Skip to main content
Sections in this category

Creating a bid sheet design using the Keelvar template

  • Updated

Keelvar provides a template that you can use to design your bid sheet offline. You can download this template on the Overview tab of the Bid Sheet submenu.

Bid Sheet — Keelvar template download
Figure 1. Bid Sheet — Keelvar template download

You can open and configure this file using Excel and then upload it in Sourcing Optimizer. Some editing restrictions apply to ensure your data is correctly interpreted by Sourcing Optimizer. Additional editing options are available after you upload the bid sheet.

Column metadata

In the bid sheet template, you can configure metadata for each column. The metadata assigns properties to the column, and provides this information to Sourcing Optimizer when you upload the bid sheet. The options available for each type of metadata are described below.

Bid sheet column metadata
Figure 2. Bid sheet column metadata

Data Type

  • Number: The bidder must enter a valid number with no more than six decimal places.
  • Currency: The bidder must enter a valid number with no more than six decimal places. The entry defaults to the event currency.
  • Text: The bidder must enter text.

Input By

  • Purchaser: The column information is provided by the purchaser designing the bid sheet.
  • Purchaser (bidder-specific value): The column information is provided by the purchaser but can be specific to each bidder.
  • Bidder: The column information is provided by the bidder when completing the bid sheet.

Bidder Visible?

  • Yes: The column is visible to bidders.
  • No: The column is hidden from bidders.

Mandatory?

  • Yes: The bidder must complete the column to place a bid.
  • No: The bidder is not required to complete the column to place a bid.

Column Role

  • Lot ID: Identifies a text column which contains unique values to identify the lot. You must configure one column to be the Lot Identifier.
  • Historical Price: Identifies a number or currency column that has historical lot prices set for reporting and comparison purposes.
  • Reserve: Identifies a number or currency column that has lot reserve prices set.
  • Bid Decrement: Identifies a number or currency column that has set minimum bid decrements per lot.
  • Feedback Target: Identifies a number or currency column that has a per-lot target value to control traffic light feedback.
  • Minimum Bid Value: Identifies a number or currency column that has per-lot values for the minimum price that will be accepted on a lot.
  • Maximum Bid Value: Identifies a number or currency column that has per-lot values for the maximum price that will be accepted on a lot.

To design your bid sheet using the Keelvar template, complete the following steps:

  1. Go to Design > Bid sheet.
  2. On the Overview tab, under Start with a template, click Download.
  3. Open the downloaded Excel file and create your bid sheet design. Complete the following steps for each column used:
    1. Select a data type from the Data Type list.
    2. Select who enters the data from the Input By list.
    3. Select whether or not the column is visible to the bidder from the Bidder Visible? list.
    4. Select whether or not the column is mandatory from the Mandatory? list.
    5. Optional: Select a column role from the Column Role list.
    6. Enter a name for the column in the Current Lot ID field.
  4. Save the Excel file.

After you complete your bid sheet design, upload it to Sourcing Optimizer to be imported and processed. Sourcing Optimizer validates your bid sheet during the upload process; the bid sheet will be rejected if there are validation issues.