{"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":269,"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":"1900"}

{"sheet":"Leader Board","index":0,"n_rows":36,"n_cols":49,"rows_kept":36,"cut":false,"hidden":false,"merged":[[4,48,4,55],[4,1,4,9],[4,11,4,18],[4,20,4,27],[4,29,4,37],[4,39,4,46]]}
[]
[]
[]
[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,"Used to reformat the leader board after resorting the results. DO NOT MODIFY",null,null,null,null,null,null,null,null,null,"Used to reformat the Group A leader boards after resorting the results. DO NOT MODIFY",null,null,null,null,null,null,null,null,"Used to reformat the Group B leader board after resorting the results. DO NOT MODIFY"]
[null,{"$f":" SeriesName & \" - Round \" & RoundsRun & \" of 6  (Overall)\"","v":"2017 BTCC - Round 3 of 6  (Overall)"},null,null,null,null,null,null,null,null,null,{"$f":" SeriesName & \" - Round \" & RoundsRun & \" of 6 (Group A)\"","v":"2017 BTCC - Round 3 of 6 (Group A)"},null,null,null,null,null,null,null,null,{"$f":" SeriesName & \" - Round \" & RoundsRun & \" of 6 (Group B)\"","v":"2017 BTCC - Round 3 of 6 (Group B)"}]
[null,"Position","+/-","Driver","Grp","Points","Behind","Starts","Laps","Fastest Laps",null,"Position","+/-","Driver","Points","Behind","Starts","Laps","Fastest Laps",null,"Position","+/-","Driver","Points","Behind","Starts","Laps","Fastest Laps"]
[null,{"$f":"IF(ISNA(VLOOKUP($D7,SeriesSummary,Rank,FALSE)),\"\",VLOOKUP($D7,SeriesSummary,Rank,FALSE))","v":1},{"$f":"IF(ISNA(VLOOKUP($D7,SeriesSummary,ChangeInRank,FALSE)),\"\",VLOOKUP($D7,SeriesSummary,ChangeInRank,FALSE))","v":"-"},{"$f":"IF(SumSheet!BM10>0,SumSheet!B10,\"\")","v":"Ary B."},{"$f":"IF(SumSheet!BM10>0,SumSheet!C10,\"\")","v":"A"},{"$f":"IF(D7<>\"\",IF(ISNA(VLOOKUP($D7,SeriesSummary,TotalPoints,FALSE)),\"-\",VLOOKUP($D7,SeriesSummary,TotalPoints,FALSE)),\"\")","v":58},"Leader",{"$f":"IF(ISNA(VLOOKUP($D7,SeriesSummary,Starts,FALSE)),\"\",VLOOKUP($D7,SeriesSummary,Starts,FALSE))","v":3},{"$f":"IF(ISNA(VLOOKUP($D7,SeriesSummary,TotalLaps,FALSE)),\"\",VLOOKUP($D7,SeriesSummary,TotalLaps,FALSE))","v":652.97},{"$f":"IF(ISNA(VLOOKUP($D7,SeriesSummary,FastestLaps,FALSE)),\"\",VLOOKUP($D7,SeriesSummary,FastestLaps,FALSE))","v":1},null,{"$f":"IF(ISNA(VLOOKUP($N7,SeriesSummary,ClassRank,FALSE)),\"\",VLOOKUP($N7,SeriesSummary,ClassRank,FALSE))","v":1},{"$f":"IF(ISNA(VLOOKUP($N7,SeriesSummary,ChangeInClassRank,FALSE)),\"\",VLOOKUP($N7,SeriesSummary,ChangeInClassRank,FALSE))","v":"-"},{"$f":"IF(AND(SumSheet!BM10>0,SumSheet!C10=\"A\"),SumSheet!B10,\"\")","v":"Ary B."},{"$f":"IF(N7<>\"\",IF(ISNA(VLOOKUP($N7,SeriesSummary,TotalPoints,FALSE)),\"-\",VLOOKUP($N7,SeriesSummary,TotalPoints,FALSE)),\"\")","v":58},"Leader",{"$f":"IF(ISNA(VLOOKUP($N7,SeriesSummary,Starts,FALSE)),\"\",VLOOKUP($N7,SeriesSummary,Starts,FALSE))","v":3},{"$f":"IF(ISNA(VLOOKUP($N7,SeriesSummary,TotalLaps,FALSE)),\"\",VLOOKUP($N7,SeriesSummary,TotalLaps,FALSE))","v":652.97},{"$f":"IF(ISNA(VLOOKUP($N7,SeriesSummary,FastestLaps,FALSE)),\"\",VLOOKUP($N7,SeriesSummary,FastestLaps,FALSE))","v":1},null,{"$f":"IF(ISNA(VLOOKUP($W7,SeriesSummary,ClassRank,FALSE)),\"\",VLOOKUP($W7,SeriesSummary,ClassRank,FALSE))","v":1},{"$f":"IF(ISNA(VLOOKUP($W7,SeriesSummary,ChangeInClassRank,FALSE)),\"\",VLOOKUP($W7,SeriesSummary,ChangeInClassRank,FALSE))","v":"-"},{"$f":"IF(AND(SumSheet!BM20>0,SumSheet!C20=\"B\"),SumSheet!B20,\"\")","v":"Mark L."},{"$f":"IF(W7<>\"\",IF(ISNA(VLOOKUP($W7,SeriesSummary,TotalPoints,FALSE)),\"-\",VLOOKUP($W7,SeriesSummary,TotalPoints,FALSE)),\"\")","v":48},"Leader",{"$f":"IF(ISNA(VLOOKUP($W7,SeriesSummary,Starts,FALSE)),\"\",VLOOKUP($W7,SeriesSummary,Starts,FALSE))","v":3},{"$f":"IF(ISNA(VLOOKUP($W7,SeriesSummary,TotalLaps,FALSE)),\"\",VLOOKUP($W7,SeriesSummary,TotalLaps,FALSE))","v":578.48},{"$f":"IF(ISNA(VLOOKUP($W7,SeriesSummary,FastestLaps,FALSE)),\"\",VLOOKUP($W7,SeriesSummary,FastestLaps,FALSE))","v":2}]
[null,{"$f":"IF(ISNA(VLOOKUP($D8,SeriesSummary,Rank,FALSE)),\"\",VLOOKUP($D8,SeriesSummary,Rank,FALSE))","v":2},{"$f":"IF(ISNA(VLOOKUP($D8,SeriesSummary,ChangeInRank,FALSE)),\"\",VLOOKUP($D8,SeriesSummary,ChangeInRank,FALSE))","v":-1},{"$f":"IF(SumSheet!BM16>0,SumSheet!B16,\"\")","v":"David C."},{"$f":"IF(SumSheet!BM16>0,SumSheet!C16,\"\")","v":"A"},57,{"$f":"IF(ISERROR(F8-$F$7),\"\",F8-$F$7)","v":-1},3,646.37,1,null,{"$f":"IF(ISNA(VLOOKUP($N8,SeriesSummary,ClassRank,FALSE)),\"\",VLOOKUP($N8,SeriesSummary,ClassRank,FALSE))","v":2},{"$f":"IF(ISNA(VLOOKUP($N8,SeriesSummary,ChangeInClassRank,FALSE)),\"\",VLOOKUP($N8,SeriesSummary,ChangeInClassRank,FALSE))","v":-1},{"$f":"IF(AND(SumSheet!BM16>0,SumSheet!C16=\"A\"),SumSheet!B16,\"\")","v":"David C."},57,{"$f":"IF(ISERROR(O8-$O$7),\"\",O8-$O$7)","v":-1},3,646.37,1,null,{"$f":"IF(ISNA(VLOOKUP($W8,SeriesSummary,ClassRank,FALSE)),\"\",VLOOKUP($W8,SeriesSummary,ClassRank,FALSE))","v":2},{"$f":"IF(ISNA(VLOOKUP($W8,SeriesSummary,ChangeInClassRank,FALSE)),\"\",VLOOKUP($W8,SeriesSummary,ChangeInClassRank,FALSE))","v":"-"},{"$f":"IF(AND(SumSheet!BM17>0,SumSheet!C17=\"B\"),SumSheet!B17,\"\")","v":"John B."},45,{"$f":"IF(ISERROR(X8-$X$7),\"\",X8-$X$7)","v":-3},3,568.29,0]
[null,{"$f":"IF(ISNA(VLOOKUP($D9,SeriesSummary,Rank,FALSE)),\"\",VLOOKUP($D9,SeriesSummary,Rank,FALSE))","v":3},{"$f":"IF(ISNA(VLOOKUP($D9,SeriesSummary,ChangeInRank,FALSE)),\"\",VLOOKUP($D9,SeriesSummary,ChangeInRank,FALSE))","v":"+1"},{"$f":"IF(SumSheet!BM21>0,SumSheet!B21,\"\")","v":"Marty M."},{"$f":"IF(SumSheet!BM21>0,SumSheet!C21,\"\")","v":"A"},{"$f":"IF(D9<>\"\",IF(ISNA(VLOOKUP($D9,SeriesSummary,TotalPoints,FALSE)),\"-\",VLOOKUP($D9,SeriesSummary,TotalPoints,FALSE)),\"\")","v":53},{"$f":"IF(ISERROR(F9-$F$7),\"\",F9-$F$7)","v":-5},3,552.43000000000006,1,null,{"$f":"IF(ISNA(VLOOKUP($N9,SeriesSummary,ClassRank,FALSE)),\"\",VLOOKUP($N9,SeriesSummary,ClassRank,FALSE))","v":3},{"$f":"IF(ISNA(VLOOKUP($N9,SeriesSummary,ChangeInClassRank,FALSE)),\"\",VLOOKUP($N9,SeriesSummary,ChangeInClassRank,FALSE))","v":"+1"},{"$f":"IF(AND(SumSheet!BM21>0,SumSheet!C21=\"A\"),SumSheet!B21,\"\")","v":"Marty M."},{"$f":"IF(N9<>\"\",IF(ISNA(VLOOKUP($N9,SeriesSummary,TotalPoints,FALSE)),\"-\",VLOOKUP($N9,SeriesSummary,TotalPoints,FALSE)),\"\")","v":53},{"$f":"IF(ISERROR(O9-$O$7),\"\",O9-$O$7)","v":-5},3,552.43000000000006,1,null,{"$f":"IF(ISNA(VLOOKUP($W9,SeriesSummary,ClassRank,FALSE)),\"\",VLOOKUP($W9,SeriesSummary,ClassRank,FALSE))","v":3},{"$f":"IF(ISNA(VLOOKUP($W9,SeriesSummary,ChangeInClassRank,FALSE)),\"\",VLOOKUP($W9,SeriesSummary,ChangeInClassRank,FALSE))","v":-1},{"$f":"IF(AND(SumSheet!BM25>0,SumSheet!C25=\"B\"),SumSheet!B25,\"\")","v":"Randy A."},{"$f":"IF(W9<>\"\",IF(ISNA(VLOOKUP($W9,SeriesSummary,TotalPoints,FALSE)),\"-\",VLOOKUP($W9,SeriesSummary,TotalPoints,FALSE)),\"\")","v":29},{"$f":"IF(ISERROR(X9-$X$7),\"\",X9-$X$7)","v":-19},2,320.16000000000003,1]
[null,{"$f":"IF(ISNA(VLOOKUP($D10,SeriesSummary,Rank,FALSE)),\"\",VLOOKUP($D10,SeriesSummary,Rank,FALSE))","v":4},{"$f":"IF(ISNA(VLOOKUP($D10,SeriesSummary,ChangeInRank,FALSE)),\"\",VLOOKUP($D10,SeriesSummary,ChangeInRank,FALSE))","v":"+2"},{"$f":"IF(SumSheet!BM20>0,SumSheet!B20,\"\")","v":"Mark L."},{"$f":"IF(SumSheet!BM20>0,SumSheet!C20,\"\")","v":"B"},48,-10,3,578.48,2,null,{"$f":"IF(ISNA(VLOOKUP($N10,SeriesSummary,ClassRank,FALSE)),\"\",VLOOKUP($N10,SeriesSummary,ClassRank,FALSE))","v":4},{"$f":"IF(ISNA(VLOOKUP($N10,SeriesSummary,ChangeInClassRank,FALSE)),\"\",VLOOKUP($N10,SeriesSummary,ChangeInClassRank,FALSE))","v":-1},{"$f":"IF(AND(SumSheet!BM29>0,SumSheet!C29=\"A\"),SumSheet!B29,\"\")","v":"Shawn G."},36,-22,2,428.12,0,null,{"$f":"IF(ISNA(VLOOKUP($W10,SeriesSummary,ClassRank,FALSE)),\"\",VLOOKUP($W10,SeriesSummary,ClassRank,FALSE))","v":4},{"$f":"IF(ISNA(VLOOKUP($W10,SeriesSummary,ChangeInClassRank,FALSE)),\"\",VLOOKUP($W10,SeriesSummary,ChangeInClassRank,FALSE))","v":"-"},{"$f":"IF(AND(SumSheet!BM26>0,SumSheet!C26=\"B\"),SumSheet!B26,\"\")","v":"Rich C."},11,-37,1,183.25,0]
[null,{"$f":"IF(ISNA(VLOOKUP($D11,SeriesSummary,Rank,FALSE)),\"\",VLOOKUP($D11,SeriesSummary,Rank,FALSE))","v":5},{"$f":"IF(ISNA(VLOOKUP($D11,SeriesSummary,ChangeInRank,FALSE)),\"\",VLOOKUP($D11,SeriesSummary,ChangeInRank,FALSE))","v":"+2"},{"$f":"IF(SumSheet!BM17>0,SumSheet!B17,\"\")","v":"John B."},{"$f":"IF(SumSheet!BM17>0,SumSheet!C17,\"\")","v":"B"},45,-13,3,568.29,0,null,{"$f":"IF(ISNA(VLOOKUP($N11,SeriesSummary,ClassRank,FALSE)),\"\",VLOOKUP($N11,SeriesSummary,ClassRank,FALSE))","v":5},{"$f":"IF(ISNA(VLOOKUP($N11,SeriesSummary,ChangeInClassRank,FALSE)),\"\",VLOOKUP($N11,SeriesSummary,ChangeInClassRank,FALSE))","v":"-"},{"$f":"IF(AND(SumSheet!BM30>0,SumSheet!C30=\"A\"),SumSheet!B30,\"\")","v":"Stephen B."},31,-27,2,392.42,0,null,{"$f":"IF(ISNA(VLOOKUP($W11,SeriesSummary,ClassRank,FALSE)),\"\",VLOOKUP($W11,SeriesSummary,ClassRank,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($W11,SeriesSummary,ChangeInClassRank,FALSE)),\"\",VLOOKUP($W11,SeriesSummary,ChangeInClassRank,FALSE))","v":""},{"$f":"IF(AND(SumSheet!BM14>0,SumSheet!C14=\"B\"),SumSheet!B14,\"\")","v":""},"","","","",""]
[null,{"$f":"IF(ISNA(VLOOKUP($D12,SeriesSummary,Rank,FALSE)),\"\",VLOOKUP($D12,SeriesSummary,Rank,FALSE))","v":6},{"$f":"IF(ISNA(VLOOKUP($D12,SeriesSummary,ChangeInRank,FALSE)),\"\",VLOOKUP($D12,SeriesSummary,ChangeInRank,FALSE))","v":-3},{"$f":"IF(SumSheet!BM29>0,SumSheet!B29,\"\")","v":"Shawn G."},{"$f":"IF(SumSheet!BM29>0,SumSheet!C29,\"\")","v":"A"},36,-22,2,428.12,0,null,{"$f":"IF(ISNA(VLOOKUP($N12,SeriesSummary,ClassRank,FALSE)),\"\",VLOOKUP($N12,SeriesSummary,ClassRank,FALSE))","v":6},{"$f":"IF(ISNA(VLOOKUP($N12,SeriesSummary,ChangeInClassRank,FALSE)),\"\",VLOOKUP($N12,SeriesSummary,ChangeInClassRank,FALSE))","v":"-"},{"$f":"IF(AND(SumSheet!BM9>0,SumSheet!C9=\"A\"),SumSheet!B9,\"\")","v":"Alejandro G."},15,-43,1,202.75,0,null,{"$f":"IF(ISNA(VLOOKUP($W12,SeriesSummary,ClassRank,FALSE)),\"\",VLOOKUP($W12,SeriesSummary,ClassRank,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($W12,SeriesSummary,ChangeInClassRank,FALSE)),\"\",VLOOKUP($W12,SeriesSummary,ChangeInClassRank,FALSE))","v":""},{"$f":"IF(AND(SumSheet!BM13>0,SumSheet!C13=\"B\"),SumSheet!B13,\"\")","v":""},"","","","",""]
[null,{"$f":"IF(ISNA(VLOOKUP($D13,SeriesSummary,Rank,FALSE)),\"\",VLOOKUP($D13,SeriesSummary,Rank,FALSE))","v":7},{"$f":"IF(ISNA(VLOOKUP($D13,SeriesSummary,ChangeInRank,FALSE)),\"\",VLOOKUP($D13,SeriesSummary,ChangeInRank,FALSE))","v":-2},{"$f":"IF(SumSheet!BM30>0,SumSheet!B30,\"\")","v":"Stephen B."},{"$f":"IF(SumSheet!BM30>0,SumSheet!C30,\"\")","v":"A"},31,-27,2,392.42,0,null,{"$f":"IF(ISNA(VLOOKUP($N13,SeriesSummary,ClassRank,FALSE)),\"\",VLOOKUP($N13,SeriesSummary,ClassRank,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($N13,SeriesSummary,ChangeInClassRank,FALSE)),\"\",VLOOKUP($N13,SeriesSummary,ChangeInClassRank,FALSE))","v":""},{"$f":"IF(AND(SumSheet!BM18>0,SumSheet!C18=\"A\"),SumSheet!B18,\"\")","v":""},"","","","","",null,{"$f":"IF(ISNA(VLOOKUP($W13,SeriesSummary,ClassRank,FALSE)),\"\",VLOOKUP($W13,SeriesSummary,ClassRank,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($W13,SeriesSummary,ChangeInClassRank,FALSE)),\"\",VLOOKUP($W13,SeriesSummary,ChangeInClassRank,FALSE))","v":""},{"$f":"IF(AND(SumSheet!BM23>0,SumSheet!C23=\"B\"),SumSheet!B23,\"\")","v":""},"","","","",""]
[null,{"$f":"IF(ISNA(VLOOKUP($D14,SeriesSummary,Rank,FALSE)),\"\",VLOOKUP($D14,SeriesSummary,Rank,FALSE))","v":8},{"$f":"IF(ISNA(VLOOKUP($D14,SeriesSummary,ChangeInRank,FALSE)),\"\",VLOOKUP($D14,SeriesSummary,ChangeInRank,FALSE))","v":-1},{"$f":"IF(SumSheet!BM25>0,SumSheet!B25,\"\")","v":"Randy A."},{"$f":"IF(SumSheet!BM25>0,SumSheet!C25,\"\")","v":"B"},29,-29,2,320.16000000000003,1,null,{"$f":"IF(ISNA(VLOOKUP($N14,SeriesSummary,ClassRank,FALSE)),\"\",VLOOKUP($N14,SeriesSummary,ClassRank,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($N14,SeriesSummary,ChangeInClassRank,FALSE)),\"\",VLOOKUP($N14,SeriesSummary,ChangeInClassRank,FALSE))","v":""},{"$f":"IF(AND(SumSheet!BM27>0,SumSheet!C27=\"A\"),SumSheet!B27,\"\")","v":""},"","","","","",null,{"$f":"IF(ISNA(VLOOKUP($W14,SeriesSummary,ClassRank,FALSE)),\"\",VLOOKUP($W14,SeriesSummary,ClassRank,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($W14,SeriesSummary,ChangeInClassRank,FALSE)),\"\",VLOOKUP($W14,SeriesSummary,ChangeInClassRank,FALSE))","v":""},{"$f":"IF(AND(SumSheet!BM16>0,SumSheet!C16=\"B\"),SumSheet!B16,\"\")","v":""},"","","","",""]
[null,{"$f":"IF(ISNA(VLOOKUP($D15,SeriesSummary,Rank,FALSE)),\"\",VLOOKUP($D15,SeriesSummary,Rank,FALSE))","v":9},{"$f":"IF(ISNA(VLOOKUP($D15,SeriesSummary,ChangeInRank,FALSE)),\"\",VLOOKUP($D15,SeriesSummary,ChangeInRank,FALSE))","v":"-"},{"$f":"IF(SumSheet!BM9>0,SumSheet!B9,\"\")","v":"Alejandro G."},{"$f":"IF(SumSheet!BM9>0,SumSheet!C9,\"\")","v":"A"},15,-43,1,202.75,0,null,{"$f":"IF(ISNA(VLOOKUP($N15,SeriesSummary,ClassRank,FALSE)),\"\",VLOOKUP($N15,SeriesSummary,ClassRank,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($N15,SeriesSummary,ChangeInClassRank,FALSE)),\"\",VLOOKUP($N15,SeriesSummary,ChangeInClassRank,FALSE))","v":""},{"$f":"IF(AND(SumSheet!BM28>0,SumSheet!C28=\"A\"),SumSheet!B28,\"\")","v":""},"","","","","",null,{"$f":"IF(ISNA(VLOOKUP($W15,SeriesSummary,ClassRank,FALSE)),\"\",VLOOKUP($W15,SeriesSummary,ClassRank,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($W15,SeriesSummary,ChangeInClassRank,FALSE)),\"\",VLOOKUP($W15,SeriesSummary,ChangeInClassRank,FALSE))","v":""},{"$f":"IF(AND(SumSheet!BM19>0,SumSheet!C19=\"B\"),SumSheet!B19,\"\")","v":""},"","","","",""]
[null,{"$f":"IF(ISNA(VLOOKUP($D16,SeriesSummary,Rank,FALSE)),\"\",VLOOKUP($D16,SeriesSummary,Rank,FALSE))","v":10},{"$f":"IF(ISNA(VLOOKUP($D16,SeriesSummary,ChangeInRank,FALSE)),\"\",VLOOKUP($D16,SeriesSummary,ChangeInRank,FALSE))","v":"-"},{"$f":"IF(SumSheet!BM26>0,SumSheet!B26,\"\")","v":"Rich C."},{"$f":"IF(SumSheet!BM26>0,SumSheet!C26,\"\")","v":"B"},11,-47,1,183.25,0,null,{"$f":"IF(ISNA(VLOOKUP($N16,SeriesSummary,ClassRank,FALSE)),\"\",VLOOKUP($N16,SeriesSummary,ClassRank,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($N16,SeriesSummary,ChangeInClassRank,FALSE)),\"\",VLOOKUP($N16,SeriesSummary,ChangeInClassRank,FALSE))","v":""},{"$f":"IF(AND(SumSheet!BM15>0,SumSheet!C15=\"A\"),SumSheet!B15,\"\")","v":""},"","","","","",null,{"$f":"IF(ISNA(VLOOKUP($W16,SeriesSummary,ClassRank,FALSE)),\"\",VLOOKUP($W16,SeriesSummary,ClassRank,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($W16,SeriesSummary,ChangeInClassRank,FALSE)),\"\",VLOOKUP($W16,SeriesSummary,ChangeInClassRank,FALSE))","v":""},{"$f":"IF(AND(SumSheet!BM24>0,SumSheet!C24=\"B\"),SumSheet!B24,\"\")","v":""},"","","","",""]
[null,{"$f":"IF(ISNA(VLOOKUP($D17,SeriesSummary,Rank,FALSE)),\"\",VLOOKUP($D17,SeriesSummary,Rank,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($D17,SeriesSummary,ChangeInRank,FALSE)),\"\",VLOOKUP($D17,SeriesSummary,ChangeInRank,FALSE))","v":""},{"$f":"IF(SumSheet!BM14>0,SumSheet!B14,\"\")","v":""},{"$f":"IF(SumSheet!BM14>0,SumSheet!C14,\"\")","v":""},"","","","","",null,{"$f":"IF(ISNA(VLOOKUP($N17,SeriesSummary,ClassRank,FALSE)),\"\",VLOOKUP($N17,SeriesSummary,ClassRank,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($N17,SeriesSummary,ChangeInClassRank,FALSE)),\"\",VLOOKUP($N17,SeriesSummary,ChangeInClassRank,FALSE))","v":""},{"$f":"IF(AND(SumSheet!BM20>0,SumSheet!C20=\"A\"),SumSheet!B20,\"\")","v":""},"","","","","",null,{"$f":"IF(ISNA(VLOOKUP($W17,SeriesSummary,ClassRank,FALSE)),\"\",VLOOKUP($W17,SeriesSummary,ClassRank,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($W17,SeriesSummary,ChangeInClassRank,FALSE)),\"\",VLOOKUP($W17,SeriesSummary,ChangeInClassRank,FALSE))","v":""},{"$f":"IF(AND(SumSheet!BM22>0,SumSheet!C22=\"B\"),SumSheet!B22,\"\")","v":""},"","","","",""]
[null,{"$f":"IF(ISNA(VLOOKUP($D18,SeriesSummary,Rank,FALSE)),\"\",VLOOKUP($D18,SeriesSummary,Rank,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($D18,SeriesSummary,ChangeInRank,FALSE)),\"\",VLOOKUP($D18,SeriesSummary,ChangeInRank,FALSE))","v":""},{"$f":"IF(SumSheet!BM18>0,SumSheet!B18,\"\")","v":""},{"$f":"IF(SumSheet!BM18>0,SumSheet!C18,\"\")","v":""},"","","","","",null,{"$f":"IF(ISNA(VLOOKUP($N18,SeriesSummary,ClassRank,FALSE)),\"\",VLOOKUP($N18,SeriesSummary,ClassRank,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($N18,SeriesSummary,ChangeInClassRank,FALSE)),\"\",VLOOKUP($N18,SeriesSummary,ChangeInClassRank,FALSE))","v":""},{"$f":"IF(AND(SumSheet!BM26>0,SumSheet!C26=\"A\"),SumSheet!B26,\"\")","v":""},"","","","","",null,{"$f":"IF(ISNA(VLOOKUP($W18,SeriesSummary,ClassRank,FALSE)),\"\",VLOOKUP($W18,SeriesSummary,ClassRank,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($W18,SeriesSummary,ChangeInClassRank,FALSE)),\"\",VLOOKUP($W18,SeriesSummary,ChangeInClassRank,FALSE))","v":""},{"$f":"IF(AND(SumSheet!BM30>0,SumSheet!C30=\"B\"),SumSheet!B30,\"\")","v":""},"","","","",""]
[null,{"$f":"IF(ISNA(VLOOKUP($D19,SeriesSummary,Rank,FALSE)),\"\",VLOOKUP($D19,SeriesSummary,Rank,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($D19,SeriesSummary,ChangeInRank,FALSE)),\"\",VLOOKUP($D19,SeriesSummary,ChangeInRank,FALSE))","v":""},{"$f":"IF(SumSheet!BM13>0,SumSheet!B13,\"\")","v":""},{"$f":"IF(SumSheet!BM13>0,SumSheet!C13,\"\")","v":""},"","","","","",null,{"$f":"IF(ISNA(VLOOKUP($N19,SeriesSummary,ClassRank,FALSE)),\"\",VLOOKUP($N19,SeriesSummary,ClassRank,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($N19,SeriesSummary,ChangeInClassRank,FALSE)),\"\",VLOOKUP($N19,SeriesSummary,ChangeInClassRank,FALSE))","v":""},{"$f":"IF(AND(SumSheet!BM17>0,SumSheet!C17=\"A\"),SumSheet!B17,\"\")","v":""},"","","","","",null,{"$f":"IF(ISNA(VLOOKUP($W19,SeriesSummary,ClassRank,FALSE)),\"\",VLOOKUP($W19,SeriesSummary,ClassRank,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($W19,SeriesSummary,ChangeInClassRank,FALSE)),\"\",VLOOKUP($W19,SeriesSummary,ChangeInClassRank,FALSE))","v":""},{"$f":"IF(AND(SumSheet!BM9>0,SumSheet!C9=\"B\"),SumSheet!B9,\"\")","v":""},"","","","",""]
[null,{"$f":"IF(ISNA(VLOOKUP($D20,SeriesSummary,Rank,FALSE)),\"\",VLOOKUP($D20,SeriesSummary,Rank,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($D20,SeriesSummary,ChangeInRank,FALSE)),\"\",VLOOKUP($D20,SeriesSummary,ChangeInRank,FALSE))","v":""},{"$f":"IF(SumSheet!BM27>0,SumSheet!B27,\"\")","v":""},{"$f":"IF(SumSheet!BM27>0,SumSheet!C27,\"\")","v":""},"","","","","",null,{"$f":"IF(ISNA(VLOOKUP($N20,SeriesSummary,ClassRank,FALSE)),\"\",VLOOKUP($N20,SeriesSummary,ClassRank,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($N20,SeriesSummary,ChangeInClassRank,FALSE)),\"\",VLOOKUP($N20,SeriesSummary,ChangeInClassRank,FALSE))","v":""},{"$f":"IF(AND(SumSheet!BM11>0,SumSheet!C11=\"A\"),SumSheet!B11,\"\")","v":""},"","","","","",null,{"$f":"IF(ISNA(VLOOKUP($W20,SeriesSummary,ClassRank,FALSE)),\"\",VLOOKUP($W20,SeriesSummary,ClassRank,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($W20,SeriesSummary,ChangeInClassRank,FALSE)),\"\",VLOOKUP($W20,SeriesSummary,ChangeInClassRank,FALSE))","v":""},{"$f":"IF(AND(SumSheet!BM10>0,SumSheet!C10=\"B\"),SumSheet!B10,\"\")","v":""},"","","","",""]
[null,{"$f":"IF(ISNA(VLOOKUP($D21,SeriesSummary,Rank,FALSE)),\"\",VLOOKUP($D21,SeriesSummary,Rank,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($D21,SeriesSummary,ChangeInRank,FALSE)),\"\",VLOOKUP($D21,SeriesSummary,ChangeInRank,FALSE))","v":""},{"$f":"IF(SumSheet!BM28>0,SumSheet!B28,\"\")","v":""},{"$f":"IF(SumSheet!BM28>0,SumSheet!C28,\"\")","v":""},"","","","","",null,{"$f":"IF(ISNA(VLOOKUP($N21,SeriesSummary,ClassRank,FALSE)),\"\",VLOOKUP($N21,SeriesSummary,ClassRank,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($N21,SeriesSummary,ChangeInClassRank,FALSE)),\"\",VLOOKUP($N21,SeriesSummary,ChangeInClassRank,FALSE))","v":""},{"$f":"IF(AND(SumSheet!BM12>0,SumSheet!C12=\"A\"),SumSheet!B12,\"\")","v":""},"","","","","",null,{"$f":"IF(ISNA(VLOOKUP($W21,SeriesSummary,ClassRank,FALSE)),\"\",VLOOKUP($W21,SeriesSummary,ClassRank,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($W21,SeriesSummary,ChangeInClassRank,FALSE)),\"\",VLOOKUP($W21,SeriesSummary,ChangeInClassRank,FALSE))","v":""},{"$f":"IF(AND(SumSheet!BM11>0,SumSheet!C11=\"B\"),SumSheet!B11,\"\")","v":""},"","","","",""]
[null,{"$f":"IF(ISNA(VLOOKUP($D22,SeriesSummary,Rank,FALSE)),\"\",VLOOKUP($D22,SeriesSummary,Rank,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($D22,SeriesSummary,ChangeInRank,FALSE)),\"\",VLOOKUP($D22,SeriesSummary,ChangeInRank,FALSE))","v":""},{"$f":"IF(SumSheet!BM23>0,SumSheet!B23,\"\")","v":""},{"$f":"IF(SumSheet!BM23>0,SumSheet!C23,\"\")","v":""},"","","","","",null,{"$f":"IF(ISNA(VLOOKUP($N22,SeriesSummary,ClassRank,FALSE)),\"\",VLOOKUP($N22,SeriesSummary,ClassRank,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($N22,SeriesSummary,ChangeInClassRank,FALSE)),\"\",VLOOKUP($N22,SeriesSummary,ChangeInClassRank,FALSE))","v":""},{"$f":"IF(AND(SumSheet!BM13>0,SumSheet!C13=\"A\"),SumSheet!B13,\"\")","v":""},"","","","","",null,{"$f":"IF(ISNA(VLOOKUP($W22,SeriesSummary,ClassRank,FALSE)),\"\",VLOOKUP($W22,SeriesSummary,ClassRank,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($W22,SeriesSummary,ChangeInClassRank,FALSE)),\"\",VLOOKUP($W22,SeriesSummary,ChangeInClassRank,FALSE))","v":""},{"$f":"IF(AND(SumSheet!BM12>0,SumSheet!C12=\"B\"),SumSheet!B12,\"\")","v":""},"","","","",""]
[null,{"$f":"IF(ISNA(VLOOKUP($D23,SeriesSummary,Rank,FALSE)),\"\",VLOOKUP($D23,SeriesSummary,Rank,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($D23,SeriesSummary,ChangeInRank,FALSE)),\"\",VLOOKUP($D23,SeriesSummary,ChangeInRank,FALSE))","v":""},{"$f":"IF(SumSheet!BM15>0,SumSheet!B15,\"\")","v":""},{"$f":"IF(SumSheet!BM15>0,SumSheet!C15,\"\")","v":""},"","","","","",null,{"$f":"IF(ISNA(VLOOKUP($N23,SeriesSummary,ClassRank,FALSE)),\"\",VLOOKUP($N23,SeriesSummary,ClassRank,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($N23,SeriesSummary,ChangeInClassRank,FALSE)),\"\",VLOOKUP($N23,SeriesSummary,ChangeInClassRank,FALSE))","v":""},{"$f":"IF(AND(SumSheet!BM14>0,SumSheet!C14=\"A\"),SumSheet!B14,\"\")","v":""},"","","","","",null,{"$f":"IF(ISNA(VLOOKUP($W23,SeriesSummary,ClassRank,FALSE)),\"\",VLOOKUP($W23,SeriesSummary,ClassRank,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($W23,SeriesSummary,ChangeInClassRank,FALSE)),\"\",VLOOKUP($W23,SeriesSummary,ChangeInClassRank,FALSE))","v":""},{"$f":"IF(AND(SumSheet!BM15>0,SumSheet!C15=\"B\"),SumSheet!B15,\"\")","v":""},"","","","",""]
[null,{"$f":"IF(ISNA(VLOOKUP($D24,SeriesSummary,Rank,FALSE)),\"\",VLOOKUP($D24,SeriesSummary,Rank,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($D24,SeriesSummary,ChangeInRank,FALSE)),\"\",VLOOKUP($D24,SeriesSummary,ChangeInRank,FALSE))","v":""},{"$f":"IF(SumSheet!BM19>0,SumSheet!B19,\"\")","v":""},{"$f":"IF(SumSheet!BM19>0,SumSheet!C19,\"\")","v":""},"","","","","",null,{"$f":"IF(ISNA(VLOOKUP($N24,SeriesSummary,ClassRank,FALSE)),\"\",VLOOKUP($N24,SeriesSummary,ClassRank,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($N24,SeriesSummary,ChangeInClassRank,FALSE)),\"\",VLOOKUP($N24,SeriesSummary,ChangeInClassRank,FALSE))","v":""},{"$f":"IF(AND(SumSheet!BM19>0,SumSheet!C19=\"A\"),SumSheet!B19,\"\")","v":""},"","","","","",null,{"$f":"IF(ISNA(VLOOKUP($W24,SeriesSummary,ClassRank,FALSE)),\"\",VLOOKUP($W24,SeriesSummary,ClassRank,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($W24,SeriesSummary,ChangeInClassRank,FALSE)),\"\",VLOOKUP($W24,SeriesSummary,ChangeInClassRank,FALSE))","v":""},{"$f":"IF(AND(SumSheet!BM18>0,SumSheet!C18=\"B\"),SumSheet!B18,\"\")","v":""},"","","","",""]
[null,{"$f":"IF(ISNA(VLOOKUP($D25,SeriesSummary,Rank,FALSE)),\"\",VLOOKUP($D25,SeriesSummary,Rank,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($D25,SeriesSummary,ChangeInRank,FALSE)),\"\",VLOOKUP($D25,SeriesSummary,ChangeInRank,FALSE))","v":""},{"$f":"IF(SumSheet!BM24>0,SumSheet!B24,\"\")","v":""},{"$f":"IF(SumSheet!BM24>0,SumSheet!C24,\"\")","v":""},"","","","","",null,{"$f":"IF(ISNA(VLOOKUP($N25,SeriesSummary,ClassRank,FALSE)),\"\",VLOOKUP($N25,SeriesSummary,ClassRank,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($N25,SeriesSummary,ChangeInClassRank,FALSE)),\"\",VLOOKUP($N25,SeriesSummary,ChangeInClassRank,FALSE))","v":""},{"$f":"IF(AND(SumSheet!BM22>0,SumSheet!C22=\"A\"),SumSheet!B22,\"\")","v":""},"","","","","",null,{"$f":"IF(ISNA(VLOOKUP($W25,SeriesSummary,ClassRank,FALSE)),\"\",VLOOKUP($W25,SeriesSummary,ClassRank,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($W25,SeriesSummary,ChangeInClassRank,FALSE)),\"\",VLOOKUP($W25,SeriesSummary,ChangeInClassRank,FALSE))","v":""},{"$f":"IF(AND(SumSheet!BM21>0,SumSheet!C21=\"B\"),SumSheet!B21,\"\")","v":""},"","","","",""]
[null,{"$f":"IF(ISNA(VLOOKUP($D26,SeriesSummary,Rank,FALSE)),\"\",VLOOKUP($D26,SeriesSummary,Rank,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($D26,SeriesSummary,ChangeInRank,FALSE)),\"\",VLOOKUP($D26,SeriesSummary,ChangeInRank,FALSE))","v":""},{"$f":"IF(SumSheet!BM22>0,SumSheet!B22,\"\")","v":""},{"$f":"IF(SumSheet!BM22>0,SumSheet!C22,\"\")","v":""},"","","","","",null,{"$f":"IF(ISNA(VLOOKUP($N26,SeriesSummary,ClassRank,FALSE)),\"\",VLOOKUP($N26,SeriesSummary,ClassRank,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($N26,SeriesSummary,ChangeInClassRank,FALSE)),\"\",VLOOKUP($N26,SeriesSummary,ChangeInClassRank,FALSE))","v":""},{"$f":"IF(AND(SumSheet!BM23>0,SumSheet!C23=\"A\"),SumSheet!B23,\"\")","v":""},"","","","","",null,{"$f":"IF(ISNA(VLOOKUP($W26,SeriesSummary,ClassRank,FALSE)),\"\",VLOOKUP($W26,SeriesSummary,ClassRank,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($W26,SeriesSummary,ChangeInClassRank,FALSE)),\"\",VLOOKUP($W26,SeriesSummary,ChangeInClassRank,FALSE))","v":""},{"$f":"IF(AND(SumSheet!BM27>0,SumSheet!C27=\"B\"),SumSheet!B27,\"\")","v":""},"","","","",""]
[null,{"$f":"IF(ISNA(VLOOKUP($D27,SeriesSummary,Rank,FALSE)),\"\",VLOOKUP($D27,SeriesSummary,Rank,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($D27,SeriesSummary,ChangeInRank,FALSE)),\"\",VLOOKUP($D27,SeriesSummary,ChangeInRank,FALSE))","v":""},{"$f":"IF(SumSheet!BM11>0,SumSheet!B11,\"\")","v":""},{"$f":"IF(SumSheet!BM11>0,SumSheet!C11,\"\")","v":""},"","","","","",null,{"$f":"IF(ISNA(VLOOKUP($N27,SeriesSummary,ClassRank,FALSE)),\"\",VLOOKUP($N27,SeriesSummary,ClassRank,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($N27,SeriesSummary,ChangeInClassRank,FALSE)),\"\",VLOOKUP($N27,SeriesSummary,ChangeInClassRank,FALSE))","v":""},{"$f":"IF(AND(SumSheet!BM24>0,SumSheet!C24=\"A\"),SumSheet!B24,\"\")","v":""},"","","","","",null,{"$f":"IF(ISNA(VLOOKUP($W27,SeriesSummary,ClassRank,FALSE)),\"\",VLOOKUP($W27,SeriesSummary,ClassRank,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($W27,SeriesSummary,ChangeInClassRank,FALSE)),\"\",VLOOKUP($W27,SeriesSummary,ChangeInClassRank,FALSE))","v":""},{"$f":"IF(AND(SumSheet!BM28>0,SumSheet!C28=\"B\"),SumSheet!B28,\"\")","v":""},"","","","",""]
[null,{"$f":"IF(ISNA(VLOOKUP($D28,SeriesSummary,Rank,FALSE)),\"\",VLOOKUP($D28,SeriesSummary,Rank,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($D28,SeriesSummary,ChangeInRank,FALSE)),\"\",VLOOKUP($D28,SeriesSummary,ChangeInRank,FALSE))","v":""},{"$f":"IF(SumSheet!BM12>0,SumSheet!B12,\"\")","v":""},{"$f":"IF(SumSheet!BM12>0,SumSheet!C12,\"\")","v":""},"","","","","",null,{"$f":"IF(ISNA(VLOOKUP($N28,SeriesSummary,ClassRank,FALSE)),\"\",VLOOKUP($N28,SeriesSummary,ClassRank,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($N28,SeriesSummary,ChangeInClassRank,FALSE)),\"\",VLOOKUP($N28,SeriesSummary,ChangeInClassRank,FALSE))","v":""},{"$f":"IF(AND(SumSheet!BM25>0,SumSheet!C25=\"A\"),SumSheet!B25,\"\")","v":""},"","","","","",null,{"$f":"IF(ISNA(VLOOKUP($W28,SeriesSummary,ClassRank,FALSE)),\"\",VLOOKUP($W28,SeriesSummary,ClassRank,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($W28,SeriesSummary,ChangeInClassRank,FALSE)),\"\",VLOOKUP($W28,SeriesSummary,ChangeInClassRank,FALSE))","v":""},{"$f":"IF(AND(SumSheet!BM29>0,SumSheet!C29=\"B\"),SumSheet!B29,\"\")","v":""},"","","","",""]
[null,{"$f":"IF(ISNA(VLOOKUP($D29,SeriesSummary,Rank,FALSE)),\"\",VLOOKUP($D29,SeriesSummary,Rank,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($D29,SeriesSummary,ChangeInRank,FALSE)),\"\",VLOOKUP($D29,SeriesSummary,ChangeInRank,FALSE))","v":""},{"$f":"IF(SumSheet!BM31>0,SumSheet!B31,\"\")","v":""},{"$f":"IF(SumSheet!BM31>0,SumSheet!C31,\"\")","v":""},"","","","","",null,{"$f":"IF(ISNA(VLOOKUP($N29,SeriesSummary,ClassRank,FALSE)),\"\",VLOOKUP($N29,SeriesSummary,ClassRank,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($N29,SeriesSummary,ChangeInClassRank,FALSE)),\"\",VLOOKUP($N29,SeriesSummary,ChangeInClassRank,FALSE))","v":""},{"$f":"IF(AND(SumSheet!BM31>0,SumSheet!C31=\"A\"),SumSheet!B31,\"\")","v":""},"","","","","",null,{"$f":"IF(ISNA(VLOOKUP($W29,SeriesSummary,ClassRank,FALSE)),\"\",VLOOKUP($W29,SeriesSummary,ClassRank,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($W29,SeriesSummary,ChangeInClassRank,FALSE)),\"\",VLOOKUP($W29,SeriesSummary,ChangeInClassRank,FALSE))","v":""},{"$f":"IF(AND(SumSheet!BM31>0,SumSheet!C31=\"B\"),SumSheet!B31,\"\")","v":""},"","","","",""]
[null,{"$f":"IF(ISNA(VLOOKUP($D30,SeriesSummary,Rank,FALSE)),\"\",VLOOKUP($D30,SeriesSummary,Rank,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($D30,SeriesSummary,ChangeInRank,FALSE)),\"\",VLOOKUP($D30,SeriesSummary,ChangeInRank,FALSE))","v":""},{"$f":"IF(SumSheet!BM32>0,SumSheet!B32,\"\")","v":""},{"$f":"IF(SumSheet!BM32>0,SumSheet!C32,\"\")","v":""},"","","","","",null,{"$f":"IF(ISNA(VLOOKUP($N30,SeriesSummary,ClassRank,FALSE)),\"\",VLOOKUP($N30,SeriesSummary,ClassRank,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($N30,SeriesSummary,ChangeInClassRank,FALSE)),\"\",VLOOKUP($N30,SeriesSummary,ChangeInClassRank,FALSE))","v":""},{"$f":"IF(AND(SumSheet!BM32>0,SumSheet!C32=\"A\"),SumSheet!B32,\"\")","v":""},"","","","","",null,{"$f":"IF(ISNA(VLOOKUP($W30,SeriesSummary,ClassRank,FALSE)),\"\",VLOOKUP($W30,SeriesSummary,ClassRank,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($W30,SeriesSummary,ChangeInClassRank,FALSE)),\"\",VLOOKUP($W30,SeriesSummary,ChangeInClassRank,FALSE))","v":""},{"$f":"IF(AND(SumSheet!BM32>0,SumSheet!C32=\"B\"),SumSheet!B32,\"\")","v":""},"","","","",""]
[null,{"$f":"IF(ISNA(VLOOKUP($D31,SeriesSummary,Rank,FALSE)),\"\",VLOOKUP($D31,SeriesSummary,Rank,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($D31,SeriesSummary,ChangeInRank,FALSE)),\"\",VLOOKUP($D31,SeriesSummary,ChangeInRank,FALSE))","v":""},{"$f":"IF(SumSheet!BM33>0,SumSheet!B33,\"\")","v":""},{"$f":"IF(SumSheet!BM33>0,SumSheet!C33,\"\")","v":""},"","","","","",null,{"$f":"IF(ISNA(VLOOKUP($N31,SeriesSummary,ClassRank,FALSE)),\"\",VLOOKUP($N31,SeriesSummary,ClassRank,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($N31,SeriesSummary,ChangeInClassRank,FALSE)),\"\",VLOOKUP($N31,SeriesSummary,ChangeInClassRank,FALSE))","v":""},{"$f":"IF(AND(SumSheet!BM33>0,SumSheet!C33=\"A\"),SumSheet!B33,\"\")","v":""},"","","","","",null,{"$f":"IF(ISNA(VLOOKUP($W31,SeriesSummary,ClassRank,FALSE)),\"\",VLOOKUP($W31,SeriesSummary,ClassRank,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($W31,SeriesSummary,ChangeInClassRank,FALSE)),\"\",VLOOKUP($W31,SeriesSummary,ChangeInClassRank,FALSE))","v":""},{"$f":"IF(AND(SumSheet!BM33>0,SumSheet!C33=\"B\"),SumSheet!B33,\"\")","v":""},"","","","",""]
[null,{"$f":"IF(ISNA(VLOOKUP($D32,SeriesSummary,Rank,FALSE)),\"\",VLOOKUP($D32,SeriesSummary,Rank,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($D32,SeriesSummary,ChangeInRank,FALSE)),\"\",VLOOKUP($D32,SeriesSummary,ChangeInRank,FALSE))","v":""},{"$f":"IF(SumSheet!BM34>0,SumSheet!B34,\"\")","v":""},{"$f":"IF(SumSheet!BM34>0,SumSheet!C34,\"\")","v":""},"","","","","",null,{"$f":"IF(ISNA(VLOOKUP($N32,SeriesSummary,ClassRank,FALSE)),\"\",VLOOKUP($N32,SeriesSummary,ClassRank,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($N32,SeriesSummary,ChangeInClassRank,FALSE)),\"\",VLOOKUP($N32,SeriesSummary,ChangeInClassRank,FALSE))","v":""},{"$f":"IF(AND(SumSheet!BM34>0,SumSheet!C34=\"A\"),SumSheet!B34,\"\")","v":""},"","","","","",null,{"$f":"IF(ISNA(VLOOKUP($W32,SeriesSummary,ClassRank,FALSE)),\"\",VLOOKUP($W32,SeriesSummary,ClassRank,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($W32,SeriesSummary,ChangeInClassRank,FALSE)),\"\",VLOOKUP($W32,SeriesSummary,ChangeInClassRank,FALSE))","v":""},{"$f":"IF(AND(SumSheet!BM34>0,SumSheet!C34=\"B\"),SumSheet!B34,\"\")","v":""},"","","","",""]
[null,{"$f":"IF(ISNA(VLOOKUP($D33,SeriesSummary,Rank,FALSE)),\"\",VLOOKUP($D33,SeriesSummary,Rank,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($D33,SeriesSummary,ChangeInRank,FALSE)),\"\",VLOOKUP($D33,SeriesSummary,ChangeInRank,FALSE))","v":""},{"$f":"IF(SumSheet!BM35>0,SumSheet!B35,\"\")","v":""},{"$f":"IF(SumSheet!BM35>0,SumSheet!C35,\"\")","v":""},"","","","","",null,{"$f":"IF(ISNA(VLOOKUP($N33,SeriesSummary,ClassRank,FALSE)),\"\",VLOOKUP($N33,SeriesSummary,ClassRank,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($N33,SeriesSummary,ChangeInClassRank,FALSE)),\"\",VLOOKUP($N33,SeriesSummary,ChangeInClassRank,FALSE))","v":""},{"$f":"IF(AND(SumSheet!BM35>0,SumSheet!C35=\"A\"),SumSheet!B35,\"\")","v":""},"","","","","",null,{"$f":"IF(ISNA(VLOOKUP($W33,SeriesSummary,ClassRank,FALSE)),\"\",VLOOKUP($W33,SeriesSummary,ClassRank,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($W33,SeriesSummary,ChangeInClassRank,FALSE)),\"\",VLOOKUP($W33,SeriesSummary,ChangeInClassRank,FALSE))","v":""},{"$f":"IF(AND(SumSheet!BM35>0,SumSheet!C35=\"B\"),SumSheet!B35,\"\")","v":""},"","","","",""]
[null,{"$f":"IF(ISNA(VLOOKUP($D34,SeriesSummary,Rank,FALSE)),\"\",VLOOKUP($D34,SeriesSummary,Rank,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($D34,SeriesSummary,ChangeInRank,FALSE)),\"\",VLOOKUP($D34,SeriesSummary,ChangeInRank,FALSE))","v":""},{"$f":"IF(SumSheet!BM36>0,SumSheet!B36,\"\")","v":""},{"$f":"IF(SumSheet!BM36>0,SumSheet!C36,\"\")","v":""},"","","","","",null,{"$f":"IF(ISNA(VLOOKUP($N34,SeriesSummary,ClassRank,FALSE)),\"\",VLOOKUP($N34,SeriesSummary,ClassRank,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($N34,SeriesSummary,ChangeInClassRank,FALSE)),\"\",VLOOKUP($N34,SeriesSummary,ChangeInClassRank,FALSE))","v":""},{"$f":"IF(AND(SumSheet!BM36>0,SumSheet!C36=\"A\"),SumSheet!B36,\"\")","v":""},"","","","","",null,{"$f":"IF(ISNA(VLOOKUP($W34,SeriesSummary,ClassRank,FALSE)),\"\",VLOOKUP($W34,SeriesSummary,ClassRank,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($W34,SeriesSummary,ChangeInClassRank,FALSE)),\"\",VLOOKUP($W34,SeriesSummary,ChangeInClassRank,FALSE))","v":""},{"$f":"IF(AND(SumSheet!BM36>0,SumSheet!C36=\"B\"),SumSheet!B36,\"\")","v":""},"","","","",""]
[null,{"$f":"IF(ISNA(VLOOKUP($D35,SeriesSummary,Rank,FALSE)),\"\",VLOOKUP($D35,SeriesSummary,Rank,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($D35,SeriesSummary,ChangeInRank,FALSE)),\"\",VLOOKUP($D35,SeriesSummary,ChangeInRank,FALSE))","v":""},{"$f":"IF(SumSheet!BM37>0,SumSheet!B37,\"\")","v":""},{"$f":"IF(SumSheet!BM37>0,SumSheet!C37,\"\")","v":""},"","","","","",null,{"$f":"IF(ISNA(VLOOKUP($N35,SeriesSummary,ClassRank,FALSE)),\"\",VLOOKUP($N35,SeriesSummary,ClassRank,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($N35,SeriesSummary,ChangeInClassRank,FALSE)),\"\",VLOOKUP($N35,SeriesSummary,ChangeInClassRank,FALSE))","v":""},{"$f":"IF(AND(SumSheet!BM37>0,SumSheet!C37=\"A\"),SumSheet!B37,\"\")","v":""},"","","","","",null,{"$f":"IF(ISNA(VLOOKUP($W35,SeriesSummary,ClassRank,FALSE)),\"\",VLOOKUP($W35,SeriesSummary,ClassRank,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($W35,SeriesSummary,ChangeInClassRank,FALSE)),\"\",VLOOKUP($W35,SeriesSummary,ChangeInClassRank,FALSE))","v":""},{"$f":"IF(AND(SumSheet!BM37>0,SumSheet!C37=\"B\"),SumSheet!B37,\"\")","v":""},"","","","",""]
[null,{"$f":"IF(ISNA(VLOOKUP($D36,SeriesSummary,Rank,FALSE)),\"\",VLOOKUP($D36,SeriesSummary,Rank,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($D36,SeriesSummary,ChangeInRank,FALSE)),\"\",VLOOKUP($D36,SeriesSummary,ChangeInRank,FALSE))","v":""},{"$f":"IF(SumSheet!BM38>0,SumSheet!B38,\"\")","v":""},{"$f":"IF(SumSheet!BM38>0,SumSheet!C38,\"\")","v":""},"","","","","",null,{"$f":"IF(ISNA(VLOOKUP($N36,SeriesSummary,ClassRank,FALSE)),\"\",VLOOKUP($N36,SeriesSummary,ClassRank,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($N36,SeriesSummary,ChangeInClassRank,FALSE)),\"\",VLOOKUP($N36,SeriesSummary,ChangeInClassRank,FALSE))","v":""},{"$f":"IF(AND(SumSheet!BM38>0,SumSheet!C38=\"A\"),SumSheet!B38,\"\")","v":""},"","","","","",null,{"$f":"IF(ISNA(VLOOKUP($W36,SeriesSummary,ClassRank,FALSE)),\"\",VLOOKUP($W36,SeriesSummary,ClassRank,FALSE))","v":""},{"$f":"IF(ISNA(VLOOKUP($W36,SeriesSummary,ChangeInClassRank,FALSE)),\"\",VLOOKUP($W36,SeriesSummary,ChangeInClassRank,FALSE))","v":""},{"$f":"IF(AND(SumSheet!BM38>0,SumSheet!C38=\"B\"),SumSheet!B38,\"\")","v":""},"","","","",""]

{"sheet":"Round 1","index":1,"n_rows":49,"n_cols":8,"rows_kept":49,"cut":false,"hidden":false,"merged":[[1,1,1,7]]}
[]
[null,{"$f":"SeriesName & \" - Round 1\"","v":"2017 BTCC - Round 1"}]
[null,"Position","Driver","Laps","Fastest Lap","Group","Fastest Lap Bonus","Points"]
[null,1,"David C.",214.39,3.9740000000000002,{"$f":"IF(ISNA(VLOOKUP(C4,SeriesSummary,Group,FALSE)),\"\",VLOOKUP(C4,SeriesSummary,Group,FALSE))","v":"A"},{"$f":"IF(C4<>\"\",IF(AND(E4=MIN( IF( $F$4:$F$23=F4, $E$4:$E$23)),E4>0),1,0),\"\")","v":1},{"$f":"IF(ISNA(VLOOKUP(B4,Points,2,FALSE)),\"\",VLOOKUP(B4,Points,2,FALSE)+G4)","v":21}]
[null,2,"Shawn G.",214.36,4.077,"A",{"$f":"IF(C5<>\"\",IF(AND(E5=MIN( IF( $F$4:$F$23=F5, $E$4:$E$23)),E5>0),1,0),\"\")","v":0},19]
[null,3,"Ary B.",212.74,4.09,"A",{"$f":"IF(C6<>\"\",IF(AND(E6=MIN( IF( $F$4:$F$23=F6, $E$4:$E$23)),E6>0),1,0),\"\")","v":0},18]
[null,4,"John B.",192.72,4.2859999999999996,"B",{"$f":"IF(C7<>\"\",IF(AND(E7=MIN( IF( $F$4:$F$23=F7, $E$4:$E$23)),E7>0),1,0),\"\")","v":0},17]
[null,5,"Mark L.",192.27,4.25,"B",{"$f":"IF(C8<>\"\",IF(AND(E8=MIN( IF( $F$4:$F$23=F8, $E$4:$E$23)),E8>0),1,0),\"\")","v":1},17]
[null,6,"Stephen B.",188.71,4.0960000000000001,"A",{"$f":"IF(C9<>\"\",IF(AND(E9=MIN( IF( $F$4:$F$23=F9, $E$4:$E$23)),E9>0),1,0),\"\")","v":0},15]
[null,7,"Randy A.",121.23,4.5119999999999996,"B",{"$f":"IF(C10<>\"\",IF(AND(E10=MIN( IF( $F$4:$F$23=F10, $E$4:$E$23)),E10>0),1,0),\"\")","v":0},14]
[null,8,"Marty M.",110.9,4.0720000000000001,"A",{"$f":"IF(C11<>\"\",IF(AND(E11=MIN( IF( $F$4:$F$23=F11, $E$4:$E$23)),E11>0),1,0),\"\")","v":0},13]
[null,null,null,null,null,"",{"$f":"IF(C12<>\"\",IF(AND(E12=MIN( IF( $F$4:$F$23=F12, $E$4:$E$23)),E12>0),1,0),\"\")","v":""},""]
[null,null,null,null,null,"",{"$f":"IF(C13<>\"\",IF(AND(E13=MIN( IF( $F$4:$F$23=F13, $E$4:$E$23)),E13>0),1,0),\"\")","v":""},""]
[null,null,null,null,null,"",{"$f":"IF(C14<>\"\",IF(AND(E14=MIN( IF( $F$4:$F$23=F14, $E$4:$E$23)),E14>0),1,0),\"\")","v":""},""]
[null,null,null,null,null,"",{"$f":"IF(C15<>\"\",IF(AND(E15=MIN( IF( $F$4:$F$23=F15, $E$4:$E$23)),E15>0),1,0),\"\")","v":""},""]
[null,null,null,null,null,"",{"$f":"IF(C16<>\"\",IF(AND(E16=MIN( IF( $F$4:$F$23=F16, $E$4:$E$23)),E16>0),1,0),\"\")","v":""},""]
[null,null,null,null,null,"",{"$f":"IF(C17<>\"\",IF(AND(E17=MIN( IF( $F$4:$F$23=F17, $E$4:$E$23)),E17>0),1,0),\"\")","v":""},""]
[null,null,null,null,null,"",{"$f":"IF(C18<>\"\",IF(AND(E18=MIN( IF( $F$4:$F$23=F18, $E$4:$E$23)),E18>0),1,0),\"\")","v":""},""]
[null,null,null,null,null,"",{"$f":"IF(C19<>\"\",IF(AND(E19=MIN( IF( $F$4:$F$23=F19, $E$4:$E$23)),E19>0),1,0),\"\")","v":""},""]
[null,null,null,null,null,"",{"$f":"IF(C20<>\"\",IF(AND(E20=MIN( IF( $F$4:$F$23=F20, $E$4:$E$23)),E20>0),1,0),\"\")","v":""},""]
[null,null,null,null,null,"",{"$f":"IF(C21<>\"\",IF(AND(E21=MIN( IF( $F$4:$F$23=F21, $E$4:$E$23)),E21>0),1,0),\"\")","v":""},""]
[null,null,null,null,null,"",{"$f":"IF(C22<>\"\",IF(AND(E22=MIN( IF( $F$4:$F$23=F22, $E$4:$E$23)),E22>0),1,0),\"\")","v":""},""]
[null,null,null,null,null,"",{"$f":"IF(C23<>\"\",IF(AND(E23=MIN( IF( $F$4:$F$23=F23, $E$4:$E$23)),E23>0),1,0),\"\")","v":""},""]
[]
[null,"Driver","Lane","Slowest Lap Time","Fastest Lap Time","Average Lap Time","Total Laps"]
[null,"David C.",1,6.1289999999999996,3.9740000000000002,4.2009999999999996,71.39]
[null,"David C.",2,6.46,4.0209999999999999,4.1769999999999996,72]
[null,"David C.",3,6.657,4.0229999999999997,4.2130000000000001,71]
[null,"Shawn G.",1,8.0730000000000004,4.077,4.2169999999999996,72.36]
[null,"Shawn G.",2,6.63,4.1319999999999997,4.2610000000000001,70]
[null,"Shawn G.",3,8.1519999999999992,4.0780000000000003,4.2210000000000001,72]
[null,"Ary B.",1,5.9669999999999996,4.09,4.2039999999999997,71.739999999999995]
[null,"Ary B.",2,6.3040000000000003,4.1159999999999997,4.2320000000000002,71]
[null,"Ary B.",3,5.3609999999999998,4.1639999999999997,4.2530000000000001,70]
[null,"John B.",1,10.472,4.351,4.7530000000000001,64.72]
[null,"John B.",2,6.8259999999999996,4.2859999999999996,4.5650000000000004,65]
[null,"John B.",3,9.5530000000000008,4.3570000000000002,4.8170000000000002,63]
[null,"Mark L.",1,6.875,4.3109999999999999,4.7869999999999999,62.27]
[null,"Mark L.",2,7.8869999999999996,4.25,4.67,64]
[null,"Mark L.",3,6.2380000000000004,4.3410000000000002,4.5819999999999999,66]
[null,"Stephen B.",1,6.702,4.0960000000000001,4.7300000000000004,63.71]
[null,"Stephen B.",2,15.282,4.1289999999999996,4.923,61]
[null,"Stephen B.",3,9.42,4.0999999999999996,4.657,64]
[null,"Randy A.",1,9.0850000000000009,4.5119999999999996,9.4640000000000004,64.23]
[null,"Randy A.",2,"--","--","--",0]
[null,"Randy A.",3,7.9089999999999998,4.53,5.2329999999999997,57]
[null,"Marty M.",1,7.3140000000000001,4.1020000000000003,4.4669999999999996,67.900000000000006]
[null,"Marty M.",2,"--","--","--",0]
[null,"Marty M.",3,8.2569999999999997,4.0720000000000001,4.4969999999999999,43]

{"sheet":"Round 2","index":2,"n_rows":55,"n_cols":8,"rows_kept":55,"cut":false,"hidden":false,"merged":[[1,1,1,7]]}
[]
[null,{"$f":"SeriesName & \" - Round 2\"","v":"2017 BTCC - Round 2"}]
[null,"Position","Driver","Laps","Fastest Lap","Group","Fastest Lap Bonus","Points"]
[null,1,"Ary B.",222.77,3.871,{"$f":"IF(ISNA(VLOOKUP(C4,SeriesSummary,Group,FALSE)),\"\",VLOOKUP(C4,SeriesSummary,Group,FALSE))","v":"A"},{"$f":"IF(C4<>\"\",IF(AND(E4=MIN( IF( $F$4:$F$23=F4, $E$4:$E$23)),E4>0),1,0),\"\")","v":1},{"$f":"IF(ISNA(VLOOKUP(B4,Points,2,FALSE)),\"\",VLOOKUP(B4,Points,2,FALSE)+G4)","v":21}]
[null,2,"Marty M.",221.2,3.9209999999999998,"A",{"$f":"IF(C5<>\"\",IF(AND(E5=MIN( IF( $F$4:$F$23=F5, $E$4:$E$23)),E5>0),1,0),\"\")","v":0},19]
[null,3,"David C.",218.25,3.94,"A",{"$f":"IF(C6<>\"\",IF(AND(E6=MIN( IF( $F$4:$F$23=F6, $E$4:$E$23)),E6>0),1,0),\"\")","v":0},18]
[null,4,"Shawn G.",213.76,4.048,"A",{"$f":"IF(C7<>\"\",IF(AND(E7=MIN( IF( $F$4:$F$23=F7, $E$4:$E$23)),E7>0),1,0),\"\")","v":0},17]
[null,5,"Stephen B.",203.71,4.0469999999999997,"A",{"$f":"IF(C8<>\"\",IF(AND(E8=MIN( IF( $F$4:$F$23=F8, $E$4:$E$23)),E8>0),1,0),\"\")","v":0},16]
[null,6,"Alejandro G.",202.75,4.157,"A",{"$f":"IF(C9<>\"\",IF(AND(E9=MIN( IF( $F$4:$F$23=F9, $E$4:$E$23)),E9>0),1,0),\"\")","v":0},15]
[null,7,"Randy A.",198.93,4.1539999999999999,"B",{"$f":"IF(C10<>\"\",IF(AND(E10=MIN( IF( $F$4:$F$23=F10, $E$4:$E$23)),E10>0),1,0),\"\")","v":1},15]
[null,8,"Mark L.",188.47,4.1790000000000003,"B",{"$f":"IF(C11<>\"\",IF(AND(E11=MIN( IF( $F$4:$F$23=F11, $E$4:$E$23)),E11>0),1,0),\"\")","v":0},13]
[null,9,"John B.",188.34,4.2489999999999997,"B",{"$f":"IF(C12<>\"\",IF(AND(E12=MIN( IF( $F$4:$F$23=F12, $E$4:$E$23)),E12>0),1,0),\"\")","v":0},12]
[null,10,"Rich C.",183.25,4.4000000000000004,"B",{"$f":"IF(C13<>\"\",IF(AND(E13=MIN( IF( $F$4:$F$23=F13, $E$4:$E$23)),E13>0),1,0),\"\")","v":0},11]
[null,null,null,null,null,"",{"$f":"IF(C14<>\"\",IF(AND(E14=MIN( IF( $F$4:$F$23=F14, $E$4:$E$23)),E14>0),1,0),\"\")","v":""},""]
[null,null,null,null,null,"",{"$f":"IF(C15<>\"\",IF(AND(E15=MIN( IF( $F$4:$F$23=F15, $E$4:$E$23)),E15>0),1,0),\"\")","v":""},""]
[null,null,null,null,null,"",{"$f":"IF(C16<>\"\",IF(AND(E16=MIN( IF( $F$4:$F$23=F16, $E$4:$E$23)),E16>0),1,0),\"\")","v":""},""]
[null,null,null,null,null,"",{"$f":"IF(C17<>\"\",IF(AND(E17=MIN( IF( $F$4:$F$23=F17, $E$4:$E$23)),E17>0),1,0),\"\")","v":""},""]
[null,null,null,null,null,"",{"$f":"IF(C18<>\"\",IF(AND(E18=MIN( IF( $F$4:$F$23=F18, $E$4:$E$23)),E18>0),1,0),\"\")","v":""},""]
[null,null,null,null,null,"",{"$f":"IF(C19<>\"\",IF(AND(E19=MIN( IF( $F$4:$F$23=F19, $E$4:$E$23)),E19>0),1,0),\"\")","v":""},""]
[null,null,null,null,null,"",{"$f":"IF(C20<>\"\",IF(AND(E20=MIN( IF( $F$4:$F$23=F20, $E$4:$E$23)),E20>0),1,0),\"\")","v":""},""]
[null,null,null,null,null,"",{"$f":"IF(C21<>\"\",IF(AND(E21=MIN( IF( $F$4:$F$23=F21, $E$4:$E$23)),E21>0),1,0),\"\")","v":""},""]
[null,null,null,null,null,"",{"$f":"IF(C22<>\"\",IF(AND(E22=MIN( IF( $F$4:$F$23=F22, $E$4:$E$23)),E22>0),1,0),\"\")","v":""},""]
[null,null,null,null,null,"",{"$f":"IF(C23<>\"\",IF(AND(E23=MIN( IF( $F$4:$F$23=F23, $E$4:$E$23)),E23>0),1,0),\"\")","v":""},""]
[]
[null,"Driver","Lane","Slowest Lap Time","Fastest Lap Time","Average Lap Time","Total Laps"]
[null,"Ary B.",1,6.0949999999999998,3.9119999999999999,4.0179999999999998,74.77]
[null,"Ary B.",2,4.7300000000000004,3.871,4.0369999999999999,74]
[null,"Ary B.",3,5.7240000000000002,3.97,4.0599999999999996,74]
[null,"Marty M.",1,4.5720000000000001,3.9580000000000002,4.0389999999999997,74.2]
[null,"Marty M.",2,6.1189999999999998,3.9209999999999998,4.0670000000000002,74]
[null,"Marty M.",3,5.2789999999999999,3.9820000000000002,4.1040000000000001,73]
[null,"David C.",1,7.76,3.94,4.1340000000000003,74.25]
[null,"David C.",2,6.1,3.9460000000000002,4.1340000000000003,72]
[null,"David C.",3,6.4240000000000004,4.0170000000000003,4.1520000000000001,72]
[null,"Shawn G.",1,6.6310000000000002,4.0860000000000003,4.2149999999999999,71.760000000000005]
[null,"Shawn G.",2,8.3119999999999994,4.0709999999999997,4.2210000000000001,71]
[null,"Shawn G.",3,6.2939999999999996,4.048,4.1929999999999996,71]
[null,"Stephen B.",1,8.0150000000000006,4.0469999999999997,4.5149999999999997,67.709999999999994]
[null,"Stephen B.",2,7.3360000000000003,4.0730000000000004,4.3959999999999999,69]
[null,"Stephen B.",3,6.6479999999999997,4.0890000000000004,4.3769999999999998,67]
[null,"Alejandro G.",1,7.5369999999999999,4.157,4.45,67.75]
[null,"Alejandro G.",2,6.3410000000000002,4.1959999999999997,4.423,68]
[null,"Alejandro G.",3,7.0170000000000003,4.1840000000000002,4.4400000000000004,67]
[null,"Randy A.",1,6.9850000000000003,4.1539999999999999,4.4980000000000002,66.930000000000007]
[null,"Randy A.",2,7.7060000000000004,4.1559999999999997,4.3929999999999998,68]
[null,"Randy A.",3,7.548,4.26,4.6920000000000002,64]
[null,"Mark L.",1,7.1360000000000001,4.4989999999999997,4.9619999999999997,60.47]
[null,"Mark L.",2,7.6580000000000004,4.1849999999999996,4.59,65]
[null,"Mark L.",3,6.8239999999999998,4.1790000000000003,4.7830000000000004,63]
[null,"John B.",1,7.5730000000000004,4.2489999999999997,4.806,62.34]
[null,"John B.",2,8.6910000000000007,4.3419999999999996,4.8230000000000004,63]
[null,"John B.",3,7.0819999999999999,4.3319999999999999,4.7770000000000001,63]
[null,"Rich C.",1,8.6430000000000007,4.4000000000000004,4.6760000000000002,65.25]
[null,"Rich C.",2,10.276,4.4930000000000003,5.1349999999999998,59]
[null,"Rich C.",3,8.5980000000000008,4.4790000000000001,5.016,59]

{"sheet":"Round 3","index":3,"n_rows":40,"n_cols":8,"rows_kept":40,"cut":false,"hidden":false,"merged":[[1,1,1,7]]}
[]
[null,{"$f":"SeriesName & \" - Round 3\"","v":"2017 BTCC - Round 3"}]
[null,"Position","Driver","Laps","Fastest Lap","Group","Fastest Lap Bonus","Points"]
[null,1,"Marty M.",220.33,3.931,{"$f":"IF(ISNA(VLOOKUP(C4,SeriesSummary,Group,FALSE)),\"\",VLOOKUP(C4,SeriesSummary,Group,FALSE))","v":"A"},{"$f":"IF(C4<>\"\",IF(AND(E4=MIN( IF( $F$4:$F$23=F4, $E$4:$E$23)),E4>0),1,0),\"\")","v":1},{"$f":"IF(ISNA(VLOOKUP(B4,Points,2,FALSE)),\"\",VLOOKUP(B4,Points,2,FALSE)+G4)","v":21}]
[null,2,"Ary B.",217.46,3.9390000000000001,"A",{"$f":"IF(C5<>\"\",IF(AND(E5=MIN( IF( $F$4:$F$23=F5, $E$4:$E$23)),E5>0),1,0),\"\")","v":0},19]
[null,3,"David C.",213.73,3.9969999999999999,"A",{"$f":"IF(C6<>\"\",IF(AND(E6=MIN( IF( $F$4:$F$23=F6, $E$4:$E$23)),E6>0),1,0),\"\")","v":0},18]
[null,4,"Mark L.",197.74,4.2590000000000003,"B",{"$f":"IF(C7<>\"\",IF(AND(E7=MIN( IF( $F$4:$F$23=F7, $E$4:$E$23)),E7>0),1,0),\"\")","v":1},18]
[null,5,"John B.",187.23,4.3319999999999999,"B",{"$f":"IF(C8<>\"\",IF(AND(E8=MIN( IF( $F$4:$F$23=F8, $E$4:$E$23)),E8>0),1,0),\"\")","v":0},16]
[null,null,null,null,null,"",{"$f":"IF(C9<>\"\",IF(AND(E9=MIN( IF( $F$4:$F$23=F9, $E$4:$E$23)),E9>0),1,0),\"\")","v":""},""]
[null,null,null,null,null,"",{"$f":"IF(C10<>\"\",IF(AND(E10=MIN( IF( $F$4:$F$23=F10, $E$4:$E$23)),E10>0),1,0),\"\")","v":""},""]
[null,null,null,null,null,"",{"$f":"IF(C11<>\"\",IF(AND(E11=MIN( IF( $F$4:$F$23=F11, $E$4:$E$23)),E11>0),1,0),\"\")","v":""},""]
[null,null,null,null,null,"",{"$f":"IF(C12<>\"\",IF(AND(E12=MIN( IF( $F$4:$F$23=F12, $E$4:$E$23)),E12>0),1,0),\"\")","v":""},""]
[null,null,null,null,null,"",{"$f":"IF(C13<>\"\",IF(AND(E13=MIN( IF( $F$4:$F$23=F13, $E$4:$E$23)),E13>0),1,0),\"\")","v":""},""]
[null,null,null,null,null,"",{"$f":"IF(C14<>\"\",IF(AND(E14=MIN( IF( $F$4:$F$23=F14, $E$4:$E$23)),E14>0),1,0),\"\")","v":""},""]
[null,null,null,null,null,"",{"$f":"IF(C15<>\"\",IF(AND(E15=MIN( IF( $F$4:$F$23=F15, $E$4:$E$23)),E15>0),1,0),\"\")","v":""},""]
[null,null,null,null,null,"",{"$f":"IF(C16<>\"\",IF(AND(E16=MIN( IF( $F$4:$F$23=F16, $E$4:$E$23)),E16>0),1,0),\"\")","v":""},""]
[null,null,null,null,null,"",{"$f":"IF(C17<>\"\",IF(AND(E17=MIN( IF( $F$4:$F$23=F17, $E$4:$E$23)),E17>0),1,0),\"\")","v":""},""]
[null,null,null,null,null,"",{"$f":"IF(C18<>\"\",IF(AND(E18=MIN( IF( $F$4:$F$23=F18, $E$4:$E$23)),E18>0),1,0),\"\")","v":""},""]
[null,null,null,null,null,"",{"$f":"IF(C19<>\"\",IF(AND(E19=MIN( IF( $F$4:$F$23=F19, $E$4:$E$23)),E19>0),1,0),\"\")","v":""},""]
[null,null,null,null,null,"",{"$f":"IF(C20<>\"\",IF(AND(E20=MIN( IF( $F$4:$F$23=F20, $E$4:$E$23)),E20>0),1,0),\"\")","v":""},""]
[null,null,null,null,null,"",{"$f":"IF(C21<>\"\",IF(AND(E21=MIN( IF( $F$4:$F$23=F21, $E$4:$E$23)),E21>0),1,0),\"\")","v":""},""]
[null,null,null,null,null,"",{"$f":"IF(C22<>\"\",IF(AND(E22=MIN( IF( $F$4:$F$23=F22, $E$4:$E$23)),E22>0),1,0),\"\")","v":""},""]
[null,null,null,null,null,"",{"$f":"IF(C23<>\"\",IF(AND(E23=MIN( IF( $F$4:$F$23=F23, $E$4:$E$23)),E23>0),1,0),\"\")","v":""},""]
[]
[null,"Driver","Lane","Slowest Lap Time","Fastest Lap Time","Average Lap Time","Total Laps"]
[null,"Marty M.",1,5.7329999999999997,3.9529999999999998,4.0780000000000003,73.33]
[null,"Marty M.",2,5.5529999999999999,3.9540000000000002,4.0759999999999996,74]
[null,"Marty M.",3,6.7450000000000001,3.931,4.0970000000000004,73]
[null,"Ary B.",1,4.774,3.9390000000000001,4.0369999999999999,74.459999999999994]
[null,"Ary B.",2,6.3739999999999997,4.0430000000000001,4.2149999999999999,71]
[null,"Ary B.",3,5.5270000000000001,4.0330000000000004,4.1609999999999996,72]
[null,"David C.",1,8.2769999999999992,3.9969999999999999,4.2460000000000004,70]
[null,"David C.",2,5.1609999999999996,4.048,4.1879999999999997,71.73]
[null,"David C.",3,4.4660000000000002,4.0369999999999999,4.1989999999999998,72]
[null,"Mark L.",1,7.39,4.3109999999999999,4.5720000000000001,65.739999999999995]
[null,"Mark L.",2,7.5419999999999998,4.2649999999999997,4.5750000000000002,65]
[null,"Mark L.",3,6.3250000000000002,4.2590000000000003,4.5,67]
[null,"John B.",1,7.2389999999999999,4.4139999999999997,4.9390000000000001,61]
[null,"John B.",2,9.5169999999999995,4.4619999999999997,4.7469999999999999,63]
[null,"John B.",3,8.6709999999999994,4.3319999999999999,4.7469999999999999,63.23]

{"sheet":"Round 4","index":4,"n_rows":25,"n_cols":8,"rows_kept":25,"cut":false,"hidden":false,"merged":[[1,1,1,7]]}
[]
[null,{"$f":"SeriesName & \" - Round 4\"","v":"2017 BTCC - Round 4"}]
[null,"Position","Driver","Laps","Fastest Lap","Group","Fastest Lap Bonus","Points"]
[null,null,null,null,null,{"$f":"IF(ISNA(VLOOKUP(C4,SeriesSummary,Group,FALSE)),\"\",VLOOKUP(C4,SeriesSummary,Group,FALSE))","v":""},{"$f":"IF(C4<>\"\",IF(AND(E4=MIN( IF( $F$4:$F$23=F4, $E$4:$E$23)),E4>0),1,0),\"\")","v":""},{"$f":"IF(ISNA(VLOOKUP(B4,Points,2,FALSE)),\"\",VLOOKUP(B4,Points,2,FALSE)+G4)","v":""}]
[null,null,null,null,null,"",{"$f":"IF(C5<>\"\",IF(AND(E5=MIN( IF( $F$4:$F$23=F5, $E$4:$E$23)),E5>0),1,0),\"\")","v":""},""]
[null,null,null,null,null,"",{"$f":"IF(C6<>\"\",IF(AND(E6=MIN( IF( $F$4:$F$23=F6, $E$4:$E$23)),E6>0),1,0),\"\")","v":""},""]
[null,null,null,null,null,"",{"$f":"IF(C7<>\"\",IF(AND(E7=MIN( IF( $F$4:$F$23=F7, $E$4:$E$23)),E7>0),1,0),\"\")","v":""},""]
[null,null,null,null,null,"",{"$f":"IF(C8<>\"\",IF(AND(E8=MIN( IF( $F$4:$F$23=F8, $E$4:$E$23)),E8>0),1,0),\"\")","v":""},""]
[null,null,null,null,null,"",{"$f":"IF(C9<>\"\",IF(AND(E9=MIN( IF( $F$4:$F$23=F9, $E$4:$E$23)),E9>0),1,0),\"\")","v":""},""]
[null,null,null,null,null,"",{"$f":"IF(C10<>\"\",IF(AND(E10=MIN( IF( $F$4:$F$23=F10, $E$4:$E$23)),E10>0),1,0),\"\")","v":""},""]
[null,null,null,null,null,"",{"$f":"IF(C11<>\"\",IF(AND(E11=MIN( IF( $F$4:$F$23=F11, $E$4:$E$23)),E11>0),1,0),\"\")","v":""},""]
[null,null,null,null,null,"",{"$f":"IF(C12<>\"\",IF(AND(E12=MIN( IF( $F$4:$F$23=F12, $E$4:$E$23)),E12>0),1,0),\"\")","v":""},""]
[null,null,null,null,null,"",{"$f":"IF(C13<>\"\",IF(AND(E13=MIN( IF( $F$4:$F$23=F13, $E$4:$E$23)),E13>0),1,0),\"\")","v":""},""]
[null,null,null,null,null,"",{"$f":"IF(C14<>\"\",IF(AND(E14=MIN( IF( $F$4:$F$23=F14, $E$4:$E$23)),E14>0),1,0),\"\")","v":""},""]
[null,null,null,null,null,"",{"$f":"IF(C15<>\"\",IF(AND(E15=MIN( IF( $F$4:$F$23=F15, $E$4:$E$23)),E15>0),1,0),\"\")","v":""},""]
[null,null,null,null,null,"",{"$f":"IF(C16<>\"\",IF(AND(E16=MIN( IF( $F$4:$F$23=F16, $E$4:$E$23)),E16>0),1,0),\"\")","v":""},""]
[null,null,null,null,null,"",{"$f":"IF(C17<>\"\",IF(AND(E17=MIN( IF( $F$4:$F$23=F17, $E$4:$E$23)),E17>0),1,0),\"\")","v":""},""]
[null,null,null,null,null,"",{"$f":"IF(C18<>\"\",IF(AND(E18=MIN( IF( $F$4:$F$23=F18, $E$4:$E$23)),E18>0),1,0),\"\")","v":""},""]
[null,null,null,null,null,"",{"$f":"IF(C19<>\"\",IF(AND(E19=MIN( IF( $F$4:$F$23=F19, $E$4:$E$23)),E19>0),1,0),\"\")","v":""},""]
[null,null,null,null,null,"",{"$f":"IF(C20<>\"\",IF(AND(E20=MIN( IF( $F$4:$F$23=F20, $E$4:$E$23)),E20>0),1,0),\"\")","v":""},""]
[null,null,null,null,null,"",{"$f":"IF(C21<>\"\",IF(AND(E21=MIN( IF( $F$4:$F$23=F21, $E$4:$E$23)),E21>0),1,0),\"\")","v":""},""]
[null,null,null,null,null,"",{"$f":"IF(C22<>\"\",IF(AND(E22=MIN( IF( $F$4:$F$23=F22, $E$4:$E$23)),E22>0),1,0),\"\")","v":""},""]
[null,null,null,null,null,"",{"$f":"IF(C23<>\"\",IF(AND(E23=MIN( IF( $F$4:$F$23=F23, $E$4:$E$23)),E23>0),1,0),\"\")","v":""},""]
[]
[null,"Driver","Lane","Slowest Lap Time","Fastest Lap Time","Average Lap Time","Total Laps"]

{"sheet":"Round 5","index":5,"n_rows":25,"n_cols":8,"rows_kept":25,"cut":false,"hidden":false,"merged":[[1,1,1,7]]}
[]
[null,{"$f":"SeriesName & \" - Round 5\"","v":"2017 BTCC - Round 5"}]
[null,"Position","Driver","Laps","Fastest Lap","Group","Fastest Lap Bonus","Points"]
[null,null,null,null,null,{"$f":"IF(ISNA(VLOOKUP(C4,SeriesSummary,Group,FALSE)),\"\",VLOOKUP(C4,SeriesSummary,Group,FALSE))","v":""},{"$f":"IF(C4<>\"\",IF(AND(E4=MIN( IF( $F$4:$F$23=F4, $E$4:$E$23)),E4>0),1,0),\"\")","v":""},{"$f":"IF(ISNA(VLOOKUP(B4,Points,2,FALSE)),\"\",VLOOKUP(B4,Points,2,FALSE)+G4)","v":""}]
[null,null,null,null,null,"",{"$f":"IF(C5<>\"\",IF(AND(E5=MIN( IF( $F$4:$F$23=F5, $E$4:$E$23)),E5>0),1,0),\"\")","v":""},""]
[null,null,null,null,null,"",{"$f":"IF(C6<>\"\",IF(AND(E6=MIN( IF( $F$4:$F$23=F6, $E$4:$E$23)),E6>0),1,0),\"\")","v":""},""]
[null,null,null,null,null,"",{"$f":"IF(C7<>\"\",IF(AND(E7=MIN( IF( $F$4:$F$23=F7, $E$4:$E$23)),E7>0),1,0),\"\")","v":""},""]
[null,null,null,null,null,"",{"$f":"IF(C8<>\"\",IF(AND(E8=MIN( IF( $F$4:$F$23=F8, $E$4:$E$23)),E8>0),1,0),\"\")","v":""},""]
[null,null,null,null,null,"",{"$f":"IF(C9<>\"\",IF(AND(E9=MIN( IF( $F$4:$F$23=F9, $E$4:$E$23)),E9>0),1,0),\"\")","v":""},""]
[null,null,null,null,null,"",{"$f":"IF(C10<>\"\",IF(AND(E10=MIN( IF( $F$4:$F$23=F10, $E$4:$E$23)),E10>0),1,0),\"\")","v":""},""]
[null,null,null,null,null,"",{"$f":"IF(C11<>\"\",IF(AND(E11=MIN( IF( $F$4:$F$23=F11, $E$4:$E$23)),E11>0),1,0),\"\")","v":""},""]
[null,null,null,null,null,"",{"$f":"IF(C12<>\"\",IF(AND(E12=MIN( IF( $F$4:$F$23=F12, $E$4:$E$23)),E12>0),1,0),\"\")","v":""},""]
[null,null,null,null,null,"",{"$f":"IF(C13<>\"\",IF(AND(E13=MIN( IF( $F$4:$F$23=F13, $E$4:$E$23)),E13>0),1,0),\"\")","v":""},""]
[null,null,null,null,null,"",{"$f":"IF(C14<>\"\",IF(AND(E14=MIN( IF( $F$4:$F$23=F14, $E$4:$E$23)),E14>0),1,0),\"\")","v":""},""]
[null,null,null,null,null,"",{"$f":"IF(C15<>\"\",IF(AND(E15=MIN( IF( $F$4:$F$23=F15, $E$4:$E$23)),E15>0),1,0),\"\")","v":""},""]
[null,null,null,null,null,"",{"$f":"IF(C16<>\"\",IF(AND(E16=MIN( IF( $F$4:$F$23=F16, $E$4:$E$23)),E16>0),1,0),\"\")","v":""},""]
[null,null,null,null,null,"",{"$f":"IF(C17<>\"\",IF(AND(E17=MIN( IF( $F$4:$F$23=F17, $E$4:$E$23)),E17>0),1,0),\"\")","v":""},""]
[null,null,null,null,null,"",{"$f":"IF(C18<>\"\",IF(AND(E18=MIN( IF( $F$4:$F$23=F18, $E$4:$E$23)),E18>0),1,0),\"\")","v":""},""]
[null,null,null,null,null,"",{"$f":"IF(C19<>\"\",IF(AND(E19=MIN( IF( $F$4:$F$23=F19, $E$4:$E$23)),E19>0),1,0),\"\")","v":""},""]
[null,null,null,null,null,"",{"$f":"IF(C20<>\"\",IF(AND(E20=MIN( IF( $F$4:$F$23=F20, $E$4:$E$23)),E20>0),1,0),\"\")","v":""},""]
[null,null,null,null,null,"",{"$f":"IF(C21<>\"\",IF(AND(E21=MIN( IF( $F$4:$F$23=F21, $E$4:$E$23)),E21>0),1,0),\"\")","v":""},""]
[null,null,null,null,null,"",{"$f":"IF(C22<>\"\",IF(AND(E22=MIN( IF( $F$4:$F$23=F22, $E$4:$E$23)),E22>0),1,0),\"\")","v":""},""]
[null,null,null,null,null,"",{"$f":"IF(C23<>\"\",IF(AND(E23=MIN( IF( $F$4:$F$23=F23, $E$4:$E$23)),E23>0),1,0),\"\")","v":""},""]
[]
[null,"Driver","Lane","Slowest Lap Time","Fastest Lap Time","Average Lap Time","Total Laps"]

{"sheet":"Round 6","index":6,"n_rows":25,"n_cols":8,"rows_kept":25,"cut":false,"hidden":false,"merged":[[1,1,1,7]]}
[]
[null,{"$f":"SeriesName & \" - Round 6\"","v":"2017 BTCC - Round 6"}]
[null,"Position","Driver","Laps","Fastest Lap","Group","Fastest Lap Bonus","Points"]
[null,null,null,null,null,{"$f":"IF(ISNA(VLOOKUP(C4,SeriesSummary,Group,FALSE)),\"\",VLOOKUP(C4,SeriesSummary,Group,FALSE))","v":""},{"$f":"IF(C4<>\"\",IF(AND(E4=MIN( IF( $F$4:$F$23=F4, $E$4:$E$23)),E4>0),1,0),\"\")","v":""},{"$f":"IF(ISNA(VLOOKUP(B4,Points,2,FALSE)),\"\",VLOOKUP(B4,Points,2,FALSE)+G4)","v":""}]
[null,null,null,null,null,"",{"$f":"IF(C5<>\"\",IF(AND(E5=MIN( IF( $F$4:$F$23=F5, $E$4:$E$23)),E5>0),1,0),\"\")","v":""},""]
[null,null,null,null,null,"",{"$f":"IF(C6<>\"\",IF(AND(E6=MIN( IF( $F$4:$F$23=F6, $E$4:$E$23)),E6>0),1,0),\"\")","v":""},""]
[null,null,null,null,null,"",{"$f":"IF(C7<>\"\",IF(AND(E7=MIN( IF( $F$4:$F$23=F7, $E$4:$E$23)),E7>0),1,0),\"\")","v":""},""]
[null,null,null,null,null,"",{"$f":"IF(C8<>\"\",IF(AND(E8=MIN( IF( $F$4:$F$23=F8, $E$4:$E$23)),E8>0),1,0),\"\")","v":""},""]
[null,null,null,null,null,"",{"$f":"IF(C9<>\"\",IF(AND(E9=MIN( IF( $F$4:$F$23=F9, $E$4:$E$23)),E9>0),1,0),\"\")","v":""},""]
[null,null,null,null,null,"",{"$f":"IF(C10<>\"\",IF(AND(E10=MIN( IF( $F$4:$F$23=F10, $E$4:$E$23)),E10>0),1,0),\"\")","v":""},""]
[null,null,null,null,null,"",{"$f":"IF(C11<>\"\",IF(AND(E11=MIN( IF( $F$4:$F$23=F11, $E$4:$E$23)),E11>0),1,0),\"\")","v":""},""]
[null,null,null,null,null,"",{"$f":"IF(C12<>\"\",IF(AND(E12=MIN( IF( $F$4:$F$23=F12, $E$4:$E$23)),E12>0),1,0),\"\")","v":""},""]
[null,null,null,null,null,"",{"$f":"IF(C13<>\"\",IF(AND(E13=MIN( IF( $F$4:$F$23=F13, $E$4:$E$23)),E13>0),1,0),\"\")","v":""},""]
[null,null,null,null,null,"",{"$f":"IF(C14<>\"\",IF(AND(E14=MIN( IF( $F$4:$F$23=F14, $E$4:$E$23)),E14>0),1,0),\"\")","v":""},""]
[null,null,null,null,null,"",{"$f":"IF(C15<>\"\",IF(AND(E15=MIN( IF( $F$4:$F$23=F15, $E$4:$E$23)),E15>0),1,0),\"\")","v":""},""]
[null,null,null,null,null,"",{"$f":"IF(C16<>\"\",IF(AND(E16=MIN( IF( $F$4:$F$23=F16, $E$4:$E$23)),E16>0),1,0),\"\")","v":""},""]
[null,null,null,null,null,"",{"$f":"IF(C17<>\"\",IF(AND(E17=MIN( IF( $F$4:$F$23=F17, $E$4:$E$23)),E17>0),1,0),\"\")","v":""},""]
[null,null,null,null,null,"",{"$f":"IF(C18<>\"\",IF(AND(E18=MIN( IF( $F$4:$F$23=F18, $E$4:$E$23)),E18>0),1,0),\"\")","v":""},""]
[null,null,null,null,null,"",{"$f":"IF(C19<>\"\",IF(AND(E19=MIN( IF( $F$4:$F$23=F19, $E$4:$E$23)),E19>0),1,0),\"\")","v":""},""]
[null,null,null,null,null,"",{"$f":"IF(C20<>\"\",IF(AND(E20=MIN( IF( $F$4:$F$23=F20, $E$4:$E$23)),E20>0),1,0),\"\")","v":""},""]
[null,null,null,null,null,"",{"$f":"IF(C21<>\"\",IF(AND(E21=MIN( IF( $F$4:$F$23=F21, $E$4:$E$23)),E21>0),1,0),\"\")","v":""},""]
[null,null,null,null,null,"",{"$f":"IF(C22<>\"\",IF(AND(E22=MIN( IF( $F$4:$F$23=F22, $E$4:$E$23)),E22>0),1,0),\"\")","v":""},""]
[null,null,null,null,null,"",{"$f":"IF(C23<>\"\",IF(AND(E23=MIN( IF( $F$4:$F$23=F23, $E$4:$E$23)),E23>0),1,0),\"\")","v":""},""]
[]
[null,"Driver","Lane","Slowest Lap Time","Fastest Lap Time","Average Lap Time","Total Laps"]

{"sheet":"SumSheet","index":7,"n_rows":64,"n_cols":80,"rows_kept":64,"cut":false,"hidden":false,"merged":[[6,53,6,63],[6,64,6,67],[6,68,6,71],[6,72,6,79],[42,1,42,2],[6,1,7,1],[6,3,6,8],[6,9,6,19],[6,20,6,30],[6,31,6,41],[6,42,6,52],[6,2,7,2]]}
[]
[]
[]
[]
[]
[null,1,{"$f":"B6+1","v":2},{"$f":"C6+1","v":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,65,66,{"$f":"BO6+1","v":67},68,69,70,71,72,73,74,75,76,77,78,79]
[null,"Racer","Group","Round 1",null,null,null,null,null,"Round 2",null,null,null,null,null,null,null,null,null,null,"Round 3",null,null,null,null,null,null,null,null,null,null,"Round 4",null,null,null,null,null,null,null,null,null,null,"Round 5",null,null,null,null,null,null,null,null,null,null,"Round 6",null,null,null,null,null,null,null,null,null,null,"Total",null,null,null,"Dropped Round",null,null,null,"Final Classification"]
[null,null,null,"Laps","Points","Fastest Lap","Total Round Points","Class Rank","Rank","Laps","Points","Fastest Lap","Total Round Points","Running Series Points","Class Rank","Running Class Rank","Change in Class Rank","Overall Rank","Running Overall Rank","Change in Overall Rank","Laps","Points","Fastest Lap","Total Round Points","Running Series Points","Class Rank","Running Class Rank","Change in Class Rank","Overall Rank","Running Overall Rank","Change in Overall Rank","Laps","Points","Fastest Lap","Total Round Points","Running Series Points","Class Rank","Running Class Rank","Change in Class Rank","Overall Rank","Running Overall Rank","Change in Overall Rank","Laps","Points","Fastest Lap","Total Round Points","Running Series Points","Class Rank","Running Class Rank","Change in Class Rank","Overall Rank","Running Overall Rank","Change in Overall Rank","Laps","Points","Fastest Lap","Total Round Points","Running Series Points","Class Rank","Running Class Rank","Change in Class Rank","Overall Rank","Running Overall Rank","Change in Overall Rank","Rounds Run","Points","Fastest Laps","Laps","Round","Points","Fastest Laps","Laps","Points","Fastest Laps","Total Points","Laps","Class Rank","Change in Class Rank","Overall Rank","Change in Overall Rank"]
[null,"Alejandro G.","A",{"$f":"IF(ISNA(VLOOKUP($B9,Round1Results,2,FALSE)),0,VLOOKUP($B9,Round1Results,2,FALSE))","v":0},{"$f":"IF(ISNA(VLOOKUP($B9,Round1Results,6,FALSE)),0,VLOOKUP($B9,Round1Results,6,FALSE)-F9)","v":0},{"$f":"IF(ISNA(VLOOKUP($B9,Round1Results,5,FALSE)),0,VLOOKUP($B9,Round1Results,5,FALSE))","v":0},{"$f":"SUM(E9:F9)","v":0},{"$f":"IF($BP9>0,SUMPRODUCT(--(C9=C$9:C$38),--(G9<(G$9:G$38)))+1,0)","v":6},{"$f":"IF($BP9>0,RANK(G9,G$9:G$38),0)","v":9},{"$f":"IF(ISNA(VLOOKUP($B9,Round2Results,2,FALSE)),0,VLOOKUP($B9,Round2Results,2,FALSE))","v":202.75},{"$f":"IF(ISNA(VLOOKUP($B9,Round2Results,6,FALSE)),0,VLOOKUP($B9,Round2Results,6,FALSE)-L9)","v":15},{"$f":"IF(ISNA(VLOOKUP($B9,Round2Results,5,FALSE)),0,VLOOKUP($B9,Round2Results,5,FALSE))","v":0},{"$f":"SUM(K9:L9)","v":15},{"$f":"G9+M9","v":15},{"$f":"IF(J9>0,SUMPRODUCT(--($C9=$C$9:$C$38),--(M9<(M$9:M$38)))+1,0)","v":6},{"$f":"IF($BP9>0,SUMPRODUCT(--($C9=$C$9:$C$38),--(N9<(N$9:N$38)))+1,0)","v":6},{"$f":"IF(H9=0,0,H9-P9)","v":0},{"$f":"IF(J9>0,RANK(M9,M$9:M$38),0)","v":6},{"$f":"IF($BP9>0,RANK(N9,N$9:N$38),0)","v":9},{"$f":"IF(I9=0,0,I9-S9)","v":0},{"$f":"IF(ISNA(VLOOKUP($B9,Round3Results,2,FALSE)),0,VLOOKUP($B9,Round3Results,2,FALSE))","v":0},{"$f":"IF(ISNA(VLOOKUP($B9,Round3Results,6,FALSE)),0,VLOOKUP($B9,Round3Results,6,FALSE)-W9)","v":0},{"$f":"IF(ISNA(VLOOKUP($B9,Round3Results,5,FALSE)),0,VLOOKUP($B9,Round3Results,5,FALSE))","v":0},{"$f":"SUM(V9:W9)","v":0},{"$f":"N9+X9","v":15},{"$f":"IF(U9>0,SUMPRODUCT(--($C9=$C$9:$C$38),--(X9<(X$9:X$38)))+1,0)","v":0},{"$f":"IF($BP9>0,SUMPRODUCT(--($C9=$C$9:$C$38),--(Y9<(Y$9:Y$38)))+1,0)","v":6},{"$f":"IF(P9=0,0,P9-AA9)","v":0},{"$f":"IF(U9>0,RANK(X9,X$9:X$38),0)","v":0},{"$f":"IF($BP9>0,RANK(Y9,Y$9:Y$38),0)","v":9},{"$f":"IF(S9=0,0,S9-AD9)","v":0},{"$f":"IF(ISNA(VLOOKUP($B9,Round4Results,2,FALSE)),0,VLOOKUP($B9,Round4Results,2,FALSE))","v":0},{"$f":"IF(ISNA(VLOOKUP($B9,Round4Results,6,FALSE)),0,VLOOKUP($B9,Round4Results,6,FALSE)-AH9)","v":0},{"$f":"IF(ISNA(VLOOKUP($B9,Round4Results,5,FALSE)),0,VLOOKUP($B9,Round4Results,5,FALSE))","v":0},{"$f":"SUM(AG9:AH9)","v":0},{"$f":"Y9+AI9","v":15},{"$f":"IF(AF9>0,SUMPRODUCT(--($C9=$C$9:$C$38),--(AI9<(AI$9:AI$38)))+1,0)","v":0},{"$f":"IF($BP9>0,SUMPRODUCT(--($C9=$C$9:$C$38),--(AJ9<(AJ$9:AJ$38)))+1,0)","v":6},{"$f":"IF(AA9=0,0,AA9-AL9)","v":0},{"$f":"IF(AF9>0,RANK(AI9,AI$9:AI$38),0)","v":0},{"$f":"IF($BP9>0,RANK(AJ9,AJ$9:AJ$38),0)","v":9},{"$f":"IF(AD9=0,0,AD9-AO9)","v":0},{"$f":"IF(ISNA(VLOOKUP($B9,Round5Results,2,FALSE)),0,VLOOKUP($B9,Round5Results,2,FALSE))","v":0},{"$f":"IF(ISNA(VLOOKUP($B9,Round5Results,6,FALSE)),0,VLOOKUP($B9,Round5Results,6,FALSE)-AS9)","v":0},{"$f":"IF(ISNA(VLOOKUP($B9,Round5Results,5,FALSE)),0,VLOOKUP($B9,Round5Results,5,FALSE))","v":0},{"$f":"SUM(AR9:AS9)","v":0},{"$f":"AJ9+AT9","v":15},{"$f":"IF(AQ9>0,SUMPRODUCT(--($C9=$C$9:$C$38),--(AT9<(AT$9:AT$38)))+1,0)","v":0},{"$f":"IF($BP9>0,SUMPRODUCT(--($C9=$C$9:$C$38),--(AU9<(AU$9:AU$38)))+1,0)","v":6},{"$f":"IF(AL9=0,0,AL9-AW9)","v":0},{"$f":"IF(AQ9>0,RANK(AT9,AT$9:AT$38),0)","v":0},{"$f":"IF($BP9>0,RANK(AU9,AU$9:AU$38),0)","v":9},{"$f":"IF(AO9=0,0,AO9-AZ9)","v":0},{"$f":"IF(ISNA(VLOOKUP($B9,Round6Results,2,FALSE)),0,VLOOKUP($B9,Round6Results,2,FALSE))","v":0},{"$f":"IF(ISNA(VLOOKUP($B9,Round6Results,6,FALSE)),0,VLOOKUP($B9,Round6Results,6,FALSE)-BD9)","v":0},{"$f":"IF(ISNA(VLOOKUP($B9,Round6Results,5,FALSE)),0,VLOOKUP($B9,Round6Results,5,FALSE))","v":0},{"$f":"SUM(BC9:BD9)","v":0},{"$f":"AU9+BE9","v":15},{"$f":"IF(BB9>0,SUMPRODUCT(--($C9=$C$9:$C$38),--(BE9<(BE$9:BE$38)))+1,0)","v":0},{"$f":"IF($BP9>0,SUMPRODUCT(--($C9=$C$9:$C$38),--(BF9<(BF$9:BF$38)))+1,0)","v":6},{"$f":"IF(AW9=0,0,AW9-BH9)","v":0},{"$f":"IF(BB9>0,RANK(BE9,BE$9:BE$38),0)","v":0},{"$f":"IF($BP9>0,RANK(BF9,BF$9:BF$38),0)","v":9},{"$f":"IF(AZ9=0,0,AZ9-BK9)","v":0},{"$f":"COUNTIF(D9,\">0\")+COUNTIF(J9,\">0\")+COUNTIF(U9,\">0\")+COUNTIF(AF9,\">0\")+COUNTIF(AQ9,\">0\")+COUNTIF(BB9,\">0\")","v":1},{"$f":"E9+K9+V9+AG9+AR9+BC9","v":15},0,{"$f":"D9+J9+U9+AF9+AQ9+BB9","v":202.75},null,{"$f":"IF($BQ9=1,E9,IF($BQ9=2,K9,IF($BQ9=3,V9,IF($BQ9=4,AG9,IF($BQ9=5,AR9,IF($BQ9=6,BC9,0))))))","v":0},{"$f":"IF($BQ9=1,F9,IF($BQ9=2,L9,IF($BQ9=3,W9,IF($BQ9=4,AH9,IF($BQ9=5,AS9,IF($BQ9=6,BD9,0))))))","v":0},{"$f":"IF($BQ$9=1,D9,IF($BQ9=2,J9,IF($BQ9=3,U9,IF($BQ9=4,AF9,IF($BQ9=5,AP9,IF($BQ9=6,BB9,0))))))","v":0},{"$f":"E9+K9+V9+AG9+AR9+BC9-BR9","v":15},0,{"$f":"BU9+BV9","v":15},{"$f":"D9+J9+U9+AF9+AQ9+BB9-BT9","v":202.75},{"$f":"IF($BW9>0,(SUMPRODUCT(($C9=Group_Range)*($BW9<(Total_Point_Range)))+1)+SUMPRODUCT(($C9=Group_Range)*(Total_Point_Range=$BW9)*(Total_Lap_Range>$BX9)),0)","v":6},{"$f":"IF(AND(B9<>\"\",RoundsRun>1),IF(IF(RoundsRun=2,VLOOKUP(B9,SeriesSummary,Round2ClassRankChange,FALSE),IF(RoundsRun=3,VLOOKUP(B9,SeriesSummary,Round3ClassRankChange,FALSE),IF(RoundsRun=4,VLOOKUP(B9,SeriesSummary,Round4ClassRankChange,FALSE),IF(RoundsRun=5,VLOOKUP(B9,SeriesSummary,Round5ClassRankChange,FALSE),IF(RoundsRun=6,VLOOKUP(B9,SeriesSummary,Round6ClassRankChange,FALSE),\"-\")))))>0,\"+\"&IF(RoundsRun=2,VLOOKUP(B9,SeriesSummary,Round2ClassRankChange,FALSE),IF(RoundsRun=3,VLOOKUP(B9,SeriesSummary,Round3ClassRankChange,FALSE),IF(RoundsRun=4,VLOOKUP(B9,SeriesSummary,Round4ClassRankChange,FALSE),IF(RoundsRun=5,VLOOKUP(B9,SeriesSummary,Round5ClassRankChange,FALSE),IF(RoundsRun=6,VLOOKUP(B9,SeriesSummary,Round6ClassRankChange,FALSE),\"-\"))))),IF((IF(RoundsRun=2,VLOOKUP(B9,SeriesSummary,Round2ClassRankChange,FALSE),IF(RoundsRun=3,VLOOKUP(B9,SeriesSummary,Round3ClassRankChange,FALSE),IF(RoundsRun=4,VLOOKUP(B9,SeriesSummary,Round4ClassRankChange,FALSE),IF(RoundsRun=5,VLOOKUP(B9,SeriesSummary,Round5ClassRankChange,FALSE),IF(RoundsRun=6,VLOOKUP(B9,SeriesSummary,Round6ClassRankChange,FALSE),\"-\"))))))=0,\"-\",(IF(RoundsRun=2,VLOOKUP(B9,SeriesSummary,Round2ClassRankChange,FALSE),IF(RoundsRun=3,VLOOKUP(B9,SeriesSummary,Round3ClassRankChange,FALSE),IF(RoundsRun=4,VLOOKUP(B9,SeriesSummary,Round4ClassRankChange,FALSE),IF(RoundsRun=5,VLOOKUP(B9,SeriesSummary,Round5ClassRankChange,FALSE),IF(RoundsRun=6,VLOOKUP(B9,SeriesSummary,Round6ClassRankChange,FALSE),\"-\")))))))),\"-\")","v":"-"},{"$f":"IF(BM9>0,RANK(BW9,Total_Point_Range)+SUMPRODUCT((Total_Point_Range=BW9)*(Total_Lap_Range>BX9)),0)","v":9},{"$f":"IF(AND(B9<>\"\",RoundsRun>1),IF(IF(RoundsRun=2,VLOOKUP(B9,SeriesSummary,Round2RankChange,FALSE),IF(RoundsRun=3,VLOOKUP(B9,SeriesSummary,Round3RankChange,FALSE),IF(RoundsRun=4,VLOOKUP(B9,SeriesSummary,Round4RankChange,FALSE),IF(RoundsRun=5,VLOOKUP(B9,SeriesSummary,Round5RankChange,FALSE),IF(RoundsRun=6,VLOOKUP(B9,SeriesSummary,Round6RankChange,FALSE),\"-\")))))>0,\"+\"&IF(RoundsRun=2,VLOOKUP(B9,SeriesSummary,Round2RankChange,FALSE),IF(RoundsRun=3,VLOOKUP(B9,SeriesSummary,Round3RankChange,FALSE),IF(RoundsRun=4,VLOOKUP(B9,SeriesSummary,Round4RankChange,FALSE),IF(RoundsRun=5,VLOOKUP(B9,SeriesSummary,Round5RankChange,FALSE),IF(RoundsRun=6,VLOOKUP(B9,SeriesSummary,Round6RankChange,FALSE),\"-\"))))),IF((IF(RoundsRun=2,VLOOKUP(B9,SeriesSummary,Round2RankChange,FALSE),IF(RoundsRun=3,VLOOKUP(B9,SeriesSummary,Round3RankChange,FALSE),IF(RoundsRun=4,VLOOKUP(B9,SeriesSummary,Round4RankChange,FALSE),IF(RoundsRun=5,VLOOKUP(B9,SeriesSummary,Round5RankChange,FALSE),IF(RoundsRun=6,VLOOKUP(B9,SeriesSummary,Round6RankChange,FALSE),\"-\"))))))=0,\"-\",(IF(RoundsRun=2,VLOOKUP(B9,SeriesSummary,Round2RankChange,FALSE),IF(RoundsRun=3,VLOOKUP(B9,SeriesSummary,Round3RankChange,FALSE),IF(RoundsRun=4,VLOOKUP(B9,SeriesSummary,Round4RankChange,FALSE),IF(RoundsRun=5,VLOOKUP(B9,SeriesSummary,Round5RankChange,FALSE),IF(RoundsRun=6,VLOOKUP(B9,SeriesSummary,Round6RankChange,FALSE),\"-\")))))))),\"-\")","v":"-"}]
[null,"Ary B.","A",212.74,18,0,18,{"$f":"IF($BP10>0,SUMPRODUCT(--(C10=C$9:C$38),--(G10<(G$9:G$38)))+1,0)","v":3},{"$f":"IF($BP10>0,RANK(G10,G$9:G$38),0)","v":3},222.77,20,1,{"$f":"SUM(K10:L10)","v":21},{"$f":"G10+M10","v":39},{"$f":"IF(J10>0,SUMPRODUCT(--($C10=$C$9:$C$38),--(M10<(M$9:M$38)))+1,0)","v":1},{"$f":"IF($BP10>0,SUMPRODUCT(--($C10=$C$9:$C$38),--(N10<(N$9:N$38)))+1,0)","v":1},{"$f":"IF(H10=0,0,H10-P10)","v":2},{"$f":"IF(J10>0,RANK(M10,M$9:M$38),0)","v":1},{"$f":"IF($BP10>0,RANK(N10,N$9:N$38),0)","v":1},{"$f":"IF(I10=0,0,I10-S10)","v":2},217.46,19,0,19,{"$f":"N10+X10","v":58},{"$f":"IF(U10>0,SUMPRODUCT(--($C10=$C$9:$C$38),--(X10<(X$9:X$38)))+1,0)","v":2},{"$f":"IF($BP10>0,SUMPRODUCT(--($C10=$C$9:$C$38),--(Y10<(Y$9:Y$38)))+1,0)","v":1},{"$f":"IF(P10=0,0,P10-AA10)","v":0},{"$f":"IF(U10>0,RANK(X10,X$9:X$38),0)","v":2},{"$f":"IF($BP10>0,RANK(Y10,Y$9:Y$38),0)","v":1},{"$f":"IF(S10=0,0,S10-AD10)","v":0},0,0,0,0,{"$f":"Y10+AI10","v":58},{"$f":"IF(AF10>0,SUMPRODUCT(--($C10=$C$9:$C$38),--(AI10<(AI$9:AI$38)))+1,0)","v":0},{"$f":"IF($BP10>0,SUMPRODUCT(--($C10=$C$9:$C$38),--(AJ10<(AJ$9:AJ$38)))+1,0)","v":1},{"$f":"IF(AA10=0,0,AA10-AL10)","v":0},{"$f":"IF(AF10>0,RANK(AI10,AI$9:AI$38),0)","v":0},{"$f":"IF($BP10>0,RANK(AJ10,AJ$9:AJ$38),0)","v":1},{"$f":"IF(AD10=0,0,AD10-AO10)","v":0},0,0,0,0,{"$f":"AJ10+AT10","v":58},{"$f":"IF(AQ10>0,SUMPRODUCT(--($C10=$C$9:$C$38),--(AT10<(AT$9:AT$38)))+1,0)","v":0},{"$f":"IF($BP10>0,SUMPRODUCT(--($C10=$C$9:$C$38),--(AU10<(AU$9:AU$38)))+1,0)","v":1},{"$f":"IF(AL10=0,0,AL10-AW10)","v":0},{"$f":"IF(AQ10>0,RANK(AT10,AT$9:AT$38),0)","v":0},{"$f":"IF($BP10>0,RANK(AU10,AU$9:AU$38),0)","v":1},{"$f":"IF(AO10=0,0,AO10-AZ10)","v":0},0,0,0,0,{"$f":"AU10+BE10","v":58},{"$f":"IF(BB10>0,SUMPRODUCT(--($C10=$C$9:$C$38),--(BE10<(BE$9:BE$38)))+1,0)","v":0},{"$f":"IF($BP10>0,SUMPRODUCT(--($C10=$C$9:$C$38),--(BF10<(BF$9:BF$38)))+1,0)","v":1},{"$f":"IF(AW10=0,0,AW10-BH10)","v":0},{"$f":"IF(BB10>0,RANK(BE10,BE$9:BE$38),0)","v":0},{"$f":"IF($BP10>0,RANK(BF10,BF$9:BF$38),0)","v":1},{"$f":"IF(AZ10=0,0,AZ10-BK10)","v":0},3,57,1,652.97,null,{"$f":"IF($BQ10=1,E10,IF($BQ10=2,K10,IF($BQ10=3,V10,IF($BQ10=4,AG10,IF($BQ10=5,AR10,IF($BQ10=6,BC10,0))))))","v":0},{"$f":"IF($BQ10=1,F10,IF($BQ10=2,L10,IF($BQ10=3,W10,IF($BQ10=4,AH10,IF($BQ10=5,AS10,IF($BQ10=6,BD10,0))))))","v":0},{"$f":"IF($BQ$9=1,D10,IF($BQ10=2,J10,IF($BQ10=3,U10,IF($BQ10=4,AF10,IF($BQ10=5,AP10,IF($BQ10=6,BB10,0))))))","v":0},57,1,{"$f":"BU10+BV10","v":58},652.97,1,"-",1,"-"]
[null,"Austin C.","B",0,0,0,{"$f":"SUM(E11:F11)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(V11:W11)","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(AG11:AH11)","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(AR11:AS11)","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(BC11:BD11)","v":0},0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"IF($BQ11=1,E11,IF($BQ11=2,K11,IF($BQ11=3,V11,IF($BQ11=4,AG11,IF($BQ11=5,AR11,IF($BQ11=6,BC11,0))))))","v":0},{"$f":"IF($BQ11=1,F11,IF($BQ11=2,L11,IF($BQ11=3,W11,IF($BQ11=4,AH11,IF($BQ11=5,AS11,IF($BQ11=6,BD11,0))))))","v":0},{"$f":"IF($BQ$9=1,D11,IF($BQ11=2,J11,IF($BQ11=3,U11,IF($BQ11=4,AF11,IF($BQ11=5,AP11,IF($BQ11=6,BB11,0))))))","v":0},0,0,0,0,0,"-",0,"-"]
[null,"Bob L.","B",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,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,{"$f":"IF($BQ$9=1,D12,IF($BQ12=2,J12,IF($BQ12=3,U12,IF($BQ12=4,AF12,IF($BQ12=5,AP12,IF($BQ12=6,BB12,0))))))","v":0},0,0,0,0,0,"-",0,"-"]
[null,"Bobby H.","B",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,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,{"$f":"IF($BQ$9=1,D13,IF($BQ13=2,J13,IF($BQ13=3,U13,IF($BQ13=4,AF13,IF($BQ13=5,AP13,IF($BQ13=6,BB13,0))))))","v":0},0,0,0,0,0,"-",0,"-"]
[null,"Brett L.","B",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,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,{"$f":"IF($BQ$14=1,D14,IF($BQ14=2,J14,IF($BQ14=3,U14,IF($BQ14=4,AF14,IF($BQ14=5,AP14,IF($BQ14=6,BB14,0))))))","v":0},0,0,0,0,0,"-",0,"-"]
[null,"Brian H.","A",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,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,{"$f":"IF($BQ$9=1,D15,IF($BQ15=2,J15,IF($BQ15=3,U15,IF($BQ15=4,AF15,IF($BQ15=5,AP15,IF($BQ15=6,BB15,0))))))","v":0},0,0,0,0,0,"-",0,"-"]
[null,"David C.","A",214.39,20,1,21,1,1,218.25,18,0,18,39,3,1,0,3,1,0,213.73,18,0,18,57,3,2,-1,3,2,-1,0,0,0,0,57,0,2,0,0,2,0,0,0,0,0,57,0,2,0,0,2,0,0,0,0,0,57,0,2,0,0,2,0,3,56,1,646.37,null,0,0,{"$f":"IF($BQ$16=1,D16,IF($BQ16=2,J16,IF($BQ16=3,U16,IF($BQ16=4,AF16,IF($BQ16=5,AP16,IF($BQ16=6,BB16,0))))))","v":0},56,1,57,646.37,2,-1,2,-1]
[null,"John B.","B",192.72,17,0,17,1,4,188.34,12,0,12,29,3,2,-1,9,7,-3,187.23,16,0,16,45,2,2,0,5,5,2,0,0,0,0,45,0,2,0,0,5,0,0,0,0,0,45,0,2,0,0,5,0,0,0,0,0,45,0,2,0,0,5,0,3,45,0,568.29,null,0,0,0,45,0,45,568.29,2,"-",5,"+2"]
[null,"Jordan C.","A",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,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,"-"]
[null,"Kyle M.","B",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,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,{"$f":"IF($BQ$9=1,D19,IF($BQ19=2,J19,IF($BQ19=3,U19,IF($BQ19=4,AF19,IF($BQ19=5,AP19,IF($BQ19=6,BB19,0))))))","v":0},0,0,0,0,0,"-",0,"-"]
[null,"Mark L.","B",192.27,16,1,17,1,4,188.47,13,0,13,30,2,1,0,8,6,-2,197.74,17,1,18,48,1,1,0,3,4,2,0,0,0,0,48,0,1,0,0,4,0,0,0,0,0,48,0,1,0,0,4,0,0,0,0,0,48,0,1,0,0,4,0,3,46,2,578.48,null,0,0,0,46,2,48,578.48,1,"-",4,"+2"]
[null,"Marty M.","A",110.9,13,0,13,5,8,221.2,19,0,19,32,2,4,1,2,4,4,220.33,20,1,21,53,1,3,1,1,3,1,0,0,0,0,53,0,3,0,0,3,0,0,0,0,0,53,0,3,0,0,3,0,0,0,0,0,53,0,3,0,0,3,0,3,52,1,552.43000000000006,null,0,0,0,52,1,53,552.43000000000006,3,"+1",3,"+1"]
[null,"Max M.","B",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,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,"-"]
[null,"Mitch A.","B",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,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,"-"]
[null,"Nick M.","B",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,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,"-"]
[null,"Randy A.","B",121.23,14,0,14,3,7,198.93,14,1,15,29,1,2,1,6,7,0,0,0,0,0,29,0,3,-1,0,8,-1,0,0,0,0,29,0,3,0,0,8,0,0,0,0,0,29,0,3,0,0,8,0,0,0,0,0,29,0,3,0,0,8,0,2,28,1,320.16000000000003,null,0,0,0,28,1,29,320.16000000000003,3,-1,8,-1]
[null,"Rich C.","B",0,0,0,0,4,9,183.25,11,0,11,11,4,4,0,10,10,-1,0,0,0,0,11,0,4,0,0,10,0,0,0,0,0,11,0,4,0,0,10,0,0,0,0,0,11,0,4,0,0,10,0,0,0,0,0,11,0,4,0,0,10,0,1,11,0,183.25,null,0,0,0,11,0,11,183.25,4,"-",10,"-"]
[null,"Roy M.","A",0,{"$f":"IF(ISNA(VLOOKUP($B27,Round1Results,6,FALSE)),0,VLOOKUP($B27,Round1Results,6,FALSE)-F27)","v":0},0,{"$f":"SUM(E27:F27)","v":0},{"$f":"IF($BP27>0,SUMPRODUCT(--(C27=C$9:C$38),--(G27<(G$9:G$38)))+1,0)","v":0},{"$f":"IF($BP27>0,RANK(G27,G$9:G$38),0)","v":0},0,{"$f":"IF(ISNA(VLOOKUP($B27,Round2Results,6,FALSE)),0,VLOOKUP($B27,Round2Results,6,FALSE)-L27)","v":0},0,{"$f":"SUM(K27:L27)","v":0},{"$f":"G27+M27","v":0},{"$f":"IF(J27>0,SUMPRODUCT(--($C27=$C$9:$C$38),--(M27<(M$9:M$38)))+1,0)","v":0},{"$f":"IF($BP27>0,SUMPRODUCT(--($C27=$C$9:$C$38),--(N27<(N$9:N$38)))+1,0)","v":0},{"$f":"IF(H27=0,0,H27-P27)","v":0},{"$f":"IF(J27>0,RANK(M27,M$9:M$38),0)","v":0},{"$f":"IF($BP27>0,RANK(N27,N$9:N$38),0)","v":0},{"$f":"IF(I27=0,0,I27-S27)","v":0},0,{"$f":"IF(ISNA(VLOOKUP($B27,Round3Results,6,FALSE)),0,VLOOKUP($B27,Round3Results,6,FALSE)-W27)","v":0},0,{"$f":"SUM(V27:W27)","v":0},{"$f":"N27+X27","v":0},{"$f":"IF(U27>0,SUMPRODUCT(--($C27=$C$9:$C$38),--(X27<(X$9:X$38)))+1,0)","v":0},{"$f":"IF($BP27>0,SUMPRODUCT(--($C27=$C$9:$C$38),--(Y27<(Y$9:Y$38)))+1,0)","v":0},{"$f":"IF(P27=0,0,P27-AA27)","v":0},{"$f":"IF(U27>0,RANK(X27,X$9:X$38),0)","v":0},{"$f":"IF($BP27>0,RANK(Y27,Y$9:Y$38),0)","v":0},{"$f":"IF(S27=0,0,S27-AD27)","v":0},0,{"$f":"IF(ISNA(VLOOKUP($B27,Round4Results,6,FALSE)),0,VLOOKUP($B27,Round4Results,6,FALSE)-AH27)","v":0},0,{"$f":"SUM(AG27:AH27)","v":0},{"$f":"Y27+AI27","v":0},{"$f":"IF(AF27>0,SUMPRODUCT(--($C27=$C$9:$C$38),--(AI27<(AI$9:AI$38)))+1,0)","v":0},{"$f":"IF($BP27>0,SUMPRODUCT(--($C27=$C$9:$C$38),--(AJ27<(AJ$9:AJ$38)))+1,0)","v":0},{"$f":"IF(AA27=0,0,AA27-AL27)","v":0},{"$f":"IF(AF27>0,RANK(AI27,AI$9:AI$38),0)","v":0},{"$f":"IF($BP27>0,RANK(AJ27,AJ$9:AJ$38),0)","v":0},{"$f":"IF(AD27=0,0,AD27-AO27)","v":0},0,{"$f":"IF(ISNA(VLOOKUP($B27,Round5Results,6,FALSE)),0,VLOOKUP($B27,Round5Results,6,FALSE)-AS27)","v":0},0,{"$f":"SUM(AR27:AS27)","v":0},{"$f":"AJ27+AT27","v":0},{"$f":"IF(AQ27>0,SUMPRODUCT(--($C27=$C$9:$C$38),--(AT27<(AT$9:AT$38)))+1,0)","v":0},{"$f":"IF($BP27>0,SUMPRODUCT(--($C27=$C$9:$C$38),--(AU27<(AU$9:AU$38)))+1,0)","v":0},{"$f":"IF(AL27=0,0,AL27-AW27)","v":0},{"$f":"IF(AQ27>0,RANK(AT27,AT$9:AT$38),0)","v":0},{"$f":"IF($BP27>0,RANK(AU27,AU$9:AU$38),0)","v":0},{"$f":"IF(AO27=0,0,AO27-AZ27)","v":0},0,{"$f":"IF(ISNA(VLOOKUP($B27,Round6Results,6,FALSE)),0,VLOOKUP($B27,Round6Results,6,FALSE)-BD27)","v":0},0,{"$f":"SUM(BC27:BD27)","v":0},{"$f":"AU27+BE27","v":0},{"$f":"IF(BB27>0,SUMPRODUCT(--($C27=$C$9:$C$38),--(BE27<(BE$9:BE$38)))+1,0)","v":0},{"$f":"IF($BP27>0,SUMPRODUCT(--($C27=$C$9:$C$38),--(BF27<(BF$9:BF$38)))+1,0)","v":0},{"$f":"IF(AW27=0,0,AW27-BH27)","v":0},{"$f":"IF(BB27>0,RANK(BE27,BE$9:BE$38),0)","v":0},{"$f":"IF($BP27>0,RANK(BF27,BF$9:BF$38),0)","v":0},{"$f":"IF(AZ27=0,0,AZ27-BK27)","v":0},{"$f":"COUNTIF(D27,\">0\")+COUNTIF(J27,\">0\")+COUNTIF(U27,\">0\")+COUNTIF(AF27,\">0\")+COUNTIF(AQ27,\">0\")+COUNTIF(BB27,\">0\")","v":0},{"$f":"E27+K27+V27+AG27+AR27+BC27","v":0},{"$f":"F27+L27+W27+AH27+AS27+BD27","v":0},{"$f":"D27+J27+U27+AF27+AQ27+BB27","v":0},null,0,0,{"$f":"IF($BQ$9=1,D27,IF($BQ27=2,J27,IF($BQ27=3,U27,IF($BQ27=4,AF27,IF($BQ27=5,AP27,IF($BQ27=6,BB27,0))))))","v":0},{"$f":"E27+K27+V27+AG27+AR27+BC27-BR27","v":0},{"$f":"F27+L27+W27+AH27+AS27+BD27-BS27","v":0},{"$f":"BU27+BV27","v":0},{"$f":"D27+J27+U27+AF27+AQ27+BB27-BT27","v":0},0,{"$f":"IF(AND(B27<>\"\",RoundsRun>1),IF(IF(RoundsRun=2,VLOOKUP(B27,SeriesSummary,Round2ClassRankChange,FALSE),IF(RoundsRun=3,VLOOKUP(B27,SeriesSummary,Round3ClassRankChange,FALSE),IF(RoundsRun=4,VLOOKUP(B27,SeriesSummary,Round4ClassRankChange,FALSE),IF(RoundsRun=5,VLOOKUP(B27,SeriesSummary,Round5ClassRankChange,FALSE),IF(RoundsRun=6,VLOOKUP(B27,SeriesSummary,Round6ClassRankChange,FALSE),\"-\")))))>0,\"+\"&IF(RoundsRun=2,VLOOKUP(B27,SeriesSummary,Round2ClassRankChange,FALSE),IF(RoundsRun=3,VLOOKUP(B27,SeriesSummary,Round3ClassRankChange,FALSE),IF(RoundsRun=4,VLOOKUP(B27,SeriesSummary,Round4ClassRankChange,FALSE),IF(RoundsRun=5,VLOOKUP(B27,SeriesSummary,Round5ClassRankChange,FALSE),IF(RoundsRun=6,VLOOKUP(B27,SeriesSummary,Round6ClassRankChange,FALSE),\"-\"))))),IF((IF(RoundsRun=2,VLOOKUP(B27,SeriesSummary,Round2ClassRankChange,FALSE),IF(RoundsRun=3,VLOOKUP(B27,SeriesSummary,Round3ClassRankChange,FALSE),IF(RoundsRun=4,VLOOKUP(B27,SeriesSummary,Round4ClassRankChange,FALSE),IF(RoundsRun=5,VLOOKUP(B27,SeriesSummary,Round5ClassRankChange,FALSE),IF(RoundsRun=6,VLOOKUP(B27,SeriesSummary,Round6ClassRankChange,FALSE),\"-\"))))))=0,\"-\",(IF(RoundsRun=2,VLOOKUP(B27,SeriesSummary,Round2ClassRankChange,FALSE),IF(RoundsRun=3,VLOOKUP(B27,SeriesSummary,Round3ClassRankChange,FALSE),IF(RoundsRun=4,VLOOKUP(B27,SeriesSummary,Round4ClassRankChange,FALSE),IF(RoundsRun=5,VLOOKUP(B27,SeriesSummary,Round5ClassRankChange,FALSE),IF(RoundsRun=6,VLOOKUP(B27,SeriesSummary,Round6ClassRankChange,FALSE),\"-\")))))))),\"-\")","v":"-"},{"$f":"IF(BM27>0,RANK(BW27,Total_Point_Range)+SUMPRODUCT((Total_Point_Range=BW27)*(Total_Lap_Range>BX27)),0)","v":0},{"$f":"IF(AND(B27<>\"\",RoundsRun>1),IF(IF(RoundsRun=2,VLOOKUP(B27,SeriesSummary,Round2RankChange,FALSE),IF(RoundsRun=3,VLOOKUP(B27,SeriesSummary,Round3RankChange,FALSE),IF(RoundsRun=4,VLOOKUP(B27,SeriesSummary,Round4RankChange,FALSE),IF(RoundsRun=5,VLOOKUP(B27,SeriesSummary,Round5RankChange,FALSE),IF(RoundsRun=6,VLOOKUP(B27,SeriesSummary,Round6RankChange,FALSE),\"-\")))))>0,\"+\"&IF(RoundsRun=2,VLOOKUP(B27,SeriesSummary,Round2RankChange,FALSE),IF(RoundsRun=3,VLOOKUP(B27,SeriesSummary,Round3RankChange,FALSE),IF(RoundsRun=4,VLOOKUP(B27,SeriesSummary,Round4RankChange,FALSE),IF(RoundsRun=5,VLOOKUP(B27,SeriesSummary,Round5RankChange,FALSE),IF(RoundsRun=6,VLOOKUP(B27,SeriesSummary,Round6RankChange,FALSE),\"-\"))))),IF((IF(RoundsRun=2,VLOOKUP(B27,SeriesSummary,Round2RankChange,FALSE),IF(RoundsRun=3,VLOOKUP(B27,SeriesSummary,Round3RankChange,FALSE),IF(RoundsRun=4,VLOOKUP(B27,SeriesSummary,Round4RankChange,FALSE),IF(RoundsRun=5,VLOOKUP(B27,SeriesSummary,Round5RankChange,FALSE),IF(RoundsRun=6,VLOOKUP(B27,SeriesSummary,Round6RankChange,FALSE),\"-\"))))))=0,\"-\",(IF(RoundsRun=2,VLOOKUP(B27,SeriesSummary,Round2RankChange,FALSE),IF(RoundsRun=3,VLOOKUP(B27,SeriesSummary,Round3RankChange,FALSE),IF(RoundsRun=4,VLOOKUP(B27,SeriesSummary,Round4RankChange,FALSE),IF(RoundsRun=5,VLOOKUP(B27,SeriesSummary,Round5RankChange,FALSE),IF(RoundsRun=6,VLOOKUP(B27,SeriesSummary,Round6RankChange,FALSE),\"-\")))))))),\"-\")","v":"-"}]
[null,"Russell M.","A",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,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,"-"]
[null,"Shawn G.","A",214.36,19,0,19,2,2,213.76,17,0,17,36,4,3,-1,4,3,-1,0,0,0,0,36,0,4,-1,0,6,-3,0,0,0,0,36,0,4,0,0,6,0,0,0,0,0,36,0,4,0,0,6,0,0,0,0,0,36,0,4,0,0,6,0,2,36,0,428.12,null,0,0,0,36,0,36,428.12,4,-1,6,-3]
[null,"Stephen B.","A",188.71,15,0,15,4,6,203.71,16,0,16,31,5,5,-1,5,5,1,0,0,0,0,31,0,5,0,0,7,-2,0,0,0,0,31,0,5,0,0,7,0,0,0,0,0,31,0,5,0,0,7,0,0,0,0,0,31,0,5,0,0,7,0,2,31,0,392.42,null,0,0,0,31,0,31,392.42,5,"-",7,-2]
[null,null,null,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,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,"-"]
[null,null,null,0,0,0,{"$f":"SUM(E32:F32)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(V32:W32)","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(AG32:AH32)","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(AR32:AS32)","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(BC32:BD32)","v":0},0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,"-",0,"-"]
[null,null,null,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,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,"-"]
[null,null,null,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,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,"-"]
[null,null,null,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,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,"-"]
[null,null,null,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,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,"-"]
[null,null,null,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,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,"-"]
[null,null,null,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,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,"-"]
[]
[]
[null,"Series Name","2017 BTCC"]
[null,"Rounds Run",{"$f":"COUNT('Round 1'!B4,'Round 2'!B4,'Round 3'!B4,'Round 4'!B4,'Round 5'!B4,'Round 6'!B4)","v":3}]
[null,"Points Table"]
[null,"Position","Points"]
[null,1,20]
[null,2,19]
[null,3,18]
[null,4,17]
[null,5,16]
[null,6,15]
[null,7,14]
[null,8,13]
[null,9,12]
[null,10,11]
[null,11,10]
[null,12,9]
[null,13,8]
[null,14,7]
[null,15,6]
[null,16,5]
[null,17,4]
[null,18,3]
[null,19,2]
[null,20,1]