{"text_format":"3","workbook":"xlsx","n_sheets":5,"sheets":["Source","Extraction1","Parametre","Feuil5","x"],"not_rendered":{"macros":1,"defined_names":1,"pivot_tables":1},"read":"whole","date_system":"1900"}

{"sheet":"Source","index":0,"n_rows":9,"n_cols":16,"rows_kept":9}
[{"$nulls":3},"NOM","ID","PRESTATAIRE","SITE","MOIS","DATE","N°CLIENT","N°CLIENT 2","Resultatvente1","Operateure1","Operateure2","PLATEFORME","TYPE DE FLUX"]
[{"$nulls":3},{"$f":"Extraction1!F5","v":"x"},{"$f":"IFERROR(VLOOKUP(D2,Parametre!$A$2:$B$292,2,0),\"--\")","v":"--"},{"$f":"IF(E2=\"\",\"--\",\"ACTICALL\")","v":"ACTICALL"},{"$f":"IF(E2=\"\",\"--\",\"CASABLANCA\")","v":"CASABLANCA"},{"$f":"TEXT(I2,\"MMMM\")","v":"mai"},{"$f":"Extraction1!A5","v":"02/05/2014"},{"$f":"Extraction1!AD5","v":1245},{"$f":"IF((M2+N2=2),J2,IF(M2+N2=1,\"\"))","v":""},{"$f":"Extraction1!L5","v":0},1,0]
[{"$nulls":3},{"$f":"Extraction1!F6","v":"u"},{"$f":"IFERROR(VLOOKUP(D3,Parametre!$A$2:$B$292,2,0),\"--\")","v":"--"},"ACTICALL","CASABLANCA",{"$f":"TEXT(I3,\"MMMM\")","v":"mai"},{"$f":"Extraction1!A6","v":"02/05/2014"},{"$f":"Extraction1!AD6","v":54587},{"$f":"IF((M3+N3=2),J3,IF(M3+N3=1,\"\"))","v":54587},"KO",1,1]
[{"$nulls":3},{"$f":"Extraction1!F7","v":"y"},{"$f":"IFERROR(VLOOKUP(D4,Parametre!$A$2:$B$292,2,0),\"--\")","v":"--"},"ACTICALL","CASABLANCA","mai",{"$f":"Extraction1!A7","v":"2014-05-02"},{"$f":"Extraction1!AD7","v":5477},"",{"$f":"Extraction1!L7","v":"OK"},1,0]
[{"$nulls":3},{"$f":"Extraction1!#REF!","v":{"$error":"#REF!"}},{"$f":"IFERROR(VLOOKUP(D5,Parametre!$A$2:$B$292,2,0),\"--\")","v":"--"},"ACTICALL","CASABLANCA","mai","2014-05-04",{"$f":"Extraction1!#REF!","v":{"$error":"#REF!"}},"",{"$f":"Extraction1!#REF!","v":{"$error":"#REF!"}},0,1]
[{"$nulls":3},{"$f":"Extraction1!#REF!","v":{"$error":"#REF!"}},{"$f":"IFERROR(VLOOKUP(D6,Parametre!$A$2:$B$292,2,0),\"--\")","v":"--"},"ACTICALL","CASABLANCA",{"$error":"#REF!"},{"$f":"Extraction1!#REF!","v":{"$error":"#REF!"}},{"$f":"Extraction1!#REF!","v":{"$error":"#REF!"}},"",{"$f":"Extraction1!#REF!","v":{"$error":"#REF!"}},0,1]
[{"$nulls":3},{"$f":"Extraction1!#REF!","v":{"$error":"#REF!"}},{"$f":"IFERROR(VLOOKUP(D7,Parametre!$A$2:$B$292,2,0),\"--\")","v":"--"},"ACTICALL","CASABLANCA","mai","2014-05-03",{"$f":"Extraction1!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},"OK",1,1]
[{"$nulls":3},{"$f":"Extraction1!#REF!","v":{"$error":"#REF!"}},{"$f":"IFERROR(VLOOKUP(D8,Parametre!$A$2:$B$292,2,0),\"--\")","v":"--"},"ACTICALL","CASABLANCA",{"$error":"#REF!"},{"$f":"Extraction1!#REF!","v":{"$error":"#REF!"}},{"$f":"Extraction1!#REF!","v":{"$error":"#REF!"}},"",{"$f":"Extraction1!#REF!","v":{"$error":"#REF!"}},0,1]
[{"$nulls":3},{"$f":"Extraction1!#REF!","v":{"$error":"#REF!"}},{"$f":"IFERROR(VLOOKUP(D9,Parametre!$A$2:$B$292,2,0),\"--\")","v":"--"},"ACTICALL","CASABLANCA",{"$error":"#REF!"},{"$f":"Extraction1!#REF!","v":{"$error":"#REF!"}},{"$f":"Extraction1!#REF!","v":{"$error":"#REF!"}},"","KO",1,0]

{"sheet":"Extraction1","index":1,"n_rows":7,"n_cols":32,"rows_kept":7}
[1]
[]
[]
["Date","Conid","Callid","Userid","Firstname","Lastname","Natureappelant","Pollution1","Pollution2","Argumentablevente1","Argumentablevente2","Resultatvente1","Vente Lachaine","Vente Leschaines","Vente Csat1pack","Vente Csat2packs","Vente Minipack","Plateforme","Utilisationbao1","Resultatvente2","couplage",null,"operateur","Preference Marque","Nom","Prenom","Code Postal","Telephone","Email","Numabonne","Commentaire","Dureetraitement"]
["02/05/2014",123,{"v":867601,"d":"867,601"},557,"michel","x","Pollution ","MD",{"$nulls":4},1,{"$nulls":4},"e","Non",{"$f":"COUNTBLANK(M5:P5)","v":3},{"$f":"IF(T5=2,1,0)","v":0},{"$f":"IF(U5=1,\"CSA\",\"\")","v":""},{"$nulls":7},1245]
["02/05/2014",4557,867708,606,"jean","u","Pollution ",null,"Autres",{"$nulls":6},1,null,"y","Non",3,{"$f":"IF(T6=2,1,0)","v":0},{"$f":"IF(U6=1,\"CSA\",\"\")","v":""},{"$nulls":7},54587]
["2014-05-02",4576,{"v":867781,"d":"867,781"},542,"larc","y","Coeur ",null,null,"Oui",null,"OK",null,1,1,null,null,"z","Non",2,1,{"$f":"IF(U7=1,\"CAN\",\"\")","v":"CAN"},{"$nulls":7},5477]

{"sheet":"Parametre","index":2,"n_rows":78,"n_cols":2,"rows_kept":78}
["NOM CC","ID"]
["AGUILOU",1]
["AOUADI",2]
["AZZAT",3]
["BAHDI",4]
["BAHIR",5]
["BAHORI",6]
["BAROU",7]
["BENCHEIKH",8]
["BENHMITI",9]
["BENNANI SMIRES",10]
["BIHI",11]
["BOUDAIR",12]
["BOUHYA",13]
["CHOUKRY",14]
["EL AOUNI",15]
["EL OUTMANI",16]
["ENAN",17]
["FATAH",18]
["FEKRI",19]
["LAMZARA",20]
["LAZRAK TALBII",21]
["MAJDOUBI",22]
["MANSOURI IDRISSI",23]
["MAROUANE",24]
["MBAYE",25]
["MOUNIR",26]
["NAZIH",27]
["NEJJAR",28]
["NGANE",29]
["OUARHOU",30]
["ROUDANI",31]
["SDAIGAI",32]
["TAOUFYQ",33]
["TAOUILI",34]
["YASSIR",35]
["ZAKARIA",36]
["ASSOU",37]
["SMIHI",38]
["ELHLAL",39]
["DNADNI",40]
["SEMMAH",41]
["CHAROT",42]
["SERBOUTI",43]
["AMMI ALAOUI",44]
["RAHI",45]
["BOUZIRE",46]
["ELKHAIR",47]
["MOUHCINE",48]
["CHAAIQ",49]
["JADIL",50]
["BENGHDAIF",51]
["TAKIEDINE",52]
["NAJIHI",53]
["DIALLO",54]
["EL GASS",55]
["NAAM",56]
["BERTAL",57]
["CHARAF",58]
["ELBADRI",59]
["FALL",60]
["FERHAT",61]
["FOUAD ",62]
["JALLAL",63]
["LAHMIDI",64]
["SIDANE ",65]
["LAMRABET",66]
["EL HARTI",67]
["EL HOUDAIGUI",68]
["BARAKAT",69]
["BENHAYOUN",70]
["ISSA SALL",71]
["SAGGAY",72]
["CHOUITEN",73]
["CHERGUI MALIH",74]
["SENE ",75]
["SAGHIR BAHOMAED",76]
["ABAAKIL",77]

{"sheet":"Feuil5","index":3,"n_rows":19,"n_cols":29,"rows_kept":19}
[]
["16/05/2014","1111111111111111",882050,544,"SOUKAINA","OUARHOU","Coeur de flux vente",null,null,"Oui",null,"OK",null,1,1,null,null,"ADSL","Non",{"$f":"COUNTBLANK(M2:P2)","v":2},{"$f":"IF(T2=3,0,1)","v":1},{"$nulls":7},"20068932"]
{"$rows_empty":8}
[{"$nulls":3},"Nombre de N°CLIENT 2"]
[{"$nulls":3},"DATE","MOIS","ID","SITE","PRESTATAIRE","Resultatvente1","Operateure1","Operateure2","Total"]
[{"$nulls":3},"02/05/2014","mai",15,"CASABLANCA","ACTICALL","OK",0,1,1]
[{"$nulls":5},30,"CASABLANCA","ACTICALL","OK",0,1,1]
[{"$nulls":5},32,"CASABLANCA","ACTICALL","OK",1,0,1]
[{"$nulls":3},"2014-05-02","mai",27,"CASABLANCA","ACTICALL","OK",1,0,1]
[{"$nulls":3},"2014-05-04","mai",12,"CASABLANCA","ACTICALL","OK",0,1,1]
[{"$nulls":3},"2014-05-03","mai",47,"CASABLANCA","ACTICALL","OK",1,1,1]
[{"$nulls":3},"Total général",{"$nulls":7},6]

{"sheet":"x","index":4,"n_rows":0,"n_cols":0,"rows_kept":0}