|
The spreadsheet files are designed to closely follow the format of the tariff
page, with (left to right) stations, followed by up to five columns for rates.
Delimited ASCII files of rates are posted on the BNSF web site at the time the tariff item is issued, rather than at the time the rates go into effect. Only one version of an item's delimited ASCII file is available on our site at any point in time... the most recent revision displacing the previous version. There is no Pending/Current complement to the delimited ASCII files. Consequently, users of this data must carefully manage the date and timing issues.
The delimited ASCII files include an 'effective' [firstday] and 'cancel' [lastday] date field which can aid users in managing the timing element of the data. The delimited ASCII files also include a file number field [FILENUM], which can be used to link rate files to the tariff text files. The file number is found on each tariff page in the bottom right hand corner.
Instructions for downloading BNSF 4022
spreadsheet files in delimited ASCII format to your PC.
1. Select the rate item you need from the menu. Use your mouse and click on the item number.
2. After you click your mouse on one of the items, our Internet site will retrieve and display on your screen a bunch of stuff that looks like this:
BURLINGTON,NORTHERN,SANTA FE,RAILWAY,,AUTHORITY,ITEM,STCC,START DAY,STOPDAY,FILENUM,
,,,,,BN-4022-I,-31040-,01-132-XX,09/16/97,12/31/99,I227IG17
,
,,,,*** ,54-107 Cars ,54-110 Cars ,*** ,*** ,,,ORIGIN ,DESTIN ,ORIGIN ,DESTIN,
OCITY,OSTATE,DCITY,DSTATE,Col 1,Col 2,Col 3,Col 4,Col5,ROUTE,NOTES,OPLS,OPSL,ROAD,ROAD,TYPE
COUNCIL BLUFFS ,IA ,GROUP 31040-50B ,XX ,. ,. ,2485 ,. ,. ,001 , ,*22425.00,*00000.00 ,BNSF ,BNSF ,PP
FREMONT ,NE ,GROUP 31040-50B ,XX ,. ,. ,2485 ,. ,. ,001 , ,*21655.00 ,*00000.00,BNSF ,BNSF ,PP
OMAHA ,NE ,GROUP 31040-50B ,XX ,. ,. ,2485 ,. ,. ,001 , ,*21780.00 ,*00000.00,BNSF ,BNSF ,PP
GROUP 31040-01F ,XX ,GROUP 31040-50B ,XX ,. ,2485 ,2405 ,. ,. ,001 , ,*00000.00,*00000.00 ,BNSF ,BNSF ,PP
GROUP 31040-02F ,XX ,GROUP 31040-50B ,XX ,. ,2525 ,2445 ,. ,. ,001 , ,*00000.00,*00000.00 ,BNSF ,BNSF ,PP
GROUP 31040-03H ,XX ,GROUP 31040-50B ,XX ,. ,. ,2485 ,. ,. ,001 , ,*00000.00,*00000.00 ,BNSF ,BNSF ,PP
GROUP 31040-04G ,XX ,GROUP 31040-50B ,XX ,. ,. ,2625 ,. ,. ,001 , ,*00000.00,*00000.00 ,BNSF ,BNSF ,PP
GROUP 31040-05D ,XX ,GROUP 31040-50B ,XX ,. ,. ,2625 ,. ,. ,001 , ,*00000.00,*00000.00 ,BNSF ,BNSF ,PP
GROUP 31040-06D ,XX ,GROUP 31040-50B ,XX ,. ,. ,2560 ,. ,. ,001 , ,*00000.00,*00000.00 ,BNSF ,BNSF ,PP
GROUP 31040-07E ,XX ,GROUP 31040-50B ,XX ,. ,. ,2750 ,. ,. ,001 , ,*00000.00,*00000.00 ,BNSF ,BNSF ,PP
GROUP 31040-08D ,XX ,GROUP 31040-50B ,XX ,. ,. ,2795 ,. ,. ,001 , ,*00000.00,*00000.00 ,BNSF ,BNSF ,PP
GROUP 31040-09D ,XX ,GROUP 31040-50B ,XX ,. ,. ,2865 ,. ,. ,001 , ,*00000.00,*00000.00 ,BNSF ,BNSF ,PP
GROUP 31040-10C ,XX ,GROUP 31040-50B ,XX ,. ,. ,2915 ,. ,. ,001 , ,*00000.00,*00000.00 ,BNSF ,BNSF ,PP |
Do not panic, or be afraid. This is a delimited ASCII file. It will not hurt your screen or your system.
3. Go to your Internet browser's FILE menu and open it up, select SAVE AS... and when prompted, indicate the desired drive letter, path, and file name. We suggest you keep the same file name that we use, which is: ITM99999.txt, and where 99999 represents the individual item number of the data file you downloaded.
4. Start up your Excel or other spreadsheet program after you finish or minimize your Internet session. Under the FILE menu on your spreadsheet program, select OPEN. An OPEN FILE dialog box will appear on you screen. On the OPEN FILE dialog box, note the section where you select a FILE TYPE, the type you should select is TXT. Check the TXT Options button. Make sure that the delimiter selected is a comma. Close the TXT Options menu. Then, on the OPEN FILE dialog box, click on OK. The delimited ASCII file will be converted and read into a spreadsheet.
5. Make any desired cosmetic enhancements you may desire, such as changing the titles to bold, and centering the data in some columns. Some values are proceeded by an asterisk '*' or a " ` " so that the spreadsheet programs will treat it as a set of characters rather than a numerical value. If you remove these marks, in some cases the value could be misinterpreted.
For questions or suggestions (complaints ??) about the use or design of these files, call us at (817) 352-6789.
|
|
