 Overview | Important | General | Column Analysis | Important Note Columns: A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T |
||||||||||||||||||||||
|
OVERVIEW:
IMPORTANT:
Do this by highlighting them and pressing your Delete key, or by highlighting the numbers 2, 3 and 4 in the numbered column at the left side of the spreadsheet and clicking "File" and "Delete" on the toolbar at the top left-hand corner. As explained above, these columns are filled in by hand. Click on the ivory/sand-colored< headers to bring up instructional notes. Other columns are also filled in by hand, but according to specific patterns. The details are given below and if you make a mistake, an error message will appear with a correct example. If you can't make make an entry work, cut and paste one from the examples and adjust it to what you want. You can identify these columns by a tan/brown colour. They are: LoadReadyDate MaxWeight Mileage NoOfDrops GENERAL:
COLUMN BY COLUMN ANALYSIS: Where pre-selection buttons are mentioned below, they do not apply to AutoPostLoads95.xls, which is a plain spreadsheet. IMPORTANT NOTE. All loads except Regular Route loads are erased after three days. All Regular Route loads are erased after 30 days. If your Regular Route loads are filled earlier, please delete them or ask us to. Top COLUMN A. LoadReadyDate. (Load Ready Date) (Required) This column includes a date and a time. Select COLUMN A, Line 2, click in the field and you will see the date and time in the window above. The format is: 28/09/2000 10:45:00 PM This may vary, depending on how your computer time clock is set up. Top COLUMN B. Action. (Program Posting instructions) ("Add" is Required) You can type "Add", "Update" or "Delete" by hand in Excel 95 or pick one as an option in Excel 2000 and Excel 97. This tells the program to deal with each load according to the word you choose. Top COLUMN C. LoadReferenceNumber. (Load identification) (Not Required) You should use load reference numbers so your dispatchers can find a load quickly when they get an inquiry. Unless you do so, you will be unable to use the "Delete" and "Update" functions in Column B. Top COLUMN D. OriginCountry. (Country your load is coming from) (Required) There are three Drop-Down options, Canada, USA and Mexico. Pick one. Top COLUMN E. OriginState. (State/Province your load is coming from) (Required) Use the Drop-Down list to insert the correct State or Province. Top COLUMN F. OriginCity. (City your load is coming from) (Required) Type this in by hand as there are too many cities in North America to list them all on a Drop-Down list. Abbreviations are appreciated if a city name is unduly long, like Washington Court House, which is still recognizable as Washington Ct Hse. Top COLUMN G. DestinationCountry. (Country your load is going to) (Required) There are three Drop-Down options, Canada, USA and Mexico. Pick one. Top COLUMN H. DestinationState. (State/Province your load is going to) (Required) Use the Drop-Down list to insert the correct State or Province. Top COLUMN I. DestinationCity. (City your load is going to) (Required) Type this in by hand as there are too many cities in North America to list them all on a Drop-Down list. Top COLUMN J. LoadType. (Category of Load) (Required) Select the load type. The program displays them as below:
Top COLUMN K. PartialLoad. (TL or LTL) (Required) Select "Full" (TL) or "Partial" (LTL). Top COLUMN L. LoadContent. (What the load is composed of) (Not Required) A short, one or two word description is ideal for space reasons when it appears on the Loadboards. Top COLUMN M. Vehicle. (Type of vehicle) (Required) Select the vehicle required. If you are unsure what sort of vehicle you need, select "Unspecified Rig". Truckers will know from your load what type of vehicle is required. Top COLUMN N. MaxWeight. (Gross weight to be carried) (Not Required if no weight is to be inserted) Type in a number. You can choose pounds or kilograms. You can optionally use commas. Top COLUMN O. WeightMeasure. (Measurement unit for your load weight) (Not Required if NaxWeight not entered) You have two choices, Lbs (Pounds) or Kg (Kilograms). Note that Kilograms are used in Mexico, while both are used in Canada. Top COLUMN P. Mileage. (Mileage estimate) (Not Required) If you know the mileage involved, you can enter it. Mileage is important for the trucker so he can calculate the pay rate. If you don't know the mileage, the trucker will calculate it. Top COLUMN Q. NumOfDrops. (Number of Deliveries to be made) (Not Required) Type in the number of deliveries to be made during the journey. Top COLUMN R. Currency. (National currency you will pay in) (Not Required if no pay rate is to be specified) It is important that you use the currency codes below because all three countries use the "$" symbol for their national currencies, but they are not "at par" (the same value). You have three options, USA$ (American dollar), CAD$ (Canadian dollar) and MEX$ (Mexican peso) Top COLUMN S. Rate. (How much you are prepared to pay) (Not Required) Enter a payment figure here if you are offering a good rate. If you prefer to see what quotes you get, leave this blank. Don't put a $ sign in as the Currency column will add the selection you chose. Top COLUMN T. Notes. (Any additional information or instructions) (Not Required) Add any additional relevant information, such as where an extra stop will be, regular route timing details, Who is taking care of national boundary documentation, etc. Top | ||||||||||||||||||||||