Category Archives for "Fleet Maintenance Software"

Video – Custom TATEMS Spreadsheet No. 129 Inventory Type Totals Installed

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!

Video – TATEMS Auto Resizing Coming to 4.6.24v Explained

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.

Video Using Excel 2016 to Link TATEMS Fleet Maintenance Software Spreadsheets

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:

Fleet Maintenance Software Spreadsheets

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.

Video Work Order Search Features coming in 4.6.24

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

Short Description

Detailed Description

Part Number

Part Description

Labor Description

Labor Employee

All Descriptions

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.

Video Unit Information Reports Help

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

  • Unit Information All Equip Data
  • Unit Information All Equip
  • Unit Information All Equip with All Equip Data

Thaks for watching and please let me know if you have any questions.


Video Reminders Popup Help

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.

Thanks Again



Video and Spreadsheet for specific parts counts over date range

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.



How To Setup Your Equipment In TATEMS – Step By Step Video

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…

  1. How to add Equipment
  2. Duplicate Equipment Numbers
  3. Basic Filling in the Equipment Summary Tab
  4. Setting up first lube service (for reminders)
  5. Setting up first 90 Day Inspection (for reminders)
  6. Setting up Inspections and Permits (for reminders)
  7. Adding Filters to Filters Tab

If I left anything out let me know.


Thanks Again,

Marc Ready