Error: -1.#IND for HAPropsSI_temp in Excel

Almenj commented 3 years ago

When trying to determine parameters based on particular dry bulb temps and specific enthalpies, I'm getting an overflow error from Excel.

Example formula: = HAPropsSI("W","Tdb",29.4+273.15,"H",62890,"P",101700)

When stepping through the code, the HAPropsSI function sets HAPropsSI_temp as -1.#IND, causing an overflow error.

However for other values, this formula works. For example: = HAPropsSI("W","Tdb",29.4+273.15,"H",64330,"P",101700) returns 0.0136.

I am using:

Many thanks

Almenj commented 3 years ago

Chart

Running through some other enthalpy values, no clear pattern there.

ibell commented 3 years ago

What relative humidities do these enthalpies correspond to?

Almenj commented 3 years ago

Hi Ian,

Thanks for following up.

Some files below that hopefully help 👍

CoolProp / CoolProp