Exporting lost time case rate into Excels sheet.
How to export lost time case rate into Excels sheet?
Similar questions: How to view LTI case rate in numbers?
Only units that have man-worked hours populated and have had lost time
injury incidents associated with them will have LTI rate above 0. Units that
did not have LTI incidents associated with them or don’t have man-worked hours
indicated will have rate of 0 for that year according to the formula 200 000 x
number of incidents/man-worked hours.
- Go to
module and select
in the left side menu – second section will be OSHA yearly rate. Once cursor is placed on a dot in the place of graph crossing the vertical line of a certain year, a box will appear showing the rate figure for that unit, whose color of the bar or line that is (color corresponds to the unit bar color as described above the graph)
- In order to export these numbers in Excels format click on
button in the upper right corner of the window. File will be downloaded to your computer and can be viewed as a table with figures of lost time incidence by each year you selected in settings to have data for
Please note that there will be only one single line with lost time case
rates figures per each year in the table in case you’ve selected to merge units
in the settings window.