{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Feuil1"],"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":"Feuil1","index":0,"n_rows":18,"n_cols":9,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
["Nom de Employé","Début de la maladie","Fin de la maladie","Durée du congé maladie"]
["toto1","2017-04-10","2017-05-06",{"$f":"IF(B2=\"\",\"\",IF(C2=\"\",NETWORKDAYS(B2,TODAY()),NETWORKDAYS(B2,C2)))","v":20}]
["toto2","2018-05-10","2018-06-06",{"$f":"IF(B3=\"\",\"\",IF(C3=\"\",NETWORKDAYS(B3,TODAY()),NETWORKDAYS(B3,C3)))","v":20}]
["toto1","2016-04-11","2016-04-25",11]
["toto4","2018-04-12","2018-04-17",4]
["toto5","2018-04-13","2018-04-18",4]
["toto1","2018-04-01",null,5," Quand la fin de la maladie n'est pas connu il prend la date d'aujourd'hui pour évaluer à ce jour la période de maladie."]
["toto7","2018-04-13","2018-04-18",4]
[]
[]
[]
[]
[null,null,null,null,null,null,"Années","2016"]
[null,null,null,null,null,null,"Mois (début maladie)","(Tous)"]
[null,null,null,null,null,null,null,null,"Dans ce TDC, Mois représente le mois où la maladie à débuter."]
[null,null,null,null,null,null,"Employés","Nombre de jours du congé maladie"]
[null,null,null,null,null,null,"toto1",11,"Si tu veux avoir un TDC avec le mois où la maladie s'est terminée, tu fais un second TDC"]
[null,null,null,null,null,null,"Total général",11,"La maladie peut débuter dans un mois et finir dans un autre mois."]