Spreadsheet: 85495d1285607592-count-several-criteria-for-days-off-sickness_monitoring_jan_2011
Sheet: Sickness-Monitoring

 | SICKNESS MONITORING |  | [NAME]
Name: |  |  |  |  |  | Location / Office: |  |  |  |  | Employee Name:
Post: |  |  |  |  |  | Service / Team: |  |  |  |  | January |  |  |  |  |  |  |  | February |  |  |  |  |  |  |  | March
 |  |  |  |  |  |  |  |  |  |  | Sun |  |  |  |  |  |  |  | Sun |  |  |  |  |  |  |  | Sun
 |  |  |  |  |  | Reason for Absence
Full Day  Sick | [NAME] on [NAME] |  |  |  |  | Reason | Reason | Reason |  |  | Mon |  |  |  |  |  |  |  | Mon |  |  |  |  |  |  |  | Mon
1/2 Day Sick | with these colours to show |  |  |  |  | Stress/Anexity/Depression | Headache/Migraine | Emergency Leave
Hours Sick | Time off |  |  |  |  | Back | Heart Problems | Special Leave |  |  | [NAME] |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  | [NAME]
 | Annual Leave |  |  |  |  | Other - Muscular/Skeletal | Disability Related | Carers Leave
 | Emergency Leave |  |  |  |  | Colds/Flu | Operation Recovery |  |  |  | Wed |  |  |  |  |  |  |  | Wed |  |  |  |  |  |  |  | Wed
 | Special Leave |  |  |  |  | Stomach/Bowel | Other - Please Specify
 | Carers Leave |  |  |  |  |  |  |  |  |  | Thur |  |  |  |  |  |  |  | Thur |  |  |  |  |  |  |  | Thur
Month | Date From | Date To (Inc) | No Days Sick | If not off for a full Day enter hrs sick i.e 02:15 | Number of Occassions | Reason for Absence | Informal Contact | Comment | Initials |  | Fri |  |  |  |  |  |  |  | Fri |  |  |  |  |  |  |  | Fri
January |  |  | 3 |  |  | Back (10) |  |  |  |  | Sat |  |  |  |  |  |  |  | Sat |  |  |  |  |  |  |  | Sat
March |  |  | 2 |  |  | Colds/Flu (20)
 |  |  |  |  |  |  |  |  |  |  | April |  |  |  |  |  |  |  | May |  |  |  |  |  |  |  | June
 |  |  |  |  |  |  |  |  |  |  | Sun |  |  |  |  |  |  |  | Sun |  |  |  |  |  |  |  | Sun
 |  |  |  |  |  |  |  |  |  |  | Mon |  |  |  |  |  |  |  | Mon |  |  |  |  |  |  |  | Mon
 |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  | Wed |  |  |  |  |  |  |  | Wed |  |  |  |  |  |  |  | Wed
 |  |  |  |  |  |  |  |  |  |  | Thur |  |  |  |  |  |  |  | Thur |  |  |  |  |  |  |  | Thur
 |  |  |  |  |  |  |  |  |  |  | Fri |  |  |  |  |  |  |  | Fri |  |  |  |  |  |  |  | Fri
 |  |  |  |  |  |  |  |  |  |  | Sat |  |  |  |  |  |  |  | Sat |  |  |  |  |  |  |  | Sat
 |  |  |  |  |  |  |  |  |  |  | July |  |  |  |  |  |  |  | August |  |  |  |  |  |  |  | September
 |  |  |  |  |  |  |  |  |  |  | Sun |  |  |  |  |  |  |  | Sun |  |  |  |  |  |  |  | Sun
 |  |  |  |  |  |  |  |  |  |  | Mon |  |  |  |  |  |  |  | Mon |  |  |  |  |  |  |  | Mon
 |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  | Wed |  |  |  |  |  |  |  | Wed |  |  |  |  |  |  |  | Wed
 |  |  |  |  |  |  |  |  |  |  | Thur |  |  |  |  |  |  |  | Thur |  |  |  |  |  |  |  | Thur
 |  |  |  |  |  |  |  |  |  |  | Fri |  |  |  |  |  |  |  | Fri |  |  |  |  |  |  |  | Fri
 |  |  |  |  |  |  |  |  |  |  | Sat |  |  |  |  |  |  |  | Sat |  |  |  |  |  |  |  | Sat
 |  |  |  |  |  |  |  |  |  |  | October |  |  |  |  |  |  |  | November |  |  |  |  |  |  |  | December
 |  |  |  |  |  |  |  |  |  |  | Sun |  |  |  |  |  |  |  | Sun |  |  |  |  |  |  |  | Sun
 |  |  |  |  |  |  |  |  |  |  | Mon |  |  |  |  |  |  |  | Mon |  |  |  |  |  |  |  | Mon
 |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  | Wed |  |  |  |  |  |  |  | Wed |  |  |  |  |  |  |  | Wed
 |  |  |  |  |  |  |  |  |  |  | Thur |  |  |  |  |  |  |  | Thur |  |  |  |  |  |  |  | Thur
 |  |  |  |  |  |  |  |  |  |  | Fri |  |  |  |  |  |  |  | Fri |  |  |  |  |  |  |  | Fri
 |  |  |  |  |  |  |  |  |  |  | Sat |  |  |  |  |  |  |  | Sat |  |  |  |  |  |  |  | Sat
 |  |  |  |  |  |  |  |  |  |  | When employee is off sick, click under the cell with the correct date & select reason from the drop down box. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | (abbreveations above left)
 |  |  |  |  |  |  |  |  |  |  | Click cell with the correct date, go to Format>Cells>Patterns, select colour, Red = Full Day, Yellow = Half Day
January |  |  | Total Number of Days | Total Hours | Number of Occassions |  |  | Reason |  | January | Feb | Mar | April | May | June | July | Aug | Sep | Oct | Nov | Dec |  | Total
February
March |  |  | 5 | 1900-01-01 00:00:00 | 0 |  |  | Stress/Anxiety/Depression (5) |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
April |  |  |  |  |  |  |  | Back (10) |  | 3 |  |  |  |  |  |  |  |  |  |  |  |  | 3
May |  |  |  |  |  |  |  | Other - Muscular/Skeletal (15) |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
June |  |  |  |  |  |  |  | Colds/Flu (20) |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
July |  |  |  |  |  |  |  | Stomach/Bowel (25) |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
August |  |  |  |  |  |  |  | Headache/Migraine (30) |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
September |  |  |  |  |  |  |  | Heart Problems (35) |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
October |  |  |  |  |  |  |  | Disability Related * (45) |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
November |  |  |  |  |  |  |  | Operation Recovery (50) |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
December |  |  |  |  |  |  |  | Other - Please Specify   (40) |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | Emergency Leave
 |  |  |  |  |  |  |  | Special Leave
 |  |  |  |  |  |  |  | Carers leave
 |  |  |  |  |  |  |  | Number of Day 's per month |  | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 3
 |  |  |  |  |  |  |  | No of Hrs Sick per month if not Full Day |  | Jan | Feb | Mar | April | May | June | July | Aug | Sep | Oct | Nov | Dec |  | Total
 |  |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  | 1900-01-01 00:00:00