Determination of the parameters for the global RM scenarios 2020 - 2100 Start macro
Goal Seek (or ctrl + b):
Determination of the free parameter of scenarios 1 - 6,
so that the budget is adhered to.
target is not met
input value determination via "goal seek" target value of "goal seek" target is met
 
RM scenarios: RM-1 const RM-2 exp RM-3 lin RM-4 quadr RM-5 rad RM-6 abs
characteristics of the scenario   RRt const RRt exp RRt lin RRt quadr RRt rad RAt const info
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)
  average last 3 years last actual value global budget
  info
change rate 2020 (RR20)[1]   -7,81% -1,55% -1,50% -1,50% -1,50% -3,55% 1,4% 1,9% 420
initial value (please enter in the grey cells if an error has occurred)[2] -6% 10% -1% 0 0 -4
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. -7,81% 14,57% -0,69205% -8,2447E+303 -8,245E+303 -8,245E+303
  -3,77787E+16   -0,00053407 -0,02456857 -1,3[3]
           
scenario 2020 - 2100 Gt 279 279 279 279 279 279
budget 2020 - 2100[4] Gt 279 279 279 279 279 279
   
emissions 2100 scenario Gt -4,35 -4,35 -4,35 -4,35 -4,35 -4,35
minimum emissions 2100; Emin[5] Gt -4,35 -4,35 -4,35 -4,35 -4,35 -4,35
 
values from the scenarios   RM-1 const RM-2 exp RM-3 lin RM-4 quadr RM-5 rad RM-6 abs
Year  Emin is achieved   2077 2052 2064 2054 2072 2051
At which level of emissions (threshold value; TV) shall the annual percentage reduction be change into a constant annual reduction?[6] RM 2 - 5 1,6 Gt 4,3%
RM-1 3,3 Gt 8,9%

[1]

Relative reduction or increase in emissions in 2020 compared to of 2019.
[2]
RM:
If the target value search (Goal Seek) generates an error message, please enter this initial values in the gray cells and choose a different starting value for 2020 or TV before you start the macro 'Goal Seek' again.
[3]
RM:
Gt p.a.
[4]
input value sheet "base data"
[5]
input value sheet "base data"
[6]
In order to be able to map net negative emissions, it is necessary to change the method at a specified threshold.