Task by Task · Free local practice
Save useful spreadsheet questions without saving stale business facts
Actual locally checked fictional workbook. This example runs locally; files selected here stay in browser memory.
Reuse questions, not old totals
- October known £10
- Two numeric values, one missing
- November has no records
Select the current period and retain no-records versus unavailable versus zero. The workbook's actual checks cover those boundaries.
Take the technique to your next job
Use this recurring analysis method with the freshly supplied file.
For [selected period], answer [named questions] using [definitions,
units and output grain]. Preserve valid zero and missing values.
Ask for the file, period and changed definitions if absent. Do not reuse
previous dates, totals or source facts. Show source coverage, actual
calculations and a small check case. Keep unavailable results explicit
rather than filling them with a plausible zero or last run's answer.