June24-Data-Uploads

[cthomasONRR]

:sunglasses: PREVIEW

Changes proposed in this pull request:

• May 24 monthly revenue
• Feb 24 monthly production
• Feb 24 monthly OGOR-B

[cthomasONRR]

Production Monthly

• [x] Make sure the downloaded data matches the raw data. Raw data saved here (Insert Teams link to raw file)

Homepage - Yearly Breakdown

• Select a year and verify the amounts and comparisons are correct for the conditions below. Repeat with the most recent year.
  • [x] Period - Fiscal Year
  • [x] Period - Calendar Year
  • [x] Commodity - Oil (bbl)
  • [x] Commodity - Gas (mcf)
  • [x] Commodity - Coal (tons)

Homepage - Monthly Breakdown

• Select a month and verify the amounts and comparisons are correct for the conditions below. Repeat with the most recent month. Be sure to verify negative numbers are correct if applicable
  • [x] Period - Most recent 12 months
  • [x] Period - Fiscal Year
  • [x] Period - Calendar Year
  • [x] Commodity - Oil (bbl)
  • [x] Commodity - Gas (mcf)
  • [x] Commodity - Coal (tons)

Homepage - Source File

• [x] Check source file links are correct.

Query Data - In the 'Period' category, filter to 'Monthly' and check the following:

• [x] One Land Type filter
• [x] One to three Products
• [x] Downloads matches filtered data

Download Page

• [x] Dates and file size are correct for csv and excel

Monthly Snap Shot

• [x] Check graphs match homepage

[cthomasONRR]

Revenue Monthly

• [x] Make sure the downloaded data matches the raw data. Raw data saved here (Insert Teams link to raw file)

Homepage - Yearly Breakdown

• Select a year and verify the amounts and comparisons are correct for the conditions below. Repeat with the most recent year.
  • [x] Period - Fiscal Year
  • [x] Period - Calendar Year
  • [x] Breakout - Source
  • [x] Breakout - Revenue Type
  • [x] Breakout - Commodity

Homepage - Monthly Breakdown

• Select a month and verify the amounts and comparisons are correct for the conditions below. Repeat with the most recent month. Be sure to verify negative numbers are correct if applicable
  • [x] Period - Most recent 12 months
  • [x] Period - Fiscal Year
  • [x] Period - Calendar Year
  • [x] Breakout - Source
  • [x] Breakout - Revenue Type
  • [x] Breakout Commodity

Homepage - Source File

• [x] Check source file links are correct.

Query Data - In the 'Period' category, filter to 'Monthly' and check the following:

• [x] One Land Type filter
• [x] One Revenue Type filter
• [x] One State
• [x] One Offshore Region
• [x] One to three Commodities
• [x] Clear All and change grouping
• [x] Downloads matches filtered data

Download Page

• [x] Dates and file size are correct for csv and excel

Monthly Snap Shot

• [x] Check graphs match homepage

[lpgoldstein]

Disbursements Monthly @lpgoldstein

• [x] Make sure the downloaded data matches the raw data. Raw data saved here (Insert Teams link to raw file)
  • Note: Make sure both datasets have the same sum. If there are line items that have the same fund type, revenue type, and location, they will be 'rolled up' together so the line item count may differ between the raw data and downloaded data.
• [x] Check Treasury Fund column is deleted
• [x] Check Hidalgo Caounty is changed to Hidalgo County under county column
• [x] Check "BLM - Permit Processing and Improvement" is changed to to "Lease Processing and Improvement" (BLM) under fund type column

Homepage - Yearly Breakdown

• Select a year and verify the amounts and comparisons are correct for the conditions below. Repeat with the most recent year.
• [x] Breakout - Source
• [x] Breakout - Recipient

Homepage - Monthly Breakdown

• Select a month and verify the amounts and comparisons are correct for the conditions below. Repeat with the most recent month. Be sure to verify negative numbers are correct if applicable
  • [x] Period - Most recent 12 months
  • [x] Period - Fiscal Year
  • [x] Period - Calendar Year
  • [x] Breakout - Source
  • [x] Breakout - Recipient

Query Data - In the 'Period' category, filter to 'Monthly' and check the following:

• [x] One Recipient
• [x] One Source
• [x] One State
• [x] One to three Commodities if applicable
• [x] Clear All and change grouping
• [x] Downloads matches filtered data

Download Page

• [x] Dates and file size are correct for csv and excel

Monthly Snap Shot

• [x] Check graphs match homepage