On Center Home | MyOnCenter Portal | Start an On-Screen Takeoff Trial | Request a Quick Bid Demo | Contact Us | SALES: 1-866-627-6246
   
 
Learn more about Searching
Looking for help for one of ConstructConnect's Other products? Login


Tools
Table of Contents

On-Screen Takeoff - 14.02.01 Price Using Excel - Selecting the Workbook - OST

Views: 667 Last Updated: 11/14/2024 02:36 pm 0 Rating/ Voters
Be sure to rate this article 5 Stars if you find it helpful!

Set a Bid to use Excel for Pricing

You need to create a new Workbook in Excel or identify an existing Excel file to which you want to link this Bid. Only one Bid should be connected to any single Excel Workbook and a Bid can only be connected to a single Excel file.

Set the Price Using field to Microsoft Excel (cell or name).

Specify the location of your Excel Workbook - click the Lookup button the lookup button is a magnifying glass that opens a dialog box where you can select an XLS file to locate the Excel Workbook file.

browse to the locate where your existing Excel file is stored and click on it

After you select the workbook, the Cover Sheet displays the path and file name.

The path and file name display in the Bid's cover sheet

Click OK to save the changes to the Cover Sheet.

Next, you link each Condition Quantity result to a specific cell or named range.

click here to view the previous article Price a Bid using Microsoft Excel Price Using Excel - Linking to a Cell click here to view the next article



Product documentation (user guides) describes functionality in the latest version of each major release and may not match the functionality in the version you are using. Please check the Product Information and Downloads pages by clicking one of the product buttons above.

Something Wrong with this Article? Let us Know! The information in this site is protected by copyright by ConstructConnect. You may not reproduce, adapt, or publish any content from this site in whole or in part for any purpose, without the express written consent of ConstructConnect, Inc.
Copyright 2024 - All Rights Reserved.