# Template for Capability Study

N

#### narfeldt

Where can I find a template (Excel) for capability studies?

------------------
/Best wish Narfeldt

[This message has been edited by narfeldt (edited 07 June 2001).]

C

#### cygnusx1

If you have a "standard" sample / sub-group size, it's fairly straight forward to create an excel template.

If you'd like to let me have further details of what you're looking for, I'm sure I can create one for you.

Cheers,
Don

N

#### narfeldt

My problem is how to get a graph with normal distrubution. The graph should illustrate a straight curve then the process is normal distrubated. I don't know what it's name are for this in your countries, but in sweden we call it normal distrubution paper.
------------------
Best wish Narfeldt

G

#### Graeme

Originally posted by narfeldt:
My problem is how to get a graph with normal distrubution. The graph should illustrate a straight curve then the process is normal distrubated. I don't know what it's name are for this in your countries, but in sweden we call it normal distrubution paper.

I have seen normal probability paper shown in several references, but I have never seen the paper itself. (The x axis is in sigma, and the y axis is in median rank. Each axis is scaled so that if an exact gaussian "normal" curve is plotted the result is a straight line.) (Does anyone know of a source?)

I have not seen a way to do that in Microsoft Excel - and I just checked a big book on formulas and macros again to be sure. Lots of histograms and curves, but no normal probability plots. This may be because Excel is optimized for general-purpose business applications and does not have many technical or statistical features.

On the occasions where I have needed to use this kind of graph, I have imported the data into a statistical analyis and graphics program. (I use StatMost; there are other good ones as well.) I would think that most statistical analysis programs have this kind of plot as a standard feature -- they are specialized for this kind of work. If you don't have such a program readily available I think it is a good idea to get one.

------------------
Graeme C. Payne
ASQ Certified Quality Engineer
[email protected]

K

#### Ken K.

Take the cost of messing around with templates (including checking their validity) and invest in a good statistical software package that does process capability analysis. MINITAB, StatGraphics, and JMP can do this.

I feel MINITAB has the best capability tools, StatGraphics next, and then JMP behind them. You can download free full-working demos of all of these by going to their respective websites:
http://www.minitab.com
http://www.statgraphics.com
http://www.jmpdiscovery.com

If the downloads are too long just call them - I'm sure they'll send you a demo disk.

R

#### Rick Goodson

Narfeldt & Graeme,

Contact TEAM (Techniacal and Engineering Aids for Management) in Tamworth New Hampshire, USA. They carry 100's of specialty graph papers including what we use to call Normal Probate paper or Normal Probability paper. Their telephone number is 603-323-8843.

Codex Book Company in Norwood Massachusetts use to carry a number of papers also. Their telephone number is 802-878-5570.

Hope this helps.

Rick

A

#### Al Dyer

Originally posted by narfeldt:
Where can I find a template (Excel) for capability studies?

A friend told me he downloaded and Excel add-on from the microsoft web site that addressed SPC. Might be worth a quick search.

ASD...

#### Howard Atkins

Staff member
This allows you to perform cpk analysis.

------------------
Howard Atkins

V

#### venkat

Mr.Howard Atkins

But I get the message as : cannot be accessed. file may be read only or in read only location or the server may not be responding

#### Howard Atkins

Staff member
When you open it you get a message as to macros. Enable them. Then you get a message as to read only. Say no, open as not read only.
If you have more problems e-mail me
Best luck

------------------
Howard Atkins

Excel Template for Cgk Study wanted (Capability Gauges Study) Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 12
A Capability Study Template Capability, Accuracy and Stability - Processes, Machines, etc. 1
C Process Capability - Attribute Data Analysis (Template) Document Control Systems, Procedures, Forms and Templates 0
C Process Capability - Variables Data Analysis (Template) Document Control Systems, Procedures, Forms and Templates 0
Excel Spreadsheet Template to calculate Cmk (Machine Capability) wanted Capability, Accuracy and Stability - Processes, Machines, etc. 2
Template or Checklist for Process Change Document Control Systems, Procedures, Forms and Templates 4
Process FMEA Template with examples - Cold and Hot Forged components FMEA and Control Plans 4
MDR GSPR Checklist template EU Medical Device Regulations 4
Email Template that go to a customer and then get returned to us for RMA/Warranty Document Control Systems, Procedures, Forms and Templates 1
Ford's MMOG/le Template wanted Manufacturing and Related Processes 0
SOP Template needed for ISO 13485 6.3 Infrastructure ISO 13485:2016 - Medical Device Quality Management Systems 9
Example of the Risk Template Document Control Systems, Procedures, Forms and Templates 1
Template for Excel Validation Reliability Analysis - Predictions, Testing and Standards 6
Informational MDCG 2020:13 - Clinical evaluation assessment report template EU Medical Device Regulations 0
Internal audit plan template Internal Auditing 6
New Equipment form / template Document Control Systems, Procedures, Forms and Templates 5
Supplier Audit Report - Template for second party audit wanted Lean in Manufacturing and Service Industries 1
Design Transfer Template capturing Customer Specific Requirements Other Medical Device Related Standards 3
Gage R&R Template AIAG 4th Edition IATF 16949 - Automotive Quality Systems Standard 3
Looking for a EU MDR Gap Analysis template EU Medical Device Regulations 4
Looking for a template SOP for UDI implementation for EU Medical Devices EU Medical Device Regulations 0
Is there any pre-defined Control plan format/template acc. VDA? VDA Standards - Germany's Automotive Standards 0
Level 3 KPI Excel Template Manufacturing and Related Processes 1
Informational New AIAG PFMEA Process - Excel Template Attached FMEA and Control Plans 23
ISO 9001:2015 Management Review Input Template wanted ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 1
Informational EU – Manufacturer incident report (MIR) for serious incident- template 2020 (Directives and new regulations) version 7.2 and related documents Medical Device and FDA Regulations and Standards News 2
Looking for Usability File Template acc. IEC 62366-1 and IEC 60601-1-6 IEC 62366 - Medical Device Usability Engineering 4
PMS template for FDA submission (De novo submission for a Class II IVD) 21 CFR Part 820 - US FDA Quality System Regulations (QSR) 8
Template for Attribute Gage R & R wanted Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 3
Medical device Validation/Verification template ISO 13485:2016 - Medical Device Quality Management Systems 1
Labeling template on QMS - Kitting and labeling documentation Manufacturing and Related Processes 9
Post Market Surveillance Plan Template EU Medical Device Regulations 6
PMCF (Post Market Clinical Followup)/ PSUR template EU Medical Device Regulations 8
QMS Template Help - Small machine shop/job shop Manufacturing and Related Processes 1
Need ISO 45001:2018 HIRA template Occupational Health & Safety Management Standards 9
Share a DFMEA template please Document Control Systems, Procedures, Forms and Templates 2
Looking for Risk Assessment Template - Not necessarily Asset based IEC 27001 - Information Security Management Systems (ISMS) 1
Australia TGA Medical Device Sponsor Agreement - Example or Template Other Medical Device Regulations World-Wide 14
Does anyone has a good verification and validation plan template? ISO 13485:2016 - Medical Device Quality Management Systems 3
ISO 45001:2018 Documentation template Occupational Health & Safety Management Standards 4
Template of a Management Review Agenda or Report in compliance with ISO 13485:2016 ISO 13485:2016 - Medical Device Quality Management Systems 6
Training template - controlled document? Document Control Systems, Procedures, Forms and Templates 21
ERP Audit Trail audit by FDA? Regular audit trail report template? 21 CFR Part 820 - US FDA Quality System Regulations (QSR) 10
IVDR and MDR ANNEX I Requirements Template EU Medical Device Regulations 5
Integrated risk and opportunities evalution template ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 0
Training Record Template and tracking Document Control Systems, Procedures, Forms and Templates 1
ITSM (IT Service Management) Ticket Audit Template Service Industry Specific Topics 0
ISO 14001 - Looking for a Gap Analysis Template ISO 14001:2015 Specific Discussions 3
Usability Process - Looking for a template (IEC 62366) IEC 62366 - Medical Device Usability Engineering 1
Template or example Excel list of ISO certificates issued to clients ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 5