Best way to Chart an On-Going CPK Requirement

IRONPOORER

Starting to get Involved
#1
I have several parts that I am required to maintain CPK and send charts with every shipment (several times/week). We get the measurement data daily or at start-up and what I ned is a CPK chart that I can simply input new data into and the oldest drops off the back of the 30 data points in the report.


Ideas?
 
Elsmar Forum Sponsor

mwohlg

Involved In Discussions
#2
If you're good with Excel, you could set up a tab where you copy/paste the new data to the bottom of the column of old data, then delete the x-number of top rows to give you exactly 30 rows. Another tab runs the calculations and makes the charts, using the information in the first 30 rows of the data tab.

It's not automatic, but it's close...
 

bobdoering

Stop X-bar/R Madness!!
Trusted Information Resource
#3
I hope your process variation is one that is appropriate for Cpk calculations! Sounds like the big old Cpk rubber stamp hitting again!
 

IRONPOORER

Starting to get Involved
#4
Actually it is a complete waste of time :mad:; I have a ?.020" tolerance and hold ?.001-.002" and am centered on nominal- usually giving CPKs in the high teens or low twenties. However it is a CC on the print and I must send cpk charts with the certs.
 

Golfman25

Trusted Information Resource
#5
Actually it is a complete waste of time :mad:; I have a ?.020" tolerance and hold ?.001-.002" and am centered on nominal- usually giving CPKs in the high teens or low twenties. However it is a CC on the print and I must send cpk charts with the certs.
Consider yourself luck. We have requirements which are next to impossible to meet, but reality falls on deaf ears.

As for your charts, you can look into gainseeker. http://www.hertzler.com/software/products/gainseeker-statistical-process-control-software/

It keeps a running chart based on the last 25 values. You can print charts out using various data criteria. Or maybe you can program a spreadsheet to use a moving average of only the latest values you want.
 
Thread starter Similar threads Forum Replies Date
M Which is the best chart for monitoring 'incoming goods' data? Quality Tools, Improvement and Analysis 9
K What should be the best control chart? Cpk study for assembly length Capability, Accuracy and Stability - Processes, Machines, etc. 2
S What is the best method to bond urethane foam to urethane foam? Manufacturing and Related Processes 4
Watchcat Best Regulatory Oversight for Off-Shore Device Manufacturing? Other Medical Device Regulations World-Wide 1
E Best way to keep up with pharmaceutical quality knowledge and current affairs Service Industry Specific Topics 1
K Best Measurement Systems Demos in California? General Measurement Device and Calibration Topics 1
Q Best approach to get a real value as average? Statistical Analysis Tools, Techniques and SPC 6
CPhelan Best metrics for monitoring low volume (<1000) parts per vendors Supply Chain Security Management Systems 1
DuncanGibbons Best practice for identifying "items" of parts for DFMEA analysis AS9100, IAQG 9100, Nadcap and related Aerospace Standards and Requirements 2
I What kind of wine best complements the Friday that you close out your external audit findings? Opinions are welcome. Coffee Break and Water Cooler Discussions 12
I Non-Conformance vs OFI -- your best descriptions ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 61
A What are Practical data center best practices IEC 27001 - Information Security Management Systems (ISMS) 0
G Best Practices for IT auditing - Is a session-id necessary for a complete audit trail? IEC 27001 - Information Security Management Systems (ISMS) 0
S Best software for customer support/complaints? Customer Complaints 0
R Bill of Materials for a complex product - Industry best practice ISO 13485:2016 - Medical Device Quality Management Systems 2
G Oversized Threads - What sized stab pin would be best to quickly check for oversized thread holes General Measurement Device and Calibration Topics 5
D What is the best software used for the pharma compliance management? Pharmaceuticals (21 CFR Part 210, 21 CFR Part 211 and related Regulations) 0
M Informational MHRA launches consultation on how to best engage patients and the public Medical Device and FDA Regulations and Standards News 0
optomist1 Mobility Field Manufacturing Best - Worst Practices Manufacturing and Related Processes 5
Q Best criteria to measure Corrective Action effectiveness - Poor Maintenance ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 10
N Best practices for capturing audit objective evidence in a practical manner? Internal Auditing 3
S How to Learn all aspects of ISO 27001:2013 | The best way to grab the knowledge on 27001:2013 (Step by Step) IEC 27001 - Information Security Management Systems (ISMS) 7
I Best visual description for SOPs? ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 18
Z Best Practices - small volume medical device tube cutting (0.020" to 0.080" OD)? Manufacturing and Related Processes 3
M Over-labelling - Any requirements or best-practices? Other Medical Device Regulations World-Wide 0
M Informational DITTA White Paper on Cybersecurity: Best Practices in the Medical Technology Manufacturing Environment Medical Device and FDA Regulations and Standards News 0
M Informational BSI – MDR Documentation Submissions Best Practices Guidelines Medical Device and FDA Regulations and Standards News 0
K Which clause would best fit this Nonconformance? (Supplier Related) Internal Auditing 2
P How to have employees buy-in of quality procedures. Best practices? ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 8
S Expiry date vs. Best Before Date - Reagents ISO 13485:2016 - Medical Device Quality Management Systems 9
C Will anyone please share training material for ISO:13485:2016 for best practices Training - Internal, External, Online and Distance Learning 0
E Best GD&T training - Your suggestions and recommendations please Training - Internal, External, Online and Distance Learning 3
M Best Practice for setting tolerances on a Drawing Inspection, Prints (Drawings), Testing, Sampling and Related Topics 8
M PCBA Drawing Best Practices IPC Class 3 ISO 13485:2016 - Medical Device Quality Management Systems 1
Ron Rompen Best Practices in CMM Correlation Studies General Measurement Device and Calibration Topics 3
B Best place is to purchase IEC 60417 labels that will pass markings test IEC 60601 - Medical Electrical Equipment Safety Standards Series 1
P Best approach to tackle difficult certifications Career and Occupation Discussions 2
E Best Ways to Close a Project APQP and PPAP 3
S Opinions on the "Best" CMM for High Accuracy Machining General Measurement Device and Calibration Topics 9
C What is the best ISO 22000 template pack to purchase? Food Safety - ISO 22000, HACCP (21 CFR 120) 2
M Best Type of Grease for Vex Plastic Gears Manufacturing and Related Processes 5
W Which is best IAS academy in Chennai Career and Occupation Discussions 1
S Referencing procedures on Control Plans - Best Practices FMEA and Control Plans 3
somashekar Which Medical Device Regulatory Body you rate as the best Other Medical Device and Orthopedic Related Topics 6
P Best Method of Cleaning of Thread Ring Gages Calibration Frequency (Interval) 5
A Best Method of Auditing an Installation Process at a client job-site ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 4
J How to manufacture best Roll Forming machine? Manufacturing and Related Processes 1
Roberticus Best practices for parts washer conveyor to belt transitions Manufacturing and Related Processes 2
L Is a CAR addressed to your customer the best way to communicate with? Misc. Quality Assurance and Business Systems Related Topics 7
A How best to start revising an existing ISO 9001:2008 system in a company ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 5
Similar threads


















































Top Bottom