{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Table","Woodentops","Rising Sun","George A","OldUns","Plume","Bucks Head","George Bees"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Table","index":0,"n_rows":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"]
["George Bees",{"$f":"COUNT('George Bees'!E:E)","v":18},{"$f":"SUM('George Bees'!I:I)","v":15},{"$f":"SUM('George Bees'!E:E)","v":63},{"$f":"SUM('George Bees'!F:F)","v":27},{"$f":"SUM('George Bees'!G:G)","v":1032},{"$f":"SUM('George Bees'!H:H)","v":689},{"$f":"F4-G4","v":343}]
["OldUns",{"$f":"COUNT(OldUns!E:E)","v":18},{"$f":"SUM(OldUns!I:I)","v":14},{"$f":"SUM(OldUns!E:E)","v":57},{"$f":"SUM(OldUns!F:F)","v":33},{"$f":"SUM(OldUns!G:G)","v":964},{"$f":"SUM(OldUns!H:H)","v":833},{"$f":"F5-G5","v":131}]
["Woodentops",{"$f":"COUNT(Woodentops!E:E)","v":18},{"$f":"SUM(Woodentops!I:I)","v":11},{"$f":"SUM(Woodentops!E:E)","v":50},{"$f":"SUM(Woodentops!F:F)","v":40},{"$f":"SUM(Woodentops!G:G)","v":957},{"$f":"SUM(Woodentops!H:H)","v":827},{"$f":"F6-G6","v":130}]
["Plume",{"$f":"COUNT(Plume!E:E)","v":18},{"$f":"SUM(Plume!I:I)","v":9},{"$f":"SUM(Plume!E:E)","v":46},{"$f":"SUM(Plume!F:F)","v":44},{"$f":"SUM(Plume!G:G)","v":890},{"$f":"SUM(Plume!H:H)","v":897},{"$f":"F7-G7","v":-7}]
["Bucks Head",{"$f":"COUNT('Bucks Head'!E:E)","v":18},{"$f":"SUM('Bucks Head'!I:I)","v":8},{"$f":"SUM('Bucks Head'!E:E)","v":41},{"$f":"SUM('Bucks Head'!F:F)","v":49},{"$f":"SUM('Bucks Head'!G:G)","v":847},{"$f":"SUM('Bucks Head'!H:H)","v":965},{"$f":"F8-G8","v":-118}]
["George A",{"$f":"COUNT('George A'!E:E)","v":18},{"$f":"SUM('George A'!I:I)","v":3},{"$f":"SUM('George A'!E:E)","v":32},{"$f":"SUM('George A'!F:F)","v":58},{"$f":"SUM('George A'!G:G)","v":754},{"$f":"SUM('George A'!H:H)","v":969},{"$f":"F9-G9","v":-215}]
["Rising Sun",{"$f":"COUNT('Rising Sun'!E:E)","v":18},{"$f":"SUM('Rising Sun'!I:I)","v":3},{"$f":"SUM('Rising Sun'!E:E)","v":26},{"$f":"SUM('Rising Sun'!F:F)","v":64},{"$f":"SUM('Rising Sun'!G:G)","v":783},{"$f":"SUM('Rising Sun'!H:H)","v":1047},{"$f":"F10-G10","v":-264}]

{"sheet":"Woodentops","index":1,"n_rows":28,"n_cols":12,"rows_kept":28,"cut":false,"hidden":false,"merged":[[2,10,2,11]]}
[]
["Team","Woodentops"]
[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","Rising Sun",{"$f":"'Rising Sun'!F6","v":3},2,{"$f":"'Rising Sun'!H6","v":54},{"$f":"'Rising Sun'!G6","v":39},{"$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,{"$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","George A",4,1,60,38,1,"Valid Scores entered","OK","OK"]
["18.05.2015",5,"Away","OldUns",{"$f":"OldUns!F9","v":3},2,{"$f":"OldUns!H9","v":56},{"$f":"OldUns!G9","v":54},1,"Valid Scores entered","OK","OK"]
["25.05.2015",6,"Bank Hol",null,null,"",null,null,"","","",""]
["01.06.2015",7,"Home","Plume",2,3,47,50,0,"Valid Scores entered","OK","OK"]
["08.06.2015",8,"Away","Bucks Head",{"$f":"'Bucks Head'!F12","v":4},1,{"$f":"'Bucks Head'!H12","v":58},{"$f":"'Bucks Head'!G12","v":38},1,"Valid Scores entered","OK","OK"]
["15.06.2015",9,"Home","George Bees",1,4,49,62,0,"Valid Scores entered","OK","OK"]
["22.06.2015",10,"Bye",null,null,"",null,null,"","","",""]
["29.06.2015",11,"Home","Rising Sun",2,3,51,45,0,"Valid Scores entered","OK","OK"]
["06.07.2015",12,"Away","George A",{"$f":"'George A'!F16","v":3},2,{"$f":"'George A'!H16","v":48},{"$f":"'George A'!G16","v":41},1,"Valid Scores entered","OK","OK"]
["13.07.2015",13,"Home","OldUns",2,3,53,49,0,"Valid Scores entered","OK","OK"]
["20.07.2015",14,"Away","Plume",{"$f":"Plume!F18","v":3},2,{"$f":"Plume!H18","v":58},{"$f":"Plume!G18","v":46},1,"Valid Scores entered","OK","OK"]
["27.07.2015",15,"Home","Bucks Head",4,1,64,36,1,"Valid Scores entered","OK","OK"]
["03.08.2015",16,"Away","George Bees",{"$f":"'George Bees'!F20","v":2},3,{"$f":"'George Bees'!H20","v":44},{"$f":"'George Bees'!G20","v":50},0,"Valid Scores entered","OK","OK"]
["10.08.2015",17,"Bye",null,null,"",null,null,"","","",""]
["17.08.2015",18,"Away","Rising Sun",{"$f":"'Rising Sun'!F22","v":3},2,{"$f":"'Rising Sun'!H22","v":55},{"$f":"'Rising Sun'!G22","v":56},1,"Valid Scores entered","OK","OK"]
["24.08.2015",19,"Home","George A",4,1,55,37,1,"Valid Scores entered","OK","OK"]
["31.08.2015",20,"Bank Hol",null,null,"",null,null,"","","",""]
["07.09.2015",21,"Away","OldUns",{"$f":"OldUns!F25","v":2},3,{"$f":"OldUns!H25","v":50},{"$f":"OldUns!G25","v":54},0,"Valid Scores entered","OK","OK"]
["14.09.2015",22,"Home","Plume",3,2,58,46,1,"Valid Scores entered","OK","OK"]
["21.09.2015",23,"Away","Bucks Head",{"$f":"'Bucks Head'!F27","v":3},2,{"$f":"'Bucks Head'!H27","v":58},{"$f":"'Bucks Head'!G27","v":34},1,"Valid Scores entered","OK","OK"]
["28.09.2015",24,"Home","George Bees",2,3,39,52,0,"Valid Scores entered","OK","OK"]

{"sheet":"Rising Sun","index":2,"n_rows":28,"n_cols":12,"rows_kept":28,"cut":false,"hidden":false,"merged":[[2,10,2,11]]}
[]
["Team","Rising Sun"]
[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","George Bees",{"$f":"'George Bees'!F5","v":0},{"$f":"IF(E5=\"\",\"\",5-E5)","v":5},{"$f":"'George Bees'!H5","v":21},{"$f":"'George Bees'!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","Woodentops",2,3,39,54,{"$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,"Bye",null,null,"",null,null,"","","",""]
["18.05.2015",5,"Away","George A",{"$f":"'George A'!F9","v":1},4,{"$f":"'George A'!H9","v":38},{"$f":"'George A'!G9","v":53},0,"Valid Scores entered","OK","OK"]
["25.05.2015",6,"Bank Hol",null,null,"",null,null,"","","",""]
["01.06.2015",7,"Home","OldUns",2,3,53,58,0,"Valid Scores entered","OK","OK"]
["08.06.2015",8,"Away","Plume",{"$f":"Plume!F12","v":0},5,{"$f":"Plume!H12","v":35},{"$f":"Plume!G12","v":65},0,"Valid Scores entered","OK","OK"]
["15.06.2015",9,"Home","Bucks Head",2,3,44,57,0,"Valid Scores entered","OK","OK"]
["22.06.2015",10,"Home","George Bees",1,4,43,63,0,"Valid Scores entered","OK","OK"]
["29.06.2015",11,"Away","Woodentops",{"$f":"Woodentops!F15","v":3},2,{"$f":"Woodentops!H15","v":45},{"$f":"Woodentops!G15","v":51},1,"Valid Scores entered","OK","OK"]
["06.07.2015",12,"Bye",null,null,"",null,null,"","","",""]
["13.07.2015",13,"Home","George A",3,2,52,61,1,"Valid Scores entered","OK","OK"]
["20.07.2015",14,"Away","OldUns",{"$f":"OldUns!F18","v":0},5,{"$f":"OldUns!H18","v":31},{"$f":"OldUns!G18","v":65},0,"Valid Scores entered","OK","OK"]
["27.07.2015",15,"Home","Plume",1,4,51,61,0,"Valid Scores entered","OK","OK"]
["03.08.2015",16,"Away","Bucks Head",{"$f":"'Bucks Head'!F20","v":0},5,{"$f":"'Bucks Head'!H20","v":41},{"$f":"'Bucks Head'!G20","v":65},0,"Valid Scores entered","OK","OK"]
["10.08.2015",17,"Away","George Bees",{"$f":"'George Bees'!F21","v":1},4,{"$f":"'George Bees'!H21","v":42},{"$f":"'George Bees'!G21","v":64},0,"Valid Scores entered","OK","OK"]
["17.08.2015",18,"Home","Woodentops",2,3,56,55,0,"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","George A",{"$f":"'George A'!F25","v":2},3,{"$f":"'George A'!H25","v":47},{"$f":"'George A'!G25","v":50},0,"Valid Scores entered","OK","OK"]
["14.09.2015",22,"Home","OldUns",1,4,37,57,0,"Valid Scores entered","OK","OK"]
["21.09.2015",23,"Away","Plume",{"$f":"Plume!F27","v":2},3,{"$f":"Plume!H27","v":45},{"$f":"Plume!G27","v":53},0,"Valid Scores entered","OK","OK"]
["28.09.2015",24,"Home","Bucks Head",3,2,63,50,1,"Valid Scores entered","OK","OK"]

{"sheet":"George A","index":3,"n_rows":28,"n_cols":12,"rows_kept":28,"cut":false,"hidden":false,"merged":[[2,10,2,11]]}
[]
["Team","George A"]
[null,null,null,null,null,null,null,null,null,null,"Check that there are enough points to win the games"]
["Date","Week","Home/Away","Opponent","Games Won","Games lost","Points For","Points Against","Match Won?","Check that input numbers are within range","Home","Away"]
["20.04.2014",1,"Away","Bucks Head",{"$f":"'Bucks Head'!F5","v":2},{"$f":"IF(E5=\"\",\"\",5-E5)","v":3},{"$f":"'Bucks Head'!H5","v":44},{"$f":"'Bucks Head'!G5","v":51},{"$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","George Bees",1,4,28,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"}]
["04.05.2015",{"$f":"B6+1","v":3},"Bank Hol",null,null,"",null,null,"","","",""]
["11.05.2015",4,"Away","Woodentops",{"$f":"Woodentops!F8","v":1},4,{"$f":"Woodentops!H8","v":38},{"$f":"Woodentops!G8","v":60},0,"Valid Scores entered","OK","OK"]
["18.05.2015",5,"Home","Rising Sun",4,1,53,38,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","OldUns",{"$f":"OldUns!F12","v":0},5,{"$f":"OldUns!H12","v":30},{"$f":"OldUns!G12","v":65},0,"Valid Scores entered","OK","OK"]
["15.06.2015",9,"Home","Plume",2,3,46,52,0,"Valid Scores entered","OK","OK"]
["22.06.2015",10,"Home","Bucks Head",2,3,49,53,0,"Valid Scores entered","OK","OK"]
["29.06.2015",11,"Away","George Bees",{"$f":"'George Bees'!F15","v":1},4,{"$f":"'George Bees'!H15","v":22},{"$f":"'George Bees'!G15","v":63},0,"Valid Scores entered","OK","OK"]
["06.07.2015",12,"Home","Woodentops",2,3,41,48,0,"Valid Scores entered","OK","OK"]
["13.07.2015",13,"Away","Rising Sun",{"$f":"'Rising Sun'!F17","v":2},3,{"$f":"'Rising Sun'!H17","v":61},{"$f":"'Rising Sun'!G17","v":52},0,"Valid Scores entered","OK","OK"]
["20.07.2015",14,"Bye",null,null,"",null,null,"","","",""]
["27.07.2015",15,"Home","OldUns",1,4,46,58,0,"Valid Scores entered","OK","OK"]
["03.08.2015",16,"Away","Plume",{"$f":"Plume!F20","v":3},2,{"$f":"Plume!H20","v":49},{"$f":"Plume!G20","v":39},1,"Valid Scores entered","OK","OK"]
["10.08.2015",17,"Away","Bucks Head",{"$f":"'Bucks Head'!F21","v":2},3,{"$f":"'Bucks Head'!H21","v":56},{"$f":"'Bucks Head'!G21","v":59},0,"Valid Scores entered","OK","OK"]
["17.08.2015",18,"Home","George Bees",1,4,29,62,0,"Valid Scores entered","OK","OK"]
["24.08.2015",19,"Away","Woodentops",{"$f":"Woodentops!F23","v":1},4,{"$f":"Woodentops!H23","v":37},{"$f":"Woodentops!G23","v":55},0,"Valid Scores entered","OK","OK"]
["31.08.2015",20,"Bank Hol",null,null,"",null,null,"","","",""]
["07.09.2015",21,"Home","Rising Sun",3,2,50,47,1,"Valid Scores entered","OK","OK"]
["14.09.2015",22,"Bye",null,null,"",null,null,"","","",""]
["21.09.2015",23,"Away","OldUns",{"$f":"OldUns!F27","v":2},3,{"$f":"OldUns!H27","v":38},{"$f":"OldUns!G27","v":57},0,"Valid Scores entered","OK","OK"]
["28.09.2015",24,"Home","Plume",2,3,37,47,0,"Valid Scores entered","OK","OK"]

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

{"sheet":"Plume","index":5,"n_rows":28,"n_cols":12,"rows_kept":28,"cut":false,"hidden":false,"merged":[[2,10,2,11]]}
[]
["Team","Plume"]
[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","OldUns",3,{"$f":"IF(E5=\"\",\"\",5-E5)","v":2},58,52,{"$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","Bucks Head",{"$f":"'Bucks Head'!F8","v":1},4,{"$f":"'Bucks Head'!H8","v":49},{"$f":"'Bucks Head'!G8","v":57},0,"Valid Scores entered","OK","OK"]
["18.05.2015",5,"Home","George Bees",1,4,46,55,0,"Valid Scores entered","OK","OK"]
["25.05.2015",6,"Bank Hol",null,null,"",null,null,"","","",""]
["01.06.2015",7,"Away","Woodentops",{"$f":"Woodentops!F11","v":3},2,{"$f":"Woodentops!H11","v":50},{"$f":"Woodentops!G11","v":47},1,"Valid Scores entered","OK","OK"]
["08.06.2015",8,"Home","Rising Sun",5,0,65,35,1,"Valid Scores entered","OK","OK"]
["15.06.2015",9,"Away","George A",{"$f":"'George A'!F13","v":3},2,{"$f":"'George A'!H13","v":52},{"$f":"'George A'!G13","v":46},1,"Valid Scores entered","OK","OK"]
["22.06.2015",10,"Away","OldUns",{"$f":"OldUns!F14","v":2},3,{"$f":"OldUns!H14","v":41},{"$f":"OldUns!G14","v":53},0,"Valid Scores entered","OK","OK"]
["29.06.2015",11,"Bye",null,null,"",null,null,"","","",""]
["06.07.2015",12,"Home","Bucks Head",4,1,63,31,1,"Valid Scores entered","OK","OK"]
["13.07.2015",13,"Away","George Bees",{"$f":"'George Bees'!F17","v":1},4,{"$f":"'George Bees'!H17","v":27},{"$f":"'George Bees'!G17","v":63},0,"Valid Scores entered","OK","OK"]
["20.07.2015",14,"Home","Woodentops",2,3,46,58,0,"Valid Scores entered","OK","OK"]
["27.07.2015",15,"Away","Rising Sun",{"$f":"'Rising Sun'!F19","v":4},1,{"$f":"'Rising Sun'!H19","v":61},{"$f":"'Rising Sun'!G19","v":51},1,"Valid Scores entered","OK","OK"]
["03.08.2015",16,"Home","George A",2,3,39,49,0,"Valid Scores entered","OK","OK"]
["10.08.2015",17,"Home","OldUns",2,3,55,56,0,"Valid Scores entered","OK","OK"]
["17.08.2015",18,"Bye",null,null,"",null,null,"","","",""]
["24.08.2015",19,"Away","Bucks Head",{"$f":"'Bucks Head'!F23","v":2},3,{"$f":"'Bucks Head'!H23","v":40},{"$f":"'Bucks Head'!G23","v":57},0,"Valid Scores entered","OK","OK"]
["31.08.2015",20,"Bank Hol",null,null,"",null,null,"","","",""]
["07.09.2015",21,"Home","George Bees",3,2,52,47,1,"Valid Scores entered","OK","OK"]
["14.09.2015",22,"Away","Woodentops",{"$f":"Woodentops!F26","v":2},3,{"$f":"Woodentops!H26","v":46},{"$f":"Woodentops!G26","v":58},0,"Valid Scores entered","OK","OK"]
["21.09.2015",23,"Home","Rising Sun",3,2,53,45,1,"Valid Scores entered","OK","OK"]
["28.09.2015",24,"Away","George A",{"$f":"'George A'!F28","v":3},2,{"$f":"'George A'!H28","v":47},{"$f":"'George A'!G28","v":37},1,"Valid Scores entered","OK","OK"]

{"sheet":"Bucks Head","index":6,"n_rows":28,"n_cols":12,"rows_kept":28,"cut":false,"hidden":false,"merged":[[2,10,2,11]]}
[]
["Team","Bucks 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,"Home","George A",3,{"$f":"IF(E5=\"\",\"\",5-E5)","v":2},51,44,{"$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","OldUns",{"$f":"OldUns!F6","v":4},1,{"$f":"OldUns!H6","v":63},{"$f":"OldUns!G6","v":36},{"$f":"IF(E6=\"\",\"\",IF(E6>2,1,0))","v":1},{"$f":"IF(E6=\"\",\"\",IF(OR(E6<0,E6>5,G6<0,G6>(5*13),H6<0,H6>(5*13)),\"Number out of range error\",\"Valid Scores entered\"))","v":"Valid Scores entered"},{"$f":"IF(E6=\"\",\"\",IF((E6*13>G6),\"Error in submitting Games Won or Points Home\",\"OK\"))","v":"OK"},{"$f":"IF(E6=\"\",\"\",IF((F6*13>H6),\"Error in submitting Games Won or Points Away\",\"OK\"))","v":"OK"}]
["04.05.2015",{"$f":"B6+1","v":3},"Bank Hol",null,null,"",null,null,"","","",""]
["11.05.2015",4,"Home","Plume",4,1,57,49,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","George Bees",{"$f":"'George Bees'!F11","v":2},{"$f":"IF(E11=\"\",\"\",5-E11)","v":3},{"$f":"'George Bees'!H11","v":46},{"$f":"'George Bees'!G11","v":58},{"$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","Woodentops",1,4,38,58,0,"Valid Scores entered","OK","OK"]
["15.06.2015",9,"Away","Rising Sun",{"$f":"'Rising Sun'!F13","v":3},2,{"$f":"'Rising Sun'!H13","v":57},{"$f":"'Rising Sun'!G13","v":44},1,"Valid Scores entered","OK","OK"]
["22.06.2015",10,"Away","George A",{"$f":"'George A'!F14","v":3},{"$f":"IF(E14=\"\",\"\",5-E14)","v":2},{"$f":"'George A'!H14","v":53},{"$f":"'George A'!G14","v":49},{"$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","OldUns",1,4,33,60,0,"Valid Scores entered","OK","OK"]
["06.07.2015",12,"Away","Plume",{"$f":"Plume!F16","v":1},4,{"$f":"Plume!H16","v":31},{"$f":"Plume!G16","v":63},0,"Valid Scores entered","OK","OK"]
["13.07.2015",13,"Bye",null,null,"",null,null,"","","",""]
["20.07.2015",14,"Home","George Bees",1,4,30,63,0,"Valid Scores entered","OK","OK"]
["27.07.2015",15,"Away","Woodentops",{"$f":"Woodentops!F19","v":1},4,{"$f":"Woodentops!H19","v":36},{"$f":"Woodentops!G19","v":64},0,"Valid Scores entered","OK","OK"]
["03.08.2015",16,"Home","Rising Sun",5,0,65,41,1,"Valid Scores entered","OK","OK"]
["10.08.2015",17,"Home","George A",3,2,59,56,1,"Valid Scores entered","OK","OK"]
["17.08.2015",18,"Away","OldUns",{"$f":"OldUns!F22","v":1},4,{"$f":"OldUns!H22","v":44},{"$f":"OldUns!G22","v":62},0,"Valid Scores entered","OK","OK"]
["24.08.2015",19,"Home","Plume",3,2,57,40,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","George Bees",{"$f":"'George Bees'!F26","v":1},4,{"$f":"'George Bees'!H26","v":43},{"$f":"'George Bees'!G26","v":57},0,"Valid Scores entered","OK","OK"]
["21.09.2015",23,"Home","Woodentops",2,3,34,58,0,"Valid Scores entered","OK","OK"]
["28.09.2015",24,"Away","Rising Sun",{"$f":"'Rising Sun'!F28","v":2},3,{"$f":"'Rising Sun'!H28","v":50},{"$f":"'Rising Sun'!G28","v":63},0,"Valid Scores entered","OK","OK"]

{"sheet":"George Bees","index":7,"n_rows":28,"n_cols":12,"rows_kept":28,"cut":false,"hidden":false,"merged":[[2,10,2,11]]}
[]
["Team","George Bees"]
[null,null,null,null,null,null,null,null,null,null,"Check that there are enough points to win the games"]
["Date","Week","Home/Away","Opponent","Games Won","Games lost","Points For","Points Against","Match Won?","Check that input numbers are within range","Home","Away"]
["20.04.2014",1,"Home","Rising Sun",5,{"$f":"IF(E5=\"\",\"\",5-E5)","v":0},65,21,{"$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","George A",{"$f":"'George A'!F6","v":4},1,{"$f":"'George A'!H6","v":63},{"$f":"'George A'!G6","v":28},{"$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","OldUns",4,1,61,26,1,"Valid Scores entered","OK","OK"]
["18.05.2015",5,"Away","Plume",{"$f":"Plume!F9","v":4},1,{"$f":"Plume!H9","v":55},{"$f":"Plume!G9","v":46},1,"Valid Scores entered","OK","OK"]
["25.05.2015",6,"Bank Hol",null,null,"",null,null,"","","",""]
["01.06.2015",7,"Home","Bucks Head",3,2,58,46,1,"Valid Scores entered","OK","OK"]
["08.06.2015",8,"Bye",null,null,"",null,null,"","","",""]
["15.06.2015",9,"Away","Woodentops",{"$f":"Woodentops!F13","v":4},1,{"$f":"Woodentops!H13","v":62},{"$f":"Woodentops!G13","v":49},1,"Valid Scores entered","OK","OK"]
["22.06.2015",10,"Away","Rising Sun",{"$f":"'Rising Sun'!F14","v":4},1,{"$f":"'Rising Sun'!H14","v":63},{"$f":"'Rising Sun'!G14","v":43},1,"Valid Scores entered","OK","OK"]
["29.06.2015",11,"Home","George A",4,1,63,22,1,"Valid Scores entered","OK","OK"]
["06.07.2015",12,"Away","OldUns",{"$f":"OldUns!F16","v":1},4,{"$f":"OldUns!H16","v":37},{"$f":"OldUns!G16","v":57},0,"Valid Scores entered","OK","OK"]
["13.07.2015",13,"Home","Plume",4,1,63,27,1,"Valid Scores entered","OK","OK"]
["20.07.2015",14,"Away","Bucks Head",{"$f":"'Bucks Head'!F18","v":4},1,{"$f":"'Bucks Head'!H18","v":63},{"$f":"'Bucks Head'!G18","v":30},1,"Valid Scores entered","OK","OK"]
["27.07.2015",15,"Bye",null,null,"",null,null,"","","",""]
["03.08.2015",16,"Home","Woodentops",3,2,50,44,1,"Valid Scores entered","OK","OK"]
["10.08.2015",17,"Home","Rising Sun",4,1,64,42,1,"Valid Scores entered","OK","OK"]
["17.08.2015",18,"Away","George A",{"$f":"'George A'!F22","v":4},1,{"$f":"'George A'!H22","v":62},{"$f":"'George A'!G22","v":29},1,"Valid Scores entered","OK","OK"]
["24.08.2015",19,"Home","OldUns",2,3,47,45,0,"Valid Scores entered","OK","OK"]
["31.08.2015",20,"Bank Hol",null,null,"",null,null,"","","",""]
["07.09.2015",21,"Away","Plume",{"$f":"Plume!F25","v":2},3,{"$f":"Plume!H25","v":47},{"$f":"Plume!G25","v":52},0,"Valid Scores entered","OK","OK"]
["14.09.2015",22,"Home","Bucks Head",4,1,57,43,1,"Valid Scores entered","OK","OK"]
["21.09.2015",23,"Bye",null,null,"",null,null,"","","",""]
["28.09.2015",24,"Away","Woodentops",{"$f":"Woodentops!F28","v":3},2,{"$f":"Woodentops!H28","v":52},{"$f":"Woodentops!G28","v":39},1,"Valid Scores entered","OK","OK"]