Hello,

would be very useful to me, and maybe for most mechanical, chemical, civil (e other) engineers (and students, of course) to have internal material data inside Smath (maybe, as a plugin).
This feature, with some nonlinear system solver with units support, would turn Smath into a nice alternative to EES (http://www.fchart.com/ees/)

For small calculations, you can put some table data in a matrix, and use submatrix and cols functions to extract the vectors to be interpolated, but it may be very time consuming, and you have to be very careful about units.

A workaround is to create various snippets, one for each Property and Material (SuperHeatedSteam_Enthalpy, Air_density...) with internal function, similar to the attachment, or create a complicated snippet with all data about a material, with the bult-in functions for properties (this would be probably the closest to the plugin code, but would turn the smallest calculation into a huge worksheet)..

The problem is that some tables are more complicated to interpolate, like this: http://server.fst.uga.ed...ated%20Steam%20Table.jpg (what if I want Enthalpy for lets say, 45kPa and 156ºC? It's just an example, anyway)..

Also, not all users may want to spend time to create so many snippets, or know which internal functions to use to achieve his goal, so a plugin like this would help a lot (and probably bring lots and lots of users ).

Sorry about my english, it's getting rust,

Danilo Monteiro

Oh, that may help.
But we could not extend it (add tables for other fluids, etc.)
Anyway, if this work, will be one less snippet to create, thanks!

__________________________________________________________________

It didn't work

Edited by user 24 April 2013 02:50:38(UTC)  | Reason: Not specified

I found these sources about xsteam:

https://sourceforge.net/projects/xsteam/
http://xsteam.sourceforge.net/

But the download links are directing to the offline site

This implementation look way more complicated than table interpolation
http://www.iapws.org/relguide/IF97-Rev.pdf

Also, is only for water/steam..

Edited by user 26 April 2013 06:33:05(UTC)  | Reason: Not specified

Well it is different from your interpolating approach and just for water but it could be extended with other resources. It would be a nice occasion to see SMath handling units, maybe the NonlinearSolvers plugin would come in handy.
XSteam is a well regarded resource in some universities from USA, Spain and Italy (I found the ods version in a engineering department from Italy).
It is only for water yet useful in lots of energy/exergy efficiency analysis like this one in excel:
http://personales.upv.es...a/CT/T4/SCE1_2012res.xls
The derivative work from the University of Alabama includes also a couple of refrigerants, which could show us the direction to consider more substances, either by using correlations or interpolating tabular data as you suggested.


Fine, I meant the possibility of porting the actual macros into C# code.
For now I lack coding skills ^^ but this reference could be useful in the future:

"VSTO, visual studio tools for office","convert vba to vb.net"
Migrating an Excel VBA Add-in to a VB.Net XLL with Excel-Dna

Edited by user 27 April 2013 13:52:07(UTC)  | Reason: Not specified

I found XSteam dll version!
Updated download link.

Edited by user 27 April 2013 13:55:49(UTC)  | Reason: Not specified

I've found these libraries for computing water properties using IAPWS-IF97 formulation :
Properties of water DLL coded in C#
Freesteam

And these are other .net libraries which might be useful:
CoolProp Property database that includes pure fluids, pseudo-pure fluids, and humid air properties.
Nature. API for computing physical properties of complex gas mixtures.

Edited by user 19 July 2013 14:48:57(UTC)  | Reason: Not specified