WWE Process Design Calculator v1.7 — Excel workbook + equipment data sheets

Twenty-eight water treatment design sheets in one Excel workbook. Every equation is visible in the cell where it works, every result is checked against the design envelope industry practice actually accepts, and water properties are computed from your temperature rather than assumed.

WHAT IS IN IT

35 tabs: twenty-eight design sheets, a shared design basis, a calculation record, a dashboard, a summary, an equipment list and a pump curve. 2,109 live formulas — none of them hidden, locked or pasted as a value.

 Hydraulics: pipe sizing and head loss · pump TDH, power and NPSH

 Solids separation: circular clarifier · rectangular sedimentation · dissolved air flotation · lamella · multimedia filter

 Oxidation: iron and manganese removal

 Adsorption: activated carbon · ion exchange

 Membranes: ceramic monolith · MF · UF · NF · RO

Degasification:  membrane contactor and its vacuum pump

 Electrodeionisation: CDI / EDI stack

 Disinfection: UV · chlorine contact tank

 Thermal: heat exchanger

Reaction and chemical: mixing tank · neutralisation · chemical dosing and day tank · polymer preparation unit

 Sludge dewatering: decanter centrifuge · recessed plate filter press · thermal drying · solar drying

NEW IN v1.7

T-1200 chemical dosing, and the pump that cannot reach the night-time dose. A dose is set in milligrams per litre of water and a metering pump is bought in litres per hour of solution. Between the two sit a strength and a specific gravity, and almost every dosing error in practice is one of them applied upside down — at 12 per cent that mistake is wrong by a factor of eight. The sheet carries the chain through once, in both L/h and the mL/min a pump dial is actually marked in, then turns a day tank into days of storage on usable volume rather than geometric volume, which on a small tank is a third of it.

Then the check that sizing calculations usually skip. A diaphragm metering pump controls down to roughly a tenth of its rated capacity, so one chosen only on the peak dose frequently cannot deliver the low-demand dose at all — and the first anyone knows of it is a residual that will not hold overnight. You state the minimum dose the same pump has to reach and the sheet tells you whether it can, with a pass mark on the answer rather than a sentence of advice.

T-1210 polymer preparation unit, sized from the process duty rather than from the solution draw: dry powder demand, sacks a day, and the hopper refill interval an operator actually plans around. It separates make-up strength from injection strength — the unit makes 0.25 to 0.5 per cent and the line dilutes to 0.05 to 0.1 — which is the distinction behind most plants that believe they are using twice the polymer they should. And it sizes the maturation chamber, because dry polymer disperses in seconds but hydrates in thirty to sixty minutes: undersize it and the unit still makes solution at the right strength, it simply does not work, and the symptom is a dose that has to keep climbing.

HOW IT WORKS

Change the flow on the design basis and it moves through every sheet that depends on it. Each linked input has its own SOURCE toggle, so you can override one sheet without breaking the rest, and a register lists every override that is on. Results outside their envelope flag themselves.

Excel only. No macros, no add-ins, no internet connection, no subscription.

ALSO INCLUDED — EQUIPMENT DATA SHEETS

A second Excel file at the same one-time price: 28 data sheets, one per unit operation, 1,989 fields across 30 tabs. The calculator tells you how big the thing has to be; the data sheet is what you send out once you know. Each opens with the same process parameters and envelopes as the matching calculation, then asks for everything a supplier needs to quote — mechanical design, materials, nozzle schedule, driver and utilities, instrumentation, codes and inspection, vendor scope. Nothing is locked and there are no formulas to break.

PRICE

SGD 19.90 until 31 December 2026 — both files, one payment. It doubles to SGD 39.90 on 1 January 2027.

Buy it once and every version after this one is free. Nineteen sheets became twenty-six without anyone paying twice, and the file is now the only place some of them exist.