{"text_format":"1","workbook":"xlsx","n_sheets":13,"sheets":["Accueil","Commandes","Rosés","Blancs","Bordeaux Sud-Ouest","Bourgogne","Beaujolais","Languedoc","Vallée du Rhône","Vallée de la Loire","Etrangers","Champagne","Listes"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":114,"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":"Accueil","index":0,"n_rows":29,"n_cols":19,"rows_kept":29,"cut":false,"hidden":false,"merged":[[28,3,28,4],[23,3,23,4],[24,3,24,4],[25,3,25,4],[26,3,26,4],[27,3,27,4],[17,4,17,11],[0,13,3,14],[4,13,7,14],[8,13,11,14],[12,13,15,14],[0,0,9,6],[10,0,15,6],[0,7,1,12],[2,7,3,12],[4,7,5,12],[6,7,7,12],[8,7,9,12],[10,7,11,12],[12,7,13,12],[14,7,15,12],[10,15,14,16],[10,17,14,17],[10,18,14,18],[0,15,4,16],[0,17,4,17],[0,18,4,18],[5,15,9,16],[5,17,9,17],[5,18,9,18]]}
["NOMBRE DE REFERENCES",null,null,null,null,null,null,"BIO",null,null,null,null,null,{"$f":"H3/A$11","v":0.44186046511627908},null,"ENTREE DE GAMME\n-26€",null,{"$f":"SUM(Rosés!I18,Blancs!I37,'Bordeaux Sud-Ouest'!I22,Bourgogne!I25,Beaujolais!I23,Languedoc!I36,'Vallée du Rhône'!I26,'Vallée de la Loire'!I25,Etrangers!I24,Champagne!I18)","v":9},{"$f":"R1/A$11","v":0.10465116279069768}]
[]
[null,null,null,null,null,null,null,{"$f":"SUM(Rosés!I10,Blancs!I29,'Bordeaux Sud-Ouest'!I14,Bourgogne!I17,Beaujolais!I15,Languedoc!I28,'Vallée du Rhône'!I18,'Vallée de la Loire'!I17,Etrangers!I16,Champagne!I10)","v":38}]
[]
[null,null,null,null,null,null,null,"NATURE",null,null,null,null,null,{"$f":"H7/A$11","v":0.11627906976744186}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MILIEU DE GAMME\n26€ - 37€",null,{"$f":"SUM(Rosés!I20,Blancs!I39,'Bordeaux Sud-Ouest'!I24,Bourgogne!I27,Beaujolais!I25,Languedoc!I38,'Vallée du Rhône'!I28,'Vallée de la Loire'!I27,Etrangers!I26,Champagne!I20)","v":40},{"$f":"R6/A$11","v":0.46511627906976744}]
[null,null,null,null,null,null,null,{"$f":"SUM(Rosés!I12,Blancs!I31,'Bordeaux Sud-Ouest'!I16,Bourgogne!I19,Beaujolais!I17,Languedoc!I30,'Vallée du Rhône'!I20,'Vallée de la Loire'!I19,Etrangers!I18,Champagne!I12)","v":10}]
[]
[null,null,null,null,null,null,null,"CONVENTIONNEL",null,null,null,null,null,{"$f":"H11/A$11","v":0.36046511627906974}]
[]
[{"$f":"SUM(Rosés!I8,Blancs!I27,'Bordeaux Sud-Ouest'!I12,Bourgogne!I15,Beaujolais!I13,Languedoc!I26,'Vallée du Rhône'!I16,'Vallée de la Loire'!I15,Etrangers!I14,Champagne!I8)","v":86},null,null,null,null,null,null,{"$f":"SUM(Rosés!I14,Blancs!I33,'Bordeaux Sud-Ouest'!I18,Bourgogne!I21,Beaujolais!I19,Languedoc!I32,'Vallée du Rhône'!I22,'Vallée de la Loire'!I21,Etrangers!I20,Champagne!I14)","v":31},null,null,null,null,null,null,null,"HAUT DE GAMME\n37€ +",null,{"$f":"SUM(Rosés!I22,Blancs!I41,'Bordeaux Sud-Ouest'!I26,Bourgogne!I29,Beaujolais!I27,Languedoc!I40,'Vallée du Rhône'!I30,'Vallée de la Loire'!I29,Champagne!I22)","v":34},{"$f":"R11/A$11","v":0.39534883720930231}]
[]
[null,null,null,null,null,null,null,"BIODYNAMIE",null,null,null,null,null,{"$f":"H15/A$11","v":0.10465116279069768}]
[]
[null,null,null,null,null,null,null,{"$f":"SUM(Rosés!I16,Blancs!I35,Bourgogne!I23,Beaujolais!I21,Languedoc!I34,'Vallée du Rhône'!I24,Etrangers!I22,Champagne!I16)","v":9}]
[]
[]
[null,null,null,null,"AJOUT NOUVELLE REFERENCE"]
[null,null,null,null,"Régions","Appelation","Millésime","Cépage(s)","Agrilculture",null,"Fournisseur","PAHT"]
[null,null,null,null,"Rosés"]
[]
[]
[]
[null,null,null,"COMMANDES DU MOIS"]
[null,null,null,{"$f":"SUM(Rosés!T5,Blancs!T24,'Bordeaux Sud-Ouest'!T9,Bourgogne!T12,Beaujolais!T10,Languedoc!T23,'Vallée du Rhône'!T13,'Vallée de la Loire'!T12,Etrangers!T11,Champagne!T5)","v":304}]
[null,null,null,"INVENTAIRE DU  MOIS"]
[null,null,null,{"$f":"SUM(Rosés!S5,Blancs!S24,'Bordeaux Sud-Ouest'!S9,Bourgogne!S12,Beaujolais!S10,Languedoc!S23,'Vallée du Rhône'!S13,'Vallée de la Loire'!S12,Etrangers!S11,Champagne!S5)","v":589}]
[null,null,null,"DEBUT DE MOIS"]
[null,null,null,{"$f":"D25+D27","v":893}]

{"sheet":"Commandes","index":1,"n_rows":3,"n_cols":4,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["Fournisseurs"]
["Didier Bordas 0660995478"]
["Appellation","Millésime","PAHT","COM"]

{"sheet":"Rosés","index":2,"n_rows":22,"n_cols":22,"rows_kept":22,"cut":false,"hidden":false,"merged":[[0,0,1,0],[0,3,0,4],[4,0,5,0],[4,1,5,1]]}
[null,"Millésime","Cépages","Agriculture",null,"Fournisseurs","PAHT","Coeff supposé","PVTTC Supposé","Rupture\n(X)",null,"BIO","NATURE","CON","BIODY","EG","MG","HG","INV","COM","PVEMP","PVGROS"]
[]
["AOP Coteaux d’Aix-en-Provence, Les Monges, Domaine de la Mongestine",2019,"Grenache noir, Cinsault, Syrah, Vermentino","BIO",null,"Didier Bordas 0660995478",6.95,{"$f":"_xlfn.IFS(G3<5,4,G3<6.5,3.75,G3<8,3.5,G3<10,3.25,G3<12,3,G3<15,2.85,G3<20,2.8,G3<50,2.65)","v":3.5},{"$f":"G3*1.2*H3","v":29.189999999999998},null,{"$f":"IF(J3=\"X\",(TRUE),(FALSE))","v":false},{"$f":"IF(AND(OR($D3=\"BIO\",$E3=\"BIO\"),$K3=TRUE),1,0)","v":0},{"$f":"IF(AND(OR($D3=\"NATURE\",$E3=\"NATURE\"),$K3=TRUE),1,0)","v":0},{"$f":"IF(AND(OR($D3=\"CON\",$E3=\"CON\"),$K3=TRUE),1,0)","v":0},{"$f":"IF(AND(OR($D3=\"BIODY\",$E3=\"BIODY\"),$K3=TRUE),1,0)","v":0},{"$f":"IF(AND($I3<26,$K3=TRUE),1,0)","v":0},{"$f":"IF(AND((I3>25.99)*(I3<37),$K3=TRUE),1,0)","v":0},{"$f":"IF(AND(36.99<$I3,$K3=TRUE),1,0)","v":0},6,0,{"$f":"$G3*1.2*2","v":16.68},{"$f":"$G3*1.2*1.2","v":10.007999999999999}]
["AOP Coteaux D’Aix en Provence, Les Éphémères, Domaine Belhambrée",2019,"Syrah, Grenache, Cinsault","BIO",null,"Palette via Patrons",4.3499999999999996,{"$f":"_xlfn.IFS(G4<5,4,G4<6.5,3.75,G4<8,3.5,G4<10,3.25,G4<12,3,G4<15,2.85,G4<20,2.8,G4<50,2.65)","v":4},{"$f":"G4*1.2*H4","v":20.88},null,{"$f":"IF(J4=\"X\",(TRUE),(FALSE))","v":false},{"$f":"IF(AND(OR($D4=\"BIO\",$E4=\"BIO\"),$K4=TRUE),1,0)","v":0},{"$f":"IF(AND(OR($D4=\"NATURE\",$E4=\"NATURE\"),$K4=TRUE),1,0)","v":0},{"$f":"IF(AND(OR($D4=\"CON\",$E4=\"CON\"),$K4=TRUE),1,0)","v":0},{"$f":"IF(AND(OR($D4=\"BIODY\",$E4=\"BIODY\"),$K4=TRUE),1,0)","v":0},{"$f":"IF(AND($I4<26,$K4=TRUE),1,0)","v":0},{"$f":"IF(AND((I4>25.99)*(I4<37),$K4=TRUE),1,0)","v":0},{"$f":"IF(AND(36.99<$I4,$K4=TRUE),1,0)","v":0},51,0,{"$f":"$G4*1.2*2","v":10.44},{"$f":"$G4*1.2*1.2","v":6.2639999999999993}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(S3:S4)","v":57},{"$f":"SUM(T3:T4)","v":0}]
[]
[null,null,null,null,null,null,null,null,"TOTAL VINS","TOTAL RUPTURES"]
[null,null,null,null,null,null,null,null,{"$f":"(ROWS(VINSROSES1))-J8","v":2},{"$f":"COUNTIF(VINSROSES1,\"VRAI\")","v":0}]
[null,null,null,null,null,null,null,null,"BIO","BIO"]
[null,null,null,null,null,null,null,null,{"$f":"COUNTIF(AGRIROSES,\"BIO\")-J10","v":2},{"$f":"SUM(RBIOROSES)","v":0}]
[null,null,null,null,null,null,null,null,"NATURE","NATURE"]
[null,null,null,null,null,null,null,null,{"$f":"COUNTIF(AGRIROSES,\"NATURE\")-J12","v":0},{"$f":"SUM(RNATUREROSES)","v":0}]
[null,null,null,null,null,null,null,null,"CONVENTIONNEL","CONVENTIONNEL"]
[null,null,null,null,null,null,null,null,{"$f":"COUNTIF(AGRIROSES,\"CON\")-J14","v":0},{"$f":"SUM(RCONROSES)","v":0}]
[null,null,null,null,null,null,null,null,"BIODYNAMIE","BIODYNAMIE"]
[null,null,null,null,null,null,null,null,{"$f":"COUNTIF(AGRIROSES,\"BIODY\")-J16","v":0},{"$f":"SUM(RBIODYROSES)","v":0}]
[null,null,null,null,null,null,null,null,"ENTREE DE GAMME","ENTREE DE GAMME"]
[null,null,null,null,null,null,null,null,{"$f":"COUNTIFS(PVTTCROSES,\"<26\")-J18","v":1},{"$f":"SUM(REGROSES)","v":0}]
[null,null,null,null,null,null,null,null,"MILIEU DE GAMME","MILIEU DE GAMME"]
[null,null,null,null,null,null,null,null,{"$f":"SUMPRODUCT((PVTTCROSES>25.99)*(PVTTCROSES<37))-J20","v":1},{"$f":"SUM(RMGROSES)","v":0}]
[null,null,null,null,null,null,null,null,"HAUT DE GAMME","HAUT DE GAMME"]
[null,null,null,null,null,null,null,null,{"$f":"COUNTIFS(PVTTCROSES,\">36,99\")-J22","v":0},{"$f":"SUM(RHGROSES)","v":0}]

{"sheet":"Blancs","index":3,"n_rows":41,"n_cols":22,"rows_kept":41,"cut":false,"hidden":false,"merged":[[23,2,24,10],[0,0,1,0],[0,3,0,4],[23,0,24,0],[23,1,24,1]]}
[null,"Millésime","Cépages","Agriculture",null,"Fournisseurs","PAHT","Coeff supposé","PVTTC Supposé","Rupture\n(X)",null,"BIO","NATURE","CON","BIODY","EG","MG","HG","INV","COM","PVEMP","PVGROS"]
[]
["AOC Alsace Grand Cru, Kaefferkopf, Domaine Léon Heitzmann",2016,"Gewurztraminer, Riesling, Pinot gris","BIODY",null,"Axel Gustoworld 0625338003",13.26,{"$f":"_xlfn.IFS(G3<5,4,G3<6.5,3.75,G3<8,3.5,G3<10,3.25,G3<12,3,G3<15,2.85,G3<20,2.8,G3<50,2.65)","v":2.85},{"$f":"G3*1.2*H3","v":45.349199999999996},null,{"$f":"IF(J3=\"X\",(TRUE),(FALSE))","v":false},{"$f":"IF(AND(OR($D3=\"BIO\",$E3=\"BIO\"),$K3=TRUE),1,0)","v":0},{"$f":"IF(AND(OR($D3=\"NATURE\",$E3=\"NATURE\"),$K3=TRUE),1,0)","v":0},{"$f":"IF(AND(OR($D3=\"CON\",$E3=\"CON\"),$K3=TRUE),1,0)","v":0},{"$f":"IF(AND(OR($D3=\"BIODY\",$E3=\"BIODY\"),$K3=TRUE),1,0)","v":0},{"$f":"IF(AND($I3<26,$K3=TRUE),1,0)","v":0},{"$f":"IF(AND((I3>25.99)*(I3<37),$K3=TRUE),1,0)","v":0},{"$f":"IF(AND(36.99<$I3,$K3=TRUE),1,0)","v":0},3,0,{"$f":"$G3*1.2*2","v":31.823999999999998},{"$f":"$G3*1.2*1.2","v":19.094399999999997}]
["AOC Coteaux du Layon, Les Marcottes, Domaine Pierre Chauvin",2018,"Chenin","BIO",null,"Aymeric Vignapart 0670827124",7.95,{"$f":"_xlfn.IFS(G4<5,4,G4<6.5,3.75,G4<8,3.5,G4<10,3.25,G4<12,3,G4<15,2.85,G4<20,2.8,G4<50,2.65)","v":3.5},33.39,null,false,0,0,0,0,0,0,0,16,0,{"$f":"$G4*1.2*2","v":19.079999999999998},{"$f":"$G4*1.2*1.2","v":11.447999999999999}]
["AOP Viré-Clessé, Terroir de Clessé, Domaine des Gandines",2019," Chardonnay","BIODY ",null,"Aymeric Vignapart 0670827124",8.9,{"$f":"_xlfn.IFS(G5<5,4,G5<6.5,3.75,G5<8,3.5,G5<10,3.25,G5<12,3,G5<15,2.85,G5<20,2.8,G5<50,2.65)","v":3.25},34.71,null,false,0,0,0,0,0,0,0,30,12,{"$f":"$G5*1.2*2","v":21.36},{"$f":"$G5*1.2*1.2","v":12.815999999999999}]
["AOC Bordeaux, Lion noir, Pierre-Henri Cosyns",2018,"Sauvignon gris, Semillon, Muscadelle","BIO",null,"Aymeric Vignapart 0670827124",4.9000000000000004,{"$f":"_xlfn.IFS(G6<5,4,G6<6.5,3.75,G6<8,3.5,G6<10,3.25,G6<12,3,G6<15,2.85,G6<20,2.8,G6<50,2.65)","v":4},23.52,null,false,0,0,0,0,0,0,0,3,0,11.76,7.056]
["AOP Côtes du Roussillon, Mas Janeil, François Lurton",2015,"Macabeu, Grenache gris","CON",null,"Biaggio Vinom 0778720063",11.5,{"$f":"_xlfn.IFS(G7<5,4,G7<6.5,3.75,G7<8,3.5,G7<10,3.25,G7<12,3,G7<15,2.85,G7<20,2.8,G7<50,2.65)","v":3},41.4,null,false,0,0,0,0,0,0,0,10,0,27.599999999999998,16.559999999999999]
["AOC Montlouis-sur-Loire, Les Terres Turones, Dominique & Philippe Ivancic",2017," Chenin","CON",null,"Biaggio Vinom 0778720063",10,{"$f":"_xlfn.IFS(G8<5,4,G8<6.5,3.75,G8<8,3.5,G8<10,3.25,G8<12,3,G8<15,2.85,G8<20,2.8,G8<50,2.65)","v":3},36,null,false,0,0,0,0,0,0,0,6,0,24,14.399999999999999]
["IGP Pays D’OC, Vermentino, Domaine de Cantaussel",2018,"Vermentino","BIO",null,"Cédric Schiltz 0612108579",7.75,{"$f":"_xlfn.IFS(G9<5,4,G9<6.5,3.75,G9<8,3.5,G9<10,3.25,G9<12,3,G9<15,2.85,G9<20,2.8,G9<50,2.65)","v":3.5},32.549999999999997,null,false,0,0,0,0,0,0,0,5,0,18.599999999999998,11.159999999999998]
["AOP Chinon, Clair de Lune, Domaine Jourdan",2018,"Chenin","BIODY",null,"Didier Bordas 0660995478",12.67,{"$f":"_xlfn.IFS(G10<5,4,G10<6.5,3.75,G10<8,3.5,G10<10,3.25,G10<12,3,G10<15,2.85,G10<20,2.8,G10<50,2.65)","v":2.85},43.331399999999995,null,false,0,0,0,0,0,0,0,null,6,30.407999999999998,18.244799999999998]
["VDF Loire, L’enfant rebelle, Antoine de la Farge",2019,"Sauvignon","CON",null,"Didier Bordas 0660995478",6.15,{"$f":"_xlfn.IFS(G11<5,4,G11<6.5,3.75,G11<8,3.5,G11<10,3.25,G11<12,3,G11<15,2.85,G11<20,2.8,G11<50,2.65)","v":3.75},27.675000000000001,null,false,0,0,0,0,0,0,0,1,0,14.76,8.8559999999999999]
["AOC Chablis, Drouhin.Vaudon, Joseph Drouhin",2017,"Chardonnay","BIODY",null,"Didier Bordas 0660995478",9.5,{"$f":"_xlfn.IFS(G12<5,4,G12<6.5,3.75,G12<8,3.5,G12<10,3.25,G12<12,3,G12<15,2.85,G12<20,2.8,G12<50,2.65)","v":3.25},37.050000000000004,null,false,0,0,0,0,0,0,0,11,0,22.8,13.68]
["AOC Sancerre, La Chatellenie, Joseph Mellot",2018,"Sauvignon","CON",null,"Didier Bordas 0660995478",9.2899999999999991,{"$f":"_xlfn.IFS(G13<5,4,G13<6.5,3.75,G13<8,3.5,G13<10,3.25,G13<12,3,G13<15,2.85,G13<20,2.8,G13<50,2.65)","v":3.25},36.230999999999995,null,false,0,0,0,0,0,0,0,12,0,22.295999999999996,13.377599999999997]
["AOP Saumur, Clos des Oratoriens, Dame de Chaintres",2019,"Chenin","BIO",null,"Didier Bordas 0660995478",10.4,{"$f":"_xlfn.IFS(G14<5,4,G14<6.5,3.75,G14<8,3.5,G14<10,3.25,G14<12,3,G14<15,2.85,G14<20,2.8,G14<50,2.65)","v":3},37.44,null,false,0,0,0,0,0,0,0,16,0,24.96,14.975999999999999]
["AOP Anjou, Bouillon aux Dames, Les Équilibristes",2018,"Chenin","CON",null,"Nicolas Jaboulet 0680320770",7.6,{"$f":"_xlfn.IFS(G15<5,4,G15<6.5,3.75,G15<8,3.5,G15<10,3.25,G15<12,3,G15<15,2.85,G15<20,2.8,G15<50,2.65)","v":3.5},31.919999999999998,null,false,0,0,0,0,0,0,0,7,6,18.239999999999998,10.943999999999999]
["AOP Picpoul de Pinet, Pic Poul, les Équilibristes",2019,"Picpoul","CON",null,"Nicolas Jaboulet 0680320770",6.85,{"$f":"_xlfn.IFS(G16<5,4,G16<6.5,3.75,G16<8,3.5,G16<10,3.25,G16<12,3,G16<15,2.85,G16<20,2.8,G16<50,2.65)","v":3.5},28.769999999999996,null,false,0,0,0,0,0,0,0,14,18,16.439999999999998,9.863999999999999]
["AOP Crozes-Hermitage, Les Hauts d’Eole, Cave de Tain",2018,"70%Marsanne, 30%Roussanne","CON",null,"Phillippe Potier 0680136645",10,{"$f":"_xlfn.IFS(G17<5,4,G17<6.5,3.75,G17<8,3.5,G17<10,3.25,G17<12,3,G17<15,2.85,G17<20,2.8,G17<50,2.65)","v":3},36,null,false,0,0,0,0,0,0,0,1,6,24,14.399999999999999]
["IGT Venero, Alla costiera, Terreni Bianchi",2016," Garganega, Moscato, Marzemina bianca","CON",null,"X",5.5,{"$f":"_xlfn.IFS(G18<5,4,G18<6.5,3.75,G18<8,3.5,G18<10,3.25,G18<12,3,G18<15,2.85,G18<20,2.8,G18<50,2.65)","v":3.75},24.75,null,false,0,0,0,0,0,0,0,6,0,13.2,7.919999999999999]
["AOC Costières de Nîmes, Château de Valcombe",2018," Roussanne, Marsanne","CON",null,"X",5.15,{"$f":"_xlfn.IFS(G19<5,4,G19<6.5,3.75,G19<8,3.5,G19<10,3.25,G19<12,3,G19<15,2.85,G19<20,2.8,G19<50,2.65)","v":3.75},23.175000000000001,null,false,0,0,0,0,0,0,0,1,0,12.360000000000001,7.4160000000000004]
["AOP Limoux, Château de Gaure, Pierre Fabre",2018," 70%Chardonnay, 30%Chenin","CON",null,"X",7.81,{"$f":"_xlfn.IFS(G20<5,4,G20<6.5,3.75,G20<8,3.5,G20<10,3.25,G20<12,3,G20<15,2.85,G20<20,2.8,G20<50,2.65)","v":3.5},32.802,null,false,0,0,0,0,0,0,0,9,0,18.744,11.2464]
["IGP Pays d’Hérault, Apollo 93, Yann Le Bouler",2017,"Viognier","BIO",null,"X",7.9,{"$f":"_xlfn.IFS(G21<5,4,G21<6.5,3.75,G21<8,3.5,G21<10,3.25,G21<12,3,G21<15,2.85,G21<20,2.8,G21<50,2.65)","v":3.5},33.18,null,false,0,0,0,0,0,0,0,7,0,18.96,11.375999999999999]
["IGP Mont-Baudile-Hérault, Mas D’Amile",2017,"Terret blanc","CON",null,"X",12,{"$f":"_xlfn.IFS(G22<5,4,G22<6.5,3.75,G22<8,3.5,G22<10,3.25,G22<12,3,G22<15,2.85,G22<20,2.8,G22<50,2.65)","v":2.85},41.04,null,false,0,0,0,0,0,0,0,5,0,28.799999999999997,17.279999999999998]
["AOC Valençay, Vieilles Vignes, Domaine André Fouassier",2018,"Sauvignon, Chardonnay, Pineau gris","CON",null,"X",5.5,{"$f":"_xlfn.IFS(G23<5,4,G23<6.5,3.75,G23<8,3.5,G23<10,3.25,G23<12,3,G23<15,2.85,G23<20,2.8,G23<50,2.65)","v":3.75},24.75,null,false,0,0,0,0,0,0,0,1,0,13.2,7.919999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(S3:S23)","v":164},{"$f":"SUM(T3:T23)","v":48}]
[]
[null,null,null,null,null,null,null,null,"TOTAL VINS","TOTAL RUPTURES"]
[null,null,null,null,null,null,null,null,{"$f":"(ROWS(VINSBLANCS))-J27","v":21},{"$f":"COUNTIF(VINSBLANCS,\"VRAI\")","v":0}]
[null,null,null,null,null,null,null,null,"BIO","BIO"]
[null,null,null,null,null,null,null,null,{"$f":"COUNTIF(AGRIVINSBLANCS,\"BIO\")-J29","v":5},{"$f":"SUM(RBIOBLANCS)","v":0}]
[null,null,null,null,null,null,null,null,"NATURE","NATURE"]
[null,null,null,null,null,null,null,null,{"$f":"COUNTIF(AGRIVINSBLANCS,\"NATURE\")-J31","v":0},{"$f":"SUM(RNATUREBLANCS)","v":0}]
[null,null,null,null,null,null,null,null,"CONVENTIONNEL","CONVENTIONNEL"]
[null,null,null,null,null,null,null,null,{"$f":"COUNTIF(AGRIVINSBLANCS,\"CON\")-J33","v":12},{"$f":"SUM(RCONBLANCS)","v":0}]
[null,null,null,null,null,null,null,null,"BIODYNAMIE","BIODYNAMIE"]
[null,null,null,null,null,null,null,null,{"$f":"COUNTIF(AGRIVINSBLANCS,\"BIODY\")-J35","v":3},{"$f":"SUM(RBIODYBLANCS)","v":0}]
[null,null,null,null,null,null,null,null,"ENTREE DE GAMME","ENTREE DE GAMME"]
[null,null,null,null,null,null,null,null,{"$f":"COUNTIFS(PVTTCBLANCS,\"<26\")-J37","v":4},{"$f":"SUM(regbla)","v":0}]
[null,null,null,null,null,null,null,null,"MILIEU DE GAMME","MILIEU DE GAMME"]
[null,null,null,null,null,null,null,null,{"$f":"SUMPRODUCT((PVTTCBLANCS>25.99)*(PVTTCBLANCS<37))-J39","v":11},{"$f":"SUM(RMGBLA)","v":0}]
[null,null,null,null,null,null,null,null,"HAUT DE GAMME","HAUT DE GAMME"]
[null,null,null,null,null,null,null,null,{"$f":"COUNTIFS(PVTTCBLANCS,\">36,99\")-J41","v":6},{"$f":"SUM(RHGBLA)","v":0}]

{"sheet":"Bordeaux Sud-Ouest","index":4,"n_rows":26,"n_cols":22,"rows_kept":26,"cut":false,"hidden":false,"merged":[[0,0,1,0],[0,3,0,4],[8,0,9,0],[8,1,9,1],[8,2,9,10]]}
[null,"Millésime","Cépages","Agriculture",null,"Fournisseurs","PAHT","Coeff supposé","PVTTC Supposé","Rupture\n(X)",null,"BIO","NATURE","CON","BIODY","EG","MG","HG","INV","COM","PVEMP","PVGROS"]
[]
["AOC Bordeaux, Origin de Kressmann",2018,"Merlot","NATURE",null,"Camille 0674705816",4.7,{"$f":"_xlfn.IFS(G3<5,4,G3<6.5,3.75,G3<8,3.5,G3<10,3.25,G3<12,3,G3<15,2.85,G3<20,2.8,G3<50,2.65)","v":4},{"$f":"G3*1.2*H3","v":22.56},null,{"$f":"IF(J3=\"X\",(TRUE),(FALSE))","v":false},{"$f":"IF(AND(OR($D3=\"BIO\",$E3=\"BIO\"),$K3=TRUE),1,0)","v":0},{"$f":"IF(AND(OR($D3=\"NATURE\",$E3=\"NATURE\"),$K3=TRUE),1,0)","v":0},{"$f":"IF(AND(OR($D3=\"CON\",$E3=\"CON\"),$K3=TRUE),1,0)","v":0},{"$f":"IF(AND(OR($D3=\"BIODY\",$E3=\"BIODY\"),$K3=TRUE),1,0)","v":0},{"$f":"IF(AND($I3<26,$K3=TRUE),1,0)","v":0},{"$f":"IF(AND((I3>25.99)*(I3<37),$K3=TRUE),1,0)","v":0},{"$f":"IF(AND(36.99<$I3,$K3=TRUE),1,0)","v":0},14,0,{"$f":"$G3*1.2*2","v":11.28},{"$f":"$G3*1.2*1.2","v":6.7679999999999998}]
["AOP Saint Emilion Grand Cru, Petit Corbin-Despagne",2016,"Merlot, Cabernet Franc","BIO",null,"Didier Bordas 0660995478",18,{"$f":"_xlfn.IFS(G4<5,4,G4<6.5,3.75,G4<8,3.5,G4<10,3.25,G4<12,3,G4<15,2.85,G4<20,2.8,G4<50,2.65)","v":2.8},{"$f":"G4*1.2*H4","v":60.47999999999999},null,false,0,0,0,0,0,0,0,null,6,{"$f":"$G4*1.2*2","v":43.199999999999996},{"$f":"$G4*1.2*1.2","v":25.919999999999998}]
["AOC Côtes de Bordeaux, Château moulin de Rioucreux",2016,"95%Merlot, 5%Malbec","BIO",null,"Didier Bordas 0660995478",6.5,{"$f":"_xlfn.IFS(G5<5,4,G5<6.5,3.75,G5<8,3.5,G5<10,3.25,G5<12,3,G5<15,2.85,G5<20,2.8,G5<50,2.65)","v":3.5},27.3,null,false,0,0,0,0,0,0,0,1,18,15.6,9.36]
["AOC Côtes de Bordeaux, Réserve de Famille, Château Martet",2016,"Merlot","CON",null,"Didier Bordas 0660995478",22.75,{"$f":"_xlfn.IFS(G6<5,4,G6<6.5,3.75,G6<8,3.5,G6<10,3.25,G6<12,3,G6<15,2.85,G6<20,2.8,G6<50,2.65)","v":2.65},{"$f":"G6*1.2*H6","v":72.344999999999999},null,false,0,0,0,0,0,0,0,16,0,54.6,32.76]
["AOC Pessac Léognan, La Lignée, Château Seguin",2016,"Cabernet Sauvignon, Merlot","CON",null,"Didier Bordas 0660995478",15.29,{"$f":"_xlfn.IFS(G7<5,4,G7<6.5,3.75,G7<8,3.5,G7<10,3.25,G7<12,3,G7<15,2.85,G7<20,2.8,G7<50,2.65)","v":2.8},{"$f":"G7*1.2*H7","v":51.374399999999994},null,false,0,0,0,0,0,0,0,8,0,36.695999999999998,22.017599999999998]
["VDF Sud Ouest, Tu Vin plus aux soirées, Fabien Jouves",2017,"Malbec, Merlot","BIO","NATURE","X",7.9,{"$f":"_xlfn.IFS(G8<5,4,G8<6.5,3.75,G8<8,3.5,G8<10,3.25,G8<12,3,G8<15,2.85,G8<20,2.8,G8<50,2.65)","v":3.5},{"$f":"G8*1.2*H8","v":33.18},null,false,0,0,0,0,0,0,0,1,0,18.96,11.375999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(S3:S8)","v":40},{"$f":"SUM(T3:T8)","v":24}]
[]
[null,null,null,null,null,null,null,null,"TOTAL VINS","TOTAL RUPTURES"]
[null,null,null,null,null,null,null,null,{"$f":"(ROWS(VINSBDX))-J12","v":6},{"$f":"COUNTIF(VINSBDX,\"VRAI\")","v":0}]
[null,null,null,null,null,null,null,null,"BIO","BIO"]
[null,null,null,null,null,null,null,null,{"$f":"COUNTIF(AGRIBDX1,\"BIO\")-J14","v":3},{"$f":"SUM(RBIOBDX)","v":0}]
[null,null,null,null,null,null,null,null,"NATURE","NATURE"]
[null,null,null,null,null,null,null,null,{"$f":"COUNTIF(AGRIBDX1,\"NATURE\")-J16","v":2},{"$f":"SUM(RNATUREBDX)","v":0}]
[null,null,null,null,null,null,null,null,"CONVENTIONNEL","CONVENTIONNEL"]
[null,null,null,null,null,null,null,null,{"$f":"COUNTIF(AGRIBDX1,\"CON\")-J18","v":2},{"$f":"SUM(RCONBDX)","v":0}]
[null,null,null,null,null,null,null,null,"BIODYNAMIE","BIODYNAMIE"]
[null,null,null,null,null,null,null,null,{"$f":"COUNTIF(AGRIBDX1,\"BIODY\")-J20","v":0},{"$f":"SUM(RBIODYBDX)","v":0}]
[null,null,null,null,null,null,null,null,"ENTREE DE GAMME","ENTREE DE GAMME"]
[null,null,null,null,null,null,null,null,{"$f":"COUNTIFS(PVTTCBDX,\"<26\")-J22","v":1},{"$f":"SUM(REGBOR)","v":0}]
[null,null,null,null,null,null,null,null,"MILIEU DE GAMME","MILIEU DE GAMME"]
[null,null,null,null,null,null,null,null,{"$f":"SUMPRODUCT((PVTTCBDX>25.99)*(PVTTCBDX<37))-J24","v":2},{"$f":"SUM(RMGBOR)","v":0}]
[null,null,null,null,null,null,null,null,"HAUT DE GAMME","HAUT DE GAMME"]
[null,null,null,null,null,null,null,null,{"$f":"COUNTIFS(PVTTCBDX,\">36,99\")-J26","v":3},{"$f":"SUM(RHGBOR)","v":0}]

{"sheet":"Bourgogne","index":5,"n_rows":29,"n_cols":22,"rows_kept":29,"cut":false,"hidden":false,"merged":[[0,0,1,0],[0,3,0,4],[11,0,12,0],[11,1,12,1],[11,2,12,10]]}
[null,"Millésime","Cépages","Agriculture",null,"Fournisseurs","PAHT","Coeff supposé","PVTTC Supposé","Rupture\n(X)",null,"BIO","NATURE","CON","BIODY","EG","MG","HG","INV","COM","PVEMP","PVGROS"]
[]
["AOC Bourgogne, Pinot noir, Domaine Chardigny",2019," Pinot noir","BIO",null,"Aymeric Vignapart 0670827124",8,{"$f":"_xlfn.IFS(G3<5,4,G3<6.5,3.75,G3<8,3.5,G3<10,3.25,G3<12,3,G3<15,2.85,G3<20,2.8,G3<50,2.65)","v":3.25},{"$f":"G3*1.2*H3","v":31.2},null,{"$f":"IF(J3=\"X\",(TRUE),(FALSE))","v":false},{"$f":"IF(AND(OR($D3=\"BIO\",$E3=\"BIO\"),$K3=TRUE),1,0)","v":0},{"$f":"IF(AND(OR($D3=\"NATURE\",$E3=\"NATURE\"),$K3=TRUE),1,0)","v":0},{"$f":"IF(AND(OR($D3=\"CON\",$E3=\"CON\"),$K3=TRUE),1,0)","v":0},{"$f":"IF(AND(OR($D3=\"BIODY\",$E3=\"BIODY\"),$K3=TRUE),1,0)","v":0},{"$f":"IF(AND($I3<26,$K3=TRUE),1,0)","v":0},{"$f":"IF(AND((I3>25.99)*(I3<37),$K3=TRUE),1,0)","v":0},{"$f":"IF(AND(36.99<$I3,$K3=TRUE),1,0)","v":0},18,12,{"$f":"$G3*1.2*2","v":19.2},{"$f":"$G3*1.2*1.2","v":11.52}]
["AOC Vosne-Romanée, Vieilles Vignes,Domaine Michel Magnien",2018,"Pinot noir","BIO",null,"Aymeric Vignapart 0670827124",39.1,{"$f":"_xlfn.IFS(G4<5,4,G4<6.5,3.75,G4<8,3.5,G4<10,3.25,G4<12,3,G4<15,2.85,G4<20,2.8,G4<50,2.65)","v":2.65},124.33799999999999,null,false,0,0,0,0,0,0,0,null,2,{"$f":"$G4*1.2*2","v":93.84},{"$f":"$G4*1.2*1.2","v":56.304000000000002}]
["AOC Monthelie 1er Cru, Sur la Velle, Eric de Surmain",2015,"Pinot noir","BIO",null,"Aymeric Vignapart 0670827124",23.65,{"$f":"_xlfn.IFS(G5<5,4,G5<6.5,3.75,G5<8,3.5,G5<10,3.25,G5<12,3,G5<15,2.85,G5<20,2.8,G5<50,2.65)","v":2.65},75.206999999999994,null,false,0,0,0,0,0,0,0,null,2,56.76,34.055999999999997]
["AOP Hautes Côtes de Nuits, Domaine Hudelot",2018,"Pinot noir","BIO",null,"Biaggio Vinom 0778720063",10,{"$f":"_xlfn.IFS(G6<5,4,G6<6.5,3.75,G6<8,3.5,G6<10,3.25,G6<12,3,G6<15,2.85,G6<20,2.8,G6<50,2.65)","v":3},36,null,false,0,0,0,0,0,0,0,null,6,24,14.399999999999999]
["AOC Alsace, Tradition, Domaine Stentz-Buecher",2017,"Pinot noir","BIODY",null,"Didier Bordas 0660995478",9.8000000000000007,{"$f":"_xlfn.IFS(G7<5,4,G7<6.5,3.75,G7<8,3.5,G7<10,3.25,G7<12,3,G7<15,2.85,G7<20,2.8,G7<50,2.65)","v":3.25},38.22,null,false,0,0,0,0,0,0,0,null,6,23.52,14.112]
["AOP Santenay, Le temps des cerises, Domaine Olivier",2017,"Pinot noir","BIODY",null,"Didier Bordas 0660995478",14.92,{"$f":"_xlfn.IFS(G8<5,4,G8<6.5,3.75,G8<8,3.5,G8<10,3.25,G8<12,3,G8<15,2.85,G8<20,2.8,G8<50,2.65)","v":2.85},51.026400000000002,null,false,0,0,0,0,0,0,0,null,6,35.808,21.4848]
["AOC Pommard, Dubreuil-Fontaine",2017," Pinot noir","CON",null,"Didier Bordas 0660995478",19.3,{"$f":"_xlfn.IFS(G9<5,4,G9<6.5,3.75,G9<8,3.5,G9<10,3.25,G9<12,3,G9<15,2.85,G9<20,2.8,G9<50,2.65)","v":2.8},64.847999999999999,null,false,0,0,0,0,0,0,0,1,0,46.32,27.791999999999998]
["AOC Côtes d'Auxerre, Domaine Bersan",2018,"Pinot noir","BIO",null,"Emmanuel Meffre 0672386975",9.3000000000000007,{"$f":"_xlfn.IFS(G10<5,4,G10<6.5,3.75,G10<8,3.5,G10<10,3.25,G10<12,3,G10<15,2.85,G10<20,2.8,G10<50,2.65)","v":3.25},36.270000000000003,null,false,0,0,0,0,0,0,0,null,18,22.32,13.391999999999999]
["AOC Irancy, Domaine Bersan",2018,"Pinot noir, César","BIO",null,"Emmanuel Meffre 0672386975",9.5,{"$f":"_xlfn.IFS(G11<5,4,G11<6.5,3.75,G11<8,3.5,G11<10,3.25,G11<12,3,G11<15,2.85,G11<20,2.8,G11<50,2.65)","v":3.25},37.050000000000004,null,false,0,0,0,0,0,0,0,null,18,22.8,13.68]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(S3:S11)","v":19},{"$f":"SUM(T3:T11)","v":70}]
[]
[null,null,null,null,null,null,null,null,"TOTAL VINS","TOTAL RUPTURES"]
[null,null,null,null,null,null,null,null,{"$f":"(ROWS(VINSBOURG))-J15","v":9},{"$f":"COUNTIF(VINSBOURG,\"VRAI\")","v":0}]
[null,null,null,null,null,null,null,null,"BIO","BIO"]
[null,null,null,null,null,null,null,null,{"$f":"COUNTIF(AGRIBOUR,\"BIO\")-J17","v":6},{"$f":"SUM(RBIOBOUR)","v":0}]
[null,null,null,null,null,null,null,null,"NATURE","NATURE"]
[null,null,null,null,null,null,null,null,{"$f":"COUNTIF(AGRIBOUR,\"NATURE\")-J19","v":0},{"$f":"SUM(RNATUREBOUR)","v":0}]
[null,null,null,null,null,null,null,null,"CONVENTIONNEL","CONVENTIONNEL"]
[null,null,null,null,null,null,null,null,{"$f":"COUNTIF(AGRIBOUR,\"CON\")-J21","v":1},{"$f":"SUM(RCONBOUR)","v":0}]
[null,null,null,null,null,null,null,null,"BIODYNAMIE","BIODYNAMIE"]
[null,null,null,null,null,null,null,null,{"$f":"COUNTIF(AGRIBOUR,\"BIODY\")-J23","v":2},{"$f":"SUM(RBIODYBOUR)","v":0}]
[null,null,null,null,null,null,null,null,"ENTREE DE GAMME","ENTREE DE GAMME"]
[null,null,null,null,null,null,null,null,{"$f":"COUNTIFS(PVTTCBOUR,\"<26\")-J25","v":0},{"$f":"SUM(REGBOU)","v":0}]
[null,null,null,null,null,null,null,null,"MILIEU DE GAMME","MILIEU DE GAMME"]
[null,null,null,null,null,null,null,null,{"$f":"SUMPRODUCT((PVTTCBOUR>25.99)*(PVTTCBOUR<37))-J27","v":3},{"$f":"SUM(RMGBOU)","v":0}]
[null,null,null,null,null,null,null,null,"HAUT DE GAMME","HAUT DE GAMME"]
[null,null,null,null,null,null,null,null,{"$f":"COUNTIFS(PVTTCBOUR,\">36,99\")-J29","v":6},{"$f":"SUM(RHGBOU)","v":0}]

{"sheet":"Beaujolais","index":6,"n_rows":27,"n_cols":22,"rows_kept":27,"cut":false,"hidden":false,"merged":[[0,0,1,0],[0,3,0,4],[9,0,10,0],[9,1,10,1],[9,2,10,10]]}
[null,"Millésime","Cépages","Agriculture",null,"Fournisseurs","PAHT","Coeff supposé","PVTTC Supposé","Rupture\n(X)",null,"BIO","NATURE","CON","BIODY","EG","MG","HG","INV","COM","PVEMP","PVGROS"]
[]
["AOC Beaujolais Villages, Domaine Victor Sornin",2020,"Gamay","BIO",null,"Aymeric Vignapart 0670827124",5.55,{"$f":"_xlfn.IFS(G3<5,4,G3<6.5,3.75,G3<8,3.5,G3<10,3.25,G3<12,3,G3<15,2.85,G3<20,2.8,G3<50,2.65)","v":3.75},{"$f":"G3*1.2*H3","v":24.974999999999998},"x",{"$f":"IF(J3=\"X\",(TRUE),(FALSE))","v":true},{"$f":"IF(AND(OR($D3=\"BIO\",$E3=\"BIO\"),$K3=TRUE),1,0)","v":1},{"$f":"IF(AND(OR($D3=\"NATURE\",$E3=\"NATURE\"),$K3=TRUE),1,0)","v":0},{"$f":"IF(AND(OR($D3=\"CON\",$E3=\"CON\"),$K3=TRUE),1,0)","v":0},{"$f":"IF(AND(OR($D3=\"BIODY\",$E3=\"BIODY\"),$K3=TRUE),1,0)","v":0},{"$f":"IF(AND($I3<26,$K3=TRUE),1,0)","v":1},{"$f":"IF(AND((I3>25.99)*(I3<37),$K3=TRUE),1,0)","v":0},{"$f":"IF(AND(36.99<$I3,$K3=TRUE),1,0)","v":0},null,0,{"$f":"$G3*1.2*2","v":13.319999999999999},{"$f":"$G3*1.2*1.2","v":7.9919999999999991}]
["AOC Fleurie, Grands Fers, Christian Bernard",2018,"Gamay","NATURE","NATURE","Biaggio Vinom 0778720063",6.9,{"$f":"_xlfn.IFS(G4<5,4,G4<6.5,3.75,G4<8,3.5,G4<10,3.25,G4<12,3,G4<15,2.85,G4<20,2.8,G4<50,2.65)","v":3.5},28.979999999999997,null,false,0,0,0,0,0,0,0,1,6,{"$f":"$G4*1.2*2","v":16.559999999999999},{"$f":"$G4*1.2*1.2","v":9.9359999999999982}]
["AOP Morgon, La Côte du Py, Domaine Marcel Joubert",2018,"Gamay","NATURE",null,"Biaggio Vinom 0778720063",11.25,{"$f":"_xlfn.IFS(G5<5,4,G5<6.5,3.75,G5<8,3.5,G5<10,3.25,G5<12,3,G5<15,2.85,G5<20,2.8,G5<50,2.65)","v":3},40.5,null,false,0,0,0,0,0,0,0,null,6,27,16.2]
["AOP Beaujolais, Beaujolais is not dead, Domaine Chasselay",2020,"Gamay","BIO",null,"Emmanuel Meffre 0672386975",7.06,{"$f":"_xlfn.IFS(G6<5,4,G6<6.5,3.75,G6<8,3.5,G6<10,3.25,G6<12,3,G6<15,2.85,G6<20,2.8,G6<50,2.65)","v":3.5},29.651999999999997,null,false,0,0,0,0,0,0,0,null,18,16.943999999999999,10.166399999999999]
["VDF Je t'aime mais j'ai soif, Domaine Chasselay",2020,"Gamay","BIO",null,"Emmanuel Meffre 0672386975",5.46,{"$f":"_xlfn.IFS(G7<5,4,G7<6.5,3.75,G7<8,3.5,G7<10,3.25,G7<12,3,G7<15,2.85,G7<20,2.8,G7<50,2.65)","v":3.75},24.57,null,false,0,0,0,0,0,0,0,null,18,13.103999999999999,7.8623999999999992]
["AOP Moulin-À-Vent, Famille Chasselay",2016," Gamay","BIO",null,"Emmanuel Meffre 0672386975",10.76,{"$f":"_xlfn.IFS(G8<5,4,G8<6.5,3.75,G8<8,3.5,G8<10,3.25,G8<12,3,G8<15,2.85,G8<20,2.8,G8<50,2.65)","v":3},38.735999999999997,null,false,0,0,0,0,0,0,0,17,0,25.823999999999998,15.494399999999999]
["VDF Beaujolais, L’épaisseur du moment présent, Romain des Grottes",2017,"Gamay","BIO","NATURE","X",6.8,{"$f":"_xlfn.IFS(G9<5,4,G9<6.5,3.75,G9<8,3.5,G9<10,3.25,G9<12,3,G9<15,2.85,G9<20,2.8,G9<50,2.65)","v":3.5},28.560000000000002,"x",true,1,1,0,0,0,1,0,18,0,{"$f":"$G9*1.2*2","v":16.32},9.7919999999999998]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(S3:S9)","v":36},{"$f":"SUM(T3:T9)","v":48}]
[]
[null,null,null,null,null,null,null,null,"TOTAL VINS","TOTAL RUPTURES"]
[null,null,null,null,null,null,null,null,{"$f":"(ROWS(VINSBEAUJ))-J13","v":5},{"$f":"COUNTIF(VINSBEAUJ,\"VRAI\")","v":2}]
[null,null,null,null,null,null,null,null,"BIO","BIO"]
[null,null,null,null,null,null,null,null,{"$f":"COUNTIF(AGRIBEAUJ,\"BIO\")-J15","v":3},{"$f":"SUM(RBIOBEAUJ)","v":2}]
[null,null,null,null,null,null,null,null,"NATURE","NATURE"]
[null,null,null,null,null,null,null,null,{"$f":"COUNTIF(AGRIBEAUJ,\"NATURE\")-J17","v":3},{"$f":"SUM(RNATUREBEAUJ)","v":1}]
[null,null,null,null,null,null,null,null,"CONVENTIONNEL","CONVENTIONNEL"]
[null,null,null,null,null,null,null,null,{"$f":"COUNTIF(AGRIBEAUJ,\"CON\")-J19","v":0},{"$f":"SUM(RCONBEAUJ)","v":0}]
[null,null,null,null,null,null,null,null,"BIODYNAMIE","BIODYNAMIE"]
[null,null,null,null,null,null,null,null,{"$f":"COUNTIF(AGRIBEAUJ,\"BIODY\")-J21","v":0},{"$f":"SUM(RBIODYBEAUJ)","v":0}]
[null,null,null,null,null,null,null,null,"ENTREE DE GAMME","ENTREE DE GAMME"]
[null,null,null,null,null,null,null,null,{"$f":"COUNTIFS(PVTTCBEAUJ,\"<26\")-J23","v":1},{"$f":"SUM(REGBEA)","v":1}]
[null,null,null,null,null,null,null,null,"MILIEU DE GAMME","MILIEU DE GAMME"]
[null,null,null,null,null,null,null,null,{"$f":"SUMPRODUCT((PVTTCBEAUJ>25.99)*(PVTTCBEAUJ<37))-J25","v":2},{"$f":"SUM(RMGBEA)","v":1}]
[null,null,null,null,null,null,null,null,"HAUT DE GAMME","HAUT DE GAMME"]
[null,null,null,null,null,null,null,null,{"$f":"COUNTIFS(PVTTCBEAUJ,\">36,99\")-J27","v":2},{"$f":"SUM(RHGBEA)","v":0}]

{"sheet":"Languedoc","index":7,"n_rows":40,"n_cols":22,"rows_kept":40,"cut":false,"hidden":false,"merged":[[0,0,1,0],[0,3,0,4],[22,0,23,0],[22,1,23,1],[22,2,23,10]]}
[null,"Millésime","Cépages","Agriculture",null,"Fournisseurs","PAHT","Coeff supposé","PVTTC Supposé","Rupture\n(X)",null,"BIO","NATURE","CON","BIODY","EG","MG","HG","INV","COM","PVEMP","PVGROS"]
[]
["IGP Pays d’Hérault, Étincelle, Domaine de La Clapière",2016,"Syrah","CON",null,"?",15,{"$f":"_xlfn.IFS(G3<5,4,G3<6.5,3.75,G3<8,3.5,G3<10,3.25,G3<12,3,G3<15,2.85,G3<20,2.8,G3<50,2.65)","v":2.8},{"$f":"G3*1.2*H3","v":50.4},null,{"$f":"IF(J3=\"X\",(TRUE),(FALSE))","v":false},{"$f":"IF(AND(OR($D3=\"BIO\",$E3=\"BIO\"),$K3=TRUE),1,0)","v":0},{"$f":"IF(AND(OR($D3=\"NATURE\",$E3=\"NATURE\"),$K3=TRUE),1,0)","v":0},{"$f":"IF(AND(OR($D3=\"CON\",$E3=\"CON\"),$K3=TRUE),1,0)","v":0},{"$f":"IF(AND(OR($D3=\"BIODY\",$E3=\"BIODY\"),$K3=TRUE),1,0)","v":0},{"$f":"IF(AND($I3<26,$K3=TRUE),1,0)","v":0},{"$f":"IF(AND((I3>25.99)*(I3<37),$K3=TRUE),1,0)","v":0},{"$f":"IF(AND(36.99<$I3,$K3=TRUE),1,0)","v":0},1,0,{"$f":"$G3*1.2*2","v":36},{"$f":"$G3*1.2*1.2","v":21.599999999999998}]
["AOC Pic Saint-Loup, Les Calades, Domaine Foulaquier",2019,"80%Syrah, 20%Grenache","BIODY",null,"Aymeric Vignapart 0670827124",14.95,{"$f":"_xlfn.IFS(G4<5,4,G4<6.5,3.75,G4<8,3.5,G4<10,3.25,G4<12,3,G4<15,2.85,G4<20,2.8,G4<50,2.65)","v":2.85},51.128999999999998,null,false,0,0,0,0,0,0,0,null,6,{"$f":"$G4*1.2*2","v":35.879999999999995},{"$f":"$G4*1.2*1.2","v":21.527999999999995}]
["VDF Le Zulu, Château Maris ",2018,"Grenache, Syrah","BIO",null,"Biaggio Vinom 0778720063",6.3,{"$f":"_xlfn.IFS(G5<5,4,G5<6.5,3.75,G5<8,3.5,G5<10,3.25,G5<12,3,G5<15,2.85,G5<20,2.8,G5<50,2.65)","v":3.75},28.349999999999998,"x",true,1,0,0,0,0,1,0,null,0,15.12,9.0719999999999992]
["AOP Côtes du Roussillon, Le Petit Pas, Mas Janeil",2017,"55%Grenache, 22%Syrah, 18%Carignan, 5%Mourvèdre","BIO",null,"Biaggio Vinom 0778720063",6.55,{"$f":"_xlfn.IFS(G6<5,4,G6<6.5,3.75,G6<8,3.5,G6<10,3.25,G6<12,3,G6<15,2.85,G6<20,2.8,G6<50,2.65)","v":3.5},27.509999999999998,"x",true,1,0,0,0,0,1,0,null,0,15.719999999999999,9.4319999999999986]
["IGP Gard, La Douzième, Aubaï Mema",2014,"95%Syrah, 5%Viognier","BIO",null,"Biaggio Vinom 0778720063",9.9,{"$f":"_xlfn.IFS(G7<5,4,G7<6.5,3.75,G7<8,3.5,G7<10,3.25,G7<12,3,G7<15,2.85,G7<20,2.8,G7<50,2.65)","v":3.25},38.61,null,false,0,0,0,0,0,0,0,5,0,23.76,14.256]
["AOP Côtes du Roussillon-Villages, Mas d’en Janeil, François Lurton",2016,"60%Grenache, 20%Carignan, 10%Syrah, 10%Mourvèdre","CON",null,"Biaggio Vinom 0778720063",11.5,{"$f":"_xlfn.IFS(G8<5,4,G8<6.5,3.75,G8<8,3.5,G8<10,3.25,G8<12,3,G8<15,2.85,G8<20,2.8,G8<50,2.65)","v":3},41.4,null,false,0,0,0,0,0,0,0,16,0,27.599999999999998,16.559999999999999]
["AOP Fitou, Cuvée des ardoises, Château des Erles",2017," 40%Syrah, 35%Grenache noir, 25%Carignan","CON",null,"Biaggio Vinom 0778720063",11.9,{"$f":"_xlfn.IFS(G9<5,4,G9<6.5,3.75,G9<8,3.5,G9<10,3.25,G9<12,3,G9<15,2.85,G9<20,2.8,G9<50,2.65)","v":3},42.839999999999996,null,false,0,0,0,0,0,0,0,1,0,28.56,17.135999999999999]
["IGP Côtes du Brian, Bergerie, Domaine de Cantaussel",2018,"Grenache, Carignan, Syrah","BIO",null,"Cédric Schiltz 0612108579",6.8,{"$f":"_xlfn.IFS(G10<5,4,G10<6.5,3.75,G10<8,3.5,G10<10,3.25,G10<12,3,G10<15,2.85,G10<20,2.8,G10<50,2.65)","v":3.5},28.560000000000002,null,false,0,0,0,0,0,0,0,16,0,16.32,9.7919999999999998]
["AOC Minervois, Estelum, Domaine de Cantaussel",2014,"Carignan, Syrah, Grenache","BIO",null,"Cédric Schiltz 0612108579",9,{"$f":"_xlfn.IFS(G11<5,4,G11<6.5,3.75,G11<8,3.5,G11<10,3.25,G11<12,3,G11<15,2.85,G11<20,2.8,G11<50,2.65)","v":3.25},35.099999999999994,null,false,0,0,0,0,0,0,0,1,0,21.599999999999998,12.959999999999999]
["AOC Minervois, Le vin de plume, Domaine du Somail",2018,"Mourvèdre, Syrah","BIODY",null,"Didier Bordas 0660995478",7.4,{"$f":"_xlfn.IFS(G12<5,4,G12<6.5,3.75,G12<8,3.5,G12<10,3.25,G12<12,3,G12<15,2.85,G12<20,2.8,G12<50,2.65)","v":3.5},31.080000000000002,null,false,0,0,0,0,0,0,0,null,6,17.760000000000002,10.656000000000001]
["AOC Corbières, Sur Pilotis, Château Montfin",2018,"40% Carignan, 30%Carignan macération carbonique, 30%Grenache","BIODY",null,"Didier Bordas 0660995478",7.13,{"$f":"_xlfn.IFS(G13<5,4,G13<6.5,3.75,G13<8,3.5,G13<10,3.25,G13<12,3,G13<15,2.85,G13<20,2.8,G13<50,2.65)","v":3.5},29.945999999999998,null,false,0,0,0,0,0,0,0,null,6,17.111999999999998,10.267199999999999]
["VDF Languedoc, Vous avez Carte Blanche, Le Clos des pères",2018,"Carignan","NATURE",null,"Le clos des pères 0628086552",6.5,{"$f":"_xlfn.IFS(G14<5,4,G14<6.5,3.75,G14<8,3.5,G14<10,3.25,G14<12,3,G14<15,2.85,G14<20,2.8,G14<50,2.65)","v":3.5},27.3,null,false,0,0,0,0,0,0,0,25,0,15.6,9.36]
["AOC Minervois la Livinière, Le Rouge des vents, Le clos des pères",2017," Syrah, Grenache","NATURE",null,"Le clos des pères 0628086552",9.5,{"$f":"_xlfn.IFS(G15<5,4,G15<6.5,3.75,G15<8,3.5,G15<10,3.25,G15<12,3,G15<15,2.85,G15<20,2.8,G15<50,2.65)","v":3.25},37.050000000000004,null,false,0,0,0,0,0,0,0,9,0,22.8,13.68]
["VDF Languedoc, Le Vire-Voltant, Les Équilibristes",2018,"Carignan","BIO",null,"Nicolas Jaboulet 0680320770",9.9,{"$f":"_xlfn.IFS(G16<5,4,G16<6.5,3.75,G16<8,3.5,G16<10,3.25,G16<12,3,G16<15,2.85,G16<20,2.8,G16<50,2.65)","v":3.25},38.61,null,false,0,0,0,0,0,0,0,18,0,23.76,14.256]
["AOP Languedoc Pézenas, Les Sept Vaillants, Les Équilibristes",2016,"60%Syrah, 20%Mourvedre, 20%Grenache","BIO",null,"Nicolas Jaboulet 0680320770",9.9,{"$f":"_xlfn.IFS(G17<5,4,G17<6.5,3.75,G17<8,3.5,G17<10,3.25,G17<12,3,G17<15,2.85,G17<20,2.8,G17<50,2.65)","v":3.25},38.61,null,false,0,0,0,0,0,0,0,14,0,23.76,14.256]
["IGP Pays d’Hérault, Apollo 93, Yann le Bouler",2017,"70%Carignan, 30%Syrah","BIO",null,"X",7.9,{"$f":"_xlfn.IFS(G18<5,4,G18<6.5,3.75,G18<8,3.5,G18<10,3.25,G18<12,3,G18<15,2.85,G18<20,2.8,G18<50,2.65)","v":3.5},33.18,null,false,0,0,0,0,0,0,0,1,0,18.96,11.375999999999999]
["AOP Corbières, Au Village, Castelmaure",2016,"50%Carignan, 30%Grenache noir, 20%Syrah","CON",null,"X",6.2,{"$f":"_xlfn.IFS(G19<5,4,G19<6.5,3.75,G19<8,3.5,G19<10,3.25,G19<12,3,G19<15,2.85,G19<20,2.8,G19<50,2.65)","v":3.75},27.9,null,false,0,0,0,0,0,0,0,1,0,14.879999999999999,8.927999999999999]
["VDF Languedoc, Carignan, Jean Lignières",2017,"Carignan","BIODY","NATURE","X",7.95,{"$f":"_xlfn.IFS(G20<5,4,G20<6.5,3.75,G20<8,3.5,G20<10,3.25,G20<12,3,G20<15,2.85,G20<20,2.8,G20<50,2.65)","v":3.5},33.39,null,false,0,0,0,0,0,0,0,1,0,19.079999999999998,11.447999999999999]
["AOP Corbières, L’ésprit du vent, Nouvelle vague (Magnum)",2016,"50%Carignan, 35%Grenache noir, 15%Syrah","CON",null,"X",7.46,{"$f":"_xlfn.IFS(G21<5,4,G21<6.5,3.75,G21<8,3.5,G21<10,3.25,G21<12,3,G21<15,2.85,G21<20,2.8,G21<50,2.65)","v":3.5},31.332000000000001,null,false,0,0,0,0,0,0,0,2,0,17.904,10.7424]
["AOP Corbières, La Réputation, Castelmaure",2016,"50%Syrah, 25%Carignan, 25%Grenache","CON",null,"X",12,{"$f":"_xlfn.IFS(G22<5,4,G22<6.5,3.75,G22<8,3.5,G22<10,3.25,G22<12,3,G22<15,2.85,G22<20,2.8,G22<50,2.65)","v":2.85},41.04,null,false,0,0,0,0,0,0,0,2,0,28.799999999999997,17.279999999999998]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(S3:S22)","v":113},{"$f":"SUM(T3:T22)","v":18}]
[]
[null,null,null,null,null,null,null,null,"TOTAL VINS","TOTAL RUPTURES"]
[null,null,null,null,null,null,null,null,{"$f":"(ROWS(VINSLANGU))-J26","v":18},{"$f":"COUNTIF(VINSLANGU,\"VRAI\")","v":2}]
[null,null,null,null,null,null,null,null,"BIO","BIO"]
[null,null,null,null,null,null,null,null,{"$f":"COUNTIF(AGRILANG,\"BIO\")-J28","v":6},{"$f":"SUM(RBIOLANG)","v":2}]
[null,null,null,null,null,null,null,null,"NATURE","NATURE"]
[null,null,null,null,null,null,null,null,{"$f":"COUNTIF(AGRILANG,\"NATURE\")-J30","v":3},{"$f":"SUM(RNATURELANG)","v":0}]
[null,null,null,null,null,null,null,null,"CONVENTIONNEL","CONVENTIONNEL"]
[null,null,null,null,null,null,null,null,{"$f":"COUNTIF(AGRILANG,\"CON\")-J32","v":6},{"$f":"SUM(RCONLANG)","v":0}]
[null,null,null,null,null,null,null,null,"BIODYNAMIE","BIODYNAMIE"]
[null,null,null,null,null,null,null,null,{"$f":"COUNTIF(AGRILANG,\"BIODY\")-J34","v":4},{"$f":"SUM(RBIODYLANG)","v":0}]
[null,null,null,null,null,null,null,null,"ENTREE DE GAMME","ENTREE DE GAMME"]
[null,null,null,null,null,null,null,null,{"$f":"COUNTIFS(PVTTCLANG,\"<26\")-J36","v":0},{"$f":"SUM(REGLAN)","v":0}]
[null,null,null,null,null,null,null,null,"MILIEU DE GAMME","MILIEU DE GAMME"]
[null,null,null,null,null,null,null,null,{"$f":"SUMPRODUCT((PVTTCLANG>25.99)*(PVTTCLANG<37))-J38","v":9},{"$f":"SUM(RMGLAN)","v":2}]
[null,null,null,null,null,null,null,null,"HAUT DE GAMME","HAUT DE GAMME"]
[null,null,null,null,null,null,null,null,{"$f":"COUNTIFS(PVTTCLANG,\">36,99\")-J40","v":9},{"$f":"SUM(RHGLAN)","v":0}]

{"sheet":"Vallée du Rhône","index":8,"n_rows":30,"n_cols":22,"rows_kept":30,"cut":false,"hidden":false,"merged":[[0,0,1,0],[0,3,0,4],[12,0,13,0],[12,1,13,1],[12,2,13,10]]}
[null,"Millésime","Cépages","Agriculture",null,"Fournisseurs","PAHT","Coeff supposé","PVTTC Supposé","Rupture\n(X)",null,"BIO","NATURE","CON","BIODY","EG","MG","HG","INV","COM","PVEMP","PVGROS"]
[]
["IGP Var, Coteaux du Verdon, Domaine de la Mongestine",2019,"60%Syrah, 40%Grenache","BIO",null,"Didier Bordas 0660995478",7.9,{"$f":"_xlfn.IFS(G3<5,4,G3<6.5,3.75,G3<8,3.5,G3<10,3.25,G3<12,3,G3<15,2.85,G3<20,2.8,G3<50,2.65)","v":3.5},{"$f":"G3*1.2*H3","v":33.18},null,{"$f":"IF(J3=\"X\",(TRUE),(FALSE))","v":false},{"$f":"IF(AND(OR($D3=\"BIO\",$E3=\"BIO\"),$K3=TRUE),1,0)","v":0},{"$f":"IF(AND(OR($D3=\"NATURE\",$E3=\"NATURE\"),$K3=TRUE),1,0)","v":0},{"$f":"IF(AND(OR($D3=\"CON\",$E3=\"CON\"),$K3=TRUE),1,0)","v":0},{"$f":"IF(AND(OR($D3=\"BIODY\",$E3=\"BIODY\"),$K3=TRUE),1,0)","v":0},{"$f":"IF(AND($I3<26,$K3=TRUE),1,0)","v":0},{"$f":"IF(AND((I3>25.99)*(I3<37),$K3=TRUE),1,0)","v":0},{"$f":"IF(AND(36.99<$I3,$K3=TRUE),1,0)","v":0},9,0,{"$f":"$G3*1.2*2","v":18.96},{"$f":"$G3*1.2*1.2","v":11.375999999999999}]
["AOC Côtes du Rhône, Domaine du Séminaire",2020,"Grenache, Syrah, Carignan","BIO",null,"Didier Bordas 0660995478",5.14,{"$f":"_xlfn.IFS(G4<5,4,G4<6.5,3.75,G4<8,3.5,G4<10,3.25,G4<12,3,G4<15,2.85,G4<20,2.8,G4<50,2.65)","v":3.75},23.129999999999995,"x",true,1,0,0,0,1,0,0,null,18,{"$f":"$G4*1.2*2","v":12.335999999999999},{"$f":"$G4*1.2*1.2","v":7.4015999999999984}]
["AOC Grignan-les-Adhémar, Héritage, Bonetto-Fabrol",2018,"Syrah","BIO",null,"Franck 0651826004",7,{"$f":"_xlfn.IFS(G5<5,4,G5<6.5,3.75,G5<8,3.5,G5<10,3.25,G5<12,3,G5<15,2.85,G5<20,2.8,G5<50,2.65)","v":3.5},29.400000000000002,null,false,0,0,0,0,0,0,0,8,0,16.8,10.08]
["AOC Costières de Nîmes, Château de Valcombe",2018,"Syrah, Grenache","CON",null,"Franck 0651826004",5.15,{"$f":"_xlfn.IFS(G6<5,4,G6<6.5,3.75,G6<8,3.5,G6<10,3.25,G6<12,3,G6<15,2.85,G6<20,2.8,G6<50,2.65)","v":3.75},23.175000000000001,null,false,0,0,0,0,0,0,0,1,0,12.360000000000001,7.4160000000000004]
["AOC Côtes du Rhône Villages, Terra Vitae, Laudun",2019,"70%Grenache, 30%Syrah","BIO",null,"Phillippe Potier 0680136645",6.81,{"$f":"_xlfn.IFS(G7<5,4,G7<6.5,3.75,G7<8,3.5,G7<10,3.25,G7<12,3,G7<15,2.85,G7<20,2.8,G7<50,2.65)","v":3.5},28.601999999999997,"x",true,1,0,0,0,0,1,0,null,0,16.343999999999998,9.8063999999999982]
["AOC Côtes du Rhône, Enfant Terrible, Laudun Chusclan",2019,"Grenache, Carignan, Syrah, Mourvèdre, Cinsault","Nature",null,"Phillippe Potier 0680136645",5.2,{"$f":"_xlfn.IFS(G8<5,4,G8<6.5,3.75,G8<8,3.5,G8<10,3.25,G8<12,3,G8<15,2.85,G8<20,2.8,G8<50,2.65)","v":3.75},23.400000000000002,"x",true,0,1,0,0,1,0,0,null,0,12.48,7.4879999999999995]
["AOC Cornas, Cave de Tain",2017,"Syrah","BIO",null,"Phillippe Potier 0680136645",20.65,{"$f":"_xlfn.IFS(G9<5,4,G9<6.5,3.75,G9<8,3.5,G9<10,3.25,G9<12,3,G9<15,2.85,G9<20,2.8,G9<50,2.65)","v":2.65},65.666999999999987,null,false,0,0,0,0,0,0,0,null,6,49.559999999999995,29.735999999999997]
["AOC Saint-Joseph, Cave de Tain",2019,"Syrah","BIO",null,"Phillippe Potier 0680136645",12.6,{"$f":"_xlfn.IFS(G10<5,4,G10<6.5,3.75,G10<8,3.5,G10<10,3.25,G10<12,3,G10<15,2.85,G10<20,2.8,G10<50,2.65)","v":2.85},43.091999999999999,null,false,0,0,0,0,0,0,0,null,12,30.24,18.143999999999998]
["AOC Crozes Hermitage, Cave de Tain",2019,"Syrah","BIO",null,"Phillippe Potier 0680136645",8.8000000000000007,{"$f":"_xlfn.IFS(G11<5,4,G11<6.5,3.75,G11<8,3.5,G11<10,3.25,G11<12,3,G11<15,2.85,G11<20,2.8,G11<50,2.65)","v":3.25},34.32,null,false,0,0,0,0,0,0,0,null,18,21.12,12.672000000000001]
["AOC Côtes du Rhône-Villages, Villa Volitnia, Chusclan",2016," Syrah, Grenache","CON",null,"Phillippe Potier 0680136645",15.85,{"$f":"_xlfn.IFS(G12<5,4,G12<6.5,3.75,G12<8,3.5,G12<10,3.25,G12<12,3,G12<15,2.85,G12<20,2.8,G12<50,2.65)","v":2.8},53.255999999999993,null,false,0,0,0,0,0,0,0,9,0,38.04,22.823999999999998]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(S3:S12)","v":27},{"$f":"SUM(T3:T12)","v":54}]
[]
[null,null,null,null,null,null,null,null,"TOTAL VINS","TOTAL RUPTURES"]
[null,null,null,null,null,null,null,null,{"$f":"(ROWS(VINSRHON))-J16","v":7},{"$f":"COUNTIF(VINSRHON,\"VRAI\")","v":3}]
[null,null,null,null,null,null,null,null,"BIO","BIO"]
[null,null,null,null,null,null,null,null,{"$f":"COUNTIF(AGRIVDR,\"BIO\")-J18","v":5},{"$f":"SUM(RBIOVDR)","v":2}]
[null,null,null,null,null,null,null,null,"NATURE","NATURE"]
[null,null,null,null,null,null,null,null,{"$f":"COUNTIF(AGRIVDR,\"NATURE\")-J20","v":0},{"$f":"SUM(RNATUREVDR)","v":1}]
[null,null,null,null,null,null,null,null,"CONVENTIONNEL","CONVENTIONNEL"]
[null,null,null,null,null,null,null,null,{"$f":"COUNTIF(AGRIVDR,\"CON\")-J22","v":2},{"$f":"SUM(RCONVDR)","v":0}]
[null,null,null,null,null,null,null,null,"BIODYNAMIE","BIODYNAMIE"]
[null,null,null,null,null,null,null,null,{"$f":"COUNTIF(AGRIVDR,\"BIODY\")-J24","v":0},{"$f":"SUM(RBIODYVDR)","v":0}]
[null,null,null,null,null,null,null,null,"ENTREE DE GAMME","ENTREE DE GAMME"]
[null,null,null,null,null,null,null,null,{"$f":"COUNTIFS(PVTTCVDR,\"<26\")-J26","v":1},{"$f":"SUM(REGVDR)","v":2}]
[null,null,null,null,null,null,null,null,"MILIEU DE GAMME","MILIEU DE GAMME"]
[null,null,null,null,null,null,null,null,{"$f":"SUMPRODUCT((PVTTCVDR>25.99)*(PVTTCVDR<37))-J28","v":3},{"$f":"SUM(RMGVDR)","v":1}]
[null,null,null,null,null,null,null,null,"HAUT DE GAMME","HAUT DE GAMME"]
[null,null,null,null,null,null,null,null,{"$f":"COUNTIFS(PVTTCVDR,\">36,99\")-J30","v":3},{"$f":"SUM(RHGVDR)","v":0}]

{"sheet":"Vallée de la Loire","index":9,"n_rows":29,"n_cols":22,"rows_kept":29,"cut":false,"hidden":false,"merged":[[0,0,1,0],[0,3,0,4],[11,0,12,0],[11,1,12,1],[11,2,12,10]]}
[null,"Millésime","Cépages","Agriculture",null,"Fournisseurs","PAHT","Coeff supposé","PVTTC Supposé","Rupture\n(X)",null,"BIO","NATURE","CON","BIODY","EG","MG","HG","INV","COM","PVEMP","PVGROS"]
[]
["VDF Loire, La Friponne, Pierre Chauvin",2018,"Grolleau noir","BIO",null,"Aymeric Vignapart 0670827124",6.9,{"$f":"_xlfn.IFS(G3<5,4,G3<6.5,3.75,G3<8,3.5,G3<10,3.25,G3<12,3,G3<15,2.85,G3<20,2.8,G3<50,2.65)","v":3.5},{"$f":"G3*1.2*H3","v":28.979999999999997},null,{"$f":"IF(J3=\"X\",(TRUE),(FALSE))","v":false},{"$f":"IF(AND(OR($D3=\"BIO\",$E3=\"BIO\"),$K3=TRUE),1,0)","v":0},{"$f":"IF(AND(OR($D3=\"NATURE\",$E3=\"NATURE\"),$K3=TRUE),1,0)","v":0},{"$f":"IF(AND(OR($D3=\"CON\",$E3=\"CON\"),$K3=TRUE),1,0)","v":0},{"$f":"IF(AND(OR($D3=\"BIODY\",$E3=\"BIODY\"),$K3=TRUE),1,0)","v":0},{"$f":"IF(AND($I3<26,$K3=TRUE),1,0)","v":0},{"$f":"IF(AND((I3>25.99)*(I3<37),$K3=TRUE),1,0)","v":0},{"$f":"IF(AND(36.99<$I3,$K3=TRUE),1,0)","v":0},14,0,{"$f":"$G3*1.2*2","v":16.559999999999999},{"$f":"$G3*1.2*1.2","v":9.9359999999999982}]
["AOC Sancerre, Domaine Serge Laloue",2018,"Pinot noir","CON",null,"Biaggio Vinom 0778720063",10.5,{"$f":"_xlfn.IFS(G4<5,4,G4<6.5,3.75,G4<8,3.5,G4<10,3.25,G4<12,3,G4<15,2.85,G4<20,2.8,G4<50,2.65)","v":3},37.799999999999997,null,false,0,0,0,0,0,0,0,1,6,{"$f":"$G4*1.2*2","v":25.2},{"$f":"$G4*1.2*1.2","v":15.12}]
["AOC Cheverny, Domaine de Montcy",2018,"Pinot noir, Gamay, Côt","BIO",null,"Biaggio Vinom 0778720063",7.75,{"$f":"_xlfn.IFS(G5<5,4,G5<6.5,3.75,G5<8,3.5,G5<10,3.25,G5<12,3,G5<15,2.85,G5<20,2.8,G5<50,2.65)","v":3.5},32.549999999999997,null,false,0,0,0,0,0,0,0,2,6,18.599999999999998,11.159999999999998]
["VDF, L'enfant rebelle, Antoine de la Farge",2019,"Pinot noir","CON",null,"Didier Bordas 0660995478",6.15,{"$f":"_xlfn.IFS(G6<5,4,G6<6.5,3.75,G6<8,3.5,G6<10,3.25,G6<12,3,G6<15,2.85,G6<20,2.8,G6<50,2.65)","v":3.75},27.675000000000001,"x",true,0,0,1,0,0,1,0,null,0,14.76,8.8559999999999999]
["AOP Chinon, Les Gallières, Domaine Jourdan",2018,"Cabernet Franc","BIODY",null,"Didier Bordas 0660995478",7.67,{"$f":"_xlfn.IFS(G7<5,4,G7<6.5,3.75,G7<8,3.5,G7<10,3.25,G7<12,3,G7<15,2.85,G7<20,2.8,G7<50,2.65)","v":3.5},32.213999999999999,null,false,0,0,0,0,0,0,0,null,12,18.407999999999998,11.044799999999999]
["IGP Vin de Vendée, Bel Canto, Domaine Prieuré La Chaume",2018,"Merlot","BIODY",null,"Didier Bordas 0660995478",11.64,{"$f":"_xlfn.IFS(G8<5,4,G8<6.5,3.75,G8<8,3.5,G8<10,3.25,G8<12,3,G8<15,2.85,G8<20,2.8,G8<50,2.65)","v":3},41.903999999999996,null,false,0,0,0,0,0,0,0,null,6,27.936,16.761599999999998]
["AOC Saumur Champigny, Château de Chaintres, Vieilles vignes",2018,"Cabernet franc","BIO",null,"Didier Bordas 0660995478",10.4,{"$f":"_xlfn.IFS(G9<5,4,G9<6.5,3.75,G9<8,3.5,G9<10,3.25,G9<12,3,G9<15,2.85,G9<20,2.8,G9<50,2.65)","v":3},37.44,null,false,0,0,0,0,0,0,0,3,0,24.96,14.975999999999999]
["AOP Saumur Champigny, Les Cinq, Famille Daheuiller",2014,"Cabernet Franc","BIO",null,"Franck 0651826004",7,{"$f":"_xlfn.IFS(G10<5,4,G10<6.5,3.75,G10<8,3.5,G10<10,3.25,G10<12,3,G10<15,2.85,G10<20,2.8,G10<50,2.65)","v":3.5},29.400000000000002,null,false,0,0,0,0,0,0,0,3,0,16.8,10.08]
["VDF Loire, Le Joufflu, Les Équilibristes",2018,"90%Grolleau noir, 10%Pineau D’Aunis","CON",null,"Nicolas Jaboulet 0680320770",7.9,{"$f":"_xlfn.IFS(G11<5,4,G11<6.5,3.75,G11<8,3.5,G11<10,3.25,G11<12,3,G11<15,2.85,G11<20,2.8,G11<50,2.65)","v":3.5},33.18,null,false,0,0,0,0,0,0,0,5,12,18.96,11.375999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(S3:S11)","v":28},{"$f":"SUM(T3:T11)","v":42}]
[]
[null,null,null,null,null,null,null,null,"TOTAL VINS","TOTAL RUPTURES"]
[null,null,null,null,null,null,null,null,{"$f":"(ROWS(VINSLOIR))-J15","v":8},{"$f":"COUNTIF(VINSLOIR,\"VRAI\")","v":1}]
[null,null,null,null,null,null,null,null,"BIO","BIO"]
[null,null,null,null,null,null,null,null,{"$f":"COUNTIF(AGRIVDL,\"BIO\")-J17","v":4},{"$f":"SUM(RBIOVDL)","v":0}]
[null,null,null,null,null,null,null,null,"NATURE","NATURE"]
[null,null,null,null,null,null,null,null,{"$f":"COUNTIF(AGRIVDL,\"NATURE\")-J19","v":0},{"$f":"SUM(RNATUREVDL)","v":0}]
[null,null,null,null,null,null,null,null,"CONVENTIONNEL","CONVENTIONNEL"]
[null,null,null,null,null,null,null,null,{"$f":"COUNTIF(AGRIVDL,\"CON\")-J21","v":2},{"$f":"SUM(RCONVDL)","v":1}]
[null,null,null,null,null,null,null,null,"BIODYNAMIE","BIODYNAMIE"]
[null,null,null,null,null,null,null,null,{"$f":"COUNTIF(AGRIVDL,\"BIODY\")-J23","v":2},{"$f":"SUM(RBIODYVDL)","v":0}]
[null,null,null,null,null,null,null,null,"ENTREE DE GAMME","ENTREE DE GAMME"]
[null,null,null,null,null,null,null,null,{"$f":"COUNTIFS(PVTTCVDL,\"<26\")-J25","v":0},{"$f":"SUM(REGVDL)","v":0}]
[null,null,null,null,null,null,null,null,"MILIEU DE GAMME","MILIEU DE GAMME"]
[null,null,null,null,null,null,null,null,{"$f":"SUMPRODUCT((PVTTCVDL>25.99)*(PVTTCVDL<37))-J27","v":5},{"$f":"SUM(RMGVDL)","v":1}]
[null,null,null,null,null,null,null,null,"HAUT DE GAMME","HAUT DE GAMME"]
[null,null,null,null,null,null,null,null,{"$f":"COUNTIFS(PVTTCVDL,\">36,99\")-J29","v":3},{"$f":"SUM(RHGVDL)","v":0}]

{"sheet":"Etrangers","index":10,"n_rows":28,"n_cols":22,"rows_kept":28,"cut":false,"hidden":false,"merged":[[0,0,1,0],[0,3,0,4],[10,0,11,0],[10,1,11,1],[10,2,11,10]]}
[null,"Millésime","Cépages","Agriculture",null,"Fournisseurs","PAHT","Coeff supposé","PVTTC Supposé","Rupture\n(X)",null,"BIO","NATURE","CON","BIODY","EG","MG","HG","INV","COM","PVEMP","PVGROS"]
[]
["DOC Alella, Merla, Celler de les Aus",2017,"Monastrell","BIO","NATURE","?",11.9,{"$f":"_xlfn.IFS(G3<5,4,G3<6.5,3.75,G3<8,3.5,G3<10,3.25,G3<12,3,G3<15,2.85,G3<20,2.8,G3<50,2.65)","v":3},{"$f":"G3*1.2*H3","v":42.839999999999996},null,{"$f":"IF(J3=\"X\",(TRUE),(FALSE))","v":false},{"$f":"IF(AND(OR($D3=\"BIO\",$E3=\"BIO\"),$K3=TRUE),1,0)","v":0},{"$f":"IF(AND(OR($D3=\"NATURE\",$E3=\"NATURE\"),$K3=TRUE),1,0)","v":0},{"$f":"IF(AND(OR($D3=\"CON\",$E3=\"CON\"),$K3=TRUE),1,0)","v":0},{"$f":"IF(AND(OR($D3=\"BIODY\",$E3=\"BIODY\"),$K3=TRUE),1,0)","v":0},{"$f":"IF(AND($I3<26,$K3=TRUE),1,0)","v":0},{"$f":"IF(AND((I3>25.99)*(I3<37),$K3=TRUE),1,0)","v":0},{"$f":"IF(AND(36.99<$I3,$K3=TRUE),1,0)","v":0},1,0,{"$f":"$G3*1.2*2","v":28.56},{"$f":"$G3*1.2*1.2","v":17.135999999999999}]
["DOC Rosso di Montepulciano, Azienda Casale",2016,"85%Sangiovese, 10%Canaiolo Nero, 5%Mammolo","CON",null,"Axel Gustoworld 0625338003",6.95,{"$f":"_xlfn.IFS(G4<5,4,G4<6.5,3.75,G4<8,3.5,G4<10,3.25,G4<12,3,G4<15,2.85,G4<20,2.8,G4<50,2.65)","v":3.5},29.189999999999998,null,false,0,0,0,0,0,0,0,2,0,{"$f":"$G4*1.2*2","v":16.68},{"$f":"$G4*1.2*1.2","v":10.007999999999999}]
["IGP Salina Rosso, Hauner, Hauner Carlo",2017,"60%Nero d’avola, 40%Nerello mascalese","CON",null,"Axel Gustoworld 0625338003",11.91,{"$f":"_xlfn.IFS(G5<5,4,G5<6.5,3.75,G5<8,3.5,G5<10,3.25,G5<12,3,G5<15,2.85,G5<20,2.8,G5<50,2.65)","v":3},42.875999999999998,null,false,0,0,0,0,0,0,0,5,0,28.584,17.150399999999998]
["IGP Negroamaro Salento, Lifili, A6mani",2019,"Negroamaro","CON",null,"Axel Gustoworld 0625338003",6.95,{"$f":"_xlfn.IFS(G6<5,4,G6<6.5,3.75,G6<8,3.5,G6<10,3.25,G6<12,3,G6<15,2.85,G6<20,2.8,G6<50,2.65)","v":3.5},29.189999999999998,null,false,0,0,0,0,0,0,0,32,0,16.68,10.007999999999999]
["IGP Terre Siciliane, Omnis, Funaro",2016," Nero d’avola","BIO",null,"Axel Gustoworld 0625338003",13.7,{"$f":"_xlfn.IFS(G7<5,4,G7<6.5,3.75,G7<8,3.5,G7<10,3.25,G7<12,3,G7<15,2.85,G7<20,2.8,G7<50,2.65)","v":2.85},46.853999999999992,null,false,0,0,0,0,0,0,0,3,0,32.879999999999995,19.727999999999998]
["VT Valdejalón, Botijo Rojo",2018,"Grenache noir","CON",null,"Axel Gustoworld 0625338003",6.73,{"$f":"_xlfn.IFS(G8<5,4,G8<6.5,3.75,G8<8,3.5,G8<10,3.25,G8<12,3,G8<15,2.85,G8<20,2.8,G8<50,2.65)","v":3.5},28.266000000000002,null,false,0,0,0,0,0,0,0,11,0,16.152000000000001,9.6912000000000003]
["DOC Sicilia, Nero d’Avola, Funaro",2019,"Nero d’Avola","BIO",null,"Axel Gustoworld 0625338003",7.84,{"$f":"_xlfn.IFS(G9<5,4,G9<6.5,3.75,G9<8,3.5,G9<10,3.25,G9<12,3,G9<15,2.85,G9<20,2.8,G9<50,2.65)","v":3.5},32.927999999999997,null,false,0,0,0,0,0,0,0,4,0,18.815999999999999,11.289599999999998]
["Alla Costiera",2017,"Cabernet Sauvignon, Merlot","BIO","NATURE","X",5.5,{"$f":"_xlfn.IFS(G10<5,4,G10<6.5,3.75,G10<8,3.5,G10<10,3.25,G10<12,3,G10<15,2.85,G10<20,2.8,G10<50,2.65)","v":3.75},24.75,null,false,0,0,0,0,0,0,0,6,0,13.2,7.919999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(S3:S10)","v":64},{"$f":"SUM(T3:T10)","v":0}]
[]
[null,null,null,null,null,null,null,null,"TOTAL VINS","TOTAL RUPTURES"]
[null,null,null,null,null,null,null,null,{"$f":"(ROWS(VINSETR))-J14","v":8},{"$f":"COUNTIF(VINSETR,\"VRAI\")","v":0}]
[null,null,null,null,null,null,null,null,"BIO","BIO"]
[null,null,null,null,null,null,null,null,{"$f":"COUNTIF(AGRIETR,\"BIO\")-J16","v":4},{"$f":"SUM(RBIOETR)","v":0}]
[null,null,null,null,null,null,null,null,"NATURE","NATURE"]
[null,null,null,null,null,null,null,null,{"$f":"COUNTIF(AGRIETR,\"NATURE\")-J18","v":2},{"$f":"SUM(RNATUREETR)","v":0}]
[null,null,null,null,null,null,null,null,"CONVENTIONNEL","CONVENTIONNEL"]
[null,null,null,null,null,null,null,null,{"$f":"COUNTIF(AGRIETR,\"CON\")-J20","v":4},{"$f":"SUM(RCONETR)","v":0}]
[null,null,null,null,null,null,null,null,"BIODYNAMIE","BIODYNAMIE"]
[null,null,null,null,null,null,null,null,{"$f":"COUNTIF(AGRIETR,\"BIODY\")-J22","v":0},{"$f":"SUM(RBIODYETR)","v":0}]
[null,null,null,null,null,null,null,null,"ENTREE DE GAMME","ENTREE DE GAMME"]
[null,null,null,null,null,null,null,null,{"$f":"COUNTIFS(PVTTCETR,\"<26\")-J24","v":1},{"$f":"SUM(REGETR)","v":0}]
[null,null,null,null,null,null,null,null,"MILIEU DE GAMME","MILIEU DE GAMME"]
[null,null,null,null,null,null,null,null,{"$f":"SUMPRODUCT((PVTTCETR>25.99)*(PVTTCETR<37))-J26","v":4},{"$f":"SUM(RMGETR)","v":0}]
[null,null,null,null,null,null,null,null,"HAUT DE GAMME","HAUT DE GAMME"]
[null,null,null,null,null,null,null,null,{"$f":"COUNTIFS(PVTTCETR,\">36,99\")-J28","v":3},{"$f":"SUM(RHGETR)","v":0}]

{"sheet":"Champagne","index":11,"n_rows":22,"n_cols":22,"rows_kept":22,"cut":false,"hidden":false,"merged":[[0,0,1,0],[4,0,5,0],[4,1,5,1],[0,3,0,4],[4,2,5,10]]}
[null,"Millésime","Cépages","Agriculture",null,"Fournisseurs","PAHT","Coeff supposé","PVTTC Supposé","Rupture\n(X)",null,"BIO","NATURE","CON","BIODY","EG","MG","HG","INV","COM","PVEMP","PVGROS"]
[]
["Champagne Gautherot, Brut, Grande réserve",null,null,"CON",null,"Gautherot 0325385003",16.8,{"$f":"_xlfn.IFS(G3<5,4,G3<6.5,3.75,G3<8,3.5,G3<10,3.25,G3<12,3,G3<15,2.85,G3<20,2.8,G3<50,2.65)","v":2.8},{"$f":"G3*1.2*H3","v":56.447999999999993},null,{"$f":"IF(J3=\"X\",(TRUE),(FALSE))","v":false},{"$f":"IF(AND(OR($D3=\"BIO\",$E3=\"BIO\"),$K3=TRUE),1,0)","v":0},{"$f":"IF(AND(OR($D3=\"NATURE\",$E3=\"NATURE\"),$K3=TRUE),1,0)","v":0},{"$f":"IF(AND(OR($D3=\"CON\",$E3=\"CON\"),$K3=TRUE),1,0)","v":0},{"$f":"IF(AND(OR($D3=\"BIODY\",$E3=\"BIODY\"),$K3=TRUE),1,0)","v":0},{"$f":"IF(AND($I3<26,$K3=TRUE),1,0)","v":0},{"$f":"IF(AND((I3>25.99)*(I3<37),$K3=TRUE),1,0)","v":0},{"$f":"IF(AND(36.99<$I3,$K3=TRUE),1,0)","v":0},40,0,{"$f":"$G3*1.2*2","v":40.32},{"$f":"$G3*1.2*1.2","v":24.192}]
["Champagne Gautherot rosé",null,null,"CON",null,"Gautherot 0325385003",16.8,{"$f":"_xlfn.IFS(G4<5,4,G4<6.5,3.75,G4<8,3.5,G4<10,3.25,G4<12,3,G4<15,2.85,G4<20,2.8,G4<50,2.65)","v":2.8},{"$f":"G4*1.2*H4","v":56.447999999999993},null,{"$f":"IF(J4=\"X\",(TRUE),(FALSE))","v":false},{"$f":"IF(AND(OR($D4=\"BIO\",$E4=\"BIO\"),$K4=TRUE),1,0)","v":0},{"$f":"IF(AND(OR($D4=\"NATURE\",$E4=\"NATURE\"),$K4=TRUE),1,0)","v":0},{"$f":"IF(AND(OR($D4=\"CON\",$E4=\"CON\"),$K4=TRUE),1,0)","v":0},{"$f":"IF(AND(OR($D4=\"BIODY\",$E4=\"BIODY\"),$K4=TRUE),1,0)","v":0},{"$f":"IF(AND($I4<26,$K4=TRUE),1,0)","v":0},{"$f":"IF(AND((I4>25.99)*(I4<37),$K4=TRUE),1,0)","v":0},{"$f":"IF(AND(36.99<$I4,$K4=TRUE),1,0)","v":0},1,0,{"$f":"$G4*1.2*2","v":40.32},{"$f":"$G4*1.2*1.2","v":24.192}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(S3:S4)","v":41},{"$f":"SUM(T3:T4)","v":0}]
[]
[null,null,null,null,null,null,null,null,"TOTAL VINS","TOTAL RUPTURES"]
[null,null,null,null,null,null,null,null,{"$f":"(ROWS(CHAMPAGNE))-J8","v":2},{"$f":"COUNTIF(CHAMPAGNE,\"VRAI\")","v":0}]
[null,null,null,null,null,null,null,null,"BIO","BIO"]
[null,null,null,null,null,null,null,null,{"$f":"COUNTIF(AGRICHA,\"BIO\")-J10","v":0},{"$f":"SUM(RBIOCHA)","v":0}]
[null,null,null,null,null,null,null,null,"NATURE","NATURE"]
[null,null,null,null,null,null,null,null,{"$f":"COUNTIF(AGRICHA,\"NATURE\")-J12","v":0},{"$f":"SUM(RNATURECHA)","v":0}]
[null,null,null,null,null,null,null,null,"CONVENTIONNEL","CONVENTIONNEL"]
[null,null,null,null,null,null,null,null,{"$f":"COUNTIF(AGRICHA,\"CON\")-J14","v":2},{"$f":"SUM(RCONCHA)","v":0}]
[null,null,null,null,null,null,null,null,"BIODYNAMIE","BIODYNAMIE"]
[null,null,null,null,null,null,null,null,{"$f":"COUNTIF(AGRICHA,\"BIODY\")-J16","v":0},{"$f":"SUM(RBIODYETR)","v":0}]
[null,null,null,null,null,null,null,null,"ENTREE DE GAMME","ENTREE DE GAMME"]
[null,null,null,null,null,null,null,null,{"$f":"COUNTIFS(PVTTCCHA,\"<26\")-J18","v":0},{"$f":"SUM(REGCHA)","v":0}]
[null,null,null,null,null,null,null,null,"MILIEU DE GAMME","MILIEU DE GAMME"]
[null,null,null,null,null,null,null,null,{"$f":"SUMPRODUCT((PVTTCCHA>25.99)*(PVTTCCHA<37))-J20","v":0},{"$f":"SUM(RMGCHA)","v":0}]
[null,null,null,null,null,null,null,null,"HAUT DE GAMME","HAUT DE GAMME"]
[null,null,null,null,null,null,null,null,{"$f":"COUNTIFS(PVTTCCHA,\">36,99\")-J22","v":2},{"$f":"SUM(RHGCHA)","v":0}]

{"sheet":"Listes","index":12,"n_rows":13,"n_cols":5,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["Rosés",null,"BIO",null,"Axel Gustoworld 0625338003"]
["Blancs",null,"BIODY",null,"Aymeric Vignapart 0670827124"]
["Bordeaux Sud-Ouest",null,"CON",null,"Biaggio Vinom 0778720063"]
["Bourgogne",null,"NATURE",null,"Camille 0674705816"]
["Beaujolais",null,null,null,"Cédric Schiltz 0612108579"]
["Languedoc",null,null,null,"Didier Bordas 0660995478"]
["Vallée du Rhône",null,null,null,"Emmanuel Meffre 0672386975"]
["Vallée de la Loire",null,null,null,"Franck 0651826004"]
["Alsace",null,null,null,"Gautherot 0325385003"]
["Etrangers",null,null,null,"Le clos des pères 0628086552"]
["Champagne",null,null,null,"Nicolas Jaboulet 0680320770"]
[null,null,null,null,"Palette via Patrons"]
[null,null,null,null,"Phillippe Potier 0680136645"]