Use this program to:

• Import the Ideal Fleet Plan from an Excel spreadsheet into the Planning Calendar.
• This program inserts and or updates records in the Ideal Fleet file.

See the chapter on Edit Ideal Fleet for a full definition of Ideal Fleet Plan.

I. SETTING UP THE SPREADSHEET

The columns for the spreadsheet are listed below. The spreadsheet must be saved in CSV format and the first row of column headers must be exported as well.

USER TIP: When creating the spreadsheet, initially save it in your spreadsheet program's native format (for example if using Microsoft's Excel program, save it as .xls). Then re-save a copy in .csv format. In this way, if there is a error in the data discovered by the merge program, you are able to go back to the file in the native format and easily make any corrections and then resave it again as a comma delimited file.

In the spreadsheet, create a row for each ideal fleet record that should be imported. Once the spreadsheet is complete and exported, use this program to import the adjustment records into the Ideal Fleet file. The column headings in the spreadsheet must be the values in the table below:

Required Column Header	Field on Edit Ideal Fleet screen	Notes
loc	Location
date	Start Date	in the format YYYYMMDD (20120101)
class	Class
ideal	Ideal Fleet
low	Low Limit
high	High Limit
limit	Reservation Limit	Y/N/or blank
note	Notes

II. TRANSMITTING THE FILE FROM A PC TO THE CARS+ SERVER

Create the spreadsheet on a PC or computer that is also used to access CARS+. Once the spreadsheet is done, save it in the csv format. Then on the same computer, sign into and access CARS+. Go to the Import Fleet Adjustment program and with the cursor at the "OPTION" field, press F4 to upload the file. A browser window will appear. Select the csv file from your PC and click "Send".

III. RUNNING THE PROGRAM

If the file has been previously imported (using the above instructions), the file can be loaded for processing by either typing the file name in Field 1 or searching for it. To search, place the cursor in Field 1 and press F6. A search window will appear on the lower half of the screen. An example is shown below.

OPTION: __ IMPORT IDEAL FLEET 1. From file named Option: _ IDEAL FLEET FILE SEARCH F2=NEXT 8 F4=PREV 8 File Name Create Date 1 idealfleet-101112.csv Oct 11 12:00 2 idealfleet-100312.csv Oct 3 14:20 ** No More Records **

Select the appropriate file by typing the row number.

After loading the name of the file to be processed, place cursor back in the "OPTION" field and press F1 to begin.

To access the program, type IMPIDEAL (RET) at any menu "OPTION:" field or the appropriate number on the Data Import Menu. The screen will then display:

OPTION: IMPORT IDEAL FLEET 1 From File named 1BEGIN 2 3ERASE 4 5 6 7HELP 8

Enter data as follows:

1. FROM FILE NAMED

Enter the full path name of the CSV file to be processed.

PRESS "F1" AT "OPTION:" TO BEGIN .