List of data entry commands

Command Comments Related clsSheet Object - Properties and Methods

AL[PHANUMERICMODE] ENABLED|DISABLED

If ENABLED, allows alphanumeric data to be entered into any cell. If DISABLED, alphanumeric data can only be entered into cells where the data type of the analyte is date, OLE or string.

AlphaNumericMode True|False

AV[ERAGE] nCol[:nColTo] [Sampletypes]

To perform row based averaging of replicate, duplicate and unknown samples to the unknown sample. Sampletypes can be combinations of D, R and U. If Sampletypes are omitted, defaults to DR, i.e., all duplicates and replicates.

Example: AVG 1:4 DR

Average (nCol, [nColTo], [Sampletypes])

BY[E] [/NEXT]

To exit the job and return to the Data Entry main window. If /NEXT is supplied, this automatically reopens the dialog box to select the next scheme for data entry.

Bye()

CE[LLTIPS] ENABLED|DISABLED

If ENABLED, on mouse-over of a quality control STD/BLK/SPK sample analyte, the expected value displays, on mouse-over of a REP/DUP/RRD/UNK sample analyte, the product limits are displayed.

ShowCellTips True|False

CH[IDE] nCol[Namedcol]

To hide a column from display.

ColHide (nCol)

CHKU[NK] ENABLED|DISABLED

If enabled, only unknown samples will have their analytical results checked to see if they are within the correct range. The default for this is defined by the CheckUNKOnly Data Entry program setting.

CheckUNKOnly True|False

CLRV[ARS]

To clear all defined variables from memory.

ClrVariables ()

CO[L] nCol

To move to the defined column in the same row. Note that if Locked sample columns is checked, you cannot move to columns 1 - 4. Note that by default, column 1, containing the sample Cuid, is hidden.

Col (nCol)

CS[HOW] nCol[Namedcol]

To show the defined column.

ColUnHide (nCol)

DE[BUG]|DB Varname

To display a variable value.

MsgBox GetVaraible (Varname)

DELV[AR] Varname

To delete a memory variable.

DelVariable (Varname)

ED[IT] [ScriptFilename]

To edit a script file. If no path name is given, it are assumed to be in the folder defined by the MDEScriptsDirectory global setting. (NB, not available for an access level less than 3.) Use double quotes around a file name to allow for embedded spaces in the file name.

Edit (ScriptFilename)

FI[ND] [/nCol] Value

To find a particular value, optionally for a given column.

Find (Value, [nCol])

FNDV[AR] [/nCol] Varname

To find the contents of a particular variable, optionally for a given column.

Find (GetVariable (Varname, [nCol])

FO[RM] [ScreenFormFilename]

To load a screen using a screen file. Use double quotes around a file name to allow for embedded spaces in the file name.

ShowScreen (ScreenFormFilename)

HI[DE]

To hide the workbook.

Hide ()

INP[VAR] Varname [Title]

To prompt the user for a specific variable value.

InputVariable(Varname, ,[Title],,,)

INS[TRUMENT] Instcode

To define an instrument for logging data from.

Instrument(Instcode)

IOFF

To stop data capture from an instrument.

StopInstrument ()

ION

To start data capture from an instrument.

StartInstrument()

IR[EWIND]

To rewind a data file to the beginning.

RewindInstrument()

LETV[AR] Varname [Value]

To let a variable equal contents of cells or a particular value.

LetVariable(Varname, [Value])

ME[DIAN] nCol[:nColTo] [Sampletypes]

Calculate median.

Median(nCol, [nColTo], [Sampletype])

MO[DE] [Weight|Raw|Final]

Set or return the data entry mode as either Weight, Raw, or Final.

ResultType

MS[GBOX] Message

To pop up a message box.

MsgBox Message

NE[XT] [Sch]|[Sch:Ana1,...Anan]| [Job:Sch:Ana]| [Job:Sch:Ana1,...Anan]

To load the workbook for the next optional job, scheme and analyte(s).

LoadSheet ()

PA[GESIZE] nPagesize

To set or return the page size.

PageSize

PL[AY] WAVFilename, [nTimes]

To play a WAV sound file. Use double quotes around a file name to allows for embedded spaces in the file name.

Play(WAVFilename, [nTimes])

QC[TREND] [nMaxRecords]

To perform quality control trend analysis for the current rack, and a history of the past nMaxRecords.

QC n

QU[IT]

To quit from the Data Entry session.

Quit()

RA[CK] [nRackFrom] [nRackTo]

To load to another rack.

RackFrom nRackFrom
RackTo nRackTo
LoadSheet()

RC nRow nCol

To move to a particular row and column.

RowCol(nRow, nCol)

REG nCol1 nCol2

To perform linear regression.

LinearRegression(nCol1, nCol2)

REPORT [Qualifiers]

To create a Data Entry report, where valid qualifiers are:

  • /CF (CUIDFormula)
  • /F (Formula)
  • /FV (FormattedValue)
  • /LBC (LBatchCUID)
  • /LBJ (LBatchJob)
  • /P[RINT] (Print)
  • /PS (PrecStatus)
  • /Q[C] (Quality Control)
  • /RV (RawValue)
  • /S[TATUS] (Status)
  • /U1 (Userfield1)
  • /U2 (Userfield2)
  • /U3 (Userfield3)
  • /U4 (Userfield4)
  • /U5 (Userfield5)
  • /V (Volume)
  • /W (Weight)
  • /{Any clsCUIDSchemeAnalyte property}

For example: REP/MinValue creates a report based on this property.

Report(Qualifiers)

RH[IDE] nRow

To hide a row from display.

RowHide(nRow)

RO[W] nRow

To move to the defined row in the same column.

Row(nRow)

RSD nCol1[:nColTo] [Sampletypes]

To calculate relative standard deviation.

RSD(nCol1, [nCol2], [Sampletypes])

RS[HOW] nRow

To show the defined row.

RowUnHide(nRow)

RUN [ScriptFilename]

To run a VBScript command file. These files are usually located in the folder defined by the MDEScriptsDirectory global setting. Use double quotes around a file name to allows for embedded spaces in the file name.

Run(ScriptFilename)

SA[VE]

To save the content of the workbook.

Save()

SETV[AR] Varname

To set a variable in memory.

SetVar(Varname)

SH[OW]

To show a workbook.

Show()

STD nCol[:nColTo] [Sampletypes]

To calculate standard deviation.

StdDeviation(nCol, [nColTo], [Sampletypes])

TO[NE] [nTimes]

To play a tone a defined number of times.

Tone([nTimes])

TR[ANSFER] Sampletype[=nOccur] nColFrom nColTo

To transfer data from one column to another.

Transfer(Sampletype, nColFrom, nColTo, [nOccur])

VS[ET] Value

To set a cell to a particular value.

SetValue(Value)