{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Table","George A","Plough","Hen and Chickens","Bye","Old Bulls Head","Farmers Boy","Whitehills","Brown Bear","Template"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":8,"comments":0,"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":11,"n_cols":8,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Matches Played","Matches Won","Games Won","Games Lost","Points Won","Points Lost","Points Diff"]
[{"$f":"Template!B4","v":"Hen and Chickens"},{"$f":"COUNT(INDIRECT(CONCATENATE(\"'\",A4,\"'!E:E\")))","v":18},{"$f":"SUM(INDIRECT(CONCATENATE(\"'\",A4,\"'!I:I\")))","v":12},{"$f":"SUM(INDIRECT(CONCATENATE(\"'\",A4,\"'!E:E\")))","v":50},{"$f":"SUM(INDIRECT(CONCATENATE(\"'\",A4,\"'!F:F\")))","v":40},{"$f":"SUM(INDIRECT(CONCATENATE(\"'\",A4,\"'!G:G\")))","v":927},{"$f":"SUM(INDIRECT(CONCATENATE(\"'\",A4,\"'!H:H\")))","v":847},{"$f":"F4-G4","v":80}]
[{"$f":"Template!B6","v":"Old Bulls Head"},{"$f":"COUNT(INDIRECT(CONCATENATE(\"'\",A5,\"'!E:E\")))","v":18},{"$f":"SUM(INDIRECT(CONCATENATE(\"'\",A5,\"'!I:I\")))","v":11},{"$f":"SUM(INDIRECT(CONCATENATE(\"'\",A5,\"'!E:E\")))","v":53},{"$f":"SUM(INDIRECT(CONCATENATE(\"'\",A5,\"'!F:F\")))","v":37},{"$f":"SUM(INDIRECT(CONCATENATE(\"'\",A5,\"'!G:G\")))","v":935},{"$f":"SUM(INDIRECT(CONCATENATE(\"'\",A5,\"'!H:H\")))","v":845},{"$f":"F5-G5","v":90}]
[{"$f":"Template!B9","v":"Brown Bear"},{"$f":"COUNT(INDIRECT(CONCATENATE(\"'\",A6,\"'!E:E\")))","v":18},{"$f":"SUM(INDIRECT(CONCATENATE(\"'\",A6,\"'!I:I\")))","v":11},{"$f":"SUM(INDIRECT(CONCATENATE(\"'\",A6,\"'!E:E\")))","v":52},{"$f":"SUM(INDIRECT(CONCATENATE(\"'\",A6,\"'!F:F\")))","v":38},{"$f":"SUM(INDIRECT(CONCATENATE(\"'\",A6,\"'!G:G\")))","v":961},{"$f":"SUM(INDIRECT(CONCATENATE(\"'\",A6,\"'!H:H\")))","v":797},{"$f":"F6-G6","v":164}]
[{"$f":"Template!B8","v":"Whitehills"},{"$f":"COUNT(INDIRECT(CONCATENATE(\"'\",A7,\"'!E:E\")))","v":18},{"$f":"SUM(INDIRECT(CONCATENATE(\"'\",A7,\"'!I:I\")))","v":11},{"$f":"SUM(INDIRECT(CONCATENATE(\"'\",A7,\"'!E:E\")))","v":51},{"$f":"SUM(INDIRECT(CONCATENATE(\"'\",A7,\"'!F:F\")))","v":39},{"$f":"SUM(INDIRECT(CONCATENATE(\"'\",A7,\"'!G:G\")))","v":960},{"$f":"SUM(INDIRECT(CONCATENATE(\"'\",A7,\"'!H:H\")))","v":849},{"$f":"F7-G7","v":111}]
[{"$f":"Template!B7","v":"Farmers Boy"},{"$f":"COUNT(INDIRECT(CONCATENATE(\"'\",A8,\"'!E:E\")))","v":18},{"$f":"SUM(INDIRECT(CONCATENATE(\"'\",A8,\"'!I:I\")))","v":9},{"$f":"SUM(INDIRECT(CONCATENATE(\"'\",A8,\"'!E:E\")))","v":49},{"$f":"SUM(INDIRECT(CONCATENATE(\"'\",A8,\"'!F:F\")))","v":41},{"$f":"SUM(INDIRECT(CONCATENATE(\"'\",A8,\"'!G:G\")))","v":924},{"$f":"SUM(INDIRECT(CONCATENATE(\"'\",A8,\"'!H:H\")))","v":860},{"$f":"F8-G8","v":64}]
[{"$f":"Template!B3","v":"Plough"},{"$f":"COUNT(INDIRECT(CONCATENATE(\"'\",A9,\"'!E:E\")))","v":18},{"$f":"SUM(INDIRECT(CONCATENATE(\"'\",A9,\"'!I:I\")))","v":5},{"$f":"SUM(INDIRECT(CONCATENATE(\"'\",A9,\"'!E:E\")))","v":34},{"$f":"SUM(INDIRECT(CONCATENATE(\"'\",A9,\"'!F:F\")))","v":56},{"$f":"SUM(INDIRECT(CONCATENATE(\"'\",A9,\"'!G:G\")))","v":826},{"$f":"SUM(INDIRECT(CONCATENATE(\"'\",A9,\"'!H:H\")))","v":997},{"$f":"F9-G9","v":-171}]
[{"$f":"Template!B2","v":"George A"},{"$f":"COUNT(INDIRECT(CONCATENATE(\"'\",A10,\"'!E:E\")))","v":18},{"$f":"SUM(INDIRECT(CONCATENATE(\"'\",A10,\"'!I:I\")))","v":4},{"$f":"SUM(INDIRECT(CONCATENATE(\"'\",A10,\"'!E:E\")))","v":26},{"$f":"SUM(INDIRECT(CONCATENATE(\"'\",A10,\"'!F:F\")))","v":64},{"$f":"SUM(INDIRECT(CONCATENATE(\"'\",A10,\"'!G:G\")))","v":726},{"$f":"SUM(INDIRECT(CONCATENATE(\"'\",A10,\"'!H:H\")))","v":1049},{"$f":"F10-G10","v":-323}]
[{"$f":"Template!B5","v":"Bye"},{"$f":"COUNT(INDIRECT(CONCATENATE(\"'\",A11,\"'!E:E\")))","v":0},{"$f":"SUM(INDIRECT(CONCATENATE(\"'\",A11,\"'!I:I\")))","v":0},{"$f":"SUM(INDIRECT(CONCATENATE(\"'\",A11,\"'!E:E\")))","v":0},{"$f":"SUM(INDIRECT(CONCATENATE(\"'\",A11,\"'!F:F\")))","v":0},{"$f":"SUM(INDIRECT(CONCATENATE(\"'\",A11,\"'!G:G\")))","v":0},{"$f":"SUM(INDIRECT(CONCATENATE(\"'\",A11,\"'!H:H\")))","v":0},{"$f":"F11-G11","v":0}]

{"sheet":"George A","index":1,"n_rows":25,"n_cols":12,"rows_kept":25,"cut":false,"hidden":false,"merged":[[2,10,2,11]]}
[]
["Team",{"$f":"Template!B2","v":"George A"},null,{"$f":"CONCATENATE(\"Home Games:\",COUNTIF(C5:C999,\"Home\"),\" Away Games:\",COUNTIF(C5:C999,\"Away\"))","v":"Home Games:11 Away Games:10"}]
[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":"30.04.2018"},1,"Home",{"$f":"Template!D20","v":"Brown Bear"},3,{"$f":"IF(E5=\"\",\"\",5-E5)","v":2},44,57,{"$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":"14.05.2018"},{"$f":"B5+1","v":2},"Away",{"$f":"Template!C21","v":"Whitehills"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D6,\"'!$F6\"))","v":1},4,{"$f":"INDIRECT(CONCATENATE(\"'\",$D6,\"'!H6\"))","v":40},{"$f":"INDIRECT(CONCATENATE(\"'\",$D6,\"'!G6\"))","v":64},{"$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":"21.05.2018"},{"$f":"B6+1","v":3},"Home",{"$f":"Template!D22","v":"Farmers Boy"},2,3,48,51,{"$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":"04.06.2018"},4,"Away",{"$f":"Template!C23","v":"Old Bulls Head"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D8,\"'!$F8\"))","v":0},5,{"$f":"INDIRECT(CONCATENATE(\"'\",$D8,\"'!H8\"))","v":35},{"$f":"INDIRECT(CONCATENATE(\"'\",$D8,\"'!G8\"))","v":65},0,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B24","v":"11.06.2018"},5,"Home",{"$f":"Template!D24","v":"Bye"},null,"",null,null,"","","",""]
[{"$f":"Template!B25","v":"18.06.2018"},6,"Away",{"$f":"Template!C25","v":"Hen and Chickens"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D10,\"'!$F10\"))","v":1},4,{"$f":"INDIRECT(CONCATENATE(\"'\",$D10,\"'!H10\"))","v":46},{"$f":"INDIRECT(CONCATENATE(\"'\",$D10,\"'!G10\"))","v":56},0,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B26","v":"25.06.2018"},7,"Home",{"$f":"Template!D26","v":"Plough"},2,3,44,56,0,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B27","v":"02.07.2018"},8,"Away",{"$f":"Template!C27","v":"Brown Bear"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D12,\"'!$F12\"))","v":0},5,{"$f":"INDIRECT(CONCATENATE(\"'\",$D12,\"'!H12\"))","v":28},{"$f":"INDIRECT(CONCATENATE(\"'\",$D12,\"'!G12\"))","v":65},0,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B28","v":"09.07.2018"},9,"Home",{"$f":"Template!D28","v":"Whitehills"},3,2,55,40,1,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B29","v":"16.07.2018"},10,"Away",{"$f":"Template!C29","v":"Farmers Boy"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D14,\"'!$F14\"))","v":1},4,{"$f":"INDIRECT(CONCATENATE(\"'\",$D14,\"'!H14\"))","v":51},{"$f":"INDIRECT(CONCATENATE(\"'\",$D14,\"'!G14\"))","v":64},0,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B30","v":"23.07.2018"},11,"Home",{"$f":"Template!D30","v":"Old Bulls Head"},3,2,49,55,1,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B31","v":"30.07.2018"},12,"Away",{"$f":"Template!C31","v":"Bye"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D16,\"'!$F16\"))","v":""},"",{"$f":"INDIRECT(CONCATENATE(\"'\",$D16,\"'!H16\"))","v":0},{"$f":"INDIRECT(CONCATENATE(\"'\",$D16,\"'!G16\"))","v":0},"","","",""]
[{"$f":"Template!B32","v":"06.08.2018"},13,"Home",{"$f":"Template!D32","v":"Hen and Chickens"},1,4,29,62,0,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B33","v":"13.08.2018"},14,"Away",{"$f":"Template!C33","v":"Plough"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D18,\"'!$F18\"))","v":1},4,{"$f":"INDIRECT(CONCATENATE(\"'\",$D18,\"'!H18\"))","v":43},{"$f":"INDIRECT(CONCATENATE(\"'\",$D18,\"'!G18\"))","v":63},0,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B34","v":"20.08.2018"},15,"Home",{"$f":"Template!D34","v":"Brown Bear"},2,3,35,53,0,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B35","v":"03.09.2018"},16,"Away",{"$f":"Template!C35","v":"Whitehills"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D20,\"'!$F20\"))","v":1},4,{"$f":"INDIRECT(CONCATENATE(\"'\",$D20,\"'!H20\"))","v":23},{"$f":"INDIRECT(CONCATENATE(\"'\",$D20,\"'!G20\"))","v":59},0,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B36","v":"10.09.2018"},17,"Home",{"$f":"Template!D36","v":"Farmers Boy"},3,2,57,53,1,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B37","v":"17.09.2018"},18,"Away",{"$f":"Template!C37","v":"Old Bulls Head"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D22,\"'!$F22\"))","v":0},5,{"$f":"INDIRECT(CONCATENATE(\"'\",$D22,\"'!H22\"))","v":25},{"$f":"INDIRECT(CONCATENATE(\"'\",$D22,\"'!G22\"))","v":65},0,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B38","v":"24.09.2018"},19,"Home",{"$f":"Template!D38","v":"Bye"},null,"",null,null,"","","",""]
[{"$f":"Template!B39","v":"01.10.2018"},20,"Away",{"$f":"Template!C39","v":"Hen and Chickens"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D24,\"'!$F24\"))","v":1},4,{"$f":"INDIRECT(CONCATENATE(\"'\",$D24,\"'!H24\"))","v":29},{"$f":"INDIRECT(CONCATENATE(\"'\",$D24,\"'!G24\"))","v":62},0,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B40","v":"08.10.2018"},21,"Home",{"$f":"Template!D40","v":"Plough"},1,4,45,59,0,"Valid Scores entered","OK","OK"]

{"sheet":"Plough","index":2,"n_rows":25,"n_cols":12,"rows_kept":25,"cut":false,"hidden":false,"merged":[[2,10,2,11]]}
[]
["Team",{"$f":"Template!B3","v":"Plough"},null,{"$f":"CONCATENATE(\"Home Games:\",COUNTIF(C5:C999,\"Home\"),\" Away Games:\",COUNTIF(C5:C999,\"Away\"))","v":"Home Games:11 Away Games:10"}]
[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":"30.04.2018"},1,"Home",{"$f":"Template!F20","v":"Whitehills"},2,{"$f":"IF(E5=\"\",\"\",5-E5)","v":3},50,56,{"$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":"14.05.2018"},{"$f":"B5+1","v":2},"Away",{"$f":"Template!E21","v":"Farmers Boy"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D6,\"'!$F6\"))","v":0},5,{"$f":"INDIRECT(CONCATENATE(\"'\",$D6,\"'!H6\"))","v":31},{"$f":"INDIRECT(CONCATENATE(\"'\",$D6,\"'!G6\"))","v":65},{"$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":"21.05.2018"},{"$f":"B6+1","v":3},"Home",{"$f":"Template!F22","v":"Old Bulls Head"},1,4,44,58,0,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B23","v":"04.06.2018"},4,"Away",{"$f":"Template!E23","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":"11.06.2018"},5,"Home",{"$f":"Template!F24","v":"Hen and Chickens"},2,3,46,52,0,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B25","v":"18.06.2018"},6,"Home",{"$f":"Template!J25","v":"Brown Bear"},3,2,54,55,1,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B26","v":"25.06.2018"},7,"Away",{"$f":"Template!C26","v":"George A"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D11,\"'!$F11\"))","v":3},2,{"$f":"INDIRECT(CONCATENATE(\"'\",$D11,\"'!H11\"))","v":56},{"$f":"INDIRECT(CONCATENATE(\"'\",$D11,\"'!G11\"))","v":44},1,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B27","v":"02.07.2018"},8,"Away",{"$f":"Template!E27","v":"Whitehills"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D12,\"'!$F12\"))","v":1},4,{"$f":"INDIRECT(CONCATENATE(\"'\",$D12,\"'!H11\"))","v":51},{"$f":"INDIRECT(CONCATENATE(\"'\",$D12,\"'!G11\"))","v":59},0,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B28","v":"09.07.2018"},9,"Home",{"$f":"Template!F28","v":"Farmers Boy"},1,4,48,61,0,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B29","v":"16.07.2018"},10,"Away",{"$f":"Template!E29","v":"Old Bulls Head"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D14,\"'!$F14\"))","v":0},5,{"$f":"INDIRECT(CONCATENATE(\"'\",$D14,\"'!H14\"))","v":26},{"$f":"INDIRECT(CONCATENATE(\"'\",$D14,\"'!G14\"))","v":65},0,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B30","v":"23.07.2018"},11,"Home",{"$f":"Template!F30","v":"Bye"},null,"",null,null,"","","",""]
[{"$f":"Template!B31","v":"30.07.2018"},12,"Away",{"$f":"Template!E31","v":"Hen and Chickens"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D16,\"'!$F16\"))","v":2},3,{"$f":"INDIRECT(CONCATENATE(\"'\",$D16,\"'!H16\"))","v":50},{"$f":"INDIRECT(CONCATENATE(\"'\",$D16,\"'!G16\"))","v":61},0,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B32","v":"06.08.2018"},13,"Away",{"$f":"Template!I32","v":"Brown Bear"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D17,\"'!$F17\"))","v":3},2,{"$f":"INDIRECT(CONCATENATE(\"'\",$D17,\"'!H17\"))","v":55},{"$f":"INDIRECT(CONCATENATE(\"'\",$D17,\"'!G17\"))","v":48},1,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B33","v":"13.08.2018"},14,"Home",{"$f":"Template!D33","v":"George A"},4,1,63,43,1,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B34","v":"20.08.2018"},15,"Home",{"$f":"Template!F34","v":"Whitehills"},2,3,44,59,0,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B35","v":"03.09.2018"},16,"Away",{"$f":"Template!E35","v":"Farmers Boy"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D20,\"'!$F20\"))","v":1},4,{"$f":"INDIRECT(CONCATENATE(\"'\",$D20,\"'!H20\"))","v":18},{"$f":"INDIRECT(CONCATENATE(\"'\",$D20,\"'!G20\"))","v":58},0,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B36","v":"10.09.2018"},17,"Home",{"$f":"Template!F36","v":"Old Bulls Head"},2,3,40,48,0,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B37","v":"17.09.2018"},18,"Away",{"$f":"Template!E37","v":"Bye"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D22,\"'!$F22\"))","v":""},"",{"$f":"INDIRECT(CONCATENATE(\"'\",$D22,\"'!H22\"))","v":0},{"$f":"INDIRECT(CONCATENATE(\"'\",$D22,\"'!G22\"))","v":0},"","","",""]
[{"$f":"Template!B38","v":"24.09.2018"},19,"Home",{"$f":"Template!F38","v":"Hen and Chickens"},2,3,49,58,{"$f":"IF(E23=\"\",\"\",IF(E23>2,1,0))","v":0},{"$f":"IF(E23=\"\",\"\",IF(OR(E23<0,E23>5,G23<0,G23>(5*13),H23<0,H23>(5*13)),\"Number out of range error\",\"Valid Scores entered\"))","v":"Valid Scores entered"},{"$f":"IF(E23=\"\",\"\",IF((E23*13>G23),\"Error in submitting Games Won or Points Home\",\"OK\"))","v":"OK"},{"$f":"IF(E23=\"\",\"\",IF((F23*13>H23),\"Error in submitting Games Won or Points Away\",\"OK\"))","v":"OK"}]
[{"$f":"Template!B39","v":"01.10.2018"},20,"Home",{"$f":"Template!J39","v":"Brown Bear"},1,4,42,62,0,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B40","v":"08.10.2018"},21,"Away",{"$f":"Template!C40","v":"George A"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D25,\"'!$F25\"))","v":4},1,{"$f":"INDIRECT(CONCATENATE(\"'\",$D25,\"'!H25\"))","v":59},{"$f":"INDIRECT(CONCATENATE(\"'\",$D25,\"'!G25\"))","v":45},1,"Valid Scores entered","OK","OK"]

{"sheet":"Hen and Chickens","index":3,"n_rows":25,"n_cols":12,"rows_kept":25,"cut":false,"hidden":false,"merged":[[2,10,2,11]]}
[]
["Team",{"$f":"Template!B4","v":"Hen and Chickens"},null,{"$f":"CONCATENATE(\"Home Games:\",COUNTIF(C5:C999,\"Home\"),\" Away Games:\",COUNTIF(C5:C999,\"Away\"))","v":"Home Games:11 Away Games:10"}]
[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":"30.04.2018"},1,"Home",{"$f":"Template!H20","v":"Farmers Boy"},4,{"$f":"IF(E5=\"\",\"\",5-E5)","v":1},56,29,{"$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":"14.05.2018"},{"$f":"B5+1","v":2},"Away",{"$f":"Template!G21","v":"Old Bulls Head"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D6,\"'!$F6\"))","v":1},4,{"$f":"INDIRECT(CONCATENATE(\"'\",$D6,\"'!H6\"))","v":36},{"$f":"INDIRECT(CONCATENATE(\"'\",$D6,\"'!G6\"))","v":63},{"$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":"21.05.2018"},{"$f":"B6+1","v":3},"Home",{"$f":"Template!H22","v":"Bye"},null,"",null,null,"","","",""]
[{"$f":"Template!B23","v":"04.06.2018"},4,"Home",{"$f":"Template!J23","v":"Brown Bear"},2,3,36,49,0,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B24","v":"11.06.2018"},5,"Away",{"$f":"Template!E24","v":"Plough"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D9,\"'!$F9\"))","v":3},2,{"$f":"INDIRECT(CONCATENATE(\"'\",$D9,\"'!H9\"))","v":52},{"$f":"INDIRECT(CONCATENATE(\"'\",$D9,\"'!G9\"))","v":46},1,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B25","v":"18.06.2018"},6,"Home",{"$f":"Template!D25","v":"George A"},4,1,56,46,1,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B26","v":"25.06.2018"},7,"Away",{"$f":"Template!G26","v":"Whitehills"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D11,\"'!$F11\"))","v":3},{"$f":"IF(E11=\"\",\"\",5-E11)","v":2},{"$f":"INDIRECT(CONCATENATE(\"'\",$D11,\"'!H11\"))","v":51},{"$f":"INDIRECT(CONCATENATE(\"'\",$D11,\"'!G11\"))","v":59},{"$f":"IF(E11=\"\",\"\",IF(E11>2,1,0))","v":1},{"$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":"Valid Scores entered"},{"$f":"IF(E11=\"\",\"\",IF((E11*13>G11),\"Error in submitting Games Won or Points Home\",\"OK\"))","v":"OK"},{"$f":"IF(E11=\"\",\"\",IF((F11*13>H11),\"Error in submitting Games Won or Points Away\",\"OK\"))","v":"OK"}]
[{"$f":"Template!B27","v":"02.07.2018"},8,"Away",{"$f":"Template!G27","v":"Farmers Boy"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D12,\"'!$F12\"))","v":1},4,{"$f":"INDIRECT(CONCATENATE(\"'\",$D12,\"'!H12\"))","v":37},{"$f":"INDIRECT(CONCATENATE(\"'\",$D12,\"'!G12\"))","v":64},0,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B28","v":"09.07.2018"},9,"Home",{"$f":"Template!H28","v":"Old Bulls Head"},2,3,54,54,0,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B29","v":"16.07.2018"},10,"Away",{"$f":"Template!G29","v":"Bye"},{"$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":"23.07.2018"},11,"Away",{"$f":"Template!I30","v":"Brown Bear"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D15,\"'!$F15\"))","v":2},3,{"$f":"INDIRECT(CONCATENATE(\"'\",$D15,\"'!H15\"))","v":42},{"$f":"INDIRECT(CONCATENATE(\"'\",$D15,\"'!G15\"))","v":49},0,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B31","v":"30.07.2018"},12,"Home",{"$f":"Template!F31","v":"Plough"},3,2,61,50,1,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B32","v":"06.08.2018"},13,"Away",{"$f":"Template!C32","v":"George A"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D17,\"'!$F17\"))","v":4},1,{"$f":"INDIRECT(CONCATENATE(\"'\",$D17,\"'!H17\"))","v":62},{"$f":"INDIRECT(CONCATENATE(\"'\",$D17,\"'!G17\"))","v":29},1,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B33","v":"13.08.2018"},14,"Home",{"$f":"Template!H33","v":"Whitehills"},1,4,47,61,0,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B34","v":"20.08.2018"},15,"Home",{"$f":"Template!H34","v":"Farmers Boy"},3,2,56,43,1,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B35","v":"03.09.2018"},16,"Away",{"$f":"Template!G35","v":"Old Bulls Head"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D20,\"'!$F20\"))","v":3},2,{"$f":"INDIRECT(CONCATENATE(\"'\",$D20,\"'!H20\"))","v":52},{"$f":"INDIRECT(CONCATENATE(\"'\",$D20,\"'!G20\"))","v":33},1,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B36","v":"10.09.2018"},17,"Home",{"$f":"Template!H36","v":"Bye"},null,"",null,null,"","","",""]
[{"$f":"Template!B37","v":"17.09.2018"},18,"Home",{"$f":"Template!J37","v":"Brown Bear"},3,2,54,47,1,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B38","v":"24.09.2018"},19,"Away",{"$f":"Template!E38","v":"Plough"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D23,\"'!$F23\"))","v":3},2,{"$f":"INDIRECT(CONCATENATE(\"'\",$D23,\"'!H23\"))","v":58},{"$f":"INDIRECT(CONCATENATE(\"'\",$D23,\"'!G23\"))","v":49},{"$f":"IF(E23=\"\",\"\",IF(E23>2,1,0))","v":1},{"$f":"IF(E23=\"\",\"\",IF(OR(E23<0,E23>5,G23<0,G23>(5*13),H23<0,H23>(5*13)),\"Number out of range error\",\"Valid Scores entered\"))","v":"Valid Scores entered"},{"$f":"IF(E23=\"\",\"\",IF((E23*13>G23),\"Error in submitting Games Won or Points Home\",\"OK\"))","v":"OK"},{"$f":"IF(E23=\"\",\"\",IF((F23*13>H23),\"Error in submitting Games Won or Points Away\",\"OK\"))","v":"OK"}]
[{"$f":"Template!B39","v":"01.10.2018"},20,"Home",{"$f":"Template!D39","v":"George A"},4,1,62,29,1,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B40","v":"08.10.2018"},21,"Away",{"$f":"Template!G40","v":"Whitehills"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D25,\"'!$F25\"))","v":4},1,{"$f":"INDIRECT(CONCATENATE(\"'\",$D25,\"'!H25\"))","v":55},{"$f":"INDIRECT(CONCATENATE(\"'\",$D25,\"'!G25\"))","v":47},1,"Valid Scores entered","OK","OK"]

{"sheet":"Bye","index":4,"n_rows":25,"n_cols":12,"rows_kept":25,"cut":false,"hidden":false,"merged":[[2,10,2,11]]}
[]
["Team",{"$f":"Template!B5","v":"Bye"},null,{"$f":"CONCATENATE(\"Home Games:\",COUNTIF(C5:C999,\"Home\"),\" Away Games:\",COUNTIF(C5:C999,\"Away\"))","v":"Home Games:10 Away Games:11"}]
[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":"30.04.2018"},1,"Home",{"$f":"Template!J20","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":"14.05.2018"},{"$f":"B5+1","v":2},"Away",{"$f":"Template!I21","v":"Brown Bear"},{"$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":"21.05.2018"},{"$f":"B6+1","v":3},"Away",{"$f":"Template!G22","v":"Hen and Chickens"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D7,\"'!$F7\"))","v":""},"",{"$f":"INDIRECT(CONCATENATE(\"'\",$D7,\"'!H7\"))","v":0},{"$f":"INDIRECT(CONCATENATE(\"'\",$D7,\"'!G7\"))","v":0},"","","",""]
[{"$f":"Template!B23","v":"04.06.2018"},4,"Home",{"$f":"Template!F23","v":"Plough"},null,"",null,null,"","","",""]
[{"$f":"Template!B24","v":"11.06.2018"},5,"Away",{"$f":"Template!C24","v":"George A"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D9,\"'!$F9\"))","v":""},"",{"$f":"INDIRECT(CONCATENATE(\"'\",$D9,\"'!H9\"))","v":0},{"$f":"INDIRECT(CONCATENATE(\"'\",$D9,\"'!G9\"))","v":0},"","","",""]
[{"$f":"Template!B25","v":"18.06.2018"},6,"Home",{"$f":"Template!H25","v":"Whitehills"},null,"",null,null,"","","",""]
[{"$f":"Template!B26","v":"25.06.2018"},7,"Away",{"$f":"Template!E26","v":"Farmers Boy"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D11,\"'!$F11\"))","v":""},"",{"$f":"INDIRECT(CONCATENATE(\"'\",$D11,\"'!H11\"))","v":0},{"$f":"INDIRECT(CONCATENATE(\"'\",$D11,\"'!G11\"))","v":0},"","","",""]
[{"$f":"Template!B27","v":"02.07.2018"},8,"Away",{"$f":"Template!I27","v":"Old Bulls Head"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D12,\"'!$F12\"))","v":""},"",{"$f":"INDIRECT(CONCATENATE(\"'\",$D12,\"'!H12\"))","v":0},{"$f":"INDIRECT(CONCATENATE(\"'\",$D12,\"'!G12\"))","v":0},"","","",""]
[{"$f":"Template!B28","v":"09.07.2018"},9,"Home",{"$f":"Template!J28","v":"Brown Bear"},null,"",null,null,"","","",""]
[{"$f":"Template!B29","v":"16.07.2018"},10,"Home",{"$f":"Template!H29","v":"Hen and Chickens"},null,"",null,null,"","","",""]
[{"$f":"Template!B30","v":"23.07.2018"},11,"Away",{"$f":"Template!E30","v":"Plough"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D15,\"'!$F15\"))","v":""},"",{"$f":"INDIRECT(CONCATENATE(\"'\",$D15,\"'!H15\"))","v":0},{"$f":"INDIRECT(CONCATENATE(\"'\",$D15,\"'!G15\"))","v":0},"","","",""]
[{"$f":"Template!B31","v":"30.07.2018"},12,"Home",{"$f":"Template!D31","v":"George A"},null,"",null,null,"","","",""]
[{"$f":"Template!B32","v":"06.08.2018"},13,"Away",{"$f":"Template!G32","v":"Whitehills"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D17,\"'!$F17\"))","v":""},"",{"$f":"INDIRECT(CONCATENATE(\"'\",$D17,\"'!H17\"))","v":0},{"$f":"INDIRECT(CONCATENATE(\"'\",$D17,\"'!G17\"))","v":0},"","","",""]
[{"$f":"Template!B33","v":"13.08.2018"},14,"Home",{"$f":"Template!F33","v":"Farmers Boy"},null,"",null,null,"","","",""]
[{"$f":"Template!B34","v":"20.08.2018"},15,"Home",{"$f":"Template!J34","v":"Old Bulls Head"},null,"",null,null,"","","",""]
[{"$f":"Template!B35","v":"03.09.2018"},16,"Away",{"$f":"Template!I35","v":"Brown Bear"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D20,\"'!$F20\"))","v":""},"",{"$f":"INDIRECT(CONCATENATE(\"'\",$D20,\"'!H20\"))","v":0},{"$f":"INDIRECT(CONCATENATE(\"'\",$D20,\"'!G20\"))","v":0},"","","",""]
[{"$f":"Template!B36","v":"10.09.2018"},17,"Away",{"$f":"Template!G36","v":"Hen and Chickens"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D21,\"'!$F21\"))","v":""},"",{"$f":"INDIRECT(CONCATENATE(\"'\",$D21,\"'!H21\"))","v":0},{"$f":"INDIRECT(CONCATENATE(\"'\",$D21,\"'!G21\"))","v":0},"","","",""]
[{"$f":"Template!B37","v":"17.09.2018"},18,"Home",{"$f":"Template!F37","v":"Plough"},null,"",null,null,"","","",""]
[{"$f":"Template!B38","v":"24.09.2018"},19,"Away",{"$f":"Template!C38","v":"George A"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D23,\"'!$F23\"))","v":""},"",{"$f":"INDIRECT(CONCATENATE(\"'\",$D23,\"'!H23\"))","v":0},{"$f":"INDIRECT(CONCATENATE(\"'\",$D23,\"'!G23\"))","v":0},{"$f":"IF(E23=\"\",\"\",IF(E23>2,1,0))","v":""},{"$f":"IF(E23=\"\",\"\",IF(OR(E23<0,E23>5,G23<0,G23>(5*13),H23<0,H23>(5*13)),\"Number out of range error\",\"Valid Scores entered\"))","v":""},{"$f":"IF(E23=\"\",\"\",IF((E23*13>G23),\"Error in submitting Games Won or Points Home\",\"OK\"))","v":""},{"$f":"IF(E23=\"\",\"\",IF((F23*13>H23),\"Error in submitting Games Won or Points Away\",\"OK\"))","v":""}]
[{"$f":"Template!B39","v":"01.10.2018"},20,"Home",{"$f":"Template!H39","v":"Whitehills"},null,"",null,null,"","","",""]
[{"$f":"Template!B40","v":"08.10.2018"},21,"Away",{"$f":"Template!E40","v":"Farmers Boy"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D25,\"'!$F25\"))","v":""},"",{"$f":"INDIRECT(CONCATENATE(\"'\",$D25,\"'!H25\"))","v":0},{"$f":"INDIRECT(CONCATENATE(\"'\",$D25,\"'!G25\"))","v":0},"","","",""]

{"sheet":"Old Bulls Head","index":5,"n_rows":25,"n_cols":12,"rows_kept":25,"cut":false,"hidden":false,"merged":[[2,10,2,11]]}
[]
["Team",{"$f":"Template!B6","v":"Old Bulls Head"},null,{"$f":"CONCATENATE(\"Home Games:\",COUNTIF(C5:C999,\"Home\"),\" Away Games:\",COUNTIF(C5:C999,\"Away\"))","v":"Home Games:10 Away Games:11"}]
[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":"30.04.2018"},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":"14.05.2018"},{"$f":"B5+1","v":2},"Home",{"$f":"Template!H21","v":"Hen and Chickens"},4,1,63,36,{"$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":"21.05.2018"},{"$f":"B6+1","v":3},"Away",{"$f":"Template!E22","v":"Plough"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D7,\"'!$F7\"))","v":4},1,{"$f":"INDIRECT(CONCATENATE(\"'\",$D7,\"'!H7\"))","v":58},{"$f":"INDIRECT(CONCATENATE(\"'\",$D7,\"'!G7\"))","v":44},1,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B23","v":"04.06.2018"},4,"Home",{"$f":"Template!D23","v":"George A"},5,0,65,35,1,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B24","v":"11.06.2018"},5,"Away",{"$f":"Template!G24","v":"Whitehills"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D9,\"'!$F9\"))","v":3},2,{"$f":"INDIRECT(CONCATENATE(\"'\",$D9,\"'!H9\"))","v":51},{"$f":"INDIRECT(CONCATENATE(\"'\",$D9,\"'!G9\"))","v":40},1,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B25","v":"18.06.2018"},6,"Home",{"$f":"Template!F25","v":"Farmers Boy"},0,5,22,65,0,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B26","v":"25.06.2018"},7,"Away",{"$f":"Template!I26","v":"Brown Bear"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D11,\"'!$F11\"))","v":3},2,{"$f":"INDIRECT(CONCATENATE(\"'\",$D11,\"'!H11\"))","v":46},{"$f":"INDIRECT(CONCATENATE(\"'\",$D11,\"'!G11\"))","v":52},1,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B27","v":"02.07.2018"},8,"Home",{"$f":"Template!J27","v":"Bye"},null,"",null,null,"","","",""]
[{"$f":"Template!B28","v":"09.07.2018"},9,"Away",{"$f":"Template!G28","v":"Hen and Chickens"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D13,\"'!$F13\"))","v":3},2,{"$f":"INDIRECT(CONCATENATE(\"'\",$D13,\"'!H13\"))","v":54},{"$f":"INDIRECT(CONCATENATE(\"'\",$D13,\"'!G13\"))","v":54},1,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B29","v":"16.07.2018"},10,"Home",{"$f":"Template!F29","v":"Plough"},5,0,65,26,1,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B30","v":"23.07.2018"},11,"Away",{"$f":"Template!C30","v":"George A"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D15,\"'!$F15\"))","v":2},3,{"$f":"INDIRECT(CONCATENATE(\"'\",$D15,\"'!H15\"))","v":55},{"$f":"INDIRECT(CONCATENATE(\"'\",$D15,\"'!G15\"))","v":49},0,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B31","v":"30.07.2018"},12,"Home",{"$f":"Template!H31","v":"Whitehills"},2,3,55,56,0,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B32","v":"06.08.2018"},13,"Away",{"$f":"Template!E32","v":"Farmers Boy"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D17,\"'!$F17\"))","v":2},3,{"$f":"INDIRECT(CONCATENATE(\"'\",$D17,\"'!H17\"))","v":51},{"$f":"INDIRECT(CONCATENATE(\"'\",$D17,\"'!G17\"))","v":57},0,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B33","v":"13.08.2018"},14,"Home",{"$f":"Template!J33","v":"Brown Bear"},1,4,38,53,0,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B34","v":"20.08.2018"},15,"Away",{"$f":"Template!I34","v":"Bye"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D19,\"'!$F19\"))","v":""},"",{"$f":"INDIRECT(CONCATENATE(\"'\",$D19,\"'!H19\"))","v":0},{"$f":"INDIRECT(CONCATENATE(\"'\",$D19,\"'!G19\"))","v":0},"","","",""]
[{"$f":"Template!B35","v":"03.09.2018"},16,"Home",{"$f":"Template!H35","v":"Hen and Chickens"},2,3,33,52,0,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B36","v":"10.09.2018"},17,"Away",{"$f":"Template!E36","v":"Plough"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D21,\"'!$F21\"))","v":3},2,{"$f":"INDIRECT(CONCATENATE(\"'\",$D21,\"'!H21\"))","v":48},{"$f":"INDIRECT(CONCATENATE(\"'\",$D21,\"'!G21\"))","v":40},1,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B37","v":"17.09.2018"},18,"Home",{"$f":"Template!D37","v":"George A"},5,0,65,25,1,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B38","v":"24.09.2018"},19,"Away",{"$f":"Template!G38","v":"Whitehills"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D23,\"'!$F23\"))","v":2},3,{"$f":"INDIRECT(CONCATENATE(\"'\",$D23,\"'!H23\"))","v":49},{"$f":"INDIRECT(CONCATENATE(\"'\",$D23,\"'!G23\"))","v":55},{"$f":"IF(E23=\"\",\"\",IF(E23>2,1,0))","v":0},{"$f":"IF(E23=\"\",\"\",IF(OR(E23<0,E23>5,G23<0,G23>(5*13),H23<0,H23>(5*13)),\"Number out of range error\",\"Valid Scores entered\"))","v":"Valid Scores entered"},{"$f":"IF(E23=\"\",\"\",IF((E23*13>G23),\"Error in submitting Games Won or Points Home\",\"OK\"))","v":"OK"},{"$f":"IF(E23=\"\",\"\",IF((F23*13>H23),\"Error in submitting Games Won or Points Away\",\"OK\"))","v":"OK"}]
[{"$f":"Template!B39","v":"01.10.2018"},20,"Home",{"$f":"Template!F39","v":"Farmers Boy"},4,1,61,48,1,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B40","v":"08.10.2018"},21,"Away",{"$f":"Template!I40","v":"Brown Bear"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D25,\"'!$F25\"))","v":3},2,{"$f":"INDIRECT(CONCATENATE(\"'\",$D25,\"'!H25\"))","v":56},{"$f":"INDIRECT(CONCATENATE(\"'\",$D25,\"'!G25\"))","v":58},1,"Valid Scores entered","OK","OK"]

{"sheet":"Farmers Boy","index":6,"n_rows":25,"n_cols":12,"rows_kept":25,"cut":false,"hidden":false,"merged":[[2,10,2,11]]}
[]
["Team",{"$f":"Template!B7","v":"Farmers Boy"},null,{"$f":"CONCATENATE(\"Home Games:\",COUNTIF(C5:C999,\"Home\"),\" Away Games:\",COUNTIF(C5:C999,\"Away\"))","v":"Home Games:10 Away Games:11"}]
[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":"30.04.2018"},1,"Away",{"$f":"Template!G20","v":"Hen and Chickens"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D5,\"'!$F5\"))","v":1},{"$f":"IF(E5=\"\",\"\",5-E5)","v":4},{"$f":"INDIRECT(CONCATENATE(\"'\",$D5,\"'!H5\"))","v":29},{"$f":"INDIRECT(CONCATENATE(\"'\",$D5,\"'!G5\"))","v":56},{"$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":"14.05.2018"},{"$f":"B5+1","v":2},"Home",{"$f":"Template!F21","v":"Plough"},5,{"$f":"IF(E6=\"\",\"\",5-E6)","v":0},65,31,{"$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":"21.05.2018"},{"$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":51},{"$f":"INDIRECT(CONCATENATE(\"'\",$D7,\"'!G7\"))","v":48},1,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B23","v":"04.06.2018"},4,"Home",{"$f":"Template!H23","v":"Whitehills"},4,1,64,33,1,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B24","v":"11.06.2018"},5,"Away",{"$f":"Template!I24","v":"Brown Bear"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D9,\"'!$F9\"))","v":2},3,{"$f":"INDIRECT(CONCATENATE(\"'\",$D9,\"'!H9\"))","v":50},{"$f":"INDIRECT(CONCATENATE(\"'\",$D9,\"'!G9\"))","v":61},0,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B25","v":"18.06.2018"},6,"Away",{"$f":"Template!E25","v":"Old Bulls Head"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D10,\"'!$F10\"))","v":5},0,{"$f":"INDIRECT(CONCATENATE(\"'\",$D10,\"'!H10\"))","v":65},{"$f":"INDIRECT(CONCATENATE(\"'\",$D10,\"'!G10\"))","v":22},1,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B26","v":"25.06.2018"},7,"Home",{"$f":"Template!F26","v":"Bye"},null,"",null,null,"","","",""]
[{"$f":"Template!B27","v":"02.07.2018"},8,"Home",{"$f":"Template!H27","v":"Hen and Chickens"},4,1,64,37,1,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B28","v":"09.07.2018"},9,"Away",{"$f":"Template!E28","v":"Plough"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D13,\"'!$F13\"))","v":4},1,{"$f":"INDIRECT(CONCATENATE(\"'\",$D13,\"'!H13\"))","v":61},{"$f":"INDIRECT(CONCATENATE(\"'\",$D13,\"'!G13\"))","v":48},1,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B29","v":"16.07.2018"},10,"Home",{"$f":"Template!D29","v":"George A"},4,1,64,51,1,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B30","v":"23.07.2018"},11,"Away",{"$f":"Template!G30","v":"Whitehills"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D15,\"'!$F15\"))","v":0},5,{"$f":"INDIRECT(CONCATENATE(\"'\",$D15,\"'!H15\"))","v":37},{"$f":"INDIRECT(CONCATENATE(\"'\",$D15,\"'!G15\"))","v":65},0,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B31","v":"30.07.2018"},12,"Home",{"$f":"Template!J31","v":"Brown Bear"},2,3,35,50,0,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B32","v":"06.08.2018"},13,"Home",{"$f":"Template!F32","v":"Old Bulls Head"},3,2,57,51,1,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B33","v":"13.08.2018"},14,"Away",{"$f":"Template!E33","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":"20.08.2018"},15,"Away",{"$f":"Template!G34","v":"Hen and Chickens"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D19,\"'!$F19\"))","v":2},3,{"$f":"INDIRECT(CONCATENATE(\"'\",$D19,\"'!H19\"))","v":43},{"$f":"INDIRECT(CONCATENATE(\"'\",$D19,\"'!G19\"))","v":56},0,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B35","v":"03.09.2018"},16,"Home",{"$f":"Template!F35","v":"Plough"},4,1,58,18,1,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B36","v":"10.09.2018"},17,"Away",{"$f":"Template!C36","v":"George A"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D21,\"'!$F21\"))","v":2},3,{"$f":"INDIRECT(CONCATENATE(\"'\",$D21,\"'!H21\"))","v":53},{"$f":"INDIRECT(CONCATENATE(\"'\",$D21,\"'!G21\"))","v":57},0,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B37","v":"17.09.2018"},18,"Home",{"$f":"Template!H37","v":"Whitehills"},2,3,50,51,0,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B38","v":"24.09.2018"},19,"Away",{"$f":"Template!I38","v":"Brown Bear"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D23,\"'!$F23\"))","v":1},4,{"$f":"INDIRECT(CONCATENATE(\"'\",$D23,\"'!H23\"))","v":30},{"$f":"INDIRECT(CONCATENATE(\"'\",$D23,\"'!G23\"))","v":64},{"$f":"IF(E23=\"\",\"\",IF(E23>2,1,0))","v":0},{"$f":"IF(E23=\"\",\"\",IF(OR(E23<0,E23>5,G23<0,G23>(5*13),H23<0,H23>(5*13)),\"Number out of range error\",\"Valid Scores entered\"))","v":"Valid Scores entered"},{"$f":"IF(E23=\"\",\"\",IF((E23*13>G23),\"Error in submitting Games Won or Points Home\",\"OK\"))","v":"OK"},{"$f":"IF(E23=\"\",\"\",IF((F23*13>H23),\"Error in submitting Games Won or Points Away\",\"OK\"))","v":"OK"}]
[{"$f":"Template!B39","v":"01.10.2018"},20,"Away",{"$f":"Template!E39","v":"Old Bulls Head"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D24,\"'!$F24\"))","v":1},4,{"$f":"INDIRECT(CONCATENATE(\"'\",$D24,\"'!H24\"))","v":48},{"$f":"INDIRECT(CONCATENATE(\"'\",$D24,\"'!G24\"))","v":61},0,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B40","v":"08.10.2018"},21,"Home",{"$f":"Template!F40","v":"Bye"},null,"",null,null,"","","",""]

{"sheet":"Whitehills","index":7,"n_rows":25,"n_cols":12,"rows_kept":25,"cut":false,"hidden":false,"merged":[[2,10,2,11]]}
[]
["Team",{"$f":"Template!B8","v":"Whitehills"},null,{"$f":"CONCATENATE(\"Home Games:\",COUNTIF(C5:C999,\"Home\"),\" Away Games:\",COUNTIF(C5:C999,\"Away\"))","v":"Home Games:10 Away Games:11"}]
[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":"30.04.2018"},1,"Away",{"$f":"Template!E20","v":"Plough"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D5,\"'!$F5\"))","v":3},{"$f":"IF(E5=\"\",\"\",5-E5)","v":2},{"$f":"INDIRECT(CONCATENATE(\"'\",$D5,\"'!H5\"))","v":56},{"$f":"INDIRECT(CONCATENATE(\"'\",$D5,\"'!G5\"))","v":50},{"$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":"14.05.2018"},{"$f":"B5+1","v":2},"Home",{"$f":"Template!D21","v":"George A"},4,1,64,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":"21.05.2018"},{"$f":"B6+1","v":3},"Away",{"$f":"Template!I22","v":"Brown Bear"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D7,\"'!$F7\"))","v":1},4,{"$f":"INDIRECT(CONCATENATE(\"'\",$D7,\"'!H7\"))","v":53},{"$f":"INDIRECT(CONCATENATE(\"'\",$D7,\"'!G7\"))","v":54},0,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B23","v":"04.06.2018"},4,"Away",{"$f":"Template!G23","v":"Farmers Boy"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D8,\"'!$F8\"))","v":1},4,{"$f":"INDIRECT(CONCATENATE(\"'\",$D8,\"'!H8\"))","v":33},{"$f":"INDIRECT(CONCATENATE(\"'\",$D8,\"'!G8\"))","v":64},0,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B24","v":"11.06.2018"},5,"Home",{"$f":"Template!H24","v":"Old Bulls Head"},2,3,40,51,0,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B25","v":"18.06.2018"},6,"Away",{"$f":"Template!G25","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":"25.06.2018"},7,"Home",{"$f":"Template!H26","v":"Hen and Chickens"},2,3,59,51,0,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B27","v":"02.07.2018"},8,"Home",{"$f":"Template!F27","v":"Plough"},4,1,63,40,1,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B28","v":"09.07.2018"},9,"Away",{"$f":"Template!C28","v":"George A"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D13,\"'!$F13\"))","v":2},3,{"$f":"INDIRECT(CONCATENATE(\"'\",$D13,\"'!H13\"))","v":40},{"$f":"INDIRECT(CONCATENATE(\"'\",$D13,\"'!G13\"))","v":55},0,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B29","v":"16.07.2018"},10,"Home",{"$f":"Template!J29","v":"Brown Bear"},2,3,36,43,0,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B30","v":"23.07.2018"},11,"Home",{"$f":"Template!H30","v":"Farmers Boy"},5,0,65,37,1,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B31","v":"30.07.2018"},12,"Away",{"$f":"Template!G31","v":"Old Bulls Head"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D16,\"'!$F16\"))","v":3},2,{"$f":"INDIRECT(CONCATENATE(\"'\",$D16,\"'!H16\"))","v":56},{"$f":"INDIRECT(CONCATENATE(\"'\",$D16,\"'!G16\"))","v":55},1,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B32","v":"06.08.2018"},13,"Home",{"$f":"Template!H32","v":"Bye"},null,"",null,null,"","","",""]
[{"$f":"Template!B33","v":"13.08.2018"},14,"Away",{"$f":"Template!G33","v":"Hen and Chickens"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D18,\"'!$F18\"))","v":4},1,{"$f":"INDIRECT(CONCATENATE(\"'\",$D18,\"'!H18\"))","v":61},{"$f":"INDIRECT(CONCATENATE(\"'\",$D18,\"'!G18\"))","v":47},1,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B34","v":"20.08.2018"},15,"Away",{"$f":"Template!E34","v":"Plough"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D19,\"'!$F19\"))","v":3},2,{"$f":"INDIRECT(CONCATENATE(\"'\",$D19,\"'!H19\"))","v":59},{"$f":"INDIRECT(CONCATENATE(\"'\",$D19,\"'!G19\"))","v":44},1,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B35","v":"03.09.2018"},16,"Home",{"$f":"Template!D35","v":"George A"},4,1,59,23,1,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B36","v":"10.09.2018"},17,"Away",{"$f":"Template!I36","v":"Brown Bear"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D21,\"'!$F21\"))","v":4},1,{"$f":"INDIRECT(CONCATENATE(\"'\",$D21,\"'!H21\"))","v":63},{"$f":"INDIRECT(CONCATENATE(\"'\",$D21,\"'!G21\"))","v":41},1,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B37","v":"17.09.2018"},18,"Away",{"$f":"Template!G37","v":"Farmers Boy"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D22,\"'!$F22\"))","v":3},2,{"$f":"INDIRECT(CONCATENATE(\"'\",$D22,\"'!H22\"))","v":51},{"$f":"INDIRECT(CONCATENATE(\"'\",$D22,\"'!G22\"))","v":50},1,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B38","v":"24.09.2018"},19,"Home",{"$f":"Template!H38","v":"Old Bulls Head"},3,2,55,49,{"$f":"IF(E23=\"\",\"\",IF(E23>2,1,0))","v":1},{"$f":"IF(E23=\"\",\"\",IF(OR(E23<0,E23>5,G23<0,G23>(5*13),H23<0,H23>(5*13)),\"Number out of range error\",\"Valid Scores entered\"))","v":"Valid Scores entered"},{"$f":"IF(E23=\"\",\"\",IF((E23*13>G23),\"Error in submitting Games Won or Points Home\",\"OK\"))","v":"OK"},{"$f":"IF(E23=\"\",\"\",IF((F23*13>H23),\"Error in submitting Games Won or Points Away\",\"OK\"))","v":"OK"}]
[{"$f":"Template!B39","v":"01.10.2018"},20,"Away",{"$f":"Template!G39","v":"Bye"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D24,\"'!$F24\"))","v":""},"",{"$f":"INDIRECT(CONCATENATE(\"'\",$D24,\"'!H24\"))","v":0},{"$f":"INDIRECT(CONCATENATE(\"'\",$D24,\"'!G24\"))","v":0},"","","",""]
[{"$f":"Template!B40","v":"08.10.2018"},21,"Home",{"$f":"Template!H40","v":"Hen and Chickens"},1,4,47,55,0,"Valid Scores entered","OK","OK"]

{"sheet":"Brown Bear","index":8,"n_rows":25,"n_cols":12,"rows_kept":25,"cut":false,"hidden":false,"merged":[[2,10,2,11]]}
[]
["Team",{"$f":"Template!B9","v":"Brown Bear"},null,{"$f":"CONCATENATE(\"Home Games:\",COUNTIF(C5:C999,\"Home\"),\" Away Games:\",COUNTIF(C5:C999,\"Away\"))","v":"Home Games:11 Away Games:10"}]
[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":"30.04.2018"},1,"Away",{"$f":"Template!C20","v":"George A"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D5,\"'!$F5\"))","v":2},{"$f":"IF(E5=\"\",\"\",5-E5)","v":3},{"$f":"INDIRECT(CONCATENATE(\"'\",$D5,\"'!H5\"))","v":57},{"$f":"INDIRECT(CONCATENATE(\"'\",$D5,\"'!G5\"))","v":44},{"$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":"14.05.2018"},{"$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":"21.05.2018"},{"$f":"B6+1","v":3},"Home",{"$f":"Template!J22","v":"Whitehills"},4,1,54,53,1,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B23","v":"04.06.2018"},4,"Away",{"$f":"Template!I23","v":"Hen and Chickens"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D8,\"'!$F8\"))","v":3},2,{"$f":"INDIRECT(CONCATENATE(\"'\",$D8,\"'!H8\"))","v":49},{"$f":"INDIRECT(CONCATENATE(\"'\",$D8,\"'!G8\"))","v":36},1,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B24","v":"11.06.2018"},5,"Home",{"$f":"Template!J24","v":"Farmers Boy"},3,2,61,50,1,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B25","v":"18.06.2018"},6,"Away",{"$f":"Template!I25","v":"Plough"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D10,\"'!$F10\"))","v":2},3,{"$f":"INDIRECT(CONCATENATE(\"'\",$D10,\"'!H10\"))","v":55},{"$f":"INDIRECT(CONCATENATE(\"'\",$D10,\"'!G10\"))","v":54},0,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B26","v":"25.06.2018"},7,"Home",{"$f":"Template!J26","v":"Old Bulls Head"},2,3,52,46,0,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B27","v":"02.07.2018"},8,"Home",{"$f":"Template!D27","v":"George A"},5,{"$f":"IF(E12=\"\",\"\",5-E12)","v":0},65,28,1,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B28","v":"09.07.2018"},9,"Away",{"$f":"Template!I28","v":"Bye"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D13,\"'!$F13\"))","v":""},"",{"$f":"INDIRECT(CONCATENATE(\"'\",$D13,\"'!H13\"))","v":0},{"$f":"INDIRECT(CONCATENATE(\"'\",$D13,\"'!G13\"))","v":0},"","","",""]
[{"$f":"Template!B29","v":"16.07.2018"},10,"Away",{"$f":"Template!I29","v":"Whitehills"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D14,\"'!$F14\"))","v":3},2,{"$f":"INDIRECT(CONCATENATE(\"'\",$D14,\"'!H14\"))","v":43},{"$f":"INDIRECT(CONCATENATE(\"'\",$D14,\"'!G14\"))","v":36},1,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B30","v":"23.07.2018"},11,"Home",{"$f":"Template!J30","v":"Hen and Chickens"},3,2,49,42,1,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B31","v":"30.07.2018"},12,"Away",{"$f":"Template!I31","v":"Farmers Boy"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D16,\"'!$F16\"))","v":3},2,{"$f":"INDIRECT(CONCATENATE(\"'\",$D16,\"'!H16\"))","v":50},{"$f":"INDIRECT(CONCATENATE(\"'\",$D16,\"'!G16\"))","v":35},1,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B32","v":"06.08.2018"},13,"Home",{"$f":"Template!J32","v":"Plough"},2,3,48,55,0,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B33","v":"13.08.2018"},14,"Away",{"$f":"Template!I33","v":"Old Bulls Head"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D18,\"'!$F18\"))","v":4},1,{"$f":"INDIRECT(CONCATENATE(\"'\",$D18,\"'!H18\"))","v":53},{"$f":"INDIRECT(CONCATENATE(\"'\",$D18,\"'!G18\"))","v":38},1,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B34","v":"20.08.2018"},15,"Away",{"$f":"Template!C34","v":"George A"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D19,\"'!$F19\"))","v":3},2,{"$f":"INDIRECT(CONCATENATE(\"'\",$D19,\"'!H19\"))","v":53},{"$f":"INDIRECT(CONCATENATE(\"'\",$D19,\"'!G19\"))","v":35},1,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B35","v":"03.09.2018"},16,"Home",{"$f":"Template!J35","v":"Bye"},null,"",null,null,"","","",""]
[{"$f":"Template!B36","v":"10.09.2018"},17,"Home",{"$f":"Template!J36","v":"Whitehills"},1,4,41,63,0,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B37","v":"17.09.2018"},18,"Away",{"$f":"Template!I37","v":"Hen and Chickens"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D22,\"'!$F22\"))","v":2},3,{"$f":"INDIRECT(CONCATENATE(\"'\",$D22,\"'!H22\"))","v":47},{"$f":"INDIRECT(CONCATENATE(\"'\",$D22,\"'!G22\"))","v":54},0,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B38","v":"24.09.2018"},19,"Home",{"$f":"Template!J38","v":"Farmers Boy"},4,1,64,30,{"$f":"IF(E23=\"\",\"\",IF(E23>2,1,0))","v":1},{"$f":"IF(E23=\"\",\"\",IF(OR(E23<0,E23>5,G23<0,G23>(5*13),H23<0,H23>(5*13)),\"Number out of range error\",\"Valid Scores entered\"))","v":"Valid Scores entered"},{"$f":"IF(E23=\"\",\"\",IF((E23*13>G23),\"Error in submitting Games Won or Points Home\",\"OK\"))","v":"OK"},{"$f":"IF(E23=\"\",\"\",IF((F23*13>H23),\"Error in submitting Games Won or Points Away\",\"OK\"))","v":"OK"}]
[{"$f":"Template!B39","v":"01.10.2018"},20,"Away",{"$f":"Template!I39","v":"Plough"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D24,\"'!$F24\"))","v":4},1,{"$f":"INDIRECT(CONCATENATE(\"'\",$D24,\"'!H24\"))","v":62},{"$f":"INDIRECT(CONCATENATE(\"'\",$D24,\"'!G24\"))","v":42},1,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B40","v":"08.10.2018"},21,"Home",{"$f":"Template!J40","v":"Old Bulls Head"},2,3,58,56,0,"Valid Scores entered","OK","OK"]

{"sheet":"Template","index":9,"n_rows":40,"n_cols":10,"rows_kept":40,"cut":false,"hidden":false,"merged":[[17,2,17,3],[17,10,17,11],[3,5,5,7],[17,4,17,5],[17,6,17,7],[17,8,17,9]]}
["Team Number","Team Name","Buddy Team"]
[1,"George A",{"$f":"B6","v":"Old Bulls Head"}]
[2,"Plough",{"$f":"B7","v":"Farmers Boy"}]
[3,"Hen and Chickens",{"$f":"B8","v":"Whitehills"},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":"B9","v":"Brown Bear"}]
[5,"Old Bulls Head",{"$f":"B2","v":"George A"}]
[6,"Farmers Boy",{"$f":"B3","v":"Plough"}]
[7,"Whitehills",{"$f":"B4","v":"Hen and Chickens"}]
[8,"Brown Bear",{"$f":"B5","v":"Bye"}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Match 1",null,"Match 2",null,"Match 3",null,"Match 4"]
["Week","Date","Home","Away","Home","Away","Home","Away","Home","Away"]
[1,"30.04.2018",{"$f":"team1","v":"George A"},{"$f":"team8","v":"Brown Bear"},{"$f":"team2","v":"Plough"},{"$f":"team7","v":"Whitehills"},{"$f":"team3","v":"Hen and Chickens"},{"$f":"team6","v":"Farmers Boy"},{"$f":"team4","v":"Bye"},{"$f":"team5","v":"Old Bulls Head"}]
[2,"14.05.2018",{"$f":"team7","v":"Whitehills"},{"$f":"team1","v":"George A"},{"$f":"team6","v":"Farmers Boy"},{"$f":"team2","v":"Plough"},{"$f":"team5","v":"Old Bulls Head"},{"$f":"team3","v":"Hen and Chickens"},{"$f":"team8","v":"Brown Bear"},{"$f":"team4","v":"Bye"}]
[3,"21.05.2018",{"$f":"team1","v":"George A"},{"$f":"team6","v":"Farmers Boy"},{"$f":"team2","v":"Plough"},{"$f":"team5","v":"Old Bulls Head"},{"$f":"team3","v":"Hen and Chickens"},{"$f":"team4","v":"Bye"},{"$f":"team8","v":"Brown Bear"},{"$f":"team7","v":"Whitehills"}]
[4,"04.06.2018",{"$f":"team5","v":"Old Bulls Head"},{"$f":"team1","v":"George A"},{"$f":"team4","v":"Bye"},{"$f":"team2","v":"Plough"},{"$f":"team6","v":"Farmers Boy"},{"$f":"team7","v":"Whitehills"},{"$f":"team3","v":"Hen and Chickens"},{"$f":"team8","v":"Brown Bear"}]
[5,"11.06.2018",{"$f":"team1","v":"George A"},{"$f":"team4","v":"Bye"},{"$f":"team2","v":"Plough"},{"$f":"team3","v":"Hen and Chickens"},{"$f":"team7","v":"Whitehills"},{"$f":"team5","v":"Old Bulls Head"},{"$f":"team8","v":"Brown Bear"},{"$f":"team6","v":"Farmers Boy"}]
[6,"18.06.2018",{"$f":"team3","v":"Hen and Chickens"},{"$f":"team1","v":"George A"},{"$f":"team5","v":"Old Bulls Head"},{"$f":"team6","v":"Farmers Boy"},{"$f":"team4","v":"Bye"},{"$f":"team7","v":"Whitehills"},{"$f":"team2","v":"Plough"},{"$f":"team8","v":"Brown Bear"}]
[7,"25.06.2018",{"$f":"team1","v":"George A"},{"$f":"team2","v":"Plough"},{"$f":"team6","v":"Farmers Boy"},{"$f":"team4","v":"Bye"},{"$f":"team7","v":"Whitehills"},{"$f":"team3","v":"Hen and Chickens"},{"$f":"team8","v":"Brown Bear"},{"$f":"team5","v":"Old Bulls Head"}]
[8,"02.07.2018",{"$f":"team8","v":"Brown Bear"},{"$f":"team1","v":"George A"},{"$f":"team7","v":"Whitehills"},{"$f":"team2","v":"Plough"},{"$f":"team6","v":"Farmers Boy"},{"$f":"team3","v":"Hen and Chickens"},{"$f":"team5","v":"Old Bulls Head"},{"$f":"team4","v":"Bye"}]
[9,"09.07.2018",{"$f":"team1","v":"George A"},{"$f":"team7","v":"Whitehills"},{"$f":"team2","v":"Plough"},{"$f":"team6","v":"Farmers Boy"},{"$f":"team3","v":"Hen and Chickens"},{"$f":"team5","v":"Old Bulls Head"},{"$f":"team4","v":"Bye"},{"$f":"team8","v":"Brown Bear"}]
[10,"16.07.2018",{"$f":"team6","v":"Farmers Boy"},{"$f":"team1","v":"George A"},{"$f":"team5","v":"Old Bulls Head"},{"$f":"team2","v":"Plough"},{"$f":"team4","v":"Bye"},{"$f":"team3","v":"Hen and Chickens"},{"$f":"team7","v":"Whitehills"},{"$f":"team8","v":"Brown Bear"}]
[11,"23.07.2018",{"$f":"team1","v":"George A"},{"$f":"team5","v":"Old Bulls Head"},{"$f":"team2","v":"Plough"},{"$f":"team4","v":"Bye"},{"$f":"team7","v":"Whitehills"},{"$f":"team6","v":"Farmers Boy"},{"$f":"team8","v":"Brown Bear"},{"$f":"team3","v":"Hen and Chickens"}]
[12,"30.07.2018",{"$f":"team4","v":"Bye"},{"$f":"team1","v":"George A"},{"$f":"team3","v":"Hen and Chickens"},{"$f":"team2","v":"Plough"},{"$f":"team5","v":"Old Bulls Head"},{"$f":"team7","v":"Whitehills"},{"$f":"team6","v":"Farmers Boy"},{"$f":"team8","v":"Brown Bear"}]
[13,"06.08.2018",{"$f":"team1","v":"George A"},{"$f":"team3","v":"Hen and Chickens"},{"$f":"team6","v":"Farmers Boy"},{"$f":"team5","v":"Old Bulls Head"},{"$f":"team7","v":"Whitehills"},{"$f":"team4","v":"Bye"},{"$f":"team8","v":"Brown Bear"},{"$f":"team2","v":"Plough"}]
[14,"13.08.2018",{"$f":"team2","v":"Plough"},{"$f":"team1","v":"George A"},{"$f":"team4","v":"Bye"},{"$f":"team6","v":"Farmers Boy"},{"$f":"team3","v":"Hen and Chickens"},{"$f":"team7","v":"Whitehills"},{"$f":"team5","v":"Old Bulls Head"},{"$f":"team8","v":"Brown Bear"}]
[15,"20.08.2018",{"$f":"team1","v":"George A"},{"$f":"team8","v":"Brown Bear"},{"$f":"team2","v":"Plough"},{"$f":"team7","v":"Whitehills"},{"$f":"team3","v":"Hen and Chickens"},{"$f":"team6","v":"Farmers Boy"},{"$f":"team4","v":"Bye"},{"$f":"team5","v":"Old Bulls Head"}]
[16,"03.09.2018",{"$f":"team7","v":"Whitehills"},{"$f":"team1","v":"George A"},{"$f":"team6","v":"Farmers Boy"},{"$f":"team2","v":"Plough"},{"$f":"team5","v":"Old Bulls Head"},{"$f":"team3","v":"Hen and Chickens"},{"$f":"team8","v":"Brown Bear"},{"$f":"team4","v":"Bye"}]
[17,"10.09.2018",{"$f":"team1","v":"George A"},{"$f":"team6","v":"Farmers Boy"},{"$f":"team2","v":"Plough"},{"$f":"team5","v":"Old Bulls Head"},{"$f":"team3","v":"Hen and Chickens"},{"$f":"team4","v":"Bye"},{"$f":"team8","v":"Brown Bear"},{"$f":"team7","v":"Whitehills"}]
[18,"17.09.2018",{"$f":"team5","v":"Old Bulls Head"},{"$f":"team1","v":"George A"},{"$f":"team4","v":"Bye"},{"$f":"team2","v":"Plough"},{"$f":"team6","v":"Farmers Boy"},{"$f":"team7","v":"Whitehills"},{"$f":"team3","v":"Hen and Chickens"},{"$f":"team8","v":"Brown Bear"}]
[19,"24.09.2018",{"$f":"team1","v":"George A"},{"$f":"team4","v":"Bye"},{"$f":"team2","v":"Plough"},{"$f":"team3","v":"Hen and Chickens"},{"$f":"team7","v":"Whitehills"},{"$f":"team5","v":"Old Bulls Head"},{"$f":"team8","v":"Brown Bear"},{"$f":"team6","v":"Farmers Boy"}]
[20,"01.10.2018",{"$f":"team3","v":"Hen and Chickens"},{"$f":"team1","v":"George A"},{"$f":"team5","v":"Old Bulls Head"},{"$f":"team6","v":"Farmers Boy"},{"$f":"team4","v":"Bye"},{"$f":"team7","v":"Whitehills"},{"$f":"team2","v":"Plough"},{"$f":"team8","v":"Brown Bear"}]
[21,"08.10.2018",{"$f":"team1","v":"George A"},{"$f":"team2","v":"Plough"},{"$f":"team6","v":"Farmers Boy"},{"$f":"team4","v":"Bye"},{"$f":"team7","v":"Whitehills"},{"$f":"team3","v":"Hen and Chickens"},{"$f":"team8","v":"Brown Bear"},{"$f":"team5","v":"Old Bulls Head"}]