Costs of Equipment

allroundgoodguy

I have done a spreadsheet for the costs of running items in the home, and putting them on stanby.
My new rule of thumb is, whatever the watts, that will be £1 per year if constantly left on. No of Watts x £1 per year.
50" Plasma 300watts =£300 per year!

Sorry the formatting doesn't work, can any Mods help in that? I lost the will to live changing it!
I sorted by cost per year, to target the biggest energy guzzlers.

There are some gaps, because my equipment didn't say or I've not got the manual.
Can anyone hlep fill the gaps?



Item……………………Cost p.a...Watts..Hrs/day..W/d..W/yr.....kwh p/a.Cost
Freezer…………………..£96.36.. .110....24........2640...963600..963.6....0.10
TV plasma 50"…………£58.40...400.....4........1600.....84000..584.0....0.10
Kettle……………………..£54.75..3000...0.5.......1500....547500..547.5....0.10
Video/DVD…............£40.30.....46...24........1104....402960..403.0....0.10
Microwave……………….£18.25..1000..0.5.........500....182500..182.5....0.10
Light bulb 100W………… £18.25 100 5 500 182500 182.5 £0.10
Light spot 100W………… £18.25 100 5 500 182500 182.5 £0.10
TVplasma per hr………… £14.60 400 1 400 146000 146.0 £0.10
Alarm clock……………… £13.14 15 24 360 131400 131.4 £0.10
Light bulb 60W £10.95 60 5 300 109500 109.5 £0.10
Light bulb 12 EnergyW…. £2.19 12 5 60 21900 21.9 £0.10
Video per hr……………… £1.68 46 1 46 16790 16.8 £0.10
TV plasma standby…….. £0.92 1.1 23 25.3 9234.5 9.2 £0.10
PC…………………………. £- 5 0 0 0.0 £0.10
Monitor……………………. £- 5 0 0 0.0 £0.10
5.1 speakers…………….. £- 0 0 0.0 £0.10
TV…………………………. £- 4 0 0 0.0 £0.10
TV per hr…………………. £- 0 0 0.0 £0.10
TV standby……………….. £- 0 0 0.0 £0.10
TV LCD…………………….. £- 4 0 0 0.0 £0.10
TVLCD per hr…………….. £- 0 0 0.0 £0.10
TV LCD standby…………. £- 0 0 0.0 £0.10
Video standby……………. £- 24 0 0 0.0 £0.10
Sky box……………………. £- 4 0 0 0.0 £0.10
Skybox per hour…………. £- 0 0 0.0 £0.10
Skybox standby………….. £- 0 0 0.0 £0.10
Oven……………………….. £- 0 0 0.0 £0.10
Fridge………………………. £- 24 0 0 0.0 £0.10
Stereo…………………….. £- 0 0 0.0 £0.10
ADLS router………………. £- £0.10
Phone…………………….. £- £0.10
£- £0.10
£348.04

Kettle £2,628.00 3000 24 72000 26280000 26280.0

My inspiration was the threads below:
http://forums.moneysavingexpert.com/showthread.html?t=241285