Yield and energy evaluation of an atmospheric crude distillation unit: enter the crude rate and API gravity, a TBP curve of up to ten points, up to five cut points with the gravity of each product, the preheat and furnace temperatures, the overflash, the stripping steam and the pumparound shares, and see the yield of every product, the balance closure, the Watson K of each cut, the preheat and furnace duty, the energy per barrel and the column heat balance.
USD 49 one-time purchase

What it does
Yields
volume and mass yield and rate of up to six products (five distillates and the residue) from ideal cuts on your TBP curve, on a volume % or mass % basis; crude entered as a standard volume or a mass rate.
Mass balance
product gravities are your inputs; the residue gravity closes the mass (or volume) balance by default, or enter a measured value and see the closure.
Characterization
volume average and mean average boiling point and Watson K of every product (and of the crude when the curve covers 10 to 90 %), by the publicly documented API Technical Data Book definitions.
Column heat balance
total heat removed, split into up to three pumparounds and the overhead condenser; net heat from the stripping steam; heat leaving with the products for preheat recovery.
Stripping steam per product
Stripping steam per product and in total, checked against the published range of 1 to 10 lb per barrel of stripped liquid; overflash rate.
Energy per barrel or
Energy per barrel or per m³ of crude (fired, absorbed and preheat).
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 in 116 recalculated runs: all 16 selector combinations, SI, US, British and industry units on three cases, result-unit switching and 83 edge and invalid-input cases; 5,843 values compared, 0 formula errors in LibreOffice. |
| 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. |