| |
| |
On-Screen Takeoff - 14.02.01 Price Using Excel - Selecting the Workbook - OST
| Views: 669 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  to locate the Excel Workbook file.
After you select the workbook, the Cover Sheet displays the path and file name.
Click OK to save the changes to the Cover Sheet.
Next, you link each Condition Quantity result to a specific cell or named range.
|
| |
Price a Bid using Microsoft Excel