Equipped with its Solver and-in and VBA, Microsoft Excel makes an ideal educational platform for design analyses of fluid-thermal systems. This paper illustrates this capability by considering a common type of these s...Equipped with its Solver and-in and VBA, Microsoft Excel makes an ideal educational platform for design analyses of fluid-thermal systems. This paper illustrates this capability by considering a common type of these systems;which is the double-pipe heat exchanger. While Solver is used for the optimisation analysis, VBA is used for the development of a user-defined function (UDF) that determines the optimum standard-pipe size for the system.展开更多
The quenching of a metal component with a channel section in a water tank is numerically simulated.Computational fluid dynamics (CFD) is used to model the multiphase flow and the heat transfer in film boiling,nucleate...The quenching of a metal component with a channel section in a water tank is numerically simulated.Computational fluid dynamics (CFD) is used to model the multiphase flow and the heat transfer in film boiling,nucleate boiling and convective cooling processes to calculate the difference in heat transfer rate around the component and then combining with the thermal simulation and structure analysis of the component to study the effect of heat transfer rate on the distortion of the U-channel component.A model is also established to calculate the residual stress produced by quenching.The coupling fluid-thermal-structural simulation provides an insight into the deformation of the component and can be used to perform parameter analysis to reduce the distortion of the component.展开更多
文摘Equipped with its Solver and-in and VBA, Microsoft Excel makes an ideal educational platform for design analyses of fluid-thermal systems. This paper illustrates this capability by considering a common type of these systems;which is the double-pipe heat exchanger. While Solver is used for the optimisation analysis, VBA is used for the development of a user-defined function (UDF) that determines the optimum standard-pipe size for the system.
文摘The quenching of a metal component with a channel section in a water tank is numerically simulated.Computational fluid dynamics (CFD) is used to model the multiphase flow and the heat transfer in film boiling,nucleate boiling and convective cooling processes to calculate the difference in heat transfer rate around the component and then combining with the thermal simulation and structure analysis of the component to study the effect of heat transfer rate on the distortion of the U-channel component.A model is also established to calculate the residual stress produced by quenching.The coupling fluid-thermal-structural simulation provides an insight into the deformation of the component and can be used to perform parameter analysis to reduce the distortion of the component.