Determination of the free parameters for the global scenarios 2020 - 2100
target is met target is not met[1]  
input values determination via "goal seek" target value of "goal seek"  
 
RM-1 const RM-2 exp RM-3 lin RM-4 quadr RM-5 rad RM-6 abs SPM-R average global change rates last three years start macro
Goal Seek (or ctrl + b):
Determination of the free parameter of scenarios 1 - 6,
so that the budget is adhered to.
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)
   
  info info
change rate 2020 (RR20)[2]   -8.1% -1.50% -1.50% -1.50% -1.50% -3.56% 0.2% 0.5%
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.05% 15.05% -0.66554% -8.2447E+303      
  -3.77787E+16   -0.00053071 -0.02330136 -1.53[3]  
   
scenario 2020 - 2100 Gt 400 400 400 400 400 400 400
budget 2020 - 2100[4] Gt 400 400 400 400 400 400 400
   
emissions 2100 scenario; E2100 Gt -3.50 -3.50 -3.50 -3.50 -3.50 -3.50 0.0
minimum emissions; Emin[5] Gt -3.50 -3.50 -3.50 -3.50 -3.50 -3.50 -
 
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    2089 2050 2062 2051 2071 2050 -
maximum RRt[6] -8.1% -43% -20% -32% -14% -48% -17%
year maximum RRt[7] 2020 2044 2048 2044 2051 2046 -
overshoot Gt 80 185 153 182 129 183 -
reduction 2030 vs. 2010   -56% -23% -35% -23% -43% -32% -62%
At which level of global emissions (threshold value; TV) shall the annual percentage reduction be change into a constant annual reduction amount in scenarios 2 - 5?   in Gt[8] 1.7 4.0% of global emissions
in 2019
Opportunity for its own TV in scenario 1 to get there earlier to global negative emissions: in Gt 1.9 4.5%
 

[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]
Within the formulae see below.
[7]
Within the formulae see below.
[8]
In order to be able to map net negative emissions, it is necessary to change the method at a specified threshold.