{"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":95,"n_cols":12,"rows_kept":95,"cut":false,"hidden":false,"merged":[]}
["Drivers per heat",4,null,null,"Driver","Lane","Laps","Hundredths","Best lap"]
["Drivers",{"$f":"COUNTIF(A5:A99,\"*\")","v":15},null,null,"Clive H","White",25,10,6.1180000000000003]
[null,null,null,null,"Callum N","Blue ",28,25,5.1779999999999999]
["Names","Class",null,null,"Deane W","Red",27,10,5.79]
["Clive H","Nascar",null,null,"Andy W","Yellow",26,65,5.5620000000000003]
["Callum N","CW"]
["Deane W","LMP",null,null,"Driver","Lane","Laps","Hundredths","Best lap"]
["Andy W","LMP",null,null,"Callum N","White",22,10,5.766]
["Dave H","CW",null,null,"Clive H","Blue ",28,55,5.7140000000000004]
["Al T","Nascar",null,null,"Andy W","Red",26,10,5.7350000000000003]
["Al W","CW",null,null,"Deane W","Yellow",25,10,6.1520000000000001]
["Tony S","Nascar"]
["Mike D","Nascar",null,null,"Driver","Lane","Laps","Hundredths","Best lap"]
["Henry T","LMP",null,null,"Mike R","White",20,75,6.8319999999999999,20,75,6.8319999999999999]
["Louis T","LMP",null,null,"Bob S","Blue ",6,60,10.244,6,60,10.244]
["Mike R","Nascar",null,null,"Ray G","Red",25,85,6.2069999999999999]
["Bob S","Nascar",null,null,"Marc T","Yellow",12,0,7.0010000000000003]
["Ray G","CW"]
["Marc T","LMP",null,null,"Driver","Lane","Laps","Hundredths","Best lap"]
[null,null,null,null,"Bob S","White",21,80,6.6539999999999999,21,80,6.6539999999999999]
[null,null,null,null,"Mike R","Blue ",19,15,7.7679999999999998,19,15,7.7679999999999998]
[null,null,null,null,"Marc T","Red",27,75,6.0119999999999996]
[null,null,null,null,"Ray G","Yellow",23,65,6.633]
[]
[null,null,null,null,"Driver","Lane","Laps","Hundredths","Best lap"]
[null,null,null,null,"Tony S","White",23,25,6.3659999999999997]
[null,null,null,null,"Mike D","Blue ",31,25,5.4870000000000001]
[null,null,null,null,"Henry T","Red",23,75,6.7839999999999998]
[null,null,null,null,"Louis T","Yellow",15,60,9.2959999999999994]
[]
[null,null,null,null,"Driver","Lane","Laps","Hundredths","Best lap"]
[null,null,null,null,"Mike D","White",29,20,5.5869999999999997]
[null,null,null,null,"Tony S","Blue ",24,80,5.8570000000000002]
[null,null,null,null,"Louis T","Red",18,60,7.4980000000000002]
[null,null,null,null,"Henry T","Yellow",19,50,7.6929999999999996]
[]
[null,null,null,null,"Driver","Lane","Laps","Hundredths","Best lap"]
[null,null,null,null,"Andy W","White",28,95,5.5579999999999998]
[null,null,null,null,"Dave H","Blue ",33,5,5.0279999999999996]
[null,null,null,null,"Al T","Red",24,45,5.8840000000000003]
[null,null,null,null,"Al W","Yellow",29,30,5.1189999999999998]
[]
[null,null,null,null,"Driver","Lane","Laps","Hundredths","Best lap"]
[null,null,null,null,"Dave H","White",28,85,5.3179999999999996]
[null,null,null,null,"Andy W","Blue ",31,30,5.2069999999999999]
[null,null,null,null,"Al W","Red",32,50,4.7089999999999996]
[null,null,null,null,"Al T","Yellow",20,20,6.8680000000000003]
[]
[null,null,null,null,"Driver","Lane","Laps","Hundredths","Best lap"]
[null,null,null,null,"Marc T","White",26,70,5.75]
[null,null,null,null,"Deane W","Blue ",26,65,5.7859999999999996]
[null,null,null,null,"Clive H","Red",26,85,5.8579999999999997]
[null,null,null,null,"Callum N","Yellow",23,85,5.9859999999999998]
[]
[null,null,null,null,"Driver","Lane","Laps","Hundredths","Best lap"]
[null,null,null,null,"Deane W","White",27,75,5.97]
[null,null,null,null,"Marc T","Blue ",29,35,5.72]
[null,null,null,null,"Callum N","Red",26,30,5.48]
[null,null,null,null,"Clive H","Yellow",17,55,6.5990000000000002]
[]
[null,null,null,null,"Driver","Lane","Laps","Hundredths","Best lap"]
[null,null,null,null,"Louis T","White",16,10,7.6]
[null,null,null,null,"Ray G","Blue ",21,80,6.4420000000000002]
[null,null,null,null,"Mike R","Red",20,30,6.3090000000000002]
[null,null,null,null,"Bob S","Yellow",14,35,7.9690000000000003]
[]
[null,null,null,null,"Driver","Lane","Laps","Hundredths","Best lap"]
[null,null,null,null,"Ray G","White",23,65,6.4550000000000001]
[null,null,null,null,"Louis T","Blue ",19,15,7.3609999999999998]
[null,null,null,null,"Bob S","Red",19,55,7.1340000000000003]
[null,null,null,null,"Mike R","Yellow",20,90,6.9980000000000002]
[]
[null,null,null,null,"Driver","Lane","Laps","Hundredths","Best lap"]
[null,null,null,null,"Al W","White",31,75,5.0940000000000003]
[null,null,null,null,null,"Blue ",0,null,"-.---"]
[null,null,null,null,"Tony S","Red",25,90,5.8470000000000004]
[null,null,null,null,"Mike D","Yellow",26,75,5.74]
[]
[null,null,null,null,"Driver","Lane","Laps","Hundredths","Best lap"]
[null,null,null,null,null,"White",0,null,"-.---"]
[null,null,null,null,"Al W","Blue ",32,50,4.8259999999999996]
[null,null,null,null,"Mike D","Red",27,50,5.5380000000000003]
[null,null,null,null,"Tony S","Yellow",22,90,6.4580000000000002]
[]
[null,null,null,null,"Driver","Lane","Laps","Hundredths","Best lap"]
[null,null,null,null,"Al T","White",25,10,6.2279999999999998]
[null,null,null,null,"Henry T","Blue ",25,30,6.0880000000000001]
[null,null,null,null,"Dave H","Red",29,5,5.1879999999999997]
[null,null,null,null,null,"Yellow",0,null,"-.---"]
[]
[null,null,null,null,"Driver","Lane","Laps","Hundredths","Best lap"]
[null,null,null,null,"Henry T","White",20,5,6.952]
[null,null,null,null,"Al T","Blue ",26,80,5.8710000000000004]
[null,null,null,null,null,"Red",0,null,"-.---"]
[null,null,null,null,"Dave H","Yellow",23,40,5.9329999999999998]

{"sheet":"Qualifying results","index":1,"n_rows":33,"n_cols":16,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
[null,null,null,"White",null,"Blue",null,"Red",null,"Yellow",null,"Overall"]
["P",null,{"$f":"Heats!$B$4","v":"Class"},"Laps","Best lap","Laps","Best lap","Laps","Best lap","Laps","Best lap","Total","Drop","Best 3","Gap","Best lap"]
[1,"Al W",{"$f":"Heats!$B$11","v":"CW"},{"$f":"Heats!$G$74+Heats!$H$74/100","v":31.75},{"$f":"Heats!$I$74","v":5.0940000000000003},{"$f":"Heats!$G$81+Heats!$H$81/100","v":32.5},{"$f":"Heats!$I$81","v":4.8259999999999996},{"$f":"Heats!$G$46+Heats!$H$46/100","v":32.5},{"$f":"Heats!$I$46","v":4.7089999999999996},{"$f":"Heats!$G$41+Heats!$H$41/100","v":29.3},{"$f":"Heats!$I$41","v":5.1189999999999998},{"$f":"D3+F3+H3+J3","v":126.05},{"$f":"MIN(D3,F3,H3,J3)","v":29.3},{"$f":"L3-M3","v":96.75},null,{"$f":"IF(MIN(E3,G3,I3,K3)=0, \"-.---\", MIN(E3,G3,I3,K3))","v":4.7089999999999996}]
[2,"Dave H",{"$f":"Heats!$B$9","v":"CW"},{"$f":"Heats!$G$44+Heats!$H$44/100","v":28.85},{"$f":"Heats!$I$44","v":5.3179999999999996},{"$f":"Heats!$G$39+Heats!$H$39/100","v":33.049999999999997},{"$f":"Heats!$I$39","v":5.0279999999999996},{"$f":"Heats!$G$88+Heats!$H$88/100","v":29.05},{"$f":"Heats!$I$88","v":5.1879999999999997},{"$f":"Heats!$G$95+Heats!$H$95/100","v":23.4},{"$f":"Heats!$I$95","v":5.9329999999999998},{"$f":"D4+F4+H4+J4","v":114.35},{"$f":"MIN(D4,F4,H4,J4)","v":23.4},{"$f":"L4-M4","v":90.949999999999989},{"$f":"N3-N4","v":5.8000000000000114},{"$f":"IF(MIN(E4,G4,I4,K4)=0, \"-.---\", MIN(E4,G4,I4,K4))","v":5.0279999999999996}]
[3,"Callum N",{"$f":"Heats!$B$6","v":"CW"},{"$f":"Heats!$G$8+Heats!$H$8/100","v":22.1},{"$f":"Heats!$I$8","v":5.766},{"$f":"Heats!$G$3+Heats!$H$3/100","v":28.25},{"$f":"Heats!$I$3","v":5.1779999999999999},{"$f":"Heats!$G$58+Heats!$H$58/100","v":26.3},{"$f":"Heats!$I$58","v":5.48},{"$f":"Heats!$G$53+Heats!$H$53/100","v":23.85},{"$f":"Heats!$I$53","v":5.9859999999999998},{"$f":"D5+F5+H5+J5","v":100.5},{"$f":"MIN(D5,F5,H5,J5)","v":22.1},{"$f":"L5-M5","v":78.400000000000006},{"$f":"N3-N5","v":18.349999999999994},{"$f":"IF(MIN(E5,G5,I5,K5)=0, \"-.---\", MIN(E5,G5,I5,K5))","v":5.1779999999999999}]
[4,"Ray G",{"$f":"Heats!$B$18","v":"CW"},{"$f":"Heats!$G$68+Heats!$H$68/100","v":23.65},{"$f":"Heats!$I$68","v":6.4550000000000001},{"$f":"Heats!$G$63+Heats!$H$63/100","v":21.8},{"$f":"Heats!$I$63","v":6.4420000000000002},{"$f":"Heats!$G$16+Heats!$H$16/100","v":25.85},{"$f":"Heats!$I$16","v":6.2069999999999999},{"$f":"Heats!$G$23+Heats!$H$23/100","v":23.65},{"$f":"Heats!$I$23","v":6.633},{"$f":"D6+F6+H6+J6","v":94.950000000000017},{"$f":"MIN(D6,F6,H6,J6)","v":21.8},{"$f":"L6-M6","v":73.15000000000002},{"$f":"N3-N6","v":23.59999999999998},{"$f":"IF(MIN(E6,G6,I6,K6)=0, \"-.---\", MIN(E6,G6,I6,K6))","v":6.2069999999999999}]
[5,"blank","CW",null,null,null,null,null,null,null,null,{"$f":"D7+F7+H7+J7","v":0},{"$f":"MIN(D7,F7,H7,J7)","v":0},{"$f":"L7-M7","v":0},{"$f":"N3-N7","v":96.75},{"$f":"IF(MIN(E7,G7,I7,K7)=0, \"-.---\", MIN(E7,G7,I7,K7))","v":"-.---"}]
[6,"blank","CW",null,null,null,null,null,null,null,null,{"$f":"D8+F8+H8+J8","v":0},{"$f":"MIN(D8,F8,H8,J8)","v":0},{"$f":"L8-M8","v":0},{"$f":"N3-N8","v":96.75},{"$f":"IF(MIN(E8,G8,I8,K8)=0, \"-.---\", MIN(E8,G8,I8,K8))","v":"-.---"}]
[7,"Andy W",{"$f":"Heats!$B$8","v":"LMP"},{"$f":"Heats!$G$38+Heats!$H$38/100","v":28.95},{"$f":"Heats!$I$38","v":5.5579999999999998},{"$f":"Heats!$G$45+Heats!$H$45/100","v":31.3},{"$f":"Heats!$I$45","v":5.2069999999999999},{"$f":"Heats!$G$10+Heats!$H$10/100","v":26.1},{"$f":"Heats!$I$10","v":5.7350000000000003},{"$f":"Heats!$G$5+Heats!$H$5/100","v":26.65},{"$f":"Heats!$I$5","v":5.5620000000000003},{"$f":"D9+F9+H9+J9","v":113},{"$f":"MIN(D9,F9,H9,J9)","v":26.1},{"$f":"L9-M9","v":86.9},{"$f":"N3-N9","v":9.8499999999999943},{"$f":"IF(MIN(E9,G9,I9,K9)=0, \"-.---\", MIN(E9,G9,I9,K9))","v":5.2069999999999999}]
[8,"Marc T",{"$f":"Heats!$B$19","v":"LMP"},{"$f":"Heats!$G$50+Heats!$H$50/100","v":26.7},{"$f":"Heats!$I$50","v":5.75},{"$f":"Heats!$G$57+Heats!$H$57/100","v":29.35},{"$f":"Heats!$I$57","v":5.72},{"$f":"Heats!$G$22+Heats!$H$22/100","v":27.75},{"$f":"Heats!$I$22","v":6.0119999999999996},{"$f":"Heats!$G$17+Heats!$H$17/100","v":12},{"$f":"Heats!$I$17","v":7.0010000000000003},{"$f":"D10+F10+H10+J10","v":95.8},{"$f":"MIN(D10,F10,H10,J10)","v":12},{"$f":"L10-M10","v":83.8},{"$f":"N3-N10","v":12.950000000000003},{"$f":"IF(MIN(E10,G10,I10,K10)=0, \"-.---\", MIN(E10,G10,I10,K10))","v":5.72}]
[9,"Deane W",{"$f":"Heats!$B$7","v":"LMP"},{"$f":"Heats!$G$56+Heats!$H$56/100","v":27.75},{"$f":"Heats!$I$56","v":5.97},{"$f":"Heats!$G$51+Heats!$H$51/100","v":26.65},{"$f":"Heats!$I$51","v":5.7859999999999996},{"$f":"Heats!$G$4+Heats!$H$4/100","v":27.1},{"$f":"Heats!$I$4","v":5.79},{"$f":"Heats!$G$11+Heats!$H$11/100","v":25.1},{"$f":"Heats!$I$11","v":6.1520000000000001},{"$f":"D11+F11+H11+J11","v":106.6},{"$f":"MIN(D11,F11,H11,J11)","v":25.1},{"$f":"L11-M11","v":81.5},{"$f":"N3-N11","v":15.25},{"$f":"IF(MIN(E11,G11,I11,K11)=0, \"-.---\", MIN(E11,G11,I11,K11))","v":5.7859999999999996}]
[10,"Henry T",{"$f":"Heats!$B$14","v":"LMP"},{"$f":"Heats!$G$92+Heats!$H$92/100","v":20.05},{"$f":"Heats!$I$92","v":6.952},{"$f":"Heats!$G$87+Heats!$H$87/100","v":25.3},{"$f":"Heats!$I$87","v":6.0880000000000001},{"$f":"Heats!$G$28+Heats!$H$28/100","v":23.75},{"$f":"Heats!$I$28","v":6.7839999999999998},{"$f":"Heats!$G$35+Heats!$H$35/100","v":19.5},{"$f":"Heats!$I$35","v":7.6929999999999996},{"$f":"D12+F12+H12+J12","v":88.6},{"$f":"MIN(D12,F12,H12,J12)","v":19.5},{"$f":"L12-M12","v":69.099999999999994},{"$f":"N3-N12","v":27.650000000000006},{"$f":"IF(MIN(E12,G12,I12,K12)=0, \"-.---\", MIN(E12,G12,I12,K12))","v":6.0880000000000001}]
[11,"Louis T",{"$f":"Heats!$B$15","v":"LMP"},{"$f":"Heats!$G$62+Heats!$H$62/100","v":16.100000000000001},{"$f":"Heats!$I$62","v":7.6},{"$f":"Heats!$G$69+Heats!$H$69/100","v":19.149999999999999},{"$f":"Heats!$I$69","v":7.3609999999999998},{"$f":"Heats!$G$34+Heats!$H$34/100","v":18.600000000000001},{"$f":"Heats!$I$34","v":7.4980000000000002},{"$f":"Heats!$G$29+Heats!$H$29/100","v":15.6},{"$f":"Heats!$I$29","v":9.2959999999999994},{"$f":"D13+F13+H13+J13","v":69.45},{"$f":"MIN(D13,F13,H13,J13)","v":15.6},{"$f":"L13-M13","v":53.85},{"$f":"N3-N13","v":42.9},{"$f":"IF(MIN(E13,G13,I13,K13)=0, \"-.---\", MIN(E13,G13,I13,K13))","v":7.3609999999999998}]
[12,"blank","LMP",null,null,null,null,null,null,null,null,{"$f":"D14+F14+H14+J14","v":0},{"$f":"MIN(D14,F14,H14,J14)","v":0},{"$f":"L14-M14","v":0},{"$f":"N3-N14","v":96.75},{"$f":"IF(MIN(E14,G14,I14,K14)=0, \"-.---\", MIN(E14,G14,I14,K14))","v":"-.---"}]
[13,"Mike D",{"$f":"Heats!$B$13","v":"Nascar"},{"$f":"Heats!$G$32+Heats!$H$32/100","v":29.2},{"$f":"Heats!$I$32","v":5.5869999999999997},{"$f":"Heats!$G$27+Heats!$H$27/100","v":31.25},{"$f":"Heats!$I$27","v":5.4870000000000001},{"$f":"Heats!$G$82+Heats!$H$82/100","v":27.5},{"$f":"Heats!$I$82","v":5.5380000000000003},{"$f":"Heats!$G$77+Heats!$H$77/100","v":26.75},{"$f":"Heats!$I$77","v":5.74},{"$f":"D15+F15+H15+J15","v":114.7},{"$f":"MIN(D15,F15,H15,J15)","v":26.75},{"$f":"L15-M15","v":87.95},{"$f":"N3-N15","v":8.7999999999999972},{"$f":"IF(MIN(E15,G15,I15,K15)=0, \"-.---\", MIN(E15,G15,I15,K15))","v":5.4870000000000001}]
[14,"Clive H",{"$f":"Heats!$B$5","v":"Nascar"},{"$f":"Heats!$G$2+Heats!$H$2/100","v":25.1},{"$f":"Heats!$I$2","v":6.1180000000000003},{"$f":"Heats!$G$9+Heats!$H$9/100","v":28.55},{"$f":"Heats!$I$9","v":5.7140000000000004},{"$f":"Heats!$G$52+Heats!$H$52/100","v":26.85},{"$f":"Heats!$I$52","v":5.8579999999999997},{"$f":"Heats!$G$59+Heats!$H$59/100","v":17.55},{"$f":"Heats!$I$59","v":6.5990000000000002},{"$f":"D16+F16+H16+J16","v":98.05},{"$f":"MIN(D16,F16,H16,J16)","v":17.55},{"$f":"L16-M16","v":80.5},{"$f":"N3-N16","v":16.25},{"$f":"IF(MIN(E16,G16,I16,K16)=0, \"-.---\", MIN(E16,G16,I16,K16))","v":5.7140000000000004}]
[15,"Al T",{"$f":"Heats!$B$10","v":"Nascar"},{"$f":"Heats!$G$86+Heats!$H$86/100","v":25.1},{"$f":"Heats!$I$86","v":6.2279999999999998},{"$f":"Heats!$G$93+Heats!$H$93/100","v":26.8},{"$f":"Heats!$I$93","v":5.8710000000000004},{"$f":"Heats!$G$40+Heats!$H$40/100","v":24.45},{"$f":"Heats!$I$40","v":5.8840000000000003},{"$f":"Heats!$G$47+Heats!$H$47/100","v":20.2},{"$f":"Heats!$I$47","v":6.8680000000000003},{"$f":"D17+F17+H17+J17","v":96.550000000000011},{"$f":"MIN(D17,F17,H17,J17)","v":20.2},{"$f":"L17-M17","v":76.350000000000009},{"$f":"N3-N17","v":20.399999999999991},{"$f":"IF(MIN(E17,G17,I17,K17)=0, \"-.---\", MIN(E17,G17,I17,K17))","v":5.8710000000000004}]
[16,"Tony S",{"$f":"Heats!$B$12","v":"Nascar"},{"$f":"Heats!$G$26+Heats!$H$26/100","v":23.25},{"$f":"Heats!$I$26","v":6.3659999999999997},{"$f":"Heats!$G$33+Heats!$H$33/100","v":24.8},{"$f":"Heats!$I$33","v":5.8570000000000002},{"$f":"Heats!$G$76+Heats!$H$76/100","v":25.9},{"$f":"Heats!$I$76","v":5.8470000000000004},{"$f":"Heats!$G$83+Heats!$H$83/100","v":22.9},{"$f":"Heats!$I$83","v":6.4580000000000002},{"$f":"D18+F18+H18+J18","v":96.85},{"$f":"MIN(D18,F18,H18,J18)","v":22.9},{"$f":"L18-M18","v":73.949999999999989},{"$f":"N3-N18","v":22.800000000000011},{"$f":"IF(MIN(E18,G18,I18,K18)=0, \"-.---\", MIN(E18,G18,I18,K18))","v":5.8470000000000004}]
[17,"Mike R",{"$f":"Heats!$B$16","v":"Nascar"},{"$f":"Heats!$G$14+Heats!$H$14/100","v":20.75},{"$f":"Heats!$I$14","v":6.8319999999999999},{"$f":"Heats!$G$21+Heats!$H$21/100","v":19.149999999999999},{"$f":"Heats!$I$21","v":7.7679999999999998},{"$f":"Heats!$G$64+Heats!$H$64/100","v":20.3},{"$f":"Heats!$I$64","v":6.3090000000000002},{"$f":"Heats!$G$71+Heats!$H$71/100","v":20.9},{"$f":"Heats!$I$71","v":6.9980000000000002},{"$f":"D19+F19+H19+J19","v":81.099999999999994},{"$f":"MIN(D19,F19,H19,J19)","v":19.149999999999999},{"$f":"L19-M19","v":61.949999999999996},{"$f":"N3-N19","v":34.800000000000004},{"$f":"IF(MIN(E19,G19,I19,K19)=0, \"-.---\", MIN(E19,G19,I19,K19))","v":6.3090000000000002}]
[18,"Bob S",{"$f":"Heats!$B$17","v":"Nascar"},{"$f":"Heats!$G$20+Heats!$H$20/100","v":21.8},{"$f":"Heats!$I$20","v":6.6539999999999999},{"$f":"Heats!$G$15+Heats!$H$15/100","v":6.6},{"$f":"Heats!$I$15","v":10.244},{"$f":"Heats!$G$70+Heats!$H$70/100","v":19.55},{"$f":"Heats!$I$70","v":7.1340000000000003},{"$f":"Heats!$G$65+Heats!$H$65/100","v":14.35},{"$f":"Heats!$I$65","v":7.9690000000000003},{"$f":"D20+F20+H20+J20","v":62.300000000000004},{"$f":"MIN(D20,F20,H20,J20)","v":6.6},{"$f":"L20-M20","v":55.7},{"$f":"N3-N20","v":41.05},{"$f":"IF(MIN(E20,G20,I20,K20)=0, \"-.---\", MIN(E20,G20,I20,K20))","v":6.6539999999999999}]
[19,null,null,null,null,null,null,null,null,null,null,{"$f":"D21+F21+H21+J21","v":0},{"$f":"MIN(D21,F21,H21,J21)","v":0},{"$f":"L21-M21","v":0},{"$f":"N3-N21","v":96.75},{"$f":"IF(MIN(E21,G21,I21,K21)=0, \"-.---\", MIN(E21,G21,I21,K21))","v":"-.---"}]
[20,null,null,null,null,null,null,null,null,null,null,{"$f":"D22+F22+H22+J22","v":0},{"$f":"MIN(D22,F22,H22,J22)","v":0},{"$f":"L22-M22","v":0},{"$f":"N3-N22","v":96.75},{"$f":"IF(MIN(E22,G22,I22,K22)=0, \"-.---\", MIN(E22,G22,I22,K22))","v":"-.---"}]
[21,null,null,null,null,null,null,null,null,null,null,{"$f":"D23+F23+H23+J23","v":0},{"$f":"MIN(D23,F23,H23,J23)","v":0},{"$f":"L23-M23","v":0},{"$f":"N3-N23","v":96.75},{"$f":"IF(MIN(E23,G23,I23,K23)=0, \"-.---\", MIN(E23,G23,I23,K23))","v":"-.---"}]
[22,null,null,null,null,null,null,null,null,null,null,{"$f":"D24+F24+H24+J24","v":0},{"$f":"MIN(D24,F24,H24,J24)","v":0},{"$f":"L24-M24","v":0},{"$f":"N3-N24","v":96.75},{"$f":"IF(MIN(E24,G24,I24,K24)=0, \"-.---\", MIN(E24,G24,I24,K24))","v":"-.---"}]
[]
[]
[null,"Add blank drivers in each class at bottom of results to \"push\" each class into it's own set of heats"]
[]
[null,"3 drivers in a class add 3 blank"]
[null,"4 drivers in a class add 2 blanks"]
[null,"5 drivers in a class add 1 blank"]
[null,"6 drivers in a class add no blanks"]
[null,"7 drivers in a class add 3 blanks"]

{"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","Class","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":"Al W"},{"$f":"'Qualifying results'!$C$3","v":"CW"},"R",{"$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":33.15},null,null,{"$f":"MAX(G3,'Qualifying results'!$J$3,'Qualifying results'!$H$3,'Qualifying results'!$F$3,'Qualifying results'!$D$3)","v":33.15},{"$f":"MIN(I3,'Qualifying results'!$K$3,'Qualifying results'!$I$3,'Qualifying results'!$G$3,'Qualifying results'!$E$3)","v":4.7089999999999996},null,null,"W",22,5,5.43,null,1,{"$f":"$D$3","v":"Al W"},{"$f":"$E$3","v":"CW"},{"$f":"$K$3","v":4.7089999999999996},null,null,1,{"$f":"$D$3","v":"Al W"},{"$f":"$E$3","v":"CW"},{"$f":"$J$3","v":33.15}]
[2,"A",2,{"$f":"'Qualifying results'!$B$4","v":"Dave H"},{"$f":"'Qualifying results'!$C$4","v":"CW"},"B",{"$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":31.5},{"$f":"$G$3-$G$4","v":1.6499999999999986},{"$f":"IF(ISNA(VLOOKUP(F4, $N$3:$Q$6, 4, FALSE)), \"-.---\", VLOOKUP(F4, $N$3:$Q$6, 4, FALSE))","v":4.7530000000000001},{"$f":"MAX(G4,'Qualifying results'!$J$4,'Qualifying results'!$H$4,'Qualifying results'!$F$4,'Qualifying results'!$D$4)","v":33.049999999999997},{"$f":"MIN(I4,'Qualifying results'!$K$4,'Qualifying results'!$I$4,'Qualifying results'!$G$4,'Qualifying results'!$E$4)","v":4.7530000000000001},null,null,"B",31,5,4.7530000000000001,null,2,{"$f":"$D$4","v":"Dave H"},{"$f":"$E$4","v":"CW"},{"$f":"$K$4","v":4.7530000000000001},null,null,2,{"$f":"$D$4","v":"Dave H"},{"$f":"$E$4","v":"CW"},{"$f":"$J$4","v":33.049999999999997},{"$f":"$AB$3-AB4","v":0.10000000000000142}]
[3,"A",{"$f":"$C$7","v":4},{"$f":"$D$7","v":"Ray G"},{"$f":"$E$7","v":"CW"},"Y",{"$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":24.65},{"$f":"$G$3-$G$5","v":8.5},{"$f":"IF(ISNA(VLOOKUP(F5, $N$3:$Q$6, 4, FALSE)), \"-.---\", VLOOKUP(F5, $N$3:$Q$6, 4, FALSE))","v":6.5330000000000004},{"$f":"MAX(G5,$J$7)","v":25.85},{"$f":"MIN(I5,$K$7)","v":6.2069999999999999},null,null,"R",33,1.5,4.2439999999999998,null,3,{"$f":"$D$6","v":"Callum N"},{"$f":"$E$6","v":"CW"},{"$f":"$K$6","v":5.1779999999999999},null,null,3,{"$f":"$D$18","v":"Mike D"},{"$f":"$E$18","v":"Nascar"},{"$f":"$J$18","v":32.25},0.89999999999999858]
[4,"A",3,{"$f":"'Qualifying results'!$B$5","v":"Callum N"},{"$f":"'Qualifying results'!$C$5","v":"CW"},"W",{"$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":22.5},{"$f":"$G$3-$G$6","v":10.649999999999999},{"$f":"IF(ISNA(VLOOKUP(F6, $N$3:$Q$6, 4, FALSE)), \"-.---\", VLOOKUP(F6, $N$3:$Q$6, 4, FALSE))","v":5.43},{"$f":"MAX(G6,'Qualifying results'!$J$5,'Qualifying results'!$H$5,'Qualifying results'!$F$5,'Qualifying results'!$D$5)","v":28.25},{"$f":"MIN(I6,'Qualifying results'!$K$5,'Qualifying results'!$I$5,'Qualifying results'!$G$5,'Qualifying results'!$E$5)","v":5.1779999999999999},null,null,"Y",24,6.5,6.5330000000000004,null,4,{"$f":"$D$14","v":"Andy W"},{"$f":"$E$14","v":"LMP"},{"$f":"$K$14","v":5.2069999999999999},null,null,4,{"$f":"$D$14","v":"Andy W"},{"$f":"$E$14","v":"LMP"},{"$f":"$J$14","v":31.3},1.8499999999999979]
["-","B",4,{"$f":"'Qualifying results'!$B$6","v":"Ray G"},{"$f":"'Qualifying results'!$C$6","v":"CW"},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":25.85},{"$f":"MIN(I7,'Qualifying results'!$K$6,'Qualifying results'!$I$6,'Qualifying results'!$G$6,'Qualifying results'!$E$6)","v":6.2069999999999999},null,"B Final","W",null,null,null,null,5,{"$f":"$D$18","v":"Mike D"},{"$f":"$E$18","v":"Nascar"},{"$f":"$K$18","v":5.2610000000000001},null,null,5,{"$f":"$D$12","v":"Marc T"},{"$f":"$E$12","v":"LMP"},{"$f":"$J$12","v":29.35}]
[5,"B",5,{"$f":"'Qualifying results'!$B$7","v":"blank"},{"$f":"'Qualifying results'!$C$7","v":"CW"},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":0},{"$f":"MIN(I8,'Qualifying results'!$K$7,'Qualifying results'!$I$7,'Qualifying results'!$G$7,'Qualifying results'!$F$7)","v":0},null,null,"B",null,null,null,null,6,{"$f":"$D$20","v":"Clive H"},{"$f":"$E$20","v":"Nascar"},{"$f":"$K$20","v":5.7140000000000004},null,null,6,{"$f":"$D$20","v":"Clive H"},{"$f":"$E$20","v":"Nascar"},{"$f":"$J$20","v":28.55}]
[6,"B",6,{"$f":"'Qualifying results'!$B$8","v":"blank"},{"$f":"'Qualifying results'!$C$8","v":"CW"},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":0},{"$f":"MIN(I9,'Qualifying results'!$K$8,'Qualifying results'!$I$8,'Qualifying results'!$G$8,'Qualifying results'!$E$8)","v":0},null,null,"R",null,null,null,null,7,{"$f":"$D$12","v":"Marc T"},{"$f":"$E$12","v":"LMP"},{"$f":"$K$12","v":5.72},null,null,7,{"$f":"$D$22","v":"Tony S"},{"$f":"$E$22","v":"Nascar"},{"$f":"$J$22","v":28.4},4.75]
[7,"B",{"$f":"$C$11","v":9},{"$f":"$D$11","v":"Deane W"},{"$f":"$E$11","v":"LMP"},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":28.15},{"$f":"MIN(I10,$K$11)","v":5.7859999999999996},null,null,"Y",null,null,null,null,8,{"$f":"$D$10","v":"Deane W"},{"$f":"$E$10","v":"LMP"},{"$f":"$K$10","v":5.7859999999999996},null,null,8,{"$f":"$D$6","v":"Callum N"},{"$f":"$E$6","v":"CW"},{"$f":"$J$6","v":28.25},4.8999999999999986]
["-","C",9,{"$f":"'Qualifying results'!$B$11","v":"Deane W"},{"$f":"'Qualifying results'!$C$11","v":"LMP"},"W",{"$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":28.15},null,{"$f":"IF(ISNA(VLOOKUP(F11, $N$11:$Q$14, 4, FALSE)), \"-.---\", VLOOKUP(F11, $N$11:$Q$14, 4, FALSE))","v":6.1529999999999996},{"$f":"MAX(G11,'Qualifying results'!$J$11,'Qualifying results'!$H$11,'Qualifying results'!$F$11,'Qualifying results'!$D$11)","v":28.15},{"$f":"MIN(I11,'Qualifying results'!$K$11,'Qualifying results'!$I$11,'Qualifying results'!$G$11,'Qualifying results'!$E$11)","v":5.7859999999999996},null,"C Final","W",28,1.5,6.1529999999999996,null,9,{"$f":"$D$22","v":"Tony S"},{"$f":"$E$22","v":"Nascar"},{"$f":"$K$22","v":5.8470000000000004},null,null,9,{"$f":"$D$10","v":"Deane W"},{"$f":"$E$10","v":"LMP"},{"$f":"$J$10","v":28.15},5]
[8,"C",8,{"$f":"'Qualifying results'!$B$10","v":"Marc T"},{"$f":"'Qualifying results'!$C$10","v":"LMP"},"R",{"$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":28.1},{"$f":"$G$11-$G$12","v":4.9999999999997158E-2},{"$f":"IF(ISNA(VLOOKUP(F12, $N$11:$Q$14, 4, FALSE)), \"-.---\", VLOOKUP(F12, $N$11:$Q$14, 4, FALSE))","v":5.9039999999999999},{"$f":"MAX(G12,'Qualifying results'!$J$10,'Qualifying results'!$H$10,'Qualifying results'!$F$10,'Qualifying results'!$D$10)","v":29.35},{"$f":"MIN(I12,'Qualifying results'!$K$10,'Qualifying results'!$I$10,'Qualifying results'!$G$10,'Qualifying results'!$E$10)","v":5.72},null,null,"B",7,5,6.6449999999999996,null,10,{"$f":"$D$21","v":"Al T"},{"$f":"$E$21","v":"Nascar"},{"$f":"$K$21","v":5.8710000000000004},null,null,10,{"$f":"$D$21","v":"Al T"},{"$f":"$E$21","v":"Nascar"},{"$f":"$J$21","v":26.8},6.3499999999999979]
[9,"C",{"$f":"$C$15","v":10},{"$f":"$D$15","v":"Henry T"},{"$f":"$E$15","v":"LMP"},"Y",{"$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":18.7},{"$f":"$G$11-$G$13","v":9.4499999999999993},{"$f":"IF(ISNA(VLOOKUP(F13, $N$11:$Q$14, 4, FALSE)), \"-.---\", VLOOKUP(F13, $N$11:$Q$14, 4, FALSE))","v":7.819},{"$f":"MAX(G13,$J$15)","v":25.3},{"$f":"MIN(I13,$K$15)","v":6.0880000000000001},null,null,"R",28,1,5.9039999999999999,null,11,{"$f":"$D$13","v":"Henry T"},{"$f":"$E$13","v":"LMP"},{"$f":"$K$13","v":6.0880000000000001},null,null,11,{"$f":"$D$5","v":"Ray G"},{"$f":"$E$5","v":"CW"},{"$f":"$J$5","v":25.85},7.2999999999999972]
[10,"C",7,{"$f":"'Qualifying results'!$B$9","v":"Andy W"},{"$f":"'Qualifying results'!$C$9","v":"LMP"},"B",{"$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":7.5},{"$f":"$G$11-$G$14","v":20.65},{"$f":"IF(ISNA(VLOOKUP(F14, $N$11:$Q$14, 4, FALSE)), \"-.---\", VLOOKUP(F14, $N$11:$Q$14, 4, FALSE))","v":6.6449999999999996},{"$f":"MAX(G14,'Qualifying results'!$J$9,'Qualifying results'!$H$9,'Qualifying results'!$F$9,'Qualifying results'!$D$9)","v":31.3},{"$f":"MIN(I14,'Qualifying results'!$K$9,'Qualifying results'!$I$9,'Qualifying results'!$G$9,'Qualifying results'!$E$9)","v":5.2069999999999999},null,null,"Y",18,7,7.819,null,12,{"$f":"$D$5","v":"Ray G"},{"$f":"$E$5","v":"CW"},{"$f":"$K$5","v":6.2069999999999999},null,null,12,{"$f":"$D$13","v":"Henry T"},{"$f":"$E$13","v":"LMP"},{"$f":"$J$13","v":25.3}]
["-","D",10,{"$f":"'Qualifying results'!$B$12","v":"Henry T"},{"$f":"'Qualifying results'!$C$12","v":"LMP"},"B",{"$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":24.65},null,{"$f":"IF(ISNA(VLOOKUP(F15, $N$15:$Q$18, 4, FALSE)), \"-.---\", VLOOKUP(F15, $N$15:$Q$18, 4, FALSE))","v":6.3620000000000001},{"$f":"MAX(G15,'Qualifying results'!$J$12,'Qualifying results'!$H$12,'Qualifying results'!$F$12,'Qualifying results'!$D$12)","v":25.3},{"$f":"MIN(I15,'Qualifying results'!$K$12,'Qualifying results'!$I$12,'Qualifying results'!$G$12,'Qualifying results'!$E$12)","v":6.0880000000000001},null,"D Final","W",0,null,"-.---",null,13,{"$f":"$D$25","v":"Mike R"},{"$f":"$E$25","v":"Nascar"},{"$f":"$K$25","v":6.3090000000000002},null,null,13,{"$f":"$D$24","v":"Bob S"},{"$f":"$E$24","v":"Nascar"},{"$f":"$J$24","v":21.8},11.349999999999998]
[11,"D",11,{"$f":"'Qualifying results'!$B$13","v":"Louis T"},{"$f":"'Qualifying results'!$C$13","v":"LMP"},"R",{"$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":19.2},{"$f":"$G$15-$G$16","v":5.4499999999999993},{"$f":"IF(ISNA(VLOOKUP(F16, $N$15:$Q$18, 4, FALSE)), \"-.---\", VLOOKUP(F16, $N$15:$Q$18, 4, FALSE))","v":6.9850000000000003},{"$f":"MAX(G16,'Qualifying results'!$J$13,'Qualifying results'!$H$13,'Qualifying results'!$F$13,'Qualifying results'!$D$13)","v":19.2},{"$f":"MIN(I16,'Qualifying results'!$K$13,'Qualifying results'!$I$13,'Qualifying results'!$G$13,'Qualifying results'!$E$13)","v":6.9850000000000003},null,null,"B",24,6.5,6.3620000000000001,null,14,{"$f":"$D$24","v":"Bob S"},{"$f":"$E$24","v":"Nascar"},{"$f":"$K$24","v":6.6539999999999999},null,null,14,{"$f":"$D$25","v":"Mike R"},{"$f":"$E$25","v":"Nascar"},{"$f":"$J$25","v":20.9},12.25]
[12,"D",12,{"$f":"'Qualifying results'!$B$14","v":"blank"},{"$f":"'Qualifying results'!$C$14","v":"LMP"},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},{"$f":"$G$15-$G$17","v":24.65},{"$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",19,2,6.9850000000000003,null,15,{"$f":"$D$16","v":"Louis T"},{"$f":"$E$16","v":"LMP"},{"$f":"$K$16","v":6.9850000000000003},null,null,15,{"$f":"$D$16","v":"Louis T"},{"$f":"$E$16","v":"LMP"},{"$f":"$J$16","v":19.2},13.95]
[13,"D",{"$f":"$C$19","v":13},{"$f":"$D$19","v":"Mike D"},{"$f":"$E$19","v":"Nascar"},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},{"$f":"$G$15-$G$18","v":24.65},{"$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":32.25},{"$f":"MIN(I18,$K$19)","v":5.2610000000000001},null,null,"Y",0,null,"-.---",null,16,null,null,null,{"$f":"V18-$V$3","v":-4.7089999999999996},null,16,{"$f":"$D$26","v":0},{"$f":"$E$26","v":0},{"$f":"$J$26","v":0},33.15]
["-","E",13,{"$f":"'Qualifying results'!$B$15","v":"Mike D"},{"$f":"'Qualifying results'!$C$15","v":"Nascar"},"B",{"$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":32.25},null,{"$f":"IF(ISNA(VLOOKUP(F19, $N$19:$Q$22, 4, FALSE)), \"-.---\", VLOOKUP(F19, $N$19:$Q$22, 4, FALSE))","v":5.2610000000000001},{"$f":"MAX(G19,'Qualifying results'!$J$15,'Qualifying results'!$H$15,'Qualifying results'!$F$15,'Qualifying results'!$D$15)","v":32.25},{"$f":"MIN(I19,'Qualifying results'!$K$15,'Qualifying results'!$I$15,'Qualifying results'!$G$15,'Qualifying results'!$E$15)","v":5.2610000000000001},null,"E Final","W",25,2.5,5.9329999999999998,null,17,null,null,null,-4.7089999999999996,null,17,{"$f":"$D$28","v":0},{"$f":"$E$28","v":0},{"$f":"$J$28","v":0},33.15]
[14,"E",14,{"$f":"'Qualifying results'!$B$16","v":"Clive H"},{"$f":"'Qualifying results'!$C$16","v":"Nascar"},"R",{"$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":27.2},{"$f":"$G$19-$G$20","v":5.0500000000000007},{"$f":"IF(ISNA(VLOOKUP(F20, $N$19:$Q$22, 4, FALSE)), \"-.---\", VLOOKUP(F20, $N$19:$Q$22, 4, FALSE))","v":6.0549999999999997},{"$f":"MAX(G20,'Qualifying results'!$J$16,'Qualifying results'!$H$16,'Qualifying results'!$F$16,'Qualifying results'!$D$16)","v":28.55},{"$f":"MIN(I20,'Qualifying results'!$K$16,'Qualifying results'!$I$16,'Qualifying results'!$G$16,'Qualifying results'!$E$16)","v":5.7140000000000004},null,null,"B",32,2.5,5.2610000000000001,null,18,null,null,null,-4.7089999999999996,null,18,{"$f":"$D$29","v":0},{"$f":"$E$29","v":0},{"$f":"$J$29","v":0},33.15]
[15,"E",15,{"$f":"'Qualifying results'!$B$17","v":"Al T"},{"$f":"'Qualifying results'!$C$17","v":"Nascar"},"W",{"$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":25.25},{"$f":"$G$19-$G$21","v":7},{"$f":"IF(ISNA(VLOOKUP(F21, $N$19:$Q$22, 4, FALSE)), \"-.---\", VLOOKUP(F21, $N$19:$Q$22, 4, FALSE))","v":5.9329999999999998},{"$f":"MAX(G21,'Qualifying results'!$J$17,'Qualifying results'!$H$17,'Qualifying results'!$F$17,'Qualifying results'!$D$17)","v":26.8},{"$f":"MIN(I21,'Qualifying results'!$K$17,'Qualifying results'!$I$17,'Qualifying results'!$G$17,'Qualifying results'!$E$17)","v":5.8710000000000004},null,null,"R",27,2,6.0549999999999997,null,19,{"$f":"$D$26","v":0},{"$f":"$E$26","v":0},{"$f":"$K$26","v":0},-4.7089999999999996,null,19,{"$f":"$D$30","v":0},{"$f":"$E$30","v":0},{"$f":"$J$30","v":0},33.15]
[16,"E",{"$f":"$C$23","v":16},{"$f":"$D$23","v":"Tony S"},{"$f":"$E$23","v":"Nascar"},"Y",{"$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":24.25},{"$f":"$G$19-$G$22","v":8},{"$f":"IF(ISNA(VLOOKUP(F22, $N$19:$Q$22, 4, FALSE)), \"-.---\", VLOOKUP(F22, $N$19:$Q$22, 4, FALSE))","v":6.2770000000000001},{"$f":"MAX(G22,$J$23)","v":28.4},{"$f":"MIN(I22,$K$23)","v":5.8470000000000004},null,null,"Y",24,2.5,6.2770000000000001,null,20,{"$f":"$D$28","v":0},{"$f":"$E$28","v":0},{"$f":"$K$28","v":0},-4.7089999999999996,null,20,null,null,null,33.15]
["-","F",16,{"$f":"'Qualifying results'!$B$18","v":"Tony S"},{"$f":"'Qualifying results'!$C$18","v":"Nascar"},"B",{"$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":28.4},null,{"$f":"IF(ISNA(VLOOKUP(F23, $N$23:$Q$26, 4, FALSE)), \"-.---\", VLOOKUP(F23, $N$23:$Q$26, 4, FALSE))","v":5.9509999999999996},{"$f":"MAX(G23,'Qualifying results'!$J$18,'Qualifying results'!$H$18,'Qualifying results'!$F$18,'Qualifying results'!$D$18)","v":28.4},{"$f":"MIN(I23,'Qualifying results'!$K$18,'Qualifying results'!$I$18,'Qualifying results'!$G$18,'Qualifying results'!$E$18)","v":5.8470000000000004},null,"F Final","W",18,6.5,7.6040000000000001,null,21,{"$f":"$D$29","v":0},{"$f":"$E$29","v":0},{"$f":"$K$29","v":0},-4.7089999999999996,null,21,null,null,null,33.15]
[17,"F",18,{"$f":"'Qualifying results'!$B$20","v":"Bob S"},{"$f":"'Qualifying results'!$C$20","v":"Nascar"},"W",{"$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":18.649999999999999},{"$f":"$G$23-$G$24","v":9.75},{"$f":"IF(ISNA(VLOOKUP(F24, $N$23:$Q$26, 4, FALSE)), \"-.---\", VLOOKUP(F24, $N$23:$Q$26, 4, FALSE))","v":7.6040000000000001},{"$f":"MAX(G24,'Qualifying results'!$J$20,'Qualifying results'!$H$20,'Qualifying results'!$F$20,'Qualifying results'!$D$20)","v":21.8},{"$f":"MIN(I24,'Qualifying results'!$K$20,'Qualifying results'!$I$20,'Qualifying results'!$G$20,'Qualifying results'!$E$20)","v":6.6539999999999999},null,null,"B",28,4,5.9509999999999996,null,22,{"$f":"$D$30","v":0},{"$f":"$E$30","v":0},{"$f":"$K$30","v":0},-4.7089999999999996,null,22,null,null,null,33.15]
[18,"F",17,{"$f":"'Qualifying results'!$B$19","v":"Mike R"},{"$f":"'Qualifying results'!$C$19","v":"Nascar"},"R",{"$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.55000000000000004},{"$f":"$G$23-$G$25","v":27.849999999999998},{"$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$19,'Qualifying results'!$H$19,'Qualifying results'!$F$19,'Qualifying results'!$D$19)","v":20.9},{"$f":"MIN(I25,'Qualifying results'!$K$19,'Qualifying results'!$I$19,'Qualifying results'!$G$19,'Qualifying results'!$E$19)","v":6.3090000000000002},null,null,"R",0,5.5,"-.---"]
[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},{"$f":"$G$23-$G$26","v":28.4},{"$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",0,null,"-.---"]
["-","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"]