Test data reduction macro

Hi all,


I have a large amount of test data that I need to process into useable information. Because of my hardware, the test sample rate was over 1000Hertz. Anyway,I need to reduce the length of the columns of test data by averaging them every 17 rows. I attached a sample of the data I am working with, some of the data is over 100,000 rows. I cannot figure out how to begin averaging the data and increment the range until the end of the column. Please help....
BTW, I am using excel2010, if that matters.



test book1.xlsx

I had a go at it as well.

Your description said a sample size of 17 but your example workbook had a sample size of 18.

Change the sample size in the code to suit.

Please Login or Register  to view this content.

AlphaFrog,

I got a "Type Mismatch" runtime error with your code on the line beginning "Avgs(k) =". No idea why....
If you can explain, it would help me understand.



Mike7952's code does what I need to do, my job is to understand how.

Thanks a lot, both of you!

Originally Posted by a1aexcel

AlphaFrog,

I got a "Type Mismatch" runtime error with your code on the line beginning "Avgs(k) =". No idea why....
If you can explain, it would help me understand.

It worked for me given your example data. Are you using the same worksheet?

Type mismatch in this case may mean the data it is trying to add is text and not numeric.

I did use a different sheet.... went back and used a new fresh sheet with raw data which is what my example was, and it worked, with 22,000 data points. Your code was fine, I am apparently the weak link.

Originally Posted by a1aexcel

Hi all,


I have a large amount of test data that I need to process into useable information. Because of my hardware, the test sample rate was over 1000Hertz. Anyway,I need to reduce the length of the columns of test data by averaging them every 17 rows. I attached a sample of the data I am working with, some of the data is over 100,000 rows. I cannot figure out how to begin averaging the data and increment the range until the end of the column. Please help....
BTW, I am using excel2010, if that matters.



Attachment 214942

I will like to use alaexcel test book1.xlsx as an example. I would like to reduce the columns averaging them every 5 rows in reference to the middle number for example rows 1+2+4+5 divided by row 3. I will then have to compare the average of the sumed rows to row 3. if row 3 is greater than the sum of rows 1+2+4+5 then flag it and increment by one. So the next rows will be the average of 2+3+5+6 then this time compare it to row 4 if greater than 8 flag it and repeat the process any help please.