Build The Spreadsheet Hidden Assumption Detector, a tool that helps analysts discover business assumptions embedded in spreadsheet formulas, constants, and calculations.
Allow users to upload Excel workbooks or provide a simplified spreadsheet model containing formulas, named ranges, input cells, and calculation outputs.
The tool should:
Identify hardcoded constants inside formulas and distinguish them from referenced inputs.
Find repeated thresholds, tax rates, conversion factors, growth assumptions, and date offsets.
Detect similar formulas that use different constants without an obvious explanation.
Map which outputs depend on each identified assumption.
Allow users to change an assumption and observe downstream effects in supported calculations.
Flag undocumented inputs and inconsistent units where detectable.
Generate an assumption register with cell references, current values, and affected outputs.
Create sensitivity scenarios for selected assumptions.
Export an audit report with recommended manual review items.
Include sample sales forecasts and project-budget models. Preserve the original workbook and clearly state which formula types the parser supports. Never describe an unexplained constant as an error without evidence. Build a usable interface with cell-level navigation and transparent calculation logic.
0 Comments