Performance of a pharmaceutical water system by water and energy balance: enter the feed, the RO recoveries and rejections, an optional EDI polishing step, the storage tank and distribution loop, the hot-water sanitization and the WFI generator, and read the flows, the quality estimate, the energy and the cost per m³.
USD 39 one-time purchase

What it does
Single or double pass
Single or double pass reverse osmosis, with the option to return the pass 2 concentrate to the pass 1 feed: permeate and concentrate flow and conductivity of each pass, from a closed-form salt and water balance.
EDI (electrodeionization) as a
EDI (electrodeionization) as a recovery and conductivity reduction you enter; purified water flow, a conductivity estimate against your own target, and the overall recovery from feed water to purified water.
Pump power and specific
Pump power and specific electricity for the RO pumps, the EDI and the loop pump.
Storage and distribution loop
velocity in the supply and return legs with a Reynolds-number check, tank turnover, hold-up volume, circulation time and storage hold time.
Hot-water sanitization
the water heated, the heat and the plant steam per event and per week.
WFI generation three ways
multi-effect distillation from your steam economy, vapour compression distillation from your specific electricity (with any make-up steam), or a cold membrane route; with the cooling water and the water balance.
Built for engineers
- Visible formulas — nothing hidden, so you can check every step.
- Fully referenced — methods from the standard references, with the book, edition and page named in the Guide tab.
- Safe to share — sheets are protected against accidental edits, with an open password so you can still customise.
- Built-in input checks — clear warnings for impossible inputs and values outside typical ranges.
For engineering estimates; verify against site data. Code-based methods are aligned with the publicly documented procedure; they are not a licensed reproduction or a certification.
Preview the workbook
An illustration of the sheet layout of this workbook, not a screenshot of calculated results. Select the image to enlarge it. For questions before you buy, email [email protected].
Specification and checks
| Format | Excel workbook (.xlsx), no macros |
| Version | v1.0 |
| Works in | Excel 2010 or later, Windows and Mac |
| Units | SI, US and British, mixed freely |
| Includes | Guide tab with method and references, calculator, print-ready report |
| Checked against | Checked against an independent Python model (water and steam properties from IAPWS-IF97) in hundreds of recalculated runs: all selector combinations, SI, US, British and alternative units, result-unit switching and many edge and invalid-input cases; 0 formula errors in LibreOffice. |
| Free version | Browse the free calculators |
Compatibility, licence and support
| File | Excel workbook (.xlsx), no macros, version v1.0; works in Excel 2010 or later on Windows and Mac. Sheets are protected against accidental edits, with an open password so you can customise. |
| Licence | Single user. A team licence (up to 5 named users) is 3 × the shop price; site licences on request — licence terms. |
| Updates | Updates to this major version are included; download them again from the link in your receipt. |
| Support | Email [email protected] with your order number — questions on the method, your inputs or your results are welcome. |
| Refunds | If the tool does not work as described, or has an error we cannot fix, email [email protected] with your order number within 14 days of purchase and we will refund you in full. Refunds are not offered for a change of mind once a file has been downloaded. Read the full refund policy. |