Injury Data and Statistics Spreadsheet
With Thanks to Roy Keatley
DOWNLOAD HERE: Copy of Data statistics draftV1
Within the work book there is two types of sheets one with Leading Indicators Under the Monthly Stats Tab,
The other is under the current Stats Tab. Just a different variation of KPI’s (lower area)
The hours must be entered in on the hours row they will automatically update rolling average of hours.
And the last Tab Is a monthly lead and lagging indicator records sheet.
I’m not saying these worksheets are flawless as I’m not an excel expert. They automatically update and do what is required for my use
LTIFR
LTIFR Moving average
MTIFR
MTIFR 12 month Moving Average
TRIFR.