Hello Guest, Welcome to Apnea Board !
As a guest, you are limited to certain areas of the board and there are some features you can't use.
To post a message, you must create a free account using a valid email address.

or Create an Account


New Posts   Today's Posts

Customize Export Data from Oscar?
#11
RE: Customize Export Data from Oscar?
Hi again all,

@Richard

Yes I did thanks, and it did work fine: the learning curve for VBA does my head in, so I have not pursued that kind of level of coding.

I landed up doing what Bonjour suggested: export data into csv, convert to xlsx, then rearrange columns with a Macro and voila. Bit less work than learning VBA, for me anyway.

Subsequent to that one time only major import, I now just add the data from OSCAR manually day by day.
Some of the data is unknown to OSCAR so I have to add that manually every day anyway.
I find that with Excel the process is organic: frequent changes to layouts, colors, links and formulas to speed things up, so at the moment I am happy doing this manually, rather than have to update code each time.

@on the virge
sounds excellent creating new copies based on your Master Database: 

Sounds like it is working well for you, I might look at that process down the line somewhat.
By the end of the year I want to stop looking at data daily, maybe just update weekly, so I will look into that process at a later date.

Here are some sample pages of my spreadsheet, quite simplistic but somewhat useful for me to look at.
(Mods: not sure if it is appropriate to post these: if not, then feel free to remove)

Overall daily data:
   

OSAs:
   

Clear Airways:
   
Post Reply Post Reply






Donate to Apnea Board  


Possibly Related Threads...
Thread Author Replies Views Last Post
  Help with Oscar/MacAir/cant upload SD card data Remmy 6 112 10-18-2020, 03:09 PM
Last Post: Jeff8356
  Export OSCAR -> ResScan RicksterNewbie 1 82 10-14-2020, 11:24 AM
Last Post: Crimson Nape
  Clear Oscar of data Lyle 2 108 09-05-2020, 09:57 PM
Last Post: Lyle
  Updated Oscar and data is inaccurate...need help KallyA 27 489 09-05-2020, 03:59 PM
Last Post: KallyA
  new member and data from CheckMe O2 available for OSCAR AirPress 21 619 08-24-2020, 10:40 AM
Last Post: LE GALIBIER
Question OSCAR doesn't remember SpO2 data folder JimInPT 8 191 08-21-2020, 09:40 PM
Last Post: GuyScharf
  Oscar export of contained pulse ox data on the virge 2 123 08-21-2020, 03:34 PM
Last Post: on the virge


New Posts   Today's Posts






About Apnea Board

Apnea Board is an educational web site designed to empower Sleep Apnea patients.