Tag Archives for " spredsheet "

Fleet Maintenance Software Spreadsheet Demo Video – Repair Codes Grouped By Year

We just created a new spreadsheet report that links to your TATEMS data and will show you how much you have spent for each repair code for your entire fleet year over year.

Here is a video that shows you the spreadsheet and also how to link it to your TATEMS data .

I did not show it in the video but in Excel if you choose the Data tab and then click Filter you will see a dropdown appear at the top of each column.

If you click on the Repair Code dropdown you can filter to see just a single repair code and to make it easier to view year over year for just that repair code.

You could also sort by the Repair Code Column with would group repair codes for the various years together.

It is number

83 TATEMSRepairCodeTotalsGroupedByYear

at

http://tatems.com/fleetmaintenancesoftware/spreadsheets.cfm

Next I’m going to try to create one that will display each equipments totals for each year. That way you can see if any specific equipment had grown way out of whack.

You could also use the spreadsheet above to see if a particular Repair Code for a specific year looks too high and then go look it up in one of the TATEMS reports I showed you in the video.

Please leave any comments below and like, tweet or plus 1!

Thanks Again