Inventory is defined in the Cambridge Dictionary as “the amount of goods and materials owned by a company at a particular time, including parts, products being made, and finished products”.
In a previous post I shared a few tips to improve inventory reception, tagging and tracking.
I created an easy to use Excel spreadsheet that generates delivery and return forms, according to the assignment of assets. The spreadsheet can be very useful in companies with up to 150 employees. I assumed that soft phones are used, and other assets like printers, televisions or projectors, are in another spreadsheet or sheet.
Most sheets in the spreadsheet represent a different asset category, and each column within it a specific characteristic, quality or feature of an asset or person.
The “Models” sheet has data validation categories for assets such as brands and models.
Some sheets have a column called “User” with a different color formatting, and they should not be touched because they include special formulas.
The “Assign” sheet is where people and assets are correlated.
The user selection in the forms, made in a specific cell, causes the form to be automatically filled in.
Download links:
Inventory_Worksheet.xlsx
Name/Size: Inventory_Worksheet.xlsx/138KiB
SHA256: 0ee17b3bc7d0c588d57d87b917e512400e663d9b8778b088ac2206b7e5e22810
