{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Table","Star","Bye","Farmers Boy","Plough","Old Bulls Head","Goat","Template"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":9,"n_cols":8,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Matches Played","Matches Won","Games Won","Games Lost","Points Won","Points Lost","Points Diff"]
[{"$f":"Template!B2","v":"Star"},{"$f":"COUNT(INDIRECT(CONCATENATE(\"'\",A4,\"'!E:E\")))","v":11},{"$f":"SUM(INDIRECT(CONCATENATE(\"'\",A4,\"'!I:I\")))","v":9},{"$f":"SUM(INDIRECT(CONCATENATE(\"'\",A4,\"'!E:E\")))","v":42},{"$f":"SUM(INDIRECT(CONCATENATE(\"'\",A4,\"'!F:F\")))","v":13},{"$f":"SUM(INDIRECT(CONCATENATE(\"'\",A4,\"'!G:G\")))","v":635},{"$f":"SUM(INDIRECT(CONCATENATE(\"'\",A4,\"'!H:H\")))","v":375},{"$f":"F4-G4","v":260}]
[{"$f":"Template!B4","v":"Farmers Boy"},{"$f":"COUNT(INDIRECT(CONCATENATE(\"'\",A5,\"'!E:E\")))","v":12},{"$f":"SUM(INDIRECT(CONCATENATE(\"'\",A5,\"'!I:I\")))","v":9},{"$f":"SUM(INDIRECT(CONCATENATE(\"'\",A5,\"'!E:E\")))","v":36},{"$f":"SUM(INDIRECT(CONCATENATE(\"'\",A5,\"'!F:F\")))","v":24},{"$f":"SUM(INDIRECT(CONCATENATE(\"'\",A5,\"'!G:G\")))","v":651},{"$f":"SUM(INDIRECT(CONCATENATE(\"'\",A5,\"'!H:H\")))","v":540},{"$f":"F5-G5","v":111}]
[{"$f":"Template!B6","v":"Old Bulls Head"},{"$f":"COUNT(INDIRECT(CONCATENATE(\"'\",A6,\"'!E:E\")))","v":12},{"$f":"SUM(INDIRECT(CONCATENATE(\"'\",A6,\"'!I:I\")))","v":6},{"$f":"SUM(INDIRECT(CONCATENATE(\"'\",A6,\"'!E:E\")))","v":31},{"$f":"SUM(INDIRECT(CONCATENATE(\"'\",A6,\"'!F:F\")))","v":29},{"$f":"SUM(INDIRECT(CONCATENATE(\"'\",A6,\"'!G:G\")))","v":585},{"$f":"SUM(INDIRECT(CONCATENATE(\"'\",A6,\"'!H:H\")))","v":577},{"$f":"F6-G6","v":8}]
[{"$f":"Template!B5","v":"Plough"},{"$f":"COUNT(INDIRECT(CONCATENATE(\"'\",A7,\"'!E:E\")))","v":10},{"$f":"SUM(INDIRECT(CONCATENATE(\"'\",A7,\"'!I:I\")))","v":3},{"$f":"SUM(INDIRECT(CONCATENATE(\"'\",A7,\"'!E:E\")))","v":19},{"$f":"SUM(INDIRECT(CONCATENATE(\"'\",A7,\"'!F:F\")))","v":31},{"$f":"SUM(INDIRECT(CONCATENATE(\"'\",A7,\"'!G:G\")))","v":410},{"$f":"SUM(INDIRECT(CONCATENATE(\"'\",A7,\"'!H:H\")))","v":552},{"$f":"F7-G7","v":-142}]
[{"$f":"Template!B7","v":"Goat"},{"$f":"COUNT(INDIRECT(CONCATENATE(\"'\",A8,\"'!E:E\")))","v":11},{"$f":"SUM(INDIRECT(CONCATENATE(\"'\",A8,\"'!I:I\")))","v":1},{"$f":"SUM(INDIRECT(CONCATENATE(\"'\",A8,\"'!E:E\")))","v":12},{"$f":"SUM(INDIRECT(CONCATENATE(\"'\",A8,\"'!F:F\")))","v":43},{"$f":"SUM(INDIRECT(CONCATENATE(\"'\",A8,\"'!G:G\")))","v":409},{"$f":"SUM(INDIRECT(CONCATENATE(\"'\",A8,\"'!H:H\")))","v":646},{"$f":"F8-G8","v":-237}]
[{"$f":"Template!B3","v":"Bye"},{"$f":"COUNT(INDIRECT(CONCATENATE(\"'\",A9,\"'!E:E\")))","v":0},{"$f":"SUM(INDIRECT(CONCATENATE(\"'\",A9,\"'!I:I\")))","v":0},{"$f":"SUM(INDIRECT(CONCATENATE(\"'\",A9,\"'!E:E\")))","v":0},{"$f":"SUM(INDIRECT(CONCATENATE(\"'\",A9,\"'!F:F\")))","v":0},{"$f":"SUM(INDIRECT(CONCATENATE(\"'\",A9,\"'!G:G\")))","v":0},{"$f":"SUM(INDIRECT(CONCATENATE(\"'\",A9,\"'!H:H\")))","v":0},{"$f":"F9-G9","v":0}]

{"sheet":"Star","index":1,"n_rows":23,"n_cols":13,"rows_kept":23,"cut":false,"hidden":false,"merged":[[2,10,2,11]]}
[]
["Team",{"$f":"Template!B2","v":"Star"}]
[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!B16","v":"30.05.2022"},1,"Home",{"$f":"Template!D16","v":"Goat"},4,{"$f":"IF(E5=\"\",\"\",5-E5)","v":1},63,31,{"$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!B17","v":"06.06.2022"},{"$f":"B5+1","v":2},"Away",{"$f":"Template!C17","v":"Old Bulls Head"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D6,\"'!$F6\"))","v":4},1,{"$f":"INDIRECT(CONCATENATE(\"'\",$D6,\"'!H6\"))","v":57},{"$f":"INDIRECT(CONCATENATE(\"'\",$D6,\"'!G6\"))","v":43},{"$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!B18","v":"13.06.2022"},{"$f":"B6+1","v":3},"Home",{"$f":"Template!D18","v":"Plough"},5,0,65,16,{"$f":"IF(E7=\"\",\"\",IF(E7>2,1,0))","v":1},{"$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!B19","v":"20.06.2022"},4,"Away",{"$f":"Template!C19","v":"Farmers Boy"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D8,\"'!$F8\"))","v":1},4,{"$f":"INDIRECT(CONCATENATE(\"'\",$D8,\"'!H8\"))","v":40},{"$f":"INDIRECT(CONCATENATE(\"'\",$D8,\"'!G8\"))","v":63},0,"Valid Scores entered","OK","OK","Home and Away reversed"]
[{"$f":"Template!B20","v":"27.06.2022"},5,"Home",{"$f":"Template!D20","v":"Bye"},null,"",null,null,"","","",""]
[{"$f":"Template!B21","v":"04.07.2022"},6,"Away",{"$f":"Template!C21","v":"Goat"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D10,\"'!$F10\"))","v":5},0,{"$f":"INDIRECT(CONCATENATE(\"'\",$D10,\"'!H10\"))","v":65},{"$f":"INDIRECT(CONCATENATE(\"'\",$D10,\"'!G10\"))","v":27},1,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B22","v":"11.07.2022"},7,"Home",{"$f":"Template!D22","v":"Old Bulls Head"},4,1,60,26,1,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B23","v":"18.07.2022"},8,"Away",{"$f":"Template!C23","v":"Plough"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D12,\"'!$F12\"))","v":4},1,{"$f":"INDIRECT(CONCATENATE(\"'\",$D12,\"'!H12\"))","v":59},{"$f":"INDIRECT(CONCATENATE(\"'\",$D12,\"'!G12\"))","v":38},1,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B24","v":"25.07.2022"},9,"Home",{"$f":"Template!D24","v":"Farmers Boy"},4,1,57,40,1,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B25","v":"01.08.2022"},10,"Away",{"$f":"Template!C25","v":"Bye"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D14,\"'!$F14\"))","v":""},"",{"$f":"INDIRECT(CONCATENATE(\"'\",$D14,\"'!H14\"))","v":0},{"$f":"INDIRECT(CONCATENATE(\"'\",$D14,\"'!G14\"))","v":0},"","","",""]
[{"$f":"Template!B26","v":"08.08.2022"},11,"Home","Goat",4,1,58,21,1,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B27","v":"15.08.2022"},12,"Away","Old Bulls Head",{"$f":"INDIRECT(CONCATENATE(\"'\",$D16,\"'!$F16\"))","v":5},0,{"$f":"INDIRECT(CONCATENATE(\"'\",$D16,\"'!H16\"))","v":65},{"$f":"INDIRECT(CONCATENATE(\"'\",$D16,\"'!G16\"))","v":31},1,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B28","v":"22.08.2022"},13,"Home","Plough",null,"",null,null,"","","",""]
[{"$f":"Template!B29","v":"05.09.2022"},14,"Away","Farmers Boy",{"$f":"INDIRECT(CONCATENATE(\"'\",$D18,\"'!$F18\"))","v":2},3,{"$f":"INDIRECT(CONCATENATE(\"'\",$D18,\"'!H18\"))","v":46},{"$f":"INDIRECT(CONCATENATE(\"'\",$D18,\"'!G18\"))","v":39},0,"Valid Scores entered","OK","OK","Home and Away reversed"]
[{"$f":"Template!B30","v":"12.09.2022"},15,"Home","Bye",null,"",null,null,"","","",""]
[null,null,null,null,null,null,null,null,"","","",""]
[null,null,null,null,null,null,null,null,"","","",""]
[null,null,null,null,null,null,null,null,"","","",""]
[null,null,{"$f":"CONCATENATE(\"Home Games:\",COUNTIF(C5:C22,\"Home\"),\" Away Games:\",COUNTIF(C5:C22,\"Away\"))","v":"Home Games:8 Away Games:7"}]

{"sheet":"Bye","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":"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!B16","v":"30.05.2022"},1,"Home",{"$f":"Template!F16","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!B17","v":"06.06.2022"},{"$f":"B5+1","v":2},"Away",{"$f":"Template!E17","v":"Plough"},{"$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!B18","v":"13.06.2022"},{"$f":"B6+1","v":3},"Home",{"$f":"Template!F18","v":"Farmers Boy"},null,"",null,null,"","","",""]
[{"$f":"Template!B19","v":"20.06.2022"},4,"Home",{"$f":"Template!H19","v":"Goat"},null,"",null,null,"","","",""]
[{"$f":"Template!B20","v":"27.06.2022"},5,"Away",{"$f":"Template!C20","v":"Star"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D9,\"'!$F9\"))","v":""},"",{"$f":"INDIRECT(CONCATENATE(\"'\",$D9,\"'!H9\"))","v":0},{"$f":"INDIRECT(CONCATENATE(\"'\",$D9,\"'!G9\"))","v":0},"","","",""]
[{"$f":"Template!B21","v":"04.07.2022"},6,"Away",{"$f":"Template!E21","v":"Old Bulls Head"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D10,\"'!$F10\"))","v":""},{"$f":"IF(E10=\"\",\"\",5-E10)","v":""},{"$f":"INDIRECT(CONCATENATE(\"'\",$D10,\"'!H10\"))","v":0},{"$f":"INDIRECT(CONCATENATE(\"'\",$D10,\"'!G10\"))","v":0},"","","",""]
[{"$f":"Template!B22","v":"11.07.2022"},7,"Home",{"$f":"Template!F22","v":"Plough"},null,"",null,null,"","","",""]
[{"$f":"Template!B23","v":"18.07.2022"},8,"Away",{"$f":"Template!E23","v":"Farmers Boy"},{"$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!B24","v":"25.07.2022"},9,"Away",{"$f":"Template!G24","v":"Goat"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D13,\"'!$F13\"))","v":""},"",{"$f":"INDIRECT(CONCATENATE(\"'\",$D13,\"'!H13\"))","v":0},{"$f":"INDIRECT(CONCATENATE(\"'\",$D13,\"'!G13\"))","v":0},"","","",""]
[{"$f":"Template!B25","v":"01.08.2022"},10,"Home",{"$f":"Template!D25","v":"Star"},null,"",null,null,"","","",""]
[{"$f":"Template!B26","v":"08.08.2022"},11,"Home","Old Bulls Head",null,"",null,null,"","","",""]
[{"$f":"Template!B27","v":"15.08.2022"},12,"Away","Plough",{"$f":"INDIRECT(CONCATENATE(\"'\",$D16,\"'!$F16\"))","v":""},{"$f":"IF(E16=\"\",\"\",5-E16)","v":""},{"$f":"INDIRECT(CONCATENATE(\"'\",$D16,\"'!H16\"))","v":0},{"$f":"INDIRECT(CONCATENATE(\"'\",$D16,\"'!G16\"))","v":0},"","","",""]
[{"$f":"Template!B28","v":"22.08.2022"},13,"Home","Farmers Boy",null,"",null,null,"","","",""]
[{"$f":"Template!B29","v":"05.09.2022"},14,"Home","Goat",null,"",null,null,"","","",""]
[{"$f":"Template!B30","v":"12.09.2022"},15,"Away","Star",{"$f":"INDIRECT(CONCATENATE(\"'\",$D19,\"'!$F19\"))","v":""},"",{"$f":"INDIRECT(CONCATENATE(\"'\",$D19,\"'!H19\"))","v":0},{"$f":"INDIRECT(CONCATENATE(\"'\",$D19,\"'!G19\"))","v":0},"","","",""]
[]
[]
[]
[null,null,{"$f":"CONCATENATE(\"Home Games:\",COUNTIF(C5:C22,\"Home\"),\" Away Games:\",COUNTIF(C5:C22,\"Away\"))","v":"Home Games:8 Away Games:7"}]

{"sheet":"Farmers Boy","index":3,"n_rows":23,"n_cols":13,"rows_kept":23,"cut":false,"hidden":false,"merged":[[2,10,2,11]]}
[]
["Team",{"$f":"Template!B4","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!B16","v":"30.05.2022"},1,"Home",{"$f":"Template!H16","v":"Plough"},4,{"$f":"IF(E5=\"\",\"\",5-E5)","v":1},60,42,{"$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!B17","v":"06.06.2022"},{"$f":"B5+1","v":2},"Away",{"$f":"Template!G17","v":"Goat"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D6,\"'!$F6\"))","v":4},{"$f":"IF(E6=\"\",\"\",5-E6)","v":1},{"$f":"INDIRECT(CONCATENATE(\"'\",$D6,\"'!H6\"))","v":56},{"$f":"INDIRECT(CONCATENATE(\"'\",$D6,\"'!G6\"))","v":48},{"$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!B18","v":"13.06.2022"},{"$f":"B6+1","v":3},"Away",{"$f":"Template!E18","v":"Bye"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D7,\"'!$F7\"))","v":""},{"$f":"IF(E7=\"\",\"\",5-E7)","v":""},{"$f":"INDIRECT(CONCATENATE(\"'\",$D7,\"'!H7\"))","v":0},{"$f":"INDIRECT(CONCATENATE(\"'\",$D7,\"'!G7\"))","v":0},"","","",""]
[{"$f":"Template!B19","v":"20.06.2022"},4,"Home",{"$f":"Template!D19","v":"Star"},4,1,63,40,1,"Valid Scores entered","OK","OK","Home and Away reversed"]
[{"$f":"Template!B20","v":"27.06.2022"},5,"Away",{"$f":"Template!E20","v":"Old Bulls Head"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D9,\"'!$F9\"))","v":1},4,{"$f":"INDIRECT(CONCATENATE(\"'\",$D9,\"'!H9\"))","v":45},{"$f":"INDIRECT(CONCATENATE(\"'\",$D9,\"'!G9\"))","v":59},0,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B21","v":"04.07.2022"},6,"Away",{"$f":"Template!G21","v":"Plough"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D10,\"'!$F10\"))","v":3},{"$f":"IF(E10=\"\",\"\",5-E10)","v":2},{"$f":"INDIRECT(CONCATENATE(\"'\",$D10,\"'!H10\"))","v":61},{"$f":"INDIRECT(CONCATENATE(\"'\",$D10,\"'!G10\"))","v":36},1,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B22","v":"11.07.2022"},7,"Home",{"$f":"Template!H22","v":"Goat"},4,{"$f":"IF(E11=\"\",\"\",5-E11)","v":1},64,34,{"$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!B23","v":"18.07.2022"},8,"Home",{"$f":"Template!F23","v":"Bye"},null,"",null,null,"","","",""]
[{"$f":"Template!B24","v":"25.07.2022"},9,"Away",{"$f":"Template!C24","v":"Star"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D13,\"'!$F13\"))","v":1},4,{"$f":"INDIRECT(CONCATENATE(\"'\",$D13,\"'!H13\"))","v":40},{"$f":"INDIRECT(CONCATENATE(\"'\",$D13,\"'!G13\"))","v":57},0,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B25","v":"01.08.2022"},10,"Home",{"$f":"Template!F25","v":"Old Bulls Head"},4,{"$f":"IF(E14=\"\",\"\",5-E14)","v":1},58,31,{"$f":"IF(E14=\"\",\"\",IF(E14>2,1,0))","v":1},{"$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":"Valid Scores entered"},{"$f":"IF(E14=\"\",\"\",IF((E14*13>G14),\"Error in submitting Games Won or Points Home\",\"OK\"))","v":"OK"},{"$f":"IF(E14=\"\",\"\",IF((F14*13>H14),\"Error in submitting Games Won or Points Away\",\"OK\"))","v":"OK"}]
[{"$f":"Template!B26","v":"08.08.2022"},11,"Home","Plough",4,1,64,34,1,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B27","v":"15.08.2022"},12,"Away","Goat",{"$f":"INDIRECT(CONCATENATE(\"'\",$D16,\"'!$F16\"))","v":3},2,{"$f":"INDIRECT(CONCATENATE(\"'\",$D16,\"'!H16\"))","v":50},{"$f":"INDIRECT(CONCATENATE(\"'\",$D16,\"'!G16\"))","v":57},1,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B28","v":"22.08.2022"},13,"Away","Bye",{"$f":"INDIRECT(CONCATENATE(\"'\",$D17,\"'!$F17\"))","v":""},{"$f":"IF(E17=\"\",\"\",5-E17)","v":""},{"$f":"INDIRECT(CONCATENATE(\"'\",$D17,\"'!H17\"))","v":0},{"$f":"INDIRECT(CONCATENATE(\"'\",$D17,\"'!G17\"))","v":0},"","","",""]
[{"$f":"Template!B29","v":"05.09.2022"},14,"Home","Star",3,2,39,46,1,"Valid Scores entered","OK","OK","Home and Away reversed"]
[{"$f":"Template!B30","v":"12.09.2022"},15,"Away","Old Bulls Head",{"$f":"INDIRECT(CONCATENATE(\"'\",$D19,\"'!$F19\"))","v":1},4,{"$f":"INDIRECT(CONCATENATE(\"'\",$D19,\"'!H19\"))","v":51},{"$f":"INDIRECT(CONCATENATE(\"'\",$D19,\"'!G19\"))","v":56},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:7 Away Games:8"}]

{"sheet":"Plough","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":"Plough"}]
[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!B16","v":"30.05.2022"},1,"Away",{"$f":"Template!G16","v":"Farmers Boy"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D5,\"'!$F5\"))","v":1},{"$f":"IF(E5=\"\",\"\",5-E5)","v":4},{"$f":"INDIRECT(CONCATENATE(\"'\",$D5,\"'!H5\"))","v":42},{"$f":"INDIRECT(CONCATENATE(\"'\",$D5,\"'!G5\"))","v":60},{"$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!B17","v":"06.06.2022"},{"$f":"B5+1","v":2},"Home",{"$f":"Template!F17","v":"Bye"},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!B18","v":"13.06.2022"},{"$f":"B6+1","v":3},"Away",{"$f":"Template!C18","v":"Star"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D7,\"'!$F7\"))","v":0},5,{"$f":"INDIRECT(CONCATENATE(\"'\",$D7,\"'!H7\"))","v":16},{"$f":"INDIRECT(CONCATENATE(\"'\",$D7,\"'!G7\"))","v":65},0,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B19","v":"20.06.2022"},4,"Home",{"$f":"Template!F19","v":"Old Bulls Head"},4,1,57,43,1,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B20","v":"27.06.2022"},5,"Away",{"$f":"Template!G20","v":"Goat"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D9,\"'!$F9\"))","v":3},{"$f":"IF(E9=\"\",\"\",5-E9)","v":2},{"$f":"INDIRECT(CONCATENATE(\"'\",$D9,\"'!H9\"))","v":50},{"$f":"INDIRECT(CONCATENATE(\"'\",$D9,\"'!G9\"))","v":47},1,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B21","v":"04.07.2022"},6,"Home",{"$f":"Template!H21","v":"Farmers Boy"},2,3,36,61,0,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B22","v":"11.07.2022"},7,"Away",{"$f":"Template!E22","v":"Bye"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D11,\"'!$F11\"))","v":""},"",{"$f":"INDIRECT(CONCATENATE(\"'\",$D11,\"'!H11\"))","v":0},{"$f":"INDIRECT(CONCATENATE(\"'\",$D11,\"'!G11\"))","v":0},"","","",""]
[{"$f":"Template!B23","v":"18.07.2022"},8,"Home",{"$f":"Template!D23","v":"Star"},1,4,38,59,0,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B24","v":"25.07.2022"},9,"Away",{"$f":"Template!E24","v":"Old Bulls Head"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D13,\"'!$F13\"))","v":3},{"$f":"IF(E13=\"\",\"\",5-E13)","v":2},{"$f":"INDIRECT(CONCATENATE(\"'\",$D13,\"'!H13\"))","v":42},{"$f":"INDIRECT(CONCATENATE(\"'\",$D13,\"'!G13\"))","v":52},1,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B25","v":"01.08.2022"},10,"Home",{"$f":"Template!H25","v":"Goat"},null,"",null,null,"","","",""]
[{"$f":"Template!B26","v":"08.08.2022"},11,"Away","Farmers Boy",{"$f":"INDIRECT(CONCATENATE(\"'\",$D15,\"'!$F15\"))","v":1},4,{"$f":"INDIRECT(CONCATENATE(\"'\",$D15,\"'!H15\"))","v":34},{"$f":"INDIRECT(CONCATENATE(\"'\",$D15,\"'!G15\"))","v":64},0,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B27","v":"15.08.2022"},12,"Home","Bye",null,"",null,null,"","","",""]
[{"$f":"Template!B28","v":"22.08.2022"},13,"Away","Star",{"$f":"INDIRECT(CONCATENATE(\"'\",$D17,\"'!$F17\"))","v":""},{"$f":"IF(E17=\"\",\"\",5-E17)","v":""},{"$f":"INDIRECT(CONCATENATE(\"'\",$D17,\"'!H17\"))","v":0},{"$f":"INDIRECT(CONCATENATE(\"'\",$D17,\"'!G17\"))","v":0},"","","",""]
[{"$f":"Template!B29","v":"05.09.2022"},14,"Home","Old Bulls Head",2,3,47,52,0,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B30","v":"12.09.2022"},15,"Away","Goat",{"$f":"INDIRECT(CONCATENATE(\"'\",$D19,\"'!$F19\"))","v":2},3,{"$f":"INDIRECT(CONCATENATE(\"'\",$D19,\"'!H19\"))","v":48},{"$f":"INDIRECT(CONCATENATE(\"'\",$D19,\"'!G19\"))","v":49},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:7 Away Games:8"}]

{"sheet":"Old Bulls Head","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":"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!B16","v":"30.05.2022"},1,"Away",{"$f":"Template!E16","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!B17","v":"06.06.2022"},{"$f":"B5+1","v":2},"Home",{"$f":"Template!D17","v":"Star"},1,{"$f":"IF(E6=\"\",\"\",5-E6)","v":4},43,57,{"$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!B18","v":"13.06.2022"},{"$f":"B6+1","v":3},"Away",{"$f":"Template!G18","v":"Goat"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D7,\"'!$F7\"))","v":5},0,{"$f":"INDIRECT(CONCATENATE(\"'\",$D7,\"'!H7\"))","v":65},{"$f":"INDIRECT(CONCATENATE(\"'\",$D7,\"'!G7\"))","v":37},1,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B19","v":"20.06.2022"},4,"Away",{"$f":"Template!E19","v":"Plough"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D8,\"'!$F8\"))","v":1},{"$f":"IF(E8=\"\",\"\",5-E8)","v":4},{"$f":"INDIRECT(CONCATENATE(\"'\",$D8,\"'!H8\"))","v":43},{"$f":"INDIRECT(CONCATENATE(\"'\",$D8,\"'!G8\"))","v":57},0,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B20","v":"27.06.2022"},5,"Home",{"$f":"Template!F20","v":"Farmers Boy"},4,1,59,45,1,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B21","v":"04.07.2022"},6,"Home",{"$f":"Template!F21","v":"Bye"},null,"",null,null,"","","",""]
[{"$f":"Template!B22","v":"11.07.2022"},7,"Away",{"$f":"Template!C22","v":"Star"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D11,\"'!$F11\"))","v":1},4,{"$f":"INDIRECT(CONCATENATE(\"'\",$D11,\"'!H11\"))","v":26},{"$f":"INDIRECT(CONCATENATE(\"'\",$D11,\"'!G11\"))","v":60},0,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B23","v":"18.07.2022"},8,"Home",{"$f":"Template!H23","v":"Goat"},5,0,65,25,1,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B24","v":"25.07.2022"},9,"Home",{"$f":"Template!F24","v":"Plough"},2,3,52,42,0,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B25","v":"01.08.2022"},10,"Away",{"$f":"Template!E25","v":"Farmers Boy"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D14,\"'!$F14\"))","v":1},4,{"$f":"INDIRECT(CONCATENATE(\"'\",$D14,\"'!H14\"))","v":31},{"$f":"INDIRECT(CONCATENATE(\"'\",$D14,\"'!G14\"))","v":58},0,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B26","v":"08.08.2022"},11,"Away","Bye",{"$f":"INDIRECT(CONCATENATE(\"'\",$D15,\"'!$F15\"))","v":""},{"$f":"IF(E15=\"\",\"\",5-E15)","v":""},{"$f":"INDIRECT(CONCATENATE(\"'\",$D15,\"'!H15\"))","v":0},{"$f":"INDIRECT(CONCATENATE(\"'\",$D15,\"'!G15\"))","v":0},"","","",""]
[{"$f":"Template!B27","v":"15.08.2022"},12,"Home","Star",0,5,31,65,0,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B28","v":"22.08.2022"},13,"Away","Goat",{"$f":"INDIRECT(CONCATENATE(\"'\",$D17,\"'!$F17\"))","v":4},1,{"$f":"INDIRECT(CONCATENATE(\"'\",$D17,\"'!H17\"))","v":62},{"$f":"INDIRECT(CONCATENATE(\"'\",$D17,\"'!G17\"))","v":33},1,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B29","v":"05.09.2022"},14,"Away","Plough",{"$f":"INDIRECT(CONCATENATE(\"'\",$D18,\"'!$F18\"))","v":3},{"$f":"IF(E18=\"\",\"\",5-E18)","v":2},{"$f":"INDIRECT(CONCATENATE(\"'\",$D18,\"'!H18\"))","v":52},{"$f":"INDIRECT(CONCATENATE(\"'\",$D18,\"'!G18\"))","v":47},1,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B30","v":"12.09.2022"},15,"Home","Farmers Boy",4,1,56,51,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:7 Away Games:8"}]

{"sheet":"Goat","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":"Goat"}]
[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!B16","v":"30.05.2022"},1,"Away",{"$f":"Template!C16","v":"Star"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D5,\"'!$F5\"))","v":1},{"$f":"IF(E5=\"\",\"\",5-E5)","v":4},{"$f":"INDIRECT(CONCATENATE(\"'\",$D5,\"'!H5\"))","v":31},{"$f":"INDIRECT(CONCATENATE(\"'\",$D5,\"'!G5\"))","v":63},{"$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!B17","v":"06.06.2022"},{"$f":"B5+1","v":2},"Home",{"$f":"Template!H17","v":"Farmers Boy"},1,4,48,56,{"$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!B18","v":"13.06.2022"},{"$f":"B6+1","v":3},"Home",{"$f":"Template!H18","v":"Old Bulls Head"},0,5,37,65,0,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B19","v":"20.06.2022"},4,"Away",{"$f":"Template!G19","v":"Bye"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D8,\"'!$F8\"))","v":""},{"$f":"IF(E8=\"\",\"\",5-E8)","v":""},{"$f":"INDIRECT(CONCATENATE(\"'\",$D8,\"'!H8\"))","v":0},{"$f":"INDIRECT(CONCATENATE(\"'\",$D8,\"'!G8\"))","v":0},"","","",""]
[{"$f":"Template!B20","v":"27.06.2022"},5,"Home",{"$f":"Template!H20","v":"Plough"},2,3,47,50,0,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B21","v":"04.07.2022"},6,"Home",{"$f":"Template!D21","v":"Star"},0,5,27,65,0,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B22","v":"11.07.2022"},7,"Away",{"$f":"Template!G22","v":"Farmers Boy"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D11,\"'!$F11\"))","v":1},4,{"$f":"INDIRECT(CONCATENATE(\"'\",$D11,\"'!H11\"))","v":34},{"$f":"INDIRECT(CONCATENATE(\"'\",$D11,\"'!G11\"))","v":64},0,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B23","v":"18.07.2022"},8,"Away",{"$f":"Template!G23","v":"Old Bulls Head"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D12,\"'!$F12\"))","v":0},{"$f":"IF(E12=\"\",\"\",5-E12)","v":5},{"$f":"INDIRECT(CONCATENATE(\"'\",$D12,\"'!H12\"))","v":25},{"$f":"INDIRECT(CONCATENATE(\"'\",$D12,\"'!G12\"))","v":65},0,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B24","v":"25.07.2022"},9,"Home",{"$f":"Template!H24","v":"Bye"},null,"",null,null,"","","",""]
[{"$f":"Template!B25","v":"01.08.2022"},10,"Away",{"$f":"Template!G25","v":"Plough"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D14,\"'!$F14\"))","v":""},"",{"$f":"INDIRECT(CONCATENATE(\"'\",$D14,\"'!H14\"))","v":0},{"$f":"INDIRECT(CONCATENATE(\"'\",$D14,\"'!G14\"))","v":0},"","","",""]
[{"$f":"Template!B26","v":"08.08.2022"},11,"Away","Star",{"$f":"INDIRECT(CONCATENATE(\"'\",$D15,\"'!$F15\"))","v":1},4,{"$f":"INDIRECT(CONCATENATE(\"'\",$D15,\"'!H15\"))","v":21},{"$f":"INDIRECT(CONCATENATE(\"'\",$D15,\"'!G15\"))","v":58},0,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B27","v":"15.08.2022"},12,"Home","Farmers Boy",2,3,57,50,0,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B28","v":"22.08.2022"},13,"Home","Old Bulls Head",1,4,33,62,0,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B29","v":"05.09.2022"},14,"Away","Bye",{"$f":"INDIRECT(CONCATENATE(\"'\",$D18,\"'!$F18\"))","v":""},{"$f":"IF(E18=\"\",\"\",5-E18)","v":""},{"$f":"INDIRECT(CONCATENATE(\"'\",$D18,\"'!H18\"))","v":0},{"$f":"INDIRECT(CONCATENATE(\"'\",$D18,\"'!G18\"))","v":0},"","","",""]
[{"$f":"Template!B30","v":"12.09.2022"},15,"Home","Plough",3,2,49,48,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:8 Away Games:7"}]

{"sheet":"Template","index":7,"n_rows":36,"n_cols":8,"rows_kept":36,"cut":false,"hidden":false,"merged":[[13,10,13,11],[3,5,5,7],[13,2,13,3],[13,4,13,5],[13,6,13,7],[13,8,13,9],[9,1,9,2],[9,3,9,5],[13,0,13,1],[10,1,10,2],[10,3,10,5],[9,6,9,8],[10,6,10,8]]}
["Team Number","Team Name","Buddy Team"]
[1,"Star",{"$f":"B5","v":"Plough"}]
[2,"Bye",{"$f":"B6","v":"Old Bulls Head"}]
[3,"Farmers Boy",{"$f":"B7","v":"Goat"},null,null,"The yellow box names are the controls for the spreadsheet.  The tab names should match the team names specified here exactly"]
[4,"Plough",{"$f":"B2","v":"Star"}]
[5,"Old Bulls Head",{"$f":"B3","v":"Bye"}]
[6,"Goat",{"$f":"B4","v":"Farmers Boy"}]
[]
[]
["Bank Holidays:","29 August (between weeks 13 and 14)"]
["Catchup weeks:","19 September (post season)",null,"26 September (post season"]
[]
[]
["League weeks",null,"Match 1",null,"Match 2",null,"Match 3"]
["Week","Date","Home","Away","Home","Away","Home","Away"]
[1,"30.05.2022",{"$f":"B2","v":"Star"},{"$f":"B7","v":"Goat"},{"$f":"B3","v":"Bye"},{"$f":"B6","v":"Old Bulls Head"},{"$f":"B4","v":"Farmers Boy"},{"$f":"B5","v":"Plough"}]
[2,"06.06.2022",{"$f":"B6","v":"Old Bulls Head"},{"$f":"B2","v":"Star"},{"$f":"B5","v":"Plough"},{"$f":"B3","v":"Bye"},{"$f":"B7","v":"Goat"},{"$f":"B4","v":"Farmers Boy"}]
[3,"13.06.2022",{"$f":"B2","v":"Star"},{"$f":"B5","v":"Plough"},{"$f":"B3","v":"Bye"},{"$f":"B4","v":"Farmers Boy"},{"$f":"B7","v":"Goat"},{"$f":"B6","v":"Old Bulls Head"}]
[4,"20.06.2022",{"$f":"B4","v":"Farmers Boy"},{"$f":"B2","v":"Star"},{"$f":"B5","v":"Plough"},{"$f":"B6","v":"Old Bulls Head"},{"$f":"B3","v":"Bye"},{"$f":"B7","v":"Goat"}]
[5,"27.06.2022",{"$f":"B2","v":"Star"},{"$f":"B3","v":"Bye"},{"$f":"B6","v":"Old Bulls Head"},{"$f":"B4","v":"Farmers Boy"},{"$f":"B7","v":"Goat"},{"$f":"B5","v":"Plough"}]
[6,"04.07.2022",{"$f":"B7","v":"Goat"},{"$f":"B2","v":"Star"},{"$f":"B6","v":"Old Bulls Head"},{"$f":"B3","v":"Bye"},{"$f":"B5","v":"Plough"},{"$f":"B4","v":"Farmers Boy"}]
[7,"11.07.2022",{"$f":"B2","v":"Star"},{"$f":"B6","v":"Old Bulls Head"},{"$f":"B3","v":"Bye"},{"$f":"B5","v":"Plough"},{"$f":"B4","v":"Farmers Boy"},{"$f":"B7","v":"Goat"}]
[8,"18.07.2022",{"$f":"B5","v":"Plough"},{"$f":"B2","v":"Star"},{"$f":"B4","v":"Farmers Boy"},{"$f":"B3","v":"Bye"},{"$f":"B6","v":"Old Bulls Head"},{"$f":"B7","v":"Goat"}]
[9,"25.07.2022",{"$f":"B2","v":"Star"},{"$f":"B4","v":"Farmers Boy"},{"$f":"B6","v":"Old Bulls Head"},{"$f":"B5","v":"Plough"},{"$f":"B7","v":"Goat"},{"$f":"B3","v":"Bye"}]
[10,"01.08.2022",{"$f":"B3","v":"Bye"},{"$f":"B2","v":"Star"},{"$f":"B4","v":"Farmers Boy"},{"$f":"B6","v":"Old Bulls Head"},{"$f":"B5","v":"Plough"},{"$f":"B7","v":"Goat"}]
[11,"08.08.2022","Star","Goat","Bye","Old Bulls Head","Farmers Boy","Plough"]
[12,"15.08.2022","Old Bulls Head","Star","Plough","Bye","Goat","Farmers Boy"]
[13,"22.08.2022","Star","Plough","Bye","Farmers Boy","Goat","Old Bulls Head"]
[14,"05.09.2022","Farmers Boy","Star","Plough","Old Bulls Head","Bye","Goat"]
[15,"12.09.2022","Star","Bye","Old Bulls Head","Farmers Boy","Goat","Plough"]
[16]
[17]
[18]
["CATCHUP","19.09.2022"]
["CATCHUP","26.09.2022"]
["ALL GAMES PLAYED BY","03.10.2022"]