The Elsmar Cove Business Standards Discussion Forums More Free Files Forum Discussion Thread Post Attachments Listing Elsmar Cove Discussion Forums Main Page
Welcome to what was The Original Cayman Cove Forums!
This thread is carried over and continued in the Current Elsmar Cove Forums

Search the Elsmar Cove!

Wooden Line
This is a "Frozen" Legacy Forum.
Most links on this page do NOT work.
Discussions since 2001 are HERE

Owl Line
The New Elsmar Cove Forums   The New Elsmar Cove Forums
  Statistical Techniques and 6 Sigma
  Excel 4 CPK/CMK?

Post New Topic  Post A Reply
profile | register | preferences | faq | search

UBBFriend: Email This Page to Someone! next newest topic | next oldest topic
Author Topic:   Excel 4 CPK/CMK?
bagpuss
unregistered
posted 22 February 2001 06:00 PM           Edit/Delete Message   Reply w/Quote
I wanna set up a cap study spread sheet on excel. Any one got any ideas on setting up the formula?

IP: Logged

Rick Goodson
Forum Wizard

Posts: 102
From:Wuakesha, Wisconsin, USA
Registered: Aug 2000

posted 26 February 2001 05:35 PM     Click Here to See the Profile for Rick Goodson   Click Here to Email Rick Goodson     Edit/Delete Message   Reply w/Quote
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?

IP: Logged

Al Dyer
Forum Wizard

Posts: 622
From:Lapeer, MI USA
Registered: Oct 2000

posted 26 February 2001 05:50 PM     Click Here to See the Profile for Al Dyer   Click Here to Email Al Dyer     Edit/Delete Message   Reply w/Quote
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

IP: Logged

Bagpuss
unregistered
posted 02 March 2001 10:28 AM           Edit/Delete Message   Reply w/Quote
Sorry. I'm new at this. What is the FTP site. Thanks for the info!!

IP: Logged

Rick Goodson
Forum Wizard

Posts: 102
From:Wuakesha, Wisconsin, USA
Registered: Aug 2000

posted 02 March 2001 10:39 AM     Click Here to See the Profile for Rick Goodson   Click Here to Email Rick Goodson     Edit/Delete Message   Reply w/Quote
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.
https://elsmar.com/

IP: Logged

All times are Eastern Standard Time (USA)

next newest topic | next oldest topic

Administrative Options: Close Topic | Archive/Move | Delete Topic
Post New Topic  Post A Reply Hop to:

Contact Us | The Elsmar Cove Home Page

Your Input Into These Forums Is Appreciated! Thanks!


Main Site Search
Y'All Come Back Now, Ya Hear?
Powered by FreeBSD!Made With A Mac!Powered by Apache!