Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

determine why rate base assets are smaller than liabilities in leafy exploded table #3404

Closed
cmgosnell opened this issue Feb 16, 2024 · 1 comment · Fixed by #3450
Closed
Assignees
Labels
analysis Data analysis tasks that involve actually using PUDL to figure things out, like calculating MCOE. data-validation Issues related to checking whether data meets our quality expectations. ferc1 Anything having to do with FERC Form 1

Comments

@cmgosnell
Copy link
Member

possible weirdness?

is it the sub-totals not having corrections?
is it that the tags aren't full propagating?
should there be sign differences within the liabilities or asset tables?
did we do soemthing wrong/weird with the plant in service table calcs & sign changes?
Are we canceling out the calced value if the reported value is null but we have leafy/child data?

ways to determine what's going wrong?

  • look at a few utilities?
  • check if the total liabilites (root) is the sum of the leafy liabilities? NO!
  • check if most of the correction records are ending up in the outputs? NO! & they have different dimension values. looks like when we assigned dim="total" this isn't propagating into the correction records...
@cmgosnell cmgosnell self-assigned this Feb 16, 2024
@cmgosnell cmgosnell converted this from a draft issue Feb 16, 2024
@zaneselvans zaneselvans added ferc1 Anything having to do with FERC Form 1 analysis Data analysis tasks that involve actually using PUDL to figure things out, like calculating MCOE. data-validation Issues related to checking whether data meets our quality expectations. labels Feb 24, 2024
@cmgosnell cmgosnell moved this from Backlog to In progress in Catalyst Megaproject Mar 6, 2024
@cmgosnell
Copy link
Member Author

Okay so the vast majority of the problem here was just from one hard-coded old table name

image
image

There is still the 2021 problem but i'm addressing that over in #3309

@cmgosnell cmgosnell moved this from In progress to In review in Catalyst Megaproject Mar 12, 2024
@github-project-automation github-project-automation bot moved this from In review to Done in Catalyst Megaproject Mar 27, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
analysis Data analysis tasks that involve actually using PUDL to figure things out, like calculating MCOE. data-validation Issues related to checking whether data meets our quality expectations. ferc1 Anything having to do with FERC Form 1
Projects
Archived in project
2 participants