I hope you are doing well.
This is the first in a series of videos I’ll be creating to show you the updates in TATEMS version 4.4.03b
Actually if you have version 4.4.03 then you have 23 of the 25 updates in the list at:
In short a video below I show you update number 25 from that list:
“Added Customer, Location and Dept/Area criteria most fuel log reports”
This update number will change and get pushed down in the future as new versions are released.
So in case you have trouble seeing the video, when you go to Reports->More Reports->Report Type:Fuel Log you now have 3 new criteria you can use to narrow down the equipment you are viewing in most of the fuel log reports. The 3 new criteria are Customer, Dept/Area and Location. Location is not included in the last report on the list. If this is a must have then please feel free to leave a comment below.
On a personal note
I hope your week is going well and if you’re in a cold part of the country or world that you’re keeping warm. Sorry I was too sick last week to create a blog post but I’m finally starting to feel a little better so here goes…
New Feature Request (NOT RELEASED YET AT Time of this post!)
We have had numerous requests come in for TATEMS to automatically show lower interval Lube/Services aka PM’s as being completed when you enter a higher interval Lube/Service.
So here is what we came up with.
Let’s say you have a truck with Lube/Service type called 5000 Mile Oil Change with an interval of every 5000 miles. You also have a Lube/Service 25000 miles Major with 25000 mile interval.
Currently when you enter the 25000 Mile Major you would also have to manually enter the 5000 Mile Oil Change.
Automatically Insert Lower Interval Lube/Services
With the next version upgrade release of TATEMS we have added something new. It’s a new window that will pop-up in the scenario above and display any lower interval Lube/Services for that equipment and allow you choose any or all of them to be automatically entered.
It will also add some text in the lower interval entry in the Notes/Other field that says “Completed during 25000 Mile Major Lube/Service”
This takes those lower interval Lube/services off the reminders popup for you and shows them as completed in the Lube/Service tab.
Just in case you don’t want to see the pop up window asking you if you want to add those lower interval Lube/Services, we had added two check boxes to the Misc User Preferences screen under the tools menu. The first check box says: “Stop Asking to Add Lover Interval Lube Services” and the one below it says: “Always Add Lower Interval Lube Services”.
Does that make sense?
Once I have the new version ready, hopefully in the next few days, I’ll make a video of the feature in action along with some of the other things we’ve added or improved.
Let me know your thoughts.
Thanks Again and Take Care
On a Personal Note
I hope you are doing well this week. Well my wife Karen and my daughter Kelly made it back here to Las Vegas. Their road trip to see my Mother in-law in Arkansas went great. The only hitch was a nail in the tire sidewall that caused them to get a late start home.
They also ran into a snow storm on the way back starting about an hour outside Of Gallup, New Mexico.
Here’s a video couple of pictures:
Obviously , nothing like what the folks back east or up north have been experiencing.
Speeding Up Videos
So I discovered this really cool software that will let you speed up (or slow down) videos. I take quite a few video courses myself and have found this to be a huge time saver. There are 2 programs actually. The first one is free and it requires you to download the video To your computer before you play it. And the second one is under $30 and it allows you to speed up videos that are playing right in your internet browser.
I made a quick demo video of each one below.
The free one that requires you to download your video is called VLC Media Player and you can get it here
The one that costs under $30 has a 7 day free trial and is called MySpeed by Enounce. You can get it here:
Your comments are highly encouraged and so are your social media shares
On a Personal Note
I hope you are doing well this week. My wife Karen and daughter Kelly made it safely on their drive from Las Vegas to AR to visit my Mother on Law for her Birthday today.
Here are a couple pictures from their road trip…
And I think this metal sculpture is suppose the be a bird in OKC
This questions comes up quite a bit so I decided to do a short video (again) on it to show you how to correct those mistakes that someone made when entering Odometer or Hours Meters readings into TATEMS Fleet Maintenance Software.
Let me know if you have any issues with the video above. I’m trying out a new player for people that are restricted from YouTube
Did you ever wonder how much your vehicle costs per mile/km or hour to run?
Bur First On a Personal Note
I hope you are doing well this week. Karen is getting ready to travel back to Arkansas next week to visit her mom along with my daughter Kelly. So it looks like I’ll be babysitting the dogs next week
Calculating Cost Per Mile/Km And Cost Per Hour
Well we added the Cost Per Mile Report in the version 4.4.02 release; and I wanted to show you what it is and how to use it so I made this quick 5 Min video for you.
Step By Step
Here are some quick written instructions and screen shots showing you the steps.
Click on Report->All Equipment Reports->Cost /Mile / Hour
And you will see this screen:
Then you can choose the date range up at the top. Then you can pick and choose any or all of your equipment. You can also choose the view and pint certain groups of equipment like Equipment TypeTruck/Tractor for example.
The next step is to click the check boxes for what you want to include in your report. In the video above I chose Fuel Log, Work Orders, Depreciation Amount, Insurance and License Fees . I left out Repairs Completed and Parts For This Equipment because you would not normally be tracking costs under those tabs when you are using Work Order.
Then click the Preview Report Button and you will see a report that looks like this:
The Beginning odometer and ending odometer readings are the closest reading to the dates you selected and the report shows you those readings and the dates they were captured.
The cost data encompasses the entire date range selected.
You can see that you get cost per mile, Cost per hour (if using hour meter readings) and WO Labor, WO Parts and Work Order overall costs. You also see in this report the total Fuel Costs for that date range and your total over costs to operate that vehicle for that date range.
I hope you like this report and that it helps you with your fleet management.
P.S. Please comment on share this post!
P.P.S. I see the report says Cost Per Mike It’s already fixed on the next version that is in the testing phase.
We have released a new version of TATEMS Fleet Maintenance Software. Now you can attach external documents like pictures, scanned invoices, purchase orders or any document to a Work Order. You can also add attachments to a piece of Equipment without it being linked to a Work Order.
Here are a couple of screen shots:
We have also added a new Cost Per Mile/Km Report under:
Reports->More Reports->All Equipment Reports->Cost/Mile/Hour
Plus a new report that will print out all the data on a piece of equipment over a date range. It can be found under:
Reports->Current Equipment Reports->Unit Information Report With All Equipment Data.
I’ll get some videos posted in the next few days to show you the new features.
You can see a list of the new features and improvements here:
And you can get the update here if you are eligible.
Please let us know if you have any questions or need any help.
In this post I am going to go over how to create a custom spreadsheet that links to your TATEMS data.
I have created and posted a number of these custom spreadsheets that you can download for free at
Hopefully not too technical
This might be a little technical for some, but if you take the time to learn it, I think you’ll like the results.
Here is a video that shows you this process using Excel 2003:
The written instructions
Below explains how to do it using Excel 2010
In Excel click on Data->From Access
Then you will want to navigate to the:
C:\Program Files\TATEMS 2005\
Or it will be in the :
C:\Program Files (x86)\TATEMS 2005
Then choose tblEquipment and click Ok
Then on the Import Data popup choose properties
Then click on the Definition Tab and paste this SQL statement into the “Command Text” box”
SELECT tblEquipment.*,tlkpEquipmentType.sEquipmentType FROM tblEquipment,tlkpEquipmentType WHERE tblEquipment.lEquipmentTypeID = tlkpEquipmentType.lEquipmentTypeID
Then change the “Command Type” from table to SQL then click OK
Then click OK and then click on again on the Import Data screen:
This will show you all the columns for each piece of equipment and the equipment type. You can delete the columns you don’t need and rename the others.
Get any data you want
You can use this technique to grab whatever data you need from the database by using different SQL statements.
You can also use the wizard in Excel to create your queries.
In Excel click on
Data->From Other Data Sources-> From Microsoft Query
Microsoft Access Database*
from the list of data sources.
then click ok.
Then in the “Select Database” window, you will need to navigate to the:
C:\Program Files\TATEMS 2005\
Or it will be in the :
C:\Program Files (x86)\TATEMS 2005
or on your network.
You can use the Drive at the dropdown at the bottom or the network button if needed .
And also check the box that says Read Only
Joining Two Tables Together
Then you will be presented with the Query Wizard window and you can choose the columns inside the tables that store the info you are looking for. You usually want to expand the table called tblEquipment and choose the fields you need. In the srceen shot below I have selected: sEquipNum, sEquipDesc from tblEquipment and sLocation from another table called tlkpLocation. So, if you need info like Location which is stored in another table called:
then navigate to the:
The wizard will automatically join the 2 tables together so that the Location in this case will be linked to the proper piece of equipment. After you have chosen the columns to display then click next and on the following screen you can create your own criteria for the report.
On the next screen you will be able to filter the data if you want to. If not just click next. In the screen shot below I have selected the sLocation field then I chose equals from the first dropdown in the left column and once I selected that then the right hand column populates with the data I want to filter for. I will choose King City from the list in the screen shot below. You can also filter on multiple fields. Once you have selected a field to filter by and created the filter you can move to another field and filter by that field.
Then click next and you can create your own sort order. You can sort by multiple fields, in order of importance. In the screen shot below I will just sort by the sEquipYear field as seen in the screen shot below.
Then click next and you can then choose to either return the data Microsoft Excel to view it or you can view the data and the query in the Microsoft Query window. If you are familiar with SQL then you can manipulate the query to suite your needs. I’ll choose the View data or edit query in Microsoft Query as selected in the screen shot below.
You can now see the data you have selected and once in the Microsoft Query Window you can customize your query even further.
For example you can set the names on the column headers to a more user friendly name by clicking on the column you want to rename and then click on Records->Edit Column. I have slected the sEquipNum column to edit in the screen shots below and will change it from sEquipNum to Equipment #.
Once you have the query the way you want it you click on the little “exit door” icon at the top to return your data to Excel.
After you click the “return data to Excel” icon you will see the Import Data dialog popup and on that screen you just click OK
I hope this gives you a basic idea how to create your own reports in Excel with your TATEMS data.
All The Best!
Well summer is about over and yes I hit my goal and I am able to eat pizza on movie night again
Check out this great video of World record-holding highliner Faith Dickey crossing a slack line between two speeding Volvo trucks.
Will she make it before the trucks reach the tunnel?
How do you get a boat with an 85 foot mast under a 65 foot bridge?
A little ingenuity…
In other trucking, transportation and equipment news:
- Diesel just topped $4 per gallon average in the U.S.
- Trucking Industry looking to add 30,000 more jobs
- DEA goes under cover as driver without trucking company knowing, gets shot 8 times
In TATEMS news we are working on getting a number of new features out the door. For example, the ability to attach items like scanned documents or pictures to a Work order and to the equipment itself.
I hope you have a great week!
All The Best!
Did you like the video I posted last week of our puppy Kiba playing Bang Bang you’re Dead with my daughter Kelly? Here’s the link.Click here and then scroll down to see the puppy..
31 Pounds so far… and counting. My son Matthew bought the P90X DVD’s and we started the regimen on Apr 1, 2012. I have a few days left to complete the 90 program and I have to say I’ve gotten into pretty good shape compared to where I was in addition to losing 31 pounds.
I’m going to go ahead and continue for another 90 days just repeating the phase 3 part of the program and see what happens.
So I have gone from 233 down to 202, my goal is 175 (which would be pretty amazing). By the way, it’s not just the exercise, I have to restrict my calories to 1400 per day.
I gotta say I am going through excruciating Pizza withdrawals and when I pass below the 200 mark it’s time to celebrate with some Papa Johns
Has anyone else gone through P90X or had a similar experience? Leave a comment below, I’d love to hear about it.
So this week I created a short video to show you how to see what you have spent on tires for a specific date range.
Just to reiterate and add to what’s in the video.
Click Reports->More Reports->Report Type:Work Orders
“All Work Orders Parts Totals by Equipment #”
Then enter your date range and then if you just want to see what you are spending on tires enter the word “tire”(without quotes) in the “Part Desc” field and also in the “To” field.
Then click preview.
As long as your part description matches the word you are searching for you will see all of that description of parts installed for that date range.
You can also use a wild card asterisk * before and/or after the “Part Desc” word you are searching for to see see part descriptions that maybe include more that one word and your not sure what the other word was.
Until next time…