Spreadsheet Calculations of Thermodynamic （电子表格计算热力学）.pdfVIP

Spreadsheet Calculations of Thermodynamic Properties Larry Caretto, David McDaniel, Tom Mincer CSU, Northridge/US Air Force Academy/CSU, Northridge Abstract A thermodynamic property calculation tool has been developed based on the Excel™ spreadsheet program. This tool can be used to determine individual state points by a graphical user interface (GUI) calculator. In addition, spreadsheet cell formulas and Visual Basic function calls can also be used to build models of thermodynamic systems. The resulting model can be used to show the effects of parameter changes on overall results such as cycle efficiency, power production, refrigeration load and coefficient of performance. In addition, the Excel™ GoalSeek or Solver tools can be used to solve systems of equations or to determine system parameters that give a constrained optimum condition. The software is available at no cost. Introduction Computer calculation of thermodynamic properties is an efficient replacement for property tables, which are still used in thermodynamics instruction. Computerized property calculations are used routinely in engineering applications. They are available from a variety of sources, such as the National Institute of Standards and Technology.1 Computer property calculations are a part of current thermodynamics texts. The book by Çengel 2 and Boles includes an academic version of the Engineering Equation Solver (EES) that allows students to formulate thermodynamic problems as a set of equations that may involve thermodynamic property calculations. EES is then able to solve a properly posed problem. It can also be used for finding an individual property at a single state. The texts by Sonntag et al.3 and Moran and Shapiro4 include programs that can find state properties or generate tables. Several recent ASEE papers have discus