{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["MAGASINS","VISITE","RESULTATS_EQUIPE"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":1,"defined_names":5,"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":20,"rows_kept":12,"cut":false,"hidden":false,"merged":[[0,3,2,8],[0,9,2,14],[0,15,2,19],[3,3,4,8],[3,9,4,14],[3,15,4,19]]}
[null,null,null,"OBJECTIFS MOIS",null,null,null,null,null,"REALISE N-1",null,null,null,null,null,"TACHES RR"]
[]
[]
[null,null,null,"JUILLET 2021",null,null,null,null,null,"JUIN 2020",null,null,null,null,null,{"$f":"D4","v":"JUILLET 2021"}]
["NOM REGION :","COTE D'AZUR"]
["MAGASIN","Email","JOURS","PM","IDV","KERA","TT","FID","ODC","PM","IDV","KERA","TT","FID","ODC","BB","JJ","KK","LL","MM"]
["NICE","1@1.fr",27,25,2.5,0.28999999999999998,0.4,0.7,144,null,null,null,null,null,null,"2021-07-06","2021-07-06",null,"2021-07-06"]
["MARSEILLE","2@2.fr",31,25,2.5,0.28999999999999998,0.4,0.7,180,null,null,null,null,null,null,"2021-07-07","2021-07-07"]
["TOULON","3@3.fr",27,25,2.5,0.28999999999999998,0.4,0.7,240,null,null,null,null,null,null,"2021-06-30"]
["TOULOUSE","4@4.fr",27,25,2.5,0.28999999999999998,0.4,0.7,144,null,null,null,null,null,null,"2021-07-01","2021-07-01",null,"2021-07-01"]
["TOURS","5@5.fr",27,25,2.5,0.28999999999999998,0.4,0.7,144]
["ANGERS","6@6.fr",27,25,2.5,0.28999999999999998,0.4,0.7,240,null,null,null,null,null,null,"2021-07-01","2021-07-01"]

{"sheet":"VISITE","index":1,"n_rows":74,"n_cols":12,"rows_kept":74,"cut":false,"hidden":false,"merged":[[57,11,57,12],[56,11,56,12],[10,8,10,9],[11,8,11,9],[6,8,6,9],[7,8,7,9],[8,8,8,9],[9,8,9,9],[4,3,4,4],[40,11,40,12],[55,11,55,12],[42,11,42,12],[41,11,41,12],[55,1,64,10],[54,1,54,10],[2,2,3,4],[4,5,4,7],[21,1,21,4],[35,7,35,10],[27,1,27,4],[28,1,28,4],[29,1,29,4],[30,1,30,4],[31,1,31,4],[22,1,22,4],[23,1,23,4],[24,1,24,4],[25,1,25,4],[26,1,26,4],[28,7,28,10],[23,7,23,10],[24,7,24,10],[40,1,50,10],[38,1,39,10],[29,7,29,10],[21,7,21,10],[22,7,22,10],[25,7,25,10],[26,7,26,10],[27,7,27,10],[9,0,10,0],[52,0,64,0],[52,1,53,10],[32,1,32,4],[33,1,33,4],[34,1,34,4],[35,1,35,4],[36,1,36,4],[33,7,33,10],[34,7,34,10],[38,0,50,0],[21,0,36,0],[30,7,30,10],[31,7,31,10],[32,7,32,10],[36,7,36,10]]}
[]
[]
[null,null,"TOULOUSE"]
[]
[null,null,"Compte Rendu :",{"$f":"TODAY()","v":"2021-07-27"}]
[]
[null,null,null,null,null,null,null,null,"Moyenne Secteur"]
["MOIS EN COURS","NB JOURS OUVERT","NB JOURS ECOULES","N° Semaine","KK",null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$f":" UPPER(TEXT(TODAY(),\"MMMM AAAA\"))","v":"JUILLET 2021"},{"$f":"VLOOKUP(C3,#REF!,3,FALSE)","v":{"$error":"#REF!"}},{"$f":"DAY(D5-1)","v":26},{"$f":"INT(MOD(INT((D5-2)/7)+0.6,52+5/28))+1","v":30},{"$f":"IFERROR(IF(VLOOKUP(C3,#REF!,16,FALSE)=0,\"\",VLOOKUP(C3,#REF!,16,FALSE)),\"\")","v":""},null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
["OPERATIONS MENSUELLES ","JJ","DD","EE","FF",null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,{"$f":"IFERROR(IF(VLOOKUP(C3,#REF!,17,FALSE)=0,\"\",VLOOKUP(C3,#REF!,17,FALSE)),\"\")","v":""},{"$f":"IFERROR(IF(VLOOKUP(C3,#REF!,18,FALSE)=0,\"\",VLOOKUP(C3,#REF!,18,FALSE)),\"\")","v":""},{"$f":"IFERROR(IF(VLOOKUP(C3,#REF!,19,FALSE)=0,\"\",VLOOKUP(C3,#REF!,19,FALSE)),\"\")","v":""},{"$f":"IFERROR(IF(VLOOKUP(C3,#REF!,20,FALSE)=0,\"\",VLOOKUP(C3,#REF!,20,FALSE)),\"\")","v":""},null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
["INDICATEURS","Objectif Mois",{"$f":"#REF!","v":{"$error":"#REF!"}},"Cible","R/O"]
[1,null,{"$f":"VLOOKUP(C3,#REF!,2,FALSE)","v":{"$error":"#REF!"}},25,{"$f":"(C14-B14)","v":{"$error":"#REF!"}}]
[2,{"$f":"VLOOKUP(C3,#REF!,4,FALSE)","v":{"$error":"#REF!"}},{"$f":"VLOOKUP(C3,#REF!,3,FALSE)","v":{"$error":"#REF!"}},25,{"$f":"(C15-B15)","v":{"$error":"#REF!"}}]
[3,{"$f":"VLOOKUP(C3,#REF!,5,FALSE)","v":{"$error":"#REF!"}},{"$f":"VLOOKUP(C3,#REF!,4,FALSE)","v":{"$error":"#REF!"}},2.5,{"$f":"C16-B16","v":{"$error":"#REF!"}}]
[4,{"$f":"VLOOKUP(C3,#REF!,6,FALSE)","v":{"$error":"#REF!"}},{"$f":"VLOOKUP(C3,#REF!,5,FALSE)","v":{"$error":"#REF!"}},0.28999999999999998,{"$f":"C17-B17","v":{"$error":"#REF!"}}]
[5,{"$f":"VLOOKUP(C3,#REF!,7,FALSE)","v":{"$error":"#REF!"}},{"$f":"VLOOKUP(C3,#REF!,6,FALSE)","v":{"$error":"#REF!"}},0.4,{"$f":"C18-B18","v":{"$error":"#REF!"}}]
[6,{"$f":"VLOOKUP(C3,#REF!,8,FALSE)","v":{"$error":"#REF!"}},{"$f":"VLOOKUP(C3,#REF!,7,FALSE)","v":{"$error":"#REF!"}},"> 70,00%",{"$f":"C19-B19","v":{"$error":"#REF!"}},null,null,{"$f":"IF(ROWS($4:9)<=COUNTIF(RESULTATS_EQUIPE!$A$1:$L$100,$C$3),INDEX(RESULTATS_EQUIPE!A$2:A$500,SMALL(IF(RESULTATS_EQUIPE!$A$1:$L$100=$C$3,ROW(INDIRECT(\"1:\"&ROWS(RESULTATS_EQUIPE!$A$1:$L$100)))),ROWS($4:9))),\"\")","v":""}]
[7,{"$f":"VLOOKUP(C3,#REF!,9,FALSE)","v":{"$error":"#REF!"}},72,{"$f":"B20","v":{"$error":"#REF!"}},{"$f":"(C20/C9)*B9","v":{"$error":"#REF!"}},null,null,{"$f":"IF(ROWS($4:10)<=COUNTIF(RESULTATS_EQUIPE!$A$1:$L$100,$C$3),INDEX(RESULTATS_EQUIPE!A$2:A$500,SMALL(IF(RESULTATS_EQUIPE!$A$1:$L$100=$C$3,ROW(INDIRECT(\"1:\"&ROWS(RESULTATS_EQUIPE!$A$1:$L$100)))),ROWS($4:10))),\"\")","v":""}]
[]
["GESTION MAGASIN","SUIVI POINT DE VENTE",null,null,null,"OK","KO","COMMENTAIRES"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["SYNTHESE","COMMENTAIRES VISITE"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Saisie"]
[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,{"$f":"LEN(B41)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["OBSERVATIONS "]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Saisie"]
[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,{"$f":"LEN(B56)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,{"$error":"#REF!"}]

{"sheet":"RESULTATS_EQUIPE","index":2,"n_rows":28,"n_cols":12,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
["NICE","MARTIN",72.59,"","","",25.3,0,2,1,"",""]
["NICE","DUPONT",46.68,0.2,0.1,18,24.55,0.26219999999999999,2.61,373,28,4]
["NICE","DURAND",78.290000000000006,0.24299999999999999,0.25,51,25.33,0.28470000000000001,2.75,516,34,10]
["NICE","PAUL",79.37,0.129,0.45,41,24.74,0.29399999999999998,2.63,450,18,18]
["NICE","GERARD",61.56,0.45,0.3,40,25.26,0.2467,2.4,436,63,12]
["MARSEILLE","MATHIEU",50.95,0.14000000000000001,"",23,21.16,0.29620000000000002,2.4700000000000002,325,14,""]
["MARSEILLE","PATRICK",54.97,0.26,0.3,44,29.77,0.34310000000000002,2.38,298,26,9]
["MARSEILLE","STEPH",31.84,0.12,3.3000000000000002E-2,14,25.41,0.27179999999999999,2.52,203,12,1]
["MARSEILLE","GERALDINE","",0.06,3.3000000000000002E-2,2,23.29,0.15409999999999999,2.27,98,6,1]
["TOULON","HENRI",61.71,6.7000000000000004E-2,0.371,32,27.42,0.2979,2.58,300,8,13]
["TOULON","FRANCK",60.21,5.8000000000000003E-2,"",28,24.09,0.29289999999999999,2.36,222,7,""]
["TOULON","FRANCIS",66.569999999999993,8.3000000000000004E-2,2.9000000000000001E-2,26,26.9,0.25580000000000003,2.56,405,10,1]
["TOULON","JACQUES",38.950000000000003,9.1999999999999998E-2,2.9000000000000001E-2,15,20.91,0.29310000000000003,2.2999999999999998,314,11,1]
["TOULON","BERNARD","","","","",15,0.14000000000000001,2,1,"",""]
["TOULOUSE","JEAN FRANCOIS",47.51,0.2,0.114,30,23.72,0.2525,2.48,337,24,4]
["TOULOUSE","JEAN JACQUES",47.86,2.5000000000000001E-2,"","",22.61,0.1673,2.41,86,3,""]
["TOULOUSE","MICHEL",53.43,5.8000000000000003E-2,0.48599999999999999,63,24.38,0.28799999999999998,2.41,352,7,17]
["TOULOUSE","NATHALIE",34.42,0.14599999999999999,0.125,24,25.21,0.32629999999999998,2.77,194,12,3]
["TOULOUSE","PRISCILLIA",24.33,8.3000000000000004E-2,2.9000000000000001E-2,21,28.11,0.24079999999999999,2.64,190,10,1]
["TOURS","FLORENT",48.42,7.4999999999999997E-2,5.7000000000000002E-2,57,25.87,0.4199,2.72,180,9,2]
["TOURS","ANAIS",46.18,0.35,0.65700000000000003,44,24.37,0.3362,2.68,244,42,23]
["TOURS","MAXIME",50.47,0.55800000000000005,0.45700000000000002,72,24.53,0.26040000000000002,2.39,275,67,16]
["TOURS","CAMILLE",36.94,0.70799999999999996,0.74299999999999999,69,26.65,0.2848,2.5499999999999998,239,85,26]
["ANGERS","EMILIE","","","","",0,0,0,0,"",""]
["ANGERS","STEPHANIE",81.010000000000005,0.05,0.125,24,19.010000000000002,0.317,2.2000000000000002,357,7,5]
["ANGERS","LAURENT",89.53,0.20699999999999999,0.17499999999999999,47,18.329999999999998,0.3226,2.12,701,29,7]
["ANGERS","DANIEL","",8.5999999999999993E-2,0.375,57,17.87,0.33160000000000001,2.1,603,12,15]
["ANGERS","KARINE",68.42,0.40699999999999997,2.5000000000000001E-2,29,20.100000000000001,0.2863,2.1800000000000002,503,57,1]