refabath.blogg.se

• #Building airflow standard calculator spreadsheet download#

Excel Template - : Number of Tubes for a Shell and Tube Heat Exchanger

#Building airflow standard calculator spreadsheet download#

units).Ĭlick here to download this Excel spreadsheet template (in S.I. version are available for download just below.Ĭlick here to download this Excel spreadsheet template (in U.S. This example spreadsheet shows calculations in U.S.

Column I contains the Excel formulas to calculate the parameters noted above. After values are entered for those parameters the Excel formulas in the spreadsheet will calculate the heat transfer rate, the log mean temperature difference, the required heat transfer area, and the needed mass flow rate for the second fluid.Ĭolumn C has cells for entry of several parameter values. The parameters that need input values are the mass flow rate, specific heat, inlet temperature and outlet temperature of one of the fluids the heat capacity, inlet temperature and outlet temperature of the second fluid and an estimated value for the overall heat transfer coefficient. The Excel spreadsheet template shown at the left will calculate the heat transfer area required for a heat exchanger after values for several parameters have been input. Excel spreadsheet templates for calculating the heat transfer area needed for a heat exchanger are presented and discussed in the next section.įor more details about preliminary heat exchanger design, the parameters involved, and example heat exchanger calculations, see the articles: “ Preliminary Heat Exchanger Design Example” and “ Fundamentals of Heat Exchanger Theory and Design.” Excel Template - : Calculation of Heat Transfer Area

The heat transfer area can be calculated after values have been determined or estimated for the required heat transfer rate, Q the overall heat transfer coefficient, U, and the log mean temperature difference for the heat exchanger, ΔTlm, based on the values of several input parameters. The heat exchanger design equation, Q = U A ΔTlm, can be used to determine the required heat transfer area, A, for a heat exchanger.