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 distributionlognormal- Log-normal distributionuniform- Uniform distributionunity- Unity distribution (always returns value 1)constant- Constant distribution (returns the midpoint of Min and Max values)custom- Custom distribution defined by a separate sheetformula- 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:
- Create a separate sheet with the same name as the Impact Differentiator
- Add numerical values in the first column of the sheet
- Set Distribution to "custom" in the Impact Multipliers tab
- [Optional] Specify Min/Max values to filter the custom distribution within bounds
Example
For an impact multiplier named "CustomHedginess":
- Create a sheet named "CustomHedginess"
- Add values like:
0.1, 0.3, 0.5, 0.8, 1.2, 1.5, 2.0, 2.8, 3.0 - In the Impact Multipliers tab, set:
- Impact Differentiator: "CustomHedginess"
- 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 powerSOW ^ OC- State of World raised to Organization Characteristic powerTempModifier-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