Spreadsheet # 100 TATEMSReport-WorkOrderActualPartsCostsAndLaborHoursByGroupedByMonthAndYear
The spreadsheet gives you Monthly Labor Hours and Parts Costs for You Entire Fleet
Checkout the video below to see how to use the spreadsheet and how to link it to your live TATEMS database
Thanks for watching!
P.S. I would really appreciate it if you could subscribe to our YouTube channel to get notifications of new TATEMS videos
I hope you had a nice Christmas and New Year!
This first video is a demo of a new spreadsheet requested
It is called
Another nice short (but descriptive) name, I know…
It was created because the client wanted to be able to see Parts and Labor Totals for Model and or Year of Equipment and other fields like Equipment Location.
It is spreadsheet number 64 at:
I forgot to show you how to filter it by the columns at the top but you can see how on one of the other videos I made here:
at about the 40 second mark.
And this second video gives you about a 4 minute demo of the new TATEMS Reminders program that we are working on.
I did not use Zoom on the TATEMS Reminders video so you may want to click the Full Screen button on the lower right side of the player.
Let me know if you would like to see a custom spreadsheet created that we can share with our users too!
Make sure you click the Facebook like button and leave a comment if you would like to try the beta version of this new add-on.
Thanks Again And Have a Great Week!
I hope your week is going well so far.
The last week or so around here has been a little crazy.
It was only 95 ° here in Las Vegas today, well below normal and the Gas prices have been getting lower. We filled up for $3.55 per gallon last Friday and have seen it as low $3.31 per gallon on the other side of town.
I usually make breakfast in the morning for my wife and me and a few days ago I did what I usually do.
I left my wife's breakfast on the counter and yelled upstairs to let her know it was ready.
Then I grabbed mine to sit down and watch TV.
She took longer than usual to come down. I was already finished when she walked over to her plate and found a plate full of ANTS! Oops…
So we spent the next few hours trying to eradicate them.
The next day as I'm making breakfast I noticed water in the kitchen sink. I thought it wasn’t draining because there were some plates on one side that were blocking the drain.
We removed the dishes and it still would not drain. So I grabbed the bathroom plunger and turned on the garbage disposal and stupidly tried to plunge the other side.
All of a sudden boom! The pipes burst, water goes spraying out the front of the cabinet, soaking my pants and flooding the cabinet under the sink and the floor.
Oh what Fun!!!
I took apart the pipes and used a 6 foot snake to try to clean it out, put it all back together, no go, tried multiple Liquid Plummer bottles, no go.
Finally got a hold of my landlord and she sent in the big guns drain cleaning service. He had to go in about 15 feet to the main drain and that did the trick.
Drama over…. For a few days.
So it’s about 6AM Monday morning and I’m downstairs in morning prayer and hear my 23 year old daughter coming downstairs to let the puppy “Kiba” out (Kiba means fang in Japanese).
A few minutes later I hear the door open and then a big bang, and the cats go flying, bells jingling and I’m thinking “what’s going on” So I look up, I don’t see my daughter, then I look behind me, the cats are staring towards the door, then I look down, and my daughter has collapsed on the floor.
I jump up and she is laying there on her side, and the floor is hard tile, she is unconscious and her eyes are open.
As I keeled over her and starting asking if she was aright she slowly came back around.
Well thank God, it turns out she just fainted and after a while she was able to get up and eat something.
We figure it was just low blood sugar. She said as she was sitting out back waiting for the dog to finish his business she started feeling ill, like she wanted to lay down. She thought she could make it back inside but just couldn’t make it.
Scared me to no end… the sight of her laying is something I’ll probably never forget. You never want to see your child hurt in any way.
And now on to today's tip…
Shelly, one of our clients was looking for a report to show all the Labor hours and costs even if the Work Order was still open.
We did not include a time clock feature for labor items in TATEMS in order to keep it as simple as possible for technicians to use.
But due to popular demand we will be adding a way to track start and Stop times and dates on each labor item in a future
In the meantime I created this spreadsheet that will let you see all the dates associated with each work order and the
associated labor so I created the spreadsheet profiled in the video below:
Labor on Work Orders Pending and Completed.
And it will link to you TATEMS data and display the following columns:
Work Order #
Date To Complete By
Cost Per H/U
You will need to have Microsoft Excel to use these spreadsheet and have it link to your TATEMS data.
The video also 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 or if you have a 64 bit version of Windows or if your TATEMS data is on a network then
see this video:
You can get the spreadsheet at our website it’s called:
It’s ready for you online and ready to download here:
It is spreadsheet number 60 in the list on that page.
I hope this tip has been helpful for you.
Have a great Weekend and a Happy 4th of July
P.S. If you need a custom spreadsheet let me know below and if you are on Facebook please click the like button… If you do… actually like this post that is…