Auto-Fill Contractor Excel BOQs From Your Price Sheet — Without Breaking Formulas
Contractors reject tenders when a distributor alters column letters, flattens =SUM() totals, or corrupts merged cover sheets. QuotePair reads the buyer's workbook locally, maps lines against your browser-local cost sheet, catches spec mismatches, and injects approved unit prices directly into the original cells.
=SUM()
Formulas Preserved
Existing row products and subtotal formulas stay untouched with fullCalcOnLoad enabled.
0 Bytes
Costs Uploaded
Your net buy prices stay strictly inside browser IndexedDB storage.
Zero-AI
NDA-Safe BOQ Path
Excel (.xlsx) and CSV BOQs run deterministically locally with no cloud LLM calls.
< 3 min
100-Line BOQ Turnaround
Review flagged exceptions, convert rolls to meters, and export in-place.
In-Place Contractor BOQ Preview — Formulas & Cell Styles Preserved
| Row | Col B — Buyer Description | Col E — Qty | Col F — Injected Unit Price | Col G — Formula Untouched | Col H — Automated Technical Note |
|---|---|---|---|---|---|
| 6 | VoltGuard ProLine 3P 63A 400V MCB | 24 pcs | 34.20 | =E6*F6 | 0 automated flags · Ex-Stock |
| 7 | NexCable 4x16mm2 Cu/XLPE/SWA Cable | 250 m | 9.22 | =E7*F7 | Unit conversion: 250 m -> 3 rolls (100m roll) |
| 8 | VoltGuard 2P 63A 30mA RCBO Breaker | 10 pcs | NO-BID | =E8*F8 | Flagged 32A vs 63A variance — estimator marked No-Bid |
| 13 | CONTRACTOR SUMMARY TOTAL ROW (MERGED CELLS & BORDERS UNTOUCHED) | =SUM(G6:G12) | Recalculates live on open | ||
How In-Place BOQ Cell Injection Protects Margin & Sheet Integrity
Before a single cell is written back to the buyer's .xlsx file, QuotePair validates electrical, pressure, dimension, and pack-unit rules line by line.
| Buyer RFQ Specification | Local Vault Record | SpecGuard Result | Commercial Action |
|---|---|---|---|
| Row 6: 24 pcs — VoltGuard ProLine 3P 63A 400V MCB | VG-CB3-63A · 3P 63A 400V · Cost $28.50 (USD) | AUTO-MATCH (0 FLAGS) | Writes $34.20 into Unit Price cell F6; buyer's =E6*F6 and =SUM(G6:G12) recalculate automatically. |
| Row 7: 250 meters — NexCable 4x16mm2 Cu/XLPE/SWA Cable | NX-4X16-SWA · Stocked per 100m Roll · Cost $640.00 | UOM CONVERSION: 250m -> 3 x 100m Rolls | Calculates 3-roll sell price ($2,304) and writes equivalent $9.22/m into buyer's meter-based sheet with conversion remark. |
| Row 8: 10 pcs — VoltGuard 2P 63A 30mA RCBO Breaker | VG-RCBO-2P32 · 2P 32A 30mA RCBO · Cost $34.00 | CRITICAL FLAG: 63A vs 32A AMP VARIANCE | Flagged in red with a confirmation gate before export. Estimator can swap SKU, enter a Spot Quote, or mark NO-BID cleanly. |
| Row 9: 6 pcs — 4 in DN100 Ductile Iron Butterfly Valve PN25 | NV-BF-DN100-PN16 · DN100 Ductile Iron PN16 · Cost $92.00 | CRITICAL FLAG: PN25 vs PN16 PRESSURE VARIANCE | Alerts estimators to under-rated valves on chilled-water risers and keeps the buyer's BOQ audit trail clear. |
Three-Step In-Place BOQ Workflow
Load Your Supplier Cost Sheet Locally
Drop your Excel (.xlsx) or ERP CSV export into the Browser-Local Vault. Review and map columns such as Net Buy Cost vs. List Price so you never pull the wrong price column.
Drop the Contractor's BOQ Workbook
QuotePair detects the header row, ignores section division headings, matches every line deterministically, and flags critical rating mismatches or meter-to-roll unit traps.
Approve Exceptions & Export In-Place
Apply Cost + Markup, Target Gross Margin, or List − Discount rules (with custom FX rates if needed), confirm review, and download the buyer's original .xlsx with prices injected into exact cells.
Manual Copy-Paste vs. In-Place BOQ Automation
| Dimension | Manual Excel VLOOKUP / Ctrl+F | QuotePair |
|---|---|---|
| Sheet Formatting & Formulas | Manual pasting frequently overwrites =SUM() rows or shifts merged headers. | Writes only into target unit-price, brand, and remarks cells while preserving workbook XML and styles. |
| Unit-of-Measure Mismatches | Quoting per-roll price on a per-meter cell causes 100x over-bids or catastrophic losses. | Detects 100m roll vs. meter discrepancies and writes exact buyer-unit equivalent rates. |
| Multi-Sheet Price Lists | Switching across 6 vendor tabs and ERP CSVs wastes hours per bid. | Merges all valid workbook tabs into one searchable browser-local vault keyed by SKU. |
| Spec Liability Protection | Visual scanning misses 32A vs. 63A or PN16 vs. PN25 on 80-line tenders. | Prominent red variance alerts + confirmation gate before export so estimators can swap, spot-quote, or no-bid. |
Frequently Asked Technical & Commercial Questions
Does QuotePair overwrite the contractor's =SUM() or =E6*F6 formulas?
No. When exporting in-place, QuotePair only writes values into the detected Unit Price, Brand/Offer, and Remarks columns. Existing Total formulas such as =E6*F6 and summary =SUM() cells remain intact, and workbook fullCalcOnLoad is enabled so Excel recalculates every total immediately on open.
Does the Excel BOQ mode send our tender or price sheet to an external AI?
No. Excel (.xlsx) and CSV BOQ extraction runs locally inside your browser, and specification matching uses deterministic attribute indexing without calling external generative AI models. Supplier costs never leave your device.
What happens when a contractor asks for 250 meters of cable we stock in 100m rolls?
QuotePair flags a Unit-of-Measure conversion warning and calculates the required whole-roll order quantity (3 rolls = 300m). When writing back into the buyer's meter-based BOQ, it automatically injects the exact per-meter equivalent sell price so Qty * Unit Price matches your true 3-roll total.
What if our master price list has both a Retail List Price column and a Net Buy Cost column?
VaultDrawer includes an interactive column mapper with live sample cell previews before import. You can verify or switch the Unit Cost column directly to Net Buy Cost before a single SKU enters your local vault.
BROWSER-LOCAL VAULT · ZERO SIGNUP · ZERO COST UPLOAD
Test QuotePair on a live industrial RFQ in under 60 seconds
Run any of the four built-in vertical samples at zero credit cost, or drop your own price sheet locally and verify how spec traps and pack conversions are caught before quoting.