{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["General Overview","OVERALL RATING","FITMENT","AEB Car-to-Car","AEB Pedestrian","AEB Cyclist","LSS","SAS","OSM","Summary"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":1,"defined_names":10,"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":"General Overview","index":0,"n_rows":22,"n_cols":24,"rows_kept":22,"cut":false,"hidden":false,"merged":[[22,2,22,4],[16,2,16,4],[20,2,20,3],[21,2,21,3],[14,2,14,4],[13,2,13,4],[15,2,15,4],[19,2,19,3],[1,1,1,4],[2,2,2,4],[3,2,3,4],[7,2,7,4],[8,2,8,4],[12,2,12,4],[17,2,17,4],[18,2,18,4],[9,2,9,4],[11,2,11,4]]}
[]
[3,"VEHICLE SPECIFICATION",null,null,null,"YEAR OF TEST",2021,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3 door hatchback"]
[null,"Make",null,null,null,"AEB Car-to-Car",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3 door wgon"]
[null,"Model",null,null,null,"AEB Pedestrian tests",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"5 door wagon"]
[null,"Tested Variant",null,null,null,"AEB Cyclist tests"]
[null,"Chassis",null,null,null,"LSS tests"]
[null,"Type Approval",null,null,null,"SAS tests",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"5 door SUV"]
[null,"VIN of test vehicle",null,null,null,"OSM test"]
[null,"Kerb weight (kg)"]
[null,"Gross Vehicle Weight(kg)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3 door SUV"]
[null,"Maximum Payload"]
[null,"Test weight (kg)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"5 door MPV"]
[null,"Engine"]
[null,"Trim level"]
[null,"Safety Pack"]
[null,"Body Type"]
[null,"Generation"]
[null,"Hand of drive"]
[null,"Seat arrangement"]
[null,"front row"]
[null,"second row"]
[null,"third row"]

{"sheet":"OVERALL RATING","index":1,"n_rows":19,"n_cols":8,"rows_kept":19,"cut":false,"hidden":false,"merged":[[11,2,11,4],[11,5,11,7],[1,2,1,4],[3,2,3,4],[3,5,3,7],[4,2,4,4],[4,5,4,7],[16,1,16,7],[17,1,17,7],[18,1,18,7],[19,1,19,7],[12,2,12,4],[12,5,12,7],[13,2,13,4],[13,5,13,7],[14,2,14,4],[14,5,14,7]]}
[]
[null,null,{"$f":"CONCATENATE('General Overview'!C3:E3,\" \",'General Overview'!C4)","v":" "},null,null,{"$f":"IF(F14>=60,\"GOLD\",IF(F14>=40,\"SILVER\",IF(F14>=20,\"BRONZE\",\"NOT RECOMMENDED\")))","v":"NOT RECOMMENDED"}]
[]
[null,null,"FITMENT\n",null,null,"PERFORMANCE\n"]
[null,null,{"$f":"ROUND(C12,1)","v":0},null,null,{"$f":"ROUND(F12,1)","v":0}]
[null,30,"AEB Car-to-Car","best fitment",{"$f":"FITMENT!D14","v":"N/A"},"AEB Car-to-Car",{"$f":"'AEB Car-to-Car'!D76/4*B6","v":0},{"$f":"CONCATENATE(\"out of \",B6)","v":"out of 30"}]
[null,10,"AEB Pedestrian","best fitment",{"$f":"FITMENT!E14","v":"N/A"},"AEB Pedestrian",{"$f":"'AEB Pedestrian'!D99/6*B7","v":0},"out of 10"]
[null,10,"AEB Cyclist","best fitment",{"$f":"FITMENT!F14","v":"N/A"},"AEB Cyclist",{"$f":"'AEB Cyclist'!D54/6*B8","v":0},"out of 10"]
[null,20,"LSS","best fitment",{"$f":"FITMENT!G25","v":"N/A"},"LSS",{"$f":"LSS!D90/4*B9","v":0},"out of 20"]
[null,15,"SAS","best fitment",{"$f":"FITMENT!G36","v":"N/A"},"SAS",{"$f":"SAS!D48/3*B10","v":0},"out of 15"]
[null,15,"OSM","best fitment",{"$f":"FITMENT!G47","v":"N/A"},"OSM",{"$f":"OSM!D20/3*B11","v":0},"out of 15"]
[null,"Total Score",null,null,null,{"$f":"SUM(G6:G11)","v":0}]
[null,"Max Points available",null,null,null,100]
[null,"Normalised Score",null,null,null,{"$f":"INT(F12/F13*100)","v":0}]
[null,"Weight",null,null,null,0.5]
[null,null,null,null,{"$f":"C14/100","v":0},null,null,{"$f":"F14/100","v":0}]
[null,"COMMENTS"]
["Verdict"]
["Comment"]

{"sheet":"FITMENT","index":2,"n_rows":47,"n_cols":7,"rows_kept":47,"cut":false,"hidden":false,"merged":[[1,3,3,5],[1,1,3,2],[24,1,24,2],[35,1,35,2],[46,1,46,2],[13,1,13,2]]}
[]
[null,"FITMENT"]
[]
[]
[null,"AEB FITMENT",null,"AEB CAR-TO-CAR","AEB PEDESTRIAN","AEB CYCLIST","AEB"]
[null,null,"France",null,null,null,{"$f":"IF(COUNTIF(D6:F6,\"Standard\")>0,\"Standard\",IF(COUNTIF(D6:F6,\"Optional\")>0,\"Optional\",\"N/A\"))","v":"N/A"}]
[null,null,"Germany",null,null,null,{"$f":"IF(COUNTIF(D7:F7,\"Standard\")>0,\"Standard\",IF(COUNTIF(D7:F7,\"Optional\")>0,\"Optional\",\"N/A\"))","v":"N/A"}]
[null,null,"Italy",null,null,null,"N/A"]
[null,null,"Luxembourg",null,null,null,"N/A"]
[null,null,"Spain",null,null,null,"N/A"]
[null,null,"Sweden",null,null,null,"N/A"]
[null,null,"The Netherlands",null,null,null,"N/A"]
[null,null,"United Kingdom",null,null,null,"N/A"]
[null,"AEB FITMENT SUMMARY",null,{"$f":"IF(COUNTIF(D6:D13,\"Standard\")>0,\"Standard\",IF(COUNTIF(D6:D13,\"Optional\")>0,\"Optional\",\"N/A\"))","v":"N/A"},{"$f":"IF(COUNTIF(E6:E13,\"Standard\")>0,\"Standard\",IF(COUNTIF(E6:E13,\"Optional\")>0,\"Optional\",\"N/A\"))","v":"N/A"},{"$f":"IF(COUNTIF(F6:F13,\"Standard\")>0,\"Standard\",IF(COUNTIF(F6:F13,\"Optional\")>0,\"Optional\",\"N/A\"))","v":"N/A"},{"$f":"IF(COUNTIF(G6:G13,\"Standard\")>0,\"Standard\",IF(COUNTIF(G6:G13,\"Optional\")>0,\"Optional\",\"N/A\"))","v":"N/A"}]
[]
[null,"LSS FITMENT",null,"ELK/LKA","LDW","BLIS","LSS"]
[null,null,"France",null,null,null,{"$f":"IF(COUNTIF(D17:F17,\"Standard\")>0,\"Standard\",IF(COUNTIF(D17:F17,\"Optional\")>0,\"Optional\",\"N/A\"))","v":"N/A"}]
[null,null,"Germany",null,null,null,{"$f":"IF(COUNTIF(D18:F18,\"Standard\")>0,\"Standard\",IF(COUNTIF(D18:F18,\"Optional\")>0,\"Optional\",\"N/A\"))","v":"N/A"}]
[null,null,"Italy",null,null,null,"N/A"]
[null,null,"Luxembourg",null,null,null,"N/A"]
[null,null,"Spain",null,null,null,"N/A"]
[null,null,"Sweden",null,null,null,"N/A"]
[null,null,"The Netherlands",null,null,null,"N/A"]
[null,null,"United Kingdom",null,null,null,"N/A"]
[null,"LSS FITMENT SUMMARY",null,{"$f":"IF(COUNTIF(D17:D24,\"Standard\")>0,\"Standard\",IF(COUNTIF(D17:D24,\"Optional\")>0,\"Optional\",\"N/A\"))","v":"N/A"},{"$f":"IF(COUNTIF(E17:E24,\"Standard\")>0,\"Standard\",IF(COUNTIF(E17:E24,\"Optional\")>0,\"Optional\",\"N/A\"))","v":"N/A"},{"$f":"IF(COUNTIF(F17:F24,\"Standard\")>0,\"Standard\",IF(COUNTIF(F17:F24,\"Optional\")>0,\"Optional\",\"N/A\"))","v":"N/A"},{"$f":"IF(COUNTIF(G17:G24,\"Standard\")>0,\"Standard\",IF(COUNTIF(G17:G24,\"Optional\")>0,\"Optional\",\"N/A\"))","v":"N/A"}]
[]
[null,"SAS FITMENT",null,"SLIF","SCF",null,"SAS"]
[null,null,"France",null,null,null,{"$f":"IF(COUNTIF(D28:F28,\"Standard\")>0,\"Standard\",IF(COUNTIF(D28:F28,\"Optional\")>0,\"Optional\",\"N/A\"))","v":"N/A"}]
[null,null,"Germany",null,null,null,{"$f":"IF(COUNTIF(D29:F29,\"Standard\")>0,\"Standard\",IF(COUNTIF(D29:F29,\"Optional\")>0,\"Optional\",\"N/A\"))","v":"N/A"}]
[null,null,"Italy",null,null,null,"N/A"]
[null,null,"Luxembourg",null,null,null,"N/A"]
[null,null,"Spain",null,null,null,"N/A"]
[null,null,"Sweden",null,null,null,"N/A"]
[null,null,"The Netherlands",null,null,null,"N/A"]
[null,null,"United Kingdom",null,null,null,"N/A"]
[null,"SAS FITMENT SUMMARY",null,{"$f":"IF(COUNTIF(D28:D35,\"Standard\")>0,\"Standard\",IF(COUNTIF(D28:D35,\"Optional\")>0,\"Optional\",\"N/A\"))","v":"N/A"},{"$f":"IF(COUNTIF(E28:E35,\"Standard\")>0,\"Standard\",IF(COUNTIF(E28:E35,\"Optional\")>0,\"Optional\",\"N/A\"))","v":"N/A"},null,{"$f":"IF(COUNTIF(G28:G35,\"Standard\")>0,\"Standard\",IF(COUNTIF(G28:G35,\"Optional\")>0,\"Optional\",\"N/A\"))","v":"N/A"}]
[]
[null,"OSM FITMENT",null,"SBR - Driver","SBR - Passenger","Attention Assist","OSM"]
[null,null,"France",null,null,null,{"$f":"IF(COUNTIF(D39:F39,\"Standard\")>0,\"Standard\",IF(COUNTIF(D39:F39,\"Optional\")>0,\"Optional\",\"N/A\"))","v":"N/A"}]
[null,null,"Germany",null,null,null,{"$f":"IF(COUNTIF(D40:F40,\"Standard\")>0,\"Standard\",IF(COUNTIF(D40:F40,\"Optional\")>0,\"Optional\",\"N/A\"))","v":"N/A"}]
[null,null,"Italy",null,null,null,"N/A"]
[null,null,"Luxembourg",null,null,null,"N/A"]
[null,null,"Spain",null,null,null,"N/A"]
[null,null,"Sweden",null,null,null,"N/A"]
[null,null,"The Netherlands",null,null,null,"N/A"]
[null,null,"United Kingdom",null,null,null,"N/A"]
[null,"OSM FITMENT SUMMARY",null,{"$f":"IF(COUNTIF(D39:D46,\"Standard\")>0,\"Standard\",IF(COUNTIF(D39:D46,\"Optional\")>0,\"Optional\",\"N/A\"))","v":"N/A"},{"$f":"IF(COUNTIF(E39:E46,\"Standard\")>0,\"Standard\",IF(COUNTIF(E39:E46,\"Optional\")>0,\"Optional\",\"N/A\"))","v":"N/A"},{"$f":"IF(COUNTIF(F39:F46,\"Standard\")>0,\"Standard\",IF(COUNTIF(F39:F46,\"Optional\")>0,\"Optional\",\"N/A\"))","v":"N/A"},{"$f":"IF(COUNTIF(G39:G46,\"Standard\")>0,\"Standard\",IF(COUNTIF(G39:G46,\"Optional\")>0,\"Optional\",\"N/A\"))","v":"N/A"}]

{"sheet":"AEB Car-to-Car","index":3,"n_rows":76,"n_cols":13,"rows_kept":76,"cut":false,"hidden":false,"merged":[[73,3,73,12],[75,1,75,2],[75,3,75,12],[68,3,68,12],[70,1,70,2],[70,3,70,12],[71,3,71,12],[72,3,72,12],[66,3,66,7],[66,8,66,12],[67,3,67,7],[67,8,67,12],[62,1,62,2],[62,3,62,12],[64,1,64,2],[64,3,64,7],[64,8,64,12],[65,3,65,7],[65,8,65,12],[58,3,58,12],[59,3,59,12],[60,3,60,4],[60,5,60,12],[61,3,61,4],[61,5,61,12],[52,3,52,4],[52,5,52,7],[52,8,52,9],[52,10,52,12],[50,3,50,4],[50,5,50,7],[50,8,50,9],[53,3,53,7],[53,8,53,12],[50,10,50,12],[51,3,51,4],[51,5,51,7],[51,8,51,9],[51,10,51,12],[56,1,56,2],[56,3,56,7],[56,8,56,12],[54,3,54,4],[54,5,54,7],[54,8,54,9],[54,10,54,12],[55,3,55,4],[55,5,55,7],[55,8,55,9],[55,10,55,12],[32,1,32,2],[32,3,32,7],[32,8,32,12],[34,1,34,2],[35,1,45,1],[35,8,35,12],[36,8,36,12],[37,8,37,12],[38,8,38,12],[46,1,46,2],[46,3,46,7],[46,8,46,12],[48,1,48,12],[49,1,49,2],[49,3,49,4],[49,5,49,7],[49,8,49,9],[49,10,49,12],[3,1,3,2],[3,3,3,7],[3,8,3,12],[4,3,4,7],[4,8,4,12],[5,3,5,7],[5,8,5,12],[1,1,2,2],[14,1,14,2],[14,3,14,12],[1,3,1,7],[1,8,1,12],[2,3,2,7],[2,8,2,12],[10,3,10,7],[10,8,10,12],[11,3,11,7],[11,8,11,12],[6,3,6,7],[6,8,6,12],[7,3,7,7],[7,8,7,12],[8,3,8,7],[8,8,8,12],[16,1,16,2],[17,1,31,1],[17,8,17,12],[12,3,12,7],[12,8,12,12],[26,3,26,7],[27,3,27,7],[28,3,28,7],[29,3,29,7],[30,3,30,7],[31,3,31,7],[13,3,13,7],[13,8,13,12],[18,8,18,12],[19,8,19,12],[20,8,20,12]]}
[3]
[null,"AEB CAR-TO-CAR",null,"AEB",null,null,null,null,"FCW"]
[]
[null,"SYSTEM DETAILS"]
[null,null,"System name"]
[null,null,"AEB and/or FCW"]
[null,null,"Functionality"]
[null,null,"Speed range (km/h) - Minimum"]
[null,null,"Maximum"]
[]
[null,"PREREQUISITES"]
[null,null,"Default ON after every journey"]
[null,null,"Loud and Clear FCW"]
[null,null,"System switches off below 130 km/h"]
[null,"PREREQUISITES",null,{"$f":"IF(AND(D12=\"PASS\",D13=\"PASS\",D14=\"NO\",I12=\"PASS\",I13=\"PASS\",I14=\"NO\"),\"PASS\",\"FAIL\")","v":"FAIL"}]
[]
[null,"CCRs",null,-0.5,-0.75,1,0.75,0.5,-0.5,-0.75,1,0.75,0.5]
[null,"Test Speed",10]
[null,null,15]
[null,null,20]
[null,null,25]
[null,null,30]
[null,null,35]
[null,null,40]
[null,null,45]
[null,null,50]
[null,null,55]
[null,null,60]
[null,null,65]
[null,null,70]
[null,null,75]
[null,null,80]
[null,"Predicted CCRs score",null,0,null,null,null,null,0]
[]
[null,"CCRm",null,-0.5,-0.75,1,0.75,0.5,-0.5,-0.75,1,0.75,0.5]
[null,"Test Speed",30]
[null,null,35]
[null,null,40]
[null,null,45]
[null,null,50]
[null,null,55]
[null,null,60]
[null,null,65]
[null,null,70]
[null,null,75]
[null,null,80]
[null,"Predicted CCRm score",null,0,null,null,null,null,0]
[]
[null,"CCRb"]
[null,"Testpoints CCRb",null,"Impact Speed",null,"Points",null,null,"Impact Speed",null,"Points"]
[null,null,"12m headway"]
[null,null,"-2m/s² EVT acceleration",null,null,{"$f":"IF(D52=\"Green\",1,IF(D52=\"Yellow\",0.75,IF(D52=\"Orange\",0.5,IF(D52=\"Brown\",0.25,0))))","v":0},null,null,null,null,{"$f":"IF(I52=\"Green\",1,IF(I52=\"Yellow\",0.75,IF(I52=\"Orange\",0.5,IF(I52=\"Brown\",0.25,0))))","v":0}]
[null,null,"-6m/s² EVT acceleration",null,null,{"$f":"IF(D53=\"Green\",1,IF(D53=\"Yellow\",0.75,IF(D53=\"Orange\",0.5,IF(D53=\"Brown\",0.25,0))))","v":0},null,null,null,null,{"$f":"IF(I53=\"Green\",1,IF(I53=\"Yellow\",0.75,IF(I53=\"Orange\",0.5,IF(I53=\"Brown\",0.25,0))))","v":0}]
[null,null,"40m headway"]
[null,null,"-2m/s² EVT acceleration",null,null,{"$f":"IF(D55=\"Green\",1,IF(D55=\"Yellow\",0.75,IF(D55=\"Orange\",0.5,IF(D55=\"Brown\",0.25,0))))","v":0},null,null,null,null,{"$f":"IF(I55=\"Green\",1,IF(I55=\"Yellow\",0.75,IF(I55=\"Orange\",0.5,IF(I55=\"Brown\",0.25,0))))","v":0}]
[null,null,"-6m/s² EVT acceleration",null,null,{"$f":"IF(D56=\"Green\",1,IF(D56=\"Yellow\",0.75,IF(D56=\"Orange\",0.5,IF(D56=\"Brown\",0.25,0))))","v":0},null,null,null,null,{"$f":"IF(I56=\"Green\",1,IF(I56=\"Yellow\",0.75,IF(I56=\"Orange\",0.5,IF(I56=\"Brown\",0.25,0))))","v":0}]
[null,"CCRb RESULT",null,{"$f":"SUM(F52:H53,F55:H56)/4","v":0},null,null,null,null,{"$f":"SUM(K52:M53,K55:M56)/4","v":0}]
[]
[null,"HMI"]
[null,null,"Additional HMI features"]
[null,null,"Suplementary warning","NO",null,{"$f":"IF(D61=\"Yes\",1,0)","v":0}]
[null,null,"Restraint activation / dynamic retractors","NO",null,{"$f":"IF(D62=\"Yes\",1,0)","v":0}]
[null,"HMI RESULT",null,{"$f":"SUM(F61:M62)/2","v":0}]
[]
[null,"SUMMARY"]
[null,null,"CCRs (prediction x correction factor)",{"$f":"IF(COUNTIF(D18:H20,\"Green\")=15,D33,0)","v":0},null,null,null,null,{"$f":"MIN(I33,1)","v":0}]
[null,null,"CCRm (prediction x correction factor)",{"$f":"MIN(D47,1)","v":0},null,null,null,null,{"$f":"MIN(I47,1)","v":0}]
[null,null,"CCRb",{"$f":"D57","v":0},null,null,null,null,{"$f":"I57","v":0}]
[null,null,"HMI",{"$f":"D63","v":0}]
[]
[null,"TOTAL"]
[null,null,"AEB",{"$f":"ROUND(AVERAGE(D66:H68)*2,Round)","v":0}]
[null,null,"FCW",{"$f":"ROUND(AVERAGE(I66:M68)*1.5,Round)","v":0}]
[null,null,"HMI",{"$f":"D69*0.5","v":0}]
[]
[null,"TOTAL AEB CAR-TO-CAR",null,{"$f":"IF(D15=\"PASS\",SUM(D72:M74),0)","v":0}]

{"sheet":"AEB Pedestrian","index":4,"n_rows":99,"n_cols":5,"rows_kept":99,"cut":false,"hidden":false,"merged":[[6,3,6,4],[7,3,7,4],[8,3,8,4],[1,1,3,2],[12,3,12,4],[1,3,2,4],[11,3,11,4],[10,3,10,4],[4,3,4,4],[5,3,5,4],[14,3,14,4],[30,3,30,4],[28,1,28,2],[28,3,28,4],[13,3,13,4],[16,1,16,2],[18,3,18,4],[15,3,15,4],[16,3,16,4],[52,1,52,2],[52,3,52,4],[40,1,40,2],[40,3,40,4],[42,3,42,4],[66,3,66,4],[76,1,76,2],[76,3,76,4],[54,3,54,4],[64,1,64,2],[64,3,64,4],[89,3,89,4],[90,3,90,4],[91,3,91,4],[86,1,86,2],[86,3,86,4],[88,1,88,2],[88,3,88,4],[92,3,92,4],[96,3,96,4],[98,1,98,2],[98,3,98,4],[93,3,93,4],[95,1,95,2],[95,3,95,4]]}
[3]
[null,"AEB Pedestrian",null,"Daytime"]
[]
[null,null,null,"Vimpact","Points"]
[null,"SYSTEM DETAILS"]
[null,null,"System Name"]
[null,null,"Functionality"]
[null,null,"Speed range (km/h) - Minimum"]
[null,null,"Maximum"]
[]
[null,"PREREQUISITES"]
[]
[null,null,"Default ON"]
[null,null,"Can identify slower walking pedestrian (CPNA-75)"]
[null,null,"System active from speeds of 10 km/h (CPNA-75)"]
[null,null,"System switches off below 80 km/h"]
[null,"PREREQUISITES",null,{"$f":"IF(AND(D13=\"YES\",D14=\"PASS\",D15=\"PASS\",D16=\"NO\"),\"PASS\",\"FAIL\")","v":"FAIL"}]
[]
[null,"CPFA-50"]
[null,1,20,null,{"$f":"IF(D20=\"\",0,ROUND(($C20-IF(D20>$C20,$C20,D20))/$C20*1,Round))","v":0}]
[null,2,25,null,{"$f":"IF(D21=\"\",0,ROUND(($C21-IF(D21>$C21,$C21,D21))/$C21*1,Round))","v":0}]
[null,2,30,null,{"$f":"IF(D22=\"\",0,ROUND(($C22-IF(D22>$C22,$C22,D22))/$C22*2,Round))","v":0}]
[null,3,35,null,{"$f":"IF(D23=\"\",0,ROUND(($C23-IF(D23>$C23,$C23,D23))/$C23*3,Round))","v":0}]
[null,3,40,null,{"$f":"IF(D24=\"\",0,ROUND(($C24-IF(D24>$C24,$C24,D24))/$C24*3,Round))","v":0}]
[null,null,45,null,{"$f":"IF(D25=\"\",0,IF(D25<=(C25-20),3,0))","v":0}]
[null,null,50,null,{"$f":"IF(D26=\"\",0,IF(D26<=(C26-20),2,0))","v":0}]
[null,null,55,null,{"$f":"IF(D27=\"\",0,IF(D27<=(C27-20),2,0))","v":0}]
[null,null,60,null,{"$f":"IF(D28=\"\",0,IF(D28<=(C28-20),1,0))","v":0}]
[null,"CPFA-50 RESULT",null,{"$f":"SUM(E20:E24,E25:E28)","v":0}]
[]
[null,"CPNA-25"]
[null,1,20,null,{"$f":"IF(D32=\"\",0,ROUND(($C32-IF(D32>$C32,$C32,D32))/$C32*1,Round))","v":0}]
[null,2,25,null,{"$f":"IF(D33=\"\",0,ROUND(($C33-IF(D33>$C33,$C33,D33))/$C33*1,Round))","v":0}]
[null,2,30,null,{"$f":"IF(D34=\"\",0,ROUND(($C34-IF(D34>$C34,$C34,D34))/$C34*2,Round))","v":0}]
[null,3,35,null,{"$f":"IF(D35=\"\",0,ROUND(($C35-IF(D35>$C35,$C35,D35))/$C35*3,Round))","v":0}]
[null,3,40,null,{"$f":"IF(D36=\"\",0,ROUND(($C36-IF(D36>$C36,$C36,D36))/$C36*3,Round))","v":0}]
[null,null,45,null,{"$f":"IF(D37=\"\",0,IF(D37<=(C37-20),3,0))","v":0}]
[null,null,50,null,{"$f":"IF(D38=\"\",0,IF(D38<=(C38-20),2,0))","v":0}]
[null,null,55,null,{"$f":"IF(D39=\"\",0,IF(D39<=(C39-20),2,0))","v":0}]
[null,null,60,null,{"$f":"IF(D40=\"\",0,IF(D40<=(C40-20),1,0))","v":0}]
[null,"CPNA-25 RESULT",null,{"$f":"SUM(E32:E36,E37:E40)","v":0}]
[]
[null,"CPNA-75"]
[null,1,20,null,{"$f":"IF(D44=\"\",0,ROUND(($C44-IF(D44>$C44,$C44,D44))/$C44*1,Round))","v":0}]
[null,2,25,null,{"$f":"IF(D45=\"\",0,ROUND(($C45-IF(D45>$C45,$C45,D45))/$C45*1,Round))","v":0}]
[null,2,30,null,{"$f":"IF(D46=\"\",0,ROUND(($C46-IF(D46>$C46,$C46,D46))/$C46*2,Round))","v":0}]
[null,3,35,null,{"$f":"IF(D47=\"\",0,ROUND(($C47-IF(D47>$C47,$C47,D47))/$C47*3,Round))","v":0}]
[null,3,40,null,{"$f":"IF(D48=\"\",0,ROUND(($C48-IF(D48>$C48,$C48,D48))/$C48*3,Round))","v":0}]
[null,null,45,null,{"$f":"IF(D49=\"\",0,IF(D49<=(C49-20),3,0))","v":0}]
[null,null,50,null,{"$f":"IF(D50=\"\",0,IF(D50<=(C50-20),2,0))","v":0}]
[null,null,55,null,{"$f":"IF(D51=\"\",0,IF(D51<=(C51-20),2,0))","v":0}]
[null,null,60,null,{"$f":"IF(D52=\"\",0,IF(D52<=(C52-20),1,0))","v":0}]
[null,"CPNA-75 RESULT",null,{"$f":"SUM(E44:E48,E49:E52)","v":0}]
[]
[null,"CPNC-50"]
[null,1,20,null,{"$f":"IF(D56=\"\",0,ROUND(($C56-IF(D56>$C56,$C56,D56))/$C56*1,Round))","v":0}]
[null,2,25,null,{"$f":"IF(D57=\"\",0,ROUND(($C57-IF(D57>$C57,$C57,D57))/$C57*1,Round))","v":0}]
[null,2,30,null,{"$f":"IF(D58=\"\",0,ROUND(($C58-IF(D58>$C58,$C58,D58))/$C58*2,Round))","v":0}]
[null,3,35,null,{"$f":"IF(D59=\"\",0,ROUND(($C59-IF(D59>$C59,$C59,D59))/$C59*3,Round))","v":0}]
[null,3,40,null,{"$f":"IF(D60=\"\",0,ROUND(($C60-IF(D60>$C60,$C60,D60))/$C60*3,Round))","v":0}]
[null,null,45,null,{"$f":"IF(D61=\"\",0,IF(D61<=(C61-20),3,0))","v":0}]
[null,null,50,null,{"$f":"IF(D62=\"\",0,IF(D62<=(C62-20),2,0))","v":0}]
[null,null,55,null,{"$f":"IF(D63=\"\",0,IF(D63<=(C63-20),2,0))","v":0}]
[null,null,60,null,{"$f":"IF(D64=\"\",0,IF(D64<=(C64-20),1,0))","v":0}]
[null,"CPNC-50 RESULT",null,{"$f":"SUM(E56:E60,E61:E64)","v":0}]
[]
[null,"CPLA-50"]
[null,1,20,null,{"$f":"IF(D68=\"\",0,ROUND((($C68-5)-(IF(D68<=5,5,IF(D68>$C68,$C68,D68))-5))/($C68-5)*$B68,Round))","v":0}]
[null,1,25,null,{"$f":"IF(D69=\"\",0,ROUND((($C69-5)-(IF(D69<=5,5,IF(D69>$C69,$C69,D69))-5))/($C69-5)*$B69,Round))","v":0}]
[null,1,30,null,{"$f":"IF(D70=\"\",0,ROUND((($C70-5)-(IF(D70<=5,5,IF(D70>$C70,$C70,D70))-5))/($C70-5)*$B70,Round))","v":0}]
[null,2,35,null,{"$f":"IF(D71=\"\",0,ROUND((($C71-5)-(IF(D71<=5,5,IF(D71>$C71,$C71,D71))-5))/($C71-5)*$B71,Round))","v":0}]
[null,2,40,null,{"$f":"IF(D72=\"\",0,ROUND((($C72-5)-(IF(D72<=5,5,IF(D72>$C72,$C72,D72))-5))/($C72-5)*$B72,Round))","v":0}]
[null,3,45,null,{"$f":"IF(D73=\"\",0,IF(D73<=(C73-20),$B73,0))","v":0}]
[null,3,50,null,{"$f":"IF(D74=\"\",0,IF(D74<=(C74-20),$B74,0))","v":0}]
[null,3,55,null,0]
[null,2,60,null,0]
[null,"CPLA-50 RESULT",null,{"$f":"SUM(E68:E72,E73:E76)","v":0}]
[]
[null,"CPLA-25",null,"TTCFCW","Points"]
[null,3,50,null,{"$f":"IF(D80=\"\",0,IF(D80>=1.7,$B80,0))","v":0}]
[null,3,55,null,{"$f":"IF(D81=\"\",0,IF(D81>=1.7,$B81,0))","v":0}]
[null,2,60,null,0]
[null,1,65,null,0]
[null,1,70,null,0]
[null,1,75,null,0]
[null,1,80,null,0]
[null,"CPLA-25 RESULT",null,{"$f":"SUM(E80:E84,E85:E86)","v":0}]
[]
[null,"SUMMARY",null,"DAYTIME"]
[null,null,"CPFA-50",{"$f":"ROUND(D29/18,Round)","v":0}]
[null,null,"CPNA-25",{"$f":"ROUND(D41/18,Round)","v":0}]
[null,null,"CPNA-75",{"$f":"ROUND(D53/18,Round)","v":0}]
[null,null,"CPNC-50",{"$f":"ROUND(D65/18,Round)","v":0}]
[null,null,"CPLA",{"$f":"ROUND((D77+D87)/30,Round)","v":0}]
[]
[null,"TOTAL"]
[null,null,"Daytime",{"$f":"IF(D17=\"FAIL\",0,ROUND(AVERAGE(D90:E94)*6,Round))","v":0}]
[]
[null,"TOTAL AEB Pedestrian",null,{"$f":"ROUND(SUM(D97:E97),Round)","v":0}]

{"sheet":"AEB Cyclist","index":5,"n_rows":54,"n_cols":5,"rows_kept":54,"cut":false,"hidden":false,"merged":[[1,1,3,2],[26,1,26,2],[26,3,26,4],[37,3,37,4],[47,1,47,2],[28,3,28,4],[16,3,16,4],[37,1,37,2],[14,1,14,2],[14,3,14,4],[11,3,11,4],[47,3,47,4],[1,3,2,4],[12,3,12,4],[13,3,13,4],[10,3,10,4],[53,1,53,2],[53,3,53,4],[52,3,52,4],[51,3,51,4],[49,1,49,2],[49,3,49,4],[50,3,50,4],[4,3,4,4],[5,3,5,4],[6,3,6,4],[7,3,7,4],[8,3,8,4]]}
[3]
[null,"AEB Cyclist"]
[]
[null,null,null,"Vimpact","Points"]
[null,"SYSTEM DETAILS"]
[null,null,"System Name"]
[null,null,"Functionality"]
[null,null,"Speed range (km/h) - Minimum"]
[null,null,"Maximum"]
[]
[null,"PREREQUISITES"]
[]
[null,null,"Default ON"]
[null,null,"System switches off below 80 km/h"]
[null,"PREREQUISITES",null,{"$f":"IF(AND(D13=\"YES\",D14=\"NO\"),\"PASS\",\"FAIL\")","v":"FAIL"}]
[]
[null,"CBNA"]
[null,null,20,null,{"$f":"IF(D18=\"\",0,ROUND(($C18-IF(D18>$C18,$C18,D18))/$C18*1,Round))","v":0}]
[null,null,25,null,{"$f":"IF(D19=\"\",0,ROUND(($C19-IF(D19>$C19,$C19,D19))/$C19*1,Round))","v":0}]
[null,null,30,null,{"$f":"IF(D20=\"\",0,ROUND(($C20-IF(D20>$C20,$C20,D20))/$C20*1,Round))","v":0}]
[null,null,35,null,{"$f":"IF(D21=\"\",0,ROUND(($C21-IF(D21>$C21,$C21,D21))/$C21*1,Round))","v":0}]
[null,null,40,null,{"$f":"IF(D22=\"\",0,ROUND(($C22-IF(D22>$C22,$C22,D22))/$C22*1,Round))","v":0}]
[null,null,45,null,{"$f":"IF(D23=\"\",0,IF(D23<=(C23-20),1,0))","v":0}]
[null,null,50,null,{"$f":"IF(D24=\"\",0,IF(D24<=(C24-20),1,0))","v":0}]
[null,null,55,null,{"$f":"IF(D25=\"\",0,IF(D25<=(C25-20),1,0))","v":0}]
[null,null,60,null,{"$f":"IF(D26=\"\",0,IF(D26<=(C26-20),1,0))","v":0}]
[null,"CBNA-50 RESULT",null,{"$f":"SUM(E18:E22,E23:E26)","v":0}]
[]
[null,"CBLA-50"]
[null,1,25,null,{"$f":"IF(D30=\"\",0,ROUND((($C30-15)-(IF(D30<=15,15,IF(D30>$C30,$C30,D30))-15))/($C30-15)*$B30,Round))","v":0}]
[null,1,30,null,{"$f":"IF(D31=\"\",0,ROUND((($C31-15)-(IF(D31<=15,15,IF(D31>$C31,$C31,D31))-15))/($C31-15)*$B31,Round))","v":0}]
[null,2,35,null,{"$f":"IF(D32=\"\",0,ROUND((($C32-15)-(IF(D32<=15,15,IF(D32>$C32,$C32,D32))-15))/($C32-15)*$B32,Round))","v":0}]
[null,2,40,null,{"$f":"IF(D33=\"\",0,ROUND((($C33-15)-(IF(D33<=15,15,IF(D33>$C33,$C33,D33))-15))/($C33-15)*$B33,Round))","v":0}]
[null,3,45,null,{"$f":"IF(D34=\"\",0,IF(D34<=(C34-20),$B34,0))","v":0}]
[null,3,50,null,{"$f":"IF(D35=\"\",0,IF(D35<=(C35-20),$B35,0))","v":0}]
[null,3,55,null,0]
[null,1,60,null,0]
[null,"CBLA-50 RESULT",null,{"$f":"SUM(E30:E33,E34:E37)","v":0}]
[]
[null,"CBLA-25",null,"TTCFCW","Points"]
[null,3,50,null,{"$f":"IF(D41=\"\",0,IF(D41>=1.7,$B41,0))","v":0}]
[null,3,55,null,{"$f":"IF(D42=\"\",0,IF(D42>=1.7,$B42,0))","v":0}]
[null,1,60,null,0]
[null,1,65,null,0]
[null,1,70,null,0]
[null,1,75,null,0]
[null,1,80,null,0]
[null,"CBLA-25 RESULT",null,{"$f":"SUM(E41:E45,E46:E47)","v":0}]
[]
[null,"SUMMARY"]
[null,null,"CBNA-50",{"$f":"ROUND(D27/9,Round)","v":0}]
[null,null,"CBLA",{"$f":"ROUND((D38+D48)/27,Round)","v":0}]
[]
[null,"TOTAL AEB Cyclist",null,{"$f":"IF(D15=\"FAIL\",0,ROUND(AVERAGE(D51:E52)*6,Round))","v":0}]

{"sheet":"LSS","index":6,"n_rows":90,"n_cols":13,"rows_kept":90,"cut":false,"hidden":false,"merged":[[6,3,6,14],[4,3,4,14],[5,3,5,14],[1,3,3,14],[17,3,17,6],[17,7,17,10],[17,11,17,14],[13,1,13,2],[13,3,13,14],[14,1,14,14],[15,3,15,14],[16,3,16,6],[16,7,16,10],[16,11,16,14],[7,3,7,14],[8,3,8,14],[9,1,9,14],[11,3,11,14],[10,3,10,14],[12,3,12,14],[1,1,3,2],[18,3,18,6],[18,7,18,10],[18,11,18,14],[19,3,19,6],[43,1,43,2],[43,3,43,14],[29,3,29,8],[41,3,41,14],[29,9,29,14],[30,3,30,8],[30,9,30,14],[28,1,28,2],[28,3,28,14],[21,3,21,6],[21,7,21,10],[21,11,21,14],[22,1,22,2],[22,3,22,14],[19,7,19,10],[19,11,19,14],[20,3,20,6],[20,7,20,10],[20,11,20,14],[26,3,26,14],[31,3,31,8],[31,9,31,14],[32,3,32,8],[32,9,32,14],[33,3,33,8],[33,9,33,14],[23,3,23,14],[24,3,24,14],[25,3,25,14],[27,3,27,14],[45,3,45,8],[45,9,45,14],[46,3,46,5],[46,6,46,8],[46,9,46,11],[46,12,46,14],[34,3,34,8],[34,9,34,14],[41,1,41,2],[42,1,42,14],[44,1,44,14],[35,3,35,8],[35,9,35,14],[36,3,36,8],[36,9,36,14],[37,3,37,8],[37,9,37,14],[38,3,38,8],[38,9,38,14],[39,3,39,8],[39,9,39,14],[40,3,40,8],[40,9,40,14],[49,3,49,5],[49,6,49,8],[49,9,49,11],[49,12,49,14],[50,3,50,5],[50,6,50,8],[50,9,50,11],[50,12,50,14],[47,3,47,5],[47,6,47,8],[47,9,47,11],[47,12,47,14],[48,3,48,5],[48,6,48,8],[48,9,48,11],[48,12,48,14],[53,3,53,5],[53,6,53,8],[53,9,53,11],[53,12,53,14],[54,3,54,5],[54,6,54,8],[54,9,54,11],[54,12,54,14],[51,1,51,2],[51,3,51,8],[51,9,51,14],[52,3,52,8],[52,9,52,14],[58,1,58,2],[58,3,58,8],[58,9,58,14],[55,3,55,5],[55,6,55,8],[55,9,55,11],[55,12,55,14],[56,3,56,5],[56,6,56,8],[56,9,56,11],[56,12,56,14],[59,3,59,8],[59,9,59,14],[60,3,60,5],[60,6,60,8],[60,9,60,11],[60,12,60,14],[57,3,57,5],[57,6,57,8],[57,9,57,11],[57,12,57,14],[63,3,63,5],[63,6,63,8],[63,9,63,11],[63,12,63,14],[64,3,64,5],[64,6,64,8],[64,9,64,11],[64,12,64,14],[61,3,61,5],[61,6,61,8],[61,9,61,11],[61,12,61,14],[62,3,62,5],[62,6,62,8],[62,9,62,11],[62,12,62,14],[68,1,68,14],[79,3,79,14],[80,3,80,14],[81,3,81,14],[82,1,82,2],[82,3,82,14],[65,1,65,2],[65,3,65,8],[65,9,65,14],[66,1,66,14],[67,1,67,2],[67,3,67,14],[69,3,69,8],[69,9,69,14],[70,3,70,5],[70,6,70,8],[70,9,70,11],[70,12,70,14],[71,3,71,5],[71,6,71,8],[71,9,71,11],[71,12,71,14],[72,3,72,5],[72,6,72,8],[87,3,87,14],[88,1,88,14],[89,1,89,2],[89,3,89,14],[83,1,83,14],[84,1,84,2],[84,3,84,14],[85,3,85,14],[86,3,86,14],[75,1,75,2],[75,3,75,8],[75,9,75,14],[76,1,76,14],[77,1,77,2],[77,3,77,14],[78,1,78,14],[72,9,72,11],[72,12,72,14],[73,3,73,5],[73,6,73,8],[73,9,73,11],[73,12,73,14],[74,3,74,5],[74,6,74,8],[74,9,74,11],[74,12,74,14]]}
[3]
[null,"Lane Support Systems"]
[]
[]
[null,"SYSTEM DETAILS"]
[null,null,"System Name"]
[null,null,"Default ON (partly)"]
[null,null,"Speed range (km/h) - Minimum"]
[null,null,"Maximum"]
[]
[null,"PREREQUISITES"]
[]
[null,null,"ESC meeting R13H"]
[null,"PREREQUISITES",null,{"$f":"IF(AND(D13=\"YES\"),\"PASS\",\"FAIL\")","v":"FAIL"}]
[]
[null,"Emergency Lane Keeping"]
[null,null,"Road Edge","No line",null,null,null,"Dashed line",null,null,null,"Solid line"]
[null,null,0.2]
[null,null,0.3]
[null,null,0.4]
[null,null,0.5]
[null,null,null,{"$f":"IF(OR(COUNTIF(D18:G21,\">-0.1\")=4,COUNTIF(D18:G21,\">-0,1\")=4),0.25,0)","v":0},null,null,null,{"$f":"IF(OR(COUNTIF(H18:K21,\">-0.1\")=4,COUNTIF(H18:K21,\">-0,1\")=4),0.25,0)","v":0},null,null,null,{"$f":"IF(OR(COUNTIF(L18:O21,\">-0.1\")=4,COUNTIF(L18:O21,\">-0,1\")=4),0.25,0)","v":0}]
[null,"ELK Road Edge assessment",null,{"$f":"SUM(D22:L22)","v":0}]
[null,null,"Oncoming vehicle"]
[null,null,0.3]
[null,null,0.4]
[null,null,0.5]
[null,null,0.6]
[null,"ELK Oncoming vehicle assessment",null,{"$f":"IF(COUNTIF(D25:O28,\"PASS\")=4,0.5,0)","v":0}]
[null,null,"Overtaking vehicle (GVT @ 72km/h)","Unintentional",null,null,null,null,null,"Intentional"]
[null,null,0.3]
[null,null,0.4]
[null,null,0.5]
[null,null,0.6]
[null,null,0.7]
[null,null,"Overtaking vehicle (GVT @ 80km/h)"]
[null,null,0.3]
[null,null,0.4]
[null,null,0.5]
[null,null,0.6]
[null,null,0.7]
[null,"ELK Overtaking vehicle assessment",null,{"$f":"IF(COUNTIF(D31:O41,\"PASS\")=14,0.25,0)","v":0}]
[]
[null,"ELK RESULT",null,{"$f":"SUM(D23,D29,D42)","v":0}]
[]
[null,"Lane Keep Assist",null,"Single lane marking",null,null,null,null,null,"Fully marked lane"]
[null,null,"Road Edge",null,null,null,"Passenger side",null,null,null,null,null,"Passenger side"]
[null,null,0.2]
[null,null,0.3]
[null,null,0.4]
[null,null,0.5]
[null,"LKA Road Edge assessment",null,{"$f":"IF(OR(COUNTIF(D48:I51,\">-0.1\")=4,COUNTIF(D48:I51,\">-0,1\")=4),0.25,0)","v":0},null,null,null,null,null,{"$f":"IF(OR(COUNTIF(J48:O51,\">-0.1\")=4,COUNTIF(J48:O51,\">-0,1\")=4),0.25,0)","v":0}]
[null,null,null,"Single lane marking",null,null,null,null,null,"Fully marked lane"]
[null,null,"Dashed Line","Driver side",null,null,"Passenger side",null,null,"Driver side",null,null,"Passenger side"]
[null,null,0.2]
[null,null,0.3]
[null,null,0.4]
[null,null,0.5]
[null,"LKA Dashed Line assessment",null,{"$f":"IF(OR(COUNTIF(D55:I58,\">-0.3\")=8,COUNTIF(D55:I58,\">-0,3\")=8),0.25,0)","v":0},null,null,null,null,null,{"$f":"IF(OR(COUNTIF(J55:O58,\">-0.3\")=8,COUNTIF(J55:O58,\">-0,3\")=8),0.5,0)","v":0}]
[null,null,null,"Single lane marking",null,null,null,null,null,"Fully marked lane"]
[null,null,"Solid Line","Driver side",null,null,"Passenger side",null,null,"Driver side",null,null,"Passenger side"]
[null,null,0.2]
[null,null,0.3]
[null,null,0.4]
[null,null,0.5]
[null,"LKA Solid Line assessment",null,{"$f":"IF(OR(COUNTIF(D62:I65,\">-0.3\")=8,COUNTIF(D62:I65,\">-0,3\")=8),0.25,0)","v":0},null,null,null,null,null,{"$f":"IF(OR(COUNTIF(J62:O65,\">-0.3\")=8,COUNTIF(J62:O65,\">-0,3\")=8),0.5,0)","v":0}]
[]
[null,"LKA RESULT",null,{"$f":"SUM(D52,J52,D59,J59,D66,J66)","v":0}]
[]
[null,"Lane Departure Warning",null,"Solid Line",null,null,null,null,null,"Dashed Line"]
[null,null,"Single lane marking","Driver side",null,null,"Passenger side",null,null,"Driver side",null,null,"Passenger side"]
[null,null,0.2]
[null,null,0.3]
[null,null,0.4]
[null,null,0.5]
[null,"LDW Solid Line assessment",null,{"$f":"IF(OR(COUNTIF(D72:I75,\">-0.2\")=8,COUNTIF(D72:I75,\">-0,2\")=8),\"PASS\",\"FAIL\")","v":"FAIL"},null,null,null,null,null,{"$f":"IF(OR(COUNTIF(J72:O75,\">-0.2\")=8,COUNTIF(J72:O75,\">-0,2\")=8),\"PASS\",\"FAIL\")","v":"FAIL"}]
[]
[null,"LDW RESULT",null,{"$f":"IF(AND(D76=\"PASS\",J76=\"PASS\"),\"PASS\",\"FAIL\")","v":"FAIL"}]
[]
[null,"HMI"]
[null,1,"Lane Departure Warning",{"$f":"D78","v":"FAIL"}]
[null,2,"Blind Spot Monitoring"]
[null,"HMI RESULT",null,{"$f":"IF(D81=\"PASS\",0.25,0)+IF(D82=\"PASS\",0.25,0)","v":0}]
[]
[null,"SUMMARY"]
[null,null,"ELK",{"$f":"D44","v":0}]
[null,null,"LKA",{"$f":"D68","v":0}]
[null,null,"HMI",{"$f":"D83","v":0}]
[]
[null,"TOTAL Lane Support Systems",null,{"$f":"IF(D14=\"FAIL\",0,ROUND(SUM(D86:O88),Round))","v":0}]

{"sheet":"SAS","index":7,"n_rows":48,"n_cols":5,"rows_kept":48,"cut":false,"hidden":false,"merged":[[8,3,8,4],[27,1,27,2],[27,3,27,4],[6,3,6,4],[1,3,2,4],[4,3,4,4],[5,3,5,4],[9,3,9,4],[11,3,11,4],[1,1,3,2],[47,1,47,2],[47,3,47,4],[41,1,41,2],[41,3,41,4],[44,3,44,4],[43,1,43,2],[43,3,43,4],[29,3,29,4],[30,3,30,4],[45,3,45,4],[32,3,32,4],[31,3,31,4]]}
[]
[null,"Speed Assistance System"]
[]
[null,null,null,"Value","Score"]
[null,"SYSTEM DETAILS"]
[null,null,"System name"]
[null,null,"Functionality"]
[]
[null,"SPEED LIMIT INFORMATION FUNCTION"]
[null,null,"Type of system"]
[null,null,"General requirements",null,{"$f":"IF(D11=\"Pass\",0.5,0)","v":0}]
[null,null,"Advanced Functions"]
[null,null,"Weather - Rain / Wetness",null,{"$f":"IF(D13=\"Pass\",0.05,0)","v":0}]
[null,null,"Weather - Snow / Icy",null,{"$f":"IF(D14=\"Pass\",0.05,0)","v":0}]
[null,null,"Time",null,{"$f":"IF(D15=\"Pass\",0.075,0)","v":0}]
[null,null,"Distance For / In",null,{"$f":"IF(D16=\"Pass\",0.025,0)","v":0}]
[null,null,"Arrows",null,{"$f":"IF(D17=\"Pass\",0.025,0)","v":0}]
[null,null,"Vehicle Categories",null,{"$f":"IF(D18=\"Pass\",0.025,0)","v":0}]
[null,null,"Implicit Speed Limits - Highway / Motorway",null,{"$f":"IF(D19=\"Pass\",0.05,0)","v":0}]
[null,null,"Implicit Speed Limits - City Entry / Exit",null,{"$f":"IF(D20=\"Pass\",0.075,0)","v":0}]
[null,null,"Implicit Speed Limits - Residential Zones",null,{"$f":"IF(D21=\"Pass\",0.05,0)","v":0}]
[null,null,"Dynamic Speed Limits",null,{"$f":"IF(D22=\"Pass\",0.075,0)","v":0}]
[null,null,"System Accuracy",null,{"$f":"IF(SUM(E13:E22)>0.3,0.25,0)","v":0}]
[null,null,"Warning Function",null,{"$f":"IF(AND(E25=\"Pass\",E26=\"Pass\",E27=\"Pass\"),0.25,0)","v":0}]
[null,null,"Position of warning",null,{"$f":"IF(D25=\"\",\"\",IF(D25<>\"Other\",\"Pass\",\"Fail\"))","v":""}]
[null,null,"Type of warning",null,{"$f":"IF(D26=\"\",\"\",IF(D26<>\"Other\",\"Pass\",\"Fail\"))","v":""}]
[null,null,"Total duration ",null,{"$f":"IF(D27=\"\",\"\",IF(AND(D27<>\"\",D27>=10),\"Pass\",\"Fail\"))","v":""}]
[null,"SPEED LIMIT INFORMATION FUNCTION RESULT",null,{"$f":"SUM(E11:E24)","v":0}]
[]
[null,"SPEED CONTROL FUNCTION"]
[null,null,"Setting Vadj"]
[]
[null,null,"50 km/h test"]
[null,null,"Vstab",null,{"$f":"IF(AND(D34<>\"\",D34>=45),\"Pass\",\"Fail\")","v":"Fail"}]
[null,null,"difference between Vstab and Vadj",{"$f":"IF(D34=\"\",\"\",50-D34)","v":""}]
[null,null,"80 km/h test"]
[null,null,"Vstab",null,{"$f":"IF(AND(D37<>\"\",D37>=75),\"Pass\",\"Fail\")","v":"Fail"}]
[null,null,"difference between Vstab and Vadj",{"$f":"IF(D37=\"\",\"\",80-D37)","v":""}]
[null,null,"120 km/h test"]
[null,null,"Vstab",null,{"$f":"IF(AND(D40<>\"\",D40>=115),\"Pass\",\"Fail\")","v":"Fail"}]
[null,null,"difference between Vstab and Vadj",{"$f":"IF(D40=\"\",\"\",120-D40)","v":""}]
[null,"SPEED CONTROL FUNCTION RESULT",null,{"$f":"IF(AND(D35<=5,D38<=5,D41<=5),IF(D31=\"System advised\",1.5,IF(D31=\"Manually set\",IF(D28>0,0.75,1.25),0)),0)","v":0}]
[]
[null,"SUMMARY"]
[null,null,"Speed Limit Information Function",{"$f":"D28","v":0}]
[null,null,"Speed Control Function",{"$f":"D42","v":0}]
[]
[null,"TOTAL SAS",null,{"$f":"ROUND(SUM(D45:E46),Round)","v":0}]

{"sheet":"OSM","index":8,"n_rows":21,"n_cols":6,"rows_kept":21,"cut":false,"hidden":false,"merged":[[1,1,3,2],[13,1,13,2],[13,3,13,6],[15,1,15,2],[15,3,15,6],[10,3,10,4],[10,5,10,6],[11,3,11,4],[11,5,12,6],[12,3,12,4],[8,1,8,2],[3,5,3,6],[8,3,8,4],[8,5,8,6],[3,3,3,4],[6,5,6,6],[17,3,17,6],[19,1,19,2],[19,3,19,6],[16,3,16,6],[7,3,7,4],[7,5,7,6],[6,3,6,4],[5,5,5,6],[5,3,5,4],[1,3,2,4],[4,3,4,4],[1,5,2,6],[4,5,4,6]]}
[]
[null,"Occupant Status Monitoring",null,"Driver",null,"Front Passenger"]
[]
[null,null,null,"Score",null,"Score"]
[null,"SEAT BELT REMINDER"]
[null,null,"Occupant detection"]
[null,null,"Visual warning"]
[null,null,"Audible warning"]
[null,"Seat Belt Reminder assessment",null,{"$f":"IF(COUNTIF(D6:E8,\"Pass\")=2,1,0)","v":0},null,{"$f":"IF(COUNTIF(F6:G8,\"Pass\")=3,1,0)","v":0}]
[]
[null,"DRIVER MONITORING"]
[null,null,"Default ON",null,null,{"$f":"IF(AND(D12=\"PASS\",D13=\"PASS\"),1,0)","v":0}]
[null,null,"Attention Assist fitment"]
[null,"Driver Monitoring assessment",null,{"$f":"F12","v":0}]
[]
[null,"SUMMARY"]
[null,null,"Seat Belt Reminder assessment",{"$f":"SUM(D9:G9)","v":0}]
[null,null,"Driver Monitoring assessment",{"$f":"D14","v":0}]
[]
[null,"TOTAL OCCUPANT STATUS MONITORING",null,{"$f":"D17+D18","v":0}]
[null,null,null,{"$f":"IF(AND(D9=2,#REF!>0),\"All seats\",IF(D9=2,\"Front seats\",\"Not available\"))","v":{"$error":"#REF!"}}]

{"sheet":"Summary","index":9,"n_rows":166,"n_cols":24,"rows_kept":166,"cut":false,"hidden":true,"merged":[[39,22,39,23],[37,12,37,13],[37,15,37,16],[38,12,38,13],[38,15,38,16],[39,19,39,20],[54,12,54,13],[54,15,54,16],[54,19,54,20],[54,22,54,23],[40,19,40,20],[40,22,40,23],[53,12,53,13],[53,15,53,16],[53,19,53,20],[53,22,53,23]]}
["Make",{"$f":"'General Overview'!C3","v":0},"text"]
["Model",{"$f":"'General Overview'!C4","v":0},"text"]
["Full Tested Vehicle",{"$f":"'General Overview'!C5","v":0},"text"]
["Rating/grading",{"$f":"'OVERALL RATING'!F2","v":"NOT RECOMMENDED"},"platinum - gold - silver - bronze - not recommended"]
["Safety Assist Performance score",{"$f":"'OVERALL RATING'!F14","v":0},"%"]
["Specification"]
["Body type",{"$f":"'General Overview'!C6","v":0},"Monocoque"]
["Category",{"$f":"'General Overview'!C7","v":0},"text","N1 - N2"]
["Kerb weight",{"$f":"'General Overview'!C9","v":0},"number"]
["Maximum Payload",{"$f":"'General Overview'!C11","v":0},"number"]
["Test weight",{"$f":"'General Overview'!C12","v":0},"number"]
["Applies to",{"$f":"'General Overview'!C17","v":0},"x generation"]
["Safety equipment"]
["SBR - Driver",{"$f":"FITMENT!D47","v":"N/A"},"standard/optional/not available"]
["SBR - Passenger",{"$f":"FITMENT!E47","v":"N/A"},"standard/optional/not available"]
["AEB Car-to-Car",{"$f":"FITMENT!D14","v":"N/A"},"standard/optional/not available"]
["AEB Pedestrian",{"$f":"FITMENT!E14","v":"N/A"},"standard/optional/not available"]
["AEB Cyclist",{"$f":"FITMENT!F14","v":"N/A"},"standard/optional/not available"]
["Attention Assist",{"$f":"FITMENT!F47","v":"N/A"},"standard/optional/not available"]
["Comment",{"$f":"'OVERALL RATING'!B19","v":0},"text"]
["Safety Assist Performance Details"]
["AEB Car-to-Car - score",{"$f":"IF(B16=\"n/a\",\"N/A$\",'OVERALL RATING'!G6)","v":"N/A$"},"number - 1 decimal"]
["AEB Car-to-Car - colour",{"$f":"IF(B16=\"N/A\",\"Grey\",IF(B22/30>=0.75,\"Green\",IF(B22/30>=0.5,\"Yellow\",IF(B22/30>=0.25,\"Orange\",IF(B22/30>0,\"Brown\",\"Red\")))))","v":"Grey"},"Green - Yellow - Orange - Brown - Red"]
["AEB_Type",{"$f":"IF(B22=\"N/A$\",\"\",CONCATENATE(IF('AEB Car-to-Car'!D7=\"YES\",\"AEB\",\"\"),IF(AND('AEB Car-to-Car'!D7=\"YES\",'AEB Car-to-Car'!I7=\"YES\"),\" & \",\"\"),IF('AEB Car-to-Car'!I7=\"YES\",\"FCW\",\"\")))","v":""},"text"]
["AEB_Operational from",{"$f":"IF(B22=\"N/A$\",\"\",MIN('AEB Car-to-Car'!D8,'AEB Car-to-Car'!I8))","v":""},"text"]
["AEB_Additional information","???","text"]
["Autobrake function only",null,null,null,null,null,null,null,null,null,null,"CCRs"]
["AFO_Approaching a stationary car - right overlap",{"$f":"IF(B$22=\"N/A$\",\"Grey\",P39)","v":"Grey"},"Green - Yellow - Orange - Brown - Red",null,null,null,null,null,"Green",1,null,"AEB",null,null,null,null,null,null,"FCW"]
["AFO_Approaching a stationary car - no overlap",{"$f":"IF(B$22=\"N/A$\",\"Grey\",O39)","v":"Grey"},"Green - Yellow - Orange - Brown - Red",null,null,null,null,null,"Yellow",0.75,null,1,{"$f":"VLOOKUP('AEB Car-to-Car'!D18,Summary!$I$28:$J$32,2,0)*$L29","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('AEB Car-to-Car'!E18,Summary!$I$28:$J$32,2,0)*$L29","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('AEB Car-to-Car'!F18,Summary!$I$28:$J$32,2,0)*$L29","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('AEB Car-to-Car'!G18,Summary!$I$28:$J$32,2,0)*$L29","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('AEB Car-to-Car'!H18,Summary!$I$28:$J$32,2,0)*$L29","v":{"$error":"#N/A"}},null,2,{"$f":"VLOOKUP('AEB Car-to-Car'!I22,Summary!$I$28:$J$32,2,0)*$S29","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('AEB Car-to-Car'!J22,Summary!$I$28:$J$32,2,0)*$S29","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('AEB Car-to-Car'!K22,Summary!$I$28:$J$32,2,0)*$S29","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('AEB Car-to-Car'!L22,Summary!$I$28:$J$32,2,0)*$S29","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('AEB Car-to-Car'!M22,Summary!$I$28:$J$32,2,0)*$S29","v":{"$error":"#N/A"}}]
["AFO_Approaching a stationary car - left overlap",{"$f":"IF(B$22=\"N/A$\",\"Grey\",M39)","v":"Grey"},"Green - Yellow - Orange - Brown - Red",null,null,null,null,null,"Orange",0.5,null,2,{"$f":"VLOOKUP('AEB Car-to-Car'!D19,Summary!$I$28:$J$32,2,0)*$L30","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('AEB Car-to-Car'!E19,Summary!$I$28:$J$32,2,0)*$L30","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('AEB Car-to-Car'!F19,Summary!$I$28:$J$32,2,0)*$L30","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('AEB Car-to-Car'!G19,Summary!$I$28:$J$32,2,0)*$L30","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('AEB Car-to-Car'!H19,Summary!$I$28:$J$32,2,0)*$L30","v":{"$error":"#N/A"}},null,2,{"$f":"VLOOKUP('AEB Car-to-Car'!I23,Summary!$I$28:$J$32,2,0)*$S30","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('AEB Car-to-Car'!J23,Summary!$I$28:$J$32,2,0)*$S30","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('AEB Car-to-Car'!K23,Summary!$I$28:$J$32,2,0)*$S30","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('AEB Car-to-Car'!L23,Summary!$I$28:$J$32,2,0)*$S30","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('AEB Car-to-Car'!M23,Summary!$I$28:$J$32,2,0)*$S30","v":{"$error":"#N/A"}}]
["AFO_Approaching a slower moving car - right overlap",{"$f":"IF(B$22=\"N/A$\",\"Grey\",P55)","v":"Grey"},"Green - Yellow - Orange - Brown - Red",null,null,null,null,null,"Brown",0.25,null,2,{"$f":"VLOOKUP('AEB Car-to-Car'!D20,Summary!$I$28:$J$32,2,0)*$L31","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('AEB Car-to-Car'!E20,Summary!$I$28:$J$32,2,0)*$L31","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('AEB Car-to-Car'!F20,Summary!$I$28:$J$32,2,0)*$L31","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('AEB Car-to-Car'!G20,Summary!$I$28:$J$32,2,0)*$L31","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('AEB Car-to-Car'!H20,Summary!$I$28:$J$32,2,0)*$L31","v":{"$error":"#N/A"}},null,2,{"$f":"VLOOKUP('AEB Car-to-Car'!I24,Summary!$I$28:$J$32,2,0)*$S31","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('AEB Car-to-Car'!J24,Summary!$I$28:$J$32,2,0)*$S31","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('AEB Car-to-Car'!K24,Summary!$I$28:$J$32,2,0)*$S31","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('AEB Car-to-Car'!L24,Summary!$I$28:$J$32,2,0)*$S31","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('AEB Car-to-Car'!M24,Summary!$I$28:$J$32,2,0)*$S31","v":{"$error":"#N/A"}}]
["AFO_Approaching a slower moving car - no overlap",{"$f":"IF(B$22=\"N/A$\",\"Grey\",O55)","v":"Grey"},"Green - Yellow - Orange - Brown - Red",null,null,null,null,null,"Red",0,null,2,{"$f":"VLOOKUP('AEB Car-to-Car'!D21,Summary!$I$28:$J$32,2,0)*$L32","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('AEB Car-to-Car'!E21,Summary!$I$28:$J$32,2,0)*$L32","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('AEB Car-to-Car'!F21,Summary!$I$28:$J$32,2,0)*$L32","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('AEB Car-to-Car'!G21,Summary!$I$28:$J$32,2,0)*$L32","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('AEB Car-to-Car'!H21,Summary!$I$28:$J$32,2,0)*$L32","v":{"$error":"#N/A"}},null,2,{"$f":"VLOOKUP('AEB Car-to-Car'!I25,Summary!$I$28:$J$32,2,0)*$S32","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('AEB Car-to-Car'!J25,Summary!$I$28:$J$32,2,0)*$S32","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('AEB Car-to-Car'!K25,Summary!$I$28:$J$32,2,0)*$S32","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('AEB Car-to-Car'!L25,Summary!$I$28:$J$32,2,0)*$S32","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('AEB Car-to-Car'!M25,Summary!$I$28:$J$32,2,0)*$S32","v":{"$error":"#N/A"}}]
["AFO_Approaching a slower moving car - left overlap",{"$f":"IF(B$22=\"N/A$\",\"Grey\",M55)","v":"Grey"},"Green - Yellow - Orange - Brown - Red",null,null,null,null,null,null,null,null,2,{"$f":"VLOOKUP('AEB Car-to-Car'!D22,Summary!$I$28:$J$32,2,0)*$L33","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('AEB Car-to-Car'!E22,Summary!$I$28:$J$32,2,0)*$L33","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('AEB Car-to-Car'!F22,Summary!$I$28:$J$32,2,0)*$L33","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('AEB Car-to-Car'!G22,Summary!$I$28:$J$32,2,0)*$L33","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('AEB Car-to-Car'!H22,Summary!$I$28:$J$32,2,0)*$L33","v":{"$error":"#N/A"}},null,3,{"$f":"VLOOKUP('AEB Car-to-Car'!I26,Summary!$I$28:$J$32,2,0)*$S33","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('AEB Car-to-Car'!J26,Summary!$I$28:$J$32,2,0)*$S33","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('AEB Car-to-Car'!K26,Summary!$I$28:$J$32,2,0)*$S33","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('AEB Car-to-Car'!L26,Summary!$I$28:$J$32,2,0)*$S33","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('AEB Car-to-Car'!M26,Summary!$I$28:$J$32,2,0)*$S33","v":{"$error":"#N/A"}}]
["AFO_Approaching a braking car",{"$f":"IF(B$22=\"N/A$\",\"Grey\",IF('AEB Car-to-Car'!D57>=0.75,\"Green\",IF('AEB Car-to-Car'!D57>=0.5,\"Yellow\",IF('AEB Car-to-Car'!D57>=0.25,\"Orange\",IF('AEB Car-to-Car'!D57>0,\"Brown\",\"Red\")))))","v":"Grey"},"Green - Yellow - Orange - Brown - Red",null,null,null,null,null,null,null,null,2,{"$f":"VLOOKUP('AEB Car-to-Car'!D23,Summary!$I$28:$J$32,2,0)*$L34","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('AEB Car-to-Car'!E23,Summary!$I$28:$J$32,2,0)*$L34","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('AEB Car-to-Car'!F23,Summary!$I$28:$J$32,2,0)*$L34","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('AEB Car-to-Car'!G23,Summary!$I$28:$J$32,2,0)*$L34","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('AEB Car-to-Car'!H23,Summary!$I$28:$J$32,2,0)*$L34","v":{"$error":"#N/A"}},null,2,{"$f":"VLOOKUP('AEB Car-to-Car'!I27,Summary!$I$28:$J$32,2,0)*$S34","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('AEB Car-to-Car'!J27,Summary!$I$28:$J$32,2,0)*$S34","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('AEB Car-to-Car'!K27,Summary!$I$28:$J$32,2,0)*$S34","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('AEB Car-to-Car'!L27,Summary!$I$28:$J$32,2,0)*$S34","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('AEB Car-to-Car'!M27,Summary!$I$28:$J$32,2,0)*$S34","v":{"$error":"#N/A"}}]
["Driver Reacts to Warning",null,null,null,null,null,null,null,null,null,null,1,{"$f":"VLOOKUP('AEB Car-to-Car'!D24,Summary!$I$28:$J$32,2,0)*$L35","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('AEB Car-to-Car'!E24,Summary!$I$28:$J$32,2,0)*$L35","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('AEB Car-to-Car'!F24,Summary!$I$28:$J$32,2,0)*$L35","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('AEB Car-to-Car'!G24,Summary!$I$28:$J$32,2,0)*$L35","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('AEB Car-to-Car'!H24,Summary!$I$28:$J$32,2,0)*$L35","v":{"$error":"#N/A"}},null,1,{"$f":"VLOOKUP('AEB Car-to-Car'!I28,Summary!$I$28:$J$32,2,0)*$S35","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('AEB Car-to-Car'!J28,Summary!$I$28:$J$32,2,0)*$S35","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('AEB Car-to-Car'!K28,Summary!$I$28:$J$32,2,0)*$S35","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('AEB Car-to-Car'!L28,Summary!$I$28:$J$32,2,0)*$S35","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('AEB Car-to-Car'!M28,Summary!$I$28:$J$32,2,0)*$S35","v":{"$error":"#N/A"}}]
["DRW_Approaching a stationary car - right overlap",{"$f":"IF(B$22=\"N/A$\",\"Grey\",W41)","v":"Grey"},"Green - Yellow - Orange - Brown - Red",null,null,null,null,null,null,null,null,1,{"$f":"VLOOKUP('AEB Car-to-Car'!D25,Summary!$I$28:$J$32,2,0)*$L36","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('AEB Car-to-Car'!E25,Summary!$I$28:$J$32,2,0)*$L36","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('AEB Car-to-Car'!F25,Summary!$I$28:$J$32,2,0)*$L36","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('AEB Car-to-Car'!G25,Summary!$I$28:$J$32,2,0)*$L36","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('AEB Car-to-Car'!H25,Summary!$I$28:$J$32,2,0)*$L36","v":{"$error":"#N/A"}},null,1,{"$f":"VLOOKUP('AEB Car-to-Car'!I29,Summary!$I$28:$J$32,2,0)*$S36","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('AEB Car-to-Car'!J29,Summary!$I$28:$J$32,2,0)*$S36","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('AEB Car-to-Car'!K29,Summary!$I$28:$J$32,2,0)*$S36","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('AEB Car-to-Car'!L29,Summary!$I$28:$J$32,2,0)*$S36","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('AEB Car-to-Car'!M29,Summary!$I$28:$J$32,2,0)*$S36","v":{"$error":"#N/A"}}]
["DRW_Approaching a stationary car - no overlap",{"$f":"IF(B$22=\"N/A$\",\"Grey\",V41)","v":"Grey"},"Green - Yellow - Orange - Brown - Red",null,null,null,null,null,null,null,null,1,{"$f":"VLOOKUP('AEB Car-to-Car'!D26,Summary!$I$28:$J$32,2,0)*$L37","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('AEB Car-to-Car'!E26,Summary!$I$28:$J$32,2,0)*$L37","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('AEB Car-to-Car'!F26,Summary!$I$28:$J$32,2,0)*$L37","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('AEB Car-to-Car'!G26,Summary!$I$28:$J$32,2,0)*$L37","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('AEB Car-to-Car'!H26,Summary!$I$28:$J$32,2,0)*$L37","v":{"$error":"#N/A"}},null,1,{"$f":"VLOOKUP('AEB Car-to-Car'!I30,Summary!$I$28:$J$32,2,0)*$S37","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('AEB Car-to-Car'!J30,Summary!$I$28:$J$32,2,0)*$S37","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('AEB Car-to-Car'!K30,Summary!$I$28:$J$32,2,0)*$S37","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('AEB Car-to-Car'!L30,Summary!$I$28:$J$32,2,0)*$S37","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('AEB Car-to-Car'!M30,Summary!$I$28:$J$32,2,0)*$S37","v":{"$error":"#N/A"}}]
["DRW_Approaching a stationary car - left overlap",{"$f":"IF(B$22=\"N/A$\",\"Grey\",T41)","v":"Grey"},"Green - Yellow - Orange - Brown - Red",null,null,null,null,null,null,null,null,null,{"$f":"SUM(M29:N37)/(2*SUM($L$29:$L$37))","v":{"$error":"#N/A"}},null,{"$f":"SUM(O29:O37)/(SUM($L$29:$L$37))","v":{"$error":"#N/A"}},{"$f":"SUM(P29:Q37)/(2*SUM($L$29:$L$37))","v":{"$error":"#N/A"}},null,null,1,{"$f":"VLOOKUP('AEB Car-to-Car'!I31,Summary!$I$28:$J$32,2,0)*$S38","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('AEB Car-to-Car'!J31,Summary!$I$28:$J$32,2,0)*$S38","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('AEB Car-to-Car'!K31,Summary!$I$28:$J$32,2,0)*$S38","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('AEB Car-to-Car'!L31,Summary!$I$28:$J$32,2,0)*$S38","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('AEB Car-to-Car'!M31,Summary!$I$28:$J$32,2,0)*$S38","v":{"$error":"#N/A"}}]
["DRW_Approaching a slower moving car - right overlap",{"$f":"IF(B$22=\"N/A$\",\"Grey\",W55)","v":"Grey"},"Green - Yellow - Orange - Brown - Red",null,null,null,null,null,null,null,null,null,{"$f":"IF(M38>=0.75,\"Green\",IF(M38>=0.5,\"Yellow\",IF(M38>=0.25,\"Orange\",IF(M38>0,\"Brown\",\"Red\"))))","v":{"$error":"#N/A"}},null,{"$f":"IF(O38>=0.75,\"Green\",IF(O38>=0.5,\"Yellow\",IF(O38>=0.25,\"Orange\",IF(O38>0,\"Brown\",\"Red\"))))","v":{"$error":"#N/A"}},{"$f":"IF(P38>=0.75,\"Green\",IF(P38>=0.5,\"Yellow\",IF(P38>=0.25,\"Orange\",IF(P38>0,\"Brown\",\"Red\"))))","v":{"$error":"#N/A"}},null,null,1,{"$f":"VLOOKUP('AEB Car-to-Car'!I32,Summary!$I$28:$J$32,2,0)*$S39","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('AEB Car-to-Car'!J32,Summary!$I$28:$J$32,2,0)*$S39","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('AEB Car-to-Car'!K32,Summary!$I$28:$J$32,2,0)*$S39","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('AEB Car-to-Car'!L32,Summary!$I$28:$J$32,2,0)*$S39","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('AEB Car-to-Car'!M32,Summary!$I$28:$J$32,2,0)*$S39","v":{"$error":"#N/A"}}]
["DRW_Approaching a slower moving car - no overlap",{"$f":"IF(B$22=\"N/A$\",\"Grey\",V55)","v":"Grey"},"Green - Yellow - Orange - Brown - Red",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(T29:U39)/(2*SUM($S$29:$S$39))","v":{"$error":"#N/A"}},null,{"$f":"SUM(V29:V39)/(SUM($S$29:$S$39))","v":{"$error":"#N/A"}},{"$f":"SUM(W29:X39)/(2*SUM($S$29:$S$39))","v":{"$error":"#N/A"}}]
["DRW_Approaching a slower moving car - left overlap",{"$f":"IF(B$22=\"N/A$\",\"Grey\",T55)","v":"Grey"},"Green - Yellow - Orange - Brown - Red",null,null,null,null,null,null,null,null,"CCRm",null,null,null,null,null,null,null,{"$f":"IF(T40>=0.75,\"Green\",IF(T40>=0.5,\"Yellow\",IF(T40>=0.25,\"Orange\",IF(T40>0,\"Brown\",\"Red\"))))","v":{"$error":"#N/A"}},null,{"$f":"IF(V40>=0.75,\"Green\",IF(V40>=0.5,\"Yellow\",IF(V40>=0.25,\"Orange\",IF(V40>0,\"Brown\",\"Red\"))))","v":{"$error":"#N/A"}},{"$f":"IF(W40>=0.75,\"Green\",IF(W40>=0.5,\"Yellow\",IF(W40>=0.25,\"Orange\",IF(W40>0,\"Brown\",\"Red\"))))","v":{"$error":"#N/A"}}]
["DRW_Approaching a braking car",{"$f":"IF(B41=\"#N/A\",\"N/A#\",IF(B$22=\"N/A$\",\"Grey\",IF('AEB Car-to-Car'!I57>=0.75,\"Green\",IF('AEB Car-to-Car'!I57>=0.5,\"Yellow\",IF('AEB Car-to-Car'!I57>=0.25,\"Orange\",IF('AEB Car-to-Car'!I57>0,\"Brown\",\"Red\"))))))","v":"Grey"},"Green - Yellow - Orange - Brown - Red",null,null,null,null,null,null,null,null,"AEB",null,null,null,null,null,null,"FCW"]
["AEB Pedestrian - score",{"$f":"IF(B17=\"n/a\",\"N/A$\",'OVERALL RATING'!G7)","v":"N/A$"},"number - 1 decimal",null,null,null,null,null,null,null,null,1,{"$f":"VLOOKUP('AEB Car-to-Car'!D36,Summary!$I$28:$J$32,2,0)*$L43","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('AEB Car-to-Car'!E36,Summary!$I$28:$J$32,2,0)*$L43","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('AEB Car-to-Car'!F36,Summary!$I$28:$J$32,2,0)*$L43","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('AEB Car-to-Car'!G36,Summary!$I$28:$J$32,2,0)*$L43","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('AEB Car-to-Car'!H36,Summary!$I$28:$J$32,2,0)*$L43","v":{"$error":"#N/A"}}]
["AEB Pedestrian - colour",{"$f":"IF(B17=\"N/A\",\"Grey\",IF(B43/10>=0.75,\"Green\",IF(B43/10>=0.5,\"Yellow\",IF(B43/10>=0.25,\"Orange\",IF(B43/10>0,\"Brown\",\"Red\")))))","v":"Grey"},"Green - Yellow - Orange - Brown - Red",null,null,null,null,null,null,null,null,1,{"$f":"VLOOKUP('AEB Car-to-Car'!D37,Summary!$I$28:$J$32,2,0)*$L44","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('AEB Car-to-Car'!E37,Summary!$I$28:$J$32,2,0)*$L44","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('AEB Car-to-Car'!F37,Summary!$I$28:$J$32,2,0)*$L44","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('AEB Car-to-Car'!G37,Summary!$I$28:$J$32,2,0)*$L44","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('AEB Car-to-Car'!H37,Summary!$I$28:$J$32,2,0)*$L44","v":{"$error":"#N/A"}}]
["Adult crossing the road",{"$f":"IF(B$43=\"N/A$\",\"Grey\",IF(AVERAGE('AEB Pedestrian'!D90:E92)>=0.75,\"Green\",IF(AVERAGE('AEB Pedestrian'!D90:E92)>=0.5,\"Yellow\",IF(AVERAGE('AEB Pedestrian'!D90:E92)>=0.25,\"Orange\",IF(AVERAGE('AEB Pedestrian'!D90:E92)>0,\"Brown\",\"Red\")))))","v":"Grey"},"Green - Yellow - Orange - Brown - Red",null,null,null,null,null,null,null,null,1,{"$f":"VLOOKUP('AEB Car-to-Car'!D38,Summary!$I$28:$J$32,2,0)*$L45","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('AEB Car-to-Car'!E38,Summary!$I$28:$J$32,2,0)*$L45","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('AEB Car-to-Car'!F38,Summary!$I$28:$J$32,2,0)*$L45","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('AEB Car-to-Car'!G38,Summary!$I$28:$J$32,2,0)*$L45","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('AEB Car-to-Car'!H38,Summary!$I$28:$J$32,2,0)*$L45","v":{"$error":"#N/A"}}]
["Child running from behind parked vehicles",{"$f":"IF(B$43=\"N/A$\",\"Grey\",IF('AEB Pedestrian'!D93>=0.75,\"Green\",IF('AEB Pedestrian'!D93>=0.5,\"Yellow\",IF('AEB Pedestrian'!D93>=0.25,\"Orange\",IF('AEB Pedestrian'!D93>0,\"Brown\",\"Red\")))))","v":"Grey"},"Green - Yellow - Orange - Brown - Red",null,null,null,null,null,null,null,null,1,{"$f":"VLOOKUP('AEB Car-to-Car'!D39,Summary!$I$28:$J$32,2,0)*$L46","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('AEB Car-to-Car'!E39,Summary!$I$28:$J$32,2,0)*$L46","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('AEB Car-to-Car'!F39,Summary!$I$28:$J$32,2,0)*$L46","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('AEB Car-to-Car'!G39,Summary!$I$28:$J$32,2,0)*$L46","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('AEB Car-to-Car'!H39,Summary!$I$28:$J$32,2,0)*$L46","v":{"$error":"#N/A"}}]
["Adult along the roadside",{"$f":"IF(B$43=\"N/A$\",\"Grey\",IF('AEB Pedestrian'!D94>=0.75,\"Green\",IF('AEB Pedestrian'!D94>=0.5,\"Yellow\",IF('AEB Pedestrian'!D94>=0.25,\"Orange\",IF('AEB Pedestrian'!D94>0,\"Brown\",\"Red\")))))","v":"Grey"},"Green - Yellow - Orange - Brown - Red",null,null,null,null,null,null,null,null,1,{"$f":"VLOOKUP('AEB Car-to-Car'!D40,Summary!$I$28:$J$32,2,0)*$L47","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('AEB Car-to-Car'!E40,Summary!$I$28:$J$32,2,0)*$L47","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('AEB Car-to-Car'!F40,Summary!$I$28:$J$32,2,0)*$L47","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('AEB Car-to-Car'!G40,Summary!$I$28:$J$32,2,0)*$L47","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('AEB Car-to-Car'!H40,Summary!$I$28:$J$32,2,0)*$L47","v":{"$error":"#N/A"}},null,1,{"$f":"VLOOKUP('AEB Car-to-Car'!I40,Summary!$I$28:$J$32,2,0)*$S47","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('AEB Car-to-Car'!J40,Summary!$I$28:$J$32,2,0)*$S47","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('AEB Car-to-Car'!K40,Summary!$I$28:$J$32,2,0)*$S47","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('AEB Car-to-Car'!L40,Summary!$I$28:$J$32,2,0)*$S47","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('AEB Car-to-Car'!M40,Summary!$I$28:$J$32,2,0)*$S47","v":{"$error":"#N/A"}}]
["AEB Cyclist - score",{"$f":"IF(B18=\"n/a\",\"N/A$\",'OVERALL RATING'!G8)","v":"N/A$"},"number - 1 decimal",null,null,null,null,null,null,null,null,1,{"$f":"VLOOKUP('AEB Car-to-Car'!D41,Summary!$I$28:$J$32,2,0)*$L48","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('AEB Car-to-Car'!E41,Summary!$I$28:$J$32,2,0)*$L48","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('AEB Car-to-Car'!F41,Summary!$I$28:$J$32,2,0)*$L48","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('AEB Car-to-Car'!G41,Summary!$I$28:$J$32,2,0)*$L48","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('AEB Car-to-Car'!H41,Summary!$I$28:$J$32,2,0)*$L48","v":{"$error":"#N/A"}},null,1,{"$f":"VLOOKUP('AEB Car-to-Car'!I41,Summary!$I$28:$J$32,2,0)*$S48","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('AEB Car-to-Car'!J41,Summary!$I$28:$J$32,2,0)*$S48","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('AEB Car-to-Car'!K41,Summary!$I$28:$J$32,2,0)*$S48","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('AEB Car-to-Car'!L41,Summary!$I$28:$J$32,2,0)*$S48","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('AEB Car-to-Car'!M41,Summary!$I$28:$J$32,2,0)*$S48","v":{"$error":"#N/A"}}]
["AEB Cyclist - colour",{"$f":"IF(B18=\"N/A\",\"Grey\",IF(B48/10>=0.75,\"Green\",IF(B48/10>=0.5,\"Yellow\",IF(B48/10>=0.25,\"Orange\",IF(B48/10>0,\"Brown\",\"Red\")))))","v":"Grey"},"Green - Yellow - Orange - Brown - Red",null,null,null,null,null,null,null,null,1,{"$f":"VLOOKUP('AEB Car-to-Car'!D42,Summary!$I$28:$J$32,2,0)*$L49","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('AEB Car-to-Car'!E42,Summary!$I$28:$J$32,2,0)*$L49","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('AEB Car-to-Car'!F42,Summary!$I$28:$J$32,2,0)*$L49","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('AEB Car-to-Car'!G42,Summary!$I$28:$J$32,2,0)*$L49","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('AEB Car-to-Car'!H42,Summary!$I$28:$J$32,2,0)*$L49","v":{"$error":"#N/A"}},null,1,{"$f":"VLOOKUP('AEB Car-to-Car'!I42,Summary!$I$28:$J$32,2,0)*$S49","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('AEB Car-to-Car'!J42,Summary!$I$28:$J$32,2,0)*$S49","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('AEB Car-to-Car'!K42,Summary!$I$28:$J$32,2,0)*$S49","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('AEB Car-to-Car'!L42,Summary!$I$28:$J$32,2,0)*$S49","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('AEB Car-to-Car'!M42,Summary!$I$28:$J$32,2,0)*$S49","v":{"$error":"#N/A"}}]
["Cyclist crossing",{"$f":"IF(B$48=\"N/A$\",\"Grey\",IF(AND(IF('AEB Cyclist'!D51>=0.75,\"Green\",IF('AEB Cyclist'!D51>=0.5,\"Yellow\",IF('AEB Cyclist'!D51>=0.25,\"Orange\",IF('AEB Cyclist'!D51>0,\"Brown\",\"Red\"))))=\"Red\",B48=\"N/A\"),\"Grey\",IF('AEB Cyclist'!D51>=0.75,\"Green\",IF('AEB Cyclist'!D51>=0.5,\"Yellow\",IF('AEB Cyclist'!D51>=0.25,\"Orange\",IF('AEB Cyclist'!D51>0,\"Brown\",\"Red\"))))))","v":"Grey"},"Green - Yellow - Orange - Brown - Red",null,null,null,null,null,null,null,null,2,{"$f":"VLOOKUP('AEB Car-to-Car'!D43,Summary!$I$28:$J$32,2,0)*$L50","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('AEB Car-to-Car'!E43,Summary!$I$28:$J$32,2,0)*$L50","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('AEB Car-to-Car'!F43,Summary!$I$28:$J$32,2,0)*$L50","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('AEB Car-to-Car'!G43,Summary!$I$28:$J$32,2,0)*$L50","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('AEB Car-to-Car'!H43,Summary!$I$28:$J$32,2,0)*$L50","v":{"$error":"#N/A"}},null,2,{"$f":"VLOOKUP('AEB Car-to-Car'!I43,Summary!$I$28:$J$32,2,0)*$S50","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('AEB Car-to-Car'!J43,Summary!$I$28:$J$32,2,0)*$S50","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('AEB Car-to-Car'!K43,Summary!$I$28:$J$32,2,0)*$S50","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('AEB Car-to-Car'!L43,Summary!$I$28:$J$32,2,0)*$S50","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('AEB Car-to-Car'!M43,Summary!$I$28:$J$32,2,0)*$S50","v":{"$error":"#N/A"}}]
["Cyclist along the roadside",{"$f":"IF(B$48=\"N/A$\",\"Grey\",IF(AND(IF('AEB Cyclist'!D52>=0.75,\"Green\",IF('AEB Cyclist'!D52>=0.5,\"Yellow\",IF('AEB Cyclist'!D52>=0.25,\"Orange\",IF('AEB Cyclist'!D52>0,\"Brown\",\"Red\"))))=\"Red\",B48=\"N/A\"),\"Grey\",IF('AEB Cyclist'!D52>=0.75,\"Green\",IF('AEB Cyclist'!D52>=0.5,\"Yellow\",IF('AEB Cyclist'!D52>=0.25,\"Orange\",IF('AEB Cyclist'!D52>0,\"Brown\",\"Red\"))))))","v":"Grey"},"Green - Yellow - Orange - Brown - Red",null,null,null,null,null,null,null,null,2,{"$f":"VLOOKUP('AEB Car-to-Car'!D44,Summary!$I$28:$J$32,2,0)*$L51","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('AEB Car-to-Car'!E44,Summary!$I$28:$J$32,2,0)*$L51","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('AEB Car-to-Car'!F44,Summary!$I$28:$J$32,2,0)*$L51","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('AEB Car-to-Car'!G44,Summary!$I$28:$J$32,2,0)*$L51","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('AEB Car-to-Car'!H44,Summary!$I$28:$J$32,2,0)*$L51","v":{"$error":"#N/A"}},null,2,{"$f":"VLOOKUP('AEB Car-to-Car'!I44,Summary!$I$28:$J$32,2,0)*$S51","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('AEB Car-to-Car'!J44,Summary!$I$28:$J$32,2,0)*$S51","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('AEB Car-to-Car'!K44,Summary!$I$28:$J$32,2,0)*$S51","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('AEB Car-to-Car'!L44,Summary!$I$28:$J$32,2,0)*$S51","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('AEB Car-to-Car'!M44,Summary!$I$28:$J$32,2,0)*$S51","v":{"$error":"#N/A"}}]
["Speed assistance - score",{"$f":"IF(B165=\"N/A\",\"N/A$\",'OVERALL RATING'!G10)","v":"N/A$"},"number - 1 decimal",null,null,null,null,null,null,null,null,2,{"$f":"VLOOKUP('AEB Car-to-Car'!D45,Summary!$I$28:$J$32,2,0)*$L52","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('AEB Car-to-Car'!E45,Summary!$I$28:$J$32,2,0)*$L52","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('AEB Car-to-Car'!F45,Summary!$I$28:$J$32,2,0)*$L52","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('AEB Car-to-Car'!G45,Summary!$I$28:$J$32,2,0)*$L52","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('AEB Car-to-Car'!H45,Summary!$I$28:$J$32,2,0)*$L52","v":{"$error":"#N/A"}},null,2,{"$f":"VLOOKUP('AEB Car-to-Car'!I45,Summary!$I$28:$J$32,2,0)*$S52","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('AEB Car-to-Car'!J45,Summary!$I$28:$J$32,2,0)*$S52","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('AEB Car-to-Car'!K45,Summary!$I$28:$J$32,2,0)*$S52","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('AEB Car-to-Car'!L45,Summary!$I$28:$J$32,2,0)*$S52","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('AEB Car-to-Car'!M45,Summary!$I$28:$J$32,2,0)*$S52","v":{"$error":"#N/A"}}]
["Speed assistance - colour",{"$f":"IF(B52=\"N/A$\",\"Grey\",IF(B52/15>=0.75,\"Green\",IF(B52/15>=0.5,\"Yellow\",IF(B52/15>=0.25,\"Orange\",IF(B52/15>0,\"Brown\",\"Red\")))))","v":"Grey"},"Green - Yellow - Orange - Brown - Red",null,null,null,null,null,null,null,null,2,{"$f":"VLOOKUP('AEB Car-to-Car'!D46,Summary!$I$28:$J$32,2,0)*$L53","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('AEB Car-to-Car'!E46,Summary!$I$28:$J$32,2,0)*$L53","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('AEB Car-to-Car'!F46,Summary!$I$28:$J$32,2,0)*$L53","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('AEB Car-to-Car'!G46,Summary!$I$28:$J$32,2,0)*$L53","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('AEB Car-to-Car'!H46,Summary!$I$28:$J$32,2,0)*$L53","v":{"$error":"#N/A"}},null,2,{"$f":"VLOOKUP('AEB Car-to-Car'!I46,Summary!$I$28:$J$32,2,0)*$S53","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('AEB Car-to-Car'!J46,Summary!$I$28:$J$32,2,0)*$S53","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('AEB Car-to-Car'!K46,Summary!$I$28:$J$32,2,0)*$S53","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('AEB Car-to-Car'!L46,Summary!$I$28:$J$32,2,0)*$S53","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('AEB Car-to-Car'!M46,Summary!$I$28:$J$32,2,0)*$S53","v":{"$error":"#N/A"}}]
["SA_Speed limit information function",{"$f":"IF(SAS!D10=0,\" \",SAS!D10)","v":" "},"text",null,null,null,null,null,null,null,null,null,{"$f":"SUM(M43:N53)/(2*SUM($L$43:$L$53))","v":{"$error":"#N/A"}},null,{"$f":"SUM(O43:O53)/(SUM($L$43:$L$53))","v":{"$error":"#N/A"}},{"$f":"SUM(P43:Q53)/(2*SUM($L$43:$L$53))","v":{"$error":"#N/A"}},null,null,null,{"$f":"SUM(T43:U53)/(2*SUM($S$43:$S$53))","v":{"$error":"#N/A"}},null,{"$f":"SUM(V43:V53)/(SUM($S$43:$S$53))","v":{"$error":"#N/A"}},{"$f":"SUM(W43:X53)/(2*SUM($S$43:$S$53))","v":{"$error":"#N/A"}}]
["SA_Speed limitation function",{"$f":"IF(SAS!D31=0,\" \",SAS!D31)","v":" "},"text",null,null,null,null,null,null,null,null,null,{"$f":"IF(M54>=0.75,\"Green\",IF(M54>=0.5,\"Yellow\",IF(M54>=0.25,\"Orange\",IF(M54>0,\"Brown\",\"Red\"))))","v":{"$error":"#N/A"}},null,{"$f":"IF(O54>=0.75,\"Green\",IF(O54>=0.5,\"Yellow\",IF(O54>=0.25,\"Orange\",IF(O54>0,\"Brown\",\"Red\"))))","v":{"$error":"#N/A"}},{"$f":"IF(P54>=0.75,\"Green\",IF(P54>=0.5,\"Yellow\",IF(P54>=0.25,\"Orange\",IF(P54>0,\"Brown\",\"Red\"))))","v":{"$error":"#N/A"}},null,null,null,{"$f":"IF(T54>=0.75,\"Green\",IF(T54>=0.5,\"Yellow\",IF(T54>=0.25,\"Orange\",IF(T54>0,\"Brown\",\"Red\"))))","v":{"$error":"#N/A"}},null,{"$f":"IF(V54>=0.75,\"Green\",IF(V54>=0.5,\"Yellow\",IF(V54>=0.25,\"Orange\",IF(V54>0,\"Brown\",\"Red\"))))","v":{"$error":"#N/A"}},{"$f":"IF(W54>=0.75,\"Green\",IF(W54>=0.5,\"Yellow\",IF(W54>=0.25,\"Orange\",IF(W54>0,\"Brown\",\"Red\"))))","v":{"$error":"#N/A"}}]
["OSM - score",{"$f":"IF(FITMENT!G47=\"N/A\",\"N/A$\",'OVERALL RATING'!G11)","v":"N/A$"},"number - 1 decimal"]
["OSM - colour",{"$f":"IF(B56=\"N/A$\",\"Grey\",IF(B56/15>=0.75,\"Green\",IF(B56/15>=0.5,\"Yellow\",IF(B56/15>=0.25,\"Orange\",IF(B56/15>0,\"Brown\",\"Red\")))))","v":"Grey"},"Green - Yellow - Orange - Brown - Red"]
["OSM_Attention Assist Driver",{"$f":"IF(FITMENT!F47=\"N/A\",\"N/A\",IF(OSM!D14>0,\"Pass\",\"Fail\"))","v":"N/A"},"pass/fail/not available"]
["OSM_Applies to","???","text"]
["OSM_Driver seat - visual",{"$f":"OSM!D7","v":0},"pass/fail/not available"]
["OSM_Driver seat - audible",{"$f":"OSM!D8","v":0},"pass/fail/not available"]
["OSM_Driver seat - occupant detection","DELETE, not needed","pass/fail/not available"]
["OSM_Front Passenger - visual",{"$f":"OSM!F7","v":0},"pass/fail/not available"]
["OSM_Front Passenger - audible",{"$f":"OSM!F8","v":0},"pass/fail/not available"]
["OSM_Front Passenger - occupant detection",{"$f":"OSM!F6","v":0},"pass/fail/not available"]
["Lane Support - score",{"$f":"IF(B164=\"N/A\",\"N/A$\",'OVERALL RATING'!G9)","v":"N/A$"},"number - 1 decimal"]
["Lane Support - colour",{"$f":"IF(B66=\"N/A$\",\"Grey\",IF(B66/20>=0.75,\"Green\",IF(B66/20>=0.5,\"Yellow\",IF(B66/20>=0.25,\"Orange\",IF(B66/20>0,\"Brown\",\"Red\")))))","v":"Grey"},"Green - Yellow - Orange - Brown - Red"]
["LSS_Type",{"$f":"CONCATENATE(IF(FITMENT!D25<>\"N/A\",\"ELK/LKA\",\"\"),IF(AND(FITMENT!D25<>\"N/A\",FITMENT!E25<>\"N/A\",FITMENT!F25=\"N/A\"),\" & \",\"\"),IF(AND(FITMENT!D25<>\"N/A\",FITMENT!E25<>\"N/A\",FITMENT!F25<>\"N/A\"),\", \",\"\"),IF(FITMENT!E25<>\"N/A\",\"LDW\",\"\"),IF(AND(FITMENT!F25<>\"N/A\",FITMENT!F25<>\"N/A\"),\" & \",\"\"),IF(FITMENT!F25<>\"N/A\",\"BLIS\",\"\"))","v":""},"text"]
["LSS_Operational from",{"$f":"LSS!D8","v":0},"text"]
["LSS_Emergency lane keeping",{"$f":"IF(FITMENT!D25=\"N/A\",\"White\",IF((LSS!D86+LSS!D87)/3.5>=0.75,\"Green\",IF((LSS!D86+LSS!D87)/3.5>=0.5,\"Yellow\",IF((LSS!D86+LSS!D87)/3.5>=0.25,\"Orange\",IF((LSS!D86+LSS!D87)/3.5>0,\"Brown\",\"Red\")))))","v":"White"},"Green - Yellow - Orange - Brown - Red"]
["LSS_Lane Keep Assist","LKA is combined with ELK, remove this line","standard/optional/not available"]
["LSS_Lane Departure Warning",{"$f":"IF(FITMENT!E25=\"N/A\",\"N/A\",LSS!D78)","v":"N/A"},"pass/fail/not available"]
["LSS_Blind Spot Information System",{"$f":"IF(FITMENT!F25=\"N/A\",\"N/A\",LSS!D82)","v":"N/A"},"pass/fail/not available"]
["Fitment"]
["AEB Car-to-Car_FR",{"$f":"FITMENT!D6","v":0},"standard/optional/not available"]
["AEB Car-to-Car_DE",{"$f":"FITMENT!D7","v":0},"standard/optional/not available"]
["AEB Car-to-Car_IT",{"$f":"FITMENT!D8","v":0},"standard/optional/not available"]
["AEB Car-to-Car_LU",{"$f":"FITMENT!D9","v":0},"standard/optional/not available"]
["AEB Car-to-Car_ES",{"$f":"FITMENT!D10","v":0},"standard/optional/not available"]
["AEB Car-to-Car_SV",{"$f":"FITMENT!D11","v":0},"standard/optional/not available"]
["AEB Car-to-Car_NL",{"$f":"FITMENT!D12","v":0},"standard/optional/not available"]
["AEB Car-to-Car_UK",{"$f":"FITMENT!D13","v":0},"standard/optional/not available"]
["AEB Pedestrian_FR",{"$f":"FITMENT!E6","v":0},"standard/optional/not available"]
["AEB Pedestrian_DE",{"$f":"FITMENT!E7","v":0},"standard/optional/not available"]
["AEB Pedestrian_IT",{"$f":"FITMENT!E8","v":0},"standard/optional/not available"]
["AEB Pedestrian_LU",{"$f":"FITMENT!E9","v":0},"standard/optional/not available"]
["AEB Pedestrian_ES",{"$f":"FITMENT!E10","v":0},"standard/optional/not available"]
["AEB Pedestrian_SV",{"$f":"FITMENT!E11","v":0},"standard/optional/not available"]
["AEB Pedestrian_NL",{"$f":"FITMENT!E12","v":0},"standard/optional/not available"]
["AEB Pedestrian_UK",{"$f":"FITMENT!E13","v":0},"standard/optional/not available"]
["AEB Cyclist_FR",{"$f":"FITMENT!F6","v":0},"standard/optional/not available"]
["AEB Cyclist_DE",{"$f":"FITMENT!F7","v":0},"standard/optional/not available"]
["AEB Cyclist_IT",{"$f":"FITMENT!F8","v":0},"standard/optional/not available"]
["AEB Cyclist_LU",{"$f":"FITMENT!F9","v":0},"standard/optional/not available"]
["AEB Cyclist_ES",{"$f":"FITMENT!F10","v":0},"standard/optional/not available"]
["AEB Cyclist_SV",{"$f":"FITMENT!F11","v":0},"standard/optional/not available"]
["AEB Cyclist_NL",{"$f":"FITMENT!F12","v":0},"standard/optional/not available"]
["AEB Cyclist_UK",{"$f":"FITMENT!F13","v":0},"standard/optional/not available"]
["LSS_ELK/LKA_FR",{"$f":"FITMENT!D17","v":0},"standard/optional/not available"]
["LSS_ELK/LKA_DE",{"$f":"FITMENT!D18","v":0},"standard/optional/not available"]
["LSS_ELK/LKA_IT",{"$f":"FITMENT!D19","v":0},"standard/optional/not available"]
["LSS_ELK/LKA_LU",{"$f":"FITMENT!D20","v":0},"standard/optional/not available"]
["LSS_ELK/LKA_ES",{"$f":"FITMENT!D21","v":0},"standard/optional/not available"]
["LSS_ELK/LKA_SV",{"$f":"FITMENT!D22","v":0},"standard/optional/not available"]
["LSS_ELK/LKA_NL",{"$f":"FITMENT!D23","v":0},"standard/optional/not available"]
["LSS_ELK/LKA_UK",{"$f":"FITMENT!D24","v":0},"standard/optional/not available"]
["LSS_LDW_FR",{"$f":"FITMENT!E17","v":0},"standard/optional/not available"]
["LSS_LDW_DE",{"$f":"FITMENT!E18","v":0},"standard/optional/not available"]
["LSS_LDW_IT",{"$f":"FITMENT!E19","v":0},"standard/optional/not available"]
["LSS_LDW_LU",{"$f":"FITMENT!E20","v":0},"standard/optional/not available"]
["LSS_LDW_ES",{"$f":"FITMENT!E21","v":0},"standard/optional/not available"]
["LSS_LDW_SV",{"$f":"FITMENT!E22","v":0},"standard/optional/not available"]
["LSS_LDW_NL",{"$f":"FITMENT!E23","v":0},"standard/optional/not available"]
["LSS_LDW_UK",{"$f":"FITMENT!E24","v":0},"standard/optional/not available"]
["LSS_BLIS_FR",{"$f":"FITMENT!F17","v":0},"standard/optional/not available"]
["LSS_BLIS_DE",{"$f":"FITMENT!F18","v":0},"standard/optional/not available"]
["LSS_BLIS_IT",{"$f":"FITMENT!F19","v":0},"standard/optional/not available"]
["LSS_BLIS_LU",{"$f":"FITMENT!F20","v":0},"standard/optional/not available"]
["LSS_BLIS_ES",{"$f":"FITMENT!F21","v":0},"standard/optional/not available"]
["LSS_BLIS_SV",{"$f":"FITMENT!F22","v":0},"standard/optional/not available"]
["LSS_BLIS_NL",{"$f":"FITMENT!F23","v":0},"standard/optional/not available"]
["LSS_BLIS_UK",{"$f":"FITMENT!F24","v":0},"standard/optional/not available"]
["SA_SLIF_FR",{"$f":"FITMENT!D$28","v":0},"standard/optional/not available"]
["SA_SLIF_DE",{"$f":"FITMENT!D29","v":0},"standard/optional/not available"]
["SA_SLIF_IT",{"$f":"FITMENT!D30","v":0},"standard/optional/not available"]
["SA_SLIF_LU",{"$f":"FITMENT!D31","v":0},"standard/optional/not available"]
["SA_SLIF_ES",{"$f":"FITMENT!D32","v":0},"standard/optional/not available"]
["SA_SLIF_SV",{"$f":"FITMENT!D33","v":0},"standard/optional/not available"]
["SA_SLIF_NL",{"$f":"FITMENT!D34","v":0},"standard/optional/not available"]
["SA_SLIF_UK",{"$f":"FITMENT!D35","v":0},"standard/optional/not available"]
["SA_SCF_FR",{"$f":"FITMENT!E28","v":0},"standard/optional/not available"]
["SA_SCF_DE",{"$f":"FITMENT!E29","v":0},"standard/optional/not available"]
["SA_SCF_IT",{"$f":"FITMENT!E30","v":0},"standard/optional/not available"]
["SA_SCF_LU",{"$f":"FITMENT!E31","v":0},"standard/optional/not available"]
["SA_SCF_ES",{"$f":"FITMENT!E32","v":0},"standard/optional/not available"]
["SA_SCF_SV",{"$f":"FITMENT!E33","v":0},"standard/optional/not available"]
["SA_SCF_NL",{"$f":"FITMENT!E34","v":0},"standard/optional/not available"]
["SA_SCF_UK",{"$f":"FITMENT!E35","v":0},"standard/optional/not available"]
["OSM_SBR Driver_FR",{"$f":"FITMENT!D39","v":0},"standard/optional/not available"]
["OSM_SBR Driver_DE",{"$f":"FITMENT!D40","v":0},"standard/optional/not available"]
["OSM_SBR Driver_IT",{"$f":"FITMENT!D41","v":0},"standard/optional/not available"]
["OSM_SBR Driver_LU",{"$f":"FITMENT!D42","v":0},"standard/optional/not available"]
["OSM_SBR Driver_ES",{"$f":"FITMENT!D43","v":0},"standard/optional/not available"]
["OSM_SBR Driver_SV",{"$f":"FITMENT!D44","v":0},"standard/optional/not available"]
["OSM_SBR Driver_NL",{"$f":"FITMENT!D45","v":0},"standard/optional/not available"]
["OSM_SBR Driver_UK",{"$f":"FITMENT!D46","v":0},"standard/optional/not available"]
["OSM_SBR Passenger_FR",{"$f":"FITMENT!E39","v":0},"standard/optional/not available"]
["OSM_SBR Passenger_DE",{"$f":"FITMENT!E40","v":0},"standard/optional/not available"]
["OSM_SBR Passenger_IT",{"$f":"FITMENT!E41","v":0},"standard/optional/not available"]
["OSM_SBR Passenger_LU",{"$f":"FITMENT!E42","v":0},"standard/optional/not available"]
["OSM_SBR Passenger_ES",{"$f":"FITMENT!E43","v":0},"standard/optional/not available"]
["OSM_SBR Passenger_SV",{"$f":"FITMENT!E44","v":0},"standard/optional/not available"]
["OSM_SBR Passenger_NL",{"$f":"FITMENT!E45","v":0},"standard/optional/not available"]
["OSM_SBR Passenger_UK",{"$f":"FITMENT!E46","v":0},"standard/optional/not available"]
["OSM_Attention Assist_FR",{"$f":"FITMENT!F39","v":0},"standard/optional/not available"]
["OSM_Attention Assist_DE",{"$f":"FITMENT!F40","v":0},"standard/optional/not available"]
["OSM_Attention Assist_IT",{"$f":"FITMENT!F41","v":0},"standard/optional/not available"]
["OSM_Attention Assist_LU",{"$f":"FITMENT!F42","v":0},"standard/optional/not available"]
["OSM_Attention Assist_ES",{"$f":"FITMENT!F43","v":0},"standard/optional/not available"]
["OSM_Attention Assist_SV",{"$f":"FITMENT!F44","v":0},"standard/optional/not available"]
["OSM_Attention Assist_NL",{"$f":"FITMENT!F45","v":0},"standard/optional/not available"]
["OSM_Attention Assist_UK",{"$f":"FITMENT!F46","v":0},"standard/optional/not available"]
["Safety equipment continued"]
["LSS",{"$f":"FITMENT!G25","v":"N/A"},"standard/optional/not available"]
["SAS",{"$f":"FITMENT!G36","v":"N/A"},"standard/optional/not available"]
["Verdict",{"$f":"'OVERALL RATING'!B18","v":0},"text"]