| 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 the insecticide resistance adjustment | 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 | Insecticide resistance for standard nets | |||||||||||||||||
6 | ||||||||||||||||||
7 | Resistance to pyrethroid insecticides | |||||||||||||||||
8 | Average mosquito mortality rate found in pyrethroid bioassays (2015-2019) | % | input | - | 24% | 52% | 70% | 75% | 75% | 52% | 23% | 44% | ||||||
9 | Average year pyrethroid bioassays were conducted | year | input | - | 2015 | 2017 | 2017 | 2017 | 2017 | 2020 | 2015 | 2016 | ||||||
10 | Expected year of ITN distribution | year | input | - | 2026 | 2024 | 2025 | 2023 | 2023 | 2023 | 2023 | 2023 | ||||||
11 | Number of years between bioassay data collection and the expected year of ITN distribution | # | calc | - | 11 | 7 | 8 | 6 | 6 | 3 | 8 | 7 | ||||||
12 | Expected annual change in mosquito mortality rates over time | ppt | input | -0.8% | - | - | - | - | - | - | - | - | ||||||
13 | Estimated change in mosquito mortality rates between bioassay data collection and the expected year of ITN distribution | % | calc | - | -9% | -6% | -7% | -5% | -5% | -3% | -6% | -6% | ||||||
14 | Estimated mosquito mortality rate in the year of ITN distribution | % | calc | - | 14% | 46% | 63% | 70% | 70% | 49% | 17% | 38% | ||||||
15 | ||||||||||||||||||
16 | Role of insecticide in the protective effect of nets | |||||||||||||||||
17 | Proportion of the protective effect of ITNs that is due to the physical barrier of the net | % | input | 27% | - | - | - | - | - | - | - | - | ||||||
18 | Proportion of the protective effect of ITNs that is due to pyrethroid insecticide | % | calc | 73% | - | - | - | - | - | - | - | - | ||||||
19 | ||||||||||||||||||
20 | ITN effectiveness compared to trial contexts | |||||||||||||||||
21 | Effectiveness of ITNs in upcoming distributions relative to nets in studies included in Cochrane reviews | % | calc | - | 38% | 60% | 73% | 78% | 78% | 63% | 39% | 55% | ||||||
22 | Reduction in effectiveness caused by resistance to pyrethroid insecticide | % | calc | - | 62% | 40% | 27% | 22% | 22% | 37% | 61% | 45% | ||||||
23 | ||||||||||||||||||
24 | Insecticide resistance for PBO nets | |||||||||||||||||
25 | ||||||||||||||||||
26 | Resistance to pyrethroid insecticides plus a piperonyl-butoxide (PBO) synergist | |||||||||||||||||
27 | Average mosquito mortality rate found in bioassays of pyrethroid plus PBO (2015-2019) | % | input | - | 55% | 96% | 90% | 93% | 93% | 96% | 93% | 95% | ||||||
28 | Average mosquito mortality rate found in the same bioassays of pyrethroid only | % | input | - | 43% | 56% | 60% | 69% | 69% | 56% | 11% | 51% | ||||||
29 | Initial proportion of resistance that remains when using PBO | % | calc | - | 80% | 9% | 26% | 24% | 24% | 10% | 8% | 9% | ||||||
30 | Reduction in effectiveness due to insecticide resistance in areas where PBO nets are effective | % | calc | - | 50% | 4% | 7% | 5% | 5% | 4% | 5% | 4% | ||||||
31 | ||||||||||||||||||
32 | External validity adjustments for country representativeness | |||||||||||||||||
33 | Proportion of bioassay test sites with confirmed pyrethroid insecticide resistance (2015-2019) | % | input | - | 100% | 81% | 76% | 62% | 62% | 89% | 100% | 99% | ||||||
34 | Proportion of test sites detected to have relevant resistance mechanism (2015-2019) | % | input | - | 71% | 100% | 79% | 79% | 79% | 92% | 79% | 83% | ||||||
35 | Estimated proportion of country where PBO nets are more effective than standard ITNs | % | calc | - | 71% | 81% | 61% | 49% | 49% | 81% | 79% | 82% | ||||||
36 | ||||||||||||||||||
37 | Insecticide resistance for Dual AI nets | |||||||||||||||||
38 | ||||||||||||||||||
39 | Resistance to insecticides used in Dual AI nets | |||||||||||||||||
40 | Reduction in effectiveness due to insecticide resistance with chlorfenapyr nets | % | input | 0% | - | - | - | - | - | - | - | - | ||||||
41 | Reduction in effectiveness due to insecticide resistance with other Dual AI nets | % | calc | - | 62% | 40% | 27% | 22% | 22% | 37% | 61% | 45% | ||||||
42 | ||||||||||||||||||
43 | Insecticide resistance adjustment | |||||||||||||||||
44 | ||||||||||||||||||
45 | Breakdown of nets purchased | |||||||||||||||||
46 | Expected proportion of standard ITNs purchased for distributions | % | input | - | 70% | 0% | 70% | 0% | 0% | 81% | 50% | 0% | ||||||
47 | Expected proportion of PBO nets purchased for distributions | % | input | - | 30% | 50% | 30% | 100% | 100% | 19% | 50% | 100% | ||||||
48 | Expected proportion of chlorfenapyr nets purchased for distributions | % | input | - | 0% | 45% | 0% | 0% | 0% | 0% | 0% | 0% | ||||||
49 | Expected proportion of other Dual AI nets purchased for distributions | % | input | - | 0% | 5% | 0% | 0% | 0% | 0% | 0% | 0% | ||||||
50 | ||||||||||||||||||
51 | Final net breakdown | |||||||||||||||||
52 | Proportion of nets that are standard nets | % | calc | - | 70% | 0% | 70% | 0% | 0% | 81% | 50% | 0% | ||||||
53 | Proportion of nets that are PBO nets distributed to areas where PBO nets are effective | % | calc | - | 30% | 50% | 30% | 49% | 49% | 19% | 50% | 82% | ||||||
54 | Proportion of nets that are PBO nets distributed to areas where PBO nets are not effective | % | calc | - | 0% | 0% | 0% | 51% | 51% | 0% | 0% | 18% | ||||||
55 | Proportion of nets that are chlorfenapyr nets | % | calc | - | 0% | 45% | 0% | 0% | 0% | 0% | 0% | 0% | ||||||
56 | Proportion of nets that are other Dual AI nets | % | calc | - | 0% | 5% | 0% | 0% | 0% | 0% | 0% | 0% | ||||||
57 | ||||||||||||||||||
58 | Insecticide resistance adjustment by net type | |||||||||||||||||
59 | Adjustment for standard nets | % | calc | - | -62% | -40% | -27% | -22% | -22% | -37% | -61% | -45% | ||||||
60 | Adjustment for PBO nets distributed to areas where PBO nets are effective | % | calc | - | -50% | -4% | -7% | -5% | -5% | -4% | -5% | -4% | ||||||
61 | Adjustment for PBO nets distributed to areas where PBO nets are not effective | % | calc | - | -62% | -40% | -27% | -22% | -22% | -37% | -61% | -45% | ||||||
62 | Adjustment for chlorfenapyr nets | % | calc | - | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | ||||||
63 | Adjustment for other Dual AI nets | % | calc | - | -62% | -40% | -27% | -22% | -22% | -37% | -61% | -45% | ||||||
64 | ||||||||||||||||||
65 | Final insecticide resistance adjustment incorporating Dual AI nets | |||||||||||||||||
66 | Adjustment for insecticide resistance | % | calc | - | -59% | -4% | -21% | -14% | -14% | -31% | -33% | -11% | ||||||
67 | ||||||||||||||||||