Spreadsheet: 813243d1673625469-count-how-many-non-empty-cells-between-date-x-and-y-excel-1
Sheet: KPI

Week ending | 2022-01-21 00:00:00 | 2022-01-28 00:00:00 | 2022-02-04 00:00:00 | 2022-02-11 00:00:00 | 2022-02-18 00:00:00 | 2022-02-25 00:00:00 | 2022-03-04 00:00:00 | 2022-03-11 00:00:00 | 2022-03-18 00:00:00 | 2022-03-25 00:00:00 | 2022-04-01 00:00:00 | 2022-04-08 00:00:00 | 2022-04-15 00:00:00 | 2022-04-22 00:00:00 | 2022-04-29 00:00:00 | 2022-05-06 00:00:00 | 2022-05-13 00:00:00 | 2022-05-20 00:00:00 | 2022-05-27 00:00:00 | 2022-06-03 00:00:00 | 2022-06-10 00:00:00 | 2022-06-17 00:00:00 | 2022-06-24 00:00:00 | 2022-07-01 00:00:00 | 2022-07-08 00:00:00 | 2022-07-15 00:00:00 | 2022-07-22 00:00:00 | 2022-07-29 00:00:00 | 2022-08-05 00:00:00 | 2022-08-12 00:00:00 | 2022-08-19 00:00:00 | 2022-08-26 00:00:00 | 2022-09-02 00:00:00 | 2022-09-09 00:00:00 | 2022-09-16 00:00:00 | 2022-09-23 00:00:00 | 2022-09-30 00:00:00 | 2022-10-07 00:00:00 | 2022-10-14 00:00:00 | 2022-10-21 00:00:00 | 2022-10-28 00:00:00 | 2022-11-04 00:00:00 | 2022-11-11 00:00:00 | 2022-11-18 00:00:00 | 2022-11-25 00:00:00 | 2022-12-02 00:00:00 | 2022-12-09 00:00:00 | 2022-12-16 00:00:00 | 2022-12-23 00:00:00 | 2022-12-30 00:00:00 | Total for 2022 | 2022-01-06 00:00:00 | 2022-01-13 00:00:00 | 2022-01-20 00:00:00 | 2022-01-27 00:00:00 | 2022-02-03 00:00:00 | 2022-02-10 00:00:00 | 2022-02-17 00:00:00 | 2022-02-24 00:00:00 | 2022-03-03 00:00:00 | 2022-03-10 00:00:00 | 2022-03-17 00:00:00 | 2022-03-24 00:00:00 | 2022-03-31 00:00:00 | 2022-04-07 00:00:00 | 2022-04-14 00:00:00 | 2022-04-21 00:00:00 | 2022-04-28 00:00:00 | 2022-05-05 00:00:00 | 2022-05-12 00:00:00 | 2022-05-19 00:00:00 | 2022-05-26 00:00:00 | 2022-06-02 00:00:00 | 2022-06-09 00:00:00 | 2022-06-16 00:00:00 | 2022-06-23 00:00:00 | 2022-06-30 00:00:00 | 2022-07-07 00:00:00 | 2022-07-14 00:00:00 | 2022-07-21 00:00:00 | 2022-07-28 00:00:00 | 2022-08-04 00:00:00 | 2022-08-11 00:00:00 | 2022-08-18 00:00:00 | 2022-08-25 00:00:00 | 2022-09-01 00:00:00 | 2022-09-08 00:00:00 | 2022-09-15 00:00:00 | 2022-09-22 00:00:00 | 2022-09-29 00:00:00 | 2022-10-06 00:00:00 | 2022-10-13 00:00:00 | 2022-10-20 00:00:00 | 2022-10-27 00:00:00 | 2022-11-03 00:00:00 | 2022-11-10 00:00:00 | 2022-11-17 00:00:00 | 2022-11-24 00:00:00 | 2022-12-01 00:00:00 | 2022-12-08 00:00:00 | 2022-12-15 00:00:00 | 2022-12-22 00:00:00 | 2022-12-29 00:00:00 | Total 2023
Open positions
Federalsburg | 5 | 5 |  |  | 4 | 5 | 5 | 5 | 15 | 15 | 15 | 15 | 16 | 16 | 20 | 14 | 12 | 10 | 9 | 10 | 10 | 10 | 10 | 14 | 14 | 11 | 14 | 14 | 15 | 11 | 12 | 12 | 13 | 12 | 11 | 18 | 17 | 20 | 21 | 18 | 17
[NAME] | 2 | 2 |  |  | 2 | 0 | 1 | 1 | 3 | 3 | 3 | 3 | 3 | 3 | 1 | 3 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 1 | 2 | 2 | 2 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2 | 2 | 2
Ormond Beach | 2 | 2 |  |  | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 2 | 2 | 2 | 2 | 2 | 8 | 8 | 8 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7
Trois-Rivieres | 9 | 10 | 9 | 8 | 6 | 4 | 10 | 10 | 15 | 15 | 15 | 15 | 15 | 15 | 23 | 15 | 12 | 18 | 15 | 14 | 15 | 13 | 10 | 10 | 7 | 12 | 17 | 16 | 16 | 15 | 12 | 13 | 22 | 22 | 21 | 29 | 29 | 29 | 33 | 32 | 33 | 33 | 33 | 33 | 33 | 33 | 28 | 26 | 29 | 26 |  | 30 | 30
Kirkland |  |  |  |  | 1 | 1 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 3 | 3 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2 | 2 | 1 | 1 | 0 | 0 | 0 | 0 | 0
Total
Nouvel embauche
Federalsburg | 2 | 1 | 2 |  | 2 | 0 | 0 | 0 | 2 | 1 | 1 | 1 | 1 | 4 | 1 | 3 | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 3 | 0 | 2 | 2 | 2 | 3 | 1 | 0 | 2 | 2 | 0 | 2 | 5 | 1 | 4 | 1
[NAME] |  |  |  | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Ormond Beach |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1
Trois-Rivieres | 1 | 1 | 1 | 1 | 0 | 2 | 1 | 0 | 0 | 0 | 1 | 2 | 1 | 1 | 1 | 7 | 8 | 3 | 3 | 8 | 3 | 6 | 0 | 1 | 1 | 1 | 0 | 4 | 0 | 1 | 2 | 0 | 3 | 5 | 2 | 1 | 1 | 3 | 3 | 2 | 0 | 0 | 1 | 2 | 2 | 1 | 2 | 1 | 1 | 3 |  | 0 | 0
Production But 2 nouveaux par semaine |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  | 0 | 0
Kirkland |  |  |  |  | 13 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0
Autre |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  | 0 | 0
Total |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Terminations/ Resignations
Federalsburg | 1 |  | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 2 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 1 | 1 | 1 | 1 | 0 | 0 | 2 | 0 | 1 | 0 | 2 | 3 | 2 | 2 | 1 | 0 | 2 | 0 | 0
[NAME] |  |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Ormond Beach | 1 |  | 0 | 0 | 0 | 1 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0
Trois-Rivieres |  |  |  | 1 | 0 | 0 |  | 0 | 0 | 0 | 2 | 1 | 3 | 0 | 1 | 0 | 2 | 3 | 0 | 1 | 0 | 2 | 1 | 1 | 0 | 0 | 3 | 1 | 0 | 0 | 1 | 1 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 3 | 1 | 0 | 2 | 0 | 2 | 1 | 0 | 1 | 1 |  | 0 | 1
Logix |  |  |  |  | 0 | 0 |  | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Total
Covid
Federalsburg | 1 |  | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 4 | 6 | 1 | 6 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 1 | 1
[NAME] | 0 |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Ormond Beach | 1 |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 3 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Trois-Rivieres | 0 | 1 | 1 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 9 | 8 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 1 | 5 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 1 | 0 | 1 | 0 | 1 | 1 |  | 1 | 0
Kirkland |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Total |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
Invalidite / LOA
Federalsburg | 1 | 1 |  |  | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
[NAME] |  |  |  |  | 0 |  | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Ormond Beach |  |  |  |  | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Trois-Rivieres | 1 | 0 | 0 |  | 0 |  | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 1 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 1 | 1 | 2 | 2 | 1 | 1 | 2 | 2 | 2 | 3 | 3 | 2 | 2 | 1 |  |  |  | 2 | 0 | 0
Logix |  |  |  |  | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Total
Interviews / Entrevue
Federalsburg | 3 | 7 | 4 | 2 |  | 5 | 5 | 7 | 9 | 1 | 1 | 1 | 10 | 7 | 8 | 10 | 2 | 3 | 1 | 0 | 1 | 3 | 2 | 11 | 2 | 5 | 4 | 3 | 4 | 8 | 12 | 3 | 4 | 2 | 5 | 52 | 2 | 9 | 4 | 10 | 2
[NAME] |  |  | 0 | 1 |  | 0 | 0 | 0 | 2 | 2 | 3 | 2 | 5 | 11 | 4 |  | 4 | 2 | 0 | 0 | 0 | 2 | 2 | 0 | 1 | 1 | 7 | 0 | 1 | 0 | 1 | 1 | 2 | 0 | 0 | 0 | 0 | 3 | 1 | 2 | 0
Ormond Beach |  |  | 0 | 0 |  | 11 | 0 | 0 | 0 | 0 | 1 | 0 | 2 | 1 | 1 | 1 | 0 | 0 | 0 | 5 | 2 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 3 | 10 | 4
Trois-Rivieres | 6 | 2 | 3 | 0 | 2 |  | 0 | 1 | 0 | 1 | 6 | 10 | 10 | 5 | 5 |  | 12 | 4 | 10 | 10 | 11 | 7 | 3 | ? | 4 | 5 | 7 | 10 | 10 | 7 | 7 | 12 | 13 | 16 | 5 | 14 | 14 | 15 | 7 | 8 | 8 |  |  | 6 |  |  |  |  | 2 | 3 |  | 2 | 3
Logix |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 2 | 2 | 2 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 3 | 2 | 4 | 3 | 4 | 2 | 2 | 0 | 0 | 0 | 0 | 0
Total |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
Accident-Safety case (recordable)
Federalsburg |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 0 | 1 | 0
[NAME] |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Ormond Beach |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Trois-Rivieres |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  | 0
Kirkland |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Total
Temp supplementaire
Federalsburg service |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 486
Federalsburg Production |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 465
[NAME]
Ormond Beach
Trois-Rivieres |  |  |  |  |  |  |  | 40.55 | 82.5 | 89.03 | 50.76 | 51.49 | 76.91 | 45.76 | 59.77 | 131.1 | 129.01 | 147.3 | 161.24 | 89.45 | 55.58 | 68.01 | 194.52 | 171.4 | 87.07 | 77.09
Logix
Total
Regular time
Federalsburg service
Federalsburg Production
[NAME]
Ormond Beach
Trois-Rivieres |  |  |  |  |  |  |  |  |  |  | 2316.28 | 1041.05 | 1282.55 | 867.1 | 1208.25 | 1234.1 | 1208 | 1600.15 | 1388.46 | 1744 | 1931.45 | 2106.37 | 1962.51 | 1615.43 | 1715.39 | 2880.35 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1331 |  | 2681
Kirkland
Total
[NAME] vs OT
Federalsburg
OT |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 38.55 |  | 36
Conge sans solde |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 294 |  | 184
Vacance |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 576 |  | 227
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 332.45 |  | 32
Ferie |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1480 |  | 555
Payroll
Federalsburg
[NAME]
Ormond Beach
Trois-Rivieres |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 114347.57 |  | 132246.29 |  | 127337.87 |  | 132015.41 |  | 147751.49 |  |  |  | 146855.82 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 170502.43
Kirkland
Total
# employees
Federalsburg |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 110 | 110 | 110 | 110
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3
Ormond Beach |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25
Trois-Rivieres | 61 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 65 | 72 | 78 | 79 | 82 | 83 | 87 | 94 | 95 | 92 | 94 | 95 | 96 | 99 |  | 102 |  |  |  |  |  |  | 94 |  | 104 |  |  |  |  |  |  |  | 108 |  | 110 |  | 111 | 111
Kirkland |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13
Total