Docstoc

Equipment Tracking

Document Sample
Equipment Tracking Powered By Docstoc
					Equipment Tracking Excel Template
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.

www.vertex42.com

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.com

ITEM DESCRIPTION Name Code
Example V42EX879

LOCATION
Description Some fancy equipment Category Computer Hardware Department/Area 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
Storage Location Room 87B Avail. 1 In Use

DATE

VALUE

Purchased Wrrnty Exp Purchase 10/11/2004 10/11/2006 $ 2,000.00

Name Example

Item Code
V42EX879

Manufacturer

Model No.

Serial No.

SKU

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


				
DOCUMENT INFO
Shared By:
Categories:
Stats:
views:808
posted:1/3/2008
language:English
pages:6
Jeff Sperry Jeff Sperry
About