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?

  • $\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