{"text_format":"1","workbook":"xlsx","n_sheets":21,"sheets":["General Overview","OVERALL RATING","AOP Frontal MPDB","AOP Frontal FW","AOP Side MDB","AOP Side Pole","AOP Farside","AOP Whiplash","AOP Rescue","COP Dynamic","COP Vehicle Based","COP CRS Installation","VRU Headform","VRU Upper Legform","VRU Lower Legform","VRU AEB Pedestrian","VRU AEB Cyclist","SA OSM","SA SAS","SA AEB Car-to-Car","SA LSS"],"not_rendered":{"charts":0,"images":247,"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":154,"n_cols":24,"rows_kept":154,"cut":false,"hidden":false,"merged":[[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],[35,2,35,3],[83,3,83,4],[15,2,15,3],[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],[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],[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],[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",2020,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3 door hatchback"]
[null,null,null,null,null,null,"BASE"]
[null,"Make",null,null,null,"Frontal MPDB test",{"$f":"IF(F3=\"\",\"\",_xlfn.CONCAT(F$3,\"-MP1\"))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3 door wgon"]
[null,"Model",null,null,null,"Frontal FW test",{"$f":"IF(F3=\"\",\"\",_xlfn.CONCAT(F$3,\"-FW1\"))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"5 door wagon"]
[null,"Start VIN",null,null,null,"Side MDB test",{"$f":"IF(F3=\"\",\"\",_xlfn.CONCAT(F$3,\"-MD1\"))","v":""}]
[null,"Kerb weight (kg)",null,null,null,"Side Pole test",{"$f":"IF(F3=\"\",\"\",_xlfn.CONCAT(F$3,\"-PO1\"))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"5 door SUV"]
[null,"Engine",null,null,null,"Whiplash tests",{"$f":"IF(F3=\"\",\"\",_xlfn.CONCAT(F$3,\"-WHL\"))","v":""},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,"Pedestrian tests",{"$f":"IF(F3=\"\",\"\",_xlfn.CONCAT(F$3,\"-PP\"))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"5 door MPV"]
[null,"Safety Pack",null,null,null,"AEB VRU Pedestrian tests",{"$f":"IF(F3=\"\",\"\",_xlfn.CONCAT(F$3,\"-AEBP\"))","v":""}]
[null,"Body Type",null,null,null,"AEB VRU Cyclist tests",{"$f":"IF(F3=\"\",\"\",_xlfn.CONCAT(F$3,\"-AEBB\"))","v":""}]
[null,"Full description",null,null,null,"SBR test",{"$f":"IF(F3=\"\",\"\",_xlfn.CONCAT(F$3,\"-SBR\"))","v":""}]
[null,"Release Date",null,null,null,"SAS tests",{"$f":"IF(F3=\"\",\"\",_xlfn.CONCAT(F$3,\"-SAS\"))","v":""}]
[null,"Hand of drive",null,null,null,"AEB Car-to-Car tests",{"$f":"IF(F3=\"\",\"\",_xlfn.CONCAT(F$3,\"-AEBC\"))","v":""}]
[null,"Seat arrangement",null,null,null,"LSS tests",{"$f":"IF(F3=\"\",\"\",_xlfn.CONCAT(F$3,\"-LSS\"))","v":""}]
[null,"front row",null,null,{"$f":"CONCATENATE(C16,C17,C18)","v":""}]
[null,"second row"]
[null,"third row"]
[null,"Vehicle class"]
[]
[null,"SAFETY EQUIPMENT"]
[]
[null,"ADULT OCCUPANT",null,null,"DRIVER","PASSENGER","REAR","ROW 3"]
[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","ROW 3"]
[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","ROW 3"]
[null,"SAFETY ASSIST SYSTEMS"]
[null,null,"SBR"]
[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]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Make","Vehicle class","CRS"]
[null,null,null,null,"Alfa Romeo","Supermini"]
[null,null,null,null,"Audi","Small Family Car"]
[null,null,null,null,"BMW","Large Family Car"]
[null,null,null,null,"Chevrolet","Executive"]
[null,null,null,null,"Chrysler","Small MPV"]
[null,null,null,null,"Citroën","Large MPV"]
[null,null,null,null,"Dacia","Small Off-Road 4x4"]
[null,null,null,null,"Daewoo","Large Off-Road 4x4"]
[null,null,null,null,"Daihatsu","Roadster sports"]
[null,null,null,null,"Dodge","Pick-up"]
[null,null,null,null,"FIAT","Business and Family Vans"]
[null,null,null,null,"Ford"]
[null,null,null,null,"Geely Emgrand"]
[null,null,null,null,"Honda"]
[null,null,null,null,"Hyundai"]
[null,null,null,null,"Infiniti"]
[null,null,null,null,"Isuzu"]
[null,null,null,null,"Jaguar"]
[null,null,null,null,"Jeep"]
[null,null,null,null,"Kia"]
[null,null,null,null,"Lancia"]
[null,null,null,null,"Land Rover"]
[null,null,null,null,"Landwind"]
[null,null,null,null,"Lexus"]
[null,null,null,null,"Maserati"]
[null,null,null,null,"Mazda"]
[null,null,null,null,"Mercedes-Benz"]
[null,null,null,null,"MG"]
[null,null,null,null,"MINI"]
[null,null,null,null,"Mitsubishi"]
[null,null,null,null,"Nissan"]
[null,null,null,null,"Opel"]
[null,null,null,null,"Peugeot"]
[null,null,null,null,"Proton"]
[null,null,null,null,"Qoros"]
[null,null,null,null,"Renault"]
[null,null,null,null,"Rover"]
[null,null,null,null,"Saab"]
[null,null,null,null,"Seat"]
[null,null,null,null,"Skoda"]
[null,null,null,null,"smart"]
[null,null,null,null,"Subaru"]
[null,null,null,null,"Suzuki"]
[null,null,null,null,"Tesla"]
[null,null,null,null,"Toyota"]
[null,null,null,null,"Volvo"]
[null,null,null,null,"Volkswagen"]

{"sheet":"OVERALL RATING","index":1,"n_rows":46,"n_cols":12,"rows_kept":46,"cut":false,"hidden":false,"merged":[[19,8,19,9],[20,8,20,9],[21,8,21,9],[22,8,22,9],[23,8,23,9],[22,4,22,5],[23,4,23,5],[19,6,19,7],[20,6,20,7],[21,6,21,7],[22,6,22,7],[23,6,23,7],[34,1,34,10],[1,6,2,6],[1,7,2,9],[26,7,31,8],[32,7,32,8],[26,9,31,10],[32,9,32,10],[15,10,16,10],[4,8,4,9],[19,2,19,3],[21,2,21,3],[22,2,22,3],[23,2,23,3],[19,4,19,5],[20,4,20,5],[21,4,21,5],[5,8,5,9],[16,8,16,9],[13,4,13,5],[15,6,15,7],[15,8,15,9],[13,8,13,9],[14,8,14,9],[15,4,15,5],[4,2,4,3],[4,4,4,5],[13,6,13,7],[14,6,14,7],[14,4,14,5],[4,6,4,7],[5,2,5,3],[14,2,14,3],[13,2,13,3],[5,4,5,5],[5,6,5,7],[48,1,48,10],[49,1,49,10],[25,1,25,10],[15,2,15,3],[16,2,16,3],[16,4,16,5],[16,6,16,7],[20,2,20,3],[35,1,41,5],[35,6,41,10],[32,1,32,2],[26,1,31,2],[32,3,32,4],[26,3,31,4],[32,5,32,6],[26,5,31,6],[44,1,44,10],[45,1,45,10],[46,1,46,10],[47,1,47,10],[42,1,42,5],[42,6,42,10]]}
[]
[null,null,{"$f":"CONCATENATE('General Overview'!C4:E4,\" \",'General Overview'!C5)","v":" "}]
[null,null,{"$f":"CONCATENATE('General Overview'!C8,\" \",'General Overview'!C9,\", \",'General Overview'!C14)","v":" , "}]
[]
[null,null,"ADULT OCCUPANT\n",null,"CHILD OCCUPANT\n",null,"VULNERABLE ROAD USER\n",null,"SAFETY ASSIST\n"]
[null,null,{"$f":"ROUND(C14,1)","v":0},null,{"$f":"ROUND(E14,1)","v":0},null,{"$f":"ROUND(G14,1)","v":0},null,{"$f":"ROUND(I14,1)","v":0}]
[null,null,"Frontal Offset",{"$f":"'AOP Frontal MPDB'!D120:G120","v":0},"Dynamic",{"$f":"IF(OR('General Overview'!C17=\"\",'General Overview'!C18=\"\",'General Overview'!C17>0,'General Overview'!C18>0),'COP Dynamic'!D54,\"\")","v":0},"Headforms",{"$f":"'VRU Headform'!T68","v":0},"OSM",{"$f":"'SA OSM'!D20","v":0}]
[null,null,"Frontal FW",{"$f":"'AOP Frontal FW'!D65","v":0},"Vehicle Based",{"$f":"'COP Vehicle Based'!D37","v":0},"Upper Legform",{"$f":"'VRU Upper Legform'!G35","v":0},"SAS",{"$f":"IF('General Overview'!E65=\"Standard\",'SA SAS'!D49,0)","v":0}]
[null,null,"Side MDB",{"$f":"'AOP Side MDB'!D53","v":0},"CRS Installation",{"$f":"'COP CRS Installation'!H28","v":0},"Lower Legform",{"$f":"'VRU Lower Legform'!E35","v":0},"AEB Car-to-Car",{"$f":"IF('General Overview'!E64=\"Standard\",'SA AEB Car-to-Car'!D112,0)","v":0}]
[null,null,"Side Pole",{"$f":"'AOP Side Pole'!D72","v":0},null,null,"AEB Pedestrian",{"$f":"IF(AND(SUM(H7,H8,H9)>=22,'General Overview'!E55=\"Standard\"),'VRU AEB Pedestrian'!D126,0)","v":0},"LSS",{"$f":"IF('General Overview'!E66=\"Standard\",'SA LSS'!D72,0)","v":0}]
[null,null,"Farside",{"$f":"'AOP Farside'!D65:G65","v":0},null,null,"AEB Cyclist",{"$f":"IF(AND(SUM(H7,H8,H9)>=22,'General Overview'!E56=\"Standard\"),'VRU AEB Cyclist'!D86,0)","v":0}]
[null,null,"Whiplash",{"$f":"'AOP Whiplash'!D74:G74","v":0}]
[null,null,"Rescue",{"$f":"'AOP Rescue'!D54","v":0}]
[null,"Total Score",{"$f":"SUM(D7:D13)","v":0},null,{"$f":"SUM(F7:F13)","v":0},null,{"$f":"SUM(H7:H13)","v":0},null,{"$f":"SUM(J7:J11)","v":0}]
[null,"Max Points available",38,null,49,null,54,null,16,null,"TOTAL"]
[null,"Normalised Score",{"$f":"INT(C14/C15*100)","v":0},null,{"$f":"INT(E14/E15*100)","v":0},null,{"$f":"INT(G14/G15*100)","v":0},null,{"$f":"INT(I14/I15*100)","v":0},null,{"$f":"INT(ROUND((C14/C15)*100,2)*C17+ROUND((E14/E15)*100,2)*E17+ROUND((G14/G15)*100,2)*G17+ROUND((I14/I15)*100,2)*I17)","v":0}]
[null,"Weight",0.4,null,0.2,null,0.2,null,0.2]
[null,null,null,{"$f":"C16/100","v":0},null,{"$f":"E16/100","v":0},null,{"$f":"G16/100","v":0},null,{"$f":"I16/100","v":0}]
[null,"RATING REQUIREMENTS 2020"]
[null,null,{"$f":"IF($C$16>=80,80,CONCATENATE(\"80 (\",ROUND(80/100*C$15-C$14,3),\"*)\"))","v":"80 (30.4*)"},null,{"$f":"IF($C$16>=80,80,CONCATENATE(\"80 (\",ROUND(80/100*E$15-E$14,3),\"*)\"))","v":"80 (39.2*)"},null,{"$f":"IF($C$16>=60,60,CONCATENATE(\"60 (\",ROUND(60/100*G$15-G$14,3),\"*)\"))","v":"60 (32.4*)"},null,{"$f":"IF($C$16>=70,70,CONCATENATE(\"70 (\",ROUND(70/100*I$15-I$14,3),\"*)\"))","v":"70 (11.2*)"},null,null,{"$f":"IF(AND($C$16>=$C20,$E$16>=$E20,$G$16>=$G20,$I$16>=$I20),1,0)","v":0}]
[null,null,{"$f":"IF($C$16>=70,70,CONCATENATE(\"70 (\",ROUND(70/100*C$15-C$14,3),\"*)\"))","v":"70 (26.6*)"},null,{"$f":"IF($C$16>=70,70,CONCATENATE(\"70 (\",ROUND(70/100*E$15-E$14,3),\"*)\"))","v":"70 (34.3*)"},null,{"$f":"IF($C$16>=50,50,CONCATENATE(\"50 (\",ROUND(50/100*G$15-G$14,3),\"*)\"))","v":"50 (27*)"},null,{"$f":"IF($C$16>=60,60,CONCATENATE(\"60 (\",ROUND(60/100*I$15-I$14,3),\"*)\"))","v":"60 (9.6*)"},null,null,{"$f":"IF(AND($C$16>=$C21,$E$16>=$E21,$G$16>=$G21,$I$16>=$I21),1,0)","v":0}]
[null,null,{"$f":"IF($C$16>=60,60,CONCATENATE(\"60 (\",ROUND(60/100*C$15-C$14,3),\"*)\"))","v":"60 (22.8*)"},null,{"$f":"IF($C$16>=60,60,CONCATENATE(\"60 (\",ROUND(60/100*E$15-E$14,3),\"*)\"))","v":"60 (29.4*)"},null,{"$f":"IF($C$16>=40,40,CONCATENATE(\"40 (\",ROUND(40/100*G$15-G$14,3),\"*)\"))","v":"40 (21.6*)"},null,{"$f":"IF($C$16>=50,50,CONCATENATE(\"50 (\",ROUND(50/100*I$15-I$14,3),\"*)\"))","v":"50 (8*)"},null,null,{"$f":"IF(AND($C$16>=$C22,$E$16>=$E22,$G$16>=$G22,$I$16>=$I22),1,0)","v":0}]
[null,null,{"$f":"IF($C$16>=50,50,CONCATENATE(\"50 (\",ROUND(50/100*C$15-C$14,3),\"*)\"))","v":"50 (19*)"},null,{"$f":"IF($C$16>=50,50,CONCATENATE(\"50 (\",ROUND(50/100*E$15-E$14,3),\"*)\"))","v":"50 (24.5*)"},null,{"$f":"IF($C$16>=30,30,CONCATENATE(\"30 (\",ROUND(30/100*G$15-G$14,3),\"*)\"))","v":"30 (16.2*)"},null,{"$f":"IF($C$16>=40,40,CONCATENATE(\"40 (\",ROUND(40/100*I$15-I$14,3),\"*)\"))","v":"40 (6.4*)"},null,null,{"$f":"IF(AND($C$16>=$C23,$E$16>=$E23,$G$16>=$G23,$I$16>=$I23),1,0)","v":0}]
[null,null,{"$f":"IF($C$16>=40,40,CONCATENATE(\"40 (\",ROUND(40/100*C$15-C$14,3),\"*)\"))","v":"40 (15.2*)"},null,{"$f":"IF($C$16>=40,40,CONCATENATE(\"40 (\",ROUND(40/100*E$15-E$14,3),\"*)\"))","v":"40 (19.6*)"},null,{"$f":"IF($C$16>=20,20,CONCATENATE(\"20 (\",ROUND(20/100*G$15-G$14,3),\"*)\"))","v":"20 (10.8*)"},null,{"$f":"IF($C$16>=30,30,CONCATENATE(\"30 (\",ROUND(30/100*I$15-I$14,3),\"*)\"))","v":"30 (4.8*)"},null,null,{"$f":"IF(AND($C$16>=$C24,$E$16>=$E24,$G$16>=$G24,$I$16>=$I24),1,0)","v":0}]
[null,null,"* Points in brackets indicate the number of additional points to be scored to reach that specific star level",null,null,null,null,null,null,null,null,{"$f":"SUM(L20:L24)","v":0}]
[null,"ADULT OCCUPANT"]
[]
[]
[]
[]
[]
[]
[null,"FRONTAL OFFSET IMPACT",null,"FRONTAL FW IMPACT",null,"SIDE MDB IMPACT",null,"SIDE POLE IMPACT",null,"WHIPLASH"]
[]
[null,"CHILD OCCUPANT"]
[]
[]
[]
[]
[]
[]
[]
[null,"FRONTAL IMPACT",null,null,null,null,"SIDE IMPACT"]
[]
[null,"COMMENTS"]
["GENERAL"]

{"sheet":"AOP Frontal MPDB","index":2,"n_rows":386,"n_cols":7,"rows_kept":386,"cut":false,"hidden":false,"merged":[[28,1,28,2],[28,3,28,4],[28,5,28,6],[1,1,2,2],[1,3,2,4],[1,5,2,6],[3,1,3,2],[18,1,18,2],[101,5,101,6],[44,1,44,2],[50,1,50,2],[50,3,50,4],[50,5,50,6],[71,1,71,2],[71,3,71,4],[71,5,71,6],[81,1,81,2],[90,1,90,2],[99,1,99,2],[101,1,101,2],[101,3,101,4],[48,5,48,6],[110,1,110,2],[110,3,110,6],[103,1,103,2],[104,3,104,4],[104,5,104,6],[105,3,105,4],[105,5,105,6],[106,3,106,4],[106,5,106,6],[107,3,107,4],[107,5,107,6],[108,1,108,2],[108,3,108,4],[108,5,108,6],[119,1,119,2],[119,3,119,6],[124,1,124,6],[112,3,112,6],[113,4,113,6],[114,4,114,6],[115,4,115,6],[116,3,116,6],[117,1,117,2],[117,3,117,6]]}
[3]
[null,"Frontal MPDB Test",null,"Driver",null,"Passenger"]
[]
[null,null,null,"Value","Points","Value","Points"]
[null,"HEAD"]
[null,null,"Steering wheel airbag present? "]
[null,null,"Peak resultant acceleration - g",null,{"$f":"IF(D6=\"Yes\",IF(D7<80,4,\"\"),IF(D6=\"No\",0,\"\"))","v":""},null,{"$f":"IF(F7=\"\",0,IF(F7<80,4,\"\"))","v":0}]
[null,null,"HIC15",null,{"$f":"IF(D6=\"Yes\",IF(D7<80,\"\",ROUND(Sliding_Scale(D8,500,700,4,0),Round)),0)","v":0},null,{"$f":"IF(F7<80,\"\",ROUND(Sliding_Scale(F8,500,700,4,0),Round))","v":""}]
[null,null,"Resultant Acc. 3 msec exeedence - g",null,{"$f":"IF(D6=\"Yes\",IF(D7<80,\"\",ROUND(Sliding_Scale(D9,72,80,4,0),Round)),IF(D6=\"No\",0,\"\"))","v":""},null,{"$f":"IF(F6=\"Yes\",IF(F7<80,\"\",ROUND(Sliding_Scale(F9,72,80,4,0),Round)),\"\")","v":""}]
[null,null,"SUFEHM"]
[null,null,"BrIC"]
[null,null,"Airbag contact modifier (-1)",null,{"$f":"D12","v":0},null,0]
[null,null,"Hazardous airbag deployment modifier (-1)",null,{"$f":"D13","v":0},null,0]
[null,null,"Incorrect airbag deployment modifier (-1)",null,{"$f":"D14","v":0},null,0]
[null,null,"Steering wheel displacement (-1) mm",null,{"$f":"MIN(ROUND(Modifier_Sliding_Scale(D16,90,110,-1,0),Round),ROUND(Modifier_Sliding_Scale(D17,72,88,-1,0),Round),ROUND(Modifier_Sliding_Scale(ABS(D18),90,110,-1,0),Round))","v":0}]
[null,null,"Fore/aft displacement - mm",null,{"$f":"IF(D16>0,\"rearward\",IF(D16<0,\"forward\",\"\"))","v":""}]
[null,null,"Vertical displacement - mm",null,{"$f":"IF(D17>0,\"upward\",IF(D17<0,\"downward\",\"\"))","v":""}]
[null,null,"Lateral displacement - mm",null,{"$f":"IF(D18>0,\"left\",IF(D18<0,\"right\",\"\"))","v":""}]
[null,"Head assessment",null,null,{"$f":"MAX(IF(D6=\"Yes\",MIN(E7:E9)+SUM(E12:E15),IF(D6=\"No\",0)))","v":0},null,{"$f":"MAX(MIN(G7:G9)+SUM(G12:G14),0)","v":0}]
[]
[null,"NECK"]
[null,null,"Shear level exceeded - kN",null,{"$f":"ROUND(Sliding_Scale(D22,1.9,3.1,4,0),Round)","v":0},null,{"$f":"ROUND(Sliding_Scale(F22,IF(F23<25,1.9-0.7*(F23/25),(IF(F23<35,1.2,IF(F23<45,1.2-0.1*(F23-35)/10,1.1)))),IF(F23<25,3.1-1.6*(F23/25),(IF(F23<35,1.5,IF(F23<45,1.5-0.4*(F23-35)/10,1.10000000000001)))),4,0),Round)","v":0}]
[null,null,"duration of exceedence - ms"]
[null,null,"Tension level exceeded - kN",null,{"$f":"ROUND(Sliding_Scale(D24,2.7,3.3,4,0),Round)","v":0},null,{"$f":"ROUND(Sliding_Scale(F24,IF(F25<35,2.7-0.4*(F25/35),(IF(F25<60,2.3-1.2*(F25-35)/25,1.1))),IF(F25<35,3.3-0.4*(F25/35),(IF(F25<60,2.9-1.8*(F25-35)/25,1.10000000000001))),4,0),Round)","v":0}]
[null,null,"duration of exceedence - ms"]
[null,null,"Extension - Nm",null,{"$f":"ROUND(Sliding_Scale(D26,42,57,4,0),Round)","v":0},null,{"$f":"ROUND(Sliding_Scale(F26,42,57,4,0),Round)","v":0}]
[null,"Neck assessment",null,null,{"$f":"MIN(E22,E24,E26)","v":0},null,{"$f":"MIN(G22,G24,G26)","v":0}]
[]
[null,"Head and Neck assessment",null,{"$f":"MIN(E19,E27)","v":0},null,{"$f":"MIN(G19,G27)","v":0}]
[]
[null,"CHEST"]
[null,null,"Compression upper left - mm"]
[null,null,"Compression upper right - mm"]
[null,null,"Compression lower left - mm"]
[null,null,"Compression lower right - mm"]
[null,null,"Chest D / Rmax",{"$f":"MAX(D32:D35)","v":0},{"$f":"IF(D36=0,0,ROUND(Sliding_Scale(D36,35,60,4,0),Round))","v":0}]
[null,null,"Chest D / PCA"]
[null,null,"Compression - mm",null,null,null,{"$f":"ROUND(Sliding_Scale(F38,22,42,4,0),Round)","v":0}]
[null,null,"Viscous criterion - m/s",null,null,null,{"$f":"ROUND(Sliding_Scale(F39,0.5,1,4,0),Round)","v":0}]
[null,null,"Shoulder belt load - kN",null,{"$f":"IF(D40>6,-2,0)","v":0},null,{"$f":"IF(F40>6,-2,0)","v":0}]
[null,null,"Incorrect airbag deployment modifier (-1)",null,{"$f":"D41","v":0},null,{"$f":"F41","v":0}]
[null,null,"Steering wheel contact (-1) ",null,{"$f":"D42","v":0}]
[null,null,"A-Pillar displacement (-2) mm",null,{"$f":"ROUND(Modifier_Sliding_Scale(D43,100,200,-2,0),Round)","v":0}]
[null,null,"Unstable passenger compartment (-1)",null,{"$f":"D44","v":0}]
[null,"Chest assessment",null,null,{"$f":"MAX(MIN(E32:E36)+SUM(E40:E44),0)","v":0},null,{"$f":"MAX(MIN(G38:G40)+SUM(G41),0)","v":0}]
[null,"ABDOMEN"]
[null,null,"Abdominal Compression left - mm",null,{"$f":"IF(D47=\"\",0,IF(D47>=88,0,4))","v":0}]
[null,null,"Abdominal Compression right - mm",null,{"$f":"IF(D48=\"\",0,IF(D48>=88,0,4))","v":0}]
[null,"Abdomen assessment",null,null,{"$f":"MIN(E47:E48)","v":0}]
[]
[null,"Chest and Abdomen assessment",null,{"$f":"MIN(E45:E48)","v":0},null,{"$f":"G45","v":0}]
[]
[null,"KNEE, FEMUR and PELVIS"]
[null,null,"Left Knee Slide - mm",null,{"$f":"ROUND(Sliding_Scale(D54,6,15,4,0),Round)","v":0},null,{"$f":"ROUND(Sliding_Scale(F54,6,15,4,0),Round)","v":0}]
[null,null,"Left Femur Compression level exceeded - kN",null,{"$f":"ROUND(Sliding_Scale(D55,3.8,IF(D56<11,9.07-1.51*D56/10,7.56),4,0),Round)","v":0},null,{"$f":"ROUND(Sliding_Scale(F55,3.8,IF(F56<11,9.07-1.51*F56/10,7.56),4,0),Round)","v":0}]
[null,null,"duration of exceedence - ms"]
[null,null,"Variable contact (-1) ",null,{"$f":"D57","v":0},null,{"$f":"F57","v":0}]
[null,null,"Concentrated loading (-1) ",null,{"$f":"D58","v":0},null,{"$f":"F58","v":0}]
[null,null,"Incorrect airbag deployment modifier (-1)",null,{"$f":"D59","v":0},null,{"$f":"F59","v":0}]
[null,"Left Knee and Femur assessment",null,null,{"$f":"MAX(MIN(E54:E55)+SUM(E57:E59),0)","v":0},null,{"$f":"MAX(MIN(G54:G55)+SUM(G57:G59),0)","v":0}]
[null,null,"Right Knee Slide - mm",null,{"$f":"ROUND(Sliding_Scale(D61,6,15,4,0),Round)","v":0},null,{"$f":"ROUND(Sliding_Scale(F61,6,15,4,0),Round)","v":0}]
[null,null,"Right Femur Compression level exceeded - kN",null,{"$f":"ROUND(Sliding_Scale(D62,3.8,IF(D63<11,9.07-1.51*D63/10,7.56),4,0),Round)","v":0},null,{"$f":"ROUND(Sliding_Scale(F62,3.8,IF(F63<11,9.07-1.51*F63/10,7.56),4,0),Round)","v":0}]
[null,null,"duration of exceedence - ms"]
[null,null,"Variable contact (-1) ",null,{"$f":"D64","v":0},null,{"$f":"F64","v":0}]
[null,null,"Concentrated loading (-1) ",null,{"$f":"D65","v":0},null,{"$f":"F65","v":0}]
[null,null,"Incorrect airbag deployment modifier (-1)",null,{"$f":"D66","v":0},null,{"$f":"F66","v":0}]
[null,"Right Knee and Femur assessment",null,null,{"$f":"MAX(MIN(E61:E62)+SUM(E64:E66),0)","v":0},null,{"$f":"MAX(MIN(G61:G62)+SUM(G64:G66),0)","v":0}]
[null,null,"Left Acetabulum Compression - kN",null,{"$f":"ROUND(Sliding_Scale(D68,3.28,4.1,4,0),Round)","v":0}]
[null,null,"Right Acetabulum Compression - kN",null,{"$f":"ROUND(Sliding_Scale(D69,3.28,4.1,4,0),Round)","v":0}]
[null,"Pelvis assessment",null,null,{"$f":"MIN(E68:E69)","v":0}]
[]
[null,"Knee, Femur and Pelvis assessment",null,{"$f":"MIN(E60,E67,E70)","v":0},null,{"$f":"MIN(G60,G67)","v":0}]
[]
[null,"LOWER LEG"]
[null,null,"Left compression - kN",null,{"$f":"ROUND(Sliding_Scale(D75,2,8,4,0),Round)","v":0},null,{"$f":"ROUND(Sliding_Scale(F75,2,8,4,0),Round)","v":0}]
[null,null,"Left Upper Tibia Index ",null,{"$f":"ROUND(Sliding_Scale(D76,0.4,1.3,4,0),Round)","v":0},null,{"$f":"ROUND(Sliding_Scale(F76,0.4,1.3,4,0),Round)","v":0}]
[null,null,"Left Lower Tibia Index",null,{"$f":"ROUND(Sliding_Scale(D77,0.4,1.3,4,0),Round)","v":0},null,{"$f":"ROUND(Sliding_Scale(F77,0.4,1.3,4,0),Round)","v":0}]
[null,null,"Maximum pedal vertical displacement - mm",null,{"$f":"ROUND(Modifier_Sliding_Scale(D78,72,88,-1,0),Round)","v":0}]
[null,null,"Brake Vertical displacement - mm",null,{"$f":"IF(D79=\"N/A\",\"\",IF(D79>0,\"upward\",IF(D79<0,\"downward\",\"\")))","v":""},"Brake"]
[null,null,"Clutch Vertical displacement - mm",null,{"$f":"IF(D80=\"N/A\",\"\",IF(D80>0,\"upward\",IF(D80<0,\"downward\",\"\")))","v":""},"Clutch"]
[null,null,"Accel Vertical displacement - mm",null,{"$f":"IF(D81=\"N/A\",\"\",IF(D81>0,\"upward\",IF(D81<0,\"downward\",\"\")))","v":""},"Accelerator"]
[null,"Left Lower Leg assessment",null,null,{"$f":"MAX(MIN(E75:E77)+E78,0)","v":0},null,{"$f":"MIN(G75:G77)","v":0}]
[]
[null,null,"Right compression - kN",null,{"$f":"ROUND(Sliding_Scale(D84,2,8,4,0),Round)","v":0},null,{"$f":"ROUND(Sliding_Scale(F84,2,8,4,0),Round)","v":0}]
[null,null,"Right Upper Tibia Index ",null,{"$f":"ROUND(Sliding_Scale(D85,0.4,1.3,4,0),Round)","v":0},null,{"$f":"ROUND(Sliding_Scale(F85,0.4,1.3,4,0),Round)","v":0}]
[null,null,"Right Lower Tibia Index",null,{"$f":"ROUND(Sliding_Scale(D86,0.4,1.3,4,0),Round)","v":0},null,{"$f":"ROUND(Sliding_Scale(F86,0.4,1.3,4,0),Round)","v":0}]
[null,null,"Maximum pedal vertical displacement - mm",null,{"$f":"ROUND(Modifier_Sliding_Scale(D87,72,88,-1,0),Round)","v":0}]
[null,null,"Brake Vertical displacement - mm",{"$f":"IF(D79=\"\",\"\",D79)","v":""},{"$f":"IF(D88=\"N/A\",\"\",IF(D88>0,\"upward\",IF(D88<0,\"downward\",\"\")))","v":"upward"}]
[null,null,"Clutch Vertical displacement - mm",{"$f":"IF(D80=\"\",\"\",D80)","v":""},{"$f":"IF(D89=\"N/A\",\"\",IF(D89>0,\"upward\",IF(D89<0,\"downward\",\"\")))","v":"upward"}]
[null,null,"Accel Vertical displacement - mm",{"$f":"IF(D81=\"\",\"\",D81)","v":""},{"$f":"IF(D90=\"N/A\",\"\",IF(D90>0,\"upward\",IF(D90<0,\"downward\",\"\")))","v":"upward"}]
[null,"Right Lower Leg assessment",null,null,{"$f":"MAX(MIN(E84:E86)+E87,0)","v":0},null,{"$f":"MIN(G84:G86)","v":0}]
[]
[null,"FOOT and ANKLE"]
[null,null,"Maximum pedal horizontal displacement - mm",null,{"$f":"IF(COUNTIF(D95:D97,\"\")=3,0,ROUND(Sliding_Scale(D94,100,200,4,0),Round))","v":0}]
[null,null,"Brake Horizontal displacement - mm",null,{"$f":"IF(D95=\"N/A\",\"\",IF(D95>0,\"rearward\",IF(D95<0,\"forward\",\"\")))","v":""},"Brake"]
[null,null,"Clutch Horizontal displacement - mm",null,{"$f":"IF(D96=\"N/A\",\"\",IF(D96>0,\"rearward\",IF(D96<0,\"forward\",\"\")))","v":""},"Clutch"]
[null,null,"Accel Horizontal displacement - mm",null,{"$f":"IF(D97=\"N/A\",\"\",IF(D97>0,\"rearward\",IF(D97<0,\"forward\",\"\")))","v":""},"Accelerator"]
[null,null,"Footwell Rupture (-1)",null,{"$f":"D98","v":0}]
[null,null,"Pedal Blocking (-1)",null,{"$f":"ROUND(Sliding_Scale(D99,50,175,0,-1),Round)","v":0}]
[null,"Foot and Ankle assessment",null,null,{"$f":"MAX(E94+E98+E99,0)","v":0}]
[]
[null,"Lower Leg, Foot and Ankle assessment",null,{"$f":"MIN(E82,E91,E100)","v":0},null,{"$f":"MIN(G82,G91)","v":0}]
[]
[null,"SUMMARY"]
[null,null,"Head and Neck assessment",{"$f":"D29","v":0},null,{"$f":"F29","v":0}]
[null,null,"Chest assessment",{"$f":"D51","v":0},null,{"$f":"F51","v":0}]
[null,null,"Knee, Femur and Pelvis assessment",{"$f":"D72","v":0},null,{"$f":"F72","v":0}]
[null,null,"Lower Leg, Foot and Ankle Assessment",{"$f":"D102","v":0},null,{"$f":"F102","v":0}]
[null,"DUMMY SCORE",null,{"$f":"SUM(D105:E108)","v":0},null,{"$f":"SUM(F105:G108)","v":0}]
[]
[null,"Door Opening",null,0]
[]
[null,"COMPATIBILITY"]
[null,null,"Standard Deviation",null,{"$f":"((IF((8-2-2)*(25-D115)/(25-40)+2<2,2,IF((8-2-2)*(25-D115)/(25-40)+2>8-2,8-2,(8-2-2)*(25-D115)/(25-40)+2)))*-1)*(IF((1)*(50-D114)/(50-150)<0,0,IF((1)*(50-D114)/(-100)+0>1,1,(1)*(50-D114)/(-100))))","v":0}]
[null,null,"OLC - g",null,{"$f":"ROUND(Sliding_Scale(D115,25,40,0,-2),Round)","v":0}]
[null,null,"Bottoming out",null,{"$f":"IF(D116=\"yes\", -2,0)","v":0}]
[]
[null,"Compatibility assessment",null,{"$f":"MAX(-8,SUM(E114:E116))/2","v":0}]
[]
[null,"TOTAL FRONTAL MPDB",null,{"$f":"MAX(IF(OR(E7=0,E8=0,E9=0,G7=0,G8=0,G9=0,E22=0,E26=0,E24=0,G22=0,G24=0,G26=0,E32=0,E33=0,E34=0,E35=0,E36=G38=0,G39=0,E47=0,E48=0),0,(MIN(D105,F105)+MIN(D106,F106)+MIN(D107,F107)+MIN(D108,F108)+D111+D118)/2),0)","v":0}]
[]
[]
[]
[]
[null,"DUMMY MEASUREMENTS"]
[null,"Head"]
[null,"Ax","Max"]
[null,null,"Min"]
[null,"Ay","Max"]
[null,null,"Min"]
[null,"Az","Max"]
[null,null,"Min"]
[null,"Wx","Max"]
[null,null,"Min"]
[null,"Wy","Max"]
[null,null,"Min"]
[null,"Wz","Max"]
[null,null,"Min"]
[null,"Skull spring"]
[null,"Fz front","Max"]
[null,null,"Min"]
[null,"Fz rear","Max"]
[null,null,"Min"]
[null,"SUFEHM","value"]
[null,"BrIC","value"]
[null,"Neck"]
[null,"Fx","Max"]
[null,null,"Min"]
[null,"Fy","Max"]
[null,null,"Min"]
[null,"Fz","Max"]
[null,null,"Min"]
[null,"Mx","Max"]
[null,null,"Min"]
[null,"My","Max"]
[null,null,"Min"]
[null,"Mz","Max"]
[null,null,"Min"]
[null,"Clavicle left inner"]
[null,"Fx","Max"]
[null,null,"Min"]
[null,"Fy","Max"]
[null,null,"Min"]
[null,"Fz","Max"]
[null,"Clavicle left outer"]
[null,"Fx","Max"]
[null,null,"Min"]
[null,"Fy","Max"]
[null,null,"Min"]
[null,"Fz","Max"]
[null,"Clavicle right inner"]
[null,"Fx","Max"]
[null,null,"Min"]
[null,"Fy","Max"]
[null,null,"Min"]
[null,"Fz","Max"]
[null,"Clavicle right outer"]
[null,"Fx","Max"]
[null,null,"Min"]
[null,"Fy","Max"]
[null,null,"Min"]
[null,"Fz","Max"]
[null,"Chest left upper"]
[null,"Dx","Max"]
[null,null,"Min"]
[null,"Dy","Max"]
[null,null,"Min"]
[null,"Dz","Max"]
[null,null,"Min"]
[null,"Dchest","Max"]
[null,null,"Min"]
[null,"αy","Max"]
[null,null,"Min"]
[null,"αz","Max"]
[null,null,"Min"]
[null,"Chest right upper"]
[null,"Dx","Max"]
[null,null,"Min"]
[null,"Dy","Max"]
[null,null,"Min"]
[null,"Dz","Max"]
[null,null,"Min"]
[null,"Dchest","Max"]
[null,null,"Min"]
[null,"αy","Max"]
[null,null,"Min"]
[null,"αz","Max"]
[null,null,"Min"]
[null,"Chest left lower"]
[null,"Dx","Max"]
[null,null,"Min"]
[null,"Dy","Max"]
[null,null,"Min"]
[null,"Dz","Max"]
[null,null,"Min"]
[null,"Dchest","Max"]
[null,null,"Min"]
[null,"αy","Max"]
[null,null,"Min"]
[null,"αz","Max"]
[null,null,"Min"]
[null,"Chest right lower"]
[null,"Dx","Max"]
[null,null,"Min"]
[null,"Dy","Max"]
[null,null,"Min"]
[null,"Dz","Max"]
[null,null,"Min"]
[null,"Dchest","Max"]
[null,null,"Min"]
[null,"αy","Max"]
[null,null,"Min"]
[null,"αz","Max"]
[null,null,"Min"]
[null,"Sternum"]
[null,"Ax","Max"]
[null,null,"Min"]
[null,"T1 "]
[null,"Ax","Max"]
[null,null,"Min"]
[null,"Ay","Max"]
[null,null,"Min"]
[null,"Az","Max"]
[null,null,"Min"]
[null,"resultant","Max"]
[null,null,"Min"]
[null,"T4"]
[null,"Ax","Max"]
[null,null,"Min"]
[null,"Ay","Max"]
[null,null,"Min"]
[null,"Az","Max"]
[null,null,"Min"]
[null,"resultant","Max"]
[null,null,"Min"]
[null,"T12"]
[null,"Ax","Max"]
[null,null,"Min"]
[null,"Ay","Max"]
[null,null,"Min"]
[null,"Az","Max"]
[null,null,"Min"]
[null,"resultant","Max"]
[null,null,"Min"]
[null,"Fx","Max"]
[null,null,"Min"]
[null,"Fy","Max"]
[null,null,"Min"]
[null,"Fz","Max"]
[null,null,"Min"]
[null,"Mx","Max"]
[null,null,"Min"]
[null,"My","Max"]
[null,null,"Min"]
[null,"Abdomen"]
[null,"Ax","Max"]
[null,null,"Min"]
[null,"Abdomen left"]
[null,"Dx","Max"]
[null,null,"Min"]
[null,"Dy","Max"]
[null,null,"Min"]
[null,"Dz","Max"]
[null,null,"Min"]
[null,"Dabdomen","Max"]
[null,null,"Min"]
[null,"αy","Max"]
[null,null,"Min"]
[null,"αz","Max"]
[null,null,"Min"]
[null,"Abdomen right"]
[null,"Dx","Max"]
[null,null,"Min"]
[null,"Dy","Max"]
[null,null,"Min"]
[null,"Dz","Max"]
[null,null,"Min"]
[null,"Dabdomen","Max"]
[null,null,"Min"]
[null,"αy","Max"]
[null,null,"Min"]
[null,"αz","Max"]
[null,null,"Min"]
[null,"Pelvis"]
[null,"Ax","Max"]
[null,null,"Min"]
[null,"Ay","Max"]
[null,null,"Min"]
[null,"Az","Max"]
[null,null,"Min"]
[null,"Iliac left"]
[null,"Fx","Max"]
[null,null,"Min"]
[null,"My","Max"]
[null,null,"Min"]
[null,"Iliac right"]
[null,"Fx","Max"]
[null,null,"Min"]
[null,"My","Max"]
[null,null,"Min"]
[null,"Acetabulum left"]
[null,"Fx","Max"]
[null,null,"Min"]
[null,"Fy","Max"]
[null,null,"Min"]
[null,"Fz","Max"]
[null,null,"Min"]
[null,"Acetabulum right"]
[null,"Fx","Max"]
[null,null,"Min"]
[null,"Fy","Max"]
[null,null,"Min"]
[null,"Fz","Max"]
[null,null,"Min"]
[null,"Femur (left)"]
[null,"Fz","Max"]
[null,null,"Min"]
[null,"Femur (right)"]
[null,"Fz","Max"]
[null,null,"Min"]
[null,"Knee (left)"]
[null,"Dknee","Max"]
[null,null,"Min"]
[null,"Knee (right)"]
[null,"Dknee","Max"]
[null,null,"Min"]
[null,"Upper Tibia (left)"]
[null,"Fx","Max"]
[null,null,"Min"]
[null,"Fz","Max"]
[null,null,"Min"]
[null,"Mx","Max"]
[null,null,"Min"]
[null,"My","Max"]
[null,null,"Min"]
[null,"Upper Tibia (right)"]
[null,"Fx","Max"]
[null,null,"Min"]
[null,"Fz","Max"]
[null,null,"Min"]
[null,"Mx","Max"]
[null,null,"Min"]
[null,"My","Max"]
[null,null,"Min"]
[null,"Lower Tibia (left)"]
[null,"Fx","Max"]
[null,null,"Min"]
[null,"Fy","Max"]
[null,null,"Min"]
[null,"Fz","Max"]
[null,null,"Min"]
[null,"Mx","Max"]
[null,null,"Min"]
[null,"My","Max"]
[null,null,"Min"]
[null,"Lower Tibia (right)"]
[null,"Fx","Max"]
[null,null,"Min"]
[null,"Fy","Max"]
[null,null,"Min"]
[null,"Fz","Max"]
[null,null,"Min"]
[null,"Mx","Max"]
[null,null,"Min"]
[null,"My","Max"]
[null,null,"Min"]

{"sheet":"AOP Frontal FW","index":3,"n_rows":209,"n_cols":9,"rows_kept":209,"cut":false,"hidden":false,"merged":[[60,7,60,8],[22,7,22,8],[22,3,22,4],[30,3,30,4],[57,3,57,4],[57,7,57,8],[56,3,56,4],[56,7,56,8],[56,5,56,6],[29,7,29,8],[29,3,29,4],[29,5,29,6],[30,7,30,8],[30,5,30,6],[44,5,44,6],[44,3,44,4],[44,7,44,8],[1,1,2,2],[1,3,2,4],[1,7,2,8],[3,1,3,2],[16,3,16,4],[16,7,16,8],[15,1,15,2],[15,3,15,4],[15,7,15,8],[1,5,2,6],[15,5,15,6],[16,5,16,6],[44,1,44,2],[39,1,39,2],[35,1,35,2],[59,7,59,8],[21,1,21,2],[21,3,21,4],[21,7,21,8],[200,1,200,4],[70,1,70,8],[177,1,177,8],[58,3,58,4],[58,7,58,8],[64,1,64,2],[64,3,64,8],[62,1,62,2],[62,3,62,8],[21,5,21,6],[22,5,22,6],[185,1,185,4],[42,1,42,2],[60,1,60,2],[60,3,60,4],[60,5,60,6],[57,5,57,6],[58,5,58,6],[59,5,59,6],[59,3,59,4],[55,1,55,2]]}
[]
[null,"Frontal FW Test",null,"Driver",null,"Front Passenger",null,"Rear Passenger"]
[]
[null,{"$f":"'General Overview'!G5","v":""},null,"Value","Points","Value","Points","Value","Points"]
[null,"HEAD"]
[null,null,"Steering wheel airbag present? ",null,null,null,null,"Contact?","No"]
[null,null,"Peak resultant acceleration - g",null,{"$f":"IF(D6=\"Yes\",IF(D7<80,4,\"\"),IF(D6=\"No\",IF(E11=\"PASS\",ROUND(Sliding_Scale(D7,80,120,2,0),Round),0),\"\"))","v":""},null,{"$f":"IF(F7=\"\",0,IF(F7<80,4,\"\"))","v":0},null,{"$f":"IF(I6=\"Yes\",IF(H7<80,4,\"\"),\"\")","v":""}]
[null,null,"HIC15",null,{"$f":"IF(D6=\"Yes\",IF(D7<80,\"\",ROUND(Sliding_Scale(D8,500,700,4,0),Round)),\"\")","v":""},null,{"$f":"IF(F7<80,\"\",ROUND(Sliding_Scale(F8,500,700,4,0),Round))","v":""},null,{"$f":"IF(I6=\"Yes\",IF(H7<80,\"\",ROUND(Sliding_Scale(H8,500,700,4,0),Round)),\"\")","v":""}]
[null,null,"Resultant Acc. 3 msec exeedence - g",null,{"$f":"IF(D6=\"Yes\",IF(D7<80,\"\",ROUND(Sliding_Scale(D9,72,80,4,0),Round)),\"\")","v":""},null,{"$f":"IF(F7<80,\"\",ROUND(Sliding_Scale(F9,72,80,4,0),Round))","v":""},null,{"$f":"IF(I6=\"No\",ROUND(Sliding_Scale(H9,72,80,4,0),Round),\"\")","v":0}]
[null,null,"Deformable honeycomb faceform test"]
[null,null,"Honeycomb crush - mm",null,{"$f":"IF(D6=\"No\",IF(AND(NOT(D11=\"\"),D11<1),\"PASS\",\"FAIL\"),\"\")","v":""}]
[null,null,"Airbag contact modifier (-1)",null,{"$f":"D12","v":0},null,{"$f":"F12","v":0},null,{"$f":"H12","v":0}]
[null,null,"Hazardous airbag deployment modifier (-1)",null,{"$f":"D13","v":0},null,{"$f":"F13","v":0},null,{"$f":"H13","v":0}]
[null,null,"Incorrect airbag deployment modifier (-1)",null,{"$f":"D14","v":0},null,{"$f":"F14","v":0},null,{"$f":"H14","v":0}]
[null,null,"Head Excursion (-2/-4)",null,null,null,null,null,{"$f":"H15","v":0}]
[null,"Head Assessment",null,{"$f":"MAX(IF(D6=\"Yes\",MIN(E7:E9)+SUM(E12:E14),IF(D6=\"No\",MIN(E11:E11)+SUM(E12:E14),0)))","v":0},null,{"$f":"MAX(MIN(G7:G9)+SUM(G12:G14),0)","v":0},null,{"$f":"MAX(MIN(I7:I9)+SUM(I12:I15),0)","v":0}]
[]
[null,"NECK"]
[null,null,"Shear level exceeded - kN",null,{"$f":"ROUND(Sliding_Scale(D19,1.2,1.95,4,0),Round)","v":0},null,{"$f":"ROUND(Sliding_Scale(F19,1.2,1.95,4,0),Round)","v":0},null,{"$f":"ROUND(Sliding_Scale(H19,1.2,1.95,1,0),Round)","v":0}]
[null,null,"Tension level exceeded - kN",null,{"$f":"ROUND(Sliding_Scale(D20,1.7,2.62,4,0),Round)","v":0},null,{"$f":"ROUND(Sliding_Scale(F20,1.7,2.62,4,0),Round)","v":0},null,{"$f":"ROUND(Sliding_Scale(H20,1.7,2.62,1,0),Round)","v":0}]
[null,null,"Extension - Nm",null,{"$f":"ROUND(Sliding_Scale(D21,36,49,4,0),Round)","v":0},null,{"$f":"ROUND(Sliding_Scale(F21,36,49,4,0),Round)","v":0},null,{"$f":"ROUND(Sliding_Scale(H21,36,49,2,0),Round)","v":0}]
[null,"Neck assessment",null,{"$f":"MIN(E19:E21)","v":0},null,{"$f":"MIN(G19:G21)","v":0},null,{"$f":"SUM(I19:I21)","v":0}]
[]
[null,"CHEST"]
[null,null,"Compression - mm",null,{"$f":"ROUND(Sliding_Scale(D25,18,42,4,0),Round)","v":0},null,{"$f":"ROUND(Sliding_Scale(F25,18,42,4,0),Round)","v":0},null,{"$f":"ROUND(Sliding_Scale(H25,18,42,4,0),Round)","v":0}]
[null,null,"Viscous criterion - m/s",null,{"$f":"ROUND(Sliding_Scale(D26,0.5,1,4,0),Round)","v":0},null,{"$f":"ROUND(Sliding_Scale(F26,0.5,1,4,0),Round)","v":0},null,{"$f":"ROUND(Sliding_Scale(H26,0.5,1,4,0),Round)","v":0}]
[null,null,"Shoulder belt load - kN (-2)",null,{"$f":"IF(D27>6,-2,0)","v":0},null,{"$f":"IF(F27>6,-2,0)","v":0},null,{"$f":"IF(H27>6,-2,0)","v":0}]
[null,null,"Incorrect airbag deployment modifier (-1)",null,{"$f":"D28","v":0},null,null,null,{"$f":"H28","v":0}]
[null,null,"Steering wheel contact (-1) ",null,{"$f":"D29","v":0}]
[null,"Chest assessment",null,{"$f":"MAX(MIN(E25:E26)+E27,0)","v":0},null,{"$f":"MAX(MIN(G25:G26)+G27,0)","v":0},null,{"$f":"MAX(MIN(I25:I26)+I27,0)","v":0}]
[]
[null,"KNEE, FEMUR and PELVIS"]
[null,null,"Left Knee Slide - mm"]
[null,null,"Left Femur Compression level exceeded - kN",null,{"$f":"ROUND(Sliding_Scale(D34,2.6,6.2,4,0),Round)","v":0},null,{"$f":"ROUND(Sliding_Scale(F34,2.6,6.2,4,0),Round)","v":0},null,{"$f":"ROUND(Sliding_Scale(H34,2.6,6.2,4,0),Round)","v":0}]
[null,null,"Incorrect airbag deployment modifier (-1)",null,{"$f":"D35","v":0},null,null,null,{"$f":"H35","v":0}]
[null,"Left Knee, Femur and Pelvis assessment",null,null,{"$f":"MAX(MIN(E34:E34)+E35,0)","v":0},null,{"$f":"MAX(MIN(G33:G34),0)","v":0},null,{"$f":"MAX(MIN(I34:I34)+I35,0)","v":0}]
[null,null,"Right Knee Slide - mm"]
[null,null,"Right Femur Compression level exceeded - kN",null,{"$f":"ROUND(Sliding_Scale(D38,2.6,6.2,4,0),Round)","v":0},null,{"$f":"ROUND(Sliding_Scale(F38,2.6,6.2,4,0),Round)","v":0},null,{"$f":"ROUND(Sliding_Scale(H38,2.6,6.02,4,0),Round)","v":0}]
[null,null,"Incorrect airbag deployment modifier (-1)",null,{"$f":"D39","v":0},null,null,null,{"$f":"H39","v":0}]
[null,"Right Knee, Femur and Pelvis assessment",null,null,{"$f":"MAX(MIN(E38:E38)+E39,0)","v":0},null,{"$f":"MAX(MIN(G37:G38),0)","v":0},null,{"$f":"MAX(MIN(I38:I38)+I39,0)","v":0}]
[]
[null,null,"Iliac load drop 1ms - kN",null,{"$f":"IF(D42>=1,-4,0)","v":0},null,{"$f":"IF(F42>=1,-4,0)","v":0},null,{"$f":"IF(H42>=1,-4,0)","v":0}]
[null,"Pelvis assessment",null,{"$f":"IF(E43=0,\"Green\",IF(E43=-4,\"Red\"))","v":"Green"},{"$f":"E42","v":0},{"$f":"IF(G43=0,\"Green\",IF(G43=-4,\"Red\"))","v":"Green"},{"$f":"G42","v":0},{"$f":"IF(I43=0,\"Green\",IF(I43=-4,\"Red\"))","v":"Green"},{"$f":"I42","v":0}]
[]
[null,"Knee, Femur and Pelvis assessment",null,{"$f":"MAX(MIN(E36,E40)+E43,0)","v":0},null,{"$f":"MAX(MIN(G36,G40)+G43,0)","v":0},null,{"$f":"MAX(MIN(I36,I40)+I43,0)","v":0}]
[]
[null,"LOWER LEG"]
[null,null,"Left compression - kN"]
[null,null,"Left Upper Tibia Index "]
[null,null,"Left Lower Tibia Index"]
[]
[null,null,"Right compression - kN"]
[null,null,"Right Upper Tibia Index "]
[null,null,"Right Lower Tibia Index"]
[]
[null,"SUMMARY"]
[null,null,"Head assessment",{"$f":"D16","v":0},null,{"$f":"F16","v":0},null,{"$f":"H16","v":0}]
[null,null,"Neck assessment",{"$f":"D22","v":0},null,{"$f":"F22","v":0},null,{"$f":"H22","v":0}]
[null,null,"Chest assessment",{"$f":"D30","v":0},null,{"$f":"F30","v":0},null,{"$f":"H30","v":0}]
[null,null,"Knee, Femur and Pelvis assessment",{"$f":"D45","v":0},null,{"$f":"F45","v":0},null,{"$f":"H45","v":0}]
[null,"DUMMY SCORE",null,{"$f":"ROUND(SUM(D57:E60),Round)","v":0},null,{"$f":"ROUND(SUM(F57:G60),Round)","v":0},null,{"$f":"ROUND(SUM(H57:I60),Round)","v":0}]
[]
[null,"Door Opening",null,0]
[]
[null,"TOTAL FRONTAL FW",null,{"$f":"IF(OR(D7>=120,D8>=700,D9>=80,D19>=2.7,D20>=2.9,D21>=57,D25>=42,D26>=1,AND(I6=\"Yes\",H8>=700),H9>=80,H25>=42,H26>=1),0,ROUND(MAX(IF(F61<0.9*D61,(0.5*(MIN(D57:G57)+MIN(D58:G58)+MIN(D59:G59)+MIN(D60:G60))+H61)/4*IF('General Overview'!C17=0,2,1)+D63,(D61+H61)/4*IF('General Overview'!C17=0,2,1)+D63),0),Round))","v":0}]
[null,null,null,null,null,"INCLUDE LOGIC IF <90%"]
[]
[]
[]
[]
[null,"DUMMY MEASUREMENTS"]
[null,"Head"]
[null,"Ax","Max"]
[null,null,"Min"]
[null,"Ay","Max"]
[null,null,"Min"]
[null,"Az","Max"]
[null,null,"Min"]
[null,"Neck"]
[null,"Fx","Max"]
[null,null,"Min"]
[null,"Fy","Max"]
[null,null,"Min"]
[null,"Fz","Max"]
[null,null,"Min"]
[null,"Mx","Max"]
[null,null,"Min"]
[null,"My","Max"]
[null,null,"Min"]
[null,"Mz","Max"]
[null,null,"Min"]
[null,"Chest"]
[null,"Ax","Max"]
[null,null,"Min"]
[null,"Ay","Max"]
[null,null,"Min"]
[null,"Az","Max"]
[null,null,"Min"]
[null,"Dchest","Max"]
[null,null,"Min"]
[null,"Pelvis"]
[null,"Ax","Max"]
[null,null,"Min"]
[null,"Ay","Max"]
[null,null,"Min"]
[null,"Az","Max"]
[null,null,"Min"]
[null,"Iliac (left)"]
[null,"Fx","Max"]
[null,null,"Min"]
[null,"My","Max"]
[null,null,"Min"]
[null,"Iliac (right)"]
[null,"Fx","Max"]
[null,null,"Min"]
[null,"My","Max"]
[null,null,"Min"]
[null,"Lumbar Spine"]
[null,"Fx","Max"]
[null,null,"Min"]
[null,"Fz","Max"]
[null,null,"Min"]
[null,"My","Max"]
[null,null,"Min"]
[null,"Femur (left)"]
[null,"Fz","Max"]
[null,null,"Min"]
[null,"Femur (right)"]
[null,"Fz","Max"]
[null,null,"Min"]
[null,"Knee (left)"]
[null,"Dknee","Max"]
[null,null,"Min"]
[null,"Knee (right)"]
[null,"Dknee","Max"]
[null,null,"Min"]
[null,"Upper Tibia (left)"]
[null,"Fx","Max"]
[null,null,"Min"]
[null,"Fz","Max"]
[null,null,"Min"]
[null,"Mx","Max"]
[null,null,"Min"]
[null,"My","Max"]
[null,null,"Min"]
[null,"Upper Tibia (right)"]
[null,"Fx","Max"]
[null,null,"Min"]
[null,"Fz","Max"]
[null,null,"Min"]
[null,"Mx","Max"]
[null,null,"Min"]
[null,"My","Max"]
[null,null,"Min"]
[null,"Lower Tibia (left)"]
[null,"Fx","Max"]
[null,null,"Min"]
[null,"Fy","Max"]
[null,null,"Min"]
[null,"Fz","Max"]
[null,null,"Min"]
[null,"Mx","Max"]
[null,null,"Min"]
[null,"My","Max"]
[null,null,"Min"]
[null,"Lower Tibia (right)"]
[null,"Fx","Max"]
[null,null,"Min"]
[null,"Fy","Max"]
[null,null,"Min"]
[null,"Fz","Max"]
[null,null,"Min"]
[null,"Mx","Max"]
[null,null,"Min"]
[null,"My","Max"]
[null,null,"Min"]
[]
[null,"VEHICLE MEASUREMENTS"]
[null,"Vehicle B-post"]
[null,"Ax","Max"]
[null,null,"Min"]
[null,"Seatbelt"]
[null,"Fseatbelt","Max"]
[null,null,"Min"]
[]
[null,"STATIC MEASURMENTS"]
[null,"Steering wheel"]
[null,null,"Fore/aft displacement - mm",null,{"$f":"IF(D188>0,\"rearward\",IF(D188<0,\"forward\",\"\"))","v":""}]
[null,null,"Vertical displacement - mm",null,{"$f":"IF(D189>0,\"upward\",IF(D189<0,\"downward\",\"\"))","v":""}]
[null,null,"Lateral displacement - mm",null,{"$f":"IF(D190>0,\"left\",IF(D190<0,\"right\",\"\"))","v":""}]
[null,"A-pillar"]
[null,null,"A-Pillar displacement - mm"]
[null,"Pedals"]
[null,null,"Brake Vertical displacement - mm",null,{"$f":"IF(D194=\"N/A\",\"\",IF(D194>0,\"upward\",IF(D194<0,\"downward\",\"\")))","v":""}]
[null,null,"Clutch Vertical displacement - mm",null,{"$f":"IF(D195=\"N/A\",\"\",IF(D195>0,\"upward\",IF(D195<0,\"downward\",\"\")))","v":""}]
[null,null,"Accel Vertical displacement - mm",null,{"$f":"IF(D196=\"N/A\",\"\",IF(D196>0,\"upward\",IF(D196<0,\"downward\",\"\")))","v":""}]
[null,null,"Brake Horizontal displacement - mm",null,{"$f":"IF(D197=\"N/A\",\"\",IF(D197>0,\"rearward\",IF(D197<0,\"forward\",\"\")))","v":""}]
[null,null,"Clutch Horizontal displacement - mm",null,{"$f":"IF(D198=\"N/A\",\"\",IF(D198>0,\"rearward\",IF(D198<0,\"forward\",\"\")))","v":""}]
[null,null,"Accel Horizontal displacement - mm",null,{"$f":"IF(D199=\"N/A\",\"\",IF(D199>0,\"rearward\",IF(D199<0,\"forward\",\"\")))","v":""}]
[]
[null,"TEST DETAILS"]
[null,"Vehicle"]
[null,null,"VIN number"]
[null,null,"Test weight - kg"]
[null,"Test"]
[null,null,"Impact speed - km/h"]
[null,null,"Impact location - mm"]
[null,null,"Vertical"]
[null,null,"Horizontal"]

{"sheet":"AOP Side MDB","index":4,"n_rows":158,"n_cols":5,"rows_kept":158,"cut":false,"hidden":false,"merged":[[17,1,17,2],[10,3,10,4],[1,1,2,2],[3,1,3,2],[1,3,2,4],[9,1,9,2],[9,3,9,4],[25,3,25,4],[43,1,43,2],[44,3,44,4],[26,3,26,4],[37,3,37,4],[42,3,42,4],[25,1,25,2],[31,1,31,2],[36,1,36,2],[36,3,36,4],[149,1,149,4],[58,1,58,4],[46,3,46,4],[41,1,41,2],[41,3,41,4],[52,1,52,2],[52,3,52,4],[48,1,48,2],[48,3,48,4],[47,3,47,4],[50,1,50,2],[50,3,50,4],[45,3,45,4]]}
[]
[null,"Side MDB Test",null,"Driver"]
[]
[null,{"$f":"'General Overview'!G6","v":""},null,"Value","Points"]
[null,"HEAD"]
[null,null,"Peak resultant acceleration - g"]
[null,null,"HIC15",null,{"$f":"ROUND(Sliding_Scale(D7,500,700,4,0),Round)","v":0}]
[null,null,"Resultant Acc. 3 msec exeedence - g",null,{"$f":"ROUND(Sliding_Scale(D8,72,80,4,0),Round)","v":0}]
[null,null,"Incorrect airbag deployment modifier (-1)",null,{"$f":"D9","v":0}]
[null,"Head assessment",null,{"$f":"MAX(MIN(E7:E8)+E9,0)","v":0}]
[]
[null,"CHEST"]
[]
[null,null,"Lateral compression - mm"]
[null,null,"Top",null,{"$f":"ROUND(Sliding_Scale(D15,28,50,4,0),Round)","v":0}]
[null,null,"Middle",null,{"$f":"ROUND(Sliding_Scale(D16,28,50,4,0),Round)","v":0}]
[null,null,"Bottom",null,{"$f":"ROUND(Sliding_Scale(D17,28,50,4,0),Round)","v":0}]
[null,"Chest rib assessment",null,null,{"$f":"MIN(E15:E17)","v":0}]
[null,null,"Shoulder Force modifier (-4)",null,{"$f":"IF(D20>=3,-4,0)","v":0}]
[null,null,"Shoulder Fy - kN"]
[null,null,"Viscous Criterion modifier (-4)",null,{"$f":"IF(OR(D22>=1,D23>=1,D24>=1),-4,0)","v":0}]
[null,null," Top rib Viscous Criterion - m/s"]
[null,null,"Middle rib Viscous Criterion - m/s"]
[null,null,"Bottom rib Viscous Criterion - m/s"]
[null,null,"Incorrect airbag deployment modifier (-1)",null,{"$f":"D25","v":0}]
[null,"Chest assessment",null,{"$f":"MAX(MIN(E15:E17)+SUM(E19,E21,E25),0)","v":0}]
[]
[null,"ABDOMEN"]
[null,null,"Lateral compression - mm"]
[null,null,"Top",null,{"$f":"ROUND(Sliding_Scale(D30,47,65,4,0),Round)","v":0}]
[null,null,"Bottom",null,{"$f":"ROUND(Sliding_Scale(D31,47,65,4,0),Round)","v":0}]
[null,"Abdomen rib assessment",null,null,{"$f":"MIN(E30:E31)","v":0}]
[null,null,"Viscous Criterion modifier (-4)",null,{"$f":"IF(OR(D34>=1,D35>=1),-4,0)","v":0}]
[null,null," Top rib Viscous Criterion - m/s"]
[null,null,"Bottom rib Viscous Criterion - m/s"]
[null,null,"Incorrect airbag deployment modifier (-1)",null,{"$f":"D36","v":0}]
[null,"Abdomen assessment",null,{"$f":"MAX(MIN(E30:E31)+SUM(E33,E36),0)","v":0}]
[]
[null,"PELVIS"]
[null,null,"Pubic Symphysis force - kN",null,{"$f":"ROUND(Sliding_Scale(D40,1.7,2.8,4,0),Round)","v":0}]
[null,null,"Incorrect airbag deployment modifier (-1)",null,{"$f":"D41","v":0}]
[null,"Pelvis assessment",null,{"$f":"MAX(E40+E41,0)","v":0}]
[]
[null,"SUMMARY"]
[null,null,"Head assessment",{"$f":"D10","v":0}]
[null,null,"Chest assessment",{"$f":"D26","v":0}]
[null,null,"Abdomen assessment",{"$f":"D37","v":0}]
[null,null,"Pelvis assessment",{"$f":"D42","v":0}]
[null,"DUMMY SCORE",null,{"$f":"SUM(D45:E48)","v":0}]
[]
[null,"Door Opening",null,0]
[]
[null,"TOTAL SIDE MDB",null,{"$f":"ROUND(IF(OR(E7=0,E8=0,E15=0,E16=0,E17=0,E30=0,E31=0,E40=0),0,(D49+D51)/16*6),Round)","v":0}]
[]
[]
[]
[]
[]
[null,"DUMMY MEASUREMENTS"]
[null,"Head"]
[null,"Ax","Max"]
[null,null,"Min"]
[null,"Ay","Max"]
[null,null,"Min"]
[null,"Az","Max"]
[null,null,"Min"]
[null,"Neck"]
[null,"Fx","Max"]
[null,null,"Min"]
[null,"Fy","Max"]
[null,null,"Min"]
[null,"Fz","Max"]
[null,null,"Min"]
[null,"Mx","Max"]
[null,null,"Min"]
[null,"My","Max"]
[null,null,"Min"]
[null,"Mz","Max"]
[null,null,"Min"]
[null,"Shoulder"]
[null,"Fx","Max"]
[null,null,"Min"]
[null,"Fy","Max"]
[null,null,"Min"]
[null,"Fz","Max"]
[null,null,"Min"]
[null,"D","Max"]
[null,null,"Min"]
[null,"α","Max"]
[null,null,"Min"]
[null,"Thorax"]
[null,"D01","Max"]
[null,null,"Min"]
[null,"α01","Max"]
[null,null,"Min"]
[null,"D02","Max"]
[null,null,"Min"]
[null,"α02","Max"]
[null,null,"Min"]
[null,"D03","Max"]
[null,null,"Min"]
[null,"α03","Max"]
[null,null,"Min"]
[null,"Abdomen"]
[null,"D01","Max"]
[null,null,"Min"]
[null,"α01","Max"]
[null,null,"Min"]
[null,"D02","Max"]
[null,null,"Min"]
[null,"α02","Max"]
[null,null,"Min"]
[null,"T12"]
[null,"Ax","Max"]
[null,null,"Min"]
[null,"Ay","Max"]
[null,null,"Min"]
[null,"Az","Max"]
[null,null,"Min"]
[null,"Pelvis"]
[null,"Ax","Max"]
[null,null,"Min"]
[null,"Ay","Max"]
[null,null,"Min"]
[null,"Az","Max"]
[null,null,"Min"]
[null,"Fy","Max"]
[null,null,"Min"]
[null,"Femur (left)"]
[null,"Fx","Max"]
[null,null,"Min"]
[null,"Fy","Max"]
[null,null,"Min"]
[null,"Fz","Max"]
[null,"Femur (right)"]
[null,"Fx","Max"]
[null,null,"Min"]
[null,"Fy","Max"]
[null,null,"Min"]
[null,"Fz","Max"]
[]
[null,"VEHICLE MEASUREMENTS"]
[null,"Vehicle B-post"]
[null,"Ay","Max"]
[null,null,"Min"]
[null,"Trolley"]
[null,"Ax","Max"]
[null,null,"Min"]
[]
[null,"TEST DETAILS"]
[null,"Vehicle"]
[null,null,"VIN number"]
[null,null,"Test weight - kg"]
[null,"Test"]
[null,null,"Impact speed - km/h"]
[null,null,"Impact location - mm"]
[null,null,"Vertical"]
[null,null,"Horizontal"]

{"sheet":"AOP Side Pole","index":5,"n_rows":177,"n_cols":7,"rows_kept":177,"cut":false,"hidden":false,"merged":[[1,1,2,2],[3,1,3,2],[10,3,10,4],[1,3,2,4],[10,1,10,2],[17,1,17,2],[11,3,11,4],[50,5,50,6],[25,1,25,2],[25,3,25,4],[31,1,31,2],[26,3,26,4],[36,1,36,2],[36,3,36,4],[41,1,41,2],[41,3,41,4],[48,1,48,2],[48,3,48,4],[168,1,168,4],[77,1,77,4],[37,3,37,4],[42,3,42,4],[71,1,71,2],[43,1,43,2],[44,3,44,4],[45,3,45,4],[46,3,46,4],[47,3,47,4],[69,1,69,2],[50,3,50,4],[71,3,71,6],[67,1,67,2],[67,3,67,6],[69,3,69,6]]}
[]
[null,"Side Pole Test",null,"Driver"]
[]
[null,{"$f":"'General Overview'!G7","v":""},null,"Value","Points"]
[null,"HEAD"]
[null,null,"Direct head contact with pole",null,{"$f":"IF(D6=\"\",0,IF(D6=\"Yes\",0,4))","v":0}]
[null,null,"Peak resultant acceleration - g",null,{"$f":"IF(D7=\"\",0,IF(D7<80,4,0))","v":0}]
[null,null,"HIC15",null,{"$f":"IF(D8=\"\",0,IF(D8<700,4,0))","v":0}]
[null,null,"Resultant Acc. 3 msec exeedence - g"]
[null,null,"Incorrect airbag deployment modifier (-1)",null,{"$f":"D10","v":0}]
[null,"Head assessment",null,{"$f":"MAX(MIN(E6:E8)+E10,0)","v":0}]
[]
[null,"CHEST"]
[null,null,"Lateral compression - mm"]
[null,null,"Top",null,{"$f":"ROUND(Sliding_Scale(D15,28,50,4,0),Round)","v":0}]
[null,null,"Middle",null,{"$f":"ROUND(Sliding_Scale(D16,28,50,4,0),Round)","v":0}]
[null,null,"Bottom",null,{"$f":"ROUND(Sliding_Scale(D17,28,50,4,0),Round)","v":0}]
[null,"Chest rib assessment",null,null,{"$f":"MIN(E15:E17)","v":0}]
[null,null,"Shoulder Force modifier (-4)",null,{"$f":"IF(D20>=3,-4,0)","v":0}]
[null,null,"Shoulder Fy - kN"]
[null,null,"Viscous Criterion modifier (-4)",null,{"$f":"IF(OR(D22>=1,D23>=1,D24>=1),-4,0)","v":0}]
[null,null," Top rib Viscous Criterion - m/s"]
[null,null,"Middle rib Viscous Criterion - m/s"]
[null,null,"Bottom rib Viscous Criterion - m/s"]
[null,null,"Incorrect airbag deployment modifier (-1)",null,{"$f":"D25","v":0}]
[null,"Chest assessment",null,{"$f":"MAX(MIN(E15:E17)+SUM(E19,E21,E25),0)","v":0}]
[]
[null,"ABDOMEN"]
[null,null,"Lateral compression - mm"]
[null,null,"Top",null,{"$f":"ROUND(Sliding_Scale(D30,47,65,4,0),Round)","v":0}]
[null,null,"Bottom",null,{"$f":"ROUND(Sliding_Scale(D31,47,65,4,0),Round)","v":0}]
[null,"Abdomen rib assessment",null,null,{"$f":"MIN(E30:E31)","v":0}]
[null,null,"Viscous Criterion modifier (-4)",null,{"$f":"IF(OR(D34>=1,D35>=1),-4,0)","v":0}]
[null,null," Top rib Viscous Criterion - m/s"]
[null,null,"Bottom rib Viscous Criterion - m/s"]
[null,null,"Incorrect airbag deployment modifier (-1)",null,{"$f":"D36","v":0}]
[null,"Abdomen assessment",null,{"$f":"MAX(MIN(E30:E31)+SUM(E33,E36),0)","v":0}]
[]
[null,"PELVIS"]
[null,null,"Pubic Symphysis force - kN",null,{"$f":"ROUND(Sliding_Scale(D40,1.7,2.8,4,0),Round)","v":0}]
[null,null,"Incorrect airbag deployment modifier (-1)",null,{"$f":"D41","v":0}]
[null,"Pelvis assessment",null,{"$f":"MAX(E40+E41,0)","v":0}]
[]
[null,"SUMMARY"]
[null,null,"Head assessment",{"$f":"D11","v":0}]
[null,null,"Chest assessment",{"$f":"D26","v":0}]
[null,null,"Abdomen assessment",{"$f":"D37","v":0}]
[null,null,"Pelvis assessment",{"$f":"D42","v":0}]
[null,"DUMMY SCORE",null,{"$f":"SUM(D45:E48)","v":0}]
[]
[null,"HPD Assessment",null,"FRONT SEATS",null,"REAR SEATS"]
[null,null,"H-point"]
[null,null,"H-point(X) - mm"]
[null,null,"H-point(Z) - mm"]
[null,null,"seat travel 5th-50th - mm"]
[null,null,"seat travel 50th-95th - mm"]
[null,null,"rear seat travel - mm"]
[]
[null,null,"XCoG,5th",{"$f":"D53+126-D55","v":126},null,{"$f":"F53+126-F57","v":126}]
[null,null,"ZCoG,5th",{"$f":"D54+594","v":594},null,{"$f":"F54+594","v":594}]
[null,null,"XCoG,95th",{"$f":"D53+147+D56","v":147},null,{"$f":"F53+147","v":147}]
[null,null,"ZCoG,95th",{"$f":"D54+693","v":693},null,{"$f":"F54+693","v":693}]
[]
[null,null,"HPD modifier (-2/-4)",null,{"$f":"IF(D65=\"OEM data\",0,IF(OR(D65=\"Fail\",D66=\"Fail\",D67=\"Fail\"),-2*IF('General Overview'!C17=0,2,1),0))","v":0},null,{"$f":"IF(F65=\"OEM data\",0,IF(OR(F65=\"Fail\",F66=\"Fail\",F67=\"Fail\"),-2,0))","v":0}]
[null,null,"HPD assessment zone coverage"]
[null,null,"seems within HPD no wider than 15mm"]
[null,null,"uninflated areas no larger than 50mm"]
[null,"HPD assessment",null,{"$f":"E64+G64","v":0}]
[]
[null,"Door Opening",null,0]
[]
[null,"TOTAL SIDE POLE",null,{"$f":"MAX(ROUND(IF(OR(D6=\"Yes\",E7=0,E8=0,D15>=55,D16>=55,D17>=55,E30=0,E31=0,E40=0),0,(D49+D68+D70)/16*6),Round),0)","v":0}]
[]
[]
[]
[]
[]
[null,"DUMMY MEASUREMENTS"]
[null,"Head"]
[null,"Ax","Max"]
[null,null,"Min"]
[null,"Ay","Max"]
[null,null,"Min"]
[null,"Az","Max"]
[null,null,"Min"]
[null,"Neck"]
[null,"Fx","Max"]
[null,null,"Min"]
[null,"Fy","Max"]
[null,null,"Min"]
[null,"Fz","Max"]
[null,null,"Min"]
[null,"Mx","Max"]
[null,null,"Min"]
[null,"My","Max"]
[null,null,"Min"]
[null,"Mz","Max"]
[null,null,"Min"]
[null,"Shoulder"]
[null,"Fx","Max"]
[null,null,"Min"]
[null,"Fy","Max"]
[null,null,"Min"]
[null,"Fz","Max"]
[null,null,"Min"]
[null,"D","Max"]
[null,null,"Min"]
[null,"α","Max"]
[null,null,"Min"]
[null,"Thorax"]
[null,"D01","Max"]
[null,null,"Min"]
[null,"α01","Max"]
[null,null,"Min"]
[null,"D02","Max"]
[null,null,"Min"]
[null,"α02","Max"]
[null,null,"Min"]
[null,"D03","Max"]
[null,null,"Min"]
[null,"α03","Max"]
[null,null,"Min"]
[null,"Abdomen"]
[null,"D01","Max"]
[null,null,"Min"]
[null,"α01","Max"]
[null,null,"Min"]
[null,"D02","Max"]
[null,null,"Min"]
[null,"α02","Max"]
[null,null,"Min"]
[null,"T12"]
[null,"Ax","Max"]
[null,null,"Min"]
[null,"Ay","Max"]
[null,null,"Min"]
[null,"Az","Max"]
[null,null,"Min"]
[null,"Pelvis"]
[null,"Ax","Max"]
[null,null,"Min"]
[null,"Ay","Max"]
[null,null,"Min"]
[null,"Az","Max"]
[null,null,"Min"]
[null,"Fy","Max"]
[null,null,"Min"]
[null,"Femur (left)"]
[null,"Fx","Max"]
[null,null,"Min"]
[null,"Fy","Max"]
[null,null,"Min"]
[null,"Fz","Max"]
[null,"Femur (right)"]
[null,"Fx","Max"]
[null,null,"Min"]
[null,"Fy","Max"]
[null,null,"Min"]
[null,"Fz","Max"]
[]
[null,"VEHICLE MEASUREMENTS"]
[null,"Vehicle B-post"]
[null,"Ay","Max"]
[null,null,"Min"]
[null,"Trolley"]
[null,"Ax","Max"]
[null,null,"Min"]
[]
[null,"TEST DETAILS"]
[null,"Vehicle"]
[null,null,"VIN number"]
[null,null,"Test weight - kg"]
[null,"Test"]
[null,null,"Impact speed - km/h"]
[null,null,"Impact location - mm"]
[null,null,"Vertical"]
[null,null,"Horizontal"]

{"sheet":"AOP Farside","index":6,"n_rows":65,"n_cols":7,"rows_kept":65,"cut":false,"hidden":false,"merged":[[52,5,52,6],[39,5,39,6],[41,5,41,6],[43,5,43,6],[44,3,44,4],[44,5,44,6],[43,3,43,4],[45,5,45,6],[38,5,38,6],[46,5,46,6],[42,5,42,6],[1,1,2,2],[1,3,2,4],[3,1,3,2],[13,1,13,2],[13,3,13,4],[7,3,7,4],[8,3,8,4],[7,1,7,2],[1,5,2,6],[13,5,13,6],[14,5,14,6],[25,5,25,6],[26,5,26,6],[7,5,7,6],[8,5,8,6],[46,3,46,4],[64,1,64,2],[52,1,52,2],[52,3,52,4],[39,3,39,4],[40,1,40,2],[41,3,41,4],[64,3,64,6],[62,1,62,2],[62,3,62,6],[54,1,54,2],[54,3,54,4],[54,5,54,6],[42,3,42,4],[45,1,45,2],[45,3,45,4],[38,1,38,2],[38,3,38,4],[14,3,14,4],[32,1,32,2],[36,1,36,2],[25,1,25,2],[25,3,25,4],[26,3,26,4],[37,1,37,4]]}
[]
[null,"Far Side Tests",null,"AE-MDB",null,"Pole"]
[]
[null,"OEM DATA",null,"Value","Points","Value","Points"]
[null,"EXCURSION ZONE"]
[null,null,"Excursion zone"]
[null,null,"Red line >125 mm outboard of the orange line"]
[null,"Excursion zone scaling factor",null,{"$f":"IF('General Overview'!$E$34=\"Standard\",IF(OR(D6=\"Green\",D6=\"Yellow\"),\"100%\",IF(D6=\"Orange\",\"75%\",IF(D6=\"Red\",IF(D7=\"No\",\"Head & Chest 0 points\",IF(D7=\"Yes\",\"Head 2 points & Chest 0 points\",\"Enter data in D10\")),IF(D6=\"Capping\",\"Both tests capped\",\"No excursion entered\")))),IF(D6=\"Green\",\"100%\",IF(D6=\"Yellow\",\"50%\",IF(D6=\"Orange\",\"25%\",IF(D6=\"Red\",\"25% and Head & Chest 0 points\",IF(D6=\"Capping\",\"Both tests capped\",\"No excursion entered\"))))))","v":"No excursion entered"},null,{"$f":"IF('General Overview'!$E$34=\"Standard\",IF(OR(F6=\"Green\",F6=\"Yellow\"),\"100%\",IF(F6=\"Orange\",\"75%\",IF(F6=\"Red\",IF(F7=\"No\",\"Head & Chest 0 points\",IF(F7=\"Yes\",\"Head 2 points & Chest 0 points\",\"Enter data in D10\")),IF(F6=\"Capping\",\"Both tests capped\",\"No excursion entered\")))),IF(F6=\"Green\",\"100%\",IF(F6=\"Yellow\",\"50%\",IF(F6=\"Orange\",\"25%\",IF(F6=\"Red\",\"25% and Head & Chest 0 points\",IF(F6=\"Capping\",\"Both tests capped\",\"No excursion entered\"))))))","v":"No excursion entered"}]
[]
[null,"HEAD"]
[null,null,"Hard contact"]
[null,null,"HIC15",null,{"$f":"IF(D11=\"Yes\",Sliding_Scale(D12,500,700,IF('General Overview'!$E$34=\"Standard\",IF(OR(D6=\"Green\",D6=\"Yellow\"),4,IF(D6=\"Orange\",3,IF(D6=\"Red\",IF(D7=\"No\",0,IF(D7=\"Yes\",2)),IF(D6=\"Capping\",0,0)))),IF(D6=\"Green\",4,IF(D6=\"Yellow\",2,IF(D6=\"Orange\",1,IF(D6=\"Red\",0,IF(D6=\"Capping\",0,0)))))),0),\"\")","v":""},null,{"$f":"IF(F11=\"Yes\",Sliding_Scale(F12,500,700,IF('General Overview'!$E$34=\"Standard\",IF(OR(F6=\"Green\",F6=\"Yellow\"),4,IF(F6=\"Orange\",3,IF(F6=\"Red\",IF(F7=\"No\",0,IF(F7=\"Yes\",2)),IF(F6=\"Capping\",0,0)))),IF(F6=\"Green\",4,IF(F6=\"Yellow\",2,IF(F6=\"Orange\",1,IF(F6=\"Red\",0,IF(F6=\"Capping\",0,0)))))),0),\"\")","v":""}]
[null,null,"Resultant Acc. 3 msec exeedence - g",null,{"$f":"Sliding_Scale(D13,72,80,IF('General Overview'!$E$34=\"Standard\",IF(OR(D6=\"Green\",D6=\"Yellow\"),4,IF(D6=\"Orange\",3,IF(D6=\"Red\",IF(D7=\"No\",0,IF(D7=\"Yes\",2)),IF(D6=\"Capping\",0,0)))),IF(D6=\"Green\",4,IF(D6=\"Yellow\",2,IF(D6=\"Orange\",1,IF(D6=\"Red\",0,IF(D6=\"Capping\",0,0)))))),0)","v":0},null,{"$f":"Sliding_Scale(F13,72,80,IF('General Overview'!$E$34=\"Standard\",IF(OR(F6=\"Green\",F6=\"Yellow\"),4,IF(F6=\"Orange\",3,IF(F6=\"Red\",IF(F7=\"No\",0,IF(F7=\"Yes\",2)),IF(F6=\"Capping\",0,0)))),IF(F6=\"Green\",4,IF(F6=\"Yellow\",2,IF(F6=\"Orange\",1,IF(F6=\"Red\",0,IF(F6=\"Capping\",0,0)))))),0)","v":0}]
[null,"Head assessment",null,{"$f":"MIN(E12:E13)","v":0},null,{"$f":"MIN(G12:G13)","v":0}]
[]
[null,"NECK"]
[null,null,"Tension Fz - kN"]
[null,null,"Upper Neck",null,{"$f":"IF(D18=\"\",0,IF(D18<=3.74,IF('General Overview'!$E$34=\"Standard\",IF(OR(D6=\"Green\",D6=\"Yellow\"),4,IF(D6=\"Orange\",3,IF(D6=\"Red\",4,IF(D6=\"Capping\",0,0)))),IF(D6=\"Green\",4,IF(D6=\"Yellow\",2,IF(D6=\"Orange\",1,IF(D6=\"Red\",1,IF(D6=\"Capping\",0,0)))))),0))","v":0},null,{"$f":"IF(F18=\"\",0,IF(F18<=3.74,IF('General Overview'!$E$34=\"Standard\",IF(OR(F6=\"Green\",F6=\"Yellow\"),4,IF(F6=\"Orange\",3,IF(F6=\"Red\",4,IF(F6=\"Capping\",0,0)))),IF(F6=\"Green\",4,IF(F6=\"Yellow\",2,IF(F6=\"Orange\",1,IF(F6=\"Red\",1,IF(F6=\"Capping\",0,0)))))),0))","v":0}]
[null,null,"Lower Neck",null,{"$f":"IF(D19=\"\",0,IF(D19<=3.74,IF('General Overview'!$E$34=\"Standard\",IF(OR(D6=\"Green\",D6=\"Yellow\"),4,IF(D6=\"Orange\",3,IF(D6=\"Red\",4,IF(D6=\"Capping\",0,0)))),IF(D6=\"Green\",4,IF(D6=\"Yellow\",2,IF(D6=\"Orange\",1,IF(D6=\"Red\",1,IF(D6=\"Capping\",0,0)))))),0))","v":0},null,{"$f":"IF(F19=\"\",0,IF(F19<=3.74,IF('General Overview'!$E$34=\"Standard\",IF(OR(F6=\"Green\",F6=\"Yellow\"),4,IF(F6=\"Orange\",3,IF(F6=\"Red\",4,IF(F6=\"Capping\",0,0)))),IF(F6=\"Green\",4,IF(F6=\"Yellow\",2,IF(F6=\"Orange\",1,IF(F6=\"Red\",1,IF(F6=\"Capping\",0,0)))))),0))","v":0}]
[null,null,"Lateral Flexion - Nm"]
[null,null,"MxOC",null,{"$f":"Sliding_Scale(D21,162,248,IF('General Overview'!$E$34=\"Standard\",IF(OR(D6=\"Green\",D6=\"Yellow\"),4,IF(D6=\"Orange\",3,IF(D6=\"Red\",4,IF(D6=\"Capping\",0,0)))),IF(D6=\"Green\",4,IF(D6=\"Yellow\",2,IF(D6=\"Orange\",1,IF(D6=\"Red\",1,IF(D6=\"Capping\",0,0)))))),0)","v":0},null,{"$f":"Sliding_Scale(F21,162,248,IF('General Overview'!$E$34=\"Standard\",IF(OR(F6=\"Green\",F6=\"Yellow\"),4,IF(F6=\"Orange\",3,IF(F6=\"Red\",4,IF(F6=\"Capping\",0,0)))),IF(F6=\"Green\",4,IF(F6=\"Yellow\",2,IF(F6=\"Orange\",1,IF(F6=\"Red\",1,IF(F6=\"Capping\",0,0)))))),0)","v":0}]
[null,null,"Mx (base of neck)",null,{"$f":"Sliding_Scale(D22,162,248,IF('General Overview'!$E$34=\"Standard\",IF(OR(D6=\"Green\",D6=\"Yellow\"),4,IF(D6=\"Orange\",3,IF(D6=\"Red\",4,IF(D6=\"Capping\",0,0)))),IF(D6=\"Green\",4,IF(D6=\"Yellow\",2,IF(D6=\"Orange\",1,IF(D6=\"Red\",1,IF(D6=\"Capping\",0,0)))))),0)","v":0},null,{"$f":"Sliding_Scale(F22,162,248,IF('General Overview'!$E$34=\"Standard\",IF(OR(F6=\"Green\",F6=\"Yellow\"),4,IF(F6=\"Orange\",3,IF(F6=\"Red\",4,IF(F6=\"Capping\",0,0)))),IF(F6=\"Green\",4,IF(F6=\"Yellow\",2,IF(F6=\"Orange\",1,IF(F6=\"Red\",1,IF(F6=\"Capping\",0,0)))))),0)","v":0}]
[null,null,"Extension - Nm"]
[null,null,"MyOC",null,{"$f":"IF(D24=\"\",0,IF(D24<=100,IF('General Overview'!$E$34=\"Standard\",IF(OR(D6=\"Green\",D6=\"Yellow\"),4,IF(D6=\"Orange\",3,IF(D6=\"Red\",4,IF(D6=\"Capping\",0,0)))),IF(D6=\"Green\",4,IF(D6=\"Yellow\",2,IF(D6=\"Orange\",1,IF(D6=\"Red\",1,IF(D6=\"Capping\",0,0)))))),0))","v":0},null,{"$f":"IF(F24=\"\",0,IF(F24<=100,IF('General Overview'!$E$34=\"Standard\",IF(OR(F6=\"Green\",F6=\"Yellow\"),4,IF(F6=\"Orange\",3,IF(F6=\"Red\",4,IF(F6=\"Capping\",0,0)))),IF(F6=\"Green\",4,IF(F6=\"Yellow\",2,IF(F6=\"Orange\",1,IF(F6=\"Red\",1,IF(F6=\"Capping\",0,0)))))),0))","v":0}]
[null,null,"My (base of neck)"]
[null,"Neck assessment",null,{"$f":"MIN(E18:E25)","v":0},null,{"$f":"MIN(G18:G25)","v":0}]
[]
[null,"CHEST & ABDOMEN"]
[null,null,"Lateral compression - mm"]
[null,null,"Top",null,{"$f":"ROUND(Sliding_Scale(D30,28,50,IF('General Overview'!$E$34=\"Standard\",IF(OR(D6=\"Green\",D6=\"Yellow\"),4,IF(D6=\"Orange\",3,IF(D6=\"Red\",0,IF(D6=\"Capping\",0,0)))),IF(D6=\"Green\",4,IF(D6=\"Yellow\",2,IF(D6=\"Orange\",1,IF(D6=\"Red\",0,IF(D6=\"Capping\",0,0)))))),0),Round)","v":0},null,{"$f":"ROUND(Sliding_Scale(F30,28,50,IF('General Overview'!$E$34=\"Standard\",IF(OR(F6=\"Green\",F6=\"Yellow\"),4,IF(F6=\"Orange\",3,IF(F6=\"Red\",0,IF(F6=\"Capping\",0,0)))),IF(F6=\"Green\",4,IF(F6=\"Yellow\",2,IF(F6=\"Orange\",1,IF(F6=\"Red\",0,IF(F6=\"Capping\",0,0)))))),0),Round)","v":0}]
[null,null,"Middle",null,{"$f":"ROUND(Sliding_Scale(D31,28,50,IF('General Overview'!$E$34=\"Standard\",IF(OR(D6=\"Green\",D6=\"Yellow\"),4,IF(D6=\"Orange\",3,IF(D6=\"Red\",0,IF(D6=\"Capping\",0,0)))),IF(D6=\"Green\",4,IF(D6=\"Yellow\",2,IF(D6=\"Orange\",1,IF(D6=\"Red\",0,IF(D6=\"Capping\",0,0)))))),0),Round)","v":0},null,{"$f":"ROUND(Sliding_Scale(F31,28,50,IF('General Overview'!$E$34=\"Standard\",IF(OR(F6=\"Green\",F6=\"Yellow\"),4,IF(F6=\"Orange\",3,IF(F6=\"Red\",0,IF(F6=\"Capping\",0,0)))),IF(F6=\"Green\",4,IF(F6=\"Yellow\",2,IF(F6=\"Orange\",1,IF(F6=\"Red\",0,IF(F6=\"Capping\",0,0)))))),0),Round)","v":0}]
[null,null,"Bottom",null,{"$f":"ROUND(Sliding_Scale(D32,28,50,IF('General Overview'!$E$34=\"Standard\",IF(OR(D6=\"Green\",D6=\"Yellow\"),4,IF(D6=\"Orange\",3,IF(D6=\"Red\",0,IF(D6=\"Capping\",0,0)))),IF(D6=\"Green\",4,IF(D6=\"Yellow\",2,IF(D6=\"Orange\",1,IF(D6=\"Red\",0,IF(D6=\"Capping\",0,0)))))),0),Round)","v":0},null,{"$f":"ROUND(Sliding_Scale(F32,28,50,IF('General Overview'!$E$34=\"Standard\",IF(OR(F6=\"Green\",F6=\"Yellow\"),4,IF(F6=\"Orange\",3,IF(F6=\"Red\",0,IF(F6=\"Capping\",0,0)))),IF(F6=\"Green\",4,IF(F6=\"Yellow\",2,IF(F6=\"Orange\",1,IF(F6=\"Red\",0,IF(F6=\"Capping\",0,0)))))),0),Round)","v":0}]
[null,"Abdomen rib assessment",null,null,{"$f":"MIN(E30:E32)","v":0},null,{"$f":"MIN(G30:G32)","v":0}]
[null,null,"Lateral compression - mm"]
[null,null,"Top",null,{"$f":"ROUND(Sliding_Scale(D35,47,65,IF('General Overview'!$E$34=\"Standard\",IF(OR(D6=\"Green\",D6=\"Yellow\"),4,IF(D6=\"Orange\",3,IF(D6=\"Red\",0,IF(D6=\"Capping\",0,0)))),IF(D6=\"Green\",4,IF(D6=\"Yellow\",2,IF(D6=\"Orange\",1,IF(D6=\"Red\",0,IF(D6=\"Capping\",0,0)))))),0),Round)","v":0},null,{"$f":"ROUND(Sliding_Scale(F35,47,65,IF('General Overview'!$E$34=\"Standard\",IF(OR(F6=\"Green\",F6=\"Yellow\"),4,IF(F6=\"Orange\",3,IF(F6=\"Red\",0,IF(F6=\"Capping\",0,0)))),IF(F6=\"Green\",4,IF(F6=\"Yellow\",2,IF(F6=\"Orange\",1,IF(F6=\"Red\",0,IF(F6=\"Capping\",0,0)))))),0),Round)","v":0}]
[null,null,"Bottom",null,{"$f":"ROUND(Sliding_Scale(D36,47,65,IF('General Overview'!$E$34=\"Standard\",IF(OR(D6=\"Green\",D6=\"Yellow\"),4,IF(D6=\"Orange\",3,IF(D6=\"Red\",0,IF(D6=\"Capping\",0,0)))),IF(D6=\"Green\",4,IF(D6=\"Yellow\",2,IF(D6=\"Orange\",1,IF(D6=\"Red\",0,IF(D6=\"Capping\",0,0)))))),0),Round)","v":0},null,{"$f":"ROUND(Sliding_Scale(F36,47,65,IF('General Overview'!$E$34=\"Standard\",IF(OR(F6=\"Green\",F6=\"Yellow\"),4,IF(F6=\"Orange\",3,IF(F6=\"Red\",0,IF(F6=\"Capping\",0,0)))),IF(F6=\"Green\",4,IF(F6=\"Yellow\",2,IF(F6=\"Orange\",1,IF(F6=\"Red\",0,IF(F6=\"Capping\",0,0)))))),0),Round)","v":0}]
[null,"Abdomen rib assessment",null,null,{"$f":"MIN(E35:E36)","v":0},null,{"$f":"MIN(G35:G36)","v":0}]
[]
[null,"Chest & Abdomen assessment",null,{"$f":"MIN(E33,E37)","v":0},null,{"$f":"MIN(G33,G37)","v":0}]
[]
[null,"SUMMARY"]
[null,null,"Head assessment",{"$f":"D14","v":0},null,{"$f":"F14","v":0}]
[null,null,"Neck assessment",{"$f":"D26","v":0},null,{"$f":"F26","v":0}]
[null,null,"Chest & Abdomen assessment",{"$f":"D39","v":0},null,{"$f":"F39","v":0}]
[null,null,"Pelvis assessment",{"$f":"D53","v":0},null,{"$f":"F53","v":0}]
[null,"DUMMY SCORE",null,{"$f":"SUM(D42:E45)","v":0},null,{"$f":"SUM(F42:G45)","v":0}]
[]
[null,"PELVIS"]
[null,null,"Pubic Symphysis force - kN",null,{"$f":"IF(D49>2.8,-4,0)","v":0},null,{"$f":"IF(F49>2.8,-4,0)","v":0}]
[null,null,"Lumbar Fy - kN",null,{"$f":"IF(D50>2,-4,0)","v":0},null,{"$f":"IF(F50>2,-4,0)","v":0}]
[null,null,"Lumbar Fz - kN",null,{"$f":"IF(D51>3.5,-4,0)","v":0},null,{"$f":"IF(F51>3.5,-4,0)","v":0}]
[null,null,"Lumbar Mx - Nm",null,{"$f":"IF(D52>120,-4,0)","v":0},null,{"$f":"IF(F52>120,-4,0)","v":0}]
[null,"Pelvis assessment",null,{"$f":"IF(COUNTIF(E49:E52,-4)>0,-4,0)","v":0},null,{"$f":"IF(COUNTIF(G49:G52,-4)>0,-4,0)","v":0}]
[]
[null,"TEST SCORE",null,{"$f":"IF(OR(D6=\"Capping\",F6=\"Capping\"),0,IF(OR(D12>700,D13>80,D30>50,D31>50,D32>50,D35>65,D36>65),0,MAX(SUM(D42:E45),0)))/12*2","v":0},null,{"$f":"IF(OR(D6=\"Capping\",F6=\"Capping\"),0,IF(OR(F12>700,F13>80,F30>50,F31>50,F32>50,F35>65,F36>65),0,MAX(SUM(F42:G45),0)))/12*2","v":0}]
[]
[null,"OCCUPANT-TO-OCCUPANT"]
[null,null,"Head-to-Head contact (from video)",null,{"$f":"IF(D58=\"No\",0,-1)","v":-1},null,{"$f":"IF(F58=\"No\",0,-1)","v":-1}]
[null,null,"HIC15",null,{"$f":"IF(D59>700,-1,0)","v":0},null,{"$f":"IF(F59>700,-1,0)","v":0}]
[null,null,"Resultant Acc. 3 msec exeedence - g",null,{"$f":"IF(D60>80,-1,0)","v":0},null,{"$f":"IF(F60>80,-1,0)","v":0}]
[null,null,"Symmetrical performance",null,{"$f":"IF(D61=\"PASS\",0,-1)","v":-1},null,{"$f":"IF(F61=\"PASS\",0,-1)","v":-1}]
[null,null,"Protection Zone",null,{"$f":"IF(D62=\"PASS\",0,-1)","v":-1},null,{"$f":"IF(F62=\"PASS\",0,-1)","v":-1}]
[null,"Occupant-to-Occupant Head Contact Assessment",null,{"$f":"MIN(E58:E62)","v":-1}]
[]
[null,"TOTAL FARSIDE",null,{"$f":"MAX(ROUND((D55+F55)+D63,Round),0)","v":0}]

{"sheet":"AOP Whiplash","index":7,"n_rows":153,"n_cols":7,"rows_kept":153,"cut":false,"hidden":false,"merged":[[12,1,12,2],[20,1,20,2],[22,1,22,2],[12,3,12,6],[20,3,20,6],[22,3,22,6],[53,1,53,2],[46,1,46,2],[40,3,40,4],[40,5,40,6],[53,3,53,4],[53,5,53,6],[6,3,6,6],[73,1,73,2],[149,1,149,6],[39,1,39,2],[39,3,39,4],[39,5,39,6],[46,3,46,4],[46,5,46,6],[70,1,70,2],[71,1,71,2],[63,1,63,2],[65,1,65,2],[63,3,63,4],[63,5,63,6],[65,3,65,6],[61,1,61,2],[1,1,2,2],[1,3,2,4],[1,5,2,6],[3,1,3,2],[5,3,5,6],[73,3,73,6],[35,4,36,4],[35,6,36,6],[66,3,66,6],[67,3,67,6],[68,3,68,6],[70,3,70,6],[71,3,71,6],[61,3,61,4],[61,5,61,6]]}
[]
[null,"Whiplash Tests",null,"Mid Pulse",null,"High Pulse"]
[]
[null,{"$f":"'General Overview'!G8","v":""},null,"Value","Points","Value","Points"]
[null,"SEAT SPECIFICATION"]
[null,null,"Type of headrest"]
[null,null,"Type of seat"]
[]
[null,"STATIC"]
[null,null,"Test position"]
[null,null,"Effective Height  - mm",null,{"$f":"ROUND(Sliding_Scale(D11,755,825,-1,1),Round)","v":0},null,{"$f":"ROUND(Sliding_Scale(F11,755,825,-1,1),Round)","v":0}]
[null,null,"Backset - mm",null,{"$f":"IF(D12=\"\",0,IF(D12<45,1,-1))","v":0},null,{"$f":"IF(F12=\"\",0,IF(F12<45,1,-1))","v":0}]
[null,"Geometric assessment (test position)",null,{"$f":"MIN(AVERAGE(E11,G11),AVERAGE(E12,G12))","v":0}]
[]
[null,null,"Down/Back"]
[null,null,"Effective Height  - mm",null,{"$f":"IF(D16=\"\",\"FAIL\",IF(D16>790,\"PASS\",\"FAIL\"))","v":"FAIL"},null,{"$f":"IF(F16=\"\",\"FAIL\",IF(F16>790,\"PASS\",\"FAIL\"))","v":"FAIL"}]
[null,null,"Backset - mm",null,{"$f":"IF(D17=\"\",\"FAIL\",IF(D17<70,\"PASS\",\"FAIL\"))","v":"FAIL"},null,{"$f":"IF(F17=\"\",\"FAIL\",IF(F17<70,\"PASS\",\"FAIL\"))","v":"FAIL"}]
[]
[null,null,"Passenger Effective Height  - mm",null,{"$f":"IF(D19=\"\",\"FAIL\",IF(D19>790,\"PASS\",\"FAIL\"))","v":"FAIL"},null,{"$f":"IF(F19=\"\",\"FAIL\",IF(F19>790,\"PASS\",\"FAIL\"))","v":"FAIL"}]
[null,null,"Passenger Backset - mm",null,{"$f":"IF(D20=\"\",\"FAIL\",IF(D20<70,\"PASS\",\"FAIL\"))","v":"FAIL"},null,{"$f":"IF(F20=\"\",\"FAIL\",IF(F20<70,\"PASS\",\"FAIL\"))","v":"FAIL"}]
[null,"Ease of Adjustment",null,{"$f":"IF(D68>3,IF(COUNTIF((D16:G17),\"FAIL\")>0,0,0.5)+IF(COUNTIF((D19:G20),\"FAIL\")>0,0,0.5),0)","v":0}]
[]
[null,"Static assessment",null,{"$f":"SUM(D13,D21)","v":0}]
[]
[null,"DYNAMIC"]
[null,null,"NIC max - m2/s2",null,{"$f":"IF(D26>27,\"Test Capped\",ROUND(Sliding_Scale(D26,11,24,1,0),Round))","v":0},null,{"$f":"IF(F26>25.5,\"Test Capped\",ROUND(Sliding_Scale(F26,13,23,1,0),Round))","v":0}]
[null,null,"UPPER Neck Shear (+Fx) - N",null,{"$f":"IF(D27>290,\"Test Capped\",ROUND(Sliding_Scale(D27,30,190,1,0),Round))","v":0},null,{"$f":"IF(F27>364,\"Test Capped\",ROUND(Sliding_Scale(F27,30,210,1,0),Round))","v":0}]
[null,null,"UPPER Neck Tension (+Fz) - N",null,{"$f":"IF(D28>900,\"Test Capped\",ROUND(Sliding_Scale(D28,360,750,1,0),Round))","v":0},null,{"$f":"IF(F28>1024,\"Test Capped\",ROUND(Sliding_Scale(F28,470,770,1,0),Round))","v":0}]
[]
[null,null,"Nkm ",null,{"$f":"IF(D30>0.69,\"Test Capped\",\"\" )","v":""},null,{"$f":"IF(F30>0.78,\"Test Capped\",\"\" )","v":""}]
[null,null,"Rebound velocity - m/s",null,{"$f":"IF(D31>5.2,\"Test Capped\",\"\" )","v":""},null,{"$f":"IF(F31>6,\"Test Capped\",\"\" )","v":""}]
[null,null,"UPPER Neck Shear (-Fx) - N",null,{"$f":"IF(D32>360,\"Test Capped\",\"\" )","v":""},null,{"$f":"IF(F32>360,\"Test Capped\",\"\" )","v":""}]
[null,null,"UPPER Neck Extension & Flexion (My) - Nm",null,{"$f":"IF(D33>30,\"Test Capped\",\"\" )","v":""},null,{"$f":"IF(F33>30,\"Test Capped\",\"\" )","v":""}]
[null,null,"LOWER Neck Shear (ABS(Fx)) - N",null,{"$f":"IF(D34>360,\"Test Capped\",\"\" )","v":""},null,{"$f":"IF(F34>360,\"Test Capped\",\"\" )","v":""}]
[null,null,"LOWER Neck Extension & Flexion (My) - N",null,{"$f":"IF(D35>30,\"Test Capped\",\"\" )","v":""},null,{"$f":"IF(F35>30,\"Test Capped\",\"\" )","v":""}]
[null,null,"T1 x-acc - g",null,{"$f":"IF(AND(D36>15.55,D37>92),\"Test Capped\",\"\" )","v":""},null,{"$f":"IF(AND(F36>17.8,F37>92),\"Test Capped\",\"\" )","v":""}]
[null,null,"Head contact start - ms"]
[]
[null,null,"Max Seat Back Dynamic Deflection - degree",null,null,null,{"$f":"IF(F39>32,\"Test Capped\",\"\" )","v":""}]
[null,"Dynamic assessment",null,{"$f":"IF(COUNTIF(E26:E39,\"Test Capped\")>0,0,SUM(E26:E28))","v":0},null,{"$f":"IF(COUNTIF(G26:G39,\"Test Capped\")>0,0,SUM(G26:G28))","v":0}]
[]
[null,"REAR WHIPLASH",null,{"$f":"IF('General Overview'!C17=0,\"\",\"2ND ROW\")","v":""},null,{"$f":"IF('General Overview'!C18=0,\"\",\"3RD ROW\")","v":""}]
[null,null,"Effective Height"]
[null,null,"Lowest position - mm",null,{"$f":"IF(D44>720,\"PASS\",\"FAIL\")","v":"FAIL"},null,{"$f":"IF(F42=\"\",\"\",IF(F44>720,\"PASS\",\"FAIL\"))","v":""}]
[null,null,"Highest position - mm",null,{"$f":"IF(D45>770,\"PASS\",\"FAIL\")","v":"FAIL"},null,{"$f":"IF(F42=\"\",\"\",IF(F45>770,\"PASS\",\"FAIL\"))","v":""}]
[null,null,{"$f":"IF(OR(E45=\"Fail\",G45=\"Fail\"),\"<50mm from interior\",\"\")","v":"<50mm from interior"}]
[null,"Rear Effective Height assessment",null,{"$f":"(IF(OR(AND(E44=\"PASS\",E45=\"PASS\"),D46=\"Yes\"),1.5,0)+IF(OR(AND(G44=\"PASS\",G45=\"PASS\"),F46=\"Yes\"),1.5,0))/IF(F42=\"\",1,2)","v":0}]
[]
[null,null,"Backset requirements"]
[null,null,"Torso angle - deg"]
[null,null,"(ΔCP X) mid position- mm",null,{"$f":"IF(D51=\"\",0,IF(AND(E44=\"Pass\",OR(E45=\"Pass\",D46=\"Yes\"),D51<=(7.128*D50+153)),1/IF(F42=\"\",1,2),0))","v":0},null,{"$f":"IF(F42=\"\",\"\",IF(F51=\"\",0,IF(AND(G44=\"Pass\",OR(G45=\"Pass\",F52=\"Yes\"),F51<=(7.128*F50+153)),1/IF(F42=\"\",1,2),0)))","v":""}]
[null,null,"(ΔCP X) worst case position- mm",null,{"$f":"IF(D52=\"\",0,IF(AND(E44=\"Pass\",OR(E45=\"Pass\",D46=\"Yes\"),D52<=(7.128*D50+153)),0.5/IF(F42=\"\",1,2),0))","v":0},null,{"$f":"IF(F42=\"\",\"\",IF(F52=\"\",0,IF(AND(G44=\"Pass\",OR(G45=\"Pass\",F52=\"Yes\"),F52<=(7.128*F50+153)),0.5/IF(F42=\"\",1,2),0)))","v":""}]
[]
[null,"Rear Backset Assessment",null,{"$f":"SUM(E51,E52,G51,G52)","v":0}]
[]
[null,null,"Non-Use position",{"$f":"IF(OR(AND(E44=\"PASS\",E45=\"PASS\"),D46=\"Yes\",E51>0,E52>0),\"Eligible for scoring\",\"Not eligible for scoring\")","v":"Not eligible for scoring"},null,{"$f":"IF(OR(AND(G44=\"PASS\",G45=\"PASS\"),F46=\"Yes\",G51>0,G52>0),\"Eligible for scoring\",\"Not eligible for scoring\")","v":"Eligible for scoring"}]
[null,null,"Automatic return head restraints"]
[null,null,"60° rotation evaluation"]
[null,null,"10° torso line change"]
[null,null,"Discomfort metric"]
[]
[null,"Rear Non-Use Position Assessment",null,{"$f":"(IF(AND(D56=\"Eligible for scoring\",OR(COUNTIF(D57:D60,\"Pass\")>0,COUNTIF(D57:D60,\"Not applicable\")=4)),1,0)+IF(AND(F56=\"Eligible for scoring\",OR(COUNTIF(F57:F60,\"Pass\")>0,COUNTIF(F57:F60,\"Not applicable\")=4)),1,0))/IF(F42=\"\",1,2)","v":0}]
[]
[null,"Rear Whiplash assessment",null,{"$f":"SUM(D47,D54,D62)","v":0}]
[]
[null,"SUMMARY"]
[null,null,"Static assessment",{"$f":"D23","v":0}]
[null,null,"Dynamic assessment",{"$f":"SUM(D40:G40)","v":0}]
[null,null,"Dummy Artifact Loading (-2)",0]
[]
[null,"TOTAL FRONT WHIPLASH",null,{"$f":"ROUND(SUM(D67:G69)/8*3,Round)","v":0}]
[null,"TOTAL REAR WHIPLASH",null,{"$f":"ROUND(D64/4*1,Round)","v":0}]
[]
[null,"TOTAL WHIPLASH",null,{"$f":"IF(OR('General Overview'!C17=\"\",'General Overview'!C18=\"\",'General Overview'!C17>0,'General Overview'!C18>0),SUM(D71:G72),D71/3*4)","v":0}]
[]
[]
[]
[]
[]
[null,"DUMMY MEASUREMENTS"]
[null,"Head"]
[null,"Ax","Max"]
[null,null,"Min"]
[null,"Ay","Max"]
[null,null,"Min"]
[null,"Az","Max"]
[null,null,"Min"]
[null,"Vx","Max"]
[null,"HRCT","Start"]
[null,null,"End"]
[null,"Cervical Spine"]
[null,"Ax","Max"]
[null,null,"Min"]
[null,"Az","Max"]
[null,null,"Min"]
[null,"Neck Upper"]
[null,"Fx","Max"]
[null,null,"Min"]
[null,"Fy","Max"]
[null,null,"Min"]
[null,"Fz","Max"]
[null,null,"Min"]
[null,"Mx","Max"]
[null,null,"Min"]
[null,"My","Max"]
[null,null,"Min"]
[null,"Mz","Max"]
[null,null,"Min"]
[null,"Neck Lower"]
[null,"Fx","Max"]
[null,null,"Min"]
[null,"Fy","Max"]
[null,null,"Min"]
[null,"Fz","Max"]
[null,null,"Min"]
[null,"Mx","Max"]
[null,null,"Min"]
[null,"My","Max"]
[null,null,"Min"]
[null,"Mz","Max"]
[null,null,"Min"]
[null,"Thoracic Spine (left)"]
[null,"Ax","Max"]
[null,null,"Min"]
[null,"Az","Max"]
[null,null,"Min"]
[null,"Thoracic Spine (right)"]
[null,"Ax","Max"]
[null,null,"Min"]
[null,"Az","Max"]
[null,null,"Min"]
[null,"Thoracic Spine T8"]
[null,"Ax","Max"]
[null,null,"Min"]
[null,"Az","Max"]
[null,null,"Min"]
[null,"Lumbar Spine"]
[null,"Ax","Max"]
[null,null,"Min"]
[null,"Az","Max"]
[null,null,"Min"]
[null,"Pelvis"]
[null,"Ax","Max"]
[null,null,"Min"]
[null,"Ay","Max"]
[null,null,"Min"]
[null,"Az","Max"]
[null,null,"Min"]
[]
[null,"SLED MEASUREMENTS"]
[null,"Sled"]
[null,"Ax","Max"]
[null,null,"Min"]

{"sheet":"AOP Rescue","index":8,"n_rows":54,"n_cols":11,"rows_kept":54,"cut":false,"hidden":false,"merged":[[1,1,2,2],[3,1,3,2],[10,1,10,2],[46,1,46,2],[53,1,53,2],[34,1,34,2],[48,1,48,2],[17,1,17,2],[22,1,22,2],[27,1,27,2],[9,3,9,6],[10,3,10,10],[4,7,4,10],[5,7,5,10],[6,7,6,10],[7,7,7,10],[8,7,8,10],[9,7,9,10],[12,3,12,4],[32,1,32,2],[41,3,41,10],[46,3,46,10],[43,3,43,6],[44,3,44,6],[45,3,45,6],[42,3,42,6],[42,7,45,10],[40,3,40,10],[38,3,38,6],[39,3,39,6],[32,3,32,10],[34,3,34,10],[33,1,33,10],[48,3,48,10],[49,3,49,10],[50,3,50,10],[51,3,51,10],[53,3,53,10],[1,3,3,10],[36,3,36,10],[37,3,37,10],[38,7,38,10],[39,7,39,10],[17,3,17,10],[22,3,22,10],[27,3,27,10],[12,7,12,8],[12,9,12,10],[4,3,4,6],[5,3,5,6],[6,3,6,6],[7,3,7,6],[8,3,8,6],[12,5,12,6]]}
[]
[null,"Rescue, Extrication & Safety"]
[]
[null,{"$f":"'General Overview'!G13","v":""}]
[null,"RESCUE",null,"AVAILABILITY",null,null,null,"COMPLIANCE"]
[null,null,"Rescue sheet"]
[null,null,"English"]
[null,null,"German"]
[null,null,"French"]
[null,null,"Spanish"]
[null,"RESCUE ASSESSMENT",null,{"$f":"IF(COUNTIF(D7:G10,\"FAIL\")>0,-2,IF(COUNTIF(H7:K10,\"FAIL\")>0,-1,0))","v":0}]
[]
[null,"EXTRICATION",null,"MPDB",null,"FW",null,"AE-MDB",null,"POLE"]
[null,null,null,"Driver side","Passenger side","Driver side","Passenger side","Driver side","Passenger side","Driver side","Passenger side"]
[null,null,"Automatic Door Locking (if applicable)"]
[null,null,"Front"]
[null,null,"Rear"]
[null,"Automatic door locking assessment",null,{"$f":"IF(COUNTIF(D16:K17,\"FAIL\")>0,-1,0)","v":0}]
[null,null,null,"Driver side","Passenger side","Driver side","Passenger side","Driver side","Passenger side","Driver side","Passenger side"]
[null,null,"Door opening forces - N"]
[null,null,"Front"]
[null,null,"Rear"]
[null,"Automatic door locking assessment",null,{"$f":"IF(OR(COUNTIF(D21:K22,\">750\")>0,COUNTIF(D21:K22,\"Tools\")>0),-1,0)","v":0}]
[null,null,null,"Driver side","Passenger side","Driver side","Passenger side","Driver side","Passenger side","Driver side","Passenger side"]
[null,null,"Retracting door handles (if applicable)"]
[null,null,"Front"]
[null,null,"Rear"]
[null,"Retracting door handles assessment",null,{"$f":"IF(COUNTIF(D26:K27,\"FAIL\")>0,-1,0)","v":0}]
[null,null,null,"Driver side","Passenger side","Driver side","Passenger side","Driver side","Passenger side","Driver side","Passenger side"]
[null,null,"Seatbelt buckle unlatching - N"]
[null,null,"Front"]
[null,null,"Rear"]
[null,"Seatbelt buckle unlatching assessment",null,{"$f":"IF(COUNTIF(D31:G32,\">60\")>0,-1,0)","v":0}]
[]
[null,"EXTRICATION ASSESSMENT",null,{"$f":"MIN(D18,D23,D28,D33)","v":0}]
[]
[null,"POST-CRASH TECHNOLOGY"]
[null,null,"Advanced eCall"]
[null,null,"Potential # of occupants",null,null,null,null,{"$f":"IF(D39=\"PASS\",0.5,0)","v":0}]
[null,null,"Recent vehicle locations N1 & N2",null,null,null,null,{"$f":"IF(D40=\"PASS\",0.5,0)","v":0}]
[]
[null,null,"Multi Collision Brake"]
[null,null,"Name",null,null,null,null,{"$f":"IF(AND(D43<>\"\",D44=\"PASS\",D45=\"PASS\",D46=\"PASS\"),1,0)","v":0}]
[null,null,"Description in manual"]
[null,null,"Deceleration during activation"]
[null,null,"Brake light activation"]
[null,"POST-CRASH TECHNOLOGY ASSESSMENT",null,{"$f":"SUM(H39:K40,H43)","v":0}]
[]
[null,"SUMMARY"]
[null,null,"Rescue",{"$f":"D11","v":0}]
[null,null,"Extrication",{"$f":"D35","v":0}]
[null,null,"Post-crash technology",{"$f":"D47","v":0}]
[]
[null,"TOTAL RESCUE, EXTRICATION & SAFETY",null,{"$f":"IF(D50<0,D50,SUM(D50:K52))","v":0}]

{"sheet":"COP Dynamic","index":9,"n_rows":125,"n_cols":7,"rows_kept":125,"cut":false,"hidden":false,"merged":[[24,1,24,2],[25,3,25,4],[25,5,25,6],[29,1,29,2],[48,3,48,4],[48,5,48,6],[40,3,40,4],[41,3,41,4],[40,5,40,6],[41,5,41,6],[43,3,43,4],[43,5,43,6],[49,3,49,4],[49,5,49,6],[51,1,51,2],[51,3,51,4],[51,5,51,6],[59,1,59,2],[19,1,19,2],[30,1,30,2],[30,3,30,4],[30,5,30,6],[39,1,39,2],[34,3,34,4],[34,5,34,6],[33,3,33,4],[33,5,33,6],[45,1,45,2],[45,3,45,4],[45,5,45,6],[53,1,53,2],[53,3,53,6],[47,1,47,2],[12,3,12,4],[12,5,12,6],[13,3,13,4],[13,5,13,6],[8,5,8,6],[8,3,8,4],[9,5,9,6],[9,3,9,4],[11,3,11,4],[11,5,11,6],[7,3,7,4],[7,5,7,6],[1,1,2,2],[1,3,2,4],[1,5,2,6],[3,1,3,2],[5,3,5,4],[5,5,5,6],[6,3,6,4],[6,5,6,6],[4,3,4,4],[4,5,4,6],[14,3,14,4],[14,5,14,6],[32,3,32,4],[32,5,32,6],[35,3,35,4],[35,5,35,6],[20,3,20,4],[21,3,21,4],[26,3,26,4],[20,5,20,6],[21,5,21,6],[26,5,26,6]]}
[3]
[null,"Child Occupant Protection",null,"Q6",null,"Q10"]
[]
[null,{"$f":"_xlfn.CONCAT('General Overview'!G4, \" & \",'General Overview'!G6)","v":" & "},null,"Value","Points","Value","Points"]
[null,"CRS DETAILS"]
[null,null,"Child restraint"]
[null,null,"CRS make and model"]
[null,null,"Installation method"]
[null,null,"Type of CRS",null,null,"='General Overview'!G42"]
[null,null,"Recommended by vehicle manufacturer"]
[]
[null,"FRONTAL"]
[null,null,"Dummy restrained throughout impact?"]
[null,null,"CRS anchorage to vehicle failure?"]
[null,null,"Head"]
[null,null,"Hard contact"]
[null,null,"HIC15",null,{"$f":"IF(D16=\"Yes\",Sliding_Scale(D17,500,700,4*IF('General Overview'!C17=0,2,1),0),\"\")","v":""},null,{"$f":"IF(F16=\"Yes\",Sliding_Scale(F17,500,700,4,0),\"\")","v":""}]
[null,null,"Head Resultant 3msec - g",null,{"$f":"ROUND(Sliding_Scale(D18,60,80,4,0),Round)","v":0},null,{"$f":"ROUND(Sliding_Scale(F18,60,80,4,0),Round)","v":0}]
[null,null,"Head Excursion (-2/-4) - mm",null,{"$f":"IF(D19>=550,-4,0)","v":0},null,{"$f":"IF(F19>=550,-4,IF(F19>=450,-2,0))","v":0}]
[null,"Head assessment",null,null,{"$f":"MAX(MIN(E17:E18)+E19,0)","v":0},null,{"$f":"MAX(MIN(G17:G18)+G19,0)","v":0}]
[]
[null,null,"Upper Neck"]
[null,null,"Tension (Upper neck Fz)",null,{"$f":"ROUND(Sliding_Scale(D23,1.7,2.62,2,0),Round)","v":0},null,{"$f":"ROUND(Sliding_Scale(F23,1.7,2.62,2,0),Round)","v":0}]
[null,null,"Extension (My)",null,{"$f":"IF(D16=\"Yes\",IF(D24<36,2,0),\"\")","v":""},null,{"$f":"IF(F16=\"Yes\",IF(F24<49,2,0),\"\")","v":""}]
[null,"Upper Neck assessment",null,null,{"$f":"MAX(MIN(E23:E24),0)","v":0},null,{"$f":"MAX(MIN(G23:G24),0)","v":0}]
[]
[null,null,"Chest (T4)"]
[null,null,"Chest Resultant 3msec - g",null,null,null,{"$f":"ROUND(Sliding_Scale(F28,41,55,2,0),Round)","v":0}]
[null,null,"Chest Deflection - mm",null,{"$f":"ROUND(Sliding_Scale(D29,30,42,2,0),Round)","v":0}]
[null,"Chest assessment",null,null,{"$f":"E29","v":0},null,{"$f":"G28","v":0}]
[null,"Front assessment",null,{"$f":"IF(OR(D13=\"No\",D14=\"Yes\",D17>800,D18>80),0,MAX(SUM(E20,E25,E30)+IF(D13=\"Partial\",-4,0),0))","v":0},null,{"$f":"IF(OR(F13=\"No\",F14=\"Yes\",F17>800,F18>80,G28>55),0,MAX(SUM(G20,G25,G30)+IF(F13=\"Partial\",-4,0),0))","v":0}]
[]
[null,"SIDE"]
[null,null,"Dummy restrained throughout impact?"]
[null,null,"CRS anchorage to vehicle failure?"]
[null,null,"Head"]
[null,null,"Hard contact"]
[null,null,"HIC15",null,{"$f":"IF(D37=\"Yes\",Sliding_Scale(D38,500,700,2,0),\"\")","v":""},null,{"$f":"IF(F37=\"Yes\",Sliding_Scale(F38,500,700,2,0),\"\")","v":""}]
[null,null,"Head Resultant 3msec - g",null,{"$f":"ROUND(Sliding_Scale(D39,60,80,2,0),Round)","v":0},null,{"$f":"ROUND(Sliding_Scale(F39,60,80,2,0),Round)","v":0}]
[null,"Head assessment",null,null,{"$f":"MAX(MIN(E38:E39),0)","v":0},null,{"$f":"MAX(MIN(G38:G39),0)","v":0}]
[]
[null,null,"Neck"]
[null,null,"Resultant Force (Upper neck)",null,{"$f":"IF(D43=\"\",0,IF(D43>=2.4,0,1))","v":0},null,{"$f":"IF(F43=\"\",0,IF(F43>=2.2,0,1))","v":0}]
[null,null,"Chest"]
[null,null,"Chest Resultant 3msec - g",null,{"$f":"IF(D45=\"\",0,IF(D45>=67,0,1))","v":0},null,{"$f":"IF(F45=\"\",0,IF(F45>=67,0,1))","v":0}]
[null,"Side assessment",null,{"$f":"IF(OR(D34=\"No\",D35=\"Yes\",D38>800,D39>80),0,SUM(E40,E43,E45))","v":0},null,{"$f":"IF(OR(F34=\"No\",F35=\"Yes\",F38>800,F39>80),0,SUM(G40,G43,G45))","v":0}]
[]
[null,"SUMMARY"]
[null,null,"Front assessment",{"$f":"D31","v":0},null,{"$f":"F31","v":0}]
[null,null,"Side assessment",{"$f":"D46","v":0},null,{"$f":"F46","v":0}]
[]
[null,"TOTAL",null,{"$f":"ROUND(SUM(D49:E50),Round)","v":0},null,{"$f":"ROUND(SUM(F49:G50),Round)","v":0}]
[]
[null,"TOTAL DYNAMIC ASSESSMENT",null,{"$f":"ROUND(SUM(D52:G52)*IF('General Overview'!C17=0,2,1),Round)","v":0}]
[]
[]
[]
[]
[]
[null,"DUMMY MEASUREMENTS",null,"Frontal","Side","Frontal","Side"]
[null,"Head"]
[null,"Ax","Max"]
[null,null,"Min"]
[null,"Ay","Max"]
[null,null,"Min"]
[null,"Az","Max"]
[null,null,"Min"]
[null,"Neck"]
[null,"Fx","Max"]
[null,null,"Min"]
[null,"Fy","Max"]
[null,null,"Min"]
[null,"Fz","Max"]
[null,null,"Min"]
[null,"Mx","Max"]
[null,null,"Min"]
[null,"My","Max"]
[null,null,"Min"]
[null,"Mz","Max"]
[null,null,"Min"]
[null,"Shoulder"]
[null,"Fx","Max"]
[null,null,"Min"]
[null,"Fy","Max"]
[null,null,"Min"]
[null,"Fz","Max"]
[null,null,"Min"]
[null,"T1"]
[null,"Ay","Max"]
[null,"Chest"]
[null,"Ax","Max"]
[null,null,"Min"]
[null,"Ay","Max"]
[null,null,"Min"]
[null,"Az","Max"]
[null,null,"Min"]
[null,"Dchest","Max"]
[null,null,"Min"]
[null,"LO","Max"]
[null,null,"Min"]
[null,"UP","Max"]
[null,null,"Min"]
[null,"Lumbar Spine (lower)"]
[null,"Fx","Max"]
[null,null,"Min"]
[null,"Fy","Max"]
[null,null,"Min"]
[null,"Fz","Max"]
[null,null,"Min"]
[null,"Mx","Max"]
[null,null,"Min"]
[null,"My","Max"]
[null,null,"Min"]
[null,"Mz","Max"]
[null,null,"Min"]
[null,"Pelvis-Sacrum"]
[null,"Ax","Max"]
[null,null,"Min"]
[null,"Ay","Max"]
[null,null,"Min"]
[null,"Az","Max"]
[null,null,"Min"]
[null,"Pelvis-Pubis"]
[null,"Fy","Max"]
[null,null,"Min"]

{"sheet":"COP Vehicle Based","index":10,"n_rows":53,"n_cols":10,"rows_kept":53,"cut":false,"hidden":false,"merged":[[30,1,30,2],[34,1,34,2],[36,1,36,2],[30,3,30,9],[34,3,34,9],[36,3,36,9],[21,1,21,2],[25,1,25,2],[20,3,20,9],[21,3,21,9],[25,3,25,9],[11,1,11,2],[15,1,15,2],[8,3,8,9],[9,3,9,9],[10,3,10,9],[11,3,11,9],[15,3,15,9],[1,1,2,2],[1,3,2,3],[1,4,2,6],[1,7,2,9],[3,1,3,2],[46,7,47,7],[49,1,49,2],[50,1,50,2],[51,1,51,2],[52,1,52,2],[46,1,47,2],[46,3,47,3],[46,4,47,4],[46,5,47,5],[46,6,47,6]]}
[]
[null,"Vehicle based assessment",null,"Front","2nd row",null,null,"3rd row"]
[]
[null,null,null,"Passenger","Left","Centre","Right","Left","Centre","Right"]
[null,"SEATING POSITIONS"]
[null,null,"Provision of three-point seat belts  "]
[]
[null,"VEHICLE HANDBOOK INFORMATION"]
[null,null,"Universal (belted) table"]
[null,null,"ISOFIX table"]
[null,null,"i-Size table"]
[null,"Eligibility for scoring",null,{"$f":"IF(AND(COUNTIF(D6:J6,\"Yes\")=(1+SUM('General Overview'!C17:D18)),COUNTIF(D9:D11,\"OK\")=3),\"Yes\",\"No\")","v":"No"}]
[]
[null,"GABARIT INSTALLATION"]
[null,null,"Gabarit installation","Pass"]
[null,"Gabarit installation score",null,{"$f":"IF(AND(E15=\"Pass\",G15=\"Pass\"),1,0)+IF(COUNTIF(D15:J15,\"Pass\")=(1+SUM('General Overview'!C17:D18)),IF(COUNTIF(D15:J15,\"Pass\")=1,2,1),0)","v":2}]
[]
[null,"i-SIZE AND TOP TETHER MARKING"]
[null,null,"i-Size marking requirements"]
[null,null,"i-Size availabilty (ISO/B2 i-Size fixture)"]
[null,null,"Simultaneously covering i-Size",{"$f":"IF(COUNTIF(D19:J19,\"Pass\")>=3*IF('General Overview'!C17+'General Overview'!C18=0,1/3,1),\"Pass\",\"Fail\")","v":"Fail"}]
[null,"i-Size and top tether marking score",null,{"$f":"IF(AND(COUNTIF(D19:J19,\"Pass\")>=2*IF('General Overview'!C17+'General Overview'!C18=0,0.5,1),COUNTIF(D20:J20,\"Pass\")>=2*IF('General Overview'!C17+'General Overview'!C18=0,0.5,1)),2,0)+IF(D21=\"Pass\",1,0)","v":0}]
[]
[null,"TWO OR MORE LARGEST ISOFIX POSITIONS"]
[null,null,"Ability to install ISO/R3"]
[null,"Two or more largest ISOFIX positions score",null,{"$f":"IF(COUNTIF(D25:J25,\"Pass\")>=2*IF('General Overview'!C17+'General Overview'!C18=0,0.5,1),1,0)","v":0}]
[]
[null,"PASSENGER AIRBAG WARNING MARKING AND DISABLING"]
[null,null,"Manual airbag disabling switch"]
[null,null,"Automatic airbag disabling switch"]
[null,"Passenger airbag warning marking and disabling score",null,{"$f":"IF(D30=\"Pass\",4,IF(D29=\"Pass\",2,0))","v":0}]
[]
[null,"INTEGRATED CRS"]
[null,null,"Integrated CRS"]
[null,"Integrated CRS scoring",null,{"$f":"IF(COUNTIF(D34:J34,\"Yes\")>=2*IF('General Overview'!C17+'General Overview'!C18=0,0.5,1),3,IF(COUNTIF(D34:J34,\"Yes\")>=1,1,0))","v":0}]
[]
[null,"TOTAL VEHICLE BASED ASSESSMENT",null,{"$f":"IF(D12=\"Yes\",SUM(D16,D22,D26,D31,D35),0)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Website table",null,"Front Passenger","2nd row Outboard","2nd row Centre","3rd row Outboard","3rd row Centre"]
[]
[]
[null,null,null,"Value","Value","Value","Value","Value"]
[null,"ISOFIX"]
[null,"iSize"]
[null,"Integrated CRS"]

{"sheet":"COP CRS Installation","index":11,"n_rows":28,"n_cols":20,"rows_kept":28,"cut":false,"hidden":false,"merged":[[25,2,25,6],[25,7,25,19],[27,1,27,6],[27,7,27,19],[22,2,22,6],[22,7,22,19],[23,2,23,6],[23,7,23,19],[24,2,24,6],[24,7,24,19],[17,3,17,4],[18,3,18,4],[19,3,19,4],[21,1,21,6],[21,7,21,19],[16,1,19,1],[16,3,16,4],[16,16,17,18],[16,19,18,19],[11,5,12,5],[11,6,12,6],[15,3,15,4],[13,3,13,4],[14,3,14,4],[9,1,10,1],[9,3,9,4],[10,3,10,4],[11,1,15,1],[11,3,12,4],[4,3,4,4],[5,1,8,1],[5,2,6,2],[5,3,5,4],[6,3,6,4],[7,3,7,4],[8,3,8,4],[1,1,3,6],[1,7,1,15],[1,16,2,19],[2,7,2,9],[2,10,2,12],[2,13,2,15]]}
[]
[null,"CRS Installation Assessment",null,null,null,null,null,"SEATING POSITION",null,null,null,null,null,null,null,null,"SCORING"]
[null,null,null,null,null,null,null,"Front",null,null,"2nd row",null,null,{"$f":"IF(OR('General Overview'!C18>1,'General Overview'!C18=\"\"),\"3rd row\",\"3rd\")","v":"3rd row"}]
[null,null,null,null,null,null,null,"Left","Centre","Right","Left","Centre","Right","Left","Centre","Right","Pass","Fail","Exempt","Score"]
[]
[null,"UNIVERSAL","Group 0+","Maxi Cosi Cabriofix",null,"B _ _ _","U",null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF($H6:$P6,\"Pass\")","v":0},{"$f":"COUNTIF($H6:$P6,\"Fail\")+COUNTIF($H6:$P6,\"P Fail\")","v":0},null,{"$f":"IF(SUM(Q6:S6)=0,\"\",Q6/(Q6+R6))","v":""}]
[null,null,null,"Maxi Cosi Cabriofix & EasyBase2",null,"B _ L _","VEHICLE LIST",null,null,null,null,null,null,null,null,null,0,0,{"$f":"COUNTIF($H7:$P7,\"Exempt\")","v":0},{"$f":"IF(SUM(Q7:S7)=0,\"\",(Q7+S7)/(Q7+R7+S7))","v":""}]
[null,null,"Group I","Britax Römer King II LS",null,"B _ _ _","U / UF",null,null,null,null,null,null,null,null,null,0,0,null,{"$f":"IF(SUM(Q8:S8)=0,\"\",Q8/(Q8+R8))","v":""}]
[null,null,"Group II/III","Britax Römer KidFix XP",null,"B _ _ _","U / UF",null,null,null,null,null,null,null,null,null,0,0,null,{"$f":"IF(SUM(Q9:S9)=0,\"\",Q9/(Q9+R9))","v":""}]
[null,"ISOFIX","Group 0+/I","BeSafe iZi Combi X4 ISOfix",null,"_ I L _","ISO/R3",null,null,null,null,null,null,null,null,null,0,0,0,{"$f":"IF(SUM(Q10:S10)=0,\"\",(Q10+S10)/(Q10+R10+S10))","v":""}]
[null,null,"Group II/III","Britax Römer KidFix XP",null,"B I _ _","VEHICLE LIST",null,null,null,null,null,null,null,null,null,0,0,null,{"$f":"IF(SUM(Q11:S11)=0,\"\",Q11/(Q11+R11))","v":""}]
[null,"i-Size","67-105cm","Maxi Cosi 2way Pearl & 2wayFix",null,"_ I L _","i-Size",null,null,null,null,null,null,null,null,null,0,0,null,""]
[null,null,">15m-105cm",null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,""]
[null,null,"61-105cm","BeSafe iZi Kid X2 i-Size",null,"_ I L _","i-Size",null,null,null,null,null,null,null,null,null,0,0,null,""]
[null,null,"76-105cm","Britax Römer TriFix2 i-Size",null,"_ I L _","i-Size",null,null,null,null,null,null,null,null,null,0,0,null,{"$f":"IF(SUM(Q15:S15)=0,\"\",Q15/(Q15+R15))","v":""}]
[null,null,"100-135cm","BeSafe iZi Flex FIX i-Size",null,"B I _ _","i-Size",null,null,null,null,null,null,null,null,null,0,0,null,""]
[null,"OEM","Group 0+",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('General Overview'!C17=0,IF(AND(COUNTIF(F17:G19,\"\")=0,Q19=1),1,0),IF(AND(COUNTIF(F17:G19,\"\")=0,Q19=2),1,0))","v":0}]
[null,null,"Group I"]
[null,null,"Group II",null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"COUNTIF($H19:$P19,\"Fail\")+COUNTIF($H19:$P19,\"P Fail\")","v":0}]
[null,null,"Group III",null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"COUNTIF($H20:$P20,\"Fail\")+COUNTIF($H20:$P20,\"P Fail\")","v":0},null,{"$f":"IF('General Overview'!C17=0,IF(Q20=1,1,0),IF(Q20=2,1,0))","v":0}]
[]
[null,"SUMMARY"]
[null,null,"Universal assessment",null,null,null,null,{"$f":"IF(COUNTIF(T6:T9,\"\")>0,0,AVERAGE(T6:T9)*4)","v":0}]
[null,null,"ISOFIX assessment",null,null,null,null,{"$f":"IF(COUNTIF(T10:T11,\"\")>0,0,AVERAGE(T10:T11)*2)","v":0}]
[null,null,"i-Size assessment",null,null,null,null,{"$f":"IF(COUNTIF(T12:T16,\"\")>0,0,AVERAGE(T12:T16)*4)","v":0}]
[null,null,"OEM assessment",null,null,null,null,{"$f":"T17+T20","v":0}]
[]
[null,"TOTAL INSTALLATION ASSESSMENT",null,null,null,null,null,{"$f":"SUM(H23:T26)","v":0}]

{"sheet":"VRU Headform","index":12,"n_rows":68,"n_cols":26,"rows_kept":68,"cut":false,"hidden":false,"merged":[[1,1,2,24],[3,1,3,3],[4,1,18,1],[20,1,20,3],[20,4,20,15],[20,16,20,18],[20,19,20,21],[20,22,20,24],[21,1,21,3],[21,4,21,15],[21,16,21,18],[21,19,21,21],[21,22,21,24],[22,1,22,3],[22,4,22,15],[22,16,22,18],[22,19,22,21],[22,22,22,24],[23,1,23,3],[23,4,23,15],[23,16,23,18],[23,19,23,21],[23,22,23,24],[24,1,24,3],[24,4,24,15],[24,16,24,18],[24,19,24,21],[24,22,24,24],[25,1,25,3],[25,4,25,15],[25,16,25,18],[25,19,25,21],[25,22,25,24],[26,1,26,3],[26,4,26,15],[26,16,26,18],[26,19,26,21],[26,22,26,24],[27,1,27,3],[27,4,27,15],[27,16,27,18],[27,19,27,21],[27,22,27,24],[28,1,28,3],[28,4,28,15],[28,16,28,18],[28,19,28,21],[28,22,28,24],[29,1,29,15],[29,16,29,18],[29,19,29,21],[29,22,29,24],[31,1,31,24],[32,1,32,2],[32,3,32,5],[32,6,32,8],[32,9,32,11],[32,13,32,15],[32,16,32,18],[32,19,32,21],[32,22,32,24],[33,1,33,2],[33,3,33,5],[33,6,33,8],[33,9,33,11],[33,13,33,15],[33,16,33,18],[33,19,33,21],[33,22,33,24],[34,1,34,2],[34,3,34,5],[34,6,34,8],[34,9,34,11],[34,13,34,15],[34,16,34,18],[34,19,34,21],[34,22,34,24],[35,1,35,2],[35,3,35,5],[35,6,35,8],[35,9,35,11],[35,13,35,15],[35,16,35,18],[35,19,35,21],[35,22,35,24],[36,1,36,2],[36,3,36,5],[36,6,36,8],[36,9,36,11],[36,13,36,15],[36,16,36,18],[36,19,36,21],[36,22,36,24],[37,1,37,2],[37,3,37,5],[37,6,37,8],[37,9,37,11],[37,13,37,15],[37,16,37,18],[37,19,37,21],[37,22,37,24],[38,1,38,2],[38,3,38,5],[38,6,38,8],[38,9,38,11],[38,13,38,15],[38,16,38,18],[38,19,38,21],[38,22,38,24],[39,1,39,2],[39,3,39,5],[39,6,39,8],[39,9,39,11],[39,13,39,15],[39,16,39,18],[39,19,39,21],[39,22,39,24],[40,1,40,2],[40,3,40,5],[40,6,40,8],[40,9,40,11],[40,13,40,15],[40,16,40,18],[40,19,40,21],[40,22,40,24],[41,1,41,2],[41,3,41,5],[41,6,41,8],[41,9,41,11],[41,13,41,15],[41,16,41,18],[41,19,41,21],[41,22,41,24],[42,1,42,2],[42,3,42,5],[42,6,42,8],[42,9,42,11],[42,13,42,15],[42,16,42,18],[42,19,42,21],[42,22,42,24],[43,1,43,2],[43,3,43,5],[43,6,43,8],[43,9,43,11],[43,13,43,15],[43,16,43,18],[43,19,43,21],[43,22,43,24],[45,1,45,18],[45,19,45,24],[47,1,47,24],[48,1,48,2],[48,3,48,5],[48,6,48,8],[48,9,48,11],[48,13,48,15],[48,16,48,18],[48,19,48,21],[48,22,48,24],[49,1,49,2],[49,3,49,5],[49,6,49,8],[49,9,49,11],[49,13,49,15],[49,16,49,18],[49,19,49,21],[49,22,49,24],[50,1,50,2],[50,3,50,5],[50,6,50,8],[50,9,50,11],[50,13,50,15],[50,16,50,18],[50,19,50,21],[50,22,50,24],[51,1,51,2],[51,3,51,5],[51,6,51,8],[51,9,51,11],[51,13,51,15],[51,16,51,18],[51,19,51,21],[51,22,51,24],[52,1,52,2],[52,3,52,5],[52,6,52,8],[52,9,52,11],[52,13,52,15],[52,16,52,18],[52,19,52,21],[52,22,52,24],[53,1,53,2],[53,3,53,5],[53,6,53,8],[53,9,53,11],[53,13,53,15],[53,16,53,18],[53,19,53,21],[53,22,53,24],[54,1,54,2],[54,3,54,5],[54,6,54,8],[54,9,54,11],[54,13,54,15],[54,16,54,18],[54,19,54,21],[54,22,54,24],[56,19,56,21],[56,22,56,24],[55,1,55,2],[55,3,55,5],[55,6,55,8],[55,9,55,11],[55,13,55,15],[55,16,55,18],[57,13,57,15],[57,16,57,18],[55,19,55,21],[55,22,55,24],[56,1,56,2],[56,3,56,5],[56,6,56,8],[56,9,56,11],[56,13,56,15],[56,16,56,18],[57,19,57,21],[57,22,57,24],[58,1,58,18],[58,19,58,24],[60,1,60,18],[60,19,60,24],[57,1,57,2],[57,3,57,5],[57,6,57,8],[57,9,57,11],[61,1,61,2],[61,3,61,18],[61,19,61,24],[62,1,62,2],[62,3,62,18],[62,19,62,24],[65,1,65,18],[65,19,65,24],[67,1,67,18],[67,19,67,24],[63,1,63,2],[63,3,63,18],[63,19,63,24],[64,1,64,2],[64,3,64,18],[64,19,64,24]]}
[]
[null,"Pedestrian Headforms"]
[]
[null,null,null,null,10,9,8,7,6,5,4,3,2,1,0,-1,-2,-3,-4,-5,-6,-7,-8,-9,-10]
[null,"WAD on Centreline",2400,14]
[null,null,2300,13]
[null,null,2200,12]
[null,null,2100,11]
[null,null,2000,10]
[null,null,1900,9]
[null,null,1800,8]
[null,null,1700,7]
[null,null,1600,6]
[null,null,1500,5]
[null,null,1400,4]
[null,null,1300,3]
[null,null,1200,2]
[null,null,1100,1]
[null,null,1000,0]
[]
[null,"PREDICTION",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nr of points",null,null,"Points",null,null,"%-age"]
[null,null,null,null,"Default green",null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF($E$5:$Y$19,\"D Green\")","v":0},null,null,{"$f":"Q22*1","v":0},null,null,{"$f":"IF(COUNTBLANK(E5:Y19)>0,\"\",Q22/$Q$30)","v":""}]
[null,null,null,null,"Green",null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF($E$5:$Y$19,\"Green\")","v":0},null,null,{"$f":"Q23*1","v":0},null,null,{"$f":"IF(COUNTBLANK(E5:Y19)>0,\"\",Q23/$Q$30)","v":""}]
[null,null,null,null,"Yellow",null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF($E$5:$Y$19,\"Yellow\")","v":0},null,null,{"$f":"Q24*0.75","v":0},null,null,{"$f":"IF(COUNTBLANK(E5:Y19)>0,\"\",Q24/$Q$30)","v":""}]
[null,null,null,null,"Orange",null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF($E$5:$Y$19,\"Orange\")","v":0},null,null,{"$f":"Q25*0.5","v":0},null,null,{"$f":"IF(COUNTBLANK(E5:Y19)>0,\"\",Q25/$Q$30)","v":""}]
[null,null,null,null,"Brown",null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF($E$5:$Y$19,\"Brown\")","v":0},null,null,{"$f":"Q26*0.25","v":0},null,null,{"$f":"IF(COUNTBLANK(E5:Y19)>0,\"\",Q26/$Q$30)","v":""}]
[null,null,null,null,"Red",null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF($E$5:$Y$19,\"Red\")","v":0},null,null,{"$f":"Q27*0","v":0},null,null,{"$f":"IF(COUNTBLANK(E5:Y19)>0,\"\",Q27/$Q$30)","v":""}]
[null,null,null,null,"Default Red",null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF($E$5:$Y$19,\"D Red\")","v":0},null,null,{"$f":"Q28*0","v":0},null,null,{"$f":"IF(COUNTBLANK(E5:Y19)>0,\"\",Q28/$Q$30)","v":""}]
[null,null,null,null,"Blue",null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF($E$5:$Y$19,\"Blue\")","v":0},null,null,null,null,null,{"$f":"IF(COUNTBLANK(E5:Y19)>0,\"\",Q29/$Q$30)","v":""}]
[null,"Predicted headform score (excluding blue points)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Q22:S29)","v":0},null,null,{"$f":"SUM(T22:V28)","v":0},null,null,{"$f":"SUM(W22:Y29)","v":0}]
[]
[null,"VERIFICATION"]
[null,"Testpoint",null,"Prediction",null,null,"Value",null,null,"Points",null,null,null,"Testpoint",null,null,"Prediction",null,null,"Value",null,null,"Points"]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(G34=\"\",\"\",actual_score(G34,D34))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(T34=\"\",\"\",actual_score(T34,Q34))","v":""}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(G35=\"\",\"\",actual_score(G35,D35))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"Total",null,{"$f":"(COUNTIF(D34:F43,\"Green\")*1)+(COUNTIF(D34:F43,\"Yellow\")*0.75)+(COUNTIF(D34:F43,\"Orange\")*0.5)+(COUNTIF(D34:F43,\"Brown\")*0.25)","v":0},null,null,null,null,null,{"$f":"SUM(J34:L43)","v":0},null,null,null,"Total",null,null,{"$f":"(COUNTIF(Q34:S43,\"Green\")*1)+(COUNTIF(Q34:S43,\"Yellow\")*0.75)+(COUNTIF(Q34:S43,\"Orange\")*0.5)+(COUNTIF(Q34:S43,\"Brown\")*0.25)","v":0},null,null,null,null,null,{"$f":"SUM(W34:Y43)","v":0}]
[]
[null,"Correction factor",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(IF((J44+W44)=0,1,(J44+W44)/(D44+Q44)),Round)","v":1}]
[]
[null,"BLUE POINTS"]
[null,"Zone",null,"GRID-point",null,null,"Value",null,null,"Points",null,null,null,"Zone",null,null,"GRID-point",null,null,"Value",null,null,"Points"]
[null,1,null,null,null,null,null,null,null,{"$f":"IF(G50=\"\",\"\",IF(G50<=650,1,IF(G50<=1000,0.75,IF(G50<=1350,0.5,IF(G50<=1700,0.25,0)))))","v":""},null,null,null,5,null,null,null,null,null,null,null,null,{"$f":"IF(T50=\"\",\"\",IF(T50<=650,1,IF(T50<=1000,0.75,IF(T50<=1350,0.5,IF(T50<=1700,0.25,0)))))","v":""}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(D51=\"\",\"\",IF(G50<=650,1,IF(G50<=1000,0.75,IF(G50<=1350,0.5,IF(G50<=1700,0.25,0)))))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Q51=\"\",\"\",IF(T50<=650,1,IF(T50<=1000,0.75,IF(T50<=1350,0.5,IF(T50<=1700,0.25,0)))))","v":""}]
[null,2,null,null,null,null,null,null,null,{"$f":"IF(G52=\"\",\"\",IF(G52<=650,1,IF(G52<=1000,0.75,IF(G52<=1350,0.5,IF(G52<=1700,0.25,0)))))","v":""},null,null,null,6,null,null,null,null,null,null,null,null,{"$f":"IF(T52=\"\",\"\",IF(T52<=650,1,IF(T52<=1000,0.75,IF(T52<=1350,0.5,IF(T52<=1700,0.25,0)))))","v":""}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(D53=\"\",\"\",IF(G52<=650,1,IF(G52<=1000,0.75,IF(G52<=1350,0.5,IF(G52<=1700,0.25,0)))))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Q53=\"\",\"\",IF(T52<=650,1,IF(T52<=1000,0.75,IF(T52<=1350,0.5,IF(T52<=1700,0.25,0)))))","v":""}]
[null,3,null,null,null,null,null,null,null,{"$f":"IF(G54=\"\",\"\",IF(G54<=650,1,IF(G54<=1000,0.75,IF(G54<=1350,0.5,IF(G54<=1700,0.25,0)))))","v":""},null,null,null,7,null,null,null,null,null,null,null,null,{"$f":"IF(T54=\"\",\"\",IF(T54<=650,1,IF(T54<=1000,0.75,IF(T54<=1350,0.5,IF(T54<=1700,0.25,0)))))","v":""}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(D55=\"\",\"\",IF(G54<=650,1,IF(G54<=1000,0.75,IF(G54<=1350,0.5,IF(G54<=1700,0.25,0)))))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Q55=\"\",\"\",IF(T54<=650,1,IF(T54<=1000,0.75,IF(T54<=1350,0.5,IF(T54<=1700,0.25,0)))))","v":""}]
[null,4,null,null,null,null,null,null,null,{"$f":"IF(G56=\"\",\"\",IF(G56<=650,1,IF(G56<=1000,0.75,IF(G56<=1350,0.5,IF(G56<=1700,0.25,0)))))","v":""},null,null,null,8,null,null,null,null,null,null,null,null,{"$f":"IF(T56=\"\",\"\",IF(T56<=650,1,IF(T56<=1000,0.75,IF(T56<=1350,0.5,IF(T56<=1700,0.25,0)))))","v":""}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(D57=\"\",\"\",IF(G56<=650,1,IF(G56<=1000,0.75,IF(G56<=1350,0.5,IF(G56<=1700,0.25,0)))))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Q57=\"\",\"\",IF(T56<=650,1,IF(T56<=1000,0.75,IF(T56<=1350,0.5,IF(T56<=1700,0.25,0)))))","v":""}]
[]
[null,"Total blue points",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(J50:L57,W50:Y57)","v":0}]
[]
[null,"SUMMARY"]
[null,null,null,"Predicted score (excluding blue points)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"T30","v":0}]
[null,null,null,"Default Green",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"T22","v":0}]
[null,null,null,"Blue points score",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"T59","v":0}]
[null,null,null,"Correction factor",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"T46","v":1}]
[null,"Total score",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(T65=\"\",\"\",ROUND((T62-T63)*T65+T63+T64,Round))","v":0}]
[]
[null,"TOTAL PEDESTRIAN HEADFORM",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTBLANK(E5:Y19)>0,0,ROUND(T66/Q30*24,Round))","v":0},null,null,null,null,null,{"$f":"ROUND(T68,1)","v":0}]

{"sheet":"VRU Upper Legform","index":13,"n_rows":35,"n_cols":29,"rows_kept":35,"cut":false,"hidden":false,"merged":[[27,8,27,9],[21,22,21,23],[25,10,25,11],[25,16,25,17],[32,6,32,27],[34,1,34,5],[34,6,34,27],[20,14,20,15],[21,14,21,15],[22,14,22,15],[23,14,23,15],[24,14,24,15],[26,10,26,11],[32,1,32,5],[26,12,26,13],[27,12,27,13],[25,24,25,25],[21,24,21,25],[22,24,22,25],[26,16,26,17],[26,24,26,25],[28,1,28,27],[27,16,27,17],[27,24,27,25],[24,24,24,25],[23,24,23,25],[22,10,22,11],[18,14,18,15],[19,14,19,15],[27,14,27,15],[26,14,26,15],[31,1,31,27],[27,10,27,11],[27,6,27,7],[29,1,29,5],[30,1,30,5],[25,14,25,15],[19,10,19,11],[23,10,23,11],[24,10,24,11],[24,12,24,13],[25,12,25,13],[24,26,24,27],[25,26,25,27],[26,26,26,27],[27,26,27,27],[23,6,23,7],[24,6,24,7],[25,6,25,7],[26,6,26,7],[14,10,14,11],[8,14,8,15],[9,14,9,15],[10,14,10,15],[11,14,11,15],[12,14,12,15],[17,14,17,15],[13,14,13,15],[21,10,21,11],[21,6,21,7],[22,6,22,7],[17,6,17,7],[18,6,18,7],[8,6,8,7],[9,6,9,7],[10,6,10,7],[12,6,12,7],[15,12,15,13],[17,8,17,9],[21,8,21,9],[15,14,15,15],[16,12,16,13],[1,18,1,25],[7,12,7,13],[23,26,23,27],[19,26,19,27],[15,10,15,11],[14,14,14,15],[23,12,23,13],[20,26,20,27],[21,26,21,27],[22,26,22,27],[21,12,21,13],[22,12,22,13],[14,16,14,17],[15,22,15,23],[22,16,22,17],[18,24,18,25],[19,16,19,17],[19,24,19,25],[20,16,20,17],[20,24,20,25],[21,16,21,17],[16,16,16,17],[16,24,16,25],[17,16,17,17],[15,26,15,27],[16,26,16,27],[17,26,17,27],[18,26,18,27],[17,22,17,23],[15,16,15,17],[15,24,15,25],[14,22,14,23],[12,22,12,23],[17,24,17,25],[16,22,16,23],[1,26,2,27],[3,26,3,27],[4,26,4,27],[5,26,5,27],[6,26,6,27],[7,26,7,27],[8,26,8,27],[9,26,9,27],[10,26,10,27],[20,6,20,7],[18,16,18,17],[16,10,16,11],[17,10,17,11],[18,10,18,11],[18,8,18,9],[19,8,19,9],[20,8,20,9],[20,10,20,11],[16,14,16,15],[16,8,16,9],[19,6,19,7],[16,6,16,7],[17,12,17,13],[18,12,18,13],[19,12,19,13],[20,12,20,13],[11,26,11,27],[12,26,12,27],[13,26,13,27],[14,26,14,27],[11,12,11,13],[12,12,12,13],[13,12,13,13],[14,12,14,13],[13,10,13,11],[13,22,13,23],[11,10,11,11],[12,10,12,11],[12,24,12,25],[14,24,14,25],[12,16,12,17],[3,6,3,7],[3,10,3,11],[8,10,8,11],[8,16,8,17],[3,24,3,25],[4,22,4,25],[11,8,11,9],[9,16,9,17],[9,24,9,25],[8,22,8,23],[9,22,9,23],[4,6,4,9],[6,6,6,9],[5,6,5,9],[7,6,7,7],[9,10,9,11],[10,10,10,11],[7,16,7,17],[10,16,10,17],[6,10,6,13],[6,14,6,17],[8,12,8,13],[6,22,6,25],[3,12,3,13],[3,22,3,23],[7,24,7,25],[4,14,4,17],[2,18,2,19],[2,20,2,21],[5,20,5,21],[4,20,4,21],[2,22,2,25],[5,22,5,25],[7,22,7,23],[7,10,7,11],[3,14,3,15],[7,14,7,15],[3,20,3,21],[7,20,7,21],[26,8,26,9],[22,8,22,9],[24,16,24,17],[23,8,23,9],[24,8,24,9],[25,8,25,9],[23,16,23,17],[3,16,3,17],[5,10,5,13],[13,18,13,19],[9,12,9,13],[10,12,10,13],[11,16,11,17],[12,8,12,9],[13,8,13,9],[24,22,24,23],[25,22,25,23],[26,22,26,23],[8,20,8,21],[9,20,9,21],[10,20,10,21],[11,20,11,21],[12,20,12,21],[13,20,13,21],[24,20,24,21],[25,20,25,21],[14,20,14,21],[15,20,15,21],[16,20,16,21],[17,20,17,21],[18,20,18,21],[19,20,19,21],[26,20,26,21],[22,22,22,23],[23,22,23,23],[20,22,20,23],[10,22,10,23],[11,22,11,23],[1,1,2,5],[3,1,3,5],[4,1,4,5],[15,4,15,5],[6,1,6,2],[2,6,2,9],[11,6,11,7],[7,8,7,9],[8,8,8,9],[9,8,9,9],[5,1,5,5],[13,6,13,7],[14,6,14,7],[15,6,15,7],[10,8,10,9],[1,6,1,17],[2,10,2,13],[4,10,4,13],[14,8,14,9],[15,8,15,9],[3,8,3,9],[13,16,13,17],[2,14,2,17],[5,14,5,17],[27,22,27,23],[6,4,6,5],[7,4,7,5],[8,4,8,5],[9,4,9,5],[10,4,10,5],[11,4,11,5],[12,4,12,5],[13,4,13,5],[14,4,14,5],[16,4,16,5],[17,4,17,5],[18,4,18,5],[19,4,19,5],[20,4,20,5],[21,4,21,5],[22,4,22,5],[23,4,23,5],[24,4,24,5],[18,22,18,23],[19,22,19,23],[25,4,25,5],[26,4,26,5],[27,4,27,5],[27,20,27,21],[3,18,3,19],[7,18,7,19],[8,18,8,19],[9,18,9,19],[10,18,10,19],[11,18,11,19],[27,18,27,19],[24,18,24,19],[26,18,26,19],[25,18,25,19],[14,18,14,19],[15,18,15,19],[16,18,16,19],[17,18,17,19],[18,18,18,19],[19,18,19,19],[20,18,20,19],[6,20,6,21],[6,18,6,19],[4,18,4,19],[5,18,5,19],[23,18,23,19],[12,18,12,19],[8,24,8,25],[20,20,20,21],[21,20,21,21],[22,20,22,21],[23,20,23,21],[21,18,21,19],[22,18,22,19],[11,24,11,25],[13,24,13,25],[10,24,10,25]]}
[]
[null,"Pedestrian Upper Legform",null,null,null,null,"Bending Moment",null,null,null,null,null,null,null,null,null,null,null,"Forces",null,null,null,null,null,null,null,"Total"]
[null,null,null,null,null,null,"upper",null,null,null,"centre",null,null,null,"lower",null,null,null,"upper",null,"lower",null,"sum"]
[null,"TESTNUMBER",null,null,null,null,"Value",null,"Points",null,"Value",null,"Points",null,"Value",null,"Points",null,"Value",null,"Value",null,"Value",null,"Points",null,"Points"]
[null,"UPPER LEGFORM"]
[]
[null,"Points to test",null,null,"Test Energy - J"]
[null,null,"U +10",null,null,null,null,null,{"$f":"IF(NOT($D8=\"Tested\"),\"\",ROUND(Sliding_Scale(G8,285,350,1,0),Round))","v":""},null,null,null,{"$f":"IF(NOT($D8=\"Tested\"),\"\",ROUND(Sliding_Scale(K8,285,350,1,0),Round))","v":""},null,null,null,{"$f":"IF(NOT($D8=\"Tested\"),\"\",ROUND(Sliding_Scale(O8,285,350,1,0),Round))","v":""},null,null,null,null,null,null,null,{"$f":"IF(NOT($D8=\"Tested\"),\"\",ROUND(Sliding_Scale(W8,5,6,1,0),Round))","v":""},null,{"$f":"IF($D8=\"N/A\",\"\",IF($D8=\"Default\",1,IF($D8=\"Tested\",MIN(I8,M8,Q8,Y8),IF($D8=\"Symmetry\",INDIRECT(ADDRESS((18-ROW(C8))*2+ROW(C8),27)),IF(OR($D8=\"Adjacent\"),MIN(AA7,AA9),\"\")))))","v":""},null,{"$f":"IF($D8=\"N/A\",\"\",IF(AA8=1,\"Green\",IF(AA8>0.75,\"Yellow\",IF(AA8>0.5,\"Orange\",IF(AA8>0.25,\"Brown\",\"Red\")))))","v":"Yellow"}]
[null,null,"U +9",null,null,null,null,null,{"$f":"IF(NOT($D9=\"Tested\"),\"\",ROUND(Sliding_Scale(G9,285,350,1,0),Round))","v":""},null,null,null,{"$f":"IF(NOT($D9=\"Tested\"),\"\",ROUND(Sliding_Scale(K9,285,350,1,0),Round))","v":""},null,null,null,{"$f":"IF(NOT($D9=\"Tested\"),\"\",ROUND(Sliding_Scale(O9,285,350,1,0),Round))","v":""},null,null,null,null,null,null,null,"",null,{"$f":"IF($D9=\"N/A\",\"\",IF($D9=\"Default\",1,IF($D9=\"Tested\",MIN(I9,M9,Q9,Y9),IF($D9=\"Symmetry\",INDIRECT(ADDRESS((18-ROW(C9))*2+ROW(C9),27)),IF(OR($D9=\"Adjacent\"),MIN(AA8,AA10),\"\")))))","v":""},null,"Yellow"]
[null,null,"U +8",null,null,null,null,null,{"$f":"IF(NOT($D10=\"Tested\"),\"\",ROUND(Sliding_Scale(G10,285,350,1,0),Round))","v":""},null,null,null,{"$f":"IF(NOT($D10=\"Tested\"),\"\",ROUND(Sliding_Scale(K10,285,350,1,0),Round))","v":""},null,null,null,{"$f":"IF(NOT($D10=\"Tested\"),\"\",ROUND(Sliding_Scale(O10,285,350,1,0),Round))","v":""},null,null,null,null,null,null,null,"",null,"",null,"Yellow"]
[null,null,"U +7",null,null,null,null,null,{"$f":"IF(NOT($D11=\"Tested\"),\"\",ROUND(Sliding_Scale(G11,285,350,1,0),Round))","v":""},null,null,null,{"$f":"IF(NOT($D11=\"Tested\"),\"\",ROUND(Sliding_Scale(K11,285,350,1,0),Round))","v":""},null,null,null,{"$f":"IF(NOT($D11=\"Tested\"),\"\",ROUND(Sliding_Scale(O11,285,350,1,0),Round))","v":""},null,null,null,null,null,null,null,"",null,"",null,"Yellow"]
[null,null,"U +6",null,null,null,null,null,{"$f":"IF(NOT($D12=\"Tested\"),\"\",ROUND(Sliding_Scale(G12,285,350,1,0),Round))","v":""},null,null,null,{"$f":"IF(NOT($D12=\"Tested\"),\"\",ROUND(Sliding_Scale(K12,285,350,1,0),Round))","v":""},null,null,null,{"$f":"IF(NOT($D12=\"Tested\"),\"\",ROUND(Sliding_Scale(O12,285,350,1,0),Round))","v":""},null,null,null,null,null,null,null,"",null,"",null,"Yellow"]
[null,null,"U +5",null,null,null,null,null,{"$f":"IF(NOT($D13=\"Tested\"),\"\",ROUND(Sliding_Scale(G13,285,350,1,0),Round))","v":""},null,null,null,{"$f":"IF(NOT($D13=\"Tested\"),\"\",ROUND(Sliding_Scale(K13,285,350,1,0),Round))","v":""},null,null,null,{"$f":"IF(NOT($D13=\"Tested\"),\"\",ROUND(Sliding_Scale(O13,285,350,1,0),Round))","v":""},null,null,null,null,null,null,null,"",null,"",null,"Yellow"]
[null,null,"U +4",null,null,null,null,null,{"$f":"IF(NOT($D14=\"Tested\"),\"\",ROUND(Sliding_Scale(G14,285,350,1,0),Round))","v":""},null,null,null,{"$f":"IF(NOT($D14=\"Tested\"),\"\",ROUND(Sliding_Scale(K14,285,350,1,0),Round))","v":""},null,null,null,{"$f":"IF(NOT($D14=\"Tested\"),\"\",ROUND(Sliding_Scale(O14,285,350,1,0),Round))","v":""},null,null,null,null,null,null,null,"",null,"",null,"Yellow"]
[null,null,"U +3",null,null,null,null,null,{"$f":"IF(NOT($D15=\"Tested\"),\"\",ROUND(Sliding_Scale(G15,285,350,1,0),Round))","v":""},null,null,null,{"$f":"IF(NOT($D15=\"Tested\"),\"\",ROUND(Sliding_Scale(K15,285,350,1,0),Round))","v":""},null,null,null,{"$f":"IF(NOT($D15=\"Tested\"),\"\",ROUND(Sliding_Scale(O15,285,350,1,0),Round))","v":""},null,null,null,null,null,null,null,"",null,"",null,"Yellow"]
[null,null,"U +2",null,null,null,null,null,{"$f":"IF(NOT($D16=\"Tested\"),\"\",ROUND(Sliding_Scale(G16,285,350,1,0),Round))","v":""},null,null,null,{"$f":"IF(NOT($D16=\"Tested\"),\"\",ROUND(Sliding_Scale(K16,285,350,1,0),Round))","v":""},null,null,null,{"$f":"IF(NOT($D16=\"Tested\"),\"\",ROUND(Sliding_Scale(O16,285,350,1,0),Round))","v":""},null,null,null,null,null,null,null,"",null,"",null,"Yellow"]
[null,null,"U +1",null,null,null,null,null,{"$f":"IF(NOT($D17=\"Tested\"),\"\",ROUND(Sliding_Scale(G17,285,350,1,0),Round))","v":""},null,null,null,{"$f":"IF(NOT($D17=\"Tested\"),\"\",ROUND(Sliding_Scale(K17,285,350,1,0),Round))","v":""},null,null,null,{"$f":"IF(NOT($D17=\"Tested\"),\"\",ROUND(Sliding_Scale(O17,285,350,1,0),Round))","v":""},null,null,null,null,null,null,null,"",null,"",null,"Yellow"]
[null,null,"U 0",null,null,null,null,null,{"$f":"IF(NOT($D18=\"Tested\"),\"\",ROUND(Sliding_Scale(G18,285,350,1,0),Round))","v":""},null,null,null,{"$f":"IF(NOT($D18=\"Tested\"),\"\",ROUND(Sliding_Scale(K18,285,350,1,0),Round))","v":""},null,null,null,{"$f":"IF(NOT($D18=\"Tested\"),\"\",ROUND(Sliding_Scale(O18,285,350,1,0),Round))","v":""},null,null,null,null,null,null,null,"",null,"",null,"Yellow"]
[null,null,"U -1",null,null,null,null,null,{"$f":"IF(NOT($D19=\"Tested\"),\"\",ROUND(Sliding_Scale(G19,285,350,1,0),Round))","v":""},null,null,null,{"$f":"IF(NOT($D19=\"Tested\"),\"\",ROUND(Sliding_Scale(K19,285,350,1,0),Round))","v":""},null,null,null,{"$f":"IF(NOT($D19=\"Tested\"),\"\",ROUND(Sliding_Scale(O19,285,350,1,0),Round))","v":""},null,null,null,null,null,null,null,"",null,"",null,"Yellow"]
[null,null,"U -2",null,null,null,null,null,{"$f":"IF(NOT($D20=\"Tested\"),\"\",ROUND(Sliding_Scale(G20,285,350,1,0),Round))","v":""},null,null,null,{"$f":"IF(NOT($D20=\"Tested\"),\"\",ROUND(Sliding_Scale(K20,285,350,1,0),Round))","v":""},null,null,null,{"$f":"IF(NOT($D20=\"Tested\"),\"\",ROUND(Sliding_Scale(O20,285,350,1,0),Round))","v":""},null,null,null,null,null,null,null,"",null,"",null,"Yellow"]
[null,null,"U -3",null,null,null,null,null,{"$f":"IF(NOT($D21=\"Tested\"),\"\",ROUND(Sliding_Scale(G21,285,350,1,0),Round))","v":""},null,null,null,{"$f":"IF(NOT($D21=\"Tested\"),\"\",ROUND(Sliding_Scale(K21,285,350,1,0),Round))","v":""},null,null,null,{"$f":"IF(NOT($D21=\"Tested\"),\"\",ROUND(Sliding_Scale(O21,285,350,1,0),Round))","v":""},null,null,null,null,null,null,null,"",null,"",null,"Yellow"]
[null,null,"U -4",null,null,null,null,null,{"$f":"IF(NOT($D22=\"Tested\"),\"\",ROUND(Sliding_Scale(G22,285,350,1,0),Round))","v":""},null,null,null,{"$f":"IF(NOT($D22=\"Tested\"),\"\",ROUND(Sliding_Scale(K22,285,350,1,0),Round))","v":""},null,null,null,{"$f":"IF(NOT($D22=\"Tested\"),\"\",ROUND(Sliding_Scale(O22,285,350,1,0),Round))","v":""},null,null,null,null,null,null,null,"",null,"",null,"Yellow"]
[null,null,"U -5",null,null,null,null,null,{"$f":"IF(NOT($D23=\"Tested\"),\"\",ROUND(Sliding_Scale(G23,285,350,1,0),Round))","v":""},null,null,null,{"$f":"IF(NOT($D23=\"Tested\"),\"\",ROUND(Sliding_Scale(K23,285,350,1,0),Round))","v":""},null,null,null,{"$f":"IF(NOT($D23=\"Tested\"),\"\",ROUND(Sliding_Scale(O23,285,350,1,0),Round))","v":""},null,null,null,null,null,null,null,"",null,"",null,"Yellow"]
[null,null,"U -6",null,null,null,null,null,{"$f":"IF(NOT($D24=\"Tested\"),\"\",ROUND(Sliding_Scale(G24,285,350,1,0),Round))","v":""},null,null,null,{"$f":"IF(NOT($D24=\"Tested\"),\"\",ROUND(Sliding_Scale(K24,285,350,1,0),Round))","v":""},null,null,null,{"$f":"IF(NOT($D24=\"Tested\"),\"\",ROUND(Sliding_Scale(O24,285,350,1,0),Round))","v":""},null,null,null,null,null,null,null,"",null,"",null,"Yellow"]
[null,null,"U -7",null,null,null,null,null,{"$f":"IF(NOT($D25=\"Tested\"),\"\",ROUND(Sliding_Scale(G25,285,350,1,0),Round))","v":""},null,null,null,{"$f":"IF(NOT($D25=\"Tested\"),\"\",ROUND(Sliding_Scale(K25,285,350,1,0),Round))","v":""},null,null,null,{"$f":"IF(NOT($D25=\"Tested\"),\"\",ROUND(Sliding_Scale(O25,285,350,1,0),Round))","v":""},null,null,null,null,null,null,null,"",null,"",null,"Yellow"]
[null,null,"U -8",null,null,null,null,null,{"$f":"IF(NOT($D26=\"Tested\"),\"\",ROUND(Sliding_Scale(G26,285,350,1,0),Round))","v":""},null,null,null,{"$f":"IF(NOT($D26=\"Tested\"),\"\",ROUND(Sliding_Scale(K26,285,350,1,0),Round))","v":""},null,null,null,{"$f":"IF(NOT($D26=\"Tested\"),\"\",ROUND(Sliding_Scale(O26,285,350,1,0),Round))","v":""},null,null,null,null,null,null,null,"",null,"",null,"Yellow"]
[null,null,"U -9",null,null,null,null,null,{"$f":"IF(NOT($D27=\"Tested\"),\"\",ROUND(Sliding_Scale(G27,285,350,1,0),Round))","v":""},null,null,null,{"$f":"IF(NOT($D27=\"Tested\"),\"\",ROUND(Sliding_Scale(K27,285,350,1,0),Round))","v":""},null,null,null,{"$f":"IF(NOT($D27=\"Tested\"),\"\",ROUND(Sliding_Scale(O27,285,350,1,0),Round))","v":""},null,null,null,null,null,null,null,"",null,"",null,"Yellow"]
[null,null,"U -10",null,null,null,null,null,{"$f":"IF(NOT($D28=\"Tested\"),\"\",ROUND(Sliding_Scale(G28,285,350,1,0),Round))","v":""},null,null,null,{"$f":"IF(NOT($D28=\"Tested\"),\"\",ROUND(Sliding_Scale(K28,285,350,1,0),Round))","v":""},null,null,null,{"$f":"IF(NOT($D28=\"Tested\"),\"\",ROUND(Sliding_Scale(O28,285,350,1,0),Round))","v":""},null,null,null,null,null,null,null,"",null,"",null,"Yellow"]
[]
[null,null,null,null,null,null,null,"+10","+9","+8","+7","+6","+5","+4","+3","+2","+1","0","-1","-2","-3","-4","-5","-6","-7","-8","-9","-10"]
[null,null,null,null,null,null,null,{"$f":"AA8","v":""},{"$f":"AA9","v":""},{"$f":"AA10","v":""},{"$f":"AA11","v":""},{"$f":"AA12","v":""},{"$f":"AA13","v":""},{"$f":"AA14","v":""},{"$f":"AA15","v":""},{"$f":"AA16","v":""},{"$f":"AA17","v":""},{"$f":"AA18","v":""},{"$f":"AA19","v":""},{"$f":"AA20","v":""},{"$f":"AA21","v":""},{"$f":"AA22","v":""},{"$f":"AA23","v":""},{"$f":"AA24","v":""},{"$f":"AA25","v":""},{"$f":"AA26","v":""},{"$f":"AA27","v":""},{"$f":"AA28","v":""}]
[]
[null,"Upper Legform assessment",null,null,null,null,{"$f":"IF(AA18=\"\",0,ROUND(SUM(AA8:AA28)/(21-COUNTIF(AA8:AA28,\"\"))*6,Round))","v":0}]
[]
[null,"TOTAL PEDESTRIAN UPPER LEGFORM",null,null,null,null,{"$f":"G33","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(G35,1)","v":0}]

{"sheet":"VRU Lower Legform","index":14,"n_rows":35,"n_cols":26,"rows_kept":35,"cut":false,"hidden":false,"merged":[[13,16,13,17],[8,16,8,17],[14,16,14,17],[15,16,15,17],[15,8,15,9],[10,4,10,5],[10,6,10,7],[10,8,10,9],[10,10,10,11],[11,10,11,11],[8,10,8,11],[9,4,9,5],[9,6,9,7],[8,4,8,5],[22,4,22,5],[22,6,22,7],[23,6,23,7],[19,4,19,5],[19,6,19,7],[19,8,19,9],[19,10,19,11],[18,8,18,9],[20,4,20,5],[21,8,21,9],[22,8,22,9],[20,6,20,7],[20,8,20,9],[20,10,20,11],[21,4,21,5],[27,6,27,7],[27,8,27,9],[23,10,23,11],[27,10,27,11],[24,6,24,7],[25,8,25,9],[25,10,25,11],[24,8,24,9],[24,10,24,11],[23,8,23,9],[26,6,26,7],[26,8,26,9],[26,10,26,11],[25,6,25,7],[17,4,17,5],[22,12,22,13],[15,12,15,13],[16,12,16,13],[17,12,17,13],[16,4,16,5],[14,6,14,7],[11,8,11,9],[14,10,14,11],[15,10,15,11],[14,4,14,5],[14,8,14,9],[12,8,12,9],[15,4,15,5],[15,6,15,7],[21,10,21,11],[22,10,22,11],[18,10,18,11],[21,6,21,7],[16,6,16,7],[17,6,17,7],[17,8,17,9],[12,10,12,11],[11,4,11,5],[18,20,18,21],[19,20,19,21],[20,20,20,21],[21,20,21,21],[22,20,22,21],[23,20,23,21],[24,20,24,21],[25,12,25,13],[26,18,26,19],[26,12,26,13],[26,20,26,21],[24,18,24,19],[23,16,23,17],[21,16,21,17],[26,16,26,17],[34,1,34,3],[34,4,34,24],[1,18,2,21],[7,12,7,13],[8,12,8,13],[9,12,9,13],[10,12,10,13],[11,20,11,21],[18,12,18,13],[24,12,24,13],[16,20,16,21],[17,20,17,21],[18,16,18,17],[19,12,19,13],[20,12,20,13],[21,12,21,13],[20,16,20,17],[18,18,18,19],[16,16,16,17],[27,22,27,24],[28,1,28,24],[29,1,29,3],[30,1,30,3],[31,1,31,24],[25,22,25,24],[25,20,25,21],[25,4,25,5],[32,1,32,3],[32,4,32,24],[27,16,27,17],[26,22,26,24],[27,18,27,19],[22,18,22,19],[25,16,25,17],[22,22,22,24],[23,18,23,19],[22,16,22,17],[24,16,24,17],[24,22,24,24],[25,18,25,19],[23,22,23,24],[23,12,23,13],[27,20,27,21],[27,12,27,13],[24,4,24,5],[26,4,26,5],[23,4,23,5],[27,4,27,5],[20,22,20,24],[21,18,21,19],[3,4,3,11],[19,22,19,24],[20,18,20,19],[18,22,18,24],[15,22,15,24],[21,22,21,24],[12,20,12,21],[13,20,13,21],[9,18,9,19],[11,22,11,24],[10,20,10,21],[19,18,19,19],[9,16,9,17],[10,16,10,17],[17,22,17,24],[16,22,16,24],[14,20,14,21],[15,20,15,21],[13,22,13,24],[19,16,19,17],[10,22,10,24],[12,16,12,17],[17,18,17,19],[11,12,11,13],[12,12,12,13],[13,12,13,13],[14,12,14,13],[14,22,14,24],[17,10,17,11],[18,4,18,5],[18,6,18,7],[17,16,17,17],[16,10,16,11],[12,22,12,24],[13,18,13,19],[12,4,12,5],[12,6,12,7],[16,18,16,19],[15,18,15,19],[16,8,16,9],[12,18,12,19],[14,18,14,19],[13,4,13,5],[13,6,13,7],[13,8,13,9],[13,10,13,11],[9,22,9,24],[8,22,8,24],[7,20,7,21],[9,10,9,11],[9,20,9,21],[7,18,7,19],[8,20,8,21],[9,8,9,9],[11,6,11,7],[8,8,8,9],[7,22,7,24],[8,6,8,7],[7,8,7,9],[7,10,7,11],[7,6,7,7],[11,18,11,19],[10,18,10,19],[11,16,11,17],[8,18,8,19],[7,16,7,17],[1,1,2,3],[6,1,6,2],[5,1,5,3],[4,1,4,3],[4,22,4,24],[2,12,3,13],[3,1,3,3],[3,18,3,19],[3,20,3,21],[1,22,2,24],[1,4,1,13],[2,4,2,5],[6,22,6,24],[2,6,2,7],[2,8,2,9],[2,10,2,11],[1,14,1,17],[3,14,3,15],[3,16,3,17],[7,4,7,5],[4,4,4,13],[4,14,4,17],[5,14,5,17],[5,22,5,24],[2,16,2,17],[4,18,4,21],[5,18,5,21],[6,18,6,21],[3,22,3,24],[5,4,5,13],[6,4,6,13],[6,14,6,17]]}
[]
[null,"Pedestrian Lower Legform",null,null,"Tibia Bending Moment",null,null,null,null,null,null,null,null,null,"ACL/PCL",null,null,null,"MCL Elongation",null,null,null,"Total"]
[null,null,null,null,"T1",null,"T2",null,"T3",null,"T4",null,"Points",null,"ACL","PCL"]
[null,"TESTNUMBER",null,null,"Value",null,null,null,null,null,null,null,null,null,"Value",null,"PASS/FAIL",null,"Value",null,"Points",null,"Points"]
[null,"LOWER LEGFORM"]
[]
[null,"Points to test"]
[null,null,"L +10",null,null,null,null,null,null,null,null,null,{"$f":"IF(NOT($D8=\"Tested\"),\"\",ROUND(Sliding_Scale(MAX(E8,G8,I8,K8),282,340,0.5,0),Round))","v":""},null,null,null,{"$f":"IF(NOT($D8=\"Tested\"),\"\",IF(MAX(O8,P8)>=10,\"FAIL\",\"PASS\"))","v":""},null,null,null,{"$f":"IF(NOT($D8=\"Tested\"),\"\",ROUND(Sliding_Scale(S8,19,22,0.5,0),Round))","v":""},null,{"$f":"IF($D8=\"N/A\",\"\",IF($D8=\"Tested\",M8+IF(Q8=\"PASS\",U8),IF($D8=\"Symmetry\",INDIRECT(ADDRESS((18-ROW(C8))*2+ROW(C8),23)),IF($D8=\"Adjacent\",MIN(W7,W9),\"\"))))","v":""},null,null,{"$f":"IF($D8=\"N/A\",\"\",IF(W8=1,\"Green\",IF(W8>0.75,\"Yellow\",IF(W8>0.5,\"Orange\",IF(W8>0.25,\"Brown\",\"Red\")))))","v":"Yellow"}]
[null,null,"L +9",null,null,null,null,null,null,null,null,null,"",null,null,null,{"$f":"IF(NOT($D9=\"Tested\"),\"\",IF(MAX(O9,P9)>=10,\"FAIL\",\"PASS\"))","v":""},null,null,null,"",null,{"$f":"IF($D9=\"N/A\",\"\",IF($D9=\"Tested\",M9+IF(Q9=\"PASS\",U9),IF($D9=\"Symmetry\",INDIRECT(ADDRESS((18-ROW(C9))*2+ROW(C9),23)),IF($D9=\"Adjacent\",MIN(W8,W10),\"\"))))","v":""},null,null,{"$f":"IF($D9=\"N/A\",\"\",IF(W9=1,\"Green\",IF(W9>0.75,\"Yellow\",IF(W9>0.5,\"Orange\",IF(W9>0.25,\"Brown\",\"Red\")))))","v":"Yellow"}]
[null,null,"L +8",null,null,null,null,null,null,null,null,null,"",null,null,null,"",null,null,null,"",null,"",null,null,"Yellow"]
[null,null,"L +7",null,null,null,null,null,null,null,null,null,"",null,null,null,"",null,null,null,"",null,"",null,null,"Yellow"]
[null,null,"L +6",null,null,null,null,null,null,null,null,null,"",null,null,null,"",null,null,null,"",null,"",null,null,"Yellow"]
[null,null,"L +5",null,null,null,null,null,null,null,null,null,"",null,null,null,"",null,null,null,"",null,"",null,null,"Yellow"]
[null,null,"L +4",null,null,null,null,null,null,null,null,null,"",null,null,null,"",null,null,null,"",null,"",null,null,"Yellow"]
[null,null,"L +3",null,null,null,null,null,null,null,null,null,"",null,null,null,"",null,null,null,"",null,"",null,null,"Yellow"]
[null,null,"L +2",null,null,null,null,null,null,null,null,null,"",null,null,null,"",null,null,null,"",null,"",null,null,"Yellow"]
[null,null,"L +1",null,null,null,null,null,null,null,null,null,"",null,null,null,"",null,null,null,"",null,"",null,null,"Yellow"]
[null,null,"L 0",null,null,null,null,null,null,null,null,null,"",null,null,null,"",null,null,null,"",null,"",null,null,"Yellow"]
[null,null,"L -1",null,null,null,null,null,null,null,null,null,"",null,null,null,"",null,null,null,"",null,"",null,null,"Yellow"]
[null,null,"L -2",null,null,null,null,null,null,null,null,null,"",null,null,null,"",null,null,null,"",null,"",null,null,"Yellow"]
[null,null,"L -3",null,null,null,null,null,null,null,null,null,"",null,null,null,"",null,null,null,"",null,"",null,null,"Yellow"]
[null,null,"L -4",null,null,null,null,null,null,null,null,null,"",null,null,null,"",null,null,null,"",null,"",null,null,"Yellow"]
[null,null,"L -5",null,null,null,null,null,null,null,null,null,"",null,null,null,"",null,null,null,"",null,"",null,null,"Yellow"]
[null,null,"L -6",null,null,null,null,null,null,null,null,null,"",null,null,null,"",null,null,null,"",null,"",null,null,"Yellow"]
[null,null,"L -7",null,null,null,null,null,null,null,null,null,"",null,null,null,"",null,null,null,"",null,"",null,null,"Yellow"]
[null,null,"L -8",null,null,null,null,null,null,null,null,null,"",null,null,null,"",null,null,null,"",null,"",null,null,"Yellow"]
[null,null,"L -9",null,null,null,null,null,null,null,null,null,"",null,null,null,"",null,null,null,"",null,"",null,null,"Yellow"]
[null,null,"L -10",null,null,null,null,null,null,null,null,null,"",null,null,null,"",null,null,null,"",null,"",null,null,"Yellow"]
[]
[null,null,null,null,"+10","+9","+8","+7","+6","+5","+4","+3","+2","+1","0","-1","-2","-3","-4","-5","-6","-7","-8","-9","-10"]
[null,null,null,null,{"$f":"W8","v":""},{"$f":"W9","v":""},{"$f":"W10","v":""},{"$f":"W11","v":""},{"$f":"W12","v":""},{"$f":"W13","v":""},{"$f":"W14","v":""},{"$f":"W15","v":""},{"$f":"W16","v":""},{"$f":"W17","v":""},{"$f":"W18","v":""},{"$f":"W19","v":""},{"$f":"W20","v":""},{"$f":"W21","v":""},{"$f":"W22","v":""},{"$f":"W23","v":""},{"$f":"W24","v":""},{"$f":"W25","v":""},{"$f":"W26","v":""},{"$f":"W27","v":""},{"$f":"W28","v":""}]
[]
[null,"Lower Legform assessment",null,null,{"$f":"IF(W18=\"\",0,ROUND(SUM(W8:W28)/(21-COUNTIF(W8:W28,\"\"))*6,Round))","v":0}]
[]
[null,"TOTAL PEDESTRIAN LOWER LEGFORM",null,null,{"$f":"E33","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(E35,1)","v":0}]

{"sheet":"VRU AEB Pedestrian","index":15,"n_rows":126,"n_cols":7,"rows_kept":126,"cut":false,"hidden":false,"merged":[[115,3,115,4],[115,5,115,6],[116,3,116,4],[116,5,116,6],[122,3,122,6],[123,3,123,6],[125,1,125,2],[125,3,125,6],[119,3,119,4],[119,5,119,6],[121,1,121,2],[121,3,121,6],[117,3,117,4],[117,5,117,6],[118,3,118,4],[118,5,118,6],[110,1,110,2],[110,3,110,4],[110,5,110,6],[112,1,112,2],[112,3,112,4],[112,5,112,6],[113,3,113,4],[113,5,113,6],[114,3,114,4],[114,5,114,6],[66,5,66,6],[67,5,67,6],[68,5,68,6],[69,5,69,6],[73,5,73,6],[74,5,74,6],[75,5,75,6],[76,5,76,6],[83,5,83,6],[90,3,90,4],[90,5,90,6],[100,1,100,2],[100,3,100,4],[100,5,100,6],[71,1,71,2],[71,3,71,4],[71,5,71,6],[70,5,70,6],[88,1,88,2],[88,3,88,4],[88,5,88,6],[85,5,85,6],[86,5,86,6],[87,5,87,6],[84,5,84,6],[77,1,77,2],[77,3,77,4],[77,5,77,6],[81,5,81,6],[80,5,80,6],[79,5,79,6],[82,5,82,6],[65,5,65,6],[43,1,43,2],[43,3,43,4],[43,5,43,6],[45,3,45,4],[31,3,31,4],[31,5,31,6],[60,5,60,6],[63,5,63,6],[64,5,64,6],[59,3,59,4],[59,5,59,6],[22,5,22,6],[57,1,57,2],[57,3,57,4],[57,5,57,6],[17,3,17,4],[17,5,17,6],[45,5,45,6],[62,5,62,6],[61,5,61,6],[29,1,29,2],[29,3,29,4],[29,5,29,6],[23,5,23,6],[24,5,24,6],[25,5,25,6],[27,5,27,6],[28,5,28,6],[26,5,26,6],[1,1,2,2],[1,3,2,4],[1,5,2,6],[20,5,20,6],[21,5,21,6],[11,3,11,6],[10,3,10,6],[3,1,3,2],[4,3,4,6],[5,3,5,6],[6,3,6,6],[7,3,7,6],[8,3,8,6],[12,3,12,6],[14,5,14,6],[15,1,15,2],[13,5,13,6],[14,3,14,4],[15,3,15,4],[15,5,15,6],[18,5,18,6],[19,5,19,6],[13,3,13,4]]}
[3]
[null,"AEB Pedestrian",null,"Daytime",null,"Night-time"]
[]
[null,"TESTNUMBER",null,"Vimpact","Points","Vimpact","Points"]
[null,"SYSTEM DETAILS"]
[null,null,"System Name"]
[null,null,"Functionality"]
[null,null,"Speed range (km/h) - Minimum"]
[null,null,"Maximum"]
[]
[null,"PREREQUISITES"]
[]
[null,null,"Default ON"]
[null,null,"Can identify slower walking pedestrian (CPNA-75)"]
[null,null,"System switches off below 80 km/h"]
[null,"PREREQUISITES",null,{"$f":"IF(AND(D13=\"YES\",D14=\"PASS\",D15=\"NO\"),\"PASS\",\"FAIL\")","v":"FAIL"},null,{"$f":"IF(AND(D13=\"YES\",F14=\"PASS\",F15=\"NO\"),\"PASS\",\"FAIL\")","v":"FAIL"}]
[]
[null,"CPFA-50"]
[null,1,10,null,{"$f":"IF(D19=\"\",0,ROUND(($C19-IF(D19>$C19,$C19,D19))/$C19*1,Round))","v":0}]
[null,2,15,null,{"$f":"IF(D20=\"\",0,ROUND(($C20-IF(D20>$C20,$C20,D20))/$C20*1,Round))","v":0}]
[null,1,20,null,{"$f":"IF(D21=\"\",0,ROUND(($C21-IF(D21>$C21,$C21,D21))/$C21*1,Round))","v":0}]
[null,2,25,null,{"$f":"IF(D22=\"\",0,ROUND(($C22-IF(D22>$C22,$C22,D22))/$C22*1,Round))","v":0}]
[null,2,30,null,{"$f":"IF(D23=\"\",0,ROUND(($C23-IF(D23>$C23,$C23,D23))/$C23*2,Round))","v":0}]
[null,3,35,null,{"$f":"IF(D24=\"\",0,ROUND(($C24-IF(D24>$C24,$C24,D24))/$C24*3,Round))","v":0}]
[null,3,40,null,{"$f":"IF(D25=\"\",0,ROUND(($C25-IF(D25>$C25,$C25,D25))/$C25*3,Round))","v":0}]
[null,null,45,null,{"$f":"IF(D26=\"\",0,IF(D26<=(C26-20),3,0))","v":0}]
[null,null,50,null,{"$f":"IF(D27=\"\",0,IF(D27<=(C27-20),2,0))","v":0}]
[null,null,55,null,{"$f":"IF(D28=\"\",0,IF(D28<=(C28-20),2,0))","v":0}]
[null,null,60,null,{"$f":"IF(D29=\"\",0,IF(D29<=(C29-20),1,0))","v":0}]
[null,"CPFA-50 RESULT",null,{"$f":"IF((COUNTBLANK(D19:D25)+COUNTBLANK(D26:D29))>0,0,SUM(E19:E25,E26:E29))","v":0}]
[]
[null,"CPNA-25"]
[null,1,10,null,{"$f":"IF(D33=\"\",0,ROUND(($C33-IF(D33>$C33,$C33,D33))/$C33*1,Round))","v":0},null,{"$f":"IF(F33=\"\",0,ROUND(($C33-IF(F33>$C33,$C33,F33))/$C33*1,Round))","v":0}]
[null,2,15,null,{"$f":"IF(D34=\"\",0,ROUND(($C34-IF(D34>$C34,$C34,D34))/$C34*1,Round))","v":0},null,{"$f":"IF(F34=\"\",0,ROUND(($C34-IF(F34>$C34,$C34,F34))/$C34*1,Round))","v":0}]
[null,1,20,null,{"$f":"IF(D35=\"\",0,ROUND(($C35-IF(D35>$C35,$C35,D35))/$C35*1,Round))","v":0},null,{"$f":"IF(F35=\"\",0,ROUND(($C35-IF(F35>$C35,$C35,F35))/$C35*1,Round))","v":0}]
[null,2,25,null,{"$f":"IF(D36=\"\",0,ROUND(($C36-IF(D36>$C36,$C36,D36))/$C36*1,Round))","v":0},null,{"$f":"IF(F36=\"\",0,ROUND(($C36-IF(F36>$C36,$C36,F36))/$C36*1,Round))","v":0}]
[null,2,30,null,{"$f":"IF(D37=\"\",0,ROUND(($C37-IF(D37>$C37,$C37,D37))/$C37*2,Round))","v":0},null,{"$f":"IF(F37=\"\",0,ROUND(($C37-IF(F37>$C37,$C37,F37))/$C37*1,Round))","v":0}]
[null,3,35,null,{"$f":"IF(D38=\"\",0,ROUND(($C38-IF(D38>$C38,$C38,D38))/$C38*3,Round))","v":0},null,{"$f":"IF(F38=\"\",0,ROUND(($C38-IF(F38>$C38,$C38,F38))/$C38*2,Round))","v":0}]
[null,3,40,null,{"$f":"IF(D39=\"\",0,ROUND(($C39-IF(D39>$C39,$C39,D39))/$C39*3,Round))","v":0},null,{"$f":"IF(F39=\"\",0,ROUND(($C39-IF(F39>$C39,$C39,F39))/$C39*2,Round))","v":0}]
[null,null,45,null,{"$f":"IF(D40=\"\",0,IF(D40<=(C40-20),3,0))","v":0},null,{"$f":"IF(F40=\"\",0,IF(F40<=(C40-20),3,0))","v":0}]
[null,null,50,null,{"$f":"IF(D41=\"\",0,IF(D41<=(C41-20),2,0))","v":0},null,{"$f":"IF(F41=\"\",0,IF(F41<=(C41-20),3,0))","v":0}]
[null,null,55,null,{"$f":"IF(D42=\"\",0,IF(D42<=(C42-20),2,0))","v":0},null,{"$f":"IF(F42=\"\",0,IF(F42<=(C42-20),3,0))","v":0}]
[null,null,60,null,{"$f":"IF(D43=\"\",0,IF(D43<=(C43-20),1,0))","v":0},null,{"$f":"IF(F43=\"\",0,IF(F43<=(C43-20),2,0))","v":0}]
[null,"CPNA-25 RESULT",null,{"$f":"IF((COUNTBLANK(D33:D39)+COUNTBLANK(D40:D43))>0,0,SUM(E33:E39,E40:E43))","v":0},null,{"$f":"IF((COUNTBLANK(F33:F39)+COUNTBLANK(F40:F43))>0,0,SUM(G33:G39,G40:G43))","v":0}]
[]
[null,"CPNA-75"]
[null,1,10,null,{"$f":"IF(D47=\"\",0,ROUND(($C47-IF(D47>$C47,$C47,D47))/$C47*1,Round))","v":0},null,{"$f":"IF(F47=\"\",0,ROUND(($C47-IF(F47>$C47,$C47,F47))/$C47*1,Round))","v":0}]
[null,1,15,null,{"$f":"IF(D48=\"\",0,ROUND(($C48-IF(D48>$C48,$C48,D48))/$C48*1,Round))","v":0},null,{"$f":"IF(F48=\"\",0,ROUND(($C48-IF(F48>$C48,$C48,F48))/$C48*1,Round))","v":0}]
[null,2,20,null,{"$f":"IF(D49=\"\",0,ROUND(($C49-IF(D49>$C49,$C49,D49))/$C49*1,Round))","v":0},null,{"$f":"IF(F49=\"\",0,ROUND(($C49-IF(F49>$C49,$C49,F49))/$C49*1,Round))","v":0}]
[null,2,25,null,{"$f":"IF(D50=\"\",0,ROUND(($C50-IF(D50>$C50,$C50,D50))/$C50*1,Round))","v":0},null,{"$f":"IF(F50=\"\",0,ROUND(($C50-IF(F50>$C50,$C50,F50))/$C50*1,Round))","v":0}]
[null,2,30,null,{"$f":"IF(D51=\"\",0,ROUND(($C51-IF(D51>$C51,$C51,D51))/$C51*2,Round))","v":0},null,{"$f":"IF(F51=\"\",0,ROUND(($C51-IF(F51>$C51,$C51,F51))/$C51*1,Round))","v":0}]
[null,3,35,null,{"$f":"IF(D52=\"\",0,ROUND(($C52-IF(D52>$C52,$C52,D52))/$C52*3,Round))","v":0},null,{"$f":"IF(F52=\"\",0,ROUND(($C52-IF(F52>$C52,$C52,F52))/$C52*2,Round))","v":0}]
[null,3,40,null,{"$f":"IF(D53=\"\",0,ROUND(($C53-IF(D53>$C53,$C53,D53))/$C53*3,Round))","v":0},null,{"$f":"IF(F53=\"\",0,ROUND(($C53-IF(F53>$C53,$C53,F53))/$C53*2,Round))","v":0}]
[null,null,45,null,{"$f":"IF(D54=\"\",0,IF(D54<=(C54-20),3,0))","v":0},null,{"$f":"IF(F54=\"\",0,IF(F54<=(C54-20),3,0))","v":0}]
[null,null,50,null,{"$f":"IF(D55=\"\",0,IF(D55<=(C55-20),2,0))","v":0},null,{"$f":"IF(F55=\"\",0,IF(F55<=(C55-20),3,0))","v":0}]
[null,null,55,null,{"$f":"IF(D56=\"\",0,IF(D56<=(C56-20),2,0))","v":0},null,{"$f":"IF(F56=\"\",0,IF(F56<=(C56-20),3,0))","v":0}]
[null,null,60,null,{"$f":"IF(D57=\"\",0,IF(D57<=(C57-20),1,0))","v":0},null,{"$f":"IF(F57=\"\",0,IF(F57<=(C57-20),2,0))","v":0}]
[null,"CPNA-75 RESULT",null,{"$f":"IF((COUNTBLANK(D47:D53)+COUNTBLANK(D54:D57))>0,0,SUM(E47:E53,E54:E57))","v":0},null,{"$f":"IF((COUNTBLANK(F47:F53)+COUNTBLANK(F54:F57))>0,0,SUM(G47:G53,G54:G57))","v":0}]
[]
[null,"CPNC-50"]
[null,1,10,null,{"$f":"IF(D61=\"\",0,ROUND(($C61-IF(D61>$C61,$C61,D61))/$C61*1,Round))","v":0}]
[null,2,15,null,{"$f":"IF(D62=\"\",0,ROUND(($C62-IF(D62>$C62,$C62,D62))/$C62*1,Round))","v":0}]
[null,2,20,null,{"$f":"IF(D63=\"\",0,ROUND(($C63-IF(D63>$C63,$C63,D63))/$C63*1,Round))","v":0}]
[null,2,25,null,{"$f":"IF(D64=\"\",0,ROUND(($C64-IF(D64>$C64,$C64,D64))/$C64*1,Round))","v":0}]
[null,2,30,null,{"$f":"IF(D65=\"\",0,ROUND(($C65-IF(D65>$C65,$C65,D65))/$C65*2,Round))","v":0}]
[null,3,35,null,{"$f":"IF(D66=\"\",0,ROUND(($C66-IF(D66>$C66,$C66,D66))/$C66*3,Round))","v":0}]
[null,3,40,null,{"$f":"IF(D67=\"\",0,ROUND(($C67-IF(D67>$C67,$C67,D67))/$C67*3,Round))","v":0}]
[null,null,45,null,{"$f":"IF(D68=\"\",0,IF(D68<=(C68-20),3,0))","v":0}]
[null,null,50,null,{"$f":"IF(D69=\"\",0,IF(D69<=(C69-20),2,0))","v":0}]
[null,null,55,null,{"$f":"IF(D70=\"\",0,IF(D70<=(C70-20),2,0))","v":0}]
[null,null,60,null,{"$f":"IF(D71=\"\",0,IF(D71<=(C71-20),1,0))","v":0}]
[null,"CPNC-50 RESULT",null,{"$f":"IF((COUNTBLANK(D61:D67)+COUNTBLANK(D68:D71))>0,0,SUM(E61:E67,E68:E71))","v":0}]
[]
[null,"CPTA-50",null,"Farside turn","Nearside turn"]
[null,1,10]
[null,2,15]
[null,2,20]
[null,"CPTA-50 RESULT",null,{"$f":"IF((COUNTBLANK(D75:D77)+COUNTBLANK(E75)>0),0,COUNTIF(D75:D77,\"=0\")+COUNTIF(E75,\"=0\"))","v":0}]
[]
[null,"CPRA",null,"Stationary","Moving"]
[null,null,"4 km/h reverse"]
[null,1,"hitpoint @ 25%"]
[null,2,"hitpoint @ 50%"]
[null,2,"hitpoint @ 75%"]
[null,null,"8 km/h reverse"]
[null,1,"hitpoint @ 25%"]
[null,2,"hitpoint @ 50%"]
[null,2,"hitpoint @ 75%"]
[null,"CPRA RESULT",null,{"$f":"IF(COUNTIF(D82:D84,\"=0\")=3,1,0)+IF(COUNTIF(E83,\"=0\")=1,1,0)+IF(COUNTIF(D86:D88,\"=0\")=3,1,0)+IF(COUNTIF(E87,\"=0\")=1,1,0)","v":0}]
[]
[null,"CPLA-50"]
[null,1,20,null,{"$f":"IF(D92=\"\",0,ROUND((($C92-5)-(IF(D92<=5,5,IF(D92>$C92,$C92,D92))-5))/($C92-5)*$B92,Round))","v":0},null,{"$f":"IF(F92=\"\",0,ROUND((($C92-5)-(IF(F92<=5,5,IF(F92>$C92,$C92,F92))-5))/($C92-5)*$B92,Round))","v":0}]
[null,1,25,null,{"$f":"IF(D93=\"\",0,ROUND((($C93-5)-(IF(D93<=5,5,IF(D93>$C93,$C93,D93))-5))/($C93-5)*$B93,Round))","v":0},null,{"$f":"IF(F93=\"\",0,ROUND((($C93-5)-(IF(F93<=5,5,IF(F93>$C93,$C93,F93))-5))/($C93-5)*$B93,Round))","v":0}]
[null,1,30,null,{"$f":"IF(D94=\"\",0,ROUND((($C94-5)-(IF(D94<=5,5,IF(D94>$C94,$C94,D94))-5))/($C94-5)*$B94,Round))","v":0},null,{"$f":"IF(F94=\"\",0,ROUND((($C94-5)-(IF(F94<=5,5,IF(F94>$C94,$C94,F94))-5))/($C94-5)*$B94,Round))","v":0}]
[null,2,35,null,{"$f":"IF(D95=\"\",0,ROUND((($C95-5)-(IF(D95<=5,5,IF(D95>$C95,$C95,D95))-5))/($C95-5)*$B95,Round))","v":0},null,{"$f":"IF(F95=\"\",0,ROUND((($C95-5)-(IF(F95<=5,5,IF(F95>$C95,$C95,F95))-5))/($C95-5)*$B95,Round))","v":0}]
[null,2,40,null,{"$f":"IF(D96=\"\",0,ROUND((($C96-5)-(IF(D96<=5,5,IF(D96>$C96,$C96,D96))-5))/($C96-5)*$B96,Round))","v":0},null,{"$f":"IF(F96=\"\",0,ROUND((($C96-5)-(IF(F96<=5,5,IF(F96>$C96,$C96,F96))-5))/($C96-5)*$B96,Round))","v":0}]
[null,3,45,null,{"$f":"IF(D97=\"\",0,IF(D97<=(C97-20),$B97,0))","v":0},null,{"$f":"IF(F97=\"\",0,IF(F97<=($C97-20),$B97,0))","v":0}]
[null,3,50,null,{"$f":"IF(D98=\"\",0,IF(D98<=(C98-20),$B98,0))","v":0},null,{"$f":"IF(F98=\"\",0,IF(F98<=($C98-20),$B98,0))","v":0}]
[null,3,55,null,{"$f":"IF(D99=\"\",0,IF(D99<=(C99-20),$B99,0))","v":0},null,{"$f":"IF(F99=\"\",0,IF(F99<=($C99-20),$B99,0))","v":0}]
[null,2,60,null,{"$f":"IF(D100=\"\",0,IF(D100<=(C100-20),$B100,0))","v":0},null,{"$f":"IF(F100=\"\",0,IF(F100<=($C100-20),$B100,0))","v":0}]
[null,"CPLA-50 RESULT",null,{"$f":"IF((COUNTBLANK(D92:D96)+COUNTBLANK(D97:D100))>0,0,SUM(E92:E96,E97:E100))","v":0},null,{"$f":"IF((COUNTBLANK(F92:F96)+COUNTBLANK(F97:F100))>0,0,SUM(G92:G96,G97:G100))","v":0}]
[]
[null,"CPLA-25",null,"TTCFCW","Points","TTCFCW","Points"]
[null,3,50,null,{"$f":"IF(D104=\"\",0,IF(D104>=1.7,$B104,0))","v":0},null,{"$f":"IF(F104=\"\",0,IF(F104>=1.7,$B104,0))","v":0}]
[null,3,55,null,0,null,0]
[null,2,60,null,0,null,0]
[null,1,65,null,0,null,0]
[null,1,70,null,0,null,0]
[null,1,75,null,0,null,0]
[null,1,80,null,0,null,0]
[null,"CPLA-25 RESULT",null,{"$f":"IF((COUNTBLANK(D104:D108)+COUNTBLANK(D109:D110))>0,0,SUM(E104:E108,E109:E110))","v":0},null,{"$f":"IF((COUNTBLANK(F104:F108)+COUNTBLANK(F109:F110))>0,0,SUM(G104:G108,G109:G110))","v":0}]
[]
[null,"SUMMARY",null,"DAYTIME",null,"NIGHT-TIME"]
[null,null,"CPFA-50",{"$f":"ROUND(D30/20,Round)","v":0}]
[null,null,"CPNA-25",{"$f":"ROUND(D44/20,Round)","v":0},null,{"$f":"ROUND(F44/20,Round)","v":0}]
[null,null,"CPNA-75",{"$f":"ROUND(D58/20,Round)","v":0},null,{"$f":"ROUND(F58/20,Round)","v":0}]
[null,null,"CPNC-50",{"$f":"ROUND(D72/20,Round)","v":0}]
[null,null,"CPLA",{"$f":"ROUND((D101+D111)/30,Round)","v":0},null,{"$f":"ROUND((F101+F111)/30,Round)","v":0}]
[null,null,"CPTA",{"$f":"ROUND(D78/4,Round)","v":0}]
[null,null,"CPRA",{"$f":"ROUND(D89/4,Round)","v":0}]
[]
[null,"TOTAL"]
[null,null,"Daytime",{"$f":"IF(D16=\"FAIL\",0,ROUND(D114*0.5+D115*0.25+D116*0.25+D117*1+D118*1+D119*1+D120*2,Round))","v":0}]
[null,null,"Night-time",{"$f":"IF(F16=\"FAIL\",0,ROUND(F115*1+F116*1+F118*1,Round))","v":0}]
[]
[null,"TOTAL AEB Pedestrian",null,{"$f":"ROUND(SUM(D123:G124),Round)","v":0}]

{"sheet":"VRU AEB Cyclist","index":16,"n_rows":86,"n_cols":5,"rows_kept":86,"cut":false,"hidden":false,"merged":[[10,3,10,4],[4,3,4,4],[5,3,5,4],[6,3,6,4],[7,3,7,4],[8,3,8,4],[1,1,2,2],[83,3,83,4],[79,1,79,2],[79,3,79,4],[80,3,80,4],[58,3,58,4],[30,3,30,4],[67,1,67,2],[3,1,3,2],[14,1,14,2],[14,3,14,4],[11,3,11,4],[77,3,77,4],[1,3,2,4],[12,3,12,4],[13,3,13,4],[67,3,67,4],[77,1,77,2],[85,1,85,2],[85,3,85,4],[84,3,84,4],[81,3,81,4],[82,3,82,4],[16,3,16,4],[28,1,28,2],[28,3,28,4],[44,3,44,4],[56,1,56,2],[56,3,56,4],[42,1,42,2],[42,3,42,4]]}
[3]
[null,"AEB Cyclist"]
[]
[null,"TESTNUMBER",null,"Vimpact","Points"]
[null,"SYSTEM DETAILS"]
[null,null,"System Name"]
[null,null,"Functionality"]
[null,null,"Speed range (km/h) - Minimum"]
[null,null,"Maximum"]
[]
[null,"PREREQUISITES"]
[]
[null,null,"Default ON"]
[null,null,"System switches off below 80 km/h"]
[null,"PREREQUISITES",null,{"$f":"IF(AND(D13=\"YES\",D14=\"NO\"),\"PASS\",\"FAIL\")","v":"FAIL"}]
[]
[null,"CBFA"]
[null,null,10,null,{"$f":"IF(D18=\"\",0,ROUND(($C18-IF(D18>$C18,$C18,D18))/$C18*1,Round))","v":0}]
[null,null,15,null,0]
[null,null,20,null,0]
[null,null,25,null,0]
[null,null,30,null,0]
[null,null,35,null,0]
[null,null,40,null,0]
[null,null,45,null,{"$f":"IF(D25=\"\",0,IF(D25<=(C25-20),1,0))","v":0}]
[null,null,50,null,{"$f":"IF(D26=\"\",0,IF(D26<=(C26-20),1,0))","v":0}]
[null,null,55,null,{"$f":"IF(D27=\"\",0,IF(D27<=(C27-20),1,0))","v":0}]
[null,null,60,null,{"$f":"IF(D28=\"\",0,IF(D28<=(C28-20),1,0))","v":0}]
[null,"CBFA RESULT",null,{"$f":"IF((COUNTBLANK(D18:D24)+COUNTBLANK(D25:D28))>0,0,SUM(E18:E24,E25:E28))","v":0}]
[]
[null,"CBNA"]
[null,null,10,null,{"$f":"IF(D32=\"\",0,ROUND(($C32-IF(D32>$C32,$C32,D32))/$C32*1,Round))","v":0}]
[null,null,15,null,0]
[null,null,20,null,0]
[null,null,25,null,0]
[null,null,30,null,0]
[null,null,35,null,0]
[null,null,40,null,0]
[null,null,45,null,{"$f":"IF(D39=\"\",0,IF(D39<=(C39-20),1,0))","v":0}]
[null,null,50,null,{"$f":"IF(D40=\"\",0,IF(D40<=(C40-20),1,0))","v":0}]
[null,null,55,null,{"$f":"IF(D41=\"\",0,IF(D41<=(C41-20),1,0))","v":0}]
[null,null,60,null,{"$f":"IF(D42=\"\",0,IF(D42<=(C42-20),1,0))","v":0}]
[null,"CBNA RESULT",null,{"$f":"IF((COUNTBLANK(D32:D38)+COUNTBLANK(D39:D42))>0,0,SUM(E32:E38,E39:E42))","v":0}]
[]
[null,"CBNAO"]
[null,null,10,null,{"$f":"IF(D46=\"\",0,ROUND(($C46-IF(D46>$C46,$C46,D46))/$C46*1,Round))","v":0}]
[null,null,15,null,0]
[null,null,20,null,0]
[null,null,25,null,0]
[null,null,30,null,0]
[null,null,35,null,0]
[null,null,40,null,0]
[null,null,45,null,{"$f":"IF(D53=\"\",0,IF(D53<=(C53-20),1,0))","v":0}]
[null,null,50,null,{"$f":"IF(D54=\"\",0,IF(D54<=(C54-20),1,0))","v":0}]
[null,null,55,null,{"$f":"IF(D55=\"\",0,IF(D55<=(C55-20),1,0))","v":0}]
[null,null,60,null,{"$f":"IF(D56=\"\",0,IF(D56<=(C56-20),1,0))","v":0}]
[null,"CBNAO RESULT",null,{"$f":"IF((COUNTBLANK(D46:D52)+COUNTBLANK(D53:D56))>0,0,SUM(E46:E52,E53:E56))","v":0}]
[]
[null,"CBLA-50"]
[null,1,25,null,{"$f":"IF(D60=\"\",0,ROUND((($C60-15)-(IF(D60<=15,15,IF(D60>$C60,$C60,D60))-15))/($C60-15)*$B60,Round))","v":0}]
[null,1,30,null,{"$f":"IF(D61=\"\",0,ROUND((($C61-15)-(IF(D61<=15,15,IF(D61>$C61,$C61,D61))-15))/($C61-15)*$B61,Round))","v":0}]
[null,2,35,null,{"$f":"IF(D62=\"\",0,ROUND((($C62-15)-(IF(D62<=15,15,IF(D62>$C62,$C62,D62))-15))/($C62-15)*$B62,Round))","v":0}]
[null,2,40,null,{"$f":"IF(D63=\"\",0,ROUND((($C63-15)-(IF(D63<=15,15,IF(D63>$C63,$C63,D63))-15))/($C63-15)*$B63,Round))","v":0}]
[null,3,45,null,{"$f":"IF(D64=\"\",0,IF(D64<=(C64-20),$B64,0))","v":0}]
[null,3,50,null,{"$f":"IF(D65=\"\",0,IF(D65<=(C65-20),$B65,0))","v":0}]
[null,3,55,null,0]
[null,1,60,null,0]
[null,"CBLA-50 RESULT",null,{"$f":"IF((COUNTBLANK(D60:D63)+COUNTBLANK(D64:D67))>0,0,SUM(E60:E63,E64:E67))","v":0}]
[]
[null,"CBLA-25",null,"TTCFCW","Points"]
[null,3,50,null,{"$f":"IF(D71=\"\",0,IF(D71>=1.7,$B71,0))","v":0}]
[null,3,55,null,{"$f":"IF(D72=\"\",0,IF(D72>=1.7,$B72,0))","v":0}]
[null,1,60,null,0]
[null,1,65,null,0]
[null,1,70,null,0]
[null,1,75,null,0]
[null,1,80,null,0]
[null,"CBLA-25 RESULT",null,{"$f":"IF((COUNTBLANK(D71:D75)+COUNTBLANK(D76:D77))>0,0,SUM(E71:E75,E76:E77))","v":0}]
[]
[null,"SUMMARY"]
[null,null,"CBFA",{"$f":"ROUND(D29/11,Round)","v":0}]
[null,null,"CBNA",{"$f":"ROUND(D43/11,Round)","v":0}]
[null,null,"CBNAO",{"$f":"ROUND(D57/11,Round)","v":0}]
[null,null,"CBLA",{"$f":"ROUND((D68+D78)/27,Round)","v":0}]
[]
[null,"TOTAL AEB Cyclist",null,{"$f":"IF(D15=\"FAIL\",0,ROUND(D81*3+D82*1.5+D83*1.5+D84*3,Round))","v":0}]

{"sheet":"SA OSM","index":17,"n_rows":21,"n_cols":9,"rows_kept":21,"cut":false,"hidden":false,"merged":[[1,1,2,2],[1,3,2,4],[3,1,3,2],[4,3,4,4],[1,7,2,8],[4,7,4,8],[1,5,2,6],[4,5,4,6],[3,5,3,6],[6,3,6,4],[7,3,7,4],[19,3,19,8],[3,3,3,4],[8,7,8,8],[7,5,7,6],[6,5,6,6],[5,7,7,7],[5,5,5,6],[5,3,5,4],[10,3,10,4],[15,3,15,8],[16,3,16,8],[17,3,17,8],[19,1,19,2],[8,1,8,2],[15,1,15,2],[13,1,13,2],[10,5,10,8],[13,3,13,8],[11,3,11,4],[11,5,12,8],[12,3,12,4],[8,3,8,6]]}
[]
[null,"Occupant Status Monitoring",null,"Driver",null,"Front Passenger",null,"Rear Passengers"]
[]
[null,{"$f":"'General Overview'!G12","v":""},null,"Score",null,"Score",null,"Nr of seats","Score"]
[null,"SEAT BELT REMINDER"]
[null,null,"Occupant detection",null,null,null,null,{"$f":"SUM('General Overview'!C17:D18)","v":0}]
[null,null,"Visual warning"]
[null,null,"Audible warning"]
[null,"Seat Belt Reminder assessment",null,{"$f":"IF(COUNTIF(D6:G8,\"Pass\")=5,\"PASS\",\"FAIL\")","v":"FAIL"},null,null,null,{"$f":"IF(H6=0,0,IF(OR(I7=\"\",I8=\"\"),0,IF(OR(I7=\"Fail\",I8=\"Fail\"),0,ROUND((MIN(LEFT(I7,1),LEFT(I8,1))*1/H6)+IF(I6=\"Fail\",0,(LEFT(I6,1)*1/H6)),Round))))","v":0}]
[]
[null,"DRIVER MONITORING"]
[null,null,"Default ON",null,null,{"$f":"IF(AND(D12=\"PASS\",D13=\"PASS\"),1,0)","v":0}]
[null,null,"Attention Assist dossier"]
[null,"Driver Monitoring assessment",null,{"$f":"F12","v":0}]
[]
[null,"SUMMARY"]
[null,null,"Seat Belt Reminder assessment",{"$f":"IF(D9=\"FAIL\",0,IF(H6=0,IF(D9=\"PASS\",2,0),SUM(H9)))","v":0}]
[null,null,"Driver Monitoring assessment",{"$f":"D14","v":0}]
[]
[null,"TOTAL OCCUPANT STATUS MONITORING",null,{"$f":"D17+D18","v":0}]
[null,null,null,{"$f":"IF(AND(D9=2,H9>0),\"All seats\",IF(D9=2,\"Front seats\",\"Not available\"))","v":"Not available"}]

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

{"sheet":"SA AEB Car-to-Car","index":19,"n_rows":112,"n_cols":13,"rows_kept":112,"cut":false,"hidden":false,"merged":[[35,8,35,12],[36,8,36,12],[37,8,37,12],[38,8,38,12],[17,8,17,12],[18,8,18,12],[19,8,19,12],[20,8,20,12],[48,1,48,12],[32,8,32,12],[34,1,34,2],[35,1,45,1],[46,1,46,2],[46,3,46,7],[46,8,46,12],[28,3,28,7],[29,3,29,7],[30,3,30,7],[31,3,31,7],[32,1,32,2],[32,3,32,7],[17,1,31,1],[26,3,26,7],[27,3,27,7],[49,1,49,2],[49,3,49,4],[49,5,49,7],[49,8,49,9],[49,10,49,12],[50,3,50,4],[55,3,55,4],[50,5,50,7],[52,3,52,4],[52,5,52,7],[55,5,55,7],[52,8,52,9],[52,10,52,12],[53,3,53,7],[53,8,53,12],[54,3,54,4],[54,5,54,7],[54,8,54,9],[54,10,54,12],[50,8,50,9],[50,10,50,12],[51,3,51,4],[51,5,51,7],[51,8,51,9],[4,8,4,12],[5,3,5,7],[5,8,5,12],[6,3,6,7],[6,8,6,12],[1,8,1,12],[2,1,2,2],[2,3,2,7],[2,8,2,12],[3,3,3,7],[3,8,3,12],[3,1,3,2],[1,1,1,2],[1,3,1,7],[4,3,4,7],[11,8,11,12],[13,3,13,7],[13,8,13,12],[16,1,16,2],[7,8,7,12],[8,3,8,7],[8,8,8,12],[10,3,10,7],[10,8,10,12],[7,3,7,7],[11,3,11,7],[14,1,14,2],[14,3,14,12],[12,3,12,7],[12,8,12,12],[59,1,59,2],[55,8,55,9],[55,10,55,12],[56,1,56,2],[56,3,56,7],[56,8,56,12],[58,1,58,12],[59,3,59,4],[60,3,60,4],[70,3,70,4],[64,3,64,4],[65,3,65,4],[63,3,63,4],[66,3,66,4],[67,3,67,4],[68,3,68,4],[69,3,69,4],[51,10,51,12],[61,3,61,4],[62,3,62,4],[78,3,78,4],[79,3,79,4],[77,3,77,4],[75,3,75,4],[76,3,76,4],[72,3,72,4],[73,3,73,4],[71,3,71,4],[74,3,74,4],[82,8,82,12],[92,3,92,12],[93,3,93,12],[94,3,94,4],[94,5,94,12],[95,3,95,4],[95,5,95,12],[84,1,84,12],[85,1,85,2],[109,3,109,12],[111,1,111,2],[111,3,111,12],[103,3,103,12],[105,1,105,2],[105,3,105,12],[106,3,106,12],[107,3,107,12],[99,3,99,7],[99,8,99,12],[100,3,100,7],[100,8,100,12],[101,3,101,7],[101,8,101,12],[98,1,98,2],[98,3,98,7],[98,8,98,12],[80,1,80,2],[80,3,80,4],[80,8,80,9],[108,3,108,12],[86,8,86,12],[87,8,87,12],[89,8,89,12],[85,8,85,12],[88,8,88,12],[90,1,90,2],[90,3,90,7],[90,8,90,12],[102,3,102,7],[102,8,102,12],[85,3,85,4],[85,5,85,7],[86,3,86,4],[96,1,96,2],[96,3,96,12],[82,1,82,2],[82,3,82,7]]}
[3]
[null,"AEB CAR-TO-CAR",null,"AEB",null,null,null,null,"FCW"]
[null,"TESTNUMBER"]
[null,"SYSTEM DETAILS"]
[null,null,"System name"]
[null,null,"AEB and/or FCW"]
[null,null,"Functionality"]
[null,null,"Speed range (km/h) - Minimum"]
[null,null,"Maximum"]
[]
[null,"PREREQUISITES"]
[null,null,"Default ON after every journey"]
[null,null,"Loud and Clear FCW"]
[null,null,"System switches off below 130 km/h"]
[null,"PREREQUISITES",null,{"$f":"IF(AND(D12=\"PASS\",D13=\"PASS\",D14=\"NO\",I12=\"PASS\",I13=\"PASS\",I14=\"NO\"),\"PASS\",\"FAIL\")","v":"FAIL"}]
[]
[null,"CCRs",null,-0.5,-0.75,1,0.75,0.5,-0.5,-0.75,1,0.75,0.5]
[null,"Test Speed",10]
[null,null,15]
[null,null,20]
[null,null,25]
[null,null,30]
[null,null,35]
[null,null,40]
[null,null,45]
[null,null,50]
[null,null,55]
[null,null,60]
[null,null,65]
[null,null,70]
[null,null,75]
[null,null,80]
[null,"Predicted CCRs score",null,0,null,null,null,null,0]
[]
[null,"CCRm",null,-0.5,-0.75,1,0.75,0.5,-0.5,-0.75,1,0.75,0.5]
[null,"Test Speed",30]
[null,null,35]
[null,null,40]
[null,null,45]
[null,null,50]
[null,null,55]
[null,null,60]
[null,null,65]
[null,null,70]
[null,null,75]
[null,null,80]
[null,"Predicted CCRm score",null,0,null,null,null,null,0]
[]
[null,"CCRb"]
[null,"Testpoints CCRb",null,"Impact Speed",null,"Points",null,null,"Impact Speed",null,"Points"]
[null,null,"12m headway"]
[null,null,"-2m/s² EVT acceleration",null,null,{"$f":"IF(D52=\"Green\",1,IF(D52=\"Yellow\",0.75,IF(D52=\"Orange\",0.5,IF(D52=\"Brown\",0.25,0))))","v":0},null,null,null,null,{"$f":"IF(I52=\"Green\",1,IF(I52=\"Yellow\",0.75,IF(I52=\"Orange\",0.5,IF(I52=\"Brown\",0.25,0))))","v":0}]
[null,null,"-6m/s² EVT acceleration",null,null,{"$f":"IF(D53=\"Green\",1,IF(D53=\"Yellow\",0.75,IF(D53=\"Orange\",0.5,IF(D53=\"Brown\",0.25,0))))","v":0},null,null,null,null,{"$f":"IF(I53=\"Green\",1,IF(I53=\"Yellow\",0.75,IF(I53=\"Orange\",0.5,IF(I53=\"Brown\",0.25,0))))","v":0}]
[null,null,"40m headway"]
[null,null,"-2m/s² EVT acceleration",null,null,{"$f":"IF(D55=\"Green\",1,IF(D55=\"Yellow\",0.75,IF(D55=\"Orange\",0.5,IF(D55=\"Brown\",0.25,0))))","v":0},null,null,null,null,{"$f":"IF(I55=\"Green\",1,IF(I55=\"Yellow\",0.75,IF(I55=\"Orange\",0.5,IF(I55=\"Brown\",0.25,0))))","v":0}]
[null,null,"-6m/s² EVT acceleration",null,null,{"$f":"IF(D56=\"Green\",1,IF(D56=\"Yellow\",0.75,IF(D56=\"Orange\",0.5,IF(D56=\"Brown\",0.25,0))))","v":0},null,null,null,null,{"$f":"IF(I56=\"Green\",1,IF(I56=\"Yellow\",0.75,IF(I56=\"Orange\",0.5,IF(I56=\"Brown\",0.25,0))))","v":0}]
[null,"CCRb RESULT",null,{"$f":"SUM(F52:H53,F55:H56)/4","v":0},null,null,null,null,{"$f":"SUM(K52:M53,K55:M56)/4","v":0}]
[]
[null,"VERIFICATION TESTS"]
[null,null,null,"Testpoint",null,"Prediction","Vimpact","Points","Testpoint","ESS","Prediction","Vimpact","Points"]
[null,null,null,null,null,null,null,{"$f":"IF(G61=\"\",\"\",actual_AEBIU_score(D61,G61,F61))","v":""},null,null,null,null,{"$f":"IF(L61=\"\",\"\",actual_AEBIU_score(I61,L61,K61))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(G62=\"\",\"\",actual_AEBIU_score(D62,G62,F62))","v":""},null,null,null,null,{"$f":"IF(L62=\"\",\"\",actual_AEBIU_score(I62,L62,K62))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(G63=\"\",\"\",actual_AEBIU_score(D63,G63,F63))","v":""},null,null,null,null,{"$f":"IF(L63=\"\",\"\",actual_AEBIU_score(I63,L63,K63))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(G64=\"\",\"\",actual_AEBIU_score(D64,G64,F64))","v":""},null,null,null,null,{"$f":"IF(L64=\"\",\"\",actual_AEBIU_score(I64,L64,K64))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(G65=\"\",\"\",actual_AEBIU_score(D65,G65,F65))","v":""},null,null,null,null,{"$f":"IF(L65=\"\",\"\",actual_AEBIU_score(I65,L65,K65))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(G66=\"\",\"\",actual_AEBIU_score(D66,G66,F66))","v":""},null,null,null,null,{"$f":"IF(L66=\"\",\"\",actual_AEBIU_score(I66,L66,K66))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(G67=\"\",\"\",actual_AEBIU_score(D67,G67,F67))","v":""},null,null,null,null,{"$f":"IF(L67=\"\",\"\",actual_AEBIU_score(I67,L67,K67))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(G68=\"\",\"\",actual_AEBIU_score(D68,G68,F68))","v":""},null,null,null,null,{"$f":"IF(L68=\"\",\"\",actual_AEBIU_score(I68,L68,K68))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(G69=\"\",\"\",actual_AEBIU_score(D69,G69,F69))","v":""},null,null,null,null,{"$f":"IF(L69=\"\",\"\",actual_AEBIU_score(I69,L69,K69))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(G70=\"\",\"\",actual_AEBIU_score(D70,G70,F70))","v":""},null,null,null,null,{"$f":"IF(L70=\"\",\"\",actual_AEBIU_score(I70,L70,K70))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(G71=\"\",\"\",actual_AEBIU_score(D71,G71,F71))","v":""},null,null,null,null,{"$f":"IF(L71=\"\",\"\",actual_AEBIU_score(I71,L71,K71))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(G72=\"\",\"\",actual_AEBIU_score(D72,G72,F72))","v":""},null,null,null,null,{"$f":"IF(L72=\"\",\"\",actual_AEBIU_score(I72,L72,K72))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(G73=\"\",\"\",actual_AEBIU_score(D73,G73,F73))","v":""},null,null,null,null,{"$f":"IF(L73=\"\",\"\",actual_AEBIU_score(I73,L73,K73))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(G74=\"\",\"\",actual_AEBIU_score(D74,G74,F74))","v":""},null,null,null,null,{"$f":"IF(L74=\"\",\"\",actual_AEBIU_score(I74,L74,K74))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(G75=\"\",\"\",actual_AEBIU_score(D75,G75,F75))","v":""},null,null,null,null,{"$f":"IF(L75=\"\",\"\",actual_AEBIU_score(I75,L75,K75))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(G76=\"\",\"\",actual_AEBIU_score(D76,G76,F76))","v":""},null,null,null,null,{"$f":"IF(L76=\"\",\"\",actual_AEBIU_score(I76,L76,K76))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(G77=\"\",\"\",actual_AEBIU_score(D77,G77,F77))","v":""},null,null,null,null,{"$f":"IF(L77=\"\",\"\",actual_AEBIU_score(I77,L77,K77))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(G78=\"\",\"\",actual_AEBIU_score(D78,G78,F78))","v":""},null,null,null,null,{"$f":"IF(L78=\"\",\"\",actual_AEBIU_score(I78,L78,K78))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(G79=\"\",\"\",actual_AEBIU_score(D79,G79,F79))","v":""},null,null,null,null,{"$f":"IF(L79=\"\",\"\",actual_AEBIU_score(I79,L79,K79))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(G80=\"\",\"\",actual_AEBIU_score(D80,G80,F80))","v":""},null,null,null,null,{"$f":"IF(L80=\"\",\"\",actual_AEBIU_score(I80,L80,K80))","v":""}]
[null,"Total",null,null,null,{"$f":"(COUNTIF(F61:F80,\"Green\")*1)+(COUNTIF(F61:F80,\"Yellow\")*0.75)+(COUNTIF(F61:F80,\"Orange\")*0.5)+(COUNTIF(F61:F80,\"Brown\")*0.25)","v":0},null,{"$f":"SUM(H61:H80)","v":0},null,null,{"$f":"(COUNTIF(K61:K80,\"Green\")*1)+(COUNTIF(K61:K80,\"Yellow\")*0.75)+(COUNTIF(K61:K80,\"Orange\")*0.5)+(COUNTIF(K61:K80,\"Brown\")*0.25)","v":0},null,{"$f":"SUM(M61:M80)","v":0}]
[]
[null,"Correction factor",null,{"$f":"IF(F81=0,0,ROUND(H81/F81,Round))","v":0},null,null,null,null,{"$f":"IF(K81=0,0,ROUND(M81/K81,Round))","v":0}]
[]
[null,"CCFtap"]
[null,"Testpoints CCFtap",null,"Test speed",null,"GVT speed"]
[null,null,null,null,null,"30 km/h","45 km/h","55 km/h"]
[null,null,null,null,"10 km/h"]
[null,null,null,null,"15 km/h"]
[null,null,null,null,"20 km/h"]
[null,"CCFtap RESULT",null,{"$f":"COUNTIF(F88:H90,\"Green\")/9","v":0}]
[]
[null,"HMI"]
[null,null,"Additional HMI features"]
[null,null,"Suplementary warning",null,null,{"$f":"IF(D95=\"Yes\",1,0)","v":0}]
[null,null,"Restraint activation / dynamic retractors",null,null,{"$f":"IF(D96=\"Yes\",1,0)","v":0}]
[null,"HMI RESULT",null,{"$f":"SUM(F95:M96)/2","v":0}]
[]
[null,"SUMMARY"]
[null,null,"CCRs (prediction x correction factor)",{"$f":"MIN(D33*D83,1)","v":0},null,null,null,null,{"$f":"MIN(I33*I83,1)","v":0}]
[null,null,"CCRm (prediction x correction factor)",{"$f":"MIN(D47*D83,1)","v":0},null,null,null,null,{"$f":"MIN(I47*I83,1)","v":0}]
[null,null,"CCRb",{"$f":"D57","v":0},null,null,null,null,{"$f":"I57","v":0}]
[null,null,"CCFtap",{"$f":"D91","v":0}]
[null,null,"HMI",{"$f":"D97","v":0}]
[]
[null,"TOTAL"]
[null,null,"AEB",{"$f":"ROUND(AVERAGE(D100:H102)*2,Round)","v":0}]
[null,null,"FCW",{"$f":"ROUND(AVERAGE(I100:M102)*1.5,Round)","v":0}]
[null,null,"CCFtap",{"$f":"ROUND(D103*2,Round)","v":0}]
[null,null,"HMI",{"$f":"D104*0.5","v":0}]
[]
[null,"TOTAL AEB CAR-TO-CAR",null,{"$f":"IF(D15=\"PASS\",SUM(D107:M110),0)","v":0}]

{"sheet":"SA LSS","index":20,"n_rows":72,"n_cols":13,"rows_kept":72,"cut":false,"hidden":false,"merged":[[69,3,69,14],[70,1,70,14],[71,1,71,2],[71,3,71,14],[65,1,65,14],[66,1,66,2],[66,3,66,14],[67,3,67,14],[68,3,68,14],[60,1,60,14],[61,3,61,14],[62,3,62,14],[63,3,63,14],[64,1,64,2],[64,3,64,14],[57,1,57,2],[57,3,57,8],[57,9,57,14],[58,1,58,14],[59,1,59,2],[59,3,59,14],[52,3,52,5],[52,6,52,8],[52,9,52,11],[52,12,52,14],[55,3,55,5],[55,6,55,8],[55,9,55,11],[55,12,55,14],[56,3,56,5],[56,6,56,8],[56,9,56,11],[56,12,56,14],[53,3,53,5],[53,6,53,8],[53,9,53,11],[53,12,53,14],[54,3,54,5],[54,6,54,8],[54,9,54,11],[54,12,54,14],[47,1,47,2],[48,1,48,14],[50,1,50,14],[41,3,41,8],[41,9,41,14],[42,3,42,8],[42,9,42,14],[43,3,43,8],[43,9,43,14],[44,3,44,8],[44,9,44,14],[45,3,45,8],[45,9,45,14],[46,3,46,8],[46,9,46,14],[39,3,39,8],[39,9,39,14],[29,3,29,14],[30,3,30,14],[31,3,31,14],[33,3,33,14],[51,3,51,8],[51,9,51,14],[40,3,40,8],[40,9,40,14],[15,3,15,14],[7,3,7,14],[8,3,8,14],[9,3,9,14],[10,1,10,14],[11,3,11,14],[12,3,12,14],[16,3,16,5],[49,1,49,2],[49,3,49,14],[35,3,35,8],[47,3,47,14],[35,9,35,14],[36,3,36,8],[36,9,36,14],[34,1,34,2],[34,3,34,14],[22,1,22,2],[22,3,22,14],[32,3,32,14],[37,3,37,8],[37,9,37,14],[38,3,38,8],[38,9,38,14],[6,3,6,14],[1,1,2,2],[3,1,3,2],[4,3,4,14],[5,3,5,14],[1,3,3,14],[13,1,13,2],[13,3,13,14],[14,1,14,14],[16,6,16,8],[16,9,16,11],[16,12,16,14],[17,3,17,5],[17,6,17,8],[17,9,17,11],[17,12,17,14],[18,3,18,5],[18,6,18,8],[18,9,18,11],[18,12,18,14],[23,3,23,8],[23,9,23,14],[19,3,19,5],[19,6,19,8],[19,9,19,11],[19,12,19,14],[20,3,20,5],[20,6,20,8],[20,9,20,11],[20,12,20,14],[21,3,21,5],[21,6,21,8],[21,9,21,11],[21,12,21,14],[28,1,28,2],[24,3,24,8],[25,3,25,8],[26,3,26,8],[27,3,27,8],[24,9,24,14],[25,9,25,14],[26,9,26,14],[27,9,27,14],[28,3,28,14]]}
[3]
[null,"Lane Support Systems"]
[]
[null,"TESTNUMBER"]
[null,"SYSTEM DETAILS"]
[null,null,"System Name"]
[null,null,"Default ON (partly)"]
[null,null,"Functionality"]
[null,null,"Speed range (km/h) - Minimum"]
[null,null,"Maximum"]
[]
[null,"PREREQUISITES"]
[null,null,"ESC meeting R13H"]
[null,"PREREQUISITES",null,{"$f":"IF(AND(D13=\"YES\"),\"PASS\",\"FAIL\")","v":"FAIL"}]
[]
[null,"Emergency Lane Keeping"]
[null,null,"Road Edge","No line",null,null,"Center line",null,null,"Center & Dashed line",null,null,"Center & Solid line"]
[null,null,0.2]
[null,null,0.3]
[null,null,0.4]
[null,null,0.5]
[null,null,null,{"$f":"IF(OR(COUNTIF(D18:F21,\">=-0.1\")=4,COUNTIF(D18:F21,\">=-0,1\")=4),0.25,0)","v":0},null,null,{"$f":"IF(OR(COUNTIF(G18:I21,\">=-0.1\")=4,COUNTIF(G18:I21,\">=-0,1\")=4),0.25,0)","v":0},null,null,{"$f":"IF(OR(COUNTIF(J18:L21,\">=-0.1\")=4,COUNTIF(J18:L21,\">=-0,1\")=4),0.25,0)","v":0},null,null,{"$f":"IF(OR(COUNTIF(M18:O21,\">=-0.1\")=4,COUNTIF(M18:O21,\">=-0,1\")=4),0.25,0)","v":0}]
[null,"ELK Road Edge assessment",null,{"$f":"SUM(D22:O22)","v":0}]
[null,null,"Solid Line","Driver side",null,null,null,null,null,"Passenger side"]
[null,null,0.2]
[null,null,0.3]
[null,null,0.4]
[null,null,0.5]
[null,"Solid Line assessment",null,{"$f":"IF(OR(COUNTIF(D25:O28,\">=-0.3\")=8,COUNTIF(D25:O28,\">=-0,3\")=8),0.5,0)","v":0}]
[null,null,"Oncoming vehicle"]
[null,null,0.3]
[null,null,0.4]
[null,null,0.5]
[null,null,0.6]
[null,"ELK Oncoming vehicle assessment",null,{"$f":"IF(COUNTIF(D31:O34,\"PASS\")=4,1,0)","v":0}]
[null,null,"Overtaking vehicle (GVT @ 72km/h)","Unintentional",null,null,null,null,null,"Intentional"]
[null,null,0.3]
[null,null,0.4]
[null,null,0.5]
[null,null,0.6]
[null,null,0.7]
[null,null,"Overtaking vehicle (GVT @ 80km/h)"]
[null,null,0.3]
[null,null,0.4]
[null,null,0.5]
[null,null,0.6]
[null,null,0.7]
[null,"ELK Overtaking vehicle assessment",null,{"$f":"IF(COUNTIF(D37:O47,\"PASS\")=14,0.5,0)","v":0}]
[]
[null,"ELK RESULT",null,{"$f":"SUM(D23,D29,D35,D48)","v":0}]
[]
[null,"Lane Keep Assist",null,"Dashed Line",null,null,null,null,null,"Solid Line"]
[null,null,null,"Driver side",null,null,"Passenger side",null,null,"Driver side",null,null,"Passenger side"]
[null,null,0.2]
[null,null,0.3]
[null,null,0.4]
[null,null,0.5]
[null,"LKA assessment",null,{"$f":"IF(OR(COUNTIF(D54:I57,\">=-0.3\")=8,COUNTIF(D54:I57,\">=-0,3\")=8),0.25,0)","v":0},null,null,null,null,null,{"$f":"IF(OR(COUNTIF(J54:O57,\">=-0.3\")=8,COUNTIF(J54:O57,\">=-0,3\")=8),0.25,0)","v":0}]
[]
[null,"LKA RESULT",null,{"$f":"SUM(D58,J58)","v":0}]
[]
[null,"HMI"]
[null,1,"Lane Departure Warning"]
[null,2,"Blind Spot Monitoring"]
[null,"HMI RESULT",null,{"$f":"IF(OR(D63=\"PASS\",D64=\"PASS\"),0.5,0)","v":0}]
[]
[null,"SUMMARY"]
[null,null,"ELK",{"$f":"D50","v":0}]
[null,null,"LKA",{"$f":"D60","v":0}]
[null,null,"HMI",{"$f":"D65","v":0}]
[]
[null,"TOTAL Lane Support Systems",null,{"$f":"IF(D14=\"FAIL\",0,ROUND(SUM(D68:O70),Round))","v":0}]