WeldTrack Pro — Welding & Fabrication Progress Tracker (Excel Template)

Stop tracking weld joints in three different places.

WeldTrack Pro is a self-contained Excel workbook that takes a piping or

structural fabrication job from "joint registered" all the way through

Fitup → Root Weld → Fill Weld → Cap Weld → VT → RT → PWHT → Hydrotest —

with the dashboard updating itself as your team logs daily progress.

No add-ins. No macros. No broken links to external files. Just open it

and start registering joints.

WHAT'S INCLUDED (6 connected tabs)

✔ Master Joint Register

 Register every joint once — Project, Area, Line No, Spool No, Joint No,

 Joint Type, Diameter, Material, Inch-Dia, Priority. Dropdown-driven so

 there's no free-typing inconsistency to clean up later.

✔ Daily Progress Entry

 One row per Joint per Activity per Day. Built-in duplicate-entry warning

 stops the same joint/activity/day being logged twice.

✔ Manpower Log

 Daily headcount per project/area/shift. Man-hours and totals calculate

 automatically.

✔ Live Dashboard

 Total joints, stage-wise completed/pending, % complete by stage,

 today's activity, this month's man-hours, inch-dia welded, inch-dia

 per welder-day, MH per joint welded — all formula-driven, all live.

✔ Lookup Tables

 Every dropdown list (Projects, Areas, Activities, Joint Types,

 Materials, Priority, Diameter) lives on one tab — add your own

 projects in seconds.

✔ Supervisor Field Form

 A clean, printable one-pager for site supervisors who fill progress by

 hand before it's entered into the system.

WHO IT'S FOR

Planning/project controls engineers, QA/QC inspectors, fabrication

supervisors and site engineers on piping, structural steel, or shutdown

and turnaround projects who need a single source of truth for joint

status without paying for a heavyweight QA/QC software license.

HOW IT WORKS

Status columns (Fitup, Root Weld, Fill Weld, Cap Weld, VT, RT, PWHT,

Hydrotest) read directly from your Daily Progress entries — log an

activity once and every dependent status, KPI and dashboard metric

updates on its own. Overall % per joint is weighted by stage (Fitup 20%,

Root Weld 20%, Fill Weld 15%, Cap Weld 15%, VT 10%, RT 10%, PWHT 5%,

Hydrotest 5%) — fully editable if your weighting differs.

WHAT'S NOT INCLUDED

This is a tracking and reporting tool, not a full QA/QC management

system — it doesn't handle NDT report uploads, welder qualification

records, or WPS/PQR management.

COMPATIBILITY

Microsoft Excel 2016+ (Windows/Mac) and Google Sheets (dropdown lists

display as standard data validation on import).

Pre-loaded with 60 sample joints and ~290 sample progress entries so you

can see every formula working before you delete the sample rows and

start entering your own project.

Q: Does this need any add-ins or macros?

A: No. Everything is built with native Excel formulas and dropdown data

  validation — no VBA, no Power Query, no third-party add-ins.

Q: Will it work in Google Sheets?

A: Yes, after uploading/converting. Dropdown lists and conditional

  formatting carry over; double-check formulas referencing whole

  columns if your sheet is very large.

Q: Can I add my own Projects, Materials or Joint Types?

A: Yes — everything lives in the 05_Lookups tab. Add a row, and it

  appears in the dropdowns immediately.

Q: How many joints can it handle?

A: Out of the box, formulas and dropdowns are pre-filled through row

  1000 in the Master Joint Register (and row 1000+ in Daily Progress) —

  thousands of joints and tens of thousands of daily entries without

  any extra setup.