{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Pedestrian Protection"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":263,"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":"Pedestrian Protection","index":0,"n_rows":40,"n_cols":49,"rows_kept":40,"cut":false,"hidden":false,"merged":[[18,26,18,27],[19,1,21,8],[1,26,2,48],[31,1,31,9],[28,10,28,12],[29,10,29,12],[30,10,30,12],[31,10,31,12],[28,4,28,9],[22,10,22,12],[11,26,12,48],[13,26,13,27],[14,26,14,27],[15,26,15,27],[16,26,16,27],[17,26,17,27],[3,26,3,27],[7,26,7,27],[8,26,8,27],[4,26,4,27],[5,26,5,27],[6,26,6,27],[22,22,22,24],[1,1,2,24],[23,19,23,21],[23,22,23,24],[23,1,23,3],[24,19,24,21],[24,22,24,24],[4,1,18,1],[3,1,3,3],[22,19,22,21],[22,4,22,9],[23,10,23,12],[24,10,24,12],[22,13,22,15],[23,13,23,15],[24,13,24,15],[22,1,22,3],[22,16,22,18],[23,16,23,18],[24,16,24,18],[23,4,23,9],[24,4,24,9],[25,4,25,9],[26,4,26,9],[25,16,25,18],[26,1,26,3],[26,16,26,18],[25,10,25,12],[26,10,26,12],[25,13,25,15],[24,1,24,3],[25,1,25,3],[25,19,25,21],[25,22,25,24],[27,13,27,15],[28,13,28,15],[29,13,29,15],[29,1,29,3],[31,22,31,24],[27,1,27,3],[26,22,26,24],[29,16,29,18],[33,1,33,18],[33,19,33,24],[27,19,27,21],[27,22,27,24],[31,19,31,21],[34,19,34,24],[35,3,35,18],[35,19,35,24],[35,1,35,2],[37,19,37,24],[31,16,31,18],[26,19,26,21],[30,16,30,18],[27,16,27,18],[28,16,28,18],[30,13,30,15],[31,13,31,15],[37,1,37,18],[34,1,34,2],[38,1,38,18],[38,19,38,24],[36,1,36,2],[39,1,39,18],[39,19,39,24],[36,3,36,18],[36,19,36,24],[34,3,34,18],[28,1,28,3],[26,13,26,15],[28,19,28,21],[28,22,28,24],[30,1,30,3],[30,19,30,21],[30,22,30,24],[30,4,30,9],[27,4,27,9],[29,4,29,9],[27,10,27,12],[29,19,29,21],[29,22,29,24],[19,26,21,27]]}
[]
[null,"Headforms",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Upper Legform"]
[]
[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,"STARTING POINT",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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"U0"]
[null,null,2300,13,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"U1"]
[null,null,2200,12,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Symmetry"]
[null,null,2100,11,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"U0 Summary",null,{"$f":"IF(OR(AC5=\"\",AC$7=\"\"),\"\",IF(OR(AC5=\"N/A\",AC$7=\"N/A\"),\"N/A\",IF(AC$7=\"Y\",IF(OR(AC5=\"T\",AC5=\"N\"),\"T/S\",\"A\"),IF(OR(AC5=\"T\",AC5=\"N\"),\"T\",\"A\"))))","v":""},{"$f":"IF(OR(AD5=\"\",AD$7=\"\"),\"\",IF(OR(AD5=\"N/A\",AD$7=\"N/A\"),\"N/A\",IF(AD$7=\"Y\",IF(OR(AD5=\"T\",AD5=\"N\"),\"T/S\",\"A\"),IF(OR(AD5=\"T\",AD5=\"N\"),\"T\",\"A\"))))","v":""},"","","","","","","","","","","","","","","","","","",""]
[null,null,2000,10,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"U1 Summary",null,{"$f":"IF(OR(AC6=\"\",AC$7=\"\"),\"\",IF(OR(AC6=\"N/A\",AC$7=\"N/A\"),\"N/A\",IF(AC$7=\"Y\",IF(OR(AC6=\"T\",AC6=\"N\"),\"T/S\",\"A\"),IF(OR(AC6=\"T\",AC6=\"N\"),\"T\",\"A\"))))","v":""},"","","","","","","","","","","","","","","","","","","",""]
[null,null,1900,9]
[null,null,1800,8]
[null,null,1700,7,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lower Legform"]
[null,null,1600,6]
[null,null,1500,5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"STARTING POINT",null,10,9,8,7,6,5,4,3,2,1,0,-1,-2,-3,-4,-5,-6,-7,-8,-9,-10]
[null,null,1400,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"L0"]
[null,null,1300,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"L1"]
[null,null,1200,2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Symmetry"]
[null,null,1100,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"L0 Summary",null,{"$f":"IF(OR(AC15=\"\",AC$17=\"\"),\"\",IF(OR(AC15=\"N/A\",AC$17=\"N/A\"),\"N/A\",IF(AC$17=\"Y\",IF(OR(AC15=\"T\",AC15=\"N\"),\"T/S\",\"A\"),IF(OR(AC15=\"T\",AC15=\"N\"),\"T\",\"A\"))))","v":""},{"$f":"IF(OR(AD15=\"\",AD$17=\"\"),\"\",IF(OR(AD15=\"N/A\",AD$17=\"N/A\"),\"N/A\",IF(AD$17=\"Y\",IF(OR(AD15=\"T\",AD15=\"N\"),\"T/S\",\"A\"),IF(OR(AD15=\"T\",AD15=\"N\"),\"T\",\"A\"))))","v":""},"","","","","","","","","","","","","","","","","","",""]
[null,null,1000,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"L1 Summary",null,{"$f":"IF(OR(AC16=\"\",AC$17=\"\"),\"\",IF(OR(AC16=\"N/A\",AC$17=\"N/A\"),\"N/A\",IF(AC$17=\"Y\",IF(OR(AC16=\"T\",AC16=\"N\"),\"T/S\",\"A\"),IF(OR(AC16=\"T\",AC16=\"N\"),\"T\",\"A\"))))","v":""},{"$f":"IF(OR(AD16=\"\",AD$17=\"\"),\"\",IF(OR(AD16=\"N/A\",AD$17=\"N/A\"),\"N/A\",IF(AD$17=\"Y\",IF(OR(AD16=\"T\",AD16=\"N\"),\"T/S\",\"A\"),IF(OR(AD16=\"T\",AD16=\"N\"),\"T\",\"A\"))))","v":""},"","","","","","","","","","","","","","","","","","",""]
[null,{"$f":"IF(COUNTBLANK(E5:Y19)>0,\"Please enter a predicted value or N/A into all grey cells\",\"\")","v":"Please enter a predicted value or N/A into all grey cells"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTBLANK(AC5:AW7)+COUNTBLANK(AC15:AW17)>0,\"Please enter a value or N/A into all grey cells\",\"\")","v":"Please enter a value or N/A into all grey cells"},null,"T:","Test point"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N:","Nominated point"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"A:","Adjacent score point"]
[null,"PREDICTION",null,null,null,null,null,null,null,null,"Nr of points",null,null,"%-age",null,null,"% x test points",null,null,"Scaled",null,null,"Score"]
[null,null,null,null,"Default green",null,null,null,null,null,{"$f":"COUNTIF($E$5:$Y$19,\"D Green\")","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"K24*1","v":0}]
[null,null,null,null,"Green",null,null,null,null,null,{"$f":"COUNTIF($E$5:$Y$19,\"Green\")","v":0},null,null,{"$f":"IF(COUNTBLANK($E$5:$Y$19)>0,\"\",K25/($K$32-$K$24-$K$30-$K$31))","v":""},null,null,{"$f":"IF(COUNTBLANK($E$5:$Y$19)>0,\"\",ROUND(N25*SUM($T$35:$Y$36),0))","v":""},null,null,2,null,null,{"$f":"K25*1","v":0}]
[null,null,null,null,"Yellow",null,null,null,null,null,{"$f":"COUNTIF($E$5:$Y$19,\"Yellow\")","v":0},null,null,{"$f":"IF(COUNTBLANK($E$5:$Y$19)>0,\"\",K26/($K$32-$K$24-$K$30-$K$31))","v":""},null,null,{"$f":"IF(COUNTBLANK($E$5:$Y$19)>0,\"\",ROUND(N26*SUM($T$35:$Y$36),0))","v":""},null,null,2,null,null,{"$f":"K26*0.75","v":0}]
[null,null,null,null,"Orange",null,null,null,null,null,{"$f":"COUNTIF($E$5:$Y$19,\"Orange\")","v":0},null,null,{"$f":"IF(COUNTBLANK($E$5:$Y$19)>0,\"\",K27/($K$32-$K$24-$K$30-$K$31))","v":""},null,null,{"$f":"IF(COUNTBLANK($E$5:$Y$19)>0,\"\",ROUND(N27*SUM($T$35:$Y$36),0))","v":""},null,null,3,null,null,{"$f":"K27*0.5","v":0}]
[null,null,null,null,"Brown",null,null,null,null,null,{"$f":"COUNTIF($E$5:$Y$19,\"Brown\")","v":0},null,null,{"$f":"IF(COUNTBLANK($E$5:$Y$19)>0,\"\",K28/($K$32-$K$24-$K$30-$K$31))","v":""},null,null,{"$f":"IF(COUNTBLANK($E$5:$Y$19)>0,\"\",ROUND(N28*SUM($T$35:$Y$36),0))","v":""},null,null,1,null,null,{"$f":"K28*0.25","v":0}]
[null,null,null,null,"Red",null,null,null,null,null,{"$f":"COUNTIF($E$5:$Y$19,\"Red\")","v":0},null,null,{"$f":"IF(COUNTBLANK($E$5:$Y$19)>0,\"\",K29/($K$32-$K$24-$K$30-$K$31))","v":""},null,null,{"$f":"IF(COUNTBLANK($E$5:$Y$19)>0,\"\",ROUND(N29*SUM($T$35:$Y$36),0))","v":""},null,null,2,null,null,{"$f":"K29*0","v":0}]
[null,null,null,null,"Default Red",null,null,null,null,null,{"$f":"COUNTIF($E$5:$Y$19,\"D Red\")","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"K30*0","v":0}]
[null,null,null,null,"Blue",null,null,null,null,null,{"$f":"COUNTIF($E$5:$Y$19,\"Blue\")","v":0}]
[null,"Predicted headform score (ex Blue)",null,null,null,null,null,null,null,null,{"$f":"SUM(K24:M31)","v":0},null,null,{"$f":"SUM(N25:N29)","v":0},null,null,{"$f":"SUM(Q25:Q29)","v":0},null,null,10,null,null,{"$f":"SUM(W24:Y30)","v":0}]
[]
[null,"NUMBER OF TEST POINTS"]
[null,null,null,"Standard number of test points ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10]
[null,null,null,"Number of test points sponsored by the manufacturer",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,"Number of blue zones sponsored by the manufacturer"]
[null,"Total of headform test points",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(T35:Y37)","v":10}]
[null,"Total of headform test points for sponsor",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"T35","v":10}]
[null,"Total of headform test points for manufacturer",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"T38-T39","v":0}]