Jump to content

Statistical Process Control Template for Spotfire® using Spotfire® Data Science - Workbench 2.1.0


1 Screenshot

Summary

This Spotfire template enables the user to build a wide range of Shewhart quality control charts. The chart specifications can be defined interactively or retrieved from a table. This comprehensive template is built with Statistica data function.

Overview

The basic building block of this template is the quality control chart. A control chart is used to monitor a process variable over time. The objective of monitoring is to determine if the process is in control or out of control. This helps to ensure that the process is stable over time and minimizes its output variability.  It can be applied in different fields like manufacturing, telco, energy, marketing, sales, healthcare, etc.

This template provides various quality control charts and tests relevant to process control:  you can construct charts for monitoring the process mean as well as variance, and you can create charts for individuals or X-bar charts. Here is the list of charts: X type charts for individuals, X-bar, EWMA, Moving average, Cusum, R/S charts, and histograms.  They can include central lines, control, warning as well as specification limits.

Points outside of limits are not the only way to identify atypical process behavior. Other tests implemented in this template are Runs Tests which identify a set of consecutive points that are not behaving randomly (e.g. 6 consecutive points with increasing or decreasing trend). All Rules Tests are configurable from inside the dashboard.

 

Implementation  

This component consists of two applications.

  • The first one - Application 1 - is an interactive dashboard application with extensive manual options to configure charts.  The user can interactively change almost every setting using document properties and parameters. Additional capabilities implemented in this application are Brushing (recalculating charts with excluded samples) and assigning causes, actions, and comments. This application is a good place to start defining and experimenting with various chart types, rules, and configurations.
  • If the user wants to investigate in an automated way a larger number of parameters with predefined configurations for quality control chart types and alarms, Application 2 can be used. All the definitions for each parameter are driven by one configuration line inside a configuration file. To run quality control charts for your data, all you need is to upload your configuration file and the measurement data. 

This template is working at the moment for the English locale.

 

We recommend reviewing a detailed article Process Control Monitoring and Alerting Solution describing the full solution which utilizes and extends capabilities of this template.

Release v2.1.0

Published: September 2021

This release adds some enhancements to previous release 2.0.0 of the template. Changes to previous version:

  • Selection condition parameter enabled for Application 2.
  • Fixing the not covered situation: in case there is only one sided limit defined from the variable (means not calculated) the alarm is now triggered for this situation. 
  • Data type for sigma multipliers in the configuration file  (Application 2) changed to real numbers instead of integers. 
  • Extended description inside the configuration file documentation (Application 2).
  • Redundant IronPython scripts has been removed from the dxp.

Release includes:

  • Two Spotfire applications for the quality control chart calculation and visualization 
  • Documentation
  • License information

 

Release v2.0.0

Published: May 2021

This release adds new generation of the template using configuration file for defining control charts specifications instead of manual dropdowns and sliders.

Release includes:

  • Version 1.0.0 (template with interactive manual choice of parameters)
  • New template (choice of parameters from configuration file)
  • Documentation
  • License information

 

Release v1.0.0

Published: May 2019

Initial release. This release is working on English locale (decimal places separator is dot character).


×
×
  • Create New...