Steady-state material and energy balance of a process block: up to 8 streams and 6 components, closure by component and element, one reaction with conversion and selectivity, recycle and purge ratios, and a heat duty with sensible and latent terms.
USD 49 one-time purchase

What it does
Component balance
Closure error for every component and overall, on a mass or mole basis, with a flag on each component that does not close.
Element balance
An atom balance from the atoms per molecule you enter, which stays valid when a reaction changes the molecules.
One reaction
Conversion specified or fitted to the streams, with reaction extent, conversion and selectivity against the values you expect.
Recycle and purge
Recycle ratio, purge fraction, purge to fresh feed and recycle to purge from the roles you give the streams.
Energy balance
Sensible and latent terms against a reference temperature, giving the duty required or a comparison with a known duty.
Metering error finder
Scaling factors that would close the mass balance, plus what-if tables for conversion and outlet temperature.
Built for engineers
- Visible formulas — nothing hidden, so you can check every step.
- Fully referenced — methods from the standard references, checked against their published worked examples.
- 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 | An independent Python model: all 216 combinations of the six selectors, 17 unit-system variants with every input and result unit switched, 40 random cases and 57 edge-case runs (blank, zero, negative, text and invalid inputs give a clear message and blank results, never an error value). Results agree within 1e-9 relative or better. |
| Free tools | 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. |
Field guide: Water Treatment, Utilities and Energy Made Simple