Exporting lost time case rate into Excels sheet.

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.

  1.  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)

                                         
                                                     

  1.  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.



    • Related Articles

    • Lost time case rate -- setting up the Dashboard.

      Setting up the Dashboard for lost time case rate. Similar questions: How to view lost time injury rate per unit? In order to obtain correct graph on lost time case rate dashboard it is necessary that man-worked hours are populated in the table of ...
    • Setting up Severity rate dashboard.

      Settings for Severity rate Dashboard. Similar questions: How to adjust the Severity rate graph? To have a severity rate figure other than 0, a unit has to have man-worked hours indicated and lost time-injury cases associated with it with the number ...
    • How to set up DART rate dashboard?

      How to set up DART rate dashboard? Similar questions: How to view the DART rate for selected organizational units? To have a DART rate figure other than 0 for a certain year, a unit has to have man-worked hours indicated for that year and lost ...
    • How export OSHA rate into Excels?

      How to export OSHA rate into Excels? Similar questions: How to view OSHA rate in numbers? Only units that have man-worked hours populated and have had recordable incidents will have incidence rate above 0. Units that did not have recordable incidents ...
    • Arranging OSHA incidence rate dashboard.

      Setting up OSHA rate dashboard. Similar questions: How to view OSHA rate per each unit separately and for all organization combined? In order to obtain correct graph on OSHA rate dashboard it is necessary that man-worked hours are populated in the ...