2 Quick New Videos… Fixing bad Odometer entries
If you missed it I also posted a Video last week showing you a couple of ways to handle Tools or Equipment that you keep on your Trucks or Vehicles
Fixing Odometer Entry Mistakes.
From a previous tip:
I had a customer call me with a weird problem today.
Whenever he ran his mileage report under Reports-More Reports Report Type: Equipment, then select the report called “Equipment Miles/Km Traveled – Hours Run”
he was getting a reading of -26066 miles traveled.
I did a quick scan of his entries via remote access and could not see what the problem was.
So I download a copy of his TATEMS data file so I could have a better look.
What I found surprised me. In the middle of all his entries he had lower odometer reading for a date of Jan 7 2800 instead of Jan 7, 2008
so the report results was always skewed. He also had a current entry April 1, 2009 that had a lower odometer reading by thousands of miles than the one entered just prior to it.
It's an easy fix but sometimes those miss entered numbers and dates are hard to spot.
So…
If you make a mistake, in order to correct it, you can click on the “Update Odometer and Hours” button.
Then you can click the “View All for This Equipment” button to find your mistake and delete it or change it.
After you have fixed it, click the “Update and Close” button.
In the short video below I demonstrate how to delete or edit An Odometer Enter that was entered incorrectly.
I hope this tip has been helpful for you.
If you have any questions or comments please leave them below.
Have a great weekend!
How To Video for Drive Fuel Efficiency Spreadsheet Report
After 3 weeks we finally got our second car out of the body shop on Friday. Overall they did a nice job. I never thought it would be so hard to go
without a second car for that period of time.
The weather here in Las Vegas is starting to warm up. It's supposed to be 75°F tomorrow; and gas prices are at a low of $3.69 per gallon on the north
west side of town.
Last week I posted spreadsheet number 56: TATEMS-DriverFuelEfficiencyReport spreadsheet and this week I created a quick video to show you how use it and where the data comes from and how to get it into the spreadsheet.
If you have any requests for a spreadsheet we haven't done please post a comment below.
Thanks Again
Marc Ready
PCHelp, LTD
Video Updating Odometer Readings Spreadsheet
When I first mentioned this spreadsheet about a year ago my daughter had just received a $300 ticket.
I'm happy to say she hasn't been in any more trouble with the law and God willing she will graduate from college in May.
I originally created this spreadsheet because one of our clients wanted to see a printout of all odometer entries for all equipment.
Basically it's what's called a cross tab query.
The way it works is for each date you have entered odometer readings, there will be a column with the date at the top except for the first column which has the Equipment Number
So then each row has the Equipment number and all the odometer readings taken.
Like this
| Equip # | 01-10-2010 | 01-17-2010 | 01-24-2010 |
| 101 | 25000 | 25250 | 25500 |
| 102 | 13232 | 13596 | 14025 |
| 103 | 96300 | 97230 | 98356 |
When I created this spreadsheet it displayed only 2010 odometer readings from TATEMS, hence the name:
TATEMS All Odometer Readings Each Date Has Own Column For All of 2010
I wanted to show you how you can change the date range on this spreadsheet to 2011 or any range you want.
So I created this short video for you.
Was this useful for you?