Feature in Sleepyhead available?

General Discussion on any topic relating to CPAP and/or Sleep Apnea.
User avatar
photonic
Posts: 261
Joined: Fri Jun 27, 2014 7:42 pm

Feature in Sleepyhead available?

Post by photonic » Wed Oct 22, 2014 6:48 pm

My last visit with my sleep doctor was interesting in that he was using the Encore software to determine if there was a downward trend in my AHI over 70 days. Well the encore graphs were a joke. They were so small and crammed on the paper that nothing could really be determined. My doctor sat there with his thumbnail trying to count the days and point to specific data points, but visually you really could not tell anything. He told me that as soon as Sleepyhead becomes commercially he will switch for better graphs and data display.

Well, this got me thinking about how I would answer the question about trends in data points that I could bring to my doctor so we could both really see how a trend was developing or not.

So I realized that I could easily do a regression analysis, that is fitting a line to the data points, in MS Excel which has this feature built in. I will launch into that.

BUT I wonder if there is a feature in Sleepyhead to do that so that I do not have to hand copy all the data points into excel. If not, then wouldn't this be a great feature for the software especially for future provider users who want to determine trends over time. My doctor is interested in seeing brain accommodation to XPAP and in my case ASV in particular. He says he sees changes for many months as the brain accommodates to therapy and knowing whether a trend line has plateaued or not lets him decide on whether to change an XPAP setting or to stay the course if the trend shows continued improvement.

Thoughts?
ResMed AirCurve 10 ASV
8 years with F&P Oracle mouth mask now changing to
F&P Evora Full with S-M size
Hozer hose management device (a miracle!)
OSCAR software

User avatar
palerider
Posts: 32300
Joined: Wed Dec 16, 2009 5:43 pm
Location: Dallas(ish).

Re: Feature in Sleepyhead available?

Post by palerider » Wed Oct 22, 2014 7:08 pm

photonic wrote: BUT I wonder if there is a feature in Sleepyhead to do that so that I do not have to hand copy all the data points into excel. I
I think you're looking for the export to csv.

file/export data/csv export wizard

_________________
Mask: Bleep DreamPort CPAP Mask Solution
Additional Comments: S9 VPAP Auto
Get OSCAR

Accounts to put on the foe list: dataq1, clownbell, gearchange, lynninnj, mper!?, DreamDiver, Geer1, almostadoctor, sleepgeek, ajack, stom, mogy, D.H., They often post misleading, timewasting stuff.

User avatar
photonic
Posts: 261
Joined: Fri Jun 27, 2014 7:42 pm

Re: Feature in Sleepyhead available?

Post by photonic » Wed Oct 22, 2014 8:02 pm

WHOA! how cool is that. CSV usually means comma separated values, but this export actually creates an Excel spread sheet for you with EVERYTHING on it. Amazing. So now I just have to highlight the correct columns and then run the analysis, print and take to my doctor.

Thanks for pointing that feature out.

Now wouldn't it be cool if SleepyHead displayed a real-time best fit line or could produce one with a button - just dreamin' here.... It would be nice if SleepyHead could make my morning espresso too!
ResMed AirCurve 10 ASV
8 years with F&P Oracle mouth mask now changing to
F&P Evora Full with S-M size
Hozer hose management device (a miracle!)
OSCAR software

User avatar
photonic
Posts: 261
Joined: Fri Jun 27, 2014 7:42 pm

Re: Feature in Sleepyhead available?

Post by photonic » Wed Oct 22, 2014 8:29 pm

Works perfectly. All you have to do is highlight two columns.: date and AHI values. Then create a simple scatter chart under the Insert tab. Then click the "+" button (chart elements) and choose fit a linear line. Voila! a Perfect line is fit and you can see if you are getting better, worse, or plateaued off on your data points. I bet ya many of the data nerds here will love this...... Or maybe it is just lonely me

But really a report like this seems incredibly useful to me to discuss with our MDs.

Cheers.
ResMed AirCurve 10 ASV
8 years with F&P Oracle mouth mask now changing to
F&P Evora Full with S-M size
Hozer hose management device (a miracle!)
OSCAR software

User avatar
photonic
Posts: 261
Joined: Fri Jun 27, 2014 7:42 pm

Re: Feature in Sleepyhead available?

Post by photonic » Wed Oct 22, 2014 9:36 pm

Image
ResMed AirCurve 10 ASV
8 years with F&P Oracle mouth mask now changing to
F&P Evora Full with S-M size
Hozer hose management device (a miracle!)
OSCAR software

JimP
Posts: 181
Joined: Thu Oct 02, 2014 2:49 pm

Re: Feature in Sleepyhead available?

Post by JimP » Wed Oct 22, 2014 10:43 pm

Which scatter chart did you use?

User avatar
photonic
Posts: 261
Joined: Fri Jun 27, 2014 7:42 pm

Re: Feature in Sleepyhead available?

Post by photonic » Thu Oct 23, 2014 7:21 am

Just the simplest chart that just uses points with no connecting lines. I then changed the styling to show horizontal lines between the major vertical axis points of 5, 10, 15 etc.
ResMed AirCurve 10 ASV
8 years with F&P Oracle mouth mask now changing to
F&P Evora Full with S-M size
Hozer hose management device (a miracle!)
OSCAR software

john5396
Posts: 59
Joined: Fri Feb 10, 2012 11:17 am
Location: North Carolina

Re: Feature in Sleepyhead available?

Post by john5396 » Thu Oct 23, 2014 7:34 am

Try graphing a 10/15/20 day moving average, that would probably give the MD a better sense of the plateau he is looking for.

_________________
Mask: AirFit™ P10 Nasal Pillow CPAP Mask with Headgear
Humidifier: S9™ Series H5i™ Heated Humidifier with Climate Control
Additional Comments: CPAP 9cm. Hunidity Auto 82 degrees. no ramp. previous mask Swift FX, now backup

bv1800
Posts: 118
Joined: Tue May 20, 2014 6:30 pm

Re: Feature in Sleepyhead available?

Post by bv1800 » Thu Oct 23, 2014 8:48 am

In addition to the suggested moving average, Excel also has non-linear fit choices (logarithmic, exponential), etc that may show the longer term plateau effect that you are looking for.

_________________
MachineMask

User avatar
photonic
Posts: 261
Joined: Fri Jun 27, 2014 7:42 pm

Re: Feature in Sleepyhead available?

Post by photonic » Thu Oct 23, 2014 8:34 pm

All terrific ideas. Thanks.

Image

The slightly curved line is the exponential and shows some flattening off as expected. The wavy line is a 15 day moving average which actually may be the most useful in that it suggests that improvement may indeed be over, that is, a plateau has been reached.
ResMed AirCurve 10 ASV
8 years with F&P Oracle mouth mask now changing to
F&P Evora Full with S-M size
Hozer hose management device (a miracle!)
OSCAR software

User avatar
Krelvin
Posts: 1977
Joined: Tue Jun 06, 2006 5:23 pm
Location: Metro Phx Area - Dry Heat!

Re: Feature in Sleepyhead available?

Post by Krelvin » Fri Oct 24, 2014 5:09 am

How did you get days instead of dates to show?
Current Settings PS 4.0 over 10.6-18.0 (cmH2O) - Resmed S9 VPAP Auto w/h5i Humidifier - Quattro Air FFM
TNET Sleep Resource Pages - CPAP Machine Database
Put your equip in your Signature - SleepyHead v1.0.0-beta-1
Kevin... alias Krelvin

User avatar
photonic
Posts: 261
Joined: Fri Jun 27, 2014 7:42 pm

Re: Feature in Sleepyhead available?

Post by photonic » Fri Oct 24, 2014 6:22 pm

When I first did the scatter chart after having highlighted the "start" column and the "AHI" column, the chart created simply showed the number of the day 1, 2, 3.... as in first, second, third day....

I put in the title "Days" as an add in. I used the "start" column rather than the "Date" column because the former had all the dates and the later had some weird ### symbols so I felt safer using the "start" column.
ResMed AirCurve 10 ASV
8 years with F&P Oracle mouth mask now changing to
F&P Evora Full with S-M size
Hozer hose management device (a miracle!)
OSCAR software

User avatar
howkim
Posts: 482
Joined: Fri Mar 06, 2009 8:36 am
Location: South Florida

Re: Feature in Sleepyhead available?

Post by howkim » Fri Oct 24, 2014 7:46 pm

In Excel, the ### symbols just mean that the display is too small to fit the data. You can widen the column, and they will go away.

_________________
Machine: PR System One REMStar 60 Series Auto CPAP Machine
Additional Comments: Encore Basic Software; Pressure >7
Howkim

I am not a mushroom.

User avatar
photonic
Posts: 261
Joined: Fri Jun 27, 2014 7:42 pm

Re: Feature in Sleepyhead available?

Post by photonic » Sat Oct 25, 2014 8:24 am

Thanks for that; I am always learning something here!!
ResMed AirCurve 10 ASV
8 years with F&P Oracle mouth mask now changing to
F&P Evora Full with S-M size
Hozer hose management device (a miracle!)
OSCAR software

User avatar
palerider
Posts: 32300
Joined: Wed Dec 16, 2009 5:43 pm
Location: Dallas(ish).

Re: Feature in Sleepyhead available?

Post by palerider » Sat Oct 25, 2014 10:37 am

photonic wrote:Thanks for that; I am always learning something here!!
I'm also pretty sure that sleepyhead actually does export comma separated value files, but when you open them in excel, it just turns 'em into a spreadsheet automatically.

I know mark dislikes microsoft enough that he'd not be wanting to go to the extreme lengths that would be needed to generate excel files

_________________
Mask: Bleep DreamPort CPAP Mask Solution
Additional Comments: S9 VPAP Auto
Get OSCAR

Accounts to put on the foe list: dataq1, clownbell, gearchange, lynninnj, mper!?, DreamDiver, Geer1, almostadoctor, sleepgeek, ajack, stom, mogy, D.H., They often post misleading, timewasting stuff.