Software for reading simple oximetry CSV files?

General Discussion on any topic relating to CPAP and/or Sleep Apnea.
ripvanwinkled
Posts: 2
Joined: Fri Jan 28, 2011 6:10 pm
Location: Milwaukee, WI

Software for reading simple oximetry CSV files?

Post by ripvanwinkled » Fri Jan 28, 2011 7:36 pm

I see mentions in the forums about tools to read CPAP downloads, but I am more interested in reading the very simple csv downloads from my fingertip pulse oximeter. Does anyone know of a nice tool (maybe just a macro for microsoft excel) that can generate graphs, or provide event and duration counts for pulse rate spike and oxygen events (and not CPAP data regarding breathing,pressure,leak, etc.)?

The reason for the question is that my CMS pulse oximeter, which comes with pretty nice software for reading their binary/proprietary download format will not let you edit out bad data so it can be removed from the breathing and pulse spike event totals and averages that it generates.
This makes the summary info it creates worthless for me. (for example, if I wake due to a car alarm going off, and my heart spikes, I want to be able to remove that event so it does not count toward my sleep arousal count)

I can use the CSV file, as that could be edited easily, but I would then need to figure out how to build my own graph and summary formulas...which I would think/hope? someone has already done.

Any good tools out there so I do not have to start from scratch on this?

HoseCrusher
Posts: 2744
Joined: Tue Oct 12, 2010 6:42 pm

Re: Software for reading simple oximetry CSV files?

Post by HoseCrusher » Fri Jan 28, 2011 8:49 pm

I am not sure what software you are using... but I can remove "artifacts" and unwanted data simply by using the left mouse button and drawing a box around the unwanted data. This results in a gray box containing the unwanted data, and the data is removed from the report summaries.

_________________
Mask: Brevida™ Nasal Pillow CPAP Mask with Headgear
Additional Comments: Machine is an AirSense 10 AutoSet For Her with Heated Humidifier.
SpO2 96+% and holding...

cpapdork
Posts: 103
Joined: Sat Nov 27, 2010 7:57 am
Contact:

Re: Software for reading simple oximetry CSV files?

Post by cpapdork » Sat Jan 29, 2011 7:52 am

ripvanwinkled wrote:I see mentions in the forums about tools to read CPAP downloads, but I am more interested in reading the very simple csv downloads from my fingertip pulse oximeter. Does anyone know of a nice tool (maybe just a macro for microsoft excel) that can generate graphs, or provide event and duration counts for pulse rate spike and oxygen events (and not CPAP data regarding breathing,pressure,leak, etc.)?
Rip, it's rather complicated software, but I imagine R will do everything you'd need. There is a graphical front-end called Rkward here:http://rkward.sourceforge.net/ (screenshots available there, too). It's mainly geared for linux, but there are windows versions available too on the download page.

If that's too much, then maybe you can get by with some custom calculations. I've been working on some CPAP data analysis, and i've found two relatively simple calculations provide some helpful data. One is Root Mean Square (RMS) and the other is a (Fast) Fourier Transform (FFT). I don't know if they would be helpful with your data. But if so, you should be able to find some tutorials on applying RMS and FFT in excel (.e.g google for "fft excel" and "root mean square excel").

If you make any progress, please share with us! Also, if you get some good results, I'd be happy to incorporate them into my CPAP data viewer (http://www.hoolehan.com/onkor) so that others with the same type of oximeter could benefit.
Image

ripvanwinkled
Posts: 2
Joined: Fri Jan 28, 2011 6:10 pm
Location: Milwaukee, WI

Re: Software for reading simple oximetry CSV files?

Post by ripvanwinkled » Sat Jan 29, 2011 11:25 am

HoseCrusher - Wow, right you are!
I would chastise myself for not reading the instructions thoroughly, but there were no instructions included with the version I have.
Thanks for the help!