Section 6: Clarius
Model 4200A-SCS Parameter Analyzer Reference Manual
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
LINFIT
LINFITYINT
LINFITSLP
LINFITXINT
Linear
REGFIT
REGFITYINT
REGFITSLP
REGFITXINT
Regression
EXPFIT
EXPFITA
EXPFITB
—————
Exponential
LOGFIT
LOGFITA
LOGFITB
—————
Logarithmic
TANFIT
TANFITYINT
TANFITSLP
TANFITXINT
Tangent
* 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
parameters.