{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Table","Axemen","Old Bulls Head","Farmers Boy","Brown Bear","Drifters","Station","Cricketers"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":2,"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":10,"n_cols":8,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Matches Played","Matches Won","Games Won","Games Lost","Points Won","Points Lost","Points Diff"]
["Cricketers",{"$f":"COUNT(Cricketers!E:E)","v":18},{"$f":"SUM(Cricketers!I:I)","v":15},{"$f":"SUM(Cricketers!E:E)","v":63},{"$f":"SUM(Cricketers!F:F)","v":21},{"$f":"SUM(Cricketers!G:G)","v":992},{"$f":"SUM(Cricketers!H:H)","v":549},{"$f":"F4-G4","v":443}]
["Station",{"$f":"COUNT(Station!E:E)","v":18},{"$f":"SUM(Station!I:I)","v":13},{"$f":"SUM(Station!E:E)","v":57},{"$f":"SUM(Station!F:F)","v":33},{"$f":"SUM(Station!G:G)","v":995},{"$f":"SUM(Station!H:H)","v":794},{"$f":"F5-G5","v":201}]
["Farmers Boy",{"$f":"COUNT('Farmers Boy'!E:E)","v":18},{"$f":"SUM('Farmers Boy'!I:I)","v":10},{"$f":"SUM('Farmers Boy'!E:E)","v":47},{"$f":"SUM('Farmers Boy'!F:F)","v":43},{"$f":"SUM('Farmers Boy'!G:G)","v":909},{"$f":"SUM('Farmers Boy'!H:H)","v":883},{"$f":"F6-G6","v":26}]
["Drifters",{"$f":"COUNT(Drifters!E:E)","v":18},{"$f":"SUM(Drifters!I:I)","v":9},{"$f":"SUM(Drifters!E:E)","v":42},{"$f":"SUM(Drifters!F:F)","v":46},{"$f":"SUM(Drifters!G:G)","v":828},{"$f":"SUM(Drifters!H:H)","v":880},{"$f":"F7-G7","v":-52}]
["Old Bulls Head",{"$f":"COUNT('Old Bulls Head'!E:E)","v":18},{"$f":"SUM('Old Bulls Head'!I:I)","v":8},{"$f":"SUM('Old Bulls Head'!E:E)","v":38},{"$f":"SUM('Old Bulls Head'!F:F)","v":50},{"$f":"SUM('Old Bulls Head'!G:G)","v":811},{"$f":"SUM('Old Bulls Head'!H:H)","v":942},{"$f":"F8-G8","v":-131}]
["Axemen",{"$f":"COUNT(Axemen!E:E)","v":18},{"$f":"SUM(Axemen!I:I)","v":7},{"$f":"SUM(Axemen!E:E)","v":41},{"$f":"SUM(Axemen!F:F)","v":49},{"$f":"SUM(Axemen!G:G)","v":854},{"$f":"SUM(Axemen!H:H)","v":903},{"$f":"F9-G9","v":-49}]
["Brown Bear",{"$f":"COUNT('Brown Bear'!E:E)","v":18},{"$f":"SUM('Brown Bear'!I:I)","v":1},{"$f":"SUM('Brown Bear'!E:E)","v":21},{"$f":"SUM('Brown Bear'!F:F)","v":67},{"$f":"SUM('Brown Bear'!G:G)","v":604},{"$f":"SUM('Brown Bear'!H:H)","v":1042},{"$f":"F10-G10","v":-438}]

{"sheet":"Axemen","index":1,"n_rows":28,"n_cols":12,"rows_kept":28,"cut":false,"hidden":false,"merged":[[2,10,2,11]]}
[]
["Team","Axemen"]
[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"]
["20.04.2014",1,"Bye",null,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":""}]
["27.04.2015",{"$f":"B5+1","v":2},"Away","Old Bulls Head",{"$f":"'Old Bulls Head'!F6","v":2},3,{"$f":"'Old Bulls Head'!H6","v":58},{"$f":"'Old Bulls Head'!G6","v":59},{"$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"}]
["04.05.2015",{"$f":"B6+1","v":3},"Bank Hol",null,null,"",null,null,{"$f":"IF(E7=\"\",\"\",IF(E7>2,1,0))","v":""},{"$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":""},{"$f":"IF(E7=\"\",\"\",IF((E7*13>G7),\"Error in submitting Games Won or Points Home\",\"OK\"))","v":""},""]
["11.05.2015",4,"Home","Farmers Boy",4,1,59,34,1,"Valid Scores entered","OK","OK"]
["18.05.2015",5,"Away","Brown Bear",{"$f":"'Brown Bear'!F9","v":5},0,{"$f":"'Brown Bear'!H9","v":65},{"$f":"'Brown Bear'!G9","v":29},1,"Valid Scores entered","OK","OK"]
["25.05.2015",6,"Bank Hol",null,null,"",null,null,"","","",""]
["01.06.2015",7,"Home","Drifters",2,3,41,56,0,"Valid Scores entered","OK","OK"]
["08.06.2015",8,"Away","Station Masters",{"$f":"Station!F12","v":1},4,{"$f":"Station!H12","v":29},{"$f":"Station!G12","v":58},0,"Valid Scores entered","OK","OK"]
["15.06.2015",9,"Home","Cricketers",1,4,32,54,0,"Valid Scores entered","OK","OK"]
["22.06.2015",10,"Bye",null,null,"",null,null,"","","",""]
["29.06.2015",11,"Home","Old Bulls Head",2,3,40,49,0,"Valid Scores entered","OK","OK"]
["06.07.2015",12,"Away","Farmers Boy",{"$f":"'Farmers Boy'!F16","v":1},4,{"$f":"'Farmers Boy'!H16","v":37},{"$f":"'Farmers Boy'!G16","v":62},0,"Valid Scores entered","OK","OK"]
["13.07.2015",13,"Home","Brown Bear",3,2,52,44,1,"Valid Scores entered","OK","OK"]
["20.07.2015",14,"Away","Drifters",{"$f":"Drifters!F18","v":1},4,{"$f":"Drifters!H18","v":44},{"$f":"Drifters!G18","v":59},0,"Valid Scores entered","OK","OK"]
["27.07.2015",15,"Home","Station Masters",4,1,60,46,1,"Valid Scores entered","OK","OK"]
["03.08.2015",16,"Away","Cricketers",{"$f":"Cricketers!F20","v":1},4,{"$f":"Cricketers!H20","v":43},{"$f":"Cricketers!G20","v":52},0,"Valid Scores entered","OK","OK"]
["10.08.2015",17,"Bye",null,null,"",null,null,"","","",""]
["17.08.2015",18,"Away","Old Bulls Head",{"$f":"'Old Bulls Head'!F22","v":1},4,{"$f":"'Old Bulls Head'!H22","v":48},{"$f":"'Old Bulls Head'!G22","v":61},0,"Valid Scores entered","OK","OK"]
["24.08.2015",19,"Home","Farmers Boy",2,3,36,52,0,"Valid Scores entered","OK","OK"]
["31.08.2015",20,"Bank Hol",null,null,"",null,null,"","","",""]
["07.09.2015",21,"Away","Brown Bear",{"$f":"'Brown Bear'!F25","v":3},2,{"$f":"'Brown Bear'!H25","v":57},{"$f":"'Brown Bear'!G25","v":46},1,"Valid Scores entered","OK","OK"]
["14.09.2015",22,"Home","Drifters",4,1,64,35,1,"Valid Scores entered","OK","OK"]
["21.09.2015",23,"Away","Station Masters",{"$f":"Station!F27","v":3},2,{"$f":"Station!H27","v":48},{"$f":"Station!G27","v":49},1,"Valid Scores entered","OK","OK"]
["28.09.2015",24,"Home","Cricketers",1,4,41,58,0,"Valid Scores entered","OK","OK"]

{"sheet":"Old Bulls Head","index":2,"n_rows":28,"n_cols":12,"rows_kept":28,"cut":false,"hidden":false,"merged":[[2,10,2,11]]}
[]
["Team","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"]
["20.04.2014",1,"Away","Cricketers",{"$f":"Cricketers!F5","v":0},{"$f":"IF(E5=\"\",\"\",5-E5)","v":5},{"$f":"Cricketers!H5","v":17},{"$f":"Cricketers!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"}]
["27.04.2015",{"$f":"B5+1","v":2},"Home","Axemen",3,2,59,58,{"$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"}]
["04.05.2015",{"$f":"B6+1","v":3},"Bank Hol",null,null,"",null,null,"","","",""]
["11.05.2015",4,"Bye",null,null,"",null,null,"","","",""]
["18.05.2015",5,"Away","Farmers Boy",{"$f":"'Farmers Boy'!F9","v":2},3,{"$f":"'Farmers Boy'!H9","v":50},{"$f":"'Farmers Boy'!G9","v":55},0,"Valid Scores entered","OK","OK"]
["25.05.2015",6,"Bank Hol",null,null,"",null,null,"","","",""]
["01.06.2015",7,"Home","Brown Bear",4,1,60,44,1,"Valid Scores entered","OK","OK"]
["08.06.2015",8,"Away","Drifters",{"$f":"Drifters!F12","v":1},4,{"$f":"Drifters!H12","v":44},{"$f":"Drifters!G12","v":64},0,"Valid Scores entered","OK","OK"]
["15.06.2015",9,"Home","Station",2,3,45,53,0,"Valid Scores entered","OK","OK"]
["22.06.2015",10,"Home","Cricketers",1,4,30,55,0,"Valid Scores entered","OK","OK"]
["29.06.2015",11,"Away","Axemen",{"$f":"Axemen!F15","v":3},2,{"$f":"Axemen!H15","v":49},{"$f":"Axemen!G15","v":40},1,"Valid Scores entered","OK","OK"]
["06.07.2015",12,"Bye",null,null,"",null,null,"","","",""]
["13.07.2015",13,"Home","Farmers Boy",2,3,58,49,0,"Valid Scores entered","OK","OK"]
["20.07.2015",14,"Away","Brown Bear",{"$f":"'Brown Bear'!F18","v":3},2,{"$f":"'Brown Bear'!H18","v":61},{"$f":"'Brown Bear'!G18","v":43},1,"Valid Scores entered","OK","OK"]
["27.07.2015",15,"Home","Drifters",3,2,61,42,1,"Valid Scores entered","OK","OK"]
["03.08.2015",16,"Away","Station",{"$f":"Station!F20","v":1},4,{"$f":"Station!H20","v":39},{"$f":"Station!G20","v":61},0,"Valid Scores entered","OK","OK"]
["10.08.2015",17,"Away","Cricketers",{"$f":"Cricketers!F21","v":0},3,{"$f":"Cricketers!H21","v":0},{"$f":"Cricketers!G21","v":45},0,"Valid Scores entered","OK","OK"]
["17.08.2015",18,"Home","Axemen",4,1,61,48,1,"Valid Scores entered","OK","OK"]
["24.08.2015",19,"Bye",null,null,"",null,null,"","","",""]
["31.08.2015",20,"Bank Hol",null,null,"",null,null,"","","",""]
["07.09.2015",21,"Away","Farmers Boy",{"$f":"'Farmers Boy'!F25","v":0},5,{"$f":"'Farmers Boy'!H25","v":31},{"$f":"'Farmers Boy'!G25","v":65},0,"Valid Scores entered","OK","OK"]
["14.09.2015",22,"Home","Brown Bear",4,1,56,45,1,"Valid Scores entered","OK","OK"]
["21.09.2015",23,"Away","Drifters",{"$f":"Drifters!F27","v":1},4,{"$f":"Drifters!H27","v":33},{"$f":"Drifters!G27","v":59},0,"Valid Scores entered","OK","OK"]
["28.09.2015",24,"Home","Station",4,1,57,51,1,"Valid Scores entered","OK","OK"]

{"sheet":"Farmers Boy","index":3,"n_rows":28,"n_cols":12,"rows_kept":28,"cut":false,"hidden":false,"merged":[[2,10,2,11]]}
[]
["Team","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"]
["20.04.2014",1,"Away","Station Masters",{"$f":"Station!F5","v":2},{"$f":"IF(E5=\"\",\"\",5-E5)","v":3},{"$f":"Station!H5","v":43},{"$f":"Station!G5","v":61},{"$f":"IF(E5=\"\",\"\",IF(E5>2,1,0))","v":0},{"$f":"IF(E5=\"\",\"\",IF(OR(E5<0,E5>5,G5<0,G5>(5*13),H5<0,H5>(5*13)),\"Number out of range error\",\"Valid Scores entered\"))","v":"Valid Scores entered"},{"$f":"IF(E5=\"\",\"\",IF((E5*13>G5),\"Error in submitting Games Won or Points Home\",\"OK\"))","v":"OK"},{"$f":"IF(E5=\"\",\"\",IF((F5*13>H5),\"Error in submitting Games Won or Points Away\",\"OK\"))","v":"OK"}]
["27.04.2015",{"$f":"B5+1","v":2},"Home","Cricketers",3,2,46,52,{"$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"}]
["04.05.2015",{"$f":"B6+1","v":3},"Bank Hol",null,null,"",null,null,"","","",""]
["11.05.2015",4,"Away","Axemen",{"$f":"Axemen!F8","v":1},4,{"$f":"Axemen!H8","v":34},{"$f":"Axemen!G8","v":59},0,"Valid Scores entered","OK","OK"]
["18.05.2015",5,"Home","Old Bulls Head",3,2,55,50,1,"Valid Scores entered","OK","OK"]
["25.05.2015",6,"Bank Hol",null,null,"",null,null,"","","",""]
["01.06.2015",7,"Bye",null,null,"",null,null,"","","",""]
["08.06.2015",8,"Away","Brown Bear",{"$f":"'Brown Bear'!F12","v":2},3,{"$f":"'Brown Bear'!H12","v":52},{"$f":"'Brown Bear'!G12","v":50},0,"Valid Scores entered","OK","OK"]
["15.06.2015",9,"Home","Drifters",2,3,53,45,0,"Valid Scores entered","OK","OK"]
["22.06.2015",10,"Home","Station Masters",0,5,45,65,0,"Valid Scores entered","OK","OK"]
["29.06.2015",11,"Away","Cricketers",{"$f":"Cricketers!F15","v":3},2,{"$f":"Cricketers!H15","v":49},{"$f":"Cricketers!G15","v":51},1,"Valid Scores entered","OK","OK"]
["06.07.2015",12,"Home","Axemen",4,1,62,37,1,"Valid Scores entered","OK","OK"]
["13.07.2015",13,"Away","Old Bulls Head",{"$f":"'Old Bulls Head'!F17","v":3},2,{"$f":"'Old Bulls Head'!H17","v":49},{"$f":"'Old Bulls Head'!G17","v":58},1,"Valid Scores entered","OK","OK"]
["20.07.2015",14,"Bye",null,null,"",null,null,"","","",""]
["27.07.2015",15,"Home","Brown Bear",4,1,61,32,1,"Valid Scores entered","OK","OK"]
["03.08.2015",16,"Away","Drifters",{"$f":"Drifters!F20","v":2},3,{"$f":"Drifters!H20","v":49},{"$f":"Drifters!G20","v":51},0,"Valid Scores entered","OK","OK"]
["10.08.2015",17,"Away","Station Masters",{"$f":"Station!F21","v":1},4,{"$f":"Station!H21","v":39},{"$f":"Station!G21","v":62},0,"Valid Scores entered","OK","OK"]
["17.08.2015",18,"Home","Cricketers",2,3,38,54,0,"Valid Scores entered","OK","OK"]
["24.08.2015",19,"Away","Axemen",{"$f":"Axemen!F23","v":3},2,{"$f":"Axemen!H23","v":52},{"$f":"Axemen!G23","v":36},1,"Valid Scores entered","OK","OK"]
["31.08.2015",20,"Bank Hol",null,null,"",null,null,"","","",""]
["07.09.2015",21,"Home","Old Bulls Head",5,0,65,31,1,"Valid Scores entered","OK","OK"]
["14.09.2015",22,"Bye",null,null,"",null,null,"","","",""]
["21.09.2015",23,"Away","Brown Bear",{"$f":"'Brown Bear'!F27","v":4},1,{"$f":"'Brown Bear'!H27","v":62},{"$f":"'Brown Bear'!G27","v":38},1,"Valid Scores entered","OK","OK"]
["28.09.2015",24,"Home","Drifters",3,2,55,51,1,"Valid Scores entered","OK","OK"]

{"sheet":"Brown Bear","index":4,"n_rows":28,"n_cols":12,"rows_kept":28,"cut":false,"hidden":false,"merged":[[2,10,2,11]]}
[]
["Team","Brown Bear"]
[null,null,null,null,null,null,null,null,null,null,"Check that there are enough points to win the games"]
["Date","Week","Home/Away","Opponent","Games Won","Games lost","Points For","Points Against","Match Won?","Check that input numbers are within range","Home","Away"]
["20.04.2014",1,"Away","Drifters",{"$f":"Drifters!F5","v":2},{"$f":"IF(E5=\"\",\"\",5-E5)","v":3},{"$f":"Drifters!H5","v":43},{"$f":"Drifters!G5","v":46},{"$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"}]
["27.04.2015",{"$f":"B5+1","v":2},"Home","Station Masters",2,3,44,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"}]
["04.05.2015",{"$f":"B6+1","v":3},"Bank Hol",null,null,"",null,null,"","","",""]
["11.05.2015",4,"Away","Cricketers",{"$f":"Cricketers!F8","v":2},3,{"$f":"Cricketers!H8","v":28},{"$f":"Cricketers!G8","v":57},0,"Valid Scores entered","OK","OK"]
["18.05.2015",5,"Home","Axemen",0,5,29,65,0,"Valid Scores entered","OK","OK"]
["25.05.2015",6,"Bank Hol",null,null,"",null,null,"","","",""]
["01.06.2015",7,"Away","Old Bulls Head",{"$f":"'Old Bulls Head'!F11","v":1},4,{"$f":"'Old Bulls Head'!H11","v":44},{"$f":"'Old Bulls Head'!G11","v":60},0,"Valid Scores entered","OK","OK"]
["08.06.2015",8,"Home","Farmers Boy",3,2,50,52,1,"Valid Scores entered","OK","OK"]
["15.06.2015",9,"Bye",null,null,"",null,null,"","","",""]
["22.06.2015",10,"Home","Drifters",1,4,23,63,0,"Valid Scores entered","OK","OK"]
["29.06.2015",11,"Away","Station Masters",{"$f":"Station!F15","v":0},5,{"$f":"Station!H15","v":23},{"$f":"Station!G15","v":65},0,"Valid Scores entered","OK","OK"]
["06.07.2015",12,"Home","Cricketers",0,5,16,65,0,"Valid Scores entered","OK","OK"]
["13.07.2015",13,"Away","Axemen",{"$f":"Axemen!F17","v":2},3,{"$f":"Axemen!H17","v":44},{"$f":"Axemen!G17","v":52},0,"Valid Scores entered","OK","OK"]
["20.07.2015",14,"Home","Old Bulls Head",2,3,43,61,0,"Valid Scores entered","OK","OK"]
["27.07.2015",15,"Away","Farmers Boy",{"$f":"'Farmers Boy'!F19","v":1},4,{"$f":"'Farmers Boy'!H19","v":32},{"$f":"'Farmers Boy'!G19","v":61},0,"Valid Scores entered","OK","OK"]
["03.08.2015",16,"Bye",null,null,"",null,null,"","","",""]
["10.08.2015",17,"Away","Drifters",{"$f":"Drifters!F21","v":0},5,{"$f":"Drifters!H21","v":29},{"$f":"Drifters!G21","v":65},0,"Valid Scores entered","OK","OK"]
["17.08.2015",18,"Home","Station Masters",1,4,27,54,0,"Valid Scores entered","OK","OK"]
["24.08.2015",19,"Away","Cricketers",{"$f":"Cricketers!F23","v":0},3,{"$f":"Cricketers!H23","v":0},{"$f":"Cricketers!G23","v":45},0,"Valid Scores entered","OK","OK"]
["31.08.2015",20,"Bank Hol",null,null,"",null,null,"","","",""]
["07.09.2015",21,"Home","Axemen",2,3,46,57,0,"Valid Scores entered","OK","OK"]
["14.09.2015",22,"Away","Old Bulls Head",{"$f":"'Old Bulls Head'!F26","v":1},4,{"$f":"'Old Bulls Head'!H26","v":45},{"$f":"'Old Bulls Head'!G26","v":56},0,"Valid Scores entered","OK","OK"]
["21.09.2015",23,"Home","Farmers Boy",1,4,38,62,0,"Valid Scores entered","OK","OK"]
["28.09.2015",24,"Bye",null,null,"",null,null,"","","",""]

{"sheet":"Drifters","index":5,"n_rows":28,"n_cols":12,"rows_kept":28,"cut":false,"hidden":false,"merged":[[2,10,2,11]]}
[]
["Team","Drifters"]
[null,null,null,null,null,null,null,null,null,null,"Check that there are enough points to win the games"]
["Date","Week","Home/Away","Opponent","Games Won","Games lost","Points For","Points Against","Match Won?","Check that input numbers are within range","Home","Away"]
["20.04.2014",1,"Home","Brown Bear",3,{"$f":"IF(E5=\"\",\"\",5-E5)","v":2},46,43,{"$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"}]
["27.04.2015",{"$f":"B5+1","v":2},"Bye",null,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":""}]
["04.05.2015",{"$f":"B6+1","v":3},"Bank Hol",null,null,"",null,null,"","","",""]
["11.05.2015",4,"Away","Station Masters",{"$f":"Station!F8","v":1},4,{"$f":"Station!H8","v":44},{"$f":"Station!G8","v":55},0,"Valid Scores entered","OK","OK"]
["18.05.2015",5,"Home","Cricketers",1,4,40,61,0,"Valid Scores entered","OK","OK"]
["25.05.2015",6,"Bank Hol",null,null,"",null,null,"","","",""]
["01.06.2015",7,"Away","Axemen",{"$f":"Axemen!F11","v":3},2,{"$f":"Axemen!H11","v":56},{"$f":"Axemen!G11","v":41},1,"Valid Scores entered","OK","OK"]
["08.06.2015",8,"Home","Old Bulls Head",4,1,64,44,1,"Valid Scores entered","OK","OK"]
["15.06.2015",9,"Away","Farmers Boy",{"$f":"'Farmers Boy'!F13","v":3},2,{"$f":"'Farmers Boy'!H13","v":45},{"$f":"'Farmers Boy'!G13","v":53},1,"Valid Scores entered","OK","OK"]
["22.06.2015",10,"Away","Brown Bear",{"$f":"'Brown Bear'!F14","v":4},1,{"$f":"'Brown Bear'!H14","v":63},{"$f":"'Brown Bear'!G14","v":23},1,"Valid Scores entered","OK","OK"]
["29.06.2015",11,"Bye",null,null,"",null,null,"","","",""]
["06.07.2015",12,"Home","Station Masters",2,3,48,50,0,"Valid Scores entered","OK","OK"]
["13.07.2015",13,"Away","Cricketers",{"$f":"Cricketers!F17","v":0},5,{"$f":"Cricketers!H17","v":25},{"$f":"Cricketers!G17","v":65},0,"Valid Scores entered","OK","OK"]
["20.07.2015",14,"Home","Axemen",4,1,59,44,1,"Valid Scores entered","OK","OK"]
["27.07.2015",15,"Away","Old Bulls Head",{"$f":"'Old Bulls Head'!F19","v":2},3,{"$f":"'Old Bulls Head'!H19","v":42},{"$f":"'Old Bulls Head'!G19","v":61},0,"Valid Scores entered","OK","OK"]
["03.08.2015",16,"Home","Farmers Boy",3,2,51,49,1,"Valid Scores entered","OK","OK"]
["10.08.2015",17,"Home","Brown Bear",5,0,65,29,1,"Valid Scores entered","OK","OK"]
["17.08.2015",18,"Bye",null,null,"",null,null,"","","",""]
["24.08.2015",19,"Away","Station Masters",{"$f":"Station!F23","v":0},5,{"$f":"Station!H23","v":35},{"$f":"Station!G23","v":65},0,"Valid Scores entered","OK","OK"]
["31.08.2015",20,"Bank Hol",null,null,"",null,null,"","","",""]
["07.09.2015",21,"Home","Cricketers",0,3,0,45,0,"Valid Scores entered","OK","OK"]
["14.09.2015",22,"Away","Axemen",{"$f":"Axemen!F26","v":1},4,{"$f":"Axemen!H26","v":35},{"$f":"Axemen!G26","v":64},0,"Valid Scores entered","OK","OK"]
["21.09.2015",23,"Home","Old Bulls Head",4,1,59,33,1,"Valid Scores entered","OK","OK"]
["28.09.2015",24,"Away","Farmers Boy",{"$f":"'Farmers Boy'!F28","v":2},3,{"$f":"'Farmers Boy'!H28","v":51},{"$f":"'Farmers Boy'!G28","v":55},0,"Valid Scores entered","OK","OK"]

{"sheet":"Station","index":6,"n_rows":28,"n_cols":12,"rows_kept":28,"cut":false,"hidden":false,"merged":[[2,10,2,11]]}
[]
["Team","Station Masters"]
[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"]
["20.04.2014",1,"Home","Farmers Boy",3,{"$f":"IF(E5=\"\",\"\",5-E5)","v":2},61,43,{"$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"}]
["27.04.2015",{"$f":"B5+1","v":2},"Away","Brown Bear",{"$f":"'Brown Bear'!F6","v":3},2,{"$f":"'Brown Bear'!H6","v":56},{"$f":"'Brown Bear'!G6","v":44},{"$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"}]
["04.05.2015",{"$f":"B6+1","v":3},"Bank Hol",null,null,"",null,null,"","","",""]
["11.05.2015",4,"Home","Drifters",4,1,55,44,1,"Valid Scores entered","OK","OK"]
["18.05.2015",5,"Bye",null,null,"",null,null,"","","",""]
["25.05.2015",6,"Bank Hol",null,null,"",null,null,"","","",""]
["01.06.2015",7,"Away","Cricketers",{"$f":"Cricketers!F11","v":1},{"$f":"IF(E11=\"\",\"\",5-E11)","v":4},{"$f":"Cricketers!H11","v":40},{"$f":"Cricketers!G11","v":64},{"$f":"IF(E11=\"\",\"\",IF(E11>2,1,0))","v":0},{"$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"}]
["08.06.2015",8,"Home","Axemen",4,1,58,29,1,"Valid Scores entered","OK","OK"]
["15.06.2015",9,"Away","Old Bulls Head",{"$f":"'Old Bulls Head'!F13","v":3},2,{"$f":"'Old Bulls Head'!H13","v":53},{"$f":"'Old Bulls Head'!G13","v":45},1,"Valid Scores entered","OK","OK"]
["22.06.2015",10,"Away","Farmers Boy",{"$f":"'Farmers Boy'!F14","v":5},{"$f":"IF(E14=\"\",\"\",5-E14)","v":0},{"$f":"'Farmers Boy'!H14","v":65},{"$f":"'Farmers Boy'!G14","v":45},{"$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"}]
["29.06.2015",11,"Home","Brown Bear",5,0,65,23,1,"Valid Scores entered","OK","OK"]
["06.07.2015",12,"Away","Drifters",{"$f":"Drifters!F16","v":3},2,{"$f":"Drifters!H16","v":50},{"$f":"Drifters!G16","v":48},1,"Valid Scores entered","OK","OK"]
["13.07.2015",13,"Bye",null,null,"",null,null,"","","",""]
["20.07.2015",14,"Home","Cricketers",3,2,47,53,1,"Valid Scores entered","OK","OK"]
["27.07.2015",15,"Away","Axemen",{"$f":"Axemen!F19","v":1},4,{"$f":"Axemen!H19","v":46},{"$f":"Axemen!G19","v":60},0,"Valid Scores entered","OK","OK"]
["03.08.2015",16,"Home","Old Bulls Head",4,1,61,39,1,"Valid Scores entered","OK","OK"]
["10.08.2015",17,"Home","Farmers Boy",4,1,62,39,1,"Valid Scores entered","OK","OK"]
["17.08.2015",18,"Away","Brown Bear",{"$f":"'Brown Bear'!F22","v":4},1,{"$f":"'Brown Bear'!H22","v":54},{"$f":"'Brown Bear'!G22","v":27},1,"Valid Scores entered","OK","OK"]
["24.08.2015",19,"Home","Drifters",5,0,65,35,1,"Valid Scores entered","OK","OK"]
["31.08.2015",20,"Bank Hol",null,null,"",null,null,"","","",""]
["07.09.2015",21,"Bye",null,null,"",null,null,"","","",""]
["14.09.2015",22,"Away","Cricketers",{"$f":"Cricketers!F26","v":2},3,{"$f":"Cricketers!H26","v":57},{"$f":"Cricketers!G26","v":51},0,"Valid Scores entered","OK","OK"]
["21.09.2015",23,"Home","Axemen",2,3,49,48,0,"Valid Scores entered","OK","OK"]
["28.09.2015",24,"Away","Old Bulls Head",{"$f":"'Old Bulls Head'!F28","v":1},4,{"$f":"'Old Bulls Head'!H28","v":51},{"$f":"'Old Bulls Head'!G28","v":57},0,"Valid Scores entered","OK","OK"]

{"sheet":"Cricketers","index":7,"n_rows":28,"n_cols":12,"rows_kept":28,"cut":false,"hidden":false,"merged":[[2,10,2,11]]}
[]
["Team","Cricketers"]
[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"]
["20.04.2014",1,"Home","Old Bulls Head",5,{"$f":"IF(E5=\"\",\"\",5-E5)","v":0},65,17,{"$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"}]
["27.04.2015",{"$f":"B5+1","v":2},"Away","Farmers Boy",{"$f":"'Farmers Boy'!F6","v":2},3,{"$f":"'Farmers Boy'!H6","v":52},{"$f":"'Farmers Boy'!G6","v":46},{"$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"}]
["04.05.2015",{"$f":"B6+1","v":3},"Bank Hol",null,null,"",null,null,"","","",""]
["11.05.2015",4,"Home","Brown Bear",3,2,57,28,1,"Valid Scores entered","OK","OK"]
["18.05.2015",5,"Away","Drifters",{"$f":"Drifters!F9","v":4},1,{"$f":"Drifters!H9","v":61},{"$f":"Drifters!G9","v":40},1,"Valid Scores entered","OK","OK"]
["25.05.2015",6,"Bank Hol",null,null,"",null,null,"","","",""]
["01.06.2015",7,"Home","Station Masters",4,1,64,40,1,"Valid Scores entered","OK","OK"]
["08.06.2015",8,"Bye",null,null,"",null,null,"","","",""]
["15.06.2015",9,"Away","Axemen",{"$f":"Axemen!F13","v":4},1,{"$f":"Axemen!H13","v":54},{"$f":"Axemen!G13","v":32},1,"Valid Scores entered","OK","OK"]
["22.06.2015",10,"Away","Old Bulls Head",{"$f":"'Old Bulls Head'!F14","v":4},1,{"$f":"'Old Bulls Head'!H14","v":55},{"$f":"'Old Bulls Head'!G14","v":30},1,"Valid Scores entered","OK","OK"]
["29.06.2015",11,"Home","Farmers Boy",2,3,51,49,0,"Valid Scores entered","OK","OK"]
["06.07.2015",12,"Away","Brown Bear",{"$f":"'Brown Bear'!F16","v":5},0,{"$f":"'Brown Bear'!H16","v":65},{"$f":"'Brown Bear'!G16","v":16},1,"Valid Scores entered","OK","OK"]
["13.07.2015",13,"Home","Drifters",5,0,65,25,1,"Valid Scores entered","OK","OK"]
["20.07.2015",14,"Away","Station Masters",{"$f":"Station!F18","v":2},3,{"$f":"Station!H18","v":53},{"$f":"Station!G18","v":47},0,"Valid Scores entered","OK","OK"]
["27.07.2015",15,"Bye",null,null,"",null,null,"","","",""]
["03.08.2015",16,"Home","Axemen",4,1,52,43,1,"Valid Scores entered","OK","OK"]
["10.08.2015",17,"Home","Old Bulls Head",3,0,45,0,1,"Valid Scores entered","OK","OK"]
["17.08.2015",18,"Away","Farmers Boy",{"$f":"'Farmers Boy'!F22","v":3},2,{"$f":"'Farmers Boy'!H22","v":54},{"$f":"'Farmers Boy'!G22","v":38},1,"Valid Scores entered","OK","OK"]
["24.08.2015",19,"Home","Brown Bear",3,0,45,0,1,"Valid Scores entered","OK","OK"]
["31.08.2015",20,"Bank Hol",null,null,"",null,null,"","","",""]
["07.09.2015",21,"Away","Drifters",3,0,{"$f":"Drifters!H25","v":45},{"$f":"Drifters!G25","v":0},1,"Valid Scores entered","OK","OK"]
["14.09.2015",22,"Home","Station Masters",3,2,51,57,1,"Valid Scores entered","OK","OK"]
["21.09.2015",23,"Bye",null,null,"",null,null,"","","",""]
["28.09.2015",24,"Away","Axemen",{"$f":"Axemen!F28","v":4},1,{"$f":"Axemen!H28","v":58},{"$f":"Axemen!G28","v":41},1,"Valid Scores entered","OK","OK"]