Skip to content

Characteristics - fos

This sheet defines opportunity-specific values for each impact multiplier.

Accepted Structure

Example:

Impact Differentiator Variable Type SD CoV OrgA OrgA_StDev OrgB OrgB_SD
Hedginess Unbounded 0.15 0.8 0.12 0.6
FundingAdditionality Proportion 0.30 0.3 0.2
PolicySignal Indicator 1

Recognised columns:

Column Required Meaning
Impact Differentiator Yes Must match a multiplier name after normalisation.
Variable Type No Metadata column used for validation and downstream interpretation.
SD No Default standard deviation for the row.
CoV No Default coefficient of variation for the row.
OrgName No Mean value for an opportunity.
OrgName_StDev or OrgName_SD No Standard deviation for that opportunity and multiplier.

Everything after the metadata columns is interpreted as opportunity-specific data. The parser recognises standard-deviation columns by the suffix _StDev or _SD.

Variable Types

The parser currently expects these common labels:

  • Indicator
  • Proportion
  • Unbounded

The current implementation does not coerce values based on these labels except for indicator-specific validation and missing-value handling.

Defaults And Inference

For each opportunity and multiplier:

  • If a mean exists and an opportunity-specific standard deviation is present, that value is used.
  • If a mean exists, the opportunity-specific standard deviation is missing, and row-level SD is present, the parser uses SD.
  • If a mean exists, SD is missing, and row-level CoV is present, the parser uses CoV * Mean.
  • If a mean exists and neither SD nor CoV can supply a standard deviation, the parser records an error.

Other parser behaviours:

  • Entire opportunity columns that are all NA are dropped.
  • Spaces and dots are removed from both opportunity names and multiplier names for matching.
  • Missing opportunity-by-multiplier combinations are completed later so that every opportunity has every multiplier, with NA values where data is absent.

Validation Behaviour

The current parser checks:

  • Indicator means must be 0, 1, or NA.
  • If Indicator mean is exactly 0, the parser currently converts it to NA.
  • If both mean and standard deviation exist, and the implied StDev / Mean differs a lot from the row-level CoV, a warning is emitted.
  • Rows for multipliers that do not exist after multiplier processing are removed later with a warning.

Notes For Agents

  • The fos sheet can reference formula-generated multipliers. If a formula-defined multiplier is used here, the engine may add it to the multiplier table automatically.
  • The parser does not require opportunities to appear in a fixed order, but later initialisation keeps only opportunities that exist in both fos and orgmeta.
  • The app preview renders this sheet as Mean [StDev] per opportunity after defaults and imputations have already been applied.