Case Study

case study

Canute Group saves £300,000 a year with Quartix Pay As You Go vehicle tracking

Request our Brochure

Request the Quartix brochure

Brochure request >>


20/03/2014 - Quartix announces record growth for 2013 and appointment of new chairman

10/01/2014 - Secretary of State for Wales visits award-winning vehicle tracking company Quartix Ltd

01/10/2013 - Quartix Named Powys Business of the Year

More news >>

Media Coverage

31/03/2014 - New mobile app from Quartix

(The Mover)

30/03/2014 - Quartix appoints new chairwoman

(Transport Monthly)

27/03/2014 - Quartix welcomes new chairman

(Builders' Merchants News)

More press coverage >>

Monthly Excel reporting - Improve vehicle utilisation across your fleet

The monthly summary report provides a clear picture of the movement and usage of all vehicles in a specific group, for a calendar month. Groups can be categorised according to vehicle type, region of operation, depot or function.

Details of vehicle usage

The report is structured to provide a separate detailed worksheet for each vehicle in a designated group, allowing easy viewing of the number of trips made, mileage recorded, expected fuel consumption and length of time that it has been away from base - for every day of the month.

Monthly vehicle tracking report

Fleet summary information

In addition to the detailed vehicle-specific worksheets the report also provides two further worksheets and a chart which summarise vehicle usage in terms of mileage covered, and fleet and driver capacity utilisation - which may be calculated in a variety of ways.

Calculating fleet utilisation - time spent away from the specified base location (which may be different for each vehicle)

Travelling time - total time from first to last use of vehicle during each shift.

Additional report features

The report has a user-friendly 'view down' spreadsheet layout, featuring vehicle-specific columns and utilisation is summarised on a daily and monthly basis. Weekends can be included or excluded at vehicle level. Pop-up help boxes describe the way the various features and calculations are used. Excess hours are highlighted - management can specify shift times and any overtime hours will be shown. Monthly recorded mileages can be compared against the vehicle odometer readings. Additional vehicle movement data and analysis can be appended to each monthly vehicle summary page.

Sample Excel reports available online include -