Spreadsheet: 190463d1351662138-90-day-rolling-formula-to-count-occurances-book1-attendance
Sheet: Sheet1

[NAME]
2012-10-01 00:00:00
NAME | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | Points | Vacation | Sick | FLHD | Tardy (T) | Late (.5) | Out (1.0)
 |  |  |  |  |  |  |  |  |  | V |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  | T |  | 1 |  |  |  | T |  |  | T |  |  | T |  |  |  |  |  | T
 | 0.5 |  |  |  |  |  | 1 |  |  |  | T |  |  |  |  |  |  |  |  |  | 0.5 | 1 |  |  |  |  |  |  | 0.5 | 0.5
 |  | 0.5 | 1 |  | 0.5 | 1 |  |  |  |  |  | T | 0.5 |  |  |  |  |  | 0.5 | 1 |  |  | 0.5 |  |  |  |  |  |  | OTC
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  | 1 |  |  |  |  |  |  |  | T | 0.5 |  |  | 0.5 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  | 1 | 0.5 |  |  |  |  | 1 | 0.5 |  |  |  | 0.5 | 1
 |  |  | T |  |  |  | 1 | T |  |  |  |  |  | T | T |  |  | T |  |  |  |  |  |  |  |  |  |  |  | T
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.5 |  | T
 | 0.5 | 0.5 |  | 1 | 0.5 |  |  |  |  |  |  |  |  |  | S | 1
 |  |  | T |  | T |  | T |  | T |  |  |  |  |  | T | T |  |  |  |  |  |  |  |  |  |  |  |  | T | 0.5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | T | T |  |  |  |  |  |  | T |  |  |  |  |  | T
 |  |  | 1 |  | T |  |  |  |  |  |  |  |  |  |  |  | T
 |  |  |  |  |  |  |  |  |  |  |  | T |  |  |  |  |  |  |  |  |  |  | T
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.5 |  | 0.5 |  | T
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.5
 |  |  | T |  |  | 1 |  | T |  |  |  |  | 0.5 |  |  |  | 0.5 |  | 0.5 |  |  | 1 |  |  |  |  |  |  | 0.5
 |  |  |  |  |  |  |  |  |  | 1 | 0.5 |  | T |  |  |  |  | 0.5 |  | 1
 |  |  |  |  |  | 1 |  |  | 1 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  | 0.5
 | 0.5 |  |  | T |  | T |  |  |  | T |  | T | 0.5 |  | T |  | T |  |  |  |  | 0.5 |  |  |  |  |  |  | 0.5
 |  |  | 0.5 | 1 |  | 1 | 0.5 |  | 0.5 | 0.5 |  |  | 0.5 |  | 1 |  | T | 0.5 |  | 1 |  |  | 1 | 1 |  |  |  |  |  | OTC
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | T |  |  |  |  |  |  |  |  |  | 1
 |  |  | 1 |  |  |  | 0.5 |  | T |  |  |  |  | T | 1 | T | T |  |  |  |  |  | T |  |  |  |  |  | T | 1
 |  |  | 0.5 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.5 | T
 |  |  |  |  |  |  |  |  |  |  |  |  | T |  |  |  | T |  |  | 0.5
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  | 0.5 |  |  |  |  | 0.5
V=Vacation, S=Sick, F=FLHD, B=Bereavement, T=Tardy <4 min, Points = absent or tardy
 | Attendance |  |  |  |  |  |  |  |  |  |  |  | If the associate is tardy (5 minutes late) or out for 2 hours or less, indicate .5 points for that day
 | 2 points-Verbal |  |  |  |  |  |  |  |  |  |  |  | If the associate is absent without any sick time (greater than 2 hours), indicate 1 point for that day
 | 4 points-Written |  |  |  |  |  |  |  |  |  |  |  | Indicate T if the associate is late or leaves for minutes before or after their scheduled shift.
 | 6 points-Final |  |  |  |  |  |  |  |  |  |  |  | Indicate v4 or v8, s4 or s8, f4 or f8 if the agent used this time
 | 8 points-Termination |  |  |  |  |  |  |  |  |  |  |  | All points are accrued on a 90 day rolling calendar