nlegaux - 19-12-2014 at 21:07
I would like to take an inventory of all of the chemicals I have on hand. What is the best way to take an inventory, and what is the best way to
organize the paper it is on? I looked on the forum but didn't see any threads discussing this. I don't have very many reagents, but I believe I have
enough that it may be a good idea.
Thank you,
nlegaux
j_sum1 - 19-12-2014 at 22:40
I just used a pen and wrote a full list in my lab journal. If anything more complex than that is needed then I will construct a spreadsheet. What's
your purpose for doing it? If you know that then the best means will be obvious.
nlegaux - 20-12-2014 at 13:14
I would like to have a better understanding of what I have and how much of it I have. I think it would make planning a lot easier (does it?). Also, I
want to know if there is a "best" way to take one to make it easier to both take and update.
Thanks,
nlegaux
j_sum1 - 20-12-2014 at 13:52
Then do a spreadsheet.
Columns for name, location, category (acds, base, oxidiser, solution, organic solvent etc), quantity, hazard info, supplier, and whatever else you
think is useful. You can then sort or filter by category as needed. You can add new columns when you want.
Then at some later stage when you find that the spreadsjheet is not doing what you want, you know what fetures you are looking for in specialised
software. And you likely have a format that you can export data from.
Zephyr - 20-12-2014 at 14:01
I have my inventory in a Microsoft access document. This makes it easy to update the list through a custom form in which I enter the chemicals
characteristics. I use the access document to print labels for all my chemicals whuch contain the name, formula, mass, melting and boiling points, and
the NFPA 704 symbol.
[Edited on 12-20-2014 by Pinkhippo11]
Praxichys - 20-12-2014 at 16:27
I keep mine here.
https://drive.google.com/open?id=1z7pm8ooGc0PQl4iC6-L_-3DLSP...
Texium - 22-12-2014 at 09:08
I use a google doc, but I don't have quantity as a field on it, as it's rather difficult to go about constantly changing that. Instead, I mark each
item with one symbol if I have copious amounts, or another if I am running low and have barely enough to use for anything. No marking means I have a
reasonable amount.
nlegaux - 22-12-2014 at 18:38
That definitely sounds like a much better way to keep track of quantities (I was just thinking about how to do that). I'm not sure if I will use Excel
on my PC or the one over google docs... It would be nice to be able to access it from anywhere.