Excel or Google Sheets formulas, VBA, Apps Script

Formulas that calculate what you need, a VBA macro or a Google Apps Script that automates the boring part. You get the working file and a short note how to use it.