Excel Spreadsheet to Calculate Temperature Compensation of Gage Blocks wanted

V

VP93Navy

#1
I'm trying to find an excel spreadsheet that someone might have created to calculate temperature compensation of gage blocks... I belive in not re-inventing the wheel. ;)

TIA
 
Elsmar Forum Sponsor
N

NumberCruncher

#2
Hi VP93Navy

It's not quite that simple. This is from NIST "The Gauge Block Handbook" by Ted Dorian and John Beers (page 28).

"The uncertainty in the expansion coefficient of the gauge or workpiece is more difficult to estimate.
Most steel gauge blocks under 100 mm are within a five tenths of 11.5 x 10 /oC, although there is
some variation from manufacturer to manufacturer, and even from batch to batch from the same
manufacturer. For long blocks, over 100 mm, the situation is more complicated. Steel gauge blocks
have the gauging surfaces hardened during manufacturing so that the surfaces can be properly
lapped. This hardening process affects only the 30 to 60 mm of the block near the surfaces. For
blocks under 100 mm this is the entire block, and there is no problem. For longer blocks, there is a
variable amount of the block in the center which is partially hardened or unhardened. Hardened
steel has a higher thermal expansion coefficient than unhardened steel, which means that the longer
the block the greater is the unhardened portion and the lower is the coefficient."


I interpret this as meaning, you need to calculate your own personal thermal expansion coefficients for your particular gauge block set. I expect that there is not much difference between different sets in reality. But if you are concerned, perhaps 'not much' is rather a lot.

You might find the handbook useful. It's available as a pdf from NIST. Just search on the title and names and I expect you will be able to find it.

NC
 
V

VP93Navy

#3
Agreed, not a cookie cutter type. I know I've seen a couple spreadsheets for doing this.

I have steel and ceramic sets. Was looking to ball park some numbers, I'mnot out to do an unceratinty budget yet.

just looking to get a feel for what I have.

Thanks for the reply.
 
P

Pezikon

#4
I made a table of values years ago (see attached);
(mirror) bayfiles.com/file/65o1/3iZido/gage_block_temp_change.xls

In some of the NAVAIR cal procedures (such as 17-20MD-08), it says that the average coefficient of thermal expansion for steel gage blocks is:
6.4 µin for every inch, per 1°F of change

I made the table just to get a feel for it, which is what you seemed to be interested in as well.

Doing a quick Google search i found a handy table of expansion coefficients relating to gage blocks:
http://books.google.com/books?id=eV...ficient thermal expansion gage blocks&f=false

Hope that helps.


.
 

Attachments

Last edited by a moderator:
Thread starter Similar threads Forum Replies Date
K Excel Spreadsheet Template to calculate Cmk (Machine Capability) wanted Capability, Accuracy and Stability - Processes, Machines, etc. 2
A How do we calculate the control chart by using excel .xls spreadsheet? Excel .xls Spreadsheet Templates and Tools 4
C Software or Excel .xls spreadsheet to calculate sample size and the AQL - ISO 2859-1 AQL - Acceptable Quality Level 2
S Help me build an Excel Spreadsheet for tracking training Training - Internal, External, Online and Distance Learning 14
M Preventive Maintenance Spreadsheet in Excel Quality Assurance and Compliance Software Tools and Solutions 2
T Calculating LCL, UCL, Cp, and Cpk in an Excel Spreadsheet Statistical Analysis Tools, Techniques and SPC 3
R Is there any Excel .xls Spreadsheet available for DOE with 3 factors? Six Sigma 1
kedarg6500 Excel spreadsheet for Unilateral Tolerance Study wanted Excel .xls Spreadsheet Templates and Tools 2
kedarg6500 Excel Spreadsheet for AIAG Example wanted Excel .xls Spreadsheet Templates and Tools 3
A Tracking Calibration and Qualification in an MS Excel Spreadsheet Calibration and Metrology Software and Hardware 5
S Form and Form/Record Numbering in an Excel Spreadsheet Excel .xls Spreadsheet Templates and Tools 2
J Excel spreadsheet to use Basic and Mini MOST for Line Balancing Document Control Systems, Procedures, Forms and Templates 1
B How to validate Microsoft Excel Spreadsheet Calculations for the Cpk value Capability, Accuracy and Stability - Processes, Machines, etc. 9
T Controlling an Excel Spreadsheet (Database) ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 3
Ajit Basrur How do I create two different columns in Excel spreadsheet ? Excel .xls Spreadsheet Templates and Tools 5
L Auditing Tool (Excel spreadsheet) for VDA 6.3 to Audit a Service Provider VDA Standards - Germany's Automotive Standards 4
J Excel spreadsheet for Gage R&R study with 9 appraisers Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 2
M Taguchi L4 Orthogonal Array Design of Experiments (DOE) in an Excel spreadsheet Excel .xls Spreadsheet Templates and Tools 3
F SPC Data Analysis - Excel Spreadsheet I can use for Diameters and Perpendicularity Capability, Accuracy and Stability - Processes, Machines, etc. 6
F SPC Newbie looking for Excel Spreadsheet formula for a sample size of 40 components Capability, Accuracy and Stability - Processes, Machines, etc. 8
S Strange PT Ratio on an Excel spreadsheet for variable GRR ANOVA Method Excel .xls Spreadsheet Templates and Tools 2
A Excel Spreadsheet Validation - Customer Audit Finding Other US Medical Device Regulations 2
V Calculation of PPM & Sigma Level in an Excel Spreadsheet Statistical Analysis Tools, Techniques and SPC 3
automoto Excel (xlsx) spreadsheet for conducting Type 1 MSA Analysis. Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 23
J ROI (Return on Investment) Excel Spreadsheet example Excel .xls Spreadsheet Templates and Tools 1
R Medical Device Inspection Sheets - Excel Spreadsheet Validation US Food and Drug Administration (FDA) 2
T Controlled Documents - Can a word document and excel spreadsheet be controlled? Document Control Systems, Procedures, Forms and Templates 5
R Cpk & Ppk and Differences between Minitab and an Excel Spreadsheet Results Statistical Analysis Tools, Techniques and SPC 4
S Excel Spreadsheet Conditional Formatting help needed Excel .xls Spreadsheet Templates and Tools 12
J Excel Spreadsheet Validation for Calculating Data coming from our Instruments (LIMS) General Measurement Device and Calibration Topics 3
1 Defect Tracking Excel Spreadsheet Template Excel .xls Spreadsheet Templates and Tools 2
S Excel spreadsheet shows weird CPK outcome Quality Assurance and Compliance Software Tools and Solutions 10
R Export some dates from an excel spreadsheet - EXCEL Question Excel .xls Spreadsheet Templates and Tools 3
A Gantt Chart or Excel Spreadsheet for ISO 9001 Implementation ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 3
T Do I need to validate a basic Excel spreadsheet Quality Assurance and Compliance Software Tools and Solutions 10
R Supplier Quality Rating Scorecard Template (excel spreadsheet) Supplier Quality Assurance and other Supplier Issues 4
Q Can someone share an Excel spreadsheet to measure Cpk or Cp values. Excel .xls Spreadsheet Templates and Tools 15
A Validation of an Excel Spreadsheet used for Recording Test Results Qualification and Validation (including 21 CFR Part 11) 14
kedarg6500 Process Capability for Attribute Data - Excel .xls spreadsheet wanted Capability, Accuracy and Stability - Processes, Machines, etc. 5
F ASTM F104 Callout Interpretation - .xls Excel Spreadsheet Various Other Specifications, Standards, and related Requirements 0
T Double-sided (USL, LSL) Variables sampling plan Z1.9 - Use in Excel spreadsheet? Inspection, Prints (Drawings), Testing, Sampling and Related Topics 2
J Attribute Measurement System Analysis Excel spreadsheet Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 11
J CMM Accuracy - Formula for Excel or a spreadsheet Excel .xls Spreadsheet Templates and Tools 20
M Capacity Analysis or Calculations - Excel Spreadsheet needed Excel .xls Spreadsheet Templates and Tools 3
U Excel .xls spreadsheet for Line Balancing (Time and Motion Study) needed Excel .xls Spreadsheet Templates and Tools 1
Kales Veggie Report Writer for Excel spreadsheet or CSV (Comma-Separated Values) Format Excel .xls Spreadsheet Templates and Tools 8
Stijloor APQP Process Assessment Tool - Excel .xls Spreadsheet Excel .xls Spreadsheet Templates and Tools 1
P Small Business Spreadsheet Factory - a good site for excel, word ... Excel .xls Spreadsheet Templates and Tools 4
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

Similar threads

Top Bottom