How it works
Energy per appliance = rated watts × hours/day × quantity × days /1000. Sum kWh and multiply by the entered tariff.
Input definitions
- CSV: appliance,watts,hours per day,quantity
- Plain text; maximum 200,000 characters.
- Number of days
- Enter the value in the labeled unit.
- Electricity price per kWh
- Enter the value in the labeled unit.
A worked example
- CSV: appliance,watts,hours per day,quantity
- appliance,watts,hours,quantity Lamp,10,5,4 Fan,50,8,1
- Number of days
- 30
- Electricity price per kWh
- 0.2
Assumptions & limits
Constant power during stated usage hours; no local prices, meter connection, peak tariffs or installation assessment.
Sources & review
Maintained by AnsRio. Methods and examples use automated checks; this does not imply independent professional certification.
Method updated 2026-10-17. Content checked against the stated method and examples. Our verification approach.
Common questions
Does this include electricity standing charges or variable tariff bands?
No. It multiplies modeled kWh by one entered rate. Add fixed charges separately and use measured consumption when appliances cycle on and off.
How does Appliance electricity audit work?
Energy per appliance = rated watts × hours/day × quantity × days /1000. Sum kWh and multiply by the entered tariff.
What are the limits of Appliance electricity audit?
Constant power during stated usage hours; no local prices, meter connection, peak tariffs or installation assessment.
How do I keep the full worksheet?
Run the tool and choose Download file. The on-page table is a preview and may show only the first 20 rows; the downloaded file contains the full result. CSV downloads escape spreadsheet formula prefixes. Inputs and files are processed on your device.