Commercial General Contractor Replaced Manual Bid Prep With an Automated Excel Workflow

Situation

Our client is a Sacramento-based general contractor and construction management firm with projects across California and Nevada. The company delivers commercial projects across multifamily housing, retail, mixed-use development, and institutional construction. Their approach is hands-on, focused on problem solving and relationship building through preconstruction, construction management, and project delivery. They have consistently been recognized as one of the region's best places to work and hold multiple Cal/OSHA safety certifications. With an active pipeline of projects, their estimating and preconstruction team works across multiple bids simultaneously.

For bid tracking, the team relied on a custom Excel workbook. As the business grew and bid complexity increased, the workbook became harder to maintain. Creating bid tally sheets for new packages required manual tab setup. Alternates had no clean structure. The contact list for each bid package was a flat sheet with no easy way to navigate or add new entries. Summary and recap tabs had to be manually connected after the fact.

The process worked, but it depended on the person running it knowing all the steps. Any variation increased the chance of missed data, duplicate entries, or broken links between tabs.

Solution

ProsperSpark worked with the team iteratively to automate the most manual parts of the bid tally process while keeping the workflow they already knew. The build focused on reducing friction at the steps where errors and delays were most likely.

The core of the project was a Create Bid Tally Sheets form built in VBA. Instead of manually setting up each new bid package tab, the team could select bid packages from a form and the workbook would generate the corresponding sheets automatically, including the correct summary formulas. The form also included checks to prevent duplicate sheet creation. An option for "Other" bid packages gave the team flexibility without breaking the structure.

Alternates were redesigned with the same approach. A dedicated Alternates worksheet was built so the team could show or hide alternates cleanly, and VBA code was added to capture only alternates from the awarded bidder, reducing noise in the output.

A new Turnover worksheet was added to support handoff from preconstruction to the project team, and it was connected directly to the bid tally sheet creation process so new entries populated automatically.

The contact list, which had been a flat sheet with no structure, was rebuilt as a table. A user form was created so the team could add new contact information for any bid package and have it sorted into the right section automatically. Ribbon buttons were added to jump directly to each bid package section, and a search function with auto-filtering made it faster to find specific contacts.

The workbook also received structural improvements: sheet header info centralized on an Info tab, named references connected across all headers, hide/unhide column buttons added to Recap, Summary, and Alternates tabs, and a custom ribbon with controls for the most common tasks.

Results

What had been a largely manual, step-dependent process became a structured, guided workflow. The team could spin up new bid tally sheets from a form instead of building them by hand. Contacts were organized, searchable, and easy to update without worrying about breaking the sheet. Alternates had a clean home. Summaries populated reliably.

Because the workbook is used across a high volume of bids, the time savings compound. Less setup work per bid means more capacity during peak periods, and less risk of errors carrying into final bid packages or handoff documentation.

The engagement continued beyond the initial build. The client returned for additional enhancements, including a salary and bonus workbook and updates to a value engineering log and deviation document. That pattern reflects what happens when a team gains confidence in a tool and starts using it more fully.