Peer Reviewing and Updating the Data

Please follow these steps for peer reviewing when receiving new monthly files and combining the new numbers with the old numbers.

1. New source file (file comes from DORC team) : copy the data and note the number of lines copied. For the production monthly file, copy all the months. For the revenue monthly file, copy most recent month.

2. Combined source file (file comes from DORC and NRRD download): note the total number of lines before pasting the new data.

3. Paste the new data to the combined source file.

4. After pasting, check the new total number of lines is adding up to the previous total number of lines (step 2) plus the new number of lines added (step 1).

5. Check the dates format is consistent.

6. Check the non-date cells to make sure that they are formatted correctly.

7. Check all the columns were pasted correctly.

8. Check the sum of the revenue/volume columns match.

9. Save the new combined source file.

Instructions for updating the data are described in each of the dataset-specific subdirectories under the data directory.

Data file names:

• production_volumes.xlxs - Monthly Production Volumes for Oil, Gas, and Coal

Updating Data on the NRRD website with excel files:

1. Review file and ensure the following names match:
   • File Name
   • Sheet Name
   • Column Names
   • Data values that are strings (Example: Onshore, Offshore, Oil & Gas, etc...)
2. Open Github Desktop or other favorite tool
3. Switch to dev branch and pull the latest changes
4. Create a new branch in our github repository from the dev branch
5. Update the excel file with the new file
   • Files are currently located in \doi-extractives-data\gatsby-site\src\data-graphql
6. Commit Changes
7. Push Changes
8. Review Changes on Federalist
9. If changes look correct, create a pull request to merge the branch into dev and add your reviewers
10. Once approved merge the changes