{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["DONNEES","Tableau de Bord"],"not_rendered":{"charts":1,"images":0,"macros":0,"external_links":1,"defined_names":37,"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":"DONNEES","index":0,"n_rows":48,"n_cols":20,"rows_kept":48,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,"PRODUIT","Totalgénéral","AUTRE DD","DD","GROS","PRESTIGE","PROMOTION","SUBD ",null,null,null,null,"Indicateurs","Realisation",null,null,null,"CANAL","T .ventes"]
[null,"Boisson0.25l",{"$f":"SUM(ventes[[#This Row],[AUTRE DD]:[SUBD ]])","v":1867399.0585370001},19764.70608,1359388.2488880004,405680.66994000005,0,6007.4504209999996,76557.983208000005,null,null,null,null,"Résultat",21083142.719999999,null,null,null,"DD",{"$f":"SUM(ventes[DD])","v":299402341.28790307}]
[null,"Canette 33 cl",{"$f":"SUM(ventes[[#This Row],[AUTRE DD]:[SUBD ]])","v":82543203.998327017},360867.12004800019,27598142.189980999,17554973.009011008,120191.59713600003,107628.609791,36801401.47236,null,null,null,null,"Ventes",{"$f":"SUM(ventes[Totalgénéral])","v":650019314.88687694},null,null,null,"SUBD",{"$f":"SUM(ventes[[SUBD ]])","v":235598274.982306}]
[null,"Confiture",{"$f":"SUM(ventes[[#This Row],[AUTRE DD]:[SUBD ]])","v":7266334.7050709957},516519.32832000015,5823435.305588996,339039.91586200002,0,211987.47113600001,375352.68416399998,null,null,null,null,null,null,null,null,null,"GROS",{"$f":"SUM(ventes[GROS])","v":103728854.05522303}]
[null,"Eaux Minerale",{"$f":"SUM(ventes[[#This Row],[AUTRE DD]:[SUBD ]])","v":1228998.1562479998},0,1101561.1775839999,109285.71760800001,0,18151.261055999999,0,null,null,null,null,null,null,null,null,null,"AUTRE DD",{"$f":"SUM(ventes[AUTRE DD])","v":8604353.0505379997}]
[null,"Harissa",{"$f":"SUM(ventes[[#This Row],[AUTRE DD]:[SUBD ]])","v":1052420.607265},87126.050304000004,900169.74805199995,24719.327856000004,0,22960.102812999998,17445.378239999998,null,null,null,null,"Marge d'exploitation",{"$f":"O5/O6","v":3.2434640382446332E-2},null,null,null,"PRESTIGE",{"$f":"SUM(G5:G19)","v":1484315.2555079991}]
[null,"LAIT",{"$f":"SUM(ventes[[#This Row],[AUTRE DD]:[SUBD ]])","v":9179208},125460,7830743,663649,0,5850,553506,null,null,null,null,null,null,null,null,null,"PROMOTION",{"$f":"SUM(ventes[PROMOTION])","v":1201176.2553989999}]
[null,"PET 1.5L",{"$f":"SUM(ventes[[#This Row],[AUTRE DD]:[SUBD ]])","v":40956928.078478992},234151.26173999999,22567553.06028299,6391956.2940229988,54453.781799999997,96118.852992999993,11612694.827640004]
[null,"Pet 1l",{"$f":"SUM(ventes[[#This Row],[AUTRE DD]:[SUBD ]])","v":109215159.051915},659997.28799100011,39585115.237219021,13225133.620791005,135126.05039999998,124848.89122399999,55484937.964289986]
[null,"Pet 1l carton jetable",{"$f":"SUM(ventes[[#This Row],[AUTRE DD]:[SUBD ]])","v":1949757.5313439996},68571.428207999983,1329828.0472679997,307478.15101799998,14369.747939999999,1571.78891,227938.36800000002]
[null,"Pet 2l",{"$f":"SUM(ventes[[#This Row],[AUTRE DD]:[SUBD ]])","v":166886859.00717795},899332.36157199997,55610759.44124797,18748201.488201007,387226.89023999992,128890.22921700001,91112448.596699998]
[null,"Pet 33 cl",{"$f":"SUM(ventes[[#This Row],[AUTRE DD]:[SUBD ]])","v":33908963.215526998},75963.024720000016,15699283.933304001,7233180.2439040001,9378.1512000000002,21441.512535000002,10869716.349864]
[null,"Tpk 100cl",{"$f":"SUM(ventes[[#This Row],[AUTRE DD]:[SUBD ]])","v":114481783.26931703},3846186.8372520008,75561175.776976034,19308464.806950003,637694.1187919993,163032.762907,14965228.96644,null,null,null,null,"Mois","Ventes N","Objectif N","Année N-1"]
[null,"Tpk 20 cl",{"$f":"SUM(ventes[[#This Row],[AUTRE DD]:[SUBD ]])","v":66576838.368310004},1547556.5016629994,38120934.029087998,16181404.395517005,125874.91799999995,157522.10905199999,10443546.414989997,null,null,null,null,"Janvier",33263041.98,35000000,0]
[null,"Triple concentré",{"$f":"SUM(ventes[[#This Row],[AUTRE DD]:[SUBD ]])","v":4572486.3216509996},148941.17627199998,2439563.0219589993,1256715.9663180001,0,87211.393092000013,640054.76401000004,null,null,null,null,"Février",46487894.399999999,36000000,0]
[null,"PET 0.25 L ",{"$f":"SUM(ventes[[#This Row],[AUTRE DD]:[SUBD ]])","v":8332975.5177080017},13915.966368000001,3874689.0704640006,1978971.4482240002,0,47953.820251999998,2417445.2124000001,null,null,null,null,"Mars",52584348.780000001,38000000,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Avril",58465526.289999999,40000000,0]
[null,null,{"$f":"+SUM(ventes[Totalgénéral])","v":650019314.88687694},null,null,null,null,null,null,null,null,null,null,"Mai",64694020.600000001,45000000,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Juin",30449460.690000001,40000000,53072075.799999997]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Juillet",97617823.930000007,80000000,50868751.079999998]
[null,"Pet 2l",166886859.00717801,{"$f":"(C24/$C$39)*100","v":25.674138473288505},null,null,null,null,null,null,null,null,null,"Août",102060868.44,75000000,69501693.519999996]
[null,"Tpk 100cl",114481783.26931703,{"$f":"(C25/$C$39)*100","v":17.61205869540051},null,null,null,null,null,null,null,null,null,"Septembre",83029796.060000002,80000000,54661955.520000003]
[null,"Pet 1l",109215159.051915,16.801832891830568,null,null,null,null,null,null,null,null,null,"Octobre",57435860.340000004,60000000,49039607.82]
[null,"Canette 33 cl",82543203.998327017,12.698577120387883,null,null,null,null,null,null,null,null,null,"Novembre",0,45000000,40380555.509999998]
[null,"Tpk 20 cl",66576838.368310004,10.242286166511281,null,null,null,null,null,null,null,null,null,"Décembre",0,38000000,34221039.729999997]
[null,"PET 1.5L",40956928.078478992,6.3008786262923184,null,null,null,null,null,null,null,null,null,"Totaux",{"$f":"SUM(O17:O28)","v":626088641.51000011},{"$f":"SUM(P17:P28)","v":612000000}]
[null,"Pet 33 cl",33908963.215526998,5.2166085589976943]
[null,"LAIT",9179208,1.4121438840009639]
[null,"PET 0.25 L ",8332975.5177080017,1.2819581398374589]
[null,"Confiture",7266334.7050709957,1.1178644293570812]
[null,"Triple concentré",4572486.3216509996,0.70343853127606693]
[null,"Pet 1l carton jetable",1949757.5313439996,0.29995378393999206,null,null,null,null,null,null,null,null,null,"% de la marge d'exploitation (entre 0 et 100)"]
[null,"Boisson0.25l",1867399.0585370001,0.28728362615839875]
[null,"Eaux Minerale",1228998.1562479998,0.18907102113756152,null,null,null,null,null,null,null,null,null,"Zone verte",33]
[null,"Harissa",1052420.607265,0.16190605158373689,null,null,null,null,null,null,null,null,null,"Zone orange",33]
[null,null,{"$f":"+SUM(C24:C38)","v":650019314.88687694},{"$f":"SUM(D24:D38)","v":100.00000000000003},null,null,null,null,null,null,null,null,null,"Zone rouge",33]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Zone invisible",{"$f":"SUM(O37:O39)","v":99}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Valeur aiguille",15]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Largeur aiguille",1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Invisible",{"$f":"SUM(O37:O40)-(O43+O42)","v":182}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Valeur Invisible1"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Valeur aiguille",{"$f":"O42&\"%\"","v":"15%"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Valeur Invisible2"]

{"sheet":"Tableau de Bord","index":1,"n_rows":7,"n_cols":17,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"M3/M4","v":1.0230206560620916},null,null,null,4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VenteObjectif[[#Totals],[Ventes N]]","v":626088641.51000011},null,null,null,"Objectif"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VenteObjectif[[#Totals],[Objectif N]]","v":612000000},null,null,null,"Année N-1"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(liste,ControlCourbe)","v":"Objectif"}]