| FLEET MENU 1. Vehicle Inventory Control INV 2. Fleet Edit Report FLTEDT 3. Fleet Edit Report 2 FLTEDT2 4. Vehicle ID Report ID 5. License Expiration Report LICEXP 6. Vehicle Presale Report PRESALE 7. Turnback Report TURNBACK 8. Fleet Mix Report MIX 9. VIN Report VINRPT 10. Fleet Snapshot Report SNAP 11. Fleet Mileage Report FLTMILE 12. Excess Mileage Report XSMILE 13. Change Vehicle Number CHGVEH 14. Edit Vehicle Grounding EDITGRND 15. Print Key Tags KEYTAG 16. Physical Inventory Menu PHYSINV 17. Restricted Veh Inv Ctrl INVR |
I. FLEET PROGRAMS
A. VEHICLE INVENTORY CONTROL - This program is used to add a vehicle to your fleet by entering such details as the vehicle I.D. number, license plate, class, model and tank size. Page two of the vehicle record is used to enter optional financial data such as depreciation and loan information. The vehicle record also displays the current status and location of the vehicle as well performance data such as revenue earned and number of days rented each month.
B. REPORTS - Several reports are available, each with a choice of parameters and sorts, allowing for a variety of reports.
II. VEHICLE REPORTS THAT ALLOW SELECTION BY VIN #.
A. INTRODUCTION
The following six reports allow vehicles to be selected by VIN#:
Vehicle Edit Report Vehicle Presale Report
Vehicle ID Report Fleet Value Report
Turnback Report VIN Report
The VIN selection ability provides two different ways to select VIN's:
As an example, number range would allow you to select all VINs whose last 6 digits are greater than 500000.
These two methods can be used in combination so that you can select all VINs with the characters 1MEB and whose last 6 characters are greater than 500000 but less than 800000.
B. THE VIN SELECTION FIELDS ON REPORT SCREENS
The VIN Selection line on the report screens is made up of three distinct fields which are separated by commas. These fields are:
Pattern-match,Start-numeric-range,End-numeric-range
As an example, the following would select the VINs mentioned in the above examples:
1MEB,500001,799999
Although none of the three fields are required, the sequence of the fields is important. Start-numeric-range must follow directly after the first comma even if no pattern match is entered. As an example, the above selection without pattern match must be entered as,
,500001,799999
No spaces are allowed in any of the fields or between any two fields. Leaving all three fields blank tells the report to select all VINs.
C. RULES OF PATTERN MATCHING
The following characters have special meanings in pattern matching:
Character Meaning and examples
^ - (called "up-caret") This character means "starting with". When up-caret precedes a pattern, records will be selected whose VINs begin with the pattern. For example, entering ^1MEB will select all VINs whose first 4 characters are 1MEB.
$ - This character means "ending with". When a dollar sign follows a pattern, records will be selected whose VINs end with the characters that precede the dollar sign. For example, entering 21$ will select all VINs ending with 21.
. - (called "period") This character is used as a placeholder in a pattern. For example, entering ^1..B will select all VINs whose first character is 1 and fourth character is B. In this example, the second and third character can have any value.
[ ] - (called left and right bracket) These characters define a set of characters to match against one (and only one) position in the VIN. As an example, entering ^[1234] will select all VINs whose first character is either 1, 2, 3 or 4.
Within a set, a "-" between two characters means a range of consecutive ASCII characters. For example, ^[1234] could also be entered as ^[1-4].
Within a set, the ^ (up-caret) has the meaning of "not" and is used to exclude characters. For example, ^.[^M] calls for VINs which DO NOT have a M in the second character position. Or entering ^.[^A-D] excludes all VINs with A, B, C, or D in the second position.
* - (called asterisk) This character is used after a period as a placeholder for zero or more character positions. For example, entering ^1.*FP will select all VINs which begin with 1 and which have the characters FP together somewhere else in the 16 character positions. This entry would select a VIN beginning with the characters 1G1FP as well as one with 1FP.
The following are additional examples of some valid and invalid pattern match selections assuming you want to match the VIN 1G3AH35AXDM403854:
^1G3 - Works because 1, G and 3 are the first three characters.
^G3 - Fails because G is not the first character.
G3 - Works because G and 3 occur together somewhere in the VIN.
4$ - Works because 4 is the last character.
44$ - Fails because the last two characters are not 44.
^1..A - Works because 1 and A are the first and fourth characters.
G[0-4]A - Works because there is somewhere a G followed by a character in the range 0 to 4, which is then followed by an A. Note that the set ([]) matches only one position in the VIN. If the VIN had the character string G23A, G[0-4]A would not match because the set [0-4] only matches the character immediately following the G, and then the next character must be an A.
^1[ACEG].[A-Z][^A-GI-Z] - Works and reads like this: 1 in the first position, an A or C or E or G in the second, anything in the third, any letter in the fourth, not an A through G or I through Z in the fifth (leaving only H and the numbers 0 through 9 as acceptable candidates for the fifth position.
D. RULES ON NUMERIC RANGES.
On numeric range selections, leaving the start or end field blank implies that there is no limit on that end of the range. For example, if you specify 100000 as the start-numeric-range and enter nothing for the end, then every number above 100000 will be selected.
The following are examples of some valid and invalid numeric range selections assuming the VIN pattern match field is left blank.
nothing - Valid. This will select all VINs.
,0,999999 - Valid and the same as the first.
,0 - Valid and the same as the first.
,,999999 - Valid and the same as the first.
0,999999 - Valid but probably a keypunching error. Because the zero is before the first comma it is in the pattern matching field. This entry would search for a VIN which had a zero in any character position but whose last 6 characters fell between the range 999999 and 999999.
,567291,289021 - Invalid because the ending range is less than the beginning range.
,D83944,D83999 - Invalid because letters are not allowed in these fields. This selection would have to be made by the following pattern match: D839[4-9][0-9]$
It is possible to construct nonsensical combinations of VIN pattern match and numeric range selections that will cause the program to run without selecting a vehicle. For example, entering "403854$,,400000" is a request for VINs whose last 6 characters both equal to 403854 and yet less than 400000. Because this is nonsense, no vehicles will be reported.