{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Лист1"],"not_rendered":{"charts":0,"images":0,"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":"Лист1","index":0,"n_rows":81,"n_cols":37,"rows_kept":81,"cut":false,"hidden":false,"merged":[[68,26,68,29],[68,23,68,25],[68,17,68,19],[33,23,34,23],[33,24,34,24],[68,8,68,9],[68,13,68,15],[33,6,34,6],[33,7,34,7],[33,8,34,8],[33,9,34,9],[3,2,3,12],[33,11,34,11],[33,1,34,1],[33,2,34,2],[33,3,34,3],[33,4,34,4],[33,5,34,5],[33,12,33,13],[33,15,33,16],[33,21,33,22],[33,18,33,19],[33,14,34,14],[33,17,34,17]]}
["z",null,null,null,null,null,null,null,null,null,"z","z",null,null,null,null,null,null,null,null,null,null,null,null,null,"z","z","z","z","z","z","z","z","z","z","z","z"]
[null,null,null,null,null,"            Приложение № 2 к ЛЗК ___",null,null,null,null,"z","z"]
[]
[null,null,"название"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Коэфициент ","Маса "]
[null,"См. Косые резы и выполнять согласно чертежа",null,null,null,null,null,"План / шт",1,null,null,{"$f":"#REF!-#REF!","v":{"$error":"#REF!"}}]
[null,"№ п/п","длина ","ширина условная расчет программы","кол-во на изделие","материал профиль трубы","тол-на","План","кол-во на план",null,{"$f":"SUM(I10:I32)","v":35},{"$f":"SUM(L10:L32)","v":{"$error":"#VALUE!"}}]
[{"$f":"IF(E10=0,\"z\",\"\")","v":""},{"$f":"IF(I10=0,\"\",R10)","v":1},150,500,2,"Труба 25х25х1",{"$f":"IF(E10=0,\"\",VLOOKUP(F10,Таблица1[[#All],[Столбец5]:[Столбец10]],2,0))","v":1},{"$f":"I8","v":1},{"$f":"E10*H10","v":2},null,{"$f":"IF(E10=0,\"\",VLOOKUP(F10,Таблица1[[#All],[Столбец5]:[Столбец10]],6,0))","v":1.48},{"$f":"C10*D10*I10*K10/1000000-M10","v":0.222},null,null,null,null,null,{"$f":"IF(I10=0,0,1)","v":1}]
[{"$f":"IF(E11=0,\"z\",\"\")","v":"z"},{"$f":"IF(I11=0,\"\",R11)","v":""},null,500,null,null,{"$f":"IF(E11=0,\"\",VLOOKUP(F11,Таблица1[[#All],[Столбец5]:[Столбец10]],2,0))","v":""},{"$f":"I8","v":1},{"$f":"E11*H11","v":0},null,{"$f":"IF(E11=0,\"\",VLOOKUP(F11,Таблица1[[#All],[Столбец5]:[Столбец10]],6,0))","v":""},{"$f":"C11*D11*I11*K11/1000000","v":{"$error":"#VALUE!"}},null,null,null,null,null,{"$f":"IF(I11=0,R10,R10+1)","v":1}]
["",{"$f":"IF(I12=0,\"\",R12)","v":2},555,500,12,"Труба 25х25х1",{"$f":"IF(E12=0,\"\",VLOOKUP(F12,Таблица1[[#All],[Столбец5]:[Столбец10]],2,0))","v":1},{"$f":"I8","v":1},12,null,{"$f":"IF(E12=0,\"\",VLOOKUP(F12,Таблица1[[#All],[Столбец5]:[Столбец10]],6,0))","v":1.48},4.9283999999999999,null,null,null,null,null,{"$f":"IF(I12=0,R11,R11+1)","v":2}]
["z","",null,500,null,null,{"$f":"IF(E13=0,\"\",VLOOKUP(F13,Таблица1[[#All],[Столбец5]:[Столбец10]],2,0))","v":""},{"$f":"I8","v":1},0,null,{"$f":"IF(E13=0,\"\",VLOOKUP(F13,Таблица1[[#All],[Столбец5]:[Столбец10]],6,0))","v":""},{"$error":"#VALUE!"},null,null,null,null,null,{"$f":"IF(I13=0,R12,R12+1)","v":2}]
["z","",null,500,null,null,{"$f":"IF(E14=0,\"\",VLOOKUP(F14,Таблица1[[#All],[Столбец5]:[Столбец10]],2,0))","v":""},{"$f":"I8","v":1},0,null,{"$f":"IF(E14=0,\"\",VLOOKUP(F14,Таблица1[[#All],[Столбец5]:[Столбец10]],6,0))","v":""},{"$error":"#VALUE!"},null,null,null,null,null,2]
["z","",null,500,null,null,{"$f":"IF(E15=0,\"\",VLOOKUP(F15,Таблица1[[#All],[Столбец5]:[Столбец10]],2,0))","v":""},{"$f":"I8","v":1},0,null,{"$f":"IF(E15=0,\"\",VLOOKUP(F15,Таблица1[[#All],[Столбец5]:[Столбец10]],6,0))","v":""},{"$error":"#VALUE!"},null,null,null,null,null,2]
["z","",null,500,null,null,{"$f":"IF(E16=0,\"\",VLOOKUP(F16,Таблица1[[#All],[Столбец5]:[Столбец10]],2,0))","v":""},{"$f":"I8","v":1},0,null,{"$f":"IF(E16=0,\"\",VLOOKUP(F16,Таблица1[[#All],[Столбец5]:[Столбец10]],6,0))","v":""},{"$error":"#VALUE!"},null,null,null,null,null,2]
["z","",null,500,null,null,{"$f":"IF(E17=0,\"\",VLOOKUP(F17,Таблица1[[#All],[Столбец5]:[Столбец10]],2,0))","v":""},{"$f":"I8","v":1},0,null,{"$f":"IF(E17=0,\"\",VLOOKUP(F17,Таблица1[[#All],[Столбец5]:[Столбец10]],6,0))","v":""},{"$error":"#VALUE!"},null,null,null,null,null,2]
["z","",null,500,null,"Труба 25х25х1",{"$f":"VLOOKUP(F18,Таблица1[[#All],[Столбец5]:[Столбец10]],2,0)","v":1},{"$f":"I8","v":1},0,null,{"$f":"IF(E18=0,\"\",VLOOKUP(F18,Таблица1[[#All],[Столбец5]:[Столбец10]],6,0))","v":""},{"$error":"#VALUE!"},null,null,null,null,null,2]
["z","",null,500,null,null,{"$f":"VLOOKUP(F19,Таблица1[[#All],[Столбец5]:[Столбец10]],2,0)","v":{"$error":"#N/A"}},{"$f":"I8","v":1},0,null,{"$f":"IF(E19=0,\"\",VLOOKUP(F19,Таблица1[[#All],[Столбец5]:[Столбец10]],6,0))","v":""},{"$error":"#VALUE!"},null,null,null,null,null,2]
["z","",null,500,null,null,{"$f":"VLOOKUP(F20,Таблица1[[#All],[Столбец5]:[Столбец10]],2,0)","v":{"$error":"#N/A"}},{"$f":"I8","v":1},0,null,{"$f":"IF(E20=0,\"\",VLOOKUP(F20,Таблица1[[#All],[Столбец5]:[Столбец10]],6,0))","v":""},{"$error":"#VALUE!"},null,null,null,null,null,2]
["",3,3455,500,21,"Труба 25х25х1",{"$f":"VLOOKUP(F21,Таблица1[[#All],[Столбец5]:[Столбец10]],2,0)","v":1},{"$f":"I8","v":1},21,null,{"$f":"IF(E21=0,\"\",VLOOKUP(F21,Таблица1[[#All],[Столбец5]:[Столбец10]],6,0))","v":1.48},53.6907,null,null,null,null,null,3]
["z","",null,500,null,null,{"$f":"VLOOKUP(F22,Таблица1[[#All],[Столбец5]:[Столбец10]],2,0)","v":{"$error":"#N/A"}},{"$f":"I8","v":1},0,null,{"$f":"IF(E22=0,\"\",VLOOKUP(F22,Таблица1[[#All],[Столбец5]:[Столбец10]],6,0))","v":""},{"$error":"#VALUE!"},null,null,null,null,null,3]
["z","",null,500,null,null,{"$f":"VLOOKUP(F23,Таблица1[[#All],[Столбец5]:[Столбец10]],2,0)","v":{"$error":"#N/A"}},{"$f":"I8","v":1},0,null,{"$f":"IF(E23=0,\"\",VLOOKUP(F23,Таблица1[[#All],[Столбец5]:[Столбец10]],6,0))","v":""},{"$error":"#VALUE!"},null,null,null,null,null,3]
["z","",null,500,null,null,{"$f":"VLOOKUP(F24,Таблица1[[#All],[Столбец5]:[Столбец10]],2,0)","v":{"$error":"#N/A"}},{"$f":"I8","v":1},0,null,{"$f":"IF(E24=0,\"\",VLOOKUP(F24,Таблица1[[#All],[Столбец5]:[Столбец10]],6,0))","v":""},{"$error":"#VALUE!"},null,null,null,null,null,3]
["z","",null,500,null,null,{"$f":"VLOOKUP(F25,Таблица1[[#All],[Столбец5]:[Столбец10]],2,0)","v":{"$error":"#N/A"}},{"$f":"I8","v":1},0,null,{"$f":"IF(E25=0,\"\",VLOOKUP(F25,Таблица1[[#All],[Столбец5]:[Столбец10]],6,0))","v":""},{"$error":"#VALUE!"},null,null,null,null,null,3]
["z","",null,500,null,null,{"$f":"VLOOKUP(F26,Таблица1[[#All],[Столбец5]:[Столбец10]],2,0)","v":{"$error":"#N/A"}},{"$f":"I8","v":1},0,null,{"$f":"IF(E26=0,\"\",VLOOKUP(F26,Таблица1[[#All],[Столбец5]:[Столбец10]],6,0))","v":""},{"$error":"#VALUE!"},null,null,null,null,null,3]
["z","",null,500,null,null,{"$f":"VLOOKUP(F27,Таблица1[[#All],[Столбец5]:[Столбец10]],2,0)","v":{"$error":"#N/A"}},{"$f":"I8","v":1},0,null,{"$f":"IF(E27=0,\"\",VLOOKUP(F27,Таблица1[[#All],[Столбец5]:[Столбец10]],6,0))","v":""},{"$error":"#VALUE!"},null,null,null,null,null,3]
["z","",null,500,null,null,{"$f":"VLOOKUP(F28,Таблица1[[#All],[Столбец5]:[Столбец10]],2,0)","v":{"$error":"#N/A"}},{"$f":"I8","v":1},0,null,{"$f":"IF(E28=0,\"\",VLOOKUP(F28,Таблица1[[#All],[Столбец5]:[Столбец10]],6,0))","v":""},{"$error":"#VALUE!"},null,null,null,null,null,3]
["z","",null,500,null,null,{"$f":"VLOOKUP(F29,Таблица1[[#All],[Столбец5]:[Столбец10]],2,0)","v":{"$error":"#N/A"}},{"$f":"I8","v":1},0,null,{"$f":"IF(E29=0,\"\",VLOOKUP(F29,Таблица1[[#All],[Столбец5]:[Столбец10]],6,0))","v":""},{"$error":"#VALUE!"},null,null,null,null,null,3]
["z","",null,500,null,null,{"$f":"VLOOKUP(F30,Таблица1[[#All],[Столбец5]:[Столбец10]],2,0)","v":{"$error":"#N/A"}},{"$f":"I8","v":1},0,null,{"$f":"IF(E30=0,\"\",VLOOKUP(F30,Таблица1[[#All],[Столбец5]:[Столбец10]],6,0))","v":""},{"$error":"#VALUE!"},null,null,null,null,null,3]
["z","",null,500,null,null,{"$f":"VLOOKUP(F31,Таблица1[[#All],[Столбец5]:[Столбец10]],2,0)","v":{"$error":"#N/A"}},{"$f":"I8","v":1},0,null,{"$f":"IF(E31=0,\"\",VLOOKUP(F31,Таблица1[[#All],[Столбец5]:[Столбец10]],6,0))","v":""},{"$error":"#VALUE!"},null,null,null,null,null,3]
["z","",null,500,null,null,{"$f":"VLOOKUP(F32,Таблица1[[#All],[Столбец5]:[Столбец10]],2,0)","v":{"$error":"#N/A"}},{"$f":"I8","v":1},0,null,{"$f":"IF(E32=0,\"\",VLOOKUP(F32,Таблица1[[#All],[Столбец5]:[Столбец10]],6,0))","v":""},{"$error":"#VALUE!"},null,null,null,null,null,3]
[]
[null,"Карта рас-кроя №","Длина, мм","Ширина, мм","Толщина, мм","Марка материала","Кол-во","Площадь остатков всего, кв.м","Площадь деталей всего, кв.м","Количество деталей",null,"Коэфициент ","Трубы/остатка со склада масса (кг)",null,"Получил","Деловой остаток на склад (кг)",null,"Получил кла-довщик","ЛОМ общий (кг)",null,"Получил кладовщик","Масса деталей (кг)",null,"Количество деталей","Получил","Расход (кг)","ЛОМ (кг)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"теория","факт",null,"теория","факт",null,"теория","факт",null,"теория","факт"]
[{"$f":"IF(G36=0,\"z\",\"\")","v":"z"},null,null,null,null,"Труба 25х25 чм, 0.8 мм",null,null,null,null,null,{"$f":"VLOOKUP(F36,Таблица1[[Столбец4]:[Столбец10]],7,0)","v":1.2},{"$f":"C36*D36*G36*L36/1000000","v":0},null,null,{"$f":"H36*L36","v":0},null,null,{"$f":"Z36-V36","v":0},null,null,{"$f":"I36*L36","v":0},null,null,null,{"$f":"M36-P36","v":0},{"$f":"Z36-V36","v":0}]
[{"$f":"IF(G37=0,\"z\",\"\")","v":"z"},null,null,null,null,"Труба 25х25 чм, 1.2 мм",null,null,null,null,null,{"$f":"VLOOKUP(F37,Таблица1[[Столбец4]:[Столбец10]],7,0)","v":1.75},0,null,null,0,null,null,{"$f":"Z37-V37","v":0},null,null,{"$f":"I37*L37","v":0},null,null,null,{"$f":"M37-P37","v":0},{"$f":"Z37-V37","v":0}]
["z",null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(F38,Таблица1[[Столбец4]:[Столбец10]],7,0)","v":{"$error":"#N/A"}},{"$error":"#N/A"},null,null,{"$error":"#N/A"},null,null,null,null,null,{"$error":"#N/A"},null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
["z",null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(F39,Таблица1[[Столбец4]:[Столбец10]],7,0)","v":{"$error":"#N/A"}},{"$error":"#N/A"},null,null,{"$error":"#N/A"},null,null,null,null,null,{"$error":"#N/A"},null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
["z",null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(F40,Таблица1[[Столбец4]:[Столбец10]],7,0)","v":{"$error":"#N/A"}},{"$error":"#N/A"},null,null,{"$error":"#N/A"},null,null,null,null,null,{"$error":"#N/A"},null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
["z",null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(F41,Таблица1[[Столбец4]:[Столбец10]],7,0)","v":{"$error":"#N/A"}},{"$error":"#N/A"},null,null,{"$error":"#N/A"},null,null,null,null,null,{"$error":"#N/A"},null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
["z",null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(F42,Таблица1[[Столбец4]:[Столбец10]],7,0)","v":{"$error":"#N/A"}},{"$error":"#N/A"},null,null,{"$error":"#N/A"},null,null,null,null,null,{"$error":"#N/A"},null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
["z",null,null,null,null,"Труба 25х25 чм, 1.2 мм",null,null,null,null,null,{"$f":"VLOOKUP(F43,Таблица1[[Столбец4]:[Столбец10]],7,0)","v":1.75},0,null,null,0,null,null,null,null,null,0,null,null,null,0,0]
["z",null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(F44,Таблица1[[Столбец4]:[Столбец10]],7,0)","v":{"$error":"#N/A"}},{"$error":"#N/A"},null,null,{"$error":"#N/A"},null,null,null,null,null,{"$error":"#N/A"},null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
["z",null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(F45,Таблица1[[Столбец4]:[Столбец10]],7,0)","v":{"$error":"#N/A"}},{"$error":"#N/A"},null,null,{"$error":"#N/A"},null,null,null,null,null,{"$error":"#N/A"},null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
["z",null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(F46,Таблица1[[Столбец4]:[Столбец10]],7,0)","v":{"$error":"#N/A"}},{"$error":"#N/A"},null,null,{"$error":"#N/A"},null,null,null,null,null,{"$error":"#N/A"},null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
["z",null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(F47,Таблица1[[Столбец4]:[Столбец10]],7,0)","v":{"$error":"#N/A"}},{"$error":"#N/A"},null,null,{"$error":"#N/A"},null,null,null,null,null,{"$error":"#N/A"},null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
["z",null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(F48,Таблица1[[Столбец4]:[Столбец10]],7,0)","v":{"$error":"#N/A"}},{"$error":"#N/A"},null,null,{"$error":"#N/A"},null,null,null,null,null,{"$error":"#N/A"},null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
["z",null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(F49,Таблица1[[Столбец4]:[Столбец10]],7,0)","v":{"$error":"#N/A"}},{"$error":"#N/A"},null,null,{"$error":"#N/A"},null,null,null,null,null,{"$error":"#N/A"},null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
["z",null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(F50,Таблица1[[Столбец4]:[Столбец10]],7,0)","v":{"$error":"#N/A"}},{"$error":"#N/A"},null,null,{"$error":"#N/A"},null,null,null,null,null,{"$error":"#N/A"},null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
["z",null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(F51,Таблица1[[Столбец4]:[Столбец10]],7,0)","v":{"$error":"#N/A"}},{"$error":"#N/A"},null,null,{"$error":"#N/A"},null,null,null,null,null,{"$error":"#N/A"},null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
["z",null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(F52,Таблица1[[Столбец4]:[Столбец10]],7,0)","v":{"$error":"#N/A"}},{"$error":"#N/A"},null,null,{"$error":"#N/A"},null,null,null,null,null,{"$error":"#N/A"},null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
["z",null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(F53,Таблица1[[Столбец4]:[Столбец10]],7,0)","v":{"$error":"#N/A"}},{"$error":"#N/A"},null,null,{"$error":"#N/A"},null,null,null,null,null,{"$error":"#N/A"},null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
["z",null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(F54,Таблица1[[Столбец4]:[Столбец10]],7,0)","v":{"$error":"#N/A"}},{"$error":"#N/A"},null,null,{"$error":"#N/A"},null,null,null,null,null,{"$error":"#N/A"},null,null,null,{"$f":"M54-P54","v":{"$error":"#N/A"}},{"$error":"#N/A"}]
["z",null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(F55,Таблица1[[Столбец4]:[Столбец10]],7,0)","v":{"$error":"#N/A"}},{"$error":"#N/A"},null,null,{"$error":"#N/A"},null,null,null,null,null,{"$error":"#N/A"},null,null,null,{"$f":"M55-P55","v":{"$error":"#N/A"}},{"$error":"#N/A"}]
["z",null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(F56,Таблица1[[Столбец4]:[Столбец10]],7,0)","v":{"$error":"#N/A"}},{"$error":"#N/A"},null,null,{"$error":"#N/A"},null,null,null,null,null,{"$error":"#N/A"},null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
["z",null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(F57,Таблица1[[Столбец4]:[Столбец10]],7,0)","v":{"$error":"#N/A"}},{"$error":"#N/A"},null,null,{"$error":"#N/A"},null,null,null,null,null,{"$error":"#N/A"},null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
["z",null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(F58,Таблица1[[Столбец4]:[Столбец10]],7,0)","v":{"$error":"#N/A"}},{"$error":"#N/A"},null,null,{"$error":"#N/A"},null,null,null,null,null,{"$error":"#N/A"},null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
["z",null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(F59,Таблица1[[Столбец4]:[Столбец10]],7,0)","v":{"$error":"#N/A"}},{"$error":"#N/A"},null,null,{"$error":"#N/A"},null,null,null,null,null,{"$error":"#N/A"},null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
["z",null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(F60,Таблица1[[Столбец4]:[Столбец10]],7,0)","v":{"$error":"#N/A"}},{"$error":"#N/A"},null,null,{"$error":"#N/A"},null,null,null,null,null,{"$error":"#N/A"},null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
["z",null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(F61,Таблица1[[Столбец4]:[Столбец10]],7,0)","v":{"$error":"#N/A"}},{"$error":"#N/A"},null,null,{"$error":"#N/A"},null,null,null,null,null,{"$error":"#N/A"},null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
["z",null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(F62,Таблица1[[Столбец4]:[Столбец10]],7,0)","v":{"$error":"#N/A"}},{"$error":"#N/A"},null,null,{"$error":"#N/A"},null,null,null,null,null,{"$error":"#N/A"},null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
["z",null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(F63,Таблица1[[Столбец4]:[Столбец10]],7,0)","v":{"$error":"#N/A"}},{"$error":"#N/A"},null,null,{"$error":"#N/A"},null,null,null,null,null,{"$error":"#N/A"},null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
["z",null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(F64,Таблица1[[Столбец4]:[Столбец10]],7,0)","v":{"$error":"#N/A"}},{"$error":"#N/A"},null,null,{"$error":"#N/A"},null,null,null,null,null,{"$error":"#N/A"},null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
["z",null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(F65,Таблица1[[Столбец4]:[Столбец10]],7,0)","v":{"$error":"#N/A"}},{"$error":"#N/A"},null,null,{"$error":"#N/A"},null,null,null,null,null,{"$error":"#N/A"},null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
["z",null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(F66,Таблица1[[Столбец4]:[Столбец10]],7,0)","v":{"$error":"#N/A"}},{"$error":"#N/A"},null,null,{"$error":"#N/A"},null,null,null,null,null,{"$error":"#N/A"},null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M36:M66)","v":{"$error":"#N/A"}},null,null,{"$f":"SUM(P36:P66)","v":{"$error":"#N/A"}},null,null,null,null,null,{"$f":"SUM(V36:V66)","v":{"$error":"#N/A"}},null,null,null,{"$f":"SUM(Z36:Z66)","v":{"$error":"#N/A"}},{"$f":"SUM(AA36:AA66)","v":{"$error":"#N/A"}}]
[]
[null,null,null,null,"АСТРА",null,null,null,"получить",null,null,null,"получить","остаток",null,null,null,"детали",null,null,null,null,null,"расход",null,null,"лом"]
[null,"№ п/п",null,"Стандарт. длина\nмм",null,"Марка материала","Толщина\nмм","Кол-во труб","Масса \nцелых\nкг","Масса\nделовых\nкг","коэф 2м","Резы","Общая\nкг","Деловой остаток с целых\nкг","Деловой остаок с деловых\nкг","Общая\nкг","ЛОМ\nкг","Масса деталей целых\nкг","Масса деталей деловых\nкг","Общая\nкг",null,null,null,"Расход целых\nкг","Расход деловых\nкг","Общий\nкг","ЛОМ\nдубль\nкг","отход\nна\nпорезку","лом \nчистый\nцелых","лом\nчистый\nделовых","Ширина реза\nмм","Масса деловых\nкг","Марка материала\nАстра"]
[null,null,null,null,"копия",null,null,null,null,"копия"]
["z","Столбец1","Столбец2","Столбец3","Столбец4","Столбец5","Столбец6","Столбец7","Столбец8","Столбец9","Столбец10","Столбец11","Столбец12","Столбец13","Столбец14","Столбец15","Столбец16","Столбец17","Столбец18","Столбец19","Столбец20","Столбец21","Столбец22","Столбец23","Столбец24","Столбец25","Столбец26","Столбец27","Столбец28","Столбец29","Столбец30","Столбец31","Столбец32","Столбец33","Столбец34","Столбец35","Столбец36"]
[{"$f":"IF(Таблица1[[#This Row],[Столбец19]]=0,\"z\",\"\")","v":"z"},null,null,6000,{"$f":"Таблица1[[#This Row],[Столбец32]]","v":"Труба 25х25 чм, 0.8 мм"},"Труба 25х25х0,8",0.8,{"$f":"SUMIFS($G$36:$G$66,$D$36:$D$66,\"=500\",$C$36:$C$66,\"=[@Столбец3]\",$E$36:$E$66,\"=[@Столбец6]\",$F$36:$F$66,\"=[@Столбец32]\")","v":0},{"$f":"SUMIFS($M$36:$M$66,$C$36:$C$66,\"=D71\",$D$36:$D$66,\"=500\",$E$36:$E$66,\"=G71\",$F$36:$F$66,\"=AG71\")","v":0},{"$f":"CONCATENATE(\"(\",Таблица1[[#This Row],[Столбец31]],\")\")","v":"(0)"},1.2,{"$f":"SUMIFS($I$10:$I$32,$F$10:$F$32,\"=[@Столбец5]\")","v":0},{"$f":"Таблица1[[#This Row],[Столбец8]]+Таблица1[[#This Row],[Столбец9]]","v":0},{"$f":"SUMIFS($P$36:$P$66,$C$36:$C$66,\"=[@Столбец3]\",$D$36:$D$66,\"=500\",$E$36:$E$66,\"=[@Столбец6]\",$F$36:$F$66,\"=[@Столбец32]\")","v":0},{"$f":"SUMIFS($P$36:$P$66,$C$36:$C$66,\"<>[@Столбец3]\",$D$36:$D$66,\"=500\",$E$36:$E$66,\"=[@Столбец6]\",$F$36:$F$66,\"=[@Столбец32]\")","v":0},{"$f":"Таблица1[[#This Row],[Столбец13]]+Таблица1[[#This Row],[Столбец14]]","v":0},{"$f":"Таблица1[[#This Row],[Столбец28]]+Таблица1[[#This Row],[Столбец29]]-Таблица1[[#This Row],[Столбец27]]","v":0},{"$f":"SUMIFS($V$36:$V$66,$C$36:$C$66,\"=[@Столбец3]\",$D$36:$D$66,\"=500\",$E$36:$E$66,\"=[@Столбец6]\",$F$36:$F$66,\"=[@Столбец32]\")","v":0},{"$f":"SUMIFS($V$36:$V$66,$C$36:$C$66,\"<>[@Столбец3]\",$D$36:$D$66,\"=500\",$E$36:$E$66,\"=[@Столбец6]\",$F$36:$F$66,\"=[@Столбец32]\")","v":0},{"$f":"Таблица1[[#This Row],[Столбец17]]+Таблица1[[#This Row],[Столбец18]]","v":0},null,null,null,{"$f":"SUMIFS($Z$36:$Z$66,$C$36:$C$66,\"=[@Столбец3]\",$D$36:$D$66,\"=500\",$E$36:$E$66,\"=[@Столбец6]\",$F$36:$F$66,\"=[@Столбец32]\")","v":0},{"$f":"SUMIFS($Z$36:$Z$66,$C$36:$C$66,\"<>[@Столбец3]\",$D$36:$D$66,\"=500\",$E$36:$E$66,\"=[@Столбец6]\",$F$36:$F$66,\"=[@Столбец32]\")","v":0},{"$f":"Таблица1[[#This Row],[Столбец23]]+Таблица1[[#This Row],[Столбец24]]","v":0},{"$f":"Таблица1[[#This Row],[Столбец28]]+Таблица1[[#This Row],[Столбец29]]-Таблица1[[#This Row],[Столбец27]]","v":0},{"$f":"Таблица1[[#This Row],[Столбец11]]*Таблица1[[#This Row],[Столбец30]]/1000*Таблица1[[#This Row],[Столбец10]]/2","v":0},{"$f":"SUMIFS($AA$36:$AA$66,$C$36:$C$66,\"=[@Столбец3]\",$D$36:$D$66,\"=500\",$E$36:$E$66,\"=[@Столбец6]\",$F$36:$F$66,\"=[@Столбец32]\")","v":0},{"$f":"SUMIFS($AA$36:$AA$66,$C$36:$C$66,\"<>[@Столбец3]\",$D$36:$D$66,\"=500\",$E$36:$E$66,\"=[@Столбец6]\",$F$36:$F$66,\"=[@Столбец32]\")","v":0},5,{"$f":"SUMIFS($M$36:$M$66,$C$36:$C$66,\"<>[@Столбец3]\",$D$36:$D$66,\"=500\",$E$36:$E$66,\"=[@Столбец6]\",$F$36:$F$66,\"=[@Столбец32]\")","v":0},"Труба 25х25 чм, 0.8 мм"]
[{"$f":"IF(Таблица1[[#This Row],[Столбец19]]=0,\"z\",\"\")","v":"z"},null,null,6000,{"$f":"Таблица1[[#This Row],[Столбец32]]","v":"Труба 25х25 чм, 1.0 мм"},"Труба 25х25х1",1,{"$f":"SUMIFS($G$36:$G$66,$D$36:$D$66,\"=500\",$C$36:$C$66,\"=[@Столбец3]\",$E$36:$E$66,\"=[@Столбец6]\",$F$36:$F$66,\"=[@Столбец32]\")","v":0},{"$f":"SUMIFS($M$36:$M$66,$C$36:$C$66,\"=D71\",$D$36:$D$66,\"=500\",$E$36:$E$66,\"=G71\",$F$36:$F$66,\"=AG71\")","v":0},{"$f":"CONCATENATE(\"(\",Таблица1[[#This Row],[Столбец31]],\")\")","v":"(0)"},1.48,0,{"$f":"Таблица1[[#This Row],[Столбец8]]+Таблица1[[#This Row],[Столбец9]]","v":0},0,0,{"$f":"Таблица1[[#This Row],[Столбец13]]+Таблица1[[#This Row],[Столбец14]]","v":0},{"$f":"Таблица1[[#This Row],[Столбец28]]+Таблица1[[#This Row],[Столбец29]]-Таблица1[[#This Row],[Столбец27]]","v":0},0,0,{"$f":"Таблица1[[#This Row],[Столбец17]]+Таблица1[[#This Row],[Столбец18]]","v":0},null,null,null,0,0,{"$f":"Таблица1[[#This Row],[Столбец23]]+Таблица1[[#This Row],[Столбец24]]","v":0},{"$f":"Таблица1[[#This Row],[Столбец28]]+Таблица1[[#This Row],[Столбец29]]-Таблица1[[#This Row],[Столбец27]]","v":0},{"$f":"Таблица1[[#This Row],[Столбец11]]*Таблица1[[#This Row],[Столбец30]]/1000*Таблица1[[#This Row],[Столбец10]]/2","v":0},0,0,5,0,"Труба 25х25 чм, 1.0 мм"]
[{"$f":"IF(Таблица1[[#This Row],[Столбец19]]=0,\"z\",\"\")","v":"z"},null,null,6000,{"$f":"Таблица1[[#This Row],[Столбец32]]","v":"Труба 25х25 чм, 1.2 мм"},"Труба 25х25х1.2",1.2,{"$f":"SUMIFS($G$36:$G$66,$D$36:$D$66,\"=500\",$C$36:$C$66,\"=[@Столбец3]\",$E$36:$E$66,\"=[@Столбец6]\",$F$36:$F$66,\"=[@Столбец32]\")","v":0},{"$f":"SUMIFS($M$36:$M$66,$C$36:$C$66,\"=D71\",$D$36:$D$66,\"=500\",$E$36:$E$66,\"=G71\",$F$36:$F$66,\"=AG71\")","v":0},{"$f":"CONCATENATE(\"(\",Таблица1[[#This Row],[Столбец31]],\")\")","v":"(0)"},1.75,{"$f":"SUMIFS($I$10:$I$32,$F$10:$F$32,\"=[@Столбец5]\")","v":0},{"$f":"Таблица1[[#This Row],[Столбец8]]+Таблица1[[#This Row],[Столбец9]]","v":0},{"$f":"SUMIFS($P$36:$P$66,$C$36:$C$66,\"=[@Столбец3]\",$D$36:$D$66,\"=500\",$E$36:$E$66,\"=[@Столбец6]\",$F$36:$F$66,\"=[@Столбец32]\")","v":0},{"$f":"SUMIFS($P$36:$P$66,$C$36:$C$66,\"<>[@Столбец3]\",$D$36:$D$66,\"=500\",$E$36:$E$66,\"=[@Столбец6]\",$F$36:$F$66,\"=[@Столбец32]\")","v":0},{"$f":"Таблица1[[#This Row],[Столбец13]]+Таблица1[[#This Row],[Столбец14]]","v":0},{"$f":"Таблица1[[#This Row],[Столбец28]]+Таблица1[[#This Row],[Столбец29]]-Таблица1[[#This Row],[Столбец27]]","v":0},{"$f":"SUMIFS($V$36:$V$66,$C$36:$C$66,\"=[@Столбец3]\",$D$36:$D$66,\"=500\",$E$36:$E$66,\"=[@Столбец6]\",$F$36:$F$66,\"=[@Столбец32]\")","v":0},{"$f":"SUMIFS($V$36:$V$66,$C$36:$C$66,\"<>[@Столбец3]\",$D$36:$D$66,\"=500\",$E$36:$E$66,\"=[@Столбец6]\",$F$36:$F$66,\"=[@Столбец32]\")","v":0},{"$f":"Таблица1[[#This Row],[Столбец17]]+Таблица1[[#This Row],[Столбец18]]","v":0},null,null,null,{"$f":"SUMIFS($Z$36:$Z$66,$C$36:$C$66,\"=[@Столбец3]\",$D$36:$D$66,\"=500\",$E$36:$E$66,\"=[@Столбец6]\",$F$36:$F$66,\"=[@Столбец32]\")","v":0},{"$f":"SUMIFS($Z$36:$Z$66,$C$36:$C$66,\"<>[@Столбец3]\",$D$36:$D$66,\"=500\",$E$36:$E$66,\"=[@Столбец6]\",$F$36:$F$66,\"=[@Столбец32]\")","v":0},{"$f":"Таблица1[[#This Row],[Столбец23]]+Таблица1[[#This Row],[Столбец24]]","v":0},{"$f":"Таблица1[[#This Row],[Столбец28]]+Таблица1[[#This Row],[Столбец29]]-Таблица1[[#This Row],[Столбец27]]","v":0},{"$f":"Таблица1[[#This Row],[Столбец11]]*Таблица1[[#This Row],[Столбец30]]/1000*Таблица1[[#This Row],[Столбец10]]/2","v":0},{"$f":"SUMIFS($AA$36:$AA$66,$C$36:$C$66,\"=[@Столбец3]\",$D$36:$D$66,\"=500\",$E$36:$E$66,\"=[@Столбец6]\",$F$36:$F$66,\"=[@Столбец32]\")","v":0},{"$f":"SUMIFS($AA$36:$AA$66,$C$36:$C$66,\"<>[@Столбец3]\",$D$36:$D$66,\"=500\",$E$36:$E$66,\"=[@Столбец6]\",$F$36:$F$66,\"=[@Столбец32]\")","v":0},5,{"$f":"SUMIFS($M$36:$M$66,$C$36:$C$66,\"<>[@Столбец3]\",$D$36:$D$66,\"=500\",$E$36:$E$66,\"=[@Столбец6]\",$F$36:$F$66,\"=[@Столбец32]\")","v":0},"Труба 25х25 чм, 1.2 мм"]
[]
[]
[]
[null,"Подпись",null,null,null,"Инженер-технолог"]
[null,"Подпись",null,null,null,"Нач техотдела"]
[null,"Подпись",null,null,null,"Генеральный директор"]