Uploading Event Data
Users can upload a bid sheet or create one offline in Microsoft Excel and simply upload it. A bid sheet template can be downloaded to help get started by clicking the “Download” button where you can begin designing your bid sheet.You can also upload an excel file by clicking “Choose a file” or even simply dragging and dropping a file in the upload area. See Figure 1:
The AI does the hard work importing your design into the system. It determines everything from a column being a Currency, Number or Text input to whether it is an optional or mandatory input. The system will also determine which column to use as the Lot Identifier:
Also, if a column already contains values, then the tool will set the ‘Input by’ to ‘Purchaser’ (whereas empty columns will have the ‘Input by’ defaulted to ‘Bidder’).
Note that all empty (bidder-entered) columns will have the input type automatically set by the AI to ‘Currency’ or 'Number' depending on the column header. Once the import is complete, review to ensure all settings match your needs.
Bid Sheet Overview
Users can download their current bid sheet design and make the changes. Additional columns and lots (rows) can be easily added by importing them in an updated bid sheet. A log of the changes made for each import is presented before the data import is finalized, as shown in Figure 2.
|You can replace an uploaded bid sheet design with updated information that's imported by simply dragging the new bid sheet to the upload area, rather than making the changes online.|
Once a bid sheet has been uploaded, the system will give previewed version of the bid sheet just as a supplier would see it on the overview tab. Users have immediate access to the columns and lots by clicking the respective tabs at the top of the screen, where they can edit columns or lots. See Figure 3
Here is some further detail on the columns types:
- The purchaser, for information you’re providing to the carriers.
- The purchaser with bidder-specific values (e.g., you would use the 'Starting Bids' screen to enter a value of '100' for Supplier A and a value of '80' for Supplier B).
- Bidder, for information they need to provide.
- Mandatory – the user cannot leave this column null/empty.
- Optional – the column can be left null/empty.
- Restricted values: Create a drop-down list by entering values separated by commas (e.g., 30 days, 45 days, 60 days, 90 days).
- Input can be by:
- Input requirement:
- Bidder visible: Either visible or not visible (hidden), meaning that the column won’t appear on the bidder side.
- Restrict input values:
- Specify the number of decimal places using the drop-down box under 'Input type'.
- Restricted values: Create a drop-down list by entering numbers separated by commas (e.g., 1, 100, 1000).
- Minimum value: Enter the minimum acceptable value.
- Maximum value: Enter the maximum acceptable value.
- The other options are the same as for Text columns.
- The default is 2 decimal places.
- All the other basic options are the same as for Number, such as the ability to restrict input values.
- See the section below for information about the ‘Show advanced options’ feature for Currency columns.
|Columns hidden from bidders display a lock icon (see Fig 4)|
When adding or editing currency columns, you’ll see ‘Show advanced options’ near the bottom of the pop-up window.
This area lets you set the currency for purchaser-input fields.
For bidder-input fields, specify whether the currency is set by the purchaser or bidder. If the currency is set by the purchaser, there’s a ‘Currency’ field you can use to select the currency for the column (based on the list you created on the ‘Overview’ subtask).
|If you need to start over and delete all column and row data, click the ‘Reset’ button and then click ‘Yes, reset’. You will be returned to a blank state and can then upload a file to start again.|