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 Price A Bid Using Microsoft Excel

Views: 2298 Last Updated: 11/04/2022 08:54 am 0 Rating/ Voters
Be sure to rate this article 5 Stars if you find it helpful!

You can link your On-Screen Takeoff Condition Results to a Microsoft Excelâ„¢ workbook. Each Condition's result is linked to a specific cell (or named range) in Excel.

Refreshing Quantities

To refresh the Excel spreadsheet (meaning to push Quantity Results from On-Screen Takeoff to Excel) press <F9> or click Bid > Refresh Worksheet. By default, any time you leave a Bid linked to Excel or close the program, you are prompted to refresh the Excel spreadsheet. To disable this prompt, click Tools > Options and remove the check mark for "Prompt to refresh worksheet before closing Bid".

If you just want to copy and paste Takeoff Tab or Worksheet Tab data and paste it into Excel, see Related Articles.

The first step is selecting the Excel Workbook to which you want this bid linked.

Creating a Rough Cost Estimate on the Worksheet Tab Price Using Excel - Selecting the Workbook 



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! Copyright 2023 - On Center Software, Inc. by ConstructConnect - All Rights Reserved.