Spreadsheet: 69638d1270164250-calculating-accrual-of-sick-days-copy-of-attendance_dummy-v2
Sheet: 2nd_Quarter

Last Name | First Name | Vacation | Statutory Holidays | Personal Days | Sick Days | Workshop | [NAME] | Meeting | Doctor's Appt. | In Late/  Left Early | no work (or bereavement)
 |  |  |  |  |  |  |  |  |  |  |  | 2010-04-01 00:00:00 | 2010-04-02 00:00:00 | 2010-04-03 00:00:00 | 2010-04-04 00:00:00 | 2010-04-05 00:00:00 | 2010-04-06 00:00:00 | 2010-04-07 00:00:00 | 2010-04-08 00:00:00 | 2010-04-09 00:00:00 | 2010-04-10 00:00:00 | 2010-04-11 00:00:00 | 2010-04-12 00:00:00 | 2010-04-13 00:00:00 | 2010-04-14 00:00:00 | 2010-04-15 00:00:00 | 2010-04-16 00:00:00 | 2010-04-17 00:00:00 | 2010-04-18 00:00:00 | 2010-04-19 00:00:00 | 2010-04-20 00:00:00 | 2010-04-21 00:00:00 | 2010-04-22 00:00:00 | 2010-04-23 00:00:00 | 2010-04-24 00:00:00 | 2010-04-25 00:00:00 | 2010-04-26 00:00:00 | 2010-04-27 00:00:00 | 2010-04-28 00:00:00 | 2010-04-29 00:00:00 | 2010-04-30 00:00:00 | 2010-05-01 00:00:00 | 2010-05-02 00:00:00 | 2010-05-03 00:00:00 | 2010-05-04 00:00:00 | 2010-05-05 00:00:00 | 2010-05-06 00:00:00 | 2010-05-07 00:00:00 | 2010-05-08 00:00:00 | 2010-05-09 00:00:00 | 2010-05-10 00:00:00 | 2010-05-11 00:00:00 | 2010-05-12 00:00:00 | 2010-05-13 00:00:00 | 2010-05-14 00:00:00 | 2010-05-15 00:00:00 | 2010-05-16 00:00:00 | 2010-05-17 00:00:00 | 2010-05-18 00:00:00 | 2010-05-19 00:00:00 | 2010-05-20 00:00:00 | 2010-05-21 00:00:00 | 2010-05-22 00:00:00 | 2010-05-23 00:00:00 | 2010-05-24 00:00:00 | 2010-05-25 00:00:00 | 2010-05-26 00:00:00 | 2010-05-27 00:00:00 | 2010-05-28 00:00:00 | 2010-05-29 00:00:00 | 2010-05-30 00:00:00 | 2010-05-31 00:00:00 | 2010-06-01 00:00:00 | 2010-06-02 00:00:00 | 2010-06-03 00:00:00 | 2010-06-04 00:00:00 | 2010-06-05 00:00:00 | 2010-06-06 00:00:00 | 2010-06-07 00:00:00 | 2010-06-08 00:00:00 | 2010-06-09 00:00:00 | 2010-06-10 00:00:00 | 2010-06-11 00:00:00 | 2010-06-12 00:00:00 | 2010-06-13 00:00:00 | 2010-06-14 00:00:00 | 2010-06-15 00:00:00 | 2010-06-16 00:00:00 | 2010-06-17 00:00:00 | 2010-06-18 00:00:00 | 2010-06-19 00:00:00 | 2010-06-20 00:00:00 | 2010-06-21 00:00:00 | 2010-06-22 00:00:00 | 2010-06-23 00:00:00 | 2010-06-24 00:00:00 | 2010-06-25 00:00:00 | 2010-06-26 00:00:00 | 2010-06-27 00:00:00 | 2010-06-28 00:00:00 | 2010-06-29 00:00:00 | 2010-06-30 00:00:00
Smith | [NAME] |  |  |  |  |  |  |  |  |  |  |  | h |  |  | i |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | h
Jones | [NAME] |  |  |  |  |  |  |  |  |  |  |  | h |  |  |  |  | d |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | v |  |  | v | v |  |  |  |  |  | h
Abbreviations |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Abbreviations |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Abbreviations |  |  |  |  |  |  |  |  |  |  |  |  |  | Abbreviations |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Abbreviations
Vacation | v |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Vacation | v |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Vacation | v |  |  |  |  |  |  |  |  |  |  |  |  | Vacation | v |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Vacation | v
Statutory Holidays | h |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Statutory Holidays | h |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Statutory Holidays | h |  |  |  |  |  |  |  |  |  |  |  |  | Statutory Holidays | h |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Statutory Holidays | h
Personal Days | p |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Personal Days | p |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Personal Days | p |  |  |  |  |  |  |  |  |  |  |  |  | Personal Days | p |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Personal Days | p
Sick Days | i |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sick Days | i |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sick Days | i |  |  |  |  |  |  |  |  |  |  |  |  | Sick Days | i |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sick Days | i
Workshop | w |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Workshop | w |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Workshop | w |  |  |  |  |  |  |  |  |  |  |  |  | Workshop | w |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Workshop | w
[NAME] | l |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | l |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | l |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | l |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | l
Meeting | b |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Meeting | b |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Meeting | b |  |  |  |  |  |  |  |  |  |  |  |  | Meeting | b |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Meeting | b
Doctor's Appt. | d |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Doctor's Appt. | d |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Doctor's Appt. | d |  |  |  |  |  |  |  |  |  |  |  |  | Doctor's Appt. | d |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Doctor's Appt. | d
In Late/Left Early | a |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Late/Left Early | a |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Late/Left Early | a |  |  |  |  |  |  |  |  |  |  |  |  | In Late/Left Early | a |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Late/Left Early | a
no work (or bereavement) | n |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | no work (or bereavement) | n |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | no work (or bereavement) | n |  |  |  |  |  |  |  |  |  |  |  |  | no work (or bereavement) | n |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | no work (or bereavement) | n