Tag Archives for " odometer readings "

[Video] Work Order Total Costs by Repair Code

The video below shows you how to run the Work Orders Total Costs By Repair Code

You'll also discover where to assign repair codes when you create a Work Orders and Add Labor and/or Parts to a Work Order

Thanks for watching!

You should also subscribe to our Youtube channel to get notifications of new TATEMS videos

Click here to subscribe to our YouTube Channel

[Video] Setting Individual Employee Labor Rates For Work Orders

The video below shows you how to set individual employee labor rates in work orders

You'll also discover how to set the company-wide labor rate and how to over-ride the default employee or default company-wide labor rate.

You previously had to click the Use Cost Defaults button just to set the employee rates in a work order.

This has changed and the employee rates are not pulled in automatically.

The video shows you the way these features work after the changes were made in version 4.6.28.011

Thanks for watching!

You should also subscribe to our Youtube channel to get notifications of new TATEMS videos

Click here to subscribe to our YouTube Channel

[Video] How To Use Bulk And Odometer And Hours

The video below shows you how to use the bulk odometer and hours entry screen

It also shows you how to use the export to Excel feature so that you can copy and paste from another spreadsheet and then import it back into TATEMS

Thanks for watching!

You should also subscribe to our Youtube channel to get notifications of new TATEMS videos

Click here to subscribe to our YouTube Channel

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?