Recent RiskAssess Update

General announcements, eg upcoming science meetings, national lab tech seminars, Chemtalk announcements, etc.
Post Reply
RosalieL
Posts: 956
Joined: 28 Jan 2021, 13:24
Job Title: Lab Assistant
School: MCS
State/Location: NSW

Recent RiskAssess Update

Post by RosalieL »

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!
Yuks
Posts: 15
Joined: 21 Oct 2021, 13:26
Job Title: Laboratory assistant
School: SMMC
State/Location: ACT

Re: Recent RiskAssess Update

Post by Yuks »

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!
Marama T
Posts: 437
Joined: 01 Aug 2017, 12:19
Job Title: Laboratory technician
School: College
State/Location: NSW

Re: Recent RiskAssess Update

Post by Marama T »

AAAAAARRRGGGHHH another thing I probably should get my head around. Thanks for all the info RosalieL.
RosalieL
Posts: 956
Joined: 28 Jan 2021, 13:24
Job Title: Lab Assistant
School: MCS
State/Location: NSW

Re: Recent RiskAssess Update

Post by RosalieL »

Yuks 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!
Hopefully this works
Screenshot 2026-10-16 at 9.52.40 am.png
Screenshot 2026-10-16 at 9.52.58 am.png
Screenshot 2026-10-16 at 9.55.20 am.png
Screenshot 2026-10-16 at 9.55.50 am.png
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

Post by Yuks »

Thank you so much, RosalieL!
RosalieL
Posts: 956
Joined: 28 Jan 2021, 13:24
Job Title: Lab Assistant
School: MCS
State/Location: NSW

Re: Recent RiskAssess Update

Post by RosalieL »

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.
Post Reply