{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Recap","Champagne","Rosé","Rouge","Blanc","Liquoreux","Aide","Pour imprime"],"not_rendered":{"charts":0,"images":8,"macros":1,"external_links":0,"defined_names":1,"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":"Recap","index":0,"n_rows":17,"n_cols":17,"rows_kept":17,"cut":false,"hidden":false,"merged":[[6,12,7,12],[1,4,1,7]]}
[]
[null,{"$f":"Champagne!A1&\" points cave Sylla \"","v":"524 points cave Sylla "},null,null,"TYPE DE VINS",null,null,null,null,null,null,"Stock",null,{"$f":"B17+D17+E17+F17+H17+J17","v":100},null,"K","L"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(N4<=N2,P2,Q2)","v":"K"}]
[null,null,null,null,null,null,null,null,null,null,null,"Ancien stock",null,{"$f":"Blanc!I2+Rouge!K2+Rosé!I2+Champagne!J2+Liquoreux!I2","v":92}]
[]
[null,null,null,null,null,null,null,null,null,null,null,"En commande",null,{"$f":"Champagne!L2+Rosé!K2+Rouge!M2+Blanc!K2+Liquoreux!K2","v":12}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(($N$2+$N$6)>=$N$4,$P$2,$Q$2)","v":"K"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"Rosé!G2","v":12},null,{"$f":"Rouge!G2","v":46},null,{"$f":"Blanc!G2","v":28},null,{"$f":"Champagne!H2","v":11},null,{"$f":"Liquoreux!G2","v":3}]

{"sheet":"Champagne","index":1,"n_rows":4,"n_cols":14,"rows_kept":4,"cut":false,"hidden":false,"merged":[[3,9,4,9]]}
[524]
[null,"TYPE","REGION","VILLE","NOM","STOCK","Stock",{"$f":"SUM(F4:F10)","v":11},"Ancien Stock",12,"En Cde",{"$f":"SUM(K4:K50)","v":0},"K","L"]
[]
[null,"Champagne",null,null,null,11,7,null,null,{"$f":"IF(J2<=H2,M2,N2)","v":"L"}]

{"sheet":"Rosé","index":2,"n_rows":8,"n_cols":14,"rows_kept":8,"cut":false,"hidden":false,"merged":[[3,8,4,8]]}
[]
[null,"TYPE","REGION","VILLE","NOM","STOCK",{"$f":"SUM(F5:F8)","v":12},"Ancien Stock",12,"En Cde",{"$f":"SUM(J5:J50)","v":6},null,"K","L"]
[]
[null,null,null,null,null,null,null,null,{"$f":"IF(I2<=G2,M2,N2)","v":"K"}]
[null,"Rosé","Corse","PATRIMONIO",null,7,null,"óóóó"]
[null,"Rosé"]
[null,"Rosé","Bordeaux","LELAURE",null,3,null,"óóóó",null,6]
[null,"Rosé","Côte du Ventoux","CROIX des PINS",null,2,null,"óó"]

{"sheet":"Rouge","index":3,"n_rows":19,"n_cols":15,"rows_kept":19,"cut":false,"hidden":false,"merged":[[2,13,3,13]]}
[]
[null,"TYPE","REGION","VILLE","NOM","STOCK",{"$f":"SUM(F4:F19)","v":46},"DE","A","Ancien Stock",38,"En Cde",{"$f":"SUM(L4:L89)","v":0},"K","L"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(K2<=G2,N2,O2)","v":"K"}]
[null,"Rouge","Espagne","Espagne","Barahonda",1,null,6,null,null,"óóó"]
[null,"Rouge","Espagne","Espagne","Monte Hiniesta",2,null,3,1,2,"óóó"]
[null,"Rouge","Espagne","Espagne","Rioja Crianza",6,null,null,null,null,"óóóó"," "]
[null,"Rouge","Bordeaux","ROC DE J.LYS",null,1,null,null,14,14,"óóó"]
[null,{"$f":"IF(C8<>\"\",\"Rouge\",\"\")","v":"Rouge"},"Bordeaux","LELAURE"," ",10,null,4,null,null,"óóó"]
[null,"Rouge","Côte du Rhône","ST JOSEPH","Septentrio",1,null,null,21,21,"óóóóó"]
[null,"Rouge","Côte du Rhône","CHATEAUNEUF","Templier",1,null,null,22,22,"óóóóó"]
[null,"Rouge","Côte du Rhône","CONDRIEU","La Champine",5,null,10,7,11,"óóó"]
[null,"Rouge","Côte du Rhône","ST JOSEPH","Ro-Rée (1,5)",1,null,null,null,null,"óóóóó"]
[null,"Rouge","Côte du Rhône","CHÂTEAU PESQUIE","Prestige",4,null,6,14,17,"óóóó"]
[null,{"$f":"IF(C14<>\"\",\"Rouge\",\"\")","v":"Rouge"},"Côte du Rhône","CHÂTEAU PESQUIE","Paradou",2,null,12,null,null,"óó"]
[null,"Rouge","Côte du Rhône","PONT ST ESPRIT","Catherinette",1,null,1,null,null,"óó"]
[null,{"$f":"IF(C16<>\"\",\"Rouge\",\"\")","v":"Rouge"},"Côte du Rhône","RASTEAU",null,2,null,2,12,13,"óóóó"]
[null,"Rouge","Côte du Ventoux","TERRAVENTOUX","Terre de truffes",3,null,null,3,5,"óóó"]
[null,"Rouge","Côte du Ventoux","TERRAVENTOUX","La cavée",6,null,null,23,28,"óóó"]
[null,"Rouge"]

{"sheet":"Blanc","index":4,"n_rows":18,"n_cols":14,"rows_kept":18,"cut":false,"hidden":false,"merged":[[3,8,4,8]]}
[]
[null,"TYPE","REGION","VILLE","NOM","STOCK",{"$f":"SUM(F5:F18)","v":28},"Ancien Stock",30,"En Cde",{"$f":"SUM(J5:J50)","v":6},null,"K","L"]
[]
[null,null,null,null,null,null,null,null,{"$f":"IF(I2<=G2,M2,N2)","v":"L"}]
[null,"Blanc","Côte du Rhône","APT","Clemestel",1,"óó"]
[null,"Blanc","Côte du Rhône","CHATEAU PESQUIE","Paradou",4,"óó"]
[null,{"$f":"IF(C7<>\"\",\"Blanc\",\"\")","v":"Blanc"},"Côte du Rhône","VALVIGNERES","Chardonnay",7,"óóóó"]
[null,{"$f":"IF(C8<>\"\",\"Blanc\",\"\")","v":"Blanc"},"Côte du Rhône","VALVIGNERES","Paille",1,"óóóóó"]
[null,{"$f":"IF(C9<>\"\",\"Blanc\",\"\")","v":"Blanc"},"Côte du Rhône","VALVIGNERES","Viognier",2,"óóóóó"]
[null,"Blanc","Alsace","BOLLENBERG","Gewurtz",1,"óóóó"]
[null,"Blanc","Alsace"]
[null,"Blanc","Jura","Côte du Jura","Vin jaune",1,"óóóóó"]
[null,"Blanc","Bordeaux","LELAURE",null,6,"óóóó",null,null,6]
[null,"Blanc","Bordeaux","JURANCON",null,1,"óóó"]
[null,"Blanc"," "," ",null," "]
[null,"Blanc","Côte du Ventoux","TERRAVENTOUX","Terraventoux",2,"óóó"]
[null,{"$f":"IF(C17<>\"\",\"Blanc\",\"\")","v":"Blanc"},"Savoie","CHIGNIN",null,2,"óóó"]
[null,"Blanc"," "," ",null," "]

{"sheet":"Liquoreux","index":5,"n_rows":7,"n_cols":14,"rows_kept":7,"cut":false,"hidden":false,"merged":[[3,8,4,8]]}
[]
[null,"TYPE","REGION","VILLE","NOM","STOCK",{"$f":"SUM(F5:F7)","v":3},"Ancien Stock",0,"En Cde",{"$f":"SUM(J5:J14)","v":0},null,"K","L"]
[]
[null,null,null,null,null,null,null,null,{"$f":"IF(I2<=G2,M2,N2)","v":"K"}]
[null,"Liquoreux","Côte du Rhône","VALVIGNERES","Paille",1,"óóóóó"]
[null,"Liquoreux","Alsace","BOLLENBERG","Pinot gris",1,"óóóó"]
[null,"Liquoreux","Bordeaux","JURANCON",null,1,"óóó"]

{"sheet":"Aide","index":6,"n_rows":16,"n_cols":9,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["Sub auto_open()"]
["Sheets(\"Nom de l'onglet\").Select"]
["Range(\"une cellule au hasard\").Select"]
["End sub",null,null,null,null,null,null,null,"ó"]
[null,null,null,null,null,null,null,null,"óó"]
[null,null,null,null,null,null,null,null,"óóó"]
[null,null,null,null,null,null,null,null,"óóóó"]
["Sub auto_close()",null,null,null,null,null,null,null,"óóóóó"]
["Dim Chemin As String, Fichier As String"]
[" ' changer le nom du chemin en fonction du besoin"]
["Chemin = \"f:\\excel\\\""]
["'Ajoute la date du jour et l'heure dans le nom du fichier"]
[" ' si on ne veut pas le jour et la date, virer texte rouge"]
["Fichier = \"Liste_vin\" & \".xlsm\""]
["ActiveWorkbook.SaveCopyAs Chemin & Fichier"]
["End Sub"]

{"sheet":"Pour imprime","index":7,"n_rows":37,"n_cols":7,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Champagne",null,null,null,11]
["Rosé","Corse","PATRIMONIO",null,7]
["Rosé"]
["Rosé","Bordeaux","LELAURE",null,3]
["Rosé","Côte du Ventoux","CROIX des PINS",null,2]
["Blanc","Côte du Rhône","APT","Clemestel",1]
["Blanc","Côte du Rhône","CHATEAU PESQUIE","Paradou",4]
[{"$f":"IF(B10<>\"\",\"Blanc\",\"\")","v":"Blanc"},"Côte du Rhône","VALVIGNERES","Chardonnay",7]
[{"$f":"IF(B11<>\"\",\"Blanc\",\"\")","v":"Blanc"},"Côte du Rhône","VALVIGNERES","Paille",1]
[{"$f":"IF(B12<>\"\",\"Blanc\",\"\")","v":"Blanc"},"Côte du Rhône","VALVIGNERES","Viognier",2]
["Blanc","Alsace","BOLLENBERG","Gewurtz",1]
["Blanc","Alsace"]
["Blanc","Jura","Côte du Jura","Vin jaune",1]
["Blanc","Bordeaux","LELAURE",null,6]
["Blanc","Bordeaux","JURANCON",null,1]
["Blanc","Côte du Ventoux","CROIX des PINS",null,1]
["Blanc","Côte du Ventoux","TERRAVENTOUX","Terraventoux",2]
[{"$f":"IF(B20<>\"\",\"Blanc\",\"\")","v":"Blanc"},"Savoie","CHIGNIN",null,2]
["Blanc","Tourraine","MONTLOUIS",null,1]
["Rouge","Autres","ESPAGNE","Barahonda",1,6]
["Rouge","Autres",{"$f":"UPPER(\"espagne\")","v":"ESPAGNE"},"Monte Hiniesta",2,3,1]
["Rouge","Autres","ESPAGNE","Rioja Crianza",7]
["Rouge","Côte du Rhône","ST JOSEPH","Septentrio",1,null,21]
["Rouge","Côte du Rhône","CHATEAUNEUF","Templier",1,null,22]
["Rouge","Bordeaux","ROC DE J.LYS",null,1,null,14]
[{"$f":"IF(B28<>\"\",\"Rouge\",\"\")","v":"Rouge"},"Bordeaux",null,"Le Laure",2,4]
["Rouge","Côte du Rhône","CONDRIEU","La Champine",5,10,7]
["Rouge","Côte du Rhône","ST JOSEPH"," ",1]
["Rouge"]
["Rouge","Côte du Rhône","CHÂTEAU PESQUIE","Prestige",4,6,14]
[{"$f":"IF(B33<>\"\",\"Rouge\",\"\")","v":"Rouge"},"Côte du Rhône","CHÂTEAU PESQUIE","Paradou",2,12]
["Rouge","Côte du Rhône","PONT ST ESPRIT","Catherinette",1,1]
["Rouge","Côte du Ventoux","TERRAVENTOUX","Terre de truffes",3,null,3]
["Rouge","Côte du Ventoux","TERRAVENTOUX","La cavée",6,null,23]
[{"$f":"IF(B37<>\"\",\"Rouge\",\"\")","v":"Rouge"},"Côte du Rhône","RASTEAU",null,2,2,12]