Huge rise in energy since move

Nooglienoo

Talldave said:

It is really easy in Excel. For gas, my kWh entry in cell R48 is: =(P48*Q48*1.02264)/3.6, where cell P48 is the gas used in m3 and cell Q48 is the calorific value (which I get off the bills, currently 39).  Cell P48 contains: =E48-E47, column E contains the meter readings, so that's effectively current reading minus last reading.  For electricity you just subtract meter readings which are already in kWh. All the formulae are relative so can be drag copied.  Then you can plot pretty graphs.....

"Its really easy" what you said might as well have been Arabic to me! I take pride in perplexing my colleagues with my photoshop skills but I leave Excel to the business analysts. (Who by the way can do incredible things with Excel I had no idea was possible.) I'm definitely going to track my meter readings - but I think I'll skip the spreadsheets 

matelodave

Have a shufti to see if there's an Android or Apple app that'll let you do it on your mobile device - I'm sure that someone must have put summat together

macman

Or simply multiply by either 11 or 31 to get a 'near enough' result...