Spreadsheet: 46276d1245175150-fetching-data-from-a-table-holiday-calendar
Sheet: Sheet1

 |  |  | 4 over 7 (3 off max) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 Over 7 (3 off max) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 Over 5 (2 off [NAME]) |  |  |  |  |  |  |  |  |  | Lates (1 Off) |  |  |  |  | Splits (1 or 2 hols) |  |  |  |  |  |  |  | Splits 2 (1 off) |  |  |  |  | Spares (1-2 off)
 |  |  | Astley M 206050 | Bell J 985080 | Booth J 965152 | Dipple K 202100 | [NAME] | Fernandes J 205057 | Goldsmith A 204135 | [NAME] 995051 | Hodgetts K 975080 | McHugh A 200034 | Meadows M 205032 | Pearce M 975048 | [NAME] 207046 | Rudd R 201183 | Seabourne J 965008 | Simmons T 206036 | Sing Gill A 208002 | Smith M 203093 | Smith MJ 208014 | Smith CE 965096 | [NAME] | Tisdale E 901025 | Trahearne A 207006 |  |  |  | Barlow T 208064 | Biggs J 208055 | Brosnan M 208060 | Chater K 200062 | Evason M 209013 | Gill A 208032 | Hammond D 209004 | Horner A 208073 | Humphreys A 202043 | Kopciuch M 208038 | Landsborough P 208037 | Langston A 207000 | Langston G 925065 | Lyder R 209008 | McPeake M 208004 | Porte J 203014 | [NAME] | Scarce C 201202 | Shaw I 204103 | Talbott H 915502 |  |  |  |  | Drakeley G 613315 | Costley W 603989 | Danks I 915114 | Hambleton R 607691 | Jenks R 313627 | [NAME] | Lidgbird A 207000 | Moss A 313523 | Pemberton J 915076 |  |  | Davies M 205015 | Fenemer 945002 | Parker J 201046 | Yeomans L 205085 |  | Barker J 207004 | Davies M 200051 | Harbone C 205020 | Jury S 203034 | [NAME] | Standley A 204081 | [NAME] |  | Goldsmith D 965004 | Parker K 200087 |  |  |  | Shipley K 985502 | [NAME] | [NAME] | Ratcliffe M 209017 | Hilton N 209023 | Murphy P 209027 |  |  |  |  |  |  |  | [NAME]
2009-04-01 00:00:00 | Week 1 | 29
 |  | 30 | H | H
 |  | 31 | H
 |  | 1
 |  | 2
 |  | 3
 |  | 4
 | Week 2 | 5
 |  | 6
 |  | 7
 |  | 8
 |  | 9
 |  | 10
 |  | 11
 | Week 3 | 12
 |  | 13
 |  | 14
 |  | 15
 |  | 16
 |  | 17
 |  | 18
 | Week 4 | 19
 |  | 20
 |  | 21
 |  | 22
 |  | 23
 |  | 24
 |  | 25
2009-05-01 00:00:00 | Week 5 | 26
 |  | 27
 |  | 28
 |  | 29
 |  | 30
 |  | 1
 |  | 2
 | Week 6 | 3
 |  | 4
 |  | 5
 |  | 6
 |  | 7
 |  | 8
 |  | 9
 | Week 7 | 10
 |  | 11
 |  | 12
 |  | 13
 |  | 14
 |  | 15
 |  | 16
 | Week 8 | 17
 |  | 18
 |  | 19
 |  | 20
 |  | 21
 |  | 22
 |  | 23
2009-06-01 00:00:00 | Week 9 | 24
 |  | 25
 |  | 26
 |  | 27
 |  | 28
 |  | 29
 |  | 30
 | Week 10 | 31
 |  | 1
 |  | 2
 |  | 3
 |  | 4
 |  | 5
 |  | 6
 | Week 11 | 7
 |  | 8
 |  | 9
 |  | 10
 |  | 11
 |  | 12
 |  | 13
 | Week 12 | 14
 |  | 15
 |  | 16
 |  | 17
 |  | 18
 |  | 19
 |  | 20
 | Week 13 | 21
 |  | 22
 |  | 23
 |  | 24
 |  | 25
 |  | 26
 |  | 27
2009-07-01 00:00:00 | Week 14 | 28
 |  | 29
 |  | 30
 |  | 1
 |  | 2
 |  | 3
 |  | 4
 | Week 15 | 5
 |  | 6
 |  | 7
 |  | 8
 |  | 9
 |  | 10
 |  | 11
 | Week 16 | 12
 |  | 13
 |  | 14
 |  | 15
 |  | 16
 |  | 17
 |  | 18
 | Week 17 | 19
 |  | 20
 |  | 21
 |  | 22
 |  | 23
 |  | 24
 |  | 25
2009-08-01 00:00:00 | Week 18 | 26
 |  | 27
 |  | 28
 |  | 29
 |  | 30
 |  | 31
 |  | 1
 | Week 19 | 2
 |  | 3
 |  | 4
 |  | 5
 |  | 6
 |  | 7
 |  | 8
 | Week 20 | 9
 |  | 10
 |  | 11
 |  | 12
 |  | 13
 |  | 14
 |  | 15
 | Week 21 | 16
 |  | 17
 |  | 18
 |  | 19
 |  | 20
 |  | 21
 |  | 22
2009-09-01 00:00:00 | Week 22 | 23
 |  | 24
 |  | 25
 |  | 26
 |  | 27
 |  | 28
 |  | 29
 | Week 23 | 30
 |  | 31
 |  | 1
 |  | 2
 |  | 3
 |  | 4
 |  | 5
 | Week 24 | 6
 |  | 7
 |  | 8
 |  | 9
 |  | 10
 |  | 11
 |  | 12
 | Week 25 | 13
 |  | 14
 |  | 15
 |  | 16
 |  | 17
 |  | 18
 |  | 19
 | Week 26 | 20
 |  | 21
 |  | 22
 |  | 23
 |  | 24
 |  | 25
 |  | 26
2009-10-01 00:00:00 | Week 27 | 27
 |  | 28
 |  | 29
 |  | 30
 |  | 1
 |  | 2
 |  | 3
 | Week 28 | 4
 |  | 5
 |  | 6
 |  | 7
 |  | 8
 |  | 9
 |  | 10
 | Week 29 | 11
 |  | 12
 |  | 13
 |  | 14
 |  | 15
 |  | 16
 |  | 17
 | Week 30 | 18
 |  | 19
 |  | 20
 |  | 21
 |  | 22
 |  | 23
 |  | 24
2009-11-01 00:00:00 | Week 31 | 25
 |  | 26
 |  | 27
 |  | 28
 |  | 29
 |  | 30
 |  | 31
 | Week 32 | 1
 |  | 2
 |  | 3
 |  | 4
 |  | 5
 |  | 6
 |  | 7
 | Week 33 | 8
 |  | 9
 |  | 10
 |  | 11
 |  | 12
 |  | 13
 |  | 14
 | Week 34 | 15
 |  | 16
 |  | 17
 |  | 18
 |  | 19
 |  | 20
 |  | 21
2009-12-01 00:00:00 | Week 35 | 22
 |  | 23
 |  | 24
 |  | 25
 |  | 26
 |  | 27
 |  | 28
 | Week 36 | 29
 |  | 30
 |  | 31
 |  | 1
 |  | 2
 |  | 3
 |  | 3
 | Week 37 | 4
 |  | 5
 |  | 6
 |  | 7
 |  | 8
 |  | 9
 |  | 10
 | Week 38 | 11
 |  | 12
 |  | 13
 |  | 14
 |  | 15
 |  | 16
 |  | 17
 | Week 39 | 18
 |  | 19
 |  | 20
 |  | 21
 |  | 22
 |  | 23
 |  | 24
2010-01-01 00:00:00 | Week 40 | 25
 |  | 26
 |  | 27
 |  | 28
 |  | 29
 |  | 30
 |  | 31
 | Week 41 | 1
 |  | 2
 |  | 3
 |  | 4
 |  | 5
 |  | 6
 |  | 7
 | Week 42 | 8
 |  | 9
 |  | 10
 |  | 11
 |  | 12
 |  | 13
 |  | 14
 | Week 43 | 15
 |  | 16
 |  | 17
 |  | 18
 |  | 19
 |  | 20
 |  | 21
2010-02-01 00:00:00 | Week 44 | 22
 |  | 23
 |  | 24
 |  | 25
 |  | 26
 |  | 27
 |  | 28
 | Week 45 | 29
 |  | 30
 |  | 31
 |  | 1
 |  | 2
 |  | 3
 |  | 4
 | Week 46 | 5
 |  | 6
 |  | 7
 |  | 8
 |  | 9
 |  | 10
 |  | 11
 | Week 47 | 12
 |  | 13
 |  | 14
 |  | 15
 |  | 16
 |  | 17
 |  | 18
2010-03-01 00:00:00 | Week 48 | 19
 |  | 20
 |  | 21
 |  | 22
 |  | 23
 |  | 24
 |  | 25
 | Week 49 | 26
 |  | 27
 |  | 28
 |  | 1
 |  | 2
 |  | 3
 |  | 4
 | Week 50 | 5
 |  | 6
 |  | 7
 |  | 8
 |  | 9
 |  | 10
 |  | 11
 | Week 51 | 12
 |  | 13
 |  | 14
 |  | 15
 |  | 16
 |  | 17
 |  | 18
 | Week 52 | 19
 |  | 20
 |  | 21
 |  | 22
 |  | 23
 |  | 24
 |  | 25