Here is an Excel spreadsheet which will help you to work out the cost of your energy and water consumption. You can input your bills and meter readings and it will draw charts showing your daily and weekly consumption of WATER, GAS and ELECTRICITY.
Have a look at this typical example It has five pages:-
If you want to input your own readings download this blank version which has all the meter readings removed. Its best to input daily readings for the first week so you can see how your consumption varies throughout the week and where the problem areas are. After that its usually good enough to take weekly readings. When you have taken a few readings its a good idea to do an audit of all your devices to find out which ones are wasting the most money. Work out the consumption of each device separately and add them all up. The total should match the difference between your weekly meter readings. The APPLIANCES page is useful for doing the audit.