Determination of the free parameter in the RM Scenario Types 2020 - 2100
Start macro Goal Seek: Determination of the free parameter of scenarios 1 - 6, so that the budget is adhered to.
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  
    RRt const RRt exp RRt lin RRt quadr RRt rad RA const  
start change rate in the start year (RR_SY);
normalised value		   only a negative RR_SY possible a positive RR_SY is also possible
(= increasing emissions after 2019)		    
       
-4.29% -4.29% -4.29% -4.29% -4.57% -4.29% copy this RR_SY to 2 - 5 (or ctrl + k)
initial value[1]   -8% 10% -1% 0 0     RR_19 -4.29%
    RRt constant a a a a RA   macro: find budget > 2030 target
free parameters are determined by "goal seek" in such a way as that the budget is adhered to -8.65% 8.48% -0.58141%        
  -3.77787E+16   -0.00056902 -0.01833008 -0.11  
             
scenario ∑ 2020 - 2100 Gt 35.72 35.72 35.72 35.72 35.72 35.72
budget ∑ 2020 - 2100; sheet 'base data'[2] Gt 35.72 35.72 35.72 35.72 35.72 35.72 Should the potential for net negative emissions (NNE) be taken into account when setting the TVs? yes
   
emissions 2100 scenario Gt -0.02 -0.02 -0.02 -0.02 -0.02 -0.02  
Emin; sheet 'base data'[3] Gt -0.02 -0.02 -0.02 -0.02 -0.02 -0.02   macro: find budget > year neutrality
year Emin is achieved   2069 2051 2055 2049 2060 2046
change rate 2030 / 1990   -65% -55% -57% -54% -60% -55% base data supple-ment minimum values proven values data macro 'finding budget':
year emissions neutrality[4]   2067 2050 2054 2049 2059 2045 NNE initial value TV RM-1 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?[5] RM 2 - 5: 0.10 Gt 3.50% of emissions in 2019 -0.7% 50% TV = Potential for net negative
emissions (-NNE) + supplement		 3.50% 3.5% Current emissions target 2030   0% -55% -57% -54% -60% -55%
RM-1: 0.13 Gt 4.50% 4.50% 85% 4.50% 4.5% Specified maximum budget   Gt
proven values Current budget   Gt
data macro 'finding budget':
Specified year of emissions neutrality     RM-2 exp RM-3 lin RM-4 quadr RM-5 rad RM-6 abs
dashboard check sum 0 is ok; 1 not ok Current year of emissions neutraltity     2050 2054 2049 2059 2045
RM-1 const RM-2 exp RM-3 lin RM-4 quadr RM-5 rad RM-6 abs 50% Specified maximum budget   Gt
budget is adhered to 0 0 0 0 0 0 0 85% Current budget   Gt
emissions in 2100 not positive 0 0 0 0 0 0 0
no increasing emissions 0 0         0
check sum 0 0 0 0 0 0 0
E_2100 is negative but not equal to E_min 0 0 0 0 0 0  
Use this link to downlad a comprehensive mathematical description of the Regensburg Model Scenario Types:
Mathematical Description of the Regensburg Model Scenario Types
[1]
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.
[2]
input value sheet "base data"
[3]
input value sheet "base data"
[4]
RM:
first year negative emissions or emissions equal to zero
[5]
It is necessary to change the method in order to be able to map net negative emissions.