Spreadsheet: 879228d1726672160-is-it-possible-to-speed-up-formula-calculation-patterns_mrshorty
Sheet: 9

 |  |  |  |  |  |  |  |  |  |  |  |  | TOP POSITION | 1 | 3 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  | BOTTOM POSITION | 1 | 2 | 3
 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 9 | 9 | 9
 |  |  |  |  |  |  |  |  |  |  |  |  | TOP GAP | 27 | 11 | 2
 | COLUMN | COLUMN | COLUMN |  | COLUMN | COLUMN | COLUMN |  | COLUMN | COLUMN | COLUMN |  | BOTTOM GAP | 29 | 19 | 19
 | 1 | 2 | 3 |  | 1 | 2 | 3 |  | 1 | 2 | 3
 | X | X | X |  | X | X | X |  | X | X | X
 | 0 | 8 | 2 | 27 | 0 | 8 | 2 | 11 | 0 | 8 | 2 | 2
 | 0 | 2 | 7 | 26 | 0 | 2 | 7 | 10 | 0 | 2 | 7 | 1
 | 9 | 6 | 4 | 25 | 9 | 6 | 4 | 9 | 9 | 6 | 4
 | 7 | 5 | 4 | 24 | 7 | 5 | 4 | 8 | 7 | 5 | 4 | 19
 | 7 | 5 | 5 | 23 | 7 | 5 | 5 | 7 | 7 | 5 | 5 | 18
 | 8 | 8 | 2 | 22 | 8 | 8 | 2 | 6 | 8 | 8 | 2 | 17
 | 0 | 8 | 1 | 21 | 0 | 8 | 1 | 5 | 0 | 8 | 1 | 16
 | 8 | 6 | 9 | 20 | 8 | 6 | 9 | 4 | 8 | 6 | 9 | 15
 | 1 | 6 | 1 | 19 | 1 | 6 | 1 | 3 | 1 | 6 | 1 | 14
 | 2 | 2 | 3 | 18 | 2 | 2 | 3 | 2 | 2 | 2 | 3 | 13
 | 8 | 2 | 2 | 17 | 8 | 2 | 2 | 1 | 8 | 2 | 2 | 12
 | 8 | 7 | 9 | 16 | 8 | 7 | 9 |  | 8 | 7 | 9 | 11
 | 1 | 9 | 5 | 15 | 1 | 9 | 5 | 19 | 1 | 9 | 5 | 10
 | 6 | 7 | 8 | 14 | 6 | 7 | 8 | 18 | 6 | 7 | 8 | 9
 | 2 | 9 | 5 | 13 | 2 | 9 | 5 | 17 | 2 | 9 | 5 | 8
 | 3 | 2 | 2 | 12 | 3 | 2 | 2 | 16 | 3 | 2 | 2 | 7
 | 5 | 8 | 4 | 11 | 5 | 8 | 4 | 15 | 5 | 8 | 4 | 6
 | 1 | 3 | 9 | 10 | 1 | 3 | 9 | 14 | 1 | 3 | 9 | 5
 | 9 | 8 | 2 | 9 | 9 | 8 | 2 | 13 | 9 | 8 | 2 | 4
 | 1 | 5 | 8 | 8 | 1 | 5 | 8 | 12 | 1 | 5 | 8 | 3
 | 8 | 8 | 0 | 7 | 8 | 8 | 0 | 11 | 8 | 8 | 0 | 2
 | 1 | 5 | 3 | 6 | 1 | 5 | 3 | 10 | 1 | 5 | 3 | 1
 | 4 | 9 | 9 | 5 | 4 | 9 | 9 | 9 | 4 | 9 | 9
 | 0 | 5 | 3 | 4 | 0 | 5 | 3 | 8 | 0 | 5 | 3
 | 9 | 3 | 2 | 3 | 9 | 3 | 2 | 7 | 9 | 3 | 2
 | 0 | 5 | 4 | 2 | 0 | 5 | 4 | 6 | 0 | 5 | 4
 | 3 | 2 | 3 | 1 | 3 | 2 | 3 | 5 | 3 | 2 | 3
 | 9 | 7 | 6 |  | 9 | 7 | 6 | 4 | 9 | 7 | 6
 | 7 | 5 | 1 | 29 | 7 | 5 | 1 | 3 | 7 | 5 | 1
 | 2 | 6 | 8 | 28 | 2 | 6 | 8 | 2 | 2 | 6 | 8
 | 2 | 1 | 4 | 27 | 2 | 1 | 4 | 1 | 2 | 1 | 4
 | 5 | 9 | 4 | 26 | 5 | 9 | 4 |  | 5 | 9 | 4
 | 2 | 5 | 6 | 25 | 2 | 5 | 6 |  | 2 | 5 | 6
 | 5 | 4 | 8 | 24 | 5 | 4 | 8 |  | 5 | 4 | 8
 | 9 | 4 | 4 | 23 | 9 | 4 | 4 |  | 9 | 4 | 4
 | 0 | 8 | 3 | 22 | 0 | 8 | 3 |  | 0 | 8 | 3
 | 9 | 4 | 0 | 21 | 9 | 4 | 0 |  | 9 | 4 | 0
 | 6 | 0 | 0 | 20 | 6 | 0 | 0 |  | 6 | 0 | 0
 | 6 | 8 | 6 | 19 | 6 | 8 | 6 |  | 6 | 8 | 6
 | 6 | 2 | 3 | 18 | 6 | 2 | 3 |  | 6 | 2 | 3
 | 4 | 3 | 7 | 17 | 4 | 3 | 7 |  | 4 | 3 | 7
 | 2 | 3 | 8 | 16 | 2 | 3 | 8 |  | 2 | 3 | 8
 | 3 | 5 | 2 | 15 | 3 | 5 | 2 |  | 3 | 5 | 2
 | 4 | 4 | 8 | 14 | 4 | 4 | 8 |  | 4 | 4 | 8
 | 5 | 6 | 0 | 13 | 5 | 6 | 0 |  | 5 | 6 | 0
 | 5 | 0 | 2 | 12 | 5 | 0 | 2 |  | 5 | 0 | 2
 | 7 | 8 | 4 | 11 | 7 | 8 | 4 |  | 7 | 8 | 4
 | 5 | 0 | 2 | 10 | 5 | 0 | 2 |  | 5 | 0 | 2
 | 8 | 9 | 6 | 9 | 8 | 9 | 6 |  | 8 | 9 | 6
 | 4 | 5 | 4 | 8 | 4 | 5 | 4 |  | 4 | 5 | 4
 | 9 | 9 | 1 | 7 | 9 | 9 | 1 |  | 9 | 9 | 1
 | 9 | 8 | 8 | 6 | 9 | 8 | 8 |  | 9 | 8 | 8
 | 5 | 2 | 3 | 5 | 5 | 2 | 3 |  | 5 | 2 | 3
 | 0 | 3 | 7 | 4 | 0 | 3 | 7 |  | 0 | 3 | 7
 | 2 | 1 | 4 | 3 | 2 | 1 | 4 |  | 2 | 1 | 4
 | 0 | 4 | 6 | 2 | 0 | 4 | 6 |  | 0 | 4 | 6
 | 9 | 5 | 0 | 1 | 9 | 5 | 0 |  | 9 | 5 | 0
 | 9 | 0 | 2 |  | 9 | 0 | 2 |  | 9 | 0 | 2
 | 1 | 1 | 0 |  | 1 | 1 | 0 |  | 1 | 1 | 0
 | 2 | 3 | 4 |  | 2 | 3 | 4 |  | 2 | 3 | 4
 | 7 | 1 | 8 |  | 7 | 1 | 8 |  | 7 | 1 | 8
 | 6 | 7 | 2 |  | 6 | 7 | 2 |  | 6 | 7 | 2