Chris,

Per our conversation, the following table shows four storage inventories that we need to track/compute/report, etc.


Background

The west desk currently displays storage balances on several of the morning reports.  These balances are not reported by the respective pipelines, however, each day the injections and withdrawals are available.  In the past, our excel spreadsheets have tracked the running balances by simply adding the current daily activity to the prior day's balance.  As we get validation of the balances through phone calls, and/or postings, we tweak the balances to maintain an accurate representation.  Currently, our reporting/storage system does not allow us to make these balances available on our reports.

Task

Synthesize the currently used method of displaying storage balances for the storage facilities shown on the following table.  It is our intent to have a DRN established (and some already have been created) that would hold the storage balance each day.  However, this requires that a calculation be executed to determine the value to be placed in the database.  One possibility is to have the scraping script make the necessary calculation and store the new storage balance each time the pipeline is scraped.  Another possibility is to incorporate the ability to do these calculations in the report, while a third option is too keep a spreadsheet with storage balances that queries the database for the daily activity.  Lastly, these storage balances could be manual entry points, but would require manual calculation each day (representing a lower level of performance than the existing system for this feature).

Timeline

This is a necessary feature before transitioning from the current spreadsheets.  At a minimum, we need to have temporary system in place before the end of the week.  Although, we do not have a final date for transitioning, we see this as one of a few critical tasks.


Mat


 

<Embedded Microsoft Excel Worksheet>