OVERVIEW

Purpose: Displays natural gas trends based on running 3 year average. Reset trends each fiscal year. Also includes cost which is monthly fixed cost, a daily cost input component, and the monthly hedge price. Also allows for parameter input of annual escalation.

Link: https://fs-tableau.uoregon.edu/#/views/NatGasTracker/GasTrackerDB

End User: Boz Van Houten

CONTACT US

• FASS@uoregon.edu

• 541-346-2455

• FASS SERVICE PORTAL

• Finance and Administration Shared Services website

DETAILS

Date Created: 3/1/2020

Created By: Alex Koleber

Approved By: Justin Porter

Notes / Assumptions:

• As of 3/27/2020, the cost component does not yet include the daily cost of gas, that will need to be input manually via MS Access form or ingested from 3rd party API.

TECHNICAL NOTES

Platform: Tableau

Data Source: NWN AMR daily .csv files sent from NW Natural stored here: H:\Departments\CPS\Energy Management Program\06-Procurement\Gas (NWN & IGI)\NWN AMR

CHANGE LOG