The Elsmar Cove Forum and Site Map The Elsmar Cove Wiki More Free Files The Elsmar Cove Forums Discussion Thread Index Post Attachments Listing Failure Modes Services and Solutions to Problems Elsmar cove Forums Main Page Elsmar Cove Home Page

Go Back   The Elsmar Cove Forum > Common Quality Assurance Processes and Tools > Quality Tools, Improvement and Analysis > Quality Assurance and Compliance Software Tools / Solutions > Excel .xls Spreadsheet Templates and Tools
Reload This Page How do we calculate the control chart by using excel .xls spreadsheet?
Register Photo AlbumsBlogs FAQ Registered Visitors Social Groups Calendar Search Today's Posts Mark Forums Read


The Elsmar Cove Forum SideBar!
Monitor the Forum
Monitor New Forum Posts
New Threads Feeds
RSS FeedRSS Feed
Sponsor Link










$ Contributor Forum Access
Courtesy Quick Links

Links that Elsmar Cove visitors will find useful in your quest for knowledge:

Howard's International Quality Services

Atul's Symphony Technologies

Dave Scott's Scott Quality Solutions

Praxiom Research Group

NIST's Engineering Statistics Handbook

IRCA - International Register of Certified Auditors

SAE - Society of Automotive Engineers

Quality Digest Portal

IEST - Institute of Environmental Sciences and Technology

ASQ - American Society for Quality

All the Important Standards and Related Web Sites in the World
Reply
 
Thread Tools Search this Thread Rate Thread Content Display Modes
  #1  
Old 2nd June 2006, 06:17 AM
amanbhai amanbhai is offline
Involved - Posts

Registration Date: Apr 2005
Location: CANADA
  
Posts: 666
Thanks Given to Others: 56
Thanked 19 Times in 17 Posts
Karma Power: 35
Karma: 155
amanbhai is appreciated, and has over 100 Karma points.amanbhai is appreciated, and has over 100 Karma points.
Question How do we calculate the control chart by using excel .xls spreadsheet?
HOw do we calculate the control chart by using excel? I search it & could not find any. Positively
Reply With Quote

Sponsored Links
  #2  
Old 2nd June 2006, 06:46 AM
apestate apestate is offline
Inactive Registered Visitor

Registration Date: Jan 2003
Location: Melbourne, FL
  
Posts: 446
Thanks Given to Others: 2
Thanked 1 Time in 1 Post
Karma Power: 59
Karma: 1151
apestate is appreciated, and has over 1100 Karma points.apestate is appreciated, and has over 1100 Karma points.apestate is appreciated, and has over 1100 Karma points.apestate is appreciated, and has over 1100 Karma points.apestate is appreciated, and has over 1100 Karma points.apestate is appreciated, and has over 1100 Karma points.apestate is appreciated, and has over 1100 Karma points.apestate is appreciated, and has over 1100 Karma points.apestate is appreciated, and has over 1100 Karma points.
Default
I assume you're asking how to establish UCL and LCL, upper control limit and lower control limit.

These are usually established through a capability study.

Direct answer:
http://www.qualitydigest.com/oct97/html/excel.html

Background info:
http://www.isixsigma.com/library/content/c030306a.asp

Good search to try:
http://www.google.com/search?hl=en&l...ormula+example
Reply With Quote
Sponsored Links

  #3  
Old 2nd June 2006, 01:56 PM
Steve Prevette's Avatar
Steve Prevette Steve Prevette is offline
Deming Disciple

Registration Date: Feb 2004
Location: Aiken, SC
  
Posts: 1,473
Thanks Given to Others: 60
Thanked 403 Times in 241 Posts
Karma Power: 190
Karma: 6872
Steve Prevette is appreciated, and has over 1700 Karma points.Steve Prevette is appreciated, and has over 1700 Karma points.
Steve Prevette is appreciated, and has over 1700 Karma points.Steve Prevette is appreciated, and has over 1700 Karma points.Steve Prevette is appreciated, and has over 1700 Karma points.Steve Prevette is appreciated, and has over 1700 Karma points.Steve Prevette is appreciated, and has over 1700 Karma points.Steve Prevette is appreciated, and has over 1700 Karma points.Steve Prevette is appreciated, and has over 1700 Karma points.
Default
Quote:
Originally Posted by amanbhai

HOw do we calculate the control chart by using excel? I search it & could not find any. Positively
I have a writeup on the internet at http://www.hanford.gov/rl/?page=1144&parent=169
__________________
Steve Prevette
"A Passionate Statistician", ASQ CQE, Fluor Government Group
The opinion stated above does not necessarily reflect that of my employer.
Last edited by Steve Prevette; 24th February 2009 at 10:49 AM. Reason: "Dead link" was not dead
Reply With Quote
Thanks to Steve Prevette for your informative Post and/or Attachment!
  #4  
Old 2nd June 2006, 06:53 PM
Sartaj Bedi Sartaj Bedi is offline
Involved in Discussions

Registration Date: Apr 2006
Location: India
  
Posts: 11
Thanks Given to Others: 3
Thanked 1 Time in 1 Post
Karma Power: 15
Karma: 25
Sartaj Bedi has less than 100 Karma points so far.
Send a message via MSN to Sartaj Bedi
Default
Hi
Try this wedsite
***DEAD LINK REMOVED***
It has a lits of tools all on excel.
Last edited by Marc; 24th February 2009 at 12:11 AM. Reason: ***DEAD LINK REMOVED***
Reply With Quote
Thanks to Sartaj Bedi for your informative Post and/or Attachment!
  #5  
Old 23rd February 2009, 11:46 PM
bobdoering's Avatar
bobdoering bobdoering is offline
Stop X-bar/R Madness

Registration Date: May 2002
Location: LaGrange, OH
  
Posts: 2,092
Thanks Given to Others: 680
Thanked 563 Times in 469 Posts
Blog Entries: 13
Karma Power: 150
Karma: 3915
bobdoering is appreciated, and has over 1700 Karma points.
bobdoering is appreciated, and has over 1700 Karma points.bobdoering is appreciated, and has over 1700 Karma points.bobdoering is appreciated, and has over 1700 Karma points.bobdoering is appreciated, and has over 1700 Karma points.bobdoering is appreciated, and has over 1700 Karma points.bobdoering is appreciated, and has over 1700 Karma points.bobdoering is appreciated, and has over 1700 Karma points.bobdoering is appreciated, and has over 1700 Karma points.
Send a message via Yahoo to bobdoering
Default Re: How do we calculate the control chart by using excel .xls spreadsheet?
For precision machining, see Statistical process control for precision machining. You will find calculations for UCL and LCL for the X hi/lo-R chart.
Reply With Quote
Reply

Lower Navigation Bar
Go Back   The Elsmar Cove Forum > Common Quality Assurance Processes and Tools > Quality Tools, Improvement and Analysis > Quality Assurance and Compliance Software Tools / Solutions > Excel .xls Spreadsheet Templates and Tools
Reload This Page How do we calculate the control chart by using excel .xls spreadsheet?

Bookmarks

Tags
.xls, control chart, excel, excel spreadsheet, forms

« Previous Thread | Next Thread »

Visitors Currently Viewing this Thread: 1 (0 Registered Visitors and 1 Unregistered Guests)
 
Thread Tools Search this Thread
Search this Thread:

Advanced Forum Search
Display Modes Rate Thread Content
Linear Mode Linear Mode
Rate Thread Content:

Posting Settings
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Discussion Threads
Discussion Thread Title Thread Starter Forum Replies Last Post or Poll Vote
SPC Chart pro forma - Seeking word .doc or excel .xls spreadsheet Denis Excel .xls Spreadsheet Templates and Tools 17 22nd May 2009 01:28 PM
How to build an SPC control chart in an Excel .xls spreadsheet dbulak@psteel.com Excel .xls Spreadsheet Templates and Tools 8 16th February 2009 01:02 PM
X-R chart - I need a Microsoft Excel .xls Programmed X-R chart spreadsheet! cokyat Excel .xls Spreadsheet Templates and Tools 40 24th August 2006 05:07 AM
Needed: Electronic or an Excel .xls spreadsheet version of a P-Chart squigs72 Excel .xls Spreadsheet Templates and Tools 4 23rd January 2006 09:25 AM
Software or Excel .xls spreadsheet to calculate sample size and the AQL - ISO 2859-1 Ced Excel .xls Spreadsheet Templates and Tools 2 24th September 2002 11:14 AM



The time now is 04:05 PM. All times are GMT -4.
The time zone can be changed in your UserCP --> Options.

Contact Marc - Elsmar Cove Site Home Page - Elsmar Cove Index (Ar) - Privacy Statement - Top


   

All Y'All Come Back Now, Y' Hear?

Made With A Mac! FreeBSD OS Powered by Apache!
Using php4 Forums provided and maintained by Marc Smith Database by MySQL

FAIR USE and CORRECTNESS NOTICE: This site contains copyrighted material the use of which has not always been specifically authorized by the copyright owner. We are making such material available in our efforts to advance understanding of environmental, political, human rights, economic, democracy, scientific, and social justice issues, etc. We believe herein constitutes a 'fair use' of any such copyrighted material as provided for in section 107 of the US Copyright Law. In accordance with Title 17 U.S.C. Section 107, the material on this site is distributed without profit to those who have expressed a prior interest in receiving the included information for research and educational purposes. For more information go to: http://www.law.cornell.edu/uscode/17/ If you wish to use copyrighted material from this site for purposes of your own that go beyond 'fair use', you must obtain permission from the copyright owner. In addition, I do not guarantee the correctness of the content. The risk of using content from the Elsmar Cove web site and forums remains with the user/visitor.

Responsibility Statement: Each person is responsible for anything they post in the Elsmar Cove forum. Neither I, Marc Timothy Smith, nor any of the forum Moderators, are responsible for the content of posts people make. Liability for post content resides with the poster as does interpretation and/or acceptance and/or use of advice by the reader.

Complaints: If you have a complaint with a post in a forum discussion thread, including Content in general, fighting, flaming, copyright infringement, defamation and/or 'slander', please use the 'Report This Post Report This Post Button button which appears at the top of every post in every thread.
Site courtesy of:
Marc Timothy Smith - Cayman Business Systems, 8466 Lesourdsville-West Chester Road, West Chester, Ohio 45069-1929 - USA
(513) 341-6272

To contact me, click the Google Voice link below, enter Your Name and Your Phone Number and Google will ring your phone and connect you for free!
The Elsmar Cove Web Site is *CopyFree*
no new posts