{"text_format":"1","workbook":"xlsx","n_sheets":14,"sheets":["System Limitations","General Overview","AD GRADING","DE Consumer Information","DE System Status","DE Driver Monitoring","DE Driving Collaboration","VA Speed Assistance","VA ACC Performance","VA Steering Assistance","SB System Failure","SB Unresponsive Driver","SB Collision Avoidance","Website Summary"],"not_rendered":{"charts":0,"images":9,"macros":1,"external_links":0,"defined_names":1,"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":"System Limitations","index":0,"n_rows":58,"n_cols":7,"rows_kept":58,"cut":false,"hidden":false,"merged":[[27,2,37,2],[38,2,43,2],[44,2,45,2],[46,2,52,2],[53,2,57,2],[25,4,25,5],[25,6,26,6],[2,2,2,4],[3,2,6,2],[7,2,10,2],[19,2,21,2],[19,6,21,6]]}
[]
[null,"General Disclaimer for Assisted Driving Systems"]
[]
[null,null,"Driver responsibilities","Control of speed and braking","At all times"]
[null,null,null,"Control of steering","At all times"]
[null,null,null,"Compliance with traffic rules","At all times"]
[null,null,null,"Situational awareness","At all times"]
[null,null,"Driver state","Visual distraction (i.e., eyes off the road)","High risk "]
[null,null,null,"Impairment/fatigue (e.g., drowsy, intoxicated)","High risk "]
[null,null,null,"Unresponsiveness","High risk "]
[null,null,null,"Hands on/off wheel","Within ODD "]
[]
[null,"[MAKE] [MODEL] [SYSTEM NAME] "]
[]
[null,"Operational Design Domain (ODD)"]
[]
[null,null,"Speed Range","20 - 180 km/h"]
[]
[null,null,null,null,"Recommended","Not recommended","Remarks "]
[null,null,"Intended ODD","Highway"]
[null,null,null,"Inter-urban"]
[null,null,null,"Urban "]
[]
[]
[]
[null,"System performance",null,null,"System performance",null,"Remarks "]
[null,null,null,null,"Optimal","Constrained"]
[null,null,"Infrastructure conditions","Tunnels"]
[null,null,null,"Bridges"]
[null,null,null,"Merging scenarios (e.g., 4 lanes into 3)"]
[null,null,null,"Split scenarios (e.g., 3 lanes into 4)"]
[null,null,null,"Parking garages"]
[null,null,null,"Steep uphill/downhill"]
[null,null,null,"Tight curves"]
[null,null,null,"Winding roads"]
[null,null,null,"Slippery roads (e.g., black ice, aquaplaning, gravel)"]
[null,null,null,"Roadworks"]
[null,null,null,"Missing /Faded/Non-standard lane markings "]
[null,null,"Adverse Environmental Conditions","Heavy rain"]
[null,null,null,"Water spray from preceeding vehicle"]
[null,null,null,"Heavy fog"]
[null,null,null,"Snow"]
[null,null,null,"Glare (e.g., direct sunlight, high beams of oncoming vehicles, exiting a tunnel)"]
[null,null,null,"Side winds"]
[null,null,"Time of the day","Daytime"]
[null,null,null,"Nighttime"]
[null,null,"Detection of road users & objects","Stationary or slow moving vehicles"]
[null,null,null,"Odd shaped-vehicle (e.g., car-carrier trailer) near vehicle ahead"]
[null,null,null,"Oncoming vehicles"]
[null,null,null,"Crossing traffic"]
[null,null,null,"Motorcycles travelling offset"]
[null,null,null,"Biciclists, Pedestrians, Animals or Objects "]
[null,null,null,"Mobile Road Work vehicles"]
[null,null,"Vehicle condition","Windshield dirt/fog/damage/covered around camera area"]
[null,null,null,"Radar sensor dirty/covered"]
[null,null,null,"Interior camera covered"]
[null,null,null,"Towing a trailer"]
[null,null,null,"Heavy baggage on rear seat/cargo area"]

{"sheet":"General Overview","index":1,"n_rows":97,"n_cols":20,"rows_kept":97,"cut":false,"hidden":false,"merged":[[56,2,56,3],[24,2,24,3],[25,2,25,3],[26,2,26,3],[54,2,54,3],[13,2,13,4],[14,2,14,4],[18,2,18,4],[49,1,49,6],[27,2,27,3],[29,2,29,3],[30,2,30,3],[31,2,31,3],[37,2,37,3],[36,2,36,3],[33,1,33,3],[15,2,15,3],[35,2,35,3],[11,2,11,4],[12,2,12,4],[3,2,3,4],[4,2,4,4],[5,2,5,4],[6,2,6,4],[7,2,7,4],[9,2,9,4],[8,2,8,4],[10,2,10,4],[72,1,72,2],[72,3,72,4],[70,1,70,4],[71,1,71,4],[67,1,68,2],[67,3,67,6],[68,3,68,4],[69,1,69,2],[69,3,69,4],[73,1,73,2],[73,3,73,4],[74,1,74,2],[74,3,74,4],[75,3,75,4],[76,1,76,2],[76,3,76,4],[77,1,77,2],[77,3,77,4],[78,1,78,2],[78,3,78,4],[85,1,85,2],[85,3,85,4],[84,1,84,2],[84,3,84,4],[79,1,79,2],[79,3,79,4],[80,1,80,2],[80,3,80,4],[81,1,81,2],[81,3,81,4],[83,3,83,4],[97,1,97,2],[97,3,97,4],[93,1,93,2],[93,3,93,4],[94,1,94,2],[94,3,94,4],[95,1,95,2],[95,3,95,4],[89,1,89,2],[89,3,89,4],[91,1,91,2],[91,3,91,4],[92,1,92,2],[92,3,92,4],[86,1,86,2],[1,1,1,4],[96,1,96,2],[96,3,96,4],[16,2,16,3],[17,2,17,3],[86,3,86,4],[87,1,87,2],[87,3,87,4],[88,1,88,2],[88,3,88,4],[90,1,90,2],[90,3,90,4],[82,1,82,2],[82,3,82,4],[83,1,83,2]]}
[]
[3,"VEHICLE SPECIFICATION",null,null,null,"YEAR OF TEST",2024,null,null,null,null,null,null,null,null,null,null,null,null,"3 door hatchback"]
[null,null,null,null,null,null,"CAMPAIGN"]
[null,"Make",null,null,null,"Also available on:",null,null,null,null,null,null,null,null,null,null,null,null,null,"3 door wgon"]
[null,"Model",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"5 door wagon"]
[null,"Version tested"]
[null,"Kerb weight (kg)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"5 door SUV"]
[null,"Engine",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3 door SUV"]
[null,"Trim level",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"5 door MPV"]
[null,"Safety Pack"]
[null,"Body Type"]
[null,"Full description"]
[null,"Release Date"]
[null,"Hand of drive"]
[null,"Seat arrangement"]
[null,"front row",null,null,{"$f":"CONCATENATE(C16,C17,C18)","v":""}]
[null,"second row",null,null,"optional"]
[null,"third row",null,null,"optional"]
[null,"Vehicle class"]
[]
[null,"SAFETY EQUIPMENT"]
[]
[null,"ADULT OCCUPANT",null,null,"DRIVER","PASSENGER","REAR"]
[null,"FRONTAL"]
[null,null,"frontal airbag"]
[null,null,"belt pretensioner"]
[null,null,"belt loadlimiter"]
[null,null,"knee airbag"]
[null,"SIDE"]
[null,null,"side head airbag"]
[null,null,"side chest airbag"]
[null,null,"side pelvis airbag"]
[null,"FARSIDE"]
[null,"farside restraint system"]
[null,"RESCUE"]
[null,null,"Advanced eCall"]
[null,null,"MCB"]
[]
[null,"CHILD OCCUPANT",null,null,"DRIVER","PASSENGER","REAR"]
[null,"CHILD RESTRAINT SYSTEM"]
[null,null,"CRS used for testing"]
[null,null,null,"Q6"]
[null,null,null,"Q10"]
[null,"VEHICLE BASED"]
[null,null,"ISOFIX"]
[null,null,"i-Size"]
[null,null,"integrated CRS"]
[null,null,"airbag cut-off switch"]
[]
[null,"VULNERABLE ROAD USER"]
[null,"ACTIVE PEDESTRIAN SYSTEM"]
[null,null,"deployable bonnet"]
[null,null,"pedestrian airbag"]
[null,"AEB"]
[null,null,"AEB Pedestrian"]
[null,null,"AEB Cyclist"]
[null,null,"AEB Reverse"]
[]
[null,"SAFETY ASSIST",null,null,"DRIVER","PASSENGER","REAR"]
[null,"SAFETY ASSIST SYSTEMS"]
[null,null,"SBR",null,"Standard","Standard","Standard"]
[null,null,"Driver Monitoring"]
[null,null,"ESC",null,"Standard"]
[null,null,"AEB Car-to-Car"]
[null,null,"Speed Assist System"]
[null,null,"Lane Support System"]
[]
[null,"PROTOCOLS"]
[null,null,null,"Protocol",null,"Version","Application"]
[null,"GENERAL"]
[null,"VEHICLE SPECIFICATION, SPONSORSHIP, TESTING AND RETESTING PROTOCOL",null,null,null,"7.1",2018]
[null,"EURO NCAP ASSESSMENT PROTOCOL - OVERALL RATING",null,null,null,"7.0.1",2016]
[null,"ADULT OCCUPANT PROTECTION"]
[null,null,null,"EURO NCAP ASSESSMENT PROTOCOL - AOP",null,"8.0.2",2018]
[null,null,null,"FRONTAL ODB TEST PROTOCOL",null,"7.1.2",2018]
[null,null,null,"FRONTAL FULL WIDTH TEST PROTOCOL",null,"1.0.2",2018]
[null,null,null,"SIDE BARRIER IMPACT TEST PROTOCOL",null,"7.1.1",2018]
[null,null,null,"SIDE POLE IMPACT TEST PROTOCOL",null,"7.0.2",2018]
[null,null,null,"WHIPLASH TESTING PROTOCOL",null,"3.2",2015]
[null,null,null,"REAR WHIPLASH TEST PROTOCOL",null,"1.0",2014]
[null,null,null,"SLED TEST PROCEDURE",null,"2.7",2010]
[null,null,null,"AEB TEST PROCEDURE",null,"2.0.1",2018]
[]
[null,"CHILD OCCUPANT PROTECTION"]
[null,null,null,"EURO NCAP ASSESSMENT PROTOCOL - COP",null,"7.2.1",2018]
[null,null,null,"COP TEST PROTOCOL",null,"7.2.1",2018]
[]
[null,"PEDESTRIAN PROTECTION"]
[null,null,null,"EURO NCAP ASSESSMENT PROTOCOL - PP",null,"9.0.2",2018]
[null,null,null,"PEDESTRIAN TEST PROTOCOL",null,"8.4",2018]
[null,null,null,"AEB VRU TEST PROTOCOL",null,"2.0.2",2018]
[]
[null,"SAFETY ASSIST"]
[null,null,null,"EURO NCAP ASSESSMENT PROTOCOL - SA",null,"8.0.1",2018]
[null,null,null,"SAS TEST PROTOCOL",null,"2.0.1",2018]
[null,null,null,"AEB TEST PROTOCOL",null,"2.0",2018]
[null,null,null,"LSS TEST PROTOCOL",null,"2.0.1",2018]

{"sheet":"AD GRADING","index":2,"n_rows":18,"n_cols":10,"rows_kept":18,"cut":false,"hidden":false,"merged":[[6,4,6,5],[17,1,17,7],[5,2,5,5],[5,6,5,7],[14,2,14,7],[1,6,2,6],[1,7,2,9],[12,4,12,5],[13,6,13,7],[12,6,12,7],[4,6,4,7],[6,6,6,7],[13,2,13,5],[4,2,4,3],[4,4,4,5],[6,2,6,3],[12,2,12,3]]}
[]
[null,null,{"$f":"CONCATENATE('General Overview'!C4:E4,\" \",'General Overview'!C5)","v":" "},null,null,null,{"$f":"IF(C15>=160,\"VERY GOOD\",IF(C15>=140,\"GOOD\",IF(C15>=120,\"MODERATE\",IF(C15>=100,\"ENTRY\",\"NO GRADING\"))))","v":"NO GRADING"}]
[null,null,{"$f":"IF('DE Consumer Information'!D6=\"\",\"\",'DE Consumer Information'!D6)","v":""}]
[]
[null,null,"DRIVER ENGAGEMENT",null,"VEHICLE ASSISTANCE"]
[null,null,"ASSISTANCE COMPETENCE",null,null,null,"SAFETY BACKUP"]
[null,null,{"$f":"FLOOR(C13,1)/100","v":0},null,{"$f":"FLOOR(E13,1)/100","v":0},null,{"$f":"FLOOR(G13,1)/100","v":0}]
[null,null,"Consumer Information",{"$f":"'DE Consumer Information'!D35","v":0},"Speed Assistance",{"$f":"'VA Speed Assistance'!D81","v":0},"System Failure",{"$f":"'SB System Failure'!F32","v":0}]
[null,null,"System Status",{"$f":"'DE System Status'!D55","v":0},"ACC Performance",{"$f":"'VA ACC Performance'!F97","v":0},"Unresponsive Driver Intervention",{"$f":"'SB Unresponsive Driver'!D20","v":0}]
[null,null,"Driver Monitoring",{"$f":"'DE Driver Monitoring'!G50","v":0},"Steering Assistance",{"$f":"'VA Steering Assistance'!D23","v":0},"Collision Avoidance",{"$f":"'SB Collision Avoidance'!F140","v":0}]
[null,null,"Driver Collaboration",{"$f":"'DE Driving Collaboration'!D25","v":0}]
[]
[null,"BOX TOTAL",{"$f":"SUM(D8:D11)","v":0},null,{"$f":"SUM(F8:F12)","v":0},null,{"$f":"SUM(H8:H12)","v":0}]
[null,"SUBTOTAL",{"$f":"FLOOR(IF(E13<=C13,E13,C13),1)","v":0},null,null,null,{"$f":"FLOOR(G13,1)","v":0}]
[null,"TOTAL",{"$f":"FLOOR(C14+G14,1)","v":0},null,null,null,null,null,null,{"$f":"G14/100","v":0}]
[]
[]
[null,"Enter comments here"]

{"sheet":"DE Consumer Information","index":3,"n_rows":35,"n_cols":5,"rows_kept":35,"cut":false,"hidden":false,"merged":[[34,1,34,2],[34,3,34,4],[27,1,27,2],[28,3,28,4],[29,3,29,4],[30,3,30,4],[31,3,31,4],[32,1,32,2],[32,3,32,4],[27,3,27,4],[1,3,2,4],[5,3,5,4],[1,1,3,2],[20,3,20,4],[25,1,25,2],[25,3,25,4],[16,3,16,4],[9,1,9,2],[9,3,9,4],[11,3,11,4],[22,3,22,4],[4,3,4,4],[14,1,14,2],[14,3,14,4],[20,1,20,2]]}
[3]
[null,"Consumer Information"]
[]
[null,null,null,"Value","Points"]
[null,"SYSTEM NAME"]
[null,null,"System name"]
[null,null,"Contains variation of Assistance?",null,{"$f":"IF(D7=\"Yes\",10,0)","v":0}]
[null,null,"Contains variation of Auto(matic)?",null,{"$f":"IF(AND(D7=\"No\",D8=\"No\"),5,0)","v":0}]
[]
[null,"System Name assessment",null,{"$f":"SUM(E7:E8)","v":0}]
[]
[null,"MARKETING MATERIAL"]
[null,null,"Marketing material ",null,{"$f":"IF(D13=\"\",0,IF(D13=\"Misleading\",0,5))","v":0}]
[]
[null,"Marketing Material assessment",null,{"$f":"E13","v":0}]
[]
[null,"QUICK START GUIDE"]
[null,null,"Quick start guide availability",null,{"$f":"IF(D18=\"\",0,IF(D18=\"Yes\",3,0))","v":0}]
[null,null,"Tutorial video/animation/interactive experience available via Vehicle Infotainment System",null,{"$f":"IF(D19=\"\",0,IF(D19=\"Yes\",2,0))","v":0}]
[]
[null,"Quick Start Guide assessment",null,{"$f":"E18+E19","v":0}]
[]
[null,"VEHICLE HANDBOOK"]
[null,null,"Clear description of level of Assistance",null,{"$f":"IF(D24=\"\",0,IF(D24=\"Yes\",5,0))","v":0}]
[]
[null,"Vehicle Handbook assessment",null,{"$f":"E24","v":0}]
[]
[null,"SUMMARY"]
[null,null,"System Name",{"$f":"D10","v":0}]
[null,null,"Marketing Material",{"$f":"D15","v":0}]
[null,null,"Quick Start Guide",{"$f":"D21","v":0}]
[null,null,"Vehicle Handbook",{"$f":"D26","v":0}]
[null,"TOTAL SCORE",null,{"$f":"SUM(D29:E32)","v":0}]
[]
[null,"TOTAL CONSUMER INFORMATION",null,{"$f":"D33","v":0}]

{"sheet":"DE System Status","index":4,"n_rows":55,"n_cols":8,"rows_kept":55,"cut":false,"hidden":false,"merged":[[49,3,49,7],[50,3,50,7],[51,3,51,7],[52,3,52,7],[54,3,54,7],[47,1,47,2],[47,3,47,7],[36,3,37,3],[36,4,37,4],[36,5,37,5],[40,3,40,7],[45,1,45,2],[36,1,37,2],[41,7,42,7],[45,3,45,7],[41,1,42,2],[41,3,42,3],[41,4,42,4],[41,5,42,5],[1,1,3,2],[23,3,23,7],[1,3,2,7],[3,3,3,7],[4,3,4,7],[5,3,5,7],[6,3,6,7],[23,1,23,2],[12,1,12,2],[12,3,12,7],[16,1,16,2],[16,3,16,7],[21,1,21,2],[21,3,21,7],[17,1,17,2],[13,1,13,2],[54,1,54,2],[49,1,49,2],[52,1,52,2],[30,1,30,2],[30,3,30,7],[35,1,35,2],[35,3,35,7],[31,3,32,3],[31,4,32,4],[31,5,32,5],[31,6,32,6],[31,7,32,7],[41,6,42,6],[36,6,37,6],[36,7,37,7],[46,3,46,7],[25,5,26,5],[22,3,22,7],[25,6,26,6],[31,1,32,2],[40,1,40,2],[26,1,26,2],[25,3,26,3],[25,4,26,4],[25,7,26,7]]}
[3]
[null,"System Status"]
[]
[]
[null,"PRECONDITIONS (2.2.1)"]
[null,null,"Indicators fitted as standard or as part of option?"]
[null,null,"Can system be used with indicator disabled?"]
[]
[null,"CONTINUOUS SYSTEM STATUS INDICATOR (2.2.2)",null,"Stand-by","Longitudinal only","Lateral only","Longitudinal & Lateral"]
[null,null,"Indicator for each system mode (default ON)"]
[null,null,"Configurable status information in instrument cluster"]
[null,null,"Additional indicator in driver's direct sight"]
[null,null,null,{"$f":"IF(AND(D6=\"Yes\",D7=\"Yes\"),(IF(COUNTIF(D10:G10,\"No\")>0,0,COUNTIF(D11:G11,\"Yes\")*0.5+COUNTIF(D12:G12,\"Yes\")*1.5)),0)","v":0}]
[null,null,null,"Stand-by","Longitudinal only","Lateral only","Longitudinal & Lateral","Vehicle in lane ahead"]
[null,null,"Indicator always ON"]
[null,null,"Distinguishable from other mode"]
[null,null,null,{"$f":"IF(AND(D6=\"Yes\",D7=\"Yes\"),(COUNTIF(D15:H15,\"Yes\")*0.5+COUNTIF(D16:H16,\"Yes\")*0.5),0)","v":0}]
[null,null,null,"Stand-by","Longitudinal only","Lateral only","Longitudinal & Lateral"]
[null,null,"Indicator in contrasting colour"]
[null,null,"Colours confirm to conventions"]
[null,null,"No flashing indicators for continuous system status"]
[null,null,null,{"$f":"IF(AND(D6=\"Yes\",D7=\"No\"),(COUNTIF(D19:D21,\"Yes\")*(5/12)+COUNTIF(E19:E21,\"Yes\")*(5/12)+COUNTIF(F19:F21,\"Yes\")*(5/12)+COUNTIF(G19:G21,\"Yes\")*(5/12)),0)","v":0}]
[]
[null,"Continuous System Status Indicator assessment",null,{"$f":"SUM(D13,D17,D22)","v":0}]
[]
[null,"SYSTEM STATUS CHANGE INDICATOR (2.2.3)",null,"Environmental Conditions\nLongitudinal & Lateral\n-> Longitudinal only","Sensor Blocking\nLongitudinal & Lateral\n-> Longitudinal only"]
[]
[null,null,"Change in continuous status indicator"]
[null,null,"Audible or Haptic warning"]
[null,null,"Additional visual information"]
[null,null,null,{"$f":"IF(AND(OR(D28=\"Yes\",E28=\"Yes\"),D41=\"PASS\"),COUNTIF(D29:D30,\"Yes\")*2,0)","v":0}]
[null,null,null,"Longitudinal & Lateral\n-> Longitudinal only"]
[]
[null,null,"Additional visual information when “hands-off”"]
[null,null,"Information does not startle or annoy"]
[null,null,null,{"$f":"IF(D41=\"PASS\",COUNTIF(D34:D35,\"Yes\")*1,0)","v":0}]
[null,null,null,"No assistance\n-> Longitudinal only","No assistance\n-> Lateral only","No assistance\n-> Longitudinal & Lateral","Longitudinal only\n-> Longitudinal & Lateral","Lateral only\n-> Longitudinal & Lateral"]
[]
[null,null,"System initiated change in status indicator"]
[null,null,"Driver initiated change in status indicator"]
[null,null,null,{"$f":"IF(COUNTIF(D39:H40,\"Yes\")+COUNTIF(D39:H40,\"N/A\")=7,\"PASS\",\"FAIL\")","v":"FAIL"}]
[null,null,null,"No assistance\n-> Longitudinal only","No assistance\n-> Lateral only","No assistance\n-> Longitudinal & Lateral","Longitudinal only\n-> Longitudinal & Lateral","Lateral only\n-> Longitudinal & Lateral"]
[]
[null,null,"No change in status indicator"]
[null,null,"Additional visual information"]
[null,null,null,{"$f":"IF(COUNTIF(D44:H44,\"Yes\")+COUNTIF(D44:H44,\"N/A\")=5,COUNTIF(D45:H45,\"Yes\")*0.2,0)","v":0}]
[]
[null,"System Status Change Indicator assessment",null,{"$f":"SUM(D31,D36,D46)","v":0}]
[]
[null,"SUMMARY"]
[null,null,"Continuous System Status Indicator",{"$f":"D24/((4-COUNTIF(D10:G10,\"N/A\"))*2+5-COUNTIF(D15:G15,\"N/A\")+(4-COUNTIF(D19:G19,\"N/A\"))*1.25)*18","v":0}]
[null,null,"System Status Change Indicator",{"$f":"D48/((5-COUNTIF(D44:H44,\"N/A\"))*0.2+6)*7","v":0}]
[null,"TOTAL SCORE",null,{"$f":"SUM(D51:E52)","v":0}]
[]
[null,"TOTAL SYSTEM STATUS",null,{"$f":"D53","v":0}]

{"sheet":"DE Driver Monitoring","index":5,"n_rows":50,"n_cols":12,"rows_kept":50,"cut":false,"hidden":false,"merged":[[42,1,42,5],[49,6,49,7],[47,1,47,2],[47,6,47,7],[4,6,4,7],[10,6,10,7],[45,6,45,7],[5,6,5,7],[6,6,6,7],[7,6,7,7],[46,6,46,7],[42,6,42,7],[13,6,13,7],[15,6,15,7],[16,6,16,7],[17,6,17,7],[34,8,35,8],[8,6,8,7],[9,6,9,7],[5,1,8,1],[14,6,14,7],[6,2,6,5],[5,2,5,5],[10,1,10,5],[12,6,12,7],[13,1,18,1],[18,6,18,7],[29,3,30,4],[31,3,32,4],[33,3,33,4],[19,6,19,7],[20,6,20,7],[21,6,21,7],[22,6,22,7],[41,1,41,7],[37,1,39,1],[34,5,35,5],[34,6,35,6],[34,7,35,7],[36,3,36,4],[39,2,39,5],[38,2,38,5],[37,2,37,5],[40,1,40,6],[34,3,35,4],[24,1,36,1],[24,2,28,2],[29,2,33,2],[34,2,36,2],[27,3,28,4],[4,1,4,5],[9,2,9,5],[8,2,8,5],[7,2,7,5],[24,3,26,4],[20,1,22,1],[23,3,23,4],[23,1,23,2],[44,1,44,7],[49,1,49,5],[45,2,45,5],[46,2,46,5],[1,1,3,7],[13,2,13,5],[14,2,14,5],[22,2,22,5],[21,2,21,5],[20,2,20,5],[19,2,19,5],[18,2,18,5],[17,2,17,5],[16,2,16,5],[15,2,15,5],[12,1,12,5]]}
[3]
[null,"Driver Monitoring"]
[]
[]
[null,"Hands-on Monitoring"]
[null,"Monitoring","Optical warning within 15s after hands-off"]
[null,null,"Acoustic & red optical warning within 30s after hands-off"]
[null,null,"System deactivation within 30s of acoustic warning"]
[null,null,"System lock-out until next IGN ON if severe hands-off warning occur up to 3 times"]
[null,"Sensing","Robust sensing of hands on steering wheel"]
[null,"Hands-on Monitoring assessment",null,null,null,null,{"$f":"IF(AND(G6=\"Yes\",G7=\"Yes\",G8=\"Yes\",G9=\"Yes\"),5,0)+IF(G10=\"Yes\",5,0)","v":0}]
[]
[null,"Direct Driver Monitoring"]
[null,"General Preconditions","DSM integral part of the system (i.e., not optional equipment)"]
[null,null,"Not possible to activate Assisted mode if DSM is not available"]
[null,null,"Assisted mode is deactivated within 10s. if DSM is not available "]
[null,null,"DSM activation forced when enabling Assisted mode (if previously switched OFF)"]
[null,null,"System lock-out until next IGN ON if driver is classified as Unresponsive up to 3 times"]
[null,null,"DSM strategy in Assisted mode covers the same behaviours as in Manual mode"]
[null,"DSM Strategy","DSM strategy in Assisted mode strategy different than in Manual mode"]
[null,"DSM Strategy Preconditions","Long distraction warning timing threshold in Assisted mode <=+150% vs Manual mode"]
[null,null,"ODD dependant warning strategy"]
[null,null,"DSM strategy in Assisted Mode same as in Assisted Mode in at least 1 of the designated ODD"]
[null,"Driver State",null,"Scenario",null,"Movement","Warning","Intervention","Sub-totals"]
[null,"Distraction","Long Distraction","Away from forward road, non-driving task",null,"Owl ",null,null,{"$f":"IF(G25=\"Yes\",K25,0)+IF(H25=\"Yes\",L25,0)","v":0},null,0.22500000000000001,0.22500000000000001]
[null,null,null,null,null,"Lizard",null,null,0,null,0.22500000000000001,0.22500000000000001]
[null,null,null,null,null,"Body lean",null,null,0,null,0.22500000000000001,0.22500000000000001]
[null,null,null,"Driving task",null,"Owl ",null,null,0,null,0.22500000000000001,0.22500000000000001]
[null,null,null,null,null,"Lizard",null,null,0,null,0.22500000000000001,0.22500000000000001]
[null,null,"Short Distraction (VATS)","Away from forward road, non-driving task",null,"Owl ",null,null,0,null,0.22500000000000001,0.22500000000000001]
[null,null,null,null,null,"Lizard",null,null,0,null,0.22500000000000001,0.22500000000000001]
[null,null,null,"Driving task",null,"Owl ",null,null,0,null,0.22500000000000001,0.22500000000000001]
[null,null,null,null,null,"Lizard",null,null,0,null,0.22500000000000001,0.22500000000000001]
[null,null,null,"Away from road (multiple locations)",null,"Lizard",null,null,0,null,0.22500000000000001,0.22500000000000001]
[null,null,"Phone Usage","Phone Use Detection – Basic ",null,"Owl +\nLizard",null,null,0,null,0.375,0.75]
[]
[null,null,null,"Phone Use Detection – Advanced ",null,"Lizard",null,null,{"$f":"IF(G37=\"Yes\",K37,0)+IF(H37=\"Yes\",L37,0)","v":0},null,0.375,0.75]
[null,"Fatigue","Drowsiness",null,null,null,null,null,{"$f":"IF(G38=\"Yes\",K38,0)+IF(H38=\"Yes\",L38,0)","v":0},null,1.875,0.75]
[null,null,"Microsleep",null,null,null,null,null,{"$f":"IF(G39=\"Yes\",K39,0)+IF(H39=\"Yes\",L39,0)","v":0},null,1.5,0.75]
[null,null,"Sleep",null,null,null,null,null,{"$f":"IF(G40=\"Yes\",K40,0)+IF(H40=\"Yes\",L40,0)","v":0},null,0.375,1.5]
[null,"Unresponsive Driver - Sudden Sickness",null,null,null,null,null,"Yes",{"$f":"IF(H41=\"Yes\",L41,0)","v":1.5},null,null,1.5]
[null,"Total Scenario Score",null,null,null,null,null,null,{"$f":"SUM(I25:I41)","v":1.5}]
[null,"Direct Driver Monitoring assessment",null,null,null,null,{"$f":"IF(G20=\"Yes\",IF(AND(COUNTIFS(G14:H19,\"Yes\")=6,COUNTIFS(G21:H23,\"Yes\")=3),I42,0),IF(COUNTIFS(G14:H19,\"Yes\")=6,I42,0))","v":0}]
[]
[null,"SUMMARY"]
[null,null,"Hands-on Monitoring",null,null,null,{"$f":"G11","v":0}]
[null,null,"Direct Driver Monitoring ",null,null,null,{"$f":"G43","v":0}]
[null,"TOTAL SCORE",null,null,null,null,{"$f":"SUM(G46:H47)","v":0}]
[]
[null,"TOTAL DRIVER MONITORING",null,null,null,null,{"$f":"G48","v":0}]

{"sheet":"DE Driving Collaboration","index":6,"n_rows":25,"n_cols":5,"rows_kept":25,"cut":false,"hidden":false,"merged":[[1,3,2,4],[11,1,11,2],[1,1,3,2],[4,3,4,4],[11,3,11,4],[22,3,22,4],[24,1,24,2],[24,3,24,4],[19,1,19,2],[20,3,20,4],[21,3,21,4],[22,1,22,2],[19,3,19,4],[13,3,13,4],[17,1,17,2],[17,3,17,4],[14,3,14,4],[15,3,15,4]]}
[3]
[null,"Driver Input Response"]
[]
[null,null,null,"System ON","System OFF"]
[null,"INCREASE IN STEERING TORQUE"]
[null,null,"Run 1 maximum torque - Nm"]
[null,null,"Run 2 maximum torque - Nm"]
[null,null,"Run 3 maximum torque - Nm"]
[null,null,"Average torque",{"$f":"IF(COUNTIF(D6:D8,\"\")>0,\"No measurements\",AVERAGE(D6:D8))","v":"No measurements"},{"$f":"IF(COUNTIF(E6:E8,\"\")>0,\"No measurements\",AVERAGE(E6:E8))","v":"No measurements"}]
[null,null,"%-age increase in torque",{"$f":"IF(COUNTIF(D6:D9,\"\")>0,\"No measurements\",(D9-E9)/E9)","v":"No measurements"}]
[]
[null,"Increase in steering torque assessment",null,{"$f":"IF(COUNTIF(D9:E10,\"No measurements\")>0,0,IF(D10<0.33,5,IF(D10<0.67,3,IF(D10<1,1,0))))","v":0}]
[]
[null,"OVERRIDE RESPONSE"]
[null,null,"Absolute override torque",{"$f":"IF(COUNTIF(D9:E9,\"No measurements\")>0,\"No measurements\",D9)","v":"No measurements"}]
[null,null,"System response"]
[]
[null,"Override torque assessment",null,{"$f":"IF(D15<=5,IF(D16=\"Continuous assistance & re-centring\",20,IF(D16=\"Reengaged assistance after re-centring by driver\",10,0)),0)","v":0}]
[]
[null,"SUMMARY"]
[null,null,"Increase in steering torque",{"$f":"D12","v":0}]
[null,null,"Override response",{"$f":"D18","v":0}]
[null,"TOTAL SCORE",null,{"$f":"SUM(D21:E22)","v":0}]
[]
[null,"TOTAL DRIVER INPUT RESPONSE",null,{"$f":"D23","v":0}]

{"sheet":"VA Speed Assistance","index":7,"n_rows":81,"n_cols":11,"rows_kept":81,"cut":false,"hidden":false,"merged":[[80,1,80,2],[80,3,80,5],[65,3,65,5],[74,1,74,2],[74,3,74,5],[78,1,78,2],[78,3,78,5],[75,3,75,5],[65,1,65,2],[68,3,68,4],[70,3,70,4],[72,1,72,2],[72,3,72,5],[69,3,69,4],[77,3,77,5],[76,3,76,5],[1,3,2,5],[57,1,57,2],[57,3,57,5],[1,1,3,2],[45,3,45,5],[4,3,4,5],[43,1,43,2],[43,3,43,5],[12,1,21,1],[7,1,10,1],[6,3,6,4],[5,3,5,4],[11,1,11,2],[46,3,46,5],[47,3,47,5],[48,3,48,5],[9,3,9,4],[8,3,8,4],[7,3,7,4],[31,1,39,1],[11,3,11,5],[23,1,29,1],[22,1,22,2],[22,3,22,5],[10,3,10,4],[41,3,41,4],[30,3,30,5],[40,3,40,5],[30,1,30,2],[40,1,40,2],[42,1,42,2],[55,3,55,4],[52,3,52,4],[49,3,49,4],[63,3,63,4],[62,3,62,4],[59,1,59,2],[59,3,59,5]]}
[]
[null,"Speed Assistance"]
[]
[null,null,null,"OEM Prediction","Lab Verification","Score"]
[null,"SPEED LIMIT INFORMATION FUNCTION"]
[null,null,"Type of system"]
[null,null,"General requirements",null,null,{"$f":"D7","v":0}]
[null,"Warning Function","Default ON at start of every journey",null,null,{"$f":"IF(D8=\"\",\"\",D8)","v":""},null,null,"Warning Function - Duration"]
[null,null,"Position of warning",null,null,{"$f":"IF(D9=\"\",\"\",IF(D9<>\"Other\",\"Pass\",\"Fail\"))","v":""},null,null,"<10 s."]
[null,null,"Type of warning",null,null,{"$f":"IF(D10=\"\",\"\",IF(D10<>\"Other\",\"Pass\",\"Fail\"))","v":""},null,null,">=10 s. "]
[null,null,"Total duration (only for non GSR2 ISA vehicles)",null,null,{"$f":"IF(D11=\"\",\"\",IF(AND(D11<>\"\",OR(D11=I10,D11=I11)),\"Pass\",\"Fail\"))","v":""},null,null,"GSR2 ISA compliant"]
[null,"General requirements assessment - Total",null,{"$f":"IF(COUNTIFS(F7:F11,\"Pass\")=5,1.5,0)","v":0}]
[2,"Advanced Speed Limits ","Weather - Rain / Wetness",null,null,{"$f":"IF(AND(D13=\"Pass\",E13=\"No discrepancy\"),A13,0)","v":0}]
[2,null,"Weather - Snow / Icy",null,null,{"$f":"IF(AND(D14=\"Pass\",E14=\"No discrepancy\"),A14,0)","v":0}]
[3,null,"Time",null,null,0]
[1,null,"Distance For / In",null,null,0]
[1,null,"Arrows",null,null,0]
[1,null,"Vehicle Categories",null,null,0]
[2,null,"Implicit Speed Limits - Highway / Motorway",null,null,0]
[3,null,"Implicit Speed Limits - City Entry / Exit",null,null,0]
[2,null,"Implicit Speed Limits - Residential Zones",null,null,0]
[3,null,"Dynamic Speed Limits",null,null,0]
[null,"Advanced Speed Limits assessment - Subtotal",null,{"$f":"SUM(F13:F22)","v":0}]
[2,"Road Features\n(Speed Adaptation)","Curves",null,null,{"$f":"IF(AND(D24=\"Pass\",E24=\"No discrepancy\"),A24,0)","v":0}]
[2,null,"Roundabouts",null,null,{"$f":"IF(AND(D25=\"Pass\",E25=\"No discrepancy\"),A25,0)","v":0}]
[1,null,"Junctions",null,null,0]
[2,null,"Traffic lights",null,null,0]
[1,null,"Stop signs",null,null,0]
[1,null,"Yield/Give way signs",null,null,0]
[1,null,"Toll Stations",null,null,0]
[null,"Road features - Subtotal",null,{"$f":"SUM(F24:F30)","v":0}]
[2,"Local Hazards\n(Inform & Warn)","Traffic jams",null,null,{"$f":"IF(AND(D32=\"Pass\",E32=\"No discrepancy\"),A32,0)","v":0}]
[1,null,"Construction zones",null,null,{"$f":"IF(AND(D33=\"Pass\",E33=\"No discrepancy\"),A33,0)","v":0}]
[1,null,"Accident ahead",null,null,0]
[1,null,"Wrong way driver",null,null,0]
[1,null,"Stopped vehicle on hard shoulder",null,null,0]
[1,null,"Items in road (including animals, people, debris etc.)",null,null,0]
[1,null,"Poor road conditions (including slippery roads)",null,null,0]
[1,null,"Poor weather conditions (including fog, heavy rain, etc.)",null,null,0]
[1,null,"Emergency vehicle",null,null,0]
[null,"Local hazards - Subtotal",null,{"$f":"SUM(F32:F40)","v":0}]
[null,"System Updates",null,null,null,{"$f":"IF(D42=\"Quarterly\",5,IF(D42=\"Continuous\",10,0))","v":0}]
[null,"System updates - Subotal",null,null,null,{"$f":"F42","v":0}]
[null,"Speed Limit Information Function score",null,{"$f":"IF(D12=0,0,D12+D23*(0.75/20)+D31*(0.75/10)+D41*(0.75/10)+F43*(0.75/10))","v":0}]
[]
[null,"SPEED CONTROL FUNCTION"]
[null,null,"Setting Vadj",null,null,null,null,null,null,null,{"$f":"\"\"","v":""}]
[]
[null,null,"50 km/h test"]
[null,null,"Vstab",null,null,{"$f":"IF(AND(D50<>\"\",D50>=45),\"Pass\",\"Fail\")","v":"Fail"}]
[null,null,"difference between Vstab and Vadj",{"$f":"IF(D50=\"\",\"\",50-D50)","v":""}]
[null,null,"80 km/h test"]
[null,null,"Vstab",null,null,{"$f":"IF(AND(D53<>\"\",D53>=75),\"Pass\",\"Fail\")","v":"Fail"}]
[null,null,"difference between Vstab and Vadj",{"$f":"IF(D53=\"\",\"\",80-D53)","v":""}]
[null,null,"120 km/h test"]
[null,null,"Vstab",null,null,{"$f":"IF(AND(D56<>\"\",D56>=115),\"Pass\",\"Fail\")","v":"Fail"}]
[null,null,"difference between Vstab and Vadj",{"$f":"IF(D56=\"\",\"\",120-D56)","v":""}]
[null,"Speed Control Function score",null,{"$f":"IF(AND(D51<=5,D54<=5,D57<=5),IF(D47=\"System advised\",4.5,IF(D47=\"Manually set\",IF(D44>0,2.25,3.75),0)),0)","v":0}]
[]
[null,"SAS RATING SCORE",null,{"$f":"(D44+D58)","v":0}]
[]
[null,"Reaction to Speed Limit Changes",null,"Value",null,"Points"]
[null,null,"Fixed speed limits",null,null,{"$f":"IF(D63=\"At speed at sign\",6,IF(D63=\"Slowing down at sign\",4,IF(D63=\"Start slowing down after sign\",2,0)))","v":0}]
[null,null,"Variable and temporary speed limits",null,null,{"$f":"IF(D64=\"At speed at sign\",6,IF(D64=\"Slowing down at sign\",6,IF(D64=\"Start slowing down after sign\",3,0)))","v":0}]
[]
[null,"REACTION TO SPEED LIMIT CHANGES SCORE",null,{"$f":"SUM(F63:F64)","v":0}]
[]
[null,"Lane-Relevant SLIF",null,"Value",null,"Points"]
[null,null,"Explicit speed limits",null,null,{"$f":"D69","v":0}]
[null,null,"Conditional speed limits",null,null,{"$f":"D70","v":0}]
[null,null,"Dynamic speed limits / Gantry",null,null,{"$f":"D71","v":0}]
[]
[null,"LANE-RELEVANT SLIF SCORE",null,{"$f":"IF(COUNTIFS(F69:F71,\"Pass\")=3,4,0)","v":0}]
[]
[null,"SUMMARY"]
[null,null,"SAS rating score",{"$f":"D60","v":0}]
[null,null,"Reaction to speed limit changes score",{"$f":"D66","v":0}]
[null,null,"Lane-Relevant SLIF score",{"$f":"D73","v":0}]
[null,"TOTAL SCORE",null,{"$f":"SUM(D76:F78)","v":0}]
[]
[null,"TOTAL ACC PERFORMANCE ROAD",null,{"$f":"D79","v":0}]

{"sheet":"VA ACC Performance","index":8,"n_rows":97,"n_cols":12,"rows_kept":97,"cut":false,"hidden":false,"merged":[[92,2,92,4],[85,1,85,4],[86,1,86,4],[87,1,87,4],[86,5,86,8],[87,5,87,8],[92,7,92,8],[37,1,37,8],[38,1,38,4],[38,5,38,8],[91,2,91,4],[89,5,89,6],[89,7,89,8],[80,5,80,8],[81,5,81,8],[82,5,82,8],[62,5,62,6],[62,7,62,8],[63,7,63,8],[64,7,64,8],[40,7,40,8],[93,7,93,8],[90,5,90,6],[91,5,91,6],[92,5,93,6],[90,7,91,8],[7,10,7,13],[8,11,8,13],[9,11,10,13],[11,11,11,13],[79,5,79,8],[42,7,42,8],[43,7,43,8],[44,7,44,8],[45,5,45,6],[45,7,45,8],[46,7,46,8],[47,7,47,8],[48,7,48,8],[49,5,49,6],[50,5,50,6],[51,5,51,6],[64,5,64,6],[44,11,44,13],[40,5,40,6],[41,11,41,13],[69,7,69,8],[65,7,65,8],[85,5,85,8],[5,2,5,4],[5,5,5,8],[7,5,7,6],[83,1,83,4],[84,1,84,4],[79,1,79,4],[80,1,80,4],[81,1,81,4],[82,1,82,4],[83,5,83,8],[84,5,84,8],[40,10,40,13],[42,11,43,13],[4,5,4,8],[78,1,78,4],[78,5,78,8],[52,5,52,6],[53,5,53,6],[53,7,53,8],[54,7,54,8],[55,7,55,8],[56,7,56,8],[57,7,57,8],[58,7,58,8],[59,7,59,8],[60,7,60,8],[41,1,69,1],[40,1,40,4],[66,7,66,8],[67,5,67,6],[67,7,67,8],[68,7,68,8],[61,7,61,8],[70,1,70,8],[71,5,71,8],[96,1,96,4],[96,5,96,8],[1,1,2,4],[73,5,73,8],[74,5,74,8],[75,1,75,8],[76,5,76,8],[76,1,76,4],[74,2,74,4],[73,1,73,4],[89,1,89,4],[94,1,94,4],[90,2,90,4],[93,2,93,4],[1,5,1,8],[3,1,3,4],[3,5,3,8],[2,5,2,8],[4,2,4,4],[94,5,94,8],[7,1,7,4],[8,1,36,1],[7,7,7,8],[71,1,71,4]]}
[3]
[null,"ACC Performance Vehicle",null,null,null,"AD"]
[]
[null,"SYSTEM DETAILS"]
[null,null,"Speed range (km/h) - Minimum"]
[null,null,"Maximum"]
[]
[null,"Longitudinal Control Car-to-Car",null,null,null,"Straight road 100%",null,"Curved road 100%",null,null,"Legend Car-to-Car"]
[null,"Car-to-Car","CCRs - Stationary target","VUT","Target","Assessment","Max deceleration [m/s²]","Assessment","Max deceleration [m/s²]",null,"Green","Avoidance"]
[null,null,null,70,"-",null,null,null,null,null,"Orange","Mitigation when speed reduction by ACC > 5 km/h @ decel < 5/m2"]
[null,null,null,80,"-"]
[null,null,null,90,"-",null,null,null,null,null,"Grey","Speed reduction by ACC < 5 km/h"]
[null,null,null,100,"-"]
[null,null,null,110,"-"]
[null,null,null,120,"-"]
[null,null,null,130,"-"]
[null,null,"CCRm - Moving target"]
[null,null,null,80,20]
[null,null,null,90,20]
[null,null,null,100,20]
[null,null,null,110,20]
[null,null,null,120,20]
[null,null,null,130,20]
[null,null,null,80,60]
[null,null,null,90,60]
[null,null,null,100,60]
[null,null,null,110,60]
[null,null,null,120,60]
[null,null,null,130,60]
[null,null,"CCRb - Braking target @ -4 m/s2"]
[null,null,"ACC-mode closest",55,50]
[null,null,"Cut-in"]
[null,null,"Cut-in @ TTC =  0.00",50,10]
[null,null,"Cut-in @ TTC =  1.50",120,70]
[null,null,"Cut-out"]
[null,null,"Cut-out @ TTC =  3.00",70,50]
[null,null,"Cut-out @ TTC =  3.00",90,70]
[]
[null,"Longitudinal Control Car-to-Car assessment",null,null,null,{"$f":"COUNTIF(F10:I37,\"Green\")*1+COUNTIF(F10:I37,\"Orange\")*0.5","v":0}]
[]
[null,"Longitudinal Control Car-to-Motorcyclist",null,null,null,"Straight road 25%",null,"Curved road 100%",null,null,"Legend Car-to-Motorcyclist"]
[null,"Car-to-Motorcyclist","CMRs - Stationary target, GVT in front","VUT","Target","Assessment","Max deceleration [m/s²]","Assessment","Max deceleration [m/s²]",null,"Green","Avoidance"]
[null,null,null,70,"-",null,null,null,null,null,"Orange","Mitigation when speed reduction by ACC > 15 km/h @ decel < 5/m2"]
[null,null,null,80,"-"]
[null,null,null,90,"-",null,null,null,null,null,"Grey","Speed reduction by ACC < 15 km/h"]
[null,null,"CMRs - Stationary target, GVT on side"]
[null,null,null,70,"-"]
[null,null,null,80,"-"]
[null,null,null,90,"-"]
[null,null,"CMRs - Stationary target, curved road"]
[null,null,null,70,"-"]
[null,null,null,80,"-"]
[null,null,null,90,"-"]
[null,null,"CMRm - Moving Target"]
[null,null,null,100,20]
[null,null,null,110,20]
[null,null,null,120,20]
[null,null,null,130,20]
[null,null,null,100,60]
[null,null,null,110,60]
[null,null,null,120,60]
[null,null,null,130,60]
[null,null,"CMRb - Braking target @ -4 m/s2"]
[null,null,"ACC-mode closest",55,50]
[null,null,"Cut-in"]
[null,null,"Cut-in @ TTC =  0.50",50,10]
[null,null,"Cut-in @ TTC =  1.50",120,70]
[null,null,"Cut-out"]
[null,null,"Cut-out @ TTC =  3.00",70,50]
[null,null,"Cut-out @ TTC =  3.00",90,70]
[]
[null,"Longitudinal Control Car-to-Motorcyclist assessment",null,null,null,{"$f":"COUNTIF(F43:I70,\"Green\")*1+COUNTIF(F43:I70,\"Orange\")*0.5","v":0}]
[]
[null,"UNDERTAKE PREVENTION"]
[null,null,"Undertake prevention @ speeds > 90 km/h"]
[]
[null,"Undertake prevention assessment",null,null,null,{"$f":"IF(F75=\"Yes\",5,0)","v":0}]
[]
[null,"ACC AUTO-RESUME"]
[null,"Assistance maintained after coming to a full stop"]
[]
[null,"Automatic resume within 5s of stop and driver input required over 5s"]
[null,"Automatic resume with eyes on to confirm engagement"]
[null,"Automatic resume with collision prevention by external sensors"]
[null,"Driver action required (no automatic resume)"]
[null,"Automatic resume after stop (any time after stop)"]
[]
[null,"ACC Auto-Resume assessment",null,null,null,{"$f":"IF(F80=\"Yes\",IF(OR(F82=\"Yes\",F83=\"Yes\",F84=\"Yes\"),10,IF(F85=\"Yes\",7,IF(F86=\"Yes\",3,0))),0)","v":0}]
[]
[null,"SUMMARY",null,null,null,"Sub-total",null,"Total"]
[null,null,"Longitudinal Control Car-to-Car score",null,null,{"$f":"F39","v":0},null,{"$f":"(F91+F92)/53*25","v":0}]
[null,null,"Longitudinal Control Car-to-Motorcyclist score",null,null,{"$f":"F72","v":0}]
[null,null,"Undertake Prevention score",null,null,null,null,{"$f":"F77","v":0}]
[null,null,"ACC Auto-Resume score",null,null,null,null,{"$f":"F88","v":0}]
[null,"TOTAL SCORE",null,null,null,{"$f":"SUM(H91:I94)","v":0}]
[]
[null,"TOTAL ACC PERFORMANCE VEHICLE",null,null,null,{"$f":"F95","v":0}]

{"sheet":"VA Steering Assistance","index":9,"n_rows":23,"n_cols":5,"rows_kept":23,"cut":false,"hidden":false,"merged":[[18,3,18,4],[17,3,17,4],[10,1,10,2],[17,1,17,2],[10,3,10,4],[1,1,3,2],[1,3,2,4],[12,3,12,4],[13,3,13,4],[15,1,15,2],[15,3,15,4],[22,3,22,4],[20,3,20,4],[20,1,20,2],[22,1,22,2],[19,3,19,4]]}
[3]
[null,"Steering Assistance"]
[]
[]
[null,"STEERING ASSISTANCE",null,"Value","Points"]
[null,null,"S-Bend tests"]
[null,null,"80 km/h",null,{"$f":"IF(D7=\"Vehicle stays in lane\",10,IF(D7=\"Vehicle directed in 2nd turn\",7.5,IF(D7=\"Vehicle directed in 1st turn\",2.5,0)))","v":0}]
[null,null,"100 km/h",null,{"$f":"IF(D8=\"Vehicle stays in lane\",10,IF(D8=\"Vehicle directed in 2nd turn\",7.5,IF(D8=\"Vehicle directed in 1st turn\",5,0)))","v":0}]
[null,null,"120 km/h",null,{"$f":"IF(D9=\"Vehicle stays in lane\",10,IF(D9=\"Vehicle directed in 2nd turn\",10,IF(D9=\"Vehicle directed in 1st turn\",7.5,0)))","v":0}]
[]
[null,"Steering Assist assessment",null,{"$f":"SUM(E7:E9)","v":0}]
[]
[null,"LANE CHANGE ASSIST"]
[null,null,"Lane Change Assist fitted"]
[]
[null,"Lane Change Assist assessment",null,{"$f":"IF(D14=\"Yes\",5,0)","v":0}]
[]
[null,"SUMMARY"]
[null,null,"Steering Assist assessment",{"$f":"D11","v":0}]
[null,null,"Lane Change Assist assessment",{"$f":"D16","v":0}]
[null,"TOTAL SCORE",null,{"$f":"D19+D20","v":0}]
[]
[null,"TOTAL STEERING ASSISTANCE",null,{"$f":"D21","v":0}]

{"sheet":"SB System Failure","index":10,"n_rows":32,"n_cols":9,"rows_kept":32,"cut":false,"hidden":false,"merged":[[31,1,31,4],[29,1,29,4],[28,2,28,4],[31,5,31,8],[29,5,29,8],[28,5,28,8],[27,5,27,8],[25,5,25,8],[27,1,27,4],[25,1,25,4],[1,1,3,3],[8,2,9,2],[14,2,15,2],[20,2,21,2],[6,2,7,2],[12,2,13,2],[18,2,19,2],[24,1,24,3]]}
[3]
[null,"System Failure"]
[]
[]
[null,"SYSTEM FAILURE",null,null,"Degradation expected","Engagement (after 2 min.)","Warning","Verification test","Points"]
[null,null,"Sensor blocked at Start-up"]
[null,null,"Camera","Full blockage",null,null,null,null,{"$f":"IF(OR(E7=\"\",AND(OR(E7=\"No\",E7=\"Unknown (no OEM data)\"),OR(F7=\"\",F7=\"System can be engaged\"),OR(G7=\"\",G7=\"No warning\"),OR(H7=\"\",H7=\"Fail\"))),0,IF(AND(OR(E7=\"No\",E7=\"Unknown (no OEM data)\"),H7=\"Pass\"),5,IF(AND(F7=\"System can NOT be engaged\",G7=\"Visual Warning within 5 minutes\"),5,IF(F7=\"System can NOT be engaged\",4,0))))","v":0}]
[null,null,null,"Partial blockage",null,null,null,null,0]
[null,null,"Lidar","Full blockage",null,null,null,null,0]
[null,null,null,"Partial blockage",null,null,null,null,{"$f":"IF(OR(E10=\"\",AND(OR(E10=\"No\",E10=\"Unknown (no OEM data)\"),OR(F10=\"\",F10=\"System can be engaged\"),OR(G10=\"\",G10=\"No warning\"),OR(H10=\"\",H10=\"Fail\"))),0,IF(AND(OR(E10=\"No\",E10=\"Unknown (no OEM data)\"),H10=\"Pass\"),5,IF(AND(F10=\"System can NOT be engaged\",G10=\"Visual Warning within 5 minutes\"),5,IF(F10=\"System can NOT be engaged\",4,0))))","v":0}]
[null,null,"Radar","Full blockage",null,null,null,null,{"$f":"IF(OR(E11=\"\",AND(OR(E11=\"No\",E11=\"Unknown (no OEM data)\"),OR(F11=\"\",F11=\"System can be engaged\"),OR(G11=\"\",G11=\"No warning\"),OR(H11=\"\",H11=\"Fail\"))),0,IF(AND(OR(E11=\"No\",E11=\"Unknown (no OEM data)\"),H11=\"Pass\"),10,IF(AND(F11=\"System can NOT be engaged\",G11=\"Visual Warning within 5 minutes\"),10,IF(F11=\"System can NOT be engaged\",8,0))))","v":0}]
[null,null,"Sensor blocked with VUT in motion, System inactive"]
[null,null,"Camera","Full blockage",null,null,null,null,{"$f":"IF(OR(E13=\"\",AND(OR(E13=\"No\",E13=\"Unknown (no OEM data)\"),OR(F13=\"\",F13=\"System can be engaged\"),OR(G13=\"\",G13=\"No warning\"),OR(H13=\"\",H13=\"Fail\"))),0,IF(AND(OR(E13=\"No\",E13=\"Unknown (no OEM data)\"),H13=\"Pass\"),2.5,IF(AND(F13=\"System can NOT be engaged\",G13=\"Visual Warning within 5 minutes\"),2.5,IF(F13=\"System can NOT be engaged\",2,0))))","v":0}]
[null,null,null,"Partial blockage",null,null,null,null,{"$f":"IF(OR(E14=\"\",AND(OR(E14=\"No\",E14=\"Unknown (no OEM data)\"),OR(F14=\"\",F14=\"System can be engaged\"),OR(G14=\"\",G14=\"No warning\"),OR(H14=\"\",H14=\"Fail\"))),0,IF(AND(OR(E14=\"No\",E14=\"Unknown (no OEM data)\"),H14=\"Pass\"),2.5,IF(AND(F14=\"System can NOT be engaged\",G14=\"Visual Warning within 5 minutes\"),2.5,IF(F14=\"System can NOT be engaged\",2,0))))","v":0}]
[null,null,"Lidar","Full blockage",null,null,null,null,0]
[null,null,null,"Partial blockage",null,null,null,null,0]
[null,null,"Radar","Full blockage",null,null,null,null,{"$f":"IF(OR(E17=\"\",AND(OR(E17=\"No\",E17=\"Unknown (no OEM data)\"),OR(F17=\"\",F17=\"System can be engaged\"),OR(G17=\"\",G17=\"No warning\"),OR(H17=\"\",H17=\"Fail\"))),0,IF(AND(OR(E17=\"No\",E17=\"Unknown (no OEM data)\"),H17=\"Pass\"),5,IF(AND(F17=\"System can NOT be engaged\",G17=\"Visual Warning within 5 minutes\"),5,IF(F17=\"System can NOT be engaged\",4,0))))","v":0}]
[null,null,"Sensor blocked with VUT in motion, System active"]
[null,null,"Camera","Full blockage",null,null,null,null,{"$f":"IF(OR(E19=\"\",AND(OR(E19=\"No\",E19=\"Unknown (no OEM data)\"),OR(F19=\"\",F19=\"System stays active\"),OR(G19=\"\",G19=\"No warning\"),OR(H19=\"\",H19=\"Fail\"))),0,IF(AND(OR(E19=\"No\",E19=\"Unknown (no OEM data)\"),H19=\"Pass\"),5,IF(AND(F19=\"System cancels\",G19=\"Visual Warning within 5 minutes\"),5,IF(F19=\"System cancels\",4,0))))","v":0}]
[null,null,null,"Partial blockage",null,null,null,null,{"$f":"IF(OR(E20=\"\",AND(OR(E20=\"No\",E20=\"Unknown (no OEM data)\"),OR(F20=\"\",F20=\"System stays active\"),OR(G20=\"\",G20=\"No warning\"),OR(H20=\"\",H20=\"Fail\"))),0,IF(AND(OR(E20=\"No\",E20=\"Unknown (no OEM data)\"),H20=\"Pass\"),5,IF(AND(F20=\"System cancels\",G20=\"Visual Warning within 5 minutes\"),5,IF(F20=\"System cancels\",4,0))))","v":0}]
[null,null,"Lidar","Full blockage",null,null,null,null,0]
[null,null,null,"Partial blockage",null,null,null,null,0]
[null,null,"Radar","Full blockage",null,null,null,null,{"$f":"IF(OR(E23=\"\",AND(OR(E23=\"No\",E23=\"Unknown (no OEM data)\"),OR(F23=\"\",F23=\"System stays active\"),OR(G23=\"\",G23=\"No warning\"),OR(H23=\"\",H23=\"Fail\"))),0,IF(AND(OR(E23=\"No\",E23=\"Unknown (no OEM data)\"),H23=\"Pass\"),10,IF(AND(F23=\"System cancels\",G23=\"Visual Warning within 5 minutes\"),10,IF(F23=\"System cancels\",8,0))))","v":0}]
[]
[]
[null,"System Failure assessment",null,null,null,{"$f":"IF(COUNTIF(F7:F23,\"\")>14,0,SUM((SUM(I7:I10,I13:I16,I19:I22)*2),I11,I17,I23)/((17-COUNTIF(F7:F23,\"\"))/3))","v":0}]
[]
[null,"SUMMARY"]
[null,null,"System Failure assessment",null,null,{"$f":"F26","v":0}]
[null,"TOTAL SCORE",null,null,null,{"$f":"F29","v":0}]
[]
[null,"TOTAL SYSTEM FAILURE",null,null,null,{"$f":"F30","v":0}]

{"sheet":"SB Unresponsive Driver","index":11,"n_rows":20,"n_cols":4,"rows_kept":20,"cut":false,"hidden":false,"merged":[[17,3,17,4],[12,3,12,4],[16,3,16,4],[17,1,17,2],[19,1,19,2],[19,3,19,4],[1,1,3,2],[7,1,7,2],[7,3,7,4],[14,1,14,2],[15,3,15,4],[9,3,9,4],[10,3,10,4],[12,1,12,2],[1,3,2,4],[4,3,4,4],[5,3,5,4],[14,3,14,4]]}
[3]
[null,"Unresponsive Driver Intervention"]
[]
[]
[null,"UNRESPONSIVE DRIVER INTERVENTION"]
[null,null,"VUT maintains steering control"]
[]
[null,"Unresponsive Driver Intervention assessment",null,{"$f":"IF(D6=\"Yes\",20,0)","v":0}]
[]
[null,"Advanced Response for Incapacitated Driver"]
[null,null,"Target Stop Area","No"]
[]
[null,"Unresponsive Driver Intervention assessment",null,{"$f":"IF(AND(D6=\"Yes\",D11=\"Involving lane change in direction towards slowest lane (1 lane)\"),3,IF(AND(D6=\"Yes\",D11=\"Involving lane change to the slowest lane (up to 2 lanes)\"),4,IF(AND(D6=\"Yes\",D11=\"Involving lane change to emergency lane lane (or breakdown spot)\"),5,0)))","v":0}]
[]
[null,"SUMMARY"]
[null,null,"Unresponsive Driver Intervention assessment",{"$f":"D8","v":0}]
[null,null,"Advanced Response for Incapacitated Driver assessment",{"$f":"D13","v":0}]
[null,"TOTAL SCORE",null,{"$f":"SUM(D16:E17)","v":0}]
[]
[null,"TOTAL UNRESPONSIVE DRIVER INTERVENTION",null,{"$f":"D18","v":0}]

{"sheet":"SB Collision Avoidance","index":12,"n_rows":140,"n_cols":18,"rows_kept":140,"cut":false,"hidden":false,"merged":[[126,1,126,4],[126,5,126,10],[127,1,127,10],[130,5,130,7],[130,8,130,10],[101,7,101,8],[86,9,86,10],[86,5,86,8],[89,5,89,8],[88,5,88,8],[87,5,87,8],[92,9,92,10],[93,5,93,8],[93,9,93,10],[94,5,94,8],[94,9,94,10],[90,5,90,8],[99,9,99,10],[104,5,104,10],[107,2,107,4],[98,1,99,4],[101,9,101,10],[102,9,102,10],[103,9,103,10],[125,2,125,4],[125,5,125,10],[43,1,43,4],[43,5,43,10],[79,1,79,10],[80,1,80,4],[80,5,80,10],[85,2,89,2],[90,2,94,2],[82,9,82,10],[83,9,83,10],[82,5,83,8],[84,5,84,8],[84,9,84,10],[102,7,102,8],[103,7,103,8],[88,9,88,10],[87,9,87,10],[91,5,91,8],[91,9,91,10],[92,5,92,8],[136,5,136,7],[136,8,136,10],[134,8,134,10],[131,5,131,7],[132,5,132,7],[133,5,133,7],[131,8,133,10],[85,5,85,8],[89,9,89,10],[124,5,124,10],[1,16,2,23],[9,16,9,19],[46,1,78,1],[85,1,89,1],[90,1,94,1],[85,9,85,10],[90,9,90,10],[69,5,69,6],[69,7,69,8],[69,9,69,10],[74,5,74,6],[74,7,74,8],[74,9,74,10],[46,5,46,6],[46,7,46,8],[46,9,46,10],[67,5,67,6],[67,7,67,8],[67,9,67,10],[4,9,4,10],[46,16,46,19],[49,17,49,19],[85,16,85,19],[45,1,45,4],[99,16,99,23],[1,1,2,4],[106,5,106,10],[107,5,107,10],[1,5,1,6],[1,7,1,8],[1,9,1,10],[2,5,2,6],[2,7,2,8],[2,9,2,10],[3,1,3,4],[3,5,3,6],[3,7,3,8],[3,9,3,10],[4,2,4,4],[4,5,4,6],[96,1,96,4],[8,1,8,4],[9,1,41,1],[9,5,9,6],[9,7,9,8],[32,5,32,6],[32,7,32,8],[103,5,103,6],[5,2,5,4],[5,5,5,6],[5,7,5,8],[5,9,5,10],[4,7,4,8],[9,9,9,10],[17,5,17,6],[17,7,17,8],[17,9,17,10],[84,1,84,4],[42,1,42,10],[106,2,106,3],[108,5,108,10],[109,5,109,10],[110,5,110,10],[30,5,30,6],[30,7,30,8],[30,9,30,10],[32,9,32,10],[37,5,37,6],[37,7,37,8],[37,9,37,10],[105,1,105,10],[98,5,98,6],[98,7,98,8],[98,9,98,10],[100,5,100,6],[100,7,100,8],[100,9,100,10],[96,5,96,10],[95,1,95,10],[99,5,99,6],[99,7,99,8],[139,1,139,4],[137,5,137,10],[138,5,138,10],[139,5,139,10],[112,2,112,4],[113,2,113,4],[114,2,114,4],[115,1,115,4],[115,5,115,10],[128,5,128,10],[116,1,116,10],[130,1,130,4],[131,2,131,4],[134,2,134,4],[122,2,122,4],[122,5,122,10],[123,2,123,4],[123,5,123,10],[124,2,124,4],[135,2,135,4],[136,2,136,4],[134,5,134,7],[135,5,135,7],[135,8,135,10],[101,5,101,6],[102,5,102,6],[137,1,137,4],[114,5,114,10],[112,5,112,10],[113,5,113,10],[128,1,128,4],[111,5,111,10],[108,2,108,4],[109,2,109,4],[110,2,110,4],[111,2,111,4],[132,2,132,4],[133,2,133,4],[117,2,117,3],[117,5,117,10],[118,2,118,4],[118,5,118,10],[119,2,119,4],[119,5,119,10],[120,2,120,4],[120,5,120,10],[121,2,121,4],[121,5,121,10]]}
[3]
[null,"Collision Avoidance",null,null,null,"AD",null,"AEB",null,"FCW",null,null,null,null,null,null,"How to fill in the Matrix"]
[null,null,null,null,null,null,null,null,null,"[s]"]
[null,"SYSTEM DETAILS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Only fill in the Grey cells (additional grey cells appear based on AD input)"]
[null,null,"Speed range (km/h) - Minimum",null,null,null,null,null,null,null,null,null,null,null,null,null,"1. Start with AD performance"]
[null,null,"Maximum",null,null,null,null,null,null,null,null,null,null,null,null,null,"2. In case AD performance is mitigation fill in AEB performance (with AD engaged)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3. In case AEB performance is mitigation, fill in FCW warning time"]
[]
[null,"Longitudinal Control",null,null,null,"Straight 100%","Curve 100%","Straight 100%","Curve 100%","Straight 100%","Curve 100%"]
[null,"Car-to-Car","CCRs - Stationary target","VUT","Target",null,null,null,null,null,null,null,null,null,null,null,"Legend Car-to-car"]
[null,null,null,70,"-",null,null,null,null,null,null,{"$f":"IF(AND(F11=\"\",G11=\"\",H11=\"\",I11=\"\",J11=\"\",K11),\"\",IF(M11=\"\",\"\",M11&CHAR(10))&IF(N11=\"\",\"\",N11&CHAR(10))&IF(O11=\"\",\"\",O11&CHAR(10))&IF(P11=\"\",\"\",P11))","v":""},{"$f":"IF(NOT(OR(H11=\"Grey\",F11=\"Grey\")),\"ERROR! Enter Result for AD or AEB, not both\",\"\")","v":"ERROR! Enter Result for AD or AEB, not both"},{"$f":"IF(NOT(OR(I11=\"Grey\",G11=\"Grey\")),\"ERROR! Enter Result for AD curve or AEB curve, not both\",\"\")","v":"ERROR! Enter Result for AD curve or AEB curve, not both"},{"$f":"IF(AND(OR(F11=\"Green\",H11=\"Green\"),J11<>\"\"),\"ERROR!, no additional 0.25 points if collision avoided\",\"\")","v":""},{"$f":"IF(AND(OR(G11=\"Green\",I11=\"Green\"),K11<>\"\"),\"ERROR!, no additional 0.25 points if collision avoided in a curve\",\"\")","v":""},"Green","Avoidance"]
[null,null,null,80,"-",null,null,null,null,null,null,{"$f":"IF(AND(F12=\"\",G12=\"\",H12=\"\",I12=\"\",J12=\"\",K12),\"\",IF(M12=\"\",\"\",M12&CHAR(10))&IF(N12=\"\",\"\",N12&CHAR(10))&IF(O12=\"\",\"\",O12&CHAR(10))&IF(P12=\"\",\"\",P12))","v":""},{"$f":"IF(NOT(OR(H12=\"Grey\",F12=\"Grey\")),\"ERROR! Enter Result for AD or AEB, not both\",\"\")","v":"ERROR! Enter Result for AD or AEB, not both"},{"$f":"IF(NOT(OR(I12=\"Grey\",G12=\"Grey\")),\"ERROR! Enter Result for AD curve or AEB curve, not both\",\"\")","v":"ERROR! Enter Result for AD curve or AEB curve, not both"},{"$f":"IF(AND(OR(F12=\"Green\",H12=\"Green\"),J12<>\"\"),\"ERROR!, no additional 0.25 points if collision avoided\",\"\")","v":""},{"$f":"IF(AND(OR(G12=\"Green\",I12=\"Green\"),K12<>\"\"),\"ERROR!, no additional 0.25 points if collision avoided in a curve\",\"\")","v":""},"Orange","Mitigation: Impact speed reduction >5 km/h"]
[null,null,null,90,"-",null,null,null,null,null,null,"","ERROR! Enter Result for AD or AEB, not both","ERROR! Enter Result for AD curve or AEB curve, not both","","","Grey","No response"]
[null,null,null,100,"-",null,null,null,null,null,null,"","ERROR! Enter Result for AD or AEB, not both","ERROR! Enter Result for AD curve or AEB curve, not both","",""]
[null,null,null,110,"-",null,null,null,null,null,null,"","ERROR! Enter Result for AD or AEB, not both","ERROR! Enter Result for AD curve or AEB curve, not both","",""]
[null,null,null,120,"-",null,null,null,null,null,null,"","ERROR! Enter Result for AD or AEB, not both","ERROR! Enter Result for AD curve or AEB curve, not both","",""]
[null,null,null,130,"-",null,null,null,null,null,null,"","ERROR! Enter Result for AD or AEB, not both","ERROR! Enter Result for AD curve or AEB curve, not both","",""]
[null,null,"CCRm - Moving target"]
[null,null,null,80,20]
[null,null,null,90,20]
[null,null,null,100,20]
[null,null,null,110,20]
[null,null,null,120,20]
[null,null,null,130,20]
[null,null,null,80,60]
[null,null,null,90,60]
[null,null,null,100,60]
[null,null,null,110,60]
[null,null,null,120,60]
[null,null,null,130,60]
[null,null,"CCRb - Braking target @ -4 m/s2"]
[null,null,"ACC-mode closest",55,50]
[null,null,"Cut-in"]
[null,null,"Cut-in @ TTC =  0.00",50,10]
[null,null,"Cut-in @ TTC = -1.50",50,10]
[null,null,"Cut-in @ TTC =  1.50",120,70]
[null,null,"Cut-in @ TTC =  0.50",120,70]
[null,null,"Cut-out"]
[null,null,"Cut-out @ TTC =  3.00",70,50]
[null,null,"Cut-out @ TTC =  2.00",70,50]
[null,null,"Cut-out @ TTC =  3.00",90,70]
[null,null,"Cut-out @ TTC =  2.00",90,70]
[]
[null,"Longitudinal Control Car-to-Car assessment",null,null,null,{"$f":"COUNTIF(F11:I42,\"Green\")*1+COUNTIF(H11:I42,\"Orange\")*0.5+COUNTIF(J11:K42,\">\"&1.5)*0.25","v":0}]
[]
[null,"Longitudinal Control Car-to-Motorcyclist ",null,null,null,"Straight 100%","Curve 100%","Straight 100%","Curve 100%","Straight 100%","Curve 100%"]
[null,"Car-to-Motorcyclist ","CMRs - Stationary target, GVT in front","VUT","Target",null,null,null,null,null,null,null,null,null,null,null,"Legend Car-to-motorcyclist"]
[null,null,null,70,"-",null,null,null,null,null,null,null,null,null,null,null,"Green","Avoidance"]
[null,null,null,80,"-",null,null,null,null,null,null,null,null,null,null,null,"Orange","Mitigation: Impact speed reduction >30 km/h"]
[null,null,null,90,"-",null,null,null,null,null,null,null,null,null,null,null,"Grey","No response"]
[null,null,"CMRs - Stationary target, GVT on side"]
[null,null,null,70,"-"]
[null,null,null,80,"-"]
[null,null,null,90,"-"]
[null,null,"CMRs - Stationary target, curved road"]
[null,null,null,70,"-",null,null,null,null,null,null,{"$f":"IF(AND(F56=\"\",G56=\"\",H56=\"\",I56=\"\",J56=\"\",K56),\"\",IF(M56=\"\",\"\",M56&CHAR(10))&IF(N56=\"\",\"\",N56&CHAR(10))&IF(O56=\"\",\"\",O56&CHAR(10))&IF(P56=\"\",\"\",P56))","v":""},{"$f":"IF(NOT(OR(H56=\"Grey\",F56=\"Grey\")),\"ERROR! Enter Result for AD or AEB, not both\",\"\")","v":"ERROR! Enter Result for AD or AEB, not both"},{"$f":"IF(NOT(OR(I56=\"Grey\",G56=\"Grey\")),\"ERROR! Enter Result for AD curve or AEB curve, not both\",\"\")","v":"ERROR! Enter Result for AD curve or AEB curve, not both"},{"$f":"IF(AND(OR(F56=\"Green\",H56=\"Green\"),J56<>\"\"),\"ERROR!, no additional 0.25 points if collision avoided\",\"\")","v":""},{"$f":"IF(AND(OR(G56=\"Green\",I56=\"Green\"),K56<>\"\"),\"ERROR!, no additional 0.25 points if collision avoided in a curve\",\"\")","v":""}]
[null,null,null,80,"-",null,null,null,null,null,null,{"$f":"IF(AND(F57=\"\",G57=\"\",H57=\"\",I57=\"\",J57=\"\",K57),\"\",IF(M57=\"\",\"\",M57&CHAR(10))&IF(N57=\"\",\"\",N57&CHAR(10))&IF(O57=\"\",\"\",O57&CHAR(10))&IF(P57=\"\",\"\",P57))","v":""},{"$f":"IF(NOT(OR(H57=\"Grey\",F57=\"Grey\")),\"ERROR! Enter Result for AD or AEB, not both\",\"\")","v":"ERROR! Enter Result for AD or AEB, not both"},{"$f":"IF(NOT(OR(I57=\"Grey\",G57=\"Grey\")),\"ERROR! Enter Result for AD curve or AEB curve, not both\",\"\")","v":"ERROR! Enter Result for AD curve or AEB curve, not both"},{"$f":"IF(AND(OR(F57=\"Green\",H57=\"Green\"),J57<>\"\"),\"ERROR!, no additional 0.25 points if collision avoided\",\"\")","v":""},{"$f":"IF(AND(OR(G57=\"Green\",I57=\"Green\"),K57<>\"\"),\"ERROR!, no additional 0.25 points if collision avoided in a curve\",\"\")","v":""}]
[null,null,null,90,"-",null,null,null,null,null,null,"","ERROR! Enter Result for AD or AEB, not both","ERROR! Enter Result for AD curve or AEB curve, not both","",""]
[null,null,"CMRm - Moving Target"]
[null,null,null,100,20]
[null,null,null,110,20]
[null,null,null,120,20]
[null,null,null,130,20]
[null,null,null,100,60]
[null,null,null,110,60]
[null,null,null,120,60]
[null,null,null,130,60]
[null,null,"CMRb - Braking target @ -4 m/s2"]
[null,null,"ACC-mode closest",55,50]
[null,null,"Cut-in"]
[null,null,"Cut-in @ TTC =  0.50",50,10]
[null,null,"Cut-in @ TTC = -1.00",50,10]
[null,null,"Cut-in @ TTC =  1.50",120,70]
[null,null,"Cut-in @ TTC =  0.75",120,70]
[null,null,"Cut-out"]
[null,null,"Cut-out @ TTC =  3.00",70,50]
[null,null,"Cut-out @ TTC =  2.00",70,50]
[null,null,"Cut-out @ TTC =  3.00",90,70]
[null,null,"Cut-out @ TTC =  2.00",90,70]
[]
[null,"Longitudinal Control Car-to-Motorcyclist assessment",null,null,null,{"$f":"COUNTIF(F48:I79,\"Green\")*1+COUNTIF(H48:I79,\"Orange\")*0.5+COUNTIF(J48:K79,\">\"&1.5)*0.25","v":0}]
[]
[null,null,null,null,null,"AD / AEB",null,null,null,"FCW"]
[null,null,null,null,null,null,null,null,null,"[s]"]
[null,"Longitudinal Control Car-to-Bicyclist & Car-to-Pedestrian ",null,null,null,"Straight 0%",null,null,null,"Straight 0%"]
[null,"Car-to-Bicyclist","CBLA 0%","VUT","Target",null,null,null,null,null,null,null,null,null,null,null,"Legend Car-to-Bicyclist & Car-to-Pedestrian"]
[null,null,null,60,20,null,null,null,null,null,null,null,null,null,null,null,"Green","Avoidance"]
[null,null,null,70,20,null,null,null,null,null,null,null,null,null,null,null,"Grey","Impact"]
[null,null,null,80,20]
[null,null,null,90,20]
[null,"Car-to-Pedestrian","CPLA 0%","VUT","Target"]
[null,null,null,60,5]
[null,null,null,70,5]
[null,null,null,80,5]
[null,null,null,90,5]
[]
[null,"Longitudinal Control Car-to-Bicyclist & Car-to-Pedestrian",null,null,null,{"$f":"COUNTIF(F87:I95,\"Green\")*1+COUNTIF(J87:K95,\">\"&1.5)*0.25","v":0}]
[]
[null,"Lateral Control",null,null,null,"AD",null,"LKA",null,"LDW"]
[null,null,null,null,null,null,null,null,null,"[m]",null,null,null,null,null,null,"How to fill in the Matrix"]
[null,null,"S-Bend","VUT",null,null,null,null,null,null,null,null,null,null,null,null,"Only fill in the Grey cells (additional grey cells appear based on AD input)"]
[null,null,null,80,null,null,null,null,null,null,null,null,null,null,null,null,"1. Start with AD performance"]
[null,null,null,100,null,null,null,null,null,null,null,null,null,null,null,null,"2. In case AD performance is not keeping the vehicle in lane, fill in LKA performance (with AD engaged)"]
[null,null,null,120,null,null,null,null,null,null,null,null,null,null,null,null,"3. In case LKA performance is not meeting the LKA requirements, fill in LDW warning distance"]
[null,null,null,null,null,{"$f":"COUNTIF(F102:I104,\"Green\")*5+COUNTIF(J102:K104,\"<\"&0.3)*2.5","v":0}]
[]
[null,null,"Lane change with overtake (Car-to-Car)",null,"Target","Intentional"]
[null,null,"Overtaking vehicle (VUT Speed 72 km/h & GVT @ 72 km/h)"]
[null,null,0.5]
[null,null,0.6]
[null,null,0.7]
[null,null,"Overtaking vehicle (VUT Speed 72 km/h & GVT @ 80 km/h)"]
[null,null,0.5]
[null,null,0.6]
[null,null,0.7]
[null,"ELK Overtaking Car-to-Car assessment",null,null,null,{"$f":"IF(COUNTIF(F109:K115,\"PASS\")=6,5,0)","v":0}]
[]
[null,null,"Lane change with overtake (Car-to-Motorcyclist)",null,"Target","Intentional"]
[null,null,"Overtaking vehicle (VUT Speed 50 km/h & EMT @ 60 km/h)"]
[null,null,0.5]
[null,null,0.6]
[null,null,0.7]
[null,null,"Overtaking vehicle (VUT Speed 72 km/h & EMT @ 80 km/h)"]
[null,null,0.5]
[null,null,0.6]
[null,null,0.7]
[null,"ELK Overtaking Car-to-Motorcyclist assessment",null,null,null,{"$f":"IF(COUNTIF(F120:K126,\"PASS\")=6,5,0)","v":0}]
[]
[null,"Lateral Control assessment",null,null,null,{"$f":"SUM(F105,F116)","v":0}]
[]
[null,"SUMMARY",null,null,null,"Sub-total",null,null,"Total"]
[null,null,"Longitudinal Control Car-to-Car score",null,null,{"$f":"F44","v":0},null,null,{"$f":"SUM(F132:H134)*25/69","v":0}]
[null,null,"Longitudinal Control Car-to-Motorcyclist score",null,null,{"$f":"F81","v":0}]
[null,null,"Longitudinal Control Car-to-Bicyclist & Car-to-Pedestrian score",null,null,{"$f":"F97","v":0}]
[null,null,"Lateral Control S-Bend score",null,null,null,null,null,{"$f":"F105","v":0}]
[null,null,"Lateral Control ELK Overtaking Car-to-Car score",null,null,null,null,null,{"$f":"F116","v":0}]
[null,null,"Lateral Control ELK Overtaking Car-to-Motorcyclist score",null,null,null,null,null,{"$f":"F127","v":0}]
[null,"TOTAL SCORE",null,null,null,{"$f":"SUM(I132:K137)","v":0}]
[]
[null,"TOTAL Collision Avoidance",null,null,null,{"$f":"F138","v":0}]

{"sheet":"Website Summary","index":13,"n_rows":92,"n_cols":11,"rows_kept":92,"cut":false,"hidden":false,"merged":[]}
["Make Model",{"$f":"'AD GRADING'!C2","v":" "}]
["Grading",{"$f":"'AD GRADING'!G2","v":"NO GRADING"}]
["Assistance Competence %",{"$f":"'AD GRADING'!C14","v":0}]
["@AC Icon neg",{"$f":"IF('AD GRADING'!C13<('AD GRADING'!E13-10),\"VehicleIC\",IF('AD GRADING'!E13<50,\"DriverIC\",IF('AD GRADING'!C13>=('AD GRADING'!E13-10),\"Balanced\",\"\")))","v":"DriverIC"}]
["@AC Icon pos frame",{"$f":"IF('AD GRADING'!C13<('AD GRADING'!E13-10),\"VehicleIC\",IF('AD GRADING'!E13<50,\"DriverIC\",IF('AD GRADING'!C13>=('AD GRADING'!E13-10),\"Balanced\",\"\")))","v":"DriverIC"}]
["Safety Backup %",{"$f":"'AD GRADING'!G14","v":0}]
["System Name",{"$f":"'DE Consumer Information'!D6:E6","v":0},0]
["Version tested",{"$f":"'General Overview'!C6:E6","v":0},0,0]
["@Automatic Speed Limit Adaption",{"$f":"LOWER('VA Speed Assistance'!D47:F47)=\"system advised\"","v":false},false,false]
["@Speed Adjustment for Road Features",{"$f":"OR('VA Speed Assistance'!#REF!=\"yes\",'VA Speed Assistance'!#REF!=\"yes\",'VA Speed Assistance'!#REF!=\"yes\")","v":{"$error":"#REF!"}}]
["@Lane Change Assist",{"$f":"'VA Steering Assistance'!D14=\"yes\"","v":false}]
["Also available on"]
["Comment General",{"$f":"'AD GRADING'!B18:H18","v":"Enter comments here"},0,0,0,0,0,0]
["Driver Engagement Pts",{"$f":"'AD GRADING'!C13:D13","v":0},0]
["Consumer Information Pts",{"$f":"'DE Consumer Information'!D35:E35","v":0},0]
["Consumer Information Colour",{"$f":"AD_Colour(B15,25)","v":"Red"}]
["Official name link to marketing material"]
["Marketing material hyperlink"]
["@Marketing material hyperlink",{"$f":"NOT(ISBLANK(B18))","v":false}]
["@Quick start guide",{"$f":"'DE Consumer Information'!D18=\"yes\"","v":false}]
["@Vehicle handbook",{"$f":"NOT(ISBLANK(B22))","v":false}]
["Vehicle handbook url"]
["Viewed date for marketing material & vehicle handbook",null,null,null,null,null,"24 September 2021"]
["System Status Pts",{"$f":"'AD GRADING'!D9","v":0}]
["System Status Colour",{"$f":"AD_Colour(B24,25)","v":"Red"}]
["Continuous system status indicator",{"$f":"AD_Colour('DE System Status'!D51,18)","v":"Red"}]
["System Status Change Indicator",{"$f":"AD_Colour('DE System Status'!D52,7)","v":"Red"}]
["Driver monitoring Pts",{"$f":"'AD GRADING'!D10","v":0},null,null,null,"Add colour for Hands-On Monitoring (Cell G46) and Direct Driver Monitoring (G47)"]
["Driver monitoring Colour",{"$f":"AD_Colour(B28,25)","v":"Red"}]
["Driver Collaboration Pts",{"$f":"'DE Driving Collaboration'!D25:E25","v":0},0]
["Driver Collaboration Colour",{"$f":"AD_Colour(B30,25)","v":"Red"}]
["@Steering to avoid an obstacle",{"$f":"'DE Driving Collaboration'!D16=\"system cancelled\"","v":false},null,null,null,"Add colour for Increase in Steering Torque (Cell D21) and Over-ride Response (D22)"]
["Steering to avoid an obstacle Caption",{"$f":"IF('DE Driving Collaboration'!D16=\"system cancelled\",\"System stops assistance  when driver steers to avoid obstacle\",IF('DE Driving Collaboration'!D16=\"\",\"ERROR!\",\"System continues to assist  while driver steers to avoid obstacle\"))","v":"ERROR!"},null,null,null,null,null,null,"changed cell to D16"]
["Vehicle Assistance Pts",{"$f":"'AD GRADING'!E13:F13","v":0},0]
["Speed Assistance Pts",{"$f":"'AD GRADING'!F8","v":0}]
["Speed Assistance Colour",{"$f":"AD_Colour(B35,25)","v":"Red"},null,null,null,"Need new fields for colours of Car - Motorcyclist tests",null,null,null,null,"Car to Stationary MC (merged straight, GVT in front and side and curve)"]
["Vehicle response to fixed speed limits",{"$f":"'VA Speed Assistance'!D63","v":0},null,null,null,null,null,null,null,null,"Car to Slower Moving MC"]
["Vehicle response to variable speed limits",{"$f":"'VA Speed Assistance'!D64","v":0},null,null,null,null,null,null,null,null,"Car to Braking MC"]
["@Road features - corners",{"$f":"'VA Speed Assistance'!#REF!=\"yes\"","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,"MC cutting in"]
["@Road features - roundabouts",{"$f":"'VA Speed Assistance'!#REF!=\"yes\"","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,"Car cutting out to expose stationary MC"]
["@Road features - junctions",{"$f":"'VA Speed Assistance'!#REF!=\"yes\"","v":{"$error":"#REF!"}}]
["ACC Performance Pts",{"$f":"'AD GRADING'!F9","v":0}]
["ACC Performance Colour",{"$f":"AD_Colour(B42,40)","v":"Red"}]
["Approaching stationary car in a curveCalc",{"$f":"(COUNTIF('VA ACC Performance'!H10:H16,\"Green\")*1+COUNTIF('VA ACC Performance'!H10:H16,\"Orange\")*0.5)/7","v":0}]
["@Approaching stationary car in a curve",{"$f":"AD_Colour(B44,1)","v":"Red"}]
["Approaching stationary carCalc",{"$f":"(COUNTIF('VA ACC Performance'!F10:F16,\"Green\")*1+(COUNTIF('VA ACC Performance'!F10:F16,\"Orange\")*0.5))/7","v":0}]
["@Approaching stationary car",{"$f":"AD_Colour(B46,1)","v":"Red"}]
["Approaching slower moving carCalc",{"$f":"(COUNTIF('VA ACC Performance'!F18:F29,\"Green\")*1+COUNTIF('VA ACC Performance'!F18:F29,\"Orange\")*0.5)/12","v":0}]
["@Approaching slower moving car",{"$f":"AD_Colour(B48,1)","v":"Red"}]
["Approaching braking carCalc",{"$f":"(COUNTIF('VA ACC Performance'!F31,\"Green\")*1+COUNTIF('VA ACC Performance'!F31,\"Orange\")*0.5)/1","v":0}]
["@Approaching braking car",{"$f":"AD_Colour(B50,1)","v":"Red"}]
["Car cutting-in in frontCalc",{"$f":"(COUNTIF('VA ACC Performance'!F33:F34,\"Green\")*1+COUNTIF('VA ACC Performance'!F33:F34,\"Orange\")*0.5)/2","v":0}]
["@Car cutting-in in front",{"$f":"AD_Colour(B52,1)","v":"Red"}]
["Car cutting-out in frontCalc",{"$f":"(COUNTIF('VA ACC Performance'!F36:F37,\"Green\")*1+COUNTIF('VA ACC Performance'!F36:F37,\"Orange\")*0.5)/2","v":0}]
["@Car cutting-out in front",{"$f":"AD_Colour(B54,1)","v":"Red"}]
["@UNDERTAKE PREVENTION",{"$f":"'VA ACC Performance'!F75=\"yes\"","v":false}]
["@Assistance maintained after coming to a full stop",{"$f":"'VA ACC Performance'!F80=\"yes\"","v":false}]
["System Assistance maintained by",{"$f":"_xlfn.IFS('VA ACC Performance'!F82=\"yes\",'VA ACC Performance'!B82,'VA ACC Performance'!F83=\"yes\",'VA ACC Performance'!B83,'VA ACC Performance'!F84=\"yes\",'VA ACC Performance'!B84,'VA ACC Performance'!F85=\"yes\",'VA ACC Performance'!B85,'VA ACC Performance'!F86=\"yes\",'VA ACC Performance'!B86)","v":{"$error":"#N/A"}}]
["Steering Assistance Pts",{"$f":"'AD GRADING'!F10","v":0}]
["Steering Assistance Colour",{"$f":"AD_Colour(B59,35)","v":"Red"}]
["@SteeringS-curve",{"$f":"'VA Steering Assistance'!D9","v":0}]
["SteeringS-curve80kmph",{"$f":"IF('VA Steering Assistance'!D7=\"vehicle stays in lane\",\"Green\",IF('VA Steering Assistance'!D7=\"vehicle directed in 2nd turn\",\"Yellow\",IF('VA Steering Assistance'!D7=\"vehicle directed in 1st turn\",\"Orange\",\"Red\")))","v":"Red"},null,"Add comment field (taken from cells D7 - D9)"]
["SteeringS-curve100kmph",{"$f":"IF('VA Steering Assistance'!D8=\"vehicle stays in lane\",\"Green\",IF('VA Steering Assistance'!D8=\"vehicle directed in 2nd turn\",\"Yellow\",IF('VA Steering Assistance'!D8=\"vehicle directed in 1st turn\",\"Orange\",\"Red\")))","v":"Red"}]
["SteeringS-curve120kmph",{"$f":"IF('VA Steering Assistance'!D9=\"vehicle stays in lane\",\"Green\",IF('VA Steering Assistance'!D9=\"vehicle directed in 2nd turn\",\"Yellow\",IF('VA Steering Assistance'!D9=\"vehicle directed in 1st turn\",\"Orange\",\"Red\")))","v":"Red"}]
["@Lane change assist fitted",{"$f":"'VA Steering Assistance'!D14=\"yes\"","v":false}]
["System Failure Pts",{"$f":"'SB System Failure'!F32:I32","v":0},0,0,0]
["System Failure Colour",{"$f":"AD_Colour(B66,25)","v":"Red"}]
["Start-up Camera Engagement",{"$f":"'SB System Failure'!F7&\" after a 5 minute drive\"","v":" after a 5 minute drive"}]
["Start-up Camera Warning",{"$f":"'SB System Failure'!G7&\" after sensor blocking\"","v":" after sensor blocking"}]
["Start-up Radar Engagement",{"$f":"'SB System Failure'!F11&\" after a 5 minute drive\"","v":" after a 5 minute drive"}]
["Start-up Radar Warning",{"$f":"'SB System Failure'!G11&\" after sensor blocking\"","v":" after sensor blocking"}]
["MotionInactive Camera Engagement",{"$f":"'SB System Failure'!F17&\" after a 5 minute drive\"","v":" after a 5 minute drive"}]
["MotionInactive Camera Warning",{"$f":"'SB System Failure'!G17&\" after sensor blocking\"","v":" after sensor blocking"}]
["MotionInactive Radar Engagement",{"$f":"'SB System Failure'!F18&\" after a 5 minute drive\"","v":" after a 5 minute drive"}]
["MotionInactive Radar Warning",{"$f":"'SB System Failure'!G18&\" after sensor blocking\"","v":" after sensor blocking"}]
["MotionActive Camera Engagement",{"$f":"'SB System Failure'!F24&\" within 2 minutes after blocking\"","v":" within 2 minutes after blocking"}]
["MotionActive Camera Warning",{"$f":"'SB System Failure'!G24&\" after sensor blocking\"","v":" after sensor blocking"}]
["MotionActive Radar Engagement",{"$f":"'SB System Failure'!F25&\" after sensor blocking\"","v":" after sensor blocking"}]
["MotionActive Radar Warning",{"$f":"'SB System Failure'!G25&\" after sensor blocking\"","v":" after sensor blocking"}]
["Unresponsive Driver Intervention Pts",{"$f":"'AD GRADING'!H9","v":0}]
["Unresponsive Driver Intervention Colour",{"$f":"AD_Colour(B80,25)","v":"Red"}]
["Emergency assist steering control",{"$f":"IF('SB Unresponsive Driver'!D6=\"yes\",\"Green\",\"Red\")","v":"Red"}]
["@Emergency assist steering control",{"$f":"'SB Unresponsive Driver'!D6=\"yes\"","v":false}]
["Collision Avoidance Pts",{"$f":"'SB Collision Avoidance'!F140:K140","v":0},0,0,0,0,0]
["Collision Avoidance Colour",{"$f":"AD_Colour(B84,50)","v":"Red"}]
["@SB Approaching stationary car in a curve",{"$f":"AD_Colour(((COUNTIF('SB Collision Avoidance'!G11:G17,\"Green\")+COUNTIF('SB Collision Avoidance'!I11:I17,\"Green\"))*1+COUNTIF('SB Collision Avoidance'!I11:I17,\"Orange\")*0.5+COUNTIF('SB Collision Avoidance'!K11:K17,\">1.5\")*0.25)/7,1)","v":"Red"}]
["@SB Approaching stationary car",{"$f":"AD_Colour(((COUNTIF('SB Collision Avoidance'!F11:F17,\"Green\")+COUNTIF('SB Collision Avoidance'!H11:H17,\"Green\"))*1+COUNTIF('SB Collision Avoidance'!H11:H17,\"Orange\")*0.5+COUNTIF('SB Collision Avoidance'!J11:J17,\">1.5\")*0.25)/7,1)","v":"Red"}]
["@SB Approaching slower moving car",{"$f":"AD_Colour(((COUNTIF('SB Collision Avoidance'!F19:F30,\"Green\")+COUNTIF('SB Collision Avoidance'!H19:H30,\"Green\"))*1+COUNTIF('SB Collision Avoidance'!H19:H30,\"Orange\")*0.5+COUNTIF('SB Collision Avoidance'!J19:J30,\">1.5\")*0.25)/12,1)","v":"Red"}]
["@SB Approaching braking car",{"$f":"AD_Colour(((COUNTIF('SB Collision Avoidance'!F32,\"Green\")+COUNTIF('SB Collision Avoidance'!H32,\"Green\"))*1+COUNTIF('SB Collision Avoidance'!H32,\"Orange\")*0.5+COUNTIF('SB Collision Avoidance'!J32,\">1.5\")*0.25)/1,1)","v":"Red"}]
["@SB Car cutting-in in front",{"$f":"AD_Colour(((COUNTIF('SB Collision Avoidance'!F34:F37,\"Green\")+COUNTIF('SB Collision Avoidance'!H34:H38,\"Green\"))*1+COUNTIF('SB Collision Avoidance'!H34:H38,\"Orange\")*0.5+COUNTIF('SB Collision Avoidance'!J34:J38,\">1.5\")*0.25)/4,1)","v":"Red"}]
["@SB Car cutting-out in front",{"$f":"AD_Colour(((COUNTIF('SB Collision Avoidance'!F39:F42,\"Green\")+COUNTIF('SB Collision Avoidance'!H39:H96,\"Green\"))*1+COUNTIF('SB Collision Avoidance'!H39:H96,\"Orange\")*0.5+COUNTIF('SB Collision Avoidance'!J39:J96,\">1.5\")*0.25)/4,1)","v":"Brown"}]
["Campaign year",{"$f":"'General Overview'!G2","v":2024}]