Median deworming country calculation

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R
1	Organization	Geographic area	Country	Present value of lifetime benefits from a year of deworming (in terms of increases in ln(consumption)), after replicability and other adjustments	Worm intensity adjustment	Proportion of deworming going to children	Present value of lifetime benefits from a year of deworming (in terms of increases in ln(consumption))	Total downside adjustment factor	Adjustments for excluded effects that impact future income	Adjusted present value of lifetime benefits from a year of deworming (in terms of increases in ln(consumption))	Median per capita consumption per month, in 2011 PPP	Median per capita consumption per year, in 2011 PPP	Present value of additional consumption from a year of deworming, 2011 PPP	Cost per person dewormed per year	Total spending on deworming for this analysis	Number of person-years of deworming	Multiplier for resource sharing within housholds	Present value of cumulative additional consumption per capita from total spending on deworming for this analysis, 2011 PPP

2	Deworm the World	Bihar	India	0.07	16.3%	100%	0.012	92%	-13.5%	0.010	$92.53	$1,110	$10.79	$0.34	$100	294	2	$6,340
3	Deworm the World	Rajasthan	India	0.07	2.6%	100%	0.002	92%	-13.5%	0.002	$92.53	$1,110	$1.71	$0.32	$100	312	2	$1,069
4	Deworm the World	Madhya Pradesh	India	0.07	2.6%	100%	0.002	92%	-13.5%	0.002	$92.53	$1,110	$1.71	$0.36	$100	280	2	$960
5	Deworm the World	-	Kenya	0.07	18.8%	100%	0.014	92%	-13.5%	0.011	$73.24	$879	$9.86	$0.66	$100	151	2	$2,971
6	Deworm the World	Uttar Pradesh	India	0.07	18.8%	100%	0.014	92%	-13.5%	0.011	$92.53	$1,110	$12.46	$0.37	$100	268	2	$6,678
7	Deworm the World	Chhattisgarh	India	0.07	18.8%	100%	0.014	92%	-13.5%	0.011	$92.53	$1,110	$12.46	$0.41	$100	247	2	$6,147
8	Deworm the World	-	Pakistan	0.07	9.8%	100%	0.007	92%	-13.5%	0.006	$116.96	$1,404	$8.19	$0.98	$100	102	2	$1,670
9	Deworm the World	Haryana	India	0.07	9.9%	100%	0.007	92%	-13.5%	0.006	$92.53	$1,110	$6.54	$0.37	$100	269	2	$3,525
10	Deworm the World	Karnataka	India	0.07	9.9%	100%	0.007	92%	-13.5%	0.006	$92.53	$1,110	$6.54	$0.33	$100	302	2	$3,949
11	Deworm the World	Uttarakhand	India	0.07	9.9%	100%	0.007	92%	-13.5%	0.006	$92.53	$1,110	$6.54	$0.37	$100	269	2	$3,525
12	Deworm the World	Lagos	Nigeria	0.07	5.3%	100%	0.004	92%	-13.5%	0.003	$54.10	$649	$2.04	$0.98	$100	102	2	$417
13	Deworm the World	Oyo	Nigeria	0.07	8.2%	100%	0.006	92%	-13.5%	0.005	$54.10	$649	$3.17	$1.03	$100	97	2	$613
14	Deworm the World	Ogun	Nigeria	0.07	12.6%	100%	0.009	92%	-13.5%	0.007	$54.10	$649	$4.87	$2.03	$100	49	2	$479
15	Deworm the World	Cross River	Nigeria	0.07	8.4%	100%	0.006	92%	-13.5%	0.005	$54.10	$649	$3.24	$1.16	$100	87	2	$562
16	Deworm the World	Rivers	Nigeria	0.07	7.2%	100%	0.005	92%	-13.5%	0.004	$54.10	$649	$2.78	$0.69	$100	145	2	$805
17	SCI Foundation	-	Ethiopia	0.07	5.2%	73%	0.003	85%	-13.5%	0.002	$77.48	$930	$1.93	$0.99	$100	101	2	$391
18	SCI Foundation	-	Malawi	0.07	2.6%	65%	0.001	85%	-13.5%	0.001	$40.70	$488	$0.46	$0.99	$100	101	2	$92
19	SCI Foundation	-	Mozambique	0.07	4.9%	100%	0.004	85%	-13.5%	0.003	$45.01	$540	$1.45	$0.99	$100	101	2	$294
20	SCI Foundation	-	Congo, Dem. Rep.	0.07	18.8%	94%	0.013	85%	-13.5%	0.010	$33.48	$402	$3.90	$0.99	$100	101	2	$789
21	SCI Foundation	-	Madagascar	0.07	9.5%	100%	0.007	85%	-13.5%	0.005	$33.01	$396	$2.07	$0.99	$100	101	2	$418
22	SCI Foundation	-	Tanzania	0.07	13.8%	91%	0.009	85%	-13.5%	0.007	$58.82	$706	$4.87	$0.99	$100	101	2	$985
23	SCI Foundation	-	Cote d'Ivoire	0.07	14.2%	100%	0.011	85%	-13.5%	0.008	$84.72	$1,017	$7.95	$0.99	$100	101	2	$1,607
24	SCI Foundation	-	Zambia	0.07	6.5%	91%	0.004	85%	-13.5%	0.003	$47.38	$569	$1.85	$0.99	$100	101	2	$375
25	SCI Foundation	-	Liberia	0.07	8.7%	71%	0.005	85%	-13.5%	0.003	$66.20	$794	$2.68	$0.99	$100	101	2	$542
26	Sightsavers	-	Guinea	0.07	10.6%	100%	0.008	78%	-13.5%	0.005	$71.01	$852	$4.56	$2.82	$100	36	2	$324
27	Sightsavers	-	Congo, Dem. Rep.	0.07	18.8%	100%	0.014	78%	-13.5%	0.009	$33.48	$402	$3.82	$0.59	$100	169	2	$1,290
28	Sightsavers	-	Guinea-Bissau	0.07	2.6%	100%	0.002	78%	-13.5%	0.001	$42.20	$506	$0.66	$3.19	$100	31	2	$42
29	Sightsavers	-	Cameroon	0.07	12.3%	100%	0.009	78%	-13.5%	0.006	$109.29	$1,311	$8.16	$0.62	$100	161	2	$2,629
30	Sightsavers	Bauchi	Nigeria	0.07	5.5%	100%	0.004	78%	-13.5%	0.003	$54.10	$649	$1.80	$0.73	$100	136	2	$490
31	Sightsavers	Benue	Nigeria	0.07	7.0%	100%	0.005	78%	-13.5%	0.004	$54.10	$649	$2.29	$1.21	$100	83	2	$379
32	Sightsavers	Kebbi	Nigeria	0.07	7.2%	100%	0.005	78%	-13.5%	0.004	$54.10	$649	$2.36	$0.64	$100	155	2	$732
33	Sightsavers	Kogi	Nigeria	0.07	6.0%	100%	0.004	78%	-13.5%	0.003	$54.10	$649	$1.96	$0.64	$100	155	2	$610
34	Sightsavers	Kwara	Nigeria	0.07	9.8%	100%	0.007	78%	-13.5%	0.005	$54.10	$649	$3.21	$0.64	$100	155	2	$997
35	Sightsavers	Sokoto	Nigeria	0.07	6.6%	100%	0.005	78%	-13.5%	0.003	$54.10	$649	$2.16	$0.64	$100	155	2	$671
36	Sightsavers	Yobe	Nigeria	0.07	5.6%	100%	0.004	78%	-13.5%	0.003	$54.10	$649	$1.83	$0.84	$100	119	2	$436
37	The END Fund	-	Ethiopia	0.07	2.8%	85%	0.002	83%	-13.5%	0.001	$77.48	$930	$1.17	$0.81	$100	124	2	$291
38	The END Fund	-	Angola	0.07	9.0%	85%	0.006	83%	-13.5%	0.004	$60.80	$730	$3.01	$0.81	$100	124	2	$748
39	The END Fund	-	Congo, Dem. Rep.	0.07	8.0%	85%	0.005	83%	-13.5%	0.004	$33.48	$402	$1.47	$0.81	$100	124	2	$364
40	The END Fund	-	Rwanda	0.07	8.3%	85%	0.005	83%	-13.5%	0.004	$52.76	$633	$2.41	$0.81	$100	124	2	$598
41	The END Fund	-	Zimbabwe	0.07	5.7%	85%	0.004	83%	-13.5%	0.003	$77.60	$931	$2.40	$0.81	$100	124	2	$597
42	Median											$649		$0.81				$642
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