{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["24 août 2015","17 août 2015","10 aout 2015","Tableau_Synthese"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":0,"defined_names":3,"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":"24 août 2015","index":0,"n_rows":30,"n_cols":14,"rows_kept":30,"cut":false,"hidden":false,"merged":[[23,0,24,1],[23,11,26,11],[25,0,26,1],[27,0,29,1],[27,11,29,11],[14,0,16,1],[14,11,17,11],[17,0,17,1],[18,0,20,1],[18,11,22,11],[21,0,22,1],[0,0,0,11],[1,0,1,11],[4,0,7,1],[4,11,7,11],[8,0,13,1],[8,11,13,11]]}
["SITUATION DES SERVICES"]
["2015-08-24"]
[]
[null,null,null,"Objectifs","Entrées","Production","Soldes ou volumes","Dossier le plus ancien\n","Soldes - Délais\n","Semaine précédente\n","Variation","Commentaires",null,"Couleur du texte"]
["Thème 1",null,"libellé 1","15 j (local)",null,null,null,null,{"$f":"IF(H5=\"\",\"\",NETWORKDAYS(H5,$A$2))","v":""},3,{"$f":"IF(OR(I5=\"\",J5=\"\"),\"\",I5-J5)","v":""},null,null,"Orange si >20 j\nRouge si >30j"]
[null,null,"libellé 2","15 j (local)",null,null,null,null,{"$f":"IF(H6=\"\",\"\",NETWORKDAYS(H6,$A$2))","v":""},13,""]
[null,null,"libellé 3","15 j (local)",null,null,null,null,"",10,{"$f":"IF(OR(I7=\"\",J7=\"\"),\"\",I7-J7)","v":""}]
[null,null,"libellé 4","15 j (local)",null,null,null,null,"",4,{"$f":"IF(OR(I8=\"\",J8=\"\"),\"\",I8-J8)","v":""}]
["Thème 2",null,"libellé 5","15 j (local)",null,null,null,null,"",10,"",null,null,"Orange si >17j"]
[null,null,"libellé 6","15 j (local)",null,null,null,null,"",13,""]
[null,null,"libellé 7","15 j (local)",null,null,null,null,"",11,""]
[null,null,"libellé 8","15 j (local)",null,null,null,null,"",21,""]
[null,null,"libellé 9","15 j (local)",null,null,null,null,"",9,""]
[null,null,"libellé 10","15 j (local)",null,null,null,null,"",5,""]
["Thème 3",null,"libellé 11","20 j (CPG)",null,null,null,null,{"$f":"IF(H15=\"\",\"\",NETWORKDAYS(H15,$A$2))","v":""},3,""]
[null,null,"libellé 12","20 j (CPG)",null,null,null,null,{"$f":"IF(H16=\"\",\"\",NETWORKDAYS(H16,$A$2))","v":""},4,""]
[null,null,"libellé 13","20 j (CPG)",null,null,null,null,"",4,""]
["Thème 4",null,"libellé 14"]
["Thème 5",null,"libellé 15","8j (local)",null,null,null,null,"",9,"",null,null,"Orange si >15j"]
[null,null,"libellé 16","8j (local)",null,null,null,null,"",4,""]
[null,null,"libellé 17","10j (local)",null,null,null,null,"",""]
["Thème 6",null,"libellé 18","15 j (local)",null,null,null,null,"",4,"",null,null,"Orange si >8j"]
[null,null,"libellé 19","15 j (local)",null,null,null,null,"",6,""]
["Thème 7",null,"libellé 20",null,null,null,null,null,null,null,null,null," "]
[null,null,"libellé 21"]
["Thème 8",null,"libellé 22","90% (CPG)",null,null,null,null,90.03,90.03,{"$f":"IF(OR(I26=\"\",J26=\"\"),\"\",I26-J26)","v":0}]
[null,null,"libellé 23","90% (CPG)",null,null,null,null,96.65,96.65,{"$f":"IF(OR(I27=\"\",J27=\"\"),\"\",I27-J27)","v":0}]
["Thème 9",null,"libellé 24","15 j (local)",null,null,null,null,{"$f":"IF(H28=\"\",\"\",NETWORKDAYS(H28,$A$2))","v":""},4,{"$f":"IF(OR(I28=\"\",J28=\"\"),\"\",I28-J28)","v":""},null,null,"Orange si >15j"]
[null,null,"libellé 25","15 j (local)",null,null,null,null,{"$f":"IF(H29=\"\",\"\",NETWORKDAYS(H29,$A$2))","v":""},2,{"$f":"IF(OR(I29=\"\",J29=\"\"),\"\",I29-J29)","v":""}]
[null,null,"libellé 26","7 j (tech)",null,null,null,null,"",1,{"$f":"IF(OR(I30=\"\",J30=\"\"),\"\",I30-J30)","v":""}]

{"sheet":"17 août 2015","index":1,"n_rows":30,"n_cols":14,"rows_kept":30,"cut":false,"hidden":false,"merged":[[0,0,0,11],[1,0,1,11],[4,0,7,1],[4,11,7,11],[8,0,13,1],[8,11,13,11],[14,0,16,1],[14,11,17,11],[17,0,17,1],[18,0,20,1],[18,11,22,11],[21,0,22,1],[23,0,24,1],[23,11,26,11],[25,0,26,1],[27,0,29,1],[27,11,29,11]]}
["SITUATION DES SERVICES"]
["2015-08-17"]
[]
[null,null,null,"Objectifs","Entrées","Production","Soldes ou volumes","Dossier le plus ancien\n","Soldes - Délais\n","Semaine précédente\n","Variation","Commentaires",null,"Couleur du texte"]
["Thème 1",null,"libellé 1","15 j (local)",42,10,42,"2015-08-06",{"$f":"IF(H5=\"\",\"\",NETWORKDAYS(H5,$A$2))","v":8},3,{"$f":"IF(OR(I5=\"\",J5=\"\"),\"\",I5-J5)","v":5},null,null,"Orange si >20 j\nRouge si >30j"]
[null,null,"libellé 2","15 j (local)",132,241,682,"2015-07-23",{"$f":"IF(H6=\"\",\"\",NETWORKDAYS(H6,$A$2))","v":18},13,5]
[null,null,"libellé 3","15 j (local)",31,39,167,"2015-07-28",15,10,{"$f":"IF(OR(I7=\"\",J7=\"\"),\"\",I7-J7)","v":5}]
[null,null,"libellé 4","15 j (local)",18,16,35,"2015-08-05",9,4,{"$f":"IF(OR(I8=\"\",J8=\"\"),\"\",I8-J8)","v":5}]
["Thème 2",null,"libellé 5","15 j (local)",13,19,122,"2015-07-28",15,10,5,null,null,"Orange si >17j"]
[null,null,"libellé 6","15 j (local)",3,0,38,"2015-07-23",18,13,5]
[null,null,"libellé 7","15 j (local)",13,5,158,"2015-07-27",16,11,5]
[null,null,"libellé 8","15 j (local)",20,0,238,"2015-07-13",26,21,5]
[null,null,"libellé 9","15 j (local)",4,0,43,"2015-07-29",14,9,5]
[null,null,"libellé 10","15 j (local)",8,8,42,"2015-08-04",10,5,5]
["Thème 3",null,"libellé 11","20 j (CPG)",0,54,44,"2015-08-06",{"$f":"IF(H15=\"\",\"\",NETWORKDAYS(H15,$A$2))","v":8},3,5]
[null,null,"libellé 12","20 j (CPG)",0,1059,1457,"2015-08-05",{"$f":"IF(H16=\"\",\"\",NETWORKDAYS(H16,$A$2))","v":9},4,5]
[null,null,"libellé 13","20 j (CPG)",0,426,465,"2015-08-05",9,4,5]
["Thème 4",null,"libellé 14"]
["Thème 5",null,"libellé 15","8j (local)",29,21,208,"2015-07-29",14,9,5,null,null,"Orange si >15j"]
[null,null,"libellé 16","8j (local)",8,45,35,"2015-08-05",9,4,5]
[null,null,"libellé 17","10j (local)",null,null,null,null,"",""]
["Thème 6",null,"libellé 18","15 j (local)",21,28,22,"2015-08-05",9,4,5,null,null,"Orange si >8j"]
[null,null,"libellé 19","15 j (local)",2,7,3,"2015-08-02",11,6,5]
["Thème 7",null,"libellé 20",null,1573,null,null,null,null,null,null,null," "]
[null,null,"libellé 21",null,327]
["Thème 8",null,"libellé 22","90% (CPG)",null,null,null,null,null,90.03,{"$f":"IF(OR(I26=\"\",J26=\"\"),\"\",I26-J26)","v":""}]
[null,null,"libellé 23","90% (CPG)",null,null,null,null,null,96.65,{"$f":"IF(OR(I27=\"\",J27=\"\"),\"\",I27-J27)","v":""}]
["Thème 9",null,"libellé 24","15 j (local)",15,9,10,"2015-08-05",{"$f":"IF(H28=\"\",\"\",NETWORKDAYS(H28,$A$2))","v":9},4,{"$f":"IF(OR(I28=\"\",J28=\"\"),\"\",I28-J28)","v":5},null,null,"Orange si >15j"]
[null,null,"libellé 25","15 j (local)",6,6,0,"2015-08-07",{"$f":"IF(H29=\"\",\"\",NETWORKDAYS(H29,$A$2))","v":7},2,{"$f":"IF(OR(I29=\"\",J29=\"\"),\"\",I29-J29)","v":5}]
[null,null,"libellé 26","7 j (tech)",4326,4155,818,"2015-08-10",6,1,{"$f":"IF(OR(I30=\"\",J30=\"\"),\"\",I30-J30)","v":5}]

{"sheet":"10 aout 2015","index":2,"n_rows":30,"n_cols":14,"rows_kept":30,"cut":false,"hidden":false,"merged":[[0,0,0,11],[1,0,1,11],[4,0,7,1],[4,11,7,11],[8,0,13,1],[8,11,13,11],[14,0,16,1],[14,11,17,11],[17,0,17,1],[18,0,20,1],[18,11,22,11],[21,0,22,1],[23,0,24,1],[23,11,26,11],[25,0,26,1],[27,0,29,1],[27,11,29,11]]}
["SITUATION DES SERVICES"]
["2015-08-10"]
[]
[null,null,null,"Objectifs","Entrées","Production","Soldes ou volumes","Dossier le plus ancien\n","Soldes - Délais\n","Semaine précédente\n","Variation","Commentaires",null,"Couleur du texte"]
["Thème 1",null,"libellé 1","15 j (local)",42,10,42,"2015-08-06",{"$f":"IF(H5=\"\",\"\",NETWORKDAYS(H5,$A$2))","v":3},3,{"$f":"IF(OR(I5=\"\",J5=\"\"),\"\",I5-J5)","v":0},null,null,"Orange si >20 j\nRouge si >30j"]
[null,null,"libellé 2","15 j (local)",132,241,682,"2015-07-23",{"$f":"IF(H6=\"\",\"\",NETWORKDAYS(H6,$A$2))","v":13},15,-2]
[null,null,"libellé 3","15 j (local)",31,39,167,"2015-07-28",10,9,{"$f":"IF(OR(I7=\"\",J7=\"\"),\"\",I7-J7)","v":1}]
[null,null,"libellé 4","15 j (local)",18,16,35,"2015-08-05",4,4,{"$f":"IF(OR(I8=\"\",J8=\"\"),\"\",I8-J8)","v":0}]
["Thème 2",null,"libellé 5","15 j (local)",13,19,122,"2015-07-28",10,7,3,null,null,"Orange si >17j"]
[null,null,"libellé 6","15 j (local)",3,0,38,"2015-07-23",13,8,5]
[null,null,"libellé 7","15 j (local)",13,5,158,"2015-07-27",11,5,6]
[null,null,"libellé 8","15 j (local)",20,0,238,"2015-07-13",21,15,6]
[null,null,"libellé 9","15 j (local)",4,0,43,"2015-07-29",9,8,1]
[null,null,"libellé 10","15 j (local)",8,8,42,"2015-08-04",5,5,0]
["Thème 3",null,"libellé 11","20 j (CPG)",0,54,44,"2015-08-06",{"$f":"IF(H15=\"\",\"\",NETWORKDAYS(H15,$A$2))","v":3},3,0]
[null,null,"libellé 12","20 j (CPG)",0,1059,1457,"2015-08-05",{"$f":"IF(H16=\"\",\"\",NETWORKDAYS(H16,$A$2))","v":4},3,1]
[null,null,"libellé 13","20 j (CPG)",0,426,465,"2015-08-05",4,3,1]
["Thème 4",null,"libellé 14"]
["Thème 5",null,"libellé 15","8j (local)",29,21,208,"2015-07-29",9,6,3,null,null,"Orange si >15j"]
[null,null,"libellé 16","8j (local)",8,45,35,"2015-08-05",4,3,1]
[null,null,"libellé 17","10j (local)",null,null,null,null,"",8]
["Thème 6",null,"libellé 18","15 j (local)",21,28,22,"2015-08-05",4,3,1,null,null,"Orange si >8j"]
[null,null,"libellé 19","15 j (local)",2,7,3,"2015-08-02",6,15,-9]
["Thème 7",null,"libellé 20",null,1573,null,null,null,null,null,null,null," "]
[null,null,"libellé 21",null,327]
["Thème 8",null,"libellé 22","90% (CPG)",null,null,null,null,90.03,90.3,{"$f":"IF(OR(I26=\"\",J26=\"\"),\"\",I26-J26)","v":-0.26999999999999602}]
[null,null,"libellé 23","90% (CPG)",null,null,null,null,96.65,96.87,{"$f":"IF(OR(I27=\"\",J27=\"\"),\"\",I27-J27)","v":-0.21999999999999886}]
["Thème 9",null,"libellé 24","15 j (local)",15,9,10,"2015-08-05",{"$f":"IF(H28=\"\",\"\",NETWORKDAYS(H28,$A$2))","v":4},3,{"$f":"IF(OR(I28=\"\",J28=\"\"),\"\",I28-J28)","v":1},null,null,"Orange si >15j"]
[null,null,"libellé 25","15 j (local)",6,6,0,"2015-08-07",{"$f":"IF(H29=\"\",\"\",NETWORKDAYS(H29,$A$2))","v":2},1,{"$f":"IF(OR(I29=\"\",J29=\"\"),\"\",I29-J29)","v":1}]
[null,null,"libellé 26","7 j (tech)",4326,4155,818,"2015-08-10",1,1,{"$f":"IF(OR(I30=\"\",J30=\"\"),\"\",I30-J30)","v":0}]

{"sheet":"Tableau_Synthese","index":3,"n_rows":28,"n_cols":18,"rows_kept":28,"cut":false,"hidden":false,"merged":[[15,0,15,1],[2,0,5,1],[6,0,11,1],[12,0,14,1],[25,0,27,1],[16,0,18,1],[19,0,20,1],[21,0,22,1],[23,0,24,1]]}
[null,null,null,"10 aout 2015",null,null,"17 août 2015",null,null,"24 août 2015",null,null,"10 aout 2015",null,null,"17 août 2015"]
[null,null,null,"Entrées","Soldes ou volumes","Soldes - Délais\n","Entrées","Soldes ou volumes","Soldes - Délais\n","Entrées","Soldes ou volumes","Soldes - Délais\n","Entrées","Soldes ou volumes","Soldes - Délais\n","Entrées","Soldes ou volumes","Soldes - Délais\n"]
["Thème 1",null,"libellé 1",42,42,3,42,42,8,null,null,"",42,42,3,42,42,8]
[null,null,"libellé 2",132,682,13,132,682,18,null,null,"",132,682,13,132,682,18]
[null,null,"libellé 3",31,167,10,31,167,15,null,null,"",31,167,10,31,167,15]
[null,null,"libellé 4",18,35,4,18,35,9,null,null,"",18,35,4,18,35,9]
["Thème 2",null,"libellé 5",13,122,10,13,122,15,null,null,"",13,122,10,13,122,15]
[null,null,"libellé 6",3,38,13,3,38,18,null,null,"",3,38,13,3,38,18]
[null,null,"libellé 7",13,158,11,13,158,16,null,null,"",13,158,11,13,158,16]
[null,null,"libellé 8",20,238,21,20,238,26,null,null,"",20,238,21,20,238,26]
[null,null,"libellé 9",4,43,9,4,43,14,null,null,"",4,43,9,4,43,14]
[null,null,"libellé 10",8,42,5,8,42,10,null,null,"",8,42,5,8,42,10]
["Thème 3",null,"libellé 11",0,44,3,0,44,8,null,null,"",0,44,3,0,44,8]
[null,null,"libellé 12",0,1457,4,0,1457,9,null,null,"",0,1457,4,0,1457,9]
[null,null,"libellé 13",0,465,4,0,465,9,null,null,"",0,465,4,0,465,9]
["Thème 4",null,"libellé 14"]
["Thème 5",null,"libellé 15",29,208,9,29,208,14,null,null,"",29,208,9,29,208,14]
[null,null,"libellé 16",8,35,4,8,35,9,null,null,"",8,35,4,8,35,9]
[null,null,"libellé 17",null,null,"",null,null,"",null,null,"",null,null,"",null,null,""]
["Thème 6",null,"libellé 18",21,22,4,21,22,9,null,null,"",21,22,4,21,22,9]
[null,null,"libellé 19",2,3,6,2,3,11,null,null,"",2,3,6,2,3,11]
["Thème 7",null,"libellé 20",1573,null,null,1573,null,null,null,null,null,1573,null,null,1573]
[null,null,"libellé 21",327,null,null,327,null,null,null,null,null,327,null,null,327]
["Thème 8",null,"libellé 22",null,null,90.03,null,null,null,null,null,90.03,null,null,90.03]
[null,null,"libellé 23",null,null,96.65,null,null,null,null,null,96.65,null,null,96.65]
["Thème 9",null,"libellé 24",15,10,4,15,10,9,null,null,"",15,10,4,15,10,9]
[null,null,"libellé 25",6,0,2,6,0,7,null,null,"",6,0,2,6,0,7]
[null,null,"libellé 26",4326,818,1,4326,818,6,null,null,"",4326,818,1,4326,818,6]