Rank: Forum user 
|
Folks
I hope someone can give me some guidance/advice. I am looking to analyse my accidents in more detail. I presently enter all accidents onto a spread sheet under minor accident (under 7 day injury) and major accident (over 7 day injury).
As you can see there is very limited analysis. I would like to analyse the accidents by type of accident or injury where I would be able to identify trends and hence appropriate remedial action.
I am aware that there are systems in the market for doing this, however I would like to design my own simple system using excel and have it running for a while before I ask for investment in this type of software. Is there anyone out there who has put together such a sheet and wouldn't mind sharing. Any advice be appreciated. Thanks
|
|
|
|
|
|
Rank: Super forum user
|
I haven't such a sheet, but I imagine it would be quite easy to create such a thing. What you need to collate is the nature of each injury or accident. It's all about the detail I suppose.
Location
Task
Time of day
Type of injury
To what part of the body
Type of incident (if a near miss or property damage)
What kind of first aid was given
How much working time was lost
What were the cost implications
I'm sure there are many more; its important that your accident reports and investigations gather this information for later use. You may find some very interesting correlations when you begin to analyse in more detail.
|
|
|
|
|
|
Rank: Guest
|
|
|
|
|
|
|
Rank: Forum user
|
|
|
|
|
|
|
Rank: Super forum user 
|
Eddie
You are doing the right thing with an excel SS which you can develop & evolve
The commercial ones are sold by snake oil salesmen who will promise you the earth and then ignore you once they have your cash.
You will then be stuck with a product that does do what you want.
|
|
|
|
|
|
Rank: Super forum user
|
Eddy,
Do want your analysis to include data on the conclusions of the accident investigations?
I've encouraged my largest customer to do this, classifying accidents as due to 'an unsafe act' or an 'unsafe condition' (and we list examples of both to tick).
Also try and identify the underlying cause, as one of three:
the individual, tick list: e.g. not using training, careless, low experience etc
the job, tick list: e.g. poor equipment, heavy workload, ineffective training, insufficient risk assessment etc
the organisation, tick list: e.g. poor culture, planning, communication, training, failure to learn lessons etc
JohnW
|
|
|
|
|
|
Rank: Super forum user 
|
Eddy
It does depend to some extent the amount of data you have to process i.e. how many accidents/incidents. The other problem with categorisation is that there are so many variables the task may not be worth the effort unless you can simply it and then you are defeating the objective to some extent. Focusing on the outcome i.e. LTI, RIDDOR, etc, reveals very little in my opinion, although managers and clients still like to see this data.
I have worked with a number of incident spreadsheets and because the underlying causal factors are so different, even subjective to a degree, the task of categorisation is very hit and miss. In my opinion identifying trends is probably best left to your own experience/knowledge based on the task, location, etc. For example, if you had a spate of hand injuries it might be just coincidence or it might be something else which has caused the problem. You don't need a spreadsheet to identify this type of trend or to investigate it further.
|
|
|
|
|
|
Rank: Forum user
|
Ray/John/Walker
Thanks for your comments. I agree with what you are all saying. I presently only analyse over 7 days/ under 7 days accidents. Tells you very little. At the minute I'm just trying to see what other people analyse and see if I should go down the same path. Last thing I want to do is analyse for the sake of analysing. I also don't want to spend a lot of money on something that has no real benefit except fancy graphs. Eddie
|
|
|
|
|
|
Rank: Super forum user 
|
I look at lost work hours, location, type injury or damage, first aid requirement, time of day, recurring names, reported near misses before accident, task, employment status, RIDDOR Reportable, off work.
I did this recently and found alot of issue with spilt tea/coffee in the corridor between the office, warehouse and on site restaurant- on a bit of a mission now :-)
I can share my sheet- admittedly its a bit messy as i'm no good with excel lol
|
|
|
|
|
|
Rank: Forum user
|
|
|
|
|
|
|
Rank: Forum user
|
|
|
|
|
|
|
Rank: New forum user
|
Hi Eddy,
sent my template to you by email, let me kniow if it is any good to you.
Martin
|
|
|
|
|
|
Rank: Super forum user
|
Eddy
I have a simple XL sheet, just categorize by body parts..if you interested PM me please
SHV
|
|
|
|
|
|
Rank: Super forum user
|
I collect the information- ie incident reports using a bespoke database(Acess) and then download the data into a spread sheet from that information I can analyse and establish things like type of incident, location, the type of person involved (employee, contractor, visitor student etc) which team etc.
I then make up pretty graphs which I present to management and the H&S committee.
There are professional packages that do this but cost stupid amounts of money to buy and maintain. Ours cost very little but we do have IT support for the database.
PM me if you would like a copy of my spread sheet(quarterly or annual).
|
|
|
|
|
|
Rank: Guest
|
I thought Pivot tables would present any information you chose within your spread sheet.
|
|
|
|
|
|
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.