The apps will calculate your 120 driving hours, and ensure you have completed all 20 learning goals. If false entries are made in a digital or paper log book, learner drivers and supervisors can face heavy penalties under the Road and Transport Legislation or Criminal Law. Any hours found to be recorded falsely will be discarded. Feb 25, 2016 Many drivers get a violation for exceeding the maximum numbers of hours in a log book work cycle. Both Canada and the United States have 2 log book work cycles.
What is claimed as being new and desired to be protected by Letters Patent of the United States is as follows:1. A new and improved electronic calculator for determining truck driver log book values comprising, in combination:
a housing with a rectilinear configuration having a top face, a bottom face, and a thin periphery, the housing further having a coupling plate with an inverted U-shaped configuration coupled to and spaced from the bottom face thereof for coupling with a prong fixed to a dashboard of a truck;
a first liquid crystal display situated adjacent a top edge of the front face of the housing and having a first column situated adjacent a left edge of the display for displaying a two digit number, a second column situated adjacent the first column for displaying a four digit number with two decimal places, a third column situated adjacent the second column for displaying a four digit number with two decimal places, a fourth column situated adjacent the third column for displaying a four digit number with two decimal places, and a fifth column situated adjacent the fourth column for displaying a four digit number with two decimal places, wherein the first liquid crystal display is representative of a row of a monthly summary sheet table of an official driver's daily log;
a second liquid crystal display situated adjacent a bottom edge of the front face of the housing and adapted to display a date thereon;
a conventional numeric keypad situated between the first liquid crystal display and the second liquid crystal display adjacent a left edge of the housing, the numeric keypad having a matrix of numeric keys for allowing the entering of numeric signals representative of whole numbers upon the successive depression of the numeric keys and subsequent depression of an enter key;
a plurality of fraction keys situated within a column adjacent the numeric keypad, the fraction keys including a 1/4 key, a 1/2 key, and a 3/4 key for allowing the entering of fraction signals representative of corresponding fractions upon the depression of one of the fraction keys and subsequent depressing the enter key, whereby the numeric keys and the fraction keys may be used in conjunction to enter value signals representative of a combination of whole numbers and fractions;
a plurality of miscellaneous keys situated within a column adjacent a right edge of the housing, the miscellaneous keys including a previous day key for transmitting a previous day signal, a next day key for transmitting a next day signal, and a new month key for transmitting a new month signal;
memory means situated within the housing for storing the signals entered via the keys; and
control means situated within the housing and electrically connected to the first liquid crystal display, the second liquid crystal display, the numeric keypad, the fraction keys, the miscellaneous keys, the memory means, and a power source, the control means adapted to store in the memory means a value signal representative of the number of hours a truck driver worked during a day, to display on the second liquid crystal display a date corresponding to the day, to display on the second column of the first liquid crystal display the hours the truck driver worked during the day, to automatically calculate and display on the third column of the first liquid crystal display a sum of the hours worked by the driver during a first amount of previous days, to automatically calculate and display on the fourth column of the first liquid crystal display a maximum of allowable working hours minus the sum of the hours worked by the driver during the first amount of previous days, and to automatically calculate and display on the fifth column of the first liquid crystal display a sum of the hours worked by the driver during a second amount of previous days;
whereby a user may utilize the miscellaneous keys to view the hours the truck driver worked during the day, the sum of the hours worked by the driver during the first amount of previous days, the maximum of allowable wording hours minus the sum of the hours worked by the driver during the first amount of previous days, and the sum of the hours worked by the driver during the second amount of previous days corresponding to the day displayed on the second liquid crystal display thereby allowing the driver to transcribe the values directly from the first liquid crystal display to a corresponding a row of the monthly summary sheet of the official driver's daily log.
2. An electronic calculator for determining truck driver log book values comprising:
a housing with a rectilinear configuration having a top face, a bottom face, and a thin periphery;
a first liquid crystal display situated adjacent a top edge of the front face of the housing and having a first column situated adjacent a left edge of the display for displaying a two digit number, a second column situated adjacent the first column for displaying a four digit number with two decimal places, a third column situated adjacent the second column for displaying a four digit number with two decimal places, a fourth column situated adjacent the third column for displaying a four digit number with two decimal places, and a fifth column situated adjacent the fourth column for displaying a four digit number with two decimal places, wherein the first liquid crystal display is representative of a row of a monthly summary sheet table of an official driver's daily log;
a conventional numeric keypad having a matrix of numeric keys for allowing the entering of numeric signals representative of whole numbers upon the successive depression of the numeric keys and subsequent depression of an enter key, whereby the numeric keys may be used to enter value signals;
memory means situated within the housing for storing the signals entered via the keys; and
control means situated within the housing and electrically connected to the first liquid crystal display, the numeric keypad, the memory means, and a power source, the control means adapted to store in the memory means a value signal representative of the number of hours a truck driver worked during a day, to display on the first column of the first liquid crystal display a date corresponding to the day, to display on the second column of the first liquid crystal display the hours the truck driver worked during the day, to automatically calculate and display on the third column of the first liquid crystal display a sum of the hours worked by the driver during a first amount of previous days, to automatically calculate and display on the fourth column of the first liquid crystal display a maximum of allowable working hours minus the sum of the hours worked by the driver during the first amount of previous days, and to automatically calculate and display on the fifth column of the first liquid crystal display a sum of the hours worked by the driver during a second amount of previous days a second liquid crystal display situated adjacent a bottom edge of the front face of the housing and adapted to display a date thereon.
3. An electronic calculator for determining truck driver log book values as set forth in claim 2 wherein the housing further has a coupling plate with an inverted U-shaped configuration coupled to and spaced from the bottom face thereof for coupling with a prong fixed to a dashboard of a truck.
4. An electronic calculator for determining truck driver log book values as set forth in claim 2 and further including a plurality of fraction keys situated within a column adjacent the numeric keypad, the fraction keys including a 1/4 key, a 1/2 key, and a 3/4 key for allowing the entering of fraction signals representative of corresponding fractions upon the depression of one of the fraction keys and subsequently depressing the enter key, whereby the numeric keys and the fraction keys may be used in conjunction to enter value signals representative of a combination of whole numbers and fractions.
5. An electronic calculator for determining truck driver log book values as set forth in claim 2 and further including a plurality of miscellaneous keys situated within a column adjacent a right edge of the housing, the miscellaneous keys including a previous day key for transmitting a previous day signal, a next day key for transmitting a next day signal, and a new month key for transmitting a new month signal, whereby a user may utilize the miscellaneous keys to view the hours the truck driver worked during the day, the sum of the hours worked by the driver during a first amount of previous days, the maximum of allowable wording hours minus the sum of the hours worked by the driver during the first amount of previous days, and the sum of the hours worked by the driver during a second amount of previous days corresponding to various days.
6. A method of calculating and transcribing truck driver work log information for a monthly summary sheet table of an official driver's daily log comprising the steps of:
providing a housing with a rectilinear configuration having a top face, a bottom face, and a thin periphery;
providing a coupling plate with an inverted U-shaped configuration coupled to and spaced from the bottom face of the housing for coupling with a prong fixed to a dashboard of a truck;
providing a first liquid crystal display situated adjacent a top edge of a front face of the housing and having a first column situated adjacent a left edge of the display for displaying a two digit number, a second column situated adjacent the first column for displaying a four digit number with two decimal places, a third column situated adjacent the second column for displaying a four digit number with two decimal places, a fourth column situated adjacent the third column for displaying a four digit number with two decimal places, and a fifth column situated adjacent the fourth column for displaying a four digit number with two decimal places, wherein the first liquid crystal display is representative of a row of a monthly summary sheet table of an official driver's daily log;
providing a second liquid crystal display situated adjacent a bottom edge of a front face of the housing and adapted to display a date thereon;
providing a conventional numeric keypad situated between the first liquid crystal display and the second liquid crystal display adjacent a left edge of the housing, the numeric keypad having a matrix of numeric keys for allowing the entering of numeric signals representative of whole numbers upon the successive depression of the numeric keys and subsequent depression of an enter key;
providing a plurality of fraction keys situated within a column adjacent the numeric keypad, the fraction keys including a 1/4 key, a 1/2 key, and a 3/4 key for allowing the entering of fraction signals representative of corresponding fractions upon the depression of one of the fraction keys and subsequently depressing the enter key, whereby the numeric keys and the fraction keys may be used in conjunction to enter value signals representative of a combination of whole numbers and fractions;
providing memory means situated within the housing for storing the signals entered via the keys;
providing control means situated within the housing and electrically connected to the first liquid crystal display, the second liquid crystal display, the numeric keypad, the fraction keys, the miscellaneous keys, the memory means, and a power source, the control means adapted to store in the memory means a value signal representative of the number of hours a truck driver worked during a day, to display on the second liquid crystal display a date corresponding to the day, to display on the second column of the first liquid crystal display the hours the truck driver worked during the day, to automatically calculate and display on the third column of the first liquid crystal display a sum of the hours worked by the driver during a first amount of previous days, to automatically calculate and display on the fourth column of the first liquid crystal display a maximum of allowable working hours minus the sum of the hours worked by the driver during the first amount of previous days, and to automatically calculate and display on the fifth column of the first liquid crystal display a sum of the hours worked by the driver during a second amount of previous days;
entering a value signal by user which is representative of the number of hours a truck driver worked during the first amount of previous days excluding a current day by the depression of the corresponding numeric keys and fraction keys and subsequently pressing enter;
entering a value signal by user which is representative of the number of hours a truck driver worked during the current day by the depression of the corresponding numeric keys and fraction keys and subsequently pressing enter; and
transcribing the values displayed in the columns of the first liquid crystal display to a corresponding a row of the monthly summary sheet of the official driver's daily log.
7. A method of calculating and transcribing truck driver work log information as set forth in claim 6 and further comprising the steps of:
providing a plurality of miscellaneous keys situated within a column adjacent a right edge of the housing, the miscellaneous keys including a previous day key for transmitting a previous day signal, a next day key for transmitting a next day signal, and a new month key for transmitting a new month signal; and
utilizing the miscellaneous keys to view the hours the truck driver worked during the day, the sum of the hours worked by the driver during the first amount of previous days, the maximum of allowable wording hours minus the sum of the hours worked by the driver during the first amount of previous days, and the sum of the hours worked by the driver during a second amount of previous days corresponding to various days.
forPilots
A simple and easy alternative to expensive Pilot Logbook Software.
✓ No subscriptions ✓ 100% Your Logbook for life
✓ No subscriptions ✓ 100% Your Logbook for life
▶ Watch Overview
and see why it's the best Electronic Pilot Logbook Spreadsheet.Perfect for anyone who wants a digital backup of their paper logbook
Excel Pilot Logbook is a universally accessible format for life, editable, and easily customized. Put it on Google Drive, and it’s in the cloud and backed-up for free.
Start from scratch or import your flight hours
Trusted by 4,000+ Pilots.
Hear what they have to say – Excel Pilot Logbook Reviews ↗
- “Thanks again for all the help. As I get deep into inputting my 25+ years of flying into the spreadsheet, I'm sure I'll have more questions. I really am impressed by your quick response time and great customer service, I'll be sure to make sure I relay that on for others to see. ★★★★★”
Patrick
Captain - “I switched to this from some of the more expensive app-based electronic logbooks that require subscriptions and have never looked back. It's brilliant! ★★★★★ ”
Tom
A320 First Officer - “Your logbook is exactly what I was looking for. I wanted to stay clear of LogTen Pro and was planning on making something myself in Excel. I’m reasonably competent at it but when googling for ideas on how to format it all I found your option, which made my life easier and seems well worth the $$. ★★★★★ ”
Matt
PC-12 Pilot - “Love this product! I have been looking for a simple, but well thought out electronic logbook and this is it! I like the Excel format and data entry is very easy. In my opinion, it doesn't get better. ★★★★★”
Rich
Private Pilot - “I have flight time in both NZ and Australia so, I am using your CASA logbook to record ICUS properly. I find the logbook easy to use and well presented. Great product all in all! Cheers ★★★★ ”
Mike
Floatplane Pilot - “Simple and easy to use log book. It does all the add-ups in a simple spreadsheet providing immediate totals. Great as a back up for the ‘official’ log book. ★★★★★”
Gary
Aircraft Owner - “I switched from LogtenPro (didn't like how expensive the yearly subscription was) to this and love it. Westjet Airline Pilot, B-737 Canada. ★★★★★ ”
Brad
B737 First Officer - “So far, it is the best spreadsheet I have ever seen. I made a few changes to the spreadsheet, so it feels like a real logbook. I froze the top header and the first column so that it is easier to see and manipulate the spreadsheet (as per your tip). I think it was a well-spent $50.00. Thanks ★★★★”
Luc
Charter Pilot
That’s okay, you can still access our free e-book every pilot should read – 7 Crucial Things You Must Know Before Starting An Electronic Pilot Logbook.
Topics covered: Rules & Regulations, Paper logbook requirements, Verifying calculations, Cost comparison, Backup tips and Future-proofing.