Forums User Guide - CLICK HERE

Incident stats

Discuss all things health and safety.

Moderator: Moderators

Post Reply
User avatar
TWDB
Student
Student
Posts: 73
Joined: Thu Apr 11, 2013 3:24 pm

Incident stats

Post by TWDB » Thu Feb 16, 2017 10:37 pm

Guys,

Just wondering if anyone has a set up excel sheet for recording AFR and AIR etc. and then an easy way to produce a monthly summary report and graphs from the data inputted. i have a very basic excel sheet that i use but skills on excel are lacking to be able to produce meaningful data results / trends and charts.

the files in the download section seem very old and i was wondering if anyone would have anything better.

working in a construction sector business.

Thanks :shock:

T

Foolsgold
Student
Student
Posts: 44
Joined: Tue Dec 14, 2010 9:54 pm

Re: Incident stats

Post by Foolsgold » Fri Feb 17, 2017 7:45 am

I would be quite interested in something like this also....

User avatar
Alexis
Official HSfB Legend
Official HSfB Legend
Posts: 44390
Joined: Thu Mar 18, 2004 10:52 am
Twitter: https://twitter.com/AlexisHSfB
Location: West Lothian
Contact:

Re: Incident stats

Post by Alexis » Fri Feb 17, 2017 11:08 am

TWDB wrote:
Thu Feb 16, 2017 10:37 pm
Guys,

Just wondering if anyone has a set up excel sheet for recording AFR and AIR etc. and then an easy way to produce a monthly summary report and graphs from the data inputted. i have a very basic excel sheet that i use but skills on excel are lacking to be able to produce meaningful data results / trends and charts.

the files in the download section seem very old and i was wondering if anyone would have anything better.

working in a construction sector business.

Thanks :shock:

T
Many of our Downloads have been donated freely by our amazing members over the years, which we are most grateful for, clapclap however, nowadays, we don't receive so many donations and sadly, we don't have any magical way of offering more up to date information to assist others.

If anyone has anything they could offer for this request or anything else they they would like to donate to our Downloads, we would be very grateful. .salut Simply contact myself or Jack. Thank you.

Can I also point people to this post. viewtopic.php?f=1&t=45152
"A candle loses none of its light by lighting another candle."

Image

http://www.safetyjobsonline.com/

User avatar
WillPool
HSfB Moderator
HSfB Moderator
Posts: 9960
Joined: Mon Mar 13, 2006 8:45 pm
Industry Sector: Civils/Telecommunications
Location: Oxfordshire

Re: Incident stats

Post by WillPool » Fri Feb 17, 2017 11:11 am

I will see if what I use can be adapted for member use ;)

Will .salut
It is better to be careful 100 times than to get killed once.
Mark Twain (1835 - 1910)

User avatar
Alexis
Official HSfB Legend
Official HSfB Legend
Posts: 44390
Joined: Thu Mar 18, 2004 10:52 am
Twitter: https://twitter.com/AlexisHSfB
Location: West Lothian
Contact:

Re: Incident stats

Post by Alexis » Fri Feb 17, 2017 11:22 am

WillPool wrote:
Fri Feb 17, 2017 11:11 am
I will see if what I use can be adapted for member use ;)

Will .salut
Many thanks Will. :D
"A candle loses none of its light by lighting another candle."

Image

http://www.safetyjobsonline.com/


User avatar
WillPool
HSfB Moderator
HSfB Moderator
Posts: 9960
Joined: Mon Mar 13, 2006 8:45 pm
Industry Sector: Civils/Telecommunications
Location: Oxfordshire

Re: Incident stats

Post by WillPool » Fri Feb 17, 2017 11:50 am

All info is made up to show the sheets/charts work. If you download both spreadhseets and save to a location, then when you open the charts it should ask you if you wish to update the links, by pressing yes it should self populate the charts.

Two attachments:

1. KPI, dept could be departments or contractors. Change the tabs to read what you want. The master page at the front automatically totals and gives afr/air etc. The AIR/AFR is only populated in the master sheet, if you need to populate it by dept/contractor let me know and I will PM you how to do it.


2. KPI Charts. Should automatically update from the KPI Template sheet.
KPI Template.xlsx
(80.47 KiB) Downloaded 31 times
KPI Charts Template.xlsx
(60.07 KiB) Downloaded 27 times
Jack/Alexis feel free to use in downloads, maybe worth while putting above explanation with them, or link to this post?

Will .salut
It is better to be careful 100 times than to get killed once.
Mark Twain (1835 - 1910)

User avatar
Alexis
Official HSfB Legend
Official HSfB Legend
Posts: 44390
Joined: Thu Mar 18, 2004 10:52 am
Twitter: https://twitter.com/AlexisHSfB
Location: West Lothian
Contact:

Re: Incident stats

Post by Alexis » Fri Feb 17, 2017 12:19 pm

WillPool wrote:
Fri Feb 17, 2017 11:50 am
All info is made up to show the sheets/charts work. If you download both spreadhseets and save to a location, then when you open the charts it should ask you if you wish to update the links, by pressing yes it should self populate the charts.

Two attachments:

1. KPI, dept could be departments or contractors. Change the tabs to read what you want. The master page at the front automatically totals and gives afr/air etc. The AIR/AFR is only populated in the master sheet, if you need to populate it by dept/contractor let me know and I will PM you how to do it.


2. KPI Charts. Should automatically update from the KPI Template sheet.

KPI Template.xlsx

KPI Charts Template.xlsx

Jack/Alexis feel free to use in downloads, maybe worth while putting above explanation with them, or link to this post?

Will .salut
.salut .salut .salut Many thanks Will.
"A candle loses none of its light by lighting another candle."

Image

http://www.safetyjobsonline.com/

Foolsgold
Student
Student
Posts: 44
Joined: Tue Dec 14, 2010 9:54 pm

Re: Incident stats

Post by Foolsgold » Fri Feb 17, 2017 1:19 pm

Many thanks Will!

User avatar
TWDB
Student
Student
Posts: 73
Joined: Thu Apr 11, 2013 3:24 pm

Re: Incident stats

Post by TWDB » Mon Feb 20, 2017 1:06 pm

Thanks all,

much appreciated as always

T

Post Reply

Who is online

Users browsing this forum: Bing [Bot] and 2 guests

 

 Health, Environment and Risk Training - for all your NEBOSH, IOSH and in-house training. Contact us for excellent consultancy rates  Ritchies Training Centre Ltd - IOSH Working & Managing Safely, NEBOSH Certificates: General / Construction / Fire / Environmental, SVQs in - Health & Safety Levels 3, 4 & 5; Learning Development 3, 4 & 5; Management 3, 4 & 5

Follow us on Twitter Find us on Facebook Find us on on LinkedIn

Terms of Use Privacy Policy