{"text_format":"3","workbook":"xls","n_sheets":15,"sheets":["ENABLE MACROS","User Form","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","Dummy Clearance Measures"],"not_rendered":{"charts":2,"images":2,"macros":1,"external_links":1,"defined_names":37},"unopened":[{"sheet":"SEAT CHART A","index":8,"reason":"not_a_worksheet"},{"sheet":"SEAT CHART B","index":13,"reason":"not_a_worksheet"}],"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"ENABLE MACROS","index":0,"n_rows":3,"n_cols":1,"rows_kept":3,"flags":["formulas_cached_only"]}
[]
["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,"hidden":true,"flags":["formulas_cached_only"]}

{"sheet":"SEAT INFORMATION","index":2,"n_rows":51,"n_cols":6,"rows_kept":51,"hidden":true,"merged":[[3,2,5,2],[12,1,12,4],[15,2,16,2]],"flags":["formulas_cached_only"]}
[]
[{"$nulls":5},"User Entered Data"]
[null,"Dummy ",{"$nulls":3},"Calculated Data"]
[null,"(1) 5th percentile female"]
[null,"(2) 50th percentile male",null,"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,"Verify the number of locking positions."]
[null,"Adjustment range (mm)","",null," "]
[null,"Movement per notch (mm)",""]
[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"]
{"$rows_empty":31}
[null,"General Information for Macros"]
[null,"Has macro been executed before; Yes =1"]
[null,"Calculation type; exact midtrack = 1, manual w/ even notches =2",""]

{"sheet":"SEAT PAN ADJUSTMENT","index":3,"n_rows":37,"n_cols":5,"rows_kept":37,"hidden":true,"merged":[[1,1,1,9],[2,1,2,9],[4,1,4,9],[5,1,5,9],[6,1,6,9],[7,1,7,9],[8,1,8,9],[9,1,9,9],[18,1,18,9],[20,1,20,9],[21,1,21,9],[22,1,22,9],[28,1,28,9],[36,1,36,9]],"flags":["formulas_cached_only"]}
[]
[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)",""]
[]
[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,""]
[]
[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)",""]
[]
[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":4,"n_rows":31,"n_cols":14,"rows_kept":31,"hidden":true,"merged":[[11,8,11,10],[25,0,25,5]],"flags":["formulas_cached_only"]}
[]
[{"$nulls":8},"CMM Data","Coordinate system",null,"+X: towards rear of vehicle; +Z: upwards"]
[{"$nulls":3},"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*",{"$nulls":6},""]
[null,null,"Pedal (top)"]
[null,null,"Pedal (middle)"]
[null,null,"Pedal (bottom)",{"$nulls":5},"Additional Measurements",null,null,"X (mm)","Y (mm)","Z (mm)"]
[null,null,"Heel Surface Pt. 1",{"$nulls":7},"Seat Ref. Pt. 1 (calculated midtrack)","","",""]
[null,null,"Heel Surface Pt. 2",{"$nulls":7},"Seat Ref. Pt. 2 (calculated midtrack)","","",""]
[null,null,"Seat Ref. Pt. 1, rear/down",{"$nulls":7},"Seat Ref. Pt. 1 at midtrack/down"]
[null,null,"Seat Ref. Pt. 2, rear/down",{"$nulls":7},"Seat Ref. Pt. 2 at midtrack/down"]
[null,null,"Seat Ref. Pt. 1 forward/down",{"$nulls":5},"H-point at midtrack/down"]
[null,null,"Seat Ref. Pt. 2 forward/down",{"$nulls":7},"H-point to Seat Ref. Pt. 2","","",""]
[null,null,"Seat Ref. Pt. 1 forward/up"]
[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","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","","",""]
[null,null,"PRP ","",null,""]
[null,null,"Heel Rest Point","",null,""]
["* The door striker measurement is only used as a reference point and does not affect the UMTRI calculations"]
[]
[{"$nulls":3},"X (mm)","Y (mm)","Z (mm)"]
[null,null,"Calibration Pt 1"]
[null,null,"Calibration Pt 2"]
[null,null,"Resultant",0]

{"sheet":"SEAT RANGE CALCULATIONS A","index":5,"n_rows":25,"n_cols":15,"rows_kept":25,"hidden":true,"flags":["formulas_cached_only"]}
[]
[null,"Position","Seat Pt. 2",null,"Seat Pt. 1",{"$nulls":5},"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",0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},"Rear/Down"]
[null,"Midtrack down",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},"Midtrack down"]
[null,"Forward/Down",0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},"Forward/Down"]
[null,"Forward/Up",0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},"Forward/Up"]
[null,"Rear/Up",0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},"Rear/Up"]
[null,"Rear/Down",0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$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",{"$error":"#DIV/0!"},{"$nulls":3},"X (mm)","Z (mm)"]
[null,0,0,0,{"$error":"#DIV/0!"},{"$nulls":5},"Front",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$nulls":10},"Rear",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[]
[null,"Seat 1-Seat 2 angle",{"$nulls":8},"Rear",0,0,0,0]
[null,"Position","angle","difference",{"$nulls":6},"Forward",0,0,0,0]
[]
[null,"Rear/Down",{"$error":"#DIV/0!"},{"$nulls":8},"Seat Pt. 1 vertical travel range",0]
[null,"Forward/Down",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$nulls":7},"Seat Pt. 2 vertical travel range",0]
[null,"Forward/Up",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"Rear/Up",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"Rear/Down",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]

{"sheet":"UMTRI CALCULATIONS A","index":6,"n_rows":78,"n_cols":12,"rows_kept":78,"hidden":true,"merged":[[27,2,27,5],[28,1,31,1],[28,2,28,3],[28,4,28,5],[28,7,28,8],[33,1,33,2]],"flags":["formulas_cached_only"]}
[]
[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,{"v":0,"d":"0.0"}]
[null,"Pedal Reference Point","PRP",{"v":0,"d":"0.0"},{"$error":"#VALUE!"}]
[null,"Rear Upper H-point","HPtRU",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"Rear Lower H-point","HPtRL",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[]
[null,"Front Upper H-point","HPtFU",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"Front Lower H-point","HPtFL",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"Steering Wheel Center","SWX",{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[]
[null,"Calculated Values",null,"X (mm)","Z (mm)"]
[null,"Rear  Mid-Height H-point ","HPtR",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"Front Mid-Height H-point","HPtF",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"Slope (∆Z/∆X)","r",{"$error":"#DIV/0!"}]
[null,"Track Angle (deg)",null,{"$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","Enter integer for dummy size into the SEAT INFORMATION worksheet"]
[]
[null,null,"UMTRI H-point Position"]
[null,"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,{"$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,"","",null,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,{"$error":"#VALUE!"},{"$error":"#DIV/0!"},{"$error":"#VALUE!"},{"$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,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,"*This is the position from which H-point was originally measured."]
[null,"Seat Point 2 should be moved by this amount."]
{"$rows_empty":34}
[null,"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":7,"n_rows":48,"n_cols":7,"rows_kept":48,"hidden":true,"merged":[[7,1,7,4],[10,6,11,6]],"flags":["formulas_cached_only"]}
[null,"Occupant size:","Enter correct value for dummy size into the SEAT INFORMATION worksheet"]
[]
[null,"Seat information"]
[null,null,"Number of locking positions",""]
[null,null,"Adjustment range (mm)",""]
[null,null,"Movement per notch (mm)",""]
[null,null,"Number of notches to UMTRI position from midtrack*",""]
[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)","",null,"",""]
[null,null,"Seat Pt. 2 (ideal UMTRI location)","",null,""]
[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","Enter correct value for dummy size into the SEAT INFORMATION worksheet","","",""]
[]
[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*","","degrees"]
[{"$nulls":3},"* 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,""]
[{"$nulls":3},"",""]
[null,null,"","",""]
[]
[null,""]
[{"$nulls":3},"",""]
[null,null,"","",""]
[null,null,"","",""]
[]
[null,null,"X (mm)","Z (mm)"]
[null,"New Offset","",""]
[null,"New Point 1 Coord.","",""]
[null,"New Point 2 Coord.","",""]

{"sheet":"CMM DATA B","index":9,"n_rows":47,"n_cols":14,"rows_kept":47,"hidden":true,"merged":[[12,8,12,9],[13,8,13,9],[14,8,14,9],[15,8,15,9],[16,8,16,9],[17,8,17,10],[18,8,18,13],[25,0,26,6]],"flags":["formulas_cached_only"]}
[]
[{"$nulls":8},"CMM Data","Coordinate system: +X: towards rear of vehicle; +Z: upwards"]
[{"$nulls":3},"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*",{"$nulls":6},""]
[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",{"$nulls":5},"Additional Measurements",null,null,"X (mm)","Y (mm)","Z (mm)"]
[null,null,"Seat Ref. Pt. 2 forward/down",{"$nulls":5},"Seat Ref. Pt. 1 forward of initial seat position; notch",null,0]
[null,null,"Seat Ref. Pt. 1 forward/up",{"$nulls":5},"Seat Ref. Pt. 2 forward of initial seat position; notch",null,0]
[null,null,"Seat Ref. Pt. 2 forward/up",{"$nulls":5},"Seat Ref. Pt. 1 at initial seat position; notch",null,1]
[null,null,"Seat Ref. Pt. 1 rear/up",{"$nulls":5},"Seat Ref. Pt. 2 at initial seat position; notch",null,1]
[null,null,"Seat Ref. Pt. 2 rear/up",{"$nulls":5},"H-point at initial seat position; notch",null,1]
[null,null,"Steering Wheel","Telescope position: mid-range",{"$nulls":4},"H-point to Seat Ref. Pt. 2",null,null,"","",""]
[null,null,"Top (0 degrees)",{"$nulls":5},""]
[null,null,"Bottom (0 degrees)",{"$nulls":5},"* 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","","",""]
[null,null,"PRP ","",null,""]
[null,null,"Heel Surface","",null,""]
["* The door striker measurement is only used as a reference point and does not affect the UMTRI calculations"]
[]
[]
[{"$nulls":3},"X (mm)","Y (mm)","Z (mm)"]
[null,null,"Calibration Pt 1"]
[null,null,"Calibration Pt 2",{"$nulls":4}," "]
[null,null,"Resultant",{"v":0,"d":"0.0"}]
{"$rows_empty":14}
[{"$nulls":9}," "]

{"sheet":"SEAT RANGE CALCULATIONS B","index":10,"n_rows":25,"n_cols":15,"rows_kept":25,"hidden":true,"flags":["formulas_cached_only"]}
[]
[null,"Position","Seat Pt. 2",null,"Seat Pt. 1",{"$nulls":5},"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",0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},"Rear/Down"]
[null,"Midtrack down",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},"Midtrack down"]
[null,"Forward/Down",0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},"Forward/Down"]
[null,"Forward/Up",0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},"Forward/Up"]
[null,"Rear/Up",0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},"Rear/Up"]
[null,"Rear/Down",0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$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",{"$error":"#DIV/0!"},{"$nulls":3},"X (mm)","Z (mm)"]
[null,0,0,0,{"$error":"#DIV/0!"},{"$nulls":5},"Front",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$nulls":10},"Rear",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[]
[null,"Seat 1-Seat 2 angle",{"$nulls":8},"Rear",0,0,0,0]
[null,"Position","angle","difference",{"$nulls":6},"Forward",0,0,0,0]
[]
[null,"Rear/Down",{"$error":"#DIV/0!"},{"$nulls":9},"Seat Pt. 1 vertical travel range (mm)",0]
[null,"Forward/Down",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$nulls":8},"Seat Pt. 2 vertical travel range (mm)",0]
[null,"Forward/Up",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"Rear/Up",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"Rear/Down",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]

{"sheet":"UMTRI CALCULATIONS B","index":11,"n_rows":78,"n_cols":9,"rows_kept":78,"hidden":true,"merged":[[27,2,27,5],[28,1,31,1],[28,7,28,8],[33,1,33,2]],"flags":["formulas_cached_only"]}
[]
[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,{"$error":"#VALUE!"}]
[null,"Rear Upper H-point","HPtRU",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"Rear Lower H-point","HPtRL",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[]
[null,"Front Upper H-point","HPtFU",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"Front Lower H-point","HPtFL",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"Steering Wheel Center","SWX",{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[]
[null,"Calculated Values",null,"X (mm)","Z (mm)"]
[null,"Rear  Mid-Height H-point ","HPtR",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"Front Mid-Height H-point","HPtF",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"Slope (∆Z/∆X)","r",{"$error":"#DIV/0!"}]
[null,"Track Angle (deg)",null,{"$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","Enter integer for dummy size into the SEAT INFORMATION worksheet"]
[]
[null,null,"UMTRI H-point Position"]
[null,"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,"",""]
[null,null,{"$error":"#VALUE!"},{"$error":"#DIV/0!"},{"$error":"#VALUE!"},{"$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,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,"*This is the position from which H-point was originally measured."]
[null,"Seat Point 2 should be moved by this amount."]
{"$rows_empty":34}
[null,"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":12,"n_rows":48,"n_cols":7,"rows_kept":48,"hidden":true,"merged":[[7,1,7,4],[10,6,11,6]],"flags":["formulas_cached_only"]}
[null,"Occupant size:","Enter correct value for dummy size into the SEAT INFORMATION worksheet"]
[]
[null,"Seat information"]
[null,null,"Number of locking positions",""]
[null,null,"Adjustment range (mm)",""]
[null,null,"Movement per notch (mm)",""]
[null,null,"Number of notches to UMTRI position from midtrack*",""]
[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)","",null,"",""]
[null,null,"Seat Reference Pt. 2 (ideal UMTRI location)","",null,""]
[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","Enter correct value for dummy size into the SEAT INFORMATION worksheet","","",""]
[]
[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*","","degrees"]
[{"$nulls":3},"* 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,""]
[{"$nulls":3},"",""]
[null,null,"","",""]
[]
[null,""]
[{"$nulls":3},"",""]
[null,null,"","",""]
[null,null,"","",""]
[]
[null,null,"X (mm)","Z (mm)"]
[null,"New Offset","",""]
[null,"New Point 1 Coord.","",""]
[null,"New Point 2 Coord.","",""]

{"sheet":"Dummy Clearance Measures","index":14,"n_rows":48,"n_cols":6,"rows_kept":48,"hidden":true,"flags":["formulas_cached_only"]}
[]
[null,"Driver","X (mm)","Y (mm)","Z (mm)"]
[null,"Front door striker"]
[null,"Driver knee"]
[null,null,1]
[null,"Striker to knee distance","",""]
[null,"Striker-to-knee angle","",""]
[]
[null,"Rear passenger","X (mm)","Y (mm)","Z (mm)"]
[null,"Rear door striker face"]
[null,"Passenger h-point"]
[null,"Passenger knee"]
[null,"Front door striker to h-point","","",""]
[]
[null,"Rear door striker-to-knee distance","",""]
[null,"Rear door striker-to-knee angle","",""]
[]
[]
[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)",{"$nulls":3},""]
[null,"Seat back (ref point 1)"]
[null,"Seat back (ref point 2)",{"$nulls":3},""]
[null,"Seat pan (ref point 1)"]
[null,"Seat pan (ref point 2)",{"$nulls":3},""]
[]
[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",{"$nulls":3},""]
[]
[]
[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)",{"$nulls":3},""]
[null,"Seat back (ref point 1)"]
[null,"Seat back (ref point 2)",{"$nulls":3},""]
[null,"Seat pan (ref point 1)"]
[null,"Seat pan (ref point 2)",{"$nulls":3},""]
[]
[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",{"$nulls":3},""]