Entering multiple values for a row or column heading
In some rate tables, the same rate amount may apply for multiple row entries or column entries. Although you can record the rate repeatedly for each entry to which it applies, you can also enter multiple values in a row or column heading so that the rate can be entered just once.
You can enter multiple values only for these row/column selections:
Axle Count | Dest. State | Master Order# | Revenue Type 1-4 |
Bill To | Dest. Zip (3-digit) | Origin Company | Stop Company |
Billto Othertypes 1-2 | Dest. Zip (Full) | Origin County | Terms |
Commodity | Destination County | Origin State | TrcType 1-4 |
Commodity Class | Divis of Parent | Origin Zip (3-digit) | Seniority (months) |
Day of Week | Driver Type 1-4 | Origin Zip (Full) | Stop Othertypes1-2 |
Dest. Company | LghType1-2 | Other Type 1-2 | TrlType 1-4 |
To use this feature, follow these steps:
1. Define your rows and/or columns. (To do so, make the appropriate selection in the Rows field and/or Col.’s field in the rate header.)
2. Double-click the heading of the row or column in which multiple values are to be entered.
The Multiple Selection window opens. It is shown here with sample data:
Note: Another way to access the Multiple Selection window is to right-click the heading of the table's row or column, then select Multiple Selection in the shortcut menu.
3. Enter the appropriate values. Use a semicolon to separate entries. Do not use spaces.
4. When your entries are complete, click OK.
The row or column heading is highlighted in turquoise to indicate that multiple values exist. An asterisk (*) to the left of the first entry indicates that only the first few entries are visible.
5. In the appropriate cell, enter the rate that applies to all the values you entered.