All data must be Entered in the Quality Inspection Entry and Defect Information screens, with in the Shop Floor Tracking Module.

In order to have the "DPMO by Employee" report create valid data, the user must be sure to enter the opportunities for defects (PPM) in the Work Order Traveler Setup and the employee must inspect the board and be assigned to the defects.  The "DPMO by Employee" report only gathers data if BOTH "Inspected By" and "Emp" are the same user, and the PPM is setup.   See Article #3156  for further detail on DPMO.   The following steps need to be followed to collect and track defects per employee. 

All data must be Entered in the Quality Inspection Entry and Defect Information screens, with in the Shop Floor Tracking Module.

Enter the SQLMANEX.EXE (within the ManEx root directory) This action will then prompt the user for a password
The following screen will be displayed, select Quality/Engineering/Statistical Quality Control (SQC) Module

The following screen will be displayed:

Template Selection Setup

This is the first screen to be used in the module. In this screen, STATISTICAL QUALITY CONTROL graphics are created by selecting parameters to be considered in the graph.

This screen operates differently than all other ManEx screens. When bringing up the SQC module, the user is first presented with a template screen from which to choose parameters to be included in the information displayed. 

When the user enters the system, he/she may select how they want to start the process of selection.  Click on the Customer, Part Number or Work Order radial.

Clicking on the Customer radial will bring up the following selection screen:  Select either Customer List or All Customers.

Selecting by Customer List will bring up the following selection screen:   Type the Customer into the red box or highlight and double click.
If the user selects by All Customers, the following screen will appear, listing All Customers, Work Centers, and Defects:

If the start is from Part Number, the following selection will appear:

If the user selects Product Number List, the following list will appear: Type the Part Number into the red box or highlight and double click.
If the user selects All Products, the following screen will appear, listing All Part Numbers, Work Centers, and Defects:

If the user starts with the Work Order start, the following selection will appear:

If the user selects the Work Order List option, the following screen will appear: User may Select from:  Open, Closed/Cancelled or All The Select from:   Work Order Number, Product Number, Customer, Sales Order Number, or All  Enter complete or partial info into the Red box or highlight and double click.
If the user selects All Work Orders the following screen will appear listing all Work Orders, all Work Centers, and all Defects.

	In the Work Order section, choose from All, One or Some.  If you’ve selected one, highlight the desired work order.  If you want more than one, depress the Ctrl key and click on the ones desired.
	In the Work Center section, choose from All, One or Some.  If you’ve selected one, highlight the desired work center.  If you want more than one, depress the Ctrl key and click on the ones desired.
	Make the same selection in the Defect List section.  If you want all defects displaying as per the System Setup, check the Defect List box.
	To make a new selection, depress the New Selection button.

Template Detail Screen

Pressing on the Template Detail tab brings up the following screen:

Enter the Date Range, From and To.  Mark the Radial for the view by Daily, Weekly, Monthly, or Yearly.

Mark the radial for the User Defined Limits for DPMO chart:  Lower Limit, Central Line, Upper Limit or Reset.  Indicate Central Line amount in box.

Mark the radial for the User Defined Limits for pChart:   Lower Limit, Central Line, Upper Limit or Reset.  Indicate Central Line amount in box.

To Save this template for future use go back to the Template Selection/Setup tab enter in a name and depress the Save button.  The Template will be saved in the Viewing Template field for future use.  

 

 

Enter the SQLMANEX.EXE (within the ManEx root directory) This action will then prompt the user for a password
The following screen will be displayed, select Quality/Engineering/Statistical Quality Control (SQC) Module

The following screen will be displayed:

Template Selection Setup

This is the first screen to be used in the module. In this screen, STATISTICAL QUALITY CONTROL graphics are created by selecting parameters to be considered in the graph.

This screen operates differently than all other ManEx screens. When bringing up the SQC module, the user is first presented with a template screen from which to choose parameters to be included in the information displayed. 

When the user enters the system, he/she may select how they want to start the process of selection.  Click on the Customer, Part Number or Work Order radial.

 

 

 

The user then may select to view just a Customer List, Product Number List, Work Order List, or All Customers, All Products, or All Work Orders.

 

Once they have made their choice, the following screen will appear.  Depending on the selection the following screen may differ.

 

 

  

	In each section, choose from All, One, Some, or Clear.  If you’ve selected one, highlight the desired. If you want some (more than one), depress the Ctrl key and click on the ones desired.  If you want all defects displaying as per the System Setup, check the "Show all defects from systems setup" box.
	To make a new selection, depress the New Selection button.

Template Detail Screen

Pressing on the Template Detail tab brings up the following screen:

Enter the Date Range, From and To.  Mark the Radial for the view by Daily, Weekly, Monthly, or Yearly.

Mark the radial for the User Defined Limits for DPMO chart:  Lower Limit, Central Line, Upper Limit or Reset.  Indicate Central Line amount in box.

Mark the radial for the User Defined Limits for pChart:   Lower Limit, Central Line, Upper Limit or Reset.  Indicate Central Line amount in box.

Indicate the user defined goal for the Yield Chart.

View Chart Screen/Graphs

Pressing on the View Chart brings up the Graphics Display Window.

Defect Pareto Chart - The results being displayed in the Pareto Chart are from Several Work Orders combined.    

Defect Pie Chart -  The results being displayed in the Defect Pie Chart are from several Work Orders Combined. 

 

The formula for the Central line (Green line) is:   c = Total Defects (divided by) Number of Subgroups

The formula for the Upper Control Limit (UCL) (Blue line)  = c + 3 (divided by) p

The formula for the Lower Control Limit (LCL) (Yellow line) = c - 3 (divided by) p (or 0, whichever is greater)

 

 

 

Defects Per Million Opportunities.  There are several ways to setup the opportunities (which means the number of possible defects that can occur on a product),  but it is up to each company to make that decision.  For Example: Some may say that a resistor with two leads that are not properly soldered is counted as two defects and some may only count it as one defect, since it is one part that was assembled incorrectly.   The opportunity or the standard opportunity is entered in the Work Order Traveler Setup module.  The field is called PPM = Parts per million. 

The DPMO chart uses the PPM as a reference to measure the actual failures against the total inspected quantity.

See Article #3156  for further detail on DPMO. 

The formula for calculating DPMO chart is as follows:

Example (2+3+3) = SUM of defect quantities (8) * opportunities or PPM (1,000,000) (divided by) Qty Inspected (500) (divided by) parts per unit (100) = 160

Daily, Weekly, Monthly, Yearly

On the Y axes the graph shows number of defects per million

One the X axes day or week or month or year

This graph collects defect information for the selected work centers and work orders in the selected date range. The user also has to select if the information will be grouped by day, week, month, or year.

The selected group will be your X coordinates on the graph.

The Y coordinates will be calculated as sum of the defect quantities *opportunities or PPM divided by total Qty inspected (divided by) parts per unit (qty was entered in the routing module) grouped by X coordinate unit (Daily, weekly, monthly, yearly).

This is a data line there is three more control lines displayed on the graph:

Central control line:

Upper control line:

Lower control line

All three lines could be user define lines.

If the lines are not user define lines they calculated as following

Central Line

lnCentralLine=lnTotalDef/lnTotalComp, where lnTotalDef is sum of all defect quantities * 1000000 and lnTotalComp is sum of inspected quantities*Parts Per Unit (entered in the routing module)

At this time system will decide if it can use average group size or not. If the size group varies more tan 15% the system will use variance Upper and Lowercontrol limit.   If average group size could be used the average group size gets calculated by taking lnAvrgSubgrSize=lnTotalComp divided by number of groups and rounded to the nearest integer.

Calculation for the Upper Control Line

LnUpperLine=ROUND(((3*(SQRT(lnCentrLine*(1000000-lnCentrLine))))/SQRT(lnAvrgSubgrSize)),3)

Calculation for the Lower Control Line

lnLowerLine = ROUND(lnCentrLine -((3*(SQRT(lnCentrLine*(1000000-lnCentrLine))))/SQRT(lnAvrgSubgrSize)),3)

Defects Distribution Chart - The results being displayed in the pChart are from all Work Orders, Work Centers, and all defects from 01/01/2012 thru 01/31/2012 (1 month)  

 

 

Yield Chart -  "Yield" =  Total number of units handled correctly through the process step(s). This is usually measured in a percentage.  The results being displayed in the "Yeild Chart" is the ratio of summed inspected qty and summed passed qty, grouped by date (user can select WO number, defect code to be filtered).  The results below are from One Work Order, All Work Centers, and all defects for one day 07/10/2013.    

1^st Pass Yield Chart  The results being displayed are from all Work Orders, Work Centers, and all defects from 01/01/2012 thru 01/31/2012 (1 month).  

1st Pass Yield chart in the SQC module is designed only when the serial number is used for the work order.  The system uses the serial number to determine how many serial numbers passed without failure/defects within a work order.  1st Pass Yield chart will be blank if there are no product tracked by serial number within the production floor

 

  

To enter a new title, depress the Graph Title button. The following will be displayed:

Enter in the new desired Graph Title. Depress the Exit button, and the graph title will be updated.