Missing Canadian Exports for 2021 and beyond

[dt-woods]

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).

[dt-woods]

There are six states that show up in the latest Export Sales workbook that are not included in the 2020 destination map. They are:

• Illinois
• Missouri
• South Dakota
• Oklahoma
• Maryland
• Arkansas

Proposed mappings of primary BA target (and secondary targets):

• Illinois: MISO (PJM)
• Missouri: AECI (MISO, SWPP)
• South Dakota: SWPP (MISO, WACM)
• Oklahoma: SWPP
• Maryland: PJM
• Arkansas: MISO

The mappings between US states and balancing authorities was based off inspection using this visualization tool.