{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Feuil1","Feuil2","Feuil3"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":8,"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":"Feuil1","index":0,"n_rows":19,"n_cols":7,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
["Début","Fin","temps total",null,null,null,"Jour fériés (Utilisable jusqu'à Iigne30)   nommé ->  JF"]
["2015-05-01","2015-05-02T18:00:00",{"$f":"IF(OR(A2=\"\",B2=\"\"),\"\",IF(INT(A2)-INT(B2)=0,B2-A2,B2-INT(B2)-(A2-INT(A2)))-IF(A2-INT(A2)<=FAM,TP,0)+IF(INT(B2)-INT(A2)>1,NETWORKDAYS(A2,B2-1,JF)*HJ,0))","v":0.70833333333333326},null,"Début AM    nommé      ->   DAM","09:00:00","2015-01-01"]
["2015-05-07T10:30:00","2015-05-08T16:30:00",{"$f":"IF(OR(A3=\"\",B3=\"\"),\"\",IF(INT(A3)-INT(B3)=0,B3-A3,B3-INT(B3)-(A3-INT(A3)))-IF(A3-INT(A3)<=FAM,TP,0)+IF(INT(B3)-INT(A3)>1,NETWORKDAYS(A3,B3-1,JF)*HJ,0))","v":0.20833333333333326},null,"Fin AM                               ->  FAM","13:00:00","2015-04-06"]
["2015-05-12T09:00:00","2015-05-12T17:00:00",{"$f":"IF(OR(A4=\"\",B4=\"\"),\"\",IF(INT(A4)-INT(B4)=0,B4-A4,B4-INT(B4)-(A4-INT(A4)))-IF(A4-INT(A4)<=FAM,TP,0)+IF(INT(B4)-INT(A4)>1,NETWORKDAYS(A4,B4-1,JF)*HJ,0))","v":0.29166666666909191},null,"Début PM                          -> DPM","14:00:00","2015-05-01"]
["2015-05-18T10:00:00","2015-05-20T16:00:00",{"$f":"IF(OR(A5=\"\",B5=\"\"),\"\",IF(INT(A5)-INT(B5)=0,B5-A5,B5-INT(B5)-(A5-INT(A5)))-IF(A5-INT(A5)<=FAM,TP,0)+IF(INT(B5)-INT(A5)>1,NETWORKDAYS(A5,B5-1,JF)*HJ,0))","v":0.87499999999999978},null,"Fin PM                                -> FPM","18:00:00","2015-05-08"]
[null,null,{"$f":"IF(OR(A6=\"\",B6=\"\"),\"\",IF(INT(A6)-INT(B6)=0,B6-A6,B6-INT(B6)-(A6-INT(A6)))-IF(A6-INT(A6)<=FAM,TP,0)+IF(INT(B6)-INT(A6)>1,NETWORKDAYS(A6,B6-1,JF)*HJ,0))","v":""},null,"horaire jour                          ->  HJ",{"$f":"F3-F2+F5-F4","v":"08:00:00"},"2015-05-14"]
[null,null,{"$f":"IF(OR(A7=\"\",B7=\"\"),\"\",IF(INT(A7)-INT(B7)=0,B7-A7,B7-INT(B7)-(A7-INT(A7)))-IF(A7-INT(A7)<=FAM,TP,0)+IF(INT(B7)-INT(A7)>1,NETWORKDAYS(A7,B7-1,JF)*HJ,0))","v":""},null,"Pause                                   ->   TP",{"$f":"F4-F3","v":"01:00:00"},"2015-05-25"]
[null,null,{"$f":"IF(OR(A8=\"\",B8=\"\"),\"\",IF(INT(A8)-INT(B8)=0,B8-A8,B8-INT(B8)-(A8-INT(A8)))-IF(A8-INT(A8)<=FAM,TP,0)+IF(INT(B8)-INT(A8)>1,NETWORKDAYS(A8,B8-1,JF)*HJ,0))","v":""},null,null,null,"2015-07-14"]
[null,null,{"$f":"IF(OR(A9=\"\",B9=\"\"),\"\",IF(INT(A9)-INT(B9)=0,B9-A9,B9-INT(B9)-(A9-INT(A9)))-IF(A9-INT(A9)<=FAM,TP,0)+IF(INT(B9)-INT(A9)>1,NETWORKDAYS(A9,B9-1,JF)*HJ,0))","v":""},null,null,null,"2015-08-15"]
[null,null,{"$f":"IF(OR(A10=\"\",B10=\"\"),\"\",IF(INT(A10)-INT(B10)=0,B10-A10,B10-INT(B10)-(A10-INT(A10)))-IF(A10-INT(A10)<=FAM,TP,0)+IF(INT(B10)-INT(A10)>1,NETWORKDAYS(A10,B10-1,JF)*HJ,0))","v":""},null,"les valeurs F2 à F5 sont modifiables",null,"2015-11-01"]
[null,null,{"$f":"IF(OR(A11=\"\",B11=\"\"),\"\",IF(INT(A11)-INT(B11)=0,B11-A11,B11-INT(B11)-(A11-INT(A11)))-IF(A11-INT(A11)<=FAM,TP,0)+IF(INT(B11)-INT(A11)>1,NETWORKDAYS(A11,B11-1,JF)*HJ,0))","v":""},null,null,null,"2015-11-11"]
[null,null,{"$f":"IF(OR(A12=\"\",B12=\"\"),\"\",IF(INT(A12)-INT(B12)=0,B12-A12,B12-INT(B12)-(A12-INT(A12)))-IF(A12-INT(A12)<=FAM,TP,0)+IF(INT(B12)-INT(A12)>1,NETWORKDAYS(A12,B12-1,JF)*HJ,0))","v":""},null,null,null,"2015-12-25"]
[null,null,{"$f":"IF(OR(A13=\"\",B13=\"\"),\"\",IF(INT(A13)-INT(B13)=0,B13-A13,B13-INT(B13)-(A13-INT(A13)))-IF(A13-INT(A13)<=FAM,TP,0)+IF(INT(B13)-INT(A13)>1,NETWORKDAYS(A13,B13-1,JF)*HJ,0))","v":""}]
[null,null,{"$f":"IF(OR(A14=\"\",B14=\"\"),\"\",IF(INT(A14)-INT(B14)=0,B14-A14,B14-INT(B14)-(A14-INT(A14)))-IF(A14-INT(A14)<=FAM,TP,0)+IF(INT(B14)-INT(A14)>1,NETWORKDAYS(A14,B14-1,JF)*HJ,0))","v":""}]
[null,null,{"$f":"IF(OR(A15=\"\",B15=\"\"),\"\",IF(INT(A15)-INT(B15)=0,B15-A15,B15-INT(B15)-(A15-INT(A15)))-IF(A15-INT(A15)<=FAM,TP,0)+IF(INT(B15)-INT(A15)>1,NETWORKDAYS(A15,B15-1,JF)*HJ,0))","v":""}]
[null,null,{"$f":"IF(OR(A16=\"\",B16=\"\"),\"\",IF(INT(A16)-INT(B16)=0,B16-A16,B16-INT(B16)-(A16-INT(A16)))-IF(A16-INT(A16)<=FAM,TP,0)+IF(INT(B16)-INT(A16)>1,NETWORKDAYS(A16,B16-1,JF)*HJ,0))","v":""}]
[null,null,{"$f":"IF(OR(A17=\"\",B17=\"\"),\"\",IF(INT(A17)-INT(B17)=0,B17-A17,B17-INT(B17)-(A17-INT(A17)))-IF(A17-INT(A17)<=FAM,TP,0)+IF(INT(B17)-INT(A17)>1,NETWORKDAYS(A17,B17-1,JF)*HJ,0))","v":""}]
[null,null,{"$f":"IF(OR(A18=\"\",B18=\"\"),\"\",IF(INT(A18)-INT(B18)=0,B18-A18,B18-INT(B18)-(A18-INT(A18)))-IF(A18-INT(A18)<=FAM,TP,0)+IF(INT(B18)-INT(A18)>1,NETWORKDAYS(A18,B18-1,JF)*HJ,0))","v":""}]
[null,null,{"$f":"IF(OR(A19=\"\",B19=\"\"),\"\",IF(INT(A19)-INT(B19)=0,B19-A19,B19-INT(B19)-(A19-INT(A19)))-IF(A19-INT(A19)<=FAM,TP,0)+IF(INT(B19)-INT(A19)>1,NETWORKDAYS(A19,B19-1,JF)*HJ,0))","v":""}]

{"sheet":"Feuil2","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Feuil3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}