{"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":152,"n_cols":53,"rows_kept":152,"cut":false,"hidden":false,"merged":[]}
["D1",null,"T1",null,"D2",null,"T2",null,"D3",null,"T2",null,"D4",null,"T4",null,"D5",null,"T5",null,"D6",null,"T6",null,"D7",null,"T7",null,"D8",null,"D9",null,"D10",null,"D11",null,"D12",null,"D13",null,"D14",null,"D15",null,"D16",null,"D17",null,"D18",null,"D19",null,"D20"]
[]
["2010-02-26",9,"2010-09-12",3,"2010-09-15",12,"2010-09-27",17,"2010-10-14",7]
[]
["2010-01-19",6]
[]
["2010-04-02",1]
[]
[]
["2010-10-04",7,"2010-10-11",12,"2010-10-23",7]
[]
[]
[]
["2010-01-29",31,"2010-03-01",14]
["2010-01-02",3,"2010-11-04",2]
[]
[]
[]
["2010-03-04",1,"2010-03-22",2,"2010-05-12",6,"2010-05-18",8,"2010-05-26",13,"2010-06-08",13]
["2010-08-05",5]
["2010-05-17",18,"2010-06-04"]
["2010-01-05",1,"2010-01-24",3]
[]
["2010-09-09",9]
[]
[]
[]
[]
[]
["2010-09-12",1,"2010-09-20",14,"2010-10-04",14,"2010-10-18",28,"2010-11-15",47]
[]
[]
["2010-06-21",7,"2010-06-28",7,"2010-07-05",7]
[]
[]
[]
["2010-02-15",3]
["2010-11-23",5]
["2010-04-21",5,"2010-04-26",5,"2010-05-04",6]
[]
[]
["2010-03-11",1,"2010-05-03"]
[]
[]
["2010-09-13",7,"2010-09-20",31]
[]
[]
[]
["2010-04-14",27,"2010-10-06",30]
[]
[]
[]
["2010-07-15",9,"2010-12-27",5]
[]
[]
[]
["2010-05-21",2]
[]
[]
["2010-10-06",5,"2010-10-11",7,"2010-12-16",16]
[]
[]
["2010-09-26",1,"2010-12-08",5]
["2010-01-20",3]
[]
[]
["2010-02-26",34,"2010-05-30",8,"2010-06-07",9,"2010-06-16",17,"2010-07-03",18,"2010-07-21",42]
["2010-04-06",4]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["2010-04-23",24,"2010-05-17",14]
[]
[]
["2009-12-19",19,"2010-05-21",1]
["2010-12-11",3,"2010-12-14",4]
["2009-12-20",20,"2010-01-21",5,"2010-06-07",3,"2010-06-10",1]
["2010-06-02",8]
[]
[]
[]
[]
[]
["2010-11-24",2,"2010-12-23",1]
[]
[]
["2010-09-10",11,"2010-09-21",13,"2010-10-04",7]
["2010-09-01",31,"2010-10-02",31,"2010-11-02",16]
[]
["2010-06-22",6,"2010-09-13",5]
["2010-01-04",7,"2010-06-05",3]
["2010-08-19",1]
[]
[]
[]
[]
[]
["2010-03-05",1]
[]
["2010-03-04",1,"2010-06-06",1]
["2010-04-16",9,"2010-10-25",5]
[]
["2010-05-12",7,"2010-05-19",8,"2010-05-27",6,"2010-06-25",31]
["2010-07-16",30,"2010-12-10",10]
[]
["2010-09-06",7,"2010-09-27",21,"2010-10-18",10]
[]
[]
[]
["2010-10-12",1]
[]
["2010-06-04",57]
[]
["2010-07-16",4]
[]
["2010-01-17",16,"2010-02-17",31,"2010-08-16",28,"2010-08-17",1,"2010-08-30",1,"2010-09-22",7,"2010-10-20",3,"2010-11-21",32,null,41]
[]
["2010-05-11",6]
[]
[]
[]
["2010-05-18",15,"2010-06-02",5,"2010-06-28",14,"2010-07-12",7]
[]
[]
[]
[]
[]
[]
["2010-01-06",5,"2010-01-19",13,"2010-01-26",7,null,7]
[]
[]
["2010-01-07",2,"2010-01-09",3,"2010-03-16",3,"2010-08-26",2,"2010-10-08",7,"2010-12-03",3]
[]
[]
[]
[]
[]
[]
["2010-01-11",2,"2010-05-27",11,"21/7/6/10",14,"2010-06-21",11,"2010-07-02",11,"2010-07-13",19,"2010-08-01",31,"2010-09-01",30,"2010-10-01",33,"2010-11-01"]
["2010-01-25",8,"2010-02-02",27,"2010-04-16",8,"2010-04-24",23,"2010-05-17",2]
[]
["2010-04-23",11,"2010-05-04",32,"2010-06-05",30,"2010-07-05",31,"2010-08-05",16]
[]
[]
["2010-01-02",2,"2010-01-03"]

{"sheet":"Feuil2","index":1,"n_rows":20,"n_cols":10,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
[null,"<7jrs","<6jrs","<5jrs","<4jrs","<3jrs","<2jrs","<1jrs","TOTAL","TOTAL_feuil3"]
["lundi",{"$f":"cumul_jrs(\"Feuil1\",$A2,B$1)","v":12},{"$f":"cumul_jrs(\"Feuil1\",$A2,C$1)","v":12},8,8,6,3,2,{"$f":"SUM(B2:H2)","v":51},{"$f":"Feuil3!J2","v":38}]
["mardi",{"$f":"cumul_jrs(\"Feuil1\",$A3,B$1)","v":11},7,6,4,3,3,0,{"$f":"SUM(B3:H3)","v":34},{"$f":"Feuil3!J3","v":21}]
["mercredi",9,8,3,3,1,0,0,24,{"$f":"Feuil3!J4","v":22}]
["jeudi",12,11,9,9,9,6,0,56,{"$f":"Feuil3!J5","v":18}]
["vendredi",7,7,7,6,5,4,1,37,{"$f":"Feuil3!J6","v":21}]
["samedi",4,4,4,4,0,0,0,16,{"$f":"Feuil3!J7","v":11}]
["dimanche",5,5,5,5,3,3,0,26,{"$f":"Feuil3!J8","v":10}]
[null,{"$f":"SUM(B2:B8)","v":60},54,42,39,27,19,3,{"$f":"SUM(I2:I8)","v":244},{"$f":"SUM(J2:J8)","v":141}]
[null,"Tableau a : Nombre d'arrets <7 jours par jour de début (anneé 2010)"]
[]
[null,"<7jrs"]
["lundi",{"$f":"B2/J2","v":0.31578947368421051}]
["mardi",{"$f":"B3/J3","v":0.52380952380952384}]
["mercredi",0.40909090909090912]
["jeudi",0.66666666666666663]
["vendredi",0.33333333333333331]
["samedi",0.36363636363636365]
["dimanche",0.5]
[null,"Tableau b : Répartition des arrets  <7 jours classés selon le jour de début (anneé 2010)"]

{"sheet":"Feuil3","index":2,"n_rows":36,"n_cols":14,"rows_kept":36,"cut":false,"hidden":false,"merged":[]}
[null,">7jrs","7jrs ","6jrs","5jrs ","4jrs","3jrs ","2jrs ","1jr","TOTAL",null,"Vérif.",null,"Nb dates"]
["lundi",{"$f":"cumul_jrs(\"Feuil1\",$A2,B$1)","v":18},{"$f":"cumul_jrs(\"Feuil1\",$A2,C$1)","v":10},0,4,0,2,3,1,{"$f":"SUM(B2:I2)","v":38},null,{"$f":"cpt_jrs(\"Feuil1\",$A2)","v":38},null,{"$f":"ROUNDDOWN(COUNTA(Feuil1!A2:AO1000)/2,0)","v":145}]
["mardi",{"$f":"cumul_jrs(\"Feuil1\",$A3,B$1)","v":9},1,4,1,2,1,0,3,{"$f":"SUM(B3:I3)","v":21},null,{"$f":"cpt_jrs(\"Feuil1\",$A3)","v":21}]
["mercredi",11,2,1,5,0,2,1,0,22,null,22]
["jeudi",5,1,1,2,0,0,3,6,18,null,18]
["vendredi",{"$f":"cumul_jrs(\"Feuil1\",$A6,B$1)","v":14},1,0,0,1,1,1,3,21,null,21]
["samedi",{"$f":"cumul_jrs(\"Feuil1\",$A7,B$1)","v":5},1,0,0,0,4,{"$f":"cumul_jrs(\"Feuil1\",$A7,H$1)","v":1},0,11,null,11]
["dimanche",5,0,0,0,0,2,0,{"$f":"cumul_jrs(\"Feuil1\",$A8,I$1)","v":3},10,null,10]
[null,{"$f":"SUM(B2:B8)","v":67},16,6,12,3,12,9,16,{"$f":"SUM(J2:J8)","v":141},null,{"$f":"SUM(L2:L8)","v":141}]
[null,null,"Tableau a : Nombre d'arrets regroupés par jour de début et durée en 2010"]
[]
[null,">7jrs","7jrs ","6jrs","5jrs ","4jrs","3jrs ","2jrs ","1jr","Total"]
["lundi",{"$f":"B2/J2","v":0.47368421052631576},{"$f":"C2/J2","v":0.26315789473684209},{"$f":"D2/J2","v":0},{"$f":"E2/J2","v":0.10526315789473684},{"$f":"F2/J2","v":0},{"$f":"G2/J2","v":5.2631578947368418E-2},{"$f":"H2/J2","v":7.8947368421052627E-2},{"$f":"I2/J2","v":2.6315789473684209E-2},{"$f":"J2/J2","v":1}]
["mardi",{"$f":"B3/J3","v":0.42857142857142855},{"$f":"C3/J3","v":4.7619047619047616E-2},{"$f":"D3/J3","v":0.19047619047619047},{"$f":"E3/J3","v":4.7619047619047616E-2},{"$f":"F3/J3","v":9.5238095238095233E-2},{"$f":"G3/J3","v":4.7619047619047616E-2},{"$f":"H3/J3","v":0},{"$f":"I3/J3","v":0.14285714285714285},{"$f":"J3/J3","v":1}]
["mercredi",0.5,9.0909090909090912E-2,4.5454545454545456E-2,0.22727272727272727,0,9.0909090909090912E-2,4.5454545454545456E-2,0,1]
["jeudi",0.27777777777777779,5.5555555555555552E-2,5.5555555555555552E-2,0.1111111111111111,0,0,0.16666666666666666,0.33333333333333331,1]
["vendredi",0.66666666666666663,4.7619047619047616E-2,0,0,4.7619047619047616E-2,4.7619047619047616E-2,4.7619047619047616E-2,0.14285714285714285,1]
["samedi",0.45454545454545453,9.0909090909090912E-2,0,0,0,0.36363636363636365,9.0909090909090912E-2,0,1]
["dimanche",0.5,0,0,0,0,0.2,0,0.3,1]
[null,null,"Tableau b : Répartition des arrets  classés selon le jour de début et la durée 2010"]
[]
[]
[null,">7jrs","7jrs ","6jrs","5jrs ","4jrs","3jrs ","2jrs ","1jr","Total",null,"Vérif."]
["JANVIER",{"$f":"cumul_mois(\"Feuil1\",$A24,B$23)","v":4},{"$f":"cumul_mois(\"Feuil1\",$A24,C$23)","v":2},1,2,0,4,{"$f":"cumul_mois(\"Feuil1\",$A24,H$23)","v":3},{"$f":"cumul_mois(\"Feuil1\",$A24,I$23)","v":1},{"$f":"SUM(B24:I24)","v":17},null,{"$f":"cpt_mois(\"Feuil1\",$A24)","v":17}]
["FÉVRIER",{"$f":"cumul_mois(\"Feuil1\",$A25,B$23)","v":4},0,0,0,0,1,0,0,{"$f":"SUM(B25:I25)","v":5},null,{"$f":"cpt_mois(\"Feuil1\",$A25)","v":5}]
["MARS",1,0,0,0,0,1,1,4,7,null,7]
["AVRIL",6,0,0,2,1,0,0,1,10,null,10]
["MAI",9,1,4,0,0,0,2,1,17,null,17]
["JUIN",9,2,1,1,0,2,0,2,17,null,17]
["JUILLET",7,2,0,0,1,0,0,0,10,null,10]
["AOÛT",3,0,0,1,0,0,1,3,8,null,8]
["SEPTEMBRE",10,3,0,1,0,1,0,2,17,null,17]
["OCTOBRE",7,6,0,2,0,1,0,1,17,null,17]
["NOVEMBRE",3,0,0,1,0,0,2,0,6,null,6]
["DÉCEMBRE",4,0,0,2,1,2,0,1,10,null,10]
[null,{"$f":"SUM(B24:B35)","v":67},16,6,12,3,12,9,16,{"$f":"SUM(J24:J35)","v":141},null,{"$f":"SUM(L24:L35)","v":141}]