~+3stddev~

Mean plus (the standard deviation time three).

~-3stddev~

Mean minus (the standard deviation time three).

~6stddev~

Standard deviation of a row times six.

A

~act,[char]~

Returns the actual value for the specified characteristic. For example ~act,pos~ returns the actual value for the Position characteristics.

~act,cause,comment~

Returns the comment of the assigned cause, if a cause has been assigned. See also ~cause,comment~.

~act,cause,desc~

Returns the label and the description of the assigned cause, if a cause has been assigned.

~act,cause~

Returns the label of the assigned cause, if a cause has been assigned.

~act,status~

Can return one of the following strings:

• Active - Loaded from database, displayed and used in statistical calculations.

• Masked - Loaded from database and displayed, but not used in statistical calculations.

• Missing - No data exists.

• Hidden - Data exists, but is not loaded from database.

• Archived - Not loaded from database and will be archived.

~act~

Value of actual for the characteristic specified in the query. 

~acttype,[char]~

Type of results data for the specified characteristic (Actual or Deviation).

~acttype~

Returns the type of the actual data.

~actvalue,[char]~

Raw value of results data for the specified characteristic. For example ~actvalue,pos~ returns the actual value for the Position characteristics.

~actvalue~

Returns the value of the actual data.

~alias,orlabel~

If the feature does not have an alias, the feature label is displayed.

~alias~

Alias label of a feature.

~alias1~

Returns the Alias 1 label of a feature, if one exists.

~alias2~

Returns the Alias 2 label of a feature, if one exists

~alias3~

Returns the Alias 3 label of a feature, if one exists

~alias4~

Returns the Alias 4 label of a feature, if one exists

~align,a1,featchr~

Returns the axis specified (characteristic) for the A1 Datum.

~align,a1,featoff~

Returns the offset specified for the A1 characteristic.

~align,a1,routhand~

Returns the handedness of the Feature designated for the A1 characteristic.

~align,a1,srchand~

Returns the handedness of the DataSource designated for the A1 characteristic.

~align,a1~

Returns the label of the Feature designated for the A1 characteristic.

~align,a2, featchr~

Returns the characteristic (X, Y or Z) of the A2 datum.

~align,a2,featoff~

Returns the offset specified for the A2 characteristic.

~align,a2,routhand~

Returns the handedness of the Feature designated for the A2 characteristic.

~align,a2,srchand~

Returns the handedness of the DataSource designated for the A2 characteristic.

~align,a2~

Returns the label of the Feature designated for the A2 characteristic.

~align,a3,featchr~

Returns the characteristic (X, Y or Z) of the A3 datum.

~align,a3,featoff~

Returns the offset specified for the A3 characteristic.

~align,a3,routhand~

Returns the handedness of the Feature designated for the A3 characteristic.

~align,a3,srchand~

Returns the handedness of the DataSource designated for the A3 characteristic.

~align,a3~

Returns the label of the Feature designated for the A3 characteristic.

~align,b1,featchr~

Returns the axis specified (characteristic) for the B1 Datum.

~align,b1,featoff~

Returns the offset specified for the B1 characteristic.

~align,b1,routhand~

Returns the handedness of the Feature designated for the B1 characteristic.

~align,b1,srchand~

Returns the handedness of the DataSource designated for the B1 characteristic.

~align,b1~

Returns the label of the Feature designated for the B1 characteristic.

~align,b2,featchr~

Returns the characteristic (X, Y or Z) of the B2 datum.

~align,b2,featoff~

Returns the offset specified for the B2 characteristic.

~align,b2,routhand~

Returns the handedness of the Feature designated for the B2 characteristic.

~align,b2,srchand~

Returns the handedness of the DataSource designated for the B2 characteristic.

~align,b2~

Returns the label of the Feature designated for the B2 characteristic.

~align,c1,featchr~

Returns the axis specified (characteristic) for the C1 Datum.

~align,c1,featoff~

Returns the offset specified for the C1 characteristic.

~align,c1,routhand~

Returns the handedness of the Feature designated for the C1 characteristic.

~align,c1,srchand~

Returns the handedness of the DataSource designated for the C1 characteristic.

~align,c1~

Returns the label of the Feature designated for the C1 characteristic.

~align,isdatum,a1~

The feature is used as A1 in the alignment.

~align,isdatum,a2~

The feature is used as A2 in the alignment.

~align,isdatum,a3~

The feature is used as A3 in the alignment.

~align,isdatum,b1~

The feature is used as B1 in the alignment.

~align,isdatum,b2~

The feature is used as B2 in the alignment.

~align,isdatum,c1~

The feature is used as C1 in the alignment.

~align,isdatum,is,isnt,[char]~

If the feature is used in the alignment for the specified [characteristic], the variable returns the string "is". If the feature is not used in the alignment for the specified [characteristic], the variable returns the string "isnt".

~align,isdatum,yes,no,[char]~

Using the [yes] and [no] parameters with the ~align,isdatum~ variable allows you to replace the strings "is" and "isnt" with text that you choose.

~align,isdatum~

If the characteristic is used in an Alignment, then will return the datum specified for the characteristic: A1, A2, A3, B1, B2, C1. If the characteristic is not part of an alignment, nothing will be returned.

~align,isoffset~

If the characteristic is used in an Alignment, then will return the offset specified for the characteristic: A1, A2, A3, B1, B2, C1. If the characteristic is not part of an alignment, nothing will be returned.

~align,rout~

Returns the label of the subroutine being aligned.

~align,routhand~

Returns the handedness of the routine being aligned.

~align,routine~

Same as ~align,rout~.

~align,routkey~

Returns the routine label plus the routine key filters. This variable can be used as a unique identifier for subroutines.

~align,sampstate~

The state of the alignment mode for a Sample. Will return one of the following: Aligned, NOT Aligned, or FAILED Align.

~align,state~

The state of the alignment mode for a Subroutine. Will return one of the following: Aligned, NOT Aligned, or FAILED Align. Using the state parameter with the align variable allows users to replace the strings Aligned, Failed Align, Not Aligned and No Subroutine with text that they choose.
NOTE: If the variable ~align,state,Yes,No,N/A,Error~ was used, the values Yes, No, N/A and Error would be used in place of the standard value strings.

~align~

Returns one of the following strings:

• Aligned - Alignment was successful.

• Failed Align - Alignment failed.

• Not Aligned - Alignment has not been turned on or has not been requested.

• No Subroutine - Alignment can't be applied because alignment requires a subroutine.

~annot,error~

Returns the text from Resolve Errors.

~annot,label~

Returns the label of the annotation.

~annot,type~

Returns the type of annotation.

~annot~

Returns the label of the annotation.

~axdir,[char]~

Returns the axis direction of the specified characteristic.

~axdir~

Returns the axis direction, as defined by the primary direction label. Same as ~axdir,p~. The direction values may be customized in the Direction Labels section of the Document Defaults dialog.

~axis,p~

Returns the primary axis label.

~axis~

Primary axis of SMI feature, or specified axis.

B

~boxhi~

Highest value in DataSet row that is within the uif (Upper Inner Fence). 

~boxlo~

Lowest value in DataSet row that is within the lif (Lower Inner Fence). 

C

~car~

OBSOLETE: Although a value may be returned if ~car~ is used, it will be inaccurate and unreliable. Use the variable ~dev~ to return deviation and deviation type.

~cause,comment~

Returns the cause comment. See also ~act,cause,comment~.

~cause,desc~

Returns the cause description.

~cause,feature~

Returns the label of the feature.

~cause,label~

Returns the cause label.

~cause,mask~

Returns whether the cause is masked or active sample.

~cause,sample~

Returns the label of the sample.
When ~cause,sample~ is used in a table (and there is more than one sample), the second sample label will be listed below the first sample label in the same cell:
See the topic Table Properties for more information on table expansion.

~cause~

Returns any cause that is assigned to an actual.

~cc~

Returns the Correlation Coefficient, which measures the strength of the relationship between two variables. The variable ~cc~ is the same as ~rp~.
The variables ~cc~ and ~cctarget~ are used in the CM4D Normality tests to examine the relationship of a set of Sample data to the normally distributed model of the data. The ~cc~ value is compared to the ~cctarget~ value as one of the Normality checks CM4D performs. See here for more information on Normality in CM4D.

~cctarget~

Returns the target value used to calculate the Correlation Coefficient. A ~cc~ value below the target is considered an indication that the data is NOT normally distributed. See the topic Normality Variables for details.

~cell~

Returns the value of a cell in a DataSet. The ~cell~ variable requires a row to be specified in the DataSet, and must have an active sample.

~cellsamp~

Returns the label for the sample resolved for the cell. For DataSets with multiple Routines, this resolves as the row number. This variable is not supported for DataStacks.

~cellsamp,filter,[a-z]~

Returns the specified filter for the sample resolved for the cell. For DataSets with multiple Routines will resolve the text of a chart axis as the Sample Label instead of the DataSet column number. This is best used with either a single feature or with Routines that have corresponding samples.

~cellsamp,label~

Returns the label for the sample resolved for the cell. For DataSets with multiple Routines will resolve the text of a chart axis as the Sample Label instead of the DataSet column number. This is best used with either a single feature or with Routines that have corresponding samples.

~chr,1~

Returns the first a letter of the characteristic type.

~chr~

Will return the characteristic used in a DataSet row.

~compareprecision~

Returns the Compare Precision number set on the Document Properties Defaults Tab.

~conformcount~

Returns number of conforming values for either Tol or Tol2 in a DataSet row.

~conformcount1~

Returns number of conforming values for Tol in a DataSet row.

~conformcount2~

Returns number of conforming values for Tol2 in a DataSet row.

~conformcountboth~

Returns number of conforming values for both Tol and Tol2in a DataSet row.

~count~

Returns the number of valid values within a DataSet row. Same as ~validcount~.

~cp~

Capability or potential of the process. A ratio of the specification width to the width of the normal distribution. Cp is normally calculated using an estimated standard deviation formula that uses either the mean of subgroup ranges or the mean of subgroup standard deviations with constant table values relative to the subgroup size. 

~cp2~

Capability or potential of the process, calculated on Tol2 (Tolerance 2).

~cpk~

Capability of process index relative to dispersion and centeredness. From the true process center (), Cpk indicates the closest specification limit (in terms of estimated standard deviation units/3).
Calculated on Tol (Tolerance).

~cpk2~

Capability of process index, calculated on Tol2 (Tolerance 2).

~cpk2Alevel,0~

Cpk < 0.33

~cpk2Alevel,1~

Cpk >= 0.33, < 0.67

~cpk2Alevel,2~

Cpk >= 0.67, < 1.00

~cpk2Alevel,3~

Cpk >= 1.00, < 1.33

~cpk2Alevel,4~

Cpk >= 1.33, < 1.67

~cpk2Alevel,5~

Cpk >= 1.67, < 2.00

~cpk2Alevel,6~

Cpk >= 2.00

~cpk2Alevel~

Returns the 6 sigma level 0-6.

~cpk2Blevel,2~

Cpk >= 0.67, < 1.00

~cpk2Blevel,3~

Cpk >= 1.00, < 1.33

~cpk2Blevel,4~

Cpk >= 1.33, < 1.67

~cpk2Blevel~

Returns the 6 sigma level 2-4.

~cpkAlevel,0~

Cpk < 0.33

~cpkAlevel,1~

Cpk >= 0.33, < 0.67

~cpkAlevel,2~

Cpk >= 0.67, < 1.00

~cpkAlevel,3~

Cpk >= 1.00, < 1.33

~cpkAlevel,4~

Cpk >= 1.33, < 1.67

~cpkAlevel,5~

Cpk >= 1.67, < 2.00

~cpkAlevel,6~

Cpk >= 2.00

~cpkAlevel~

Returns the 6 sigma level 0-6.

~cpkBlevel,2~

Cpk >= 0.67, < 1.00

~cpkBlevel,3~

Cpk >= 1.00, < 1.33

~cpkBlevel,4~

Cpk >= 1.33, < 1.67

~cpkBlevel~

Returns the 6 sigma level 2-4.

~cpm~

Capability of process index influenced by the difference between the sample mean and the nominal target value.

~cr~

Capability ratio. The reciprocal of Cp. 

D

~dagostino~

Returns n/a, normal, or abnormal. This returns the result of the D'Agostino Pearson Omnibus test for Normality.

~dataset,boxhi~

Returns the box highest value for the entire DataSet.

~dataset,boxlo~

Returns the box lowest value for the entire DataSet.

~dataset,conformcount~

Returns the number of conforming values in a DataSet.

~dataset,cp~

Returns the Cp value of the data in the DataSet. There are two limitations to calculating Process Capability on a DataSet:
  1. All cells in the DataSet must have a Tolerance, and the Tolerance must be the same for all cells in the DataSet.
  2. Subgroups will not be applied when using the Cpk parameter.
Without Subgroups, Cp is the same as Pp.

~dataset,cpk~

Returns the Cpk value of the data in the DataSet. There are two limitations to calculating Process Capability on a DataSet:
  1. All cells in the DataSet must have a Tolerance, and the Tolerance must be the same for all cells in the DataSet.
  2. Subgroups will not be applied when using the Cpk parameter.
Without Subgroups, Cpk is the same as Ppk.

~dataset,cr~

Returns the Cr value of the data in the DataSet. There are two limitations to calculating Process Capability on a DataSet:
  1. All cells in the DataSet must have a Tolerance, and the Tolerance must be the same for all cells in the DataSet.
  2. Subgroups will not be applied when using the Cpk parameter.
Without Subgroups, Cr is the same as Pr.

~dataset,hi~

Returns the high value for the entire DataSet.

~dataset,invalidcount~

Returns the number of invalid values in an entire DataSet.

~dataset,iqr~

Returns the inter quartile range for the entire DataSet.

~dataset,lif~

Returns the lower inner fence value for the entire DataSet.

~dataset,lo~

Returns the lo value of the entire DataSet.

~dataset,lof~

Returns the lower outer fence value for an entire DataSet.

~dataset,lowerlimit~

Returns the lower limit for the entire DataSet.

~dataset,mean~

Returns the mean value for the entire DataSet.

~dataset,median~

Returns the median value for the entire DataSet.

~dataset,nonconformcount~

Returns number of nonconforming values in a DataSet

~dataset,nospeccount~

Returns the number of valid values in an entire DataSet that do not have a spec limit.

~dataset,nospeccount2~

Returns the number of valid values in an entire DataSet that do not have a spec limit 2.

~dataset,outofspeccount~

Returns the number of valid values in a DataSet that are out of spec.

~dataset,outofspeccount2~

Returns the number of valid values in a DataSet that are out of spec2.

~dataset,percentconform~

Returns percent of conforming values in a DataSet.

~dataset,percentinvalid~

Returns the percent of invalid values in an entire DataSet.

~dataset,percentnonconform~

Returns percent of nonconforming values in a DataSet.

~dataset,percentvalid~

Returns the percent of valid values in an entire DataSet.

~dataset,pp~

Returns the Pp value of the DataSet.

~dataset,ppk~

Returns the Ppk value of the DataSet.

~dataset,pr~

Returns the Pr value of the DataSet.

~dataset,q1~

Returns the quartile one value for an entire DataSet.

~dataset,q3~

Returns the quartile one value for an entire DataSet.

~dataset,range~

Returns the range value for the entire DataSet.

~dataset,rovcenter~

Returns the ROV Center for the entire DataSet. See also, DataSet Range of Variation.

~dataset,rovspread~

Returns the ROV Spread for the entire DataSet. See also, DataSet Range of Variation.

~dataset,rovtarget~

Returns the ROV Target for the entire DataSet. See also, DataSet Range of Variation.

~dataset,rowcount~

Returns the number of rows in the DataSet. See also, ~rows~.

~dataset,stddev~

Returns the Standard Deviation of the DataSet.

~dataset,sum~

Returns the value of the sum of an entire DataSet.

~dataset,totalcount~

Returns the number of values in an entire DataSet.

~dataset,uif~

Returns the upper inner fence value for the entire DataSet.

~dataset,uof~

Returns the upper outer fence value for an entire DataSet.

~dataset,upperlimit~

Returns the upper limit for the entire DataSet.

~dataset~

Returns the label of the DataSet.

~datastate~

Returns Collecting Data or Not Collecting Data. The ~datastate~ variable returns "Collecting Data" if a DataSet is in Collecting Data mode, or "Not Collecting Data" if the DataSet is in any mode other than collecting data.

~date,[param]~

See the [Parameters] above for a complete list of available date parameters.

~date~

Returns the current date using the current regional format. Formatting options below are case sensitive, may be combined, and may be applied also to the variable ~samp,date~. For example:
If the date was March 14, 2002, ~date,%d-%b-%Y~ would resolve to "14-MAR-2002".
If the time were 08:12:59, ~date,%M past %H~ would resolve to "12 past 08".

~dev,[char]~

Returns the deviation value of the specified characteristic, based on the query setting.

~dev~

Returns the deviation value based on the query setting.

~devtype~

Returns the deviation type, Vec or Car, based on the query setting.

~distribution~

Returns n/a, normal, or abnormal. This is based on the Normal Distribution Correlation Coefficient (~cc~). If the value of ~cc~ is less than the target (~cctarget~), then ~distribution~ will return abnormal. If the value of ~cc~ is greater than or equal to ~cctarget~, then ~distribution~ will return normal. If ~cc~ does not resolve, then ~distribution~ will return n/a.

~doc,[param]~

Returns information related to the CM4D document.

~doc,label~

Returns the saved name of the document, excluding the file extension.

~doc,path~

Returns the entire folder path of document, excluding the filename.

~doc,title~

Returns the saved name of the document, including the file extension.

E

~err~

Returns the value of the error (the amount out of  tolerance). Always an absolute value.

~err2~

Returns the amount of error of a value compared to tolerance 2.

~errr~

Returns the amount of error of a value compared to reasonable limits.

~eventcount1~

Returns the number of events for Trigger 1.

~eventcount2~

Returns the number of events for Trigger 2.

~eventcountboth~

Returns the number of events that triggered for both Trigger 1 and 2.

F

~feat,alias~

Returns the value of the alias of the feature.

~feat,alias1~

Returns the value of the alias 1 of the feature.

~feat,alias2~

Returns the value of the alias 2 of the feature.

~feat,alias3~

Returns the value of the alias 3 of the feature.

~feat,alias4~

Returns the value of the alias 4 of the feature.

~feat,desc~

Returns the description of the feature.

~feat,label~

Returns the label of the feature.

~feat,refcount~

Resolves the number of reference features associated to the feature.

~feat,seq~

Returns the sequence of the feature.

~feat,sourcerout~

Returns the source routine of the feature.

~feat,sourceroutkey~

Returns the source routine key of the feature.

~feat,type~

Returns the implied SMI Type, which is used by the Sift Rules.

~feat~

Returns the label of the feature.

~featref1,alias~

Returns the value of the alias of the first reference feature.

~featref1,alias1~

Returns the value of the alias 1 of the first reference feature.

~featref1,alias2~

Returns the value of the alias 2 of the first reference feature.

~featref1,alias3~

Returns the value of the alias 3 of the first reference feature.

~featref1,alias4~

Returns the value of the alias 4 of the first reference feature.

~featref1,desc~

Returns the description of the first reference feature.

~featref1,filter~

Returns the filter value for the specified feature filter (use character A through Z, or filter label as defined in database) of the first reference feature.

~featref1,label~

Returns the label of the first reference feature.

~featref1,seq~

Returns the sequence of the first reference feature.

~featref1,sourcerout~

Returns the source routine of the first reference feature.

~featref1,sourceroutkey~

Returns the source routine key of the first reference feature.

~featref1,type~

Returns the type of the reference first feature.

~featref1~

Returns the label of the first reference feature.

~featref2,alias~

Returns the value of the alias of the second reference feature.

~featref2,alias1~

Returns the value of the alias 1 of the second reference feature.

~featref2,alias2~

Returns the value of the alias 2 of the second reference feature.

~featref2,alias3~

Returns the value of the alias 3 of the second reference feature.

~featref2,alias4~

Returns the value of the alias 4 of the second reference feature.

~featref2,desc~

Returns the description of the second reference feature.

~featref2,filter~

Returns the filter value for the specified feature filter (use character A through Z, or filter label as defined in database) of the second reference feature.

~featref2,label~

Returns the label of the second reference feature.

~featref2,seq~

Returns the sequence of the second reference feature.

~featref2,sourcerout~

Returns the source routine of the second reference feature.

~featref2,sourceroutkey~

Returns the source routine key of the second reference feature.

~featref2,type~

Returns the type of the reference second feature.

~featref2~

Returns the label of the second reference feature.

~feature~

Same as ~feat~.

G

~grade,count~

Returns the number of valid values in tolerance. This variable must use a DataStack as its DataSource, and the DataStack must have limits.

~grade,percent~

Returns the percent of valid values in tolerance (count divided by total). Percent is rounded to nearest integer (no % sign).

~grade,total~

Returns the total number of valid values. This variable must use a DataStack as its DataSource, and the DataStack must have limits.

~grade~

Requires a DataStack as the DataSource. Grade looks at every cell of the entire DataStack and checks to see if the values are within Spec Limits. The ~grade~ variables are very similar to the ~tally~ variables.

~graphtype~

Returns the type of a graph. The graph types are Trend, XBar-R, XBar-S, X-MR, MA-MR, Box_Whisker, Six Sigma, Pareto, Normality, Benchmark, Target, and Six Sigma Projection.

H

~hand,1~

Returns just L or R.

~hand~

Returns LEFT or RIGHT. The handedness is based on the value of the Y char. If Y is less than zero (negative), the handedness will be LEFT; if Y is more than zero (positive), the handedness will be RIGHT.

~hi~

Highest of valid values within a DataSet row 

I

~invalidcount~

Number of invalid values in DataSet row. Invalid data is not nonconforming data and so will not be included in the ~validcount~ results. 

~iqr~

Inter Quartile Range (q3-q1) 

K

~kurtosis~

Returns the measure of flatness of a distribution 

L

~label~

Returns the label of feature.

~lcl,[char],[param]~

~lcl~

Lower control limit. The lower control limit for control charts. Control limits are used with the distribution of averages not the distribution of individuals. Control limits are used in conjunction with process control charts to identify when assignable causes of variation are present. Control limits should not be confused with specification limits which are established for engineering specifications and are used with individual measurements to indicate process performance.

~lcl2,[char],[param] ~

~lcl2~

Lower Control Limit 2. The variable ~lcl2~ will return the value of the lcl 2 if one has been created. See ~lcl~.

~lclma,[char],[param] ~

~lclma~

Lower control limit for Moving Average 

~lclmr,[char],[param] ~

~lclmr~

Lower control limit for Moving Range 

~lclr,[char],[param] ~

~lclr~

Lower control limit for Range 

~lcls,[char],[param] ~

~lcls~

Lower control limit for Standard Deviation 

~lclxbr,[char],[param] ~

~lclxbr~

Lower control limit for Xbar with Range 

~lclxbs,[char],[param] ~

~lclxbs~

Lower control limit for Xbar with Standard Deviation 

~lclxmr,[char],[param] ~

~lclxmr~

Lower control limit for  X with Moving Range 

~lif~

Lower Inner Fence (q1 - 1.5 * iqr) 

~limittype~

The ~limittype~ variable determines whether a control chart is using Trial Control Limits or Process Control Limits (e.g. "Trial XBar-R" or "Control XBar-R").

~lo~

Lowest of valid values within a DataSet row 

~load,[param] ~

Load information for the Query.

~load,feattime~

Returns the total time it took the query to load the features.

~load,features,filters~

Returns the filters that were selected and used by the loaded features.

~load,features~

Returns the number of features loaded in a query.

~load,images~

Returns the number of Routine images loaded in the query.

~load,imagetime~

Returns the total time it took the query to load all its images.

~load,label~

Returns the label of the query.

~load,loadtime~

Returns the total time it took the query to load its features, samples and images.

~load,order~

Returns the setting of the order of the samples in the query.

~load,query~

Returns the settings for the samples in the query.

~load,routine~

Returns the routine label of any routine in the query. If more than one routine exists in the query, the variable returns the routine labels of all the routines, separated by a space.

~load,routtime~

Returns the total time it took the query to load all its Routines.

~load,samples~

Returns the number of synchronized samples.

~load,samptime~

Returns the total time it took the query to load all its Samples.

~lof~

Lower Outer Fence (q1 – 3.0 * iqr) 

~lrl~

Lower reasonable limit. For more information about reasonable limits see the topic Reasonable Limits.

~lrt~

Lower reasonable tolerance.

~lsl~

Lower specification limit. The lower engineering limit specified for a measurement. 

~lsl2~

Lower specification limit 2. The lower engineering limit 2 specified for a measurement. 

~lt~

Lower tolerance.

~lt2~

Lower tolerance 2.

M

~mean,ga~

Grand average of subgroup averages within a DataSet row. This is the same as ~mean~, unless some subgroups were found to be invalid because they had invalid or missing sample values. Subgroups with invalid values are removed from statistical calculations since their subgroup size is affected.

~mean,ma~

Mean moving average of subgroup moving averages within a DataSet row 

~mean,mr~

Mean moving range of subgroup moving ranges within a DataSet row 

~mean,r~

Mean range of subgroup ranges within a DataSet row 

~mean,s~

Mean standard deviation of subgroup standard deviations within a DataSet row 

~mean~

Average of valid values within a DataSet row 

~median~

Middle value of DataSet row.

~miniball,isvalid~

Returns 1 or 0, indicating whether or not the Miniball is valid. The variable ~miniball,valid~ may also be used to return the same result.

~miniball,m-dia~

Returns the diameter of the Miniball.

~miniball,m-out#~

Returns number of points that are Out of Miniball Limit.

~miniball,m-out%~

Returns the percentage of out of limit points for Miniball {m-out#/pnt#}.

~miniball,m-rad~

Returns the radius of the Miniball.

~miniball,msk#~

Returns the number of masked data points.

~miniball,m-tol~

Returns the tolerance of the Miniball.

~miniball,m-told~

Returns the diametrical tolerance of the Miniball.

~miniball,pnt#~

Returns the number of points included in the Miniball calculation.

~miniball,ref#~

Returns the number of features referenced by the constructed Polar feature.

~miniball,ref~

Returns the Reference Feature used in the Constructed Feature.

~miniball,refdesc~

Returns the Description (if available) of the Reference Feature.

~miniball,refpol~

Returns the Polar value of the Reference Feature used in the Constructed Feature.

~miniball,refx~

Returns the Nominal X value of the Reference Feature.

~miniball,refy~

Returns the Nominal Y value of the Reference Feature.

~miniball,refz~

Returns the Nominal Z value of the Reference Feature.

~miniball,status~

Returns one of the five states of the Miniball calculation for a single feature.

• Masked - the feature is masked

• Conform - the feature is within the Miniball tolerance

• Zero! - the feature is out of Miniball tolerance

• Mini! - this status does not yet apply

• Both! - this status does not yet apply

~miniball,x~

Returns the horizontal offset of the Miniball. The variable ~miniball,x-off~ may also be used to return the same result.

~miniball,y~

Returns the vertical offset of the Miniball. The variable ~miniball,y-off~ may also be used to return the same result.

~miniball,z-dia~

Returns the diameter of the Zeroball.

~miniball,z-out#~

Returns the number of points that are Out of Zeroball Limit.

~miniball,z-out%~

Returns the percentage of out of limit points for Zeroball {z-out#/pnt#}.

~miniball,z-rad~

Returns the radius of the Zeroball, from center zero.

~miniball,z-tol~

Returns the tolerance of the Zeroball.

~miniball,z-told~

Returns the diametrical tolerance of the Zeroball.

~msa,effdate~

Effective Date

~msa,ev~

Equipment Variation

~msa,evpt~

Equipment Variation as a percent of Tolerance

~msa,evptv~

Equipment Variation as a percent of Total Variation

~msa,mv~

Measurement Variation = PF * ~stddev~ (with setup) or ~stddev,e~ (without setup)  

~msa,mvpt~

Measurement Variation as a percent of Tolerance

~msa,operators~

Number of Operators used in study

~msa,ov~

Operator Variation

~msa,ovpt~

Operator Variation as a percent of Tolerance

~msa,ovptv~

Operator Variation as a percent of Total Variation

~msa,parts~

Number of Parts used in study

~msa,pf~

Program Factor = 5.15 or 6.0

~msa,pv~

Part Variation

~msa,pvpt~

Part Variation as a percent of Tolerance

~msa,pvptv~

Part Variation as a percent of Total Variation

~msa,rr~

Repeatability & Reproducibility

~msa,rrpt~

Repeatability/Reproducibility as a percent of Tolerance

~msa,rrptv~

Repeatability/Reproducibility as a percent of Total Variation

~msa,status~

Status (Passed-Green [< = MSA TargetMin], May be acceptable-Yellow [between TargetMin and TargetMax], Failed-Red [> = TargetMax], Not-Done)

~msa,studydate~

Study Date

~msa,studytype~

Study Type (With Setup, Without Setup, User Defined)

~msa,targetmax~

Target Maximum

~msa,targetmin~

Target Minimum

~msa,tol~

Study Tolerance

~msa,trials~

Number of Trials per operator used in study

~msa,tv~

Total Variation

~msa,updatedate~

Update Date

~msa~

Returns the measurement system analysis of a DataSet row. Same as ~msa,mvpt~ for legacy support.

N

~nom,[char] ,eff, [param] ~

Returns the effective date of the nominal characteristic, according to the parameters set. See the [Parameters] above for a complete list of available date parameters.

~nom,[char],eff~

Returns the effective date of the nominal characteristic.

~nom,[char],label~

Returns the label of the nominal characteristic.

~nom,[char],signif~

Returns the significance of a characteristic. The possible values which can be returned are: Unknown, Insignificant, Significant, Data Not Allowed or Alarmed.

~nom,[char]~

Value of nominal for specified characteristic.

~nom,filter,[A-Z] ~

Returns the value of the nominal filter. There are 26 filters available in the database, A-Z. Filters can also have labels, in addition to their alphabetical designations. If no label was assigned to the filter when it was created, a default filter label would have been created, using the word 'Filter', a space, then the letter designation of the filter. For example, if ~nom,filter,S~ were used, it would return the nominal value of the S filter.

~nom,filter,[filterlabel] ~

Returns the value of the nominal filter. Filters can also have alphabetical designations, in addition to their labels. There are 26 filters available in the database, A-Z. All of these filters can also have filter labels. For example, if ~nom,filter,operator~ were used it would return the value of the filter labelled "Operator'".

~nom~

Returns the nominal value. 

~nonconformcount~

Returns number of nonconforming values for either Tol or Tol2 in a DataSet row.

~nonconformcount1~

Returns number of conforming values for Tol in a DataSet row.

~nonconformcount2~

Returns number of nonconforming values for Tol2 in a DataSet row.

~nonconformcountboth~

Returns number of nonconforming values for both Tol and Tol2in a DataSet row.

~normality~

Returns n/a, normal, or abnormal. If either ~distribution~ or ~dagostino~ returns normal, then ~normality~ will return normal. If neither ~distribution~ or ~dagostino~ returns normal, then ~normality~ will return either n/a or abnormal.

~nospeccount~

Number of valid values in a DataSet row that do not have a spec limit 

~nospeccount2~

Number of valid values in a DataSet row that do not have a spec limit 2.

O

~off~

[DEPRECATED] Although a value may be returned when ~off~ is used, it will be inaccurate and unreliable. Use the variable ~dev~ to return deviation and deviation type.

~ord~

[DEPRECATED] Although a value may be returned when ~ord~ is used, it will be inaccurate and unreliable. Use the variable ~dev~ to return deviation and deviation type.

~outofspeccount~

Returns the number of values in a DataSet row that are out of spec, or out of tolerance, regardless of the Event Trigger setting.

~outofspeccount2~

Returns the number of values in a DataSet row that are out of spec 2, or out of tolerance 2, regardless of the Event Trigger setting.

P

~page,count~

Returns the number of sheets in the SheetSet, not including the title sheet.

~page,label~

Returns the sheet label. (This variable will not return a value when used on the title sheet.)

~page~

Returns the page number of the current sheet (within a SheetSet). Same as ~sheets~.

~pages~

Returns the number pages in the SheetSet. Same as ~sheets~.

~percentconform~

Returns percent of conforming values for either Tol or Tol2 in a DataSet row.

~percentconform1~

Returns percent of conforming values for Tol in a DataSet row.

~percentconform2~

Returns percent of conforming values for Tol2 in a DataSet row.

~percentconformboth~

Returns percent of conforming values for both Tol or Tol2 in a DataSet row.

~percentinvalid~

Percentage of invalid values in DataSet row 

~percentnonconform~

Returns percent of nonconforming values for either Tol or Tol2 in a DataSet row.

~percentnonconform1~

Returns percent of nonconforming values for Tol in a DataSet row.

~percentnonconform2~

Returns percent of nonconforming values for Tol2 in a DataSet row.

~percentnonconformboth~

Returns percent of nonconforming values for both Tol or Tol2 in a DataSet row.

~percentvalid~

Percentage of valid values in DataSet row 

~pp~

Returns Pp calculated on Tol (Tolerance).

~pp2~

Returns Pp calculated on Tol2 (Tolerance 2).

~ppk~

Returns Ppk calculated on Tol (Tolerance).

~ppk2~

Returns Ppk calculated on Tol2 (Tolerance 2).

~pr~

Process performance ratio. The reciprocal of pp. 

~process,cp~

Capability or potential of the process baseline. The ratio of the specification width to the width of the normal distribution. Cp is normally calculated using an estimated standard deviation formula that uses either the mean of subgroup ranges or the mean of subgroup standard deviations with constant table values relative to the subgroup size.

~process,cpk~

Capability of the process baseline index relative to dispersion and centeredness. From the true process center (), Cpk indicates the closest specification limit (in terms of estimated standard deviation units/3).

~process,cpm~

Capability of the process baseline index influenced by the difference between the sample mean and the nominal target value.

~process,cr~

Capability ratio using the process baseline. The reciprocal of Cp.

~process,effdate~

Returns the effective date of the process.

~process,effdates~

Returns the effective dates for the process baseline.

~process,lsl~

Lower specification limit for the process baseline. The lower engineering limit specified for a measurement.

~process,mabar~

Returns the MA Bar value.

~process,mean~

Mean (average) of valid values within a data set row for the process baseline.

~process,mrbar~

Returns the MR Bar value.

~process,nom,[char],abs~

Returns the value of the absolute nominal within the process baseline for a specified characteristic.

~process,nom,[char],rel~

Returns the value of the relative nominal within the process baseline for a specified characteristic.

~process,nom,[char]~

Returns the value of the nominal within the process baseline for a specified characteristic.

~process,pp~

The process baseline performance index relative to dispersion. A ratio of the specification width to the width of the normal distribution. Pp is calculated using calculated or sample population standard deviation.

~process,ppk~

The process baseline performance index relative to dispersion and centeredness. Ppk is calculated using calculated or sample population standard deviation.

~process,rbar~

Returns the R Bar value.

~process,sbar~

Returns the S Bar value.

~process,stddev~

Calculated standard deviation of a row, for the process baseline.

~process,stddevest~

Estimated standard deviation of a row, for the process baseline.

~process,stddevtarget~

A measure of the spread of the data used in the denominator of the CPM calculation for the process baseline.

~process,subsize~

Returns the subgroup size for the process baseline.

~process,usl~

Upper specification limit for the process baseline. The upper engineering limit specified for a measurement.

~process,xbarbar~

Returns the X Double Bar value.

~process~

All process variables report values based on process control statistics for the most recent process baseline. A process variable will return values from the most recent process in the DataSet. If you wish your process variables to display data from a process other than the most recent process in the DataSet, you should create a new DataSet in which the process you want to display is the most recent process.

Q

~q1~

Quartile 1 value, i.e., Lower Quartile 

~q2~

Quartile 2 value, i.e., Median 

~q3~

Quartile 3 value, i.e., Upper Quartile 

R

~range~

Range (highest - lowest) of valid values within a DataSet row 

~reportsiftrule~

Returns the sift rule used for the report.

~rout,alias~

Returns the alias of the routine.

~rout,code~

Returns the routine code.

~rout,desc~

Returns the routine description.

~rout,filter~

Returns the filter associated with the routine.

~rout,hand~

Returns the handedness of the routine as:

• RH - Right Handed

• LH - Left Handed

• BH - Both Hands

• ?H - No Handedness

~rout,imagesrc~

Returns name of the image file associated with the routine.

~rout,imagetype~

Returns type of image which is associated with the routine:

• Wire

• 2D

• 3D

~rout,key~

Returns the routine key.

~rout,maxsamps~

Returns the maximum samples setting for the routine.

~rout,node~

Returns the label of the routine node.

~rout,nodecode~

Returns the routine node's routine code.

~rout,subgroup~

Returns the subgroup size of the routine.

~rout,sublabel~

Returns the subroutine label if the subroutine is active. If there is no active subroutine, the variable will be blank.

~rout~

Returns the label of the routine. Same as ~routine~.

~routine~

Returns the label of the routine. Same as ~rout~.

~rovcenter~

Returns the default ROV Center value.

~rovcenterok~

Returns status of the ROV Center for the row, OK or NOTOK.

~rovspread~

Returns the default ROV Spread value.

~rovspreadok~

Returns status of the ROV Spread for the row, OK or NOTOK.

~rovtarget~

Returns the default ROV Target value.

~rovtargetok~

Returns status of the ROV Target for the row, OK or NOTOK.

~row,actual~

Returns the active row number in a DataSet.

~row,actualcount~

Returns a count of the number of active rows in a DataSet.

~row,virtual~

Returns the active row number from the map column in a DataSet when Multiple Sift Rules are being used.

~row,virtualcount~

Returns the total number of active rows from the map column in a DataSet when Multiple Sift Rules are being used.

~row~

Returns number of the DataSet row.

~rowlabel~

Returns the label of the DataSet row.

~rows~

Returns the number of rows in the DataSet.

~rp~

Returns Relational Probability. This is the same as Correlation Coefficient.

~rstat,count~

Returns the number of Range features that are in the DataSet.

~rstat,hi~

Returns the highest value in the range of deviations.

~rstat,lo~

Returns the lowest value in the range of deviations.

~rstat,mean~

Returns the mean value of the range of deviations.

~rstat,ppk~

Returns the Ppk value of the range of deviations.

~rstat,stddev~

Returns the standard deviation within the range of deviations.

~rstat~

The "rstat" variables calculate various statistics on the reference features of a Range feature. Range statistics are calculated per sample for all reference features.

S

~samp,archdate~

Returns the archive date of the sample.

~samp,archdays~

Returns the number of days after the creation date until the samples are archived.

~samp,archtype~

Returns the archive type of the sample: Date, Days, or Never.

~samp,date,%__~

Returns the creation dates of the Sample in a format specified by the specified Date parameter(s). For example, if the date was March 14, 2002, ~samp,date,% d-%b-%Y~ would resolve to "14-MAR-2002". If the time were 08:12:59, ~samp,date,% M past % H~ would resolve to "12 past 08". See here for a complete list of parameters.

~samp,date~

Returns the creation dates of the samples in a DataSet.

~samp,desc~

Returns the description of the sample.

~samp,effdate~

Returns the effective date of the current sample.

~samp,filter,[filterlabel] ~

Returns the value assigned to the sample filter associated with the sample. This variable replaced the obsolete variable, ~sample,filter,info~.

~samp,impdate~

Returns the import date of the sample.

~samp,index~

Returns the position of the sample as it exists in the Query.

~samp,order~

Returns the number of the Sample’s position based on the order of Samples in the Query.

~samp,seq~

Returns the sequence number of the sample.

~samp,status~

Returns the status of the sample:

• Active - Loaded from database, displayed and used in statistical calculations.

• Masked - Loaded from database and displayed, but not used in statistical calculations.

• Missing - No data exists.

• Hidden - Data exists, but is not loaded from database.

• Archived - Not loaded from database and will be archived.

~samp,subgroup~

Returns the subgroup label.

~samp,subgroupseq~

Returns the sequence order within the subgroup.

~samp,type~

Returns the sample type: Var, HVD, or Mix.

~samp~

Returns the label of the current sample. This is the same as ~samp,label~. When a Sample [Parameter] is appended to any sample variables, the DataSet results will be overridden and the sample signified by the sample paramter will be returned.

~sampdatecount~

Returns the amount of unique dates in a row.

~sampdateordered~

If the samples are ordered by date, this variable returns the value 'Yes'. If the samples are not ordered by date, this variable returns the value 'No'.

~sample,label~

Returns the sample label. This is the same as ~samp~ and is the default sample parameter.

~sample,serial~

Returns the serial number of the sample.

~samples~

Number of samples in a DataSet.

~sheet,setcontent~

Builds a table of contents for the SheetSet.

~sheet,setlabel~

Returns the SheetSet label. The total number of sheets will not include the title sheet.

~sheet~

Returns the page number of the current sheet (within a SheetSet). Same as ~page~.

~sheets~

Returns the number sheets in the SheetSet. Same as ~pages~.

~sheetsiftrule~

Returns the sift rule used from the multi-sift.

~siftrule,boxhi~

Box high value

~siftrule,boxlo~

Box low value

~siftrule,conformcount~

Number of conforming values

~siftrule,cp~

Capability Process

~siftrule,cpk~

Capability Process Index

~siftrule,cr~

Capability Ratio

~siftrule,hi~

Highest value

~siftrule,invalidcount~

Number of invalid values

~siftrule,iqr~

Inter quartile range

~siftrule,lif~

Lower inner fence value

~siftrule,lo~

Lowest value

~siftrule,lof~

Lower outer fence value

~siftrule,lowerlimit~

Lower Limit

~siftrule,mean~

Mean value

~siftrule,median~

Median value

~siftrule,nonconformcount~

Number of nonconforming values

~siftrule,nospeccount~

Number of valid values that do not have a specification limit

~siftrule,nospeccount2~

Number of valid values that do not have a specification limit 2.

~siftrule,outofspeccount~

Number of valid values that are out of specification.

~siftrule,outofspeccount2~

Number of valid values that are out of specification 2.

~siftrule,percentconform~

Percentage of conforming values

~siftrule,percentinvalid~

Percentage of invalid values

~siftrule,percentnonconform~

Percentage of nonconforming values

~siftrule,percentvalid~

Percentage of valid values

~siftrule,pp~

Process Performance

~siftrule,ppk~

Process Performance Indext

~siftrule,pr~

Process Ratio

~siftrule,q1~

Quartile one value

~siftrule,q3~

Quartile three

~siftrule,range~

Range value

~siftrule,rowcount~

Number of rows

~siftrule,stddev~

Standard Deviation

~siftrule,sum~

Sum value

~siftrule,totalcount~

Number of values

~siftrule,uif~

Upper inner fence value

~siftrule,uof~

Upper outer fence value

~siftrule,upperlimit~

Upper Limit

~siftrule~

Returns various summary statistics on data in a DataSet that is associated with a particular Sift Rule. When a Sift Rule variable is used with two parameters, the calculation is done only for the Sift Rule that is specified by the first parameter. The second parameter is the statistic that will be calculated on the data included in the Sift Rule specified by the first parameter. The first parameter can be specified using one of the following options:
Number of Sift Rule - the integer that indicates the position of Sift Rule in the list, as it appears in the Multiple Sift Rules dialog.
Label of Sift Rule - label of Sift Rule.
When the variable is used with the Evaluation/SiftRule Variable DataStack type, the first parameter is not used.

~siftruletype~

Returns "multiple" or "single".

~skewness~

Measure of symmetry of distribution 

~statsmode~

Returns the name of the applied Statistics Rule:
ATS (Default)
Ford
Saab
Volvo Cars

~stddev,e~

Returns the estimated standard deviation 

~stddev,t~

Returns the standard deviation target 

~stddev~

Returns the calculated standard deviation of a DataSet row 

~subgroup~

Returns the subgroup size.

~sum~

Sum (accumulation) of all valid values within a DataSet row 

T

~tally,[param]~

Requires a DataStack as the DataSource. Tally looks at every cell of every DataSet in a DataStack and checks to see if the values are within Spec Limits. The ~tally~ variables are very similar to the ~grade~ variables. The tally variables are limited in their functionality, as they cannot calculate certain limits (e.g. cannot be used with Spec Limit 2). Because of such limitations, the following equivalents are the preferred variables to use:
In place of ~tally,total~, use ~dataset,validcount~.
In place of ~tally,count~, use ~dataset,outofspeccount~.

~tally,count~

Returns the number of cells of the DataSets that are within Spec Limits.

~tally,percent~

Returns the percent of valid values in the DataSets (count divided by total). Percent is rounded to nearest integer (no % sign).

~tally,total~

Returns the total number of valid cells in the DataSets.

~target~

Returns the nominal value adjusted for value type (i.e. is 0 for deviation). This value is usually between spec limits, but may not be as in the case of unilateral or odd limits such as +1 to -2.

~this~

Used to perform calculations on a single cell. See the topic Expression Evaluator for more information on expressions.
If used in a table {~this~*2} would multiply the value of a cell by two, and display that value in the cell.

~time~

Returns the current time. Additional Date/Time parameters may be added to this variable to specify specific information to display, or some particular format. See here for a complete list of parameters.

~totalcount~

Number of values in DataSet row (i.e., the sum of conform, non-conform, and non valid) 

~transformtype~

Returns the transform type used in the statistics, No Transform, Square of X Transform, Square-root of X Transform, -1 / Square-root of X Transform, Cube of X Transform, Log of X Transform, -1 * X Transform, or -1 / X Transform.

~trupos,ang~

Returns the true position angle.

~trupos,rad~

Returns the true position radius.

~trupos~

Returns the true position value. Requires a point with a vector as the true position plane will be determined by the primary direction of vector.

U

~ucl,[char],[param] ~

~ucl~

Upper control limit. The upper control limit for control charts. See the description of ~lcl~ for more details on control limits.

~ucl2,[char],[param] ~

~ucl2~

Upper control limit 2. See ~ucl~.

~uclma,[char],[param] ~

~uclma~

Upper control limit for Moving Average 

~uclmr,[char],[param] ~

~uclmr~

Upper control limit for Moving Range 

~uclr,[char],[param] ~

~uclr~

Upper control limit for Range 

~ucls,[char],[param] ~

~ucls~

Upper control limit for Standard Deviation 

~uclxbr,[char],[param] ~

~uclxbr~

Upper control limit for Xbar with Range 

~uclxbs,[char],[param] ~

~uclxbs~

Upper control limit for Xbar with Standard Deviation 

~uclxmr,[char],[param] ~

~uclxmr~

Upper control limit for X with Moving Range 

~uif~

Upper Inner Fence (q3 + 1.5 * iqr) 

~uof~

Upper Outer Fence (q3 + 3.0 * iqr) 

~url~

Upper reasonable limit. For more information about reasonable limits see the topic Reasonable Limits.

~urt~

Upper reasonable tolerance.

~userfour~

Returns the value of the User Four user-defined row variable.

~userfourstr~

Returns the value of the User Four user-defined row variable as a formatted string.

~userone~

Returns the value of the User One user-defined row variable.

~useronestr~

Returns the value of the User One user-defined row variable as a formatted string.

~userthree~

Returns the value of the User Three user-defined row variable.

~userthreestr~

Returns the value of the User Three user-defined row variable as a formatted string.

~usertwo~

Returns the value of the User Two user-defined row variable.

~usertwostr~

Returns the value of the User Two user-defined row variable as a formatted string.

~usl~

Upper specification limit. The upper engineering limit specified for a measurement. The variable ~usl2~ will return the value of the usl 2 if one has been created. 

~usl2~

Upper specification limit 2. See ~usl~. 

~ut~

Upper tolerance.

~ut2~

Upper tolerance 2.

V

~validcount~

Number of valid values in DataSet row (i.e., the sum of conform and non-conform) 

~variance~

Returns the variance value of a DataSet row. In a population of samples, the variance value is the mean of the squares of the difference between the respective samples and their mean. Basically, it is the measure of the spread of data, or the standard deviation, squared 

~version,doc~

Returns the version of CM4D the document has been last saved in.

~version~

Returns the version of CM4D currently being run.