The Charts and Graphs Project: A collaborative effort - we need your help

[SuperSleeper]

~ The Charts & Graphs Project ~

Howdy folks,

I've received a number of requests for some type of Excel spreadsheet for manually recording and displaying CPAP data.  In other words, where a patient can manually enter nightly CPAP data (such as AHI, perhaps other data also), and the spreadsheet automatically calculates your weekly, monthly & overall averages and also graphs this on a chart (Bar graph options and/or line graphs, etc), so that patient can spot changes and trends in their therapy results.

The request seems to come from folks who don't like to use a complicated software package like ResScan or SleepyHead.

In light of Apnea Board's collaborative and helpful community spirit, I'm asking those of you with a little Excel spreadsheet knowledge to help out if you can.  I'm hoping that we can come up with a finalized spreadsheet, and then upload the final version to the Apnea Board website for people to freely use as they see fit.

If you can help, or have any thoughts or ideas on this, please reply to this post and use the attachment feature (at the bottom, when you reply) to attach any spreadsheet file that you've done or you've found elsewhere.  

Then, others can build upon what you've done, and we all can make improvements to it as time goes on.

Anyone have thoughts on this?

[greatunclebill]

my wife said she will try this but...."don't expect it tommorrow". between going to work at noon and getting home not before 10 or 11pm, then doing whatever in the morning and trying to watch dvr prime time tv shows in the morning, theres not a bunch of time. i wish i knew excel because i have all the time in the world. if someone else is an excel whiz, give it a go.

first we need to get an idea from the requesters about what data they want on this.

[JudgeMental]

I just love SleepHead.. its just too ez for me and has everything I want & need. It gives me the running avg's. I'm still using the older version 8.8.2., so the newer version probably has more then I need or at least in better format. Can't beat success.
Until Sleepyhead came along I had made and used a very primitive Excell spreadsheet just to make averaging the monthly numbers easily.
I actually didn;t use Excell but a free & open productivity suite called "Open Office.org".. its freeware ..

also there is a tutorial about how to put together and use Excell (Open Office) which uses the same format.. heres link to start your education
http://spreadsheets.about.com/od/excel20..._forma.htm

[SuperSleeper]

Thanks guys... I do know how to do Excel spreadsheets, and getting a real basic sheet up and running I can do, but it's when it comes to the more advanced features like taking that data and creating nice-looking charts and graphs from it.... that's where I'm lacking.

For some reason, many people are averse to using software like ResScan or SleepyHead, but they feel completely comfortable using a simple spreadsheet.

A couple of things:

1. What kind of data would be useful to have on a spreadsheet like this? Keep in mind we want to keep it simple. It's basically a quick and easy spreadsheet for someone to manually record AHI each day plus maybe one or two other variables? (but that looks nice and is easy to use).

2. Anyone with experience in creating nice looking charts and graphs from within Excel with data like this?

I'd learn how to do this stuff, but I just don't have the time right now between work, this forum and trying to re-design the website plus other projects.

But, I thought I'd throw this out there in case someone has the time and ability to do this. Of course, it can be a collaborative effort... even if someone builds a basic spreadsheet, someone else can take that sheet and expand upon it, with nicer graphics, charts, etc.

[tombarelybreathing]

Microsoft has a chart & graph wizard that makes charting data really easy. You can choose any kind of graph you want and it grabs all the data from your spreadsheet. You can name the charts & graphs anything you want as well.

Once we all decide what data we want to see I can help with the spreadsheet & graphs if my help is needed. No problem.

tombarelybreathing.

[tombarelybreathing]

I'll start out with a basic spreadsheet with an attached graph and I'll attach the file so that people can start to come up with more ideas about what they want.

I don't know about everyone else but I find it easier to see an example and then work up from there. Give me a day and I'll have it here if you'd like...just let me know.

tombarelybreathing

[tombarelybreathing]

  Sleep Data.xls (Size: 43.5 KB / Downloads: 251)

All,

Here is a rough spreadsheet ( very very rough) just so you can see an example of what it might look like. If you want me to finish it and install graphs for the info just let me know what info you want and i'll set it up.

tombarelybreathing

[SuperSleeper]

Wow, nice job for a version 1, Tom... thanks!

Okay, folks Tom's got us rolling... what do you think of this? Anything need to be added, changed, whatever?

Wish I had time to work on this but it's nearly 2 a.m. and I need to get some sack time.

Excellent Tom... see my PM I just sent to you also...

[greatunclebill]

Wow, nice job for a version 1, Tom... thanks!

Okay, folks Tom's got us rolling... what do you think of this? Anything need to be added, changed, whatever?

Wish I had time to work on this but it's nearly 2 a.m. and I need to get some sack time.

Excellent Tom... see my PM I just sent to you also...

looks good. i'd like to have block for type of mask so we can enter our masks. for instance i am currently using 2 different full face masks on different nights. i'd like to be able to push a button and see the 2 masks side by side showing the average leaks and ahi of each to decide which is better if that makes any sense or if it is doable.

[tombarelybreathing]

Greatunclebill,

I think it can be done...I'm not sure I can "button it" but I can include multiple columns for masks and at the very least you will be able to see them both on the graph. I'm working midnight shift this week so my brain is a little foggy.

tombarelybreathing