Using HAPropsSI within circular reference on Mac Excel 2011 causes div/0 error!

[zajaczkowski]

Hi! Here is another issue I found: if I use HAPropsSI within circular reference (iterative calculations) on Mac Excel 2011, lots of div/0 errors is showing up (popping up in a message window, not in cells). The same file opened on Windows Excel gives no problems at all.

At first I thought that maybe Excels on Mac and Windows do iterations differently. However, the message window looks like something produced by CoolProp, so maybe you could look into it.

Here is a simple file for testing: file-is-not-available-anymore You might need to switch on iterations.

Best!

[ibell]

Sounds like we need to find a way to clear the fpu bits like we did on
windows. I'll look into it.
On Dec 17, 2014 11:47 AM, "Bartosz Zajaczkowski" notifications@github.com
wrote:

Hi! Here is another issue I found: if I use HAPropsSI within circular
reference (iterative calculations) on Mac Excel 2011, lots of div/0 errors
is showing up (popping up in a message window, not in cells). The same file
opened on Windows Excel gives no problems at all.

At first I thought that maybe Excels on Mac and Windows do iterations
differently. However, the message window looks like something produced by
CoolProp, so maybe you could look into it.

Here is a simple file for testing:
https://dl.dropboxusercontent.com/u/17755628/hapropssi_error_11.xlsx You
might need to switch on iterations.

Best!

—
Reply to this email directly or view it on GitHub
#353.

[ibell]

I think I might have just fixed it, please let me know if that is the case.

On Wed, Dec 17, 2014 at 3:08 PM, Ian Bell ian.h.bell@gmail.com wrote:

Sounds like we need to find a way to clear the fpu bits like we did on
windows. I'll look into it.
On Dec 17, 2014 11:47 AM, "Bartosz Zajaczkowski" notifications@github.com
wrote:

Hi! Here is another issue I found: if I use HAPropsSI within circular
reference (iterative calculations) on Mac Excel 2011, lots of div/0 errors
is showing up (popping up in a message window, not in cells). The same file
opened on Windows Excel gives no problems at all.

At first I thought that maybe Excels on Mac and Windows do iterations
differently. However, the message window looks like something produced by
CoolProp, so maybe you could look into it.

Here is a simple file for testing:
https://dl.dropboxusercontent.com/u/17755628/hapropssi_error_11.xlsx You
might need to switch on iterations.

Best!

—
Reply to this email directly or view it on GitHub
#353.

[zajaczkowski]

I might be doing something wrong, but I've

• ...downloaded latest nightly shared library for OS X (according to date stamp it was updated yesterday) and saved it in /home/user/lib/
• ...downloaded latest xlam (from GitHub) and saved it in the same folder.
• ...added new add-in for Excel 2011.

No improvement... still the same error.

[ibell]

No more div/0, but the circular reference remains. Why are you doing this in the first place?

[ibell]

I'll let you know when the nightly files are up to date.

[ibell]

Ok, should be good in a minute or so.

[zajaczkowski]

Works like a charm! Thank you!
Among other things, I usually use circular references in calculations of heat exchangers. Normally is much faster to write simple procedure in Python, but with CoolProp in Excel it is very elegant way to show students how iterative calculation works.

[ibell]

Ah makes sense to me, but the solver in excel doesn't give you much control
over the iteration process, in my opinion better to get them going with
python.

In any case glad to hear this bug is dead.
On Dec 19, 2014 8:58 AM, "Bartosz Zajaczkowski" notifications@github.com
wrote:

Works like a charm! Thank you!
Among other things, I usually use circular references in calculations of
heat exchangers. Normally is much faster to write simple procedure in
Python, but with CoolProp in Excel it is very elegant way to show students
how iterative calculation works.

—
Reply to this email directly or view it on GitHub
#353 (comment).