Please Note

36 TO 1296 NEW - 6 CHAR FNSECT FNDRIV DH R1 Y0 1296 A1 1296 TO 46656 FNBODY FNTRIM FNMY 27 36 TO 1296 CA 36 TO 1296 CA FNTRAN & FNTRAN2 FNFUEL 0 AS IS, plus ADDITION field in table for SHORT Manufacturer name Increase to allow extra field volume, plus ADDITION field in table for SHORT Model name AS IS Merge to allow creation of FNMY table, linked to MAN & MOD Increase to accommodate extra field volume for Commercials, Plus SHORT DESC Re-Use to allow creation of FNENG TABLE, linked to FNMAN MERGE TO 1296 FNMAN Re-Use & Increase to allow creation of FNSECT TABLE (Sectors) Actual CC - prefixed with zeros to 6 Characters to allow for engines > 9999 CC Increase to accommodate extra field volume, and reset to make UNIQ CAR & LCV AS IS Merge to allow creation of FNMNTH table Increase to allow creation of FNTRAN2 table - retaining old, simple FNTRAN Engine power rating (bhp/ps defined in FNENG table) Rebuilt as a single table with Drive and Wheel configurations Rebuilt as a single table covering FNCARB & FNFUEL, linking to FNENG table, but can draw Fuel type directly from char1 UK NEW - Country of origin - Will be blank for the forseeable future Re-use to define Vehicle Type - VEHTYP table - Car, Light Commercial, Etc 0128 4 char MERGE TO 1296 A3300 Re-Use & Increase to allow creation of FNWGHT TABLE (Content TBA - No sheet) 123400 ACTCC - NO TABLE FNMOD FNCNTRY FNWGHT FNPOWER FNMTH FLEETNETTABLES2006_sample.xls CODE2006 2 Char 1 Char 1 Char 30 Char 15 Char 1 Char FNBODY STAT FNVTYP BODYDESC BODYSH ROOF 0L E L Platform Cab High Roof Plat HRoof 3 0M E L Platform Cab Medium Roof Plat MRoof 2 1C H L Chassis Double Cab Chass DCab 0 1D E L Chassis Cab ExtFrame Chass Cab ExFr 0 1L E L Chassis Double Cab Chass DCab 0 2L E L Chassis Double Cab ExtFrame Chass DCab ExFr 0 3L E L Van Hi Cube Van Hi Cube 3 3T E L Van TRW Hi Cube TRW HiCube 3 4L E L Platform Cab Plat Cab 0 5L E L Tipper Dropside Tipper D/S 0 6L E L Van Medium Roof Van MRoof 2 7L E L Pickup Double Cab Pickup DCab 0 8L E L Luton Double Cab Luton DCab 0 9L E L Van Extra High Roof Van EXHRoof 4 AC E C SUV SUV 0 AL E L Hard Top H/Top 0 BC E C Convertible Con 0 BL E L Chassis Cab Chass Cab 0 CC E C Coupe Coupe 0 CL E L Chassis Curtainside Curtainside 0 DC E C Coupe-Cabriolet Coupe-Cab 0 DD E C Coupe-Convertible Coupe-Con 0 DL E L Dropside Dropside 0 EC E C Estate Est 0 EH E C Hearse Hearse 0 EL E L Station Wagon S Wagon 0 ES H L Estate Estate 0 FC E L Van Chiller Van Chiller 0 FF E L Van Freezer Van Freezer 0 FL E L Refrigerated Van Van Fridge 0 FZ E L Van Chill/Freeze Van Chill/Freez 0 GL E L Van Long Cube Van Long Cube 0 HC E C Hatchbac Hatch 0 HL E L Van High Roof Van HRoof 3 IL E L Window Van Medium Roof Window Van MR 2 JL E L Dropside Double Cab Dropside DCab 0 FNBODY PROPOSED FNWHL TABLE EXAMPLE 2 Char 1 Char 2 Char 10 Char 2 Char 10 Char 1 Char 20 Char 20 Char 10 Char 10 Char FNDRIV STAT WHLNO WHLLAYOU AXLEN AXLEDR DRIVTY DRIVDESC WHLTYPDESC WHLSH DRIVSH 2H H 4 ********** 2 ********** 2 ********** 4C E 4 2200000000 2 110000000 4 Four Wheel Drive 4WD 4H H 4 ********** 2 110000000 4 Four Wheel Drive FC E 4 2200000000 2 100000000 F Front Wheel Drive FH H 4 ********** 2 100000000 F Front Wheel Drive R1 E 4 2200000000 2 010000000 R Rear Wheel Drive Single Rear Wheel R2 E 6 2400000000 2 010000000 R Rear Wheel Drive Double Rear Wheels DRW SH H 4 ********** 2 100000000 S Four Wheel Steer 4WS R8 E 2 1100000000 2 010000000 R Rear Wheel Drive R9 E 4 2200000000 2 010000000 R Rear Wheel Drive SRW RA E 6 2400000000 2 010000000 R Rear Wheel Drive RB E 6 2220000000 3 011000000 R 2 Axle Rear Drive 6 Whlr RC E 8 2222000000 4 001100000 R 2 Axle Rear Drive 8 Whlr RD E 10 2440000000 3 011000000 R 2 Axle Rear Drive 10 Whlr Allows new types to be added, but all existing vehicles can use first char for current drive types. Examples only **00000000 is to be used solely on historic, non current codes. FLEETNETTABLES2006_sample.xls DRIV CURRENT NO TABLE PROPOSED TABLE EXAMPLE 28 2 Char 2 Char 1 Char 2 Char 6 Char 1 Char 6 Char 1 Char 6 Char 10 Char 10 Char 12 Char 6 Char 6 Char 6 Char 2 Char 10 Char 2 5 Char Read Effect FNMAN FNEN STAT FNFUE BAND POWTyp ACTCC FNVTYP CCSH ENGDES ENGSHFISCALDES FISH STPOW POWSH MM MMDESC FNENGDESC 00 0.0 FO 12 H P0 12 1 1247 C 1.25 75 1.25 01 0.1 FO 16 H P0 16 1 1596 C 1.6 100 1.6 02 0.2 FO 18 H P0 18 1 1796 C 1.8 125 1.8 03 0.3 FO 18 H D0 18 1 1786 C 1.8 D D 82 1.8 D 04 0.4 FO AD H D0 18 1 1786 C 1.8 TD TD 82 1.8 TD 05 0.5 FO AE E D0 20 1 1996 C 2.0 TDci TDci EU3 130 2.0 TDci 06 0.6 FO AF E D0 20 1 1996 C 2.0 TDci TDci EU3 115 115 2.0 TDci 115 07 0.7 FO AG E D0 20 1 1996 C 2.0 TDci TDci EU4 EU4 130 130 2.0 TDci 130 EU4 08 0.8 FO AH E D0 20 1 1996 C 2.0 TDci TDci EU4 EU4 130 115 2.0 TDci 115 EU4 09 0.9 VO A E D0 123 0 12300 T 12.3 XX XX HCV1 CV1 280 280 12.3 XX 280 CV1 10 1.0 VO AB E D0 1234 0 123400 T 123.4 XX XX HCV1 CV2 900 900 123.4 XX 900 CV2 11 1.1 12 1.2 This NEW table is created by RE-USING the THE CURRENT CC free format field 13 1.3 14 1.4 It would create a new table of around 1300 records as above to deal with Historic Models 15 1.5 Is likely to add around 500-600 records per annum thereafter 16 1.6 17 1.7 This shows the followin advanta es - 18 1.8 SHOWS ENGINE DESCRIPTIONS ACCURATELY AND COVERS ALL VEHICLE TYPES 19 1.9 REDUCES DESCRIPTIVE ERRORS, HELPING WITH CONSISTENCY 20 2.0 21 2.1 22 2.2 Examples only 23 2.3 24 2.4 25 2.5 26 2.6 27 2.7 ETC FNENG - FleetNet ENGINE Description table FLEETNETTABLES2006_sample.xls ENG Combination of previous tables 2 char 1 char 20 char 20 char 10 char KFUELC TY FUELCODE FUELDESC FNFUEL STAT FUELDESC FDEL FLSH BC C B Bi Fuel A0 E Hydrogen Injection Hydrog BL L B Bi Fuel B0 E Bi Fuel Injection BiFuel CL L C CNG BiFuel C0 E CNG Injection CNG DC C D Diesel D0 E Diesel CRD Turbo Common Rail CRD DL L D Diesel E0 E Electric NIL Elect EC C E Electric F0 E LPG Injection LPG EL L E Electric G0 E Gas Injection Gas GC C G Gas H0 E Petrol/Elect hybrid Injection Hybrid GL L G GAS I0 E Diesel/Electric Injection D/Elect HC C H Elec/Petro J0 E Petrol Zero Sulphur Injection ZSulph LL L L LPG BiFuel K0 E BioDiesel Injection BioDsl PC C P Petrol L0 E Petrol/Prop BiFuel Injection P/Prop PL L P Petrol M0 E Diesel/LPG BiFuel Turbo D/LPG N0 E Petrol/LPG BiFuel Injection P/LPG O0 E BioPetrol Injection BioP KFDELY TY FDELY FDELDESC P0 E Petrol Injection CC C C Carburettor Q0 E Petrol Carburettor Carb Pet IC C I Injection R0 E Diesel Turbo Turbo TD TC C T Turbo S0 E Diesel Inj Injection D CL L C Carburettor T0 E Petrol HPi High press inj HPI EL L E Cable U0 E Diesel/CNG BiFuel Injection Dsl/CNG IL L I Injection V0 E Petrol/CNG BiFuel Injection Pet/CNG TL L T Turbo Both tables will link to the new FNENG table, but first character can drive stand alone fuel types, replacing existing fuel typ e slot FNFUELLU FNFUEL FNCARBLU FNCAR AND FNFUEL TABLES FLEETNETTABLES2006_sample.xls FUEL 2 Char 1 Char 20 Char 10 Char 2 Char FNMAN STAT MANDESC MANSH COFSALE AA E Asia Asia UK AC E AC AC UK AD E Auverland A-land UK AL E Alfa Romeo Alfa UK AM E Austin Austin UK AS E Aston Martin Aston UK AU E Audi Audi UK AX E Aixam Aixam UK BE E Bedford Bedford UK BH E Bremach Bremach UK BM E BMW BMW UK BR E Bristol Bristol UK BY E Bentley Bentley UK C1 E Cadillac Cadillac UK C2 E Chevrolet Chevy UK CA E Caterham Caterham UK CH E Chrysler Chrysler UK CI E Citroen Citroen UK CM E Coleman Milne Coleman UK DA E Dacia Dacia UK DE E De Tomaso De Tomaso UK DO E Dodge Dodge UK DR E Daimler Daimler UK DU E Daihatsu Daihatsu UK DW E Daewoo Daewoo UK EA E Eagle Eagle UK FB E FBS FBS UK FE E Ferrari Ferrari UK FI E Fiat Fiat UK FO E Ford Ford UK FS E F.S.O.<br><br> F.S.O. UK HO E Honda Honda UK HY E Hyundai Hyundai UK IN E Invicta Invicta UK IS E Isuzu Isuzu UK IT E Isuzu Trucks Isuzu CV UK FNMAN FNMNTH - FleetNet MONTH TABLE INTRO Date NOT RECORDED - KU, & 00 2 Char 2 Char 4 Char 2 Char 4 Char 5 Char FNMNTH FNMO FNMONO YRSH FNYR MTHSH RO 01 0001 80 1980 01-80 RP 02 0002 80 1980 02-80 RQ 03 0003 80 1980 03-80 RR 04 0004 80 1980 04-80 RS 05 0005 80 1980 05-80 RT 06 0006 80 1980 06-80 RU 07 0007 80 1980 07-80 RV 08 0008 80 1980 08-80 RW 09 0009 80 1980 09-80 RX 10 0010 80 1980 10-80 RY 11 0011 80 1980 11-80 RZ 12 0012 80 1980 12-80 S0 01 0013 81 1981 01-81 S1 02 0014 81 1981 02-81 S2 03 0015 81 1981 03-81 S3 04 0016 81 1981 04-81 S4 05 0017 81 1981 05-81 S5 06 0018 81 1981 06-81 S6 07 0019 81 1981 07-81 S7 08 0020 81 1981 08-81 S8 09 0021 81 1981 09-81 S9 10 0022 81 1981 10-81 SM 11 0023 81 1981 11-81 SN 12 0024 81 1981 12-81 SO 01 0025 82 1982 01-82 SP 02 0026 82 1982 02-82 SQ 03 0027 82 1982 03-82 SR 04 0028 82 1982 04-82 SS 05 0029 82 1982 05-82 ST 06 0030 82 1982 06-82 SU 07 0031 82 1982 07-82 SV 08 0032 82 1982 08-82 SW 09 0033 82 1982 09-82 SX 10 0034 82 1982 10-82 FLEETNETTABLES2006_sample.xls MNTH 2 Char 2 Char 2 char 1 Char 1 Char 20 Char 30 Char 25 Char 1 Char 2 char 2 char 2 char 2 char FNMAN FNMOD FNMODGRP FNVYT STAT MODDESC MODLONG MODSH SHOWBODY FNDRIV MODSEQ SUBMODSEQ COFSALE AC 0A 0A C E 212 Convertible 2Dr Conv 2Dr 0 R1 UK AC 0B 0B C E 302 Convertible 2Dr Conv 2Dr 0 R1 UK AC 0C 0C C E Mamba Coupe 2Dr Coupe 2Dr 0 R1 UK AI 0A 0A C E 500.4 Hatch 3Dr Hatch 3Dr 0 FC UK AI 0B 0B C E 500.5 Hatch 3Dr Hatch 3Dr 0 FC UK AI 0C 0C L E Mega LWB LWB 1 FC UK AL 0A 0A C E 147 Hatch 3Dr Hatch 3Dr 0 FC UK AL 0B 0A C E 147 Hatch 5Dr Hatch 5Dr 0 FC UK AL 0C 0B C E 156 Saloon 4Dr Sal 4Dr 0 FC UK AL 0D 0B C E 156 S ortwagon 5Dr S twagon 5Dr 0 FC UK AL 0E 0C C E 166 Saloon 4Dr Sal 4Dr 0 FC UK AL 0F 0D C E GT Cou e 2Dr Cou e 2Dr 0 FC UK AL 0G 0E C E GTV Coupe 2Dr Coupe 2Dr 0 FC UK AL 0H 0F C E S ider Convertible 2Dr Conv 2Dr 0 FC UK AS 0A 0B C E DB9 Volante 2Dr Conv 2Dr 0 R1 UK AS 0B 0B C E DB9 Cou e 2Dr Cou e 2Dr 0 R1 UK AS 0C 0A C E DB7 Volante 2Dr Conv 2Dr 0 R1 UK AS 0D 0A C E DB7 Coupe 2Dr Coupe 2Dr 0 R1 UK AS 0E 0C C E Vanquish Coupe 2Dr Coupe 2Dr 0 R1 UK AU 0A 0A C E A2 MPV 5Dr MPV 5Dr 0 FC UK AU 0B 0B C E A3 Hatch 3Dr Hatch 3Dr 0 FC UK AU 0C 0B C E A3 Hatch Quattro 3Dr Hatch Quattro 3Dr 0 4C UK AU 0D 0B C E A3 Sportback 5Dr Sportback 5Dr 0 FC UK AU 0E 0C C E A4 Avant 5Dr Avant 5Dr 0 FC UK AU 0F 0C C E A4 Avant Quattro 5Dr Avant Quattro 5Dr 0 4C UK AU 0G 0C C E A4 Cabriolet 2Dr Cabrio 2Dr 0 FC UK AU 0H 0C C E A4 Cabriolet Quattro 2Dr Cabrio Quattro 2Dr 0 4C UK AU 0I 0C C E A4 Saloon 4Dr Sal 4Dr 0 FC UK AU 0J 0C C E A4 Saloon Quattro 4Dr Sal Quattro 4Dr 0 4C UK AU 0K 0D C E A6 Avant 5Dr Avant 5Dr 0 FC UK AU 0L 0D C E A6 Avant Quattro 5Dr Avant Quattro 5Dr 0 4C UK AU 0M 0D C E A6 Saloon 4Dr Sal 4Dr 0 FC UK AU 0N 0D C E A6 Saloon Quattro 4Dr Sal Quattro 4Dr 0 4C UK AU 0O 0E C E A8 Saloon Quattro 4Dr Sal Quattro 4Dr 0 4C UK AU 0P 0E C E A8 Saloon Quattro LWB 4Dr Sal Quattro LWB 4Dr 0 4C UK FNMOD NOTAL NOTAL NOTAL 2 Char 2 Char 2 Char 1 char 2 Char 2 Char 4 Char 4 Char 20 Char 2 Char 1 Char FNMAN FNMOD FNMY STAT FNMKYR MYINTRO MYDESC MYDESCSH MODDESC FNBODY FNDRS AC 0A EE 2001 01 212 BC 2 AC 0A EE 2001 01 302 BC 2 AC 0A EE 2001 01 Mamba CC 2 AL 0B IC 2005 05 147 HC 5 AL 0A GG 2003 03 Spider BC 2 AL 0A GG 2003 03 GTV CC 2 AL 0A HD 2004 04 GT CC 2 AL 0A HD 2004 04 166 SC 4 AL 0A GA 2003 03 156 EC 5 AL 0A EB 2001 01 147 HC 5 AL 0B HJ 2005 05 147 HC 3 AL 0 EB 2001 01 147 HC 3 AL 0 G 2003 03 156 SC 4 AS 0 HE 2004 04 DB9 CC 2 AS 0 CF 1999 99 DB7 BC 2 AS 0 ED 2001 01 Vanquish CC 2 AS 0 CF 1999 99 DB7 CC 2 AS 0 HE 2004 04 DB9 BC 2 AU 0 GD 2003 03 A8 SC 4 AU 0 HA 2004 04 A3 HC 3 AU 0 CL 1999 99 TT BC 2 AU 0 CI 1999 99 S6 SC 4 AU 0 CI 1999 99 S6 EC 5 AU 0B HA 2004 04 S4 SC 4 AU 0 EB 2001 01 S4 SC 4 AU 0 EB 2001 01 S4 EC 5 AU 0B HA 2004 04 S4 BC 2 AU 0 FG 2002 02 RS SC 4 AU 0 DG 2000 00 allroad EC 5 AU 0 GD 2003 03 A8 SW 4 AU 0B HF 2004 04 A6 SC 4 AU 0 EB 2001 01 A6 SC 4 AU 0B IE 2005 05 A6 EC 5 AU 0 EB 2001 01 A6 EC 5 FLEETNETTABLES2006_sample.xls MY 2 Char 1 Char 1 Char 1 Char 30 Char 20 Char FNSECT STAT FNVTYP BASECODE SECTDESC BASEGRP 13 E C 1 Micro Car Hatch 3Dr Micro Car 15 E C 1 Micro Car Hatch 5Dr Micro Car 1C E C 1 Micro Car Cou e Micro Car 1E E C 1 Micro Car Estate 3Dr Micro Car 1F E C 1 Micro Car Estate 5Dr Micro Car 1V E C 1 Micro Car Convertible Micro Car 23 E C 2 Su ermini Hatch 3Dr Su ermini 25 E C 2 Su ermini Hatch 5Dr Su ermini 2C E C 2 Su ermini Cou e Su ermini 2E E C 2 Su ermini Estate Su ermini 2S E C 2 Su ermini Saloon Su ermini 2V E C 2 Su ermini Conv Su ermini 33 E C 3 Lower Medium Hatch 3Dr Lower Medium 35 E C 3 Lower Medium Hatch 5Dr Lower Medium 3C E C 3 Lower Medium Cou e Lower Medium 3E E C 3 Lower Medium Estate Lower Medium 3S E C 3 Lower Medium Saloon Lower Medium 3V E C 3 Lower Medium Convertible Lower Medium 43 E C 4 Premium Lower Med Hatch 3Dr Premium Lower Med 45 E C 4 Premium Lower Med Hatch 5Dr Premium Lower Med 4S E C 4 Premium Lower Med Saloon Premium Lower Med 55 E C 5 U er Medium Hatch 5Dr U er Medium 5E E C 5 U er Medium Estate U er Medium 5S E C 5 U er Medium Saloon U er Medium 63 E C 6 Premium U er Med Hatch 3Dr Premium U er Med 6C E C 6 Premium U er Med Cou e Premium U er Med 6E E C 6 Premium U er Med Estate Premium U er Med 6S E C 6 Premium U er Med Saloon Premium U er Med 6V E C 6 Premium U er Med Conv Premium U er Med 7C E C 7 S orts Cou e S orts 7V E C 7 S orts Convertible S orts AA E L A Car Derived Vans 4x4 LCV Car Derived Vans AB E L A Car Derived Vans Box Van Car Derived Vans AC E L A Car Derived Vans Chassis Car Derived Vans AD E L A Car Derived Vans Crew Van Car Derived Vans AE E L A Car Derived Vans Curtainside Car Derived Vans FNSECT TABLE FNTRAN TABLE - UNCHANGED 1 20 6 FNTTYP TTYPDESC TTYPSH A Automatic Auto M Manual FLEETNETTABLES2006_sample.xls TRAN 2 Char 2 Char 2 Char 1 Char 1 Char 1 Char 25 Char 15 Char FNMA FNTRA FNGEAR STAT FNVTY FNTTY TRANDESC TRANSH AA M5 5 E C M Manual 5S d AC A4 4 E C A Auto 4S d Auto4 AC M5 5 E C M Manual 5S d AC M6 6 E C M Manual 6S d 6S d AD MA 5 E L M Manual 5S d AI A1 1 E C A Automatic Auto AI A2 2 E C A Auto 2S d Auto AI A3 3 E C A Auto 3S d Auto AI A4 1 E L A Automatic Auto AL A3 3 E C A Auto 3S d Auto AL A4 4 E C A Auto 4S d Auto4 AL A5 5 E C A Auto 5S d Auto5 AL A6 6 E C A Auto 6S d Auto6 AL A7 5 E C A Seles eed Auto 5S d Seles d Auto5 AL A8 6 E C A Seles eed Auto 6S d Seles d Auto6 AL AS 4 E C A S ortronic Auto 4S d S ortron Auto4 AL M5 5 E C M Manual 5S d AL M6 6 E C M Manual 6S d 6S d AM A3 3 E C A Auto 3S d Auto AM A4 4 E C A Auto 4S d Auto4 AM A5 5 E C A Auto 5S d Auto5 AM M4 4 E C M Manual 4S d AM M5 5 E C M Manual 5S d AM M5 5 E L M Manual 5S d AS A3 3 E C A Auto 3S d Auto AS A4 4 E C A Auto 4S d Auto4 AS A5 5 E C A Auto 5S d Auto5 AS A6 6 E C A Auto 6S d Auto6 AS AT 5 E C A Touchtronic Auto TTronic Auto5 AS M5 5 E C M Manual 5S d AS M6 6 E C M Manual 6S d 6S d AU A1 1 E C A Automatic Auto AU A3 3 E C A Auto 3S d Auto AU A4 4 E C A Auto 4S d Auto4 AU A5 5 E C A Auto 5S d Auto5 FNTRAN2 FLEETNETTABLES2006_sample.xls TRAN2 2 Char 3 Char 1 Char 30 Char 29 Char 25 Char 2 Char FNMA FNTRI STAT TRIMDESC SUBTRIMDESC TRIMSH COFSALE AC 000 E UK AC 001 E CRS CRS UK AC 002 E S/C S/C UK AI 000 E E E UK AI 001 E L L UK AI 002 E SL SL UK AI 004 E UK AL 000 E UK AL 001 E GTA GTA UK AL 002 E Lusso Lusso UK AL 003 E Lusso Final Edition Lusso Final Ed UK AL 004 E Lusso Ti Lusso Ti UK AL 005 E Ti Ti UK AL 006 E Turismo Turismo UK AL 007 E Turismo Special Edition Turismo Spcl Ed UK AL 008 E Veloce Veloce UK AL 009 E Veloce 1 Veloce 1 UK AS 000 E UK AS 001 E 2+0 2+0 UK AS 002 E 2+2 2+2 UK AS 003 E Anniversary Anniv UK AS 004 E Anniversary Volante Anniv Vol UK AS 005 E GT GT UK AS 006 E GTA GTA UK AS 007 E S 2+0 S 2+0 UK AS 008 E S 2+2 S 2+2 UK AS 009 E Vantage Vant UK AS 00A E Vantage Volante Vant Vol UK AS 00B E Volante Vol UK AU 000 E UK AU 001 E Colour Storm Col Storm UK AU 002 E EL EL UK AU 003 E Final Edition Fin Ed UK AU 004 E Limited Edition Ltd Ed UK AU 005 E S S UK FNTRIM table FLEETNETTABLES2006_sample.xls TRIM 1 Char 1 Char 1 Char 2 Char 2 Char 2 Char 2 Char 20 Char 10 Char FNVTYP STAT TESTTYP FIRST SUBSEQMFIRST SUBSEQW VTYPDESC VTYPSH 3 E A 36 12 3 Wheeler 3 Whlr A E A 12 12 Minibus A M/Bus A C E A 36 12 Car Car E E A 36 12 Exec Bus ExecBus L E A 36 12 Light Commercial LCV M E A 36 12 Motorc cle M/C P E A 36 12 Mo ed Mo ed V E V 12 12 Minibus V M/Bus V FNTYP TABLE FLEETNETTABLES2006_sample.xls VTYP 2 Char 1 Char 20 Char 10 Char FNWGHT STAT WGHTRANGE WGHTDESC 00 E Unlisted 05 E 500-599K 500K 06 E 600-699K 600K 07 E 700-799K 700K 08 E 800-899K 800K 09 E 900-999K 900K 10 E 1000-1099K 1.0t 11 E 1100-1199K 1.1t 12 E 1200-1299K 1.2t 13 E 1300-1399K 1.3t 14 E 1400-1499K 1.4t 15 E 1500-1599K 1.5t 16 E 1600-1699K 1.6t 17 E 1700-1799K 1.7t 18 E 1800-1899K 1.8t 19 E 1900-1999K 1.9t 20 E 2000-2099K 2.0t 21 E 2100-2199K 2.1t 22 E 2200-2299K 2.2t 23 E 2300-2399K 2.3t 24 E 2400-2499K 2.4t 25 E 2500-2599K 2.5t 26 E 2600-2699K 2.6t 27 E 2700-2799K 2.7t 28 E 2800-2899K 2.8t 29 E 2900-2999K 2.9t 30 E 3000-3099K 3.0t 31 E 3100-3199K 3.1t 32 E 3200-3299K 3.2t 33 E 3300-3399K 3.3t 34 E 3400-3499K 3.4t 35 E 3500-3599K 3.5t 36 E 3600-3699K 3.6t 37 E 3700-3799K 3.7t 38 E 3800-3899K 3.8t 39 E 3900-3999K 3.9t FNWGHT TABLE FLEETNETTABLES2006_sample.xls WGHT FNCNTRY TABLE 2 char 40 char 40 char 40 char CNTRY CNTRYDESC CAPITAL CNTRYSH AF Afghanistan Kabul Afghanistan AL Albania Tirane Albania DZ Algeria Algiers Algeria AD Andorra Andorra la Vella Andorra AO Angola Luanda Angola AG Antigua and Barbuda Saint John's Antigua & Barb AR Argentina Buenos Aires Argentina AM Armenia Yerevan Armenia AU Australia Canberra Australia AT Austria Vienna Austria AZ Azerbaijan Baku Azerbaijan BH Bahrain Manama Bahrain BD Bangladesh Dhaka Bangladesh BB Barbados Bridgetown Barbados BY Belarus Minsk Belarus BE Belgium Brussels Belgium BZ Belize Belmopan Belize BJ Benin Porto-Novo Benin BT Bhutan Thim hu Bhutan BO Bolivia La Paz Bolivia BA Bosnia and Herzegovina Sarajevo Bosnia & Herz BW Botswana Gaborone Botswana BR Brazil Brasilia Brazil BN Brunei Bandar Seri Begawan Brunei BG Bulgaria Sofia Bulgaria BF Burkina Faso Ouagadougou Burkina Faso BI Burundi Bujumbura Burundi KH Cambodia Phnom Penh Cambodia CM Cameroon Yaounde Cameroon CA Canada Ottawa Canada CV Ca e Verde Praia Ca e Verde CF Central African Re ublic Bangui C African Re TD Chad N'Djamena Chad CL Chile Santiago Chile CN China Beijing China CO Colombia Bogota Colombia

less