+- Apnea Board Forum - CPAP | Sleep Apnea (https://www.apneaboard.com/forums)
+-- Forum: Public Area (https://www.apneaboard.com/forums/Forum-Public-Area)
+--- Forum: Software Support Forum (https://www.apneaboard.com/forums/Forum-Software-Support-Forum)
+--- Thread: OSCAR: Tutorial for graphing CSV? Start/End times not easily regognized (/Thread-OSCAR-Tutorial-for-graphing-CSV-Start-End-times-not-easily-regognized)
OSCAR: Tutorial for graphing CSV? Start/End times not easily regognized - Earendil - 07-06-2021
My excel is rusty, but it seems as if Excel doesn't recognize the Start/End format as exported as a time. I tossed it into MacOS Numbers as well and the same issue. Am I just being dense? (It's okay to say I am).
I really only want to graph start/end times for each day, but where I specify when the day "starts" so that the graph is easier to read.
Thanks for any help, or for labeling me dense, really either one
RE: OSCAR: Tutorial for graphing CSV? Start/End times not easily regognized - 2SleepBetta - 07-07-2021
If I understand your need correctly, these snips from Detail, Session and Daily exports to CSV file show the dates and times at left in the spreadsheet for files sampled on left. I think you have to inspect down the rows for the times of the file at right.
But you must drag the right hand column markers wider to see all that is in that column which seems full of other info. Columns are squeezed as first seen.
[attachment=33551]
I use excel a lot, including CSV files but had never done an export like these from OSCAR. Thanks for the prod to take a look.
Now I have some ideas for use of the one at right. It appears to present session segments serially down the rows. Separate segments of a sleep session are chronological internally, but times jump when there is a segment change (I think).
Look at segment times (or what summary divisions there are) near the bottom of the left summary presentation by OSCAR. There may not be a fully detailed listing of segments though, as I recall (just know something like that is there.)
.Again, if the sample at right does not show an End time you may need to take it from the last pressure shown for the whole sleep session, near the bottom of the sheet. The other two files show Start and End times, as illustrated.
Sorry, for uncertainties. I was shutting down and saw your unanswered question so wanted to take a look and respond if I could.