Solar · Excel workbook
Solar Water Pump Planning Calculator
Estimate hydraulic energy, electric energy and indicative PV capacity.
Download free XLSX ↗Version 1.0 · 25 September 2026 · No registration required
What you need
- Daily water demand in m³
- Total dynamic head in metres
- Combined pump and motor efficiency
- Peak sun hours and PV delivery factor
- Desired storage days
What you get
- Hydraulic and electrical energy per day
- Indicative PV array capacity
- Planning storage volume
How to use it
- Save a working copy and read the instructions in the file.
- Replace illustrative inputs or response fields with your site records.
- Check units, dates and boundaries before using the results.
- Keep the completed file with its supporting evidence.
Method
Hydraulic energy (kWh/day) = 0.002725 × volume × head. Divide by combined efficiency for electrical energy, then by sun hours and delivery factor for indicative PV kWp.
Scope and limitations
Not a pump selection or final electrical design. Confirm pump curves, drawdown, friction, starting behaviour, seasonal irradiation, controls, dry-run protection and water storage quality.
Reference: MNRE and IWMI solar pump sizing manual
Read the related guide: Practical guidance for this tool.