[labnetwork] Inventory Management System

[Chang, Long]

Hi Jacob,

The majority of our chemical inventory is supplied by the user. We have a computer and label maker dedicated for chemical registration. Our custom software allows a user to register the chemical. Upon registration, a label is printed and the details is uploaded to a google spreadsheet. The label contains a storage code that new students use to match with a appropriate storage cabinet. Here's what our spreadsheet looks like now:
https://docs.google.com/spreadsheets/d/1cUVMhzxE6NiS3t1xE1GWebd9wTs2n9D1IoqtdzN6Osw/edit#gid=1440247124
This googlesheet is shared with every user to facilitate sharing of chemicals.

When we need room, we announce a purge. All active users need to visit the cleanroom to put a sticker on their chemicals within a month. Offsite users can send staff and email. Then staff removes all inactive chemicals and decide what to do with them.

Best,
Long
On Aug 24, 2017, at 7:44 AM, Jacob Trevino <Jacob.Trevino at asrc.cuny.edu<mailto:Jacob.Trevino at asrc.cuny.edu>> wrote:

Hello All,

I’m curious to know what people are using for inventory management in your respective facilities. I’m sure the responses will be quite diverse. I can image many people are either using an Excel sheet or maybe something built into their lab management software. We utilize Badger LMS here and it has inventory capabilities; however, it is a bit cumbersome. I was hoping someone has found something that integrates well with mobile devices, maybe app driven. As we have grown our facility, inventory management has become a more complex beast. Also, I’d be curious who manages your inventory. Do you have a dedicated person or is it a team effort? Is it staff driven or do your users participate in any way?

Happy new academic year to all!

Best regards,
Jacob

--
Jacob Trevino, PhD
NanoFabrication Facility Director |Research Associate Professor
CUNY Advanced Science Research Center
85 St. Nicholas Terrace, New York, NY 10031
212-413-3310 | jacob.trevino at asrc.cuny.edu<mailto:jacob.trevino at asrc.cuny.edu>
http://www.trevinolab.com/| http://nanofab.asrc.cuny.edu<http://nanofab.asrc.cuny.edu/>/
NanoFab Blogsite: https://www.nanonotes.org/
Twitter: @JTrevinoNano | @ASRCNanoFab


_______________________________________________
labnetwork mailing list
labnetwork at mtl.mit.edu<mailto:labnetwork at mtl.mit.edu>
https://www-mtl.mit.edu/mailman/listinfo.cgi/labnetwork

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://mtl.mit.edu/pipermail/labnetwork/attachments/20170824/7b2df603/attachment.html>