New Equipment Filters Spreadsheet with More Info and Video Tutorials

I hope you’re doing well so far this week

Our puppy Kiba is not doing so well, He got clipped (neutered) yesterday.

The Vet says he has to stay confined for 10 days and he’s already getting antsy.

Gas prices are down to $3.35 per gallon at the Sam’s club nearest to us here in Las Vegas.

It’s supposed to get up to 102 ° F today. It’s cooling down…

Now on to today’s Tip:

I had a request from a client yesterday for a filters report that could be broken down by customer or a list of equipment.

So I created a spreadsheet that will link to your TATEMS data And display the following columns in Excel:

Equip Num
Customer
Location
Dept Or Area
Lube Primary
Lube Secondary
Air Filter
Air Inner
Fuel Primary
Fuel Secondary
Hydraulic
Trans Filter
Water Filter
Other Filters

Once you open it up in Excel you can sort it and filter it anyway you want.

I show you how in this video:

You will need to have Microsoft Excel to use this spreadsheet and have it link to your TATEMS data.

This spreadsheet will link to your TATEMS data if it’s in the default installation location on 32 bit Windows.

C:Program FilesTATEMS 2005tatems2005be.mdb

The video in a previous post below shows you how to change the data path in the spreadsheet if you have Excel 2007 or Excel 2010. Click here to see the previous post.

And the video below shows you what you will probably need to do in order to make it work on your computer if you are not running Excel 2007 or 2010

You can get this newest spreadsheet at our website and it’s called:

TATEMS-EquipmentFilters-WithCustomer-Location-DeptOrArea-Fields

It’s completed for you online and ready to download at the link above or here:

http://tatems.com/spreadsheets

This spreadsheet is number 61 in the list on that spreadsheet page.

I hope this tip has been helpful for you.

Please leave any questions, comments or requests for special Excel Spreadsheets below. If your spreadsheet requests are feasible I’ll get them created and posted in a future TATEMS Tip.

Thanks Again,

Marc Ready
PCHelp, LTD

P.S. We plan to have a updated version of TATEMS in a a day or two.

P.P.S. We are also about ready to release a beta version of our new TATEMS Reminders program. This program runs in the windows notification tray down by the clock separately from TATEMS. It will automatically send out different reminder types via email to as many people as you need to send them to. Let me know if you would like to try out the beta version.

Sharing is Caring