Calculating base electric load

[Daox]

For the past few weeks I've been trying to get an accurate base load analysis done on my house. To do this, I've basically gone through every single thing that has a plug on it and have measured it with a kill a watt. I log its power usage and plug it into my attached spreadsheet. For some things, I have logged the actual power consumption of devices like my fridge. When I enter that information in, it overrides the constant load for the calculations on the right side.

I have yet to finish logging power usage for the water softener, so I've colored those cells grey. I could probably do so with other items that probably have a fairly average power draw over time. I just haven't gotten that far yet. The items that say 1W are 1W or less since the kill a watt doesn't read any lower than 1W.

This spreadsheet now gives me an alright idea of where a lot of my power usage is going while I'm not at home or sleeping (which is by far the majority of the time). With it I can find ways of reducing this power usage with timers for instance. Its also a great way of finding phantom loads which many of you probably know. I found that I had some speakers that my wife only very occasionally uses drew 8W constantly. They are no longer wasting almost 6 kWh a month.

Of course, this doesn't figure in the things you can't plug in. The ceiling fans, the furnace, the well and other things. Anyone have any ideas for measuring these things?