1. Logon to Transoceanic's website at http://www.transoceanic.com/transtrack, enter your customer number and password.
   
2. You may choose either "view all" or "select", View-All will take you directly to a PO status report starting with the first Purchase Order.
   
3. If you choose “select” … you may also enter a search string in the box to the right. If you leave the box blank, a list of all PO’s will appear for you to choose from. Check off which PO’s you want to look at, and then click “Assemble selected PO’s”.
   
4. You should now see a PO Status report. To view more records in the report, go to the bottom of your screen and select “View Next”.
   
5. To download this into Excel, Click on “Create file” at the bottom of the screen. When the file is finished, the screen will display a message that you can download the file “Here”.
   
6. Right click on the word, “Here” and left click “save target as”. A dialog box will appear, asking you where to save the file. Tell it where you want to save the file.
   
7. Open Excel. Click on File … Open… Go to the location of the file you just saved. Be sure to set “files of Type” to All files (*.*)
   
8. An import wizard will appear in Excel, just click “finish” and your data will be imported into an Excel spreadsheet.
   
9. You can now reformat and/or re-sort the data into any form that best suits your needs.(Tip: Change format to text for MR# and BOX# columns)

How to set filters in Excel for PO Status report.

1. Click on the top left-hand corner of your spreadsheet (between the “A” and the “1”). This will select your entire spreadsheet.
   
2. Click on the “Data” drop-down menu. Then click on Filter … and Auto Filter… This will change all of the column headers to “drop-down” menus.
   
3. You can now click the “down-arrow” on any of the columns and select a report by a specific item in that column.

For example; if you select the “down-arrow” in the Purchase Order column, and then select one of the PO’s in the list, you will then have a report on just that PO.

4. You may also generate a report on multiple PO’s by selecting the “custom…” item in the drop-down list.
   
   This will bring up another selection box. If for example you want to see all PO’s that begin with “123”, change the first box from “equals” to “begins with”. Then in the box to the right, type in 123* (don’t forget the asterisk). Then click “OK”.
   

   You should now have a report on all PO’s that begin with 123.