Any ideas on setting up Capability Study spreadsheet in Excel? (CPK/CMK formulae)

B

bagpuss

#1
I wanna set up a cap study spread sheet on excel. Any one got any ideas on setting up the formula??
 
Elsmar Forum Sponsor
R

Rick Goodson

#2
I am not sure I understand your question. The formula are the same ones you would use if doing a manual study and can be found in any good SPC book. Is it the statistics side or the Excel side you are having problems with?
 
A

Al Dyer

#3
Try the following file in the FTP site. The second page has a basic chart that will do CP/CPK/PP/CPK and is easily modified. Be sure to verify the formulas before you make decisions based on the file!

ASD...

Bias-Linearity_WS.xls
 
R

Rick Goodson

#5
Index of /pdf_files You will be in a file of documents that you can view on your browser or download to your computer. The majority of the files are pdf files (you need Adobe Acrobat Reader to see them), doc files (Microsoft Word), or xls files (Microsoft Excel). Click on the document name to see it.
 
Thread starter Similar threads Forum Replies Date
T Ideas for developing a Supplier Quality Management System, non automotive ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 5
M Production approval testing - Alternative ideas for Validation Reliability Analysis - Predictions, Testing and Standards 4
O Inventory control ideas - I have an open stock room with a "sign out" book Manufacturing and Related Processes 9
Ed Panek Ideas to keep quotes for consulting service accurate on not inflated Consultants and Consulting 11
B Practical ideas for information labelling in healthcare environment IEC 27001 - Information Security Management Systems (ISMS) 2
F Ideas for brewery poka-yoke system - Labels that are glued to a bottle Manufacturing and Related Processes 0
D Error proofing ideas sheet metal punches Manufacturing and Related Processes 8
D Ideas for Poka Yoke or Improvement - Aluminum FOD in Assembly Customer Complaints 3
K Looking for Calibrated Tool Shadowboard Substrate Ideas AS9100, IAQG 9100, Nadcap and related Aerospace Standards and Requirements 5
J ISO 17025 Guide and Ideas for a New Calibration Business ISO 17025 related Discussions 18
G Process for Product Safety - Ideas for Documenting Process for 4.4.1.2 IATF 16949 - Automotive Quality Systems Standard 3
Sean Kelley New Catchy Quality Policy Ideas Wanted IATF 16949 - Automotive Quality Systems Standard 4
P Need ideas on managing Shelf Life Studies within an organization ISO 13485:2016 - Medical Device Quality Management Systems 1
T Need ideas on Synchronization of Processes Design and Development of Products and Processes 2
D ISO/IEC 17025 Implementation Workshop Ideas ISO 17025 related Discussions 2
B Share ideas to make Management Review more interesting Management Review Meetings and related Processes 4
K Product Ideas for Manufacturing Startup Coffee Break and Water Cooler Discussions 4
Gman2 Scope Ideas? Can our scope contain bullets? Example inside. ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 5
K Ideas for an Open Source Calibration Database Software Calibration and Metrology Software and Hardware 3
T UK Quality Engineering Courses - Your ideas please Career and Occupation Discussions 3
9 Ideas for reducing Human Error during Order Receipt Quality Manager and Management Related Issues 4
B Starting a small boutique and looking for business ideas Career and Occupation Discussions 8
S Ideas on QA/RA Company Magazine Other US Medical Device Regulations 4
A "Refreshing" a Company Ideas scheme Lean in Manufacturing and Service Industries 8
C Ideas on Implementing Lean and 5S Methods Lean in Manufacturing and Service Industries 6
B Need ideas for a friendly bet - Year-end food drive Coffee Break and Water Cooler Discussions 6
L Working closer and better with Suppliers - Practical ideas to improve? Supplier Quality Assurance and other Supplier Issues 8
AnaMariaVR2 Developing Innovative Ideas for New Companies: free course Training - Internal, External, Online and Distance Learning 0
K Looking for Ideas to Track Customer Requests and PPAP Data Packages APQP and PPAP 4
F Quality Awareness Sessions - Seeking Ideas and Presentation Material Quality Manager and Management Related Issues 4
A Request for Daily Talking Point and Meeting Ideas Misc. Quality Assurance and Business Systems Related Topics 15
A R&D Design Control - Ideas to Improve the Quality of Drawings Design and Development of Products and Processes 7
T Quality Control System Ideas to stream line the PPAP Process ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 4
V Ideas, Measures/Metrics for making Quality Proactive? US Food and Drug Administration (FDA) 2
I Looking for Ideas/Tips for Management Review Meeting ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 25
B Ideas on how to differentiate jobs (AS9100 jobs vs. "commercial" jobs) AS9100, IAQG 9100, Nadcap and related Aerospace Standards and Requirements 6
T Let's share ideas about an inspection problem.... Inspection, Prints (Drawings), Testing, Sampling and Related Topics 6
I Any Ideas To Define The Root Cause of Corrosion Issue? Manufacturing and Related Processes 12
P Scorecard Data Forged - Ideas Please Quality Manager and Management Related Issues 3
Y Ideas of interactive exercises for a Quality Training (ISO 13485) Training - Internal, External, Online and Distance Learning 6
J Keeping Milk for Domestic Consumption Fresh - - Ideas? Coffee Break and Water Cooler Discussions 33
Chennaiite Product Release Risk Assessment - Ideas Wanted Design and Development of Products and Processes 2
A Sustainability 101 Training Ideas and Presentation Materials wanted Sustainability, Green Initiatives and Ecology 2
smryan Seeking Conference Room Name Ideas Coffee Break and Water Cooler Discussions 41
A Seeking Views and Ideas on Procedure related to Project Implementation ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 3
T Concept Process FMEA examples and ideas wanted FMEA and Control Plans 1
J Would like to remodel our QA Layout Laboratory - Your ideas appreciated Inspection, Prints (Drawings), Testing, Sampling and Related Topics 9
C Management Of Change System or Software - Recommendations and Ideas wanted After Work and Weekend Discussion Topics 2
P Floor Supervisor End of Shift Report ideas and/or template wanted Manufacturing and Related Processes 7
M Operator Station Inspection Training Materials and Ideas wanted Training - Internal, External, Online and Distance Learning 9
Similar threads


















































Top Bottom