Mastersheets

What a mastersheet is for

1. The Markets page holds signed-off final history through 2026 (green) and projections from 2027 onward (blue).
2. Click Save as mastersheet to capture a dated review snapshot for one market or all visible markets. It is separate from the live market view.
3. Open a mastersheet to see its tables. Every value is editable from 2027 onward. Signed-off years through 2026 remain locked and cannot be changed by a new scrape. For full Excel-like editing, switch to Spreadsheet mode: one tab per market where you can type formulas (=B2*1.05, =SUM(B2:B9), even across tabs), insert or delete rows and columns, copy/paste and fill down — then Save as final writes your results back into the mastersheet. Your changes turn amber and only affect this mastersheet, never the live data or signed-off history.
4. Inside an opened mastersheet, click Scraped tables next to a market name. The raw source tables open below the grid. You can edit them, or use Paste tables from a workbook to add tables copied from Excel. All edits are saved to this mastersheet only. Newly scraped tables stay in this review area until someone deliberately applies them; they never silently replace the snapshot.
5. After editing raw tables, click Apply changes to recalculate the grid above. Use Compare with live data to see what changed since you saved, and Excel to download the final workbook.