The video below shows you how to link and use the TATEMS Custom spreadsheet called TATEMS-WorkOrderPartsInventoryInstalledByCustomerbyYearAndInventoryType
This spreadsheet is number 129 and can be found here:
The columns in this spreadsheet are
Customer (From Custom Selected on the Equipment Summary Tab. If you have no customers this would be “In House”)
Year Work Order Parts Installed (from the Work Orders Completed Date)
Inventory Type (from the Parts Inventory screen)
Parts Cost (from the Work Order Parts Screen)
The video above shows you how to link this spreadsheet using Excel 2016 or 2019 and it might also be similar for Excel 2013
If you have Excel 2010 or 2007 then the video here will show you how to link these spreadsheets to your TATEMS data.
Thanks for stopping by!
UPDATE: Version 4.6.24v was released on Oct 1, 2018.
The current update is available here:
In the video below I show you the new Auto Resizing feature we are adding to TATEMS starting with version 4.6.24v (scheduled for release the first week of October 2018)
You may want to go to full screen on the above video to get a better feel for this cool new feature.
This feature is may cause instability of TATEMS on some systems causing unannounced shutdowns of TATEMS in which case you would need to keep the Auto Resizing feature turned off.
We will continue to make improvements to this feature in order to mitigate any instability issues people experience after version 4.6.24v is released.
The feature will be turned off by default.
In the video below I show you how to use Excel 2016 to link the spreadsheet called All Parts Inventory no Grouping to your live TATEMS data.
You can use this video as a guide for to help you link the other over 120 custom spreadsheets we have created for you here:
In the video, I also show you a failed attempt at trying to get Excel 2016 to act like older versions of Excel using the data Legacy options.
I'll keep experimenting with that and post something when and if I can show how to do what I wanted to do.
Here is a quick video to show you the new work order search features coming in TATEMS version 4.6.24
You will be able to search on the Work Order tab or the Work Orders list by
Also, the Work Orders tab and the Work Orders List will display all the work orders costs for the items displayed in the list.
This will make it much easier to find and view specific repairs and services in your work orders.
The video below goes over all 4 Unit Information Reports in TATEMS that are found under Current Equipment Reports and All Equipment Reports Menu Items
Thaks for watching and please let me know if you have any questions.
Here is a new video showing how to use the Cost Per Mile/km Hour report to see Over all costs and miles traveled or hours run over a selected date range
This video goes over the Reminders Popup Screen
One thing I forgot to mention in the video is the enable check boxes on each tab.
If you un-check any of those the TATEMS will not check for that type of reminder and may speed up the Reminders Popup screen queries and loading.
The most computer intensive queries are the lube service queries so those are what usually takes the longest to process when opening the Reminders Popup screen.
The video below shows you how to link and use the new custom spreadsheet number 123.
It is called TATEMS-PartsUsedCountTotalsCustomDateRange
And you can find it and all the other ones available here:
It shows you how to link it and how to change the date range
The video above also shows you how to use a custom repair code.
For example, “Abuse”, and also goes over how to run various reports in TATEMS related to that repair code.
I hope you find it useful….
Let me know if you have any ideas for more spreadsheets.
For some reason in the current version 4.6.23g release of TATEMS the ability to choose All Years for the Lube Service Report and the Repairs Report is Missing.
The All Years feature will be added back in on version 4.6.24
In the meantime here is a work around using the Unit Information With All Equip Data report
This step by step video shows you how to setup a piece of equipment in TATEMS Fleet Management Software.
This video covers the items below and more…
If I left anything out let me know.