Determination of the free parameters for the global scenarios
target is met target is not met[1]  
input values determination via "goal seek" target value of "goal seek"  
 start macro
Goal Seek:
Determination of the free parameter of scenarios 1 - 6,
so that the budget is adhered to.
copy to RM 2 - 5
 
RM-1 const RM-2 exp RM-3 lin RM-4 quadr RM-5 rad RM-6 abs SPM-R average global change rates 2017 - 2019 global change rate 2019
characteristics of the scenario   RRt const RRt exp RRt lin RRt quadr RRt rad RA const Raupach
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)
   
     
change rate 2020 (RR20)[2]   -0.60% -0.60% -0.60% -0.60%     1.3% 1.54% -0.60%
Initial values for free parameter (cells shaded in grey) if Goal Seek does not converge: -10% 1% -1% 0 0 -3  
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.73% 18.95% -0.56135% -8.2447E+303      
  -3.77787E+16   -0.00040681 -0.02127523 -1.38[3]  
   
scenario 2020 - 2100 Gt 500 500 500 500 500 500 500
budget 2020 - 2100[4] Gt 500 500 500 500 500 500 500
   
emissions 2100 scenario; E2100 Gt -3.50 -3.50 -3.50 -3.50 -3.50 -3.50 0.00
minimum emissions; Emin[5] Gt -3.50 -3.50 -3.50 -3.50 -3.50 -3.50 -
 
At which level of emissions in 2019 (threshold value; TV) shall the percentage reduction be change into a constant reduction?[6] RM 2 -5 1.5 Gt 3.5% of global emissions
in 2019
3.5%[7]
RM 1 1.9 Gt 4.5% 4.5%[8]
     
values from the scenarios   RM-1 const RM-2 exp RM-3 lin RM-4 quadr RM-5 rad RM-6 abs SPM-R
year Emin is achieved    2096 2049 2068 2058 2080 2054 -
maximum RRt -7.7% -46% -19% -32% -13% -59% -14%
year maximum RRt 2024 2045 2052 2048 2056 2050 -
overshoot Gt 59 185 136 164 102 170 -
reduction 2030 vs. 2010   -48% -9% -25% -13% -35% -25% -48%
Detailed description of the RM Scenario Types: Zenodo

[1]
Budget 2020 - 2100 is not met
[2]
Relative reduction or increase in emissions in 2020 compared to of 2019.

The inclusion of a temporary corona effect does not make sense here.
[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.
[7]
AW:
Plausible initial value
[8]
AW:
Plausible initial value