Cartell Carstat GUI User Manual v2.0
Contents
1. Vehicles All fields are tailored to each type of vehicle this means that some fields may not be available on some types of vehicle For example the field named CO2 band does not occur Cartell Carstat GUI User Manual v2 0 7 in the LCV HGV statistical report however it appears on the Cars Only statistical report as the CO2 band is relative to Cars only in this particular circumstance Location Display On the Location County selection field click Display four options will be displayed Table Graph Pivot Map Options for Location County are displayed Table Graph Pivot Map Location County Table Graph Pivot Map Location County gt Number DUBLIN 1275710 CORK 488270 LIMERICK 182487 GALWAY 179999 LOUTH 154665 TIPPERARY 153351 KILDARE 145522 DONEGAL 134588 Filter Click Filter a choice of twenty six counties will be listed Select the counties you need for your query Location County Select filters DUBLIN CORK LIMERICK GALWAY LOUTH TIPPERARY Cartell Carstat GUI User Manual v2 0 8 Click Display and the four available Table Graph Pivot Map will be displayed Table This shows the data selected in tabular form with information displayed from the different fields already chosen Select Display and the table is the first to be displayed Example shows the number of 2010 red KIA Rio models in County Kildare Location County Table Graph Pivot Map2. disable the user accordingly Cartell Carstat GUI User Manual v2 0 12
3. Cartell Carstat User Manual Logging In Navigate to www cartell ie and click Trade Users on the top right Trade Users corner of the screen Enter your username and password to access Cartell Trade services On the top right there is a tab for Carstat Click Carstat to access the Carstat Fleet intelligence page There are 4 main sections Cartell Carstat Fleet Intelligence Live Vehicle Statistics New Vehicle Statistics Used Vehicle Statistics All Vehicles Cars Only a amp Commercial LCV HGV Imported Vehicle Statistics amp All Vehicles aA Cars Only a amp Commercial LCV HGV Live Vehicle Statistics Irish Carparc statistics showing vehicles that are currently live New Vehicle Statistics Irish Car Parc for all new vehicles registered Used Vehicle Statistic Irish Car Parc statistics showing all sale transactions for a selected period Imported Vehicle Statistics Irish Car Parc statistics for all imported transactions for a selected period Within each section there are 3 sub sections which include the following All Vehicles Statistics for all vehicles including Car LCV HGV Buses Motorcycles Agricultural Vehicles etc Cars Only Statictics for cars only determined by Tax Class Private Taxi Hackney Commercial LCV HGV Statistics for all Light Commercial Vehicles LCV and Heavy Good Vehicles HGV determined by Tax Class Goods Cartell Carstat GUI User Ma
4. amp Download CSV A Location County Number X KILDARE 7 Total Graph displays the data selected in a linear format and compares it to other possible choices To select the graph option click Display followed by the Graph icon Comparison of 2010 red KIA Rio models from 5 different counties Location County Table Graph Pivot Map Download CSV DUBLIN KILKENNY 10 TIPPERARY E total 7 pe ic MEATH 9 KILDARE 7 0 11 22 33 44 E total Pivot enables the User to breakdown the search even further once in Location County To do this select Display under the Location County heading then select the Pivot tab This is followed by a drop box listed with possible pivot options to choose from and will refine the search even further These include options from all other data fields like Body Type Fuel Type etc Cartell Carstat GUI User Manual v2 0 9 Pivot Tab Table Graph Pivot Map amp Download CSV Pivot Location County on Year of Sale Month of Sale Detailed Sale Type Trade Sales Manufacturer 3 IV r Model to pivot you Fnnine Canarity query on List of data fields Once you have selected the data field to pivot a pivot CSV will be downloaded to your PC A pivot csv can be downloaded for any 2 queries to compare For example comparing Models by Registration Year Map an illustration of the Island of Ireland with all counties separated individ
5. cial B Premium Tax Class tax category the vehicle is assigned Private Taxi Hackney Number of owners the total numbner of owners Location County the location to where vehicle is registered within the country Imported the number of vehicles registered in Ireland after been registered abroad Detailed Sale Type this shows from and to whom the vehicle was sold Garage to Garage Private to Garage Garage to Company etc Cartell Carstat GUI User Manual v2 0 2 Selecting Fields When choosing fields there are two options When Display is selected it will display the figures from the field selected For example if we select the Display icon for the Manufacturer field all Manufacturer data will be displayed in descending order Table Graph Pivot amp Download CSV Manufacturer gt Number hi VOLKSWAGEN 62837 TOYOTA 58847 FORD 54859 NISSAN 38027 RENAULT 36022 OPEL 34034 HYUNDAI 32969 SKODA 30384 AUDI 21188 Biv 19609 KIA 19389 PEUGEOT 15536 MERCEDES BENZ 11162 SEAT 11038 MAZDA 9976 CITROEN 7535 HONDA 6486 YVOLYO 6288 By selecting Filter the list of options will appear for that field For example if we select Filter on the Model data field a list of Models will be displayed This allows the User to select the Model required or select multiple Models Click Apply to create your query Select filters AVENSIS COROLLA YARIS AURIS RAV 4 Drop box with list of AYGO options
6. enced when choosing Fuel Type Some Models in the Manufacturer s line up may be processed under separate models even though it is possible the models are the same This may occur when selecting a model of vehicle from the list of Models an example of this would be when choosing a Volkswagen Model When choosing a Golf the User must also click various types of Volkswagen Golf available within the list to gain a more accurate reading of the data Otherwise the data will be incomplete and it will not account for all Volkswagen Golf models in the database In this example the User should scroll through the list of Volkswagen models available and include all possible models of Volkswagen Golf including Golf Golf 1 9D Golf 1 6 TDI For example see image below 3 models of Golf chosen from the selection of Volkswagens to include all Golfs in the range Model Select filters GOLF IIL F 4 1b GOLF 1 6 TDI GOLF PASSAT POLO BORA JETTA BEETLE Cancel Month and Year of Sale It is recommended that when clicking between month of sale and year of sale that year of sale is first choice over month of sale The reason for this is when choosing a month the system automatically selects all years available which may hinder the accuracy of the search It is advised that Year is the first of the two selected as it will narrow the list of Months to just that year years selected giving a more accurate search Different Fields for Different
7. f l h Calibri li FA A FE Co py dbase ZF Format Painter P 4 U H 7 27 dd Clipboard Font J23 X fe A B 1 Name Cars Only 2 Model Number 3 FOCUS 181089 4 GOLF 165779 5 COROLLA 161096 6 PASSAT 145995 7 AVENSIS 128749 8 ASTRA 120566 9 FIESTA 99325 10 CORSA 91718 11 MICRA 91599 12 POLO 90571 Cartell Carstat GUI User Manual v2 0 11 Logging Out When finished the User can logout of their Carstat account to stop non account holders from entering their account and tampering with any previous searches or any saved queries on the account To successfully Logout click the Logout icon located at the top right of the Cartell Carstat Fleet intelligence page or alternatively at the top right of the Statistical report page The logout button is blue in colour and reads LOGOUT across the icon See the image below oe ne Logout Tab tell i ca rtel LIC LO Ca r Trade 5 Carstat Home My Services Help Cartell ie Statistical Report Cars Only Live Fields Saved Queries CER No saved queries Model Engine Capacity Current Query Litres Field Value Actions No filters selected Fuel Type Note All users must have their own login Do not share your login credentials with anyone If there is a requirement for a colleague to access a Cartell service please ask them to contact Cartell at info cartell ie to obtain their own login credentials Please also advise us should an employee leave your company so that we can
8. fields Pr Body Type Fuel Type DIESEL x amp Transmission Manual x Z Transmission Body Type ESTATE x Y Doors Display Filter ED fa PEE i x E Colour Save Que Clear All oe Segment Delete Data Field Edit Data Field Cartell Carstat GUI User Manual v2 0 4 The Current Query can then be saved after the User has successfully selected all the fields by choosing the green icon below the Current Query list marked Save Query Alternatively the User also has the option to clear all fields by choosing the red icon marked Clear All These options can be seen in the Images below B save Query Clear All Saved queries These are held in storage and when clicked will display three options for the User 1 Apply when clicked the previously saved query will appear on the screen with each field appearing below 2 Edit Name the user is given the option to change the name given to the saved query in the past 3 Delete the User can delete the saved query altogether and it will no longer be stored in the saved query section These options can be seen in the Image below VW Golf Registration Year 2013 and Detailed Sale Type undefined and Manufacturer undefined and Model GOLF Apply Edit Name Close Editing Name click Edit Name from the options list a drop box will appear below the three options and a new name may be selected e g Golf to apply the new name click the Update button
9. found at the end drop box This can be seen below VW Golf Manufacturer VOLKSWAGEN and Model GOLF and Year of Sale 2012 Enter anew name Apply Edit Name Delete Update Cartell Carstat GUI User Manual v2 0 5 Deleting the Query when deleting the query the User should select the Delete tab shown on the image above This will be followed by another drop box showing a screen displaying Delete Query When you are sure of deleting the query simply click Delete as shown below Delete button Delete Query A Are you sure you want to delete your saved query Passat Cancel Delete Filtering Process When filtering through each field some options may not include all possible vehicles therefore some extra categories must be chosen to allow for a more accurate breakdown of the field Example When filtering for a Hybrid powered vehicle click Fuel Type Hybrid However alternative options like Petrol Electric and Diesel Electric should be selected as these may also be considered as Hybrid powered vehicles See Image Below Select all options that could be a Hybrid Fuel Type Select filters PETROLV ELECTRIC HYBRID DIESEL ELECTRIC PETROL ELECTRIC ELECTRIC PETROL amp GAS FLEXIFUEL GAS HYBRID B Cancel Apply Cartell Carstat GUI User Manual v2 0 6 When filtering through Manufacturer Models the User may come across the same issue experi
10. in field Model Cancel Apply Cartell Carstat GUI User Manual v2 0 Queries After a field is selected it is then saved as a Current Query on the right hand side of the screen this is to ensure the user knows what they have chosen from the fields available However each query can be Deleted or Edited individually by selecting the icons displayed under the heading of Actions to the right of each selected field Delete ried gt X Z A Edt ried The Delete Field option marked by the red X will cause the chosen query to disappear completely The Edit option will allow the user to customise the query further or change the previous selection When this option is clicked the drop box for that field will appear once more To customise simply chose another option within the field and click apply at the bottom right To change it completely click the X marked beside the chosen query it should then disappear leaving the User with a number of options for that field in the drop box below Once the User makes their choice successfully they may click Apply once more to continue with the new search Statistical Report Cars Only New Fields Saved Queries Registration Year Av Golf A Ford Focus Detailed Sale Type Manufacturer Current Query Model Display Filter Ce Field Value Actions Engine Capacity Registration Year 2012 x List of Litres Model OCTAVIA x amp possible Fuel Type Manufacturer SKODA x amp
11. nual v2 0 1 Statistical Report Once a sub section is selected the user will see the Statistical Report page where the user will be given a number of options These options help to filter down to the query required before displaying the results List of possible fields Fields Saved Queries SEa No saved queries Model Engine Capacity Current Query Lires Field Value Actions E No filters selected Body Type Transmission Doors Colour Registration Year CAIRand ini cin The most common fields are Manufacturer Volkswagen Toyota BMW etc Model Passat Land Cruiser 520 Litres engine size measured in litres 2 0 1 4 2 5 1 8 etc Fuel Type required power source to run vehicle Diesel Petrol Electric etc Engine Capacity engine size measured in Cubic Centimetres 1868cc 2991cc 1193cc etc Body Type size shape of vehicle Saloon Hatchback Estate etc Transmission type of Gearbox in the vehicle Automatic Manual etc Doors numbers of access points into out of the vehicle 3 4 5 Colour paint colour of the vehicle Silver Black Green Red Registration Year year the vehicle was registered 2012 2007 2010 2006 etc CO2 Band the category assigned to the vehicle depending on emissions released from the running of the vehicle A4 B1 C D etc Segment category selected for vehicle depending on the size and class of the vehicle A Sports Commer
12. ually When the cursor is hovered over each county the number of vehicles based on the selected query will be displayed for that county Table Graph Pivot Map Options List Kildare 7 No of Vehicles f Displayed County Ae s EA pA nr T EF oe aa ad To select the Map option Click Display followed by the Map tab this will display the illustration of Ireland and also the number of vehicles in each county refined by the selected fields Cartell Carstat GUI User Manual v2 0 10 Download CSV Comma separate value file CSV is available when Display is clicked in any of the fields within a statistical report Downloading the CSV file allows the User to download the information about car statistics in an Excel format To download a CSV file Click Display on any fields whether other fields have been selected or not and a drop box will appear When the drop box appears it will carry with it a green box in the top right corner of the drop box Click on the Download CSV box and an Excel file with all the relevant statistics will be downloaded See image below Green box to download CSV Manufacturer Table Graph Pivot Manufacturer Number v VOLKSWAGEN 486936 TOYOTA 482591 B FORD 433885 Table of Statistics NISSAN 317659 OPEL 300719 When the download is complete the statistics will appear in a spreadsheet See image below FA 9 cols Home Insert Page Layout Formulas Da to Cut a
Download Pdf Manuals
Related Search