Exporting rate data to Excel
If you want, you can export rate data from the Tariff Mass Table Rate Change window to a new Excel workbook.
Note: If you have made changes to rate data, you must save your changes before exporting to Excel.
Click the Excel Export button in the header of the window. A new instance of Excel opens, showing the rate data from the window. Rate data is shown in these columns:
Rows | Cmd Class 2 | Rate 3 | Rate Nbr 4 |
Row Cmp ID | Min Qty 2 | Cmd Class 4 | Rate 4 |
Col Cmp ID | Rate Nbr 2 | Min Qty 4 | Bill Mile Rate* |
Cmd Class 1 | Rate 2 | Rate Nbr 4 | Bill Miles* |
Min Qty 1 | Cmd Class 3 | Rate 4 | Toll Chg Rate |
Tar_number | Min Qty 3 | Cmd Class 4 | Toll Charge |
Rate 1 | Rate Nbr 3 | Min Qty 4 | Pump Rate |
| | | Pump Charge |
* The Bill Mile Rate and Bill Miles columns are custom columns that do not appear in the Tariff Mass Table Rate Change window.
You can save the workbook for future reference. When you close Excel, the Tariff Mass Table Rate Change window is still displayed.