{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["DONNEES","Tableau de Bord","compteur","Feuil1","Feuil3","Gauge"],"not_rendered":{"charts":10,"images":3,"macros":1,"external_links":1,"defined_names":40,"comments":0,"pivot_tables":1},"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":93,"n_cols":25,"rows_kept":93,"cut":false,"hidden":false,"merged":[[75,1,75,8],[53,1,53,7],[75,10,75,17],[53,10,53,17]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"U3/U4","v":1.0230206560620916},null,null,null,4]
[null,12,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,null,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,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,null,null,null,null,null,null,null,null,{"$f":"INDEX(liste,ControlCourbe)","v":"Année N-1"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Ventes"]
[null,{"$f":"Y7","v":"Année N-1"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Produit","Totalgénéral",null,"AUTRE DD",null,"DD",null,"GROS",null,"PRESTIGE",null,"PROMOTION",null,"SUBD "]
[null,{"$f":"INDIRECT(\"DONNEES!B\"&(5+'Tableau de Bord'!Y1))","v":"Harissa"},{"$f":"INDIRECT(\"DONNEES!C\"&(5+Y1))","v":1052420.607265},{"$f":"C41","v":1052420.607265},{"$f":"INDIRECT(\"DONNEES!D\"&(5+Y1))","v":87126.050304000004},{"$f":"E41","v":87126.050304000004},{"$f":"INDIRECT(\"DONNEES!E\"&(5+Y1))","v":900169.74805199995},{"$f":"G41","v":900169.74805199995},{"$f":"INDIRECT(\"DONNEES!F\"&(5+Y1))","v":24719.327856000004},{"$f":"I41","v":24719.327856000004},{"$f":"INDIRECT(\"DONNEES!G\"&(5+Y1))","v":0},{"$f":"K41","v":0},{"$f":"INDIRECT(\"DONNEES!H\"&(5+Y1))","v":22960.102812999998},{"$f":"M41","v":22960.102812999998},{"$f":"INDIRECT(\"DONNEES!I\"&(5+Y1))","v":17445.378239999998},{"$f":"O41","v":17445.378239999998}]
[null,{"$f":"INDEX(ListeProduit,MATCH(B41,ListeProduit,0)+1)","v":"LAIT"},{"$f":"INDEX(Total_général,MATCH(C41,Total_général,0)+1)","v":9179208},9179208,{"$f":"INDEX(AUTRE_DD,MATCH(E41,AUTRE_DD,0)+1)","v":125460},125460,{"$f":"INDEX(DD,MATCH(G41,DD,0)+1)","v":7830743},7830743,{"$f":"INDEX(GROS,MATCH(I41,GROS,0)+1)","v":663649},663649,{"$f":"INDEX(PRESTIGE,MATCH(K41,PRESTIGE,0)+1)","v":120191.59713600003},120191.59713600003,{"$f":"INDEX(PROMOTION,MATCH(M41,PROMOTION,0)+1)","v":5850},5850,{"$f":"INDEX(SUBD,MATCH(O41,SUBD,0)+1)","v":553506},553506]
[null,"PET 1.5L",40956928.078478992,40956928.078478992,{"$f":"INDEX(AUTRE_DD,MATCH(E42,AUTRE_DD,0)+1)","v":234151.26173999999},234151.26173999999,22567553.06028299,22567553.06028299,6391956.2940229988,6391956.2940229988,0,0,96118.852992999993,96118.852992999993,11612694.827640004,11612694.827640004]
[null,"Pet 1l",109215159.051915,109215159.051915,{"$f":"INDEX(AUTRE_DD,MATCH(E43,AUTRE_DD,0)+1)","v":659997.28799100011},659997.28799100011,39585115.237219021,39585115.237219021,13225133.620791005,13225133.620791005,120191.59713600003,120191.59713600003,124848.89122399999,124848.89122399999,55484937.964289986,55484937.964289986]
[null,"Pet 1l carton jetable",1949757.5313439996,1949757.5313439996,{"$f":"INDEX(AUTRE_DD,MATCH(E44,AUTRE_DD,0)+1)","v":68571.428207999983},68571.428207999983,1329828.0472679997,1329828.0472679997,307478.15101799998,307478.15101799998,0,0,1571.78891,1571.78891,227938.36800000002,227938.36800000002]
[null,"Pet 2l",166886859.00717795,166886859.00717795,null,0,55610759.44124797,55610759.44124797,18748201.488201007,18748201.488201007,120191.59713600003,120191.59713600003,128890.22921700001,128890.22921700001,91112448.596699998,91112448.596699998]
[null,"Pet 33 cl",33908963.215526998,33908963.215526998,{"$f":"INDEX(AUTRE_DD,MATCH(E46,AUTRE_DD,0)+1)","v":87126.050304000004},87126.050304000004,15699283.933304001,15699283.933304001,7233180.2439040001,7233180.2439040001,0,0,21441.512535000002,21441.512535000002,10869716.349864,10869716.349864]
[null,"Tpk 100cl",114481783.26931703,114481783.26931703,{"$f":"INDEX(AUTRE_DD,MATCH(E47,AUTRE_DD,0)+1)","v":125460},125460,75561175.776976034,75561175.776976034,19308464.806950003,19308464.806950003,120191.59713600003,120191.59713600003,163032.762907,163032.762907,14965228.96644,14965228.96644]
[null,"Tpk 20 cl",66576838.368310004,66576838.368310004,{"$f":"INDEX(AUTRE_DD,MATCH(E48,AUTRE_DD,0)+1)","v":234151.26173999999},234151.26173999999,38120934.029087998,38120934.029087998,16181404.395517005,16181404.395517005,0,0,157522.10905199999,157522.10905199999,10443546.414989997,10443546.414989997]
[null,"Triple concentré",4572486.3216509996,4572486.3216509996,{"$f":"INDEX(AUTRE_DD,MATCH(E49,AUTRE_DD,0)+1)","v":659997.28799100011},659997.28799100011,2439563.0219589993,2439563.0219589993,1256715.9663180001,1256715.9663180001,120191.59713600003,120191.59713600003,87211.393092000013,87211.393092000013,640054.76401000004,640054.76401000004]
[]
[]
[]
[null,"Performance des ventes réelles (%)",null,null,null,null,null,null,null,null,"Ecart Ventes réelles Vs Objectifs\n"]
[null,"Aout",{"$f":"\"Objectif:\"&Feuil1!H7","v":"Objectif:75000000"},{"$f":"\"Vente réelle:\"&Feuil1!H8","v":"Vente réelle:103039876,202642"},null,{"$f":"\"Ecart:\"","v":"Ecart:"},{"$f":"Feuil1!H9","v":37.386501603522696},"%"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Vente Par Produit",null,null,null,null,null,null,null,null,"Vente Par Canal"]
[null,"Produits","part dans CA"]
[]
[null,"Pet 2l",{"$f":"DONNEES!D24","v":25.674138473288505}]
[null,"Tpk 100cl",{"$f":"DONNEES!D25","v":17.61205869540051}]
[null,"Pet 1l",{"$f":"DONNEES!D26","v":16.801832891830568}]
[null,"Canette 33 cl",{"$f":"DONNEES!D27","v":12.698577120387883}]
[null,"Tpk 20 cl",{"$f":"DONNEES!D28","v":10.242286166511281}]
[null,"PET 1.5L",{"$f":"DONNEES!D29","v":6.3008786262923184}]
[null,"Pet 33 cl",{"$f":"DONNEES!D30","v":5.2166085589976943}]
[null,"LAIT",{"$f":"DONNEES!D31","v":1.4121438840009639}]
[null,"PET 0.25 L ",{"$f":"DONNEES!D32","v":1.2819581398374589}]
[null,"Confiture",{"$f":"DONNEES!D33","v":1.1178644293570812}]
[null,"Triple concentré",{"$f":"DONNEES!D34","v":0.70343853127606693}]
[null,"Pet 1l carton jetable",{"$f":"DONNEES!D35","v":0.29995378393999206}]
[null,"Boisson0.25l",{"$f":"DONNEES!D36","v":0.28728362615839875}]
[null,"Eaux Minerale",{"$f":"DONNEES!D37","v":0.18907102113756152}]
[null,"Harissa",{"$f":"DONNEES!D38","v":0.16190605158373689}]

{"sheet":"compteur","index":2,"n_rows":27,"n_cols":3,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Zone verte",33]
[null,"Zone orange",33]
[null,"Zone rouge",33]
[null,"Zone invisible",{"$f":"SUM(C16:C18)","v":99}]
[]
[null,"Valeur aiguille",3]
[null,"Largeur aiguille",1]
[null,"Invisible",{"$f":"SUM(C16:C19)-(C22+C21)","v":194}]
[]
[null,"Valeur Invisible1"]
[null,"Valeur aiguille",{"$f":"DONNEES!O9","v":3.2434640382446332E-2}]
[null,"Valeur Invisible2"]

{"sheet":"Feuil1","index":3,"n_rows":30,"n_cols":8,"rows_kept":30,"cut":false,"hidden":false,"merged":[[4,1,4,3],[4,6,4,7],[12,6,12,7],[18,1,18,2]]}
[]
[]
[]
[]
[null,"Table 1 -  Performance des ventes",null,null,null,null,"Table 2 - Selected Sales rep"]
[null,"Mois","Objectif","ventes réelles","Ecart",null,"Mois",{"$f":"'Tableau de Bord'!B55","v":"Aout"}]
[null,"Janvier",35000000,34568468.895985,{"$f":"(D7-C7)","v":-431531.10401500016},null,"Objectif",{"$f":"VLOOKUP($H$6,$B$7:$D$16,2,FALSE)","v":75000000}]
[null,"Fevrier",36000000,46544005.823442005,{"$f":"(D8-C8)","v":10544005.823442005},null,"ventes réelles",{"$f":"VLOOKUP($H$6,$B$7:$D$16,3,FALSE)","v":103039876.20264202}]
[null,"Mars",38000000,52697942.931878015,14697942.931878015,null,"Ecart(réelle/ objectif) (%)",{"$f":"((H8-H7)/H7)*100","v":37.386501603522696}]
[null,"Avril",40000000,60777235.527070001,20777235.527070001]
[null,"Mai",45000000,67292181.324409008,22292181.324409008]
[null,"Juin",40000000,31315282.207122996,-8684717.7928770036]
[null,"Juillet",80000000,98070910.033525988,18070910.033525988,null,"Table 4 - Ticker settings"]
[null,"Aout",75000000,103039876.20264202,28039876.202642024,null,"Actual /Plan (%) (modified)",{"$f":"H9-1","v":36.386501603522696}]
[null,"Septembre",80000000,85114140.337568015,5114140.3375680149,null,"Ticker",2]
[null,"Octobre",60000000,61557722.341312006,1557722.3413120061,null,"Rest value",{"$f":"C24-H15-H14","v":141.6134983964773}]
[null,"Total",{"$f":"SUM(C7:C16)","v":529000000},{"$f":"SUM(D7:D16)","v":640977765.62495506},null,null,"Total",{"$f":"SUM(H14:H16)","v":180}]
[]
[null,"Table 3 - Zone settings"]
[null,"Red Zone",20,null,null,null,"Mois",{"$f":"E6","v":"Ecart"}]
[null,"Orange Zone",30,null,null,null,"Janvier",{"$f":"E7","v":-431531.10401500016}]
[null,"Green Zone",70,null,null,null,"Fevrier",10544005.823442005]
[null,"Hidden Zone",60,null,null,null,"Mars",14697942.931878015]
[null,"Total",{"$f":"SUM(C20:C23)","v":180},null,null,null,"Avril",20777235.527070001]
[null,null,null,null,null,null,"Mai",22292181.324409008]
[null,null,null,null,null,null,"Juin",-8684717.7928770036]
[null,null,null,null,null,null,"Juillet",18070910.033525988]
[null,null,null,null,null,null,"Aout",28039876.202642024]
[null,null,null,null,null,null,"Septembre",5114140.3375680149]
[null,null,null,null,null,null,"Octobre",1557722.3413120061]

{"sheet":"Feuil3","index":4,"n_rows":67,"n_cols":14,"rows_kept":67,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Année",2017]
[null,null,"Année","Mois","Canal","objectif","ventes réelles"]
[null,null,2017,"Janvier","Autre DD",800000,760309.91694199992,null,"Étiquettes de lignes","Somme de objectif","Somme de ventes réelles",null,null,{"$f":"(34568468.9-35000000)/35000000","v":-1.2329460000000042E-2}]
[null,null,2017,"Janvier","DD",20000000,20390137.571077999,null,"Janvier",35000000,34568468.895985]
[null,null,2017,"Janvier","Gros",7500000,7611189.8033250002,null,"Fevrier",36000000,46544005.823442005]
[null,null,2017,"Janvier","Prestige",200000,102174.453702,null,"Mars",38000000,52697942.931878015]
[null,null,2017,"Janvier","Promotion",null,0,null,"Avril",40000000,60777235.527070001]
[null,null,2017,"Janvier","SUBD",6500000,5704657.1509379996,null,"Mai",45000000,67292181.324409008]
[null,null,2017,"Fevrier","Autre DD",600000,382134.46317999996,null,"Juin",40000000,31315282.207122996]
[null,null,2017,"Fevrier","DD",20000000,23555044.946474005,null,"Juillet",80000000,98070910.033525988]
[null,null,2017,"Fevrier","Gros",8000000,12198597.144612001,null,"Aout",75000000,103039876.20264202]
[null,null,2017,"Fevrier","Prestige",400000,292810.0845,null,"Septembre",80000000,85114140.337568015]
[null,null,2017,"Fevrier","Promotion",null,0,null,"Octobre",60000000,61557722.341312006]
[null,null,2017,"Fevrier","SUBD",7000000,10115419.184675999,null,"Total général",529000000,640977765.62495506]
[null,null,2017,"Mars","Autre DD",500000,911546.22089999996]
[null,null,2017,"Mars","DD",18000000,24631309.761852004]
[null,null,2017,"Mars","Gros",8000000,10649114.316765001]
[null,null,2017,"Mars","Prestige",200000,126806.72274,null,null,{"$f":"VLOOKUP(J23,Gauge!C5:E14,1,FALSE)","v":0}]
[null,null,2017,"Mars","Promotion",100000,51714.286259]
[null,null,2017,"Mars","SUBD",11200000,16327451.623362001]
[null,null,2017,"Avril","Autre DD",900000,777086.72771699994]
[null,null,2017,"Avril","DD",26000000,32919976.816488001]
[null,null,2017,"Avril","Gros",6000000,8899814.8951849993]
[null,null,2017,"Avril","Prestige",null,0]
[null,null,2017,"Avril","Promotion",100000,13445.32416]
[null,null,2017,"Avril","SUBD",7000000,18166911.763519999]
[null,null,2017,"Mai","Autre DD",1000000,1261612.235236]
[null,null,2017,"Mai","DD",20000000,28844823.124020997]
[null,null,2017,"Mai","Gros",8000000,11217676.702359999]
[null,null,2017,"Mai","Prestige"]
[null,null,2017,"Mai","Promotion",100000,68817.016747999995]
[null,null,2017,"Mai","SUBD",15900000,25899252.246044002]
[null,null,2017,"Juin","Autre DD",600000,281747.49463800003]
[null,null,2017,"Juin","DD",18000000,13255042.343807999]
[null,null,2017,"Juin","Gros",6000000,3948728.8315849998]
[null,null,2017,"Juin","Prestige",300000,138902.52112800002]
[null,null,2017,"Juin","Promotion",100000,67279.201514]
[null,null,2017,"Juin","SUBD",15000000,13623581.814449999]
[null,null,2017,"Juillet","Autre DD",1000000,1177954.0873199999]
[null,null,2017,"Juillet","DD",33000000,36140239.280120991]
[null,null,2017,"Juillet","Gros",9000000,11540198.660662999]
[null,null,2017,"Juillet","Prestige",200000,323871.89362800005]
[null,null,2017,"Juillet","Promotion",100000,43486.546836000009]
[null,null,2017,"Juillet","SUBD",36700000,48845159.564957991]
[null,null,2017,"Aout","Autre DD",1000000,1495424.2304439999]
[null,null,2017,"Aout","DD",29000000,42832274.869413003]
[null,null,2017,"Aout","Gros",9000000,15200969.576558001]
[null,null,2017,"Aout","Prestige",300000,503951.59656000003]
[null,null,2017,"Aout","Promotion",100000,21684.873971000001]
[null,null,2017,"Aout","SUBD",35600000,42985571.055696011]
[null,null,2017,"Septembre","Autre DD",1000000,586384.03898299998]
[null,null,2017,"Septembre","DD",33000000,33226368.983511001]
[null,null,2017,"Septembre","Gros",9000000,11467898.313643001]
[null,null,2017,"Septembre","Prestige",200000]
[null,null,2017,"Septembre","Promotion",100000,10705.882366999998]
[null,null,2017,"Septembre","SUBD",36700000,39822783.119064003]
[null,null,2017,"Octobre","Autre DD",1000000,628440.7086250002]
[null,null,2017,"Octobre","DD",33500000,36374887.451278001]
[null,null,2017,"Octobre","Gros",10000000,10043153.072472]
[null,null,2017,"Octobre","Prestige",100000,4202.0167499999998]
[null,null,2017,"Octobre","Promotion",800000,909143.76022099995]
[null,null,2017,"Octobre","SUBD",14600000,13597895.331966002]

{"sheet":"Gauge","index":5,"n_rows":28,"n_cols":17,"rows_kept":28,"cut":false,"hidden":false,"merged":[[2,2,2,4],[2,6,2,7],[4,11,5,16],[13,6,13,7],[14,2,14,3]]}
[]
[]
[null,null,"Table 1 - Sales Performance",null,null,null,"Table 2 - Selected Sales rep"]
[null,null,"Mois","Plan","Actual",null,"Mois",{"$f":"$L$7","v":"Janvier"}]
[null,null,"Janvier",35000000,34568468.895985,null,"Actual",{"$f":"VLOOKUP($H$4,$C$5:$E$12,3,FALSE)","v":34568468.895985},null,null,null,"Sales performance (%)"]
[null,null,"Fevrier",36000000,46544005.823442005,null,"Plan",{"$f":"VLOOKUP($H$4,$C$5:$E$12,2,FALSE)","v":35000000}]
[null,null,"Mars",38000000,52697942.931878015,null,"Actual / Plan (%)",{"$f":"((H5/H6))","v":0.98767053988528575},null,null,null,"Janvier",{"$f":"\"Actual: \"&H6","v":"Actual: 35000000"},{"$f":"\"Plan: \"&H5","v":"Plan: 34568468,895985"},{"$f":"\"Status: \"","v":"Status: "},{"$f":"H7","v":0.98767053988528575},"%"]
[null,null,"Avril",40000000,60777235.527070001]
[null,null,"Mai",45000000,67292181.324409008]
[null,null,"Juin",40000000,31315282.207122996]
[null,null,"Juillet",80000000,98070910.033525988]
[null,null,"Aout",75000000,103039876.20264202]
[null,null,"Septembre",80000000,85114140.337568015]
[null,null,"Octobre",60000000,61557722.341312006,null,"Table 4 - Ticker settings"]
[null,null,"Table 3 - Zone settings",null,null,null,"Actual /Plan (%) (modified)",{"$f":"H7-1","v":-1.2329460114714252E-2}]
[null,null,"Red Zone",20,null,null,"Ticker",2]
[null,null,"Orange Zone",30,null,null,"Rest value",{"$f":"D20-H16-H15","v":178.01232946011473}]
[null,null,"Green Zone",70,null,null,"Total",{"$f":"SUM(H15:H17)","v":180}]
[null,null,"Hidden Zone",60]
[null,null,"Total",{"$f":"SUM(D16:D19)","v":180}]
[null,null,null,180]
[null,null,null,{"$f":"D21-D20","v":0}]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"70%-on OK"]