Determination of the parameters for the global RM scenarios 2020 - 2100
input value determination via "goal seek"[1] target value of "goal seek" target is met target is not met
  Start macro
Goal Seek (or ctrl + b):
Determination of the free parameter of scenarios 1-4, so that the budget is adhered to.
RM scenarios: RM-1 RM-2 RM-3 RM-4 RM-5
characteristics of the scenario   RRt const RRt exp RRt lin RRt quadr RRt rad
      only a negative RR_20 possible a positive RR_20 is also possible
(= increasing emissions after 2019)
     
reduction rate 2020 (RR20)[2]   -7,66% -1,50% -1,50% -1,50% -1,47%
initial value (please enter in the grey cells if an error has occurred) -1% 1% -1% 0 0
RRt constant ER_RR A a a
Free parameters are determined by 'Goal Seek' in such a way as that the budget is adhered to. -7,66%[3] 15,13%[4] -0,69862%[5] -8,2447E+303 -8,245E+303
  -3,77787E+16   -0,00054359[6] -0,02486484
         
scenario 2020 - 2100 Gt 282 282 282 282 282
budget 2020 - 2100[7] Gt 282 282 282 282 282
   
emissions 2100 scenario Gt -4,35 -4,35 -4,35 -4,35 -4,35
minimum emissions 2100; Emin[8] Gt -4,35 -4,35 -4,35 -4,35 -4,35
 
values from the scenarios   RM-1 RM-2 RM-3 RM-4 RM-5
Year  Emin is achieved   2075 2052 2064 2054 2072
maximum RRt -7,7% -44% -20% -33% -15%
year maximum RRt     2044 2047 2044 2049
maximum overshoot Gt 145 226 189 219 162
At which level of emissions (threshold value; TV) shall the annual percentage reduction be change into a constant annual reduction?[9] RM 2 - 4 1,5 Gt 4,0%[10]
RM-1 4,0 Gt 10,7%[11]

[1]
In rare cases, goal seek does not converge despite of the existence of a solution. We recommend in such cases to start with a different start value in the cells shaded in grey.
Good start values are RR_t constant viz. A = -1%, ER = 1% and a = 0.
[2]

Relative reduction or increase in emissions in 2020 compared to of 2019.
[3]
If the Goal Seek did not converge, enter -1% here and perform the Goal Seek again.
[4]

ER must be greater than zero, otherwise RR_t decreases (mathematically: increases).

If the Goal Seek did not converge, enter 1 here and perform the Goal Seek again. Changing RR_20 can also be useful.
[5]

A must be less than zero, otherwise RR_t decreases (mathematically: increases).

If the Goal Seek didn't converge, enter -1 here and perform the Goal Seek again. Changing RR_20 can also be useful.
[6]
If the Goal Seek didn't converged, enter zero here and perform the Goal Seek again. Changing RR_20 can also be useful.
[7]
input value sheet "base data"
[8]
input value sheet "base data"
[9]
Background:
In our view, it makes sense to change the method at  relatively low global emissions in the scenarios 1-4 to change the method. We propose the threshold of 1 Gt CO2. Another threshold can be entered here. The absolute reduction of the previous year is then used as a constant annual reduction.
[10]
RM:
global share
[11]
RM:
global share