{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Товар","Продано"],"not_rendered":{"charts":0,"images":1,"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":"Товар","index":0,"n_rows":5,"n_cols":17,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["Подрядчик","Наличие","Категория 1","Категория 2","Наименование продукта","Цена за единицу без скидок","Цена за ед со скидками","Кол-во","Итого цена","Накрутка","Цена за ед с наценкой","Куплено","Итого цена с наценкой","Итого чистыми","Столбец1","Артикул","Примечание"]
[null,"Да","Гаджеты","Колонки и MP3 плееры","Водонепроницаемая Беспроводная Bluetooth Колонка Для Душа Bathbeats (BATHBEATS)",509.22,{"$f":"IFERROR(VLOOKUP(Таблица1[[#This Row],[Артикул]],$S$2:$T$4,2,0),F2)","v":509.22},1,{"$f":"G2*H2","v":509.22},{"$f":"K2*1/G2-1","v":0.76544519068379091},899,{"$f":"Таблица1[[#This Row],[Кол-во]]","v":1},{"$f":"L2*K2","v":899},{"$f":"IF(M2=0,0,M2-I2)","v":389.78},null,"GA1:00"]
[null,"Да","Гаджеты","Гаджеты","Наушники вакуумные светящиеся Glow",499,{"$f":"IFERROR(VLOOKUP(Таблица1[[#This Row],[Артикул]],$S$2:$T$4,2,0),F3)","v":499},0,{"$f":"G3*H3","v":0},0.73346693386773554,865,{"$f":"Таблица1[[#This Row],[Кол-во]]","v":0},{"$f":"L3*K3","v":0},0,null,"GC2:10"]
[null,"Да","Гаджеты","Портативные зарядные устройства (Power Bank)","Внешний Аккумулятор Remax Lipmax 2400 Mah (Черно-Красный)",478,{"$f":"IFERROR(VLOOKUP(Таблица1[[#This Row],[Артикул]],$S$2:$T$4,2,0),F4)","v":478},1,{"$f":"G4*H4","v":478},0.88284518828451874,900,{"$f":"Таблица1[[#This Row],[Кол-во]]","v":1},{"$f":"L4*K4","v":900},422,null,"GB3:20"]
["Итог",null,null,null,null,{"$f":"SUBTOTAL(109,[Цена за единицу без скидок])","v":1486.22},{"$f":"SUBTOTAL(109,[Цена за ед со скидками])","v":1486.22},{"$f":"SUBTOTAL(109,[Кол-во])","v":2},{"$f":"SUBTOTAL(109,[Итого цена])","v":987.22},null,null,{"$f":"SUBTOTAL(109,[Куплено])","v":2},{"$f":"SUBTOTAL(109,[Итого цена с наценкой])","v":1799},{"$f":"SUBTOTAL(109,[Итого чистыми])","v":811.78}]

{"sheet":"Продано","index":1,"n_rows":7,"n_cols":9,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Наименование продукта","Закупка","Цена","Куплено","Доп Скидка","Итого цена","Итого чистыми","Артикул","Дата продажи"]
["Водонепроницаемая Беспроводная Bluetooth Колонка Для Душа Bathbeats (BATHBEATS)",479.22,900,1,0.1,{"$f":"IF(E2>0,(C2-(C2*E2))*D2,D2*C2)","v":810},{"$f":"F2-(B2*D2)","v":330.78},"G08:A",42624]
["Наушники вакуумные светящиеся Glow",489.02,865,1,0,{"$f":"IF(E3>0,C3-(C3*E3),D3*C3)","v":865},375.98,"G14:BB",42624]
["Внешний Аккумулятор Rockbox Hybrid 1200 Mah (Голуб",184.24,396,1,0,{"$f":"IF(E4>0,C4-(C4*E4),D4*C4)","v":396},{"$f":"F4-(B4*D4)","v":211.76},"G05:RS",42624]
[]
[null,479.22,899,1,{"$f":"10/100","v":0.1},{"$f":"C6-(E6*C6)","v":809.1},{"$f":"F6-(B6*D6)","v":329.88}]
[null,null,null,null,{"$f":"E6","v":0.1}]