Skip to main content

How can I Import my Estimate Spreadsheet?

The import feature allows Estimators to pull in project estimates that have been prepared outside the system quickly and efficiently.

If you build estimates in a spreadsheet, you can import them into a project's Base Bid instead of entering each cost item by hand. Always start from the import template you download from RedTeam Go, so the columns are exactly what the import expects. You can import while the project is in Bidding; the Bidding menu isn't available once the project is In Progress.

Important: Importing replaces the cost items on the Base Bid with the rows in your template, including items that had reminder notes. Include every cost item you want to keep before you import.

Download the import template

Step 1: Open the project, then click Bidding > Worksheet > Base Bid.

Step 2: Click Import.

Step 3: Click Download the import template. The template (an Excel file) is saved to your computer.

Fill in the template

Open the template in Excel and enter one cost item per row, starting under the header row. Don't add, remove, rename or reorder the columns, and don't use a spreadsheet of your own: copy your values into the template instead.

Column

What to enter

Cost Code

A cost code from the project's cost code list, in the same format (for example, 01-021.L). Each cost code can appear only once.

Description

The cost item description. When the cost code matches, the description from your cost code list is used.

Unit Type

The unit, such as LS, EA or HR. A blank or unrecognized unit is imported as LS.

Quantity

A number from 0 to 999.

Amount

The unit price, from 0 to 9,999,999. The price on the estimate is Quantity × Amount.

Tip: For a quantity over 999 (for example, 2,400 SF), enter a quantity of 1 with the unit LS and the total price as the Amount.

Save the template as an Excel file (.xlsx or .xls).

Import the template

Step 1: On the Base Bid, click Import.

Step 2: Select Add imported cost codes to the existing estimate or Overwrite the existing estimate with the imported cost codes.

Step 3: Drag your filled-in template onto the upload area, or click the area to browse for it.

RedTeam Go checks every row and shows how many are ready to import. Rows with a problem are listed under Rows that need attention; the rest are listed under Ready to import.

Fix rows that need attention

Each problem is shown in red under the value to fix.

  • Cost code not found: click the cost code box, type part of the code or description, then pick a cost code from the list.

  • Cost code already used by another row: pick a different cost code, or click Remove.

  • Quantity or Amount must be a number: type a value in the range shown.

A row moves to Ready to import as soon as its last problem is fixed, and you can't edit it there. Check the row's quantity and amount before you fix its last problem.

Remove takes a row out of this import straight away. To get it back, click Start over and upload the template again.

Complete the import

Step 1: When the window shows Nothing needs attention, click Import.

Rows still under Rows that need attention are not imported, so fix or remove them first.

Step 2: Check the summary: the number of cost codes imported and their total before markups. Click Return to worksheet.

Your project markups are applied on the Base Bid worksheet, where you can adjust any cost item. To change markups, see How do I set project markups?.

Did this answer your question?