In the last two decades, a lot of research has been done to develop analytical and numerical models for the analysis of EAHE systems. Version are both available for download just below.The earth–air heat exchanger (EAHE) is a promising technique which can effectively be used to reduce the heating/cooling load of a building by preheating the air in winter and vice versa in summer. This example spreadsheet shows calculations in U.S. Thus the heat exchange area calculated on page 1 can be used for the page 2 calculations. In the spreadsheet templates that can be downloaded below, this page 2 and page 1 from the previous section are both included as part of the same Excel template. This spreadsheet calculates the number of tubes needed for a specified tube length and diameter. Version are available for download just below.Įxcel Template - : Number of Tubes for a Shell and Tube Heat Exchanger The Excel spreadsheet template at the right is for shell and tube heat exchanger design. Column I contains the Excel formulas to calculate the parameters noted above. Column C has cells for entry of several parameter values. Data sheet in Microsoft Excel for.Īfter 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. Video clip to demonstrate shell and tube condenser design software calculations. 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. For more details about preliminary heat exchanger design, the parameters involved, and example heat exchanger calculations, see the articles: ' and '.' Excel Template - : Calculation of Heat Transfer Area 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. 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, ΔT lm, based on the values of several input parameters. Equations and Parameters The heat exchanger design equation, Q = U A ΔT lm, can be used to determine the required heat transfer area, A, for a heat exchanger.

Tube condenser calculations