Personnel Today
  • Home
    • All PT content
    • Advertise
  • Email sign-up
  • Topics
    • HR Practice
    • Employee relations
    • Equality, diversity and inclusion
    • Learning & training
    • Pay & benefits
    • Wellbeing
    • Recruitment & retention
    • HR strategy
    • HR Tech
    • The HR profession
    • Global
    • All HR topics
  • Legal
    • Case law
    • Commentary
    • Flexible working
    • Legal timetable
    • Shared parental leave
    • Redundancy
    • Maternity & Paternity
    • TUPE
    • Disciplinary and grievances
    • Employer’s guides
  • AWARDS
    • Personnel Today Awards
    • The RAD Awards
    • OHW Awards
  • Jobs
    • Find a job
    • Jobs by email
    • Careers advice
    • Post a job
  • XpertHR
    • Learn more
    • Products
    • Pricing
    • Free trial
    • Subscribe
    • XpertHR USA
  • Webinars
  • OHW+

Personnel Today

Register
Log in
Personnel Today
  • Home
    • All PT content
    • Advertise
  • Email sign-up
  • Topics
    • HR Practice
    • Employee relations
    • Equality, diversity and inclusion
    • Learning & training
    • Pay & benefits
    • Wellbeing
    • Recruitment & retention
    • HR strategy
    • HR Tech
    • The HR profession
    • Global
    • All HR topics
  • Legal
    • Case law
    • Commentary
    • Flexible working
    • Legal timetable
    • Shared parental leave
    • Redundancy
    • Maternity & Paternity
    • TUPE
    • Disciplinary and grievances
    • Employer’s guides
  • AWARDS
    • Personnel Today Awards
    • The RAD Awards
    • OHW Awards
  • Jobs
    • Find a job
    • Jobs by email
    • Careers advice
    • Post a job
  • XpertHR
    • Learn more
    • Products
    • Pricing
    • Free trial
    • Subscribe
    • XpertHR USA
  • Webinars
  • OHW+

LettersHR practiceSickness absence

Discussions online… Bradford Factor reporting

by Personnel Today 31 Oct 2006
by Personnel Today 31 Oct 2006

Q I am required to provide Bradford Factor reports [a way of measuring sickness absence that concentrates on instances of sickness rather than number of days] on a monthly basis for about 50 individual sites in our business (totalling about 2,000 employees). Each site requires a report purely relating to its own employees on (in points order). In addition, regional managers require a report for each of their regions. At present I am using Excel to do this. It is very time-consuming and involves a lot of cutting and pasting. Does anyone know of a suitable software package or alternative method I can use?


A I used to have to produce complicated manpower reports, and all I had was Excel. Like you, I initially had to cut and paste information, and then I found a great tool on Excel, called ‘pivot tables’. These enable you to load your raw data into Excel and then produce any type and combination of report you require. Using this function you should easily be able to report on different locations and managers. You will find pivot tables under the ‘data’ menu on Excel. They look complicated at first, but just play around with them and you will soon be able to create what you want.

Avatar
Personnel Today

previous post
Home Office looks to increase visa fees for migrant workers to the UK
next post
Employment law: is compulsory mediation a good idea?

You may also like

Lack of flexibility pushes half of women to...

16 May 2022

Spain plans menstrual leave for painful periods

13 May 2022

Queen’s Speech: Exclusivity contracts for low-paid workers to...

9 May 2022

Are we happy now? New research Sugar-coats working...

6 May 2022

Alan Sugar calls PwC Friday afternoons off a...

6 May 2022

Brain fog: the menopause symptom impacting women at...

4 May 2022

Union accuses easyJet of corporate bullying over staff...

29 Apr 2022

Two thirds of employers do not collect enough...

20 Apr 2022

Bank holidays: six things employers need to know

20 Apr 2022

Businesses plead for free or cheaper Covid-19 tests

19 Apr 2022
  • What it really means to be mentally fit PROMOTED | What is mental fitness...Read more
  • How music can help to ease anxiety at work PROMOTED | A lot has happened since March 2020, hasn’t it?...Read more
  • Why now is the time to plug the unhealthy gap PROMOTED | We’ve all heard the term ‘health is wealth’...Read more

Personnel Today Jobs
 

Search Jobs

PERSONNEL TODAY

About us
Contact us
Browse all HR topics
Email newsletters
Content feeds
Cookies policy
Privacy policy
Terms and conditions

JOBS

Personnel Today Jobs
Post a job
Why advertise with us?

EVENTS & PRODUCTS

The Personnel Today Awards
The RAD Awards
Employee Benefits
Forum for Expatriate Management
OHW+
Whatmedia

ADVERTISING & PR

Advertising opportunities
Features list 2022

  • Facebook
  • Twitter
  • Instagram
  • Linkedin


© 2011 - 2022 DVV Media International Ltd

Personnel Today
  • Home
    • All PT content
    • Advertise
  • Email sign-up
  • Topics
    • HR Practice
    • Employee relations
    • Equality, diversity and inclusion
    • Learning & training
    • Pay & benefits
    • Wellbeing
    • Recruitment & retention
    • HR strategy
    • HR Tech
    • The HR profession
    • Global
    • All HR topics
  • Legal
    • Case law
    • Commentary
    • Flexible working
    • Legal timetable
    • Shared parental leave
    • Redundancy
    • Maternity & Paternity
    • TUPE
    • Disciplinary and grievances
    • Employer’s guides
  • AWARDS
    • Personnel Today Awards
    • The RAD Awards
    • OHW Awards
  • Jobs
    • Find a job
    • Jobs by email
    • Careers advice
    • Post a job
  • XpertHR
    • Learn more
    • Products
    • Pricing
    • Free trial
    • Subscribe
    • XpertHR USA
  • Webinars
  • OHW+