SLOTS
The SLOTS function takes a list of items and groups them into slots.
It also accepts a group of lists, returning, in this case, a group with slots in each of its entries.
SLOTS(items, table, [multiple])
Argument name | Description |
items Required | List of items, or group of lists.
The list can contain duplicated items, in whose case they will weigh more and will be prioritized in the slots. |
table Required | Table with the association between each item and its group.
An item can be also associated with multiple slots. |
multiple Optional | If true, each slot will accept more than a single item. It is false by default. |
Table syntax
Column name | Description |
item Required | Item identifier. |
slot Required | Slot identifier. |
If:
- items = [p1, p2, p3, p4, p5]
And table is:
table
SLOTS(items, table) will return:
slot1: [p1]
slot2: [p2]
slot3: [p4]
SLOTS(items, table, true) will return:
slot1: [p1, p5]
slot2: [p2, p3]
slot3: [p4]
If:
- items = [p1, p2, p5, p3, p4, p5]
and table is:
table
SLOTS(items, table, true) will return:
slot1: [p5, p1]
slot2: [p2, p3]
slot3: [p4]
Note p5 has a higher priority because it appears twice in the list.
If:
- items = {group1:[p1, p2, p3, p4], group2:[p5, p6, p7, p8]}
and table is:
table
SLOTS(items, table, true) will return:
group1:
slot1: [p1]
slot2: [p2, p3]
slot3: [p4]
group2:
slot1: [p5]
slot2: [p6]
slot3: [p6, p7, p8]
Last modified 2yr ago