ABCDEFGHIJKLMNOPQRSTUVWXY
1
Notes
2
3
Instructions:
4
1. Read everything on this tab
5
2. Click here to make an editable copy of this workbook
6
3. Edit the "Parameters," "Moral weights," and "[Intervention]" tabs as needed. Delete rows you don't need
7
8
Source CEA:
9
Discount rates, moral weights, and results are pulled from the URL below:
10
https://docs.google.com/spreadsheets/d/13b_qt-G_TQtoYNznNak3_5dzvzgCSUPJnk3l5dMisJo/edit#gid=1537947274
11
Please update the URL if a newer CEA is available (last updated 12/4/17)
12
13
General guidelines:
14
-Parameters with highly uncertain values that research team members are likely to disagree on should go on the "Parameters" tab. Everything else belongs on the "[Intervention]" tab
15
-Try to minimize the number of items on the "Parameters" tab
16
-Avoid hard coding values inside formulas (use multiple rows instead!)
17
-Try to make your CEA as simple as possible for an outsider to understand
18
-Use explanatory cell notes in column A liberally
19
-User-selected parameters should have a yellow background
20
-Hard coded numbers should have a white background AND a cell note explaining where the number comes from
21
-Calculations performed in the [Intervention] tab should have blue backgrounds
22
-Try to be explicit about what units that are being used
23
-When it's easy to do, use nominal USD for monetary values
24
-Generally, it should not be necessary to make any edits to the "Notes," "Results," or "Speadsheet settings" tabs in this workbook
25
-Comments in this workbook give additional guidelines
26
27
Potentially useful documents:
28
Tutorial video for the intervention template
29
CEA technincal guide (explains index match match functions, formulas for discounting, and more)
30
Other:
31
This template does not incorporate our leverage/funging framework. If you'd like to use that framework in an early-stage CEA, please reach out to the CEA owner (Chris as of 12/4/17)
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