Real Time SPC Gages and Interfaces

Shopping cart

0 Product(s) in cart

Total $0.00

» Checkout

Jay Arthur
888-468-1537
303-756-9144
KnowWare International, Inc.
DBA LifeStar
2253 S. Oneida
Ste 3D
Denver, CO 80224

We work with companies
that want to fire up their profits using
Lean Six Sigma

Copyright © 2011

Manufacturers have to measure parts and track results to ensure that production remains consistent and trouble-free. Statistical Process Control (SPC) is an excellent method to do this. The trick is that you have to get the measurement from the gage into an SPC chart in real time.

With the QI Macros, you can do real time SPC manually and mechanically.

Manual input - Employees on the production floor can perform real-time SPC by inputting data directly into one of the QI Macros fill-in-the-blanks-templates. They just input the data in the yellow area to the left and control charts, histograms, and probability plots are created on the right.

If your gage exports data into a comma delimited file (.csv), you can open the file with Excel and copy/paste the data into one of the QI Macros XmR, XbarR or XbarS templates to create charts instantly. Order Now!

Automated input - If manual input becomes too cumbersome or error-prone, imagine clicking the data button on a gage and automatically transferring each measurement into a template that calculates Cp, Cpk and and draws control charts.

Gage interfaces and the QI Macros (for one gage) or our Real Time SPC Worksheet (for multiple gages) make this easy.

Gage Interfaces

Modern gages allow for digital SPC output with the push of a button.

The gage connects to an interface via a cable or wireless modem. The interface connects to a PC running Excel and the QI Macros.

Keyboard-like Input

Software allows data coming from the gage to act like there's a typist at the keyboard. The gage name, data value, date/time stamp and so on can be transferred to an Excel spreadsheet with a single click of the gage's "data/read" button.

Using the QI Macros XmR template (for a single gage) or Real Time SPC Worksheet (for 2-8 gages), data read from each gage can automatically populate control charts, histograms and normal probability plots in real time:

Cp and Cpk values can be read directly from the worksheets. Unstable conditions can be identified directly from the control charts.

Real Time SPC Worksheet - view video

The Real Time SPC Worksheet takes data from 2-8 gages arriving as a single data stream (columns A:D) and splits them into individual columns of data by gage (F:G, I:J, L:M, etc.).

These automatically populate control chart worksheets like the one above and a Cp/Cpk worksheet:

MicroRidge Hardware and Software Interfaces

Download
QI Macros
30-Day Trial Now!

Or Buy It Now!