Importing Ergonomics Data from an Exel Data Base

The Excel import function parses the configuration file:
C:\Program Files\nVIZ\Ergonomics\<version>\xlsximport.config
The configuration file specifies which Excel sheets and columns are to be extracted to retrieve the vehicles ergonomics data.

Contact nVIZ to receive our Excel template for ergonomics data. Columns A to J store generic vehicle information. Columns K to FT are to be filled in according to the type of vehicle. Leave cells blank if the seats or mirrors are not part of the specific vehicle or are not of interest for the ergonomics review.
Make sure the Excel sheet name matches the entry in the configuration file.
The configuration file (see above) specifies the number of header rows. In the example depicted here, the data import will start with row 7.
Row 6 are the column numbers, added to make it easier to reference the column number in the configuration file.
A pink cell in row 6 indicates that data from this column will be imported, a grey cell indicates that data in this column is for information only.

• Position: Consecutive number.
• Import: Input a 1 to import this row, input a 0 to skip this row.
• Brand, Model, Model Year: Generic vehicle information.
• RHD / LHD: Indicates left hand drive or right hand drive vehicle.
• Carline, Type: Generic vehicle information.
• Vehicle Code: This entry must be a unique vehicle identifier. Duplicate entries will not be imported.
• Data Source: Reference to the source of the data.

The Excel data base stores ergonomics data for the following list of items:

• Seat Row 1 Driver Side
• Seat Row 1 Center
• Seat Row 1 Passenger Side
• Seat Row2 Driver Side
• Seat Row 2 Center
• Seat Row 2 Passenger Side
• Seat Row 3 Driver Side
• Seat Row 3 Center
• Seat Row 3 Passenger Side
• Steering Wheel
• Mirrors & Active Mirror Systems
• Spotter Mirrors
• Eye Points
• Center Console

The data is grouped per item. For any item of interest for an ergonomics review, the data needs to be filled in. Leave all cells of a group blank if the item is not present in the vehicle or not of interest for the ergonomics review.

All seating positions of interest most have the seat reference point and the seat adjustment range (seat travel envelope) filled in.

Additionally, the driver seat needs to have the heal point and the ball of foot point filled in as the common reference point on the CNC seating buck.

• Seat Reference Point: The X, Y and Z coordinates of the seat reference point in the vehicle coordinate system.
• Back Rest Angle: For information only.
• Heel Point: The X and Z coordinates of the driver’s heel point in the vehicle coordinate system.
• H30 Reference: For information only.
• Ball of Foot: The X and Z coordinates of the driver’s ball of foot point in the vehicle coordinate system.
• Seat Adjustment: X and Z coordinates of the front most upper and rear most lowest point of the seat adjustment range (seat travel envelope) in the vehicle coordinate system.
• Seat Track: Length and angle of the seat track.

The steering reference point, steering pivot point and the steering adjustment range (steering travel envelope) need to be filled in.

• Steering A-Point: X, Y and Z coordinates of the steering reference point in the vehicle coordinate system.
• Steering B-Point: X, Y and Z coordinates of the lower steering column point in the vehicle coordinate system.
• Offset B-Point: X and Z coordinates of the steering column pivot point in the vehicle coordinate system.
• Steering Column Adjustment: X and Z coordinates of points I to IV representing the corner points of the steering adjustment range (steering travel envelope) in the vehicle coordinate system.
• Steering Wheel Diameter: For information only.

• Mirror A-Point: X,Y and Z coordinates of the mirror pivot point in the vehicle coordinate system.
• Mirror Adjustment: Left, right, up down adjustment angels.

• 95% Male: X,Y and Z coordinates of the 95 percentile male driver eye point in the vehicle coordinate system.
• 55% Male: X,Y and Z coordinates of the 55 percentile male driver eye point in the vehicle coordinate system.
• 5% Female: X,Y and Z coordinates of the 5 percentile female driver eye point in the vehicle coordinate system.

• Reference Point: X,Y and Z coordinates and pitch angle of the center console reference point in the vehicle coordinate system.