Overview

Heat Exchanger Excel Workbook: The Ultimate Engineering ToolkitEssential Calculations, Standards, Charts & Data for Heat Exchanger Design, Selection, and MaintenanceUnlock a powerful, easy-to-use Excel workbook designed specifically for engineers, designers, and technical professionals working with heat exchangers in oil & gas, chemical, petroleum, and refining industries. This comprehensive toolkit streamlines your workflow and puts vital technical data and calculations at your fingertips.Key Features & BenefitsComprehensive Technical DataPhysical properties of common process fluids used in heat exchangersThermal conductivity values for widely used construction materialsHeat transfer coefficients ("U" and "α") for various applicationsAdvanced Engineering CalculationsPressure loss calculations for both tube and shell sides in shell and tube exchangersGeometrical calculations for shell and tube configurationsDesign data compliant with DIN 28184 & 28191 and TEMA StandardsSelection & Sizing ToolsStep-by-step guidelines for selecting the right shell and tube heat exchangerGeometrical data tables to assist with accurate sizing and specificationValuable Charts & DiagramsReady-to-use heat exchanger charts, figures, and diagramsNumerous conversion tables for quick referenceUser-Friendly, Organized & PracticalWell-structured worksheets make it easy to find the data and tools you needIdeal for design, operation, maintenance, and inspection tasksWho Is This Workbook For?Process, chemical, and mechanical engineersPlant designers and maintenance professionalsEngineering students and technical traineesAnyone involved in heat exchanger design, selection, or troubleshootingWhy Choose This Workbook?Save Time: Access all essential formulas, data, and standards in one placeImprove Accuracy: Minimize errors with built-in calculations and up-to-date standardsWork Smarter: Streamline project workflows with ready-to-use engineering toolsEquip yourself with the Heat Exchanger Excel Workbook and make your next project faster, easier, and more reliableWR Training - Your Partner in Process Engineering & Plant ExcellenceSpread the wings of your knowledge--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.--HEAT EXCHANGER DESIGN AND CALCULATION EXCEL WORKBOOK: TABLE OF CONTENTAn Excel VBA 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/ CHARTS AND DIAGRAMSa. Tema heat exchanger tableb. AES exchanger nomenclaturec. AEP exchanger nomenclatured. AJW exchanger nomenclaturee. AKT exchanger nomenclaturef. BEM exchanger nomenclatureg. CFU exchanger nomenclatureh. Heat exchanger design procedurei. Heat exchanger selection guidelinesj. Tube patternsk. Bafflesl. LMTDm. TEMA data sheet for shell & tube heat exchangersn. Comparison of TEMA class R, C and B heat exchangerso. Shell and tube exchanger features according to type of designp. Conversion tablesNOTEThis Excel workbook includes Visual Basic for Application function subroutines. Macros must be enabled for them to work.DISCLAIMERThis 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.

Skills

Reviews