QC-CALC User's Manual - The CMM Store

1 User's Guide by Prolink Incorporated Version March 2010 Prolink Incorporated 148 Eastern Blvd. Glastonbury, CT 06033 (860) 659-5928 Phone (860) 633-7309 Fax of Contents i INTRODUCTION .. 1 1. DATA ANALYSIS AND MANIPULATION .. 1 2. BEFORE RUNNING SETUP .. 1 3. RUNNING THE SETUP PROGRAM .. 2 QC-CALC BASICS .. 3 1. DATABASE STRUCTURE .. 3 2. GETTING HELP .. 5 3. NETWORK FILE OWNERSHIP .. 5 QC-CALC REAL-TIME .. 6 1. VIEWING THE QC-CALC REAL-TIME SCREEN .. 9 2. FILE .. 15 3. VIEW .. 19 4. REPORT .. 31 5. EXPORT .. 53 6. GAGE R&R WIZARD .. 63 7. TOOLS .. 70 8. OPTIONS .. 76 9. ADMINISTRATIVE TOOLS .. 141 10. HELP .. 142 11. POPUP MENU (RIGHT CLICK ON ANY PLOT) .. 153 QC-CALC SPC.

2 157 1. INTRODUCTION TO THE QC-CALC SPC SCREEN .. 159 2. FILE .. 160 3. EDIT .. 165 4. VIEW .. 173 5. GROUP .. 175 6. REPORT .. 176 7. TOOLS .. 209 8. OPTIONS .. 238 9. ADMINISTRATIVE TOOLS .. 241 10. WINDOW .. 242 11. HELP .. 243 12. POPUP MENU (RIGHT CLICK) .. 244 APPENDIX A ADMINISTRATIVE TOOL & 21 CFR PART 11 .. 1 1. INTRODUCTION .. 1 2. SETUP AND INSTALLATION INSTRUCTIONS .. 1 3. SILENT INSTALL .. 2 4. SETUP BATCH FILE .. 3 5. RUNNING QC-CALC REAL-TIME .. 4 6. MANAGE user GROUPS .. 4 7. ESTABLISHING FIRST TIME PASSWORD .. 4 8. CREATE user GROUPS .. 5 9. EDIT APPLICATION DEFAULTS .. 9 10. LOGOUT .. 10 11. DISCONNECTING FROM ADMIN PATH .. 10 12. TROUBLESHOOTING .. 10 13. 21 CFR PART 11 CONSIDERATIONS.

3 11 APPENDIX B FILE CONVERSION PROGRAM .. 1 1. STEPS FOR USING THE FILE CONVERTER: .. 1 2. CHANGING THE SETTINGS OF VERSION FILES .. 1 Table of Contents ii APPENDIX C EQUATIONS .. 1 APPENDIX D TRUE POSITION .. 1 1. INTRODUCTION .. 1 2. TRUE POSITION EXAMPLE .. 1 3. DETAILS OF THE PLOT .. 4 4. HOW IS BONUS USED IN CPK CALCULATION? .. 5 5. HOW ARE THE CONTROL LIMITS CALCULATED? .. 6 APPENDIX E EXPORTING FORMATS .. 1 1. ASCII TEXT FILE .. 2 2. ASCII user DEFINED TEMPLATE .. 5 3. LIGHTHOUSE SPC .. 8 4. MINITAB .. 9 5. ODBC - OPEN DATABASE CONNECTIVITY .. 10 6. OLEDB EXPORT .. 13 7. PROFICY SHOP FLOOR (VISUALSPC) .. 14 8. Q-DAS FORMAT ASCII OUTPUT .. 17 9. REACTION PLAN 24 10. SQL SERVER EXPORT.

4 27 11. STAT SUMMARY FILE .. 29 QC-CALC Introduction QC-CALC Page - 1 Introduction QC-CALC is a comprehensive statistical process control program designed to manage, analyze and report inspection data. Inspection data may be collected automatically from inspection devices or entered manually. QC-CALC performs the following functions: Data collection from automatic measuring machines and gages Manual inspection data entry using a spreadsheet editor Real-Time SPC analysis and charting as data is collected SPC analysis and charting Custom Reports QC-CALC has a direct DDE, RS232 or ASCII file interface to automated dimensional measuring systems. DDE or Dynamic Data Exchange is a method of transferring information between two programs running in Windows.

5 Each machine is interfaced with special software drivers to ensure fully automatic operation. 1. Data Analysis and Manipulation Once the data is collected, QC-CALC can perform all of the standard SPC analyses. You can easily manipulate the data with the editor by adding, changing or deleting. The data can be exported or imported to or from other software programs. Data analysis can be performed using any of several available SPC functions. You can work with all of the stored inspection data or with a selected subset. By using filters, you can extract data matching a specific criterion for editing, exporting to ASCII files, reporting or SPC analysis.

6 2. Before Running Setup Before you install QC-CALC , make sure that your computer meets the minimum requirements listed below. Note: You cannot simply copy files from the distribution disks to your hard disk and run QC-CALC . You must use the setup program, which decompresses and installs the files in the appropriate directories. Hardware Requirements To run QC-CALC , you must have certain hardware and software installed on your computer. The system requirements include: Pentium 450 Mhz processor minimum, 1 Ghz recommended A hard disk with 50 megabytes of free space A CD-ROM drive A SVGA display 1 GB of memory minimum A serial card based on a 16550 or compatible UART (for RS232) A mouse and keyboard Windows NT SP5, Windows 2000, Windows XP, Windows Vista QC-CALC Introduction QC-CALC Page - 2 3.

7 Running The Setup Program You install QC-CALC on your computer using the program. The Setup program automatically installs QC-CALC , the Help system, sample data files and other product components from the CD to your hard disk. When you run the Setup program, you ll set a path for QC-CALC to install itself. To start Setup: 1. Insert the QC-CALC CD-ROM into your CD-ROM drive 2. If setup starts automatically skip to step #5 3. From the Windows Start Menu choose Run 4. Type x:\setup (where x: is the assigned letter of your CD-ROM drive) 5. Follow the Setup instructions on the screen. Note: QC-CALC has been adapted to collect information electronically from various inspection machines.

8 If you have purchased this program with an inspection machine, please review any special instructions that may be contained in the gray paper section found in the front of this Manual . QC-CALC Basics QC-CALC Page - 3 QC-CALC Basics This basic user section of the Manual provides the conceptual information that you need to know in order to use QC-CALC . Here we explain the program organization (menu options), and the structure of QC-CALC files. 1. Database Structure Each database is made up of individual records. Within each record, measure-ment results and extra values called FACTORs are stored for each individual part you measure.

9 To see the data formatted as illustrated below, select from QC-CALC SPC, View View as Edit Data. Rec No. Dim1 Dim2 .. Dim 1250 Date Time Numer Fact1 Numer Fact2 Text Fact1 Text Fact2 Fails 1 6/30/98 12:34 1 1 0 0 0 2 .. 6/30/98 12:35 1 1 0 0 0 3 .. 6/30/98 12:36 1 2 0 0 0 4 .. 6/30/98 12:38 2 2 0 0 0 5 .. 6/30/98 13:03 2 3 0 0 1 .. 15000 .. 6/30/98 06:00 1 6 0 0 0 Table 1 Conceptual View of Database Parts of the Database A QC-CALC database is simply a way of dividing a large body of information into smaller logical pieces. Grouping like information together into a file does this. Ideally, each file is devoted to a particular part type being measured.

10 Records The furthest left column lists the record numbers that make up the file you are viewing (the active file). Each record contains one part's worth of data. Dim The Dimension columns contain measurement results for each dimension in the database. Date / Time QC-CALC automatically includes the PC's current date and time. It receives the information from a measurement machine for each part (or record) and then is stored with the dimensional values. The Microsoft Windows format is used for date and time. Numer. Fact 1 - Numer. Fact 15 Numer. Fact stands for Numeric Factor. You can only enter numbers in these columns. You can use these columns to record information specific to each part stored in the database.