Data global
 
now sheet 'base data'
budget 2020 - 2100: 550.0 Gt 'goal seek' is ok
country Global        
     
data base GCP
        budget 2020 on
 
 
      550.00
   
Test macro:
delete  global data in sheet "base data" macro:
convert links into values "base data"
    inputs sheet "EU27"
global budget 2020 on[1] 550
potential NNE[2] -1%
   
E_18 40.326 GCP E_90 27.714
E_19 40.899 1.4%
E_20 38.545 -5.8%
E_21 40.345 4.7%
E_22 40.663 0.8%
E_23 (projection) 40.900 0.6%
data status GCP: Dez 23 Data from the "WP" tool: https://doi.org/10.5281/zenodo.5837866        
1990 2010 2015 2018 2019 2020 2021 2022 2023
budget up to 2024 390 27.71 37.93 40.41 40.33 40.90 38.54 40.35 40.66 40.90

[1]
see paper for download on the right side
[2]
RM:
See paper on the right side.