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: 570
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]   -7.99% -3.00% -3.00% -3.00% -3.00% -4.26% -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. -7.99% 11.48% -0.64983% 2.03697E+66      
  -3.77787E+16   -0.00064115 -0.02038859 -125.07[4]  
             
scenario ∑ 2020 - 2100; sheet 'RM' Mill. t 33,080 33,080 33,080 33,080 33,080 33,080
budget ∑ 2020 - 2100; sheet 'base data'[5] Mill. t 33,080 33,080 33,080 33,080 33,080 33,080
   
emissions 2100 scenario; sheet 'RM' Mill. t 0.0 0.0 0.0 0.0 0.0 0.0  
Emin; sheet 'base data'[6] Mill. t 0.0 0.0 0.0 0.0 0.0 0.0  
year  Emin is achieved   2069 2045 2051 2044 2057 2043
change rate 2030 / 1990   -69% -59% -62% -58% -65% -59%
year minimum positive emissions 2068 2044 2050 2043 2056 2042
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: 132.26  Mill. t 4.50% data macro 'finding budget':
macro: finding NNE
Specified emissions target   0%
Download a comprehensive mathematical description of the Regensburg Model Scenario Types: Current emissions target   0%
Mathematicel Description RM 1 - 6 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
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"