Spreadsheet?

elyena

I'm probably being very thick here but I've heard several people talking about using a spreadsheet to calculate electricity/gas bills.
How is this done? Is there a template or have you set it up yourself?

Thanks Eleyna

Newcroft

Elyena,

I will send you a personal message and explain. Should you wish, I can also prepare a spreadsheet and send it to you.

Newcroft

Lil306

elyena wrote: »

I'm probably being very thick here but I've heard several people talking about using a spreadsheet to calculate electricity/gas bills.
How is this done? Is there a template or have you set it up yourself?

Thanks Eleyna

Most people probably use a template or knock them up themselves

Any spreadsheet can do all the calculations for you as long as you know the values to enter

For electricity you would just use a formula to calculate at a certain rate up to a certain usage, then another rate to calculate another.

I don't have one myself but imagined it would be easy to knock up if I had all the data at hand.

My problem is usually working out how to input the formulas so it calculates correctly

phildo_2

Just knock them up as needed. I seem to have spreadsheets for everything. Gas/Leccy, mortgage, car finance, water usage...
Basic idea is to build a model that can cover all variables and has just a few cells that you update/change for the rates and usage. This is an example of mine.
I enter the usage in KwH (16500 & 2400) and the rates (6.53,3.16,21.29 & 10.11). There is no standing charge so that stays at zero but there are variable discounts applied to whole bill so i enter the 24.5%. The values for the low use units (2680 & 900) are the quarterly figs x 4 and the figs for normal units (13,820 & 1,500) are the total usages minus the low use units these are formulas. Everything else is formulas and casts down to the total. This can be used for vast majority of tariffs and is accurate to within a few pence.

16500 2400 EON Fixonline v7 gas ele Low 2,680 900 Normal 13,820 1,500 Low 6.53 21.29 Normal 3.16 10.11 Standing Charge 0 0 Low £ 174.87 191.65 Normal £ 436.44 151.68 Total £ 611.31 343.33

954.63 % discounts 24.5% - 233.88 Fixed discount
-
720.75 pcm 60.06

phildo_2

Sorry, thought that I'd be able to insert an image of an excel table! Clearly not. I can send you if you want?

elyena

phildo wrote: »

Sorry, thought that I'd be able to insert an image of an excel table! Clearly not. I can send you if you want?

That would be great. Trying to get my head around all this and getting very confused. Not that it takes much these days....

phildo_2

I can't add a spreadsheet in a PM either :mad:.
PM me with an email address and I'll send there if you like.