Incident stats

[TWDB]

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

[Foolsgold]

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

[Alexis]

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

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.

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

[WillPool]

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

Will

[Alexis]

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

Will

Many thanks Will.

[WillPool]

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 146 times

KPI Charts Template.xlsx

(60.07 KiB) Downloaded 142 times

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

Will

[Alexis]

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

Many thanks Will.

[Foolsgold]

Many thanks Will!

[TWDB]

Thanks all,

much appreciated as always

T