Google Spreadsheet Post #2556
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI Dec-28-2018
question by: Mark Allenspach:
https://productforums.google.com/forum/?utm_medium=email&utm_source=best_answer_notification_button#!topic/docs/A2xTirWzmx4;context-place=mydiscussions
https://productforums.google.com/forum/?utm_medium=email&utm_source=best_answer_notification_button#!topic/docs/A2xTirWzmx4;context-place=mydiscussions
Removing bad data
I have various heater elements that collect data in a google sheet to date/time stamp when the heaters turn on/off.
A sample that can be viewed is at https://docs.google.com/
Normally, the data will show the first time stamp when the heater turned on followed by the next time stamp when it turned off.
Per the snapshot, sometimes I get bad data and have several time stamps in sequence all saying the heater turned on (or off).
When there is such erroneous data, I would like to only keep the 1st time stamp for "ON" and the last time stamp for "OFF".
92 KB
No comments:
Post a Comment