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

[CPAP] Spreadsheet for Data
#1
Hi Folks
I'm a newbie to the posting part although I've around a few months now, doing my homework and research.

I've been on CPAP now for about 15 months. I had a sleep study done back in 2002 and couldn't tolerate my CPAP machine then which was a Respironics Virtuoso LX Autoset. I had a severe panic attack that scared me to death (never had one in my life until then, nor since) so I just stuck it in my closet until 2011 when I had another sleep study done because I felt exhausted all the time. Results of both were moderate to severe OSA.

I decided I was going to use it or die trying. I'm still around, so far. This spring I started Medicare and I asked my Doc to prescribe a new S9 for me which he did. I wanted to be able to see the data so I got the ResMed software and also SleepyHead, which I really like. It so much more flexible than the V3.16 ResMed, at least I think so...

Anyway to make a long story shorter, I've been working on an Excel spreadsheet to display the exported data from SleepyHead in a sortable format. So far I have it set up for 365 days of data but I only have 151 days of Data in it. It could be easily expanded to include whatever amount of data you like.

Please feel free to use it for your own data if you like. Just be careful not to delete formulas
Sleep-well

.xls   Attachment.xls (Size: 175.5 KB / Downloads: 469)
Post Reply Post Reply
#2
Hi Pete, First of all, WELCOME! to the forum.! I don't know anything about your older machine but, I think you'll really be happy with the "Resmed," I'm very pleased with mine.
trish6hundred
Post Reply Post Reply
#3
Hi Pete,

Welcome to the forum!!!

Nice job on the spreadsheet. Your hard work and effort shows! Okay Thanks

Any chance of including instructions on how to import data to the spreadsheet to make it user friendly?
"Goodnight Chesty wherever you are!"
Post Reply Post Reply


#4
(09-18-2012, 08:14 PM)pssnn Wrote: Hi Pete,

Welcome to the forum!!!

Nice job on the spreadsheet. Your hard work and effort shows! Okay Thanks

Any chance of including instructions on how to import data to the spreadsheet to make it user friendly?

Hopefully this is the right way to reply - Like I said I'm a newbie...

IN Sleepyhead Click file EXPORT then in the Dialog box that comes up labeled as Export to CSV (Comma Separated Value file) click the down arrow on the Quick Range line and select whether you want just today or a range of days or all your data - if you select Custom it activates the calendars and lets you choose Start and Ending dates...

Next, click one of the three options on the Resolution line -- I usually select the daily option because the details option gives thousands of line of data which might be OK for one or two days but for any longer you'll get more data than you can imagine especially with an Autoset machine.

Most of it is just pressure data second by second. There's some useful data there but you have to sift though a lot to get anything worthwhile. About the only useful data is the time in seconds per event which is nice but you have to hunt those needles in a very large haystack.

Finally, after you select Daily then click on the button to the right of filename and select a destination folder for the data and a file name you'll remember. It's an Excel.csv file once you do this the Export button will activate -- click it and you're done...
open the new Excel file and you'll see the raw data in Excel. Each row contains one day of data. The date and time in Sleepy Head have a "T" (for time) in them that Excel does not recognize as a valid date. Use the search and replace option in excel to replace all the t's with a single space...
There are several columns of zeroes in the data that have no apparent meaning ??? not sure why and there are some other numeric data that I have no idea what are for. I can't seem to find matching data in SH to match any of it. I think the 95% pressure data is there or at least it close so locate it.
I copy all this new data to the spreadsheet "Scratch sheet" There's a macro there that will replace all the "t" with spaces if you select just those cells first. When you get the data properly lined up under the right headers on the scratch sheet then select just the data and copy it. don't select anything beyond the 95% column....

FINALLY go to the bottom of the data on the ALL DATA sheet in column "C" (under the green Macro button) and do a PASTE SPECIAL from the edit menu and select values only to paste the data into the sheet. NOTE: the time info from Sh is not a valid time according to Excel but it should still reflect the time you used CPAP. It takes into account the session times in some way. I used a logical formula to do the same thing on mine but when you paste the data in it overwrites the formulas, so you need to go back and recopy them down from a cell above or below.

The calculated time with formulas is 100% accurate but I finally realized it's counting the time between when you started therapy the night before and when you cut off the machine the next morning. It does not take into account the session times when you were not on the machine at the potty or reading at night with the mask off, etc...

Hope this helps some. Just be careful with the formulas. I think I protected the workbook to protect them and if you need to unlock it I'll send you the P/W by PM. Have a large time...
Post Reply Post Reply
#5
(09-19-2012, 07:09 PM)Pete Wrote:
(09-18-2012, 08:14 PM)pssnn Wrote: Hi Pete,

Welcome to the forum!!!

Nice job on the spreadsheet. Your hard work and effort shows! Okay Thanks

Any chance of including instructions on how to import data to the spreadsheet to make it user friendly?

Hopefully this is the right way to reply - Like I said I'm a newbie...

IN Sleepyhead Click file EXPORT then in the Dialog box that comes up labeled as Export to CSV (Comma Separated Value file) click the down arrow on the Quick Range line and select whether you want just today or a range of days or all your data - if you select Custom it activates the calendars and lets you choose Start and Ending dates...

Next, click one of the three options on the Resolution line -- I usually select the daily option because the details option gives thousands of line of data which might be OK for one or two days but for any longer you'll get more data than you can imagine especially with an Autoset machine.

Most of it is just pressure data second by second. There's some useful data there but you have to sift though a lot to get anything worthwhile. About the only useful data is the time in seconds per event which is nice but you have to hunt those needles in a very large haystack.

Finally, after you select Daily then click on the button to the right of filename and select a destination folder for the data and a file name you'll remember. It's an Excel.csv file once you do this the Export button will activate -- click it and you're done...
open the new Excel file and you'll see the raw data in Excel. Each row contains one day of data. The date and time in Sleepy Head have a "T" (for time) in them that Excel does not recognize as a valid date. Use the search and replace option in excel to replace all the t's with a single space...
There are several columns of zeroes in the data that have no apparent meaning ??? not sure why and there are some other numeric data that I have no idea what are for. I can't seem to find matching data in SH to match any of it. I think the 95% pressure data is there or at least it close so locate it.
I copy all this new data to the spreadsheet "Scratch sheet" There's a macro there that will replace all the "t" with spaces if you select just those cells first. When you get the data properly lined up under the right headers on the scratch sheet then select just the data and copy it. don't select anything beyond the 95% column....

FINALLY go to the bottom of the data on the ALL DATA sheet in column "C" (under the green Macro button) and do a PASTE SPECIAL from the edit menu and select values only to paste the data into the sheet. NOTE: the time info from Sh is not a valid time according to Excel but it should still reflect the time you used CPAP. It takes into account the session times in some way. I used a logical formula to do the same thing on mine but when you paste the data in it overwrites the formulas, so you need to go back and recopy them down from a cell above or below.

The calculated time with formulas is 100% accurate but I finally realized it's counting the time between when you started therapy the night before and when you cut off the machine the next morning. It does not take into account the session times when you were not on the machine at the potty or reading at night with the mask off, etc...

Hope this helps some. Just be careful with the formulas. I think I protected the workbook to protect them and if you need to unlock it I'll send you the P/W by PM. Have a large time...

Not sure how "friendly these instructions are... Nothing takes the place of hard work -- I'll say this it's not hard once you know how to do it. Pretty much like everything else in this 'ole world! Okay
Post Reply Post Reply
#6
Wow, Pete! Great job! I love spreadsheets and the opportunity to get more info about my CPAP data.

Not to be nosy, but if this spreadsheet contains your personal data, what in the world made your AHI jump to 20.12 when it had been much lower? My contact tells me "we" are trying to keep that number below 5.0 so 20 is just much higher than I've seen unless you've found a way to gather the same data without using CPAP?
Post Reply Post Reply


#7
Hi Pete,

Thanks for posting the instructions!!!!
Great-info
"Goodnight Chesty wherever you are!"
Post Reply Post Reply
#8
Nice job on the spreadsheet, Pete...

Well-done
SuperSleeper
Apnea Board Administrator
www.ApneaBoard.com


INFORMATION ON APNEA BOARD FORUMS OR ON APNEABOARD.COM SHOULD NOT BE CONSIDERED AS MEDICAL ADVICE. ALWAYS SEEK THE ADVICE OF A PHYSICIAN BEFORE SEEKING TREATMENT FOR MEDICAL CONDITIONS, INCLUDING SLEEP APNEA. INFORMATION POSTED ON THE APNEA BOARD WEB SITE AND FORUMS ARE PERSONAL OPINION ONLY AND NOT NECESSARILY A STATEMENT OF FACT.



Post Reply Post Reply
#9
Very nice spreadsheet you have put together Pete!!!! [Image: clapping_hands.gif]

Thank you for sharing it.
INFORMATION ON APNEA BOARD FORUMS OR ON APNEABOARD.COM SHOULD NOT BE CONSIDERED AS MEDICAL ADVICE. ALWAYS SEEK THE ADVICE OF A PHYSICIAN BEFORE SEEKING TREATMENT FOR MEDICAL CONDITIONS, INCLUDING SLEEP APNEA. INFORMATION POSTED ON THE APNEA BOARD WEB SITE AND FORUMS ARE PERSONAL OPINION ONLY AND NOT NECESSARILY A STATEMENT OF FACT.
Post Reply Post Reply


#10
(09-19-2012, 07:39 PM)LorryMarie Wrote: Wow, Pete! Great job! I love spreadsheets and the opportunity to get more info about my CPAP data.

Not to be nosy, but if this spreadsheet contains your personal data, what in the world made your AHI jump to 20.12 when it had been much lower? My contact tells me "we" are trying to keep that number below 5.0 so 20 is just much higher than I've seen unless you've found a way to gather the same data without using CPAP?

Yep, It's my data. Apparently I'm having issues with Central Apneas. I'm going to a specialist to see if they can find out why. The short answer is Altitude. The higher numbers are at an altitude of about 1400 feet higher and my best AHI was pretty near sea level.

I've read some newer research that also verifies this phenomenon.
Post Reply Post Reply


Possibly Related Threads...
Thread Author Replies Views Last Post
  Why does Sleepyhead data not match my machine's data? Ihaveapnea 8 769 01-06-2017, 06:19 PM
Last Post: Ihaveapnea
  Sleepyhead data vs. Doctor's data Daisylouu 8 1,988 09-01-2016, 06:10 PM
Last Post: eseedhouse
  Revised Post Regarding "I need help with SH data" - with data included! Jeffo1 3 789 05-16-2016, 11:28 PM
Last Post: Jeffo1
  Data viewer for 960 BiPAP AutoSV / Missing data pswartz 5 2,458 10-06-2014, 02:31 PM
Last Post: pswartz
  Does reading the data card erase the data? Marnid2014 22 9,256 03-12-2014, 12:36 PM
Last Post: retired_guy

Forum Jump:

New Posts   Today's Posts




About Apnea Board

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

For any more information, please use our contact form.