Skip to content
GraviPointThe Centre of Productivity
  • AI AgentNew
  • Pricing
  • Community
Log inGet started free
TemplatesHR & People ManagementAttendance & LeaveAbsence & Bradford Factor Tracker

SpreadsheetAttendance & LeaveFree

Absence & Bradford Factor Tracker

Record sickness absence, calculate each employee’s Bradford Factor and see who has reached a trigger point.

Shown with sample data

Colour

Absence & Bradford Factor Tracker

Record sickness absence, calculate each employee’s Bradford Factor and see who has reached a trigger point.

Days lost
22
Employees at a trigger
1
Highest score
96
Bradford Factor by employee
  • Ravi Patel96
  • Elena Rossi20
  • Mina Cho10
  • Sam Kim1

How to use it

  1. 1Log each spell of absence with first and last day.
  2. 2List employees on the Summary sheet.
  3. 3Check trigger points monthly.
  4. 4Use the score to start a conversation, never as the only evidence.

In this workbook

  • About
  • What’s included
  • How to use
  • Questions
  • Related resources

About this template

Frequent short absences disrupt more than one long one, and the Bradford Factor measures exactly that. Log each spell of absence; the summary counts spells and days per employee over the year, calculates the score (spells² × days) and shows the action your policy calls for.

Who it’s for

  • Applying an absence policy consistently
  • Return-to-work conversations
  • Reporting absence rates

What’s included

  • Absences sheet: One row per spell of absence.
  • Summary sheet: Spells, days and Bradford Factor per employee.

How to use it

  1. 1Log each spell of absence with first and last day.
  2. 2List employees on the Summary sheet.
  3. 3Check trigger points monthly.
  4. 4Use the score to start a conversation, never as the only evidence.

Questions

What trigger points are typical?

Many policies use 51 for an informal chat, 201 for a written warning and 401 for a final warning, but set your own and apply them with judgement.

Related searchesbradford factorabsence trackersickness absenceabsence managementattendance triggers

Details

Format
Spreadsheet
Category
Attendance & Leave
Sheets
2
Setup
10 min
Level
Intermediate
Price
Free

Download a copy

Downloads need a free account.

SpreadsheetAttendance & LeaveFree

Absence & Bradford Factor Tracker

Record sickness absence, calculate each employee’s Bradford Factor and see who has reached a trigger point.

A free account keeps your copy safe so you can come back to it. Have one? Log in

Download a copy

Downloads need a free account.

Details

Format
Spreadsheet
Category
Attendance & Leave
Sheets
2
Setup
10 min
Level
Intermediate
Price
Free

Your copy is private to you.

More attendance & leave templates

View all
Leave & Vacation Tracker4 sheets

Off today

1

Pending requests

2

Annual leave used

34%

Annual leave remaining
27
24
18
14
10
Amara OkaforMei TanakaPriya ShahDaniel BrooksGrace Kim
SpreadsheetAttendance & Leave

Leave & Vacation Tracker

Leave requests counted in working days (skipping weekends and holidays), with balances, bookings, who is off and monthly totals.

10 min setupPreview
Employee Shift Schedule

Scheduled hours

218.5

Labour cost

$3,773

MonTueWedThuFriSatSun
Jess LaneOpenOpenOpenOpenOpenOffOff
Arun DasMidOpenOffClosClosOpenOff
Kim LeeOffClosClosOffOffClosOpen
Rosa DiazShorShorShorOffShorMidOff
SpreadsheetAttendance & Leave

Employee Shift Schedule

Build the weekly rota from shift codes, with hours, overtime and labour cost per person, opener and closer coverage each day, and labour as a share of sales.

10 min setupPreview
Monthly Attendance Sheet

Attendance rate

95%

Sick days

4

1256789
Amara OkaforPPPPRPP
Daniel BrooksPPPPPPP
Mei TanakaRRPPRRR
Lucas SilvaRRRRRLL
SpreadsheetAttendance & Leave

Monthly Attendance Sheet

A month-at-a-glance register with present, remote, sick, absent and leave codes, attendance rates, absence flags and daily coverage.

10 min setupPreview

Practical guides and new resources, monthly.

One short email with new templates, calculators and how-tos. Unsubscribe any time.

GraviPointThe Centre of Productivity

Find the right resource. Make it work for you. Get things done with spreadsheets, documents, forms and calculators you can use right in your browser.

support@gravipoint.com
  • @gravipoint
  • @GraviPoint
  • GraviPoint
  • 𝕏@gravipoint

Templates

  • All templates
  • Budgets & expenses
  • Invoices & billing
  • Project management
  • HR & people
  • Inventory & stock
  • Sales & CRM
  • Financial calculators

Popular

  • Monthly budget
  • Invoice
  • Employee shift schedule
  • Weekly timesheet
  • Project plan & Gantt chart
  • Inventory tracker
  • Expense report
  • Mortgage calculator

Solutions

  • Individuals & households
  • Freelancers & consultants
  • Founders & startups
  • Small business owners
  • Teams & operations
  • Students & educators

Company

  • About
  • Features
  • Pricing
  • Community
  • Journal
  • Contact
© 2026 GraviPoint. All rights reserved.
  • Privacy
  • Terms
  • Help centre
  • FAQ