TEST RESULTS HANDLING VOLTECH AT3600 USER MANUAL
3.2.5. 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 previous day.
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 manipulating
data.
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
PAGE 4.3.32. VPN 98 - 024 USING THE SERVER