Sciencemadness Discussion Board
Not logged in [Login ]
Go To Bottom

Printable Version  
Author: Subject: Taking an Inventory
nlegaux
Hazard to Self
**




Posts: 93
Registered: 28-11-2014
Location: East Tennessee
Member Is Offline

Mood: No Mood

[*] posted on 19-12-2014 at 21:07
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
View user's profile View All Posts By User
j_sum1
Administrator
********




Posts: 5490
Registered: 4-10-2014
Location: Oz
Member Is Offline

Mood: Taking opportunities to breathe.

[*] posted on 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.
View user's profile View All Posts By User
nlegaux
Hazard to Self
**




Posts: 93
Registered: 28-11-2014
Location: East Tennessee
Member Is Offline

Mood: No Mood

[*] posted on 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
View user's profile View All Posts By User
j_sum1
Administrator
********




Posts: 5490
Registered: 4-10-2014
Location: Oz
Member Is Offline

Mood: Taking opportunities to breathe.

[*] posted on 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.
View user's profile View All Posts By User
Zephyr
National Hazard
****




Posts: 329
Registered: 30-8-2013
Location: Seattle, WA
Member Is Offline


[*] posted on 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]




Sciencemadness Patches for sale! U2U me if you are interested.
http://imgur.com/a/QmpHn http://www.sciencemadness.org/talk/viewthread.php?tid=62566&...
View user's profile View All Posts By User
Praxichys
International Hazard
*****




Posts: 1061
Registered: 31-7-2013
Location: Detroit, Michigan, USA
Member Is Offline

Mood: Coprecipitated

[*] posted on 20-12-2014 at 16:27


I keep mine here.

https://drive.google.com/open?id=1z7pm8ooGc0PQl4iC6-L_-3DLSP...




View user's profile Visit user's homepage View All Posts By User
Texium
Administrator
********




Posts: 3536
Registered: 11-1-2014
Location: Salt Lake City
Member Is Offline

Mood: Triturated

[*] posted on 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.



Come check out the Official Sciencemadness Wiki
They're not really active right now, but here's my YouTube channel and my blog.
View user's profile Visit user's homepage View All Posts By User
nlegaux
Hazard to Self
**




Posts: 93
Registered: 28-11-2014
Location: East Tennessee
Member Is Offline

Mood: No Mood

[*] posted on 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.
View user's profile View All Posts By User

  Go To Top