But I can't get the results to match the predictions. HELP!
Here's the rought draght: http://www.soundcolor.net/amp_hours_calculator.xls
As I understand it, the general formula is Qantity * watts * 1.4 (inverter waste) / 12 Volts = Amp Draw * Hours Needed = Amp Hours needed.
(I'd like to be able to work the spread sheet a few different ways though... you know, backwards and forwards.
Batteries:
I have 2 160 amp hour batteries
2 120 amp hour batteries
and 1 10 amp hour battery (may get more...)
120 Volt items:
* (3) 30 LED Light bulbs: Green and Blue = .06 amps per LED = 1.8 each
* (2) 30 Light bulbs: Red = .05 amps per LED = 1.5 amps each
* (1) Big LED Light bulb: 4.6 amps
* (10) LED Christmass Light Strings = 1.8 Watts? each
* (1)15 Watt Light
* (1)10 Watt LED color changing Light
* (1) What's a small fan run? 15-20 Watts?
My central question is: how many of these things can I use and still get 5-7 full nights out of my batteries without a re-charge? That's why a spread sheet would be useful to play with it. So if anyone knows an existing tool like this please let me know. I'd be happy to post mine for other people when I'm done! THANKS!