{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Параметры","Накладная"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":3,"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":9,"n_cols":8,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["Артикул","Наименование","Цена","Объем","Вес","Кратность","в упак","в паллете уп"]
["Артикул 1","Изделие Е",5.73,8.0000000000000007E-5,4.8000000000000001E-2,18000,200,90]
["Артикул 2","Изделие Б",7.5,1.73E-4,8.5000000000000006E-2,10560,120,88]
["Артикул 3","Изделие Н",7.1,1.6699999999999999E-4,7.6999999999999999E-2,10080,144,70]
["Артикул 4","Изделие Д",9.52,2.7099999999999997E-4,0.104,6048,84,72]
["Артикул 5","Изделие С",9.41,2.2900000000000001E-4,0.10299999999999999,7680,96,80]
["Артикул 6","Изделие В",12.76,4.1599999999999997E-4,0.11600000000000001,4000,50,80]
["Артикул 7","Изделие А",16.309999999999999,6.2500000000000001E-4,0.122,2304,32,72]
["Артикул 8","Изделие М",21.05,6.4000000000000005E-4,0.23699999999999999,2400,30,80]

{"sheet":"Накладная","index":1,"n_rows":34,"n_cols":20,"rows_kept":34,"cut":false,"hidden":false,"merged":[[20,7,20,8],[23,5,23,6],[25,5,25,6],[3,2,3,4],[5,2,5,4],[16,0,16,2],[16,7,16,8],[17,7,17,8]]}
[]
[null,"НАКЛАДНАЯ №",273,"от","2015-11-05"]
[]
[null,"Грузоотправитель","Склад Первый",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Заполняем ячейки H9:I16, I31:I33 и применяем фильтр."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Подскажите, как сохранить данные (без формул) с диапазона A1:E33 (с учетом фильтра) в новую книгу с именем \"Накладная № C2 от E2\"  с одним листом (\"Лист1\") в эту же папку?"]
[null,"Грузополучатель","Склад Второй"]
[]
["№ п/п","Наименование товара","Артикул","Ед. изм","Количество","Вес","Мест","Упаковки","Паллеты","Брутто 1 м","в паллете уп","в уп. М","Цена","Сумма","Объём 1 п.м.","Общий V, м3"]
[{"$f":"IF(E9>0,1)","v":false},"Изделие Е","Артикул 1","м",{"$f":"I9*K9*L9+H9*L9","v":0},{"$f":"J9*E9","v":0},{"$f":"I9*K9+H9","v":0},null,null,{"$f":"VLOOKUP(C9,Параметры,5,0)","v":4.8000000000000001E-2},{"$f":"VLOOKUP(C9,Параметры,8,0)","v":90},{"$f":"VLOOKUP(C9,Параметры,7,0)","v":200},{"$f":"VLOOKUP(C9,Параметры,3,0)","v":5.73},{"$f":"M9*E9","v":0},{"$f":"VLOOKUP(C9,Параметры,4,0)","v":8.0000000000000007E-5},{"$f":"O9*E9","v":0}]
[{"$f":"IF(E10>0,A9+1,A9)","v":1},"Изделие Б","Артикул 2","м",6720,{"$f":"J10*E10","v":571.20000000000005},{"$f":"I10*K10+H10","v":56},56,null,8.5000000000000006E-2,88,120,7.5,{"$f":"M10*E10","v":50400},1.73E-4,{"$f":"O10*E10","v":1.16256}]
[{"$f":"IF(E11>0,A10+1,A10)","v":1},"Изделие Н","Артикул 3","м",0,0,0,null,null,7.6999999999999999E-2,70,144,7.1,0,1.6699999999999999E-4,0]
[1,"Изделие Д","Артикул 4","м",0,0,0,null,null,0.104,72,84,9.52,0,2.7099999999999997E-4,0]
[2,"Изделие С","Артикул 5","м",38400,3955.2,400,null,5,0.10299999999999999,80,96,9.41,361344,2.2900000000000001E-4,8.7935999999999996]
[2,"Изделие В","Артикул 6","м",0,0,0,null,null,0.11600000000000001,80,50,12.76,0,4.1599999999999997E-4,0]
[3,"Изделие А","Артикул 7","м",50688,6183.9359999999997,1584,null,22,0.122,72,32,16.309999999999999,826721.27999999991,6.2500000000000001E-4,31.68]
[3,"Изделие М","Артикул 8","м",0,0,0,null,null,0.23699999999999999,80,30,21.05,0,6.4000000000000005E-4,0]
["Итого",null,null,"м",{"$f":"SUM(E9:E16)","v":95808},{"$f":"SUM(F9:F16)","v":10710.335999999999},{"$f":"SUM(G9:G16)","v":2040},{"$f":"SUM(N9:N16)","v":1238465.2799999998}]
[null,null,null,null,null,"Масса ","Мест","Сумма"]
[]
[null,"Отпуск разрешил",null,"Иванов И.И",null,"Объём",{"$f":"SUM(P9:P16)","v":41.636160000000004},"Доверен.",{"$f":"C2","v":273}]
[]
[null,"Отпуск груза произвёл",null,"Петров П.П"]
[]
[null,"Груз к перевозке принял",null,"Сидоров С.С."]
[]
[]
[null,null,{"$f":"CONCATENATE(\"Доверенность №\",\" \",I20)","v":"Доверенность № 273"},"от",{"$f":"E2","v":"2015-11-05"}]
["Тара к перемещению: ",null,null,null,"тара"]
[null,null,null,null,"тара"]
["№ п/п","Наименование товара","Артикул","Ед. изм","Количество",{"$f":"F17+I30","v":10738.335999999999},null,null,{"$f":"SUM(I31:I33)","v":28}]
[{"$f":"IF(E31>0,1)","v":false},"Поддон 2000х800мм","А","шт",{"$f":"I31*K31*L31+H31*L31","v":0},{"$f":"J31*G31","v":0},{"$f":"I31*K31+H31","v":0},null,null,150,1,1]
[{"$f":"IF(E32>0,A31+1,A31)","v":1},"Поддон 120х1000мм","АА","шт",{"$f":"I32*K32*L32+H32*L32","v":22},{"$f":"J32*G32","v":1716},{"$f":"I32*K32+H32","v":22},null,22,78,1,1]
[{"$f":"IF(E33>0,A32+1,A32)","v":2},"Поддон 1200х800мм","ААА","шт",{"$f":"I33*K33*L33+H33*L33","v":6},{"$f":"J33*G33","v":108},{"$f":"I33*K33+H33","v":6},null,6,18,1,1]
[null,null,null,null,null,null,null,null," "]