Paragon
HB · Vista · FAA Three-Way Compare
v2
No Job Loaded
📊
Budget Import Reconciliation
Load HeavyBid, Vista, and an optional reference file to compare budget line by line. Join key: phase suffix → bid item number.
Job Number
Job Name
Contract Value ($)
1
HeavyBid Viewpoint CSV
REQUIRED
BOR export from HeavyBid. Row type 1 = bid items (qty, unit, unit price, extended $). Row type 2 = phases. Export must use same revision/filters as Vista import.
2
JCCostEstCT — Vista Cost/Estimate
REQUIRED
Vista JC Cost to Estimate report exported to Excel. Phase codes roll up to bid item by suffix integer. Est $ column is the comparison target.
3
Reference / Prior Recon Workbook
OPTIONAL
Prior recon Excel, FAA pay schedule, or any third reference. First sheet used. Item# column auto-detected.
Load Files to Continue
Line-by-Line Comparison
All
⚠ Delta >2%
~ Delta 0.5–2%
✓ Match
LS Items
Unmatched
Export CSV
Reset
Item #
Description
Unit
HB Qty
HB Unit $
HB Extended $
Vista Est $
Delta $
Delta %
Ref $
Flags
Vista Phases — No HB Match
Phase Code
Description
Est $
Note