Spreadsheet: 867820d1714615872-search-formulas-zt_pt_9532_n
Sheet: ZT_PT_9532_N

2023 | Heures travaillees | Heures a plein temps | Heures a temps partiel | Heures temporaires | Heures supplementaires | Heures de conges payes | [NAME] (PT&TP) | Accident du travail | Conge rais pers - Planifie | Conge rais pers - Urgent | PAICD - approuve | Conge special | [NAME] (PT&TP) | Maladie-Depart h‰tif | Conge special | Autres absences (Temp) | Vacances | Conge stat. | Conge non-paye
0
1 | 813.1 | 692.82 | 120.28 |  |  | 1133.75 | 301.75 | 32 | 173 | 0.75 | 96 |  |  |  |  |  | 436 | 396
2 | 1329.18 | 1180.47 | 148.71 |  |  | 548.54 | 383.79 | 16 | 238.25 | 9.54 | 120 |  |  |  |  |  | 164.75 |  | 3.45
3 | 1402.75 | 1238.3 | 149.25 | 13.6 | 1.6 | 542.76 | 279.01 | 15.83 | 136 | 7.18 | 120 |  |  |  |  |  | 263.75 |  | 3.75
4 | 1326.1 | 1154.9 | 168.23 | 1.77 | 1.2 | 478.38 | 310.38 | 19.75 | 164.75 | 5.88 | 120 |  |  |  |  |  | 168 |  | 50.12
5 | 1426.85 | 1232.63 | 186.5 | 7.72 |  | 524.74 | 244.74 | 19.68 | 100.75 | 4.31 | 120 |  |  |  |  |  | 280 |  | 42
6 | 1348.97 | 1191.27 | 153 | 4.7 |  | 557.41 | 277.41 | 20 | 141.5 | 11.91 | 88 | 16 |  |  |  |  | 280 |  | 52.6
7 | 1374.59 | 1232.27 | 140.54 |  | 1.78 | 476.94 | 180.94 | 19.67 | 94.25 | 3.02 | 64 |  |  |  |  |  | 296 |  | 22.25
8 | 1327.56 | 1164.38 | 150.1 | 5.08 | 8 | 460.82 | 207 | 21.84 | 76.75 | 36.41 | 72 |  | 5.82 |  | 5.82 |  | 248 |  | 63.03
9 | 1374.63 | 1231.72 | 132.41 |  | 10.5 | 413.75 | 116.25 | 9.6 | 57.5 | 1.15 | 48 |  |  |  |  |  | 297.5 |  | 80.57
10 | 1284.86 | 1163.47 | 89 | 28.39 | 4 | 535.67 | 271.92 | 9.92 | 120 |  | 40 | 102 |  |  |  |  | 263.75 |  | 83.45
11 | 1268.19 | 1060.1 | 151.07 | 22.52 | 34.5 | 634.11 | 378.11 | 10 | 124.75 | 27.36 | 72 | 144 |  |  |  |  | 256 |  | 8
12 | 1389.39 | 1208.69 | 127.25 |  | 53.45 | 457.35 | 195.85 | 7.5 | 104.75 | 3.6 | 80 |  | 8 |  | 8 |  | 253.5 |  | 20.33
13 | 1415.34 | 1279.02 | 92.25 | 20.95 | 23.12 | 410.57 | 199.07 |  | 72 | 4.07 | 104 | 19 |  |  |  |  | 211.5 |  | 80
14 | 1125.96 | 928.1 | 118.44 | 48.92 | 30.5 | 751.6 | 138.2 |  | 68.75 | 5.45 | 64 |  |  |  |  |  | 227 | 386.4 | 40
15 | 1074.97 | 743 | 150.23 | 43.07 | 138.67 | 882 | 115.5 |  | 48 | 3.5 | 64 |  |  |  |  |  | 388.75 | 377.75 | 41.5
16 | 1554.54 | 1324.92 | 161.08 | 48.12 | 20.42 | 281.17 | 241.17 |  | 114 | 15.17 | 80 | 32 |  |  |  | 8 | 32 |  | 29.05
17 | 1594.59 | 1401.27 | 137.73 | 52.09 | 3.5 | 276.08 | 132.08 | 3.52 | 36.75 | 7.64 | 84.17 |  |  |  |  |  | 144 |  | 16
18 | 1570.06 | 1341.62 | 175.98 | 48.46 | 4 | 200.99 | 112.99 |  | 32.75 | 8.24 | 64 | 8 |  |  |  |  | 88 |  | 140
19 | 1659.94 | 1438.54 | 147.27 | 72.13 | 2 | 252.85 | 156.85 |  | 56.25 | 12.6 | 48 | 40 |  |  |  |  | 96 |  | 20.08
20 | 1625.73 | 1398.09 | 164.38 | 62.76 | 0.5 | 258.69 | 226.69 |  | 133.5 | 20.44 | 72.75 |  |  |  |  | 8 | 24 |  | 67.84
21 | 1151.16 | 974.96 | 137.34 | 38.86 |  | 810.78 | 123.83 |  | 52.75 | 7.08 | 64 |  |  |  |  | 8 | 276 | 402.95 | 33.9
22 | 1551.04 | 1335.02 | 155.35 | 48.67 | 12 | 335.07 | 163.07 |  | 70.25 | 12.82 | 80 |  |  |  |  |  | 172 |  | 40.23
23 | 1507.09 | 1291.66 | 166.53 | 46.9 | 2 | 198.93 | 114.93 |  | 72 | 2.93 | 40 |  |  |  |  |  | 84 |  | 160.27
24 | 1511.05 | 1342.82 | 120.47 | 47.39 | 0.37 | 341.49 | 169.99 |  | 100.75 | 21.24 | 48 |  |  |  |  | 8 | 163.5 |  | 61.12
25 | 1200.75 | 1096.32 | 102 | 2.43 |  | 1002.01 | 294.7 |  | 167.5 | 21.2 | 42 | 64 |  |  |  |  | 306 | 401.31 | 100.5
26 | 884.32 | 712 | 109.23 | 43.09 | 20 | 1077.55 | 180.75 |  | 148.75 |  | 32 |  |  |  |  |  | 487.75 | 409.05 | 81.97
27 | 922.93 | 817.8 | 89.75 | 7.3 | 8.08 | 657.81 | 151.81 |  | 100.75 | 11.06 | 40 |  | 36 |  | 36 |  | 462 | 8 | 24
28 | 1368.92 | 1253.61 | 86.75 | 8.28 | 20.28 | 561.27 | 154.02 |  | 122.75 | 11.1 | 20.17 |  |  |  |  |  | 407.25
29 | 1434.1 | 1248.87 | 130.17 | 31.64 | 23.42 | 553.38 | 186.13 |  | 146 | 36.85 | 3.28 |  |  |  |  |  | 367.25 |  | 8
30 | 1384.51 | 1217.51 | 139.75 | 7.25 | 20 | 570.73 | 166.48 |  | 129.5 | 25.83 | 11.15 |  | 32 |  | 32 |  | 372.25
31 | 1329.92 | 1162 | 166.35 | 0.29 | 1.28 | 578.1 | 114.6 |  | 88 | 18.85 | 7.75 |  |  |  |  |  | 463.5
32 | 1358.99 | 1133.68 | 220.37 | 4.94 |  | 563.47 | 203.47 |  | 168 | 25.47 | 10 |  |  |  |  |  | 360 |  | 27.93
33 | 1476.16 | 1254.01 | 200.98 | 21.17 |  | 375.41 | 135.41 |  | 60.75 | 44.96 | 29.7 |  |  |  |  |  | 240 |  | 16
34 | 1483.52 | 1288.97 | 176 | 18.55 |  | 352.21 | 128.46 |  | 84.75 | 43.71 |  |  |  |  |  |  | 223.75 |  | 37.47
35 | 1452.77 | 1275.98 | 154 | 14.79 | 8 | 356.57 | 92.42 |  | 73.5 | 18.92 |  |  | 0.15 | 0.15 |  |  | 264 |  | 16
36 | 993.26 | 869.29 | 123.5 |  | 0.47 | 779.45 | 103.3 |  | 56 | 26.3 | 21 |  |  |  |  |  | 315 | 361.15 | 16.08
37 | 1342.2 | 1131.17 | 152.23 | 54.8 | 4 | 526.57 | 182.82 |  | 98 | 44.82 | 40 |  |  |  |  |  | 343.75 |  | 12.28
38 | 1280.07 | 1073.75 | 136.75 | 53.24 | 16.33 | 539.14 | 131.39 |  | 85.5 | 4.89 | 41 |  |  |  |  |  | 407.75 |  | 43
39 | 1342.84 | 1167.68 | 148.25 | 13.18 | 13.73 | 736.79 | 147.79 |  | 76.75 | 31.04 | 40 |  |  |  |  |  | 240 | 349
40 | 1004.03 | 830.69 | 140.39 |  | 32.95 | 386.64 | 114.64 |  | 24 | 50.64 | 40 |  |  |  |  |  | 264 | 8 | 12
41 | 1036.65 | 874.6 | 122.25 | 25.55 | 14.25 | 686.82 | 86.94 |  | 24 | 30.94 | 32 |  |  |  |  |  | 243 | 356.88 | 11.17
42 | 1408.08 | 1164.16 | 176.12 | 67.8 |  | 263.9 | 159.9 |  | 90 | 29.9 | 40 |  |  |  |  |  | 104 |  | 20
43 | 1472.55 | 1271.14 | 172.68 | 24.73 | 4 | 266.94 | 135.86 |  | 41.5 | 41.86 | 52.5 |  | 3.08 |  | 3.08 |  | 128 |  | 0.37
44 | 1470.47 | 1235.79 | 194.25 | 23.65 | 16.78 | 305.39 | 141.39 |  | 43 | 58.39 | 40 |  |  |  |  |  | 164 |  | 87
45 | 1545.62 | 1274.02 | 209.75 | 42.92 | 18.93 | 597.27 | 140.67 |  | 36.75 | 23.92 | 80 |  |  |  |  |  | 92.75 | 363.85 | 45.98
46 | 1170.96 | 891.66 | 131.79 | 30.93 | 116.58 | 389.75 | 119.75 |  | 16 | 39.75 | 64 |  |  |  |  |  | 262 | 8 | 4
47 | 1516.91 | 1252.96 | 222.53 | 17.42 | 24 | 228.04 | 180.04 |  | 64 | 36.04 | 80 |  |  |  |  |  | 48 |  | 27.18
48 | 1546.85 | 1354.6 | 174.75 |  | 17.5 | 135.72 | 131.72 |  | 26 | 25.72 | 80 |  |  |  |  |  | 4 |  | 16.78
49 | 1556.42 | 1338.37 | 205.55 |  | 12.5 | 144.45 | 136.45 |  | 48 | 40.45 | 48 |  |  |  |  |  | 8 |  | 6.7
50 | 1556.56 | 1278.2 | 223.56 | 52.8 | 2 | 196.02 | 188.02 |  | 68 | 40.02 | 80 |  |  |  |  |  | 8 |  | 40
51 | 1610 | 1329.42 | 214.02 | 66.56 |  | 237.25 | 181.25 |  | 66.75 | 34.5 | 80 |  |  |  |  | 16 | 40 |  | 18.63
52 | 670.16 | 571.66 | 65.5 | 16 | 17 | 1299.32 | 123.11 |  | 57.75 | 17.36 | 48 |  |  |  |  | 24 | 350.25 | 801.96 | 9.56
53
Table de sortie
2023 | Heures Travaillees | Heures Temporaires | Heures Supplementaires | JP Planifie | JP Urgent | PAICD | Conge Special | Absenteisme | Accident du travail | Conge sans Solde | Year
0
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
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