Organization Funding - orgmeta
This sheet defines organization-level funding constraints: room for funding, diminishing-returns parameters, year availability, and model coverage.
Accepted Structure
Example:
| Variable | Description | OrgA | OrgB |
|---|---|---|---|
| Room for funding [1] | First funding bracket | 10 | 8 |
| Room for funding [2] | Second funding bracket | 5 | 4 |
| Discount [1] | Utility decline in first bracket | 0.00 | 0.00 |
| Discount [2] | Utility decline in second bracket | 0.10 | 0.15 |
| Utility multiplier [1] | Optional multiplier on first bracket | 1.00 | 0.90 |
| Model Coverage | Fraction represented in the model | 1 | 1 |
| Available in year 1 | Availability in year 1 | 1 | 1 |
| Available in year 2 | Availability in year 2 | 1 | 0 |
Recognized columns:
| Column | Required | Meaning |
|---|---|---|
Variable |
Yes | Variable family and bracket/year label. |
Description |
No | Ignored by the parser if present. |
| Organization columns | Yes | One column per organization. |
Recognized Variable Families
The parser currently recognizes rows whose Variable value starts with:
Room for fundingDiscountUtility declineUtility multiplierAvailable in yearModel CoverageorModel_Coverage
Brackets And Row Order
Bracket numbers are assigned by row order within each variable family, not by the number shown in square brackets.
That means these two facts are both true:
- Labels like
[1],[2],[3]are helpful for humans. - The parser actually uses the order of the rows it sees after reshaping, so agents should not rely on the bracket number embedded in the label as the source of truth.
From a modeling perspective, earlier brackets usually represent the first dollars you can grant to an organization, while later brackets represent additional funding after the easiest or highest-value opportunities have already been filled.
Typical interpretation:
- earlier
Room for fundingbrackets represent more attractive funding opportunities, - later brackets often have higher
Discountvalues to reflect diminishing returns, - later brackets may also have lower
Utility multipliervalues if you want to scale down their value directly.
Defaults And Inference
The current parser fills missing information as follows:
- Missing
Available in year Xentries default to1for every organization and every year from1toYears. - Missing
Model Coveragedefaults to1. - Missing bracketed
Discountvalues default to0. - Missing bracketed
Utility multipliervalues default to1. - Missing bracketed
Room for fundingvalues default to0.
It also:
- Removes organizations whose entire funding column is empty.
- Restores the original organization order after parsing.
- Removes
Available in year Xrows whose year exceedsmeta$Years.
Validation Behavior
The parser and later initialization currently perform these checks:
- Year-availability values outside
[0, 1]are corrected to1.0with a warning. - Availability rows with invalid or non-positive years are treated as errors later in validation.
- If an organization has a different number of non-missing room-for-funding and discount rows, the parser records an error.
- If both
DiscountandUtility multiplierare specified for the same organization and bracket, the engine warns and applies both. - Later validation warns when discount values decrease across brackets for an organization.
Notes For Agents
- Spaces and dots are removed from organization names for matching against
fos. - Organizations present only in
orgmetaor only infosare dropped later during initialization. Available in year Xuses year1as the present year.- The app preview summarizes this sheet into
Room for funding,Discount, andModel Coverage, with bracketed values displayed as vectors. Model Coverageis used to add post-EV noise when coverage is below1; see Noise And Model Coverage.