# Lathe Tool Offset Record Worksheet

> Source: https://netray.co/tools/lathe-tool-offset-record-worksheet
> Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems.
> Section: Free Tools

## Short answer

Keep a written record of geometry and wear offsets per turret station so you can rebuild a setup or spot tools that drift.

## Category

mes-shop-floor

## Industry

Machining

## Audience

- Machinist
- CNC operator
- Setup technician

## Tool

**Kind:** worksheet

**Mode:** editable

**Columns:**

#### Station

**Key:** station

**Type:** text

#### Tool / insert

**Key:** tool

**Type:** text

#### Operation

**Key:** op

**Type:** select

**Options:**

- Rough OD
- Finish OD
- Rough ID
- Finish ID
- Groove
- Thread
- Drill
- Part off

#### Geometry X

**Key:** geo_x

**Type:** number

**Unit:** in

#### Geometry Z

**Key:** geo_z

**Type:** number

**Unit:** in

#### Wear X

**Key:** wear_x

**Type:** number

**Unit:** in

#### Wear Z

**Key:** wear_z

**Type:** number

**Unit:** in

#### Total X wear

**Key:** wear_total

**Type:** number

**Expr:** abs(wear_x)

**Format:** decimal

**Unit:** in

#### Nose radius

**Key:** nose

**Type:** number

**Unit:** in

#### Last checked

**Key:** checked

**Type:** date

**Rows:**

**Station:** T0101

**Tool:** CNMG 432 rough

**Op:** Rough OD

**Geo x:** -8.2145

**Geo z:** -11.4302

**Wear x:** 0

**Wear z:** 0

**Nose:** 0.0312

**Checked:** 2026-10-19

**Station:** T0202

**Tool:** VNMG 331 finish

**Op:** Finish OD

**Geo x:** -7.9871

**Geo z:** -11.2218

**Wear x:** 0.0008

**Wear z:** -0.0005

**Nose:** 0.0156

**Checked:** 2026-10-19

**Station:** T0303

**Tool:** Groove 0.125 wide

**Op:** Groove

**Geo x:** -8.4012

**Geo z:** -10.9987

**Wear x:** -0.0015

**Wear z:** 0

**Nose:** 0

**Checked:** 2026-10-19

**Station:** T0404

**Tool:** 60 degree threading

**Op:** Thread

**Geo x:** -8.1033

**Geo z:** -11.064

**Wear x:** 0

**Wear z:** 0

**Nose:** 0

**Checked:** 2026-10-18

**Station:** T0505

**Tool:** 0.375 drill

**Op:** Drill

**Geo x:** 0

**Geo z:** -14.7761

**Wear x:** 0

**Wear z:** 0

**Nose:** 0

**Checked:** 2026-10-18

**Totals:**

#### Largest X wear to review

**Key:** wear_total

**Agg:** max

**Format:** decimal

#### Tools recorded

**Key:** station

**Agg:** count

**Format:** integer

**Notes:** Example values are placeholders; do not copy offsets between machines. Record the sign convention your control uses, and note whether X is diameter or radius so the next person reads the values correctly.

## Content

**Intro:** When a crash or power loss wipes offsets, the worksheet is what gets the lathe running again. Use it to keep geometry and wear offsets per station, together with the tool and operation they belong to.

**Sections:**

#### How to use the worksheet

**Body:** After setting each tool, add a row with the station, the tool description, geometry offsets in X and Z, and the nose radius used for compensation. During production, update the wear columns whenever you adjust size. The sheet shows the largest wear value so you can see which tool is drifting and decide whether it is time to change the edge instead of nudging offsets again.

#### Geometry versus wear offsets

**Body:** Geometry offsets locate the tool tip relative to the machine or part zero and rarely change once set. Wear offsets hold the small corrections made during a run to hold size. Keeping them separate lets you reset wear to zero on a new edge while preserving the geometry. If your control combines both in one register, record the starting value and the changes over time instead.

#### Using the record in practice

**Body:** Print the record and keep it at the machine. Compare today's values against the previous setup for the same program: large differences in geometry hint at a changed holder or a mis-set tool. A steady rise in wear X on a finish tool is a sign that the insert is wearing, not that the offset needs more adjusting. Date the entries so an auditor or the next shift can follow the history.

#### Common mistakes

**Body:** Do not mix radius and diameter programming conventions between machines. Do not forget the nose radius compensation value and the tip orientation, since both affect the finished profile. Avoid storing offsets only on the control, because batteries fail and operators clear registers. Finally, note any tool that is shared between jobs, and verify its offset before each run.

**Cta:** If you manage tool data in an ERP or MES, Netray can help connect it to the shop floor so offset records are not kept on paper alone.

**Faq:**

#### What is the difference between geometry and wear offset?

**Answer:** Geometry offsets locate the tool to the machine reference and are set during tool setting. Wear offsets are small adjustments applied on top to hold the part size as the insert wears. Splitting them makes resets after an edge change simple.

#### Should wear offsets be reset on a new insert?

**Answer:** Usually yes, then verify with a trial cut and adjust. Some shops keep a small starting wear value for repeatability. Record whatever you do on the sheet so the practice is consistent between shifts.

#### How large a wear offset is too large?

**Answer:** It depends on the tolerance. As a working rule, if you need to move wear offsets by more than a fraction of the tolerance band over a short run, investigate the tool, the insert or thermal growth before adjusting further.

#### Can this replace tool presetter data?

**Answer:** It complements it. A presetter gives measured tool lengths and diameters, and the sheet records what ended up on the control after the cutting trial. Keep both for traceability.

## Search terms

lathe tool offset sheet, cnc lathe offset record, tool geometry offset log, wear offset tracking, tool offset worksheet excel, cnc turning offsets record, lathe tool setting sheet

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