ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
Instructions for the absence.io Excel Vacation Tracker
3
4
5
       Thank you for downloading the vacation tracker!
6
7
1. On the bottom of this file you find the monthly tabs with a daily overview for each employee
8
9
2.      Enter “V” for vacation, “S” for sick days and “HO” for home office days in the given cells for a certain date and employee (and see the aggregated categorized overview on the right)
10
11
VSHO
12
13
3.       When you have entered the absences the template will automatically:
14
15
· Add up the monthly absence days per employee on the right side of each tab/month
16
· Show the remaining vacation days left per employee
17
· Give you a clear statistical overview of absences per employee (last tab)
18
· Show you a complete overview of your company's absence days per category (V,S,HO)
19
20
       Simple, helpful, clear and always on track – lets get started!
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100