DIAdem
average with StatBlockCalc
Hello everybody, I'm new here, so nice to meet you all!
I have the first 2 columns of a table like this one:
and like named in the table, I need a third column that calculates the avarage only for a certain time and not for the whole channel. So I tryed "StatBlockCalc", but in my case I can't set fix values for "RowNoStr", because they differ for every new experiment. Of course in this example I could use 1-5 and in a second new generated column I could use 6-8 and so on and somehow I would combine all the new columns to a big one. But I would love to use something automatic. They way I tryed seems maybe a little bit complicated:
I created a new column with the same values like in column "time" but starting one line later (due to fixed length of the channel, I have lost the last value of the time). Now I subtracted this row from the original one and when the difference was bigger than 1, I knew that here was the beginning of a new average. So I could realize that I got a zero in the "value" column in every line that had this difference bigger than 1. Then I tryed to split my channel via "ChnSplitAtValue" but is wasn't working. If it would work, I would make this splitting-step again and again, calculate the avarage for every (now complete) channel and then put all the channels again together to a big one. The problem now would be the automation. I could split my channel once and the so new created again and again. But this would only work, if i had a fixed number of splits. I have no idea, how I could manage that the column is splitted as often as necessary. In my example it would be twice, but in reality it's different every time, maybe five times or also ten times.
That was my idea of solving this problem, you guys here are very smart, so I think if you don't even have a better idea, you hopefully can help me fixing my problems!
Thank you so very much
makkin
