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.10% -0.10% -0.10% -0.10%     1.3% 1.42% -0.10%
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. -8.44% 48.12% -0.83018% -8.2447E+303      
  -3.77787E+16   -0.00079018 -0.02731220 -1.84[3]  
   
scenario ∑ 2020 - 2100 Gt 550 550 550 550 550 550 550
budget ∑ 2020 - 2100[4] Gt 550 550 550 550 550 550 550
   
emissions 2100 scenario; E2100 Gt 0.00 0.00 0.00 0.00 0.00 0.00 0.00
minimum emissions; Emin[5] Gt 0.00 0.00 0.00 0.00 0.00 0.00 -
 
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.4 Gt 3.5% of global emissions
in 2019		 3.5%[7]
RM 1 1.9 Gt 4.7% 4.5%[8]
     
dashboard check sum 0 is ok; 1 not ok
RM-1 const RM-2 exp RM-3 lin RM-4 quadr RM-5 rad RM-6 abs
budget is adhered to 0 0 0 0 0 0 0
emissions in 2100 not positive 0 0 0 0 0 0 0
no increasing emissions 0 0         0
check sum 0 0 0 0 0 0 0
E_2100 is negative but not equal to E_min 0 0 0 0 0 0  
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    2068 2038 2051 2044 2058 2045 -
maximum RRt -8.4% -79% -23% -38% -15% -88% -12%
year maximum RRt 2024 2037 2047 2042 2052 2044 -
overshoot Gt 0 0 0 0 0 0 -
reduction 2030 vs. 2010   -47% -8% -32% -22% -38% -32% -41%
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