Monthly Archives: May 2011

New Spreadsheet Shows All Equipment PM History

I pray that you are staying healthy and safe with all these disasters going on in the world.

On Monday we attended my daughters college graduating ceremony.

It was great to see her finish college, now on to her career in Cardiac Sonography.

Know any doctors or hospitals hiring? 🙂

Nice to see that gas has been getting a little cheaper. It's come down to $3.67 here at the local Sam's Club here in Las Vegas.

I just finished up a new spreadsheet that shows you a list of all your equipment and also all of the lube services that have been completed.

It will link to and display your current TATEMS data:

Each row in the spreadsheets contains the following columns:

Equip Num
Lube Service Type
Date Completed
Accomplished By
Air Filter
Oil Change
Fuel Filter
Oil Filter
Tire Pressure
Wheel Bearings
Brake Adjusments
A Service
B Service
C Service

This will allow you to see which PM items were checked off over time on each piece of equipment.

I shot a short screen cam video that shows you what it looks like.

The spreadsheet is number 59 on our TATEMS maintenance software spreadsheets page

Tidbits from around the NET
From the L.A.P.D.

“Things Your Burglar Won't Tell You”

1. Of course I look familiar. I was here just last week cleaning your carpets, painting your shutters, selling magazine subscriptions or delivering your new refrigerator.

2. Hey, thanks for letting me use the bathroom when I was working in your yard last week. While I was in there, I unlatched the back window to make my return a little easier.

3. Those yard toys your kids leave out always make me wonder what type of gaming system they have.

4. Yes, I really do look for newspapers piled up on the driveway. And I might leave a pizza flyer in your front door to see how long it takes you to remove it.

5. Hey your car parked in the driveway – I will use the garage door opener in your car, it activates the garage door – even when the car ignition is off. So you may want to turn your garage door opener (power) off from inside the garage when your home.

More of those on the next post.
Tell a Friend about TATEMS or like this post on Facebook and leave any comments below.

Have a great weekend!

2 New Spreadsheets that pull Work Order Discounts and More

I hope your week is going well . Gas is still holding at 3.79 per gallon and the it's going to be about 92 degrees today, but the winds are supposed to get up to 50 MPH tomorrow here in Las Vegas.

American Idol or the Voice? If you live in the U.S. do you watch either of these?

OK I admit it… my wife and my daughter and I are Idol fans, but The Voice is not bad either and it brings a new twist. Are you watching the battling talent shows?

We had a request come in and a client wanted to see just the “Discounts” given on all work orders, he also wanted to see the “Misc” charges separated out on the same spreadsheet. He just wanted to see the grand Totals for the 2 fields for all equipment combined over a certain date range.

So we not only created that spreadsheet but went one better and created a second spreadsheet that will also display the Parts Totals, Labor Totals, Misc Totals, Discount Totals and Grand Totals from Work Orders for each piece of equipment.

The first spreadsheet only displays the 2 cells

Screenshot Grand Totals For Work Orders Discount and Misc Spreadsheet

Screenshot above: Work Orders Discount and Misc Spreadsheet

This spreadsheet uses a date range of 1/1/2000 to 12/31/2050 and is a compilation of all equipment over that time period.

To change the date range in Excel 2010 see the screenshot below

Screenshot to change Discounts Grand Totals for Work Orders Date Range

Screenshot above: How to change the date range for this spreadsheet

The second spreadsheet displays a row for each piece of equipment and the 6 columns seen below. This one also uses a date range between 01-01-2000 and 12-31-2050.

Screenshot Grand Totals For Work Orders Totals For Labor, Parts And Discounts

Screenshot above: This spreadsheet gives you much more data from Work Orders Totals

Changing the date range on the second spreadsheet is basically the same, but the dates are not so close to the bottom of the command text box seen below. To get to the point where you click connections in step one you have to be in the data tab.

Screenshot Equipment Totals For Work Orders Change Date Range

Screenshot above: Changing the date range on the second spreadsheet

When you open either one of the spreadsheets or change the date range you may need to click the
refresh data in the data tab.

Most of this stuff looks the same in older versions of Excel, but instead of a data tab there will be a data menu item.

You can find both of the new spreadsheets at:

They are numbers 57 and 58 respectively.

There is also a link on that page to a video that shows you how to link to your TATEMS data on a different server.

Or see the video on this page:

I hope this was helpful for you. Please leave any comments or questions below and if you use Facebook be sure to click the like button below.

Have a Great Weekend!

Thanks Again


New Version 4.3.02 and Video

Big news this week!

Osama Bin Laden is dead, my youngest daughter turns 23 and graduates from college, and we released a new version update of TATEMS!

Gas prices here in Las Vegas were 3.79 per gallon at the nearby Sam's club this past weekend and the weather is great! It's going to be about 77 degrees today and almost no wind.

I created a quick (less than 3 minute) video showing you a couple of changes we made in this version update.

Get the update here

Please comment below if you have any feature requests and remember to like this page on Facebook, re-tweet on twitter and bookmark at your favorite bookmarking site!

Thanks Again

Marc Ready