equipment-tracking[2]

Equipment Tracking Excel Template www.vertex42.com This workbook is designed as a very basic way to inventory and track equipment. At the moment, this template is just a start at setting up tables in Excel for listing equipment and associated details. If you have suggestions for what else to include in the template, please share them. For example, would you like to have a spreadsheet that has various depreciation calculators? Or, do you have suggestions for other important information to include in the tables? If you want a more automated system, you might want to consider custom equipment tracking software.www.vertex42.comITEM DESCRIPTION LOCATION Name Code Description Category Department/Area Example V42EX879 Some fancy equipment Computer Hardware ME Dept. Equipment /Fixed-Asset Inventory This is the basic worksheet for listing your equipment or assets. If you would like to include more details, you can add columns to this spreadsheet, or you could set up another table and link the records using the item Code. For example, the Details worksheet in this workbook allows you to include serial numbers, model numbers, manufacturer info, etc.QUANTITY DATE VALUE Storage Location Avail. In Use Purchased Wrrnty Exp Purchase Room 87B 1 10/11/2004 10/11/2006 2,000.00 $ Name Item Code Manufacturer Model No. Serial No. SKU Example V42EX879 Inventory Details You can use a spreadsheet such as this to provide additional information for specific items in the inventory. To add an entry, copy the formula in column A down, and add the item code for the tool, asset, or hardware that you want to provide more information on. Column A uses a basic lookup function to grab the name of the item from the Inventory worksheet.UPC