Table of Contents
Configuration File
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.
Excel Data Base
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.
Vehicle Information
- 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.
Ergonomics 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.
Seats
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.
Steering Wheel
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.
Mirrors and Spotter Mirrors
- 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.
Eye Points
- 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.
Center Console
- Reference Point: X,Y,Z coordinates and pitch angle of the center console reference point in the vehicle coordinate system.
Pedals
- Reference Point: X,Y,Z coordinates and pitch angle of the throttle, brake and clutch pedals and footrest reference points in the vehicle coordinate system.
HMI Cobot
- Foot Reference Point Position: X,Y,Z coordinates of the HMI cobot foot point in the vehicle coordinate system.
- Foot Reference Point Orientation: RX,RY,RZ orientation of the HMI cobot foot point in the vehicle coordinate system.
Vehicle Offsets
- For VR in Design System: X,Y,Z, RZ coordinate offsets for positioning the vehicle in the VR scene relative to the design coordinate system. These values are typically used to e.g. move the vehicle a little down in the VR scene to make it look like it is standing firmly on the street.
- For VR in CarMakerFR1 System: X,Y,Z, RZ coordinate offsets for positioning the vehicle in the Car Maker FR1 reference system relative to the design coordinate system. These offsets are required for correct driving simulation in VR.