nlegaux
Hazard to Self
Posts: 93
Registered: 28-11-2014
Location: East Tennessee
Member Is Offline
Mood: No Mood
|
|
Taking an Inventory
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
Administrator
Posts: 6297
Registered: 4-10-2014
Location: Unmoved
Member Is Offline
Mood: Organised
|
|
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
Hazard to Self
Posts: 93
Registered: 28-11-2014
Location: East Tennessee
Member Is Offline
Mood: No Mood
|
|
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
Administrator
Posts: 6297
Registered: 4-10-2014
Location: Unmoved
Member Is Offline
Mood: Organised
|
|
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
Hazard to Others
Posts: 341
Registered: 30-8-2013
Location: Seattle, WA
Member Is Offline
|
|
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
International Hazard
Posts: 1063
Registered: 31-7-2013
Location: Detroit, Michigan, USA
Member Is Offline
Mood: Coprecipitated
|
|
I keep mine here.
https://drive.google.com/open?id=1z7pm8ooGc0PQl4iC6-L_-3DLSP...
|
|
Texium
Administrator
Posts: 4556
Registered: 11-1-2014
Location: Salt Lake City
Member Is Offline
Mood: PhD candidate!
|
|
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
Hazard to Self
Posts: 93
Registered: 28-11-2014
Location: East Tennessee
Member Is Offline
Mood: No Mood
|
|
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.
|
|