The video below shows you how to use the custom Lube Service Reminders Spreadsheets number 52 and number 137 and how to link them to the live TATEMS Fleet Maintenance Software database.
You can download the spreadsheets directly from here:
TATEMS-LubeLubeServices-LastDone-NextDue-MileageKmHoursDaysToGoTillDue.xlsx
And you can see all the available spreadsheets here
https://tatems.com/spreadsheets
Thanks for watching!
You should also subscribe to our Youtube channel to get notifications of new TATEMS videos
The video below shows you how to use the custom Lube Service Reminders Spreadsheets number 52 and number 136 (video may show it as 137 but the number order got messed up and this one is actually number 136) and how to link them to the live TATEMS Fleet Maintenance Software database.
You'll also discover how to fix the strange date sorting behavior in Excel
You can download the spreadsheets directly from here:
52. TATEMS-LubeServiceRemindersWithRemainingTimeLeft
136. TATEMS-LubeServiceRemindersWithRemainingTimeLeftAndExtraEquipFields
And you can see all the available spreadsheets here
https://tatems.com/spreadsheets
Thanks for watching!
You should also subscribe to our Youtube channel to get notifications of new TATEMS videos
The video below shows you how to change the equipment number on an existing work order you have already created.
Hint: You have to use the Work Orders List under Forms->Work Orders list to change the equipment number on a work order
Thanks for watching!
You should also subscribe to our Youtube channel to get notifications of new TATEMS videos
The video below shows you how to add an equipment number when the number already exists or change an equipment number to a number that already exists
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
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
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
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
The video below shows what's inside and how to use spreadsheet number 94 called TATEMS Equipment List With Customer Equip Type Odometer And Hours Meter Out Of Service Yes Or No
The video also gives you a tip on how to use the custom Equipment List spreadsheet
This video also shows you how to link to your TATEMS database if you are on a network or the TATEMS data file is in a folder other than
C:\Program Files\TATEMS 2005\
The unique thing about this report is that it gives you the customer and the equipment type along with a few other fields
Here is a list of the fields/columns you'll find in this spreadsheet
Customer Name
Equipment Type
Equipment Number
Description
Year
Make
Model
VIN/Serial
License Plate number
Current Odometer Reading
Current Hours Meter Reading
Out Of Service (Yes or No)
Sort Order Number (Numeric Value)
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