{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["IS","Synthèse","Hist"],"not_rendered":{"macros":1,"defined_names":2},"read":"whole","date_system":"1900"}

{"sheet":"IS","index":0,"n_rows":95,"n_cols":15,"rows_kept":95}
[]
[]
[null,"Année","Semaine","Famille",null,null,"Fournisseur",null,"Statut",null,"Clio ouverte?","N° Clio","Problème identifié","Interlocuteur","Commentaire"]
[null,2016,8,"ADH",{"$f":"CONCATENATE(C4,D4)","v":"8ADH"},{"$f":"CONCATENATE(C4,I4)","v":"8OK"},"a",{"$f":"CONCATENATE(C4,G4)","v":"8a"},"OK",{"$f":"IF((I4=\"OK\"),1,0)","v":1},{"$f":"IF(I4=\"OK\",\"\",\"à compléter\")","v":""},{"$f":"IF(I4=\"OK\",\"\",\"à compléter\")","v":""},{"$f":"IF(I4=\"OK\",\"\",\"à compléter\")","v":""}]
[null,2016,8,"ADH",{"$f":"CONCATENATE(C5,D5)","v":"8ADH"},{"$f":"CONCATENATE(C5,I5)","v":"8OK"},"b",{"$f":"CONCATENATE(C5,G5)","v":"8b"},"OK",{"$f":"IF((I5=\"OK\"),1,0)","v":1},"","",""]
[null,2016,8,"BCH","8BCH","8OK","c","8c","OK",1,"","",""]
[null,2016,8,"BCH","8BCH","8OK","d","8d","OK",1,"","",""]
[null,2016,8,"CRT","8CRT","8OK","e","8e","OK",1,"","",""]
[null,2016,8,"CRT","8CRT","8OK","f","8f","OK",1,"","",""]
[null,2016,8,"CRT","8CRT","8OK","g","8g","OK",1,"","",""]
[null,2016,8,"CRT","8CRT","8OK","h","8h","OK",1,"","",""]
[null,2016,8,"CRT","8CRT","8OK","i","8i","OK",1,"","",""]
[null,2016,8,"CRT","8CRT","8OK","j","8j","OK",1,"","",""]
[null,2016,8,"CRT","8CRT","8OK","k","8k","OK",1,"","",""]
[null,2016,8,"CRT","8CRT","8OK","l","8l","OK",1,"","",""]
[null,2016,8,"ETI","8ETI","8OK","m","8m","OK",1,"","",""]
[null,2016,8,"ETI","8ETI","8OK","n","8n","OK",1,"","",""]
[null,2016,8,"ETI","8ETI","8OK","o","8o","OK",1,"","",""]
[null,2016,8,"ETI","8ETI","8OK","p","8p","OK",1,"","",""]
[null,2016,8,"ETI","8ETI","8OK","q","8q","OK",1,"","",""]
[null,2016,8,"ETI","8ETI","8OK","r","8r","OK",1,"","",""]
[null,2016,8,"FIR","8FIR","8OK","s","8s","OK",1,"","",""]
[null,2016,8,"FIR","8FIR","8OK","t","8t","OK",1,"","",""]
[null,2016,8,"FIR","8FIR","8OK","u","8u","OK",1,"","",""]
[null,2016,8,"POI","8POI","8OK","v","8v","OK",1,"","",""]
[null,2016,8,"POI","8POI","8OK","w","8w","OK",1,"","",""]
[null,2016,9,"ADH","9ADH","9OK","a","9a","OK",1,"",{"$f":"IF(I27=\"OK\",\"\",\"à compléter\")","v":""},{"$f":"IF(I27=\"OK\",\"\",\"à compléter\")","v":""}]
[null,2016,9,"ADH","9ADH","9OK","b","9b","OK",1,"","",""]
[null,2016,9,"BCH","9BCH","9OK","c","9c","OK",1,"","",""]
[null,2016,9,"BCH","9BCH","9OK","d","9d","OK",1,"","",""]
[null,2016,9,"CRT","9CRT","9OK","e","9e","OK",1,"","",""]
[null,2016,9,"CRT","9CRT","9OK","f","9f","OK",1,"","",""]
[null,2016,9,"CRT","9CRT","9OK","g","9g","OK",1,"","",""]
[null,2016,9,"CRT","9CRT","9NOK","h","9h","NOK",0,"à compléter","à compléter","Problème identifié ","Monsieur S","Solution trouvée"]
[null,2016,9,"CRT","9CRT","9OK","i","9i","OK",1,"","",""]
[null,2016,9,"CRT","9CRT","9OK","j","9j","OK",1,"","",""]
[null,2016,9,"CRT","9CRT","9OK","k","9k","OK",1,"","",""]
[null,2016,9,"CRT","9CRT","9OK","l","9l","OK",1,"","",""]
[null,2016,9,"ETI","9ETI","9OK","m","9m","OK",1,"","",""]
[null,2016,9,"ETI","9ETI","9OK","n","9n","OK",1,"","",""]
[null,2016,9,"ETI","9ETI","9OK","o","9o","OK",1,"","",""]
[null,2016,9,"ETI","9ETI","9OK","p","9p","OK",1,"","",""]
[null,2016,9,"ETI","9ETI","9OK","q","9q","OK",1,"","",""]
[null,2016,9,"ETI","9ETI","9OK","r","9r","OK",1,"","",""]
[null,2016,9,"FIR","9FIR","9OK","s","9s","OK",1,"","",""]
[null,2016,9,"FIR","9FIR","9OK","t","9t","OK",1,"","",""]
[null,2016,9,"FIR","9FIR","9OK","u","9u","OK",1,"","",""]
[null,2016,9,"POI","9POI","9OK","v","9v","OK",1,"","",""]
[null,2016,9,"POI","9POI","9OK","w","9w","OK",1,"","",""]
[null,2016,10,"ADH",{"$f":"CONCATENATE(C50,D50)","v":"10ADH"},"10OK","a",{"$f":"CONCATENATE(C50,G50)","v":"10a"},"OK",1,"",{"$f":"IF(I50=\"OK\",\"\",\"à compléter\")","v":""},{"$f":"IF(I50=\"OK\",\"\",\"à compléter\")","v":""}]
[null,2016,10,"ADH","10ADH","10OK","b","10b","OK",1,"","",""]
[null,2016,10,"BCH","10BCH","10OK","c","10c","OK",1,"","",""]
[null,2016,10,"BCH","10BCH","10OK","d","10d","OK",1,"","",""]
[null,2016,10,"CRT","10CRT","10OK","e","10e","OK",1,"","",""]
[null,2016,10,"CRT","10CRT","10OK","f","10f","OK",1,"","",""]
[null,2016,10,"CRT","10CRT","10OK","g","10g","OK",1,"","",""]
[null,2016,10,"CRT","10CRT","10OK","h","10h","OK",1,"","",""]
[null,2016,10,"CRT","10CRT","10OK","i","10i","OK",1,"","",""]
[null,2016,10,"CRT","10CRT","10OK","j","10j","OK",1,"","",""]
[null,2016,10,"CRT","10CRT","10OK","k","10k","OK",1,"","",""]
[null,2016,10,"CRT","10CRT","10OK","l","10l","OK",1,"","",""]
[null,2016,10,"ETI","10ETI","10OK","m","10m","OK",1,"","",""]
[null,2016,10,"ETI","10ETI","10OK","n","10n","OK",1,"","",""]
[null,2016,10,"ETI","10ETI","10OK","o","10o","OK",1,"","",""]
[null,2016,10,"ETI","10ETI","10OK","p","10p","OK",1,"","",""]
[null,2016,10,"ETI","10ETI","10OK","q","10q","OK",1,"","",""]
[null,2016,10,"ETI","10ETI","10OK","r","10r","OK",1,"","",""]
[null,2016,10,"FIR","10FIR","10OK","s","10s","OK",1,{"$f":"IF(I68=\"OK\",\"\",\"à compléter\")","v":""},"",""]
[null,2016,10,"FIR","10FIR",{"$f":"CONCATENATE(C69,I69)","v":"10OK"},"t","10t","OK",{"$f":"IF((I69=\"OK\"),1,0)","v":1},"","",""]
[null,2016,10,"FIR","10FIR","10OK","u","10u","OK",1,"","",""]
[null,2016,10,"POI","10POI","10OK","v","10v","OK",1,"","",""]
[null,2016,10,"POI","10POI","10OK","w","10w","OK",1,"","",""]
[null,2016,11,"ADH",{"$f":"CONCATENATE(C73,D73)","v":"11ADH"},"11","a",{"$f":"CONCATENATE(C73,G73)","v":"11a"},null,0,{"$f":"IF(I73=\"OK\",\"\",\"à compléter\")","v":"à compléter"},{"$f":"IF(I73=\"OK\",\"\",\"à compléter\")","v":"à compléter"},{"$f":"IF(I73=\"OK\",\"\",\"à compléter\")","v":"à compléter"}]
[null,2016,11,"ADH","11ADH","11","b","11b",null,0,"à compléter","à compléter","à compléter"]
[null,2016,11,"BCH","11BCH","11","c","11c",null,0,"à compléter","à compléter","à compléter"]
[null,2016,11,"BCH","11BCH","11","d","11d",null,0,"à compléter","à compléter","à compléter"]
[null,2016,11,"CRT","11CRT","11","e","11e",null,0,"à compléter","à compléter","à compléter"]
[null,2016,11,"CRT","11CRT","11","f","11f",null,0,"à compléter","à compléter","à compléter"]
[null,2016,11,"CRT","11CRT","11","g","11g",null,0,"à compléter","à compléter","à compléter"]
[null,2016,11,"CRT","11CRT","11","h","11h",null,0,"à compléter","à compléter","à compléter"]
[null,2016,11,"CRT","11CRT","11","i","11i",null,0,"à compléter","à compléter","à compléter"]
[null,2016,11,"CRT","11CRT","11","j","11j",null,0,"à compléter","à compléter","à compléter"]
[null,2016,11,"CRT","11CRT","11","k","11k",null,0,"à compléter","à compléter","à compléter"]
[null,2016,11,"CRT","11CRT","11","l","11l",null,0,"à compléter","à compléter","à compléter"]
[null,2016,11,"ETI","11ETI","11","m","11m",null,0,"à compléter","à compléter","à compléter"]
[null,2016,11,"ETI","11ETI","11","n","11n",null,0,"à compléter","à compléter","à compléter"]
[null,2016,11,"ETI","11ETI","11","o","11o",null,0,"à compléter","à compléter","à compléter"]
[null,2016,11,"ETI","11ETI","11","p","11p",null,0,"à compléter","à compléter","à compléter"]
[null,2016,11,"ETI","11ETI","11","q","11q",null,0,"à compléter","à compléter","à compléter"]
[null,2016,11,"ETI","11ETI","11","r","11r",null,0,"à compléter","à compléter","à compléter"]
[null,2016,11,"FIR","11FIR","11","s","11s",null,0,"à compléter","à compléter","à compléter"]
[null,2016,11,"FIR","11FIR","11","t","11t",null,0,"à compléter","à compléter","à compléter"]
[null,2016,11,"FIR","11FIR","11","u","11u",null,0,"à compléter","à compléter","à compléter"]
[null,2016,11,"POI","11POI","11","v","11v",null,0,"à compléter","à compléter","à compléter"]
[null,2016,11,"POI","11POI","11","w","11w",null,0,"à compléter","à compléter","à compléter"]

{"sheet":"Synthèse","index":1,"n_rows":28,"n_cols":22,"rows_kept":28,"merged":[[4,2,4,3],[4,10,4,11],[5,2,10,2],[5,10,27,10],[9,18,13,18],[21,3,21,7],[23,2,27,2]]}
[]
[]
[null,"Etat de la semaine ",null,9,{"$nulls":5},"Etat de la semaine ",null,{"$f":"D3","v":9},{"$nulls":5},"Semaine","Etat de la semaine","Nb d'anomalies","Problèmes identifiés","Fournisseur"]
[{"$nulls":17},{"$f":"D3","v":9},{"$f":"AVERAGE(M6:M28)","v":0.9565217391304348},{"$f":"COUNTIFS(IS!C4:C1048576,Synthèse!R4,IS!I4:I1048576,\"NOK\")","v":1},{"$f":"IF(COUNTIF(IS!$F$4:$F$1048576,CONCATENATE(Synthèse!$R$4,\"NOK\"))>0,VLOOKUP(CONCATENATE(Synthèse!$R$4,\"NOK\"),IS!$F$4:$M$1048576,8,FALSE),\"RAS\")","v":"Problème identifié "},{"$f":"IF(COUNTIF(IS!$F$4:$F$1048576,CONCATENATE(Synthèse!$R$4,\"NOK\"))>0,VLOOKUP(CONCATENATE(Synthèse!$R$4,\"NOK\"),IS!F4:G1048576,2,FALSE),\"RAS\")","v":"h"}]
[null,null,"Forecasts fournisseurs",null,"Amphion","S",{"$f":"D3","v":9},{"$nulls":3},"Forecasts fournisseurs",null,"Amphion","S",{"$f":"D3","v":9}]
[null,null,"Par familles de fournitures","ADH",{"$f":"SUMIF(IS!$E$4:$E$1048576,CONCATENATE(Synthèse!$G$5,Synthèse!D6),IS!$J$4:$J$1048576)/COUNTIF(IS!$E$4:$E$1048576,CONCATENATE(Synthèse!$G$5,Synthèse!D6))","v":1},{"$nulls":5},"Par fournisseurs","a",{"$f":"SUMIF(IS!$H$4:$H$1048576,CONCATENATE(Synthèse!$O$5,Synthèse!L6),IS!$J$4:$J$1048576)/COUNTIF(IS!$H$4:$H$1048576,CONCATENATE(Synthèse!$O$5,Synthèse!L6))","v":1}]
[{"$nulls":3},"BCH",{"$f":"SUMIF(IS!$E$4:$E$1048576,CONCATENATE(Synthèse!$G$5,Synthèse!D7),IS!$J$4:$J$1048576)/COUNTIF(IS!$E$4:$E$1048576,CONCATENATE(Synthèse!$G$5,Synthèse!D7))","v":1},{"$nulls":6},"b",{"$f":"SUMIF(IS!$H$4:$H$1048576,CONCATENATE(Synthèse!$O$5,Synthèse!L7),IS!$J$4:$J$1048576)/COUNTIF(IS!$H$4:$H$1048576,CONCATENATE(Synthèse!$O$5,Synthèse!L7))","v":1}]
[{"$nulls":3},"CRT",{"$f":"SUMIF(IS!$E$4:$E$1048576,CONCATENATE(Synthèse!$G$5,Synthèse!D8),IS!$J$4:$J$1048576)/COUNTIF(IS!$E$4:$E$1048576,CONCATENATE(Synthèse!$G$5,Synthèse!D8))","v":0.875},{"$nulls":6},"c",{"$f":"SUMIF(IS!$H$4:$H$1048576,CONCATENATE(Synthèse!$O$5,Synthèse!L8),IS!$J$4:$J$1048576)/COUNTIF(IS!$H$4:$H$1048576,CONCATENATE(Synthèse!$O$5,Synthèse!L8))","v":1}]
[{"$nulls":3},"ETI",{"$f":"SUMIF(IS!$E$4:$E$1048576,CONCATENATE(Synthèse!$G$5,Synthèse!D9),IS!$J$4:$J$1048576)/COUNTIF(IS!$E$4:$E$1048576,CONCATENATE(Synthèse!$G$5,Synthèse!D9))","v":1},{"$nulls":6},"d",{"$f":"SUMIF(IS!$H$4:$H$1048576,CONCATENATE(Synthèse!$O$5,Synthèse!L9),IS!$J$4:$J$1048576)/COUNTIF(IS!$H$4:$H$1048576,CONCATENATE(Synthèse!$O$5,Synthèse!L9))","v":1}]
[{"$nulls":3},"FIR",{"$f":"SUMIF(IS!$E$4:$E$1048576,CONCATENATE(Synthèse!$G$5,Synthèse!D10),IS!$J$4:$J$1048576)/COUNTIF(IS!$E$4:$E$1048576,CONCATENATE(Synthèse!$G$5,Synthèse!D10))","v":1},{"$nulls":6},"e",{"$f":"SUMIF(IS!$H$4:$H$1048576,CONCATENATE(Synthèse!$O$5,Synthèse!L10),IS!$J$4:$J$1048576)/COUNTIF(IS!$H$4:$H$1048576,CONCATENATE(Synthèse!$O$5,Synthèse!L10))","v":1}]
[{"$nulls":3},"POI",{"$f":"SUMIF(IS!$E$4:$E$1048576,CONCATENATE(Synthèse!$G$5,Synthèse!D11),IS!$J$4:$J$1048576)/COUNTIF(IS!$E$4:$E$1048576,CONCATENATE(Synthèse!$G$5,Synthèse!D11))","v":1},{"$nulls":6},"f",{"$f":"SUMIF(IS!$H$4:$H$1048576,CONCATENATE(Synthèse!$O$5,Synthèse!L11),IS!$J$4:$J$1048576)/COUNTIF(IS!$H$4:$H$1048576,CONCATENATE(Synthèse!$O$5,Synthèse!L11))","v":1}]
[{"$nulls":11},"g",{"$f":"SUMIF(IS!$H$4:$H$1048576,CONCATENATE(Synthèse!$O$5,Synthèse!L12),IS!$J$4:$J$1048576)/COUNTIF(IS!$H$4:$H$1048576,CONCATENATE(Synthèse!$O$5,Synthèse!L12))","v":1}]
[{"$nulls":11},"h",{"$f":"SUMIF(IS!$H$4:$H$1048576,CONCATENATE(Synthèse!$O$5,Synthèse!L13),IS!$J$4:$J$1048576)/COUNTIF(IS!$H$4:$H$1048576,CONCATENATE(Synthèse!$O$5,Synthèse!L13))","v":0}]
[{"$nulls":11},"i",{"$f":"SUMIF(IS!$H$4:$H$1048576,CONCATENATE(Synthèse!$O$5,Synthèse!L14),IS!$J$4:$J$1048576)/COUNTIF(IS!$H$4:$H$1048576,CONCATENATE(Synthèse!$O$5,Synthèse!L14))","v":1}]
[{"$nulls":11},"j",{"$f":"SUMIF(IS!$H$4:$H$1048576,CONCATENATE(Synthèse!$O$5,Synthèse!L15),IS!$J$4:$J$1048576)/COUNTIF(IS!$H$4:$H$1048576,CONCATENATE(Synthèse!$O$5,Synthèse!L15))","v":1}]
[{"$nulls":11},"k",{"$f":"SUMIF(IS!$H$4:$H$1048576,CONCATENATE(Synthèse!$O$5,Synthèse!L16),IS!$J$4:$J$1048576)/COUNTIF(IS!$H$4:$H$1048576,CONCATENATE(Synthèse!$O$5,Synthèse!L16))","v":1}]
[{"$nulls":11},"l",{"$f":"SUMIF(IS!$H$4:$H$1048576,CONCATENATE(Synthèse!$O$5,Synthèse!L17),IS!$J$4:$J$1048576)/COUNTIF(IS!$H$4:$H$1048576,CONCATENATE(Synthèse!$O$5,Synthèse!L17))","v":1}]
[{"$nulls":11},"m",{"$f":"SUMIF(IS!$H$4:$H$1048576,CONCATENATE(Synthèse!$O$5,Synthèse!L18),IS!$J$4:$J$1048576)/COUNTIF(IS!$H$4:$H$1048576,CONCATENATE(Synthèse!$O$5,Synthèse!L18))","v":1}]
[{"$nulls":11},"n",{"$f":"SUMIF(IS!$H$4:$H$1048576,CONCATENATE(Synthèse!$O$5,Synthèse!L19),IS!$J$4:$J$1048576)/COUNTIF(IS!$H$4:$H$1048576,CONCATENATE(Synthèse!$O$5,Synthèse!L19))","v":1}]
[{"$nulls":11},"o",{"$f":"SUMIF(IS!$H$4:$H$1048576,CONCATENATE(Synthèse!$O$5,Synthèse!L20),IS!$J$4:$J$1048576)/COUNTIF(IS!$H$4:$H$1048576,CONCATENATE(Synthèse!$O$5,Synthèse!L20))","v":1}]
[{"$nulls":11},"p",{"$f":"SUMIF(IS!$H$4:$H$1048576,CONCATENATE(Synthèse!$O$5,Synthèse!L21),IS!$J$4:$J$1048576)/COUNTIF(IS!$H$4:$H$1048576,CONCATENATE(Synthèse!$O$5,Synthèse!L21))","v":1}]
[{"$nulls":11},"q",{"$f":"SUMIF(IS!$H$4:$H$1048576,CONCATENATE(Synthèse!$O$5,Synthèse!L22),IS!$J$4:$J$1048576)/COUNTIF(IS!$H$4:$H$1048576,CONCATENATE(Synthèse!$O$5,Synthèse!L22))","v":1}]
[{"$nulls":11},"r",{"$f":"SUMIF(IS!$H$4:$H$1048576,CONCATENATE(Synthèse!$O$5,Synthèse!L23),IS!$J$4:$J$1048576)/COUNTIF(IS!$H$4:$H$1048576,CONCATENATE(Synthèse!$O$5,Synthèse!L23))","v":1}]
[{"$nulls":11},"s",{"$f":"SUMIF(IS!$H$4:$H$1048576,CONCATENATE(Synthèse!$O$5,Synthèse!L24),IS!$J$4:$J$1048576)/COUNTIF(IS!$H$4:$H$1048576,CONCATENATE(Synthèse!$O$5,Synthèse!L24))","v":1}]
[{"$nulls":11},"t",{"$f":"SUMIF(IS!$H$4:$H$1048576,CONCATENATE(Synthèse!$O$5,Synthèse!L25),IS!$J$4:$J$1048576)/COUNTIF(IS!$H$4:$H$1048576,CONCATENATE(Synthèse!$O$5,Synthèse!L25))","v":1}]
[{"$nulls":11},"u",{"$f":"SUMIF(IS!$H$4:$H$1048576,CONCATENATE(Synthèse!$O$5,Synthèse!L26),IS!$J$4:$J$1048576)/COUNTIF(IS!$H$4:$H$1048576,CONCATENATE(Synthèse!$O$5,Synthèse!L26))","v":1}]
[{"$nulls":11},"v",{"$f":"SUMIF(IS!$H$4:$H$1048576,CONCATENATE(Synthèse!$O$5,Synthèse!L27),IS!$J$4:$J$1048576)/COUNTIF(IS!$H$4:$H$1048576,CONCATENATE(Synthèse!$O$5,Synthèse!L27))","v":1}]
[{"$nulls":11},"w",{"$f":"SUMIF(IS!$H$4:$H$1048576,CONCATENATE(Synthèse!$O$5,Synthèse!L28),IS!$J$4:$J$1048576)/COUNTIF(IS!$H$4:$H$1048576,CONCATENATE(Synthèse!$O$5,Synthèse!L28))","v":1}]

{"sheet":"Hist","index":2,"n_rows":9,"n_cols":28,"rows_kept":9}
[]
[]
[]
[]
[null,null,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33]
[null,"Etat de la semaine",1,0.9565217391304348]
[null,"Nb d'anomalies",0,1]
[null,"Problèmes identifiés","RAS",{"$f":"IF(COUNTIF(IS!$F$4:$F$1048576,CONCATENATE(Synthèse!$R$4,\"NOK\"))>0,VLOOKUP(CONCATENATE(Synthèse!$R$4,\"NOK\"),IS!$F$4:$M$1048576,8,FALSE),\"RAS\")","v":"Problème identifié "}]
[null,"Fournisseur",null,"h"]