Hi all,
I just wanted to say the recent riskassess update to include the chemical inventory has been a really good addition! I have just finished importing the data from my spreadsheet. I made some mistakes in the process so I thought I'd give you some tips if you're wanting to set yours up.
Open the recommended template on riskassess. Open your spreadsheet and make a copy. Use the copy to rearrange the columns into the same order as it is on the template. This means you can copy the whole lot over at once.
Max quantity is required in g or ml etc and it doesn't recognise "20 tablets" for buffer tabs or "100 strips" for litmus so leave those types of things off the mass import. I haven't checked what you can do manually yet.
If you don't have a storage column in your current inventory, it's easy to just add a column and type in the location in the first cell then drag from the bottom right corner to copy that all the way to the bottom.
You still need to export the data to a CSV file (or there are a few other options) even from the template. It automatically selects the "create separate tables" or something like that so the instructions end up separate to the data.
Once you have imported everything, you can generate the hazardous chemical register from within riskassess including quantities and storage location. At this point, I only have my science chemicals in there but I think it would be useful to eventually do the whole school so it is all in one place. Chemicals can be linked to the riskassess safety data as well.
It has taken me about an hour total (including a few interruptions) to put everything over, and I did all the coping over one or two columns at a time, and by letter groups (all the As, then all the Bs) because they are separated on my original spreadsheet. In hindsight I should have just done the whole lot then deleted the extra lines. I only started rearranging the columns towards the end so I could do more than one at once. That's why I thought I'd help you all out. It looks like it will be a very convenient feature.
I hope this saves at least one person some time!
Recent RiskAssess Update
-
Yuks
- Posts: 15
- Joined: 21 Oct 2021, 13:26
- Job Title: Laboratory assistant
- School: SMMC
- State/Location: ACT
Re: Recent RiskAssess Update
Thank you RosalieL! I am planning to do this after senior exam but didn't wanted to put every single chemicals each time... So glad that you put this on here.
However, where could I find the recommended template...?
Thanks in advance!
However, where could I find the recommended template...?
Thanks in advance!
-
Marama T
- Posts: 443
- Joined: 01 Aug 2017, 12:19
- Job Title: Laboratory technician
- School: College
- State/Location: NSW
Re: Recent RiskAssess Update
AAAAAARRRGGGHHH another thing I probably should get my head around. Thanks for all the info RosalieL.
-
RosalieL
- Posts: 964
- Joined: 28 Jan 2021, 13:24
- Job Title: Lab Assistant
- School: MCS
- State/Location: NSW
Re: Recent RiskAssess Update
Hopefully this worksYuks wrote: 15 Oct 2026, 08:34 Thank you RosalieL! I am planning to do this after senior exam but didn't wanted to put every single chemicals each time... So glad that you put this on here.
However, where could I find the recommended template...?
Thanks in advance!
You do not have the required permissions to view the files attached to this post.
-
Yuks
- Posts: 15
- Joined: 21 Oct 2021, 13:26
- Job Title: Laboratory assistant
- School: SMMC
- State/Location: ACT
Re: Recent RiskAssess Update
Thank you so much, RosalieL!
-
RosalieL
- Posts: 964
- Joined: 28 Jan 2021, 13:24
- Job Title: Lab Assistant
- School: MCS
- State/Location: NSW
Re: Recent RiskAssess Update
When it is all set up you can print a hazardous chemical register by location and also print a QR code (by whole school or just location) to have anywhere that it might be needed so anyone can access it through a QR reader.