Spreadsheets that do the maths for you.
Fill in the yellow cells. The formulas are already built, tested and explained.
How every template works
Yellow cells are yours. Dates, names, numbers: anything you type goes here.
White cells calculate. Totals, rates and statuses update as you type. Leave them alone.
Grey rows are examples. They show the format. Overwrite them when you start.
Every file opens in Excel 2016 or newer, Excel for the web and Google Sheets. No macros, no add-ons, no account. A "Start here" tab explains the file in one page.
Guides
- How to calculate engagement rate, and which version to use
The three common engagement rate formulas, when each one is the right choice, and how to work them out in Excel or Google Sheets without the averaging mistake most reports make.
- Influencer campaign ROI: CPM, cost per click, cost per sale and ROAS explained
The five numbers that tell you whether a creator was worth the money, how to calculate each one in a spreadsheet, and how to count costs and sales honestly.
- How to track unpaid invoices as a freelancer, in one spreadsheet
Set up due dates, an automatic overdue status, days overdue and an ageing summary in Excel or Google Sheets, plus a simple schedule for chasing late payers.