{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Absence","IJ","TCD"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":2,"comments":0,"pivot_tables":1},"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":"Absence","index":0,"n_rows":39,"n_cols":17,"rows_kept":39,"cut":false,"hidden":false,"merged":[]}
["Agent","Site","Motif","Type","Date de début d'absence","Date de fin d'absence","Etat actuel",null,"c1","Abs_Date_DEB_P","c2","Abs_Date_FIN_P","NB Jrs","M\nD","A\nD","M\nF","A\nF"]
["TITI",null,"Maladie (préciser si lien avec état pathologique)","Initial","2019040202/04/2019","2019040202/04/2019","En attente de validation AC",null,{"$f":"MID(E2,9,10)","v":"02/04/2019"},{"$f":"DATE(RIGHT(I2,4),MID(I2,4,2),LEFT(I2,2))","v":"2019-04-02"},{"$f":"MID(F2,9,10)","v":"02/04/2019"},{"$f":"DATE(RIGHT(K2,4),MID(K2,4,2),LEFT(K2,2))","v":"2019-04-02"},{"$f":"DATEDIF(J2,L2,\"d\")+1","v":1},{"$f":"MONTH(J2)","v":4},{"$f":"YEAR(J2)","v":2019},{"$f":"MONTH(L2)","v":4},{"$f":"YEAR(L2)","v":2019}]
["TOTO",null,"Temps partiel thérapeutique","Prolongation","2018120303/12/2018","2019020303/02/2019","Validé par l'agence comptable",null,"03/12/2018","2018-12-03","03/02/2019","2019-02-03",63,12,2018,2,2019]
["TOTO",null,"Temps partiel thérapeutique","Prolongation","2019012121/01/2019","2019033131/03/2019","Validé par l'agence comptable",null,"21/01/2019","2019-01-21","31/03/2019","2019-03-31",70,1,2019,3,2019]
["TOTO",null,"Temps partiel thérapeutique","Prolongation","2019032727/03/2019","2019060202/06/2019","En attente de validation AC",null,"27/03/2019","2019-03-27","02/06/2019","2019-06-02",68,3,2019,6,2019]
["TOTO",null,"Temps partiel thérapeutique","Prolongation","2019052020/05/2019","2019090101/09/2019","En attente de validation AC",null,"20/05/2019","2019-05-20","01/09/2019","2019-09-01",105,5,2019,9,2019]
["TOTO",null,"Temps partiel thérapeutique","Prolongation","2019090101/09/2019","2019100505/10/2019","En attente de validation AC",null,"01/09/2019","2019-09-01","05/10/2019","2019-10-05",35,9,2019,10,2019]
["TOTO",null,"Temps partiel thérapeutique","Prolongation","2019093030/09/2019","2019113030/11/2019","En attente de validation AC",null,"30/09/2019","2019-09-30","30/11/2019","2019-11-30",62,9,2019,11,2019]
["TUTU",null,"Maladie (préciser si lien avec état pathologique)","Prolongation","2018120404/12/2018","2019010606/01/2019","Validé par l'agence comptable",null,"04/12/2018","2018-12-04","06/01/2019","2019-01-06",34,12,2018,1,2019]
["TUTU",null,"Maladie (préciser si lien avec état pathologique)","Prolongation","2019010404/01/2019","2019011111/01/2019","Validé par l'agence comptable",null,"04/01/2019","2019-01-04","11/01/2019","2019-01-11",8,1,2019,1,2019]
["TUTU",null,"Maladie (préciser si lien avec état pathologique)","Prolongation","2019011111/01/2019","2019012020/01/2019","Validé par l'agence comptable",null,"11/01/2019","2019-01-11","20/01/2019","2019-01-20",10,1,2019,1,2019]
["TUTU",null,"Temps partiel thérapeutique","Initial","2019012121/01/2019","2019022121/02/2019","Validé par l'agence comptable",null,"21/01/2019","2019-01-21","21/02/2019","2019-02-21",32,1,2019,2,2019]
["TUTU",null,"Temps partiel thérapeutique","Prolongation","2019022121/02/2019","2019032929/03/2019","En attente de validation AC",null,"21/02/2019","2019-02-21","29/03/2019","2019-03-29",37,2,2019,3,2019]
["TUTU",null,"Temps partiel thérapeutique","Prolongation","2019033030/03/2019","2019053131/05/2019","En attente de validation AC",null,"30/03/2019","2019-03-30","31/05/2019","2019-05-31",63,3,2019,5,2019]
["TUTU",null,"Temps partiel thérapeutique","Prolongation","2019052424/05/2019","2019083131/08/2019","En attente de validation AC",null,"24/05/2019","2019-05-24","31/08/2019","2019-08-31",100,5,2019,8,2019]
["TUTU",null,"Temps partiel thérapeutique","Prolongation","2019091616/09/2019","2019113030/11/2019","Validé par l'agence comptable",null,"16/09/2019","2019-09-16","30/11/2019","2019-11-30",76,9,2019,11,2019]
["TUTU",null,"Temps partiel thérapeutique","Prolongation","2019082626/08/2019","2019091515/09/2019","Validé par l'agence comptable",null,"26/08/2019","2019-08-26","15/09/2019","2019-09-15",21,8,2019,9,2019]
["TUTU",null,"Maladie","Initial","2019100101/10/2019","2019110707/11/2019","Validé par l'agence comptable",null,"01/10/2019","2019-10-01","07/11/2019","2019-11-07",38,10,2019,11,2019]
["AA",null,"Maladie (préciser si lien avec état pathologique)","Initial","2019041616/04/2019","2019041717/04/2019","En attente de validation AC",null,"16/04/2019","2019-04-16","17/04/2019","2019-04-17",2,4,2019,4,2019]
["AA",null,"Maladie (préciser si lien avec état pathologique)","Prolongation","2019041919/04/2019","2019050808/05/2019","En attente de validation AC",null,"19/04/2019","2019-04-19","08/05/2019","2019-05-08",20,4,2019,5,2019]
["AA",null,"Maladie (préciser si lien avec état pathologique)","Prolongation","2019050606/05/2019","2019052424/05/2019","En attente de validation AC",null,"06/05/2019","2019-05-06","24/05/2019","2019-05-24",19,5,2019,5,2019]
["AA",null,"Maladie (préciser si lien avec état pathologique)","Prolongation","2019052020/05/2019","2019060202/06/2019","En attente de validation AC",null,"20/05/2019","2019-05-20","02/06/2019","2019-06-02",14,5,2019,6,2019]
["AA",null,"Maladie (préciser si lien avec état pathologique)","Initial","2019060505/06/2019","2019061616/06/2019","En attente de validation AC",null,"05/06/2019","2019-06-05","16/06/2019","2019-06-16",12,6,2019,6,2019]
["AB",null,"Maladie (préciser si lien avec état pathologique)","Initial","2019011414/01/2019","2019011818/01/2019","En attente de validation AC",null,"14/01/2019","2019-01-14","18/01/2019","2019-01-18",5,1,2019,1,2019]
["AC",null,"Maladie (préciser si lien avec état pathologique)","Initial","2019031313/03/2019","2019031515/03/2019","En attente de validation AC",null,"13/03/2019","2019-03-13","15/03/2019","2019-03-15",3,3,2019,3,2019]
["AC",null,"Maladie (préciser si lien avec état pathologique)","Initial","2019061111/06/2019","2019061414/06/2019","En attente de validation AC",null,"11/06/2019","2019-06-11","14/06/2019","2019-06-14",4,6,2019,6,2019]
["AD",null,"Temps partiel thérapeutique","Initial","2019030404/03/2019","2019041212/04/2019","Validé par l'agence comptable",null,"04/03/2019","2019-03-04","12/04/2019","2019-04-12",40,3,2019,4,2019]
["AD",null,"Temps partiel thérapeutique","Prolongation","2019041111/04/2019","2019051717/05/2019","En attente de validation AC",null,"11/04/2019","2019-04-11","17/05/2019","2019-05-17",37,4,2019,5,2019]
["AD",null,"Temps partiel thérapeutique","Prolongation","2019051717/05/2019","2019052828/05/2019","En attente de validation AC",null,"17/05/2019","2019-05-17","28/05/2019","2019-05-28",12,5,2019,5,2019]
["AD",null,"Temps partiel thérapeutique","Prolongation","2019051717/05/2019","2019062828/06/2019","En attente de validation AC",null,"17/05/2019","2019-05-17","28/06/2019","2019-06-28",43,5,2019,6,2019]
["AD",null,"Temps partiel thérapeutique","Prolongation","2019062626/06/2019","2019090101/09/2019","En attente de validation AC",null,"26/06/2019","2019-06-26","01/09/2019","2019-09-01",68,6,2019,9,2019]
["AD",null,"Temps partiel thérapeutique","Prolongation","2019090202/09/2019","2019092929/09/2019","Validé par l'agence comptable",null,"02/09/2019","2019-09-02","29/09/2019","2019-09-29",28,9,2019,9,2019]
["AD",null,"Temps partiel thérapeutique","Prolongation","2019093030/09/2019","2019103131/10/2019","Validé par l'agence comptable",null,"30/09/2019","2019-09-30","31/10/2019","2019-10-31",32,9,2019,10,2019]
["AE",null,"Maladie (préciser si lien avec état pathologique)","Initial","2019022727/02/2019","2019030101/03/2019","En attente de validation AC",null,"27/02/2019","2019-02-27","01/03/2019","2019-03-01",3,2,2019,3,2019]
["AE",null,"Maladie (préciser si lien avec état pathologique)","Initial","2019041616/04/2019","2019041919/04/2019","En attente de validation AC",null,"16/04/2019","2019-04-16","19/04/2019","2019-04-19",4,4,2019,4,2019]
["AE",null,"Maladie (préciser si lien avec état pathologique)","Initial","2019072929/07/2019","2019080202/08/2019","En attente de validation AC",null,"29/07/2019","2019-07-29","02/08/2019","2019-08-02",5,7,2019,8,2019]
["AE",null,"Maladie","Prolongation","2019080202/08/2019","2019080808/08/2019","En attente de validation AC",null,"02/08/2019","2019-08-02","08/08/2019","2019-08-08",7,8,2019,8,2019]
["AE",null,"Maladie","Prolongation","2019080808/08/2019","2019081313/08/2019","En attente de validation AC",null,"08/08/2019","2019-08-08","13/08/2019","2019-08-13",6,8,2019,8,2019]
["AE",null,"Maladie","Initial","2019091919/09/2019","2019092020/09/2019","En attente de validation AC",null,"19/09/2019","2019-09-19","20/09/2019","2019-09-20",2,9,2019,9,2019]

{"sheet":"IJ","index":1,"n_rows":100,"n_cols":25,"rows_kept":100,"cut":false,"hidden":false,"merged":[]}
["Agent","Nom","Date de Paiement","Date comptable","Salarié",null,"Date de début","Date de fin","Nature","NB jours","Prix unitaire","Mtt de la prestation","Assurance","num agent","Service","Code affectation spe",null,"IJ_Date_DEB_P","IJ_Date_FIN_P","NB Jrs","I.J.\nOui-Non","M\nD","A\nD","M\nF","A\nF"]
["TITI",null,"26 04 2019",null,null,null,"02 04 2019","02 04 2019","CARENCE",1,null,null,"AS",null,null,null,null,{"$f":"IF(G2<>\"  \",DATE(RIGHT(G2,4),MID(G2,4,2),LEFT(G2,2)),\"\")","v":"2019-04-02"},{"$f":"DATE(RIGHT(H2,4),MID(H2,4,2),LEFT(H2,2))","v":"2019-04-02"},{"$f":"IF(AND(R2=\"\",U2=0),0,DATEDIF(R2,S2,\"d\")+1)","v":1},{"$f":"SUM(IF(OR(LEFT(I2,4)=\"I.J.\",LEFT(I2,4)=\"CARE\"),1,0))","v":1},{"$f":"IF($R2<>\"\",MONTH(R2),\"\")","v":4},{"$f":"IF($R2<>\"\",YEAR(R2),\"\")","v":2019},{"$f":"IF($S2<>\"\",MONTH(S2),\"\")","v":4},{"$f":"IF($S2<>\"\",YEAR(S2),\"\")","v":2019}]
["TOTO",null,"16 10 2019",null,null,null,"01 09 2019","01 09 2019","I.J. MI-TEMPS",1,null,null,"AT",null,null,null,null,"2019-09-01","2019-09-01",1,1,{"$f":"IF($R3<>\"\",MONTH(R3),\"\")","v":9},{"$f":"IF($R3<>\"\",YEAR(R3),\"\")","v":2019},{"$f":"IF($S3<>\"\",MONTH(S3),\"\")","v":9},{"$f":"IF($S3<>\"\",YEAR(S3),\"\")","v":2019}]
["TOTO",null,"16 10 2019",null,null,null,"02 09 2019","30 09 2019","I.J. MI-TEMPS",29,null,null,"AT",null,null,null,null,"2019-09-02","2019-09-30",29,1,9,2019,9,2019]
["TOTO",null,"16 10 2019",null,null,null,"01 08 2019","31 08 2019","I.J. MI-TEMPS",31,null,null,"AT",null,null,null,null,"2019-08-01","2019-08-31",31,1,8,2019,8,2019]
["TOTO",null,"28 01 2019",null,null,null,"05 11 2018","30 11 2018","I.J. MI-TEMPS",26,null,null,"AT",null,null,null,null,"2018-11-05","2018-11-30",26,1,11,2018,11,2018]
["TOTO",null,"28 01 2019",null,null,null,"01 12 2018","31 12 2018","I.J. MI-TEMPS",31,null,null,"AT",null,null,null,null,"2018-12-01","2018-12-31",31,1,12,2018,12,2018]
["TOTO",null,"05 08 2019",null,null,null,"01 04 2019","30 04 2019","I.J. MI-TEMPS",30,null,null,"AT",null,null,null,null,"2019-04-01","2019-04-30",30,1,4,2019,4,2019]
["TOTO",null,"05 08 2019",null,null,null,"01 05 2019","31 05 2019","I.J. MI-TEMPS",31,null,null,"AT",null,null,null,null,"2019-05-01","2019-05-31",31,1,5,2019,5,2019]
["TOTO",null,"05 08 2019",null,null,null,"01 06 2019","02 06 2019","I.J. MI-TEMPS",2,null,null,"AT",null,null,null,null,"2019-06-01","2019-06-02",2,1,6,2019,6,2019]
["TOTO",null,"05 08 2019",null,null,null,"03 06 2019","30 06 2019","I.J. MI-TEMPS",28,null,null,"AT",null,null,null,null,"2019-06-03","2019-06-30",28,1,6,2019,6,2019]
["TOTO",null,"20 08 2019",null,null,null,"01 07 2019","31 07 2019","I.J. MI-TEMPS",31,null,null,"AT",null,null,null,null,"2019-07-01","2019-07-31",31,1,7,2019,7,2019]
["TOTO",null,"23 04 2019",null,null,null,"01 01 2019","20 01 2019","I.J. MI-TEMPS",20,null,null,"AT",null,null,null,null,"2019-01-01","2019-01-20",20,1,1,2019,1,2019]
["TOTO",null,"23 04 2019",null,null,null,"21 01 2019","31 01 2019","I.J. MI-TEMPS",11,null,null,"AT",null,null,null,null,"2019-01-21","2019-01-31",11,1,1,2019,1,2019]
["TOTO",null,"23 04 2019",null,null,null,"01 02 2019","03 02 2019","I.J. MI-TEMPS",3,null,null,"AT",null,null,null,null,"2019-02-01","2019-02-03",3,1,2,2019,2,2019]
["TOTO",null,"23 04 2019",null,null,null,"04 02 2019","04 02 2019","I.J. MI-TEMPS",1,null,null,"AT",null,null,null,null,"2019-02-04","2019-02-04",1,1,2,2019,2,2019]
["TOTO",null,"23 04 2019",null,null,null,"05 02 2019","28 02 2019","I.J. MI-TEMPS",24,null,null,"AT",null,null,null,null,"2019-02-05","2019-02-28",24,1,2,2019,2,2019]
["TOTO",null,"23 04 2019",null,null,null,"01 03 2019","31 03 2019","I.J. MI-TEMPS",31,null,null,"AT",null,null,null,null,"2019-03-01","2019-03-31",31,1,3,2019,3,2019]
["TUTU",null,"18 09 2019",null,null,null,"01 08 2019","31 08 2019","I.J. MI-TEMPS",31,null,null,"AS",null,null,null,null,"2019-08-01","2019-08-31",31,1,8,2019,8,2019]
["TUTU",null,"16 08 2019",null,null,null,"01 07 2019","31 07 2019","I.J. MI-TEMPS",31,null,null,"AS",null,null,null,null,"2019-07-01","2019-07-31",31,1,7,2019,7,2019]
["TUTU",null,"21 06 2019",null,null,null,"01 04 2019","20 04 2019","I.J. MI-TEMPS",20,null,null,"AS",null,null,null,null,"2019-04-01","2019-04-20",20,1,4,2019,4,2019]
["TUTU",null,"21 06 2019",null,null,null,"21 04 2019","30 04 2019","I.J. MI-TEMPS",10,null,null,"AS",null,null,null,null,"2019-04-21","2019-04-30",10,1,4,2019,4,2019]
["TUTU",null,"21 06 2019",null,null,null,"01 05 2019","31 05 2019","I.J. MI-TEMPS",31,null,null,"AS",null,null,null,null,"2019-05-01","2019-05-31",31,1,5,2019,5,2019]
["TUTU",null,"16 07 2019",null,null,null,"01 06 2019","30 06 2019","I.J. MI-TEMPS",30,null,null,"AS",null,null,null,null,"2019-06-01","2019-06-30",30,1,6,2019,6,2019]
["TUTU",null,"14 05 2019",null,null,null,"01 03 2019","31 03 2019","I.J. MI-TEMPS",31,null,null,"AS",null,null,null,null,"2019-03-01","2019-03-31",31,1,3,2019,3,2019]
["TUTU",null,"29 03 2019",null,null,null,"21 01 2019","31 01 2019","I.J. MI-TEMPS",11,null,null,"AS",null,null,null,null,"2019-01-21","2019-01-31",11,1,1,2019,1,2019]
["TUTU",null,"29 03 2019",null,null,null,"01 02 2019","21 02 2019","I.J. MI-TEMPS",21,null,null,"AS",null,null,null,null,"2019-02-01","2019-02-21",21,1,2,2019,2,2019]
["TUTU",null,"29 03 2019",null,null,null,"22 02 2019","28 02 2019","I.J. MI-TEMPS",7,null,null,"AS",null,null,null,null,"2019-02-22","2019-02-28",7,1,2,2019,2,2019]
["TUTU",null,"07 01 2019",null,null,null,"22 12 2018","31 12 2018","I.J. NORMALES",10,null,null,"AS",null,null,null,null,"2018-12-22","2018-12-31",10,1,12,2018,12,2018]
["TUTU",null,"07 01 2019",null,null,null,"01 01 2019","04 01 2019","I.J. NORMALES",4,null,null,"AS",null,null,null,null,"2019-01-01","2019-01-04",4,1,1,2019,1,2019]
["TUTU",null,"17 01 2019",null,null,null,"05 01 2019","06 01 2019","I.J. NORMALES",2,null,null,"AS",null,null,null,null,"2019-01-05","2019-01-06",2,1,1,2019,1,2019]
["TUTU",null,"17 01 2019",null,null,null,"07 01 2019","11 01 2019","I.J. NORMALES",5,null,null,"AS",null,null,null,null,"2019-01-07","2019-01-11",5,1,1,2019,1,2019]
["TUTU",null,"17 01 2019",null,null,null,"12 01 2019","15 01 2019","I.J. NORMALES",4,null,null,"AS",null,null,null,null,"2019-01-12","2019-01-15",4,1,1,2019,1,2019]
["TUTU",null,"29 03 2019",null,null,null,"16 01 2019","20 01 2019","I.J. NORMALES",5,null,null,"AS",null,null,null,null,{"$f":"IF(G34<>\"  \",DATE(RIGHT(G34,4),MID(G34,4,2),LEFT(G34,2)),\"\")","v":"2019-01-16"},{"$f":"DATE(RIGHT(H34,4),MID(H34,4,2),LEFT(H34,2))","v":"2019-01-20"},{"$f":"IF(AND(R34=\"\",U34=0),0,DATEDIF(R34,S34,\"d\")+1)","v":5},1,1,2019,1,2019]
["AA",null,"01 07 2019",null,null,null,"05 06 2019","07 06 2019","CARENCE",3,null,null,"AS",null,null,null,null,"2019-06-05","2019-06-07",3,1,6,2019,6,2019]
["AA",null,"07 05 2019",null,null,null,"16 04 2019","17 04 2019","CARENCE",2,null,null,"AS",null,null,null,null,"2019-04-16","2019-04-17",2,1,4,2019,4,2019]
["AA",null,"07 05 2019",null,null,null,"18 04 2019","18 04 2019","CARENCE",1,null,null,"AS",null,null,null,null,"2019-04-18","2019-04-18",1,1,4,2019,4,2019]
["AA",null,"01 07 2019",null,null,null,"08 06 2019","16 06 2019","I.J. NORMALES",9,null,null,"AS",null,null,null,null,"2019-06-08","2019-06-16",9,1,6,2019,6,2019]
["AA",null,"27 05 2019",null,null,null,"11 05 2019","24 05 2019","I.J. NORMALES",14,null,null,"AS",null,null,null,null,"2019-05-11","2019-05-24",14,1,5,2019,5,2019]
["AA",null,"11 06 2019",null,null,null,"25 05 2019","02 06 2019","I.J. NORMALES",9,null,null,"AS",null,null,null,null,"2019-05-25","2019-06-02",9,1,5,2019,6,2019]
["AA",null,"07 05 2019",null,null,null,"19 04 2019","03 05 2019","I.J. NORMALES",15,null,null,"AS",null,null,null,null,"2019-04-19","2019-05-03",15,1,4,2019,5,2019]
["AA",null,"09 05 2019",null,null,null,"04 05 2019","04 05 2019","I.J. NORMALES",1,null,null,"AS",null,null,null,null,"2019-05-04","2019-05-04",1,1,5,2019,5,2019]
["AA",null,"14 05 2019",null,null,null,"05 05 2019","08 05 2019","I.J. NORMALES",4,null,null,"AS",null,null,null,null,"2019-05-05","2019-05-08",4,1,5,2019,5,2019]
["AA",null,"14 05 2019",null,null,null,"09 05 2019","10 05 2019","I.J. NORMALES",2,null,null,"AS",null,null,null,null,"2019-05-09","2019-05-10",2,1,5,2019,5,2019]
["AB",null,"29 01 2019",null,null,null,"14 01 2019","16 01 2019","CARENCE",3,null,null,"AS",null,null,null,null,"2019-01-14","2019-01-16",3,1,1,2019,1,2019]
["AB",null,"29 01 2019",null,null,null,"17 01 2019","18 01 2019","I.J. NORMALES",2,null,null,"AS",null,null,null,null,"2019-01-17","2019-01-18",2,1,1,2019,1,2019]
["AC",null,"02 07 2019",null,null,null,"11 06 2019","13 06 2019","CARENCE",3,null,null,"AS",null,null,null,null,"2019-06-11","2019-06-13",3,1,6,2019,6,2019]
["AC",null,"04 04 2019",null,null,null,"14 03 2019","15 03 2019","CARENCE",2,null,null,"AS",null,null,null,null,"2019-03-14","2019-03-15",2,1,3,2019,3,2019]
["AC",null,"02 07 2019",null,null,null,"14 06 2019","14 06 2019","I.J. NORMALES",1,null,null,"AS",null,null,null,null,"2019-06-14","2019-06-14",1,1,6,2019,6,2019]
["AD",null,"13 05 2019",null,null,null,"28 05 2018","30 05 2018","CARENCE",3,null,null,"AS",null,null,null,null,"2018-05-28","2018-05-30",3,1,5,2018,5,2018]
["AD",null,"13 05 2019",null,null,null,"28 05 2018","30 05 2018","CARENCE",3,null,null,"AS",null,null,null,null,"2018-05-28","2018-05-30",3,1,5,2018,5,2018]
["AD",null,"08 10 2019",null,null,null,"01 09 2019","01 09 2019","I.J. MI-TEMPS",1,null,null,"AS",null,null,null,null,"2019-09-01","2019-09-01",1,1,9,2019,9,2019]
["AD",null,"08 10 2019",null,null,null,"02 09 2019","29 09 2019","I.J. MI-TEMPS",28,null,null,"AS",null,null,null,null,"2019-09-02","2019-09-29",28,1,9,2019,9,2019]
["AD",null,"19 09 2019",null,null,null,"01 07 2019","31 07 2019","I.J. MI-TEMPS",31,null,null,"AS",null,null,null,null,"2019-07-01","2019-07-31",31,1,7,2019,7,2019]
["AD",null,"19 09 2019",null,null,null,"01 08 2019","31 08 2019","I.J. MI-TEMPS",31,null,null,"AS",null,null,null,null,"2019-08-01","2019-08-31",31,1,8,2019,8,2019]
["AD",null,"01 08 2019",null,null,null,"01 06 2019","03 06 2019","I.J. MI-TEMPS",3,null,null,"AS",null,null,null,null,"2019-06-01","2019-06-03",3,1,6,2019,6,2019]
["AD",null,"01 08 2019",null,null,null,"04 06 2019","28 06 2019","I.J. MI-TEMPS",25,null,null,"AS",null,null,null,null,"2019-06-04","2019-06-28",25,1,6,2019,6,2019]
["AD",null,"01 08 2019",null,null,null,"29 06 2019","30 06 2019","I.J. MI-TEMPS",2,null,null,"AS",null,null,null,null,"2019-06-29","2019-06-30",2,1,6,2019,6,2019]
["AD",null,"27 06 2019",null,null,null,"01 05 2019","17 05 2019","I.J. MI-TEMPS",17,null,null,"AS",null,null,null,null,"2019-05-01","2019-05-17",17,1,5,2019,5,2019]
["AD",null,"27 06 2019",null,null,null,"18 05 2019","31 05 2019","I.J. MI-TEMPS",14,null,null,"AS",null,null,null,null,"2019-05-18","2019-05-31",14,1,5,2019,5,2019]
["AD",null,"13 05 2019",null,null,null,"04 03 2019","31 03 2019","I.J. MI-TEMPS",28,null,null,"AS",null,null,null,null,"2019-03-04","2019-03-31",28,1,3,2019,3,2019]
["AD",null,"13 05 2019",null,null,null,"04 03 2019","31 03 2019","I.J. MI-TEMPS",28,null,null,"AS",null,null,null,null,"2019-03-04","2019-03-31",28,1,3,2019,3,2019]
["AD",null,"14 05 2019",null,null,null,"01 04 2019","12 04 2019","I.J. MI-TEMPS",12,null,null,"AS",null,null,null,null,"2019-04-01","2019-04-12",12,1,4,2019,4,2019]
["AD",null,"14 05 2019",null,null,null,"13 04 2019","30 04 2019","I.J. MI-TEMPS",18,null,null,"AS",null,null,null,null,"2019-04-13","2019-04-30",18,1,4,2019,4,2019]
["AD",null,"17 04 2019",null,null,null,"04 03 2019","31 03 2019","I.J. MI-TEMPS",28,null,null,"AS",null,null,null,null,"2019-03-04","2019-03-31",28,1,3,2019,3,2019]
["AD",null,"07 01 2019",null,null,null,"28 11 2018","20 12 2018","I.J. NORMALES",23,null,null,"AS",null,null,null,null,{"$f":"IF(G66<>\"  \",DATE(RIGHT(G66,4),MID(G66,4,2),LEFT(G66,2)),\"\")","v":"2018-11-28"},{"$f":"DATE(RIGHT(H66,4),MID(H66,4,2),LEFT(H66,2))","v":"2018-12-20"},{"$f":"IF(AND(R66=\"\",U66=0),0,DATEDIF(R66,S66,\"d\")+1)","v":23},{"$f":"SUM(IF(OR(LEFT(I66,4)=\"I.J.\",LEFT(I66,4)=\"CARE\"),1,0))","v":1},11,2018,12,2018]
["AD",null,"07 01 2019",null,null,null,"21 12 2018","31 12 2018","I.J. NORMALES",11,null,null,"AS",null,null,null,null,"2018-12-21","2018-12-31",11,1,{"$f":"IF($R67<>\"\",MONTH(R67),\"\")","v":12},{"$f":"IF($R67<>\"\",YEAR(R67),\"\")","v":2018},{"$f":"IF($S67<>\"\",MONTH(S67),\"\")","v":12},{"$f":"IF($S67<>\"\",YEAR(S67),\"\")","v":2018}]
["AD",null,"07 01 2019",null,null,null,"01 01 2019","03 01 2019","I.J. NORMALES",3,null,null,"AS",null,null,null,null,"2019-01-01","2019-01-03",3,1,1,2019,1,2019]
["AD",null,"18 01 2019",null,null,null,"04 01 2019","17 01 2019","I.J. NORMALES",14,null,null,"AS",null,null,null,null,"2019-01-04","2019-01-17",14,1,1,2019,1,2019]
["AD",null,"01 02 2019",null,null,null,"18 01 2019","31 01 2019","I.J. NORMALES",14,null,null,"AS",null,null,null,null,"2019-01-18","2019-01-31",14,1,1,2019,1,2019]
["AD",null,"15 02 2019",null,null,null,"01 02 2019","14 02 2019","I.J. NORMALES",14,null,null,"AS",null,null,null,null,"2019-02-01","2019-02-14",14,1,2,2019,2,2019]
["AD",null,"13 05 2019",null,null,null,"02 08 2018","27 08 2018","I.J. NORMALES",26,null,null,"AS",null,null,null,null,"2018-08-02","2018-08-27",26,1,8,2018,8,2018]
["AD",null,"13 05 2019",null,null,null,"28 08 2018","30 09 2018","I.J. NORMALES",34,null,null,"AS",null,null,null,null,"2018-08-28","2018-09-30",34,1,8,2018,9,2018]
["AD",null,"13 05 2019",null,null,null,"01 10 2018","20 12 2018","I.J. NORMALES",81,null,null,"AS",null,null,null,null,"2018-10-01","2018-12-20",81,1,10,2018,12,2018]
["AD",null,"13 05 2019",null,null,null,"21 12 2018","31 12 2018","I.J. NORMALES",11,null,null,"AS",null,null,null,null,"2018-12-21","2018-12-31",11,1,12,2018,12,2018]
["AD",null,"13 05 2019",null,null,null,"01 01 2019","03 03 2019","I.J. NORMALES",62,null,null,"AS",null,null,null,null,"2019-01-01","2019-03-03",62,1,1,2019,3,2019]
["AD",null,"13 05 2019",null,null,null,"31 05 2018","01 06 2018","I.J. NORMALES",2,null,null,"AS",null,null,null,null,"2018-05-31","2018-06-01",2,1,5,2018,6,2018]
["AD",null,"13 05 2019",null,null,null,"02 06 2018","01 08 2018","I.J. NORMALES",61,null,null,"AS",null,null,null,null,"2018-06-02","2018-08-01",61,1,6,2018,8,2018]
["AD",null,"13 05 2019",null,null,null,"02 08 2018","27 08 2018","I.J. NORMALES",26,null,null,"AS",null,null,null,null,"2018-08-02","2018-08-27",26,1,8,2018,8,2018]
["AD",null,"13 05 2019",null,null,null,"28 08 2018","27 11 2018","I.J. NORMALES",92,null,null,"AS",null,null,null,null,"2018-08-28","2018-11-27",92,1,8,2018,11,2018]
["AD",null,"13 05 2019",null,null,null,"28 11 2018","31 12 2018","I.J. NORMALES",34,null,null,"AS",null,null,null,null,"2018-11-28","2018-12-31",34,1,11,2018,12,2018]
["AD",null,"13 05 2019",null,null,null,"01 01 2019","03 01 2019","I.J. NORMALES",3,null,null,"AS",null,null,null,null,"2019-01-01","2019-01-03",3,1,1,2019,1,2019]
["AD",null,"13 05 2019",null,null,null,"04 01 2019","03 03 2019","I.J. NORMALES",59,null,null,"AS",null,null,null,null,"2019-01-04","2019-03-03",59,1,1,2019,3,2019]
["AD",null,"13 05 2019",null,null,null,"31 05 2018","01 06 2018","I.J. NORMALES",2,null,null,"AS",null,null,null,null,"2018-05-31","2018-06-01",2,1,5,2018,6,2018]
["AD",null,"13 05 2019",null,null,null,"02 06 2018","11 06 2018","I.J. NORMALES",10,null,null,"AS",null,null,null,null,"2018-06-02","2018-06-11",10,1,6,2018,6,2018]
["AD",null,"13 05 2019",null,null,null,"12 06 2018","25 06 2018","I.J. NORMALES",14,null,null,"AS",null,null,null,null,"2018-06-12","2018-06-25",14,1,6,2018,6,2018]
["AD",null,"13 05 2019",null,null,null,"26 06 2018","04 07 2018","I.J. NORMALES",9,null,null,"AS",null,null,null,null,"2018-06-26","2018-07-04",9,1,6,2018,7,2018]
["AD",null,"13 05 2019",null,null,null,"05 07 2018","12 07 2018","I.J. NORMALES",8,null,null,"AS",null,null,null,null,"2018-07-05","2018-07-12",8,1,7,2018,7,2018]
["AD",null,"13 05 2019",null,null,null,"13 07 2018","17 07 2018","I.J. NORMALES",5,null,null,"AS",null,null,null,null,"2018-07-13","2018-07-17",5,1,7,2018,7,2018]
["AD",null,"13 05 2019",null,null,null,"18 07 2018","01 08 2018","I.J. NORMALES",15,null,null,"AS",null,null,null,null,"2018-07-18","2018-08-01",15,1,7,2018,8,2018]
["AD",null,"01 03 2019",null,null,null,"15 02 2019","28 02 2019","I.J. NORMALES",14,null,null,"AS",null,null,null,null,"2019-02-15","2019-02-28",14,1,2,2019,2,2019]
["AD",null,"15 03 2019",null,null,null,"01 03 2019","03 03 2019","I.J. NORMALES",3,null,null,"AS",null,null,null,null,"2019-03-01","2019-03-03",3,1,3,2019,3,2019]
["AE",null,"02 01 2019",null,null,null,"14 12 2018","14 12 2018","CARENCE",1,null,null,"AS",null,null,null,null,"2018-12-14","2018-12-14",1,1,12,2018,12,2018]
["AE",null,"05 08 2019",null,null,null,"30 07 2019","01 08 2019","CARENCE",3,null,null,"AS",null,null,null,null,"2019-07-30","2019-08-01",3,1,7,2019,8,2019]
["AE",null,"07 05 2019",null,null,null,"16 04 2019","18 04 2019","CARENCE",3,null,null,"AS",null,null,null,null,"2019-04-16","2019-04-18",3,1,4,2019,4,2019]
["AE",null,"19 03 2019",null,null,null,"27 02 2019","01 03 2019","CARENCE",3,null,null,"AS",null,null,null,null,"2019-02-27","2019-03-01",3,1,2,2019,3,2019]
["AE",null,"06 08 2019",null,null,null,"02 08 2019","02 08 2019","I.J. NORMALES",1,null,null,"AS",null,null,null,null,"2019-08-02","2019-08-02",1,1,8,2019,8,2019]
["AE",null,"16 08 2019",null,null,null,"03 08 2019","08 08 2019","I.J. NORMALES",6,null,null,"AS",null,null,null,null,"2019-08-03","2019-08-08",{"$f":"IF(AND(R98=\"\",U98=0),0,DATEDIF(R98,S98,\"d\")+1)","v":6},1,8,2019,8,2019]
["AE",null,"16 08 2019",null,null,null,"09 08 2019","13 08 2019","I.J. NORMALES",5,null,null,"AS",null,null,null,null,"2019-08-09","2019-08-13",5,1,8,2019,8,2019]
["AE",null,"07 05 2019",null,null,null,"19 04 2019","19 04 2019","I.J. NORMALES",1,null,null,"AS",null,null,null,null,"2019-04-19","2019-04-19",1,1,4,2019,4,2019]

{"sheet":"TCD","index":2,"n_rows":15,"n_cols":19,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["Dates","(Tous)"]
["Select_Lignes(CAR)+(IJ)","(Tous)"]
[]
[null,"Étiquettes de colonnes"]
[null,"Abs_Date_DEB_P",null,"Abs_Date_FIN_P",null,"IJ_Date_DEB_P",null,"IJ_Date_FIN_P",null,"Total Min de Valeur","Total Max de Valeur"]
["Étiquettes de lignes","Min de Valeur","Max de Valeur","Min de Valeur","Max de Valeur","Min de Valeur","Max de Valeur","Min de Valeur","Max de Valeur",null,null,null,null,null,null,null,"Nbre de jour(s) Absent(s)","Nbre de jour(s) indemnisé(s)","Reste à indemniser"]
["TITI","2019-04-02","2019-04-02","2019-04-02","2019-04-02","2019-04-02","2019-04-02","2019-04-02","2019-04-02","2019-04-02","2019-04-02",null,null,null,null,null,{"$f":"GETPIVOTDATA(\"Valeur\",$A3,\"Ligne\",A7,\"Colonne\",\"Abs_Date_FIN_P\")-GETPIVOTDATA(\"Valeur\",$A3,\"Ligne\",A7,\"Colonne\",\"Abs_Date_DEB_P\")+1","v":1},{"$f":"GETPIVOTDATA(\"Valeur\",$A$4,\"Ligne\",A7,\"Colonne\",\"IJ_Date_FIN_P\")-GETPIVOTDATA(\"Valeur\",$A$4,\"Ligne\",A7,\"Colonne\",\"IJ_Date_DEB_P\")+1","v":1},{"$f":"Q7-R7","v":0}]
["TOTO","2018-12-03","2019-09-30","2019-02-03","2019-11-30","2018-11-05","2019-09-02","2018-11-30","2019-09-30","2018-11-05","2019-11-30",null,null,null,null,null,{"$f":"GETPIVOTDATA(\"Valeur\",$A4,\"Ligne\",A8,\"Colonne\",\"Abs_Date_FIN_P\")-GETPIVOTDATA(\"Valeur\",$A4,\"Ligne\",A8,\"Colonne\",\"Abs_Date_DEB_P\")+1","v":63},{"$f":"GETPIVOTDATA(\"Valeur\",$A$4,\"Ligne\",A8,\"Colonne\",\"IJ_Date_FIN_P\")-GETPIVOTDATA(\"Valeur\",$A$4,\"Ligne\",A8,\"Colonne\",\"IJ_Date_DEB_P\")+1","v":26},{"$f":"Q8-R8","v":37}]
["TUTU","2018-12-04","2019-10-01","2019-01-06","2019-11-30","2018-12-22","2019-08-01","2018-12-31","2019-08-31","2018-12-04","2019-11-30",null,null,null,null,null,34,10,24]
["AA","2019-04-16","2019-06-05","2019-04-17","2019-06-16","2019-04-16","2019-06-08","2019-04-17","2019-06-16","2019-04-16","2019-06-16",null,null,null,null,null,2,2,0]
["AB","2019-01-14","2019-01-14","2019-01-18","2019-01-18","2019-01-14","2019-01-17","2019-01-16","2019-01-18","2019-01-14","2019-01-18",null,null,null,null,null,5,3,2]
["AC","2019-03-13","2019-06-11","2019-03-15","2019-06-14","2019-03-14","2019-06-14","2019-03-15","2019-06-14","2019-03-13","2019-06-14",null,null,null,null,null,3,2,1]
["AD","2019-03-04","2019-09-30","2019-04-12","2019-10-31","2018-05-28","2019-09-02","2018-05-30","2019-09-29","2018-05-28","2019-10-31",null,null,null,null,null,40,3,37]
["AE","2019-02-27","2019-09-19","2019-03-01","2019-09-20","2018-12-14","2019-08-09","2018-12-14","2019-08-13","2018-12-14","2019-09-20",null,null,null,null,null,3,1,2]
["Total général","2018-12-03","2019-10-01","2019-01-06","2019-11-30","2018-05-28","2019-09-02","2018-05-30","2019-09-30","2018-05-28","2019-11-30"]