Spreadsheet: 151960d1335197182-help-needed-from-excel-gurus-in-formulating-a-table-sbusdps-table
Sheet: Sheet1

 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48 | 49 | 50 | 51 | 52 | 53 | 54 | 55 |  | -0.001 | 30 | Miss 30 or more with letter N end up _0.1% sse in colimn Bi
Rank | Name | 2011-04-14 00:00:00 | 2011-04-21 00:00:00 | 2011-04-28 00:00:00 | 2011-05-05 00:00:00 | 2011-05-12 00:00:00 | 2011-05-19 00:00:00 | 2011-05-26 00:00:00 | 2011-06-02 00:00:00 | 2011-06-09 00:00:00 | 2011-06-16 00:00:00 | 2011-06-23 00:00:00 | 2011-06-30 00:00:00 | 2011-07-07 00:00:00 | 2011-07-14 00:00:00 | 2011-07-21 00:00:00 | 2011-07-28 00:00:00 | 2011-08-04 00:00:00 | 2011-08-11 00:00:00 | 2011-08-18 00:00:00 | 2011-08-25 00:00:00 | 2011-09-01 00:00:00 | 2011-09-08 00:00:00 | 2011-09-15 00:00:00 | 2011-09-22 00:00:00 | 2011-09-29 00:00:00 | 2011-10-06 00:00:00 | 2011-10-13 00:00:00 | 2011-10-20 00:00:00 | 2011-10-27 00:00:00 | 2011-11-03 00:00:00 | 2011-11-10 00:00:00 | 2011-11-17 00:00:00 | 2011-11-24 00:00:00 | 2011-12-01 00:00:00 | 2011-12-08 00:00:00 | 2011-12-15 00:00:00 | 2011-12-22 00:00:00 | 2011-12-29 00:00:00 | 2012-01-05 00:00:00 | 2012-01-12 00:00:00 | 2012-01-19 00:00:00 | 2012-01-26 00:00:00 | 2012-02-02 00:00:00 | 2012-02-09 00:00:00 | 2012-02-16 00:00:00 | 2012-02-23 00:00:00 | 2012-03-01 00:00:00 | 2012-03-08 00:00:00 | 2012-03-15 00:00:00 | 2012-03-22 00:00:00 | 2012-03-29 00:00:00 | 2012-04-05 00:00:00 | 2012-04-12 00:00:00 | 2012-04-19 00:00:00 | Win | Draw | Lost | N | % | %
1 | Name 1 | L | W |  |  | N | W | W | W |  | W | N | N | W | L | D | D | W | W | W | L | W | W | N | W | W | D | L | N | D | N | N | N | N | N | W |  |  |  | W | L | L | W |  |  | N | N | N | N | N | N | N | N | N | L | 16 | 4 | 7 | 19 | 0.6956521739130435 | 0.6956521739130435
6 | Name 2 | L | L |  |  | N | L | N | N |  | W | W | N | N | W | D | N | N | L | W | W | W | W | N | W | N | D | W | N | D | N | L | L | N | L | N |  |  |  | L | L | W | W |  |  | L | N | N | W | N | L | W | N | N | N | 13 | 3 | 11 | 19 | 0.5416666666666666 | 0.5416666666666666
7 | Name 3 | W | N |  |  | L | W | N | N |  | L | W | N | W | W | D | D | W | N | N | L | N | N | W | L | N | N | W | L | D | N | N | L | W | N | N |  |  |  | L | W | L | W |  |  | L | L | N | N | L | L | W | L | W | W | 14 | 3 | 13 | 16 | 0.5185185185185185 | 0.5185185185185185
8 | Name 4 | W | W |  |  | L | L | W | L |  | L | L | L | W | N | D | N | W | N | L | N | N | L | N | N | L | N | L | L | N | W | L | N | L | W | W |  |  |  | W | W | N | L |  |  | N | N | W | N | W | W | N | W | L | N | 14 | 1 | 15 | 16 | 0.4827586206896552 | 0.4827586206896552
14 | Name 5 | L | N |  |  | W | L | L | W |  | L | N | N | L | L | D | D | N | L | W | L | L | N | W | W | N | D | N | L | D | L | L | W | L | L | L |  |  |  | W | L | L | L |  |  | N | N | N | N | N | L | L | N | L | W | 8 | 4 | 21 | 13 | 0.2758620689655172 | 0.2758620689655172
9 | Name 6 | W | N |  |  | N | W | L | L |  | L | W | W | L | L | N | D | L | W | L | W | W | W | L | W | W | N | W | W | D | L | L | L | N | L | L |  |  |  | N | N | N | N |  |  | N | N | N | N | N | N | N | N | N | N | 12 | 2 | 13 | 19 | 0.48 | 0.48
12 | Name 7 | L | L |  |  | L | W | L | N |  | L | L | N | W | W | N | N | L | W | L | W | N | N | L | N | N | D | W | L | D | N | W | N | N | N | N |  |  |  | N | N | N | N |  |  | N | N | N | N | N | N | W | L | N | N | 8 | 2 | 11 | 25 | 0.4210526315789473 | 0.4210526315789473
5 | Name 8 | W | W |  |  | N | N | N | N |  | N | W | W | L | W | N | N | N | N | L | L | L | L | N | L | L | D | N | W | D | N | N | W | W | W | W |  |  |  | N | N | W | L |  |  | W | W | L | W | W | W | L | W | L | L | 17 | 2 | 12 | 15 | 0.5862068965517241 | 0.5862068965517241
10 | Name 9 | N | W |  |  | W | N | W | L |  | W | N | L | L | L | N | D | L | N | N | W | N | W | W | N | L | D | L | N | N | L | W | L | W | W | N |  |  |  | W | W | N | W |  |  | L | L | W | L | N | N | L | L | L | L | 14 | 2 | 16 | 14 | 0.4666666666666667 | 0.4666666666666667
21 | Name 10 | N | N |  |  | W | L | N | N |  | N | N | W | N | L | N | D | N | L | N | N | N | N | N | N | N | N | L | W | N | W | L | N | N | L | N |  |  |  | N | W | W | W |  |  | N | N | N | N | N | N | N | N | N | N | 7 | 1 | 6 | 32 | -0.001 | 0.5384615384615384
28 | Name 11 | N | N |  |  | N | N | N | N |  | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N |  |  |  | N | N | N | N |  |  | N | N | N | N | N | N | N | N | N | N | 0 | 0 | 0 | 46 | -0.001 | 0
13 | Name 12 | N | L |  |  | N | N | N | W |  | N | L | W | N | N | N | D | L | N | L | N | N | L | N | N | W | D | L | N | N | N | W | N | L | N | W |  |  |  | N | N | N | L |  |  | N | L | L | L | W | W | L | W | N | N | 8 | 2 | 12 | 24 | 0.4 | 0.4
4 | Name 13 | N | N |  |  | L | L | L | W |  | W | W | N | L | N | N | N | N | N | N | N | L | L | N | N | W | N | N | N | N | N | N | W | W | W | N |  |  |  | W | L | N | N |  |  | L | W | W | N | L | W | N | N | W | W | 13 | 0 | 9 | 24 | 0.5909090909090909 | 0.5909090909090909
2 | Name 14 | L | L |  |  | W | W | N | W |  | N | N | W | N | N | D | N | L | W | W | W | W | N | N | W | N | D | N | N | D | L | W | N | W | N | N |  |  |  | L | W | N | N |  |  | W | N | L | W | L | N | N | N | L | L | 14 | 3 | 9 | 20 | 0.6086956521739131 | 0.6086956521739131
11 | Name 15 | W | L |  |  | N | N | W | L |  | W | L | N | W | N | D | D | W | N | N | L | N | N | N | N | N | N | N | W | N | W | W | W | L | N | L |  |  |  | L | L | W | N |  |  | W | L | L | L | W | N | L | L | N | L | 12 | 2 | 14 | 18 | 0.4615384615384616 | 0.4615384615384616
3 | Name 16 | N | N |  |  | N | N | N | N |  | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | W | W | D | L | N | W | L | L | L |  |  |  | N | N | L | L |  |  | W | W | W | W | N | N | W | N | N | W | 9 | 1 | 6 | 30 | 0.6 | 0.6
15 | Name 17 | N | N |  |  | N | N | N | N |  | N | N | N | N | N | D | N | N | N | W | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N |  |  |  | N | N | N | N |  |  | N | N | N | N | N | N | N | N | N | N | 1 | 1 | 0 | 44 | -0.001 | 1
18 | Name 18 | N | W |  |  | N | N | N | N |  | N | N | N | N | W | N | D | N | N | N | N | L | W | N | N | N | N | N | N | N | N | N | N | N | N | N |  |  |  | N | N | N | N |  |  | N | W | N | N | N | L | N | N | N | N | 4 | 1 | 2 | 39 | -0.001 | 0.6666666666666666
28 | Name 19 | N | N |  |  | L | N | N | N |  | N | N | N | N | N | N | N | N | N | N | N | N | N | L | N | N | N | N | N | N | N | N | N | N | N | N |  |  |  | N | N | N | N |  |  | N | N | N | N | N | N | N | N | N | N | 0 | 0 | 2 | 44 | -0.001 | 0
22 | Name 20 | N | N |  |  | N | N | W | L |  | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N |  |  |  | N | N | N | N |  |  | N | N | N | N | N | N | N | N | N | N | 1 | 0 | 1 | 44 | -0.001 | 0.5
22 | Name 21 | N | N |  |  | W | N | L | N |  | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N |  |  |  | N | N | N | N |  |  | N | N | N | N | N | N | N | N | N | N | 1 | 0 | 1 | 44 | -0.001 | 0.5
20 | Name 22 | N | N |  |  | N | N | N | N |  | N | N | L | N | N | D | N | W | N | N | N | N | N | N | L | L | N | N | N | N | N | N | N | N | N | N |  |  |  | L | N | W | N |  |  | W | N | L | W | N | L | W | W | W | W | 8 | 1 | 6 | 31 | -0.001 | 0.5714285714285714
26 | Name 23 | N | N |  |  | N | N | N | N |  | N | L | L | N | N | N | D | N | L | N | N | W | N | N | L | W | D | N | L | N | N | N | N | N | W | N |  |  |  | N | N | N | N |  |  | N | N | N | N | L | N | N | N | N | N | 3 | 2 | 6 | 35 | -0.001 | 0.3333333333333333
27 | Name 24 | N | N |  |  | N | N | N | N |  | N | N | N | N | N | D | N | N | L | N | N | L | N | L | N | L | D | N | N | N | W | N | N | N | N | L |  |  |  | N | N | N | N |  |  | L | W | W | L | N | N | N | N | N | N | 3 | 2 | 7 | 34 | -0.001 | 0.3
22 | Name 25 | N | N |  |  | N | N | N | N |  | N | N | L | N | N | N | N | N | N | N | N | N | L | W | N | N | N | N | N | N | N | N | N | N | N | N |  |  |  | N | N | N | N |  |  | N | N | N | N | N | N | N | W | N | N | 2 | 0 | 2 | 42 | -0.001 | 0.5
18 | Name 26 | N | N |  |  | N | N | N | N |  | N | N | N | N | N | N | N | N | W | N | N | N | N | N | L | N | N | N | N | N | N | N | N | N | N | N |  |  |  | N | N | N | N |  |  | N | N | N | L | W | W | N | N | W | N | 4 | 0 | 2 | 40 | -0.001 | 0.6666666666666666
15 | Name 27 | N | N |  |  | N | N | N | N |  | N | N | N | N | N | N | N | N | N | N | N | N | N | W | N | N | N | N | N | N | N | N | N | N | N | N |  |  |  | N | N | N | N |  |  | N | N | N | N | N | N | N | N | N | N | 1 | 0 | 0 | 45 | -0.001 | 1
15 | Name 28 | N | N |  |  | N | N | N | N |  | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | D | W | N | N | N | N | N |  |  |  | N | N | N | N |  |  | N | N | N | N | N | N | N | N | N | N | 1 | 1 | 0 | 44 | -0.001 | 1
28 | Name 29 | N | N |  |  | N | N | N | N |  | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | L | N | N | N |  |  |  | N | N | N | N |  |  | N | N | N | N | N | N | N | N | N | N | 0 | 0 | 1 | 45 | -0.001 | 0
22 | Name 30 | N | N |  |  | N | N | N | N |  | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | W |  |  |  | N | N | L | N |  |  | N | N | N | N | N | N | N | N | N | N | 1 | 0 | 1 | 44 | -0.001 | 0.5
 | Name 1
 | Name 14 | L-L | W-L | - | - | N-W | W-W | W-N | W-W | - | W-N | N-N | N-W | W-N | L-N | D-D | D-N | W-L | W-W | W-W | L-W | W-W | W-N | N-N | W-W | W-N | D-D | L-N | N-N | D-D | N-L | N-W | N-N | N-W | N-N | W-N | - | - | - | W-L | L-W | L-N | W-N | - | - | N-W | N-N | N-L | N-W | N-L | N-N | N-N | N-N | N-L | L-L
 | Play together
 | W-W | 6
 | D-D | 3 | It this what you looking for?
 | L-L | 2
 | N-N | 9
Leaderboard
Rank | Names | % | N
1 | Name 1 | 0.6956521739130435 | 19
2 | Name 14 | 0.6086956521739131 | 20
3 | Name 16 | 0.6 | 30
4 | Name 13 | 0.5909090909090909 | 24
5 | Name 8 | 0.5862068965517241 | 15
6 | Name 2 | 0.5416666666666666 | 19
7 | Name 3 | 0.5185185185185185 | 16
8 | Name 4 | 0.4827586206896552 | 16
9 | Name 6 | 0.48 | 19
10 | Name 9 | 0.4666666666666667 | 14
11 | Name 15 | 0.4615384615384616 | 18
12 | Name 7 | 0.4210526315789473 | 25
13 | Name 12 | 0.4 | 24
14 | Name 5 | 0.2758620689655172 | 13
15 | Name 17 | 1 | 44
15 | Name 27 | 1 | 45
15 | Name 28 | 1 | 44
18 | Name 18 | 0.6666666666666666 | 39
18 | Name 26 | 0.6666666666666666 | 40
20 | Name 22 | 0.5714285714285714 | 31
21 | Name 10 | 0.5384615384615384 | 32 |  | Letter N Miss more than 30 or more drop down leaderboard as you can see rank 15 to 28
22 | Name 20 | 0.5 | 44 |  | Cell BG1 You can change the number what ever you want with leaderboard Rank.
22 | Name 21 | 0.5 | 44
22 | Name 25 | 0.5 | 42
22 | Name 30 | 0.5 | 44
26 | Name 23 | 0.3333333333333333 | 35
27 | Name 24 | 0.3 | 34
28 | Name 11 | 0 | 46
28 | Name 19 | 0 | 44
28 | Name 29 | 0 | 45