This Excel spreadsheet helps you design a TEMA Type E heat exchanger. The spreadsheet uses the Bell-Delaware method to calculate the overall heat transfer coefficient and the shell-side pressure drop.
TEMA Type E heat exchangers are the basis of many other designs. They offer a single pass, with liquid entry and exist on opposing sides of the shell
The spreadsheet allows you to pick from a triangle, square or rotated square tube placement, and specify the precise geometry of the shell, and then calculates the shell-side pressure drop and heat transfer coefficient accordingly.
The spreadsheet contains several empirical correlations, including those to calculate the Colburn J factor (used in determining the shell-side friction factor) and the pressure drop.
In the Bell-Delaware method, the shell-side heat transfer coefficient is the ideal heat transfer coefficient for cross-flow across a tube bank, multiplied by several correction factors as follows
The correction factors adjust the ideal heat transfer coefficient for leakage effects, bundle bypass, baffle spacing, and baffle cut. The correction factors are all calculated inside the spreadsheet for your convenience. The product of all the correction factors are equal to about 0.6 for an efficiently designed heat exchanger.
The spreadsheet is easy to use. Simply enter the process parameters (i.e. flowrates, temperatures, etc) and the geometrical parameters (number of tube passes, shell dimensions etc) in the pink cells. You will need to equalize heat transfer across the shell-side and tube-side streams by varying a process parameter (this is indicated inside the spreadsheet).
Download Excel Spreadsheet for TEMA Type E Heat Exchanger Design using Bell-Delaware