{"text_format":"1","workbook":"xlsx","n_sheets":13,"sheets":["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":"General Overview","index":0,"n_rows":97,"n_cols":20,"rows_kept":97,"cut":false,"hidden":false,"merged":[[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],[89,1,89,2],[89,3,89,4],[91,1,91,2],[91,3,91,4],[92,1,92,2],[92,3,92,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],[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],[76,1,76,2],[76,3,76,4],[77,1,77,2],[77,3,77,4],[78,1,78,2],[78,3,78,4],[73,1,73,2],[73,3,73,4],[74,1,74,2],[74,3,74,4],[75,3,75,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],[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],[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],[56,2,56,3],[24,2,24,3],[25,2,25,3],[26,2,26,3],[54,2,54,3]]}
[]
[3,"VEHICLE SPECIFICATION",null,null,null,"YEAR OF TEST",2021,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":1,"n_rows":18,"n_cols":10,"rows_kept":18,"cut":false,"hidden":false,"merged":[[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],[6,4,6,5],[17,1,17,7],[5,2,5,5],[5,6,5,7],[14,2,14,7]]}
[]
[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'!D34","v":0},"Speed Assistance",{"$f":"'VA Speed Assistance'!D58","v":0},"System Failure",{"$f":"'SB System Failure'!D23","v":0}]
[null,null,"System Status",{"$f":"'DE System Status'!D57","v":0},"ACC Performance",{"$f":"'VA ACC Performance'!F63","v":0},"Unresponsive Driver Intervention",{"$f":"'SB Unresponsive Driver'!D14","v":0}]
[null,null,"Driver Monitoring",{"$f":"'DE Driver Monitoring'!D16","v":0},"Steering Assistance",{"$f":"'VA Steering Assistance'!D23","v":0},"Collision Avoidance",{"$f":"'SB Collision Avoidance'!F71","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":2,"n_rows":34,"n_cols":5,"rows_kept":34,"cut":false,"hidden":false,"merged":[[1,3,2,4],[5,3,5,4],[1,1,3,2],[19,3,19,4],[24,1,24,2],[24,3,24,4],[16,3,16,4],[9,1,9,2],[9,3,9,4],[11,3,11,4],[21,3,21,4],[4,3,4,4],[14,1,14,2],[14,3,14,4],[19,1,19,2],[33,1,33,2],[33,3,33,4],[26,1,26,2],[27,3,27,4],[28,3,28,4],[29,3,29,4],[30,3,30,4],[31,1,31,2],[31,3,31,4],[26,3,26,4]]}
[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\",5,0))","v":0}]
[]
[null,"Quick Start Guide assessment",null,{"$f":"E18","v":0}]
[]
[null,"VEHICLE HANDBOOK"]
[null,null,"Clear description of level of Assistance",null,{"$f":"IF(D23=\"\",0,IF(D23=\"Yes\",5,0))","v":0}]
[]
[null,"Vehicle Handbook assessment",null,{"$f":"E23","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":"D20","v":0}]
[null,null,"Vehicle Handbook",{"$f":"D25","v":0}]
[null,"TOTAL SCORE",null,{"$f":"SUM(D28:E31)","v":0}]
[]
[null,"TOTAL CONSUMER INFORMATION",null,{"$f":"D32","v":0}]

{"sheet":"DE System Status","index":3,"n_rows":57,"n_cols":8,"rows_kept":57,"cut":false,"hidden":false,"merged":[[27,5,28,5],[24,3,24,7],[27,6,28,6],[33,1,34,2],[42,1,42,2],[28,1,28,2],[27,3,28,3],[27,4,28,4],[27,7,28,7],[56,1,56,2],[51,1,51,2],[54,1,54,2],[32,1,32,2],[32,3,32,7],[37,1,37,2],[37,3,37,7],[33,3,34,3],[33,4,34,4],[33,5,34,5],[33,6,34,6],[33,7,34,7],[43,6,44,6],[38,6,39,6],[38,7,39,7],[48,3,48,7],[1,1,3,2],[25,3,25,7],[1,3,2,7],[3,3,3,7],[4,3,4,7],[5,3,5,7],[6,3,6,7],[25,1,25,2],[12,1,12,2],[12,3,12,7],[16,1,16,2],[16,3,16,7],[23,1,23,2],[23,3,23,7],[17,1,17,2],[13,1,13,2],[49,1,49,2],[49,3,49,7],[38,3,39,3],[38,4,39,4],[38,5,39,5],[42,3,42,7],[47,1,47,2],[38,1,39,2],[43,7,44,7],[47,3,47,7],[43,1,44,2],[43,3,44,3],[43,4,44,4],[43,5,44,5],[51,3,51,7],[52,3,52,7],[53,3,53,7],[54,3,54,7],[56,3,56,7]]}
[3]
[null,"System Status"]
[]
[]
[null,"PRECONDITIONS"]
[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",null,"Stand-by","Longitudinal only","Lateral only","Longitudinal & Lateral"]
[null,2.1,"Indicator for each system mode (default ON)"]
[null,null,"Additional status information"]
[null,null,"Additional indicator in driver's direct sight"]
[null,null,null,{"$f":"IF(COUNTIF(D10:G10,\"No\")>0,0,COUNTIF(D11:G11,\"Yes\")*0.5+COUNTIF(D12:G12,\"Yes\")*1.5)","v":0}]
[null,null,null,"Stand-by","Longitudinal only","Lateral only","Longitudinal & Lateral","Vehicle in lane ahead"]
[null,2.2000000000000002,"Indicator always ON"]
[null,null,"Distinguishable from other mode"]
[null,null,null,{"$f":"COUNTIF(D15:H15,\"Yes\")*0.5+COUNTIF(D16:H16,\"Yes\")*0.5","v":0}]
[null,null,null,"Stand-by","Longitudinal only","Lateral only","Longitudinal & Lateral"]
[null,2.2999999999999998,"Indicator in contrasting colour"]
[null,null,"Colours confirm to conventions"]
[null,null,"No red/green and blue/yellow colour combinations"]
[null,null,"Commonly accepted indicators"]
[null,null,"No flashing indicators for continuous system status"]
[null,null,null,{"$f":"COUNTIF(D19:D23,\"Yes\")*0.25+COUNTIF(E19:E23,\"Yes\")*0.25+COUNTIF(F19:F23,\"Yes\")*0.25+COUNTIF(G19:G23,\"Yes\")*0.25","v":0}]
[]
[null,"Continuous System Status Indicator assessment",null,{"$f":"SUM(D13,D17,D24)","v":0}]
[]
[null,"SYSTEM STATUS CHANGE INDICATOR",null,"Longitudinal & Lateral\n-> Longitudinal only"]
[]
[null,"3.1.1","Change in continuous status indicator"]
[null,null,"Audible or Haptic warning"]
[null,null,"Additional visual information"]
[null,null,null,{"$f":"IF(AND(D30=\"Yes\",D43=\"PASS\"),COUNTIF(D31:D32,\"Yes\")*2,0)","v":0}]
[null,null,null,"Longitudinal & Lateral\n-> Longitudinal only"]
[]
[null,"3.1.2","Additional visual information when “hands-off”"]
[null,null,"Information does not startle or annoy"]
[null,null,null,{"$f":"IF(D43=\"PASS\",COUNTIF(D36:D37,\"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,"3.2.1","System initiated change in status indicator"]
[null,"3.3.1","Driver initiated change in status indicator"]
[null,null,null,{"$f":"IF(COUNTIF(D41:H42,\"Yes\")+COUNTIF(D41:H42,\"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,"3.4.1","No change in status indicator"]
[null,null,"Additional visual information"]
[null,null,null,{"$f":"IF(COUNTIF(D46:H46,\"Yes\")+COUNTIF(D46:H46,\"N/A\")=5,COUNTIF(D47:H47,\"Yes\")*0.2,0)","v":0}]
[]
[null,"System Status Change Indicator assessment",null,{"$f":"SUM(D33,D38,D48)","v":0}]
[]
[null,"SUMMARY"]
[null,null,"Continuous System Status Indicator",{"$f":"D26/((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":"D50/((5-COUNTIF(D46:H46,\"N/A\"))*0.2+6)*7","v":0}]
[null,"TOTAL SCORE",null,{"$f":"SUM(D53:E54)","v":0}]
[]
[null,"TOTAL SYSTEM STATUS",null,{"$f":"D55","v":0}]

{"sheet":"DE Driver Monitoring","index":4,"n_rows":16,"n_cols":4,"rows_kept":16,"cut":false,"hidden":false,"merged":[[15,1,15,2],[15,3,15,4],[13,1,13,2],[13,3,13,4],[1,3,2,4],[1,1,3,2],[4,3,4,4],[9,3,9,4],[12,3,12,4],[9,1,9,2],[11,1,11,2],[11,3,11,4],[5,3,5,4],[6,3,6,4],[7,3,7,4]]}
[3]
[null,"Driver Monitoring"]
[]
[]
[null,"UNECE R79 REVISION 4"]
[null,null,"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,"UNECE R79 revision 4 assessment",null,{"$f":"IF(AND(D6=\"Yes\",D7=\"Yes\",D8=\"Yes\"),10,0)","v":0}]
[]
[null,"SUMMARY"]
[null,null,"UNECE R79 revision 4",{"$f":"D10","v":0}]
[null,"TOTAL SCORE",null,{"$f":"SUM(D13)","v":0}]
[]
[null,"TOTAL DRIVER MONITORING",null,{"$f":"D14","v":0}]

{"sheet":"DE Driving Collaboration","index":5,"n_rows":25,"n_cols":5,"rows_kept":25,"cut":false,"hidden":false,"merged":[[13,3,13,4],[17,1,17,2],[17,3,17,4],[14,3,14,4],[15,3,15,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],[1,3,2,4],[11,1,11,2],[1,1,3,2],[4,3,4,4],[11,3,11,4]]}
[3]
[null,"Driver Input Response"]
[]
[null,null,null,"System ON","System OFF"]
[null,"OVERRIDE 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,"Override 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,"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,"Override 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":6,"n_rows":58,"n_cols":5,"rows_kept":58,"cut":false,"hidden":false,"merged":[[1,3,2,4],[38,1,38,2],[38,3,38,4],[1,1,3,2],[26,3,26,4],[4,3,4,4],[5,3,5,4],[7,3,7,4],[24,1,24,2],[24,3,24,4],[40,1,40,2],[40,3,40,4],[45,3,45,4],[27,3,27,4],[28,3,28,4],[29,3,29,4],[54,3,54,4],[57,1,57,2],[57,3,57,4],[50,3,50,4],[52,1,52,2],[52,3,52,4],[55,1,55,2],[55,3,55,4],[53,3,53,4],[50,1,50,2]]}
[]
[null,"Speed Assistance"]
[]
[null,null,null,"Value","Score"]
[null,"SPEED LIMIT INFORMATION FUNCTION"]
[null,null,"Type of system"]
[null,null,"General requirements",null,{"$f":"IF(D7=\"Pass\",0.5,0)","v":0}]
[null,null,"Advanced Functions"]
[null,null,"Weather - Rain / Wetness",null,{"$f":"IF(D9=\"Pass\",0.05,0)","v":0}]
[null,null,"Weather - Snow / Icy",null,{"$f":"IF(D10=\"Pass\",0.05,0)","v":0}]
[null,null,"Time",null,{"$f":"IF(D11=\"Pass\",0.075,0)","v":0}]
[null,null,"Distance For / In",null,{"$f":"IF(D12=\"Pass\",0.025,0)","v":0}]
[null,null,"Arrows",null,{"$f":"IF(D13=\"Pass\",0.025,0)","v":0}]
[null,null,"Vehicle Categories",null,{"$f":"IF(D14=\"Pass\",0.025,0)","v":0}]
[null,null,"Implicit Speed Limits - Highway / Motorway",null,{"$f":"IF(D15=\"Pass\",0.05,0)","v":0}]
[null,null,"Implicit Speed Limits - City Entry / Exit",null,{"$f":"IF(D16=\"Pass\",0.075,0)","v":0}]
[null,null,"Implicit Speed Limits - Residential Zones",null,{"$f":"IF(D17=\"Pass\",0.05,0)","v":0}]
[null,null,"Dynamic Speed Limits",null,{"$f":"IF(D18=\"Pass\",0.075,0)","v":0}]
[null,null,"System Accuracy",null,{"$f":"IF(AND(SUM(E9:E18)>0.3,D20=\"PASS\"),0.25,0)","v":0}]
[null,null,"Map update",null,{"$f":"IF(D20=\"\",\"\",IF(D20<>\"Other\",\"Pass\",\"Fail\"))","v":""}]
[null,null,"Warning Function",null,{"$f":"IF(AND(E22=\"Pass\",E23=\"Pass\",E24=\"Pass\"),0.25,0)","v":0}]
[null,null,"Position of warning",null,{"$f":"IF(D22=\"\",\"\",IF(D22<>\"Other\",\"Pass\",\"Fail\"))","v":""}]
[null,null,"Type of warning",null,{"$f":"IF(D23=\"\",\"\",IF(D23<>\"Other\",\"Pass\",\"Fail\"))","v":""}]
[null,null,"Total duration ",null,{"$f":"IF(D24=\"\",\"\",IF(AND(D24<>\"\",D24>=10),\"Pass\",\"Fail\"))","v":""}]
[null,"Speed Limit Information Function score",null,{"$f":"SUM(E7:E21)","v":0}]
[]
[null,"SPEED CONTROL FUNCTION"]
[null,null,"Setting Vadj"]
[]
[null,null,"50 km/h test"]
[null,null,"Vstab",null,{"$f":"IF(AND(D31<>\"\",D31>=45),\"Pass\",\"Fail\")","v":"Fail"}]
[null,null,"difference between Vstab and Vadj",{"$f":"IF(D31=\"\",\"\",50-D31)","v":""}]
[null,null,"80 km/h test"]
[null,null,"Vstab",null,{"$f":"IF(AND(D34<>\"\",D34>=75),\"Pass\",\"Fail\")","v":"Fail"}]
[null,null,"difference between Vstab and Vadj",{"$f":"IF(D34=\"\",\"\",80-D34)","v":""}]
[null,null,"120 km/h test"]
[null,null,"Vstab",null,{"$f":"IF(AND(D37<>\"\",D37>=115),\"Pass\",\"Fail\")","v":"Fail"}]
[null,null,"difference between Vstab and Vadj",{"$f":"IF(D37=\"\",\"\",120-D37)","v":""}]
[null,"Speed Control Function score",null,{"$f":"IF(AND(D32<=5,D35<=5,D38<=5),IF(D28=\"System advised\",1.5,IF(D28=\"Manually set\",IF(D25>0,0.75,1.25),0)),0)","v":0}]
[]
[null,"SAS RATING SCORE",null,{"$f":"(D25+D39)","v":0}]
[]
[null,"ROAD FEATURES",null,"Value","Points"]
[null,null,"Reaction to fixed speed limit changes",null,{"$f":"IF(D44=\"At speed at sign\",6,IF(D44=\"Slowing down at sign\",4,IF(D44=\"Start slowing down after sign\",2,0)))","v":0}]
[null,null,"Reaction to variable and temporary speed limit changes",null,{"$f":"IF(D45=\"At speed at sign\",6,IF(D45=\"Slowing down at sign\",6,IF(D45=\"Start slowing down after sign\",3,0)))","v":0}]
[null,null,"Speed adaption to road features"]
[null,null,"Corners",null,{"$f":"IF(D47=\"Yes\",3,0)","v":0}]
[null,null,"Roundabouts",null,{"$f":"IF(D48=\"Yes\",2,0)","v":0}]
[null,null,"Junctions",null,{"$f":"IF(D49=\"Yes\",2,0)","v":0}]
[]
[null,"ACC features assessment",null,{"$f":"SUM(E44:E45,E47:E49)","v":0}]
[]
[null,"SUMMARY"]
[null,null,"SAS rating score",{"$f":"D41*2","v":0}]
[null,null,"Road features assessment",{"$f":"D51","v":0}]
[null,"TOTAL SCORE",null,{"$f":"SUM(D54:E55)","v":0}]
[]
[null,"TOTAL ACC PERFORMANCE ROAD",null,{"$f":"D56","v":0}]

{"sheet":"VA ACC Performance","index":7,"n_rows":63,"n_cols":9,"rows_kept":63,"cut":false,"hidden":false,"merged":[[62,1,62,4],[62,5,62,8],[1,1,2,4],[40,5,40,8],[41,5,41,8],[42,1,42,8],[43,5,43,8],[43,1,43,4],[41,2,41,4],[40,1,40,4],[56,1,56,4],[60,1,60,4],[57,2,57,4],[59,2,59,4],[56,5,56,8],[59,5,59,8],[60,5,60,8],[7,1,7,4],[8,1,36,1],[7,7,7,8],[38,1,38,4],[37,1,37,8],[38,5,38,8],[50,1,50,4],[51,1,51,4],[46,1,46,4],[47,1,47,4],[48,1,48,4],[49,1,49,4],[50,5,50,8],[51,5,51,8],[52,5,52,8],[1,5,1,8],[3,1,3,4],[3,5,3,8],[2,5,2,8],[4,2,4,4],[5,2,5,4],[5,5,5,8],[7,5,7,6],[4,5,4,8],[45,1,45,4],[45,5,45,8],[46,5,46,8],[47,5,47,8],[48,5,48,8],[49,5,49,8],[58,2,58,4],[58,5,58,8],[52,1,52,4],[53,1,53,4],[54,1,54,4],[57,5,57,8],[53,5,53,8],[54,5,54,8]]}
[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",null,null,null,"Straight road 100%",null,"Curved road 100%"]
[null,"Scenario","CCRs - Stationary target","VUT","Target","Assessment","Max deceleration [m/s²]","Assessment","Max deceleration [m/s²]"]
[null,null,null,70,"-"]
[null,null,null,80,"-"]
[null,null,null,90,"-"]
[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 Car-to-Car assessment",null,null,null,{"$f":"COUNTIF(F10:I37,\"Green\")*1+COUNTIF(F10:I37,\"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(F42=\"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(F47=\"Yes\",IF(OR(F49=\"Yes\",F50=\"Yes\",F51=\"Yes\"),10,IF(F52=\"Yes\",7,IF(F53=\"Yes\",3,0))),0)","v":0}]
[]
[null,"SUMMARY"]
[null,null,"Longitudinal Car-to-Car score",null,null,{"$f":"F39/31*25","v":0}]
[null,null,"Undertake Prevention score",null,null,{"$f":"F44","v":0}]
[null,null,"ACC Auto-Resume score",null,null,{"$f":"F55","v":0}]
[null,"TOTAL SCORE",null,null,null,{"$f":"SUM(F58:I60)","v":0}]
[]
[null,"TOTAL ACC PERFORMANCE VEHICLE",null,null,null,{"$f":"F61","v":0}]

{"sheet":"VA Steering Assistance","index":8,"n_rows":23,"n_cols":5,"rows_kept":23,"cut":false,"hidden":false,"merged":[[22,3,22,4],[20,3,20,4],[20,1,20,2],[22,1,22,2],[19,3,19,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],[18,3,18,4],[17,3,17,4],[10,1,10,2],[17,1,17,2],[10,3,10,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":9,"n_rows":23,"n_cols":6,"rows_kept":23,"cut":false,"hidden":false,"merged":[[22,1,22,2],[22,3,22,5],[1,3,2,5],[1,1,3,2],[16,3,16,5],[19,3,19,5],[20,3,20,5],[18,3,18,5],[16,1,16,2],[18,1,18,2],[20,1,20,2]]}
[3]
[null,"System Failure"]
[]
[]
[null,"SYSTEM FAILURE",null,"Engagement","Warning","Points"]
[null,null,"Sensor blocked at Start-up"]
[null,null,"Camera",null,null,{"$f":"IF(AND(D7=\"System can NOT be engaged\",E7=\"Visual Warning within 5 minutes\"),10,IF(D7=\"System can NOT be engaged\",8,0))","v":0}]
[null,null,"Radar",null,null,{"$f":"IF(AND(D8=\"System can NOT be engaged\",E8=\"Visual Warning within 5 minutes\"),10,IF(D8=\"System can NOT be engaged\",8,0))","v":0}]
[null,null,"Sensor blocked with VUT in motion, System inactive"]
[null,null,"Camera",null,null,{"$f":"IF(AND(D10=\"System can NOT be engaged\",E10=\"Visual Warning within 5 minutes\"),5,IF(D10=\"System can NOT be engaged\",4,0))","v":0}]
[null,null,"Radar",null,null,{"$f":"IF(AND(D11=\"System can NOT be engaged\",E11=\"Visual Warning within 5 minutes\"),5,IF(D11=\"System can NOT be engaged\",4,0))","v":0}]
[null,null,"Sensor blocked with VUT in motion, System active"]
[null,null,"Camera",null,null,{"$f":"IF(AND(D13=\"System cancels\",E13=\"Visual Warning within 5 minutes\"),10,IF(D13=\"System cancels\",8,0))","v":0}]
[null,null,"Radar",null,null,{"$f":"IF(AND(D14=\"System cancels\",E14=\"Visual Warning within 5 minutes\"),10,IF(D14=\"System cancels\",8,0))","v":0}]
[]
[]
[null,"System Failure assessment",null,{"$f":"IF(COUNTIF(D7:D14,\"\")>5,0,SUM(F7:F14)/((8-COUNTIF(D7:D14,\"\"))/3))","v":0}]
[]
[null,"SUMMARY"]
[null,null,"System Failure assessment",{"$f":"D17","v":0}]
[null,"TOTAL SCORE",null,{"$f":"D20","v":0}]
[]
[null,"TOTAL SYSTEM FAILURE",null,{"$f":"D21","v":0}]

{"sheet":"SB Unresponsive Driver","index":10,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[[11,1,11,2],[13,1,13,2],[13,3,13,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],[7,1,7,2],[7,3,7,4],[9,1,9,2],[10,3,10,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,"SUMMARY"]
[null,null,"Unresponsive Driver Intervention assessment",{"$f":"D8","v":0}]
[null,"TOTAL SCORE",null,{"$f":"SUM(D11)","v":0}]
[]
[null,"TOTAL UNRESPONSIVE DRIVER INTERVENTION",null,{"$f":"D12","v":0}]

{"sheet":"SB Collision Avoidance","index":11,"n_rows":71,"n_cols":16,"rows_kept":71,"cut":false,"hidden":false,"merged":[[66,2,66,4],[67,2,67,4],[68,1,68,4],[60,5,60,10],[58,5,58,10],[59,5,59,10],[63,1,63,4],[44,1,45,4],[70,1,70,4],[65,5,65,10],[66,5,66,10],[68,5,68,10],[69,5,69,10],[70,5,70,10],[58,2,58,4],[59,2,59,4],[60,2,60,4],[61,1,61,4],[61,5,61,10],[63,5,63,10],[67,5,67,10],[62,1,62,10],[65,1,65,4],[52,2,52,3],[54,5,54,10],[55,5,55,10],[56,5,56,10],[57,5,57,10],[54,2,54,4],[55,2,55,4],[56,2,56,4],[57,2,57,4],[53,2,53,4],[50,5,50,10],[49,5,49,6],[47,7,47,8],[48,7,48,8],[49,7,49,8],[47,9,47,10],[48,9,48,10],[49,9,49,10],[47,5,47,6],[48,5,48,6],[31,9,31,10],[36,5,36,6],[36,7,36,8],[36,9,36,10],[51,1,51,10],[44,5,44,6],[44,7,44,8],[44,9,44,10],[46,5,46,6],[46,7,46,8],[46,9,46,10],[42,5,42,10],[41,1,41,10],[45,5,45,6],[45,7,45,8],[45,9,45,10],[8,9,8,10],[16,5,16,6],[16,7,16,8],[16,9,16,10],[29,5,29,6],[29,7,29,8],[29,9,29,10],[4,9,4,10],[5,2,5,4],[5,5,5,6],[5,7,5,8],[5,9,5,10],[4,7,4,8],[7,1,7,4],[8,1,40,1],[8,5,8,6],[8,7,8,8],[31,5,31,6],[31,7,31,8],[1,1,2,4],[52,5,52,10],[53,5,53,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],[42,1,42,4]]}
[3]
[null,"Collision Avoidance",null,null,null,"AD",null,"AEB",null,"FCW"]
[null,null,null,null,null,null,null,null,null,"[s]"]
[null,"SYSTEM DETAILS"]
[null,null,"Speed range (km/h) - Minimum"]
[null,null,"Maximum"]
[]
[null,"Longitudinal Control",null,null,null,"Straight 100%","Curve 100%","Straight 100%","Curve 100%","Straight 100%","Curve 100%"]
[null,"Scenario","CCRs - Stationary target","VUT","Target"]
[null,null,null,70,"-",null,null,null,null,null,null,{"$f":"IF(AND(F10=\"\",G10=\"\",H10=\"\",I10=\"\",J10=\"\",K10),\"\",IF(M10=\"\",\"\",M10&CHAR(10))&IF(N10=\"\",\"\",N10&CHAR(10))&IF(O10=\"\",\"\",O10&CHAR(10))&IF(P10=\"\",\"\",P10))","v":""},{"$f":"IF(NOT(OR(H10=\"Grey\",F10=\"Grey\")),\"ERROR! Enter Result for AD or AEB, not both\",\"\")","v":"ERROR! Enter Result for AD or AEB, not both"},{"$f":"IF(NOT(OR(I10=\"Grey\",G10=\"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(F10=\"Green\",H10=\"Green\"),J10<>\"\"),\"ERROR!, no additional 0.25 points if collision avoided\",\"\")","v":""},{"$f":"IF(AND(OR(G10=\"Green\",I10=\"Green\"),K10<>\"\"),\"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(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":""}]
[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,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 Car-to-Car assessment",null,null,null,{"$f":"COUNTIF(F10:I41,\"Green\")*1+COUNTIF(H10:I41,\"Orange\")*0.5+COUNTIF(J10:K41,\">\"&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,"S-Bend","VUT"]
[null,null,null,80]
[null,null,null,100]
[null,null,null,120]
[null,null,null,null,null,{"$f":"COUNTIF(F48:I50,\"Green\")*5+COUNTIF(J48:K50,\"<\"&0.3)*2.5","v":0}]
[]
[null,null,"Lane change with overtake",null,"Target","Intentional"]
[null,null,"Overtaking vehicle (GVT @ 72km/h)"]
[null,null,0.5]
[null,null,0.6]
[null,null,0.7]
[null,null,"Overtaking vehicle (GVT @ 80km/h)"]
[null,null,0.5]
[null,null,0.6]
[null,null,0.7]
[null,"ELK Overtaking vehicle assessment",null,null,null,{"$f":"IF(COUNTIF(F55:K61,\"PASS\")=6,10,0)","v":0}]
[]
[null,"Lateral Control assessment",null,null,null,{"$f":"SUM(F51,F62)","v":0}]
[]
[null,"SUMMARY"]
[null,null,"Longitudinal Control",null,null,{"$f":"F43/35*25","v":0}]
[null,null,"Lateral Control",null,null,{"$f":"F64","v":0}]
[null,"TOTAL SCORE",null,null,null,{"$f":"SUM(F67:I68)","v":0}]
[]
[null,"TOTAL Collision Avoidance",null,null,null,{"$f":"F69","v":0}]

{"sheet":"Website Summary","index":12,"n_rows":92,"n_cols":8,"rows_kept":92,"cut":false,"hidden":true,"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'!D28:E28)=\"system advised\"","v":false},false]
["@Speed Adjustment for Road Features",{"$f":"OR('VA Speed Assistance'!D47=\"yes\",'VA Speed Assistance'!D48=\"yes\",'VA Speed Assistance'!D49=\"yes\")","v":false}]
["@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'!D34:E34","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'!D53,18)","v":"Red"}]
["System Status Change Indicator",{"$f":"AD_Colour('DE System Status'!D54,7)","v":"Red"}]
["Driver monitoring Pts",{"$f":"'AD GRADING'!D10","v":0}]
["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}]
["Steering to avoid an obstacle Caption",{"$f":"IF('DE Driving Collaboration'!D17=\"system cancelled\",\"System stops assistance  when driver steers to avoid obstacle\",\"System continues to assist  while driver steers to avoid obstacle\")","v":"System continues to assist  while driver steers to avoid obstacle"}]
["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"}]
["Vehicle response to fixed speed limits",{"$f":"'VA Speed Assistance'!D44","v":0}]
["Vehicle response to variable speed limits",{"$f":"'VA Speed Assistance'!D45","v":0}]
["@Road features - corners",{"$f":"'VA Speed Assistance'!D47=\"yes\"","v":false}]
["@Road features - roundabouts",{"$f":"'VA Speed Assistance'!D48=\"yes\"","v":false}]
["@Road features - junctions",{"$f":"'VA Speed Assistance'!D49=\"yes\"","v":false}]
["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'!F42=\"yes\"","v":false}]
["@Assistance maintained after coming to a full stop",{"$f":"'VA ACC Performance'!F47=\"yes\"","v":false}]
["System Assistance maintained by",{"$f":"_xlfn.IFS('VA ACC Performance'!F49=\"yes\",'VA ACC Performance'!B49,'VA ACC Performance'!F50=\"yes\",'VA ACC Performance'!B50,'VA ACC Performance'!F51=\"yes\",'VA ACC Performance'!B51,'VA ACC Performance'!F52=\"yes\",'VA ACC Performance'!B52,'VA ACC Performance'!F53=\"yes\",'VA ACC Performance'!B53)","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}]
["80km/h",{"$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"}]
["100km/h",{"$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"}]
["120km/h",{"$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'!D23:F23","v":0},0,0]
["System Failure Colour",{"$f":"AD_Colour(B66,25)","v":"Red"}]
["Start-up Camera Engagement",{"$f":"'SB System Failure'!D7&\" after a 5 minute drive\"","v":" after a 5 minute drive"}]
["Start-up Camera Warning",{"$f":"'SB System Failure'!E7&\" after sensor blocking\"","v":" after sensor blocking"}]
["Start-up Radar Engagement",{"$f":"'SB System Failure'!D8&\" after a 5 minute drive\"","v":" after a 5 minute drive"}]
["Start-up Radar Warning",{"$f":"'SB System Failure'!E8&\" after sensor blocking\"","v":" after sensor blocking"}]
["MotionInactive Camera Engagement",{"$f":"'SB System Failure'!D11&\" after a 5 minute drive\"","v":" after a 5 minute drive"}]
["MotionInactive Camera Warning",{"$f":"'SB System Failure'!E11&\" after sensor blocking\"","v":" after sensor blocking"}]
["MotionInactive Radar Engagement",{"$f":"'SB System Failure'!D12&\" after a 5 minute drive\"","v":" after a 5 minute drive"}]
["MotionInactive Radar Warning",{"$f":"'SB System Failure'!E12&\" after sensor blocking\"","v":" after sensor blocking"}]
["MotionActive Camera Engagement",{"$f":"'SB System Failure'!D15&\" within 2 minutes after blocking\"","v":" within 2 minutes after blocking"}]
["MotionActive Camera Warning",{"$f":"'SB System Failure'!E15&\" after sensor blocking\"","v":" after sensor blocking"}]
["MotionActive Radar Engagement",{"$f":"'SB System Failure'!D16&\" after sensor blocking\"","v":" after sensor blocking"}]
["MotionActive Radar Warning",{"$f":"'SB System Failure'!E16&\" 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'!F71:K71","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'!G10:G16,\"Green\")+COUNTIF('SB Collision Avoidance'!I10:I16,\"Green\"))*1+COUNTIF('SB Collision Avoidance'!I10:I16,\"Orange\")*0.5+COUNTIF('SB Collision Avoidance'!K10:K16,\">1.5\")*0.25)/7,1)","v":"Red"}]
["@SB Approaching stationary car",{"$f":"AD_Colour(((COUNTIF('SB Collision Avoidance'!F10:F16,\"Green\")+COUNTIF('SB Collision Avoidance'!H10:H16,\"Green\"))*1+COUNTIF('SB Collision Avoidance'!H10:H16,\"Orange\")*0.5+COUNTIF('SB Collision Avoidance'!J10:J16,\">1.5\")*0.25)/7,1)","v":"Red"}]
["@SB Approaching slower moving car",{"$f":"AD_Colour(((COUNTIF('SB Collision Avoidance'!F18:F29,\"Green\")+COUNTIF('SB Collision Avoidance'!H18:H29,\"Green\"))*1+COUNTIF('SB Collision Avoidance'!H18:H29,\"Orange\")*0.5+COUNTIF('SB Collision Avoidance'!J18:J29,\">1.5\")*0.25)/12,1)","v":"Red"}]
["@SB Approaching braking car",{"$f":"AD_Colour(((COUNTIF('SB Collision Avoidance'!F31,\"Green\")+COUNTIF('SB Collision Avoidance'!H31,\"Green\"))*1+COUNTIF('SB Collision Avoidance'!H31,\"Orange\")*0.5+COUNTIF('SB Collision Avoidance'!J31,\">1.5\")*0.25)/1,1)","v":"Red"}]
["@SB Car cutting-in in front",{"$f":"AD_Colour(((COUNTIF('SB Collision Avoidance'!F33:F36,\"Green\")+COUNTIF('SB Collision Avoidance'!H33:H37,\"Green\"))*1+COUNTIF('SB Collision Avoidance'!H33:H37,\"Orange\")*0.5+COUNTIF('SB Collision Avoidance'!J33:J37,\">1.5\")*0.25)/4,1)","v":"Red"}]
["@SB Car cutting-out in front",{"$f":"AD_Colour(((COUNTIF('SB Collision Avoidance'!F38:F41,\"Green\")+COUNTIF('SB Collision Avoidance'!H38:H42,\"Green\"))*1+COUNTIF('SB Collision Avoidance'!H38:H42,\"Orange\")*0.5+COUNTIF('SB Collision Avoidance'!J38:J42,\">1.5\")*0.25)/4,1)","v":"Red"}]
["Campaign year",{"$f":"'General Overview'!G2","v":2021}]