{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Table","Star","Farmers Boy","Bye","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":12},{"$f":"SUM(INDIRECT(CONCATENATE(\"'\",A4,\"'!I:I\")))","v":11},{"$f":"SUM(INDIRECT(CONCATENATE(\"'\",A4,\"'!E:E\")))","v":50},{"$f":"SUM(INDIRECT(CONCATENATE(\"'\",A4,\"'!F:F\")))","v":10},{"$f":"SUM(INDIRECT(CONCATENATE(\"'\",A4,\"'!G:G\")))","v":721},{"$f":"SUM(INDIRECT(CONCATENATE(\"'\",A4,\"'!H:H\")))","v":424},{"$f":"F4-G4","v":297}]
[{"$f":"Template!B3","v":"Farmers Boy"},{"$f":"COUNT(INDIRECT(CONCATENATE(\"'\",A5,\"'!E:E\")))","v":12},{"$f":"SUM(INDIRECT(CONCATENATE(\"'\",A5,\"'!I:I\")))","v":7},{"$f":"SUM(INDIRECT(CONCATENATE(\"'\",A5,\"'!E:E\")))","v":35},{"$f":"SUM(INDIRECT(CONCATENATE(\"'\",A5,\"'!F:F\")))","v":25},{"$f":"SUM(INDIRECT(CONCATENATE(\"'\",A5,\"'!G:G\")))","v":614},{"$f":"SUM(INDIRECT(CONCATENATE(\"'\",A5,\"'!H:H\")))","v":540},{"$f":"F5-G5","v":74}]
[{"$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":23},{"$f":"SUM(INDIRECT(CONCATENATE(\"'\",A6,\"'!F:F\")))","v":37},{"$f":"SUM(INDIRECT(CONCATENATE(\"'\",A6,\"'!G:G\")))","v":506},{"$f":"SUM(INDIRECT(CONCATENATE(\"'\",A6,\"'!H:H\")))","v":655},{"$f":"F6-G6","v":-149}]
[{"$f":"Template!B5","v":"Plough"},{"$f":"COUNT(INDIRECT(CONCATENATE(\"'\",A7,\"'!E:E\")))","v":12},{"$f":"SUM(INDIRECT(CONCATENATE(\"'\",A7,\"'!I:I\")))","v":4},{"$f":"SUM(INDIRECT(CONCATENATE(\"'\",A7,\"'!E:E\")))","v":25},{"$f":"SUM(INDIRECT(CONCATENATE(\"'\",A7,\"'!F:F\")))","v":35},{"$f":"SUM(INDIRECT(CONCATENATE(\"'\",A7,\"'!G:G\")))","v":534},{"$f":"SUM(INDIRECT(CONCATENATE(\"'\",A7,\"'!H:H\")))","v":622},{"$f":"F7-G7","v":-88}]
[{"$f":"Template!B7","v":"Goat"},{"$f":"COUNT(INDIRECT(CONCATENATE(\"'\",A8,\"'!E:E\")))","v":12},{"$f":"SUM(INDIRECT(CONCATENATE(\"'\",A8,\"'!I:I\")))","v":2},{"$f":"SUM(INDIRECT(CONCATENATE(\"'\",A8,\"'!E:E\")))","v":17},{"$f":"SUM(INDIRECT(CONCATENATE(\"'\",A8,\"'!F:F\")))","v":43},{"$f":"SUM(INDIRECT(CONCATENATE(\"'\",A8,\"'!G:G\")))","v":538},{"$f":"SUM(INDIRECT(CONCATENATE(\"'\",A8,\"'!H:H\")))","v":672},{"$f":"F8-G8","v":-134}]
[{"$f":"Template!B4","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":12,"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":"2023-05-15"},1,"Home",{"$f":"Template!D16","v":"Goat"},5,{"$f":"IF(E5=\"\",\"\",5-E5)","v":0},65,27,{"$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":"2023-05-22"},{"$f":"B5+1","v":2},"Away",{"$f":"Template!C17","v":"Old Bulls Head"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D6,\"'!$F6\"))","v":5},0,{"$f":"INDIRECT(CONCATENATE(\"'\",$D6,\"'!H6\"))","v":65},{"$f":"INDIRECT(CONCATENATE(\"'\",$D6,\"'!G6\"))","v":20},{"$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":"2023-06-05"},{"$f":"B6+1","v":3},"Home",{"$f":"Template!D18","v":"Plough"},3,2,48,37,{"$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":"2023-06-12"},4,"Away",{"$f":"Template!C19","v":"Bye"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D8,\"'!$F8\"))","v":""},"",{"$f":"INDIRECT(CONCATENATE(\"'\",$D8,\"'!H8\"))","v":0},{"$f":"INDIRECT(CONCATENATE(\"'\",$D8,\"'!G8\"))","v":0},"","","",""]
[{"$f":"Template!B20","v":"2023-06-19"},5,"Home",{"$f":"Template!D20","v":"Farmers Boy"},5,0,65,28,1,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B21","v":"2023-06-26"},6,"Away",{"$f":"Template!C21","v":"Goat"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D10,\"'!$F10\"))","v":2},3,{"$f":"INDIRECT(CONCATENATE(\"'\",$D10,\"'!H10\"))","v":52},{"$f":"INDIRECT(CONCATENATE(\"'\",$D10,\"'!G10\"))","v":55},0,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B22","v":"2023-07-03"},7,"Home",{"$f":"Template!D22","v":"Old Bulls Head"},5,0,65,34,1,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B23","v":"2023-07-10"},8,"Away",{"$f":"Template!C23","v":"Plough"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D12,\"'!$F12\"))","v":5},0,{"$f":"INDIRECT(CONCATENATE(\"'\",$D12,\"'!H12\"))","v":65},{"$f":"INDIRECT(CONCATENATE(\"'\",$D12,\"'!G12\"))","v":30},1,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B24","v":"2023-07-24"},9,"Home",{"$f":"Template!D24","v":"Bye"},null,"",null,null,"","","",""]
[{"$f":"Template!B25","v":"2023-07-31"},10,"Away",{"$f":"Template!C25","v":"Farmers Boy"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D14,\"'!$F14\"))","v":3},2,{"$f":"INDIRECT(CONCATENATE(\"'\",$D14,\"'!H14\"))","v":51},{"$f":"INDIRECT(CONCATENATE(\"'\",$D14,\"'!G14\"))","v":46},1,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B26","v":"2023-08-07"},11,"Home",{"$f":"Template!D26","v":"Goat"},5,0,65,33,1,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B27","v":"2023-08-14"},12,"Away",{"$f":"Template!C27","v":"Old Bulls Head"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D16,\"'!$F16\"))","v":5},0,{"$f":"INDIRECT(CONCATENATE(\"'\",$D16,\"'!H16\"))","v":65},{"$f":"INDIRECT(CONCATENATE(\"'\",$D16,\"'!G16\"))","v":37},1,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B28","v":"2023-08-21"},13,"Home",{"$f":"Template!D28","v":"Plough"},3,2,52,50,1,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B29","v":"2023-09-04"},14,"Away",{"$f":"Template!C29","v":"Bye"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D18,\"'!$F18\"))","v":""},"",{"$f":"INDIRECT(CONCATENATE(\"'\",$D18,\"'!H18\"))","v":0},{"$f":"INDIRECT(CONCATENATE(\"'\",$D18,\"'!G18\"))","v":0},"","","",""]
[{"$f":"Template!B30","v":"2023-09-11"},15,"Home",{"$f":"Template!D30","v":"Farmers Boy"},4,1,63,27,1,"Valid Scores entered","OK","OK"]
[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":"Farmers Boy","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":"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":"2023-05-15"},1,"Home",{"$f":"Template!F16","v":"Old Bulls Head"},5,{"$f":"IF(E5=\"\",\"\",5-E5)","v":0},65,23,{"$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":"2023-05-22"},{"$f":"B5+1","v":2},"Away",{"$f":"Template!E17","v":"Plough"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D6,\"'!$F6\"))","v":1},4,{"$f":"INDIRECT(CONCATENATE(\"'\",$D6,\"'!H6\"))","v":45},{"$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!B18","v":"2023-06-05"},{"$f":"B6+1","v":3},"Home",{"$f":"Template!F18","v":"Bye"},null,"",null,null,"","","",""]
[{"$f":"Template!B19","v":"2023-06-12"},4,"Home",{"$f":"Template!H19","v":"Goat"},4,1,55,43,1,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B20","v":"2023-06-19"},5,"Away",{"$f":"Template!C20","v":"Star"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D9,\"'!$F9\"))","v":0},5,{"$f":"INDIRECT(CONCATENATE(\"'\",$D9,\"'!H9\"))","v":28},{"$f":"INDIRECT(CONCATENATE(\"'\",$D9,\"'!G9\"))","v":65},0,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B21","v":"2023-06-26"},6,"Away",{"$f":"Template!E21","v":"Old Bulls Head"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D10,\"'!$F10\"))","v":2},{"$f":"IF(E10=\"\",\"\",5-E10)","v":3},{"$f":"INDIRECT(CONCATENATE(\"'\",$D10,\"'!H10\"))","v":56},{"$f":"INDIRECT(CONCATENATE(\"'\",$D10,\"'!G10\"))","v":56},0,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B22","v":"2023-07-03"},7,"Home",{"$f":"Template!F22","v":"Plough"},4,1,54,32,1,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B23","v":"2023-07-10"},8,"Away",{"$f":"Template!E23","v":"Bye"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D12,\"'!$F12\"))","v":""},{"$f":"IF(E12=\"\",\"\",5-E12)","v":""},{"$f":"INDIRECT(CONCATENATE(\"'\",$D12,\"'!H12\"))","v":0},{"$f":"INDIRECT(CONCATENATE(\"'\",$D12,\"'!G12\"))","v":0},"","","",""]
[{"$f":"Template!B24","v":"2023-07-24"},9,"Away",{"$f":"Template!G24","v":"Goat"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D13,\"'!$F13\"))","v":4},1,{"$f":"INDIRECT(CONCATENATE(\"'\",$D13,\"'!H13\"))","v":57},{"$f":"INDIRECT(CONCATENATE(\"'\",$D13,\"'!G13\"))","v":37},1,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B25","v":"2023-07-31"},10,"Home",{"$f":"Template!D25","v":"Star"},2,3,46,51,0,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B26","v":"2023-08-07"},11,"Home",{"$f":"Template!F26","v":"Old Bulls Head"},4,1,62,30,1,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B27","v":"2023-08-14"},12,"Away",{"$f":"Template!E27","v":"Plough"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D16,\"'!$F16\"))","v":4},{"$f":"IF(E16=\"\",\"\",5-E16)","v":1},{"$f":"INDIRECT(CONCATENATE(\"'\",$D16,\"'!H16\"))","v":57},{"$f":"INDIRECT(CONCATENATE(\"'\",$D16,\"'!G16\"))","v":34},1,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B28","v":"2023-08-21"},13,"Home",{"$f":"Template!F28","v":"Bye"},null,"",null,null,"","","",""]
[{"$f":"Template!B29","v":"2023-09-04"},14,"Home",{"$f":"Template!H29","v":"Goat"},4,1,62,43,1,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B30","v":"2023-09-11"},15,"Away",{"$f":"Template!C30","v":"Star"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D19,\"'!$F19\"))","v":1},4,{"$f":"INDIRECT(CONCATENATE(\"'\",$D19,\"'!H19\"))","v":27},{"$f":"INDIRECT(CONCATENATE(\"'\",$D19,\"'!G19\"))","v":63},0,"Valid Scores entered","OK","OK"]
[]
[]
[]
[null,null,{"$f":"CONCATENATE(\"Home Games:\",COUNTIF(C5:C22,\"Home\"),\" Away Games:\",COUNTIF(C5:C22,\"Away\"))","v":"Home Games:8 Away Games:7"}]

{"sheet":"Bye","index":3,"n_rows":23,"n_cols":12,"rows_kept":23,"cut":false,"hidden":false,"merged":[[2,10,2,11]]}
[]
["Team",{"$f":"Template!B4","v":"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":"2023-05-15"},1,"Home",{"$f":"Template!H16","v":"Plough"},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":"2023-05-22"},{"$f":"B5+1","v":2},"Away",{"$f":"Template!G17","v":"Goat"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D6,\"'!$F6\"))","v":""},{"$f":"IF(E6=\"\",\"\",5-E6)","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":"2023-06-05"},{"$f":"B6+1","v":3},"Away",{"$f":"Template!E18","v":"Farmers Boy"},{"$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":"2023-06-12"},4,"Home",{"$f":"Template!D19","v":"Star"},null,"",null,null,"","","",""]
[{"$f":"Template!B20","v":"2023-06-19"},5,"Away",{"$f":"Template!E20","v":"Old Bulls Head"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D9,\"'!$F9\"))","v":""},"",{"$f":"INDIRECT(CONCATENATE(\"'\",$D9,\"'!H9\"))","v":0},{"$f":"INDIRECT(CONCATENATE(\"'\",$D9,\"'!G9\"))","v":0},"","","",""]
[{"$f":"Template!B21","v":"2023-06-26"},6,"Away",{"$f":"Template!G21","v":"Plough"},{"$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":"2023-07-03"},7,"Home",{"$f":"Template!H22","v":"Goat"},null,{"$f":"IF(E11=\"\",\"\",5-E11)","v":""},null,null,{"$f":"IF(E11=\"\",\"\",IF(E11>2,1,0))","v":""},{"$f":"IF(E11=\"\",\"\",IF(OR(E11<0,E11>5,G11<0,G11>(5*13),H11<0,H11>(5*13)),\"Number out of range error\",\"Valid Scores entered\"))","v":""},{"$f":"IF(E11=\"\",\"\",IF((E11*13>G11),\"Error in submitting Games Won or Points Home\",\"OK\"))","v":""},{"$f":"IF(E11=\"\",\"\",IF((F11*13>H11),\"Error in submitting Games Won or Points Away\",\"OK\"))","v":""}]
[{"$f":"Template!B23","v":"2023-07-10"},8,"Home",{"$f":"Template!F23","v":"Farmers Boy"},null,"",null,null,"","","",""]
[{"$f":"Template!B24","v":"2023-07-24"},9,"Away",{"$f":"Template!C24","v":"Star"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D13,\"'!$F13\"))","v":""},"",{"$f":"INDIRECT(CONCATENATE(\"'\",$D13,\"'!H13\"))","v":0},{"$f":"INDIRECT(CONCATENATE(\"'\",$D13,\"'!G13\"))","v":0},"","","",""]
[{"$f":"Template!B25","v":"2023-07-31"},10,"Home",{"$f":"Template!F25","v":"Old Bulls Head"},null,{"$f":"IF(E14=\"\",\"\",5-E14)","v":""},null,null,{"$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!B26","v":"2023-08-07"},11,"Home",{"$f":"Template!H26","v":"Plough"},null,"",null,null,"","","",""]
[{"$f":"Template!B27","v":"2023-08-14"},12,"Away",{"$f":"Template!G27","v":"Goat"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D16,\"'!$F16\"))","v":""},"",{"$f":"INDIRECT(CONCATENATE(\"'\",$D16,\"'!H16\"))","v":0},{"$f":"INDIRECT(CONCATENATE(\"'\",$D16,\"'!G16\"))","v":0},"","","",""]
[{"$f":"Template!B28","v":"2023-08-21"},13,"Away",{"$f":"Template!E28","v":"Farmers Boy"},{"$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":"2023-09-04"},14,"Home",{"$f":"Template!D29","v":"Star"},null,"",null,null,"","","",""]
[{"$f":"Template!B30","v":"2023-09-11"},15,"Away",{"$f":"Template!E30","v":"Old Bulls Head"},{"$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: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":"2023-05-15"},1,"Away",{"$f":"Template!G16","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":"2023-05-22"},{"$f":"B5+1","v":2},"Home",{"$f":"Template!F17","v":"Farmers Boy"},4,{"$f":"IF(E6=\"\",\"\",5-E6)","v":1},63,45,{"$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":"2023-06-05"},{"$f":"B6+1","v":3},"Away",{"$f":"Template!C18","v":"Star"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D7,\"'!$F7\"))","v":2},3,{"$f":"INDIRECT(CONCATENATE(\"'\",$D7,\"'!H7\"))","v":37},{"$f":"INDIRECT(CONCATENATE(\"'\",$D7,\"'!G7\"))","v":48},0,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B19","v":"2023-06-12"},4,"Home",{"$f":"Template!F19","v":"Old Bulls Head"},3,2,53,39,1,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B20","v":"2023-06-19"},5,"Away",{"$f":"Template!G20","v":"Goat"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D9,\"'!$F9\"))","v":4},{"$f":"IF(E9=\"\",\"\",5-E9)","v":1},{"$f":"INDIRECT(CONCATENATE(\"'\",$D9,\"'!H9\"))","v":63},{"$f":"INDIRECT(CONCATENATE(\"'\",$D9,\"'!G9\"))","v":53},1,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B21","v":"2023-06-26"},6,"Home",{"$f":"Template!H21","v":"Bye"},null,"",null,null,"","","",""]
[{"$f":"Template!B22","v":"2023-07-03"},7,"Away",{"$f":"Template!E22","v":"Farmers Boy"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D11,\"'!$F11\"))","v":1},4,{"$f":"INDIRECT(CONCATENATE(\"'\",$D11,\"'!H11\"))","v":32},{"$f":"INDIRECT(CONCATENATE(\"'\",$D11,\"'!G11\"))","v":54},0,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B23","v":"2023-07-10"},8,"Home",{"$f":"Template!D23","v":"Star"},0,5,30,65,0,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B24","v":"2023-07-24"},9,"Away",{"$f":"Template!E24","v":"Old Bulls Head"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D13,\"'!$F13\"))","v":2},{"$f":"IF(E13=\"\",\"\",5-E13)","v":3},{"$f":"INDIRECT(CONCATENATE(\"'\",$D13,\"'!H13\"))","v":44},{"$f":"INDIRECT(CONCATENATE(\"'\",$D13,\"'!G13\"))","v":53},0,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B25","v":"2023-07-31"},10,"Home",{"$f":"Template!H25","v":"Goat"},3,2,53,44,1,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B26","v":"2023-08-07"},11,"Away",{"$f":"Template!G26","v":"Bye"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D15,\"'!$F15\"))","v":""},"",{"$f":"INDIRECT(CONCATENATE(\"'\",$D15,\"'!H15\"))","v":0},{"$f":"INDIRECT(CONCATENATE(\"'\",$D15,\"'!G15\"))","v":0},"","","",""]
[{"$f":"Template!B27","v":"2023-08-14"},12,"Home",{"$f":"Template!F27","v":"Farmers Boy"},1,4,34,57,0,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B28","v":"2023-08-21"},13,"Away",{"$f":"Template!C28","v":"Star"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D17,\"'!$F17\"))","v":2},{"$f":"IF(E17=\"\",\"\",5-E17)","v":3},{"$f":"INDIRECT(CONCATENATE(\"'\",$D17,\"'!H17\"))","v":50},{"$f":"INDIRECT(CONCATENATE(\"'\",$D17,\"'!G17\"))","v":52},0,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B29","v":"2023-09-04"},14,"Home",{"$f":"Template!F29","v":"Old Bulls Head"},1,4,33,56,0,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B30","v":"2023-09-11"},15,"Away",{"$f":"Template!G30","v":"Goat"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D19,\"'!$F19\"))","v":2},3,{"$f":"INDIRECT(CONCATENATE(\"'\",$D19,\"'!H19\"))","v":42},{"$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":"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":"2023-05-15"},1,"Away",{"$f":"Template!E16","v":"Farmers Boy"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D5,\"'!$F5\"))","v":0},{"$f":"IF(E5=\"\",\"\",5-E5)","v":5},{"$f":"INDIRECT(CONCATENATE(\"'\",$D5,\"'!H5\"))","v":23},{"$f":"INDIRECT(CONCATENATE(\"'\",$D5,\"'!G5\"))","v":65},{"$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":"2023-05-22"},{"$f":"B5+1","v":2},"Home",{"$f":"Template!D17","v":"Star"},0,{"$f":"IF(E6=\"\",\"\",5-E6)","v":5},20,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!B18","v":"2023-06-05"},{"$f":"B6+1","v":3},"Away",{"$f":"Template!G18","v":"Goat"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D7,\"'!$F7\"))","v":3},2,{"$f":"INDIRECT(CONCATENATE(\"'\",$D7,\"'!H7\"))","v":53},{"$f":"INDIRECT(CONCATENATE(\"'\",$D7,\"'!G7\"))","v":54},1,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B19","v":"2023-06-12"},4,"Away",{"$f":"Template!E19","v":"Plough"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D8,\"'!$F8\"))","v":2},{"$f":"IF(E8=\"\",\"\",5-E8)","v":3},{"$f":"INDIRECT(CONCATENATE(\"'\",$D8,\"'!H8\"))","v":39},{"$f":"INDIRECT(CONCATENATE(\"'\",$D8,\"'!G8\"))","v":53},0,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B20","v":"2023-06-19"},5,"Home",{"$f":"Template!F20","v":"Bye"},null,"",null,null,"","","",""]
[{"$f":"Template!B21","v":"2023-06-26"},6,"Home",{"$f":"Template!F21","v":"Farmers Boy"},3,2,56,56,1,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B22","v":"2023-07-03"},7,"Away",{"$f":"Template!C22","v":"Star"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D11,\"'!$F11\"))","v":0},5,{"$f":"INDIRECT(CONCATENATE(\"'\",$D11,\"'!H11\"))","v":34},{"$f":"INDIRECT(CONCATENATE(\"'\",$D11,\"'!G11\"))","v":65},0,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B23","v":"2023-07-10"},8,"Home",{"$f":"Template!H23","v":"Goat"},4,1,60,47,1,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B24","v":"2023-07-24"},9,"Home",{"$f":"Template!F24","v":"Plough"},3,2,53,44,1,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B25","v":"2023-07-31"},10,"Away",{"$f":"Template!E25","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":"2023-08-07"},11,"Away",{"$f":"Template!E26","v":"Farmers Boy"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D15,\"'!$F15\"))","v":1},{"$f":"IF(E15=\"\",\"\",5-E15)","v":4},{"$f":"INDIRECT(CONCATENATE(\"'\",$D15,\"'!H15\"))","v":30},{"$f":"INDIRECT(CONCATENATE(\"'\",$D15,\"'!G15\"))","v":62},0,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B27","v":"2023-08-14"},12,"Home",{"$f":"Template!D27","v":"Star"},0,5,37,65,0,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B28","v":"2023-08-21"},13,"Away",{"$f":"Template!G28","v":"Goat"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D17,\"'!$F17\"))","v":3},2,{"$f":"INDIRECT(CONCATENATE(\"'\",$D17,\"'!H17\"))","v":45},{"$f":"INDIRECT(CONCATENATE(\"'\",$D17,\"'!G17\"))","v":46},1,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B29","v":"2023-09-04"},14,"Away",{"$f":"Template!E29","v":"Plough"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D18,\"'!$F18\"))","v":4},{"$f":"IF(E18=\"\",\"\",5-E18)","v":1},{"$f":"INDIRECT(CONCATENATE(\"'\",$D18,\"'!H18\"))","v":56},{"$f":"INDIRECT(CONCATENATE(\"'\",$D18,\"'!G18\"))","v":33},1,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B30","v":"2023-09-11"},15,"Home",{"$f":"Template!F30","v":"Bye"},null,"",null,null,"","","",""]
[]
[]
[]
[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":"2023-05-15"},1,"Away",{"$f":"Template!C16","v":"Star"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D5,\"'!$F5\"))","v":0},{"$f":"IF(E5=\"\",\"\",5-E5)","v":5},{"$f":"INDIRECT(CONCATENATE(\"'\",$D5,\"'!H5\"))","v":27},{"$f":"INDIRECT(CONCATENATE(\"'\",$D5,\"'!G5\"))","v":65},{"$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":"2023-05-22"},{"$f":"B5+1","v":2},"Home",{"$f":"Template!H17","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!B18","v":"2023-06-05"},{"$f":"B6+1","v":3},"Home",{"$f":"Template!H18","v":"Old Bulls Head"},2,3,54,53,0,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B19","v":"2023-06-12"},4,"Away",{"$f":"Template!G19","v":"Farmers Boy"},{"$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":55},0,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B20","v":"2023-06-19"},5,"Home",{"$f":"Template!H20","v":"Plough"},1,4,53,63,0,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B21","v":"2023-06-26"},6,"Home",{"$f":"Template!D21","v":"Star"},3,2,55,52,1,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B22","v":"2023-07-03"},7,"Away",{"$f":"Template!G22","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":"2023-07-10"},8,"Away",{"$f":"Template!G23","v":"Old Bulls Head"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D12,\"'!$F12\"))","v":1},{"$f":"IF(E12=\"\",\"\",5-E12)","v":4},{"$f":"INDIRECT(CONCATENATE(\"'\",$D12,\"'!H12\"))","v":47},{"$f":"INDIRECT(CONCATENATE(\"'\",$D12,\"'!G12\"))","v":60},0,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B24","v":"2023-07-24"},9,"Home",{"$f":"Template!H24","v":"Farmers Boy"},1,4,37,57,0,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B25","v":"2023-07-31"},10,"Away",{"$f":"Template!G25","v":"Plough"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D14,\"'!$F14\"))","v":2},3,{"$f":"INDIRECT(CONCATENATE(\"'\",$D14,\"'!H14\"))","v":44},{"$f":"INDIRECT(CONCATENATE(\"'\",$D14,\"'!G14\"))","v":53},0,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B26","v":"2023-08-07"},11,"Away",{"$f":"Template!C26","v":"Star"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D15,\"'!$F15\"))","v":0},5,{"$f":"INDIRECT(CONCATENATE(\"'\",$D15,\"'!H15\"))","v":33},{"$f":"INDIRECT(CONCATENATE(\"'\",$D15,\"'!G15\"))","v":65},0,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B27","v":"2023-08-14"},12,"Home",{"$f":"Template!H27","v":"Bye"},null,"",null,null,"","","",""]
[{"$f":"Template!B28","v":"2023-08-21"},13,"Home",{"$f":"Template!H28","v":"Old Bulls Head"},2,3,46,45,0,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B29","v":"2023-09-04"},14,"Away",{"$f":"Template!G29","v":"Farmers Boy"},{"$f":"INDIRECT(CONCATENATE(\"'\",$D18,\"'!$F18\"))","v":1},{"$f":"IF(E18=\"\",\"\",5-E18)","v":4},{"$f":"INDIRECT(CONCATENATE(\"'\",$D18,\"'!H18\"))","v":43},{"$f":"INDIRECT(CONCATENATE(\"'\",$D18,\"'!G18\"))","v":62},0,"Valid Scores entered","OK","OK"]
[{"$f":"Template!B30","v":"2023-09-11"},15,"Home",{"$f":"Template!H30","v":"Plough"},3,2,56,42,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,"Farmers Boy",{"$f":"B6","v":"Old Bulls Head"}]
[3,"Bye",{"$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":"Farmers Boy"}]
[6,"Goat",{"$f":"B4","v":"Bye"}]
[]
[]
["Bank Holidays:","29 May (between weeks 2 and 3)",null,"28 August (between weeks 13 and 14)"]
["Catchup weeks:","17 July (between weeks 8 and 9)",null,"18 September (post season)",null,null,"25 September (post season)"]
[]
[]
["League weeks",null,"Match 1",null,"Match 2",null,"Match 3"]
["Week","Date","Home","Away","Home","Away","Home","Away"]
[1,"2023-05-15",{"$f":"B2","v":"Star"},{"$f":"B7","v":"Goat"},{"$f":"B3","v":"Farmers Boy"},{"$f":"B6","v":"Old Bulls Head"},{"$f":"B4","v":"Bye"},{"$f":"B5","v":"Plough"}]
[2,"2023-05-22",{"$f":"B6","v":"Old Bulls Head"},{"$f":"B2","v":"Star"},{"$f":"B5","v":"Plough"},{"$f":"B3","v":"Farmers Boy"},{"$f":"B7","v":"Goat"},{"$f":"B4","v":"Bye"}]
[3,"2023-06-05",{"$f":"B2","v":"Star"},{"$f":"B5","v":"Plough"},{"$f":"B3","v":"Farmers Boy"},{"$f":"B4","v":"Bye"},{"$f":"B7","v":"Goat"},{"$f":"B6","v":"Old Bulls Head"}]
[4,"2023-06-12",{"$f":"B4","v":"Bye"},{"$f":"B2","v":"Star"},{"$f":"B5","v":"Plough"},{"$f":"B6","v":"Old Bulls Head"},{"$f":"B3","v":"Farmers Boy"},{"$f":"B7","v":"Goat"}]
[5,"2023-06-19",{"$f":"B2","v":"Star"},{"$f":"B3","v":"Farmers Boy"},{"$f":"B6","v":"Old Bulls Head"},{"$f":"B4","v":"Bye"},{"$f":"B7","v":"Goat"},{"$f":"B5","v":"Plough"}]
[6,"2023-06-26",{"$f":"B7","v":"Goat"},{"$f":"B2","v":"Star"},{"$f":"B6","v":"Old Bulls Head"},{"$f":"B3","v":"Farmers Boy"},{"$f":"B5","v":"Plough"},{"$f":"B4","v":"Bye"}]
[7,"2023-07-03",{"$f":"B2","v":"Star"},{"$f":"B6","v":"Old Bulls Head"},{"$f":"B3","v":"Farmers Boy"},{"$f":"B5","v":"Plough"},{"$f":"B4","v":"Bye"},{"$f":"B7","v":"Goat"}]
[8,"2023-07-10",{"$f":"B5","v":"Plough"},{"$f":"B2","v":"Star"},{"$f":"B4","v":"Bye"},{"$f":"B3","v":"Farmers Boy"},{"$f":"B6","v":"Old Bulls Head"},{"$f":"B7","v":"Goat"}]
[9,"2023-07-24",{"$f":"B2","v":"Star"},{"$f":"B4","v":"Bye"},{"$f":"B6","v":"Old Bulls Head"},{"$f":"B5","v":"Plough"},{"$f":"B7","v":"Goat"},{"$f":"B3","v":"Farmers Boy"}]
[10,"2023-07-31",{"$f":"B3","v":"Farmers Boy"},{"$f":"B2","v":"Star"},{"$f":"B4","v":"Bye"},{"$f":"B6","v":"Old Bulls Head"},{"$f":"B5","v":"Plough"},{"$f":"B7","v":"Goat"}]
[11,"2023-08-07","Star","Goat","Farmers Boy","Old Bulls Head","Bye","Plough"]
[12,"2023-08-14","Old Bulls Head","Star","Plough","Farmers Boy","Goat","Bye"]
[13,"2023-08-21","Star","Plough","Farmers Boy","Bye","Goat","Old Bulls Head"]
[14,"2023-09-04","Bye","Star","Plough","Old Bulls Head","Farmers Boy","Goat"]
[15,"2023-09-11","Star","Farmers Boy","Old Bulls Head","Bye","Goat","Plough"]
[16]
[17]
[18]
["CATCHUP","2023-09-18"]
["CATCHUP","2023-09-25"]
["ALL GAMES PLAYED BY","2023-10-02"]