{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["MAGASINS","VISITE","STATS_EQUIPE"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":1,"defined_names":8,"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":"MAGASINS","index":0,"n_rows":12,"n_cols":15,"rows_kept":12,"cut":false,"hidden":false,"merged":[[0,9,2,14],[3,9,4,14],[0,3,2,8],[3,3,4,8]]}
[null,null,null,"OBJECTIFS MOIS",null,null,null,null,null,"REALISE N-1"]
[]
[]
[null,null,null,"AOUT 2021",null,null,null,null,null,"AOUT 2020"]
["NOM REGION :","abe"]
["MAGASIN","Email","JOURS","PM","IDV","KERA","TT","FID","ODM","PM","IDV","KERA","TT","FID","ODC"]
["TNL","&",27,25,2.5,0.28999999999999998,0.4,0.7,400]
["CAP","é",31,25,2.5,0.28999999999999998,0.4,0.7,800]
["LIN","\"",27,25,2.5,0.28999999999999998,0.4,0.7,700]
["OLL","",27,25,2.5,0.28999999999999998,0.4,0.7,400]
["MAY","(",27,25,2.5,0.28999999999999998,0.4,0.7,400]
["TGV",{"$f":"-B13è","v":{"$error":"#NAME?"}},27,25,2.5,0.28999999999999998,0.4,0.7,600]

{"sheet":"VISITE","index":1,"n_rows":81,"n_cols":15,"rows_kept":81,"cut":false,"hidden":false,"merged":[[43,7,43,11],[64,1,73,11],[61,1,63,11],[44,7,44,11],[45,7,45,11],[47,1,48,11],[49,1,59,11],[38,7,38,11],[39,7,39,11],[40,7,40,11],[41,7,41,11],[42,7,42,11],[66,14,67,15],[9,0,10,0],[49,14,49,15],[50,14,50,15],[51,14,52,15],[64,14,64,15],[21,0,21,11],[40,1,40,4],[30,7,30,11],[31,7,31,11],[32,7,32,11],[33,7,33,11],[65,14,65,15],[34,7,34,11],[35,7,35,11],[36,7,36,11],[82,2,82,3],[61,0,73,0],[41,1,41,4],[42,1,42,4],[43,1,43,4],[44,1,44,4],[45,1,45,4],[47,0,59,0],[30,0,45,0],[34,1,34,4],[35,1,35,4],[81,2,81,3],[79,2,79,3],[80,2,80,3],[38,1,38,4],[39,1,39,4],[2,2,3,4],[4,5,4,7],[30,1,30,4],[36,1,36,4],[37,1,37,4],[31,1,31,4],[32,1,32,4],[33,1,33,4],[4,3,4,4],[37,7,37,11]]}
[null,null,null,null,null,null,null,null,null,null,null,null,"  "]
[]
[null,null,"OLL"]
[]
[null,null,"Compte Rendu :",{"$f":"TODAY()","v":"2021-08-25"}]
[]
[]
["MOIS EN COURS","NB JOURS OUVERT","NB JOURS ECOULES","N° Semaine","CONTR OFFRES"]
[{"$f":" UPPER(TEXT(TODAY(),\"MMMM AAAA\"))","v":"AOÛT 2021"},{"$f":"VLOOKUP(C3,MAGASINS!A7:O16,3,FALSE)","v":27},{"$f":"DAY(D5-1)","v":24},{"$f":"INT(MOD(INT((D5-2)/7)+0.6,52+5/28))+1","v":34},{"$f":"IFERROR(IF(VLOOKUP(C3,MAGASINS!A7:O16,16,FALSE)=0,\"\",VLOOKUP(C3,MAGASINS!A7:O16,16,FALSE)),\"\")","v":""}]
["OPERATIONS MENSUELLES RESPONSABLE REGIONAL","DEFECTEUX","TICKETS KADEOS","CONTRÔLE COFFRE","FIN DE MOIS"]
[null,{"$f":"IFERROR(IF(VLOOKUP(C3,MAGASINS!A7:O16,17,FALSE)=0,\"\",VLOOKUP(C3,MAGASINS!A7:O16,17,FALSE)),\"\")","v":""},{"$f":"IFERROR(IF(VLOOKUP(C3,MAGASINS!A7:O16,18,FALSE)=0,\"\",VLOOKUP(C3,MAGASINS!A7:O16,18,FALSE)),\"\")","v":""},{"$f":"IFERROR(IF(VLOOKUP(C3,MAGASINS!A7:O16,19,FALSE)=0,\"\",VLOOKUP(C3,MAGASINS!A7:O16,19,FALSE)),\"\")","v":""},{"$f":"IFERROR(IF(VLOOKUP(C3,MAGASINS!A7:O16,20,FALSE)=0,\"\",VLOOKUP(C3,MAGASINS!A7:O16,20,FALSE)),\"\")","v":""}]
[]
["INDICATEURS","Objectif Mois",{"$f":"#REF!","v":{"$error":"#REF!"}},"Cible","R/O","Secteur"]
["AB",null,{"$f":"VLOOKUP(C3,#REF!,3,FALSE)","v":{"$error":"#REF!"}},1,{"$f":"(C14-B14)","v":{"$error":"#REF!"}}]
["CV",1,{"$f":"VLOOKUP(C3,#REF!,4,FALSE)","v":{"$error":"#REF!"}},2,{"$f":"(C15-B15)","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
["ER",2,{"$f":"VLOOKUP(C3,#REF!,5,FALSE)","v":{"$error":"#REF!"}},3,{"$f":"C16-B16","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
["TY",0.03,{"$f":"VLOOKUP(C3,#REF!,7,FALSE)","v":{"$error":"#REF!"}},0.04,{"$f":"C17-B17","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
["IJ",0.04,{"$f":"VLOOKUP(C3,#REF!,9,FALSE)","v":{"$error":"#REF!"}},0.05,{"$f":"C18-B18","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
["RF",0.05,{"$f":"VLOOKUP(C3,#REF!,10,FALSE)","v":{"$error":"#REF!"}},6,{"$f":"C19-B19","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
["TG",6,{"$f":"E29","v":0},{"$f":"B20","v":6},{"$f":"(C20/C9)*B9","v":0}]
[]
[{"$f":"\"RESULTATS INDIVIDUELS BOUTIQUE DE \"&C3&\"\"","v":"RESULTATS INDIVIDUELS BOUTIQUE DE OLL"}]
[{"$f":"STATS_EQUIPE!B2","v":"MEMBRE"},{"$f":"STATS_EQUIPE!C2","v":"PR"},{"$f":"STATS_EQUIPE!D2","v":"EP"},{"$f":"STATS_EQUIPE!E2","v":"VL"},{"$f":"STATS_EQUIPE!F2","v":"ODM"},{"$f":"STATS_EQUIPE!H2","v":"PM"},{"$f":"STATS_EQUIPE!I2","v":"KJ"},{"$f":"STATS_EQUIPE!J2","v":"II"},{"$f":"STATS_EQUIPE!K2","v":"NB"},{"$f":"STATS_EQUIPE!M2","v":"CA"},{"$f":"STATS_EQUIPE!N2","v":"EP"}]
[]
[]
[]
[]
[]
[]
[]
["GESTION MAGASIN","SUIVI POINT DE VENTE",null,null,null,"OK","KO","COMMENTAIRES"]
[null,"AA"]
[null,"BB"]
[null,"CC"]
[null,"DD"]
[null,"EE"]
[null,"FF"]
[null,"GG"]
[null,"HH"]
[null,"II"]
[null,"JJ"]
[null,"KK"]
[null,"LL"]
[null,"MM"]
[null,"NN"]
[null,"OO"]
[]
["SYNTHESE","COMMENTAIRES"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Saisie"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Limitée à 500 Carractères"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"LEN(B50)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["OBSERVATIONS ","COMMENTAIRES PERSONNELS RESPONSABLE REGIONAL"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Saisie"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Limitée à 500 Carractères"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"LEN(B65)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Le Compte Rendu va être envoyé à :",null,{"$f":"C3","v":"OLL"}]
["L'adresse d'envoi est :",null,{"$f":"VLOOKUP(C3,MAGASINS!A7:O16,2,FALSE)","v":""}]

{"sheet":"STATS_EQUIPE","index":2,"n_rows":33,"n_cols":15,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
["RESULTATS AU",{"$f":"[1]Menu!$E$3","v":"2021-08-25"}]
["LIEU","MEMBRE","PR","EP","VL",{"$f":"'[1]Compte Rendu Performance Equipe'!$H$1","v":"ODM"},null,{"$f":"'[1]Compte Rendu Performance Equipe'!$J$1","v":"PM"},"KJ","II","NB",null,{"$f":"'[1]Compte Rendu Performance Equipe'!$O$1","v":"CA"},"EP","VLC"]
["CAP","AZ",95.97,"","",9,null,27.72,0.34510000000000002,2.85,13,null,360.3,"",""]
["CAP","RT","",1.6E-2,"",37,null,22.59,0.2296,2.4700000000000002,210,null,4760.12,2,""]
["CAP","Y",119.59,0.504,"",221,null,25.49,0.317,2.73,674,null,18245.310000000001,63,""]
["CAP","UI",106.64,0.28799999999999998,"",167,null,25.42,0.29360000000000003,2.58,622,null,16378.19,36,""]
["CAP","DC",7.46,3.2000000000000001E-2,"",10,null,32.86,0.29599999999999999,3.1,42,null,1386.07,4,""]
["CAP","VB","","","","",null,23.52,0.28660000000000002,2.5499999999999998,426,null,10142.83,"",""]
["CAP","N",95.13,0.68799999999999994,"",158,null,27.12,0.24490000000000001,2.48,642,null,19504.28,86,""]
["OLL","E",29.96,9.5000000000000001E-2,"",50,null,26.59,0.20119999999999999,2.4500000000000002,227,null,6569.84,9,""]
["OLL","RT",24.04,5.2999999999999999E-2,"",34,null,32.86,0.29599999999999999,3.1,42,null,1386.07,5,""]
["OLL","TY",55.83,0.26300000000000001,"",59,null,23.33,0.26840000000000003,2.42,426,null,10526.01,25,""]
["OLL","E",72.22,0.221,"",92,null,23.52,0.28660000000000002,2.5499999999999998,426,null,10142.83,21,""]
["TGV","D","","","","",null,0,0,0,0,null,0,"",""]
["TGV","SFD",73.069999999999993,1.7999999999999999E-2,0.33300000000000002,22,null,25.32,0.36049999999999999,2.54,189,null,4873.21,2,1]
["TGV","RT",67.34,0.33600000000000002,"",76,null,30.75,0.2787,2.97,347,null,10750.31,37,""]
["TGV","FDGF",49.93,9.0999999999999998E-2,"",42,null,22.98,0.2959,2.4,320,null,7436.96,10,""]
["TGV","JKJHK",19.8,1.7999999999999999E-2,"",14,null,18.690000000000001,0.38829999999999998,2.2799999999999998,126,null,2375.39,2,""]
["TGV","DSDF",73.33,9.0999999999999998E-2,"",77,null,21.46,0.32119999999999999,2.5,470,null,10218.23,10,""]
["TNL","EREZR",55.09,0.318,0.33300000000000002,125,null,25.51,0.27279999999999999,2.58,461,null,11879.79,35,1]
["TNL","FGGFD",60.29,8.9999999999999993E-3,"",1,null,21.31,0.20069999999999999,2.13,64,null,1372.36,1,""]
["TNL","ERER",26.83,0.127,"",73,null,24.86,0.30669999999999997,2.75,189,null,4725.09,14,""]
["TNL","DSDF","","","","",null,0,0,0,0,null,0,"",""]
["TNL","REZRE",99.71,0.38200000000000001,"",127,null,24.74,0.29830000000000001,2.4500000000000002,592,null,14793.51,42,""]
["LIN","XWCXW",71.53,0.82699999999999996,"",190,null,31.23,0.27779999999999999,2.83,334,null,10516.13,91,""]
["LIN","FGFD",20.63,"","","",null,27.22,0.4002,3,364,null,9992.41,"",""]
["LIN","TYTR","","","","",null,0,0,0,0,null,0,"",""]
["LIN","YTRYY",70.349999999999994,1.0820000000000001,"",209,null,24.89,0.29759999999999998,2.72,346,null,8670.39,119,""]
["MAY","TYTRY","","","","",null,0,0,0,0,null,0,"",""]
["MAY","EREZR",90.49,1.6E-2,"",26,null,21.37,0.2858,2,186,null,3987.51,2,""]
["MAY","ERE",138.78,0.112,"",131,null,17.91,0.39450000000000002,2.14,965,null,17344.78,14,""]
["MAY","YTYTRY",104.54,0.2,"",111,null,18.18,0.36080000000000001,2.1,765,null,13971.29,25,""]
["MAY","VBV",27.45,1.6E-2,"",28,null,22.32,0.29659999999999997,2.29,191,null,4311.54,2,""]