Rank: Advanced Member Groups: Registered
Joined: 22/02/2023(UTC) Posts: 34 Location: Seoul Was thanked: 1 time(s) in 1 post(s)
|
I would like to have a function like lookup (vlookup, hlookup) in smath. thank you. bar size.sm (7kb) downloaded 11 time(s).
|
1 user thanked soomoon for this useful post.
|
|
|
Rank: Advanced Member Groups: Registered
Joined: 12/02/2018(UTC) Posts: 62 Location: Belém Was thanked: 7 time(s) in 6 post(s)
|
findrows function within Special Functions plugin is what you're looking for, soomoon
|
|
|
|
Rank: Guest
Groups: Registered
Joined: 04/07/2015(UTC) Posts: 6,866 Was thanked: 981 time(s) in 809 post(s)
|
Originally Posted by: soomoon I would like to have a function like lookup (vlookup, hlookup) in smath. Find Index Key Code is lot more powerful. Assume your Customer wants more information from his bar diameter you can give all pertaining informations ... Add price column, material, delivery ... etc. Cheers ... Jean bar size Findndex KeyCode.sm (11kb) downloaded 36 time(s).
|
|
|
|
Rank: Advanced Member Groups: Registered
Joined: 05/06/2014(UTC) Posts: 348 Location: Colombo Was thanked: 127 time(s) in 82 post(s)
|
|
Look within!... The secret is inside you. Best Regards Eng. NDTM Amarasekera - Sri Lanka |
1 user thanked ndtma for this useful post.
|
|
|
Rank: Advanced Member Groups: Registered
Joined: 12/02/2018(UTC) Posts: 62 Location: Belém Was thanked: 7 time(s) in 6 post(s)
|
Jean, your example shows EXACTLY what findrows does.
|
|
|
|
Rank: Guest
Groups: Registered
Joined: 04/07/2015(UTC) Posts: 6,866 Was thanked: 981 time(s) in 809 post(s)
|
Originally Posted by: joaobr Jean, your example shows EXACTLY what findrows does Yes for that simple application. FindIdx(V,x,col) gives me more for advanced Engineering works Thanks for the observation.
|
|
|
|
Rank: Advanced Member Groups: Registered
Joined: 23/07/2013(UTC) Posts: 1,131 Was thanked: 511 time(s) in 341 post(s)
|
|
|
|
|
Rank: Advanced Member Groups: Registered
Joined: 05/06/2014(UTC) Posts: 348 Location: Colombo Was thanked: 127 time(s) in 82 post(s)
|
findrows() function revisited. As a part of a project undertaken to study flows of some perennial streams in Sri Lanka, a particular stream, located far away from Colombo, was selected and a Rating Table (RT) was prepared relating water levels to flows. This process took a few years so that the data would almost cover reasonable range of depths for practical reasons, excluding severe floods. During this period, an electronic device was also constructed to measure water levels (WL) and transmit as digital signals to control station in Colombo. However, the numerical values of transmitted WL had more than 6 decimals, whereas the Rating Table (RT) was calibrated only to 2 decimals. Hence, initially WL values had to be refined to 2 decimals for use with RT values. Earlier a vlookup function which was posted in the forum was used, but it took a long time to process But when the findrows function was available, data processing was dramatically fast. Both Excel and SM files must be in the same folder. Cheers 1.July WL&RT.xlsx (30kb) downloaded 17 time(s). Find_Flows-R1.sm (27kb) downloaded 20 time(s). Find_Flows-R1.pdf (235kb) downloaded 30 time(s).Edited by user 07 March 2023 19:00:22(UTC)
| Reason: Not specified |
Look within!... The secret is inside you. Best Regards Eng. NDTM Amarasekera - Sri Lanka |
1 user thanked ndtma for this useful post.
|
|
|
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.