| | Example scenario: | | | | Your scenario: |
| Appliance wattage | 600 | watts | | | | watts |
| Appliance amperage in 120V circuit | 5 | amperes | | Wattage/Volts=Amperes | 0 | amperes |
| Resistance | 24 | ohms | | Voltage/Amperes=Ohms | ERROR:#DIV/0! | ohms |
| Amperage needed w/ 12V batteries | 50 | amperes | | Wattage/Volts=Amperes | 0 | amperes |
| Number of hours you use this device a day | 5 | hours | | | | hours |
| Battery storage (amperage hours, or AH) needed for a day | 250 | amperage hours | | | 0 | amperage hours |
| Number of 225 AH batteries needed | 1.1111111111 | | | | 0 |
| Round up if necessary | 2 | batteries | | | | batteries |
| Total energy (watts) needed | 3000 | kWh | | | 0 | kWh |
| Hours of sunlight | 6 | hours | | | | hours |
| Solar panel wattage needed | 500 | watts | | | ERROR:#DIV/0! | watts |
| Number of 100-watt solar panels needed | 5 | | | | ERROR:#DIV/0! |
| Round up if necessary | 5 | panels | | | | panels |
| Battery costs | $ 800.00 | | | | $ - 0 |
| Solar panel costs | $ 1,000.00 | | | | $ - 0 |
| Total | $ 1,800.00 | | | | $ - 0 |
| Price of energy per kWh | $ 0.10 |
| kWh (kiloWatts used per hour) | 0.6 | | | | 0 |
| Cost for 1 hour of use | $ 0.06 | | | | $ - 0 |
| # of hours to pay for equipment | 28735.63 | hours | | | ERROR:#DIV/0! | hours |
| Number of days of average use to pay for equipment | 239.4636015326 | days | | | ERROR:#DIV/0! | days |
Trayvon1996
unit_3_unpluged_spread_sheet.xlsx
