Cost-effectiveness of climate change mitigation.xlsx
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

View only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
GroupingTitleCentral value5% / low95% / highUnitTypeTime valueSourceURL
2
Current emissionsA1B 2016 emissions50,000,000,00050,000,000,00045,000,000,000tCO2eqInput2016
Bernie, Dan, Jason Lowe, and Stephen Smith. "Technical Appendix: Updated projections of global emissions and temperatures." Report commissioned by the UK Committee on Climate Change in support of the fourth carbon budget review (2013).
https://www.theccc.org.uk/wp-content/uploads/2013/11/Updated-projections-of-global-emissions-and-temperatures.pdf
3
4
2030 impactsAdditional deaths from undernutrition95176.0-119807.0310156.0DeathsInput2030
World Health Organization. Quantitative risk assessment of the effects of climate change on selected causes of death, 2030s and 2050s. World Health Organization, 2014.
5
Additional deaths from malaria60091.037608.0117001.0DeathsInput2030ibid.
6
Additional deaths from dengue fever258.0136.0331.0DeathsInput2030ibid.
7
Additional deaths from diarrhoeal disease48114.021097.067702.0DeathsInput2030ibid.
8
Additional deaths from excessive heat37588.026912.048390.0DeathsInput2030ibid.
9
Percentage of total deaths (assuming that deaths due to all causes grow at the same rate as the above - very generous assumption)
5.15.94.4Input2030
Global Burden of Disease Study
http://vizhub.healthdata.org/gbd-compare/
10
Total deaths4714227.1-582119.712382232.3DeathsCalc2030
11
12
2050 impactsAdditional deaths from undernutrition84697.0-29203.0163989.0DeathsInput2050
World Health Organization. Quantitative risk assessment of the effects of climate change on selected causes of death, 2030s and 2050s. World Health Organization, 2014.
13
Additional deaths from malaria32695.022786.040817.0DeathsInput2050ibid.
14
Additional deaths from dengue fever282.0195.0342.0DeathsInput2050ibid.
15
Additional deaths from diarrhoeal disease32955.014914.049151.0DeathsInput2050ibid.
16
Additional deaths from excessive heat94621.070775.0126684.0DeathsInput2050ibid.
17
Percentage of total deaths (assuming that deaths due to all causes grow at the same rate as the above - very generous assumption)
5.15.94.4Input2050
Global Burden of Disease Study
http://vizhub.healthdata.org/gbd-compare/
18
Total deaths4792847.41358410.38678428.2DeathsCalc2050
19
20
Average increase per year 2030-2050
Additional deaths from undernutrition-524.04530.2-7308.4Deaths/yearCalc2030-2050
n.b. these decrease due to adaptation and disease prevention work
21
Additional deaths from malaria-1369.8-741.1-3809.2Deaths/yearCalc2030-2050
n.b. these decrease due to adaptation and disease prevention work
22
Additional deaths from dengue fever1.23.00.6Deaths/yearCalc2030-2050
23
Additional deaths from diarrhoeal disease-758.0-309.2-927.6Deaths/yearCalc2030-2050
n.b. these decrease due to adaptation and disease prevention work
24
Additional deaths from excessive heat2851.72193.23914.7Deaths/yearCalc2030-2050
25
Sum of additional deaths due to these pathways201.25676.1-8129.9Deaths/yearCalc2030-2051
26
Percentage of total deaths (assuming that deaths due to all causes grow at the same rate as the above - very generous assumption)
5.15.94.4%Input
Global Burden of Disease Study
http://vizhub.healthdata.org/gbd-compare/
27
Total deaths per year (according to rate of change in the given column)
3931.0110925.3-158879.2Deaths/yearCalc2030-2050
28
Total deaths per year (using rate of change in the central value column)
3931.03438.54582.0Deaths/yearCalc2030-2051
29
30
Effect of emissions reduction
CO2 climate lag37.550.025yearsInput
Hansen, J. et al. Earth's Energy Imbalance: Confirmation and Implications, 2004. http://science.sciencemag.org/content/early/2005/04/28/science.1110252
Science AAAS, ”Earth’s Energy Imbalance: Confirmation and Implications”, available (after free registration) at www.scienceonline.org/cgi/reprint/1110252v1.pdf, p.1
31
Current year2016.02016.02016.0Input
32
Year of effect2053.52066.02066.0Calc
33
Is the year of effect within 5 years of 2030-20501.00.00.0Y/N
Input (estimate)
34
Additional emissions averted (use this box for emissions averted by methods other than donations to Cool Earth)
0.00.00.0tCO2eqInput
35
Additional costs (use this box for the cost of emissions averted through other means
0.00.00.0
36
Emissions averted (including below)265.4140.1548.3tCO2eqCalc
37
Proportion of total annual emissions for that year averted5.31E-092.80E-091.22E-08#Calc
38
Lives saved if global warming was cancelled out entirely for that year
4806605.93133215.86136360.6DeathsCalc
39
Effect of emissions averted (global warming completely cancelled)
2.55E-028.78E-037.48E-02DeathsCalc
40
Average cost/life saved (global warming completely cancelled)3919.711392.11337.4$/lifeCalc
n.b. this is an extreme underestimate of the actual cost
41
Downward effect of adaptation on heat deaths (percentage of annual increase)
180.0150.0200.0%
Input (estimate)
42
Downward effect of adaptation on Dengue fever (percentage of annual increase)
180.0150.0200.0%
Input (estimate)
43
Downward effect of adaptation on undernutrition (percentage of annual decrease)
180.0150.0200.0%
Input (estimate)
44
Downward effect of adaptation on malaria (percentage of annual decrease)
180.0150.0200.0%
Input (estimate)
45
Downward effect of adaptation on diarrhoeal disease (percentage of annual decrease)
180.0150.0200.0%
Input (estimate)
46
Heat deaths prevented by incremental warming delay2.72E-051.20E-056.95E-05LivesCalc
47
Dengue fever deaths prevented by incremental warming delay1.15E-088.40E-092.92E-08LivesCalc
48
Undernutrition deaths prevented by incremental warming delay5.01E-062.20E-061.28E-05LivesCalc
49
Malaria deaths prevented by incremental warming delay1.31E-055.76E-063.34E-05LivesCalc
50
Diarrhoeal disease deaths prevented by incremental warming delay
7.24E-063.19E-061.85E-05LivesCalc
51
Lives saved (all 5 areas) by incremental warming delay5.26E-052.31E-051.34E-04LivesCalc
52
Lives saved (all 5 areas) per 1tCO2eq averted1.98E-071.65E-072.45E-07Lives
53
Tonnes per life saved in these 5 areas5046330.46054716.54087527.6
54
Cost per life saved in these 5 areas1901486.94322329.9745467.1$/lifeCalc
55
Percentage of total lives saved5.15.94.4%Input
56
Cost per life saved (all causes of death)97299.1252856.332726.0US$/lifeCalc
57
Lives saved per 1tCO2eq averted (all causes of death)3.87E-062.82E-065.57E-06LivesCalc
58
Tonnes per life saved (all causes of death)258220.7354200.9179442.5tCO2eq/lifeCalc
59
Lives saved as a result of individual emission reduction0.0010277589070.00039548154190.003055673695
60
61
DiscountingYears into the future37.550.025yearsInput
Hansen, J. et al. Earth's Energy Imbalance: Confirmation and Implications, 2004. http://science.sciencemag.org/content/early/2005/04/28/science.1110252
Science AAAS, ”Earth’s Energy Imbalance: Confirmation and Implications”, available (after free registration) at www.scienceonline.org/cgi/reprint/1110252v1.pdf, p.1
62
Discount rate/year331%/yearInput
63
Factor of value in that year0.31910972150.21806537530.7778213594Calc
64
Tonnes per death averted (discounted)809191.03071624287.731230698.809tCO2eq/lifeCalc
65
Cost per life saved (discounted)304907.92731159543.55942073.9377$/lifeCalc
66
67
Cool Earth donationsAmount donated100100100US$Input
68
Cost per acre protected10012080US$/acreInput
Communications with Cool Earth
69
Area protected1.000.831.25acres Calc
70
Additional acres shielded per acre directly protected2.551.622.55acres/acreInput
Communications with Cool Earth
71
Area shielded2.551.353.18acresCalc
72
Total area (protected or shielded)3.552.194.43acresCalc
73
Percentage of comparable forest logged282840%Input
Communications with Cool Earth; International Arm of the French Forestry Commission
74
Percentage of protected forest logged0.50.50.5%Input
Communications with Cool Earth
75
Reduction in logging (including both protected and shielded areas)
0.980.601.75acresCalc
76
Emissions averted per acre not logged272.00233.00313.00
tCO2eq/acre
Input
Communications with Cool Earth; Saatchi, et al, 2011, Benchmark map of forest carbon stocks in tropical regions across three continents, PNAS.; Kearsley, et al, 2013, Conventional tree height-diameter relationships significantly overestimate aboveground carbon stocks in the Central Congo Basin, Nature Communications.; Vincent, et al, 2015, Forest carbon in lowland Papua New Guinea: Local variation and the importance of small trees, Austral Ecology.
77
Total emissions averted 265.39140.08548.32tCO2eq/Calc
78
Cost per tonne of emissions averted0.380.710.18
US$/tCO2eq
Calc
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
Loading...
Main menu