Spreadsheet: 887624d1737895372-calculat-how-many-occurance-within-the-same-month-for-the-same-branch-and-sort-it-as-1st-calculat-how-many-occurance-within-the-same-month-for-the-same-branch-and
Sheet: Sheet1 (2)

Branch |  | Branch | Allowed Absence |  | Branch | From | To | Penalty |  | Month | Year | Contract Amount | Contract Increased % | Contract Total Amount |  | No. | Date | Branch | Contract | Supervision | Cameras | Security | Individuals | Attended | Attended % | Absence | Absence % | No One Attended | How Many Times No One Attended | Allowed Absence | [NAME] | Total Penalty
A |  | A | 2 |  | A | 3 | 5 | 300 |  | November | 2024 | 674000 |  |  |  |  | 2025-01-01 00:00:00 | A | 8 | 0 | 0 | 0 | 0
B |  | B | 1 |  | A | 6 |  | 500 |  | December | 2024 |  |  |  |  |  | 2025-01-02 00:00:00 | B | 11 | 2 | 1 | 1 | 5
C |  | C | 2 |  | B | 2 | 5 | 300 |  | January | 2025 |  |  |  |  |  | 2025-01-03 00:00:00 | C | 12 | 2 | 1 | 1 | 7
D |  | D | 1 |  | B | 6 |  | 500 |  | February | 2025 |  |  |  |  |  | 2025-01-04 00:00:00 | A | 12 | 0 | 0 | 0 | 0
E |  | E | 0 |  | C | 3 | 6 | 300 |  | March | 2025 |  |  |  |  |  | 2025-01-05 00:00:00 | E | 12 | 2 | 1 | 1 | 6
F |  | F | 0 |  | C | 7 |  | 500 |  | April | 2025 |  |  |  |  |  | 2025-01-06 00:00:00 | B | 12 | 0 | 0 | 0 | 0 | 0
G |  | G | 0 |  | D | 2 | 4 | 300 |  | May | 2025 |  |  |  |  |  | 2025-01-07 00:00:00 | G | 12 | 2 | 1 | 1 | 7
H |  | H | 0 |  | D | 5 |  | 500 |  | June | 2025 |  |  |  |  |  | 2025-01-08 00:00:00 | H | 8 | 0 | 0 | 2 | 4
 |  |  |  |  | E | 1 |  | 500 |  | July | 2025 |  |  |  |  |  | 2025-01-09 00:00:00 | B | 11 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  | F | 1 |  | 500 |  | August | 2025 |  |  |  |  |  | 2025-01-10 00:00:00 | B | 12 | 2 | 1 | 1 | 7
 |  |  |  |  | G | 1 |  | 500 |  | September | 2025 |  |  |  |  |  | 2025-01-11 00:00:00 | C | 12 | 0 | 0 | 0 | 0
 |  |  |  |  | H | 1 |  | 500 |  | October | 2025 |  |  |  |  |  | 2025-01-12 00:00:00 | D | 12 | 2 | 1 | 1 | 6
 |  |  |  |  |  |  |  |  |  | November | 2025 |  | 0.1 |  |  |  | 2025-01-13 00:00:00 | C | 12 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  | December | 2025 |  |  |  |  |  | 2025-02-01 00:00:00 | F | 12 | 2 | 1 | 1 | 6
 |  |  |  |  |  |  |  |  |  | January | 2025 |  |  |  |  |  | 2025-02-02 00:00:00 | G | 8 | 0 | 0 | 2 | 5
 |  |  |  |  |  |  |  |  |  | February | 2025 |  |  |  |  |  | 2025-02-03 00:00:00 | H | 11 | 2 | 1 | 1 | 5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2025-02-04 00:00:00 | A | 12 | 2 | 1 | 1 | 7
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2025-02-05 00:00:00 | B | 12 | 2 | 1 | 1 | 6
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2025-02-06 00:00:00 | F | 12 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2025-02-07 00:00:00 | D | 12 | 2 | 1 | 1 | 7
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2025-02-08 00:00:00 | E | 12 | 2 | 1 | 1 | 6
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2025-02-09 00:00:00 | F | 8 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2025-02-10 00:00:00 | G | 11 | 2 | 1 | 1 | 5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2025-02-11 00:00:00 | H | 12 | 2 | 1 | 1 | 7
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2025-02-12 00:00:00 | A | 12 | 2 | 1 | 1 | 7
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2025-03-01 00:00:00 | B | 12 | 2 | 1 | 1 | 7
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2025-03-02 00:00:00 | C | 12 | 2 | 1 | 1 | 6
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2025-03-03 00:00:00 | D | 12 | 2 | 1 | 1 | 5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2025-03-04 00:00:00 | E | 8 | 0 | 0 | 1 | 5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2025-03-05 00:00:00 | A | 11 | 0 | 0 | 0 | 0