Determination of the parameters for the RM scenarios 2020 - 2100 EU28 weighting population key in the weighted key 50% budget 420
input value determination via "goal seek" target value of "goal seek" target is met target is not met[1]
  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 basis projection 2019
      only a negative RR_20 possible a positive RR_20 is also possible
(= increasing emissions after 2019)
     
reduction rate 2020 (RR20)[2]   -9,54% -1,50% -1,50% -1,50% -1,50% -1,00%
initial value   -8% 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.[3] -9,54% 16,95% -0,82349% -8,245E+303 -8,2447E+303  
  -3,77787E+16   -0,00067616 -0,02847073  
           
scenario 2020 - 2100 Mill. t 21.403 21.403 21.403 21.403 21.403
budget 2020 - 2100[4] Mill. t 21.403 21.403 21.403 21.403 21.403
   
emissions 2100 scenario Mill. t -417,3 -417,3 -417,3 -417,3 -417,3  
minimum emissions 2100; Emin[5] Mill. t -417,3 -417,3 -417,3 -417,3 -417,3  
 
values from the scenarios   RM-1 RM-2 RM-3 RM-4 RM-5  
Year  Emin is achieved   2089 2049 2061 2051 2069  
maximum RRt -10% -47% -22% -34% -16%
year maximum RRt     2042 2045 2042 2047
from emissions 2019
At which level of emissions (threshold value; TV) shall the annual percentage reduction be change into a constant annual reduction? RM 2 - 5 139,1 Mill. t 4,00%
RM-1 142,6 Mill. t 4,10%

[1]
Budget 2020 - 2050 (BG) oder
Zielmenge 2050 (ZM) wird nicht eingehalten.
[2]

Relative reduction or increase in emissions in 2020 compared to of 2019.
[3]
Andreas Wolfsteiner:

If the Goal Seek did not converge, enter the 'initial value' and perform the Goal Seek again.

Changing RR_20 can also be useful.

A change of TV can also be helpful.
[4]
input value sheet "base data"
[5]
input value sheet "base data"