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.02 Price Using Excel - Linking a Condition to an Excel Cell or Named Range - OST

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

Now that you've selected the workbook you want to link this bid to, you must link each Condition Quantity result to a specific cell or named range in that workbook.

Cell or Named Range

First, you need to decide if you will use explicit cell references or named ranges to connect On-Screen Takeoff to Excel:

  • Microsoft Excel (cell) - designates a specific cell to which a Condition Quantity Result is linked - uses the cell’s absolute location (i.e. Sheet1, (Cell) A3 or Sheet2, (Cell) Q27). If you make any changes to where cells are in the spreadsheet (adding rows or columns, for example), On-Screen Takeoff will still place data in the specified cell (for example - if you specify a Result is to populate cell "A1" in your spreadsheet, if you add a row or column to your spreadsheet, On-Screen Takeoff will still push the value to cell "A1".
  • Microsoft Excel (name) - On-Screen Takeoff creates (defines) a "named range" in Excel and the Condition Quantity is linked to that named range. Because the Condition quantity is not linked to a specific cell (such as A2 or Q27), if you make changes to the spreadsheet (such as adding or rearranging rows/columns), the Quantities are still sent to the correct location in the spreadsheet.

You must have a fully-licensed version of Microsoft Excel installed on your PC to use "Price using Excel". Student, Home, and any trial editions cannot be used. Excel is neither provided, sold, or supported by On Center Software nor included with On-Screen Takeoff. Check current System Requirements, for currently supported versions of Microsoft Excel.

Linking a Condition Quantity Result to Excel

  • Click on the Image Tab or the Worksheet Tab.
  • Select a Condition.
  • Open the Condition Properties (the Results you've select will likely be different than the example below).
  • Click on the Link icon Condition Detail link to excel button is a small grid - this opens the designated spreadsheet (or brings it to focus if it is already open).
  • Locate the cell to which you want On-Screen Takeoff to send Quantity Results.
  • Double-click the cell and a reference to that cell or the named range is placed in the appropriate Results box in On-Screen Takeoff.

Excel minimizes and On-Screen Takeoff Condition Properties dialog box regains focus.

On-Screen Takeoff Condition Properties dialog box showing the cell reference
Results after linking to a "Cell"

On-Screen Takeoff Condition Properties dialog box showing the named range reference
Results after linking to a "Named Range"

Notice once a cell is assigned, the Export field is greyed-out and cannot be modified although you can click the Link button again to update the mapping (you just cannot type within the field).

Repeat this process for each Result in each Condition in the Bid.

Note
Even though you are creating a link while viewing a particular Page in your Bid, the values sent to Excel are for the cumulative Condition Quantity Results for the entire Bid (those cumulative Results displayed on the Takeoff (Summary) and Worksheet Tabs. There is no breakdown by Type, Area, Zone, or Page when exporting to Excel - the entire Condition's value is exported to the linked spreadsheet. If you need to break out your estimate, may we suggest using Quick Bid?

click here to view the previous article Price Using Excel - Selecting the WorkbookPrice a Bid using Quick Bid (Interactive Bids) 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.