SMath Studio Forum
»
SMath Studio
»
Questions
»
Units in variables from a matrix
 Rank: Newbie
Groups: Registered
Joined: 11/06/2023(UTC)
Posts: 3
|
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
|
|
|
|
|
|
 Rank: Guest
Groups: Registered
Joined: 04/07/2015(UTC) Posts: 6,866  Was thanked: 981 time(s) in 809 post(s)
|
Suggestive ... 
|
|
|
|
|
|
 Rank: Advanced Member Groups: Registered
Joined: 23/07/2013(UTC) Posts: 1,128  Was thanked: 509 time(s) in 339 post(s)
|
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
|
|
|
|
|
|
Rank: Advanced Member Groups: Registered
Joined: 28/08/2014(UTC) Posts: 1,356  Was thanked: 815 time(s) in 516 post(s)
|
Originally Posted by: RC_eng  ... 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?  Best regards. Alvaro.
|
|
|
|
|
|
Rank: Guest
Groups: Registered
Joined: 04/07/2015(UTC) Posts: 6,866 Was thanked: 981 time(s) in 809 post(s)
|
Originally Posted by: Jean Giraud Suggestive ... ... Think in terms of sub-utilities you may need to apply.
|
|
|
|
|
|
Rank: Advanced Member Groups: Registered
Joined: 23/07/2013(UTC) Posts: 1,128 Was thanked: 509 time(s) in 339 post(s)
|
Originally Posted by: Razonar 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. 
|
 1 user thanked overlord for this useful post.
|
|
|
|
Rank: Newbie
Groups: Registered
Joined: 11/06/2023(UTC)
Posts: 3
|
 Worksheet1.sm (8kb) downloaded 7 time(s). data_forum.xlsx (9kb) downloaded 7 time(s).Thanks for your replies, here are the files. I would like to display variable z as kN/m instead of that kg/s^2 Edited by user 12 June 2023 09:32:35(UTC)
| Reason: wrong files attached
|
|
|
|
|
|
 Rank: Advanced Member Groups: Registered, Advanced Member Joined: 13/01/2012(UTC) Posts: 2,648   Location: Italy Was thanked: 1331 time(s) in 876 post(s)
|
You have to customize the result units in the rightmost placeholder. ![2023-06-12 10_26_44-SMath Solver - [Worksheet1.sm_].png](/forum/resource.ashx?a=47324&b=2) |
If you like my plugins consider to support SMath Studio buying a plan; to offer me a coffee: paypal.me/dcprojects |
1 user thanked Davide Carpi for this useful post.
|
|
|
|
Rank: Newbie
Groups: Registered
Joined: 11/06/2023(UTC)
Posts: 3
|
Originally Posted by: Davide Carpi You have to customize the result units in the rightmost placeholder. 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 
|
|
|
|
|
|
Rank: Advanced Member Groups: Registered, Advanced Member Joined: 13/01/2012(UTC) Posts: 2,648 Location: Italy Was thanked: 1331 time(s) in 876 post(s)
|
You're welcome |
If you like my plugins consider to support SMath Studio buying a plan; to offer me a coffee: paypal.me/dcprojects |
|
|
|
|
|
SMath Studio Forum
»
SMath Studio
»
Questions
»
Units in variables from a matrix
Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.
