Spreadsheet: 77407d1277898381-schedule-based-on-given-criteria-test2
Sheet: Sheet1

Group A |  |  |  |  | Group B |  |  |  |  |  |  |  |  |  |  |  | # of Teams/Group | # of Match/Team/Group | Total Matches
# of Teams | Team | [NAME] by Each Team |  |  | # of Teams | Team | [NAME] by Each Team |  |  |  |  |  |  |  |  |  | 8 | 7
1 | A1 |  |  |  | 1 | B1 |  |  |  | # of Teams In Group A |  |  |  |  |  |  | 7 | 6
2 | A2 |  |  |  | 2 | B2 |  |  |  |  |  |  |  |  |  |  | 6 | 5
3 | A3 |  |  |  | 3 | B3 |  |  |  | # of Teams In Group B |  |  |  |  |  |  | 5 | 4
4 | A4 |  |  |  | 4 | B4 |  |  |  |  |  |  |  |  |  |  | 4 | 3
5 | A5 |  |  |  | 5 | B5 |  |  |  |  |  |  |  |  |  |  | 3 | 2
6 | A6 |  |  |  | 6 | B6
7 | A7 |  |  |  | 7 | B7
8 | A8 |  |  |  | 8 | B8
Total Matches of Group (A & B) |  |  |  |  |  |  |  | Group A Matches |  |  |  |  |  | Group B Matches
Match | Team 1 | Team 2 | Group | Plan Date | Actual Date |  |  | Match | Team 1 | Team 2 | Plan Date | Actual Date |  | Match | Team 1 | Team 2 | Plan Date | Actual Date
1 | A1 | A2 | A | 2010-07-07 00:00:00 |  |  |  | 1 | A1 | A2 | 2010-07-07 00:00:00 |  |  | 1 | B1 | B2 | 2010-07-07 00:00:00
2 | A1 | A3 | A | 2010-07-08 00:00:00 |  |  |  | 2 | A1 | A3 | 2010-07-08 00:00:00 |  |  | 2 | B1 | B3 | 2010-07-08 00:00:00
3 | A1 | A4 | A | 2010-07-09 00:00:00 |  |  |  | 3 | A1 | A4 | 2010-07-09 00:00:00 |  |  | 3 | B1 | B4 | 2010-07-09 00:00:00
4 | A1 | A5 | A | 2010-07-10 00:00:00 |  |  |  | 4 | A1 | A5 | 2010-07-10 00:00:00 |  |  | 4 | B1 | B5 | 2010-07-10 00:00:00
5 | A1 | A6 | A | 2010-07-11 00:00:00 |  |  |  | 5 | A1 | A6 | 2010-07-11 00:00:00 |  |  | 5 | B1 | B6 | 2010-07-11 00:00:00
6 | A1 | A7 | A | 2010-07-12 00:00:00 |  |  |  | 6 | A1 | A7 | 2010-07-12 00:00:00 |  |  | 6 | B1 | B7 | 2010-07-12 00:00:00
7 | A1 | A8 | A | 2010-07-13 00:00:00 |  |  |  | 7 | A1 | A8 | 2010-07-13 00:00:00 |  |  | 7 | B1 | B8 | 2010-07-13 00:00:00
8 | A2 | A3 | A | 2010-07-14 00:00:00 |  |  |  | 8 | A2 | A3 | 2010-07-14 00:00:00 |  |  | 8 | B2 | B3 | 2010-07-14 00:00:00
9 | A2 | A4 | A | 2010-07-15 00:00:00 |  |  |  | 9 | A2 | A4 | 2010-07-15 00:00:00 |  |  | 9 | B2 | B4 | 2010-07-15 00:00:00
10 | A2 | A5 | A | 2010-07-16 00:00:00 |  |  |  | 10 | A2 | A5 | 2010-07-16 00:00:00 |  |  | 10 | B2 | B5 | 2010-07-16 00:00:00
11 | A2 | A6 | A | 2010-07-17 00:00:00 |  |  |  | 11 | A2 | A6 | 2010-07-17 00:00:00 |  |  | 11 | B2 | B6 | 2010-07-17 00:00:00
12 | A2 | A7 | A | 2010-07-18 00:00:00 |  |  |  | 12 | A2 | A7 | 2010-07-18 00:00:00 |  |  | 12 | B2 | B7 | 2010-07-18 00:00:00
13 | A2 | A8 | A | 2010-07-19 00:00:00 |  |  |  | 13 | A2 | A8 | 2010-07-19 00:00:00 |  |  | 13 | B2 | B8 | 2010-07-19 00:00:00
14 | A3 | A4 | A | 2010-07-20 00:00:00 |  |  |  | 14 | A3 | A4 | 2010-07-20 00:00:00 |  |  | 14 | B3 | B4 | 2010-07-20 00:00:00
15 | A3 | A5 | A | 2010-07-21 00:00:00 |  |  |  | 15 | A3 | A5 | 2010-07-21 00:00:00 |  |  | 15 | B3 | B5 | 2010-07-21 00:00:00
16 | A3 | A6 | A | 2010-07-22 00:00:00 |  |  |  | 16 | A3 | A6 | 2010-07-22 00:00:00 |  |  | 16 | B3 | B6 | 2010-07-22 00:00:00
17 | A3 | A7 | A | 2010-07-23 00:00:00 |  |  |  | 17 | A3 | A7 | 2010-07-23 00:00:00 |  |  | 17 | B3 | B7 | 2010-07-23 00:00:00
18 | A3 | A8 | A | 2010-07-24 00:00:00 |  |  |  | 18 | A3 | A8 | 2010-07-24 00:00:00 |  |  | 18 | B3 | B8 | 2010-07-24 00:00:00
19 | A4 | A5 | A | 2010-07-25 00:00:00 |  |  |  | 19 | A4 | A5 | 2010-07-25 00:00:00 |  |  | 19 | B4 | B5 | 2010-07-25 00:00:00
20 | A4 | A6 | A | 2010-07-26 00:00:00 |  |  |  | 20 | A4 | A6 | 2010-07-26 00:00:00 |  |  | 20 | B4 | B6 | 2010-07-26 00:00:00
21 | A4 | A7 | A | 2010-07-27 00:00:00 |  |  |  | 21 | A4 | A7 | 2010-07-27 00:00:00 |  |  | 21 | B4 | B7 | 2010-07-27 00:00:00
22 | A4 | A8 | A | 2010-07-28 00:00:00 |  |  |  | 22 | A4 | A8 | 2010-07-28 00:00:00 |  |  | 22 | B4 | B8 | 2010-07-28 00:00:00
23 | A5 | A6 | A | 2010-07-29 00:00:00 |  |  |  | 23 | A5 | A6 | 2010-07-29 00:00:00 |  |  | 23 | B5 | B6 | 2010-07-29 00:00:00
24 | A5 | A7 | A | 2010-07-30 00:00:00 |  |  |  | 24 | A5 | A7 | 2010-07-30 00:00:00 |  |  | 24 | B5 | B7 | 2010-07-30 00:00:00
25 | A5 | A8 | A | 2010-07-31 00:00:00 |  |  |  | 25 | A5 | A8 | 2010-07-31 00:00:00 |  |  | 25 | B5 | B8 | 2010-07-31 00:00:00
26 | A6 | A7 | A | 2010-08-01 00:00:00 |  |  |  | 26 | A6 | A7 | 2010-08-01 00:00:00 |  |  | 26 | B6 | B7 | 2010-08-01 00:00:00
27 | A6 | A8 | A | 2010-08-02 00:00:00 |  |  |  | 27 | A6 | A8 | 2010-08-02 00:00:00 |  |  | 27 | B6 | B8 | 2010-08-02 00:00:00
28 | A7 | A8 | A | 2010-08-03 00:00:00 |  |  |  | 28 | A7 | A8 | 2010-08-03 00:00:00 |  |  | 28 | B7 | B8 | 2010-08-03 00:00:00
29 | B1 | B2 | B | 2010-07-07 00:00:00
30 | B1 | B3 | B | 2010-07-08 00:00:00
31 | B1 | B4 | B | 2010-07-09 00:00:00
32 | B1 | B5 | B | 2010-07-10 00:00:00
33 | B1 | B6 | B | 2010-07-11 00:00:00
34 | B1 | B7 | B | 2010-07-12 00:00:00
35 | B1 | B8 | B | 2010-07-13 00:00:00
36 | B2 | B3 | B | 2010-07-14 00:00:00
37 | B2 | B4 | B | 2010-07-15 00:00:00
38 | B2 | B5 | B | 2010-07-16 00:00:00
39 | B2 | B6 | B | 2010-07-17 00:00:00
40 | B2 | B7 | B | 2010-07-18 00:00:00
41 | B2 | B8 | B | 2010-07-19 00:00:00
42 | B3 | B4 | B | 2010-07-20 00:00:00
43 | B3 | B5 | B | 2010-07-21 00:00:00
44 | B3 | B6 | B | 2010-07-22 00:00:00
45 | B3 | B7 | B | 2010-07-23 00:00:00
46 | B3 | B8 | B | 2010-07-24 00:00:00
47 | B4 | B5 | B | 2010-07-25 00:00:00
48 | B4 | B6 | B | 2010-07-26 00:00:00
49 | B4 | B7 | B | 2010-07-27 00:00:00
50 | B4 | B8 | B | 2010-07-28 00:00:00
51 | B5 | B6 | B | 2010-07-29 00:00:00
52 | B5 | B7 | B | 2010-07-30 00:00:00
53 | B5 | B8 | B | 2010-07-31 00:00:00
54 | B6 | B7 | B | 2010-08-01 00:00:00
55 | B6 | B8 | B | 2010-08-02 00:00:00
56 | B7 | B8 | B | 2010-08-03 00:00:00