{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Feuil1","Feuil2","Feuil3"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":64,"n_cols":7,"rows_kept":64,"cut":false,"hidden":false,"merged":[]}
[]
[null,"client","Entrée","Sortie","Jour","Amplitude","Temps occupation"]
["Date  "]
["2015-10-05",1,"19:10:00","20:00:00","2015-10-05",{"$f":"IFERROR(LARGE(($D$4:$D$1004)*($A$4:$A$1004=$E4),1)-INDEX(($C$4:$C$1004),SMALL(IF($A$4:$A$1004=$E4,ROW($1:$1000)),1),1),\"\")","v":"00:50:00"},{"$f":"IF(E4=\"\",\"\",TEMPSOCCUPATION($A$4:$A$50,$C$4:$C$50,$D$4:$D$50,$E4))","v":"00:50:00"}]
["2015-10-06",1,"10:45:00","12:00:00","2015-10-06",{"$f":"IFERROR(LARGE(($D$4:$D$1004)*($A$4:$A$1004=$E5),1)-INDEX(($C$4:$C$1004),SMALL(IF($A$4:$A$1004=$E5,ROW($1:$1000)),1),1),\"\")","v":"07:15:00"},{"$f":"IF(E5=\"\",\"\",TEMPSOCCUPATION($A$4:$A$50,$C$4:$C$50,$D$4:$D$50,$E5))","v":"07:05:00"}]
["2015-10-06",2,"14:30:00","16:00:00","2015-10-07",{"$f":"IFERROR(LARGE(($D$4:$D$1004)*($A$4:$A$1004=$E6),1)-INDEX(($C$4:$C$1004),SMALL(IF($A$4:$A$1004=$E6,ROW($1:$1000)),1),1),\"\")","v":"04:30:00"},"02:30:00"]
["2015-10-06",3,"11:00:00","11:30:00",null,{"$f":"IFERROR(LARGE(($D$4:$D$1004)*($A$4:$A$1004=$E7),1)-INDEX(($C$4:$C$1004),SMALL(IF($A$4:$A$1004=$E7,ROW($1:$1000)),1),1),\"\")","v":""},""]
["2015-10-06",4,"16:55:00","18:00:00",null,{"$f":"IFERROR(LARGE(($D$4:$D$1004)*($A$4:$A$1004=$E8),1)-INDEX(($C$4:$C$1004),SMALL(IF($A$4:$A$1004=$E8,ROW($1:$1000)),1),1),\"\")","v":""},""]
["2015-10-06",5,"11:00:00","12:30:00",null,{"$f":"IFERROR(LARGE(($D$4:$D$1004)*($A$4:$A$1004=$E9),1)-INDEX(($C$4:$C$1004),SMALL(IF($A$4:$A$1004=$E9,ROW($1:$1000)),1),1),\"\")","v":""},""]
["2015-10-06",6,"09:00:00","11:00:00",null,{"$f":"IFERROR(LARGE(($D$4:$D$1004)*($A$4:$A$1004=$E10),1)-INDEX(($C$4:$C$1004),SMALL(IF($A$4:$A$1004=$E10,ROW($1:$1000)),1),1),\"\")","v":""},""]
["2015-10-07",7,"08:30:00","10:00:00",null,{"$f":"IFERROR(LARGE(($D$4:$D$1004)*($A$4:$A$1004=$E11),1)-INDEX(($C$4:$C$1004),SMALL(IF($A$4:$A$1004=$E11,ROW($1:$1000)),1),1),\"\")","v":""},{"$f":"IF(E11=\"\",\"\",TEMPSOCCUPATION($A$4:$A$50,$C$4:$C$50,$D$4:$D$50,$E11))","v":""}]
["2015-10-06",8,"07:00:00","08:00:00",null,{"$f":"IFERROR(LARGE(($D$4:$D$1004)*($A$4:$A$1004=$E12),1)-INDEX(($C$4:$C$1004),SMALL(IF($A$4:$A$1004=$E12,ROW($1:$1000)),1),1),\"\")","v":""},""]
["2015-10-07",9,"12:00:00","13:00:00",null,{"$f":"IFERROR(LARGE(($D$4:$D$1004)*($A$4:$A$1004=$E13),1)-INDEX(($C$4:$C$1004),SMALL(IF($A$4:$A$1004=$E13,ROW($1:$1000)),1),1),\"\")","v":""},""]
[null,null,null,null,null,{"$f":"IFERROR(LARGE(($D$4:$D$1004)*($A$4:$A$1004=$E14),1)-INDEX(($C$4:$C$1004),SMALL(IF($A$4:$A$1004=$E14,ROW($1:$1000)),1),1),\"\")","v":""},""]
[null,null,null,null,null,{"$f":"IFERROR(LARGE(($D$4:$D$1004)*($A$4:$A$1004=$E15),1)-INDEX(($C$4:$C$1004),SMALL(IF($A$4:$A$1004=$E15,ROW($1:$1000)),1),1),\"\")","v":""},""]
[null,null,null,null,null,{"$f":"IFERROR(LARGE(($D$4:$D$1004)*($A$4:$A$1004=$E16),1)-INDEX(($C$4:$C$1004),SMALL(IF($A$4:$A$1004=$E16,ROW($1:$1000)),1),1),\"\")","v":""},""]
[null,null,null,null,null,{"$f":"IFERROR(LARGE(($D$4:$D$1004)*($A$4:$A$1004=$E17),1)-INDEX(($C$4:$C$1004),SMALL(IF($A$4:$A$1004=$E17,ROW($1:$1000)),1),1),\"\")","v":""},""]
[null,null,null,null,null,{"$f":"IFERROR(LARGE(($D$4:$D$1004)*($A$4:$A$1004=$E18),1)-INDEX(($C$4:$C$1004),SMALL(IF($A$4:$A$1004=$E18,ROW($1:$1000)),1),1),\"\")","v":""},""]
[null,null,null,null,null,{"$f":"IFERROR(LARGE(($D$4:$D$1004)*($A$4:$A$1004=$E19),1)-INDEX(($C$4:$C$1004),SMALL(IF($A$4:$A$1004=$E19,ROW($1:$1000)),1),1),\"\")","v":""},""]
[null,null,null,null,null,{"$f":"IFERROR(LARGE(($D$4:$D$1004)*($A$4:$A$1004=$E20),1)-INDEX(($C$4:$C$1004),SMALL(IF($A$4:$A$1004=$E20,ROW($1:$1000)),1),1),\"\")","v":""},""]
[null,null,null,null,null,{"$f":"IFERROR(LARGE(($D$4:$D$1004)*($A$4:$A$1004=$E21),1)-INDEX(($C$4:$C$1004),SMALL(IF($A$4:$A$1004=$E21,ROW($1:$1000)),1),1),\"\")","v":""},""]
[null,null,null,null,null,{"$f":"IFERROR(LARGE(($D$4:$D$1004)*($A$4:$A$1004=$E22),1)-INDEX(($C$4:$C$1004),SMALL(IF($A$4:$A$1004=$E22,ROW($1:$1000)),1),1),\"\")","v":""},""]
[null,null,null,null,null,{"$f":"IFERROR(LARGE(($D$4:$D$1004)*($A$4:$A$1004=$E23),1)-INDEX(($C$4:$C$1004),SMALL(IF($A$4:$A$1004=$E23,ROW($1:$1000)),1),1),\"\")","v":""},""]
[null,null,null,null,null,{"$f":"IFERROR(LARGE(($D$4:$D$1004)*($A$4:$A$1004=$E24),1)-INDEX(($C$4:$C$1004),SMALL(IF($A$4:$A$1004=$E24,ROW($1:$1000)),1),1),\"\")","v":""},""]
[null,null,null,null,null,{"$f":"IFERROR(LARGE(($D$4:$D$1004)*($A$4:$A$1004=$E25),1)-INDEX(($C$4:$C$1004),SMALL(IF($A$4:$A$1004=$E25,ROW($1:$1000)),1),1),\"\")","v":""},""]
[null,null,null,null,null,{"$f":"IFERROR(LARGE(($D$4:$D$1004)*($A$4:$A$1004=$E26),1)-INDEX(($C$4:$C$1004),SMALL(IF($A$4:$A$1004=$E26,ROW($1:$1000)),1),1),\"\")","v":""},""]
[null,null,null,null,null,{"$f":"IFERROR(LARGE(($D$4:$D$1004)*($A$4:$A$1004=$E27),1)-INDEX(($C$4:$C$1004),SMALL(IF($A$4:$A$1004=$E27,ROW($1:$1000)),1),1),\"\")","v":""},""]
[null,null,null,null,null,{"$f":"IFERROR(LARGE(($D$4:$D$1004)*($A$4:$A$1004=$E28),1)-INDEX(($C$4:$C$1004),SMALL(IF($A$4:$A$1004=$E28,ROW($1:$1000)),1),1),\"\")","v":""},""]
[null,null,null,null,null,{"$f":"IFERROR(LARGE(($D$4:$D$1004)*($A$4:$A$1004=$E29),1)-INDEX(($C$4:$C$1004),SMALL(IF($A$4:$A$1004=$E29,ROW($1:$1000)),1),1),\"\")","v":""},""]
[null,null,null,null,null,{"$f":"IFERROR(LARGE(($D$4:$D$1004)*($A$4:$A$1004=$E30),1)-INDEX(($C$4:$C$1004),SMALL(IF($A$4:$A$1004=$E30,ROW($1:$1000)),1),1),\"\")","v":""},""]
[null,null,null,null,null,{"$f":"IFERROR(LARGE(($D$4:$D$1004)*($A$4:$A$1004=$E31),1)-INDEX(($C$4:$C$1004),SMALL(IF($A$4:$A$1004=$E31,ROW($1:$1000)),1),1),\"\")","v":""},""]
[null,null,null,null,null,{"$f":"IFERROR(LARGE(($D$4:$D$1004)*($A$4:$A$1004=$E32),1)-INDEX(($C$4:$C$1004),SMALL(IF($A$4:$A$1004=$E32,ROW($1:$1000)),1),1),\"\")","v":""},""]
[null,null,null,null,null,{"$f":"IFERROR(LARGE(($D$4:$D$1004)*($A$4:$A$1004=$E33),1)-INDEX(($C$4:$C$1004),SMALL(IF($A$4:$A$1004=$E33,ROW($1:$1000)),1),1),\"\")","v":""},""]
[null,null,null,null,null,{"$f":"IFERROR(LARGE(($D$4:$D$1004)*($A$4:$A$1004=$E34),1)-INDEX(($C$4:$C$1004),SMALL(IF($A$4:$A$1004=$E34,ROW($1:$1000)),1),1),\"\")","v":""},""]
[null,null,null,null,null,{"$f":"IFERROR(LARGE(($D$4:$D$1004)*($A$4:$A$1004=$E35),1)-INDEX(($C$4:$C$1004),SMALL(IF($A$4:$A$1004=$E35,ROW($1:$1000)),1),1),\"\")","v":""},""]
[null,null,null,null,null,{"$f":"IFERROR(LARGE(($D$4:$D$1004)*($A$4:$A$1004=$E36),1)-INDEX(($C$4:$C$1004),SMALL(IF($A$4:$A$1004=$E36,ROW($1:$1000)),1),1),\"\")","v":""},""]
[null,null,null,null,null,{"$f":"IFERROR(LARGE(($D$4:$D$1004)*($A$4:$A$1004=$E37),1)-INDEX(($C$4:$C$1004),SMALL(IF($A$4:$A$1004=$E37,ROW($1:$1000)),1),1),\"\")","v":""},""]
[null,null,null,null,null,{"$f":"IFERROR(LARGE(($D$4:$D$1004)*($A$4:$A$1004=$E38),1)-INDEX(($C$4:$C$1004),SMALL(IF($A$4:$A$1004=$E38,ROW($1:$1000)),1),1),\"\")","v":""},""]
[null,null,null,null,null,{"$f":"IFERROR(LARGE(($D$4:$D$1004)*($A$4:$A$1004=$E39),1)-INDEX(($C$4:$C$1004),SMALL(IF($A$4:$A$1004=$E39,ROW($1:$1000)),1),1),\"\")","v":""},""]
[null,null,null,null,null,{"$f":"IFERROR(LARGE(($D$4:$D$1004)*($A$4:$A$1004=$E40),1)-INDEX(($C$4:$C$1004),SMALL(IF($A$4:$A$1004=$E40,ROW($1:$1000)),1),1),\"\")","v":""},""]
[null,null,null,null,null,{"$f":"IFERROR(LARGE(($D$4:$D$1004)*($A$4:$A$1004=$E41),1)-INDEX(($C$4:$C$1004),SMALL(IF($A$4:$A$1004=$E41,ROW($1:$1000)),1),1),\"\")","v":""},""]
[null,null,null,null,null,{"$f":"IFERROR(LARGE(($D$4:$D$1004)*($A$4:$A$1004=$E42),1)-INDEX(($C$4:$C$1004),SMALL(IF($A$4:$A$1004=$E42,ROW($1:$1000)),1),1),\"\")","v":""},""]
[null,null,null,null,null,{"$f":"IFERROR(LARGE(($D$4:$D$1004)*($A$4:$A$1004=$E43),1)-INDEX(($C$4:$C$1004),SMALL(IF($A$4:$A$1004=$E43,ROW($1:$1000)),1),1),\"\")","v":""},""]
[null,null,null,null,null,{"$f":"IFERROR(LARGE(($D$4:$D$1004)*($A$4:$A$1004=$E44),1)-INDEX(($C$4:$C$1004),SMALL(IF($A$4:$A$1004=$E44,ROW($1:$1000)),1),1),\"\")","v":""},""]
[null,null,null,null,null,{"$f":"IFERROR(LARGE(($D$4:$D$1004)*($A$4:$A$1004=$E45),1)-INDEX(($C$4:$C$1004),SMALL(IF($A$4:$A$1004=$E45,ROW($1:$1000)),1),1),\"\")","v":""},""]
[null,null,null,null,null,{"$f":"IFERROR(LARGE(($D$4:$D$1004)*($A$4:$A$1004=$E46),1)-INDEX(($C$4:$C$1004),SMALL(IF($A$4:$A$1004=$E46,ROW($1:$1000)),1),1),\"\")","v":""},""]
[null,null,null,null,null,{"$f":"IFERROR(LARGE(($D$4:$D$1004)*($A$4:$A$1004=$E47),1)-INDEX(($C$4:$C$1004),SMALL(IF($A$4:$A$1004=$E47,ROW($1:$1000)),1),1),\"\")","v":""},""]
[null,null,null,null,null,{"$f":"IFERROR(LARGE(($D$4:$D$1004)*($A$4:$A$1004=$E48),1)-INDEX(($C$4:$C$1004),SMALL(IF($A$4:$A$1004=$E48,ROW($1:$1000)),1),1),\"\")","v":""},""]
[null,null,null,null,null,{"$f":"IFERROR(LARGE(($D$4:$D$1004)*($A$4:$A$1004=$E49),1)-INDEX(($C$4:$C$1004),SMALL(IF($A$4:$A$1004=$E49,ROW($1:$1000)),1),1),\"\")","v":""},""]
[null,null,null,null,null,{"$f":"IFERROR(LARGE(($D$4:$D$1004)*($A$4:$A$1004=$E50),1)-INDEX(($C$4:$C$1004),SMALL(IF($A$4:$A$1004=$E50,ROW($1:$1000)),1),1),\"\")","v":""},""]
[null,null,null,null,null,{"$f":"IFERROR(LARGE(($D$4:$D$1004)*($A$4:$A$1004=$E51),1)-INDEX(($C$4:$C$1004),SMALL(IF($A$4:$A$1004=$E51,ROW($1:$1000)),1),1),\"\")","v":""},""]
[null,null,null,null,null,{"$f":"IFERROR(LARGE(($D$4:$D$1004)*($A$4:$A$1004=$E52),1)-INDEX(($C$4:$C$1004),SMALL(IF($A$4:$A$1004=$E52,ROW($1:$1000)),1),1),\"\")","v":""},""]
[null,null,null,null,null,{"$f":"IFERROR(LARGE(($D$4:$D$1004)*($A$4:$A$1004=$E53),1)-INDEX(($C$4:$C$1004),SMALL(IF($A$4:$A$1004=$E53,ROW($1:$1000)),1),1),\"\")","v":""},""]
[null,null,null,null,null,{"$f":"IFERROR(LARGE(($D$4:$D$1004)*($A$4:$A$1004=$E54),1)-INDEX(($C$4:$C$1004),SMALL(IF($A$4:$A$1004=$E54,ROW($1:$1000)),1),1),\"\")","v":""},""]
[null,null,null,null,null,{"$f":"IFERROR(LARGE(($D$4:$D$1004)*($A$4:$A$1004=$E55),1)-INDEX(($C$4:$C$1004),SMALL(IF($A$4:$A$1004=$E55,ROW($1:$1000)),1),1),\"\")","v":""},""]
[null,null,null,null,null,{"$f":"IFERROR(LARGE(($D$4:$D$1004)*($A$4:$A$1004=$E56),1)-INDEX(($C$4:$C$1004),SMALL(IF($A$4:$A$1004=$E56,ROW($1:$1000)),1),1),\"\")","v":""},""]
[null,null,null,null,null,{"$f":"IFERROR(LARGE(($D$4:$D$1004)*($A$4:$A$1004=$E57),1)-INDEX(($C$4:$C$1004),SMALL(IF($A$4:$A$1004=$E57,ROW($1:$1000)),1),1),\"\")","v":""},""]
[null,null,null,null,null,{"$f":"IFERROR(LARGE(($D$4:$D$1004)*($A$4:$A$1004=$E58),1)-INDEX(($C$4:$C$1004),SMALL(IF($A$4:$A$1004=$E58,ROW($1:$1000)),1),1),\"\")","v":""},""]
[null,null,null,null,null,{"$f":"IFERROR(LARGE(($D$4:$D$1004)*($A$4:$A$1004=$E59),1)-INDEX(($C$4:$C$1004),SMALL(IF($A$4:$A$1004=$E59,ROW($1:$1000)),1),1),\"\")","v":""},""]
[null,null,null,null,null,{"$f":"IFERROR(LARGE(($D$4:$D$1004)*($A$4:$A$1004=$E60),1)-INDEX(($C$4:$C$1004),SMALL(IF($A$4:$A$1004=$E60,ROW($1:$1000)),1),1),\"\")","v":""},""]
[null,null,null,null,null,{"$f":"IFERROR(LARGE(($D$4:$D$1004)*($A$4:$A$1004=$E61),1)-INDEX(($C$4:$C$1004),SMALL(IF($A$4:$A$1004=$E61,ROW($1:$1000)),1),1),\"\")","v":""},""]
[null,null,null,null,null,{"$f":"IFERROR(LARGE(($D$4:$D$1004)*($A$4:$A$1004=$E62),1)-INDEX(($C$4:$C$1004),SMALL(IF($A$4:$A$1004=$E62,ROW($1:$1000)),1),1),\"\")","v":""},""]
[null,null,null,null,null,{"$f":"IFERROR(LARGE(($D$4:$D$1004)*($A$4:$A$1004=$E63),1)-INDEX(($C$4:$C$1004),SMALL(IF($A$4:$A$1004=$E63,ROW($1:$1000)),1),1),\"\")","v":""},""]
[null,null,null,null,null,{"$f":"IFERROR(LARGE(($D$4:$D$1004)*($A$4:$A$1004=$E64),1)-INDEX(($C$4:$C$1004),SMALL(IF($A$4:$A$1004=$E64,ROW($1:$1000)),1),1),\"\")","v":""},""]

{"sheet":"Feuil2","index":1,"n_rows":7,"n_cols":9,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[null,null,null,"09:00:00",null,null,"14:00:00"]
[null,"08:00:00","08:30:00"]
[null,"08:00:00",null,null,"10:00:00"]
[null,"08:00:00",null,null,null,null,null,"15:00:00"]
[null,null,null,null,"10:00:00","11:00:00"]
[null,null,null,null,"10:00:00",null,null,"15:00:00"]
[null,null,null,null,null,null,null,"15:00:00","16:00:00"]

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