NETWORKING

Personneltoday.com’s new networking forum HR Space is now live. Your existing registration details will allow you access to HR Space. All you need to do is Sign in, create a nickname and choose a role.

The threads and posts to the existing forum below will become read only. Please visit HR Space to add new posts, upload and attach documents, create your own blog and upload photos. If you have any questions regarding HR Space, please email hrspace@rbi.co.uk

Go back to Networking Home Page

Go back to General HR issues

Start a new thread Search Forums

How do you record Bradford Factor?

Summary of postings

How do you record Bradford Factor?	Charlotte	19 Aug 07
Re: How do you record Bradford Factor?	Rachel	22 Aug 07
Re: How do you record Bradford Factor?	MissJ	22 Aug 07
Re: How do you record Bradford Factor?	Rachel	23 Aug 07
Re: How do you record Bradford Factor?	MissJ	23 Aug 07
Re: How do you record Bradford Factor?	Rees Howell	23 Aug 07
Re: How do you record Bradford Factor?	Char	23 Aug 07
Re: How do you record Bradford Factor?	Rees Howell	23 Aug 07
Re: How do you record Bradford Factor?	Rachel Hall	4 Feb 08
Re: How do you record Bradford Factor?	Steve	12 Mar 08

Details of postings

How do you record Bradford Factor?	Charlotte	19/08/2007 18:39
Hi I've just started work on absence management at a new organisation and they currently use the Bradford Factor. I've never used this method before and they have no HR system. What's the best method of keeping track? I'm thinking of using excel? Does anyone have any templates? Thanks Charlotte

+ Re: How do you record Bradford Factor?	Rachel	22/08/2007 15:35
I used to work for an organisation that used the Bradford Factor system and had set up an in-house Access database. The functionality of Access worked well for monitoring the system but with almost 1000 employees utilising the Bradford Factor system was very time-consuming and required at least 10-15 hours dedicated time per week to administer.
++ Re: How do you record Bradford Factor?	MissJ	22/08/2007 17:06
I've never heard of the Bradford Factor before...what is it, exactly?
+++ Re: How do you record Bradford Factor?	Rachel	23/08/2007 08:57
It is a system used to calculate a "score" for each employee based on the number of days absence they have had and the number of occasions they have been off (e.g. sick leave of one week may be 5 days but only one occasion). It takes into account the effect regular short term absences can have on an organisation rather then just the total number of days sickness an employee has had. There are then trigger points for action (decided by the organisation) so that when a certain level of points is reached by an employee it may result in them receiving a letter, having a meeting with their manager, withdrawal from the sick pay scheme, disciplinary action etc regarding their level of absence. Their score is calculated using the formula (Number of occasions x Number of occasions x Number of days off = BF Score). The data used is taken from the proceeding 12 months.
++++ Re: How do you record Bradford Factor?	MissJ	23/08/2007 17:52
Oh wow, that's really interesting...I like it a lot, a good mathematical way of keeping track of things. Thanks so much for the info!
+++ Re: How do you record Bradford Factor?	Rees Howell	23/08/2007 11:09
My office uses an online program (TeamSeer) that works out everyone’s Bradford Factor automatically. It can be a nightmare in Excel (even when using pivot tables), not just because it’s labour intensive, but it also has to be 100% accurate - and identifying each individual episode is a pain. The Bradford Factor software has quite a bit of info on calculating the Bradford Factor. http://www.teamseer.com/bradford_factor.php
++++ Re: How do you record Bradford Factor?	Char	23/08/2007 13:03
Yes I was looking at the teamseer programme? However we are a small organisation and I wondered the initial cost? If you could give me an idea I would be very grateful.
+++++ Re: How do you record Bradford Factor?	Rees Howell	23/08/2007 15:55
It’s priced per user, so as a small company it’s much cheaper, there’s a pricing enquiry form online: http://www.teamseer.com/pricing.php
++++++ Re: How do you record Bradford Factor?	Rachel Hall	04/02/2008 09:27	rachelhhall@ yahoo co uk
Hi there, New to these boards, but wondered if anyone was willing to point me in the right direction as to how to build a Bradford factor absence monitor in Excel. I have used pivot tables before, but am not clear on the specifics of how the above pivot table solutions would work. Many thanks Rachel rachelhhall@aol.com
+++++++ Re: How do you record Bradford Factor?	Steve	12/03/2008 08:50	steven hadley@ virgin net
We used to do it in Excel, until one of our employees pointed out we were miscalculating the episodes. You have to check for any periods between sick days that the employee might not normally be at work - weekends & bank holidays we had done automatically in Excel (providing you remember to update the bank holidays each year). What we had was one employee that only worked 4 days a week and he was sick either side of his day off - we had calculated that as 2 episodes rather than 1. As the Bradford Factor uses the square of the episodes this starts to make a big difference in the score. We've got just under 100 employees and it was taking so long to do all the manual checking in Excel we moved to a proper system and now run reports either for the last 12 months, but have also started doing it for the last 3 months. We look at the worse offenders and then print out their individual calendar for the manager to review with them. No-one has questioned the scores since we changed. We also now use % of working time off sick by department and individual when reviewing our absences.