Determination of the free parameter in the RM Scenario Types 2020 - 2100
Start macro
Goal Seek (or ctrl + b):
Determination of the free parameter of scenarios 1 - 6,
so that the budget is adhered to.
macro: Goal Seek RM-6
 copy this RR_20 to 2 - 5 (or ctrl + k)
macro: fine-tuning RR_20
macro:
find budget > 2030 target
macro:
find budget > year neutrality
target cell
"goal seek"
changeable cell "goal seek" target value "goal seek" target is not met  
input values   target is met  
 
RM Scenario Type: RM-1 const RM-2 exp RM-3 lin RM-4 quadr RM-5 rad RM-6 abs   info: change rate
2019
    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    
change rate 2020 (RR20)[1]   -8.55% -4.00% -4.00% -4.00% -4.00% -4.57% -3.9% -4.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.55% 9.37% -0.62012%        
  -3.77787E+16   -0.00062443 -0.01925357 -0.13  
             
scenario 2020 - 2100 Gt 30.49 30.49 30.49 30.49 30.49 30.49
budget 2020 - 2100; sheet 'base data'[3] Gt 30.49 30.49 30.49 30.49 30.49 30.49
   
emissions 2100 scenario Gt 0.00 0.00 0.00 0.00 0.00 0.00  
Emin; sheet 'base data'[4] Gt 0.00 0.00 0.00 0.00 0.00 0.00  
year Emin is achieved   2065 2046 2050 2044 2056 2041
change rate 2030 / 1990   -71% -64% -66% -62% -68% -62% data macro 'finding budget':
year emissions neutrality[5]   2064 2045 2049 2043 2055 2040 Specified emissions target 2030   0% RM-2 exp RM-3 lin RM-4 quadr RM-5 rad RM-6 abs
At which level of emissions (threshold value; TV) shall the annual reduction be change into a constant annual reduction amount?[6] RM 2 - 5: 0.10 Gt 3.50% of emissions in the BY Current emissions target 2030   0% -64% -66% -62% -68% -62%
RM-1: 0.13 Gt 4.50% Specified maximum budget   Gt
Current budget   Gt
Use this link to downlad a comprehensive mathematical description of the Regensburg Model Scenario Types: data macro 'finding budget':
Specified year of emissions neutrality     RM-2 exp RM-3 lin RM-4 quadr RM-5 rad RM-6 abs
Mathematical Description of the Regensburg Model Scenario Types Current year of emissions neutraltity     2045 2049 2043 2055 2040
Specified maximum budget   Gt
Current budget   Gt

[1]
► 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]
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]
year minimum positive emissions
[6]
It is necessary to change the method in order to be able to map net negative emissions.