Sheet Set
Need help on how to create spreadsheets for inventory at work, please.?
I like to create a spreadsheet that is effective and easy for everyone to continue to keep track of surgical equipment in our office. What are some important things to list that I have not mentioned? So far I have: name, description, quantity in stock and Reorder quantity. What else should I list?
I am not in the medical industry but you've covered the basics. I would put that on the front sheet for all to read at a glance. Sheet1 but then withdraw from the sheet 2, and let me lead (as this answer (sorry)) in Sheet2 … just think of things to do while you're rearranging – number – Manufacturer – perhaps the date of the last order (if not lose sight of a leaf more complicated, this will let you know how much time between orders … maybe you could find yourself needing to increase order quantity of something) – if you have a catalog, then perhaps the page # … but that is old, I imagine that most things you buy on the Internet now. – An expiration date? so you can use material as quickly as possible before it expires, or preparing to ask for more. – Maybe the price
