IMPORTING BID ITEMS FROM AN EXCEL SPREADSHEET

 

Note: The exported spreadsheet’s format must be exactly the same as it was when it was exported to successfully import the paper based bid back into CapEx Manager.

Only base line items (these are line items that are designated as Work-Related) will be imported. Imported Unit Prices (or Labor and Material Prices) for line items will automatically overwrite any Unit Prices (or Labor and Material Prices) that were previously entered manually for these same line items in the system.

 

1.   Click the Browse... button under the Import Your Bid section (see Screen Shot).

6

2.   In the ‘Choose File’ popup window, locate your bid spreadsheet on your computer and click the Open button.

3.   Click the Import Bid button.

 

Note: If the import is successful, a confirmation message will be displayed. If the import fails, an error message will be displayed. Click on the ? link to refer to the spreadsheet formatting rules for import.