Historical Data

Import BuildingConnected bid history

Bring a leveled bid workbook and its quote archive into ScrubPlan, then review the results before adding them to your cost history.

Where to goHistorical Data › Import projectOpen ScrubPlan

Before you begin

  • The BuildingConnected Proposal Summary XLSX for the leveled bids.
  • The matching Bid Archive ZIP, if you want to preserve bid forms, quotes, and attachments.
  • The project name, bid round, currency, total building square footage, building type, and market sector.

Follow these steps

  1. Upload the exports

    Select Import project. Drop or choose the Proposal Summary XLSX and, if available, the matching Bid Archive ZIP. Select Read files.

    The XLSX is required. The ZIP adds the supporting files needed for quote review and material unit cost extraction.

  2. Choose the project destination

    Select Create a history-only project or Link an existing ScrubPlan project. Confirm the destination before continuing so the round is saved under the correct project.

    Review the project number and name, bid round, currency, actual bid date, and available location fields.

  3. Complete the project metrics

    Enter the total building SF, building type, and market sector. Complete the project description and applicable lot area, construction type, sprinkler, occupancy, and use-group information.

    If you enter square footage by level, the levels must add up to the total building SF. Add applicable general project costs and the Key Project Metric.

    Select Review import when the details are ready.

  4. Confirm organization package matches

    Review how each imported bid package maps to your organization's packages. Resolve every item that needs review by choosing the correct organization package or keeping the bid unmapped.

    Use Re-match packages when the organization package list or matching rules have changed.

  5. Review pricing and exclusions

    Check the calculated leveled bid totals, apparent low bidders, and any differences from the workbook's saved header totals. ScrubPlan uses the calculated leveled totals to determine ranking.

    Resolve flagged pricing items. Where appropriate, enter a verified total and its reason, or exclude the affected package from the rollup.

  6. Check quote and attachment matches

    Review the package and bidder assigned to each archive group. Select the appropriate quote PDFs for each bidder; more than one PDF may be selected. Correct or exclude unmatched items before approval.

    Material unit cost extraction runs on selected quote PDFs in the background.

  7. Approve the import

    Select Approve import. If unresolved data will be excluded, review the confirmation list and the effect of each exclusion before accepting it. Return to review if anything should be corrected.

    The approved project opens in Historical Data. Check its bid round, pricing, and quote records.

  8. Approve material results that finish later

    If a Quote material extraction notice shows completed rows ready for review, select Review materials. Verify the description, bid package, grouping, quantity, units, total cost, and unit cost. Remove rows that should not be included, then approve the reviewed results.

    Results completed after the initial import require this separate review before their unit costs join the historical snapshot. A quote marked completed with no qualifying lines does not add material costs.

Unmapped bids stay out of package averages

Keeping a bid unmapped preserves it in project history while excluding it from organization package averages. Correct mappings make comparisons between imported projects more useful.

Check each material value

Quantity, total cost, and unit cost can be edited independently. After a correction, verify that all three values and the unit agree with the source quote.