Category Archives for "Fleet Maintenance Software"

[Video] Parts For This Equipment Tab

In this video, you'll discover the history of the Parts For This Equip tab, how it was originally used and how it can be used now.

I did not mention it in the video but you can also hide this tab and any other unused tabs by going to

Tools->Simplify TATEMS

And then un-checking the tabs you want to hide.

You can also see the Parts For This Equip related reports by going to

Reports->More Reports->Report Type: Parts Installed

There is also the quick report for this tab for the currently selected piece of equipment under

Reports->Current Equipment Reports->Parts Report

Information from this tab is also included in the Unit Information Reports With All Equipment Data under

Current Equipment Reports


All Equipment Reports

It is also one of the choices for totals to be included in the Cost Per Mile/Km / Hour Report under

Reports->All Equipment Reports

And you will also find some custom spreadsheets that will pull data from the Parts For This Equip tab here

TATEMS Fleet Maintenance Software Custom Spreadsheets

When you get to that page you can press F3 on your keyboard to search the keyword “PartsForThis” without the quotes but all run together just like that.

At the time of this post, the following spreadsheets have Parts For This Equip Tab data that you can pull from your live TATEMS database.

42. TATEMSPartsForThisEquipTotalForEachYear

44. TATEMSPartsForThisEquipNumberOfTimesPartNumberUsedAndCost

132. TATEMS-PartsForThisEquipWithAllColumns

I hope this has been helpful to you!



How To Remove Extra Backups From Special Backup Folder

This video shows you how to find and remove the extra backups that are created in the special backup folder.

WARNING: Make sure you are in the correct folder called “tatems2005beBackup” before you delete anything! 

When you create backups in TATEMS you can choose where to save the backup.

In addition to the location that you choose, TATEMS also creates an extra backup that it saves it to a special folder called “tatems2005beBackup” .

Once that special folder called “tatems2005beBackup”  has 30 backups saved to it, you will start seeing a message telling you that you may want to clean out some of the older backups.

I hope this video has been helpful to you!

Thanks Again,


Video Work Order Parts Totals By Equip Num Report

The 7 and a 1/2 minute video below shows you what's inside and how to use the TATEMS Fleet Maintenance software report called:

All Work Orders Parts Totals By Equipment Number

This report can be found in TATEMS under:

Reports->More Reports->Report Type: Work Orders

You will discover how to use the various criteria like:

Date Completed Range (so you can see parts costs over a specific period)

Equipment Number

Part Description and how to use wild cards so you can show costs for specific items like tires or brakes.

Part Number.

Work Order Number

The report gives you the total parts costs for each equipment and a grand total of parts costs of all the equipment included in the report


New Video for TATEMS Version

The video below shows you the new features added to TATEMS version released Mar 22, 2019

This includes a huge time saver, that allows you to edit a work order from the Parts Inventory Screen instead of the old way of having to:

1. Note the Equipment Number Note
2. Note the Work Order Number
3. Close the Parts Inventory Screen
4. Go find the equipment
5. Find the work order
6. Then open the work order for editing.

Now… instead of doing all that, you can just double click on the Work Order in “Where This Part Installed List” on the Parts Inventory Screen

You can get always the latest update here:



New Video For Spreadsheet 130

This video goes shows you how to link spreadsheet number 130 TATEMS-WorkOrdersTotalsByYearPerEquipment  to your TATEMS database using:

Excel 2016 (should also be the same for Excel 2013 and Excel 2019)


Excel 2010 (should also be the same for Excel 2007)

It also goes over how to create the same spreadsheet from scratch if you get an error when you try to link it to your TATEMS data.


You'll also see the spreadsheet columns and how to filter the columns in Excel

the columns are

Equipment  Num

Year (Work Order Completed)

Labor Totals

Parts Totals

Misc Totals



Totals Costs

So to sum it up you will see the Work Order Totals For Each Year For Each Piece of Equipment In Your Fleet




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.

1 2 3