Missing Canadian Exports for 2021 and beyond

Background There are three CSV data files provided with eLCI representing Canadian electricity trade summaries:

CA_Imports_Gen.csv
- annual total MWh exported by each Canadian balancing authority
CA_Imports_Cols.csv
- the annual MWh in trades between specific Canadian and US balancing authorities
CA_Imports_Rows.csv
- just an empty row, col matrix pairing the Canadian and US balancing authorities

These files are referenced in eia_io_trading.py.

https://github.com/USEPA/ElectricityLCI/blob/2232c41f2cb4fd333ad59c8710aa55906e6a7ed3/electricitylci/eia_io_trading.py#L188

Issue These datasets are missing entries for 2021 and beyond.

Potential Solution A Microsoft Excel workbook is available here, which provides the Canadian exports, similar to those used to generate these CSV files.

A mapping is required between Canadian provinces and their BA names and the destinations and their BA names. Example mapping is provided from the 2018–2020 updates (in a separate workbook).

Additional context There seems to be three datasets used in this module.

EIA bulk US Electric System Operating Data (df_net_gen)
- Imports to US
EIA 923 + EIA 860 (eia_gen_ba)
- US generation
Canadian Electricity Trade Summary (df_CA_Imports_Gen)
- Canada to US exports

Imports and exports are mixed together (df_net_gen_sum).

It seems that the Canadian export data to US is used to compare against EIA 923 generation data (I think it's comparing to the Canadian destination BA area's generation). The difference between Canadian export to BA and BA generation is calculated.

It seems that the mean absolute difference between all export and generation amounts is used as threshold value to trigger a swap (I believe the EIA generation is used in place of the Canadian export).

USEPA / ElectricityLCI

Missing Canadian Exports for 2021 and beyond #236