Covidien INVOS 5100C, Operator'S Manual

Page: 118 / 178

Using the Monitor Ports
7-16 Operator's Manual
7.5.1
Graph Data Files—rSO
2
versus Time with Microsoft Excel
In Microsoft Excel, a macro can be written that automates graphing rSO
2
data versus time and
places event marks on a chart. Versions of Microsoft Excel may be different, but the general steps
to chart without a macro include the following:
1.
Turn on the PC and open the Microsoft Excel program. Under File>Open, select the file name and
directory where the data file is stored (make sure “all files” or “text files” is selected). Excel will display
the Text Import Wizard dialog box. Stored data files created by the INVOS™ system are automatically
named by the software using the date (YYMMDD) followed by a letter indicating the type of recording
(N = Normal run function, C = control, I = intervention) and a file extension consisting of a letter (H =
history, or R = real-time) and a sequence number.
2.
Under Original Data Type, select Delimited, remove Tab, and select Space. The data should now be
parsed into individual cells. Select Finish.
3.
Insert an empty row at the top of the data by selecting Row from the Insert menu. Enter the column
headings in row 1.
4.
Select CTRL (PC) or Command (Mac™*) on the keyboard and select or highlight the time column start-
ing from row 1 to the end of the data. Without releasing the CTRL key, select or highlight the rSO
2
data
columns from row 1 to the end of the data.
5.
Select the Chart icon from the Chart tool bar or select Chart from the Insert menu. The Chart Wizard
will appear.
6.
Choose chart type by selecting XY Scatter as the Chart type and Scatter with data points connected by
smooth lines as the chart subtype. Other chart subtypes may be chosen for different graph line for-
mats. Select Next.

Note:
Using the XY Scatter instead of Line will yield a true x-axis time scale.
7.
Chart source data with the data range and columns previously selected in step 4. Select Next.
8.
Enter chart options, such as Chart title, Value (X) axis, and Value (Y) axis. Other parameters may also be
entered, if desired. After completing all of the chart options, select Next.
9.
Select Finish and save the file as an Excel Workbook.
10.
To further format the graph, double click on either axis and a dialog box will appear to allow changes
to other attributes.