Hgv Drivers Log Book Template

Hgv Drivers Log Book Template Rating: 5,8/10 2337 reviews
Track your auto repairs and create a vehicle maintenance schedule using Microsoft Excel®

This vehicle maintenance log template was created based on a user's request for a template to keep track of auto repairs and upkeep. It has all the requested features, including columns for the date of service, work performed, mileage at service, and cost. After creating it I discovered another very handy use. In addition to recording actual vehicle maintenance work, you can use the log to create a vehicle maintenance schedule. Now, before I take the car in for servicing, I'll print out my log with the recommended schedule so that I can tell whether I really need that 'flush and replace every fluid in the entire vehicle' service.

Wholesale case of 25 rediform driver s daily log book driver s log with carbons. Aluminum driver s log book. Vehicle maintenance log book template. Bigroad trucking logbook. Hgv log book for drivers of large goods vehicles to record thei.

Where can I find a recommended maintenance schedule? If you don't have the original service schedule that came with your vehicle, then you can do what I did and go to Edmund.com's Car Maintenance Guide to get the Manufacturer's Recommended Maintenance Schedule. I added a link to that page within the spreadsheet plus some fields at the top of the worksheet for recording some of the information you'll need (like the Make, Model, Year, Engine).

Download

⤓ Excel⤓ Google Sheets

Template Details

LicenseDrivers: Private Use
(not for distribution or resale)

'No installation, no macros - just a simple spreadsheet' - by Jon Wittwer

Description

Almost no spreadsheet experience is required to use this template. The few tips you may need to know are listed in spreadsheet (such as using Alt+Enter to add a new line within a cell). The only calculation is the SUM() formula used to display the total cost.

Thanks to Ryan for suggesting this template via Vertex42's Facebook page.

Related Templates

  • Mileage Log - Track your mileage to calculate your vehicle's average MPG.
  • Auto Loan Calculator - Have your financing figured out before going to the dealership.
  • Home Budget - Use this spreadsheet or one of our many other budget templates for handling variable expenses like vehicle maintenance.

Related Content

Analogue Tachograph
The Tachograph Chart

A tachograph is a device fitted to a vehicle that automatically records its speed and distance, together with the driver's activity selected from a choice of modes. The drive mode is activated automatically when the vehicle is in motion, and modern tachograph heads usually default to the other work mode upon coming to rest. The rest and availability modes can be manually selected by the driver whilst stationary.

A tachograph system comprises a sender unit mounted to the vehicle gearbox, the tachograph head and a recording medium. Tachograph heads are of either analogue or digital types. All relevant vehicles manufactured in the EU since 1 May 2006 must be fitted with digital tachograph heads. The recording medium for analogue heads are wax coated paper discs, and for digital heads there are two recording mediums: internal memory (which can be read out with one of a variety of download devices into a so-called .ddd file) and digital driver cards containing a microchip with flash memory. Digital driver cards store data in a format that can later also be read out as a .ddd file. These files - both those read from internal memory with a download device, and those read from the driver cards - can be imported into tachograph analysis/archival software.

Drivers and their employers are legally required to accurately record their activities, retain the records (files from internal memory and from driver cards must both be retained) and produce them on demand to transport authorities who are in charge of enforcing regulations governing drivers' working hours.

They are also used in the maritime world, for example through the Central Commission for Navigation on the Rhine.

  • 2Regulations
  • 3Analogue tachographs
  • 6Digital tachographs

Origins[edit]

The tachograph was originally introduced for the railways so that companies could better document irregularities. The inventor was Max Maria von Weber, a civil servant, engineer and author. The Daniel Tachometer has been known in the railway industry since 1844.[1] The HaslerEvent recorder was introduced in the 1920s.

Regulations[edit]

For reasons of public safety, many jurisdictions have limits on the working hours of drivers of certain vehicles, such as buses and trucks. A tachograph can be used to monitor this and ensure that appropriate breaks are taken.

In Germany (historical)[edit]

The Verkehrs-Sicherungs-Gesetz (German Traffic Safety Law) of 19 December 1952, made tachographs mandatory in Germany for all commercial vehicles weighing over 7.5 tonnes. Since 23 March and 23 December 1953, all new commercial vehicles and buses must be equipped with the device per law Straßenverkehrs-Zulassungs-Ordnung § 57a.

Tachographs are mandatory for vehicles allowed to carry a total weight of over 3.5 tonnes and vehicles built to carry at least 9 passengers, if the vehicle is used for commercial purposes. They are used to review the driving and rest time of drivers during reviews by traffic standards organizations or accident investigation. A driver must carry the tachograph records with him for all days of the current week and the last day of the previous week that he drove. Companies must keep the records for 1 year. In Germany, § 16 of the work time regulations lengthens this time to 2 years if the records will be used as proof of work time.

In the EU[edit]

EEC regulation 3821/85[2] from 20 December 1985 made tachographs mandatory throughout the EEC as of 29 September 1986. (Regulation 1463/70 amended by regulation 2828/77 made tachographs mandatory by 1 July 1979, reference to these regulations can be found in regulation 3821/85).

A 'European arrangement in regard to the work of driving personnel engaged in international traffic' (AETR, from French 'Accord Européen sur les Transports Routiers') became effective on 31 July 1985.

Regulation 561/2006/EC of the European Union adopted on 11 April 2007[3] specified the driving and rest times of professional drivers. These time periods can be checked by the employers, police and other authorities with the help of the tachograph.

Analogue tachographs[edit]

Most tachographs produced prior to 1 May 2006 were of the analogue type. Later analogue tachograph head models are of a modular design, enabling the head to fit into a standard DIN slot in the vehicle dashboard. This would enable a relatively easy upgrade to the forthcoming digital models, which were manufactured to the same physical dimensions.

The analogue tachograph head uses styli to trace lines on a wax coated paper disc that rotates throughout the day, where one rotation encompasses a 24-hour period. If the disc is left in the head over 24 hours, a second trace will be written onto the first, and so on until the disc is removed. It is an infringement of EU Regulation 561/2006 to use a disc for a period longer than it is designed for. Multiple overlapping traces may still be deciphered in the speed and distance fields, but it is far more difficult for the activity field where one trace can easily be obliterated by another. Analogue tachograph heads provide no indication to the driver of the need to change the disc.

Analogue data is retrieved visually, and can be assisted by manual analysis tools. Analogue discs can also be electronically scanned and analysed by computer, although this analogue to digital conversion process still requires human expert interpretation for best results, due to imperfections in the source disc such as dirt and scratch marks in the wax surface that can be incorrectly read as trace marks.

The analogue chart (EU)[edit]

The analogue chart must be EU type approved. The country of type approval can be found on the rear of the chart, i.e. a mark of E11 would indicate the chart to have been approved in the UK for use in the EU. The chart is manufactured out of heavyweight paper with a black printed face that is thinly coated with a white wax, upon which is printed a number of features. The surface can be scratched or rubbed to reveal the black paper underneath. This enables the traces to be made without the use of ink. The chart features a pear-shaped aperture in the centre, ensuring it is perfectly aligned upon insertion into the tachograph head. There is no facility to prevent it being inserted back to front, where the styli would be prevented from making contact with the wax surface.

The Doctor's Book of Natural Health Remedies: Unlock the Power of Alternative Healing and Find Your Path Back to Health Peg Moline, Editors of Natural Health on Amazon.com.FREE. shipping on qualifying offers. The most comprehensive handbook ever written about vitamins, herbs, supplements, and holistic healing—everything you need to feel better. Breakthroughs CONFIDENTIAL REPORTS by BottomLine: Money Secrets of Multimillionaire Investors. The Doctor's Handbook of Healing Remedies and Medical Breakthroughs; BottomLine on Amazon.com.FREE. shipping on qualifying offers. Good clean copy, no page damage, no writing or highlighting.

The centrefield is used by the driver to store certain handwritten information. This includes the drivers name, the date(s) the disc refers to, the start and end odometer readings and the registration mark of the vehicle.

Three traces are made in the wax surface by the head. These traces are either made by three separate styli or a single multipurpose stylus.

The trace closest to the centrefield is the distance trace. The stylus moves up and down with distance travelled, producing a zig-zag pattern, often referred to as a 'V' trace. A complete deflection is created every 5 kilometres, and therefore each completed 'V' represents 10 kilometres travelled. By counting the zig-zags, the total distance travelled can be calculated and compared against the stated odometer readings in the centrefield. By comparing the end position of the trace for a particular day against the start position for the following day, it can be seen if the vehicle has moved in the intermediate period.

The trace in the central area is the mode trace. The driver's activity is displayed in this area, and is always displayed as either drive, other work, availability or rest. Earlier tachograph heads displayed the mode as a thin line in one of four concentric tracks within the activity band. These heads are known as manual heads as the activity was manually selected using the mode switch. Automatic heads succeeded manual heads, and differ from them in two main areas. Firstly, the automatic head will always display the drive mode when the vehicle is in motion, regardless of the setting of the mode switch. For this reason, the drive mode is no longer available to be selected by the mode switch. Secondly, the activity is displayed on the chart as a sequence of block traces of differing thickness. The rest mode appears as a thin line, availability as a slightly thicker line, other work as slightly thicker again and the drive trace being the thickest.

The trace closest to the outer edge is the speed trace. The disc is preprinted with a speed scale and the stylus produces a mark corresponding with the speed of the vehicle at any given time. It is important that the maximum speed (Vmax) specification of the chart matches that of the tachograph head for the speed to be correctly recorded. It can be expected that a high speed trace will correlate with a tightly-spaced zig-zag pattern within the distance trace.

The disc is preprinted with a 24-hour scale that completes the outer circumference.

The rear face of the chart is printed with a grid that enables the driver to make handwritten additions or amendments to the information on the front.

  • VDO Kienzle 1318

  • Kienzle 1314

  • Veeder Root 1426

    BMW INPA Download software is the Ediabas K+DCAN diagnostic tool.V50.02 BMW Inpa Download software all function actived so no need to pay extra fee to get anthorization. VXDAS.com share BMW INPA download software on mega and also the software install video guide. INPA K+DCAN Interface for BMW Full OBD2 Diagnostic Tool with FT232RL Chip with Switch. Professionally Created BMW Diagnostic Software Ediabas Inpa NCS Expert ETK GT1 TIS DIS V57 V44 Rheingold ISTA-P ISTA+ E-SYS Autodata Tool32 Itool Radar WinKFP EBA TIS WDS SSS Progman SP-Daten NCS Dummy ISPI AiCoder psdzdata Support E, F, G, I, Mini BMW Diagnose. BMW INPA Software is factory BMW diagnostics software that connects to all the systems and modules on BMW cars not just engine like generic scanners, it reads. INPA ediabas 6.4.7 donload,INPA ediabas 5.02 download,INPA 5.0.6 ediabas downloadINPA 6.4.3 ediabas download,BMW INPA 5.02 and Ediabas 6.4.7 download,all of the can work with BMW. BMW Diagnostic Software Paket Ediabas INPA NCS Expert ETK GT1 TIS DIS V57 V44 Rheingold ISTA-P ISTA-D E-SYS ISTA+ Autodata Best View32 Tool32 Itool Radar WinKFP EBA TIS WDS BMW Mini SSS Progman SP-DATEN NCS DUMMY BMW ISPI KSD BMWAiCoder. Ediabas software download.

  • Motometer

Its use in accident investigation[edit]

Apart from enforcing regulations, tachographs are often used in Germany to investigate and punish speeding. This practice was approved by the German high regional court in the 1990s. Also, after an accident, the discs are often examined with a microscope to discover the events that took place at a collision site.

Tampering[edit]

Tachographs can be tampered with in various ways, such as slightly twisting the marker, blocking the path of the arm with a piece of rubber or foam, short-circuiting the unit for short periods, intentionally preventing the detection of gear movement with a magnet, or interrupting the (older analogue) tachograph's power supply with a blown fuse to stop operation completely thus recording no information whatsoever. There is also 'forgetting to insert' the chart when beginning duty. Unauthorized changing of the discs (and then discarding one of the two, so that some activities are 'forgotten') is well known throughout Europe. 'Ghosting' is another common trick when false driver information is entered onto a second chart to give the appearance that there is a second driver present in the cab for long distance runs that cannot be completed within a single driver's daily driving period.

Digital tachographs[edit]

Introduction of the digital tachograph in the EU[edit]

Digital tachographs make tampering much more difficult by sending signals in an encrypted manner. EU regulation 1360/2002 makes digital tachographs mandatory for all vehicles described in the above section Regulations and manufactured after 1 August 2005. Digital tachographs have been required as of 1 May 2006 for all new vehicles for which EWG regulation VO(EWG)3820/85 applies, as was published in the official newsletter of the European Union L102 from 11 April 2006.

Digital tachographs have been implemented in Mexico since 1994, but this is not a federal regulation. The last implementations developed in Mexico have GPS capabilities such as mapping, altitude and location-activated video triggering.

See also[edit]

  • Electronic Logging Devices, comparable device used in the US and Canada

Further reading[edit]

  • Armin Müller: Kienzle. Ein deutsches Industrieunternehmen im 20. Jahrhundert, second edition, Franz Steiner Verlag: Stuttgart 2014, ISBN978-3-515-10669-6

German Book about the invention of the tachograph and the history of the main producer/ seller Kienzle Apparate GmbH (today VDO).

References[edit]

  1. ^[1] Meyers Konversations-Lexikon, 4th edition (1885-1890)
  2. ^EUR-Lex – 31985R3821 – EN
  3. ^'L_2006102EN.01000101.xml'. eur-lex.europa.eu.

External links[edit]

  • Using tachographs – Business Link UK.

Media related to Tachographs at Wikimedia Commons

Retrieved from 'https://en.wikipedia.org/w/index.php?title=Tachograph&oldid=923526301'