{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["HREC","PERS","Initialise"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":13,"defined_names":342,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"HREC","index":0,"n_rows":53,"n_cols":18,"rows_kept":53,"cut":false,"hidden":false,"merged":[]}
[null,null,null,"CIR","CIR","CIR","CIR","CIR","CIR","CIR","CII","CII","CII","CII","CII"]
["Matricule","Nom","Prénom","Projet 1","Projet 2","Projet 3","Projet 4","Projet 5","Projet 6","Projet 7","Projet 8","Projet 9","Projet 10","Projet 11","Projet 12",{"$f":"IF(PERS!$A$1=\"HEURES\",\"Total heures CIR\",\"Total jours CIR\")","v":"Total heures CIR"},{"$f":"IF(PERS!$A$1=\"HEURES\",\"Total heures CII\",\"Total jours CII\")","v":"Total heures CII"},{"$f":"IF(PERS!$A$1=\"HEURES\",\"Total heures\",\"Total jours\")","v":"Total heures"}]
[1,"dupond",null,100,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUMIFS(D3:O3,$D$1:$O$1,\"CIR\")","v":100},{"$f":"SUMIFS(D3:O3,$D$1:$O$1,\"CII\")","v":0},{"$f":"SUM(P3:Q3)","v":100}]
[2,"martin",null,200,null,null,null,null,null,null,null,null,null,null,null,200,0,200]
[3,"durand",null,300,null,null,null,null,null,null,null,null,null,null,null,300,0,300]
[4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
[5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
[6,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
[7,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
[8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
[9,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
[10,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
[11,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
[12,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
[13,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
[14,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
[15,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
[16,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
[17,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
[18,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
[19,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
[20,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
[21,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
[22,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
[23,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
[24,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
[25,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
[26,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
[27,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
[28,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
[29,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
[30,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
[31,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
[32,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
[33,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUMIFS(D35:O35,$D$1:$O$1,\"CIR\")","v":0},{"$f":"SUMIFS(D35:O35,$D$1:$O$1,\"CII\")","v":0},{"$f":"SUM(P35:Q35)","v":0}]
[34,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
[35,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
[36,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
[37,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
[38,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
[39,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
[40,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
[41,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
[42,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
[43,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
[44,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
[45,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
[46,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
[47,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
[48,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
[49,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
[50,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
["ZZZ","ZZZ","TOTAUX",{"$f":"SUM(D3:D52)","v":600},0,0,0,0,0,0,0,0,0,0,0,600,0,600]

{"sheet":"PERS","index":1,"n_rows":74,"n_cols":10,"rows_kept":74,"cut":false,"hidden":false,"merged":[]}
["HEURES",null,"Heures / jour",7]
["Matricule RH","Site/BU","Nom","Prénom","Date \nd'entrée","Date \nde sortie",{"$f":"IF(A1=\"HEURES\",\"Heures payées\",\"Jours payés\")","v":"Heures payées"},"Absences, CP, autres",{"$f":"IF(A1=\"HEURES\",\"Heures travaillées\",\"Jours travaillé\")","v":"Heures travaillées"},{"$f":"IF(A1=\"HEURES\",\"Total heures projets\",\"Total jours projets\")","v":"Total heures projets"}]
[{"$f":"HREC!A3","v":1},null,{"$f":"VLOOKUP(A3,HREC!$A$3:$S$341,2,FALSE)","v":"dupond"},{"$f":"VLOOKUP(A3,HREC!$A$3:$S$341,3,FALSE)","v":0},"2021-01-01","2021-12-31",{"$f":"IF($A$1=\"HEURES\",NETWORKDAYS(E3,F3,$A$66:$A$74)*$D$1,NETWORKDAYS(E3,F3,$A$66:$A$74))","v":1827},null,{"$f":"G3-H3","v":1827},{"$f":"VLOOKUP(A3,HREC!$A$3:$S$341,18,FALSE)","v":100}]
[{"$f":"HREC!A4","v":2},null,{"$f":"VLOOKUP(A4,HREC!$A$3:$S$341,2,FALSE)","v":"martin"},{"$f":"VLOOKUP(A4,HREC!$A$3:$S$341,3,FALSE)","v":0},"2021-01-01","2021-12-31",1827,null,1827,{"$f":"VLOOKUP(A4,HREC!$A$3:$S$341,18,FALSE)","v":200}]
[{"$f":"HREC!A5","v":3},null,{"$f":"VLOOKUP(A5,HREC!$A$3:$S$341,2,FALSE)","v":"durand"},{"$f":"VLOOKUP(A5,HREC!$A$3:$S$341,3,FALSE)","v":0},"2021-01-01","2021-12-31",1827,null,1827,{"$f":"VLOOKUP(A5,HREC!$A$3:$S$341,18,FALSE)","v":300}]
[{"$f":"HREC!A6","v":4},null,{"$f":"VLOOKUP(A6,HREC!$A$3:$S$341,2,FALSE)","v":0},{"$f":"VLOOKUP(A6,HREC!$A$3:$S$341,3,FALSE)","v":0},"2021-01-01","2021-12-31",1827,null,1827,{"$f":"VLOOKUP(A6,HREC!$A$3:$S$341,18,FALSE)","v":0}]
[{"$f":"HREC!A7","v":5},null,{"$f":"VLOOKUP(A7,HREC!$A$3:$S$341,2,FALSE)","v":0},{"$f":"VLOOKUP(A7,HREC!$A$3:$S$341,3,FALSE)","v":0},"2021-01-01","2021-12-31",1827,null,1827,{"$f":"VLOOKUP(A7,HREC!$A$3:$S$341,18,FALSE)","v":0}]
[{"$f":"HREC!A8","v":6},null,{"$f":"VLOOKUP(A8,HREC!$A$3:$S$341,2,FALSE)","v":0},{"$f":"VLOOKUP(A8,HREC!$A$3:$S$341,3,FALSE)","v":0},"2021-01-01","2021-12-31",1827,null,1827,{"$f":"VLOOKUP(A8,HREC!$A$3:$S$341,18,FALSE)","v":0}]
[{"$f":"HREC!A9","v":7},null,{"$f":"VLOOKUP(A9,HREC!$A$3:$S$341,2,FALSE)","v":0},{"$f":"VLOOKUP(A9,HREC!$A$3:$S$341,3,FALSE)","v":0},"2021-01-01","2021-12-31",1827,null,1827,{"$f":"VLOOKUP(A9,HREC!$A$3:$S$341,18,FALSE)","v":0}]
[{"$f":"HREC!A10","v":8},null,{"$f":"VLOOKUP(A10,HREC!$A$3:$S$341,2,FALSE)","v":0},{"$f":"VLOOKUP(A10,HREC!$A$3:$S$341,3,FALSE)","v":0},"2021-01-01","2021-12-31",1827,null,1827,{"$f":"VLOOKUP(A10,HREC!$A$3:$S$341,18,FALSE)","v":0}]
[{"$f":"HREC!A11","v":9},null,{"$f":"VLOOKUP(A11,HREC!$A$3:$S$341,2,FALSE)","v":0},{"$f":"VLOOKUP(A11,HREC!$A$3:$S$341,3,FALSE)","v":0},"2021-01-01","2021-12-31",1827,null,1827,{"$f":"VLOOKUP(A11,HREC!$A$3:$S$341,18,FALSE)","v":0}]
[{"$f":"HREC!A12","v":10},null,{"$f":"VLOOKUP(A12,HREC!$A$3:$S$341,2,FALSE)","v":0},{"$f":"VLOOKUP(A12,HREC!$A$3:$S$341,3,FALSE)","v":0},"2021-01-01","2021-12-31",1827,null,1827,{"$f":"VLOOKUP(A12,HREC!$A$3:$S$341,18,FALSE)","v":0}]
[{"$f":"HREC!A13","v":11},null,{"$f":"VLOOKUP(A13,HREC!$A$3:$S$341,2,FALSE)","v":0},{"$f":"VLOOKUP(A13,HREC!$A$3:$S$341,3,FALSE)","v":0},"2021-01-01","2021-12-31",1827,null,1827,{"$f":"VLOOKUP(A13,HREC!$A$3:$S$341,18,FALSE)","v":0}]
[{"$f":"HREC!A14","v":12},null,{"$f":"VLOOKUP(A14,HREC!$A$3:$S$341,2,FALSE)","v":0},{"$f":"VLOOKUP(A14,HREC!$A$3:$S$341,3,FALSE)","v":0},"2021-01-01","2021-12-31",1827,null,1827,{"$f":"VLOOKUP(A14,HREC!$A$3:$S$341,18,FALSE)","v":0}]
[{"$f":"HREC!A15","v":13},null,{"$f":"VLOOKUP(A15,HREC!$A$3:$S$341,2,FALSE)","v":0},{"$f":"VLOOKUP(A15,HREC!$A$3:$S$341,3,FALSE)","v":0},"2021-01-01","2021-12-31",1827,null,1827,{"$f":"VLOOKUP(A15,HREC!$A$3:$S$341,18,FALSE)","v":0}]
[{"$f":"HREC!A16","v":14},null,{"$f":"VLOOKUP(A16,HREC!$A$3:$S$341,2,FALSE)","v":0},{"$f":"VLOOKUP(A16,HREC!$A$3:$S$341,3,FALSE)","v":0},"2021-01-01","2021-12-31",1827,null,1827,{"$f":"VLOOKUP(A16,HREC!$A$3:$S$341,18,FALSE)","v":0}]
[{"$f":"HREC!A17","v":15},null,{"$f":"VLOOKUP(A17,HREC!$A$3:$S$341,2,FALSE)","v":0},{"$f":"VLOOKUP(A17,HREC!$A$3:$S$341,3,FALSE)","v":0},"2021-01-01","2021-12-31",1827,null,1827,{"$f":"VLOOKUP(A17,HREC!$A$3:$S$341,18,FALSE)","v":0}]
[{"$f":"HREC!A18","v":16},null,{"$f":"VLOOKUP(A18,HREC!$A$3:$S$341,2,FALSE)","v":0},{"$f":"VLOOKUP(A18,HREC!$A$3:$S$341,3,FALSE)","v":0},"2021-01-01","2021-12-31",1827,null,1827,{"$f":"VLOOKUP(A18,HREC!$A$3:$S$341,18,FALSE)","v":0}]
[{"$f":"HREC!A19","v":17},null,{"$f":"VLOOKUP(A19,HREC!$A$3:$S$341,2,FALSE)","v":0},{"$f":"VLOOKUP(A19,HREC!$A$3:$S$341,3,FALSE)","v":0},"2021-01-01","2021-12-31",1827,null,1827,{"$f":"VLOOKUP(A19,HREC!$A$3:$S$341,18,FALSE)","v":0}]
[{"$f":"HREC!A20","v":18},null,{"$f":"VLOOKUP(A20,HREC!$A$3:$S$341,2,FALSE)","v":0},{"$f":"VLOOKUP(A20,HREC!$A$3:$S$341,3,FALSE)","v":0},"2021-01-01","2021-12-31",1827,null,1827,{"$f":"VLOOKUP(A20,HREC!$A$3:$S$341,18,FALSE)","v":0}]
[{"$f":"HREC!A21","v":19},null,{"$f":"VLOOKUP(A21,HREC!$A$3:$S$341,2,FALSE)","v":0},{"$f":"VLOOKUP(A21,HREC!$A$3:$S$341,3,FALSE)","v":0},"2021-01-01","2021-12-31",1827,null,1827,{"$f":"VLOOKUP(A21,HREC!$A$3:$S$341,18,FALSE)","v":0}]
[{"$f":"HREC!A22","v":20},null,{"$f":"VLOOKUP(A22,HREC!$A$3:$S$341,2,FALSE)","v":0},{"$f":"VLOOKUP(A22,HREC!$A$3:$S$341,3,FALSE)","v":0},"2021-01-01","2021-12-31",1827,null,1827,{"$f":"VLOOKUP(A22,HREC!$A$3:$S$341,18,FALSE)","v":0}]
[{"$f":"HREC!A23","v":21},null,{"$f":"VLOOKUP(A23,HREC!$A$3:$S$341,2,FALSE)","v":0},{"$f":"VLOOKUP(A23,HREC!$A$3:$S$341,3,FALSE)","v":0},"2021-01-01","2021-12-31",1827,null,1827,{"$f":"VLOOKUP(A23,HREC!$A$3:$S$341,18,FALSE)","v":0}]
[{"$f":"HREC!A24","v":22},null,{"$f":"VLOOKUP(A24,HREC!$A$3:$S$341,2,FALSE)","v":0},{"$f":"VLOOKUP(A24,HREC!$A$3:$S$341,3,FALSE)","v":0},"2021-01-01","2021-12-31",1827,null,1827,{"$f":"VLOOKUP(A24,HREC!$A$3:$S$341,18,FALSE)","v":0}]
[{"$f":"HREC!A25","v":23},null,{"$f":"VLOOKUP(A25,HREC!$A$3:$S$341,2,FALSE)","v":0},{"$f":"VLOOKUP(A25,HREC!$A$3:$S$341,3,FALSE)","v":0},"2021-01-01","2021-12-31",1827,null,1827,{"$f":"VLOOKUP(A25,HREC!$A$3:$S$341,18,FALSE)","v":0}]
[{"$f":"HREC!A26","v":24},null,{"$f":"VLOOKUP(A26,HREC!$A$3:$S$341,2,FALSE)","v":0},{"$f":"VLOOKUP(A26,HREC!$A$3:$S$341,3,FALSE)","v":0},"2021-01-01","2021-12-31",1827,null,1827,{"$f":"VLOOKUP(A26,HREC!$A$3:$S$341,18,FALSE)","v":0}]
[{"$f":"HREC!A27","v":25},null,{"$f":"VLOOKUP(A27,HREC!$A$3:$S$341,2,FALSE)","v":0},{"$f":"VLOOKUP(A27,HREC!$A$3:$S$341,3,FALSE)","v":0},"2021-01-01","2021-12-31",1827,null,1827,{"$f":"VLOOKUP(A27,HREC!$A$3:$S$341,18,FALSE)","v":0}]
[{"$f":"HREC!A28","v":26},null,{"$f":"VLOOKUP(A28,HREC!$A$3:$S$341,2,FALSE)","v":0},{"$f":"VLOOKUP(A28,HREC!$A$3:$S$341,3,FALSE)","v":0},"2021-01-01","2021-12-31",1827,null,1827,{"$f":"VLOOKUP(A28,HREC!$A$3:$S$341,18,FALSE)","v":0}]
[{"$f":"HREC!A29","v":27},null,{"$f":"VLOOKUP(A29,HREC!$A$3:$S$341,2,FALSE)","v":0},{"$f":"VLOOKUP(A29,HREC!$A$3:$S$341,3,FALSE)","v":0},"2021-01-01","2021-12-31",1827,null,1827,{"$f":"VLOOKUP(A29,HREC!$A$3:$S$341,18,FALSE)","v":0}]
[{"$f":"HREC!A30","v":28},null,{"$f":"VLOOKUP(A30,HREC!$A$3:$S$341,2,FALSE)","v":0},{"$f":"VLOOKUP(A30,HREC!$A$3:$S$341,3,FALSE)","v":0},"2021-01-01","2021-12-31",1827,null,1827,{"$f":"VLOOKUP(A30,HREC!$A$3:$S$341,18,FALSE)","v":0}]
[{"$f":"HREC!A31","v":29},null,{"$f":"VLOOKUP(A31,HREC!$A$3:$S$341,2,FALSE)","v":0},{"$f":"VLOOKUP(A31,HREC!$A$3:$S$341,3,FALSE)","v":0},"2021-01-01","2021-12-31",1827,null,1827,{"$f":"VLOOKUP(A31,HREC!$A$3:$S$341,18,FALSE)","v":0}]
[{"$f":"HREC!A32","v":30},null,{"$f":"VLOOKUP(A32,HREC!$A$3:$S$341,2,FALSE)","v":0},{"$f":"VLOOKUP(A32,HREC!$A$3:$S$341,3,FALSE)","v":0},"2021-01-01","2021-12-31",1827,null,1827,{"$f":"VLOOKUP(A32,HREC!$A$3:$S$341,18,FALSE)","v":0}]
[{"$f":"HREC!A33","v":31},null,{"$f":"VLOOKUP(A33,HREC!$A$3:$S$341,2,FALSE)","v":0},{"$f":"VLOOKUP(A33,HREC!$A$3:$S$341,3,FALSE)","v":0},"2021-01-01","2021-12-31",1827,null,1827,{"$f":"VLOOKUP(A33,HREC!$A$3:$S$341,18,FALSE)","v":0}]
[{"$f":"HREC!A34","v":32},null,{"$f":"VLOOKUP(A34,HREC!$A$3:$S$341,2,FALSE)","v":0},{"$f":"VLOOKUP(A34,HREC!$A$3:$S$341,3,FALSE)","v":0},"2021-01-01","2021-12-31",1827,null,1827,{"$f":"VLOOKUP(A34,HREC!$A$3:$S$341,18,FALSE)","v":0}]
[{"$f":"HREC!A35","v":33},null,{"$f":"VLOOKUP(A35,HREC!$A$3:$S$341,2,FALSE)","v":0},{"$f":"VLOOKUP(A35,HREC!$A$3:$S$341,3,FALSE)","v":0},"2021-01-01","2021-12-31",{"$f":"IF($A$1=\"HEURES\",NETWORKDAYS(E35,F35,$A$66:$A$74)*$D$1,NETWORKDAYS(E35,F35,$A$66:$A$74))","v":1827},null,{"$f":"G35-H35","v":1827},{"$f":"VLOOKUP(A35,HREC!$A$3:$S$341,18,FALSE)","v":0}]
[{"$f":"HREC!A36","v":34},null,{"$f":"VLOOKUP(A36,HREC!$A$3:$S$341,2,FALSE)","v":0},{"$f":"VLOOKUP(A36,HREC!$A$3:$S$341,3,FALSE)","v":0},"2021-01-01","2021-12-31",1827,null,1827,{"$f":"VLOOKUP(A36,HREC!$A$3:$S$341,18,FALSE)","v":0}]
[{"$f":"HREC!A37","v":35},null,{"$f":"VLOOKUP(A37,HREC!$A$3:$S$341,2,FALSE)","v":0},{"$f":"VLOOKUP(A37,HREC!$A$3:$S$341,3,FALSE)","v":0},"2021-01-01","2021-12-31",1827,null,1827,{"$f":"VLOOKUP(A37,HREC!$A$3:$S$341,18,FALSE)","v":0}]
[{"$f":"HREC!A38","v":36},null,{"$f":"VLOOKUP(A38,HREC!$A$3:$S$341,2,FALSE)","v":0},{"$f":"VLOOKUP(A38,HREC!$A$3:$S$341,3,FALSE)","v":0},"2021-01-01","2021-12-31",1827,null,1827,{"$f":"VLOOKUP(A38,HREC!$A$3:$S$341,18,FALSE)","v":0}]
[{"$f":"HREC!A39","v":37},null,{"$f":"VLOOKUP(A39,HREC!$A$3:$S$341,2,FALSE)","v":0},{"$f":"VLOOKUP(A39,HREC!$A$3:$S$341,3,FALSE)","v":0},"2021-01-01","2021-12-31",1827,null,1827,{"$f":"VLOOKUP(A39,HREC!$A$3:$S$341,18,FALSE)","v":0}]
[{"$f":"HREC!A40","v":38},null,{"$f":"VLOOKUP(A40,HREC!$A$3:$S$341,2,FALSE)","v":0},{"$f":"VLOOKUP(A40,HREC!$A$3:$S$341,3,FALSE)","v":0},"2021-01-01","2021-12-31",1827,null,1827,{"$f":"VLOOKUP(A40,HREC!$A$3:$S$341,18,FALSE)","v":0}]
[{"$f":"HREC!A41","v":39},null,{"$f":"VLOOKUP(A41,HREC!$A$3:$S$341,2,FALSE)","v":0},{"$f":"VLOOKUP(A41,HREC!$A$3:$S$341,3,FALSE)","v":0},"2021-01-01","2021-12-31",1827,null,1827,{"$f":"VLOOKUP(A41,HREC!$A$3:$S$341,18,FALSE)","v":0}]
[{"$f":"HREC!A42","v":40},null,{"$f":"VLOOKUP(A42,HREC!$A$3:$S$341,2,FALSE)","v":0},{"$f":"VLOOKUP(A42,HREC!$A$3:$S$341,3,FALSE)","v":0},"2021-01-01","2021-12-31",1827,null,1827,{"$f":"VLOOKUP(A42,HREC!$A$3:$S$341,18,FALSE)","v":0}]
[{"$f":"HREC!A43","v":41},null,{"$f":"VLOOKUP(A43,HREC!$A$3:$S$341,2,FALSE)","v":0},{"$f":"VLOOKUP(A43,HREC!$A$3:$S$341,3,FALSE)","v":0},"2021-01-01","2021-12-31",1827,null,1827,{"$f":"VLOOKUP(A43,HREC!$A$3:$S$341,18,FALSE)","v":0}]
[{"$f":"HREC!A44","v":42},null,{"$f":"VLOOKUP(A44,HREC!$A$3:$S$341,2,FALSE)","v":0},{"$f":"VLOOKUP(A44,HREC!$A$3:$S$341,3,FALSE)","v":0},"2021-01-01","2021-12-31",1827,null,1827,{"$f":"VLOOKUP(A44,HREC!$A$3:$S$341,18,FALSE)","v":0}]
[{"$f":"HREC!A45","v":43},null,{"$f":"VLOOKUP(A45,HREC!$A$3:$S$341,2,FALSE)","v":0},{"$f":"VLOOKUP(A45,HREC!$A$3:$S$341,3,FALSE)","v":0},"2021-01-01","2021-12-31",1827,null,1827,{"$f":"VLOOKUP(A45,HREC!$A$3:$S$341,18,FALSE)","v":0}]
[{"$f":"HREC!A46","v":44},null,{"$f":"VLOOKUP(A46,HREC!$A$3:$S$341,2,FALSE)","v":0},{"$f":"VLOOKUP(A46,HREC!$A$3:$S$341,3,FALSE)","v":0},"2021-01-01","2021-12-31",1827,null,1827,{"$f":"VLOOKUP(A46,HREC!$A$3:$S$341,18,FALSE)","v":0}]
[{"$f":"HREC!A47","v":45},null,{"$f":"VLOOKUP(A47,HREC!$A$3:$S$341,2,FALSE)","v":0},{"$f":"VLOOKUP(A47,HREC!$A$3:$S$341,3,FALSE)","v":0},"2021-01-01","2021-12-31",1827,null,1827,{"$f":"VLOOKUP(A47,HREC!$A$3:$S$341,18,FALSE)","v":0}]
[{"$f":"HREC!A48","v":46},null,{"$f":"VLOOKUP(A48,HREC!$A$3:$S$341,2,FALSE)","v":0},{"$f":"VLOOKUP(A48,HREC!$A$3:$S$341,3,FALSE)","v":0},"2021-01-01","2021-12-31",1827,null,1827,{"$f":"VLOOKUP(A48,HREC!$A$3:$S$341,18,FALSE)","v":0}]
[{"$f":"HREC!A49","v":47},null,{"$f":"VLOOKUP(A49,HREC!$A$3:$S$341,2,FALSE)","v":0},{"$f":"VLOOKUP(A49,HREC!$A$3:$S$341,3,FALSE)","v":0},"2021-01-01","2021-12-31",1827,null,1827,{"$f":"VLOOKUP(A49,HREC!$A$3:$S$341,18,FALSE)","v":0}]
[{"$f":"HREC!A50","v":48},null,{"$f":"VLOOKUP(A50,HREC!$A$3:$S$341,2,FALSE)","v":0},{"$f":"VLOOKUP(A50,HREC!$A$3:$S$341,3,FALSE)","v":0},"2021-01-01","2021-12-31",1827,null,1827,{"$f":"VLOOKUP(A50,HREC!$A$3:$S$341,18,FALSE)","v":0}]
[{"$f":"HREC!A51","v":49},null,{"$f":"VLOOKUP(A51,HREC!$A$3:$S$341,2,FALSE)","v":0},{"$f":"VLOOKUP(A51,HREC!$A$3:$S$341,3,FALSE)","v":0},"2021-01-01","2021-12-31",1827,null,1827,{"$f":"VLOOKUP(A51,HREC!$A$3:$S$341,18,FALSE)","v":0}]
[{"$f":"HREC!A52","v":50},null,{"$f":"VLOOKUP(A52,HREC!$A$3:$S$341,2,FALSE)","v":0},{"$f":"VLOOKUP(A52,HREC!$A$3:$S$341,3,FALSE)","v":0},"2021-01-01","2021-12-31",1827,null,1827,{"$f":"VLOOKUP(A52,HREC!$A$3:$S$341,18,FALSE)","v":0}]
["ZZZ",null,"ZZZ","TOTAUX","ZZZ","ZZZ",{"$f":"SUBTOTAL(9,G3:G52)","v":91350},null,{"$f":"SUBTOTAL(9,I3:I52)","v":91350},{"$f":"SUM(J3:J52)","v":600}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["2020-01-01","Jour de l'An"]
["2020-04-13","Lundi de Pâques"]
["2020-05-01","Fête du Travail"]
["2020-05-08","Victoire 1945"]
["2020-05-21","Ascension"]
["2020-06-01","Lundi de Pentecôte"]
["2020-07-14","Fête nationale"]
["2020-11-11","Armistice 1918"]
["2020-12-25","Noël"]

{"sheet":"Initialise","index":2,"n_rows":10,"n_cols":22,"rows_kept":10,"cut":false,"hidden":true,"merged":[]}
[]
["n° ligne","Matricule","Site","Jeune docteur","Nom","Prénom","Opération 1","Opération 2","Opération 3","Opération 4","Opération 5","Total heures affectées\n aux phases éligibles \ndes projets de R&D","Taux d'éligibilité \ninitial CIR %",null,"Pour HRECH",null,null,"Heures de Recherche par niveau de risque"]
[null,null,null,null,null,null,"Site/BU a","Site/BU b","Site/BU c","Site/BU a","Site/BU b",null,null,null,"Pour HRECH"]
[null,null,null,null,null,null,0,1,2,3,4,null,{"$f":" MATCH($M$2,PERS!2:2,0)-1","v":{"$error":"#N/A"}},null,"Pour HRECH",null,"Eligibilité personne",0,1,2,3,4]
[10,10,null,"Non","Nouv-Nom","jjj",null,0,0,0,null,{"$f":"SUM(G5:K5)","v":0},{"$f":"IF(ISERROR(VLOOKUP($B5,PERS!#REF!,$M$4,FALSE)),0,VLOOKUP($B5,PERS!#REF!,$M$4,FALSE))","v":0},null,null,null,{"$f":"PERS!#REF!","v":{"$error":"#REF!"}},{"$f":"SUMIFS($G5:$K5,$G$4:$K$4,\"<1\")","v":0},{"$f":"SUMIFS($G5:$K5,$G$4:$K$4,\"<2\",$G$4:$K$4,\">0\")","v":0},{"$f":"SUMIFS($G5:$K5,$G$4:$K$4,\"<3\",$G$4:$K$4,\">1\")","v":0},{"$f":"SUMIFS($G5:$K5,$G$4:$K$4,\"<4\",$G$4:$K$4,\">2\")","v":0},{"$f":"SUMIFS($G5:$K5,$G$4:$K$4,\">3\")","v":0}]
[]
[]
[]
[]
[null,"A renseigner"]