Units in variables from a matrix

Units in variables from a matrix - 消息

#1 已发布: 2023/6/11 06:37:44
AR

AR

0个赞,共3个帖子。

组: User

Hi

I have a dataset (using Excel-file as a source) from where I get values with vlookup, but I am unable to set units properly.

Values retrieved from a matrix have these square brackets around them [], and it makes working with units really difficult.

I was able to convert mm to m (my database has plain values, but they are supposed to be mm). But next step is to display final results in kN/m, but I keep getting kg/s^2.

I am able to remove units completely and display the correct result without units displayed, but this is suboptimal.

EDIT: I'm using importData plugin
#2 已发布: 2023/6/11 09:51:55
Jean Giraud

Jean Giraud

983个赞,共6,866个帖子。

组: User

Suggestive ...

VectorUnits.PNG
#3 已发布: 2023/6/11 11:37:52
overlord

overlord

600个赞,共1,381个帖子。

组: Moderator

You either need to alter your dataset or do corrections after import.
I am not promising anything but maybe units can be imported as they are.
But we need your dataset and smath file for to check if it can be done.

Regards
#4 已发布: 2023/6/11 15:32:41
Alvaro

Alvaro

1,139个赞,共1,805个帖子。

组: User

Wrote

... I was able to convert mm to m (my database has plain values, but they are supposed to be mm). But next step is to display final results in kN/m, but I keep getting kg/s^2. ...



Hi. Something like this?

Clipboard01.png

Best regards.
Alvaro.
#5 已发布: 2023/6/11 15:52:33
Jean Giraud

Jean Giraud

983个赞,共6,866个帖子。

组: User

Wrote

Suggestive ...


... Think in terms of sub-utilities you may need to apply.
#6 已发布: 2023/6/11 18:35:16
overlord

overlord

600个赞,共1,381个帖子。

组: Moderator

Wrote

Hi. Something like this?

Best regards.
Alvaro.


My guess is his data is something like this.
That's what I deduce from his description at least.
Without him posting datasheet we can't help any further.

2023-06-12_00-33.png
1位用户喜欢此帖子
Alvaro 2023/6/11 23:10:00
#7 已发布: 2023/6/12 03:30:41
AR

AR

0个赞,共3个帖子。

组: User

未找到文件。未找到文件。

Thanks for your replies, here are the files.

I would like to display variable z as kN/m instead of that kg/s^2
#8 已发布: 2023/6/12 05:29:17
Davide Carpi

Davide Carpi

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

组: Moderator

You have to customize the result units in the rightmost placeholder.

2023-06-12 10_26_44-SMath Solver - [Worksheet1.sm_].png
If you like my plugins please consider to support the program buying a license; for personal contributions to me: paypal.me/dcprojects
1位用户喜欢此帖子
sergio 2023/6/12 05:44:00
#9 已发布: 2023/6/12 07:01:46
AR

AR

0个赞,共3个帖子。

组: User

Wrote

You have to customize the result units in the rightmost placeholder.

2023-06-12 10_26_44-SMath Solver - [Worksheet1.sm_].png



Thank you! I don't know how I didn't get that working couple days ago, I tried to write units outside of brackets but didn't succeed. But now it works no problem
#10 已发布: 2023/6/12 08:43:56
Davide Carpi

Davide Carpi

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

组: Moderator

You're welcome
If you like my plugins please consider to support the program buying a license; for personal contributions to me: paypal.me/dcprojects
  • 有新帖
  • 无新帖