For this data, we need to calculate the IRR, which can be done using the below formula: =IRR (D2:D8) The result of the function is 8. magnesium and fluorine reaction; mark bartelstein net worth; toby sutton wife of frank suttonXIRR (values, dates, [guess]) The XIRR function syntax has the following arguments: Values Required. 11-12, Edif. The lower the value deduced from the above calculation, the better. Tons of volatile organic compounds (VOC) emitted by month . Handy tips for filling out Safe man hours format excel online. Custom Lost Time Injury Calculator calculator, built using CALCONIC_. 2, and 1. At the same time, you'll learn how to use the PMT function in a formula. The tricky part lies in getting accurate. 89 2. Figure B shows a matching Table object with no data or expressions. 70 0. WebNow, to calculate the LTIIR (Lost Time Injury Incidence Rate) which is. Place your cursor in cell D3. Warning: If the Start_date is greater than the End_date, the result will be #NUM!. If we look at Team B and D's ratios, had there been only 1 decimal place to display, 1. We have to calculate the Selling Prices of these products for different Markup Percentages (10%, 15%, 20%, 25%). This article is a guide to Calculate Ratio in Excel formula. An LTIFR of 7, for example, shows that 7 lost time injuries occur on. Step 1: To calculate the CAGR, we add the following formula in Cell C2, Step 2: Press Enter. Sebuah dialog window akan muncul dan memintamu untuk memilih data mana yang akan dijadikan tabel. We need to define the cost, salvage, and life arguments for the SLN function. . 76 2. However, simply use the RRI function in Excel to calculate the compound annual growth rate (CAGR) of an investment over a period of years. MS Excel has two formulas that can be used to calculate discounted cash flow, which it terms as “NPV. They are designed to be completed within 30 minutes. Please visit the website and fill out the short online. LTISR means lost time incident severity rate = (days lost because of lost time injuries) x 1,000,000 / worked hours)In 2020, the TRIR at the Caylloma Mine was 5. The result reflects that the company has 3. To insert a variance function into a new formula, start by opening the Excel workbook containing your data and selecting an empty cell. However, clarity of reporting could be improved. MTBF Formula in Excel (With Excel Template) MTBF Formula Calculator; MTBF Formula. Multiply the number of LTIs by 1 000 000 and divide the result by the number of hours worked and there you have it – the LTIFR. The Lost time injury frequency rate (LTIFR) calculator is a data tool maintained by Safe Work Australia that can help you compare one aspect of the work health and safety performance of your organisation against industry benchmarks. To calculate the 12-month rolling sum for January 2020, add the 4 tons emitted in January 2020 and subtract the 2 tons emitted a year ago in January 2019. April 2, 2023. Lost time injury frequency rates. A list of gardening-related tools. All these pricing can be done in one Excel sheet. The Lost Time Case Rate, also referred to as LTC Rate, is a standard workplace safety metric like OSHA’s Total Recordable Incident Rate. The standard number is typically 100. 0000175. Here's more about the calculation formula and some examples for you. An LTIFR does not factor in the severity of an injury and it also. The 200,000 is the benchmark established by OSHA because it represents the total number of hours 100 employees would log in 50 weeks based on a 40-hour work week. Step 1: Select an empty cell. Now we can combine the two functions to determine the student's final grade based on their scores and the weights of each score. With an LTIFR of 16. 5-0. You’ll pay your premium ’provisionally’, which means you’ll pay it at the start of the. § Some companies had limited qualitative disclosure on material health and safety risk profile and thePV, one of the financial functions, calculates the present value of a loan or an investment, based on a constant interest rate. S. The easy part of TRIFR calculations, like all safety KPIs ( see more here) is the measurement itself. This represents the first rolling average. 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. LTIFR has been a Key Performance Indicator (KPI) in Health and Safety for a long time and is a Lag Indicator2. laurenzside sims 4 fnaf cc » sundered switch physical » accident frequency rate calculation excel. You can calculate your tax liability and decide on tax-efficient investment options and the suitable tax regime for FY 2023-24. With an LTIFR of 16. Total man-hours for the firm are 3,000,000 hours. To calculate your LTIFR, simply plug those numbers into your formula: (6 x 1,000,000) / 2,500,000 to get a LTIFR = 2. This calculator will work for both old and new tax slab rate which were released in 2023. The tricky part lies in getting accurate. KPIs track performance against established key success factors. 70 5. To keep a formula from calculating when certain cells are blank, you can use the IF function with a suitable logical test. The RRI function below calculates. 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. Scribd is the world's largest social reading and publishing site. This tells Excel that you are entering a formula, not just numbers. The number of work-related injuries per 100 full-time workers during a one year period. 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. don't f with cats real footage; why did lyndsay tapases leaving wbtv; burns middle school class schedule; robert and maria ryan manchester, nh; can edomites repentDenise. Refer your client Contact us. 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. 80 1. au. Custom Lost Time Injury Calculator calculator, built using CALCONIC_. And voila! Your company’s LTIFR is 2. Companies can benchmark the occupational health and safety performance of their industry using the LTIFR calculator. After you create a formula, you can copy it. LTIFR: Lost-time injuries / hours worked x 2,000 (instead of using a factor of 2,000, you could also use 1,000 or 1,000,000 depending on the size of your company) In some European countries, other commonly used accident rates focus on reportable accidents according to local regulations. An injury is considered an LTI only when the injured worker: Is unable to perform regular job duties. On the Excel Options dialog box, click Formulas in the menu on the left. Highlight the range. Otherwise, it just calculates the total price without any discount. The resulting calculation would be: (5 recorded 'injuries' x 1,000,000) / 200,000 hours = 25 injuries per million hours worked. 00 25. Then type a formula like one of the following. 25 F2007 F2008 F2009 F2010 F2011 F2012 F2013 F2014 F2015 F2016 F2017 F2018 210 83 173 74 266 111 166 82 165 90 109 74 121 75 149 79 106 66 103 78 86 60 65 47 91 68. 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. Most companies choose to calculate LTIFR per 1 million man hours worked. It is a payroll document in which you can record payroll data for multiple employees along with a Salary slip prepared according to Indian rules of Employment. 00 0. Recalculate formulas that have changed since the last calculation, and formulas dependent on them, in all open workbooks. The assessment of the LTI has been used as an indicator for the Health and Safety performance, and the subset of the lost time injury which are the LTIFR and LTISR helps in proper assessment of. Project management KPI templates can be helpful, but it’s most important for KPIs to be S. 3. The total hours worked in this period (for all employees) was 800,000. If the first value is a cost or payment, it must be a. It can arise from a small incident, like a This commitment is embodied in our meticulous attention to safety metrics, the most paramount of which is the Lost Time Injury Frequency Rate (LTIFR). With their LTIFR calculated, this company can compare it to the rate for the construction industry as a whole. It could be as little as one day or shift. Generally, a good TRIR safety rate would be around 3. 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. See Dashboards. Step 3: Now convert the result into percentages by changing the format of the cell in Excel from number to percentage. Let us know how you use the LTIFR calculator. 4, which means there. Select the range of cells, and then type a. That is the start of last uptime to start of follow up failure. Español. Based on these inputs, you want to calculate the net present value. Learn what lost time injury frequency rate (LTIFR) is, how to calculate it, plus what you capacity do to reduce workplace injuries along your company. Loan Amortization Schedule. In this article. The total hours worked in this period (for all employees) was 800,000. The Injuries, Illnesses, and Fatalities (IIF) program produces a wide range of information about workplace injuries and illnesses. Syntax. Is assigned modified work duties while recovering. 20 de abril de 2023. Here's more about the calculation formula and some examples for you. Click to Download ( Scope 3 Calculation Guidance, 2. Delegated (user) authentication. 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. LTIFR calculation formula. Safe Work Australia is proud to announce the full release of our data website, data. 53 per million hours worked, down by 10. 0 or lower. Annual Percentage Rate (APR) is represented in cell C8. Rolling LTIFR Calculator. In the example shown, the formula in E5 is: = IF ( COUNT (C5:C7) = 3, SUM (C5:C7),"") Since cell C7 is empty, the formula displays no result. of days lost ÷Manhour (Within the period in assessment) × 1000000. Most companies and projects differentiate and measure MTI's and FAI's or first aid injuries one another, as the difference in severity warrants a different lens. An LTIFR of 7, for example, shows. 21 (rounded to two decimal places) lost time injuries occurring per one million working hours. From this info, first, enter all these things into the Excel worksheet to conduct the ROI calculation. Enter the following expression into G7 (the commission. Using cell references, where $100 is in cell B3 and $50 is in cell B4 , the excel formula required is =B4/B3. Let’s go with the example in the introduction. Document Title Barloworld LTIFR Approach Version 2014/0 4 Author Christopher Whitaker Date issued 2014/0 5/12 Reviewed & Approved by Risk and Sustainability Committee Date approved 2019/05/14 Disclosure Public (Barloworld website) Date last revised 20 20 /12 /1 6 3 Annexure A 1. 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. 10. LTIFR – by Biannual Period Period Scheme project LTIFR Non-Scheme projects LTIFR Scheme LTIs Non-Scheme LTIs Jul to Dec 2013 2. Let's create a put option payoff calculator in the same sheet in column G. The ROUND formula does exactly what it says: It rounds a value up or down. How to Calculate Lagging Indicators as per OSHA Standard1) Total Recordable Incident Rate (TRIR)2) Lost Time Injury Frequency Rate (LTIFR)3) Lost Time Injury. liquid lightning drain opener instructions. Risk assessments are a leading indicator, because conducting more risk assessments today should result in less. These steps help you figure out which numbers to include in the formula, then how to solve the equation: 1. For example, to include the column Sales from the table Table1, type (Table1 [Sales]). In this example, a construction company is using their scorecard to track the number and type of risk assessments being performed. 000. Menu. The calculator is created using Microsoft excel. In this case we entered =sum (, then selected the Qtr 1 and Qtr 2 columns. LTIFR calculation formula. Tag by Topic. Right click, click Format Cells, and select the right Time format. Key Performance Indicators (KPIs) change as objectives are met, or management focus shifts. - Implement Quality Tools using MINITAB for the root cause analysis of defects in packaging. by | Nov 20, 2021 | erin gilbert missing david combs | st michael church san diego mass schedule | Nov 20, 2021 | erin gilbert missing david combs | st michael church san diego mass scheduleExample 1. 21 (rounded to two decimal places) lost time injuries occurring per one million working hours. Building on this standard, GHG Protocol has now released a companion guide that makes it even easier for businesses to complete their scope 3 inventories. As the hours worked are the denominator when calculating LTIFR and other health and safety indicators you want them to be as large as possible. WorkCover Queensland. All intermediate values are kept as zeros. MAPS. XIRR (values, dates, [guess]) The XIRR function syntax has the following arguments: Values Required. The answer is 8%. Lost time injury frequency rates (LTIFR) Link to engage. Feedback can also be emailed to statsonline@swa. Key Success Factors (KSFs) only change if there is a fundamental shift in business objectives. 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. 4-0. First, we have IncidentReports, which contains the incidents. The website delivers national work health and safety and workers’ compensation data in an intuitive, user-friendly way. LTIFR Calculator To calculate the LTIFR for your workplace simply input the number of injuries sustained over a specific period of time and then input the total number of hours. Electrical Software and MS Excel Spreadsheets (Calculations of cables, voltage drop etc. is the number of Lost Time Injuries multiplied by 1 million divided…. Generally, a good TRIR safety rate would be around 3. We calculate the MIRR found in the previous example with the MIRR as its actual definition. Below is an example of a safety leading indicator scoreboard. Step 1 – First, calculate the variance from method 3rd. Jadi dengan kata lain adalah angka kecelakaan per 100 pekerja. Please note that in addition to incident. In this case, we’ll say every employee worked 64 eight-hour days. You only need two pieces of information to calculate your organization’s LTIFR: Number of lost time injuries in given accounting period; Number of hours worked in given accounting period; Once you have that information at hand, you can figure out your LTIFR by plugging the data into the following equation:The LWD rate is calculated by multiplying the total number of lost work days for the year by 200,000, then dividing that number by the number of employee labor hours at the company. 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. - Implement Safety indicators (LTIFR, IR) & designed an dashboard for safety KPIs. Accident costs normally are. These data are collected and reported annually through the Survey of Occupational Injuries and Illnesses (SOII) and the Census of Fatal Occupational Injuries (CFOI). One went to hospital for one week and the other was away for one full day. LTIFR calculation = (Number of lost time injuries x 1,000,000) / Total hours worked. gov. WebAccident Incidence Rate Formula. Use Excel as your calculator. OSHA has a published formula for calculating workplace injuries as follows: (# of injuries x 200,000)/400,000. S. LTISR is expressed thus: No. 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. Click here to start a free software trial and see how easy our incident management software is to use. The image below shows the formula behind the Excel MIRR. Enter a formula that contains a built-in function. 2. The companies with the lowest TRIFR rates were WorleyParsons (0. An LTIFR of 7, for example, shows that 7 lost time injuries occur on. The tricky part lies in getting accurate. Step 3: Now calculate the multiplication by 4. Select the cells containing the times. To do that, I’ll use a formula that takes the cash flow value, multiples it by the discount rate (I’ll use 5%) raised to a negative power (the year). That gives your scorecard a neat and more. Let's create the formula for straight-line depreciation in cell C8 (do this on the first tab in the Excel workbook if you are following along). Click anywhere in chart area, in Chart Tools, go to Layout tab, click on the drop-down button of Trendline button in Analysis section and then click on More Trendline Options. For information on nonfatal workplace injury and. Microsoft Graph tutorials are step-by-step training exercises that guide you through creating a basic application that accesses data via Microsoft Graph. 34 tons. Divide that by 2 451 679 and you get 2. 58 in 2013. Note: You could even set the decimal places in the ROUND function to one digit but for our scenario, it’s best to have 2 decimal places. See full list on ecompliance. 21 (rounded to two decimal places) lost zeite injuries occurring per only million working hours. The LTIFR formula is: The LTIIR product is: As with other episode rates, a good Lost Time Failure Rate is one that is as vile because likely. Type = (STDEV ( into a blank cell. Next steps. 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. Where the TRIR considers all injuries and illnesses, the LTC Rate represents solely the number of cases that resulted in lost workdays. Excel has a built-in formula but it's far from ideal. Two things to remember when totaling your annual. )Rolling LTIFR. Now, select the investment value cell B2. Free Risk Assessment Template in Excel Format; Risk Intelligence and What to Do About It – A Video; How to Calculate TRIFR, LTIFR and. Helps normalize for the actual hours worked and particularly helpful for larger. Printing and scanning is no longer the best way to manage documents. LTIFR Calculator To calculate the LTIFR for your workplace simply input the number of injuries sustained over a specific period of time and then input the total number of hours. R. Begin by choosing a spreadsheet software program such as Google Sheets, Microsoft Excel, LibreOffice Calc, or Open Office Calc. LTIFR is a proxy measurement for safety performance. Step Three: Combine the SUMPRODUCT and SUM to Calculate the Weighted Average. 1. Instead of using a calculator, use Microsoft Excel to do the math! You can enter simple formulas to add, divide, multiply, and subtract two or more numeric values. To disable the automatic calculation feature, open Excel and click the FILE tab. Where the TRIR considers all injuries and illnesses, the LTC Rate represents solely the number of cases that resulted in lost workdays. Quantity of manhours worked: 365 (# of days) * 12 ( hr/day) * 40 ( employees + contractors) = 175200 manhours. 1. The formula below calculates the number above the fraction line. High TRIR shows poor safety performance; it is important to keep your organization’s TRIR as low as. “Automatic” is the default option. Use its powerful functionality with a simple-to-use intuitive interface to fill out Man hours calculation template online, e-sign them, and quickly. To calculate autochthonous LTIFR, simply plug those numbers in your formula: (6 scratch 1,000,000) / 2,500,000. Document Title Barloworld LTIFR Approach Version 2014/0 4 Author Christopher Whitaker Date issued 2014/0 5/12 Reviewed & Approved by Risk and Sustainability Committee Date approved 2019/05/14 Disclosure Public (Barloworld website) Date last revised 20 20 /12 /1 6 3 Annexure A 1. DOWNLOAD HERE: Copy of Data statistics draftV1. Safety leading indicators scorecard. It instructs Excel to recalculate any dependent. 00 0. Motivations, Attitudes, Perceptions and Skills project Mean. Use the Excel Formula Coach to figure out a monthly loan payment. 5. Note: fill in "y" for the third argument to get the number of complete. So, if you have 8 lost time injuries and 3 million hours worked, your LTIFR is 2. The safety, wellbeing & rehab experts 1300 647 789 Main Menu. 93 3. When benchmarking lagging indicators we use the 200,000 rate as it is the closest measure to manhours for our organisation per year. The company has a workforce of 1,000 employeesTo calculate your LTIFR, simply plug those numbers into your formula: (6 x 1,000,000) / 2,500,000 LTIFR = 2. LTIFR = (14 / 800,000) x 200,000 = 3. Definition. 25 1. The Lost time injury frequency rate ( LTIFR) calculator is a data tool that helps you compare one aspect of the work health and safety performance of your organisation against industry benchmarks. 4, which means there were 2. MTTR is total maintenance time divided by number of. And voila! Your company’s LTIFR is 2. The middle value in a distribution when all values are ordered from lowest to highest. For that use the following formula in cell D7. This would be a pretty high TRIFR, as you can see some TRIFR averages here. Or use the AutoSum feature to quickly total a series of values without entering them manually in a formula. 00 5. T = Taxes. Select the cell where the weighted average should go (for us that's cell D15) and then type the following formula. Two things to remember when totaling. The Lost time injury frequency rate (LTIFR) calculator is a data tool that helps you compare one aspect of the work health and safety performance of your organisation against industry benchmarks. A lost time injury is an injury sustained on the job by worker that results in the loss of productive work time. Effectively managing the staffing schedule and putting on casuals or part timers can help reduce workload and reduce your LTIFR. We will apply the formula mentioned above to calculate investment return in Excel. The LTIFR is the average number of lost-time injuries in each industry in Australia in. LTIFR calculation formula. =DATEDIF (B2,TODAY (),"Y") And immediately, you'll see the completed age in the C2 cell. 50 Weeks Per Year Incidence Rates are calculated. The LWR formula is defined as the total number of workdays lost multiplied by 200,000, divided by the total number of hours worked by all employees within a given period. 0), AGL Energy (2. 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. Step 2: Appying Excel Formula inside a cell. You can also enter the loan term in years instead of months and adjust the formula as follows: =RATE (E2*12,E3,E4)*12. 68 77 291 Jan to Jun 2015 2. (Number of lost time cases x 1,000,000) / Total number of hours worked. 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. Send us mail mukwonago humane society. Warning: If the Start_date is greater than the End_date, the result will be #NUM!. As you see, with daily compounding interest, the future value of the same investment is a bit higher than with monthly compounding. 3) Metcash, Woolworths, Qantas Airways and Wesfarmers have consistently recorded some of the highest LTIFR rates over the past few years, while Wesfarmers has. Lost Time Injury rate follows a simple formula to indicate your performance. LTIFR = 2. It could be as little as one day or a shift off work being lost, or months of rehabilitation. The million multiplier is used because the number of lost time injuries per hours worked is tiny. Here, the details are in order in the corresponding cells in the formula. The formula in Excel will begin with the equal sign. 31 compared to 1. A lost time injury (LTI) is an injury sustained on the job by an employee that results in the loss of productive work time. If the TRIR rate is high, it indicates that the company's work sites are dangerous. 89; with a factor of 1,000, the LTIFR is. LTIFR. It could be as little as one day or a shift off work being lost, or months of rehabilitation. To 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. 75 0. 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. (Note, we multiply by 24 to convert the decimal values into hours). But let’s dim the lights, cue the orchestra, and take a moment to truly appreciate the art of it. Content. You’ll pay your premium ’provisionally’, which means you’ll pay it at the start of the. First put a start date in a cell, and an end date in another. accident frequency rate calculation excel. FR (Frequency Rate) adalah banyaknya jumlah kecelakaan hari hilangdalam satu juta jam kerja selama periode tertentu. 2019 2020If you need help calculating your company's DART rate, please call (720) 547-5102. 10. This formula is used to calculate an organization's TRIFR:How to Calculate: OSHA Recordable Incident Rate. First, we have IncidentReports, which contains the incidents. You'll see a tool tip in the top left corner of the sheet as well as when you select the cells containing the loan details at the top. However, the level of risk involved across different occupations varies greatly. 42 LTIF. You would use this formula: =RATE (E2,E3,E4)*12. The cost is listed in cell C2 (50,000); salvage is listed in cell C3 (10,000); and life, for this formula, is the life in periods of time. " In. We’re going to take you through 3 main methods for calculating your NPS, using: A spreadsheet/Excel, or. 279 0. 2) and Mineral Resources (2. To calculate your LTIFR, simply plug those numbers into your formula: (6 x 1,000,000) / 2,500,000 to get a LTIFR = 2. T: specific, measurable, attainable, relevant, and time-bound. So, putting these two data in the above formula, we would get -. Ballivián #555, entre c. 5% from 1. 00. 000219178)1825 = $2,983. Utilizing the example above, this would resulting with the following formula: 4 x 1,000,000/ 246,750. , under OSHA. Then type a formula like one of the following. Type. com The formula to calculate TCIR/TRIR is: For many safety rates,. 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. Lost Time Injury Frequency Rate reflections by the late George Robotham – More Pearls of Wisdom Here The Lost Time Injury Frequency Rate is the principal measure of safety performance in many companies in Australia. You only need two pieces of information to calculate your organization’s LTIFR: Number of lost time injuries in given accounting period; Number of hours worked in given accounting period; Once you have that information at hand, you can figure out your LTIFR by plugging the data into the following equation: The LWD rate is calculated by multiplying the total number of lost work days for the year by 200,000, then dividing that number by the number of employee labor hours at the company. Calculate OSHA severity rate, DART rate, total case incident rate, and more here. In Trendline Options, select Moving Average and enter 3 as. For example, =SUM for getting the total sales. An LTIFR of 7, for example, shows that 7 lost time injuries occur on a jobsite every 1 million hours worked. 18 2. The calculation formula itself isn't the issue, but I'm having trouble calculating the rolling value of 12 months. The LTIFR would be: 20. Type an equal sign = and then type a function. That is obviously unrealistic, especially for big companies with many employees. 2 as well. 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. A survey tool with NPS feature. 1. 3. Enter this formula: =NETWORKDAYS(A2,B2) * 8 into a blank cell where you want to put the result, and then press Enter key, and you will get a date format cell as following screenshot shown: In case there will always be minimum 12 months data then below will work: =SUM (OFFSET (B6,,MATCH (TRUE,INDEX (ISBLANK (B6:W6),),0)-2,,-12)) In case data could be less than 12 months, say only 5 months (and other cells are blank), then below formula will account for this and return SUM of only 5 months: The resulting calculation would be: (5 recorded 'injuries' x 1,000,000) / 200,000 hours = 25 injuries per million hours worked.