{"text_format":"1","workbook":"xlsx","n_sheets":25,"sheets":["ENABLE MACROS","User Form","FP SEAT CHART","FP CMM DATA","FP SEAT RANGE CALC","FP FINAL H-POINT & SEAT POS","FP Clearance Measures","SEAT INFORMATION","SEAT PAN ADJUSTMENT","CMM DATA A","SEAT RANGE CALCULATIONS A","UMTRI CALCULATIONS A","FINAL H-POINT & SEAT POSITION A","SEAT CHART A","CMM DATA B","SEAT RANGE CALCULATIONS B","UMTRI CALCULATIONS B","FINAL H-POINT & SEAT POSITION B","SEAT CHART B","Excursion calculations","Additional Occupant Measures","Frontal Clearance Measures","Side Clearance Measures","Additional Measures","Excursion"],"not_rendered":{"charts":8,"images":6,"macros":1,"external_links":0,"defined_names":168,"comments":0,"pivot_tables":0},"unopened":[{"sheet":"FP SEAT CHART","index":2,"reason":"not_a_worksheet"},{"sheet":"SEAT CHART A","index":13,"reason":"not_a_worksheet"},{"sheet":"SEAT CHART B","index":18,"reason":"not_a_worksheet"}],"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":"ENABLE MACROS","index":0,"n_rows":3,"n_cols":1,"rows_kept":3,"cut":false,"hidden":true,"merged":[]}
[]
["Macros must be enabled for the ATD Positioning Template to function"]
["Close workbook and re-open with macros enabled"]

{"sheet":"User Form","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"FP CMM DATA","index":3,"n_rows":22,"n_cols":21,"rows_kept":22,"cut":false,"hidden":true,"merged":[[12,8,12,10]]}
[]
[null,"Seat information",null,null,null,null,null,null,"User Entered Data"]
[null,null,null,"Seat type",null,null,null,null,"CMM Data","Coordinate system",null,"+X: towards rear of vehicle; +Z: upwards"]
[null,null,null,"Number of locking positions",null,null,null,null,"Calculated Data",null,null,"* The calculations used in this worksheet apply only to this coordinate system"]
[null,null,null,"Adjustment range (mm)",{"$f":"IF(E4=\"\",\"\",ABS('FP SEAT RANGE CALC'!C15))","v":""}]
[null,null,null,"Movement per notch (mm)",{"$f":"IF(E4=\"\",\"\",IF(E4=\"n/a\",\"n/a\",E5/E4))","v":""}]
[]
[null,null,null,"X (mm)","Y (mm)","Z (mm)",null,null,"Additional Measurements",null,null,"X (mm)","Y (mm)","Z (mm)",null,"For manual seats with even notches",null,null,"X (mm)","Y (mm)","Z (mm)"]
[null,null,"Passenger door striker",null,null,null,null,null,null,null,"Seat Ref. Pt. 1 (calculated midtrack)",{"$f":"IF(D12=\"\",\"\",AVERAGE(D10,D12))","v":""},"","",null,null,null,"Seat Ref. Pt. 1 at notch forward of mid"]
[null,null,"Seat Ref. Pt. 1, rear/down",null,null,null,null,null,null,null,"Seat Ref. Pt. 2 (calculated midtrack)","","","",null,null,null,"Seat Ref. Pt. 2 at notch forward of mid"]
[null,null,"Seat Ref. Pt. 2, rear/down",null,null,null,null,null,null,null,"Seat Ref. Pt. 1 at midtrack/down",null,null,null,null,null,null,"Seat Ref. Pt. 1 at notch rearward of mid"]
[null,null,"Seat Ref. Pt. 1 forward/down",null,null,null,null,null,null,null,"Seat Ref. Pt. 2 at midtrack/down",null,null,null,null,null,null,"Seat Ref. Pt. 2 at notch rearward of mid"]
[null,null,"Seat Ref. Pt. 2 forward/down",null,null,null,null,null,"H-point at midtrack/down*",null,null,null,null,null,null,{"$f":"IF(S10=\"\",\"\",IF(ABS((AVERAGE(S12,S10)-AVERAGE(D11,D13)))>2,\"Midpoint Discrepancy.  Check the number of locking positions and initial seat position\",\"\"))","v":""}]
[null,null,"Seat Ref. Pt. 1 forward/up",null,null,null,null,null,null,null,"H-point to Seat Ref. Pt. 2",{"$f":"IF(L13=\"\",\"\",L13-L12)","v":""},{"$f":"IF(M13=\"\",\"\",M13-M12)","v":""},{"$f":"IF(N13=\"\",\"\",N13-N12)","v":""}]
[null,null,"Seat Ref. Pt. 2 forward/up",null,null,null,null,null,"* for manual seats with even number of notches, seat is set to one notch rearward of mid"]
[null,null,"Seat Ref. Pt. 1 rear/up"]
[null,null,"Seat Ref. Pt. 2 rear/up"]
[]
[null,null,null,"X (mm)","Y (mm)","Z (mm)"]
[null,null,"Calibration Pt 1"]
[null,null,"Calibration Pt 2"]
[null,null,"Resultant",{"$f":"SQRT((D20-D21)^2+(E20-E21)^2+(F20-F21)^2)","v":0}]

{"sheet":"FP SEAT RANGE CALC","index":4,"n_rows":25,"n_cols":15,"rows_kept":25,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Position","Seat Pt. 2",null,"Seat Pt. 1",null,null,null,null,null,"H-point",null,"Position"]
[null,null,"X","Z","X","Z","a",null,"Q ",null,"X","Z"]
[null,null,"(mm)","(mm)","(mm)","(mm)","(radians)","(degrees)","(radians)","(degrees)","(mm)","(mm)"]
[null,"Rear/Down",{"$f":"'FP CMM DATA'!D11","v":0},{"$f":"'FP CMM DATA'!F11","v":0},{"$f":"'FP CMM DATA'!D10","v":0},{"$f":"'FP CMM DATA'!F10","v":0},{"$f":"(ATAN((F5-D5)/(C5-E5)))","v":{"$error":"#DIV/0!"}},{"$f":"DEGREES(G5)","v":{"$error":"#DIV/0!"}},{"$f":"$I$6-$G$6+G5","v":{"$error":"#DIV/0!"}},{"$f":"DEGREES(I5)","v":{"$error":"#DIV/0!"}},{"$f":"IF(I5<PI()/2,C5-$H$14*COS(I5),IF(I5>PI()/2,C5+$H$14*COS(PI()-I5),C5))","v":{"$error":"#DIV/0!"}},{"$f":"IF(I5<PI()/2,D5+$H$14*SIN(I5),IF(I5>PI()/2,D5+$H$14*SIN(PI()-I5),D5+$H$14))","v":{"$error":"#DIV/0!"}},"Rear/Down"]
[null,"Midtrack down",{"$f":"AVERAGE('FP CMM DATA'!D11,'FP CMM DATA'!D13)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE('FP CMM DATA'!F11,'FP CMM DATA'!F13)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE('FP CMM DATA'!D10,'FP CMM DATA'!D12)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE('FP CMM DATA'!F10,'FP CMM DATA'!F12)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"IF(K6<C6,ATAN((L6-D6)/(C6-K6)),IF(K6>C6,PI()-ATAN((L6-D6)/(K6-C6)),PI()))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"C6+'FP CMM DATA'!L14","v":{"$error":"#DIV/0!"}},{"$f":"D6+'FP CMM DATA'!N14","v":{"$error":"#DIV/0!"}},"Midtrack down"]
[null,"Forward/Down",{"$f":"'FP CMM DATA'!D13","v":0},{"$f":"'FP CMM DATA'!F13","v":0},{"$f":"'FP CMM DATA'!D12","v":0},{"$f":"'FP CMM DATA'!F12","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"$I$6-$G$6+G7","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"IF(I7<PI()/2,C7-$H$14*COS(I7),IF(I7>PI()/2,C7+$H$14*COS(PI()-I7),C7))","v":{"$error":"#DIV/0!"}},{"$f":"IF(I7<PI()/2,D7+$H$14*SIN(I7),IF(I7>PI()/2,D7+$H$14*SIN(PI()-I7),D7+$H$14))","v":{"$error":"#DIV/0!"}},"Forward/Down"]
[null,"Forward/Up",{"$f":"'FP CMM DATA'!D15","v":0},{"$f":"'FP CMM DATA'!F15","v":0},{"$f":"'FP CMM DATA'!D14","v":0},{"$f":"'FP CMM DATA'!F14","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"$I$6-$G$6+G8","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"IF(I8<PI()/2,C8-$H$14*COS(I8),IF(I8>PI()/2,C8+$H$14*COS(PI()-I8),C8))","v":{"$error":"#DIV/0!"}},{"$f":"IF(I8<PI()/2,D8+$H$14*SIN(I8),IF(I8>PI()/2,D8+$H$14*SIN(PI()-I8),D8+$H$14))","v":{"$error":"#DIV/0!"}},"Forward/Up"]
[null,"Rear/Up",{"$f":"'FP CMM DATA'!D17","v":0},{"$f":"'FP CMM DATA'!F17","v":0},{"$f":"'FP CMM DATA'!D16","v":0},{"$f":"'FP CMM DATA'!F16","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"$I$6-$G$6+G9","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"IF(I9<PI()/2,C9-$H$14*COS(I9),IF(I9>PI()/2,C9+$H$14*COS(PI()-I9),C9))","v":{"$error":"#DIV/0!"}},{"$f":"IF(I9<PI()/2,D9+$H$14*SIN(I9),IF(I9>PI()/2,D9+$H$14*SIN(PI()-I9),D9+$H$14))","v":{"$error":"#DIV/0!"}},"Rear/Up"]
[null,"Rear/Down",{"$f":"C5","v":0},{"$f":"D5","v":0},{"$f":"E5","v":0},{"$f":"F5","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"$I$6-$G$6+G10","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"IF(I10<PI()/2,C10-$H$14*COS(I10),IF(I10>PI()/2,C10+$H$14*COS(PI()-I10),C10))","v":{"$error":"#DIV/0!"}},{"$f":"IF(I10<PI()/2,D10+$H$14*SIN(I10),IF(I10>PI()/2,D10+$H$14*SIN(PI()-I10),D10+$H$14))","v":{"$error":"#DIV/0!"}},"Rear/Down"]
[]
[]
[null,"Track Length","Horizontal Track Travel","Vertical Track Travel","Track Rise",null,"Vector","Length (mm)",null,null,"H-point Midheight Travel Path"]
[null,"(mm)","(mm)","(mm)","(degrees)",null,"H2",{"$f":"SQRT((K6-C6)^2+(L6-D6)^2)","v":{"$error":"#DIV/0!"}},null,null,null,"X (mm)","Z (mm)"]
[null,{"$f":"SQRT((C15)^2+(D15)^2)","v":0},{"$f":"C7-C5","v":0},{"$f":"D7-D5","v":0},{"$f":"DEGREES(ATAN(D15/C15))","v":{"$error":"#DIV/0!"}},null,null,null,null,null,"Front",{"$f":"K7","v":{"$error":"#DIV/0!"}},{"$f":"L7","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,"Rear",{"$f":"K10","v":{"$error":"#DIV/0!"}},{"$f":"L10","v":{"$error":"#DIV/0!"}}]
[]
[null,"Seat 1-Seat 2 angle",null,null,null,null,null,null,null,null,"Rear",{"$f":"C9-C10","v":0},{"$f":"D9-D10","v":0},{"$f":"E9-E10","v":0},{"$f":"F9-F10","v":0}]
[null,"Position","angle","difference",null,null,null,null,null,null,"Forward",{"$f":"C8-C7","v":0},{"$f":"D8-D7","v":0},{"$f":"E8-E7","v":0},{"$f":"F8-F7","v":0}]
[]
[null,"Rear/Down",{"$f":"DEGREES(ATAN(((D5-F5)/(C5-E5))))","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,"Seat Pt. 1 vertical travel range",{"$f":"AVERAGE(O18:O19)","v":0}]
[null,"Forward/Down",{"$f":"DEGREES(ATAN(((D7-F7)/(C7-E7))))","v":{"$error":"#DIV/0!"}},{"$f":"C22-C21","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,"Seat Pt. 2 vertical travel range",{"$f":"AVERAGE(M18:M19)","v":0}]
[null,"Forward/Up",{"$f":"DEGREES(ATAN(((D8-F8)/(C8-E8))))","v":{"$error":"#DIV/0!"}},{"$f":"C23-C21","v":{"$error":"#DIV/0!"}}]
[null,"Rear/Up",{"$f":"DEGREES(ATAN(((D9-F9)/(C9-E9))))","v":{"$error":"#DIV/0!"}},{"$f":"C24-C21","v":{"$error":"#DIV/0!"}}]
[null,"Rear/Down",{"$f":"DEGREES(ATAN(((D10-F10)/(C10-E10))))","v":{"$error":"#DIV/0!"}},{"$f":"C25-C21","v":{"$error":"#DIV/0!"}}]

{"sheet":"FP FINAL H-POINT & SEAT POS","index":5,"n_rows":19,"n_cols":6,"rows_kept":19,"cut":false,"hidden":true,"merged":[]}
[]
[null,"H-point Position",null,"X (mm)","Z (mm)"]
[null,"H-point Position at midtrack",null,{"$f":"'FP CMM DATA'!L13","v":0},{"$f":"'FP CMM DATA'!N13","v":0}]
[]
[null,"Torso Recline",null,"X (mm)","Y (mm)","Z (mm)"]
[null,null,"H-Point"]
[null,null,"Head CG"]
[]
[]
[null,null,"H-Point to CG angle",{"$f":"IF(F7=\"\",\"\",DEGREES(ATAN(-(D6-D7)/(F7-F6))))","v":""},"degrees"]
[]
[null,"Passenger Knee",null,"X (mm)","Y (mm)","Z (mm)"]
[null,null,"Passenger striker"]
[null,null,"Right knee"]
[]
[]
[null,"Final Position for Seat*",null,"X (mm)","Y (mm)","Z (mm)"]
[null,null,"Seat Pt. 1 Test Position"]
[null,null,"Seat Pt. 2 Test Position"]

{"sheet":"FP Clearance Measures","index":6,"n_rows":33,"n_cols":5,"rows_kept":33,"cut":false,"hidden":true,"merged":[[1,1,1,4],[2,3,2,4],[21,1,21,4],[22,3,22,4],[32,1,40,4]]}
[]
[null,"Hand Clearance Measurements"]
[null,"Location","Code","Measurement"]
[null,"Head to header","HH",null,{"$f":"IF(FP_HH=\"\",\"\",\"mm\")","v":""}]
[null,"Nose to center dash","ND",null,{"$f":"IF(FP_ND=\"\",\"\",\"mm\")","v":""}]
[null,"Chest to center dash, ref.","CD",null,{"$f":"IF(FP_CD=\"\",\"\",\"mm\")","v":""}]
[null,"Chest to dash, minimum","CDM",null,{"$f":"IF(FP_CDM=\"\",\"\",\"mm\")","v":""}]
[null,"Knee to dash, left","KDL",null,{"$f":"IF(FP_KDL=\"\",\"\",\"mm\")","v":""}]
[null,"Knee to dash, right","KDR",null,{"$f":"IF(FP_KDR=\"\",\"\",\"mm\")","v":""}]
[null,"Knee to knee","KK",null,{"$f":"IF(FP_KK=\"\",\"\",\"mm\")","v":""}]
[null,"Ankle to Ankle","AA",null,{"$f":"IF(FP_AA=\"\",\"\",\"mm\")","v":""}]
[null,"Arm to door","AD",null,{"$f":"IF(FP_AD=\"\",\"\",\"mm\")","v":""}]
[null,"H-point to door","HD",null,{"$f":"IF(FP_HD=\"\",\"\",\"mm\")","v":""}]
[null,"Head to A-pillar","HA",null,{"$f":"IF(FP_HA=\"\",\"\",\"mm\")","v":""}]
[null,"Head to roof","HR",null,{"$f":"IF(FP_HR=\"\",\"\",\"mm\")","v":""}]
[null,"Head to side window","HS",null,{"$f":"IF(FP_HS=\"\",\"\",\"mm\")","v":""}]
[null,"Pelvic angle","PA",null,{"$f":"IF(FP_PA=\"\",\"\",\"degrees\")","v":""}]
[null,"Seat back angle","SA",null,{"$f":"IF(FP_SA=\"\",\"\",\"degrees\")","v":""}]
[null,"Neck bracket angle","NBA",null,{"$f":"IF(FP_NBA=\"\",\"\",\"degrees\")","v":""}]
[null,"Neck angle, seated","NAS",null,{"$f":"IF(FP_NAS=\"\",\"\",\"degrees\")","v":""}]
[]
[null,"CMM Clearance Measurements"]
[null,"Location","Code","Measurement"]
[null,"Striker to head CG, horizontal ","CGH",{"$f":"IF('FP FINAL H-POINT & SEAT POS'!D7=\"\",\"\",ROUND(('FP FINAL H-POINT & SEAT POS'!D7-'FP FINAL H-POINT & SEAT POS'!D13),0))","v":""},{"$f":"IF(FP_CGH=\"\",\"\",\"mm\")","v":""}]
[null,"Striker to head CG, lateral ","CGL",{"$f":"IF('FP FINAL H-POINT & SEAT POS'!E7=\"\",\"\",ROUND(('FP FINAL H-POINT & SEAT POS'!E7-'FP FINAL H-POINT & SEAT POS'!E13),0))","v":""},{"$f":"IF(FP_CGL=\"\",\"\",\"mm\")","v":""}]
[null,"Striker to head CG, vertical ","CGV",{"$f":"IF('FP FINAL H-POINT & SEAT POS'!F7=\"\",\"\",ROUND('FP FINAL H-POINT & SEAT POS'!F7-'FP FINAL H-POINT & SEAT POS'!F13,0))","v":""},{"$f":"IF(FP_CGV=\"\",\"\",\"mm\")","v":""}]
[null,"Striker to H-point, horizontal","SHH",{"$f":"IF('FP FINAL H-POINT & SEAT POS'!D6=\"\",\"\",ROUND(('FP FINAL H-POINT & SEAT POS'!D6-'FP FINAL H-POINT & SEAT POS'!D13),0))","v":""},{"$f":"IF(FP_SHH=\"\",\"\",\"mm\")","v":""}]
[null,"Striker to H-point, vertical","SHV",{"$f":"IF('FP FINAL H-POINT & SEAT POS'!F6=\"\",\"\",ROUND(('FP FINAL H-POINT & SEAT POS'!F6-'FP FINAL H-POINT & SEAT POS'!F13),0))","v":""},{"$f":"IF(FP_SHV=\"\",\"\",\"mm\")","v":""}]
[null,"Striker to knee","SK",{"$f":"IF('FP FINAL H-POINT & SEAT POS'!D14=\"\",\"\",ROUND((('FP FINAL H-POINT & SEAT POS'!D13-'FP FINAL H-POINT & SEAT POS'!D14)^2+('FP FINAL H-POINT & SEAT POS'!F13-'FP FINAL H-POINT & SEAT POS'!F14)^2)^0.5,0))","v":""},{"$f":"IF(FP_SK=\"\",\"\",\"mm\")","v":""}]
[null,"Torso Recline Angle","TRA",{"$f":"IF('FP FINAL H-POINT & SEAT POS'!D10=\"\",\"\",ROUND('FP FINAL H-POINT & SEAT POS'!D10,1))","v":""},{"$f":"IF(FP_TRA=\"\",\"\",\"degrees\")","v":""}]
[null,"Striker to knee angle","SKA",{"$f":"IF('FP FINAL H-POINT & SEAT POS'!F14=\"\",\"\",ROUND(DEGREES(ATAN(('FP FINAL H-POINT & SEAT POS'!F14-'FP FINAL H-POINT & SEAT POS'!F13)/('FP FINAL H-POINT & SEAT POS'!D13-'FP FINAL H-POINT & SEAT POS'!D14))),1))","v":""},{"$f":"IF(FP_SKA=\"\",\"\",\"degrees\")","v":""}]
[]
[null,"Notes:"]

{"sheet":"SEAT INFORMATION","index":7,"n_rows":51,"n_cols":6,"rows_kept":51,"cut":false,"hidden":true,"merged":[[3,2,5,2],[12,1,12,4],[15,2,16,2]]}
[]
[null,null,null,null,null,"User Entered Data"]
[null,"Dummy ",null,null,null,"Calculated Data"]
[null,"(1) 5th percentile female"]
[null,"(2) 50th percentile male",null,{"$f":"IF(C4=1,\"\",IF(C4=2,\"\",IF(C4=3,\"\",\"Enter an integer (1, 2, or 3) for the dummy being used\")))","v":"Enter an integer (1, 2, or 3) for the dummy being used"}]
[null,"(3) 95th percentile male"]
[]
[null,"Seat Information"]
[null,"Adjustment type"]
[null,"Number of locking positions",null,{"$f":"IF(C10=\"N/A\",\"\",\"Verify the number of locking positions.\")","v":"Verify the number of locking positions."}]
[null,"Adjustment range (mm)",{"$f":"IF(C51=\"\",\"\",IF(C51=1,IF('CMM DATA A'!D13=\"\",\"\",'CMM DATA A'!D11-'CMM DATA A'!D13),IF(C51=2,IF('CMM DATA B'!D13=\"\",\"\",'CMM DATA B'!D11-'CMM DATA B'!D13),\"Error\")))","v":""},null," "]
[null,"Movement per notch (mm)",{"$f":"IF(C10=\"n/a\",\"n/a\",IF(C11=\"\",\"\",C11/(C10-1)))","v":""}]
[null,"The \"Adjustment Range\" and \"Movement per Notch\" values above will be correct only after the CMM DATA worksheet has been completed"]
[]
[null,"Accelerator Pedal Shape"]
[null,"(1) Flat"]
[null,"(2) Curved"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"General Information for Macros"]
[null,"Has macro been executed before; Yes =1"]
[null,"Calculation type; exact midtrack = 1, manual w/ even notches =2",{"$f":"IF(C10=\"\",\"\",IF(C10=\"N/A\",1,IF(MOD(C10,2)=1,1,2)))","v":""}]

{"sheet":"SEAT PAN ADJUSTMENT","index":8,"n_rows":37,"n_cols":5,"rows_kept":37,"cut":false,"hidden":true,"merged":[[8,1,8,9],[28,1,28,9],[1,1,1,9],[2,1,2,9],[4,1,4,9],[5,1,5,9],[6,1,6,9],[7,1,7,9],[36,1,36,9],[9,1,9,9],[18,1,18,9],[20,1,20,9],[22,1,22,9],[21,1,21,9]]}
[]
[null,"The following is taken from Step 4.2 in the Guidelines for Using the UMTRI ATD Positioning Procedure for ATD and Seat Positioning "]
[null,"If the seat pan cushion moves independently of the seat back and frame, it should be placed in its rearmost position.  If the seat pan also moves vertically independently of the seat back, adjust the seat pan to the appropriate position as described below:"]
[]
[null,"4.2 Define seat pan height adjustment range (if applicable)"]
[null,"4.2.1. If the seat also can be adjusted such that the seat pan cushion and seat back move together vertically, place the seat pan in the lowest vertical position."]
[null,"4.2.2. If the seat pan adjustment only tilts the front of the cushion upwards (i.e., if the seating height of an occupant would not change due to this adjustment), leave the tilt adjustment in the lowest position"]
[null,"4.2.3. If the seat does not have an additional adjustment feature that simultaneously moves the seat pan and seat back vertically, place the seat pan cushion in the middle of its vertical height adjustment range as follows ((the Seat Pan Adjustment worksheet can be used as an aid for setting the seat pan height):"]
[null,"4.2.4. Adjust the seat pan to its lowest position.  Locate and record the forwardmost point on the center of the leading edge of the seat cushion (seat pan point 1).  Locate and record a second point (seat pan point 2) 400 mm rearward of pan point 1 in the X-direction while keeping the Y-coordinate constant."]
[null," Record the coordinates of the two seat pan points in the cells below."]
[]
[null,null,"X (mm)","Y (mm)","Z (mm)"]
[null,"Seat pan point 1 (full down)"]
[null,"Seat pan point 2 (full down)"]
[]
[null,"Initial seat cushion angle (degrees)",{"$f":"IF(E14=\"\",\"\",DEGREES(ATAN((E13-E14)/(C14-C13))))","v":""}]
[]
[null,"4.2.5. Single control seat pan height"]
[null,"4.2.5.1. Raise the seat pan to its highest position and record seat pan point 2.  Lower the seat pan adjustment until seat pan point 2 is in the middle of its vertical adjustment range."]
[null,"4.2.6. Multiple control seat pan height"]
[null,"4.2.6.1. The seat cushion angle is established in step 4.2.4 "]
[null,"4.2.6.2. While leaving the front seat pan adjustment in its lowest position, adjust the rear seat pan to its highest vertical adjustment.  Record the coordinates of seat pan point 2.  Using the seat pan adjustment, lower seat pan point 2 to the middle of its vertical range (the target location is automatically calculated in the Seat Pan Adjustment worksheet)."]
[null,"Record the coordinates of seat pan point 2 in the cells below, then adjust seat pan point 2 to the calculated mid-height position."]
[]
[null,null,"X (mm)","Y (mm)","Z (mm)"]
[null,"Seat pan point 2 (full up)"]
[null,"Seat pan point 2 (mid height)",null,null,{"$f":"IF(E26=\"\",\"\",AVERAGE(E26,E14))","v":""}]
[]
[null,"4.2.6.3. Using only the front seat pan adjustment, move the seat pan upwards until the seat cushion angle matches the seat cushion angle that was measured in step 4.2.4.  If the front adjustment range is not large enough to achieve the seat cushion angle measured in step 4.2.4, place the front adjustment in the position that most closely matches the target seat location"]
[]
[null,"Final seat pan position","X (mm)","Y (mm)","Z (mm)"]
[null,"Seat pan point 1 (adjusted)"]
[null,"Seat pan point 2 (adjusted)"]
[]
[null,"Seat cushion angle (degrees)",{"$f":"IF(E33=\"\",\"\",DEGREES(ATAN((E32-E33)/(C33-C32))))","v":""}]
[]
[null,"Note: After completing step 4.1, a seat pan that moves independently of the seat back should not be moved for the remainder of the seating procedure.  From this point forward, all references to fore-aft and vertical seat movement refer to adjustments where the seat back and seat pan move together."]

{"sheet":"CMM DATA A","index":9,"n_rows":31,"n_cols":14,"rows_kept":31,"cut":false,"hidden":true,"merged":[[11,8,11,10],[25,0,25,5],[13,8,13,10]]}
[]
[null,null,null,null,null,null,null,null,"CMM Data","Coordinate system",null,"+X: towards rear of vehicle; +Z: upwards"]
[null,null,null,"X (mm)","Y (mm)","Z (mm)",null,null,"Calculated Data",null,null,"* The calculations used in this worksheet apply only to this coordinate system"]
[null,null,"Door striker*",null,null,null,null,null,null,{"$f":"IF(D13=\"\",\"\",IF(D11<D13,\"CHECK CMM ALIGNMENT TO MATCH COORDINATE SYSTEM ABOVE\",IF(F23>F8,\"\",\"CHECK CMM ALIGNMENT TO MATCH COORDINATE SYSTEM ABOVE\")))","v":""}]
[null,null,"Pedal (top)"]
[null,null,"Pedal (middle)"]
[null,null,"Pedal (bottom)",null,null,null,null,null,"Additional Measurements",null,null,"X (mm)","Y (mm)","Z (mm)"]
[null,null,"Heel Surface Pt. 1",null,null,null,null,null,null,null,"Seat Ref. Pt. 1 (calculated midtrack)",{"$f":"IF(D12=\"\",\"\",AVERAGE(D10,D12))","v":""},"",""]
[null,null,"Heel Surface Pt. 2",null,null,null,null,null,null,null,"Seat Ref. Pt. 2 (calculated midtrack)","","",""]
[null,null,"Seat Ref. Pt. 1, rear/down",null,null,null,null,null,null,null,"Seat Ref. Pt. 1 at midtrack/down"]
[null,null,"Seat Ref. Pt. 2, rear/down",null,null,null,null,null,null,null,"Seat Ref. Pt. 2 at midtrack/down"]
[null,null,"Seat Ref. Pt. 1 forward/down",null,null,null,null,null,"H-point at midtrack/down"]
[null,null,"Seat Ref. Pt. 2 forward/down",null,null,null,null,null,null,null,"H-point to Seat Ref. Pt. 2",{"$f":"IF(L12=\"\",\"\",L12-L11)","v":""},{"$f":"IF(M12=\"\",\"\",M12-M11)","v":""},{"$f":"IF(N12=\"\",\"\",N12-N11)","v":""}]
[null,null,"Seat Ref. Pt. 1 forward/up",null,null,null,null,null,"2nd H-point, verification"]
[null,null,"Seat Ref. Pt. 2 forward/up"]
[null,null,"Seat Ref. Pt. 1 rear/up"]
[null,null,"Seat Ref. Pt. 2 rear/up"]
[null,null,"Steering Wheel",{"$f":"IF('SEAT INFORMATION'!C4=1,\"Telescope position: full-forward\",\"Telescope position: mid-range\")","v":"Telescope position: mid-range"}]
[null,null,"Top (0 degrees)"]
[null,null,"Bottom (0 degrees)"]
[null,null,"Top (180 degrees)"]
[null,null,"Bottom (180 degrees)"]
[null,null,"Steering Wheel Center",{"$f":"IF(D22=\"\",\"\",AVERAGE(D19:D22))","v":""},{"$f":"IF(E22=\"\",\"\",AVERAGE(E19:E22))","v":""},{"$f":"IF(F22=\"\",\"\",AVERAGE(F19:F22))","v":""}]
[null,null,"PRP ",{"$f":"IF(F9=\"\",\"\",IF('SEAT INFORMATION'!C16=1,D25-200/((1+((F7-F5)/(D7-D5))^2)^0.5),pedalreferencepointx($D$5,$F$5,$D$6,$F$6,$D$7,$F$7,$D$8,$F$8,$D$9,$F$9 )))","v":""},null,{"$f":"IF(F9=\"\",\"\",IF('SEAT INFORMATION'!C16=1,((F7-F5)/(D7-D5))*D24+(F5-((F7-F5)/(D7-D5))*D5),pedalreferencepointz($D$5,$F$5,$D$6,$F$6,$D$7,$F$7,$D$8,$F$8,$D$9,$F$9)))","v":""}]
[null,null,"Heel Rest Point",{"$f":"IF(F9=\"\",\"\",IF('SEAT INFORMATION'!C16=1,((F5-(F7-F5)/(D7-D5)*D5)-(F8-((F9-F8)/(D9-D8))*D8))/(((F9-F8)/(D9-D8))-((F7-F5)/(D7-D5))),HeelRestSurfaceX($D$5,$F$5,$D$6,$F$6,$D$7,$F$7,$D$8,$F$8,$D$9,$F$9)))","v":""},null,{"$f":" IF(F9=\"\",\"\",IF('SEAT INFORMATION'!C16=1,((F9-F8)/(D9-D8))*(D25-D8)+F8,HeelRestSurfaceZ($D$5,$F$5,$D$6,$F$6,$D$7,$F$7,$D$8,$F$8,$D$9,$F$9)))","v":""}]
["* The door striker measurement is only used as a reference point and does not affect the UMTRI calculations"]
[]
[null,null,null,"X (mm)","Y (mm)","Z (mm)"]
[null,null,"Calibration Pt 1"]
[null,null,"Calibration Pt 2"]
[null,null,"Resultant",{"$f":"SQRT((D29-D30)^2+(E29-E30)^2+(F29-F30)^2)","v":0}]

{"sheet":"SEAT RANGE CALCULATIONS A","index":10,"n_rows":25,"n_cols":15,"rows_kept":25,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Position","Seat Pt. 2",null,"Seat Pt. 1",null,null,null,null,null,"H-point",null,"Position"]
[null,null,"X","Z","X","Z","a",null,"Q ",null,"X","Z"]
[null,null,"(mm)","(mm)","(mm)","(mm)","(radians)","(degrees)","(radians)","(degrees)","(mm)","(mm)"]
[null,"Rear/Down",{"$f":"'CMM DATA A'!D11","v":0},{"$f":"'CMM DATA A'!F11","v":0},{"$f":"'CMM DATA A'!D10","v":0},{"$f":"'CMM DATA A'!F10","v":0},{"$f":"(ATAN((F5-D5)/(C5-E5)))","v":{"$error":"#DIV/0!"}},{"$f":"DEGREES(G5)","v":{"$error":"#DIV/0!"}},{"$f":"$I$6-$G$6+G5","v":{"$error":"#DIV/0!"}},{"$f":"DEGREES(I5)","v":{"$error":"#DIV/0!"}},{"$f":"IF(I5<PI()/2,C5-$H$14*COS(I5),IF(I5>PI()/2,C5+$H$14*COS(PI()-I5),C5))","v":{"$error":"#DIV/0!"}},{"$f":"IF(I5<PI()/2,D5+$H$14*SIN(I5),IF(I5>PI()/2,D5+$H$14*SIN(PI()-I5),D5+$H$14))","v":{"$error":"#DIV/0!"}},"Rear/Down"]
[null,"Midtrack down",{"$f":"AVERAGE('CMM DATA A'!D11,'CMM DATA A'!D13)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE('CMM DATA A'!F11,'CMM DATA A'!F13)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE('CMM DATA A'!D10,'CMM DATA A'!D12)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE('CMM DATA A'!F10,'CMM DATA A'!F12)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"IF(K6<C6,ATAN((L6-D6)/(C6-K6)),IF(K6>C6,PI()-ATAN((L6-D6)/(K6-C6)),PI()))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"C6+'CMM DATA A'!L13","v":{"$error":"#DIV/0!"}},{"$f":"D6+'CMM DATA A'!N13","v":{"$error":"#DIV/0!"}},"Midtrack down"]
[null,"Forward/Down",{"$f":"'CMM DATA A'!D13","v":0},{"$f":"'CMM DATA A'!F13","v":0},{"$f":"'CMM DATA A'!D12","v":0},{"$f":"'CMM DATA A'!F12","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"$I$6-$G$6+G7","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"IF(I7<PI()/2,C7-$H$14*COS(I7),IF(I7>PI()/2,C7+$H$14*COS(PI()-I7),C7))","v":{"$error":"#DIV/0!"}},{"$f":"IF(I7<PI()/2,D7+$H$14*SIN(I7),IF(I7>PI()/2,D7+$H$14*SIN(PI()-I7),D7+$H$14))","v":{"$error":"#DIV/0!"}},"Forward/Down"]
[null,"Forward/Up",{"$f":"'CMM DATA A'!D15","v":0},{"$f":"'CMM DATA A'!F15","v":0},{"$f":"'CMM DATA A'!D14","v":0},{"$f":"'CMM DATA A'!F14","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"$I$6-$G$6+G8","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"IF(I8<PI()/2,C8-$H$14*COS(I8),IF(I8>PI()/2,C8+$H$14*COS(PI()-I8),C8))","v":{"$error":"#DIV/0!"}},{"$f":"IF(I8<PI()/2,D8+$H$14*SIN(I8),IF(I8>PI()/2,D8+$H$14*SIN(PI()-I8),D8+$H$14))","v":{"$error":"#DIV/0!"}},"Forward/Up"]
[null,"Rear/Up",{"$f":"'CMM DATA A'!D17","v":0},{"$f":"'CMM DATA A'!F17","v":0},{"$f":"'CMM DATA A'!D16","v":0},{"$f":"'CMM DATA A'!F16","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"$I$6-$G$6+G9","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"IF(I9<PI()/2,C9-$H$14*COS(I9),IF(I9>PI()/2,C9+$H$14*COS(PI()-I9),C9))","v":{"$error":"#DIV/0!"}},{"$f":"IF(I9<PI()/2,D9+$H$14*SIN(I9),IF(I9>PI()/2,D9+$H$14*SIN(PI()-I9),D9+$H$14))","v":{"$error":"#DIV/0!"}},"Rear/Up"]
[null,"Rear/Down",{"$f":"C5","v":0},{"$f":"D5","v":0},{"$f":"E5","v":0},{"$f":"F5","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"$I$6-$G$6+G10","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"IF(I10<PI()/2,C10-$H$14*COS(I10),IF(I10>PI()/2,C10+$H$14*COS(PI()-I10),C10))","v":{"$error":"#DIV/0!"}},{"$f":"IF(I10<PI()/2,D10+$H$14*SIN(I10),IF(I10>PI()/2,D10+$H$14*SIN(PI()-I10),D10+$H$14))","v":{"$error":"#DIV/0!"}},"Rear/Down"]
[]
[]
[null,"Track Length","Horizontal Track Travel","Vertical Track Travel","Track Rise",null,"Vector","Length (mm)",null,null,"H-point Midheight Travel Path"]
[null,"(mm)","(mm)","(mm)","(degrees)",null,"H2",{"$f":"SQRT((K6-C6)^2+(L6-D6)^2)","v":{"$error":"#DIV/0!"}},null,null,null,"X (mm)","Z (mm)"]
[null,{"$f":"SQRT((C15)^2+(D15)^2)","v":0},{"$f":"C7-C5","v":0},{"$f":"D7-D5","v":0},{"$f":"DEGREES(ATAN(D15/C15))","v":{"$error":"#DIV/0!"}},null,null,null,null,null,"Front",{"$f":"AVERAGE(K7:K8)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(L7:L8)","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,"Rear",{"$f":"AVERAGE(K9:K10)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(L9:L10)","v":{"$error":"#DIV/0!"}}]
[]
[null,"Seat 1-Seat 2 angle",null,null,null,null,null,null,null,null,"Rear",{"$f":"C9-C10","v":0},{"$f":"D9-D10","v":0},{"$f":"E9-E10","v":0},{"$f":"F9-F10","v":0}]
[null,"Position","angle","difference",null,null,null,null,null,null,"Forward",{"$f":"C8-C7","v":0},{"$f":"D8-D7","v":0},{"$f":"E8-E7","v":0},{"$f":"F8-F7","v":0}]
[]
[null,"Rear/Down",{"$f":"DEGREES(ATAN(((D5-F5)/(C5-E5))))","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,"Seat Pt. 1 vertical travel range",{"$f":"AVERAGE(O18:O19)","v":0}]
[null,"Forward/Down",{"$f":"DEGREES(ATAN(((D7-F7)/(C7-E7))))","v":{"$error":"#DIV/0!"}},{"$f":"C22-C21","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,"Seat Pt. 2 vertical travel range",{"$f":"AVERAGE(M18:M19)","v":0}]
[null,"Forward/Up",{"$f":"DEGREES(ATAN(((D8-F8)/(C8-E8))))","v":{"$error":"#DIV/0!"}},{"$f":"C23-C21","v":{"$error":"#DIV/0!"}}]
[null,"Rear/Up",{"$f":"DEGREES(ATAN(((D9-F9)/(C9-E9))))","v":{"$error":"#DIV/0!"}},{"$f":"C24-C21","v":{"$error":"#DIV/0!"}}]
[null,"Rear/Down",{"$f":"DEGREES(ATAN(((D10-F10)/(C10-E10))))","v":{"$error":"#DIV/0!"}},{"$f":"C25-C21","v":{"$error":"#DIV/0!"}}]

{"sheet":"UMTRI CALCULATIONS A","index":11,"n_rows":78,"n_cols":12,"rows_kept":78,"cut":false,"hidden":true,"merged":[[28,7,28,8],[33,1,33,2],[27,2,27,5],[28,2,28,3],[28,4,28,5],[28,1,31,1]]}
[]
[null,"All coordinates are expressed with respect to"]
[null,"Horizontal","X","Pedal Reference Point (PRP)"]
[null,"Vertical","Z","Heel Surface (AHP-Z)"]
[]
[null,"Reference Points","Symbol","X (mm)","Z (mm)"]
[null,"Heel Surface Z","AHP",null,0]
[null,"Pedal Reference Point","PRP",0,{"$f":"('CMM DATA A'!F24-'CMM DATA A'!F25)","v":{"$error":"#VALUE!"}}]
[null,"Rear Upper H-point","HPtRU",{"$f":"('SEAT RANGE CALCULATIONS A'!K9-'CMM DATA A'!D24)","v":{"$error":"#DIV/0!"}},{"$f":"('SEAT RANGE CALCULATIONS A'!L9-'CMM DATA A'!F25)","v":{"$error":"#DIV/0!"}}]
[null,"Rear Lower H-point","HPtRL",{"$f":"('SEAT RANGE CALCULATIONS A'!K10-'CMM DATA A'!D24)","v":{"$error":"#DIV/0!"}},{"$f":"('SEAT RANGE CALCULATIONS A'!L10-'CMM DATA A'!F25)","v":{"$error":"#DIV/0!"}}]
[]
[null,"Front Upper H-point","HPtFU",{"$f":"('SEAT RANGE CALCULATIONS A'!K8-'CMM DATA A'!D24)","v":{"$error":"#DIV/0!"}},{"$f":"('SEAT RANGE CALCULATIONS A'!L8-'CMM DATA A'!F25)","v":{"$error":"#DIV/0!"}}]
[null,"Front Lower H-point","HPtFL",{"$f":"('SEAT RANGE CALCULATIONS A'!K7-'CMM DATA A'!D24)","v":{"$error":"#DIV/0!"}},{"$f":"('SEAT RANGE CALCULATIONS A'!L7-'CMM DATA A'!F25)","v":{"$error":"#DIV/0!"}}]
[null,"Steering Wheel Center","SWX",{"$f":"('CMM DATA A'!D23-'CMM DATA A'!D24)","v":{"$error":"#VALUE!"}},{"$f":"('CMM DATA A'!F23-'CMM DATA A'!F25)","v":{"$error":"#VALUE!"}}]
[]
[null,"Calculated Values",null,"X (mm)","Z (mm)"]
[null,"Rear  Mid-Height H-point ","HPtR",{"$f":"(D10+D9)/2","v":{"$error":"#DIV/0!"}},{"$f":"(E10+E9)/2","v":{"$error":"#DIV/0!"}}]
[null,"Front Mid-Height H-point","HPtF",{"$f":"(D13+D12)/2","v":{"$error":"#DIV/0!"}},{"$f":"(E13+E12)/2","v":{"$error":"#DIV/0!"}}]
[null,"Slope (∆Z/∆X)","r",{"$f":"(HPtFZ-HPtRZ)/(HPtRX-HPtFX)","v":{"$error":"#DIV/0!"}}]
[null,"Track Angle (deg)",null,{"$f":"DEGREES(ATAN(D19))","v":{"$error":"#DIV/0!"}}]
[]
[null,"ATD Reference Stature ","(mm)"]
[null,"small female",1511]
[null,"midsize male",1753]
[null,"large male",1870]
[null,"Stature of ATD being used",{"$f":"IF('SEAT INFORMATION'!C4:C4=1,'UMTRI CALCULATIONS A'!C23,IF('SEAT INFORMATION'!C4:C4=2,'UMTRI CALCULATIONS A'!C24,IF('SEAT INFORMATION'!C4=3,'UMTRI CALCULATIONS A'!C25,\"Enter integer for dummy size into the SEAT INFORMATION worksheet\")))","v":"Enter integer for dummy size into the SEAT INFORMATION worksheet"}]
[]
[null,null,"UMTRI H-point Position"]
[null,{"$f":"IF('SEAT INFORMATION'!C4:C4=1,'UMTRI CALCULATIONS A'!B23,IF('SEAT INFORMATION'!C4:C4=2,'UMTRI CALCULATIONS A'!B24,IF('SEAT INFORMATION'!C4=3,'UMTRI CALCULATIONS A'!B25,\"Enter correct value for dummy size into the SEAT INFORMATION worksheet\")))","v":"Enter correct value for dummy size into the SEAT INFORMATION worksheet"},"Reference: UMTRI coordinates",null,"Reference: Vehicle-based coordinates",null,null,"Adjusted H-Point",null,null,{"$f":"IF(E32=H31,\"\",\"Uncensored UMTRI H-point Position\")","v":{"$error":"#VALUE!"}}]
[null,null,"Aft of PRP","Above Heel Surface","(user-defined coordinate system)",null,null,"X (mm)","Z (mm)",null,"X (mm)","Z (mm)"]
[null,null,"X (mm)","Z (mm)","X (mm)","Z (mm)",null,{"$f":"'FINAL H-POINT & SEAT POSITION A'!D17","v":""},{"$f":"'FINAL H-POINT & SEAT POSITION A'!E17","v":""},null,{"$f":"IF(E32=H31,0,E32)","v":{"$error":"#VALUE!"}},{"$f":"IF(F32=I31,0,F32)","v":{"$error":"#VALUE!"}}]
[null,null,{"$f":"-15+0.433*C26+0.41*D14-0.24/(1-0.3943*D19)*(HPtRZ+D19*(HPtRX-1054))","v":{"$error":"#VALUE!"}},{"$f":"HPtRZ+ $D$19 *(HPtRX-C32)","v":{"$error":"#DIV/0!"}},{"$f":"C32+'CMM DATA A'!$D$24","v":{"$error":"#VALUE!"}},{"$f":"'CMM DATA A'!$F$25+D32","v":{"$error":"#VALUE!"}}]
[]
[null,"Seat Adjustment required to move the seat into the UMTRI Position"]
[null,"Aft of Midtrack*","Above Midtrack Full-down*"]
[null,"(mm)","(mm)"]
[null,{"$f":"E32-'CMM DATA A'!$L$12","v":{"$error":"#VALUE!"}},{"$f":"F32-'CMM DATA A'!$N$12","v":{"$error":"#VALUE!"}}]
[null,"*This is the position from which H-point was originally measured."]
[null,"Seat Point 2 should be moved by this amount."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"IF(B29=B23, B75, IF(B29=B24,B76,IF(B29=B25,B77,B78)))","v":"Enter occupant size into Seat Information worksheet"}]
[null,"UMTRI H-point (small female)"]
[null,"UMTRI H-point (midsize male)"]
[null,"UMTRI H-point (large male)"]
[null,"Enter occupant size into Seat Information worksheet"]

{"sheet":"FINAL H-POINT & SEAT POSITION A","index":12,"n_rows":48,"n_cols":7,"rows_kept":48,"cut":false,"hidden":true,"merged":[[7,1,7,4],[10,6,11,6]]}
[null,"Occupant size:",{"$f":"'UMTRI CALCULATIONS A'!B29","v":"Enter correct value for dummy size into the SEAT INFORMATION worksheet"}]
[]
[null,"Seat information"]
[null,null,"Number of locking positions",{"$f":"IF('SEAT INFORMATION'!C10=\"\",\"\",'SEAT INFORMATION'!C10)","v":""}]
[null,null,"Adjustment range (mm)",{"$f":"'SEAT INFORMATION'!C11","v":""}]
[null,null,"Movement per notch (mm)",{"$f":"IF(D4=\"n/a\",\"n/a\",'SEAT INFORMATION'!C12)","v":""}]
[null,null,"Number of notches to UMTRI position from midtrack*",{"$f":"IF(D6=\"\",\"\",IF(D6=\"N/A\",D6,'UMTRI CALCULATIONS A'!B37/'FINAL H-POINT & SEAT POSITION A'!D6))","v":""}]
[null,"* This is only an esitmate.  Seats should be placed in the the position that most closely matches the UMTRI calculated positions for Reference Points 1 and 2 (shown below).  Positive numbers indicate rearward seat movement."]
[]
[null,"UMTRI Position for Seat",null,"X (mm)","Y (mm)","Z (mm)"]
[null,null,"Seat Pt. 1 (ideal UMTRI location)",{"$f":"IF('CMM DATA A'!L13=\"\",\"\",C47)","v":""},null,{"$f":"IF('CMM DATA A'!L13=\"\",\"\",D47)","v":""},{"$f":"IF('CMM DATA A'!L13=\"\",\"\",IF(AND(C46=0,D46=0),\"\",\"‡\"))","v":""}]
[null,null,"Seat Pt. 2 (ideal UMTRI location)",{"$f":"IF('CMM DATA A'!L13=\"\",\"\",C48)","v":""},null,{"$f":"IF('CMM DATA A'!L13=\"\",\"\",D48)","v":""}]
[null,null,"Seat Pt. 1 UMTRI Position"]
[null,null,"Seat Pt. 2 UMTRI Position"]
[]
[null,"H-point Position",null,"X (mm)","Z (mm)"]
[null,"UMTRI Calculated H-point Position for",{"$f":"'UMTRI CALCULATIONS A'!B29","v":"Enter correct value for dummy size into the SEAT INFORMATION worksheet"},{"$f":"IF('CMM DATA A'!L13=\"\",\"\",IF((('CMM DATA A'!L12+'UMTRI CALCULATIONS A'!B37)>'SEAT RANGE CALCULATIONS A'!L16),'SEAT RANGE CALCULATIONS A'!L16,IF((('CMM DATA A'!L12+'UMTRI CALCULATIONS A'!B37)<'SEAT RANGE CALCULATIONS A'!L15),'SEAT RANGE CALCULATIONS A'!L15,'CMM DATA A'!L12+'UMTRI CALCULATIONS A'!B37)))","v":""},{"$f":"IF('CMM DATA A'!L13=\"\",\"\",IF((D17='SEAT RANGE CALCULATIONS A'!L15),'SEAT RANGE CALCULATIONS A'!M15,IF((D17='SEAT RANGE CALCULATIONS A'!L16),'SEAT RANGE CALCULATIONS A'!M16,'CMM DATA A'!N12+'UMTRI CALCULATIONS A'!C37)))","v":""},{"$f":"IF('CMM DATA A'!L13=\"\",\"\",IF(D17='UMTRI CALCULATIONS A'!E32,\"\",\"†\"))","v":""}]
[]
[null,"Torso Recline",null,"X (mm)","Y (mm)","Z (mm)"]
[null,null,"H-Point"]
[null,null,"Head CG"]
[]
[]
[null,null,"H-Point to CG angle*",{"$f":"IF(F21=\"\",\"\",DEGREES(ATAN(-(D20-D21)/(F21-F20))))","v":""},"degrees"]
[null,null,null,"* Set to 12 degrees +/- 1 degree"]
[]
[]
[null,"Final UMTRI Position for Seat*",null,"X (mm)","Y (mm)","Z (mm)"]
[null,null,"Seat Pt. 1 Test Position"]
[null,null,"Seat Pt. 2 Test Position"]
[null,"*Final seat position may differ from UMTRI position shown above if seat is moved forward to allow for accelerator pedal overlap"]
[]
[]
[]
[null,"Cells below are protected"]
[null,{"$f":"IF('CMM DATA A'!L13=\"\",\"\",IF(D17='UMTRI CALCULATIONS A'!E32,\"\",\"† H-point position has been adjusted to a location that is within the actual movement of the seat\"))","v":""}]
[null,null,null,{"$f":"IF('CMM DATA A'!L13=\"\",\"\",IF(D17='UMTRI CALCULATIONS A'!E32,\"\",\"X (mm)\"))","v":""},{"$f":"IF('CMM DATA A'!L13=\"\",\"\",IF(D17='UMTRI CALCULATIONS A'!E32,\"\",\"Z (mm)\"))","v":""}]
[null,null,{"$f":"IF('CMM DATA A'!L13=\"\",\"\",IF(D17='UMTRI CALCULATIONS A'!E32,\"\",\"Original H-point position\"))","v":""},{"$f":"IF('CMM DATA A'!L13=\"\",\"\",IF(D17='UMTRI CALCULATIONS A'!E32,\"\",'UMTRI CALCULATIONS A'!E32))","v":""},{"$f":"IF('CMM DATA A'!L13=\"\",\"\",IF(D17='UMTRI CALCULATIONS A'!E32,\"\",'UMTRI CALCULATIONS A'!F32))","v":""}]
[]
[null,{"$f":"IF('CMM DATA A'!L13=\"\",\"\",IF(AND(C46=0,D46=0),\"\",\"‡ Seat Points 1 and 2 have been adjusted by the same amount as the H-point\"))","v":""}]
[null,null,null,{"$f":"IF('CMM DATA A'!L13=\"\",\"\",IF(AND(C46=0,D46=0),\"\",\"X (mm)\"))","v":""},{"$f":"IF('CMM DATA A'!L13=\"\",\"\",IF(AND(C46=0,D46=0),\"\",\"Z (mm)\"))","v":""}]
[null,null,{"$f":"IF('CMM DATA A'!L13=\"\",\"\",IF(AND(C46=0,D46=0),\"\",\"Original Seat Point 1\"))","v":""},{"$f":"IF('CMM DATA A'!L13=\"\",\"\",IF(AND(C46=0,D46=0),\"\",'SEAT RANGE CALCULATIONS A'!E6+'UMTRI CALCULATIONS A'!B37))","v":""},{"$f":"IF('CMM DATA A'!L13=\"\",\"\",IF(AND(C46=0,D46=0),\"\",'SEAT RANGE CALCULATIONS A'!F6+'UMTRI CALCULATIONS A'!C37))","v":""}]
[null,null,{"$f":"IF('CMM DATA A'!L13=\"\",\"\",IF(AND(C46=0,D46=0),\"\",\"Original Seat Point 2\"))","v":""},{"$f":"IF('CMM DATA A'!L13=\"\",\"\",IF(AND(C46=0,D46=0),\"\",'SEAT RANGE CALCULATIONS A'!C6+'UMTRI CALCULATIONS A'!B37))","v":""},{"$f":"IF('CMM DATA A'!L13=\"\",\"\",IF(AND(C46=0,D46=0),\"\",'SEAT RANGE CALCULATIONS A'!D6+'UMTRI CALCULATIONS A'!C37))","v":""}]
[]
[null,null,"X (mm)","Z (mm)"]
[null,"New Offset",{"$f":"IF('CMM DATA A'!L13=\"\",\"\",IF((D17='UMTRI CALCULATIONS A'!E32),0,'UMTRI CALCULATIONS A'!E32-'FINAL H-POINT & SEAT POSITION A'!D17))","v":""},{"$f":"IF('CMM DATA A'!L13=\"\",\"\",IF((E17='UMTRI CALCULATIONS A'!F32),0,'UMTRI CALCULATIONS A'!F32-'FINAL H-POINT & SEAT POSITION A'!E17))","v":""}]
[null,"New Point 1 Coord.",{"$f":"IF('CMM DATA A'!L13=\"\",\"\",'SEAT RANGE CALCULATIONS A'!E6+'UMTRI CALCULATIONS A'!B37-C46)","v":""},{"$f":"IF('CMM DATA A'!L13=\"\",\"\",'SEAT RANGE CALCULATIONS A'!F6+'UMTRI CALCULATIONS A'!C37-D46)","v":""}]
[null,"New Point 2 Coord.",{"$f":"IF('CMM DATA A'!L13=\"\",\"\",'SEAT RANGE CALCULATIONS A'!C6+'UMTRI CALCULATIONS A'!B37-C46)","v":""},{"$f":"IF('CMM DATA A'!L13=\"\",\"\",'SEAT RANGE CALCULATIONS A'!D6+'UMTRI CALCULATIONS A'!C37-D46)","v":""}]

{"sheet":"CMM DATA B","index":14,"n_rows":47,"n_cols":14,"rows_kept":47,"cut":false,"hidden":true,"merged":[[25,0,26,6],[18,8,18,13],[17,8,17,10],[13,8,13,9],[12,8,12,9],[16,8,16,9],[15,8,15,9],[14,8,14,9]]}
[]
[null,null,null,null,null,null,null,null,"CMM Data","Coordinate system: +X: towards rear of vehicle; +Z: upwards"]
[null,null,null,"X (mm)","Y (mm)","Z (mm)",null,null,"Calculated Data","* The calculations used in this worksheet apply only to this coordinate system"]
[null,null,"Door striker*",null,null,null,null,null,null,{"$f":"IF(D13=\"\",\"\",IF(D11<D13,\"CHECK CMM ALIGNMENT TO MATCH COORDINATE SYSTEM ABOVE\",IF(F23>F25,\"\",\"CHECK CMM ALIGNMENT TO MATCH COORDINATE SYSTEM ABOVE\")))","v":""}]
[null,null,"Pedal (top)"]
[null,null,"Pedal (middle)"]
[null,null,"Pedal (bottom)"]
[null,null,"Heel Surface Pt. 1"]
[null,null,"Heel Surface Pt. 2"]
[null,null,"Seat Ref. Pt. 1, rear/down"]
[null,null,"Seat Ref. Pt. 2, rear/down"]
[null,null,"Seat Ref. Pt. 1 forward/down",null,null,null,null,null,"Additional Measurements",null,null,"X (mm)","Y (mm)","Z (mm)"]
[null,null,"Seat Ref. Pt. 2 forward/down",null,null,null,null,null,"Seat Ref. Pt. 1 forward of initial seat position; notch",null,{"$f":"'SEAT INFORMATION'!$C$10/2","v":0}]
[null,null,"Seat Ref. Pt. 1 forward/up",null,null,null,null,null,"Seat Ref. Pt. 2 forward of initial seat position; notch",null,{"$f":"'SEAT INFORMATION'!$C$10/2","v":0}]
[null,null,"Seat Ref. Pt. 2 forward/up",null,null,null,null,null,"Seat Ref. Pt. 1 at initial seat position; notch",null,{"$f":"'SEAT INFORMATION'!$C$10/2+1","v":1}]
[null,null,"Seat Ref. Pt. 1 rear/up",null,null,null,null,null,"Seat Ref. Pt. 2 at initial seat position; notch",null,{"$f":"'SEAT INFORMATION'!$C$10/2+1","v":1}]
[null,null,"Seat Ref. Pt. 2 rear/up",null,null,null,null,null,"H-point at initial seat position; notch",null,{"$f":"'SEAT INFORMATION'!$C$10/2+1","v":1}]
[null,null,"Steering Wheel",{"$f":"IF('SEAT INFORMATION'!C4=1,\"Telescope position: full-forward\",\"Telescope position: mid-range\")","v":"Telescope position: mid-range"},null,null,null,null,"H-point to Seat Ref. Pt. 2",null,null,{"$f":"IF(L17=\"\",\"\",L17-L16)","v":""},{"$f":"IF(M17=\"\",\"\",M17-M16)","v":""},{"$f":"IF(N17=\"\",\"\",N17-N16)","v":""}]
[null,null,"Top (0 degrees)",null,null,null,null,null,{"$f":"IF(L14=\"\",\"\",IF(ABS((AVERAGE(L16,L14)-AVERAGE(D11,D13)))>2,\"Midpoint Discrepancy.  Check the number of locking positions and initial seat position\",\"\"))","v":""}]
[null,null,"Bottom (0 degrees)",null,null,null,null,null,"* Notch 1 is the forwardmost locking fore/aft seat position"]
[null,null,"Top (180 degrees)"]
[null,null,"Bottom (180 degrees)"]
[null,null,"Steering Wheel Center",{"$f":"IF(D22=\"\",\"\",AVERAGE(D19:D22))","v":""},{"$f":"IF(E22=\"\",\"\",AVERAGE(E19:E22))","v":""},{"$f":"IF(F22=\"\",\"\",AVERAGE(F19:F22))","v":""}]
[null,null,"PRP ",{"$f":"IF(F9=\"\",\"\",IF('SEAT INFORMATION'!C16=1,D25-200/((1+((F7-F5)/(D7-D5))^2)^0.5),pedalreferencepointx($D$5,$F$5,$D$6,$F$6,$D$7,$F$7,$D$8,$F$8,$D$9,$F$9 )))","v":""},null,{"$f":"IF(F9=\"\",\"\",IF('SEAT INFORMATION'!C16=1,((F7-F5)/(D7-D5))*D24+(F5-((F7-F5)/(D7-D5))*D5),pedalreferencepointz($D$5,$F$5,$D$6,$F$6,$D$7,$F$7,$D$8,$F$8,$D$9,$F$9)))","v":""}]
[null,null,"Heel Surface",{"$f":"IF(F9=\"\",\"\",IF('SEAT INFORMATION'!C16=1,((F5-(F7-F5)/(D7-D5)*D5)-(F8-((F9-F8)/(D9-D8))*D8))/(((F9-F8)/(D9-D8))-((F7-F5)/(D7-D5))),HeelRestSurfaceX($D$5,$F$5,$D$6,$F$6,$D$7,$F$7,$D$8,$F$8,$D$9,$F$9)))","v":""},null,{"$f":" IF(F9=\"\",\"\",IF('SEAT INFORMATION'!C16=1,((F9-F8)/(D9-D8))*(D25-D8)+F8,HeelRestSurfaceZ($D$5,$F$5,$D$6,$F$6,$D$7,$F$7,$D$8,$F$8,$D$9,$F$9)))","v":""}]
["* The door striker measurement is only used as a reference point and does not affect the UMTRI calculations"]
[]
[]
[null,null,null,"X (mm)","Y (mm)","Z (mm)"]
[null,null,"Calibration Pt 1"]
[null,null,"Calibration Pt 2",null,null,null,null," "]
[null,null,"Resultant",{"$f":"SQRT((D30-D31)^2+(E30-E31)^2+(F30-F31)^2)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null," "]

{"sheet":"SEAT RANGE CALCULATIONS B","index":15,"n_rows":25,"n_cols":15,"rows_kept":25,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Position","Seat Pt. 2",null,"Seat Pt. 1",null,null,null,null,null,"H-point",null,"Position"]
[null,null,"X","Z","X","Z","a",null,"Q ",null,"X","Z"]
[null,null,"(mm)","(mm)","(mm)","(mm)","(radians)","(degrees)","(radians)","(degrees)","(mm)","(mm)"]
[null,"Rear/Down",{"$f":"'CMM DATA B'!D11","v":0},{"$f":"'CMM DATA B'!F11","v":0},{"$f":"'CMM DATA B'!D10","v":0},{"$f":"'CMM DATA B'!F10","v":0},{"$f":"(ATAN((F5-D5)/(C5-E5)))","v":{"$error":"#DIV/0!"}},{"$f":"DEGREES(G5)","v":{"$error":"#DIV/0!"}},{"$f":"$I$6-$G$6+G5","v":{"$error":"#DIV/0!"}},{"$f":"DEGREES(I5)","v":{"$error":"#DIV/0!"}},{"$f":"IF(I5<PI()/2,C5-$H$14*COS(I5),IF(I5>PI()/2,C5+$H$14*COS(PI()-I5),C5))","v":{"$error":"#DIV/0!"}},{"$f":"IF(I5<PI()/2,D5+$H$14*SIN(I5),IF(I5>PI()/2,D5+$H$14*SIN(PI()-I5),D5+$H$14))","v":{"$error":"#DIV/0!"}},"Rear/Down"]
[null,"Midtrack down",{"$f":"AVERAGE('CMM DATA B'!D11,'CMM DATA B'!D13)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE('CMM DATA B'!F11,'CMM DATA B'!F13)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE('CMM DATA B'!D10,'CMM DATA B'!D12)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE('CMM DATA B'!F10,'CMM DATA B'!F12)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"IF(K6<C6,ATAN((L6-D6)/(C6-K6)),IF(K6>C6,PI()-ATAN((L6-D6)/(K6-C6)),PI()))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"C6+'CMM DATA B'!L18","v":{"$error":"#DIV/0!"}},{"$f":"D6+'CMM DATA B'!N18","v":{"$error":"#DIV/0!"}},"Midtrack down"]
[null,"Forward/Down",{"$f":"'CMM DATA B'!D13","v":0},{"$f":"'CMM DATA B'!F13","v":0},{"$f":"'CMM DATA B'!D12","v":0},{"$f":"'CMM DATA B'!F12","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"$I$6-$G$6+G7","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"IF(I7<PI()/2,C7-$H$14*COS(I7),IF(I7>PI()/2,C7+$H$14*COS(PI()-I7),C7))","v":{"$error":"#DIV/0!"}},{"$f":"IF(I7<PI()/2,D7+$H$14*SIN(I7),IF(I7>PI()/2,D7+$H$14*SIN(PI()-I7),D7+$H$14))","v":{"$error":"#DIV/0!"}},"Forward/Down"]
[null,"Forward/Up",{"$f":"'CMM DATA B'!D15","v":0},{"$f":"'CMM DATA B'!F15","v":0},{"$f":"'CMM DATA B'!D14","v":0},{"$f":"'CMM DATA B'!F14","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"$I$6-$G$6+G8","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"IF(I8<PI()/2,C8-$H$14*COS(I8),IF(I8>PI()/2,C8+$H$14*COS(PI()-I8),C8))","v":{"$error":"#DIV/0!"}},{"$f":"IF(I8<PI()/2,D8+$H$14*SIN(I8),IF(I8>PI()/2,D8+$H$14*SIN(PI()-I8),D8+$H$14))","v":{"$error":"#DIV/0!"}},"Forward/Up"]
[null,"Rear/Up",{"$f":"'CMM DATA B'!D17","v":0},{"$f":"'CMM DATA B'!F17","v":0},{"$f":"'CMM DATA B'!D16","v":0},{"$f":"'CMM DATA B'!F16","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"$I$6-$G$6+G9","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"IF(I9<PI()/2,C9-$H$14*COS(I9),IF(I9>PI()/2,C9+$H$14*COS(PI()-I9),C9))","v":{"$error":"#DIV/0!"}},{"$f":"IF(I9<PI()/2,D9+$H$14*SIN(I9),IF(I9>PI()/2,D9+$H$14*SIN(PI()-I9),D9+$H$14))","v":{"$error":"#DIV/0!"}},"Rear/Up"]
[null,"Rear/Down",{"$f":"C5","v":0},{"$f":"D5","v":0},{"$f":"E5","v":0},{"$f":"F5","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"$I$6-$G$6+G10","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"IF(I10<PI()/2,C10-$H$14*COS(I10),IF(I10>PI()/2,C10+$H$14*COS(PI()-I10),C10))","v":{"$error":"#DIV/0!"}},{"$f":"IF(I10<PI()/2,D10+$H$14*SIN(I10),IF(I10>PI()/2,D10+$H$14*SIN(PI()-I10),D10+$H$14))","v":{"$error":"#DIV/0!"}},"Rear/Down"]
[]
[]
[null,"Track Length","Horizontal Track Travel","Vertical Track Travel","Track Rise",null,"Vector","Length (mm)",null,null,"H-point Midheight Travel Path"]
[null,"(mm)","(mm)","(mm)","(degrees)",null,"H2",{"$f":"SQRT((K6-C6)^2+(L6-D6)^2)","v":{"$error":"#DIV/0!"}},null,null,null,"X (mm)","Z (mm)"]
[null,{"$f":"SQRT((C15)^2+(D15)^2)","v":0},{"$f":"C7-C5","v":0},{"$f":"D7-D5","v":0},{"$f":"DEGREES(ATAN(D15/C15))","v":{"$error":"#DIV/0!"}},null,null,null,null,null,"Front",{"$f":"AVERAGE(K7:K8)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(L7:L8)","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,"Rear",{"$f":"AVERAGE(K9:K10)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(L9:L10)","v":{"$error":"#DIV/0!"}}]
[]
[null,"Seat 1-Seat 2 angle",null,null,null,null,null,null,null,null,"Rear",{"$f":"C9-C10","v":0},{"$f":"D9-D10","v":0},{"$f":"E9-E10","v":0},{"$f":"F9-F10","v":0}]
[null,"Position","angle","difference",null,null,null,null,null,null,"Forward",{"$f":"C8-C7","v":0},{"$f":"D8-D7","v":0},{"$f":"E8-E7","v":0},{"$f":"F8-F7","v":0}]
[]
[null,"Rear/Down",{"$f":"DEGREES(ATAN(((D5-F5)/(C5-E5))))","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,"Seat Pt. 1 vertical travel range (mm)",{"$f":"AVERAGE(O18:O19)","v":0}]
[null,"Forward/Down",{"$f":"DEGREES(ATAN(((D7-F7)/(C7-E7))))","v":{"$error":"#DIV/0!"}},{"$f":"C22-C21","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,"Seat Pt. 2 vertical travel range (mm)",{"$f":"AVERAGE(M18:M19)","v":0}]
[null,"Forward/Up",{"$f":"DEGREES(ATAN(((D8-F8)/(C8-E8))))","v":{"$error":"#DIV/0!"}},{"$f":"C23-C21","v":{"$error":"#DIV/0!"}}]
[null,"Rear/Up",{"$f":"DEGREES(ATAN(((D9-F9)/(C9-E9))))","v":{"$error":"#DIV/0!"}},{"$f":"C24-C21","v":{"$error":"#DIV/0!"}}]
[null,"Rear/Down",{"$f":"DEGREES(ATAN(((D10-F10)/(C10-E10))))","v":{"$error":"#DIV/0!"}},{"$f":"C25-C21","v":{"$error":"#DIV/0!"}}]

{"sheet":"UMTRI CALCULATIONS B","index":16,"n_rows":78,"n_cols":9,"rows_kept":78,"cut":false,"hidden":true,"merged":[[27,2,27,5],[33,1,33,2],[28,1,31,1],[28,7,28,8]]}
[]
[null,"All coordinates are expressed with respect to"]
[null,"Horizontal","X","Pedal Reference Point (PRP)"]
[null,"Vertical","Z","Heel Surface (AHP-Z)"]
[]
[null,"Reference Points","Symbol","X (mm)","Z (mm)"]
[null,"Heel Surface Z","AHP",null,0]
[null,"Pedal Reference Point","PRP",0,{"$f":"('CMM DATA B'!F24-'CMM DATA B'!F25)","v":{"$error":"#VALUE!"}}]
[null,"Rear Upper H-point","HPtRU",{"$f":"('SEAT RANGE CALCULATIONS B'!K9-'CMM DATA B'!D24)","v":{"$error":"#DIV/0!"}},{"$f":"('SEAT RANGE CALCULATIONS B'!L9-'CMM DATA B'!F25)","v":{"$error":"#DIV/0!"}}]
[null,"Rear Lower H-point","HPtRL",{"$f":"('SEAT RANGE CALCULATIONS B'!K10-'CMM DATA B'!D24)","v":{"$error":"#DIV/0!"}},{"$f":"('SEAT RANGE CALCULATIONS B'!L10-'CMM DATA B'!F25)","v":{"$error":"#DIV/0!"}}]
[]
[null,"Front Upper H-point","HPtFU",{"$f":"('SEAT RANGE CALCULATIONS B'!K8-'CMM DATA B'!D24)","v":{"$error":"#DIV/0!"}},{"$f":"('SEAT RANGE CALCULATIONS B'!L8-'CMM DATA B'!F25)","v":{"$error":"#DIV/0!"}}]
[null,"Front Lower H-point","HPtFL",{"$f":"('SEAT RANGE CALCULATIONS B'!K7-'CMM DATA B'!D24)","v":{"$error":"#DIV/0!"}},{"$f":"('SEAT RANGE CALCULATIONS B'!L7-'CMM DATA B'!F25)","v":{"$error":"#DIV/0!"}}]
[null,"Steering Wheel Center","SWX",{"$f":"('CMM DATA B'!D23-'CMM DATA B'!D24)","v":{"$error":"#VALUE!"}},{"$f":"('CMM DATA B'!F23-'CMM DATA B'!F25)","v":{"$error":"#VALUE!"}}]
[]
[null,"Calculated Values",null,"X (mm)","Z (mm)"]
[null,"Rear  Mid-Height H-point ","HPtR",{"$f":"(D10+D9)/2","v":{"$error":"#DIV/0!"}},{"$f":"(E10+E9)/2","v":{"$error":"#DIV/0!"}}]
[null,"Front Mid-Height H-point","HPtF",{"$f":"(D13+D12)/2","v":{"$error":"#DIV/0!"}},{"$f":"(E13+E12)/2","v":{"$error":"#DIV/0!"}}]
[null,"Slope (∆Z/∆X)","r",{"$f":"(HPtFZ-HPtRZ)/(HPtRX-HPtFX)","v":{"$error":"#DIV/0!"}}]
[null,"Track Angle (deg)",null,{"$f":"DEGREES(ATAN(D19))","v":{"$error":"#DIV/0!"}}]
[]
[null,"ATD Reference Stature ","(mm)"]
[null,"small female",1511]
[null,"midsize male",1753]
[null,"large male",1870]
[null,"Stature of ATD being used",{"$f":"IF('SEAT INFORMATION'!C4:C4=1,'UMTRI CALCULATIONS B'!C23,IF('SEAT INFORMATION'!C4:C4=2,'UMTRI CALCULATIONS B'!C24,IF('SEAT INFORMATION'!C4=3,'UMTRI CALCULATIONS B'!C25,\"Enter integer for dummy size into the SEAT INFORMATION worksheet\")))","v":"Enter integer for dummy size into the SEAT INFORMATION worksheet"}]
[]
[null,null,"UMTRI H-point Position"]
[null,{"$f":"IF('SEAT INFORMATION'!C4:C4=1,'UMTRI CALCULATIONS B'!B23,IF('SEAT INFORMATION'!C4:C4=2,'UMTRI CALCULATIONS B'!B24,IF('SEAT INFORMATION'!C4=3,'UMTRI CALCULATIONS B'!B25,\"Enter correct value for dummy size into the SEAT INFORMATION worksheet\")))","v":"Enter correct value for dummy size into the SEAT INFORMATION worksheet"},"Reference: UMTRI coordinates",null,"Reference: Vehicle-based coordinates",null,null,"Adjusted H-Point"]
[null,null,"Aft of PRP","Above Heel Surface","(user-defined coordinate system)",null,null,"X (mm)","Z (mm)"]
[null,null,"X (mm)","Z (mm)","X (mm)","Z (mm)",null,{"$f":"'FINAL H-POINT & SEAT POSITION B'!D17","v":""},{"$f":"'FINAL H-POINT & SEAT POSITION B'!E17","v":""}]
[null,null,{"$f":"-15+0.433*C26+0.41*D14-0.24/(1-0.3943*D19)*(HPtRZ+D19*(HPtRX-1054))","v":{"$error":"#VALUE!"}},{"$f":"HPtRZ+ $D$19 *(HPtRX-C32)","v":{"$error":"#DIV/0!"}},{"$f":"'CMM DATA B'!$D$24+ C32","v":{"$error":"#VALUE!"}},{"$f":"'CMM DATA B'!$F$25+D32","v":{"$error":"#VALUE!"}}]
[]
[null,"Seat Adjustment required to move the seat into the UMTRI Position"]
[null,"Aft of Midtrack*","Above Midtrack Full-down*"]
[null,"(mm)","(mm)"]
[null,{"$f":"E32-'CMM DATA B'!$L$17","v":{"$error":"#VALUE!"}},{"$f":"F32-'CMM DATA B'!$N$17","v":{"$error":"#VALUE!"}}]
[null,"*This is the position from which H-point was originally measured."]
[null,"Seat Point 2 should be moved by this amount."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"IF(B29=B23, B75, IF(B29=B24,B76,IF(B29=B25,B77,B78)))","v":"Enter occupant size into Seat Information worksheet"}]
[null,"UMTRI H-point (small female)"]
[null,"UMTRI H-point (midsize male)"]
[null,"UMTRI H-point (large male)"]
[null,"Enter occupant size into Seat Information worksheet"]

{"sheet":"FINAL H-POINT & SEAT POSITION B","index":17,"n_rows":48,"n_cols":7,"rows_kept":48,"cut":false,"hidden":true,"merged":[[7,1,7,4],[10,6,11,6]]}
[null,"Occupant size:",{"$f":"'UMTRI CALCULATIONS B'!B29","v":"Enter correct value for dummy size into the SEAT INFORMATION worksheet"}]
[]
[null,"Seat information"]
[null,null,"Number of locking positions",{"$f":"IF('SEAT INFORMATION'!C10=\"\",\"\",'SEAT INFORMATION'!C10)","v":""}]
[null,null,"Adjustment range (mm)",{"$f":"'SEAT INFORMATION'!C11","v":""}]
[null,null,"Movement per notch (mm)",{"$f":"'SEAT INFORMATION'!C12","v":""}]
[null,null,"Number of notches to UMTRI position from midtrack*",{"$f":"IF(D6=\"\",\"\",IF(D6=\"N/A\",D6,'UMTRI CALCULATIONS B'!B37/'FINAL H-POINT & SEAT POSITION A'!D6))","v":""}]
[null,"* This is only an esitmate.  Seats should be placed in the the position that most closely matches the UMTRI calculated positions for Reference Points 1 and 2 (shown below).  Positive numbers indicate rearward seat movement"]
[]
[null,"UMTRI Position for Seat",null,"X (mm)","Y (mm)","Z (mm)"]
[null,null,"Seat Reference Pt. 1 (ideal UMTRI location)",{"$f":"IF('CMM DATA B'!L13=\"\",\"\",C47)","v":""},null,{"$f":"IF('CMM DATA B'!L13=\"\",\"\",D47)","v":""},{"$f":"IF('CMM DATA B'!L13=\"\",\"\",IF(AND(C46=0,D46=0),\"\",\"‡\"))","v":""}]
[null,null,"Seat Reference Pt. 2 (ideal UMTRI location)",{"$f":"IF('CMM DATA B'!L13=\"\",\"\",C48)","v":""},null,{"$f":"IF('CMM DATA B'!L13=\"\",\"\",D48)","v":""}]
[null,null,"Seat Pt. 1 UMTRI Position"]
[null,null,"Seat Pt. 2 UMTRI Position"]
[]
[null,"H-point Position",null,"X (mm)","Z (mm)"]
[null,"UMTRI H-point Position for",{"$f":"'UMTRI CALCULATIONS B'!B29","v":"Enter correct value for dummy size into the SEAT INFORMATION worksheet"},{"$f":"IF('CMM DATA B'!L13=\"\",\"\",IF((('CMM DATA B'!L17+'UMTRI CALCULATIONS B'!B37)>'SEAT RANGE CALCULATIONS B'!L16),'SEAT RANGE CALCULATIONS B'!L16,IF((('CMM DATA B'!L17+'UMTRI CALCULATIONS B'!B37)<'SEAT RANGE CALCULATIONS B'!L15),'SEAT RANGE CALCULATIONS B'!L15,'CMM DATA B'!L17+'UMTRI CALCULATIONS B'!B37)))","v":""},{"$f":"IF('CMM DATA B'!L13=\"\",\"\",IF((D17='SEAT RANGE CALCULATIONS B'!L15),'SEAT RANGE CALCULATIONS B'!M15,IF((D17='SEAT RANGE CALCULATIONS B'!L16),'SEAT RANGE CALCULATIONS B'!M16,'CMM DATA B'!N17+'UMTRI CALCULATIONS B'!C37)))","v":""},{"$f":"IF('CMM DATA B'!L13=\"\",\"\",IF(D17='UMTRI CALCULATIONS B'!E32,\"\",\"†\"))","v":""}]
[]
[null,"Torso Recline",null,"X (mm)","Y (mm)","Z (mm)"]
[null,null,"H-Point"]
[null,null,"Head CG"]
[]
[]
[null,null,"H-Point to CG angle*",{"$f":"IF(D21=\"\",\"\",DEGREES(ATAN(-(D20-D21)/(F21-F20))))","v":""},"degrees"]
[null,null,null,"* Set to 12 degrees +/- 1 degree"]
[]
[]
[null,"Final UMTRI Position for Seat*",null,"X (mm)","Y (mm)","Z (mm)"]
[null,null,"Seat Pt. 1 Test Position"]
[null,null,"Seat Pt. 2 Test Position"]
[null,"*Final seat position may differ from UMTRI position shown above if seat is moved forward to allow for accelerator pedal overlap"]
[]
[]
[]
[null,"Cells below are protected"]
[null,{"$f":"IF('CMM DATA B'!L13=\"\",\"\",IF(D17='UMTRI CALCULATIONS B'!E32,\"\",\"† H-point position has been adjusted to a location that is within the actual movement of the seat\"))","v":""}]
[null,null,null,{"$f":"IF('CMM DATA B'!L13=\"\",\"\",IF(D17='UMTRI CALCULATIONS B'!E32,\"\",\"X (mm)\"))","v":""},{"$f":"IF('CMM DATA B'!L13=\"\",\"\",IF(D17='UMTRI CALCULATIONS B'!E32,\"\",\"Z (mm)\"))","v":""}]
[null,null,{"$f":"IF('CMM DATA B'!L13=\"\",\"\",IF(D17='UMTRI CALCULATIONS B'!E32,\"\",\"Original H-point position\"))","v":""},{"$f":"IF('CMM DATA B'!L13=\"\",\"\",IF(D17='UMTRI CALCULATIONS B'!E32,\"\",'UMTRI CALCULATIONS B'!E32))","v":""},{"$f":"IF('CMM DATA B'!L13=\"\",\"\",IF(D17='UMTRI CALCULATIONS B'!E32,\"\",'UMTRI CALCULATIONS B'!F32))","v":""}]
[]
[null,{"$f":"IF('CMM DATA B'!L13=\"\",\"\",IF(AND(C46=0,D46=0),\"\",\"‡ Seat Points 1 and 2 have been adjusted by the same amount as the H-point\"))","v":""}]
[null,null,null,{"$f":"IF('CMM DATA B'!L13=\"\",\"\",IF(AND(C46=0,D46=0),\"\",\"X (mm)\"))","v":""},{"$f":"IF('CMM DATA B'!L13=\"\",\"\",IF(AND(C46=0,D46=0),\"\",\"Z (mm)\"))","v":""}]
[null,null,{"$f":"IF('CMM DATA B'!L13=\"\",\"\",IF(AND(C46=0,D46=0),\"\",\"Original Seat Point 1\"))","v":""},{"$f":"IF('CMM DATA B'!L13=\"\",\"\",IF(AND(C46=0,D46=0),\"\",'SEAT RANGE CALCULATIONS B'!E6+'UMTRI CALCULATIONS B'!B37))","v":""},{"$f":"IF('CMM DATA B'!L13=\"\",\"\",IF(AND(C46=0,D46=0),\"\",'SEAT RANGE CALCULATIONS B'!F6+'UMTRI CALCULATIONS B'!C37))","v":""}]
[null,null,{"$f":"IF('CMM DATA B'!L13=\"\",\"\",IF(AND(C46=0,D46=0),\"\",\"Original Seat Point 2\"))","v":""},{"$f":"IF('CMM DATA B'!L13=\"\",\"\",IF(AND(C46=0,D46=0),\"\",'SEAT RANGE CALCULATIONS B'!C6+'UMTRI CALCULATIONS B'!B37))","v":""},{"$f":"IF('CMM DATA B'!L13=\"\",\"\",IF(AND(C46=0,D46=0),\"\",'SEAT RANGE CALCULATIONS B'!D6+'UMTRI CALCULATIONS B'!C37))","v":""}]
[]
[null,null,"X (mm)","Z (mm)"]
[null,"New Offset",{"$f":"IF('CMM DATA B'!L13=\"\",\"\",IF((D17='UMTRI CALCULATIONS B'!E32),0,'UMTRI CALCULATIONS B'!E32-'FINAL H-POINT & SEAT POSITION B'!D17))","v":""},{"$f":"IF('CMM DATA B'!L13=\"\",\"\",IF((E17='UMTRI CALCULATIONS B'!F32),0,'UMTRI CALCULATIONS B'!F32-'FINAL H-POINT & SEAT POSITION B'!E17))","v":""}]
[null,"New Point 1 Coord.",{"$f":"IF('CMM DATA B'!L13=\"\",\"\",'CMM DATA B'!L15+'UMTRI CALCULATIONS B'!B37-C46)","v":""},{"$f":"IF('CMM DATA B'!L13=\"\",\"\",'CMM DATA B'!N15+'UMTRI CALCULATIONS B'!C37-D46)","v":""}]
[null,"New Point 2 Coord.",{"$f":"IF('CMM DATA B'!L13=\"\",\"\",'CMM DATA B'!L16+'UMTRI CALCULATIONS B'!B37-C46)","v":""},{"$f":"IF('CMM DATA B'!L13=\"\",\"\",'CMM DATA B'!N16+'UMTRI CALCULATIONS B'!C37-D46)","v":""}]

{"sheet":"Excursion calculations","index":19,"n_rows":74,"n_cols":16,"rows_kept":74,"cut":false,"hidden":true,"merged":[[0,0,0,3],[20,0,20,3],[50,0,50,3]]}
["Finding seat back \"hinge\" point"]
[null,"X (mm)","Y (mm)","Z (mm)"]
["Point 1",{"$f":"'Additional Measures'!C16","v":0},{"$f":"'Additional Measures'!D16","v":0},{"$f":"'Additional Measures'!E16","v":0}]
["Point 1 with seat reclined",{"$f":"'Additional Measures'!C18","v":0},{"$f":"'Additional Measures'!D18","v":0},{"$f":"'Additional Measures'!E18","v":0}]
["mid pt",{"$f":"AVERAGE(B3:B4)","v":0},null,{"$f":"AVERAGE(D3:D4)","v":0}]
["inverse slope",{"$f":"-1/((D4-D3)/(B4-B3))","v":{"$error":"#DIV/0!"}}]
["y intercept",{"$f":"D5-B6*B5","v":{"$error":"#DIV/0!"}}]
[]
["Point 2",{"$f":"'Additional Measures'!C17","v":0},{"$f":"'Additional Measures'!D17","v":0},{"$f":"'Additional Measures'!E17","v":0}]
["Point 2 with seat reclined",{"$f":"'Additional Measures'!C19","v":0},{"$f":"'Additional Measures'!D19","v":0},{"$f":"'Additional Measures'!E19","v":0}]
["mid pt",{"$f":"AVERAGE(B9:B10)","v":0},null,{"$f":"AVERAGE(D9:D10)","v":0}]
["inverse slope",{"$f":"-1/((D10-D9)/(B10-B9))","v":{"$error":"#DIV/0!"}}]
["y intercept",{"$f":"D11-B12*B11","v":{"$error":"#DIV/0!"}}]
[]
["Calculated hinge point",{"$f":"(B13-B7)/(B6-B12)","v":{"$error":"#DIV/0!"}},null,{"$f":"B6*B15+B7","v":{"$error":"#DIV/0!"}}]
[]
["Seat pan movement after hinge point calculated?",{"$f":"Excursion!C3","v":0},null,{"$f":"Excursion!D3","v":0}]
["Hinge point at test",{"$f":"B15+B17","v":{"$error":"#DIV/0!"}},null,{"$f":"D15+D17","v":{"$error":"#DIV/0!"}}]
[]
[]
["Finding seatback deflection at time of max dummy excursion"]
[null,"X (mm)","Y (mm)","Z (mm)"]
["Outboard pot attachment to driver seatback",{"$f":"'Additional Occupant Measures'!C8","v":0},{"$f":"'Additional Occupant Measures'!D8","v":0},{"$f":"'Additional Occupant Measures'!E8","v":0}]
["Outboard pot cable at sensor housing",{"$f":"'Additional Occupant Measures'!C6","v":0},{"$f":"'Additional Occupant Measures'!D6","v":0},{"$f":"'Additional Occupant Measures'!E6","v":0},null,null,null,"Circle definitions for chart"]
["Inboard pot attachment to driver seatback",{"$f":"'Additional Occupant Measures'!C7","v":0},{"$f":"'Additional Occupant Measures'!D7","v":0},{"$f":"'Additional Occupant Measures'!E7","v":0},null,null,null,"Degrees","Seat Back OB X","Seat back OB Z","Seat back IB X","Seat back IB Z","OB pot X","OB pot Z","IB pot X","IB pot Z"]
["Inboard pot cable at sensor housing",{"$f":"'Additional Occupant Measures'!C5","v":0},{"$f":"'Additional Occupant Measures'!D5","v":0},{"$f":"'Additional Occupant Measures'!E5","v":0},null,null,null,0,{"$f":"B18","v":{"$error":"#DIV/0!"}},{"$f":"$D$18+SQRT($B$30^2-($B$18-I26)^2)","v":{"$error":"#DIV/0!"}},{"$f":"B18","v":{"$error":"#DIV/0!"}},{"$f":"$D$18+SQRT($B$40^2-($B$18-I26)^2)","v":{"$error":"#DIV/0!"}},{"$f":"B24","v":0},{"$f":"D24+B33","v":0},{"$f":"B26","v":0},{"$f":"D26+B43","v":0}]
["Outboard pot pull-out at time of maximum dummy excursion",{"$f":"Excursion!C17","v":0},null,null,null,null,null,{"$f":"H26+9","v":9},{"$f":"$I$26+($B$30*SIN(RADIANS(H27)))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"$I$26+($B$40*SIN(RADIANS(H27)))","v":{"$error":"#DIV/0!"}},{"$f":"$D$18+SQRT($B$40^2-($B$18-K27)^2)","v":{"$error":"#DIV/0!"}},{"$f":"$B$24-SQRT($B$33^2-($D$24-N27)^2)","v":0},{"$f":"$N$26-$B$33*SIN(RADIANS(H27))","v":0},{"$f":"$B$26-SQRT($B$43^2-($D$26-P27)^2)","v":0},{"$f":"$P$26-$B$43*SIN(RADIANS(H27))","v":0}]
["Inboard pot pull-out at time of maximum dummy excursion",{"$f":"Excursion!C16","v":0},null,null,null,null,null,{"$f":"H27+9","v":18},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,0,0,0]
[null,null,null,null,null,null,null,{"$f":"H28+9","v":27},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,0,0,0]
["Radius from seatback hinge point to outboard pot attachment",{"$f":"SQRT((B23-B18)^2+(D23-D18)^2)","v":{"$error":"#DIV/0!"}},null,null,null,null,null,36,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,0,0,0]
["Outboard pot pretest length",{"$f":"((B23-B24)^2+(C23-C24)^2+(D23-D24)^2)^0.5","v":0},null,null,null,null,null,45,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,0,0,0]
["Outboard pot length with pull-out",{"$f":"B27+B31","v":0},null,null,null,null,null,54,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,0,0,0]
["Outboard pot length with pull-out, excluding lateral component",{"$f":"SQRT(B32^2-(C23-C24)^2)","v":0},null,null,null,null,null,63,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,0,0,0]
["Distance from outboard pot housing to hinge point",{"$f":"SQRT((B24-B18)^2+(D24-D18)^2)","v":{"$error":"#DIV/0!"}},null,null,null,null,null,72,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,0,0,0]
["Distance from hinge point to line joining circumference intersections",{"$f":"ABS((B30^2-B33^2+B34^2)/(2*B34))","v":{"$error":"#DIV/0!"}},null,null,null,null,null,81,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,0,0,0]
["Coordinates of outboard pot attachment at max excursion",{"$f":"B18+B35/SQRT(1+((D24-D18)/(B24-B18))^2)-SQRT((B30^2-B35^2)/(1+1/((D24-D18)/(B24-B18))^2))","v":{"$error":"#DIV/0!"}},null,{"$f":"SQRT(B30^2-(B36-B18)^2)+D18","v":{"$error":"#DIV/0!"}},null,null,null,90,{"$error":"#DIV/0!"},{"$f":"D18","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"D18","v":{"$error":"#DIV/0!"}},0,0,0,0]
["Seat movement at outboard pot attachment",{"$f":"B36-B23","v":{"$error":"#DIV/0!"}},null,{"$f":"D36-D23","v":{"$error":"#DIV/0!"}},null,null,null,99,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,0,{"$f":"$N$36-$B$33*(1-SIN(RADIANS(H37)))","v":0},0,{"$f":"$P$36-$B$43*(1-SIN(RADIANS(H37)))","v":0}]
["Seatback deflection angle at outboard pot attachment",{"$f":"SIGN(B27)*DEGREES(ASIN(((B37^2+D37^2)^0.5/2)/B30))*2","v":{"$error":"#DIV/0!"}},"deg",null,null,null,null,108,null,null,null,null,0,{"$f":"$N$36-$B$33*(1-SIN(RADIANS(H38)))","v":0},0,{"$f":"$P$36-$B$43*(1-SIN(RADIANS(H38)))","v":0}]
[null,null,null,null,null,null,null,117,null,null,null,null,0,{"$f":"$N$36-$B$33*(1-SIN(RADIANS(H39)))","v":0},0,{"$f":"$P$36-$B$43*(1-SIN(RADIANS(H39)))","v":0}]
["Radius from seatback hinge point to inboard pot attachment",{"$f":"SQRT((B25-B18)^2+(D25-D18)^2)","v":{"$error":"#DIV/0!"}},null,null,null,null,null,126,null,null,null,null,0,{"$f":"$N$36-$B$33*(1-SIN(RADIANS(H40)))","v":0},0,{"$f":"$P$36-$B$43*(1-SIN(RADIANS(H40)))","v":0}]
["Inboard pot pretest length",{"$f":"((B25-B26)^2+(C25-C26)^2+(D25-D26)^2)^0.5","v":0},null,null,null,null,null,135,null,null,null,null,0,{"$f":"$N$36-$B$33*(1-SIN(RADIANS(H41)))","v":0},0,{"$f":"$P$36-$B$43*(1-SIN(RADIANS(H41)))","v":0}]
["Inboard pot length with pull-out",{"$f":"B28+B41","v":0}]
["Inboard pot length with pull-out, excluding lateral component",{"$f":"SQRT(B42^2-(C25-C26)^2)","v":0}]
["Distance from inboard pot housing to hinge point",{"$f":"SQRT((B26-B18)^2+(D26-D18)^2)","v":{"$error":"#DIV/0!"}}]
["Distance from hinge point to line joining circumference intersections",{"$f":"ABS((B40^2-B43^2+B44^2)/(2*B44))","v":{"$error":"#DIV/0!"}}]
["Coordinates of outboard pot attachment at max excursion",{"$f":"B18+B45/SQRT(1+((D26-D18)/(B26-B18))^2)-SQRT((B40^2-B45^2)/(1+1/((D26-D18)/(B26-B18))^2))","v":{"$error":"#DIV/0!"}},null,{"$f":"SQRT(B40^2-(B46-B18)^2)+D18","v":{"$error":"#DIV/0!"}}]
["Seat movement at inboard pot attachment",{"$f":"B46-B25","v":{"$error":"#DIV/0!"}},null,{"$f":"D46-D25","v":{"$error":"#DIV/0!"}}]
["Seatback deflection angle at inboard pot attachment",{"$f":"SIGN(B28)*DEGREES(ASIN(((B47^2+D47^2)^0.5/2)/B40))*2","v":{"$error":"#DIV/0!"}},"deg"]
[]
[]
["Finding overall dummy excursion"]
[null,"X (mm)","Y (mm)","Z (mm)",null,null,null,"Circle definitions for chart"]
["Tape attachment bracket on dummy",{"$f":"'Additional Occupant Measures'!C11","v":0},{"$f":"'Additional Occupant Measures'!D11","v":0},{"$f":"'Additional Occupant Measures'!E11","v":0},null,null,null,"Degrees","OB Y left","OB X top","IB Y left","IB X top","IB X bottom","OB X bottom","OB Y right"]
["Outboard tape at seatback",{"$f":"'Additional Occupant Measures'!C10","v":0},{"$f":"'Additional Occupant Measures'!D10","v":0},{"$f":"'Additional Occupant Measures'!E10","v":0},null,null,null,0,{"$f":"C67-B69","v":{"$error":"#DIV/0!"}},{"$f":"B67","v":{"$error":"#DIV/0!"}},{"$f":"C68-B70","v":{"$error":"#DIV/0!"}},{"$f":"B68","v":{"$error":"#DIV/0!"}},{"$f":"B68","v":{"$error":"#DIV/0!"}},{"$f":"B67","v":{"$error":"#DIV/0!"}},{"$f":"C67+B69","v":{"$error":"#DIV/0!"}}]
["Inboard tape at seatback",{"$f":"'Additional Occupant Measures'!C9","v":0},{"$f":"'Additional Occupant Measures'!D9","v":0},{"$f":"'Additional Occupant Measures'!E9","v":0},null,null,null,{"$f":"H54+9","v":9},{"$f":"$I$54+($B$69-$B$69*COS(RADIANS(H55)))","v":{"$error":"#DIV/0!"}},{"$f":"$J$54-SQRT($B$69^2-($C$67-I55)^2)","v":{"$error":"#DIV/0!"}},{"$f":"$K$54+($B$70-$B$70*COS(RADIANS(H55)))","v":{"$error":"#DIV/0!"}},{"$f":"$L$54-SQRT($B$70^2-($C$68-K55)^2)","v":{"$error":"#DIV/0!"}},{"$f":"$L$54+SQRT($B$70^2-($C$68-K55)^2)","v":{"$error":"#DIV/0!"}},{"$f":"$J$54+SQRT($B$69^2-($C$67-I55)^2)","v":{"$error":"#DIV/0!"}},{"$f":"$O$54-($B$69-$B$69*COS(RADIANS(H55)))","v":{"$error":"#DIV/0!"}}]
["Outboard tape test pull-out",{"$f":"Excursion!C12*10","v":0},null,null,null,null,null,{"$f":"H55+9","v":18},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["Inboard tape test pull-out",{"$f":"Excursion!C8*10","v":0},null,null,null,null,null,27,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,36,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["Radius from hinge point to outboard tape",{"$f":"SQRT((B54-B18)^2+(D54-D18)^2)","v":{"$error":"#DIV/0!"}},null,null,null,null,null,45,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["Radius from hinge point to inboard tape",{"$f":"SQRT((B55-B18)^2+(D55-D18)^2)","v":{"$error":"#DIV/0!"}},null,null,null,null,null,54,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["Seatback deflection angle at outboard tape lateral coordinate",{"$f":"((B38-B48)/(C23-C25))*(C54-C23)+B38","v":{"$error":"#DIV/0!"}},"deg",null,null,null,null,63,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["Seatback deflection angle at inboard tape lateral coordinate",{"$f":"((B38-B48)/(C23-C25))*(C55-C25)+B48","v":{"$error":"#DIV/0!"}},"deg",null,null,null,null,72,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["Outboard tape pretest length",{"$f":"((B53-B54)^2+(C53-C54)^2+(D53-D54)^2)^0.5","v":0},null,null,null,null,null,81,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["Outboard tape length with pull-out",{"$f":"B56+B63","v":0},null,null,null,null,null,90,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["Inboard tape pretest length",{"$f":"((B53-B55)^2+(C53-C55)^2+(D53-D55)^2)^0.5","v":0},null,null,null,null,null,99,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["Inboard tape length with pull-out",{"$f":"B57+B65","v":0},null,null,null,null,null,108,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["Outboard tape at seatback, deflected",{"$f":"B18+B59*COS(ATAN((D54-D18)/(B54-B18))+RADIANS(B61))","v":{"$error":"#DIV/0!"}},{"$f":"C54","v":0},{"$f":"D18+SQRT(B59^2-(B18-B67)^2)","v":{"$error":"#DIV/0!"}},null,null,null,117,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["Inboard tape at seatback, deflected",{"$f":"B18+B60*COS(ATAN((D55-D18)/(B55-B18))+RADIANS(B62))","v":{"$error":"#DIV/0!"}},{"$f":"C55","v":0},{"$f":"D18+SQRT(B60^2-(B18-B68)^2)","v":{"$error":"#DIV/0!"}},null,null,null,126,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["Outboard tape length with pull-out, excluding vertical component",{"$f":"SQRT(B64^2-(D53-D67)^2)","v":{"$error":"#DIV/0!"}},null,null,null,null,null,135,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["Inboard tape length with pull-out, excluding vertical component",{"$f":"SQRT(B66^2-(D53-D68)^2)","v":{"$error":"#DIV/0!"}},null,null,null,null,null,144,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["Distance from outboard tape to inboard tape seat points",{"$f":"SQRT((B67-B68)^2+(C67-C68)^2)","v":{"$error":"#DIV/0!"}},null,null,null,null,null,153,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["Distance from outboard tape to line joining circumference intersections",{"$f":"(B70^2-B69^2-B71^2)/(2*B71)","v":{"$error":"#DIV/0!"}},null,null,null,null,null,162,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["Coordinates of dummy bracket at max excursion",{"$f":"-1*B69*SIN(ASIN(B72/B69)+(PI()/2-ATAN((B68-B67)/(C68-C67))))+B67","v":{"$error":"#DIV/0!"}},{"$f":"B69*COS(ASIN(B72/B69)+(PI()/2-ATAN((B68-B67)/(C68-C67))))+C67","v":{"$error":"#DIV/0!"}},null,null,null,null,171,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["Excursion",{"$f":"B53-B73","v":{"$error":"#DIV/0!"}},{"$f":"C53-C73","v":{"$error":"#DIV/0!"}},null,null,null,null,{"$f":"H73+8.9","v":179.9},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]

{"sheet":"Additional Occupant Measures","index":20,"n_rows":64,"n_cols":6,"rows_kept":64,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Driver","X (mm)","Y (mm)","Z (mm)"]
[null,"Front door striker"]
[null,"Driver knee"]
[null,"Pot cable at housing (inboard)"]
[null,"Pot cable at housing (outboard)"]
[null,"Pot attachment to seat (inboard)"]
[null,"Pot attachment to seat (outboard)"]
[null,"Pull string at seat (inboard)"]
[null,"Pull string at seat (outboard)"]
[null,"Pull string attachment bracket on dummy"]
[null,"Nose"]
[null,"Chin"]
[null,"Clavicle access, L"]
[null,"Clavicle access, R"]
[null,"Belt upper edge, chest CL 1"]
[null,"Belt upper edge, chest CL 2"]
[null,"Belt upper edge, chest CL 3"]
[null,"Belt upper edge at D-ring"]
[null,"HR Post"]
[]
[null,"Rear passenger","X (mm)","Y (mm)","Z (mm)"]
[null,"Rear door striker face"]
[null,"Passenger h-point"]
[null,"Passenger head CG"]
[null,"Passenger knee"]
[]
[]
[null,"The measures below are used to center the driver and rear dummies in the seat for side impact tests"]
[]
[null,"Driver seat centerline","X (mm)","Y (mm)","Z (mm)","Lateral Centerline (mm)"]
[null,"Head restraint (ref point 1)"]
[null,"Head restraint (ref point 2)",null,null,null,{"$f":"IF(D33=\"\",\"\",iihsround(AVERAGE(D32:D33),0))","v":""}]
[null,"Seat back (ref point 1)"]
[null,"Seat back (ref point 2)",null,null,null,{"$f":"IF(D35=\"\",\"\",iihsround(AVERAGE(D34:D35),0))","v":""}]
[null,"Seat pan (ref point 1)*"]
[null,"Seat pan (ref point 2)*",null,null,null,{"$f":"IF(D37=\"\",\"\",iihsround(AVERAGE(D36:D37),0))","v":""}]
[null,"* The target x-axis position should be within 10 mm of the calculated UMTRI X value located in the \"FINAL H-POINT & SEAT POSITION\" worksheet"]
[null,"Driver dummy centerline","X (mm)","Y (mm)","Z (mm)","Lateral Centerline (mm)"]
[null,"Driver nose"]
[null,"Driver center of neck"]
[null,"Driver left pelvis point"]
[null,"Driver right pelvis point",null,null,null,{"$f":"IF(D43=\"\",\"\",iihsround(AVERAGE(D42:D43),0))","v":""}]
[]
[]
[null,"Rear seat centerline","X (mm)","Y (mm)","Z (mm)","Lateral Centerline (mm)"]
[null,"Head restraint (ref point 1)"]
[null,"Head restraint (ref point 2)",null,null,null,{"$f":"IF(D48=\"\",\"\",iihsround(AVERAGE(D47:D48),0))","v":""}]
[null,"Seat back (ref point 1)"]
[null,"Seat back (ref point 2)",null,null,null,{"$f":"IF(D50=\"\",\"\",iihsround(AVERAGE(D49:D50),0))","v":""}]
[null,"Seat pan (ref point 1)"]
[null,"Seat pan (ref point 2)",null,null,null,{"$f":"IF(D52=\"\",\"\",iihsround(AVERAGE(D51:D52),0))","v":""}]
[]
[null,"Rear dummy centerline","X (mm)","Y (mm)","Z (mm)","Lateral Centerline (mm)"]
[null,"Passenger nose"]
[null,"Passenger center of neck"]
[null,"Passenger left pelvis point"]
[null,"Passenger right pelvis point",null,null,null,{"$f":"IF(D58=\"\",\"\",iihsround(AVERAGE(D57:D58),0))","v":""}]
[]
[]
[]
[null,"Driver","X (mm)","Y (mm)","Z (mm)"]
[null,"Shoulder"]
[null,"Inboard seat belt buckle"]

{"sheet":"Frontal Clearance Measures","index":21,"n_rows":36,"n_cols":5,"rows_kept":36,"cut":false,"hidden":true,"merged":[[35,1,43,4],[24,1,24,4],[1,1,1,4],[25,3,25,4],[2,3,2,4]]}
[]
[null,"Hand Clearance Measurements"]
[null,"Location","Code","Measurement"]
[null,"Head to header","HH",null,{"$f":"IF(F_HH=\"\",\"\",\"mm\")","v":""}]
[null,"Nose to rim","NR",null,{"$f":"IF(F_NR=\"\",\"\",\"mm\")","v":""}]
[null,"Chest to dash","CD",null,{"$f":"IF(F_CD=\"\",\"\",\"mm\")","v":""}]
[null,"Rim to abdomen","RA",null,{"$f":"IF(F_RA=\"\",\"\",\"mm\")","v":""}]
[null,"Steering wheel to chest, horiz.","SCH",null,{"$f":"IF(F_SCH=\"\",\"\",\"mm\")","v":""}]
[null,"Steering wheel to chest, ref.","SCR",null,{"$f":"IF(F_SCR=\"\",\"\",\"mm\")","v":""}]
[null,"Hub to chest, minimum","HCM",null,{"$f":"IF(F_HCM=\"\",\"\",\"mm\")","v":""}]
[null,"Knee to dash, left","KDL",null,{"$f":"IF(F_KDL=\"\",\"\",\"mm\")","v":""}]
[null,"Knee to dash, right","KDR",null,{"$f":"IF(F_KDR=\"\",\"\",\"mm\")","v":""}]
[null,"Knee to knee","KK",null,{"$f":"IF(F_KK=\"\",\"\",\"mm\")","v":""}]
[null,"Ankle to Ankle","AA",null,{"$f":"IF(F_AA=\"\",\"\",\"mm\")","v":""}]
[null,"Arm to door","AD",null,{"$f":"IF(F_AD=\"\",\"\",\"mm\")","v":""}]
[null,"H-point to door","HD",null,{"$f":"IF(F_HD=\"\",\"\",\"mm\")","v":""}]
[null,"Head to A-pillar","HA",null,{"$f":"IF(F_HA=\"\",\"\",\"mm\")","v":""}]
[null,"Head to roof","HR",null,{"$f":"IF(F_HR=\"\",\"\",\"mm\")","v":""}]
[null,"Head to side window","HS",null,{"$f":"IF(F_HS=\"\",\"\",\"mm\")","v":""}]
[null,"Pelvic angle","PA",null,{"$f":"IF(F_PA=\"\",\"\",\"degrees\")","v":""}]
[null,"Seat back angle","SA",null,{"$f":"IF(F_SA=\"\",\"\",\"degrees\")","v":""}]
[null,"Neck bracket angle","NBA",null,{"$f":"IF(F_NBA=\"\",\"\",\"degrees\")","v":""}]
[null,"Neck angle, seated","NAS",null,{"$f":"IF(F_NAS=\"\",\"\",\"degrees\")","v":""}]
[]
[null,"CMM Clearance Measurements"]
[null,"Location","Code","Measurement"]
[null,"Striker to head CG, horizontal ","CGH",{"$f":"IF('FINAL H-POINT & SEAT POSITION A'!D21=\"\",\"\",ROUND('FINAL H-POINT & SEAT POSITION A'!D21,0))","v":""},{"$f":"IF(F_CGH=\"\",\"\",\"mm\")","v":""}]
[null,"Striker to head CG, lateral ","CGL",{"$f":"IF('FINAL H-POINT & SEAT POSITION A'!E21=\"\",\"\",ROUND('FINAL H-POINT & SEAT POSITION A'!E21,0))","v":""},{"$f":"IF(F_CGL=\"\",\"\",\"mm\")","v":""}]
[null,"Striker to head CG, vertical ","CGV",{"$f":"IF('FINAL H-POINT & SEAT POSITION A'!F21=\"\",\"\",ROUND('FINAL H-POINT & SEAT POSITION A'!F21,0))","v":""},{"$f":"IF(F_CGV=\"\",\"\",\"mm\")","v":""}]
[null,"Striker to H-point, horizontal","SHH",{"$f":"IF('FINAL H-POINT & SEAT POSITION A'!D20=\"\",\"\",ROUND('FINAL H-POINT & SEAT POSITION A'!D20,0))","v":""},{"$f":"IF(F_SHH=\"\",\"\",\"mm\")","v":""}]
[null,"Stiker to H-point, vertical","SHV",{"$f":"IF('FINAL H-POINT & SEAT POSITION A'!F20=\"\",\"\",ROUND('FINAL H-POINT & SEAT POSITION A'!F20,0))","v":""},{"$f":"IF(F_SHV=\"\",\"\",\"mm\")","v":""}]
[null,"Striker to knee","SK",{"$f":"IF('Additional Occupant Measures'!C4=\"\",\"\",ROUND((('Additional Occupant Measures'!C4-'Additional Occupant Measures'!C3)^2+('Additional Occupant Measures'!E4-'Additional Occupant Measures'!E3)^2)^0.5,0))","v":""},{"$f":"IF(F_SK=\"\",\"\",\"mm\")","v":""}]
[null,"Torso Recline Angle","TRA",{"$f":"IF('FINAL H-POINT & SEAT POSITION A'!D24=\"\",\"\",ROUND('FINAL H-POINT & SEAT POSITION A'!D24,1))","v":""},{"$f":"IF(F_TRA=\"\",\"\",\"degrees\")","v":""}]
[null,"Striker to knee angle","SKA",{"$f":"IF('Additional Occupant Measures'!C4=\"\",\"\",ROUND(DEGREES(ATAN(('Additional Occupant Measures'!E4-'Additional Occupant Measures'!E3)/('Additional Occupant Measures'!C3-'Additional Occupant Measures'!C4))),1))","v":""},{"$f":"IF(F_SKA=\"\",\"\",\"degrees\")","v":""}]
[]
[null,"Notes:"]

{"sheet":"Side Clearance Measures","index":22,"n_rows":40,"n_cols":12,"rows_kept":40,"cut":false,"hidden":true,"merged":[[2,11,2,17],[18,11,18,17],[30,6,30,9],[34,6,42,9],[1,6,1,9],[2,8,2,9],[18,6,18,9],[19,8,19,9],[39,1,47,4],[1,1,1,4],[23,1,23,4],[35,1,35,4],[2,3,2,4],[24,3,24,4]]}
[]
[null,"Driver Hand Clearance Measurements",null,null,null,null,"Passenger Hand Clearance Measurements"]
[null,"Location","Code","Measurement",null,null,"Location","Code","Measurement",null,null,"Driver Clearance Measurements"]
[null,"Head to header","HH",null,{"$f":"IF(SD_HH=\"\",\"\",\"mm\")","v":""},null,"Head to head restraint","HHR",null,{"$f":"IF(SP_HHR=\"\",\"\",\"mm\")","v":""}]
[null,"Nose to rim","NR",null,{"$f":"IF(SD_NR=\"\",\"\",\"mm\")","v":""},null,"Chest to seat, horizontal","CS",null,{"$f":"IF(SP_CS=\"\",\"\",\"mm\")","v":""}]
[null,"Steering wheel to chest, ref.","SCR",null,{"$f":"IF(SD_SCR=\"\",\"\",\"mm\")","v":""},null,"Knee to knee","KK",null,{"$f":"IF(SP_KK=\"\",\"\",\"mm\")","v":""}]
[null,"Steering wheel to chest, horiz.","SCH",null,{"$f":"IF(SD_SCH=\"\",\"\",\"mm\")","v":""},null,"Ankle to ankle","AA",null,{"$f":"IF(SP_AA=\"\",\"\",\"mm\")","v":""}]
[null,"Hub to chest, minimum","HCM",null,{"$f":"IF(SD_HCM=\"\",\"\",\"mm\")","v":""},null,"Armrest to dummy, minimum","ADM",null,{"$f":"IF(SP_ADM=\"\",\"\",\"mm\")","v":""}]
[null,"Rim to abdomen","RA",null,{"$f":"IF(SD_RA=\"\",\"\",\"mm\")","v":""},null,"Arm to door","AD",null,{"$f":"IF(SP_AD=\"\",\"\",\"mm\")","v":""}]
[null,"Knee to dash, left, horizontal","KDL",null,{"$f":"IF(SD_KDL=\"\",\"\",\"mm\")","v":""},null,"H-point to door","HD",null,{"$f":"IF(SP_HD=\"\",\"\",\"mm\")","v":""}]
[null,"Knee to knee","KK",null,{"$f":"IF(SD_KK=\"\",\"\",\"mm\")","v":""},null,"Head to B-pillar","HB",null,{"$f":"IF(SP_HB=\"\",\"\",\"mm\")","v":""}]
[null,"Ankle to Ankle","AA",null,{"$f":"IF(SD_AA=\"\",\"\",\"mm\")","v":""},null,"Head to roof","HR",null,{"$f":"IF(SP_HR=\"\",\"\",\"mm\")","v":""}]
[null,"Arm to door","AD",null,{"$f":"IF(SD_AD=\"\",\"\",\"mm\")","v":""},null,"Head to side window","HS",null,{"$f":"IF(SP_HS=\"\",\"\",\"mm\")","v":""}]
[null,"Armrest to dummy, minimum","ADM",null,{"$f":"IF(SD_ADM=\"\",\"\",\"mm\")","v":""},null,"Pelvic angle","PA",null,{"$f":"IF(SP_PA=\"\",\"\",\"degrees\")","v":""}]
[null,"H-point to door","HD",null,{"$f":"IF(SD_HD=\"\",\"\",\"mm\")","v":""},null,"Seat back angle","SA",null,{"$f":"IF(SP_SA=\"\",\"\",\"degrees\")","v":""}]
[null,"Head to A-pillar","HA",null,{"$f":"IF(SD_HA=\"\",\"\",\"mm\")","v":""},null,"Neck bracket angle","NBA",null,{"$f":"IF(SP_NBA=\"\",\"\",\"degrees\")","v":""}]
[null,"Head to roof","HR",null,{"$f":"IF(SD_HR=\"\",\"\",\"mm\")","v":""},null,"Neck angle, seated","NAS",null,{"$f":"IF(SP_NAS=\"\",\"\",\"degrees\")","v":""}]
[null,"Head to side window","HS",null,{"$f":"IF(SD_HS=\"\",\"\",\"mm\")","v":""}]
[null,"Pelvic angle","PA",null,{"$f":"IF(SD_PA=\"\",\"\",\"degrees\")","v":""},null,"Passenger CMM Clearance Measurements",null,null,null,null,"Passenger Clearance Measurements"]
[null,"Seat back angle","SA",null,{"$f":"IF(SD_SA=\"\",\"\",\"degrees\")","v":""},null,"Location","Code","Measurement"]
[null,"Neck bracket angle","NBA",null,{"$f":"IF(SD_NBA=\"\",\"\",\"degrees\")","v":""},null,"Striker to head CG, horizontal ","CGH",{"$f":"IF('Additional Occupant Measures'!C25=\"\",\"\",ROUND('Additional Occupant Measures'!C25,0))","v":""},{"$f":"IF(SP_CGH=\"\",\"\",\"mm\")","v":""}]
[null,"Neck angle, seated","NAS",null,{"$f":"IF(SD_NAS=\"\",\"\",\"degrees\")","v":""},null,"Striker to head CG, lateral ","CGL",{"$f":"IF('Additional Occupant Measures'!D25=\"\",\"\",ROUND('Additional Occupant Measures'!D25,0))","v":""},{"$f":"IF(SP_CGL=\"\",\"\",\"mm\")","v":""}]
[null,null,null,null,null,null,"Striker to head CG, vertical ","CGV",{"$f":"IF('Additional Occupant Measures'!E25=\"\",\"\",ROUND('Additional Occupant Measures'!E25,0))","v":""},{"$f":"IF(SP_CGV=\"\",\"\",\"mm\")","v":""}]
[null,"Driver CMM Clearance Measurements",null,null,null,null,"Striker to H-point, horizontal","SHH",{"$f":"IF('Additional Occupant Measures'!C24=\"\",\"\",ROUND('Additional Occupant Measures'!C24,0))","v":""},{"$f":"IF(SP_SHH=\"\",\"\",\"mm\")","v":""}]
[null,"Location","Code","Measurement",null,null,"Striker to H-point, lateral","SHL",{"$f":"IF('Additional Occupant Measures'!D24=\"\",\"\",ROUND('Additional Occupant Measures'!D24,0))","v":""},{"$f":"IF(SP_SHL=\"\",\"\",\"mm\")","v":""}]
[null,"Striker to head CG, horizontal ","CGH",{"$f":"IF('FINAL H-POINT & SEAT POSITION A'!D21=\"\",\"\",ROUND('FINAL H-POINT & SEAT POSITION A'!D21,0))","v":""},{"$f":"IF(SD_CGH=\"\",\"\",\"mm\")","v":""},null,"Stiker to H-point, vertical","SHV",{"$f":"IF('Additional Occupant Measures'!E24=\"\",\"\",ROUND('Additional Occupant Measures'!E24,0))","v":""},{"$f":"IF(SP_SHV=\"\",\"\",\"mm\")","v":""}]
[null,"Striker to head CG, lateral ","CGL",{"$f":"IF('FINAL H-POINT & SEAT POSITION A'!E21=\"\",\"\",ROUND('FINAL H-POINT & SEAT POSITION A'!E21,0))","v":""},{"$f":"IF(SD_CGL=\"\",\"\",\"mm\")","v":""},null,"Rear striker to knee","SK",{"$f":"IF('Additional Occupant Measures'!C26=\"\",\"\",ROUND((('Additional Occupant Measures'!C26-'Additional Occupant Measures'!C23)^2+('Additional Occupant Measures'!E26-'Additional Occupant Measures'!E23)^2)^0.5,0))","v":""},{"$f":"IF(SP_SK=\"\",\"\",\"mm\")","v":""}]
[null,"Striker to head CG, vertical ","CGV",{"$f":"IF('FINAL H-POINT & SEAT POSITION A'!F21=\"\",\"\",ROUND('FINAL H-POINT & SEAT POSITION A'!F21,0))","v":""},{"$f":"IF(SD_CGV=\"\",\"\",\"mm\")","v":""},null,"Torso Recline Angle","TRA",{"$f":"IF('Additional Occupant Measures'!C25=\"\",\"\",ROUND(DEGREES(ATAN(-('Additional Occupant Measures'!C24-'Additional Occupant Measures'!C25)/('Additional Occupant Measures'!E25-'Additional Occupant Measures'!E24))),1))","v":""},{"$f":"IF(SP_TRA=\"\",\"\",\"degrees\")","v":""}]
[null,"Striker to H-point, horizontal","SHH",{"$f":"IF('FINAL H-POINT & SEAT POSITION A'!D20=\"\",\"\",ROUND('FINAL H-POINT & SEAT POSITION A'!D20,0))","v":""},{"$f":"IF(SD_SHH=\"\",\"\",\"mm\")","v":""},null,"Rear striker to knee angle","SKA",{"$f":"IF('Additional Occupant Measures'!C26=\"\",\"\",ROUND(DEGREES(ATAN(('Additional Occupant Measures'!E26-'Additional Occupant Measures'!E23)/('Additional Occupant Measures'!C23-'Additional Occupant Measures'!C26))),1))","v":""},{"$f":"IF(SP_SKA=\"\",\"\",\"degrees\")","v":""}]
[null,"Striker to H-point, lateral","SHL",{"$f":"IF('FINAL H-POINT & SEAT POSITION A'!E20=\"\",\"\",ROUND('FINAL H-POINT & SEAT POSITION A'!E20,0))","v":""},{"$f":"IF(SD_SHL=\"\",\"\",\"mm\")","v":""}]
[null,"Stiker to H-point, vertical","SHV",{"$f":"IF('FINAL H-POINT & SEAT POSITION A'!F20=\"\",\"\",ROUND('FINAL H-POINT & SEAT POSITION A'!F20,0))","v":""},{"$f":"IF(SD_SHV=\"\",\"\",\"mm\")","v":""},null,"Passenger Additional Measurements"]
[null,"Striker to knee","SK",{"$f":"IF('Additional Occupant Measures'!C4=\"\",\"\",ROUND((('Additional Occupant Measures'!C4-'Additional Occupant Measures'!C3)^2+('Additional Occupant Measures'!E4-'Additional Occupant Measures'!E3)^2)^0.5,0))","v":""},{"$f":"IF(SD_SK=\"\",\"\",\"mm\")","v":""},null,"Arm angle","n/a",null,{"$f":"IF(I32=\"\",\"\",\"degrees\")","v":""}]
[null,"Torso Recline Angle","TRA",{"$f":"IF('FINAL H-POINT & SEAT POSITION A'!D24=\"\",\"\",ROUND('FINAL H-POINT & SEAT POSITION A'!D24,1))","v":""},{"$f":"IF(SD_TRA=\"\",\"\",\"degrees\")","v":""},null,"Head angle","n/a",null,{"$f":"IF(I33=\"\",\"\",\"degrees\")","v":""}]
[null,"Striker to knee angle","SKA",{"$f":"IF('Additional Occupant Measures'!C4=\"\",\"\",ROUND(DEGREES(ATAN(('Additional Occupant Measures'!E4-'Additional Occupant Measures'!E3)/('Additional Occupant Measures'!C3-'Additional Occupant Measures'!C4))),1))","v":""},{"$f":"IF(SD_SKA=\"\",\"\",\"degrees\")","v":""}]
[null,null,null,null,null,null,"Notes:"]
[null,"Driver Additional Measurements"]
[null,"Arm angle","n/a",null,{"$f":"IF(D37=\"\",\"\",\"degrees\")","v":""}]
[null,"Head angle","n/a",null,{"$f":"IF(D38=\"\",\"\",\"degrees\")","v":""}]
[]
[null,"Notes:"]

{"sheet":"Additional Measures","index":23,"n_rows":19,"n_cols":8,"rows_kept":19,"cut":false,"hidden":true,"merged":[[10,3,10,4],[11,3,11,4]]}
[]
[]
[null,"The cells below are used to determine the vehicle CG location for frontal crashes"]
[null,"Rear weight (kg)",null,null,null,null,null,"User Entered Data"]
[null,"Test weight (kg)",null,null,null,null,null,"CMM Data"]
[null,"Vehicle wheelbase (mm)",null,null,null,null,null,"Calculated Data"]
[null,null,"X (mm)","Y (mm)","Z (mm)"]
[null,"CMM coordinates for center of left front axle (mm)"]
[null,"CMM coordinates of vehicle accelerometer (mm)"]
[null,"Front axle to vehicle CG distance (mm)",{"$f":"IF(C6=\"\",\"\",(C4*C6)/C5)","v":""}]
[null,"CMM x-axis coordinate for vehicle CG (mm)",{"$f":"IF(C8=\"\",\"\",C8+C10)","v":""}]
[null,"Front axle to vehicle accelerometer distance(mm)",{"$f":"IF(C9=\"\",\"\",C9-C8)","v":""}]
[]
[null,"The cells below are used to determine the seat back hinge-point (in the XZ plane)"]
[null,null,"X (mm)","Y (mm)","Z (mm)"]
[null,"Seat back pt 1"]
[null,"Seat back pt 2"]
[null,"Seat back pt 1, reclined"]
[null,"Seat back pt 2, reclined"]

{"sheet":"Excursion","index":24,"n_rows":20,"n_cols":7,"rows_kept":20,"cut":false,"hidden":true,"merged":[[8,1,8,2],[13,1,13,2],[1,6,7,6]]}
[]
[null,"Seat position","X (mm)","Z (mm)",null,null,"Comments: "]
[null,"Was the seat pan moved during dummy positioning?",0,0]
[]
[null,"Tape distance readings","cm"]
[null,"Inboard tape reading at seat, pre-test",0]
[null,"Inboard tape reading at seat, post-test",0]
[null,"Inboard tape pull-out during test",{"$f":"ABS(C7-C6)","v":0}]
[]
[null,"Outboard tape reading at seat, pre-test",0]
[null,"Outboard tape reading at seat, post-test",0]
[null,"Outboard tape pull-out during test",{"$f":"ABS(C11-C10)","v":0}]
[]
[null,"Seat back deflection"]
[null,"Time of maximum dummy excursion (ms)"]
[null,"Inboard pot pull-out at time of maximum dummy excursion (mm)",0]
[null,"Outboard pot pull-out at time of maximum dummy excursion (mm)",0]
[]
[null,"Peak excursion","X (mm)","Y (mm)"]
[null,"Excursion",{"$f":"IF(ISNUMBER('Excursion calculations'!B74),'Excursion calculations'!B74,\"\")","v":""},{"$f":"IF(ISNUMBER('Excursion calculations'!C74),'Excursion calculations'!C74,\"\")","v":""}]