{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["SeasonInfo","RaceFinishes","Blank","Trophies","Blank (3)","ChampSeriesResults","JulySeriesResults","AugustSeriesResults"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":4,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1904"}

{"sheet":"SeasonInfo","index":0,"n_rows":17,"n_cols":14,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
["Fleet",null,"Series","Part of Champ?",null,"Sail Number","Racer Name",null,null,"Drop Schedule",null,null,"Tie Rules"]
["MC",null,"Champ","Yes",null,509,"Annie Lerew"]
[null,null,"July","Yes",null,1149,"Todd Collins",null,null,0,0,null,"Priority 1","Number of firsts"]
["Year",null,"August","Yes",null,1188,"Eley Thompson",null,null,6,1,null,"Priority 2","Number of seconds"]
[2016,null,null,null,null,1284,"Jim Campbell",null,null,10,2,null,"Priority 3","Number of times one boat beat the other"]
[null,null,null,null,null,2165,"Will Forgrave",null,null,14,3,null,"Priority 4","Who beat who in the last race"]
[null,null,null,null,null,1758,"Max Watrous",null,null,18,4]
[null,null,null,null,null,1998,"Alan Hickman",null,null,22,5]
[null,null,null,null,null,2068,"Tommy Nordberg"]
[null,null,null,null,null,2086,"Tye Nordberg"]
[null,null,null,null,null,2594,"Phil Drick"]
[null,null,null,null,null,2406,"Dan Lorimer"]
[null,null,null,null,null,2411,"Craig Hupp"]
[null,null,null,null,null,2524,"Pete Comfort"]
[null,null,null,null,null,2587,"Wiggins"]
[null,null,null,null,null,1485,"Chris Stearns"]
[null,null,null,null,null,2259,"Hallett"]

{"sheet":"RaceFinishes","index":1,"n_rows":53,"n_cols":36,"rows_kept":53,"cut":false,"hidden":false,"merged":[]}
[null,"2015 MC -Season"]
[]
["Races Scheduled",{"$f":"COUNT(C7:AJ7)","v":25}]
["Total Races Run",{"$f":"COUNTIF(C10:AE10, \"<>\"&\"\")","v":9}]
["Total Competitors in Fleet",{"$f":"COUNTIF(SeasonInfo!F:F, \"*\")+COUNT(SeasonInfo!F:F)-1","v":16},null,{"$f":"RaceFinishes!I6:V24+RaceFinishes!G6","v":{"$error":"#VALUE!"}}]
[null,"Series","July","July","July","July",null,"July","July","July","July","July","July","July","July","July","July","August","August","August","August","August","August","August","August","August","August"]
[null,"Date","2016-07-02","2016-07-02","2016-07-03","2016-07-03","2016-07-04","2016-07-09","2016-07-09","2019-07-10","2019-07-10","2019-07-16","2019-07-16","2019-07-17","2019-07-17","2019-07-23","2016-07-23","2016-07-24","2016-07-24","2019-08-06","2019-08-06","2019-08-07","2016-08-07","2016-08-20","2016-08-20","2016-08-21","2016-08-21"]
[null,"Trophy","Forgrave",null,null,null,"Christensen",null,null,null,null,null,null,null,null,null,null,null,null,"Simons",null,null,null,null,null,null,"Last Chance"]
[null,"Race #","R1","R2","R3","R4","R5","R6","R7","R8","R9","R10","R11","R12","R13","R14","R15 **","R15","R16","R17","R18","R19","R20","R21","R22","R23","R24","R25","R26","R27","R28","R29","R30","R31","R32"]
["Finished Position",1,2086,509,1284,2165,2406,2524,2165,1284,1284]
[null,2,2524,2165,509,1284,null,2165,2406,2165,2165]
[null,3,509,1998,2086,2086,null,1284,1485,1998,509]
[null,4,2165,2411,2165,1998,null,1758,1284,1485,1998]
[null,5,2068,2594,1998,509,null,2086,1998,2086,2259]
[null,6,1149,1149,2068,2587,null,1998,2068,509,1149]
[null,7,2411,2068,null,2068,null,2068,509,2068,2068]
[null,8,1998,1188,null,null,null,2411,2086,2259,2086]
[null,9,2594,null,null,null,null,1485,null,1149,1485]
[null,10,1188,null,null,null,null,509,null,2594,2594]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]
[null,16]
[null,17]
[null,18]
[null,19]
[null,20]
[null,21]
[null,22]
[null,23]
[null,24]
[null,25]
[null,"DNF"]
[null,"DNF"]
[null,"DNF"]
[null,"DNF"]
[null,"DNF"]
[null,"DNF"]
[null,"Regatta Points"]
[null,"Regatta Points"]
[null,"Regatta Points"]
[null,"Regatta Points"]
[null,"Regatta Points"]
[null,"DSQ"]
[null,"DSQ"]
[null,"DSQ"]
[null,"# starting",{"$f":"COUNTIF(C10:C40, \"<>\"&\"\")","v":10},{"$f":"COUNTIF(D10:D40, \"<>\"&\"\")","v":8},6,7,1,10,8,10,10,{"$f":"COUNTIF(L10:L40, \"<>\"&\"\")","v":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]
[null,"DNF",{"$f":"COUNTIF(C35:C40, \"<>\"&\"\")","v":0},{"$f":"COUNTIF(D35:D40, \"<>\"&\"\")","v":0},0,0,0,0,0,0,0,{"$f":"COUNTIF(L35:L40, \"<>\"&\"\")","v":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]
[null,"DSQ",{"$f":"COUNTIF(C46:C48, \"<>\"&\"\")","v":0},{"$f":"COUNTIF(D46:D48, \"<>\"&\"\")","v":0},0,0,0,0,0,0,0,{"$f":"COUNTIF(L46:L48, \"<>\"&\"\")","v":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]
[null,"Regatta Points",{"$f":"COUNTIF(C41:C45, \"<>\"&\"\")","v":0},{"$f":"COUNTIF(D41:D45, \"<>\"&\"\")","v":0},0,0,0,0,0,0,0,{"$f":"COUNTIF(L41:L45, \"<>\"&\"\")","v":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]
[null,"In Champ?",{"$f":"IFERROR(IF(VLOOKUP(C6, SeasonInfo!$C$2:$G$27, 2, FALSE)=\"Yes\", \"Champ\"), \"No\")","v":"Champ"},{"$f":"IFERROR(IF(VLOOKUP(D6, SeasonInfo!$C$2:$G$27, 2, FALSE)=\"Yes\", \"Champ\"), \"No\")","v":"Champ"},{"$f":"IFERROR(IF(VLOOKUP(E6, SeasonInfo!$C$2:$G$27, 2, FALSE)=\"Yes\", \"Champ\"), \"No\")","v":"Champ"},{"$f":"IFERROR(IF(VLOOKUP(F6, SeasonInfo!$C$2:$G$27, 2, FALSE)=\"Yes\", \"Champ\"), \"No\")","v":"Champ"},"No",{"$f":"IFERROR(IF(VLOOKUP(H6, SeasonInfo!$C$2:$G$27, 2, FALSE)=\"Yes\", \"Champ\"), \"No\")","v":"Champ"},{"$f":"IFERROR(IF(VLOOKUP(I6, SeasonInfo!$C$2:$G$27, 2, FALSE)=\"Yes\", \"Champ\"), \"No\")","v":"Champ"},{"$f":"IFERROR(IF(VLOOKUP(J6, SeasonInfo!$C$2:$G$27, 2, FALSE)=\"Yes\", \"Champ\"), \"No\")","v":"Champ"},{"$f":"IFERROR(IF(VLOOKUP(K6, SeasonInfo!$C$2:$G$27, 2, FALSE)=\"Yes\", \"Champ\"), \"No\")","v":"Champ"},{"$f":"IFERROR(IF(VLOOKUP(L6, SeasonInfo!$C$2:$G$27, 2, FALSE)=\"Yes\", \"Champ\"), \"No\")","v":"Champ"},{"$f":"IFERROR(IF(VLOOKUP(M6, SeasonInfo!$C$2:$G$27, 2, FALSE)=\"Yes\", \"Champ\"), \"No\")","v":"Champ"},{"$f":"IFERROR(IF(VLOOKUP(N6, SeasonInfo!$C$2:$G$27, 2, FALSE)=\"Yes\", \"Champ\"), \"No\")","v":"Champ"},{"$f":"IFERROR(IF(VLOOKUP(O6, SeasonInfo!$C$2:$G$27, 2, FALSE)=\"Yes\", \"Champ\"), \"No\")","v":"Champ"},{"$f":"IFERROR(IF(VLOOKUP(P6, SeasonInfo!$C$2:$G$27, 2, FALSE)=\"Yes\", \"Champ\"), \"No\")","v":"Champ"},{"$f":"IFERROR(IF(VLOOKUP(Q6, SeasonInfo!$C$2:$G$27, 2, FALSE)=\"Yes\", \"Champ\"), \"No\")","v":"Champ"},{"$f":"IFERROR(IF(VLOOKUP(R6, SeasonInfo!$C$2:$G$27, 2, FALSE)=\"Yes\", \"Champ\"), \"No\")","v":"Champ"},{"$f":"IFERROR(IF(VLOOKUP(S6, SeasonInfo!$C$2:$G$27, 2, FALSE)=\"Yes\", \"Champ\"), \"No\")","v":"Champ"},{"$f":"IFERROR(IF(VLOOKUP(T6, SeasonInfo!$C$2:$G$27, 2, FALSE)=\"Yes\", \"Champ\"), \"No\")","v":"Champ"},{"$f":"IFERROR(IF(VLOOKUP(U6, SeasonInfo!$C$2:$G$27, 2, FALSE)=\"Yes\", \"Champ\"), \"No\")","v":"Champ"},{"$f":"IFERROR(IF(VLOOKUP(V6, SeasonInfo!$C$2:$G$27, 2, FALSE)=\"Yes\", \"Champ\"), \"No\")","v":"Champ"},{"$f":"IFERROR(IF(VLOOKUP(W6, SeasonInfo!$C$2:$G$27, 2, FALSE)=\"Yes\", \"Champ\"), \"No\")","v":"Champ"},{"$f":"IFERROR(IF(VLOOKUP(X6, SeasonInfo!$C$2:$G$27, 2, FALSE)=\"Yes\", \"Champ\"), \"No\")","v":"Champ"},{"$f":"IFERROR(IF(VLOOKUP(Y6, SeasonInfo!$C$2:$G$27, 2, FALSE)=\"Yes\", \"Champ\"), \"No\")","v":"Champ"},{"$f":"IFERROR(IF(VLOOKUP(Z6, SeasonInfo!$C$2:$G$27, 2, FALSE)=\"Yes\", \"Champ\"), \"No\")","v":"Champ"},{"$f":"IFERROR(IF(VLOOKUP(AA6, SeasonInfo!$C$2:$G$27, 2, FALSE)=\"Yes\", \"Champ\"), \"No\")","v":"Champ"},{"$f":"IFERROR(IF(VLOOKUP(AB6, SeasonInfo!$C$2:$G$27, 2, FALSE)=\"Yes\", \"Champ\"), \"No\")","v":"No"},{"$f":"IFERROR(IF(VLOOKUP(AC6, SeasonInfo!$C$2:$G$27, 2, FALSE)=\"Yes\", \"Champ\"), \"No\")","v":"No"},{"$f":"IFERROR(IF(VLOOKUP(AD6, SeasonInfo!$C$2:$G$27, 2, FALSE)=\"Yes\", \"Champ\"), \"No\")","v":"No"},{"$f":"IFERROR(IF(VLOOKUP(AE6, SeasonInfo!$C$2:$G$27, 2, FALSE)=\"Yes\", \"Champ\"), \"No\")","v":"No"},{"$f":"IFERROR(IF(VLOOKUP(AF6, SeasonInfo!$C$2:$G$27, 2, FALSE)=\"Yes\", \"Champ\"), \"No\")","v":"No"},{"$f":"IFERROR(IF(VLOOKUP(AG6, SeasonInfo!$C$2:$G$27, 2, FALSE)=\"Yes\", \"Champ\"), \"No\")","v":"No"},{"$f":"IFERROR(IF(VLOOKUP(AH6, SeasonInfo!$C$2:$G$27, 2, FALSE)=\"Yes\", \"Champ\"), \"No\")","v":"No"},{"$f":"IFERROR(IF(VLOOKUP(AI6, SeasonInfo!$C$2:$G$27, 2, FALSE)=\"Yes\", \"Champ\"), \"No\")","v":"No"},{"$f":"IFERROR(IF(VLOOKUP(AJ6, SeasonInfo!$C$2:$G$27, 2, FALSE)=\"Yes\", \"Champ\"), \"No\")","v":"No"}]

{"sheet":"Blank","index":2,"n_rows":9,"n_cols":5,"rows_kept":9,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Series:"]
[]
[null,"Races In Series:",null,null,"DSQ"]
[null,"Drops:",{"$f":"VLOOKUP(C4,SeasonInfo!J3:K7,2)","v":0},null,"DNS"]
[null,"Total Count of Racers:",null,null,"Redress"]
[null,null,null,null,"DNF"]
[null,"Race Date"]
[null,{"$f":"A9&\" - \"& VLOOKUP(A9, SeasonInfo!F:G, 2, FALSE)","v":{"$error":"#N/A"}}]

{"sheet":"Trophies","index":3,"n_rows":6,"n_cols":4,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Trophy Results:",{"$f":"SeasonInfo!A2&\" Fleet\"","v":"MC Fleet"}]
[]
[null,"Trophy","Date","Winner"]
[2406,"Christensen","2016-07-04",{"$f":"A5&\" - \"& VLOOKUP(A5, SeasonInfo!$F:$G, 2, FALSE)","v":"2406 - Dan Lorimer"}]
[null,"Simons","2019-08-06",{"$f":"A6&\" - \"& VLOOKUP(A6, SeasonInfo!$F:$G, 2, FALSE)","v":{"$error":"#N/A"}}]

{"sheet":"Blank (3)","index":4,"n_rows":9,"n_cols":5,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Series:"]
[]
[null,"Races In Series:",null,null,"DSQ"]
[null,"Drops:",{"$f":"VLOOKUP(C4,SeasonInfo!J3:K7,2)","v":0},null,"DNS"]
[null,"Total Count of Racers:",null,null,"Redress"]
[null,null,null,null,"DNF"]
[null,"Race Date"]
[null,{"$f":"A9&\" - \"& VLOOKUP(A9, SeasonInfo!F:G, 2, FALSE)","v":{"$error":"#N/A"}}]

{"sheet":"ChampSeriesResults","index":5,"n_rows":27,"n_cols":54,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Series:","2016 MC Champ Results"]
[]
[null,"Races In Series:",8,null,"DSQ"]
[null,"Drops:",{"$f":"VLOOKUP(C4,SeasonInfo!J3:K7,2)","v":1},null,"DNS"]
[null,"Total Count of Racers:",16,null,"Redress"]
[null,null,null,null,"DNF"]
[null,"Race Date","2016-07-02","2016-07-02","2016-07-03","2016-07-03","2016-07-09","2016-07-09","2019-07-10","2019-07-10",null,"Total Points",null,"Drop 1",null,"Grand Total",null,null,null,null,null,509,1149,1188,1284,2165,1758,1998,2068,2086,2594,2406,2411,2524,2587,1485,2259,null,509,1149,1188,1284,2165,1758,1998,2068,2086,2594,2406,2411,2524,2587,1485,2259]
[2165,{"$f":"A9&\" - \"& VLOOKUP(A9, SeasonInfo!F:G, 2, FALSE)","v":"2165 - Will Forgrave"},4,2,4,1,2,1,2,2,null,{"$f":"SUM(C9:J9)","v":18},null,{"$f":"LARGE(C9:J9, 1)","v":4},null,{"$f":"L9-N9","v":14},null,0,{"$f":"IFERROR(AVERAGE(C9:K9),999)","v":2.25},{"$f":"COUNTIF(B9:L9,1)","v":2},{"$f":"COUNTIF(B9:L9,2)","v":4},0,1,1,0,0,1,1,1,1,1,1,1,1,1,1,1,null,0,8,8,-4,-2,6,0,4,0,8,6,6,4,8,2,8]
[1284,{"$f":"A10&\" - \"& VLOOKUP(A10, SeasonInfo!F:G, 2, FALSE)","v":"1284 - Jim Campbell"},11,9,1,2,3,4,1,1,null,32,null,11,null,21,null,0,4,3,1,0,0,1,0,0,1,0,0,0,1,0,1,0,1,1,0,null,-8,0,4,-4,-8,3,-6,-4,-4,2,3,1,1,3,0,0]
[509,{"$f":"A11&\" - \"& VLOOKUP(A11, SeasonInfo!F:G, 2, FALSE)","v":"509 - Annie Lerew"},3,1,2,5,10,7,6,3,null,37,null,10,null,27,null,0,4.625,1,1,0,0,0,0,0,1,0,0,0,0,0,0,0,1,0,0,null,-8,-4,0,-4,-8,1,-8,-8,-6,-4,1,-3,-1,1,-2,0]
[1998,{"$f":"A12&\" - \"& VLOOKUP(A12, SeasonInfo!F:G, 2, FALSE)","v":"1998 - Alan Hickman"},8,3,5,4,6,5,3,4,null,38,null,8,null,30,null,0,4.75,0,0,1,1,1,0,1,1,1,1,1,1,1,1,1,1,1,1,null,4,4,4,0,-2,6,4,4,5,4,4,4,3,6,4,6]
[2086,{"$f":"A13&\" - \"& VLOOKUP(A13, SeasonInfo!F:G, 2, FALSE)","v":"2086 - Tye Nordberg"},1,9,3,3,5,8,5,8,null,42,null,9,null,33,null,0,5.25,1,0,1,1,1,0,0,1,1,1,1,1,1,1,1,1,1,1,null,2,8,8,2,0,8,8,8,4,8,8,8,4,8,8,8]
[2068,{"$f":"A14&\" - \"& VLOOKUP(A14, SeasonInfo!F:G, 2, FALSE)","v":"2068 - Tommy Nordberg"},5,7,6,7,7,6,7,7,null,52,null,7,null,45,null,0,6.5,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,null,-6,-3,-1,-6,-8,0,-6,-6,-5,-3,0,-1,-2,0,-2,-1]
[2524,{"$f":"A15&\" - \"& VLOOKUP(A15, SeasonInfo!F:G, 2, FALSE)","v":"2524 - Pete Comfort"},2,9,7,8,1,9,11,11,null,58,null,11,null,47,null,0,7.25,1,1,0,1,1,0,0,1,0,1,0,1,0,1,0,1,1,1,null,0,6,8,-4,-8,6,0,6,0,8,6,6,4,8,6,8]
[1485,{"$f":"A16&\" - \"& VLOOKUP(A16, SeasonInfo!F:G, 2, FALSE)","v":"1485 - Chris Stearns"},11,9,7,8,9,3,4,9,null,60,null,11,null,49,null,0,7.5,0,0,0,1,1,0,0,1,0,0,0,1,0,1,0,1,1,1,null,-4,4,8,-4,-8,6,-6,0,-2,6,6,6,4,6,4,6]
[1149,{"$f":"A17&\" - \"& VLOOKUP(A17, SeasonInfo!F:G, 2, FALSE)","v":"1149 - Todd Collins"},6,6,7,8,11,9,9,6,null,62,null,11,null,51,null,0,7.75,0,0,0,1,1,0,0,1,1,1,0,1,1,1,0,1,1,1,null,0,4,6,-5,-4,5,0,2,0,6,5,6,5,7,3,5]
[2411,{"$f":"A18&\" - \"& VLOOKUP(A18, SeasonInfo!F:G, 2, FALSE)","v":"2411 - Craig Hupp"},7,4,7,8,8,9,11,11,null,65,null,11,null,54,null,0,8.125,0,0,0,0,1,0,0,1,0,0,0,0,0,0,0,1,0,0,null,-8,-2,4,-4,-8,3,-8,-6,-6,0,3,-1,1,3,-2,0]
[2259,{"$f":"A19&\" - \"& VLOOKUP(A19, SeasonInfo!F:G, 2, FALSE)","v":"2259 - Hallett"},11,9,7,8,11,9,8,5,null,68,null,11,null,57,null,0,8.5,0,0,0,1,1,0,0,1,1,1,0,1,0,1,0,1,1,1,null,-6,-3,-1,-4,-8,0,-6,-6,-5,-3,0,-2,-1,0,-2,-1]
[2594,{"$f":"A20&\" - \"& VLOOKUP(A20, SeasonInfo!F:G, 2, FALSE)","v":"2594 - Phil Drick"},9,5,7,8,11,9,10,10,null,69,null,11,null,58,null,0,8.625,0,0,0,0,1,0,0,1,0,0,0,1,0,0,0,1,0,1,null,-6,-1,3,-4,-8,1,-6,-6,-6,1,2,0,-1,2,0,1]
[2406,{"$f":"A21&\" - \"& VLOOKUP(A21, SeasonInfo!F:G, 2, FALSE)","v":"2406 - Dan Lorimer"},11,9,7,8,11,2,11,11,null,70,null,11,null,59,"(T)",1,8.75,0,1,0,1,1,0,0,1,1,1,1,1,1,1,0,1,1,1,null,-4,-1,1,-3,-4,2,-4,-4,-5,-1,1,1,0,1,-1,0]
[1758,{"$f":"A22&\" - \"& VLOOKUP(A22, SeasonInfo!F:G, 2, FALSE)","v":"1758 - Max Watrous"},11,9,7,8,4,9,11,11,null,70,null,11,null,59,"(T)",0,8.75,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,-8,-3,-1,-6,-8,0,-8,-6,-7,-3,0,-2,-1,0,-3,-1]
[1188,{"$f":"A23&\" - \"& VLOOKUP(A23, SeasonInfo!F:G, 2, FALSE)","v":"1188 - Eley Thompson"},10,8,7,8,11,9,11,11,null,75,null,11,null,64,"(T)",1,9.375,0,0,0,0,1,0,0,1,0,0,0,1,0,1,0,1,0,1,null,-2,0,2,-4,-8,2,-6,-4,-3,2,2,0,1,3,0,2]
[2587,{"$f":"A24&\" - \"& VLOOKUP(A24, SeasonInfo!F:G, 2, FALSE)","v":"2587 - Wiggins"},11,9,7,6,11,9,11,11,null,75,null,11,null,64,"(T)",0,9.375,0,0,0,1,1,0,0,1,0,0,0,1,0,0,0,1,0,0,null,-8,0,0,-6,-8,1,-8,-6,-5,0,1,-1,0,1,-2,0]
[]
[null,"Total Starters:",10,8,6,7,10,8,10,10]
[null,"Total Finishers:",10,8,6,7,10,8,10,10]

{"sheet":"JulySeriesResults","index":6,"n_rows":27,"n_cols":54,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Series:","2016 MC July Results"]
[]
[null,"Races In Series:",8,null,"DSQ"]
[null,"Drops:",{"$f":"VLOOKUP(C4,SeasonInfo!J3:K7,2)","v":1},null,"DNS"]
[null,"Total Count of Racers:",16,null,"Redress"]
[null,null,null,null,"DNF"]
[null,"Race Date","2016-07-02","2016-07-02","2016-07-03","2016-07-03","2016-07-09","2016-07-09","2019-07-10","2019-07-10",null,"Total Points",null,"Drop 1",null,"Grand Total",null,null,null,null,null,509,1149,1188,1284,2165,1758,1998,2068,2086,2594,2406,2411,2524,2587,1485,2259,null,509,1149,1188,1284,2165,1758,1998,2068,2086,2594,2406,2411,2524,2587,1485,2259]
[2165,{"$f":"A9&\" - \"& VLOOKUP(A9, SeasonInfo!F:G, 2, FALSE)","v":"2165 - Will Forgrave"},4,2,4,1,2,1,2,2,null,{"$f":"SUM(C9:J9)","v":18},null,{"$f":"LARGE(C9:J9, 1)","v":4},null,{"$f":"L9-N9","v":14},null,0,{"$f":"IFERROR(AVERAGE(C9:K9),999)","v":2.25},{"$f":"COUNTIF(B9:L9,1)","v":2},{"$f":"COUNTIF(B9:L9,2)","v":4},0,1,1,0,0,1,1,1,1,1,1,1,1,1,1,1,null,0,8,8,-4,-2,6,0,4,0,8,6,6,4,8,2,8]
[1284,{"$f":"A10&\" - \"& VLOOKUP(A10, SeasonInfo!F:G, 2, FALSE)","v":"1284 - Jim Campbell"},11,9,1,2,3,4,1,1,null,32,null,11,null,21,null,0,4,3,1,0,0,1,0,0,1,0,0,0,1,0,1,0,1,1,0,null,-8,0,4,-4,-8,3,-6,-4,-4,2,3,1,1,3,0,0]
[509,{"$f":"A11&\" - \"& VLOOKUP(A11, SeasonInfo!F:G, 2, FALSE)","v":"509 - Annie Lerew"},3,1,2,5,10,7,6,3,null,37,null,10,null,27,null,0,4.625,1,1,0,0,0,0,0,1,0,0,0,0,0,0,0,1,0,0,null,-8,-4,0,-4,-8,1,-8,-8,-6,-4,1,-3,-1,1,-2,0]
[1998,{"$f":"A12&\" - \"& VLOOKUP(A12, SeasonInfo!F:G, 2, FALSE)","v":"1998 - Alan Hickman"},8,3,5,4,6,5,3,4,null,38,null,8,null,30,null,0,4.75,0,0,1,1,1,0,1,1,1,1,1,1,1,1,1,1,1,1,null,4,4,4,0,-2,6,4,4,5,4,4,4,3,6,4,6]
[2086,{"$f":"A13&\" - \"& VLOOKUP(A13, SeasonInfo!F:G, 2, FALSE)","v":"2086 - Tye Nordberg"},1,9,3,3,5,8,5,8,null,42,null,9,null,33,null,0,5.25,1,0,1,1,1,0,0,1,1,1,1,1,1,1,1,1,1,1,null,2,8,8,2,0,8,8,8,4,8,8,8,4,8,8,8]
[2068,{"$f":"A14&\" - \"& VLOOKUP(A14, SeasonInfo!F:G, 2, FALSE)","v":"2068 - Tommy Nordberg"},5,7,6,7,7,6,7,7,null,52,null,7,null,45,null,0,6.5,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,null,-6,-3,-1,-6,-8,0,-6,-6,-5,-3,0,-1,-2,0,-2,-1]
[2524,{"$f":"A15&\" - \"& VLOOKUP(A15, SeasonInfo!F:G, 2, FALSE)","v":"2524 - Pete Comfort"},2,9,7,8,1,9,11,11,null,58,null,11,null,47,null,0,7.25,1,1,0,1,1,0,0,1,0,1,0,1,0,1,0,1,1,1,null,0,6,8,-4,-8,6,0,6,0,8,6,6,4,8,6,8]
[1485,{"$f":"A16&\" - \"& VLOOKUP(A16, SeasonInfo!F:G, 2, FALSE)","v":"1485 - Chris Stearns"},11,9,7,8,9,3,4,9,null,60,null,11,null,49,null,0,7.5,0,0,0,1,1,0,0,1,0,0,0,1,0,1,0,1,1,1,null,-4,4,8,-4,-8,6,-6,0,-2,6,6,6,4,6,4,6]
[1149,{"$f":"A17&\" - \"& VLOOKUP(A17, SeasonInfo!F:G, 2, FALSE)","v":"1149 - Todd Collins"},6,6,7,8,11,9,9,6,null,62,null,11,null,51,null,0,7.75,0,0,0,1,1,0,0,1,1,1,0,1,1,1,0,1,1,1,null,0,4,6,-5,-4,5,0,2,0,6,5,6,5,7,3,5]
[2411,{"$f":"A18&\" - \"& VLOOKUP(A18, SeasonInfo!F:G, 2, FALSE)","v":"2411 - Craig Hupp"},7,4,7,8,8,9,11,11,null,65,null,11,null,54,null,0,8.125,0,0,0,0,1,0,0,1,0,0,0,0,0,0,0,1,0,0,null,-8,-2,4,-4,-8,3,-8,-6,-6,0,3,-1,1,3,-2,0]
[2259,{"$f":"A19&\" - \"& VLOOKUP(A19, SeasonInfo!F:G, 2, FALSE)","v":"2259 - Hallett"},11,9,7,8,11,9,8,5,null,68,null,11,null,57,null,0,8.5,0,0,0,1,1,0,0,1,1,1,0,1,0,1,0,1,1,1,null,-6,-3,-1,-4,-8,0,-6,-6,-5,-3,0,-2,-1,0,-2,-1]
[2594,{"$f":"A20&\" - \"& VLOOKUP(A20, SeasonInfo!F:G, 2, FALSE)","v":"2594 - Phil Drick"},9,5,7,8,11,9,10,10,null,69,null,11,null,58,null,0,8.625,0,0,0,0,1,0,0,1,0,0,0,1,0,0,0,1,0,1,null,-6,-1,3,-4,-8,1,-6,-6,-6,1,2,0,-1,2,0,1]
[2406,{"$f":"A21&\" - \"& VLOOKUP(A21, SeasonInfo!F:G, 2, FALSE)","v":"2406 - Dan Lorimer"},11,9,7,8,11,2,11,11,null,70,null,11,null,59,"(T)",1,8.75,0,1,0,1,1,0,0,1,1,1,1,1,1,1,0,1,1,1,null,-4,-1,1,-3,-4,2,-4,-4,-5,-1,1,1,0,1,-1,0]
[1758,{"$f":"A22&\" - \"& VLOOKUP(A22, SeasonInfo!F:G, 2, FALSE)","v":"1758 - Max Watrous"},11,9,7,8,4,9,11,11,null,70,null,11,null,59,"(T)",0,8.75,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,-8,-3,-1,-6,-8,0,-8,-6,-7,-3,0,-2,-1,0,-3,-1]
[1188,{"$f":"A23&\" - \"& VLOOKUP(A23, SeasonInfo!F:G, 2, FALSE)","v":"1188 - Eley Thompson"},10,8,7,8,11,9,11,11,null,75,null,11,null,64,"(T)",1,9.375,0,0,0,0,1,0,0,1,0,0,0,1,0,1,0,1,0,1,null,-2,0,2,-4,-8,2,-6,-4,-3,2,2,0,1,3,0,2]
[2587,{"$f":"A24&\" - \"& VLOOKUP(A24, SeasonInfo!F:G, 2, FALSE)","v":"2587 - Wiggins"},11,9,7,6,11,9,11,11,null,75,null,11,null,64,"(T)",0,9.375,0,0,0,1,1,0,0,1,0,0,0,1,0,0,0,1,0,0,null,-8,0,0,-6,-8,1,-8,-6,-5,0,1,-1,0,1,-2,0]
[]
[null,"Total Starters:",10,8,6,7,10,8,10,10]
[null,"Total Finishers:",10,8,6,7,10,8,10,10]

{"sheet":"AugustSeriesResults","index":7,"n_rows":27,"n_cols":45,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Series:","2016 MC August Results"]
[]
[null,"Races In Series:",null,null,"DSQ"]
[null,"Drops:",{"$f":"VLOOKUP(C4,SeasonInfo!J3:K7,2)","v":0},null,"DNS"]
[null,"Total Count of Racers:",16,null,"Redress"]
[null,null,null,null,"DNF"]
[null,"Race Date",null,"Total Points",null,null,"Grand Total",null,null,null,null,null,509,1149,1188,1284,2165,1758,1998,2068,2086,2594,2406,2411,2524,2587,1485,2259,null,509,1149,1188,1284,2165,1758,1998,2068,2086,2594,2406,2411,2524,2587,1485,2259]
[509,{"$f":"A9&\" - \"& VLOOKUP(A9, SeasonInfo!F:G, 2, FALSE)","v":"509 - Annie Lerew"},null,null,null,null,{"$f":"D9","v":0},"(T)",0,{"$f":"IFERROR(AVERAGE(C9:C9),999)","v":999},{"$f":"COUNTIF(B9:C9,1)","v":0},{"$f":"COUNTIF(B9:C9,2)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[1149,{"$f":"A10&\" - \"& VLOOKUP(A10, SeasonInfo!F:G, 2, FALSE)","v":"1149 - Todd Collins"},null,null,null,null,0,"(T)",0,999,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[1188,{"$f":"A11&\" - \"& VLOOKUP(A11, SeasonInfo!F:G, 2, FALSE)","v":"1188 - Eley Thompson"},null,null,null,null,0,"(T)",0,999,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[1284,{"$f":"A12&\" - \"& VLOOKUP(A12, SeasonInfo!F:G, 2, FALSE)","v":"1284 - Jim Campbell"},null,null,null,null,0,"(T)",0,999,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[2165,{"$f":"A13&\" - \"& VLOOKUP(A13, SeasonInfo!F:G, 2, FALSE)","v":"2165 - Will Forgrave"},null,null,null,null,0,"(T)",0,999,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[1758,{"$f":"A14&\" - \"& VLOOKUP(A14, SeasonInfo!F:G, 2, FALSE)","v":"1758 - Max Watrous"},null,null,null,null,0,"(T)",0,999,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[1998,{"$f":"A15&\" - \"& VLOOKUP(A15, SeasonInfo!F:G, 2, FALSE)","v":"1998 - Alan Hickman"},null,null,null,null,0,"(T)",0,999,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[2068,{"$f":"A16&\" - \"& VLOOKUP(A16, SeasonInfo!F:G, 2, FALSE)","v":"2068 - Tommy Nordberg"},null,null,null,null,0,"(T)",0,999,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[2086,{"$f":"A17&\" - \"& VLOOKUP(A17, SeasonInfo!F:G, 2, FALSE)","v":"2086 - Tye Nordberg"},null,null,null,null,0,"(T)",0,999,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[2594,{"$f":"A18&\" - \"& VLOOKUP(A18, SeasonInfo!F:G, 2, FALSE)","v":"2594 - Phil Drick"},null,null,null,null,0,"(T)",0,999,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[2406,{"$f":"A19&\" - \"& VLOOKUP(A19, SeasonInfo!F:G, 2, FALSE)","v":"2406 - Dan Lorimer"},null,null,null,null,0,"(T)",0,999,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[2411,{"$f":"A20&\" - \"& VLOOKUP(A20, SeasonInfo!F:G, 2, FALSE)","v":"2411 - Craig Hupp"},null,null,null,null,0,"(T)",0,999,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[2524,{"$f":"A21&\" - \"& VLOOKUP(A21, SeasonInfo!F:G, 2, FALSE)","v":"2524 - Pete Comfort"},null,null,null,null,0,"(T)",0,999,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[2587,{"$f":"A22&\" - \"& VLOOKUP(A22, SeasonInfo!F:G, 2, FALSE)","v":"2587 - Wiggins"},null,null,null,null,0,"(T)",0,999,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[1485,{"$f":"A23&\" - \"& VLOOKUP(A23, SeasonInfo!F:G, 2, FALSE)","v":"1485 - Chris Stearns"},null,null,null,null,0,"(T)",0,999,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[2259,{"$f":"A24&\" - \"& VLOOKUP(A24, SeasonInfo!F:G, 2, FALSE)","v":"2259 - Hallett"},null,null,null,null,0,"(T)",0,999,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Total Starters:"]
[null,"Total Finishers:"]