INT176 - Gas Composition Data
|
Trigger type |
Time triggered |
|
Published |
Sunday at 10:47 |
|
Audience |
Public |
|
Output file name |
int176_v[n]_gas_composition_data_[p]~yyyymmddhhmmss.csv |
Report purpose
This public report provides the gas composition daily average corresponding to the heating value zone.
Audience notes
The gas composition daily average in the report has taken into account the total delay hours from the injection source to the heating value zone. Therefore, the HV High voltage is always published one day in arrears.
The data in this report applies to the VIC wholesale gas market.
Content notes
All gas composition values used in the daily average calculation are taken as at top of hour.
This report contains data for the past 60 gas days (such as, 60 gas days less than report date).
Only the Victorian heating value zones are included in this report.
Gas composition values are in molecule percentage units, except for Specific Gravity (which does not have a unit).
Gas composition data will be reported to 5 decimal places.
The gas composition daily average is calculated using the following formula:
- SUM(hourly gas composition values) / COUNT(hours)
- Where hours is the number of hours used to calculate the total gas composition for the day
- Where no value is available for an hour, the report skips the hour in the calculation and continues on to the next hour. If no hourly values are available for the entire day, a NULL is displayed.
Data content
|
Name |
Data Type |
No Nulls |
Primary Key |
CQ |
Comments |
|---|---|---|---|---|---|
|
hv_zone |
integer |
True |
True |
N |
Heating value zone number as assigned by the AEMO. Values for Victoria can be in the range of 400-699 |
|
hv_zone_desc |
varchar(254) |
True |
False |
N |
The heating value zone |
|
gas_date |
varchar(20) |
True |
True |
N |
The gas date (e.g. 30 Jun 2011) |
|
methane |
numeric(9,5) |
False |
False |
Y |
The daily average of methane |
|
ethane |
numeric(9,5) |
False |
False |
Y |
The daily average of ethane |
|
propane |
numeric(9,5) |
False |
False |
Y |
The daily average of propane |
|
butane_i |
numeric(9,5) |
False |
False |
Y |
The daily average of butane |
|
butane_n |
numeric(9,5) |
False |
False |
Y |
The daily average of butane (N) |
|
pentane_i |
numeric(9,5) |
False |
False |
Y |
The daily average of pentane |
|
pentane_n |
numeric(9,5) |
False |
False |
Y |
The daily average of pentane (N) |
|
pentane_neo |
numeric(9,5) |
False |
False |
Y |
The daily average of pentane (Neo) |
|
hexane |
numeric(9,5) |
False |
False |
Y |
The daily average of hexane |
|
nitrogen |
numeric(9,5) |
False |
False |
Y |
The daily average of nitrogen |
|
carbon_doxide |
numeric(9,5) |
False |
False |
Y |
The daily average of carbon dioxide |
|
hydrogen |
Numeric(9,5) |
False |
False |
Y |
The daily average of hydrogen. If no hourly values are available for the entire day, NULL is displayed. |
|
spec_gravity |
numeric(9,5) |
False |
False |
Y |
The daily average of specific gravity |
|
current_date |
varchar(20) |
True |
False |
N |
The date and time the report is produced (e.g. 29 Jun 2012 01:23:45) |