Calculating Thermo Properties of Water in Excel

[traijan]

Hi - I am currently working on a paper verifying some thermal hydraulic code against experimental test data for subcooled water subchannel flow. I have close to 1000 points in excel all listed with T & P and the process for inputting the corresponding enthalpies for subcooled water by lookup table is dreadfully slow (the code requires the enthalpy - no built in look up table) Does anyone have any advice for correlations or calculations I can input to excel to perform the enthalpy calcs? Thank you!

 

[mfb]

I don't understand what you are asking. What exactly takes time (and is it your time or computation time) and how do you want to reduce that?
Correlations between what, calculations for what, based on what?

 

[Q_Goest]

Does anyone have any advice for correlations or calculations I can input to excel to perform the enthalpy calcs? Thank you!

Perhaps REFPROP would help. It's a database of thermophysical properties that can be accessed by Excel. It has a lot more than water in it, but it's not particularly expensive. Basically, you put a specific code into the cell similar to a lookup function and it brings back some property of the fluid you're looking for such as enthalpy (or density, entropy, etc...). There's a list of properties on the web site.

You can research it and purchase it online here:
http://www.nist.gov/srd/nist23.cfm