SBS - The best value in QMS software

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
M

mwohlg

#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
P Best european location to set up for a virtual medical device manufacturer? EU Medical Device Regulations 4
optomist1 Best Optical Comparators General Measurement Device and Calibration Topics 9
qualprod Best practice to ensure inputting of data in production Lean in Manufacturing and Service Industries 13
M Best profilometer for the money General Measurement Device and Calibration Topics 22
P Best Global Option to become an OBL/PLM/Virtual medical device brand in 2020 Other Medical Device Regulations World-Wide 2
earl62 What is the best way to control special characteristics in Control plan? Is it Mandatory to have SPC for IATF 16949? IATF 16949 - Automotive Quality Systems Standard 12
J ISO 13485 System 'soft start' - How to best reflect this in initial audits, management review minutes and other records? ISO 13485:2016 - Medical Device Quality Management Systems 3
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
qualprod 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, NADCAP and Aerospace related 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
qualprod 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

Similar threads

Top Bottom