wondering how to easily plot sleep data (ResScan)

[vicktn]

Is there any way to make a traditional graph (X - Y coordinates) of two sets of data from ResScan from within the software?...or move certain data to Excel and make the plot? I'd like to plot Apnea events vs pressure (low and high) to visually see if there is an ideal setting. (I also want to show my sleep doc that higher pressure doesn't necessarily reduce apnea events...which is my observation but I'd like to show hard data.) Of course I can look at my stored data in ResScan and plot it all manually with pencil and graph paper, or copy and paste individual numbers into Excel... but surely there is an easier method.

[bwexler]

You might try looking at Sleepyhead software.
I don't think it will export to excel, but it goes give you more control over your graphs then ResScan.

[Jay Aitchsee]

I think the ResScan summary data graphs do a pretty good job of showing pressure and AHI, but you can export some data including mask pressure and AHI (depending on machine and setting) in CSV format to use in a spreadsheet. In ResScan, select file > export and you'll get a dialogue box to select the patient and date range. I think the S9 might only export pressure data recorded in the auto mode, though. You'll have to try it and see.
CSV data can be exported from Sleepyhead as well.

[avi123]

Is there any way to make a traditional graph (X - Y coordinates) of two sets of data from ResScan from within the software?...or move certain data to Excel and make the plot? I'd like to plot Apnea events vs pressure (low and high) to visually see if there is an ideal setting. (I also want to show my sleep doc that higher pressure doesn't necessarily reduce apnea events...which is my observation but I'd like to show hard data.) Of course I can look at my stored data in ResScan and plot it all manually with pencil and graph paper, or copy and paste individual numbers into Excel... but surely there is an easier method.

Question,

Why would I need it in Excel? I get the following tables and graphs from ResScan 4.5 software:



The values in the following table are MEDIANS (except the hours):





With the Resmed company the newer the version of the S9 ResScan, the slower it works to process the data. What could be the reasons?

[vicktn]

Thanks. I'll try the export feature.

AVI123: The detailed graphs are fine for individual nights. I want to plot individual data points (one per night) over a two month period. The summary graphs/data will only average a time span.

[vicktn]

I tried the export feature, but when I opened the .csv file in Excel, there was no data.

[jedimark]

Is there any way to make a traditional graph (X - Y coordinates) of two sets of data from ResScan from within the software?...or move certain data to Excel and make the plot? I'd like to plot Apnea events vs pressure (low and high) to visually see if there is an ideal setting. (I also want to show my sleep doc that higher pressure doesn't necessarily reduce apnea events...which is my observation but I'd like to show hard data.) Of course I can look at my stored data in ResScan and plot it all manually with pencil and graph paper, or copy and paste individual numbers into Excel... but surely there is an easier method.

Interesting concept.

You should see the new "By Pressure" chart in the latest sleepyhead source code version... It automatically calculates all the event indices at each pressure live as you zoom and scroll through your data.



I'm about to add a mode for this graph that switches between the text format and a dual Y axis graphical plot that shows all the indices vs Time at pressure.

There is of course the old Changes in Prescription settings list in statistics, which highlights your best and worst setting yet, but you'll want an up to date version for the pressure/mode/flex strings to be accurate.

[Jay Aitchsee]

I tried the export feature, but when I opened the .csv file in Excel, there was no data.

I did have a problem exporting from ResScan 4.3. I posted about it, but no one else seemed to have the same problem so I thought it was some sort of glitch in my setup, maybe not. Previous versions of ResScan and ResScan 4.5 have worked OK for me.

Here's the thread where I discussed my problem with 4.3 viewtopic/p904821/viewtopic.php?f=1&t=9 ... 69#p901305

I want to plot individual data points (one per night) over a two month period. The summary graphs/data will only average a time span.

Not sure what you mean. The attached snip of Summary Graph shows pressure and ahi individually by night over an approximate 2 month time span.

[vicktn]

Jay Aitchsee wrote:

Not sure what you mean. The attached snip of Summary Graph shows pressure and ahi individually by night over an approximate 2 month time span.

Yeah...you've illustrated it well...that's exactly the data I want to present...only in an X-Y plot that would more clearly show whether/how AHIs track pressure. Bar graphs are fine as far as they go, but it's very difficult to compare one with the other, even when aligned. In your example, of course, you've kept the pressure fairly constant, but I have been changing it frequently, trying to find a "sweet spot".

[avi123]

Yeah...you've illustrated it well...that's exactly the data I want to present...only in an X-Y plot that would more clearly show whether/how AHIs track pressure. Bar graphs are fine as far as they go, but it's very difficult to compare one with the other, even when aligned. In your example, of course, you've kept the pressure fairly constant, but I have been changing it frequently, trying to find a "sweet spot".

Comment,

There is no need for the AHIs to be accurately pressure depended b/c our bodies don't work like a clock. See here that while I titrated myself 3 years ago there has not been any linear function of AHIs vs Pressure:

All done at begin of 2011

[IreneN]

Is this what you meant? This was something that I had wondered about also. Sleepyhead has an easy export function to CSV, and it's easy to plot in Excel. Here's what I looked at just for grins (pressure on horizontal axis and number of events on vertical):








My pressure has been set to a range of 9-12 for the last couple of weeks, with much better results than the previous setting of 7-12.

I didn't run this data until today, and thought it was interesting. By the number of dots and the number of posts, you can see I'm quite the newbie, but am doing much better lately. If I could eliminate the number of bathroom runs each night, because it takes a while to fall asleep after, I'll bet I'd feel much better and the numbers would reflect that.

This has been quite a ride so far! Thanks to all for all your helpful posts...

[Jay Aitchsee]

VickTn, I think you'd enjoy this. From an old thread I started some time back.
viewtopic.php?f=1&t=85585#p778673

Here's a chart I thought you might find interesting. It's my ResScan and Zeo data from July 2011 into Jan 2013. I created it by using the “export” function of both applications, exporting the data in CSV format into a spreadsheet (I use Open Office) and then selecting the variables to chart. I used 15 day moving averages to smooth the results a bit. The thing that really stands out is the increase in Deep Sleep in the last few months.

I have been using XPAP for more than 5 years, but like many, I continued to suffer from fatigue. So, about 3 years ago, I really started to work at becoming compliant, improving my sleep hygiene, and trying prescriptions to calm my diagnosed PLMD (none worked, BTW). Around October of 2011, I changed my diet to exclude most processed foods and have lost about 20 lbs. About that time, I also looked at my blood work and began supplementing my deficiencies, namely D3, B12, and Thyroid, all of which were low.

Prior to July 2011, my Deep Sleep as measured by 3 PSG's and Zeo had always been less than 10 minutes. I figured if I could increase my Deep Sleep, my fatigue would improve.

So now, my Deep Sleep as measured by Zeo has improved a lot. Nearly normal for my age. Is Zeo right? Has my Deep Sleep actually improved? I think yes. My fatigue is better, not miraculously, but better. I feel different in the mornings. I actually feel a little more groggy when I first wake than I used to, and I think most telling, is that I am not getting up at all during the night. Three or four years ago, I was getting up 2 or 3 times a night. Lately, not at all!

So, if my Deep Sleep has increased...why? It would be easy to say it was the mask or the CoQ10, or perhaps a combination of factors (most likely). Or, perhaps something else altogether. Looking at the data, it appears my Deep Sleep improves as daylight savings time ends. Coincidence? Maybe.

So, I'm going to continue doing what I'm doing, try to practice good sleep hygiene, keep looking for the most comfortable non leaking mask, watch my blood work, and see what happens in the summer.

Your thoughts are welcome.

Jay

... you've kept the pressure fairly constant, but I have been changing it frequently, trying to find a "sweet spot".

I know exactly what you're trying to do. I did it myself several years ago the "old fashioned way" by keeping a log and charting the variables. I caution against changing the pressure too frequently. Most find that it takes several days or longer for the body to adjust and "settle in" after a pressure change.