You can design your bid sheet online using Sourcing Optimizer, or you can design it offline and then upload it to the application. Your bid sheet can be your own design, or it can be based on a downloadable Keelvar template.
If you are designing your bid sheet offline, note the following requirements:
• It must be an Excel spreadsheet.
• The first row in the spreadsheet must contain column names.
• There must be one row per lot.
• There must be a column which identifies lots; the values must be unique.
• Bidder-input columns must be left empty.
When you are designing your bid sheet, consider the following best practices:
- Use descriptive identifiers for lots.
- Group the bidder-input columns together after the purchaser-input columns.
- Include a column for historical prices for analysis.
- Ensure that any columns that will be used for cost calculation and analysis are marked as mandatory.
After you upload your bid sheet, Sourcing Optimizer converts your design into its own bid sheet format. It determines which column to use as the lot identifier; whether columns require a number, currency or text input; if columns are mandatory or optional; and whether columns require purchaser input or bidder input.