Spreadsheet: 869902d1716455211-substitute-and-count-text-strings-to-value-holiday-plan-sample-aligw
Sheet: Sheet1

Nr. | Name | Total 2024 | Total 2023 | Total number of holiday leave | JAN | FEB | MAR | Trim. I | APR | MAY | JUN | Trim. II | JUL | AUG | SEP | Trim. III | OCT | NOV | DEC | Trim. IV | TOTAL | Rest
1 | A | 18 | 1 | 19 |  | 14-16 (3 days) 19-19 (1 days) |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
2 | B | 21 | 1 | 22 | 12-12 (1 days) 23-26 (3 days) |  | 14-15 (2 days) | 6 | 16-16 (1 days) | 2-2 (1 days) 17-17 (1 days) 20-20 (1 days) |  | 4 |  |  |  | 0 |  |  |  | 0
3 | C | 18 | 0 | 18 |  | 23-23 (1 days) 29-29 (1 days) | 14-14 (1 days) | 3 | 1-2 (2 days) | 2-2 (1 days) 17-17 (1 days) |  | 4 |  |  |  | 0 |  |  |  | 0
4 | D | 17 | 0 | 17 |  |  |  | 0 |  | 7-10 (4 days) |  | 4 |  |  |  | 0 |  |  |  | 0
5 | E | 19 | 0 | 19 |  |  | 8-8 (1 days) 13-15 (3 days) | 4 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
6 | F | 20 | 0 | 20 | 3-5 (3 days) |  |  | 3 |  | 2-2 (1 days) |  | 1 |  |  |  | 0 |  |  |  | 0
7 | G | 21 | 5 | 26 | 23-23 (1 days) |  |  | 1 | 2-2 (1 days) | 2-2 (1 days) |  | 2 |  |  |  | 0 |  |  |  | 0
8 | H | 21 | 1 | 22 |  | 5-5 (1 days) |  | 1 |  | 22-27 (4 days) |  | 4 |  |  |  | 0 |  |  |  | 0
9 | I | 15 | 0 | 15 |  | 21-23 (3 days) | 29-29 (1 days) | 4 | 19-19 (1 days) | 2-2 (1 days) |  | 2 |  |  |  | 0 |  |  |  | 0
10 | J | 19 | 0 | 19 | 5-5 (1 days) |  |  | 1 | 1-1 (1 days) | 2-2 (1 days) 7-7 (1 days) |  | 3 |  |  |  | 0 |  |  |  | 0
11 | K | 21 | 3 | 24 | 3-5 (3 days) |  | 14-14 (1 days) | 4 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
12 | L | 16 | 0 | 16 | 3-5 (3 days) |  | 22-22 (1 days) | 4 | 22-24 (3 days) | 2-2 (1 days) |  | 4 |  |  |  | 0 |  |  |  | 0
13 | M | 20 | 0 | 20 | 19-19 (1 days) |  | 11-11 (1 days) 21-22 (2 days) | 4 |  | 2-2 (1 days) |  | 1 |  |  |  | 0 |  |  |  | 0
14 | N | 20 | 0 | 20 |  |  | 4-5 (2 days) | 2 |  | 2-2 (1 days) |  | 1 |  |  |  | 0 |  |  |  | 0
15 | O | 21 | 21 | 42 | 3-31 (20 days) |  |  | 20 | 3-5 (3 days) | 2-2 (1 days) |  | 4 |  |  |  | 0 |  |  |  | 0
16 | P | 21 | 2 | 23 | 3-5 (3 days) |  | 22-22 (1 days) | 4 |  | 2-2 (1 days) 20-27 (6 days) |  | 7 |  |  |  | 0 |  |  |  | 0
17 | Q | 21 | 4 | 25 | 3-5 (3 days) |  |  | 3 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
18 | R | 18 | 0 | 18 | 3-3 (1 days) |  |  | 1 |  | 23-24 (2 days) |  | 2 |  |  |  | 0 |  |  |  | 0
19 | S | 13 | -1 | 12 | 3-5 (3 days) 12-12 (1 days) |  |  | 4 | 9-16 (6 days) | 31-31 (1 days) | 7-7 (1 days) | 8 |  |  |  | 0 |  |  |  | 0
20 | T | 14 | 0 | 14 |  |  |  | 0 |  |  | 19-28 (7 days) | 7 |  |  |  | 0 |  |  |  | 0
21 | U | 15 | 0 | 15 | 3-5 (3 days) |  | 25-29 (5 days) | 8 |  | 13-13 (1 days) |  | 1 |  |  |  | 0 |  |  |  | 0
22 | V | 18 | 0 | 18 |  |  |  | 0 |  | 20-20 (1 days) 22-22 (1 days) |  | 2 |  |  |  | 0 |  |  |  | 0
23 | W | 16 | 0 | 16 |  |  | 18-22 (5 days) | 5 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
24 | X | 14 | 0 | 14 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
25 | Y | 14 | 0 | 14 |  |  | 1-1 (1 days) 11-11 (1 days) | 2 | 8-10 (3 days) |  |  | 3 |  |  |  | 0 |  |  |  | 0
26 | Z | 15 | 0 | 15 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
27 | A | 16 | 0 | 16 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
28 | B | 17 | 0 | 17 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
29 | C | 15 | 0 | 15 | 25-25 (1 days) | 26-26 (1 days) |  | 2 |  |  | 18-25 (5 days) | 5 |  |  |  | 0 |  |  |  | 0
30 | D | 7 | 0 | 7 | 3-5 (3 days) |  |  | 3 | 17-25 (7 days) |  |  | 7 |  |  |  | 0 |  |  |  | 0
31 | E | 21 | 0 | 21 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
32 | F | 17 | 0 | 17 | 3-5 (3 days) 8-8 (1 days) |  | 8-8 (1 days) | 5 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
33 | G | 16 | 0 | 16 |  |  |  | 0 | 1-1 (1 days) | 2-2 (1 days) |  | 2 |  |  |  | 0 |  |  |  | 0
34 | H | 17 | 0 | 17 |  |  | 5-5 (1 days) 20-20 (1 days) | 2 | 16-16 (1 days) 29-30 (2 days) | 2-2 (1 days) |  | 4 |  |  |  | 0 |  |  |  | 0
35 | I | 21 | 21 | 42 | 3-5 (3 days) | 26-29 (4 days) | 1-1 (1 days) | 8 |  | 2-2 (1 days) 10-10 (1 days) 24-24 (1 days) 31-31 (1 days) |  | 4 |  |  |  | 0 |  |  |  | 0
36 | J | 17 | 0 | 17 |  | 12-12 (1 days) 21-22 (2 days) | 4-4 (1 days) 19-19 (1 days) | 5 | 8-8 (1 days) 25-26 (2 days) | 16-16 (1 days) 23-23 (1 days) |  | 5 |  |  |  | 0 |  |  |  | 0
37 | K | 21 | 13 | 34 |  | 12-13 (2 days) | 7-7 (1 days) | 3 | 19-19 (1 days) | 16-17 (2 days) |  | 3 |  |  |  | 0 |  |  |  | 0
38 | L | 0 | 1 | 1 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
39 | M | 21 | 1 | 22 | 3-5 (3 days) |  | 8-8 (1 days) | 4 | 29-30 (2 days) | 2-2 (1 days) |  | 3 |  |  |  | 0 |  |  |  | 0
40 | N | 12 | 0 | 12 | 3-5 (3 days) |  | 29-29 (1 days) | 4 | 11-12 (2 days) | 2-2 (1 days) | 3-3 (1 days) 11-14 (4 days) | 8 |  |  |  | 0 |  |  |  | 0
41 | O | 21 | 2 | 23 | 3-5 (3 days) |  |  | 3 | 15-19 (5 days) | 2-2 (1 days) |  | 6 |  |  |  | 0 |  |  |  | 0
42 | P | 0 | 0 | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
43 | Q | 20 | 0 | 20 | 3-5 (3 days) |  |  | 3 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
44 | R | 21 | 8 | 29 | 3-5 (3 days) |  | 25-25 (1 days) | 4 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
45 | S | 16 | 0 | 16 |  |  |  | 0 |  | 2-2 (1 days) |  | 1 |  |  |  | 0 |  |  |  | 0
46 | T | 21 | 4 | 25 |  |  | 6-8 (3 days) | 3 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
47 | U | 21 | 0 | 21 | 3-5 (3 days) |  |  | 3 |  | 2-2 (1 days) |  | 1 |  |  |  | 0 |  |  |  | 0
48 | V | 20 | 0 | 20 | 3-3 (1 days) 19-19 (1 days) | 2-2 (1 days) 6-9 (4 days) 15-16 (2 days) | 6-6 (1 days) | 10 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
49 | W | 21 | 3 | 24 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
50 | X | 21 | 2 | 23 | 3-5 (3 days) |  |  | 3 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
51 | Y | 0 | 0 | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
52 | Z | 13 | 0 | 13 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
53 | A | 21 | 4 | 25 |  |  |  | 0 |  | 2-2 (1 days) |  | 1 |  |  |  | 0 |  |  |  | 0
54 | B | 21 | 0 | 21 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
55 | C | 21 | 5 | 26 |  |  |  | 0 | 10-15 (4 days) | 29-31 (3 days) | 3-3 (1 days) | 8 |  |  |  | 0 |  |  |  | 0
56 | D | 14 | 0 | 14 | 22-22 (1 days) | 19-19 (1 days) | 28-29 (2 days) | 4 | 1-4 (4 days) |  |  | 4 |  |  |  | 0 |  |  |  | 0
57 | E | 21 | 0 | 21 | 12-12 (1 days) 15-16 (2 days) |  |  | 3 |  | 8-8 (1 days) |  | 1 |  |  |  | 0 |  |  |  | 0
58 | F | 21 | 16 | 37 | 3-5 (3 days) |  |  | 3 |  | 2-2 (1 days) |  | 1 |  |  |  | 0 |  |  |  | 0
59 | G | 14 | 2 | 16 | 25-26 (2 days) |  |  | 2 |  | 2-2 (1 days) |  | 1 |  |  |  | 0 |  |  |  | 0
60 | H | 21 | 4 | 25 | 25-26 (2 days) |  | 8-8 (1 days) 11-11 (1 days) | 4 | 19-19 (1 days) | 2-2 (1 days) 31-31 (1 days) |  | 3 |  |  |  | 0 |  |  |  | 0
61 | I | 21 | 2 | 23 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
62 | J | 20 | 0 | 20 |  | 16-16 (1 days) |  | 1 | 25-25 (1 days) | 2-2 (1 days) |  | 2 |  |  |  | 0 |  |  |  | 0
63 | K | 21 | 4 | 25 | 12-12 (1 days) | 19-20 (2 days) |  | 3 | 12-12 (1 days) |  |  | 1 |  |  |  | 0 |  |  |  | 0
64 | L | 21 | 4 | 25 |  | 26-26 (1 days) |  | 1 | 26-26 (1 days) 30-30 (1 days) |  |  | 2 |  |  |  | 0 |  |  |  | 0
65 | M | 19 | -1 | 18 | 3-5 (3 days) |  |  | 3 |  |  | 3-4 (2 days) | 2 |  |  |  | 0 |  |  |  | 0
66 | N | 13 | 0 | 13 |  | 12-12 (1 days) |  | 1 |  | 23-31 (7 days) |  | 7 |  |  |  | 0 |  |  |  | 0
67 | O | 21 | 21 | 42 | 3-5 (3 days) | 16-23 (6 days) |  | 9 |  | 7-7 (1 days) |  | 1 |  |  |  | 0 |  |  |  | 0
68 | P | 21 | 20 | 41 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
69 | Q | 11 | 0 | 11 | 3-3 (1 days) |  | 13-13 (1 days) | 2 |  |  | 25-28 (4 days) | 4 |  |  |  | 0 |  |  |  | 0
70 | R | 20 | 0 | 20 | 3-5 (3 days) 30-30 (1 days) | 29-29 (1 days) | 1-1 (1 days) 11-11 (1 days) | 7 |  | 20-20 (1 days) |  | 1 |  |  |  | 0 |  |  |  | 0
71 | S | 21 | 1 | 22 | 3-4 (2 days) |  | 1-1 (1 days) | 3 | 8-12 (5 days) |  |  | 5 |  |  |  | 0 |  |  |  | 0
72 | T | 21 | 5 | 26 | 25-26 (2 days) |  | 1-1 (1 days) | 3 |  | 2-2 (1 days) 23-24 (2 days) |  | 3 |  |  |  | 0 |  |  |  | 0
73 | U | 7 | 0 | 7 |  |  |  | 0 | 23-30 (6 days) | 2-2 (1 days) |  | 7 |  |  |  | 0 |  |  |  | 0
74 | V | 17 | 0 | 17 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
75 | W | 17 | 0 | 17 |  |  |  | 0 | 25-26 (2 days) 29-30 (2 days) | 2-2 (1 days) |  | 5 |  |  |  | 0 |  |  |  | 0
76 | X | 14 | 0 | 14 |  |  | 11-15 (5 days) 18-19 (2 days) | 7 | 29-30 (2 days) |  |  | 2 |  |  |  | 0 |  |  |  | 0
77 | Y | 20 | 0 | 20 | 3-3 (1 days) |  |  | 1 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
78 | Z | 21 | 4 | 25 |  |  |  | 0 |  | 2-2 (1 days) |  | 1 |  |  |  | 0 |  |  |  | 0
 | Monthly TOTAL |  |  |  | 112 | 40 | 58 |  | 75 | 75 | 25 |  | 5 | 0 | 0 |  | 0 | 0 | 0
Generat cu iFlow.ro