Calculation for the EU based on the Extended Smooth Pathway Model (ESPM)
The ESPM offers the use of a weighted allocation key to determine a budget for the EU that includes the "population" and the "emissions" in a base year.
now sheet "base data"
 budget 2020 - 2100: 30.49 Gt corona effect is not taken into account 'goal seek' is ok
scope of the budget from 2020 on 10.44 years sheet 'goal seek'
             
input fields  
data base EEA incl. LUC/ISA data base   EDGAR (excl. LUC/ISA)
  EU27 weighted key global budget 2020 on EU27 budget 2020 on     EU27 weighted key global budget 2020 on EU27 budget 2020 on
     
     
emissions share 6.8% 6.28% 486 30.5 emissions share 8.4% 7.1% 406 28.8
population share 5.8% population share 5.8%
Test macro:
delete  EU data in sheet "base data"
macro:
find budget > 2030 target
weighting population 50% LUC/ISA 16%
global budget 2018 on 570
potential NNE 0% potential NNE -10%
macro:
delete  EU data in sheet "base data"
Test
   
E_18 3.04 E_18   3.09
E_19 2.92   E_19   2.94
E_90 3.81 E_90   1.02
global 2018 - 2019 84.23 global 2018 - 2019 73.3
global 2018 on LUC/ISA 91.2
per capita EU 6.8 per capita EU 6.6
global 5.5 global 4.8
data macro 'finding budget':
Specified emissions target 2030   0% RM-2 exp RM-3 lin RM-4 quadr RM-5 rad RM-6 abs
Current emissions target 2030   0% -64% -66% -62% -68% -62%
Specified maximum global budget   Gt
Current global budget     Gt