Home › Shop › Batch Process Scale-Up and Yield Evaluation
Excel tool

Batch Process Scale-Up and Yield Evaluation

Scale a stirred batch from lab to plant by four rules, with heat-removal and yield-by-step checks.

Enter the lab/pilot vessel geometry, the impeller type and speed, the liquid density and viscosity, the plant batch volume, a jacket area with cooling data, and the step yields in the lab and in the plant. The tool scales the vessel by four classic rules and shows what each one does to the plant impeller speed, power, power per unit volume, tip speed, Reynolds number and blend time.

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
Batch Process Scale-Up and Yield Evaluation — sample pages

What it does

Dimensionless groups from Perry's

Dimensionless groups from Perry's Handbook: power number Np = P/(ρN³D⁵), Reynolds number ρND²/µ and dimensionless blend time tb·N, with a warning when the flow is not fully turbulent.

Geometric similarity (plant geometry

Geometric similarity (plant geometry scaled from the lab by the volume ratio) or your own plant impeller, tank and area.

Selected-rule summary

plant speed, power, P/V, tip speed, Reynolds number and blend time, each against the lab value.

Yield by step, lab vs plant

overall yield as the product of the reaction, work-up, isolation and drying yields, the yield gap, the actual product per batch, and the process mass intensity (mass charged per kg of product).

Ranked findings, three charts

Ranked findings, three charts (speed and power by rule, area per volume against scale, plant yield waterfall) and a print-ready report. SI, US and other units, switchable on every row; typical-range checks on every input.

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

Batch Process Scale-Up and Yield Evaluation 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 (same quantities from first principles, no shared formula code) in 33 selector runs, US and British unit variants, result-unit switching and 15 edge cases: about 1,950 values compared, 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.