# Flange Bolt-Up Torque Sequence Log Worksheet

> Source: https://netray.co/tools/flange-bolt-up-torque-sequence-log-worksheet
> Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems.
> Section: Free Tools

## Short answer

Log each flanged joint with target torque and calculated pass values at 30, 60 and 100 percent. Edit rows and export to Excel.

## Category

maintenance

## Industry

Oil & Gas Equipment

## Audience

- Mechanical technician
- Commissioning engineer
- Inspector

## Tool

**Kind:** worksheet

**Mode:** editable

**Columns:**

#### Joint / flange tag

**Key:** joint

**Type:** text

#### Size and class

**Key:** size

**Type:** select

**Options:**

- 2 in 300
- 4 in 150
- 4 in 300
- 6 in 150
- 6 in 600
- 8 in 300
- 10 in 900

#### Number of bolts

**Key:** bolts

**Type:** number

#### Final target torque

**Key:** target

**Type:** number

**Unit:** ft-lb

#### Pass 1 (30%)

**Key:** pass1

**Type:** number

**Expr:** target * 0.3

**Format:** integer

**Unit:** ft-lb

#### Pass 2 (60%)

**Key:** pass2

**Type:** number

**Expr:** target * 0.6

**Format:** integer

**Unit:** ft-lb

#### Pass 3 (100%)

**Key:** pass3

**Type:** number

**Expr:** target

**Format:** integer

**Unit:** ft-lb

#### Technician

**Key:** tech

**Type:** text

#### Date

**Key:** date

**Type:** date

#### Status

**Key:** status

**Type:** select

**Options:**

- Pending
- In progress
- Complete
- Retorque required

**Rows:**

**Joint:** FL-101-A

**Size:** 6 in 150

**Bolts:** 8

**Target:** 90

**Tech:** M. Okafor

**Date:** 2026-10-19

**Status:** Complete

**Joint:** FL-101-B

**Size:** 6 in 150

**Bolts:** 8

**Target:** 90

**Tech:** M. Okafor

**Date:** 2026-10-19

**Status:** Complete

**Joint:** FL-204-A

**Size:** 4 in 300

**Bolts:** 8

**Target:** 120

**Tech:** S. Patel

**Date:** 2026-10-20

**Status:** In progress

**Joint:** FL-310-C

**Size:** 8 in 300

**Bolts:** 12

**Target:** 175

**Date:** 2026-10-21

**Status:** Pending

**Joint:** FL-402-A

**Size:** 10 in 900

**Bolts:** 20

**Target:** 450

**Date:** 2026-10-22

**Status:** Pending

**Totals:**

#### Total bolts

**Key:** bolts

**Agg:** sum

**Format:** integer

#### Joints logged

**Key:** joint

**Agg:** count

**Format:** integer

**Summary:**

#### Average bolts per joint

**Key:** avg_bolts

**Expr:** sum_bolts / count

**Format:** decimal

**Notes:** The 30, 60 and 100 percent passes follow a common star-pattern practice, often followed by a circular check pass. Always use the target torque from your approved procedure, gasket manufacturer or ASME PCC-1 calculation for the actual bolt, lubricant and gasket. The default values are examples only.

## Content

**Intro:** Bolt-up records prove each flanged joint was tightened to procedure. This worksheet lets you list joints, set a final target torque and see the staged pass values calculated automatically, then export the whole log to Excel.

**Sections:**

#### How to use this worksheet

**Body:** Add a row per flanged joint, pick the size and class, enter the number of bolts and the final target torque from your procedure. The worksheet calculates the 30, 60 and 100 percent pass values for the technician to follow. Update the technician, date and status as work progresses, then export the sheet to Excel or PDF for the commissioning dossier. Add a row note in the joint tag if a joint has a special gasket.

#### Why bolt-up uses several passes

**Body:** A flange gasket compresses unevenly when bolts are tightened to full torque in one pass, which can leave the joint prone to leakage. Industry guidance such as ASME PCC-1 describes tightening in stages using a cross or star pattern, followed by sequential circular passes until the nut stops turning at final torque. Torque is only a proxy for bolt load, so friction, lubricant and nut condition change the real preload.

**Bullets:**

- Clean threads and lubricate nut faces as per procedure
- Follow the star pattern for each pass
- Finish with a circular check pass at final torque
- Record the lubricant and torque wrench serial number

#### Common mistakes

**Body:** Using one torque value for every flange size, ignoring the lubricant's effect on the nut factor and skipping the final circular pass are the most frequent faults. Another is reusing damaged gaskets or fasteners. Compare the log to the hydrotest schedule so any joint marked as retorque is corrected before pressure is applied.

**Cta:** If bolt-up and leak test records are rekeyed from paper into your ERP or CMMS, we can help set up a private workflow that captures them once.

**Faq:**

#### Where do I get the target torque?

**Answer:** From a bolt load calculation per ASME PCC-1, the gasket manufacturer or your company procedure. It depends on bolt size, material, gasket type and lubricant, so no single table fits every joint.

#### Why 30, 60 and 100 percent?

**Answer:** It is a common staged pattern that brings the flange faces together evenly. Some procedures use different steps, such as 20, 50 and 100 percent, so change the multipliers in your procedure if needed.

#### Is torque enough to verify a joint?

**Answer:** Torque is an indirect measure. For critical joints, hydraulic tensioning or bolt stretch measurement gives better control, and a leak test confirms the result.

#### Can I export this for the customer?

**Answer:** Yes. Export to Excel or PDF from the tool. Add torque wrench calibration references and signatures in the document your customer expects.

## Search terms

flange bolt up record, flange torque log excel, bolt tightening record sheet, flange joint assembly log, pcc-1 bolt up form, torque pass table, flange make up report, bolting torque record template

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