Reducing a data set for use in a plot

[tomtom412]

Hi All

I have a data set of over 4500 data points. I want to reduce this to roughly 200 points for use in a plot.
The data is an output from a tensile tester, and I am looking to pair it and plot against a data set from a numerical simulation, which is only outputs 200 data points.

What is the best way to do this, without losing the trend I have in my mechanical testing data set?

Thank you all for your time

Regards,
Tom

[Pete_UK]

That is a reduction of about 20 to 1. Do you want to take every 20th cell (or 22nd if you want) and put it into another table which you can use as the source for you graph, or would that tend to hide your trends?

Pete

[tomtom412]

That is a reduction of about 20 to 1. Do you want to take every 20th cell (or 22nd if you want) and put it into another table which you can use as the source for you graph, or would that tend to hide your trends?

Pete

Pete,

That sounds exactly like what im after! Could you suggest where I could begin with this?
Thanks
Tom

[Pete_UK]

Okay, take a look at the attached file, where I have filled sequential numbers down column A and put this formula in cell E2, which is then copied down a few rows:

=INDEX(A:A,(ROWS($1:1)-1)*22+2)

You can see that this produces the sequence 1, 23, 45, 67, 89 and so on, showing that it is picking up cells with a gap of 22 between them. The 2 in the formula is needed because the data starts on row 2.

Hopefully you can adapt this to how your data is laid out.

Hope this helps.

Pete

[shg]

I have a user-defined function that does this: https://en.wikipedia.org/wiki/Ramer%...cker_algorithm

[shg]

Example attached.

[tomtom412]

Okay, take a look at the attached file, where I have filled sequential numbers down column A and put this formula in cell E2, which is then copied down a few rows:

=INDEX(A:A,(ROWS($1:1)-1)*22+2)

You can see that this produces the sequence 1, 23, 45, 67, 89 and so on, showing that it is picking up cells with a gap of 22 between them. The 2 in the formula is needed because the data starts on row 2.

Hopefully you can adapt this to how your data is laid out.

Hope this helps.

Pete

Thank you Pete, this should work perfectly for my application!

Tom