Gage R&R Excel .xls form and SPC Xbar and R template (lost it.. )

T

TownDawg

#1
Good morning.

I had a request to do a gage R & R -- well actuallly.. the R & R is done -- I just don't seem to be able to find that EXCEL spreadsheet on my laptop anywhere -- I'm thinking it's at home, but doesn't help me now. Anyone got one (a spreadsheet) set up with the formulas? The short form is fine -- patterned after the APQP workbook. I don't need the REAL one (unless you got it) -- I just didn't want to setup the entire set of formulas again -- wanted to enter this data into a spreadsheet and study the results this morning..

Post attachment or send private (and we can go from there.)
 
Last edited by a moderator:
Elsmar Forum Sponsor

Tim Folkerts

Super Moderator
#5
One option that I resort to on occasion for finding missing files is to go to "Start" "search" "For files or folders" (or whatever the equivalent is on your particular version of Word (or the equivalent on Macs, for that matter)). Then

  • under "search options" choose the type of file (Excel in this case)
  • under "containing text" type in some string of characters from that file that won't be in too many other files (perhaps "Xbar" or "SPC" but probably not "quality")
It takes quite a bit longer than searching for the title of the file, but it can often track down "lost" files. And it is the computer's time, not yours, so you can go get some coffee and then comeback to see what it found thumbup1.gif

Tim F
 
T

TownDawg

#6
* smiles *

So tru. I've done it that way as well. I'm thinking (occasionally I DO think, so don't laugh!) that I pushed that file off to my home 'puter. Maybe one will turn up. I checked the Cayman file listing -- figured since I found the 1st excel there, I might find one called Xbar and R.xls.

I found another two more Gage R & R's Excel templates; i.e., Honda's format, and Nissan's. I still lyk the partcert(6.15) one from Delphi the bestest though.

and someone has a thread in the MSA board -- basically same Q.

Gage R&R / Inspection Sheet - Example Excel Templates Attached
 

Wes Bucey

Quite Involved in Discussions
#7
Tim Folkerts said:
One option that I resort to on occasion for finding missing files is to go to "Start" "search" "For files or folders" (or whatever the equivalent is on your particular version of Word (or the equivalent on Macs, for that matter)). Then
  • under "search options" choose the type of file (Excel in this case)
  • under "containing text" type in some string of characters from that file that won't be in too many other files (perhaps "Xbar" or "SPC" but probably not "quality")
It takes quite a bit longer than searching for the title of the file, but it can often track down "lost" files. And it is the computer's time, not yours, so you can go get some coffee and then comeback to see what it found thumbup1.gif

Tim F
I note Google, Yahoo, and Mickeysoft have new desktop searchtools that work infinitely faster than the original search method described by Tim. One or more of these have the ability to even search emails, etc. all in the same search.
 
T

TownDawg

#8
Google, Yahoo, and Mickeysoft have new desktop searchtools

I know they are out there, but right now -- I don't want any more invasion of my privacy.

I already got enuff spyware trying to survive the first 24 hrs on my desktop.
 

Tim Folkerts

Super Moderator
#10
Perhaps not enough time to drive to Starbucks, but across the hall to the break room is a different matter. biggrin-a1.gif

For me, it took about 2 min to search my computer for excel files with specific word in the text, which is just about enough time to refill my cup.

(I was surprised that it still took nearly 1 minute to just search for excel files with a specific word in the title.)

Tim F
 
Thread starter Similar threads Forum Replies Date
L Good Excel .xls sheet for Gage R&R that calculates both Anova and Range Excel .xls Spreadsheet Templates and Tools 9
C Gage R&R Studies Excel .xls spreadsheet Excel .xls Spreadsheet Templates and Tools 7
A GR&R (Gage R&R) Calculation Excel .xls Spreadsheet Excel .xls Spreadsheet Templates and Tools 6
M Gage R&R Excel .xls Spreadsheet Problem Excel .xls Spreadsheet Templates and Tools 5
K Gage R & R - How to enter appraiser results into an Excel .xls spread sheet Excel .xls Spreadsheet Templates and Tools 12
M Excel .xls Template for Attribute Gage R&R with ORDINAL Data needed Excel .xls Spreadsheet Templates and Tools 10
H MSA Excel .xls worksheet that includes GR&R (Gage R&R), Bias, Linearity, etc. Excel .xls Spreadsheet Templates and Tools 15
D Gage R&R / Inspection Sheet - Example Excel .xls Templates Attached Excel .xls Spreadsheet Templates and Tools 39
S Excel .xls spreadsheet file for Gage R&R for Variable Data Excel .xls Spreadsheet Templates and Tools 6
D Gage R&R .xls spreadsheet in Excel that allows you to set up experiments Excel .xls Spreadsheet Templates and Tools 9
R Gage R&R Excel templates Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 3
D Gage Calibration Tracking in MS Excel Calibration and Metrology Software and Hardware 9
A Excel Spread Sheet for Gage R&R wanted Excel .xls Spreadsheet Templates and Tools 1
J Excel spreadsheet for Gage R&R study with 9 appraisers Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 2
V Excel Spreadsheet to Calculate Temperature Compensation of Gage Blocks wanted General Measurement Device and Calibration Topics 3
I Minitab ANOVA Gage R&R Error (vs. EXCEL ANOVA GRR Calculation) Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 5
W Type 1 Gauge (Gage) R&R Excel Template anyone? Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 21
automoto Gage R&R Form in Excel for Calculating Gauge R&R - Attached Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 73
F Updated Gage R&R Excel Forms Excel .xls Spreadsheet Templates and Tools 7
J Type 1 Gage Study Excel Template Excel .xls Spreadsheet Templates and Tools 5
S Gage R&R Excel Format For Entering The Data - 3rd Edition needed Excel .xls Spreadsheet Templates and Tools 3
C Excel spreadsheet containing Gage R&R with Anova Method wanted Excel .xls Spreadsheet Templates and Tools 22
I Gage R&R Form - Excel or other - Calculations Questions Excel .xls Spreadsheet Templates and Tools 13
T Plug Gage Calibration Calibration and Metrology Software and Hardware 1
L Gage R&R TMV Acceptance Criteria Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 4
S MSA for attribute relation gage Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 2
E Zero part to part variation - Gage R&R project Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 15
M Gage R&R and right way to measure Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 16
L Gage RandR on automated equipment. IATF 16949 - Automotive Quality Systems Standard 7
B Gage calibration frequency, ISO and IATF - What are the requirements Calibration Frequency (Interval) 3
D Difference between Test Method Validation and Gage R&R Qualification and Validation (including 21 CFR Part 11) 18
R Determining Uncertainty from Gage R&R Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 1
C Correct Calibration Method for Dial Depth Gage General Measurement Device and Calibration Topics 6
C Gage Block Wringing General Measurement Device and Calibration Topics 3
B Gage R&R with NDC=1 Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 19
S Type 1 Gage R&R or something else? Reliability Analysis - Predictions, Testing and Standards 6
G Should I perform Gage R&R only at the beginning of a new project? Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 6
V Thread Plug Gage Pitch GO Diameter out of spec AQL - Acceptable Quality Level 8
G Gage R&R - Where am I going wrong? Part of a FAIR submission (Aerospace) Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 2
K Gage R&R with more than 3 appraisers Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 2
Anerol C Gage R&R Template AIAG 4th Edition IATF 16949 - Automotive Quality Systems Standard 3
T Attributes SPC study - Attributive control (Go gage) Statistical Analysis Tools, Techniques and SPC 5
S Capability or Gage R&R Study for Leak Tester? Reliability Analysis - Predictions, Testing and Standards 15
N % Tolerance - Type 1 study on the gages, then a gage R&R (ANOVA) Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 4
M Definitive answer on Type 1 vs Type 2 vs Type 3 Gage Study Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 0
V Gage Management and Gage R&R Software General Measurement Device and Calibration Topics 1
D Gage R&R Study on Load Cells - Large chemical blending tanks IATF 16949 - Automotive Quality Systems Standard 1
B Minitab Type 1 Gage Study on True Position Question Measurement Uncertainty (MU) 1
S Gage R&R on alloy Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 10
8 Need Help - Runout - Function Gage Inspection, Prints (Drawings), Testing, Sampling and Related Topics 7

Similar threads

Top Bottom