6: Clarius Model 4200A-SCS Parameter Analyzer Reference
6-226 4200A-901-01 Rev. C / February 2017
Using the Formulator options
You can use the Formulator functions, operators, and constants in combination to create simple or
complex analysis equations.
You can nest multiple functions. For example, in one equation you can:
• Calculate a series of moving averages for a column of data (vector) in the Analyze worksheet,
using the MAVG function.
• Find the maximum value of the MAVG averages, using the MAX function.
• Multiply the MAX found value by a constant.
The equation below illustrates this use of nested Formulator functions.
MAXDIFF = 10*MAX(MAVG(COLUMNA))
The degree (number of levels) of nesting is unlimited.
The purpose, format, and arguments for the above functions and other functions available in the
Formulator are described in the following topics.
Row 1 of an Analyze worksheet contains column headings. Therefore, when the row number (index)
of a column (vector) is specified as a function argument, do not insert 1.
Keithley Instruments recommends using the function FIRSTPOS as the argument for the first value in
a vector:
[format: FIRSTPOS(DataWorksheetColumn)]
Similarly, use the function LASTPOS for the last value in the vector:
[format: LASTPOS(DataWorksheetColumn)]
In Graph tab graphs, you can directly perform composite line fits that are equivalent to the following
groups of individual Formulator line fits:
• EXPFIT, EXPFITA, and EXPFITB
• LINFIT, LINFITSLP, LINFITXINT, and LINFITYINT
• LOGFIT, LOGFITA, and LOGFITB
• REGFIT, REGFITSLP, REGFITXINT, and REGFITYINT
• TANFIT, TANFITSLP, TANFITXINT, and TANFITYINT
The fit lines and parameters only display in the graphs. They are not available for use in calculations.
Correspondence between Graph tab and Formulator line fits
Formulator fit functions*
Corresponding
Graph tab line fit
* These functions calculate individual fit lines and parameters that may be used in other
calculations. By contrast, the Graph tab calculates and displays only the fit line and all fit
To Next Page
Loading...
Need help?
General
