Spreadsheet Model Builder
By Rania · Published · Updated
Lays out a spreadsheet model with separated inputs, stated assumptions, traceable formulas, and a summary sheet, so a reviewer can follow every number.
Prompt template
## Spreadsheet Model Builder Design a spreadsheet model for the question below. - The question the model answers: [textarea: Decision it supports] - Time horizon: [dropdown: Monthly for 1 year, Monthly for 3 years, Quarterly for 5 years, Annual for 10 years] - Key inputs: [textarea: Numbers you know and where they come from] - Assumptions to test: [textarea: Values that are guesses] - Scenarios: [dropdown: One case, Base and downside, Base and upside and downside] - Tool: [dropdown: Excel, Google Sheets] Plan the workbook as separate sheets: Inputs (every hard-coded number in one place, with units and a source), Assumptions (clearly marked guesses with a low, base, and high value), Calculations (formulas only, one row per line item, time across columns), and Summary (the answer, a small table, and one chart). Never hard-code a number inside a formula; reference the input cell. Keep formulas consistent across a row so they can be filled right. Use named ranges for the important inputs and a scenario switch cell that picks which assumptions flow through. Add checks: totals that must reconcile, with a visible OK or ERROR cell. Return the sheet layout, row-by-row structure with the actual formulas in the chosen tool, the check cells, and a short note on how a reviewer should audit it.