https://bugs.documentfoundation.org/show_bug.cgi?id=133677
--- Comment #3 from OldSurferDude <[email protected]> ---
Created attachment 161623
--> https://bugs.documentfoundation.org/attachment.cgi?id=161623&action=edit
CALC file used to analyze data file
With this spread sheet I can determine the length of time a sensor is on or
off.
To get the data into the spreadsheet:
1. open up data in a text document
2. select all and copy date.
3. in the CALC document, move to cell A1
4. paste
5. change the first column type to Date(YMD)
6. OK
7. sort the five columns by location(C), sensor(D), time(B)
8. go to the first entry in seconds on(F) column
9. Select that entry and the one in secondsoff(G)
10. Copy
11. Select all the cells in (F) that have data data location 1, and sensor 2
12. paste
the pasted cells now show how many seconds the sensor was on in column (F) and
hours off in column (G)
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
