Concept: Linked Event Worksheets
Linked event worksheets enable you to collect and migrate data from 1 sheet to another. You
can:
- Consolidate data from multiple sheets.
- Break out components of complex event worksheets into new sheets.
- Connect data across sheets.
Linked event worksheets help you run sourcing events with several sheets, as well as build more
flexible bid sheets to capture supplier responses. Common use cases for linked event
worksheets include:
Use Case | Description |
|---|---|
Freight Costs | Collect freight costs per pound to various locations, and use pricing
to calculate the fully landed cost of each item. Prices are the same across
the different items. |
Project Costs | Collect rate cards on 1 sheet, then select titles and quantities on a second sheet to
build the cost of a project. |
Facility Information | Collect general information about production facilities on 1 sheet, then use that
information on a second sheet. |
Currency Conversion | Store rates on 1 sheet and run conversions on a second sheet. |