Elsmar Cove Forum Header Graphic 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
NQA-USA
NQA-USA
Miner's MSA (Measurement Systems Analysis) Blog 
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
Forum Username

Search the Elsmar Cove
Search Elsmar
Monitor the Elsmar Forum
Follow Marc & Elsmar
Elsmar Cove Forum RSS Feed  Marc Smith's Google+ Page  Marc Smith's Linked In Page   Marc Smith's Elsmar Cove YouTube Page  Marc Smith's Facebook Page  Elsmar Cove Twitter Feed
Elsmar Cove Groups
Elsmar Cove Google+ Group  Elsmar Cove LinkedIn Group  Elsmar Cove Facebook Group
Donate and $ Contributor Forum Access
Courtesy Quick Links

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

Howard's
International Quality Services
Marcelo Antunes'
SQR Consulting
Bob Doering's
Correct SPC - Precision Machining

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

Related Topic Tags
bias study (measurement), gage r&r (repeatability and reproducibility), linearity, linearity study, microsoft excel .xls .xlsx spreadsheet, msa (measurement system analysis)
Reply
 
Thread Tools Search this Thread Rate Thread Content Display Modes
  #1  
Old 2nd February 2006, 09: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: 44
Karma: 10
HDR has less than 100 Karma points so far.
Question MSA Excel .xls worksheet that includes GR&R (Gage R&R), Bias, Linearity, etc.

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

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

 
Registration Date: Jan 1996
Location: Olde West Chester - Southern Ohio - USA
Age: 64
 
Posts: 24,340
Thanks Given to Others: 9,898
Thanked 5,432 Times in 3,407 Posts
Blog Entries: 4
Karma Power: 400
Karma: 33302
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.
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 - Correlation does not imply Causation
We can't solve problems by using the same kind of thinking we used when we created them. - Unknown
Sponsored Links

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

 
Registration Date: Aug 2003
Location: Hilliard, Ohio, USA
Age: 50
 
Posts: 883
Thanks Given to Others: 105
Thanked 302 Times in 146 Posts
Karma Power: 141
Karma: 3663
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.
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?
  #4  
Old 1st March 2006, 11:10 PM
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: 36
Karma: 10
vishd2003 has less than 100 Karma points so far.
Gage R&R Excel Form

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

 
Registration Date: Sep 2004
Location: Ohio
 
Posts: 352
Thanks Given to Others: 18
Thanked 15 Times in 12 Posts
Karma Power: 0
Karma: 207
tarheels4 - 2007 is appreciated, and has over 200 Karma points.tarheels4 - 2007 is appreciated, and has over 200 Karma points.tarheels4 - 2007 is appreciated, and has over 200 Karma points.
Quote:
In Reply to Parent Post 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 this post, 3. Use at your Own Risk.
File Type: xls grr_KA.xls (29.0 KB, 1416 views)
Thanks to tarheels4 - 2007 for your informative Post and/or Attachment!
  #6  
Old 3rd March 2006, 02:50 AM
Howard Atkins's Avatar
Howard Atkins Howard Atkins is offline
Forum Administrator

 
Registration Date: Jul 1997
Location: Revivim, Israel
 
Posts: 2,914
Thanks Given to Others: 152
Thanked 989 Times in 508 Posts
Blog Entries: 8
Karma Power: 400
Karma: 7854
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.Howard Atkins is appreciated, and has over 1700 Karma points.
Send a message via Skype™ to Howard Atkins
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

__________________

Lean starts with your documentation
Save trees
Thanks to Howard Atkins for your informative Post and/or Attachment!
  #7  
Old 3rd March 2006, 04:13 AM
Marc's Avatar
Marc Marc is offline
Your Elsmar Cove Host

 
Registration Date: Jan 1996
Location: Olde West Chester - Southern Ohio - USA
Age: 64
 
Posts: 24,340
Thanks Given to Others: 9,898
Thanked 5,432 Times in 3,407 Posts
Blog Entries: 4
Karma Power: 400
Karma: 33302
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.
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 - Correlation does not imply Causation
We can't solve problems by using the same kind of thinking we used when we created them. - Unknown
  #8  
Old 4th March 2006, 07:08 AM
tony s's Avatar
tony s tony s is offline
Information Seeker

 
Registration Date: Sep 2003
Location: Philippines
Age: 41
 
Posts: 79
Thanks Given to Others: 91
Thanked 28 Times in 14 Posts
Karma Power: 54
Karma: 611
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.
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 this post, 3. Use at your Own Risk.
File Type: xls GRR MSA by ARK.XLS (77.0 KB, 1803 views)
File Type: xls GRR Other Form.XLS (59.5 KB, 1268 views)
File Type: xls Commingled Chart for GRR.xls (32.0 KB, 1100 views)
File Type: xls Attribute Gage Study.xls (136.0 KB, 1471 views)
Thank You to tony s for your informative Post and/or Attachment!
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

Do you find this discussion thread helpful and informational?


Bookmarks


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

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

Forum 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


Similar Discussion Threads
Discussion Thread Title Thread Starter Forum Replies Last Post or Poll Vote
MSA Tools - Excel templates for doing the Linearity & Bias, & Stability Studies Courier Excel .xls Spreadsheet Templates and Tools 13 11th June 2013 07:48 PM
Meeting the AIAG's MSA Manual Gage R&R Bias, Linearity, Stability requirements Frank45 Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 18 31st October 2012 01:43 PM
MSA 4th Edition formats in Excel wanted - GR&R, Bias, Stability and Linearity sudhaacar Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 5 14th October 2012 03:26 AM
Error in MSA Manual - Discrimination - Bias Linearity Worksheet AllenLee Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 7 6th October 2003 06: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 07:36 PM



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


   


Marc Timothy Smith - Elsmar.com
8466 LeSourdsville-West Chester Road, Olde West Chester, Ohio 45069-1929
513 341-6272
NOTE: This forum uses "cookies".