Instructions for the nightly check

readme.md

1. From the graham-db website (link: https://graham-db.herokuapp.com/#), execute the query:

   select * from realtime_sync.supply_nightly_opis_price_review_v2; 

2. Export the results of this query to CSV and the file will open in Excel in a file named something like pgweb-8328742.csv

3. From the exported csv file in step 2, copy columns A and B into the FOB Template Excel File on the sheet named actual_rank in the columns A and B

4. Columns C and D will autopopulate as the formulae reflect the newly pasted values

5. Copy the price and the mkt_rank columns from the pgweb export file (step 2) into FOB Template Excel File on the sheet named actual_rank columns E and F

6. Navigate to the tab named "fob", the ranks should now be up to date. Handle any values which were not mapped by the VLOOKUP

   1. These error records should have cells that say something like "Missing Key Do Manually"
   2. After review and the final cleaning of the Actual rank values, the data should be ready to paste onto the FOB Terminal Pricing Google Sheet