  Rank: Advanced Member Groups: Registered
Joined: 18/12/2014(UTC)
Posts: 38
|
Hi All, I have a worksheet that I am trying to simplify for the data input, what I would like to do is combine all the relevant input data into one matrix, but avoiding the use of augment or stack functions, so effectively using the single data matrix as shown below, its the extraction of each row or column data to do the various calculations in an easy format, I know I can call each matrix element, but that would create a lot of work. I have attached the worksheet. Thanking in advance  Combining Test V2.sm (22kb) downloaded 10 time(s).
|
|
|
|
|
|
Rank: Advanced Member Groups: Registered
Joined: 18/12/2014(UTC)
Posts: 38
|
Hi Jean, I might not have explained it well enough, maybe the below is clearer, the matrix "data" is to be used and will be the only part filled in by the user, I know how to use the stack function, and as I said in my first post, I do not want to use this. 
|
|
|
|
|
|
 Rank: Advanced Member Groups: Registered, Advanced Member Joined: 10/11/2010(UTC) Posts: 1,494   Was thanked: 1274 time(s) in 745 post(s)
|
Indexes and function range(2) can be used.  |
Russia ☭ forever
Viacheslav N. Mezentsev |
|
|
|
|
|
Rank: Advanced Member Groups: Registered
Joined: 18/12/2014(UTC)
Posts: 38
|
Hi Uni,
That is brilliant, never knew that there was a function range for matrices, is this documented anywhere?
|
|
|
|
|
|
Rank: Advanced Member Groups: Registered
Joined: 23/07/2013(UTC) Posts: 1,128  Was thanked: 509 time(s) in 339 post(s)
|
If this not satisfy all your requests, please inform. PS: Oops, it seems uni is already answered your question. Shall delete if you think this post is unnecessary. Regards Combining Test V2_r1.sm (22kb) downloaded 8 time(s).Edited by user 19 November 2021 23:51:14(UTC)
| Reason: Not specified
|
 1 user thanked overlord for this useful post.
|
|
|
|
Rank: Advanced Member Groups: Registered, Advanced Member Joined: 10/11/2010(UTC) Posts: 1,494 Was thanked: 1274 time(s) in 745 post(s)
|
Originally Posted by: ianlh  That is brilliant, never knew that there was a function range for matrices, is this documented anywhere? Probably about a year ago there was a discussion of this possibility and somewhere there is a document that shows all the use cases. Unfortunately, I cannot remember this topic. |
Russia ☭ forever
Viacheslav N. Mezentsev |
|
|
|
|
|
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: uni Originally Posted by: ianlh That is brilliant, never knew that there was a function range for matrices, is this documented anywhere? Probably about a year ago there was a discussion of this possibility and somewhere there is a document that shows all the use cases. Unfortunately, I cannot remember this topic. Hi. Maybe from here: https://en.smath.com/for...atrix-from-a-matrix.aspxBest regards. Alvaro.
|
1 user thanked Razonar for this useful post.
|
|
|
|
Rank: Advanced Member Groups: Registered
Joined: 18/12/2014(UTC)
Posts: 38
|
Originally Posted by: Jean Giraud Originally Posted by: ianlh I might not have explained it well enough, maybe the below is clearer, the matrix "data" is to be used and will be the only part filled in by the user, I know how to use the stack function, and as I said in my first post, I do not want to use this. Easy to extract the numeric values from the string matrix. As the missing row for the suite, extract this one as well. Your summation code does not work in my Smath version. As it looks, your summation is the vector sum. Does not look correct vs my proposal... Visit below the red separator. Cheers ... Jean. Combining Test V2.sm (50kb) downloaded 7 time(s). Not sure what you mean by the "summation is the vector sum", if you are referring to the "A weighting" then this is just a simple addition, then the log summation is preformed to obtain the total sound level  an example: 
|
|
|
|
|
|
Rank: Advanced Member Groups: Registered
Joined: 18/12/2014(UTC)
Posts: 38
|
Originally Posted by: Jean Giraud ... simply go back post 9 ... comment/continue. There is no need to do a log addition when adding the "A weighting", the log addition comes when you need the the total overall sound level, plus the "mean" value you show has no bearing on acoustics. it is nothing. Thanks for all your help and insights into matrix manipulation.
|
|
|
|
|
|
 Rank: Guest
Groups: Registered
Joined: 04/07/2015(UTC) Posts: 6,866  Was thanked: 981 time(s) in 809 post(s)
|
Originally Posted by: ianlh Thanks for all your help and insights into matrix manipulation. Deleted previous attachments.
|
|
|
|
|
|
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.
