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


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 February 2006, 10:37 AM
HDR HDR is offline
Getting Involved (6 to 9 Posts)

Registration Date: Feb 2004
Location: United States
 
Posts: 8
Thanks Given to Others: 0
Thanked 0 Times in 0 Posts
Karma Power: 24
Karma: 10
HDR has less than 100 Karma points so far.
Question MSA Excel .xls worksheet that includes GR&R, Bias, Linearity, etc.

Does any one have a MSA Excel worksheet that includes GR&R, Bias, Linearity, etc. Thank you.
Reply With Quote

Sponsored Links
  #2  
Old 2nd February 2006, 10:59 AM
Marc's Avatar
Marc Marc is online now
Your Elsmar Cove Host

Registration Date: Jan 1996
Location: West Chester, Ohio - USA
Age: 59
 
Posts: 15,857
Thanks Given to Others: 1,895
Thanked 1,567 Times in 1,019 Posts
Blog Entries: 4
Karma Power: 605
Karma: 11564
Marc is appreciated, and has over 1700 Karma points.Marc is appreciated, and has over 1700 Karma points.Marc is appreciated, and has over 1700 Karma points.
Marc is appreciated, and has over 1700 Karma points.Marc is appreciated, and has over 1700 Karma points.Marc is appreciated, and has over 1700 Karma points.Marc is appreciated, and has over 1700 Karma points.Marc is appreciated, and has over 1700 Karma points.Marc is appreciated, and has over 1700 Karma points.Marc is appreciated, and has over 1700 Karma points.Marc is appreciated, and has over 1700 Karma points.Marc is appreciated, and has over 1700 Karma points.Marc is appreciated, and has over 1700 Karma points.Marc is appreciated, and has over 1700 Karma points.Marc is appreciated, and has over 1700 Karma points.Marc is appreciated, and has over 1700 Karma points.Marc is appreciated, and has over 1700 Karma points.
Send a message via AIM to Marc Send a message via Skype™ to Marc
Default

One discussion thread to look at is MSA Tools - Excel templates for doing the Linearity & Bias, & Stability Studies - There are a couple of spreadhseets in that thread.

There are also a number of spreadsheets listed in the post attachments files listing (scroll to the bottom of the page with more on the next page).

What instrument /gage(s) do you plan to use it with?
__________________
A Search is a terrible thing to waste!
One Test is Worth 1000 Expert Opinions - The plural of anecdote is not data.
We can't solve problems by using the same kind of thinking we used when we created them. - Unknown
Reply With Quote
Sponsored Links

  #3  
Old 2nd February 2006, 11:04 AM
Icy Mountain's Avatar
Icy Mountain Icy Mountain is offline
Sachem

Registration Date: Aug 2003
Location: Hilliard, Ohio, USA
Age: 45
 
Posts: 784
Thanks Given to Others: 53
Thanked 168 Times in 90 Posts
Karma Power: 98
Karma: 2869
Icy Mountain is appreciated, and has over 1700 Karma points.Icy Mountain is appreciated, and has over 1700 Karma points.Icy Mountain is appreciated, and has over 1700 Karma points.Icy Mountain is appreciated, and has over 1700 Karma points.Icy Mountain is appreciated, and has over 1700 Karma points.Icy Mountain is appreciated, and has over 1700 Karma points.Icy Mountain is appreciated, and has over 1700 Karma points.Icy Mountain is appreciated, and has over 1700 Karma points.Icy Mountain is appreciated, and has over 1700 Karma points.Icy Mountain is appreciated, and has over 1700 Karma points.Icy Mountain is appreciated, and has over 1700 Karma points.Icy Mountain is appreciated, and has over 1700 Karma points.Icy Mountain is appreciated, and has over 1700 Karma points.Icy Mountain is appreciated, and has over 1700 Karma points.Icy Mountain is appreciated, and has over 1700 Karma points.
Default

HDR,
Welcome to the Cove. There is also an AIAG sanctioned Excel spreadsheet with all of the core tools forms. Go to the AIAG Store and search for APD-0105. It's US$250.00 for a 5 seat license but it's worth its weight in gold.
__________________
Did you know that facts remain even when you disregard them?
Reply With Quote
  #4  
Old 2nd March 2006, 12:10 AM
vishd2003 vishd2003 is offline
Inactive Registered Visitor

Registration Date: Mar 2006
Location: US/MI
 
Posts: 2
Thanks Given to Others: 0
Thanked 0 Times in 0 Posts
Karma Power: 16
Karma: 10
vishd2003 has less than 100 Karma points so far.
Default Gage R&R Excel Form

There's a Excel Gage R&R form at - http://thequalityportal.com/q_forms.htm
Reply With Quote
  #5  
Old 2nd March 2006, 10:58 AM
tarheels4's Avatar
tarheels4 tarheels4 is offline
E-Mails Invalid or Rejected

Registration Date: Sep 2004
Location: Ohio
Age: 46
 
Posts: 352
Thanks Given to Others: 18
Thanked 4 Times in 4 Posts
Karma Power: 0
Karma: 152
tarheels4 is appreciated, and has over 100 Karma points.tarheels4 is appreciated, and has over 100 Karma points.
Default

Quote:
Originally Posted by HDR

Does any one have a MSA Excel worksheet that includes GR&R, Bias, Linearity, etc. Thank you.
Here is one for GR&R
Attached Files: 1. Scan for viruses before using, 2. Please report any 'bad' files by Reporting the post it is in, 3. Use at your Own Risk.
File Type: xls grr_KA.xls (29.0 KB, 446 views)
Reply With Quote
  #6  
Old 3rd March 2006, 03:50 AM
Howard Atkins's Avatar
Howard Atkins Howard Atkins is offline
Forum Administrator

Registration Date: Jul 1997
Location: Revivim, Israel
 
Posts: 2,412
Thanks Given to Others: 100
Thanked 448 Times in 253 Posts
Blog Entries: 8
Karma Power: 195
Karma: 4817
Howard Atkins is appreciated, and has over 1700 Karma points.
Howard Atkins is appreciated, and has over 1700 Karma points.Howard Atkins is appreciated, and has over 1700 Karma points.Howard Atkins is appreciated, and has over 1700 Karma points.Howard Atkins is appreciated, and has over 1700 Karma points.Howard Atkins is appreciated, and has over 1700 Karma points.Howard Atkins is appreciated, and has over 1700 Karma points.Howard Atkins is appreciated, and has over 1700 Karma points.Howard Atkins is appreciated, and has over 1700 Karma points.Howard Atkins is appreciated, and has over 1700 Karma points.Howard Atkins is appreciated, and has over 1700 Karma points.Howard Atkins is appreciated, and has over 1700 Karma points.Howard Atkins is appreciated, and has over 1700 Karma points.
Send a message via Skype™ to Howard Atkins
Default

Thank you both for these forms but please note that both of them use the 2nd edition constants and are not valid according to the latest edition of MSA
__________________
You can’t fake quality any more than you can fake a good meal.
* William S. Burroughs
Reply With Quote
  #7  
Old 3rd March 2006, 05:13 AM
Marc's Avatar
Marc Marc is online now
Your Elsmar Cove Host

Registration Date: Jan 1996
Location: West Chester, Ohio - USA
Age: 59
 
Posts: 15,857
Thanks Given to Others: 1,895
Thanked 1,567 Times in 1,019 Posts
Blog Entries: 4
Karma Power: 605
Karma: 11564
Marc is appreciated, and has over 1700 Karma points.Marc is appreciated, and has over 1700 Karma points.Marc is appreciated, and has over 1700 Karma points.
Marc is appreciated, and has over 1700 Karma points.Marc is appreciated, and has over 1700 Karma points.Marc is appreciated, and has over 1700 Karma points.Marc is appreciated, and has over 1700 Karma points.Marc is appreciated, and has over 1700 Karma points.Marc is appreciated, and has over 1700 Karma points.Marc is appreciated, and has over 1700 Karma points.Marc is appreciated, and has over 1700 Karma points.Marc is appreciated, and has over 1700 Karma points.Marc is appreciated, and has over 1700 Karma points.Marc is appreciated, and has over 1700 Karma points.Marc is appreciated, and has over 1700 Karma points.Marc is appreciated, and has over 1700 Karma points.Marc is appreciated, and has over 1700 Karma points.
Send a message via AIM to Marc Send a message via Skype™ to Marc
Default

Can the constants be changed or are the sheets locked?
__________________
A Search is a terrible thing to waste!
One Test is Worth 1000 Expert Opinions - The plural of anecdote is not data.
We can't solve problems by using the same kind of thinking we used when we created them. - Unknown
Reply With Quote
  #8  
Old 4th March 2006, 08:08 AM
tony s's Avatar
tony s tony s is offline
Registered Visitor

Registration Date: Sep 2003
Location: Philippines
Age: 36
 
Posts: 68
Thanks Given to Others: 61
Thanked 17 Times in 9 Posts
Karma Power: 38
Karma: 556
tony s is appreciated, and has over 500 Karma points.tony s is appreciated, and has over 500 Karma points.tony s is appreciated, and has over 500 Karma points.tony s is appreciated, and has over 500 Karma points.tony s is appreciated, and has over 500 Karma points.tony s is appreciated, and has over 500 Karma points.
Default GRR and Attribute Gage Study Forms

Hi guys,

I've been registered since 2002 and I got a lot of help from you. So, I want to reciprocate by sharing my wares. The "commingled chart" is linked to the "grr msa by ARK" file. You can edit cells with pastel colors.
Attached Files: 1. Scan for viruses before using, 2. Please report any 'bad' files by Reporting the post it is in, 3. Use at your Own Risk.
File Type: xls GRR MSA by ARK.XLS (77.0 KB, 689 views)
File Type: xls GRR Other Form.XLS (59.5 KB, 554 views)
File Type: xls Commingled Chart for GRR.xls (32.0 KB, 476 views)
File Type: xls Attribute Gage Study.xls (136.0 KB, 626 views)
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

Bookmarks


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
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
To formulate an Excel .xls worksheet for MSA on attribute data using Kappa Analysis veness Excel .xls Spreadsheet Templates and Tools 14 13th September 2005 10:23 AM
MSA Tools - Excel templates for doing the Linearity & Bias, & Stability Studies Courier Excel .xls Spreadsheet Templates and Tools 6 23rd October 2004 08:07 AM
Bias & Linearity Calculations and T Value Formula in the AIAG's MSA Manual Gregime Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 2 4th December 2003 09:50 PM
Error in MSA Manual - Discrimination - Bias Linearity Worksheet AllenLee Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 7 6th October 2003 07:45 PM
4.11.4 MSA is R&R Enough? Linearity, bias, stability necessary as well? saleh.E Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 3 13th February 2001 08:36 PM



The time now is 12:06 AM. All times are GMT -4.
The time zone can be changed in your UserCP --> Options.



   

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