catalyst-cooperative / rmi-ferc1-eia

A collaboration with RMI to integrate FERC Form 1 and EIA CapEx and OpEx reporting
MIT License
3 stars 3 forks source link

check if O&M exists in ferc1 small and hydro plants tables #216

Closed cmgosnell closed 2 years ago

cmgosnell commented 2 years ago

Made this issue because the RMI Optimus formatted table has a field called Total O&M Cost that only seems to have info for steam plants (none of the wind/renewables etc.) This issue is to investigate why

aesharpe commented 2 years ago

Ok, so the RMI Optimus formatted table is reading from the all_plants_ferc1() table because that table is already being used to create the ferc1_to_eia table which feeds into the Optimus formatted table. The issue here seems to be column alignment within the all_plants_ferc1 table.

The Optimus formatted table has a field called Total O&M Cost that is a copy off the ferc1 column opex_nonfuel. This column can be found in the ferc1_steam_plants table, but none of the other plant tables (hydro, pumped storage, small gens).

My proposal is to calculate the opex_nofuel value for the other FERC tables by using the following equations:

Because neither hydro nor pumped storage units require fuel payment, it can be reasonably assumed that the nonfuel opex is equivalent to the total opex.

This should probably be continued as an issue in the PUDL repo

aesharpe commented 2 years ago

See #1619