Spreadsheet # 100 TATEMSReport-WorkOrderActualPartsCostsAndLaborHoursByGroupedByMonthAndYear
The spreadsheet gives you Monthly Labor Hours and Parts Costs for You Entire Fleet
Checkout the video below to see how to use the spreadsheet and how to link it to your live TATEMS database
Thanks for watching!
Marc Ready
P.S. I would really appreciate it if you could subscribe to our YouTube channel to get notifications of new TATEMS videos
Click here to subscribe to our YouTube Channel
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 print a TATEMS Fleet Maintenance Report To PDF and then how to convert it to an Excel Spreadsheet.
We convert the PDF to Excel using the free online converter PDF to Excel converter tool found here:
https://www.pdftoexcelconverter.net/
If you don't have a PDF printer in your printer selector you can see instructions for installing the free Microsoft PDF driver here:
https://tatems.com/MSPDFPrinter
Or you can get a free PDF print driver for Windows from here:
https://tatems.com/FreeCutePDF
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
I updated spreadsheet number 41 called:
TATEMSWorkOrdersLabor-Parts-Misc-SalesTaxTotals-Displays-2013-2014
You can find this and over 70 other spreadsheets here:
The video above shows you how you can change the date range and filter the data in Excel.
This video above shows you how to link to your TATEMS data file, just in case your data is on a 64bit machine or on a network.
It also shows you how you can re-create the spreadsheet if you get an error trying to link it.
If you need me to change the videos from YouTube to our other video platform leave a comment below and I will.