Ask three safety managers how they got their TRIR number and you'll likely get three different answers: a spreadsheet formula someone built five years ago, a free web tool bookmarked after a Google search, or a number a recordkeeping platform spat out automatically. Every TRIR calculator — spreadsheet, free tool or full software — runs the same fixed formula, so the maths is never really the risk. The risk is what goes in before the maths starts. We compared the three common approaches on real criteria: does the tool show its formula, does it handle edge cases, and does it connect to an actual recordability decision or just trust the numbers you hand it.
What is the TRIR formula, and why does the calculator matter less than the inputs?
TRIR stands for Total Recordable Incident Rate. The formula itself is short:
TRIR = (Number of OSHA recordable cases × 200,000) ÷ Total hours worked by all employees
The 200,000 is fixed. It represents 100 employees working 40 hours a week for 50 weeks — a standard baseline that lets a 30-person firm and a 3,000-person plant compare rates fairly. DART, the Days Away, Restricted or Transferred rate, uses the identical structure: cases involving days away, restricted work or job transfer, times 200,000, divided by hours worked. We cover DART on its own in our DART rate explainer.
Because the formula is fixed and public, no calculator can get the arithmetic wrong without a coding bug. What varies — and what actually separates a good TRIR calculator from a bad one — is everything upstream of the division sign: whether the case count only includes genuinely recordable cases under 1904.7, and whether "hours worked" means what OSHA means by it. We wrote a full walkthrough of the TRIR calculation if you want the formula worked line by line. This piece is about the tools people use to run it.
The three ways teams actually calculate TRIR
Nearly every employer we've spoken with falls into one of three camps.
The spreadsheet formula
This is the default for smaller employers and for safety managers who've inherited a file from a predecessor. It's a cell with =(B2*200000)/C2 and a tab for supporting data. It costs nothing beyond the software licence you already have, and it's infinitely flexible — you can add columns for site, shift or job type without asking anyone's permission.
The trade-off is that a spreadsheet has no idea what a recordable case is. It sums whatever number a human typed into a cell. If that number includes a first-aid case that should never have counted, or misses a case that should have been recorded, the spreadsheet has no way to flag it. It also won't tell you if your hours-worked figure is scheduled hours rather than actual hours worked — a distinction OSHA cares about and a spreadsheet doesn't.
The free online calculator
A free TRIR calculator — a web page where you type in case count and hours worked and get a rate back — sits in the middle. It removes the risk of a broken formula (no fat-fingered cell reference, no accidentally deleted row), and a good one shows its formula openly rather than hiding the maths behind a black box. Job13's own /rates page is one example: no signup, no account, free to use, and it displays the TRIR and DART formulas next to the result so you can check the arithmetic yourself.
The honest limitation is that a free calculator like this only calculates. It doesn't know whether the case count you typed in is correct — that's still on you, or on a separate determination process. And Job13's version specifically covers federal 29 CFR Part 1904 today; it isn't built for a multi-site employer juggling state-plan variations or dozens of establishments needing rolled-up reporting. For that scale, a free calculator is a spot-check tool, not a system of record.
Full recordkeeping software
Recordkeeping platforms fold the calculator into a bigger system — case logging, the 300 Log, 300A summary, sometimes ITA export — so the TRIR number updates automatically as cases are entered. The advantage is that the calculator is connected to the actual case list, not a number someone retyped from a different file. If a case gets closed out or reclassified, the rate updates without anyone touching a formula.
The trade-off is cost and complexity. These platforms are usually a paid annual contract, often with onboarding and training overhead, and they're built for the scale of employer that needs multi-establishment rollups and audit trails — overkill for a 15-person contractor who just wants a rate for a client bid.
Comparing the three approaches
| Criteria | Spreadsheet formula | Free online calculator | Full recordkeeping software |
|---|---|---|---|
| Shows the formula | Only if you built it yourself | Usually, if a good one | Sometimes hidden behind the UI |
| Handles partial-year hires | Manual — you calculate it | No — you supply the total | Often automated from payroll data |
| Handles multiple establishments | Manual, one tab per site | No — single-site input only | Built in, with rollups |
| Requires signup | No | Depends on the tool | Yes, always |
| Connects to a recordability determination | No | No (separate step) | Sometimes, if built in |
| Cost | Free (your time) | Free | Paid, often per-seat or per-site |
| Risk of silent error | High — broken formula or wrong reference | Low, but garbage in still means garbage out | Low, but complex setup can mask mistakes |
Table: how a TRIR spreadsheet, a free online calculator and full recordkeeping software compare on the criteria that actually matter — not just whether they can do the division.
None of the three checks every box. That's the honest takeaway: pick based on the size of your operation and how much you trust the numbers going in, not on which one looks slickest.
A real example: when the hours-worked number was the problem, not the calculator
A mid-sized manufacturer we heard about built its own TRIR spreadsheet years ago. Every quarter, someone pulled the recordable case count from the 300 Log and pasted it into a cell, then pulled "hours worked" from the payroll system's scheduled-hours report — the number HR used for staffing, not the number that reflected actual time on the floor.
For most of the year the gap between scheduled and actual hours was small enough not to matter. Then a slow quarter hit: overtime dropped, a production line ran short-staffed for six weeks, and actual hours worked came in noticeably below what was scheduled. The spreadsheet's TRIR, calculated against the higher scheduled-hours figure, understated the real rate. Nobody caught it until the safety manager ran the same case count and a corrected actual-hours figure through a free online calculator as a sanity check, and the two numbers didn't match. The formula in the spreadsheet was never wrong. The input was.
That's the pattern worth remembering: TRIR calculator errors are rarely arithmetic errors. They're input errors, and a second tool — even a simple free one — is a cheap way to catch them.
Where teams get this wrong
A few mistakes show up again and again, independent of which calculator someone uses.
- Trusting a calculator's output without checking what fed it. A rate calculated from an incomplete or inflated case list is precise and wrong at the same time. The calculator did its job; the input list didn't.
- Using scheduled or paid hours instead of actual hours worked. As above, this quietly skews the denominator, and the error grows or shrinks with staffing changes rather than staying constant.
- Mixing calendar-year and fiscal-year data. If your 300 Log runs on a calendar year but your hours-worked report comes from a fiscal-year payroll extract, you're dividing one period's cases by a different period's hours.
- Forgetting partial-year hires and terminations. Hours worked should reflect actual time on payroll for everyone who worked during the period, including someone who started in September or left in March — not a full-year assumption applied to a partial-year employee.
- Treating a single-site number as a company-wide one. A calculator that only takes one set of inputs will happily give you a rate for one location while a spreadsheet elsewhere claims to represent the whole company. Multi-establishment employers need every site rolled up consistently, which is exactly where free single-entry calculators run out of road.
One EHS manager we spoke with put it this way: "The calculator was never our problem. Our problem was that three different people had three different ideas of what counted as a recordable case, and the spreadsheet just averaged their disagreement without telling us it was there." That's the real argument for connecting the calculation to an actual determination process rather than treating TRIR as a standalone maths exercise.
Is a free TRIR calculator accurate enough for reporting?
For a spot-check, a client bid, or a monthly internal update, yes — a free online calculator that shows its formula and takes correctly-determined case counts and correctly-measured hours will produce an accurate rate. What it can't do is verify that the case count itself is right, or replace a full recordkeeping system for an employer running dozens of establishments that need rolled-up, auditable numbers. More EHS teams are moving TRIR calculation out of standalone spreadsheets and into tools connected to the underlying recordability decision, precisely because a rate is only as trustworthy as the determinations behind it. That's a sensible direction of travel even without switching to full recordkeeping software: pairing a free calculator with a genuine OSHA recordable calculator for the individual cases closes most of the gap.
Does a TRIR calculator replace the need to determine recordability first?
No. A TRIR calculator — whether it's a spreadsheet, a free tool or part of paid software — takes a case count as a given input. It has no way to independently judge whether a specific injury meets the 1904.7 recording criteria: death, days away from work, restricted work or transfer, medical treatment beyond first aid, loss of consciousness, or a significant diagnosis. That judgement call happens upstream, case by case, before any number reaches the calculator.
If you're building your case list from scratch, it's worth running each borderline case through a dedicated tool rather than a group debate in a meeting room. Job13's free recordability check applies the 1904.7 criteria to the facts of a case and returns a clear recordable or non-recordable answer — or flags it as needing review when the regulation genuinely leaves room for judgement, rather than guessing. Feeding a TRIR calculator from that kind of process, rather than from memory or a hurried group call, is the single biggest accuracy improvement most teams can make.
Whichever approach you use to get a TRIR number, the calculator itself is rarely where the risk lives. If you want a quick, free way to run the formula and check your own maths, Job13's TRIR and DART calculator takes the numbers you already trust, shows its formula openly, and needs no signup — though for large multi-site employers with fiscal-year complexity and audit needs, it's a complement to full recordkeeping software, not a replacement for it. For anything approaching year-end reporting, pair it with a proper recordability check on the individual cases first. See Job13 pricing if you want the case-by-case determinations, the 300 Log and the ITA export in one connected system.
Frequently asked questions
What is the TRIR formula used by every calculator?
TRIR equals the number of OSHA recordable cases multiplied by 200,000, divided by total hours worked by all employees during the period. The 200,000 constant represents 100 employees working 40 hours a week for 50 weeks, which standardises the rate so employers of different sizes can be compared fairly.
Is there a genuinely free TRIR calculator with no signup?
Yes. Job13's /rates page calculates TRIR and DART from numbers you enter, with no account or signup required, and it shows the formula it's using rather than hiding the maths. It covers federal 29 CFR Part 1904 and is best used as a quick check alongside your existing case records, not as a replacement for a full recordkeeping system.
Why did my spreadsheet TRIR not match a free calculator's result?
Almost always because of a difference in the inputs, not the maths. Common causes include using scheduled or paid hours instead of actual hours worked, mixing calendar-year case data with fiscal-year hours, or including a case in one tool's count that was left out of the other's.
Does a DART rate calculator use a different formula from a TRIR calculator?
The structure is the same, but the numerator differs. DART counts only cases involving days away from work, restricted work or job transfer, multiplied by 200,000 and divided by total hours worked. TRIR counts all recordable cases, which is a broader set. A dart rate calculator should show which case types it's including.
Can recordkeeping software calculate TRIR automatically from logged cases?
Yes, and that's one of its real advantages over a spreadsheet: the rate updates as cases are added, closed or reclassified, without anyone re-entering totals by hand. The trade-off is cost and setup complexity, which usually only pays off once an employer has enough case volume or enough establishments to make manual tracking unreliable. For background on picking between the two approaches generally, see our comparison of spreadsheets versus recordkeeping software.
This article is for general information about OSHA recordkeeping under 29 CFR Part 1904 and is not legal advice. For authoritative guidance, see OSHA's recordkeeping resources, the full text of Part 1904, and industry benchmark data from the Bureau of Labor Statistics. Read more on the Job13 blog, or find out more about Job13 and its API and MCP integration.
