Quality Control Chart

What is Quality Control Chart?

Q

uality Control Chart is a powerful statistical process control software (SPC). It is used to graph quality control charts in order to monitor and control a process. Monitoring and controlling the process ensures that it operates at its full potential. At its full potential, the process can make as much conforming product as possible with a minimum (if not an elimination) of waste.

Quality Control Chart used in chemical laboratory or factory to graph quality control and process capability charts as performance-based program. It can be used to graph hundreds of QC charts and perform automatic calculations of control limits.

Why Quality Control Chart?

Use Quality Control Chart tp help you:

  • Watch process capability on real time.
  • Ensure that your process is under statistical control.
  • Reduce or eliminate process waste.
  • Emphasize early detection and prevention of problems.
  • Reduce the time required to produce the product.
  • Ensure the product is conformance to specification.
  • Gain your customer's confidence.

How it works?

Quality Control Chart is database software which runs on multiple PCs and interacts with users. All data stored into single database where it can be accessed from anywhere. Several types of databases are supported such as (MS Access, MS SQL and MySQL).

Example

As an example of the QC chart for a quality control in testing laboratories, we will take Laboratory Control Sample (QC) for selective test (Total Organic Carbons). QC sample is a real sample contains known concentration of the analyte, the QC sample processed along with all other samples in one batch. Every batch of 20 real samples contains one QC sample. Final result from all QC samples were collected and graph using Quality Control Chart software. Below is an example of statistical interpretations of all QC results.


Quality Control Chart automatically calculate QC limits which include:

  1. Mean
  2. UWL/LWL (Upper and lower warning limits)
  3. UAL/LAL (Upper and lower action limits)


When QC results between warnning limits UWL/LWL (orange lines) considered to be PASS. If the QC result is outside action limits (red lines) i.e. above UAL or lower than LAL then batch considered to be FAIL unless there is ajustification reason (e.g. double spiked by accident is not fail). If the QC result comes in between the orange line and red line (i.e. between UAL and UWL or between LAL and LWL) the batch most likely PASS with taking serious attention to the next point. If the same result appear contiously for the next couple of bacthes without justification reason then last batch considered FAIL and the system is out of statistical control.

Features

  • User friendly interface.
  • Easily Add/remove and restore points to/from QC charts
  • Import data from table similar to excel sheet.
  • Display various types charts (Indivisual points, XBar, Range, Standard Deviation and process capability) for the same points, easy switch between charts.
  • Import data from different QC Chart.
  • Multiple users security support with different roles for each.
  • Auto calculations of all QC limits.
  • Outlier detection (all outliers above UCL or below LCL will be highlighted with red color).
  • Export data to MS Excel (*xls), Comma Separated Values (*.csv), Tab Separated Values (*.tsv).
  • Export QC Chart as PDF, Bitmap (*.bmp), Windows Meta File (*.emf), Enhanced Windows Meta File (*.emf).
  • Support draging and zooming charts.
  • Change view options of the QC chart to way to like.
  • Generate professional reports include (Data report and QC Chart list).
  • Support Login/Logout from database with username and password.
  • Supported databases: MS Access 2003 or later, MS SQL Server 2000 or later, MySQL version 5.1 or later

System Requirements

A. System Requirements to work with normal MS Acess Database:

  • Windows XP, Vista, 7, 8

Note: MS Access is not required to be installed to work with Quality Control Chart.


B. System Requirements to work MS SQL and My SQL Database (Used for multiple PCs connected to one server):

  • Windows XP, Vista, 7, 8
  • Database software installed on server and client, one of the following supported database:
    1. Microsoft SQL Server 2000 or later.
    2. MySQL Community Server 5.1 (include MySQL GUI Tools and MySQL ODBC 5.1 Driver Connectivity) or later.

The software shipped with three database files MS Access 2000, MS SQL 2000 and MySQL 5.1. The MS Access database assigned as a default database at installation. To use MS SQL and MySQL files, an addition configurations required as per help files instructions.


Database Connection Lab Demonstration

Using MS SQL or MySQL, connect all lab departments and sections into one database. Help quality assurance program maintain the quality of service provided to customers.


FAQ

How to interpret data in Quality Control Chart?

The purpose of Quality Control Chart is to determine if a system is in statistical control. This determination is made by examining the location of individual points in relation to the warning limits (UWL,LWL) and the control limits (UCL,LCL), and the distribution of the points around the central line (Mean). If we assume that the data are normally distributed, then the probability of finding a point at any distance from the mean value can be determined from the normal distribution curve.


In any of the following cases for individual sample chart, the system will be out of control:

  1. If any individual point exceeds either the UCL or the LCL.
  2. If two out of three consecutive points are between the UWL and UCL or between the LWL and LCL. When a system is in statistical control, the data points should be randomly distributed about the center line. The presence of an unlikely pattern in the data is another indication that a system is no longer in statistical control.
  3. If a run of seven consecutive points is completely above or completely below the center line
  4. If six consecutive points are all increasing in value or all decreasing in value. The points may be on either side of the center line.
  5. If any obvious (nonrandom) pattern is observed.

All above points are to help you identify the error in your system, eventually you are the decision maker, to decide if any individual is outlier or not.

How to get started with Quality Control Chart?

Once you instal Quality Control Chart, the software will configure database automatically as MS Access database.

  1. Run Quality Control Chart from Desktop shortcut or from start menu.



  2. At the bottom status bar on the left side you can see the red light, meaning the database is disconnected. Next to the green light the current configured database source (QC_CHART_MSACCESS) is shown which is configured by default in the first time. Now Go to menu File >> Login , or press on login button (Green button) in the tool bar. The software will connect to the database and the red light will change to green light at the status bar.
  3. Go to menu QC Chart >> Load QC Chart..., list of all QC Chart in the database appeared, by default there is one installed as example. Select the TOC QC Chart from list and press Load button. The QC Chart will be loaded on the screen.



  4. Start move the QC Chart drawing by press hold and drag the right mouse button.
  5. Switch between charts (All Points, XBar,R Chart, S Chart) from the tabs at the bottom of the chart.
  6. Make zoom by press hold and drag with left mouse button or press on Zoom In and Zoom Out button on the tool bar. To reset the scale press rescale button.
  7. To edit result from table on, on the Edit column press on the button cell on the same line. Dialog will show to edit the result, edit the result, press save and close dialog or navigate to the next line using navigator.



  8. To add new result to the QC chart go to menu Points >> Add New Point. Then Edit Result dialog will show empty, fill data and press save check mark. Press F5 to refresh the QC Chart and see the new points.
  9. Sort data in the table by press at the header of each column. The data will be sorted in alphabetical order.
  10. To show calculate limits preferences, go to menu QC Chart >> Preferences. All calculations of QC Limits are based on statistical equations, modify the parameters from Preferences dialog:



How many points do I need to establish my first QC Chart?

We recommend to start with one point and continue adding until you reach 22 points. Once you have 22 points you will get clear picture of your system if it's under statistical control or not.

Where is my data stored and how can I make backup?

Your data stored in database. The default detabase is MS Access database which by default located in C:\Program files\Chemiasoft\QC Chart\Database\qcchart_access2000_db.mdb. Make backup for this file frequently. If you are using MS SQL or MySQL databases then you need help from an IT person who can make backup from the server where the database is located.

I want to buy Quality Control Chart for our lab, can you help me?

Yes, for sure. First you must decide which type of database you want and how many computer want access. Quality Control Chart support three database types (MS Access, MS SQL and MySQL), you may need IT person to answer this question. Database will be installed in server, clients computer will access the database through Quality Control Chart installed on each computer. After that you have to order one licesne for each computer. If you need any futher help please contact us..

Which is better for me to get Quality Control Chart downloaded version or delivery version?

It depends on you. If you are using only one PC to access the data then downloaded version is enough. If more than one PC then it's better to get delivery version with USB dongle so you can use Quality Control Chart on any PC you want once you connect the USB dongle.

How do you ship the delivery version?

We deliver using ecomonic express mail service (EMS). If you prefer another carrier please contact us.

Get The Latest Version

Version 1.7.12
Released on Oct, 29, 2015
License: Shareware 30 days trial.
OS: Windows XP, Vista, 7, 8.

DOWNLOAD


Download version for 79$

BUY DOWNLOAD


If you want volume license please contact us to get discount.

Screenshots

Getting Started Guide

DOWNLOAD GUIDE

What's New In Version 1.7.12

Oct, 29, 2015
  • Bug fix when importing points from other charts.
  • Bug fix when loading more than 10 QC Charts.

What's New In Version 1.6.9

June, 11, 2015
  • Bug fix when export chart as PDF file.
  • General optimizations.

What's New In Version 1.6.8

March, 17, 2015
  • Integration of TeeChart 2014 for Multilanguage support.
  • Integration of Fast Report 5.0 for Mutilanguage support for reporting system.
  • Option to export chart as PDF file for high resolution printing.
  • Add support to Mutilanguage entries.
  • Improved user interface.
  • Simplify databases setup and updates to become automatic.
  • Various bug fix.

What's New In Version 1.6

Oct, 13, 2014
  • Integration of Process Capability chart (PC).
  • Integration of Moving Range chart (MR).
  • Add LSL and USL fields to database.
  • Add support to write comments in Korean language.
  • Add chart zooming/scrolling tools.
  • Bug fix in R chart calculations.
  • Fix chart auto rescale issue.
  • Add print preview chart button.
  • Add Import from table button.
  • Improve Edit Result dialog.
  • Bug fix in hint display.

What's New In Version 1.5

Sep, 1, 2014
  • Add new charts, XBar, R and S charts.
  • Automatic calculations of QC Limits.
  • QC Limits calculations preferences dialog.

Other Products