General Information

QWAdmin Help Files

Application Template Name

This is the description that will be displayed on the Begin screen of QW or any time you are prompted to select from a list of the available applications.  

 

Number of Variables to Lock

The number of variables that you wish to lock in position on the left side of the Logsheet as you scroll to the right.  The default value is 2 which will lock the first two variables, Date and Time.  The maximum number of variables you can lock is determined by the Length of the longest variable in your application.  The longest variable must be able to fit on the screen with the locked variables.  If it does not QW defaults to Date and Time.

 

Number of Historical Data Points

Indicates how many  historical records should be loaded each time the application is selected from the Begin screen.  This can be from 0 to 100 records.  QW will always load the historical points starting with the most recent information in the data file back in time the number of data points set in this field.

 

In a process monitoring application where the use of statistics is important, the number of points should be set high to increase the value of the statistics calculated for each variable.

 

For an attribute or event analysis application, where statistics are not as important, you can set the value lower.  You should consider the value of the operator seeing recent entries, say the last or current shift.

 

Chart Screen Options

 

Control Chart X-Axis Variable

The Variable Reference number, V##, for the template variable that 

you want to be displayed as the X-axis on the bottom of the Control Chart on the Chart and Relationship screen, as well as the legend on the Summary screen.

 

You can use any variable for this purpose but QW will only display  the first five characters of the variable selected for the X-axis  field on the Control Chart.

 

To select a variable for the X-axis press the Enter key while positioned in this field.  A popup window of all  the variables available in the application will be displayed.  Use the Up/Down arrow keys to position the highlighted bar on the variable to be selected and press the Enter key.

 

The default selection is V2 - Time.

 

Annotated Field 1: included in Positional Cursor Information Box

The Variable Reference number,  V##,   for the template variable that you want to be displayed on the Chart and Relationship screens under the X-axis of the Control Chart and just to the left of the value of a data point.

 

The display length for this variable is 40 characters.  It should be noted that this field may overwrite the word "Histogram" if it is over 20 characters in length.

 

It is called an annotated field because the value of the field will change as the cursor bar is moved using the left and right arrow keys on the Chart screen.

 

To select a variable for Annotated Field 1 press the Enter key while positioned in this field.  A popup window of all the variables available in the application will be displayed.  Use the Up/Down arrow keys to position the highlighted bar on the variable to be selected and press the Enter key.

 

The default selection is V1 - Date.

 

You should set this field with the X-axis variable in mind.  One should compliment the other.  Such as, if the x-axis is set to V2 (time) then this field might best be set to date or if the x-axis is set to the date this field might be best used to display a process batch number.

 

Annotated Field 2: (above top right corner of control chart)

The Variable Reference number, V##, for the template variable that you want to be displayed in the top right corner of the Chart and Relationship screens.  

 

It is called an annotated field because the value in the field will change as the cursor bar is moved using the left and right arrow keys.

 

To select a variable for Annotated Field 2 press the Enter key while positioned in this field.  A popup window of all the variables available in the application will be displayed.  Use the Up/Down arrow keys to position the highlighted bar on the variable to be selected and press the Enter key.

 

We would suggest that each QW application template include a variable where comments from the operator can be entered.  You should set this annotated field to the variable id number for the comment field and encourage comments relevant to each entry or record.  These comments can be very useful in understanding  the nature of problems detected and what actions were taken to correct the problem.

 

Add Screen Options

 

Batch File to Execute

A DOS batch file or command line entry that you can  specify to be executed before the Add function.  This batch file can be used to execute other programs that can obtain information from other systems or access data from measuring devices. 

 

Once this data has been obtained and ordered in a QW Variable Input File it is then available to be displayed on the Add screen as a default value.  This can decrease the time to manually enter data as well as increase the accuracy of the data into a QW application.  

 

Once the batch file processing is complete QW will be re-activate the Add screen with any values obtained as default data.

 

You can specify the Batch filename to execute with full disk drive and path support or a command line entry. 

 

Example: C:\UTILITY\SCALE.BAT

 

Transaction Audit Trail

You have the option of having Quality Window keep track of each time a record or entry is added, edited, inserted, copied or deleted from an application and also execute a DOS batch file after the transaction has been recorded.

 

The following three examples show how you could use this option:

 

Where it is required by law that a complete audit trail of all data recorded be maintained.

 

As a backup facility to recover an application data file that has been damaged or lost.

 

As a creator of a transaction file used to update an off-line system.

 

Log Filename to Update

the name of the file to which Quality Window will store all activity for an application - additions, changes and deletions. 

 

QW stores this data in ASCII comma delimited format that matches the order and format of the variables as defined in QWAdmin.  The current value of each variable is stored in this file whether it has changed or not.  At the end of each record there is additional information indicating the application template name the data is from, the date and time the activity occurred and the type of transaction (Add, Edit, Delete or Update). 

 

There is full disk drive and path support for the filename.

 

Example F:\AUDITS\PROCESS.LOG

 

The name of the file must meet DOS file name restrictions, maximum of 8 characters in length, no special characters and a three character extension.

 

 

We would suggest using the application template name and an extension of .LOG for easy identification.

 

Batch File to Execute

a DOS batch file or command line entry that you can specify to be executed after the <Insert> key is pressed to save data in the Add or Edit screens and after a record has been deleted using the delete option on the Log Sheet screen.

 

This batch file will be executed after the Log file, if specified, has been updated.

 

This batch file or command line entry can be used to perform any procedure that must be performed after the data file has been updated.  This can be sending the transaction log to a mainframe computer to update an off line system.  It can also be used to perform cleanup routines like copying or deleting files.

 

Before the Batch File is executed QW will first store itself in upper memory, if available, or temporarily on the harddisk under the name QWSWAP.FIL.  This is done to free up memory for the Batch File to use. If there is not a need to free up memory for the Batch file and also eliminate the time QW needs to store itself you can use the SET QWSHELL=N command.  Refer to the QW Getting Started Manual under the section Customizing Your QW Environment for details.

 

You can specify this batch file with full disk drive and path support or as a command line entry. 

 

Example: C:\QWAPPLIC\UPDATE.BAT

 

Variable Used to Store AutoNumber

 

 This setting is useful when a unique identifier is needed for each record in order to make synchronizing with an outside database more efficient. 

 

This variable is typically a Protected and Numeric.

 

Security Options

 

Security Turned On For

Limits access to application templates as well as what a user can access while in an application template.

 

Security Level

Description

Template

the user is prompted for their Userid and Password when the template is accessed from the Begin screen

Add

the user is prompted for their Userid and Password when the Add screen is accessed 

Edit 

the user is prompted for their Userid and Password when the Edit screen is accessed 

Delete

the user is prompted for their Userid and Password when the Delete function is clicked

Insert

the user is prompted for their Userid and Password when the Insert function is clicked

Copy

the user is prompted for their Userid and Password when the Copy function is clicked

        

Variable Used to Store Security Info

The optional template variable that can be used to store the users name as entered on the QWAdmin - SECURITY data screen. 

 

The variable must already have been defined in the template.

 

Limit Method Criteria

 

The Limit Method Criteria is used only for variables whose limits are calculated based on:

 

  • Moving Range Estimate, Low Variation, High Variation, Low Average, High Average

 

Variables with limits calculated based on population are not subject to the Limit Method Criteria.

 

The Limit Method Criteria takes into account the percentage of the data population as well as the minimum and maximum number of data points to use.

 

Example:

 

Total

Points

 Percent

Minimum

Maximum

Limits will be

Based On

350

10 (35 Points)

30

40

35 points

500

10(50 points)

30

40

40 points

100

10(20 points)

30

40

30 points