{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Элементы1","Элементы2","Элементы3","цены"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":7,"comments":3,"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":95,"n_cols":23,"rows_kept":95,"cut":false,"hidden":false,"merged":[[94,18,94,19],[94,20,94,21],[94,0,94,3],[94,6,94,8],[94,10,94,11],[94,12,94,13],[94,14,94,15],[94,16,94,17],[93,0,93,2],[93,10,93,11],[93,12,93,13],[93,14,93,15],[93,16,93,17],[93,18,93,19],[93,20,93,21],[92,0,92,2],[92,10,92,11],[92,12,92,13],[92,14,92,15],[92,16,92,17],[92,18,92,19],[89,22,90,22],[90,0,90,2],[91,0,91,2],[91,10,91,11],[91,12,91,13],[91,14,91,15],[92,20,92,21],[91,16,91,17],[91,18,91,19],[91,20,91,21],[89,10,90,11],[89,12,90,13],[89,14,90,15],[89,16,90,17],[89,18,90,19],[89,20,90,21],[82,19,83,21],[84,16,85,18],[84,19,85,21],[86,16,88,18],[86,19,88,21],[88,0,88,15],[89,0,89,3],[89,4,90,4],[89,5,90,5],[89,6,89,8],[89,9,90,9],[75,19,75,20],[75,22,75,23],[76,16,76,18],[76,19,76,21],[77,16,77,18],[77,19,77,21],[78,16,79,18],[78,19,79,21],[80,16,81,18],[80,19,81,21],[72,0,72,2],[72,3,72,15],[73,0,73,2],[73,3,73,15],[74,0,74,6],[74,8,74,15],[74,16,74,17],[75,0,87,7],[75,8,87,15],[75,16,75,17],[82,16,83,18],[69,10,69,11],[69,12,69,13],[69,14,69,15],[69,16,69,17],[69,18,69,19],[67,18,67,19],[69,20,69,21],[70,0,70,3],[70,6,70,8],[70,10,70,11],[70,12,70,13],[70,14,70,15],[70,16,70,17],[70,18,70,19],[70,20,70,21],[69,0,69,2],[67,0,67,2],[67,10,67,11],[67,12,67,13],[67,14,67,15],[67,16,67,17],[67,20,67,21],[68,0,68,2],[68,10,68,11],[68,12,68,13],[68,14,68,15],[68,16,68,17],[68,18,68,19],[68,20,68,21],[58,19,59,21],[60,16,61,18],[60,19,61,21],[61,22,61,23],[62,16,64,18],[62,19,64,21],[62,22,64,23],[64,0,64,15],[65,0,65,3],[65,4,66,4],[65,5,66,5],[65,6,65,8],[65,9,66,9],[65,10,66,11],[65,12,66,13],[65,14,66,15],[65,16,66,17],[65,18,66,19],[65,20,66,21],[65,22,66,22],[66,0,66,2],[51,19,51,20],[51,22,51,23],[52,16,52,18],[52,19,52,21],[53,16,53,18],[53,19,53,21],[54,16,55,18],[54,19,55,21],[56,16,57,18],[56,19,57,21],[48,0,48,2],[48,3,48,15],[49,0,49,2],[49,3,49,15],[50,0,50,6],[50,8,50,15],[50,16,50,17],[51,0,63,7],[51,8,63,15],[51,16,51,17],[58,16,59,18],[46,0,46,3],[46,6,46,8],[46,10,46,11],[46,12,46,13],[46,14,46,15],[46,16,46,17],[46,18,46,19],[46,20,46,21],[45,0,45,2],[44,0,44,2],[44,10,44,11],[44,12,44,13],[44,14,44,15],[44,16,44,17],[44,18,44,19],[44,20,44,21],[45,10,45,11],[45,12,45,13],[45,14,45,15],[45,16,45,17],[45,18,45,19],[45,20,45,21],[41,18,42,19],[41,20,42,21],[41,22,42,22],[42,0,42,2],[43,0,43,2],[43,10,43,11],[43,12,43,13],[43,14,43,15],[43,16,43,17],[43,20,43,21],[43,18,43,19],[41,0,41,3],[41,4,42,4],[41,5,42,5],[41,6,41,8],[41,9,42,9],[41,10,42,11],[41,12,42,13],[41,14,42,15],[41,16,42,17],[26,16,26,17],[27,0,39,7],[27,8,39,15],[27,16,27,17],[30,16,31,18],[38,16,40,18],[27,19,27,20],[27,22,27,23],[28,16,28,18],[28,19,28,21],[29,16,29,18],[29,19,29,21],[30,19,31,21],[32,16,33,18],[32,19,33,21],[34,16,35,18],[34,19,35,21],[36,16,37,18],[36,19,37,21],[38,19,40,21],[40,0,40,15],[24,0,24,2],[24,3,24,15],[25,0,25,2],[25,3,25,15],[22,0,22,3],[22,6,22,8],[22,10,22,11],[22,12,22,13],[26,0,26,6],[26,8,26,15],[20,0,20,2],[20,10,20,11],[20,12,20,13],[20,14,20,15],[20,16,20,17],[20,18,20,19],[22,14,22,15],[22,16,22,17],[20,20,20,21],[21,0,21,2],[21,10,21,11],[21,12,21,13],[21,14,21,15],[21,16,21,17],[21,18,21,19],[21,20,21,21],[22,18,22,19],[22,20,22,21],[14,19,16,21],[16,0,16,15],[17,22,18,22],[18,0,18,2],[19,0,19,2],[19,10,19,11],[19,12,19,13],[19,14,19,15],[19,16,19,17],[19,18,19,19],[19,20,19,21],[17,10,18,11],[6,19,7,21],[8,16,9,18],[8,19,9,21],[10,16,11,18],[10,19,11,21],[2,16,2,17],[3,16,3,17],[3,19,3,20],[17,0,17,3],[17,4,18,4],[17,5,18,5],[17,6,17,8],[17,9,18,9],[6,16,7,18],[3,0,15,7],[3,8,15,15],[17,12,18,13],[17,14,18,15],[17,16,18,17],[17,18,18,19],[17,20,18,21],[12,16,13,18],[12,19,13,21],[14,16,16,18],[2,8,2,15],[3,22,3,23],[4,16,4,18],[4,19,4,21],[5,16,5,18],[5,19,5,21],[0,0,0,2],[0,3,0,15],[1,0,1,2],[1,3,1,15],[2,0,2,6]]}
["Артикул",null,null,"ЭтСп-001"]
["Наименование",null,null,"Червонка"]
["Фото",null,null,null,null,null,null,null,"Описание",null,null,null,null,null,null,null,"Доставка материала",null,1.07,"а",{"$f":"(T15-S23)/S23","v":{"$error":"#NAME?"}}]
[null,null,null,null,null,null,null,null,"Червонка длинна 415мм, высота 110мм. По обеим сторонам одинаковый загиб",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,{"$f":"_xlfn.CEILING.MATH(T15/(V4*Y4),1)","v":{"$error":"#NAME?"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Стоимость п.м. изделия",null,null,{"$f":"_xlfn.CEILING.MATH(T15/(S4*2+V4*2),1)","v":{"$error":"#NAME?"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Чистая прибыль",null,null,{"$f":"T15-T9-T11-T13-S23","v":{"$error":"#NAME?"}}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Заработная плата",null,null,{"$f":"(T15-_xlfn.CEILING.MATH(S23,5))*20%","v":{"$error":"#NAME?"}}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Расходники",null,null,{"$f":"(T15-_xlfn.CEILING.MATH(S23,5))*7%","v":{"$error":"#NAME?"}}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Аренда, электричество",null,null,{"$f":"(T15-_xlfn.CEILING.MATH(S23,5))*10%","v":{"$error":"#NAME?"}}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ИТОГОВАЯ ЦЕНА",null,null,{"$f":"_xlfn.CEILING.MATH(O23,5)","v":{"$error":"#NAME?"}}]
[]
["Калькуляция"]
["Наименование материала",null,null,null,"Статус","Ед. изм","Размер заготовки (мм)",null,null,"Размер заготовки (мм)","Количество заготовок (шт)",null,"Цена (руб/м.п.)",null,"Стоимость (руб)",null,"Количество материала факт(м.п.)",null,"Стоимость фактическая (руб)",null,"Количество материала (м.п.)",null,"Вес"]
["Расходный материал",null,null,"Описание",null,null,"Длина","Ширина","Площадь"]
["Профильная  труба15*15*1,5",null,null,null,{"$f":"IF(ISNA(VLOOKUP(A20,цены!$B$3:$H$500,7)),\"\",VLOOKUP(A20,цены!$B$3:$H$500,7,0))","v":"Материал"},{"$f":"IF(ISNA(VLOOKUP(A20,цены!$B$3:$D$500,2)),\"\",VLOOKUP(A20,цены!$B$3:$D$500,2,0))","v":"м.п."},null,null,{"$f":"_xlfn.CEILING.MATH(G20*H20/1000000,0.01)","v":{"$error":"#NAME?"}},690,1,null,{"$f":"IF(ISNA(VLOOKUP(A20,цены!$B$3:$D$500,3)),\"0\",VLOOKUP(A20,цены!$B$3:$D$500,3,0))","v":32},null,{"$f":"IF(F20=\"м2\",I20*K20,_xlfn.CEILING.MATH(J20*K20,500)/1000)*$S$3*M20*IF(E20=\"Материал\",1+VLOOKUP($T$3,цены!$J$3:$K$11,2,0),1)","v":{"$error":"#NAME?"}},null,{"$f":"IF(F20=\"м2\",G20*H20*K20/1000000,J20*K20/1000)","v":0.69},null,{"$f":"Q20*M20","v":22.08},null,{"$f":"IF(F20=\"м2\",_xlfn.CEILING.MATH(G20*H20*K20/1000000,0.1),_xlfn.CEILING.MATH(J20*K20,500)/1000)","v":{"$error":"#NAME?"}},null,{"$f":"IF(ISNA(VLOOKUP(A20,цены!$B$3:$E$500,4)),\"\",VLOOKUP(A20,цены!$B$3:$E$500,4,0)*Q20)","v":0.44159999999999999}]
[null,null,null,null,{"$f":"IF(ISNA(VLOOKUP(A21,цены!$B$3:$H$500,7)),\"\",VLOOKUP(A21,цены!$B$3:$H$500,7,0))","v":""},{"$f":"IF(ISNA(VLOOKUP(A21,цены!$B$3:$D$500,2)),\"\",VLOOKUP(A21,цены!$B$3:$D$500,2,0))","v":""},null,null,{"$f":"_xlfn.CEILING.MATH(G21*H21/1000000,0.01)","v":{"$error":"#NAME?"}},null,null,null,{"$f":"IF(ISNA(VLOOKUP(A21,цены!$B$3:$D$500,3)),\"0\",VLOOKUP(A21,цены!$B$3:$D$500,3,0))","v":"0"},null,{"$f":"IF(F21=\"м2\",I21*K21,_xlfn.CEILING.MATH(J21*K21,500)/1000)*$S$3*M21*IF(E21=\"Материал\",1+VLOOKUP($T$3,цены!$J$3:$K$11,2,0),1)","v":{"$error":"#NAME?"}},null,{"$f":"IF(F21=\"м2\",G21*H21*K21/1000000,J21*K21/1000)","v":0},null,{"$f":"Q21*M21","v":0},null,{"$f":"IF(F21=\"м2\",_xlfn.CEILING.MATH(G21*H21*K21/1000000,0.1),_xlfn.CEILING.MATH(J21*K21,500)/1000)","v":{"$error":"#NAME?"}},null,{"$f":"IF(ISNA(VLOOKUP(A21,цены!$B$3:$E$500,4)),\"\",VLOOKUP(A21,цены!$B$3:$E$500,4,0)*Q21)","v":""}]
[null,null,null,null,{"$f":"IF(ISNA(VLOOKUP(A22,цены!$B$3:$H$500,7)),\"\",VLOOKUP(A22,цены!$B$3:$H$500,7,0))","v":""},{"$f":"IF(ISNA(VLOOKUP(A22,цены!$B$3:$D$500,2)),\"\",VLOOKUP(A22,цены!$B$3:$D$500,2,0))","v":""},null,null,{"$f":"_xlfn.CEILING.MATH(G22*H22/1000000,0.01)","v":{"$error":"#NAME?"}},null,null,null,{"$f":"IF(ISNA(VLOOKUP(A22,цены!$B$3:$D$500,3)),\"0\",VLOOKUP(A22,цены!$B$3:$D$500,3,0))","v":"0"},null,{"$f":"IF(F22=\"м2\",I22*K22,_xlfn.CEILING.MATH(J22*K22,500)/1000)*$S$3*M22*IF(E22=\"Материал\",1+VLOOKUP($T$3,цены!$J$3:$K$11,2,0),1)","v":{"$error":"#NAME?"}},null,{"$f":"IF(F22=\"м2\",G22*H22*K22/1000000,J22*K22/1000)","v":0},null,{"$f":"Q22*M22","v":0},null,{"$f":"IF(F22=\"м2\",_xlfn.CEILING.MATH(G22*H22*K22/1000000,0.1),_xlfn.CEILING.MATH(J22*K22,500)/1000)","v":{"$error":"#NAME?"}},null,{"$f":"IF(ISNA(VLOOKUP(A22,цены!$B$3:$E$500,4)),\"\",VLOOKUP(A22,цены!$B$3:$E$500,4,0)*Q22)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(O20:P22)","v":{"$error":"#NAME?"}},null,null,null,{"$f":"SUM(S20:T22)","v":22.08},null,null,null,{"$f":"SUM(W20:W22)","v":0.44159999999999999}]
[]
["Артикул",null,null,"ЭтСп-002"]
["Наименование"]
["Фото",null,null,null,null,null,null,null,"Описание",null,null,null,null,null,null,null,"Доставка материала",null,1.07,"а",{"$f":"(T39-S47)/S47","v":{"$error":"#NAME?"}}]
[null,null,null,null,null,null,null,null,"Червонка длина 340 мм высота загиба большого завитка 150 мм, малого завитка 80 мм.",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,{"$f":"_xlfn.CEILING.MATH(T39/(V28*Y28),1)","v":{"$error":"#NAME?"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Стоимость п.м. изделия",null,null,{"$f":"_xlfn.CEILING.MATH(T39/(S28*2+V28*2),1)","v":{"$error":"#NAME?"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Чистая прибыль",null,null,{"$f":"T39-T33-T35-T37-S47","v":{"$error":"#NAME?"}}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Заработная плата",null,null,{"$f":"(T39-_xlfn.CEILING.MATH(S47,5))*20%","v":{"$error":"#NAME?"}}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Расходники",null,null,{"$f":"(T39-_xlfn.CEILING.MATH(S47,5))*7%","v":{"$error":"#NAME?"}}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Аренда, электричество",null,null,{"$f":"(T39-_xlfn.CEILING.MATH(S47,5))*10%","v":{"$error":"#NAME?"}}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ИТОГОВАЯ ЦЕНА",null,null,{"$f":"_xlfn.CEILING.MATH(O47,5)","v":{"$error":"#NAME?"}}]
[]
["Калькуляция"]
["Наименование материала",null,null,null,"Статус","Ед. изм","Размер заготовки (мм)",null,null,"Размер заготовки (мм)","Количество заготовок (шт)",null,"Цена (руб/м.п.)",null,"Стоимость (руб)",null,"Количество материала факт(м.п.)",null,"Стоимость фактическая (руб)",null,"Количество материала (м.п.)",null,"Вес"]
["Расходный материал",null,null,"Описание",null,null,"Длина","Ширина","Площадь"]
["Профильная  труба15*15*1,5",null,null,null,{"$f":"IF(ISNA(VLOOKUP(A44,цены!$B$3:$H$500,7)),\"\",VLOOKUP(A44,цены!$B$3:$H$500,7,0))","v":"Материал"},{"$f":"IF(ISNA(VLOOKUP(A44,цены!$B$3:$D$500,2)),\"\",VLOOKUP(A44,цены!$B$3:$D$500,2,0))","v":"м.п."},null,null,{"$f":"_xlfn.CEILING.MATH(G44*H44/1000000,0.01)","v":{"$error":"#NAME?"}},690,1,null,{"$f":"IF(ISNA(VLOOKUP(A44,цены!$B$3:$D$500,3)),\"0\",VLOOKUP(A44,цены!$B$3:$D$500,3,0))","v":32},null,{"$f":"IF(F44=\"м2\",I44*K44,_xlfn.CEILING.MATH(J44*K44,500)/1000)*$S$27*M44*IF(E44=\"Материал\",1+VLOOKUP($T$27,цены!$J$3:$K$11,2,0),1)","v":{"$error":"#NAME?"}},null,{"$f":"IF(F44=\"м2\",G44*H44*K44/1000000,J44*K44/1000)","v":0.69},null,{"$f":"Q44*M44","v":22.08},null,{"$f":"IF(F44=\"м2\",_xlfn.CEILING.MATH(G44*H44*K44/1000000,0.1),_xlfn.CEILING.MATH(J44*K44,500)/1000)","v":{"$error":"#NAME?"}},null,{"$f":"IF(ISNA(VLOOKUP(A44,цены!$B$3:$E$500,4)),\"\",VLOOKUP(A44,цены!$B$3:$E$500,4,0)*Q44)","v":0.44159999999999999}]
[null,null,null,null,{"$f":"IF(ISNA(VLOOKUP(A45,цены!$B$3:$H$500,7)),\"\",VLOOKUP(A45,цены!$B$3:$H$500,7,0))","v":""},{"$f":"IF(ISNA(VLOOKUP(A45,цены!$B$3:$D$500,2)),\"\",VLOOKUP(A45,цены!$B$3:$D$500,2,0))","v":""},null,null,{"$f":"_xlfn.CEILING.MATH(G45*H45/1000000,0.01)","v":{"$error":"#NAME?"}},null,null,null,{"$f":"IF(ISNA(VLOOKUP(A45,цены!$B$3:$D$500,3)),\"0\",VLOOKUP(A45,цены!$B$3:$D$500,3,0))","v":"0"},null,{"$f":"IF(F45=\"м2\",I45*K45,_xlfn.CEILING.MATH(J45*K45,500)/1000)*$S$27*M45*IF(E45=\"Материал\",1+VLOOKUP($T$27,цены!$J$3:$K$11,2,0),1)","v":{"$error":"#NAME?"}},null,{"$f":"IF(F45=\"м2\",G45*H45*K45/1000000,J45*K45/1000)","v":0},null,{"$f":"Q45*M45","v":0},null,{"$f":"IF(F45=\"м2\",_xlfn.CEILING.MATH(G45*H45*K45/1000000,0.1),_xlfn.CEILING.MATH(J45*K45,500)/1000)","v":{"$error":"#NAME?"}},null,{"$f":"IF(ISNA(VLOOKUP(A45,цены!$B$3:$E$500,4)),\"\",VLOOKUP(A45,цены!$B$3:$E$500,4,0)*Q45)","v":""}]
[null,null,null,null,{"$f":"IF(ISNA(VLOOKUP(A46,цены!$B$3:$H$500,7)),\"\",VLOOKUP(A46,цены!$B$3:$H$500,7,0))","v":""},{"$f":"IF(ISNA(VLOOKUP(A46,цены!$B$3:$D$500,2)),\"\",VLOOKUP(A46,цены!$B$3:$D$500,2,0))","v":""},null,null,{"$f":"_xlfn.CEILING.MATH(G46*H46/1000000,0.01)","v":{"$error":"#NAME?"}},null,null,null,{"$f":"IF(ISNA(VLOOKUP(A46,цены!$B$3:$D$500,3)),\"0\",VLOOKUP(A46,цены!$B$3:$D$500,3,0))","v":"0"},null,{"$f":"IF(F46=\"м2\",I46*K46,_xlfn.CEILING.MATH(J46*K46,500)/1000)*$S$27*M46*IF(E46=\"Материал\",1+VLOOKUP($T$27,цены!$J$3:$K$11,2,0),1)","v":{"$error":"#NAME?"}},null,{"$f":"IF(F46=\"м2\",G46*H46*K46/1000000,J46*K46/1000)","v":0},null,{"$f":"Q46*M46","v":0},null,{"$f":"IF(F46=\"м2\",_xlfn.CEILING.MATH(G46*H46*K46/1000000,0.1),_xlfn.CEILING.MATH(J46*K46,500)/1000)","v":{"$error":"#NAME?"}},null,{"$f":"IF(ISNA(VLOOKUP(A46,цены!$B$3:$E$500,4)),\"\",VLOOKUP(A46,цены!$B$3:$E$500,4,0)*Q46)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(O44:P46)","v":{"$error":"#NAME?"}},null,null,null,{"$f":"SUM(S44:T46)","v":22.08},null,null,null,{"$f":"SUM(W44:W46)","v":0.44159999999999999}]
[]
["Артикул",null,null,"ЭтСп-0018"]
["Наименование"]
["Фото",null,null,null,null,null,null,null,"Описание",null,null,null,null,null,null,null,"Доставка материала",null,1.07,"ж",{"$f":"(T63-S71)/S71","v":{"$error":"#NAME?"}}]
[null,null,null,null,null,null,null,null,"Червонка с одинаковыми загибами, окончание гусиная и гладкая лапка. Длина заготовки 450 мм. Материал квадрат 10мм. Размер h*L 60*170мм.",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,{"$f":"_xlfn.CEILING.MATH(T63/(V52*Y52),1)","v":{"$error":"#NAME?"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Стоимость п.м. изделия",null,null,{"$f":"_xlfn.CEILING.MATH(T63/(S52*2+V52*2),1)","v":{"$error":"#NAME?"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Чистая прибыль",null,null,{"$f":"T63-T57-T59-T61-S71","v":{"$error":"#NAME?"}}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Заработная плата",null,null,{"$f":"(T63-_xlfn.CEILING.MATH(S71,50))*20%","v":{"$error":"#NAME?"}}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Расходники",null,null,{"$f":"(T63-_xlfn.CEILING.MATH(S71,50))*7%","v":{"$error":"#NAME?"}}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Аренда, электричество",null,null,{"$f":"(T63-_xlfn.CEILING.MATH(S71,50))*10%","v":{"$error":"#NAME?"}}]
[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,null,null,null,null,null,null,null,"ИТОГОВАЯ ЦЕНА",null,null,{"$f":"_xlfn.CEILING.MATH(O71,0.01)","v":{"$error":"#NAME?"}},null,null,{"$f":"T63*1.5","v":{"$error":"#NAME?"}}]
[]
["Калькуляция"]
["Наименование материала",null,null,null,"Статус","Ед. изм","Размер заготовки (мм)",null,null,"Размер заготовки (мм)","Количество заготовок (шт)",null,"Цена (руб/м.п.)",null,"Стоимость (руб)",null,"Количество материала факт(м.п.)",null,"Стоимость фактическая (руб)",null,"Количество материала (м.п.)",null,"Вес"]
["Расходный материал",null,null,"Описание",null,null,"Длина","Ширина","Площадь"]
["Квадрат 10*10",null,null,"Червонка",{"$f":"IF(ISNA(VLOOKUP(A68,цены!$B$3:$H$500,7)),\"\",VLOOKUP(A68,цены!$B$3:$H$500,7,0))","v":"Материал"},{"$f":"IF(ISNA(VLOOKUP(A68,цены!$B$3:$D$500,2)),\"\",VLOOKUP(A68,цены!$B$3:$D$500,2,0))","v":"м.п."},null,null,{"$f":"_xlfn.CEILING.MATH(G68*H68/1000000,0.01)","v":{"$error":"#NAME?"}},450,1,null,{"$f":"IF(ISNA(VLOOKUP(A68,цены!$B$3:$D$500,3)),\"0\",VLOOKUP(A68,цены!$B$3:$D$500,3,0))","v":34},null,{"$f":"IF(F68=\"м2\",I68*K68,_xlfn.CEILING.MATH(J68*K68,10)/1000)*$S$51*M68*IF(E68=\"Материал\",1+VLOOKUP($T$51,цены!$J$3:$K$11,2,0),1)","v":{"$error":"#NAME?"}},null,{"$f":"IF(F68=\"м2\",G68*H68*K68/1000000,J68*K68/1000)","v":0.45},null,{"$f":"Q68*M68","v":15.3},null,{"$f":"IF(F68=\"м2\",_xlfn.CEILING.MATH(G68*H68*K68/1000000,0.1),_xlfn.CEILING.MATH(J68*K68,500)/1000)","v":{"$error":"#NAME?"}},null,{"$f":"IF(ISNA(VLOOKUP(A68,цены!$B$3:$E$500,4)),\"\",VLOOKUP(A68,цены!$B$3:$E$500,4,0)*Q68)","v":0.35100000000000003}]
[null,null,null,null,{"$f":"IF(ISNA(VLOOKUP(A69,цены!$B$3:$H$500,7)),\"\",VLOOKUP(A69,цены!$B$3:$H$500,7,0))","v":""},{"$f":"IF(ISNA(VLOOKUP(A69,цены!$B$3:$D$500,2)),\"\",VLOOKUP(A69,цены!$B$3:$D$500,2,0))","v":""},null,null,{"$f":"_xlfn.CEILING.MATH(G69*H69/1000000,0.01)","v":{"$error":"#NAME?"}},null,null,null,{"$f":"IF(ISNA(VLOOKUP(A69,цены!$B$3:$D$500,3)),\"0\",VLOOKUP(A69,цены!$B$3:$D$500,3,0))","v":"0"},null,{"$f":"IF(F69=\"м2\",I69*K69,_xlfn.CEILING.MATH(J69*K69,10)/1000)*$S$51*M69*IF(E69=\"Материал\",1+VLOOKUP($T$51,цены!$J$3:$K$11,2,0),1)","v":{"$error":"#NAME?"}},null,{"$f":"IF(F69=\"м2\",G69*H69*K69/1000000,J69*K69/1000)","v":0},null,{"$f":"Q69*M69","v":0},null,{"$f":"IF(F69=\"м2\",_xlfn.CEILING.MATH(G69*H69*K69/1000000,0.1),_xlfn.CEILING.MATH(J69*K69,500)/1000)","v":{"$error":"#NAME?"}},null,{"$f":"IF(ISNA(VLOOKUP(A69,цены!$B$3:$E$500,4)),\"\",VLOOKUP(A69,цены!$B$3:$E$500,4,0)*Q69)","v":""}]
[null,null,null,null,{"$f":"IF(ISNA(VLOOKUP(A70,цены!$B$3:$H$500,7)),\"\",VLOOKUP(A70,цены!$B$3:$H$500,7,0))","v":""},{"$f":"IF(ISNA(VLOOKUP(A70,цены!$B$3:$D$500,2)),\"\",VLOOKUP(A70,цены!$B$3:$D$500,2,0))","v":""},null,null,{"$f":"_xlfn.CEILING.MATH(G70*H70/1000000,0.01)","v":{"$error":"#NAME?"}},null,null,null,{"$f":"IF(ISNA(VLOOKUP(A70,цены!$B$3:$D$500,3)),\"0\",VLOOKUP(A70,цены!$B$3:$D$500,3,0))","v":"0"},null,{"$f":"IF(F70=\"м2\",I70*K70,_xlfn.CEILING.MATH(J70*K70,10)/1000)*$S$51*M70*IF(E70=\"Материал\",1+VLOOKUP($T$51,цены!$J$3:$K$11,2,0),1)","v":{"$error":"#NAME?"}},null,{"$f":"IF(F70=\"м2\",G70*H70*K70/1000000,J70*K70/1000)","v":0},null,{"$f":"Q70*M70","v":0},null,{"$f":"IF(F70=\"м2\",_xlfn.CEILING.MATH(G70*H70*K70/1000000,0.1),_xlfn.CEILING.MATH(J70*K70,500)/1000)","v":{"$error":"#NAME?"}},null,{"$f":"IF(ISNA(VLOOKUP(A70,цены!$B$3:$E$500,4)),\"\",VLOOKUP(A70,цены!$B$3:$E$500,4,0)*Q70)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(O68:P70)","v":{"$error":"#NAME?"}},null,null,null,{"$f":"SUM(S68:T70)","v":15.3},null,null,null,{"$f":"SUM(W68:W70)","v":0.35100000000000003}]
[]
["Артикул",null,null,"ЭтСп-003"]
["Наименование"]
["Фото",null,null,null,null,null,null,null,"Описание",null,null,null,null,null,null,null,"Доставка материала",null,1.07,"в",{"$f":"(T87-S95)/S95","v":{"$error":"#NAME?"}}]
[null,null,null,null,null,null,null,null,"Дуга для вешала ширина основания 540 мм.",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,{"$f":"_xlfn.CEILING.MATH(T87/(V76*Y76),1)","v":{"$error":"#NAME?"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Стоимость п.м. изделия",null,null,{"$f":"_xlfn.CEILING.MATH(T87/(S76*2+V76*2),1)","v":{"$error":"#NAME?"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Чистая прибыль",null,null,{"$f":"T87-T81-T83-T85-S95","v":{"$error":"#NAME?"}}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Заработная плата",null,null,{"$f":"(T87-_xlfn.CEILING.MATH(S95,5))*20%","v":{"$error":"#NAME?"}}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Расходники",null,null,{"$f":"(T87-_xlfn.CEILING.MATH(S95,5))*7%","v":{"$error":"#NAME?"}}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Аренда, электричество",null,null,{"$f":"(T87-_xlfn.CEILING.MATH(S95,5))*10%","v":{"$error":"#NAME?"}}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ИТОГОВАЯ ЦЕНА",null,null,{"$f":"_xlfn.CEILING.MATH(O95,5)","v":{"$error":"#NAME?"}}]
[]
["Калькуляция"]
["Наименование материала",null,null,null,"Статус","Ед. изм","Размер заготовки (мм)",null,null,"Размер заготовки (мм)","Количество заготовок (шт)",null,"Цена (руб/м.п.)",null,"Стоимость (руб)",null,"Количество материала факт(м.п.)",null,"Стоимость фактическая (руб)",null,"Количество материала (м.п.)",null,"Вес"]
["Расходный материал",null,null,"Описание",null,null,"Длина","Ширина","Площадь"]
["Профильная  труба20*20*1,5",null,null,null,{"$f":"IF(ISNA(VLOOKUP(A92,цены!$B$3:$H$500,7)),\"\",VLOOKUP(A92,цены!$B$3:$H$500,7,0))","v":"Материал"},{"$f":"IF(ISNA(VLOOKUP(A92,цены!$B$3:$D$500,2)),\"\",VLOOKUP(A92,цены!$B$3:$D$500,2,0))","v":"м.п."},null,null,{"$f":"_xlfn.CEILING.MATH(G92*H92/1000000,0.01)","v":{"$error":"#NAME?"}},900,1,null,{"$f":"IF(ISNA(VLOOKUP(A92,цены!$B$3:$D$500,3)),\"0\",VLOOKUP(A92,цены!$B$3:$D$500,3,0))","v":41},null,{"$f":"IF(F92=\"м2\",I92*K92,_xlfn.CEILING.MATH(J92*K92,500)/1000)*$S75*M92*IF(E92=\"Материал\",1+VLOOKUP($T$75,цены!$J$3:$K$11,2,0),1)","v":{"$error":"#NAME?"}},null,{"$f":"IF(F92=\"м2\",G92*H92*K92/1000000,J92*K92/1000)","v":0.9},null,{"$f":"Q92*M92","v":36.9},null,{"$f":"IF(F92=\"м2\",_xlfn.CEILING.MATH(G92*H92*K92/1000000,0.1),_xlfn.CEILING.MATH(J92*K92,500)/1000)","v":{"$error":"#NAME?"}},null,{"$f":"IF(ISNA(VLOOKUP(A92,цены!$B$3:$E$500,4)),\"\",VLOOKUP(A92,цены!$B$3:$E$500,4,0)*Q92)","v":0.78300000000000003}]
[null,null,null,null,{"$f":"IF(ISNA(VLOOKUP(A93,цены!$B$3:$H$500,7)),\"\",VLOOKUP(A93,цены!$B$3:$H$500,7,0))","v":""},{"$f":"IF(ISNA(VLOOKUP(A93,цены!$B$3:$D$500,2)),\"\",VLOOKUP(A93,цены!$B$3:$D$500,2,0))","v":""},null,null,{"$f":"_xlfn.CEILING.MATH(G93*H93/1000000,0.01)","v":{"$error":"#NAME?"}},null,null,null,{"$f":"IF(ISNA(VLOOKUP(A93,цены!$B$3:$D$500,3)),\"0\",VLOOKUP(A93,цены!$B$3:$D$500,3,0))","v":"0"},null,{"$f":"IF(F93=\"м2\",I93*K93,_xlfn.CEILING.MATH(J93*K93,500)/1000)*$S76*M93*IF(E93=\"Материал\",1+VLOOKUP($T$75,цены!$J$3:$K$11,2,0),1)","v":{"$error":"#NAME?"}},null,{"$f":"IF(F93=\"м2\",G93*H93*K93/1000000,J93*K93/1000)","v":0},null,{"$f":"Q93*M93","v":0},null,{"$f":"IF(F93=\"м2\",_xlfn.CEILING.MATH(G93*H93*K93/1000000,0.1),_xlfn.CEILING.MATH(J93*K93,500)/1000)","v":{"$error":"#NAME?"}},null,{"$f":"IF(ISNA(VLOOKUP(A93,цены!$B$3:$E$500,4)),\"\",VLOOKUP(A93,цены!$B$3:$E$500,4,0)*Q93)","v":""}]
[null,null,null,null,{"$f":"IF(ISNA(VLOOKUP(A94,цены!$B$3:$H$500,7)),\"\",VLOOKUP(A94,цены!$B$3:$H$500,7,0))","v":""},{"$f":"IF(ISNA(VLOOKUP(A94,цены!$B$3:$D$500,2)),\"\",VLOOKUP(A94,цены!$B$3:$D$500,2,0))","v":""},null,null,{"$f":"_xlfn.CEILING.MATH(G94*H94/1000000,0.01)","v":{"$error":"#NAME?"}},null,null,null,{"$f":"IF(ISNA(VLOOKUP(A94,цены!$B$3:$D$500,3)),\"0\",VLOOKUP(A94,цены!$B$3:$D$500,3,0))","v":"0"},null,{"$f":"IF(F94=\"м2\",I94*K94,_xlfn.CEILING.MATH(J94*K94,500)/1000)*$S77*M94*IF(E94=\"Материал\",1+VLOOKUP($T$75,цены!$J$3:$K$11,2,0),1)","v":{"$error":"#NAME?"}},null,{"$f":"IF(F94=\"м2\",G94*H94*K94/1000000,J94*K94/1000)","v":0},null,{"$f":"Q94*M94","v":0},null,{"$f":"IF(F94=\"м2\",_xlfn.CEILING.MATH(G94*H94*K94/1000000,0.1),_xlfn.CEILING.MATH(J94*K94,500)/1000)","v":{"$error":"#NAME?"}},null,{"$f":"IF(ISNA(VLOOKUP(A94,цены!$B$3:$E$500,4)),\"\",VLOOKUP(A94,цены!$B$3:$E$500,4,0)*Q94)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(O92:P94)","v":{"$error":"#NAME?"}},null,null,null,{"$f":"SUM(S92:T94)","v":36.9},null,null,null,{"$f":"SUM(W92:W94)","v":0.78300000000000003}]

{"sheet":"Элементы2","index":1,"n_rows":95,"n_cols":23,"rows_kept":95,"cut":false,"hidden":false,"merged":[[94,18,94,19],[94,20,94,21],[94,0,94,3],[94,6,94,8],[94,10,94,11],[94,12,94,13],[94,14,94,15],[94,16,94,17],[92,20,92,21],[93,0,93,2],[93,10,93,11],[93,12,93,13],[93,14,93,15],[93,16,93,17],[93,18,93,19],[93,20,93,21],[92,0,92,2],[92,10,92,11],[92,12,92,13],[92,14,92,15],[92,16,92,17],[92,18,92,19],[89,22,90,22],[90,0,90,2],[91,0,91,2],[91,10,91,11],[91,12,91,13],[91,14,91,15],[91,16,91,17],[91,18,91,19],[91,20,91,21],[89,10,90,11],[89,12,90,13],[89,14,90,15],[89,16,90,17],[89,18,90,19],[89,20,90,21],[84,16,85,18],[84,19,85,21],[86,16,88,18],[86,19,88,21],[88,0,88,15],[89,0,89,3],[89,4,90,4],[89,5,90,5],[89,6,89,8],[89,9,90,9],[78,16,79,18],[78,19,79,21],[80,16,81,18],[80,19,81,21],[82,16,83,18],[82,19,83,21],[74,16,74,17],[75,0,87,7],[75,8,87,15],[75,16,75,17],[75,19,75,20],[75,22,75,23],[76,16,76,18],[76,19,76,21],[77,16,77,18],[77,19,77,21],[72,0,72,2],[72,3,72,15],[73,0,73,2],[73,3,73,15],[74,0,74,6],[74,8,74,15],[69,20,69,21],[70,0,70,3],[70,6,70,8],[70,10,70,11],[70,12,70,13],[70,14,70,15],[70,16,70,17],[70,18,70,19],[70,20,70,21],[69,0,69,2],[69,10,69,11],[69,12,69,13],[69,14,69,15],[69,16,69,17],[69,18,69,19],[67,18,67,19],[67,20,67,21],[68,0,68,2],[68,10,68,11],[68,12,68,13],[68,14,68,15],[68,16,68,17],[68,18,68,19],[68,20,68,21],[65,16,66,17],[65,18,66,19],[65,20,66,21],[65,22,66,22],[66,0,66,2],[67,0,67,2],[67,10,67,11],[67,12,67,13],[67,14,67,15],[67,16,67,17],[64,0,64,15],[65,0,65,3],[65,4,66,4],[65,5,66,5],[65,6,65,8],[65,9,66,9],[65,10,66,11],[65,12,66,13],[65,14,66,15],[60,16,61,18],[60,19,61,21],[61,22,61,23],[62,16,64,18],[62,19,64,21],[62,22,64,23],[54,16,55,18],[54,19,55,21],[56,16,57,18],[56,19,57,21],[58,16,59,18],[58,19,59,21],[50,16,50,17],[51,0,63,7],[51,8,63,15],[51,16,51,17],[51,19,51,20],[51,22,51,23],[52,16,52,18],[52,19,52,21],[53,16,53,18],[53,19,53,21],[48,0,48,2],[48,3,48,15],[49,0,49,2],[49,3,49,15],[50,0,50,6],[50,8,50,15],[45,20,45,21],[46,0,46,3],[46,6,46,8],[46,10,46,11],[46,12,46,13],[46,14,46,15],[46,16,46,17],[46,18,46,19],[46,20,46,21],[45,0,45,2],[45,10,45,11],[45,12,45,13],[45,14,45,15],[45,16,45,17],[45,18,45,19],[43,18,43,19],[43,20,43,21],[44,0,44,2],[44,10,44,11],[44,12,44,13],[44,14,44,15],[44,16,44,17],[44,18,44,19],[44,20,44,21],[41,16,42,17],[41,18,42,19],[41,20,42,21],[41,22,42,22],[42,0,42,2],[43,0,43,2],[43,10,43,11],[43,12,43,13],[43,14,43,15],[43,16,43,17],[38,19,40,21],[40,0,40,15],[41,0,41,3],[41,4,42,4],[41,5,42,5],[41,6,41,8],[41,9,42,9],[41,10,42,11],[41,12,42,13],[41,14,42,15],[30,19,31,21],[32,16,33,18],[32,19,33,21],[34,16,35,18],[34,19,35,21],[36,16,37,18],[36,19,37,21],[27,19,27,20],[27,22,27,23],[28,16,28,18],[28,19,28,21],[29,16,29,18],[29,19,29,21],[26,0,26,6],[26,8,26,15],[26,16,26,17],[27,0,39,7],[27,8,39,15],[27,16,27,17],[30,16,31,18],[38,16,40,18],[22,18,22,19],[22,20,22,21],[24,0,24,2],[24,3,24,15],[25,0,25,2],[25,3,25,15],[22,0,22,3],[22,6,22,8],[22,10,22,11],[22,12,22,13],[22,14,22,15],[22,16,22,17],[20,20,20,21],[21,0,21,2],[21,10,21,11],[21,12,21,13],[21,14,21,15],[21,16,21,17],[21,18,21,19],[21,20,21,21],[20,0,20,2],[20,10,20,11],[20,12,20,13],[20,14,20,15],[20,16,20,17],[20,18,20,19],[17,22,18,22],[18,0,18,2],[19,0,19,2],[19,10,19,11],[19,12,19,13],[19,14,19,15],[19,16,19,17],[19,18,19,19],[19,20,19,21],[17,10,18,11],[17,12,18,13],[17,14,18,15],[17,16,18,17],[17,18,18,19],[17,20,18,21],[12,16,13,18],[12,19,13,21],[14,16,16,18],[14,19,16,21],[16,0,16,15],[17,0,17,3],[17,4,18,4],[17,5,18,5],[17,6,17,8],[17,9,18,9],[6,16,7,18],[6,19,7,21],[8,16,9,18],[8,19,9,21],[10,16,11,18],[10,19,11,21],[2,16,2,17],[3,0,15,7],[3,8,15,15],[3,16,3,17],[3,19,3,20],[3,22,3,23],[4,16,4,18],[4,19,4,21],[5,16,5,18],[5,19,5,21],[0,0,0,2],[0,3,0,15],[1,0,1,2],[1,3,1,15],[2,0,2,6],[2,8,2,15]]}
["Артикул",null,null,"ЭтСп-0013",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(Элементы1!Все=Элементы1!Тек)","v":{"$error":"#NAME?"}}]
["Наименование",null,null,"Червонка"]
["Фото",null,null,null,null,null,null,null,"Описание",null,null,null,null,null,null,null,"Доставка материала",null,1.07,"а",{"$f":"(T15-S23)/S23","v":{"$error":"#NAME?"}}]
[null,null,null,null,null,null,null,null,"Червонка длинна 415мм, высота 110мм. По обеим сторонам одинаковый загиб",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,{"$f":"_xlfn.CEILING.MATH(T15/(V4*Y4),1)","v":{"$error":"#NAME?"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Стоимость п.м. изделия",null,null,{"$f":"_xlfn.CEILING.MATH(T15/(S4*2+V4*2),1)","v":{"$error":"#NAME?"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Чистая прибыль",null,null,{"$f":"T15-T9-T11-T13-S23","v":{"$error":"#NAME?"}}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Заработная плата",null,null,{"$f":"(T15-_xlfn.CEILING.MATH(S23,5))*20%","v":{"$error":"#NAME?"}}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Расходники",null,null,{"$f":"(T15-_xlfn.CEILING.MATH(S23,5))*7%","v":{"$error":"#NAME?"}}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Аренда, электричество",null,null,{"$f":"(T15-_xlfn.CEILING.MATH(S23,5))*10%","v":{"$error":"#NAME?"}}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ИТОГОВАЯ ЦЕНА",null,null,{"$f":"_xlfn.CEILING.MATH(O23,5)","v":{"$error":"#NAME?"}}]
[]
["Калькуляция"]
["Наименование материала",null,null,null,"Статус","Ед. изм","Размер заготовки (мм)",null,null,"Размер заготовки (мм)","Количество заготовок (шт)",null,"Цена (руб/м.п.)",null,"Стоимость (руб)",null,"Количество материала факт(м.п.)",null,"Стоимость фактическая (руб)",null,"Количество материала (м.п.)",null,"Вес"]
["Расходный материал",null,null,"Описание",null,null,"Длина","Ширина","Площадь"]
["Профильная  труба15*15*1,5",null,null,null,{"$f":"IF(ISNA(VLOOKUP(A20,цены!$B$3:$H$500,7)),\"\",VLOOKUP(A20,цены!$B$3:$H$500,7,0))","v":"Материал"},{"$f":"IF(ISNA(VLOOKUP(A20,цены!$B$3:$D$500,2)),\"\",VLOOKUP(A20,цены!$B$3:$D$500,2,0))","v":"м.п."},null,null,{"$f":"_xlfn.CEILING.MATH(G20*H20/1000000,0.01)","v":{"$error":"#NAME?"}},690,1,null,{"$f":"IF(ISNA(VLOOKUP(A20,цены!$B$3:$D$500,3)),\"0\",VLOOKUP(A20,цены!$B$3:$D$500,3,0))","v":32},null,{"$f":"IF(F20=\"м2\",I20*K20,_xlfn.CEILING.MATH(J20*K20,500)/1000)*$S$3*M20*IF(E20=\"Материал\",1+VLOOKUP($T$3,цены!$J$3:$K$11,2,0),1)","v":{"$error":"#NAME?"}},null,{"$f":"IF(F20=\"м2\",G20*H20*K20/1000000,J20*K20/1000)","v":0.69},null,{"$f":"Q20*M20","v":22.08},null,{"$f":"IF(F20=\"м2\",_xlfn.CEILING.MATH(G20*H20*K20/1000000,0.1),_xlfn.CEILING.MATH(J20*K20,500)/1000)","v":{"$error":"#NAME?"}},null,{"$f":"IF(ISNA(VLOOKUP(A20,цены!$B$3:$E$500,4)),\"\",VLOOKUP(A20,цены!$B$3:$E$500,4,0)*Q20)","v":0.44159999999999999}]
[null,null,null,null,{"$f":"IF(ISNA(VLOOKUP(A21,цены!$B$3:$H$500,7)),\"\",VLOOKUP(A21,цены!$B$3:$H$500,7,0))","v":""},{"$f":"IF(ISNA(VLOOKUP(A21,цены!$B$3:$D$500,2)),\"\",VLOOKUP(A21,цены!$B$3:$D$500,2,0))","v":""},null,null,{"$f":"_xlfn.CEILING.MATH(G21*H21/1000000,0.01)","v":{"$error":"#NAME?"}},null,null,null,{"$f":"IF(ISNA(VLOOKUP(A21,цены!$B$3:$D$500,3)),\"0\",VLOOKUP(A21,цены!$B$3:$D$500,3,0))","v":"0"},null,{"$f":"IF(F21=\"м2\",I21*K21,_xlfn.CEILING.MATH(J21*K21,500)/1000)*$S$3*M21*IF(E21=\"Материал\",1+VLOOKUP($T$3,цены!$J$3:$K$11,2,0),1)","v":{"$error":"#NAME?"}},null,{"$f":"IF(F21=\"м2\",G21*H21*K21/1000000,J21*K21/1000)","v":0},null,{"$f":"Q21*M21","v":0},null,{"$f":"IF(F21=\"м2\",_xlfn.CEILING.MATH(G21*H21*K21/1000000,0.1),_xlfn.CEILING.MATH(J21*K21,500)/1000)","v":{"$error":"#NAME?"}},null,{"$f":"IF(ISNA(VLOOKUP(A21,цены!$B$3:$E$500,4)),\"\",VLOOKUP(A21,цены!$B$3:$E$500,4,0)*Q21)","v":""}]
[null,null,null,null,{"$f":"IF(ISNA(VLOOKUP(A22,цены!$B$3:$H$500,7)),\"\",VLOOKUP(A22,цены!$B$3:$H$500,7,0))","v":""},{"$f":"IF(ISNA(VLOOKUP(A22,цены!$B$3:$D$500,2)),\"\",VLOOKUP(A22,цены!$B$3:$D$500,2,0))","v":""},null,null,{"$f":"_xlfn.CEILING.MATH(G22*H22/1000000,0.01)","v":{"$error":"#NAME?"}},null,null,null,{"$f":"IF(ISNA(VLOOKUP(A22,цены!$B$3:$D$500,3)),\"0\",VLOOKUP(A22,цены!$B$3:$D$500,3,0))","v":"0"},null,{"$f":"IF(F22=\"м2\",I22*K22,_xlfn.CEILING.MATH(J22*K22,500)/1000)*$S$3*M22*IF(E22=\"Материал\",1+VLOOKUP($T$3,цены!$J$3:$K$11,2,0),1)","v":{"$error":"#NAME?"}},null,{"$f":"IF(F22=\"м2\",G22*H22*K22/1000000,J22*K22/1000)","v":0},null,{"$f":"Q22*M22","v":0},null,{"$f":"IF(F22=\"м2\",_xlfn.CEILING.MATH(G22*H22*K22/1000000,0.1),_xlfn.CEILING.MATH(J22*K22,500)/1000)","v":{"$error":"#NAME?"}},null,{"$f":"IF(ISNA(VLOOKUP(A22,цены!$B$3:$E$500,4)),\"\",VLOOKUP(A22,цены!$B$3:$E$500,4,0)*Q22)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(O20:P22)","v":{"$error":"#NAME?"}},null,null,null,{"$f":"SUM(S20:T22)","v":22.08},null,null,null,{"$f":"SUM(W20:W22)","v":0.44159999999999999}]
[]
["Артикул",null,null,"ЭтСп-002"]
["Наименование"]
["Фото",null,null,null,null,null,null,null,"Описание",null,null,null,null,null,null,null,"Доставка материала",null,1.07,"а",{"$f":"(T39-S47)/S47","v":{"$error":"#NAME?"}}]
[null,null,null,null,null,null,null,null,"Червонка длина 340 мм высота загиба большого завитка 150 мм, малого завитка 80 мм.",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,{"$f":"_xlfn.CEILING.MATH(T39/(V28*Y28),1)","v":{"$error":"#NAME?"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Стоимость п.м. изделия",null,null,{"$f":"_xlfn.CEILING.MATH(T39/(S28*2+V28*2),1)","v":{"$error":"#NAME?"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Чистая прибыль",null,null,{"$f":"T39-T33-T35-T37-S47","v":{"$error":"#NAME?"}}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Заработная плата",null,null,{"$f":"(T39-_xlfn.CEILING.MATH(S47,5))*20%","v":{"$error":"#NAME?"}}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Расходники",null,null,{"$f":"(T39-_xlfn.CEILING.MATH(S47,5))*7%","v":{"$error":"#NAME?"}}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Аренда, электричество",null,null,{"$f":"(T39-_xlfn.CEILING.MATH(S47,5))*10%","v":{"$error":"#NAME?"}}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ИТОГОВАЯ ЦЕНА",null,null,{"$f":"_xlfn.CEILING.MATH(O47,5)","v":{"$error":"#NAME?"}}]
[]
["Калькуляция"]
["Наименование материала",null,null,null,"Статус","Ед. изм","Размер заготовки (мм)",null,null,"Размер заготовки (мм)","Количество заготовок (шт)",null,"Цена (руб/м.п.)",null,"Стоимость (руб)",null,"Количество материала факт(м.п.)",null,"Стоимость фактическая (руб)",null,"Количество материала (м.п.)",null,"Вес"]
["Расходный материал",null,null,"Описание",null,null,"Длина","Ширина","Площадь"]
["Профильная  труба15*15*1,5",null,null,null,{"$f":"IF(ISNA(VLOOKUP(A44,цены!$B$3:$H$500,7)),\"\",VLOOKUP(A44,цены!$B$3:$H$500,7,0))","v":"Материал"},{"$f":"IF(ISNA(VLOOKUP(A44,цены!$B$3:$D$500,2)),\"\",VLOOKUP(A44,цены!$B$3:$D$500,2,0))","v":"м.п."},null,null,{"$f":"_xlfn.CEILING.MATH(G44*H44/1000000,0.01)","v":{"$error":"#NAME?"}},690,1,null,{"$f":"IF(ISNA(VLOOKUP(A44,цены!$B$3:$D$500,3)),\"0\",VLOOKUP(A44,цены!$B$3:$D$500,3,0))","v":32},null,{"$f":"IF(F44=\"м2\",I44*K44,_xlfn.CEILING.MATH(J44*K44,500)/1000)*$S$27*M44*IF(E44=\"Материал\",1+VLOOKUP($T$27,цены!$J$3:$K$11,2,0),1)","v":{"$error":"#NAME?"}},null,{"$f":"IF(F44=\"м2\",G44*H44*K44/1000000,J44*K44/1000)","v":0.69},null,{"$f":"Q44*M44","v":22.08},null,{"$f":"IF(F44=\"м2\",_xlfn.CEILING.MATH(G44*H44*K44/1000000,0.1),_xlfn.CEILING.MATH(J44*K44,500)/1000)","v":{"$error":"#NAME?"}},null,{"$f":"IF(ISNA(VLOOKUP(A44,цены!$B$3:$E$500,4)),\"\",VLOOKUP(A44,цены!$B$3:$E$500,4,0)*Q44)","v":0.44159999999999999}]
[null,null,null,null,{"$f":"IF(ISNA(VLOOKUP(A45,цены!$B$3:$H$500,7)),\"\",VLOOKUP(A45,цены!$B$3:$H$500,7,0))","v":""},{"$f":"IF(ISNA(VLOOKUP(A45,цены!$B$3:$D$500,2)),\"\",VLOOKUP(A45,цены!$B$3:$D$500,2,0))","v":""},null,null,{"$f":"_xlfn.CEILING.MATH(G45*H45/1000000,0.01)","v":{"$error":"#NAME?"}},null,null,null,{"$f":"IF(ISNA(VLOOKUP(A45,цены!$B$3:$D$500,3)),\"0\",VLOOKUP(A45,цены!$B$3:$D$500,3,0))","v":"0"},null,{"$f":"IF(F45=\"м2\",I45*K45,_xlfn.CEILING.MATH(J45*K45,500)/1000)*$S$27*M45*IF(E45=\"Материал\",1+VLOOKUP($T$27,цены!$J$3:$K$11,2,0),1)","v":{"$error":"#NAME?"}},null,{"$f":"IF(F45=\"м2\",G45*H45*K45/1000000,J45*K45/1000)","v":0},null,{"$f":"Q45*M45","v":0},null,{"$f":"IF(F45=\"м2\",_xlfn.CEILING.MATH(G45*H45*K45/1000000,0.1),_xlfn.CEILING.MATH(J45*K45,500)/1000)","v":{"$error":"#NAME?"}},null,{"$f":"IF(ISNA(VLOOKUP(A45,цены!$B$3:$E$500,4)),\"\",VLOOKUP(A45,цены!$B$3:$E$500,4,0)*Q45)","v":""}]
[null,null,null,null,{"$f":"IF(ISNA(VLOOKUP(A46,цены!$B$3:$H$500,7)),\"\",VLOOKUP(A46,цены!$B$3:$H$500,7,0))","v":""},{"$f":"IF(ISNA(VLOOKUP(A46,цены!$B$3:$D$500,2)),\"\",VLOOKUP(A46,цены!$B$3:$D$500,2,0))","v":""},null,null,{"$f":"_xlfn.CEILING.MATH(G46*H46/1000000,0.01)","v":{"$error":"#NAME?"}},null,null,null,{"$f":"IF(ISNA(VLOOKUP(A46,цены!$B$3:$D$500,3)),\"0\",VLOOKUP(A46,цены!$B$3:$D$500,3,0))","v":"0"},null,{"$f":"IF(F46=\"м2\",I46*K46,_xlfn.CEILING.MATH(J46*K46,500)/1000)*$S$27*M46*IF(E46=\"Материал\",1+VLOOKUP($T$27,цены!$J$3:$K$11,2,0),1)","v":{"$error":"#NAME?"}},null,{"$f":"IF(F46=\"м2\",G46*H46*K46/1000000,J46*K46/1000)","v":0},null,{"$f":"Q46*M46","v":0},null,{"$f":"IF(F46=\"м2\",_xlfn.CEILING.MATH(G46*H46*K46/1000000,0.1),_xlfn.CEILING.MATH(J46*K46,500)/1000)","v":{"$error":"#NAME?"}},null,{"$f":"IF(ISNA(VLOOKUP(A46,цены!$B$3:$E$500,4)),\"\",VLOOKUP(A46,цены!$B$3:$E$500,4,0)*Q46)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(O44:P46)","v":{"$error":"#NAME?"}},null,null,null,{"$f":"SUM(S44:T46)","v":22.08},null,null,null,{"$f":"SUM(W44:W46)","v":0.44159999999999999}]
[]
["Артикул",null,null,"ЭтСп-0018"]
["Наименование"]
["Фото",null,null,null,null,null,null,null,"Описание",null,null,null,null,null,null,null,"Доставка материала",null,1.07,"ж",{"$f":"(T63-S71)/S71","v":{"$error":"#NAME?"}}]
[null,null,null,null,null,null,null,null,"Червонка с одинаковыми загибами, окончание гусиная и гладкая лапка. Длина заготовки 450 мм. Материал квадрат 10мм. Размер h*L 60*170мм.",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,{"$f":"_xlfn.CEILING.MATH(T63/(V52*Y52),1)","v":{"$error":"#NAME?"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Стоимость п.м. изделия",null,null,{"$f":"_xlfn.CEILING.MATH(T63/(S52*2+V52*2),1)","v":{"$error":"#NAME?"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Чистая прибыль",null,null,{"$f":"T63-T57-T59-T61-S71","v":{"$error":"#NAME?"}}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Заработная плата",null,null,{"$f":"(T63-_xlfn.CEILING.MATH(S71,50))*20%","v":{"$error":"#NAME?"}}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Расходники",null,null,{"$f":"(T63-_xlfn.CEILING.MATH(S71,50))*7%","v":{"$error":"#NAME?"}}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Аренда, электричество",null,null,{"$f":"(T63-_xlfn.CEILING.MATH(S71,50))*10%","v":{"$error":"#NAME?"}}]
[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,null,null,null,null,null,null,null,"ИТОГОВАЯ ЦЕНА",null,null,{"$f":"_xlfn.CEILING.MATH(O71,0.01)","v":{"$error":"#NAME?"}},null,null,{"$f":"T63*1.5","v":{"$error":"#NAME?"}}]
[]
["Калькуляция"]
["Наименование материала",null,null,null,"Статус","Ед. изм","Размер заготовки (мм)",null,null,"Размер заготовки (мм)","Количество заготовок (шт)",null,"Цена (руб/м.п.)",null,"Стоимость (руб)",null,"Количество материала факт(м.п.)",null,"Стоимость фактическая (руб)",null,"Количество материала (м.п.)",null,"Вес"]
["Расходный материал",null,null,"Описание",null,null,"Длина","Ширина","Площадь"]
["Квадрат 10*10",null,null,"Червонка",{"$f":"IF(ISNA(VLOOKUP(A68,цены!$B$3:$H$500,7)),\"\",VLOOKUP(A68,цены!$B$3:$H$500,7,0))","v":"Материал"},{"$f":"IF(ISNA(VLOOKUP(A68,цены!$B$3:$D$500,2)),\"\",VLOOKUP(A68,цены!$B$3:$D$500,2,0))","v":"м.п."},null,null,{"$f":"_xlfn.CEILING.MATH(G68*H68/1000000,0.01)","v":{"$error":"#NAME?"}},450,1,null,{"$f":"IF(ISNA(VLOOKUP(A68,цены!$B$3:$D$500,3)),\"0\",VLOOKUP(A68,цены!$B$3:$D$500,3,0))","v":34},null,{"$f":"IF(F68=\"м2\",I68*K68,_xlfn.CEILING.MATH(J68*K68,10)/1000)*$S$51*M68*IF(E68=\"Материал\",1+VLOOKUP($T$51,цены!$J$3:$K$11,2,0),1)","v":{"$error":"#NAME?"}},null,{"$f":"IF(F68=\"м2\",G68*H68*K68/1000000,J68*K68/1000)","v":0.45},null,{"$f":"Q68*M68","v":15.3},null,{"$f":"IF(F68=\"м2\",_xlfn.CEILING.MATH(G68*H68*K68/1000000,0.1),_xlfn.CEILING.MATH(J68*K68,500)/1000)","v":{"$error":"#NAME?"}},null,{"$f":"IF(ISNA(VLOOKUP(A68,цены!$B$3:$E$500,4)),\"\",VLOOKUP(A68,цены!$B$3:$E$500,4,0)*Q68)","v":0.35100000000000003}]
[null,null,null,null,{"$f":"IF(ISNA(VLOOKUP(A69,цены!$B$3:$H$500,7)),\"\",VLOOKUP(A69,цены!$B$3:$H$500,7,0))","v":""},{"$f":"IF(ISNA(VLOOKUP(A69,цены!$B$3:$D$500,2)),\"\",VLOOKUP(A69,цены!$B$3:$D$500,2,0))","v":""},null,null,{"$f":"_xlfn.CEILING.MATH(G69*H69/1000000,0.01)","v":{"$error":"#NAME?"}},null,null,null,{"$f":"IF(ISNA(VLOOKUP(A69,цены!$B$3:$D$500,3)),\"0\",VLOOKUP(A69,цены!$B$3:$D$500,3,0))","v":"0"},null,{"$f":"IF(F69=\"м2\",I69*K69,_xlfn.CEILING.MATH(J69*K69,10)/1000)*$S$51*M69*IF(E69=\"Материал\",1+VLOOKUP($T$51,цены!$J$3:$K$11,2,0),1)","v":{"$error":"#NAME?"}},null,{"$f":"IF(F69=\"м2\",G69*H69*K69/1000000,J69*K69/1000)","v":0},null,{"$f":"Q69*M69","v":0},null,{"$f":"IF(F69=\"м2\",_xlfn.CEILING.MATH(G69*H69*K69/1000000,0.1),_xlfn.CEILING.MATH(J69*K69,500)/1000)","v":{"$error":"#NAME?"}},null,{"$f":"IF(ISNA(VLOOKUP(A69,цены!$B$3:$E$500,4)),\"\",VLOOKUP(A69,цены!$B$3:$E$500,4,0)*Q69)","v":""}]
[null,null,null,null,{"$f":"IF(ISNA(VLOOKUP(A70,цены!$B$3:$H$500,7)),\"\",VLOOKUP(A70,цены!$B$3:$H$500,7,0))","v":""},{"$f":"IF(ISNA(VLOOKUP(A70,цены!$B$3:$D$500,2)),\"\",VLOOKUP(A70,цены!$B$3:$D$500,2,0))","v":""},null,null,{"$f":"_xlfn.CEILING.MATH(G70*H70/1000000,0.01)","v":{"$error":"#NAME?"}},null,null,null,{"$f":"IF(ISNA(VLOOKUP(A70,цены!$B$3:$D$500,3)),\"0\",VLOOKUP(A70,цены!$B$3:$D$500,3,0))","v":"0"},null,{"$f":"IF(F70=\"м2\",I70*K70,_xlfn.CEILING.MATH(J70*K70,10)/1000)*$S$51*M70*IF(E70=\"Материал\",1+VLOOKUP($T$51,цены!$J$3:$K$11,2,0),1)","v":{"$error":"#NAME?"}},null,{"$f":"IF(F70=\"м2\",G70*H70*K70/1000000,J70*K70/1000)","v":0},null,{"$f":"Q70*M70","v":0},null,{"$f":"IF(F70=\"м2\",_xlfn.CEILING.MATH(G70*H70*K70/1000000,0.1),_xlfn.CEILING.MATH(J70*K70,500)/1000)","v":{"$error":"#NAME?"}},null,{"$f":"IF(ISNA(VLOOKUP(A70,цены!$B$3:$E$500,4)),\"\",VLOOKUP(A70,цены!$B$3:$E$500,4,0)*Q70)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(O68:P70)","v":{"$error":"#NAME?"}},null,null,null,{"$f":"SUM(S68:T70)","v":15.3},null,null,null,{"$f":"SUM(W68:W70)","v":0.35100000000000003}]
[]
["Артикул",null,null,"ЭтСп-0033"]
["Наименование"]
["Фото",null,null,null,null,null,null,null,"Описание",null,null,null,null,null,null,null,"Доставка материала",null,1.07,"в",{"$f":"(T87-S95)/S95","v":{"$error":"#NAME?"}}]
[null,null,null,null,null,null,null,null,"Дуга для вешала ширина основания 540 мм.",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,{"$f":"_xlfn.CEILING.MATH(T87/(V76*Y76),1)","v":{"$error":"#NAME?"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Стоимость п.м. изделия",null,null,{"$f":"_xlfn.CEILING.MATH(T87/(S76*2+V76*2),1)","v":{"$error":"#NAME?"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Чистая прибыль",null,null,{"$f":"T87-T81-T83-T85-S95","v":{"$error":"#NAME?"}}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Заработная плата",null,null,{"$f":"(T87-_xlfn.CEILING.MATH(S95,5))*20%","v":{"$error":"#NAME?"}}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Расходники",null,null,{"$f":"(T87-_xlfn.CEILING.MATH(S95,5))*7%","v":{"$error":"#NAME?"}}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Аренда, электричество",null,null,{"$f":"(T87-_xlfn.CEILING.MATH(S95,5))*10%","v":{"$error":"#NAME?"}}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ИТОГОВАЯ ЦЕНА",null,null,{"$f":"_xlfn.CEILING.MATH(O95,5)","v":{"$error":"#NAME?"}}]
[]
["Калькуляция"]
["Наименование материала",null,null,null,"Статус","Ед. изм","Размер заготовки (мм)",null,null,"Размер заготовки (мм)","Количество заготовок (шт)",null,"Цена (руб/м.п.)",null,"Стоимость (руб)",null,"Количество материала факт(м.п.)",null,"Стоимость фактическая (руб)",null,"Количество материала (м.п.)",null,"Вес"]
["Расходный материал",null,null,"Описание",null,null,"Длина","Ширина","Площадь"]
["Профильная  труба20*20*1,5",null,null,null,{"$f":"IF(ISNA(VLOOKUP(A92,цены!$B$3:$H$500,7)),\"\",VLOOKUP(A92,цены!$B$3:$H$500,7,0))","v":"Материал"},{"$f":"IF(ISNA(VLOOKUP(A92,цены!$B$3:$D$500,2)),\"\",VLOOKUP(A92,цены!$B$3:$D$500,2,0))","v":"м.п."},null,null,{"$f":"_xlfn.CEILING.MATH(G92*H92/1000000,0.01)","v":{"$error":"#NAME?"}},900,1,null,{"$f":"IF(ISNA(VLOOKUP(A92,цены!$B$3:$D$500,3)),\"0\",VLOOKUP(A92,цены!$B$3:$D$500,3,0))","v":41},null,{"$f":"IF(F92=\"м2\",I92*K92,_xlfn.CEILING.MATH(J92*K92,500)/1000)*$S75*M92*IF(E92=\"Материал\",1+VLOOKUP($T$75,цены!$J$3:$K$11,2,0),1)","v":{"$error":"#NAME?"}},null,{"$f":"IF(F92=\"м2\",G92*H92*K92/1000000,J92*K92/1000)","v":0.9},null,{"$f":"Q92*M92","v":36.9},null,{"$f":"IF(F92=\"м2\",_xlfn.CEILING.MATH(G92*H92*K92/1000000,0.1),_xlfn.CEILING.MATH(J92*K92,500)/1000)","v":{"$error":"#NAME?"}},null,{"$f":"IF(ISNA(VLOOKUP(A92,цены!$B$3:$E$500,4)),\"\",VLOOKUP(A92,цены!$B$3:$E$500,4,0)*Q92)","v":0.78300000000000003}]
[null,null,null,null,{"$f":"IF(ISNA(VLOOKUP(A93,цены!$B$3:$H$500,7)),\"\",VLOOKUP(A93,цены!$B$3:$H$500,7,0))","v":""},{"$f":"IF(ISNA(VLOOKUP(A93,цены!$B$3:$D$500,2)),\"\",VLOOKUP(A93,цены!$B$3:$D$500,2,0))","v":""},null,null,{"$f":"_xlfn.CEILING.MATH(G93*H93/1000000,0.01)","v":{"$error":"#NAME?"}},null,null,null,{"$f":"IF(ISNA(VLOOKUP(A93,цены!$B$3:$D$500,3)),\"0\",VLOOKUP(A93,цены!$B$3:$D$500,3,0))","v":"0"},null,{"$f":"IF(F93=\"м2\",I93*K93,_xlfn.CEILING.MATH(J93*K93,500)/1000)*$S76*M93*IF(E93=\"Материал\",1+VLOOKUP($T$75,цены!$J$3:$K$11,2,0),1)","v":{"$error":"#NAME?"}},null,{"$f":"IF(F93=\"м2\",G93*H93*K93/1000000,J93*K93/1000)","v":0},null,{"$f":"Q93*M93","v":0},null,{"$f":"IF(F93=\"м2\",_xlfn.CEILING.MATH(G93*H93*K93/1000000,0.1),_xlfn.CEILING.MATH(J93*K93,500)/1000)","v":{"$error":"#NAME?"}},null,{"$f":"IF(ISNA(VLOOKUP(A93,цены!$B$3:$E$500,4)),\"\",VLOOKUP(A93,цены!$B$3:$E$500,4,0)*Q93)","v":""}]
[null,null,null,null,{"$f":"IF(ISNA(VLOOKUP(A94,цены!$B$3:$H$500,7)),\"\",VLOOKUP(A94,цены!$B$3:$H$500,7,0))","v":""},{"$f":"IF(ISNA(VLOOKUP(A94,цены!$B$3:$D$500,2)),\"\",VLOOKUP(A94,цены!$B$3:$D$500,2,0))","v":""},null,null,{"$f":"_xlfn.CEILING.MATH(G94*H94/1000000,0.01)","v":{"$error":"#NAME?"}},null,null,null,{"$f":"IF(ISNA(VLOOKUP(A94,цены!$B$3:$D$500,3)),\"0\",VLOOKUP(A94,цены!$B$3:$D$500,3,0))","v":"0"},null,{"$f":"IF(F94=\"м2\",I94*K94,_xlfn.CEILING.MATH(J94*K94,500)/1000)*$S77*M94*IF(E94=\"Материал\",1+VLOOKUP($T$75,цены!$J$3:$K$11,2,0),1)","v":{"$error":"#NAME?"}},null,{"$f":"IF(F94=\"м2\",G94*H94*K94/1000000,J94*K94/1000)","v":0},null,{"$f":"Q94*M94","v":0},null,{"$f":"IF(F94=\"м2\",_xlfn.CEILING.MATH(G94*H94*K94/1000000,0.1),_xlfn.CEILING.MATH(J94*K94,500)/1000)","v":{"$error":"#NAME?"}},null,{"$f":"IF(ISNA(VLOOKUP(A94,цены!$B$3:$E$500,4)),\"\",VLOOKUP(A94,цены!$B$3:$E$500,4,0)*Q94)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(O92:P94)","v":{"$error":"#NAME?"}},null,null,null,{"$f":"SUM(S92:T94)","v":36.9},null,null,null,{"$f":"SUM(W92:W94)","v":0.78300000000000003}]

{"sheet":"Элементы3","index":2,"n_rows":95,"n_cols":23,"rows_kept":95,"cut":false,"hidden":false,"merged":[[94,18,94,19],[94,20,94,21],[94,0,94,3],[94,6,94,8],[94,10,94,11],[94,12,94,13],[94,14,94,15],[94,16,94,17],[92,20,92,21],[93,0,93,2],[93,10,93,11],[93,12,93,13],[93,14,93,15],[93,16,93,17],[93,18,93,19],[93,20,93,21],[92,0,92,2],[92,10,92,11],[92,12,92,13],[92,14,92,15],[92,16,92,17],[92,18,92,19],[89,22,90,22],[90,0,90,2],[91,0,91,2],[91,10,91,11],[91,12,91,13],[91,14,91,15],[91,16,91,17],[91,18,91,19],[91,20,91,21],[89,10,90,11],[89,12,90,13],[89,14,90,15],[89,16,90,17],[89,18,90,19],[89,20,90,21],[84,16,85,18],[84,19,85,21],[86,16,88,18],[86,19,88,21],[88,0,88,15],[89,0,89,3],[89,4,90,4],[89,5,90,5],[89,6,89,8],[89,9,90,9],[78,16,79,18],[78,19,79,21],[80,16,81,18],[80,19,81,21],[82,16,83,18],[82,19,83,21],[74,16,74,17],[75,0,87,7],[75,8,87,15],[75,16,75,17],[75,19,75,20],[75,22,75,23],[76,16,76,18],[76,19,76,21],[77,16,77,18],[77,19,77,21],[72,0,72,2],[72,3,72,15],[73,0,73,2],[73,3,73,15],[74,0,74,6],[74,8,74,15],[69,20,69,21],[70,0,70,3],[70,6,70,8],[70,10,70,11],[70,12,70,13],[70,14,70,15],[70,16,70,17],[70,18,70,19],[70,20,70,21],[69,0,69,2],[69,10,69,11],[69,12,69,13],[69,14,69,15],[69,16,69,17],[69,18,69,19],[67,18,67,19],[67,20,67,21],[68,0,68,2],[68,10,68,11],[68,12,68,13],[68,14,68,15],[68,16,68,17],[68,18,68,19],[68,20,68,21],[65,16,66,17],[65,18,66,19],[65,20,66,21],[65,22,66,22],[66,0,66,2],[67,0,67,2],[67,10,67,11],[67,12,67,13],[67,14,67,15],[67,16,67,17],[64,0,64,15],[65,0,65,3],[65,4,66,4],[65,5,66,5],[65,6,65,8],[65,9,66,9],[65,10,66,11],[65,12,66,13],[65,14,66,15],[60,16,61,18],[60,19,61,21],[61,22,61,23],[62,16,64,18],[62,19,64,21],[62,22,64,23],[54,16,55,18],[54,19,55,21],[56,16,57,18],[56,19,57,21],[58,16,59,18],[58,19,59,21],[50,16,50,17],[51,0,63,7],[51,8,63,15],[51,16,51,17],[51,19,51,20],[51,22,51,23],[52,16,52,18],[52,19,52,21],[53,16,53,18],[53,19,53,21],[48,0,48,2],[48,3,48,15],[49,0,49,2],[49,3,49,15],[50,0,50,6],[50,8,50,15],[45,20,45,21],[46,0,46,3],[46,6,46,8],[46,10,46,11],[46,12,46,13],[46,14,46,15],[46,16,46,17],[46,18,46,19],[46,20,46,21],[45,0,45,2],[45,10,45,11],[45,12,45,13],[45,14,45,15],[45,16,45,17],[45,18,45,19],[43,18,43,19],[43,20,43,21],[44,0,44,2],[44,10,44,11],[44,12,44,13],[44,14,44,15],[44,16,44,17],[44,18,44,19],[44,20,44,21],[41,16,42,17],[41,18,42,19],[41,20,42,21],[41,22,42,22],[42,0,42,2],[43,0,43,2],[43,10,43,11],[43,12,43,13],[43,14,43,15],[43,16,43,17],[38,19,40,21],[40,0,40,15],[41,0,41,3],[41,4,42,4],[41,5,42,5],[41,6,41,8],[41,9,42,9],[41,10,42,11],[41,12,42,13],[41,14,42,15],[30,19,31,21],[32,16,33,18],[32,19,33,21],[34,16,35,18],[34,19,35,21],[36,16,37,18],[36,19,37,21],[27,19,27,20],[27,22,27,23],[28,16,28,18],[28,19,28,21],[29,16,29,18],[29,19,29,21],[26,0,26,6],[26,8,26,15],[26,16,26,17],[27,0,39,7],[27,8,39,15],[27,16,27,17],[30,16,31,18],[38,16,40,18],[22,18,22,19],[22,20,22,21],[24,0,24,2],[24,3,24,15],[25,0,25,2],[25,3,25,15],[22,0,22,3],[22,6,22,8],[22,10,22,11],[22,12,22,13],[22,14,22,15],[22,16,22,17],[20,20,20,21],[21,0,21,2],[21,10,21,11],[21,12,21,13],[21,14,21,15],[21,16,21,17],[21,18,21,19],[21,20,21,21],[20,0,20,2],[20,10,20,11],[20,12,20,13],[20,14,20,15],[20,16,20,17],[20,18,20,19],[17,22,18,22],[18,0,18,2],[19,0,19,2],[19,10,19,11],[19,12,19,13],[19,14,19,15],[19,16,19,17],[19,18,19,19],[19,20,19,21],[17,10,18,11],[17,12,18,13],[17,14,18,15],[17,16,18,17],[17,18,18,19],[17,20,18,21],[12,16,13,18],[12,19,13,21],[14,16,16,18],[14,19,16,21],[16,0,16,15],[17,0,17,3],[17,4,18,4],[17,5,18,5],[17,6,17,8],[17,9,18,9],[6,16,7,18],[6,19,7,21],[8,16,9,18],[8,19,9,21],[10,16,11,18],[10,19,11,21],[2,16,2,17],[3,0,15,7],[3,8,15,15],[3,16,3,17],[3,19,3,20],[3,22,3,23],[4,16,4,18],[4,19,4,21],[5,16,5,18],[5,19,5,21],[0,0,0,2],[0,3,0,15],[1,0,1,2],[1,3,1,15],[2,0,2,6],[2,8,2,15]]}
["Артикул",null,null,"ЭтСп-0014"]
["Наименование",null,null,"Червонка"]
["Фото",null,null,null,null,null,null,null,"Описание",null,null,null,null,null,null,null,"Доставка материала",null,1.07,"а",{"$f":"(T15-S23)/S23","v":{"$error":"#NAME?"}}]
[null,null,null,null,null,null,null,null,"Червонка длинна 415мм, высота 110мм. По обеим сторонам одинаковый загиб",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,{"$f":"_xlfn.CEILING.MATH(T15/(V4*Y4),1)","v":{"$error":"#NAME?"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Стоимость п.м. изделия",null,null,{"$f":"_xlfn.CEILING.MATH(T15/(S4*2+V4*2),1)","v":{"$error":"#NAME?"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Чистая прибыль",null,null,{"$f":"T15-T9-T11-T13-S23","v":{"$error":"#NAME?"}}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Заработная плата",null,null,{"$f":"(T15-_xlfn.CEILING.MATH(S23,5))*20%","v":{"$error":"#NAME?"}}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Расходники",null,null,{"$f":"(T15-_xlfn.CEILING.MATH(S23,5))*7%","v":{"$error":"#NAME?"}}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Аренда, электричество",null,null,{"$f":"(T15-_xlfn.CEILING.MATH(S23,5))*10%","v":{"$error":"#NAME?"}}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ИТОГОВАЯ ЦЕНА",null,null,{"$f":"_xlfn.CEILING.MATH(O23,5)","v":{"$error":"#NAME?"}}]
[]
["Калькуляция"]
["Наименование материала",null,null,null,"Статус","Ед. изм","Размер заготовки (мм)",null,null,"Размер заготовки (мм)","Количество заготовок (шт)",null,"Цена (руб/м.п.)",null,"Стоимость (руб)",null,"Количество материала факт(м.п.)",null,"Стоимость фактическая (руб)",null,"Количество материала (м.п.)",null,"Вес"]
["Расходный материал",null,null,"Описание",null,null,"Длина","Ширина","Площадь"]
["Профильная  труба15*15*1,5",null,null,null,{"$f":"IF(ISNA(VLOOKUP(A20,цены!$B$3:$H$500,7)),\"\",VLOOKUP(A20,цены!$B$3:$H$500,7,0))","v":"Материал"},{"$f":"IF(ISNA(VLOOKUP(A20,цены!$B$3:$D$500,2)),\"\",VLOOKUP(A20,цены!$B$3:$D$500,2,0))","v":"м.п."},null,null,{"$f":"_xlfn.CEILING.MATH(G20*H20/1000000,0.01)","v":{"$error":"#NAME?"}},690,1,null,{"$f":"IF(ISNA(VLOOKUP(A20,цены!$B$3:$D$500,3)),\"0\",VLOOKUP(A20,цены!$B$3:$D$500,3,0))","v":32},null,{"$f":"IF(F20=\"м2\",I20*K20,_xlfn.CEILING.MATH(J20*K20,500)/1000)*$S$3*M20*IF(E20=\"Материал\",1+VLOOKUP($T$3,цены!$J$3:$K$11,2,0),1)","v":{"$error":"#NAME?"}},null,{"$f":"IF(F20=\"м2\",G20*H20*K20/1000000,J20*K20/1000)","v":0.69},null,{"$f":"Q20*M20","v":22.08},null,{"$f":"IF(F20=\"м2\",_xlfn.CEILING.MATH(G20*H20*K20/1000000,0.1),_xlfn.CEILING.MATH(J20*K20,500)/1000)","v":{"$error":"#NAME?"}},null,{"$f":"IF(ISNA(VLOOKUP(A20,цены!$B$3:$E$500,4)),\"\",VLOOKUP(A20,цены!$B$3:$E$500,4,0)*Q20)","v":0.44159999999999999}]
[null,null,null,null,{"$f":"IF(ISNA(VLOOKUP(A21,цены!$B$3:$H$500,7)),\"\",VLOOKUP(A21,цены!$B$3:$H$500,7,0))","v":""},{"$f":"IF(ISNA(VLOOKUP(A21,цены!$B$3:$D$500,2)),\"\",VLOOKUP(A21,цены!$B$3:$D$500,2,0))","v":""},null,null,{"$f":"_xlfn.CEILING.MATH(G21*H21/1000000,0.01)","v":{"$error":"#NAME?"}},null,null,null,{"$f":"IF(ISNA(VLOOKUP(A21,цены!$B$3:$D$500,3)),\"0\",VLOOKUP(A21,цены!$B$3:$D$500,3,0))","v":"0"},null,{"$f":"IF(F21=\"м2\",I21*K21,_xlfn.CEILING.MATH(J21*K21,500)/1000)*$S$3*M21*IF(E21=\"Материал\",1+VLOOKUP($T$3,цены!$J$3:$K$11,2,0),1)","v":{"$error":"#NAME?"}},null,{"$f":"IF(F21=\"м2\",G21*H21*K21/1000000,J21*K21/1000)","v":0},null,{"$f":"Q21*M21","v":0},null,{"$f":"IF(F21=\"м2\",_xlfn.CEILING.MATH(G21*H21*K21/1000000,0.1),_xlfn.CEILING.MATH(J21*K21,500)/1000)","v":{"$error":"#NAME?"}},null,{"$f":"IF(ISNA(VLOOKUP(A21,цены!$B$3:$E$500,4)),\"\",VLOOKUP(A21,цены!$B$3:$E$500,4,0)*Q21)","v":""}]
[null,null,null,null,{"$f":"IF(ISNA(VLOOKUP(A22,цены!$B$3:$H$500,7)),\"\",VLOOKUP(A22,цены!$B$3:$H$500,7,0))","v":""},{"$f":"IF(ISNA(VLOOKUP(A22,цены!$B$3:$D$500,2)),\"\",VLOOKUP(A22,цены!$B$3:$D$500,2,0))","v":""},null,null,{"$f":"_xlfn.CEILING.MATH(G22*H22/1000000,0.01)","v":{"$error":"#NAME?"}},null,null,null,{"$f":"IF(ISNA(VLOOKUP(A22,цены!$B$3:$D$500,3)),\"0\",VLOOKUP(A22,цены!$B$3:$D$500,3,0))","v":"0"},null,{"$f":"IF(F22=\"м2\",I22*K22,_xlfn.CEILING.MATH(J22*K22,500)/1000)*$S$3*M22*IF(E22=\"Материал\",1+VLOOKUP($T$3,цены!$J$3:$K$11,2,0),1)","v":{"$error":"#NAME?"}},null,{"$f":"IF(F22=\"м2\",G22*H22*K22/1000000,J22*K22/1000)","v":0},null,{"$f":"Q22*M22","v":0},null,{"$f":"IF(F22=\"м2\",_xlfn.CEILING.MATH(G22*H22*K22/1000000,0.1),_xlfn.CEILING.MATH(J22*K22,500)/1000)","v":{"$error":"#NAME?"}},null,{"$f":"IF(ISNA(VLOOKUP(A22,цены!$B$3:$E$500,4)),\"\",VLOOKUP(A22,цены!$B$3:$E$500,4,0)*Q22)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(O20:P22)","v":{"$error":"#NAME?"}},null,null,null,{"$f":"SUM(S20:T22)","v":22.08},null,null,null,{"$f":"SUM(W20:W22)","v":0.44159999999999999}]
[]
["Артикул",null,null,"ЭтСп-0017"]
["Наименование"]
["Фото",null,null,null,null,null,null,null,"Описание",null,null,null,null,null,null,null,"Доставка материала",null,1.07,"а",{"$f":"(T39-S47)/S47","v":{"$error":"#NAME?"}}]
[null,null,null,null,null,null,null,null,"Червонка длина 340 мм высота загиба большого завитка 150 мм, малого завитка 80 мм.",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,{"$f":"_xlfn.CEILING.MATH(T39/(V28*Y28),1)","v":{"$error":"#NAME?"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Стоимость п.м. изделия",null,null,{"$f":"_xlfn.CEILING.MATH(T39/(S28*2+V28*2),1)","v":{"$error":"#NAME?"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Чистая прибыль",null,null,{"$f":"T39-T33-T35-T37-S47","v":{"$error":"#NAME?"}}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Заработная плата",null,null,{"$f":"(T39-_xlfn.CEILING.MATH(S47,5))*20%","v":{"$error":"#NAME?"}}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Расходники",null,null,{"$f":"(T39-_xlfn.CEILING.MATH(S47,5))*7%","v":{"$error":"#NAME?"}}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Аренда, электричество",null,null,{"$f":"(T39-_xlfn.CEILING.MATH(S47,5))*10%","v":{"$error":"#NAME?"}}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ИТОГОВАЯ ЦЕНА",null,null,{"$f":"_xlfn.CEILING.MATH(O47,5)","v":{"$error":"#NAME?"}}]
[]
["Калькуляция"]
["Наименование материала",null,null,null,"Статус","Ед. изм","Размер заготовки (мм)",null,null,"Размер заготовки (мм)","Количество заготовок (шт)",null,"Цена (руб/м.п.)",null,"Стоимость (руб)",null,"Количество материала факт(м.п.)",null,"Стоимость фактическая (руб)",null,"Количество материала (м.п.)",null,"Вес"]
["Расходный материал",null,null,"Описание",null,null,"Длина","Ширина","Площадь"]
["Профильная  труба15*15*1,5",null,null,null,{"$f":"IF(ISNA(VLOOKUP(A44,цены!$B$3:$H$500,7)),\"\",VLOOKUP(A44,цены!$B$3:$H$500,7,0))","v":"Материал"},{"$f":"IF(ISNA(VLOOKUP(A44,цены!$B$3:$D$500,2)),\"\",VLOOKUP(A44,цены!$B$3:$D$500,2,0))","v":"м.п."},null,null,{"$f":"_xlfn.CEILING.MATH(G44*H44/1000000,0.01)","v":{"$error":"#NAME?"}},690,1,null,{"$f":"IF(ISNA(VLOOKUP(A44,цены!$B$3:$D$500,3)),\"0\",VLOOKUP(A44,цены!$B$3:$D$500,3,0))","v":32},null,{"$f":"IF(F44=\"м2\",I44*K44,_xlfn.CEILING.MATH(J44*K44,500)/1000)*$S$27*M44*IF(E44=\"Материал\",1+VLOOKUP($T$27,цены!$J$3:$K$11,2,0),1)","v":{"$error":"#NAME?"}},null,{"$f":"IF(F44=\"м2\",G44*H44*K44/1000000,J44*K44/1000)","v":0.69},null,{"$f":"Q44*M44","v":22.08},null,{"$f":"IF(F44=\"м2\",_xlfn.CEILING.MATH(G44*H44*K44/1000000,0.1),_xlfn.CEILING.MATH(J44*K44,500)/1000)","v":{"$error":"#NAME?"}},null,{"$f":"IF(ISNA(VLOOKUP(A44,цены!$B$3:$E$500,4)),\"\",VLOOKUP(A44,цены!$B$3:$E$500,4,0)*Q44)","v":0.44159999999999999}]
[null,null,null,null,{"$f":"IF(ISNA(VLOOKUP(A45,цены!$B$3:$H$500,7)),\"\",VLOOKUP(A45,цены!$B$3:$H$500,7,0))","v":""},{"$f":"IF(ISNA(VLOOKUP(A45,цены!$B$3:$D$500,2)),\"\",VLOOKUP(A45,цены!$B$3:$D$500,2,0))","v":""},null,null,{"$f":"_xlfn.CEILING.MATH(G45*H45/1000000,0.01)","v":{"$error":"#NAME?"}},null,null,null,{"$f":"IF(ISNA(VLOOKUP(A45,цены!$B$3:$D$500,3)),\"0\",VLOOKUP(A45,цены!$B$3:$D$500,3,0))","v":"0"},null,{"$f":"IF(F45=\"м2\",I45*K45,_xlfn.CEILING.MATH(J45*K45,500)/1000)*$S$27*M45*IF(E45=\"Материал\",1+VLOOKUP($T$27,цены!$J$3:$K$11,2,0),1)","v":{"$error":"#NAME?"}},null,{"$f":"IF(F45=\"м2\",G45*H45*K45/1000000,J45*K45/1000)","v":0},null,{"$f":"Q45*M45","v":0},null,{"$f":"IF(F45=\"м2\",_xlfn.CEILING.MATH(G45*H45*K45/1000000,0.1),_xlfn.CEILING.MATH(J45*K45,500)/1000)","v":{"$error":"#NAME?"}},null,{"$f":"IF(ISNA(VLOOKUP(A45,цены!$B$3:$E$500,4)),\"\",VLOOKUP(A45,цены!$B$3:$E$500,4,0)*Q45)","v":""}]
[null,null,null,null,{"$f":"IF(ISNA(VLOOKUP(A46,цены!$B$3:$H$500,7)),\"\",VLOOKUP(A46,цены!$B$3:$H$500,7,0))","v":""},{"$f":"IF(ISNA(VLOOKUP(A46,цены!$B$3:$D$500,2)),\"\",VLOOKUP(A46,цены!$B$3:$D$500,2,0))","v":""},null,null,{"$f":"_xlfn.CEILING.MATH(G46*H46/1000000,0.01)","v":{"$error":"#NAME?"}},null,null,null,{"$f":"IF(ISNA(VLOOKUP(A46,цены!$B$3:$D$500,3)),\"0\",VLOOKUP(A46,цены!$B$3:$D$500,3,0))","v":"0"},null,{"$f":"IF(F46=\"м2\",I46*K46,_xlfn.CEILING.MATH(J46*K46,500)/1000)*$S$27*M46*IF(E46=\"Материал\",1+VLOOKUP($T$27,цены!$J$3:$K$11,2,0),1)","v":{"$error":"#NAME?"}},null,{"$f":"IF(F46=\"м2\",G46*H46*K46/1000000,J46*K46/1000)","v":0},null,{"$f":"Q46*M46","v":0},null,{"$f":"IF(F46=\"м2\",_xlfn.CEILING.MATH(G46*H46*K46/1000000,0.1),_xlfn.CEILING.MATH(J46*K46,500)/1000)","v":{"$error":"#NAME?"}},null,{"$f":"IF(ISNA(VLOOKUP(A46,цены!$B$3:$E$500,4)),\"\",VLOOKUP(A46,цены!$B$3:$E$500,4,0)*Q46)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(O44:P46)","v":{"$error":"#NAME?"}},null,null,null,{"$f":"SUM(S44:T46)","v":22.08},null,null,null,{"$f":"SUM(W44:W46)","v":0.44159999999999999}]
[]
["Артикул",null,null,"ЭтСп-0018"]
["Наименование"]
["Фото",null,null,null,null,null,null,null,"Описание",null,null,null,null,null,null,null,"Доставка материала",null,1.07,"ж",{"$f":"(T63-S71)/S71","v":{"$error":"#NAME?"}}]
[null,null,null,null,null,null,null,null,"Червонка с одинаковыми загибами, окончание гусиная и гладкая лапка. Длина заготовки 450 мм. Материал квадрат 10мм. Размер h*L 60*170мм.",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,{"$f":"_xlfn.CEILING.MATH(T63/(V52*Y52),1)","v":{"$error":"#NAME?"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Стоимость п.м. изделия",null,null,{"$f":"_xlfn.CEILING.MATH(T63/(S52*2+V52*2),1)","v":{"$error":"#NAME?"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Чистая прибыль",null,null,{"$f":"T63-T57-T59-T61-S71","v":{"$error":"#NAME?"}}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Заработная плата",null,null,{"$f":"(T63-_xlfn.CEILING.MATH(S71,50))*20%","v":{"$error":"#NAME?"}}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Расходники",null,null,{"$f":"(T63-_xlfn.CEILING.MATH(S71,50))*7%","v":{"$error":"#NAME?"}}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Аренда, электричество",null,null,{"$f":"(T63-_xlfn.CEILING.MATH(S71,50))*10%","v":{"$error":"#NAME?"}}]
[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,null,null,null,null,null,null,null,"ИТОГОВАЯ ЦЕНА",null,null,{"$f":"_xlfn.CEILING.MATH(O71,0.01)","v":{"$error":"#NAME?"}},null,null,{"$f":"T63*1.5","v":{"$error":"#NAME?"}}]
[]
["Калькуляция"]
["Наименование материала",null,null,null,"Статус","Ед. изм","Размер заготовки (мм)",null,null,"Размер заготовки (мм)","Количество заготовок (шт)",null,"Цена (руб/м.п.)",null,"Стоимость (руб)",null,"Количество материала факт(м.п.)",null,"Стоимость фактическая (руб)",null,"Количество материала (м.п.)",null,"Вес"]
["Расходный материал",null,null,"Описание",null,null,"Длина","Ширина","Площадь"]
["Квадрат 10*10",null,null,"Червонка",{"$f":"IF(ISNA(VLOOKUP(A68,цены!$B$3:$H$500,7)),\"\",VLOOKUP(A68,цены!$B$3:$H$500,7,0))","v":"Материал"},{"$f":"IF(ISNA(VLOOKUP(A68,цены!$B$3:$D$500,2)),\"\",VLOOKUP(A68,цены!$B$3:$D$500,2,0))","v":"м.п."},null,null,{"$f":"_xlfn.CEILING.MATH(G68*H68/1000000,0.01)","v":{"$error":"#NAME?"}},450,1,null,{"$f":"IF(ISNA(VLOOKUP(A68,цены!$B$3:$D$500,3)),\"0\",VLOOKUP(A68,цены!$B$3:$D$500,3,0))","v":34},null,{"$f":"IF(F68=\"м2\",I68*K68,_xlfn.CEILING.MATH(J68*K68,10)/1000)*$S$51*M68*IF(E68=\"Материал\",1+VLOOKUP($T$51,цены!$J$3:$K$11,2,0),1)","v":{"$error":"#NAME?"}},null,{"$f":"IF(F68=\"м2\",G68*H68*K68/1000000,J68*K68/1000)","v":0.45},null,{"$f":"Q68*M68","v":15.3},null,{"$f":"IF(F68=\"м2\",_xlfn.CEILING.MATH(G68*H68*K68/1000000,0.1),_xlfn.CEILING.MATH(J68*K68,500)/1000)","v":{"$error":"#NAME?"}},null,{"$f":"IF(ISNA(VLOOKUP(A68,цены!$B$3:$E$500,4)),\"\",VLOOKUP(A68,цены!$B$3:$E$500,4,0)*Q68)","v":0.35100000000000003}]
[null,null,null,null,{"$f":"IF(ISNA(VLOOKUP(A69,цены!$B$3:$H$500,7)),\"\",VLOOKUP(A69,цены!$B$3:$H$500,7,0))","v":""},{"$f":"IF(ISNA(VLOOKUP(A69,цены!$B$3:$D$500,2)),\"\",VLOOKUP(A69,цены!$B$3:$D$500,2,0))","v":""},null,null,{"$f":"_xlfn.CEILING.MATH(G69*H69/1000000,0.01)","v":{"$error":"#NAME?"}},null,null,null,{"$f":"IF(ISNA(VLOOKUP(A69,цены!$B$3:$D$500,3)),\"0\",VLOOKUP(A69,цены!$B$3:$D$500,3,0))","v":"0"},null,{"$f":"IF(F69=\"м2\",I69*K69,_xlfn.CEILING.MATH(J69*K69,10)/1000)*$S$51*M69*IF(E69=\"Материал\",1+VLOOKUP($T$51,цены!$J$3:$K$11,2,0),1)","v":{"$error":"#NAME?"}},null,{"$f":"IF(F69=\"м2\",G69*H69*K69/1000000,J69*K69/1000)","v":0},null,{"$f":"Q69*M69","v":0},null,{"$f":"IF(F69=\"м2\",_xlfn.CEILING.MATH(G69*H69*K69/1000000,0.1),_xlfn.CEILING.MATH(J69*K69,500)/1000)","v":{"$error":"#NAME?"}},null,{"$f":"IF(ISNA(VLOOKUP(A69,цены!$B$3:$E$500,4)),\"\",VLOOKUP(A69,цены!$B$3:$E$500,4,0)*Q69)","v":""}]
[null,null,null,null,{"$f":"IF(ISNA(VLOOKUP(A70,цены!$B$3:$H$500,7)),\"\",VLOOKUP(A70,цены!$B$3:$H$500,7,0))","v":""},{"$f":"IF(ISNA(VLOOKUP(A70,цены!$B$3:$D$500,2)),\"\",VLOOKUP(A70,цены!$B$3:$D$500,2,0))","v":""},null,null,{"$f":"_xlfn.CEILING.MATH(G70*H70/1000000,0.01)","v":{"$error":"#NAME?"}},null,null,null,{"$f":"IF(ISNA(VLOOKUP(A70,цены!$B$3:$D$500,3)),\"0\",VLOOKUP(A70,цены!$B$3:$D$500,3,0))","v":"0"},null,{"$f":"IF(F70=\"м2\",I70*K70,_xlfn.CEILING.MATH(J70*K70,10)/1000)*$S$51*M70*IF(E70=\"Материал\",1+VLOOKUP($T$51,цены!$J$3:$K$11,2,0),1)","v":{"$error":"#NAME?"}},null,{"$f":"IF(F70=\"м2\",G70*H70*K70/1000000,J70*K70/1000)","v":0},null,{"$f":"Q70*M70","v":0},null,{"$f":"IF(F70=\"м2\",_xlfn.CEILING.MATH(G70*H70*K70/1000000,0.1),_xlfn.CEILING.MATH(J70*K70,500)/1000)","v":{"$error":"#NAME?"}},null,{"$f":"IF(ISNA(VLOOKUP(A70,цены!$B$3:$E$500,4)),\"\",VLOOKUP(A70,цены!$B$3:$E$500,4,0)*Q70)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(O68:P70)","v":{"$error":"#NAME?"}},null,null,null,{"$f":"SUM(S68:T70)","v":15.3},null,null,null,{"$f":"SUM(W68:W70)","v":0.35100000000000003}]
[]
["Артикул",null,null,"ЭтСп-003"]
["Наименование"]
["Фото",null,null,null,null,null,null,null,"Описание",null,null,null,null,null,null,null,"Доставка материала",null,1.07,"в",{"$f":"(T87-S95)/S95","v":{"$error":"#NAME?"}}]
[null,null,null,null,null,null,null,null,"Дуга для вешала ширина основания 540 мм.",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,{"$f":"_xlfn.CEILING.MATH(T87/(V76*Y76),1)","v":{"$error":"#NAME?"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Стоимость п.м. изделия",null,null,{"$f":"_xlfn.CEILING.MATH(T87/(S76*2+V76*2),1)","v":{"$error":"#NAME?"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Чистая прибыль",null,null,{"$f":"T87-T81-T83-T85-S95","v":{"$error":"#NAME?"}}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Заработная плата",null,null,{"$f":"(T87-_xlfn.CEILING.MATH(S95,5))*20%","v":{"$error":"#NAME?"}}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Расходники",null,null,{"$f":"(T87-_xlfn.CEILING.MATH(S95,5))*7%","v":{"$error":"#NAME?"}}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Аренда, электричество",null,null,{"$f":"(T87-_xlfn.CEILING.MATH(S95,5))*10%","v":{"$error":"#NAME?"}}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ИТОГОВАЯ ЦЕНА",null,null,{"$f":"_xlfn.CEILING.MATH(O95,5)","v":{"$error":"#NAME?"}}]
[]
["Калькуляция"]
["Наименование материала",null,null,null,"Статус","Ед. изм","Размер заготовки (мм)",null,null,"Размер заготовки (мм)","Количество заготовок (шт)",null,"Цена (руб/м.п.)",null,"Стоимость (руб)",null,"Количество материала факт(м.п.)",null,"Стоимость фактическая (руб)",null,"Количество материала (м.п.)",null,"Вес"]
["Расходный материал",null,null,"Описание",null,null,"Длина","Ширина","Площадь"]
["Профильная  труба20*20*1,5",null,null,null,{"$f":"IF(ISNA(VLOOKUP(A92,цены!$B$3:$H$500,7)),\"\",VLOOKUP(A92,цены!$B$3:$H$500,7,0))","v":"Материал"},{"$f":"IF(ISNA(VLOOKUP(A92,цены!$B$3:$D$500,2)),\"\",VLOOKUP(A92,цены!$B$3:$D$500,2,0))","v":"м.п."},null,null,{"$f":"_xlfn.CEILING.MATH(G92*H92/1000000,0.01)","v":{"$error":"#NAME?"}},900,1,null,{"$f":"IF(ISNA(VLOOKUP(A92,цены!$B$3:$D$500,3)),\"0\",VLOOKUP(A92,цены!$B$3:$D$500,3,0))","v":41},null,{"$f":"IF(F92=\"м2\",I92*K92,_xlfn.CEILING.MATH(J92*K92,500)/1000)*$S75*M92*IF(E92=\"Материал\",1+VLOOKUP($T$75,цены!$J$3:$K$11,2,0),1)","v":{"$error":"#NAME?"}},null,{"$f":"IF(F92=\"м2\",G92*H92*K92/1000000,J92*K92/1000)","v":0.9},null,{"$f":"Q92*M92","v":36.9},null,{"$f":"IF(F92=\"м2\",_xlfn.CEILING.MATH(G92*H92*K92/1000000,0.1),_xlfn.CEILING.MATH(J92*K92,500)/1000)","v":{"$error":"#NAME?"}},null,{"$f":"IF(ISNA(VLOOKUP(A92,цены!$B$3:$E$500,4)),\"\",VLOOKUP(A92,цены!$B$3:$E$500,4,0)*Q92)","v":0.78300000000000003}]
[null,null,null,null,{"$f":"IF(ISNA(VLOOKUP(A93,цены!$B$3:$H$500,7)),\"\",VLOOKUP(A93,цены!$B$3:$H$500,7,0))","v":""},{"$f":"IF(ISNA(VLOOKUP(A93,цены!$B$3:$D$500,2)),\"\",VLOOKUP(A93,цены!$B$3:$D$500,2,0))","v":""},null,null,{"$f":"_xlfn.CEILING.MATH(G93*H93/1000000,0.01)","v":{"$error":"#NAME?"}},null,null,null,{"$f":"IF(ISNA(VLOOKUP(A93,цены!$B$3:$D$500,3)),\"0\",VLOOKUP(A93,цены!$B$3:$D$500,3,0))","v":"0"},null,{"$f":"IF(F93=\"м2\",I93*K93,_xlfn.CEILING.MATH(J93*K93,500)/1000)*$S76*M93*IF(E93=\"Материал\",1+VLOOKUP($T$75,цены!$J$3:$K$11,2,0),1)","v":{"$error":"#NAME?"}},null,{"$f":"IF(F93=\"м2\",G93*H93*K93/1000000,J93*K93/1000)","v":0},null,{"$f":"Q93*M93","v":0},null,{"$f":"IF(F93=\"м2\",_xlfn.CEILING.MATH(G93*H93*K93/1000000,0.1),_xlfn.CEILING.MATH(J93*K93,500)/1000)","v":{"$error":"#NAME?"}},null,{"$f":"IF(ISNA(VLOOKUP(A93,цены!$B$3:$E$500,4)),\"\",VLOOKUP(A93,цены!$B$3:$E$500,4,0)*Q93)","v":""}]
[null,null,null,null,{"$f":"IF(ISNA(VLOOKUP(A94,цены!$B$3:$H$500,7)),\"\",VLOOKUP(A94,цены!$B$3:$H$500,7,0))","v":""},{"$f":"IF(ISNA(VLOOKUP(A94,цены!$B$3:$D$500,2)),\"\",VLOOKUP(A94,цены!$B$3:$D$500,2,0))","v":""},null,null,{"$f":"_xlfn.CEILING.MATH(G94*H94/1000000,0.01)","v":{"$error":"#NAME?"}},null,null,null,{"$f":"IF(ISNA(VLOOKUP(A94,цены!$B$3:$D$500,3)),\"0\",VLOOKUP(A94,цены!$B$3:$D$500,3,0))","v":"0"},null,{"$f":"IF(F94=\"м2\",I94*K94,_xlfn.CEILING.MATH(J94*K94,500)/1000)*$S77*M94*IF(E94=\"Материал\",1+VLOOKUP($T$75,цены!$J$3:$K$11,2,0),1)","v":{"$error":"#NAME?"}},null,{"$f":"IF(F94=\"м2\",G94*H94*K94/1000000,J94*K94/1000)","v":0},null,{"$f":"Q94*M94","v":0},null,{"$f":"IF(F94=\"м2\",_xlfn.CEILING.MATH(G94*H94*K94/1000000,0.1),_xlfn.CEILING.MATH(J94*K94,500)/1000)","v":{"$error":"#NAME?"}},null,{"$f":"IF(ISNA(VLOOKUP(A94,цены!$B$3:$E$500,4)),\"\",VLOOKUP(A94,цены!$B$3:$E$500,4,0)*Q94)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(O92:P94)","v":{"$error":"#NAME?"}},null,null,null,{"$f":"SUM(S92:T94)","v":36.9},null,null,null,{"$f":"SUM(W92:W94)","v":0.78300000000000003}]

{"sheet":"цены","index":3,"n_rows":192,"n_cols":12,"rows_kept":192,"cut":false,"hidden":false,"merged":[[0,5,0,6],[0,9,0,10],[7,11,7,14],[8,11,8,14]]}
[null,null,null,null,null,"Наценка на металл",null,null,null,"Наценка на металл"]
[null,"Расходный материал","Ед.изм.","Цена","Вес (м.п.)","Ставка","Литера","Статус",null,"Ставка","Литера"]
[null,"Арматура 10 мм","м.п.",19,null,null,null,"Материал",null,"А",1]
[null,"Арматура 14 мм","м.п.",36,null,null,null,"Материал",null,"Б",1.5]
[null,"Арматура 16 мм","м.п.",46,null,null,null,"Материал",null,"В",2]
[null,"Квадрат 6*6","м.п.",29,0.28000000000000003,1,"А","Материал",null,"Г",2.5]
[null,"Квадрат 8*8","м.п.",36,0.5,1.5,"Б","Материал",null,"Д",3]
[null,"Квадрат 10*10","м.п.",34,0.78,2,"В","Материал",null,"Е",1.25,"Для элементов без лапки"]
[null,"Квадрат 12*12","м.п.",52,1.1299999999999999,2.5,"Г","Материал",null,"Ж",1.75,"Для элементов с лапкой и сварных"]
[null,"Квадрат 14*14","м.п.",62,1.54,3,"Д","Материал",null,"З",2.25]
[null,"Квадрат 16*16","м.п.",74,2.0099999999999998,null,null,"Материал",null,"И",2.75]
[null,"Квадрат 18*18","м.п.",null,2.54,null,null,"Материал",null,"К",0]
[null,"Квадрат 20*20","м.п.",null,3.14,null,null,"Материал",null,"Л",0.5]
[null,"Квадрат 22*22","м.п.",null,null,null,null,"Материал",null,"М",0.75]
[null,"Квадрат 25*25","м.п.",null,null,null,null,"Материал"]
[null,"Круг  6,5 мм","м.п.",9.5,0.26,null,null,"Материал"]
[null,"Круг  8 мм","м.п.",17,0.39,null,null,"Материал"]
[null,"Круг  10 мм","м.п.",25,0.62,null,null,"Материал"]
[null,"Круг  12 мм","м.п.",34,0.89,null,null,"Материал"]
[null,"Круг  14 мм","м.п.",49,1.21,null,null,"Материал"]
[null,"Круг  16 мм","м.п.",63,1.58,null,null,"Материал"]
[null,"Круг  18 мм","м.п.",null,2,null,null,"Материал"]
[null,"Круг  20 мм","м.п.",90,2.46,null,null,"Материал"]
[null,"Круг  22 мм","м.п.",null,null,null,null,"Материал"]
[null,"Круг  25 мм","м.п.",120,3.83,null,null,"Материал"]
[null,"Круг  26 мм","м.п.",null,null,null,null,"Материал"]
[null,"Круг  30 мм","м.п.",191,5.51,null,null,"Материал"]
[null,"Круг  36 мм","м.п.",273,7.94,null,null,"Материал"]
[null,"Лист 0,5 х.к","м2",null,null,null,null,"Материал"]
[null,"Лист 0,7 х.к","м2",null,null,null,null,"Материал"]
[null,"Лист 1,0 х.к","м2",null,7.85,null,null,"Материал"]
[null,"Лист 1,2 х.к","м2",null,null,null,null,"Материал"]
[null,"Лист 1,5 х.к","м2",512,11.77,null,null,"Материал"]
[null,"Лист 1,8 г.к","м2",null,null,null,null,"Материал"]
[null,"Лист 2,0 г.к","м2",448,15.7,null,null,"Материал"]
[null,"Лист 2,0 х.к","м2",null,null,null,null,"Материал"]
[null,"Лист 3,0 г.к","м2",816,23.55,null,null,"Материал"]
[null,"Лист 3,0 рифленый","м2",null,null,null,null,"Материал"]
[null,"Полоса обжимная","м.п.",60,null,null,null,"Материал"]
[null,"Полоса 20*4","м.п.",null,null,null,null,"Материал"]
[null,"Полоса 20*5","м.п.",null,null,null,null,"Материал"]
[null,"Полоса 25*4","м.п.",34,0.79,null,null,"Материал"]
[null,"Полоса 40*4","м.п.",54,1.26,null,null,"Материал"]
[null,"Полоса 40*5","м.п.",null,null,null,null,"Материал"]
[null,"Полоса 50*5","м.п.",87,1.95,null,null,"Материал"]
[null,"Профильная  труба10*10*1,2","м.п.",null,null,null,null,"Материал"]
[null,"Профильная  труба15*15*1,5","м.п.",32,0.64,null,null,"Материал"]
[null,"Профильная  труба20*20*1,2","м.п.",null,null,null,null,"Материал"]
[null,"Профильная  труба20*20*1,5","м.п.",41,0.87,null,null,"Материал"]
[null,"Профильная  труба20*20*2,0","м.п.",52,1.1200000000000001,null,null,"Материал"]
[null,"Профильная  труба25*25*1,5","м.п.",54,1.1000000000000001,null,null,"Материал"]
[null,"Профильная  труба25*25*2,0","м.п.",62,1.44,null,null,"Материал"]
[null,"Профильная  труба30*20*1,5","м.п.",47,1.1000000000000001,null,null,"Материал"]
[null,"Профильная  труба30*20*2,0","м.п.",54,1.44,null,null,"Материал"]
[null,"Профильная  труба30*30*1,5","м.п.",60,1.33,null,null,"Материал"]
[null,"Профильная  труба30*30*2,0","м.п.",78,1.75,null,null,"Материал"]
[null,"Профильная  труба40*20*1,5","м.п.",60,1.34,null,null,"Материал"]
[null,"Профильная  труба40*20*2,0","м.п.",74,1.75,null,null,"Материал"]
[null,"Профильная  труба40*25*2","м.п.",79,1.9,null,null,"Материал"]
[null,"Профильная  труба40*40*1,5","м.п.",79,1.8,null,null,"Материал"]
[null,"Профильная  труба40*40*2,0","м.п.",97,2.39,null,null,"Материал"]
[null,"Профильная  труба40*40*3,0","м.п.",117,3.49,null,null,"Материал"]
[null,"Профильная  труба50*25*1,5","м.п.",82,1.68,null,null,"Материал"]
[null,"Профильная  труба50*25*2,0","м.п.",93,2.2200000000000002,null,null,"Материал"]
[null,"Профильная  труба50*50*2,0","м.п.",null,null,null,null,"Материал"]
[null,"Профильная  труба60*40*2,0","м.п.",null,null,null,null,"Материал"]
[null,"Профильная  труба60*60*2,0","м.п.",null,null,null,null,"Материал"]
[null,"Профильная  труба80*40*2,0","м.п.",null,null,null,null,"Материал"]
[null,"Профильная  труба80*80*2,0","м.п.",null,null,null,null,"Материал"]
[null,"Профильная  труба100*100*3,0","м.п.",null,null,null,null,"Материал"]
[null,"Труба 10*1,0","м.п.",null,null,null,null,"Материал"]
[null,"Труба 12*1,0","м.п.",null,null,null,null,"Материал"]
[null,"Труба 14*1,0","м.п.",null,null,null,null,"Материал"]
[null,"Труба 14*1,0","м.п.",null,null,null,null,"Материал"]
[null,"Труба 16*1,0","м.п.",null,null,null,null,"Материал"]
[null,"Труба 18*1,0","м.п.",null,null,null,null,"Материал"]
[null,"Труба 20*1,0","м.п.",null,null,null,null,"Материал"]
[null,"Труба 20*2,5","м.п.",65,1.08,null,null,"Материал"]
[null,"Труба 25*2,8","м.п.",100,1.53,null,null,"Материал"]
[null,"Труба 32*4,0","м.п.",153,2.76,null,null,"Материал"]
[null,"Труба 40*4,0","м.п.",176,3.55,null,null,"Материал"]
[null,"Труба 50*3,0","м.п.",null,null,null,null,"Материал"]
[null,"Труба 57*3,5","м.п.",188,4.62,null,null,"Материал"]
[null,"Труба 76*3,5","м.п.",265,6.26,null,null,"Материал"]
[null,"Труба 76*6,0","м.п.",590,10.36,null,null,"Материал"]
[null,"Труба 89*3,5","м.п.",300,7.38,null,null,"Материал"]
[null,"Уголок 25*3","м.п.",42,1.1100000000000001,null,null,"Материал"]
[null,"Уголок 25*4","м.п.",57,1.44,null,null,"Материал"]
[null,"Уголок 32*4","м.п.",65,1.88,null,null,"Материал"]
[null,"Уголок 35*4","м.п.",63,2.06,null,null,"Материал"]
[null,"Уголок 40*4","м.п.",67,2.37,null,null,"Материал"]
[null,"Уголок 45*4","м.п.",90,2.7,null,null,"Материал"]
[null,"Уголок 50*4","м.п.",92,3,null,null,"Материал"]
[null,"Уголок 50*5","м.п.",110,3.73,null,null,"Материал"]
[null,"Уголок 63*5","м.п.",153,4.75,null,null,"Материал"]
[null,"Швеллер 5","м.п.",188,null,null,null,"Материал"]
[null,"Швеллер 6,5","м.п.",220,null,null,null,"Материал"]
[null,"Швеллер 8","м.п.",220,null,null,null,"Материал"]
[null,"Швеллер 10","м.п.",250,null,null,null,"Материал"]
[null,"Швеллер 12","м.п.",310,null,null,null,"Материал"]
[null,"Швеллер 14","м.п.",400,null,null,null,"Материал"]
[null,"Швеллер 16","м.п.",445,null,null,null,"Материал"]
[null,"Швеллер 18","м.п.",490,null,null,null,"Материал"]
[null,"Швеллер 20","м.п.",570,null,null,null,"Материал"]
[null,"Покраска (грунт ГФ-021)","м2",200,null,null,null,"Услуга"]
[null,"Покраска (эмаль ПФ-115)","м2",300,null,null,null,"Услуга"]
[null,"Доска для лавки 70х30","м.п.",60,null,null,null,"Материал"]
[null,"Доска для лавки 90х30","м.п.",85,null,null,null,"Материал"]
[null,"Покраска (эмаль НЦ-115)","м2",300,null,null,null,"Услуга"]
[null,"Офактуровка \"Витая труба\" d>42 мм ","м.п.",110,null,null,null,"Услуга"]
[null,"Офактуровка \"Витая труба\" d 42>57 мм ","м.п.",120,null,null,null,"Услуга"]
[null,"Офактуровка \"Витая труба\" d 57>89 мм ","м.п.",130,null,null,null,"Услуга"]
[null,"Офактуровка \"Витая труба\" d 89>109 мм ","м.п.",140,null,null,null,"Услуга"]
[null,"Офактуровка \"Витая труба\" d 109>150 мм ","м.п.",150,null,null,null,"Услуга"]
[null,"Офактуровка полосы 40*4 мм","м.п.",60,null,null,null,"Услуга"]
[null,"Офактуровка Профильная труба 20*20 мм","м.п.",55,null,null,null,"Услуга"]
[null,"Офактуровка Профильная труба 25*25 мм","м.п.",55,null,null,null,"Услуга"]
[null,"Офактуровка Профильная труба 40*20 мм","м.п.",55,null,null,null,"Услуга"]
[null,"Офактуровка Профильная труба 40*40 мм","м.п.",55,null,null,null,"Услуга"]
[null,"Лист 19-1003","шт.",14.7,null,null,null,"Услуга"]
[null,"Лист 19-1005","шт.",19.309999999999999,null,null,null,"Услуга"]
[null,"Лист 19-1015","шт.",19.309999999999999,null,null,null,"Услуга"]
[null,"Лист 19-1061","шт.",33.04,null,null,null,"Услуга"]
[null,"Балясина 10122","шт.",341.74,1.03,null,null,"Услуга"]
[null,"Подпятник литой, отв. 40 мм 19486-40/80","шт.",91,0.245,null,null,"Услуга"]
[null,"Наконечник 18263","шт.",154,0.56999999999999995,null,null,"Услуга"]
[null,"Покраска \"КК\" черная акриловая","м2",1300,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,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,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,"Услуга"]
[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,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,"м.п.",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,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,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,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,"Услуга"]
[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,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,"м.п.",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,null,null,null,"Услуга"]
[null,null,"м.п.",null,null,null,null,"Услуга"]
[null,null,"м.п.",null,null,null,null,"Услуга"]
[null,null,"м.п.",null,null,null,null,"Услуга"]