OST - 14.02.01 Price Using Excel - Selecting the Workbook

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

Price Using Excel - Linking to a Cell