Confused how my energy supplier estimates forward my annual consumption

vintage36

Board Regular
Joined
Nov 29, 2011
Messages
58
My energy supplier’s monthly statements give an estimate of my annual use. This, of course changes month to month. In the 12 months prior to joining them gas consumed was 15000 kWh +/- say 200 in all.
Readings with the new supplier:
START
END
DAYS
kWh
Supplier kWh
forecast
04-May​
29-May​
26​
568.7​
14370​
30-May​
01-Jul​
33​
252.8​
14634​
02-Jul​
01-Aug​
31​
190.6​
14910​
02-Aug​
31-Aug​
30​
190.1​
14761​
01-Sep​
30-Sep​
30​
254.7​
14607​
01-Oct​
31-Oct​
31​
1232.2​
14013​
I fail to see how they arrive at those figures. Does anyone have ideas?
 

Excel Facts

Square and cube roots
The =SQRT(25) is a square root. For a cube root, use =125^(1/3). For a fourth root, use =625^(1/4).
Suppliers base their forecasts on
1) your usage pattern, including recent trends and seasonal trends for your abode
2) the usage patterns in your neighborhood
3) the usage patterns in your city and province, especially as they relate to weather forecasts, both medium-term and seasonal
4) proprietary algorithms.

So you'll never suss it out.
 
Just for anyone's info and interest. Here is a paraphrase of a reply I received.
Rich (BB code):
The annual estimates aren't set directly by the energy supplier. The supplier has to forward any customer reading to a data collector who aggregates the last three years worth of readings and averages this down to 1 year. 
 My informant does not know the actual formula, but is aware that the more recent readings have greater weighting.
 

Forum statistics

Threads
1,224,946
Messages
6,181,939
Members
453,074
Latest member
JefersonKollet

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top