This Heat Exchanger Excel Workbook provides well organized technical data in form of spreadsheet calculations, tables, charts and diagrams, indispensible for anyone involved in the design, selection, operation, maintenance or inspection of heat exchangers. This Excel workbook presents formulae and data for: Physical properties of the most common fluids used in heat exchangers in Oil & Gas, Petroleum, Refining and Chemical processesHeat transfer coefficients “U” and “Pressure losses in shell and tube heat exchangers (tube + shell sides)Useful shell and tube geometrical calculationsGeometrical data of shell and tube heat exchangers according to DIN 28184 & 28191 and TEMAStandardsGuidelines for the selection of shell and tube heat exchangersThermal conductivity of the most common material of construction of shell and tube heat exchangersValuable heat exchanger charts, figures and diagramsNumerous conversion tablesAnd much more. Please refer to the table of content hereafter for further details. IMPORTANT NOTESWe assume that Microsoft Excel is installed on your computer and that you have basic knowledge of using ExcelThis Excel workbook includes Visual Basic for Application function subroutines. Macros must be enabled for them to workDISCLAIMERThis Heat Exchanger Excel Workbook is provided by WR Training “as is” and any express or implied warranties, including, but not limited to, the implied warranties of merchantability and fitness for a particular purpose are disclaimed. In no event shall the Copyright owner or contributors be liable for any direct, indirect, incidental, special, exemplary, or consequential damages (including, but not limited to, procurement of substitute goods or services, loss of use, data, or profits, or business interruption) however caused and on any theory of liability, whether in contract, strict liability, or tort (including negligence or otherwise) arising in any way out of the use of this Excel Workbook, even if advised of the possibility of such damage-HEATEXCHANGER DESIGNANDCALCULATIONEXCEL WORKBOOK: TABLE OF CONTENTAn ExcelVBA based engineering tool by WR TrainingI/ SPREADSHEET CALCULATIONSA. Physical properties of fluids1. Properties of water and steama. saturation properties with temperatureb. saturation properties with pressurec. properties given pressure and temperatured. properties given pressure and enthalpy2. Dynamic viscosity of gases3. Kinematic viscosity4. Weight density of liquidsformula 1formula 2formula 35. Weight density of ideal gases6. Weight density of real gases7. Gas compressibility factor8. Specific gravity of gases9. Boiling point pure component10. Vapor pressure: pure component11. Vapor pressure: mixture12. Thermal conductivity of water13. Thermal conductivity of liquids14. Thermal conductivity of gases15. Fouling factors of water16. Fouling factors of other fluids17. Specific and molar heat capacities of fluidsB. Overall heat transfer coefficient1. Approximate overall heat transfer coefficient2. Overall heat transfer coefficients “u” from heat transfer coefficients “3. Overall heat transfer coefficients from refinery process dataliquid hydrocarbons coolersgaseous hydrocarbons coolerstotal hydrocarbons condensers4. Overall heat transfer coefficients from general formulaC. Heat transfer coefficients ()1. Approximate heat transfer coefficients2. Tube side heat transfer coefficients as a function of the flow velocity3. Shell side heat transfer coefficients as a function of the flow velocity4. Tube side heat transfer coefficient5. Shell side heat transfer coefficientD. Heat calculations1. Heat load2. Heat exchange areaformula 1formula 23. Corrected effective temperature difference4. Corrected effective mean temperature differenceformula 1formula 2formula 35. Temperature efficiency factor6. Outlet temperature of the cold fluid7. Outlet temperature of the hot fluidE. Pressure losses in shell & tube heat exchangers1. Tube side pressure losstubes Pinlet nozzle Poutlet nozzle P2. Tube side pressure lossbaffle window Pshell tube Pnozzles PF. Useful geometrical calculations1. Tube sideflow cross sectionflow velocity in the tubesnumber of tubes per pass2. Tube side pressure lossflow cross sectioncross stream velocity through the tube bundlelongitudinal stream cross area in the baffle windowlongitudinal stream velocity through the baffle windowaverage shell side flow cross sectionaverage shell side flow velocitynumber of bafflesnumber of tube rows in cross stream between the baffle windowsnumber of total vertical tube rowsflow cross section for the longitudinal flow in the baffle windowdiametric shell to baffle clearanceG. Geometrical data of shell & tube heat exchangers according to din 28184 - 28191 and tema standardsH. shell and tube exchanger selection guideI. dimensionless numbersJ. thermal conductivity of heat exchanger metal of constructionII/CHARTSANDDIAGRAMSa. Tema heat exchanger tableb. AES exchanger nomenclaturec. AEP exchanger nomenclatured. AJW exchanger nomenclaturee. AKT exchanger nomenclaturef. BEM exchanger nomenclatureg. C
