+- Apnea Board Forum - CPAP | Sleep Apnea (https://www.apneaboard.com/forums)
+-- Forum: Public Area (https://www.apneaboard.com/forums/Forum-Public-Area)
+--- Forum: Main Apnea Board Forum (https://www.apneaboard.com/forums/Forum-Main-Apnea-Board-Forum)
+--- Thread: Sleep / CPAP diary in Microsoft Access (/Thread-Sleep-CPAP-diary-in-Microsoft-Access)
Sleep / CPAP diary in Microsoft Access - Dagmar - 01-15-2017
Just thought I'd share a project I'm working on; I'm tracking what I feel are my most important CPAP data in an Access database. I have a few reasons for doing this. First, I wanted to see how long on average I used my masks (cushions), headgear, chin strap, etc. before throwing them out. I've been tweaking this database over the last week or so and won't really have any useful data until I've thrown out my current reusable equipment and replaced it with new. Then, I can really begin tracking longevity. I'm also keeping track pressure and leak data, hours used including start and stop times. This would probably be more interested if I was in auto-mode. But, I use straight CPAP due to clear airways being a problem with changing pressure. Because I use a WiFi SD card in my machine, looking at the data is really easy.
[attachment=3096]
I'll post an update if anyone is interested after I have some more useful data (and If I stay with it
Dagmar
RE: Sleep / CPAP diary in Microsoft Access - Beej - 01-15-2017
Go for it!
Always like to see people checking the data!
RE: Sleep / CPAP diary in Microsoft Access - Hydrangea - 01-15-2017
Cool idea! It makes me wonder if there's an app that could act as a sleep diary for me.
RE: Sleep / CPAP diary in Microsoft Access - Dagmar - 01-15-2017
I've also been playing around with Excel looking at data that I exported from SleepyHead to a .csv file. That endeavor does not seem to be going anywhere. So, for the time being I have to manually enter my data into Access.
RE: Sleep / CPAP diary in Microsoft Access - trish6hundred - 01-15-2017
Hi Dagmar,
Sounds like a neat idea, keep us posted on your progress.
RE: Sleep / CPAP diary in Microsoft Access - Beej - 01-15-2017
If you have exported a CSV file, it should be possible to import the data into Acess.
RE: Sleep / CPAP diary in Microsoft Access - Dagmar - 01-16-2017
(01-15-2017, 10:39 PM)Beej Wrote: If you have exported a CSV file, it should be possible to import the data into Acess.
Good point about the csv file but it's only partial data and what is there needs a little more manipulation then I can give it. That's why I'm doing the manual entry. I put about three hours into seeing if I could work with the csv file but eventually gave up.
RE: Sleep / CPAP diary in Microsoft Access - Beej - 01-16-2017
In Excel, I was able to do some graphs and then fit lines to the data.
What is it you want to be able to do?
RE: Sleep / CPAP diary in Microsoft Access - Dagmar - 01-17-2017
(01-16-2017, 08:49 PM)Beej Wrote: In Excel, I was able to do some graphs and then fit lines to the data.
What is it you want to be able to do?
Thanks for the offer of help
I was exporting session data and not a daily view so I think I'm okay now.