Incident stats
Moderator: Moderators
- TWDB
- Snr Member
- Posts: 390
- Joined: Thu Apr 11, 2013 3:24 pm
- 11
- Industry Sector: Civil Eng, HV Elec, Remediation Soil/Wat
- Occupation: SHEQ Manager
- Location: UK WIDE
- Has thanked: 177 times
- Been thanked: 29 times
Incident stats
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
T
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
T
Update: taken a new job hopefully confidence and positivity will return with new challenge - scary though leaving current place after 16 years (6 years H&S !)
(previous signature: was motivated once ..................... searching to get it back ! )
(previous signature: was motivated once ..................... searching to get it back ! )
- Alexis
- Official HSfB Legend
- Posts: 48846
- Joined: Thu Mar 18, 2004 10:52 am
- 20
- Twitter: https://twitter.com/AlexisHSfB
- Location: West Lothian
- Has thanked: 2823 times
- Been thanked: 340 times
- Contact:
Re: Incident stats
Many of our Downloads have been donated freely by our amazing members over the years, which we are most grateful for, 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.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
T
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. 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."
Hundreds of FREE Health & Safety Downloads Here
Hundreds of FREE Health & Safety Downloads Here
- WillPool
- HSfB Moderator
- Posts: 10784
- Joined: Mon Mar 13, 2006 8:45 pm
- 18
- Industry Sector: Construction/Civils/Telecomms
- Occupation: Regional Safety Director
- Location: Tabuk - Saudi Arabia
- Has thanked: 24 times
- Been thanked: 312 times
- Contact:
Re: Incident stats
I will see if what I use can be adapted for member use
Will
Will
It is better to be careful 100 times than to get killed once.
Mark Twain (1835 - 1910)
Mark Twain (1835 - 1910)
- Alexis
- Official HSfB Legend
- Posts: 48846
- Joined: Thu Mar 18, 2004 10:52 am
- 20
- Twitter: https://twitter.com/AlexisHSfB
- Location: West Lothian
- Has thanked: 2823 times
- Been thanked: 340 times
- Contact:
Re: Incident stats
Many thanks Will.
"A candle loses none of its light by lighting another candle."
Hundreds of FREE Health & Safety Downloads Here
Hundreds of FREE Health & Safety Downloads Here
- WillPool
- HSfB Moderator
- Posts: 10784
- Joined: Mon Mar 13, 2006 8:45 pm
- 18
- Industry Sector: Construction/Civils/Telecomms
- Occupation: Regional Safety Director
- Location: Tabuk - Saudi Arabia
- Has thanked: 24 times
- Been thanked: 312 times
- Contact:
Re: Incident stats
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.
Jack/Alexis feel free to use in downloads, maybe worth while putting above explanation with them, or link to this post?
Will
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.
Jack/Alexis feel free to use in downloads, maybe worth while putting above explanation with them, or link to this post?
Will
It is better to be careful 100 times than to get killed once.
Mark Twain (1835 - 1910)
Mark Twain (1835 - 1910)
- Alexis
- Official HSfB Legend
- Posts: 48846
- Joined: Thu Mar 18, 2004 10:52 am
- 20
- Twitter: https://twitter.com/AlexisHSfB
- Location: West Lothian
- Has thanked: 2823 times
- Been thanked: 340 times
- Contact:
Re: Incident stats
Many thanks Will.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
"A candle loses none of its light by lighting another candle."
Hundreds of FREE Health & Safety Downloads Here
Hundreds of FREE Health & Safety Downloads Here
- TWDB
- Snr Member
- Posts: 390
- Joined: Thu Apr 11, 2013 3:24 pm
- 11
- Industry Sector: Civil Eng, HV Elec, Remediation Soil/Wat
- Occupation: SHEQ Manager
- Location: UK WIDE
- Has thanked: 177 times
- Been thanked: 29 times
Re: Incident stats
Thanks all,
much appreciated as always
T
much appreciated as always
T
Update: taken a new job hopefully confidence and positivity will return with new challenge - scary though leaving current place after 16 years (6 years H&S !)
(previous signature: was motivated once ..................... searching to get it back ! )
(previous signature: was motivated once ..................... searching to get it back ! )