Skip to content

Opportunity Funding - orgmeta

This sheet defines opportunity-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] Bracket decline in first bracket 0.00 0.00
Discount [2] Bracket decline in second bracket 0.10 0.15
Utility multiplier [1] Bracket factor for 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

Recognised columns:

Column Required Meaning
Variable Yes Variable family and bracket/year label.
Description No Ignored by the parser if present.
Opportunity columns Yes One column per opportunity.

Recognised Variable Families

The parser currently recognises rows whose Variable value starts with:

  • Room for funding
  • Discount
  • Utility decline
  • Utility multiplier
  • Available in year
  • Model Coverage or Model_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 modelling perspective, earlier brackets usually represent the first dollars you can grant to an opportunity, while later brackets represent additional funding after the easiest or highest-value opportunities have already been filled.

Typical interpretation:

  • earlier Room for funding brackets represent more attractive funding opportunities,
  • later brackets often have higher Discount values to reflect diminishing returns,
  • later brackets may also have lower Utility multiplier values if you want to scale down their value directly.

Defaults And Inference

The current parser fills missing information as follows:

  • Missing Available in year X entries default to 1 for every opportunity and every year from 1 to Years.
  • Missing Model Coverage defaults to 1.
  • Missing bracketed Discount values default to 0.
  • Missing bracketed Utility multiplier values default to 1.
  • Missing bracketed Room for funding values default to 0.

It also:

  • Removes opportunities whose entire funding column is empty.
  • Restores the original opportunity order after parsing.
  • Removes Available in year X rows whose year exceeds meta$Years.

Validation Behaviour

The parser and later initialisation currently perform these checks:

  • Year-availability values outside [0, 1] are corrected to 1.0 with a warning.
  • Availability rows with invalid or non-positive years are treated as errors later in validation.
  • If an opportunity has a different number of non-missing room-for-funding and bracket-decline rows, the parser records an error.
  • If both Discount and Utility multiplier are specified for the same opportunity and bracket, the engine warns and applies both.
  • Later validation warns when bracket decline values decrease across brackets for an opportunity.

Notes For Agents

  • Spaces and dots are removed from opportunity names for matching against fos.
  • Opportunities present only in orgmeta or only in fos are dropped later during initialisation.
  • Available in year X uses year 1 as the present year.
  • The app preview summarises this sheet into Room for funding, Discount, and Model Coverage, with bracketed values displayed as vectors.
  • Model Coverage is used to add post-EV noise when coverage is below 1; see Noise And Model Coverage.