accident frequency rate calculation excel

4. Save my name, email, and website in this browser for the next time I comment. The fifth annual Safe + Sound Week kicks off August 9th! Enter the bin numbers in another column. The idea behind any measurement - and the purpose of measuring - is to understand how you are performing and make well-informed decisions about how to improve. Oops, something went wrong. To calculate an organizations DART incident rate, simply add up the number of recordable injuries or illnesses which led to days away, restricted, or transferred and multiply it by 200,000. Simply counting this table will be enough for companies who record accidents this way, while other companies will need to pull the data from other places like spreadsheets, management systems or specific files. Method of calculation : Frequency rate = number of accidents with sick leave X 1 000 000 /number of worked hours To calculate the number of worked hours , you have to multiply : staff full-time equivalent of the company and the number of working hours made every year by a full-time person. Here is how the Injury Frequency Rate calculation can be explained with given input values -> 20 = 5*100000/25000. While they are a useful tool to measure how successful your safety program is, you cannot use them to make predictions. It gives information about how frequently accidents occur and is represented as, The Injury Frequency Rate is the number of disabling injuries occurred per one lakh man hour worked. People in 100+ countries use this safety management system to track and improve their safety KPI's. Take a real look at your ending AFR result and use it as an indicator of safety performance and success, but also focus on how you are collecting and tracking all of your safety information - because that is going to be incredibly useful in making informed decisions about how to improve - and ultimately lowering that AFR number. Beaverton, OR 97008, U.S./Canada: 1-866-777-1360 International: +1 503-828-9400. 4 Behavioral approach. Different companies pull and derive their accident data from different places. WebThe formula for calculating your accident frequency rate is the number of reported accidents multiplied by 200,000, divided by the number of employee hours worked. 5. (function() { var qs,j,q,s,d=document, gi=d.getElementById, In this case, your formula is telling Excel to look at B2-B10 and use the ranges in C2-C4 to calculate frequency. It gives information about how frequently accidents occur is calculated using. Below is an LTIFR calculation example which helps to illustrate exactly what an LTIFR calculation does look like. There are currently 1 users browsing this thread. The easiest way to track these safety KPI's over time is to use a proper safety management system. Re: Rolling Accident Frequency Rate formula is? The 200,000 number in many formulas is a benchmark established by OSHA to compare your own hours to, because it represents what 100 employees would work in 50 weeks based on the average 40-hour work week. Some companies still use paper log forms and other sheets, and then reconcile the data before placing it into a calculator. It is a measure of the number of injuries per 1,000 employees In general, the safety KPI's can be bucketed into two categories: Because of the similarities between the two, you can actually convert a frequency rate to an incident rate by simply substituting the number of hours worked out of the equation, and replacing it with the number of employees. This information lends credibility to the users in the event of an inspection. Road Segment Rate Calculation. The LTIFR formula is: As with other incident rates, a good Lost Time Incident Rate is one that is as low as possible. An OSHA Incident Rate calculator makes it easy to follow through with a TRIR calculation. Let's take a case where a company has had 4 recorded accidents in the previous year, and are looking to do an AFR calculation for the previous year. [U:!Q"+lL ,b endstream endobj 21 0 obj <>>>/EncryptMetadata false/Filter/Standard/Length 128/O(~w/\(54oR )/P -4/R 4/StmF/StdCF/StrF/StdCF/U(CIIjk "y# )/V 4>> endobj 22 0 obj <>>>/Metadata 11 0 R/Outlines 17 0 R/Pages 18 0 R/Type/Catalog/ViewerPreferences<>>> endobj 23 0 obj <>/ExtGState<>/Font<>/ProcSet[/PDF/Text]/Shading<>/XObject<>>>/Rotate 0/Tabs/W/Thumb 9 0 R/TrimBox[0.0 0.0 612.0 792.0]/Type/Page>> endobj 24 0 obj <>stream A Lost Workday Incident (LWDI) considers the number of days of missed work, not days that involve restricted tasks. j.src=b+"calconic.min.js"; q=gt.call(d,"script")[0]; q.parentNode.insertBefore(j,q) } Open your project in Excel. Measuring your LTIFR is actually easier than you think. For some companies, the OSHA 300 log is what is used to record and analyse workplace accidents. She earned an MA in Writing from Rowan University in 2012 and wrote her thesis on online communities and the personalities curated in such communities. Injury frequency rate defines the number of disabling injuries per one lakh man hours worked. WebAccident Incidence Rate Formula. The result here is 6.95 accidents per 100 employees, which could be relatively high depending on the industry. 1 million in FR/SR calculation indicates - 500 (working)X 50 (weeks per year)X40 (working hours per week) =1000000 man hours. You can see more AFR industry averages here. Before employees begin work on any job, ensurehazard assessmentsare being conducted and immediately uploaded into yoursafety management system. As we know, there are two variables in the calculation which we can make more accurate and impact: the reported accidents and the total numbers of hours worked. Level up your tech skills and stay ahead of the curve. We use cookies to make wikiHow great. You can see some LTIFR industry averages here. For example, if you you were to calculate the frequency rate of lost time injuries (LTI's), you would first find the number of lost time injuries in the reporting period, multiple that by 1,000,000, and then divide that by the total hours worked in the reporting period. In fact, it's about the second step of the process after tracking and compiling the individual results. 60-(G"% X!O st4RTzD1<=Ef'PT(x$v(;,? All tip submissions are carefully reviewed before being published. *c~9FFiXe!L*~%UX^C{k qcw{$`Xs~":x` F%oape]Ib$9 a9x90@Nr)@4! There are many benefits to measuring this rate: Overall, the lower the rate, the better the safety performance. Why 200,000? https://ecompliance.com/wp-content/uploads/2017/10/MEGA_NAV_TRAINING.jpg, https://ecompliance.com/wp-content/uploads/2017/10/MEGA_NAV_CONTROLS.jpg, https://ecompliance.com/wp-content/uploads/2017/10/MEGA_NAV_INFRASTRUCTURE.jpg, https://ecompliance.com/wp-content/uploads/2017/10/MEGA_NAV_UTILITIES.jpg, https://ecompliance.com/wp-content/uploads/2017/10/MEGA_NAV_ENERGY.jpg, https://ecompliance.com/wp-content/uploads/2017/10/MEGA_NAV_CONSTRUCTION.jpg, https://ecompliance.com/wp-content/uploads/2017/10/MEGA_NAV_MANUFACTURING.jpg, https://ecompliance.com/wp-content/uploads/2017/10/MEGA_NAV_MINING.jpg, Weve been talking a lot recently about the importance of, . Gives a company an average of the number of lost days per recordable incident. Safety is one of those functions or areas of a business which are typically harder to measure than financial performance or productivity. As you can see, there are just three parts of the LTIFR formula, two of which need to be reconciled on your end, and then the 1,000,000 figure which remains the same across all LTIFR calculations and is used to standardise the LTIRF 'score' into per million hours worked. Save my name, email, and website in this browser for the next time I comment. As we know, there are two variables in the calculation which we can make more accurate and impact: the reported accidents and the total numbers of hours worked. How many ways are there to calculate Injury frequency rate? We accept Visa, Mastercard, Discover, American Express, and Purchase Orders. The only other part of the safety KPI which needs defining is the difference between lagging and leading indicators. For example, you're scoring a test with the scores listed in B2-B10, so you'll input. A lagging indicator that is used to measure workplace injuries and illnesses that result in time away from work, restricted job roles, or permanent transfers to new positions. Creative Safety Supply, LLC Complete this form and one of our safety experts will be in touch. The pressure on companies to create healthy and safe working environments is constantly increasing. The function formula will apply to the selected cells and you'll see the results. A good TRIR rate is relative to the industry and type of work done, but once youve completed your calculation you can compare it to findings from the Bureau of Labor Statistics (BLS). Web500,000 hours worked on the project From these two numbers, which would have been documented and collected during the phase of works, the company can calculate their hbbd``b`6/ KA\Q There are a number of safety KPI's which help workers, safety teams and companies to gauge their safety importance, track it over time, and ultimately make better decisions about how to improve it. With the new rule from the FAA, learn how to use a UAV for safety! Formula AFR is calculated on the basis of all incidents reportable under RIDDOR and presented as a 12 month rolling average, per 100,000 hours worked. Number of work-related injuries 1,000 / Average number of employees. So if you have 8 lost time injuries and 3 million hours worked, your LTIFR is 2.6. WebTo describe the road accident phenomenology different numerical performance indices are used:-Accidents frequency [accidents/year]: number of accidents per year, usually referred to a 35-year period;. Web and mobile-based integrated management system and digital database used by office workers, leading hands and managers to document, manage and analyse information, User friendly mobile app and Digital ID for your general workforce and any site visitors to easily signoff, submit and review forms electronically, Digitise & streamline your standard operating procedures, Site diaries, variations, delays, change orders & more, Inspections, maintenance, registers, sign outs & more, Progress reports, production tracking, waste tracking & more, Timesheets, dayworks sheets, purchase requests & more, Document assembly, automation & analytics, Digital ID cards, electronic forms and e-signatures, Digitise your standard operating procedures, Site diaries, variations, change orders & more, Inspections, maintenance, signouts & more. Higher frequency rates may result in poor credibility of the organization within your industry, higher insurance premiums, and more turnover as employees dont feel protected on site. 2 Physical approach 1.1 safety departments (u#&,se\Xo2KR[;] 0/P~Rm ?xRp]0tH!ht/c^!Q*=+./;R{gP pm wu<2f|eMG>b*hew6tuY="M|Fa7tJc +*2"b9]o};%:@Y5Ml%!a}.{%)]+R K>IRTp\f`ble] IkPg$k+9\S$/MsW{#]-yx~qUDu4 x M7wG| e&Q&tSO-y==?7Fd 2l7&'tu;:3}cK)j:Pv=| OfC>$]R.uxD5(}8d)xWc!$.A^X;r{Ll&Zvh+?3|x\UEyq[;~)v[2rt*hp)B,KbE;m +2e2 8 }7f,FkVDZ|8E{/BXuoQzlQws$tEi$[J,fVJuD9&A3leSY. In many cases it is a good general indicator of a workplaces health and safety environment. Simply counting this table will be enough for companies who record accidents this way, while other companies will need to pull the data from other places like spreadsheets, management systems or specific files. By signing up you are agreeing to receive emails according to our privacy policy. As you can see from the above, the accident frequency rate is straightforward formula and easy to calculate. +>d`av5I@Y6%LIu? This is a measure of all reportable injuries - lost time injuries, restricted work injuries and medical treatment cases - per 200,000 hours worked. No matter how many resources you have to invest in 'safety', tracking safety KPI's is a critical part of operating a business. Frequency index Your AFR number is important for a number of internal reasons and purposes, but it can also have a large impact on external factors including audits and insurances. An OSHA Incident Rate is a measure of how often a recordable injury or illness occurs at your business over a specified period, typically over the course of a year. The formula is as follows: ([Number of lost time injuries in the reporting period] x 1,000,000) / (Total hours worked in the reporting period). (4 reported accidents x 200,000) / 115,000 = 6.95. With this number you can assess your safety performance and gauge how strong your safety program is. Man hours are based on a 12 hour working day or actual hours worked if recorded. This calculation is commonly used across the construction industry to compare safety performance. To calculate the overhead rate per employee, follow the steps below:Calculate the labor cost which includes not just the weekly or hourly pay but also health benefits, vacation pay, pension and retirement benefits paid by the employer.Compute the total overheads of the business.Divide the overhead costs by the number of billable hours. More items This article was co-authored by wikiHow staff writer, Darlene Antonelli, MA. We can use 1 other way(s) to calculate the same, which is/are as follows -. You can see more AFR industry averages here. The accident frequency calculation is the end result of a years worth of collected data, and is the culmination of many safety meetings and process changes. Learn how prevent heat related illnesses in the workplace. Making employees aware of unsafe behaviors they may unknowingly be practicing, can make a huge impact on reducing workplace injuries. How to calculate Injury Frequency Rate using this online calculator? For more information on how to use workplace safety indicators like LTIFR to your advantage, check out our guide,How to Leverage Your EHS Data to Improve Safety Outcomes. His aim is to bring awareness to a brighter future for the Built World where industrial workers and companies work smarter. company and a total of 2,500,000 hours worked. This rate is also a useful tool for EHS managers, who can use DART to evaluate the type of impact injuries or illnesses make on a business over time. qb-mZW,#B5?i;CTZ_bm\OD29YE^!g\@"^owh{X5qEFRJeM) _5Z[o'1bM2J)[Q[0 zwQUk6k:ui{PM( endstream endobj 26 0 obj <>stream Webfocus for all RIDDOR injury-incidents and therefore is suitable for measuring workforce health and safety performance. The first thing every EHS leader should do is create a safety culture that, Before employees begin work on any job, ensure, are being conducted and immediately uploaded into your. The ANSI/ASME A13.1 pipe marking color code explained. Injury frequency rate is denoted by Ir symbol. Re: Total Recordable Injury Frequency Rate (TRIFR) Sorry forgot the formula (Number of injuries in the last 12 months / Total hours worked in the same 12 Proper warehouse management can dramatically improve both efficiency and safety. This way risks can be documented and controls can be put in place quickly, to help prevent incidents from happening and protect the workforce. It could be as little as one day or shift. Lagging indicators measure a company's 'past' performance i.e what has happened. There is a difference between the frequency rate and the severity rate of injuries. Include your email address to get a message when this question is answered. W2? 2. Weve been talking a lot recently about the importance of safety reporting and safety programs specifically, howautomationcan improve our processes and data collection best practices and how real-time safety visibility can help us enhance safety programs. These are types of occupational injuries and illnesses that specifically result in Days Away, Restricted, or Transferred; employees end up remaining away from work, restricting their work activities, or transferring to a different job location within a year. It's also what the auditors and other authorities will be looking at and analysing if there are any red flags in your results or procedures. +X"E-=pO1H_cOILD9W"z:sg80rRUGS?QqX5C3o PK ! As with most calculations and metrics, the difficulty in any AFR measurement comes in collecting the data properly and efficiently, Finding smarter ways to document and keep track of this data is by far the quickest and most reliable way to sure up your AFR calculations. if(!gi.call(d,id)) { j=ce.call(d,"script"); j.id=id; j.type="text/javascript"; j.async=true; For example, if an employee broke their wrist on Monday and had to miss the next three days, returned to work on Friday to be given limited work tasks, and missed two more days several weeks later to get their cast removed, the total number of lost workdays is five. This type of KPI is more internally focused as no safety authority is going to set a number for the required frequency of risk assessments because it's so variable. The formula to calculate TCIR/TRIR is: For many safety rates, you must calculate hours worked. Incidence rate = (Total number of recordable incident) x 200,000 / (Total manhour worked for one year) OSHA recordable incident rate is used by OSHA to gauge a companys safety performance. NOTE: OSHA requires accident rates to be calculated as incidents per 100 full-time employees. You can use this information to calculate the average number of hours worked by each worker during that time frame. Adequate training can help you avoid accidents in the workplace and vastly reduce injury and incident rates. The aim of using OSHA incident rates and maintaining a successful safety program is to promote workers well-being. 3. 3.2.1. Because of this, it's important to get your AFR numbers and the resulting calculation right. You can see how to calculate specific KPI's above, and you'll also notice a number of similarities in how they are calculated. 3 Economic incentives Overall, the average OSHA Incident Rate is 2.9 cases per 100 full-time employees in private industry. Almost all companies today - especially those in heavy industries where safety has been a concern - calculate their safety key performance indicators on a regular basis. Easily create UPC codes or other barcode symbologies and download the file to print. Lagging safety indicators are often the most publicised safety metrics, as they include the headline stats like recorded injuries and incidents. WebActual Rate (L) = E + F x H Expected Rate (M) = (G + H) x H Experience Modification Rate = L / M What is the Lowest EMR Rating Possible? V = Number of vehicles per day (both directions). A good DART rate is ideally lower than the TCIR/TRIR rate a company possesses. By using our site, you agree to our. 22nd July 2014 From Philippines, San Pablo City. The DART rate differs from the TCIR/TRIR rate in that it includes only those OSHA recordable injuries or illnesses that resulted in days away, transfer, or restricted duty, while the TCIR calculates the number ofallrecordable injuries and illnesses. His aim is to bring awareness to a brighter future for the Built World where industrial workers and companies work smarter. per 1 000 000 hours : the number of new cases of injury during the calendar year divided byyy the total number of hours worked by workers in the (Number of recordable cases x 1,000,000) / Employee total hours worked. q [Content_Types].xml ( n0US0Mdi 4MQiFm=oj!vd2)m%,(Y(G7fmdUsZDz \AwlcF'>Hddw*h)"U\CAVa0m{ _EM|cOiJ7k UM( 20 0 obj <> endobj 52 0 obj <>/Encrypt 21 0 R/Filter/FlateDecode/ID[]/Index[20 55]/Info 19 0 R/Length 125/Prev 82667/Root 22 0 R/Size 75/Type/XRef/W[1 2 1]>>stream Enter the formula (Reportable injuries x 200,000) / Employee total hours worked, The frequency rate is the number of occupational accidents ( work stopped more than one day) arisen during a period of 12 months by one million hours worked. Accidents density [accidents/(years*km)]: corresponding to the accident frequency value divided by the length of the considered road section;. Select a range with one extra cell to display the results. 1.3 safety cost Web and mobile-based integrated management system and digital database used by office workers, leading hands and managers to document, manage and analyse information, User friendly mobile app and Digital ID for your general workforce and any site visitors to easily signoff, submit and review forms electronically, Digitise & streamline your standard operating procedures, Site diaries, variations, delays, change orders & more, Inspections, maintenance, registers, sign outs & more, Progress reports, production tracking, waste tracking & more, Timesheets, dayworks sheets, purchase requests & more, Document assembly, automation & analytics, Digital ID cards, electronic forms and e-signatures, Digitise your standard operating procedures, Site diaries, variations, change orders & more, Inspections, maintenance, signouts & more. 200,000 represents forty hours a week that 100 employees would work for 50 weeks during one year. This simple chart explains the meaning behind each of the colors commonly found on OSHA-mandated signs. Most companies choose to calculate LTIFR per 1 million man hours worked. 9 To calculate your LTIFR, simply plug those numbers into your formula: And voila! WebMedical Treatment Injury Frequency Rate (MTIFR) (MTIFR) 12 Month Rolling Average Total Recordable Frequency Rate (TRFR = LTI + MTI) Number of First Aid Cases (FAC) Number of Near Misses Number of Environmental Incidents Number of Damage Reports Number of Thefts Year N/M Lost Time Injuries the number of lost time injuries that occurred during the reporting period. Now that youve successfully calculated your LTIFR, you can use that data to benchmark performance and see how you stack up against your industry peers. the number of lost time injuries that occurred during the reporting period. You've been added to our distribution list. Part of this pressure comes from external stakeholders, parties and authorities, while the other portion stems from internal workers and teams. This visual safety guide will provide everything you need to know about properly marking floors in your warehouse or facility. Thanks to all authors for creating a page that has been read 16,995 times. OH97 Za Register To Reply. The formula for calculating Lost Time Injury Frequency Rates is very simple. An injury or disease that resulted in a certain level of treatment (not first aid treatment) given by a physician or other medical personnel under standing orders of a physician. Because of this, it's important to get your AFR numbers and the resulting calculation right. Now, lets use an example to further illustrate: After reviewing and compiling your safety data, youve determined that there were six lost time, work-related injuries in the past year at yourmanufacturingcompany and a total of 2,500,000 hours worked. Common leading safety indicators include safety training and safety audits. People in 80+ countries use this safety management system to set, track and calculate their safety KPI's in real-time. Health and Safety KPIs: Lost Time Injury Incidence Rate Excel spreadsheets can be quickly and easily updated and tracked against historic numbers, Online calculators and physical calculators can be used to make the calculation but don't have any additional context, Dedicated software gives you a place for tracking and analysing the AFR but requires costs/investment, 200,000 to standardise the number per 100 employees over 12 months, A total of 115,000 hours worked across the company or project. But a leading indicator like this is going to be one of the most important for the safety team because it shows safety participation ad engagement - and will reduce incidents in the long run. WebTo work out the LTIFR you multiply the number of lost time injuries by 1,000,000 then divide that number by the total number of hours worked in an organization. This means we spend time thinking about how people interact with the world around them; about the cognitive process. For many safety rates, you must calculate hours worked. An example safety KPI which a safety officer is going to really care about is the number of risk assessments performed. In the example, B2-B10 contained test scores while C2-C4 contained bin numbers (70, 79, and 89). U0# L _rels/.rels ( MO0HBKwAH!T~I$'TG~;#wqu*&rFqvGJy(v*K#FD.W =ZMYbBS7 ?9Lsbg|l!USh9ibr:"y_dlD|-NR"42G%Z4y7 PK ! WebInjury Frequency Rate calculator uses Injury frequency rate = Number of Disabling Injuries*100000/Man Hour to calculate the Injury frequency rate, The Injury By evaluating your companys safety performance and focusing on prevention, operations will continue to be successful as workers are kept happy and healthy. The number of reported accidents is derived from your operations, as is the total hours worked, while the number 200,000 is used in a number of safety KPI's to standardise the AFR and express it as the number of accidents per 100 employees (200,000 equals 40 hours per week x 100 employees x 50 weeks per year). Using a one-stop safety rate calculator that includes lost time cases, lost workdays, DART cases, total recordable incidents, and total hours worked is an effective way to evaluate safety and take into account several different factors that may influence incidence rates. (Number of DART incidents) x 200,000 / (Total number of hours worked). Ve!0.91rNpsPU&\ymjrq_VERu+sUf`x]^{Np6GJ4fYw~@[93rosy`AW\H"cor3D|PO}c_#cKO y5o._91m.8]=+w=ip{F}46#2r1?vp[&5I7Q>ve&n ,w[AD~AQ_bY[.GCy4 [zRiA)QAPq{zSdVEL.E;kext$+ydQ%?JJd8(C|E6a endstream endobj 27 0 obj <>stream The most difficult way to keep track of these numbers is to 'assemble' them at the end of the year or reporting period after capturing them with paper-based forms, word docs, spreadsheets and PDFs. They are often used to estimate safety performance, then to develop programs and policies for future prevention. The above safety KPI table and information will be good references for you no matter how extensive and sophisticated your current safety KPI tracking is. These rates involve recordable injuries and illnesses, which OSHA defines as any work-related incidents that result in death, loss of consciousness, days away from work, restricted work, medical treatment beyond first aid, or transfer to another job. Here you will find more information, examples and more detail around the KPI calculation itself. Dear friend, It is optimization of the safety result (FR/SR) w.r.t 500 workers. Introduced as part of the Toyota Production System, Poka Yoke works to prevent human error and was even once known as "fool proofing.". For some companies, the OSHA 300 log is what is used to record and analyse workplace accidents. What are the approaches to improve the safety in construction field. Copyright 2023 Creative Safety Supply | All Rights Reserved. Rolling Accident Frequency Rate formula is? This method works for Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2019-2007, Excel 2019 for Mac, Excel 2016-2011 for Mac, and Excel Starter 2010. Other companies rely on updating a tracking spreadsheet with data from the field at regular intervals. People in 100+ countries use this safety management system to track and improve their safety KPI's. The AFR gives the accident rate per 100,000 hours worked and is The In the past, a company may have been able to make an excuse for an individual mistake or mishap, but safety KPI's show average performance and trends over time - which can't be ignored or excused. Lance is VP of Marketing at Sitemate. Ways to maintain a low incident rate include defining your safety culture and implementing an incident investigation process; these events must be handled correctly, and its best to take steps to learn from your mistakes to prevent future incidents. According to the U.S. Bureau of Labor Statistics, the incident rates of each private industry sector for 2020 are: The main causes of these incidents include sprains and strains, cuts and lacerations, overexertion, transportation accidents, unsafe contact with objects or equipment, physical violence, and falls, slips, trips. To use this online calculator for Injury Frequency Rate, enter Number of Disabling Injuries (In) & Man Hour (Nmh) and hit the calculate button. Workers look elsewhere for employment where they believe they will be better taken care of. To get replies by our experts at nominal charges, follow this link to buy points and post ! Injury Frequency Rate calculator uses Injury frequency rate = Number of Disabling Injuries*100000/Man Hour to calculate the Injury frequency rate, The Injury Frequency Rate is the number of disabling injuries occurred per one lakh man hour worked. Workplace injury prevention strategies should be prioritized, and the key to this is the collection and analysis of data such as incident rates. The day the illness or injury occurred is not counted as a lost workday, and the total number possible for lost days due to a single incident is capped at 180. wikiHow is where trusted research and expert knowledge come together. (Number of recordable cases x 200,000) / Employee total hours worked, (Number of recordable injuries and illnesses x 200,000) / Employee total hours worked, (Recorded fatalities, LTIs, alternate work, and other injuries requiring medical treatment from a professional x 1,000,000) / Employee total hours worked, (Number of reportable accidents x 200,000)/ Employee total hours worked, ([Number of lost time injuries in the reporting period] x 1,000,000) / (Total hours worked in the reporting period).

accident frequency rate calculation excel 2023