Section 6: Clarius
Model 4200A-SCS Parameter Analyzer Reference Manual
6-184
4200A-901-01 Rev. C / February 2017
Spreadsheet
The Analyze spreadsheet is a spreadsheet that is compatible with Microsoft
®
Excel
®
. It contains at
least the following worksheets:
•
Run: Records all the numerical test data that is generated every time you execute test at a given
site. Data is recorded in real time as the test execute. The Run sheet also records data generated
by the Formulator. This worksheet is read-only.
•
Calc: Provides a spreadsheet that you can use for custom, test-specific data analysis. If there are
multiple same-named instances of a test in a project, the Calc worksheet equations are unique for
each instance. Cells in the Calc worksheet may be hot-linked to cells in the Run and Settings
worksheets.
•
Settings: Documents the test configuration and site number. This worksheet is read-only.
Run worksheet
In the Analyze pane, the Run worksheet numerically displays data for a test in a worksheet that is
compatible with Microsoft
®
Excel
®
. There is a Run worksheet for every run of every test for each site.
Each column contains the results for one test parameter or for a Formulator calculation. Each column
heading identifies the data in that column. Headings are assigned by Clarius for ITMs, by the KULT
programmer for UTMs, or by the name defined in the Formulator for the Formulator.
The contents of the Run worksheet are read-only. However, you can manipulate the contents of the
Run worksheet after linking it to or pasting it in the Calc worksheet.
If a project contains multiple instances of a test under the same name, each instance generates its
own data. Tests are numbered in the order in which they are added to the project. Ensure that you
select the correct instance of the test in the project tree to view the data for that test.
The figure below shows a Run worksheet that contains data generated by the
moscap-cvsweep
test.
Figure 348: Analyze Run worksheet
