{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Leader Board","Round 1","Round 2","Round 3","Round 4","Round 5","Round 6","SumSheet"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":24,"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":"Leader Board","index":0,"n_rows":17,"n_cols":13,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,1,1,8],[1,12,1,19]]}
[null,null,null,null,null,null,null,null,null,null,null,null,"Used to reformat the leader board after resorting the results. DO NOT MODIFY"]
[null,{"$f":" SeriesName & \" - Round \" & RoundsRun & \" of 6  (Overall)\"","v":"2013 BRM Series - Round 2 of 6  (Overall)"}]
[null,"Position","+/-","Driver","Points","Behind","Starts","Laps","Fastest Laps"]
[null,{"$f":"IF(ISNA(VLOOKUP($D4,SeriesSummary,59,FALSE)),\"\",VLOOKUP($D4,SeriesSummary,59,FALSE))","v":1},{"$f":"IF(ISNA(VLOOKUP($D4,SeriesSummary,60,FALSE)),\"\",VLOOKUP($D4,SeriesSummary,60,FALSE))","v":"-"},{"$f":"IF(SumSheet!AV15>0,SumSheet!B15,\"\")","v":"Shawn G."},{"$f":"IF(D4<>\"\",IF(ISNA(VLOOKUP($D4,SeriesSummary,57,FALSE)),\"-\",VLOOKUP($D4,SeriesSummary,57,FALSE)),\"\")","v":22},"Leader",{"$f":"IF(ISNA(VLOOKUP($D4,SeriesSummary,47,FALSE)),\"\",VLOOKUP($D4,SeriesSummary,47,FALSE))","v":2},{"$f":"IF(ISNA(VLOOKUP($D4,SeriesSummary,58,FALSE)),\"\",VLOOKUP($D4,SeriesSummary,58,FALSE))","v":435.69},{"$f":"IF(ISNA(VLOOKUP($D4,SeriesSummary,56,FALSE)),\"\",VLOOKUP($D4,SeriesSummary,56,FALSE))","v":2}]
[null,{"$f":"IF(ISNA(VLOOKUP($D5,SeriesSummary,59,FALSE)),\"\",VLOOKUP($D5,SeriesSummary,59,FALSE))","v":2},{"$f":"IF(ISNA(VLOOKUP($D5,SeriesSummary,60,FALSE)),\"\",VLOOKUP($D5,SeriesSummary,60,FALSE))","v":"-"},{"$f":"IF(SumSheet!AV10>0,SumSheet!B10,\"\")","v":"Jim J."},17,{"$f":"IF(ISERROR(E5-$E$4),\"\",E5-$E$4)","v":-5},2,431.81,0]
[null,{"$f":"IF(ISNA(VLOOKUP($D6,SeriesSummary,59,FALSE)),\"\",VLOOKUP($D6,SeriesSummary,59,FALSE))","v":3},{"$f":"IF(ISNA(VLOOKUP($D6,SeriesSummary,60,FALSE)),\"\",VLOOKUP($D6,SeriesSummary,60,FALSE))","v":"+3"},{"$f":"IF(SumSheet!AV12>0,SumSheet!B12,\"\")","v":"Marty M."},14,{"$f":"IF(ISERROR(E6-$E$4),\"\",E6-$E$4)","v":-8},2,389.95,0]
[null,{"$f":"IF(ISNA(VLOOKUP($D7,SeriesSummary,59,FALSE)),\"\",VLOOKUP($D7,SeriesSummary,59,FALSE))","v":4},{"$f":"IF(ISNA(VLOOKUP($D7,SeriesSummary,60,FALSE)),\"\",VLOOKUP($D7,SeriesSummary,60,FALSE))","v":"-"},{"$f":"IF(SumSheet!AV13>0,SumSheet!B13,\"\")","v":"Roy M."},12,-10,2,425.34000000000003,0]
[null,{"$f":"IF(ISNA(VLOOKUP($D8,SeriesSummary,59,FALSE)),\"\",VLOOKUP($D8,SeriesSummary,59,FALSE))","v":5},{"$f":"IF(ISNA(VLOOKUP($D8,SeriesSummary,60,FALSE)),\"\",VLOOKUP($D8,SeriesSummary,60,FALSE))","v":"+1"},{"$f":"IF(SumSheet!AV9>0,SumSheet!B9,\"\")","v":"Brian H."},12,-10,2,417.14,0]
[null,{"$f":"IF(ISNA(VLOOKUP($D9,SeriesSummary,59,FALSE)),\"\",VLOOKUP($D9,SeriesSummary,59,FALSE))","v":6},{"$f":"IF(ISNA(VLOOKUP($D9,SeriesSummary,60,FALSE)),\"\",VLOOKUP($D9,SeriesSummary,60,FALSE))","v":-2},{"$f":"IF(SumSheet!AV4>0,SumSheet!B4,\"\")","v":"Ary B."},12,-10,2,352.82,1]
[null,{"$f":"IF(ISNA(VLOOKUP($D10,SeriesSummary,59,FALSE)),\"\",VLOOKUP($D10,SeriesSummary,59,FALSE))","v":7},{"$f":"IF(ISNA(VLOOKUP($D10,SeriesSummary,60,FALSE)),\"\",VLOOKUP($D10,SeriesSummary,60,FALSE))","v":"-"},{"$f":"IF(SumSheet!AV16>0,SumSheet!B16,\"\")","v":"Stephen B."},7,-15,1,213.19,0]
[null,{"$f":"IF(ISNA(VLOOKUP($D11,SeriesSummary,59,FALSE)),\"\",VLOOKUP($D11,SeriesSummary,59,FALSE))","v":8},{"$f":"IF(ISNA(VLOOKUP($D11,SeriesSummary,60,FALSE)),\"\",VLOOKUP($D11,SeriesSummary,60,FALSE))","v":"-"},{"$f":"IF(SumSheet!AV8>0,SumSheet!B8,\"\")","v":"Brett L."},4,-18,1,189.05,0]
[null,{"$f":"IF(ISNA(VLOOKUP($D12,SeriesSummary,59,FALSE)),\"\",VLOOKUP($D12,SeriesSummary,59,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($D12,SeriesSummary,60,FALSE)),\"\",VLOOKUP($D12,SeriesSummary,60,FALSE))","v":""},{"$f":"IF(SumSheet!AV5>0,SumSheet!B5,\"\")","v":""},"","","","",""]
[null,{"$f":"IF(ISNA(VLOOKUP($D13,SeriesSummary,59,FALSE)),\"\",VLOOKUP($D13,SeriesSummary,59,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($D13,SeriesSummary,60,FALSE)),\"\",VLOOKUP($D13,SeriesSummary,60,FALSE))","v":""},{"$f":"IF(SumSheet!AV6>0,SumSheet!B6,\"\")","v":""},"","","","",""]
[null,{"$f":"IF(ISNA(VLOOKUP($D14,SeriesSummary,59,FALSE)),\"\",VLOOKUP($D14,SeriesSummary,59,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($D14,SeriesSummary,60,FALSE)),\"\",VLOOKUP($D14,SeriesSummary,60,FALSE))","v":""},{"$f":"IF(SumSheet!AV7>0,SumSheet!B7,\"\")","v":""},"","","","",""]
[null,{"$f":"IF(ISNA(VLOOKUP($D15,SeriesSummary,59,FALSE)),\"\",VLOOKUP($D15,SeriesSummary,59,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($D15,SeriesSummary,60,FALSE)),\"\",VLOOKUP($D15,SeriesSummary,60,FALSE))","v":""},{"$f":"IF(SumSheet!AV11>0,SumSheet!B11,\"\")","v":""},"","","","",""]
[null,{"$f":"IF(ISNA(VLOOKUP($D16,SeriesSummary,59,FALSE)),\"\",VLOOKUP($D16,SeriesSummary,59,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($D16,SeriesSummary,60,FALSE)),\"\",VLOOKUP($D16,SeriesSummary,60,FALSE))","v":""},{"$f":"IF(SumSheet!AV14>0,SumSheet!B14,\"\")","v":""},"","","","",""]
[null,{"$f":"IF(ISNA(VLOOKUP($D17,SeriesSummary,59,FALSE)),\"\",VLOOKUP($D17,SeriesSummary,59,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($D17,SeriesSummary,60,FALSE)),\"\",VLOOKUP($D17,SeriesSummary,60,FALSE))","v":""},{"$f":"IF(SumSheet!AV17>0,SumSheet!B17,\"\")","v":""},"","","","",""]

{"sheet":"Round 1","index":1,"n_rows":35,"n_cols":7,"rows_kept":35,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,{"$f":"SeriesName & \" - Round 1\"","v":"2013 BRM Series - Round 1"}]
[null,"Position","Driver","Laps","Fastest Lap","Fastest Lap Bonus","Points"]
[null,1,"Shawn G.",216.32,3.9729999999999999,{"$f":"IF(C4<>\"\",IF(AND(E4=MIN($E$4:$E$15),E4>0),1,0),\"\")","v":1},{"$f":"IF(ISNA(VLOOKUP(B4,Points,2,FALSE)),\"\",VLOOKUP(B4,Points,2,FALSE)+F4)","v":11}]
[null,2,"Jim J.",215.56,3.996,{"$f":"IF(C5<>\"\",IF(AND(E5=MIN($E$4:$E$15),E5>0),1,0),\"\")","v":0},9]
[null,3,"Ary B.",214.82,3.9729999999999999,1,9]
[null,4,"Roy M.",213.81,4.0510000000000002,0,7]
[null,5,"Brian H.",205.32,4.0650000000000004,0,6]
[null,6,"Marty M.",171,3.9849999999999999,0,5]
[null,null,null,null,null,"",""]
[null,null,null,null,null,"",""]
[null,null,null,null,null,"",""]
[null,null,null,null,null,"",""]
[null,null,null,null,null,"",""]
[null,null,null,null,null,"",""]
[]
[null,"Driver","Lane","Slowest Lap Time","Fastest Lap Time","Average Lap Time","Total Laps"]
[null,"Shawn G.",1,4.9870000000000001,3.9729999999999999,4.1379999999999999,73]
[null,"Shawn G.",2,5.51,3.9769999999999999,4.1360000000000001,72.319999999999993]
[null,"Shawn G.",3,7.141,4.0110000000000001,4.18,71]
[null,"Jim J.",1,6.5380000000000003,4.016,4.202,71]
[null,"Jim J.",2,5.1890000000000001,3.996,4.1269999999999998,73.56]
[null,"Jim J.",3,6.1269999999999998,4.03,4.2060000000000004,71]
[null,"Ary B.",1,4.8230000000000004,4.0060000000000002,4.085,73]
[null,"Ary B.",2,5.306,4.0309999999999997,4.1710000000000003,72.819999999999993]
[null,"Ary B.",3,5.1669999999999998,3.9729999999999999,4.3259999999999996,69]
[null,"Roy M.",1,5.8019999999999996,4.0510000000000002,4.1909999999999998,71]
[null,"Roy M.",2,4.6070000000000002,4.0519999999999996,4.1520000000000001,72.81]
[null,"Roy M.",3,5.649,4.08,4.2949999999999999,70]
[null,"Brian H.",1,5.8920000000000003,4.165,4.3540000000000001,69]
[null,"Brian H.",2,15.385999999999999,4.0730000000000004,4.58,66.319999999999993]
[null,"Brian H.",3,6.0590000000000002,4.0650000000000004,4.2380000000000004,70]
[null,"Marty M.",1,5.7240000000000002,3.9990000000000001,4.1150000000000002,73]
[null,"Marty M.",2,28.015999999999998,4.0220000000000002,4.7789999999999999,38]
[null,"Marty M.",3,22.359000000000002,3.9849999999999999,4.9800000000000004,60]

{"sheet":"Round 2","index":2,"n_rows":41,"n_cols":7,"rows_kept":41,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,{"$f":"SeriesName & \" - Round 2\"","v":"2013 BRM Series - Round 2"}]
[null,"Position","Driver","Laps","Fastest Lap","Fastest Lap Bonus","Points"]
[null,1,"Shawn G.",219.37,3.9159999999999999,{"$f":"IF(C4<>\"\",IF(AND(E4=MIN($E$4:$E$15),E4>0),1,0),\"\")","v":1},{"$f":"IF(ISNA(VLOOKUP(B4,Points,2,FALSE)),\"\",VLOOKUP(B4,Points,2,FALSE)+F4)","v":11}]
[null,2,"Marty M.",218.95,3.9969999999999999,{"$f":"IF(C5<>\"\",IF(AND(E5=MIN($E$4:$E$15),E5>0),1,0),\"\")","v":0},9]
[null,3,"Jim J.",216.25,3.9689999999999999,0,8]
[null,4,"Stephen B.",213.19,3.9569999999999999,0,7]
[null,5,"Brian H.",211.82,4.0039999999999996,0,6]
[null,6,"Roy M.",211.53,4.1100000000000003,0,5]
[null,7,"Brett L.",189.05,4.0629999999999997,0,4]
[null,8,"Ary B.",138,4.1159999999999997,0,3]
[null,null,null,null,null,"",""]
[null,null,null,null,null,"",""]
[null,null,null,null,null,"",""]
[null,null,null,null,null,"",""]
[]
[null,"Driver","Lane","Slowest Lap Time","Fastest Lap Time","Average Lap Time","Total Laps"]
[null,"Shawn G.",1,5.484,3.9159999999999999,4.0439999999999996,74]
[null,"Shawn G.",2,5.4080000000000004,3.99,4.202,72.37]
[null,"Shawn G.",3,5.4260000000000002,3.9740000000000002,4.0730000000000004,73]
[null,"Marty M.",1,4.2439999999999998,3.9969999999999999,4.093,73]
[null,"Marty M.",2,5.6159999999999997,4.0069999999999997,4.1219999999999999,72.95]
[null,"Marty M.",3,5.1379999999999999,4.0229999999999997,4.133,73]
[null,"Jim J.",1,4.9610000000000003,3.9689999999999999,4.1529999999999996,72]
[null,"Jim J.",2,4.78,4.0170000000000003,4.117,73.25]
[null,"Jim J.",3,6.8339999999999996,4.0380000000000003,4.2359999999999998,71]
[null,"Stephen B.",1,6.16,3.9569999999999999,4.1710000000000003,71]
[null,"Stephen B.",2,7.4960000000000004,4.0359999999999996,4.266,71.19]
[null,"Stephen B.",3,6.2880000000000003,3.9849999999999999,4.242,71]
[null,"Brian H.",1,6.8840000000000003,4.0170000000000003,4.3070000000000004,70]
[null,"Brian H.",2,6.7439999999999998,4.0039999999999996,4.2480000000000002,70.819999999999993]
[null,"Brian H.",3,5.3339999999999996,4.0209999999999999,4.202,71]
[null,"Roy M.",1,5.7919999999999998,4.1100000000000003,4.21,71]
[null,"Roy M.",2,5.5410000000000004,4.1449999999999996,4.3079999999999998,70.53]
[null,"Roy M.",3,5.266,4.1459999999999999,4.2539999999999996,70]
[null,"Brett L.",1,7.3289999999999997,4.0629999999999997,4.5,66]
[null,"Brett L.",2,7.476,4.266,4.7839999999999998,63.05]
[null,"Brett L.",3,7.5570000000000004,4.367,4.9669999999999996,60]
[null,"Ary B.",1,10.944000000000001,4.1399999999999997,4.3559999999999999,69]
[null,"Ary B.",2,"--","--","--",0]
[null,"Ary B.",3,8.7319999999999993,4.1159999999999997,4.3170000000000002,69]

{"sheet":"Round 3","index":3,"n_rows":17,"n_cols":7,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,{"$f":"SeriesName & \" - Round 3\"","v":"2013 BRM Series - Round 3"}]
[null,"Position","Driver","Laps","Fastest Lap","Fastest Lap Bonus","Points"]
[null,null,null,null,null,{"$f":"IF(C4<>\"\",IF(AND(E4=MIN($E$4:$E$15),E4>0),1,0),\"\")","v":""},{"$f":"IF(ISNA(VLOOKUP(B4,Points,2,FALSE)),\"\",VLOOKUP(B4,Points,2,FALSE)+F4)","v":""}]
[null,null,null,null,null,{"$f":"IF(C5<>\"\",IF(AND(E5=MIN($E$4:$E$15),E5>0),1,0),\"\")","v":""},""]
[null,null,null,null,null,"",""]
[null,null,null,null,null,"",""]
[null,null,null,null,null,"",""]
[null,null,null,null,null,"",""]
[null,null,null,null,null,"",""]
[null,null,null,null,null,"",""]
[null,null,null,null,null,"",""]
[null,null,null,null,null,"",""]
[null,null,null,null,null,"",""]
[null,null,null,null,null,"",""]
[]
[null,"Driver","Lane","Slowest Lap Time","Fastest Lap Time","Average Lap Time","Total Laps"]

{"sheet":"Round 4","index":4,"n_rows":17,"n_cols":7,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,{"$f":"SeriesName & \" - Round 4\"","v":"2013 BRM Series - Round 4"}]
[null,"Position","Driver","Laps","Fastest Lap","Fastest Lap Bonus","Points"]
[null,null,null,null,null,{"$f":"IF(C4<>\"\",IF(AND(E4=MIN($E$4:$E$15),E4>0),1,0),\"\")","v":""},{"$f":"IF(ISNA(VLOOKUP(B4,Points,2,FALSE)),\"\",VLOOKUP(B4,Points,2,FALSE)+F4)","v":""}]
[null,null,null,null,null,{"$f":"IF(C5<>\"\",IF(AND(E5=MIN($E$4:$E$15),E5>0),1,0),\"\")","v":""},""]
[null,null,null,null,null,"",""]
[null,null,null,null,null,"",""]
[null,null,null,null,null,"",""]
[null,null,null,null,null,"",""]
[null,null,null,null,null,"",""]
[null,null,null,null,null,"",""]
[null,null,null,null,null,"",""]
[null,null,null,null,null,"",""]
[null,null,null,null,null,"",""]
[null,null,null,null,null,"",""]
[]
[null,"Driver","Lane","Slowest Lap Time","Fastest Lap Time","Average Lap Time","Total Laps"]

{"sheet":"Round 5","index":5,"n_rows":17,"n_cols":7,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,{"$f":"SeriesName & \" - Round 5\"","v":"2013 BRM Series - Round 5"}]
[null,"Position","Driver","Laps","Fastest Lap","Fastest Lap Bonus","Points"]
[null,null,null,null,null,{"$f":"IF(C4<>\"\",IF(AND(E4=MIN($E$4:$E$15),E4>0),1,0),\"\")","v":""},{"$f":"IF(ISNA(VLOOKUP(B4,Points,2,FALSE)),\"\",VLOOKUP(B4,Points,2,FALSE)+F4)","v":""}]
[null,null,null,null,null,{"$f":"IF(C5<>\"\",IF(AND(E5=MIN($E$4:$E$15),E5>0),1,0),\"\")","v":""},""]
[null,null,null,null,null,"",""]
[null,null,null,null,null,"",""]
[null,null,null,null,null,"",""]
[null,null,null,null,null,"",""]
[null,null,null,null,null,"",""]
[null,null,null,null,null,"",""]
[null,null,null,null,null,"",""]
[null,null,null,null,null,"",""]
[null,null,null,null,null,"",""]
[null,null,null,null,null,"",""]
[]
[null,"Driver","Lane","Slowest Lap Time","Fastest Lap Time","Average Lap Time","Total Laps"]

{"sheet":"Round 6","index":6,"n_rows":17,"n_cols":7,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,{"$f":"SeriesName & \" - Round 6\"","v":"2013 BRM Series - Round 6"}]
[null,"Position","Driver","Laps","Fastest Lap","Fastest Lap Bonus","Points"]
[null,null,null,null,null,{"$f":"IF(C4<>\"\",IF(AND(E4=MIN($E$4:$E$15),E4>0),1,0),\"\")","v":""},{"$f":"IF(ISNA(VLOOKUP(B4,Points,2,FALSE)),\"\",VLOOKUP(B4,Points,2,FALSE)+F4)","v":""}]
[null,null,null,null,null,{"$f":"IF(C5<>\"\",IF(AND(E5=MIN($E$4:$E$15),E5>0),1,0),\"\")","v":""},""]
[null,null,null,null,null,"",""]
[null,null,null,null,null,"",""]
[null,null,null,null,null,"",""]
[null,null,null,null,null,"",""]
[null,null,null,null,null,"",""]
[null,null,null,null,null,"",""]
[null,null,null,null,null,"",""]
[null,null,null,null,null,"",""]
[null,null,null,null,null,"",""]
[null,null,null,null,null,"",""]
[]
[null,"Driver","Lane","Slowest Lap Time","Fastest Lap Time","Average Lap Time","Total Laps"]

{"sheet":"SumSheet","index":7,"n_rows":41,"n_cols":64,"rows_kept":41,"cut":false,"hidden":false,"merged":[[1,51,1,54],[1,55,1,60],[23,1,23,2],[1,1,2,1],[1,47,1,50],[1,2,1,6],[1,15,1,22],[1,7,1,14],[1,23,1,30],[1,31,1,38],[1,39,1,46]]}
[null,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]
[null,"Racer","Round 1",null,null,null,null,"Round 2",null,null,null,null,null,null,null,"Round 3",null,null,null,null,null,null,null,"Round 4",null,null,null,null,null,null,null,"Round 5",null,null,null,null,null,null,null,"Round 6",null,null,null,null,null,null,null,"Total",null,null,null,"Dropped Round",null,null,null,"Final Classification"]
[null,null,"Laps","Points","Fastest Lap","Total Round Points","Rank","Laps","Points","Fastest Lap","Total Round Points","Rank","Running Series Points","Running Series Rank","Change in Rank","Laps","Points","Fastest Lap","Total Round Points","Rank","Running Series Points","Running Series Rank","Change in Rank","Laps","Points","Fastest Lap","Total Round Points","Rank","Running Series Points","Running Series Rank","Change in Rank","Laps","Points","Fastest Lap","Total Round Points","Rank","Running Series Points","Running Series Rank","Change in Rank","Laps","Points","Fastest Lap","Total Round Points","Rank","Running Series Points","Running Series Rank","Change in Rank","Rounds Run","Points","Fastest Laps","Laps","Round","Points","Fastest Laps","Laps","Points","Fastest Laps","Total Points","Laps","Rank","Change in Rank"]
[null,"Ary B.",{"$f":"IF(ISNA(VLOOKUP($B4,Round1Results,2,FALSE)),0,VLOOKUP($B4,Round1Results,2,FALSE))","v":214.82},{"$f":"IF(ISNA(VLOOKUP($B4,Round1Results,5,FALSE)),0,VLOOKUP($B4,Round1Results,5,FALSE)-E4)","v":8},{"$f":"IF(ISNA(VLOOKUP($B4,Round1Results,4,FALSE)),0,VLOOKUP($B4,Round1Results,4,FALSE))","v":1},{"$f":"SUM(D4:E4)","v":9},{"$f":"IF(C4>0,RANK(F4,F$4:F$19),0)","v":2},{"$f":"IF(ISNA(VLOOKUP($B4,Round2Results,2,FALSE)),0,VLOOKUP($B4,Round2Results,2,FALSE))","v":138},{"$f":"IF(ISNA(VLOOKUP($B4,Round2Results,5,FALSE)),0,VLOOKUP($B4,Round2Results,5,FALSE)-J4)","v":3},{"$f":"IF(ISNA(VLOOKUP($B4,Round2Results,4,FALSE)),0,VLOOKUP($B4,Round2Results,4,FALSE))","v":0},{"$f":"SUM(I4:J4)","v":3},{"$f":"IF(H4>0,RANK(K4,K$4:K$19),\"-\")","v":8},{"$f":"F4+K4","v":12},{"$f":"RANK(M4,M$4:M$19)","v":4},{"$f":"IF(G4=0,0,G4-N4)","v":-2},{"$f":"IF(ISNA(VLOOKUP($B4,Round3Results,2,FALSE)),0,VLOOKUP($B4,Round3Results,2,FALSE))","v":0},{"$f":"IF(ISNA(VLOOKUP($B4,Round3Results,5,FALSE)),0,VLOOKUP($B4,Round3Results,5,FALSE)-R4)","v":0},{"$f":"IF(ISNA(VLOOKUP($B4,Round3Results,4,FALSE)),0,VLOOKUP($B4,Round3Results,4,FALSE))","v":0},{"$f":"SUM(Q4:R4)","v":0},{"$f":"IF(P4>0,RANK(S4,S$4:S$19),\"-\")","v":"-"},{"$f":"M4+S4","v":12},{"$f":"RANK(U4,U$4:U$19)","v":4},{"$f":"IF(N4=0,0,N4-V4)","v":0},{"$f":"IF(ISNA(VLOOKUP($B4,Round4Results,2,FALSE)),0,VLOOKUP($B4,Round4Results,2,FALSE))","v":0},{"$f":"IF(ISNA(VLOOKUP($B4,Round4Results,5,FALSE)),0,VLOOKUP($B4,Round4Results,5,FALSE)-Z4)","v":0},{"$f":"IF(ISNA(VLOOKUP($B4,Round4Results,4,FALSE)),0,VLOOKUP($B4,Round4Results,4,FALSE))","v":0},{"$f":"SUM(Y4:Z4)","v":0},{"$f":"IF(X4>0,RANK(AA4,AA$4:AA$19),\"-\")","v":"-"},{"$f":"U4+AA4","v":12},{"$f":"RANK(AC4,AC$4:AC$19)","v":4},{"$f":"IF(V4=0,0,V4-AD4)","v":0},{"$f":"IF(ISNA(VLOOKUP($B4,Round5Results,2,FALSE)),0,VLOOKUP($B4,Round5Results,2,FALSE))","v":0},{"$f":"IF(ISNA(VLOOKUP($B4,Round5Results,5,FALSE)),0,VLOOKUP($B4,Round5Results,5,FALSE)-AH4)","v":0},{"$f":"IF(ISNA(VLOOKUP($B4,Round5Results,4,FALSE)),0,VLOOKUP($B4,Round5Results,4,FALSE))","v":0},{"$f":"SUM(AG4:AH4)","v":0},{"$f":"IF(AF4>0,RANK(AI4,AI$4:AI$19),\"-\")","v":"-"},{"$f":"AC4+AI4","v":12},{"$f":"RANK(AK4,AK$4:AK$19)","v":4},{"$f":"IF(AD4=0,0,AD4-AL4)","v":0},{"$f":"IF(ISNA(VLOOKUP($B4,Round6Results,2,FALSE)),0,VLOOKUP($B4,Round6Results,2,FALSE))","v":0},{"$f":"IF(ISNA(VLOOKUP($B4,Round6Results,5,FALSE)),0,VLOOKUP($B4,Round6Results,5,FALSE)-AP)","v":0},{"$f":"IF(ISNA(VLOOKUP($B4,Round6Results,4,FALSE)),0,VLOOKUP($B4,Round6Results,4,FALSE))","v":0},{"$f":"SUM(AO4:AP4)","v":0},{"$f":"IF(AN4>0,RANK(AQ4,AQ$4:AQ$19),\"-\")","v":"-"},{"$f":"AK4+AQ4","v":12},{"$f":"RANK(AS4,AS$4:AS$19)","v":4},{"$f":"IF(AL4=0,0,AL4-AT4)","v":0},{"$f":"COUNTIF(C4,\">0\")+COUNTIF(H4,\">0\")+COUNTIF(P4,\">0\")+COUNTIF(X4,\">0\")+COUNTIF(AF4,\">0\")+COUNTIF(AN4,\">0\")","v":2},{"$f":"D4+I4+Q4+Y4+AG4+AO4","v":11},1,{"$f":"C4+H4+P4+X4+AF4+AN4","v":352.82},null,0,0,0,{"$f":"D4+I4+Q4+Y4+AG4+AO4-BA4","v":11},{"$f":"E4+J4+R4+Z4+AH4+AP4-BB4","v":1},{"$f":"BD4+BE4","v":12},{"$f":"C4+H4+P4+X4+AF4+AN4-BC4","v":352.82},{"$f":"IF(AV4>0,RANK(BF4,$BF$4:$BF$19)+SUMPRODUCT(--($BF$4:$BF$19=BF4),--($BG$4:$BG$19>BG4)),0)","v":6},{"$f":"IF(B4<>\"\",IF(IF(RoundsRun=2,VLOOKUP(B4,SeriesSummary,14,FALSE),IF(RoundsRun=3,VLOOKUP(B4,SeriesSummary,22,FALSE),IF(RoundsRun=4,VLOOKUP(B4,SeriesSummary,30,FALSE),IF(RoundsRun=5,VLOOKUP(B4,SeriesSummary,38,FALSE),IF(RoundsRun=6,VLOOKUP(B4,SeriesSummary,46,FALSE),\"-\")))))>0,\"+\"&IF(RoundsRun=2,VLOOKUP(B4,SeriesSummary,14,FALSE),IF(RoundsRun=3,VLOOKUP(B4,SeriesSummary,22,FALSE),IF(RoundsRun=4,VLOOKUP(B4,SeriesSummary,30,FALSE),IF(RoundsRun=5,VLOOKUP(B4,SeriesSummary,38,FALSE),IF(RoundsRun=6,VLOOKUP(B4,SeriesSummary,46,FALSE),\"-\"))))),IF((IF(RoundsRun=2,VLOOKUP(B4,SeriesSummary,14,FALSE),IF(RoundsRun=3,VLOOKUP(B4,SeriesSummary,22,FALSE),IF(RoundsRun=4,VLOOKUP(B4,SeriesSummary,30,FALSE),IF(RoundsRun=5,VLOOKUP(B4,SeriesSummary,38,FALSE),IF(RoundsRun=6,VLOOKUP(B4,SeriesSummary,46,FALSE),\"-\"))))))=0,\"-\",(IF(RoundsRun=2,VLOOKUP(B4,SeriesSummary,14,FALSE),IF(RoundsRun=3,VLOOKUP(B4,SeriesSummary,22,FALSE),IF(RoundsRun=4,VLOOKUP(B4,SeriesSummary,30,FALSE),IF(RoundsRun=5,VLOOKUP(B4,SeriesSummary,38,FALSE),IF(RoundsRun=6,VLOOKUP(B4,SeriesSummary,46,FALSE),\"-\")))))))),\"\")","v":-2},null,{"$f":"BH4","v":6},{"$f":"B4","v":"Ary B."}]
[null,"Austin C.",0,0,0,{"$f":"SUM(D5:E5)","v":0},{"$f":"IF(C5>0,RANK(F5,F$4:F$19),0)","v":0},0,0,0,{"$f":"SUM(I5:J5)","v":0},{"$f":"IF(H5>0,RANK(K5,K$4:K$19),\"-\")","v":"-"},{"$f":"F5+K5","v":0},{"$f":"RANK(M5,M$4:M$19)","v":9},{"$f":"IF(G5=0,0,G5-N5)","v":0},0,0,0,{"$f":"SUM(Q5:R5)","v":0},{"$f":"IF(P5>0,RANK(S5,S$4:S$19),\"-\")","v":"-"},{"$f":"M5+S5","v":0},{"$f":"RANK(U5,U$4:U$19)","v":9},{"$f":"IF(N5=0,0,N5-V5)","v":0},0,0,0,{"$f":"SUM(Y5:Z5)","v":0},{"$f":"IF(X5>0,RANK(AA5,AA$4:AA$19),\"-\")","v":"-"},{"$f":"U5+AA5","v":0},{"$f":"RANK(AC5,AC$4:AC$19)","v":9},{"$f":"IF(V5=0,0,V5-AD5)","v":0},0,0,0,{"$f":"SUM(AG5:AH5)","v":0},{"$f":"IF(AF5>0,RANK(AI5,AI$4:AI$19),\"-\")","v":"-"},{"$f":"AC5+AI5","v":0},{"$f":"RANK(AK5,AK$4:AK$19)","v":9},{"$f":"IF(AD5=0,0,AD5-AL5)","v":0},0,{"$f":"IF(ISNA(VLOOKUP($B5,Round6Results,5,FALSE)),0,VLOOKUP($B5,Round6Results,5,FALSE)-AP)","v":0},0,{"$f":"SUM(AO5:AP5)","v":0},{"$f":"IF(AN5>0,RANK(AQ5,AQ$4:AQ$19),\"-\")","v":"-"},{"$f":"AK5+AQ5","v":0},{"$f":"RANK(AS5,AS$4:AS$19)","v":9},{"$f":"IF(AL5=0,0,AL5-AT5)","v":0},0,0,0,0,null,0,0,0,{"$f":"D5+I5+Q5+Y5+AG5+AO5-BA5","v":0},0,{"$f":"BD5+BE5","v":0},0,{"$f":"IF(AV5>0,RANK(BF5,$BF$4:$BF$19)+SUMPRODUCT(--($BF$4:$BF$19=BF5),--($BG$4:$BG$19>BG5)),0)","v":0},"-",null,{"$f":"BH5","v":0},{"$f":"B5","v":"Austin C."}]
[null,"Bob L.",0,0,0,0,0,0,0,0,0,"-",{"$f":"F6+K6","v":0},9,{"$f":"IF(G6=0,0,G6-N6)","v":0},0,0,0,0,"-",{"$f":"M6+S6","v":0},9,{"$f":"IF(N6=0,0,N6-V6)","v":0},0,0,0,0,"-",{"$f":"U6+AA6","v":0},9,{"$f":"IF(V6=0,0,V6-AD6)","v":0},0,0,0,0,"-",{"$f":"AC6+AI6","v":0},9,{"$f":"IF(AD6=0,0,AD6-AL6)","v":0},0,{"$f":"IF(ISNA(VLOOKUP($B6,Round6Results,5,FALSE)),0,VLOOKUP($B6,Round6Results,5,FALSE)-AP)","v":0},0,0,"-",{"$f":"AK6+AQ6","v":0},9,{"$f":"IF(AL6=0,0,AL6-AT6)","v":0},0,0,0,0,null,0,0,0,0,0,0,0,0,"-",null,0,"Bob L."]
[null,"Brandon M.",0,0,0,0,0,0,0,0,0,"-",{"$f":"F7+K7","v":0},9,{"$f":"IF(G7=0,0,G7-N7)","v":0},0,0,0,0,"-",{"$f":"M7+S7","v":0},9,{"$f":"IF(N7=0,0,N7-V7)","v":0},0,0,0,0,"-",{"$f":"U7+AA7","v":0},9,{"$f":"IF(V7=0,0,V7-AD7)","v":0},0,0,0,0,"-",{"$f":"AC7+AI7","v":0},9,{"$f":"IF(AD7=0,0,AD7-AL7)","v":0},0,{"$f":"IF(ISNA(VLOOKUP($B7,Round6Results,5,FALSE)),0,VLOOKUP($B7,Round6Results,5,FALSE)-AP)","v":0},0,0,"-",{"$f":"AK7+AQ7","v":0},9,{"$f":"IF(AL7=0,0,AL7-AT7)","v":0},0,0,0,0,null,0,0,0,0,0,0,0,0,"-",null,0,"Brandon M."]
[null,"Brett L.",0,0,0,0,0,189.05,4,0,4,7,4,8,0,0,0,0,0,"-",4,8,0,0,0,0,0,"-",4,8,0,0,0,0,0,"-",4,8,0,0,{"$f":"IF(ISNA(VLOOKUP($B8,Round6Results,5,FALSE)),0,VLOOKUP($B8,Round6Results,5,FALSE)-AP)","v":0},0,0,"-",4,8,0,1,4,0,189.05,null,0,0,0,4,0,4,189.05,8,"-",null,8,"Brett L."]
[null,"Brian H.",205.32,6,0,6,5,211.82,6,0,6,5,12,4,1,0,0,0,0,"-",12,4,0,0,0,0,0,"-",12,4,0,0,0,0,0,"-",12,4,0,0,{"$f":"IF(ISNA(VLOOKUP($B9,Round6Results,5,FALSE)),0,VLOOKUP($B9,Round6Results,5,FALSE)-AP)","v":0},0,0,"-",12,4,0,2,12,0,417.14,null,0,0,0,12,0,12,417.14,5,"+1",null,5,"Brian H."]
[null,"Jim J.",215.56,9,0,9,2,216.25,8,0,8,3,17,2,0,0,0,0,0,"-",17,2,0,0,0,0,0,"-",17,2,0,0,0,0,0,"-",17,2,0,0,{"$f":"IF(ISNA(VLOOKUP($B10,Round6Results,5,FALSE)),0,VLOOKUP($B10,Round6Results,5,FALSE)-AP)","v":0},0,0,"-",17,2,0,2,17,0,431.81,null,0,0,0,17,0,17,431.81,2,"-",null,2,"Jim J."]
[null,"Kevin F.",0,0,0,0,0,0,0,0,0,"-",0,9,0,0,0,0,0,"-",0,9,0,0,0,0,0,"-",0,9,0,0,0,0,0,"-",0,9,0,0,{"$f":"IF(ISNA(VLOOKUP($B11,Round6Results,5,FALSE)),0,VLOOKUP($B11,Round6Results,5,FALSE)-AP)","v":0},0,0,"-",0,9,0,0,0,0,0,null,0,0,0,0,0,0,0,0,"-",null,0,"Kevin F."]
[null,"Marty M.",171,5,0,5,6,218.95,9,0,9,2,14,3,3,0,0,0,0,"-",14,3,0,0,0,0,0,"-",14,3,0,0,0,0,0,"-",14,3,0,0,{"$f":"IF(ISNA(VLOOKUP($B12,Round6Results,5,FALSE)),0,VLOOKUP($B12,Round6Results,5,FALSE)-AP)","v":0},0,0,"-",14,3,0,2,14,0,389.95,null,{"$f":"MIN(D12,I12,Q12,Y12,AG12,AO12)","v":0},0,0,14,0,14,389.95,3,"+3",null,3,"Marty M."]
[null,"Roy M.",213.81,7,0,{"$f":"SUM(D13:E13)","v":7},4,211.53,5,0,{"$f":"SUM(I13:J13)","v":5},6,12,4,0,0,0,0,{"$f":"SUM(Q13:R13)","v":0},"-",12,4,0,0,0,0,{"$f":"SUM(Y13:Z13)","v":0},"-",12,4,0,0,0,0,{"$f":"SUM(AG13:AH13)","v":0},"-",12,4,0,0,{"$f":"IF(ISNA(VLOOKUP($B13,Round6Results,5,FALSE)),0,VLOOKUP($B13,Round6Results,5,FALSE)-AP)","v":0},0,{"$f":"SUM(AO13:AP13)","v":0},"-",12,4,0,2,12,0,425.34000000000003,null,0,0,0,12,0,12,425.34000000000003,4,"-",null,4,"Roy M."]
[null,"Russell M.",0,0,0,0,0,0,0,0,0,"-",0,9,0,0,0,0,0,"-",0,9,0,0,0,0,0,"-",0,9,0,0,0,0,0,"-",0,9,0,0,{"$f":"IF(ISNA(VLOOKUP($B14,Round6Results,5,FALSE)),0,VLOOKUP($B14,Round6Results,5,FALSE)-AP)","v":0},0,0,"-",0,9,0,0,0,0,0,null,{"$f":"MIN(D14,I14,Q14,Y14,AG14,AO14)","v":0},0,0,0,0,0,0,0,"-",null,0,"Russell M."]
[null,"Shawn G.",216.32,10,1,11,1,219.37,10,1,11,1,22,1,0,0,0,0,0,"-",22,1,0,0,0,0,0,"-",22,1,0,0,0,0,0,"-",22,1,0,0,{"$f":"IF(ISNA(VLOOKUP($B15,Round6Results,5,FALSE)),0,VLOOKUP($B15,Round6Results,5,FALSE)-AP)","v":0},0,0,"-",22,1,0,2,20,2,435.69,null,0,0,0,20,2,22,435.69,1,"-",null,1,"Shawn G."]
[null,"Stephen B.",0,0,0,0,0,213.19,7,0,7,4,7,7,0,0,0,0,0,"-",7,7,0,0,0,0,0,"-",7,7,0,0,0,0,0,"-",7,7,0,0,{"$f":"IF(ISNA(VLOOKUP($B16,Round6Results,5,FALSE)),0,VLOOKUP($B16,Round6Results,5,FALSE)-AP)","v":0},0,0,"-",7,7,0,1,7,0,213.19,null,0,0,0,7,0,7,213.19,7,"-",null,7,"Stephen B."]
[null,null,0,0,0,0,0,0,0,0,0,"-",0,9,0,0,0,0,0,"-",0,9,0,0,0,0,0,"-",0,9,0,0,0,0,0,"-",0,9,0,0,{"$f":"IF(ISNA(VLOOKUP($B17,Round6Results,5,FALSE)),0,VLOOKUP($B17,Round6Results,5,FALSE)-AP)","v":0},0,0,"-",0,9,0,0,0,0,0,null,0,0,0,0,0,0,0,0,"",null,0,0]
[null,null,0,0,0,0,{"$f":"IF(C18>0,RANK(F18,F$4:F$19),0)","v":0},0,0,0,0,{"$f":"IF(H18>0,RANK(K18,K$4:K$19),\"-\")","v":"-"},0,{"$f":"RANK(M18,M$4:M$19)","v":9},0,0,0,0,0,{"$f":"IF(P18>0,RANK(S18,S$4:S$19),\"-\")","v":"-"},0,{"$f":"RANK(U18,U$4:U$19)","v":9},0,0,0,0,0,{"$f":"IF(X18>0,RANK(AA18,AA$4:AA$19),\"-\")","v":"-"},0,{"$f":"RANK(AC18,AC$4:AC$19)","v":9},0,0,0,0,0,{"$f":"IF(AF18>0,RANK(AI18,AI$4:AI$19),\"-\")","v":"-"},0,{"$f":"RANK(AK18,AK$4:AK$19)","v":9},0,0,{"$f":"IF(ISNA(VLOOKUP($B18,Round6Results,5,FALSE)),0,VLOOKUP($B18,Round6Results,5,FALSE)-AP)","v":0},0,0,{"$f":"IF(AN18>0,RANK(AQ18,AQ$4:AQ$19),\"-\")","v":"-"},0,{"$f":"RANK(AS18,AS$4:AS$19)","v":9},0,0,0,0,0,null,0,0,0,0,0,0,0,0,"",null,0,0]
[null,null,0,0,0,0,{"$f":"IF(C19>0,RANK(F19,F$4:F$19),0)","v":0},0,0,0,0,{"$f":"IF(H19>0,RANK(K19,K$4:K$19),\"-\")","v":"-"},0,{"$f":"RANK(M19,M$4:M$19)","v":9},0,0,0,0,0,{"$f":"IF(P19>0,RANK(S19,S$4:S$19),\"-\")","v":"-"},0,{"$f":"RANK(U19,U$4:U$19)","v":9},0,0,0,0,0,{"$f":"IF(X19>0,RANK(AA19,AA$4:AA$19),\"-\")","v":"-"},0,{"$f":"RANK(AC19,AC$4:AC$19)","v":9},0,0,0,0,0,{"$f":"IF(AF19>0,RANK(AI19,AI$4:AI$19),\"-\")","v":"-"},0,{"$f":"RANK(AK19,AK$4:AK$19)","v":9},0,0,{"$f":"IF(ISNA(VLOOKUP($B19,Round6Results,5,FALSE)),0,VLOOKUP($B19,Round6Results,5,FALSE)-AP)","v":0},0,0,{"$f":"IF(AN19>0,RANK(AQ19,AQ$4:AQ$19),\"-\")","v":"-"},0,{"$f":"RANK(AS19,AS$4:AS$19)","v":9},0,0,0,0,0,null,0,0,0,0,0,0,0,0,"",null,0,0]
[]
[]
[null,"Series Name","2013 BRM Series"]
[null,"Rounds Run",{"$f":"COUNT('Round 1'!B4,'Round 2'!B4,'Round 3'!B4,'Round 4'!B4,'Round 5'!B4,'Round 6'!B4)","v":2}]
[null,"Points Table"]
[null,"Position","Points"]
[null,1,10]
[null,2,9]
[null,3,8]
[null,4,7]
[null,5,6]
[null,6,5]
[null,7,4]
[null,8,3]
[null,9,2]
[null,10,1]
[null,11,1]
[null,12,1]
[null,13,1]
[null,14,1]
[null,15,1]
[null,16,1]