Post Reply 
[CPAP] Spreadsheet for Data
Author Message
Pete Offline

Members

Posts: 18
Joined: Mar 2012

Machine: ResMed S9 VPAP Adapt SV
Mask Type: Nasal mask
Mask Make & Model: Respironics - Opti Life
Humidifier: H5i & Climateline
CPAP Pressure: EPAP 5-15 PS 2-15
CPAP Software: ResScan SleepyHead

Other Comments: Sleep-on

Sex: Male
Location: USA Georgia

Post: #1
Spreadsheet for Data
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: 439)
09-18-2012 04:54 PM
Find all posts by this user Post Reply Quote this message in a reply

Donate to Apnea Board
trish6hundred Offline

Advisory Members

Posts: 6,430
Joined: May 2012

Machine: Resmed S9 AutoSet for Her
Mask Type: Full face mask
Mask Make & Model: Fisher & Paykel Simplus
Humidifier: H5i Heated Humidifier
CPAP Pressure: 10 - 7-20 Cm H2O
CPAP Software: Not using software

Other Comments: I started CPAP in 2008. Totally blind since birth.

Sex: Female
Location: Missouri, USA

Post: #2
RE: Spreadsheet for Data
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
09-18-2012 05:33 PM
Find all posts by this user Post Reply Quote this message in a reply
pssnn Offline
Wiki Editor
Preferred Members-2

Posts: 136
Joined: Mar 2012

Machine: ResMed S9 Autoset
Mask Type: Nasal pillows
Mask Make & Model: Swift FX
Humidifier: H5i
CPAP Pressure: 14 - 18
CPAP Software: ResScan SleepyHead

Other Comments: Quattro FX + Swift FX

Sex: Male
Location: Missouri

Post: #3
RE: Spreadsheet for Data
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!"
09-18-2012 08:14 PM
Find all posts by this user Post Reply Quote this message in a reply

Donate to Apnea Board
Pete Offline

Members

Posts: 18
Joined: Mar 2012

Machine: ResMed S9 VPAP Adapt SV
Mask Type: Nasal mask
Mask Make & Model: Respironics - Opti Life
Humidifier: H5i & Climateline
CPAP Pressure: EPAP 5-15 PS 2-15
CPAP Software: ResScan SleepyHead

Other Comments: Sleep-on

Sex: Male
Location: USA Georgia

Post: #4
RE: Spreadsheet for Data
(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...
09-19-2012 07:09 PM
Find all posts by this user Post Reply Quote this message in a reply
Pete Offline

Members

Posts: 18
Joined: Mar 2012

Machine: ResMed S9 VPAP Adapt SV
Mask Type: Nasal mask
Mask Make & Model: Respironics - Opti Life
Humidifier: H5i & Climateline
CPAP Pressure: EPAP 5-15 PS 2-15
CPAP Software: ResScan SleepyHead

Other Comments: Sleep-on

Sex: Male
Location: USA Georgia

Post: #5
RE: Spreadsheet for Data
(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
09-19-2012 07:14 PM
Find all posts by this user Post Reply Quote this message in a reply

Donate to Apnea Board
LorryMarie Offline

New Members

Posts: 2
Joined: Sep 2012

Machine: Respironics System One
Mask Type: Nasal pillows
Mask Make & Model: mirage swift fx
Humidifier: Respironics System One
CPAP Pressure: 7.0 (lowered from 8.0)
CPAP Software: SleepyHead

Other Comments:

Sex: Female
Location: Dallas area

Post: #6
RE: Spreadsheet for Data
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?
09-19-2012 07:39 PM
Find all posts by this user Post Reply Quote this message in a reply
pssnn Offline
Wiki Editor
Preferred Members-2

Posts: 136
Joined: Mar 2012

Machine: ResMed S9 Autoset
Mask Type: Nasal pillows
Mask Make & Model: Swift FX
Humidifier: H5i
CPAP Pressure: 14 - 18
CPAP Software: ResScan SleepyHead

Other Comments: Quattro FX + Swift FX

Sex: Male
Location: Missouri

Post: #7
RE: Spreadsheet for Data
Hi Pete,

Thanks for posting the instructions!!!!
Great-info

"Goodnight Chesty wherever you are!"
09-20-2012 07:02 PM
Find all posts by this user Post Reply Quote this message in a reply

Donate to Apnea Board
SuperSleeper Offline

Administrators

Posts: 9,961
Joined: Feb 2012

Machine: PR System One REMstar Auto (DS560)
Mask Type: Nasal pillows
Mask Make & Model: ResMed Mirage Swift II
Humidifier: none
CPAP Pressure: 12.5 - 18.5 cmH20 (auto range)
CPAP Software: SleepyHead

Other Comments: Have diabetes Type II

Sex: Male
Location: Illinois, USA

Post: #8
RE: Spreadsheet for Data
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.

09-20-2012 08:27 PM
Find all posts by this user Post Reply Quote this message in a reply
cbramsey Offline

Advisory Members

Posts: 900
Joined: Mar 2012

Machine: ResMed S9 Autoset
Mask Type: Nasal mask
Mask Make & Model: ResMed Mirage FX
Humidifier: ResMed H5i with ClimateLine
CPAP Pressure: 6 - 12
CPAP Software: ResScan

Other Comments: Supreme Overlord of Web Darkness

Sex: Male
Location: NC, USA

Post: #9
RE: Spreadsheet for Data
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.
09-21-2012 08:20 PM
Find all posts by this user Post Reply Quote this message in a reply

Donate to Apnea Board
Pete Offline

Members

Posts: 18
Joined: Mar 2012

Machine: ResMed S9 VPAP Adapt SV
Mask Type: Nasal mask
Mask Make & Model: Respironics - Opti Life
Humidifier: H5i & Climateline
CPAP Pressure: EPAP 5-15 PS 2-15
CPAP Software: ResScan SleepyHead

Other Comments: Sleep-on

Sex: Male
Location: USA Georgia

Post: #10
RE: Spreadsheet for Data
(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.
09-22-2012 10:46 AM
Find all posts by this user Post Reply Quote this message in a reply
Post Reply 


Possibly Related Threads...
Thread: Author Replies: Views: Last Post
  Sleepyhead data vs. Doctor's data Daisylouu 8 1,380 09-01-2016 06:10 PM
Last Post: eseedhouse
  Revised Post Regarding "I need help with SH data" - with data included! Jeffo1 3 592 05-16-2016 11:28 PM
Last Post: Jeffo1
  Data viewer for 960 BiPAP AutoSV / Missing data pswartz 5 2,249 10-06-2014 02:31 PM
Last Post: pswartz
  Does reading the data card erase the data? Marnid2014 22 8,551 03-12-2014 12:36 PM
Last Post: retired_guy

Forum Jump:

Who's Online (Complete List)