chemical register

[Pm706Narrogin]

Just to clarify, Anna, I meant a register in the form of duplicate copies of every SDS for every chemical held on site stored in the main admin building. WorkSafe WA deemed that prohibitive and said the printed ChemAlert register would suffice. Every area chemicals are used has paper copies of the SDS as required by law.

You're too kind doing it for everyone else too. It feels like it's the reality of the situation but I find a lot of schools don't give the cleaners/gardeners etc. the training and resources they need to do the chemical management side of their job properly. I think the only time ours even have access to a computer at work is when they have to complete mandatory online training

[bigmack]

.

You're too kind doing it for everyone else too. It feels like it's the reality of the situation but I find a lot of schools don't give the cleaners/gardeners etc. the training and resources they need to do the chemical management side of their job properly. I think the only time ours even have access to a computer at work is when they have to complete mandatory online training

I think you are bang in the money there PM706.
Gardeners and General Assistants hate computers and I found doing their Chem register was worth way more in favours and browny points than it was an effort for me . I’d print last year’s copy and get them to stocktake and amend as necessary . Then I’d change it on the computer .

[Anna Z]

.

You're too kind doing it for everyone else too. It feels like it's the reality of the situation but I find a lot of schools don't give the cleaners/gardeners etc. the training and resources they need to do the chemical management side of their job properly. I think the only time ours even have access to a computer at work is when they have to complete mandatory online training

I think you are bang in the money there PM706.
Gardeners and General Assistants hate computers and I found doing their Chem register was worth way more in favours and browny points than it was an effort for me . I’d print last year’s copy and get them to stocktake and amend as necessary . Then I’d change it on the computer .

Yep, browny points are good...... also that seems like a good way to do it too... I still have trouble getting them to slow down long enough to do it accurately on a paper copy though and prefer to do it myself.

[cactus155]

yep, we have cleaners and canteens chemicals on our register..... I update and I stocktake and make sure the SDS are in date. I only do this as then I know IT"D DONE PROPERLY.

As for not realistic to have paper copies of SDS's on site.... by law we have to in VIC. I have a super easy system....the electronic register flags when SDS's are coming due for reprint, I go in each month, spend 10 minutes updating the SDS's and print off new versions, walk upstairs and file them away in our folders. I think it takes me a whole 15 minutes a month.

Hi everyone, Anna Z did you design the register yourself or is it a commercially available program? I would be interested in knowing more as it sounds like a fairly decent system. Thanks

[bigmack]

I'm pretty sure I got my idea off Anna .
using excel .
Setup conditional Formatting on the SDS date cells .
I've got mine so they are green if in date , orange if a month off expiring and red if over 5 years old .
It was years ago I set this up and I've forgotten how I did it but this should help you if you are into Excel
.
I can just scroll down the form and as long as the Date is green , it's good . saves literally hours of manually going through SDS folders . I also have the link to the SDS next to the Data column .

(Click on the images to make them readable)

Conditional formatting 1.png

Conditional formatting 2.png

[RosalieL]

I have the same as bigmack but in googlesheets except I only have current green/not current red. I might just add in an orange one next time I'm working on it! I think that's a great idea.

[Anna Z]

yep, we have cleaners and canteens chemicals on our register..... I update and I stocktake and make sure the SDS are in date. I only do this as then I know IT"D DONE PROPERLY.

As for not realistic to have paper copies of SDS's on site.... by law we have to in VIC. I have a super easy system....the electronic register flags when SDS's are coming due for reprint, I go in each month, spend 10 minutes updating the SDS's and print off new versions, walk upstairs and file them away in our folders. I think it takes me a whole 15 minutes a month.

Hi everyone, Anna Z did you design the register yourself or is it a commercially available program? I would be interested in knowing more as it sounds like a fairly decent system. Thanks

No I didn't design it, it's a department of Education template (Victoria), I have heavily modified it though because their original one sucked

[cactus155]

Thanks everyone for that information. I have a similar one and now it highlights the expired SDS and ones that are close to expiring.

[LabbieSeth]

When does an SDS 'expire'? I currently just update them yearly to the newest released/revised from a primary source in Australia

[RosalieL]

5 years from when it was last "updated" on the actual SDS produced by the manufacturer

[Pm706Narrogin]

When does an SDS 'expire'? I currently just update them yearly to the newest released/revised from a primary source in Australia

To echo Rosalie, every 5 years. But as you've probably noticed some get updated more regularly

WA DoE uses ChemAlert for our registers and as part of that you can see the latest revision date so if I notice something has been recently revised, I can update them then and there