Determination of the free parameter in the RM scenarios 2020 - 2100 EU28 < selected country / weighting population > 50% global budget:  420 Gt
6,61[1]  t / capita ↑ target is not met to distribute here:  279 Gt
input value determination via "goal seek" target value of "goal seek" target is met
  Start macro
Goal Seek (or ctrl + b):
Determination of the free parameter of scenarios 1 - 6,
so that the budget is adhered to.
RM scenarios: RM-1 const RM-2 exp RM-3 lin RM-4 quadr RM-5 rad RM-6 info
characteristics of the scenario   RRt const RRt exp RRt lin RRt quadr RRt rad RA const basis projection 2019 last actual change rate
A corona effect should not be considered here.     only a negative RR_20 possible a positive RR_20 is also possible
(= increasing emissions after 2019)
 
    info
macro: Goal Seek RM-6
 copy this RR_20 to 2 - 5 (or ctrl + k)
macro: fine-tuning RR_20
2 - 5
change rate 2020 (RR20)[2]   -9,53% -1,96% -2,00% -1,97% -2,00% -3,77% -2,00% -1,9% -2,00%
initial value[3]   -8% 10% -1% 0 0 -136  
    RRt constant a a a a RA  
free parameters are determined by Goal Seek in such a way as that the budget is adhered to. -9,53% 13,69% -0,74012%        
  -3,77787E+16   -0,00058405 -0,02613375 -127,70[4]  
             
scenario 2020 - 2100; sheet 'RM' Mill. t 22.030 22.030 22.030 22.030 22.030 22.030
budget 2020 - 2100; sheet 'base data'[5] Mill. t 22.030 22.030 22.030 22.030 22.030 22.030
   
emissions 2100 scenario; sheet 'RM' Mill. t -397,6 -397,6 -397,6 -397,6 -397,6 -397,6  
minimum emissions 2100; sheet 'base data'[6] Mill. t -397,6 -397,6 -397,6 -397,6 -397,6 -397,6  
Year  Emin is achieved   2092 2051 2063 2052 2072 2049
change rate 2030 / 1990   -74% -51% -60% -51% -66% -55%
from emissions 2019
At which level of emissions (threshold value; TV) shall the annual percentage reduction be change into a constant annual reduction? RM 2 - 5: 118,58  Mill. t 3,50%
RM-1: 135,53  Mill. t 4,00%

[1]
RM:
For countries with very low per capita emissions, it can be difficult to reach the minimum value for 2100.
[2]

Relative reduction or increase in emissions in 2020 compared to of 2019.
[3]
RM:
Please enter this value in the cell for the free parameter (gray cells), if the target value search (goal seek) should lead to an error message there.
[4]
Mill. t p.a.
[5]
input value sheet "base data"
[6]
input value sheet "base data"