Bradford Factor Calculator

Bradford Factor Calculator
Fully Editable
Instant Download
Professional Design
Pre-Built
No Expertise Is Needed
Description

Bradford Factor Calculator

Measure how strongly repeated absence spells affect the Bradford score, compare the result with a chosen review benchmark, and export the current analysis to Excel.

Absence spells 3 Days absent 10 Bradford score 90 Benchmark Above 50

Absence inputs

Use one consistent measurement period for both fields.

Count separate instances of absence, not individual days.

Add all absence days in the same measurement period.

Formula: B = S² × D Frequency is squared, so repeated short absences increase the score much faster than the same days taken in fewer spells.

Live results

The score is an attendance-pattern indicator, not a diagnosis or automatic employment decision.

Bradford factor 90

3 spells across 10 days produce a Bradford score of 90.

Frequency multiplier 9×

The squared spell count, S².

Average days per spell 3.33

Total days divided by absence spells.

One-spell baseline 10

Score if the same days occurred in one spell.

Frequency uplift 80

Current score minus the one-spell baseline.

Benchmark context: This score is 40 points above the selected benchmark of 50. Treat the benchmark as a review prompt, not an automatic sanction.

Formula breakdown

Each displayed value comes from the same current-state calculation model.

S 3 Absence spells
S² 9 Frequency multiplier
D 10 Total days absent
B 90 Bradford score

Frequency sensitivity

See how the score changes when total absent days stay fixed and only the number of spells changes.

Enter at least one absence spell and a positive number of days to see the sensitivity chart.
Current pattern: Moving from one spell to three spells while keeping 10 absent days raises the score from 10 to 90.
Absence spells Total days Bradford score Benchmark comparison
Table note: Each row holds total days constant. It isolates the mathematical effect of changing absence frequency.
Advanced context

Optional internal comparison point. It does not change the Bradford score.

Use the same period consistently when comparing people or teams.

How to use the Bradford Factor responsibly

The Bradford Factor estimates the concentration of absence by combining two quantities: the number of separate absence spells and the total number of absent days in one measurement period. Its defining feature is that the spell count is squared. As a result, several short absences can produce a much higher score than one continuous absence with the same total number of days. The calculator is useful for exploring attendance patterns, but the score does not explain why an employee was absent and should not be treated as a stand-alone finding of misconduct, capability, or health status.

Important: Review thresholds are organisational policy choices. Acas notes that there are no universal legal rules for when absence must be reviewed, and trigger points should lead to a fair conversation rather than an automatic outcome.

Inputs: what to enter

Number of absence spells (S) is the count of separate absence instances during the chosen period. One continuous five-day absence is one spell, not five. Three unrelated one-day absences are three spells. This field is required for a meaningful score and must be a non-negative whole number. A higher spell count has a strong effect because it is squared: changing S from 2 to 4 increases the frequency multiplier from 4 to 16. Common mistakes include counting return-to-work days as new spells without following the organisation’s policy, mixing planned leave with sickness absence, or comparing employees over different periods.

Total days absent (D) is the sum of all days included in those spells. Use the same day-counting rule across the organisation—for example, scheduled working days rather than calendar days—unless your policy clearly says otherwise. This field is required for a meaningful score and can include partial days if your recording system supports them. Increasing D raises the score proportionally, while increasing S raises it quadratically. Do not combine unrelated leave types unless the policy explicitly defines them as part of the same measure.

Review benchmark is an optional comparison value. It does not alter the Bradford formula. The initial example uses 50 because that figure is sometimes cited as a low-score reference, but employers commonly create their own trigger points. Enter the threshold stated in your policy, or leave the field empty to remove benchmark comparisons. A score above a benchmark should initiate a contextual review, not a predetermined sanction.

Measurement period labels the analysis and Excel workbook. A 52-week or 12-month period is common, but consistency matters more than the label. Changing the period can change both S and D, so comparisons are valid only when the same window and counting rules are applied. The period selector does not perform date calculations; it records the context you selected.

Results and practical interpretation

Bradford factor is the primary result, calculated as B = S² × D. A zero score means there are no recorded absence days or no absence spells. A higher score indicates that the recorded days are spread across more separate spells. There is no universal “good” or “bad” legal score. Interpretation depends on policy, workforce conditions, disability-related absence, pregnancy-related absence, occupational health advice, and other facts that the formula does not contain.

Frequency multiplier is S². It shows why repeated absences dominate the calculation. Average days per spell is D ÷ S and describes the typical spell length; it is descriptive only and is not part of the Bradford formula. One-spell baseline is the score produced by the same total days in one spell, which equals D. Frequency uplift is the current score minus that baseline. It isolates how much of the score arises from the frequency weighting rather than from the total days alone.

The frequency sensitivity chart holds D constant and recalculates the score across several spell counts. The highlighted bar is the current spell count; the other bars show alternative frequencies. When a benchmark is entered, the dashed line shows that comparison level. The accompanying table exposes the exact values used by the chart, so it is suitable for checking calculations or documenting a discussion. The chart is not a forecast: it is a controlled mathematical comparison.

Formula, tradeoffs, and common mistakes

The model first squares the number of spells and then multiplies by absent days. For 3 spells and 10 days, S² is 9 and B is 90. With the same 10 days in one spell, B is 10; in five spells, B is 250. This sensitivity can help identify repeated short-term patterns, but it also means the score can escalate rapidly without distinguishing between avoidable absence and legitimate recurring health needs.

  • Use the score alongside return-to-work conversations, absence records, job demands, occupational health information, and the employee’s explanation.
  • Apply one written method consistently, but allow legally required and reasonable adjustments. Disability-related or pregnancy-related absence may need separate treatment.
  • Protect attendance and health records. They may contain sensitive personal information and should be collected, accessed, retained, and shared only for defined purposes.
  • Avoid ranking employees solely by Bradford score. Different roles, working patterns, part-time schedules, and recording practices can make raw comparisons misleading.
  • Check data quality before acting. Duplicate spells, incorrect day totals, inconsistent periods, and mixing leave categories can materially distort the result.

Further guidance

For absence policy design and trigger-point practice, see Acas guidance on absence trigger points and creating absence policies. For a broader people-management perspective, review the CIPD absence management factsheet. Employers handling health information should consult the ICO guidance on workers’ health information. UK employers should also consider Acas guidance on disability-related absence and reasonable adjustments. These sources provide general guidance; local law and the facts of an individual case may require specialist advice.