Spreadsheet: 135316d1325925694-display-annual-leave-dates-by-employee-2012-staff-planner
Sheet: employee Data

ID | Name | Department | Job Title | Track Leave As ... | Annual Leave - Annual Entitlement | Bank Holiday Entitlement lieu Days | Annual Leave - Carried from Last Year | Annual Leave - Total Entitlement Calculated |  | Bank Holiday worked | Bank Holiday worked | Bank Holiday worked | Bank Holiday worked | Bank Holiday worked | Bank Holiday worked | Bank Holiday worked | Bank Holiday worked | Bank Holiday worked
 |  |  |  |  |  |  |  |  |  | 2013-04-06 00:00:00 | 2013-04-09 00:00:00 | 2013-05-07 00:00:00 | 2012-06-04 00:00:00 | 2012-06-05 00:00:00 | 2012-08-27 00:00:00 | 2012-12-25 00:00:00 | 2012-12-26 00:00:00 | 2013-01-01 00:00:00
1 | sean |  |  | Days | 25 | 0 | 0 | 25 | 0
2 | [NAME] |  |  | Days | 25 | 0 | 0 | 25 | 0
3 | [NAME] |  |  | Days | 25 | 0 | 0 | 25 | 0
4 | wayne |  |  | Days | 25 | 9 | 0 | 34 | 9 | w | w | w | w | w | w | w | w | w
5 | bob |  |  | Days | 25 | 0 | 0 | 25 | 0
6 | [NAME] |  |  | Days | 25 | 9 | 0 | 34 | 9 | w | w | w | w | w | w | w | w | w
7 | Mark |  |  | Days | 25 | 9 | 0 | 34 | 9 | w | w | w | w | w | w | w | w | w
8 | [NAME] |  |  | Days | 25 | 9 | 0 | 34 | 9 | w | w | w | w | w | w | w | w | w
9 | [NAME] |  |  | Days | 25 | 9 | 0 | 34 | 9 | w | w | w | w | w | w | w | w | w
10 | [NAME] |  |  | Days | 25 | 9 | 0 | 34 | 9 | w | w | w | w | w | w | w | w | w
11 | Stuart |  |  | Days | 25 | 0 | 0 | 25 | 0
12 | [NAME] |  |  | Days | 25 | 0 | 0 | 25 | 0
13 | [NAME] |  |  | Days | 25 | 0 | 0 | 25 | 0
14 | [NAME] |  |  | Days | 25 | 9 | 0 | 34 | 9 | w | w | w | w | w | w | w | w | w
15 | Reece |  |  | Days | 25 | 9 | 0 | 34 | 9 | w | w | w | w | w | w | w | w | w
16 | Stand |  |  | Days | 25 | 9 | 0 | 34 | 9 | w | w | w | w | w | w | w | w | w
17 |  |  |  | Days | 25 | 0 | 0 | 25 | 0
18 |  |  |  | Days | 25 | 0 | 0 | 25 | 0
19 |  |  |  | Days | 25 | 0 | 0 | 25 | 0
20 |  |  |  | Days | 25 | 0 | 0 | 25 | 0
21 |  |  |  | Days | 25 | 0 | 0 | 25 | 0
22 |  |  |  | Days | 25 | 0 | 0 | 25 | 0
23 |  |  |  | Days | 25 | 0 | 0 | 25 | 0
24 |  |  |  | Days | 25 | 0 | 0 | 25 | 0
25 |  |  |  | Days | 25 | 0 | 0 | 25 | 0
26 |  |  |  | Days | 25 | 0 | 0 | 25 | 0
27 |  |  |  | Days | 25 | 0 | 0 | 25 | 0
28 |  |  |  | Days | 25 | 0 | 0 | 25 | 0
29 |  |  |  | Days | 25 | 0 | 0 | 25 | 0
30 |  |  |  | Days | 25 | 0 | 0 | 25 | 0
31 |  |  |  | Days | 25 | 0 | 0 | 25 | 0
32 |  |  |  | Days | 25 | 0 | 0 | 25 | 0
33 |  |  |  | Days | 25 | 0 | 0 | 25 | 0
34 |  |  |  | Days | 25 | 0 | 0 | 25 | 0
35 |  |  |  | Days | 25 | 0 | 0 | 25 | 0
36 |  |  |  | Days | 25 | 0 | 0 | 25 | 0
37 |  |  |  | Days | 25 | 0 | 0 | 25 | 0
38 |  |  |  | Days | 25 | 0 | 0 | 25 | 0
39 |  |  |  | Days | 25 | 0 | 0 | 25 | 0
40 |  |  |  | Days | 25 | 0 | 0 | 25 | 0
41 |  |  |  | Days | 25 | 0 | 0 | 25 | 0
42 |  |  |  | Days | 25 | 0 | 0 | 25 | 0
43 |  |  |  | Days | 25 | 0 | 0 | 25 | 0
44 |  |  |  | Days | 25 | 0 | 0 | 25 | 0
45 |  |  |  | Days | 25 | 0 | 0 | 25 | 0
46 |  |  |  | Days | 25 | 0 | 0 | 25 | 0
47 |  |  |  | Days | 25 | 0 | 0 | 25 | 0
48 |  |  |  | Days | 25 | 0 | 0 | 25 | 0
49 |  |  |  | Days | 25 | 0 | 0 | 25 | 0
50 |  |  |  | Days | 25 | 0 | 0 | 25 | 0
51 |  |  |  | Days | 25 | 0 | 0 | 25 | 0
52 |  |  |  | Days | 25 | 0 | 0 | 25 | 0
53 |  |  |  | Days | 25 | 0 | 0 | 25 | 0
54 |  |  |  | Days | 25 | 0 | 0 | 25 | 0
55 |  |  |  | Days | 25 | 0 | 0 | 25 | 0
56 |  |  |  | Days | 25 | 0 | 0 | 25 | 0
57 |  |  |  | Days | 25 | 0 | 0 | 25 | 0
58 |  |  |  | Days | 25 | 0 | 0 | 25 | 0
59 |  |  |  | Days | 25 | 0 | 0 | 25 | 0
60 |  |  |  | Days | 25 | 0 | 0 | 25 | 0
61 |  |  |  | Days | 25 | 0 | 0 | 25 | 0
62 |  |  |  | Days | 25 | 0 | 0 | 25 | 0
63 |  |  |  | Days | 25 | 0 | 0 | 25 | 0
64 |  |  |  | Days | 25 | 0 | 0 | 25 | 0
65 |  |  |  | Days | 25 | 0 | 0 | 25 | 0
66 |  |  |  | Days | 25 | 0 | 0 | 25 | 0
67 |  |  |  | Days | 25 | 0 | 0 | 25 | 0
68 |  |  |  | Days | 25 | 0 | 0 | 25 | 0
69 |  |  |  | Days | 25 | 0 | 0 | 25 | 0
70 |  |  |  | Days | 25 | 0 | 0 | 25 | 0