{"text_format":"1","workbook":"xlsx","n_sheets":18,"sheets":["Récap","Champagne","Rosé","Rouge","Blanc","Liquoreux","Aide","Région","Régusse","C. de Provence","C. du Rhône","C. du Ventoux","Italie","C. du Roussillon","Alsace","Ardèche","Portugal","Bordeaux"],"not_rendered":{"charts":0,"images":12,"macros":1,"external_links":0,"defined_names":12,"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":"Récap","index":0,"n_rows":22,"n_cols":17,"rows_kept":22,"cut":false,"hidden":false,"merged":[[1,4,2,7]]}
[null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,"TYPE DE VINS",null,null,null,null," ",null,"Stock",{"$f":"SUM(B16:J16)","v":113},null,null,"K","L"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"En commande",{"$f":"SUM(B20:J20)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"OFFSET(INDIRECT(B$22),,ROW()-10)","v":31},null,{"$f":"OFFSET(INDIRECT(D$22),,ROW()-10)","v":35},null,{"$f":"OFFSET(INDIRECT(F$22),,ROW()-10)","v":25},null,{"$f":"OFFSET(INDIRECT(H$22),,ROW()-10)","v":19},null,{"$f":"OFFSET(INDIRECT(J$22),,ROW()-10)","v":3}]
[]
[]
[]
[null,{"$f":"OFFSET(INDIRECT(B$22),,ROW()-11)","v":0},null,{"$f":"OFFSET(INDIRECT(D$22),,ROW()-12)","v":0},null,{"$f":"OFFSET(INDIRECT(F$22),,ROW()-12)","v":0},null,{"$f":"OFFSET(INDIRECT(H$22),,ROW()-12)","v":0},null,{"$f":"OFFSET(INDIRECT(J$22),,ROW()-11)","v":0}]
[]
[null,"Rosé!A2",null,"Rouge!A2",null,"Blanc!A2",null,"Champagne!A2",null,"Liquoreux!A2"]

{"sheet":"Champagne","index":1,"n_rows":9,"n_cols":12,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[" ",null,null,null,null,null,null,null,null,null," "]
[null,"TYPE","REGION","VILLE","NOM","STOCK",{"$f":"SUM(F5:F50)","v":19},"En Cde",{"$f":"SUM(J5:J50)","v":0},null,"K","L"]
[]
[]
[null,"Champagne","Régusse","Millésimé",null,5]
[null,"Champagne",null,"Gougolet Ruche",null,1]
[null,"Champagne",null,"Jacquard",null,5]
[null,"Champagne","Régusse","Chardonnay brut",null,8,null," "]
[null,"Champagne",null,"Villa Conchi",null,0]

{"sheet":"Rosé","index":2,"n_rows":7,"n_cols":13,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
[null,"TYPE","REGION","VILLE","NOM","STOCK",{"$f":"SUM(F5:F36)","v":31},null,"En Cde",{"$f":"SUM(J5:J36)","v":0},null,"K","L"]
[]
[]
[null,"Rosé","C. de Provence","Domaine des Aspras","Licorne",5,null,"óóóóó"," "]
[null,"Rosé","C. de Provence","Luberon","Les Chaberts",8,null,"óóó"," "]
[null,"Rosé","C. de Provence","Régusse",null,18,null,"óóó"]

{"sheet":"Rouge","index":3,"n_rows":14,"n_cols":14,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[]
[null,"TYPE","REGION","VILLE","NOM","STOCK",{"$f":"SUM(F5:F29)","v":35},"En Cde",{"$f":"SUM(J5:J20)","v":0},null,null,null,"K","L"]
[]
[]
[null,"Rouge","C. du Rhône","Famille Perrin","Les collines",7,null,"óóó"]
[null,"Rouge","C. du Rhône","St Joseph","Monier Perreol",1,null,"óóóóó"]
[null,"Rouge","C. du Rhône","St Joseph","Ro-Rée",1,null,"óóóóó"]
[null,"Rouge","C. de Provence","Bandol","Bunan",2,null,"óóóóó"]
[null,"Rouge","C. du Ventoux","Grand Jacquet","Près des sangliers",4,null,"óóóóó"]
[null,"Rouge","C. du Ventoux","Terraventoux","Terre de truffe",3,null,"óóó"]
[null,"Rouge","C. du Ventoux","Unan","La source",7,null,"óóóó"]
[null,"Rouge","C. du Ventoux","Unan","Village",1,null,"óóóó"]
[null,"Rouge","Italie","Chianti","Savignola Paolina",6,null,"óóó"]
[null,"Rouge","C. du Roussillon","Perpignan","Les vignerons catalans",3]

{"sheet":"Blanc","index":4,"n_rows":13,"n_cols":14,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[]
[null,"TYPE","REGION","VILLE","NOM","STOCK",{"$f":"SUM(F5:F27)","v":25},"En Cde",{"$f":"SUM(J5:J14)","v":0},null,null,null,null,"L"]
[]
[]
[null,"Blanc","Alsace","Gewurtz","Althenberg",2,null,"óóóó"]
[null,"Blanc","Alsace","Gewurtz","Terroir",3,null,"óóóó"]
[null,"Blanc","Alsace","Gewurtz","Vieilles vignes",1,null,"óóóóó"]
[null,"Blanc","Alsace","Riesling","René Meyer",5,null,"óóóó"]
[null,"Blanc","Ardèche","Les Vigneaux","Petit Chardonnay",3,null,"óóóó"]
[null,"Blanc","C. de Provence","Bandol Bunan","Moulin des Costes",1,null,"óóóóó"," "]
[null,"Blanc","C. de Provence","Grand Jacquet","Sanglier gourmand",2,null,"óóóóó"]
[null,"Blanc","C. du Ventoux","Régusse","Le primeur",4,null,"óóó"]
[null,"Blanc","Portugal",null,"Invisibile",4,null,"óóóóó"]

{"sheet":"Liquoreux","index":5,"n_rows":6,"n_cols":13,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
[]
[null,"TYPE","REGION","VILLE/CAVE","NOM","STOCK",{"$f":"SUM(F5:F38)","v":3},null,"En Cde",{"$f":"SUM(J5:J39)","v":0},null,"K","L"]
[]
[]
[null,"Liquoreux","Alsace","RIBEAUVILLE","Pinot gris tardive",1,null,"óóóóó"]
[null,"Liquoreux","Bordeaux","LOUPIAC","Château de Suberne",2,null,"óóóó"]

{"sheet":"Aide","index":6,"n_rows":14,"n_cols":9,"rows_kept":14,"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\\\""]
["Fichier = \"Liste_vin\" & \".xlsm\""]
["ActiveWorkbook.SaveCopyAs Chemin & Fichier"]
["End Sub"]

{"sheet":"Région","index":7,"n_rows":2,"n_cols":11,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
[]
[null,"TYPE","REGION","VILLE","NOM","STOCK",null,{"$f":"SUM(F5:F50)","v":0},null,"En Cde",{"$f":"SUM(J5:J50)","v":0}]

{"sheet":"Régusse","index":8,"n_rows":6,"n_cols":11,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
[]
[null,"TYPE","REGION","VILLE","NOM","STOCK",null,{"$f":"SUM(F5:F50)","v":13},null,"En Cde",{"$f":"SUM(J5:J50)","v":0}]
[]
[]
[null,"Champagne","Régusse","Millésimé",null,5]
[null,"Champagne","Régusse","Chardonnay brut",null,8,null," "]

{"sheet":"C. de Provence","index":9,"n_rows":10,"n_cols":11,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
[null,"TYPE","REGION","VILLE","NOM","STOCK",null,{"$f":"SUM(F5:F50)","v":36},null,"En Cde",{"$f":"SUM(J5:J50)","v":0}]
[]
[]
[null,"Rosé","C. de Provence","Domaine des Aspras","Licorne",5,null,"óóóóó"," "]
[null,"Rosé","C. de Provence","Luberon","Les Chaberts",8,null,"óóó"," "]
[null,"Rosé","C. de Provence","Régusse",null,18,null,"óóó"]
[null,"Rouge","C. de Provence","Bandol","Bunan",2,null,"óóóóó"]
[null,"Blanc","C. de Provence","Bandol Bunan","Moulin des Costes",1,null,"óóóóó"," "]
[null,"Blanc","C. de Provence","Grand Jacquet","Sanglier gourmand",2,null,"óóóóó"]

{"sheet":"C. du Rhône","index":10,"n_rows":7,"n_cols":11,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
[null,"TYPE","REGION","VILLE","NOM","STOCK",null,{"$f":"SUM(F5:F50)","v":9},null,"En Cde",{"$f":"SUM(J5:J50)","v":0}]
[]
[]
[null,"Rouge","C. du Rhône","Famille Perrin","Les collines",7,null,"óóó"]
[null,"Rouge","C. du Rhône","St Joseph","Monier Perreol",1,null,"óóóóó"]
[null,"Rouge","C. du Rhône","St Joseph","Ro-Rée",1,null,"óóóóó"]

{"sheet":"C. du Ventoux","index":11,"n_rows":9,"n_cols":11,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[]
[null,"TYPE","REGION","VILLE","NOM","STOCK",null,{"$f":"SUM(F5:F50)","v":19},null,"En Cde",{"$f":"SUM(J5:J50)","v":0}]
[]
[]
[null,"Rouge","C. du Ventoux","Grand Jacquet","Près des sangliers",4,null,"óóóóó"]
[null,"Rouge","C. du Ventoux","Terraventoux","Terre de truffe",3,null,"óóó"]
[null,"Rouge","C. du Ventoux","Unan","La source",7,null,"óóóó"]
[null,"Rouge","C. du Ventoux","Unan","Village",1,null,"óóóó"]
[null,"Blanc","C. du Ventoux","Régusse","Le primeur",4,null,"óóó"]

{"sheet":"Italie","index":12,"n_rows":5,"n_cols":11,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
[]
[null,"TYPE","REGION","VILLE","NOM","STOCK",null,{"$f":"SUM(F5:F50)","v":6},null,"En Cde",{"$f":"SUM(J5:J50)","v":0}]
[]
[]
[null,"Rouge","Italie","Chianti","Savignola Paolina",6,null,"óóó"]

{"sheet":"C. du Roussillon","index":13,"n_rows":5,"n_cols":11,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
[]
[null,"TYPE","REGION","VILLE","NOM","STOCK",null,{"$f":"SUM(F5:F50)","v":3},null,"En Cde",{"$f":"SUM(J5:J50)","v":0}]
[]
[]
[null,"Rouge","C. du Roussillon","Perpignan","Les vignerons catalans",3]

{"sheet":"Alsace","index":14,"n_rows":9,"n_cols":11,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[]
[null,"TYPE","REGION","VILLE","NOM","STOCK",null,{"$f":"SUM(F5:F50)","v":12},null,"En Cde",{"$f":"SUM(J5:J50)","v":0}]
[]
[]
[null,"Blanc","Alsace","Gewurtz","Althenberg",2,null,"óóóó"]
[null,"Blanc","Alsace","Gewurtz","Terroir",3,null,"óóóó"]
[null,"Blanc","Alsace","Gewurtz","Vieilles vignes",1,null,"óóóóó"]
[null,"Blanc","Alsace","Riesling","René Meyer",5,null,"óóóó"]
[null,"Liquoreux","Alsace","RIBEAUVILLE","Pinot gris tardive",1,null,"óóóóó"]

{"sheet":"Ardèche","index":15,"n_rows":5,"n_cols":11,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
[]
[null,"TYPE","REGION","VILLE","NOM","STOCK",null,{"$f":"SUM(F5:F50)","v":3},null,"En Cde",{"$f":"SUM(J5:J50)","v":0}]
[]
[]
[null,"Blanc","Ardèche","Les Vigneaux","Petit Chardonnay",3,null,"óóóó"]

{"sheet":"Portugal","index":16,"n_rows":5,"n_cols":11,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
[]
[null,"TYPE","REGION","VILLE","NOM","STOCK",null,{"$f":"SUM(F5:F50)","v":4},null,"En Cde",{"$f":"SUM(J5:J50)","v":0}]
[]
[]
[null,"Blanc","Portugal",null,"Invisibile",4,null,"óóóóó"]

{"sheet":"Bordeaux","index":17,"n_rows":5,"n_cols":11,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
[]
[null,"TYPE","REGION","VILLE","NOM","STOCK",null,{"$f":"SUM(F5:F50)","v":2},null,"En Cde",{"$f":"SUM(J5:J50)","v":0}]
[]
[]
[null,"Liquoreux","Bordeaux","LOUPIAC","Château de Suberne",2,null,"óóóó"]