Externally indexed torrent

If you are the original uploader, contact staff to have it moved to your account

Textbook in PDF format

Microsoft Excel is a general-purpose application that is taught to engineering students in the introductory courses on computer applications. The powerful tools of Excel for data analysis and visualisation, together with its wide availability and simplicity, encouraged its use as an educational tool in various engineering subjects. With respect thermofluid analyses, a number of articles and research papers have been presented in this regard at various conferences and specialised publications over the past two decades. The lack of built-in functions in Excel for fluid properties also motivated a number of academic institutions and individual researchers to develop relevant Excel add-ins. However, a textbook that presents a general pedagogical approach for using Excel as a platform for computer-aided thermofluid analyses and provides the lecturers and students with sufficiently detailed examples and exercises has, so far, been missing. The aim of this book is to complement the previous efforts by gathering the information needed for using Excel as an effective modelling platform for various types of computer-aided thermofluid analyses. The Excel-based modelling platform described in the book has four elements Excel with its user-interface and built-in functions, (ii) the integrated programming language Visual Basic for Applications (VBA), the Solver add-in that comes with Excel, and (iv) an Excel add-in for fluid properties called Thermax. While Excel and Solver are adequate for most fluid mecanics and heat-transfer analyses, the Thermax add-in helps the students to perform thermodynamic analyses with Excel in an effective and accurate manner. VBA is needed for the development of custom functions when the analytical model cannot be executed by only using Excel‟s built-in functions and Thermax functions. Proper use of the Excel-based modelling platform minimises the effort of developing the analytical model so that more attention can be paid to the application of the physical and economic principles in thermofluid analyses. The first three chapters of the book review the basic principles of thermofluid analyses and describe the four components of the Excel-based modelling platform. Chapter 4 is also a general chapter that shows how Excel and its iterative tools can be used for performing iterative solutions in the three thermofluid areas. The following six chapters apply the platform for particular types of thermofluid analyses. Chapters 5 and 6 are dedicated to the hydraulic analyses of pump-pipe systems and pipe-networks, while Chapters 7 and 8 deal with heat-transfer analyses by focussing on the numerical solution of the heat-conduction equation by using the finite-difference method. The application of the Excel-based platform for thermodynamic analyses is demonstrated in Chapters 9 and 10 that use the property functions provided by the Thermax add-in for ideal gases and refrigerant fluids for dealing with the analyses of power-generation and refrigeration cycles. The book adopts a learning-by-example approach and most of its examples are based on relevant cases or examples given in popular thermofluid textbooks so that the students can verify their Excel solutions and look for additional applications. Exercises are given at the end of each chapter that help students to sharpen their skills related to the particular topic. The material covered in the book is adequate for a stand-alone course on computeraided thermofluid analyses, but the book can also be used to supplement the existing relevant courses by selecting certain chapters or sections from it. Although the book is primarily meant for educational purposes, it is hoped that the material covered in the book can also be useful for practicing engineers in the area of thermofluid systems