singularity-energy / open-grid-emissions

Tools for producing high-quality hourly generation and emissions data for U.S. electric grids
MIT License
67 stars 4 forks source link

feat: update EIA-930 manual adjustments #328

Closed rouille closed 6 months ago

rouille commented 6 months ago

Purpose

Update manual adjustments of timestamps in EIA-930 data. More specifically, the timestamps for the TEPC-ALL and IID-CISO interchange timeseries have been updated. No changes in the already adjusted generation timeseries and in the sign of the interchange.

What the code is doing

Shift timestamps to fix observed in time series. The identify_eia930_time_lags notebook has been used to identify the lags.

Testing

N/A

Where to look

Changes are in the eia930 module

Usage Example/Visuals

TEPC-ALL lag (7 hours):

TEPC-SRP TEPC-WALC Lag start 10/25/2021

IID-CISO lag (4 hours):

IID-CISO_2021 IID-CISO_2022 Lag occurs in 2021

Lag table:

# TEPC
|      |   all_years |   2021 |   2022 |   daylight savings |   standard time |
|:-----|------------:|-------:|-------:|-------------------:|----------------:|
| AZPS |           6 |      0 |      7 |                  1 |               7 |
| EPE  |           7 |      0 |      7 |                  1 |               7 |
| PNM  |           7 |      0 |      7 |                  7 |               7 |
| SRP  |           6 |      0 |      7 |                  4 |               7 |
| WALC |           7 |      0 |      7 |                  7 |               7 |

# IID
|      |   all_years |   2021 |   2022 |   daylight savings |   standard time |
|:-----|------------:|-------:|-------:|-------------------:|----------------:|
| AZPS |           0 |      0 |      0 |                  0 |               0 |
| CISO |           1 |      4 |      0 |                  1 |               0 |
| WALC |           0 |      0 |      0 |                  0 |               0 |

Review estimate

15min

Future work

N/A

Checklist

rouille commented 6 months ago

@grgmiller, here are the plots after updating the eia930_raw.csv with changes in the manual_930_adjust function (see commit #762d5d9)

TEPC-SRP

TEPC-SRP As you can see there is no shift before and after 10/25/2021

IID-CISO

IID-CISO_2021 IID-CISO_2022 No shift in 2021 and 2022

I have added the notebook to this PR. Outputs have been cleared.