ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
INSTRUCTIONS: Enter inputs only in the light blue cells. Start with the MAIN tab and enter in program details (name, location, start year, base year, duration) at the top. Then proceed to Tabs 1 through 5 and enter information in the light blue cells. After completing Tabs 1 through 5, return to the MAIN tab to see the results.

To fill in this worksheet, you will need the following information:
2
3
SheetDataSourceNotes
4
MAINProgram location, start year, and durationProgram records
5
Base year for currency values--Typically the same year as the program start year.
6
1_Participant_InputsTypes of program participants
Number of participants
Program recordsParticipants include both beneficiaries and other participants
7
Average age of program beneficiaries at the time of program implementationProgram recordsNecessary for program beneficiaries, but not for non-beneficiary participants
8
Time lost for each participant typeProgram recordsLost time captures the opportunity cost of participation, such as time spent in training, sessions, or program activities.
9
2_Costed Work PlanProgram expensesProgram budget data, such as a costed work planProgram expenses are those that are directly incurred to implement the program and deliver its intended services or activities. These are the resources that drive the outcomes being measured.
10
3_SocialEnvironmental externalities, quantified (includes tonnes of CO2 emissions, m3 of water consumption, and hectares of forest land)Calculate based on program records and conversion factors available onlineIf unknown, can leave blank.
11
4_BenefitsImpact estimatesImpact estimates from a randomized controlled trial (RCT) or quasi-experimental design are preferable, if available. If not, source comparable estimates from existing literatureIf project generates benefits at the intensive margin, impact estimates should be an average treatment effect, typically in SD. If at the extensive margin, estimates should be a change in the number of beneficiaries, or DALYs averted (for health).
12
5_Model_InputsLabor force entry and exit ageCountry estimatesUsed to calculate benefits
13
14
15
16
17
18
19
20
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