| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
1 | Take this spreadsheet with a grain of salt. Not everyone will have a team that can stack bins, and other pitfalls happen along the way. 135 seconds will dissapear fast. | |||||
2 | ||||||
3 | ||||||
4 | ||||||
5 | Do not edit | |||||
6 | Insert your own testing/estimate | |||||
7 | Edit for different scenarios | |||||
8 | ||||||
9 | Variable | Time (s) | Note | Game time | ||
10 | T | 4 | Average time to stack one tote | G6 | 0 | (S6 + B + M6) * N6 |
11 | G5 | 0 | ||||
12 | S6 | 24 | 6 stack, 6 * T | G4 | 124 | |
13 | S5 | 20 | 5 stack | G3 | 0 | |
14 | S4 | 16 | 4 stack | G2 | 0 | |
15 | S3 | 12 | 3 stack | 0 | ||
16 | S2 | 8 | 2 stack | Total | 124 | Can't exceed 135 |
17 | S1 | 4 | 1 stack | |||
18 | Game points | (without bins) | ||||
19 | B | 0 | Average time to stack a bin, 0 if someone else will do this | P6 | 0 | 0 |
20 | P5 | 0 | 0 | |||
21 | M6 | 23 | Average time to move 6 stack on plateform | P4 | 96 | 64 |
22 | M5 | 20 | Average time to move 5 stack on plateform | P3 | 0 | 0 |
23 | M4 | 15 | Average time to move 4 stack on plateform | P2 | 0 | 0 |
24 | M3 | 15 | Average time to move 3 stack on plateform | P1 | 0 | 0 |
25 | M2 | 8 | Average time to move 2 stack on plateform | Total | 96 | 64 |
26 | M1 | 8 | Average time to move 1 stack on plateform | |||
27 | ||||||
28 | N6 | 0 | Number of 6 stacks in a game | |||
29 | N5 | 0 | Number of 5 stacks in a game | |||
30 | N4 | 4 | Number of 4 stacks in a game | |||
31 | N3 | 0 | Number of 3 stacks in a game | |||
32 | N2 | 0 | Number of 2 stacks in a game | |||
33 | N1 | 0 | Number of 1 stacks in a game | |||