DAILY LOAD PLANNING
Household energy worksheet
Select the appliances you use, then edit watts, units and hours. Presets are starting assumptions, not measured ratings. Replace them with nameplate, energy-label or meter readings.
Daily energy (kWh) = watts × units × hours/day × duty (%) ÷ 100,000. For cycling loads, enter connected hours and a duty percentage; do not also reduce hours for the same cycling.
Connected load is the sum of selected running watts, not a simultaneous peak or motor-start estimate. This worksheet does not include inverter/battery losses.
Changes are saved in this browser.
| Use | Category | Appliance | Watts / unit | Units | Hours / day | Duty % | kWh / day | Typical W range | Remarks | Remove |
|---|---|---|---|---|---|---|---|---|---|---|
| Selected totals: 0 devices (units) · 0 W | ||||||||||
Typical wattage ranges are read-only references supplied for this worksheet, including older appliance examples. Calculations use the editable Watts / unit value, not the range. Awake/asleep rows are alternative operating states: split daily hours and avoid counting the same physical device twice in your device total.
How to improve the estimate
- Use average operating watts for variable-speed equipment, or adjust duty based on measured energy. Avoid applying cycling twice.
- For a weekly appliance, average its hours over seven days. Add separate rows for cooking and keep-warm operation if needed.
- A refrigerator runs intermittently. Its annual energy label divided by 365 often gives a better daily estimate than its maximum watts.
- Save separate exports for different households. Excel includes all rows, selection flags and editable formulas.
Method reference: Virginia Tech — estimating appliance energy use. Preset watts, schedules and duty factors below are illustrative planning inputs, not product specifications.