Unified Construction Bidding Spreadsheet - 13/04/2026 17:12 EDT
Budget: $500 – $5,000 USD
Project Overview
I have an existing Excel workbook used for job costing in a construction/striping business. The workbook is already functional and calculates costs based on quantities entered across multiple sheets (organized by item types such as striping widths, colors, markers, removals, etc.).
Each sheet calculates unit pricing based on quantity tiers and produces totals. However, my current summary sheet only shows category totals (e.g., total striping, total removals) and does not provide a detailed, itemized breakdown.
What I Want to Achieve
I need to create a final summary sheet that dynamically pulls and displays ONLY the items used in a job, including:
Item description (ex: 4” White Stripe, RPM Marker, etc.)
Quantity entered
Unit cost (based on the pricing logic already built)
Total cost per item
Important:
The summary should ONLY display rows for items that are actually used (i.e., quantity > 0).
If an item is not used (quantity is blank or zero), it should NOT appear in the summary.
Current Structure
Multiple sheets organized by item type (striping, removals, markers, etc.)
Each sheet:
User inputs quantities
Unit Price remains hidden to user, Unit price is calculated via lookup tables (tiered pricing)
Extended totals are calculated
Final sheet:
Currently shows only high-level totals (no item-level detail)
Scope of Work
Build a dynamic summary/output sheet that:
Pulls data from all relevant sheets
Consolidates into one clean table
Filters out unused items automatically
Ensure:
No manual filtering required
Clean formatting suitable for printing or exporting to PDF
Maintain compatibility with my existing workbook (do not break current formulas)
Preferred Approach (Open to Suggestions)
I’m open to how this is built, but it may involve:
Power Query, OR
Advanced formulas (FILTER, UNIQUE, INDEX/MATCH, etc.), OR
Pivot table with dynamic filtering, OR
VBA (if necessary, but prefer non-VBA if possible)
End Goal
A clean, professional print-ready breakdown sheet that shows only the relevant items for a job, instead of printing multiple sheets with unused/blank items.
I have an existing Excel workbook used for job costing in a construction/striping business. The workbook is already functional and calculates costs based on quantities entered across multiple sheets (organized by item types such as striping widths, colors, markers, removals, etc.).
Each sheet calculates unit pricing based on quantity tiers and produces totals. However, my current summary sheet only shows category totals (e.g., total striping, total removals) and does not provide a detailed, itemized breakdown.
What I Want to Achieve
I need to create a final summary sheet that dynamically pulls and displays ONLY the items used in a job, including:
Item description (ex: 4” White Stripe, RPM Marker, etc.)
Quantity entered
Unit cost (based on the pricing logic already built)
Total cost per item
Important:
The summary should ONLY display rows for items that are actually used (i.e., quantity > 0).
If an item is not used (quantity is blank or zero), it should NOT appear in the summary.
Current Structure
Multiple sheets organized by item type (striping, removals, markers, etc.)
Each sheet:
User inputs quantities
Unit Price remains hidden to user, Unit price is calculated via lookup tables (tiered pricing)
Extended totals are calculated
Final sheet:
Currently shows only high-level totals (no item-level detail)
Scope of Work
Build a dynamic summary/output sheet that:
Pulls data from all relevant sheets
Consolidates into one clean table
Filters out unused items automatically
Ensure:
No manual filtering required
Clean formatting suitable for printing or exporting to PDF
Maintain compatibility with my existing workbook (do not break current formulas)
Preferred Approach (Open to Suggestions)
I’m open to how this is built, but it may involve:
Power Query, OR
Advanced formulas (FILTER, UNIQUE, INDEX/MATCH, etc.), OR
Pivot table with dynamic filtering, OR
VBA (if necessary, but prefer non-VBA if possible)
End Goal
A clean, professional print-ready breakdown sheet that shows only the relevant items for a job, instead of printing multiple sheets with unused/blank items.