Problem Definition
The model is usually defined through a spreadsheet workbook. This section details the data input requirements.
Workbook Sheets
Mandatory sheets:
- Impact Multipliers -
impDefine the uncertain impact differentiators, their distributions, and how they combine with organization characteristics. - Correlation Matrix -
covDefine correlations between impact multipliers, and optionally between organization noise modifiers. - Organization Characteristics -
fosDefine how each organization scores on each impact differentiator. - Funding Parameters -
metaDefine the budget, time horizon, and optional virtual-organization settings. - Organization Funding -
orgmetaDefine room for funding, diminishing-returns parameters, year availability, and model coverage for each organization.
Optional sheets:
- Formulas -
formulasDefine derived variables using formulas instead of sampling them directly.
Optional supporting sheets:
- Custom Distributions - separate sheets referenced from
imp, not a literal tab namedcustom_distributionsProvide empirical value lists for multipliers that useDistribution = custom.
Parser Load Order
The engine initializes workbook inputs in this order:
formulasimpcovfosmetaorgmeta
This matters because later sheets can depend on information or defaults established earlier. For example:
covis filtered against the final multiplier set.orgmetausesmeta$Yearsto validateAvailable in year X.foscan reference formula-generated differentiators that are added to the multiplier table later.
How To Use These Pages
Each page in this section is written as a parser contract:
- accepted structure,
- defaults and inferred values,
- validation behavior,
- implementation details that are easy to miss when reading only the spreadsheet examples.
If you are updating example workbooks or creating agent prompts, prefer these pages over older prose descriptions.