Hi Eddy,

I would advise you find someone locally who has expertise in Excel and trust the combination of your interest and their willingness to help you deliver a suitable outcome. Data analysis is a bit of a skill and using someone separated from the ct of safety will help avoid the trap of merely using data to confirm your assumptions too.

Assking safety people to help with excel generally follows the usatisfactory pathh of finding a "one eyed king in the land of the blind", or even worse realising after a month of vigorous thrashing that you've actually both been "fanning the towel"...

Hi Eddy

What do you hope to get out of any analysis? Are you looking to group accidents by injury type ie eye or cut or burn etc or by accident type ie slip trip fall or fall from height or crush injury? I do record this type of info on a spreadsheet, but we don’t have enough accidents to really get anything much from it. Or are you hoping to get something else from it? If so what?

What you do and how easy it is depends on what you or others want out (garbage in garbage out and all that). Don’t try and create stats for the sake of it. If at some point you want to group all falls from height then you will need your spreadsheet in the same row as the other accident details on the spreadsheet to record “Fall from height” etc. You need to ensure the wording and spelling is consistent to get the sheet to group together when sorted. The categories you set should be easily relatable to the accident type you get, especially if you are to get others to input the info. Learn to use Excel a little at a time and you soon pick up the basics and that way you are in control. It is a good skill to have even if only basic stuff.

But please as above only record what you need, not for the sake of it. Recording info that is never used is a waste of time and effort.

Chris