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.9% -1.50% -1.50% -1.50% -1.50% -3.92% -0.1% 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.90% 17.66% -0.82468% -8.2447E+303      
  -3.77787E+16   -0.00074927 -0.02775348 -1.69[3]  
   
scenario 2020 - 2100 Gt 335 335 335 335 335 335 335
budget 2020 - 2100[4] Gt 335 335 335 335 335 335 335
   
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    2084 2046 2057 2049 2066 2047 -
maximum RRt[6] -8.9% -46% -22% -38% -16% -67% -20%
year maximum RRt[7] 2043 2041 2045 2042 2048 2044 -
overshoot Gt 96 199 168 191 144 192 -
reduction 2030 vs. 2010   -60% -27% -41% -30% -49% -36% -73%
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.