This spreadsheet provides a template for analysis of the Rankine (steam) thermodynamic power cycle. The user fills  in the state point data in the top grid from other software or table lookup. From that data, the worksheet updates cells in the second (Processes) grid.  In addition, theworksheet generates Pressure-volume (P-v) and Temperature-entropy (T-s) diagrams.

For best results download the handy (and free) Excel “add-in” from Coolprop. That easy-to-implement add-in provides functions for all the properties of water you’ll need in completing this spreadsheet.  (It cludes 150+ other fluids as well). The logic is no different than manual table look-up and interpolation. Provide two independent properties, e.g., P (pressure) and Q (quality) and the function returns any of the others (U, T, H, S, etc.)

Once you have implemented these functions properly, then the whole spreadsheet updates whenever any input parameter (those having the green background in the screen grab below) is changed.   That makes it simple to assess the effects of various inputs. This spreadsheet includes a VBA function that allows you to run a sequence of cases automatically.   That way you can assess the sensitivity of one variable, e.g., the cycle efficiency, to another parameter, e.g., the turbine inlet pressure.

With use of the Coolprop add-in, this workbook can just as easily be used for organic Rankine cycle analysis.