I make frequent use of steam table calling functions in my Excel spreadsheets, and I would like to use this capability within Mathcad Prime 3.0. However, so far I have been unable to figure out how to bring a sheet with it's steam table calls into an Excel component in Mathcad Prime 3.0.
I think the functions are inside of a couple of .bas files, and I have tried to save those in the Excel component, but this seems to cause trouble with Mathcad.
I will attach a small sample Excel file showing how the calls work.
If anyone can advise how to make this work I would very much appreciate it.
P.S. The steam calls in this sheet are the work of Magnus Holmgren (formerly of www.x-eng.com) However, he seems to have dropped out of site. I was unable to find him when I last tried some months ago. Anybody know what happened to him?