New spreadsheet-Periodic (90 Day) Inspections Due and Past Due with extra columns

Our prayers go out to the people of Japan and hope that things will improve soon for them.  

I had a request last week to create a new spreadsheet to display the 90 Day Inspections(or user defined number of days) Due or Past Due along with the Location so that they could sort the list by Location 

When I created it I also added the Deptartment or Area and the Customer fields in addition to the Location field.

This spreadsheet will link to and display the following columns fromyour TATEMS data:

Location
Dept or Area
Customer
Equip Num
Date Insp Completed
Next Inspection Due
Equip Desc
Equip Sort Order

Here is a short video to that shows you the Spreadsheet in action.

You can get the spreadsheet here

Have a great week!

Thanks Again

Marc Ready

Sharing is Caring