Determination of the free parameter in the RM scenarios 2020 - 2100 selected country: EU27 weighting P: 50%
  target is not met t / capita 6.60[1] global budget in Gt: 420
input value determination via "goal seek" target value of "goal seek" target is met
macro: fine-tuning RR_20
macro: Goal Seek RM-6
Start macro
Goal Seek (or ctrl + b):
Determination of the free parameter of scenarios 1 - 6,
so that the budget is adhered to.
 copy this RR_20 to 2 - 5 (or ctrl + k)
macro: finding budget
 
RM scenarios: RM-1 const RM-2 exp RM-3 lin RM-4 quadr RM-5 rad RM-6 info
characteristics of the scenario   RRt const RRt exp RRt lin RRt quadr RRt rad RA const last actual change rate average annual change rate last two years
A corona effect should not be considered here.     only a negative RR_20 possible a positive RR_20 is also possible
(= increasing emissions after 2019)
 
    info 2 - 5
change rate 2020 (RR20)[2]   -9.40% -3.00% -3.00% -3.00% -3.00% -3.98% -4.0% -2.7% -3.00%
initial value[3]   -8% 10% -1% 0 0 -118  
    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. -9.40% 10.66% -0.68609% 2.03697E+66      
  -3.77787E+16   -0.00054004 -0.02400338 -116.93[4]  
             
scenario 2020 - 2100; sheet 'RM' Mill. t 19,286 19,286 19,286 19,286 19,286 19,286
budget 2020 - 2100; sheet 'base data'[5] Mill. t 19,286 19,286 19,286 19,286 19,286 19,286
   
emissions 2100 scenario; sheet 'RM' Mill. t -293.9 -293.9 -293.9 -293.9 -293.9 -293.9  
minimum emissions 2100; sheet 'base data'[6] Mill. t -293.9 -293.9 -293.9 -293.9 -293.9 -293.9  
year  Emin is achieved   2084 2054 2063 2052 2071 2047
change rate 2030 / 1990   -74% -58% -63% -56% -68% -57%
year minimum positive emissions 2060 2045 2049 2045 2053 2044
At which level of emissions in 2019 (threshold value; TV) shall the annual percentage reduction be change into a constant annual reduction? RM 2 - 5: 102.87  Mill. t 3.50%
RM-1: 126.38  Mill. t 4.30% data macro 'finding budget':
macro: finding NNE
Specified emissions target   0%
Current emissions target   0%
Specified maximum global budget   Gt
Current global budget   Gt
data macro 'finding NNE':
Specified emissions target   0.0%
Current emissions target   0.0%
Specified max. potential NNE   0.0%
Current potential NNE   0.0%
baseline potential NNE   0.0%
macro: finding weighting population
data macro 'finding weighting p.':
Specified emissions target   0.0%
Current emissions target   0.0%
Minimum or maximum weight P   0.0%
Current weighting population   0.0%
baseline weighting population   0.0%
global per capita   t
country per capita   t
macro: finding budget
Download a comprehensive mathematical description of the Regensburg Model Scenario Types:
Mathematicel Description RM 1 - 6
data macro 'finding budget':
Specified year of emissions neutrality    
Current year of emissions neutraltity    
Specified maximum global budget   Gt
Current global budget   Gt
macro: finding NNE
data macro 'finding NNE':
Specified year    
Current year    
Specified max. potential NNE   0.0%
Current potential NNE   0.0%
baseline potential NNE   0.0%
macro: finding weighting population
data macro 'finding weighting p.':
Specified emissions target    
Current emissions target    
Minimum or maximum weight P   0.0%
Current weighting population   0.0%
baseline weighting population   0.0%
global per capita   t
country per capita   t

[1]
RM:
For countries with very low per capita emissions, it can be difficult to reach the minimum value for 2100.
[2]

Relative reduction or increase in emissions in 2020 compared to of 2019.
[3]
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.
[4]
Mill. t p.a.
[5]
input value sheet "base data"
[6]
input value sheet "base data"