| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | ||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | Against Malaria Foundation | |||||||||||||||||
2 | Chad | DRC | Guinea | Nigeria | Nigeria | South Sudan | Togo | Uganda | ||||||||||
3 | Supplemental calculations for effective coverage years provided per net | unit | type | Overall | GF states | PMI states | ||||||||||||
4 | Final cost-effectiveness estimate (pulled from "Main calcs" sheet for visibility) | xbenchmark | main | - | 4.8 | 14.6 | 22.8 | 16.8 | 13.3 | 7.2 | 8.8 | 15.6 | ||||||
5 | Net survival | |||||||||||||||||
6 | ||||||||||||||||||
7 | Net coverage years lost to attrition | |||||||||||||||||
8 | Percentage of nets remaining in use two years after the CTN distributions in trials from the Pryce et al. 2018 meta-analysis | % | input | 100% | - | - | - | - | - | - | - | - | ||||||
9 | Average percentage of nets remaining in use during the 1st year after an ITN distribution | % | input | 95% | - | - | - | - | - | - | - | - | ||||||
10 | Average percentage of nets remaining in use during the 2nd year after an ITN distribution | % | input | 83% | - | - | - | - | - | - | - | - | ||||||
11 | Average percentage of nets remaining in use during the 3rd year after an ITN distribution | % | input | 69% | - | - | - | - | - | - | - | - | ||||||
12 | ||||||||||||||||||
13 | Net coverage years lost due to physical decay | |||||||||||||||||
14 | Percentage of remaining nets lost due to physical damage at the midpoint of the 1st year after an ITN distribution | % | input | 3% | - | - | - | - | - | - | - | - | ||||||
15 | Percentage of remaining nets lost due to physical damage at the midpoint of the 2nd year after an ITN distribution | % | input | 15% | - | - | - | - | - | - | - | - | ||||||
16 | Percentage of remaining nets lost due to physical damage at the midpoint of the 3rd year after an ITN distribution | % | input | 35% | - | - | - | - | - | - | - | - | ||||||
17 | Ratio of physical net decay in trials of CTN distributions from the Pryce et al. 2018 meta-analysis compared to physical net decay from grantee ITN distributions | % | input | 33% | - | - | - | - | - | - | - | - | ||||||
18 | Percentage of remaining nets lost due to physical damage at the midpoint of the 1st year after a CTN distribution from the Pryce et al. 2018 meta-analysis | % | calc | 2% | - | - | - | - | - | - | - | - | ||||||
19 | Percentage of remaining nets lost due to physical damage at the midpoint of the 2nd year after a CTN distribution from the Pryce et al. 2018 meta-analysis | % | calc | 10% | - | - | - | - | - | - | - | - | ||||||
20 | Average percentage of remaining nets lost due to physical damage over the two-year period following a CTN distribution from the Pryce et al. 2018 meta-analysis | % | calc | 6% | - | - | - | - | - | - | - | - | ||||||
21 | ||||||||||||||||||
22 | Net coverage years lost due to insecticide decay | |||||||||||||||||
23 | Proportion of net coverage lost due to insecticide decay for CTNs distributed in trials from the Pryce et al. 2018 meta-analysis | % | input | 0% | - | - | - | - | - | - | - | - | ||||||
24 | Proportion of net coverage lost due to insecticide decay for ITNs distributed in grantee distributions | % | input | 0% | - | - | - | - | - | - | - | - | ||||||
25 | ||||||||||||||||||
26 | Total net coverage years lost | |||||||||||||||||
27 | Coverage years lost per year for CTNs distributed in trials from the Pryce et al. 2018 meta-analysis | # | calc | 0.06 | - | - | - | - | - | - | - | - | ||||||
28 | Coverage years lost during the 1st year after a grantee ITN distribution | # | calc | 0.08 | - | - | - | - | - | - | - | - | ||||||
29 | Coverage years lost during the 2nd year after a grantee ITN distribution | # | calc | 0.29 | - | - | - | - | - | - | - | - | ||||||
30 | Coverage years lost during the 3rd year after a grantee ITN distribution | # | calc | 0.55 | - | - | - | - | - | - | - | - | ||||||
31 | ||||||||||||||||||
32 | Trial-equivalent coverage years provided per distributed net | |||||||||||||||||
33 | Effective net coverage years provided by a CTN distributed in a trial from the Pryce et al. 2018 meta-analysis (reference value) | # | input | 1.00 | - | - | - | - | - | - | - | - | ||||||
34 | Effective coverage years provided per net in the 1st year after a grantee ITN distribution | # | calc | 0.98 | - | - | - | - | - | - | - | - | ||||||
35 | Effective coverage years provided per net in the 2nd year after a grantee ITN distribution | # | calc | 0.77 | - | - | - | - | - | - | - | - | ||||||
36 | Effective coverage years provided per net in the 3rd year after a grantee ITN distribution | # | calc | 0.52 | - | - | - | - | - | - | - | - | ||||||
37 | Total effective coverage years provided per net over the three-year period following a grantee ITN distribution for reference ITNs | # | calc | 2.27 | - | - | - | - | - | - | - | - | ||||||
38 | ||||||||||||||||||
39 | Adjustment for generic ITNs | |||||||||||||||||
40 | Total effective coverage years provided per net over the three-year period following a grantee ITN distribution of reference ITNs | # | calc | 2.27 | - | - | - | - | - | - | - | - | ||||||
41 | Adjustment for reduced net coverage provided by generic ITNs | % | input | -15% | - | - | - | - | - | - | - | - | ||||||
42 | Total effective coverage years provided per net over the three-year period following a grantee ITN distribution for generic ITNs | # | calc | 1.93 | - | - | - | - | - | - | - | - | ||||||
43 | ||||||||||||||||||
44 | Breakdown of net types purchased for distributions | |||||||||||||||||
45 | Expected proportion of ITNs purchased that are generic ITNs | % | input | 47% | - | - | - | - | - | - | - | - | ||||||
46 | ||||||||||||||||||
47 | Effective coverage years per net, incorporating generic ITNs | |||||||||||||||||
48 | Overall effective coverage years provided per net over the three-year period following a grantee ITN distribution, before adjusting for lower net durability in DRC | # | calc | 2.11 | - | - | - | - | - | - | - | - | ||||||
49 | ||||||||||||||||||
50 | Adjustment for lower net durability in DRC | |||||||||||||||||
51 | Adjustment for lower net durability in DRC than in other countries | % | input | - | - | -17% | - | - | - | - | - | - | ||||||
52 | Overall effective coverage years provided per net over the three-year period following a grantee ITN distribution, after adjusting for lower net durability in DRC | # | calc | - | 2.11 | 1.75 | 2.11 | 2.11 | 2.11 | 2.11 | 2.11 | 2.11 | ||||||
53 | ||||||||||||||||||
54 | Net decay rates | |||||||||||||||||
55 | ||||||||||||||||||
56 | Extrapolated net decay rate over a six-year period | |||||||||||||||||
57 | Effective coverage years provided per net in the 1st year after a grantee ITN distribution | # | feed | 0.98 | - | - | - | - | - | - | - | - | ||||||
58 | Effective coverage years provided per net in the 2nd year after a grantee ITN distribution | # | feed | 0.77 | - | - | - | - | - | - | - | - | ||||||
59 | Effective coverage years provided per net in the 3rd year after a grantee ITN distribution | # | feed | 0.52 | - | - | - | - | - | - | - | - | ||||||
60 | Effective coverage years provided per net in the 4th year after a grantee ITN distribution | # | input | 0.22 | - | - | - | - | - | - | - | - | ||||||
61 | Effective coverage years provided per net in the 5th year after a grantee ITN distribution | # | input | 0.07 | - | - | - | - | - | - | - | - | ||||||
62 | Effective coverage years provided per net in the 6th year after a grantee ITN distribution | # | input | 0.01 | - | - | - | - | - | - | - | - | ||||||
63 | ||||||||||||||||||
64 | Extrapolated net decay rate, adjusted for the inclusion of generic ITNs | |||||||||||||||||
65 | Overall adjustment for reduced net coverage provided by generic ITNs | % | calc | -7% | - | - | - | - | - | - | - | - | ||||||
66 | Adjusted effective coverage years provided per net in the 1st year after a grantee ITN distribution | # | calc | 0.92 | - | - | - | - | - | - | - | - | ||||||
67 | Adjusted effective coverage years provided per net in the 2nd year after a grantee ITN distribution | # | calc | 0.72 | - | - | - | - | - | - | - | - | ||||||
68 | Adjusted effective coverage years provided per net in the 3rd year after a grantee ITN distribution | # | calc | 0.48 | - | - | - | - | - | - | - | - | ||||||
69 | Adjusted effective coverage years provided per net in the 4th year after a grantee ITN distribution | # | calc | 0.20 | - | - | - | - | - | - | - | - | ||||||
70 | Adjusted effective coverage years provided per net in the 5th year after a grantee ITN distribution | # | calc | 0.06 | - | - | - | - | - | - | - | - | ||||||
71 | Adjusted effective coverage years provided per net in the 6th year after a grantee ITN distribution | # | calc | 0.01 | - | - | - | - | - | - | - | - | ||||||
72 | ||||||||||||||||||
73 | Adjusted net decay rate adjusted for lower net durability in DRC | |||||||||||||||||
74 | Adjustment for lower effective coverage years provided in the 1st year after a grantee ITN distribution in DRC | % | input | - | - | -12% | - | - | - | - | - | - | ||||||
75 | Adjustment for lower effective coverage years provided in the 2nd year after a grantee ITN distribution in DRC | % | input | - | - | -16% | - | - | - | - | - | - | ||||||
76 | Adjustment for lower effective coverage years provided in the 3rd year after a grantee ITN distribution in DRC | % | input | - | - | -32% | - | - | - | - | - | - | ||||||
77 | Adjustment for lower effective coverage years provided in the 4th year after a grantee ITN distribution in DRC | % | calc | - | - | -65% | - | - | - | - | - | - | ||||||
78 | Adjustment for lower effective coverage years provided in the 5th year after a grantee ITN distribution in DRC | % | calc | - | - | -100% | - | - | - | - | - | - | ||||||
79 | Adjustment for lower effective coverage years provided in the 6th year after a grantee ITN distribution in DRC | % | calc | - | - | -100% | - | - | - | - | - | - | ||||||
80 | ||||||||||||||||||
81 | Final extrapolated net decay rate, after all adjustments | |||||||||||||||||
82 | Final effective coverage years provided per net in the 1st year after a grantee ITN distribution | # | calc | - | 0.92 | 0.81 | 0.92 | 0.92 | 0.92 | 0.92 | 0.92 | 0.92 | ||||||
83 | Final effective coverage years provided per net in the 2nd year after a grantee ITN distribution | # | calc | - | 0.72 | 0.60 | 0.72 | 0.72 | 0.72 | 0.72 | 0.72 | 0.72 | ||||||
84 | Final effective coverage years provided per net in the 3rd year after a grantee ITN distribution | # | calc | - | 0.48 | 0.32 | 0.48 | 0.48 | 0.48 | 0.48 | 0.48 | 0.48 | ||||||
85 | Final effective coverage years provided per net in the 4th year after a grantee ITN distribution | # | calc | - | 0.20 | 0.07 | 0.20 | 0.20 | 0.20 | 0.20 | 0.20 | 0.20 | ||||||
86 | Final effective coverage years provided per net in the 5th year after a grantee ITN distribution | # | calc | - | 0.06 | 0.00 | 0.06 | 0.06 | 0.06 | 0.06 | 0.06 | 0.06 | ||||||
87 | Final effective coverage years provided per net in the 6th year after a grantee ITN distribution | # | calc | - | 0.01 | 0.00 | 0.01 | 0.01 | 0.01 | 0.01 | 0.01 | 0.01 | ||||||
88 | ||||||||||||||||||
89 | Changes in net distribution intervals | |||||||||||||||||
90 | ||||||||||||||||||
91 | Time intervals between distributions in different scenarios | |||||||||||||||||
92 | Standard number of months between ITN distributions as modeled in this CEA | # | input | 36 | - | - | - | - | - | - | - | - | ||||||
93 | Expected number of months between the previous net distribution and the upcoming distribution in the absence of a grant | # | input | - | - | 42 | - | - | 45 | 45 | - | - | ||||||
94 | Expected number of months between the previous net distribution and the upcoming distribution if a grant is made | # | input | - | - | 33 | - | - | 36 | 35 | - | - | ||||||
95 | Expected reduction in number of months between the previous net distribution and the upcoming distribution if a grant is made | # | calc | - | - | 9 | - | - | 9 | 10 | - | - | ||||||
96 | ||||||||||||||||||
97 | Costs per distributed net per year for different distribution intervals | |||||||||||||||||
98 | Total cost per insecticide-treated net (ITN) distributed | $ | input | - | - | $5.85 | - | - | $4.34 | $5.33 | - | - | ||||||
99 | Cost per net distributed per year for a standard 36-month distribution interval | $ | calc | - | - | $1.95 | - | - | $1.45 | $1.78 | - | - | ||||||
100 | Cost per net distributed per year in the absence of a grant | $ | calc | - | - | $1.67 | - | - | $1.16 | $1.42 | - | - | ||||||