|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/heat-exchangers-design-calculation-excel-workbook/
课程评论：没有评论
课程名称：《热交换器设计与计算 Excel 工作簿》 概述： 该课程提供了一个强大的 Excel 工作簿，专为在油气、化工、石油及精炼行业中工作的工程师、设计师和技术专业人士设计。这一综合工具包简化了工作流程，让您能够轻松获取热交换器设计、选择和维护所需的重要技术数据及计算。 关键特点与优点： - **全面的技术数据**：包括常见工艺流体的物理性质、广泛使用的建材的热导率、各种应用的热交换系数等。 - **先进的工程计算**：提供壳管式热交换器的压力损失计算和几何计算，符合DIN 28184、28191和TEMA标准的设计数据。 - **选择与尺寸工具**：提供选择合适的壳管式热交换器的逐步指南，及精确尺寸和规格的数据表。 - **实用的图表与图示**：现成的热交换器图表、图形和示意图，以及快速参考的转换表。 - **用户友好、结构清晰**：组织良好的工作表，方便查找所需的数据和工具，适用于设计、操作、维护和检查任务。 适用人群： - 工程师（过程、化工、机械） - 工厂设计师和维护专业人士 - 工程学生及技术培训生 - 任何参与热交换器设计、选择或故障排除的人士 为什么选择该工作簿？ - **节约时间**：在一个地方获取所有必要的公式、数据和标准。 - **提高准确性**：通过内置计算和最新标准减少错误。 - **更高效的工作方式**：使用现成的工程工具简化项目工作流程。 注意事项： - 需在计算机上安装 Microsoft Excel，并具备基本的 Excel 使用知识。 - 此工作簿包含 VBA 函数子例程，需启用宏才能正常工作。 免责声明： 本热交换器 Excel 工作簿由 WR Training 提供，按现状提供，不承担任何明示或暗示的担保责任。对于因使用本工作簿而引发的任何直接或间接的损害，著作权拥有者或贡献者不承担责任。
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.
