Closed eelzi-ONRR closed 5 months ago
@cthomasONRR @lpgoldstein Rechecked using the 3 other spreadsheets. The same error exists on all fact sheets. For FY23/22 I used the PDFs in the Teams folder, for all others I used the PDFs on the live site
FY 2018 - Revenue says 12 states/regions but only 11 listed on data check sheet FY 2019 - Revenue says 11 states/regions but only 10 listed on data check sheet FY 2020 - Revenue says 11 states/regions but only 10 listed on data check sheet FY 2021 - Revenue says 11 states/regions but only 9 listed on data check sheet FY 2022 - Revenue says 11 states/regions but only 10 listed on data check sheet FY 2023 - Revenue says 11 states/regions but only 10 listed on data check sheet
@eelzi-ONRR @lpgoldstein
I looked into this this morning. For Revenue-Geothermal, "(blank)" is considered a location in the check sheet. This "(blank)" is for the Native American localities that are intentionally omitted from the data.
The FY21 was indeed really off by one. I checked and the file in the OneDrive location was correct but the file on the NRRD site wasn't. I made sure these 2 files match
Example with 2018. There are 12 localities, which includes Native American as one locality:
@cthomasONRR Can I close this issue then?
@eelzi-ONRR I think so, thanks for your help. It's always good to have a second set of eye on the data.
@cthomasONRR @lpgoldstein let me know if I'm not reviewing these correctly. I didn't include the things from FY22 that Christine marked as being changed with the April PR
FY21 - pdf says 11 states, spreadsheet says 10 FY21 - none of the geothermal production numbers match the spreadsheet FY20 - only some of the geothermal production numbers match the spreadsheet FY18 - factsheet says 12 locations, spreadsheet says 11, wind and geothermal percentages don't match the spreadsheet, state vs treasury percentages don't match spreadsheet, geothermal production numbers don't match spreadsheet