OdysseyGPT

Free template

WPS, PQR and WPQ cross-check matrix template (Excel and CSV)

Weld by weld: is the welding procedure approved, does its PQR cover the joint, and is the welder qualified and current?

By Ademola Afolabi, Founder, New Odyssey Ltd · Last reviewed:

The short answer

A WPS/PQR/WPQ cross-check matrix takes each weld on the weld map and records whether its welding procedure (WPS) is approved, whether the supporting procedure qualification record (PQR) covers the joint, and whether the welder's qualification (WPQ) covers the work and is current. This free Excel template records the check; the code you weld to sets the ranges.

Key Takeaways

  • One row per weld on the weld map, not one row per procedure.
  • Qualification ranges come from the code named in the PO; the matrix records the check, it does not compute ranges.
  • Check welder qualifications are current on the weld date.
  • A qualified welding engineer or coordinator signs off the matrix.

Download the WPS/PQR/WPQ cross-check matrix

Both files are free under CC BY 4.0, with no form to fill in. The XLSX opens in Excel, Google Sheets, LibreOffice and Numbers. The CSV carries the table only; the header block is in the XLSX.

What it is for and who uses it

Customers and inspectors check welding documents weld by weld: the weld map points to a WPS, the WPS rests on one or more PQRs, and each welder needs a qualification that covers the work. A gap found at the record book stage can mean repeat qualification or a concession. The matrix finds it before the weld is made.

  • Welding coordinators and welding engineers.
  • Quality engineers preparing for inspection.
  • Document controllers filing welding records in the record book.

Example rows: vessel and spool welds

Invented example rows for PO-EX-4410 (some columns omitted)
WeldBase materialt (mm)ProcessWPSPQRPQR coversWelder / WPQWPQ coversWPQ currentResultRemarks
W1SA-516 Gr 70 (P-No. 1)25SAW / 1GWPS-EX-012 Rev 1PQR-EX-031YWX-07 / WPQ-EX-207YYOK
W2SA-516 Gr 70 (P-No. 1)25SAW / 1GWPS-EX-012 Rev 1PQR-EX-031YWX-09 / WPQ-EX-209YCheckQueryContinuity record for WX-09 not on file for the weld date.
W3SA-105 to SA-516 Gr 70 (P-No. 1)25GTAW + SMAW / 2GWPS-EX-015 Rev 0PQR-EX-033CheckWX-07 / WPQ-EX-207NYGapWPS not yet approved by customer. WPQ-EX-207 covers SAW only; welder needs a GTAW/SMAW qualification.
W4A333 Gr 6 to A350 LF2 (P-No. 1)11GTAW + SMAW / 6GWPS-EX-021 Rev 2PQR-EX-040CheckWX-12 / WPQ-EX-212YYQueryLow-temperature service: confirm the PQR includes impact tests at the required temperature.

The file also has columns for joint, WPS approval and filler certificate. Every example value is invented: the project, customer, purchase order and every document, certificate, heat and report number do not exist. Standards are named but not quoted.

Columns and what to write

ColumnWhat to write
Weld / joint IDWeld number from the weld map.
JointJoint type and what it joins.
Base materialMaterial specification and grade, and the grouping number the code uses.
Thickness (mm)Thickness welded.
Process / positionWelding process and position.
WPS no. / revThe welding procedure specification assigned on the weld map.
WPS approvedY, N or Check: approved by the customer where the PO requires it (drop-down).
Supporting PQR(s)The procedure qualification record(s) the WPS cites.
PQR range covers jointY, N or Check: the material, thickness and other variables of the joint fall inside the range the PQR qualifies, as the code defines it (drop-down).
Welder IDWelder or operator stamp.
WPQ no.The welder's performance qualification record.
WPQ covers process / position / rangeY, N or Check (drop-down).
WPQ currentY, N or Check: the qualification is kept current as the code requires (continuity or revalidation record) on the weld date (drop-down).
Filler certificateFiller material certificate or batch, where the PO asks for it.
ResultOK, Gap or Query (drop-down). Gap rows turn red; Query rows amber.
RemarksWhat is missing and the action.

How to use the template

  1. Fill in the header with the welding code the PO names and the weld map revision. Qualification ranges come from that code; the matrix records the check, it does not work out the ranges.
  2. Add one row per weld on the weld map, with joint, base material, thickness and process.
  3. Enter the WPS assigned to each weld and check it is approved where the PO requires approval.
  4. List the PQR(s) behind each WPS and check, against the code, that the joint's variables fall inside what the PQR qualifies. Mark Check where you are not sure.
  5. For each welder, enter the WPQ and check it covers the process, position and range used, and that it is current on the weld date.
  6. Set the result. Gap rows turn red and Query rows amber. Close each one before the weld is made, or before the record book is issued if it was already made.
  7. Ask a qualified welding engineer or coordinator to sign off the matrix. It supports their review; it does not replace it.

Checking welding records from the documents

In OdysseyGPT's Manufacturing QA module, Welding Qualification Review (beta) reads the weld map, WPSs, PQRs and welder qualifications and flags the welds whose records do not line up. Every finding cites the page it came from, and your engineers decide what to do with it. These tools are in beta: you can request access, and we onboard each team ourselves.

Want us to run the check for you?

Send up to 20 material certificates and the purchase order. We send back a certificate check report, each finding cited to its page.

Get the free certificate check

New templates by email (optional)

Your download does not depend on this.

We use your email only for this. See our privacy policy.

Frequently asked questions

What is the difference between a WPS, a PQR and a WPQ?

A WPS is the written procedure the welder follows. A PQR records the test weld that qualified it, and the WPS must stay inside what the PQR covers. A WPQ records that a particular welder is qualified for a process, position and range.

Is there a free WPS/PQR/WPQ matrix template in Excel?

Yes. This XLSX template has a blank matrix, a filled-in example with invented welds and a How to use sheet, with Y/N/Check drop-downs. A CSV of the same columns is also free under CC BY 4.0.

References

Creative Commons Attribution 4.0 International

Creative Commons

Visit source

Related Pages