Ex8_1 - VisualBasic does not distinguish between a blank...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
Sheet1 Page 1 Example8.1 -- Rankine cycle This spreadsheet checks the calculation of water properties following the formulae and values in W.C. Reynolds, Thermodynamic Properties in SI, Mechanical Engineering, Stanford University, Stanford CA 94305-3030 (Copyright 1979 Department of Mechanical Engineering, Stanford U.) Programing copyright J. Lewalle 1995. The order of the properties in the vector must be T,P,V,u,h,s,x Also, use conventional metric system (not SI) at input/output To use as part of problem solving, just keep the vector of properties (and units) below, everything else can be deleted except for the modules. To see the modules, pull down Tools, click on Macro, then VisualBasic editor, and open the Modules Known bug:
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: VisualBasic does not distinguish between a blank cell and a value 0 When looking for sat. liquid properties, enter a small value of x rather than 0 Refer to water_si.xls for testing of various combinations of properties. T p v u h s x State 1 8000 1 ### ### #MACRO? #MACRO? #MACRO? #MACRO? ### State 2 8 #MACRO? ### ### #MACRO? #MACRO? #MACRO? #MACRO? ### w_s = ### State 3 8 0.0001 ### ### #MACRO? #MACRO? #MACRO? #MACRO? ### q_in = ### State 4 8000 #MACRO? ### ### #MACRO? #MACRO? #MACRO? #MACRO? ### w_s = ### eta_th = ### The function call is: =properties(T:x) as an array function (calculate the entire vector , use Ctrl-Shift-Enter, as a function of the entire vector of data (blanks and all)....
View Full Document

{[ snackBarMessage ]}

Ask a homework question - tutors are online