# Coating Dry Film Thickness (DFT) Measurement Log Worksheet

> Source: https://netray.co/tools/coating-dry-film-thickness-measurement-log-worksheet
> Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems.
> Section: Free Tools

## Short answer

Log DFT readings per spot, auto-calculate the average and minimum, and see the margin to the specified minimum thickness. Exports to Excel.

## Category

quality

## Industry

Oil & Gas Equipment

## Audience

- Coating inspector
- Quality engineer
- Painting supervisor

## Tool

**Kind:** worksheet

**Mode:** editable

**Columns:**

#### Item / area

**Key:** item

**Type:** text

#### Coat

**Key:** coat

**Type:** select

**Options:**

- Primer
- Intermediate
- Topcoat
- Total system

#### Specified minimum

**Key:** spec_min

**Type:** number

**Unit:** um

#### Reading 1

**Key:** r1

**Type:** number

**Unit:** um

#### Reading 2

**Key:** r2

**Type:** number

**Unit:** um

#### Reading 3

**Key:** r3

**Type:** number

**Unit:** um

#### Spot average

**Key:** avg

**Type:** number

**Expr:** (r1 + r2 + r3) / 3

**Format:** decimal

**Unit:** um

#### Lowest reading

**Key:** low

**Type:** number

**Expr:** min(r1, min(r2, r3))

**Format:** integer

**Unit:** um

#### Margin to spec

**Key:** margin

**Type:** number

**Expr:** avg - spec_min

**Format:** decimal

**Unit:** um

#### Date

**Key:** date

**Type:** date

**Rows:**

**Item:** Separator skid base frame

**Coat:** Primer

**Spec min:** 60

**R1:** 72

**R2:** 68

**R3:** 75

**Date:** 2026-10-19

**Item:** Separator skid base frame

**Coat:** Total system

**Spec min:** 240

**R1:** 262

**R2:** 255

**R3:** 270

**Date:** 2026-10-20

**Item:** Vessel shell, 3 o'clock

**Coat:** Total system

**Spec min:** 240

**R1:** 238

**R2:** 245

**R3:** 251

**Date:** 2026-10-20

**Item:** Pipe spool PS-114

**Coat:** Intermediate

**Spec min:** 125

**R1:** 140

**R2:** 132

**R3:** 128

**Date:** 2026-10-21

**Item:** Pipe spool PS-115

**Coat:** Topcoat

**Spec min:** 50

**R1:** 46

**R2:** 55

**R3:** 52

**Date:** 2026-10-21

**Totals:**

#### Spots logged

**Key:** spec_min

**Agg:** count

**Format:** integer

#### Worst margin to spec

**Key:** margin

**Agg:** min

**Format:** decimal

#### Average of spot averages

**Key:** avg

**Agg:** avg

**Format:** decimal

**Notes:** Units are micrometers (um); 1 mil is 25.4 um. A spot is commonly the average of several gauge readings, and SSPC-PA 2 style practice takes five spots per 100 square feet of area, but your project specification controls the plan and the acceptance limits. A low individual reading may still be rejected even when the average passes.

## Content

**Intro:** Dry film thickness records are among the most frequently asked-for documents when pipe, vessels and skids are coated. This worksheet calculates the average, lowest reading and margin to the specification for each spot, then exports the log.

**Sections:**

#### How to use this worksheet

**Body:** Enter the item or area, the coat, and the minimum DFT from the coating specification. Type the three gauge readings for each spot. The sheet calculates the spot average, the lowest reading and the margin between the average and the specified minimum. A negative margin means the average is below specification and the coating needs recoating or additional film. Export to Excel for the inspection report or to PDF for the data book.

#### Measurement practice

**Body:** Magnetic and eddy current gauges must be calibrated on a reference plate with a shim near the expected thickness, and the readings taken on a surface profile that is accounted for. Common standards such as SSPC-PA 2 and ISO 19840 describe how to take spot and area measurements and how to treat individual low readings. Projects often allow a limited percentage of readings below the minimum, but only within a stated floor, so read the specification closely.

**Bullets:**

- Calibrate the gauge before each shift
- Account for blast profile on bare steel
- Take readings away from edges and welds unless specified
- Record gauge serial number and calibration reference

#### Common mistakes

**Body:** Typical errors include measuring wet film and reporting it as dry, averaging across different coats and not recording the gauge calibration. Another is checking only the average and ignoring individual readings that fall below the specification floor. Keep the primer, intermediate and topcoat rows separate so each layer's thickness can be traced, and add a total system row after the final coat.

**Cta:** If coating inspection results are collected on paper and rekeyed, we can help build a private workflow that captures readings once and feeds the quality record in your ERP.

**Faq:**

#### Does a passing average mean the coating is accepted?

**Answer:** Not always. Many specifications limit individual readings as well as the average, for example no reading below a stated percentage of the minimum. The worksheet shows the lowest reading so you can compare against that rule.

#### How many readings per spot?

**Answer:** Practice varies. SSPC-PA 2 style methods average a few gauge readings per spot, and ISO 19840 uses its own rules. Use your project's method and edit the readings columns if you need more.

#### Can I use mils instead of micrometers?

**Answer:** Yes. Enter the values in mils consistently for all columns, or convert by multiplying mils by 25.4 to get micrometers. The calculations work in any unit as long as you do not mix them.

#### Is wet film measurement acceptable?

**Answer:** Wet film readings guide application but do not replace the dry film inspection after curing. Record DFT after the coating has cured according to the paint data sheet.

## Search terms

dft log excel, dry film thickness report template, coating inspection record, paint dft measurement sheet, sspc pa 2 dft record, coating inspection report oil and gas, dft reading log, paint inspection report format

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