Spreadsheets Where the Formulas Are Real

Five .xlsx workbooks, 30 sheets, 3,530 live formula cells. Change an input and every number downstream moves — because none of them are typed in.

5 workbooks · 30 sheets · 3,530 live formulas · 30-day refund

Why Most Spreadsheet Templates Break

The numbers are typed in, not calculated

A screenshot-perfect dashboard often turns out to be hardcoded values. Change one assumption and nothing moves. Every figure here that should be derived is derived: 3,530 formula cells, counted by reading the files back with a spreadsheet library, not by eye.

No idea which cells you are supposed to touch

Input cells and formula cells are filled with different colours, and every workbook opens on an Instructions sheet that says what the workbook is for, which cells to fill, which to leave alone, and what it assumes.

It falls apart in the app you actually use

These are plain .xlsx files with no macros, so nothing gets blocked on open. The included COMPATIBILITY.md sets out what to expect in Excel, LibreOffice Calc and Google Sheets, including what changes when you upload and convert.

Open. Read the Instructions sheet. Fill the coloured cells.

Each workbook ships with sample data so every formula has something to compute on the first open. Delete the samples once you can see how the sheet behaves.

The Five Workbooks

✈

Solo Business Financial Model

523 formulas across Assumptions, Revenue, Costs, Cash Flow and Summary. Twelve months of projection with runway calculated from your own inputs rather than a fixed number.

📱

Digital Product P&L & Refund Tracker

1,094 formulas — the largest of the five. Orders, products, monthly P&L and a metrics sheet that derives refund rate, chargeback rate, processing fees and net revenue from the order log.

🚘

Freelance Invoice & Tax Set-Aside

732 formulas. An invoice ledger with AR ageing buckets and a tax set-aside sheet that computes what to move aside per payment at a rate you set, so the money is not spent before the bill arrives.

🏠

Content & SEO Tracker

844 formulas across a content log, keyword table, CTR model and monthly performance roll-up, so published work can be tied to positions and traffic rather than tracked by feel.

💼

KPI Dashboard

337 formulas pulling monthly data against targets, with variance and trend. Built on lookups so it keeps working when you add rows.

🔄

Instructions & Compatibility

Every workbook opens on its own Instructions sheet. COMPATIBILITY.md covers Excel, LibreOffice Calc and Google Sheets, including what changes on upload and conversion.

See what each workbook computes before you buy

Five workbooks, thirty sheets, 3,530 live formulas. One payment, no subscription.

Get the Pack