All automations

Automation · August 2026

BOQ Analyzer

A VBA tool that checks vendor bills of quantities against the master list and flags every mismatch in seconds.

  • Excel VBA
  • Power Query

How it runs

5 steps, the same way every time.

  1. Import BOQ
  2. Match items
  3. Validate prices
  4. Flag issues
  5. Export report

Before → after

What changed.

Before

The problem

Vendors send bills of quantities (BOQs) in their own formats. Checking each line by hand against the master part list took hours, and mistakes still slipped through.

After

The solution

A macro-enabled workbook that imports any vendor BOQ, normalises part numbers (ignoring leading zeros), matches each line to the master list, and highlights price, quantity and description mismatches.

Five connected circles showing the BOQ Analyzer steps from import to export

In more detail

The full story

Sample automation migrated from v1. All numbers here are illustrative.