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 (21 КиБ) скачан 35 раз(а).

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.

Indexes and function range(2) can be used.

Hi Uni,

That is brilliant, never knew that there was a function range for matrices, is this documented anywhere?

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 (21 КиБ) скачан 30 раз(а).

Wrote

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.

Wrote

Wrote

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/forum/yaf_postst7741_Extracting-matrix-from-a-matrix.aspx

Best regards.
Alvaro.

Wrote

Wrote

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 (49 КиБ) скачан 29 раз(а).

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:

Wrote

... 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.

Wrote

Thanks for all your help and insights into matrix manipulation.

Deleted previous attachments.