Encore Pro - Another Problem

[roster]

Did you ever run a report for just one day and then check the indexes on the Sleep Therapy Daily Details report against the indexes on the Sleep Therapy Long Term Trend report?

They should all match up but, at least in my case, they are always different. Seems like sloppy programming. What do you think?

Note: I am still very happy to have this software.

[Wulfman]

Did you ever run a report for just one day and then check the indexes on the Sleep Therapy Daily Details report against the indexes on the Sleep Therapy Long Term Trend report?

They should all match up but, at least in my case, they are always different. Seems like sloppy programming. What do you think?

Note: I am still very happy to have this software.

WRONG assumption, Rooster! Obviously the programmers at Respironics took different math classes than we did.

Yeah, I inquired about this feat of mathematical "magic" of them about a week after I had been using the Encore Pro software. So.....what did they say to explain it?......."The software wasn't designed for the end users." (in other words....."GO AWAY")

That was about the time that Derek was coming out with his MyEncore program and that's what I put my confidence in. Yes, the Daily Details are seemingly correct, but the "Long Term Trend" numbers are WAY high. Basically, if you have ANY event (apnea or hypopnea), it translates to a 1.0 regardless of whether it was a 0.1.

Den

[WearyOne]

Don't ya just hate that?

I pull up reports for previous night every morning, and I had the "bright" idea to use the long-term trend data when my machine decides to have one of those, "No Daily Details" nights, so I could at least get some information. But when I compared the long-term trend graph to the daily data on the nights that daily data was reported, I found out about the rounding up, no matter what the actually number was (0.1, etc.)

But I guess since us end-users aren't supposed to be using it, it's okay if it doesn't work right, huh.

(Yeah, I'm happy to have it too. Can't remember what I did before I started using it.)

Pam

[RosemaryB]

The nightly reports are all I ever look at. Most mornings.

[jskinner]

They should all match up but, at least in my case, they are always different. Seems like sloppy programming. What do you think?

I discovered this problem as well when writing Encore Pro Analyzer. I believe that I can explain what is happening. The Smart card stores two types of data, up to seven sessions of detailed data and up to six months of stats.

The stats are stored as averages on the card. The Daily Detailed reports are generated from the detailed data and the Trend reports from the Stats.

Basically it comes down to rounding errors from what I can tell. They didn't use enough precision for the average storage (space limitation no doubt)

Thus there are a number of values that can be calculated two ways, such as AHI. In EPA i chose to use only the detailed data as it give the best results in my opinion. I maybe should use the stats value for those days that are missing due to the M-Series bug...

Its annoying yes.

Cheers,

[UmmYeah]

I discovered this problem as well when writing Encore Pro Analyzer...

Mr. Skinner,

Given your prodigious talents in working with the Encore Pro database, do you think you will someday be able to export the hourly daily detail data to your database so that we can use the numbers ourselves? I export the numbers that you use in your Encore Pro Analyzer, which I assume is the Stats section you referred to, but you don't currently seem to capture the daily detail numbers. Is that possible?

Sincerely,
An Aspiring CPAP Geek

[jskinner]

Given your prodigious talents in working with the Encore Pro database, do you think you will someday be able to export the hourly daily detail data to your database so that we can use the numbers ourselves? I export the numbers that you use in your Encore Pro Analyzer, which I assume is the Stats section you referred to, but you don't currently seem to capture the daily detail numbers. Is that possible?

First off I use both the detail (Histigram) and Trend data in EPA. Not all data is available in both tables so I have to combine them. There are numerous other tables as well that I have not mentioned for simplicity sake. I don't maintain a database myself just some in memory data structures.

I'm not sure I know what you mean by hourly data. The detailed data is stored based on seconds at a specific pressure. The stats data has start and end times but I don't remember if this snapshotted at regular intervals or not. I'm not sure if its possible to calculate the details at hourly intervals given the format. There are other tables for specific events that one might be able to build this info up from.

Its pretty easy to export directly from the database to excel so you might want to try that. I have no current plans to provide more export data (unless there is a large demand).

[jskinner]

Below is the data structure that I use internally to collect the nightly data and the tables that I use to populate them.

// Histogram
public int HistogramSeconds;
public double[] HistogramPressure = new double[3];

public int ObstructiveApneas;
public int Hypopneas;
public int NonResponsives;
public int Snores;
public int FlowLimiations;
public int VariableBreathing;

// TrendEventLog
public int TrendSeconds;
public double ApneaIndex;
public double HypopneaIndex;

public short SecondsInApnea;
public int MaxLeak;
public double NinetyPctLeak;
public double AvgLeak;
public short LargeLeakMinutes;
public short VarBreathingMinutes;

public string TherapyMode = "NA";
public string UnitModelNumber = "NA";
public string UnitSerialNumber = "NA";

public double HumidiferSetting;
public double CFlexSetting;
public int RampCount = -1;

// TrendPressureStats
public double[] Pressure = new double[20];

// Calculated
public double OAI;
public double HI;
public double NRI;
public double SI;
public double FLI;
public double AverageApneaDuration;

[UmmYeah]

I believe what I was referring to as "hourly data" is the Histogram data you are mentioning. What I would like to be able to do is to download that Histogram data into a spreadsheet so that I can generate custom graphs, making it easy to see if my apnea events occur at the same time as my leaks or increased pressure across time. EPA generates INCREDIBLY helpful information but of course, the more you know, the more you want to know. Is there anyway for a spreadsheet geek like me to get into the data in the EP database that does require some heavy coding?

[jskinner]

Is there anyway for a spreadsheet geek like me to get into the data in the EP database that does require some heavy coding?

No coding required. In Excel use the Data->Import External Data menu and walk through the wizard. Let me know if you need more detials...

[UmmYeah]

Great! I've done that with other databases so I think I can figure it out when I get home. What format is the database file and how do I locate it? I see MSSQLSERVER says the database is \\MYNAME\ENCOREPRO but I don't know how to latch on to that database to pull in the data.

[jskinner]

What format is the database file and how do I locate it? I see MSSQLSERVER says the database is \\MYNAME\ENCOREPRO but I don't know how to latch on to that database to pull in the data.

When you start the Wizard select 'new SQL Server connection' and then enter \\MYNAME\ENCOREPRO when asked, that will connect you.