Spreadsheet: 80705d1280926749-bradford-factor-period-calculation-bridgwater-bradford-31st-july-2010-kg
Sheet: Location Absence Report

LOCATION ABSENCE REPORT
LOCATION: |  |  | Bridgwater Depot |  |  |  | PERIOD: |  | 01.07.10-30.07.10
 |  |  |  |  |  |  | MONTH: |  | 2010-07-01 00:00:00
Employee | No. of days lost in period | No. of days available in period | No. of absences in period | Returned to work - yes/no | Return to work interview completed | Action taken - e.g. verbal or written warning, absence supervision | No. of days lost in last year | No. of absences in year | Previous action | No. of working days available in year 01.01.09 - 31.12.09 | % non-attendance for current month | Bradford Factor ( No Days x No instances x No instances)
Aydin H | 0 | 22 | 0 |  |  |  | 0 | 0 |  | 260 | 0 | 0
[NAME] A | 0 | 22 | 0 | N | N |  | 0 | 0 |  | 260 | 0 | 0
[NAME] | 3 | 22 | 1 |  |  |  | 0 | 0 |  | 260 | 0.1363636363636364 | 0
[NAME] T | 0 | 22 | 0 |  |  |  | 1 | 1 | continual reduction | 260 | 0 | 1
[NAME] | 0 | 22 | 0 |  |  |  | 3 | 2 |  | 260 | 0 | 12
[NAME] | 0 | 22 | 0 |  |  |  | 0 | 0 |  | 260 | 0 | 0
Beckett J | 0 | 22 | 0 | Y | Y |  | 0 | 0 | improvement letter 1 | 260 | 0 | 0
Bennett D | 0 | 22 | 0 |  |  |  | 0 | 0 |  | 260 | 0 | 0
Bett D | 0 | 16 | 0 |  |  |  | 0 | 0 |  | 260 | 0 | 0
Biddiscombe C | 0 | 22 | 0 |  |  |  | 9 | 5 |  | 260 | 0 | 225
Binding I | 0 | 22 | 0 |  |  |  | 42 | 6 |  | 260 | 0 | 1512
Bird R | 0 | 22 | 0 |  |  |  | 0 | 0 |  | 260 | 0 | 0
Boobyer B | 0 | 22 | 0 |  |  |  | 4 | 1 |  | 260 | 0 | 4
[NAME] B | 0 | 22 | 0 |  |  |  | 4 | 3 |  | 260 | 0 | 36
Butterworth R | 0 | 22 | 0 | Y | Y |  | 10 | 1 |  | 260 | 0 | 10
Coppell N | 1 | 22 | 0 | Y | Y |  | 5 | 1 |  | 260 | 0.04545454545454546 | 5
[NAME] | 0 | 22 | 0 | Y | Y |  | 0 | 0 |  | 260 | 0 | 0
[NAME] | 22 | 22 | 1 | N |  |  | 9 | 6 | Letter2 02.06.09 (882) | 260 | 0.04545454545454546 | 324
Day S | 5 | 22 | 1 |  |  |  | 2 | 1 |  | 260 | 0.2272727272727273 | 2
Dibble M | 0 | 22 | 0 |  |  |  | 1 | 1 |  | 260 | 0 | 1
Elsworth MJ | 0 | 22 | 0 |  |  |  | 0 | 0 |  | 260 | 0 | 0
Evans T | 0 | 22 | 0 |  |  |  | 5 | 1 |  | 260 | 0 | 5
Fieldhouse D | 0 | 22 | 0 | Y | Y |  | 3 | 1 |  | 260 | 0 | 3
Futcher P | 0 | 22 | 0 |  |  |  | 1 | 1 |  | 260 | 0 | 1
Futcher T | 0 | 22 | 0 |  |  |  | 59 | 7 |  | 260 | 0 | 2891
[NAME] | 1 | 22 | 1 |  |  |  | 13 | 7 |  | 260 | 0.04545454545454546 | 637
Grant R | 0 | 22 | 0 |  |  |  | 9 | 3 |  | 260 | 0 | 81
Green K | 0 | 22 | 0 |  |  |  | 0 | 0 |  | 260 | 0 | 0
[NAME] | 0 | 22 | 0 | N | N |  | 9 | 5 |  | 260 | 0 | 225
Harman C | 1 | 22 | 1 | Y | Y |  | 0 | 0 | Letter2 02.06.09 (2700) | 260 | 0.04545454545454546 | 0
Harmer R | 0 | 22 | 0 |  |  |  | 10 | 4 |  | 260 | 0 | 160
Haste C | 0 | 22 | 0 |  |  |  | 1 | 1 | continual reduction following chat | 260 | 0 | 1
Hatton C | 0 | 22 | 0 |  |  |  | 0 | 0 |  | 260 | 0 | 0
Hill K | 0 | 22 | 0 |  |  |  | 1 | 1 |  | 260 | 0 | 1
Hood P | 0 | 22 | 0 |  |  |  | 0 | 0 |  | 260 | 0 | 0
Hooper C | 0 | 22 | 0 |  |  |  | 17 | 9 |  | 260 | 0 | 1377
Jones J | 0 | 22 | 0 |  |  |  | 7 | 7 |  | 260 | 0 | 343
Jordan N | 0 | 22 | 0 |  |  |  | 19 | 5 |  | 260 | 0 | 475
Kozai T | 0 | 22 | 0 | N | N |  | 0 | 0 |  | 260 | 0 | 0
Lock J | 0 | 22 | 0 |  |  |  | 0 | 0 |  | 260 | 0 | 0
May I | 0 | 22 | 0 |  |  |  | 0 | 0 |  | 260 | 0 | 0
O'Neill T | 1 | 22 | 1 |  |  |  | 10 | 2 |  | 260 | 0.04545454545454546 | 40
Osborne M | 0 | 22 | 0 |  |  |  | 0 | 0 |  | 260 | 0 | 0
Owens P | 0 | 22 | 0 | Y | Y |  | 1 | 1 |  | 260 | 0 | 1
[NAME] | 8 | 22 | 1 |  |  |  | 5 | 4 |  | 260 | 0.3636363636363636 | 80
Pearce Z | 1 | 22 | 1 | Y | Y |  | 17 | 3 |  | 260 | 0.04545454545454546 | 153
Penny G | 0 | 22 | 0 |  |  |  | 5 | 2 |  | 260 | 0 | 20
Phiilips D | 0 | 22 | 0 | N | N |  | 0 | 0 |  | 260 | 0 | 0
Pike C | 0 | 16 | 0 |  |  |  | 60 | 8 |  | 260 | 0 | 3840
[NAME] | 2 | 22 | 1 |  |  |  | 0 | 0 |  | 260 | 0.09090909090909091 | 0
Raggett B | 0 | 22 | 0 |  |  |  | 0 | 0 |  | 260 | 0 | 0
Roberts P | 0 | 22 | 0 | N | N |  | 0 | 0 |  | 260 | 0 | 0
Salter K | 0 | 22 | 0 |  |  |  | 0 | 0 |  | 260 | 0 | 0
Stanton S | 0 | 22 | 0 |  |  |  | 2 | 2 |  | 260 | 0 | 8
[NAME] R | 0 | 22 | 0 |  |  |  | 0 | 0 |  | 260 | 0 | 0
[NAME] | 1 | 22 | 1 | N | N |  | 9 | 2 | pending test results for cancer | 260 | 0.04545454545454546 | 36
[NAME] | 5 | 22 | 0 | N | N |  | 3 | 2 | back problems, referred to OHP | 260 | 0 | 12
[NAME] | 0 | 22 | 0 |  |  |  | 0 | 0 | continual reduction | 260 | 0 | 0
Thorne W | 0 | 22 | 0 | N | N |  | 1 | 1 |  | 260 | 0 | 1
Tredigio P | 0 | 22 | 0 |  |  |  | 0 | 0 |  | 260 | 0 | 0
Troake J | 0 | 22 | 0 |  |  |  | 130 | 3 |  | 260 | 0 | 1170
Trout J | 0 | 22 | 0 |  |  |  | 4 | 2 |  | 260 | 0 | 16
Waite D | 4 | 22 | 2 | Y | Y |  | 0 | 0 |  | 260 | 0.1818181818181818 | 0
Weber L | 0 | 22 | 0 |  |  |  | 0 | 0 |  | 260 | 0 | 0
White D | 0 | 22 | 0 |  |  |  | 4 | 1 |  | 260 | 0 | 4
Winn P | 5 | 22 | 1 |  |  |  | 0 | 0 |  | 260 | 0.2272727272727273 | 0
 |  |  |  |  |  |  | 0 | 0
TOTAL | 51 | 1242 | 10 |  |  |  | 356 | 102 |  | 14820 | 0.008051529790660225 | 12474