How I made global.1751_2021.ems9.*
                 __________________________________


(This is "fossil CO2 emissions only." Land use change effects are not included in this spreadsheet.
For a spreadsheets which include "land use change emissions" see global.1751_2021_ems13.*)

Start with: https://zenodo.org/record/7215364/files/GCB2022v27_MtCO2_flat.csv?download=1
Find it at https://zenodo.org/record/7215364
That page is linked-to from https://www.globalcarbonproject.org/

Delete everything (except the header line) which doesn't start with:
"Global","WLD",

Copy the comments at the top from a previous version; I used the first 15 lines of:
w:\html\sealevel\carbon\ICOS_and_GCP\GCB2021v34_MtCO2_flat_global-only.tab
Fix the URLs, the date & the version number in the comments.

The "Country" and "ISO 3166-1 alpha-3" columns (the first two) must be deleted,
the "Coal","Oil","Gas" columns must be rearranged to Gas,Oil,Coal,
and the units must be converted from GtCO2 to GtC.

So this:
"Country","ISO 3166-1 alpha-3","Year","Total","Coal","Oil","Gas","Cement","Flaring","Other","Per Capita"
...
"Global","WLD",1938,4201.279796,3228.046168,796.989445,135.493153,38.550531,,,1.854686

Becomes this:
Year,Total,Gas,Oil,Coal,Cement,Flaring,Other,Per_Capita
...
1938,1144.930122,36.973142,217.577171,879.273899,10.505368,,,0.505982

Delete the first two columns manually, in any editor; this is SlickEdit
c/"Global","WLD",//

Delete all quote marks from the header line and all subsequent data lines (leave them in the comment block at the top).

Then use this program to make the other changes:
w:\html\sealevel\carbon\ICOS_and_GCP\cvt_MtCO2_to_MtC.pl

But first you've got to change the format to tab-delimited.
There are no tabs in the original file, and the only quote marks are around fields, so it's easy to do it in SlickEdit.

Then save it as:
GCB2022v27_MtCO2_flat_global_only_temp1.tab

Now run the program:
perl cvt_MtCO2_to_MtC.pl <GCB2022v27_MtCO2_flat_global_only_temp1.tab >global.1751_2021.ems9.tab

Finally, copy the comments at the bottom from a previous version to the bottom of global.1751_2021.ems9.tab
I used:
W:\html\sealevel\carbon\temp_work_files\global.1751_2020.ems8.csv
(and then I tweaked the comments)

I created the .txt version in SlickEdit via:
tabs 7 21 35 49 62 75 87 99
save +E w:\html\sealevel\carbon\ICOS_and_GCP\global.1751_2021.ems9.txt

Then load the .tab version into Excel and save the .csv and .xlsx versions.