Determination of the free parameter in the RM scenarios 2020 - 2100
target value of "goal seek" target is not met  
input value determination via "goal seek" target is met  
  Start macro
Goal Seek (or ctrl + b):
Determination of the free parameter of scenarios 1 - 6,
so that the budget is adhered to.
RM scenarios: RM-1 const RM-2 exp RM-3 lin RM-4 quadr RM-5 rad RM-6 abs   info: change rate
2019 / 2018
characteristics of the scenario   RRt const RRt exp RRt lin RRt quadr RRt rad RA const  
A corona effect should not be considered here. This can be taken into account in the sheet "base data".   only a negative RR_20 possible a positive RR_20 is also possible
(= increasing emissions after 2019)
   
  info
macro: Goal Seek RM-6
 copy this RR_20 to 2 - 5 (or ctrl + k)
macro: fine-tuning RR_20
 
 
change rate 2020 (RR20)[1]   -8,90% -2,00% -2,00% -2,00% -2,00% -6,38% -2,0% -2,00%
initial value[2]   -8% 10% -1% 0 0    
    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% 12,56% -0,67486%        
  -3,77787E+16   -0,00050654 -0,02423849 -0,11  
             
scenario 2020 - 2100 Gt 22 22 22 22 22 22
budget 2020 - 2100; sheet 'base data'[3] Gt 22 22 22 22 22 22
   
emissions 2100 scenario Gt -0,4 -0,4 -0,4 -0,4 -0,4 -0,4  
minimum emissions 2100; sheet 'base data'[4] Gt -0,4 -0,4 -0,4 -0,4 -0,4 -0,4  
year  Emin is achieved   2091 2055 2066 2054 2075 2051
change rate 2030 / 1990   -74% -53% -61% -53% -66% -56%
from emissions 2019
At which level of emissions (threshold value; TV) shall the annual reduction be change into a constant annual reduction amount?[5] RM 2 - 5: 0,12 Gt 3,50%
RM-1: 0,15 Gt 4,50%
Use this link to downlad a comprehensive mathematical description of the Regensburg Model Scenario Types:
Mathematical Description of the Regensburg Model Scenario Types

[1]
RM:
► Relative reduction or increase in emissions in 2020 compared to of 2019
► A
corona effect should not be considered here. This can be taken into account in the sheet "base data".
[2]
RM:
Please enter this value in the cell for the free parameter (gray cells), if the target value search (goal seek) should lead to an error message there.
[3]
input value sheet "base data"
[4]
input value sheet "base data"
[5]
RM:
It is necessary to change the method in order to be able to map net negative emissions.