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[2]
  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)[3]   -7,39% -1,5% -1,5% -1,5% -1,5%
initial value (please enter in the gray 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,39%[4] 14,07%[5] -0,61174%[6] -8,2447E+303 -8,245E+303
  -3,77787E+16   -0,00047432[7] -0,02201095
         
scenario 2020 - 2100 Gt 285 285 285 285 285
budget 2020 - 2100[8] Gt 285 285 285 285 285
   
emissions 2100 scenario Gt -4,35 -4,35 -4,35 -4,35 -4,35
minimum emissions 2100; Emin[9] 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 2051 2060 2053 2068
maximum RRt -7,4% -35% -17% -29% -13%
year maximum RRt     2044 2046 2044 2048
maximum overshoot Gt 144 228 198 222 173
At which level of emissions (threshold value; TV) shall the annual percentage reduction be change into a constant annual reduction?[10] RM 2 - 4 2,5 Gt
RM-1 4,0 Gt

[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]
Budget 2020 - 2050 (BG) oder
Zielmenge 2050 (ZM) wird nicht eingehalten.
[3]

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

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.
[6]

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.
[7]
If the Goal Seek didn't converged, enter zero here and perform the Goal Seek again. Changing RR_20 can also be useful.
[8]
input value sheet "base data"
[9]
input value sheet "base data"
[10]
Background:
In our view, it makes sense to change the methode 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.