Excel Quality Tools
Statistical Process Control is an evolved form of target value steering. Partly you steer toward a target value, but also with the help of systematically performed sampling into a control chart.
It is this control chart which helps us make the right decision when we adjust the machinery or the process. The SPC - control chart file is a simple concept for helping operators to manage their work process.
- up to 45 samplings
- 3 to 8 parts per sampling
- automatic calculation of the control limits (based on Rbar or Xbar)
- average value adjustment possible
- also calculate the Cpk value
XBar-R Diagram "Datasheet" - Sheet
Target value, tolerance specifications, measurements and other information to be fed in this data sheet.
Capability parameter cpk calculated by using variation width and averages within the extracted samples.
XBar-R Diagram "Control Chart" - Sheet
The results of the SPC analyse is shown in two charts:
Xbar diagram (shows the average value of the extracted samples)
R diagram (shows the range of variation in the extracted samples)
XBar-R Diagram "Result" - Sheet
The results of the capability study is displayed in three different graphs:
Capability diagram (showing whether the result is normally distributed and all calculated capability parameters foreseeable in a table)
Production sequence (showing the change in results during production)
Histogram (showing the position against tolerance limits)
The price for the tool Xbar-R Diagram is 2.000 SEK excl. VAT.
To order Excel Quality Tools please use the
electronic order form.
The copyright of the Excel files is owned by Q2 Management Development AB. It is impermissible to copy, modify, distribute, promote or sell multiple or single files, unless written permission has been given from Q2 Management Development AB.
The Excel files are designed and developed by Q2 Management Development AB.