Import/Export to/from xlsx

Import/Export to/from xlsx - 消息

#1 已发布: 2013/8/21 20:24:41
tedd

tedd

0个赞,共9个帖子。

组: User

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?
#2 已发布: 2013/8/21 21:05:49
Davide Carpi

Davide Carpi

1,443个赞,共2,936个帖子。

组: Moderator

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
2013-08-22 03_07_07-SMath Studio Desktop - [UnitFromPlain.sm].png
If you like my plugins please consider to support the program buying a license; for personal contributions to me: paypal.me/dcprojects
#3 已发布: 2013/8/22 12:46:57
tedd

tedd

0个赞,共9个帖子。

组: User

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
#4 已发布: 2013/8/22 13:07:54
Martin Kraska

Martin Kraska

1,362个赞,共2,276个帖子。

组: Moderator

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.
Technische Mechanik mit SMath Studio: https://link.springer.com/book/10.1007/978-3-658-50592-9
1位用户喜欢此帖子
Davide Carpi 2013/8/22 16:50:00
#5 已发布: 2013/8/22 17:05:40
Davide Carpi

Davide Carpi

1,443个赞,共2,936个帖子。

组: Moderator

Wrote

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



that's a very good idea
If you like my plugins please consider to support the program buying a license; for personal contributions to me: paypal.me/dcprojects
#6 已发布: 2013/8/22 18:10:30
tedd

tedd

0个赞,共9个帖子。

组: User

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
  • 有新帖
  • 无新帖