I have done experiments on a grinding machine and have collected the data of grinding wheel profile (using a laser sensor).

The raw data consists of info on grinding wheel profile, waviness and roughness (because of abrasive grains). I would like to process the collected raw data. I want to filter out the high frequency and low frequency data. (I want to apply a simple band pass filter). One cycle data is about 200,000 data units and i have them in an excel file (csv data) and would like to perform digital filtering.

How do I filter out the waviness data separately and analyze, from this?


closed as unclear what you're asking by DLS3141, Wasabi, Carl Witthoft, BarbalatsDilemma, user16 Feb 13 '17 at 13:02

Please clarify your specific problem or add additional details to highlight exactly what you need. As it's currently written, it’s hard to tell exactly what you're asking. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.

  • $\begingroup$ Are you looking for help doing filtering in Excel? or what exactly? $\endgroup$ – DLS3141 Feb 9 '17 at 13:24
  • $\begingroup$ You asking how to do fourier tansform in excel? $\endgroup$ – joojaa Feb 9 '17 at 16:30
  • $\begingroup$ You need to be more specific about the form of your data. $\endgroup$ – Wallace Park Feb 9 '17 at 19:25
  • $\begingroup$ At the very least you'll have to define a cutoff between off-axis error (a disc rotating not about its center), eccentricity or ellipse-ishness, and "waviness" which presumably is of higher order. $\endgroup$ – Carl Witthoft Feb 10 '17 at 14:50
  • $\begingroup$ @CarlWitthoft it's not clear if these measurements are made in the axial direction or the radial. $\endgroup$ – DLS3141 Feb 10 '17 at 16:56