I hope somebody can help as this is becoming a bit of a showstopper. I have attached sample data for information.
Objective
Calculate the Bradford factor from a single source of event dates:
The Bradford factor is calculated using the Bradford Formula S2 x D = B
- S is the total number separate absences
- D is the total number of days of absence of that individual over the same set period(normally a rolling 52 week period)
- B is the Bradford Factor score
Example:
Calculation example:
- 01 instance of absence with a duration of ten days (1 x 1 x 10) = 10 points
- 03 instances of absence; one of one and two of two days (3 x 3 x 5) = 45 points
- 03 instances of absence; one of one, one of three and one of six days (3 x 3 x 10) = 90 points
- 05 instances of absence; each of two days (5 x 5 x 10) = 250 points
- 10 instances of absence; each of one day (10 x 10 x 10) = 1000 points
The Problem..
The Bradford Factor calculates instances of sickness as well as duration to produce a score. I have attached sample data and need urgent support in resolving the following:
Number of Instances
The period of sickness is not stored as ‘Start Date’ and ‘End Date’ only as a run of dates by Event Type, ‘EventDate’ which makes it tricky to calculate number of instances.
Number of days
The number of days is a little easier but should exclude i) non-working days (weekends) ii) Bank holidays iii) Annual leave
Many thanks,
Natalie
