The following table shows the various formula options for the calculations available in the GCM.
| Inputs to Calculations | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| GCM Calculation | Formula Options | Formula Breakdown |
|
|
|
|
|
|
|
|
|
|
N/A |
AccumDelta = (Daily Projection) – (Nomination) |
|
|
|
|
||||||
|
Accumulated Delta Percentage |
N/A |
AccumDeltaPercentage = (Daily Accumulated / Nomination) * 100 |
|
|
|
||||||
|
N/A |
AvgHourlyAccumulation = Average of Historical Hourly Flows in VHS |
|
|
||||||||
|
Daily Accumulated |
If Perform predictive calculations using only complete hours is checked, the Formula has no effect. |
DailyAccum = Sum(Hourly Volumes in VHS) |
|
|
|
||||||
|
If Perform predictive calculations using only complete hours is not checked and the Formula = Sum Hourly History. |
DailyAccum = Sum(Hourly Volumes in VHS) + ((Hours Elapsed Since Beginning of Hour) * (Value of Last Full Hourly Volume in VHS)) |
|
|
||||||||
|
If Perform predictive calculations using only complete hours is not checked and the Formula = Sum Hourly History + Current Hour. |
DailyAccum = Sum(Hourly Volumes in VHS) + (((Minutes Elapsed Since Beginning of Hour) / (Minutes Represented by CVS Value Timestamp)) * (CVS Value)) |
|
|
|
|||||||
|
Use Last Hour Accum (from History) |
DailyProjection = DailyAccum + ((Last Historical Value in VHS) * (Hours Left in Day)) |
|
|
|
|||||||
|
Use Last Hour Accum (from CVS) |
DailyProjection = DailyAccum + ((Last Hour Flow in CVS) * (Hours Left in Day)) |
|
|
|
|||||||
|
Use Current Flow |
DailyProjection = Daily Accum + ((Instantaneous Flow Rate) * (Hours Left in Day)) |
|
|
|
|||||||
|
Use Flow Rate History |
Iterates the history of the instantaneous flow rate point in the VHS, which should contain an entry for each flow rate change. It then sums up the flow per hour and writes an hourly volume to the VHS under the historical volume point. For more information, see Command Parameters. |
|
|
||||||||
|
Use Daily Accum History |
Iterates the history of the daily accumulated point in the VHS, which should contain an entry for each value poll. The value should start at zero at the beginning of the day and slowly increase throughout the course of the day. It then breaks out the flow per hour and writes an hourly volume to the VHS under the historical volume point. For more information, see Command Parameters. |
|
|
||||||||
|
Use Last Hour Accum (from History) |
AccumPerHour = (Last Historical Value in VHS) AccumToGo = Nomination – DailyAccum HoursToGo = AccumToGo / AccumPerHour NominationMetTime = Now + HoursToGo |
|
|
|
|
||||||
|
Use Last Hour Accum (from CVS) |
AccumPerHour = (Last Hour Flow in CVS) AccumToGo = Nomination – DailyAccum HoursToGo = AccumToGo / AccumPerHour NominationMetTime = Now + HoursToGo |
|
|
|
|
||||||
|
Use Current Flow |
AccumPerHour = (Instantaneous Flow Rate) AccumToGo = Nomination – DailyAccum HoursToGo = AccumToGo / AccumPerHour NominationMetTime = Now + HoursToGo |
|
|
|
|
||||||
|
N/A |
FlowDelta = (Instantaneous Flow Rate) – (Rate-To-Go) |
|
|
|
|
||||||
|
Linear |
RateToGo = (Nomination - DailyAccum) / (Hours Left in Day) |
|
|
|
|||||||
* This input changes depending on the Commodity Type selected on the Settings page. Natural gas calculations use Energy Density as an input (Volume * Energy Density yields Energy); Liquids calculations use Gravity as an input (Volume * Gravity yields Mass).