Home › Shop › Crude Distillation Unit Evaluation
Excel tool

Crude Distillation Unit Evaluation

TBP yields, mass balance, Watson K, furnace duty, pumparound and condenser heat balance for an atmospheric crude unit.

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

  • 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
Crude Distillation Unit Evaluation — sample pages

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

Crude Distillation Unit 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 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 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.