{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Heats","Qualifying results","Finals","Settings"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":5,"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":"Heats","index":0,"n_rows":47,"n_cols":9,"rows_kept":47,"cut":false,"hidden":false,"merged":[]}
["Drivers per heat",4,null,null,"Driver","Lane","Laps","Hundredths","Best lap"]
["Drivers",{"$f":"COUNTIF(A5:A99,\"*\")","v":8},null,null,"Tony S","White",12,null,5.0090000000000003]
["Shuffle ",1,null,null,"blank","Blue ",0,null,"-.---"]
["Names","Chassis",null,null,"Marc T","Red",26,null,4.423]
["Tony S",null,null,null,"Andy W","Yellow",20,null,5.4589999999999996]
["blank"]
["Marc T",null,null,null,"Driver","Lane","Laps","Hundredths","Best lap"]
["Andy W",null,null,null,"blank","White",0,null,"-.---"]
["Clive H",null,null,null,"Tony S","Blue ",17,null,4.9050000000000002]
["Mike D",null,null,null,"Andy W","Red",17,null,5.1929999999999996]
["Mike R",null,null,null,"Marc T","Yellow",25,null,4.3550000000000004]
["Callum N"]
[null,null,null,null,"Driver","Lane","Laps","Hundredths","Best lap"]
[null,null,null,null,"Clive H","White",20,null,5.0940000000000003]
[null,null,null,null,"Mike D","Blue ",13,null,4.8559999999999999]
[null,null,null,null,"Mike R","Red",17,null,6.4409999999999998]
[null,null,null,null,"Callum N","Yellow",9,null,7.0190000000000001]
[]
[null,null,null,null,"Driver","Lane","Laps","Hundredths","Best lap"]
[null,null,null,null,"Mike D","White",17,null,4.6379999999999999]
[null,null,null,null,"Clive H","Blue ",18,null,5.3769999999999998]
[null,null,null,null,"Callum N","Red",16,null,5.58]
[null,null,null,null,"Mike R","Yellow",17,null,6.165]
[]
[null,null,null,null,"Driver","Lane","Laps","Hundredths","Best lap"]
[null,null,null,null,"Marc T","White",5,null,4.6619999999999999]
[null,null,null,null,"Andy W","Blue ",20,null,5.5869999999999997]
[null,null,null,null,"Tony S","Red",15,null,5.2149999999999999]
[null,null,null,null,"blank","Yellow",0,null,"-.---"]
[]
[null,null,null,null,"Driver","Lane","Laps","Hundredths","Best lap"]
[null,null,null,null,"Andy W","White",19,50,5.5970000000000004]
[null,null,null,null,"Marc T","Blue ",0,null,"-.---"]
[null,null,null,null,"blank","Red",0,null,"-.---"]
[null,null,null,null,"Tony S","Yellow",13,65,5.9009999999999998]
[]
[null,null,null,null,"Driver","Lane","Laps","Hundredths","Best lap"]
[null,null,null,null,"Mike R","White",18,null,5.6870000000000003]
[null,null,null,null,"Callum N","Blue ",14,null,5.2530000000000001]
[null,null,null,null,"Clive H","Red",22,null,5.1100000000000003]
[null,null,null,null,"Mike D","Yellow",17,null,4.9740000000000002]
[]
[null,null,null,null,"Driver","Lane","Laps","Hundredths","Best lap"]
[null,null,null,null,"Callum N","White",4,95,6.3179999999999996]
[null,null,null,null,"Mike R","Blue ",18,55,5.6310000000000002]
[null,null,null,null,"Mike D","Red",21,20,4.8380000000000001]
[null,null,null,null,"Clive H","Yellow",16,55,5.5490000000000004]

{"sheet":"Qualifying results","index":1,"n_rows":24,"n_cols":18,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
[null,null,null,"White",null,"Blue",null,"Red",null,"Yellow",null,"Overall"]
["P",null,{"$f":"Heats!$B$4","v":"Chassis"},"Laps","Best lap","Laps","Best lap","Laps","Best lap","Laps","Best lap","Total","Drop","Best 3","Gap","Best lap"]
[1,"Clive H",{"$f":"Heats!$B$9","v":0},{"$f":"Heats!$G$14+Heats!$H$14/100","v":20},{"$f":"Heats!$I$14","v":5.0940000000000003},{"$f":"Heats!$G$21+Heats!$H$21/100","v":18},{"$f":"Heats!$I$21","v":5.3769999999999998},{"$f":"Heats!$G$40+Heats!$H$40/100","v":22},{"$f":"Heats!$I$40","v":5.1100000000000003},{"$f":"Heats!$G$47+Heats!$H$47/100","v":16.55},{"$f":"Heats!$I$47","v":5.5490000000000004},{"$f":"D3+F3+H3+J3","v":76.55},{"$f":"MIN(D3,F3,H3,J3)","v":16.55},{"$f":"L3-M3","v":60},null,{"$f":"IF(MIN(E3,G3,I3,K3)=0, \"-.---\", MIN(E3,G3,I3,K3))","v":5.0940000000000003}]
[2,"Andy W",{"$f":"Heats!$B$8","v":0},{"$f":"Heats!$G$32+Heats!$H$32/100","v":19.5},{"$f":"Heats!$I$32","v":5.5970000000000004},{"$f":"Heats!$G$27+Heats!$H$27/100","v":20},{"$f":"Heats!$I$27","v":5.5869999999999997},{"$f":"Heats!$G$10+Heats!$H$10/100","v":17},{"$f":"Heats!$I$10","v":5.1929999999999996},{"$f":"Heats!$G$5+Heats!$H$5/100","v":20},{"$f":"Heats!$I$5","v":5.4589999999999996},{"$f":"D4+F4+H4+J4","v":76.5},{"$f":"MIN(D4,F4,H4,J4)","v":17},{"$f":"L4-M4","v":59.5},{"$f":"N3-N4","v":0.5},5.1929999999999996]
[3,"Mike R",{"$f":"Heats!$B$11","v":0},{"$f":"Heats!$G$38+Heats!$H$38/100","v":18},{"$f":"Heats!$I$38","v":5.6870000000000003},{"$f":"Heats!$G$45+Heats!$H$45/100","v":18.55},{"$f":"Heats!$I$45","v":5.6310000000000002},{"$f":"Heats!$G$16+Heats!$H$16/100","v":17},{"$f":"Heats!$I$16","v":6.4409999999999998},{"$f":"Heats!$G$23+Heats!$H$23/100","v":17},{"$f":"Heats!$I$23","v":6.165},{"$f":"D5+F5+H5+J5","v":70.55},{"$f":"MIN(D5,F5,H5,J5)","v":17},{"$f":"L5-M5","v":53.55},{"$f":"N3-N5","v":6.4500000000000028},5.6310000000000002]
[4,"Mike D",{"$f":"Heats!$B$10","v":0},{"$f":"Heats!$G$20+Heats!$H$20/100","v":17},{"$f":"Heats!$I$20","v":4.6379999999999999},{"$f":"Heats!$G$15+Heats!$H$15/100","v":13},{"$f":"Heats!$I$15","v":4.8559999999999999},{"$f":"Heats!$G$46+Heats!$H$46/100","v":21.2},{"$f":"Heats!$I$46","v":4.8380000000000001},{"$f":"Heats!$G$41+Heats!$H$41/100","v":17},{"$f":"Heats!$I$41","v":4.9740000000000002},{"$f":"D6+F6+H6+J6","v":68.2},{"$f":"MIN(D6,F6,H6,J6)","v":13},{"$f":"L6-M6","v":55.2},{"$f":"N3-N6","v":4.7999999999999972},4.6379999999999999,null,"delete drop and best 3"]
[5,"Tony S",{"$f":"Heats!$B$5","v":0},{"$f":"Heats!$G$2+Heats!$H$2/100","v":12},{"$f":"Heats!$I$2","v":5.0090000000000003},{"$f":"Heats!$G$9+Heats!$H$9/100","v":17},{"$f":"Heats!$I$9","v":4.9050000000000002},{"$f":"Heats!$G$28+Heats!$H$28/100","v":15},{"$f":"Heats!$I$28","v":5.2149999999999999},{"$f":"Heats!$G$35+Heats!$H$35/100","v":13.65},{"$f":"Heats!$I$35","v":5.9009999999999998},{"$f":"D7+F7+H7+J7","v":57.65},{"$f":"MIN(D7,F7,H7,J7)","v":12},{"$f":"L7-M7","v":45.65},{"$f":"N3-N7","v":14.350000000000001},4.9050000000000002,null,"Add three laps to each"]
[6,"Marc T",{"$f":"Heats!$B$7","v":0},{"$f":"Heats!$G$26+Heats!$H$26/100","v":5},{"$f":"Heats!$I$26","v":4.6619999999999999},{"$f":"Heats!$G$33+Heats!$H$33/100","v":0},{"$f":"Heats!$I$33","v":"-.---"},{"$f":"Heats!$G$4+Heats!$H$4/100","v":26},{"$f":"Heats!$I$4","v":4.423},{"$f":"Heats!$G$11+Heats!$H$11/100","v":25},{"$f":"Heats!$I$11","v":4.3550000000000004},{"$f":"D8+F8+H8+J8","v":56},{"$f":"MIN(D8,F8,H8,J8)","v":0},{"$f":"L8-M8","v":56},{"$f":"N3-N8","v":4},4.3550000000000004]
[7,"Callum N",{"$f":"Heats!$B$12","v":0},{"$f":"Heats!$G$44+Heats!$H$44/100","v":4.95},{"$f":"Heats!$I$44","v":6.3179999999999996},{"$f":"Heats!$G$39+Heats!$H$39/100","v":14},{"$f":"Heats!$I$39","v":5.2530000000000001},{"$f":"Heats!$G$22+Heats!$H$22/100","v":16},{"$f":"Heats!$I$22","v":5.58},{"$f":"Heats!$G$17+Heats!$H$17/100","v":9},{"$f":"Heats!$I$17","v":7.0190000000000001},{"$f":"D9+F9+H9+J9","v":43.95},{"$f":"MIN(D9,F9,H9,J9)","v":4.95},{"$f":"L9-M9","v":39},{"$f":"N3-N9","v":21},5.2530000000000001]
[8,"blank",{"$f":"Heats!$B$6","v":0},{"$f":"Heats!$G$8+Heats!$H$8/100","v":0},{"$f":"Heats!$I$8","v":"-.---"},{"$f":"Heats!$G$3+Heats!$H$3/100","v":0},{"$f":"Heats!$I$3","v":"-.---"},{"$f":"Heats!$G$34+Heats!$H$34/100","v":0},{"$f":"Heats!$I$34","v":"-.---"},{"$f":"Heats!$G$29+Heats!$H$29/100","v":0},{"$f":"Heats!$I$29","v":"-.---"},{"$f":"D10+F10+H10+J10","v":0},{"$f":"MIN(D10,F10,H10,J10)","v":0},{"$f":"L10-M10","v":0},{"$f":"N3-N10","v":60},"-.---"]
[9,null,null,null,null,null,null,null,null,null,null,{"$f":"D11+F11+H11+J11","v":0},{"$f":"MIN(D11,F11,H11,J11)","v":0},{"$f":"L11-M11","v":0},{"$f":"N3-N11","v":60},"-.---"]
[10,null,null,null,null,null,null,null,null,null,null,{"$f":"D12+F12+H12+J12","v":0},{"$f":"MIN(D12,F12,H12,J12)","v":0},{"$f":"L12-M12","v":0},{"$f":"N3-N12","v":60},"-.---"]
[11,null,null,null,null,null,null,null,null,null,null,0,0,0,{"$f":"N3-N13","v":60},"-.---"]
[12,null,null,null,null,null,null,null,null,null,null,0,0,0,{"$f":"N3-N14","v":60},"-.---"]
[13,null,null,null,null,null,null,null,null,null,null,0,0,0,{"$f":"N3-N15","v":60},"-.---"]
[14,null,null,null,null,null,null,null,null,null,null,0,0,0,{"$f":"N3-N16","v":60},"-.---"]
[15,null,null,null,null,null,null,null,null,null,null,0,0,0,{"$f":"N3-N17","v":60},"-.---"]
[16,null,null,null,null,null,null,null,null,null,null,0,0,0,{"$f":"N3-N18","v":60},"-.---"]
[17,null,null,null,null,null,null,null,null,null,null,0,0,0,{"$f":"N3-N19","v":60},"-.---"]
[18,null,null,null,null,null,null,null,null,null,null,0,0,0,{"$f":"N3-N20","v":60},"-.---"]
[19,null,null,null,null,null,null,null,null,null,null,0,0,0,{"$f":"N3-N21","v":60},"-.---"]
[20,null,null,null,null,null,null,null,null,null,null,0,0,0,{"$f":"N3-N22","v":60},"-.---"]
[21,null,null,null,null,null,null,null,null,null,null,0,0,0,{"$f":"N3-N23","v":60},"-.---"]
[22,null,null,null,null,null,null,null,null,null,null,0,0,0,{"$f":"N3-N24","v":60},"-.---"]

{"sheet":"Finals","index":2,"n_rows":30,"n_cols":29,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,"Final",null,null,null,"Overall",null,null,null,null,null,null,null,null,"Best lap time ",null,null,null,null,null,"Best laps"]
["P","Final ","Q","Driver","Chassis","Lane","Laps","Gap","Best lap","Best laps","Best lap",null,"A Final","Lane","laps","tenths","best Lap",null,"P","Driver","Chassis","best lap","Gap",null,"P","Driver","Chassis","best laps","Gap"]
[1,"A",1,{"$f":"'Qualifying results'!$B$3","v":"Clive H"},{"$f":"'Qualifying results'!$C$3","v":0},null,{"$f":"IF(ISNA(VLOOKUP(F3, $N$3:$Q$6, 2, FALSE)), 0, VLOOKUP(F3, $N$3:$Q$6, 2, FALSE)+VLOOKUP(F3, $N$3:$Q$6, 3, FALSE)/10)","v":0},null,{"$f":"IF(ISNA(VLOOKUP(F3, $N$3:$Q$6, 4, FALSE)), \"-.---\", VLOOKUP(F3, $N$3:$Q$6, 4, FALSE))","v":"-.---"},{"$f":"MAX(G3,'Qualifying results'!$J$3,'Qualifying results'!$H$3,'Qualifying results'!$F$3,'Qualifying results'!$D$3)","v":22},{"$f":"MIN(I3,'Qualifying results'!$K$3,'Qualifying results'!$I$3,'Qualifying results'!$G$3,'Qualifying results'!$E$3)","v":5.0940000000000003},null,null,"W",null,null,null,null,1,{"$f":"$D$3","v":"Clive H"},{"$f":"$E$3","v":0},{"$f":"$K$3","v":5.0940000000000003},null,null,1,{"$f":"$D$3","v":"Clive H"},{"$f":"$E$3","v":0},{"$f":"$J$3","v":22}]
[2,"A",2,{"$f":"'Qualifying results'!$B$4","v":"Andy W"},{"$f":"'Qualifying results'!$C$4","v":0},null,{"$f":"IF(ISNA(VLOOKUP(F4, $N$3:$Q$6, 2, FALSE)), 0, VLOOKUP(F4, $N$3:$Q$6, 2, FALSE)+VLOOKUP(F4, $N$3:$Q$6, 3, FALSE)/10)","v":0},null,{"$f":"IF(ISNA(VLOOKUP(F4, $N$3:$Q$6, 4, FALSE)), \"-.---\", VLOOKUP(F4, $N$3:$Q$6, 4, FALSE))","v":"-.---"},{"$f":"MAX(G4,'Qualifying results'!$J$4,'Qualifying results'!$H$4,'Qualifying results'!$F$4,'Qualifying results'!$D$4)","v":20},{"$f":"MIN(I4,'Qualifying results'!$K$4,'Qualifying results'!$I$4,'Qualifying results'!$G$4,'Qualifying results'!$E$4)","v":5.1929999999999996},null,null,"B",null,null,null,null,2,{"$f":"$D$4","v":"Andy W"},{"$f":"$E$4","v":0},{"$f":"$K$4","v":5.1929999999999996},{"$f":"V4-$V$3","v":9.8999999999999311E-2},null,2,{"$f":"$D$4","v":"Andy W"},{"$f":"$E$4","v":0},{"$f":"$J$4","v":20},{"$f":"$AB$3-AB4","v":2}]
[3,"A",3,{"$f":"'Qualifying results'!$B$5","v":"Mike R"},{"$f":"'Qualifying results'!$C$5","v":0},null,{"$f":"IF(ISNA(VLOOKUP(F5, $N$3:$Q$6, 2, FALSE)), 0, VLOOKUP(F5, $N$3:$Q$6, 2, FALSE)+VLOOKUP(F5, $N$3:$Q$6, 3, FALSE)/10)","v":0},null,{"$f":"IF(ISNA(VLOOKUP(F5, $N$3:$Q$6, 4, FALSE)), \"-.---\", VLOOKUP(F5, $N$3:$Q$6, 4, FALSE))","v":"-.---"},{"$f":"MAX(G5,'Qualifying results'!$J$5,'Qualifying results'!$H$5,'Qualifying results'!$F$5,'Qualifying results'!$D$5)","v":18.55},{"$f":"MIN(I5,'Qualifying results'!$K$5,'Qualifying results'!$I$5,'Qualifying results'!$G$5,'Qualifying results'!$E$5)","v":5.6310000000000002},null,null,"R",null,null,null,null,3,{"$f":"$D$5","v":"Mike R"},{"$f":"$E$5","v":0},{"$f":"$K$5","v":5.6310000000000002},0.53699999999999992,null,3,{"$f":"$D$5","v":"Mike R"},{"$f":"$E$5","v":0},{"$f":"$J$5","v":18.55},3.4499999999999993]
[4,"A",{"$f":"$C$7","v":4},{"$f":"$D$7","v":"Mike D"},{"$f":"$E$7","v":0},null,{"$f":"IF(ISNA(VLOOKUP(F6, $N$3:$Q$6, 2, FALSE)), 0, VLOOKUP(F6, $N$3:$Q$6, 2, FALSE)+VLOOKUP(F6, $N$3:$Q$6, 3, FALSE)/10)","v":0},null,{"$f":"IF(ISNA(VLOOKUP(F6, $N$3:$Q$6, 4, FALSE)), \"-.---\", VLOOKUP(F6, $N$3:$Q$6, 4, FALSE))","v":"-.---"},{"$f":"MAX(G6,$J$7)","v":21.2},{"$f":"MIN(I6,$K$7)","v":4.6379999999999999},null,null,"Y",null,null,null,null,4,{"$f":"$D$6","v":"Mike D"},{"$f":"$E$6","v":0},{"$f":"$K$6","v":4.6379999999999999},-0.45600000000000041,null,4,{"$f":"$D$6","v":"Mike D"},{"$f":"$E$6","v":0},{"$f":"$J$6","v":21.2},0.80000000000000071]
["-","B",4,{"$f":"'Qualifying results'!$B$6","v":"Mike D"},{"$f":"'Qualifying results'!$C$6","v":0},null,{"$f":"IF(ISNA(VLOOKUP(F7, $N$7:$Q$10, 2, FALSE)), 0, VLOOKUP(F7, $N$7:$Q$10, 2, FALSE)+VLOOKUP(F7, $N$7:$Q$10, 3, FALSE)/10)","v":0},null,{"$f":"IF(ISNA(VLOOKUP(F7, $N$7:$Q$10, 4, FALSE)), \"-.---\", VLOOKUP(F7, $N$7:$Q$10, 4, FALSE))","v":"-.---"},{"$f":"MAX(G7,'Qualifying results'!$J$6,'Qualifying results'!$H$6,'Qualifying results'!$F$6,'Qualifying results'!$D$6)","v":21.2},{"$f":"MIN(I7,'Qualifying results'!$K$6,'Qualifying results'!$I$6,'Qualifying results'!$G$6,'Qualifying results'!$E$6)","v":4.6379999999999999},null,"B Final","W",null,null,null,null,5,{"$f":"$D$8","v":"Tony S"},{"$f":"$E$8","v":0},{"$f":"$K$8","v":4.9050000000000002},-0.18900000000000006,null,5,{"$f":"$D$8","v":"Tony S"},{"$f":"$E$8","v":0},{"$f":"$J$8","v":17},5]
[5,"B",5,{"$f":"'Qualifying results'!$B$7","v":"Tony S"},{"$f":"'Qualifying results'!$C$7","v":0},null,{"$f":"IF(ISNA(VLOOKUP(F8, $N$7:$Q$10, 2, FALSE)), 0, VLOOKUP(F8, $N$7:$Q$10, 2, FALSE)+VLOOKUP(F8, $N$7:$Q$10, 3, FALSE)/10)","v":0},null,{"$f":"IF(ISNA(VLOOKUP(F8, $N$7:$Q$10, 4, FALSE)), \"-.---\", VLOOKUP(F8, $N$7:$Q$10, 4, FALSE))","v":"-.---"},{"$f":"MAX(G8,'Qualifying results'!$J$7,'Qualifying results'!$H$7,'Qualifying results'!$F$7,'Qualifying results'!$D$7)","v":17},{"$f":"MIN(I8,'Qualifying results'!$K$7,'Qualifying results'!$I$7,'Qualifying results'!$G$7,'Qualifying results'!$F$7)","v":4.9050000000000002},null,null,"B",null,null,null,null,6,{"$f":"$D$9","v":"Marc T"},{"$f":"$E$9","v":0},{"$f":"$K$9","v":4.3550000000000004},-0.73899999999999988,null,6,{"$f":"$D$9","v":"Marc T"},{"$f":"$E$9","v":0},{"$f":"$J$9","v":26},-4]
[6,"B",6,{"$f":"'Qualifying results'!$B$8","v":"Marc T"},{"$f":"'Qualifying results'!$C$8","v":0},null,{"$f":"IF(ISNA(VLOOKUP(F9, $N$7:$Q$10, 2, FALSE)), 0, VLOOKUP(F9, $N$7:$Q$10, 2, FALSE)+VLOOKUP(F9, $N$7:$Q$10, 3, FALSE)/10)","v":0},null,{"$f":"IF(ISNA(VLOOKUP(F9, $N$7:$Q$10, 4, FALSE)), \"-.---\", VLOOKUP(F9, $N$7:$Q$10, 4, FALSE))","v":"-.---"},{"$f":"MAX(G9,'Qualifying results'!$J$8,'Qualifying results'!$H$8,'Qualifying results'!$F$8,'Qualifying results'!$D$8)","v":26},{"$f":"MIN(I9,'Qualifying results'!$K$8,'Qualifying results'!$I$8,'Qualifying results'!$G$8,'Qualifying results'!$E$8)","v":4.3550000000000004},null,null,"R",null,null,null,null,7,{"$f":"$D$10","v":"Callum N"},{"$f":"$E$10","v":0},{"$f":"$K$10","v":5.2530000000000001},0.15899999999999981,null,7,{"$f":"$D$10","v":"Callum N"},{"$f":"$E$10","v":0},{"$f":"$J$10","v":16},6]
[7,"B",{"$f":"$C$11","v":7},{"$f":"$D$11","v":"Callum N"},{"$f":"$E$11","v":0},null,{"$f":"IF(ISNA(VLOOKUP(F10, $N$7:$Q$10, 2, FALSE)), 0, VLOOKUP(F10, $N$7:$Q$10, 2, FALSE)+VLOOKUP(F10, $N$7:$Q$10, 3, FALSE)/10)","v":0},null,{"$f":"IF(ISNA(VLOOKUP(F10, $N$7:$Q$10, 4, FALSE)), \"-.---\", VLOOKUP(F10, $N$7:$Q$10, 4, FALSE))","v":"-.---"},{"$f":"MAX(G10,$J$11)","v":16},{"$f":"MIN(I10,$K$11)","v":5.2530000000000001},null,null,"Y",null,null,null,null,8,{"$f":"$D$12","v":"blank"},{"$f":"$E$12","v":0},{"$f":"$K$12","v":0},-5.0940000000000003,null,8,{"$f":"$D$12","v":"blank"},{"$f":"$E$12","v":0},{"$f":"$J$12","v":0},22]
["-","C",7,{"$f":"'Qualifying results'!$B$9","v":"Callum N"},{"$f":"'Qualifying results'!$C$9","v":0},null,{"$f":"IF(ISNA(VLOOKUP(F11, $N$11:$Q$14, 2, FALSE)), 0, VLOOKUP(F11, $N$11:$Q$14, 2, FALSE)+VLOOKUP(F11, $N$11:$Q$14, 3, FALSE)/10)","v":0},null,{"$f":"IF(ISNA(VLOOKUP(F11, $N$11:$Q$14, 4, FALSE)), \"-.---\", VLOOKUP(F11, $N$11:$Q$14, 4, FALSE))","v":"-.---"},{"$f":"MAX(G11,'Qualifying results'!$J$9,'Qualifying results'!$H$9,'Qualifying results'!$F$9,'Qualifying results'!$D$9)","v":16},{"$f":"MIN(I11,'Qualifying results'!$K$9,'Qualifying results'!$I$9,'Qualifying results'!$G$9,'Qualifying results'!$E$9)","v":5.2530000000000001},null,"C Final","W",null,null,null,null,9,{"$f":"$D$13","v":0},{"$f":"$E$13","v":0},{"$f":"$K$13","v":0},-5.0940000000000003,null,9,{"$f":"$D$13","v":0},{"$f":"$E$13","v":0},{"$f":"$J$13","v":0},22]
[8,"C",8,{"$f":"'Qualifying results'!$B$10","v":"blank"},{"$f":"'Qualifying results'!$C$10","v":0},null,{"$f":"IF(ISNA(VLOOKUP(F12, $N$11:$Q$14, 2, FALSE)), 0, VLOOKUP(F12, $N$11:$Q$14, 2, FALSE)+VLOOKUP(F12, $N$11:$Q$14, 3, FALSE)/10)","v":0},null,{"$f":"IF(ISNA(VLOOKUP(F12, $N$11:$Q$14, 4, FALSE)), \"-.---\", VLOOKUP(F12, $N$11:$Q$14, 4, FALSE))","v":"-.---"},{"$f":"MAX(G12,'Qualifying results'!$J$10,'Qualifying results'!$H$10,'Qualifying results'!$F$10,'Qualifying results'!$D$10)","v":0},{"$f":"MIN(I12,'Qualifying results'!$K$10,'Qualifying results'!$I$10,'Qualifying results'!$G$10,'Qualifying results'!$E$10)","v":0},null,null,"B",null,null,null,null,10,{"$f":"$D$14","v":0},{"$f":"$E$14","v":0},{"$f":"$K$14","v":0},-5.0940000000000003,null,10,{"$f":"$D$14","v":0},{"$f":"$E$14","v":0},{"$f":"$J$14","v":0},22]
[9,"C",9,{"$f":"'Qualifying results'!$B$11","v":0},{"$f":"'Qualifying results'!$C$11","v":0},null,{"$f":"IF(ISNA(VLOOKUP(F13, $N$11:$Q$14, 2, FALSE)), 0, VLOOKUP(F13, $N$11:$Q$14, 2, FALSE)+VLOOKUP(F13, $N$11:$Q$14, 3, FALSE)/10)","v":0},null,{"$f":"IF(ISNA(VLOOKUP(F13, $N$11:$Q$14, 4, FALSE)), \"-.---\", VLOOKUP(F13, $N$11:$Q$14, 4, FALSE))","v":"-.---"},{"$f":"MAX(G13,'Qualifying results'!$J$11,'Qualifying results'!$H$11,'Qualifying results'!$F$11,'Qualifying results'!$D$11)","v":0},{"$f":"MIN(I13,'Qualifying results'!$K$11,'Qualifying results'!$I$11,'Qualifying results'!$G$11,'Qualifying results'!$E$11)","v":0},null,null,"R",null,null,null,null,11,{"$f":"$D$16","v":0},{"$f":"$E$16","v":0},{"$f":"$K$16","v":0},-5.0940000000000003,null,11,{"$f":"$D$16","v":0},{"$f":"$E$16","v":0},{"$f":"$J$16","v":0},22]
[10,"C",{"$f":"$C$15","v":10},{"$f":"$D$15","v":0},{"$f":"$E$15","v":0},null,{"$f":"IF(ISNA(VLOOKUP(F14, $N$11:$Q$14, 2, FALSE)), 0, VLOOKUP(F14, $N$11:$Q$14, 2, FALSE)+VLOOKUP(F14, $N$11:$Q$14, 3, FALSE)/10)","v":0},null,{"$f":"IF(ISNA(VLOOKUP(F14, $N$11:$Q$14, 4, FALSE)), \"-.---\", VLOOKUP(F14, $N$11:$Q$14, 4, FALSE))","v":"-.---"},{"$f":"MAX(G14,$J$15)","v":0},{"$f":"MIN(I14,$K$15)","v":0},null,null,"Y",null,null,null,null,12,{"$f":"$D$17","v":0},{"$f":"$E$17","v":0},{"$f":"$K$17","v":0},-5.0940000000000003,null,12,{"$f":"$D$17","v":0},{"$f":"$E$17","v":0},{"$f":"$J$17","v":0},22]
["-","D",10,{"$f":"'Qualifying results'!$B$12","v":0},{"$f":"'Qualifying results'!$C$12","v":0},null,{"$f":"IF(ISNA(VLOOKUP(F15, $N$15:$Q$18, 2, FALSE)), 0, VLOOKUP(F15, $N$15:$Q$18, 2, FALSE)+VLOOKUP(F15, $N$15:$Q$18, 3, FALSE)/10)","v":0},null,{"$f":"IF(ISNA(VLOOKUP(F15, $N$15:$Q$18, 4, FALSE)), \"-.---\", VLOOKUP(F15, $N$15:$Q$18, 4, FALSE))","v":"-.---"},{"$f":"MAX(G15,'Qualifying results'!$J$12,'Qualifying results'!$H$12,'Qualifying results'!$F$12,'Qualifying results'!$D$12)","v":0},{"$f":"MIN(I15,'Qualifying results'!$K$12,'Qualifying results'!$I$12,'Qualifying results'!$G$12,'Qualifying results'!$E$12)","v":0},null,"D Final","W",null,null,null,null,13,{"$f":"$D$18","v":0},{"$f":"$E$18","v":0},{"$f":"$K$18","v":0},-5.0940000000000003,null,13,{"$f":"$D$18","v":0},{"$f":"$E$18","v":0},{"$f":"$J$18","v":0},22]
[11,"D",11,{"$f":"'Qualifying results'!$B$13","v":0},{"$f":"'Qualifying results'!$C$13","v":0},null,{"$f":"IF(ISNA(VLOOKUP(F16, $N$15:$Q$18, 2, FALSE)), 0, VLOOKUP(F16, $N$15:$Q$18, 2, FALSE)+VLOOKUP(F16, $N$15:$Q$18, 3, FALSE)/10)","v":0},null,{"$f":"IF(ISNA(VLOOKUP(F16, $N$15:$Q$18, 4, FALSE)), \"-.---\", VLOOKUP(F16, $N$15:$Q$18, 4, FALSE))","v":"-.---"},{"$f":"MAX(G16,'Qualifying results'!$J$13,'Qualifying results'!$H$13,'Qualifying results'!$F$13,'Qualifying results'!$D$13)","v":0},{"$f":"MIN(I16,'Qualifying results'!$K$13,'Qualifying results'!$I$13,'Qualifying results'!$G$13,'Qualifying results'!$E$13)","v":0},null,null,"B",null,null,null,null,14,{"$f":"$D$20","v":0},{"$f":"$E$20","v":0},{"$f":"$K$20","v":0},-5.0940000000000003,null,14,{"$f":"$D$20","v":0},{"$f":"$E$20","v":0},{"$f":"$J$20","v":0},22]
[12,"D",12,{"$f":"'Qualifying results'!$B$14","v":0},{"$f":"'Qualifying results'!$C$14","v":0},null,{"$f":"IF(ISNA(VLOOKUP(F17, $N$15:$Q$18, 2, FALSE)), 0, VLOOKUP(F17, $N$15:$Q$18, 2, FALSE)+VLOOKUP(F17, $N$15:$Q$18, 3, FALSE)/10)","v":0},null,{"$f":"IF(ISNA(VLOOKUP(F17, $N$15:$Q$18, 4, FALSE)), \"-.---\", VLOOKUP(F17, $N$15:$Q$18, 4, FALSE))","v":"-.---"},{"$f":"MAX(G17,'Qualifying results'!$J$14,'Qualifying results'!$H$14,'Qualifying results'!$F$14,'Qualifying results'!$D$14)","v":0},{"$f":"MIN(I17,'Qualifying results'!$K$14,'Qualifying results'!$I$14,'Qualifying results'!$G$14,'Qualifying results'!$E$14)","v":0},null,null,"R",null,null,null,null,15,{"$f":"$D$21","v":0},{"$f":"$E$21","v":0},{"$f":"$K$21","v":0},-5.0940000000000003,null,15,{"$f":"$D$21","v":0},{"$f":"$E$21","v":0},{"$f":"$J$21","v":0},22]
[13,"D",{"$f":"$C$19","v":13},{"$f":"$D$19","v":0},{"$f":"$E$19","v":0},null,{"$f":"IF(ISNA(VLOOKUP(F18, $N$15:$Q$18, 2, FALSE)), 0, VLOOKUP(F18, $N$15:$Q$18, 2, FALSE)+VLOOKUP(F18, $N$15:$Q$18, 3, FALSE)/10)","v":0},null,{"$f":"IF(ISNA(VLOOKUP(F18, $N$15:$Q$18, 4, FALSE)), \"-.---\", VLOOKUP(F18, $N$15:$Q$18, 4, FALSE))","v":"-.---"},{"$f":"MAX(G18,$J$19)","v":0},{"$f":"MIN(I18,$K$19)","v":0},null,null,"Y",null,null,null,null,16,{"$f":"$D$22","v":0},{"$f":"$E$22","v":0},{"$f":"$K$22","v":0},-5.0940000000000003,null,16,{"$f":"$D$22","v":0},{"$f":"$E$22","v":0},{"$f":"$J$22","v":0},22]
["-","E",13,{"$f":"'Qualifying results'!$B$15","v":0},{"$f":"'Qualifying results'!$C$15","v":0},null,{"$f":"IF(ISNA(VLOOKUP(F19, $N$19:$Q$22, 2, FALSE)), 0, VLOOKUP(F19, $N$19:$Q$22, 2, FALSE)+VLOOKUP(F19, $N$19:$Q$22, 3, FALSE)/10)","v":0},null,{"$f":"IF(ISNA(VLOOKUP(F19, $N$19:$Q$22, 4, FALSE)), \"-.---\", VLOOKUP(F19, $N$19:$Q$22, 4, FALSE))","v":"-.---"},{"$f":"MAX(G19,'Qualifying results'!$J$15,'Qualifying results'!$H$15,'Qualifying results'!$F$15,'Qualifying results'!$D$15)","v":0},{"$f":"MIN(I19,'Qualifying results'!$K$15,'Qualifying results'!$I$15,'Qualifying results'!$G$15,'Qualifying results'!$E$15)","v":0},null,"E Final","W",null,null,null,null,17,{"$f":"$D$24","v":0},{"$f":"$E$24","v":0},{"$f":"$K$24","v":0},-5.0940000000000003,null,17,{"$f":"$D$24","v":0},{"$f":"$E$24","v":0},{"$f":"$J$24","v":0},22]
[14,"E",14,{"$f":"'Qualifying results'!$B$16","v":0},{"$f":"'Qualifying results'!$C$16","v":0},null,{"$f":"IF(ISNA(VLOOKUP(F20, $N$19:$Q$22, 2, FALSE)), 0, VLOOKUP(F20, $N$19:$Q$22, 2, FALSE)+VLOOKUP(F20, $N$19:$Q$22, 3, FALSE)/10)","v":0},null,{"$f":"IF(ISNA(VLOOKUP(F20, $N$19:$Q$22, 4, FALSE)), \"-.---\", VLOOKUP(F20, $N$19:$Q$22, 4, FALSE))","v":"-.---"},{"$f":"MAX(G20,'Qualifying results'!$J$16,'Qualifying results'!$H$16,'Qualifying results'!$F$16,'Qualifying results'!$D$16)","v":0},{"$f":"MIN(I20,'Qualifying results'!$K$16,'Qualifying results'!$I$16,'Qualifying results'!$G$16,'Qualifying results'!$E$16)","v":0},null,null,"B",null,null,null,null,18,{"$f":"$D$25","v":0},{"$f":"$E$25","v":0},{"$f":"$K$25","v":0},-5.0940000000000003,null,18,{"$f":"$D$25","v":0},{"$f":"$E$25","v":0},{"$f":"$J$25","v":0},22]
[15,"E",15,{"$f":"'Qualifying results'!$B$17","v":0},{"$f":"'Qualifying results'!$C$17","v":0},null,{"$f":"IF(ISNA(VLOOKUP(F21, $N$19:$Q$22, 2, FALSE)), 0, VLOOKUP(F21, $N$19:$Q$22, 2, FALSE)+VLOOKUP(F21, $N$19:$Q$22, 3, FALSE)/10)","v":0},null,{"$f":"IF(ISNA(VLOOKUP(F21, $N$19:$Q$22, 4, FALSE)), \"-.---\", VLOOKUP(F21, $N$19:$Q$22, 4, FALSE))","v":"-.---"},{"$f":"MAX(G21,'Qualifying results'!$J$17,'Qualifying results'!$H$17,'Qualifying results'!$F$17,'Qualifying results'!$D$17)","v":0},{"$f":"MIN(I21,'Qualifying results'!$K$17,'Qualifying results'!$I$17,'Qualifying results'!$G$17,'Qualifying results'!$E$17)","v":0},null,null,"R",null,null,null,null,19,{"$f":"$D$26","v":0},{"$f":"$E$26","v":0},{"$f":"$K$26","v":0},-5.0940000000000003,null,19,{"$f":"$D$26","v":0},{"$f":"$E$26","v":0},{"$f":"$J$26","v":0},22]
[16,"E",{"$f":"$C$23","v":16},{"$f":"$D$23","v":0},{"$f":"$E$23","v":0},null,{"$f":"IF(ISNA(VLOOKUP(F22, $N$19:$Q$22, 2, FALSE)), 0, VLOOKUP(F22, $N$19:$Q$22, 2, FALSE)+VLOOKUP(F22, $N$19:$Q$22, 3, FALSE)/10)","v":0},null,{"$f":"IF(ISNA(VLOOKUP(F22, $N$19:$Q$22, 4, FALSE)), \"-.---\", VLOOKUP(F22, $N$19:$Q$22, 4, FALSE))","v":"-.---"},{"$f":"MAX(G22,$J$23)","v":0},{"$f":"MIN(I22,$K$23)","v":0},null,null,"Y",null,null,null,null,20,{"$f":"$D$28","v":0},{"$f":"$E$28","v":0},{"$f":"$K$28","v":0},-5.0940000000000003,null,20,{"$f":"$D$28","v":0},{"$f":"$E$28","v":0},{"$f":"$J$28","v":0},22]
["-","F",16,{"$f":"'Qualifying results'!$B$18","v":0},{"$f":"'Qualifying results'!$C$18","v":0},null,{"$f":"IF(ISNA(VLOOKUP(F23, $N$23:$Q$26, 2, FALSE)), 0, VLOOKUP(F23, $N$23:$Q$26, 2, FALSE)+VLOOKUP(F23, $N$23:$Q$26, 3, FALSE)/10)","v":0},null,{"$f":"IF(ISNA(VLOOKUP(F23, $N$23:$Q$26, 4, FALSE)), \"-.---\", VLOOKUP(F23, $N$23:$Q$26, 4, FALSE))","v":"-.---"},{"$f":"MAX(G23,'Qualifying results'!$J$18,'Qualifying results'!$H$18,'Qualifying results'!$F$18,'Qualifying results'!$D$18)","v":0},{"$f":"MIN(I23,'Qualifying results'!$K$18,'Qualifying results'!$I$18,'Qualifying results'!$G$18,'Qualifying results'!$E$18)","v":0},null,"F Final","W",null,null,null,null,21,{"$f":"$D$29","v":0},{"$f":"$E$29","v":0},{"$f":"$K$29","v":0},-5.0940000000000003,null,21,{"$f":"$D$29","v":0},{"$f":"$E$29","v":0},{"$f":"$J$29","v":0},22]
[17,"F",17,{"$f":"'Qualifying results'!$B$19","v":0},{"$f":"'Qualifying results'!$C$19","v":0},null,{"$f":"IF(ISNA(VLOOKUP(F24, $N$23:$Q$26, 2, FALSE)), 0, VLOOKUP(F24, $N$23:$Q$26, 2, FALSE)+VLOOKUP(F24, $N$23:$Q$26, 3, FALSE)/10)","v":0},null,{"$f":"IF(ISNA(VLOOKUP(F24, $N$23:$Q$26, 4, FALSE)), \"-.---\", VLOOKUP(F24, $N$23:$Q$26, 4, FALSE))","v":"-.---"},{"$f":"MAX(G24,'Qualifying results'!$J$19,'Qualifying results'!$H$19,'Qualifying results'!$F$19,'Qualifying results'!$D$19)","v":0},{"$f":"MIN(I24,'Qualifying results'!$K$19,'Qualifying results'!$I$19,'Qualifying results'!$G$19,'Qualifying results'!$E$19)","v":0},null,null,"B",null,null,null,null,22,{"$f":"$D$30","v":0},{"$f":"$E$30","v":0},{"$f":"$K$30","v":0},-5.0940000000000003,null,22,{"$f":"$D$30","v":0},{"$f":"$E$30","v":0},{"$f":"$J$30","v":0},22]
[18,"F",18,{"$f":"'Qualifying results'!$B$20","v":0},{"$f":"'Qualifying results'!$C$20","v":0},null,{"$f":"IF(ISNA(VLOOKUP(F25, $N$23:$Q$26, 2, FALSE)), 0, VLOOKUP(F25, $N$23:$Q$26, 2, FALSE)+VLOOKUP(F25, $N$23:$Q$26, 3, FALSE)/10)","v":0},null,{"$f":"IF(ISNA(VLOOKUP(F25, $N$23:$Q$26, 4, FALSE)), \"-.---\", VLOOKUP(F25, $N$23:$Q$26, 4, FALSE))","v":"-.---"},{"$f":"MAX(G25,'Qualifying results'!$J$20,'Qualifying results'!$H$20,'Qualifying results'!$F$20,'Qualifying results'!$D$20)","v":0},{"$f":"MIN(I25,'Qualifying results'!$K$20,'Qualifying results'!$I$20,'Qualifying results'!$G$20,'Qualifying results'!$E$20)","v":0},null,null,"R"]
[19,"F",{"$f":"$C$27","v":19},{"$f":"$D$27","v":0},{"$f":"$E$27","v":0},null,{"$f":"IF(ISNA(VLOOKUP(F26, $N$23:$Q$26, 2, FALSE)), 0, VLOOKUP(F26, $N$23:$Q$26, 2, FALSE)+VLOOKUP(F26, $N$23:$Q$26, 3, FALSE)/10)","v":0},null,{"$f":"IF(ISNA(VLOOKUP(F26, $N$23:$Q$26, 4, FALSE)), \"-.---\", VLOOKUP(F26, $N$23:$Q$26, 4, FALSE))","v":"-.---"},{"$f":"MAX(G26,$J$27)","v":0},{"$f":"MIN(I26,$K$27)","v":0},null,null,"Y"]
["-","G",19,{"$f":"'Qualifying results'!$B$21","v":0},{"$f":"'Qualifying results'!$C$21","v":0},null,{"$f":"IF(ISNA(VLOOKUP(F27, $N$27:$Q$30, 2, FALSE)), 0, VLOOKUP(F27, $N$27:$Q$30, 2, FALSE)+VLOOKUP(F27, $N$27:$Q$30, 3, FALSE)/10)","v":0},null,{"$f":"IF(ISNA(VLOOKUP(F27, $N$27:$Q$30, 4, FALSE)), \"-.---\", VLOOKUP(F27, $N$27:$Q$30, 4, FALSE))","v":"-.---"},{"$f":"MAX(G27,'Qualifying results'!$J$21,'Qualifying results'!$H$21,'Qualifying results'!$F$21,'Qualifying results'!$D$21)","v":0},{"$f":"MIN(I27,'Qualifying results'!$K$21,'Qualifying results'!$I$21,'Qualifying results'!$G$21,'Qualifying results'!$E$21)","v":0},null,"G Final","W"]
[20,"G",20,{"$f":"'Qualifying results'!$B$22","v":0},{"$f":"'Qualifying results'!$C$22","v":0},null,{"$f":"IF(ISNA(VLOOKUP(F28, $N$27:$Q$30, 2, FALSE)), 0, VLOOKUP(F28, $N$27:$Q$30, 2, FALSE)+VLOOKUP(F28, $N$27:$Q$30, 3, FALSE)/10)","v":0},null,{"$f":"IF(ISNA(VLOOKUP(F28, $N$27:$Q$30, 4, FALSE)), \"-.---\", VLOOKUP(F28, $N$27:$Q$30, 4, FALSE))","v":"-.---"},{"$f":"MAX(G28,'Qualifying results'!$J$22,'Qualifying results'!$H$22,'Qualifying results'!$F$22,'Qualifying results'!$D$22)","v":0},{"$f":"MIN(I28,'Qualifying results'!$K$22,'Qualifying results'!$I$22,'Qualifying results'!$G$22,'Qualifying results'!$E$22)","v":0},null,null,"B"]
[21,"G",21,{"$f":"'Qualifying results'!$B$23","v":0},{"$f":"'Qualifying results'!$C$23","v":0},null,{"$f":"IF(ISNA(VLOOKUP(F29, $N$27:$Q$30, 2, FALSE)), 0, VLOOKUP(F29, $N$27:$Q$30, 2, FALSE)+VLOOKUP(F29, $N$27:$Q$30, 3, FALSE)/10)","v":0},null,{"$f":"IF(ISNA(VLOOKUP(F29, $N$27:$Q$30, 4, FALSE)), \"-.---\", VLOOKUP(F29, $N$27:$Q$30, 4, FALSE))","v":"-.---"},{"$f":"MAX(G29,'Qualifying results'!$J$23,'Qualifying results'!$H$23,'Qualifying results'!$F$23,'Qualifying results'!$D$23)","v":0},{"$f":"MIN(I29,'Qualifying results'!$K$23,'Qualifying results'!$I$23,'Qualifying results'!$G$23,'Qualifying results'!$E$23)","v":0},null,null,"R"]
[22,"G",22,{"$f":"'Qualifying results'!$B$24","v":0},{"$f":"'Qualifying results'!$C$24","v":0},null,{"$f":"IF(ISNA(VLOOKUP(F30, $N$27:$Q$30, 2, FALSE)), 0, VLOOKUP(F30, $N$27:$Q$30, 2, FALSE)+VLOOKUP(F30, $N$27:$Q$30, 3, FALSE)/10)","v":0},null,{"$f":"IF(ISNA(VLOOKUP(F30, $N$27:$Q$30, 4, FALSE)), \"-.---\", VLOOKUP(F30, $N$27:$Q$30, 4, FALSE))","v":"-.---"},{"$f":"MAX(G30,'Qualifying results'!$J$24,'Qualifying results'!$H$24,'Qualifying results'!$F$24,'Qualifying results'!$D$24)","v":0},{"$f":"MIN(I30,'Qualifying results'!$K$24,'Qualifying results'!$I$24,'Qualifying results'!$G$24,'Qualifying results'!$E$24)","v":0},null,null,"Y"]

{"sheet":"Settings","index":3,"n_rows":6,"n_cols":2,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["Lanes",{"$f":"COUNTIF(A3:A10,\"*\")","v":4}]
["Colours"]
["White"]
["Blue "]
["Red"]
["Yellow"]