Calorific value data

Staffordian11

Can anyone please explain how I can find CV figures I can use when calculating my gas cost?

Specifically I could do with an average figure for each calendar month as I read meters and calculate gas and electricity costs on this basis.

I can see something on the National Grid website, termed data item explorer and can download some spreadsheet data, but it seems rather complex and lists values for what seem to be individual gas fields on a daily basis.  I can see nothing which gives a figure for gas supplied to specific UK geographical areas (West Midlands being what I need).

I'm guessing if I find the correct data it will be daily and I'll need to take an average of that to get a figure for the month, is that correct? But first, I need to find the data...

Thanks in advance for any pointers.

molerat

You are looking in the right place. The data is listed by your Local Distribution Zone.  Download it into Excel in CSV format for the dates required and average it. LDZ(WM) is the one you need. Set the Criteria to Applicable For

Applicable At	Applicable For	Data Item	Value	Generated Time	Quality Indicator
###########	27/10/2022	Calorific Value, LDZ(WM)	39.6	27/10/2022 10:33
###########	26/10/2022	Calorific Value, LDZ(WM)	39.6	27/10/2022 10:33
###########	26/10/2022	Calorific Value, LDZ(WM)	39.5	26/10/2022 10:33
###########	25/10/2022	Calorific Value, LDZ(WM)	39.6	26/10/2022 10:33
###########	25/10/2022	Calorific Value, LDZ(WM)	39.4	25/10/2022 10:33
###########	24/10/2022	Calorific Value, LDZ(WM)	39.5	25/10/2022 10:33
###########	24/10/2022	Calorific Value, LDZ(WM)	39.4	24/10/2022 10:32

Staffordian11

molerat said:

You are looking in the right place. The data is listed by your Local Distribution Zone.  Download it into Excel in CSV format for the dates required and average it. LDZ(WM) is the one you need. Set the Criteria to Applicable For

Applicable At	Applicable For	Data Item	Value	Generated Time	Quality Indicator
###########	27/10/2022	Calorific Value, LDZ(WM)	39.6	27/10/2022 10:33
###########	26/10/2022	Calorific Value, LDZ(WM)	39.6	27/10/2022 10:33
###########	26/10/2022	Calorific Value, LDZ(WM)	39.5	26/10/2022 10:33
###########	25/10/2022	Calorific Value, LDZ(WM)	39.6	26/10/2022 10:33
###########	25/10/2022	Calorific Value, LDZ(WM)	39.4	25/10/2022 10:33
###########	24/10/2022	Calorific Value, LDZ(WM)	39.5	25/10/2022 10:33
###########	24/10/2022	Calorific Value, LDZ(WM)	39.4	24/10/2022 10:32

Thank you, much appreciated!

Staffordian11

molerat said:

You are looking in the right place. The data is listed by your Local Distribution Zone.  Download it into Excel in CSV format for the dates required and average it. LDZ(WM) is the one you need. Set the Criteria to Applicable For

Applicable At	Applicable For	Data Item	Value	Generated Time	Quality Indicator
###########	27/10/2022	Calorific Value, LDZ(WM)	39.6	27/10/2022 10:33
###########	26/10/2022	Calorific Value, LDZ(WM)	39.6	27/10/2022 10:33
###########	26/10/2022	Calorific Value, LDZ(WM)	39.5	26/10/2022 10:33
###########	25/10/2022	Calorific Value, LDZ(WM)	39.6	26/10/2022 10:33
###########	25/10/2022	Calorific Value, LDZ(WM)	39.4	25/10/2022 10:33
###########	24/10/2022	Calorific Value, LDZ(WM)	39.5	25/10/2022 10:33
###########	24/10/2022	Calorific Value, LDZ(WM)	39.4	24/10/2022 10:32

I see there are multiple entries for some days, sometimes just a few seconds apart.  Is a simple average of all these individual entries calculated, regardless of how many there are per day or how far apart they are, or should they be weighted depending on the time difference between entries?

Raxiel

It's a while since I looked at this, but my recollection is it's the average over the specific billing period, truncated to 1 decimal place (effectively rounded down).

molerat

I find it works averaging across all of them, it rarely alters the truncated to 1 decimal place value.

Staffordian11

Thanks both.  Guess I'm overthinking it!