ABCDEFGHIJKLMNOPQRSTUVWXY
1
2
Start here: This provides a description and summary of our work.Click Here to watch a video walk through of this spreadsheet
3
4
This spreadsheet analyzes the cost-effectiveness of distributing free ceramic water filtration devices in low-income settings (further details in the full report). The analysis focuses on two interventions, with the key distinction between these interventions is the extent of educational support:

1) Ceramic Filters with Minimal Education (tab CEA 2 - Without WASH education - (Working Model).
In addition to providing free ceramic filteres, users receive instruction on the setup, usage, and maintenance of the filters.

2) Ceramic Filters with WASH Education (tab CEA 2 - With WASH education (Working Model)
This builds on the "Minimal Education" with an expanded educational WASH package covering diverse topics like hygiene, nutrition, and family values, inspired by methodologies from related studies.

These CEAs methods attempts to more closely replicate GiveWell's Water Quality Report (GiveWell, 2022) CEA when possible (plus some external validity adjustments of our own). This represents our current best guess of the cost-effectiveness of ceramic water filters.

For each of the aformentioned CEAs, we then compared each interventions cost effectiveness with that of chlorination devices (as calculated by GiveWell), and highlighted the results in Table 2 below.

How to use:
Enter a country name below to automatically populate key data points in the analysis. This will automatically populate the final column in rows 1 and 2.
For greater insights into the CEA itself, open the corresponding tabs.
5
6
Choose a Country: Brazil
7
8
Table 1: Comparison between Cost effectiveness of Ceramic Filtration (CF) with and without comprehensive WASH education, for selected countries
9
KenyaUgandaMalawiNigeriaCurrently selected country (Brazil)
10
Without WASH education - Central scenario $67.06/DALY $53.89/DALY $62.91/DALY $8.47/DALY $391.21/DALY
11
......................................... - Best-case scenario $10.26/DALY $8.92/DALY $11.44/DALY $1.70/DALY $78.54/DALY
12
......................................... - Worst-case scenario $1,749.03/DALY $931.11/DALY $1,416.04/DALY $433.71/DALY $3,469.40/DALY
13
With WASH education $81.41/DALY $65.42/DALY $76.37/DALY $10.28/DALY $474.89/DALY
14
......................................... - Best-case scenario $15.54/DALY $13.50/DALY $17.31/DALY $2.57/DALY $118.92/DALY
15
......................................... - Worst-case scenario $1,821.66/DALY $969.78/DALY $1,474.84/DALY $451.72/DALY $3,613.46/DALY
17
18
19
Table 2: Comparison between Cost effectiveness of Ceramic Filtration (CF) vs Chlorination (In line chlorination and Dispensers for Safe Water in Kenya, Uganda, and Malawi) using the current Working Model, without comprehensive WASH education
20
CF Only KenyaCF Only UgandaCF Only MalawiCF Only NigeriaCF Only - Currently selected country (Brazil)
21
Cost Effectiveness of Ceramic Filters, no WASH education (Central scenario) $67.06/DALY $53.89/DALY $62.91/DALY $8.47/DALY $391.21/DALY
22
Cost Effectivness of Ceramic Filters (Best-case scenario) $10.26/DALY $8.92/DALY $11.44/DALY $1.70/DALY $78.54/DALY
23
Cost Effectiveness Ceramic Filters (Worst-case scenario) $1,749.03/DALY $931.11/DALY $1,416.04/DALY $433.71/DALY $3,469.40/DALY
24
Cost effectiveness of Ceramic Filters compared to Chlorination (In-line Chlorination and Dispensers for Safe Water in Kenya, Uganda, and Malawi)
- Unit: Times more cost effective than In-line Chlorination.		1.32.41.73.70.9
28
29
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
101
102
103
104
105