I'm attempting to use the same set of parameters in sMath calculations as I use in Autodesk Inventor CAD files. Inventor requires the parameters to be recorded in either a .xls or a .xlsx file. The method I've settled on is to create the parameter sheet in Excel in the format that Inventor requires, and then importData into sMath. The problem is the units. Inventor requires a rigid spreadsheet format: parameter_name, value, unit, and the units must be in plain text (mm, m/s, etc.)

So I can import the parameters into sMath as an nx3 matrix, and I can see what the unit for each parameter is meant to be ("mm", "m/s", etc.). But how do I assign that unit to the parameter?

You can try with a loop in the matrix where you multiply the 2nd row value with the 3rd row value using the attached function

That's a naive solution, so if you have something like 1/s replace it with Hz or s^-1 (if possible).


regards,

Davide

---

Davide:

Thanks, that works great!

Perhaps the next step, for me, is to figure out how to turn that into a plugin. The company I work for is standardizing on sMath for engineering calculations, and I would like all our engineers to share parameter files between sMath and the CAD system, but most of the other engineers will only adopt it if I make it user friendly.

Tedd

Wrote

Perhaps the next step, for me, is to figure out how to turn that into a plugin. The company I work for is standardizing on sMath for engineering calculations, and I would like all our engineers to share parameter files between sMath and the CAD system, but most of the other engineers will only adopt it if I make it user friendly.

Tedd

May be you want to have a look at the SMath viewer.

Wrote

May be you want to have a look at the SMath viewer.

that's a very good idea

Martin:

Thank you, that is a great idea. I did not know about the viewer.

Even if I decide not to use it for this particular thing, I'm sure I will want to use it for other things.

Tedd