source:
base data When modifying input data (which the cells shaded in yellow are designated for), you must always execute the macro in sheet “goal seek” to adjust the parameters in the scenario such as to meet the budget 2020 - 2100. http://www.ipcc.ch/report/sr15/
> Chapter 2
input fields values can be overwritten values from the sheet „EDGAR“  SPM >
I. Input of base data for the determination of global emission pathways 2020 - 2100 which are compatible with a given remaining budget
I. a) Remaining budget from 2018 to 2100                      
A B = A * J C = A - B J
CO2 budget from 2018 to 2100
in Gt
FOLU
from 2018 - 2100
in Gt
Budget
from 2018 - 2100
without FOLU
in Gt
Proportion of FOLU: 15%
420 see Table 2.2 63 357 FOLU analog global paths 16%[1]
 
 
I. b) Emissions 2012 - 2019                      
  annual rate of change:   2,0% 1,2% -0,1% -0,7% 0,5%
      year: 2012 2013 2014 2015 2016 2017 2018 2019 sum
2018 - 2019
CO2 emissions with FOLU in Gt         41,1            
CO2 emissions without FOLU in Gt     35,0 35,7 36,1 36,1 35,8 36,0 36,2 36,3 72 F
I. c) Remaining budget 2020 - 2100                      
CO2 cumulative budget 2020 - 2100 in Gt without FOLU emissions (here calculated value) 285 = C - F
CO2 cumulative budget 2020 - 2100 in Gt; free input  
CO2 budget 2020 - 2100 in Gt (basis for this tool)     here calculated value   285 without FOLU
I. d) Emissions in the base year 2019 and minimum emissions                
CO2 emissions in the base year 2019 in Gt (see I. b) 36,3  
Minimum annual CO2 emissions in Gt (negative value for global negative emissions possible, see notes); Emin: -4,4
II. Base date of the national emission pathways calculated with the Regensburg Formula
At what level of per capita emissions all countries should converge; convergence level (t / capita)?[2] 0,25
For your information: global per capita emissions today (without FOLU and int. Aviation/Shipping) approx. (t / capita):         4,6
Which population size is to be used in the tool for the convergence year? frozen population size 2019
III. Input values when global emissions are increasing
The Regensburg Formula does not yield reasonable results if global emissions are increasing, because developing countries would need to lower their emissions.
We do however also offer some scenarios where global emissions can increase temporarily after 2019. For those years with increasing emissions, the Regensburg Formula was not applied. Instead, global increase was distributed according to the following rule: the proportion PC_t of this increase is distributed according to population in relation to global population, and the proportion (1-PC_t) of this increase is distributed according to the proportion of emissions in relation to global emissions in year t-1.

PC_t can be escalated with an escalation rate. Here you can set the start value PC_20 for the year 2020 and the escalation rate ER_PC.
PC20 100%
ERPC  
Lists for the drop-down menus:
   
here calculated value
value of free input
   
frozen population size 2019
minimum "instant replacement" / "forecast values"
forecast values  

[1]
info
[2]
This value is not used if you have chosen the version "implicit budget" in the sheet "graphs country".