In more detail
The full story
Sample automation migrated from v1. All numbers here are illustrative.
Automation · August 2026
A VBA tool that checks vendor bills of quantities against the master list and flags every mismatch in seconds.
How it runs
Before → after
Before
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
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.
In more detail
Sample automation migrated from v1. All numbers here are illustrative.