Video – Custom TATEMS Spreadsheet No. 129 Inventory Type Totals Installed
The video below shows you how to link and use the TATEMS Custom spreadsheet called TATEMS-WorkOrderPartsInventoryInstalledByCustomerbyYearAndInventoryType
This spreadsheet is number 129 and can be found here:
The columns in this spreadsheet are
Customer (From Custom Selected on the Equipment Summary Tab. If you have no customers this would be “In House”)
Year Work Order Parts Installed (from the Work Orders Completed Date)
Inventory Type (from the Parts Inventory screen)
Parts Cost (from the Work Order Parts Screen)
The video above shows you how to link this spreadsheet using Excel 2016 or 2019 and it might also be similar for Excel 2013
If you have Excel 2010 or 2007 then the video here will show you how to link these spreadsheets to your TATEMS data.
Thanks for stopping by!