Zero-AI Local Spreadsheet Engine

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

fullCalcOnLoad = true · Zero-AI Local
RowCol B — Buyer DescriptionCol E — QtyCol F — Injected Unit PriceCol G — Formula UntouchedCol H — Automated Technical Note
6VoltGuard ProLine 3P 63A 400V MCB24 pcs34.20=E6*F60 automated flags · Ex-Stock
7NexCable 4x16mm2 Cu/XLPE/SWA Cable250 m9.22=E7*F7Unit conversion: 250 m -> 3 rolls (100m roll)
8VoltGuard 2P 63A 30mA RCBO Breaker10 pcsNO-BID=E8*F8Flagged 32A vs 63A variance — estimator marked No-Bid
13CONTRACTOR 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 SpecificationLocal Vault RecordSpecGuard ResultCommercial Action
Row 6: 24 pcs — VoltGuard ProLine 3P 63A 400V MCBVG-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 CableNX-4X16-SWA · Stocked per 100m Roll · Cost $640.00UOM CONVERSION: 250m -> 3 x 100m RollsCalculates 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 BreakerVG-RCBO-2P32 · 2P 32A 30mA RCBO · Cost $34.00CRITICAL FLAG: 63A vs 32A AMP VARIANCEFlagged 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 PN25NV-BF-DN100-PN16 · DN100 Ductile Iron PN16 · Cost $92.00CRITICAL FLAG: PN25 vs PN16 PRESSURE VARIANCEAlerts estimators to under-rated valves on chilled-water risers and keeps the buyer's BOQ audit trail clear.

Three-Step In-Place BOQ Workflow

01

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.

02

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.

03

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

DimensionManual Excel VLOOKUP / Ctrl+FQuotePair
Sheet Formatting & FormulasManual 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 MismatchesQuoting 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 ListsSwitching 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 ProtectionVisual 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.

Open Live Quoting Workspace — No Signup Required

Explore Related Industrial Quoting Workflows