Home › Shop › Purified Water and WFI Generation Performance
Excel tool

Purified Water and WFI Generation Performance

Reverse osmosis, EDI, storage loop, hot-water sanitization and WFI by distillation or membrane: recovery, quality, energy and cost per m³.

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

  • Excel workbook (.xlsx), no macros, version v1.0
  • Excel 2010 or later, Windows and Mac
  • Instant download after payment; updates to this major version included
  • Single-user licence; team and site options
  • Refund if it does not work as described or has an error we cannot fix: contact support within 14 days of purchase — full refund policy
Purified Water and WFI Generation Performance — sample pages

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].

Purified Water and WFI Generation Performance Excel workbook sample pages
Layout illustration (not a results screenshot).

Specification and checks

FormatExcel workbook (.xlsx), no macros
Versionv1.0
Works inExcel 2010 or later, Windows and Mac
UnitsSI, US and British, mixed freely
IncludesGuide tab with method and references, calculator, print-ready report
Checked againstChecked 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 versionBrowse the free calculators

Compatibility, licence and support

FileExcel 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.
LicenceSingle user. A team licence (up to 5 named users) is 3 × the shop price; site licences on request — licence terms.
UpdatesUpdates to this major version are included; download them again from the link in your receipt.
SupportEmail [email protected] with your order number — questions on the method, your inputs or your results are welcome.
RefundsIf 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.