Home › Shop › Crystallizer Yield and Energy Balance
Excel tool

Crystallizer Yield and Energy Balance

Crystal yield, mother liquor, cooling duty or vapour load, magma density and an MSMPR size view for cooling, evaporative and vacuum crystallizers.

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

  • 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
Crystallizer Yield and Energy Balance — sample pages

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

Crystallizer Yield and Energy Balance 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 (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 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.