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,01% -1,40% -1,50% -1,70% -1,50% -1,00%
initial value   -1% 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,01% 16,49% -0,73711% -8,245E+303 -8,2447E+303  
  -3,77787E+16   -0,00058177 -0,02591944  
           
scenario 2020 - 2100 Mill. t 21.875 21.875 21.875 21.875 21.875
budget 2020 - 2100[4] Mill. t 21.875 21.875 21.875 21.875 21.875
   
emissions 2100 scenario Mill. t -407,0 -407,0 -407,0 -407,0 -407,0  
minimum emissions 2100; Emin[5] Mill. t -407,0 -407,0 -407,0 -407,0 -407,0  
 
values from the scenarios   RM-1 RM-2 RM-3 RM-4 RM-5  
Year  Emin is achieved   2087 2048 2059 2052 2068  
maximum RRt -9% -40% -20% -32% -15%
year maximum RRt     2042 2045 2043 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 183,3 Mill. t 5,50%
RM-1 166,6 Mill. t 5,00%

[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"