How to filter the data.

1 view (last 30 days)
Nguyen Trung Hieu
Nguyen Trung Hieu on 2 Aug 2021
Hi guys. I'm having a hard time right now and I hope you can help!
- I have some parameters taken from the motion of the sensors and transferred this data to Google Sheet, then from GG Sheet transmitted to MATLAB and gave the results as shown. All are automatically transmitted 24/24.
- The next step I need to do is save as an excel file (including 4 sheets). Because each movement of the sensor will be filtered into a sheet that matches the pre-set conditions. And then will plot the parameters in each corresponding sheet into a waveform.
Thanks! Hope the helping.
  1 Comment
Rik on 2 Aug 2021
You put your question in the title, instead of the question body. Please edit your question.
Have a read here and here. It will greatly improve your chances of getting an answer.

Sign in to comment.

Answers (1)

Peter Perkins
Peter Perkins on 2 Aug 2021
Not sure how you are getting those data into MATLAB, but I suggest that you figure out why you have a cell array. You want a table, actually you probably want a timetable. Once you have that, it's trivial to write it out using writetable.
  1 Comment
Nguyen Trung Hieu
Nguyen Trung Hieu on 3 Aug 2021
Those cell arrays appear, but that's because this data is pulled entirely from Google Sheets. As for why I can get those numbers, I use Google Sheet in combination with Arduino. I use Arduino to code the sensors, so that when the sensors are moved the corresponding numbers are output to a Google Sheet. And MATLAB will take the parameters from there.
Thank you!

Sign in to comment.

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!