Spreadsheet: 844987d1696569771-how-do-i-make-a-dynamic-dropdown-list-file-included-help
Sheet: List

PH
LOCATIONS |  |  | LATEST | LATEST | Area | 1 - 3 Sep | 4 - 10 Sep | 11 - 17 Sep | 18 - 24 Sep | 25 - 30 Sep | 1 Oct | 2 - 8 Oct
 | MODE / SPOT | Remarks | START | END
 |  |  | TIME | TIME
West 1 | Mode 1 | NA | 11.30 AM | 8.30 PM | West | Y | Y | Y | Y | Y | Y | Y
North 1 | Mode 2 | NA | 11.30 AM | 8.30 PM | North |  |  | Y | Y | Y |  | Y
South 1 | Mode 3 | NA | 11.30 AM | 8.30 PM | South | Y | Y | Y | Y | Y | Y | Y
East 1 | Mode 4 | NA | 11.30 AM | 7.30 PM | East |  | Y | Y | Y | Y | Y | Y
Central 1 | Mode 5 | NA | 11.30 AM | 8.30 PM | Central | Y | Y | Y | Y | Y | Y | Y
West 2 | Mode 6 | NA | 11.30 AM | 8.30 PM | West | Y | Y | Y | Y | Y | Y | Y
North 2 | Mode 7 | NA | 11.30 AM | 8.30 PM | North | Y | Y | Y | Y | Y | Y | Y
South 2 | Mode 8 | NA | 12.00 PM | 9.00 PM | South
East 2 | Mode 9 | NA | 12.00 PM | 9.00 PM | East
Central 2 | Mode 10 | NA | 12.00 PM | 9.00 PM | Central |  | Y | Y |  | Y | Y
West 3 | Mode 11 | NA | 12.00 PM | 9.00 PM | West
North 3 | Mode 12 | NA | 12.00 PM | 9.00 PM | North
South 3 | Mode 13 | NA | 12.00 PM | 9.00 PM | South
East 3 | Mode 14 | NA | 12.00 PM | 9.00 PM | East |  |  |  | Y | Y |  | Y
Central 3 | Mode 15 | NA | 12.00 PM | 9.00 PM | Central |  |  |  | Y | Y |  | Y
West 4 | Mode 16 | NA | 12.00 PM | 9.00 PM | West | Y |  | Y | Y | Y |  | Y
North 4 | Mode 17 | NA | 12.00 PM | 9.00 PM | North
South 4 | Mode 18 | NA | 12.00 PM | 9.00 PM | South
East 4 | Mode 19 | NA | 12.00 PM | 9.00 PM | East |  |  |  | Y | Y |  | Y
Central 4 | Mode 20 | NA | 12.00 PM | 9.00 PM | Central |  |  | Y | Y |  |  | Y
West 5 | Mode 21 | NA | 12.00 PM | 9.00 PM | West |  |  | Y | Y |  |  | Y
North 5 | Mode 22 | NA | 12.00 PM | 9.00 PM | North |  |  |  |  | Y
South 5 | Mode 23 | NA | 12.00 PM | 9.00 PM | South |  |  | Y | Y | Y |  | Y
East 5 | Mode 24 | NA | 12.00 PM | 9.00 PM | East |  |  |  | Y | Y |  | Y
Central 5 | Mode 25 | NA | 12.00 PM | 9.00 PM | Central |  |  | Y | Y | Y |  | Y
West 6 | Mode 26 | NA | 12.00 PM | 9.00 PM | West |  |  | Y |  | Y
North 6 | Mode 27 | NA | 12.00 PM | 9.00 PM | North |  |  | Y |  | Y
South 6 | Mode 28 | NA | 12.00 PM | 9.00 PM | South |  |  |  | Y |  |  | Y
East 6 | Mode 29 | NA | 12.00 PM | 9.00 PM | East |  |  | Y | Y | Y |  | Y
Central 6 | Mode 30 | NA | 12.00 PM | 9.00 PM | Central |  |  | Y
West 7 | Mode 31 | NA | 12.00 PM | 9.00 PM | West |  |  | Y | Y | Y |  | Y
North 7 | Mode 32 | NA | 12.00 PM | 9.00 PM | North |  |  | Y
South 7 | Mode 33 | NA | 12.00 PM | 9.00 PM | South |  |  |  | Y | Y |  | Y
East 7 | Mode 34 | NA | 12.00 PM | 9.00 PM | East |  |  |  | Y | Y |  | Y
Central 7 | Mode 35 | NA | 12.00 PM | 9.00 PM | Central |  |  | Y
West 8 | Mode 36 | NA | 12.00 PM | 9.00 PM | West |  | Y |  |  | Y | Y
North 8 | Mode 37 | NA | 12.00 PM | 9.00 PM | North | Y |  | Y | Y | Y |  | Y
South 8 | Mode 38 | NA | 12.00 PM | 9.00 PM | South | Y |  | Y | Y |  |  | Y
East 8 | Mode 39 | NA | 3.00 PM (Weekdays) 12.00 PM (Weekends) | 10.00 PM (Weekdays) 9.00 PM (Weekends) | East |  | Y |  |  |  | Y
Central 8 | Mode 40 | NA | 3.00 PM (Weekdays) 12.00 PM (Weekends) | 10.00 PM (Weekdays) 9.00 PM (Weekends) | Central | Y | Y |  |  |  | Y
West 9 | Mode 41 | NA | 3.00 PM (Weekdays) 12.00 PM (Weekends) | 10.00 PM (Weekdays) 9.00 PM (Weekends) | West |  | Y |  |  |  | Y
North 9 | Mode 42 | NA | 3.00 PM (Weekdays) 12.00 PM (Weekends) | 10.00 PM (Weekdays) 9.00 PM (Weekends) | North | Y | Y |  |  |  | Y
South 9 | Mode 43 | NA | 3.00 PM (Weekdays) 12.00 PM (Weekends) | 10.00 PM (Weekdays) 9.00 PM (Weekends) | South | Y | Y |  |  |  | Y
East 9 | Mode 44 | NA | 3.00 PM (Weekdays) 12.00 PM (Weekends) | 10.00 PM (Weekdays) 9.00 PM (Weekends) | East
Central 9 | Mode 45 | NA | 3.00 PM (Weekdays) 12.00 PM (Weekends) | 10.00 PM (Weekdays) 9.00 PM (Weekends) | Central | Y
West 10 | Mode 46 | NA | 3.00 PM (Weekdays) 12.00 PM (Weekends) | 10.00 PM (Weekdays) 9.00 PM (Weekends) | West |  | Y |  |  |  | Y
North 10 | Mode 47 | NA | 3.00 PM (Weekdays) 12.00 PM (Weekends) | 10.00 PM (Weekdays) 9.00 PM (Weekends) | North | Y | Y |  |  |  | Y
South 10 | Mode 48 | NA | 3.00 PM (Weekdays) 12.00 PM (Weekends) | 10.00 PM (Weekdays) 9.00 PM (Weekends) | South |  | Y |  |  |  | Y
East 10 | Mode 49 | NA | 3.00 PM (Weekdays) 12.00 PM (Weekends) | 10.00 PM (Weekdays) 9.00 PM (Weekends) | East |  | Y |  |  |  | Y
Central 10 | Mode 50 | NA | 3.00 PM (Weekdays) 12.00 PM (Weekends) | 10.00 PM (Weekdays) 9.00 PM (Weekends) | Central |  | Y |  |  |  | Y
West 11 | Mode 51 | NA | 3.00 PM (Weekdays) 12.00 PM (Weekends) | 10.00 PM (Weekdays) 9.00 PM (Weekends) | West |  |  |  | Y | Y |  | Y
North 11 | Mode 52 | NA | 3.00 PM | 10.00 PM | North |  |  | Y | Y |  |  | Y
South 11 | Mode 53 | NA | 3.00 PM | 10.00 PM | South |  |  | Y
East 11 | Mode 54 | NA | 3.00 PM (Weekdays) 12.00 PM (Weekends) | 10.00 PM (Weekdays) 9.00 PM (Weekends) | East |  |  |  | Y | Y |  | Y
Central 11 | Mode 55 | NA | 11.00 AM | 9.00 PM | Central | Y
West 12 | Mode 56 | NA | 11.00 AM | 9.00 PM | West |  | Y |  |  |  | Y
North 12 | Mode 57 | NA | 11.00 AM | 9.00 PM | North |  |  |  | Y |  |  | Y
South 12 | Mode 58 | NA | 10.30 AM (Mon-Sat) 11.00 AM (Sun) | 7.30 PM (Mon-Sat) 6.00 PM (Sun) | South | Y | Y |  |  |  | Y
East 12 | Mode 59 | NA | 11.00 AM | 8.00 PM | East |  |  |  | Y |  |  | Y
Central 12 | Mode 60 | NA | 11.00 AM | 2.00 PM | Central |  |  |  |  | Y
South 13 | Mode 61 | NA | TBA | TBA | South |  |  |  |  | Y
East 13 | Mode 62 | NA | 10.00 AM | 10.00 PM | East |  | Y |  |  |  | Y
Central 13 | Mode 63 | NA | 10.00 AM | 10.00 PM | Central |  |  |  | Y | Y |  | Y