Each route is identified by a route number and effective date. A route number can have multiple records, each with a different effective date. The effective date is at the top of the spreadsheet from Operations, as Figure 1 shows.
Field 1, Route Number, and 2, Effective Date: To insert a new route number, fill in the route number in field 1. In field 2, enter 6 digits (MMDDYY) for the date of the schedule from Operations in field 2.
Using the example in the figures, you might add a new route 811 with an effective date of 010504.
Field 3, Expiration Date: As this is a new route, leave Expiration Date empty. (See Expiring a Route and Changing a Route for instructions in when to use Expiration Date.)
Field 4, Assoc Route: Each route on the spreadsheet in Figure 1 has two route numbers. The odd-numbered route identifies the outbound flight from Miami. The even number identifies the associated, or inbound route returning to Miami. When you set up a new outbound route record, enter the even-numbered inbound route in field 4. See Entering the Associated Inbound Route for information about the associated route.
Field 5, Flight Date, is the day of the week the route leaves Miami. The second digit of the route number indicates the day of the week:
Monday = 1
Tuesday = 2
Wednesday = 3
Thursday = 4
Friday = 5
Saturday = 6
Sunday = 7
Fields 6, Departure and 7, Arrival: In field 6, enter 4 digits (HHMM) to indicate the time the flight leaves Miami. In field 7, enter 4 digits (HHMM) for the time the last inbound leg lands in Miami. Use Military (24-hour) time for the hour digits. In our Route 811 example, the first leg of the route departs Miami at 0400 (4:00 AM) and the last leg arrives in Miami at 1505 (3:02 PM).
Fields 8 through 10, Cutoff Times: Cutoff times refer to the outbound leg departing Miami. Typically, Reservation cutoff (field 8) is 1730 (or 5:30 PM) when Customer Service closes for the day. Receiving (field 9) cuts off at 2000 (8 PM). You do not need to enter a cutoff for palletizing.
Field 11, Exceptions, opens a text box in which you can indicate when times are different or the flight does not occur. Refer to the schedule from Operations for any exceptions. This field is rarely used.
Fields 12 thorugh 18, legs of the flight: Enter a row for each departure/arrival pair in the route. Fill the following columns:
|City||The 3-character airport code where the leg departs|
|Destination||The 3-character airport code where the leg stops|
|Ter||"Terminating" is N (No) for all but the last leg, the return flight to Miami, which has a Y (Yes) in the Ter column|
|STA, STD||Scheduled arrival time and scheduled departure time are reversed. Leave them blank.|
|Miles||Press Enter and the system automatically fills in the miles between City and Destination.|
|Inactive||Enter N (for active) if cargo is loaded at Destination for the leg and Y (inactive) if no cargo is loaded. No one can make a reservation for a leg that has Inactive set to Y.|
|Reason||You must enter a reason for an inactive leg. Usually this field shows "N/A".|
You can copy the record for a particular route and change the effective date. First enter the new schedule date as field 3, expiration date. Then enter the letter R to access and change either field 1 or field 2. For example, if the departure and arrival times for route 8113 change from in January, 2004, from the schedule entered in January, 2003, you indicate the change as follows:
You do not need to expire a schedule and create a new copy if unless the arrival, departure, or leg information changes.