Notes on making global.1751_2021.ems10.xlsx and global.1751_2021.ems10.txt
These are similar


Start by making global.1751_2021.ems10.xlsx:

Start with global.1751_2021.ems9.xlsx

Fix the comments at the bottom.

Rename the "Total" column header to "Given total fossil"

Rename "Per_Capita" column header to "Per Capita Fossil"

Insert new column B "Fossil + Land use"

Insert new column D "Summed Fossil" and define it to be the sum of gas+oil+coal+flaring+other, and fill-down.
(Note that column D and column C should be the same, but they sometimes differ slightly.)

Create new column L "Land use (OSCAR)" and paste values for 1850 to latest from the OSCAR sheet of
National_LandUseChange_Carbon_Emissions_2022v1.0_mod1.xlsx

Fill in the values of column B "Fossil + Land use" starting with 1850, defined as the sum of columns C and L, and fill-down.


After making global.1751_2021.ems10.xlsx, save it, then save it again in tab-deliminated format,
as global.1751_2021.ems10.txt

Then open global.1751_2021.ems10.txt in SlickEdit, set the tabs, and save with the +E (expand tabs) option.

Then exit SlickEdit, and open it again in SlickEdit.

Then fix the column alignments by selecting each desired column, and doing this repeatedly:
c /{[0-9.]#}{ }/#1#0/mr

Then delete all the quote marks:
c/"//


-------------------

global.1751_2021.ems11.* and global.1751_2021.ems12.* are very similar to global.1751_2021.ems11.*, except that
11 uses BLUE land effects estimates instead of OSCAR, and 12 uses H&R 2017 land effects estimates.

Also, based on advice from Clemens Schwingshackl, I changed global.1751_2021.ems11.* to use BLUE data from
Global_Carbon_Budget_2022v1.0_mod1.xlsx instead of National_LandUseChange_Carbon_Emissions_2022v1.0_mod1.xlsx
for the years 1959 - 2021.