Encore Data Table

Mikesus · Post by **Mikesus** » Mon Mar 14, 2005 6:26 pm

Derek will probably find the most use out of this.

I finally sat down and took a look at the db structure for the Encore Software (DB is WAY over normalized, but I digress) Anyway, there is a table that contains How many Obstructive Apneas, Hypopneas, NR, and Flow limitations, along with the pressure, and the number of seconds at that pressure. (Name of the table is DBO_HISTOGRAM.

If you have MS Access you can link to the local DB fairly easily...

derek · Post by **derek** » Mon Mar 14, 2005 6:42 pm

Mike,
Please, please tell me by posting or PM. I would dearly love to get at the data to make extra plots and do statistical analyses. I've used Filemaker Pro a bit and a little bit of Access. I know many programming languages but have never had a need for SQL... What do you think about making this information public?
derek

Mikesus · Post by **Mikesus** » Mon Mar 14, 2005 6:46 pm

I could, the only problem that I found is that the Leak table is not tied to it... If you pm me your email address I can send it to you in an excel file.

derek · Post by **derek** » Wed Mar 16, 2005 7:20 am

Mike,
Thanks VERY much. With the info you gave me I was able to create an Excel spreadsheet that is linked directly to the Encore Pro database and generates plots of long-term trends (AHI, FL, snore), and AHI and Total Hours as a function of APAP pressure. Just hitting Refresh Data updates all the plots after a new download. If/when I can clean it up I may make it available to others - right now you need to know what you are doing...

Thanks again
derek

Mikesus · Post by **Mikesus** » Wed Mar 16, 2005 7:23 am

Figured you were the guy to tie it all together. Glad it helped. We might want to include that guide to linking to the SQL server that I sent you in the final version. If you pm me, I might be able to help with the refreshing, you should be able to tie Excel directly to the backend tables...

Guest · Post by **Guest** » Wed Mar 16, 2005 10:27 am

I think I understand, from the thread, what you guys have figured out on longterm trend analysis using encore, above and beyond the canned graphs. I, for one, would be very glad to know what to do to enhance the utility of the data that I know the SQL database is capturing. Great work!!

littlebaddow · Post by **littlebaddow** » Wed Mar 16, 2005 6:11 pm

derek wrote: If/when I can clean it up I may make it available to others - right now you need to know what you are doing...

Form an orderly queue
Derek, I'm sure you'd get swamped if you did decide to make it available to others, so without anyone else knowing can I join the queue please

Mikesus · Post by **Mikesus** » Wed Mar 16, 2005 6:15 pm

Well, Derek is the Math Guy, but I am hoping that we can come up with a fairly easy implementation of either an ACCESS REPORT, or an EXCEL spreadsheet that can be used with little backend knowledge.

Derek, I can prolly come up with queries to drive the excel sheets if need be.

Machine	Mask