Home

2 - CyberMetrics

1. 66 PEGCISIOD onn o AE RATS EP RAT EDU T T abt AA ROCA ERAT vER Le cU Edu Ves CUT E D adt epis 66 Repeatability Equipment Variation ccccsssssssscscssssscscesesssssssssssssssesesesesesssesesesesseseseaeseaeseseseaesesessssseaescseacacaesseeseseeseseseseaas 67 Reproducibility Appraiser Variation ssssssscssssssssscscssssssssssssssesssssssscsescacsesesesesesesesssssseseacseseseseaeacsesesesssseseseaeseacaesescaeacaeseees 67 jeje M 67 Variatoti COMPONE MS 22a qiti oe nt o ar abs cas t adc aaa CARLOS teen Loa T CATENA 67 Dage RSR ENT MENU dote cu neve e veto edd cava uit duet vi n e V is 68 Range Method Short Method sscscsssssssssssssssssscsssesssesesesssesesesesessesesesesssesesesesesseseaesescaeaeaesesesesssseseseseseaeacacacaeseseseseeseseseaeas 68 Range Method Short Method Interpretation scscscsssssssssssssssssssscscsescssssssseseseseesesesesesesesesesesssssesssssseseseseacacacaeseneseseeseseseaas 68 Average and Range Methodist deed ema ore eo uei oti uA RENE Rud reip o eU CR XEM LR CREER Mu cR eTAvER E Veo uda CE oaa 69 Average and Range Study SCEeBH sod c m Cav ht arcuate ete atttem ato bau dau o Rc etitm d 69 Average and Range Method Interpretation 6 rire trait epar sonssvassccensissuedhcavendotbnsonssasavesisebssusesesniustdesbesscavubevcdacsicnseades 71 Generating REDIRET DTE D 71 Range Chart
2. M 81 Table of Contents 7 COM OLC AIS viana RNE E reas ance lare ins atest aeindeeaa TI A EE eae 82 Stability Study SCCM GS etait aeta tole Und exe RN eU DB Sd OE EVE SEN EN IRR HN NAVES santos SURREY VR RUE NEIN GU PANNE Pu CER RN vada Uus 82 Adding Stability Sub GFOUD earen tibt ere ee n a ee de b ucl bd A GRO a Du p etu daos 83 Calculated Average Control Chart Elelds iioi teet eiie t EDI o ER te EL e eo SEHE UR e PUR E ida 84 Calculated Pange Control Chart Fields on at op tef a m HP asap tae Gasman ELSE e DERE HERE e DR A RAIN 84 Stability F rmula RR EE ETE iaconieeauneatecanes 85 Attribute Study Short Method oot a id etait vod utset t tui elei thon vitet tutd id uiuis 85 Attribute SLUG SCLOGITo us sites ob ette M eta eM ED dp IER PME AR 86 PIN OV e M 87 ANOVA Study SCH SCM aao deti pec ses pesaeeh ce dev ese Elie EVO SEU E E EREE OE EOS e ke dU Ee NN NEN PIE ETUR ed ass bleeds 87 ANOVA CHabb ioca n Ree did ce M a E Ua ion pa een IA LOI iU et eH OUI a s LRL DIM I NEED e UI 88 ANOVA PGI rita coii ecrit ET dra cs cucu ce Edna uu Ma EA LN ES E I REEL 89 Measurement System Evaluation Procedures eee ee eee eese eene enne een sten estas etse tenet tasses tease easet ene soae 97 AfialySiS eei ata aM dM quu mA I e 97 icd edd o cR MD Pp Hp ERNST 97 Total Measurement VariatlObia uoo ei on a Ett hU Ui MAC cen mU 98
3. End Value Enter the information for this particular standard then click F Z GAGEtrak automatically enters the information into the Standards screen r Information History Standards Parts Procedures Schedule Gage ID t PreFill Standard ID Type Units Minimum Nominal Maximum 8 1 Gage Block 1 Inch Inch 0 999 1 001 2 Gage Block 2 Inch 1 999 2 001 E 3 Gage Block 3 Inch Inch 2 399 3 001 al 4 Gage Block 4 Inch 5 Gage Block 5 Inch Inch 4 999 5 001 5 5 Gage Block 6 Inch Inch 5 999 6 001 i lt z o gt r i Inch 3 333 4 001 Jl Record 4 4 B gt gt t gt of 5 Record 14 D Il 1E or gt of 1 In this example the minimum and maximum measurements are automatically calculated based on the and tolerances entered in the Gage Entry Information screen 001 The Calibration Standards table contains the following fields Field Button Name Description Standard ID Enter the name or identification of the calibration standard or checkpoint for example Gage Block Each standard ID that you enter for the gage must be unique If you need to use the same name for more than one ID number or letter each ID For example if you need to use the name CMM Check for more than one standard ID you could number the name each time The names would then look like this 1 CMM Check 2 CMM Check 3 CMM Check
4. From the left side of the Export screen highlight the table s you want to export From the right side of the screen choose the file format you want E Export Import Esport Import Table s To Export Format ta Export To Calibration Header Calibration Measurement Escel v3 Calibration Standards Excel v4 Excel vh Gage Regs Excel 37 v8 Enc Issue Tracking Each table that you can export has a corresponding filename so you don t need to name your export files The filenames are based upon the destination source tables plus the appropriate extension for the file type For example a text file from the Parts Master table will be named PARTS TXT the same file sent to an Excel file will be named PARTS XLS The Export utility places these files in the same directory as your program file Table Name Export Filename Helpful Information Calibration CalHead Every calibration record will be present in the Calibration Header Header table Calibration CalMeas Not every Calibration Header record requires a Measurement corresponding Calibration Measurement record The Calibration Measurement table contains only calibrations that include actual calibration standards measurements One Calibration Header record may have many corresponding calibration records Calibration CalStd This table links gages to their calibration standards Standards Gage Master GageMast All Gage Entry information is contained in this table
5. 4 eere eee sees teet eese eee eee en etta etse east tae t ane t senes sae tas etas enae 201 Create a New GAGEtrak Database uiae aec beoe ele ER EE asec EE ELE HERRERA OPNS ease NEUVES 201 Creating coris ih WINDOWS o nca dde E ie o din ne uua unte ae Econo ond toc UN Lao CI 202 Hut ANN NL DR UU TEE 202 CompactU Repalr JCOFiacousesteseto koci b RN HX oU DURER ROYALE E E EE Se CU eU p REO eod ud aid 202 Appendix D System Maintenance and Troubleshooting esses 205 DAS FOr AlS esce c btt mande LM M M 205 Maintaining Your Habd DUIVe ie eus esc oie a itv cde ooi Ho cie oe edt Ea 205 Maximizing Your Perfortmslite ns ea a eare Laert piel da ie ua arabe oi dirais 206 Installation diis sehe SA AMA MM E E Ru eT 206 Kepaliririg DataFllBs x 9 a epit dits is doe t e E a eu DUE LU 206 Duplicate Value Error Message peso L Sen E E Ivo E sos Vu Eso bU Ps DO EUIS T ESO AGRO O 206 Previewing or Printing Reports Error Message eere eee eese eene eee eene en ette tenet in etas stas t enses stans tas s sae sn setae 207 10 Table of Contents P Touch Printer Does Not Print Labels eere ee ee e e e eee eee nenne nonno nore eee ee eee eee ee eee eee eee eee eee eee ee e eaae eee 207 GADEtrak Wont ODORE ER ON IER d O Ee da Ee im M I I EE 207 Appendix E TESIPIG sassis irren eie iod rev a rei rd ru aa rez cn Gk Ves G ae aaa aaaea aD du cV a 209 Quick Start Guide
6. Enter the ID of the new gage into the Mew Gage D field then click Clone To clone more gage records keep entering new gage IDs and clicking the Clone button Click the Exit button when you re finished Other Gage Entry Options We ll discuss each of these options in more detail in the User s Manual Tab Button Name Description Gage R amp R In this part of the Schedule screen you can set up the R amp R repeatability amp Schedule reproducibility study schedule for each gage This tab shows all calibration history for the gage It sorts the calibration history by date in descending order Use these records to define the parts and operations for which you will use the Parts gage Associating this information facilitates traceability to manufacturing Before you can associate parts with a gage enter the part records in Part Entry The Procedures tab lets you link a procedure to each gage You must enter the History nbeceGaren procedure in Procedure Entry before you can access It in this screen Graph To view an accuracy chart click on this button Undo Click this button to remove any changes to the current record Delete Use the Delete button to delete the gage record and all associated records Calibration This button takes you directly to Calibration Entry for the current gage ID In this window Calibration Entry from Gage Entry you can perform all actions that you would normally do in Calibration Entry except dele
7. Record 14 4 1 jejee oF 4 Now one of your lab technicians tells you that another department needs to borrow a gage May just give it to them he asks Your reply No we need to provide traceability each time someone uses our gages You ask him for the gage ID and use Gage Issue and Return to loan out the gage so that you have an accurate location for it You might have never found this gage again if it had gone off to the other department unchecked You ve also ensured that you ll have traceability for this gage GAGEtrak Calibration Management Software Quick Start Guide 17 D Gage ID Next Due Date Issue Date 09 30 1998 12 19 1998 Issue Time 3 38 PM Type Production Use m Issued To e5 m Issued Dept Job 7512FinalAssy m Part No 6754 CP 873 H Storage Location TodCiE Bin12 Current Location TodCi Bn12 Received Date Received Time aa Received From u Cycles i w o NextGage Exit 4 4 4 4 Later in the afternoon you check on the tool crib Some gages used for manufacturing today are being returned An employee with a Barcode Reader is quickly scanning the bar coded labels on each gage A second scan across bar coded department identification completes the gage return information Because you expect your auditor to arrive tomorrow you print the Calibration History with Measurements report for the last three months for a
8. System Administrator s Guide CyberMetrics 16100 N Greenway Hayden Loop uite 100 Scottsdale AZ 85260 480 922 7300 Fax 480 922 7400 www cybermetrics com Chapter 1 Installation You can use GAGEtrak 4 2007 on a single workstation on a network or in a client server environment installation will vary slightly for each of these options This chapter gives you general installation instructions for all options Chapters 2 and 3 deal specifically with setting up an Oracle client server system and an MS SQL client server system respectively Program Requirements GAGEtrak 4 2007 for Windows requires the following Microsoft Windows 98 2000 XP or Vista o Hard disk with 700 MB of free space for program files and 25 50 MB of free space for typical database 512 MB RAM or more VGA or compatible display monitor Mouse or compatible pointing device Printer if you want to print reports ink jet bubble jet or laser printer is best BM PC or 100 compatible computer 2 Pentium 133 MHz or higher CPU Installation Files The setup consists of three files SETUP EXE contains all the files required to run GAGEtrak G_CONECT INI is the initialization file used during installation to configure the user s database settings and README TXT notes special features or changes to the program Important Note for Oracle Users If you re planning to use GAGEtrak on an Oracle client server system you must in
9. Like A D Right Gage ID 2 99 GAGEtrak Calibration Management Software User s Manual 131 GAGEtrak Will Find Gages due between the 1st and 31st of March 2000 Gages located in the QC Lab or in Receiving Gages that aren t located in the QC Lab Gages overdue by more than 30 days Datel represents the current date Gages due in 2000 Gages due in the fourth calendar quarter Gages with descriptions that start with the letter C Gages with descriptions that are between A and D Gage IDs that have 99 in the last two field positions Description Description Adding New Records Is Null Is Not Null Adding Records in Form View To add new records in Form view you can f Click the New om button in the toolbar Or Gages with null blank descriptions Gages with descriptions that aren t null blank 2 Click the Last Record M navigation button then click the Next Record H navigation button Or 3 Use the keyboard shortcut CTRL Enter the information into the record then repeat any of the above steps to add another new record Adding Records in Table View To add new records in Table view you can 1 Click on the Last Record EI navigation button then click on the Next Record H navigation button Or 2 Scroll to the bottom row the record selector button will have an asterisk on it Enter the information into the record repeat either of these steps to add another new r
10. This screen contains the following fields Field Button Name Description Procedure Name Enter a unique title for each procedure If you try to create two procedures with the same name GAGEtrak tells you that you can t have duplicate index values If this happens enter a unique procedure name or click Undo Media Path To attach a media file such as a movie or an audio clip to the procedure enter the media player path and the media file path into this field example C WINDOWS MPLAYER EXE C MOVIES CALIPER AVI Procedure n this field enter the text of the procedure New Click this button to create a new procedure Undo Use this button to remove any changes you ve made to the procedure Delete To remove the procedure from all associated gage records and from your database click Delete Remove If you want to keep the procedure in your database but remove it from your gages 103 104 Chapter 6 Calibration Procedures click Remove This action removes the procedure from all attached gages but keeps it in Procedure Entry for your reference If you want to remove a procedure only from a particular gage go to Gage Entry Exit Click this button to return to the main menu Play To view or listen to any media file that you ve attached to this procedure click the Play button Copying Procedures from Another Windows Application You can use Windows Clipboard to copy procedures from other programs If you want to paste a proc
11. When it s finished you ll see this screen GAGE trak Eau IMPR EIL GAGEtrak Calibration Management Software System Administrator s Guide 153 After you ve read the information about the database location and license click Finish If additional files are required for GAGEtrak 4 2007 to run they will install now Follow the instructions on your screen to install any additional files Important Note During user workstation installations from your network GAGEtrak will look for the appropriate program settings in the configuration file G_CONECT INI in the network directory If it doesn t find them there it will check the workstation s Windows Registry and use the settings there If the settings aren t in either of these locations the program will use the default information MS Access Please note that Technical Support is not available for the creation of your client server database After You Install GAGEtrak If you re upgrading from a previous version of GAGEtrak you will need to run the Data Transfer Utility before you begin using the program Please see Appendix A Data Transfer Utility beginning on page 209 for complete instructions If you re using GAGEtrak in a client server environment first follow these steps to configure it with your Oracle or MS SQL database Administrator Installation To complete the administrator setup follow these steps Note You will need to do this only once for an administrator setu
12. 37 38 Chapter 1 Starting GAGEtrak User Name ajem L My Recent Documents i Microsoft Office Duok jmi TES ve Dv J My Computer central Panel ii notos Peeranger y Set Progam access and l VE aki Ww ELE gg Printers and Faxes i Toa indes ie 4 Hee ara sugar E SUE FE tog ost MO Shut Dos 3 Select the GAGEtrak 4 2007 program group then choose the GAGEtrak 4 2007 program and the main menu will appear GAGEtrak Logon When you run GAGEtrak a logon window will appear if you have set up security Enter your PIN Personal Identification Number and click the OA button For more information about setting up user security please see the System Administrator s Guide Please Enter PIN No Cancel GAGEtrak Serial Number If you haven t entered your program serial number into the About box the following message will appear to remind you to enter it Hn Serial No Entered IN Please Enter your Serial No inthe About Bos Click the OK button and the About window will appear Enter the serial number for your copy of GAGEtrak the serial number is located in your manual package on your registration card and on the packing list that came with your package If you can t locate your serial number please contact CyberMetrics Technical Support at 480 922 7300 GAGEtrak Calibration Management Software User s Manual 39 Main Menu The main menu shows the name of the currently logged i
13. option either a return of the price paid or b repair or replacement of the SOFTWARE or hardware that does not meet CyberMetrics Limited Warranty and which is returned to CyberMetrics with a copy of your invoice or receipt This Limited Warranty is void if failure of the SOFTWARE or hardware has resulted from accident abuse or misapplication Any replacement SOFTWARE will be warranted for the remainder of the original warranty period or 30 days whichever is longer NO OTHER WARRANTIES CyberMetrics DISCLAIMS ALL OTHER WARRANTIES EITHER EXPRESSED OR IMPLIED INCLUDING BUT NOT LIMITED TO IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE WITH RESPECT TO THE SOFTWARE THE ACCOMPANYING WRITTEN MATERIALS and ANY ACCOMPANYING HARDWARE THIS LIMITED WARRANT Y GIVES YOU SPECIFIC LEGAL RIGHTS YOU MAY HAVE OTHERS WHICH VARY FROM STATE TO STATE NO LIABILITY FROM CONSEQUENTIAL DAMAGES In no event shall CyberMetrics its distributors its representatives or its suppliers be liable for any damages whatsoever including without limitation damages for the loss of business profits business interruption loss of business information or other pecuniary loss arising out of the use or inability to use this CyberMetrics product even if CyberMetrics has been advised of the possibility of such damages Because some states do not allow the exclusion or limitation of liability for consequential or incidental damages the above limitation
14. GAGEtrak CyberMetrics 16100 N Greenway Hayden Loop Suite 100 Scottsdale AZ 85260 480 922 7300 Fax 480 922 7400 www cybermetrics com Chapter 1 introduction Overview We re proud to welcome you to GAGEtrak Version 4 2007 for Windows a database software program that automates your calibration information saving you time and giving you precise control over the tools you use to do your job The program was designed for quality control professionals who need a convenient easy to use and powerful method for documenting tracking and retrieving calibration information Once you ve mastered its essentials GAGEtrak will become a vital tool for managing your calibration records The Quick Start Guide will help you install and run GAGEtrak quickly so that you can evaluate its major features The User s Manual gives you detailed information about working with records and reports The System Aaministrator s Guide provides comprehensive installation instructions including client server installations and directions for setting up and maintaining the program and database The first section of this guide briefly discusses the development of formal measurement testing and calibration Next we ll look at a hypothetical example of how you could use GAGEtrak on a typical day This example will familiarize you with the program s major functions and features while giving you a look at some optional accessories In the second part of th
15. This field is required To add more choices to the Status field go to the Tools and Utilities menu and select Status ID Entry see the System Administrator s Guide for more information Tip If the Status field is not set to Active the Calibration Due and Calibration Schedule reports will skip over the gage Ref Standard Check this box to indicate that the record is for a calibration reference standard such as a gage block or reference weight not a gage NIST No For reference standards only enter the number that NIST provides for traceability purposes If it s not marked on the reference standard ask your supplier for the number Gage S N Enter the actual gage manufacturer s serial number found on most gages Asset No In this field enter the gage s asset number usually issued by your accounting department Model No Use this field to store the model number of this gage Gage Description Enter a brief but informative description of the gage Type This field is a list box field from which you can choose or enter a classification of the type of gage such as Variable Attribute Dial Vernier Hard Digital or SPC7 Unit of Meas Enter the actual units that the gage measures in such as In mm N LBf LBm Ohms or mA This field is a list box in which more choices will be available as you add them for other gage records Drawing No and If applicable ent
16. performed each action amp Settings IBEX User Info General Cal Options Skip Dates Audit Trail Exit Audit Trail I Erab Aud Tel Cancel Select Text Editor NotePad Audit Location c audit log View Audit Trail Tip If you are sharing the GAGEtrak database on a network drive locate your audit log in the same folder Field Button Name Description Enable Audit Trail Click in this box to enable the Audit Trail feature View Audit Trail Click this button to see your audit trail file Select Text Editor Choose a default text editor program such as NotePad to use for viewing the audit trail file Audit Location GAGEtrak puts the audit trail file in the directory you designate in this field Exit If you want to save your changes click Ex tto return to the main menu Cancel To exit this screen without saving your changes click the Cance button 176 Chapter 5 Setting Up GAGEtrak Set Up Users Security When you re finished with Settings select Setup Users from the Tools and Utilities menu to enter your user records You can assign different rights to the program for each user mw 7 EE Lim roa Locmbss Plaza gt g i nummszsens TET Carina fees p Mirim Typem Dega HaT Fe Derek ap nuuuu nzczc F n8 ns 2 ne i E Field Button Name Description PIN Each user should have a unique PIN Personal Identification Number a four digit number used to l
17. this works only in date fields When the calendar first appears it displays the current date To select another date click the up or down arrow buttons to scroll to the desired month and year then click the day of the month Click the OA button to accept the date click the Cance button to close the calendar without selecting a date 7557 9 af Feb e 2 3 4 5 6 7 8 101112131415 122 Chapter 11 Program Conventions Form Views of Records After you click Find in a filter window GAGEtrak looks through your database and opens the first record in the set displaying it in Form view Form views of records show you only one record at a time while Table or Datasheet views display many records at a time each row represents a record and many rows records are displayed at once Form view is the default presentation of your data use the toolbar or the View menu to switch between Form and Datasheet views Sample Form View of a Gage Record Gage Entry E3 P Information History Standards Parts Procedures Schedule Gage ID GEX9IT N Storage Location ocas H Status fi Active Current Location cas H Ref Standard NIST No Service Date 0570571998 Gage S N po3za943CV Retirement Date 05705203 Asset No poc458 Supplier Code ACME GAGES WORLDWIDE F Model No 8532C Cost 8743 s Description NCHGAG
18. For each request the report lists the date supplier requester and gage ID This report lists parts including descriptions and uses Check one of the Summary Listing options to show parts or gages that you use together To print gage requirement sheets check Gage Requirement Listing By Part These reports show you Datasheet views of your gage or calibration records Use them to change the way your tables look such as font style or column size and format lists of records Please note that you cannot change any of the actual data in these reports just the formatting 118 Chapter 10 Reports Chapter 11 Program onventions To save time and ensure consistency GAGEtrak uses a set of program conventions which are standard commands and design elements that make the different windows and forms operate in the same way You can use these conventions to navigate through add edit and delete records Other conventions help you retrieve and print records Shortcut keys help you save data entry time and avoid mistakes You should become familiar with these conventions before you begin using GAGEtrak Rather than repeating the same information in every section of this manual we discuss these conventions only in this section You ll find record specific information such as each record s individual purpose fields and special buttons in the parts of this manual that discuss specific record types GAGEtrak Help Go to the Help menu or press t
19. Gage ID Select the gage ID from the drop down list box Gage Desc The name of the gage or measurement device appears in this field Study Type GAGEstat automatically sets this field to Linearity you can t change it Appraiser Enter the name of the person conducting the study Comments Use this field to enter any comments about this study Co Part No Enter your internal company part or job number Part No Select a related part number such as the customer or supplier part number Part Desc This field displays the description or name of the part Characteristic In this field enter the name of the characteristic that you re evaluating These fields show the minimum and maximum specification limits of the characteristic that you re measuring In order to calculate linearity you must know the 6 Sigma Process Variation Specification Limits 6 Sigma Proc Var required of the characteristic Enter it here and GAGEstat will use it in the Linearity and Linearity PV calculations Part Reference Enter all five part reference values required Values 7 5 required Trials 1 12 In these fields enter all 12 trials of measurements for each part reference required required New To enter a new Linearity study click Vewto open a blank data entry form Linearity Analysis Fields Field Button Name Description Average Bias Average bias based on the Individual part bias values Linearity Linearity value for the study absolute value o
20. Gages or Gauges This term applies to many measurement inspection devices including fixed limit attribute or go no go and variable actual numeric measurement gages Usually your company calibrates this type of equipment internally using either working or precision standards You can calibrate fixed limit gages by using working standards or dimensional layout For simplicity throughout this manual we use the term gage to refer to all measurement equipment Inventory and Classification To begin your gage control system take an inventory of your gages During this initial inventory usually the most difficult determine origins locations types and calibration schedules then assign identification numbers and collect additional information to classify your gages In the past companies manually recorded this information on gage record cards that s where GAGEtrak comes in Instead of sifting through hundreds of cards to find gages due for calibration GAGEtrak automates the task letting you selectively create a list of these gages Calibration Schedules You usually determine calibration schedules by the gage s classification You can establish initial calibration schedules by expected usage engineering judgment and bargaining As you gather actual calibration information you might need to adjust the schedules The primary intent of a calibration schedule is to detect accuracy deterioration pr orto intolerable levels of accuracy
21. Last R amp R Date 03 23 1338 Next 27 728 2081 Last R amp R Result 4 6 R amp R Next R amp R Date 0972971999 jos 28 2002 Record 14 1 gt gt t gt of 1 Gage Calibration Schedule Field Button Name Description Initial Times Used To track gage usage go to this field and enter the gage s current number of uses as a starting point As you issue the gage out and enter usage information GAGEtrak automatically counts the number of uses and displays it in the Issue Tracking Entry screen Calibrator This field is a list box from which you choose the code of the calibration service supplier see the Supplier Entry section in the User s Manual for more information If you calibrate the gage within your own facility you could enter In House a specific department or a technician s name You can later use your Calibrator field entries to print a group of gages due for calibration by a particular calibrator Last Calibrated By The name of the user who last calibrated the gage appears in this field Calib Freq and Enter the frequency of calibration using the unlabeled list box field on the Calib Freq Units right for the frequency units for example 45 DAYS When the software calculates the next calibration due date it uses this value Your choices for the Units field are explained below Days schedule is based on elapsed calendar days Weeks each week equals seven days schedule is based on e
22. SET Last 03 30 96 By JFR Due n2 20n 07 137 138 Appendix A Calibration Label Kit Printing Labels from Calibration Entry You can print individual calibration labels directly from the Calibration Entry Labels tab 3 Calibration Entry x Calibration Measurements Procedures Labels Gage ID C 00001 Exit Select Calibration Label To Print D E F AWxl1L AWx L AW x3L G Wx1L H 4Wx2L L 8W x3L Iv Preview Tape Catalog Record 14 4 Il 1788 gt t ir of 4 To immediately printa label click on any of the label buttons such as 7 Wx 1 L the button size is about the same size as the label You must choose a button that s the same width as the tape currently installed in your label printer Note Because the labels are designed to cut off as close to the edges as possible a piece of blank tape will eject before the actual label prints To preview a label on screen check the Preview box and click the label button Printing Labels from the Calibration Labels Report To print a batch of labels select Calibration Labels from the Listing and Reports menu You can use this report to print all of your calibration labels in a single batch at the end of the day You can filter for a group of calibration labels based upon the calibration date gage ID location or description for any previously entered calibration records Select Calibration Label To Print x G AWXIL H aWx 2L l aWx3
23. Therefore you must treat the SOFTWARE like any other copyrighted material e g a book or musical recording except that you may a make copies of the SOFTWARE solely for backup or archival purposes and b transfer the software to hard disks provided that only one copy of the SOFTWARE is used at any time You MAY NOT COPY the written materials accompanying the SOFTWARE 3 OTHER RESTRICTIONS You may not rent or lease the SOFTWARE but you may transfer the SOFTWARE and accompanying written materials on a permanent basis provided you retain no copies and the recipient agrees to the terms of this Agreement LIMITED WARRANTY CyberMetrics warrants that a you may return the SOFTWARE and all accompanying written materials for any reason for a full refund for a period of 30 days from the date of receipt and b the SOFTWARE will perform substantially in accordance with the accompanying written materials for a period of 90 days from the date of receipt and c any hardware accompanying the SOFTWARE will be free from defects in materials and workmanship under normal use and service for a period of one year from the date of receipt Any implied warranties on the software and hardware are limited to 90 days and one 1 year respectively Some states do not allow limitations on duration of an implied warranty so the above limitation may not apply to you CUSTOMER REMEDIES Cyber Metrics entire liability and your exclusive remedy shall be at CyberMetrics
24. This field shows the accuracy based on the before measurement Before Nominal Acc Aft In this field GAGEtrak shows the accuracy based on the after measurement After Nominal Accuracy Flag If the before and after measurements are greater than the maximum or smaller than the minimum GAGEtrak alerts you by placing an X in the red square on the right of the accuracy calculation Limited Use If a gage is out of tolerance you can still pass it depending on its before and after measurements compared to its calibration standards Check this box to indicate limited use for it for specific operating ranges GAGEtrak doesn t automatically update this field Gage ID of Standard This field stores the gage ID of the reference standard which is important for traceability back to a specific standard You can manually enter the standard s gage ID or select from a list of available standards by clicking the small button on the right of this field The list shows only those gage records that have X s in their Gage Entry Ref Standard checkboxes Uncertainty If you select the reference standard from the list the uncertainty value will automatically display If you manually enter the standard then enter its uncertainty value here You can obtain this value from the manufacturer it s expressed in units such as percentage 0 5 proportion 0 005 or measurement 0 0001 inch You must enter units of the same value otherwise the calcu
25. and Reports Charts Average and Range Linearity Stability Attribute ANOVA Reports Menu Gage Listing With Calibration Standards With Calibration Procedures Gage Detail Report Gage Status Report Calibration Due Listing With Calibration Standards With Details Grouped by Calibrator Calibration Schedule Summarized by Day Week Month Quarter or Year Detailed by Day Calibration Work Order With Calibration Procedures Certificate of Calibration Calibration Costs amp Labor Calibration Labels Calibration History With Calibration Measurements Standards Traceability Report R amp R Due Listing Gage Issue History Listing Supplier Listing Procedure Listing Summary by Gage ID Summary by Calibration Procedure Corrective Action Request Part Listing Summary by Gage ID Summary by Part No Gage Requirements by Part Customizable Gage Report Customizable Calibration Report Setup Menu Settings Report Control ID Entry Setup Users Setup CA Service Request Status ID Entry Data Tools Menu Archive Un Archive Backup Restore Compact Repair Data Export Import Modify License Utilities Menu Edit All Tables Calculate All Due Dates Remove Spaces from Gage IDs Set Status of Gages Reset Gage Issue Status Reset Adjusted Frequencies Fill Calibration History 43 Chapter 2 Gage Records Before you begin entering information into your GAGEtrak program we recommend that you look over the Program Conventions sectio
26. new printer drivers You must select a default Windows printer in order to preview any reports See Windows Help or your Windows manual for more information on the Printers screen Colors To select a new color scheme for your Windows environment click the Colors button to access Windows Control Panel See Windows Help or your Windows 174 Chapter 5 Setting Up GAGEtrak Cancel Exft Field Button Name Auto Adjust Cal Frequency Frequency Adjustment Factors Certificate of Calibration Statement Exit Cancel manual for more information on the Appearance tab Click the Cance button to discard any changes and exit this window To save your changes and return to the main menu click the Exit button Calibration Options Selection amp Settings Jol x Auto Adjust Cal Frequency Exit Cancel Frequency Adjustment Factors Certificate of Calibration Statement Itis hereby certified that the above described instrument conforms to the original manufacturer s specifications and has been calibrated using standards whose accuracies are traceable to the National Institute of Standards and Technology within the limitations of the Instrute Calibration Services or have been derived from accepted values of natural physical constants or have been derived by the ratio type of self calibration techniques Our calibration system satisfies ISO 9000 QS 9000 and the ANSI 2 540 requirements Description If you check the A
27. vs A A vs C e o e e e 2 9 e mA jan mA MIA JA mA Co mui Wo t tQ QC CQ O x R oo Rx W eh a kt FZLO tper O HEVO ZELO rat a ELO ErELO B vs C o o e o o o ow I ow I J I I bod 4 4 4 fa fa fa o n2 n2 ce o Scatter Plot The Scatter Plot charts individual readings by part by appraiser to help you determine consistency among appraisers occurrences of abnormal readings and the interaction between the parts and appraisers Example Scatter Plot SCATTER PLOT oz o0n mzaz APPRAISER PART Repeatability Range Control Chart Using a standard range chart this chart plots the ranges of the readings by each appraiser for each part including the average range and control limits The data is grouped by appraiser and lines connect the points for each appraiser Repeatability Range Chart Interpretation The Range Control chart shouldn t show data patterns relative to the appraisers or have any out of control points An n control Range Control chart is a sign that the appraisers are consistent and use the gage in the same way With the Range Control chart you can determine consistency of the measurement process among appraisers for each part and statistical control in regard to repeatability 76 Chapter 4 Gage R amp R Entry Example Repeatability Range Control Chart REPEATABILITY RANGE CONTROL CHART
28. 0 1334 0 1332 Average Chart The Average chart is much like the Run chart except that it also calculates the overall average and control limits From this chart you can determine the measurement system s acceptability Example Average Chart AVERAGE CHART BY PART UCL 0 134196 AVG 0 134073 LCL 0 133951 The measurement discrimination or noise is represented by the area within the control limits If the group of parts used in the study represents the process variation about half or more of the averages should be outside the control limits If the chart shows this pattern then the measurement system should be able to reveal part to part variation it can also provide useful information for analyzing and controlling the process If less than half the averages are outside the control limits it might be because the measurement system isn t able to thoroughly distinguish differences or because the part sample doesn t represent the expected process variation 74 Chapter 4 Gage R amp R Entry Normalized Individuals Chart by Part Appraiser and by Appraiser Part In this chart the plotted data consists of the individual readings minus the overall average of the readings The normalized data is plotted grouped by appraiser or part number This chart can help you determine reproducibility consistency among appraisers occurrences of abnormal readings and the interaction between the parts and appraisers Example Normalized
29. 4 Record i 4 1 gt gt t gt of 1 Field Button Name Description Gage ID The ID of the selected gage will appear in this field Procedure Name To link a calibration procedure to the current gage select the procedure name from this list box Procedure In this section you ll see either the procedure text or any attached pictures Play To view or listen to an attached media file click the P ay button View Hide OLE You can view the procedure text or you can click the OLE Object Linking and Embedding button to view its associated picture The OL button s name will be either View or Hide only one of these options is visible at a time View OLE appears when you re viewing the text and Hide OLE appears when you re viewing the picture Exit Delete To exit Gage Entry click this button Click this button to remove the procedure from this gage When you click this button a dialog window will appear to tell you that in Gage Entry you can only remove the procedure from the current gage record To remove the procedure click Yes If you want to delete or remove a procedure from all gages you must do so in Procedure Entry see page 109 Remove Pincedura eR Uo pua mend bouemi thi peocedune hom Hair gage a This procedure vill be niic lom ork hig gage Ta riesce a procsdune fior all gages Lick Flansces in Procida Erg Adding Procedures To link another calibration procedure to this gage use
30. 43 97 Record 14 lt 1 gt bE Tb of 1 Record 14 4 1 gt gt t r of 1 Field Button Name Description Part No Select the part s ID number After you select the part number GAGEtrak will fill in the other fields with the information that you entered in Part Entry Description The name of the part will appear in this field Operation This field stores the production operation or work center description such as Stamping or Machine 13 Drawing No The blueprint drawing number of the part appears in this field 52 Chapter 2 Gage Records Gage Entry Procedures In the Gage Entry Procedures screen you can link calibration procedures to each gage amp Gage Entry x gt Information History Standards Parts Procedures Schedule f Gage ID Exit Delete Procedure Name CP22E Revision 12 01 97 x View OLE Procedure DIAL DIGITAL AND VERNIER CALIPERS Calibration Frequency 12 months can be modified according to stability purpose and usage 1 0 Scope This method describes the calibration of calipers inside and outside dimensions up to 72 inches 1800 mm and depth dimension up to 12 inches 300 mm Instrument resolution 0 001 or 0 0005 inch 0 02 or 0 05 mm 2 0 References This document is based on the DOD procedures 3 0 Definitions Tl Test Instrument DD Department of Defense 4 0 General Requirements Environment T rer she D Record 14
31. 56 Gage Entry 6Graph BUOI e M 57 Gage Entry Calibration BUltor io onte t rtt uat ba ttv eater tette tue trm rici 58 Chapter 3 Calibration ReCOFGS n cisonceiucieccvini nina aaa noe cni anta uer uds xo el scu chua eva ctu Cru imu a 59 Calibration EBU Yos e seio R vri essere ratus avene sott s coe eM MM p MV EU AU M Ue E M UU Med 59 Calibration Enty 62 1 o fs ufo n RED HP 59 Calibration Entry Measurements siii rrie t rri tuta bi eS a NIIS n Rue EEeR NER eSE TRES ERAN UNIS MEND Cu eR eH TERES E ETUR RN ORI R ERES env M Un oa uan UNES NE 62 CalibraliomEntmry PrOCedul 6S ias S D ei D RM UHR DI RUIN NIE IMS RU er NE D ste e TIE Ne 63 Calibration Entry E3b6ls ccce d Na tu ea tees opes tox ern O eiv cn ttu ete rete bI N S ic cv RUN CHEM buUd 64 Chapter Gage R amp R EDU Ome eae dodo deoa t ei Edu mR Sina NN SNE uoto o cupa Jecusu ero D save usu eC d dne TUE 65 Si MT M n 65 About the Manual Software and Technical Support eere eee eee eese esee sees etre tn ttn tn eate tn en sese tasa senses eps nae 65 Validating the SONWalre Lector toad ees ta eo a RR Mods E DoD S e aeu e EA 65 Terms and Belniopnsx e e Occo bom lu LI M Ln 66 Bias Accuracy dus resi t cca bnt D o a cat ba d eR DE Pu a d OE E oun E ED ED ERN an 66 NTC Ria PE
32. Assistant Now set up the configuration for SQL Net with the Oracle Net 8 Assistant 1 Click Start and select Programs Oracle for Windows 95 Oracle Net8 Assistant You ll see this warning Net8 Assistant Warning X Comment information has been detected in your Network Configuration files which may be lost or repositioned when you save your Network Configuration Do you wish to continue g Dont show this warning again 2 Click Yesto continue 3 Another screen will appear In the left pane select the Profile folder 4 Inthe right pane click the Oracle Names tab 5 Set Default Domainto your company s domain Orel Hag Assiatant Minnen gaunt Radmin e Ld dcos ke ug cH 4 Sameer 4r lt Semice Henes Coq hais Han ug To D ilis Narasi Si ea Metrods Drace Names Lame Deiz1 5mza Di nil Pun air HesalJbor ersiste 23 ae muri sa 7 zeza Albert 1 E Siteripts Per He nes Seer l F irh emma Maart n VES 1 Cor achora 3 inte tealloc ted Requests Fie 3t look Hap Ob etwit tk I tonle oer ce Hames 73 graci han29 Severs 160 Chapter 2 Oracle Installation 8 Next click the Plus button to create a service name 9 The Service Name Wizard will appear Enter your service name and click Next Oracle Net Service Name Wizard lt Service Name gt minis 10 In the next screen select the
33. Calibration Entry When you go to Calibration Entry from the main menu you can choose from calibration records for all of your gages Chapter 3 Calibration Records Calibration Entry Calibration Entry Filter To enter calibration records select Calibration Entry from the Enter View Records menu This filter window will appear amp Calibration Entry Filter LX Gage ID C 002 Gage S N Calibration Date 0 1997 Calibration Type Clear Filter Exit As with the Gage Entry filter you can search for a particular gage by selecting its ID from the Gage D drop down list In the sample screen you can see that the user is looking for calibration records for gage C 002 from October of 1997 To see all of your calibration records leave the filter fields blank If you try to calibrate a gage that you haven t already set up in Gage Entry you ll get the following warning message Application The Gage ID that you enteied has not been entered in Gage Master Entry Select a different Gage ID or enter the gage into Gage Master Entry Click OK then enter the gage in Gage Entry Once yourre finished you can enter calibration records for the gage Calibration Entry Calibration After you click the Find button in the filter the Calibration Entry screen will appear When you first open this screen GAGEtrak displays the most recent calibration record If you filtered for a group of gages the most rece
34. Contribution Field Button Name Description Study Date This field defaults to the current date but you can change it Gage ID Select the ID code for the gage you re using in the study Gage Desc Once you select a gage ID the gage s description will appear in this field Appraisers Select the number of appraisers you re using in the study Trials In this field select how many trials you re going to perform two or three Study Type This field automatically displays ANOVA you can t change it Comments Enter any notes relevant to the study Co Part No In this field enter the part number for the part s used in the study 88 Chapter 4 Gage R amp R Entry Part No Select the number of the part used in the study Part Desc After you select the part number its description appears in this field Characteristic Enter a brief description of the aspect you re studying with this gage Appr A B and C In these fields enter the name of each appraiser 1 10 Enter the appraiser s measurement results in these fields Prefill If all measurements will begin with similar digits use the Prefill feature to save data entry time see the description under the Average and Range section on page 70 New Click this button to create a blank ANOVA record Calc After you enter the measurements click Ca cto see the results of your study Print If you want to print the study click this button Delete Click this button to delete the curren
35. DATA9731 MDB file 3 Next click the small button on the right of the Destination Connection Information field to navigate to your GAGEtrak 4 2007 database GTDATA40 2007 MDB J 4 Click the ransfer Data button All Versions Verify Data Transfer After you click ransfer Data GAGEtrak automatically moves your records into the new database When it s finished you ll see this message Transfer Completed i Data Transfer Complete Click OK then GAGEtrak will show you a screen where you can check the transfer and verify that it was successful This screen is different for each version but the general instructions are the same The Record Count values should match in both the Source and Destination tables for those table names that appear in both sections You can ignore the table names on the Destination list that have no corresponding name on the Source list these are GAGEtrak 4 2007J s new tables the report control table will always be higher on the Destination side when you are transferring data from Version 3 192 Appendix A Data Transfer Utility If the counts for the tables that appear in both sections don t match print the form select File Print and contact Technical Support at 480 922 7300 for assistance Click the Finish button to return to the main DTU window Sample Data Transfer from Version 4 0 Data amp Data Transfer Utility Record Counts Source Destination Table Record Counts Esto Mess
36. Date 01 17 1997 _ Print Requester Administrator J Letter Gage ID c 002 Insurance Amt 236 00 Type Calibration Request Service Supplier 001 a Status Closed z Completion Date 03 01 1987 T Comments Record ta J 4 7 r of 2 Field Button Name Description CA Request No This field automatically generates a number to track your requests Request Date Enter the date or click the small button on the right of this field to automatically enter today s date Requester Select or enter the name of person requesting service Gage ID Choose the ID of the gage for which you need service Enter the amount for which you want to insure the device use for return freight Insurance Amount insurance if you re sending the device out for repair or calibration Select the type of the document to use such as Calibration Repair Calibration amp Repair or Corrective Action Notice For directions on adding new documents and editing service request letters or corrective action request forms see your System Administrator s Guide Select the supplier code of the service provider this might also be a department within your own company Status Mark the service request as either Open or Closed Enter the date on which the service was completed You can use the small button to the right of this field to automatically enter today s date Type Service Supplier Completion Date 107 108 Chapter 7 S
37. Electronic support is also available 24 hours a day to all registered users contact Technical Support at Email support cybermetrics com Internet www cybermetrics com NOTE TECHNICAL SUPPORT CANNOT BE PROVIDED UNLESS THE USER HAS FULLY COMPLETED AND MAILED IN THE ACCOMPANYING REGISTRATION CARD TRADEMARK ACKNOWLEDGMENTS All CyberMetrics Corporation products are trademarks or registered trademarks of CyberMetrics Corporation All other brand and product names are trademarks or registered trademarks of their respective holders SINGLE USER SOFTWARE LICENSE AGREEMENT This is a legal agreement between you the end user and CyberMetrics Corporation CyberMetrics BY USING THIS SOFTWARE YOU ARE AGREEING TO BE BOUND BY THE TERMS OF THIS AGREEMENT IF YOU DO NOT AGREE TO THE TERMS OF THE AGREEMENT PROMPTLY RETURN THE DISKS AND THE ACCOMPANYING ITEMS including written materials and binders or other containers TO THE PLACE FROM WHICH YOU OBTAINED THEM FOR A FULL REFUND SOFTWARE LICENSE 1 GRANT OF LICENSE CyberMetrics grants to you the right to use one copy of the enclosed software program the SOF TWARE on a single computer If you wish to put the SOFTWARE on a network server you must purchase the same number of copies as computers attached to the network that use the SOFTWARE 2 COPYRIGHT The SOFTWARE is owned by CyberMetrics or its suppliers and is protected by United States copyright laws and international treaty provisions
38. Files ktxt t cavit tabs asc Microsoft Excel 5 7 xls Microsoft Excel 97 xls HTML Documents C hml hkm Send Command E mail Reports The Send command from the File menu allows you to output reports to Microsoft Mail or any MAPI compatible mail program The output includes subforms and subreports The file format and appearances are the same as those described above for the Output To command You can send GAGEtrak information in the following formats Send Select Format Microsoft Active Server Pages Microsoft Excel i xls Cancel Microsoft IIS Abs idc MS DOS Text Ext Rich Text Format rEF EE Ic All Selection Select Record Command Use the Select Record command from the Edit menu to select highlight the current record which allows you to work with it as a whole For example you can select a record you want to copy to the Clipboard Select All Records Command You can use the Select All Records command from the Edit menu to select highlight all open records so that you can work with them as a group For example you can select all the records in one table and copy them to a spreadsheet or word processing document Find Command While you re in Form view or Table view you can use Edit Find to search through your records for specific information For example you could search the database for gages located in a certain department or for gages you purchased last y
39. Gage Reqs GageReqs In this table gages are linked with parts GRR Results GRR This table stores all of your gage R amp R studies and results Issue IssueTrk All Gage Issue and Return information is in this table 184 Chapter 6 Other Utilities Tracking Letter Letter The form letters you create for repairs service requests or calibrations are stored in this table MDR SrvReq This table contains the service requests that you ve entered into GAGEtrak Part Master Parts In this table you ll find all of the Part Entry information Procedure ProcLink This table links gages with procedures Link Procedures Procs Procedures are Stored in this table ResultCodes RsltCode The Result Codes table stores your Automatic Frequency Adjustment factors Skip Dates SkipDate This table stores all of the dates that the program skips when it calculates Next Due Dates for gages Status Status The Status table contains all of your gage status options Supplier Supplier The Supplier table stores all of your supplier information Master After you ve selected one or more tables to export click the Export Tablels button ES Export Import Export Import Table s To Export Format ta Export Ta Calibration Header q Excel 97 va Calibration Measurement Calibration Standards Gage Master Gage Regs GAR Results Issue Tracking Export T able s Close The Export program automatically sends the file s to the sam
40. Individuals Chart NORMALIZED INDIVIDUALS CHART PART APPRAISER Whiskers Chart The Whiskers chart plots and connects the high and low data values and the average by part by appraiser This chart helps you see consistency among appraisers occurrences of abnormal readings and the interaction between the parts and the appraisers Example Whiskers Chart WHISKERS CHART HIGH AVG LOW BY APPRAISER PART B 1 ABC 1 T T 00 ABC ABC ABC ABC ABC 44 5 5 65 6 777 8 8 6 X Y Plot of Averages by Size This chart plots the averages of each appraiser s various readings for each part using the reference value or overall part average if you don t enter a reference value as the index This plot can help you determine linearity if you use the reference value and consistency in linearity among appraisers Example X Y Plot Averages by Size X Y PLOT OF AVERAGES BY SIZE oOmmcuob rpmz mobrz5mtemp REFEREHCE VALUE GAGEtrak Calibration Management Software User s Manual 75 Comparison X Y Plots In a Comparison X Y Plot the averages of each appraiser s readings on each part are plotted against each other using appraiser as an index This plot compares one appraiser s readings to those of another appraiser If the appraisers readings matched perfectly the plotted points would form a straight line 45 degrees to the axis Example Appraiser Comparison X Y Plots COMPARISOH X Y PLOTS BY APPRAISER B
41. MEUM MINE 38 Main Men Sessa sata cassis T O 39 6 Table of Contents Organization of GAGEtrak s MenuG ssscsscssscssscesssscsssccssecesscncssecessccsnscssssecsssccssccssssssssecessccasensccansensssecensccanseesss 41 Enter Visw Records Mehta pidan a oda audae EE EU 41 REDONS ud 3010 PRSE TR ETT IU T ee 41 SOUP MENi n 41 Chapter 2 Gage ReEOLS 5 52 13 2 095 24a tas acus is caasa cua ch cca aaa anaa aaar aaa a A Deua a esae aaar aE 45 Entering Gage RECODGS i52 totu hada vo sc d ota PU a DNE RD TRUTH AER ONU Hoe cotes eee 45 Gage Ery FIG E acaso atn cud d C dm uM Ec M LN cu 45 Gage Entry Inforffiallon ics e tentes bao maU vacances tisk Osee Ups ad antec eee eia oa e NE ad 46 Gage Entry MISO y as rrr or Ec N LA MAL b rM Mar ace rn A E t uM eie mE 48 age Entry Standards A ELO APA TRAE QI Noo ID coni E b asi E Nude A IVA TR Eia ed iau 48 Standards Prefll EBU a sioe Ero EE OR e E MEL UNES e ee REUS VES NUN SE EAD TU NE 50 Gage Entry Pants P RTL RUN 51 Gage Entry Procedutes enu D ve cece cess a eui did Meus c Ur ouv eed coda AEA NENNE AAE AEE 52 Gage Entiry Scene dle eee 53 Gage RAR Schedule 2 uiti dod tee i De Ee nea De DOMI eR ain e Hu cius DNE D Id 54 Being Gage COORG Serre oer oed IM DL LN HEIDE tee 55 Cloning Gage ReGOFdS 4 5 5i epu mittam P deti terdum aeons anaes 55 esue Retukm LAG king Records oin etant i behoben Sce RR
42. Options Select boi poet descendi ot diae a d oie et SEED Ode o td oS Db 174 Defining Calibration Skip Dates tnt esae i OR ERO Re OBS Deci E ORO PON A A RN OREL PU NS ease eae es Los 175 AUIETESIL s itera bc tt Eo N AD ME EE 175 Set Up Users Se CU 5r ie die Ne V CTI OI OUO ON TINO GU Ote bae A ENS MAUI HI MIA EI DIM 176 Chapter o Other UtllItI8s 5 3 9 9 2 03 2 3 2 Eia IE a a 177 Remove spaces trom Gage DS iuam d p Rt n E E Ec M At cp n d ucc 177 Ser Status OF Dages eui retinent Dav ig Pen pM IE A oU du assests paca stale iussu tuve da d eb eU p edis mt qtu eL vor eiu 177 Backup Re5toFeLionce cette eq EMPORIUM NE Re E RO ERRINE 177 EdIt AUT LES ioi Ur Ou Eu deat rv te aa stis ba ras p e RU REDIT FAEERE d ME Ma e QUT ine UE 180 I II CES IR DIUTABE Cie 180 Set Up CA Service Regue s eee ta ed c tb ed e aec ota rd ada ione Ip uada edd eco ded 181 Archiive UnsAFCHIVe a ocn ettet ead A NM E MM DA DEM 181 Status EM os om matre b m Er oer cr M ME AI M EM US MC e 182 REDON ControblDB EDtey iae i rece i ee REEE E D leder Ue OD TEC E o e re Mos PRO ELTE A B UA E ere IVA DAE Gee ied 182 EDOM UNION eraan bcs asset ceqn tanta tu ebd LM eA Mo t Ep M sud 183 Reset Gage Ssue SEatUS 5o di cesses URL HEREDES A QU C e IDE Eoo IRR nna Cite E CU 185 Compact PRE elt Data 3s eut tu dtes Ee NERO G IHR ERE RONA 185 ResebAdjusted Frequenti S eio t a Matos etin E d b LOG Y ERE E UU RES RC RUIN DEL EDEN ORE Dee ON iu mu Pa 185 FIRE G
43. R sum square RR R amp R upper control limit S sum square SS appraiser x parts sum square SS appraiser sum square SS gage error sum square SS parts sum square TV total variation TV total variation sum square UCL upper control limit Total DF nx k xr 1 3x10x2 1 60 1 59 Gage Error Totpr App Por APpf 59 2 9 18 30 Sum All Readings 16 55 15 35 16 55 48 45 Sum Square All Readings 273 90 235 62 273 90 783 42 92 Chapter 4 Gage R amp R Entry Correction Factor for ANOVA CF SumReadings n k r 48 45 10 3 2 39 123 Appraiser Sum Square SSapp SSReading n r CF 783 42 10 2 39 123 0 048 Appraiser Mean Square SSanp DFapp 0 048 2 0 024 Parts Sum Square SSp PartsSumSquare k r CF 247 08 3 2 39 123 2 057 Parts Mean Square MSp SSp DFp 2 124 9 0 2286 App x Parts Sum Square SSap SumSquare TotalReadings r CF SSp SSapp 82 668 2 39 123 2 057 0 048 0 106 App x Parts Mean Square MS ape Sa 20 Fag 0 106 18 0 0059 Gage Error Sum Square SSerr SumSquare All CF SSap SSp SSapp 41 373 39 123 0 106 2 057 0 048 0 039 Gage Error Mean Square MSarr SSerp DF err err 0 039 30 0 0013 F Value M5ap MSerr GAGEtrak Calibration Management Software User s Manual 93 0 0059 0 0013 4 5385 F0 25 fromF Table 1 310 ANOVA Table Sue w ss mw
44. Resultas Fail The Attribute Study screen contains these fields and buttons Field Button Name Description Study Date This field defaults to the current date but you can change it Gage ID Select the ID code for the gage you re using in the study Gage Desc Once you select a gage ID the gage s description will appear in this field Trials In this field select how many trials you re going to perform two or three Study Type This field automatically displays Attribute you can t change it Co Part No In this field enter your company s part number for the part s used in the study Part No Select the number of the part used in the study don t meet the established limits such as no go fail or no Part Desc After you select the part number its description appears in this field Characteristic Enter a brief description of the aspect you re studying with this gage for this Pass Value In this field enter a description of how the appraisers should describe a part that meets the standard such as go pass or yes Fail Value You can enter a brief description of how appraisers should note parts that don t meet the established limits such as no go fail or no Result After you click Calc this field will confirm whether the gage passed or failed this study If it failed GAGEtrak will highlight this field in red Comments Enter any notes relevant to the study ApprarserA ang In th
45. S N MT 9887 0 Asset No 6 1 556 Model No AN 765 Description 12 Inch Ve Type Caliper Ar Unit of Meas Inch Drawing No AN 765 4 You can use the record selector bar a tall rectangular bar located on the left side of the form to select the entire record for copying or deletion You can also use it to save any changes made to the record if you change anything an icon of a pencil appears on the bar click on the bar to write your changes to the database Record Selector Bar Symbols Lr Current Record Record changed but not saved yet Ea New Record Record locked and in use by another user Navigation Buttons Use the navigation buttons located at the bottom left corner of the form to move through your records Each of the four buttons has an arrow on it that indicates its navigation direction 4 First Record Next Record Previous Record 71 Last Record Record Allows you to type in the record number that you want to go to Example If you have 250 records and you want to go to the sixteenth record enter 16 in the Record box then press ENTER to go to that record Scroll Bars Description Type 12 Inch Vernier Cal Caliper Analog 12 Inch Vernier Cal 1 Inch Gage Block 2 Inch Gage Block 3 Inch Gage Block You might see scroll bars on the right the bottom or both sides of a form Use them to go to portions of the form that you can t see Jab Selectors Information History Standards P
46. Tubes and Apparatus File Cabinet Labeling Calibration Instructions Dangerous Materials Notice Folder Labels Operating Instructions Warning Notices Equipment Maintenance Sample Submissions Floppy Disks Parts Bins SPC Capability Studies Equipment Identification Asset ID Labels Receiving Inspection Tags Inventory Employee Badge Labels Inspection Hold Tags Storage Bins Computer Cabling and more Important You can t use GAGEtrak to print your custom labels use the P Touch PC Editor program instead See the enclosed Brother manuals for instructions Appendix B Gage Calibration and ontrol This section discusses the basics of gage calibration and control it s intended for users with limited experience but it also serves as a review for more experienced users A list of references is at the end of this section Purpose of Calibration Gages test equipment and measurement standards are all susceptible to deterioration in accuracy during use and storage To maintain accuracy in your measurements you need an ongoing calibration system Calibration Terminology Calibration Unfortunately the terminology associated with calibration control is not universally standardized Typically the term calibration means placing a gage measurement standard or test instrument into a state of accuracy Calibration is also called re calibration or reconditioning Purchased Precision Standards Companies buy these high accuracy measuremen
47. Variation AV The appraiser variation is the part of the total GR amp R study error that is caused by the appraisers measurement method If the appraiser uses a poor measurement technique or doesn t know how to read the measurement instrument it can cause a large AV 68 Chapter 4 Gage R amp R Entry Part Variation PM The part variation is the part of the total GR amp R study error that is due to the parts being measured Total Variation TV The total variation is the sum of the equipment variation appraiser variation and the part variation In general the TV should be less than 10 of the total tolerance If the TV is between 20 to 30 try to decrease it by using cost effective methods such as training to decrease the error Beyond 30 TV you should work to correct the measurement error A TV larger than 3096 causes problems because it might cause you to judge good parts unacceptable and mistakenly accept bad parts Gage R amp R Entry Menu Select Gage R amp R Entry from the Enter View Records menu to access the Gage R amp R Entry menu amp Gage R amp R Entry Menu Jol x Linearity Stability Attribute ANOVA Exit Click the menu button that corresponds to the study you want click Ex fto return to the main menu We ll discuss each type of study next Tip You can also run GAGEstat by clicking the Gage R amp A button in the Calibration Entry screen Running GAGEstat this way restricts you to entering ga
48. Z Zoom in or out for a magnified view of part of the page C or ESC Cancel Print Preview To view different pages in Print Preview when zoomed out F5 Go to the page number box enter the page number you want to see and press ENTER PAGE DOWN or Move to the next page when zoomed out DOWN ARROW END Move to the last page PAGE UP or Go to the previous page when zoomed out UP ARROW HOME Move to the first page To view different parts of the current page using the zoomed in feature DOWN ARROW Scroll down in small increments PAGE DOWN Scroll down in large increments CTRL DOWN ARROW Go to the bottom of the page UP ARROW Scroll up in small increments PAGE UP Scroll up in large increments CTRL UP ARROW Move to the top of the page RIGHT ARROW Scroll to the right in small increments CTRL RIGHT ARROW Go to the right edge of the page or END CTRL END Move to the lower right corner of the page LEFT ARROW Scroll to the left in small increments CTRL LEFT ARROW Move to the left edge of the page or HOME CTRL HOME Go to the upper left corner of the page GAGEtrak Calibration Management Software User s Manual 115 Output To Send The Output To command from the File menu allows you to transmit reports to a text file Microsoft RTF file HTML or Microsoft Excel spreadsheet file If you save a file in RTF format and then open that file in a word processing application such as Microsoft Word your data will have the appearance and
49. acer eb E ea v b Rt NER Rt Na re A UN pe eu oan denne 142 Inventory and c LAS SICAL OM seu inita E EE DRE ED b CN RON TE A Mita Re ieu RU TEE D 142 Caubration Schedules 65 a ee latin o RUD Him i cH rm eR T E 142 Calibration Practice Ss erii ho DO a d GHI M Dd EI m NM NS 142 Kererences conde D MEI MEA M EM ME 143 Resources for Books Publications and Reference Materials eee eee eee eee eee etn nete eenun 143 System Administrators Guide eia oci tco voa N S ivan EE ard REN E aou WEARS Qva SU cRCbM cue pr tip cR Br Ole 145 Chapter T IristallatlO Di edicosd oci eis taa ane nn fio nt tene MPP ta Der Soe th nner ne EE ap de ene Sere vn eet iE 147 Program Fe CIN emensus NEUE FR M E 147 luz 147 lal PRO T T TN T G 147 Important Note for Oracle USGers 2 d tha o oo i E but d a d to Ead Pat De recs UE 147 DIE Ee MOMENI T 147 Alter Youdpnstall GA GEEK ooi Ren Or e SO Ex ve NS X DEI SO Od NIE va uas be ot deme 153 Adminstrator Installsllofy doo ero eiat es eee eret nete oe pie deem tea eee epa even cono dev ep ce nie ica bi demo ies 153 Corimgurauon Ele Setting S cutus de dudo rue Aca ELO OIL DU 154 Sample ConfigiralloDis o er ren en e a n Pee Never tpn runs bre pues po es eei rey mr tasa m M hase yy reve EDI 155 Chapter 2 Oracle Iristallationh ici iri uas uar vacki con cci tin C en i o uds 157 Setting Up Oracle Tools 5e o wed saad aves de oe de eie edu aid dei c ei Poi ut
50. and Embedding This means that you can link any valid Windows object such as a graph picture or digitized movie into this field When you double click in the OLF field the Insert Object box appears and you can select the program in which you created or will create the object Note The list of object types varies depending on which programs are on your computer Insert Object 2 x seca Corel PHOTO PAINT 5 0 Image Media Clip Create New C Create from File Microsoft Graph 97 Chart Result 1 Inserts a new Bitmap Image object into your document Use the scroll bar to select the type of object that you want to link then click OA When you select an object type the program in which you created the object opens so that you can edit the image if necessary When you re finished just click inside the object to insert it and return to Procedure Entry 106 Chapter 6 Calibration Procedures Chapter 7 Service Requests You can use Service Request Entry to track and print service requests for both in house and outside service providers More importantly you can use it to document track and report on corrective actions that you ve issued for failed or malfunctioning gages Select Service Request Entry from the Enter View Records menu and the main entry screen will appear amp Corrective Action Service Request Entry EX Delete Exit CA RequestNo 1 Preview Letter Request
51. appraisers then measures the ten parts Make sure that you randomly mix the parts before each appraiser measures them Each appraiser should measure the parts at least two or three times trials Tip In Long Form and Short Form gage R amp R methods maintain part number traceability when you record the measurements For example record Appraiser A s part 8 measurement next to Appraiser B s part 8 measurement In order to use the software correctly you should gather data for at least two appraisers performing one trial of 2 10 measurements each If you use one trial of measurements then the program uses the Short Form method for calculating gage R amp R results This method will not divide the R amp R results into their AV and EV components If the part size is quite large or parts aren t readily available then use this alternate part measuring sequence 1 Randomly select the first part to be measured 2 Let Appraiser A measure and record 3 Next Appraiser B and Appraiser C measure the same part 4 Finally randomly select another part and repeat this sequence until the appraisers have measured all ten parts If the appraisers that you re using work on different shifts you can use this sequence 1 Appraiser A measures the parts randomly and someone records the results 2 Appraiser A re measures the parts in a different order and records the results 3 Finally Appraiser B and Appraiser C measure the parts on their own shifts T
52. arrow in the Sort row to select a sort option If you sort on multiple fields the program sorts on the fields you specify in order from left to right Tip You can also sort on a hidden field Minimize the Filter window 5 Select Apply Filter Sort in the Records menu this menu is available while the Filter window is open but minimized To undo a sort click on the toolbar s ter button and clear the filter values then click the F nd button Entering Filter Criteria In addition to sorting you can enter a criteria expression to find only those records that match your specific conditions Enter criteria expressions into the Criteria cell row and optionally into the Orcell row If you re using field names in the criteria expression choose only those fields displayed in the field list you must spell the field names exactly as shown Criteria Expression Examples Field If You Enter GAGEtrak Will Find Description Caliper Gages with the description Caliper Description Caliper Or Micrometer Calipers or micrometers Next Due Date 3 2 2000 Gages due on March 2 2000 Field Next Due_Date Current Location Current Location Next Due_Date Next Due_Date Next Due_ Date Description Description Gage ID If You Enter Between 3 1 2000 And 3 31 2000 In QC Lab Receiving Not QC Lab V Datel 30 Year Order Datel 2000 DatePart q Next Due Datel 24 Like C
53. below use the table s horizontal scroll bar to view the fields on the rightmost side of the table Field Name Description Sub Use this number to identify the subgroup usually you will start with 1 then go to 2 then 3 and keep using consecutive numbering However you can also use letters such as M 100 M 200 then M 300 Date In this field enter the date on which you measured the repeated readings 1 through 10 Enter the actual measurements taken on the master or master part For example if you re taking a sample size of five repeated readings enter the first reading in field 1 the second in field 2 the third in field 3 continuing up to field 5 In this example fields 6 through 10 remain blank R In this field you ll see the range for the sub group the largest reading minus the smallest reading This value is calculated you cannot change it S GAGEtrak calculates the standard deviation for the sub group only when the sub group size is five or more You can t change this value Xbar X In this field you ll see the average arithmetic mean for the sub group This value is calculated you can t change it Notes Record any comments in this field Printing the Stability Study If you want to print the Stability study data select File Print from the top menu bar Tip If you want to print just the data for a single study first preview the report on screen and make a note of which page numbers pertain to
54. bias variation over time is more stable than the one with higher bias variation You can quantify these total bias variations but not until you can demonstrate that both systems are statistically stable 82 Chapter 4 Gage R amp R Entry Control Charts You can use control charts to determine statistical stability Control charts help you differentiate common cause variation variation due to causes affecting all measurement results from special cause variation variation that is the result of specific conditions When using control charts you should look for both points that fall beyond the control limits and for other Special cause indicators such as trends and centerline hugging The existence of these factors indicates out of control or unstable conditions You can find control charting methods and interpretation guidelines in texts on quality and statistical process control SPC The method presented here for studying measurement system stability is to plot the average and range of repeated master or master part readings on a regular basis For example you might conclude from this analysis that an out of control signal is a sign that you need to calibrate your measurement system Calibration of the system without any out of control signals is likely to increase the variation of your readings If the master or master part is dirty you might see an out of control signal Your knowledge of the process is the basis for your interpretation of
55. compact the GAGEtrak 4 2007 database 204 Appendix C Database Management Appendix D System Maintenance and Troubleshooting Date Formats GAGEtrak supports all of the available numeric date formats within Windows For example you can represent the date of November 1 2000 as 11 1 00 11 01 00 11 1 2000 00 11 1 00 1 11 or 2000 11 1 Because GAGEtrak s reports use only numeric dates you can select only numeric date formats Therefore you can t use dates like November 1 2000 or 1 November 2000 As a precaution you may want to verify your date settings in Windows Control Panel Select Start Settings Control Panel then run the Regional Settings icon The date formats that you enter into GAGEtrak must matchthe Windows date setting otherwise errors will occur while you re running the program The sample screen shows the most popular format used in the United States Regional Settings Properties l2 1 x Regional Settings Number Currency Time Date Calendar type Gregorian Calenda Y po ee Short date sample 09 30 1998 Short date style MM dd yyyy Date separator po rz EON END Long date sample ednesdav 30 September 1998 Long date style dddd dd MMMM s H Maintaining Your Hard Drive We highly recommend that you run the Windows ScanDisk and Disk Defragmenter utilities to keep your hard disk running smoothly Run ScanDisk each week to clean up cross li
56. cycles used or parts measured by the gage GAGEtrak adds Cycles this value to any previous cycles for the gage then uses that value to calculate the Next Due Datefor gages that you calibrate according to cycles Notes Record any important comments such as damages or malfunctions Next Gage If you have other gages to return click Next Gageto process the record Exit When you re finished click the Ex f button to return to the main menu GAGEtrak uses the following rules to manage Issue Tracking records 1 When you issue a gage GAGEtrak inserts the current date and time as the issue date and time It also changes the gage s Current Location field to a description that consists of ssued To plus ssued Dept for example 675 Job 7512 Final Assy 2 GAGEtrak assumes you want to return a gage if its current record is incomplete After you enter the Received Date and Time and save the record GAGEtrak changes the gage s Current Location field to its storage location Chapter 10 Reports GAGEtrak includes a large variety of standard reports To generate reports go to the main menu and select the Listings and Reports menu Ej AE tak 4 20 7 Your Company Name Your Division Reports Listings and Reports Open Calibration Reports Calibration History Reports Fart Reports R amp R Reports Miscollantous Reports Customizable Reporta Lever I Atkri Ca TWwASNGTS npin Like some of the entry screens each
57. eee ect ora EA i bends as Fe Uo EDU EE edes CERE EET OSA DEN oss CFTE EU VES 22 Gage Entry SchBdule us dried ELO de raa deo dn rei uH HA edes eI TUE LUUD IN LATIN R des seus uaa do DS O epa DU ERE ETI CNN EU 24 Gage Calibration Schedule 559 dn dava cta HO Ta ee C an V bn Dd o tee ensa c Tog cedes uE 24 Cloning Gage ReGODGS Soo nee cp eR ado GR D Aa PM DLE Rn TET woes O OR I ete RIP DN OT SRT er MrT COUR Tr 25 Other Dage Entry OBlHOns ostia ho ERO o tad EA Fetal ase sli ra T 25 Chapter 5 Entering Calibration Records inae i ex eeti exte aeaa cog egeta ev ce Dv 27 catibraton RB ED LED G 27 Calibration Measurements RR TT s 29 Chapter 6 Issuing and Returning Gages eere Leer L LLLI L I ere serere nnmnnn nannan nnn nnne 31 Gage ISSue and REU Merienn er e E E UE A aia R Rives 31 Gage i e HIP pP 32 Gage Retur Missa oe tassel gaa eae acess a oe AT aa acu cee eats sean beans AT 32 Chapter 7 Conclusion 5 252 ioana aaaea aaa Oaea seewncoeseeseccastesencdavanseiensusuedcveioueice 33 User S LI TL epe iaa aa aa aab ia a a ai 35 Chapter Staring GAGEA K s coeunt oon sen atewat wa vavenvesenet tae aac cana gru recu cene cue sunset aestus 37 Iristalling GAG Eran 6i oro REO E nbi va D eee enone een Mu EN acetals 37 RUNAMI CADETIK asean tato re erie coca trado men ret fe ciertas oido A TES DM TUN I IUE OM EDU 37 CAGEFIK LOGON RENE RR c S 38 GAGEtrak Serial NUMBER onore E eee E ec uE A M ME MM
58. field stores any other data you need to track Manufacturer Select or enter the manufacturer of the gage this field creates its own list as you enter different manufacturers so you can later just select from the list Owner This field also creates its own list as you enter different gage owners Resolution Use this field to store the resolution of the gage This is the smallest or least count unit of motion that the gage is capable of measuring and displaying For example 0 001 is the resolution on a typical dial caliper Tolerance Use this field to store the upper tolerance for the gage as published by the manufacturer GAGEtrak later uses this information to calculate the maximum value for calibration standards To enter this value as a percentage of the nominal enter the value followed by the percentage sign for example enter 1 Tip Check the placement of decimal points for example 1 equals one percent 1 equals one tenth of a percent Tolerance Enter the owertolerance for this gage as published by the manufacturer use a positive value GAGEtrak later uses this information to calculate the minimum value for calibration standards To enter this value as a percentage of the nominal enter the value followed by the percentage sign for example enter 1 Tip Check the placement of decimal points for example 1 equals one percent 1 equals one tenth of a percent Calibration To go to Calibration Entry for this ga
59. for security purposes 5 Your screen should look similar the one below shown set up for an Oracle version When you re finished click OK 154 Chapter 1 Installation amp Open Database Ea Browse Database Use ODBC Use DSN Use File DSN Database Name DSN File DSH User ID Password GAGEtrak GTDATA40 MDB X Vv Iv Required Fields 4 GageMGR Oracle GageMgr T GageMgr Lr 0 5 O O Driver as Server I Ss Service Name EE Database Attribute lE Application Attributes NENNEN Prefetch Gount Transation Option 3 Translation library Name Configuration File Settings If you want to reconfigure your G_CONECT INI file follow these guidelines Note The brackets 4L x contain instructions about the information you should enter after the equal sign 2 on each line Database dbType 0 for a Microsoft Access Database 1 for a client server database UseDSN 0 for No 1 for Yes used only for client serverl s UseFileDSN 240 for No 1 for Yes used only for client server File Name of the database file used for Microsoft Access Database Path Path mapped drive or UNC to the database file used for Microsoft Access Database s DSN Data Source Name for the database used for DSN FileDSN Name and path mapped drive or UNC of the DSN file used with FileDSN S Driver J Driver name only if not using FileDSN or DENJA Server
60. for the gage and you re ready to enter its calibration standards Because you will electronically check this gage at incremental intervals during calibration you use GAGEtrak s Calibration Standards Prefill feature to automatically create the eight calibration checkpoints required You ll need a new procedure for calibrating too You use Ca Pro a database of step by step calibration procedures that covers everything from gage blocks to micrometers and calipers Thanks to Ca Pro you don t have to waste time researching or creating calibration procedures You can simply import the procedures directly into GAGEtrak Using CalPro also helps your company comply with ISO 9001 and QS 9000 quality standards INDEX OF CALIBRATION MAEDLIILES After lunch you spend the afternoon calibrating some gages yourself One of the gages you calibrate is the new electronic gage you received this morning The output from this gage is transmitted through one of the serial ports on your PC You re using the Software Wedge program to capture this real time data and automatically insert the gage s measurements into GAGEtrak s Calibration Measurements screen Once you ve finished you use the GAGEtrak Calibration Label Kitto print out a calibration label for each gage These laminated durable labels are oil and water resistant and they re easy to print and apply to your gages E Calibration Entry G M WxlL H aWx z2L lL 8Wx3iL Preview Tape Catalog
61. formatting of the GAGEtrak report that you exported If you output to a text file all of the data will be present but the formatting will be lost Output to an Excel spreadsheet is the best option to select when you wish to export a report created from Datasheet view see page 131 such as the Customizable Gage Report or Customizable Calibration Report see the description for these reports under Report Descriptions The Send command from the File menu allows you to output reports to Microsoft Mail or any MAPI compatible mail program The output includes subforms and subreports The file format and appearances are the same as those described above for the Output To command Print Setup Select Print Setup from the File menu if you want to change report settings such as orientation Portrait or Landscape or margins Some options are controlled by the type of printer and Windows printer driver that you have but a typical setup window looks like this Page Setup Tx Margins Page coums Margins inches Top 0 5 Bottom pos Left foe Right fos Print Data Only Tip To save paper and time first view the report on screen and then adjust the print setup values You ll see any changes on screen after you click the OA button When you close the report window the program will save the new settings 116 Chapter 10 Reports Report Descriptions This table
62. needs maintenance 2 the gage needs more rigidity 3 the location of part to gage should be improved Total Measurement Variation You can classify total measurement variation into five categories which we ll discuss next including definitions and examples 1 Accuracy the difference between the average observed measurement and the average true measurement of the same characteristic on the same part Example The calipers are off by 001 on all the measurements Gage Accuracy True Measurement Observed Avg Measurement 2 Linearity difference between accuracy values throughout the range of the gage Example The calipers are off by 001 when closed but are off by 002 when fully opened Avg Gage Linearity Largest Accuracy Smallest Accuracy 3 Stability the difference in the average of the gages measurements over time Example Calipers are subject to wear deterioration and environmental changes over time If you use the gage infrequently and calibrate it before each use then you can calculate the stability at the same time as the R amp R study To do this you must calibrate the gage before and after each trial Record the calibration change for each trial for example the gage was off by 002 before trial and off by 005 after trial then calculate the difference between the largest calibration change and smallest calibration change for that trial 005 002 003 The result is the stability for this trial
63. networking protocol that your company uses and click Next Oracle Net8 Service Name Wizard TCP IP internet Protocol SPX NetWare Networking Named Pipes Microsoft Networking Bequeath Local database IFC Local Process Piian 11 Enter your Host Name the name or IP address of your Oracle server and Port Number Click Next Oracle Net8 Service Name Wizard Pel ta GAGEtrak Calibration Management Software System Administrator s Guide 161 12 In the next Wizard screen enter your Database S D usually ORCL and click Next Oracle Net8 Service Name Wizard c E m sie vl j E ORCL ul Ficia 12 In the last Wizard screen click the Fin sh button Oracle Net8 Service Name Wizard 13 From the File menu select Save Network Configuration 14 When yourre finished close the program by selecting Exit from the File menu Create Data Source Name DSN for Oracle Next create the data source name DSN for your GAGEtrak 4 2007 Oracle setup 1 Click Startand select Settings Control Panel Double click the ODBC icon The ODBC Data Source Administrator window will appear 162 Chapter 2 Oracle Installation 2 Goto the System DSN tab ODBC Data Source Administrator Oracle_GageMar 3 Click the Add button You ll see a screen similar to this one f Create New Data Source B Microsoft Excel Driver xls 4 00 3711 08 Microsoft FoxPro Driver dbf 4 00 3711 08 Microsof
64. new fields and tables have been added to GAGEtrak 4 2007 new client server users need to run it in order to transfer the prefilled settings such as status IDs to the client server database If you re a new user with an Access database these settings are already in the database so you do not need to run the DTU After you run the DTU your records will be in both your old and new versions of GAGEtrak However don t use your old version of GAGEtrak enter all new records into GAGEtrak 4 2007 187 188 Appendix A Data Transfer Utility Client Server Versions Before You Run the DTU If you re using a client server version of GAGEtrak 4 0 You do not need to run the DTU to use version v 2007 as the ODBC schemas are identical only the Access backend database has been upgraded to Jet 4 0 Access 2000 If you are a new user of GAGEtrak version 4 2007 Client Server you must run scripts to set up your database and tables before you transfer your data To do so click the Aun Scripts button on the main DTU screen E Data Tansee Weility Weis 4 AUD i Jata Base Destination Da TREH quc Varin LC Dala The Run Scripts screen will appear The table below contains information about the fields and buttons in this screen amp Run Scripts Field Button Name Description Script Fath and This field contains the location of the Scripts file for the current workstation It defaul
65. of your file this may take several minutes to complete Network users should make sure that no one else Is running GAGEtrak when someone is performing this operation If you cannot open your GAGEtrak database click the Windows Start button select Programs choose the GAGEtrak 4 2007 program group and run Compact Database If you have copied or created a Compact Database shortcut icon on your desktop see Appendix C you can double click it to repair and compact your GAGEtrak database If the error message persists when you re trying to run the program contact Technical Support immediately at 480 922 7300 for additional instructions Duplicate Value Error Message An error message may appear if you enter two records with the same key field values Duplicate ID Gage ID can not e duplicated You ll receive a similar message if you enter o two gage records with the same gage ID o two calibration standards with the same name for the same gage o two procedures with the same procedure name for the same gage Oo two calibration standard ID names on the same calibration record two supplier records with the same supplier code o two procedures with the same procedure name two parts with the same part number If an error message appears click OK then click the Undo button or choose Undo from the Edit menu GAGEtrak Calibration Management Software System Administrator s Guide 207 Previewing or Printing Reports Error Me
66. somewhat above the standard in question The gage passes the study only f all of the measurements agree This means that each appraiser s measurement must match those of the other appraiser for each part for example if Appraiser A finds that part number 8 failed then Appraiser B should also find that part number 8 failed If the appraisers measurements are different for even one part you should take steps to improve the gage s performance and then re evaluate it If the gage continues to fail this type of study or if you cannot improve it you should discard and replace the gage 86 Chapter 4 Gage R amp R Entry Attribute Study Screen amp Attribute Study x r4 Record 1 1 gt ot r of 1 Study Date 08 25 1999 Gage ID 22k Digital Caliper 0 6 Gage Desc Caliper Study Type Attribute Pass Value Pass Fail Yalue Fail Result Comments Co Part No 10 221 1 Part No 10 221 1 Part Desc Bracket Rt Hand Characteristic Length Appraiser A JON 1 Pass 2 Pass 3 4 Pass 5 Pass 6 Pass 7 Lz g iPass g Pass 10 Pass 11 Pass 12 Pass 13 Pass 14 ass 15 LEE 16 Pass 17 Pass 18 Pass 19 Pass 20 Pass ew elete Close Appraiser B Pass Pass Pass GAGEtrak highlights the non matching measurements in red as you can see in the screen above For this study when you click the Ca c button the program will display the
67. stores information about how to connect to the EX indicated data provider A System data source is visible to all users on this machine including NT services Help OK Cancel 3 Click the Add button You ll see a screen similar to this one Create New Data Source Select a driver for which you want to set up a data source Name Version C Microsoft Excel Driver xls 4 00 4202 00 Microsoft FoxPro Driver dbf 4 00 4202 00 Microsoft OD3C Driver for Oracle 2 00 00 6325 Microsoft OD3C for Oracle 2 573 4202 00 Microsoft Paradox Driver db 4 00 4202 00 Microsoft Text Driver tst csv 4 00 4202 00 Microsott Visual FoxPro Driver b UU 544 UU zozzzrzzzzx Oracle ODBC Driver 8 00 05 00 3 70 06 90 163 164 Chapter 3 MS SQL Installation 4 Select the SQL Server ODBC driver and click Finish This screen will appear Create a New Data Source to SQL Server 5 Enter MSSQL_GAGEMGR for the data source Name In the Description field enter a brief explanation about the data source After you enter the name of the MS SQL server click Next This screen will appear i Create a New Data Source to SQL Server Enter the Login Dand Password for your SQL server then click Next You ll see the Configuration screen If needed change the default database check the box next to this field and enter or select a new database 10 GAGEtrak Calibration Management Software System Admin
68. the control signals To determine the sample size and the frequency for a measurement system control chart you should have an in depth knowledge of the system and focus on the conditions to which the system is exposed during its use If for example you are certain that the system s users allow for sufficient warm up time before using it don t take samples before the warm up period Also when you re designing a measurement system control chart make sure that the time at which you take the samples of master or reference value isn t introducing bias into the results For example samples taken only after morning calibration might not represent the usual conditions to which the measurement system is exposed As with any control chart out ofcontrol signals might exist because of problems in the sample size and frequency so it s important to carefully design your control charting techniques As mentioned before to find more information on control chart design look in SPC publications You don t need to calculate a measurement system stability number You can use indices to measure progress but you can use a control chart to view the system s progress The elimination of special causes from a process might improve it making it more stable You can see more improvement in the reduction in the width of control limits which indicates that you ve lowered the system s common cause variation Training and education on statistical process control theor
69. the study Then when you select the Print command enter the range of page numbers Otherwise all of the studies will print 84 Chapter 4 Gage R amp R Entry Generating Stability Control Charts To generate a Stability Control chart click the Chart button You ll see two control charts The top contains a control chart of averages and the bottom contains a control chart of ranges For easier interpretation the program draws control limits and average lines on each chart Example Stability Control Chart STABILITY 2 y 9 yy yF XM 9 ye ov y v 9 49 yf v y x P a i T os os os ost T wr Pa t y ot et d y Y Oo BE Calculated Average Control Chart Fields Field Name UCL AVG LCL Description From your measurement data GAGEtrak calculates the upper control limit for the averages and displays it in this field This field shows the overall grand average value GAGEtrak calculates the value for the lower control limit for the averages from the measurement data that you entered Calculated Range Control Chart Fields Field Name UCL AVG LCL Description From the measurement data that you entered GAGEtrak calculates the upper control limit for the ranges and displays it in this field This field shows the average range value GAGEtrak calculates the lower control limit for the ranges based on the measurement data that you entered Printing the Stability Control Chart To print the S
70. tos p pA Rd tx c e Ee cddk 157 Astal Oracle TOO Sisir sso coti ai bsc Po dh Dav adc oc nel va ca tn casio E aM M M 157 install Updated Oracle ODBC DEOIVBES oreet er Er UO ERES ERE OI Oo ve Cou erui tei endi baa T ac X TR ES IE DUE 158 Configure SQLNet with Oracle Net 8 Assistant eee eee esee eene eene tenete tenet tn eines east eas tns tas etas e sas eaa etae 159 Create Data Source Name DSN for Oracle cscsscccssessssesssscsssscsssscessscessscessecessecessscessecessecessecessscesssceessceesseees 161 Chapter 3 MS S LInstalldlOliosinsce i eu rive vx Ovi ovv xiva Yu vi evo ux Vua ra rv vua ev veuve 163 Create Data Source Name DSN for MS SQL eere eere eere einer enne ener rn eee rs e ease tasse sane ease ease passe pae 163 Table of Contents 9 Chapter 4 Running GAGE UE AK ui aree xerox avo x Rev rv cvv vd rv 167 ols aq emmromer EET 167 Sera NUTIBOES oss lt tecesssaseceescsiccasscaseceyacsesecateaseceslsnecseseuenceseoeosactonsesaceoeceiucsunscaucda E 167 licenseand Irial Perlod 5 ood Irt cad et eno tis Rd n1 oU en ees s eoe aieo otia tovto ven ae aen ek ep e eere ess 168 Main MoN TENET 169 Chapter 5 Setting Up GAGEUIrakK sisticcecesivcsacestvcraccstvesacsstvenacsntvesaceatvenscsatvectviedenstncdencctnctlacstecdsaccies 171 DADEtrak Seting Somena a a uper lat eiut fia 172 Generat Preferences SelecHObis ssec o Dae o Scr f eO dris ER RI TUM dU EDS A NN RUEEU 173 Calibration
71. traceability For example if you find that a gage is out of tolerance you can immediately generate a part recall report listing all parts that you might have measured incorrectly Note You can also issue or return gages one at a time via Gage Entry s ssue Return button however Gage Issue and Return is designed for consecutive gage issues returns and to facilitate bar coded data entry Both screens operate in the same way To issue or return gages go to the Enter View Records menu and select Gage Issue and Return Click ssue Gages and this screen appears Issue Gages Gage ID Next Due Date Issue Date 09730 1998 Issue Time 3 38PM Type ProductionUse mj Issued To es gf Issued Dept Job 7512 FinalAssy Part No 6754 CPA 573 m Storage Location TodCb Bini2 Curentlocation TooCib Bini2 Received Date Received Time oa Received From RI Cycles Notes ha 31 32 Chapter 6 Issuing and Returning Gages Gage Issue The Gage Issue fields are as follows Field Button Name Description ssue Date and ssue These fields track the date and time on which you checked out the gage Time They re prefilled with the current date and time Type Select the type of issue this field creates its own list from your entries Issued To Enter the name of the person to whom you issued the gage Issued Dept Use this field to track the department or job number that will use the gage Part No Enter the n
72. uS 113 Viewing REPO CS 5d nd tener nbi eie A E URN n ep Unde e GE NER NE UR CUI c ecol xE rV HDD NOE Ee 113 nop om PO 115 je P M S 115 PENCO UD oia pinea de ert e p d Mo RV eU saat Ba ar unt nS oro AT Lobo on p CASSA 115 Report DESCHIDUOIMNS diei tr REED bh pen oi v Dn tb ito E tr se ERN cta rel Pereira COS ICE Us 116 Chapter 11 Program Conventions Leere LL Le LI Le Lec ee nnmnnn nnmnnn nnmnnn mannanna nannan 119 CSAS EUAN Help ica re tete Ru Ibit Eoo asd etus Mast cM acd tior eM auod ur uelut ER 119 Record Filter WIHdOWSs sand pe taie Ie m am dm imu uA cde Capi ET 119 Accessing UU RSC ORCS o Somn notas ntu aen tomb Cer CHA Eam E 120 ACCESSING Certan REG ORAS io eR LA td te re potere EA etes ol se eet oda e vendor oghautedsstsaeetsaasas iei Le o RARE N 120 Supported Wildcard Characters in Search Fields 4 eee eee ee tette teens eere teen en en atte tn east e tasas tne ts sns n essen epae 120 Floating OOF ten C e 121 Pop Up Calendar Tor Date Fields onec tt tee ea eee bete nt rU eb e Ta seed e NEU PO oce d o ve ERU Ee Vie dU ING 121 FORM VISWSIDDISeCOFGS 5 cse o b b oto pet D CDM ID M EIU REO UIS TCI REEL eSI 122 Elements of d ReCOPIPBOEITIG od Sa eic tme a und Tet edd cH EE A I Ta d pK T MH RHS E ARE CPU 122 Datasheet Table Views Of RECON AS us
73. uses less memory If you can view your logo in the Settings window but it doesn t appear on your reports you don t have enough memory for the logo size in bytes that you ve used Exit To save your changes and return to the main menu click the Ext button Cancel Click Cancelto return to the main menu without saving your changes GAGEtrak Calibration Management Software System Administrator s Guide 173 General Preferences Selection A Settings Imm x Userinto General Cal Options Skip Dates Audit Trall Reports Printers Colors Allow Save of Print Setup Exit Options Cancel Format Reports Floating Tool Bar w Open automatically Field Button Name Description Enable Auto Check this box if you want the Calibration Due Report to automatically pop Cal Due Report up when you open GAGEtrak This report shows gage IDs that are due or past due You can print the report or close it to continue into the program A message will appear if you don t have any gages due for calibration Allow Save of You must check this box if you want to save changes to print setup options Print Setup Options such as margins If you ve enabled Allow Save of Print Setup Options you can also change and save which printer will be used for a form or report To do So go to the Print Preview version of the form or report and designate the printer as the Specific Printer 83 Setiags For Fieprorts Ei Format Reports
74. will show you the last cloned record that you created and you can enter each clone s unique information 56 Chapter 2 Gage Records Issue Return Tracking Records When you need to check a gage out to a different Location or department you can record the issue in GAGEtrak This feature is particularly useful in a gage crib situation where gages and inspection equipment are loaned out and then returned for storage and safe keeping By tracking this information you ll know which gages your company uses most often and which employees or departments use them To check out or return a gage click the ssue Return button at the bottom of the Gage Entry Information screen The Issue Tracking Entry screen will appear Tip You can also issue and return gages by selecting Gage Issue and Return from the Enter View Records menu However Gage Issue and Return is designed for consecutive gage issues or returns for large batches of gages and to facilitate bar coded data entry Issue Tracking is designed for issuing or returning a single gage Please see page 117 for information on Gage Issue and Return rrr img baer mH I Fg ma ales ial t You must use Issue Tracking records for any gage whose calibration schedule is based on usage or cycles instead of elapsed calendar days These records track usage days and operating cycles they also update the next due dates of gages with usage frequencies If you consistently use the Part No field you ll c
75. 00 Source AIAG Measurement Systems Analysis Guide 89 90 Chapter 4 Gage R amp R Entry Readings Appraiser A Part Trial 1 Square Trial 2 Square Sum Sum Square 1 0 5 042 0 0 036 125 90278 4 o8 07 2095 090 18 160 6 100 100 100 100 200 X 200 7 095 X 090 095 090 190 180 8 o8 07 o8 064 165 t SH MEME a o e BH eee 7 70 C a 1430 085 7 14 7 13 Total 16 55 SS Fotal 14 27 Appraiser B Part Trial 1 Square Trial 2 Square Sum Sum Square 1 085 030 tt 6 2 10 100 X 095 090 200 3 080 0 4 075 0560 155 120 Ap 080 0 4 X 075 o t155 120 al 040 owe 040 016 080 oa po op 10 100 105 100 205 210 7 09 209 2090 oO8 JH 85 7 8 075 056 o070 049 145 105 too 100 095 X 090 195 190 6 60 6 03 Total 2 15 35 Sum Square Total 12 63 Appraiser C Part Trial 1 Square Trial 2 Square Sum Sum Square Cak q00 OT om L 71 95 09 CD0s 990 20 5 7090 8 wa 0 4 080 X 0 4 160 128 085 072 080 ya 388 Tee Total 16 55 Sum Square Total 14 40 Legend AV appraiser variation AV appraiser variation lower control limit AV appraiser variation su
76. 41 Sf o199 013 0 1338 oss9f 01339 01339 o1ca2f 01341 0 1341 amp of 0133 01335 om3 01336 03433 oaf 0 1348 0 1341 Bl 7 oaf oaf 0134 oaf oaf 0 1341 orcas 01341 f 0 1342 EI ef o142 oaf 0 1341 o1 42 o1342 0 1342 o1catf 01343 f 0 1344 gf o134f off 0139 f o134f o134f 0134 f o1cazf o1343f 0 134 of o1342 o 1341f 0134 013427 0 13427 01342 oma f o1342 0 134 Repeatability Reproducibility Part Variation EV AV PV Tol 122 To 1369 eto 1859 Rbar goi Tek 18 3 we 9 amp ww mme wore UCL ome wm 700 PART REFERENCE VALUES 1 2 3 4 5 6 7 8 9 10 er ey ree eee ee ee ee ee Ii amp R Total Variation Gage R R amp R Average and Range Study Screen The table below explains each of the fields in the Average and Range study screen Field Button Name Description Study Date This field shows the date of the study defaults to the current date Gage D Using the drop down list box select the ID of the gage Gage Desc This field shows the name of the gage or measurement device Appraisers In this field enter the number of appraisers used in the study Trials Enter the number of measurement tests that each appraiser performed either two or three Study Type Select the type of study Long or Short and the method used to calculate results such as AIAG GM Ford or Chrysler Comments Enter any comments you wish to note Co Part No You can enter yo
77. AGEtrak You can find this code on the CD envelope that came with your software package Tip If you don t have an install code leave this field blank Enter Install Code GAGEtrak Calibration Management Software System Administrator s Guide 149 1 Now the installation program will tell you that you will be choosing the location for the program on your hard drive Since this location is specific to each workstation do not select a network location We recommend using the default directory C GTW4 2 Unless you re using the program with an Oracle or MS SQL database the installation program will now let you select a location for the GAGEtrak database If you are using GAGEtrak in a client server environment skip to step 5 Program Location The ret Form allows vou to speni where the GAGE tra 4 0 2007 prograen vell be iritaled Cho nior specsfy a nereiork location tis pecsomimended tag pou accept the deta location C Program Files IST W 4 2007 AS Lhonze Program Localia Setup wil ratal BAGE irsk 4 2007 in the folovang folder To niii into a diluat folder ch Browee end select anahe Folder You can chocs nior Eo install GAGE rak 4 20077 bu clicking Cancel to ext Setup If you are using the program on a single workstation select the default directory C GTW4 If you have a network license of the program and are using it with an Access database click the Browse
78. Accuracy deterioration usually results from gage usage less often it results from the passage of time The most common methods for determining calibration schedules are E elapsed calendar time the most popular method it establishes a fixed calendar time such as 90 days as a checking interval actual amount of usage time and cycles based on counting the number of days or operating cycles for which the gage was used you can keep this count manually or automatically actual operating time an excellent method for electrically driven gages a device used for measuring actual operating time is called a coulometer Calibration Practice To ensure consistency in your calibration techniques develop procedure manuals of calibration practices At minimum include tolerances for accuracy standards temperature and humidity controls if needed time cycles human technique and other important factors After calibration make the equipment tamper proof if possible with sealed adjusting screws lead sealed lock wires stamps and other devices GAGEtrak Calibration Management Software User s Manual 143 Record the results of your calibration checks and any required adjustments or repairs At minimum record the following information x date on which calibration was checked P person that checked calibration o any deficiencies seen in the equipment o accuracy data if able to measure accuracy causes for out of cali
79. B78334 El 1 999000 Mu E E 2 000000 0 000000 Comments 3 Gage Block 3 Inch 3 001000 M fa r SIN678334 E E 3 000000 BSEC NIE Comments 4 Gage Block 4 Inch gl 4 000000 0 000000 B SIN678334 5 sh VEA 4 000000 0 000000 Comments Record 14 4 107 gt t r of 4 You can use this screen to compare the actual before and after measurements of the gage with the standards that you use to calibrate the gage You will use these fields in the Measurements screen Field Button Name Standard D Description GAGEtrak copies the Standard Ds from the Calibration Standards table that you defined in Gage Entry see page 43 Minimum Nominal GAGEtrak copies the gage s Minimum Nominal and Maximum values from and and Maximum Maximum Gage Entry Units The type of calibration standard will be either Variable or Attribute GAGEtrak copies it from Gage Entry if entered or you can select it here Type The type of calibration standard will be either Variable or Attribute GAGEtrak copies it from Gage Entry if entered or you can select it here Before Enter the actual measurement observed before you adjust the gage After Next enter the actual measurement observed after you adjust the gage Acc Bfr This field shows the accuracy value based on the before measurement Before minus Nominal Acc Aft In this field you ll see the accuracy value based on the after measurement After minus Nominal Limited U
80. Body Enclosed is an instrument which is in need of calibration Upon receipt of this unit please call me at the number below with the estimate for the cost of the calibration Be sure to include any return shipping and insurance charges in your estimate Please include the following information in your calibration documentation 1 The calibration environmental conditions including but not limited to relative humidity and ambient temperature A calibration certificate which states that the calibration technique or standard which is directly traceable to the National Institute of Standards and Technology or an internationally accepted naturally occuring phenomenon Record uff 4 gt ri frm of 3 Archive Un Archive Use this utility to archive or un archive your calibration records Archive moves your records from the current group and puts them in a storage location within the database This makes your current group of records smaller and your database faster An archive is not the same as a backup Remember Always make a backup copy of your GIDATA40 2007 MDB file before you archive it When you select this feature the following filter will appear amp Archive Filter olx Gage ID From Date 10 15 1397 To Date 01 15 1998 View Cal Header Un Archive View Cal Meas Clear Filter Exit CAGTW4NGTDATA4O0 MDB 182 Chapter 6 Other Utilities You can archive your calibration records by Gage
81. Company Hare Division Mame Calibration Due Listing By Due Date TL SE Paga 1413 Due Dae Duae gU Deer 37 Diipa Locahon Pieper U Additional Linge B teaan Rocarde 1 42 dT ILLALLA aga SW Caliper Hsi i Pics dan DATS Jue Coins viii rine 5 rs OT ATCA REO Gags EH Galineta 12 Job Q7 121 GO DATS T1247 Ue AL ES T4 Gig HN Caliph Digest f Job WT T10 mU DAS Paper TM co al gee eRe tizi FN WJA idicromaser Cel Aerahiag BO Dales Tithe Background j BEEE mi mie p pen n LIM XAMEHMICO 5 MIOUM Mireni OCTS OO DAYS Line Cobor Bet mima m mim LI Lig FELIU MS Mee a DAS Heading Color 4j LJ IMormaionColor LE LL I J Exit Click the Format Reports button to access this screen where you can set your report options The sample report on the right side of the screen shows your current settings Selections include four different types of page number formats or omit page numbers altogether three types of fonts with two font styles regular and italic different font styles for report headings and information additional separator lines between records ten different colors available for title title background lines headings and information Floating Toolbar In the data entry screens you can click the floating toolbar to resize or move it If you don t want the toolbar to appear at all un check the Open Automatically checkbox in this screen Please see the Program Conventions printer or install
82. D or by Date To archive by Date enter the beginning date in the From Date field and the ending date in the 7o Date field Click the Archive button when you re ready Archived records are stored within the database After you archive records you can decrease the size of your data file by running Compact Data from the GAGEtrak 4 2007 program group To view the archived records click the View Cal Header or View Cal Meas buttons To put archived records back into the current record group set up the criteria in this screen and click Un Archive Status ID Entry Select this utility to enter the descriptions you want to appear in the Status drop down list in Gage Entry You must use the status ID 1 for current gages because the 1 tells GAGEtrak that the gage is active On Calibration Due Listings Calibration Work Orders and Calibration Schedules GAGEtrak includes only active gages those marked with status ID 1 Therefore do not delete status ID 1 Active amp Status ID s i OF x HAUST S New Delete Status ID 1 Status Description Active Record ta i 4 F gt i rx of 5 The default Status Descriptions that come with GAGEtrak are Active nactive Out For Repair Out For Calibration and Lost You can change these descriptions except Active or add as many additional descriptions as might necessary for your company for example you may need to add Status Descriptions like Retired Sealed or Loaned Out Repor
83. EBLOCK Purchase Date 04707719938 Type GageBlock s User Defined O Unit of Meas n y Manufacturer ACME GAGES TORONTO gj Drawing No 21D Owner COMPANY g Drawing Date 05998 Resolution 00 Change Level ic 1 Tolerance 000 Change Date 085199 Tolerance 9900 Notes Uncertainty Issue Return Clone Gage Graph Calibration New Record Undo Delete Exit Record ujaj 5 gt ri low of 5 Elements of a Record Form All record forms have the following elements Form Title Bar Located at the top of each form the title bar shows the form s name Gage Entry in the above example Click the title bar to drag the form to a new location Menu Bar Located above the title bar the menu bar usually has menus for File Edit View Records and Help Click on a menu title and a list of commands will appear Some items may not be available they appear gray If commands are unavailable you can t use them in Form view Control Menu Icon Click on this icon Located to the left of the name on the title bar to change the window s size and location Double click on it to close the window Control Menu Icon from Gage Entry Screen E Gage Entry GAGEtrak Calibration Management Software User s Manual 123 Record Selector Bar gt Information History Standarc Gage ID c 00001 Status fi hd Ref Standard NIST Gage
84. Exit User Defined 1 Truck Transmission oo User Defined 2 Customer 8534 Job 99554 Inspection Procedure 1 Place the clutch arm in the fixture with the flat surface on top 2 Measure its thickness with the caliper inserted into the positioning slot Gage Requirements BagelD Description Dimension Control Method Freq Comments m 12 Inch Vemier Call Thickness Lenglh 100 Inspection 12 Months __ P 00263 5 Inch Plug Gage Diameter 100 Inspection 12 Months Record I4 4 3 LF TET oF 3 Record 14 4 1 gt t dr of 1 Field Button Name Description Part No In this field enter the number of the part use either the customer s or your Description Enter the name of the part or a description that includes the name Operation Use this field to track the production operation or work center description that uses or installs the part such as Stamping or Machine 13 Drawing No Use these fields to record the blueprint drawing number and drawing date and Drawing Date Change Level In these fields enter the blueprint change level also called engineering and Change Date change level and the change date User Defined 1 Use these fields to track additional information on the part and 2 Inspection Enter instructions for checking the part Procedure Gage Requirements Field Button Name Description Gage ID Select the gage ID of the gage you will use to inspect the part Dime
85. GAGEtrak 4 2007 from this program group to start using GAGEtrak When you open GAGEtrak a logon window will appear if you have set up security The window will ask you to enter your PIN Personal Identification Number Enter your PIN and click OK see the System Administrator s Guide for more information about setting up security Next GAGEtrak will give you this message Please enter your Serial No in the About box Click the OK button and the About window will appear Enter the serial number for your copy of GAGEtrak you can find this serial number in your manual package on your registration card and on the packing list that came with your order Please call Technical Support at 480 922 7300 if you can t find your serial number 19 20 Chapter 3 Installing and Running GAGEtrak Trial Period Each copy of GAGEtrak is set to give you a 45 day single user license trial period If you purchased a multi user license of GAGEtrak please follow step 1 after you install your software Seven days before your trial period is over GAGEtrak will begin giving you messages that your trial period is nearing its end For your convenience the trial period will not expire on a Saturday or Sunday To enable your copy of the software to continue past the 45 day period you can do one of two things 1 Goto the Tools and Utilities menu and select Modify License GAGEtrak will generate a screen that gives you a Code Entry number and a Compute
86. Gage Exit E E A A m 111 112 Chapter 9 Gage Issue and Return Batch Mode Gage Issue The Gage Issue fields are as follows Field Button Name Description Gage ID Select the ID of the gage ssue Date and ssue These fields track the date and time at which you issued the gage they re Time prefilled with the current date and time Type Choose the type of issue this field creates a self building list as you enter different descriptions Issued To Enter the name of the person to whom you issued the gage ssued Dept Select the department or job number that will be using the gage Part No Next Gage Exit This field tracks the part or group of parts that you ll measure with the gage If you have other gages to issue click this button to issue the gage Click the Ext button to save the record and exit the screen Next Due Date Issue Gages will create a predicted Next Due Date when you issue out a gage that has a usage frequency If the gage is due for calibration this message will appear beneath the date This gage is past due celibrasoan Uk Gage Return The Gage Return fields are as follows Field Button Name Description Gage ID Select the ID to return Received Date These fields show the date and time at which you received the gage they re and Received Time prefilled with the current date and time Received From In this field enter the name of the person that returned the gage Enter the number of
87. If you purchased a multi user license please follow step 1 after you install your software Seven days before your trial period is over GAGEtrak will begin telling you that the expiration date is near For your convenience the trial will not expire on a Saturday or Sunday To enable your license to continue past the 45 day trial you can do one of two things 1 Go to the Tools and Utilities menu and select Modify License GAGEtrak will generate a screen that gives you a Code Entrynumber and a Computer D number Leave this screen open and call Technical Support immediately The support representative will then give you two additional code numbers that you will enter on your Modify License screen Once the modification is complete GAGEtrak will give you a message titled Modification Successful 2 You can also wait until the date on which your trial period expires At that time you will receive an Application Violation message when you open GAGEtrak Click the OA button and the Modify License screen will appear Again leave this screen open and call Technical Support immediately for the necessary code numbers You ll receive a Modification Successful message once you have entered the code numbers that your support representative gives you To check on your expiration date and number of assigned user licenses click the About button on the main menu and look under License and System Information GAGEtrak Calibration Management Software Sy
88. J Name of the server used for Microsoft SQL Sever Database Name of the database used for client server UID User D used only for client server PWD J Password used only for client serverls APA JL Application Attributes used only for client server not required DBA V Database Attribute used only for client server not required DBQ Service Name required for Oracle if not using DSN or FileDSN PFC 4 Prefetch Count used only for client server not required TLL 2 Translation Library Name used only for client server not required s TLO Translation Option used only for client server not required Network LicensePath VL Path mapped drive or UNC to the license file GAGEtrak Calibration Management Software System Administrator s Guide 155 Sample Configuration The following sample is for a single user Access database version of GAGEtrak 4 2007 Database dbType 0 UseDSN UseFileDSN File G 7Datago 2007 mdb Path C GT4 DSN FileDSN Driver Server Database UID PWD APA DBA DBQ PFC TLL TLO Network LicensePath C G7W4 156 Chapter 1 Installation Chapter 2 Oracle Installation Setting Up Oracle Tools If you re planning to use GAGEtrak on an Oracle server you must set up Oracle and create the data source name DSN before you install GAGEtrak You must also be using Oracle 8 Follow this sequence to install and set up the software 1 Inst
89. L Preview Tape Catalog Refilter Gage ID Description Last By Next Due S pe s N 1 0001 NO 3 Dial Bore 08 03 1998 g 04 30 1999 i Record 14 1 18M gt t LEJ of 126 Tip This method eliminates the blank waste tape that ejects with each label that you print from Calibration Entry You ll still get an initial piece of blank waste tape but after that the printer adjacently cuts and ejects all of the labels Use the scroll bar or navigation buttons to view the selected calibration records To change the filter criteria click Refilter To preview labels check the Preview box and click the label button To print labels make sure the Preview box is not checked then click the label button Make sure that you have the correct tape cartridge in your label printer GAGEtrak Calibration Management Software User s Manual 139 Designing Your Own Labels Your label kit includes special label designing software To use this software double click the P Touch PC Editor icon You can use this software to create barcode and Do Not Use labels Barcode Label Do Not Use Label File Edit mp View Barcode Options Help Length 21 emm _ ATI ENT Heat E wf ra Pa Eia Fuga Eua a Bs Eile Edit Type View Dlarcode Options Help me mox 71 Black d m wem 2 Gage ID ABCD 123 OUT OF CALIBRATION AMATO You can also create other types of labels including Gage R amp R Part ID Labels Test
90. LOWMETER FLOWMETER FMM 00003 1 Multimeter Digital Variable GNG 00013 1 Go NoGoPinGage Attribute GNG124 i SMW 1 GO NDGO 051 055 PLUG GAGE GNG125 1 SMww01 GO NOGO 052 055 PLUG GAGE L44565 20 1 026 Step Gace Step Gage MSGBI 2 GAGE BLOCK SET 81 PC GAGE BLOCK S MSM12 1 1 2 OD MIC 0001 MITUTOYO MICROMETER MSM 23 1 2 3 OD MIC 0001 MITUTOYO _ MICROMETER MSM34 1 3 4 OD MIC 0001 MITUTOYO MICROMETER MSM45 1 4 5 OD MIC 0001 MITUTOYO MICROMETER P Record jaf 1 gt drrirx of 52 Elements of a Table View Window All Table view windows have the following elements Title Bar Located at the top of each table the title bar contains the table s name Gage Entry in the above example Click the title bar to drag the table window to a new location Menu Bar The menu bar located above the title bar typically has menus for File Edit View and Help To select a menu click on the menu title and a list of menu commands will appear Some menu items may not be available they will appear gray Control Menu Icon Click on this icon located to the left of the title bar to change the table window s size and location You can also use it close the window GAGEtrak Calibration Management Software User s Manual 125 Record Selector Buttons 5 Gage Entry 022E Digital Caliper 0 6 1230133 3 b2C U2 Record selector buttons are small rectangular buttons located on the far left sid
91. Other T chniques References siue cene ostii otia eo Cedar e chaired Co a ease eva bees Vl ee eoe sc Eee a aaas 99 Chapter 5 Supplier RECOROS soris eios eain due Rx vox even xx Cw bv o Vv E Rv Rav 101 Suppen Enty Fle cenin reo ard odd odd E S A EU MATE 101 SUPPLET EN Y genre meer ee meme E EDU LC CUM AIME ELE A IT n MELIA A LE 102 Chapter 6 Calibration PFOCeduF6es iini e De ini e ie kl ek Dec ak inn Cites iod cta Caes 103 Procedure Entry Procedure Text oe eite Rt neta eU eoe Elea uei AEAEE e OR REP Ea E UITAE AR EORR VRBAVRAE ERE NEU rid 103 Copying Procedures from Another Windows Application 4 eere eere esee eee ee eee e eee tn eost teta en ste tn ense nete en ease sa sa ata 104 CalProCalbralon ProGCedules otii doc i D UE en Ett e na tae a iis aerate eens 104 Procedure ENtry Procegure IMAG REA PR m 105 Chapter 7 Service RedueslS eccccsc ot pinea n aec ne Eaa 107 Chapter 8 Part RECON Sanninina inania ust cuu c Ceo sumaeue ceu icu sw tact equi vas a tss vE vec cei nemea uc kou EE dita RERUM US 109 PaECEDU VENIS S be uM A EM eR ere rater enter ee rome ree 109 mmn casa ance EET 110 GAG 1S SUS MN MC EE 112 Dage REIU ood ocu tiiu itus ctu It dpa iM d d us ML tI ee 112 Chapter 10 REDONIS soromra a 113 Report Commands and PURCUOPDS a fh Eee ae ES nee eso Se vr aea eiaa EN tede
92. R Charts menu will appear Select a Chart Range Chart by Appraiser Part _ Whiskers Charts by Appraiser Part a Range Chart by Part Appraiser X Y Plot of Averages by Size Error Chart Comparison X Y Plots by Appraiser __ Run Chart by Part __ Scatter Plot __ Average Chart by Part __ Repeatability Range Control Chart Normalized Individuals Chart by Part Appraiser R Part Appraiser Average Control Chart a Normalized Individuals Chart by Appraiser Part 72 Chapter 4 Gage R amp R Entry Printing Charts To print a chart first click the small button next to the chart type to generate it on screen Then choose File Print from the top menu bar We ll discuss each type of chart next Range Chart by Appraiser Part and by Part Appraiser Using a standard range chart this chart plots the ranges of each appraiser s readings including the average range and control limits You can choose to plot the data grouped by part or grouped by appraiser Example Range Chart Appraiser Part RAHGE CHART APPRAISER PART UCL 0 00031 AVG 0 00012 Range Chart Interpretation The Range chart can help you determine both statistical control in regard to repeatability and consistency of the measurement process among appraisers for each part You won t see lines connecting the range data points because this data is not ordered Neither chart should show patterns in the data relative to the appraisers or parts Y
93. Se GAGEtrak Calibration Management Software Version 4 User Guide Cyber Metrics CyberMetrics Corporation 1523 W Whispering Wind Drive Suite 100 Phoenix Arizona 85085 USA Toll free 1 800 777 7020 USA Phone 480 922 7300 Fax 480 922 7400 www CyberMetrics com Entire Contents Copyright 1988 2011 CyberMetrics Corporation All Rights Reserved Worldwide U S GOVERNMENT RESTRICTED RIGHTS This software and documentation are provided with RESTRICTED RIGHTS Use duplication or disclosure by the Government is subject to restrictions as set forth in subdivision b 3 ii of The Rights in Technical Data and Computer software clause at 252 22 013 Contractor manufacturer is CyberMetrics Corporation QUESTIONS Should you have any questions concerning this agreement or if you wish to contact CyberMetrics Corporation for any reason please write or call CyberMetrics Corporation 1523 W Whispering Wind Drive Suite 100 Phoenix AZ 85085 Tel 480 922 300 USA Toll Free 1 800 77 020 Fax 480 922 400 TECHNICAL SUPPORT If you need technical support please call or write our product support and development office CyberMetrics Corporation 1523 W Whispering Wind Drive Suite 100 Phoenix AZ 85085 Tel 480 922 300 USA Toll Free 1 800 77 020 Fax 480 922 400 Technical support is available by telephone during normal business hours Mountain Central time Email and Internet Support
94. Sort Use this command to apply the record filters and sorting set up in the QBE grid Show All Records Choose this command to disable any previous filters and see all records Help Menu Command Description Contents To see the Help file s table of contents choose Help Contents About Select this command if you want to see information about the program 136 Chapter 11 Program Conventions Appendix A Calibration Label Kit The following instructions will help you install and set up the optional GAGEtrak Calibration Label Kit You can use the kit to print durable oil resistant adhesive backed calibration labels for your gages test equipment and calibration standards The kit includes a dedicated Brother P Touch PC label printer cables black on white tape cartridge and software drivers for Windows and Macintosh If you ordered extra tape cartridges they are enclosed with your kit Installing the Label Printer and Windows Software First attach the Brother P Touch PC printer s serial port or USB cables then put the tape cartridge into the printer Next install the P 7ouch PC Editor for Microsoft Windows software See the enclosed Brother booklets for more detailed Instructions Printing Calibration Labels GAGEtrak can print 1 inch Y2 inch and inch wide calibration labels in three lengths 1 inch 2 inch and 3 inch Asample label is shown below 71 inch Wx 71 inch L Your Company Name ID 200 02 Desc RADIUS GAGE
95. T INSERT Extend the selection or deselect one character to the left Extend the selection or deselect one word to the left Copy the selection into Windows Clipboard Paste text from Windows Clipboard 134 Chapter 11 Program Conventions Datasheet Table Keyboard Shortcuts Press To TAB ENTER or Move to the next field RGT ARROW END Move to the last field in the current record Table view SHIFT TAB or LFT Move to the previous field ARROW HOME Move to the first field in the current record Table view DN ARROW Move to the current field in the next record CTRL DN ARROW Move to the current field in the last record CTRL END Move to the last field in the last record UP ARROW Move to the current field in the previous record CTRL UP ARROW Move to the current field in the first record CTRL HOME Move to the first field in the first record Menus and Commands The following is a summary of the various menus available from the menu bar including explanations of the available commands in each File Menu Command Description Close Use this command to close the current screen and return to the prior screen Save Record To save the current record choose File Save Record Output To Select this command to output the current record s to an Excel spreadsheet word processing RTF or ASCII text file Print Setup Choose File Print Setup to define your printer and settings Print Preview To see the current record as it would loo
96. Type Select either V for Variable or A for Attribute Unit of Meas Enter the units measured such as MM inches lbs or degrees Minimum This field contains the minimum acceptable value for the gage or instrument for when you measure this standard for example 0 999 When you enter the nominal measurement GAGEtrak automatically calculates the minimum measurement based on the gage s tolerance Nominal Enter the nominal value for the gage or instrument for when this standard is measured for example 1 000 Maximum This field contains the maximum acceptable value for the gage or instrument for when this standard is measured such as 1 001 When you enter the nominal measurement GAGEtrak automatically calculates the maximum measurement based on the gage s tolerance 24 Chapter 4 Entering Gage Records Gage Entry Schedule Use the Schedule tab to set up the calibration schedule for each gage amp Gage Entry Ea Information History Standards Parts Procedures Schedule i Exit CALIBRATION Initial Times Used Calibrator GC Lab Building 12 Projected Calibration Schedule Last Calibrated By J oe Jones X 0371 9 1999 Calib Freq 30DAYS E 06 17 1999 Auto Adjust Calibration Frequency FE 09 1 5 1999 Calibration Hours 25 Next Last Calib Date Sue Calib Next Due Date GAGE R amp R Projected R amp R Schedule R amp R Freq 365 DAYS 7 03728 2000
97. UCL 0 00031 AVG 0 00012 Part Appraiser Average Control Chart Using a standard average chart the averages of each appraiser s readings for each part are plotted including the overall average and control limits The data is grouped by appraiser with lines connecting each appraiser s points If half or more of the points are outside of the control limits then the measurement system should be able to detect part to part variation If less than half are outside the control limits it might be because the measurement system isn t able to thoroughly distinguish differences or because the part sample doesn t represent the expected process variation Example Part Appraiser Average Control Chart PART APPRAISER AVERAGE CONTROL CHART UCL 0 1354196 AVG 0 134073 LCL 0 133851 Average and Range Formulas Range Short Form Method Values of d Parts 1 2 3 4 5 6 7 8 9 w EV Not calculated AV Not calculated R amp R 5 15 d2 xR 96 R amp R 100xR amp R TOL Or ARAR 100xR amp RJ PV where PV is the Process Variation GAGEtrak Calibration Management Software User s Manual 177 Note When calculating R amp R the Short Form Ford method uses 6 00 instead of 5 15 6 00 d2 xR AIAG Average and Range Method Long Form Equipment Variation EV Repeatability Trials 2 3 4 56 3 05 EV R xK1 EV 2100 x EV TV or If comparing to tolerance EV 2100 x EV Tolerance Appraiser Vari
98. ailable only in certain record entry screens l Use this command to search for specific information Place your cursor in Find the field containing the category by which you want to search then click this button The Find window opens and you can enter the information that you want to locate 4 After you ve closed the Find window click the Find Next button to locate the t Find Next next instance of the information for which you re searching Qu Place your cursor in the field containing the information you want to replace Replace The Replace window will prompt you for Find Whatand Replace With You can replace any or all occurrences of the same information Wa Use this button to re open the filter window for the record window You can Filter Records then filter for a group of records that match the criteria you enter all Select this button to sort all of your records in ascending order numbers Sort Ascending show before letters zl l Click this button to sort all of your records in descending order numbers Sort Descending show after letters a If you need to remove any changes to the current record click this button i Undo 5 Use this button to enter a new record New Record Pop Up Calendar for Date Fields You can enter dates by choosing them from a pop up calendar instead of manually typing them Whenever you re entering information in a filter or data entry screen double click on any date field to view the calendar
99. ak automatically saves records whenever you go to a different record or close the window but you can manually save records by clicking the record selector bar or selector button in Table view You can also use Save Record from the File menu to save your records Editing and Shortcut Keys You can use these keyboard shortcuts to save time when you re entering records Note Where indicated by CTRL press the CTRL key while pressing the other key Keyboard Shortcuts General Press To PAGE DOWN Go to next record in Form view next page of records in Table view PAGE UP Go to prior record in Form view prior page of records in Table view CTRL PAGE DOWN Go to next record but keep cursor in same field CTRL PAGE UP Go to prior record but keep cursor in same field CTRL Copy field data from the pryorrecord s field CTRL Insert the current date CTRL Insert the current time CTRL Add a new record SHIFT ENTER Save changes to the current record CTRL Delete the current record CTRL ENTER Add a new line to a memo field F2 Switch between field editing and navigation modes F5 Move to the record number entry box SHIFT SPACE Select the current record Field Editing and Selection Keys Press To SHIFT RGT ARROW Extend the selection or deselect one character to the right CTRL SHIFT RGT Extend the selection or deselect one word to the right ARROW SHIFT LFT ARROW CTRL SHIFT LFT ARROW CTRL C or CTRL INSERT CTRL V or SHIF
100. ali enti Ws SONY ETE Eo 185 Appendix A Data Iranster Utility ssoi 187 Client Server Versions Before You Run the DTU cscsscssscssssssssssccssesssssecesssssssssscsecessessscsecessesssceseessesseccecess 188 Data Transfer Instructions Version 4 2007 Access Users to Client Server Version 4 2007 190 Data Transfer Instructions for Version 3 Archive File 4 eere eese eee eese eee eee etes ernst in etna e tae tn etna 190 Data Transfer Instructions for Versions 3 Database File eee e e eee eee eese eee tenete sten ettn etta stnae 191 Al Versions Verify Data Transfer x eos tecti a aer EO Ee EO OEC D ANRA 191 Sample Data Transfer from Version 4 0 Dalai e ee rr E Re er i RE PA DU MIDI SEP LEA M EL ain A Dr UR OL RE Rbe c EUH CITRUS 192 Sample Data Transfer from Versi lS AFChIVe usos tesa t E bar eod eL HN Eug ee egt eh i e EVER Ee e DNO CH UAR LR URN EHE ER 192 Sample Data Trahsterfrorm Version Data ideo nro a ba piti Mab dom dedu eur 193 Appendix B Record Formats eicit dint coc a aeaa 195 Key Field Saoir 195 Cormbinablom KEV FIE Saa a AA O E AA A D dN E 195 Record EOrmidisu oet A LU M M M d ME 195 Appendix C Database Management 1 eere L ILL LLLI err c eer c esses ases aa tn nnmnnn Dn aan asma aar 201 Moving or Renaming the GAGEtrak Database
101. all Oracle Tools 2 Install updated Oracle ODBC drivers 3 Configure SQL Net with Oracle Net 8 Assistant 4 Create data source name DSN 5 Install GAGEtrak 4 2007 This chapter gives you step by step instructions for installing and configuring your database When you re finished please return to chapter 1 for instructions on installing and setting up GAGEtrak Note Remember to modify all references to drives paths user ID password server names etc to fit your system Install Oracle Tools 1 First run SETUP EXE from your Oracle 8 CD 2 The Oracle Installation Settings screen will appear Keep the default settings and click OK Oracle Installation Settings X e Please enter the Oracle Home settings for this installation Session Company Name Enter Company Name H ere Oracle Home Name DEFAULT HOME Location fC Sorawingg iN Language noh O mg Help Cancel 157 158 Chapter 2 Oracle Installation 3 Inthe next screen select Oracle8 Client and click OK e Select the type of installation you want to perform Oracle8 Client C Custom Installation Help Cancel 4 Another screen will appear select Application User and click OK Select Oracle8 Client Configuration X e Select the primary function you will be performing Application User C Database Administrator Help Cancel 5 Complete the installation After installation you might need t
102. ame of the person who calibrated the gage This field automatically displays the name of the current user but you can change it Results Enter any results or comments typically used for attribute type gaging or dimensional layouts Enter calibration measurements into the Measurements table see below As Found Condition Choose the condition of the gage before calibration or adjustment Select In for in tolerance Out for out of tolerance or New for a new instrument that has not been calibrated before Prior to calibration a test points of the instrument must be within tolerance to have the As Found Condition field set to In You need this information only if you ve chosen Auto Adjust Action Required Pass Findings X Uncertainty Environmental Conditions Type Cost Acct No Hours Certificate No Gage R amp R Graph Gage Master Undo Delete Certificate Exit GAGEtrak Calibration Management Software User s Manual 61 Calibration Frequency for this gage see the System Administrator s Guide for details Enter any action that may be required such as send out for repair You must check this box in order for the program to automatically calculate the next calibration due date Calibration Frequency Calibration Date Use this memo field to describe any other pertinent information such as visual inspection notes You can scroll through this field if you need more room for text Note Your certificates of
103. amp R record for the gage Next R amp R Click this button to calculate the Next R amp A Date and three future R amp R dates You can use this button to calculate the Next R amp R Date even if you don t enter an R amp R study record for the gage Using Gage Records Cloning Gage Records If you want to copy a particular gage record ncluding its set of calibration standards procedures and parts click the Clone Gage button Located at the bottom of the Gage Entry window This window will appear amp Clone Gage x Source Gage ID C 00001 New Gage ID Clone Exit Enter the gage ID of the new record into the New Gage D field then click the Clone button If you want to clone more gages keep entering new gage IDs and clicking the Clone button Click the Ex f button when you re finished If you filtered for just one gage when you re done cloning GAGEtrak will show you the original gage record from which you created the clones If you want to edit your cloned records you ll have to re filter and find them to re filter click the toolbar button that looks like a funnel with a pencil A better way to clone gages is to re filter and find all of your gages before you clone any of them again to re filter click the toolbar button that Looks like a funnel with a pencil You can then use the Find binoculars button on the toolbar to find the gage s that you want to clone If you use this method when you re done cloning GAGEtrak
104. appear It looks like the one shown below JO Bappiws Gaia c Supe Hans x2 zi LL Each supplier record contains the following fields Field Button Name Description Supplier Code Create a unique supplier ID or code for each supplier then enter it here Supplier Name In this field enter the company name of the supplier Supplier Type Use this field to categorize your suppliers by the type s of goods they sell Contact Person In this field enter the name of the contact person at the supplier company Salutation Enter the salutation to use for written correspondence to this supplier such as Mr Ms or Mrs Leave this field blank if you don t want to use a salutation i e Joe Smith vs Mr Joe Smith Address City State In these fields fill in the complete address of the supplier including phone and Zip Country Phone fax numbers and Fax E Mail Use this field to store the contact person s e mail address Last Review and Last In these fields enter the date of the last quality review and last quality rating for Rating this supplier Last Received and Enter the date on which you last received a shipment from the supplier and the Last Rejected date on which you last rejected a shipment from the supplier Enabled Check this box to indicate that the supplier is currently active and approved User Defined 1and 2 Enter any other information that you wish to track on the supplier Be sure to use these fields consis
105. arts Procedures Schedule Each tab selector contains an entry screen that stores a specific category of information In each tab you can edit or view information for the current record The tabs shown above are available in Gage Entry Maximize Minimize Restore Close Buttons Piel Es ME E l Minimize Button Restore Button Bi Maximize Button x Close Button Use these buttons located in the upper right corner of the form to maximize the form s size to the largest size allowed or to minimize the form to an icon If you maximize the form then the Maximize button changes to the Restore button Click this button to return the window to its original size 124 Chapter 11 Program Conventions List Box Buttons List box buttons indicate that a field has a list of items available from which you can choose When you click the button it presents the list in a scrollable box Click on any item in the list to select it Example of a list box button w Datasheet Table Views of Records Datasheet also called Table views allow you to see many records at once Because of this they can be a more efficient interface for adding or modifying your records Table views operate like spreadsheet programs Each row represents a record and each column represents a field In Table view you can add change and view records This format offers more flexibility in that you can resize column widths and row heights rearrange column positions and even h
106. at protect against data entry errors or relational integrity corruption are in place Please be extremely cautious when using this feature Calculate All Due Dates If you need to re calculate calibration due dates select this utility For example if you change the calibration frequencies on all of your micrometers from 60 Days to 90 Days and you have 50 micrometer records it s easier to run this procedure than manually click the Next Calrb button on the Gage Entry window for those 50 records GAGEtrak Calibration Management Software System Administrator s Guide 181 You ll see the message shown below when you select this utility Re calculate Calibration Due Dates 9 Calibration due dates will be re calculated for all records Are you sure you want to do this Click Yesto have GAGEtrak calculate the Next Due Date for every Gage Entry record based on Calibration Frequency and Last Due Date It deletes or overwrites any manually entered dates Set Up CA Service Request To set up service request letters or corrective action request notices choose Setup CA Service Request Letter from the Tools and Utilities menu The Letter Entry screen will appear Here you can enter the letter 7ype Date Authored Authored By and the Body of the letter Enter as many letters as you need amp Letter Entry L Oi x Letters i i Delete Letter Type Calibration Request Date Authored 01 16 1997 Authored by Sample
107. ate an accuracy chart for the current gage record click the Graph button in the Gage Entry Information screen By default the program charts the entire calibration history for the first calibration standard You can specify a time frame by entering beginning and ending dates in the From Calibration Date and Thru Calibration Date fields amp Gage Accuracy Chart Jof x Gage ID C 002 Standard ID i INCH GAGE BLOCK From Calibration Date 101 01 1980 Thru Calibration Date 12 31 2100 1 002 1 0 998 0 996 0 994 0 992 0 99 0 988 0 986 0 984 Gage Accuracy History e CM Before m cM After 4Z Minimum 5 Nominal 3 Maximum 01 07 1396 011211837 1012 1335 10181337 10 28 1336 Record wif 1 gt nir of 3 To view different standards use the navigation arrow buttons or press the PAGE DOWN PAGE UP keys Remember you can generate this chart only after you ve entered some calibration and measurement records see the next chapter for more information on calibration records As you can see in the sample screen the chart plots before and after values as well as the nominal minimum and maximum allowable limits Click the Print button to print the graph or go to the File menu and select Print the latter method lets you print multiple charts per page Modifying Accuracy Graphs To edit accuracy graph properties such as scaling or fonts double click on the chart You can modify chart
108. ate number such as 1001 GAGEtrak Calibration Management Software Quick Start Guide 29 Calibration Measurements Use this screen to view the standards test parameters or checkpoints that you use to calibrate the gage GAGEtrak copies this list from the Calibration Standards table that you defined in Gage Entry Calibration Measurements Procedures Labels Gage ID C 00001 Exit CALIBRATION MEASUREMENTS Standard ID Minimum Nominal Maximum Before Accuracy Limited Gage ID of Standard Uncertaint Units Type After Accurac Use EDIDI 399000 500030 n BE Se E SIND78334 In ish 1 000000 0 000000 Comments SIN678334 us 2 000000 BEMNTTOROEEE Comments 3 Gage Block 3 Inch ul SIN678334 4 000000 0 000000 fux sh 4 000000 0 000000 Comments Record i 4 1 gt gt t gt of 4 You ll use the following fields in the Measurements table Field Button Name Description Standard ID GAGEtrak copies the calibration standards and their nominal minimum and Minimum Nominal Minimum Nominal maximum values from Gage Entry and Maximum and Maximum Type and Unit of The program automatically pulls this information from Gage Entry If you enter Measure this information here it becomes part of this calibration record but not the gage record Before Enter the actual measurement before you calibrate the gage After Next enter the actual measurement after you calibrate or adjust the gage Acc Bfr
109. ate the Next Due Datefor gages that calibrated according to cycles Notes Use this field for important comments such as damages or malfunctions New To create a new issue record for this gage click the Mew button Undo If you need to undo an entry you ve made click this button Ex Click Ex tto return to the Gage Entry Information screen GAGEtrak Calibration Management Software User s Manual 57 GAGEtrak uses the following rules to manage Issue Tracking records 1 When you issue a gage GAGEtrak inserts the current date and time as the issue date and time It also changes the gage s Current Location field to a description that consists of ssued To plus ssued Dept for example Joe Jones Assembly GAGEtrak assumes you want to return a gage if its current record is incomplete After you enter the Received Date and Time and save the record GAGEtrak changes the gage s Current Location field to its storage location Pop Up Issue Information In the Gage Entry Information tab the Current Location field turns yellow to show that the gage is currently issued out Double click on this field to open a pop up window that shows you the date time person department and part information from Issue Tracking Double click anywhere in the pop up window to close it Issue Date foe271999 Issue Time fiC0356AM Issued To Joe Jones Issued Dept assembly Part No rce214 Gage Entry Graph Button To gener
110. ation AV Reproducibility Apps 2 3 Ko 2 70 Gas x Kay EV nx dbo AV X xK EV n xr diff 2 where n of parts r of trials Note If a negative value results under the square root the AV is reported as 0 96AV 2100 x AV TV Or if comparing to tolerance 96AV 2100 x AV Tolerance Repeatability amp Reproducibility R amp R R amp R V EV AV EV AV R amp R 2100 x R amp R TV or if comparing to tolerance R amp R 2100 x R amp R Tolerance Part Variation PV Rare st o Jr Je Jpow dg po log te PV Rp xK3 R Max X MinX p Xp values are the averages of each measured part Note If you know the 6 Sigma Process Variation from SPC or Capability studies enter it into the Proc Var field If entered into the Gage R amp R Study form the software will calculate TV as TV 25 15 6 SigmaProc Var 6 and calculate PV as PV J TV R amp R Total Variation TV TV JR amp R PV General Motors and Chrysler Long Form Method Equipment Variation EV Repeatability Trials 2 3 K 456 305 EV R xK1 EV EV TOL 78 Chapter 4 Gage R amp R Entry Appraiser Variation AV Reproducibility K 3 65 2 70 AV 4 Xie Kp EV nr where n of parts r of trials Note If a negative value results under the square root the AV is reported as 0 AV 100 xAV TOLRepeatability amp Reproducibility R amp R R amp R VEV AV Ev
111. ave a specialized backup product such as Colorado Backup Zip Drive or another network backup utility you can use that product instead 177 178 Chapter 6 Other Utilities Backing Up Data First gather some pre formatted blank diskettes you might need several depending on how many records are in your database Next select Backup Restore from the Tools and Utilities menu When the Backup Restore screen appears click the Backup button B Backup Restore A dialog box called Choose a name for the Zip File will appear Choose a name for the Zip File 21x Look in 5 34 Floppy A ics c se File name 20001 025 zip i Files of type ZIP zip Cancel Iv Open as read only 7 Select the drive and enter a name for the backup ZIP file If you ll be saving not reusing the diskettes use the current date as your filename in this format YYYYMMDD ZIP For example save October 25 2000 s backup as 20001025 ZIP Tip The drive that you are backing up to must be removable media such as floppy disks or zip disks You cannot back up onto your hard drive using the GAGEtrak Backup utility but you can copy your database to a network drive that is backed up daily Alternate your backup diskettes so that you always have at least your last two backups available You can also use five or six sets of diskettes one set labeled for each day of the week and back up your database as GTDATAAO ZIP every day T
112. avigate to your GTDATAAO MDB file 3 Next click the small button on the right of the Destination Connection Information field to select the new location of your GAGEtrak 4 2007 database on the network or server GTDATAA40 2007 MDB 4 Click the ransfer Data button Data Transfer Instructions for Version 3 Archive File Converting your archive file ARCH9731 MDB or ARCH9735 MDB DbN ame Version V Dale DbName 4 i Dm ig a it k m Terman 2 Arche 3 418 Falun LT TESTS 4 lf Pala LS 141 i Pa F 1 Under Source Data Base select Version 3 Archive 2 Click the small button on the right of the Source Connection Information field to navigate to your GAGEtrak Calibration Management Software System Administrator s Guide 191 ARCH9731 MDB or ARCH9735 MDB file 3 Next click the small button on the right of the Destination Connection Information field to navigate to your GAGEtrak 4 2007 database GTDATA40 2007 MDBJ 4 Click the ransfer Data button Data Transfer Instructions for Versions 3 Database File Converting your database file DATA9731 MDB DbMame Versian Version 4 2007 Data 45 1 1 2007 Source Connection Information 7 al Cestinabon Connection Inlamalsonc a n III Bun Scripts Transfer Data Exit 1 Under Source Data Base select Version 3 Data 2 Click the small button on the right of the Source Connection Information field to navigate to your
113. batch of calibration labels based upon the calibration date gage ID location or description for any existing calibration records Tip Use this report to print your calibration labels at the end of the day in one batch This method eliminates the blank waste tape that prints for each label you print from Calibration Entry You ll still get an initial piece of waste tape but after that the printer adjacently ejects and cuts your labels To preview a label check the Preview box and click the label button To print a label clear the Preview box then click the label button Be sure to install the appropriate label tape in your printer To see a list of calibration history select this report Enter the dates for the time frame in question along with any other filters Check the Calibration Meas box to include the table of calibration measurements Use this report to provide traceability for your calibration and reference standards This report lists gages that are due for R amp R studies For a complete list of gage issue history use this report This report lists your suppliers Check Enabled to see only active suppliers To see both active and inactive suppliers click Clear Filter the Enabled field will become a gray box To see a list of calibration procedures choose this report Check the Summary Listing By Gage D box to include the gages linked to each procedure Use this report for a list of open corrective action or service requests
114. bering feature To do so first enter a numeric certificate value On your next calibration record click the small button next to Certificate No and GAGEtrak will automatically insert the next number in the sequence you started The first number you enter in this field sets the counter any other number you enter resets it Each subsequent automatic number will be incremented by one For example if you enter 156 in this field then go to the next record and click the numbering button the next certificate number will be 157 Then if you go to a third calibration record and enter the number 256 it will reset the number format This means that if you go to a fourth record and click the automatic numbering button the certificate number will be 257 not 158 If you want to use a number format that contains both numbers and letters you can t use the automatic numbering feature instead you must enter a new certificate number for each calibration record To enter a gage R amp R study for the current gage click the Gage R amp A button gage R amp R studies are explained in the following chapter To view an accuracy chart click the Graph button Please see page 53 for more information Use this button to switch to the Gage Entry record for the current gage This button allows you to remove any changes you ve made to the record If you need to delete this calibration record click this button It won t delete any other calibration records
115. bration conditions repair time and calibration time Review this information periodically to see if you should reduce checks on stable equipment Increase checks on unstable equipment or redesign replace the measurement equipment References The following books and publications discuss gage calibration and control JURAN J M Juran s Quality Control Handbook Fourth Ed 1988 JURAN J M Quality Planning and Analysis Second Ed 1980 FARAGO Francis T Handbook of Dimensional Measurement Second Ed 1982 National Conference of Standards Laboratories NCSL Establishment and Adjustment of Calibration Intervals RP 1 Second Ed 1989 U S Dept of Defense MIL STD 45662A Calibration System Requirements 1988 Resources for Books Publications and Reference Materials American Society for Quality Control ASQC 310 W Wisconsin Ave Milwaukee Wl 53203 Phone numbers 800 952 6587 or 414 272 8575 National Conference of Standards Laboratories NCSL th 1800 30 St Suite 305B Boulder CO 80301 Phone number 303 440 3339 National Institute of Standards and Technology NIST Bldg 411 Rm A112 Gaithersburg MD 20899 American National Standards Institute ANSI 1430 Broadway New York NY 10018 American Society for Testing and Materials ASTM 1916 Race St Philadelphia PA 1910 The Naval Publications and Forms Center 5801 Tabor Ave Philadelphia PA 19120 144 Appendix B Gage Calibration and Control GAGEtrak
116. button and select the network directory where you will store your database If you are running the setup from a network drive the path to the SETUP EXE file will be the default database location Note If your Windows Registry or INI file already lists a directory for the GAGEtrak database file that directory information will appear in this screen Go to step 5 IMPORTANT Database Location The next fom slows pou fo specty the default databace lacatian fer GaGEtak 4 2007 Any databace files vall be installed bo this directory 1 Select the browse buthon Eo specdy Ehe desired shared databace lacalion 2 If pou are installing a stand alone vor sation and wil nat be shaeng ang Hes wilh other watkstehons click Browse and select aloca dine 150 Chapter 1 Installation Lae RR E IEEE Loealenr AI G amp GEtesk d S007 dalsbaze hka wal be mistalled lo the olipa drey F pou vali be sharing databases wath other workstations i yall need bo select a network dave IF you vell mot be shanng databases vou may select a focal dires E pouw acminestrator has 321 up a retvaok drep bor bo CM h drechom Tou can chooses not to copy the DADE liak 4 2007 setup by clicking Cancel C Program Files ya Tw 4 2007 The Browse button will allow you to specify a location on any file server directory where the anticipated range of GAGEtrak users have been given Full Rights This form is a di
117. by Appraiser Part and by Part Appraiser ssscscsssssssssssssesesssssssesssscsssssecssssesecscassssecacassesecscassesscscassesecseasens 72 Error a p EL 72 Run Chartand Average Chant oivan tico ono id oa p Reni e be titulo ee 73 Normalized Individuals Chart by Part Appraiser and by Appraiser Part ssssssscscscssssssssssssssssssesesesesesesessssseseseseesesesees 74 Whiskers Chal au ertetie dest teneis EEE EAEE Rare eo RES TERRI RE POPE AA AEA REA e eo RUP EPOR AET ORO REN 74 XY Plot OL Averages Dy SIZ Gs 5 e aru Ut EDEN dc DC d cM eee 74 Comparison A Y PIOUS euet aee S aren Mao s UD Me tt vi oo edo Pea estilo n tem A da SO VEN RR Haan 75 Scatter udo IPOD 75 Repeatability Range Control Chart uio viet dH enne a inion E EIE RU bU Ee cac CH EVER HR RUE DUR A 75 Part Appraiser Average Control CBartu ien e be tede eer et Ebo do danni rici ud ei ee Dies 76 Average and Range Formulas a na oe otra eiut bcr A ie m cua et EM e a i eEEee PR re FOE I eb penale 76 Biriearty Study soc osos A aD I C D eA T Ee E AET EA TAAA A 78 Linear Std y SCI Beb eee o tesserae ccscstesvece A etui iesdevateniu secus qii estos tren AER 79 Linearity Study Interpr etatioD casis Eh tara t dub Ua dn cd din dba ug diced tcm M 80 Lipearity Formulas ceo t e URS ete SURE Ta Re Oa Ee beer to ovt o I tee c Die D dec S ev CUN Mes ashe eu rae Eee 81 Stabl StU eee
118. calibration will include this field This field will display the total calculated uncertainty value using the root sum of squares method You can t edit it Uncertainty y Uncertainty 1 Uncertainty 27 Uncertainty N where Uncertainty N is the last reference standard s Uncertainty value Calibration Status Select the final calibration status Passed Failed Repaired or Limited Enter the relevant environmental conditions for the calibration Humidity Temperature Pressure or any other factor that may affect results In this field enter the type of work being performed such as calibration repair or rebuild To track your costs enter any expenses related to this calibration such as internal labor material costs or outside calibration service costs Enter an account number or other tracking number associated with the cost examples include a job purchase order invoice or customer number There are two fields for hours The gray Hours field will display the estimated hours that you entered for this gage in Gage Entry The white Hours field applies to this particular calibration Enter the actual amount of time the calibration required or click the Start button to use the built in calibration timer see below Record the certificate number issued by the outside calibration provider or your company You can use this field in one of two ways If you want to use a format made up of numbers use the automatic num
119. ce env EU o I NEWER UA dU Un ETE IUe 124 Elements ofa Table VIeW WIDOIQW sconto dene Neb dud en C ED oda A Meee ae d eR E 124 Other Comimands and FUNCIONS 25 nuoto ei Ee coe ED tte a aa lanai to 127 Dutput To Cornimiafid aei tor p ec d eias eias p ais aediles Cea d eM SU DUM oda n 127 Send Command E Mail Reporte s ciaecoa cese ec EN AAEREN A NUAGE EAE Rau et 128 Selec Record CONIA usd onec eo b M ed ata esa A o NO Red eeu ect UR oscar E AE 128 Select All Records Command o ERE eoe eee n nei A TA 128 8 Table of Contents Find Command ost SS ERR ONSE SM T MEE MEE 128 Replace COMM ANG PRSE TD 129 Q ick Sort Commandon eate aeui EE Ure nce e He a p E E meum E 130 Fiter Sort Command see ooo eese cere co recle te Cv v b Cit tn t iactis ue eda c ee ra Eee 130 Adding New REcords 5 icit n EROR o CS RD NO HT D n Uic es D IAE GN EINE 131 GO FOG ORIN E eel 132 Show Al Becords Commandera ote Pre pO i ves I eden pta ue dp Nn E M NE 132 Copyiri RSC OTS sibon eri HERD EO i e toni dea ed RGRM T ta Ecc EIS ree eee 132 Deleting Records ero eret pie ihid tn eie R Ve a muU Pete er betur eos e ES 132 Undoing Changes to Fields arid Records eret reiten ere eee tea erben a e onde eina ete euo dep P en XP EN Eee eg NER RN ER Pe en URN adn 132 Saving Records ioci T M aa dad LU M d Mte Hn Ma Cs 133 Editing and Shortcut Keys inscio ect vetet se te teas eed bt eve ESAE HI CO itas ee nua Ee ed beta eo d aod ues 133 Menus apnd Commands Js sso sosesic
120. click on one of these buttons you select the entire column like the Status column shown above You can then work with it as a whole For example click the column selector button to select a column that you want to move or hide Note You cannot move the contents of one column to another column 126 Chapter 11 Program Conventions Navigation Buttons Use the navigation buttons located in the bottom left corner of the window to move through the records in the table Each of the buttons has an arrow on it that indicates its navigation direction 4 First Record Le Next Record La Previous Record 71 Last Record Record Allows you to type in the record number that you want to go to Example If you have 250 records and you want to go to the sixteenth record enter 16 in the Record box then press ENTER to go to that record Scroll Bars 12 Inch Vernier Cal Caliper Analog 12 Inch Vernier Cal Em j 1 Inch Gage Block 2 Inch Gage Block 3 Inch Gage Black j You might see scroll bars on the right the bottom or both sides of the table Use the vertical up down scroll bars to scroll to different records Use the horizontal left right scroll bars to scroll to portions of the table that you can t see Maximize Minimize Restore Close Buttons ZERI i Minimize Button Restore Button Inl Maximize Rutton Close Button Use these buttons located in the upper right corner of the table to maximize the table s size t
121. contains a description of each report including special filtering options Report Description Gage Listing To generate a list of gages use this report You can include calibration standards or procedures and sort the list in several different ways Gage Detail Use this report to see a comprehensive gage report including record details Report Cage Status To create a list of your gages sorted by status choose this report Report Calibration Due This report lists gages that are due for calibration during the time period you specify Listing You can sort the list by several different fields such as Gage D Check the Calibration Stds box to include the standards table for each gage To see past due calibrations check the nclude Past Due box Check nclude Details to include additional calibration information for each gage Important The Calibration Due Listing report lists only gages that you assigned as Active status ID 1 in Gage Entry Calibration If you have a large gage inventory with a variety of calibration frequencies it s Schedule difficult to plan your workload This powerful report makes this task easier by helping you predict calibrations that are due during a specific time frame It builds a temporary schedule for each gage and then summarizes the findings taking your skip days dates into account Use this report as a labor and cost planning tool After you enter any filter values click the Generate button to generate th
122. d barcodes features that let you use it for many other quality control and production labeling applications For more information about the kit please contact CyberMetrics Corporation or your distributor If you purchased the Calibration Label Kit see the appropriate section of this manual for installation and setup instructions Chapter 4 Gage R amp R Entry Overview With Gage R amp R Entry you can assess your measurement systems using the statistical test procedures of repeatability reproducibility bias stability and linearity collectively referred to as gage R amp R studies This feature saves time and prevents the mistakes that you can make when you manually assess your measurement systems You ll soon find that it s an essential tool for analyzing and managing your gage R amp R studies This feature was designed for calibration technicians metrologists inspectors and other quality control professionals who need a convenient easy to use method for documenting tracking and performing measurement systems analysis The software is based primarily on the techniques described in the AIAG MSA guide and other industry publications see the reference list in this manual Before starting SPC capability studies or any type of repetitive measuring use Gage R amp R Entry to make sure that your measurement system can give you reliable measurements Instructions for performing studies on your measurement system are given throughout
123. dates see the System Administrator s Guide GAGEtrak schedules the Next Due Date on the last working day of the month Years each year equals 365 days schedule is based on elapsed calendar years Usage when using this type of schedule the program won t create a next due date for calibration until you issue use the gage even if you enter a calibration record for the gage When you issue the gage GAGEtrak calculates a predicted next due date based on the remaining number of usage days You must use the Issue Tracking records for this to work Cycles similar in principle to the usage days method but schedules 54 Chapter 2 Gage Records calibration only when the total number of cycles equals or exceeds the Frequencyvalue cycles means either the number of parts measured or number of cycles operated You must use Issue Tracking records in order for this schedule type to work Each Use use this option if you must calibrate the gage before or after each use GAGEtrak wll not automatically calculate calibration due dates for this frequency you must manually enter your due dates Bef Use select this option when you must calibrate the gage before every use GAGEtrak will not automatically calculate calibration due dates for this frequency you must manually enter your due dates Aft Use select this option when you must calibrate the gage a fer each use GAGEtrak will not automatically calculate calibration due date
124. ds Use these records to define the list of standards or test parameters that you measure when you calibrate the gage Later when you enter a calibration record for the gage GAGEtrak automatically copies this list to the calibration record It sorts and displays your calibration standards in ascending order based on the standard IDs You can enter as many calibration standards as you need The Calibration Standards table contains these fields Field Button Name Description Standard ID Enter the name or ID of the calibration standard or checkpoint for example Gage Block Each standard ID that you enter for the gage must be unique If you need to use the same name for multiple standards number or letter each name For example if you re using CMM Check in more than one standard ID number the name for each standard Your IDs would look like this 01 CMM Check 02 CMM Check 03 CMM Check This numbering also lets you control the list s sort order the program automatically keeps the list in alphabetical order by the Standard IDvalue Type Two types are available Variable or Attribute Select Variable for those standards that have a value that you actually measure such as 0 502 inches Select Attribute for pass fail or visual types of checks Units Indicate the units being measured such as inches mm or degrees When you enter the nominal measurement GAGEtrak automatically calculates the minimum measurement based on
125. e a New GAGEtrak Database You can use multiple databases with GAGEtrak For your convenience the program installs an empty data file in the same location as your database named GTDATAA40 2007 EMP Copy this empty data file for each additional database that you want to use Before you add a new data file you may want to create a new folder in which to store it Use Windows Explorer or My Computer to create the new folder You can name your folder to identify which GIDATA40 2007 MDB file it contains such as PLANT5 or CALIPERS or by the name of a customer or a supplier For example if you had a database for three locations you might name your folders as follows C Program Files GTW4 2007 CHICAGO GTDATA40 2007 MDB C Program FilesGTW4 2007 MIAMI GTDATA40 2007 MDB C Program Files GTW4 2007 SEATTLE GTDATA40 2007 MDB After you ve created your new database run GAGEtrak and select File Open Database while in the main menu Click the Browse button to navigate to the new directory containing the second GIDATA40 2007 MDB file then click OK In the lower right corner of the main menu you ll find the name of the database file that you re currently using as shown here Service Request Entry User ID Admir C Program Files Va Tw 20075 T5 amps 2007 mdb 201 202 Appendix C Database Management GAGEtrak will remember which database file you last opened even if you quit the program and restart it later To open and use
126. e dederas Orid tcs Ned e p veste Ip beE He PUE s EIN e URSI o IRI RAD 134 AppendbcA Calibration Label KIt suuiinuni rimi nate ni rama cata vid aaa aa daaa aaa anaana aaia 137 Installing the Label Printer and Windows Software 4 eere Leere eres eese ener eee eene en ette etse t testae tane ta setas 137 Printing Calibration Eabels nasua bu e PURI 9O PUES DIRE ee PEERS Ran HIE EHE Lato ae PUE Arann 137 Printing Labels from Calibration Entry uoi ators oa ER LOIN EU FER vba Ee LER EO ines cinema CR Te LU EM R 138 Printing Labels from the Calibration Labels Report sssssssscsssscssssssscssssssecsssscsscessasssceseacsnsssseceasscseccsecessscsecessaceecaceaseesas 138 Designing Your OWIESDels 5 95 9 cise ate itai a ed iut eer aaa 139 Appendix B Gage Calibration and Control ccce ccc rr eere nerenne 141 Purpose or CalibEStlopls aeos sr a e sesto notes tel sut sce iesu Du dL SD CH Ee tM EE EIE 141 Calibration Terminology m 141 CDE AON 55e hero cout suas eun abc lc M cM ra m ME 141 Purchased Precision Standalts uod eod ise ie mI HO a OU REA DID o diede aM E c 141 Purchased Working Stand ald Sachs osos eerte eibi eras to eer EH ED EDU RISE MMSF Oe R REND REDI RETE beans ERRLN IND RERO R UD AN MEC A 141 Test EquIDITIeD eoo PAA A eren Un Pet rt EMI eas ER cu etait mee eem A ur sac Er esee eet ET EI NU EE 142 Test Maleri3ls ied t RD ED mie OD da a Ma MM M EE 142 Gages Ol G3utesl
127. e directory as your program file When it s finished a message tells you that GAGEtrak successfully exported the tables Importing Data You can import data into the same tables from which you can export using the same filenames and file types as for the Export utility E Export Import OF Export Import Table s Ta Import Format to Impoit From Calibration Header Calibration Measurement Escel v3 Calibration Standards Excel v4 Gage Master Excel v5 Gage Regs Excel 97 v8 GAR Results Test Issue Trackinc The easiest way to import data is to first export data from GAGEtrak s empty database to the file format of your choice You ll then have the exact import configuration in place for the file Next open the file and duplicate its configuration for a file you already have or add the records you want to import to the file created by the export In order to import files you must name them as shown with the appropriate file extension of TXT or XLS Make sure that you put the files you re importing into the same directory as your GAGEtrak program file GAGEtrak Calibration Management Software System Administrator s Guide 185 Reset Gage Issue Status This utility is for users who have imported information to the Gage Master or Issue Tracking tables or upgraded from previous GAGEtrak versions It modifies the database to accommodate the entry and display of user defined ssue Types while it updates gage records Com
128. e its own criteria Manufacturing industries generally follow the guidelines below If the R amp R as a percentage of the tolerance is GAGEtrak Calibration Management Software User s Manual 69 o under 10 the system is acceptable between 10 and 30 you might need to further analyze the system to find the cause of the error use the Average and Range method the Long method to learn more about the problem over 30 you should perform further analysis on the system to find the cause of the error you might learn more about the problem by using the Long method Average and Range Method The Average and Range method helps you pinpoint the reasons for measurement system error In contrast to the Range method with this method you can break down the measurement system into repeatability and reproducibility E Gage R amp R oix Study Date 03 06 1397 Co Part No 521000 te 4 Prefill Gage ID 100 10 Part No 521 40 002 gt d Gage Desc CALIPER Part Desc Bracket New Delete Charts Close 6 Sigma Proc Var Appraisers E Trials 3 J Characteristic ength B Study Type Long AlAG Specification Limits 1375 1405 Comments v CLAMP 1 oaf of 01339 f o134 o134 01344 o184 01341 f 01340 2 oaas off 014 O oaf o14 014 f o se od 0 1341 3f 01342 013427 0 1341 0 1341 0 1342 0 1342 o1241f 0134 0 1342 4 o143 0 1342 01342 013437 0 13437 01943 onaf 01341 f 0 13
129. e of each row Use them to select the entire record for copying or deletion You can also use them to store any changes made to the record if you change any fields an icon of a pencil will appear on the button click on the button to write your changes to the database You can select multiple records by clicking and dragging your mouse pointer over the desired records To select all records between two records first click on the first record then hold the SHIFT key while you click on the last record This operation selects all records between the first and last records A selector button that has an asterisk on it indicates that a row is a new record position it will always be located at the bottom of the table Record Selector Bar Symbols n Current Record Record changed but not saved yet 5 New Record Record Locked and in use by another user All Records Selection Button amp Gage Entry 022E Digital Caliper 0 6 1230193 3gabz C2 This small square button is located on the upper left portion of the table just below the control menu icon Click it to select a records in the table Column Field Selector Buttons amp Gage Entry b 022E Digital Caliper 0 6 1230193 jabec Due a1 20M61 40 4126hMe1 80 NE These small rectangular buttons are located at the top of each column Each button contains the name of the field that it represents Gage D and Status in the above example When you
130. e schedule Tip Don t use too wide of a date range such as a 10 year span as it can take a long time to generate If the schedule takes too long press CTRL BREAK to stop it then try a smaller date range Schedule report options include Include days with no activity lf you want your report to include complete time frames check this box to include days on which calibrations aren t scheduled For example suppose you wanted to create a schedule for January through March and no calibrations were due in February If you left this box un checked your report would show January and March but not February If you checked this box the report would include February Default Hours GAGEtrak uses this value for gages that don t have an estimated calibration length i e their Calibration Hours fields are blank For example if you enter 0 5 GAGEtrak assigns a half hour of time only to those gages If you entered Calibration Hours for your gages leave this field blank Schedule Type Use this field to select how to summarize your schedule by day week month quarter or year Select By Day With Details for a comprehensive listing Tip You can print more than one schedule type without having to re generate the schedule each time Calibration Use these forms to gather calibration data and document work assignments Work Order Work Order for your personnel Certificate of Calibration certificates prove that you ve performed the proper calibrati
131. e the record If you don t have a gage ID numbering system you can take this opportunity to create one Tip Avoid using the characters and in your gage IDs or other fields as these are considered wildcard characters in GAGEtrak For more information about wildcards please see the Program Conventions section of the User s Manual Status Use the list box to pick from available choices such as Active or n Active This field is also required Tip If the Status field is not set to Active the Calibration Due reports will skip over the gage Ref Standard Check this box to indicate that this record is for a calibration reference standard not a gage use it to identify gage blocks or reference weights NIST No If this record is for a reference standard enter its NIST number here Calibration Standards Entry Select the Standards tab to define the set of standards that you ll measure when you calibrate the gage Later GAGEtrak automatically copies these standards to the calibration record Enter as many calibration standards as you need If you have two or more similar standards use the Standards Prefill feature to save data entry time and avoid mistakes Click the PreF ll button in the Standards screen and this screen appears GAGEtrak Calibration Management Software Quick Start Guide 23 Number of Standards 60 Start Value Increment Value Do Standard Names Gage Block Unit of Measure nh Type
132. ear You can search for any text string including a phrase a word or part of a word You can also use wildcard characters to make the search more general For faster searches search for the first few characters within a single field The Find box remains open during searches so you can find as many records as you want without repeatedly selecting the Find command If necessary drag the Find box out of the way so that you can see your records To Find Data 1 Display the table or form for the records you want to search 2 Select the field column in which you want to search unless you want to search in all fields However remember that searching a single field is faster than searching in all fields 3 From the Edit menu choose Find The Find window appears GAGEtrak Calibration Management Software User s Manual 129 T i Fini in lield Tane Kl 4 Inthe Find What box type the text you want to find Use wildcard characters such as and 2 to make your search more general 5 Set other Find dialog box options if necessary 6 To find the first occurrence of the text choose the Find First button To find the next occurrence of the text click Find Next 7 When you re finished click the Close button Replace Command While you re in either Form or Table view the Replace command is available via the Edit menu Within a database table you can search for and replace all or some occurrences of a specified text
133. ecord 132 Chapter 11 Program Conventions Go To Command You can use the Go To command from the Records menu to quickly move to different records After you select this option a submenu will appear with the following options to help you navigate through your records Command Description First To move the cursor from a field in the current record to the same field in the first record choose First Last Select this command to move the cursor from a field in the current record to the same field in the last record Next If you want to move the cursor from a field in the current record to the same field in the next record select Next Previous To move the cursor from a field in the current record to the same field in the previous record select this command New Select New to move the cursor to a blank record at the end of your form or datasheet allowing you to enter a new record Show All Records Command To display the most current records in a form or datasheet select Records Show All Records This command removes a filter if you re currently using one including a sort created with the Quick Sort command queries the database to display the most current data and then moves to the first record Copying Records You can easily copy records to save time and reduce mistakes However remember that certain records require that certain fields be unique In these cases go ahead and copy the record but make sure that you ve ente
134. ecord Formats Name Data Type Size GM Owner Text 50 Description Text 50 GM Type Text 50 Unit of Meas Text 50 Drawing_No Text 50 Drawing Date Date 8 Change Level Text 50 Change Date Date 8 Storage_Location Text 50 Current Location Text 50 Service Date Date 8 Retirement Date Date 8 Calibrator Text 50 Calibration_Frequency Double 8 Calibration Frequency UOM Text 50 Resolution Text Text 50 Operating Range Text 50 Plus Tolerance Text 50 Minus Tolerance Text 50 Supplier_Code Text 50 GM Cost Double 8 Purchase Date Date 8 Calibration Hours Double 8 Next Due Date Date 8 Last Calibration Date Date 8 Notes Text 250 Status Text 50 User Defined Text 50 RefStandard Yes No 1 GM Format Text 50 Calibrated_By Text 50 GM_Usage Double 8 AdjPlanCode Text 50 AdjCalFreq Double 8 RRFreq Double 8 RRFreqUnits Text 50 LastRR Date 8 NextRR Date 8 RRResult Text 50 LabelCode Text 50 Uncer Double 8 PriorCalDate Date 8 Nist No Text 50 Table Name Calibration Standards GAGEtrak Calibration Management Software System Administrator s Guide 197 Field Name Type Size Gage ID key Text Key 50 Standard ID Text Key 50 Minimum Double 8 Nominal Double 8 Maximum Double 8 Units Text 50 CS_Type Text 50 Table Name Issue Tracking Field Name Gage ID key Issue Date Issue lime Issued To Issued Dept Received Date Received lime Received From Notes Return Cycles Long 4 Part No Issue Tracking Type PO No ExpReturnDate Table Name P
135. edure from the Clipboard Open the program that contains the procedure you want to copy Highlight the text then press CTRL C to copy it to Windows Clipboard In GAGEtrak s Procedure screen first enter a procedure name Next click within the Procedure body field Press CTRL V to paste the procedure The pasted procedure text will word wrap to fit the region you might need to adjust it as necessary GAGEtrak won t paste text formatting such as fonts or bolding it will paste just the text Cc1ifp co N gt CalPro Calibration Procedures To help save time when you re entering procedures CyberMetrics Corporation offers an optional add on product called CalPro CalPro is a database of complete step by step calibration procedures covering everything from gage blocks to micrometers and calipers CalPro procedures are industry proven editable procedures that you can automatically import into your GAGEtrak database or use separately as documents For information about purchasing CalPro please contact CyberMetrics Corporation or your distributor GAGEtrak Calibration Management Software User s Manual 105 Procedure Entry Procedure Image In the Procedure Image screen you can attach a picture or map to each procedure To do so double click in the OLE box amp Procedure Entry lolx OLE Box Double Click in OLE box to insert object Record is 1 r of 3 OLE stands for Object Linking
136. ensuring your company s compliance with ISO 9001 and QS 9000 Chapter 3 installing and Running GAGEtrak Now that you ve seen how GAGEtrak works it s time to Install your software The following instructions will tell you how to install and run the software quickly allowing you to evaluate its major functions For more detailed information please consult your System Administrator s Guide and User s Manual which are located elsewhere in this publication System Requirements GAGEtrak 4 2007 for Windows requires the following Microsoft Windows 2000 or Windows XP Hard disk with 700 MB of free space for program files plus 5 20 MB for a typical Access database 512 MB or more of random access memory Installing GAGEtrak The System Administrator s Guide contains detailed information about different ways to install GAGEtrak and set it up on a network including how to set it up in a client server environment However if you ll just be using the program on one PC and installing it from the CD ROM follow these instructions 1 Click the Windows Start button and select the Run command 2 Place the GAGEtrak 4 2007 JCD into your CD ROM drive D and enter D SETUP EXE in the Open field in the Run box 3 Follow the installation instructions on your screen Running GAGEtrak To run your program for the first time click the Start button select Programs and then select the GAGEtrak 4 2007 program group Choose
137. ent Value of 1 with Inches your Unit of Measure f you enter Gage Block in this field the resulting names for your standards will be 1 Gage Block 1 Inch and 2 Gage Block 2 Inch Tip If your number of standards is between one and nine your standard ID names will be numbered like this 1 Name 2 Name If you have from ten to 99 standards their names will look like this 01 Name 02 Name Unit of Measure In this field enter the unit of measure that the standards share Type Select the type of standard Variable or Attribute End Value GAGEtrak calculates the end value for you depending on the Number of Standards the Start Value and the ncrement Value Fill After you ve entered the information click the button and GAGEtrak will fillin the information The Minimum and Maximum values will be calculated from the olerance and Tolerance values GAGEtrak Calibration Management Software User s Manual 51 Gage Entry Parts Use these records to define the parts and operations for which you ll use the gage By linking this information to each gage you re facilitating manufacturing traceability Before you can link a part to a gage you must enter the part s record in Part Entry see page 115 amp Gage Entry E j Information History Standards Parts Procedures Schedule Gage ID Exit Part No Description Uperation Drawing No 6754 CPA 873 v Clutch Arm Final Assy CL5
138. eport To Hide Columns 1 Go to the column you want to hide and click anywhere in it or click its field selector button Located at the top of the column To hide multiple columns drag across the field selectors 2 From the Format menu choose Hide Current Column GAGEtrak Calibration Management Software User s Manual 127 TO Display Hidden Columns 1 From the Format menu choose Show Hide All Columns Unhide Columns i21 x Column Ivi v Ref Standard v NIST No vi Gage S N JV Asset No v Description v Type v Unit of Meas M Drawing No v Drawing Date v Change Level V Change Dae Notes 2 IntheUnhide Columns window select the column you want to show 3 When you ve selected all the columns you want click Close Hiding and Displaying Gridlines By default the program shows gridlines around each cell in Table view You can hide the gridlines by choosing Gridlines from the Format menu remove the checkmark which indicates that gridlines are active Changing the Row Height To adjust the height of all rows in a table choose Format Row Height Changing the Column Width Choose Column Width from the Format menu to adjust the width of selected columns in a datasheet To Freeze Columns To prevent columns from moving off the screen choose Format Freeze Columns to freeze selected columns on the left side of the window If you haven t selected any columns
139. er the gage drawing number and date of the original drawing GAGEtrak Calibration Management Software User s Manual 47 Drawing Date usually for custom designed gages fixtures or templates Otherwise use this field to store other information Change Leveland Enter the current change level ID of the current gage drawing and the date of the Change Date most recent drawing change level Notes Use this field to store any comments about the gage Storage Location Enter the gage s storage or usual location for example Tool Crib Bin 12 Current Location This field contains the gage s current location such as Assembly Dept Service Date Enter the date on which you first started using the gage Retirement Date In this field enter the expected or actual date on which you stop using the gage Usually this date is at the end of the gage s useful service life typically 5 10 years or at the expected date of major overhaul or maintenance Supplier Code This field contains the supplier code or name of the gage supplier If you plan to use GAGEtrak s supplier records enter the supplier ID code in this field not the supplier name The drop down list box for this field contains information that you entered in Supplier Entry for more information see page 107 Cost Enter the actual purchase price or build cost of the gage Purchase Date In this field enter the date on which you purchased or first used the gage User Defined This
140. erall average range value UCL R The upper control limit for ranges R amp R Tol TV Any trials that have a range value that exceeds the Upper Control Limit for Ranges UCL R will be marked with a red flag as shown below You should review these values to see if there has been a typing error a common cause for out of control range values onf om o1241 g pisa aasar 01342 Bg Overall gage R amp R variation Percent of tolerance consumed by R amp R Percent of total variation that R amp R contributes GAGEtrak Calibration Management Software User s Manual 71 Printing the Study To print the study click the Print button and a Print menu will appear as shown here Select Print Option PRINT This Study _Data Sheet Vew This Study Data Sheet Include Analysis Sheet To print the study report click the 7Ars Study button that s in the Print section To preview the study report on screen click the 7 s Study button that s in the l ew section Use the Data Sheet buttons to print or preview a blank data collection sheet you can use to record measurements during the study If you want the two page report the second page is an analysis report that includes more detail place a check in the nclude Analysis Sheet checkbox Average and Range Method Interpretation To interpret an Average and Range Method study look at the percentage of the part tolerance that measurement system error consumes or the p
141. eration Complete Your data is now backed up For future reference clearly label the backup diskette s with the date or day of the week and diskette number The resulting backup files will be in a highly compressed industry standard ZIP format This means that you can use other utilities such as PKZIP PC Tools WinZip or Norton to restore your backup file Restoring Data If you need to restore your database file place your backup disk in the drive and click the Restore button in the Backup Restore screen If your backup used more than one disk insert the ast disk of the set A dialog box will appear highlight the file you want to restore unzip and click Open Choose a file to UnZIP RES Lookin ed 3 Floppy A J4 amp Al ex e amp 20001025 zip File name 20001 025 zip Files of type ziPt zip Cancel Iv Open as read only Now choose the drive and directory to which you want to restore the backup ZIP file Browse for Folder 24 x Select the folder where the restored files will be placed tZ Desktop My Computer a 3 Floppy A Ee C OC mssetupt C mssttgft a Acrobat3 H febewrk C3 Fedex 2 Fsmm3 EC Fsmm4 o C3 fsivd 0 53 Gtw4 ge Gtw97 xl i Cancel Note When you restore your database restore it to a different location than your current database location The Restore utility contains a safeguard that prevents you from overwriting your c
142. ercentage of total variation that s due to measurement system error As with the Range method studies no strict rules exist for determining what percentage amount you should consider acceptable or unacceptable Generally manufacturers accept the guidelines below percentages expressed as a percent of the total variation or as a percent of part tolerance If the R amp R percentage is 9 under 10 the measurement system is acceptable R between 10 and 30 depending on costs criticality of use and other factors you might need to perform further analysis to find the source of the measurement system error over 30 the measurement system needs improvement you should perform additional studies to find the source of the error If the error component of the reproducibility is large perhaps twice as much as the repeatability you might reduce error by training the appraisers on using and reading the gage and ensuring the gage face or readout is legible to the appraisers If the error component of repeatability is large perhaps twice as much as the reproducibility you might reduce gaging error by cleaning and repairing the gage such as sticking parts and or redesigning the gage and fixture to be more rigid Generating Charts Gage R amp R Entry offers an extensive variety of charts to help you determine the causes of measurement error To generate a chart from your Average and Range study click the Charts button and the Gage R amp
143. erstand more about how GAGEtrak can help you organize and document your gage and calibration records Please consult your User s Manualand System Administrator s Guide located elsewhere in this publication for detailed instructions on other entry screens reports program setup options and other features If you have any questions please contact CyberMetrics at 480 922 7300 and choose option three for Technical Support 33 User s Manual GAGEtrak CyberMetrics 16100 N Greenway Hayden Loop Suite 100 Scottsdale AZ 85260 480 922 7300 Fax 480 922 7400 www cybermetrics com Chapter 1 Starting GAGEtrak Installing GAGEtrak The System Administrator s Guide contains detailed information about different ways to install GAGEtrak and set it up on a network including how to set it up for a client server environment However if you re planning to use the program on one PC and install it from the CD ROM follow these instructions 1 Click the Windows Start button then select the Run command fi Start 2 Place the GAGEtrak Version 4 2007 2007 CD into your CD ROM drive D and enter D SETUP EXE in the Open field in the Run box Type the meme cf a program Folder document or 17 Jokerrest resource and indo jill open E For you perc coisehp exel CC emen ms 3 Follow the installation instructions on your screen Running GAGEtrak 1 Click the Start button tt Start 2 Select Programs
144. ervice Requests Comments In this field enter any notes about this request New Click this button to add a new letter Exit When you re finished click the Ex t button to return to the main menu Undo To remove any changes you ve made to the current letter click this button Delete Use this button to delete the service request or corrective action letter Preview Letter To view the letter currently linked to this record click Prewew Letter Print Letter Click the Print Letter button to print the letter associated with this record Chapter 8 Part Records Use Part Entry to track parts and set up lists of gage requirements lists of gages that you need to inspect parts as you produce them Part Entry Filter From the Enter View Records menu select Part Entry This filter window will appear Part No E Description Bo o O Operation Drawing No O Change Level O Change Date O Clear Filter Exit Use the filter to select a specific record or group of records If you want to find all of your part records leave the filter blank After you ve entered any of the optional filters click the F nd button The Part Entry window will appear 109 110 Chapter 8 Part Records Part Entry ES Part Entry i IDE XI Part No 6754 CPA 873 Description Duchim New peration Fina ss Cis Drawing No L54337 Drawing Date zmn Delete Change Level 933 Change Date iiss S
145. ese fields enter the name of each appraiser Appraiser B 1 20 Enter the appraisers measurement results in these fields Any measurements that don t match for both appraisers will appear red Prefill If all measurements will begin with similar digits you can use the Prefill feature to save data entry time New Click this button to create a blank Attribute record Calc After you enter all of the measurements click this button to see the results of Print Delete Close ANOVA Analysis of variance ANOVA is a type of study that you can use to look at the factors particularly measurement error that contribute to variability in measurement system analysis Using this method you can break variance down into four groups parts appraisers part appraiser interaction and gage repeatability ANOVA offers you several advantages including the fact that you can use it in almost any type of testing arrangement Its estimate of variation is more precise than that of other methods and it allows you to pull more information from your study such as part appraiser interaction GAGEtrak s Gage R amp R feature automatically performs ANOVA s complex calculations eliminating worry about manually calculating the results of your study However ANOVA is a difficult technique that requires you to have a thorough your study If you want to print the study click this button Click this button to delete the current record When yourre finished click C
146. f the slope multiplied by process variation Linearity PV Linearity expressed as a percentage of the process variation Linearity Tol Linearity expressed as a percentage of the tolerance shown only if you entered both the upper and lower specification limits Slope Slope value of the regression line for the plotted data a slope of zero is best when plotting bias versus reference values Gaognessor Fi IR The value that represents how well the regression line fits the data points the closer this value is to 1 the better the fit is 80 Chapter 4 Gage R amp R Entry Part Bias Average and Range Fields Note You must click the Ca c button in order to see the following fields Field Button Name Description Average Average measured value of the reference part Bias Part average minus the part reference value Range Linearity expressed as a percentage of the process variation Linearity Tol Difference between the largest and smallest part measurement Printing the Linearity Study If you want to print the Linearity study data and analysis values but not a chart first click the Calc button to display the results Then choose File Print from the top menu bar Tip If you want to print just the data for a single study then first preview the report on screen and make a note of which page numbers pertain to the study Then when you select the Print command enter the range of page numbers you want to print Otherwise the program wil
147. finished today Now it s time to organize the work for your calibration crew First you assemble the reports that you printed last Friday Because you have several calibration technicians and you have some gages that you must send off site for calibration you printed a separate Calibration report for each of these people or sites Along with each of these lists you include the Calibration Work Order for each gage that needs to be calibrated The Calibration Work Order includes a list of all of the Calibration Standards used along with the minimum nominal and maximum measurements for each standard You ve also been thorough enough to include the Calibration Procedures needed for each Work Order Later in the morning you finally receive the new gages that you ordered last week Since you already have a gage of the same type as one of these new gages you use the Clone Gage feature to copy the common information about this gage into a new gage record When you clone the gage GAGEtrak copies all of the calibration standards parts and procedures to the clone All you have to do is enter the gage s unique information like its serial number purchase date and next calibration date amp Clone Gage Eq Source Gage ID C 00001 New Gage ID Clone Exit 15 16 Chapter 2 How Does GAGEtrak Work After you clone the first gage it s time to enter a record for a completely different type of gage You enter all of the specifications
148. for the gage This button is visible only if you ve checked the Pass box for the current record Use this button to print a calibration certificate for the current record See page 123 for more information on this report Click this button to return to the main menu 62 Chapter 3 Calibration Records Calibration Timer Button Use the Start button next to the Hours field to time your calibration it works like a stopwatch When you re ready to calibrate just click the Start button Its name will change to Stop When you re finished click Stop and GAGEtrak will automatically calculate the hours for you The timer is cumulative This allows you to temporarily stop the timer and do something else Just click the Stop button to stop the timer then when you re ready to resume click the Start button again The time is expressed in decimal hours the smallest unit of time is 0 01 hours which equals 36 seconds Example 1 0 25 hours 0 25 x 60 minutes 15 minutes Example 2 0 01 hours 0 01 x 60 minutes 0 6 minutes Calibration Entry Measurements amp Calibration Entry F3 Calibration Measurements Procedures Labels Gage ID fc 00001 Exit CALIBRATION MEASUREMENTS Standard ID Gage ID of Standard 1 Gage Block 1 Inch _ J S NB78334 lu Minimum Nominal Maximum Before Accuracy Limited Uncertaint Units Type After Accurac Use 1 000000 0 000000 A 1 000000 0 000000 Comments 2 Gage Block 2Inch S N
149. ge click this button see page 54 New Record When you need to create a new record click this button Undo If you want to remove a change you ve just made click Undo Delete To delete this gage record click this button Exit When you re finished with this record click Ex tto return to the main menu 48 Chapter 2 Gage Records Gage Entry History The History tab displays all calibration history for the selected gage ID These records are sorted by date in descending order this means that the most recent calibrations are at the top of the list GAGEtrak pulls this information from the data you record in Calibration Entry Field Button Name Description Gage ID The ID code for the current record appears in this field Date This field shows the date for each calibration record By In this field you ll see the name of the user who performed the calibration Pass This field tells you whether each calibration was successful Results Any additional results recorded about the calibration will appear in this field Type A description of the type of calibration performed will appear in this field Gage Entry Standards amp Gage Entry 1 Gage Block 1 Inch a F eesesieecmen Fe cexesteck Gainey v eiie _ Frcasesioar e v sie T e TC am 7 0 GAGEtrak Calibration Management Software User s Manual 49 Calibration Standard Recor
150. ge R amp R studies for only the gage shown in the Calibration Entry screen Range Method Short Method The Range method also called the Short method offers a quick estimate of measurement variability This method provides an overall picture of the measurement system but it doesn t break down the variability into repeatability and reproducibility The Range method typically uses two appraisers and five parts although you can use more parts Both appraisers measure each part just once The range for each part is the absolute difference between the measurement obtained by Appraiser A and the measurement obtained by Appraiser B Next find the sum of the ranges then calculate the average range R To find the total measurement variability multiply the average range by 5 15 d You should also calculate what percentage of the process variation or tolerance the measurement variation consumes To convert the R amp R to a percentage multiply by 100 and divide by the process variation or tolerance Note The formula for d is based on the number of appraisers and parts used in the study Range Method Short Method Interpretation To interpret a Range Method study look at the percentage of the part tolerance that measurement system error consumes or at the percentage of total variation due to measurement system error No strict rules exist for determining if a percentage amount is acceptable or unacceptable each industry will hav
151. he F1 key to open GAGEtrak s on line Help Select a topic from the Contents or use the Search function to browse an alphabetical list of topics Use the Back button and History listing to return to recent topics Click Printto print any Help topic Record Filter Windows Some entry screens and reports open with filter windows that you can use to select a subset of records that match the criteria you enter This may not seem useful at first but you will appreciate this feature later when you have hundreds or thousands of records from which to select Sample Filter Window Gage ID Status O Gage S N ees Description Caliper Type StorageLocaton ssi Current Location i HH Next Due Date O Clear Filter Exit 119 120 Chapter 11 Program Conventions Accessing All Records If you want to open a of your records leave the filter fields blank and just click the F nd button Accessing Certain Records To access only certain records you can use wildcard characters optional For example you might want to edit gage records that have descriptions exactly equalto Caliper In this case enter Caliper in the Description field in the Gage Entry filter In the same way if you want to find gage records with descriptions that start with Caliper such as Caliper 6 inch and Caliper Digital then enter Caliper in the filter as shown above The asterisk is a wildcard character that indicate
152. he User s Manual This field scrolls up and down to allow for longer statements To save your changes and exit this screen click this button If you don t want to save your changes click Cancel to exit Settings GAGEtrak Calibration Management Software System Administrator s Guide 175 Defining Calibration Skip Dates amp Settings olx User Info General Cal Options Skip Dates Audit Trail Skip Date Entry Cancel Skip Sun Skip Dates 12 24 1999 333 Sk po BEANE Skip Tue 05 29 2000 07 04 2000 005 T NNNM Skip Thu Skip Fri Skip Sat GAGEtrak lets you define dates that you want it to skip when it calculates calibration due dates These days called skip dates or skip days might include holidays vacation periods or plant shutdown periods Go to the Skip Dates tab and enter as many skip dates as necessary To delete a skip date click on the record selector box on the left of each date and press DELETE To skip days of the week like weekends check the box next to each day you want to skip If a calculated calibration due date falls on a skip date GAGEtrak schedules it on the following day If you manually enter a calibration due date GAGEtrak won t apply your skip dates to it Audit Trail Use GAGEtrak s Audit Trail feature to keep a text file of actions made during use of the program such as record modifications and deletions The file also includes the name of the user who
153. his way you ll always have a week s worth of backups You might also want to archive a permanent set of backups on a regular basis perhaps once a month Next select the database file to add to your ZIP file Choose your data file GTDATA40 2007 MDB and click the Open button Select Database file to Zip RAE Look in a Gtw4 al c 8 L Backup JDTUA mdb GTSamp40 mdb Gtw4 mdb File name Gtdate40 mdb Files of type Accessi mdb Cancel Iv Open as read only Tip If your database is on your server you must change the drive letter to your network drive and select the appropriate folders then highlight GTDATA40 2007 MDB If you aren t sure where your database is located check the database location on the lower right corner of the main menu before you back up your database If you use more than one database with GAGEtrak back up each one of your databases on a separate set of labeled diskettes GAGEtrak Calibration Management Software System Administrator s Guide 179 Place a blank pre formatted diskette in the drive and click the OA button DynaZIP ZIP Request E Please insert the first disk of the Multi olume set Press OK when ready or Cancel to abort Cancel A progress meter will show you the percentage of completion If the backup requires more than one diskette the program will ask you to insert another disk When the backup is finished you ll see this message Finished Op
154. ide columns One drawback of Datasheet views however is that they cannot display the related records in an embedded table for example the Table view of gage records contains an embedded table of calibration standards for that gage you can t see both the gage record and a table of calibration standards at the same time Since the program automatically presents records in Form view you must manually switch to Table view use the toolbar button or select Datasheet View from the View menul Sample Datasheet View of Gage Records Status Description S gt 022E Digital Caliper 0 6 1 Caliper 0 6 inch Digital 1230193 1 Digital Indicator Digital Variable 38620 002 1 Temp Controllar Digital Variable 9128M61 40 1 2 344 Height Block Set Height Block 9128M81 80 1 2 375 Height Block Set Height Black A1230196 pe Digital Scale Digital Variable C 002 d CALIPER DIAL 12 INCH DIAL COMPARATOR 1 14 Kodak Optical Comparator Comparator CTGO02 1 SUNDSTRAND THREAD GAGE GO NO GO DB S N 1 1 0001 NO 3 Dial Bore Bore Gage DIO4 E MITUTOYO 0001 ELEC DROP IND DROP INDICATOR DM 00002 _ i Digital Micrometers Digital variable FGOS 1 FEELER GAGE PERSONAL FEELER GAGE SET FG25169 1 0 200 LBS DICITAL FORCE GAUGE DIGITAL FORCE GAUGE FIX143 2 OLIN WING SPAN GAGE 848 010 FIXTURE FM14 1 0 0 1 50 GPM LIQUID F
155. ing program or to make your reservation please contact CyberMetrics Corporation or your distributor 209 210 Appendix E Training
156. ip If you re using three trials the appraisers must measure the parts three times Analysis Next enter the recorded measurements into GAGEtrak for automatic calculation press the Ca c button You can then judge whether your measurement system is adequate The program marks out of control ranges with an asterisk You should re measure those readings or remove the data and reprint the report R amp R Tol R amp R Tol is the percentage tolerance measure of a gage s repeatability and reproducibility In general the gage acceptability criteria for R amp R is as follows under 10 acceptable 1096 to 30 might be acceptable based on the importance of application gage cost repair cost or other factors over 3096 not acceptable you must identify and correct the problem s AV Tol and EV Tol AV Tol is the percentage tolerance measure of appraiser variation gage reproducibility and EV Tol is the percentage tolerance measure of equipment variation gage repeatability Viewing these values as components 98 Chapter 4 Gage R amp R Entry helps you pinpoint the sources of measurement system error If the AV Tol is large compared to the EV Tol it might signify that 1 the measurement method needs standardization such as gage or part position 2 the appraisers need training in method 3 the gage dial or display is not clear If the EV Tol is large compared to the AV Tol it might signify that 1 the gage
157. is guide you ll learn how to quickly install and use GAGEtrak s three major functions Gage Entry Calibration Entry and Gage Issue and Return Measurement and Calibration Throughout history measurement has been a tricky process Before our modern measurement systems were developed people didn t have standard measurements to use in their daily lives For example if you told the local woodcutter that you needed a foot of wood you would get just that but a foot by A s definition not your definition If his feet were Longer than yours you benefited if not you were left short Gradually people began to realize that this method of measurement simply would not do They developed standards of measurement ultimately national standards However with the advent of the global marketplace it became apparent that we needed global standards to ensure part interchangeability between countries In developing these standards we were trying to ensure accuracy and precision in our measurements Accuracy is how close a measurement instrument comes to an established standard precision is how consistent that instrument is when measuring the same item several times Therefore we calibrate our instruments to adjust them to the proper standard This is where GAGEtrak comes in Every day you have to test and calibrate gages to ensure their accuracy and precision In order to ensure quality and provide for a ready analysis of a single gage s performance
158. istrator s Guide 165 11 Click Finish The SQL Server Setup screen will appear 12 To check the data source click 7est Data Source lf you don t want to test it click OK 13 When you re finished close the ODBC Data Source Administrator 166 Chapter 3 MS SQL Installation Chapter 4 Running GAGEtrak Logon When you open GAGEtrak a logon window will appear if you have set up security Enter your PIN Personal Identification Number and click OK For information about setting up user security please see page 195 Please Enter PIN No Cancel Serial Number If you haven t entered your program serial number into the About box the following message will appear to remind you to enter it Ho 5erial No Entered IN Please Enter your Serial No in the About Boxl 167 168 Chapter 4 Running GAGEtrak Click OK and the About window will appear Enter your GAGEtrak serial number located on your registration card and on the packing list that came with your package If you can t find your serial number contact Technical Support at 480 922 7300 as About E For technical support cal 420 242 7350 Expration Windows Debiri ES ANHT bam Dect org aries Access Direcborg Soper ight 1206 2007 Cyber Metric Corporation AU righbs reservec License and Trial Period Each copy of GAGEtrak 4 2007 is set to give you a 45 day single user license trial period
159. k if printed select this command Print This command prints the current record performs like a screen dump Send Use File Send to e mail the report if you have MAPI compliant e mail Exit To quit GAGEtrak choose File Exit Edit Menu Command Description Undo Typing Choose this command to remove any typing in the current field active only if your CTRL Z cursor remains in that field Undo Current Field To remove all changes to current field choose this command active only if your ESC cursor remains in that field Cut CTRL X Select Edit Cut to remove the selected text from a field or a selected record a copy is placed in the Clipboard Copy CTRL C To copy the selected text or record into the Clipboard choose Edit Copy Paste CTRL V This command is active only when you cut or copy something use it to paste the cut or copied text at the location of your cursor Delete Choose Edit Delete to either delete the selected text from a field or to delete a record select the record first Select Record Use this command to place the current record in a selected state for copying deleting or printing Select All Records To select a records for copying deleting or printing select Edit Select All Records Find Select this command to search for a record based on the current field Replace To perform a Find and Replace operation from the field in which your cursor is Located choose Edit Replace GAGEt
160. l 33 RepControl 34 ResultCodes 3 ResultCodes 3 Settings 1 jSettings Skip Dates 0 Skip Dates 0 Counts for both Source and Destination tables should be equal except where newtables have been added in Destination Takles f STEP5 Ifthe Counts match click the Finish Button 194 Appendix A Data Transfer Utility Appendix B Record Formats Key Fields A key field is a single field or combination of fields that the program uses to uniquely identify each record in a table In the tables that follow if the Data Type column contains the word Key it means that this field or combination of fields is a key field Combination Key Fields This table shows combination key fields two key fields are identified Name Data Type Size Gage ID Text Key 50 Standard ID Text Key 50 The following data table is acceptable at least one of the key fields is unique Gage ID Standard ID 100 10 1 Inch Block 100 10 2 Inch Block Whereas this data table is not be acceptable none of the key fields is unique Gage ID Standard ID 100 10 1 Inch Block 100 10 1 Inch Block Record Formats The next few pages contain summaries of the record formats within the database tables If you need information for other tables please contact Technical Support at 480 922 7300 Table Name Gage Master Name Data Type Size Gage ID Text Key 50 Gage_SN Text 50 Asset No Text 50 Model No Text 50 Manufacturer Text 50 195 196 Appendix B R
161. l button then enter a prefill value of 1 165 Now you need to enter only the last digit of each measurement Before using Pre ll enter the number of trials and appraisers for the study Tip Since all measurements must be eight digits or less you might need to code the data to fit it into the measurement fields For example suppose the actual measurements consist of 2223 11221 2223 12373 and 2223 10312 with a drawing specification of 2223 10 05 The measurements exceed the eight digit limit so you must code them To code the data use only the last eight digits of the measurements For 2223 11221 the coded measurement would be 23 11221 Coding the specifications results in 23 10 05 USL 23 15 and LSL 23 05 The resulting percentage values calculated for the study J6R amp R EV and 96AV will still be correct The program calculates these fields when you click the Ca c button Field Name Description EV Equipment variation Repeatability Tol Percent of tolerance consumed by EV 26 TV Percent of total variation that EV contributes AV Appraiser variation Reproducibility Tol Percent of tolerance consumed by AV 26 TV Percent of total variation that AV contributes PV Part Variation the portion of variation contributed by the parts Tol Percent of tolerance consumed by PV 1V Percent of total variation that PV contributes TV Total variation resulting from both gage variation and part variation R bar R The ov
162. l print all of your studies Linearity Chart To generate a Linearity chart click on the Chart button You ll see a plot chart of the Bias versus Reference Value for each point as well as a best fit linear regression line which should have a downward negative slope Example Linearity Chart Linearity Plot wie oo 2 4 B i 10 Reference Value Printing the Linearity Chart To print the Linearity chart first generate it on screen then select File Print Click the Print button to see a preview of the report before printing it Linearity Study Interpretation The Goodness of Fit value R of the linear regression line determines whether the biases and reference values have a good linear relationship This value will be a number between 0 and 1 the closer it is to 1 the better the linear relationship is Using the slope of the regression line and the process variation or tolerance of the parts the program calculates linearity and percent linearity of the system If the regression line has a good linear fit then you can evaluate the magnitude of the linearity and percent linearity to determine if the linearity is acceptable If the regression line does not have a good linear fit then the bias average and reference values might have a nonlinear relationship You then must perform additional analysis to determine if the measurement system s linearity is acceptable GAGEtrak Calibration Management Software User
163. lapsed calendar weeks Months schedule is based on elapsed calendar months EOM rounds the next due date to the end of the month in which it occurs For example 6 EOM means every 6 months but the program extends the due date to the end of the sixth month or the last working day of the month if you re using skip days see the System Administrator s Guide for more information Years each year equals 365 days schedule is based on elapsed calendar years Usage when using this schedule the program won t create a next due date for calibration until you issue use the gage even if you enter a calibration record for the gage When you issue the gage GAGEtrak calculates a predicted next due date based on the remaining number of usage days You must use the Issue Tracking records for this to work Cycles similar in principle to the usage days method but it tells the program to schedule calibration only when the total number of cycles equals the calibration frequency value You must use the Issue Tracking records for this schedule to work Each Use select this option if you calibrate the gage before or after each use GAGEtrak Calibration Management Software Quick Start Guide 25 you must manually enter your due dates Bef Use select this option if you calibrate the gage before every use you must manually enter your due dates Aft Use select this option if you calibrate the gage after every use you must manually enter your d
164. lated Uncertainty will be wrong 30 Chapter 5 Entering Calibration Records Other Calibration Entry Options Like the Gage Entry options we ll talk about each of these Calibration Entry options in the User s Manual Tab Button Name Description Calibration Use this screen to view the procedures that you use to calibrate the gage The Procedures program copies these procedures from Gage Entry Procedures Labels From this screen you can print a calibration label for the current record only if you have the optional GAGEtrak Calibration Label Kit Gage R amp R To enter a gage R amp R study click this button to access Gage R amp R Entry Graph If you want to see an accuracy chart for the current record click this button Delete Click this button to delete the current calibration record Chapter 6 Issuing and Returning Gages Gage Issue and Return In Gage Issue and Return you can track each time you loan out a gage including return information This is particularly useful in a gage crib where gages and inspection equipment are checked out and then returned for storage By tracking this information you ll identify which gages your company uses the most and who uses those gages You ll also be able to locate any gage Another purpose of these records is to track gage usage times and cycles if you base the gage s calibration schedule on days used or cycles If you consistently use the Part No field you can create manufacturing
165. le is based on elapsed calendar days Weeks each week equals seven days schedule is based on elapsed calendar weeks Months the schedule is based on months Last R amp R Date Years each year equals 365 days the schedule is based on elapsed calendar years When you first enter the gage record enter the gage s last R amp R study date As you add new R amp R records for the gage as long as you use an R amp A Frequency value other than zero GAGEtrak automatically updates this field Last R amp R Result This field shows the last gage R amp R study results usually this is the gage error GRR expressed as either a percentage of TV or a percentage of tolerance Later it will be automatically updated as you add new R amp R records for the gage as long as you enter an R amp R Frequency value other than zero Next R amp R Date This field tracks the next gage R amp R due date GAGEtrak automatically updates it whenever you add a new R amp R record for the gage or you can manually enter a date into this field If the today s date is past the next due date you ll see a Past Due message Tip To calculate this date immediately click the Next R amp R button only if you ve entered an R amp R frequency and a last R amp R date Future R amp R Dates To the right of the Gage R amp R fields you can see the next three future R amp R dates GAGEtrak calculates these dates when you click the Next R amp R button then updates them when you add a new R
166. lii 2 d Liser ID Admin z Program Fikes tG Tw 4 200 743 T5 mp44 0 200 7 mc 171 172 Chapter 5 Setting Up GAGEtrak GAGEtrak Settings In the first Settings screen User Info enter your company information E wiles IECIT Cal Cpi amp as Sipp Cersa arr Tai aur pues inlvrrrrmiium User Information Entry Field Button Name Description Company Enter your company name address phone fax numbers and logo optional The Information two lines for your company name and logo will appear at the top of all reports Paste Logo and To enter your company logo use the nsert Object or Paste buttons Use nsert Insert Object Objectif you already have a logo file or want to create the logo in a graphics program and link it to CAGEtrak Use the Paste button if you ve copied the logo to Windows Clipboard Try to insert a logo graphic about the same size as the logo region shown Otherwise you might not have enough memory available to print the logo on your reports Also to avoid wasting memory don t use a logo with more colors than your printer can print You can use a scanner to obtain your logo but scanners are often set for more resolution or colors than your printer can support A logo created this way becomes a huge file that uses an excessive amount of memory To conserve memory paste your logo into GAGEtrak as a BMP file even if you created it in a graphics program Pasting your logo as a bitmapped object
167. lity LCL 5 15 Ma 5 15x 40 00005 0 04 5 155 5 15x JAM 5 15x 0 00091 0 16 UcL 5 15x 4 AVueL 5 15 0 0230 0 78 YTV Std Dev TV 0 16 1 05 14 8 PC TV 2 2 Part x Appraiser LCL 5 15x Jet 5 15x 40 0008 0 15 E s RS 5 15x 40 00223 0 24 UCL 5 15 x luct 5 15x 40 0054 0 38 YTV Std Dev TV 0 24 1 05 23 2 PC TV Gage R amp R LCL 5 15 x VRRict 5 15x 40 0036 031 5 1555 5 15 x J RR 5 15x 40 00444 0 34 UCL 5 15x JRRua 5 15x 40 0266 0 84 YTV Std Dev TV 0 34 1 05 32 7 PC TV 10 7 GAGEtrak Calibration Management Software User s Manual 95 96 Chapter 4 Gage R amp R Entry Part to Part LCL2 5 15x Priel 5 15x 40 0146 0 62 5 15 5 15 JPM 5 15x 0 03716 0 99 UCL 5 1 5x 4 PMjci 25 15x40 1119 1 72 YTV Std Dev TV 0 99 1 05 94 59 PC ogTV 89 3 GAGEtrak Calibration Management Software User s Manual 97 Measurement System Evaluation Procedures To perform a measurement system evaluation gather ten parts and discreetly number them put the numbers on the back of the parts so they aren t obvious Use parts that represent the variability normally seen in production Next randomly mix the parts Appraiser A measures the ten parts while Appraiser B records the measurements and corresponding part numbers Next Appraiser B measures and Appraiser A records Appraiser C if you use three
168. ll Technical Support at 480 922 7300 You can contact Technical Support to obtain a trigger code anytime within the 45 days after you install the program or you can wait until you receive this message If you re using the software on just one workstation and you receive this message it means that your operating system has detected more than one instance of GAGEtrak open on your computer Close any unidentified open applications or restart Windows to remove the message Appendix E Training CyberMetrics Corporation offers GAGEtrak for Windows training workshops on a regular basis throughout the year at various locations This one day hands on training workshop will take you step by step through planning preparation setup and successful operation of the GAGEtrak calibration software You ll learn how to save time avoid common mistakes and maximize the use of your software You ll also learn about advanced topics such as data import export data filtering system maintenance system security creating macros performance tuning and more Anyone involved in the implementation or use of the GAGEtrak for Windows calibration management software is encouraged to attend We keep our class sizes small in order to provide individualized instruction and assistance Attendees will receive a complete workbook detailing all of the training topics presented in the workshop On site training classes are also available For more information about our train
169. ll and bell but not bill matches any single character within the brackets Tip Because it allows a literal search on wildcard characters this character helps you find records that contain wildcard characters for example to find Machine 1 you would enter Machine 4 1 Z is another wildcard character b lae lL bill and bull but not bell matches any character not in the list between the brackets bla cld bad bbd and bcd matches any one of a range of characters GAGEtrak Calibration Management Software User s Manual 121 Floating Toolbar In GAGEtrak you can access common program functions from a floating toolbar that appears in all entry screens If you don t want the toolbar to appear you can disable it through GAGEtrak s Settings screen see the System Administrator s Guide for more information 1 Repositioning the Toolbar Toolbar Form To move the toolbar click its title bar and drag it to its new location d 7 5n MP Sl 3 Resizing the Toolbar Click one of the edges of the toolbar and drag it to the desired size Shown in Horizontal Mode Button Description Eg Click this button to display your records in Form view the default Form View presentation of your records In Form view you can see all of the fields for a record but you can see only one record at a time To display your records in a tabular format click this button Table views Table View allow you to view many records at a time av
170. ll fill Calibration records with information x from the Calibration tab in Gage Entry The Calibration Frequency Calibration Frequency Units and Next Due Date in Calibration Entry will be filled in only if those fields are blank Make sure that those fields in Gage Entry are correct and that you have backed up your database before you run this utility Do you wish to continue 186 Chapter 6 Other Utilities Appendix A Data Transfer Utility Use this utility only once when you install your new GAGEtrak 4 2007 and need to transfer your data from GAGEtrak for Windows Version 3 0 3 1 3 5 4 x or 4 2007 if you re using a client server setup with Version 4 Version 3 Version 4 0 Version 4 2007 Version 4 2007 New 3 means any GAGEtrak Version 3 or higher including GAGEtrak 97 and GAGEtrak Version 3 For GAGEtrak 97 32 bit the database file is DATA9731 MDB the archive file can be named either ARCH9731 MDB or ARCH9735 MDB For GAGEtrak Version 3 16 bit the database file is DATA30 MDB the archive file is ARCHIVE MDB 4 0 means any GAGEtrak Version 4 Access Database The database and archive are in one file GIDATA4O MDB 4 2007 means any GAGEtrak Version 4 2007 Access Database The database and archive are in one file Transfer to ODBC database Use 4 2007 New to populate newly created ODBC database first Running the DTU overwrites your GAGEtrak 4 2007 database You need to run the DTU because
171. ll of your gages You also print the Standards Traceability report which shows all of the reference standards associated with your calibration standards for every calibration Now you have documented proof as to exactly which instrument or standard you used to calibrate each gage If your auditor asks for more information about your reference standards you can quickly generate reports showing each one s NIST number uncertainty calibration schedule calibration history calibration certificate numbers and even the exact calibration measurements since you ve entered this much detail into your GAGEtrak records It s time to go home now and you re ready to go As you leave you try to remember what your workday was like before you had GAGEtrak How did you ever manage Benefits As you can see using GAGEtrak and its accessories saved you a lot of time effort and stress Let s list these benefits by what feature of the program they used 1 X You easily and quickly generated an accurate Calibration Schedule 2 Youalso easily generated an Automatic Calibration Due Listing report that told you what you had to do for the day Plus you were able to give each of your technicians the Calibration Work Orders and Calibration Procedures that they needed for their assigned calibrations 3 The PDA gave the technician who was going off site a faster less cumbersome way of recording his calibration information and later you will easily be able to u
172. loseto return to the main menu understanding of how to explain your findings GAGEtrak Calibration Management Software User s Manual 87 When gathering data for an ANOVA study you must be careful to use random measurements in order to prevent bias values To do this you can use a random number table or a simpler technique such as pulling appraiser part measurement assignments out of a hat or bowl No matter what method you use you must carefully plan then execute your study ANOVA Study Screen Study Date 12 23 1399 Gage ID 022E Digital Caliper 0 6 Gage Desc Caliper 0 6 inch Appraisers E Trials J Characteristic Length Study Type ANOVA JOE m TALL e Lu Appr A f oes 7 555 0 85 nz m 095 055 1 To 1 2 3 4 5 6 7 8 9 0 L 1 Lower CL 5 15 STD DEY UP Repeatability Reproducibility 0 036 Part x Appraiser Gage R amp R Part to Part 081 Study Variation Record ta 1 11 dx of 7 GAGEtrak s ANOVA study screen contains the following fields and buttons Co Part No 0221 1 Part No 10 221 1 Part Desc Bracket Rt Hand pm o Pad 0 5 UL m m m o oo e nr an 2 IN rx of Oho gt f mf af o e e e f en alia D D in Delete Charts Close Comments Hp of coy om TALL oa e oo ER CL Total Variation 2a CO
173. lues throughout the operating range If the graph shows that a straight line could represent the plotted points then a best fit linear regression line between biases and reference values represents the linearity between those two parameters GAGEtrak Calibration Management Software User s Manual 79 Linearity Study Screen Linearity Study lolx Study Date 04 10 1997 Co Part No 521 40 002 Gage ID COMPARATOR kj Part No p24002 H Gage Desc 14 Kodak Optical Compar Part Desc Spacer Study Type Linearity Characteristic Angle Dep Delete Chart Close Appraiser J Smith Spec Limits J fs Sigma ProcVar 6 amp 6 PART REFERENCE 1 2 3 4 5 NEM 023 4 A25 3 E M co 1 2 7 5 1 5 8 7 6 9 1 Validation test using AIAG MSA 2 25 33 57 zal 33 Reference Manual page 3b 3 i 4 5 9 24 2 gf 78 95 T 4j 2s5 5 59 77f 93 R E oA sof of 79 94 A 6 23 39f 61f 78f 95 m L z 25 39 of vel 95 Linearity Analysis s 8 725 39 ey L zr mam Average Bias 00253 3 27 39 65 785 95 Linearity 0 84 ELE UL cp 73 5 Linearity PV 740 s 342p 63 76 92 5e Average 525 aE e 78517 33907 gt E W A a a S Godness of Ft oss Rane a4 taf oes e2 a5 The Linearity Study screen contains these fields Field Button Name Description Study Date Enter the date of the study this field defaults to the current date
174. ly use this method more than the search options To remove any existing filter values click the Clear Filter button Click the Find button to go to the main entry screen 45 46 Chapter 2 Gage Records Gage Entry Information Seam pers Deets Punt Perito eei Gage ltt Too a Jimma jima Pei Fermi O PART fa zl Gage PME 67 7 7 PEI Poebzab 70 Madeta UU To enter a new gage record click the New Record button it looks like a blank sheet of paper on the floating toolbar or click the Vew Record button at the bottom of the screen Use your mouse cursor or TAB key to move between the available fields in the gage record window Press the F2 key to edit existing field information Gage Entry Information records contain the following fields Field Button Name Description Gage ID In this field enter a un que alphanumeric identification code for each gage In order to save the gage record you must enter an ID For consistency and efficiency you ll need to develop your own gage ID numbering system Tip Avoid using the characters or in your gage IDs or other fields as these are considered wildcard characters in GAGEtrak If you must use these characters such as in Gage 1 then you must place brackets around the wildcard character whenever you want to search or filter your records for example you would enter Gage 1 Status Use the list box to pick from your available choices for example 1 Active
175. m square AV appraiser variation upper control limit CF correction factor DF degrees of freedom CHI CHI probability distribution CHI inverse of CHI probability distribution DF degrees of freedom DF appraiser x parts degrees of freedom DF appraiser degrees of freedom DF gage error degrees of freedom DF parts degrees of freedom EV equipment variation EV inverse of equipment variation EV equipment variation lower control limit EV equipment variation sum square EV equipment variation upper control limit Fy inverse of F probability distribution F F probability distribution interaction lt interaction lower control limit l interaction sum square la Interaction upper control limit Study Values k 3 n 10 r 2 Appraiser DF k 1 3 1 2 Parts DF n 1 10 1 9 App Parts App DF x Parts DF 2x9 18 Totals GAGEtrak Calibration Management Software User s Manual 91 k number of appraisers LCL lower control limit MS appraiser x parts mean square MS gage error mean square MS parts mean square n number of parts PC percent contribution PV part variation PV part variation lower control limit PV part variation sum square PV part variation upper control limit r number of trials R amp R repeatability amp reproducibility RR a R amp R lower control limit RR R amp
176. may not apply to you Copyright CyberMetrics Corporation All Rights Reserved Table of Contents Q ick ea UL os cius nadie est cni os RESIDUI DO EDUED 11 Chapter 1 Io ugiefo V ejiTo pem eati 13 DVSCVI Cod cena DD ND ML e M i cuu E 13 Measurementapd Calbralloli secco seva ep edam SNO CHR ces eese ceo nd is E Ncque dissi N avecausess 13 Chapter 2 How Does GAGEtrak Work Leere eere Irc erre eene nenne nnmnnn nnmnnn 15 A Typical Day in the Calibration Laboratory sees eis eoe aet dera eee y o a eiae eau e peu eia vae one uet eg a ERE ER Ete thes 15 EC IS FIRS ieee ban NEL Em ncn e E A 17 Chapter 3 Installing and Running GAGEtrak Leere L erre r erre e eene ennaanna 19 Sytem REGUIL EN ICIALS seien eo epe tea qe ues o VEI UE de ua REN ERUNT auc D en TOE AE a eden E D MEE 19 Installing GADEIU SK i onadto nemo mao een deti utn Ib utn bao cau s tac HER 19 R nning GAGEIUL3Ka ete E er eee ee ee Se EAE dive vac visse A LEM LE 19 TUSHAR PPS TOGA meet M P 20 Mali MORBUS cie ennt e DA Ot cadet eh dad tend Pec d uA AT INI A MU IA SM AI AT I ss 20 Chapter A Entering Gage Records uode tanitani mea ice Eos bass Ue ebu ie dessus astute e ceca c Fa OR aa 21 GAGS EMMY NE TD TN 21 Gage nformati M serere o e n Uo oL DEO ANR HEAR NEED TUE ERN RR NDA B IHE SAU DUE ED UE Ren 22 Calibration Standards EM ey Seueri o desea t tcr Ee dnec Ense ia
177. n of this manual beginning on page 125 This will help you learn the most efficient ways to use your program s basic commands and functions Entering Gage Records Gage Entry Filter Use Gage Entry to enter gage information issue return gages set up calibration standards and link calibration procedures to gages When you select Gage Entry from the Enter View Records menu this filter window will appear ELE F rir Fi ae dl If you want to search for a particular gage and don t know its ID then select the st box button it has a downward pointing arrow next to the Gage D field A list of all available gages showing both gage ID and description will appear Similarly for the other fields you can select from the list box if one is available or type in information that applies only to the particular gage s you want to find In any of the list box fields after you type in one or two characters the first option that begins with those characters will appear in the field To save time if this is the selection you want you can instantly go to the next field instead of entering the rest of the characters In the sample screen the user is searching for active dial gages with IDs that start with the letter A the asterisk is a wildcard character that is an effective search tool see page 126 for more information If you don t enter any filter information GAGEtrak will present all of your gage records At first you ll probab
178. n user in the lower left corner and shows the full path to the current data file in the lower right corner m GAGEbak 4 2007 Main Records 40 Chapter 1 Starting GAGEtrak The main menu contains the following buttons Button Description ere Click this button to access the Main Records menu where you can add change EEG or delete records for your gages parts suppliers and other elements of your calibration management system Main Records J y Click this button to access the Calibrations Menu where you can add change or E delete calibration records Calibrations r Click this button to access your GAGEtrak Gage R amp R studies Click this button to access the GAGEtrak Reports menu Click this button to set up your GAGEtrak program or enter user information Er Click this button to back up your GAGEtrak data import or export data Access EU database or archive or un archive records IU Click this button to edit your GAGEtrak data tables directly or run utilities Utilities GAGEtrak Calibration Management Software User s Manual 41 Organization of GAGEtrak s Menus Enter View Records Menu Gage Entry Information History Standards Parts Procedures Schedule Supplier Entry Procedure Entry Service Request Entry Part Entry Gage Issue and Return Calibrations Menu Calibration Entry Calibration Measurements Procedures Labels Gage R amp R Menu Gage R amp R Entry
179. nd exporting or importing records Remove Spaces from Gage IDs Run this utility once after you ve imported data from any other gage management program This utility removes any unnecessary trailing spaces that your old program used and that were in any databases that you imported into GAGEtrak It also rounds your calibration measurements to six decimal places removing any extraneous digits added or transferred during the import process Depending on how many records you have this process can take from one to ten minutes Note This utility is not the same as the GAGEtrak Compact Data utility The Compact utility doesn t remove spaces it removes old deleted records that you no longer need Set Status of Gages This procedure updates the Gage Entry Status field for all records to which you haven t assigned a status It changes these empty Status fields to status 1 Active This utility won t change the status of any gages in your database that already have a status Note Use this utility only if you re upgrading from a 1 x version of GAGEtrak or if you imported data from another program or file format If you re upgrading from a 1 x version of GAGEtrak run this utility after the Data Transfer Utility see Appendix A Backup Restore You should periodically back up your GTDATA40 2007 MDB database file we suggest that you do so every day We recommend that you use GAGEtrak s built in Backup Restore function for this task However if you h
180. ndustry Action Group Southfield Michigan 1995 highly recommended to order a copy call AIAG at 810 358 3003 and ask for document number MSA DUNCAN A J Quality Control and Industrial Statistics Fourth Ed Richard D Irwin Inc Homewood Illinois 1974 GRUBBS F E Errors of Measurement Precision Accuracy and the Statistical Comparison of Measuring Instruments echnometrics Vol 15 February 1973 HICKS C R Fundamental Concepts in the Design of Experiments Holt Rinehart and Winston New York 1973 LAZUR John G Measurement Systems Analysis General Motors publication March 1985 WESTERN ELECTRIC Statistical Quality Control Handbook Select Code 700444 Indianapolis Indiana Chapter 5 Supplier Records Supplier Entry Filter To enter supplier records select Supplier Entry from the Enter View Records menu A filter window will appear enter any search criteria if you want to open only a certain group of supplier records Otherwise leave the filter fields blank click Find and all supplier records will appear amp Supplier Entry Filter x Supplier Code l GAGE Name PC Teppe d User Defined 1 User Defined 2 GO f Clear Filter Exit In the sample screen note that the user is looking for all suppliers whose supplier IDs contain the word gage 101 102 Chapter 5 Supplier Records Supplier Entry After you click Find the Supplier Entry window will
181. nected to the correct path before you run the scripts To exit this screen without running the scripts click Cance to return to the main DTU screen When you re finished running the scripts you can begin transferring data Next you ll see several sets of instructions for running the Data Transfer Utility Please consult the section that corresponds to your old version number After You first create your blank ODBC database from the scripts you must run the DTU from version 4 2007 New to fill in the default tables before you can use GAGEtrak version 4 2007 especially if you are a new customer and do not have any data from a previous version of GAGEtrak to transfer into the newly created ODBC database 9 Data Transfer Unity Version 4 2007 Yersion 4 2007 Hew DhMame TEE 2007 Daa A 5 1 1 2007 Source Connection Infonmation Dectinalon Gonnechon IEndeimalien EE Bun Scripts Transfer Data _Exit 190 Appendix A Data Transfer Utility Data Transfer Instructions Version 4 2007 Access Users to Client Server Version 4 2007 Converting your old version 4 0 database file GIDATA40 MDB E Data Tianslen Wititi Verzion 4 A007 u So urce D La Ha ze I Derlinatim 1 D ata Bas E bH ame I Don I3 Emu abge Farmon 4 ZF bala 4 Fast re mr I 1 Under Source Data Base select Version 4 0 Data 2 Click the small button on the right of the Source Connection Information field to n
182. nked files and other problems Next run Disk Defragmenter to reorganize your files this keeps your files from being spread out in pieces all over the hard drive Your disk accesses will run somewhat faster and your hard drive will be less prone to problems To 205 run these utilities check the Start button select Programs then choose Accessories Highlight System Tools then select the utility and follow the directions on your screen Maximizing Your Performance We recommend that you keep a large amount of empty hard drive space for your operating system s virtual memory management If you have limited resources and GAGEtrak runs slowly try closing all other applications to devote all available system resources to GAGEtrak Installation Fails If for any reason you cant install your CD or you receive any error messages during Installation try reinstalling the CD If installation fails again please write down any error messages and call Technical Support at 480 922 7300 for further instructions Repairing Data Files Although GAGEtrak has been designed to be as trouble free as possible error messages may appear because of occurrences like power outages accidental resetting of your computer network disconnects and other mishaps In these cases you might need to repair and compact your data file GTDATA40 2007 MDB You can do this by selecting the Compact Repair Data utility from the Tools and Utilities menu Depending on the size
183. nsion In this field enter the dimension or characteristic that you will check with the gage Control Method Enter the control method such as Inspection Sheet or Control Chart Freq Specify how frequently you will inspect the part with this gage such as 5 per Shift or 10 per Day Comments Record any notes about the dimension or characteristic that you re checking Chapter 9 Gage issue and Return Batch Mode You can issue and return gages one at a time via Gage Entry click the ssue Return button to open Issue Tracking Entry For higher volume batch mode processing of gage issues and returns use Gage Issue and Return Intended for use in a gage or tool crib this feature was designed for bar coded data entry but will also work with manual keyboard entry Select Gage Issue and Return from the Enter View Records menu Another menu will appear click either ssue Gages or Return Gagesto open an entry screen amp Issue and Return Menu i OF x Return Gages Exit I flssue Gages y Gage ID Next Due Date E Issue Date 03 30 1998 Issue Time 338PM Type Production Use ml Issued To 5 xf j l Issued Dept Job 7512FinalAssy m E Part No 575scPae7s Ej Storage Location Tod Cib Bn12 E Current Location TodC b Bini2 ut Received Date E Received Time jin Received From __ _ Cycles ld 4 4 Next
184. nt record for the first gage in the group will appear To enter a new calibration record click the New Record button 59 60 Chapter 3 Calibration Records gt Calibration Measurements Procedures Labels Gage ID C 002 E Gage R amp R New Record Description CALIPER DIAL 12 INCH Gage S N SN19803467 _ Graph Undo Calib Freq 3 MONTHS Next Due 10 15 1995 Exit Delete Calibration Date 10 12 1995 Time 6 09 PM Gage Master Certificate Department ac 4 By JB Calibration Type As Found Condition n Results Passed Okto Use Pass M Using Auto Adjust I Action Required Calibration Status Findings Uncertainty pones First Procedure Name CP22E Revision 12 01 97 ENVIRONMENTAL Temperature fC Pressure PO Humidity O Other i ACCOUNTING Costs rt wD Account No fC O Hours 025 025 Star CerlificateNo Record 14 4 11518 ri LEA of 141 Each calibration record contains the following fields Field Button Name Description Gage ID Use the drop down list box to select from a list of available gage IDs Tip Once you ve selected a gage to calibrate do not change this field After you save the calibration record you can t edit this field If you want to enter another calibration record for this gage or for another gage click the New Record button first Description GAGEtrak looks up the gage s description from its Gage E
185. ntry record and displays it here you can t edit it in this screen Gage S N This field displays the gage s serial number you can t change it here Freq After you mark the gage as having passed calibration GAGEtrak displays the calibration frequency that you entered in Gage Entry If you need to edit this value do so in Gage Entry Calibration frequencies are stored with the calibration record This allows you to maintain a complete history of calibration frequencies and how they might change over time Note If you checked the Auto Adjust Cal Frequency box for this gage whenever you enter a new calibration record GAGEtrak will automatically adjust the Calibration Frequency according to the rules you defined in the Frequency Adjustment Factors table Please see the System Administrator s Guide for details This field stores the next due date for calibration based on the calibration INEKE LUG HALE frequency You must check the Fass box in order for GAGEtrak to show the next due date Date Use this field to store the date of the calibration it s automatically set to the current date but you can change it until you save the calibration record Time Like the Date field this field automatically displays the current time If you change the time enter it in this format HH MM This field is required Department In this field select or enter the name of the department that used the gage before calibration By Select or enter the n
186. o add change or delete records select the menu button that looks like a yellow folder To view or print reports select the button that looks like a printer To configure GAGEtrak set up users back up your data edit your data tables archive or un archive records export records or run a utility select the menu button that looks like a pocket of tools To exit the program click the X in the upper right Chapter 4 Entering Gage Records Gage Entry To begin entering your gage records select Gage Entry from the Enter View Records menu A filter window will appear as shown below 6 Gage Entry Filter x Gage ID m Status A GageS N Description oe Type m Storage Location z Curent Location Next Due Dat Clear Filter Exit Since you don t have any gage records entered yet leave the filter fields blank After you enter your gage records you can use these fields to narrow your record searches Click the F nd button to go to the gage record window 21 22 Chapter 4 Entering Gage Records Gage Information free Rey eee en Pee Soret To enter a new gage record click the New Record button at the bottom of the screen then fill in the gage record with your data Below are brief descriptions of the major fields in this screen Field Button Name Description Gage ID Enter a unique alphanumeric gage identification code you must enter this ID in order to stor
187. o correct changes to your C AUTOEXEC BAT file Edit the file using Notepad Tip If you have a PATH line in this file make sure it includes the following C WINDOWS C ORAWIN95 BIN assuming that C ORAWIN95 BIN is where you installed Oracle Tools and that CAWINDOWS is the location of your Windows installation 7 Reboot your system Install Updated Oracle ODBC Drivers Next install your new Oracle ODBC drivers 1 Click Start and select Programs Oracle for Windows 95 Oracle Installer You ll see the Software Asset Manager screen E Suflwaie Assal Maran No Pandurts Awailahle Products Installed ab Caw Askio ComminF ke 89 00 Javal TH 3un mz Erercrmert 1 17 90 0 Tuseme Idiv 8 5 J ry ell firari 7 2 Fyren Scope ANE AN Orack TZ2 IF Fiotozcl Adapter z 05 J C Orach T sce Colezlio zr4zes 05 2 0 Miah ODBCE ma 05 CO Uashi Haase Nude OJ LUU Kenti zo Seppo Pikes SU UU COE CRAIC 4 gt Space Hequienmerily Space req_redis O in Prcduz Aesisble Space 2 27M Sedand Products Ne prozi cts is ecisc Click the From button to browse to the location of the new ODBC drivers on the CD Select the file WIN95 PRD and click Open Highlight Oracle ODBC Driver 8 0 5 6 0 under Available Products Click nstall OX on KR O When you re finished click Exit GAGEtrak Calibration Management Software System Administrator s Guide 159 Configure SQLNet with Oracle Net 8
188. o the largest size allowed or to minimize it to an icon If you maximize the table the Restore button Is visible Click the Restore button to return the table back to original size Saving Table View Changes While in an entry screen you can t save any changes you make to table attributes such as column widths displayed hidden columns column locations gridlines and fonts If you want to save any of these changes in your gage or calibration records use the Customizable Gage Report or Customizable Calibration Report both available form the Listings and Reports menu Each of these reports shows you a Datasheet view of your records you can follow the instructions given in this section to format your reports However you cannot change any record data when using the customizable reports For more information about these reports please see Customizable Gage Report and Customizable Calibration Report under the Report Descriptions section Printing Tables of Records You can print records in both Table and Form views To do so select Print from the File menu You can also select Print Setup and Print Preview from the File menu These commands combined with the Filter Sort command will be useful when you re designing customized reports Hiding and Displaying Columns You can temporarily hide columns while in Table view This feature helps you remove nonessential data from the screen and reduce the report s width when you re designing a custom r
189. og on to GAGEtrak Name Title In these fields enter information about the user including his or her name Location and Phone job title Location or department and phone number User Rights This area lists each program area and user privilege see the following descriptions Access Access indicates that the user can get into this area of the program If the user has only this box checked he or she can only view records Add Mark this box to let the user add new records in that area of the program Modify Check this box to let the user edit existing records in this program area Delete If you check this box you allow the user to delete records in this area Important If the user has permission to delete records then the user automatically has permission to modify records Access to Tools This checkbox gives the user access to all program utilities including the and Utilities Menu User Entry screen Tip You should give this right only to supervisors Access to Reports To let the user print from the Reports menu and print records from data Menu and Printing entry screens selecting File Print in a data entry screen check this box Chapter 6 Other Utilities In addition to setup features the Tools and Utilities menu also contains functions that help you maintain your program and database In this chapter we ll discuss these utilities including backing up your data editing data tables archiving or un archiving records a
190. only Perform this for each of the trials during the study and calculate the gage stability as follows Am sum of calibration differences for all trials Gage Stability 2 number of trials If you use the gage often and it doesn t need to be calibrated with each use you can determine gage stability by performing two gage R amp R studies Perform one study after a normally scheduled calibration and a second study just before the next scheduled calibration Calculate the gage stability as follows GageStability Largest grand average of the 2 studies smallest grand average of the 2 studies Convert gage accuracy linearity and stability each to a percentage of tolerance multiply by 100 and divide by the total tolerance Compare the percentages with these guidelines 596 or under acceptable gaging 5 to 10 may be acceptable based on application importance or repair cost over 10 not acceptable identify and correct problem o o Gage accuracy over 1096 might be caused by an error in the master worn gage parts components or measuring the wrong characteristic Gage linearity over 10 might be due to the gage not being calibrated throughout operating range a worn gage error in masters or the internal gage design GAGEtrak Calibration Management Software User s Manual 99 Gage stability over 10 could result from infrequent gage calibration the gage a
191. ons Calibration and that the procedures used meet exceed certain minimum requirements GAGEtrak retrieves the certificate information from Calibration Entry You can update only three fields in the report screen Customer nformation Statement and Format f you need to add or edit other information go to Calibration Entry Customer nformation Enter what you want to print on the certificate This might include the customer s company name contact name address telephone number or other important information Statement You can edit the calibration statement for each certificate Any changes you make to the calibration statement apply only to that record If you want to change all Calibration Costs and Labor Report Calibration Labels Batch Calibration History Standards Traceability Report R amp R Due Listing Gage Issue History Report Supplier Listing Procedure Listing Corrective Action Request Part Listing Customizable Gage Reportand Customizable Calibration Report GAGEtrak Calibration Management Software User s Manual 117 future calibration statements go to Settings Calibration Options see the System Aaministrator s Guide Format Use the drop down list box to select the format for the standards and measurements that you used to calibrate the gage Use this report to track your calibration costs for each gage You must have the optional Calibration Label Kit to print labels You can print a
192. ou can calculate the next due date even if you don t enter a calibration record for the gage Next Calib and Future To the right of the calibration schedule you ll see the next three anticipated Calibration Dates calibration dates which GAGEtrak calculates when you click Next Calib When you add a new calibration record for the gage GAGEtrak automatically updates these dates based on the current frequency Note If you re using the Auto Adjustment of Calibration Frequency feature be aware that these dates do not take into account future adjustments of the calibration frequency since GAGEtrak can t predict if future calibrations will pass or fail Gage R amp R Schedule The Gage R amp R R amp R stands for Repeatability and Reproducibility section is located at the bottom of the Schedule screen GAGE R amp R R amp H Freq o DAvs M Last R amp R Date Next Last R amp R Result R amp R Next R amp R Date SS GAGEtrak Calibration Management Software User s Manual 55 The table below describes the fields in this area Field Button Name Description R amp R Freq and R amp R Enter the frequency of gage R amp R studies such as 6 MONTHS When the Freq Units software calculates the next gage R amp R study date it uses this value Use the field located on the right of the R amp A Frequency field to select the Frequency Units schedule type Choose from these options Days the most common units schedu
193. ou can determine stability by a point or points outside the control limit within appraiser or within part patterns Error Chart The Error chart shows the individual deviations from the accepted reference values GAGEtrak calculates the individual deviation or error for each part according to the following formula Error Observed Value Reference Value or Error Observed Value Average Measurement of the Part f you didn t enter a reference value GAGEstat uses this method Before you do any other statistical analysis you should thoroughly screen the deviations for clear causes of variations that you can ascribe to specific factors Look for any uniform patterns in your Error chart including the following one appraiser s second or third set of readings is consistently higher than his first one appraiser s average is higher than the other appraisers averages and or one part standing out as more difficult to measure consistently GAGEtrak Calibration Management Software User s Manual 73 Example Error Chart ERROR CHART PART 3 FIFNUER PART 6 PART 7 PART 8 PART 9 PART 10 Run Chart and Average Chart Run Chart This chart plots the averages of each appraiser s various readings using part number as an index The Run chart can help you determine the consistency among appraisers Example Run Chart RUN CHART 0 1344 polum s ad a o a 3 m d C ee Se e 0 134 a zo 0 133 MEME CUN
194. ove then 10 Enter this entire line of text in the arget field c Program Files Microsoft Office ART Office msaccess exe excl runtime wrkgrp c Program Files gtw4 2007 system mdw c Program Files gtw4 2007 gtw4 2007 mdb All of the files referenced in the target for the GAGEtrak 4 2007 program file should be located on the hard drive whether your GAGEtrak 4 2007 database file is located on your hard drive or on your server 1 Click Apply then click Ok or Close 2 Right click on the shortcut icon again and then go to Rename Name it GAGEtrak 4 2007 and press ENTER 3 Double click the new shortcut to start GAGEtrak 4 2007 Compact Repair Icon To create a Compact Repair icon follow the steps above then 10 Enter this entire line of text in the arget field C Program Files Microsoft Office ART Office LaunchAccess exe runtime profile BAGEtrak 4 2007 wrkgrp C Program Files GTW4 2007 system mdw repair C Program Files GTW4 2007 GTSamp40 2007 mdb GAGEtrak Calibration Management Software System Administrator s Guide 203 If you have installed the GAGEtrak database to your local workstation the default location of database f will be c Program Files gtw4 2007 gtdata40 2007 mdb 1 Click Apply then click Ok or Close 2 Right click on the shortcut icon again and then go to Rename Name it Compact Database and press ENTER 3 Double click the new shortcut to repair and
195. over time you have to document each calibration that you perform on that gage Now you could do this on paper but then you have stacks of paperwork to keep organized This paperwork is easily lost and you often don t have backup copies for it We developed GAGEtrak for this reason By giving you a paperless easy to use tracking system GAGEtrak makes the job of managing your gages and test equipment easier and ensures that your calibration records are accurate and up to date 13 Chapter 2 How oes GAGEtrak ork To answer this question let s look at how your calibration lab might use GAGEtrak on a typical day Please note that this story is merely hypothetical it s not meant to be prescriptive You ll notice that all of the program s features and reports are in bold print and all of the optional accessories are in talic print A Typical Day in the Calibration Laboratory Its Monday morning and it s time to plan the day The QC manager asks you for the weekly Calibration Schedule You anticipated this request and you ve already printed it so your first task of the day is finished almost effortlessly Next you pour your coffee turn on your computer and start up GAGEtrak to help you plan the rest of your day Your Automatic Calibration Due Listing report pops up on the screen showing all of the calibrations that are due today You print it out to use as a handy reference so that you can be sure that all of the required work is
196. p To set up each workstation follow steps 3 10 1 Runthe appropriate scripts for your server to create the database and tables The scripts are located in the GTW4 SCRIPTS directory The files have prefixes to their names Step1 Step2 to indicate the order in which you should run them You might need to modify the data file in the table space for your system See the Step 1 script for details 2 Next run GAGEtrak s Data Transfer Utility Version 4 to import existing data from a previous version or prefill the database See page 209 for instructions 3 Open GAGEtrak 4 2007 and select Open Database from the File menu 4 Inthe Open Database screen check the Use ODBC checkbox Place a check in the Use DSN checkbox Important If you used a different Database Name DSN User ID and or Password during installation enter the information you used instead of the values listed below If you set up the configuration file G6 CONNECT INI GAGEtrak will automatically fill in these fields in this screen 1 The Database Name should read GageMgr or the name that you entered during installation 2 The DSNfield should show Oracle GageMgr or MSSQL_GageMgr the DSN that you entered during installation this value may be different 3 Your user ID should be GageMgr this field may also vary according to your setup 4 The Password field should contain the password you entered during installation Note that the password is displayed as asterisks
197. pact Repair Data Whenever you delete a record the program doesn t actually delete the record it only marks it as deleted and then re uses it whenever you add new records i e your data file size does not decrease If you delete many records you should compact your data file so that the program actually removes these records decreasing the size of the data file You can do this by running Compact Repair Data from the Tools and Utilities menu Reset Adjusted Frequencies If you ve enabled the Auto Adjust Cal Frequency feature for any gage and then decide that you would like to change the gage s frequency back to its original value run this utility It resets the frequency as long as you used GAGEtrak Versions 3 5 or 4 to enable the Automatic Adjustment feature Running this utility won t affect any calibration frequencies automatically adjusted within previous versions of GAGEtrak Fill Calibration History This utility is designed for users who are upgrading from previous versions of GAGEtrak for Windows software It calculates the Next Due Datefor the calibration records using the current calibration frequency from Gage Entry If you ve ever used GAGEtrak Versions 1 or 2 or if you ve imported records to the Calibration Header table run this utility once to update your calibration records with information from your gage records When you select this utility the following window will appear Fill Calibration History 9 This utility wi
198. plier_Master_Name Text 50 Salutation Text 50 Contact Text 50 Phone Text 50 Fax Text 50 EMail Text 50 Address Text 50 City Text 50 State Text 50 Zip Text 50 Country Text 50 Last Review Date 8 Last_Rating Date 8 Last Received Date 8 Last_Reject Date 8 Enabled Long 4 User1 Text 50 User2 Text 50 GAGEtrak Calibration Management Software System Administrator s Guide 199 Suplype Text 50 Table Name Part_Master Field Name Type Size Part No Text Key 50 Gage ID Text Key 50 Description Text 50 Operation Text 50 Drawing No Text 50 Drawing _Date Date 8 Change_Level Text 50 Change Date Date 8 Insp_Procedure Memo User Defined Text 50 User Defined2 Text 50 Table Name Gage Reqs Field Name Type Size Part No Text 50 Gage ID Text 50 Step_No Text 50 Dimension Text 50 Method Text 50 Freq Text 50 Comments Memo 200 Appendix B Record Formats Appendix C Database Management Moving or Renaming the GAGEtrak Database When you first install GAGEtrak the database location and name are set for each workstation To change the database location or name first make sure that all users exit GAGEtrak Next select Rename Move Database from the GAGEtrak 4 2007 program group This utility shows you the current name and location for the database Enter a new name and or a new location and the utility will rename and or move the database It will then update the program shortcuts with the new database name location Creat
199. pload this information into your database 4 The Clone Gage feature also saved you time Without it entering the new gage s information would have taken much longer not to mention that it would have been a redundant task This feature also provided for more accurate data entry since you didn t have to worry about as many potential errors 5 The Software Wedge program instantly inserted your calibration measurements into GAGEtrak you didn t have to enter anything CalPro gave you proven calibration procedures that were already researched and documented The Calibration Label Kithelped you speedily print durable easy to read calibration labels for each gage that you calibrated 8 Using Issue Tracking Entry you were able to quickly issue a gage out to another department and avoid the problem of not knowing where the gage is located Most importantly you now have an easy way to provide traceable gage usage history for each of your gages 9 The Barcode Reader provided for fast easy and accurate entry of issued and returned gages and even updated their current information all directly into 18 Chapter 2 How Does GAGEtrak Work GAGEtrak 10 Thanks to GAGEtrak s large variety of detailed reports you can rest assured that you ll be able to quickly and accurately retrieve any calibration information that your auditor asks to see 11 Finally GAGEtrak s features and optional accessories helped you with one extremely important task
200. praiser x Part 18 0 10367 0 00575 4 45 U 2i Gage Error 30 0 03875 0 00129 T Total 59 2 2491 Significant at 0 25 level Estimate of Std 90 Conf Limit 5 15 o 9eStudy Contribution Variance Dev o for Std Dev Variation t 0 00129 0 0359 0 030 0 046 EV 0 19 17 6 5 Repeatability y 0 00091 0 0302 0 007 0 152 AV 0 16 14 8 2 2 Operator Y 0 00223 0 0472 0 029 0 074 INT 0 24 252 5 4 Interaction R amp R 0 00443 0 0666 0 060 0 163 R amp R 0 34 32 7 10 7 C o 0 0371641 0 1928 0 121 0 334 PV 0 99 94 5 89 5 Part Study or total Variation TV JR amp R PV 0 54 0 99Y 1 05 wat 15o components study Variation 100 SESOKCONIDOREQES 5 150 study variation o Contribution 5 15 o components x100 5 15 c study variation Gage R amp R ANOVA Method GA File GASKET GAGE R amp R ANOVA METHOD STUDY 1 STUDY DATE MM DD YY GAGE X 2034 DESC Thickness Gage TYPE 0 10 0 MM CHAR NAME One 3 APR 10 PARTS 2 TRIALS Comment Special Study LOWERCL 5 15STD UPPERCL TOTAL PERCENT DEV VARIATION CONTRIBUTION Repeatability 0 15 0 19 0 24 17 6 3 1 Reproducibility 0 04 0 16 0 78 14 8 2 2 Part x Appraiser 0 15 0 24 0 38 23 2 5 4 GAGE R amp R 0 31 0 34 0 84 4 4 10 7 Part to Part 0 62 0 99 1 72 94 5 89 5 BASED ON DATA CATEGORIES GAGE OK Note Tolerance N A Study Variation 1 05 Number of distinct data categories 4 Conf level CL 90
201. r D number Leave this screen open and call Technical Support immediately The support representative will then give you two additional code numbers that you will enter on your Modify License screen Once the modification is complete GAGEtrak will give you a message titled Modification Successful 2 You can also wait until the date on which your trial period expires At that time you ll receive an Application Violation message when you open GAGEtrak Click the OA button and the Modify License screen will appear Again leave this screen open and call Technical Support immediately for the necessary code numbers You will receive a Modification Successful message once you have entered the code numbers that your support representative gives you To check on your expiration date and number of assigned user licenses click the About button on the main menu and look under License and System Information Main Menu GAGEtrak s main menu looks like this E GAGEtak 4 2007 Your Company Name Your Division Main Recorda Gage Entry Supplier Entry Fart Entry lesie Gages Procedure Eniry Return Gages Semio Request Entry Leer IC cran DDEC Datsbese GagrmgdSuzpoti Note that in the Lower left hand corner you see the name of the currently logged in user In the lower right corner you ll see the full path to the GTDATA40 2007 MDB file default database or the ODBC database specified currently open as seen above T
202. rak Calibration Management Software User s Manual 135 View Menu Command Description Form Choose this command to see the record in Form view Datasheet To see records in Datasheet view select this command Show Hide Toolbar Use this command to display or close the floating toolbar Format Menu Note These commands are active only in Datasheet view Command Description Font Use this command to change the Table view font doesn t affect Form view Row Height To change the height of all rows select Format Row Height Column Width Select this command to adjust the width of the selected column s Hide Current To hide the selected column choose this command Column Show Hide All Use this command to show or hide all or several columns Columns Freeze Columns You can use this command when you want to freeze the current column so that it is always visible even when you re scrolling to the right Unfreeze Columns To release any frozen column s choose Format Unfreeze Columns Gridlines Use this command to display or hide the gridlines surrounding each cell Record Menu Command Description Go To Choose this command to go to the first last next or previous record Quick Sort Use this command to quickly sort by the currently selected field s by either ascending A Z or descending Z A order Edit Filter Sort Select this command to set up record filters and sorting via the Query By Example QBE grid Apply Filter
203. rance to have the as found condition set to In This field displays the total calculated uncertainty value using the root sum of X Uncertainty squares method You can t edit it Calibration Status Select from the following options Passed Failed Repaired or Limited Enter the 7emperature Humidity Pressure and Other factors that may affect the Environmental CAD DES OR Accounting Section Field Button Name Description Cost Enter any costs related to the calibration such as those for internal or external service or supplies Hours In this field enter the actual time in hours that the calibration required In the gray box next to this field GAGEtrak shows the estimated default time from Gage Entry Use the Start timer button next to the Hours field to time your calibration it works like a stopwatch When you re ready to calibrate click Start Its name will change to Stop When you re finished with the calibration click Stop and GAGEtrak will automatically calculate the time and enter it in the Hours field The time is expressed in decimal hours example 0 25 hours 0 25 x 60 minutes 15 minutes Acct No Enter any tracking number associated with the calibration cost such as a job purchase order invoice customer or department number Certificate No You can enter a certificate number or push the button next to this field to generate a sequential certificate number first you must manually enter a starting certific
204. rding to stability purpose and usage 1 0 Scope This method describes the calibration of calipers inside and outside dimensions up to 72 inches 1800 mm and depth dimension up to 12 inches 300 mm Instrument resolution 0 001 or 0 0005 inch 0 02 or 0 05 mm Record 1 i por rtr of 4 The first procedure appears automatically to view additional procedures for this gage click the record navigation button at the bottom left corner of the inner window If a media file is attached to the procedure click Play to watch or listen to it Tip You can t edit procedures here you can only view them To edit procedures go to Procedure Entry 64 Chapter 3 Calibration Records Calibration Entry Labels Ej Calibration Entry x Calibration Measurements Procedures Labels Gage ID c 00001 Exit Select Calibration Label To Print D E F AWxIL AWx L AWx3L G amp Wx1L H amp Wx L l Wx3L Iv Preview Tape Catalog Record 14 1 If 1 ok rrr of 4 In the Labels tab you can print a calibration label for the current record You can use this feature only if you ve installed the optional GAGEtrak Calibration Label Kit printer and software shown below The Calibration Label Kit prints durable laminated cut to length calibration labels It includes a printer that attaches to your PC s serial port so it won t interfere with your default printer It also includes label design software fonts clipart an
205. re Appraiser 2 0048 0024 J Parts 2061 a 88 MB App x Cage Em om ee Total s 2249 S G Components of Variance Most of these values are calculated using values from an F distribution table You can find F tables in most statistics manuals Lower Control Limits AV z M5 nt x 1 Ryy 0 05 DE DES MSapp MSap 1 PV MS p kr x 1 Ryy 0 05 DE DE M54 MSapp 1 l MSg r x T hyy 0 05 DE DE M53 MSerr 1 EV MSgrr CHlyy 0 05 D Ferr D Ferr R amp R i n0 x MS pp CHlyy 0 05 DFypp DFypp n r 1 x MSerr n 1 MSap Sum Squares AV M5 MSap nr EV MS PV MS MS kr R amp R AV l EV MSap Mgr f TV RR PV Upper Control Limit Upper control limit formulas are the same as LCL formulas Just substitute 0 95 in the Fw and CHI v factors where 0 05 exists Table a s Ud AV oo 0009 0025 P ooms 005716 Olll9 0 0008 0 00223 0 0054 0 0009 0 00129 0 0021 RR 0 0036 0 00444 0 0266 TV 0 041 60 94 Chapter 4 Gage R amp R Entry Study Variation Se W 5 15x Ts 5 15x 40 0416 1 05 Repeatability LCL 5 15x JEMa 5 15x 40 0009 0 15 5 15 5 15 J EM 5 15x 40 00129 0 19 UCL 5 15x JEV c 5 15x 40 0021 0 24 TV Rep Std Dev Study Variation x 100 0 19 1 05 x100 17 6 PC TV 3 1 Reproducibi
206. reate manufacturing traceability For example if you find that a gage is out of tolerance you can immediately generate a part recall report that lists all parts that you might have measured incorrectly The table below explains the fields and buttons in the Issue Tracking Entry screen Field Button Name Description ssue Date and These fields track the date and time at which you issue the gage they re Issue Time prefilled with the current date and time Issued To Enter the person to whom you issue the gage or use this field to track the customer number Type Select the reason for issue this field creates its own list from your entries Issued Dept Enter the department or job number that will use the gage Part No Use this field to track the part or group of parts that the gage will measure PO No You can enter a PO number if you re sending the gage out to a supplier for repair or calibration or are manufacturing parts for a customer Promised Date Enter the date on which you expect the gage to be returned to you Received Date and These fields track the date and time at which the gage was returned Click the Received Time small button next to Received Date to insert the current date and time Received From In this field enter the name of the person who returned the gage Cycles Enter the number of cycles performed by the gage usually 1 GAGEtrak adds this number to any previous cycles for the gage It uses that number to calcul
207. rectory level browse only Select Destination Director C Pragrem Figs w d 2 DO 7 e c c Pragram Files Cancel 1 Next GAGEtrak will ask if you want it to create backup copies of all of the files that it overwrites on your system We recommend that you select Yes and use the default location C GTW4 BACKUP 2 l fyou re using an Oracle or SQL version of GAGEtrak the installation program now asks where you want to install the database scripts Click the Browse button to select a location If you don t want to install the scripts remove the check from the nstall Oracle or MS SQL Scripts box 3 Next GAGEtrak will ask if you want to install under the Common Users Group or the Current User only It is recommended that you install under the Common User Group 4 Now the program will ask you to select the Program Manager group to add GAGEtrak s icons to We recommend that you select the default GAGEtrak 4 2007 5 Click Next and this screen will appear GAGEtrak Calibration Management Software System Administrator s Guide 151 Backup Replaced Files Te CH elem vere the zi Laonsze Dalabase Siim Locali ilgelt Lee Fire LS Uses Lal op Curent User Ork 152 Chapter 1 Installation Salat Program Marader loro Shade rch allalen ra 10 Click Nextto begin the installation During Installation you will see the following Windows Installer popup this will appear when the installer is almost done
208. red unique information in those fields before you try to save it Otherwise GAGEtrak will give you an error message To copy a record follow these steps 1 Go to the record you want to copy and click on the record s selector bar or button Choose Copy from the Edit menu or press CTRL INS on your keyboard Go to a new record Click on the new record s selector bar or button Finally choose Edit Paste or press SHIFT INS on your keyboard ok CO N Deleting Records To delete records do the following 1 Goto the record you want to delete and click on the record s selector bar or button 2 Choose Delete from the Edit menu or press the DELETE key 3 GAGEtrak will ask you to confirm the deletion sometimes twice In Table view you can delete multiple records by selecting more than one record Use the record selector buttons to select all the records that you want to delete then follow steps 2 and 3 Undoing Changes to Fields and Records If you want to undo changes to a field and you haven t left the field either press the ESC key or select Undo Current Field from the Edit menu If you change more than one field on a record and want to remove those changes select Edit Undo Current Record If you re still in one of the fields that you changed first go to the Edit menu and select Undo Current GAGEtrak Calibration Management Software User s Manual 133 Field then select Undo Current Record Saving Records GAGEtr
209. report starts with a filter window that allows you to select a specific group of records for the report Most reports also let you select the sort order click the appropriate sort button in the filter Some reports such as the Calibration Due Listing report are time based you can specify the date range you need to see All reports were designed using standard Windows True Type fonts Report Commands and Functions Viewing Reports You can preview any report by clicking the Vew button in the filter After the report appears you can use the scroll bars to look at different parts of it Use the navigation buttons to go to other pages of the report To zoom in or out of the report click anywhere in the body of the report 113 114 Chapter 10 Reports Report Preview Toolbar GAGEtrak s Report toolbar contains common commands that you can use for reports Each toolbar button is described below Toolbar Report amp ai fO 100 dose Button Description eb Click this button to print the report Print T To e mail the current report click this button Send 100 If you need to see a close up or an overview of the report click the magnifyin I p p g g 7 glass to zoom in or out of the report You can also select a specific percentage d value for magnification When you re finished click this button to close the report Close Print Preview Keyboard Shortcuts Press To P Print the report S Open the Setup dialog box
210. rocedures Field Name Procedure Name Procedure txt MediaPath Table Name Procedure Link Field Name Gage ID Procedure Name Table Name Calibration Header Field Name Gage ID Calibration Date Calibration Time Calibration Type Calibration By Department Results Action Required Approved Findings Calibration Cost Type Text Key Date Key Date Key Text Text Date Date Text Text Long Text Text Text Date Type Text Key Memo Text Type Text Key Text Key Type Text Key Date Key Date Key Text Text Text Text Text Long Memo Double Size 50 50 50 50 50 50 50 50 Size 50 299 Size HO KO Size 50 50 50 50 50 N us 198 Appendix B Record Formats AcctNo Text 50 TotalUncert Double 8 ResultCode Double Double 8 CalDateUpdated Long 4 CertNo Text 50 Time_Required Double 8 CalFrequency Double CalFrequency_UOM Text 50 NextDue Date 8 Temperature Text 50 Humidity Text 50 Pressure Text 50 Other Text 50 CalibType Text 50 Table Name Calibration Measurement Field Name Type Size Gage ID Text Key 50 Calibration Date Date Key 8 Gage Standard ID Text Key 50 CM Before Double 8 CM_ After Double 8 Minimum Double 8 Nominal Double 8 Maximum Double 8 Uncert Double 8 CM Calibration ID Text 50 imitUse Long 4 Units Text 50 CM_Type Text 50 Comments Text 50 Table Name Supplier_Master Field Name Type Size Supplier Code Text Key 50 Sup
211. rrors The software uses up to 15 significant digits of precision in all intermediate calculations rounding only the final results 65 66 Chapter 4 Gage R amp R Entry Terms and Definitions Before using Gage R amp R Entry you may want to familiarize yourself with these terms Bias Accuracy The difference between the observed average of measurements and the reference value is known as b as often called accuracy The reference value accepted reference value or master value functions as an agreed upon reference for the measured values You can determine a reference value by using a higher level of measuring equipment such as metrology lab or layout equipment to average several measurements Observed Reference Average Value Value Bias i Accuracy f Aa rj I4 Linearity Linearityis the difference in the bias accuracy values through the gage s estimated operating range High Enc rue Observed weragt Average iut IC E i EF S rj hh M Vd j al N l EN F j n i E A LowEnd 4 9 High End Bias Observed Average Low End Bias Ze E j j i J I M Precision Below we ll use a bull s eye target to describe three examples of precision Accurate but not precise Notice that the average of all the readings would be in the center of the target no bias A measuring instrument like this would have a significant amount of error Precise but not accura
212. s in this example that you want all gage records that have a description starting with the word Caliper Likewise if you enter Caliper it tells the program that you want all gage records with descriptions ending in the word Caliper such as 4 inch Caliper Furthermore if you enter Caliper it tells the program that you want all gage records with descriptions containing the word Caliper 4 inch Caliper and Caliper Digital You can specify as many filter fields as you need depending on how selective you want to be After you enter any filter values click the Find button to view the filtered recordset To remove any filter information click the Clear Filter button Supported Wildcard Characters tn Search Fields The asterisk question mark number sign 4 exclamation point hyphen and brackets are all wildcard characters You can use them in record filters and in Find Replace commands to include all records that begin with specific characters or match a certain pattern Wildcard If You Enter GAGEtrak Finds Character wh what white and why works like MS DOS commands at cat bat and what i 94 records with any date in 1994 11 records with any date in the month of November b ll ball bell and bill this symbol matches any single character H 143 103 113 123 matches any single digit not for use with date fields use asterisk instead blaelll ba
213. s only if you have a compatible version of a Microsoft Windows program such as Word or Excel that includes a complete version of MS Graph Due to the licensing arrangement with Microsoft GAGEtrak comes with only a non modifiable run time version of MS Graph If you do own a complete version of MS Graph and you want to save your modified chart settings follow these 58 Chapter 2 Gage Records steps 1 Make your chart changes in MS Graph and return to GAGEtrak Your screen should reflect the changes that you made Select File Print Preview 3 Select File Print Setup then adjust one of the margin values You can type the same value but you must type something so that the program can detect a change 4 Close the Gage Accuracy Chart screen the program will ask if you want to save your changes You can print modified charts by first viewing the chart then selecting File Print from the top menu bar Gage Entry Calibration Button This button will take you directly to the Calibration Entry screen for the current gage ID When you go to Calibration Entry from Gage Entry you can see only the calibration records for the gage that you selected in Gage Entry In this window you can enter everything that you would normally enter in Calibration Entry but you can t delete whole records To return to Gage Entry from Calibration Entry click Return or Exit Please read the following section of this manual for complete instructions for
214. s Manual 81 If a measurement system has non linearity Look for these possible causes gage not calibrated properly at lower and upper ends of the operating range error in the minimum or maximum master worn instrument internal instrument design characteristics RON gt Linearity Formulas y b ax x reference value y bias a slope X xy xx 2Y a 2 S x2 XX n b xf a zr n n pay R l Bias b ax R Goodness of fit If using the Process Variation 6 Sigma Process Variation Linearity Slope xProcess Variation Linearity 100 x Linearity ProcessVariation Or if using the tolerance Linearity Slope xTolerance Linearity 100 x Linearity Tolerance where Tolerance Upper Spec Limit Lower Spec Limit Stability Study When thinking about measurement system stability you must distinguish between measurement system stability the amount of total variation in the bias of the system over time on a particular part or master part and statistical stability Statistical stability is the more common term that is used to describe stability repeatability bias and processes Two different measurement systems could measure the same master part and both could show statistical stability yet one system might have much higher variation in its bias over time than the other From a statistical point of view they re equally stable However from a traditional gage stability point of view the system with the lower
215. s for this frequency you must manually enter the due dates Auto Adjust Calibration f you want GAGEtrak to change this gage s calibration frequency according to its Frequency as found condition before calibration select this option If you check this box GAGEtrak will automatically adjust calibration frequencies whenever you enter a new calibration record according to the rules you defined in the Frequency Adjustment Factors table Please see the System Administrator s Guide for more information Tip Do not check this box unless you fully understand this feature and decide that you want GAGEtrak to automatically adjust your calibration frequencies Calibration Hours Enter the actual or estimated time it takes to calibrate the gage Last Calib Date When you first enter the gage record enter the gages last calibration date Later the program will automatically update this field whenever you add a new calibration record for the gage Next Due Date This field shows the next calibration due date It s automatically updated whenever you add a new calibration record for the gage Next Due Date Calibration Date Freg You can also manually enter any date into this field If the current date is past the next due date you ll see the message Past Due on the right of this date Tip To calculate this date immediately click the Next Calib button only if you ve entered a calibration frequency and last calibration date Using this button y
216. sav R amp R 100 xR amp R TOL Ford Long Form Method Equipment Variation EV Repeatability KI 4 56 3 05 EV RXK EV 2100 xEV R amp R xTOL Appraiser Variation AV Reproducibility Apprs 2 3 K 3 65 2 70 AV A pyre x KJ EV nr WAV 100 x AV R amp RXTOL Repeatability amp Reproducibility R amp R 2 2 R amp R V EV AV EV LAV JoR amp R EV AV Linearity Study To determine linearity choose parts throughout the gage s operating range To find the bias of each part calculate the difference between the reference value and the observed average measurement The slope of the regression line that best fits the bias average versus reference values multiplied by the process variation or the tolerance of the parts is an index that can represent the linearity of the gage To convert gage linearity to a percentage of process variation or tolerance multiply by 100 and divide by the process variation or the tolerance As with stability the recommended analysis technique is graphical a scatter diagram with a best fit line You can use tool room or layout inspection equipment to determine the reference values of the parts The appraisers measure the parts then the program calculates each part s observed average The difference between the reference value and the observed average is the bvas the software calculates it for each part The linearity graph plots biases and reference va
217. se Based on the gage s accuracy compared to its calibration standard use this box to restrict the gage to limited use meaning that it shouldn t be used for measurement of this particular range Gage ID of Standard This field stores the gage ID of the reference standard which is important for traceability back to a specific standard You can manually enter the standard s gage ID or select from a list of available standards shown below by clicking the GAGEtrak Calibration Management Software User s Manual 63 small button on the right of this field The list shows only those gage records that have X s in their Gage Entry Ref Standard checkboxes Uncertainty If you select the reference standard from the list the uncertainty value will automatically display If you manually enter the standard then enter its uncertainty value here You can obtain this value from the manufacturer it s expressed in units such as percentage 0 5 proportion 0 005 or measurement 0 0001 inch You must enter units of the same value otherwise the calculated Uncertainty will be wrong Calibration Entry Procedures In this screen you can see any calibration procedures that are attached to the gage amp Calibration Entry E3 Calibration Measurements Procedures Labets Gage ID C 00001 Exit gt Procedure Name CP22E Revision 12 01 93 DIAL DIGITAL AND VERNIER CALIPERS Calibration Frequency 12 months can be modified acco
218. ssage The error message stating The sum of the margins and the height of the page footer is greater than the length of the page you are printing on appears if you install the P Touch label printer and assign it as the default Windows printer To eliminate this error select your report printer as the default Windows printer GAGEtrak is designed so that calibration labels are printed to the P Touch printer as a specific printer For more information about the label printer please see Appendix A of the User s Manual P Touch Printer Does Not Print Labels If you can preview calibration labels but cannot print them you probably do not have a compatible version of the P Touch printer driver editor or spooler files If you can print labels from the P Touch Editor program but you get a message that your P Touch printer is not installed or recognized you may also have this problem Please visit our web site www cybermetrics com to download the current P Touch files for your operating system if you don t have Internet access please contact Technical Support to obtain these files GAGEtrak Won t Open Message The program has expired After you install GAGEtrak 4 2007 you have 45 days to obtain your trigger code Once you exceed the 45 day limit you ll receive this expiration message when you try to open GAGEtrak To obtain your trigger code go to the Technical Support section of the CyberMetrics web site www cybermetrics com or ca
219. stall Oracle Tools before you install GAGEtrak See chapter 2 for more instructions return to this section when you re finished Installation Options You can use GAGEtrak 4 2007 as a client server program with one centralized dedicated computer hosting the database and one or more user workstations accessing the database from that server You can also choose to install and use GAGEtrak on only one PC a single user setup If you have a multi user license of GAGEtrak you and your other GAGEtrak users can install the program from the CD or from a network location If you want your users to install from a network location copy the 147 148 Chapter t Installation SETUP EXE and G_CONECT INI files to the same network location then instruct users to run SETUP EXE from that location You can find the Access Oracle or MS SQL G_CONECT INI file on the CD under the directory of the database name i e the Access G_CONECT INI file is in the Access directory on the CD To install GAGEtrak follow these instructions 1 To begin installation click the Windows Start button and select the Run command Click the Browse button to navigate to your CD ROM or network drive then select SETUP EXE The sample screens show a CD and a network installation 2 Next you ll see the Welcome screen Make sure that you ve closed all other programs then click Next w elcome In the next screen enter the install code for your copy of G
220. stem Administrator s Guide 169 Main Menu The main menu shows the name of the currently logged in user in the lower left corner and shows the full path to current database file in the lower right corner ie GAGEtak 4 2007 E3 Your Company Name Your Division Supplier Entry Part Entry Issue Gages Procedure Entry Retun Gages p Semit Request Entry User ID Adnin D DBC Datsbeze Goong Supporti The function of each main menu button is explained in this table Button Description Ert Click this button to access the Main Records menu where you can add change or delete ppa records for your gages parts suppliers and other elements of your calibration management system Main Records J y S Click this button to access the Calibrations Menu where you can add change or delete E calibration records Calibrations Click this button to access your GAGEtrak Gage R amp R studies Click this button to access the GAGEtrak Reports menu Click this button to set up your GAGEtrak program or enter user information or archive or un archive records Click this button to back up your GAGEtrak data import or export data Access database n Click this button to edit your GAGEtrak data tables directly or run utilities A Utilities 170 Chapter 4 Running GAGEtrak If the program can t find your database file then the Open Database window will appear If this happens
221. string including a phrase a word or part of a word For example you might want to change all occurrences of the word Bolt to Washer in a part description field To Replace Data in a Table 1 Display the table or form containing the information you want to replace 2 Select the field column in which you want to replace data unless you intend to search all fields 3 From the Edit menu choose Replace The Replace dialog box appears Pll ce m Ard Typa I T 3 T entem hapta i E blah hha ict E gast Onde CurngeiT eid Cham 4 Inthe Find What box type the text you want to find Use wildcard characters to make your search more general If you use wildcard characters you might want to confirm text replacements to ensure that they re correct see below 5 Inthe Replace With box type the replacement text 6 Under Search In select Current Field or All Fields If you select Current Field the program searches for data in the field in which your cursor is located 7 Set other Replace dialog box options if necessary You can confirm each replacement or you can replace all occurrences without confirmation To Confirm Each Replacement 8 Choose the Find Next button to find the first occurrence of the text The program locates the first occurrence of the text and highlights it 9 Clickthe Replace button to replace the highlighted text with the text in the Replace With box If you don t want to replace this occ
222. t Control ID Entry If your company needs to comply with ISO 9000 or QS 9000 Document Identification and Control requirements you can identify each GAGEtrak report with a unique document control number To set up this feature select Report Control ID Entry from the Tools and Utilities menu Enter the control text for each report using the navigation arrows at the bottom of the window to go to the next report The document control ID the Control Text field will appear at the bottom of reports using the alignment you have chosen for each individual report Left Center or Right amp Report Control ID s Jol x Report Name CalDueAuto K 4 b M Control Text Automatic Calibration Due Report Alignment I Left F Center M Right Record 14 1 1 F gt i LEd of 33 Tip If your company doesn t require a form number on reports use this area for your company s address and telephone numbers Export Import GAGEtrak Calibration Management Software System Administrator s Guide 183 For your convenience GAGEtrak includes an automated export program To export or import data go to the Tools and Utilities menu and select Export Import This screen will appear Export Import OF x Esport Import Exporting Data Table s To Export Format ta Export To Calibration Header Calibration Measurement Calibration Standards hage Master Gage Reg GAR Results Issue Tracking Expert T able s
223. t OD3C Driver for Oracle 2 010 00 6325 Microsoft OD3C for Oracle 2 573 3711 00 Microsoft Paradox Driver db 4 00 3711 08 Microsoft Test Driver txt csv 4 00 3711 08 Microsott Visual FoxPro Driver 5 UU 9428 UU Oracle ODBC Driver 8 00 05 00 3 70 06 06 23 ZOQZZ2 2 2 2 2 2 SQL Server 4 Oracle8 OD BC Driver Setup Dracle GageMar Oracle Gage Manager Enter Oracle GageMgr for the Data Source Name In the Description field enter a brief explanation about the data source Go to the ser Dfield and enter GageMgr Click the OA button then close the ODBC Administrator SO oOo N OQ OI Next enter your Service Name the name you created with the Service Name Wizard Chapter 3 MS SQL Installation If you re going to use GAGEtrak on a MS SQL client server system first install GAGEtrak see chapter 1 for instructions then create the data source name DSN for your setup following the instructions in this chapter Create Data Source Name DSN for MS SQL If you re using GAGEtrak with an MS SQL server follow these steps to create your DSN 1 Click Start then select Settings Control Panel Double click the ODBC icon and the ODBC Data Source Administrator window will appear 2 Goto the System DSN tab ODBC Data Source Administrator 71x UserDSN System DSN File DSN ODBC Drivers Tracing About System Data Sources Name Driver Configure pe An ODBC System data source
224. t automatically sets this field to Stability Appraiser Enter the name of the person conducting the study Comments Use this field to enter any comments Co Part No Enter your internal company part or job number Part No Select a related part number such as the customer or supplier part number Part Desc This field shows the description or name of the part Characteristic In this field you ll see the characteristic that you re evaluating Specification Limits If needed you can enter the upper and lower part Specification Limits optional used only for reference purposes Sigma Proc Var If you know the 6 Sigma Process Variation of the characteristic that you re measuring enter it here Use this field only for tracking purposes the program doesnt use it for stability calculations New To enter a new Stability study click Vewto open a blank data entry form Adding Stability Sub Groups To add stability sub group measurements click on the first row in the Sub Grouptable Each sub group row represents the values of the repeated master or master part measurements that you make You must use the same number of readings for each sub group of measurements for example you shouldn t use a sample size of five repeated readings on your first sub group and then use only three repeated readings on your second sub group Add additional sub groups to the rows following the first sub group row The sub group record fields are explained
225. t record Chart To see a chart for your study click this button Close When you re finished click Closeto return to the main menu Click the Ca c button and GAGEtrak automatically calculates these fields Lower CL lower control limit 5 15 Std Dev standard deviation x 5 15 provides measure of variation or spread Upper CL upper control limit Total Variation percentage of total variation Contribution percentage of contribution Repeatability equipment variation Reproducibility appraiser variation Gage R amp R overall gage R amp R variation Part to Part variation caused by the difference in parts Study Variation overall variation for the study M E a S U R E D A v E R A G E This chart plots the average measurement per appraiser for each part then connects the plotted points for each appraiser The more parallel the appraiser lines the less significant the interaction You should carefully study any points where the lines are nonparallel especially if they appear to have a large angle of intersection GAGEtrak Calibration Management Software User s Manual ANOVA Formulas Estimate of Variance Components Variance Estimate Gage t MS Interaction MS MS Y p r Appraiser MS MS Te e od nr Part MS MS Oo ee See lt i kr ANOVA Calculation ANOVA Calculation Source DF SS MS F EMS Appraiser 2 0 04800 0 02400 t 27 200 Parts 9 2 05871 0 22875 T 2V 60 Ap
226. t standards such as gage blocks or standard load cells from outside sources These standards represent the highest degree of accuracy in a company Usually your only form of calibration control on one of these standards is your supplier s certification that the standard is traceable to the U S Department of Commerce s National Institute of Standards and Technology NIST formerly the National Bureau of Standards Your supplier an independent laboratory or the NIST must perform any subsequent calibrations on these standards Purchased Working Standards These standards aren t as accurate as the precision standards they usually don t cost as much either You use them to check calibration internally before using gages or test equipment You might calibrate these standards in house but more often you send them to an outside source for calibration 141 142 Appendix B Gage Calibration and Control Test Equipment The term test equipment covers a variety of measuring equipment sometimes including working standards You use this equipment to check your products and manufacturing processes Check test equipment for calibration before you use it even if it s brand new Test Materials This term refers to all consumable standards such as films or liquids used in calibrating test equipment Since variability in these materials can affect your measurements and calibrations suppliers often give you data on the test materials variation
227. tability Control chart first generate the chart on screen then select File Print Click the Print button to see a preview of the report before printing it GAGEtrak Calibration Management Software User s Manual 85 Stability Formulas n sample size number of observations in sub group X individual sample measurement R Range X Sub group average A D D control chart constants based on value of n as shown in the table below pn A D D 2 1880 O 3 267 3 1003 O0 2575 4 0729 O 2282 5 0577 O 2115 0483 O 2004 0 337 0 184 1 816 12 Max X Min X ER E 20d of subgroups UCLp RxD LCLp R xD X XX X 7 of subgroups UCL X A xR LCLy X A2 x R Attribute Study Short Method Attribute or go no go gages evaluate parts according to whether or not those parts meet a particular standard any part that doesn t meet this standard fails the test These gages don t measure the degree of a part s success or failure they judge only whether the part met the established limits GAGEtrak uses the short method for attribute studies For this type of study select twenty parts and two appraisers Each appraiser should measure each part be sure that they perform the measurements randomly To prevent appraiser knowledge bias you should conceal these numbers from the appraisers The group of parts that you select should range from somewhat below to
228. te You can see that the readings are all close to each other but are biased in the upper right region of the target Statistically this amounts to a histogram with a small spread with the average of the measurements differing from the true value Precise and accurate In this the best condition the readings are all close to each other and centered GAGEtrak Calibration Management Software User s Manual 67 Repeatability Equipment Variation Gage repeatability is the measurement variation that occurs when one appraiser uses the same gage to measure Identical characteristics of the same parts Repeatability Reproducibility Appraiser Variation When different appraisers use the same gage to measure identical characteristics on the same parts the variation in the average of these measurements is known as gage reproducibility Observed Averages Operator B Operator A Reproducibility Stability When using a measurement system to evaluate the same characteristic on a master or part over an extended period of time the total variation in the measurements is known as stability or drift Observed Averages Time 2 Time 1 4 Gage Stability Variation Components Equipment Variation EV The equipment variation is the component of the total GR amp R study error that the measurement device causes A worn out gage or a non rigid fixture on the gage might contribute to a large EV Appraiser
229. te whole records To return to Gage Entry click Return or Exit Chapter 5 Entering Calibration Records Calibration Entry To enter calibration records select Calibration Entry from the Enter View Records menu a filter window will appear By now you should have at least one gage record entered use the Gage D list box field to select that gage so that you can create a calibration record for it amp Calibration Entry Filter LX Gage ID BH Gage S N 1 O Calibration Date Calibration Type fri ew Clear Filter Exit After you select a gage click the Find button and the Calibration Entry window will appear To enter a new calibration record click New Record After you save the record by entering information into this screen such as your department GAGEtrak automatically retrieves any standards you set up for the gage amp Calibration Entry LX gt Calibration Measurements Procedures Labels Gage ID C 002 E Gage R amp R New Record Description CALIPER DIAL 12 INCH Gage S N SN19803467 Graph Undo Calib Freq 3 MONTHS Next Due 10 15 1995 Exit Delete Calibration Date 10 12 1995 Time 609PM Department pica By e LSageMester Certificate Calibration Type As Found Condition I 4 Results Passed Okto Use Pass M Using Auto Adjust Action Required Calibration Status Findings X Uncertainty nones First Proced
230. tently throughout your supplier records Gages This table displays a list of all gages that you purchased from the supplier It s for viewing only GAGEtrak automatically updates it when you enter the code in a gage record s Supplier Code field Chapter 6 Calibration Procedures When you select Procedure Entry from the Enter View Records menu the Procedure Entry window appears It contains two different tabs Procedure Text and Procedure Image Procedure Entry Procedure Text In this screen you can copy or enter the text of each procedure amp Procedure Entry lolx gt Procedure Text Procedure Image Procedure Name CP22E Revision 12 01 97 Media Path Procedure DIAL DIGITAL AND VERNIER CALIPERS Calibration Frequency 12 months can be modified according to stability purpose and usage 1 0 Scope Undo This method describes the calibration of calipers inside and outside dimensions up to 2 inches 1800 mm and depth dimension up to 12 inches 300 mm Delete Instrument resolution 0 001 5r 0 0005 inch 0 02 or 0 05 mm 2 0 References This document is based on the DOD procedures Remove z 3 0 Definitions Tl Test Instrument Exit DOD Department of Defense es Loe Bemove a 4 0 General Requirements Play Environment Temperature Change should not exceed 2 deg F hr 1 deg C hr Humidity No excessive humidity Air quality N A LE Record 4 4 4 gt oifewl of 3
231. the gage s tolerance This value is the Mini ae Mi minimum acceptable value for the gage when you measure this standard for example 0 999 Enter the nominal value for the gage when you measure this standard for Nominal example 1 000 When you enter the nominal measurement GAGEtrak automatically calculates the maximum measurement based on the gage s tolerance This value is the Maximum maximum acceptable value for the gage when you measure this standard such as 1 001 50 Chapter 2 Gage Records Standards Prefill Entry Use Standards Prefill Entry to save time when you have multiple calibration standards and their nominal values are evenly spaced for example if you have a group of standards with the values 1 2 3 4 5 and 6 amp Standards Prefill Entry x Gage ID C 0t Topo MAN HU Number of Standards Start Value Increment Value Standard Names Unit of Measure Type End Value Field Button Name Description Number of In this field enter the amount of standards Standards Start Value Enter the smallest nominal value for the similar standards Increment Value You can enter the difference between the sizes of the nominal values of the standards such as 5 or 005 in this field Standard Names Enter the part of the names that s the same for all of them For example let s say that you ve entered 6 as your Number of Standards and 1 as the Start Value Also you ve chosen an ncrem
232. the navigation buttons at the bottom of the Procedures window to add a new procedure record Again select the name of the procedure from the list box You can choose only procedures that you ve entered in Procedure Entry see page 109 GAGEtrak Calibration Management Software User s Manual Gage Entry Schedule In this screen you ll set up the calibration and gage R amp R schedules for each gage amp Gage Entry e Information History Standards Parts Procedures Schedule E Gage ID prin 53 CALIBRATION Initial Times Used Calibrator fac Lab Building 12 J Last Calibrated By Joe Jones Calib Freq so DAvs Auto Adjust Calibration ee Ej Calibration Hours Last Calib Date Next Due Date GAGE R amp R Gage Calibration Schedule Field Button Name Initial Times Used Calibrator Last Calibrated By Calib Freq and Calib Freq Units 0671 7 1933 09 1 5 1999 2 25 Next 09 20 1998 _ Calib Projected R amp R Schedule R amp R Freq 365 DAYS bd 09 29 1998 Next 4 6 R amp R Record 14 4 1 gt gt t gt of 1 Last R amp R Date Last R amp R Result Next R amp A Date Mex Projected Calibration Schedule 0371 9 1999 03 28 2000 03 28 2001 03 28 2002 Description GAGEtrak counts how many Issue Tracking records the gage has and adds it to this field The total is displayed as Cumulative Times Used at
233. the top of the Issue Tracking Entry screen This field is a list box field from which you can enter or select the code for the supplier that normally calibrates the gage the calibration service supplier You can also set this field to In House or a department or technician s name if calibrated within your own facility simply type the information into this field Later you can use this information to select a group of gages due for calibration by that calibrator Note If you have the GAGEtrak PDA you must enter a calibrator since the PDA downloads calibrations by this field The name of the user who last calibrated the gage appears in this field Enter how often the gage should be calibrated such as 45 DAYS When GAGEtrak calculates the next calibration due date it uses this value The field located just to the right of the Calibration Frequency field is the Frequency Units field it s not labeled Use the list box button to choose the calibration schedule type You can choose from these types Days the most common units schedule is based on elapsed calendar days Weeks each week equals seven days schedule is based on elapsed calendar weeks Months this option bases the schedule on months EOM always rounds the calculated Next Due Date to the end of the month in which it occurs For example 6 EOM means every 6 months but the program extends the Next Due Dateto the end of the sixth month If you re using skip
234. this chapter About the Manual Software and Technical Support The purpose of this guide is to help you learn how to operate the software Ks not meant to be an authoritative guide on conducting analyzing and interpreting your gage R amp R studies Although this manual describes gage R amp R study procedures they are simply the views as documented by various industry publications The software is simply a tool used to store data calculate results and generate printed reports and charts in compliance with the Measurement Systems Analysis 2 Edition pulished by the AIAG It does not determine whether a measurement system is good or bad As the user this determination is your sole responsibility Important The technical support available for this software is limited strictly to the operation of the software We cannot provide advice or support on interpreting results or charts If you have interpretation questions please consult your customer a statistician or other qualified professional Validating the Software This software has been tested validated and deemed suitable for release Calculation validations were conducted using test data with known results However you should still conduct your own validation tests using data with known results those that you calculate by hand or proven published values When comparing the software results to your manually calculated results remember that you may find differences due to rounding e
235. ts to the same path that the DTU Is in for the current workstation If this path is incorrect you ll see a message similar to the one shown above Click Browse to find the directory where the Scripts file is located Browse Data File Name Log File Name MS SQL only Administrator User D and Password Server MS SQL only Service Name Oracle only Run Test Connection Cancel GAGEtrak Calibration Management Software System Administrator s Guide 189 Enter the name and server location of the GAGEtrak 4 2007 data file The letter for the drive must be its physical drive letter not a mapped letter For example if your server has a physical drive D that s mapped to as a different letter F enter D followed by the rest of the path MS SQL users should enter the name and server location of the log file We recommend that you use the same path as for the data file again using the drive letter of the physical drive Enter the user name and password of your database administrator MS SQL users must enter the server name in this field For example if the server name is Company NT enter that name in this field Oracle users must enter the name of the service that the database will be installed on you create this name when you configure Oracle on the server When you ve finished entering all of the necessary information click this button to run the scripts Click this button to make sure that you re con
236. ue dates Calibration Hours In this field enter the actual or estimated time it takes to calibrate the gage Last Calib Date Enter the last calibration date for the gage GAGEtrak automatically updates this field whenever you add a new calibration record for the gage Next Due Date The next calibration due date is automatically updated when you add a new calibration record for the gage Next Due Date Calibration Date Freq You can also manually enter a date into this field If today s date is past the Next Due Date you ll see the message Past Due on the right of this date Tip Click Next Calib to calculate this field immediately only if you entered a calibration frequency and last calibration date This button is useful if you want the program to calculate the next due date but don t want to enter a calibration record for the gage Projected Calibration To the right of the calibration scheduling you can see the next three Schedule anticipated calibration dates To calculate these three dates click Next Calib GAGEtrak automatically updates them based on the current calibration frequency whenever you add a new calibration record for the gage Cloning Gage Records If you want to copy a gage record including its set of calibration standards procedures and parts click the Clone Gage button in the Gage Entry Information screen This window will appear E Clone Gage Source Gage ID c 00001 New Gage ID 3 Clone Exit
237. umber of the part the gage will measure Gage Return The Gage Return fields are as follows Field Button Name Description Received Date and These fields track the date and time when you received the gage Click the Received Time small button next to Received Date to fill in the current date and time Received From In this field enter the name of the person that returned the gage Cycles Enter the number of use cycles performed by the gage usually 1 For gages that you calibrate according to cycles GAGEtrak adds this number of cycles to any previous cycles that the gage performed then it uses that number to calculate the next calibration due date Notes Record any important comments such as damages or malfunctions GAGEtrak uses the following rules for managing Issue Tracking records 1 When you issue a gage the program automatically inserts the current date and time It also changes the gage record s Current Location field to a description that consists of the ssued 7o field plus the ssued Dept field separated by a slash for example 675 Job 7512 Final Assy 2 The program assumes you want to return a gage complete the Issue Tracking record if the gage has an incomplete current record After you save the Issue Tracking record GAGEtrak marks the gage record s current location as its storage location Chapter 7 onclusion We hope that you re more familiar with GAGEtrak 4 2007 now and that this guide has helped you und
238. un D foalibraton Mecsuemenmt Eso Sendads S fibration Stendarde 35 Esame a focus BegFen de Regs RR Rete S eeR Resuts T C o sm LLLA Men Sequences en Sequences MOR Parc Master T_OfPenMete Cd Procedure mk opor f Procedues YS Process Procedues oe J 3 pedes ug T Fepcoma 7 3 Repco E FesmCodes E peemmodes E Seting O pe C T E l3 Sample Data Transfer from Version 3 Archive amp Data Transfer Utility Record Counts Source Destination Table Record Counts CD 0000 LL TL fowarchive YMA GAGEtrak Calibration Management Software System Administrator s Guide 193 Sample Data Transfer from Version 3 Data amp Data Transfer Utility Record Counts Source Destination Table Record Counts Source Version 3 Tables Count Destination Version 4 0 Tables Count Calibration Header 14 398 Calibration Header 14 398 Calibration Measurement 0 jCalibration Measurement 0 Calibration Standards D Calibration Standards D Gage Master 4148 Gage Master 4 148 Gage Reqs 0 jGage Reqs 0 GRR Results 0 JGRR Results 0 Issue Tracking 9 075 Jlssue_Tracking 9 075 Letter 1 Letter 4 New Table 0 Man Sequences 1 MDR 640 MDR 540 Part Master 0 JPart Master 0 Procedure Link 58 Procedure Link 58 Procedures 3 JProcedures 3 Procedures 3 JProcedures OLE 3 RepContro
239. ur internal company part or job number in this field Part No Select a related part number such as the customer or supplier part number Part Desc The description or name of the part appears in this field Characteristic Enter the characteristic that you re evaluating in the study Specification Limits Be sure to enter the minimum and maximum Specification Limit values otherwise the software can t calculate the tolerance values for your study Sigma Proc Var If you know the 6 Sigma Process Variation of the characteristic that you re measuring enter it here This causes the program to use this value instead of 70 Chapter 4 Gage R amp R Entry Appr A Appr B and Appr C Part Reference New Prefill estimating part variation from your sample of study parts If you know the standard deviation of the characteristic from SPC or Capability studies multiply it by six and enter the result here Enter the names of Appraisers A B and C If known enter the reference values for parts 1 through 10 used for Values generating Error and X Y Plot charts If you don t enter any values then 1 10 GAGEstat will use the part averages in place of the reference values To enter a new study click the New button to open a blank data entry form If most of your measurements begin with the same numbers such as 1 1651 1 1650 and 1 1658 you can save time by prefilling the measurements with those digits In this case click the Pref
240. ure Name CP22E Revision 12 01 97 ENVIRONMENTAL Temperature Pressure Humidity Other ACCOUNTING Costs 0 Account No Hours 0 25 0 25 Start Certificate No 3 Record i 4 115 F dr of 141 27 28 Chapter 5 Entering Calibration Records The major fields in the calibration record window are described below Field Button Name Description Gage ID The gage ID that you filtered for automatically appears If you left the filter window blank use the drop down list box to select a gage ID Tip Once you select a gage DO NOT change this field If you want to enter another record click New Record Next Due Date This field stores the next due date for calibration based on the calibration frequency You must check the Pass checkbox field in order for GAGEtrak to show the next due date Department Enter the name of the department that used the gage before calibration Action Required In this field enter any required action such as send out for repair Findings Use this memo field to describe any other pertinent information such as visual inspection notes Note What you enter here appears on the calibration certificate As Found Condition Choose the condition of the gage before calibration or adjustment Select Infor in tolerance Outfor out of tolerance or Newfor a gage that hasn t been calibrated before Before calibration a test points of the gage must be within tole
241. urrence of the text click the Find Next button to locate the next occurrence To Replace All Occurrences without Confirmation 10 Click the Replace All button 130 Chapter 11 Program Conventions Quick Sort Command You can use the Quick Sort command from the Records menu to perform a simple sort of your records based on the currently selected field s When you select this command you ll see a submenu that enables you to sort in ascending or descending order see below The sorted records return to their original order when you close the form or table Ascending A Z or 0 100 Descending Z A or 100 0 Filter Sort Command To filter and sort records in either Form or Table view modes use the Filter Sort command You can sort in ascending order or descending order see Quick Sort Command above The sorted records return to their original order when you close the form or table Jo Sort Records 1 Choose Edit Filter Sort from the Records menu The filter window appears with a list of available fields gg Gage Master EntryFilterl Filter Oy xi Gage Master En Field Sort Criteria or 2 Inthe Feld row in the filter window s grid add the fields for which you want to specify a sort order You can drag fields from the field list or you can click a cell in the F e d row then click the drop down arrow and choose a field from the list 3 Foreach field whose data you want to sort click the drop down
242. urrent database even if you try to do so This safeguard lets you alternately open your restored and current 180 Chapter 6 Other Utilities databases to compare them in case you suspect that you ve lost data because of a corrupted database Use a folder named Backup as the location for your restored database as shown here Browse for Folder Select the folder where the restored files will be placed 29 C CJ mssetupt CJ msstfaft CJ Acrobat3 fcbewrk Fedex 1 Fsmm3 C3 Fsmm4 CJ fsrv4 C3 Gtw4 CJ Hipdsk97 zi omen Click OKto begin the Restore operation When it s finished you ll see this message Tip If you ve replaced your hard dri Finished UnzIP Operation Complete ve or are installing the software to another computer reinstall GAGEtrak first then restore your backup database file Edit All Tables This utility provides a direct interface for you to make changes to your records instead of going through GAGEtrak s normal data entry screens When you open it the Edit All Tables menu will appear you can choose from the following data tables Gages Calibration Headers Calibration Measurements Calibration Standards ssue Tracking Gages Parts Links Parts Procedures Procedure Links Suppliers Warning When editing data from this utility you are working directly with the tables in your database none of the GAGEtrak fe atures th
243. uto Adjust Cal Frequency box in Gage Entry for any gage whenever you enter a new calibration record for it GAGEtrak automatically adjusts its calibration frequency according to the rules you define in the Frequency Adjustment Factorstable This table is preset to use the NCSL RP 1 Method A1 see Appendix C of the User s Manual for NCSL s address This method increases the existing calibration frequency by 10 if the as found condition of the gage is in tolerance multiplied by 1 1 If the as found condition of the gage is out of tolerance then it reduces the interval by 5596 of the existing frequency multiplied by 45 If the gage is new and you ve never calibrated it then the interval remains the same multiplied by 1 Simulation studies show that you achieve measurement reliability target of 9596 EOP using this approach EOP stands for End Of Period it refers to the reliability of a gage at the end of its calibration interval You can change the table to use different factors if you need to use another frequency adjustment method Example If the frequency is 30 days and the as found condition before calibration is n tolerance then the frequency would be set to 33 days 1 1 x 30 33 days If the as found condition was out of tolerance the frequency would be automatically reduced to 13 5 days 45 x 30 13 5 days This statement is included in the Certificate of Calibration document see Calibration the Reports section of t
244. uxiliary equipment needing controls or a warm up period being necessary Although gage accuracy linearity and stability variations are not as dominant as gage repeatability and reproducibility you can and should identify and reduce them 4 Repeatability the variation in the measurements obtained with a gage when one appraiser uses it several times to measure the same characteristic on the same part Example The calipers are off randomly due to internal friction electrical noise or some other factor also called precision You can also express this as Equipment Variation EV 5 Reproducibility variation in the measurement average when several appraisers use the gage to measure the same characteristic on the same part You can also express this as Appraiser Variation AV Example Each of the three inspectors gets a different measurement although each one Is measuring the same part Other Techniques References Other measurement system error evaluation techniques are available such as Confidence Interval Determination Control Charting and Performance Curve Plotting However these excellent but somewhat technical statistical tools are beyond the intended scope of this manual We used the following publications as references in developing Gage R amp R Entry we recommend them to expand your understanding of measurement system evaluations AIAG MSA Measurement Systems Analysis Reference Manual Automotive I
245. when you choose this command the program freezes the column that your cursor is in GAGEtrak adds new frozen columns to the right of existing frozen columns A bold line separates the frozen and unfrozen columns To Unfreeze Columns To release frozen columns choose Format Unfreeze Columns When you unfreeze columns they remain in the same order they were in while frozen You can t unfreeze specific columns you can only release all frozen columns at once Other Commands and Functions Output To Command The Output To command from the File menu allows you to transmit reports to a text file Microsoft RTF file HTML or Microsoft Excel spreadsheet file If you save a file in RTF format and then open that file in a word processing application such as Microsoft Word your data will have the appearance and formatting of the GAGEtrak report that you exported If you output to a text file all of the data will be present but the formatting will be lost Output to an Excel spreadsheet is the best option to select when you wish to export a report created from Datasheet view such as the Customizable Gage Report or Customizable Calibration Report see the description for these reports under Report Descriptions 128 Chapter 11 Program Conventions The following is an example of the output options for the Gage Listing report Gage Listing mdb Microsoft Access mdb mdw mda mde Microsoft Access mdb mdw mda mde Text
246. y and practice will help you better understand control chart patterns Stability Study Screen amp Stability Study L OE xj Study Date 04 13 1997 Co Part No 12345 Gage ID ATL 1 0002 Part No 12345 zi LL Gage Desc ELCOMETER A345FB 2 Part Desc WINDOW SWITCH New Calc Print Study Type Stability Characteristic VOLTAGE DC Delete Chart Close Appraiser DON Spec Limits 6 Sigma Proc Var Comments Sub Groups gt 04 13 1997 0 12 0 13 0 14 d 04 13 1987 o 0 21 0 11 04 13 1937 0 11 0 23 0 12 d 04 13 1987 015 0 2 0 12 04 13 1997 0 12 0 13 0 14 esi 04 13 1987 0 11 0 21 0 11 EN 04 13 1997 o 1 0 23 0 1 2 04 13 1987 0 15 0 2 0 12 04 13 1987 0 12 0 13 0 14 o 04 13 1997 0 11 0 21 0 11 04 13 1987 0 11 0 23 0 12 04 13 1997 0 15 0 2 0 12 04 13 1987 0 12 0 13 0 14 04 13 1997 0 11 0 21 0 11 Record uj 1 tl n jr of 46 GAGEtrak Calibration Management Software User s Manual 83 Each of the fields in the Stability Study screen is explained in the table below Field Button Name Description Study Date Enter the date of the study this field defaults to the current date Gage D Select the gage ID of the measurement device Gage Desc In this field you ll see the name of the gage or measurement device Study Type GAGEsta
247. you ll need to tell GAGEtrak where to find the database file GTDATA40 2007 MDB The Open Database window looks like the one shown here 5 Open Database Database Required Fields ageMGR Oracle GageMgr GageMgr e Driver SEIVET SPITVICe Name Database Attribute Application Attributes Pretetchi Count Transation Option Translation Littany Name If this window appears click the Browse button and navigate through the available drives and directories until you find the database file Remember the file name must be GTDATA40 2007 MDB Where Is The Data File I3 Backup JDTU4 mdb Rv Gtdata40 rdb F GTSamp40 mdb Gtdata40 mdb Nu L Note Users who have their database file Located on the network server must log into the network operating system before they can open the database file If you re using GAGEtrak on a client server system you must set up the Open Database screen according to your database configuration Please see page 170 for more information Chapter 5 Setting p GAGEtrak Before you begin entering records we recommend that you configure your GAGEtrak program To do so go to the Settings Area of the Main Menu ie GAGEtak 4 2007 Your Company Name Your Division Setup CA Service Settings Request Report Control ID Emir Status ID Entry Setup Users E a iy r LINES H o T F r
248. your original GTDATA40 2007 MDB file select File Open Database again but this time go to your original directory usually C Program Files GTW4 2007 Important Currently no easy method exists for transferring records between databases Although you can use the Copy and Paste approach it s cumbersome and error prone you must be extremely careful and fully understand the data table relationships Please consider this if you decide to use multiple databases If you do use multiple database files and later want to merge them please contact Technical Support for assistance there may be a small charge for this service Creating Icons in Windows These general steps are the same for creating the different GAGEtrak icons 1 Click on My Computer 2 Select Drive C or wherever you have GAGEtrak installed 3 Click on the GIW4 2007 directory 4 Highlight the TOOLS ICO icon by clicking on it once If you can t see it go to View Options and View again then click on the radio button for Show All Files 5 Without moving the mouse button off of the TOOLS ICO icon click the right mouse button and click on Create Shortcut 6 Youll see the new shortcut icon appear at the bottom of the window already highlighted in blue 7 Click the right mouse button on the new shortcut icon 8 Goto Properties 9 Click on the Shortcut tab it s next to the General tab Program Icon To create a program icon for GAGEtrak 4 2007 follow the steps ab

2 - CyberMetrics

Contents

Download Pdf Manuals

Related Search

Related Contents