Spreadsheet: 151425d1334913366-help-needed-from-excel-gurus-in-formulating-a-table-example
Sheet: Sheet1

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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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