scale ferc data to level of depreciation data - Githubissues

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

scale ferc data to level of depreciation data #58

Closed cmgosnell closed 3 years ago

cmgosnell commented 3 years ago

every depreciation record should have appropriately scaled ferc data associated with it.

FERC1 data points to scale:

[x] operational costs - non fuel
[x] net generation

Different scaling processes for different matching methods:

[x] Truly the same record: just pull on over the FERC data points.
[x] Same record, except for the ownership level (owned/total): ...
[x] Same qualifier ids, depreciation record is smaller: ...
[x] Same qualifier ids, depreciation record is larger: ...

[ ] Only one FERC option to match to (we have none of these right now):
- [ ] Depreciation record is at a smaller level: ...
- [ ] Depreciation record is at a larger level: ...

cmgosnell commented 3 years ago

I need a convention for dealing with the origins and associations of all of these data columns. I have three main data sets:

the master unit list (from EIA)
the depreciation study records
the ferc1 steam table records

Both depreciation and ferc1 records are associated with master unit list records and data columns. But ferc1 records also have their own data columns (sometimes with the same names e.g. capacity_mw).

Through working on this issue, I need to associated ferc1 steam data columns with depreciation records.