Skip to content

Impact Multipliers - imp

Example Data

Impact Differentiator Min Max Distribution Weight Type
Hedginess 0.1 3.0 lognormal OC ^ SOW
Neglectedness 0.2 2.5 lognormal OC ^ SOW
OrgStrength 0.5 2.0 normal OC ^ SOW
ActivityAdditionality 0.3 1.8 uniform OC ^ SOW
FundingAdditionality 0.4 2.2 lognormal OC x SOW
Policy Additionality 0.6 1.9 normal OC x SOW
ATMGrantDelay 0.8 1.2 normal TempModifier-Compounded

Column Descriptions

Column Type Description Example Values
Impact Differentiator Text Name of the impact multiplier "Hedginess", "Neglectedness", "OrgStrength"
Min Number Minimum value across all simulations 0.1, 0.2, 0.5
Max Number Maximum value across all simulations 1.2, 2.0, 3.0
Distribution Text Statistical distribution for sampling "normal", "lognormal", "uniform", "unity", "constant" or "custom"
Weight Type Text Mathematical operation type "OC ^ SOW", "OC x SOW", "TempModifier-Compounded"

Distribution Types

The statistical distribution type for sampling values:

  • normal - Normal distribution
  • lognormal - Log-normal distribution
  • uniform - Uniform distribution
  • unity - Unity distribution (always returns value 1)
  • constant - Constant distribution (returns the midpoint of Min and Max values)
  • custom - Custom distribution defined by a separate sheet
  • formula - Formula-based distribution. See Formulas for details

Unity and Constant Distributions

Unity Distribution

  • Value: Always returns 1
  • Use case: When you want a multiplier that has no effect (multiplicative identity)
  • Min/Max: Ignored for unity distribution

Constant Distribution

  • Value: Returns the midpoint of Min and Max values
  • Use case: When you want a fixed multiplier value
  • Min/Max: Used to determine the constant value as (Min + Max) / 2

Custom Distributions

Custom distributions allow you to define empirical distributions based on your own data. To use a custom distribution:

  1. Create a separate sheet with the same name as the Impact Differentiator
  2. Add numerical values in the first column of the sheet
  3. Set Distribution to "custom" in the Impact Multipliers tab
  4. [Optional] Specify Min/Max values to filter the custom distribution within bounds

Example

For an impact multiplier named "CustomHedginess":

  1. Create a sheet named "CustomHedginess"
  2. Add values like: 0.1, 0.3, 0.5, 0.8, 1.2, 1.5, 2.0, 2.8, 3.0
  3. In the Impact Multipliers tab, set:
  4. Impact Differentiator: "CustomHedginess"
  5. Distribution: "custom"

The model will: - Sample from the empirical quantiles of your custom values - If specified, apply Min/Max filtering to keep values within bounds

Notes

  • Values outside Min/Max bounds are automatically filtered out
  • Custom distributions work with the correlation matrix to maintain statistical relationships

Weight Types

The type of multiplier operation:

  • SOW x OC - Multiplies State of World (SOW) with Organization Characteristic (OC)
  • OC ^ SOW - Organization Characteristic raised to State of World power
  • SOW ^ OC - State of World raised to Organization Characteristic power
  • TempModifier-Compounded - Temporal modifier applied across multiple years, becoming a multiplier with a value of \(\text{TempModifier}^{(year-1)}\). For example, a temporal modifier of 0.9 corresponds to a 10% yearly discount.
  • TempModifier-SingleYear - Temporal modifier applied to single year