We got one of our cars back from the body shop. Hopefully we'll get the other one back by the end of the week.
We filled up the other day for $3.69 per gallon at an Arco station near us here in Las Vegas. Now I'm glad we traded in our 14 MPG Yukon Denali SUV late last year for a 25 MPG Camry. I loved that Yukon though.
We had a request a while back for a somewhat complex spreadsheet/report that would display the Miles Per Gallon or km/L for each driver on each piece of equipment. This would allow you to see if some drivers are costing you more per mile.
So the spreadsheet we created has the following columns:
Driver Started On Equip
Driver Ended On Equip
It is sorted by Equipment Number then Driver Start Date then Sort Order number.
You will need to have Microsoft Excel to use this spreadsheet and have it link to your TATEMS data.
This spreadsheet will link to your TATEMS data if it's in the default installation location on 32 bit Windows.
C:Program FilesTATEMS 2005tatems2005be.mdb
The video link below shows you where the underlying data query is.
The video also shows you what you will probably need to do in order to make it work on your computer if you are not running Excel 2007 or 2010
The video link below will help you to see how to change the path to your TATEMS data if you need to.
I was looking forward to a normal day when the call came in. I just got out of the shower and my wife’s phone was on her nightstand ringing.
“Can I talk to Mom?” my daughter said. I walked the phone down the hall to hand it my wife. As she spoke she stayed calm but it didn’t sound good.
Our daughter had been in an accident. Our Honda was crumpled and un-drivable but Thank God she was not injured, and neither were the people in the SUV.
Fast forward a few hours and my wife and I are on our way to the body repair shop so they can begin repairs. I’m waiting patiently for the pedestrians to cross in front of me before I make a right turn. When suddenly BAM! We get rear ended in a 3 car accident. The car behind us runs into us after she got rear ended.
Thank God for no injuries.
Now our Toyota has to go the body repair shop for repair.
2 accidents in one day can cause you to feel a little shell-shocked. I had not been in an accident since I rolled my Dad’s VW when I was 18.
I'm feeling like, ok when will the next accident happen?
The unexpected can happen at any time, that’s why it’s so important to have insurance.
You need to insure against losing your data too.
Please make sure you back up your data every day. The best practice is to make sure it’s backed up off site.
At a bare minimum get a copy of your data off your computer and onto to an external flash or hard drive.
I made a video that shows you much of what I describe below:
In order to save and backup your TATEMS data, you need to make a backup copy of a file called tatems2005be.mdb.
tatems2005be.mdb is the file that contains all the data you entered into the program.
This file is in the folder
C:Program FilesTATEMS 2005
Or the folder below on a 64 bit system
C:Program Files (x86)TATEMS 2005
TATEMS must to be closed on all computers whenever you backup or restore this file.
If you ever have to reinstall the program, you will need to restore this file back into its folder after reinstalling in order to work with the backed up data.
A couple of additional things need to be addressed here. There is a Backup and Compact feature in TATEMS under
Tools->Backup and Compact.
You can see this feature in action if you go to TATEMS Training Videos then click on the “Backup and Compact data” link
The Backup and Compact feature only allows you to backup the data to the same folder where the data file is housed.
So if the data file is in
C:Program FilesTATEMS 2005
then the backup file will be created in that folder.
The backup file will be Date/Time stamped within the actual file name. It will look something like this:
The 7-19-2006 is the date part and the 09-12 is the time part in 24 hour time (9:12AM).
This can be useful if you want to go back to a “point in time” backup to see where some mistake was made or something went wrong.
These “point in time” backups and any backups for that matter should be moved off the hard drive to a CR-R, a Zip drive, USB drive or memory card for safe keeping.
The “point in time” backups should also be moved off your hard drive because they can quickly start taking up space, especially if you do them on a daily basis.
You can always link to a point in time backup by using the Networking Tool in TATEMS.
Under: Tools->Networking. This will allow you to see what's in a file without having to rename it.
Regardless of which approach you use to backup your data, you should do it on a daily basis.
Our prayers go out to the people of Japan and hope that things will improve soon for them.
I had a request last week to create a new spreadsheet to display the 90 Day Inspections(or user defined number of days) Due or Past Due along with the Location so that they could sort the list by Location
When I created it I also added the Deptartment or Area and the Customer fields in addition to the Location field.
This spreadsheet will link to and display the following columns fromyour TATEMS data:
Dept or Area
Date Insp Completed
Next Inspection Due
Equip Sort Order
Here is a short video to that shows you the Spreadsheet in action.
In the current version of TATEMS “4.3.00” we have added a dropdown to the Accomplished By field so you don’t have to keep typing the same person over and over again, or worry about misspellings. If you choose to add them to the dropdown you will be presented with the personnel form so you can add the new person. You also have the option to not add them to the list and they will still be logged as the accomplished by person or entity for that particular Lube Service.This very short video shows you how it works.
Is this helpful for you? By the way, I have to get a tooth pulled on Wednesday Feb 23rd at 11:30 AM PDT so I may not be available for the rest of the afternoon. Wish me luck!
For most drivers, 14 consecutive hrs. (may continue on-duty/not driving after 14 hrs.);”Regional” allowed one 16-hr. period “weekly” but release from duty required after 16 hrs;Non-CDL w/i 150 miles allowed two 16-hr. periods “weekly” (may continue on-duty/not driving after 16 hrs.).
For all property-carrying CMV drivers(unless excepted):14 consecutive hrs. with release from duty required at end of driving window;16 consecutive hrs. no more than twice “weekly” with release from duty required at end of driving window.
Any on-duty time after 14th hour constitutes use of a 16-hr. period.
Max. on-duty within driving window
Normally 14 hrs; 16 hrs. once per week for “regional” drivers; 16 hrs. twice per week for non-CDL w/i 150 miles.
Proposal not applicable to non-CDL 150 mile short-haul drivers. 13 hrs. during 14- or 16-hour driving windows for others.
Max. driving within driving window
10 or 11 hrs. (Both being considered)
Limit on consecutive hours of driving
May drive only if it has been 7 hours or less since last off-duty period of at least 30 minutes
Proposal not applicable to non-CDL 150 mile short-haul drivers.
“WEEKLY” DUTY PERIOD
Max. on-duty hours
60 hrs. in 7 days/ 70 hrs. in 8 days
34 consecutive hrs.
See “limits on restarts” below.
Limits on Restarts
(1) Must include two periods between Midnight-6 a.m.;
(2) May only be used once per week.
Driver must designate the period being used as a restart
When used as substitute for 10 consecutive hrs. off duty
Two periods: One at least 8 consecutive hrs. in SB; other at least 2 hrs. SB or off-duty. The shorter period does NOT extend the driving window.
Continue 8/2 hr. periods, but apply same new driving, on-duty, and duty-period limits as proposed for non-SB drivers.
DEFINITION OF ON-DUTY TIME
Includes any time in CMV except sleeper-berth.
Does not include any time resting in a parked CMV. In moving CMV, does not include up to 2 hrs. in passenger seat immediately before or after 8 consecutive hrs. in sleeper-berth.
Also applies to passenger-carrying drivers.
“Waiting time” for certain drivers at oilfields (which is off-duty but does extend 14-hr duty period) must be recorded and available to FMCSA, but no method or details are specified for the recordkeeping.
“Waiting time” for certain drivers at oilfields must be shown on RODS or electronic equivalent as off duty and identified by annotations in “remarks” or a separate line added to “grid.”
“Waiting time” is not included in on-duty time or the calculation of the 14 or 16-hr. driving window.
It’s been a crazy couple of months for us. Our landlord stopped paying the mortgage so we had to scramble to find a new place to rent.
Luckily we found a place only about 2 blocks away from where we were so that was nice and the new place has a nice in-ground pool and spa. Something we have not had here in Las Vegas since 2004, other than the vinyl above ground pool we put up last summer. But we are finally getting settled in and happy to be at the new house.
I’ve been working on getting this new TATEMS blog up and running to make it easier to communicate with our clients, and hopefully get some guest contributors as well. If you would like to contribute an article please let me know.
I have a whole bunch of new training videos planned and a multiple new updated of versions of TATEMS planned for 2011.
New spreadsheet and video training
A few weeks back one of our clients wanted to see the quantity count of each filter installed on his fleet. So I created the spreadsheet for him that pulls the live data he needs from TATEMS.
I wanted to show you how to customize it so that you could see quantities installed, not only of particular filters, but any type of part and for any date range.
The search criteria field used is a Part Description of “Filter” and Work Order Date Requested between “1/1/2000” and “12/31/2020”. It only applies to parts/filters used in the Work Orders section of TATEMS Maintenance Software.
The video below shows you the spreadsheet in action. It also teaches you how to customize the spreadsheet; to alter what Part Description you may want to use and to how to narrow the date range.