BPI Consulting  

Home Support Contact About Us
Information
 
Articles, Newsletters
Home
SPC for MS Excel
MSA/Gage R&R
Customer Complaint SPC
Training
Consulting & Implementation
Articles, Newsletters
Special Offers
Ordering Information

 
SPC for MS Excel

Making SPC fun!


 
Below are our past e-zines (started in January 2004) and articles.  The e-zines contain the featured topic for the month.  The articles are pdf files.

e-Zines

bulletVariation (January 2004)
bulletLeadership and Variation (February 2004)
bulletOperational Definitions/Measurement System Analysis (March 2004)
bulletInterpreting Control Charts (April 2004)
bulletProblem Solving Model (May 2004)
bulletPareto Diagrams (June 2004)
bulletc Control Charts (July 2004)
bulletControl Strategies (August 2004)
bulletData Collection (September 2004)
bulletProcess Capability - Part 1 (October 2004)
bulletProcess Capability - Part 2 (November 2004)
bulletProcess Capability - Part 3 (December 2004)
bulletUse of Control Charts (January 2005)
bulletScatter Diagrams (February 2005)
bulletXbar-R Charts - Part 1 (March 2005)
bulletXbar-R Charts - Part 2 (April 2005)
bulletRational Subgrouping and Xbar-R Charts (May 2005) 
bulletClick here to download machine data
bulletRational Subgrouping and Xbar-R Charts - Part 2 (June 2005) 
bulletp Control Charts (July 2005) 
bulletExplaining Standard Deviation (August 2005)
bulletInspecting Supplier Material (September 2005)
bulletCreating Cause and Effect Diagrams (October 2005)
bulletAnalyzing Cause and Effect Diagrams (November 2005)
bulletHistograms - Part 1 (December 2005)
bulletHistograms - Part 2 (January 2006)
bulletThe Impact of Statistical Control (February 2006)
bulletRevisiting Variation (March 2006)
bulletSelecting the Right Control Chart (April 2006)
bulletMonitoring Test Methods Using SPC (May 2006)
bulletMonitoring Customer Complaints Using SPC (June 2006)
bulletOvercontrolling a Process: The Funnel Experiment (July 2006)
bulletComparing Two Processes (August 2006)
bulletPaired Sample Comparison (September 2006)
bulletIndividuals Control Charts (October 2006)
bulletDr. Deming and Profound Knowledge - Part 1 (October 2006)
bulletProcess Management Model (November 2006)
bulletClick here to download the process flow diagrams
bulletDr. Deming and Profound Knowledge - Part 2 (November 2006)
bulletDr. Deming and Profound Knowledge - Part 3 (December 2006)
bulletDr. Deming and Profound Knowledge - Part 4 (January 2007)
bulletComparing Multiple Processes (February 2007)
bulletBox and Whisker Plots (March 2007)
bulletChunky Data and Control Charts (April 2007)
bulletRare Events and X-mR Charts (May 2007)
bulletSPC and On-Time Performance (June 2007)
bulletu Control Charts (July 2007)
bulletSPC & Process Improvement in the Warehouse (August 2007)
bulletVariable Measurement Systems - Part 1: Stability (September 2007)
bulletVariable Measurement Systems - Part 2: Bias (October 2007)
bulletVariable Measurement Systems - Part 3: Linearity (November 2007)
bulletVariable Measurement Systems - Part 4: Gage R&R (December 2007)
bulletRevisiting Variation (January 2008)
bulletSmall Sample Case for p and np Control Charts (February 2008)
bulletSmall Sample Case for c and u Control Charts (March 2008)
bulletAre the Skewness and Kurtosis Useful Statistics? (April 2008)
bulletClick here to download the workbook with the calculations

 

Sign-up for the SPC for MS Excel monthly e-zine!

SPC examples, case studies, and more!

Email

 

 

Articles

bullet"Using Time Series Charts to Analyze Financial Data" - this paper was presented at the 2002 Annual Quality Congress and describes how one company has used time series charts to analyze financial data (from the monthly profit and loss statement). (Download size: 375 KB)

 

bullet"Cutting Costs, Not Employees" - this paper describes how organizations can cut costs without cutting employees; it also describes the role of the quality professional in making this happen. (Download size: 400 KB)

 

bullet"Process Management" - this paper was presented at the 2001 Annual Quality Congress and shows how one company is using Process Management as its method to embed quality into the culture of the company, to run its business, to optimize systems and to reach its vision.  At the heart of Process Management is a five-step method that is applied to each primary process: define, document, measure, manage and improve.  The model represents a blend of process and people skills, which include statistical analysis of processes, teamwork, and team styles. (Download size 275 KB)  

 

bullet"Quality Skills Training: A Roadmap For Learning" - this paper was presented at the 2003 Annual Quality Congress.  The purpose of this paper is to provide a blueprint for conducting monthly quality training to all associates.  The major component of this blueprint is called Quality Skills Training (QST).  QSTs are one and half-hour training sessions.  This paper describes how these training sessions are designed and includes a teaching guide for one topic: creativity.  This paper is designed to be part of an interactive session where the QST on creativity is presented as part of the blueprint. (Download size 378 KB)

 

bullet"Develop Effective Metrics for Supply Management" - this paper was presented at the 90th Annual International Supply Management Conference in May 2005. Metrics are used to know where you are, where you have been and where you are going.  This paper examines a process for selecting metrics based on the organization’s vision.  The best way to know if a metric is changing is to examine the data over time using time-series charts.  A ten-step process to implement metrics is also presented. (Download size 61KB)

 

SPC for MS Excel

This software provides an easy and affordable method of creating and updating charts in Microsoft Excel.

 

 

      SPC for MS Excel MSA/Gage R&R Customer Complaint SPC Training Consulting & Implementation Articles, Newsletters Special Offers Ordering Information