COPS FY12 User Handbook.doc

2Basic Information

3Adding a New User

4Offer Preparation System Screen

4Download Options

5File Download Dialogue Box

9File Formats

10Uploading Offers

10File upload for Group 1

11Upload Results

13Itemized Bidding

14Search page

15Search results page

16Required Information

Basic Information

This site is viewed best using Netscape version 4.0, Internet Explorer version 4.0 or AOL version 4.0 (or higher). Using any browser less than version 4.0 will result in certain features being disabled. You are encouraged to upgrade to a recommended browser version. Upgrades are free at the sites listed below. If you experience difficulties at any time please contact Kristen Jaremback at 703-605-2819.

Internet Explorer: http://www.microsoft.com/windows/ie/download/default.asp Netscape: http://www.netscape.com/ AOL: http://www.aol.com/

To enter the City Pair Offer Preparation System (COPS) you will need a user id and password. Remember the user id and password is case sensitive. Only use lowercase letters and numbers.

This is a new solicitation and all offerors need to reapply for user ids and passwords.

Click the New User button and turn to page two.

NOTE: If you have already done this, Click the Login button, and proceed to the third page of this document

Adding a New User

1) Select from the “Airline” drop down list the name of your Airline

2) Enter the Password assigned to your Airline (if you do not have a password, contact Kristen Jaremback at 703-605-2819.)

3) Fill in completely the “User Information” and “Identification and Password” sections.

The User Id and password will be activated within 24 hours of submission Monday through Friday.

After the New User receives confirmation via e-mail, that the new user ID and Password have been activated, they may login and follow the instructions on page three.

Offer Preparation System Screen

The user has eight choices:

1) “Download CityPairs”

2) “Upload Offers”

3) “Delete Group 1 Items”

4) “Delete Group 2 Items”

5) “Group 1 Error Log”

6) “Group 2 Error Log”

7) “Itemized bidding and modification.”

8) “Account Management”

9) “Logout”

Download Options

If you select the “Download CityPairs” button, you will go to the “Download options” page. You may choose to download the Group 1 or 2 items.

There are two options for each group.

1. “Download All”

2. “File Format”

Select the “Download All” button for each Group to download your current City Pair data.

Error Log – An e-mail will be sent to you telling you whether your file was successfully accepted or not. The e-mail will not contain any information about the file in case of any errors. You will have to log into the system and check the error logs.

Account Management – You will have the capability to change your password.

Any Amendments to the solicitation will be posted to the file that you downloaded from this page. It is suggested that you backup previously downloaded files, since any amendment which you download will overwrite the previously downloaded file on your system.

File Download Dialogue Box

To download the file you must right click on the filename.csv blue hyperlink. DO NOT CHANGE THE NAME OF THE FILE YOU ARE DOWNLOADING!! Depending on the browser you are using, follow the directions below.

Internet Explorer 4.0 Options:

AOL 4.0 Options:

Open

Open

Open in a New Window

Save Target As

Save Target As Print Target

Print Target

Copy Shortcut

Copy Shortcut

Add to Favorites

Add to Favorites

Properties

Properties

Netscape Navigator 4.0 Options:

Back

Reload

View Source

View Info

Set as Wallpaper

Add Bookmark

Create Shortcut

Send Page

Save Link As Save Background As

Copy Link Location

Below is an example from Internet Explorer:

The Save As dialog box appears. A default directory is found and the file name is filled in. If you do not want the file saved in this directory you need to change the desired directory. The default file name automatically displays in the File Name box. Click the Save button and continue to the next page. Again, DO NOT CHANGE THE FILENAME!!

File Formats

Select the File Format button under Group 1.

File Format for Group 1

This screen lists the file layout. These three columns are provided to use with your downloaded City Pairs.

Please note the following:

· Meet_min – Do you meet our minimum requirements for this City Pair? Fill in a “Y” for yes or an “N” for no. If you leave this field blank your offer will not be accepted. If offeror enters “N”, this offer will be rejected.

Click the Previous Page button, located at the bottom of the screen, to return to the “Download Option” screen.

Uploading Offers

Click “Upload Offers”.

File upload for Group 1

The File Upload Form for Group 1 appears.

In the Filename box type in the location of the .csv file to be uploaded, or Click the Browse button and search the computer for the file to be uploaded.

Once the file is ready to send, Click the submit button. If you make a mistake while typing or browsing click the Clear Entries button and start the process over.

PLEASE BE PREPARED TO WAIT AT LEAST 15 MINUTES FOR THIS PROCESS TO FINISH!! YOUR DATA IS BEING UPLOADED, CONVERTED AND VERIFIED.

DO NOT MAKE CHANGES TO THE HEADER ROW (Line item 1) AS THIS ROW IS ALREADY IDENTIFIED IN COPS AS THE HEADER ROW.

After Clicking the submit button a progress meter will display at the bottom of the page to indicate that the file transfer is taking place.

Upload Results

If there are errors during the uploading, an error message will be displayed to the screen. This means that you do not have a field filled in properly. Review the error message and make the necessary correction and either re-upload your file or make the change manually in the Itemized Bidding and Modification portion of the website.

When the file has been successfully uploaded, a confirmation will display the total number of records that have been successfully uploaded.

Click the web browser back button until you return to the Upload Option screen. Click the Upload Group 2 button or the logout button to exit the application. Please remember to exit the application.

IMPORTANT NOTE! VERIFY YOUR DATA!

Your offer will not be accepted if it is not complete. Listed below are some reasons why your offer may have been rejected:

· If your meet_min entry is blank or is anything other than an UPPERCASE “Y”

· If any fare entry has decimals (ie – market_fare, yca_fare, _ca_fare, bns_fare, bns_mkt_fare)

· If your market_fare entry is blank or equal to zero

· If you have no _ca fare or yca fare proposed in a domestic market, except for commuter markets

· If your yca_fare entry has decimals, is blank, is equal to zero

· If there is no market_fare or there is just a _ca _fare in domestic entries, except for commuter markets

· If you have no yca_fare and just a _CA_fare except for commuter markets

· If you do not have an entry in bns_fare but have a bns_mkt_fare entry

· If you have a bns_fare entered but no bns_mkt_fare entry, _ca or yca fare proposed

· If you have put alpha characters in numeric fields and vice-versa

· If your avg_time field is blank, equal to zero, has more than 2 decimals or an alpha character

DO NOT UPLOAD BLANK ITEMS OR YOU WILL GET ERROR MESSAGES!!!

DO NOT MAKE CHANGES TO THE HEADER ROW (Line item 1) AS THIS ROW IS ALREADY IDENTIFIED IN COPS AS THE HEADER ROW.

Itemized Bidding

Click the “Itemized bidding and modification” button.

Search page

You may use any of the search criteria in any combination for more detailed searches. Define the search using the criteria:

Item No: choose from the drop down list an operator then enter a value immediately to the right in both boxes to establish a range

Origin Airport: choose an operator form the drop down list, then enter a code in the box to the right

Destination Airport: choose an operator form the drop down list, then enter a code in the box to the right

Group No: select to search against group 1, 2 or both 1 and 2

Exiting Bids only: if selected, searches against items the airline currently has bids placed on

Search several items: Item numbers do not have to be in order, just separated by “comma”.

Search results page

This page displays the search results from the query defined on the previous page.

Item No: click on a blue item number and the Required Information page for the itemized entry is loaded onto your screen (see next page)

Required Information

Top of page and scroll down to see all of the fields.

After changing the fields you choose, click the “Accept My Offer” button to update the offer.

If your offer has been successfully updated you will see a screen that notifies you of this. Otherwise you will see dialogue boxes instructing you to correct your offer.

City Pair Offer Preparation System (COPS)

User Handbook FY12

� EMBED PBrush ���

ATTACHMENT 3

QMAD-KJ-11-0001-N

_1072264524

_1108280613

_1230628339.bin

_1230701706.bin

_1073976627

_1108280129

_1072269134

_1072261228

_1072262552

_1072260745

_1072261148