Spreadsheet: 466453d1466188013-create-formula-based-on-w-l-book11
Sheet: System

GR1 | Skip Count |  |  | GR2 | Skip Count |  |  | GR3 | Skip Count |  | Order |  | [NAME] A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  | Before |  |  |  | After |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Before |  |  |  | After
L | 0 |  |  | W | 1 |  |  | L |  |  | ABA |  | 20 |  |  |  | 20 | 10 |  |  | 10 on GR1 and 10 on GR3// Both Loss move half loss to labby B |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20 |  |  |  | x | 10 |  | 20 on GR2//Won
W | 1 |  |  |  | 1 |  |  | W |  |  | BA |  | 20 | 10 |  |  | x | x |  |  | 30 on GR1// Won |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10 |  |  |  | x |  |  | 10 on GR3//Won
 | 1 |  |  |  | 1 |  |  |  |  |  |  |  | NB |  |  |  | NB |  |  |  | All lines cleaGR1 with non remaining//new lines |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NB |  |  |  | NB
 | 1 |  |  |  | 1 |  |  |  |  |  |  |  | NB |  |  |  | NB |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NB |  |  |  | NB
 | 1 |  |  |  | 1 |  |  |  |  |  |  |  | NB |  |  |  | NB |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NB |  |  |  | NB
L | 0 |  |  | W | 1 |  |  | W |  |  | BAB |  | 20 |  |  |  | x |  |  |  | 20 on GR2// Won…cleaGR1 new line |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20 |  |  |  | 20 |  |  | 10 on GR1 and 10 on GR3// 1Win,1 Loss stays the same
W | 1 |  |  |  | 1 |  |  |  |  |  | A |  | 20 |  |  |  | x |  |  |  | 20 on GR1// Won…cleaGR1 new line |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NB |  |  |  | NB
 | 1 |  |  |  | 1 |  |  |  |  |  |  |  | NB |  |  |  | NB |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NB |  |  |  | NB
 | 1 |  |  |  | 1 |  |  |  |  |  |  |  | NB |  |  |  | NB |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NB |  |  |  | NB
 | 1 |  |  |  | 1 |  |  |  |  |  |  |  | NB |  |  |  | NB |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NB |  |  |  | NB
L | 0 |  |  | L | 0 |  |  | L |  |  | BAB |  | 20 |  |  |  | 20 | 20 |  |  | 20 on GR2//Loss move half to line 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20 |  |  |  | 20 | 20 |  | 10 on GR1 and 10 on GR3// Both Loss move half to line 1
W | 1 |  |  | W | 1 |  |  | L |  |  | ABA |  | 20 | 20 |  |  | 20 | 20 |  |  | 20 on GR1 and 20 on GR3// 1 Win and 1 Loss , stays the same |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20 | 20 |  |  | x | x |  | 40 on GR2//Won
 | 1 |  |  |  | 1 |  |  | L |  |  | B |  | NB |  |  |  | NB |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20 |  |  |  | 20 | 10 |  | 20 on GR3//Loss move half to line 1
 | 1 |  |  |  | 1 |  |  | L |  |  | A |  | 20 | 20 | 10 |  | 22 | 22 | 22 |  | 30 on GR3// Loss , Half to line 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NB |  |  |  | NB
 | 1 |  |  |  | 1 |  |  | L |  |  | B |  | NB |  |  |  | NB |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20 | 10 | 15 |  | 21 | 21 | 21 | 35 on GR3//Loss move half to line 1
W | 1 |  |  | W | 1 |  |  | L |  |  | ABA |  | 28 | 28 | 28 |  | 28 | 28 | 28 |  | 28 on GR1 and 28 on GR3// 1 Win and 1 Loss , stays the same |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 21 | 21 | 21 |  | x | 21 | x | 42 on GR2//won
 | 1 |  |  |  | 1 |  |  | L |  |  | B |  | NB |  |  |  | NB |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 21 |  |  |  | 21 | 11 |  | 21 on GR3//Loss half to line 1
 | 1 |  |  |  | 1 |  |  | L |  |  | A |  | 32 | 32 | 32 |  | 43 | 43 | 43 |  | 64 on GR3// Loss , Half to line 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NB |  |  |  | NB
 | 1 |  |  |  | 1 |  |  | L |  |  | B |  | NB |  |  |  | NB |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 21 | 11 | 32 |  | 30 | 30 | 30 | 53 on GR3//Loss half to line 1
 | 1 |  |  |  | 1 |  |  | L |  |  | A |  | 52 | 52 | 52 |  | 69 | 69 | 69 |  | 104 on GR3// Loss , Half to line 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NB |  |  |  | NB
L | 0 |  |  | L | 0 |  |  | W |  |  | BAB |  | 69 | 69 | 69 |  | 92 | 92 | 92 |  | 138 on GR2// Loss , Half to line 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 48 | 48 | 48 |  | 48 | 48 | 48 | 48 on GR1 & 48 on GR3//1Win,1 Loss stays same
W | 1 |  |  | L | 0 |  |  |  |  |  | AB |  | 92 | 92 | 92 |  | x | 92 | x |  | 184 on GR1// Won |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 71 | 71 | 71 |  | 95 | 95 | 95 | 142 on GR2//Loss half to line 1
 | 1 |  |  | L | 0 |  |  |  |  |  | A |  | 92 | 71 |  |  | 92 | 71 | 82 |  | 163 on GR2// loss |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NB |  |  |  | NB
 | 1 |  |  | W | 1 |  |  |  |  |  | B |  | NB |  |  |  | NB |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 122 | 122 | 122 |  | x | 122 | x | 244 on GR2//won
 | 1 |  |  |  | 1 |  |  |  |  |  |  |  | NB |  |  |  | NB |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NB |  |  |  | NB
L | 0 |  |  | L | 0 |  |  | W |  |  | ABA |  | 82 | 82 | 82 |  | 82 | 82 | 82 |  | 82 on GR1 and 82 on GR3// 1 Win and 1 Loss , stays the same |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 122 |  |  |  | 122 | 61 |  | 122 on GR2//loss half to 1
L | 0 |  |  | L | 0 |  |  |  |  |  | BA |  | 102 | 102 | 102 |  | 136 | 136 | 136 |  | 102 on GR1 // Loss , Half to line 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 122 | 61 |  |  | 122 | 61 | 92 | 183 on GR2//loss half to 1
L | 0 |  |  | L | 0 |  |  |  |  |  | BA |  | 167 | 167 | 167 |  | 223 | 223 | 223 |  | 334 on GR2 // Loss , Half to line 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 126 | 126 | 126 |  | 224 | 224 | 224 | 252 on GR1//loss half to 1
W | 1 |  |  | W | 1 |  |  |  |  |  | BA |  | 265 | 265 | 265 |  | x | 265 | x |  | 530 on GR2 // Won |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 224 | 224 | 224 |  | x | 224 | x | 448 on GR1//won
 | 1 |  |  |  | 1 |  |  |  |  |  |  |  | NB |  |  |  | NB |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NB |  |  |  | NB
W | 1 |  |  | W | 1 |  |  | W |  |  | BAB |  | 265 |  |  |  | x |  |  |  | 265 on GR2 // Won |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 224 |  |  |  | x |  |  | 112 on GR1 & 112 on GR3//both win
 | 1 |  |  |  | 1 |  |  |  |  |  |  |  | NB |  |  |  | NB |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NB |  |  |  | NB
 | 1 |  |  |  | 1 |  |  |  |  |  |  |  | NB |  |  |  | NB |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NB |  |  |  | NB
 | 1 |  |  |  | 1 |  |  |  |  |  |  |  | NB |  |  |  | NB |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NB |  |  |  | NB
 | 1 |  |  |  | 1 |  |  |  |  |  |  |  | NB |  |  |  | NB |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NB |  |  |  | NB