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   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)		    
       
change rate 2020 (RR20)[1]   -6.67% -0.01% -0.01% -0.01% -0.01% -3.46%
copy this RR_20 to 2 - 5 (or ctrl + k)
macro: find budget > 2030 target
macro: find budget > year neutrality
1.42% -0.01%
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 -6.67% 75.53% -0.76486%        
  -3.77787E+16   -0.00072451 -0.02497838 -1.41  
             
scenario ∑ 2020 - 2100 Gt 550.00 550.00 550.00 550.00 550.00 550.00
budget ∑ 2020 - 2100; sheet 'base data'[3] Gt 550.00 550.00 550.00 550.00 550.00 550.00
   
emissions 2100 scenario Gt -0.41 -0.41 -0.41 -0.41 -0.41 -0.41  
Emin; sheet 'base data'[4] Gt -0.41 -0.41 -0.41 -0.41 -0.41 -0.41  
year Emin is achieved   2082 2037 2053 2046 2062 2049
change rate 2030 / 1990   -31% 38% -4% 11% -14% -9% data macro 'finding budget':
year emissions neutrality[5]   2078 2037 2052 2045 2060 2048 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: 1.43 Gt 3.50%[7] of emissions in the BY Current emissions target 2030   0% 38% -4% 11% -14% -9%
RM-1: 1.88 Gt 4.60%[8] Specified maximum budget   Gt
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     2037 2052 2045 2060 2048
RM-1 const RM-2 exp RM-3 lin RM-4 quadr RM-5 rad RM-6 abs Specified maximum budget   Gt
budget is adhered to 0 0 0 0 0 0 0 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]
► 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]
RM:
first year negative emissions or emissions equal to zero
[6]
It is necessary to change the method in order to be able to map net negative emissions.
[7]
AW:
Plausible initial value: 3,5%
[8]
AW:
Plausible initial value: 4,5%