{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["Cover","Dates","Inputs","PCOUTPUT","Excelexport","Handbook","DIVDivision1","All Fixtures","Generate","tables","fixture tables","Teamsanddivs"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":1,"defined_names":45,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Cover","index":0,"n_rows":24,"n_cols":3,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
[]
[null,"How Does this sheet Work ?"]
[]
[null,"It is the work flow sheet for generating and entering Fixtures for a 8 team multidivision cricket league"]
[]
[null,"The Process is"]
[null,"1)","Copy the Play cricket dowloaded site ID, for your teams and divisions - Import Teams"]
[null,"2)","Setup the Dates for your season in the Dates sheet"]
[null,"3)","Setup the Divisions allocate teams to a position in each division - press the setup division button then go to the \"Inputs\" sheet"]
[null,"4)","Place each team into a slot in the division - checks are made to highlight in Red duplicate teams in divisions , ground sharing teams are automatically added, and cells higlighted in Purple show a ground share rule is broken "]
[null,"6) ","Once the teams are allocated to a division select a divison in the list box on the \"fixture Generation\" on the Ribbon and hit \"Generate Fixtures\""]
[null,"7) ","Once all divisions are generated then \"consolidate the sheets\" usingthe button to the Ribbon"]
[null,"8) ","\"Export to Excel\" creates a user friendly print of the fixtures by division and \"format for Handbook\" produces a handbook friendly versions"]
[null,"9)","\"Export to Play-Cricket\" creates the file that can be uploaded in to Play-Cricket 2017 version"]
[]
[]
[null,"Advanced"]
[null,null,"The Fixtures generate off tables of \"Home and Away\" round robin tables.... "]
[null,null,"the fixture tables sheet provides a good mix of home and away and allow ground shares within a division it can be changed but in doing so you may destroy the functionalitiy"]
[null,null,"On the 8 team table, teams 1 thru 4 are at home, when teams 5 thru 8 are away"]
[]
[null,"Tips"]
[null,null,"Sharing grounds between leagues or even between 8 and 10 team divisions in not trivial, however most templates in use in leagues have a team which goes H,A,H,A  etc and 1 that goes A,H,A,H -- so try to reserve these to share outside of the league or between 10 and 12 team divisions"]
[null,null,"This allow for all play all up to 2 times depending how many dates are entered"]

{"sheet":"Dates","index":1,"n_rows":23,"n_cols":4,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
["Week","Dates","Day","Time"]
[1,"2017-05-06",{"$f":"VLOOKUP(WEEKDAY(B2),days,2)","v":"Saturday"},"13:00:00"]
[{"$f":"A2+1","v":2},{"$f":"B2+7","v":"2017-05-13"},"Saturday","13:00:00"]
[3,{"$f":"B3+7","v":"2017-05-20"},"Saturday","13:00:00"]
[4,"2017-05-27","Saturday","13:00:00"]
[5,"2017-06-03","Saturday","13:00:00"]
[6,"2017-06-10","Saturday","13:00:00"]
[7,"2017-06-17","Saturday","13:00:00"]
[8,"2017-06-24","Saturday","13:00:00"]
[9,"2017-07-01","Saturday","13:00:00"]
[10,"2017-07-08","Saturday","13:00:00"]
[11,"2017-07-15",{"$f":"VLOOKUP(WEEKDAY(B12),days,2)","v":"Saturday"},"13:00:00"]
[12,"2017-07-22","Saturday","13:00:00"]
[13,"2017-07-29","Saturday","13:00:00"]
[14,"2017-08-05","Saturday","13:00:00"]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]

{"sheet":"Inputs","index":2,"n_rows":34,"n_cols":2,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
["Setup Divisions allocate teams to a position in each division"]
[]
[]
[null,"Division 1"]
[null,"a"]
[null,1]
[null,2]
[null,3]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,1]
[null,2]
[null,3]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]

{"sheet":"PCOUTPUT","index":3,"n_rows":57,"n_cols":11,"rows_kept":57,"cut":false,"hidden":false,"merged":[]}
["Division ID","Match Date","Time","Home Team ID","Away Team ID","Ground ID","Ground Name","Umpire 1 ID","Umpire 2 ID","Umpire 3 ID","Match Ref ID"]
["a","2017-05-06","13:00:00",1,8,1]
["a","2017-05-06","13:00:00",2,7,2]
["a","2017-05-06","13:00:00",3,6,3]
["a","2017-05-06","13:00:00",4,5,4]
["a","2017-05-13","13:00:00",1,2,1]
["a","2017-05-13","13:00:00",6,4,6]
["a","2017-05-13","13:00:00",7,3,7]
["a","2017-05-13","13:00:00",8,5,8]
["a","2017-05-20","13:00:00",2,8,2]
["a","2017-05-20","13:00:00",3,1,3]
["a","2017-05-20","13:00:00",4,7,4]
["a","2017-05-20","13:00:00",5,6,5]
["a","2017-05-27","13:00:00",1,4,1]
["a","2017-05-27","13:00:00",2,3,2]
["a","2017-05-27","13:00:00",7,5,7]
["a","2017-05-27","13:00:00",8,6,8]
["a","2017-06-03","13:00:00",3,8,3]
["a","2017-06-03","13:00:00",4,2,4]
["a","2017-06-03","13:00:00",5,1,5]
["a","2017-06-03","13:00:00",6,7,6]
["a","2017-06-10","13:00:00",4,8,4]
["a","2017-06-10","13:00:00",5,3,5]
["a","2017-06-10","13:00:00",6,2,6]
["a","2017-06-10","13:00:00",7,1,7]
["a","2017-06-17","13:00:00",1,6,1]
["a","2017-06-17","13:00:00",2,5,2]
["a","2017-06-17","13:00:00",3,4,3]
["a","2017-06-17","13:00:00",8,7,8]
["a","2017-06-24","13:00:00",5,4,5]
["a","2017-06-24","13:00:00",6,3,6]
["a","2017-06-24","13:00:00",7,2,7]
["a","2017-06-24","13:00:00",8,1,8]
["a","2017-07-01","13:00:00",2,1,2]
["a","2017-07-01","13:00:00",3,7,3]
["a","2017-07-01","13:00:00",4,6,4]
["a","2017-07-01","13:00:00",5,8,5]
["a","2017-07-08","13:00:00",1,3,1]
["a","2017-07-08","13:00:00",6,5,6]
["a","2017-07-08","13:00:00",7,4,7]
["a","2017-07-08","13:00:00",8,2,8]
["a","2017-07-15","13:00:00",3,2,3]
["a","2017-07-15","13:00:00",4,1,4]
["a","2017-07-15","13:00:00",5,5,5]
["a","2017-07-15","13:00:00",6,8,6]
["a","2017-07-22","13:00:00",1,5,1]
["a","2017-07-22","13:00:00",2,4,2]
["a","2017-07-22","13:00:00",7,6,7]
["a","2017-07-22","13:00:00",8,3,8]
["a","2017-07-29","13:00:00",1,7,1]
["a","2017-07-29","13:00:00",2,6,2]
["a","2017-07-29","13:00:00",3,5,3]
["a","2017-07-29","13:00:00",8,4,8]
["a","2017-08-05","13:00:00",4,3,4]
["a","2017-08-05","13:00:00",5,2,5]
["a","2017-08-05","13:00:00",6,1,6]
["a","2017-08-05","13:00:00",7,8,7]

{"sheet":"Excelexport","index":4,"n_rows":57,"n_cols":10,"rows_kept":57,"cut":false,"hidden":false,"merged":[]}
["Division","Date","Date","Time","Home","Away","PC_DIV","PC_HOME","PC_AWAY","PC_Ground"]
["Division 1","Saturday","2017-05-06","13:00:00",1,8,"a",1,8,1]
["Division 1","Saturday","2017-05-06","13:00:00",2,7,"a",2,7,2]
["Division 1","Saturday","2017-05-06","13:00:00",3,6,"a",3,6,3]
["Division 1","Saturday","2017-05-06","13:00:00",4,5,"a",4,5,4]
["Division 1","Saturday","2017-05-13","13:00:00",1,2,"a",1,2,1]
["Division 1","Saturday","2017-05-13","13:00:00",6,4,"a",6,4,6]
["Division 1","Saturday","2017-05-13","13:00:00",7,3,"a",7,3,7]
["Division 1","Saturday","2017-05-13","13:00:00",8,5,"a",8,5,8]
["Division 1","Saturday","2017-05-20","13:00:00",2,8,"a",2,8,2]
["Division 1","Saturday","2017-05-20","13:00:00",3,1,"a",3,1,3]
["Division 1","Saturday","2017-05-20","13:00:00",4,7,"a",4,7,4]
["Division 1","Saturday","2017-05-20","13:00:00",5,6,"a",5,6,5]
["Division 1","Saturday","2017-05-27","13:00:00",1,4,"a",1,4,1]
["Division 1","Saturday","2017-05-27","13:00:00",2,3,"a",2,3,2]
["Division 1","Saturday","2017-05-27","13:00:00",7,5,"a",7,5,7]
["Division 1","Saturday","2017-05-27","13:00:00",8,6,"a",8,6,8]
["Division 1","Saturday","2017-06-03","13:00:00",3,8,"a",3,8,3]
["Division 1","Saturday","2017-06-03","13:00:00",4,2,"a",4,2,4]
["Division 1","Saturday","2017-06-03","13:00:00",5,1,"a",5,1,5]
["Division 1","Saturday","2017-06-03","13:00:00",6,7,"a",6,7,6]
["Division 1","Saturday","2017-06-10","13:00:00",4,8,"a",4,8,4]
["Division 1","Saturday","2017-06-10","13:00:00",5,3,"a",5,3,5]
["Division 1","Saturday","2017-06-10","13:00:00",6,2,"a",6,2,6]
["Division 1","Saturday","2017-06-10","13:00:00",7,1,"a",7,1,7]
["Division 1","Saturday","2017-06-17","13:00:00",1,6,"a",1,6,1]
["Division 1","Saturday","2017-06-17","13:00:00",2,5,"a",2,5,2]
["Division 1","Saturday","2017-06-17","13:00:00",3,4,"a",3,4,3]
["Division 1","Saturday","2017-06-17","13:00:00",8,7,"a",8,7,8]
["Division 1","Saturday","2017-06-24","13:00:00",5,4,"a",5,4,5]
["Division 1","Saturday","2017-06-24","13:00:00",6,3,"a",6,3,6]
["Division 1","Saturday","2017-06-24","13:00:00",7,2,"a",7,2,7]
["Division 1","Saturday","2017-06-24","13:00:00",8,1,"a",8,1,8]
["Division 1","Saturday","2017-07-01","13:00:00",2,1,"a",2,1,2]
["Division 1","Saturday","2017-07-01","13:00:00",3,7,"a",3,7,3]
["Division 1","Saturday","2017-07-01","13:00:00",4,6,"a",4,6,4]
["Division 1","Saturday","2017-07-01","13:00:00",5,8,"a",5,8,5]
["Division 1","Saturday","2017-07-08","13:00:00",1,3,"a",1,3,1]
["Division 1","Saturday","2017-07-08","13:00:00",6,5,"a",6,5,6]
["Division 1","Saturday","2017-07-08","13:00:00",7,4,"a",7,4,7]
["Division 1","Saturday","2017-07-08","13:00:00",8,2,"a",8,2,8]
["Division 1","Saturday","2017-07-15","13:00:00",3,2,"a",3,2,3]
["Division 1","Saturday","2017-07-15","13:00:00",4,1,"a",4,1,4]
["Division 1","Saturday","2017-07-15","13:00:00",5,5,"a",5,5,5]
["Division 1","Saturday","2017-07-15","13:00:00",6,8,"a",6,8,6]
["Division 1","Saturday","2017-07-22","13:00:00",1,5,"a",1,5,1]
["Division 1","Saturday","2017-07-22","13:00:00",2,4,"a",2,4,2]
["Division 1","Saturday","2017-07-22","13:00:00",7,6,"a",7,6,7]
["Division 1","Saturday","2017-07-22","13:00:00",8,3,"a",8,3,8]
["Division 1","Saturday","2017-07-29","13:00:00",1,7,"a",1,7,1]
["Division 1","Saturday","2017-07-29","13:00:00",2,6,"a",2,6,2]
["Division 1","Saturday","2017-07-29","13:00:00",3,5,"a",3,5,3]
["Division 1","Saturday","2017-07-29","13:00:00",8,4,"a",8,4,8]
["Division 1","Saturday","2017-08-05","13:00:00",4,3,"a",4,3,4]
["Division 1","Saturday","2017-08-05","13:00:00",5,2,"a",5,2,5]
["Division 1","Saturday","2017-08-05","13:00:00",6,1,"a",6,1,6]
["Division 1","Saturday","2017-08-05","13:00:00",7,8,"a",7,8,7]

{"sheet":"Handbook","index":5,"n_rows":90,"n_cols":4,"rows_kept":90,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Division 1"]
[]
[]
["Sat",1,"v",8]
["May",2,"v",7]
["6th",3,"v",6]
["13:00",4,"v",5]
[]
[]
["Sat",1,"v",2]
["May",6,"v",4]
["13rd",7,"v",3]
["13:00",8,"v",5]
[]
[]
["Sat",2,"v",8]
["May",3,"v",1]
["20th",4,"v",7]
["13:00",5,"v",6]
[]
[]
["Sat",1,"v",4]
["May",2,"v",3]
["27th",7,"v",5]
["13:00",8,"v",6]
[]
[]
["Sat",3,"v",8]
["Jun",4,"v",2]
["3rd",5,"v",1]
["13:00",6,"v",7]
[]
[]
["Sat",4,"v",8]
["Jun",5,"v",3]
["10th",6,"v",2]
["13:00",7,"v",1]
[]
[]
["Sat",1,"v",6]
["Jun",2,"v",5]
["17th",3,"v",4]
["13:00",8,"v",7]
[]
[]
["Sat",5,"v",4]
["Jun",6,"v",3]
["24th",7,"v",2]
["13:00",8,"v",1]
[]
[]
[null,"Division 1"]
[]
[]
["Sat",2,"v",1]
["Jul",3,"v",7]
["1st",4,"v",6]
["13:00",5,"v",8]
[]
[]
["Sat",1,"v",3]
["Jul",6,"v",5]
["8th",7,"v",4]
["13:00",8,"v",2]
[]
[]
["Sat",3,"v",2]
["Jul",4,"v",1]
["15th",5,"v",5]
["13:00",6,"v",8]
[]
[]
["Sat",1,"v",5]
["Jul",2,"v",4]
["22nd",7,"v",6]
["13:00",8,"v",3]
[]
[]
["Sat",1,"v",7]
["Jul",2,"v",6]
["29th",3,"v",5]
["13:00",8,"v",4]
[]
[]
["Sat",4,"v",3]
["Aug",5,"v",2]
["5th",6,"v",1]
["13:00",7,"v",8]

{"sheet":"DIVDivision1","index":6,"n_rows":57,"n_cols":10,"rows_kept":57,"cut":false,"hidden":false,"merged":[]}
[]
["Division 1","Saturday","2017-05-06","13:00:00",1,8,"a",1,8,1]
["Division 1","Saturday","2017-05-06","13:00:00",2,7,"a",2,7,2]
["Division 1","Saturday","2017-05-06","13:00:00",3,6,"a",3,6,3]
["Division 1","Saturday","2017-05-06","13:00:00",4,5,"a",4,5,4]
["Division 1","Saturday","2017-05-13","13:00:00",1,2,"a",1,2,1]
["Division 1","Saturday","2017-05-13","13:00:00",6,4,"a",6,4,6]
["Division 1","Saturday","2017-05-13","13:00:00",7,3,"a",7,3,7]
["Division 1","Saturday","2017-05-13","13:00:00",8,5,"a",8,5,8]
["Division 1","Saturday","2017-05-20","13:00:00",2,8,"a",2,8,2]
["Division 1","Saturday","2017-05-20","13:00:00",3,1,"a",3,1,3]
["Division 1","Saturday","2017-05-20","13:00:00",4,7,"a",4,7,4]
["Division 1","Saturday","2017-05-20","13:00:00",5,6,"a",5,6,5]
["Division 1","Saturday","2017-05-27","13:00:00",1,4,"a",1,4,1]
["Division 1","Saturday","2017-05-27","13:00:00",2,3,"a",2,3,2]
["Division 1","Saturday","2017-05-27","13:00:00",7,5,"a",7,5,7]
["Division 1","Saturday","2017-05-27","13:00:00",8,6,"a",8,6,8]
["Division 1","Saturday","2017-06-03","13:00:00",3,8,"a",3,8,3]
["Division 1","Saturday","2017-06-03","13:00:00",4,2,"a",4,2,4]
["Division 1","Saturday","2017-06-03","13:00:00",5,1,"a",5,1,5]
["Division 1","Saturday","2017-06-03","13:00:00",6,7,"a",6,7,6]
["Division 1","Saturday","2017-06-10","13:00:00",4,8,"a",4,8,4]
["Division 1","Saturday","2017-06-10","13:00:00",5,3,"a",5,3,5]
["Division 1","Saturday","2017-06-10","13:00:00",6,2,"a",6,2,6]
["Division 1","Saturday","2017-06-10","13:00:00",7,1,"a",7,1,7]
["Division 1","Saturday","2017-06-17","13:00:00",1,6,"a",1,6,1]
["Division 1","Saturday","2017-06-17","13:00:00",2,5,"a",2,5,2]
["Division 1","Saturday","2017-06-17","13:00:00",3,4,"a",3,4,3]
["Division 1","Saturday","2017-06-17","13:00:00",8,7,"a",8,7,8]
["Division 1","Saturday","2017-06-24","13:00:00",5,4,"a",5,4,5]
["Division 1","Saturday","2017-06-24","13:00:00",6,3,"a",6,3,6]
["Division 1","Saturday","2017-06-24","13:00:00",7,2,"a",7,2,7]
["Division 1","Saturday","2017-06-24","13:00:00",8,1,"a",8,1,8]
["Division 1","Saturday","2017-07-01","13:00:00",2,1,"a",2,1,2]
["Division 1","Saturday","2017-07-01","13:00:00",3,7,"a",3,7,3]
["Division 1","Saturday","2017-07-01","13:00:00",4,6,"a",4,6,4]
["Division 1","Saturday","2017-07-01","13:00:00",5,8,"a",5,8,5]
["Division 1","Saturday","2017-07-08","13:00:00",1,3,"a",1,3,1]
["Division 1","Saturday","2017-07-08","13:00:00",6,5,"a",6,5,6]
["Division 1","Saturday","2017-07-08","13:00:00",7,4,"a",7,4,7]
["Division 1","Saturday","2017-07-08","13:00:00",8,2,"a",8,2,8]
["Division 1","Saturday","2017-07-15","13:00:00",3,2,"a",3,2,3]
["Division 1","Saturday","2017-07-15","13:00:00",4,1,"a",4,1,4]
["Division 1","Saturday","2017-07-15","13:00:00",5,5,"a",5,5,5]
["Division 1","Saturday","2017-07-15","13:00:00",6,8,"a",6,8,6]
["Division 1","Saturday","2017-07-22","13:00:00",1,5,"a",1,5,1]
["Division 1","Saturday","2017-07-22","13:00:00",2,4,"a",2,4,2]
["Division 1","Saturday","2017-07-22","13:00:00",7,6,"a",7,6,7]
["Division 1","Saturday","2017-07-22","13:00:00",8,3,"a",8,3,8]
["Division 1","Saturday","2017-07-29","13:00:00",1,7,"a",1,7,1]
["Division 1","Saturday","2017-07-29","13:00:00",2,6,"a",2,6,2]
["Division 1","Saturday","2017-07-29","13:00:00",3,5,"a",3,5,3]
["Division 1","Saturday","2017-07-29","13:00:00",8,4,"a",8,4,8]
["Division 1","Saturday","2017-08-05","13:00:00",4,3,"a",4,3,4]
["Division 1","Saturday","2017-08-05","13:00:00",5,2,"a",5,2,5]
["Division 1","Saturday","2017-08-05","13:00:00",6,1,"a",6,1,6]
["Division 1","Saturday","2017-08-05","13:00:00",7,8,"a",7,8,7]

{"sheet":"All Fixtures","index":7,"n_rows":57,"n_cols":10,"rows_kept":57,"cut":false,"hidden":false,"merged":[]}
[]
["Division 1","Saturday","2017-05-06","13:00:00",1,8,"a",1,8,1]
["Division 1","Saturday","2017-05-06","13:00:00",2,7,"a",2,7,2]
["Division 1","Saturday","2017-05-06","13:00:00",3,6,"a",3,6,3]
["Division 1","Saturday","2017-05-06","13:00:00",4,5,"a",4,5,4]
["Division 1","Saturday","2017-05-13","13:00:00",1,2,"a",1,2,1]
["Division 1","Saturday","2017-05-13","13:00:00",6,4,"a",6,4,6]
["Division 1","Saturday","2017-05-13","13:00:00",7,3,"a",7,3,7]
["Division 1","Saturday","2017-05-13","13:00:00",8,5,"a",8,5,8]
["Division 1","Saturday","2017-05-20","13:00:00",2,8,"a",2,8,2]
["Division 1","Saturday","2017-05-20","13:00:00",3,1,"a",3,1,3]
["Division 1","Saturday","2017-05-20","13:00:00",4,7,"a",4,7,4]
["Division 1","Saturday","2017-05-20","13:00:00",5,6,"a",5,6,5]
["Division 1","Saturday","2017-05-27","13:00:00",1,4,"a",1,4,1]
["Division 1","Saturday","2017-05-27","13:00:00",2,3,"a",2,3,2]
["Division 1","Saturday","2017-05-27","13:00:00",7,5,"a",7,5,7]
["Division 1","Saturday","2017-05-27","13:00:00",8,6,"a",8,6,8]
["Division 1","Saturday","2017-06-03","13:00:00",3,8,"a",3,8,3]
["Division 1","Saturday","2017-06-03","13:00:00",4,2,"a",4,2,4]
["Division 1","Saturday","2017-06-03","13:00:00",5,1,"a",5,1,5]
["Division 1","Saturday","2017-06-03","13:00:00",6,7,"a",6,7,6]
["Division 1","Saturday","2017-06-10","13:00:00",4,8,"a",4,8,4]
["Division 1","Saturday","2017-06-10","13:00:00",5,3,"a",5,3,5]
["Division 1","Saturday","2017-06-10","13:00:00",6,2,"a",6,2,6]
["Division 1","Saturday","2017-06-10","13:00:00",7,1,"a",7,1,7]
["Division 1","Saturday","2017-06-17","13:00:00",1,6,"a",1,6,1]
["Division 1","Saturday","2017-06-17","13:00:00",2,5,"a",2,5,2]
["Division 1","Saturday","2017-06-17","13:00:00",3,4,"a",3,4,3]
["Division 1","Saturday","2017-06-17","13:00:00",8,7,"a",8,7,8]
["Division 1","Saturday","2017-06-24","13:00:00",5,4,"a",5,4,5]
["Division 1","Saturday","2017-06-24","13:00:00",6,3,"a",6,3,6]
["Division 1","Saturday","2017-06-24","13:00:00",7,2,"a",7,2,7]
["Division 1","Saturday","2017-06-24","13:00:00",8,1,"a",8,1,8]
["Division 1","Saturday","2017-07-01","13:00:00",2,1,"a",2,1,2]
["Division 1","Saturday","2017-07-01","13:00:00",3,7,"a",3,7,3]
["Division 1","Saturday","2017-07-01","13:00:00",4,6,"a",4,6,4]
["Division 1","Saturday","2017-07-01","13:00:00",5,8,"a",5,8,5]
["Division 1","Saturday","2017-07-08","13:00:00",1,3,"a",1,3,1]
["Division 1","Saturday","2017-07-08","13:00:00",6,5,"a",6,5,6]
["Division 1","Saturday","2017-07-08","13:00:00",7,4,"a",7,4,7]
["Division 1","Saturday","2017-07-08","13:00:00",8,2,"a",8,2,8]
["Division 1","Saturday","2017-07-15","13:00:00",3,2,"a",3,2,3]
["Division 1","Saturday","2017-07-15","13:00:00",4,1,"a",4,1,4]
["Division 1","Saturday","2017-07-15","13:00:00",5,5,"a",5,5,5]
["Division 1","Saturday","2017-07-15","13:00:00",6,8,"a",6,8,6]
["Division 1","Saturday","2017-07-22","13:00:00",1,5,"a",1,5,1]
["Division 1","Saturday","2017-07-22","13:00:00",2,4,"a",2,4,2]
["Division 1","Saturday","2017-07-22","13:00:00",7,6,"a",7,6,7]
["Division 1","Saturday","2017-07-22","13:00:00",8,3,"a",8,3,8]
["Division 1","Saturday","2017-07-29","13:00:00",1,7,"a",1,7,1]
["Division 1","Saturday","2017-07-29","13:00:00",2,6,"a",2,6,2]
["Division 1","Saturday","2017-07-29","13:00:00",3,5,"a",3,5,3]
["Division 1","Saturday","2017-07-29","13:00:00",8,4,"a",8,4,8]
["Division 1","Saturday","2017-08-05","13:00:00",4,3,"a",4,3,4]
["Division 1","Saturday","2017-08-05","13:00:00",5,2,"a",5,2,5]
["Division 1","Saturday","2017-08-05","13:00:00",6,1,"a",6,1,6]
["Division 1","Saturday","2017-08-05","13:00:00",7,8,"a",7,8,7]

{"sheet":"Generate","index":8,"n_rows":70,"n_cols":26,"rows_kept":70,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"Saturday","Saturday","Saturday","Saturday","Saturday","Saturday","Saturday","Saturday","Saturday","Saturday","Saturday","Saturday","Saturday","Saturday"]
[null,null,"2017-05-06","2017-05-13","2017-05-20","2017-05-27","2017-06-03","2017-06-10","2017-06-17","2017-06-24","2017-07-01","2017-07-08","2017-07-15","2017-07-22","2017-07-29","2017-08-05"]
[null,null,"13:00:00","13:00:00","13:00:00","13:00:00","13:00:00","13:00:00","13:00:00","13:00:00","13:00:00","13:00:00","13:00:00","13:00:00","13:00:00","13:00:00",null,null,1,2,3,4,5,6,7,8]
[null,1,8,2,null,4,null,null,6,null,null,3,null,5,7,null,null,1,null,"13/05/2017","2017-08-07","27/05/2017","22/07/2017","17/06/2017","29/07/2017","2017-06-05"]
[null,2,7,null,8,3,null,null,5,null,1,null,null,4,6,null,null,2,"2017-01-07",null,"27/05/2017","22/07/2017","17/06/2017","29/07/2017","2017-06-05","20/05/2017"]
[null,3,6,null,1,null,8,null,4,null,7,null,2,null,5,null,null,3,"20/05/2017","15/07/2017",null,"17/06/2017","29/07/2017","2017-06-05","2017-01-07","2017-03-06"]
[null,4,5,null,7,null,2,8,null,null,6,null,1,null,null,3,null,4,"15/07/2017","2017-03-06","2017-05-08",null,"2017-06-05","2017-01-07","20/05/2017","2017-10-06"]
[null,5,null,null,6,null,1,3,null,4,8,null,5,null,null,2,null,5,"2017-03-06","2017-05-08","2017-10-06","24/06/2017","15/07/2017","20/05/2017",null,"2017-01-07"]
[null,6,null,4,null,null,7,2,null,3,null,5,8,null,null,1,null,6,"2017-05-08","2017-10-06","24/06/2017","13/05/2017","2017-08-07",null,"2017-03-06","15/07/2017"]
[null,7,null,3,null,5,null,1,null,2,null,4,null,6,null,8,null,7,"2017-10-06","24/06/2017","13/05/2017","2017-08-07","27/05/2017","22/07/2017",null,"2017-05-08"]
[null,8,null,5,null,6,null,null,7,1,null,2,null,3,4,null,null,8,"24/06/2017","2017-08-07","22/07/2017","29/07/2017","13/05/2017","27/05/2017","17/06/2017"]
[]
[]
[null,"Division 1","Saturday","2017-05-06","13:00:00",1,8,"a",1,8,1]
[null,"Division 1","Saturday","2017-05-06","13:00:00",2,7,"a",2,7,2]
[null,"Division 1","Saturday","2017-05-06","13:00:00",3,6,"a",3,6,3]
[null,"Division 1","Saturday","2017-05-06","13:00:00",4,5,"a",4,5,4]
[null,"Division 1","Saturday","2017-05-13","13:00:00",1,2,"a",1,2,1]
[null,"Division 1","Saturday","2017-05-13","13:00:00",6,4,"a",6,4,6]
[null,"Division 1","Saturday","2017-05-13","13:00:00",7,3,"a",7,3,7]
[null,"Division 1","Saturday","2017-05-13","13:00:00",8,5,"a",8,5,8]
[null,"Division 1","Saturday","2017-05-20","13:00:00",2,8,"a",2,8,2]
[null,"Division 1","Saturday","2017-05-20","13:00:00",3,1,"a",3,1,3]
[null,"Division 1","Saturday","2017-05-20","13:00:00",4,7,"a",4,7,4]
[null,"Division 1","Saturday","2017-05-20","13:00:00",5,6,"a",5,6,5]
[null,"Division 1","Saturday","2017-05-27","13:00:00",1,4,"a",1,4,1]
[null,"Division 1","Saturday","2017-05-27","13:00:00",2,3,"a",2,3,2]
[null,"Division 1","Saturday","2017-05-27","13:00:00",7,5,"a",7,5,7]
[null,"Division 1","Saturday","2017-05-27","13:00:00",8,6,"a",8,6,8]
[null,"Division 1","Saturday","2017-06-03","13:00:00",3,8,"a",3,8,3]
[null,"Division 1","Saturday","2017-06-03","13:00:00",4,2,"a",4,2,4]
[null,"Division 1","Saturday","2017-06-03","13:00:00",5,1,"a",5,1,5]
[null,"Division 1","Saturday","2017-06-03","13:00:00",6,7,"a",6,7,6]
[null,"Division 1","Saturday","2017-06-10","13:00:00",4,8,"a",4,8,4]
[null,"Division 1","Saturday","2017-06-10","13:00:00",5,3,"a",5,3,5]
[null,"Division 1","Saturday","2017-06-10","13:00:00",6,2,"a",6,2,6]
[null,"Division 1","Saturday","2017-06-10","13:00:00",7,1,"a",7,1,7]
[null,"Division 1","Saturday","2017-06-17","13:00:00",1,6,"a",1,6,1]
[null,"Division 1","Saturday","2017-06-17","13:00:00",2,5,"a",2,5,2]
[null,"Division 1","Saturday","2017-06-17","13:00:00",3,4,"a",3,4,3]
[null,"Division 1","Saturday","2017-06-17","13:00:00",8,7,"a",8,7,8]
[null,"Division 1","Saturday","2017-06-24","13:00:00",5,4,"a",5,4,5]
[null,"Division 1","Saturday","2017-06-24","13:00:00",6,3,"a",6,3,6]
[null,"Division 1","Saturday","2017-06-24","13:00:00",7,2,"a",7,2,7]
[null,"Division 1","Saturday","2017-06-24","13:00:00",8,1,"a",8,1,8]
[null,"Division 1","Saturday","2017-07-01","13:00:00",2,1,"a",2,1,2]
[null,"Division 1","Saturday","2017-07-01","13:00:00",3,7,"a",3,7,3]
[null,"Division 1","Saturday","2017-07-01","13:00:00",4,6,"a",4,6,4]
[null,"Division 1","Saturday","2017-07-01","13:00:00",5,8,"a",5,8,5]
[null,"Division 1","Saturday","2017-07-08","13:00:00",1,3,"a",1,3,1]
[null,"Division 1","Saturday","2017-07-08","13:00:00",6,5,"a",6,5,6]
[null,"Division 1","Saturday","2017-07-08","13:00:00",7,4,"a",7,4,7]
[null,"Division 1","Saturday","2017-07-08","13:00:00",8,2,"a",8,2,8]
[null,"Division 1","Saturday","2017-07-15","13:00:00",3,2,"a",3,2,3]
[null,"Division 1","Saturday","2017-07-15","13:00:00",4,1,"a",4,1,4]
[null,"Division 1","Saturday","2017-07-15","13:00:00",5,5,"a",5,5,5]
[null,"Division 1","Saturday","2017-07-15","13:00:00",6,8,"a",6,8,6]
[null,"Division 1","Saturday","2017-07-22","13:00:00",1,5,"a",1,5,1]
[null,"Division 1","Saturday","2017-07-22","13:00:00",2,4,"a",2,4,2]
[null,"Division 1","Saturday","2017-07-22","13:00:00",7,6,"a",7,6,7]
[null,"Division 1","Saturday","2017-07-22","13:00:00",8,3,"a",8,3,8]
[null,"Division 1","Saturday","2017-07-29","13:00:00",1,7,"a",1,7,1]
[null,"Division 1","Saturday","2017-07-29","13:00:00",2,6,"a",2,6,2]
[null,"Division 1","Saturday","2017-07-29","13:00:00",3,5,"a",3,5,3]
[null,"Division 1","Saturday","2017-07-29","13:00:00",8,4,"a",8,4,8]
[null,"Division 1","Saturday","2017-08-05","13:00:00",4,3,"a",4,3,4]
[null,"Division 1","Saturday","2017-08-05","13:00:00",5,2,"a",5,2,5]
[null,"Division 1","Saturday","2017-08-05","13:00:00",6,1,"a",6,1,6]
[null,"Division 1","Saturday","2017-08-05","13:00:00",7,8,"a",7,8,7]

{"sheet":"tables","index":9,"n_rows":33,"n_cols":23,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
[null,"Start Times",null,null,"Convert date to day"]
[null,"1.30 pm","13:30:00",null,1,"Sunday",null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,"Division 1","a"]
[null,"1.00 pm","13:00:00",null,2,"Monday",null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[null,"12.30 pm","12:30:00",null,3,"Tuesday",null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,"12.00 pm","12:00:00",null,4,"Wednesday",null,null,null,null,null,null,null,null,null,null,null,null,null,4]
[null,null,null,null,5,"Thursday",null,null,null,null,null,null,null,null,null,null,null,null,null,5]
[null,null,null,null,6,"Friday",null,null,null,null,null,null,null,null,null,null,null,null,null,6]
[null,null,null,null,7,"Saturday",null,null,null,null,null,null,null,null,null,null,null,null,null,7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Teamnumbers"]
[null,8]

{"sheet":"fixture tables","index":10,"n_rows":22,"n_cols":16,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
[]
[null,"How these work"]
[]
[null,"For each Week number across the top row, the home team in Column B, hosts the away team "]
[]
[]
[null,"The current Tables in use are"]
[]
[null,"Range","Usage"]
[null,"M8T","8 team divisions 1,2,3,4 reverse with 4,5,6,8 within the division, teams 3 and 8 have HAHA and AHAH patterns"]
[]
[null,null,null,"x",null,"x","x",null,"x",null," ","x"," ","x"," "," "]
[null,"8 Team Table"]
[null,null,1,2,3,4,5,6,7,8,9,10,11,12,13,14]
[null,1,8,2,null,4,null,null,6,null,null,3,null,5,7]
[null,2,7,null,8,3,null,null,5,null,1,null,null,4,6]
[null,3,6,null,1,null,8,null,4,null,7,null,2,null,5]
[null,4,5,null,7,null,2,8,null,null,6,null,1,null,null,3]
[null,5,null,null,6,null,1,3,null,4,8,null,5,null,null,2]
[null,6,null,4,null,null,7,2,null,3,null,5,8,null,null,1]
[null,7,null,3,null,5,null,1,null,2,null,4,null,6,null,8]
[null,8,null,5,null,6,null,null,7,1,null,2,null,3,4]

{"sheet":"Teamsanddivs","index":11,"n_rows":86,"n_cols":7,"rows_kept":86,"cut":false,"hidden":false,"merged":[]}
["Division Name","Division ID","Team name","Team ID","Ground Name","Ground ID","Ground Shared With"]
["Division 1","a",1,1,1,1,5]
["Division 1","a",2,2,2,2,6]
["Division 1","a",3,3,3,3,7]
["Division 1","a",4,4,4,4,8]
["Division 1","a",5,5,5,5,1]
["Division 1","a",6,6,6,6,2]
["Division 1","a",7,7,7,7,3]
["Division 1","a",8,8,8,8,4]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Division 9 West",65968,"Wishaw CC - 2nd XI",102520,"Church Lane, Wishaw",38501,"Wishaw CC - 1st XI"]