Heat Transfer Calculations
Excel spreadsheets and spreadsheet packages are available to calculate forced convection heat transfer coefficients and natural convection heat transfer coefficients for several common physical and flow configurations. There are also spreadsheets for calculating condensation heat transfer coefficients and for double pipe heat exchanger design calculations. These spreadsheets are available for U.S. or S.I. units
This Excel spreadsheet bundle is a convection heat transfer coefficient calculator including both the forced convection heat transfer coefficient calculator spreadsheet package and the natural convection heat transfer coefficient calculator spreadsheet package (both described in more detail below), providing the means to calculate convection heat transfer coefficients for six different forced convection configurations and five different natural convection heat transfer coefficients, all in U.S. units.
This Excel spreadsheet bundle includes both the forced convection heat transfer coefficient spreadsheet package and the natural convection heat transfer coefficient spreadsheet package (both described in more detail below), providing the means to calculate convection heat transfer coefficients for six different forced convection configurations and five different natural convection heat transfer coefficients, all in S.I. units.
Five forced convection heat transfer coefficient calculator worksheets are included in this package. Forced convection heat transfer coefficients can be calculated for turbulent pipe flow, laminar pipe flow, turbulent flow in an annulus, turbulent flow in a non-circular duct and flow parallel to a flat plate. These spreadsheets are set up for U.S. units.
FREE DOWNLOAD! Try this Excel Spreadsheet! Forced convection heat transfer coefficients for laminar flow in pipes can be calculated in either U.S. or S.I. units. Three different correlations for Nusselt number are used for determining forced convection heat transfer coefficients from values for Reynolds number, Prandtl number, and L/D.
This package includes five Excel templates for calculation of forced convection heat transfer coefficients for turbulent flow in pipes, laminar flow in pipes, turbulent flow in an annulus, turbulent flow in a non-circular duct, flow past a single cylinder and flow paralle to a flat plate. These Excel spreadsheets are set up to use S.I. units.
FREE DOWNLOAD - Try this Excel template! The natural convection heat transfer coefficient between a fluid and a sphere can be calculated in either U.S. or S.I. units with this Excel spreadsheet. Input parameters are needed to allow calculation of the Prantl number and the Grashof number. The natural convection heat transfer coefficient is calculated from the Nusselt number, which comes from a correlation for Nusselt number in terms of Prantl and Grashof numbers.
Five natural convection heat transfer coefficient calculator spreadsheets are included in this package. Natural convection heat transfer coefficients can be calculated for heat transfer between a fluid and a vertical plate, a horizontal plate, an inclined plate, a horizontal cylinder or a sphere. These spreadsheets make the calculations in U.S. units
Five free convection heat transfer coefficient calculator spreadsheets are included in this package. Natural convection heat transfer coefficients can be calculated for heat transfer between a fluid and a vertical plate, a horizontal plate, an inclined plate, a horizontal cylinder or a sphere. These spreadsheets make the calculations in S.I. units
This Excel spreadsheet template calculates the heat transfer coefficient for condensation outside of a bank of horizontal tubes, using S.I. units.
This Excel spreadsheet template will calculate the overall heat transfer coefficient for heat transfer through a tube/pipe wall, based on input values for the inside and outside convection heat transfer coefficient, the pipe wall thermal conductivity and fouling resistaance values. Calculations are in U.S. units.
This Excel spreadsheet template will calculate the overall heat transfer coefficient for heat transfer across a tube/pipe wall, based on input values for the inside and outside convevtive heat transfer coefficient, the pipe wall thermal conductivity, and fouling resistances. Calculations are in S.I. units.
This Excel spreadsheet uses U.S. units in an iterative procedure for thermal design of a double pipe heat exchanger. The first iteration calculates the needed heat transfer area for an estimated value of the overall heat transfer coefficient. It also leads the user through selection of pipe diameters & lengths and number of passes and calculates the annulus and tubeside pressure drops. Additional worksheets then are used to calculate the tubeside heat transfer coefficient and the annulus heat transfer coefficient. The final worksheet then calculates the overall heat transfer coefficient. The inital estimate of overall heat transfer coefficient can then be adjusted to the calculated value.
This Excel spreadsheet uses S.I. units in an iterative procedure for thermal design of a double pipe heat exchanger. The first iteration calculates the needed heat transfer area for an estimated value of the overall heat transfer coefficient. It also leads the user through selection of pipe diameters & lengths and number of passes and calculates the annulus and tubeside pressure drops. Additional worksheets then are used to calculate the tubeside heat transfer coefficient and the annulus heat transfer coefficient. The final worksheet then calculates the overall heat transfer coefficient. The inital estimate of overall heat transfer coefficient can then be adjusted to the calculated value.