Data enrichment for State of Utah Travel hotel stay data.
Hotel stay data is provided on a quarterly basis. It is loaded as a Sheet to a shared source data Google Drive folder.
- Hotel stay sheet must be downloaded as a csv.
- Path to stay csv is provided when running perdiem.py
- perdiem.py will produce output csv with federal and state perdiem hotel rates added.
- You can confirm non-Utah rates at GSA perdiem lookup
- Confirm Utah rate in utah_rates.csv
- Output csv must be loaded to results Drive folder
- Convert csv to Google sheet if it was not converted automatically.
- Confirm ARRAYFORMULA's in first row have evaluated.
- The formulas may need to be deleted from the cell and re-added to evaluate :man-shrugging:.
- Email interested parties to notify results are ready.
Every new Utah fiscal year Travel produces new Utah per diem rates. They will be provided by State Travel and must replace utah_rates.csv