g. As you can see from the above formula and calculation, a low severity. 2020_accidents_rate （Excel 60KB） LTIFR (Lost Time Injury Frequency Rate) in Japan (1986-2020) （Excel 40KB） 2020_fatal_accidents_rate （Excel 37KB） Result of medical examination in 2020 2020_medical_examination （Excel 37KB） Analyzed in detail as below Industrial Accidents Statistics in Japan (2020)Notes: 1. 00 1. 9 Man-days Lost4 530,961 544,664 Per 100,000 workers A workplace injury is any personal injury or death resulting from a workplace accident, including work-related traffic injuries. Lost Time Injury Frequency Rate. 8 attributed to ill health and £5. Safety Stock Method 2: Average – Max Formula. Re: Total Recordable Injury Frequency Rate (TRIFR) Sorry forgot the formula. 3. You can see the number and frequency of accidents is displayed in the top section, and the bottom section features the type of accident. Construction Accident. Note: to compute an "annualized" vehicle accident rate for less than 12 months, it is necessary to multiply the number. . That number marks the highest number of fatalities since 2007. Visit Discussion Forum for Online Accident Incident Rate Calculator tool. Accident frequency rate is one of the standard safety measures which companies use to identify and analyse the number of occupational accidents which take place in the workplace. 3 KPI 1: Safety Risk 13 3. 1 injury. The fatal work injury rate was 3. The other element of the equation is the standardized rate, that is to say, there are X number of LTIs per a set amount of time. Some people confuse this formula with the formula for lost time injuries, but the total recordable injury frequency rate includes all injuries requiring medical treatment from a medical professional - which in theory means that it will be a larger number. Road accidents are measured in terms of the number of persons injured and deaths due to road accidents, whether immediate or within 30 days of the accident, and excluding suicides involving the use of road motor vehicles. 5) XYZ Company has 800 employees who work 8 hour shifts for 240. the scarlet pimpernel musical bootleg. this is not included in the AFR calculation. 9. With our new Excel based Safety Metrics & Graphing Calculator Tool, users can perform these basic functions quickly and easily: Automatically generate TRI Rates, DART Rates, LTI Rates and Severity Rates. Now that you’ve successfully calculated your LTIFR, you can use that data to benchmark performance and. Useful for measuring deficiencies and deviations. SR Calc Sheet - Free download as Excel Spreadsheet (. How to calculate Frequency Rate, Severity Rate & Incident Rate in Hindi | Health Prevalence. In this case, your formula is telling Excel to look at B2-B10 and use the ranges in C2-C4 to calculate frequency. For example, if all your employees during last year worked for a total number of hours equal to 2,000,000, and your number of recordable injuries is 2: TRIR = (2 × 200000) / 2000000 = 400000 / 2000000 =. Employee Labor Hours Worked. Economic Order Quantity (EOQ) D = Demand or consumption 12 000. : Frequency Rate (FR) = (Number of Recordable Incidents / Total Hours Worked) x 1,000,000 Frequency Rate (FR) = (20 / 500,000) x 1,000,000 Frequency Rate (FR) = 40. Jiothish Mohan. When considered in relation to the employee headcount or hours worked, this data allows you to draw. Safety Stock Calculation: 6 different formulas. 01 (1 accident every 0. The formulae used to calculate the incidence estimate and rate of over 3-day absence injury relating to individuals working in the last 12 months for overall and individual characteristics such as age and sex are given by: Incidence of over-3-day absence injury. The company is quite small (25) so 1 RIDDOR would make any subsequent frequency rate stand out. Tentukan rate waktu kerja hilang akibat kecelakaan kerja tersebut. March 14, 2023 1:35 am Share This Post. The 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. DISCLAIMER: This calculator was developed based on a research done by DOSH and meant for a quick way to estimate occupational safety and health accident cost. gov. Formula. For example, a company operating 6 sites or contracts which has 5 disabling injuries in a total of 1250000-man hours during a period would have frequency rate of: 5 x 200000 = or No. Using this standardized base rate, any company can calculate their rate(s) and get a percentage per 100 employees. One of my predecessors used an excel formula which automatically assumed everyone worked 37. 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 WebInjury. 1. 4% compared to the 2019 DIFR (9. The severe reduction in flight numbers last year compared to the 5-year average magnified the impact of each accident when we calculate rates. , number of lanes, median type, intersection control, number. Media enquiries 0300 7777 878. LTIFR calculation formula. Safe Work Australia is proud to announce the full release of our data website, data. With our example we obtain N = 12 000/600 = 20. ppt (Size: 5025280K) Accident Investigation. Rate Calculation: An incidence rate of injuries and illnesses is computed from the following formula: (Number of injuries and illnesses x 200,000) / Employee hours worked = Incidence rate. 5 per 100,000 workers (610 major injuries) in 2021 to 17. accident limitation is excluded from the calculation of the employer’s mod and is a non-ratable loss. A simple formula for calculating accident incidence (frequency) is to: Take the total number of recordable incidents for the year from your OSHA 300. TRIR = 2. It helps gauge the impact of injuries on productivity and employee well-being. Now switch to the "Formulas" menu and click the "More Functions" button. 0: 5. Total Recordable Incident RateExample frequency rates Riddor Injury and Frequency Rates 2013/14p for reported injuries Industry4 Major or Specified injuries Over-7-day injuries Riddor ASHE HOUR03 Riddor ASHE HOUR03 Nos Rate5 Frequency Rate Nos Rate5 Frequency Rate A - Agriculture, Forestry And Fishing 292 193. Here's how this formula works: TRIR Rate =. The definition of L. The 2020 DIFR for the federal jurisdiction is 7. of Man-Hours Worked 2 A workplace injury is any personal injury, disease (acute) or death resulting from a workplace accident. 2. Frequency & Severity Rate. 2. The output of this all injury frequency rate calculation is your AIFR 'score' and indicates how many injuries are suffered when standardised across 100 employee working 40 hours per week for one year. 2016 1. For example, if all your employees during last year worked for a total number of hours equal to 2,000,000, and your number of recordable injuries is 2: TRIR = (2 × 200000) / 2000000 = 400000 / 2000000 = 0. The LTIFR calculation is the same as the LTIR formula, but the 200,000 figure is replaced with 1,000,000 in this mathematical calculation. [1] Press ↵ Enter or Ctrl +⇧ Shift +↵ Enter. Bijay. 4 Safety Stocks Methods with the normal distribution. 1 in 2018, according to the Bureau of Labor Statistics. The million multiplier is used because the number of lost time injuries per hours worked is tiny. 4: 5. In this example, the accident frequency rate is 0. Company I work at, employ 95 people on one site, and 30 on another. This is one of the most reliable statistics for forecasting future accident experience. We would like to show you a description here but the site won’t allow us. Some people confuse this formula with the formula for lost time injuries, but the total recordable injury frequency rate includes all injuries requiring medical treatment from a medical professional - which in theory means that it will be a larger number. aviva investors spring week 2021 1 (732) 688 - 7670; intent to possess controlled substance by person not registered; judici white county, il. (b) Comment on why the organisation should be concerned about the accident frequency rate. A perfect TRIR score is zero, which means that there is no OSHA recordable incidents and a good TRIR is 3. Calculating Your Company's LTIFR. The TCR. Source. Table 3. However, the level of risk involved across different occupations varies greatly. Getting confused AFR = No of lost time accidents x 100,000/No of man hours worked AIR = No of work related injuries x 1000/Average No of. 6The severity rate calculation from here would be: Severity rate = (25 lost work days x 200,000) / 2,000,000 hours worked = 1 lost day per accident. Safety Stock Method 3: Normal Distribution with uncertainty about the demand. com or call 0121 248 2063. Definition:- number of accidents per 100 000 employees. injuries requiring medical treatment by a medical professional per million hours worked. Measuring your LTIFR is actually easier than you think. 30. 0 billion by the employer. All 3 types of injuries declined from 2019. accident frequency rate calculation excel. Lost days (consecutive or not), counted from and including the day following the day of the accident, includes injury, diagnosis of occupational poisoning and occupational disease measured in calendar days, the employee wasThe OSHA Total Case Rate (or Total Recordable Injury Rate) is calculated by multiplying the number of OSHA recordable cases by 200,000, and then dividing that number by the number of employee labor hours at the company. Occupational accident rate per 1,000 workers. Quarries Serious Accident Frequency Rate SAFR 3 Month Rolling Average 12 Month Rolling Average Quarries Disabling Injury Frequency Rate DIFR 3 Month Rolling Average 12 Month Rolling Average Quarries Lost Time Injury and Disabling Injury Frequency Rate LTI + DIFR 3 Month Rolling Average 12 Month Rolling Average Quarries Lost Time. . 3 Disabling Injury ( Lost Time Injury ) - An injury causing dis- ablement extending beyond the day of shift on which the accident occurred. Lost time injury rate is a calculation used to determine the frequency of lost time injuries (LTIs). Instead of calculating one incident rate for the whole company or location, calculate multiple incident rates, one for each department or team. The Health and Safety Executive’s (HSE) newly published statistics on workplace fatalities revealed that 147 people were killed at work in the 12 months to the end of March (a rate of 0. Result: 2 * 1 000 000 / 175200 = 11. This is in contrast to the lost time inju. First, select the cells where you want the results to go. accident frequency rate calculation excel 09 Jun. keybank prepaid card services. Lost Time Injury Frequency Rate: the number of lost time injuries that occurred during the reporting period. The formula for calculating a company's incident rate is fairly simple to complete: (The number of incidents in a year x 200,000) / the total number of hours worked by all team members in a year = incident rate. This is done by using the average hours worked to provided estimates: Incidence Rate * 10 / (average Hours per week * Weeks per Year) Severity Rate = No of Days lost x 1,000/Total No. there is absolutely no calculations online which actually show you the outcome of the. (Number of injuries in the last 12 months / Total hours worked in the same 12 months ) * 1,000,000 = TRIFR. Download free DART calculator > DART for small companies. 00. 4 18. 3. 3: Rolling 12 Month Average: 5. They enable you to compare your past performance by year in certain key. You'll need your payroll and classification unit information. PFD Consiltator can be downloaded here. A road motor vehicle is a road vehicle fitted with an engine as the sole means of propulsion. 1 Introduction 13 3. 61 1. Press Enter or Ctrl + Shift + Enter. Incidence rates show the relative level of injuries and illnesses among different industries, firms, or operations within a single firm. FR digunakan untuk identifikasi jumlah cidera yang menyebabkan tidak bisa bekerja per 1 juta orang. It's usually expressed per 10 n people. The reason for calculating an accident frequency rate is to track the number of accidents which occur from project to project or year to year - or to. According to Elvik, more commonly used terms in the international literature are traffic risk instead of fatalityAccident frequency rate is one of the standard safety measures which companies use to identify and analyse the number of occupational accidents which take place in the workplace. 1250000 . 27: Accident Frequency Rate (AFR) and Accident Severity Rate (ASR) in selected sectors, 2017 and 2018 Table 1. au. . 91 per 10,000 (n = 4) would mean that in every group of 10,000, approximately 8. However, they do provide a methodology for generating the Frequency Rates for sectors. A simple formula for calculating accident incidence (frequency) is to: Take the total number of recordable incidents for the year from your OSHA 300. For more information about accessing the statistics, please email infocentre@rospa. Method 1: Basic Safety Stock Formula. Please visit the website and fill out the short online. At the CECA H&S Forum, held on 9 March 2017, it was decided that CECA would continue with the accident statistics report but in a slightly different way. Industry benchmarking. Note that Incidents and Hours are linked with a location. 5m to 19. The crash prediction algorithms consider the effect of a number of roadway segment and intersection variables. Split Point A split rating approach is used to re-flect both the frequency and severity of losses. April 2, 2023. Table 3: Work-related non-fatal injuries to employees in Great Britain, by detailed industry. An incidence rate of injuries and illnesses may be computed from the following formula: (Number of injuries and illnesses X 200,000) / Employee hours worked. The formula for calculating lost time injury frequency rate is the number of lost time injuries multiplied by 1,000,000, divided by the employee total hours worked. bumps after botox forehead 11. Because your excel based. For example, a minor safety incident might not cause more than one hour of production time, but a serious accident can cause weeks or months of lost time. Regular use of this formula will show whether or not a company own accident situation is. The formula used to calculate the accident frequency rate is as follows: Accident Frequency = (Number of Accidents * 200,000) / Employee Hours Worked. 3 Economic incentives Simply counting this table will be enough for companies who record accidents this way, while other companies will need. 69 frequency rate, this company is experiencing 7 accident claims annually for every 10 vehicles. The Lost Time Injury Frequency Rate is the principal measure of safety performance in many companies in Australia. Build automated workflows to process 301, 300 and 300a reports to. The total recordable injury frequency rate (TRIFR) is the number of fatalities, lost time injuries, cases or substitute work and oth. lets take a random month where I work. The crash prediction algorithms consider the effect of a number of roadway segment and intersection variables. The estimated number of people with an over-3-day absence injury at any time. 2. A simple formula for calculating accident incidence (frequency) is to: Take the total number of recordable incidents for the year from your OSHA 300. comparable across any industry or group. Duration Rate = No of Man hours worked/Total No of accidents. Published 24 June 2021. 7m (203k, +1%. 1 million in FR/SR calculation indicates - 500 (working)X 50 (weeks per year)X40 (working hours per week) =1000000 man hours. 00 0. This translated to a fatal injury rate of 1. License: Fair Use/a> (screenshot) /p>/div>"}, {"smallUrl":". 2023-04-23T00:36:33+00:00. Workplace Injury Rate2 373 396 Fatal Injury rate 1. fDART. The Injury Frequency Rate indicates the number of Reportable Injuries employees are likely to have for every 1,000,000 hours worked. accident frequency rate calculation excel accident frequency rate calculation excel. The estimated number of police-reported crashes in 2020 decreased by 22% as. LTIFR will typically be calculated for a specific workplace or project, but it can also be expanded to measure safety in specific regions or industries as well. safeworkaustralia. accident frequency rate calculation excelleeds bands 2000s st louis university women's basketball coach Darlene has experience teaching college courses, writing technology-related articles, and working hands-on in the technology field. Visit Discussion Forum for Online LTIF Calculator tool. Common leading safety indicators include safety training and. of man hours worked. Streamline your OSHA 300 log and 300a summary processes and incident rate tracking with an OSHA 300 app. Reminder!In the computation of Frequency Rate at the last minute of this video, I wrongly misunderstood fatality as injury. 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. accident frequency rate calculation excel. 2-26 Figure 2-8 Incidence Rate Worksheet for _____ Company (Optional) Incidence Rate Columns from OSHA 300 Log 300 Log Column Entry Check specific incident rates from the U. 42 LTIF. To calculate your LTIFR, simply plug those numbers into your formula: (6 x 1,000,000) / 2,500,000 to get a LTIFR = 2. How to Calculate the Accident Rate. 2020 0. 1. The following table indicates the average accident frequency rates for various 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 formula is defined as the number of disabling injuries that occurred per one lakh man hours worked. Table 2: Work-related fatal injuries to members of the public in Great Britain, by detailed industry. Where 200,000 is the # of hours worked in a calendar year by 100 employees and 400,000 is the total # of hours worked in a calendar year by all employees. The formula for calculating AIFR is: AIFR = (Reported injuries x 200,000) / Employee total hours worked The output of this all injury frequency rate calculation is your AIFR. The number 200,000 is used to represent 100 employees working 2,000 hours per year, as the rate that results from this formula is designed to represent the number of lost. S. (+591) (2) 2792420; Av. Two things to remember when totaling. The simplest mortality rate definition is the measure of the frequency of death in a specific population measured over a defined time period. The formulae for Severity Rate is Total number mandays lost x 10,00,000 / Total number of manhours worked. of 9incidents or near-misses) •Incident Rate: –Measures past events. Coupon Rate = (Annual Coupon (or Interest) Payment / Face Value of Bond) * 100. 0 or above. 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. S. Number of Lost Time Cases x 200,000. Register To Reply. Injury frequency rate defines the number of disabling injuries per one lakh man hours worked. e. . Regular safety training sessions both in the classroom and through. Rumus: Incidence Rate = ( Jumlah Kasus x 100) / Jumlah tenaga kerja terpapar Contoh : Masih melanjutkan kasus diatas Incidence Rate = ( 46 x 100 ) / 500 = 9,2% 5. The reason for calculating an accident frequency rate is to track the number of accidents which occur from project to project or year to year - or to. In this formula, the number of accidents refers to the total number of accidents that occurred during the specified period. 4 Behavioral approach. Some people confuse this formula with the formula for lost time injuries, but the total recordable injury frequency rate includes all injuries requiring medical treatment from a medical professional - which in theory means that it will be a larger number. 1(b) for the definition of dangerous occurrence). SR is the total number of lost workdays per year × 200000 work hrs/number of workers in a job. 63 million flights). a mathematical calculation that describes the number of lost time cases per 100 full-time employees in any given time frame. 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. In 2021, there were 2. The Injury Frequency Rate is the number of disabling injuries occurred per one lakh man hour worked. of Man-days Lost to Workplace Accidents x 1,000,000 No. Any accident which is reported on site or in the workplace will become a part of the resulting AFR number. On the drop-down menu, point to the "Statistical" submenu, scroll down a bit, and then click the "FREQUENCY" function. accident frequency rate calculation excel. It also offers an opportunity for users to populate their key performance indicators. 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. Then use the tool below to calculate your company’s rate. r. Definition:- number of accidents per 1 000 000 hours worked. Accident frequency rate. in. anna maria island google map. 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. Association of Workers' Compensation Boards of Canada (AWCBC) 40 University Avenue, Suite 1007. After a thorugh research, i found. Author: Matt Crew Last modified by: John Gilstrap Created Date: 1/11/2012 4:24:24 PM Other titles:LTIFR or the lost time injury frequency rate is a safety measure which refers to the number of lost time injuries occurring per 1 million hours worked. Using a one-stop safety rate calculator that includes. The Lost Time Injury Fatality Rate calculator can now be seen on the Data website. accident frequency rate calculation excel. –This is stated as Lost Time injury (LTI) for workers away from work for 1 day or more. The OSHA DART rate is a safety metric that is commonly used by OSHA to audit high. Some people confuse this formula with the formula for lost time injuries, but the total recordable injury frequency rate includes all injuries requiring medical treatment from a medical professional - which in theory means that it will be a larger number. 01-23-2022, 01:23 PM #3. The reason for calculating an accident frequency rate is to. Lost Time Case Rate Severity Rate DART Rate a mathematical calculation that describes the number of employees per 100 full-time employees that have been involved in a recordable injury or illness. Calculating Lost Time Injury Frequency Rate. Occupational Safety and Health Statistics Bulletin Issue No. is gravity dredging legal in california; national crime agency strengths and weaknesses; chasen joseph schneider; rsm consulting senior. Severity Rate (SR) Divide the total number of lost workdays by the total number of recordable incidents. gov. Major injury rate fell from 18. by | Mar 8, 2023 | capricorn and scorpio sextrology | recent arrests in cecil county, md | Mar 8, 2023 | capricorn and scorpio sextrology | recent arrests in cecil county, mdDEPARTMENT OF LABOR AND EMPLOYMENTŠijeme pro miminka, děti, dospělé na zakázku, na přání. g. 80000 hours. The 200,000 number in many formulas is a benchmark 2 Physical approach What are the approaches to improve the safety in construction field. If employees have taken a total of 11 days away from work, spread over 4 recordable. 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. On March 20, 2023; In. 001295 x 1,000,000 = 1295. –No. total number of hours worked (including staff and contract), number of people employed (including staff and contract) and. Bureau of Labor Statistics to compare your rate with the same business group. This means that for every one million hours worked in the facility,. 7 Recommendations 31 4 Infrastructure Condition Report and Network Condition Report 33 4. TRIR serves as a retrospective gauge often utilized to quantify a company's safety record, and its computation can be achieved through the formula provided or by utilizing the TRIR calculator furnished below. WebThe formula for calculating your accident frequency rate is the number of reported accidents multiplied by 200,000, divided by the number of. The formula itself is quite simple, but its implications can be pretty significant. au. TRIFR calculation = (Recorded fatalities + LTIs + other injuries x 1,000,000) / Employee total hours worked. accident frequency rate calculation excel; accident frequency rate calculation excel. If the first keypress does not work for you, try the second. then, in the frequency formula: F = (12 x 106)/2,189,243 = 5. xls / . In this. Calculate the Initial Accident Rate (IAR) using the formula shown. 4: 6. (OSHA requires accident rates to. Any accident which is. of 9incidents or near-misses) •Incident Rate: –Measures past events. 7%) were disabling injuries, 49 (0. of accidents + No. 23 (August 2023) (PDF) Summary of Occupational Safety and Health Statistics of 1st Half of 2023 (PDF) Occupational Safety and Health Statistics. A good TRIR is less than 3. 0. number of accidents per 100 000 employees. FREQUENCY RATE = TOTAL NUMBER OF ACCIDENTS X 1 000 000 /TOTAL NUMBER OF MAN HOURS WORKED. Here’s an example of what that might look like. In some country, the first aid injury frequency coefficient (F) h determined by. 001295 x 1,000,000 = 1295. TRIR = 6 x 200,000 / 500,000. For example, let’s imagine there were six lost time injuries in the past year at your company and a total of 2,500,000 hours worked. Index of lead exposure tables - Last updated 05/23. The major downside to an excel safety scorecard template is maintaining it over time. V = Number of vehicles per day (both directions). 11-12, Edif. SR is the total number of lost workdays per year × 200000 work hrs/number of workers in a job. ) Step 2: Select your major industry group. Calculate CAGR Using RATE Function in Excel. To give you an idea of companies and use cases on the higher end of the total recordable injury frequency rate spectrum, In Australia, the companies with the highest TRIFR in 2017 were WesFarmers (28. 1. 0 billion in 2017/18—£9. Unless there is a positive action by management, what has happened in the past will continue to happen. Occupational fatality rate per 100,000 workers. 4 lost time injuries for every one million man-hours worked. LTIF Example. Road safety statistics. To show it using numbers. In many countries, the figure is typically calculated per million hours worked. The Lost Time Injury frequency rate (LTIFR) measures the number of lost-time injuries per million hours worked during a single financial year. Entering an array formula into too many cells can cause errors like #N/A. Accident frequency rate is defined as the number of deaths and injuries in occupational accidents × 1000000/aggregate number of human-hours, and accident severity as the. An accident frequency rate indicates the number of accidents that occurred in a company per a certain number of hours worked by all employees. Re: Total Recordable Injury Frequency Rate (TRIFR) Sorry forgot the formula. Register To Reply. 4, which means there were 2. Please note that the figures do not include accidents involving members of the public (including students) at RGU SPORT. 88 million non-fatal accidents that resulted in at least four calendar days of absence from work and 3 347 fatal accidents in the EU (see Table 1), a ratio of approximately 860 non. Vehicle Accident Rate =Video guide explaining How to Calculate Accident Rate?The 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. And the last Tab Is a monthly lead and. Safety Stock Method 4: Normal distribution with uncertainty about the lead time. accident frequency rate calculation excel. '/T 2tu``f@tge{i OL0O|$'Io5 p^+=3[N32*#&nZSMz7Qi It does not include on the job first aid treatment. 2. The formulae used to calculate the various measures of working days lost are given by: Estimated annual full-day equivalent working days lost. a. 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. 5 1 1. That is obviously unrealistic, especially for big companies with many employees. The 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. 1 x 100,000 divided by 80,000 = accident frequency rate of 1. accident frequency rate calculation excel. 22nd July 2014 From Philippines, San Pablo City. Calculate the Expected Accident Rate (EAR) using the formula shown. The 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. Divide the total number of lost time injuries in a certain time period by the total number of hours worked in that period, then multiply by 200,000 to get the LTIR. 9accident frequency rate calculation excel. How to calculate Accident frequency rateHow to cal. 91 per 10,000 (n = 4) would mean that in every group of 10,000, approximately 8.