# Hole and Shaft Fit Clearance Worksheet

> Source: https://netray.co/tools/hole-shaft-fit-clearance-worksheet
> Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems.
> Section: Free Tools

## Short answer

An editable worksheet that computes minimum and maximum clearance (negative means interference) for each hole and shaft pair from their limit sizes.

## Category

engineering-plm

## Industry

Discrete Manufacturing

## Audience

- Design engineer
- Manufacturing engineer

## Tool

**Kind:** worksheet

**Mode:** editable

**Columns:**

#### Assembly or joint

**Key:** assembly

**Type:** text

#### Fit designation

**Key:** fit

**Type:** text

#### Hole min

**Key:** hole_min

**Type:** number

**Unit:** mm

**Format:** decimal

#### Hole max

**Key:** hole_max

**Type:** number

**Unit:** mm

**Format:** decimal

#### Shaft min

**Key:** shaft_min

**Type:** number

**Unit:** mm

**Format:** decimal

#### Shaft max

**Key:** shaft_max

**Type:** number

**Unit:** mm

**Format:** decimal

#### Min clearance (negative = interference)

**Key:** min_clr

**Type:** number

**Expr:** hole_min - shaft_max

**Format:** decimal

**Unit:** mm

#### Max clearance (negative = interference)

**Key:** max_clr

**Type:** number

**Expr:** hole_max - shaft_min

**Format:** decimal

**Unit:** mm

#### Fit variation

**Key:** variation

**Type:** number

**Expr:** max_clr - min_clr

**Format:** decimal

**Unit:** mm

**Rows:**

**Assembly:** Gear on shaft, running

**Fit:** 25 H7/g6

**Hole min:** 25

**Hole max:** 25.021

**Shaft min:** 24.98

**Shaft max:** 24.993

**Assembly:** Bearing seat, sliding

**Fit:** 20 H8/f7

**Hole min:** 20

**Hole max:** 20.033

**Shaft min:** 19.959

**Shaft max:** 19.98

**Assembly:** Dowel pin, press

**Fit:** 12 H7/p6

**Hole min:** 12

**Hole max:** 12.018

**Shaft min:** 12.018

**Shaft max:** 12.029

**Assembly:** Pulley hub, transition

**Fit:** 40 H7/k6

**Hole min:** 40

**Hole max:** 40.025

**Shaft min:** 40.002

**Shaft max:** 40.018

**Totals:**

#### Smallest minimum clearance

**Key:** min_clr

**Agg:** min

**Format:** decimal

#### Largest maximum clearance

**Key:** max_clr

**Agg:** max

**Format:** decimal

**Notes:** Enter limit sizes from your drawing or from the ISO 286 / ASME B4.1 tables. Positive clearance means a gap, negative means interference. A row with min negative and max positive is a transition fit.

## Content

**Intro:** Every fit callout reduces to four limit sizes. This worksheet turns them into minimum and maximum clearance so you can see at a glance whether a joint is a clearance, transition or interference fit, and how much it varies.

**Sections:**

#### How to use the worksheet

**Body:** Add one row per joint. Enter the smallest and largest hole size and the smallest and largest shaft size in millimetres. The sheet calculates minimum clearance as hole minimum minus shaft maximum, and maximum clearance as hole maximum minus shaft minimum. Edit the examples, add rows for your assemblies and export to Excel for the design record.

#### Reading the result

**Body:** If both clearances are positive the fit always leaves a gap. If both are negative the parts always interfere, so assembly needs force, heat or cooling. If one is negative and one positive, some assemblies will interfere and some will not. The fit variation equals the hole tolerance plus the shaft tolerance, so tightening either one narrows the spread.

**Bullets:**

- Both positive: clearance fit
- Min negative, max positive: transition fit
- Both negative: interference fit
- Variation = hole tolerance + shaft tolerance

#### Common mistakes

**Body:** Mixing up which size pairs with which is the classic error: minimum clearance uses the smallest hole against the largest shaft. Another is ignoring coatings or plating thickness, which shifts the shaft size after finish. Use the post-finish limits for the final fit check, and check the temperature if the parts are different materials.

**Cta:** If fit and tolerance data lives in spreadsheets outside the ERP, we can talk about connecting characteristics to item and routing records.

**Faq:**

#### What does negative clearance mean?

**Answer:** Negative clearance is interference: the shaft is larger than the hole. The amount shows how much material must deform or how much force or thermal change is needed to assemble the parts.

#### Where do I get the limit sizes for H7/g6?

**Answer:** From the ISO 286 tables or ASME B4.1 for inch fits, based on the nominal size. Enter the resulting hole and shaft limits here. The examples use ISO 286 values for the stated sizes.

#### Does this account for surface finish or form error?

**Answer:** No. It uses size limits only. Surface roughness, out-of-roundness and taper reduce the effective clearance or change the interference, so leave margin for them on precision fits.

#### Can I use inches?

**Answer:** Yes. The maths is unit independent. Enter all values in inches and ignore the mm label, or convert first.

## Search terms

hole shaft fit worksheet, clearance fit calculator excel, interference fit worksheet, min max clearance calculation, limits and fits spreadsheet, h7 g6 fit clearance, shaft hole tolerance table excel

---
Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json