{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["Table","George A","Brown Bear","Bye2","Bye","Drifters","George Bees","Farmers Boy","Old Bulls Head","Plough OldUns","Hen and Chickens","Template"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"Table","index":0,"n_rows":13,"n_cols":8,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Matches Played","Matches Won","Games Won","Games Lost","Points Won","Points Lost","Points Diff"]
[{"$f":"Template!B9","v":"Old Bulls Head"},{"$f":"COUNT(INDIRECT(CONCATENATE(\"'\",A4,\"'!E:E\")))","v":14},{"$f":"SUM(INDIRECT(CONCATENATE(\"'\",A4,\"'!I:I\")))","v":10},{"$f":"SUM(INDIRECT(CONCATENATE(\"'\",A4,\"'!E:E\")))","v":38},{"$f":"SUM(INDIRECT(CONCATENATE(\"'\",A4,\"'!F:F\")))","v":32},{"$f":"SUM(INDIRECT(CONCATENATE(\"'\",A4,\"'!G:G\")))","v":735},{"$f":"SUM(INDIRECT(CONCATENATE(\"'\",A4,\"'!H:H\")))","v":683},{"$f":"F4-G4","v":52}]
[{"$f":"Template!B6","v":"Drifters"},{"$f":"COUNT(INDIRECT(CONCATENATE(\"'\",A5,\"'!E:E\")))","v":14},{"$f":"SUM(INDIRECT(CONCATENATE(\"'\",A5,\"'!I:I\")))","v":9},{"$f":"SUM(INDIRECT(CONCATENATE(\"'\",A5,\"'!E:E\")))","v":40},{"$f":"SUM(INDIRECT(CONCATENATE(\"'\",A5,\"'!F:F\")))","v":30},{"$f":"SUM(INDIRECT(CONCATENATE(\"'\",A5,\"'!G:G\")))","v":746},{"$f":"SUM(INDIRECT(CONCATENATE(\"'\",A5,\"'!H:H\")))","v":638},{"$f":"F5-G5","v":108}]
[{"$f":"Template!B8","v":"Farmers Boy"},{"$f":"COUNT(INDIRECT(CONCATENATE(\"'\",A6,\"'!E:E\")))","v":14},{"$f":"SUM(INDIRECT(CONCATENATE(\"'\",A6,\"'!I:I\")))","v":9},{"$f":"SUM(INDIRECT(CONCATENATE(\"'\",A6,\"'!E:E\")))","v":40},{"$f":"SUM(INDIRECT(CONCATENATE(\"'\",A6,\"'!F:F\")))","v":30},{"$f":"SUM(INDIRECT(CONCATENATE(\"'\",A6,\"'!G:G\")))","v":722},{"$f":"SUM(INDIRECT(CONCATENATE(\"'\",A6,\"'!H:H\")))","v":653},{"$f":"F6-G6","v":69}]
[{"$f":"Template!B7","v":"George Bees"},{"$f":"COUNT(INDIRECT(CONCATENATE(\"'\",A7,\"'!E:E\")))","v":14},{"$f":"SUM(INDIRECT(CONCATENATE(\"'\",A7,\"'!I:I\")))","v":7},{"$f":"SUM(INDIRECT(CONCATENATE(\"'\",A7,\"'!E:E\")))","v":42},{"$f":"SUM(INDIRECT(CONCATENATE(\"'\",A7,\"'!F:F\")))","v":28},{"$f":"SUM(INDIRECT(CONCATENATE(\"'\",A7,\"'!G:G\")))","v":741},{"$f":"SUM(INDIRECT(CONCATENATE(\"'\",A7,\"'!H:H\")))","v":621},{"$f":"F7-G7","v":120}]
[{"$f":"Template!B3","v":"Brown Bear"},{"$f":"COUNT(INDIRECT(CONCATENATE(\"'\",A8,\"'!E:E\")))","v":14},{"$f":"SUM(INDIRECT(CONCATENATE(\"'\",A8,\"'!I:I\")))","v":6},{"$f":"SUM(INDIRECT(CONCATENATE(\"'\",A8,\"'!E:E\")))","v":37},{"$f":"SUM(INDIRECT(CONCATENATE(\"'\",A8,\"'!F:F\")))","v":33},{"$f":"SUM(INDIRECT(CONCATENATE(\"'\",A8,\"'!G:G\")))","v":745},{"$f":"SUM(INDIRECT(CONCATENATE(\"'\",A8,\"'!H:H\")))","v":717},{"$f":"F8-G8","v":28}]
[{"$f":"Template!B10","v":"Plough OldUns"},{"$f":"COUNT(INDIRECT(CONCATENATE(\"'\",A9,\"'!E:E\")))","v":13},{"$f":"SUM(INDIRECT(CONCATENATE(\"'\",A9,\"'!I:I\")))","v":6},{"$f":"SUM(INDIRECT(CONCATENATE(\"'\",A9,\"'!E:E\")))","v":30},{"$f":"SUM(INDIRECT(CONCATENATE(\"'\",A9,\"'!F:F\")))","v":35},{"$f":"SUM(INDIRECT(CONCATENATE(\"'\",A9,\"'!G:G\")))","v":650},{"$f":"SUM(INDIRECT(CONCATENATE(\"'\",A9,\"'!H:H\")))","v":655},{"$f":"F9-G9","v":-5}]
[{"$f":"Template!B11","v":"Hen and Chickens"},{"$f":"COUNT(INDIRECT(CONCATENATE(\"'\",A10,\"'!E:E\")))","v":14},{"$f":"SUM(INDIRECT(CONCATENATE(\"'\",A10,\"'!I:I\")))","v":6},{"$f":"SUM(INDIRECT(CONCATENATE(\"'\",A10,\"'!E:E\")))","v":30},{"$f":"SUM(INDIRECT(CONCATENATE(\"'\",A10,\"'!F:F\")))","v":40},{"$f":"SUM(INDIRECT(CONCATENATE(\"'\",A10,\"'!G:G\")))","v":635},{"$f":"SUM(INDIRECT(CONCATENATE(\"'\",A10,\"'!H:H\")))","v":754},{"$f":"F10-G10","v":-119}]
[{"$f":"Template!B2","v":"George A"},{"$f":"COUNT(INDIRECT(CONCATENATE(\"'\",A11,\"'!E:E\")))","v":13},{"$f":"SUM(INDIRECT(CONCATENATE(\"'\",A11,\"'!I:I\")))","v":2},{"$f":"SUM(INDIRECT(CONCATENATE(\"'\",A11,\"'!E:E\")))","v":18},{"$f":"SUM(INDIRECT(CONCATENATE(\"'\",A11,\"'!F:F\")))","v":47},{"$f":"SUM(INDIRECT(CONCATENATE(\"'\",A11,\"'!G:G\")))","v":492},{"$f":"SUM(INDIRECT(CONCATENATE(\"'\",A11,\"'!H:H\")))","v":745},{"$f":"F11-G11","v":-253}]
[{"$f":"Template!B4","v":"Bye2"},{"$f":"COUNT(INDIRECT(CONCATENATE(\"'\",A12,\"'!E:E\")))","v":0},{"$f":"SUM(INDIRECT(CONCATENATE(\"'\",A12,\"'!I:I\")))","v":0},{"$f":"SUM(INDIRECT(CONCATENATE(\"'\",A12,\"'!E:E\")))","v":0},{"$f":"SUM(INDIRECT(CONCATENATE(\"'\",A12,\"'!F:F\")))","v":0},{"$f":"SUM(INDIRECT(CONCATENATE(\"'\",A12,\"'!G:G\")))","v":0},{"$f":"SUM(INDIRECT(CONCATENATE(\"'\",A12,\"'!H:H\")))","v":0},{"$f":"F12-G12","v":0}]
[{"$f":"Template!B5","v":"Bye"},{"$f":"COUNT(INDIRECT(CONCATENATE(\"'\",A13,\"'!E:E\")))","v":0},{"$f":"SUM(INDIRECT(CONCATENATE(\"'\",A13,\"'!I:I\")))","v":0},{"$f":"SUM(INDIRECT(CONCATENATE(\"'\",A13,\"'!E:E\")))","v":0},{"$f":"SUM(INDIRECT(CONCATENATE(\"'\",A13,\"'!F:F\")))","v":0},{"$f":"SUM(INDIRECT(CONCATENATE(\"'\",A13,\"'!G:G\")))","v":0},{"$f":"SUM(INDIRECT(CONCATENATE(\"'\",A13,\"'!H:H\")))","v":0},{"$f":"F13-G13","v":0}]

{"sheet":"George A","index":1,"n_rows":23,"n_cols":12,"rows_kept":23,"cut":false,"hidden":false,"merged":[[2,10,2,11]]}
[]
["Team",{"$f":"Template!B2","v":"George A"}]
[null,null,null,null,null,null,null,null,null,null,"Check that there are enough points to win the games"]
["Date","Week","Home/Away","Opponent","Games Won","Games lost","Points For","Points Against","Match Won?","Check that input numbers are within range","Home","Away"]
[{"$f":"Template!B20","v":"08.05.2017"},1,"Home",{"$f":"Template!B11","v":"Hen and Chickens"},2,{"$f":"IF(E5=\"\",\"\",5-E5)","v":3},46,54,{"$f":"IF(E5=\"\",\"\",IF(E5>2,1,0))","v":0},{"$f":"IF(E5=\"\",\"\",IF(OR(E5<0,E5>5,G5<0,G5>(5*13),H5<0,H5>(5*13)),\"Number out of range error\",\"Valid Scores entered\"))","v":"Valid Scores entered"},{"$f":"IF(E5=\"\",\"\",IF((E5*13>G5),\"Error in submitting Games Won or Points Home\",\"OK\"))","v":"OK"},{"$f":"IF(E5=\"\",\"\",IF((F5*13>H5),\"Error in submitting Games Won or Points Away\",\"OK\"))","v":"OK"}]
[{"$f":"Template!B21","v":"15.05.2017"},{"$f":"B5+1","v":2},"Away",{"$f":"Template!B10","v":"Plough OldUns"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D6,\"'!$F6\"))","v":""},"",{"$f":"INDIRECT(CONCATENATE(\"'\",$D6,\"'!H6\"))","v":0},{"$f":"INDIRECT(CONCATENATE(\"'\",$D6,\"'!G6\"))","v":0},{"$f":"IF(E6=\"\",\"\",IF(E6>2,1,0))","v":""},{"$f":"IF(E6=\"\",\"\",IF(OR(E6<0,E6>5,G6<0,G6>(5*13),H6<0,H6>(5*13)),\"Number out of range error\",\"Valid Scores entered\"))","v":""},{"$f":"IF(E6=\"\",\"\",IF((E6*13>G6),\"Error in submitting Games Won or Points Home\",\"OK\"))","v":""},{"$f":"IF(E6=\"\",\"\",IF((F6*13>H6),\"Error in submitting Games Won or Points Away\",\"OK\"))","v":""}]
[{"$f":"Template!B22","v":"22.05.2017"},{"$f":"B6+1","v":3},"Home","Old Bulls Head",2,3,52,48,{"$f":"IF(E7=\"\",\"\",IF(E7>2,1,0))","v":0},{"$f":"IF(E7=\"\",\"\",IF(OR(E7<0,E7>5,G7<0,G7>(5*13),H7<0,H7>(5*13)),\"Number out of range error\",\"Valid Scores entered\"))","v":"Valid Scores entered"},{"$f":"IF(E7=\"\",\"\",IF((E7*13>G7),\"Error in submitting Games Won or Points Home\",\"OK\"))","v":"OK"},"OK"]
[{"$f":"Template!B23","v":"05.06.2017"},4,"Away",{"$f":"Template!B8","v":"Farmers Boy"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D8,\"'!$F8\"))","v":1},4,{"$f":"INDIRECT(CONCATENATE(\"'\",$D8,\"'!H8\"))","v":18},{"$f":"INDIRECT(CONCATENATE(\"'\",$D8,\"'!G8\"))","v":58},0,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B24","v":"12.06.2017"},5,"Home",{"$f":"Template!B7","v":"George Bees"},3,2,46,46,1,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B25","v":"19.06.2017"},6,"Away",{"$f":"Template!C25","v":"Drifters"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D10,\"'!$F10\"))","v":1},4,{"$f":"INDIRECT(CONCATENATE(\"'\",$D10,\"'!H10\"))","v":26},{"$f":"INDIRECT(CONCATENATE(\"'\",$D10,\"'!G10\"))","v":62},0,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B26","v":"26.06.2017"},7,"Home",{"$f":"Template!D26","v":"Bye"},null,"",null,null,"","","",""]
[{"$f":"Template!B27","v":"03.07.2017"},8,"Away",{"$f":"Template!C27","v":"Bye2"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D12,\"'!$F12\"))","v":""},"",{"$f":"INDIRECT(CONCATENATE(\"'\",$D12,\"'!H12\"))","v":0},{"$f":"INDIRECT(CONCATENATE(\"'\",$D12,\"'!G12\"))","v":0},"","","",""]
[{"$f":"Template!B28","v":"10.07.2017"},9,"Home",{"$f":"Template!D28","v":"Brown Bear"},0,5,31,65,0,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B29","v":"17.07.2017"},10,"Away",{"$f":"Template!C29","v":"Hen and Chickens"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D14,\"'!$F14\"))","v":2},3,{"$f":"INDIRECT(CONCATENATE(\"'\",$D14,\"'!H14\"))","v":48},{"$f":"INDIRECT(CONCATENATE(\"'\",$D14,\"'!G14\"))","v":56},0,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B30","v":"24.07.2017"},11,"Home",{"$f":"Template!D30","v":"Plough OldUns"},3,2,42,52,1,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B31","v":"31.07.2017"},12,"Away",{"$f":"Template!C31","v":"Old Bulls Head"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D16,\"'!$F16\"))","v":1},4,{"$f":"INDIRECT(CONCATENATE(\"'\",$D16,\"'!H16\"))","v":23},{"$f":"INDIRECT(CONCATENATE(\"'\",$D16,\"'!G16\"))","v":59},0,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B32","v":"07.08.2017"},13,"Home",{"$f":"Template!D32","v":"Farmers Boy"},2,3,42,52,0,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B33","v":"14.08.2017"},14,"Away",{"$f":"Template!C33","v":"George Bees"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D18,\"'!$F18\"))","v":0},5,{"$f":"INDIRECT(CONCATENATE(\"'\",$D18,\"'!H18\"))","v":33},{"$f":"INDIRECT(CONCATENATE(\"'\",$D18,\"'!G18\"))","v":65},0,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B34","v":"21.08.2017"},15,"Home",{"$f":"Template!D34","v":"Drifters"},0,5,28,65,0,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B35","v":"04.09.2017"},16,"Away",{"$f":"Template!C35","v":"Bye"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D20,\"'!$F20\"))","v":""},"",{"$f":"INDIRECT(CONCATENATE(\"'\",$D20,\"'!H20\"))","v":0},{"$f":"INDIRECT(CONCATENATE(\"'\",$D20,\"'!G20\"))","v":0},"","","",""]
[{"$f":"Template!B36","v":"11.09.2017"},17,"Home",{"$f":"Template!D36","v":"Bye2"},null,"",null,null,"","","",""]
[{"$f":"Template!B37","v":"18.09.2017"},18,"Away",{"$f":"Template!C37","v":"Brown Bear"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D22,\"'!$F22\"))","v":1},4,{"$f":"INDIRECT(CONCATENATE(\"'\",$D22,\"'!H22\"))","v":57},{"$f":"INDIRECT(CONCATENATE(\"'\",$D22,\"'!G22\"))","v":63},0,"Valid Scores entered","OK","OK"]
[null,null,{"$f":"CONCATENATE(\"Home Games:\",COUNTIF(C5:C22,\"Home\"),\" Away Games:\",COUNTIF(C5:C22,\"Away\"))","v":"Home Games:9 Away Games:9"}]

{"sheet":"Brown Bear","index":2,"n_rows":23,"n_cols":12,"rows_kept":23,"cut":false,"hidden":false,"merged":[[2,10,2,11]]}
[]
["Team",{"$f":"Template!B3","v":"Brown Bear"}]
[null,null,null,null,null,null,null,null,null,null,"Check that there are enough points to win the games"]
["Date","Week","Home/Away","Opponent","Games Won","Games lost","Points For","Points Against","Match Won?","Check that input numbers are within range","Home","Away"]
[{"$f":"Template!B20","v":"08.05.2017"},1,"Home",{"$f":"Template!C5","v":"Plough OldUns"},2,{"$f":"IF(E5=\"\",\"\",5-E5)","v":3},53,61,{"$f":"IF(E5=\"\",\"\",IF(E5>2,1,0))","v":0},{"$f":"IF(E5=\"\",\"\",IF(OR(E5<0,E5>5,G5<0,G5>(5*13),H5<0,H5>(5*13)),\"Number out of range error\",\"Valid Scores entered\"))","v":"Valid Scores entered"},{"$f":"IF(E5=\"\",\"\",IF((E5*13>G5),\"Error in submitting Games Won or Points Home\",\"OK\"))","v":"OK"},{"$f":"IF(E5=\"\",\"\",IF((F5*13>H5),\"Error in submitting Games Won or Points Away\",\"OK\"))","v":"OK"}]
[{"$f":"Template!B21","v":"15.05.2017"},{"$f":"B5+1","v":2},"Away",{"$f":"Template!B9","v":"Old Bulls Head"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D6,\"'!$F6\"))","v":2},3,{"$f":"INDIRECT(CONCATENATE(\"'\",$D6,\"'!H6\"))","v":56},{"$f":"INDIRECT(CONCATENATE(\"'\",$D6,\"'!G6\"))","v":50},{"$f":"IF(E6=\"\",\"\",IF(E6>2,1,0))","v":0},{"$f":"IF(E6=\"\",\"\",IF(OR(E6<0,E6>5,G6<0,G6>(5*13),H6<0,H6>(5*13)),\"Number out of range error\",\"Valid Scores entered\"))","v":"Valid Scores entered"},{"$f":"IF(E6=\"\",\"\",IF((E6*13>G6),\"Error in submitting Games Won or Points Home\",\"OK\"))","v":"OK"},{"$f":"IF(E6=\"\",\"\",IF((F6*13>H6),\"Error in submitting Games Won or Points Away\",\"OK\"))","v":"OK"}]
[{"$f":"Template!B22","v":"22.05.2017"},{"$f":"B6+1","v":3},"Home",{"$f":"Template!B8","v":"Farmers Boy"},2,3,51,44,0,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B23","v":"05.06.2017"},4,"Away",{"$f":"Template!B7","v":"George Bees"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D8,\"'!$F8\"))","v":1},4,{"$f":"INDIRECT(CONCATENATE(\"'\",$D8,\"'!H8\"))","v":46},{"$f":"INDIRECT(CONCATENATE(\"'\",$D8,\"'!G8\"))","v":60},0,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B24","v":"12.06.2017"},5,"Home",{"$f":"Template!B6","v":"Drifters"},5,0,65,50,1,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B25","v":"19.06.2017"},6,"Away",{"$f":"Template!B5","v":"Bye"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D10,\"'!$F10\"))","v":""},"",{"$f":"INDIRECT(CONCATENATE(\"'\",$D10,\"'!H10\"))","v":0},{"$f":"INDIRECT(CONCATENATE(\"'\",$D10,\"'!G10\"))","v":0},"","","",""]
[{"$f":"Template!B26","v":"26.06.2017"},7,"Home",{"$f":"Template!B4","v":"Bye2"},null,"",null,null,"","","",""]
[{"$f":"Template!B27","v":"03.07.2017"},8,"Home",{"$f":"Template!B11","v":"Hen and Chickens"},4,1,59,45,1,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B28","v":"10.07.2017"},9,"Away",{"$f":"Template!B2","v":"George A"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D13,\"'!$F13\"))","v":5},0,{"$f":"INDIRECT(CONCATENATE(\"'\",$D13,\"'!H13\"))","v":65},{"$f":"INDIRECT(CONCATENATE(\"'\",$D13,\"'!G13\"))","v":31},1,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B29","v":"17.07.2017"},10,"Away",{"$f":"Template!B10","v":"Plough OldUns"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D14,\"'!$F14\"))","v":4},1,{"$f":"INDIRECT(CONCATENATE(\"'\",$D14,\"'!H14\"))","v":58},{"$f":"INDIRECT(CONCATENATE(\"'\",$D14,\"'!G14\"))","v":40},1,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B30","v":"24.07.2017"},11,"Home",{"$f":"Template!B9","v":"Old Bulls Head"},1,4,54,64,0,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B31","v":"31.07.2017"},12,"Away",{"$f":"Template!B8","v":"Farmers Boy"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D16,\"'!$F16\"))","v":1},4,{"$f":"INDIRECT(CONCATENATE(\"'\",$D16,\"'!H16\"))","v":37},{"$f":"INDIRECT(CONCATENATE(\"'\",$D16,\"'!G16\"))","v":53},0,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B32","v":"07.08.2017"},13,"Home",{"$f":"Template!B7","v":"George Bees"},2,3,43,55,0,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B33","v":"14.08.2017"},14,"Away",{"$f":"Template!B6","v":"Drifters"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D18,\"'!$F18\"))","v":3},2,{"$f":"INDIRECT(CONCATENATE(\"'\",$D18,\"'!H18\"))","v":45},{"$f":"INDIRECT(CONCATENATE(\"'\",$D18,\"'!G18\"))","v":47},1,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B34","v":"21.08.2017"},15,"Home",{"$f":"Template!B5","v":"Bye"},null,"",null,null,"","","",""]
[{"$f":"Template!B35","v":"04.09.2017"},16,"Away",{"$f":"Template!B4","v":"Bye2"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D20,\"'!$F20\"))","v":""},"",{"$f":"INDIRECT(CONCATENATE(\"'\",$D20,\"'!H20\"))","v":0},{"$f":"INDIRECT(CONCATENATE(\"'\",$D20,\"'!G20\"))","v":0},"","","",""]
[{"$f":"Template!B36","v":"11.09.2017"},17,"Away",{"$f":"Template!K36","v":"Hen and Chickens"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D21,\"'!$F21\"))","v":1},4,{"$f":"INDIRECT(CONCATENATE(\"'\",$D21,\"'!H21\"))","v":50},{"$f":"INDIRECT(CONCATENATE(\"'\",$D21,\"'!G21\"))","v":60},0,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B37","v":"18.09.2017"},18,"Home",{"$f":"Template!B2","v":"George A"},4,1,63,57,1,"Valid Scores entered","OK","OK"]
[null,null,{"$f":"CONCATENATE(\"Home Games:\",COUNTIF(C5:C22,\"Home\"),\" Away Games:\",COUNTIF(C5:C22,\"Away\"))","v":"Home Games:9 Away Games:9"}]

{"sheet":"Bye2","index":3,"n_rows":23,"n_cols":12,"rows_kept":23,"cut":false,"hidden":false,"merged":[[2,10,2,11]]}
[]
["Team",{"$f":"Template!B4","v":"Bye2"}]
[null,null,null,null,null,null,null,null,null,null,"Check that there are enough points to win the games"]
["Date","Week","Home/Away","Opponent","Games Won","Games lost","Points For","Points Against","Match Won?","Check that input numbers are within range","Home","Away"]
[{"$f":"Template!B20","v":"08.05.2017"},1,"Home",{"$f":"Template!H20","v":"Old Bulls Head"},null,{"$f":"IF(E5=\"\",\"\",5-E5)","v":""},null,null,{"$f":"IF(E5=\"\",\"\",IF(E5>2,1,0))","v":""},{"$f":"IF(E5=\"\",\"\",IF(OR(E5<0,E5>5,G5<0,G5>(5*13),H5<0,H5>(5*13)),\"Number out of range error\",\"Valid Scores entered\"))","v":""},{"$f":"IF(E5=\"\",\"\",IF((E5*13>G5),\"Error in submitting Games Won or Points Home\",\"OK\"))","v":""},{"$f":"IF(E5=\"\",\"\",IF((F5*13>H5),\"Error in submitting Games Won or Points Away\",\"OK\"))","v":""}]
[{"$f":"Template!B21","v":"15.05.2017"},{"$f":"B5+1","v":2},"Away",{"$f":"Template!G21","v":"Farmers Boy"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D6,\"'!$F6\"))","v":""},"",{"$f":"INDIRECT(CONCATENATE(\"'\",$D6,\"'!H6\"))","v":0},{"$f":"INDIRECT(CONCATENATE(\"'\",$D6,\"'!G6\"))","v":0},{"$f":"IF(E6=\"\",\"\",IF(E6>2,1,0))","v":""},{"$f":"IF(E6=\"\",\"\",IF(OR(E6<0,E6>5,G6<0,G6>(5*13),H6<0,H6>(5*13)),\"Number out of range error\",\"Valid Scores entered\"))","v":""},{"$f":"IF(E6=\"\",\"\",IF((E6*13>G6),\"Error in submitting Games Won or Points Home\",\"OK\"))","v":""},{"$f":"IF(E6=\"\",\"\",IF((F6*13>H6),\"Error in submitting Games Won or Points Away\",\"OK\"))","v":""}]
[{"$f":"Template!B22","v":"22.05.2017"},{"$f":"B6+1","v":3},"Home",{"$f":"Template!H22","v":"George Bees"},null,"",null,null,"","","",""]
[{"$f":"Template!B23","v":"05.06.2017"},4,"Away",{"$f":"Template!G23","v":"Drifters"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D8,\"'!$F8\"))","v":""},"",{"$f":"INDIRECT(CONCATENATE(\"'\",$D8,\"'!H8\"))","v":0},{"$f":"INDIRECT(CONCATENATE(\"'\",$D8,\"'!G8\"))","v":0},"","","",""]
[{"$f":"Template!B24","v":"12.06.2017"},5,"Home",{"$f":"Template!H24","v":"Bye"},null,"",null,null,"","","",""]
[{"$f":"Template!B25","v":"19.06.2017"},6,"Home",{"$f":"Template!L25","v":"Hen and Chickens"},null,"",null,null,"","","",""]
[{"$f":"Template!B26","v":"26.06.2017"},7,"Away",{"$f":"Template!E26","v":"Brown Bear"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D11,\"'!$F11\"))","v":""},{"$f":"IF(E11=\"\",\"\",5-E11)","v":""},{"$f":"INDIRECT(CONCATENATE(\"'\",$D11,\"'!H11\"))","v":0},{"$f":"INDIRECT(CONCATENATE(\"'\",$D11,\"'!G11\"))","v":0},{"$f":"IF(E11=\"\",\"\",IF(E11>2,1,0))","v":""},{"$f":"IF(E11=\"\",\"\",IF(OR(E11<0,E11>5,G11<0,G11>(5*13),H11<0,H11>(5*13)),\"Number out of range error\",\"Valid Scores entered\"))","v":""},{"$f":"IF(E11=\"\",\"\",IF((E11*13>G11),\"Error in submitting Games Won or Points Home\",\"OK\"))","v":""},{"$f":"IF(E11=\"\",\"\",IF((F11*13>H11),\"Error in submitting Games Won or Points Away\",\"OK\"))","v":""}]
[{"$f":"Template!B27","v":"03.07.2017"},8,"Home",{"$f":"Template!D27","v":"George A"},null,"",null,null,"","","",""]
[{"$f":"Template!B28","v":"10.07.2017"},9,"Away",{"$f":"Template!I28","v":"Plough OldUns"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D13,\"'!$F13\"))","v":""},"",{"$f":"INDIRECT(CONCATENATE(\"'\",$D13,\"'!H13\"))","v":0},{"$f":"INDIRECT(CONCATENATE(\"'\",$D13,\"'!G13\"))","v":0},"","","",""]
[{"$f":"Template!B29","v":"17.07.2017"},10,"Away",{"$f":"Template!G29","v":"Old Bulls Head"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D14,\"'!$F14\"))","v":""},{"$f":"IF(E14=\"\",\"\",5-E14)","v":""},{"$f":"INDIRECT(CONCATENATE(\"'\",$D14,\"'!H14\"))","v":0},{"$f":"INDIRECT(CONCATENATE(\"'\",$D14,\"'!G14\"))","v":0},{"$f":"IF(E14=\"\",\"\",IF(E14>2,1,0))","v":""},{"$f":"IF(E14=\"\",\"\",IF(OR(E14<0,E14>5,G14<0,G14>(5*13),H14<0,H14>(5*13)),\"Number out of range error\",\"Valid Scores entered\"))","v":""},{"$f":"IF(E14=\"\",\"\",IF((E14*13>G14),\"Error in submitting Games Won or Points Home\",\"OK\"))","v":""},{"$f":"IF(E14=\"\",\"\",IF((F14*13>H14),\"Error in submitting Games Won or Points Away\",\"OK\"))","v":""}]
[{"$f":"Template!B30","v":"24.07.2017"},11,"Home",{"$f":"Template!H30","v":"Farmers Boy"},null,"",null,null,"","","",""]
[{"$f":"Template!B31","v":"31.07.2017"},12,"Away",{"$f":"Template!G31","v":"George Bees"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D16,\"'!$F16\"))","v":""},"",{"$f":"INDIRECT(CONCATENATE(\"'\",$D16,\"'!H16\"))","v":0},{"$f":"INDIRECT(CONCATENATE(\"'\",$D16,\"'!G16\"))","v":0},"","","",""]
[{"$f":"Template!B32","v":"07.08.2017"},13,"Home",{"$f":"Template!H32","v":"Drifters"},null,"",null,null,"","","",""]
[{"$f":"Template!B33","v":"14.08.2017"},14,"Away",{"$f":"Template!G33","v":"Bye"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D18,\"'!$F18\"))","v":""},"",{"$f":"INDIRECT(CONCATENATE(\"'\",$D18,\"'!H18\"))","v":0},{"$f":"INDIRECT(CONCATENATE(\"'\",$D18,\"'!G18\"))","v":0},"","","",""]
[{"$f":"Template!B34","v":"21.08.2017"},15,"Away",{"$f":"Template!K34","v":"Hen and Chickens"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D19,\"'!$F19\"))","v":""},"",{"$f":"INDIRECT(CONCATENATE(\"'\",$D19,\"'!H19\"))","v":0},{"$f":"INDIRECT(CONCATENATE(\"'\",$D19,\"'!G19\"))","v":0},"","","",""]
[{"$f":"Template!B35","v":"04.09.2017"},16,"Home",{"$f":"Template!F35","v":"Brown Bear"},null,"",null,null,"","","",""]
[{"$f":"Template!B36","v":"11.09.2017"},17,"Away",{"$f":"Template!C36","v":"George A"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D21,\"'!$F21\"))","v":""},"",{"$f":"INDIRECT(CONCATENATE(\"'\",$D21,\"'!H21\"))","v":0},{"$f":"INDIRECT(CONCATENATE(\"'\",$D21,\"'!G21\"))","v":0},"","","",""]
[{"$f":"Template!B37","v":"18.09.2017"},18,"Home",{"$f":"Template!J37","v":"Plough OldUns"},null,"",null,null,"","","",""]
[null,null,{"$f":"CONCATENATE(\"Home Games:\",COUNTIF(C5:C22,\"Home\"),\" Away Games:\",COUNTIF(C5:C22,\"Away\"))","v":"Home Games:9 Away Games:9"}]

{"sheet":"Bye","index":4,"n_rows":23,"n_cols":12,"rows_kept":23,"cut":false,"hidden":false,"merged":[[2,10,2,11]]}
[]
["Team",{"$f":"Template!B5","v":"Bye"}]
[null,null,null,null,null,null,null,null,null,null,"Check that there are enough points to win the games"]
["Date","Week","Home/Away","Opponent","Games Won","Games lost","Points For","Points Against","Match Won?","Check that input numbers are within range","Home","Away"]
[{"$f":"Template!B20","v":"08.05.2017"},1,"Home",{"$f":"Template!J20","v":"Farmers Boy"},null,{"$f":"IF(E5=\"\",\"\",5-E5)","v":""},null,null,{"$f":"IF(E5=\"\",\"\",IF(E5>2,1,0))","v":""},{"$f":"IF(E5=\"\",\"\",IF(OR(E5<0,E5>5,G5<0,G5>(5*13),H5<0,H5>(5*13)),\"Number out of range error\",\"Valid Scores entered\"))","v":""},{"$f":"IF(E5=\"\",\"\",IF((E5*13>G5),\"Error in submitting Games Won or Points Home\",\"OK\"))","v":""},{"$f":"IF(E5=\"\",\"\",IF((F5*13>H5),\"Error in submitting Games Won or Points Away\",\"OK\"))","v":""}]
[{"$f":"Template!B21","v":"15.05.2017"},{"$f":"B5+1","v":2},"Away",{"$f":"Template!I21","v":"George Bees"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D6,\"'!$F6\"))","v":""},"",{"$f":"INDIRECT(CONCATENATE(\"'\",$D6,\"'!H6\"))","v":0},{"$f":"INDIRECT(CONCATENATE(\"'\",$D6,\"'!G6\"))","v":0},{"$f":"IF(E6=\"\",\"\",IF(E6>2,1,0))","v":""},{"$f":"IF(E6=\"\",\"\",IF(OR(E6<0,E6>5,G6<0,G6>(5*13),H6<0,H6>(5*13)),\"Number out of range error\",\"Valid Scores entered\"))","v":""},{"$f":"IF(E6=\"\",\"\",IF((E6*13>G6),\"Error in submitting Games Won or Points Home\",\"OK\"))","v":""},{"$f":"IF(E6=\"\",\"\",IF((F6*13>H6),\"Error in submitting Games Won or Points Away\",\"OK\"))","v":""}]
[{"$f":"Template!B22","v":"22.05.2017"},{"$f":"B6+1","v":3},"Home",{"$f":"Template!J22","v":"Drifters"},null,"",null,null,"","","",""]
[{"$f":"Template!B23","v":"05.06.2017"},4,"Home",{"$f":"Template!L23","v":"Hen and Chickens"},null,"",null,null,"","","",""]
[{"$f":"Template!B24","v":"12.06.2017"},5,"Away",{"$f":"Template!G24","v":"Bye2"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D9,\"'!$F9\"))","v":""},"",{"$f":"INDIRECT(CONCATENATE(\"'\",$D9,\"'!H9\"))","v":0},{"$f":"INDIRECT(CONCATENATE(\"'\",$D9,\"'!G9\"))","v":0},"","","",""]
[{"$f":"Template!B25","v":"19.06.2017"},6,"Home",{"$f":"Template!F25","v":"Brown Bear"},null,"",null,null,"","","",""]
[{"$f":"Template!B26","v":"26.06.2017"},7,"Away",{"$f":"Template!C26","v":"George A"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D11,\"'!$F11\"))","v":""},"",{"$f":"INDIRECT(CONCATENATE(\"'\",$D11,\"'!H11\"))","v":0},{"$f":"INDIRECT(CONCATENATE(\"'\",$D11,\"'!G11\"))","v":0},"","","",""]
[{"$f":"Template!B27","v":"03.07.2017"},8,"Home",{"$f":"Template!J27","v":"Plough OldUns"},null,"",null,null,"","","",""]
[{"$f":"Template!B28","v":"10.07.2017"},9,"Away",{"$f":"Template!G28","v":"Old Bulls Head"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D13,\"'!$F13\"))","v":""},"",{"$f":"INDIRECT(CONCATENATE(\"'\",$D13,\"'!H13\"))","v":0},{"$f":"INDIRECT(CONCATENATE(\"'\",$D13,\"'!G13\"))","v":0},"","","",""]
[{"$f":"Template!B29","v":"17.07.2017"},10,"Away",{"$f":"Template!I29","v":"Farmers Boy"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D14,\"'!$F14\"))","v":""},"",{"$f":"INDIRECT(CONCATENATE(\"'\",$D14,\"'!H14\"))","v":0},{"$f":"INDIRECT(CONCATENATE(\"'\",$D14,\"'!G14\"))","v":0},"","","",""]
[{"$f":"Template!B30","v":"24.07.2017"},11,"Home",{"$f":"Template!J30","v":"George Bees"},null,"",null,null,"","","",""]
[{"$f":"Template!B31","v":"31.07.2017"},12,"Away",{"$f":"Template!I31","v":"Drifters"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D16,\"'!$F16\"))","v":""},"",{"$f":"INDIRECT(CONCATENATE(\"'\",$D16,\"'!H16\"))","v":0},{"$f":"INDIRECT(CONCATENATE(\"'\",$D16,\"'!G16\"))","v":0},"","","",""]
[{"$f":"Template!B32","v":"07.08.2017"},13,"Away",{"$f":"Template!K32","v":"Hen and Chickens"},null,"",null,null,"","","",""]
[{"$f":"Template!B33","v":"14.08.2017"},14,"Home",{"$f":"Template!H33","v":"Bye2"},null,"",null,null,"","","",""]
[{"$f":"Template!B34","v":"21.08.2017"},15,"Away",{"$f":"Template!E34","v":"Brown Bear"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D19,\"'!$F19\"))","v":""},"",{"$f":"INDIRECT(CONCATENATE(\"'\",$D19,\"'!H19\"))","v":0},{"$f":"INDIRECT(CONCATENATE(\"'\",$D19,\"'!G19\"))","v":0},"","","",""]
[{"$f":"Template!B35","v":"04.09.2017"},16,"Home",{"$f":"Template!D35","v":"George A"},null,"",null,null,"","","",""]
[{"$f":"Template!B36","v":"11.09.2017"},17,"Away",{"$f":"Template!I36","v":"Plough OldUns"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D21,\"'!$F21\"))","v":""},"",{"$f":"INDIRECT(CONCATENATE(\"'\",$D21,\"'!H21\"))","v":0},{"$f":"INDIRECT(CONCATENATE(\"'\",$D21,\"'!G21\"))","v":0},"","","",""]
[{"$f":"Template!B37","v":"18.09.2017"},18,"Home",{"$f":"Template!H37","v":"Old Bulls Head"},null,"",null,null,"","","",""]
[null,null,{"$f":"CONCATENATE(\"Home Games:\",COUNTIF(C5:C22,\"Home\"),\" Away Games:\",COUNTIF(C5:C22,\"Away\"))","v":"Home Games:9 Away Games:9"}]

{"sheet":"Drifters","index":5,"n_rows":23,"n_cols":12,"rows_kept":23,"cut":false,"hidden":false,"merged":[[2,10,2,11]]}
[]
["Team",{"$f":"Template!B6","v":"Drifters"}]
[null,null,null,null,null,null,null,null,null,null,"Check that there are enough points to win the games"]
["Date","Week","Home/Away","Opponent","Games Won","Games lost","Points For","Points Against","Match Won?","Check that input numbers are within range","Home","Away"]
[{"$f":"Template!B20","v":"08.05.2017"},1,"Home",{"$f":"Template!L20","v":"George Bees"},3,{"$f":"IF(E5=\"\",\"\",5-E5)","v":2},59,40,{"$f":"IF(E5=\"\",\"\",IF(E5>2,1,0))","v":1},{"$f":"IF(E5=\"\",\"\",IF(OR(E5<0,E5>5,G5<0,G5>(5*13),H5<0,H5>(5*13)),\"Number out of range error\",\"Valid Scores entered\"))","v":"Valid Scores entered"},{"$f":"IF(E5=\"\",\"\",IF((E5*13>G5),\"Error in submitting Games Won or Points Home\",\"OK\"))","v":"OK"},{"$f":"IF(E5=\"\",\"\",IF((F5*13>H5),\"Error in submitting Games Won or Points Away\",\"OK\"))","v":"OK"}]
[{"$f":"Template!B21","v":"15.05.2017"},{"$f":"B5+1","v":2},"Away",{"$f":"Template!K21","v":"Hen and Chickens"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D6,\"'!$F6\"))","v":3},2,{"$f":"INDIRECT(CONCATENATE(\"'\",$D6,\"'!H6\"))","v":50},{"$f":"INDIRECT(CONCATENATE(\"'\",$D6,\"'!G6\"))","v":40},{"$f":"IF(E6=\"\",\"\",IF(E6>2,1,0))","v":1},{"$f":"IF(E6=\"\",\"\",IF(OR(E6<0,E6>5,G6<0,G6>(5*13),H6<0,H6>(5*13)),\"Number out of range error\",\"Valid Scores entered\"))","v":"Valid Scores entered"},{"$f":"IF(E6=\"\",\"\",IF((E6*13>G6),\"Error in submitting Games Won or Points Home\",\"OK\"))","v":"OK"},{"$f":"IF(E6=\"\",\"\",IF((F6*13>H6),\"Error in submitting Games Won or Points Away\",\"OK\"))","v":"OK"}]
[{"$f":"Template!B22","v":"22.05.2017"},{"$f":"B6+1","v":3},"Away",{"$f":"Template!I22","v":"Bye"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D7,\"'!$F7\"))","v":""},"",{"$f":"INDIRECT(CONCATENATE(\"'\",$D7,\"'!H7\"))","v":0},{"$f":"INDIRECT(CONCATENATE(\"'\",$D7,\"'!G7\"))","v":0},"","","",""]
[{"$f":"Template!B23","v":"05.06.2017"},4,"Home",{"$f":"Template!H23","v":"Bye2"},null,"",null,null,"","","",""]
[{"$f":"Template!B24","v":"12.06.2017"},5,"Away",{"$f":"Template!E24","v":"Brown Bear"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D9,\"'!$F9\"))","v":0},5,{"$f":"INDIRECT(CONCATENATE(\"'\",$D9,\"'!H9\"))","v":50},{"$f":"INDIRECT(CONCATENATE(\"'\",$D9,\"'!G9\"))","v":65},0,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B25","v":"19.06.2017"},6,"Home",{"$f":"Template!D25","v":"George A"},4,1,62,26,1,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B26","v":"26.06.2017"},7,"Away",{"$f":"Template!I26","v":"Plough OldUns"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D11,\"'!$F11\"))","v":2},3,{"$f":"INDIRECT(CONCATENATE(\"'\",$D11,\"'!H11\"))","v":47},{"$f":"INDIRECT(CONCATENATE(\"'\",$D11,\"'!G11\"))","v":59},0,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B27","v":"03.07.2017"},8,"Home",{"$f":"Template!H27","v":"Old Bulls Head"},5,0,65,35,1,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B28","v":"10.07.2017"},9,"Away",{"$f":"Template!E28","v":"Farmers Boy"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D13,\"'!$F13\"))","v":1},4,{"$f":"INDIRECT(CONCATENATE(\"'\",$D13,\"'!H13\"))","v":37},{"$f":"INDIRECT(CONCATENATE(\"'\",$D13,\"'!G13\"))","v":61},0,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B29","v":"17.07.2017"},10,"Away",{"$f":"Template!K29","v":"George Bees"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D14,\"'!$F14\"))","v":3},2,{"$f":"INDIRECT(CONCATENATE(\"'\",$D14,\"'!H14\"))","v":52},{"$f":"INDIRECT(CONCATENATE(\"'\",$D14,\"'!G14\"))","v":51},1,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B30","v":"24.07.2017"},11,"Home",{"$f":"Template!L30","v":"Hen and Chickens"},3,2,57,44,1,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B31","v":"31.07.2017"},12,"Home",{"$f":"Template!J31","v":"Bye"},null,"",null,null,"","","",""]
[{"$f":"Template!B32","v":"07.08.2017"},13,"Away",{"$f":"Template!G32","v":"Bye2"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D17,\"'!$F17\"))","v":""},"",{"$f":"INDIRECT(CONCATENATE(\"'\",$D17,\"'!H17\"))","v":0},{"$f":"INDIRECT(CONCATENATE(\"'\",$D17,\"'!G17\"))","v":0},"","","",""]
[{"$f":"Template!B33","v":"14.08.2017"},14,"Home",{"$f":"Template!F33","v":"Brown Bear"},2,3,47,45,0,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B34","v":"21.08.2017"},15,"Away",{"$f":"Template!C34","v":"George A"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D19,\"'!$F19\"))","v":5},0,{"$f":"INDIRECT(CONCATENATE(\"'\",$D19,\"'!H19\"))","v":65},{"$f":"INDIRECT(CONCATENATE(\"'\",$D19,\"'!G19\"))","v":28},1,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B35","v":"04.09.2017"},16,"Home",{"$f":"Template!J35","v":"Plough OldUns"},4,1,55,43,1,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B36","v":"11.09.2017"},17,"Away",{"$f":"Template!G36","v":"Old Bulls Head"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D21,\"'!$F21\"))","v":2},3,{"$f":"INDIRECT(CONCATENATE(\"'\",$D21,\"'!H21\"))","v":43},{"$f":"INDIRECT(CONCATENATE(\"'\",$D21,\"'!G21\"))","v":63},0,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B37","v":"18.09.2017"},18,"Home",{"$f":"Template!F37","v":"Farmers Boy"},3,2,57,38,1,"Valid Scores entered","OK","OK"]
[null,null,{"$f":"CONCATENATE(\"Home Games:\",COUNTIF(C5:C22,\"Home\"),\" Away Games:\",COUNTIF(C5:C22,\"Away\"))","v":"Home Games:9 Away Games:9"}]

{"sheet":"George Bees","index":6,"n_rows":23,"n_cols":12,"rows_kept":23,"cut":false,"hidden":false,"merged":[[2,10,2,11]]}
[]
["Team",{"$f":"Template!B7","v":"George Bees"}]
[null,null,null,null,null,null,null,null,null,null,"Check that there are enough points to win the games"]
["Date","Week","Home/Away","Opponent","Games Won","Games lost","Points For","Points Against","Match Won?","Check that input numbers are within range","Home","Away"]
[{"$f":"Template!B20","v":"08.05.2017"},1,"Away",{"$f":"Template!K20","v":"Drifters"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D5,\"'!$F5\"))","v":2},{"$f":"IF(E5=\"\",\"\",5-E5)","v":3},{"$f":"INDIRECT(CONCATENATE(\"'\",$D5,\"'!H5\"))","v":40},{"$f":"INDIRECT(CONCATENATE(\"'\",$D5,\"'!G5\"))","v":59},{"$f":"IF(E5=\"\",\"\",IF(E5>2,1,0))","v":0},{"$f":"IF(E5=\"\",\"\",IF(OR(E5<0,E5>5,G5<0,G5>(5*13),H5<0,H5>(5*13)),\"Number out of range error\",\"Valid Scores entered\"))","v":"Valid Scores entered"},{"$f":"IF(E5=\"\",\"\",IF((E5*13>G5),\"Error in submitting Games Won or Points Home\",\"OK\"))","v":"OK"},{"$f":"IF(E5=\"\",\"\",IF((F5*13>H5),\"Error in submitting Games Won or Points Away\",\"OK\"))","v":"OK"}]
[{"$f":"Template!B21","v":"15.05.2017"},{"$f":"B5+1","v":2},"Home",{"$f":"Template!J21","v":"Bye"},null,"",null,null,{"$f":"IF(E6=\"\",\"\",IF(E6>2,1,0))","v":""},{"$f":"IF(E6=\"\",\"\",IF(OR(E6<0,E6>5,G6<0,G6>(5*13),H6<0,H6>(5*13)),\"Number out of range error\",\"Valid Scores entered\"))","v":""},{"$f":"IF(E6=\"\",\"\",IF((E6*13>G6),\"Error in submitting Games Won or Points Home\",\"OK\"))","v":""},{"$f":"IF(E6=\"\",\"\",IF((F6*13>H6),\"Error in submitting Games Won or Points Away\",\"OK\"))","v":""}]
[{"$f":"Template!B22","v":"22.05.2017"},{"$f":"B6+1","v":3},"Away",{"$f":"Template!G22","v":"Bye2"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D7,\"'!$F7\"))","v":""},"",{"$f":"INDIRECT(CONCATENATE(\"'\",$D7,\"'!H7\"))","v":0},{"$f":"INDIRECT(CONCATENATE(\"'\",$D7,\"'!G7\"))","v":0},"","","",""]
[{"$f":"Template!B23","v":"05.06.2017"},4,"Home",{"$f":"Template!F23","v":"Brown Bear"},4,1,60,46,1,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B24","v":"12.06.2017"},5,"Away",{"$f":"Template!C24","v":"George A"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D9,\"'!$F9\"))","v":2},3,{"$f":"INDIRECT(CONCATENATE(\"'\",$D9,\"'!H9\"))","v":46},{"$f":"INDIRECT(CONCATENATE(\"'\",$D9,\"'!G9\"))","v":46},0,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B25","v":"19.06.2017"},6,"Home",{"$f":"Template!J25","v":"Plough OldUns"},4,1,59,40,1,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B26","v":"26.06.2017"},7,"Away",{"$f":"Template!G26","v":"Old Bulls Head"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D11,\"'!$F11\"))","v":2},3,{"$f":"INDIRECT(CONCATENATE(\"'\",$D11,\"'!H11\"))","v":49},{"$f":"INDIRECT(CONCATENATE(\"'\",$D11,\"'!G11\"))","v":51},0,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B27","v":"03.07.2017"},8,"Home",{"$f":"Template!F27","v":"Farmers Boy"},5,0,65,26,1,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B28","v":"10.07.2017"},9,"Away",{"$f":"Template!K28","v":"Hen and Chickens"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D13,\"'!$F13\"))","v":1},4,{"$f":"INDIRECT(CONCATENATE(\"'\",$D13,\"'!H13\"))","v":41},{"$f":"INDIRECT(CONCATENATE(\"'\",$D13,\"'!G13\"))","v":52},0,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B29","v":"17.07.2017"},10,"Home",{"$f":"Template!L29","v":"Drifters"},2,3,51,52,0,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B30","v":"24.07.2017"},11,"Away",{"$f":"Template!I30","v":"Bye"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D15,\"'!$F15\"))","v":""},"",{"$f":"INDIRECT(CONCATENATE(\"'\",$D15,\"'!H15\"))","v":0},{"$f":"INDIRECT(CONCATENATE(\"'\",$D15,\"'!G15\"))","v":0},"","","",""]
[{"$f":"Template!B31","v":"31.07.2017"},12,"Home",{"$f":"Template!H31","v":"Bye2"},null,"",null,null,"","","",""]
[{"$f":"Template!B32","v":"07.08.2017"},13,"Away",{"$f":"Template!E32","v":"Brown Bear"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D17,\"'!$F17\"))","v":3},2,{"$f":"INDIRECT(CONCATENATE(\"'\",$D17,\"'!H17\"))","v":55},{"$f":"INDIRECT(CONCATENATE(\"'\",$D17,\"'!G17\"))","v":43},1,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B33","v":"14.08.2017"},14,"Home",{"$f":"Template!D33","v":"George A"},5,0,65,33,1,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B34","v":"21.08.2017"},15,"Away",{"$f":"Template!I34","v":"Plough OldUns"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D19,\"'!$F19\"))","v":2},3,{"$f":"INDIRECT(CONCATENATE(\"'\",$D19,\"'!H19\"))","v":49},{"$f":"INDIRECT(CONCATENATE(\"'\",$D19,\"'!G19\"))","v":51},0,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B35","v":"04.09.2017"},16,"Home",{"$f":"Template!H35","v":"Old Bulls Head"},2,3,37,57,0,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B36","v":"11.09.2017"},17,"Away",{"$f":"Template!E36","v":"Farmers Boy"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D21,\"'!$F21\"))","v":4},1,{"$f":"INDIRECT(CONCATENATE(\"'\",$D21,\"'!H21\"))","v":61},{"$f":"INDIRECT(CONCATENATE(\"'\",$D21,\"'!G21\"))","v":43},1,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B37","v":"18.09.2017"},18,"Home",{"$f":"Template!L37","v":"Hen and Chickens"},4,1,63,22,1,"Valid Scores entered","OK","OK"]
[null,null,{"$f":"CONCATENATE(\"Home Games:\",COUNTIF(C5:C22,\"Home\"),\" Away Games:\",COUNTIF(C5:C22,\"Away\"))","v":"Home Games:9 Away Games:9"}]

{"sheet":"Farmers Boy","index":7,"n_rows":23,"n_cols":12,"rows_kept":23,"cut":false,"hidden":false,"merged":[[2,10,2,11]]}
[]
["Team",{"$f":"Template!B8","v":"Farmers Boy"}]
[null,null,null,null,null,null,null,null,null,null,"Check that there are enough points to win the games"]
["Date","Week","Home/Away","Opponent","Games Won","Games lost","Points For","Points Against","Match Won?","Check that input numbers are within range","Home","Away"]
[{"$f":"Template!B20","v":"08.05.2017"},1,"Away",{"$f":"Template!I20","v":"Bye"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D5,\"'!$F5\"))","v":""},{"$f":"IF(E5=\"\",\"\",5-E5)","v":""},{"$f":"INDIRECT(CONCATENATE(\"'\",$D5,\"'!H5\"))","v":0},{"$f":"INDIRECT(CONCATENATE(\"'\",$D5,\"'!G5\"))","v":0},{"$f":"IF(E5=\"\",\"\",IF(E5>2,1,0))","v":""},{"$f":"IF(E5=\"\",\"\",IF(OR(E5<0,E5>5,G5<0,G5>(5*13),H5<0,H5>(5*13)),\"Number out of range error\",\"Valid Scores entered\"))","v":""},{"$f":"IF(E5=\"\",\"\",IF((E5*13>G5),\"Error in submitting Games Won or Points Home\",\"OK\"))","v":""},{"$f":"IF(E5=\"\",\"\",IF((F5*13>H5),\"Error in submitting Games Won or Points Away\",\"OK\"))","v":""}]
[{"$f":"Template!B21","v":"15.05.2017"},{"$f":"B5+1","v":2},"Home",{"$f":"Template!H21","v":"Bye2"},null,{"$f":"IF(E6=\"\",\"\",5-E6)","v":""},null,null,{"$f":"IF(E6=\"\",\"\",IF(E6>2,1,0))","v":""},{"$f":"IF(E6=\"\",\"\",IF(OR(E6<0,E6>5,G6<0,G6>(5*13),H6<0,H6>(5*13)),\"Number out of range error\",\"Valid Scores entered\"))","v":""},{"$f":"IF(E6=\"\",\"\",IF((E6*13>G6),\"Error in submitting Games Won or Points Home\",\"OK\"))","v":""},{"$f":"IF(E6=\"\",\"\",IF((F6*13>H6),\"Error in submitting Games Won or Points Away\",\"OK\"))","v":""}]
[{"$f":"Template!B22","v":"22.05.2017"},{"$f":"B6+1","v":3},"Away",{"$f":"Template!E22","v":"Brown Bear"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D7,\"'!$F7\"))","v":3},2,{"$f":"INDIRECT(CONCATENATE(\"'\",$D7,\"'!H7\"))","v":44},{"$f":"INDIRECT(CONCATENATE(\"'\",$D7,\"'!G7\"))","v":51},1,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B23","v":"05.06.2017"},4,"Home",{"$f":"Template!D23","v":"George A"},4,1,58,18,1,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B24","v":"12.06.2017"},5,"Away",{"$f":"Template!I24","v":"Plough OldUns"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D9,\"'!$F9\"))","v":2},3,{"$f":"INDIRECT(CONCATENATE(\"'\",$D9,\"'!H9\"))","v":47},{"$f":"INDIRECT(CONCATENATE(\"'\",$D9,\"'!G9\"))","v":46},0,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B25","v":"19.06.2017"},6,"Home",{"$f":"Template!H25","v":"Old Bulls Head"},3,2,61,53,1,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B26","v":"26.06.2017"},7,"Away",{"$f":"Template!K26","v":"Hen and Chickens"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D11,\"'!$F11\"))","v":2},3,{"$f":"INDIRECT(CONCATENATE(\"'\",$D11,\"'!H11\"))","v":53},{"$f":"INDIRECT(CONCATENATE(\"'\",$D11,\"'!G11\"))","v":59},0,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B27","v":"03.07.2017"},8,"Away",{"$f":"Template!E27","v":"George Bees"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D12,\"'!$F12\"))","v":0},5,{"$f":"INDIRECT(CONCATENATE(\"'\",$D12,\"'!H12\"))","v":26},{"$f":"INDIRECT(CONCATENATE(\"'\",$D12,\"'!G12\"))","v":65},0,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B28","v":"10.07.2017"},9,"Home",{"$f":"Template!F28","v":"Drifters"},4,1,61,37,1,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B29","v":"17.07.2017"},10,"Home",{"$f":"Template!J29","v":"Bye"},null,"",null,null,"","","",""]
[{"$f":"Template!B30","v":"24.07.2017"},11,"Away",{"$f":"Template!G30","v":"Bye2"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D15,\"'!$F15\"))","v":""},"",{"$f":"INDIRECT(CONCATENATE(\"'\",$D15,\"'!H15\"))","v":0},{"$f":"INDIRECT(CONCATENATE(\"'\",$D15,\"'!G15\"))","v":0},"","","",""]
[{"$f":"Template!B31","v":"31.07.2017"},12,"Home",{"$f":"Template!F31","v":"Brown Bear"},4,1,53,37,1,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B32","v":"07.08.2017"},13,"Away",{"$f":"Template!C32","v":"George A"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D17,\"'!$F17\"))","v":3},2,{"$f":"INDIRECT(CONCATENATE(\"'\",$D17,\"'!H17\"))","v":52},{"$f":"INDIRECT(CONCATENATE(\"'\",$D17,\"'!G17\"))","v":42},1,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B33","v":"14.08.2017"},14,"Home",{"$f":"Template!J33","v":"Plough OldUns"},5,0,65,39,1,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B34","v":"21.08.2017"},15,"Away",{"$f":"Template!G34","v":"Old Bulls Head"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D19,\"'!$F19\"))","v":3},2,{"$f":"INDIRECT(CONCATENATE(\"'\",$D19,\"'!H19\"))","v":57},{"$f":"INDIRECT(CONCATENATE(\"'\",$D19,\"'!G19\"))","v":50},1,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B35","v":"04.09.2017"},16,"Home",{"$f":"Template!L35","v":"Hen and Chickens"},4,1,64,38,1,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B36","v":"11.09.2017"},17,"Home",{"$f":"Template!F36","v":"George Bees"},1,4,43,61,0,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B37","v":"18.09.2017"},18,"Away",{"$f":"Template!E37","v":"Drifters"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D22,\"'!$F22\"))","v":2},3,{"$f":"INDIRECT(CONCATENATE(\"'\",$D22,\"'!H22\"))","v":38},{"$f":"INDIRECT(CONCATENATE(\"'\",$D22,\"'!G22\"))","v":57},0,"Valid Scores entered","OK","OK"]
[null,null,{"$f":"CONCATENATE(\"Home Games:\",COUNTIF(C5:C22,\"Home\"),\" Away Games:\",COUNTIF(C5:C22,\"Away\"))","v":"Home Games:9 Away Games:9"}]

{"sheet":"Old Bulls Head","index":8,"n_rows":23,"n_cols":12,"rows_kept":23,"cut":false,"hidden":false,"merged":[[2,10,2,11]]}
[]
["Team",{"$f":"Template!B9","v":"Old Bulls Head"}]
[null,null,null,null,null,null,null,null,null,null,"Check that there are enough points to win the games"]
["Date","Week","Home/Away","Opponent","Games Won","Games lost","Points For","Points Against","Match Won?","Check that input numbers are within range","Home","Away"]
[{"$f":"Template!B20","v":"08.05.2017"},1,"Away",{"$f":"Template!G20","v":"Bye2"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D5,\"'!$F5\"))","v":""},{"$f":"IF(E5=\"\",\"\",5-E5)","v":""},{"$f":"INDIRECT(CONCATENATE(\"'\",$D5,\"'!H5\"))","v":0},{"$f":"INDIRECT(CONCATENATE(\"'\",$D5,\"'!G5\"))","v":0},{"$f":"IF(E5=\"\",\"\",IF(E5>2,1,0))","v":""},{"$f":"IF(E5=\"\",\"\",IF(OR(E5<0,E5>5,G5<0,G5>(5*13),H5<0,H5>(5*13)),\"Number out of range error\",\"Valid Scores entered\"))","v":""},{"$f":"IF(E5=\"\",\"\",IF((E5*13>G5),\"Error in submitting Games Won or Points Home\",\"OK\"))","v":""},{"$f":"IF(E5=\"\",\"\",IF((F5*13>H5),\"Error in submitting Games Won or Points Away\",\"OK\"))","v":""}]
[{"$f":"Template!B21","v":"15.05.2017"},{"$f":"B5+1","v":2},"Home",{"$f":"Template!F21","v":"Brown Bear"},3,2,50,56,{"$f":"IF(E6=\"\",\"\",IF(E6>2,1,0))","v":1},{"$f":"IF(E6=\"\",\"\",IF(OR(E6<0,E6>5,G6<0,G6>(5*13),H6<0,H6>(5*13)),\"Number out of range error\",\"Valid Scores entered\"))","v":"Valid Scores entered"},{"$f":"IF(E6=\"\",\"\",IF((E6*13>G6),\"Error in submitting Games Won or Points Home\",\"OK\"))","v":"OK"},{"$f":"IF(E6=\"\",\"\",IF((F6*13>H6),\"Error in submitting Games Won or Points Away\",\"OK\"))","v":"OK"}]
[{"$f":"Template!B22","v":"22.05.2017"},{"$f":"B6+1","v":3},"Away",{"$f":"Template!C22","v":"George A"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D7,\"'!$F7\"))","v":3},2,{"$f":"INDIRECT(CONCATENATE(\"'\",$D7,\"'!H7\"))","v":48},{"$f":"INDIRECT(CONCATENATE(\"'\",$D7,\"'!G7\"))","v":52},1,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B23","v":"05.06.2017"},4,"Home",{"$f":"Template!J23","v":"Plough OldUns"},3,2,44,57,1,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B24","v":"12.06.2017"},5,"Away",{"$f":"Template!K24","v":"Hen and Chickens"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D9,\"'!$F9\"))","v":4},1,{"$f":"INDIRECT(CONCATENATE(\"'\",$D9,\"'!H9\"))","v":58},{"$f":"INDIRECT(CONCATENATE(\"'\",$D9,\"'!G9\"))","v":32},1,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B25","v":"19.06.2017"},6,"Away",{"$f":"Template!G25","v":"Farmers Boy"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D10,\"'!$F10\"))","v":2},3,{"$f":"INDIRECT(CONCATENATE(\"'\",$D10,\"'!H10\"))","v":53},{"$f":"INDIRECT(CONCATENATE(\"'\",$D10,\"'!G10\"))","v":61},0,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B26","v":"26.06.2017"},7,"Home",{"$f":"Template!H26","v":"George Bees"},3,2,51,49,1,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B27","v":"03.07.2017"},8,"Away",{"$f":"Template!G27","v":"Drifters"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D12,\"'!$F12\"))","v":0},5,{"$f":"INDIRECT(CONCATENATE(\"'\",$D12,\"'!H12\"))","v":35},{"$f":"INDIRECT(CONCATENATE(\"'\",$D12,\"'!G12\"))","v":65},0,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B28","v":"10.07.2017"},9,"Home",{"$f":"Template!H28","v":"Bye"},null,"",null,null,"","","",""]
[{"$f":"Template!B29","v":"17.07.2017"},10,"Home",{"$f":"Template!H29","v":"Bye2"},null,"",null,null,"","","",""]
[{"$f":"Template!B30","v":"24.07.2017"},11,"Away",{"$f":"Template!E30","v":"Brown Bear"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D15,\"'!$F15\"))","v":4},1,{"$f":"INDIRECT(CONCATENATE(\"'\",$D15,\"'!H15\"))","v":64},{"$f":"INDIRECT(CONCATENATE(\"'\",$D15,\"'!G15\"))","v":54},1,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B31","v":"31.07.2017"},12,"Home",{"$f":"Template!D31","v":"George A"},4,1,59,23,1,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B32","v":"07.08.2017"},13,"Away",{"$f":"Template!I32","v":"Plough OldUns"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D17,\"'!$F17\"))","v":1},4,{"$f":"INDIRECT(CONCATENATE(\"'\",$D17,\"'!H17\"))","v":45},{"$f":"INDIRECT(CONCATENATE(\"'\",$D17,\"'!G17\"))","v":55},0,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B33","v":"14.08.2017"},14,"Home",{"$f":"Template!L33","v":"Hen and Chickens"},3,2,58,42,1,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B34","v":"21.08.2017"},15,"Home",{"$f":"Template!H34","v":"Farmers Boy"},2,3,50,57,0,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B35","v":"04.09.2017"},16,"Away",{"$f":"Template!G35","v":"George Bees"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D20,\"'!$F20\"))","v":3},2,{"$f":"INDIRECT(CONCATENATE(\"'\",$D20,\"'!H20\"))","v":57},{"$f":"INDIRECT(CONCATENATE(\"'\",$D20,\"'!G20\"))","v":37},1,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B36","v":"11.09.2017"},17,"Home",{"$f":"Template!H36","v":"Drifters"},3,2,63,43,1,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B37","v":"18.09.2017"},18,"Away",{"$f":"Template!G37","v":"Bye"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D22,\"'!$F22\"))","v":""},"",{"$f":"INDIRECT(CONCATENATE(\"'\",$D22,\"'!H22\"))","v":0},{"$f":"INDIRECT(CONCATENATE(\"'\",$D22,\"'!G22\"))","v":0},"","","",""]
[null,null,{"$f":"CONCATENATE(\"Home Games:\",COUNTIF(C5:C22,\"Home\"),\" Away Games:\",COUNTIF(C5:C22,\"Away\"))","v":"Home Games:9 Away Games:9"}]

{"sheet":"Plough OldUns","index":9,"n_rows":23,"n_cols":12,"rows_kept":23,"cut":false,"hidden":false,"merged":[[2,10,2,11]]}
[]
["Team",{"$f":"Template!B10","v":"Plough OldUns"}]
[null,null,null,null,null,null,null,null,null,null,"Check that there are enough points to win the games"]
["Date","Week","Home/Away","Opponent","Games Won","Games lost","Points For","Points Against","Match Won?","Check that input numbers are within range","Home","Away"]
[{"$f":"Template!B20","v":"08.05.2017"},1,"Away",{"$f":"Template!E20","v":"Brown Bear"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D5,\"'!$F5\"))","v":3},{"$f":"IF(E5=\"\",\"\",5-E5)","v":2},{"$f":"INDIRECT(CONCATENATE(\"'\",$D5,\"'!H5\"))","v":61},{"$f":"INDIRECT(CONCATENATE(\"'\",$D5,\"'!G5\"))","v":53},{"$f":"IF(E5=\"\",\"\",IF(E5>2,1,0))","v":1},{"$f":"IF(E5=\"\",\"\",IF(OR(E5<0,E5>5,G5<0,G5>(5*13),H5<0,H5>(5*13)),\"Number out of range error\",\"Valid Scores entered\"))","v":"Valid Scores entered"},{"$f":"IF(E5=\"\",\"\",IF((E5*13>G5),\"Error in submitting Games Won or Points Home\",\"OK\"))","v":"OK"},{"$f":"IF(E5=\"\",\"\",IF((F5*13>H5),\"Error in submitting Games Won or Points Away\",\"OK\"))","v":"OK"}]
[{"$f":"Template!B21","v":"15.05.2017"},{"$f":"B5+1","v":2},"Home",{"$f":"Template!D21","v":"George A"},null,"",null,null,{"$f":"IF(E6=\"\",\"\",IF(E6>2,1,0))","v":""},{"$f":"IF(E6=\"\",\"\",IF(OR(E6<0,E6>5,G6<0,G6>(5*13),H6<0,H6>(5*13)),\"Number out of range error\",\"Valid Scores entered\"))","v":""},{"$f":"IF(E6=\"\",\"\",IF((E6*13>G6),\"Error in submitting Games Won or Points Home\",\"OK\"))","v":""},{"$f":"IF(E6=\"\",\"\",IF((F6*13>H6),\"Error in submitting Games Won or Points Away\",\"OK\"))","v":""}]
[{"$f":"Template!B22","v":"22.05.2017"},{"$f":"B6+1","v":3},"Away",{"$f":"Template!K22","v":"Hen and Chickens"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D7,\"'!$F7\"))","v":2},3,{"$f":"INDIRECT(CONCATENATE(\"'\",$D7,\"'!H7\"))","v":42},{"$f":"INDIRECT(CONCATENATE(\"'\",$D7,\"'!G7\"))","v":58},0,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B23","v":"05.06.2017"},4,"Away",{"$f":"Template!I23","v":"Old Bulls Head"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D8,\"'!$F8\"))","v":2},3,{"$f":"INDIRECT(CONCATENATE(\"'\",$D8,\"'!H8\"))","v":57},{"$f":"INDIRECT(CONCATENATE(\"'\",$D8,\"'!G8\"))","v":44},0,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B24","v":"12.06.2017"},5,"Home",{"$f":"Template!J24","v":"Farmers Boy"},3,2,46,47,1,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B25","v":"19.06.2017"},6,"Away",{"$f":"Template!I25","v":"George Bees"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D10,\"'!$F10\"))","v":1},4,{"$f":"INDIRECT(CONCATENATE(\"'\",$D10,\"'!H10\"))","v":40},{"$f":"INDIRECT(CONCATENATE(\"'\",$D10,\"'!G10\"))","v":59},0,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B26","v":"26.06.2017"},7,"Home",{"$f":"Template!J26","v":"Drifters"},3,2,59,47,1,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B27","v":"03.07.2017"},8,"Away",{"$f":"Template!I27","v":"Bye"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D12,\"'!$F12\"))","v":""},{"$f":"IF(E12=\"\",\"\",5-E12)","v":""},{"$f":"INDIRECT(CONCATENATE(\"'\",$D12,\"'!H12\"))","v":0},{"$f":"INDIRECT(CONCATENATE(\"'\",$D12,\"'!G12\"))","v":0},"","","",""]
[{"$f":"Template!B28","v":"10.07.2017"},9,"Home",{"$f":"Template!J28","v":"Bye2"},null,"",null,null,"","","",""]
[{"$f":"Template!B29","v":"17.07.2017"},10,"Home",{"$f":"Template!F29","v":"Brown Bear"},1,4,40,58,0,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B30","v":"24.07.2017"},11,"Away",{"$f":"Template!C30","v":"George A"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D15,\"'!$F15\"))","v":2},3,{"$f":"INDIRECT(CONCATENATE(\"'\",$D15,\"'!H15\"))","v":52},{"$f":"INDIRECT(CONCATENATE(\"'\",$D15,\"'!G15\"))","v":42},0,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B31","v":"31.07.2017"},12,"Home",{"$f":"Template!L31","v":"Hen and Chickens"},5,0,65,33,1,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B32","v":"07.08.2017"},13,"Home",{"$f":"Template!J32","v":"Old Bulls Head"},4,1,55,45,1,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B33","v":"14.08.2017"},14,"Away",{"$f":"Template!I33","v":"Farmers Boy"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D18,\"'!$F18\"))","v":0},5,{"$f":"INDIRECT(CONCATENATE(\"'\",$D18,\"'!H18\"))","v":39},{"$f":"INDIRECT(CONCATENATE(\"'\",$D18,\"'!G18\"))","v":65},0,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B34","v":"21.08.2017"},15,"Home",{"$f":"Template!J34","v":"George Bees"},3,2,51,49,1,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B35","v":"04.09.2017"},16,"Away",{"$f":"Template!I35","v":"Drifters"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D20,\"'!$F20\"))","v":1},4,{"$f":"INDIRECT(CONCATENATE(\"'\",$D20,\"'!H20\"))","v":43},{"$f":"INDIRECT(CONCATENATE(\"'\",$D20,\"'!G20\"))","v":55},0,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B36","v":"11.09.2017"},17,"Home",{"$f":"Template!J36","v":"Bye"},null,"",null,null,"","","",""]
[{"$f":"Template!B37","v":"18.09.2017"},18,"Away",{"$f":"Template!I37","v":"Bye2"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D22,\"'!$F22\"))","v":""},"",{"$f":"INDIRECT(CONCATENATE(\"'\",$D22,\"'!H22\"))","v":0},{"$f":"INDIRECT(CONCATENATE(\"'\",$D22,\"'!G22\"))","v":0},"","","",""]
[null,null,{"$f":"CONCATENATE(\"Home Games:\",COUNTIF(C5:C22,\"Home\"),\" Away Games:\",COUNTIF(C5:C22,\"Away\"))","v":"Home Games:9 Away Games:9"}]

{"sheet":"Hen and Chickens","index":10,"n_rows":23,"n_cols":12,"rows_kept":23,"cut":false,"hidden":false,"merged":[[2,10,2,11]]}
[]
["Team",{"$f":"Template!B11","v":"Hen and Chickens"}]
[null,null,null,null,null,null,null,null,null,null,"Check that there are enough points to win the games"]
["Date","Week","Home/Away","Opponent","Games Won","Games lost","Points For","Points Against","Match Won?","Check that input numbers are within range","Home","Away"]
[{"$f":"Template!B20","v":"08.05.2017"},1,"Away",{"$f":"Template!C20","v":"George A"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D5,\"'!$F5\"))","v":3},{"$f":"IF(E5=\"\",\"\",5-E5)","v":2},{"$f":"INDIRECT(CONCATENATE(\"'\",$D5,\"'!H5\"))","v":54},{"$f":"INDIRECT(CONCATENATE(\"'\",$D5,\"'!G5\"))","v":46},{"$f":"IF(E5=\"\",\"\",IF(E5>2,1,0))","v":1},{"$f":"IF(E5=\"\",\"\",IF(OR(E5<0,E5>5,G5<0,G5>(5*13),H5<0,H5>(5*13)),\"Number out of range error\",\"Valid Scores entered\"))","v":"Valid Scores entered"},{"$f":"IF(E5=\"\",\"\",IF((E5*13>G5),\"Error in submitting Games Won or Points Home\",\"OK\"))","v":"OK"},{"$f":"IF(E5=\"\",\"\",IF((F5*13>H5),\"Error in submitting Games Won or Points Away\",\"OK\"))","v":"OK"}]
[{"$f":"Template!B21","v":"15.05.2017"},{"$f":"B5+1","v":2},"Home",{"$f":"Template!L21","v":"Drifters"},2,3,40,50,{"$f":"IF(E6=\"\",\"\",IF(E6>2,1,0))","v":0},{"$f":"IF(E6=\"\",\"\",IF(OR(E6<0,E6>5,G6<0,G6>(5*13),H6<0,H6>(5*13)),\"Number out of range error\",\"Valid Scores entered\"))","v":"Valid Scores entered"},{"$f":"IF(E6=\"\",\"\",IF((E6*13>G6),\"Error in submitting Games Won or Points Home\",\"OK\"))","v":"OK"},{"$f":"IF(E6=\"\",\"\",IF((F6*13>H6),\"Error in submitting Games Won or Points Away\",\"OK\"))","v":"OK"}]
[{"$f":"Template!B22","v":"22.05.2017"},{"$f":"B6+1","v":3},"Home",{"$f":"Template!L22","v":"Plough OldUns"},3,2,58,42,1,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B23","v":"05.06.2017"},4,"Away",{"$f":"Template!K23","v":"Bye"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D8,\"'!$F8\"))","v":""},"",{"$f":"INDIRECT(CONCATENATE(\"'\",$D8,\"'!H8\"))","v":0},{"$f":"INDIRECT(CONCATENATE(\"'\",$D8,\"'!G8\"))","v":0},"","","",""]
[{"$f":"Template!B24","v":"12.06.2017"},5,"Home",{"$f":"Template!L24","v":"Old Bulls Head"},1,4,32,58,0,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B25","v":"19.06.2017"},6,"Away",{"$f":"Template!K25","v":"Bye2"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D10,\"'!$F10\"))","v":""},"",{"$f":"INDIRECT(CONCATENATE(\"'\",$D10,\"'!H10\"))","v":0},{"$f":"INDIRECT(CONCATENATE(\"'\",$D10,\"'!G10\"))","v":0},"","","",""]
[{"$f":"Template!B26","v":"26.06.2017"},7,"Home",{"$f":"Template!L26","v":"Farmers Boy"},3,2,59,53,1,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B27","v":"03.07.2017"},8,"Away",{"$f":"Template!K27","v":"Brown Bear"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D12,\"'!$F12\"))","v":1},4,{"$f":"INDIRECT(CONCATENATE(\"'\",$D12,\"'!H12\"))","v":45},{"$f":"INDIRECT(CONCATENATE(\"'\",$D12,\"'!G12\"))","v":59},0,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B28","v":"10.07.2017"},9,"Home",{"$f":"Template!L28","v":"George Bees"},4,1,52,41,1,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B29","v":"17.07.2017"},10,"Home",{"$f":"Template!D29","v":"George A"},3,2,56,48,1,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B30","v":"24.07.2017"},11,"Away",{"$f":"Template!K30","v":"Drifters"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D15,\"'!$F15\"))","v":2},3,{"$f":"INDIRECT(CONCATENATE(\"'\",$D15,\"'!H15\"))","v":44},{"$f":"INDIRECT(CONCATENATE(\"'\",$D15,\"'!G15\"))","v":57},0,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B31","v":"31.07.2017"},12,"Away",{"$f":"Template!K31","v":"Plough OldUns"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D16,\"'!$F16\"))","v":0},5,{"$f":"INDIRECT(CONCATENATE(\"'\",$D16,\"'!H16\"))","v":33},{"$f":"INDIRECT(CONCATENATE(\"'\",$D16,\"'!G16\"))","v":65},0,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B32","v":"07.08.2017"},13,"Home",{"$f":"Template!L32","v":"Bye"},null,"",null,null,"","","",""]
[{"$f":"Template!B33","v":"14.08.2017"},14,"Away",{"$f":"Template!K33","v":"Old Bulls Head"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D18,\"'!$F18\"))","v":2},3,{"$f":"INDIRECT(CONCATENATE(\"'\",$D18,\"'!H18\"))","v":42},{"$f":"INDIRECT(CONCATENATE(\"'\",$D18,\"'!G18\"))","v":58},0,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B34","v":"21.08.2017"},15,"Home",{"$f":"Template!L34","v":"Bye2"},null,"",null,null,"","","",""]
[{"$f":"Template!B35","v":"04.09.2017"},16,"Away",{"$f":"Template!K35","v":"Farmers Boy"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D20,\"'!$F20\"))","v":1},4,{"$f":"INDIRECT(CONCATENATE(\"'\",$D20,\"'!H20\"))","v":38},{"$f":"INDIRECT(CONCATENATE(\"'\",$D20,\"'!G20\"))","v":64},0,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B36","v":"11.09.2017"},17,"Home",{"$f":"Template!L36","v":"Brown Bear"},4,1,60,50,1,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B37","v":"18.09.2017"},18,"Away",{"$f":"Template!K37","v":"George Bees"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D22,\"'!$F22\"))","v":1},4,{"$f":"INDIRECT(CONCATENATE(\"'\",$D22,\"'!H22\"))","v":22},{"$f":"INDIRECT(CONCATENATE(\"'\",$D22,\"'!G22\"))","v":63},0,"Valid Scores entered","OK","OK"]
[null,null,{"$f":"CONCATENATE(\"Home Games:\",COUNTIF(C5:C22,\"Home\"),\" Away Games:\",COUNTIF(C5:C22,\"Away\"))","v":"Home Games:9 Away Games:9"}]

{"sheet":"Template","index":11,"n_rows":40,"n_cols":12,"rows_kept":40,"cut":false,"hidden":false,"merged":[[17,10,17,11],[3,5,5,7],[17,2,17,3],[17,4,17,5],[17,6,17,7],[17,8,17,9]]}
["Team Number","Team Name","Buddy Team"]
[1,"George A",{"$f":"B7","v":"George Bees"}]
[2,"Brown Bear",{"$f":"B8","v":"Farmers Boy"}]
[3,"Bye2",{"$f":"B9","v":"Old Bulls Head"},null,null,"The yellow box names are the controls for the spreadsheet.  The tab names should match the team names specified here exactly"]
[4,"Bye",{"$f":"B10","v":"Plough OldUns"}]
[5,"Drifters",{"$f":"B11","v":"Hen and Chickens"}]
[6,"George Bees",{"$f":"B2","v":"George A"}]
[7,"Farmers Boy",{"$f":"B3","v":"Brown Bear"}]
[8,"Old Bulls Head",{"$f":"B4","v":"Bye2"}]
[9,"Plough OldUns",{"$f":"B5","v":"Bye"}]
[10,"Hen and Chickens",{"$f":"B6","v":"Drifters"}]
[]
[]
[]
[]
[]
[]
[null,null,"Match 1",null,"Match 2",null,"Match 3",null,"Match 4",null,"Match 5"]
["Week","Date","Home","Away","Home","Away","Home","Away","Home","Away","Home","Away"]
[1,"08.05.2017",{"$f":"B2","v":"George A"},{"$f":"B11","v":"Hen and Chickens"},{"$f":"B3","v":"Brown Bear"},{"$f":"B10","v":"Plough OldUns"},{"$f":"B4","v":"Bye2"},{"$f":"B9","v":"Old Bulls Head"},{"$f":"B5","v":"Bye"},{"$f":"B8","v":"Farmers Boy"},{"$f":"B6","v":"Drifters"},{"$f":"B7","v":"George Bees"}]
[2,"15.05.2017",{"$f":"B10","v":"Plough OldUns"},{"$f":"B2","v":"George A"},{"$f":"B9","v":"Old Bulls Head"},{"$f":"B3","v":"Brown Bear"},{"$f":"B8","v":"Farmers Boy"},{"$f":"B4","v":"Bye2"},{"$f":"B7","v":"George Bees"},{"$f":"B5","v":"Bye"},{"$f":"B11","v":"Hen and Chickens"},{"$f":"B6","v":"Drifters"}]
[3,"22.05.2017",{"$f":"B2","v":"George A"},{"$f":"B9","v":"Old Bulls Head"},{"$f":"B3","v":"Brown Bear"},{"$f":"B8","v":"Farmers Boy"},{"$f":"B4","v":"Bye2"},{"$f":"B7","v":"George Bees"},{"$f":"B5","v":"Bye"},{"$f":"B6","v":"Drifters"},{"$f":"B11","v":"Hen and Chickens"},{"$f":"B10","v":"Plough OldUns"}]
[4,"05.06.2017",{"$f":"B8","v":"Farmers Boy"},{"$f":"B2","v":"George A"},{"$f":"B7","v":"George Bees"},{"$f":"B3","v":"Brown Bear"},{"$f":"B6","v":"Drifters"},{"$f":"B4","v":"Bye2"},{"$f":"B9","v":"Old Bulls Head"},{"$f":"B10","v":"Plough OldUns"},{"$f":"B5","v":"Bye"},{"$f":"B11","v":"Hen and Chickens"}]
[5,"12.06.2017",{"$f":"B2","v":"George A"},{"$f":"B7","v":"George Bees"},{"$f":"B3","v":"Brown Bear"},{"$f":"B6","v":"Drifters"},{"$f":"B4","v":"Bye2"},{"$f":"B5","v":"Bye"},{"$f":"B10","v":"Plough OldUns"},{"$f":"B8","v":"Farmers Boy"},{"$f":"B11","v":"Hen and Chickens"},{"$f":"B9","v":"Old Bulls Head"}]
[6,"19.06.2017",{"$f":"B6","v":"Drifters"},{"$f":"B2","v":"George A"},{"$f":"B5","v":"Bye"},{"$f":"B3","v":"Brown Bear"},{"$f":"B8","v":"Farmers Boy"},{"$f":"B9","v":"Old Bulls Head"},{"$f":"B7","v":"George Bees"},{"$f":"B10","v":"Plough OldUns"},{"$f":"B4","v":"Bye2"},{"$f":"B11","v":"Hen and Chickens"}]
[7,"26.06.2017",{"$f":"B2","v":"George A"},{"$f":"B5","v":"Bye"},{"$f":"B3","v":"Brown Bear"},{"$f":"B4","v":"Bye2"},{"$f":"B9","v":"Old Bulls Head"},{"$f":"B7","v":"George Bees"},{"$f":"B10","v":"Plough OldUns"},{"$f":"B6","v":"Drifters"},{"$f":"B11","v":"Hen and Chickens"},{"$f":"B8","v":"Farmers Boy"}]
[8,"03.07.2017",{"$f":"B4","v":"Bye2"},{"$f":"B2","v":"George A"},{"$f":"B7","v":"George Bees"},{"$f":"B8","v":"Farmers Boy"},{"$f":"B6","v":"Drifters"},{"$f":"B9","v":"Old Bulls Head"},{"$f":"B5","v":"Bye"},{"$f":"B10","v":"Plough OldUns"},{"$f":"B3","v":"Brown Bear"},{"$f":"B11","v":"Hen and Chickens"}]
[9,"10.07.2017",{"$f":"B2","v":"George A"},{"$f":"B3","v":"Brown Bear"},{"$f":"B8","v":"Farmers Boy"},{"$f":"B6","v":"Drifters"},{"$f":"B9","v":"Old Bulls Head"},{"$f":"B5","v":"Bye"},{"$f":"B10","v":"Plough OldUns"},{"$f":"B4","v":"Bye2"},{"$f":"B11","v":"Hen and Chickens"},{"$f":"B7","v":"George Bees"}]
[10,"17.07.2017",{"$f":"B11","v":"Hen and Chickens"},{"$f":"B2","v":"George A"},{"$f":"B10","v":"Plough OldUns"},{"$f":"B3","v":"Brown Bear"},{"$f":"B9","v":"Old Bulls Head"},{"$f":"B4","v":"Bye2"},{"$f":"B8","v":"Farmers Boy"},{"$f":"B5","v":"Bye"},{"$f":"B7","v":"George Bees"},{"$f":"B6","v":"Drifters"}]
[11,"24.07.2017",{"$f":"B2","v":"George A"},{"$f":"B10","v":"Plough OldUns"},{"$f":"B3","v":"Brown Bear"},{"$f":"B9","v":"Old Bulls Head"},{"$f":"B4","v":"Bye2"},{"$f":"B8","v":"Farmers Boy"},{"$f":"B5","v":"Bye"},{"$f":"B7","v":"George Bees"},{"$f":"B6","v":"Drifters"},{"$f":"B11","v":"Hen and Chickens"}]
[12,"31.07.2017",{"$f":"B9","v":"Old Bulls Head"},{"$f":"B2","v":"George A"},{"$f":"B8","v":"Farmers Boy"},{"$f":"B3","v":"Brown Bear"},{"$f":"B7","v":"George Bees"},{"$f":"B4","v":"Bye2"},{"$f":"B6","v":"Drifters"},{"$f":"B5","v":"Bye"},{"$f":"B10","v":"Plough OldUns"},{"$f":"B11","v":"Hen and Chickens"}]
[13,"07.08.2017",{"$f":"B2","v":"George A"},{"$f":"B8","v":"Farmers Boy"},{"$f":"B3","v":"Brown Bear"},{"$f":"B7","v":"George Bees"},{"$f":"B4","v":"Bye2"},{"$f":"B6","v":"Drifters"},{"$f":"B10","v":"Plough OldUns"},{"$f":"B9","v":"Old Bulls Head"},{"$f":"B11","v":"Hen and Chickens"},{"$f":"B5","v":"Bye"}]
[14,"14.08.2017",{"$f":"B7","v":"George Bees"},{"$f":"B2","v":"George A"},{"$f":"B6","v":"Drifters"},{"$f":"B3","v":"Brown Bear"},{"$f":"B5","v":"Bye"},{"$f":"B4","v":"Bye2"},{"$f":"B8","v":"Farmers Boy"},{"$f":"B10","v":"Plough OldUns"},{"$f":"B9","v":"Old Bulls Head"},{"$f":"B11","v":"Hen and Chickens"}]
[15,"21.08.2017",{"$f":"B2","v":"George A"},{"$f":"B6","v":"Drifters"},{"$f":"B3","v":"Brown Bear"},{"$f":"B5","v":"Bye"},{"$f":"B9","v":"Old Bulls Head"},{"$f":"B8","v":"Farmers Boy"},{"$f":"B10","v":"Plough OldUns"},{"$f":"B7","v":"George Bees"},{"$f":"B11","v":"Hen and Chickens"},{"$f":"B4","v":"Bye2"}]
[16,"04.09.2017",{"$f":"B5","v":"Bye"},{"$f":"B2","v":"George A"},{"$f":"B4","v":"Bye2"},{"$f":"B3","v":"Brown Bear"},{"$f":"B7","v":"George Bees"},{"$f":"B9","v":"Old Bulls Head"},{"$f":"B6","v":"Drifters"},{"$f":"B10","v":"Plough OldUns"},{"$f":"B8","v":"Farmers Boy"},{"$f":"B11","v":"Hen and Chickens"}]
[17,"11.09.2017",{"$f":"B2","v":"George A"},{"$f":"B4","v":"Bye2"},{"$f":"B8","v":"Farmers Boy"},{"$f":"B7","v":"George Bees"},{"$f":"B9","v":"Old Bulls Head"},{"$f":"B6","v":"Drifters"},{"$f":"B10","v":"Plough OldUns"},{"$f":"C10","v":"Bye"},{"$f":"B11","v":"Hen and Chickens"},{"$f":"B3","v":"Brown Bear"}]
[18,"18.09.2017",{"$f":"B3","v":"Brown Bear"},{"$f":"B2","v":"George A"},{"$f":"B6","v":"Drifters"},{"$f":"B8","v":"Farmers Boy"},{"$f":"B5","v":"Bye"},{"$f":"B9","v":"Old Bulls Head"},{"$f":"B4","v":"Bye2"},{"$f":"B10","v":"Plough OldUns"},{"$f":"B7","v":"George Bees"},{"$f":"B11","v":"Hen and Chickens"}]
["CATCHUP","25.09.2017"]
["CATCHUP","02.10.2017"]
["ALL GAMES PLAYED BY","09.10.2017"]