Introduction

QGAGE is a software for companies that are interested in taking a good control of their measurements instruments as well as keep in good condition their measurement system.

Calculations and studies included in this program are based on the Measurement System Analysis, Fourth Edition, published by Daimler Chrysler Corp., Ford Motor Company and General Motors Corp. Meets the requirements of ISO / TS 16949 to carry out studies of Repeatability and Reproducibility, Linearity, Stability and Bias; as well as for the Calculation of uncertainty.

QGAGE allows to:

QGAGE is a friendly system that maintains the standards of Windows 7, so that the user who has had contact with any application developed on Windows 7 and MS Excel, MS Word, etc., can quickly learn how to use this program.

How to use this manual

This manual is not designed to be read from start to finish but rather to quickly provide you with the information you need. If for any reason you find this is not the case, please send us an e-mail at: soporte@wilsoftap.com. We strive to provide the best possible service and would be delighted to receive any suggestions you may have for improving the product. Whether or not you are a user with QGAGE experience, your feedback on the manual would be very much appreciated, given that this new version includes important changes.

Assumptions

This manual assumes that you have a basic knowledge of Windows Vista or later versions of Windows. This knowledge includes use of menus, dialogue boxes, mouses, and so on. If you are unfamiliar with these operations, consult your manual for Microsoft Windows Vista (or later version of Windows).

Technical support

If you are already a customer and require technical support, contact us at

Ø  Tel. : +1 210 449 2756

Ø  E-mail:support@wilsoftapp.com

Wilsoft on the Internet

The latest information on Wilsoft and its products can be found on our website: www.wilsoftapp.com


 

Chapter 1: How to Start

The following instructions will tell you how to start the application quickly and easily, allowing you to evaluate the main functionalities.

To run QGAGE, type in the internet browser the link where the application was installed. At the login, QGAGE asks for a username and password. The user must be registered by a user with an Admin role. See Users later in the Utilities chapter

 

Upon entering, a window opens with the reminder of the user's pending actions which can be:

- Scheduled calibrations.

- Programmed studies of M.S.A.

- Scheduled events.

- Expiration of masters.

- Pending approvals.

 

Environment

On the main screen the instruments in a browser view are shown. The left side shows a tree with folders or groups of the company, and in the right side the instruments of the selected group are shown.

 

Group

User

Tab

Application button

At the top of the screen is the ribbon.

 

 

 

 

 

Sections of the ribbon:

  1. Start
    1. Management
      1. Intrument Types: Allows managing instrument types.
      2. Masters: Allows managing masters.
      3. Labels: Allows managing label designs.
      4. Suppliers: Allows managing suppliers.
      5. Event types: Allows managing event types.
      6. Events: Allows managing events.
    1. M.S.A.
      1. Variable R&R: Allows managing R&R studies by variable.
      2. Attribute R&R: Allows managing R&R studies by attribute.
      3. Bias: Allows managing bias studies.
      4. Linearity: Allows managing linearity studies.
      5. Stability: Allows managing stability studies.
      6. Calibrations: Allows managing calibrations.
    2. Tools
      1. Master List: Displays a master list of the instruments.
      2. Calendar: Shows pending actions in calendar form.
      3. Dashboard: Displays system indicators on dashboards.
      4. Suite: Switch between Wilsoft applications.
  1. Reports
    1. Instruments
      1. Inventory: Displays a list of instruments.
      2. Out of place: Displays the instruments that are not on its location.
      3. By group: Displays the instruments ordered by group.
    2. Schedule
      1. Masters expiration: Displays a report of masters with expiration date.
      2. Event: Displays a report of scheduled events.
      3. R&R: Display a report of scheduled R&R studies.
      4. Bias: Displays a report of scheduled Bias studies.
      5. Linearity: Displays a report of scheduled Linearity studies.
      6. Stability: Displays a report of scheduled Stability studies.
      7. Calibration: Displays a report of scheduled calibrations.
    3. Admin
      1. Custom: Allows adding new custom reports (it is necessary to contact technical support)
      2. Email: Displays a report with the emails sent by the application.
      3. Tracking: Displays a report detailing the changes made ​​to the system.
  1. Help

a. Documentation

      1. Documents: Custom documents.
      2. Content: Displays the QGAGE index.
      3. Manual: Displays the QGAGE user’s manual.

b. Wilsoft

      1. License: Shows information about licensing.
      2. Web: Links to the Wilsoft website.
      3. About: Displays information on the product version.


  1.  

Chapter 2: Performance

QGAGE functionality it is divided into three stages as follows:

Basic information

This stage consists of entering all the support information, such as the properties of patterns, tools, and instruments.

Measurement System Analysis

The measurement system covers instruments, operators, and measurement methods. It is essential to make a proper analysis of the measurement system before taking any corrective action. Many times when problems occur in the measurement system, it sends the instrument to calibrate, but there are times when the instrument is not causing the problem. Maybe the operators or the method used in the measurement. R&R, bias, linearity and stability studies allow analyzing the measurement system and help to find the improvement actions.

Improvement actions

When a measurement system has a high variation, actions must be taken to reduce it because the measurements become unreliable. Either to calibrate the instrument, train operators, to unify and document the measurement methods, and establish good measurement practices are everyday actions taken to improve the quality of the measurements. It is essential to pay attention to the resulting graphic from the studies to correctly decide what actions to take.

 

Chapter 3: Utilities

This chapter shows how to record roles and users, and also how to configure the system. To access the utilities options, click the   button on the ribbon.

Reminder

Upon starting QGAGEthe Reminder window with calibrations and R&R pending studies, as well as the due patterns, are shown. This option can also be accessed manually from the application menu of the main screen.

Calibrations tab

The list of instruments to be calibrated is displayed. Each item of the list shows the instrument code, instrument description, and scheduled date. If the scheduled date appears in red, it means a delayed calibration. If it appears in yellow, it means that it is right on the day of the scheduling, while if it appears in green, it means there is still time to calibrate

To create the corresponding calibration record, click

Studies tab

The list of instruments with their scheduled studies is displayed. Each item in the list shows the instrument code, the description of the instrument, the study, and the scheduled date. If the date appears in red, it means the study is delayed. If it appears in yellow, it means that it is right on the day of the scheduled study, while if it appears in green, it means that there is still time to carry out the study. The list of instruments that must pass through the R&R study is shown.

To create the corresponding studies record, click

Events tab

 

The tool list, with its events and scheduled services, is displayed. Each item in the list shows the instrument code, the description of the instrument, the type of event, and the scheduled date. If the scheduled date appears in red, it means it is delayed. If it appears in yellow, it means that it is right on the scheduled day, while if it appears in green, it means that there is still time to carry out the event

To create the corresponding event record, click

 

Patterns expiration tab

The list of patterns to be calibrated is displayed. Each item in the list shows the pattern code, the pattern description, and the expiration date. If the expiration date appears in red, it means it is delayed. If it appears in yellow, it means that it is right on the day of expiration, while if it appears in green, it means that there is still time to send to calibrate the pattern.

To update the expiration date of the corresponding pattern, click

Approval Tab

The list of studies to be approved is displayed. Each item in the list shows the instrument code, study, study code, study date. If the study date appears in red, it means it is delayed. If it appears in yellow, it means that it is right on the day of the study.

To approve a study, click

 

Filter option

In every tab, there is a textbox that allows you to filter the list

of records found in the tab. The filter is done by the columns Code

of the instrument and Description of the instrument. To filter the list

1. Type part of the code or description in the Filter text box

2. Click      or press Enter

 

Records will be displayed where the instrument code or description contains the typed text.

 

Send reminders

QGAGE allows sending automatically email alerts to users with pendings in the reminder. These sending are scheduled on the server with the option of scheduled tasks through the instruction

qgage.exe / send-reminders

To send reminders manually click Send reminders in the application menu.

Roles

Roles allow you to group users according to what they do in the system. You can create as many roles as necessary. However, it is very useful to properly analyze the roles which are needed according to the permissions which you are going to assign, since a user can only have one specific role. We recommend that you draft up a list of the groups and users that are going to use the system, in order to facilitate management.

The Admin role cannot be deleted or renamed. Users who are assigned this role can configure the system and have access to the Roles, Users, Configuration, and Group Properties options.

To access the Roles window, click Roles in the Application menu.

 

 

To create a new role

1.    Click New. A record with a default role name appears.

2.    Rename the role.

3.    Click Save.

To edit a role

1.    In the list, click the role that you want to edit.

2.    Rename role in the right side of the window.

3.    Click Save.

To delete a role

1.    Click the delete button to right of the role that you want to delete from the list. The transfer dialog box is displayed. You can see three options:

a.    Delete: This option deletes all related information.

b.    Transfer: This option transfers the related information of the deleted role to another role. For example: If you delete the Supervisor role and want supervisor users to become Managers rather than being deleted, you should choose to transfer the related information from the Supervisor role to the Manager role.

c.     Cancel: This option will abort deletion of the role.

To filter a role

1. Type part of the code or description in the Filter text box

2. Click      or press Enter

Users

Only registered users are able to access QGAGE. To see the list of users, click Users in the Application menu.

 

 

 

The list of users includes the columns:

- Name: Username to enter the system,

- Password: User password,

- Email: User email. It is essential to register the email because of all the notices

They are this way.

- Role: Role of the user.

- Status: Indicates if the user is enabled. Only enabled users

They can enter the application.

 

To create a new user

1. Click New.

2. Enter the user information.

3. Click on Save

 

To import users

1. Click Import

2. Select the medium from which users are going to import

3. Click on Save

 

Import users

QGAGE import users from an Excel file, from a database or from

a VCard file

Import from Excel

The Excel workbook must have a Design sheet with the following data:

- In cell B3 the header row number must be found; that is the row

where the data header appears. The data should appear in the next row

- From row 3, you must indicate the places from which the values ​​of the

fields Column A indicates the name of the sheet where the values ​​are located.

Column B indicates the column where the values ​​are located, and column C contains the name of the field.

Users window displays a master list and the details for the currently selected item:

Name: The username used to log in.

Password: The user's password.

E-mail: The user's email address. This is important, since all notifications are sent out by e-mail.

Role: The user’s role.

For example

 

 

Import from database

A connection string must be provided to the database that contains the users

and an SQL string to extract the information. For this, it is vital to consult the IT staff.

Import from VCard

This option allows you to import users from a VCard file, so you can

import cell phone users, Outlook, and many more.

Among the users, the user Admin is a superuser who can do everything within the system. You can only change the Admin's Email and password. It cannot be deleted.

However, it is allowed to create other Admin role users with any name, which can be deleted.

 

To modify a user's information

1. Click the corresponding .

2. Modify user information. To change the password, click on

Change Password. The Password text box appears. Type the new

password. If you want to reset the previous password click on Keep

Current password.

3. Click on Save.

 

To delete a user

1. Click the  on the user on the list you want to delete. The system asks

what do you want to do about the information related to the user, such as

executions initiated by said user. Three options appear:

a. Delete: This option deletes the related information and cannot be

recover.

b. Transfer: This option transfers related user information to

another user that is selected in the user combo that is deployed.

For example: If you delete User1 and you want the instruments of

This user is not deleted, but instead becomes instruments of the

User2, then you must choose to transfer the related information

from User1 to User2.,

c. Cancel: This option cancels user deletion.

 

To filter the user list

1. Enter a phrase you want to filter in the text box at the bottom

of the window.

2. Click  or press Enter. Users, where the name will be displayed,

contain the typed phrase.

To export the list of users to an Excel file, click on Export Users.

To import users, click on Import users. Users can be imported

since:

- Active Directory.

- Excel workbook. The file must have the format of the tmpUsers.xlsx book.

- Wilsoft application.

 

To obtain a report of the users registered in the system, click on Report.

 

Change of password

Each user when accessing the system can change their password in the option Application Menu Password. To change the password, enter your current password to access the system and then new password you want to do so. When you finish click save.

 

Configuration

The Configuration window allows the user with Admin role to change system parameters.

General Tab

Language: Selecting a language from the Language drop-down list while the interface is displayed in the selected language.

-          Document Folder: All the additional information that is uploaded to the application as files is stored in this folder. It must be a shared folder on the server where the application is installed so that all the computers that use the General Tab

-          Language: When selecting a language from the Language drop-down list, the entire interface is displayed in the selected language.

-          Use online report viewer: Allows you to use the online report viewer.

-          All system reports are issued in Excel. If this option is checked, the reports will be displayed directly in the browser. When the reports are not marked, they are downloaded as Excel files, which can be opened in the Windows downloads folder.

-          To save the changes, click on Save.

Prefixes tab

In the different windows of the application where codes are used, automatic codes are generated when a new record is created. These codes are composed of a prefix and consecutive number. This tab establishes the prefixes used in each of the application windows. In the case of instruments, the prefix that is fed in the Group window is used.

-          Pattern: Prefix used to encode patterns.

-          Supplier: Prefix used to code suppliers.

-          Event: Prefix used to encode events.

-          Variable R&R: Prefix used to encode variable R&R studies.

-          R&R by attribute: Prefix used to encode R&R studies by attribute.

-          Bias: Prefix used to encode bias studies.

-          Linearity: Prefix used to encode linearity studies.

-          Stability: Prefix used to code stability studies.

-          Calibration: Prefix used to code calibrations.

Acceptance tab

Defines the R&R percentages to define whether the measurement system is considered Acceptable, Under Review or Unacceptable. As well as the criteria to consider a compliant calibration. By default, the criteria proposed in the Measurement System Analysis manual, published by General Motor, Ford and Chrysler, are presented.

The criteria to know if the variability of a measurement system is satisfactory depends on the variability percentage of the manufacturing/production process or the tolerance of the part that is consumed by the measurement system variation. The

Final acceptance criteria for specific measurement systems depend on the environment and purpose of the measurement system and should be agreed with the customer.

For measurement systems whose purpose is to analyze a process, an empirical and general rule for the acceptance of a measurement system is as follows:

-          % R & R <10% - generally considered an acceptable measurement system.

-          % R & R between 10 and 30% - may be acceptable or not, based on the importance of the application, cost of the measuring device, repair costs, etc.

-          % R & R> 30% - considered as not acceptable, efforts should be made to improve the measurement system.

In addition, the number of different categories (ndc), times in which the variation of the process can be divided by the variation of the measurement system must be greater than or equal to 5. In the event that in a given study this number is less than 5 will be considered an invalid study so it must be repeated.

Alerts tab

In this tab the days of anticipation with which the event reminder, calibrations, R&R studies and pattern expiration are set are configured.

-          Days in advance for event alerts: Determines the number of days in advance with which a pending event appears in the reminder of the responsible user. This allows that before the date of the event arrives, the person responsible for it will be notified.

-          Days in advance for calibration alerts: Determines the number of days in advance with which the pending calibration appears in the reminder of the responsible user. This allows the person responsible for it to be notified before the date of the next calibration of the instrument arrives.

-          Days in advance for notices of R&R studies: Determines the number of days in advance with which the pending R&R study appears in the reminder of the responsible user. This allows the person responsible for it to be notified before the date of the next R&R study of the instrument arrives.

-          Days in advance for employer notices: Determines the number of days in advance with which the employer's expiration notice appears in the reminder of the responsible user. This allows the employer to be notified before the employer's expiration date arrives.

Email Tab

All notices are made ​​by email, therefore the mail server information must be established so it can send the warning messages.

-          Email use: Allows activating and deactivating the use of email. If this option is deactivated, no messages will be sent.

-          Show Messages: Allows displaying the contents of the message on screen before sending.

-          Edit Messages: Allows modifying the content of the message before sending.

-          Enable SSL: Allows using secure connections on emails. If your mail server has activated the use of secure connections for incoming email (SSL), one must activate this option for the messages to appear.

-          Authentication Mode: Indicates if the mail server SMTP requires the client to authenticate before the server sends an email on its behalf.

-          Mail for sending report delays: Email address that will receive the summary delays report. This report is issued once a day. Multiple addresses can be written if separated by semicolons.

-          Outgoing mail server: Address or name of the mail server where the messages will go out.

-          Username: User of the email account or email address from where all messages will go out. This account should be registered on the mail server.

-          Password: Password of the email account from where all messages will go out.

-          Port: Port used for outgoing mail.

 

Upon completion of the changes, click Save.

To test the functionality of the email, click Test. The application will send a message to the email of the Admin user.

For sending reminders to go out from the server automatically, create a scheduled task in the server to run qgagetask.exe with the parameter /send-reminders.

 

Security tab

 

The checkboxes on this tab enable/disable security options.

- Allow user deletion: If you want to avoid the accidental deletion of Users, disable this option.

- New users must change the password: This box forces the user that recently signed in the application to feed your password.

- Password expires: When activating this box, the passwords must be changed periodically

- Days of password duration: Number of days that the password lasts. After the time configured here, the system asks the user to feed a new password.

- Non-reusable passwords: Minimum number of different passwords than You must use a user.

- Minimum password length: Indicates the minimum amount of characters that They must have user passwords.

- Maximum idle time (minutes): Inactivity time in minutes to log out The application shuts down after a specific configured time In this option.

- Maximum amount of attempts to enter: To prevent a person from outside the app to enter it without the permissions of an assigned user, you can configure the maximum number of attempts to Enter the system. This way, when a user fails a certain amount of Sometimes, the user account is disabled, and an email is sent to the Admin user. The user can be enabled again in the Users window.

To save the changes, click Save.

 

 

Custom Fields Tab

This tab creates and deletes the custom fields that appear in the different application windows. These fields are used to add information

customized to the application.

To add a new field to a window

1.    Select the window from the Window drop-down list.

2.    Click New.

3.    Type the name of the field.

4.    Click Save.

To remove a custom field from a window

1.    Select the window from the Window drop-down list

2.    Click the corresponding . The confirmation window is displayed.

3.    Click Yes. Deleting a custom field loses all information

Registered in that field. This removal cannot be undone.

 

Custom Reports tab

You can add custom reports to the system. These reports are shown on the main screen in the Admin group of the Reports tab of the ribbon.

Custom Report Information

- Name: Report Name

- Description: Brief description of the report.

- Template: Excel file containing the report template. See chapter Reports for the characteristics that the report must meet. To search the template, click , Select the file, and click Open.

- SQL query: SQL query that extracts the information from the database. To write this query, you should know the structure of the SQL database server that is on the server. You can rely on the WILSOFT tech support service to create customized reports.

 

To add a new custom report

1.    Click New.

2.    Enter the report information.

3.    Click on Save.

To modify a custom report

1.    Click the corresponding .

2.    Modify the report information.

3.    Click on Save.

To delete a custom report

1.    Click the corresponding . The confirmation window is displayed.

2.    Click Yes.

Report templates management

All system reports are issued directly in Excel. The templates of these reports can be modified to obtain the reports in the desired format. To see the structure of the templates, see the Reports chapter below. In this tab, you can manage the templates used by the application. To do this, click on Manage templates.

You can download the template file by clicking      . To modify the template, you can use MS Excel and then upload the modified file by clicking on

 

Records tab

This option allows you to delete information that is no longer necessary from the database.

As well as import a list of instruments.

To delete records, you must enter the period to consider for deletion on the dates From and To.

You can delete the records of Events, Variable R&R Studies, Attribute R&R Studies, Bias Studies, Linearity Studies, Stability Studies, Calibrations, Tracking, Posts, and Deleted Instruments. As well as temporary report files. In the corresponding checkboxes are selected

the records you want to delete. To delete records that meet the selected conditions, click Delete.

You can import instruments from an Excel sheet. To use this option, Excel files must be in the format of the tmpInstruments.xlsx template.

To import instruments

1. Click Import from Excel.

2. Select the file that contains the instrument information.

3. Click Open.

Log off

This option allows you to exit the application and displays the Login page for an upcoming login.

Groups

The main QGAGE screen presents a browser structure that shows the grouped instruments. The folders on the left side are the groups, which can represent departments, areas, or any division of the company. The right part shows the instruments that belong to the selected group. Users with Group permission perform group management.

Group Properties

General Tab

- Name: Group name

- Description: Brief description of the group.

- Prefix: It is used to generate automatic instrument coding. Each new instrument that is created has a code by default that begins with the group prefix and a consecutive number.

- Email: Email address to send copies of arrears notices.

Permissions tab

Allows you to assign permissions to each role on the information related to the group.

Description of permissions.

- Read: View the information about the instruments of the group.

- Edit: Allows you to modify information about the instruments of the group.

- Delete: Delete records related to the instruments of the group.

- Approve: It allows us to approve the studies of the instruments of the group.

- Group: Create, modify, and delete subgroups within the current group.

Also, it allows modifying the properties of the group, as well as eliminating it permanently.

To add a group

1. Right-click on the group you want to add as a subgroup.

2. Click New, the Group window opens

3. Enter the properties of the group.

4. Click Save.

To modify/consult a group

1. Right-click on the group

2. Click Properties, the Group window opens.

3. Modify the properties.

4. Click Save.

To delete a group

1. Right-click on the group

2. Click Remove, the system asks you what you want to do with the related information:

o Remove: Remove all subgroups from the group and remove all

instruments of the group and subgroups.

o Transfer: Transfers all the information of the group to the selected group in a combination box.

My instruments

The My Instruments list appears in the auxiliary panel that contains the instruments that the current user frequently uses.

To add an instrument to the list of My instruments, see below Add to my instruments in the Instruments chapter.

To add an instrument to the list of My instruments, see below Add to my instruments in the Instruments chapter.

To access the R&R studies of an instrument, click on the corresponding .

To access the calibration records of an instrument, click on the corresponding .

To remove an instrument from the list of My Instruments, click on the corresponding .

 

 

 


 

Chapter 4: Catalogs

This chapter shows how to record the information that supports the operation of the application, such as Instrument types, Patterns, Labels, Suppliers, Event types, and Events.

Instrument types

To access the instrument types, click on Instrument types in the Management group on the Home tab. In this option, the types or families of instruments are managed.

Instrument Type Properties

General Tab

-          Type: Name or code of the type of instrument.

-          Description: Description of the type of instrument.

-          Classification: Classify the instruments in Attribute, Variable, Tooling and others.

Documents tab

The Documents tab shows a list of documents related to the type of instruments, such as calibration procedure and use and technical documentation in general. In this option, you can add any file.

To add a document to the type of instrument

1.    Click Add.

2.    Click on

3.    Select the file.

4.    Click Open.

5.    Type a description of the document.

6.    Click Save.

To open a document, click on the corresponding .

To delete a document, click on the corresponding .

Custom Tab

The information registered in the custom fields of the pattern is displayed. To change the value of a field, enter the value in the corresponding cell.

To add a new type of instrument

1.    Click on New

2.    Enter the properties of the instrument type.

3.    Click on Save.

To modify the properties of an instrument type

1.    Click the corresponding .

2.    Modify the properties.

3.    Click on Save.

To delete an instrument type

1.    Click the corresponding . The system asks you what you want to do with the related information (such instruments). Two options are shown:

a.    Delete: Deletes the related information and cannot be recovered.

b.    Transfer: Transfers related information from one type to another that is selected in the type combo. For example: If Type1 is eliminated and Type 1 instruments are not to be deleted, but to become Type2 instruments, then you must choose to transfer information related to Type2.

To issue a report with all types of instruments, click on Report. Template: tmpReportInstrumenttypes.xlsx.

To filter the list of instrument types

1.    Enter a text that is in the instrument type key.

2.    Click or press Enter.

Patterns

It is essential for the company to keep track of the patterns it has to perform calibrations. To access the patterns, click on Patterns in the Management group on the Home tab.

Employer Information

General Tab

-          Code: Code or identification code of the employer.

-          Description: Description of the pattern.

-          Feature: Physical magnitude measured in the pattern. For example, length, thickness, volume, etc.

-          Value: Nominal value of the characteristic in the pattern.

-          Uncertainty: Uncertainty of the pattern according to the latest calibration report.

-          Valid until: Date the validity of the calibration of the pattern expires indicates when the pattern must be calibrated again

-          Traceability: Traceability code of the employer. The measurement of the pattern must be traceable to a national standard.

-          Units: Unit of measurement in which the value of the characteristic is expressed.

-          Group: Group to which the employer belongs.

-          Responsible: User responsible for the employer.

 

Documents tab

The Documents tab shows a list of the documents related to the pattern, such as calibration certificate, use procedure, etc. In this option, you can add any type of file.

To add a document to the pattern

1.    Click Add.

2.    Click

3.    Select the file.

4.    Click Open.

5.    Type a description of the document.

6.    Click Save.

To open a document, click on the corresponding .

To delete a document, click on the corresponding .

Custom Tab

The information registered in the custom fields of the pattern is displayed. To change the value of a field, enter the value in the corresponding cell.

To add a new pattern

1.    Click on New

2.    Enter the pattern information.

3.    Click on Save.

To modify the information of a pattern

1.    Click the corresponding  .

2.    Modify the properties.

3.    Click on Save.

To delete a pattern

1. Click the corresponding . The system asks you what you want to do with the related information (calibrations where the employer has participated). Two options are shown:

a.    Delete: Deletes the related information and cannot be recovered.

b.    Transfer: Transfers related information from one employer to another that

Select in the pattern combo. For example: If the

Pattern1 and it is wanted that the calibration records where Pattern1 is located are not deleted, but instead become records with Pattern2, then you must choose to transfer the information related to Pattern2.

To issue a report with all the patterns, click on Report. Template:

tmpReportPatterns.xlsx.

To filter the list of patterns

1.    Enter the text that is in the pattern key.

2.    Click or press Enter.

Tags

QGAGE allows you to print labels to stick on the instrument. Labels may contain information about the instrument, as well as study schedules, events, and calibrations. Any number of labels can be created and designed. To access the tags, click on Tags in the Management group on the Home tab.

Tag Properties

General Tab

-          Name: Name to identify the label.

-          Applies to: Indicates if it applies to Instrument or Planning. In the case of Instrument, the label is sent to print by right-clicking on the Instrument and select the Print label option. In the case of Planning, the label is sent to print by selecting click  on the Planning tab of the instrument properties.

-          Description: Description of the label.

-          Page layout: Allows you to design the label.

Suppliers

Instrument, pattern, and tool suppliers can be managed to keep proper control of deliveries and services. To access the suppliers do

Click Suppliers in the Management group on the Home tab.

Supplier Information

General Tab

1.    Code: Supplier identification code.

2.    Name: Name or company name of the provider.

3.    Email: Contact email.

4.    Contact: Name of the contact person.

5.    Comments: Comment or observations about the supplier.

 

Documents tab

In the Documents tab, a list of the documents related to the

provider. In this option, you can add any file.

To add a document to the provider

1.    Click Add.

2.    Click

3.    Select the file.

4.    Click Open.

5.    Type a description of the document.

6.    Click Save.

To open a document, click on the corresponding .

To delete a document, click on the corresponding .

Custom Tab

The information registered in the supplier's custom fields is displayed. To modify the value of a field, enter the value in the corresponding cell.

To add a new provider

1.    Click on New

2.    Enter the provider information.

3.    Click on Save.

To modify the information of a provider

1.    Click the corresponding.

2.    Modify the properties.

3.    Click on Save.

To delete a provider

1. Click the corresponding . The system asks you what you want to do with the related information. Two options are shown:

c.     Delete: Deletes the related information and cannot be recovered.

d.    Transfer: Transfer related information from one provider to another

that is selected in the vendor combo. For example: If deleted

the Supplier1 and it is intended that the instruments of the Supplier1 are not deleted, but become records with Supplier2, then

You must choose to transfer the related information to the Supplier2.

To issue a report with all suppliers, click on Report.

 

 

To filter the list of suppliers

1.    Enter the text that is in the provider code.

2.    Click  or press Enter

Event Types

The types of events are the concepts with which the events related to instruments and tools are classified. Among the most common types of events are cleaning, maintenance, adjustments, loans, etc. To access the event types, click on Event types in the Management group on the Home tab.

Event Type Information

General Tab

-          Name: Name of the type of event.

-          Description: Description of the type of event.

Documents tab

The Documents tab shows a list of the documents related to the type of event. In this option, you can add any file.

To add a document to the event type

1.    Click Add.

2.    Click

3.    Select the file.

4.    Click Open.

5.    Type a description of the document.

6.    Click Save.

To open a document, click on the corresponding .

To delete a document, click on the corresponding .

Custom Tab

The information registered in the custom fields of the event type is displayed.

To change the value of a field, enter the value in the corresponding cell.

To add a new type of event

1.    Click on New

2.    Enter the information about the type of event.

3.    Click on Save.

To modify the information of an event type

1.    Click the corresponding .

2.    Modify the properties.

3.    Click on Save.

 

To delete an event type

1. Click the corresponding . The system asks you what you want to do with the related information. Two options are shown:

a.    Delete: Deletes the related information and cannot be recovered.

b.    Transfer: Transfers related information from one type to another that is selected in the type combo. For example: If Event Type 1 is deleted and events of Event Type1 are wanted not to be deleted, but to become events of Event Type 2, then you must choose to transfer information related to Event Type 2.

To issue a report with all types of events, click on Report.

To filter the list of event types

1. Enter the text that is in the name of the event type.

2. Click  or press Enter.

Events

This option takes control of the movements and services that are performed on the instruments and tools. The movements that can be recorded are the types of events defined above.

Event information

General Tab

-          Instrument: Key and description of the instrument

-          Code: Identifying code of the event.

-          Date: Date of the event.

-          Type of event: Type of event or service.

-          Description: Description of the event.

Documents tab

In the Documents tab a list of the documents related to the

event. In this option you can add any type of file.

To add a document to the event

1.    Click Add.

2.    Click

3.    Select the file.

4.    Click Open.

5.    Type a description of the document.

6.    Click Save.

To open a document, click on the corresponding .

To delete a document, click on the corresponding .

Custom Tab

The information registered in the custom fields of the event is displayed. For

modify the value of a field enter the value in the corresponding cell.

To add an event

1.    Click on New

2.    Enter the event information.

3.    Click on Save.

To modify the information of an event

1.    Select the record.

2.    Enter the event information.

3.    Click on Save.

To delete an event

1.    Click the corresponding . The confirmation window opens.

2.    Click Yes.

To issue a report with all events click on Report.

To filter the list of event types

1.    Enter text that is in the name of the event type.

2.    Click  or press Enter.

Chapter 5: Instruments

On the main screen the instruments are shown in a explorer view. The left side shows a tree with folders or groups of instruments, and in the right side the instruments of the selected group are shown.

Properties of the instrument

 

General tab

-          Code: Code or instrument code.

-          Type: Type of instrument key.

-          Description: Description of the instrument.

-          Brand: Instrument brand.

-          Model: Model of the instrument.

-          Catalog: Code of the instrument in a supplier's catalog.

-          Serial number: Serial number of the instrument.

-          Supplier: Supplier of the instrument or tooling.

-          Location: Place of the company where the instrument should be.

-          Instead: Indicates if the instrument is in place.

-          Comments: Observations or comments on the instrument.

-          Group: Group to which the instrument belongs.

-          Responsible: User responsible for the instrument.

-          Calibration status: Calibrated, Not calibrated, or Not to be calibrated.

-          Procedure: Code of the instrument calibration procedure.

-          Calibrated with: Stores if the instrument is calibrated with standards or with any other instrument of greater precision.

Planning tab

Studies, calibrations, and services to the instrument and the tooling can be planned.

The person responsible for the instrument is notified when it is time to complete a schedule.

-          Activity: Type of planned activity

-          Time interval: Time interval enters each activity of this type.

-          Last: Date of last time, that activity was carried out.

-          Next: Next time to carry out this activity.

Documents tab

A list of documents related to the instrument is displayed on the Documents tab. In this option, you can add any type of file.

To add a document to the instrument

1.    Click Add.

2.    Click

3.    Select the file.

4.    Click Open.

5.    Type a description of the document.

6.    Click Save.

To open a document, click on the corresponding .

To delete a document, click on the corresponding .

Custom Tab

The information registered in the instrument's custom fields is displayed. To modify the value of a field enter the value in the corresponding cell

To register a new instrument

1.    Right-click on the right part of the main screen.

2.    Click New.

3.    Enter the instrument information.

4.    Click Record.

To modify the information of an instrument

1.    Right-click on the instrument you want to edit.

2.    Click Properties.

3.    Modify the instrument information.

4.    Click Save.

To add an instrument to the My Instruments list of the application's auxiliary panel, click Add to my instruments.

To delete an instrument

1.    Right-click on the instrument you wish to remove.

2.    Click Delete. A confirmation message is displayed.

3.    Click Yes.

Deleted instruments pass to the Deleted Instruments group. Only users with an Admin role can recover or delete it permanently.

To access the events of an instrument

1.    Right-click on the instrument.

2.    Click on Events.

To access the variable R&R studies of an instrument

1.    Right-click on the instrument.

2.    Click on Variable R&R Studies.

To access R&R studies by attribute of an instrument

1.    Right-click on the instrument.

2.    Click on R&R Studies by attribute.

To access bias studies of an instrument

1.    Right-click on the instrument.

2.    Click Bias Studies.

To access the linearity studies of an instrument

1.    Right-click on the instrument.

2.    Click Linearity.

To access the stability studies of an instrument

1.    Right-click on the instrument.

2.    Click Stability.

To access the calibrations of an instrument

1.    Right-click on the instrument.

2.    Click Calibrations.

To print an instrument label

1.    Right-click on the instrument.

2.    Click Print Label.

To display a report with the information of an instrument

1.    Right-click on the instrument.

2.    Click Report

Tools

Search for

Click Search to locate instruments that meet specific criteria. The information entered is searched in the ID, Password, Description, Brand, and Serial number fields.

 

Master list

To see a list with all instruments, click on the Master List. The report shows the instruments of the groups where the current user has permission to read.

 

Calendar

The Calendar option shows in a calendar form the planning of studies, calibrations, and services, as well as the expiration of employers. The information that is presented corresponds to the groups where the current user has permission to read. Clicking on a calendar item displays the options for registering the planning

To create a record corresponding to the planning, click .

To associate the calendar record with a Google calendar click .

To associate the calendar record with an Outlook calendar click  .

 


 

Chapter 6: Measurement System Analysis

The main functionality of QGAGE is to evaluate the measurement system. It counts with R&R studies, Bias studies, Linearity studies, Stability studies and calibrations.

Variable R&R study

The R&R study is the most important of all because it measures how suitable is the measurement system to measure the production process. To access the Variable R&R studies click Variable R&R study of the M.S.A. group on the Home tab.

Information of the R&R study

 

General tab

-          Key: Key to identify the R&R study. The key is automatically generated when a new study is created but it can be modified manually.

-          Date: Date when the study was performed.

-          Instrument: Key of the instrument.

-          Performed by: Person that carried out the study.

-          Product: Product on which measurements are made.

-          Characteristic: Measured characteristic of the product.

-          Units: Units of the measurement values.

-          Decimal places: Number of decimal places of the measurements.

-          Method: Method by which the R&R study is performed. It can be Range, Mean and Range or ANOVA.

-          Operators: Number of operators involved in the study.

-          Samples: Number of samples involved in the study.

-          Measurements: Number of measurements performed by an operator on the same sample.

-          Variation of the process: In order the process variation is calculated by the system from the samples, select the samples option. To enter the variation of the process manually select the manually option and enter the value.

-          Study operators: Names of operators involved in the study.

Data tab

The data sheet is based on the M.S.A. format.

To capture data

  1. Click Design. The data table is prepared with default values ​​.
  2. Enter the measurements in the corresponding cells.
  3. Click Save.

Conclusions tab

The results of the study are shown in the Conclusions tab.

-          Repeatability [%]: Percentage of repeatability.

-          Reproducibility [%]: Percentage of reproducibility.

-          R&R [%]: Percentage of R&R.

-          Observations: Observations or comments on the study.

Once the study is completed click Refresh to update the date of the latest R&R study in the window of the instrument.

To create a new variable R&R study

  1. Click New.
  2. Enter the information of the study.
  3. Click Save.

To modify the information of a variable R&R study

  1. Select the study in the list on the left.
  2. Modify the study information.
  3. Click Save.

To obtain a report of the variable R&R study, click on the corresponding Report button. The report includes the Rank, Average, and Rank and ANOVA methods. When the report is issued, the fields of the Conclusions tab are updated.

To delete a variable R&R study

  1. Click on the corresponding . The confirmation message is displayed.
  2. Click Yes.

For a summary report of several R&R studies

  1. Click Report.
  2. Select the dates period of the studies.
  3. Click OK.

To filter the list of R&R studies

  1. Enter a text in the lower left text box.
  2. Press Enter.

R&R study by attributes

QGAGE allows using the Analytical and Risk analysis methods to calculate the % of the R&R by attributes. To access the R&R studies by attribute click Attribute R&R of the M.S.A. group on the Home tab.

Information of the R&R study

General tab

-          Key: Key to identify the R&R study. The key automatically generated when a new study is created but can be modified manually.

-          Date: Date when the study was performed.

-          Instrument: Key of the instrument.

-          Performed by: Person that carried out the study.

-          Product: Product on which measurements are made.

-          Characteristic: Measured characteristic of the product.

-          Units: Units of the measurement values.

-          Decimal places: Number of decimal places of the measurements.

Analytical method tab

The analytical method uses the concept of Gage Performance Curve to evaluate the repeatability and the gage bias. This analysis can be used in gage of one limit and/or two limits. For a double limit gage, is only needed to examine a limit with the assumption of linearity and error uniformity.

Generally, the analytical method consists of obtaining the reference values ​​for a group of selected parts. These parts are evaluated a number of times (m), with the total number of accepts (a), for each part being recorded. From the results, repeatability and bias can be assessed.

The first stage of the attribute study is the part selection. It is essential that reference value be known for each part used in the study. For practical reasons, 8 samples of reference values ​​ equidistant are selected. The maximum and minimum values ​​should represent the process variation.

Gage should be applied in the eight parts m=20 times and record the number of acceptances. The smallest parts must have the value a=0; the largest part, a=20; and the six others parts, 1≤ a ≤19. If these criteria are not satisfied, more parts with known reference values, (X), must be run through the gage until the above conditions are met, if, for the smallest value a≠0, then smaller and smaller parts are taken and evaluated until a=0. If the largest value a≠20 then larger and larger parts are taken until a=20.if six ot he parts do not have 1≤ a ≤19, additional parts can be taken at selected points throughout the range. The first interval at the a=0 end starts from the largest measurement where a=0 and a=20 ends and worked toward the middle of the part range. If necessary, the procedure can be repeated until the criteria are met.

To capture the data for the study

  1. Select the Specification, if it is lower or higher and the value of it.
  2. Click Design. Data table is prepared with default values ​​.
  3. Enter the values ​​of the reference samples and the number of acceptances of each.
  4. Click Save.

The result is obtained by issuing the study report by clicking the corresponding Report button.

-          Bias: Represents the shifting that has the gage regarding its specification. In some cases this bias or shift is not important. When the bias is important, a legend in red indicating "significant bias" is displayed in the report. In this case the value of bias must be taken into account to calibrate the gage. Otherwise, it must not because it is not statistically significant.

-          R&R Gage: Gage repeatability.

Once the study is completed click Refresh to update the date of the latest R&R study in the window of the instrument.

Risk Analysis Method tab

In some attributes situations is not feasible to get sufficient parts with variable reference values. In such cases, the risks of making the wrong or inconsistent decisions can be evaluated by using:

-          Hypothesis Test Analyses

-          Signal Detection Theory

Since these methods do not quantify the measurement system variability, they should be used under with the consent of customer. Selection and use of such techniques should be based on good statistical practices, an understanding of the potential sources of variation wich can affect the product and measurement processes, and the effect of an incorrect decision on the remaining processes and the final customer.

In this method three operators are used, and each operator takes three decisions on each part. A Pass decision is designated with a one (1) and a Does not pass decision with a zero (0).

The Value column contains the numerical reference value. This column can be ignored in case there is not data.

To capture data of the risk analysis method

-          Click Design. A data table with default values ​​is prepared.

-          Enter the values ​​in the corresponding cells.

-          Click Save.

To see the study report, click the corresponding Report button.

The Kappa table between operators shows the reach of agreement between the evaluations of the operators. A value of 1 indicates the agreement is perfect. A value of 0 indicates the agreement is not better than a mere chance.

A general empirical rule is that the values ​​of kappa greater than 0.75 indicate a good to excellent agreement (with a maximum of kappa = 1). Values ​​lower than 0.4 indicates a poor agreement.

Kappa does not take into account the size of the disagreement between the operators, only if they agree or not. This analysis is necessary to determine if there are differences between operators but does not tell us how good the measurement system classifies good from bad parts. For this analysis should be observed the last line of the table where the values ​​of Kappa represents the comparison between the operator and the reference value.

The Effectiveness and Probability Summary table shows the percentages of effectiveness, error and false alarm for each operator. The last column Pr (PM / DM) indicates the probability that the part that the operator indicates as bad, is really bad. This is a measure of the effectiveness.

Once the study is completed click Refresh to update the date of the latest R&R study in the window of the instrument.

To create a new R&R study by attribute

1.       Click New.

2.       Enter information of the study.

3.       Click Save.

To modify the information of an R&R study by attribute

1.       Select the study in the list of the left.

2.       Modify the information of the study.

3.       Click Save.

To obtain a report of the R&R study by attribute click the corresponding Report button. Template: tmpReportRRAttribute.xlsx. Upon issued the report the fields of the Conclusions tab are updated.

To delete an R&R study by attribute

  1. Click on the corresponding . The confirmation message is displayed.
  2. Click Yes.

To obtain a summary report of several R&R by attribute studies

  1. Click Report.
  2. Select the dates period of the studies.
  3. Click OK.

To filter the list of the R&R by attribute studies

  1. Enter a text in the lower left text box.
  2. Press Enter.

Bias Study

The statistics properties most commonly used to characterize the data quality are the bias and the variance. Bias refers to the location of the data in relation to the reference value (master) and is calculated as the difference between the real value (reference value) and the observed average of the measurements. Bias is the measure of the systematic error of the measurement system. It is the total error contribution integrated ​​by the combined effects of all variation sources, known or not.

In this option is carried tout he control of all bias studies accomplished.

Bias study information

 

General tab

-          Key: Key to identify the study.

-          Date: Date when the study was performed.

-          Instrument: Key of the instrument.

-          Performed by: Person that carried out the study.

-          Characteristic: Measured characteristic of the study.

-          Units: Units of the measurement values.

-          Decimal places: Number of decimal places of the measurements.

-          Measurements: Number of measurements performed over the sample or pattern.

-          Tolerance: Tolerance of the instrument. It is used in the calculation of Cg and Cgk.

Measurements tab

In this tab the results of the measurements are introduced. To capture the measurements

  1. Click Design. A data sheet with default values ​​is prepared.
  2. Enter the values ​​in the corresponding cells.
  3. Click Save.

Conclusions tab

The results of the study are shown in the Conclusions tab.

-          Mean: Average of the measurements.

-          Bias: Bias of the measurements.

-          SigmaR: Standard deviation.

-          SigmaB: Standard deviation of the mean.

-          Range: Amplitude of the confidence interval.

-          Cg and Cgk: Capacity indexes of the instrument.

-          t: t Statistic

-          t critical: Significant t value.

-          Observations: Set by default if the system has an acceptable bias from the comparison of the t Statistic with the Significant t value

To create a new bias study

  1. Click New.
  2. Enter the information of the study.
  3. Click Save.

To modify the information of a bias study

1.       Select the study in the list of the left.

2.       Modify the information of the study.

3.       Click Save.

To obtain a bias study report, click on the corresponding Report button. When the report is issued the fields of the Conclusions tab are updated.

To delete a bias study

1.    Click on the corresponding . The confirmation message is displayed.

2.    Click Yes.

To obtain a summary report of several bias studies

1.    Click Report.

2.    Select the dates period of the studies.

3.    Click OK.

To filter the list of bias studies

1.    Enter a text in the lower left text box.

2.    Press Enter.

Linearity study

Linearity is the change of the bias through the normal operating range of the instrument.

An instrument has an acceptable linearity when the bias of the measurements remains in low values as the size of the pattern on which it is measured changes.

 

Linearity study information

 

General tab

-          Key: Key to identify the linearity study.

-          Date: Date when the linearity study was performed.

-          Instrument: Key of the instrument.

-          Performed by: Person that carried out the study.

-          Product: Product on which measurements are made.

-          Units: Units of the measurement values.

-          Decimal places: Number of decimal places of the measurements.

-          Characteristic: Characteristic measured in the linearity study.

-          Samples: Number of samples involved in the study. It is important to make a good selection of the samples for the linearity study. The value of the characteristic of the samples should cover all the normal range of operation of the instrument.

-          Measurements: Number of measurements performed on each pattern or sample.

-          Tolerance: Measurement tolerance of the instrument.

Measurements tab

In this tab the results of the measurements are introduced. Measurement 0 corresponds to the nominal value of the pattern or sample. The rest of measurements are those carried out with the instrument on the pattern or sample. To capture measurements

  1. Click Design. A data sheet with default values ​​is prepared.
  2. Enter the values ​​in the corresponding cells.
  3. Click Save.

Conclusions tab

The conclusions are shown after obtaining the study report.

-          Slope: Slope of the line of linear regression.

-          Independent: Independent term of the equation of the line of linear regression.

-          Goodness of fit: Goodness of fit of the linear regression.

-          ta: t statistic of Student for the slope.

-          tb: t statistic of Student t test for the independent term.

-          t critical: critical t of Student for the degrees of freedom of the study.

-          Observations: Observations or comments on the study.

QGAGE calculates each individual measurement bias in respect to the reference value and find, by linear regression, the straight line of best fit (reference value against individual bias).

Besides to the linearity ​​and linearity % values it is very important to focus on the goodness of fit. The goodness of fit is always a value between 0 and 1 that represents how well the straight line approximates the points cloud. If this value is close to 1 then the regression line is near the points cloud, so it can be said that the regression equation represents quite reliable the points of the graph. If the value of the goodness of fit is far from 1 then the regression line is not a good approximation of the measured values. In the latter case the linearity and linearity % will not shed reliable results, so these values ​​should not be recorded. In such cases the study should be repeated seeking greater values of goodness of fit.

To determine if the instrument presents problems of linearity two hypothesis tests are performed. The first seek if the slope of the regression line is zero. If this hypothesis is rejected it means that the inclination of the line is considerable, which implies that the biases for each reference value are different. In this case it is concluded that "The measurement system does not present the same bias for all reference values."

If the hypothesis is not rejected the second hypothesis test is performed, which consist of try if the independent term is enough close to zero. If this second hypothesis test is rejected it means some biases are statistically very large. In this case, it is concluded that "The measurement system has an unacceptable linearity ".

 

To create a new linearity study

  1. Click New
  2. Enter the information of the study.
  3. Click Save

To modify the information of a linearity study

1.       Select the study in the list of the left.

2.       Modify the information of the study.

3.       Click Save.

To obtain a linearity study report, click on the corresponding Report button. When the report is issued, the fields of the Conclusions tab are updated.

To delete a linearity study

1.    Click on the corresponding . The confirmation message is displayed.

2.    Click Yes.

To obtain a summary report of several linearity studies

1.    Click Report.

2.    Select the dates period of the studies.

3.    Click OK.

To filter the list of linearity studies

1.    Enter a text in the lower left text box.

2.    Press Enter.

Stability Study

Stability studies are very important because it can indicate us when a calibration or an R&R study is needed.

Stability study Information

General tab

-          Key: Key to identify the stability study.

-          Date: Date when the study was performed.

-          Instrument: Key of the instrument.

-          Performed by: Person that carried out the study.

-          Product: Product that participates in the study.

-          Characteristic: Characteristic measured in the linearity study.

-          Units: Units of the measurement values.

-          Decimal places: Number of decimal places of the measurements.

-          Measurements: Number of measurements performed on each pattern or sample.

Measurements tab

Stability studies should be carried on three patterns: a pattern with the highest range value of operation of the instrument, another pattern with a mean value and a third pattern with the lowest value of the range.

The Subgroup column indicates a consecutive value that identifies the group of measurements of the day. To add a subset of measurements

  1. Click Add subgroup.
  2. Enter the measurements in the Reading column.
  3. Click Save.

To delete a subgroup of measurements

  1. Click on one of the records of the subgroup.
  2. Click Remove subgroup.
  3. Click Save.

Reading column contains the measurements on patterns.

Conclusions tab

Contain the observations of the study.

To create a new stability study

  1. Click New.
  2. Enter the information of the study.
  3. Click Save

To modify the information of a stability study

  1. Select the study in the list of the left.
  2. Modify the information of the study.
  3. Click Save.

To obtain a report of the stability study, click on the corresponding Report button. The report contains the control charts for each of the patterns.

 

 

To delete a stability study

1.    Click on the corresponding . The confirmation message is displayed.

2.    Click Yes.

For a summary report of several studies of stability

1.    Click Report.

2.    Select the dates period of the studies.

3.    Click OK.

To filter the list of stability studies

1.    Enter a text in the lower left text box.

2.    Press Enter.

Analysis of the stability graph

Stability is a very important property that must have measurement systems. If the measurement system does not have a good stability, the results of R&R studies are not durable, i.e. only apply to a short period of time.

The stability is not obtained from a number or measured parameter. The statistical stability is determined through the use of control charts.

Control charts also provide a separation mean of the variation due to the causes that affect the measurement results (common causes of variation) of the variation that result from specifics variations (special causes of variation). The methods of control charts can be found in books of processes statistical control and quality. It is important to notice that when control charts are used one must not only look at the points that fall outside the control limits but also signals of special causes such as trends and adherence to the center line. In publications on process statistical control, it can be found guides to detect these signals. The presence of these signals and one point or points outside the control limits prove unstable or uncontrolled conditions.

A method of studying stability of a Measurement System consists of plotting the mean and a pattern range or sample or pattern readings regularly. From such analysis can be determined for example that a signal out of control is a sign that the measurement system requires calibration. A calibration without a signal out of control is likely to increase the variation of readings of the Measurement System.

It is not necessary to calculate a stability number of the measurement system. The indexes are commonly used as a measure of improvement but with a control chart, the improving of the system can be seen in the diagram. A way of improvement may be the elimination of special causes of the process resulting in a stable process measurement. QGage has the option to perform a graphic Stability analysis through graphical means and ranges.

 Calibrations

In this option the calibrations performed to the measurements instruments are controlled.

Information of the calibration

 

General tab

-          Key: Key to identify the calibration. This key is automatically generated but can be modified.

-          Date: Date when the calibration was performed.

-          Instrument: Key of the instrument.

-          Type:  Calibration type (external calibration, internal calibration, internal verification or metrological verification).

-          Performed by: Person that carried out the calibration.

-          Characteristic: Characteristic measured in the calibration.

-          Units: Units used in the calibration.

-          Decimal places: Number of decimal places which the measurements are captured.

-          Tolerance: Tolerance allowed to the instrument.

-          Process variation: Variation in the process that has the measured characteristic.

-          Measurements: Number of measurements performed on each pattern.

-          Patterns: Number of patterns used in the calibration.

-          Temperature: Temperature in the calibration room.

-          Humidity: Humidity in the calibration room.

-          Adjustment factor (K): Adjustment factor to the calculation of expanded uncertainty.

 

Measurements tab

The measurements are grouped in two tables: Measurements used for calculating uncertainty and measurement before adjustment. The upper part shows the patterns involved in measurements.

To capture data

To obtain a calibration report, click on the corresponding Report button.

The report includes the calculation of type A uncertainty. To complement the calculation of uncertainty with the type uncertainty, enter the data in the Uncertainty sheet of the Excel workbook of the report.

Conclusions tab

The conclusions are fed after obtaining the report of the calibration.

-          Uncertainty: Value or result of the uncertainty calculation.

-          Expanded uncertainty: Is the uncertainty combined by the adjustment factor.

-          Result: Displays if calibration is considered to be Conform or Not conform.

-          Observations: Observations or comments on the calibration.

Click Refresh to update the date of the latest calibration in the window of the instrument.

To create a new calibration

To change the information of the calibration

 

To obtain a calibration report, click on the corresponding Report button.

The report includes formulations for the calculation of uncertainty..

To delete a calibration

1.    Click on the corresponding . The confirmation message is displayed.

2.    Click Yes.

For a summary report of several calibrations

1.    Click Report.

2.    Select the dates period of the calibrations.

3.    Click OK.  

To filter the list of calibrations

 


 

Chapter 7: Reports.

One of the main advantages of QTRAINING is the customizing of reports. All QTRAINING reports are issued in MS Excel 2007 format. The templates are editable so that the reports are issued in the required format. Report templates are found in the folder where the application was installed.

Report design

 

To modify a report template, open the file with MS Excel 2007 (2010 or 2013). All templates contain a Design sheet that defines where the information extracted from the database is written. The database consists of tables containing records, and each record consists of fields containing values that are ​​shown in the reports. By editing this template, the results of the reports are modified. When issuing a report, QTRAINING reads the Design sheet to fill the remaining sheets with the information from the database.

There are two types of reports:

1.    From a list of records.

2.    From a record combined with a list of records from a related table.

Report from a records list

This type of report consists of a list of records in a table with statements. The Design sheet must contain:

-       In cell B1, the row number that contains the statement.

-       In column A, from row 3, the name of the sheet where the value of the records is written.

-       In column B, from row 3, the column letter where the value of the records is written.

-       In column C, from row 3, the name of the field that contains the value.

-       In column D, from row 3, the statement of the column of data.


The last cell in column A should contain the word "End."

 

Example: Courses report.

 

Report from a record list combined with a list of records from a related table

 

This type of report consists of a free area where the fields of the main record and a list of records in table form with statements will be placed. The Design sheet must contain:

-       In column A, from row 2, the name of the sheet where the value of the main record is written.

-       In column B, from row 2, the cell where the value of the main record is written.

-       In column C, from row 2, the name of the field containing the value.

-       In cell F1, the row number that contains the statement of the list of related records.

-       In column E, from row 3, the name of the sheet where the value of related records is written.

-       In column F, from row 3, the column letter where the value of related records is written.

-       In column C, from row 3, the name of the field containing the value of related records.

-       In column D, from row 3, the statement of the data column from the related records.

 

Reports tab

The main reports are located in the Reports tab of the ribbon.They are grouped into

  1. Instruments, reports related to instruments.
  2. Scheduling, reports related to R&R studies and calibration scheduling,
  3. Admin, reports can only see the Admin user.

The following table displays the reports with its modifiable template.

Instruments

1.    Inventory: Displays the number of instruments by type.

Template: TmpReportInventory.xlsx.

2.    Calibrations plan: Displays the instruments from a selected group scheduled to calibrate in a period of time.

Template: tmpReportCalibrationplan.xlsx.

3.    Offside: Displays the instruments that are not on its location.

Template: tmpReportNotinplace.xlsx.

4.    By group: Displays the instruments of the selected groups.

Template: tmpReportInstgroup.xlsx.

Programmings

1.    Calibrations: Displays the calibrations plan for a period of time.

2.    R & R studies: Displays the R&R studies scheduled in a period of time.

3.    Patterns: Displays patterns with expiring date in a period of time.

Admin

1.    Email: Displays emails records sent from the application.

2.    Tracking: Displays trace records that leave the application every time a user makes changes within the system.

3.    Custom: Displays the custom reports created in the Settings window.