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 to create Stoplight Control charts with excel?
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
Page 1 of 3 1 23
 
Thread Tools Search this Thread Rate Thread Content Display Modes
  #1  
Old 12th March 2009, 02:18 AM
hansin hansin is offline
Involved in Discussions

Registration Date: Apr 2008
Location: china shanghai
  
Posts: 15
Thanks Given to Others: 1
Thanked 0 Times in 0 Posts
Karma Power: 7
Karma: 10
hansin has less than 100 Karma points so far.
Please Help! How to create Stoplight Control charts with excel?
I hope to use Stoplight Control charts to control processes but I am poor in excel. Please help!
Last edited by harry; 12th March 2009 at 02:47 AM.
Reply With Quote

Sponsored Links
  #2  
Old 12th March 2009, 02:45 AM
harry harry is offline
Super Moderator

Registration Date: Sep 2005
Location: Johore/Malaysia
  
Posts: 2,941
Thanks Given to Others: 571
Thanked 1,031 Times in 746 Posts
Blog Entries: 1
Karma Power: 231
Karma: 7783
harry is appreciated, and has over 1700 Karma points.harry is appreciated, and has over 1700 Karma points.
harry is appreciated, and has over 1700 Karma points.harry is appreciated, and has over 1700 Karma points.harry is appreciated, and has over 1700 Karma points.harry is appreciated, and has over 1700 Karma points.harry is appreciated, and has over 1700 Karma points.harry is appreciated, and has over 1700 Karma points.harry is appreciated, and has over 1700 Karma points.harry is appreciated, and has over 1700 Karma points.harry is appreciated, and has over 1700 Karma points.harry is appreciated, and has over 1700 Karma points.harry is appreciated, and has over 1700 Karma points.
Default Re: How to create Stoplight Control charts with excel?
This is one of Steve's post related to this subject.

This one is from google search: Create Traffic Lights With Excel
Reply With Quote
Sponsored Links

  #3  
Old 12th March 2009, 03:23 AM
howste's Avatar
howste howste is offline
Thaumaturge

Registration Date: May 2003
Location: Utah
  
Posts: 2,416
Thanks Given to Others: 377
Thanked 838 Times in 460 Posts
Karma Power: 206
Karma: 6556
howste is appreciated, and has over 1700 Karma points.howste is appreciated, and has over 1700 Karma points.
howste is appreciated, and has over 1700 Karma points.howste is appreciated, and has over 1700 Karma points.howste is appreciated, and has over 1700 Karma points.howste is appreciated, and has over 1700 Karma points.howste is appreciated, and has over 1700 Karma points.howste is appreciated, and has over 1700 Karma points.
Default Re: How to create Stoplight Control charts with excel?
If I understand what you're asking for, conditional formatting is probably your best bet. Excel 2007 has a lot fancier capabilities, but conditional formatting still exists in previous versions.
Reply With Quote
  #4  
Old 12th March 2009, 03:28 AM
hansin hansin is offline
Involved in Discussions

Registration Date: Apr 2008
Location: china shanghai
  
Posts: 15
Thanks Given to Others: 1
Thanked 0 Times in 0 Posts
Karma Power: 7
Karma: 10
hansin has less than 100 Karma points so far.
Default Re: How to create Stoplight Control charts with excel?
Quote:
Originally Posted by harry View Post

This is one of Steve's post related to this subject.

This one is from google search: Create Traffic Lights With Excel
Thanks for your reply, but what I want is different from your offer, it is one for SPC control charts!
Last edited by Stijloor; 12th March 2009 at 03:34 AM.
Reply With Quote
  #5  
Old 12th March 2009, 03:40 AM
harry harry is offline
Super Moderator

Registration Date: Sep 2005
Location: Johore/Malaysia
  
Posts: 2,941
Thanks Given to Others: 571
Thanked 1,031 Times in 746 Posts
Blog Entries: 1
Karma Power: 231
Karma: 7783
harry is appreciated, and has over 1700 Karma points.harry is appreciated, and has over 1700 Karma points.
harry is appreciated, and has over 1700 Karma points.harry is appreciated, and has over 1700 Karma points.harry is appreciated, and has over 1700 Karma points.harry is appreciated, and has over 1700 Karma points.harry is appreciated, and has over 1700 Karma points.harry is appreciated, and has over 1700 Karma points.harry is appreciated, and has over 1700 Karma points.harry is appreciated, and has over 1700 Karma points.harry is appreciated, and has over 1700 Karma points.harry is appreciated, and has over 1700 Karma points.harry is appreciated, and has over 1700 Karma points.
Default Re: How to create Stoplight Control charts with excel?
You want to know how to create control charts with excel?
Reply With Quote
  #6  
Old 12th March 2009, 04:10 AM
hansin hansin is offline
Involved in Discussions

Registration Date: Apr 2008
Location: china shanghai
  
Posts: 15
Thanks Given to Others: 1
Thanked 0 Times in 0 Posts
Karma Power: 7
Karma: 10
hansin has less than 100 Karma points so far.
Default Re: How to create Stoplight Control charts with excel?
Quote:
Originally Posted by harry View Post

You want to know how to create control charts with excel?
You want to know how to create control charts with excel? yes!
only Stoplight Control (PLS see spc 2nd ,like pre control chart)!
Reply With Quote
  #7  
Old 12th March 2009, 04:14 AM
hansin hansin is offline
Involved in Discussions

Registration Date: Apr 2008
Location: china shanghai
  
Posts: 15
Thanks Given to Others: 1
Thanked 0 Times in 0 Posts
Karma Power: 7
Karma: 10
hansin has less than 100 Karma points so far.
Default Re: How to create Stoplight Control charts with excel?
[IMG]C:\Documents and Settings\Administrator\桌面\090312\停止灯控制图.jpg[/IMG]
Reply With Quote
  #8  
Old 12th March 2009, 04:17 AM
Stijloor's Avatar
Stijloor Stijloor is offline
Cross Forum Moderator

Registration Date: May 2003
Location: Charlotte, North Carolina.
Age: 61
  
Posts: 6,619
Thanks Given to Others: 1,315
Thanked 2,232 Times in 1,595 Posts
Karma Power: 377
Karma: 10934
Stijloor is appreciated, and has over 1700 Karma points.Stijloor is appreciated, and has over 1700 Karma points.Stijloor is appreciated, and has over 1700 Karma points.
Stijloor is appreciated, and has over 1700 Karma points.Stijloor is appreciated, and has over 1700 Karma points.Stijloor is appreciated, and has over 1700 Karma points.Stijloor is appreciated, and has over 1700 Karma points.Stijloor is appreciated, and has over 1700 Karma points.Stijloor is appreciated, and has over 1700 Karma points.Stijloor is appreciated, and has over 1700 Karma points.Stijloor is appreciated, and has over 1700 Karma points.Stijloor is appreciated, and has over 1700 Karma points.Stijloor is appreciated, and has over 1700 Karma points.Stijloor is appreciated, and has over 1700 Karma points.Stijloor is appreciated, and has over 1700 Karma points.
Default Re: How to create Stoplight Control charts with excel?
Quote:
Originally Posted by hansin View Post

[IMG]C:\Documents and Settings\Administrator\桌面\090312\停止灯控制图.jpg[/IMG]
What are you trying to post?

Stijloor.
Reply With Quote
Reply
Page 1 of 3 1 23

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 to create Stoplight Control charts with excel?

Bookmarks

Tags
excel, stoplight control charts

« 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
Sorting in Microsoft Excel .xls - I want to create a Pareto Chart Winner Excel .xls Spreadsheet Templates and Tools 15 24th April 2009 06:25 PM
How Can I Create a Bell curve in Excel 2007 bbrandon Excel .xls Spreadsheet Templates and Tools 7 15th February 2009 08:00 PM
Can someone help me create a POISSON ACUMULATIVE PROBABILITY table in Excel? Maolopez Excel .xls Spreadsheet Templates and Tools 1 25th May 2005 08:37 PM
Flow Charts in Excel - 'autoshape' and add text commands Laura M Excel .xls Spreadsheet Templates and Tools 8 23rd April 2003 12:28 AM
High Cpk's and Control Charts - Is it justified to stop using control charts? MSAFAI Capability, Accuracy and Stability - Process, Machine, etc. 7 11th August 2001 02:23 PM



The time now is 10:43 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