OdysseyGPT

Free template

URS template: a response matrix for user requirement specifications (Excel and CSV)

For pharmaceutical and bioprocess equipment suppliers: one row per URS requirement, with your response, a status, the document that supports it and where it will be verified.

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

The short answer

A URS response matrix is the supplier's point-by-point answer to a user requirement specification. This free Excel template has one row per requirement: URS ID, requirement text, category, must or want, your response, a status, your reference document and the stage where it will be verified, from DQ and FAT to SAT, IQ and OQ.

Key Takeaways

  • Keep the customer's URS IDs and copy each requirement word for word.
  • Every status needs a reference document. A status with no reference is a claim the customer cannot check.
  • Deviates and Clarification rows go into your deviation and clarification lists, with the item number in Remarks.
  • The example has 15 rows for an invented URS (URS-EX-5120) for a stainless process vessel skid.

Download the URS response 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

A user requirement specification (URS) is the customer's numbered list of what the equipment must do. Most enquiries ask the supplier to answer it point by point, and the answer later becomes the starting point for design qualification and the traceability matrix. This template is that answer. It follows the same idea as the general compliance matrix template, with the columns a URS needs: must or want, and where each requirement will be verified.

  • Proposal and sales engineers at equipment suppliers, who answer the URS in the offer.
  • Validation and quality engineers, who check that every requirement has a verification stage.
  • Customers writing a URS, who can use the first four columns as the requirement list and send the rest for suppliers to fill in.

If the customer supplies its own response form, copy your rows into that form. See also pharmaceutical equipment manufacturers.

Header block

Header block fields, with the invented example values
FieldExample
ProjectExample Biologics Facility, Suite 2 (fictional)
CustomerExample Pharma Ltd (fictional)
URS no. and revisionURS-EX-5120 Rev 2 (fictional)
EquipmentStainless steel process vessel skid, 500 L (fictional)
SupplierExample Process Equipment Ltd (fictional)
Quotation no.Q-EX-5120 Rev A
Matrix no.URM-EX-5120
RevisionA
Date2027-01-18
Prepared byProposal engineer
Checked byValidation engineer

Example rows: a URS for a stainless process vessel skid

Invented example rows for URS-EX-5120
URS IDRequirementCategoryMust / wantSupplier responseStatusReference documentVerified atRemarks
URS-001The vessel shall have a working volume of 500 L and a minimum working volume of 100 L.ProcessMust500 L working volume; minimum stirred volume 90 L.CompliesDS-EX-5120 Rev A, line 4DQ; IQ
URS-002The vessel and jacket shall be designed for the pressures and temperatures in URS table 2, including full vacuum.ProcessMustDesign conditions as URS table 2.CompliesDS-EX-5120 Rev A, lines 7 to 10; GA-EX-5120 Rev ADQ; IQ
URS-003The skid shall be cleaned in place (CIP) and steamed in place (SIP) without dismantling.ProcessMustCIP by spray ball; SIP through the vessel and the sterile boundary valves.ClarificationPID-EX-5120 Rev AFAT; OQCustomer to confirm CIP supply flow and pressure at the skid inlet. Clarification C-01.
URS-004The agitator speed shall be adjustable from 20 to 200 rpm.ProcessWantAdjustable from 30 to 250 rpm with the offered drive.DeviatesDS-EX-5120 Rev A, line 15FAT; OQLower limit is 30 rpm. Deviation D-01.
URS-005Product-contact metal parts shall be 316L stainless steel, with material certificates of the type the URS names.Materials and surface finishMust316L for all product-contact metal parts; certificates as requested.CompliesBOM-EX-5120 Rev ADQ; IQ
URS-006Product-contact surfaces shall be finished to 0.5 micrometres Ra or better and electropolished.Materials and surface finishMustMechanically polished to 0.5 micrometres Ra. Electropolishing is not in the base offer.DeviatesQ-EX-5120 Rev A, section 3.2FAT; IQElectropolishing offered as a priced option. Deviation D-02.
URS-007Elastomers in product contact shall carry the compliance certificates listed in URS section 6.Materials and surface finishMustEPDM and PTFE seals, with the certificates listed.CompliesSeal list SL-EX-5120 Rev AIQ
URS-008The control system shall keep an audit trail and electronic records that meet the customer's data integrity policy DI-EX-01.AutomationMustSupplier's standard audit trail and user management offered.ClarificationFS-EX-5120 Rev 0, section 8DQ; FAT; OQPolicy DI-EX-01 was not in the enquiry. Clarification C-02.
URS-009Alarms shall be raised for high temperature, high pressure and agitator fault, and logged with time and user.AutomationMustAlarms as listed, logged with time stamp and user.CompliesAlarm list AL-EX-5120 Rev 0FAT; OQ
URS-010The skid shall send batch data to the site historian.AutomationWantNot addressedNot covered in Q-EX-5120. Answer before the offer is issued.
URS-011The supplier shall deliver a functional specification, design specification, P&ID, material certificates, weld documentation and calibration certificates in the turnover package.DocumentationMustAll listed documents included. Weld documentation covers product-contact welds: weld map, weld log and inspection records.CompliesDocument list DL-EX-5120 Rev ADQ; IQ
URS-012The supplier shall provide IQ and OQ protocols for the customer's approval before they are executed.DocumentationMustIQ and OQ protocols included, in the supplier's standard format.ClarificationQ-EX-5120 Rev A, section 5IQ; OQCustomer to confirm the supplier's protocol format is acceptable. Clarification C-03.
URS-013A factory acceptance test (FAT) shall be run to an approved protocol and witnessed by the customer.TestingMustFAT to a protocol issued for the customer's approval before the test.CompliesQ-EX-5120 Rev A, section 6FAT
URS-014Spray coverage of the vessel interior shall be demonstrated at the FAT.TestingMustCoverage test included in the FAT.CompliesQ-EX-5120 Rev A, section 6FAT
URS-015The supplier shall carry out a site acceptance test (SAT) after installation, repeating the loop checks and alarm tests.TestingMustSAT support quoted at a day rate; not in the fixed price.DeviatesQ-EX-5120 Rev A, section 7SATDeviation D-03.

Three rows deviate, three need a clarification and one is not yet addressed. The requirement values are the invented customer's own and are not taken from any standard or guideline. Every example value is invented: the project, customer, bidders, purchase order, prices and every document, certificate, serial and report number do not exist. Standards are named but not quoted.

Status values

StatusUse it when
CompliesThe offer meets the requirement as written. Point to the document and line that shows it.
DeviatesThe offer does not meet the requirement as written. Say what is offered instead and carry the item into the deviation list.
ClarificationThe requirement is unclear, depends on information the customer has not sent, or is met in a different way that the customer should confirm.
Not addressedThe offer does not yet answer the requirement. Every such row needs an answer before the offer goes out.

Where each requirement is verified

StageCommon meaning
DQ (design qualification)Documented check that the proposed design meets the URS, usually by reviewing specifications and drawings.
FAT (factory acceptance test)Tests at the supplier's works before shipment.
SAT (site acceptance test)Tests at the customer's site after installation.
IQ (installation qualification)Documented check that the equipment is installed as specified.
OQ (operational qualification)Documented check that the equipment operates as specified across its operating ranges.

These are common meanings. The customer's validation plan and the contract decide which stages apply and who runs them, so agree the split before you fill in the column. Performance qualification (PQ) is usually run by the customer on its own process, so the template leaves it out; add it if your contract covers it. See IQ, OQ and PQ and FAT vs SAT.

Columns and what to write

ColumnWhat to write
URS IDThe requirement's own number in the URS. Do not renumber.
Requirement (verbatim)The requirement text, copied word for word. One requirement per row; split a paragraph that holds several.
CategoryProcess, Materials and surface finish, Automation, Documentation or Testing (drop-down).
Must / wantMust or Want, as the URS marks it (drop-down). Use the customer's own classes if the URS defines others.
Supplier responseWhat you offer against this requirement, in one or two lines.
StatusComplies, Deviates, Clarification or Not addressed (drop-down). Deviates rows turn red, Clarification amber, Not addressed grey.
Supplier reference documentThe document, revision and line that supports the response: datasheet, P&ID, functional specification, quotation section.
Verified atThe stage or stages where the requirement will be verified: DQ, FAT, SAT, IQ or OQ. Separate more than one with a semicolon.
RemarksThe deviation list item, the question for the customer, or what is still missing.

How to use the template

  1. Fill in the header block: the URS number and revision you are answering, the equipment, and your quotation number and revision.
  2. Add one row per URS requirement, with the URS's own ID and the text copied word for word. Split a paragraph that holds several requirements, and keep the URS ID on each part.
  3. Set the category and whether the URS marks the requirement Must or Want. Use the customer's own classes if the URS defines others.
  4. Write what you offer and set the status: Complies, Deviates, Clarification or Not addressed.
  5. For every row, name the document, revision and line that supports the response. A status with no reference is a claim the customer cannot check.
  6. Enter where each requirement will be verified: DQ, FAT, SAT, IQ or OQ. Agree the split with the customer; their validation plan decides it.
  7. Carry every Deviates row into your deviation list and every Clarification into your clarification list, and put the item number in Remarks.
  8. Before the offer goes out, filter Status for Not addressed. Every such row needs an answer.

Starting from a draft

In OdysseyGPT's Tender & Quotation module, Document Review and Customer Specification Review (beta) read the customer's URS and your own datasheets and specifications, list each requirement and show what your documents say against it, with a quote from the source page. Your engineers decide every status and response. Tools marked beta are open on request, and we onboard each team ourselves.

See how OdysseyGPT reviews a tender

Tell us how your team reviews tenders today. We can walk through an example together.

Book a call

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 a URS?

A user requirement specification is the document in which the customer states what a piece of equipment or a system must do. Each requirement is usually numbered so it can be traced through design, testing and qualification.

Is this a URS template or a response template?

It is the supplier's response matrix. A customer writing a URS can use the first four columns (ID, requirement, category, must or want) as the requirement list and send the file to suppliers to complete.

What is the difference between a URS response matrix and a traceability matrix?

The response matrix is made at offer stage and says whether the offer meets each requirement. A traceability matrix is kept after the order and links each requirement to the design document and the test that verified it. One usually grows into the other.

Who decides where a requirement is verified?

The customer's validation plan and the contract. The supplier proposes a stage for each requirement in the matrix, and the two sides agree it. Check the contract for which tests the supplier runs and which the customer runs.

Is there a free URS template in Excel?

Yes. This XLSX template has a blank matrix, a filled-in example for an invented process vessel skid and a How to use sheet. 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