{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Исходные данные","Автообновляемая сводная"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":3,"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":"Исходные данные","index":0,"n_rows":41,"n_cols":9,"rows_kept":41,"cut":false,"hidden":false,"merged":[]}
["Магазин","Артикул","Наименование товара","Производитель","Страна \nпроисхождения","Вес Нетто","Вес Брутто","количество, шт","Цена, \nUSD"]
["магазин 1",221001165,"Vodka Jelzin","Les Grands Chais de France","Франция",1163.8,1211.8,720,2.73]
["магазин 1",221001276,"Vodka Jelzin","Les Grands Chais de France","Франция",748.14,772.14,240,5.4]
["магазин 1",221001285,"Viru Valge","AS \"Liviko\"","Эстония",92.8,94.8,60,3.64]
["магазин 1",221008051,"J.P.Chenet Brandy XO","Les Grands Chais De France","Франция",295.08999999999997,311.08999999999997,240,4.3600000000000003]
["магазин 1",221009324,"Duclos Napolean","Les Grands Chais de France","Франция",256.39999999999998,272.39999999999998,240,2.2799999999999998]
["магазин 1",221010146,"Jelzin Liqueur Orange","Les Grands Chais de France","Франция",70.849999999999994,74.849999999999994,60,2.86]
["магазин 1",221010446,"Jelzin Liqueur Kirsch","Les Grands Chais de France","Франция",70.849999999999994,74.849999999999994,60,2.6]
["магазин 1",221010489,"Jelzin Liqueur Figue","Les Grands Chais de France","Франция",70.849999999999994,74.849999999999994,60,2.54]
["магазин 1",221010510,"VANA TALLINN","AS \"Liviko\"","Эстония",95.96,99.96,60,6.44]
["магазин 1",221010514,"VANA TALLINN Cream Liquer","AS \"Liviko\"","Эстония",50.24,51.84,48,6.11]
["магазин 1",221010515,"VANA TALLINN Chocolate Cream","AS \"Liviko\"","Эстония",62.8,64.8,60,6.11]
["магазин 1",221010516,"VANA TALLINN Coffee Cream","AS \"Liviko\"","Эстония",62.8,64.8,60,6.11]
["магазин 1",221011008,"Baron d'Arignac 12GR","Les Grands Chais de France","Франция",246.94,258.94,180,2.67]
["магазин 1",221011548,"J.P. Chenet Medium Sweet Rouge","Les Grands Chais de France","Франция",326.56,342.56,240,4.03]
["магазин 1",221011593,"J.P.Chenet Founder's Reserve Merlot Cabernet","Les Grands Chais de France","Франция",163.28,171.28,120,5.46]
["магазин 1",221011603,"Baron D'Arignac VDP de I'Aude Rouge Moelleux","Les Caves de Landiras","Франция",329.53,345.53,240,3.12]
["магазин 1",221011604,"Calvet Carte Rouge VDT de France","Calvet","Франция",55.03,58.23,48,3.45]
["магазин 1",221011612,"Calvet Aetos Cotes de Castillon Appellation Cot.de Cast","Calvet","Франция",47.6,49.2,24,15.54]
["магазин 1",221012015,"Baron d'Arignac Vin de Pays de I'Herault blanc","Les Caves de Landiras","Франция",164.63,172.63,120,2.86]
["магазин 1",221012165,"Baron d'Arignac Vin de Pays de I'Herault blanc moelleux","Les Caves de Landiras","Франция",241.41,253.41,180,3.38]
["магазин 1",221012285,"Quality wine Liebfraumilch","OTTO PRESSLER GmbH & Co.KG","Германия",132.01,140.01,"120",3.19]
["магазин 1",221012360,"J.P.Chenet Medium Sweet","Les Grands Chais de France","Франция",164.78,172.78,120,3.71]
["магазин 1",221012396,"J.P.Chenet Founder's Reserve Chardonnay Med","Les Grands Chais de France","Франция",170.15,178.15,120,5.4]
["магазин 1",221012410,"Calvet Carte D'Or VDT De France","Calvet","Франция",68.790000000000006,72.790000000000006,60,3.71]
["магазин 1",221012411,"Calvet Chardonnay VDP D'oc","Calvet","Франция",64.38,67.58,48,4.03]
["магазин 1",221012415,"Calvet Bourgogne Chard.Appel.Bourg.Controlee","Pasquier Desvignes","Франция",64.38,67.58,48,7.61]
["магазин 1",221033002,"J.P.Chenet Caberne Syrah","Les Grands Chais de France","Франция",163.28,171.28,120,4.03]
["магазин 1",221033003,"J.P.Chenet Merlot","Les Grands Chais de France","Франция",164.63,172.63,120,4.03]
["магазин 1",221033004,"Santa Lucia Malbec","Les Grands Chais de France","Франция",44.4,46.8,"36",3.45]
["магазин 1",221012348,"J.P. Chenet Sparkling Medium Vin Mousseux","Les Grands Chais de France","Франция",164.63,172.63,120,4.29]
["магазин 1",221012349,"J.P. Chenet Sparkling Brut Vin Mousseux","Les Grands Chais de France","Франция",192,200,120,4.2300000000000004]
["магазин 1",221012429,"J.P. Chenet Sparkling Sweet","Les Grands Chais de France","Франция",164.63,172.63,120,3.71]
["магазин 1",221013002,"Martini Asti","Martini & Rossi S.P.A.","Италия",614.39,630.39,480,8]
["магазин 1",221013003,"Martini Asti","Martini & Rossi S.P.A.","Италия",158.76,162.76,60,17.489999999999998]
["магазин 1",221016098,"Martini Rose Sparkling","Martini & Rossi S.P.A.","Италия",151.49,159.49,120,8.26]
["магазин 1",221016083,"Martini Rosato","Martini & Rossi S.P.A.","Италия",207.01,211.01,120,7.8]
["магазин 1",221016084,"Martini Bianco","Martini & Rossi S.P.A.","Италия",1043.25,1063.25,600,7.87]
["магазин 1",221016087,"Martini Rosso","Martini & Rossi S.P.A.","Италия",208.65,212.65,120,7.22]
["магазин 1",221016089,"Martini Extra Dry","Martini & Rossi S.P.A.","Италия",213.02,217.02,120,7.28]
["магазин 1",221016089,"Martini Extra Dry","Martini & Rossi S.P.A.","Италия",213.02,217.02,120,7.28]

{"sheet":"Автообновляемая сводная","index":1,"n_rows":5,"n_cols":2,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Названия строк","Количество по полю количество, шт"]
["магазин 1",40]
["Общий итог",40]