Performance and sizing check for a triethylene glycol (TEG) gas dehydration unit: enter the gas flow, pressure and temperature, the outlet specification, the lean glycol purity and the circulation or the contactor trays, and see the water removed, the inlet and outlet dew points, the dew point in equilibrium with the lean glycol, the theoretical stages and trays, the contactor diameter and the reboiler duty.
USD 49 one-time purchase

What it does
Outlet specification as a
Outlet specification as a water dew point or a water content, converted both ways at contactor pressure; dew point depression and water removal.
Equilibrium with the lean glycol
a generic activity-coefficient fit, or an equilibrium dew point you read from your own chart. Limiting lean purity for the specification.
Absorption factor, theoretical stages
Absorption factor, theoretical stages and actual trays (Kremser and Colburn relations, as published in Perry's handbook), minimum circulation, circulation rate and ratio per kg of water, rich glycol concentration.
Sizing mode (stages for
Sizing mode (stages for a chosen circulation) or rating mode (predicted outlet dew point of an existing contactor). Enter a measured dew point to see the tray efficiency the unit is really achieving.
Contactor diameter from a
Contactor diameter from a Souders-Brown K: your own value, or the published C factor equation with the absorber service factor; gas velocity load of an existing column.
Reboiler duty
sensible, vaporisation, reflux and heat loss, per litre of glycol and per kg of water; stripping gas as a user factor on residual water, with gas consumption; glycol losses per day.
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 152 recalculated runs: all 16 selector combinations on two input sets, SI, US, British and other units on three cases, result-unit switching and 95 edge and invalid-input cases; about 3,800 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. |