{"text_format":"1","workbook":"xlsx","n_sheets":20,"sheets":["General Overview","Vehicle Settings","OVERALL RATING","AOP Frontal ODB","AOP Frontal FW","AOP Side MDB","AOP Side Pole","AOP Whiplash","AEB City","COP Dynamic","COP Vehicle Based","COP CRS Installation","PP Headform","PP Upper Legform","PP Lower Legform","PP AEB Pedestrian","SA SBR","SA SAS","SA AEB Inter-Urban","SA LDW LKA"],"not_rendered":{"charts":0,"images":237,"macros":1,"external_links":2,"defined_names":56,"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":151,"n_cols":24,"rows_kept":151,"cut":false,"hidden":false,"merged":[[1,1,2,4],[46,1,46,6],[27,2,27,3],[29,2,29,3],[30,2,30,3],[31,2,31,3],[34,2,34,3],[33,2,33,3],[8,2,8,4],[10,2,10,4],[24,2,24,3],[25,2,25,3],[26,2,26,3],[13,2,13,4],[14,2,14,4],[18,2,18,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],[66,1,66,2],[66,3,66,4],[64,1,64,4],[65,1,65,4],[61,1,62,2],[61,3,61,6],[62,3,62,4],[63,1,63,2],[63,3,63,4],[67,1,67,2],[67,3,67,4],[68,1,68,2],[68,3,68,4],[69,3,69,4],[70,1,70,2],[70,3,70,4],[71,1,71,2],[71,3,71,4],[72,1,72,2],[72,3,72,4],[79,1,79,2],[79,3,79,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,1,75,2],[75,3,75,4],[15,2,15,3],[91,1,91,2],[91,3,91,4],[87,1,87,2],[87,3,87,4],[88,1,88,2],[88,3,88,4],[89,1,89,2],[89,3,89,4],[83,1,83,2],[83,3,83,4],[85,1,85,2],[85,3,85,4],[86,1,86,2],[86,3,86,4],[80,1,80,2],[90,1,90,2],[90,3,90,4],[51,2,51,3],[16,2,16,3],[17,2,17,3],[80,3,80,4],[81,1,81,2],[81,3,81,4],[82,1,82,2],[82,3,82,4],[84,1,84,2],[84,3,84,4],[76,1,76,2],[76,3,76,4],[77,1,77,2],[77,3,77,4]]}
[]
[3,"VEHICLE SPECIFICATION",null,null,null,"YEAR OF TEST",2016,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3 door hatchback"]
[null,null,null,null,null,"BASE/OPTIONAL","OPTIONAL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"5 door hatchback"]
[null,"Make",null,null,null,"Frontal ODB test",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3 door wgon"]
[null,"Model",null,null,null,"Frontal FW test",null,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"]
[null,"Kerb weight (kg)",null,null,null,"Side Pole test",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"5 door SUV"]
[null,"Engine",null,null,null,"Whiplash tests",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3 door SUV"]
[null,"Trim level",null,null,null,"AEB City tests",null,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,"Pedestrian tests"]
[null,"Body Type",null,null,null,"AEB Pedestrian tests"]
[null,"Full description",null,null,null,"SBR test"]
[null,"Release Date",null,null,null,"SAS tests"]
[null,"Hand of drive",null,null,null,"AEB Inter-Urban tests"]
[null,"Seat arrangement"]
[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,"AEB"]
[null,null,"AEB City"]
[]
[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",{"$f":"IF(OR(AND(F42=\"PASS\",F43=\"PASS\"),D44=\"Yes\"),1.5/IF('General Overview'!C18<>\"not available\",4,2),0)","v":0}]
[]
[null,"PEDESTRIAN"]
[null,"ACTIVE PEDESTRIAN SYSTEM"]
[null,null,"deployable bonnet",null,null,{"$f":"IF(OR(E49:E50=\"Standard\"),\"Standard\",IF(OR(E49:E50=\"Optional meeting fitment\"),\"Optional meeting fitment\",IF(OR(E49:E50=\"Optional not meeting fitment\"),\"Optional not meeting fitment\",\"Not available\")))","v":"Not available"}]
[null,null,"pedestrian airbag"]
[null,"AEB"]
[null,null,"AEB Pedestrian"]
[]
[null,"SAFETY ASSIST",null,null,"DRIVER","PASSENGER","REAR","ROW 3"]
[null,"SAFETY ASSIST SYSTEMS"]
[null,null,"SBR"]
[null,null,"ESC"]
[null,null,"AEB Inter-Urban"]
[null,null,"Speed Assist System"]
[null,null,"Lane Assist System"]
[]
[null,"PROTOCOLS"]
[null,null,null,"Protocol",null,"Version","Application"]
[null,"GENERAL"]
[null,"VEHICLE SPECIFICATION, SPONSORSHIP, TESTING AND RETESTING PROTOCOL",null,null,null,"7.0",2015]
[null,"EURO NCAP ASSESSMENT PROTOCOL - OVERALL RATING",null,null,null,"6.0",2013]
[null,"ADULT OCCUPANT PROTECTION"]
[null,null,null,"EURO NCAP ASSESSMENT PROTOCOL - AOP",null,"7.0.3",2016]
[null,null,null,"FRONTAL ODB TEST PROTOCOL",null,"7.1.1",2016]
[null,null,null,"FRONTAL FULL WIDTH TEST PROTOCOL",null,"1.0.2",2016]
[null,null,null,"SIDE BARRIER IMPACT TEST PROTOCOL",null,"7.1.1",2016]
[null,null,null,"SIDE POLE IMPACT TEST PROTOCOL",null,"7.0.2",2016]
[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,"1.1",2015]
[]
[null,"CHILD OCCUPANT PROTECTION"]
[null,null,null,"EURO NCAP ASSESSMENT PROTOCOL - COP",null,"7.0.1",2016]
[null,null,null,"COP TEST PROTOCOL",null,"7.0",2016]
[]
[null,"PEDESTRIAN PROTECTION"]
[null,null,null,"EURO NCAP ASSESSMENT PROTOCOL - PP",null,"8.1",2016]
[null,null,null,"PEDESTRIAN TEST PROTOCOL",null,"8.2",2016]
[null,null,null,"AEB VRU TEST PROTOCOL",null,"1.0.1",2016]
[]
[null,"SAFETY ASSIST"]
[null,null,null,"EURO NCAP ASSESSMENT PROTOCOL - SA",null,"7.0",2016]
[null,null,null,"SAS TEST PROTOCOL",null,"1.1",2016]
[null,null,null,"AEB TEST PROTOCOL",null,"1.1",2016]
[null,null,null,"LSS TEST PROTOCOL",null,"1.0",2016]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[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,"Citroen","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/Vauxhall"]
[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,"Toyota"]
[null,null,null,null,"Volvo"]
[null,null,null,null,"VW"]
[null,null,null,null,"Suzuki"]
[null,null,null,null,"Toyota"]
[null,null,null,null,"Volvo"]
[null,null,null,null,"VW"]

{"sheet":"Vehicle Settings","index":1,"n_rows":53,"n_cols":4,"rows_kept":53,"cut":false,"hidden":false,"merged":[[1,3,2,3],[1,1,3,2]]}
[]
[null,"Vehicle settings"]
[]
[null,null,null,"Value"]
[null,"VEHICLE PREPARATION"]
[null,null,"fuel tank capacity - l"]
[null,null,"tyre pressure - bar"]
[null,null,"normal ride attitude (wheel arch height) - mm"]
[]
[null,"SEAT SETTING"]
[]
[null,"FRONT SEATS"]
[null,null,"5th percentile"]
[null,null,"Fore/aft"]
[null,null,"Seat base tilt"]
[null,null,"Seat height"]
[null,null,"Seat back angle"]
[null,null,"Head restraint height"]
[null,null,"Head restraint tilt"]
[null,null,"Seat lumbar support"]
[null,null,"Arm rests"]
[null,null,"Seat belt anchorage"]
[null,null,"50th percentile"]
[null,null,"Fore/aft"]
[null,null,"Seat base tilt"]
[null,null,"Seat height"]
[null,null,"Seat back angle"]
[null,null,"Head restraint height"]
[null,null,"Head restraint tilt"]
[null,null,"Seat lumbar support"]
[null,null,"Arm rests"]
[null,null,"Seat belt anchorage"]
[null,null,"95th percentile"]
[null,null,"Fore/aft"]
[]
[null,"REAR SEATS"]
[null,null,"Fore/aft"]
[null,null,"Seat base tilt"]
[null,null,"Seat height"]
[null,null,"Seat back angle"]
[null,null,"Head restraint height"]
[null,null,"Head restraint tilt"]
[null,null,"Seat lumbar support"]
[null,null,"Arm rests"]
[null,null,"Seat belt anchorage"]
[]
[null,"STEERING WHEEL SETTING"]
[null,null,"5th percentile"]
[null,null,"Horizontal"]
[null,null,"Vertical"]
[null,null,"50th percentile"]
[null,null,"Horizontal"]
[null,null,"Vertical"]

{"sheet":"OVERALL RATING","index":2,"n_rows":45,"n_cols":12,"rows_kept":45,"cut":false,"hidden":false,"merged":[[43,1,43,10],[44,1,44,10],[45,1,45,10],[46,1,46,10],[41,1,41,5],[41,6,41,10],[47,1,47,10],[48,1,48,10],[22,8,22,9],[18,4,18,5],[21,8,21,9],[22,4,22,5],[22,6,22,7],[22,2,22,3],[21,4,21,5],[21,2,21,3],[18,8,18,9],[24,1,24,10],[20,8,20,9],[21,6,21,7],[20,6,20,7],[20,2,20,3],[14,2,14,3],[15,2,15,3],[15,4,15,5],[15,6,15,7],[4,2,4,3],[4,4,4,5],[12,6,12,7],[13,6,13,7],[13,4,13,5],[4,6,4,7],[5,2,5,3],[13,2,13,3],[12,2,12,3],[18,2,18,3],[19,2,19,3],[18,6,18,7],[19,6,19,7],[19,4,19,5],[20,4,20,5],[5,4,5,5],[5,6,5,7],[5,8,5,9],[19,8,19,9],[15,8,15,9],[12,4,12,5],[14,6,14,7],[14,8,14,9],[12,8,12,9],[13,8,13,9],[14,4,14,5],[34,1,40,5],[34,6,40,10],[31,1,31,2],[25,1,30,2],[31,3,31,4],[25,3,30,4],[31,5,31,6],[25,5,30,6],[33,1,33,10],[1,6,2,6],[1,7,2,9],[25,7,30,8],[31,7,31,8],[25,9,30,10],[31,9,31,10],[14,10,15,10],[4,8,4,9]]}
[]
[null,null,{"$f":"CONCATENATE('General Overview'!C4:E4,\" \",'General Overview'!C5)","v":" "},null,null,null,2016]
[null,null,{"$f":"CONCATENATE('General Overview'!C8,\" \",'General Overview'!C9,\", \",'General Overview'!C14)","v":" , "}]
[]
[null,null,"ADULT OCCUPANT\n",null,"CHILD OCCUPANT\n",null,"PEDESTRIAN\n",null,"SAFETY ASSIST\n"]
[null,null,{"$f":"ROUND(C13,1)","v":0},null,{"$f":"ROUND(E13,1)","v":0},null,{"$f":"ROUND(G13,1)","v":0},null,{"$f":"ROUND(I13,1)","v":0}]
[null,null,"Frontal ODB",{"$f":"'AOP Frontal ODB'!D99","v":0},"Dynamic",{"$f":"IF(OR('General Overview'!C17=\"\",'General Overview'!C18=\"\",'General Overview'!C17>0,'General Overview'!C18>0),'COP Dynamic'!D49,\"\")","v":0},"Headforms",{"$f":"'PP Headform'!T68","v":0},"SBR",{"$f":"'SA SBR'!D10","v":0}]
[null,null,"Frontal FW",{"$f":"'AOP Frontal FW'!D64","v":0},"Vehicle Based",{"$f":"'COP Vehicle Based'!D37","v":0},"Upper Legform",{"$f":"'PP Upper Legform'!G35","v":0},"SAS",{"$f":"'SA SAS'!D48","v":0}]
[null,null,"Side MDB",{"$f":"'AOP Side MDB'!D54","v":0},"CRS Installation",{"$f":"'COP CRS Installation'!H28","v":0},"Lower Legform",{"$f":"'PP Lower Legform'!E35","v":0},"AEB Inter-Urban",{"$f":"'SA AEB Inter-Urban'!D70","v":0}]
[null,null,"Side Pole",{"$f":"'AOP Side Pole'!D73","v":0},null,null,"AEB Pedestrian",{"$f":"IF(SUM(H7,H8,H9)>=22,'PP AEB Pedestrian'!D52,0)","v":0},"LDW / LKA",{"$f":"'SA LDW LKA'!D39","v":0}]
[null,null,"Whiplash",{"$f":"'AOP Whiplash'!D71","v":0}]
[null,null,"AEB City",{"$f":"IF(D11>=1.5,'AEB City'!D33:E33,0)","v":0}]
[null,"Total Score",{"$f":"SUM(D7:D12)","v":0},null,{"$f":"SUM(F7:F12)","v":0},null,{"$f":"SUM(H7:H12)","v":0},null,{"$f":"SUM(J7:J11)","v":0}]
[null,"Max Points available",38,null,{"$f":"IF(OR('General Overview'!C17=\"\",'General Overview'!C18=\"\",'General Overview'!C17>0,'General Overview'!C18>0),49,21)","v":49},null,36,null,13,null,"TOTAL"]
[null,"Normalised Score",{"$f":"INT(C13/C14*100)","v":0},null,{"$f":"INT(E13/E14*100)","v":0},null,{"$f":"INT(G13/G14*100)","v":0},null,{"$f":"INT(I13/I14*100)","v":0},null,{"$f":"INT(ROUND((C13/C14)*100,2)*C16+ROUND((E13/E14)*100,2)*E16+ROUND((G13/G14)*100,2)*G16+ROUND((I13/I14)*100,2)*I16)","v":0}]
[null,"Weight",0.4,null,0.2,null,0.2,null,0.2]
[null,null,null,{"$f":"C15/100","v":0},null,{"$f":"E15/100","v":0},null,{"$f":"G15/100","v":0},null,{"$f":"I15/100","v":0}]
[null,"RATING REQUIREMENTS 2016"]
[null,null,80,null,75,null,60,null,50,null,null,{"$f":"IF($C$15:$J$15>=C19:J19,1,0)","v":0}]
[null,null,70,null,60,null,50,null,40,null,null,{"$f":"IF($C$15:$J$15>=C20:J20,1,0)","v":0}]
[null,null,60,null,30,null,40,null,25,null,null,{"$f":"IF($C$15:$J$15>=C21:J21,1,0)","v":0}]
[null,null,50,null,25,null,30,null,15,null,null,{"$f":"IF($C$15:$J$15>=C22:J22,1,0)","v":0}]
[null,null,40,null,15,null,20,null,10,null,null,{"$f":"IF($C$15:$J$15>=C23:J23,1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L19:L23)","v":0}]
[null,"ADULT OCCUPANT"]
[]
[]
[]
[]
[]
[]
[null,"FRONTAL ODB 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 ODB","index":3,"n_rows":218,"n_cols":7,"rows_kept":218,"cut":false,"hidden":false,"merged":[[1,3,2,4],[1,5,2,6],[28,3,28,4],[28,5,28,6],[91,5,91,6],[56,5,56,6],[38,3,38,4],[39,3,39,4],[39,5,39,6],[38,5,38,6],[56,3,56,4],[90,3,90,4],[91,3,91,4],[92,3,92,4],[86,3,86,4],[209,1,209,4],[104,1,104,6],[201,1,201,6],[98,3,98,6],[96,3,96,4],[89,5,89,6],[90,5,90,6],[86,5,86,6],[88,1,88,2],[94,3,94,6],[98,1,98,2],[96,5,96,6],[92,5,92,6],[89,3,89,4],[1,1,2,2],[3,1,3,2],[28,1,28,2],[75,1,75,2],[38,1,38,2],[18,1,18,2],[26,1,26,2],[96,1,96,2],[94,1,94,2],[47,1,47,2],[66,1,66,2],[84,1,84,2],[86,1,86,2],[54,1,54,2],[56,1,56,2]]}
[]
[null,"Frontal ODB Test",null,"Driver",null,"Passenger"]
[]
[null,{"$f":"'General Overview'!G4","v":0},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\",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,null,"HIC15",null,{"$f":"IF(D6=\"Yes\",IF(D7<80,\"\",ROUND(Sliding_Scale(D8,500,700,4,0),Round)),IF(D6=\"No\",IF(E11=\"PASS\",IF(D8>=700,0,2),0),\"\"))","v":""},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\",ROUND(Sliding_Scale(D9,65,80,2,0),Round),\"\"))","v":""},null,{"$f":"IF(F6=\"Yes\",IF(F7<80,\"\",ROUND(Sliding_Scale(F9,72,80,4,0),Round)),\"\")","v":""}]
[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,null,"Hazardous airbag deployment modifier (-1)",null,{"$f":"D13","v":0},null,{"$f":"F13","v":0}]
[null,null,"Incorrect airbag deployment modifier (-1)",null,{"$f":"D14","v":0},null,{"$f":"F14","v":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),72,88,-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\",MIN(E11:E11)+SUM(E12:E15),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,IF(D23<25,1.9-0.7*(D23/25),(IF(D23<35,1.2,IF(D23<45,1.2-0.1*(D23-35)/10,1.1)))),IF(D23<25,3.1-1.6*(D23/25),(IF(D23<35,1.5,IF(D23<45,1.5-0.4*(D23-35)/10,1.10000000000001)))),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,IF(D25<35,2.7-0.4*(D25/35),(IF(D25<60,2.3-1.2*(D25-35)/25,1.1))),IF(D25<35,3.3-0.4*(D25/35),(IF(D25<60,2.9-1.8*(D25-35)/25,1.10000000000001))),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 - mm",null,{"$f":"ROUND(Sliding_Scale(D32,22,42,4,0),Round)","v":0},null,{"$f":"ROUND(Sliding_Scale(F32,22,42,4,0),Round)","v":0}]
[null,null,"Viscous criterion - m/s",null,{"$f":"ROUND(Sliding_Scale(D33,0.5,1,4,0),Round)","v":0},null,{"$f":"ROUND(Sliding_Scale(F33,0.5,1,4,0),Round)","v":0}]
[null,null,"Shoulder belt load - kN",null,{"$f":"IF(D34>6,-2,0)","v":0},null,{"$f":"IF(F34>6,-2,0)","v":0}]
[null,null,"Incorrect airbag deployment modifier (-1)",null,{"$f":"D35","v":0},null,{"$f":"F35","v":0}]
[null,null,"Steering wheel contact (-1) ",null,{"$f":"D36","v":0}]
[null,null,"A-Pillar displacement (-2) mm",null,{"$f":"ROUND(Modifier_Sliding_Scale(D37,100,200,-2,0),Round)","v":0}]
[null,null,"Unstable passenger compartment (-1)",null,{"$f":"D38","v":0}]
[null,"Chest assessment",null,{"$f":"MAX(MIN(E32:E33)+SUM(E35:E38),0)","v":0},null,{"$f":"MAX(MIN(G32:G33)+SUM(G35:G38),0)","v":0}]
[]
[null,"KNEE, FEMUR and PELVIS"]
[null,null,"Left Knee Slide - mm",null,{"$f":"ROUND(Sliding_Scale(D42,6,15,4,0),Round)","v":0},null,{"$f":"ROUND(Sliding_Scale(F42,6,15,4,0),Round)","v":0}]
[null,null,"Left Femur Compression level exceeded - kN",null,{"$f":"ROUND(Sliding_Scale(D43,3.8,IF(D44<11,9.07-1.51*D44/10,7.56),4,0),Round)","v":0},null,{"$f":"ROUND(Sliding_Scale(F43,3.8,IF(F44<11,9.07-1.51*F44/10,7.56),4,0),Round)","v":0}]
[null,null,"duration of exceedence - ms"]
[null,null,"Variable contact (-1) ",null,{"$f":"D45","v":0},null,{"$f":"F45","v":0}]
[null,null,"Concentrated loading (-1) ",null,{"$f":"D46","v":0},null,{"$f":"F46","v":0}]
[null,null,"Incorrect airbag deployment modifier (-1)",null,{"$f":"D47","v":0},null,{"$f":"F47","v":0}]
[null,"Left Knee, Femur and Pelvis assessment",null,null,{"$f":"MAX(MIN(E42:E43)+SUM(E45:E47),0)","v":0},null,{"$f":"MAX(MIN(G42:G43)+SUM(G45:G47),0)","v":0}]
[null,null,"Right Knee Slide - mm",null,{"$f":"ROUND(Sliding_Scale(D49,6,15,4,0),Round)","v":0},null,{"$f":"ROUND(Sliding_Scale(F49,6,15,4,0),Round)","v":0}]
[null,null,"Right Femur Compression level exceeded - kN",null,{"$f":"ROUND(Sliding_Scale(D50,3.8,IF(D51<11,9.07-1.51*D51/10,7.56),4,0),Round)","v":0},null,{"$f":"ROUND(Sliding_Scale(F50,3.8,IF(F51<11,9.07-1.51*F51/10,7.56),4,0),Round)","v":0}]
[null,null,"duration of exceedence - ms"]
[null,null,"Variable contact (-1) ",null,{"$f":"D52","v":0},null,{"$f":"F52","v":0}]
[null,null,"Concentrated loading (-1) ",null,{"$f":"D53","v":0},null,{"$f":"F53","v":0}]
[null,null,"Incorrect airbag deployment modifier (-1)",null,{"$f":"D54","v":0},null,{"$f":"F54","v":0}]
[null,"Right Knee, Femur and Pelvis assessment",null,null,{"$f":"MAX(MIN(E49:E50)+SUM(E52:E54),0)","v":0},null,{"$f":"MAX(MIN(G49:G50)+SUM(G52:G54),0)","v":0}]
[]
[null,"Knee, Femur and Pelvis assessment",null,{"$f":"MIN(E48,E55)","v":0},null,{"$f":"MIN(G48,G55)","v":0}]
[]
[null,"LOWER LEG"]
[null,null,"Left compression - kN",null,{"$f":"ROUND(Sliding_Scale(D60,2,8,4,0),Round)","v":0},null,{"$f":"ROUND(Sliding_Scale(F60,2,8,4,0),Round)","v":0}]
[null,null,"Left Upper Tibia Index ",null,{"$f":"ROUND(Sliding_Scale(D61,0.4,1.3,4,0),Round)","v":0},null,{"$f":"ROUND(Sliding_Scale(F61,0.4,1.3,4,0),Round)","v":0}]
[null,null,"Left Lower Tibia Index",null,{"$f":"ROUND(Sliding_Scale(D62,0.4,1.3,4,0),Round)","v":0},null,{"$f":"ROUND(Sliding_Scale(F62,0.4,1.3,4,0),Round)","v":0}]
[null,null,"Maximum pedal vertical displacement - mm",{"$f":"MAX(D64:D66)","v":0},{"$f":"ROUND(Modifier_Sliding_Scale(D63,72,88,-1,0),Round)","v":0}]
[null,null,"Brake Vertical displacement - mm",null,{"$f":"IF(D64=\"N/A\",\"\",IF(D64>0,\"upward\",IF(D64<0,\"downward\",\"\")))","v":""},"Brake"]
[null,null,"Clutch Vertical displacement - mm",null,{"$f":"IF(D65=\"N/A\",\"\",IF(D65>0,\"upward\",IF(D65<0,\"downward\",\"\")))","v":""},"Clutch"]
[null,null,"Accel Vertical displacement - mm",null,{"$f":"IF(D66=\"N/A\",\"\",IF(D66>0,\"upward\",IF(D66<0,\"downward\",\"\")))","v":""},"Accelerator"]
[null,"Left Lower Leg assessment",null,null,{"$f":"MAX(MIN(E60:E62)+E63,0)","v":0},null,{"$f":"MIN(G60:G62)","v":0}]
[]
[null,null,"Right compression - kN",null,{"$f":"ROUND(Sliding_Scale(D69,2,8,4,0),Round)","v":0},null,{"$f":"ROUND(Sliding_Scale(F69,2,8,4,0),Round)","v":0}]
[null,null,"Right Upper Tibia Index ",null,{"$f":"ROUND(Sliding_Scale(D70,0.4,1.3,4,0),Round)","v":0},null,{"$f":"ROUND(Sliding_Scale(F70,0.4,1.3,4,0),Round)","v":0}]
[null,null,"Right Lower Tibia Index",null,{"$f":"ROUND(Sliding_Scale(D71,0.4,1.3,4,0),Round)","v":0},null,{"$f":"ROUND(Sliding_Scale(F71,0.4,1.3,4,0),Round)","v":0}]
[null,null,"Maximum pedal vertical displacement - mm",{"$f":"MAX(D73:D75)","v":0},{"$f":"ROUND(Modifier_Sliding_Scale(D72,72,88,-1,0),Round)","v":0}]
[null,null,"Brake Vertical displacement - mm",{"$f":"IF(D64=\"\",\"\",D64)","v":""},{"$f":"IF(D73=\"N/A\",\"\",IF(D73>0,\"upward\",IF(D73<0,\"downward\",\"\")))","v":"upward"}]
[null,null,"Clutch Vertical displacement - mm",{"$f":"IF(D65=\"\",\"\",D65)","v":""},{"$f":"IF(D74=\"N/A\",\"\",IF(D74>0,\"upward\",IF(D74<0,\"downward\",\"\")))","v":"upward"}]
[null,null,"Accel Vertical displacement - mm",{"$f":"IF(D66=\"\",\"\",D66)","v":""},{"$f":"IF(D75=\"N/A\",\"\",IF(D75>0,\"upward\",IF(D75<0,\"downward\",\"\")))","v":"upward"}]
[null,"Right Lower Leg assessment",null,null,{"$f":"MAX(MIN(E69:E71)+E72,0)","v":0},null,{"$f":"MIN(G69:G71)","v":0}]
[]
[null,"FOOT and ANKLE"]
[null,null,"Maximum pedal horizontal displacement - mm",{"$f":"MAX(D80:D82)","v":0},{"$f":"IF(COUNTIF(D80:D82,\"\")=3,0,ROUND(Sliding_Scale(D79,100,200,4,0),Round))","v":0}]
[null,null,"Brake Horizontal displacement - mm",null,{"$f":"IF(D80=\"N/A\",\"\",IF(D80>0,\"rearward\",IF(D80<0,\"forward\",\"\")))","v":""},"Brake"]
[null,null,"Clutch Horizontal displacement - mm",null,{"$f":"IF(D81=\"N/A\",\"\",IF(D81>0,\"rearward\",IF(D81<0,\"forward\",\"\")))","v":""},"Clutch"]
[null,null,"Accel Horizontal displacement - mm",null,{"$f":"IF(D82=\"N/A\",\"\",IF(D82>0,\"rearward\",IF(D82<0,\"forward\",\"\")))","v":""},"Accelerator"]
[null,null,"Footwell Rupture (-1)",null,{"$f":"D83","v":0}]
[null,null,"Pedal Blocking (-1)",null,{"$f":"ROUND(Sliding_Scale(D84,50,175,0,-1),Round)","v":0}]
[null,"Foot and Ankle assessment",null,null,{"$f":"MAX(E79+E83+E84,0)","v":0}]
[]
[null,"Lower Leg, Foot and Ankle assessment",null,{"$f":"MIN(E67,E76,E85)","v":0},null,{"$f":"MIN(G67,G76)","v":0}]
[]
[null,"SUMMARY"]
[null,null,"Head and Neck assessment",{"$f":"D29","v":0},null,{"$f":"F29","v":0}]
[null,null,"Chest assessment",{"$f":"D39","v":0},null,{"$f":"F39","v":0}]
[null,null,"Knee, Femur and Pelvis assessment",{"$f":"D57","v":0},null,{"$f":"F57","v":0}]
[null,null,"Lower Leg, Foot and Ankle Assessment",{"$f":"D87","v":0},null,{"$f":"F87","v":0}]
[]
[null,"Door Opening",null,0]
[]
[null,"TOTAL",null,{"$f":"SUM(D90:E93)","v":0},null,{"$f":"SUM(F90:G93)","v":0}]
[]
[null,"TOTAL FRONTAL ODB",null,{"$f":"MAX(IF(OR(E7=0,E8=0,E9=0,G7=0,G8=0,G9=0,E22=0,E24=0,E26=0,G22=0,G24=0,G26=0,E32=0,E33=0,G32=0,G33=0),0,(MIN(D90,F90)+MIN(D91,F91)+MIN(D92,F92)+MIN(D93,F93)+D95)/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,"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,"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,"B-post"]
[null,"Ax","Max"]
[null,null,"Min"]
[null,"Seatbelt"]
[null,"Fseatbelt","Max"]
[null,null,"Min"]
[]
[null,"TEST DETAILS"]
[null,"Vehicle"]
[null,null,"VIN numer"]
[null,null,"Test weight - kN"]
[null,"Test"]
[null,null,"Impact speed - km/h"]
[null,null,"Impact location - mm"]
[null,null,"Vertical"]
[null,null,"Horizontal"]

{"sheet":"AOP Frontal FW","index":4,"n_rows":208,"n_cols":9,"rows_kept":208,"cut":false,"hidden":false,"merged":[[21,5,21,6],[22,5,22,6],[184,1,184,4],[55,5,55,6],[56,5,56,6],[57,5,57,6],[61,5,61,6],[57,3,57,4],[53,1,53,2],[42,1,42,2],[37,1,37,2],[34,1,34,2],[40,1,40,2],[57,7,57,8],[21,1,21,2],[21,3,21,4],[21,7,21,8],[199,1,199,4],[69,1,69,8],[176,1,176,8],[56,3,56,4],[56,7,56,8],[63,1,63,2],[63,3,63,8],[59,1,59,2],[59,3,59,8],[61,1,61,2],[61,3,61,4],[61,7,61,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],[22,7,22,8],[22,3,22,4],[30,3,30,4],[55,3,55,4],[55,7,55,8],[54,3,54,4],[54,7,54,8],[54,5,54,6],[29,7,29,8],[29,3,29,4],[29,5,29,6],[30,7,30,8],[30,5,30,6],[42,5,42,6],[42,3,42,4],[42,7,42,8]]}
[]
[null,"Frontal FW Test",null,"Driver",null,"Front Passenger",null,"Rear Passenger"]
[]
[null,{"$f":"'General Overview'!G5","v":0},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.02,4,0),Round)","v":0}]
[null,"Left Knee, Femur and Pelvis assessment",null,null,{"$f":"MAX(MIN(E33:E34),0)","v":0},null,{"$f":"MAX(MIN(G33:G34),0)","v":0},null,{"$f":"MAX(MIN(I33:I34),0)","v":0}]
[null,null,"Right Knee Slide - mm"]
[null,null,"Right Femur Compression level exceeded - kN",null,{"$f":"ROUND(Sliding_Scale(D37,2.6,6.2,4,0),Round)","v":0},null,{"$f":"ROUND(Sliding_Scale(F37,2.6,6.2,4,0),Round)","v":0},null,{"$f":"ROUND(Sliding_Scale(H37,2.6,6.02,4,0),Round)","v":0}]
[null,"Right Knee, Femur and Pelvis assessment",null,null,{"$f":"MAX(MIN(E36:E37),0)","v":0},null,{"$f":"MAX(MIN(G36:G37),0)","v":0},null,{"$f":"MAX(MIN(I36:I37),0)","v":0}]
[]
[null,null,"Iliac load drop 1ms - kN",null,{"$f":"IF(D40>=1,-4,0)","v":0},null,{"$f":"IF(F40>=1,-4,0)","v":0},null,{"$f":"IF(H40>=1,-4,0)","v":0}]
[null,"Pelvis assessment",null,{"$f":"IF(E41=0,\"Green\",IF(E41=-4,\"Red\"))","v":"Green"},{"$f":"E40","v":0},{"$f":"IF(G41=0,\"Green\",IF(G41=-4,\"Red\"))","v":"Green"},{"$f":"G40","v":0},{"$f":"IF(I41=0,\"Green\",IF(I41=-4,\"Red\"))","v":"Green"},{"$f":"I40","v":0}]
[]
[null,"Knee, Femur and Pelvis assessment",null,{"$f":"MAX(MIN(E35,E38)+E41,0)","v":0},null,{"$f":"MAX(MIN(G35,G38)+G41,0)","v":0},null,{"$f":"MAX(MIN(I35,I38)+I41,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":"D43","v":0},null,{"$f":"F43","v":0},null,{"$f":"H43","v":0}]
[]
[null,"Door Opening",null,0]
[]
[null,"TOTAL",null,{"$f":"IF(OR(D7>=120,D8>=700,D9>=80,D19>=2.7,D20>=2.9,D21>=57,D25>=42,D26>=1),0,ROUND(SUM(D55:E58)/2,Round))","v":0},null,{"$f":"IF(OR(F7>=120,F8>=700,F9>=80,F19>=2.7,F20>=2.9,F21>=57,F25>=42,F26>=1),0,ROUND(SUM(F55:G58)/2,Round))","v":0},null,{"$f":"IF(OR(H7>=120,H8>=700,H9>=80,H25>=42,H26>=1),0,ROUND(SUM(H55:I58)/2,Round))","v":0}]
[]
[null,"TOTAL FRONTAL FW",null,{"$f":"ROUND(MAX(IF(F62<0.9*D62,(0.5*(MIN(D55:G55)+MIN(D56:G56)+MIN(D57:G57)+MIN(D58:G58))+H62)/2+D60,(D62+H62)/2+D60),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(D187>0,\"rearward\",IF(D187<0,\"forward\",\"\"))","v":""}]
[null,null,"Vertical displacement - mm",null,{"$f":"IF(D188>0,\"upward\",IF(D188<0,\"downward\",\"\"))","v":""}]
[null,null,"Lateral displacement - mm",null,{"$f":"IF(D189>0,\"left\",IF(D189<0,\"right\",\"\"))","v":""}]
[null,"A-pillar"]
[null,null,"A-Pillar displacement - mm"]
[null,"Pedals"]
[null,null,"Brake Vertical displacement - mm",null,{"$f":"IF(D193=\"N/A\",\"\",IF(D193>0,\"upward\",IF(D193<0,\"downward\",\"\")))","v":""}]
[null,null,"Clutch Vertical displacement - mm",null,{"$f":"IF(D194=\"N/A\",\"\",IF(D194>0,\"upward\",IF(D194<0,\"downward\",\"\")))","v":""}]
[null,null,"Accel Vertical displacement - mm",null,{"$f":"IF(D195=\"N/A\",\"\",IF(D195>0,\"upward\",IF(D195<0,\"downward\",\"\")))","v":""}]
[null,null,"Brake Horizontal displacement - mm",null,{"$f":"IF(D196=\"N/A\",\"\",IF(D196>0,\"rearward\",IF(D196<0,\"forward\",\"\")))","v":""}]
[null,null,"Clutch Horizontal displacement - mm",null,{"$f":"IF(D197=\"N/A\",\"\",IF(D197>0,\"rearward\",IF(D197<0,\"forward\",\"\")))","v":""}]
[null,null,"Accel Horizontal displacement - mm",null,{"$f":"IF(D198=\"N/A\",\"\",IF(D198>0,\"rearward\",IF(D198<0,\"forward\",\"\")))","v":""}]
[]
[null,"TEST DETAILS"]
[null,"Vehicle"]
[null,null,"VIN numer"]
[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":5,"n_rows":159,"n_cols":5,"rows_kept":159,"cut":false,"hidden":false,"merged":[[150,1,150,4],[59,1,59,4],[46,3,46,4],[41,1,41,2],[41,3,41,4],[53,1,53,2],[53,3,53,4],[51,1,51,2],[51,3,51,4],[47,3,47,4],[49,1,49,2],[49,3,49,4],[45,3,45,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],[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]]}
[]
[null,"Side MDB Test",null,"Driver"]
[]
[null,{"$f":"'General Overview'!G6","v":0},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,"Door Opening",null,0]
[]
[null,"TOTAL",null,{"$f":"SUM(D45:E48,D50)","v":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,D52/2),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 numer"]
[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":6,"n_rows":178,"n_cols":7,"rows_kept":178,"cut":false,"hidden":false,"merged":[[169,1,169,4],[78,1,78,4],[37,3,37,4],[42,3,42,4],[70,1,70,2],[72,1,72,2],[43,1,43,2],[44,3,44,4],[45,3,45,4],[46,3,46,4],[47,3,47,4],[68,1,68,2],[49,3,49,4],[72,3,72,6],[66,1,66,2],[70,3,70,6],[17,1,17,2],[11,3,11,4],[49,5,49,6],[25,1,25,2],[25,3,25,4],[31,1,31,2],[26,3,26,4],[66,3,66,6],[68,3,68,6],[36,1,36,2],[36,3,36,4],[41,1,41,2],[41,3,41,4],[1,1,2,2],[3,1,3,2],[10,3,10,4],[1,3,2,4],[10,1,10,2]]}
[]
[null,"Side Pole Test",null,"Driver"]
[]
[null,{"$f":"'General Overview'!G7","v":0},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,"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":"D52+126-D54","v":126},null,{"$f":"F52+126-F56","v":126}]
[null,null,"ZCoG,5th",{"$f":"D53+594","v":594},null,{"$f":"F53+594","v":594}]
[null,null,"XCoG,95th",{"$f":"D52+147+D55","v":147},null,{"$f":"F52+147","v":147}]
[null,null,"ZCoG,95th",{"$f":"D53+693","v":693},null,{"$f":"F53+693","v":693}]
[]
[null,null,"HPD modifier (-2/-4)",null,{"$f":"IF(D64=\"OEM data\",0,IF(OR(D64=\"Fail\",D65=\"Fail\",D66=\"Fail\"),IF('General Overview'!C15=\"Yes\",-2,-4),0))","v":0},null,{"$f":"IF(F64=\"OEM data\",0,IF(OR(F64=\"Fail\",F65=\"Fail\",F66=\"Fail\"),IF('General Overview'!E15=\"Yes\",-2,-4),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":"IF('General Overview'!C15=\"Yes\",E63+G63,MIN(E63,G63))","v":0}]
[]
[null,"Door Opening",null,0]
[]
[null,"TOTAL",null,{"$f":"SUM(D45:E48,D67,D69)","v":0}]
[]
[null,"TOTAL SIDE POLE",null,{"$f":"ROUND(IF(OR(D6=\"Yes\",E7=0,E8=0,D15>=55,D16>=55,D17>=55,E30=0,E31=0,E40=0),0,D71/2),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 numer"]
[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 Whiplash","index":7,"n_rows":150,"n_cols":9,"rows_kept":150,"cut":false,"hidden":false,"merged":[[146,1,146,8],[35,3,35,4],[35,5,35,6],[67,1,67,2],[61,1,61,2],[65,3,65,8],[61,3,61,8],[35,7,35,8],[64,3,64,8],[42,1,42,2],[36,3,36,4],[36,5,36,6],[36,7,36,8],[76,1,76,8],[42,3,42,8],[70,1,70,2],[50,3,50,5],[51,3,51,5],[56,3,56,5],[56,6,56,8],[41,6,41,7],[45,4,45,5],[45,7,45,8],[49,1,49,2],[40,3,40,4],[40,6,40,7],[46,6,46,7],[47,6,47,7],[48,3,48,5],[48,6,48,8],[43,3,43,5],[43,6,43,8],[44,3,44,5],[44,6,44,8],[41,3,41,4],[5,3,5,8],[6,3,6,8],[70,3,70,8],[62,3,62,8],[63,3,63,8],[22,3,22,8],[49,3,49,8],[51,6,51,8],[50,6,50,8],[52,6,52,7],[53,6,53,7],[54,6,54,7],[55,6,55,7],[54,3,54,4],[46,3,46,4],[47,3,47,4],[1,7,2,8],[1,3,2,4],[1,5,2,6],[1,1,2,2],[3,1,3,2],[20,1,20,2],[20,3,20,8],[39,3,39,4],[12,1,12,2],[12,3,12,8],[22,1,22,2],[35,1,35,2],[37,3,37,5],[37,6,37,8],[39,6,39,7],[38,3,38,5],[38,6,38,8],[68,1,68,2],[68,3,68,8],[52,3,52,4],[57,3,57,8],[53,3,53,4],[67,3,67,8],[55,3,55,4],[57,1,57,2],[59,1,59,2],[59,3,59,8]]}
[]
[null,"Whiplash Tests",null,"Low Pulse",null,"Mid Pulse",null,"High Pulse"]
[]
[null,{"$f":"'General Overview'!G8","v":0},null,"Value","Points","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,"Backset (HRMD) - mm",null,{"$f":"ROUND(Sliding_Scale(D11,40,100,1,-1),Round)","v":0},null,{"$f":"ROUND(Sliding_Scale(F11,40,100,1,-1),Round)","v":0},null,{"$f":"ROUND(Sliding_Scale(H11,40,100,1,-1),Round)","v":0}]
[null,null,"Height (HRMD) - mm",null,{"$f":"ROUND(Sliding_Scale(D12,0,80,1,-1),Round)","v":0},null,{"$f":"ROUND(Sliding_Scale(F12,0,80,1,-1),Round)","v":0},null,{"$f":"ROUND(Sliding_Scale(H12,0,80,1,-1),Round)","v":0}]
[null,"Geometric assessment (test position)",null,{"$f":"MIN(AVERAGE(E11,G11,I11),AVERAGE(E12,G12,I12))","v":0}]
[]
[null,null,"Down/Back"]
[null,null,"Backset (HRMD) - mm",null,{"$f":"ROUND(Sliding_Scale(D16,40,100,1,-1),Round)","v":0},null,{"$f":"ROUND(Sliding_Scale(F16,40,100,1,-1),Round)","v":0},null,{"$f":"ROUND(Sliding_Scale(H16,40,100,1,-1),Round)","v":0}]
[null,null,"Height (HRMD) - mm",null,{"$f":"ROUND(Sliding_Scale(D17,0,80,1,-1),Round)","v":0},null,{"$f":"ROUND(Sliding_Scale(F17,0,80,1,-1),Round)","v":0},null,{"$f":"ROUND(Sliding_Scale(H17,0,80,1,-1),Round)","v":0}]
[]
[null,null,"Passenger Seat Backset (HRMD) - mm",null,{"$f":"ROUND(Sliding_Scale(D19,40,100,1,-1),Round)","v":0},null,{"$f":"ROUND(Sliding_Scale(F19,40,100,1,-1),Round)","v":0},null,{"$f":"ROUND(Sliding_Scale(H19,40,100,1,-1),Round)","v":0}]
[null,null,"Passenger Seat Height (HRMD) - mm",null,{"$f":"ROUND(Sliding_Scale(D20,0,80,1,-1),Round)","v":0},null,{"$f":"ROUND(Sliding_Scale(F20,0,80,1,-1),Round)","v":0},null,{"$f":"ROUND(Sliding_Scale(H20,0,80,1,-1),Round)","v":0}]
[null,"Ease of Adjustment",null,{"$f":"IF(MIN(AVERAGE(E16,G16,I16),AVERAGE(E17,G17,I17))>0,0.5,0)+IF(MIN(AVERAGE(E19,G19,I19),AVERAGE(E20,G20,I20))>0,0.5,0)","v":0}]
[]
[null,"Static assessment",null,{"$f":"SUM(D13,D21)","v":0}]
[]
[null,"DYNAMIC"]
[null,null,"T1 x-acc - g",null,{"$f":"ROUND(Sliding_Scale(D26,9.4,12,0.5,0),Round)","v":0},null,{"$f":"ROUND(Sliding_Scale(F26,9.3,13.1,0.5,0),Round)","v":0},null,{"$f":"ROUND(Sliding_Scale(H26,12.5,15.9,0.5,0),Round)","v":0}]
[null,null,"Head contact start - ms",null,{"$f":"ROUND(Sliding_Scale(D27,61,83,0.5,0),Round)","v":0},null,{"$f":"ROUND(Sliding_Scale(F27,57,82,0.5,0),Round)","v":0},null,{"$f":"ROUND(Sliding_Scale(H27,53,80,0.5,0),Round)","v":0}]
[null,null,null,null,{"$f":"MAX(E26:E27)","v":0},null,{"$f":"MAX(G26:G27)","v":0},null,{"$f":"MAX(I26:I27)","v":0}]
[]
[null,null,"NIC max - m2/s2",null,{"$f":"ROUND(Sliding_Scale(D30,9,15,0.5,0),Round)","v":0},null,{"$f":"ROUND(Sliding_Scale(F30,11,24,0.5,0),Round)","v":0},null,{"$f":"ROUND(Sliding_Scale(H30,13,23,0.5,0),Round)","v":0}]
[null,null,"Nkm ",null,{"$f":"ROUND(Sliding_Scale(D31,0.12,0.35,0.5,0),Round)","v":0},null,{"$f":"ROUND(Sliding_Scale(F31,0.15,0.55,0.5,0),Round)","v":0},null,{"$f":"ROUND(Sliding_Scale(H31,0.22,0.47,0.5,0),Round)","v":0}]
[null,null,"Rebound head vel rel sled - m/s",null,{"$f":"ROUND(Sliding_Scale(D32,3,4.4,0.5,0),Round)","v":0},null,{"$f":"ROUND(Sliding_Scale(F32,3.2,4.8,0.5,0),Round)","v":0},null,{"$f":"ROUND(Sliding_Scale(H32,4.1,5.5,0.5,0),Round)","v":0}]
[null,null,"UPPER Neck Shear (+Fx)  (head rw) - N",null,{"$f":"ROUND(Sliding_Scale(D33,30,110,0.5,0),Round)","v":0},null,{"$f":"ROUND(Sliding_Scale(F33,30,190,0.5,0),Round)","v":0},null,{"$f":"ROUND(Sliding_Scale(H33,30,210,0.5,0),Round)","v":0}]
[null,null,"UPPER Neck tension (+Fz) - N",null,{"$f":"ROUND(Sliding_Scale(D34,270,610,0.5,0),Round)","v":0},null,{"$f":"ROUND(Sliding_Scale(F34,360,750,0.5,0),Round)","v":0},null,{"$f":"ROUND(Sliding_Scale(H34,470,770,0.5,0),Round)","v":0}]
[null,null,"Max Seat Back Dynamic Deflection - degree",null,null,null,null,null,{"$f":"IF(H35>32,-3,0)","v":0}]
[null,"Dynamic assessment",null,{"$f":"IF(OR(D30>18.3,D31>0.5,D32>4.7,D33>187,D34>734,AND(D26>14.1,D27>83),AND(D26>12,D27>95)),0,SUM(E28,E30:E34))","v":0},null,{"$f":"IF(OR(F30>27,F31>0.69,F32>5.2,F33>290,F34>900,AND(F26>15.55,F27>82),AND(F26>13.1,F27>92)),0,SUM(G28,G30:G34))","v":0},null,{"$f":"IF(OR(H30>25.5,H31>0.78,H32>6,H33>364,H34>1024,AND(H26>17.8,H27>80),AND(H26>15.9,H27>92),H35>32),0,SUM(I28,I30:I34))","v":0}]
[null,null,null,{"$f":"ROUND(D36,1)","v":0},null,{"$f":"ROUND(F36,1)","v":0},null,{"$f":"ROUND(H36,1)","v":0}]
[null,"REAR WHIPLASH",null,"2ND ROW",null,null,{"$f":"IF('General Overview'!C18=0,\"\",\"3RD ROW\")","v":""}]
[null,null,"Effective Height"]
[null,null,"Lowest position - mm",null,null,{"$f":"IF(D40>720,\"Pass\",\"Fail\")","v":"Fail"},null,null,{"$f":"IF(G38=\"\",\"\",IF(G40>720,\"Pass\",\"Fail\"))","v":""}]
[null,null,"Highest position - mm",null,null,{"$f":"IF(D41>770,\"Pass\",\"Fail\")","v":"Fail"},null,null,{"$f":"IF(G38=\"\",\"\",IF(G41>770,\"Pass\",\"Fail\"))","v":""}]
[null,null,{"$f":"IF(OR(F41=\"Fail\",I41=\"Fail\"),\"<50mm from interior\",\"\")","v":"<50mm from interior"}]
[null,"Rear Effective Height assessment",null,{"$f":"(IF(OR(AND(F40=\"PASS\",F41=\"PASS\"),D42=\"Yes\"),1.5,0)+IF(OR(AND(I40=\"PASS\",I41=\"PASS\"),G42=\"Yes\"),1.5,0))/IF(G38=\"\",1,2)","v":0}]
[]
[null,null,"Backset requirements"]
[null,null,"Torso angle - deg",null,{"$f":"IF(D46=\"\",\"\",CONCATENATE(\"CPx limit = \",TEXT((7.128*D46+153),0)))","v":""},null,null,{"$f":"IF(G38=\"\",\"\",IF(G46=\"\",\"\",CONCATENATE(\"CPx limit = \",TEXT((7.128*G46+153),0))))","v":""}]
[null,null,"(ΔCP X) mid position- mm",null,null,{"$f":"IF(D47=\"\",0,IF(AND(F40=\"Pass\",F41=\"Pass\",D47<=(7.128*D46+153)),1/IF(G38=\"\",1,2),0))","v":0},null,null,{"$f":"IF(G38=\"\",\"\",IF(G47=\"\",0,IF(AND(I40=\"Pass\",I41=\"Pass\",G47<=(7.128*G46+153)),1/IF(G38=\"\",1,2),0)))","v":""}]
[null,null,"(ΔCP X) worst case position- mm",null,null,{"$f":"IF(D48=\"\",0,IF(AND(F40=\"Pass\",F41=\"Pass\",D48<=(7.128*D46+153)),0.5/IF(G38=\"\",1,2),0))","v":0},null,null,{"$f":"IF(G38=\"\",\"\",IF(G48=\"\",0,IF(AND(I40=\"Pass\",I41=\"Pass\",G48<=(7.128*G46+153)),0.5/IF(G38=\"\",1,2),0)))","v":""}]
[]
[null,"Rear Backset Assessment",null,{"$f":"SUM(F47,F48,I47,I48)","v":0}]
[]
[null,null,"Non-Use position",{"$f":"IF(OR(AND(F40=\"PASS\",F41=\"PASS\"),D42=\"Yes\",F47>0,F48>0),\"Eligible for scoring\",\"Not eligible for scoring\")","v":"Not eligible for scoring"},null,null,{"$f":"IF(OR(AND(I40=\"PASS\",I41=\"PASS\"),G42=\"Yes\",I47>0,I48>0),\"Eligible for scoring\",\"Not eligible for scoring\")","v":"Eligible for scoring"}]
[null,null,"Automatic return head restraints","Pass"]
[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(D52=\"Eligible for scoring\",OR(COUNTIF(D53:E56,\"Pass\")>0,COUNTIF(D53:E56,\"Not applicable\")=4)),1,0)+IF(AND(G52=\"Eligible for scoring\",OR(COUNTIF(G53:H56,\"Pass\")>0,COUNTIF(G53:H56,\"Not applicable\")=4)),1,0))/IF(G38=\"\",1,2)","v":0}]
[]
[null,"Rear Whiplash assessment",null,{"$f":"SUM(D43,D50,D58)","v":0}]
[]
[null,"SUMMARY"]
[null,null,"Static assessment",{"$f":"D23","v":0}]
[null,null,"Dynamic assessment",{"$f":"SUM(D36:I36)","v":0}]
[null,null,"Seatback Dynamic Deflection (-3)",{"$f":"I35","v":0}]
[null,null,"Dummy Artifact Loading (-2)",0]
[]
[null,"TOTAL FRONT WHIPLASH",null,{"$f":"ROUND(SUM(D63:I66)/11*2,Round)","v":0}]
[null,"TOTAL REAR WHIPLASH",null,{"$f":"ROUND(D60/4,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(D68:I69),D68*1.5)","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":"AEB City","index":8,"n_rows":33,"n_cols":5,"rows_kept":33,"cut":false,"hidden":false,"merged":[[22,1,22,2],[22,3,22,4],[1,1,2,2],[1,3,2,4],[3,1,3,2],[4,3,4,4],[14,1,14,2],[14,3,14,4],[16,3,16,4],[17,3,17,4],[18,3,18,4],[19,3,19,4],[20,3,20,4],[29,3,29,4],[30,3,30,4],[32,1,32,2],[32,3,32,4],[24,1,24,2],[24,3,24,4],[25,3,25,4],[26,3,26,4],[28,1,28,2],[28,3,28,4]]}
[3]
[null,"AEB City",null,"AEB"]
[]
[null,null,null,"Impact speed","Points"]
[null,"CCRs"]
[null,1,10,null,{"$f":"IF(D6=\"\",0,ROUND(($C6-IF(D6>$C6,$C6,D6))/$C6*B6,Round))","v":0}]
[null,2,15,null,0]
[null,2,20,null,0]
[null,2,25,null,0]
[null,2,30,null,0]
[null,2,35,null,0]
[null,1,40,null,0]
[null,1,45,null,0]
[null,1,50,null,0]
[null,"CCRs RESULT",null,{"$f":"IF(AND(D6=0,D7=0,D8=0),SUM(E6:E14),0)","v":0}]
[null,null,null,{"$f":"COUNTIF(F6:F14,2)*5+5","v":5}]
[null,"HMI"]
[null,null,"Preconditions"]
[null,null,"Default ON after every journey"]
[]
[null,null,"Additional HMI features"]
[null,null,"Minimum requirements to turn OFF AEB",null,{"$f":"IF(D22=\"YES\",2,0)","v":0}]
[null,"HMI RESULT",null,{"$f":"IF(D19=\"PASS\",SUM(E22:E22),0)","v":0}]
[]
[null,"SUMMARY"]
[null,null,"CCRs",{"$f":"D15/14","v":0}]
[null,null,"HMI",{"$f":"D23/2*1","v":0}]
[]
[null,"TOTAL"]
[null,null,"AEB",{"$f":"ROUND(SUM(D26:E26)*2.5,Round)","v":0}]
[null,null,"HMI",{"$f":"ROUND(SUM(D27:E27)*0.5,Round)","v":0}]
[]
[null,"TOTAL AEB City",null,{"$f":"ROUND((D30+D31),Round)","v":0}]

{"sheet":"COP Dynamic","index":9,"n_rows":84,"n_cols":7,"rows_kept":84,"cut":false,"hidden":false,"merged":[[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],[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],[19,1,19,2],[25,1,25,2],[25,3,25,4],[25,5,25,6],[34,1,34,2],[29,3,29,4],[29,5,29,6],[28,3,28,4],[28,5,28,6],[54,1,54,6],[42,1,42,2],[43,3,43,4],[43,5,43,6],[44,3,44,4],[44,5,44,6],[46,1,46,2],[46,3,46,4],[46,5,46,6],[40,1,40,2],[40,3,40,4],[40,5,40,6],[48,1,48,2],[48,3,48,6]]}
[3]
[null,"Child Occupant Protection",null,"Q6",null,"Q10"]
[]
[null,null,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,"Recommended by vehicle manufacturer"]
[]
[null,"FRONTAL"]
[null,null,"Dummy restraint throughout impact?"]
[null,null,"CRS anchorage to vehicle failure?"]
[null,null,"Head"]
[null,null,"Hard contact"]
[null,null,"HIC15",null,{"$f":"IF(OR(D16=\"Yes\",D17=\"\"),Sliding_Scale(D17,500,700,4,0),\"\")","v":0},null,{"$f":"IF(OR(F16=\"Yes\",F17=\"\"),Sliding_Scale(F17,500,700,4,0),\"\")","v":0}]
[null,null,"Head Resultant 3msec - g",null,{"$f":"ROUND(Sliding_Scale(D18,87,100,4,0),Round)","v":0},null,{"$f":"ROUND(Sliding_Scale(F18,87,100,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,"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,"Chest"]
[null,null,"Chest Resultant 3msec - g",null,{"$f":"ROUND(Sliding_Scale(D25,41,55,2,0),Round)","v":0},null,{"$f":"ROUND(Sliding_Scale(F25,41,55,2,0),Round)","v":0}]
[null,"Front assessment",null,{"$f":"IF(OR(D13=\"No\",D14=\"Yes\"),0,SUM(E20,E23,E25))","v":0},null,{"$f":"IF(OR(F13=\"No\",F14=\"Yes\"),0,SUM(G20,G23,G25))","v":0}]
[]
[null,"SIDE"]
[null,null,"Dummy restraint throughout impact?"]
[null,null,"CRS anchorage to vehicle failure?"]
[null,null,"Head"]
[null,null,"Hard contact"]
[null,null,"HIC15",null,{"$f":"IF(OR(D32=\"Yes\",D33=\"\"),Sliding_Scale(D33,500,700,2,0),\"\")","v":0},null,{"$f":"IF(OR(F32=\"Yes\",F33=\"\"),Sliding_Scale(F33,500,700,2,0),\"\")","v":0}]
[null,null,"Head Resultant 3msec - g",null,{"$f":"ROUND(Sliding_Scale(D34,72,88,2,0),Round)","v":0},null,{"$f":"ROUND(Sliding_Scale(F34,72,88,2,0),Round)","v":0}]
[null,"Head assessment",null,null,{"$f":"MAX(MIN(E33:E34),0)","v":0},null,{"$f":"MAX(MIN(G33:G34),0)","v":0}]
[]
[null,null,"Neck"]
[null,null,"Tension (Upper neck Fz)",null,{"$f":"IF(D38=\"\",0,IF(D38>=2.4,0,1))","v":0},null,{"$f":"IF(F38=\"\",0,IF(F38>=2.2,0,1))","v":0}]
[null,null,"Chest"]
[null,null,"Chest Resultant 3msec - g",null,{"$f":"IF(D40=\"\",0,IF(D40>=67,0,1))","v":0},null,{"$f":"IF(F40=\"\",0,IF(F40>=67,0,1))","v":0}]
[null,"Side assessment",null,{"$f":"IF(OR(D29=\"No\",D30=\"Yes\"),0,SUM(E35,E38,E40))","v":0},null,{"$f":"IF(OR(F29=\"No\",F30=\"Yes\"),0,SUM(G35,G38,G40))","v":0}]
[]
[null,"SUMMARY"]
[null,null,"Front assessment",{"$f":"D26","v":0},null,{"$f":"F26","v":0}]
[null,null,"Side assessment",{"$f":"D41","v":0},null,{"$f":"F41","v":0}]
[]
[null,"TOTAL",null,{"$f":"IF(OR(D13=\"No\",D14=\"Yes\",D29=\"No\",D30=\"Yes\"),0,SUM(D44:E45))","v":0},null,{"$f":"IF(OR(F13=\"No\",F14=\"Yes\",F29=\"No\",F30=\"Yes\"),0,SUM(F44:G45))","v":0}]
[]
[null,"TOTAL DYNAMIC ASSESSMENT",null,{"$f":"SUM(D47:G47)","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,"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"]

{"sheet":"COP Vehicle Based","index":10,"n_rows":53,"n_cols":10,"rows_kept":53,"cut":false,"hidden":false,"merged":[[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],[1,1,2,2],[1,3,2,3],[1,4,2,6],[1,7,2,9],[3,1,3,2],[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],[21,1,21,2],[25,1,25,2],[19,3,19,9],[20,3,20,9],[21,3,21,9],[25,3,25,9],[30,1,30,2],[34,1,34,2],[36,1,36,2],[30,3,30,9],[34,3,34,9],[36,3,36,9]]}
[]
[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"]
[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)),1,0)","v":0}]
[]
[null,"i-SIZE AND TOP TETHER MARKING"]
[null,null,"i-Size marking requirements"]
[null,null,"i-Size availabilty",{"$f":"IF(COUNTIF(D19:J19,\"Pass\")>=2,2,0)","v":0}]
[null,null,"Simultaneously covering i-Size",{"$f":"IF(COUNTIF(D19:J19,\"Pass\")>=3,1,0)","v":0}]
[null,"i-Size and top tether marking score",null,{"$f":"D20+D21","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,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,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,{"$f":"IF('General Overview'!F42=\"\",\"\",IF('General Overview'!F42=\"Standard\",\"Standard\",IF(NOT(ISERROR(FIND(\"Optional\",'General Overview'!F42))),\"Optional\",\"Not Available\")))","v":""},{"$f":"IF('General Overview'!G42=\"\",\"\",IF('General Overview'!G42=\"Standard\",\"Standard\",IF(NOT(ISERROR(FIND(\"Optional\",'General Overview'!G42))),\"Optional\",\"Not Available\")))","v":""},null,{"$f":"IF('General Overview'!H42=\"\",\"\",IF('General Overview'!H42=\"Standard\",\"Standard\",IF(NOT(ISERROR(FIND(\"Optional\",'General Overview'!H42))),\"Optional\",\"Not Available\")))","v":""}]
[null,"iSize",null,{"$f":"IF('General Overview'!F43=\"\",\"\",IF('General Overview'!F43=\"Standard\",\"Standard\",IF(NOT(ISERROR(FIND(\"Optional\",'General Overview'!F43))),\"Optional\",\"Not Available\")))","v":""},{"$f":"IF('General Overview'!G43=\"\",\"\",IF('General Overview'!G43=\"Standard\",\"Standard\",IF(NOT(ISERROR(FIND(\"Optional\",'General Overview'!G43))),\"Optional\",\"Not Available\")))","v":""},null,{"$f":"IF('General Overview'!H43=\"\",\"\",IF('General Overview'!H43=\"Standard\",\"Standard\",IF(NOT(ISERROR(FIND(\"Optional\",'General Overview'!H43))),\"Optional\",\"Not Available\")))","v":""}]
[null,"Integrated CRS",null,{"$f":"IF('General Overview'!F44=\"\",\"\",IF('General Overview'!F44=\"Standard\",\"Standard\",IF(NOT(ISERROR(FIND(\"Optional\",'General Overview'!F44))),\"Optional\",\"Not Available\")))","v":""},{"$f":"IF('General Overview'!G44=\"\",\"\",IF('General Overview'!G44=\"Standard\",\"Standard\",IF(NOT(ISERROR(FIND(\"Optional\",'General Overview'!G44))),\"Optional\",\"Not Available\")))","v":""},null,{"$f":"IF('General Overview'!H44=\"\",\"\",IF('General Overview'!H44=\"Standard\",\"Standard\",IF(NOT(ISERROR(FIND(\"Optional\",'General Overview'!H44))),\"Optional\",\"Not Available\")))","v":""}]

{"sheet":"COP CRS Installation","index":11,"n_rows":28,"n_cols":20,"rows_kept":28,"cut":false,"hidden":false,"merged":[[1,1,3,6],[1,7,1,15],[1,16,2,19],[2,7,2,9],[2,10,2,12],[2,13,2,15],[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],[9,1,12,1],[9,3,9,4],[10,3,10,4],[11,3,11,4],[12,3,12,4],[13,1,15,1],[13,3,14,4],[13,5,14,5],[13,6,14,6],[15,3,15,4],[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],[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]]}
[]
[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,"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(COUNTIF(H6:P6,\"\")>COUNTIF($H$5:$P$5,\"N/A\"),\"\",Q6/(Q6+R6))","v":""}]
[null,null,null,"Maxi Cosi Cabriofix & EasyFix",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(COUNTIF(H7:P7,\"\")>COUNTIF($H$5:$P$5,\"N/A\"),\"\",(Q7+S7)/(Q7+R7+S7))","v":""}]
[null,null,"Group I","Römer King II LS",null,"B _ _ _","U / UF",null,null,null,null,null,null,null,null,null,0,0,null,{"$f":"IF(COUNTIF(H8:P8,\"\")>COUNTIF($H$5:$P$5,\"N/A\"),\"\",Q8/(Q8+R8))","v":""}]
[null,null,"Group II/III","Römer KidFix XP",null,"B _ _ _","U / UF",null,null,null,null,null,null,null,null,null,0,0,null,{"$f":"IF(COUNTIF(H9:P9,\"\")>COUNTIF($H$5:$P$5,\"N/A\"),\"\",Q9/(Q9+R9))","v":""}]
[null,"ISOFIX","Group 0+","Maxi Cosi Cabriofix & EasyFix",null,"_ I L _","ISO/R1",null,null,null,null,null,null,null,null,null,0,0,null,{"$f":"IF(COUNTIF(H10:P10,\"\")>COUNTIF($H$5:$P$5,\"N/A\"),\"\",Q10/(Q10+R10))","v":""}]
[null,null,"Group 0+/I","BeSafe iZi Kid X3 ISOfix",null,"_ I L _","ISO/R3",null,null,null,null,null,null,null,null,null,0,0,0,{"$f":"IF(COUNTIF(H11:P11,\"\")>COUNTIF($H$5:$P$5,\"N/A\"),\"\",(Q11+S11)/(Q11+R11+S11))","v":""}]
[null,null,"Group I","Römer Duo Plus",null,"_ I _ S","ISO/F2X",null,null,null,null,null,null,null,null,null,0,0,null,{"$f":"IF(COUNTIF(H12:P12,\"\")>COUNTIF($H$5:$P$5,\"N/A\"),\"\",Q12/(Q12+R12))","v":""}]
[null,null,"Group II/III","Römer KidFix XP",null,"B I _ _","VEHICLE LIST",null,null,null,null,null,null,null,null,null,0,0,null,{"$f":"IF(COUNTIF(H13:P13,\"\")>COUNTIF($H$5:$P$5,\"N/A\"),\"\",Q13/(Q13+R13))","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,{"$f":"IF(AND(S14>0,Q14=0,R14=0),0,IF(COUNTIF(H14:P14,\"\")>COUNTIF($H$5:$P$5,\"N/A\"),\"\",Q14/(Q14+R14)))","v":""}]
[null,null,">15m-105cm",null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,{"$f":"IF(AND(S15>0,Q15=0,R15=0),0,IF(COUNTIF(H15:P15,\"\")>COUNTIF($H$5:$P$5,\"N/A\"),\"\",Q15/(Q15+R15)))","v":""}]
[null,null,"61-105cm","BeSafe iZi Kid X1 i-Size",null,"_ I L _","i-Size",null,null,null,null,null,null,null,null,null,0,0,null,{"$f":"IF(COUNTIF(H16:P16,\"\")>COUNTIF($H$5:$P$5,\"N/A\"),\"\",Q16/(Q16+R16))","v":""}]
[null,"OEM","Group 0+",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"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(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:T13,\"\")>0,0,AVERAGE(T10:T13)*2)","v":0}]
[null,null,"i-Size assessment",null,null,null,null,{"$f":"IF(COUNTIF(T14:T16,\"\")>0,0,AVERAGE(T14:T16)*4)","v":0}]
[null,null,"OEM assessment",null,null,null,null,{"$f":"IF(COUNTIF(T19:T20,\"\")>0,0,T17+AVERAGE(T19:T20)*1)","v":0}]
[]
[null,"TOTAL INSTALLATION ASSESSMENT",null,null,null,null,null,{"$f":"SUM(H23:T26)","v":0}]

{"sheet":"PP Headform","index":12,"n_rows":68,"n_cols":26,"rows_kept":68,"cut":false,"hidden":false,"merged":[[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],[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],[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],[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],[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],[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],[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],[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],[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],[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],[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],[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],[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],[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],[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],[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],[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],[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],[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]]}
[]
[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(T51=\"\",\"\",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(T53=\"\",\"\",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(T55=\"\",\"\",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(T57=\"\",\"\",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":"PP Upper Legform","index":13,"n_rows":35,"n_cols":29,"rows_kept":35,"cut":false,"hidden":false,"merged":[[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],[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],[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],[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],[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],[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],[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],[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],[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],[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],[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],[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,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],[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],[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],[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]]}
[]
[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":"PP Lower Legform","index":14,"n_rows":35,"n_cols":26,"rows_kept":35,"cut":false,"hidden":false,"merged":[[1,1,2,3],[6,1,6,2],[5,8,5,9],[3,22,3,24],[5,10,5,11],[5,12,5,13],[4,1,4,3],[4,22,4,24],[4,12,4,13],[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],[6,4,6,5],[6,6,6,7],[6,8,6,9],[6,10,6,11],[2,6,2,7],[2,8,2,9],[2,10,2,11],[11,18,11,19],[6,18,6,19],[6,20,6,21],[10,18,10,19],[11,16,11,17],[8,18,8,19],[5,1,5,3],[5,22,5,24],[7,16,7,17],[7,22,7,24],[7,4,7,5],[8,4,8,5],[8,6,8,7],[7,8,7,9],[7,10,7,11],[7,6,7,7],[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],[5,18,5,19],[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],[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],[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],[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],[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],[17,4,17,5],[5,6,5,7],[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],[9,8,9,9],[22,10,22,11],[18,10,18,11],[21,6,21,7],[16,6,16,7],[17,6,17,7],[17,8,17,9],[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],[12,10,12,11],[6,12,6,13],[6,16,6,17],[11,4,11,5],[11,6,11,7],[8,8,8,9],[8,10,8,11],[9,4,9,5],[9,6,9,7],[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],[5,20,5,21],[4,18,4,19],[4,20,4,21],[1,14,1,17],[3,14,3,15],[3,16,3,17],[5,16,5,17],[4,16,4,17],[21,4,21,5],[13,16,13,17],[8,16,8,17],[14,16,14,17],[15,16,15,17],[4,4,4,5],[4,6,4,7],[4,8,4,9],[4,10,4,11],[5,4,5,5],[15,8,15,9],[10,4,10,5],[10,6,10,7],[10,8,10,9],[10,10,10,11],[11,10,11,11]]}
[]
[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":"PP AEB Pedestrian","index":15,"n_rows":52,"n_cols":11,"rows_kept":52,"cut":false,"hidden":false,"merged":[[7,3,7,10],[5,3,5,10],[3,3,3,10],[4,3,4,10],[6,3,6,10],[1,1,1,2],[1,3,1,4],[1,5,1,8],[1,9,1,10],[2,1,2,2],[2,3,2,4],[2,5,2,6],[2,7,2,8],[2,9,2,10],[9,3,9,4],[9,5,9,6],[9,7,9,8],[9,9,9,10],[10,3,10,4],[10,5,10,6],[10,7,10,8],[10,9,10,10],[11,3,11,4],[11,5,11,6],[11,7,11,8],[11,9,11,10],[12,3,12,4],[12,5,12,6],[12,7,12,8],[12,9,12,10],[13,3,13,10],[14,1,14,2],[14,3,14,10],[28,1,28,2],[28,3,28,4],[28,5,28,6],[28,7,28,8],[28,9,28,10],[30,3,30,4],[30,5,30,10],[31,3,31,4],[31,5,31,10],[32,3,32,4],[32,5,32,10],[33,3,33,4],[33,5,33,10],[34,3,34,4],[34,5,34,10],[35,3,35,4],[35,5,35,10],[36,3,36,4],[36,5,36,10],[37,3,37,4],[37,5,37,10],[38,1,38,2],[38,3,38,10],[51,1,51,2],[51,3,51,10],[40,1,40,2],[40,3,40,10],[41,3,41,10],[42,3,42,10],[43,3,43,10],[44,3,44,10],[45,3,45,10],[47,1,47,2],[47,3,47,10],[48,3,48,10],[49,3,49,10]]}
[3]
[null,"AEB Pedestrian",null,"Adult Running",null,"Adult Walking",null,null,null,"Child Running"]
[null,"TESTNUMBER",null,"Farside 50%",null,"Nearside 25%",null,"Nearside 75%",null,"Nearside obstructed 50%"]
[null,"SYSTEM DETAILS"]
[null,null,"Name"]
[null,null,"Functionality"]
[null,null,"Speed range (km/h) - Minimum"]
[null,null,"Maximum"]
[]
[null,"PREREQUISITES"]
[]
[null,null,"Ability to identify slower walking pedestrian"]
[null,null,"System active from speeds of 10 km/h"]
[null,null,"System switches off below 60 km/h"]
[null,"PREREQUISITES",null,{"$f":"IF(AND(H12=\"PASS\",H13=\"PASS\",D14=\"NO\"),\"PASS\",\"FAIL\")","v":"FAIL"}]
[]
[null,"AEB",null,"Impact speed","Score","Impact speed","Score","Impact speed","Score","Impact speed","Score"]
[null,1,20,null,{"$f":"IF(D18=\"\",0,ROUND(($C18-IF(D18>$C18,$C18,D18))/$C18*1,Round))","v":0},null,{"$f":"IF(F18=\"\",0,ROUND(($C18-IF(F18>$C18,$C18,F18))/$C18*1,Round))","v":0},null,{"$f":"IF(H18=\"\",0,ROUND(($C18-IF(H18>$C18,$C18,H18))/$C18*1,Round))","v":0},null,{"$f":"IF(J18=\"\",0,ROUND(($C18-IF(J18>$C18,$C18,J18))/$C18*1,Round))","v":0}]
[null,2,25,null,{"$f":"IF(D19=\"\",0,ROUND(($C19-IF(D19>$C19,$C19,D19))/$C19*2,Round))","v":0},null,{"$f":"IF(F19=\"\",0,ROUND(($C19-IF(F19>$C19,$C19,F19))/$C19*2,Round))","v":0},null,{"$f":"IF(H19=\"\",0,ROUND(($C19-IF(H19>$C19,$C19,H19))/$C19*2,Round))","v":0},null,{"$f":"IF(J19=\"\",0,ROUND(($C19-IF(J19>$C19,$C19,J19))/$C19*2,Round))","v":0}]
[null,2,30,null,{"$f":"IF(D20=\"\",0,ROUND(($C20-IF(D20>$C20,$C20,D20))/$C20*2,Round))","v":0},null,{"$f":"IF(F20=\"\",0,ROUND(($C20-IF(F20>$C20,$C20,F20))/$C20*2,Round))","v":0},null,{"$f":"IF(H20=\"\",0,ROUND(($C20-IF(H20>$C20,$C20,H20))/$C20*2,Round))","v":0},null,{"$f":"IF(J20=\"\",0,ROUND(($C20-IF(J20>$C20,$C20,J20))/$C20*2,Round))","v":0}]
[null,3,35,null,{"$f":"IF(D21=\"\",0,ROUND(($C21-IF(D21>$C21,$C21,D21))/$C21*3,Round))","v":0},null,{"$f":"IF(F21=\"\",0,ROUND(($C21-IF(F21>$C21,$C21,F21))/$C21*3,Round))","v":0},null,{"$f":"IF(H21=\"\",0,ROUND(($C21-IF(H21>$C21,$C21,H21))/$C21*3,Round))","v":0},null,{"$f":"IF(J21=\"\",0,ROUND(($C21-IF(J21>$C21,$C21,J21))/$C21*3,Round))","v":0}]
[null,3,40,null,{"$f":"IF(D22=\"\",0,ROUND(($C22-IF(D22>$C22,$C22,D22))/$C22*3,Round))","v":0},null,{"$f":"IF(F22=\"\",0,ROUND(($C22-IF(F22>$C22,$C22,F22))/$C22*3,Round))","v":0},null,{"$f":"IF(H22=\"\",0,ROUND(($C22-IF(H22>$C22,$C22,H22))/$C22*3,Round))","v":0},null,{"$f":"IF(J22=\"\",0,ROUND(($C22-IF(J22>$C22,$C22,J22))/$C22*3,Round))","v":0}]
[]
[null,null,null,"Speed reduction","Score","Speed reduction","Score","Speed reduction","Score","Speed reduction","Score"]
[null,null,45,null,{"$f":"IF(D25=\"\",0,IF(D25>=20,3,0))","v":0},null,{"$f":"IF(F25=\"\",0,IF(F25>=20,3,0))","v":0},null,{"$f":"IF(H25=\"\",0,IF(H25>=20,3,0))","v":0},null,{"$f":"IF(J25=\"\",0,IF(J25>=20,3,0))","v":0}]
[null,null,50,null,{"$f":"IF(D26=\"\",0,IF(D26>=20,2,0))","v":0},null,{"$f":"IF(F26=\"\",0,IF(F26>=20,2,0))","v":0},null,{"$f":"IF(H26=\"\",0,IF(H26>=20,2,0))","v":0},null,{"$f":"IF(J26=\"\",0,IF(J26>=20,2,0))","v":0}]
[null,null,55,null,{"$f":"IF(D27=\"\",0,IF(D27>=20,1,0))","v":0},null,{"$f":"IF(F27=\"\",0,IF(F27>=20,1,0))","v":0},null,{"$f":"IF(H27=\"\",0,IF(H27>=20,1,0))","v":0},null,{"$f":"IF(J27=\"\",0,IF(J27>=20,1,0))","v":0}]
[null,null,60,null,{"$f":"IF(D28=\"\",0,IF(D28>=20,1,0))","v":0},null,{"$f":"IF(F28=\"\",0,IF(F28>=20,1,0))","v":0},null,{"$f":"IF(H28=\"\",0,IF(H28>=20,1,0))","v":0},null,{"$f":"IF(J28=\"\",0,IF(J28>=20,1,0))","v":0}]
[null,"AEB RESULT",null,{"$f":"IF((COUNTBLANK(D18:D22)+COUNTBLANK(D25:D28))>0,0,SUM(E18:E22,E25:E28))","v":0},null,{"$f":"IF((COUNTBLANK(F18:F22)+COUNTBLANK(F25:F28))>0,0,SUM(G18:G22,G25:G28))","v":0},null,{"$f":"IF((COUNTBLANK(H18:H22)+COUNTBLANK(H25:H28))>0,0,SUM(I18:I22,I25:I28))","v":0},null,{"$f":"IF((COUNTBLANK(J18:J22)+COUNTBLANK(J25:J28))>0,0,SUM(K18:K22,K25:K28))","v":0}]
[]
[null,"HMI"]
[null,null,"Preconditions"]
[null,null,"Default ON after every journey"]
[]
[null,null,"Additional HMI features"]
[null,null,"Minimum requirements to turn OFF AEB/FCW",null,null,{"$f":"IF(D36=\"Yes\",2,0)","v":0}]
[null,null,"Warning at speeds over 40 km/h",null,null,{"$f":"IF(D37=\"Yes\",1,0)","v":0}]
[null,null,"Operation at low ambient lighting conditions",null,null,{"$f":"IF(D38=\"Yes\",1,0)","v":0}]
[null,"HMI RESULT",null,{"$f":"IF(D33=\"PASS\",SUM(F36:K38),0)","v":0}]
[null,null,null,{"$f":"D39","v":0},{"$f":"ROUND(D39,1)","v":0}]
[null,"SUMMARY"]
[null,null,"Adult Running, farside, 50%",{"$f":"ROUND(D29/18,Round)","v":0}]
[null,null,"Adult Walking, nearside, 25%",{"$f":"ROUND(F29/18,Round)","v":0}]
[null,null,"Adult Walking, nearside, 75%",{"$f":"ROUND(H29/18,Round)","v":0}]
[null,null,"Child Running, nearside obscured, 50%",{"$f":"ROUND(J29/18,Round)","v":0}]
[null,null,"HMI",{"$f":"ROUND(D39/4,Round)","v":0}]
[]
[null,"TOTAL"]
[null,null,"AEB",{"$f":"ROUND(AVERAGE(D42:K45)*5,Round)","v":0}]
[null,null,"HMI",{"$f":"ROUND(D46*1,Round)","v":0}]
[]
[null,"TOTAL AEB Pedestrian",null,{"$f":"IF(D15=\"FAIL\",0,ROUND(SUM(D49:K50),Round))","v":0}]

{"sheet":"SA SBR","index":16,"n_rows":11,"n_cols":10,"rows_kept":11,"cut":false,"hidden":false,"merged":[[9,1,9,2],[7,1,7,2],[3,5,3,6],[7,3,7,6],[5,3,5,4],[6,3,6,4],[9,3,9,8],[5,7,6,7],[3,3,3,4],[7,7,7,8],[6,5,6,6],[5,5,5,6],[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]]}
[]
[null,"Seat Belt Reminder",null,"Driver",null,"Front Passenger",null,"Rear Passengers"]
[]
[null,{"$f":"'General Overview'!G12","v":0},null,"Score",null,"Score",null,"Nr of seats","Score"]
[null,"TYPE OF WARNING"]
[null,null,"Visual warning",null,null,null,null,{"$f":"SUM('General Overview'!C17:D18)","v":0}]
[null,null,"Audible warning"]
[null,"Seat Belt Reminder assessment",null,{"$f":"IF(COUNTIF(D6:G7,\"Pass\")=4,IF(H6=0,3,2),0)","v":0},null,null,null,{"$f":"IF(H6=0,\"\",IF(OR(I6=\"\",I7=\"\"),0,IF(OR(I6=\"Fail\",I7=\"Fail\"),0,ROUND(MIN(LEFT(I6,1),LEFT(I7,1))*1/H6,Round))))","v":""}]
[]
[null,"TOTAL SEAT BELT REMINDER",null,{"$f":"IF(D8=0,0,IF(H6=0,D8,SUM(D8+H8)))","v":0},null,null,null,null,null,{"$f":"ROUND(D10,1)","v":0}]
[null,null,null,{"$f":"IF(AND(D8=2,H8>0),\"All seats\",IF(D8=2,\"Front seats\",\"Not available\"))","v":"Not available"}]

{"sheet":"SA SAS","index":17,"n_rows":48,"n_cols":5,"rows_kept":48,"cut":false,"hidden":false,"merged":[[26,1,26,2],[26,3,26,4],[42,3,42,4],[30,3,30,4],[1,1,2,2],[1,3,2,4],[3,1,3,2],[14,3,14,4],[4,3,4,4],[5,3,5,4],[9,3,9,4],[12,1,12,2],[12,3,12,4],[6,3,6,4],[7,3,7,4],[15,3,15,4],[47,1,47,2],[47,3,47,4],[40,1,40,2],[40,3,40,4],[43,3,43,4],[42,1,42,2],[44,3,44,4],[16,3,16,4],[22,3,22,4],[28,3,28,4],[29,3,29,4],[45,3,45,4],[31,3,31,4],[18,3,18,4],[19,3,19,4],[21,3,21,4],[17,3,17,4]]}
[]
[null,"Speed Assistance System"]
[]
[null,{"$f":"'General Overview'!G13","v":0},null,"Value","Score"]
[null,"SYSTEM DETAILS"]
[null,null,"System name"]
[null,null,"Functionality"]
[null,null,"Active braking"]
[]
[null,"SPEED LIMIT INFORMATION FUNCTION"]
[null,null,"Type of system"]
[null,null,"Subsign recognition"]
[null,"SPEED LIMIT INFORMATION FUNCTION RESULT",null,{"$f":"IF(E11=\"Pass\",IF(OR(D11=\"Camera based\",D11=\"Map based\"),0.25,IF(D11=\"Camera & Map\",0.75,0))+IF(AND(D12=\"Yes\",E12=\"Pass\"),0.25,0),0)","v":0}]
[]
[null,"WARNING FUNCTION"]
[null,null,"Setting Vadj"]
[null,null,"Visual Warning"]
[null,null,"Position of warning"]
[null,null,"Supplementary Warning"]
[null,null,"Type of warning"]
[null,null,"Total duration ",null,{"$f":"IF(AND(D21<>\"\",D21>=10),\"Pass\",\"Fail\")","v":"Fail"}]
[]
[null,null,"Vindicated when warning is initiated"]
[null,null,"50 km/h test",null,{"$f":"IF(AND(D24<>\"\",D24<=55),\"Pass\",\"Fail\")","v":"Fail"}]
[null,null,"80 km/h test",null,{"$f":"IF(AND(D25<>\"\",D25<=85),\"Pass\",\"Fail\")","v":"Fail"}]
[null,null,"120 km/h test",null,{"$f":"IF(AND(D26<>\"\",D26<=125),\"Pass\",\"Fail\")","v":"Fail"}]
[null,"WARNING FUNCTION RESULT",null,{"$f":"IF(OR(D8=\"Yes\",AND(E21=\"Pass\",COUNTIF(E24:E26,\"Pass\")=3)),IF(D16=\"Manually set\",0.5,IF(D16=\"System advised\",1,0)),0)","v":0}]
[]
[null,"SPEED LIMITATION FUNCTION"]
[null,null,"Setting Vadj"]
[]
[null,null,"50 km/h test"]
[null,null,"Vstab",null,{"$f":"IF(AND(D33<>\"\",D33>=40),\"Pass\",\"Fail\")","v":"Fail"}]
[null,null,"difference between Vstab and Vadj",{"$f":"IF(D33=\"\",\"\",50-D33)","v":""}]
[null,null,"80 km/h test"]
[null,null,"Vstab",null,{"$f":"IF(AND(D36<>\"\",D36>=70),\"Pass\",\"Fail\")","v":"Fail"}]
[null,null,"maximum variation around Vstab"]
[null,null,"120 km/h test"]
[null,null,"Vstab",null,{"$f":"IF(AND(D39<>\"\",D39>=110),\"Pass\",\"Fail\")","v":"Fail"}]
[null,null,"maximum variation around Vstab",{"$f":"IF(D39=\"\",\"\",120-D39)","v":""}]
[null,"SPEED LIMITATION FUNCTION RESULT",null,{"$f":"IF(AND(D27<>0,D30<>\"N/A\"),IF(AND(D34<=5,D37<=5,D40<=5),1,IF(OR(D34>10,D37>10,D40>10),0,0.75)),0)","v":0}]
[]
[null,"SUMMARY"]
[null,null,"Speed Limit Information Function",{"$f":"D13","v":0}]
[null,null,"Warning Function",{"$f":"D27","v":0}]
[null,null,"Speed Limitation Function",{"$f":"D41","v":0}]
[]
[null,"TOTAL SAS",null,{"$f":"ROUND(SUM(D44:E46),Round)","v":0}]

{"sheet":"SA AEB Inter-Urban","index":18,"n_rows":71,"n_cols":7,"rows_kept":71,"cut":false,"hidden":false,"merged":[[5,3,5,6],[1,1,2,2],[1,3,2,4],[1,5,2,6],[3,1,3,2],[4,3,4,6],[6,3,6,4],[6,5,6,6],[7,3,7,4],[7,5,7,6],[8,3,8,4],[8,5,8,6],[9,3,9,4],[9,5,9,6],[11,3,11,4],[11,5,11,6],[23,1,23,2],[23,3,23,4],[23,5,23,6],[46,1,46,2],[46,3,46,4],[46,5,46,6],[25,3,25,4],[25,5,25,6],[37,1,37,2],[37,3,37,4],[37,5,37,6],[39,3,39,4],[39,5,39,6],[51,3,51,6],[40,3,40,4],[40,5,40,6],[43,3,43,4],[43,5,43,6],[48,3,48,4],[48,5,48,6],[49,3,49,4],[49,5,49,6],[50,3,50,6],[52,3,52,4],[52,5,52,6],[53,3,53,4],[53,5,53,6],[54,3,54,4],[54,5,54,6],[55,3,55,4],[55,5,55,6],[56,3,56,4],[56,5,56,6],[65,1,65,2],[65,3,65,6],[57,1,57,2],[57,3,57,6],[59,1,59,2],[59,3,59,4],[59,5,59,6],[60,3,60,4],[60,5,60,6],[66,3,66,6],[67,3,67,6],[70,1,70,2],[70,3,70,6],[61,3,61,4],[61,5,61,6],[62,3,62,4],[62,5,62,6],[63,3,63,6],[68,3,68,6]]}
[3]
[null,"AEB Inter-Urban",null,"AEB",null,"FCW"]
[]
[null,"TESTNUMBER",null,"Impact speed","Points","Impact speed","Points"]
[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,"CCRs"]
[null,2,30,"-","-",null,{"$f":"IF(F13=\"\",0,ROUND(($C13-IF(F13>$C13,$C13,F13))/$C13*B13,Round))","v":0}]
[null,2,35,"-","-",null,0]
[null,2,40,"-","-",null,0]
[null,2,45,"-","-",null,0]
[null,3,50,"-","-",null,0]
[null,2,55,"-","-",null,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,"CCRs RESULT",null,"-",null,{"$f":"SUM(G13:G23)","v":0}]
[]
[null,"CCRm"]
[null,1,30,null,{"$f":"IF(D27=\"\",0,ROUND((($C27-20)-(IF(D27<=20,20,IF(D27>$C27,$C27,D27))-20))/($C27-20)*B27,Round))","v":0},"-","-"]
[null,1,35,null,0,"-","-"]
[null,1,40,null,0,"-","-"]
[null,1,45,null,0,"-","-"]
[null,1,50,null,0,null,{"$f":"IF(F31=\"\",0,ROUND((($C31-20)-(IF(F31<=20,20,IF(F31>$C31,$C31,F31))-20))/($C31-20)*B31,Round))","v":0}]
[null,1,55,null,0,null,{"$f":"IF(F31=\"\",0,ROUND((($C32-20)-(IF(F32<=20,20,IF(F32>$C32,$C32,F32))-20))/($C32-20)*B32,Round))","v":0}]
[null,1,60,null,0,null,{"$f":"IF(F31=\"\",0,ROUND((($C33-20)-(IF(F33<=20,20,IF(F33>$C33,$C33,F33))-20))/($C33-20)*B33,Round))","v":0}]
[null,2,65,null,0,null,{"$f":"IF(F31=\"\",0,ROUND((($C34-20)-(IF(F34<=20,20,IF(F34>$C34,$C34,F34))-20))/($C34-20)*B34,Round))","v":0}]
[null,2,70,null,0,null,{"$f":"IF(F31=\"\",0,ROUND((($C35-20)-(IF(F35<=20,20,IF(F35>$C35,$C35,F35))-20))/($C35-20)*B35,Round))","v":0}]
[null,2,75,"-","-",null,{"$f":"IF(F31=\"\",0,ROUND((($C36-20)-(IF(F36<=20,20,IF(F36>$C36,$C36,F36))-20))/($C36-20)*B36,Round))","v":0}]
[null,2,80,"-","-",null,{"$f":"IF(F31=\"\",0,ROUND((($C37-20)-(IF(F37<=20,20,IF(F37>$C37,$C37,F37))-20))/($C37-20)*B37,Round))","v":0}]
[null,"CCRm RESULT",null,{"$f":"SUM(E27:E37)","v":0},null,{"$f":"SUM(G27:G37)","v":0}]
[]
[null,"CCRb"]
[null,null,"12m headway"]
[null,null,"-2m/s² EVT acceleration",null,{"$f":"IF(D42=\"\",0,ROUND((50-IF(D42>50,50,D42))/50*1,Round))","v":0},null,{"$f":"IF(F42=\"\",0,ROUND((50-IF(F42>50,50,F42))/50*1,Round))","v":0}]
[null,null,"-6m/s² EVT acceleration",null,{"$f":"IF(D43=\"\",0,ROUND((50-IF(D43>50,50,D43))/50*1,Round))","v":0},null,{"$f":"IF(F43=\"\",0,ROUND((50-IF(F43>50,50,F43))/50*1,Round))","v":0}]
[null,null,"40m headway"]
[null,null,"-2m/s² EVT acceleration",null,{"$f":"IF(D45=\"\",0,ROUND((50-IF(D45>50,50,D45))/50*1,Round))","v":0},null,{"$f":"IF(F45=\"\",0,ROUND((50-IF(F45>50,50,F45))/50*1,Round))","v":0}]
[null,null,"-6m/s² EVT acceleration",null,{"$f":"IF(D46=\"\",0,ROUND((50-IF(D46>50,50,D46))/50*1,Round))","v":0},null,{"$f":"IF(F46=\"\",0,ROUND((50-IF(F46>50,50,F46))/50*1,Round))","v":0}]
[null,"CCRb RESULT",null,{"$f":"SUM(E42:E43,E45:E46)","v":0},null,{"$f":"SUM(G42:G43,G45:G46)","v":0}]
[]
[null,"HMI"]
[null,null,"Preconditions"]
[null,null,"Audiovisual warning"]
[null,null,"Default ON after every journey"]
[]
[null,null,"Additional HMI features"]
[null,null,"Minimum requirements to turn OFF AEB/FCW",null,null,{"$f":"IF(D55=\"Yes\",2,0)","v":0}]
[null,null,"Suplementary warning",null,null,{"$f":"IF(D56=\"Yes\",1,0)","v":0}]
[null,null,"Restraint activation / dynamic retractors",null,null,{"$f":"IF(D57=\"Yes\",1,0)","v":0}]
[null,"HMI RESULT",null,{"$f":"IF(F8=\"YES\",IF(AND(D51=\"PASS\",D52=\"PASS\"),SUM(F55:F57),0),IF(D8=\"YES\",IF(D52=\"PASS\",SUM(F55,F57),0),0))","v":0}]
[]
[null,"SUMMARY"]
[null,null,"CCRs",{"$f":"D24","v":"-"},null,{"$f":"ROUND(F24/18*1,Round)","v":0}]
[null,null,"CCRm",{"$f":"ROUND(D38/11*1,Round)","v":0},null,{"$f":"ROUND(F38/11*1,Round)","v":0}]
[null,null,"CCRb",{"$f":"ROUND(D47/4*1,Round)","v":0},null,{"$f":"ROUND(F47/4*1,Round)","v":0}]
[null,null,"HMI",{"$f":"ROUND(D58/(IF(F8=\"YES\",4,3))*1,Round)","v":0}]
[]
[null,"TOTAL"]
[null,null,"AEB",{"$f":"ROUND(SUM(D61:E63)/2*1.5,Round)","v":0}]
[null,null,"FCW",{"$f":"ROUND(SUM(F61:G63)/3*1,Round)","v":0}]
[null,null,"HMI",{"$f":"ROUND(SUM(D64:G64)*0.5,Round)","v":0}]
[]
[null,"TOTAL AEB Inter-Urban",null,{"$f":"IF(AND(OR(D8=\"YES\",F8=\"YES\"),D10>=80,F10>=80),ROUND((D67+D68+D69),Round),0)","v":0}]

{"sheet":"SA LDW LKA","index":19,"n_rows":39,"n_cols":15,"rows_kept":39,"cut":false,"hidden":false,"merged":[[6,3,6,14],[1,1,2,2],[1,3,2,6],[1,7,2,14],[3,1,3,2],[4,3,4,14],[5,3,5,14],[25,1,25,2],[25,3,25,6],[14,13,14,14],[7,3,7,6],[7,7,7,14],[8,3,8,6],[8,7,8,14],[9,3,9,6],[9,7,9,14],[14,3,14,4],[14,5,14,6],[14,7,14,8],[14,9,14,10],[14,11,14,12],[10,3,10,6],[10,7,10,14],[38,1,38,2],[38,3,38,14],[29,3,29,8],[29,13,29,14],[30,3,30,8],[30,13,30,14],[31,1,31,2],[31,3,31,14],[33,1,33,2],[33,3,33,14],[34,3,34,14],[35,3,35,14],[36,3,36,14],[11,3,11,14],[25,7,25,14],[27,3,27,14],[28,3,28,8],[28,13,28,14],[13,11,13,14],[13,3,13,6],[13,7,13,10]]}
[3]
[null,"LANE SUPPORT SYSTEMS",null,"LKA",null,null,null,"LDW"]
[]
[null,"TESTNUMBER",null,"DTCL","Pass/Fail","DTCL","Pass/Fail","DTCL","Pass/Fail","DTCL","Pass/Fail","DTCL","Pass/Fail","DTCL","Pass/Fail"]
[null,"SYSTEM DETAILS"]
[null,null,"System name"]
[null,null,"ESC meeting R13H"]
[null,null,"LKA and/or LDW"]
[null,null,"Functionality"]
[null,null,"Speed range (km/h) - Minimum"]
[null,null,"Maximum"]
[]
[]
[null,"LANE SUPPORT SYSTEMS",null,"SOLID LINE ON FULLY MARKED LANE",null,null,null,"SINGLE DASHED LINE",null,null,null,"SINGLE SOLID LINE"]
[null,null,null,"Test on left side",null,"Test on right side",null,"Test on left side",null,"Test on right side",null,"Test on left side",null,"Test on right side"]
[null,2,0.1,null,{"$f":"IF(D16=\"\",\"\",IF(D16<=0.4,\"Pass\",\"Fail\"))","v":""},null,{"$f":"IF(F16=\"\",\"\",IF(F16<=0.4,\"Pass\",\"Fail\"))","v":""}]
[null,2,0.2,null,{"$f":"IF(D17=\"\",\"\",IF(D17<=0.4,\"Pass\",\"Fail\"))","v":""},null,{"$f":"IF(F17=\"\",\"\",IF(F17<=0.4,\"Pass\",\"Fail\"))","v":""}]
[null,2,0.3,null,{"$f":"IF(D18=\"\",\"\",IF(D18<=0.4,\"Pass\",\"Fail\"))","v":""},null,{"$f":"IF(F18=\"\",\"\",IF(F18<=0.4,\"Pass\",\"Fail\"))","v":""},null,{"$f":"IF(H18=\"\",\"\",IF(H18<=0.3,\"Pass\",\"Fail\"))","v":""},null,{"$f":"IF(J18=\"\",\"\",IF(J18<=0.3,\"Pass\",\"Fail\"))","v":""},null,{"$f":"IF(L18=\"\",\"\",IF(L18<=0.3,\"Pass\",\"Fail\"))","v":""},null,{"$f":"IF(N18=\"\",\"\",IF(N18<=0.3,\"Pass\",\"Fail\"))","v":""}]
[null,2,0.4,null,{"$f":"IF(D19=\"\",\"\",IF(D19<=0.4,\"Pass\",\"Fail\"))","v":""},null,{"$f":"IF(F19=\"\",\"\",IF(F19<=0.4,\"Pass\",\"Fail\"))","v":""}]
[null,3,0.5,null,{"$f":"IF(D20=\"\",\"\",IF(D20<=0.4,\"Pass\",\"Fail\"))","v":""},null,{"$f":"IF(F20=\"\",\"\",IF(F20<=0.4,\"Pass\",\"Fail\"))","v":""},null,{"$f":"IF(H20=\"\",\"\",IF(H20<=0.3,\"Pass\",\"Fail\"))","v":""},null,{"$f":"IF(J20=\"\",\"\",IF(J20<=0.3,\"Pass\",\"Fail\"))","v":""},null,{"$f":"IF(L20=\"\",\"\",IF(L20<=0.3,\"Pass\",\"Fail\"))","v":""},null,{"$f":"IF(N20=\"\",\"\",IF(N20<=0.3,\"Pass\",\"Fail\"))","v":""}]
[null,2,0.6,null,"-",null,"-"]
[null,1,0.7,null,"-",null,"-"]
[null,1,0.8,null,"-",null,"-"]
[null,1,0.9,null,"-",null,"-"]
[null,1,1,null,"-",null,"-"]
[null,"LANE SUPPORT SYSTEMS RESULT",null,{"$f":"IF(IF(AND(E16=\"Pass\",G16=\"Pass\"),1,0)+IF(AND(E17=\"Pass\",G17=\"Pass\"),1,0)+IF(AND(E18=\"Pass\",G18=\"Pass\"),1,0)+IF(AND(E19=\"Pass\",G19=\"Pass\"),1,0)+IF(AND(E20=\"Pass\",G20=\"Pass\"),1,0)>=3,1,0)","v":0},null,null,null,{"$f":"IF(AND(I18=\"Pass\",I20=\"Pass\",K18=\"Pass\",K20=\"Pass\",M18=\"Pass\",M20=\"Pass\",O18=\"Pass\",O20=\"Pass\"),1.5,0)","v":0}]
[null,null,null,{"$f":"ROUND(D26,1)","v":0},null,null,null,{"$f":"ROUND(H26,1)","v":0}]
[null,"HMI"]
[null,null,"Default ON",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D29=\"Yes\",0.2,0)","v":0}]
[null,null,"Haptic Warning",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D30=\"Yes\",0.2,0)","v":0}]
[null,null,"Blind Spot Monitoring",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D31=\"Yes\",0.1,0)","v":0}]
[null,"HMI RESULT",null,{"$f":"SUM(N29:O31)","v":0}]
[]
[null,"TOTAL"]
[null,null,"LKA",{"$f":"IF(D9=\"NO\",0,D26)","v":0}]
[null,null,"LDW",{"$f":"IF(H9=\"NO\",0,H26)","v":0}]
[null,null,"HMI",{"$f":"D32","v":0}]
[]
[null,"TOTAL LANE SUPPORT SYSTEMS",null,{"$f":"SUM(D35:O37)","v":0}]