{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["MODE D'EMPLOI","Affectations Saisie PY","Indisponibilités","DATA"],"not_rendered":{"images":4,"macros":1},"read":"whole","date_system":"1900"}

{"sheet":"MODE D'EMPLOI","index":0,"n_rows":36,"n_cols":10,"rows_kept":36}
[]
[]
["AVANT TOUTE CHOSE (à faire lors de la première utilisation du fichier ou en cas de changement de salarié):",{"$nulls":8},"Saisie de l'indisponibilité d'un ou de salariés:"]
[{"$nulls":9},"1/ Aller dans l'onglet \"Indisponibilité\""]
["1/ Aller dans l'onglet \"Indisponibilités\""]
["2/ Faire Ctrl+F"]
{"$rows_empty":12}
["3/ Cliquer sur \"Remplacer\""]
{"$rows_empty":12}
["Dans \"Rechercher\", saisir \"Sal1\"",{"$nulls":8},"2/ Saisir les indisponibilités des salariés les semaines où ils sont absents"]
["Dans \"Remplacer\", saisir Prénom et nom du salarié"]
[]
["4/ Cliquer sur \"Remplacer tout\""]
["5/ Faire la même chose pour Sal2, Sal3, Sal4, Sal5, Sal6, Sal7"]

{"sheet":"Affectations Saisie PY","index":1,"n_rows":56,"n_cols":10,"rows_kept":56,"merged":[[1,1,1,5],[1,7,2,7]]}
["Année"]
[2023,"Roulement de l'équipe pour la saisie des PY",{"$nulls":5},"Légende",null,"Absence salarié"]
[{"$nulls":9},"Repérage de l'affectation d'un salarié en particulier"]
["1er jour de la semaine","Salarie1","Salarié en charge de la saisie","Remplaçant 1 ","Remplaçant 2","Remplaçant 3"]
[{"$f":"7*RIGHT(B5,LEN(B5)-FIND(\".\",B5)*1)+DATE($A$2,1,3)-WEEKDAY(DATE($A$2,1,3))-5","v":"2023-01-02"},"Sem.1",{"$f":"VLOOKUP($B5,DATA!$K:$Y,9,FALSE)","v":"Salarie7"},{"$f":"VLOOKUP($B5,DATA!$K:$Y,10,FALSE)","v":"Salarie4"},{"$f":"VLOOKUP($B5,DATA!$K:$Y,11,FALSE)","v":"Salarie6"},{"$f":"VLOOKUP($B5,DATA!$K:$Y,12,FALSE)","v":"Salarie3"}]
[{"$f":"7*RIGHT(B6,LEN(B6)-FIND(\".\",B6)*1)+DATE($A$2,1,3)-WEEKDAY(DATE($A$2,1,3))-5","v":"2023-01-09"},"Sem.2",{"$f":"VLOOKUP($B6,DATA!$K:$Y,9,FALSE)","v":"Salarie4"},{"$f":"VLOOKUP($B6,DATA!$K:$Y,10,FALSE)","v":"Salarie6"},{"$f":"VLOOKUP($B6,DATA!$K:$Y,11,FALSE)","v":"Salarie3"},{"$f":"VLOOKUP($B6,DATA!$K:$Y,12,FALSE)","v":"Salarie2"}]
["2023-01-16","Sem.3",{"$f":"VLOOKUP($B7,DATA!$K:$Y,9,FALSE)","v":"Salarie6"},{"$f":"VLOOKUP($B7,DATA!$K:$Y,10,FALSE)","v":"Salarie3"},{"$f":"VLOOKUP($B7,DATA!$K:$Y,11,FALSE)","v":"Salarie2"},{"$f":"VLOOKUP($B7,DATA!$K:$Y,12,FALSE)","v":"Salarie1"}]
["2023-01-23","Sem.4",{"$f":"VLOOKUP($B8,DATA!$K:$Y,9,FALSE)","v":"Salarie3"},{"$f":"VLOOKUP($B8,DATA!$K:$Y,10,FALSE)","v":"Salarie2"},{"$f":"VLOOKUP($B8,DATA!$K:$Y,11,FALSE)","v":"Salarie1"},{"$f":"VLOOKUP($B8,DATA!$K:$Y,12,FALSE)","v":"Salarie5"}]
["2023-01-30","Sem.5",{"$f":"VLOOKUP($B9,DATA!$K:$Y,9,FALSE)","v":"Salarie2"},{"$f":"VLOOKUP($B9,DATA!$K:$Y,10,FALSE)","v":"Salarie1"},{"$f":"VLOOKUP($B9,DATA!$K:$Y,11,FALSE)","v":"Salarie5"},{"$f":"VLOOKUP($B9,DATA!$K:$Y,12,FALSE)","v":"Salarie7"}]
["2023-02-06","Sem.6",{"$f":"VLOOKUP($B10,DATA!$K:$Y,9,FALSE)","v":"Salarie1"},{"$f":"VLOOKUP($B10,DATA!$K:$Y,10,FALSE)","v":"Salarie5"},{"$f":"VLOOKUP($B10,DATA!$K:$Y,11,FALSE)","v":"Salarie7"},{"$f":"VLOOKUP($B10,DATA!$K:$Y,12,FALSE)","v":"Salarie4"}]
["2023-02-13","Sem.7",{"$f":"VLOOKUP($B11,DATA!$K:$Y,9,FALSE)","v":"Salarie5"},{"$f":"VLOOKUP($B11,DATA!$K:$Y,10,FALSE)","v":"Salarie7"},{"$f":"VLOOKUP($B11,DATA!$K:$Y,11,FALSE)","v":"Salarie4"},{"$f":"VLOOKUP($B11,DATA!$K:$Y,12,FALSE)","v":"Salarie6"}]
["2023-02-20","Sem.8",{"$f":"VLOOKUP($B12,DATA!$K:$Y,9,FALSE)","v":"Salarie7"},{"$f":"VLOOKUP($B12,DATA!$K:$Y,10,FALSE)","v":"Salarie4"},{"$f":"VLOOKUP($B12,DATA!$K:$Y,11,FALSE)","v":"Salarie6"},{"$f":"VLOOKUP($B12,DATA!$K:$Y,12,FALSE)","v":"Salarie3"}]
["2023-02-27","Sem.9",{"$f":"VLOOKUP($B13,DATA!$K:$Y,9,FALSE)","v":"Salarie4"},{"$f":"VLOOKUP($B13,DATA!$K:$Y,10,FALSE)","v":"Salarie6"},{"$f":"VLOOKUP($B13,DATA!$K:$Y,11,FALSE)","v":"Salarie3"},{"$f":"VLOOKUP($B13,DATA!$K:$Y,12,FALSE)","v":"Salarie2"}]
["2023-03-06","Sem.10",{"$f":"VLOOKUP($B14,DATA!$K:$Y,9,FALSE)","v":"Salarie6"},{"$f":"VLOOKUP($B14,DATA!$K:$Y,10,FALSE)","v":"Salarie3"},{"$f":"VLOOKUP($B14,DATA!$K:$Y,11,FALSE)","v":"Salarie2"},{"$f":"VLOOKUP($B14,DATA!$K:$Y,12,FALSE)","v":"Salarie1"}]
["2023-03-13","Sem.11",{"$f":"VLOOKUP($B15,DATA!$K:$Y,9,FALSE)","v":"Salarie3"},{"$f":"VLOOKUP($B15,DATA!$K:$Y,10,FALSE)","v":"Salarie2"},{"$f":"VLOOKUP($B15,DATA!$K:$Y,11,FALSE)","v":"Salarie1"},{"$f":"VLOOKUP($B15,DATA!$K:$Y,12,FALSE)","v":"Salarie5"}]
["2023-03-20","Sem.12",{"$f":"VLOOKUP($B16,DATA!$K:$Y,9,FALSE)","v":"Salarie2"},{"$f":"VLOOKUP($B16,DATA!$K:$Y,10,FALSE)","v":"Salarie1"},{"$f":"VLOOKUP($B16,DATA!$K:$Y,11,FALSE)","v":"Salarie5"},{"$f":"VLOOKUP($B16,DATA!$K:$Y,12,FALSE)","v":"Salarie7"}]
["2023-03-27","Sem.13",{"$f":"VLOOKUP($B17,DATA!$K:$Y,9,FALSE)","v":"Salarie1"},{"$f":"VLOOKUP($B17,DATA!$K:$Y,10,FALSE)","v":"Salarie5"},{"$f":"VLOOKUP($B17,DATA!$K:$Y,11,FALSE)","v":"Salarie7"},{"$f":"VLOOKUP($B17,DATA!$K:$Y,12,FALSE)","v":"Salarie4"}]
["2023-04-03","Sem.14",{"$f":"VLOOKUP($B18,DATA!$K:$Y,9,FALSE)","v":"Salarie5"},{"$f":"VLOOKUP($B18,DATA!$K:$Y,10,FALSE)","v":"Salarie7"},{"$f":"VLOOKUP($B18,DATA!$K:$Y,11,FALSE)","v":"Salarie4"},{"$f":"VLOOKUP($B18,DATA!$K:$Y,12,FALSE)","v":"Salarie6"}]
["2023-04-10","Sem.15",{"$f":"VLOOKUP($B19,DATA!$K:$Y,9,FALSE)","v":"Salarie7"},{"$f":"VLOOKUP($B19,DATA!$K:$Y,10,FALSE)","v":"Salarie4"},{"$f":"VLOOKUP($B19,DATA!$K:$Y,11,FALSE)","v":"Salarie6"},{"$f":"VLOOKUP($B19,DATA!$K:$Y,12,FALSE)","v":"Salarie3"}]
["2023-04-17","Sem.16",{"$f":"VLOOKUP($B20,DATA!$K:$Y,9,FALSE)","v":"Salarie4"},{"$f":"VLOOKUP($B20,DATA!$K:$Y,10,FALSE)","v":"Salarie6"},{"$f":"VLOOKUP($B20,DATA!$K:$Y,11,FALSE)","v":"Salarie3"},{"$f":"VLOOKUP($B20,DATA!$K:$Y,12,FALSE)","v":"Salarie2"}]
["2023-04-24","Sem.17",{"$f":"VLOOKUP($B21,DATA!$K:$Y,9,FALSE)","v":"Salarie6"},{"$f":"VLOOKUP($B21,DATA!$K:$Y,10,FALSE)","v":"Salarie3"},{"$f":"VLOOKUP($B21,DATA!$K:$Y,11,FALSE)","v":"Salarie2"},{"$f":"VLOOKUP($B21,DATA!$K:$Y,12,FALSE)","v":"Salarie1"}]
["2023-05-01","Sem.18",{"$f":"VLOOKUP($B22,DATA!$K:$Y,9,FALSE)","v":"Salarie3"},{"$f":"VLOOKUP($B22,DATA!$K:$Y,10,FALSE)","v":"Salarie2"},{"$f":"VLOOKUP($B22,DATA!$K:$Y,11,FALSE)","v":"Salarie1"},{"$f":"VLOOKUP($B22,DATA!$K:$Y,12,FALSE)","v":"Salarie5"}]
["2023-05-08","Sem.19",{"$f":"VLOOKUP($B23,DATA!$K:$Y,9,FALSE)","v":"Salarie2"},{"$f":"VLOOKUP($B23,DATA!$K:$Y,10,FALSE)","v":"Salarie1"},{"$f":"VLOOKUP($B23,DATA!$K:$Y,11,FALSE)","v":"Salarie5"},{"$f":"VLOOKUP($B23,DATA!$K:$Y,12,FALSE)","v":"Salarie7"}]
["2023-05-15","Sem.20",{"$f":"VLOOKUP($B24,DATA!$K:$Y,9,FALSE)","v":"Salarie1"},{"$f":"VLOOKUP($B24,DATA!$K:$Y,10,FALSE)","v":"Salarie5"},{"$f":"VLOOKUP($B24,DATA!$K:$Y,11,FALSE)","v":"Salarie7"},{"$f":"VLOOKUP($B24,DATA!$K:$Y,12,FALSE)","v":"Salarie4"}]
["2023-05-22","Sem.21",{"$f":"VLOOKUP($B25,DATA!$K:$Y,9,FALSE)","v":"Salarie5"},{"$f":"VLOOKUP($B25,DATA!$K:$Y,10,FALSE)","v":"Salarie7"},{"$f":"VLOOKUP($B25,DATA!$K:$Y,11,FALSE)","v":"Salarie4"},{"$f":"VLOOKUP($B25,DATA!$K:$Y,12,FALSE)","v":"Salarie6"}]
["2023-05-29","Sem.22",{"$f":"VLOOKUP($B26,DATA!$K:$Y,9,FALSE)","v":"Salarie7"},{"$f":"VLOOKUP($B26,DATA!$K:$Y,10,FALSE)","v":"Salarie4"},{"$f":"VLOOKUP($B26,DATA!$K:$Y,11,FALSE)","v":"Salarie6"},{"$f":"VLOOKUP($B26,DATA!$K:$Y,12,FALSE)","v":"Salarie3"}]
["2023-06-05","Sem.23",{"$f":"VLOOKUP($B27,DATA!$K:$Y,9,FALSE)","v":"Salarie4"},{"$f":"VLOOKUP($B27,DATA!$K:$Y,10,FALSE)","v":"Salarie6"},{"$f":"VLOOKUP($B27,DATA!$K:$Y,11,FALSE)","v":"Salarie3"},{"$f":"VLOOKUP($B27,DATA!$K:$Y,12,FALSE)","v":"Salarie2"}]
["2023-06-12","Sem.24",{"$f":"VLOOKUP($B28,DATA!$K:$Y,9,FALSE)","v":"Salarie6"},{"$f":"VLOOKUP($B28,DATA!$K:$Y,10,FALSE)","v":"Salarie3"},{"$f":"VLOOKUP($B28,DATA!$K:$Y,11,FALSE)","v":"Salarie2"},{"$f":"VLOOKUP($B28,DATA!$K:$Y,12,FALSE)","v":"Salarie1"}]
["2023-06-19","Sem.25",{"$f":"VLOOKUP($B29,DATA!$K:$Y,9,FALSE)","v":"Salarie3"},{"$f":"VLOOKUP($B29,DATA!$K:$Y,10,FALSE)","v":"Salarie2"},{"$f":"VLOOKUP($B29,DATA!$K:$Y,11,FALSE)","v":"Salarie1"},{"$f":"VLOOKUP($B29,DATA!$K:$Y,12,FALSE)","v":"Salarie5"}]
["2023-06-26","Sem.26",{"$f":"VLOOKUP($B30,DATA!$K:$Y,9,FALSE)","v":"Salarie2"},{"$f":"VLOOKUP($B30,DATA!$K:$Y,10,FALSE)","v":"Salarie1"},{"$f":"VLOOKUP($B30,DATA!$K:$Y,11,FALSE)","v":"Salarie5"},{"$f":"VLOOKUP($B30,DATA!$K:$Y,12,FALSE)","v":"Salarie7"}]
["2023-07-03","Sem.27",{"$f":"VLOOKUP($B31,DATA!$K:$Y,9,FALSE)","v":"Salarie1"},{"$f":"VLOOKUP($B31,DATA!$K:$Y,10,FALSE)","v":"Salarie5"},{"$f":"VLOOKUP($B31,DATA!$K:$Y,11,FALSE)","v":"Salarie7"},{"$f":"VLOOKUP($B31,DATA!$K:$Y,12,FALSE)","v":"Salarie4"}]
["2023-07-10","Sem.28",{"$f":"VLOOKUP($B32,DATA!$K:$Y,9,FALSE)","v":"Salarie5"},{"$f":"VLOOKUP($B32,DATA!$K:$Y,10,FALSE)","v":"Salarie7"},{"$f":"VLOOKUP($B32,DATA!$K:$Y,11,FALSE)","v":"Salarie4"},{"$f":"VLOOKUP($B32,DATA!$K:$Y,12,FALSE)","v":"Salarie6"}]
["2023-07-17","Sem.29",{"$f":"VLOOKUP($B33,DATA!$K:$Y,9,FALSE)","v":"Salarie7"},{"$f":"VLOOKUP($B33,DATA!$K:$Y,10,FALSE)","v":"Salarie4"},{"$f":"VLOOKUP($B33,DATA!$K:$Y,11,FALSE)","v":"Salarie6"},{"$f":"VLOOKUP($B33,DATA!$K:$Y,12,FALSE)","v":"Salarie3"}]
["2023-07-24","Sem.30",{"$f":"VLOOKUP($B34,DATA!$K:$Y,9,FALSE)","v":"Salarie4"},{"$f":"VLOOKUP($B34,DATA!$K:$Y,10,FALSE)","v":"Salarie6"},{"$f":"VLOOKUP($B34,DATA!$K:$Y,11,FALSE)","v":"Salarie3"},{"$f":"VLOOKUP($B34,DATA!$K:$Y,12,FALSE)","v":"Salarie2"}]
["2023-07-31","Sem.31",{"$f":"VLOOKUP($B35,DATA!$K:$Y,9,FALSE)","v":"Salarie6"},{"$f":"VLOOKUP($B35,DATA!$K:$Y,10,FALSE)","v":"Salarie3"},{"$f":"VLOOKUP($B35,DATA!$K:$Y,11,FALSE)","v":"Salarie2"},{"$f":"VLOOKUP($B35,DATA!$K:$Y,12,FALSE)","v":"Salarie1"}]
["2023-08-07","Sem.32",{"$f":"VLOOKUP($B36,DATA!$K:$Y,9,FALSE)","v":"Salarie3"},{"$f":"VLOOKUP($B36,DATA!$K:$Y,10,FALSE)","v":"Salarie2"},{"$f":"VLOOKUP($B36,DATA!$K:$Y,11,FALSE)","v":"Salarie1"},{"$f":"VLOOKUP($B36,DATA!$K:$Y,12,FALSE)","v":"Salarie5"}]
["2023-08-14","Sem.33",{"$f":"VLOOKUP($B37,DATA!$K:$Y,9,FALSE)","v":"Salarie2"},{"$f":"VLOOKUP($B37,DATA!$K:$Y,10,FALSE)","v":"Salarie1"},{"$f":"VLOOKUP($B37,DATA!$K:$Y,11,FALSE)","v":"Salarie5"},{"$f":"VLOOKUP($B37,DATA!$K:$Y,12,FALSE)","v":"Salarie7"}]
["2023-08-21","Sem.34",{"$f":"VLOOKUP($B38,DATA!$K:$Y,9,FALSE)","v":"Salarie1"},{"$f":"VLOOKUP($B38,DATA!$K:$Y,10,FALSE)","v":"Salarie5"},{"$f":"VLOOKUP($B38,DATA!$K:$Y,11,FALSE)","v":"Salarie7"},{"$f":"VLOOKUP($B38,DATA!$K:$Y,12,FALSE)","v":"Salarie4"}]
["2023-08-28","Sem.35",{"$f":"VLOOKUP($B39,DATA!$K:$Y,9,FALSE)","v":"Salarie5"},{"$f":"VLOOKUP($B39,DATA!$K:$Y,10,FALSE)","v":"Salarie7"},{"$f":"VLOOKUP($B39,DATA!$K:$Y,11,FALSE)","v":"Salarie4"},{"$f":"VLOOKUP($B39,DATA!$K:$Y,12,FALSE)","v":"Salarie6"}]
["2023-09-04","Sem.36",{"$f":"VLOOKUP($B40,DATA!$K:$Y,9,FALSE)","v":"Salarie7"},{"$f":"VLOOKUP($B40,DATA!$K:$Y,10,FALSE)","v":"Salarie4"},{"$f":"VLOOKUP($B40,DATA!$K:$Y,11,FALSE)","v":"Salarie6"},{"$f":"VLOOKUP($B40,DATA!$K:$Y,12,FALSE)","v":"Salarie3"}]
["2023-09-11","Sem.37",{"$f":"VLOOKUP($B41,DATA!$K:$Y,9,FALSE)","v":"Salarie4"},{"$f":"VLOOKUP($B41,DATA!$K:$Y,10,FALSE)","v":"Salarie6"},{"$f":"VLOOKUP($B41,DATA!$K:$Y,11,FALSE)","v":"Salarie3"},{"$f":"VLOOKUP($B41,DATA!$K:$Y,12,FALSE)","v":"Salarie2"}]
["2023-09-18","Sem.38",{"$f":"VLOOKUP($B42,DATA!$K:$Y,9,FALSE)","v":"Salarie6"},{"$f":"VLOOKUP($B42,DATA!$K:$Y,10,FALSE)","v":"Salarie3"},{"$f":"VLOOKUP($B42,DATA!$K:$Y,11,FALSE)","v":"Salarie2"},{"$f":"VLOOKUP($B42,DATA!$K:$Y,12,FALSE)","v":"Salarie1"}]
["2023-09-25","Sem.39",{"$f":"VLOOKUP($B43,DATA!$K:$Y,9,FALSE)","v":"Salarie3"},{"$f":"VLOOKUP($B43,DATA!$K:$Y,10,FALSE)","v":"Salarie2"},{"$f":"VLOOKUP($B43,DATA!$K:$Y,11,FALSE)","v":"Salarie1"},{"$f":"VLOOKUP($B43,DATA!$K:$Y,12,FALSE)","v":"Salarie5"}]
["2023-10-02","Sem.40",{"$f":"VLOOKUP($B44,DATA!$K:$Y,9,FALSE)","v":"Salarie2"},{"$f":"VLOOKUP($B44,DATA!$K:$Y,10,FALSE)","v":"Salarie1"},{"$f":"VLOOKUP($B44,DATA!$K:$Y,11,FALSE)","v":"Salarie5"},{"$f":"VLOOKUP($B44,DATA!$K:$Y,12,FALSE)","v":"Salarie7"}]
["2023-10-09","Sem.41",{"$f":"VLOOKUP($B45,DATA!$K:$Y,9,FALSE)","v":"Salarie1"},{"$f":"VLOOKUP($B45,DATA!$K:$Y,10,FALSE)","v":"Salarie5"},{"$f":"VLOOKUP($B45,DATA!$K:$Y,11,FALSE)","v":"Salarie7"},{"$f":"VLOOKUP($B45,DATA!$K:$Y,12,FALSE)","v":"Salarie4"}]
["2023-10-16","Sem.42",{"$f":"VLOOKUP($B46,DATA!$K:$Y,9,FALSE)","v":"Salarie5"},{"$f":"VLOOKUP($B46,DATA!$K:$Y,10,FALSE)","v":"Salarie7"},{"$f":"VLOOKUP($B46,DATA!$K:$Y,11,FALSE)","v":"Salarie4"},{"$f":"VLOOKUP($B46,DATA!$K:$Y,12,FALSE)","v":"Salarie6"}]
["2023-10-23","Sem.43",{"$f":"VLOOKUP($B47,DATA!$K:$Y,9,FALSE)","v":"Salarie7"},{"$f":"VLOOKUP($B47,DATA!$K:$Y,10,FALSE)","v":"Salarie4"},{"$f":"VLOOKUP($B47,DATA!$K:$Y,11,FALSE)","v":"Salarie6"},{"$f":"VLOOKUP($B47,DATA!$K:$Y,12,FALSE)","v":"Salarie3"}]
["2023-10-30","Sem.44",{"$f":"VLOOKUP($B48,DATA!$K:$Y,9,FALSE)","v":"Salarie4"},{"$f":"VLOOKUP($B48,DATA!$K:$Y,10,FALSE)","v":"Salarie6"},{"$f":"VLOOKUP($B48,DATA!$K:$Y,11,FALSE)","v":"Salarie3"},{"$f":"VLOOKUP($B48,DATA!$K:$Y,12,FALSE)","v":"Salarie2"}]
["2023-11-06","Sem.45",{"$f":"VLOOKUP($B49,DATA!$K:$Y,9,FALSE)","v":"Salarie6"},{"$f":"VLOOKUP($B49,DATA!$K:$Y,10,FALSE)","v":"Salarie3"},{"$f":"VLOOKUP($B49,DATA!$K:$Y,11,FALSE)","v":"Salarie2"},{"$f":"VLOOKUP($B49,DATA!$K:$Y,12,FALSE)","v":"Salarie1"}]
["2023-11-13","Sem.46",{"$f":"VLOOKUP($B50,DATA!$K:$Y,9,FALSE)","v":"Salarie3"},{"$f":"VLOOKUP($B50,DATA!$K:$Y,10,FALSE)","v":"Salarie2"},{"$f":"VLOOKUP($B50,DATA!$K:$Y,11,FALSE)","v":"Salarie1"},{"$f":"VLOOKUP($B50,DATA!$K:$Y,12,FALSE)","v":"Salarie5"}]
["2023-11-20","Sem.47",{"$f":"VLOOKUP($B51,DATA!$K:$Y,9,FALSE)","v":"Salarie2"},{"$f":"VLOOKUP($B51,DATA!$K:$Y,10,FALSE)","v":"Salarie1"},{"$f":"VLOOKUP($B51,DATA!$K:$Y,11,FALSE)","v":"Salarie5"},{"$f":"VLOOKUP($B51,DATA!$K:$Y,12,FALSE)","v":"Salarie7"}]
["2023-11-27","Sem.48",{"$f":"VLOOKUP($B52,DATA!$K:$Y,9,FALSE)","v":"Salarie1"},{"$f":"VLOOKUP($B52,DATA!$K:$Y,10,FALSE)","v":"Salarie5"},{"$f":"VLOOKUP($B52,DATA!$K:$Y,11,FALSE)","v":"Salarie7"},{"$f":"VLOOKUP($B52,DATA!$K:$Y,12,FALSE)","v":"Salarie4"}]
["2023-12-04","Sem.49",{"$f":"VLOOKUP($B53,DATA!$K:$Y,9,FALSE)","v":"Salarie5"},{"$f":"VLOOKUP($B53,DATA!$K:$Y,10,FALSE)","v":"Salarie7"},{"$f":"VLOOKUP($B53,DATA!$K:$Y,11,FALSE)","v":"Salarie4"},{"$f":"VLOOKUP($B53,DATA!$K:$Y,12,FALSE)","v":"Salarie6"}]
["2023-12-11","Sem.50",{"$f":"VLOOKUP($B54,DATA!$K:$Y,9,FALSE)","v":"Salarie7"},{"$f":"VLOOKUP($B54,DATA!$K:$Y,10,FALSE)","v":"Salarie4"},{"$f":"VLOOKUP($B54,DATA!$K:$Y,11,FALSE)","v":"Salarie6"},{"$f":"VLOOKUP($B54,DATA!$K:$Y,12,FALSE)","v":"Salarie3"}]
["2023-12-18","Sem.51",{"$f":"VLOOKUP($B55,DATA!$K:$Y,9,FALSE)","v":"Salarie4"},{"$f":"VLOOKUP($B55,DATA!$K:$Y,10,FALSE)","v":"Salarie6"},{"$f":"VLOOKUP($B55,DATA!$K:$Y,11,FALSE)","v":"Salarie3"},{"$f":"VLOOKUP($B55,DATA!$K:$Y,12,FALSE)","v":"Salarie2"}]
["2023-12-25","Sem.52",{"$f":"VLOOKUP($B56,DATA!$K:$Y,9,FALSE)","v":"Salarie6"},{"$f":"VLOOKUP($B56,DATA!$K:$Y,10,FALSE)","v":"Salarie3"},{"$f":"VLOOKUP($B56,DATA!$K:$Y,11,FALSE)","v":"Salarie2"},{"$f":"VLOOKUP($B56,DATA!$K:$Y,12,FALSE)","v":"Salarie1"}]

{"sheet":"Indisponibilités","index":2,"n_rows":63,"n_cols":25,"rows_kept":63}
["indisp."]
[{"$nulls":18},{"$f":"IFERROR(VLOOKUP(L2,$C$2:$D$8,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(M2,$C$2:$D$8,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(N2,$C$2:$D$8,2,FALSE),\"\")","v":""},"","","",""]
[{"$nulls":18},{"$f":"IFERROR(VLOOKUP(L3,$C$2:$D$8,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(M3,$C$2:$D$8,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(N3,$C$2:$D$8,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(O3,$C$2:$D$8,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(P3,$C$2:$D$8,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Q3,$C$2:$D$8,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(R3,$C$2:$D$8,2,FALSE),\"\")","v":""}]
[{"$nulls":18},"","","","","","",""]
[{"$nulls":18},"","","","","","",""]
[{"$nulls":18},"","","","","","",""]
[{"$nulls":18},"","","","","","",""]
[{"$nulls":18},"","","","","","",""]
[{"$nulls":18},"","","","","","",""]
[{"$nulls":18},"","","","","","",""]
[null,null,"Salarie1","Salarie2","Salarie3","Salarie4","Salarie5","Salarie6","Salarie7",{"$nulls":9},"","","","","","",""]
[null,"Sem.1",{"$nulls":16},"","","","","","",""]
[null,"Sem.2",{"$nulls":16},"","","","","","",""]
[null,"Sem.3",{"$nulls":16},"","","","","","",""]
[null,"Sem.4",{"$nulls":16},"","","","","","",""]
[null,"Sem.5",{"$nulls":16},"","","","","","",""]
[null,"Sem.6",{"$nulls":16},"","","","","","",""]
[null,"Sem.7",{"$nulls":16},"","","","","","",""]
[null,"Sem.8",{"$nulls":16},"","","","","","",""]
[null,"Sem.9",{"$nulls":16},"","","","","","",""]
[null,"Sem.10",{"$nulls":16},"","","","","","",""]
[null,"Sem.11",{"$nulls":16},"","","","","","",""]
[null,"Sem.12",{"$nulls":16},"","","","","","",""]
[null,"Sem.13",{"$nulls":16},{"$f":"IFERROR(VLOOKUP(L24,$C$2:$D$8,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(M24,$C$2:$D$8,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(N24,$C$2:$D$8,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(O24,$C$2:$D$8,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(P24,$C$2:$D$8,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Q24,$C$2:$D$8,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(R24,$C$2:$D$8,2,FALSE),\"\")","v":""}]
[null,"Sem.14",{"$nulls":16},"","","","","","",""]
[null,"Sem.15",{"$nulls":16},"","","","","","",""]
[null,"Sem.16",{"$nulls":16},"","","","","","",""]
[null,"Sem.17","indisp.",null,null,"indisp.",{"$nulls":12},"","","","","","",""]
[null,"Sem.18",{"$nulls":5},"indisp.","indisp.",{"$nulls":9},"","","","","","",""]
[null,"Sem.19",{"$nulls":6},"indisp.",{"$nulls":9},"","","","","","",""]
[null,"Sem.20",{"$nulls":16},"","","","","","",""]
[null,"Sem.21",null,"indisp.",{"$nulls":14},"","","","","","",""]
[null,"Sem.22",{"$nulls":16},"","","","","","",""]
[null,"Sem.23",{"$nulls":16},"","","","","","",""]
[null,"Sem.24",{"$nulls":16},"","","","","","",""]
[null,"Sem.25",{"$nulls":16},"","","","","","",""]
[null,"Sem.26",{"$nulls":16},"","","","","","",""]
[null,"Sem.27",{"$nulls":16},"","","","","","",""]
[null,"Sem.28",{"$nulls":16},"","","","","","",""]
[null,"Sem.29",null,"indisp.",{"$nulls":14},"","","","","","",""]
[null,"Sem.30",null,"indisp.",{"$nulls":14},"","","","","","",""]
[null,"Sem.31",null,"indisp.",{"$nulls":14},"","","","","","",""]
[null,"Sem.32",{"$nulls":5},"indisp.","indisp.",{"$nulls":9},"","","","","","",""]
[null,"Sem.33","indisp.",null,null,"indisp.",null,"indisp.","indisp.",{"$nulls":9},"","","","","","",""]
[null,"Sem.34","indisp.",null,null,"indisp.",null,null,"indisp.",{"$nulls":9},"","","","","","",""]
[null,"Sem.35","indisp.",null,null,"indisp.",{"$nulls":12},"","","","","","",""]
[null,"Sem.36",{"$nulls":16},"","","","","","",""]
[null,"Sem.37",{"$nulls":16},"","","","","","",""]
[null,"Sem.38",{"$nulls":16},"","","","","","",""]
[null,"Sem.39",{"$nulls":16},"","","","","","",""]
[null,"Sem.40",{"$nulls":16},"","","","","","",""]
[null,"Sem.41",{"$nulls":16},"","","","","","",""]
[null,"Sem.42",{"$nulls":16},"","","","","","",""]
[null,"Sem.43"]
[null,"Sem.44"]
[null,"Sem.45"]
[null,"Sem.46"]
[null,"Sem.47"]
[null,"Sem.48"]
[null,"Sem.49"]
[null,"Sem.50"]
[null,"Sem.51"]
[null,"Sem.52"]

{"sheet":"DATA","index":3,"n_rows":53,"n_cols":25,"rows_kept":53}
[]
[null,{"$f":"RAND()","v":0.7914997994325079},1,"Salarie7",0.12358809913612745,{"$nulls":5},"Sem.1",1,{"$f":"IF(L2+1<=7,L2+1,1)","v":2},{"$f":"IF(M2+1<=7,M2+1,1)","v":3},4,5,6,7,{"$f":"IFERROR(VLOOKUP(L2,$C$2:$D$8,2,FALSE),\"\")","v":"Salarie7"},{"$f":"IFERROR(VLOOKUP(M2,$C$2:$D$8,2,FALSE),\"\")","v":"Salarie4"},{"$f":"IFERROR(VLOOKUP(N2,$C$2:$D$8,2,FALSE),\"\")","v":"Salarie6"},"Salarie3","Salarie2","Salarie1","Salarie5"]
[null,0.753526248564749,2,"Salarie4",0.13069182338596097,{"$nulls":5},"Sem.2",2,{"$f":"IF(L3+1<=7,L3+1,1)","v":3},4,5,6,7,1,{"$f":"IFERROR(VLOOKUP(L3,$C$2:$D$8,2,FALSE),\"\")","v":"Salarie4"},"Salarie6","Salarie3","Salarie2","Salarie1","Salarie5","Salarie7"]
[null,0.6391321552968876,3,"Salarie6",0.3303813834271013,{"$nulls":5},"Sem.3",3,4,5,6,7,1,2,"Salarie6","Salarie3","Salarie2","Salarie1","Salarie5","Salarie7","Salarie4"]
[null,0.9206751364046378,4,"Salarie3",0.3358848202904128,{"$nulls":5},"Sem.4",4,5,6,7,1,2,3,"Salarie3","Salarie2","Salarie1","Salarie5","Salarie7","Salarie4","Salarie6"]
[null,0.8774180877238537,5,"Salarie2",0.44927600984866334,{"$nulls":5},"Sem.5",5,6,7,1,2,3,4,"Salarie2","Salarie1","Salarie5","Salarie7","Salarie4","Salarie6","Salarie3"]
[null,0.5886278805214539,6,"Salarie1",0.46694245590758565,{"$nulls":5},"Sem.6",6,7,1,2,3,4,5,"Salarie1","Salarie5","Salarie7","Salarie4","Salarie6","Salarie3","Salarie2"]
[null,0.9810885148096775,7,"Salarie5",0.5153387908026205,{"$nulls":5},"Sem.7",7,1,2,3,4,5,6,"Salarie5","Salarie7","Salarie4","Salarie6","Salarie3","Salarie2","Salarie1"]
[{"$nulls":10},"Sem.8",{"$f":"IF(L8+1<=7,L8+1,$L$2)","v":1},2,3,4,5,6,7,"Salarie7","Salarie4","Salarie6","Salarie3","Salarie2","Salarie1","Salarie5"]
[{"$nulls":10},"Sem.9",{"$f":"IF(L9+1<=7,L9+1,$L$2)","v":2},3,4,5,6,7,1,"Salarie4","Salarie6","Salarie3","Salarie2","Salarie1","Salarie5","Salarie7"]
[{"$nulls":10},"Sem.10",3,4,5,6,7,1,2,"Salarie6","Salarie3","Salarie2","Salarie1","Salarie5","Salarie7","Salarie4"]
[{"$nulls":10},"Sem.11",4,5,6,7,1,2,3,"Salarie3","Salarie2","Salarie1","Salarie5","Salarie7","Salarie4","Salarie6"]
[{"$nulls":10},"Sem.12",5,6,7,1,2,3,4,"Salarie2","Salarie1","Salarie5","Salarie7","Salarie4","Salarie6","Salarie3"]
[{"$nulls":10},"Sem.13",6,7,1,2,3,4,5,"Salarie1","Salarie5","Salarie7","Salarie4","Salarie6","Salarie3","Salarie2"]
[{"$nulls":10},"Sem.14",7,1,2,3,4,5,6,"Salarie5","Salarie7","Salarie4","Salarie6","Salarie3","Salarie2","Salarie1"]
[{"$nulls":10},"Sem.15",1,2,3,4,5,6,7,"Salarie7","Salarie4","Salarie6","Salarie3","Salarie2","Salarie1","Salarie5"]
[{"$nulls":10},"Sem.16",2,3,4,5,6,7,1,"Salarie4","Salarie6","Salarie3","Salarie2","Salarie1","Salarie5","Salarie7"]
[{"$nulls":10},"Sem.17",3,4,5,6,7,1,2,"Salarie6","Salarie3","Salarie2","Salarie1","Salarie5","Salarie7","Salarie4"]
[{"$nulls":10},"Sem.18",4,{"$f":"IF(L19+1<=7,L19+1,1)","v":5},6,7,1,2,3,"Salarie3","Salarie2","Salarie1","Salarie5","Salarie7","Salarie4","Salarie6"]
[{"$nulls":10},"Sem.19",5,6,7,1,2,3,4,"Salarie2","Salarie1","Salarie5","Salarie7","Salarie4","Salarie6","Salarie3"]
[{"$nulls":10},"Sem.20",6,7,1,2,3,4,5,"Salarie1","Salarie5","Salarie7","Salarie4","Salarie6","Salarie3","Salarie2"]
[{"$nulls":10},"Sem.21",7,1,2,3,4,5,6,"Salarie5","Salarie7","Salarie4","Salarie6","Salarie3","Salarie2","Salarie1"]
[{"$nulls":10},"Sem.22",1,2,3,4,5,6,7,"Salarie7","Salarie4","Salarie6","Salarie3","Salarie2","Salarie1","Salarie5"]
[{"$nulls":10},"Sem.23",2,3,4,5,6,7,1,{"$f":"IFERROR(VLOOKUP(L24,$C$2:$D$8,2,FALSE),\"\")","v":"Salarie4"},"Salarie6","Salarie3","Salarie2","Salarie1","Salarie5","Salarie7"]
[{"$nulls":10},"Sem.24",3,4,5,6,7,1,2,"Salarie6","Salarie3","Salarie2","Salarie1","Salarie5","Salarie7","Salarie4"]
[{"$nulls":10},"Sem.25",4,5,6,7,1,2,3,"Salarie3","Salarie2","Salarie1","Salarie5","Salarie7","Salarie4","Salarie6"]
[{"$nulls":10},"Sem.26",5,6,7,1,2,3,4,"Salarie2","Salarie1","Salarie5","Salarie7","Salarie4","Salarie6","Salarie3"]
[{"$nulls":10},"Sem.27",6,7,1,2,3,4,5,"Salarie1","Salarie5","Salarie7","Salarie4","Salarie6","Salarie3","Salarie2"]
[{"$nulls":10},"Sem.28",7,1,2,3,4,5,6,"Salarie5","Salarie7","Salarie4","Salarie6","Salarie3","Salarie2","Salarie1"]
[{"$nulls":10},"Sem.29",1,2,3,4,5,6,7,"Salarie7","Salarie4","Salarie6","Salarie3","Salarie2","Salarie1","Salarie5"]
[{"$nulls":10},"Sem.30",2,3,4,5,6,7,1,"Salarie4","Salarie6","Salarie3","Salarie2","Salarie1","Salarie5","Salarie7"]
[{"$nulls":10},"Sem.31",3,4,5,6,7,1,2,"Salarie6","Salarie3","Salarie2","Salarie1","Salarie5","Salarie7","Salarie4"]
[{"$nulls":10},"Sem.32",4,5,6,7,1,2,3,"Salarie3","Salarie2","Salarie1","Salarie5","Salarie7","Salarie4","Salarie6"]
[{"$nulls":10},"Sem.33",5,{"$f":"IF(L34+1<=7,L34+1,1)","v":6},7,1,2,3,4,"Salarie2","Salarie1","Salarie5","Salarie7","Salarie4","Salarie6","Salarie3"]
[{"$nulls":10},"Sem.34",6,{"$f":"IF(L35+1<=7,L35+1,1)","v":7},1,2,3,4,5,"Salarie1","Salarie5","Salarie7","Salarie4","Salarie6","Salarie3","Salarie2"]
[{"$nulls":10},"Sem.35",7,1,2,3,4,5,6,"Salarie5","Salarie7","Salarie4","Salarie6","Salarie3","Salarie2","Salarie1"]
[{"$nulls":10},"Sem.36",1,2,3,4,5,6,7,"Salarie7","Salarie4","Salarie6","Salarie3","Salarie2","Salarie1","Salarie5"]
[{"$nulls":10},"Sem.37",2,3,4,5,6,7,1,"Salarie4","Salarie6","Salarie3","Salarie2","Salarie1","Salarie5","Salarie7"]
[{"$nulls":10},"Sem.38",3,4,5,6,7,1,2,"Salarie6","Salarie3","Salarie2","Salarie1","Salarie5","Salarie7","Salarie4"]
[{"$nulls":10},"Sem.39",4,5,6,7,1,2,3,"Salarie3","Salarie2","Salarie1","Salarie5","Salarie7","Salarie4","Salarie6"]
[{"$nulls":10},"Sem.40",5,6,7,1,2,3,4,"Salarie2","Salarie1","Salarie5","Salarie7","Salarie4","Salarie6","Salarie3"]
[{"$nulls":10},"Sem.41",6,7,1,2,3,4,5,"Salarie1","Salarie5","Salarie7","Salarie4","Salarie6","Salarie3","Salarie2"]
[{"$nulls":10},"Sem.42",7,1,2,3,4,5,6,"Salarie5","Salarie7","Salarie4","Salarie6","Salarie3","Salarie2","Salarie1"]
[{"$nulls":10},"Sem.43",1,2,3,4,5,6,7,"Salarie7","Salarie4","Salarie6","Salarie3","Salarie2","Salarie1","Salarie5"]
[{"$nulls":10},"Sem.44",{"$f":"IF(L44+1<=7,L44+1,$L$2)","v":2},3,4,5,6,7,1,"Salarie4","Salarie6","Salarie3","Salarie2","Salarie1","Salarie5","Salarie7"]
[{"$nulls":10},"Sem.45",3,4,5,6,7,1,2,"Salarie6","Salarie3","Salarie2","Salarie1","Salarie5","Salarie7","Salarie4"]
[{"$nulls":10},"Sem.46",4,5,6,7,1,2,3,"Salarie3","Salarie2","Salarie1","Salarie5","Salarie7","Salarie4","Salarie6"]
[{"$nulls":10},"Sem.47",5,6,7,1,2,3,4,"Salarie2","Salarie1","Salarie5","Salarie7","Salarie4","Salarie6","Salarie3"]
[{"$nulls":10},"Sem.48",6,7,1,2,3,4,5,"Salarie1","Salarie5","Salarie7","Salarie4","Salarie6","Salarie3","Salarie2"]
[{"$nulls":10},"Sem.49",7,1,2,3,4,5,6,"Salarie5","Salarie7","Salarie4","Salarie6","Salarie3","Salarie2","Salarie1"]
[{"$nulls":10},"Sem.50",1,{"$f":"IF(L51+1<=7,L51+1,1)","v":2},3,4,5,6,7,"Salarie7","Salarie4","Salarie6","Salarie3","Salarie2","Salarie1","Salarie5"]
[{"$nulls":10},"Sem.51",2,3,4,5,6,7,1,"Salarie4","Salarie6","Salarie3","Salarie2","Salarie1","Salarie5","Salarie7"]
[{"$nulls":10},"Sem.52",3,4,5,6,7,1,2,"Salarie6","Salarie3","Salarie2","Salarie1","Salarie5","Salarie7","Salarie4"]