

- TOOL INVENTORY SHEET PDF FOR FREE
- TOOL INVENTORY SHEET PDF HOW TO
- TOOL INVENTORY SHEET PDF UPGRADE
- TOOL INVENTORY SHEET PDF CODE
- TOOL INVENTORY SHEET PDF LICENSE
You can also add each item's current location. Go back to the Items sheet and begin by assigning Home Location to each item, which is where the item should be located when not in use. Start with the ones where your equipment is located by default, its home location. Locationsĭo the same with the Locations sheet Remove the sample locations, and add your own. This is done in the column called PPR, which is an abbreviation for Primary Person Responsible. You can now go back to the Items sheet and assign main responsibilities for each item to different users. Click the Users sheet, delete the sample names and add your own users. If you have different people using the equipment, you should add the people to the equipment database, so that you always know who is using it. Go back to the Items sheet, and start categorizing each item in the Type column (C), by simply selecting the type from the dropdown menu. Remove the sample types, and add your own. In the equipment database, select the sheet called Types. But once the database grows, it might be convenient to group items by type. If you only have a few items, there is no need to categorize them.
TOOL INVENTORY SHEET PDF CODE
While most equipment management solutions use QR code labels that you can scan with an app, you can manually label your equipment with this number, so that it's easy to find the exact equipment in the spreadsheet database.

We have also added a column called UniqueID, which is simply a unique number. If you have multiple similar items, you can simply add #1, #2, #3, and so on after the name.

TOOL INVENTORY SHEET PDF LICENSE
Common naming conventions are combinations of brand, model, and a unique identifier, like the license plate, if a vehicle. The most important is that each name is unique and that it's easy to understand which item it is. Find a way of naming items that makes sense for you, but keep it consistent. Add your own equipment inventoryįirst, begin by deleting the sample records in the items sheet, then start adding items.

The other sheets contain records of information you can select in the items sheet and when logging information in the logging sheets, like lists of users, types and locations. The log sheets are where you'll have the history of who has been using the equipment, where it has been, how it has been performing (condition) and any event that might have occurred. Items: This is the main sheet where you can put all your equipment.The spreadsheet is divided into multiple sheets: We have added a few sample items, just so you can get a quick impression of the setup. Once you have copied and opened the file, you will see a list of items. You'll find download instructions at the end of this post.
TOOL INVENTORY SHEET PDF FOR FREE
To get you quickly started, we have made a Google Sheets template that you can copy for free and use as a starting point.
TOOL INVENTORY SHEET PDF UPGRADE
If you later decide to upgrade to a dedicated equipment management solution, you can always import your equipment from the spreadsheet.
TOOL INVENTORY SHEET PDF HOW TO
Although such a solution has many advantages over using a spreadsheet, the task of just finding the best solution for you and learning how to use it can require a big effort.īut there is no harm in getting started with equipment management simply using a spreadsheet like Microsoft Excel, Apple Numbers - or even better, a free, online inventory template spreadsheet like Google Sheets. There are several great, dedicated equipment management and tracking solutions available that helps you manage especially expensive and important equipment in your organization.
