18.104.22.168 Off-Line Analysis
If you have no requirement for real-time analysis but are interested in
post test analysis of test results, off-line data analysis should be
adopted. An example of this would be to view the results file created the
As described in section one of this chapter, the batch result file is
stored in a text based Comma Separated Variable format (CSV).
A spreadsheet is an ideal environment to analyze and manage your test
data. Almost all spreadsheet applications are able to import a CSV file.
Once imported test results may be graphed, calculated, edited and printed
like any other data. Using a package such as Microsoft Excel, macros may
be setup to sort and extract the appropriate result sections, calculate
and compile reports and finally produce a printout for records.
Refer to your own application handbook for details of importing and
EXAMPLE OF OFF-LINE ANALYSIS
The spreadsheet used in the example is Microsoft Excel 97.
From the Excel top level menu bar, select:
File > Open
Excel will then bring up the ?Open File? dialogue box. Select the results
file you wish to view and click on ?Open?.
After clicking ?Open?, the Text Import Wizard dialog box will appear:
Ensure that the ?Delimited? option is checked and click on ?Next >? to
move to step two.
In the ?Delimiters? section of this screen, ensure that only the ?Comma?
option is checked. Click on ?Next >? and proceed to step three:
Check that the ?Column Data Format? option is checked as ?General? and
click on finish.
You may need to adjust the Cell number format of the spreadsheet, and the
width of the columns, in order to display the required number of decimal
Using functions built into the spreadsheet, the data obtained may now be
used to create graphs and bar charts for a visual representation of your
As an example, to produce a graph, select a group of results from one
column; then click the Chart Wizard button and use this to create the
graph you require in the normal way.
For additional help on what may be possible, please refer to your
spreadsheet user manuals.