Water Chemistry & Chemical Demand
Assess raw-water hardness and alkalinity, estimate hydrated lime or quicklime and soda ash dosages, and calculate daily chemical consumption.
Engineering Excel Workbook
A structured Excel workbook for preliminary lime–soda softening design. Evaluate raw-water hardness chemistry, lime and soda ash consumption, upflow solids-contact softener dimensions, recarbonation requirements, sludge generation, and linked engineering design checks.

Assess raw-water hardness and alkalinity, estimate hydrated lime or quicklime and soda ash dosages, and calculate daily chemical consumption.
Size duty softener units, annular upflow area, tank diameter, contact well, working volume, detention time, and overflow weir configuration.
Estimate CO₂ dosing, two-compartment recarbonation basin dimensions, CaCO₃ and Mg(OH)₂ solids generation, and sludge slurry requirements.
A linked lime–soda treatment sequence, from raw-water chemistry and reagent requirements to solids-contact tank sizing, recarbonation, and sludge assessment.
Workbook Experience
Explore the actual Calculation Sheet and linked Dashboard layout before purchasing.


Original Lime Softener Dashboard excerpt showing the solids-contact unit, dimensions, reagent requirements, recarbonation, sludge production, and preliminary design review.
Screen preliminary softener, recarbonation, and sludge withdrawal design parameters against the workbook design basis.
| Review Item | Workbook Evaluation |
|---|---|
| Water chemistry & dosing | Review hardness and alkalinity conversions and chemical consumption from adopted reaction and purity assumptions |
| Softener hydraulic sizing | Evaluate annular upflow rate, required tank size, detention time, and contact-well basis |
| Overflow and weir loading | Review the preliminary discharge arrangement and hydraulic sizing checks |
| Recarbonation sizing | Evaluate mixing/reaction basin geometry and detention time from the adopted process basis |
| Sludge withdrawal | Estimate precipitation, dry solids, and expected slurry withdrawal volumes |
Residual hardness and final pH are adopted preliminary design assumptions, not guaranteed removal predictions. Confirm reagent dosages, carbonate equilibrium, sludge performance, and final equipment sizing using project-specific testing and vendor data.
Instructions & assumptions
Project information
Chemistry, unit sizing & sludge
Process schematic & design summary
Design criteria, constants & units
This workbook provides preliminary engineering calculation and review support. Reagent selection, residual hardness, recarbonation, process performance, tank internals, and sludge handling remain subject to treatability testing, project-specific criteria, and supplier confirmation.
Bring water chemistry, lime–soda dosing, solids-contact softener sizing, recarbonation, and sludge-production estimates into one structured engineering workbook.