 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 |
||||||||||||||||||||||
|
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: TruckReadyDate MaxWeight Mileage GENERAL:
COLUMN BY COLUMN ANALYSIS: Where pre-selection buttons are mentioned below, they do not apply to AutoPostTrucks95.xls, which is a plain spreadsheet. IMPORTANT NOTE. All trucks except Regular Route loads are erased after three days. All Regular Route trucks are erased after 30 days. If your Regular Route trucks are filled earlier, please delete them or ask us to. Top COLUMN A. TruckReadyDate. (Truck 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 truck according to the word you choose. Top COLUMN C. TruckReferenceNumber. (Truck identification) (Not Required) You should use truck reference numbers so your dispatchers can find a truck 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 truck is coming from) (Required) There are three Drop-Down options, Canada, USA and Mexico. Pick one. Top COLUMN E. OriginState. (State/Province your truck is coming from) (Required) Use the Drop-Down list to insert the correct State or Province. Top COLUMN F. OriginCity. (City your truck 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 truck is going to) (Required) There are three Drop-Down options, Canada, USA and Mexico. Pick one. Top COLUMN H. DestinationState. (State/Province your truck is going to) (Required) Use the Drop-Down list to insert the correct State or Province. Top COLUMN I. DestinationCity. (City your truck 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 preferred) (Required) Select preferred load type. The program displays them as below:
Top COLUMN K. PartialLoad. (Whether you want TL or LTL) (Required) Select "Full" (TL) or "Partial" (LTL). Top COLUMN L. LoadContent. (What your preferred load is composed of) (Not Required) A short, one or two word description is ideal for space reasons when it appears on the Truckboards. Top COLUMN M. Vehicle. (Type of vehicle) (Required) Select the vehicle you have available. Top COLUMN N. MaxWeight. (Gross weight you can carry) (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. Top COLUMN Q. Currency. (National currency you will accept as pay) (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 R. Rate. (How much you want to be paid) (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 S. Notes. (Any additional information or instructions) (Not Required) Add any additional relevant information. Top | ||||||||||||||||||||||