We have been working hard this summer to bring some major additions and enhancements.
Artificially intelligent design upload
We are excited to announce the addition of AI to design sheet imports. 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 AI will also automatically hide columns that should not be visible to bidders. Helpful to ensure historic prices or other sensitive data does not get inadvertently leaked. The user just has to review the import log to ensure the design meets their needs. We are going to continue working on adding AI to other parts of the application.
Bid Sheet Design
There are major updates on the bid sheet design. A new redesigned tab layout gives immediate access to an overview of the current design. The bid sheet can be previewed just as a supplier would see it. The current design can be downloaded in Excel format for editing offline. Offline design updates can be easily uploaded. A history of uploads can be viewed allowing changes to be tracked over time. The Columns and Lots tab give easy access to configure those aspects of your bid sheet. In addition, the plus tab gives access to additional functionality that can be enabled on the bid sheet.
Download bid sheet
Download your current bid sheet design to an excel file. Once downloaded you can edit your design offline. It is simple to upload your changes back into the system from the Overview tab. You can download a blank template to start your design offline or iterate on an existing design mid event. The offline sheet allows configuration of column metadata, adding/removing of lots/columns, renaming of lots/columns to name some of the actions. A help worksheet is present to help you understand all the offline design possibilities.
Global bid inputs
You can now configure bid inputs that are at the bid sheet level and can apply to all lots. We call these global bid inputs. Once the feature is enabled on the plus tab, you can create a global bid input in a similar manner as a standard column.
Global bid inputs can be used in the cost function and are available for bidder's to input values in both online and offline excel bidding. Global bid inputs replace the use of RFI questions in the cost function.
Lot rows have a default ordering in the system usually based on the order they were created. As lots are added or removed the need to re-order lots may be required. A new option allows you to update the default order. You simply choose one or more columns to base the lot re-order on and the lots will be saved in that order.
Columns in the design bid sheet can be easily sorted now by clicking on the sort direction arrow in the column header. Bidders can also sort data in the online bid sheet in a similar manner.
Want to get to particular lots quickly? We now have filtering on column data in the lot design view. When combined with sorting it offers a quick way to access the exact data you require. We will be rolling out filtering in additional locations in our application in coming releases.
Sometimes you just need to take a step back in your design and start again. You can delete all lots or your entire design can be Reset from the Overview tab. The design reset will clear all columns, rows, global bid inputs and cost functions. Be sure to read the confirm dialog before confirming!
Column type conversion
If your column is the wrong type, it is now easy to change to the correct type. You can toggle a column from a Currency/Number type to a string and any cell data will be automatically converted. You can also toggle from a string to a numeric type. We will warn you if there are any text strings that can't be converted, allowing you to take corrective action.
Volume capacity per bidder
In split award events, it is now possible to specifiy minimum and maximum capacities per lot. Simply map a demand column and a column which identifies the maximum or minimum volume per bidder. You can, as the purchaser choose to define the limits or you can allow individual bidders to populate their own capacity in a bidder input column.
Scenario forced allocations
For a particular scenario, it is now possible to force the allocation of lots or lot shares to bidders. Once a scenario is evaluated, lots defined in forced allocation are allocated first. This allocation is pinned before any remaining lots are evaluated and awarded. Ideal if you need to cherry pick your allocation.
- Scenarios can now be re-ordered from the scenario drop down menu.
- Scenario results now show the bidder names in split award events.
- Awarded volume information is now available in the downloadable reports.
- Various bug fixes