Download the WPS/PQR/WPQ cross-check matrix
XLSX
WPS/PQR/WPQ cross-check matrix (Excel)
Header block, 16 columns, Y/N/Check drop-downs, Gap rows in red and Query rows in amber, frozen header row, filters and a How to use sheet.
CSV
WPS/PQR/WPQ cross-check matrix (CSV)
The example rows as plain CSV (UTF-8), for Google Sheets or any other tool.
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
| Weld | Base material | t (mm) | Process | WPS | PQR | PQR covers | Welder / WPQ | WPQ covers | WPQ current | Result | Remarks |
|---|---|---|---|---|---|---|---|---|---|---|---|
| W1 | SA-516 Gr 70 (P-No. 1) | 25 | SAW / 1G | WPS-EX-012 Rev 1 | PQR-EX-031 | Y | WX-07 / WPQ-EX-207 | Y | Y | OK | |
| W2 | SA-516 Gr 70 (P-No. 1) | 25 | SAW / 1G | WPS-EX-012 Rev 1 | PQR-EX-031 | Y | WX-09 / WPQ-EX-209 | Y | Check | Query | Continuity record for WX-09 not on file for the weld date. |
| W3 | SA-105 to SA-516 Gr 70 (P-No. 1) | 25 | GTAW + SMAW / 2G | WPS-EX-015 Rev 0 | PQR-EX-033 | Check | WX-07 / WPQ-EX-207 | N | Y | Gap | WPS not yet approved by customer. WPQ-EX-207 covers SAW only; welder needs a GTAW/SMAW qualification. |
| W4 | A333 Gr 6 to A350 LF2 (P-No. 1) | 11 | GTAW + SMAW / 6G | WPS-EX-021 Rev 2 | PQR-EX-040 | Check | WX-12 / WPQ-EX-212 | Y | Y | Query | Low-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
| Column | What to write |
|---|---|
| Weld / joint ID | Weld number from the weld map. |
| Joint | Joint type and what it joins. |
| Base material | Material specification and grade, and the grouping number the code uses. |
| Thickness (mm) | Thickness welded. |
| Process / position | Welding process and position. |
| WPS no. / rev | The welding procedure specification assigned on the weld map. |
| WPS approved | Y, 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 joint | Y, 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 ID | Welder or operator stamp. |
| WPQ no. | The welder's performance qualification record. |
| WPQ covers process / position / range | Y, N or Check (drop-down). |
| WPQ current | Y, N or Check: the qualification is kept current as the code requires (continuity or revalidation record) on the weld date (drop-down). |
| Filler certificate | Filler material certificate or batch, where the PO asks for it. |
| Result | OK, Gap or Query (drop-down). Gap rows turn red; Query rows amber. |
| Remarks | What is missing and the action. |
How to use the template
- 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.
- Add one row per weld on the weld map, with joint, base material, thickness and process.
- Enter the WPS assigned to each weld and check it is approved where the PO requires approval.
- 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.
- 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.
- 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.
- 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.
