Mass and energy balance of a solution crystallizer: enter the feed flow, concentration and temperature, the final temperature and your own solubility curve, and see the theoretical crystal yield, the mother liquor, the heat duty and the slurry you have to pump.
USD 49 one-time purchase

What it does
Theoretical (equilibrium) crystal yield
Theoretical (equilibrium) crystal yield from your own solubility curve: up to 8 points, joined by straight lines, entered per 100 of solvent or as mass % of the saturated solution.
Anhydrous or hydrated crystals
for a hydrate, the two molar masses fix the water of crystallisation that leaves with the crystals and is no longer available as solvent.
Mother liquor flow and
Mother liquor flow and composition, solute recovery, yield per unit of feed, saturation temperature of the feed and supersaturation coefficient at the feed and at the final temperature.
Magma
solids fraction by mass and by volume, slurry density, magma density, slurry volume flow, wet cake with adhering mother liquor and filtrate.
What-if table
yield, recovery, evaporation and heat duty at every temperature of your solubility table.
Selectors for mode, crystal
Selectors for mode, crystal form, solubility basis and the MSMPR view; rows you do not need disappear; Default/Manual on the secondary inputs.
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 (IAPWS-IF97 properties from a separate library, the vacuum case solved numerically, not by the sheet's formula) in 165 recalculated runs: all 24 selector combinations, SI, US, British and industry units on three cases, result-unit switching and 116 edge and invalid-input cases; about 5,500 values compared, 0 formula errors in LibreOffice. The yield and the size relations reproduce two published handbook examples. |
| 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. |