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. 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. 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.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |