ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
INSTRUCTIONS
2
How to use this doc (quick start)Status for this model
3
0. InstructionsOverview of how to use the model, what each tab contains, and the main comparable impact units used in CEAs. This tab is the starting point for users and provides the key guidance needed to navigate the workbook correctly.✅ Active
4
1. Model MetadataSingle reference tab identifying the intervention, organization, country, impact unit, and primary evidence source — fill this first; all other tabs pull from here automatically.✅ Active
5
2. CEA resultsAll aggregated outputs from the model by year, including key assumptions, total project costs, cost per beneficiary, effective beneficiaries, UNIT per beneficiary, total UNITs, cost per UNIT, and UNITs per 1,000 USD. This tab summarizes results for both direct implementation and the endgame-at-scale phase.✅ Active
6
3. Key AssumptionsMain reach and scale assumptions used to estimate the number of beneficiaries reached and effective beneficiaries by year. This tab includes both the direct implementation phase and the endgame-at-scale phase, and defines the operational assumptions that feed into the cost and impact calculations.✅ Active
7
4. Intervention costsDetailed cost calculations for the intervention, including cost per beneficiary and total project costs. This tab covers both the direct implementation phase and the projected scale phase (separating costs for the meta-organization, other implementing actors, and total costs at scale). All costs are in USD.✅ Active
8
5. Organizations costsDetailed annual budget inputs for the organization, including both the direct implementation phase and the meta-organization phase at scale. This tab breaks down costs by category and line item, and serves as the main source for the cost calculations summarized in the intervention costs and CEA results tabs. All costs are in USD. (Hidden) - if you are a funder and would like to have the complete budget, please contact the founders and it will be provided.✅ Active
9
6. Evidence LibraryRepository of the external and internal studies used to parameterize intervention effects. This tab records key information from RCTs, meta-analyses, and other evidence sources, including study design, sample sizes, and source links.✅ Active
10
7. Effects Measurement PlanPlanning tool for data collection - defines indicators before launch. This tab defines the indicators, instruments, collection methods, timing, and data quality considerations needed to generate the internal evidence that will later feed into the effect and impact calculations.✅ Active — planning mode
11
8. Effects ConversionConverts operational outcome metrics into standardized effect sizes that can be used consistently across studies and evidence sources. This tab links the organization’s measured outcomes with external or internal evidence and applies the formulas needed to translate results (e.g., PHQ, GAD, test scores, income changes) into a common standardized effect metric for the next stage of the CEA.⚠ Simplified — direct d available
12
9. Effects Impact - UNITConverts standardized effects into the final comparable impact unit used in the CEA. This tab applies the relevant conversion logic, assumptions, and adjustment factors to estimate impact per beneficiary in a common unit that can be aggregated and linked to costs in the CEA results tab.✅ Active — core calculation
13
10. GDP p/capitaReference table with GDP per capita by country and region, used to compare the original study context with the intervention context and approximate cost variation across countries. Also to calculate WHO thresholds for cost effectiveness. This tab supports cost localization in the CEA results and the organizational costs tab.✅ Active
14
15
16
COLOR CODING LEGEND
17
Text colorMeaning
18
Black textHardcoded inputs — values you set and can change
19
Blue textFormulas — calculated automatically, do not edit
20
Green textCross-sheet links — pulling from another tab
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100