OSCAR -- oximetry calculations
Hi folks
I'm interested in working out how long my SpO2 is below 90% each night, and trying to match that figure to other parameters or settings.
Does OSCAR provide a way to present this information automatically?
If not, can it export the actual SpO2 values it imported from my Wellue device?
If no, is the Wellue file format sufficiently well know that I could extract the values myself?
Best wishes, DS
01-11-2022, 08:35 AM
(This post was last modified: 01-11-2022, 08:36 AM by Ratchick.)
RE: OSCAR -- oximetry calculations
If you save the data from your phone/computer and open it using the Wellue/Viatom app or software, there is an option to save data as CSV. That's probably the easiest way to do it. Assuming you aren't just taking the <90% figure from out of the Viatom reports, of course.
Just be aware that things like the baseline and ODI are measured differently between Wellue and OSCAR.
RE: OSCAR -- oximetry calculations
(01-11-2022, 08:35 AM)Ratchick Wrote: If you save the data from your phone/computer and open it using the Wellue/Viatom app or software, there is an option to save data as CSV.
Thank you -- I exported the data as CSV from the app. I don't have the Wellue desktop software as, so far as I know, there isn't a Linux version. I was rather hoping that OSCAR would be able to display this data, and I was just missing something.
BW, DS
PS -- the answer is: there is no correspondence between time spent < 90% and any other setting. It doesn't even seem to make any difference whether I actually use the CPAP machine or not. But I now know that the main cause of my desaturation is not apnea, so I guess I shouldn't be surprised.
RE: OSCAR -- oximetry calculations
OSCAR only uses the Wellue's binary data file. Since you're using Linux, the CSV file can be opened with LibreOffice's spreadsheet program. You could then create a filter to parse out any reading below 90% and then sum the time.
RE: OSCAR -- oximetry calculations
Are you using the app on your phone to download the data? If so, it SHOULD show you the value in the report... at least it does on my Android app, I can't swear to what would show on the iOS app.
RE: OSCAR -- oximetry calculations
iOS is identical to the Android app showing the <90% Time. Can also export as Binary|PDF|CSV
RE: OSCAR -- oximetry calculations
I wish I could export the binary on my Android app. It does PDF and CSV, but it's easy enough to brows for the ViHealth folder to get to the binaries.
RE: OSCAR -- oximetry calculations
From viatom_loader.cpp, I think this is what you're looking for:
Code:
//int time_under_90pct = header[22] | (header[23] << 8); // in seconds
OSCAR doesn't currently import that, as it (for historical reasons) doesn't really have a way to handle summary data, only detailed data. On our list to fix, but pretty far down the road.
RE: OSCAR -- oximetry calculations
(01-11-2022, 10:19 AM)Crimson Nape Wrote: OSCAR only uses the Wellue's binary data file. Since you're using Linux, the CSV file can be opened with LibreOffice's spreadsheet program. You could then create a filter to parse out any reading below 90% and then sum the time.
Thanks. I used a Perl script in the end but, yes, I did have to export the CSV files. The Android app does expose a "<90" figure, but I was really hoping I could automate the entire process, since I've already loaded all the data into OSCAR.
But no biggie.
BW, DS
RE: OSCAR -- oximetry calculations
It's honestly the only figure I have to go regularly to the Viatom software for because OSCAR doesn't show it. I tend to write things like that into the notes so at least it's there for future reference.