Last Updated: 5/18/2012



Free Excel/VBA Spreadsheets for Thermodynamics:

Rankine, Brayton, Otto and Diesel Cycles

 

Usage, Disclaimer, Notes


 

Brayton Cycle (Cold Air Standard) Template including Regeneration (Updated 6/21/2010)

 

This spreadsheet provides a template for analysis of the Brayton Cycle using the Cold Air Standard (constant specific heats).  The user must fill in the data in the top grid.  From that data, the cells in the second grid are updated, and Pressure-volume and Temperature-entropy diagrams are generated.  Make sure your volume is set up high when you open it!   A second sheet in the same workbook (not seen below but operating in a similar fashion) is set up to include Regeneration.  For photos of aircraft powered by the Brayton cycle (Turbofans and Turboprops) as well as some powered by the Otto cycle, click here.

 

 

 


Rankine Cycle Template (Updated 6/21/2010)

 

This spreadsheet provides a template for analysis of the Rankine (Steam) Cycle.  The user must fill in the data in the top grid (from other software or table lookup).  From that data, the cells in the second grid are updated, and Pressure-volume and Temperature-entropy diagrams are generated.   If you use the thermal properties Excel add-in from Spreadsheetworld.com, then you can have the whole spreadsheet update whenever any input parameter is changed.

 

 

 


Otto Cycle Template (Updated 5/12/09)

 

This spreadsheet provides a template for analysis of the Otto (spark-ignition, internal combustion) Cycle.  The user must fill in the data in the top grid (from other software or table lookup).  From that data, the cells in the second grid are updated, and Pressure-volume and Temperature-entropy diagrams are generated.   If you use the thermal properties Excel add-in from Spreadsheetworld.com, then you can have the whole spreadsheet update whenever any input parameter is changed.  This updated spreadsheet includes the capability of doing a sensitivity analysis.  Turn up your volume before opening!    For more on large aircraft engines using the Otto cycle, click here. 

 

 

 


Diesel Cycle Template (New 5/28/2009)

 

This spreadsheet provides a template for analysis of the Diesel (compression-ignition, internal combustion) Cycle.  The user must fill in the data in the top grid.  From that data, the cells in the second grid are updated, and Pressure-volume and Temperature-entropy diagrams are generated.   This workbook includes the capability of doing a sensitivity analysis.   

 

 

 

Back to Spreadsheets Main Page


Back to Heat Transfer Tools Main Page

R. J. Ribando Home