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

OST - 14.02.01 Price Using Excel - Selecting the Workbook

Views: 473 Last Updated: 11/04/2022 08:54 am 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 ALT TEXT to locate the Excel Workbook file.

ALT TEXT

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

ALT TEXT

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 ExcelPrice 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.