{"text_format":"3","workbook":"xlsx","n_sheets":12,"sheets":["Al_2009_10","Al_2010_11","Al_2011_12","Al_2012_13","Al_2013_14","Al_2014_15","AL_2015_16","AL_2016_17","AL_2017_18","Notes_and_History_+_Buttons","scratch for manipulation","Penalties_Given"],"not_rendered":{"macros":1,"defined_names":19},"read":"whole","date_system":"1900"}

{"sheet":"Al_2009_10","index":0,"n_rows":28,"n_cols":26,"rows_kept":28,"merged":[[3,4,3,5],[3,6,3,7],[3,8,3,9],[3,10,3,11],[3,12,3,13]]}
[]
[null,null,"ALBURY CUP RESULTS 2009/10",{"$nulls":9},"As at: ",{"$f":"TEXT(NOW(),\"d mmmm yyy\")","v":"13 November 2018"}]
[]
[null,"Albury Cup","Event >","Albury Points Best 4 from 5","Gazette Cup 4 miles",null,"Alec Potton 7 miles",null,"Christmas Cup 5 km",null,"SWC Open 10 km",null,"SWC Track 3 km",null,"Total Points",null,null,{"$f":"+C2","v":"ALBURY CUP RESULTS 2009/10"},null,{"$f":"+E28","v":0},{"$f":"+G28","v":0},{"$f":"+I28","v":0},{"$f":"+K28","v":0},{"$f":"+M28","v":0}]
[null,"Rank","Name    -  date>","after 3","   8/10/09",null,"  13/11/09",null,"  17/12/09",null,"    None",null,"    1/7/10",null,"  2009/10",null,null,"est acc name","Year Rank","Pos 1","Pos 2","Pos 3","Pos 4","Pos 5","Pos 6","Pos 7"]
[null,1,"Ian Statter",{"$f":"+O6-MIN(F6,H6,J6,L6,N6)","v":68},2,{"$f":"IF(ISBLANK(E6),0,F$23+1-E6)","v":24},4,{"$f":"IF(ISBLANK(G6),0,H$23+1-G6)","v":22},4,{"$f":"IF(ISBLANK(I6),0,J$23+1-I6)","v":22},null,{"$f":"IF(ISBLANK(K6),0,L$23+1-K6)","v":0},null,{"$f":"IF(ISBLANK(M6),0,N$23+1-M6)","v":0},{"$f":"+F6+H6+J6+L6+N6","v":68},null,null,{"$f":"RIGHT(C6,LEN(C6)-FIND(\" \",C6)) & \"_\" & LEFT(C6,FIND(\" \",C6)-1)","v":"Statter_Ian"},{"$f":"+B6","v":1},{"$f":"+E6","v":2},{"$f":"+G6","v":4},{"$f":"+I6","v":4},{"$f":"+K6","v":0},{"$f":"+M6","v":0}]
[null,{"$f":"+B6+1","v":2},"Dave Delaney",65,9,17,3,23,1,25,null,0,null,0,65,null,null,{"$f":"RIGHT(C7,LEN(C7)-FIND(\" \",C7)) & \"_\" & LEFT(C7,FIND(\" \",C7)-1)","v":"Delaney_Dave"},{"$f":"+B7","v":2},{"$f":"+E7","v":9},{"$f":"+G7","v":3},{"$f":"+I7","v":1},{"$f":"+K7","v":0},{"$f":"+M7","v":0}]
[null,3,"Peter Hannell",64,5,21,7,19,2,24,null,0,null,0,64,null,null,"Hannell_Peter",3,5,7,2,0,0]
[null,4,"David Hoben",61,1,25,9,17,7,19,null,0,null,0,61,null,null,"Hoben_David",4,1,9,7,0,0]
[null,5,"Peter Crane",59,6,20,6,20,7,19,null,0,null,0,59,null,null,"Crane_Peter",5,6,6,7,0,0]
[null,6,"Nolan Simmons",50,10,16,11,15,7,19,null,0,null,0,50,null,null,"Simmons_Nolan",6,10,11,7,0,0]
[null,7,"Mark Easton",47,3,23,2,24,null,0,null,0,null,0,47,null,null,"Easton_Mark",7,3,2,0,0,0]
[null,8,"Chris Flint",43,8,18,1,25,null,0,null,0,null,0,43,null,null,"Flint_Chris",8,8,1,0,0,0]
[null,9,"Bernard Imber",35,12,14,5,21,null,0,null,0,null,0,35,null,null,"Imber_Bernard",9,12,5,0,0,0]
[null,10,"Stephen Crane",29,11,15,12,14,null,0,null,0,null,0,29,null,null,"Crane_Stephen",10,11,12,0,0,0]
[null,11,"Gary MacDonald",23,null,0,null,0,3,23,null,0,null,0,23,null,null,"MacDonald_Gary",11,0,0,3,0,0]
[null,12,"Trevor Sliwerski",22,4,22,null,0,null,0,null,0,null,0,22,null,null,"Sliwerski_Trevor",12,4,0,0,0,0]
[null,13,"Andrew Statter",19,7,19,null,0,null,0,null,0,null,0,19,null,null,"Statter_Andrew",13,7,0,0,0,0]
[null,14,"Pam Ficken",19,null,0,null,0,7,19,null,0,null,0,19,null,null,"Ficken_Pam",14,0,0,7,0,0]
[null,15,"Mick Harran",18,null,0,8,18,null,0,null,0,null,0,18,null,null,"Harran_Mick",15,0,8,0,0,0]
[null,16,"Paul King",16,null,0,10,16,null,0,null,0,null,0,16,null,null,"King_Paul",16,0,10,0,0,0]
[]
[null,null,"SWC Number Out",null,{"$f":"+COUNT(E6:E21)","v":12},25,{"$f":"+COUNT(G6:G21)","v":12},25,{"$f":"+COUNT(I6:I21)","v":8},25,{"$f":"+COUNT(K6:K21)","v":0},25,{"$f":"+COUNT(M6:M21)","v":0},25]
[]
[]
[null,null,"Check total positions =",null,{"$f":"TEXT(SUM(E6:E21),\"0\")","v":"78"},null,{"$f":"TEXT(SUM(G6:G21),\"0\")","v":"78"},null,{"$f":"TEXT(SUM(I6:I21),\"0\")","v":"38"},null,{"$f":"TEXT(SUM(K6:K21),\"0\")","v":"0"},null,{"$f":"TEXT(SUM(M6:M21),\"0\")","v":"0"}]
[null,null,"If t = walkers then t*( t+1)/2 =",null,{"$f":"+E23*(E23+1)/2","v":78},null,{"$f":"+G23*(G23+1)/2","v":78},null,{"$f":"+I23*(I23+1)/2","v":36},null,{"$f":"+K23*(K23+1)/2","v":0},null,{"$f":"+M23*(M23+1)/2","v":0}]
[null,null,"Acc Event Number"]

{"sheet":"Al_2010_11","index":1,"n_rows":29,"n_cols":26,"rows_kept":29,"merged":[[3,4,3,5],[3,6,3,7],[3,8,3,9],[3,10,3,11],[3,12,3,13]]}
[]
[null,null,"ALBURY CUP RESULTS 2010/11",{"$nulls":3},"NOT 10/11 results!!",{"$nulls":5},"As at: ",{"$f":"TEXT(NOW(),\"d mmmm yyy\")","v":"13 November 2018"}]
[]
[null,"Albury Cup","Event >","Albury Points Best 4 from 5","Gazette Cup 4 miles",null,"Alec Potton 7 miles",null,"Christmas Cup 5 km",null,"SWC Open 10 km",null,"SWC Track 3 km",null,"Total Points",null,null,{"$f":"+C2","v":"ALBURY CUP RESULTS 2010/11"},null,{"$f":"+E28","v":0},{"$f":"+G28","v":0},{"$f":"+I28","v":0},{"$f":"+K28","v":0},{"$f":"+M28","v":0}]
[null,"Rank","Name    -  date>","after 3","  06/10/13",null,"  06/10/13",null,"  06/10/13",null,"  March 14",null,"  25/6/14",null,"  2013/14",null,null,"est acc name","Year Rank","Pos 1","Pos 2","Pos 3","Pos 4","Pos 5","Pos 6","Pos 7"]
[null,1,"Dave Delaney",{"$f":"+O6-MIN(F6,H6,J6,L6,N6)","v":0},null,{"$f":"IF(ISBLANK(E6),0,F$24+1-E6)","v":0},null,{"$f":"IF(ISBLANK(G6),0,H$24+1-G6)","v":0},null,{"$f":"IF(ISBLANK(I6),0,J$24+1-I6)","v":0},null,{"$f":"IF(ISBLANK(K6),0,L$24+1-K6)","v":0},null,{"$f":"IF(ISBLANK(M6),0,N$24+1-M6)","v":0},{"$f":"+F6+H6+J6+L6+N6","v":0},null,null,{"$f":"RIGHT(C6,LEN(C6)-FIND(\" \",C6)) & \"_\" & LEFT(C6,FIND(\" \",C6)-1)","v":"Delaney_Dave"},{"$f":"+B6","v":1},{"$f":"+E6","v":0},{"$f":"+G6","v":0},{"$f":"+I6","v":0},{"$f":"+K6","v":0},{"$f":"+M6","v":0}]
[null,{"$f":"+B6+1","v":2},"David Hoben",0,null,0,null,0,null,0,null,0,null,0,0,null,null,{"$f":"RIGHT(C7,LEN(C7)-FIND(\" \",C7)) & \"_\" & LEFT(C7,FIND(\" \",C7)-1)","v":"Hoben_David"},{"$f":"+B7","v":2},{"$f":"+E7","v":0},{"$f":"+G7","v":0},{"$f":"+I7","v":0},{"$f":"+K7","v":0},{"$f":"+M7","v":0}]
[null,{"$f":"+B7+1","v":3},"Trevor Sliwerski",0,null,0,null,0,null,0,null,0,null,0,0,null,null,"Sliwerski_Trevor",3,0,0,0,0,0]
[null,4,"Peter Hannell",0,null,0,null,0,null,0,null,0,null,0,0,null,null,"Hannell_Peter",4,0,0,0,0,0]
[null,5,"Bernard Imber",0,null,0,null,0,null,0,null,0,null,0,0,null,null,"Imber_Bernard",5,0,0,0,0,0]
[null,6,"Andrew Statter",0,null,0,null,0,null,0,null,0,null,0,0,null,null,"Statter_Andrew",6,0,0,0,0,0]
[null,7,"Stephen Crane",0,null,0,null,0,null,0,null,0,null,0,0,null,null,"Crane_Stephen",7,0,0,0,0,0]
[null,8,"Gary MacDonald",0,null,0,null,0,null,0,null,0,null,0,0,null,null,"MacDonald_Gary",8,0,0,0,0,0]
[null,9,"Chris Flint",0,null,0,null,0,null,0,null,0,null,0,0,null,null,"Flint_Chris",9,0,0,0,0,0]
[null,10,"Pam Ficken",{"$f":"+O15-MIN(F15,H15,J15,L15,N15)","v":0},null,0,null,0,null,0,null,0,null,0,{"$f":"+F15+H15+J15+L15+N15","v":0},null,null,"Ficken_Pam",10,0,0,0,0,0]
[null,11,"Mark Easton",0,null,{"$f":"IF(ISBLANK(E16),0,F$24+1-E16)","v":0},null,{"$f":"IF(ISBLANK(G16),0,H$24+1-G16)","v":0},null,{"$f":"IF(ISBLANK(I16),0,J$24+1-I16)","v":0},null,{"$f":"IF(ISBLANK(K16),0,L$24+1-K16)","v":0},null,{"$f":"IF(ISBLANK(M16),0,N$24+1-M16)","v":0},0,null,null,"Easton_Mark",11,0,0,0,0,0]
[null,12,"Mick Harran",0,null,{"$f":"IF(ISBLANK(E17),0,F$24+1-E17)","v":0},null,{"$f":"IF(ISBLANK(G17),0,H$24+1-G17)","v":0},null,{"$f":"IF(ISBLANK(I17),0,J$24+1-I17)","v":0},null,{"$f":"IF(ISBLANK(K17),0,L$24+1-K17)","v":0},null,{"$f":"IF(ISBLANK(M17),0,N$24+1-M17)","v":0},0,null,null,"Harran_Mick",12,0,0,0,0,0]
[null,13,"Ian Statter",0,null,0,null,0,null,0,null,0,null,0,0,null,null,"Statter_Ian",13,0,0,0,0,0]
[null,14,"Peter Crane",0,null,0,null,0,null,0,null,0,null,0,0,null,null,"Crane_Peter",14,0,0,0,0,0]
[null,15,"Paul King",0,null,0,null,0,null,0,null,0,null,0,0,null,null,"King_Paul",15,0,0,0,0,0]
[null,16,"Kevin Burnett",0,null,0,null,0,null,0,null,0,null,0,0,null,null,"Burnett_Kevin",16,0,0,0,0,0]
[null,17,"Nolan Simmons",0,null,0,null,0,null,0,null,0,null,0,0,null,null,{"$f":"RIGHT(C22,LEN(C22)-FIND(\" \",C22)) & \"_\" & LEFT(C22,FIND(\" \",C22)-1)","v":"Simmons_Nolan"},{"$f":"+B22","v":17},{"$f":"+E22","v":0},{"$f":"+G22","v":0},{"$f":"+I22","v":0},{"$f":"+K22","v":0},{"$f":"+M22","v":0}]
[]
[null,null,"SWC Number Out",null,{"$f":"+MAX(E6:E22)","v":0},25,{"$f":"+MAX(G6:G22)","v":0},25,0,25,0,25,0,25]
[]
[]
[null,null,"Check total positions =",null,{"$f":"TEXT(SUM(E7:E22),\"0\")","v":"0"},null,{"$f":"TEXT(SUM(G7:G22),\"0\")","v":"0"},null,{"$f":"TEXT(SUM(I7:I22),\"0\")","v":"0"},null,{"$f":"TEXT(SUM(K7:K22),\"0\")","v":"0"},null,{"$f":"TEXT(SUM(M7:M22),\"0\")","v":"0"}]
[null,null,"If t = walkers then t*( t+1)/2 =",null,{"$f":"+E24*(E24+1)/2","v":0},null,{"$f":"+G24*(G24+1)/2","v":0},null,{"$f":"+I24*(I24+1)/2","v":0},null,{"$f":"+K24*(K24+1)/2","v":0},null,{"$f":"+M24*(M24+1)/2","v":0}]
[null,null,"Acc Event Number",null,26,null,29,null,31,null,32,null,78]

{"sheet":"Al_2011_12","index":2,"n_rows":30,"n_cols":24,"rows_kept":30,"merged":[[3,4,3,5],[3,6,3,7],[3,8,3,9],[3,10,3,11],[3,12,3,13]]}
[]
[null,null,"ALBURY CUP RESULTS 2011/12",{"$nulls":9},"As at: ",{"$f":"TEXT(NOW(),\"d mmmm yyy\")","v":"13 November 2018"}]
[]
[null,"Albury Cup","Event >","Albury Points Best 4 from 5","Gazette Cup 4 miles",null,"Alec Potton 7 miles",null,"Christmas Cup 5 km",null,"SWC Open 10 km",null,"SWC Track 3 km",null,"Total Points",null,null,{"$f":"+C2","v":"ALBURY CUP RESULTS 2011/12"},null,{"$f":"+E30","v":101},{"$f":"+G30","v":105},{"$f":"+I30","v":108},{"$f":"+K30","v":112},{"$f":"+M30","v":141}]
[null,"Rank","Name    -  date>","after 4","  15/10/11",null,"  06/11/11",null,"  10/12/11",null,"No Hcp",null,"  06/06/12",null,"  2011/12",null,null,"est acc name","Year Rank",{"$f":"+E5","v":"  15/10/11"},{"$f":"+G5","v":"  06/11/11"},{"$f":"+I5","v":"  10/12/11"},{"$f":"+K5","v":"No Hcp"},{"$f":"+M5","v":"  06/06/12"}]
[null,1,"Dave Delaney",{"$f":"+O6-MIN(F6,H6,J6,L6,N6)","v":84},1,{"$f":"IF(ISBLANK(E6),0,F$25+1-E6)","v":25},2,{"$f":"IF(ISBLANK(G6),0,H$25+1-G6)","v":24},11,{"$f":"IF(ISBLANK(I6),0,J$25+1-I6)","v":15},null,{"$f":"IF(ISBLANK(K6),0,L$25+1-K6)","v":0},6,{"$f":"IF(ISBLANK(M6),0,N$25+1-M6)","v":20},{"$f":"+F6+H6+J6+L6+N6","v":84},null,null,{"$f":"RIGHT(C6,LEN(C6)-FIND(\" \",C6)) & \"_\" & LEFT(C6,FIND(\" \",C6)-1)","v":"Delaney_Dave"},{"$f":"+B6","v":1},{"$f":"+E6","v":1},{"$f":"+G6","v":2},{"$f":"+I6","v":11},{"$f":"+K6","v":0},{"$f":"+M6","v":6}]
[null,{"$f":"+B6+1","v":2},"Shaun Lightman",82,11,15,4,22,4,22,null,0,3,23,82,null,null,{"$f":"RIGHT(C7,LEN(C7)-FIND(\" \",C7)) & \"_\" & LEFT(C7,FIND(\" \",C7)-1)","v":"Lightman_Shaun"},{"$f":"+B7","v":2},{"$f":"+E7","v":11},{"$f":"+G7","v":4},{"$f":"+I7","v":4},{"$f":"+K7","v":0},{"$f":"+M7","v":3}]
[null,{"$f":"+B7+1","v":3},"Mark Easton",65,4,22,7,19,2,24,null,0,null,0,65,null,null,"Easton_Mark",3,4,7,2,0,0]
[null,4,"Ian Statter",65,3,23,5,21,5,21,null,0,null,0,65,null,null,"Statter_Ian",4,3,5,5,0,0]
[null,5,"Peter Hannell",62,8,18,3,23,null,0,null,0,5,21,62,null,null,"Hannell_Peter",5,8,3,0,0,5]
[null,6,"Kathy Crilley",59,9,17,1,25,9,17,null,0,null,0,59,null,null,"Crilley_Kathy",6,9,1,9,0,0]
[null,7,"David Hoben",56,6,20,null,0,12,14,null,0,4,22,56,null,null,"Hoben_David",7,6,0,12,0,4]
[null,8,"Peter Crane",52,5,21,8,18,13,13,null,0,null,0,52,null,null,"Crane_Peter",8,5,8,13,0,0]
[null,9,"Kevin Burnett",47,null,0,null,0,3,23,null,0,2,24,47,null,null,"Burnett_Kevin",9,0,0,3,0,2]
[null,10,"Paul King",38,null,0,6,20,8,18,null,0,null,0,38,null,null,"King_Paul",10,0,6,8,0,0]
[null,11,"David Crane",37,null,0,null,0,14,12,null,0,1,25,37,null,null,"Crane_David",11,0,0,14,0,1]
[null,12,"Mick Harran",33,null,0,9,17,10,16,null,0,null,0,33,null,null,"Harran_Mick",12,0,9,10,0,0]
[null,13,"Chris Flint",30,7,19,null,0,15,11,null,0,null,0,30,null,null,"Flint_Chris",13,7,0,15,0,0]
[null,14,"Lyn Atterbury",25,null,0,null,0,1,25,null,0,null,0,25,null,null,"Atterbury_Lyn",14,0,0,1,0,0]
[null,15,"Pam Ficken",24,2,24,null,0,null,0,null,0,null,0,24,null,null,"Ficken_Pam",15,2,0,0,0,0]
[null,16,"Andrew Statter",20,null,0,null,0,6,20,null,0,null,0,20,null,null,"Statter_Andrew",16,0,0,6,0,0]
[null,17,"Bernard Imber",19,null,0,null,0,7,19,null,0,null,0,19,null,null,{"$f":"RIGHT(C22,LEN(C22)-FIND(\" \",C22)) & \"_\" & LEFT(C22,FIND(\" \",C22)-1)","v":"Imber_Bernard"},{"$f":"+B22","v":17},{"$f":"+E22","v":0},{"$f":"+G22","v":0},{"$f":"+I22","v":7},{"$f":"+K22","v":0},{"$f":"+M22","v":0}]
[null,18,"Steve Crane",16,10,16,null,0,null,0,null,0,null,0,16,null,null,"Crane_Steve",18,10,0,0,0,0]
[]
[null,null,"SWC Number Out",null,{"$f":"+COUNT(E6:E23)","v":11},25,{"$f":"+COUNT(G6:G23)","v":9},25,{"$f":"+COUNT(I6:I23)","v":15},25,{"$f":"+COUNT(K6:K23)","v":0},25,{"$f":"+COUNT(M6:M23)","v":6},25]
[]
[]
[null,null,"Check total positions =",null,{"$f":"TEXT(SUM(E6:E23),\"0\")","v":"66"},null,{"$f":"TEXT(SUM(G6:G23),\"0\")","v":"45"},null,{"$f":"TEXT(SUM(I6:I23),\"0\")","v":"120"},null,{"$f":"TEXT(SUM(K6:K23),\"0\")","v":"0"},null,{"$f":"TEXT(SUM(M6:M23),\"0\")","v":"21"}]
[null,null,"If t = walkers then t*( t+1)/2 =",null,{"$f":"+E25*(E25+1)/2","v":66},null,{"$f":"+G25*(G25+1)/2","v":45},null,{"$f":"+I25*(I25+1)/2","v":120},null,{"$f":"+K25*(K25+1)/2","v":0},null,{"$f":"+M25*(M25+1)/2","v":21}]
[null,null,"Acc Event Number",null,101,null,105,null,108,null,112,null,141]

{"sheet":"Al_2012_13","index":3,"n_rows":24,"n_cols":24,"rows_kept":24,"merged":[[3,4,3,5],[3,6,3,7],[3,8,3,9],[3,10,3,11],[3,12,3,13]]}
[]
[null,null,"ALBURY CUP RESULTS 2012/13",{"$nulls":9},"As at: ",{"$f":"TEXT(NOW(),\"d mmmm yyy\")","v":"13 November 2018"}]
[]
[null,"Albury Cup","Event >","Albury Points Best 4 from 5","Gazette Cup 4 miles",null,"Alec Potton 7 miles",null,"Christmas Cup 5 km",null,"SWC Open 10 km",null,"SWC Track 3 km",null,"Total Points",null,null,{"$f":"+C2","v":"ALBURY CUP RESULTS 2012/13"},null,{"$f":"+E24","v":183},{"$f":"+G24","v":189},{"$f":"+I24","v":195},{"$f":"+K24","v":198},{"$f":"+M24","v":238}]
[null,"Rank","Name    -  date>","after 5"," 20/10/12",null," 03/11/12",null,"  08/12/12",null,"  05/01/13",null,"  12/6/13",null,"  2012/13",null,null,"est acc name","Year Rank",{"$f":"+E5","v":" 20/10/12"},{"$f":"+G5","v":" 03/11/12"},{"$f":"+I5","v":"  08/12/12"},{"$f":"+K5","v":"  05/01/13"},{"$f":"+M5","v":"  12/6/13"}]
[null,1,"Paul King",{"$f":"+O6-MIN(F6,H6,J6,L6,N6)","v":91},3,{"$f":"IF(ISBLANK(E6),0,F$19+1-E6)","v":23},2,{"$f":"IF(ISBLANK(G6),0,H$19+1-G6)","v":24},7,{"$f":"IF(ISBLANK(I6),0,J$19+1-I6)","v":19},1,{"$f":"IF(ISBLANK(K6),0,L$19+1-K6)","v":25},null,{"$f":"IF(ISBLANK(M6),0,N$19+1-M6)","v":0},{"$f":"+F6+H6+J6+L6+N6","v":91},null,null,{"$f":"RIGHT(C6,LEN(C6)-FIND(\" \",C6)) & \"_\" & LEFT(C6,FIND(\" \",C6)-1)","v":"King_Paul"},{"$f":"+B6","v":1},{"$f":"+E6","v":3},{"$f":"+G6","v":2},{"$f":"+I6","v":7},{"$f":"+K6","v":1},{"$f":"+M6","v":0}]
[null,{"$f":"+B6+1","v":2},"David Crane",90,10,16,5,21,1,25,6,20,2,24,106,null,null,{"$f":"RIGHT(C7,LEN(C7)-FIND(\" \",C7)) & \"_\" & LEFT(C7,FIND(\" \",C7)-1)","v":"Crane_David"},{"$f":"+B7","v":2},{"$f":"+E7","v":10},{"$f":"+G7","v":5},{"$f":"+I7","v":1},{"$f":"+K7","v":6},{"$f":"+M7","v":2}]
[null,{"$f":"+B7+1","v":3},"David Hoben",86,8,18,4,22,6,20,5,21,3,23,104,null,null,"Hoben_David",3,8,4,6,5,3]
[null,4,"Chris Flint",85,1,25,7,19,9,17,2,24,null,0,85,null,null,"Flint_Chris",4,1,7,9,2,0]
[null,5,"Ian Statter",84,6,20,9,17,4,22,null,0,1,25,84,null,null,"Statter_Ian",5,6,9,4,0,1]
[null,6,"Shaun Lightman",82,11,15,3,23,3,23,null,0,5,21,82,null,null,"Lightman_Shaun",6,11,3,3,0,5]
[null,7,"Peter Crane",82,9,17,1,25,8,18,7,19,6,20,99,null,null,"Crane_Peter",7,9,1,8,7,6]
[null,8,"Dave Delaney",73,7,19,11,15,5,21,8,18,null,0,73,null,null,"Delaney_Dave",8,7,11,5,8,0]
[null,9,"Peter Hannell",62,null,0,10,16,2,24,null,0,4,22,62,null,null,"Hannell_Peter",9,0,10,2,0,4]
[null,10,"Mick Harran",62,5,21,8,18,null,0,3,23,null,0,62,null,null,"Harran_Mick",10,5,8,0,3,0]
[null,11,"Kathy Crilley",58,4,22,12,14,null,0,4,22,null,0,58,null,null,"Crilley_Kathy",11,4,12,0,4,0]
[null,12,"Mark Easton",44,2,24,6,20,null,0,null,0,null,0,44,null,null,"Easton_Mark",12,2,6,0,0,0]
[]
[null,null,"SWC Number Out",null,{"$f":"+MAX(E6:E17)","v":11},25,{"$f":"+MAX(G6:G17)","v":12},25,9,25,8,25,6,25]
[]
[]
[null,null,"Check total positions =",null,{"$f":"TEXT(SUM(E5:E17),\"0\")","v":"66"},null,{"$f":"TEXT(SUM(G5:G17),\"0\")","v":"78"},null,{"$f":"TEXT(SUM(I5:I17),\"0\")","v":"45"},null,{"$f":"TEXT(SUM(K5:K17),\"0\")","v":"36"},null,{"$f":"TEXT(SUM(M5:M17),\"0\")","v":"21"}]
[null,null,"If t = walkers then t*( t+1)/2 =",null,{"$f":"+E19*(E19+1)/2","v":66},null,{"$f":"+G19*(G19+1)/2","v":78},null,{"$f":"+I19*(I19+1)/2","v":45},null,{"$f":"+K19*(K19+1)/2","v":36},null,{"$f":"+M19*(M19+1)/2","v":21}]
[null,null,"Acc Event Number",null,183,null,189,null,195,null,198,null,238]

{"sheet":"Al_2013_14","index":4,"n_rows":30,"n_cols":35,"rows_kept":30,"merged":[[3,4,3,5],[3,6,3,7],[3,8,3,9],[3,10,3,11],[3,12,3,13]]}
[]
[null,null,"ALBURY CUP RESULTS 2013/14",{"$nulls":9},"As at: ",{"$f":"TEXT(NOW(),\"d mmmm yyy\")","v":"13 November 2018"}]
[{"$nulls":18},"Compressed Copy of Results for transfer to history stage 1 (Table Compressed_13_14)",{"$nulls":9},"Results for transfer to history stage 2. cols AC to last race to be copied(123) to History sheet"]
[null,"Albury Cup","Event >","Albury Points Best 4 from 5","Gazette Cup 4 miles",null,"Alec Potton 7 miles",null,"Christmas Cup 5 km",null,"SWC Open 10 km",null,"SWC Track 3 km",null,"Total Points","Races Walked",null,null,{"$f":"+C2","v":"ALBURY CUP RESULTS 2013/14"},null,{"$f":"+E30","v":283},{"$f":"+G30","v":289},{"$f":"+I30","v":298},322,{"$f":"+M30","v":372}]
[null,"Rank","Name    -  date>","after 5","  06/10/13",null,"  3/11/13",null,"  21/12/13",null,"  29/03/14",null,"  04/06/14",null," 2013/14",{"$f":"+O5","v":" 2013/14"},null,null,"Athlete Key","Year Rank",{"$f":"+E5","v":"  06/10/13"},{"$f":"+G5","v":"  3/11/13"},{"$f":"+I5","v":"  21/12/13"},{"$f":"+K5","v":"  29/03/14"},{"$f":"+M5","v":"  04/06/14"},"Pos 6","Pos 7",null,"Keys from History Table",{"$f":"+T5","v":"Year Rank"},{"$f":"+U5","v":"  06/10/13"},"  3/11/13","  21/12/13","  29/03/14","  04/06/14"]
[null,1,"Malcolm Martin",{"$f":"+O6-MIN(F6,H6,J6,L6,N6)","v":87},4,{"$f":"IF(ISBLANK(E6),0,F$27+1-E6)","v":22},4,22,6,{"$f":"IF(ISBLANK(I6),0,J$27+1-I6)","v":20},6,{"$f":"IF(ISBLANK(K6),0,L$27+1-K6)","v":20},3,{"$f":"IF(ISBLANK(M6),0,N$27+1-M6)","v":23},{"$f":"+F6+H6+J6+L6+N6","v":107},{"$f":"+COUNT(E6,G6,I6,K6,M6)","v":5},null,null,{"$f":"RIGHT(C6,LEN(C6)-FIND(\" \",C6)) & \"_\" & LEFT(C6,FIND(\" \",C6)-1)","v":"Martin_Malcolm"},{"$f":"+B6","v":1},{"$f":"+E6","v":4},{"$f":"+G6","v":4},{"$f":"+I6","v":6},{"$f":"+K6","v":6},{"$f":"+M6","v":3},{"$nulls":3},{"$f":"+'Notes_and_History_+_Buttons'!A25","v":"Atterbury_Lyn"},{"$f":"IF(ISERROR(VLOOKUP($AC6,Compressed_13_14,2,FALSE)),0,VLOOKUP($AC6,Compressed_13_14,2,FALSE))","v":0},{"$f":"IF(ISERROR(VLOOKUP($AC6,Compressed_13_14,3,FALSE)),0,VLOOKUP($AC6,Compressed_13_14,3,FALSE))","v":0},{"$f":"IF(ISERROR(VLOOKUP($AC6,Compressed_13_14,4,FALSE)),0,VLOOKUP($AC6,Compressed_13_14,4,FALSE))","v":0},{"$f":"IF(ISERROR(VLOOKUP($AC6,Compressed_13_14,5,FALSE)),0,VLOOKUP($AC6,Compressed_13_14,5,FALSE))","v":0},{"$f":"IF(ISERROR(VLOOKUP($AC6,Compressed_13_14,6,FALSE)),0,VLOOKUP($AC6,Compressed_13_14,6,FALSE))","v":0},{"$f":"IF(ISERROR(VLOOKUP($AC6,Compressed_13_14,7,FALSE)),0,VLOOKUP($AC6,Compressed_13_14,7,FALSE))","v":0}]
[null,{"$f":"+B6+1","v":2},"Angela Martin",79,10,16,5,21,7,{"$f":"IF(ISBLANK(I7),0,J$27+1-I7)","v":19},5,{"$f":"IF(ISBLANK(K7),0,L$27+1-K7)","v":21},8,{"$f":"IF(ISBLANK(M7),0,N$27+1-M7)","v":18},95,{"$f":"+COUNT(E7,G7,I7,K7,M7)","v":5},null,null,{"$f":"RIGHT(C7,LEN(C7)-FIND(\" \",C7)) & \"_\" & LEFT(C7,FIND(\" \",C7)-1)","v":"Martin_Angela"},{"$f":"+B7","v":2},{"$f":"+E7","v":10},{"$f":"+G7","v":5},{"$f":"+I7","v":7},{"$f":"+K7","v":5},{"$f":"+M7","v":8},{"$nulls":3},{"$f":"+'Notes_and_History_+_Buttons'!A26","v":"Brown_Sandra"},12,0,0,0,4,5]
[null,{"$f":"+B7+1","v":3},"Dave Delaney",70,1,25,6,20,1,{"$f":"IF(ISBLANK(I8),0,J$27+1-I8)","v":25},null,{"$f":"IF(ISBLANK(K8),0,L$27+1-K8)","v":0},null,{"$f":"IF(ISBLANK(M8),0,N$27+1-M8)","v":0},70,3,null,null,"Delaney_Dave",3,1,6,1,0,0,{"$nulls":3},{"$f":"+'Notes_and_History_+_Buttons'!A27","v":"Burnett_Kevin"},14,9,0,0,0,6]
[null,4,"David Hoben",68,6,20,1,25,3,{"$f":"IF(ISBLANK(I9),0,J$27+1-I9)","v":23},null,{"$f":"IF(ISBLANK(K9),0,L$27+1-K9)","v":0},null,{"$f":"IF(ISBLANK(M9),0,N$27+1-M9)","v":0},68,3,null,null,"Hoben_David",4,6,1,3,0,0,{"$nulls":3},{"$f":"+'Notes_and_History_+_Buttons'!A28","v":"Campbell_Sandra"},10,0,0,0,2,4]
[null,5,"Dan Maskell",66,3,23,2,24,null,{"$f":"IF(ISBLANK(I10),0,J$27+1-I10)","v":0},null,{"$f":"IF(ISBLANK(K10),0,L$27+1-K10)","v":0},7,{"$f":"IF(ISBLANK(M10),0,N$27+1-M10)","v":19},66,3,null,null,"Maskell_Dan",5,3,2,0,0,7,{"$nulls":3},{"$f":"+'Notes_and_History_+_Buttons'!A29","v":"Crane_David"},8,12,12,2,0,0]
[null,6,"Chris Flint",61,null,0,11,15,5,{"$f":"IF(ISBLANK(I11),0,J$27+1-I11)","v":21},1,{"$f":"IF(ISBLANK(K11),0,L$27+1-K11)","v":25},null,{"$f":"IF(ISBLANK(M11),0,N$27+1-M11)","v":0},61,3,null,null,"Flint_Chris",6,0,11,5,1,0,{"$nulls":3},{"$f":"+'Notes_and_History_+_Buttons'!A30","v":"Crane_Peter"},9,0,0,4,0,1]
[null,7,"Shaun Lightman",61,null,0,7,19,8,{"$f":"IF(ISBLANK(I12),0,J$27+1-I12)","v":18},null,{"$f":"IF(ISBLANK(K12),0,L$27+1-K12)","v":0},2,{"$f":"IF(ISBLANK(M12),0,N$27+1-M12)","v":24},61,3,null,null,"Lightman_Shaun",7,0,7,8,0,2,{"$nulls":3},{"$f":"+'Notes_and_History_+_Buttons'!A31","v":"Crane_Steve"},0,0,0,0,0,0]
[null,8,"David Crane",52,12,14,12,14,2,{"$f":"IF(ISBLANK(I13),0,J$27+1-I13)","v":24},null,{"$f":"IF(ISBLANK(K13),0,L$27+1-K13)","v":0},null,{"$f":"IF(ISBLANK(M13),0,N$27+1-M13)","v":0},52,3,null,null,"Crane_David",8,12,12,2,0,0,{"$nulls":3},{"$f":"+'Notes_and_History_+_Buttons'!A32","v":"Crilley_Kathy"},11,5,3,0,0,0]
[null,9,"Peter Crane",47,null,0,null,0,4,{"$f":"IF(ISBLANK(I14),0,J$27+1-I14)","v":22},null,{"$f":"IF(ISBLANK(K14),0,L$27+1-K14)","v":0},1,{"$f":"IF(ISBLANK(M14),0,N$27+1-M14)","v":25},47,2,null,null,"Crane_Peter",9,0,0,4,0,1,{"$nulls":3},{"$f":"+'Notes_and_History_+_Buttons'!A33","v":"Delaney_Dave"},3,1,6,1,0,0]
[null,10,"Sandra Campbell",46,null,0,null,0,null,{"$f":"IF(ISBLANK(I15),0,J$27+1-I15)","v":0},2,{"$f":"IF(ISBLANK(K15),0,L$27+1-K15)","v":24},4,{"$f":"IF(ISBLANK(M15),0,N$27+1-M15)","v":22},46,2,null,null,"Campbell_Sandra",10,0,0,0,2,4,{"$nulls":3},{"$f":"+'Notes_and_History_+_Buttons'!A34","v":"Easton_Mark"},15,8,9,0,0,0]
[null,11,"Kathy Crilley",44,5,21,3,23,null,{"$f":"IF(ISBLANK(I16),0,J$27+1-I16)","v":0},null,{"$f":"IF(ISBLANK(K16),0,L$27+1-K16)","v":0},null,{"$f":"IF(ISBLANK(M16),0,N$27+1-M16)","v":0},44,2,null,null,"Crilley_Kathy",11,5,3,0,0,0,{"$nulls":3},{"$f":"+'Notes_and_History_+_Buttons'!A35","v":"Edwards_Chris"},0,0,0,0,0,0]
[null,12,"Sandra Brown",43,null,0,null,0,null,{"$f":"IF(ISBLANK(I17),0,J$27+1-I17)","v":0},4,{"$f":"IF(ISBLANK(K17),0,L$27+1-K17)","v":22},5,{"$f":"IF(ISBLANK(M17),0,N$27+1-M17)","v":21},43,2,null,null,"Brown_Sandra",12,0,0,0,4,5,{"$nulls":3},{"$f":"+'Notes_and_History_+_Buttons'!A36","v":"Ficken_Pam"},0,0,0,0,0,0]
[null,13,"Paul King",41,null,0,8,18,null,{"$f":"IF(ISBLANK(I18),0,J$27+1-I18)","v":0},3,{"$f":"IF(ISBLANK(K18),0,L$27+1-K18)","v":23},null,{"$f":"IF(ISBLANK(M18),0,N$27+1-M18)","v":0},41,2,null,null,"King_Paul",13,0,8,0,3,0,{"$nulls":3},{"$f":"+'Notes_and_History_+_Buttons'!A38","v":"Gaston_Paul"},0,0,0,0,0,0]
[null,14,"Kevin Burnett",37,9,17,null,0,null,{"$f":"IF(ISBLANK(I19),0,J$27+1-I19)","v":0},null,{"$f":"IF(ISBLANK(K19),0,L$27+1-K19)","v":0},6,{"$f":"IF(ISBLANK(M19),0,N$27+1-M19)","v":20},37,2,null,null,"Burnett_Kevin",14,9,0,0,0,6,{"$nulls":3},{"$f":"+'Notes_and_History_+_Buttons'!A39","v":"Hannell_Peter"},0,0,0,0,0,0]
[null,15,"Mark Easton",35,8,18,9,17,null,{"$f":"IF(ISBLANK(I20),0,J$27+1-I20)","v":0},null,{"$f":"IF(ISBLANK(K20),0,L$27+1-K20)","v":0},null,{"$f":"IF(ISBLANK(M20),0,N$27+1-M20)","v":0},35,2,null,null,{"$f":"RIGHT(C20,LEN(C20)-FIND(\" \",C20)) & \"_\" & LEFT(C20,FIND(\" \",C20)-1)","v":"Easton_Mark"},{"$f":"+B20","v":15},{"$f":"+E20","v":8},{"$f":"+G20","v":9},{"$f":"+I20","v":0},{"$f":"+K20","v":0},{"$f":"+M20","v":0},{"$nulls":3},{"$f":"+'Notes_and_History_+_Buttons'!A40","v":"Harran_Mick"},16,7,10,0,0,0]
[null,16,"Mick Harran",35,7,19,10,16,null,{"$f":"IF(ISBLANK(I21),0,J$27+1-I21)","v":0},null,{"$f":"IF(ISBLANK(K21),0,L$27+1-K21)","v":0},null,{"$f":"IF(ISBLANK(M21),0,N$27+1-M21)","v":0},35,2,null,null,"Harran_Mick",16,7,10,0,0,0,{"$nulls":3},{"$f":"+'Notes_and_History_+_Buttons'!A41","v":"Hoben_David"},4,6,1,3,0,0]
[null,17,"Ian Statter",24,2,24,null,0,null,{"$f":"IF(ISBLANK(I22),0,J$27+1-I22)","v":0},null,{"$f":"IF(ISBLANK(K22),0,L$27+1-K22)","v":0},null,{"$f":"IF(ISBLANK(M22),0,N$27+1-M22)","v":0},24,1,null,null,"Statter_Ian",17,2,0,0,0,0,{"$nulls":3},{"$f":"+'Notes_and_History_+_Buttons'!A42","v":"Imber_Bernard"},0,0,0,0,0,0]
[null,{"$f":"+B22+1","v":18},"Nolan Simmons",15,11,{"$f":"IF(ISBLANK(E23),0,F$27+1-E23)","v":15},null,{"$f":"IF(ISBLANK(G23),0,H$27+1-G23)","v":0},null,{"$f":"IF(ISBLANK(I23),0,J$27+1-I23)","v":0},null,{"$f":"IF(ISBLANK(K23),0,L$27+1-K23)","v":0},null,{"$f":"IF(ISBLANK(M23),0,N$27+1-M23)","v":0},15,1,null,null,"Simmons_Nolan",18,11,0,0,0,0,{"$nulls":3},{"$f":"+'Notes_and_History_+_Buttons'!A43","v":"King_Paul"},13,0,8,0,3,0]
[{"$nulls":28},{"$f":"+'Notes_and_History_+_Buttons'!A44","v":"Lightman_Shaun"},7,0,7,8,0,2]
[null,null,"SWC Number Out",null,{"$f":"+COUNT(E6:E23)","v":12},null,{"$f":"+COUNT(G6:G23)","v":12},null,{"$f":"+COUNT(I6:I23)","v":8},null,{"$f":"+COUNT(K6:K23)","v":6},null,{"$f":"+COUNT(M6:M23)","v":8},{"$nulls":15},{"$f":"+'Notes_and_History_+_Buttons'!A45","v":"Martin_Angela"},2,10,5,7,5,8]
[{"$nulls":28},{"$f":"+'Notes_and_History_+_Buttons'!A46","v":"Martin_Malcolm"},1,4,4,6,6,3]
[null,null,"Winning score",null,null,25,null,25,null,25,null,25,null,25,{"$nulls":14},{"$f":"+'Notes_and_History_+_Buttons'!A48","v":"Michell_Roger"},0,0,0,0,0,0]
[null,null,"Check total positions =",null,{"$f":"TEXT(SUM(E6:E23),\"0\")","v":"78"},null,{"$f":"TEXT(SUM(G6:G23),\"0\")","v":"78"},null,{"$f":"TEXT(SUM(I6:I23),\"0\")","v":"36"},null,{"$f":"TEXT(SUM(K6:K23),\"0\")","v":"21"},null,{"$f":"TEXT(SUM(M6:M23),\"0\")","v":"36"},{"$nulls":15},{"$f":"+'Notes_and_History_+_Buttons'!A49","v":"Simmons_Nolan"},18,11,0,0,0,0]
[null,null,"If t = walkers then t*( t+1)/2 =",null,{"$f":"+E25*(E25+1)/2","v":78},null,{"$f":"+G25*(G25+1)/2","v":78},null,{"$f":"+I25*(I25+1)/2","v":36},null,{"$f":"+K25*(K25+1)/2","v":21},null,{"$f":"+M25*(M25+1)/2","v":36},{"$nulls":15},{"$f":"+'Notes_and_History_+_Buttons'!A50","v":"Sliwerski_Trevor"},0,0,0,0,0,0]
[null,null,"Acc Event Number",null,283,null,289,null,298,{"$nulls":3},372,{"$nulls":15},{"$f":"+'Notes_and_History_+_Buttons'!A52","v":"Statter_Ian"},17,2,0,0,0,0]

{"sheet":"Al_2014_15","index":5,"n_rows":84,"n_cols":32,"rows_kept":84,"merged":[[3,4,3,5],[3,6,3,7],[3,8,3,9],[3,10,3,11],[3,12,3,13],[61,4,61,5],[61,6,61,7],[61,8,61,9],[61,10,61,11],[61,12,61,13]]}
[]
[null,null,"ALBURY CUP RESULTS 2014/15",{"$nulls":5},"FINAL",{"$nulls":3},"As at: ","8 August 2015",{"$nulls":3},"NB Change Ranges Each Year: Table_For_History_Unsorted and Table_For_History_Sorted"]
[{"$nulls":17},"Copy of table with columns for history in correct order",{"$nulls":7},"Copy of table (123 copy) rows manually sorted into alphabetical order of names for transfer to history sheet"]
[null,"Albury Cup","Event >","Albury Points Best 4 from 5","Gazette Cup 4 miles",null,"Alec Potton 7 miles",null,"Christmas Cup 5 km",null,"SWC Track 3 km",null,"SWC Open Track 5 km",null,"Total Points","Races Walked",null,"ALBURY CUP 2014/15 UNSORTED by NAME","Event >>",{"$f":"+E31","v":420},{"$f":"+G31","v":432},{"$f":"+I31","v":443},{"$f":"+K31","v":509},{"$f":"+M31","v":533},null,"ALBURY CUP 2014/15 SORTED for Lookup",{"$f":"+S4","v":"Event >>"},420,432,443,509,533]
[null,"Rank","Name    -  date>","after 5","  28/09/14",null,"  2/11/14",null,"  20/12/14",null,"  03/06/15",null,"  05/08/15",null," 2014/15",{"$f":"+O5","v":" 2014/15"},null,"NAME","Year Rank","Pos 1","Pos 2","Pos 3","Pos 4","Pos 5",null,"NAME","Year Rank","Pos 1","Pos 2","Pos 3","Pos 4","Pos 5"]
[null,1,"David Crane",{"$f":"+O6-MIN(F6,H6,J6,L6,N6)","v":50},3,{"$f":"IF(ISBLANK(E6),0,F$28+1-E6)","v":12},1,{"$f":"IF(ISBLANK(G6),0,H$28+1-G6)","v":13},1,{"$f":"IF(ISBLANK(I6),0,J$28+1-I6)","v":14},2,11,2,{"$f":"IF(ISBLANK(M6),0,N$28+1-M6)","v":8},{"$f":"+F6+H6+J6+L6+N6","v":58},{"$f":"+COUNT(E6,G6,I6,K6,M6)","v":5},null,{"$f":"RIGHT(C6,LEN(C6)-FIND(\" \",C6)) & \"_\" & LEFT(C6,FIND(\" \",C6)-1)","v":"Crane_David"},{"$f":"+B6","v":1},{"$f":"+E6","v":3},{"$f":"+G6","v":1},{"$f":"+I6","v":1},{"$f":"+K6","v":2},{"$f":"+M6","v":2},null,"Brown_Sandra",19,0,0,0,0,0]
[null,{"$f":"+B6+1","v":2},"David Hoben",39,null,0,3,11,3,12,4,9,3,7,39,4,null,{"$f":"RIGHT(C7,LEN(C7)-FIND(\" \",C7)) & \"_\" & LEFT(C7,FIND(\" \",C7)-1)","v":"Hoben_David"},{"$f":"+B7","v":2},{"$f":"+E7","v":0},{"$f":"+G7","v":3},{"$f":"+I7","v":3},{"$f":"+K7","v":4},{"$f":"+M7","v":3},null,"Burnett_Kevin",17,0,0,0,0,0]
[null,3,"Dan Maskell",36,2,13,5,9,8,7,6,7,4,6,42,5,null,"Maskell_Dan",3,2,5,8,6,4,null,"Campbell_Sandra",13,8,0,0,0,0]
[null,4,"Angela Martin",31,5,10,null,0,6,9,1,12,null,0,31,3,null,"Martin_Angela",4,5,0,6,1,0,null,"Crane_David",1,3,1,1,2,2]
[null,5,"Peter Crane",31,4,11,2,12,7,8,null,0,null,0,31,3,null,"Crane_Peter",5,4,2,7,0,0,null,"Crane_Peter",5,4,2,7,0,0]
[null,6,"Malcolm Martin",28,6,9,null,0,2,13,7,6,null,0,28,3,null,"Martin_Malcolm",6,6,0,2,7,0,null,"Crilley_Kathy",16,0,0,0,0,0]
[null,7,"Mick Harran",27,null,0,6,8,5,10,null,0,1,9,27,3,null,"Harran_Mick",7,0,6,5,0,1,null,"Delaney_Dave",11,7,0,0,0,0]
[null,8,"Paul King",24,1,14,4,10,null,0,null,0,null,0,24,2,null,"King_Paul",8,1,4,0,0,0,null,"Easton_Mark",14,0,7,0,0,0]
[null,9,"Chris Flint",22,null,0,8,6,4,11,null,0,5,5,22,3,null,"Flint_Chris",9,0,8,4,0,5,null,"Flint_Chris",9,0,8,4,0,5]
[null,10,"Shaun Lightman",20,null,0,null,0,9,6,3,10,6,4,20,3,null,"Lightman_Shaun",10,0,0,9,3,6,null,"Gaston_Paul",18,0,0,0,0,0]
[null,11,"Dave Delaney",8,7,8,null,0,null,0,null,0,null,0,8,1,null,"Delaney_Dave",11,7,0,0,0,0,null,"Harran_Mick",7,0,6,5,0,1]
[null,12,"Nolan Simmons",8,null,0,null,0,null,0,5,8,null,0,8,1,null,"Simmons_Nolan",12,0,0,0,5,0,null,"Hoben_David",2,0,3,3,4,3]
[null,13,"Sandra Campbell",7,8,7,null,0,null,0,null,0,null,0,7,1,null,"Campbell_Sandra",13,8,0,0,0,0,null,"King_Paul",8,1,4,0,0,0]
[null,14,"Mark Easton",7,null,0,7,7,null,0,null,0,null,0,7,1,null,"Easton_Mark",14,0,7,0,0,0,null,"Lightman_Shaun",10,0,0,9,3,6]
[null,15,"Trevor Sliwerski",6,9,6,null,0,null,0,null,0,null,0,6,1,null,"Sliwerski_Trevor",15,9,0,0,0,0,null,"Martin_Angela",4,5,0,6,1,0]
[null,16,"Kathy Crilley",0,null,0,null,0,null,0,null,0,null,0,0,0,null,"Crilley_Kathy",{"$f":"+B21","v":16},{"$f":"+E21","v":0},{"$f":"+G21","v":0},{"$f":"+I21","v":0},{"$f":"+K21","v":0},{"$f":"+M21","v":0},null,"Martin_Malcolm",6,6,0,2,7,0]
[null,17,"Kevin Burnett",0,null,0,null,0,null,0,null,0,null,0,0,0,null,"Burnett_Kevin",17,0,0,0,0,0,null,"Maskell_Dan",3,2,5,8,6,4]
[null,18,"Paul Gaston",0,null,0,null,0,null,0,null,0,null,0,0,0,null,"Gaston_Paul",{"$f":"+B23","v":18},{"$f":"+E23","v":0},{"$f":"+G23","v":0},{"$f":"+I23","v":0},{"$f":"+K23","v":0},{"$f":"+M23","v":0},null,"Simmons_Nolan",12,0,0,0,5,0]
[null,19,"Sandra Brown",0,null,0,null,0,null,0,null,0,null,0,0,0,null,"Brown_Sandra",19,0,0,0,0,0,null,"Sliwerski_Trevor",15,9,0,0,0,0]
[]
[null,null,"SWC Number Out",null,{"$f":"+COUNT(E6:E24)","v":9},null,{"$f":"+COUNT(G6:G24)","v":8},null,{"$f":"+COUNT(I6:I24)","v":9},null,{"$f":"+COUNT(K6:K24)","v":7},null,{"$f":"+COUNT(M6:M24)","v":6}]
[]
[null,null,"Winning score",null,null,{"$f":"+ROUND(E26*1.5+0.1,0)","v":14},null,{"$f":"+ROUND(G26*1.5+0.1,0)+1","v":13},null,{"$f":"+ROUND(I26*1.5+0.1,0)","v":14},null,{"$f":"+ROUND(K26*1.5+0.1,0)+1","v":12},null,{"$f":"+ROUND(M26*1.5+0.1,0)","v":9}]
[null,null,"Check total positions =",null,{"$f":"TEXT(SUM(E6:E24),\"0\")","v":"45"},null,{"$f":"TEXT(SUM(G6:G24),\"0\")","v":"36"},null,{"$f":"TEXT(SUM(I6:I24),\"0\")","v":"45"},null,{"$f":"TEXT(SUM(K6:K24),\"0\")","v":"28"},null,{"$f":"TEXT(SUM(M6:M24),\"0\")","v":"21"}]
[null,null,"If t = walkers then t*( t+1)/2 =",null,{"$f":"+E26*(E26+1)/2","v":45},null,{"$f":"+G26*(G26+1)/2","v":36},null,{"$f":"+I26*(I26+1)/2","v":45},null,{"$f":"+K26*(K26+1)/2","v":28},null,{"$f":"+M26*(M26+1)/2","v":21}]
[null,null,"Acc Event Number",null,420,null,432,null,443,null,509,null,533]
[null,null,"Average points (always t + 1)",null,{"$f":"INT(SUM(F6:F24)/E26+0.5)","v":10},null,{"$f":"INT(SUM(H6:H24)/G26+0.5)","v":10},null,{"$f":"INT(SUM(J6:J24)/I26+0.5)","v":10},null,9,null,7]
[]
[null,"Officials",null,null,"attend","pts","attend","pts","attend","pts","attend","pts","attend","pts"]
[null,null,"Peter Selby",null,1,{"$f":"IF(E35>0,E$32,0)","v":10},1,{"$f":"IF(G35>0,G$32,0)","v":10},1,{"$f":"IF(I35>0,I$32,0)","v":10},1,{"$f":"IF(K35>0,K$32,0)","v":9},1,{"$f":"IF(M35>0,M$32,0)","v":7}]
[null,null,"Pam Ficken",null,1,{"$f":"IF(E36>0,E$32,0)","v":10},1,{"$f":"IF(G36>0,G$32,0)","v":10},1,{"$f":"IF(I36>0,I$32,0)","v":10},1,{"$f":"IF(K36>0,K$32,0)","v":9},null,{"$f":"IF(M36>0,M$32,0)","v":0}]
[null,null,"Mark Easton",null,1,10,null,0,1,10,null,0,null,0]
[null,null,"Nolan Simmons",null,1,10,1,10,1,10,null,0,null,0]
[null,"UNSORTED"]
[null,null,"David Crane",{"$f":"+O40-MIN(F40,H40,J40,L40,N40)","v":47},3,{"$f":"IF(ISBLANK(E40),0,F$28+1-E40)","v":12},1,{"$f":"IF(ISBLANK(G40),0,H$28+1-G40)","v":13},1,{"$f":"IF(ISBLANK(I40),0,J$28+1-I40)","v":14},null,{"$f":"IF(ISBLANK(K40),0,L$28+1-K40)","v":0},2,{"$f":"IF(ISBLANK(M40),0,N$28+1-M40)","v":8},{"$f":"+F40+H40+J40+L40+N40","v":47},{"$f":"+COUNT(E40,G40,I40,K40,M40)","v":4}]
[null,null,"Dan Maskell",39,2,13,5,9,8,7,3,10,6,4,43,5]
[null,null,"David Hoben",29,null,0,3,11,3,12,null,0,4,6,29,3]
[null,null,"Angela Martin",28,5,10,null,0,6,9,null,0,1,9,28,3]
[null,null,"Peter Crane",31,4,11,2,12,7,8,null,0,null,0,31,3]
[null,null,"Chris Flint",28,null,0,8,6,4,11,2,11,null,0,28,3]
[null,null,"Malcolm Martin",25,6,9,null,0,2,13,null,0,7,3,25,3]
[null,null,"Paul King",24,1,14,4,10,null,0,null,0,null,0,24,2]
[null,null,"Shaun Lightman",21,null,0,null,0,9,6,5,8,3,7,21,3]
[null,null,"Peter Selby",39,{"$f":"+IF(E35>0,0,\"\")","v":0},{"$f":"+F35","v":10},{"$f":"+IF(G35>0,0,\"\")","v":0},{"$f":"+H35","v":10},{"$f":"+IF(I35>0,0,\"\")","v":0},{"$f":"+J35","v":10},{"$f":"+IF(K35>0,0,\"\")","v":0},{"$f":"+L35","v":9},{"$f":"+IF(M35>0,0,\"\")","v":0},{"$f":"+N35","v":7},46,5]
[null,null,"Pam Ficken",39,{"$f":"+IF(E36>0,0,\"\")","v":0},{"$f":"+F36","v":10},{"$f":"+IF(G36>0,0,\"\")","v":0},{"$f":"+H36","v":10},{"$f":"+IF(I36>0,0,\"\")","v":0},{"$f":"+J36","v":10},{"$f":"+IF(K36>0,0,\"\")","v":0},{"$f":"+L36","v":9},{"$f":"+IF(M36>0,0,\"\")","v":""},{"$f":"+N36","v":0},39,4]
[null,null,"Mick Harran",18,null,{"$f":"IF(ISBLANK(E51),0,F$28+1-E51)","v":0},6,{"$f":"IF(ISBLANK(G51),0,H$28+1-G51)","v":8},5,{"$f":"IF(ISBLANK(I51),0,J$28+1-I51)","v":10},null,{"$f":"IF(ISBLANK(K51),0,L$28+1-K51)","v":0},null,{"$f":"IF(ISBLANK(M51),0,N$28+1-M51)","v":0},18,2]
[null,null,"Paul Gaston",12,null,{"$f":"IF(ISBLANK(E52),0,F$28+1-E52)","v":0},null,{"$f":"IF(ISBLANK(G52),0,H$28+1-G52)","v":0},null,{"$f":"IF(ISBLANK(I52),0,J$28+1-I52)","v":0},1,{"$f":"IF(ISBLANK(K52),0,L$28+1-K52)","v":12},null,0,12,1]
[null,null,"Sandra Campbell",14,8,{"$f":"IF(ISBLANK(E53),0,F$28+1-E53)","v":7},null,{"$f":"IF(ISBLANK(G53),0,H$28+1-G53)","v":0},null,{"$f":"IF(ISBLANK(I53),0,J$28+1-I53)","v":0},6,{"$f":"IF(ISBLANK(K53),0,L$28+1-K53)","v":7},null,0,14,2]
[null,null,"Sandra Brown",9,null,{"$f":"IF(ISBLANK(E54),0,F$28+1-E54)","v":0},null,{"$f":"IF(ISBLANK(G54),0,H$28+1-G54)","v":0},null,{"$f":"IF(ISBLANK(I54),0,J$28+1-I54)","v":0},4,{"$f":"IF(ISBLANK(K54),0,L$28+1-K54)","v":9},null,0,9,1]
[null,null,"Nolan Simmons",35,{"$f":"+IF(E38>0,0,\"\")","v":0},{"$f":"+F38","v":10},{"$f":"+IF(G38>0,0,\"\")","v":0},{"$f":"+H38","v":10},{"$f":"+IF(I38>0,0,\"\")","v":0},{"$f":"+J38","v":10},{"$f":"+IF(K38>0,0,\"\")","v":""},{"$f":"+L38","v":0},5,5,35,4]
[null,null,"Dave Delaney",8,7,{"$f":"IF(ISBLANK(E56),0,F$28+1-E56)","v":8},null,{"$f":"IF(ISBLANK(G56),0,H$28+1-G56)","v":0},null,{"$f":"IF(ISBLANK(I56),0,J$28+1-I56)","v":0},null,{"$f":"IF(ISBLANK(K56),0,L$28+1-K56)","v":0},null,0,8,1]
[null,null,"Mark Easton",27,{"$f":"+IF(E37>0,0,\"\")","v":0},{"$f":"+F37","v":10},7,{"$f":"IF(ISBLANK(G57),0,H$28+1-G57)","v":7},{"$f":"+IF(I37>0,0,\"\")","v":0},{"$f":"+J37","v":10},{"$f":"+IF(K37>0,0,\"\")","v":""},{"$f":"+L37","v":0},{"$f":"+IF(M37>0,0,\"\")","v":""},{"$f":"+N37","v":0},27,3]
[null,null,"Trevor Sliwerski",6,9,{"$f":"IF(ISBLANK(E58),0,F$28+1-E58)","v":6},null,{"$f":"IF(ISBLANK(G58),0,H$28+1-G58)","v":0},null,{"$f":"IF(ISBLANK(I58),0,J$28+1-I58)","v":0},null,{"$f":"IF(ISBLANK(K58),0,L$28+1-K58)","v":0},null,{"$f":"IF(ISBLANK(M58),0,N$28+1-M58)","v":0},6,1]
[null,null,"Kathy Crilley",0,null,{"$f":"IF(ISBLANK(E59),0,F$28+1-E59)","v":0},null,{"$f":"IF(ISBLANK(G59),0,H$28+1-G59)","v":0},null,{"$f":"IF(ISBLANK(I59),0,J$28+1-I59)","v":0},null,{"$f":"IF(ISBLANK(K59),0,L$28+1-K59)","v":0},null,{"$f":"IF(ISBLANK(M59),0,N$28+1-M59)","v":0},0,0]
[null,null,"Kevin Burnett",0,null,{"$f":"IF(ISBLANK(E60),0,F$28+1-E60)","v":0},null,{"$f":"IF(ISBLANK(G60),0,H$28+1-G60)","v":0},null,{"$f":"IF(ISBLANK(I60),0,J$28+1-I60)","v":0},null,{"$f":"IF(ISBLANK(K60),0,L$28+1-K60)","v":0},null,{"$f":"IF(ISBLANK(M60),0,N$28+1-M60)","v":0},0,0]
[null,"RESORTED VERSION FOR REVIEW PURPOSES ONLY"]
[null,"Albury Cup","Event >","Albury Points Best 4 from 5","Gazette Cup 4 miles",null,"Alec Potton 7 miles",null,"Christmas Cup 5 km",null,"SWC Open 10 km",null,"SWC Track 3 km",null,"Total Points","Races Walked"]
[null,"Rank","Name    -  date>","after 4","  28/09/14",null,"  2/11/14",null,"  20/12/14",null,"  20/01/15",null,"  03/06/15",null," 2014/15",{"$f":"+O63","v":" 2014/15"}]
[null,null,"David Crane",48,3,12,1,12,1,14,null,0,2,10,48,4]
[null,null,"Peter Selby",40,0,10,0,10,0,10,0,10,"",0,40,4]
[null,null,"Pam Ficken",40,0,10,0,10,0,10,0,10,"",0,40,4]
[null,null,"Nolan Simmons",37,0,10,0,10,0,10,"",0,5,7,37,4]
[null,null,"Dan Maskell",35,2,13,5,8,8,7,3,7,6,6,41,5]
[null,null,"David Hoben",30,null,0,3,10,3,12,null,0,4,8,30,3]
[null,null,"Angela Martin",30,5,10,null,0,6,9,null,0,1,11,30,3]
[null,null,"Peter Crane",30,4,11,2,11,7,8,null,0,null,0,30,3]
[null,null,"Malcolm Martin",27,6,9,null,0,2,13,null,0,7,5,27,3]
[null,null,"Mark Easton",26,0,10,7,6,0,10,"",0,"",0,26,3]
[null,null,"Chris Flint",24,null,0,8,5,4,11,2,8,null,0,24,3]
[null,null,"Paul King",23,1,14,4,9,null,0,null,0,null,0,23,2]
[null,null,"Shaun Lightman",20,null,0,null,0,9,6,5,5,3,9,20,3]
[null,null,"Mick Harran",17,null,0,6,7,5,10,null,0,null,0,17,2]
[null,null,"Sandra Campbell",11,8,7,null,0,null,0,6,4,null,0,11,2]
[null,null,"Paul Gaston",9,null,0,null,0,null,0,1,9,null,0,9,1]
[null,null,"Dave Delaney",8,7,8,null,0,null,0,null,0,null,0,8,1]
[null,null,"Sandra Brown",6,null,0,null,0,null,0,4,6,null,0,6,1]
[null,null,"Trevor Sliwerski",6,9,6,null,0,null,0,null,0,null,0,6,1]
[null,null,"Kathy Crilley",0,null,0,null,0,null,0,null,0,null,0,0,0]
[null,null,"Kevin Burnett",0,null,0,null,0,null,0,null,0,null,0,0,0]

{"sheet":"AL_2015_16","index":6,"n_rows":84,"n_cols":32,"rows_kept":84,"merged":[[3,4,3,5],[3,6,3,7],[3,8,3,9],[3,10,3,11],[3,12,3,13],[4,6,4,7],[61,4,61,5],[61,6,61,7],[61,8,61,9],[61,10,61,11],[61,12,61,13]]}
[]
[null,null,"ALBURY CUP RESULTS 2015/16",{"$nulls":9},"As at: "," 1st June 2016",{"$nulls":3},"NB Change Ranges Each Year: Table_For_History_Unsorted and Table_For_History_Sorted"]
[{"$nulls":17},"Copy of table with columns for history in correct order >>>>>>>",{"$nulls":7},"Copy of table (123 copy) rows manually sorted into alphabetical order of names for transfer to history sheet"]
[null,"Albury Cup","Event >","Albury Points Best 4 from 5","Gazette Cup 4 miles",null,"Alec Potton 7 miles",null,"Christmas Cup 5 km",null,"SWC Track 3 km",null,"SWC Open Track 5 km",null,"Total Points","Races Walked",null,"ALBURY CUP 2015/16 UNSORTED by NAME","Event >>",{"$f":"+E31","v":772},{"$f":"+G31","v":878},{"$f":"+I31","v":917},{"$f":"+K31","v":1109},806,null,"ALBURY CUP 2014/15 SORTED for Lookup",{"$f":"+S4","v":"Event >>"},{"$f":"+T4","v":772},{"$f":"+U4","v":878},917,1109,806]
[null,"Rank","Name    -  date>","after 4","  27/09/15",null,"2015-11-01",null,"  5/12/15",null,"  01/06/16",null,"  27/7/16",null," 2015/16",{"$f":"+O5","v":" 2015/16"},{"$nulls":3},{"$f":"+E5","v":"  27/09/15"},{"$f":"+G5","v":"2015-11-01"},{"$f":"+I5","v":"  5/12/15"},{"$f":"+K5","v":"  01/06/16"},"2016-07-27"]
[null,1,"David Crane",{"$f":"O6-MIN(F6,H6,J6,L6,N6)","v":40},3,{"$f":"IF(ISBLANK(E6),0,F$28+1-E6)","v":5},1,{"$f":"IF(ISBLANK(G6),0,H$28+1-G6)","v":12},1,{"$f":"IF(ISBLANK(I6),0,J$28+1-I6)","v":12},null,{"$f":"IF(ISBLANK(K6),0,L$28+1-K6)","v":0},2,{"$f":"IF(ISBLANK(M6),0,N$28+1-M6)","v":11},{"$f":"+F6+H6+J6+L6+N6","v":40},{"$f":"+COUNT(E6,G6,I6,K6,M6)","v":4},null,"NAME","Year Rank","Pos 1","Pos 2","Pos 3","Pos 4","Pos 5",null,"NAME","Year Rank","Pos 1","Pos 2","Pos 3","Pos 4","Pos 5"]
[null,{"$f":"+IF(O7>0,B6+1,\"-\")","v":2},"Dan Maskell",32,1,7,5,8,null,0,3,7,3,10,32,4,null,{"$f":"RIGHT(C6,LEN(C6)-FIND(\" \",C6)) & \"_\" & LEFT(C6,FIND(\" \",C6)-1)","v":"Crane_David"},{"$f":"+B6","v":1},{"$f":"+E6","v":3},{"$f":"+G6","v":1},{"$f":"+I6","v":1},{"$f":"+K6","v":0},{"$f":"+M6","v":2},null,"Burnett_Kevin","-",0,0,0,0,0]
[null,{"$f":"+IF(O8>0,B7+1,\"-\")","v":3},"David Hoben",31,null,0,4,9,5,8,2,8,7,6,31,4,null,"Maskell_Dan",2,1,5,0,3,3,null,"Campbell_Sandra","-",0,0,0,0,0]
[null,4,"Shaun Lightman",24,null,0,6,7,null,0,1,9,5,8,24,3,null,"Hoben_David",3,0,4,5,2,7,null,"Crane_David",1,3,1,1,0,2]
[null,5,"Malcolm Martin",19,null,0,null,0,3,10,null,0,4,9,19,2,null,"Lightman_Shaun",4,0,6,0,1,5,null,"Crane_Peter","-",0,0,0,0,0]
[null,6,"Dave Delaney",17,null,0,3,10,6,7,null,0,null,0,17,2,null,"Martin_Malcolm",5,0,0,3,0,4,null,"Crane_Steve",10,0,0,0,0,1]
[null,7,"Mick Harran",16,4,4,null,0,7,6,4,6,null,0,16,3,null,"Delaney_Dave",6,0,3,6,0,0,null,"Crilley_Kathy","-",0,0,0,0,0]
[null,8,"Mark Easton",12,2,6,7,6,null,0,null,0,null,0,12,2,null,"Harran_Mick",7,4,0,7,4,0,null,"Delaney_Dave",6,0,3,6,0,0]
[null,9,"Chris Flint",12,null,0,null,0,null,0,5,5,6,7,12,2,null,"Easton_Mark",8,2,7,0,0,0,null,"Easton_Mark",8,2,7,0,0,0]
[null,10,"Steve Crane",12,null,0,null,0,null,0,null,0,1,12,12,1,null,"Flint_Chris",9,0,0,0,5,6,null,"Flint_Chris",9,0,0,0,5,6]
[null,11,"Paul King",11,null,0,2,11,null,0,null,0,null,0,11,1,null,"Crane_Steve",10,0,0,0,0,1,null,"Gaston_Paul",13,0,0,4,0,0]
[null,12,"Angela Martin",{"$f":"O17-MIN(F17,H17,J17,L17,N17)","v":11},null,0,null,0,2,11,null,0,null,0,11,1,null,"King_Paul",11,0,2,0,0,0,null,"Harran_Mick",7,4,0,7,4,0]
[null,13,"Paul Gaston",{"$f":"O18-MIN(F18,H18,J18,L18,N18)","v":9},null,0,null,0,4,9,null,0,null,0,9,1,null,"Martin_Angela",12,0,0,2,0,0,null,"Hoben_David",3,0,4,5,2,7]
[null,"-","Nolan Simmons",0,null,0,null,0,null,0,null,0,null,0,0,0,null,"Gaston_Paul",13,0,0,4,0,0,null,"King_Paul",11,0,2,0,0,0]
[null,"-","Peter Crane",0,null,0,null,0,null,0,null,0,null,0,0,0,null,"Simmons_Nolan","-",0,0,0,0,0,null,"Lightman_Shaun",4,0,6,0,1,5]
[null,"-","Sandra Campbell",0,null,0,null,0,null,0,null,0,null,0,0,0,null,"Crane_Peter","-",0,0,0,0,0,null,"Martin_Angela",12,0,0,2,0,0]
[null,"-","Trevor Sliwerski",0,null,0,null,0,null,0,null,0,null,0,0,0,null,"Campbell_Sandra","-",0,0,0,0,0,null,"Martin_Malcolm",5,0,0,3,0,4]
[null,"-","Kathy Crilley",0,null,0,null,0,null,0,null,0,null,0,0,0,null,"Sliwerski_Trevor","-",0,0,0,0,0,null,"Maskell_Dan",2,1,5,0,3,3]
[null,"-","Kevin Burnett",0,null,0,null,0,null,0,null,0,null,0,0,0,null,"Crilley_Kathy","-",0,0,0,0,0,null,"Simmons_Nolan","-",0,0,0,0,0]
[{"$nulls":17},"Burnett_Kevin","-",0,0,0,0,0,null,"Sliwerski_Trevor","-",0,0,0,0,0]
[null,null,"SWC Number Out",null,{"$f":"+COUNT(E6:E24)","v":4},null,{"$f":"+COUNT(G6:G24)","v":7},null,{"$f":"+COUNT(I6:I24)","v":7},null,{"$f":"+COUNT(K6:K24)","v":5},null,{"$f":"+COUNT(M6:M24)","v":7}]
[]
[null,null,"Winning score",null,null,{"$f":"+ROUND(E26*1.5+1.1,0)","v":7},null,{"$f":"+ROUND(G26*1.5+1.1,0)","v":12},null,{"$f":"+ROUND(I26*1.5+1.1,0)","v":12},null,{"$f":"+ROUND(K26*1.5+1.1,0)","v":9},null,{"$f":"+ROUND(M26*1.5+1.1,0)","v":12}]
[null,null,"Check total positions =",null,{"$f":"TEXT(SUM(E6:E24),\"0\")","v":"10"},null,{"$f":"TEXT(SUM(G6:G24),\"0\")","v":"28"},null,{"$f":"TEXT(SUM(I6:I24),\"0\")","v":"28"},null,{"$f":"TEXT(SUM(K6:K24),\"0\")","v":"15"},null,{"$f":"TEXT(SUM(M6:M24),\"0\")","v":"28"}]
[null,null,"If t = walkers then t*( t+1)/2 =",null,{"$f":"+E26*(E26+1)/2","v":10},null,{"$f":"+G26*(G26+1)/2","v":28},null,{"$f":"+I26*(I26+1)/2","v":28},null,{"$f":"+K26*(K26+1)/2","v":15},null,{"$f":"+M26*(M26+1)/2","v":28}]
[null,null,"Acc Event Number",null,772,null,878,null,917,null,1109]
[null,null,"Average points (always t + 2)",null,{"$f":"INT(SUM(F6:F24)/E26+0.5)","v":6},null,{"$f":"INT(SUM(H6:H24)/G26+0.5)","v":9},null,{"$f":"INT(SUM(J6:J24)/I26+0.5)","v":9},null,7,null,9]
[]
[null,"Officials",null,null,"attend","pts","attend","pts","attend","pts","attend","pts","attend","pts"]
[null,null,"Peter Selby",null,null,{"$f":"IF(E35>0,E$32,0)","v":0},1,{"$f":"IF(G35>0,G$32,0)","v":9},1,{"$f":"IF(I35>0,I$32,0)","v":9},1,{"$f":"IF(K35>0,K$32,0)","v":7},1,{"$f":"IF(M35>0,M$32,0)","v":9}]
[null,null,"Pam Ficken",null,1,{"$f":"IF(E36>0,E$32,0)","v":6},1,{"$f":"IF(G36>0,G$32,0)","v":9},1,{"$f":"IF(I36>0,I$32,0)","v":9},1,{"$f":"IF(K36>0,K$32,0)","v":7},null,{"$f":"IF(M36>0,M$32,0)","v":0}]
[null,null,"Mark Easton",null,1,6,null,0,1,9,null,0,null,0]
[null,null,"Nolan Simmons",null,1,6,1,9,1,9,null,0,null,0]
[null,"UNSORTED"]
[null,null,"David Crane",{"$f":"+O40-MIN(F40,H40,J40,L40,N40)","v":40},3,{"$f":"IF(ISBLANK(E40),0,F$28+1-E40)","v":5},1,{"$f":"IF(ISBLANK(G40),0,H$28+1-G40)","v":12},1,{"$f":"IF(ISBLANK(I40),0,J$28+1-I40)","v":12},null,{"$f":"IF(ISBLANK(K40),0,L$28+1-K40)","v":0},2,{"$f":"IF(ISBLANK(M40),0,N$28+1-M40)","v":11},{"$f":"+F40+H40+J40+L40+N40","v":40},{"$f":"+COUNT(E40,G40,I40,K40,M40)","v":4}]
[null,null,"Dan Maskell",28,2,6,5,8,8,5,3,7,6,7,33,5]
[null,null,"David Hoben",29,null,0,3,10,3,10,null,0,4,9,29,3]
[null,null,"Angela Martin",22,5,3,null,0,6,7,null,0,1,12,22,3]
[null,null,"Peter Crane",21,4,4,2,11,7,6,null,0,null,0,21,3]
[null,null,"Chris Flint",22,null,0,8,5,4,9,2,8,null,0,22,3]
[null,null,"Malcolm Martin",19,6,2,null,0,2,11,null,0,7,6,19,3]
[null,null,"Paul King",16,1,7,4,9,null,0,null,0,null,0,16,2]
[null,null,"Shaun Lightman",19,null,0,null,0,9,4,5,5,3,10,19,3]
[null,null,"Peter Selby",34,{"$f":"+IF(E35>0,0,\"\")","v":""},{"$f":"+F35","v":0},{"$f":"+IF(G35>0,0,\"\")","v":0},{"$f":"+H35","v":9},{"$f":"+IF(I35>0,0,\"\")","v":0},{"$f":"+J35","v":9},{"$f":"+IF(K35>0,0,\"\")","v":0},{"$f":"+L35","v":7},{"$f":"+IF(M35>0,0,\"\")","v":0},{"$f":"+N35","v":9},34,4]
[null,null,"Pam Ficken",31,{"$f":"+IF(E36>0,0,\"\")","v":0},{"$f":"+F36","v":6},{"$f":"+IF(G36>0,0,\"\")","v":0},{"$f":"+H36","v":9},{"$f":"+IF(I36>0,0,\"\")","v":0},{"$f":"+J36","v":9},{"$f":"+IF(K36>0,0,\"\")","v":0},{"$f":"+L36","v":7},{"$f":"+IF(M36>0,0,\"\")","v":""},{"$f":"+N36","v":0},31,4]
[null,null,"Mick Harran",15,null,{"$f":"IF(ISBLANK(E51),0,F$28+1-E51)","v":0},6,{"$f":"IF(ISBLANK(G51),0,H$28+1-G51)","v":7},5,{"$f":"IF(ISBLANK(I51),0,J$28+1-I51)","v":8},null,{"$f":"IF(ISBLANK(K51),0,L$28+1-K51)","v":0},null,{"$f":"IF(ISBLANK(M51),0,N$28+1-M51)","v":0},15,2]
[null,null,"Paul Gaston",9,null,{"$f":"IF(ISBLANK(E52),0,F$28+1-E52)","v":0},null,{"$f":"IF(ISBLANK(G52),0,H$28+1-G52)","v":0},null,{"$f":"IF(ISBLANK(I52),0,J$28+1-I52)","v":0},1,{"$f":"IF(ISBLANK(K52),0,L$28+1-K52)","v":9},null,0,9,1]
[null,null,"Sandra Campbell",4,8,{"$f":"IF(ISBLANK(E53),0,F$28+1-E53)","v":0},null,{"$f":"IF(ISBLANK(G53),0,H$28+1-G53)","v":0},null,{"$f":"IF(ISBLANK(I53),0,J$28+1-I53)","v":0},6,{"$f":"IF(ISBLANK(K53),0,L$28+1-K53)","v":4},null,0,4,2]
[null,null,"Sandra Brown",6,null,{"$f":"IF(ISBLANK(E54),0,F$28+1-E54)","v":0},null,{"$f":"IF(ISBLANK(G54),0,H$28+1-G54)","v":0},null,{"$f":"IF(ISBLANK(I54),0,J$28+1-I54)","v":0},4,{"$f":"IF(ISBLANK(K54),0,L$28+1-K54)","v":6},null,0,6,1]
[null,null,"Nolan Simmons",32,{"$f":"+IF(E38>0,0,\"\")","v":0},{"$f":"+F38","v":6},{"$f":"+IF(G38>0,0,\"\")","v":0},{"$f":"+H38","v":9},{"$f":"+IF(I38>0,0,\"\")","v":0},{"$f":"+J38","v":9},{"$f":"+IF(K38>0,0,\"\")","v":""},{"$f":"+L38","v":0},5,8,32,4]
[null,null,"Dave Delaney",1,7,{"$f":"IF(ISBLANK(E56),0,F$28+1-E56)","v":1},null,{"$f":"IF(ISBLANK(G56),0,H$28+1-G56)","v":0},null,{"$f":"IF(ISBLANK(I56),0,J$28+1-I56)","v":0},null,{"$f":"IF(ISBLANK(K56),0,L$28+1-K56)","v":0},null,0,1,1]
[null,null,"Mark Easton",21,{"$f":"+IF(E37>0,0,\"\")","v":0},{"$f":"+F37","v":6},7,{"$f":"IF(ISBLANK(G57),0,H$28+1-G57)","v":6},{"$f":"+IF(I37>0,0,\"\")","v":0},{"$f":"+J37","v":9},{"$f":"+IF(K37>0,0,\"\")","v":""},{"$f":"+L37","v":0},{"$f":"+IF(M37>0,0,\"\")","v":""},{"$f":"+N37","v":0},21,3]
[null,null,"Trevor Sliwerski",0,9,{"$f":"IF(ISBLANK(E58),0,F$28+1-E58)","v":-1},null,{"$f":"IF(ISBLANK(G58),0,H$28+1-G58)","v":0},null,{"$f":"IF(ISBLANK(I58),0,J$28+1-I58)","v":0},null,{"$f":"IF(ISBLANK(K58),0,L$28+1-K58)","v":0},null,{"$f":"IF(ISBLANK(M58),0,N$28+1-M58)","v":0},-1,1]
[null,null,"Kathy Crilley",0,null,{"$f":"IF(ISBLANK(E59),0,F$28+1-E59)","v":0},null,{"$f":"IF(ISBLANK(G59),0,H$28+1-G59)","v":0},null,{"$f":"IF(ISBLANK(I59),0,J$28+1-I59)","v":0},null,{"$f":"IF(ISBLANK(K59),0,L$28+1-K59)","v":0},null,{"$f":"IF(ISBLANK(M59),0,N$28+1-M59)","v":0},0,0]
[null,null,"Kevin Burnett",0,null,{"$f":"IF(ISBLANK(E60),0,F$28+1-E60)","v":0},null,{"$f":"IF(ISBLANK(G60),0,H$28+1-G60)","v":0},null,{"$f":"IF(ISBLANK(I60),0,J$28+1-I60)","v":0},null,{"$f":"IF(ISBLANK(K60),0,L$28+1-K60)","v":0},null,{"$f":"IF(ISBLANK(M60),0,N$28+1-M60)","v":0},0,0]
[null,"RESORTED VERSION FOR REVIEW PURPOSES ONLY"]
[null,"Albury Cup","Event >","Albury Points Best 4 from 5","Gazette Cup 4 miles",null,"Alec Potton 7 miles",null,"Christmas Cup 5 km",null,"SWC Open 10 km",null,"SWC Track 3 km",null,"Total Points","Races Walked"]
[null,"Rank","Name    -  date>","after 4","  28/09/14",null,"  2/11/14",null,"  20/12/14",null,"  20/01/15",null,"  03/06/15",null," 2014/15",{"$f":"+O63","v":" 2014/15"}]
[null,null,"David Crane",48,3,12,1,12,1,14,null,0,2,10,48,4]
[null,null,"Peter Selby",40,0,10,0,10,0,10,0,10,"",0,40,4]
[null,null,"Pam Ficken",40,0,10,0,10,0,10,0,10,"",0,40,4]
[null,null,"Nolan Simmons",37,0,10,0,10,0,10,"",0,5,7,37,4]
[null,null,"Dan Maskell",35,2,13,5,8,8,7,3,7,6,6,41,5]
[null,null,"David Hoben",30,null,0,3,10,3,12,null,0,4,8,30,3]
[null,null,"Angela Martin",30,5,10,null,0,6,9,null,0,1,11,30,3]
[null,null,"Peter Crane",30,4,11,2,11,7,8,null,0,null,0,30,3]
[null,null,"Malcolm Martin",27,6,9,null,0,2,13,null,0,7,5,27,3]
[null,null,"Mark Easton",26,0,10,7,6,0,10,"",0,"",0,26,3]
[null,null,"Chris Flint",24,null,0,8,5,4,11,2,8,null,0,24,3]
[null,null,"Paul King",23,1,14,4,9,null,0,null,0,null,0,23,2]
[null,null,"Shaun Lightman",20,null,0,null,0,9,6,5,5,3,9,20,3]
[null,null,"Mick Harran",17,null,0,6,7,5,10,null,0,null,0,17,2]
[null,null,"Sandra Campbell",11,8,7,null,0,null,0,6,4,null,0,11,2]
[null,null,"Paul Gaston",9,null,0,null,0,null,0,1,9,null,0,9,1]
[null,null,"Dave Delaney",8,7,8,null,0,null,0,null,0,null,0,8,1]
[null,null,"Sandra Brown",6,null,0,null,0,null,0,4,6,null,0,6,1]
[null,null,"Trevor Sliwerski",6,9,6,null,0,null,0,null,0,null,0,6,1]
[null,null,"Kathy Crilley",0,null,0,null,0,null,0,null,0,null,0,0,0]
[null,null,"Kevin Burnett",0,null,0,null,0,null,0,null,0,null,0,0,0]

{"sheet":"AL_2016_17","index":7,"n_rows":85,"n_cols":32,"rows_kept":85,"merged":[[3,4,3,5],[3,6,3,7],[3,8,3,9],[3,10,3,11],[3,12,3,13],[4,4,4,5],[4,6,4,7],[4,8,4,9],[4,10,4,11],[4,12,4,13],[62,4,62,5],[62,6,62,7],[62,8,62,9],[62,10,62,11],[62,12,62,13]]}
[]
[null,null,"ALBURY CUP RESULTS 2016/17",{"$nulls":3},"FINAL VERSION",{"$nulls":5},"As at: "," 19th July 2017",{"$nulls":3},"NB Change Ranges Each Year: Table_For_History_Unsorted and Table_For_History_Sorted"]
[{"$nulls":5},"Race handicap position and Albury Cup points",{"$nulls":11},"LINKED Copy of table with columns for history in correct order >>>>>>>",{"$nulls":7},"MANUAL Copy of table (123 copy) rows sorted into alphabetical order of names for transfer to history sheet"]
[null,"Albury Cup","Event >","Albury Points Best 4 from 5","Alec Potton 7 miles",null,"Christmas Cup 5 km",null,"SWC Track 3km",null,"Gazette Cup 4 miles",null,"SWC Open 5km",null,"Total Points","Races Walked",null,"ALBURY CUP 2016/17 UNSORTED by NAME","Event >>",{"$f":"+E32","v":878},{"$f":"+G32","v":917},{"$f":"+I32","v":1109},1123,1144,null,"ALBURY CUP 2016/17 SORTED by NAME","Event >>",878,917,1109,1123,1144]
[null,"Rank","Name    -  date>","after 5","2016-11-06",null,"2016-12-03",null,"2017-05-31",null,"2017-06-28",null,"2017-07-19",null," 2016/17",{"$f":"+O5","v":" 2016/17"},{"$nulls":3},{"$f":"+E5","v":"2016-11-06"},{"$f":"+G5","v":"2016-12-03"},{"$f":"+I5","v":"2017-05-31"},{"$f":"+K5","v":"2017-06-28"},{"$f":"+M5","v":"2017-07-19"},{"$nulls":3},"2016-11-06","2016-12-03","2017-05-31","2017-06-28","2017-07-19"]
[null,1,"David Hoben",{"$f":"O6-MIN(F6,H6,J6,L6,N6)","v":27},1,{"$f":"IF(ISBLANK(E6),0,F$29+1-E6)","v":13},6,{"$f":"IF(ISBLANK(G6),0,H$29+1-G6)","v":5},2,{"$f":"IF(ISBLANK(I6),0,J$29+1-I6)","v":5},3,{"$f":"IF(ISBLANK(K6),0,L$29+1-K6)","v":4},null,{"$f":"IF(ISBLANK(M6),0,N$29+1-M6)","v":0},{"$f":"+F6+H6+J6+L6+N6","v":27},{"$f":"+COUNT(E6,G6,I6,K6,M6)","v":4},null,"NAME","Year Rank","Pos 1","Pos 2","Pos 3","Pos 4","Pos 5",null,"NAME","Year Rank","Pos 1","Pos 2","Pos 3","Pos 4","Pos 5"]
[null,2,"Dave Delaney",25,3,11,3,8,null,0,1,6,null,0,25,3,null,{"$f":"RIGHT(C6,LEN(C6)-FIND(\" \",C6)) & \"_\" & LEFT(C6,FIND(\" \",C6)-1)","v":"Hoben_David"},{"$f":"IF(D6>0,+B6,0)","v":1},{"$f":"+E6","v":1},{"$f":"+G6","v":6},{"$f":"+I6","v":2},{"$f":"+K6","v":3},{"$f":"+M6","v":0},null,"Burnett_Kevin",11,0,0,3,0,0]
[null,"=3","Angela Martin",24,2,12,5,6,null,0,null,0,1,6,24,3,null,"Delaney_Dave",{"$f":"IF(D7>0,+B7,0)","v":2},3,3,0,1,0,null,"Campbell_Sandra",0,0,0,0,0,0]
[null,"=3","David Crane",24,5,9,1,10,null,0,null,0,2,5,24,3,null,"Martin_Angela","=3",2,5,0,0,1,null,"Crane_David",4,5,1,0,0,2]
[null,5,"Malcolm Martin",19,8,6,2,9,null,0,null,0,3,4,19,3,null,"Crane_David","=3",5,1,0,0,2,null,"Crane_Peter",0,0,0,0,0,0]
[null,6,"Chris Flint",13,null,0,4,7,1,6,null,0,null,0,13,2,null,"Martin_Malcolm",5,8,2,0,0,3,null,"Crane_Steve",0,0,0,0,0,0]
[null,7,"Mick Harran",10,4,10,null,0,null,0,null,0,null,0,10,1,null,"Flint_Chris",6,0,4,1,0,0,null,"Crilley_Kathy",0,0,0,0,0,0]
[null,8,"Paul King",8,6,8,null,0,null,0,null,0,null,0,8,1,null,"Harran_Mick",7,4,0,0,0,0,null,"Delaney_Dave",2,3,3,0,1,0]
[null,9,"Dan Maskell",7,7,7,null,0,null,0,null,0,null,0,7,1,null,"King_Paul",8,6,0,0,0,0,null,"Easton_Mark",0,0,0,0,0,0]
[null,10,"Roger Michell",5,null,0,null,0,null,0,2,5,null,0,5,1,null,"Maskell_Dan",9,7,0,0,0,0,null,"Flint_Chris",6,0,4,1,0,0]
[null,11,"Kevin Burnett",4,null,0,null,0,3,4,null,0,null,0,4,1,null,"Michell_Roger",10,0,0,0,2,0,null,"Gaston_Paul",0,0,0,0,0,0]
[null,12,"Kathy Crilley",0,null,0,null,0,null,0,null,0,null,0,0,0,null,"Burnett_Kevin",11,0,0,3,0,0,null,"Harran_Mick",7,4,0,0,0,0]
[null,13,"Mark Easton",0,null,0,null,0,null,0,null,0,null,0,0,0,null,"Crilley_Kathy",0,0,0,0,0,0,null,"Hoben_David",1,1,6,2,3,0]
[null,14,"Nolan Simmons",0,null,0,null,0,null,0,null,0,null,0,0,0,null,{"$f":"RIGHT(C18,LEN(C18)-FIND(\" \",C18)) & \"_\" & LEFT(C18,FIND(\" \",C18)-1)","v":"Easton_Mark"},0,{"$f":"+E18","v":0},{"$f":"+G18","v":0},{"$f":"+I18","v":0},{"$f":"+K18","v":0},{"$f":"+M18","v":0},null,"King_Paul",8,6,0,0,0,0]
[null,15,"Paul Gaston",0,null,0,null,0,null,0,null,0,null,0,0,0,null,"Simmons_Nolan",0,0,0,0,0,0,null,"Lightman_Shaun",0,0,0,0,0,0]
[null,16,"Peter Crane",0,null,0,null,0,null,0,null,0,null,0,0,0,null,"Gaston_Paul",0,0,0,0,0,0,null,"Martin_Angela",3,2,5,0,0,1]
[null,17,"Sandra Campbell",0,null,0,null,0,null,0,null,0,null,0,0,0,null,"Crane_Peter",0,0,0,0,0,0,null,"Martin_Malcolm",5,8,2,0,0,3]
[null,18,"Shaun Lightman",0,null,0,null,0,null,0,null,0,null,0,0,0,null,"Campbell_Sandra",0,0,0,0,0,0,null,"Maskell_Dan",9,7,0,0,0,0]
[null,19,"Steve Crane",0,null,0,null,0,null,0,null,0,null,0,0,0,null,"Lightman_Shaun",0,0,0,0,0,0,null,"Michell_Roger",10,0,0,0,2,0]
[null,20,"Trevor Sliwerski",0,null,0,null,0,null,0,null,0,null,0,0,0,null,"Crane_Steve",0,0,0,0,0,0,null,"Simmons_Nolan",0,0,0,0,0,0]
[{"$nulls":15},"At least 1",null,"Sliwerski_Trevor",0,0,0,0,0,0,null,"Sliwerski_Trevor",0,0,0,0,0,0]
[null,null,"SWC Number Out",null,{"$f":"+COUNT(E6:E25)","v":8},null,{"$f":"+COUNT(G6:G25)","v":6},null,{"$f":"+COUNT(I6:I25)","v":3},null,{"$f":"+COUNT(K6:K25)","v":3},null,{"$f":"+COUNT(M6:M25)","v":3},null,null,11]
[]
[null,null,"Winning score",null,null,{"$f":"+ROUND(E27*1.5+1.1,0)","v":13},null,{"$f":"+ROUND(G27*1.5+1.1,0)","v":10},null,{"$f":"+ROUND(I27*1.5+1.1,0)","v":6},null,{"$f":"+ROUND(K27*1.5+1.1,0)","v":6},null,{"$f":"+ROUND(M27*1.5+1.1,0)","v":6}]
[null,null,"Check total positions =",null,{"$f":"TEXT(SUM(E6:E25),\"0\")","v":"36"},null,{"$f":"TEXT(SUM(G6:G25),\"0\")","v":"21"},null,{"$f":"TEXT(SUM(I6:I25),\"0\")","v":"6"},null,{"$f":"TEXT(SUM(K6:K25),\"0\")","v":"6"},null,{"$f":"TEXT(SUM(M6:M25),\"0\")","v":"6"}]
[null,null,"If t = walkers then t*( t+1)/2 =",null,{"$f":"+E27*(E27+1)/2","v":36},null,{"$f":"+G27*(G27+1)/2","v":21},null,{"$f":"+I27*(I27+1)/2","v":6},null,{"$f":"+K27*(K27+1)/2","v":6},null,{"$f":"+M27*(M27+1)/2","v":6}]
[null,null,"Actual Event Number",null,878,null,917,null,1109]
[null,null,"Average points (always t + 2)",null,{"$f":"INT(SUM(F6:F25)/E27+0.5)","v":10},null,{"$f":"INT(SUM(H6:H25)/G27+0.5)","v":8},null,{"$f":"INT(SUM(J6:J25)/I27+0.5)","v":5},null,5,null,5]
[]
[null,"Officials",null,null,"attend","pts","attend","pts","attend","pts","attend","pts","attend","pts"]
[null,null,"Peter Selby",null,1,{"$f":"IF(E36>0,E$33,0)","v":10},1,{"$f":"IF(G36>0,G$33,0)","v":8},1,{"$f":"IF(I36>0,I$33,0)","v":5},1,{"$f":"IF(K36>0,K$33,0)","v":5},1,{"$f":"IF(M36>0,M$33,0)","v":5}]
[null,null,"Pam Ficken",null,1,{"$f":"IF(E37>0,E$33,0)","v":10},1,{"$f":"IF(G37>0,G$33,0)","v":8},1,{"$f":"IF(I37>0,I$33,0)","v":5},1,{"$f":"IF(K37>0,K$33,0)","v":5},null,{"$f":"IF(M37>0,M$33,0)","v":0}]
[null,null,"Mark Easton",null,0,0,null,0,1,5,null,0,null,0]
[null,null,"Nolan Simmons",null,1,10,1,8,1,5,null,0,null,0]
[null,"UNSORTED"]
[null,null,"David Crane",{"$f":"+O41-MIN(F41,H41,J41,L41,N41)","v":32},3,{"$f":"IF(ISBLANK(E41),0,F$29+1-E41)","v":11},1,{"$f":"IF(ISBLANK(G41),0,H$29+1-G41)","v":10},1,{"$f":"IF(ISBLANK(I41),0,J$29+1-I41)","v":6},null,{"$f":"IF(ISBLANK(K41),0,L$29+1-K41)","v":0},2,{"$f":"IF(ISBLANK(M41),0,N$29+1-M41)","v":5},{"$f":"+F41+H41+J41+L41+N41","v":32},{"$f":"+COUNT(E41,G41,I41,K41,M41)","v":4}]
[null,null,"Dan Maskell",23,2,12,5,6,8,-1,3,4,6,1,22,5]
[null,null,"David Hoben",15,null,0,3,8,3,4,null,0,4,3,15,3]
[null,null,"Angela Martin",16,5,9,null,0,6,1,null,0,1,6,16,3]
[null,null,"Peter Crane",19,4,10,2,9,7,0,null,0,null,0,19,3]
[null,null,"Chris Flint",11,null,0,8,3,4,3,2,5,null,0,11,3]
[null,null,"Malcolm Martin",13,6,8,null,0,2,5,null,0,7,0,13,3]
[null,null,"Paul King",20,1,13,4,7,null,0,null,0,null,0,20,2]
[null,null,"Shaun Lightman",6,null,0,null,0,9,-2,5,2,3,4,4,3]
[null,null,"Peter Selby",28,{"$f":"+IF(E36>0,0,\"\")","v":0},{"$f":"+F36","v":10},{"$f":"+IF(G36>0,0,\"\")","v":0},{"$f":"+H36","v":8},{"$f":"+IF(I36>0,0,\"\")","v":0},{"$f":"+J36","v":5},{"$f":"+IF(K36>0,0,\"\")","v":0},{"$f":"+L36","v":5},{"$f":"+IF(M36>0,0,\"\")","v":0},{"$f":"+N36","v":5},33,5]
[null,null,"Pam Ficken",28,{"$f":"+IF(E37>0,0,\"\")","v":0},{"$f":"+F37","v":10},{"$f":"+IF(G37>0,0,\"\")","v":0},{"$f":"+H37","v":8},{"$f":"+IF(I37>0,0,\"\")","v":0},{"$f":"+J37","v":5},{"$f":"+IF(K37>0,0,\"\")","v":0},{"$f":"+L37","v":5},{"$f":"+IF(M37>0,0,\"\")","v":""},{"$f":"+N37","v":0},28,4]
[null,null,"Mick Harran",7,null,{"$f":"IF(ISBLANK(E52),0,F$29+1-E52)","v":0},6,{"$f":"IF(ISBLANK(G52),0,H$29+1-G52)","v":5},5,{"$f":"IF(ISBLANK(I52),0,J$29+1-I52)","v":2},null,{"$f":"IF(ISBLANK(K52),0,L$29+1-K52)","v":0},null,{"$f":"IF(ISBLANK(M52),0,N$29+1-M52)","v":0},7,2]
[null,null,"Paul Gaston",6,null,{"$f":"IF(ISBLANK(E53),0,F$29+1-E53)","v":0},null,{"$f":"IF(ISBLANK(G53),0,H$29+1-G53)","v":0},null,{"$f":"IF(ISBLANK(I53),0,J$29+1-I53)","v":0},1,{"$f":"IF(ISBLANK(K53),0,L$29+1-K53)","v":6},null,0,6,1]
[null,null,"Sandra Campbell",7,8,{"$f":"IF(ISBLANK(E54),0,F$29+1-E54)","v":6},null,{"$f":"IF(ISBLANK(G54),0,H$29+1-G54)","v":0},null,{"$f":"IF(ISBLANK(I54),0,J$29+1-I54)","v":0},6,{"$f":"IF(ISBLANK(K54),0,L$29+1-K54)","v":1},null,0,7,2]
[null,null,"Sandra Brown",3,null,{"$f":"IF(ISBLANK(E55),0,F$29+1-E55)","v":0},null,{"$f":"IF(ISBLANK(G55),0,H$29+1-G55)","v":0},null,{"$f":"IF(ISBLANK(I55),0,J$29+1-I55)","v":0},4,{"$f":"IF(ISBLANK(K55),0,L$29+1-K55)","v":3},null,0,3,1]
[null,null,"Nolan Simmons",25,{"$f":"+IF(E39>0,0,\"\")","v":0},{"$f":"+F39","v":10},{"$f":"+IF(G39>0,0,\"\")","v":0},{"$f":"+H39","v":8},{"$f":"+IF(I39>0,0,\"\")","v":0},{"$f":"+J39","v":5},{"$f":"+IF(K39>0,0,\"\")","v":""},{"$f":"+L39","v":0},5,2,25,4]
[null,null,"Dave Delaney",7,7,{"$f":"IF(ISBLANK(E57),0,F$29+1-E57)","v":7},null,{"$f":"IF(ISBLANK(G57),0,H$29+1-G57)","v":0},null,{"$f":"IF(ISBLANK(I57),0,J$29+1-I57)","v":0},null,{"$f":"IF(ISBLANK(K57),0,L$29+1-K57)","v":0},null,0,7,1]
[null,null,"Mark Easton",9,{"$f":"+IF(E38>0,0,\"\")","v":""},{"$f":"+F38","v":0},7,{"$f":"IF(ISBLANK(G58),0,H$29+1-G58)","v":4},{"$f":"+IF(I38>0,0,\"\")","v":0},{"$f":"+J38","v":5},{"$f":"+IF(K38>0,0,\"\")","v":""},{"$f":"+L38","v":0},{"$f":"+IF(M38>0,0,\"\")","v":""},{"$f":"+N38","v":0},9,2]
[null,null,"Trevor Sliwerski",5,9,{"$f":"IF(ISBLANK(E59),0,F$29+1-E59)","v":5},null,{"$f":"IF(ISBLANK(G59),0,H$29+1-G59)","v":0},null,{"$f":"IF(ISBLANK(I59),0,J$29+1-I59)","v":0},null,{"$f":"IF(ISBLANK(K59),0,L$29+1-K59)","v":0},null,{"$f":"IF(ISBLANK(M59),0,N$29+1-M59)","v":0},5,1]
[null,null,"Kathy Crilley",0,null,{"$f":"IF(ISBLANK(E60),0,F$29+1-E60)","v":0},null,{"$f":"IF(ISBLANK(G60),0,H$29+1-G60)","v":0},null,{"$f":"IF(ISBLANK(I60),0,J$29+1-I60)","v":0},null,{"$f":"IF(ISBLANK(K60),0,L$29+1-K60)","v":0},null,{"$f":"IF(ISBLANK(M60),0,N$29+1-M60)","v":0},0,0]
[null,null,"Kevin Burnett",0,null,{"$f":"IF(ISBLANK(E61),0,F$29+1-E61)","v":0},null,{"$f":"IF(ISBLANK(G61),0,H$29+1-G61)","v":0},null,{"$f":"IF(ISBLANK(I61),0,J$29+1-I61)","v":0},null,{"$f":"IF(ISBLANK(K61),0,L$29+1-K61)","v":0},null,{"$f":"IF(ISBLANK(M61),0,N$29+1-M61)","v":0},0,0]
[null,"RESORTED VERSION FOR REVIEW PURPOSES ONLY"]
[null,"Albury Cup","Event >","Albury Points Best 4 from 5","Gazette Cup 4 miles",null,"Alec Potton 7 miles",null,"Christmas Cup 5 km",null,"SWC Open 10 km",null,"SWC Track 3 km",null,"Total Points","Races Walked"]
[null,"Rank","Name    -  date>","after 4","  28/09/14",null,"  2/11/14",null,"  20/12/14",null,"  20/01/15",null,"  03/06/15",null," 2014/15",{"$f":"+O64","v":" 2014/15"}]
[null,null,"David Crane",48,3,12,1,12,1,14,null,0,2,10,48,4]
[null,null,"Peter Selby",40,0,10,0,10,0,10,0,10,"",0,40,4]
[null,null,"Pam Ficken",40,0,10,0,10,0,10,0,10,"",0,40,4]
[null,null,"Nolan Simmons",37,0,10,0,10,0,10,"",0,5,7,37,4]
[null,null,"Dan Maskell",35,2,13,5,8,8,7,3,7,6,6,41,5]
[null,null,"David Hoben",30,null,0,3,10,3,12,null,0,4,8,30,3]
[null,null,"Angela Martin",30,5,10,null,0,6,9,null,0,1,11,30,3]
[null,null,"Peter Crane",30,4,11,2,11,7,8,null,0,null,0,30,3]
[null,null,"Malcolm Martin",27,6,9,null,0,2,13,null,0,7,5,27,3]
[null,null,"Mark Easton",26,0,10,7,6,0,10,"",0,"",0,26,3]
[null,null,"Chris Flint",24,null,0,8,5,4,11,2,8,null,0,24,3]
[null,null,"Paul King",23,1,14,4,9,null,0,null,0,null,0,23,2]
[null,null,"Shaun Lightman",20,null,0,null,0,9,6,5,5,3,9,20,3]
[null,null,"Mick Harran",17,null,0,6,7,5,10,null,0,null,0,17,2]
[null,null,"Sandra Campbell",11,8,7,null,0,null,0,6,4,null,0,11,2]
[null,null,"Paul Gaston",9,null,0,null,0,null,0,1,9,null,0,9,1]
[null,null,"Dave Delaney",8,7,8,null,0,null,0,null,0,null,0,8,1]
[null,null,"Sandra Brown",6,null,0,null,0,null,0,4,6,null,0,6,1]
[null,null,"Trevor Sliwerski",6,9,6,null,0,null,0,null,0,null,0,6,1]
[null,null,"Kathy Crilley",0,null,0,null,0,null,0,null,0,null,0,0,0]
[null,null,"Kevin Burnett",0,null,0,null,0,null,0,null,0,null,0,0,0]

{"sheet":"AL_2017_18","index":8,"n_rows":40,"n_cols":33,"rows_kept":40,"merged":[[1,13,1,14],[3,4,3,5],[3,6,3,7],[3,8,3,9],[3,10,3,11],[3,12,3,13],[4,4,4,5],[4,6,4,7],[4,8,4,9],[4,10,4,11],[4,12,4,13]]}
[]
[null,null,"ALBURY CUP RESULTS 2017/8",{"$nulls":3},"RACE 5 VERSION",{"$nulls":5},"As at: ",{"$f":"NOW()","v":"2018-11-13T16:48:19.780"},{"$nulls":3},"NB Change Ranges Each Year: Table_For_History_Unsorted and Table_For_History_Sorted"]
[{"$nulls":5},"Race handicap position and Albury Cup points",{"$nulls":11},"LINKED Copy of table with columns for history in correct order >>>>>>>",{"$nulls":7},"MANUAL Copy of table (123 copy) rows sorted into alphabetical order of names for transfer to history sheet"]
[null,"Albury Cup","Event >","Albury Points Best 4 from 5","Christmas Cup 5 km",null,"Alec Potton 7 miles",null,"SWC Track 3km",null,"Gazette Cup 4 miles",null,"SWC Open 5km",null,"Total Points","Races Walked",null,"ALBURY CUP 2017/18 UNSORTED by NAME","Event >>",{"$f":"+E33","v":1261},{"$f":"+G33","v":1266},{"$f":"+I33","v":1366},{"$f":"KI33","v":0},{"$f":"+JM2","v":0},null,"ALBURY CUP 2016/17 SORTED by NAME","Event >>",878,917,1109,1123,1144]
[null,"Rank","Name    -  date>","after 5","2017-11-20",null,"28/11/17",null,"2018-05-30",null,"2018-06-27",null,"2018-07-25",null," 2017/18",{"$f":"+O5","v":" 2017/18"},{"$nulls":3},{"$f":"+E5","v":"2017-11-20"},{"$f":"+G5","v":"28/11/17"},{"$f":"+I5","v":"2018-05-30"},{"$f":"+K5","v":"2018-06-27"},{"$f":"+M5","v":"2018-07-25"},{"$nulls":3},"2017-11-20","28/11/17","2018-05-30","2018-06-27","2018-07-19"]
[null,1,"Chris Flint",{"$f":"O6-MIN(F6,H6,J6,L6,N6)","v":33},4,{"$f":"IF(ISBLANK(E6),0,F$30+1-E6)","v":6},4,{"$f":"IF(ISBLANK(G6),0,H$30+1-G6)","v":7},2,{"$f":"IF(ISBLANK(I6),0,J$30+1-I6)","v":11},2,{"$f":"IF(ISBLANK(K6),0,L$30+1-K6)","v":9},null,{"$f":"IF(ISBLANK(M6),0,N$30+1-M6)","v":0},{"$f":"+F6+H6+J6+L6+N6","v":33},{"$f":"+IF(COUNT(E6,G6,I6,K6,M6)>0,COUNT(E6,G6,I6,K6,M6),\"\")","v":4},null,"NAME","Year Rank","Pos 1","Pos 2","Pos 3","Pos 4","Pos 5",null,"NAME","Year Rank","Pos 1","Pos 2","Pos 3","Pos 4","Pos 5"]
[null,2,"Dan Maskell",28,null,0,3,8,4,9,3,8,1,3,28,4,null,{"$f":"RIGHT(C6,LEN(C6)-FIND(\" \",C6)) & \"_\" & LEFT(C6,FIND(\" \",C6)-1)","v":"Flint_Chris"},{"$f":"IF(D6>0,+B6,0)","v":1},{"$f":"+E6","v":4},{"$f":"+G6","v":4},{"$f":"+I6","v":2},{"$f":"+K6","v":2},{"$f":"+M6","v":0},null,"Burnett_Kevin",10,0,0,6,0,0,0]
[null,3,"David Hoben",27,5,5,2,9,5,8,6,5,null,0,27,4,null,"Maskell_Dan",{"$f":"IF(D7>0,+B7,0)","v":2},0,3,4,3,1,null,"Campbell_Sandra",0,0,0,0,0,0,0]
[null,4,"David Crane",20,null,0,1,10,3,10,null,0,null,0,20,2,null,"Hoben_David",3,5,2,5,6,0,null,"Crane_David",4,0,1,3,0,0,0]
[null,5,"Malcolm Martin",14,1,9,6,5,null,0,null,0,null,0,14,2,null,"Crane_David",4,0,1,3,0,0,null,"Crane_Peter",0,0,0,0,0,0,0]
[null,6,"Shaun Lightman",14,2,8,5,6,null,0,null,0,null,0,14,2,null,"Martin_Malcolm",5,1,6,0,0,0,null,"Crane_Steve",0,0,0,0,0,0,0]
[null,7,"Mick Harran",12,null,0,null,0,1,12,null,0,null,0,12,1,null,"Lightman_Shaun",6,2,5,0,0,0,null,"Crilley_Kathy",0,0,0,0,0,0,0]
[null,8,"Nolan Simmons",12,null,0,null,0,7,6,5,6,null,0,12,2,null,"Harran_Mick",7,0,0,1,0,0,null,"Delaney_Dave",0,0,0,0,0,0,0]
[null,9,"Chris Edwards",10,null,0,null,0,null,0,1,10,null,0,10,1,null,"Simmons_Nolan",8,0,0,7,5,0,null,"Easton_Mark",0,0,0,0,0,0,0]
[null,10,"Kevin Burnett",7,null,0,null,0,6,7,null,0,null,0,7,1,null,"Edwards_Chris",9,0,0,0,1,0,null,"Edwards_Chris",9,0,0,0,1,0,0]
[null,11,"Paul Gaston",7,3,7,null,0,null,0,null,0,null,0,7,1,null,"Burnett_Kevin",10,0,0,6,0,0,null,"Flint_Chris",1,4,4,2,2,0,0]
[null,12,"Roger Michell",7,null,0,null,0,null,0,4,7,null,0,7,1,null,"Gaston_Paul",11,3,0,0,0,0,null,"Gaston_Paul",11,3,0,0,0,0,0]
[null,13,"Angela Martin",{"$f":"O18-MIN(F18,H18,J18,L18,N18)","v":0},null,{"$f":"IF(ISBLANK(E18),0,F$30+1-E18)","v":0},null,{"$f":"IF(ISBLANK(G18),0,H$30+1-G18)","v":0},null,{"$f":"IF(ISBLANK(I18),0,J$30+1-I18)","v":0},null,{"$f":"IF(ISBLANK(K18),0,L$30+1-K18)","v":0},null,{"$f":"IF(ISBLANK(M18),0,N$30+1-M18)","v":0},{"$f":"+F18+H18+J18+L18+N18","v":0},{"$f":"+IF(COUNT(E18,G18,I18,K18,M18)>0,COUNT(E18,G18,I18,K18,M18),\"\")","v":""},null,"Michell_Roger",12,0,0,0,4,0,null,"Harran_Mick",7,0,0,1,0,0,0]
[null,14,"Dave Delaney",0,null,0,null,0,null,0,null,0,null,0,0,"",null,"Martin_Angela",0,0,0,0,0,0,null,"Hoben_David",2,5,2,5,6,0,0]
[null,15,"Kathy Crilley",0,null,0,null,0,null,0,null,0,null,0,0,"",null,"Delaney_Dave",0,0,0,0,0,0,null,"King_Paul",0,0,0,0,0,0,0]
[null,16,"Mark Easton",0,null,0,null,0,null,0,null,0,null,0,0,"",null,"Crilley_Kathy",0,0,0,0,0,0,null,"Lightman_Shaun",6,2,5,0,0,0,0]
[null,17,"Paul King",0,null,0,null,0,null,0,null,0,null,0,0,"",null,"Easton_Mark",0,0,0,0,0,0,null,"Martin_Angela",0,0,0,0,0,0,0]
[null,18,"Peter Crane",0,null,0,null,0,null,0,null,0,null,0,0,"",null,"King_Paul",{"$f":"IF(D22>0,+B22,0)","v":0},{"$f":"+E22","v":0},{"$f":"+G22","v":0},{"$f":"+I22","v":0},{"$f":"+K22","v":0},{"$f":"+M22","v":0},null,"Martin_Malcolm",5,1,6,0,0,0,0]
[null,19,"Sandra Campbell",0,null,0,null,0,null,0,null,0,null,0,0,"",null,"Crane_Peter",0,0,0,0,0,0,null,"Maskell_Dan",3,0,3,4,3,0,0]
[null,20,"Steve Crane",0,null,0,null,0,null,0,null,0,null,0,0,"",null,"Campbell_Sandra",0,0,0,0,0,0,null,"Michell_Roger",12,0,0,0,4,0,0]
[null,21,"Trevor Sliwerski",0,null,0,null,0,null,0,null,0,null,0,0,"",null,"Crane_Steve",0,0,0,0,0,0,null,"Simmons_Nolan",8,0,0,7,5,0,0]
[{"$nulls":15},"At least 1 race",null,"Sliwerski_Trevor",0,0,0,0,0,0,null,"Sliwerski_Trevor",0,0,0,0,0,0,0]
[null,null,"SWC Number Out",null,{"$f":"+COUNT(E6:E26)","v":5},null,{"$f":"+COUNT(G6:G26)","v":6},null,{"$f":"+COUNT(I6:I26)","v":7},null,{"$f":"+COUNT(K6:K26)","v":6},null,{"$f":"+COUNT(M6:M26)","v":1},null,null,{"$f":"+COUNT(P6:P26)","v":12}]
[]
[null,null,"Calculated Winning score",null,null,{"$f":"+ROUND(E28*1.5+1.1,0)","v":9},null,{"$f":"+ROUND(G28*1.5+1.1,0)","v":10},null,{"$f":"+ROUND(I28*1.5+1.1,0)","v":12},null,{"$f":"+ROUND(K28*1.5+1.1,0)","v":10},null,{"$f":"+ROUND(M28*1.5+1.1,0)","v":3}]
[null,null,"Check total positions =",null,{"$f":"TEXT(SUM(E6:E26),\"0\")","v":"15"},null,{"$f":"TEXT(SUM(G6:G26),\"0\")","v":"21"},null,{"$f":"TEXT(SUM(I6:I26),\"0\")","v":"28"},null,{"$f":"TEXT(SUM(K6:K26),\"0\")","v":"21"},null,{"$f":"TEXT(SUM(M6:M26),\"0\")","v":"1"}]
[null,null,"If t = walkers then t*( t+1)/2 =",null,{"$f":"+E28*(E28+1)/2","v":15},null,{"$f":"+G28*(G28+1)/2","v":21},null,{"$f":"+I28*(I28+1)/2","v":28},null,{"$f":"+K28*(K28+1)/2","v":21},null,{"$f":"+M28*(M28+1)/2","v":1}]
[null,null,"Actual Event Number",null,1261,null,1266,null,1366,null,1382]
[null,null,"Average points (always t + 2) and awarded to officials",null,{"$f":"INT(SUM(F6:F26)/E28+0.5)","v":7},null,{"$f":"INT(SUM(H6:H26)/G28+0.5)","v":8},null,{"$f":"INT(SUM(J6:J26)/I28+0.5)","v":9},null,8,null,3]
[]
[null,"Officials",null,null,"attend","pts","attend","pts","attend","pts","attend","pts","attend","pts"]
[null,null,"Peter Selby",null,1,{"$f":"IF(E37>0,E$34,0)","v":7},1,{"$f":"IF(G37>0,G$34,0)","v":8},0,{"$f":"IF(I37>0,I$34,0)","v":0},0,{"$f":"IF(K37>0,K$34,0)","v":0},0,{"$f":"IF(M37>0,M$34,0)","v":0}]
[null,null,"Pam Ficken",null,1,7,1,{"$f":"IF(G38>0,G$34,0)","v":8},0,0,0,{"$f":"IF(K38>0,K$34,0)","v":0},0,{"$f":"IF(M38>0,M$34,0)","v":0}]
[null,null,"Mark Easton",null,0,0,null,0,0,0,0,0,0,0]
[null,null,"Nolan Simmons",null,1,7,1,8,0,0,0,0,0,0]

{"sheet":"Notes_and_History_+_Buttons","index":9,"n_rows":57,"n_cols":65,"rows_kept":57}
["Column wdths ",null,"Col A",8.11,null,null,"Table of Handicap loadings",null,null,"Base = ",0.01,"(3rd in last race)"]
[null,null,"year rank col  B",7.29,{"$nulls":3},"last race 1","penult r 2","PenPen r3"]
[null,null,"name C",13.43,"and R",null,"1st",{"$f":"3*K1","v":{"v":0.03,"d":"0.030"}},{"$f":"2*K1","v":{"v":0.02,"d":"0.020"}},{"$f":"+K1","v":{"v":0.01,"d":"0.010"}}]
[null,null,"points D",12,"and S",null,"2nd",{"$f":"2*K1","v":{"v":0.02,"d":"0.020"}},{"$f":"+K1","v":{"v":0.01,"d":"0.010"}},{"v":0,"d":"0.000"}]
[null,null,"events E-N",4.57,null,null,"3rd",{"$f":"+K1","v":{"v":0.01,"d":"0.010"}},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"}]
[null,null,"Total O",8.86]
[null,null,"normal",7.56,null,null,"score = ","16*pos 1+4*pos 2 + pos 3",null,null,">3 = zero"]
[{"$nulls":6},"eg 2nd ,7th,1st last 3 in reverse order >"]
[{"$nulls":7},{"$f":"32+0+1","v":33}]
["case",1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64]
["last race-1- posn",0,1,2,3,0,1,2,3,0,1,2,3,0,1,2,3,0,1,2,3,0,1,2,3,0,1,2,3,0,1,2,3,0,1,2,3,0,1,2,3,0,1,2,3,0,1,2,3,0,1,2,3,0,1,2,3,0,1,2,3,0,1,2,3]
["penu race-2- posn",0,0,0,0,1,1,1,1,2,2,2,2,3,3,3,3,0,0,0,0,1,1,1,1,2,2,2,2,3,3,3,3,0,0,0,0,1,1,1,1,2,2,2,2,3,3,3,3,0,0,0,0,1,1,1,1,2,2,2,2,3,3,3,3]
["penp race-3- posn",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3]
["race-1-Load",0,{"$f":"+$H$3","v":0.03},{"$f":"+$H$4","v":0.02},{"$f":"+$H$5","v":{"v":0.01,"d":"0.010"}},{"v":0,"d":"0.000"},{"$f":"+$H$3","v":{"v":0.03,"d":"0.030"}},{"$f":"+$H$4","v":{"v":0.02,"d":"0.020"}},{"$f":"+$H$5","v":{"v":0.01,"d":"0.010"}},0,{"$f":"+$H$3","v":0.03},{"$f":"+$H$4","v":0.02},{"$f":"+$H$5","v":{"v":0.01,"d":"0.010"}},0,{"$f":"+$H$3","v":0.03},{"$f":"+$H$4","v":0.02},{"$f":"+$H$5","v":{"v":0.01,"d":"0.010"}},0,{"$f":"+$H$3","v":0.03},{"$f":"+$H$4","v":0.02},{"$f":"+$H$5","v":{"v":0.01,"d":"0.010"}},0,{"$f":"+$H$3","v":0.03},{"$f":"+$H$4","v":0.02},{"$f":"+$H$5","v":{"v":0.01,"d":"0.010"}},0,{"$f":"+$H$3","v":0.03},{"$f":"+$H$4","v":0.02},{"$f":"+$H$5","v":{"v":0.01,"d":"0.010"}},0,{"$f":"+$H$3","v":0.03},{"$f":"+$H$4","v":0.02},{"$f":"+$H$5","v":{"v":0.01,"d":"0.010"}},0,{"$f":"+$H$3","v":0.03},{"$f":"+$H$4","v":0.02},{"$f":"+$H$5","v":{"v":0.01,"d":"0.010"}},0,{"$f":"+$H$3","v":0.03},{"$f":"+$H$4","v":0.02},{"$f":"+$H$5","v":{"v":0.01,"d":"0.010"}},0,{"$f":"+$H$3","v":0.03},{"$f":"+$H$4","v":0.02},{"$f":"+$H$5","v":{"v":0.01,"d":"0.010"}},0,{"$f":"+$H$3","v":0.03},{"$f":"+$H$4","v":0.02},{"$f":"+$H$5","v":{"v":0.01,"d":"0.010"}},0,{"$f":"+$H$3","v":0.03},{"$f":"+$H$4","v":0.02},{"$f":"+$H$5","v":{"v":0.01,"d":"0.010"}},0,{"$f":"+$H$3","v":0.03},{"$f":"+$H$4","v":0.02},{"$f":"+$H$5","v":{"v":0.01,"d":"0.010"}},0,{"$f":"+$H$3","v":0.03},{"$f":"+$H$4","v":0.02},{"$f":"+$H$5","v":{"v":0.01,"d":"0.010"}},0,{"$f":"+$H$3","v":0.03},{"$f":"+$H$4","v":0.02},{"$f":"+$H$5","v":{"v":0.01,"d":"0.010"}}]
["race-2-Load",0,0,0,0,{"$f":"+$I$3","v":{"v":0.02,"d":"0.020"}},{"$f":"+$I$3","v":{"v":0.02,"d":"0.020"}},{"v":0.02,"d":"0.020"},{"v":0.02,"d":"0.020"},{"$f":"+$I$4","v":{"v":0.01,"d":"0.010"}},{"$f":"+$I$4","v":{"v":0.01,"d":"0.010"}},{"v":0.01,"d":"0.010"},{"v":0.01,"d":"0.010"},{"$f":"+$I$5","v":{"v":0,"d":"0.000"}},{"$f":"+$I$5","v":{"v":0,"d":"0.000"}},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},0,0,0,0,{"$f":"+$I$3","v":{"v":0.02,"d":"0.020"}},{"$f":"+$I$3","v":{"v":0.02,"d":"0.020"}},{"v":0.02,"d":"0.020"},{"v":0.02,"d":"0.020"},{"$f":"+$I$4","v":{"v":0.01,"d":"0.010"}},{"$f":"+$I$4","v":{"v":0.01,"d":"0.010"}},{"v":0.01,"d":"0.010"},{"v":0.01,"d":"0.010"},{"$f":"+$I$5","v":{"v":0,"d":"0.000"}},{"$f":"+$I$5","v":{"v":0,"d":"0.000"}},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},0,0,0,0,{"$f":"+$I$3","v":{"v":0.02,"d":"0.020"}},{"$f":"+$I$3","v":{"v":0.02,"d":"0.020"}},{"v":0.02,"d":"0.020"},{"v":0.02,"d":"0.020"},{"$f":"+$I$4","v":{"v":0.01,"d":"0.010"}},{"$f":"+$I$4","v":{"v":0.01,"d":"0.010"}},{"v":0.01,"d":"0.010"},{"v":0.01,"d":"0.010"},{"$f":"+$I$5","v":{"v":0,"d":"0.000"}},{"$f":"+$I$5","v":{"v":0,"d":"0.000"}},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},0,0,0,0,{"$f":"+$I$3","v":{"v":0.02,"d":"0.020"}},{"$f":"+$I$3","v":{"v":0.02,"d":"0.020"}},{"v":0.02,"d":"0.020"},{"v":0.02,"d":"0.020"},{"$f":"+$I$4","v":{"v":0.01,"d":"0.010"}},{"$f":"+$I$4","v":{"v":0.01,"d":"0.010"}},{"v":0.01,"d":"0.010"},{"v":0.01,"d":"0.010"},{"$f":"+$I$5","v":{"v":0,"d":"0.000"}},{"$f":"+$I$5","v":{"v":0,"d":"0.000"}},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"}]
["race-3-Load",{"$f":"+$J$5","v":{"v":0,"d":"0.000"}},{"$f":"+$J$5","v":{"v":0,"d":"0.000"}},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"$f":"+$J$3","v":{"v":0.01,"d":"0.010"}},{"$f":"+$J$3","v":{"v":0.01,"d":"0.010"}},{"v":0.01,"d":"0.010"},{"v":0.01,"d":"0.010"},{"v":0.01,"d":"0.010"},{"v":0.01,"d":"0.010"},{"v":0.01,"d":"0.010"},{"v":0.01,"d":"0.010"},{"v":0.01,"d":"0.010"},{"v":0.01,"d":"0.010"},{"v":0.01,"d":"0.010"},{"v":0.01,"d":"0.010"},{"v":0.01,"d":"0.010"},{"v":0.01,"d":"0.010"},{"v":0.01,"d":"0.010"},{"v":0.01,"d":"0.010"},{"$f":"+$J$5","v":{"v":0,"d":"0.000"}},{"$f":"+$J$5","v":{"v":0,"d":"0.000"}},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"$f":"+$J$5","v":{"v":0,"d":"0.000"}},{"$f":"+$J$5","v":{"v":0,"d":"0.000"}},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"}]
[]
["code",{"$f":"+B11*16+B12*4+B13","v":0},16,32,48,4,20,36,52,8,24,40,56,12,28,44,60,1,17,33,49,5,21,37,53,9,25,41,57,13,29,45,61,{"$f":"+AH11*16+AH12*4+AH13","v":2},18,34,50,6,22,38,54,10,26,42,58,14,30,46,62,3,19,35,51,7,23,39,55,11,27,43,59,15,31,47,63]
["Total Loading",{"$f":"+B14+B15+B16","v":{"v":0,"d":"0.000"}},{"v":0.03,"d":"0.030"},{"v":0.02,"d":"0.020"},{"v":0.01,"d":"0.010"},{"v":0.02,"d":"0.020"},{"v":0.05,"d":"0.050"},{"v":0.04,"d":"0.040"},{"v":0.03,"d":"0.030"},{"v":0.01,"d":"0.010"},{"v":0.04,"d":"0.040"},{"v":0.03,"d":"0.030"},{"v":0.02,"d":"0.020"},{"v":0,"d":"0.000"},{"v":0.03,"d":"0.030"},{"v":0.02,"d":"0.020"},{"v":0.01,"d":"0.010"},{"v":0.01,"d":"0.010"},{"v":0.04,"d":"0.040"},{"v":0.03,"d":"0.030"},{"v":0.02,"d":"0.020"},{"v":0.03,"d":"0.030"},{"v":0.060000000000000005,"d":"0.060"},{"v":0.05,"d":"0.050"},{"v":0.04,"d":"0.040"},{"v":0.02,"d":"0.020"},{"v":0.05,"d":"0.050"},{"v":0.04,"d":"0.040"},{"v":0.03,"d":"0.030"},{"v":0.01,"d":"0.010"},{"v":0.04,"d":"0.040"},{"v":0.03,"d":"0.030"},{"v":0.02,"d":"0.020"},{"$f":"+AH14+AH15+AH16","v":{"v":0,"d":"0.000"}},{"v":0.03,"d":"0.030"},{"v":0.02,"d":"0.020"},{"v":0.01,"d":"0.010"},{"v":0.02,"d":"0.020"},{"v":0.05,"d":"0.050"},{"v":0.04,"d":"0.040"},{"v":0.03,"d":"0.030"},{"v":0.01,"d":"0.010"},{"v":0.04,"d":"0.040"},{"v":0.03,"d":"0.030"},{"v":0.02,"d":"0.020"},{"v":0,"d":"0.000"},{"v":0.03,"d":"0.030"},{"v":0.02,"d":"0.020"},{"v":0.01,"d":"0.010"},{"v":0,"d":"0.000"},{"v":0.03,"d":"0.030"},{"v":0.02,"d":"0.020"},{"v":0.01,"d":"0.010"},{"v":0.02,"d":"0.020"},{"v":0.05,"d":"0.050"},{"v":0.04,"d":"0.040"},{"v":0.03,"d":"0.030"},{"v":0.01,"d":"0.010"},{"v":0.04,"d":"0.040"},{"v":0.03,"d":"0.030"},{"v":0.02,"d":"0.020"},{"v":0,"d":"0.000"},{"v":0.03,"d":"0.030"},{"v":0.02,"d":"0.020"},{"v":0.01,"d":"0.010"}]
[null,null,"NB Leave Dates Blank until penalties created"]
["ALBURY CUP RESULTS",null,null,"Sum of factors =",{"$f":"SUM(B25:B135)","v":0.07}," (should be 0.05)"]
["Year","Special","2011/12","2011/12","2011/12","2011/12","2011/12","2011/12","2012/13","2012/13","2012/13","2012/13","2012/13","2012/13","2013/14","2013/14","2013/14","2013/14","2013/14","2013/14","2014/15","2014/15","2014/15","2014/15","2014/15","2014/15","2015/16","2015/16","2015/16","2015/16","2015/16","2015/16","2016/17","2016/17","2016/17","2016/17","2016/17","2016/17","2017/18","2017/18","2017/18","2017/18","2017/18","2017/18"]
["Event","Handicap","Year",101,105,108,112,141,"Year",183,189,195,198,238,"Year",283,289,298,322,372,"Year",420,432,443,509,533,"Year",557,577,585,730,806,"Year",878,917,1099,1123,1144,"Year",{"$f":"AL_2017_18!T4","v":1261},1266,1366,1123,1399]
["Name","*Percentage*","Rank","  15/10/11","  06/11/11","  10/12/11","No Hcp","  06/06/12","Rank"," 20/10/12"," 03/11/12","  08/12/12","  05/01/13","  12/6/13","Rank","  06/10/13","  3/11/13","  21/12/13","  29/03/14","  04/06/14","Rank","2014-09-28","2014-11-02","2014-12-20","2015-06-03","2015-06-03","Rank","2015-09-27","2015-11-01","2015-12-05","2016-06-01","2016-07-27","Rank","2016-11-06","2016-12-03","2017-05-31","2017-06-28","2017-07-19","Rank",{"$f":"AL_2017_18!T5","v":"2017-11-20"},{"$f":"AL_2017_18!U5","v":"28/11/17"},{"$f":"AL_2017_18!V5","v":"2018-05-30"},{"$f":"AL_2017_18!W5","v":"2018-06-27"},"2018-07-25"]
["Atterbury_Lyn",{"v":0,"d":"0.000"},14,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Brown_Sandra",{"v":0,"d":"0.000"},0,0,0,0,0,0,0,0,0,0,0,0,12,0,0,0,4,5,19,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Burnett_Kevin",{"v":0,"d":"0.000"},9,0,0,3,0,2,0,0,0,0,0,0,14,9,0,0,0,6,17,0,0,0,0,0,0,0,0,0,0,0,11,0,0,3,0,0,8,0,0,6,0,0,0,0,0,0,0,0,0,0,0]
["Campbell_Sandra",{"v":0,"d":"0.000"},9,0,0,3,0,2,0,0,0,0,0,0,10,0,0,0,2,4,13,8,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,18,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Crane_David",{"v":0,"d":"0.000"},11,0,0,14,0,1,2,10,5,1,6,2,8,12,12,2,0,0,1,3,1,1,2,2,1,3,1,1,0,2,4,5,1,0,0,2,3,0,1,3,0,0,0,0,0,0,0,0,0,0,0]
["Crane_Peter",{"v":0,"d":"0.000"},0,5,8,13,0,0,7,9,1,8,7,6,9,0,0,4,0,1,5,4,2,7,0,0,0,0,0,0,0,0,0,0,0,0,0,0,16,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Crane_Steve",{"v":0,"d":"0.000"},0,10,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,10,0,0,0,0,1,0,0,0,0,0,0,19,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Crilley_Kathy",{"v":0,"d":"0.000"},6,9,1,9,0,0,11,4,12,0,4,0,11,5,3,0,0,0,16,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,13,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Delaney_Dave",{"v":0,"d":"0.000"},1,1,2,11,0,6,8,7,11,5,8,0,3,1,6,1,0,0,11,7,0,0,0,0,6,0,3,6,0,0,2,3,3,0,1,0,12,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Easton_Mark",{"v":0,"d":"0.000"},3,4,7,2,0,0,12,2,6,0,0,0,15,8,9,0,0,0,14,0,7,0,0,0,8,2,7,0,0,0,0,0,0,0,0,0,14,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Edwards_Chris",{"v":0.02,"d":"0.020"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0]
["Ficken_Pam",{"v":0,"d":"0.000"},15,2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Flint_Chris",{"v":0.01,"d":"0.010"},13,7,0,15,0,0,4,1,7,9,2,4,6,0,11,5,1,5,9,0,8,4,0,5,9,0,0,0,5,6,6,0,4,1,0,0,1,4,4,2,2,0,0,0,0,0,0,0,0,0,0]
["Gaston_Paul",{"v":0,"d":"0.000"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,18,0,0,0,0,0,13,0,0,4,0,0,0,0,0,0,0,0,9,3,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Hannell_Peter",{"v":0,"d":"0.000"},5,8,3,0,0,5,9,0,10,2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Harran_Mick",{"v":0.01,"d":"0.010"},12,0,9,10,0,0,10,5,8,0,3,3,16,7,10,0,0,0,7,0,6,5,0,1,7,4,0,7,4,0,7,4,0,0,0,0,7,0,0,1,0,0,0,0,0,0,0,0,0,0,0]
["Hoben_David",{"v":0,"d":"0.000"},7,6,0,12,0,4,3,8,4,6,5,0,4,6,1,3,0,0,2,0,3,3,4,3,3,0,4,5,2,7,1,1,6,2,3,0,2,5,2,5,6,0,0,0,0,0,0,0,0,0,0]
["Imber_Bernard",{"v":0,"d":"0.000"},17,0,0,7,0,0,0,0,0,0,0,5,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["King_Paul",{"v":0,"d":"0.000"},10,0,6,8,0,0,1,3,2,7,1,1,13,0,8,0,3,0,8,1,4,0,0,0,11,0,2,0,0,0,8,6,0,0,0,0,15,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Lightman_Shaun",{"v":0,"d":"0.000"},2,11,4,4,0,3,6,11,3,3,0,0,7,0,7,8,0,2,10,0,0,9,3,6,4,0,6,0,1,5,0,0,0,0,0,0,6,2,5,0,0,0,0,0,0,0,0,0,0,0,0]
["Martin_Angela",{"v":0,"d":"0.000"},0,0,0,0,0,0,0,0,0,0,0,0,2,10,5,7,5,8,4,5,0,6,1,0,12,0,0,2,0,0,3,2,5,0,0,1,11,0,6,0,0,0,0,0,0,0,0,0,0,0,0]
["Martin_Malcolm",{"v":0,"d":"0.000"},0,0,0,0,0,0,0,0,0,0,0,0,1,4,4,6,6,3,6,6,0,2,7,0,5,0,0,3,0,4,5,8,2,0,0,3,5,1,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Maskell_Dan",{"v":0.03,"d":"0.030"},0,0,0,0,0,0,0,0,0,0,0,0,5,3,2,0,0,7,3,2,5,8,6,4,2,1,5,0,3,3,9,7,0,0,0,0,4,0,3,4,3,1,0,0,0,0,0,0,0,0,0]
["Michell_Roger",{"v":0,"d":"0.000"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,10,0,0,0,2,0,17,0,0,0,4,0,0,0,0,0,0,0,0,0,0]
["Simmons_Nolan",{"v":0,"d":"0.000"},0,0,0,0,0,0,0,0,0,0,0,0,18,11,0,0,0,0,12,0,0,0,5,0,0,0,0,0,0,0,0,0,0,0,0,0,10,0,0,7,5,0,0,0,0,0,0,0,0,0,0]
["Sliwerski_Trevor",{"v":0,"d":"0.000"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,15,9,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,20,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Statter_Andrew",{"v":0,"d":"0.000"},16,0,0,6,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Statter_Ian",{"v":0,"d":"0.000"},4,3,5,5,0,0,5,6,9,4,0,0,17,2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
["Check max",null,{"$f":"+MAX(C25:C52)","v":17},{"$f":"+MAX(D25:D52)","v":11},9,15,0,6,12,11,12,9,8,6,18,12,12,8,6,8,19,9,8,9,7,6,13,4,7,7,5,7,11,8,6,3,3,3,20,5,6,7,6,1,0,0,0,0,0,0,0,0,0,0]
["Theo sum",null,{"$f":"+(C54+1)*C54/2","v":153},{"$f":"+(D54+1)*D54/2","v":66},45,120,0,21,78,66,78,45,36,21,171,78,78,36,21,36,190,45,36,45,28,21,91,10,28,28,15,28,66,36,21,6,6,6,210,15,21,28,21,1,0,0,0,0,0,0,0,0]
["act sum",null,{"$f":"SUM(C27:C52)","v":140},{"$f":"SUM(D25:D52)","v":66},{"$f":"SUM(E27:E52)","v":45},122,0,23,78,66,78,45,36,21,159,78,78,36,{"$f":"SUM(S25:S52)","v":21},36,171,45,36,45,28,21,91,10,28,28,15,28,66,36,21,6,6,6,210,15,21,28,21,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Error",null,null,{"$f":"+D55-D56","v":0},{"$f":"+E55-E56","v":0},{"$f":"+F55-F56","v":-2},{"$f":"+G55-G56","v":0},{"$f":"+H55-H56","v":-2},null,{"$f":"+J55-J56","v":0},{"$f":"+K55-K56","v":0},{"$f":"+L55-L56","v":0},{"$f":"+M55-M56","v":0},{"$f":"+N55-N56","v":0},null,{"$f":"+P55-P56","v":0},{"$f":"+Q55-Q56","v":0},{"$f":"+R55-R56","v":0},{"$f":"+S55-S56","v":0},{"$f":"+T55-T56","v":0},null,{"$f":"+V55-V56","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+AL55-AL56","v":0},{"$f":"+AM55-AM56","v":0},{"$f":"+AN55-AN56","v":0},{"$f":"+AO55-AO56","v":0},{"$f":"+AP55-AP56","v":0},{"$f":"+AQ55-AQ56","v":0},{"$f":"+AR55-AR56","v":0},{"$f":"+AS55-AS56","v":0},{"$f":"+AT55-AT56","v":0},{"$f":"+AU55-AU56","v":0},{"$f":"+AV55-AV56","v":0},{"$f":"+AW55-AW56","v":0},{"$f":"+AX55-AX56","v":0},{"$f":"+AY55-AY56","v":0},{"$f":"+AZ55-AZ56","v":0},{"$f":"+BA55-BA56","v":0},{"$f":"+BB55-BB56","v":0},{"$f":"+BC55-BC56","v":0},{"$f":"+BD55-BD56","v":0},{"$f":"+BE55-BE56","v":0},{"$f":"+BF55-BF56","v":0},{"$f":"+BG55-BG56","v":0},{"$f":"+BH55-BH56","v":0},{"$f":"+BI55-BI56","v":0},{"$f":"+BJ55-BJ56","v":0},{"$f":"+BK55-BK56","v":0},{"$f":"+BL55-BL56","v":0}]

{"sheet":"scratch for manipulation","index":10,"n_rows":20,"n_cols":8,"rows_kept":20}
[]
[null,null,"Brown_Sandra",13,0,0,0,4]
[null,null,"Burnett_Kevin",18,0,0,0,0]
[null,null,"Campbell_Sandra",10,8,0,0,6]
[null,null,"Crane_David",2,3,1,1,0]
[null,null,"Crane_Peter",3,4,2,7,0]
[null,null,"Crilley_Kathy",17,0,0,0,0]
[null,null,"Delaney_Dave",14,7,0,0,0]
[null,null,"Easton_Mark",15,0,7,0,0]
[null,null,"Flint_Chris",4,0,8,4,2]
[null,null,"Gaston_Paul",12,0,0,0,1]
[null,null,"Harran_Mick",9,0,6,5,0]
[null,null,"Hoben_David",6,0,3,3,0]
[null,null,"King_Paul",5,1,4,0,0]
[null,null,"Lightman_Shaun",11,0,0,9,5]
[null,null,"Martin_Angela",8,5,0,6,0]
[null,null,"Martin_Malcolm",7,6,0,2,0]
[null,null,"Maskell_Dan",1,2,5,8,3]
[null,null,"Simmons_Nolan",19,0,0,0,0]
[null,null,"Sliwerski_Trevor",16,9,0,0,0]

{"sheet":"Penalties_Given","index":11,"n_rows":30,"n_cols":11,"rows_kept":30}
["Penalties Used",null," +ve adjustmts > penalty > reduce allowance > increase net time"]
["Date","2014-06-04","3km N Park",{"$nulls":3},"2014-09-28","4m Sandilands"]
["Event details","Hcp Base","Dist conv","Medn Tm",null,null,"Hcp Base","Dist conv","Medn Tm"]
[null,14,0.279682,{"$f":"14+22.5/60","v":{"v":14.375,"d":"14.38"}},null,null,30,0.62144,{"$f":"31+53/60","v":{"v":31.883333333333333,"d":"31.88"}}]
["Colums","Pcn_Man","Pcn_Auto","Mins dec","act hcp","act nt min","Pcn_Man","Pcn_Auto","Mins dec","act hcp","act nt min"]
["Atterbury_Lyn",0,0,{"v":0,"d":"0.00"}]
["Brown_Sandra",-7.000000000000001,0,-1.04,{"v":2.5,"d":"2.50"},{"$f":"14+25/60","v":{"v":14.416666666666666,"d":"14.42"}}]
["Burnett_Kevin",2,0,0.42,{"v":8.5,"d":"8.50"},{"$f":"14+25/60","v":{"v":14.416666666666666,"d":"14.42"}}]
["Campbell_Sandra",0,1,0.14,{"v":7,"d":"7.00"},{"$f":"14+20/60","v":{"v":14.333333333333334,"d":"14.33"}},2,{"v":0.5,"d":"0.50"},-1.17,16.17,{"$f":"33+25/60","v":{"v":33.416666666666664,"d":"33.42"}}]
["Crane_David",0,0.5,-0.08,{"$nulls":5},{"$f":"4+5/6","v":{"v":4.833333333333333,"d":"4.83"}},{"$f":"31+15/60","v":31.25}]
["Crane_Peter",0,0,{"v":0,"d":"0.00"},{"v":6,"d":"6.00"},{"$f":"13+48/60","v":{"v":13.8,"d":"13.80"}},null,{"v":1.5,"d":"1.50"},-0.68,{"$f":"14+1/6","v":{"v":14.166666666666666,"d":"14.17"}},{"$f":"31+26/60","v":{"v":31.433333333333334,"d":"31.43"}}]
["Crane_Steve",-2,0,0.29,null,null,-3]
["Crilley_Kathy",0,0,{"v":0,"d":"0.00"}]
["Delaney_Dave",-2,1,0.23,{"$nulls":3},0.5,-0.27,{"v":13.5,"d":"13.50"},{"$f":"32+22/60","v":{"v":32.36666666666667,"d":"32.37"}}]
["Easton_Mark",0,0,{"v":0,"d":"0.00"}]
["Ficken_Pam",0,0,{"v":0,"d":"0.00"}]
["Flint_Chris",0,1.5,{"v":-0.2,"d":"-0.20"},null,null,2,1,-1.18]
["Hannell_Peter",-1,0,0.17,{"v":4.3333,"d":"4.33"},{"$f":"14+22/60","v":{"v":14.366666666666667,"d":"14.37"}},null,null,{"v":0,"d":"0.00"},{"$f":"11+10/60","v":{"v":11.166666666666666,"d":"11.17"}},{"$f":"32+12/60","v":{"v":32.2,"d":"32.20"}}]
["Harran_Mick",0,0,{"v":0,"d":"0.00"}]
["Hoben_David",0,0.5,-0.04]
["Imber_Bernard",0,0,{"v":0,"d":"0.00"}]
["King_Paul",0,0.5,-0.03,{"$nulls":4},{"v":0,"d":"0.00"},11.33,{"$f":"30+38/60","v":{"v":30.633333333333333,"d":"30.63"}}]
["Lightman_Shaun",0,0,{"v":0,"d":"0.00"},{"$f":"3+10/60","v":{"v":3.1666666666666665,"d":"3.17"}},{"$f":"13+51/60","v":13.85},null,1,-0.35,{"v":8.5,"d":"8.50"}]
["Martin_Angela",1,1,-0.43,{"v":4.33333,"d":"4.33"},{"$f":"15+15/60","v":15.25},null,null,{"v":0,"d":"0.00"},{"v":13.5,"d":"13.50"},{"$f":"31+53/60","v":{"v":31.883333333333333,"d":"31.88"}}]
["Martin_Malcolm",1,0,0.14,{"$f":"1+50/60","v":{"v":1.8333333333333335,"d":"1.83"}},{"$f":"14+2/60","v":{"v":14.033333333333333,"d":"14.03"}},null,0.5,{"v":-0.2,"d":"-0.20"},{"v":3.5,"d":"3.50"},{"$f":"32+7/60","v":{"v":32.11666666666667,"d":"32.12"}}]
["Maskell_Dan",0,1,-0.17,{"v":3.5,"d":"3.50"},{"$f":"14+53/60","v":{"v":14.883333333333333,"d":"14.88"}},2,null,-0.83,9.67,{"$f":"30+48/60","v":{"v":30.8,"d":"30.80"}}]
["Simmons_Nolan",0,0,{"v":0,"d":"0.00"}]
["Sliwerski_Trevor",0,0,{"v":0,"d":"0.00"},{"$nulls":4},{"v":0,"d":"0.00"},14.67,{"$f":"34+55/60","v":{"v":34.916666666666664,"d":"34.92"}}]
["Statter_Andrew",0,0,{"v":0,"d":"0.00"}]
["Statter_Ian",-1,0,0.12]