Tag Archives for " spreadsheets "

[Video] Spreadsheet # 100 Monthly Work Order Parts And Labor Totals For Entire Fleet

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

 

[Video] See How Long To Go for All Lube Services with Spreadsheet 137

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

Click here to subscribe to our YouTube Channel

[Video] How To Export/Print Fleet Maintenance Reports To PDF And Convert To Excel Spreadsheet

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

Click here to subscribe to our YouTube Channel

[Video] Using Lube Service Reminders Spreadsheets Nos. 52 and 136

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

Click here to subscribe to our YouTube Channel

Update to TATEMS spreadsheet number 41

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.