Parts Replaced Under Warranty Spreadsheet

It was 29 ° F this morning here in Las Vegas a bit cold for us but I’m sure not as cold as it is in other cities.

I created another spreadsheet to display all parts that were installed that have a warranty. This would allow you to check to see if part was under warranty when it failed.

To make this as useful as possible; you should add a note as to the warranty duration when you add a part to a Work Order and check the Warranty Box for the part.

Here are the fields that will display in this spreadsheet

Equip Num
Work Order ID
Requested Date
Completed Date
Part Num
Part Descr
Qty
Cost Per Unit
Total Cost
Notes
Warranty?

You can download it here:

TATEMS-PartsReplacedUnderWarranty.xls

You can also find this and many other spreadsheets we have created here

http://blog.tatems.com/hd2

Here is a short video tour of the Parts Replaced Under Warranty spreadsheet :

Do you think we should add a warranty term next to the check box for the part in TATEMS?
Please leave your comments below.

Thanks Again
Marc