bagpuss
22nd February 2001, 07:00 PM
I wanna set up a cap study spread sheet on excel. Any one got any ideas on setting up the formula??
|
*Please be aware that SOME RECENT forum threads may not yet be indexed by Google. |
|
View Full Version : Any ideas on setting up Capability study spreadsheet in Excel?(CPK/CMK formulae) Rick Goodson 26th February 2001, 06:35 PM 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? Al Dyer 26th February 2001, 06:50 PM 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 Bagpuss 2nd March 2001, 11:28 AM Sorry. I'm new at this. What is the FTP site. Thanks for the info!! Rick Goodson 2nd March 2001, 11:39 AM Open the site below with your web browser. It is the home page for Cayman Business Sytems. Push the FTP button. 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. |
|