Welcome Guest! The IOSH forums are a free resource to both members and non-members. Login or register to use them

Postings made by forum users are personal opinions. IOSH is not responsible for the content or accuracy of any of the information contained in forum postings. Please carefully consider any advice you receive.

Notification

Icon
Error

Options
Go to last post Go to first unread
simon1972  
#1 Posted : 02 February 2022 15:48:29(UTC)
Rank: New forum user
simon1972

I have started with a company that employes a lot of sub-contractors. Each month they are asking for a "rolling" monthly AIR figure in comparison to the HSE average AIR figure for construction (that being 330, as taken from the Home builders federation statistics ). my question is,, is this possible to do by pro rata'ing the 100,000 by 12 ?

Therefore the 100,000 divide by 12 ,  this would be = 8333. -- the company has had 3 x minor accidents during January and we have had 500 persons work for us during January . 

Working this our would be 3 / 500 = 0.006 , times this by the pro rata'd rate , being 8333  = an AIR of 49.9.

If we then divide the HSE AIR figure of 330 by 12 it gives 27.5. therefore is it fair to state that for January our company had an AIR statistic of 49.9 against a monthly AIR from the HSE that would be 27.5 

I hope that makes sense,,  apologies if not as getting very confused 

HSSnail  
#2 Posted : 03 February 2022 09:12:58(UTC)
Rank: Super forum user
HSSnail

Simon

someone may know better but my undertsanding of a "rolling" AIR figure is that it increases each month.

and the end of your 12 month reporting period the 1st month drops off.  If you have had 3 accidents in january and none in february you still have 3 accidents for that year - to try and take monthly averages will realy confuse your figures.

Kate  
#3 Posted : 03 February 2022 09:45:34(UTC)
Rank: Super forum user
Kate

I'm with Brian on this.  To me a rolling figure means the up to date figure for the last 12 months, regardless of calendar year.

So each accident drops out of it after a year has elapsed.

The "monthly" bit doesn't mean the accidents in the last month and doesn't involve any pro-rata, it just means you work it out each month, for the preceding 12 months.

So once January is over, you work out the figure based on accidents in the period last February to January just gone.

Once February is over, you do the same thing for last March to February just gone.

And so on.

You need a nice spreadsheet that will automate this.

achrn  
#4 Posted : 03 February 2022 12:11:44(UTC)
Rank: Super forum user
achrn

Mathematically, you can do all sorts of things, and some of teh things you've done are correct, and some are not, but I'm not sure it's useful.

330 injuries per 100,000 workers per year is the same thing as 27.5 per 100,000 workers per month, yes.

However 3 injuries per 500 workers per month is equivalent to a rate of 600 injuries per 100,000 workers per month.  So the figure for your company that you would compare to teh 27.5 (if you decided to) would be 600.

Any statistics built on a sample where you're only getting 3 isn't likely to be representative.  If 'they' want a figure updated monthly I wouldn't give them a figure for just the month, I'd give them a figure for the  preceding year recalculated each month, as the other replies have suggested.  It's probably easier to make comparisons, and with a larger sample it will probably be more representative (though it will be slower to react to changes, good and bad).

Users browsing this topic
Guest
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.