Program Settings - MDE

The access level for each staff member to the Manual Data Entry application.

n

• 0 - no access
• 1 - read only access
• 2 - read/write access
• 3 - read/write/delete access.

If enabled, then the user can change the status of a particular analyte of a sample to Ignore.

Enabled | Disabled

Enabled | Disabled

If enabled, then extra empty columns appears on the F1Book.

If disabled, then the same amount of columns as there are analytes appears on the F1Book.

Where no empty columns are needed for custom calculations beyond the amount of analytes, then the AllowTrailers setting is typically set to disabled. The look of the F1Book is comparable to a Microsoft Excel™ spreadsheet, in that, if AllowTrailers is set to enabled, then empty columns beyond the amount of analytes are allowed.

Enabled | Disabled

If enabled, then the user can unlock a particular analyte of a sample when it was previously set to Listed Not Received (LNR), Insufficient Sample (IS) or Not Analysed (NA).

Enabled | Disabled

If enabled, then the user can validate a particular analyte of a sample, which will change the status from Not Validated (NVL) to Complete (CPL).

Enabled | Disabled

AlphaNumericMode

If enabled, then alphanumeric data can 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.

Enabled | Disabled

The comma-delimited list of analyte locked statuses.

If a cell has a status that is in the list of AnalyteLockedStatuses, then the cell is locked for non-level 3 users.

CPL | IGN | NVL | NA | IS | LNR | OWH | OWL | OFT | OFL | OFT, or a comma-delimited list of these analyte statuses.

If enabled, then formula cells are locked automatically so that users cannot overwrite the formula accidentally.

Enabled | Disabled

If this VBS file exists in the MDEScripts folder, then the script is invoked after loading the sheet. Use double quotes around a filename to allow for embedded spaces in the filename.

{VBScriptFile}.VBS

If this VBS file exists in the MDEScripts folder, then the script is invoked after saving the sheet. Use double quotes around a filename to allow for embedded spaces in the filename.

{VBScriptFile}.VBS

If this VBS file exists in the MDEScripts folder, then the script is invoked before saving the sheet. Use double quotes around a filename to allow for embedded spaces in the filename.

{VBScriptFile}.VBS

If enabled, then the BCScriptFile is run to allow for the reading of a barcode.

Enabled | Disabled

If this VBS file exists in the Config folder, then the script is invoked by the Data Entry jobs browser so that a bar code reader can be used to enter the job number. Use double quotes around a filename to allow for embedded spaces in the filename.

{FileName}

If this VBS file exists in the Config folder, then the script is invoked by the Data Entry jobs browser so that a bar code reader can be used to enter the job number. Use double quotes around a filename to allow for embedded spaces in the filename.

{ASCII character}

The database view used to filter data.

{DatabaseViewName}

If enabled, then only unknown samples are checked that their analytical results are in the correct range.

Enabled | Disabled

If enabled, then an error displays if the weight is outside of the allowable weight range for the scheme.

Enabled | Disabled

When a range of cells on the spreadsheet is selected and unlock requested:

• If enabled, then all cells in the range are unlocked and have their analyte statuses cleared.
• If disabled, then only cells with a NA, LNR or IS analyte status in the range are unlocked and have their analyte statuses cleared.

Enabled | Disabled

When cells are set to a NA, LNR or IS analyte status:

• If enabled, then the date analysed is cleared.
• If disabled, then the date analysed is retained.

Enabled | Disabled

When cells are set to a NA, LNR or IS analyte status:

• If enabled, then the date started is cleared.
• If disabled, then the date started is retained.

Enabled | Disabled

Only applied if LoadBrowser is enabled.

The list of criteria used to select records for the browse display. Each criterion is defined by a name and a SQL clause used to filter the records. Only one criteria can be active at a time.

These criteria and the default criteria used are editable in the application as well as via the Staff application. If modified in the application and staff settings are present only for CCLASMGR, then they are copied into the individual user’s staff settings.

{CriteriaName},{SQLStatement}

Only applied if LoadBrowser is enabled.

The list of criteria used to select records for the browse display. Each criterion is defined by a name and a SQL clause used to filter the records. Only one criteria can be active at a time.

These criteria and the default criteria used are editable in the application as well as via the Staff application. If modified in the application and staff settings are present only for CCLASMGR, then they are copied into the individual user’s staff settings.

{CriteriaName},{SQLStatement}

Only applied if LoadBrowser is enabled.

The list of criteria used to select records for the browse display. Each criterion is defined by a name and a SQL clause used to filter the records. Only one criteria can be active at a time.

These criteria and the default criteria used are editable in the application as well as via the Staff application. If modified in the application and staff settings are present only for CCLASMGR, then they are copied into the individual user’s staff settings.

{CriteriaName},{SQLStatement}

Only applied if LoadBrowser is enabled.

The list of criteria used to select records for the browse display. Each criterion is defined by a name and a SQL clause used to filter the records. Only one criteria can be active at a time.

These criteria and the default criteria used are editable in the application as well as via the Staff application. If modified in the application and staff settings are present only for CCLASMGR, then they are copied into the individual user’s staff settings.

{CriteriaName},{SQLStatement}

The number of the current criterion.

The number of the current criterion.

The number of the current criterion.

The number of the current criterion.

n

The background colour used when displaying a date cell.

{Colour}

The style in which XMDE opens, the grid display arranges:

• 1 = Samples vertically and analytes horizontally.
• 2 = Samples horizontally and are vertically.

The colour used to display a cell where there a results exists that falls below the determination limit.

{Colour}

The columns of sample details in the spreadsheet when the default spreadsheet style is used.

The columns of sample details in the spreadsheet when the analytes-each-row spreadsheet style is used.

If enabled, when a job is opened, then all scheme and analyte nodes are expanded on the spreadsheet.

Enabled | Disabled

The number of rows that are added to the bottom of the F1Book spreadsheet.

The background colour used for a cell that contains a formula.

{Colour}

The background colour used for a cell that contains an ignored failure on a QC sample.

{Colour}

The VBScript run when a quality control sample's result is ignored. Use double quotes around a filename to allow for embedded spaces in the filename.

Example: %CCLASRootDirectory%MDEScripts\QCIgnore.VBS

{VBScriptFile}.VBS

When the user is presented with a list of instrument for data capture in a Data Entry session:

• If defined, then the list is populated with the defined instruments. The Filename is the IFF for the instrument communication.
• If not defined, then the list is populated with all instruments that have IFF files in the IFFScripts folder.

{InstrumentName}, {FileName}

If enabled, then the tree display begins at client, and branches down to project and job level.

If disabled, then the tree display only contains the job level.

Enabled | Disabled

If enabled, then the list of clients, or the list of jobs (depending upon the ListViewByClient) application setting), appears in the viewing pane of the Data Entry application.

If disabled, then clients or jobs are populated in the viewing pane of the Data Etnry application using the criteria established in the MDEUserQuery.SCR query screen file, located in the directory defined by the Config Directory global setting.

Enabled | Disabled

When a cell containing locked data displays, theis background colour is used.

{Colour}

The columns of details (fields from the PROFJOB and PROFJOBUSER tables) displayed in the browse frame of this application.

{FieldName},Width,{ColumnHeading}[,{Picture}]

If enabled, then browser display in this application uses a grid.

Enabled | Disabled

The columns of details displayed on the Samples tab of the Open Job screen.

{FieldName},Width,{ColumnHeading}[,{Picture}]

When the user accesses the list of Data Entry commands using the Command menu option, then the list is populated with the defined scripts. Use double quotes around a file name to allow for embedded spaces in the name.

{ScriptName},{VBScriptFile}.VBS

The screens or scripts available for running from the Run menu option when the Jobs node is selected on the main Data Entry screen.

{ScriptName},{VBScriptFile}.VBS|SCR

The background colour used when displaying a cell where there is an LNR, NA or IS status.

{Colour}

When more than one scheme is selected for opening in the Data Entry application:

• If enabled, then the Include QC check box is unchecked.
• If disabled, then the Include QC check box remains checked.

Enabled | Disabled

The background colour used when displaying a cell containing a non-validated result.

{Colour}

The page footer printed on a Data Entry report page. Headers and footers can contain text and special formatting codes.

• &L = Left-aligns the characters that follow
• &C = Centres the characters that follow
• &R = Right-aligns the characters that follow
• &D = Prints the current date
• &T = Prints the current time
• &F = Prints the worksheet name
• &P = Prints the page number
• &P+number = Prints the page number plus number
• &P-number = Prints the page number minus number
• && = Prints an ampersand
• &N = Prints the total number of pages in the document
• Codes and text are, by default, centered unless &L or &R is specified.
• The following font codes must appear before other codes and text or they are ignored.
• The alignment codes (e.g., &L, &C, and &R) restart each section; new font codes can be specified after an alignment code.
• &B = Use a bold font
• &I = Use an italic font
• &U = Underline the header
• &S = Strikeout the header
• &O = Ignored
• &H = Ignored
• &<FontName> = Use the specified font
• &nn = Use the specified font size - must be a two digit number.

{FormatCode}

The page header printed on a Data Entry report page. Headers and footers can contain text and special formatting codes.

• &L = Left-aligns the characters that follow
• &C = Centres the characters that follow
• &R = Right-aligns the characters that follow
• &D = Prints the current date
• &T = Prints the current time
• &F = Prints the worksheet name
• &P = Prints the page number
• &P+number = Prints the page number plus number
• &P-number = Prints the page number minus number
• && = Prints an ampersand
• &N = Prints the total number of pages in the document
• Codes and text are, by default, centered unless &L or &R is specified.
• The following font codes must appear before other codes and text or they are ignored.
• The alignment codes (e.g., &L, &C, and &R) restart each section; new font codes can be specified after an alignment code.
• &B = Use a bold font
• &I = Use an italic font
• &U = Underline the header
• &S = Strikeout the header
• &O = Ignored
• &H = Ignored
• &<FontName> = Use the specified font
• &nn = Use the specified font size - must be a two digit number.

{FormatCode}

The margin on the bottom of the page.

The footer margin.

The header margin.

The margin on the left-hand side of the page.

The margin on the right-hand side of the page.

The margin at the top of the page.

If enabled, then column headings are printed.

Enabled | Disabled

If enabled, then grid lines are printed on the page.

Enabled | Disabled

If enabled, then row headings are printed.

Enabled | Disabled

If enabled, then the report is printed in landscape format.

Enabled | Disabled

The background colour used when displaying the first line of QC details for a sample.

{Colour}

The background colour used when displaying the second line of QC details for a sample.

{Colour}

The background colour used when displaying the third line of QC details for a sample.

{Colour}

The background colour used when displaying a cell containing a QC sample that has failed the action limits.

{Colour}

The colour of the font used to display a QC sample value.

{Colour}

The background colour used when displaying a cell containing a QC sample that has failed the warning limit.

{Colour}

The command within the MDEUserQuery.SCR file that is executed to return a list of jobs. Only active if the LoadBrowser setting is disabled.

Example: cmdQuery_Click

{EventName}

If enabled, when raw results are being entered for one scheme and analyte, the Raw final mode check box is checked.

Enabled | Disabled

{FileName}

If enabled, then cross-scheme calculations are automatically performed.

Enabled | Disabled

If set to R, then the Raw results mode option is the default selection.

If set to F, then the Final results mode option is the default selection.

R | F

If enabled, then on mouse-over of a quality control standard, blank or spike sample analyte, the expected value displays, and on the mouse-over of a replicate, duplicate, reread or unknown sample analyte, the product limits are displayed.

Enabled | Disabled

If enabled, then the content of the TipOfTheDayFile displays on application on start up.

If disabled, then no tip of the day displays.

Enabled | Disabled

The colour used to display a cell containing an OLE data type.

{Colour}

The columns of project details for clients displayed in the browse frame of the Data Entry application.

Only applicable if ListViewByClient is enabled.

The columns of job details for projects of clients displayed in the browse frame of the Data Entry application.

Only applicable if ListViewByClient is enabled.

{FieldName},Width,{ColumnHeading}[,{Picture}]

If enabled, then old formula names are supported.

Enabled | Disabled

The name of the file containing the current tip of the day for the application.

Example: %CCLASRootDirectory%Tip\MDE.TIP

{FileName}

If enabled, then only locked cells is unlocked when a range of cells on the spreadsheet is selected to be unlocked.

Enabled | Disabled

If enabled, then the job status is automatically updated when the analytical data for the job is saved.

Enabled | Disabled

If enabled, then the job status is automatically updated when the analytical data for the job is saved.

Enabled | Disabled

{FormHeading}, {ScriptName},{VBScriptFile}.VBS|SCR

If enabled, then the short name of the analyte appears on the Scheme-Analyte selection screen when opening a job.

If disabled, then the analyte code appears on the Scheme-Analyte selection screen when opening a job.

Enabled | Disabled

The VBS file run when a quality control sample's result is validated. Use double quotes around a filename to allow for embedded spaces in the filename.

Example: %CCLASRootDirectory%MDEScripts\QCValidate.VBS

{ScriptName},{VBScriptFile}.VBS

If enabled, then sample weights and volumes are used to automatically correct data collected from an instrument.

Enabled | Disabled