{"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":177,"n_cols":42,"rows_kept":177,"cut":false,"hidden":false,"merged":[[32,11,32,12],[32,14,32,15],[32,20,32,21],[32,17,32,18],[67,11,67,12],[67,14,67,15],[67,17,67,18],[67,20,67,21]]}
[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,null,null,"z","z","z","z","z","z","z","z","z","z","z"]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(J9:J14=0,\"тревога\",\"всё ок\")","v":{"$error":"#VALUE!"}}]
[]
[]
[null,null,null,null,null,null,null,null,null,"Коэфициент ","Маса "]
["См. Косые резы и выполнять согласно чертежа",null,null,null,null,null,"План / шт",10,null,null,{"$f":"U174-AB172","v":{"$error":"#VALUE!"}}]
["№ п/п","длина ","ширина условная расчет программы","кол-во на изделие","материал профиль трубы","тол-на","План","кол-во на план",null,{"$f":"SUM(H9:H31)","v":700},{"$f":"SUM(K9:K31)","v":91.209579999999988}]
[{"$f":"IF(H9=0,\"z\",Q9)","v":1},589,500,2,"Труба 20х20 чм, 1.5 мм",{"$f":"IFERROR(VLOOKUP(E9,$AI$70:$AK$174,2,0),\"\")","v":1.5},{"$f":"H7","v":10},{"$f":"D9*G9","v":20},null,{"$f":"IFERROR(VLOOKUP(E9,$AI$70:$AK$174,3,0),0)","v":1.8720000000000001},{"$f":"B9*C9*H9*J9/1000000-L9","v":11.02608},0,null,null,null,null,{"$f":"IF(H9=0,0,1)","v":1}]
[{"$f":"IF(H10=0,\"z\",Q10)","v":2},12,500,3,"Труба 20 чм, 1.0 мм",{"$f":"IFERROR(VLOOKUP(E10,$AI$70:$AK$174,2,0),\"\")","v":1},{"$f":"H7","v":10},{"$f":"D10*G10","v":30},null,0.98,{"$f":"B10*C10*H10*J10/1000000","v":0.1764},0.78500000000000003,null,null,null,null,{"$f":"IF(H10=0,Q9,Q9+1)","v":2}]
[3,54,500,5,"Труба 30х50 чм, 2.0 мм",2,{"$f":"H7","v":10},50,null,4.8899999999999997,6.6014999999999997,null,null,null,null,null,{"$f":"IF(H11=0,Q10,Q10+1)","v":3}]
[4,87,500,8,"Труба 20 чм, 1.0 мм",1,{"$f":"H7","v":10},80,null,0.98,3.4104000000000001,null,null,null,null,null,{"$f":"IF(H12=0,Q11,Q11+1)","v":4}]
[5,848,500,8,"Труба 20 чм, 1.0 мм",1,{"$f":"H7","v":10},80,null,0.98,33.241599999999998,null,null,null,null,null,5]
[6,589,500,10,"Труба 20х20 чм, 1.0 мм",1,{"$f":"H7","v":10},100,null,1.248,36.753599999999999,null,null,null,null,null,6]
[7,32,500,34,null,"",{"$f":"H7","v":10},340,null,0,0,null,null,null,null,null,7]
["z",null,500,null,null,"",{"$f":"H7","v":10},0,null,0,0,null,null,null,null,null,7]
["z",null,500,null,null,"",{"$f":"H7","v":10},0,null,0,0,null,null,null,null,null,7]
["z",null,500,null,null,"",{"$f":"H7","v":10},0,null,0,0,null,null,null,null,null,7]
["z",null,500,null,null,"",{"$f":"H7","v":10},0,null,0,0,null,null,null,null,null,7]
["z",null,500,null,null,"",{"$f":"H7","v":10},0,null,0,0,null,null,null,null,null,7]
["z",null,500,null,null,"",{"$f":"H7","v":10},0,null,0,0,null,null,null,null,null,7]
["z",null,500,null,null,"",{"$f":"H7","v":10},0,null,0,0,null,null,null,null,null,7]
["z",null,500,null,null,"",{"$f":"H7","v":10},0,null,0,0,null,null,null,null,null,7]
["z",null,500,null,null,"",{"$f":"H7","v":10},0,null,0,0,null,null,null,null,null,7]
["z",null,500,null,null,"",{"$f":"H7","v":10},0,null,0,0,null,null,null,null,null,7]
["z",null,500,null,null,"",{"$f":"H7","v":10},0,null,0,0,null,null,null,null,null,7]
["z",null,500,null,null,"",{"$f":"H7","v":10},0,null,0,0,null,null,null,null,null,7]
["z",null,500,null,null,"",{"$f":"H7","v":10},0,null,0,0,null,null,null,null,null,7]
["z",null,500,null,null,"",{"$f":"H7","v":10},0,null,0,0,null,null,null,null,null,7]
["z",null,500,null,null,"",{"$f":"H7","v":10},0,null,0,0,null,null,null,null,null,7]
["z",null,500,null,null,"",{"$f":"H7","v":10},0,null,0,0,null,null,null,null,null,7]
[]
["Карта рас-кроя №","Длина, мм","Ширина, мм","Толщина, мм","Марка материала","Кол-во","Площадь остатков всего, кв.м","Площадь деталей всего, кв.м","Количество деталей",null,"Коэфициент ","Трубы/остатка со склада масса (кг)",null,"Получил","Деловой остаток на склад (кг)",null,"Получил кла-довщик","ЛОМ общий (кг)",null,"Получил кладовщик","Масса деталей (кг)",null,"Количество деталей","Получил","Расход (кг)","ЛОМ (кг)"]
[null,null,null,null,null,null,null,null,null,null,null,"теория","факт",null,"теория","факт",null,"теория","факт",null,"теория","факт"]
[1,6000,500,1,"Труба 30х20 чм, 1.0 мм",5,0.65495000000000003,0.54800000000000004,5,null,{"$f":"IFERROR(VLOOKUP(E35,$AI$70:$AK$174,3,0),0)","v":1.5720000000000001},{"$f":"B35*C35*F35*K35/1000000","v":23.58},null,null,{"$f":"G35*K35","v":1.0295814000000001},null,null,{"$f":"Y35-U35","v":21.688962599999996},null,null,{"$f":"H35*K35","v":0.86145600000000011},null,null,null,{"$f":"L35-O35","v":22.550418599999997},{"$f":"Y35-U35","v":21.688962599999996}]
[2,5645,500,1,"Труба 30х20 чм, 1.0 мм",2,0.95809999999999995,0.55000000000000004,2,null,{"$f":"IFERROR(VLOOKUP(E36,$AI$70:$AK$174,3,0),0)","v":1.5720000000000001},8.8739399999999993,null,null,1.5061332000000001,null,null,{"$f":"Y36-U36","v":6.5032067999999992},null,null,{"$f":"H36*K36","v":0.86460000000000015},null,null,null,{"$f":"L36-O36","v":7.3678067999999994},{"$f":"Y36-U36","v":6.5032067999999992}]
[3,5622,500,1.5,"Труба 40х20 чм, 1.5 мм",10,0.95409999999999995,0.25800000000000001,3,null,2.88,80.956800000000001,null,null,2.7478079999999996,null,null,null,null,null,0.74304000000000003,null,null,null,78.208991999999995,77.465952000000001]
[4,6000,500,1.5,"Труба 40х20 чм, 1.5 мм",10,0.95409999999999995,0.25800000000000001,3,null,2.88,86.4,null,null,2.7478079999999996,null,null,null,null,null,0.74304000000000003,null,null,null,83.652191999999999,82.909152000000006]
["z",null,null,null,null,null,null,null,null,null,0,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,0,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,0,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,0,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,0,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,0,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,0,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,0,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,0,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,0,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,0,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,0,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,0,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,0,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,0,0,null,null,0,null,null,null,null,null,0,null,null,null,{"$f":"L53-O53","v":0},0]
["z",null,null,null,null,null,null,null,null,null,0,0,null,null,0,null,null,null,null,null,0,null,null,null,{"$f":"L54-O54","v":0},0]
["z",null,null,null,null,null,null,null,null,null,0,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,0,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,0,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,0,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,0,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,0,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,0,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,0,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,0,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,0,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,0,0,null,null,0,null,null,null,null,null,0,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L35:L65)","v":199.81074000000001},null,null,{"$f":"SUM(O35:O65)","v":8.0313305999999987},null,null,null,null,null,{"$f":"SUM(U35:U65)","v":3.2121360000000005},null,null,null,{"$f":"SUM(Y35:Y65)","v":191.77940939999999},{"$f":"SUM(Z35:Z65)","v":188.5672734}]
[]
[null,null,null,null,null,null,null,"Кол-во труб чм ","Трубы по толщине",null,null,"Трубы/остатка со склада масса (кг)",null,"Получил","Деловой остаток на склад (кг)",null,"Получил кладовщик","ЛОМ (кг)",null,"Получил кладовщик","масса деталей (кг)",null,"Количество","Получил","Расход (кг)",null,"ЛОМ (кг) дубль","отход на порезку","лом чистый",null,null,null,null,"народное название","название в \nАСТРА","толщина\nмм ","масса 2м\n(коэф)",null,"длина трубы\nмм","не равно","толщина реза\nмм"]
[null,null,null,null,null,null,null,null,null,null,null,"теория","факт",null,"теория","факт",null,"теория","факт",null,"теория","факт",null,null,null,null,null,null,null,null,null,null,null,null,"Столбец1"]
[{"$f":"IF(U72=0,\"z\",\" \")","v":"z"},null,null,null,null,"Труба 25х25 чм, 0.8 мм",null,{"$f":"SUMIFS(F35:F65,C35:C65,\"=500\",B35:B65,\"=6000\",D35:D65,\"=0,8\",E35:E65,\"=Труба 25х25 чм, 0.8 мм\")","v":0},0.8,null,1.2383999999999999,{"$f":"SUMIFS(L35:L65,B35:B65,\"=6000\",C35:C65,\"=500\",D35:D65,\"=0,8\",E35:E65,\"=Труба 25х25 чм, 0.8 мм\")","v":0},null,null,{"$f":"SUMIFS(O35:O65,B35:B65,\"=6000\",C35:C65,\"=500\",D35:D65,\"=0,8\",E35:E65,\"=Труба 25х25 чм, 0.8 мм\")","v":0},null,null,{"$f":"AC70+AC71-AB70","v":0},null,null,{"$f":"SUMIFS(U35:U65,B35:B65,\"=6000\",C35:C65,\"=500\",D35:D65,\"=0,8\",E35:E65,\"=Труба 25х25 чм, 0.8 мм\")","v":0},null,null,null,{"$f":"SUMIFS(Y35:Y65,B35:B65,\"=6000\",C35:C65,\"=500\",D35:D65,\"=0,8\",E35:E65,\"=Труба 25х25 чм, 0.8 мм\")","v":0},null,{"$f":"AC70+AC71-AB70","v":0},{"$f":"AG76*0.005*AL76","v":0},{"$f":"SUMIFS(Z35:Z65,B35:B65,\"=6000\",C35:C65,\"=500\",D35:D65,\"=0,8\",E35:E65,\"=Труба 25х25 чм, 0.8 мм\")","v":0},null,null,null,{"$f":"SUMIFS($H$9:$H$31,$E$9:$E$31,AI70)","v":0},"Труба ø 16х1",null,1,0.74,0.37,6000,{"$f":"CONCATENATE(\"<>\",AM70)","v":"<>6000"},5]
[{"$f":"IF(U72=0,\"z\",\" \")","v":"z"},null,null,null,null,null,"Остатки",null,null,null,null,{"$f":"SUMIFS(L35:L65,B35:B65,\"<>6000\",C35:C65,\"=500\",D35:D65,\"=0,8\",E35:E65,\"=Труба 25х25 чм, 0.8 мм\")","v":0},null,null,{"$f":"SUMIFS(O35:O65,B35:B65,\"<>6000\",C35:C65,\"=500\",D35:D65,\"=0,8\",E35:E65,\"=Труба 25х25 чм, 0.8 мм\")","v":0},null,null,null,null,null,{"$f":"SUMIFS(U35:U65,B35:B65,\"<>6000\",C35:C65,\"=500\",D35:D65,\"=0,8\",E35:E65,\"=Труба 25х25 чм, 0.8 мм\")","v":0},null,null,null,{"$f":"SUMIFS(Y35:Y65,B35:B65,\"<>6000\",C35:C65,\"=500\",D35:D65,\"=0,8\",E35:E65,\"=Труба 25х25 чм, 0.8 мм\")","v":0},null,null,null,{"$f":"SUMIFS(Z35:Z65,B35:B65,\"<>6000\",C35:C65,\"=500\",D35:D65,\"=0,8\",E35:E65,\"=Труба 25х25 чм, 0.8 мм\")","v":0}]
[{"$f":"IF(U72=0,\"z\",\" \")","v":"z"},null,null,null,null,null,"общая",null,null,null,null,{"$f":"L70+L71","v":0},null,null,{"$f":"O70+O71","v":0},null,null,{"$f":"R70","v":0},null,null,{"$f":"U70+U71+AB70","v":0},null,null,null,{"$f":"Y70+Y71","v":0}]
[{"$f":"IF(U75=0,\"z\",\" \")","v":" "},null,null,null,null,{"$f":"AI73","v":"Труба 20х20 чм, 1.0 мм"},null,{"$f":"SUMIFS($F$35:$F$65,$C$35:$C$65,\"=500\",$B$35:$B$65,AM59,$D$35:$D$65,AJ73,$E$35:$E$65,AI73)","v":0},{"$f":"AJ73","v":1},null,{"$f":"AK73","v":1.248},{"$f":"SUMIFS($L$35:$L$65,$B$35:$B$65,AM73,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ73,$E$35:$E$65,AI73)","v":0},null,null,{"$f":"SUMIFS($O$35:$O$65,$B$35:$B$65,AM73,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ73,$E$35:$E$65,AI73)","v":0},null,null,{"$f":"AC73+AC74-AB73","v":-0.312},null,null,{"$f":"SUMIFS($U$35:$U$65,$B$35:$B$65,AM73,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ73,$E$35:$E$65,AI73)","v":0},null,null,null,{"$f":"SUMIFS($Y$35:$Y$65,$B$35:$B$65,AM73,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ73,$E$35:$E$65,AI73)","v":0},null,{"$f":"AC73+AC74-AB73","v":-0.312},{"$f":"AG73*AO73/1000/2*AK73","v":0.312},{"$f":"SUMIFS($Z$35:$Z$65,$B$35:$B$65,AM73,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ73,$E$35:$E$65,AI73)","v":0},null,null,null,{"$f":"SUMIFS($H$9:$H$31,$E$9:$E$31,AI73)","v":100},"Труба 20х20 чм, 1.0 мм","Труба 20х20 чм, 1.0 мм",1,1.248,0.624,6000,"<>6000",5]
[{"$f":"IF(U75=0,\"z\",\" \")","v":" "},null,null,null,null,null,"Остатки",null,null,null,null,{"$f":"SUMIFS($L$35:$L$65,$B$35:$B$65,AN73,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ73,$E$35:$E$65,AI73)","v":0},null,null,{"$f":"SUMIFS($O$35:$O$65,$B$35:$B$65,AN73,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ73,$E$35:$E$65,AI73)","v":0},null,null,null,null,null,{"$f":"SUMIFS($U$35:$U$65,$B$35:$B$65,AN73,C23:C53,\"=500\",$D$35:$D$65,AJ73,$E$35:$E$65,AI73)","v":0},null,null,null,{"$f":"SUMIFS($Y$35:$Y$65,$B$35:$B$65,AN73,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ73,$E$35:$E$65,AI73)","v":0},null,null,null,{"$f":"SUMIFS($Z$35:$Z$65,$B$35:$B$65,AN73,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ73,$E$35:$E$65,AI73)","v":0}]
[{"$f":"IF(U75=0,\"z\",\" \")","v":" "},null,null,null,null,null,"общая",null,null,null,null,{"$f":"L73+L74","v":0},null,null,{"$f":"O73+O74","v":0},null,null,{"$f":"R73","v":-0.312},null,null,{"$f":"U73+U74+AB73","v":0.312},null,null,null,{"$f":"Y73+Y74","v":0}]
[{"$f":"IF(U78=0,\"z\",\" \")","v":"z"},null,null,null,null,{"$f":"AI76","v":"Труба 25х25 чм, 0.8 мм"},null,{"$f":"SUMIFS($F$35:$F$65,$C$35:$C$65,\"=500\",$B$35:$B$65,AM62,$D$35:$D$65,AJ76,$E$35:$E$65,AI76)","v":0},{"$f":"AJ76","v":0.8},null,{"$f":"AK76","v":1.2383999999999999},{"$f":"SUMIFS($L$35:$L$65,$B$35:$B$65,AM76,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ76,$E$35:$E$65,AI76)","v":0},null,null,{"$f":"SUMIFS($O$35:$O$65,$B$35:$B$65,AM76,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ76,$E$35:$E$65,AI76)","v":0},null,null,{"$f":"AC76+AC77-AB76","v":0},null,null,{"$f":"SUMIFS($U$35:$U$65,$B$35:$B$65,AM76,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ76,$E$35:$E$65,AI76)","v":0},null,null,null,{"$f":"SUMIFS($Y$35:$Y$65,$B$35:$B$65,AM76,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ76,$E$35:$E$65,AI76)","v":0},null,{"$f":"AC76+AC77-AB76","v":0},{"$f":"AG76*AO76/1000/2*AK76","v":0},{"$f":"SUMIFS($Z$35:$Z$65,$B$35:$B$65,AM76,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ76,$E$35:$E$65,AI76)","v":0},null,null,null,{"$f":"SUMIFS($H$9:$H$31,$E$9:$E$31,AI76)","v":0},"Труба 25х25х0,8","Труба 25х25 чм, 0.8 мм",0.8,1.2383999999999999,0.61919999999999997,6000,"<>6000",5]
[{"$f":"IF(U78=0,\"z\",\" \")","v":"z"},null,null,null,null,null,"Остатки",null,null,null,null,{"$f":"SUMIFS($L$35:$L$65,$B$35:$B$65,AN76,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ76,$E$35:$E$65,AI76)","v":0},null,null,{"$f":"SUMIFS($O$35:$O$65,$B$35:$B$65,AN76,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ76,$E$35:$E$65,AI76)","v":0},null,null,null,null,null,{"$f":"SUMIFS($U$35:$U$65,$B$35:$B$65,AN76,C26:C56,\"=500\",$D$35:$D$65,AJ76,$E$35:$E$65,AI76)","v":0},null,null,null,{"$f":"SUMIFS($Y$35:$Y$65,$B$35:$B$65,AN76,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ76,$E$35:$E$65,AI76)","v":0},null,null,null,{"$f":"SUMIFS($Z$35:$Z$65,$B$35:$B$65,AN76,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ76,$E$35:$E$65,AI76)","v":0}]
[{"$f":"IF(U78=0,\"z\",\" \")","v":"z"},null,null,null,null,null,"общая",null,null,null,null,{"$f":"L76+L77","v":0},null,null,{"$f":"O76+O77","v":0},null,null,{"$f":"R76","v":0},null,null,{"$f":"U76+U77+AB76","v":0},null,null,null,{"$f":"Y76+Y77","v":0}]
[{"$f":"IF(U81=0,\"z\",\" \")","v":"z"},null,null,null,null,{"$f":"AI79","v":"Труба 25х25 чм, 1.5 мм"},null,{"$f":"SUMIFS($F$35:$F$65,$C$35:$C$65,\"=500\",$B$35:$B$65,AM65,$D$35:$D$65,AJ79,$E$35:$E$65,AI79)","v":0},{"$f":"AJ79","v":1.5},null,{"$f":"AK79","v":2.2200000000000002},{"$f":"SUMIFS($L$35:$L$65,$B$35:$B$65,AM79,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ79,$E$35:$E$65,AI79)","v":0},null,null,{"$f":"SUMIFS($O$35:$O$65,$B$35:$B$65,AM79,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ79,$E$35:$E$65,AI79)","v":0},null,null,{"$f":"AC79+AC80-AB79","v":0},null,null,{"$f":"SUMIFS($U$35:$U$65,$B$35:$B$65,AM79,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ79,$E$35:$E$65,AI79)","v":0},null,null,null,{"$f":"SUMIFS($Y$35:$Y$65,$B$35:$B$65,AM79,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ79,$E$35:$E$65,AI79)","v":0},null,{"$f":"AC79+AC80-AB79","v":0},{"$f":"AG79*AO79/1000/2*AK79","v":0},{"$f":"SUMIFS($Z$35:$Z$65,$B$35:$B$65,AM79,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ79,$E$35:$E$65,AI79)","v":0},null,null,null,{"$f":"SUMIFS($H$9:$H$31,$E$9:$E$31,AI79)","v":0},"Труба 25х25х1,5","Труба 25х25 чм, 1.5 мм",1.5,2.2200000000000002,1.1100000000000001,6000,"<>6000",5]
[{"$f":"IF(U81=0,\"z\",\" \")","v":"z"},null,null,null,null,null,"Остатки",null,null,null,null,{"$f":"SUMIFS($L$35:$L$65,$B$35:$B$65,AN79,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ79,$E$35:$E$65,AI79)","v":0},null,null,{"$f":"SUMIFS($O$35:$O$65,$B$35:$B$65,AN79,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ79,$E$35:$E$65,AI79)","v":0},null,null,null,null,null,{"$f":"SUMIFS($U$35:$U$65,$B$35:$B$65,AN79,C29:C59,\"=500\",$D$35:$D$65,AJ79,$E$35:$E$65,AI79)","v":0},null,null,null,{"$f":"SUMIFS($Y$35:$Y$65,$B$35:$B$65,AN79,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ79,$E$35:$E$65,AI79)","v":0},null,null,null,{"$f":"SUMIFS($Z$35:$Z$65,$B$35:$B$65,AN79,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ79,$E$35:$E$65,AI79)","v":0}]
[{"$f":"IF(U81=0,\"z\",\" \")","v":"z"},null,null,null,null,null,"общая",null,null,null,null,{"$f":"L79+L80","v":0},null,null,{"$f":"O79+O80","v":0},null,null,{"$f":"R79","v":0},null,null,{"$f":"U79+U80+AB79","v":0},null,null,null,{"$f":"Y79+Y80","v":0}]
[{"$f":"IF(U84=0,\"z\",\" \")","v":"z"},null,null,null,null,{"$f":"AI82","v":"Труба 25х28 чм, 2.0 мм"},null,{"$f":"SUMIFS($F$35:$F$65,$C$35:$C$65,\"=500\",$B$35:$B$65,AM68,$D$35:$D$65,AJ82,$E$35:$E$65,AI82)","v":0},{"$f":"AJ82","v":2},null,{"$f":"AK82","v":0},{"$f":"SUMIFS($L$35:$L$65,$B$35:$B$65,AM82,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ82,$E$35:$E$65,AI82)","v":0},null,null,{"$f":"SUMIFS($O$35:$O$65,$B$35:$B$65,AM82,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ82,$E$35:$E$65,AI82)","v":0},null,null,{"$f":"AC82+AC83-AB82","v":0},null,null,{"$f":"SUMIFS($U$35:$U$65,$B$35:$B$65,AM82,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ82,$E$35:$E$65,AI82)","v":0},null,null,null,{"$f":"SUMIFS($Y$35:$Y$65,$B$35:$B$65,AM82,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ82,$E$35:$E$65,AI82)","v":0},null,{"$f":"AC82+AC83-AB82","v":0},{"$f":"AG82*AO82/1000/2*AK82","v":0},{"$f":"SUMIFS($Z$35:$Z$65,$B$35:$B$65,AM82,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ82,$E$35:$E$65,AI82)","v":0},null,null,null,{"$f":"SUMIFS($H$9:$H$31,$E$9:$E$31,AI82)","v":0},"Труба 25х28х2","Труба 25х28 чм, 2.0 мм",2,null,null,6000,"<>6000",5]
[{"$f":"IF(U84=0,\"z\",\" \")","v":"z"},null,null,null,null,null,"Остатки",null,null,null,null,{"$f":"SUMIFS($L$35:$L$65,$B$35:$B$65,AN82,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ82,$E$35:$E$65,AI82)","v":0},null,null,{"$f":"SUMIFS($O$35:$O$65,$B$35:$B$65,AN82,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ82,$E$35:$E$65,AI82)","v":0},null,null,null,null,null,{"$f":"SUMIFS($U$35:$U$65,$B$35:$B$65,AN82,C32:C62,\"=500\",$D$35:$D$65,AJ82,$E$35:$E$65,AI82)","v":0},null,null,null,{"$f":"SUMIFS($Y$35:$Y$65,$B$35:$B$65,AN82,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ82,$E$35:$E$65,AI82)","v":0},null,null,null,{"$f":"SUMIFS($Z$35:$Z$65,$B$35:$B$65,AN82,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ82,$E$35:$E$65,AI82)","v":0}]
[{"$f":"IF(U84=0,\"z\",\" \")","v":"z"},null,null,null,null,null,"общая",null,null,null,null,{"$f":"L82+L83","v":0},null,null,{"$f":"O82+O83","v":0},null,null,{"$f":"R82","v":0},null,null,{"$f":"U82+U83+AB82","v":0},null,null,null,{"$f":"Y82+Y83","v":0}]
[{"$f":"IF(U87=0,\"z\",\" \")","v":" "},null,null,null,null,{"$f":"AI85","v":"Труба 30х20 чм, 1.0 мм"},null,{"$f":"SUMIFS($F$35:$F$65,$C$35:$C$65,\"=500\",$B$35:$B$65,AM71,$D$35:$D$65,AJ85,$E$35:$E$65,AI85)","v":0},{"$f":"AJ85","v":1},null,{"$f":"AK85","v":1.5720000000000001},{"$f":"SUMIFS($L$35:$L$65,$B$35:$B$65,AM85,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ85,$E$35:$E$65,AI85)","v":23.58},null,null,{"$f":"SUMIFS($O$35:$O$65,$B$35:$B$65,AM85,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ85,$E$35:$E$65,AI85)","v":1.0295814000000001},null,null,{"$f":"AC85+AC86-AB85","v":28.192169399999997},null,null,{"$f":"SUMIFS($U$35:$U$65,$B$35:$B$65,AM85,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ85,$E$35:$E$65,AI85)","v":0.86145600000000011},null,null,null,{"$f":"SUMIFS($Y$35:$Y$65,$B$35:$B$65,AM85,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ85,$E$35:$E$65,AI85)","v":22.550418599999997},null,{"$f":"AC85+AC86-AB85","v":28.192169399999997},{"$f":"AG85*AO85/1000/2*AK85","v":0},{"$f":"SUMIFS($Z$35:$Z$65,$B$35:$B$65,AM85,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ85,$E$35:$E$65,AI85)","v":21.688962599999996},null,null,null,{"$f":"SUMIFS($H$9:$H$31,$E$9:$E$31,AI85)","v":0},"Труба 30х20х1","Труба 30х20 чм, 1.0 мм",1,1.5720000000000001,0.78600000000000003,6000,{"$f":"CONCATENATE(\"<>\",AM85)","v":"<>6000"},5]
[{"$f":"IF(U87=0,\"z\",\" \")","v":" "},null,null,null,null,null,"Остатки",null,null,null,null,{"$f":"SUMIFS($L$35:$L$65,$B$35:$B$65,AN85,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ85,$E$35:$E$65,AI85)","v":8.8739399999999993},null,null,{"$f":"SUMIFS($O$35:$O$65,$B$35:$B$65,AN85,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ85,$E$35:$E$65,AI85)","v":1.5061332000000001},null,null,null,null,null,{"$f":"SUMIFS($U$35:$U$65,$B$35:$B$65,AN85,C35:C65,\"=500\",$D$35:$D$65,AJ85,$E$35:$E$65,AI85)","v":0.86460000000000015},null,null,null,{"$f":"SUMIFS($Y$35:$Y$65,$B$35:$B$65,AN85,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ85,$E$35:$E$65,AI85)","v":7.3678067999999994},null,null,null,{"$f":"SUMIFS($Z$35:$Z$65,$B$35:$B$65,AN85,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ85,$E$35:$E$65,AI85)","v":6.5032067999999992}]
[{"$f":"IF(U87=0,\"z\",\" \")","v":" "},null,null,null,null,null,"общая",null,null,null,null,{"$f":"L85+L86","v":32.453939999999996},null,null,{"$f":"O85+O86","v":2.5357146000000004},null,null,{"$f":"R85","v":28.192169399999997},null,null,{"$f":"U85+U86+AB85","v":1.7260560000000003},null,null,null,{"$f":"Y85+Y86","v":29.918225399999997}]
[{"$f":"IF(U90=0,\"z\",\" \")","v":" "},null,null,null,null,{"$f":"AI88","v":"Труба 40х20 чм, 1.5 мм"},null,{"$f":"SUMIFS($F$35:$F$65,$C$35:$C$65,\"=500\",$B$35:$B$65,AM74,$D$35:$D$65,AJ88,$E$35:$E$65,AI88)","v":0},{"$f":"AJ88","v":1.5},null,{"$f":"AK88","v":2.88},{"$f":"SUMIFS($L$35:$L$65,$B$35:$B$65,AM88,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ88,$E$35:$E$65,AI88)","v":86.4},null,null,{"$f":"SUMIFS($O$35:$O$65,$B$35:$B$65,AM88,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ88,$E$35:$E$65,AI88)","v":2.7478079999999996},null,null,{"$f":"AC88+AC89-AB88","v":160.37510400000002},null,null,{"$f":"SUMIFS($U$35:$U$65,$B$35:$B$65,AM88,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ88,$E$35:$E$65,AI88)","v":0.74304000000000003},null,null,null,{"$f":"SUMIFS($Y$35:$Y$65,$B$35:$B$65,AM88,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ88,$E$35:$E$65,AI88)","v":83.652191999999999},null,{"$f":"AC88+AC89-AB88","v":160.37510400000002},{"$f":"AG88*AO88/1000/2*AK88","v":0},{"$f":"SUMIFS($Z$35:$Z$65,$B$35:$B$65,AM88,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ88,$E$35:$E$65,AI88)","v":82.909152000000006},null,null,null,{"$f":"SUMIFS($H$9:$H$31,$E$9:$E$31,AI88)","v":0},"Труба 40х20х1,5","Труба 40х20 чм, 1.5 мм",1.5,2.88,1.44,6000,{"$f":"CONCATENATE(\"<>\",AM88)","v":"<>6000"},5]
[{"$f":"IF(U90=0,\"z\",\" \")","v":" "},null,null,null,null,null,"Остатки",null,null,null,null,{"$f":"SUMIFS($L$35:$L$65,$B$35:$B$65,AN88,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ88,$E$35:$E$65,AI88)","v":80.956800000000001},null,null,{"$f":"SUMIFS($O$35:$O$65,$B$35:$B$65,AN88,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ88,$E$35:$E$65,AI88)","v":2.7478079999999996},null,null,null,null,null,{"$f":"SUMIFS($U$35:$U$65,$B$35:$B$65,AN88,C38:C68,\"=500\",$D$35:$D$65,AJ88,$E$35:$E$65,AI88)","v":0},null,null,null,{"$f":"SUMIFS($Y$35:$Y$65,$B$35:$B$65,AN88,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ88,$E$35:$E$65,AI88)","v":78.208991999999995},null,null,null,{"$f":"SUMIFS($Z$35:$Z$65,$B$35:$B$65,AN88,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ88,$E$35:$E$65,AI88)","v":77.465952000000001}]
[{"$f":"IF(U90=0,\"z\",\" \")","v":" "},null,null,null,null,null,"общая",null,null,null,null,{"$f":"L88+L89","v":167.35680000000002},null,null,{"$f":"O88+O89","v":5.4956159999999992},null,null,{"$f":"R88","v":160.37510400000002},null,null,{"$f":"U88+U89+AB88","v":0.74304000000000003},null,null,null,{"$f":"Y88+Y89","v":161.86118399999998}]
[{"$f":"IF(U93=0,\"z\",\" \")","v":" "},null,null,null,null,{"$f":"AI91","v":"Труба 30х50 чм, 2.0 мм"},null,{"$f":"SUMIFS($F$35:$F$65,$C$35:$C$65,\"=500\",$B$35:$B$65,AM77,$D$35:$D$65,AJ91,$E$35:$E$65,AI91)","v":0},{"$f":"AJ91","v":2},null,{"$f":"AK91","v":4.8899999999999997},{"$f":"SUMIFS($L$35:$L$65,$B$35:$B$65,AM91,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ91,$E$35:$E$65,AI91)","v":0},null,null,{"$f":"SUMIFS($O$35:$O$65,$B$35:$B$65,AM91,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ91,$E$35:$E$65,AI91)","v":0},null,null,{"$f":"AC91+AC92-AB91","v":-0.61124999999999996},null,null,{"$f":"SUMIFS($U$35:$U$65,$B$35:$B$65,AM91,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ91,$E$35:$E$65,AI91)","v":0},null,null,null,{"$f":"SUMIFS($Y$35:$Y$65,$B$35:$B$65,AM91,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ91,$E$35:$E$65,AI91)","v":0},null,{"$f":"AC91+AC92-AB91","v":-0.61124999999999996},{"$f":"AG91*AO91/1000/2*AK91","v":0.61124999999999996},{"$f":"SUMIFS($Z$35:$Z$65,$B$35:$B$65,AM91,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ91,$E$35:$E$65,AI91)","v":0},null,null,null,{"$f":"SUMIFS($H$9:$H$31,$E$9:$E$31,AI91)","v":50},"Труба 30х50х2","Труба 30х50 чм, 2.0 мм",2,4.8899999999999997,2.4489999999999998,6000,{"$f":"CONCATENATE(\"<>\",AM91)","v":"<>6000"},5]
[{"$f":"IF(U93=0,\"z\",\" \")","v":" "},null,null,null,null,null,"Остатки",null,null,null,null,{"$f":"SUMIFS($L$35:$L$65,$B$35:$B$65,AN91,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ91,$E$35:$E$65,AI91)","v":0},null,null,{"$f":"SUMIFS($O$35:$O$65,$B$35:$B$65,AN91,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ91,$E$35:$E$65,AI91)","v":0},null,null,null,null,null,{"$f":"SUMIFS($U$35:$U$65,$B$35:$B$65,AN91,C41:C71,\"=500\",$D$35:$D$65,AJ91,$E$35:$E$65,AI91)","v":0},null,null,null,{"$f":"SUMIFS($Y$35:$Y$65,$B$35:$B$65,AN91,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ91,$E$35:$E$65,AI91)","v":0},null,null,null,{"$f":"SUMIFS($Z$35:$Z$65,$B$35:$B$65,AN91,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ91,$E$35:$E$65,AI91)","v":0}]
[{"$f":"IF(U93=0,\"z\",\" \")","v":" "},null,null,null,null,null,"общая",null,null,null,null,{"$f":"L91+L92","v":0},null,null,{"$f":"O91+O92","v":0},null,null,{"$f":"R91","v":-0.61124999999999996},null,null,{"$f":"U91+U92+AB91","v":0.61124999999999996},null,null,null,{"$f":"Y91+Y92","v":0}]
[{"$f":"IF(U96=0,\"z\",\" \")","v":"z"},null,null,null,null,{"$f":"AI94","v":"Труба 40х20 чм, 1.0 мм"},null,{"$f":"SUMIFS($F$35:$F$65,$C$35:$C$65,\"=500\",$B$35:$B$65,AM80,$D$35:$D$65,AJ94,$E$35:$E$65,AI94)","v":0},{"$f":"AJ94","v":1},null,{"$f":"AK94","v":1.8839999999999999},{"$f":"SUMIFS($L$35:$L$65,$B$35:$B$65,AM94,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ94,$E$35:$E$65,AI94)","v":0},null,null,{"$f":"SUMIFS($O$35:$O$65,$B$35:$B$65,AM94,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ94,$E$35:$E$65,AI94)","v":0},null,null,{"$f":"AC94+AC95-AB94","v":0},null,null,{"$f":"SUMIFS($U$35:$U$65,$B$35:$B$65,AM94,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ94,$E$35:$E$65,AI94)","v":0},null,null,null,{"$f":"SUMIFS($Y$35:$Y$65,$B$35:$B$65,AM94,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ94,$E$35:$E$65,AI94)","v":0},null,{"$f":"AC94+AC95-AB94","v":0},{"$f":"AG94*AO94/1000/2*AK94","v":0},{"$f":"SUMIFS($Z$35:$Z$65,$B$35:$B$65,AM94,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ94,$E$35:$E$65,AI94)","v":0},null,null,null,{"$f":"SUMIFS($H$9:$H$31,$E$9:$E$31,AI94)","v":0},"Труба 40х20х1","Труба 40х20 чм, 1.0 мм",1,1.8839999999999999,0.94199999999999995,6000,"<>6000",5]
[{"$f":"IF(U96=0,\"z\",\" \")","v":"z"},null,null,null,null,null,"Остатки",null,null,null,null,{"$f":"SUMIFS($L$35:$L$65,$B$35:$B$65,AN94,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ94,$E$35:$E$65,AI94)","v":0},null,null,{"$f":"SUMIFS($O$35:$O$65,$B$35:$B$65,AN94,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ94,$E$35:$E$65,AI94)","v":0},null,null,null,null,null,{"$f":"SUMIFS($U$35:$U$65,$B$35:$B$65,AN94,C44:C74,\"=500\",$D$35:$D$65,AJ94,$E$35:$E$65,AI94)","v":0},null,null,null,{"$f":"SUMIFS($Y$35:$Y$65,$B$35:$B$65,AN94,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ94,$E$35:$E$65,AI94)","v":0},null,null,null,{"$f":"SUMIFS($Z$35:$Z$65,$B$35:$B$65,AN94,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ94,$E$35:$E$65,AI94)","v":0}]
[{"$f":"IF(U96=0,\"z\",\" \")","v":"z"},null,null,null,null,null,"общая",null,null,null,null,{"$f":"L94+L95","v":0},null,null,{"$f":"O94+O95","v":0},null,null,{"$f":"R94","v":0},null,null,{"$f":"U94+U95+AB94","v":0},null,null,null,{"$f":"Y94+Y95","v":0}]
[{"$f":"IF(U99=0,\"z\",\" \")","v":"z"},null,null,null,null,{"$f":"AI97","v":"Труба 15х15 чм, 1.0 мм"},null,{"$f":"SUMIFS($F$35:$F$65,$C$35:$C$65,\"=500\",$B$35:$B$65,AM83,$D$35:$D$65,AJ97,$E$35:$E$65,AI97)","v":0},{"$f":"AJ97","v":1},null,{"$f":"AK97","v":0.85199999999999998},{"$f":"SUMIFS($L$35:$L$65,$B$35:$B$65,AM97,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ97,$E$35:$E$65,AI97)","v":0},null,null,{"$f":"SUMIFS($O$35:$O$65,$B$35:$B$65,AM97,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ97,$E$35:$E$65,AI97)","v":0},null,null,{"$f":"AC97+AC98-AB97","v":0},null,null,{"$f":"SUMIFS($U$35:$U$65,$B$35:$B$65,AM97,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ97,$E$35:$E$65,AI97)","v":0},null,null,null,{"$f":"SUMIFS($Y$35:$Y$65,$B$35:$B$65,AM97,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ97,$E$35:$E$65,AI97)","v":0},null,{"$f":"AC97+AC98-AB97","v":0},{"$f":"AG97*AO97/1000/2*AK97","v":0},{"$f":"SUMIFS($Z$35:$Z$65,$B$35:$B$65,AM97,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ97,$E$35:$E$65,AI97)","v":0},null,null,null,{"$f":"SUMIFS($H$9:$H$31,$E$9:$E$31,AI97)","v":0},"Труба 15х15х1","Труба 15х15 чм, 1.0 мм",1,0.85199999999999998,0.47599999999999998,6000,{"$f":"CONCATENATE(\"<>\",AM97)","v":"<>6000"},5]
[{"$f":"IF(U99=0,\"z\",\" \")","v":"z"},null,null,null,null,null,"Остатки",null,null,null,null,{"$f":"SUMIFS($L$35:$L$65,$B$35:$B$65,AN97,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ97,$E$35:$E$65,AI97)","v":0},null,null,{"$f":"SUMIFS($O$35:$O$65,$B$35:$B$65,AN97,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ97,$E$35:$E$65,AI97)","v":0},null,null,null,null,null,{"$f":"SUMIFS($U$35:$U$65,$B$35:$B$65,AN97,C47:C77,\"=500\",$D$35:$D$65,AJ97,$E$35:$E$65,AI97)","v":0},null,null,null,{"$f":"SUMIFS($Y$35:$Y$65,$B$35:$B$65,AN97,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ97,$E$35:$E$65,AI97)","v":0},null,null,null,{"$f":"SUMIFS($Z$35:$Z$65,$B$35:$B$65,AN97,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ97,$E$35:$E$65,AI97)","v":0}]
[{"$f":"IF(U99=0,\"z\",\" \")","v":"z"},null,null,null,null,null,"общая",null,null,null,null,{"$f":"L97+L98","v":0},null,null,{"$f":"O97+O98","v":0},null,null,{"$f":"R97","v":0},null,null,{"$f":"U97+U98+AB97","v":0},null,null,null,{"$f":"Y97+Y98","v":0}]
[{"$f":"IF(U102=0,\"z\",\" \")","v":"z"},null,null,null,null,{"$f":"AI100","v":"Труба 25х50 чм, 1.2 мм"},null,{"$f":"SUMIFS($F$35:$F$65,$C$35:$C$65,\"=500\",$B$35:$B$65,AM86,$D$35:$D$65,AJ100,$E$35:$E$65,AI100)","v":0},{"$f":"AJ100","v":1.2},null,{"$f":"AK100","v":2.7},{"$f":"SUMIFS($L$35:$L$65,$B$35:$B$65,AM100,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ100,$E$35:$E$65,AI100)","v":0},null,null,{"$f":"SUMIFS($O$35:$O$65,$B$35:$B$65,AM100,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ100,$E$35:$E$65,AI100)","v":0},null,null,{"$f":"AC100+AC101-AB100","v":0},null,null,{"$f":"SUMIFS($U$35:$U$65,$B$35:$B$65,AM100,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ100,$E$35:$E$65,AI100)","v":0},null,null,null,{"$f":"SUMIFS($Y$35:$Y$65,$B$35:$B$65,AM100,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ100,$E$35:$E$65,AI100)","v":0},null,{"$f":"AC100+AC101-AB100","v":0},{"$f":"AG100*AO100/1000/2*AK100","v":0},{"$f":"SUMIFS($Z$35:$Z$65,$B$35:$B$65,AM100,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ100,$E$35:$E$65,AI100)","v":0},null,null,null,{"$f":"SUMIFS($H$9:$H$31,$E$9:$E$31,AI100)","v":0},"Труба 25х50х1,2","Труба 25х50 чм, 1.2 мм",1.2,2.7,1.35,6000,{"$f":"CONCATENATE(\"<>\",AM100)","v":"<>6000"},5]
[{"$f":"IF(U102=0,\"z\",\" \")","v":"z"},null,null,null,null,null,"Остатки",null,null,null,null,{"$f":"SUMIFS($L$35:$L$65,$B$35:$B$65,AN100,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ100,$E$35:$E$65,AI100)","v":0},null,null,{"$f":"SUMIFS($O$35:$O$65,$B$35:$B$65,AN100,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ100,$E$35:$E$65,AI100)","v":0},null,null,null,null,null,{"$f":"SUMIFS($U$35:$U$65,$B$35:$B$65,AN100,C50:C80,\"=500\",$D$35:$D$65,AJ100,$E$35:$E$65,AI100)","v":0},null,null,null,{"$f":"SUMIFS($Y$35:$Y$65,$B$35:$B$65,AN100,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ100,$E$35:$E$65,AI100)","v":0},null,null,null,{"$f":"SUMIFS($Z$35:$Z$65,$B$35:$B$65,AN100,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ100,$E$35:$E$65,AI100)","v":0}]
[{"$f":"IF(U102=0,\"z\",\" \")","v":"z"},null,null,null,null,null,"общая",null,null,null,null,{"$f":"L100+L101","v":0},null,null,{"$f":"O100+O101","v":0},null,null,{"$f":"R100","v":0},null,null,{"$f":"U100+U101+AB100","v":0},null,null,null,{"$f":"Y100+Y101","v":0}]
[{"$f":"IF(U105=0,\"z\",\" \")","v":"z"},null,null,null,null,{"$f":"AI103","v":"Труба 30х15 чм, 1.2 мм"},null,{"$f":"SUMIFS($F$35:$F$65,$C$35:$C$65,\"=500\",$B$35:$B$65,AM89,$D$35:$D$65,AJ103,$E$35:$E$65,AI103)","v":0},{"$f":"AJ103","v":1.2},null,{"$f":"AK103","v":1.5660000000000001},{"$f":"SUMIFS($L$35:$L$65,$B$35:$B$65,AM103,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ103,$E$35:$E$65,AI103)","v":0},null,null,{"$f":"SUMIFS($O$35:$O$65,$B$35:$B$65,AM103,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ103,$E$35:$E$65,AI103)","v":0},null,null,{"$f":"AC103+AC104-AB103","v":0},null,null,{"$f":"SUMIFS($U$35:$U$65,$B$35:$B$65,AM103,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ103,$E$35:$E$65,AI103)","v":0},null,null,null,{"$f":"SUMIFS($Y$35:$Y$65,$B$35:$B$65,AM103,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ103,$E$35:$E$65,AI103)","v":0},null,{"$f":"AC103+AC104-AB103","v":0},{"$f":"AG103*AO103/1000/2*AK103","v":0},{"$f":"SUMIFS($Z$35:$Z$65,$B$35:$B$65,AM103,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ103,$E$35:$E$65,AI103)","v":0},null,null,null,{"$f":"SUMIFS($H$9:$H$31,$E$9:$E$31,AI103)","v":0},"Труба 30х15х1,2","Труба 30х15 чм, 1.2 мм",1.2,1.5660000000000001,0.78300000000000003,6000,{"$f":"CONCATENATE(\"<>\",AM103)","v":"<>6000"},5]
[{"$f":"IF(U105=0,\"z\",\" \")","v":"z"},null,null,null,null,null,"Остатки",null,null,null,null,{"$f":"SUMIFS($L$35:$L$65,$B$35:$B$65,AN103,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ103,$E$35:$E$65,AI103)","v":0},null,null,{"$f":"SUMIFS($O$35:$O$65,$B$35:$B$65,AN103,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ103,$E$35:$E$65,AI103)","v":0},null,null,null,null,null,{"$f":"SUMIFS($U$35:$U$65,$B$35:$B$65,AN103,C53:C83,\"=500\",$D$35:$D$65,AJ103,$E$35:$E$65,AI103)","v":0},null,null,null,{"$f":"SUMIFS($Y$35:$Y$65,$B$35:$B$65,AN103,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ103,$E$35:$E$65,AI103)","v":0},null,null,null,{"$f":"SUMIFS($Z$35:$Z$65,$B$35:$B$65,AN103,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ103,$E$35:$E$65,AI103)","v":0}]
[{"$f":"IF(U105=0,\"z\",\" \")","v":"z"},null,null,null,null,null,"общая",null,null,null,null,{"$f":"L103+L104","v":0},null,null,{"$f":"O103+O104","v":0},null,null,{"$f":"R103","v":0},null,null,{"$f":"U103+U104+AB103","v":0},null,null,null,{"$f":"Y103+Y104","v":0}]
[{"$f":"IF(U108=0,\"z\",\" \")","v":"z"},null,null,null,null,{"$f":"AI106","v":"Труба 40х20 чм, 2.0 мм"},null,{"$f":"SUMIFS($F$35:$F$65,$C$35:$C$65,\"=500\",$B$35:$B$65,AM92,$D$35:$D$65,AJ106,$E$35:$E$65,AI106)","v":0},{"$f":"AJ106","v":2},null,{"$f":"AK106","v":3.4},{"$f":"SUMIFS($L$35:$L$65,$B$35:$B$65,AM106,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ106,$E$35:$E$65,AI106)","v":0},null,null,{"$f":"SUMIFS($O$35:$O$65,$B$35:$B$65,AM106,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ106,$E$35:$E$65,AI106)","v":0},null,null,{"$f":"AC106+AC107-AB106","v":0},null,null,{"$f":"SUMIFS($U$35:$U$65,$B$35:$B$65,AM106,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ106,$E$35:$E$65,AI106)","v":0},null,null,null,{"$f":"SUMIFS($Y$35:$Y$65,$B$35:$B$65,AM106,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ106,$E$35:$E$65,AI106)","v":0},null,{"$f":"AC106+AC107-AB106","v":0},{"$f":"AG106*AO106/1000/2*AK106","v":0},{"$f":"SUMIFS($Z$35:$Z$65,$B$35:$B$65,AM106,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ106,$E$35:$E$65,AI106)","v":0},null,null,null,{"$f":"SUMIFS($H$9:$H$31,$E$9:$E$31,AI106)","v":0},"Труба 40х20х2","Труба 40х20 чм, 2.0 мм",2,3.4,1.7,6000,"<>6000",5]
[{"$f":"IF(U108=0,\"z\",\" \")","v":"z"},null,null,null,null,null,"Остатки",null,null,null,null,{"$f":"SUMIFS($L$35:$L$65,$B$35:$B$65,AN106,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ106,$E$35:$E$65,AI106)","v":0},null,null,{"$f":"SUMIFS($O$35:$O$65,$B$35:$B$65,AN106,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ106,$E$35:$E$65,AI106)","v":0},null,null,null,null,null,{"$f":"SUMIFS($U$35:$U$65,$B$35:$B$65,AN106,C56:C86,\"=500\",$D$35:$D$65,AJ106,$E$35:$E$65,AI106)","v":0},null,null,null,{"$f":"SUMIFS($Y$35:$Y$65,$B$35:$B$65,AN106,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ106,$E$35:$E$65,AI106)","v":0},null,null,null,{"$f":"SUMIFS($Z$35:$Z$65,$B$35:$B$65,AN106,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ106,$E$35:$E$65,AI106)","v":0}]
[{"$f":"IF(U108=0,\"z\",\" \")","v":"z"},null,null,null,null,null,"общая",null,null,null,null,{"$f":"L106+L107","v":0},null,null,{"$f":"O106+O107","v":0},null,null,{"$f":"R106","v":0},null,null,{"$f":"U106+U107+AB106","v":0},null,null,null,{"$f":"Y106+Y107","v":0}]
[{"$f":"IF(U111=0,\"z\",\" \")","v":"z"},null,null,null,null,{"$f":"AI109","v":"Труба 40х25 чм, 2.0 мм"},null,{"$f":"SUMIFS($F$35:$F$65,$C$35:$C$65,\"=500\",$B$35:$B$65,AM95,$D$35:$D$65,AJ109,$E$35:$E$65,AI109)","v":0},{"$f":"AJ109","v":2},null,{"$f":"AK109","v":4.08},{"$f":"SUMIFS($L$35:$L$65,$B$35:$B$65,AM109,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ109,$E$35:$E$65,AI109)","v":0},null,null,{"$f":"SUMIFS($O$35:$O$65,$B$35:$B$65,AM109,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ109,$E$35:$E$65,AI109)","v":0},null,null,{"$f":"AC109+AC110-AB109","v":0},null,null,{"$f":"SUMIFS($U$35:$U$65,$B$35:$B$65,AM109,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ109,$E$35:$E$65,AI109)","v":0},null,null,null,{"$f":"SUMIFS($Y$35:$Y$65,$B$35:$B$65,AM109,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ109,$E$35:$E$65,AI109)","v":0},null,{"$f":"AC109+AC110-AB109","v":0},{"$f":"AG109*AO109/1000/2*AK109","v":0},{"$f":"SUMIFS($Z$35:$Z$65,$B$35:$B$65,AM109,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ109,$E$35:$E$65,AI109)","v":0},null,null,null,{"$f":"SUMIFS($H$9:$H$31,$E$9:$E$31,AI109)","v":0},"Труба 40х25х","Труба 40х25 чм, 2.0 мм",2,4.08,2.04,6000,"<>6000",5]
[{"$f":"IF(U111=0,\"z\",\" \")","v":"z"},null,null,null,null,null,"Остатки",null,null,null,null,{"$f":"SUMIFS($L$35:$L$65,$B$35:$B$65,AN109,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ109,$E$35:$E$65,AI109)","v":0},null,null,{"$f":"SUMIFS($O$35:$O$65,$B$35:$B$65,AN109,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ109,$E$35:$E$65,AI109)","v":0},null,null,null,null,null,{"$f":"SUMIFS($U$35:$U$65,$B$35:$B$65,AN109,C59:C89,\"=500\",$D$35:$D$65,AJ109,$E$35:$E$65,AI109)","v":0},null,null,null,{"$f":"SUMIFS($Y$35:$Y$65,$B$35:$B$65,AN109,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ109,$E$35:$E$65,AI109)","v":0},null,null,null,{"$f":"SUMIFS($Z$35:$Z$65,$B$35:$B$65,AN109,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ109,$E$35:$E$65,AI109)","v":0}]
[{"$f":"IF(U111=0,\"z\",\" \")","v":"z"},null,null,null,null,null,"общая",null,null,null,null,{"$f":"L109+L110","v":0},null,null,{"$f":"O109+O110","v":0},null,null,{"$f":"R109","v":0},null,null,{"$f":"U109+U110+AB109","v":0},null,null,null,{"$f":"Y109+Y110","v":0}]
[{"$f":"IF(U114=0,\"z\",\" \")","v":"z"},null,null,null,null,{"$f":"AI112","v":"Труба 60х30 чм, 2.0 мм"},null,{"$f":"SUMIFS($F$35:$F$65,$C$35:$C$65,\"=500\",$B$35:$B$65,AM98,$D$35:$D$65,AJ112,$E$35:$E$65,AI112)","v":0},{"$f":"AJ112","v":2},null,{"$f":"AK112","v":5.3},{"$f":"SUMIFS($L$35:$L$65,$B$35:$B$65,AM112,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ112,$E$35:$E$65,AI112)","v":0},null,null,{"$f":"SUMIFS($O$35:$O$65,$B$35:$B$65,AM112,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ112,$E$35:$E$65,AI112)","v":0},null,null,{"$f":"AC112+AC113-AB112","v":0},null,null,{"$f":"SUMIFS($U$35:$U$65,$B$35:$B$65,AM112,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ112,$E$35:$E$65,AI112)","v":0},null,null,null,{"$f":"SUMIFS($Y$35:$Y$65,$B$35:$B$65,AM112,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ112,$E$35:$E$65,AI112)","v":0},null,{"$f":"AC112+AC113-AB112","v":0},{"$f":"AG112*AO112/1000/2*AK112","v":0},{"$f":"SUMIFS($Z$35:$Z$65,$B$35:$B$65,AM112,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ112,$E$35:$E$65,AI112)","v":0},null,null,null,{"$f":"SUMIFS($H$9:$H$31,$E$9:$E$31,AI112)","v":0},"Труба 60х30х2","Труба 60х30 чм, 2.0 мм",2,5.3,2.65,6000,"<>6000",5]
[{"$f":"IF(U114=0,\"z\",\" \")","v":"z"},null,null,null,null,null,"Остатки",null,null,null,null,{"$f":"SUMIFS($L$35:$L$65,$B$35:$B$65,AN112,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ112,$E$35:$E$65,AI112)","v":0},null,null,{"$f":"SUMIFS($O$35:$O$65,$B$35:$B$65,AN112,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ112,$E$35:$E$65,AI112)","v":0},null,null,null,null,null,{"$f":"SUMIFS($U$35:$U$65,$B$35:$B$65,AN112,C62:C92,\"=500\",$D$35:$D$65,AJ112,$E$35:$E$65,AI112)","v":0},null,null,null,{"$f":"SUMIFS($Y$35:$Y$65,$B$35:$B$65,AN112,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ112,$E$35:$E$65,AI112)","v":0},null,null,null,{"$f":"SUMIFS($Z$35:$Z$65,$B$35:$B$65,AN112,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ112,$E$35:$E$65,AI112)","v":0}]
[{"$f":"IF(U114=0,\"z\",\" \")","v":"z"},null,null,null,null,null,"общая",null,null,null,null,{"$f":"L112+L113","v":0},null,null,{"$f":"O112+O113","v":0},null,null,{"$f":"R112","v":0},null,null,{"$f":"U112+U113+AB112","v":0},null,null,null,{"$f":"Y112+Y113","v":0}]
[{"$f":"IF(U117=0,\"z\",\" \")","v":"z"},null,null,null,null,{"$f":"AI115","v":0},null,{"$f":"SUMIFS($F$35:$F$65,$C$35:$C$65,\"=500\",$B$35:$B$65,AM101,$D$35:$D$65,AJ115,$E$35:$E$65,AI115)","v":0},{"$f":"AJ115","v":3},null,{"$f":"AK115","v":4.3159999999999998},{"$f":"SUMIFS($L$35:$L$65,$B$35:$B$65,AM115,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ115,$E$35:$E$65,AI115)","v":0},null,null,{"$f":"SUMIFS($O$35:$O$65,$B$35:$B$65,AM115,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ115,$E$35:$E$65,AI115)","v":0},null,null,{"$f":"AC115+AC116-AB115","v":0},null,null,{"$f":"SUMIFS($U$35:$U$65,$B$35:$B$65,AM115,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ115,$E$35:$E$65,AI115)","v":0},null,null,null,{"$f":"SUMIFS($Y$35:$Y$65,$B$35:$B$65,AM115,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ115,$E$35:$E$65,AI115)","v":0},null,{"$f":"AC115+AC116-AB115","v":0},{"$f":"AG115*AO115/1000/2*AK115","v":0},{"$f":"SUMIFS($Z$35:$Z$65,$B$35:$B$65,AM115,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ115,$E$35:$E$65,AI115)","v":0},null,null,null,{"$f":"SUMIFS($H$9:$H$31,$E$9:$E$31,AI115)","v":0},"Труба ø 32,5х3",null,3,4.3159999999999998,2.1579999999999999,6000,"<>6000",5]
[{"$f":"IF(U117=0,\"z\",\" \")","v":"z"},null,null,null,null,null,"Остатки",null,null,null,null,{"$f":"SUMIFS($L$35:$L$65,$B$35:$B$65,AN115,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ115,$E$35:$E$65,AI115)","v":0},null,null,{"$f":"SUMIFS($O$35:$O$65,$B$35:$B$65,AN115,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ115,$E$35:$E$65,AI115)","v":0},null,null,null,null,null,{"$f":"SUMIFS($U$35:$U$65,$B$35:$B$65,AN115,C65:C95,\"=500\",$D$35:$D$65,AJ115,$E$35:$E$65,AI115)","v":0},null,null,null,{"$f":"SUMIFS($Y$35:$Y$65,$B$35:$B$65,AN115,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ115,$E$35:$E$65,AI115)","v":0},null,null,null,{"$f":"SUMIFS($Z$35:$Z$65,$B$35:$B$65,AN115,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ115,$E$35:$E$65,AI115)","v":0}]
[{"$f":"IF(U117=0,\"z\",\" \")","v":"z"},null,null,null,null,null,"общая",null,null,null,null,{"$f":"L115+L116","v":0},null,null,{"$f":"O115+O116","v":0},null,null,{"$f":"R115","v":0},null,null,{"$f":"U115+U116+AB115","v":0},null,null,null,{"$f":"Y115+Y116","v":0}]
[{"$f":"IF(U120=0,\"z\",\" \")","v":" "},null,null,null,null,{"$f":"AI118","v":"Труба 20 чм, 1.0 мм"},null,{"$f":"SUMIFS($F$35:$F$65,$C$35:$C$65,\"=500\",$B$35:$B$65,AM104,$D$35:$D$65,AJ118,$E$35:$E$65,AI118)","v":0},{"$f":"AJ118","v":1},null,{"$f":"AK118","v":0.98},{"$f":"SUMIFS($L$35:$L$65,$B$35:$B$65,AM118,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ118,$E$35:$E$65,AI118)","v":0},null,null,{"$f":"SUMIFS($O$35:$O$65,$B$35:$B$65,AM118,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ118,$E$35:$E$65,AI118)","v":0},null,null,{"$f":"AC118+AC119-AB118","v":-0.46549999999999997},null,null,{"$f":"SUMIFS($U$35:$U$65,$B$35:$B$65,AM118,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ118,$E$35:$E$65,AI118)","v":0},null,null,null,{"$f":"SUMIFS($Y$35:$Y$65,$B$35:$B$65,AM118,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ118,$E$35:$E$65,AI118)","v":0},null,{"$f":"AC118+AC119-AB118","v":-0.46549999999999997},{"$f":"AG118*AO118/1000/2*AK118","v":0.46549999999999997},{"$f":"SUMIFS($Z$35:$Z$65,$B$35:$B$65,AM118,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ118,$E$35:$E$65,AI118)","v":0},null,null,null,{"$f":"SUMIFS($H$9:$H$31,$E$9:$E$31,AI118)","v":190},"Труба ø 20х1","Труба 20 чм, 1.0 мм",1,0.98,0.49,6000,"<>6000",5]
[{"$f":"IF(U120=0,\"z\",\" \")","v":" "},null,null,null,null,null,"Остатки",null,null,null,null,{"$f":"SUMIFS($L$35:$L$65,$B$35:$B$65,AN118,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ118,$E$35:$E$65,AI118)","v":0},null,null,{"$f":"SUMIFS($O$35:$O$65,$B$35:$B$65,AN118,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ118,$E$35:$E$65,AI118)","v":0},null,null,null,null,null,{"$f":"SUMIFS($U$35:$U$65,$B$35:$B$65,AN118,C68:C98,\"=500\",$D$35:$D$65,AJ118,$E$35:$E$65,AI118)","v":0},null,null,null,{"$f":"SUMIFS($Y$35:$Y$65,$B$35:$B$65,AN118,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ118,$E$35:$E$65,AI118)","v":0},null,null,null,{"$f":"SUMIFS($Z$35:$Z$65,$B$35:$B$65,AN118,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ118,$E$35:$E$65,AI118)","v":0}]
[{"$f":"IF(U120=0,\"z\",\" \")","v":" "},null,null,null,null,null,"общая",null,null,null,null,{"$f":"L118+L119","v":0},null,null,{"$f":"O118+O119","v":0},null,null,{"$f":"R118","v":-0.46549999999999997},null,null,{"$f":"U118+U119+AB118","v":0.46549999999999997},null,null,null,{"$f":"Y118+Y119","v":0}]
[{"$f":"IF(U123=0,\"z\",\" \")","v":"z"},null,null,null,null,{"$f":"AI121","v":"Труба 25 чм, 1.5 мм"},null,{"$f":"SUMIFS($F$35:$F$65,$C$35:$C$65,\"=500\",$B$35:$B$65,AM107,$D$35:$D$65,AJ121,$E$35:$E$65,AI121)","v":0},{"$f":"AJ121","v":1.5},null,{"$f":"AK121","v":1.86},{"$f":"SUMIFS($L$35:$L$65,$B$35:$B$65,AM121,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ121,$E$35:$E$65,AI121)","v":0},null,null,{"$f":"SUMIFS($O$35:$O$65,$B$35:$B$65,AM121,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ121,$E$35:$E$65,AI121)","v":0},null,null,{"$f":"AC121+AC122-AB121","v":0},null,null,{"$f":"SUMIFS($U$35:$U$65,$B$35:$B$65,AM121,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ121,$E$35:$E$65,AI121)","v":0},null,null,null,{"$f":"SUMIFS($Y$35:$Y$65,$B$35:$B$65,AM121,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ121,$E$35:$E$65,AI121)","v":0},null,{"$f":"AC121+AC122-AB121","v":0},{"$f":"AG121*AO121/1000/2*AK121","v":0},{"$f":"SUMIFS($Z$35:$Z$65,$B$35:$B$65,AM121,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ121,$E$35:$E$65,AI121)","v":0},null,null,null,{"$f":"SUMIFS($H$9:$H$31,$E$9:$E$31,AI121)","v":0},"Труба ø 25х1,5","Труба 25 чм, 1.5 мм",1.5,1.86,0.93,6000,{"$f":"CONCATENATE(\"<>\",AM121)","v":"<>6000"},5]
[{"$f":"IF(U123=0,\"z\",\" \")","v":"z"},null,null,null,null,null,"Остатки",null,null,null,null,{"$f":"SUMIFS($L$35:$L$65,$B$35:$B$65,AN121,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ121,$E$35:$E$65,AI121)","v":0},null,null,{"$f":"SUMIFS($O$35:$O$65,$B$35:$B$65,AN121,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ121,$E$35:$E$65,AI121)","v":0},null,null,null,null,null,{"$f":"SUMIFS($U$35:$U$65,$B$35:$B$65,AN121,C71:C101,\"=500\",$D$35:$D$65,AJ121,$E$35:$E$65,AI121)","v":0},null,null,null,{"$f":"SUMIFS($Y$35:$Y$65,$B$35:$B$65,AN121,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ121,$E$35:$E$65,AI121)","v":0},null,null,null,{"$f":"SUMIFS($Z$35:$Z$65,$B$35:$B$65,AN121,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ121,$E$35:$E$65,AI121)","v":0}]
[{"$f":"IF(U123=0,\"z\",\" \")","v":"z"},null,null,null,null,null,"общая",null,null,null,null,{"$f":"L121+L122","v":0},null,null,{"$f":"O121+O122","v":0},null,null,{"$f":"R121","v":0},null,null,{"$f":"U121+U122+AB121","v":0},null,null,null,{"$f":"Y121+Y122","v":0}]
[{"$f":"IF(U126=0,\"z\",\" \")","v":"z"},null,null,null,null,{"$f":"AI124","v":0},null,{"$f":"SUMIFS($F$35:$F$65,$C$35:$C$65,\"=500\",$B$35:$B$65,AM110,$D$35:$D$65,AJ124,$E$35:$E$65,AI124)","v":0},{"$f":"AJ124","v":3},null,{"$f":"AK124","v":2.3199999999999998},{"$f":"SUMIFS($L$35:$L$65,$B$35:$B$65,AM124,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ124,$E$35:$E$65,AI124)","v":0},null,null,{"$f":"SUMIFS($O$35:$O$65,$B$35:$B$65,AM124,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ124,$E$35:$E$65,AI124)","v":0},null,null,{"$f":"AC124+AC125-AB124","v":0},null,null,{"$f":"SUMIFS($U$35:$U$65,$B$35:$B$65,AM124,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ124,$E$35:$E$65,AI124)","v":0},null,null,null,{"$f":"SUMIFS($Y$35:$Y$65,$B$35:$B$65,AM124,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ124,$E$35:$E$65,AI124)","v":0},null,{"$f":"AC124+AC125-AB124","v":0},{"$f":"AG124*AO124/1000/2*AK124","v":0},{"$f":"SUMIFS($Z$35:$Z$65,$B$35:$B$65,AM124,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ124,$E$35:$E$65,AI124)","v":0},null,null,null,{"$f":"SUMIFS($H$9:$H$31,$E$9:$E$31,AI124)","v":0},"Труба ДУ15",null,3,2.3199999999999998,1.1599999999999999,6000,"<>6000",5]
[{"$f":"IF(U126=0,\"z\",\" \")","v":"z"},null,null,null,null,null,"Остатки",null,null,null,null,{"$f":"SUMIFS($L$35:$L$65,$B$35:$B$65,AN124,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ124,$E$35:$E$65,AI124)","v":0},null,null,{"$f":"SUMIFS($O$35:$O$65,$B$35:$B$65,AN124,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ124,$E$35:$E$65,AI124)","v":0},null,null,null,null,null,{"$f":"SUMIFS($U$35:$U$65,$B$35:$B$65,AN124,C74:C104,\"=500\",$D$35:$D$65,AJ124,$E$35:$E$65,AI124)","v":0},null,null,null,{"$f":"SUMIFS($Y$35:$Y$65,$B$35:$B$65,AN124,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ124,$E$35:$E$65,AI124)","v":0},null,null,null,{"$f":"SUMIFS($Z$35:$Z$65,$B$35:$B$65,AN124,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ124,$E$35:$E$65,AI124)","v":0}]
[{"$f":"IF(U126=0,\"z\",\" \")","v":"z"},null,null,null,null,null,"общая",null,null,null,null,{"$f":"L124+L125","v":0},null,null,{"$f":"O124+O125","v":0},null,null,{"$f":"R124","v":0},null,null,{"$f":"U124+U125+AB124","v":0},null,null,null,{"$f":"Y124+Y125","v":0}]
[{"$f":"IF(U129=0,\"z\",\" \")","v":"z"},null,null,null,null,{"$f":"AI127","v":0},null,{"$f":"SUMIFS($F$35:$F$65,$C$35:$C$65,\"=500\",$B$35:$B$65,AM113,$D$35:$D$65,AJ127,$E$35:$E$65,AI127)","v":0},{"$f":"AJ127","v":0},null,{"$f":"AK127","v":0},{"$f":"SUMIFS($L$35:$L$65,$B$35:$B$65,AM127,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ127,$E$35:$E$65,AI127)","v":0},null,null,{"$f":"SUMIFS($O$35:$O$65,$B$35:$B$65,AM127,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ127,$E$35:$E$65,AI127)","v":0},null,null,{"$f":"AC127+AC128-AB127","v":0},null,null,{"$f":"SUMIFS($U$35:$U$65,$B$35:$B$65,AM127,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ127,$E$35:$E$65,AI127)","v":0},null,null,null,{"$f":"SUMIFS($Y$35:$Y$65,$B$35:$B$65,AM127,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ127,$E$35:$E$65,AI127)","v":0},null,{"$f":"AC127+AC128-AB127","v":0},{"$f":"AG127*AO127/1000/2*AK127","v":0},{"$f":"SUMIFS($Z$35:$Z$65,$B$35:$B$65,AM127,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ127,$E$35:$E$65,AI127)","v":0}]
[{"$f":"IF(U129=0,\"z\",\" \")","v":"z"},null,null,null,null,null,"Остатки",null,null,null,null,{"$f":"SUMIFS($L$35:$L$65,$B$35:$B$65,AN127,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ127,$E$35:$E$65,AI127)","v":0},null,null,{"$f":"SUMIFS($O$35:$O$65,$B$35:$B$65,AN127,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ127,$E$35:$E$65,AI127)","v":0},null,null,null,null,null,{"$f":"SUMIFS($U$35:$U$65,$B$35:$B$65,AN127,C77:C107,\"=500\",$D$35:$D$65,AJ127,$E$35:$E$65,AI127)","v":0},null,null,null,{"$f":"SUMIFS($Y$35:$Y$65,$B$35:$B$65,AN127,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ127,$E$35:$E$65,AI127)","v":0},null,null,null,{"$f":"SUMIFS($Z$35:$Z$65,$B$35:$B$65,AN127,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ127,$E$35:$E$65,AI127)","v":0}]
[{"$f":"IF(U129=0,\"z\",\" \")","v":"z"},null,null,null,null,null,"общая",null,null,null,null,{"$f":"L127+L128","v":0},null,null,{"$f":"O127+O128","v":0},null,null,{"$f":"R127","v":0},null,null,{"$f":"U127+U128+AB127","v":0},null,null,null,{"$f":"Y127+Y128","v":0}]
[{"$f":"IF(U132=0,\"z\",\" \")","v":"z"},null,null,null,null,{"$f":"AI130","v":0},null,{"$f":"SUMIFS($F$35:$F$65,$C$35:$C$65,\"=500\",$B$35:$B$65,AM116,$D$35:$D$65,AJ130,$E$35:$E$65,AI130)","v":0},{"$f":"AJ130","v":0},null,{"$f":"AK130","v":0},{"$f":"SUMIFS($L$35:$L$65,$B$35:$B$65,AM130,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ130,$E$35:$E$65,AI130)","v":0},null,null,{"$f":"SUMIFS($O$35:$O$65,$B$35:$B$65,AM130,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ130,$E$35:$E$65,AI130)","v":0},null,null,{"$f":"AC130+AC131-AB130","v":0},null,null,{"$f":"SUMIFS($U$35:$U$65,$B$35:$B$65,AM130,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ130,$E$35:$E$65,AI130)","v":0},null,null,null,{"$f":"SUMIFS($Y$35:$Y$65,$B$35:$B$65,AM130,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ130,$E$35:$E$65,AI130)","v":0},null,{"$f":"AC130+AC131-AB130","v":0},{"$f":"AG130*AO130/1000/2*AK130","v":0},{"$f":"SUMIFS($Z$35:$Z$65,$B$35:$B$65,AM130,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ130,$E$35:$E$65,AI130)","v":0}]
[{"$f":"IF(U132=0,\"z\",\" \")","v":"z"},null,null,null,null,null,"Остатки",null,null,null,null,{"$f":"SUMIFS($L$35:$L$65,$B$35:$B$65,AN130,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ130,$E$35:$E$65,AI130)","v":0},null,null,{"$f":"SUMIFS($O$35:$O$65,$B$35:$B$65,AN130,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ130,$E$35:$E$65,AI130)","v":0},null,null,null,null,null,{"$f":"SUMIFS($U$35:$U$65,$B$35:$B$65,AN130,C80:C110,\"=500\",$D$35:$D$65,AJ130,$E$35:$E$65,AI130)","v":0},null,null,null,{"$f":"SUMIFS($Y$35:$Y$65,$B$35:$B$65,AN130,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ130,$E$35:$E$65,AI130)","v":0},null,null,null,{"$f":"SUMIFS($Z$35:$Z$65,$B$35:$B$65,AN130,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ130,$E$35:$E$65,AI130)","v":0}]
[{"$f":"IF(U132=0,\"z\",\" \")","v":"z"},null,null,null,null,null,"общая",null,null,null,null,{"$f":"L130+L131","v":0},null,null,{"$f":"O130+O131","v":0},null,null,{"$f":"R130","v":0},null,null,{"$f":"U130+U131+AB130","v":0},null,null,null,{"$f":"Y130+Y131","v":0}]
[{"$f":"IF(U135=0,\"z\",\" \")","v":"z"},null,null,null,null,{"$f":"AI133","v":0},null,{"$f":"SUMIFS($F$35:$F$65,$C$35:$C$65,\"=500\",$B$35:$B$65,AM119,$D$35:$D$65,AJ133,$E$35:$E$65,AI133)","v":0},{"$f":"AJ133","v":0},null,{"$f":"AK133","v":0},{"$f":"SUMIFS($L$35:$L$65,$B$35:$B$65,AM133,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ133,$E$35:$E$65,AI133)","v":0},null,null,{"$f":"SUMIFS($O$35:$O$65,$B$35:$B$65,AM133,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ133,$E$35:$E$65,AI133)","v":0},null,null,{"$f":"AC133+AC134-AB133","v":0},null,null,{"$f":"SUMIFS($U$35:$U$65,$B$35:$B$65,AM133,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ133,$E$35:$E$65,AI133)","v":0},null,null,null,{"$f":"SUMIFS($Y$35:$Y$65,$B$35:$B$65,AM133,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ133,$E$35:$E$65,AI133)","v":0},null,{"$f":"AC133+AC134-AB133","v":0},{"$f":"AG133*AO133/1000/2*AK133","v":0},{"$f":"SUMIFS($Z$35:$Z$65,$B$35:$B$65,AM133,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ133,$E$35:$E$65,AI133)","v":0}]
[{"$f":"IF(U135=0,\"z\",\" \")","v":"z"},null,null,null,null,null,"Остатки",null,null,null,null,{"$f":"SUMIFS($L$35:$L$65,$B$35:$B$65,AN133,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ133,$E$35:$E$65,AI133)","v":0},null,null,{"$f":"SUMIFS($O$35:$O$65,$B$35:$B$65,AN133,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ133,$E$35:$E$65,AI133)","v":0},null,null,null,null,null,{"$f":"SUMIFS($U$35:$U$65,$B$35:$B$65,AN133,C83:C113,\"=500\",$D$35:$D$65,AJ133,$E$35:$E$65,AI133)","v":0},null,null,null,{"$f":"SUMIFS($Y$35:$Y$65,$B$35:$B$65,AN133,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ133,$E$35:$E$65,AI133)","v":0},null,null,null,{"$f":"SUMIFS($Z$35:$Z$65,$B$35:$B$65,AN133,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ133,$E$35:$E$65,AI133)","v":0}]
[{"$f":"IF(U135=0,\"z\",\" \")","v":"z"},null,null,null,null,null,"общая",null,null,null,null,{"$f":"L133+L134","v":0},null,null,{"$f":"O133+O134","v":0},null,null,{"$f":"R133","v":0},null,null,{"$f":"U133+U134+AB133","v":0},null,null,null,{"$f":"Y133+Y134","v":0}]
[{"$f":"IF(U138=0,\"z\",\" \")","v":"z"},null,null,null,null,{"$f":"AI136","v":"Труба 17х17 чм, 2,0"},null,{"$f":"SUMIFS($F$35:$F$65,$C$35:$C$65,\"=500\",$B$35:$B$65,AM86,$D$35:$D$65,AJ136,$E$35:$E$65,AI136)","v":0},{"$f":"AJ136","v":2},null,{"$f":"AK136","v":1.88},{"$f":"SUMIFS($L$35:$L$65,$B$35:$B$65,AM136,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ136,$E$35:$E$65,AI136)","v":0},null,null,{"$f":"SUMIFS($O$35:$O$65,$B$35:$B$65,AM136,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ136,$E$35:$E$65,AI136)","v":0},null,null,{"$f":"AC136+AC137-AB136","v":0},null,null,{"$f":"SUMIFS($U$35:$U$65,$B$35:$B$65,AM136,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ136,$E$35:$E$65,AI136)","v":0},null,null,null,{"$f":"SUMIFS($Y$35:$Y$65,$B$35:$B$65,AM136,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ136,$E$35:$E$65,AI136)","v":0},null,{"$f":"AC136+AC137-AB136","v":0},{"$f":"AG136*AO136/1000/2*AK136","v":0},{"$f":"SUMIFS($Z$35:$Z$65,$B$35:$B$65,AM136,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ136,$E$35:$E$65,AI136)","v":0},null,null,null,{"$f":"SUMIFS($H$9:$H$31,$E$9:$E$31,AI136)","v":0},"Труба 17х17х2","Труба 17х17 чм, 2,0",2,1.88,0.94,6000,{"$f":"CONCATENATE(\"<>\",AM136)","v":"<>6000"},5]
[{"$f":"IF(U138=0,\"z\",\" \")","v":"z"},null,null,null,null,null,"Остатки",null,null,null,null,{"$f":"SUMIFS($L$35:$L$65,$B$35:$B$65,AN136,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ136,$E$35:$E$65,AI136)","v":0},null,null,{"$f":"SUMIFS($O$35:$O$65,$B$35:$B$65,AN136,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ136,$E$35:$E$65,AI136)","v":0},null,null,null,null,null,{"$f":"SUMIFS($U$35:$U$65,$B$35:$B$65,AN136,C50:C80,\"=500\",$D$35:$D$65,AJ136,$E$35:$E$65,AI136)","v":0},null,null,null,{"$f":"SUMIFS($Y$35:$Y$65,$B$35:$B$65,AN136,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ136,$E$35:$E$65,AI136)","v":0},null,null,null,{"$f":"SUMIFS($Z$35:$Z$65,$B$35:$B$65,AN136,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ136,$E$35:$E$65,AI136)","v":0}]
[{"$f":"IF(U138=0,\"z\",\" \")","v":"z"},null,null,null,null,null,"общая",null,null,null,null,{"$f":"L136+L137","v":0},null,null,{"$f":"O136+O137","v":0},null,null,{"$f":"R136","v":0},null,null,{"$f":"U136+U137+AB136","v":0},null,null,null,{"$f":"Y136+Y137","v":0}]
[{"$f":"IF(U141=0,\"z\",\" \")","v":"z"},null,null,null,null,{"$f":"AI139","v":"Труба 20х20 чм, 0.8 мм"},null,{"$f":"SUMIFS($F$35:$F$65,$C$35:$C$65,\"=500\",$B$35:$B$65,AM89,$D$35:$D$65,AJ139,$E$35:$E$65,AI139)","v":0},{"$f":"AJ139","v":0.8},null,{"$f":"AK139","v":1.006},{"$f":"SUMIFS($L$35:$L$65,$B$35:$B$65,AM139,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ139,$E$35:$E$65,AI139)","v":0},null,null,{"$f":"SUMIFS($O$35:$O$65,$B$35:$B$65,AM139,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ139,$E$35:$E$65,AI139)","v":0},null,null,{"$f":"AC139+AC140-AB139","v":0},null,null,{"$f":"SUMIFS($U$35:$U$65,$B$35:$B$65,AM139,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ139,$E$35:$E$65,AI139)","v":0},null,null,null,{"$f":"SUMIFS($Y$35:$Y$65,$B$35:$B$65,AM139,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ139,$E$35:$E$65,AI139)","v":0},null,{"$f":"AC139+AC140-AB139","v":0},{"$f":"AG139*AO139/1000/2*AK139","v":0},{"$f":"SUMIFS($Z$35:$Z$65,$B$35:$B$65,AM139,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ139,$E$35:$E$65,AI139)","v":0},null,null,null,{"$f":"SUMIFS($H$9:$H$31,$E$9:$E$31,AI139)","v":0},"Труба 20х20х0,8","Труба 20х20 чм, 0.8 мм",0.8,1.006,0.503,6000,{"$f":"CONCATENATE(\"<>\",AM139)","v":"<>6000"},5]
[{"$f":"IF(U141=0,\"z\",\" \")","v":"z"},null,null,null,null,null,"Остатки",null,null,null,null,{"$f":"SUMIFS($L$35:$L$65,$B$35:$B$65,AN139,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ139,$E$35:$E$65,AI139)","v":0},null,null,{"$f":"SUMIFS($O$35:$O$65,$B$35:$B$65,AN139,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ139,$E$35:$E$65,AI139)","v":0},null,null,null,null,null,{"$f":"SUMIFS($U$35:$U$65,$B$35:$B$65,AN139,C53:C83,\"=500\",$D$35:$D$65,AJ139,$E$35:$E$65,AI139)","v":0},null,null,null,{"$f":"SUMIFS($Y$35:$Y$65,$B$35:$B$65,AN139,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ139,$E$35:$E$65,AI139)","v":0},null,null,null,{"$f":"SUMIFS($Z$35:$Z$65,$B$35:$B$65,AN139,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ139,$E$35:$E$65,AI139)","v":0}]
[{"$f":"IF(U141=0,\"z\",\" \")","v":"z"},null,null,null,null,null,"общая",null,null,null,null,{"$f":"L139+L140","v":0},null,null,{"$f":"O139+O140","v":0},null,null,{"$f":"R139","v":0},null,null,{"$f":"U139+U140+AB139","v":0},null,null,null,{"$f":"Y139+Y140","v":0}]
[{"$f":"IF(U144=0,\"z\",\" \")","v":" "},null,null,null,null,{"$f":"AI142","v":"Труба 20х20 чм, 1.5 мм"},null,{"$f":"SUMIFS($F$35:$F$65,$C$35:$C$65,\"=500\",$B$35:$B$65,AM92,$D$35:$D$65,AJ142,$E$35:$E$65,AI142)","v":0},{"$f":"AJ142","v":1.5},null,{"$f":"AK142","v":1.8720000000000001},{"$f":"SUMIFS($L$35:$L$65,$B$35:$B$65,AM142,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ142,$E$35:$E$65,AI142)","v":0},null,null,{"$f":"SUMIFS($O$35:$O$65,$B$35:$B$65,AM142,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ142,$E$35:$E$65,AI142)","v":0},null,null,{"$f":"AC142+AC143-AB142","v":-9.3600000000000017E-2},null,null,{"$f":"SUMIFS($U$35:$U$65,$B$35:$B$65,AM142,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ142,$E$35:$E$65,AI142)","v":0},null,null,null,{"$f":"SUMIFS($Y$35:$Y$65,$B$35:$B$65,AM142,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ142,$E$35:$E$65,AI142)","v":0},null,{"$f":"AC142+AC143-AB142","v":-9.3600000000000017E-2},{"$f":"AG142*AO142/1000/2*AK142","v":9.3600000000000017E-2},{"$f":"SUMIFS($Z$35:$Z$65,$B$35:$B$65,AM142,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ142,$E$35:$E$65,AI142)","v":0},null,null,null,{"$f":"SUMIFS($H$9:$H$31,$E$9:$E$31,AI142)","v":20},"Труба 20х20х1,5","Труба 20х20 чм, 1.5 мм",1.5,1.8720000000000001,0.93600000000000005,6000,{"$f":"CONCATENATE(\"<>\",AM142)","v":"<>6000"},5]
[{"$f":"IF(U144=0,\"z\",\" \")","v":" "},null,null,null,null,null,"Остатки",null,null,null,null,{"$f":"SUMIFS($L$35:$L$65,$B$35:$B$65,AN142,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ142,$E$35:$E$65,AI142)","v":0},null,null,{"$f":"SUMIFS($O$35:$O$65,$B$35:$B$65,AN142,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ142,$E$35:$E$65,AI142)","v":0},null,null,null,null,null,{"$f":"SUMIFS($U$35:$U$65,$B$35:$B$65,AN142,C56:C86,\"=500\",$D$35:$D$65,AJ142,$E$35:$E$65,AI142)","v":0},null,null,null,{"$f":"SUMIFS($Y$35:$Y$65,$B$35:$B$65,AN142,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ142,$E$35:$E$65,AI142)","v":0},null,null,null,{"$f":"SUMIFS($Z$35:$Z$65,$B$35:$B$65,AN142,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ142,$E$35:$E$65,AI142)","v":0}]
[{"$f":"IF(U144=0,\"z\",\" \")","v":" "},null,null,null,null,null,"общая",null,null,null,null,{"$f":"L142+L143","v":0},null,null,{"$f":"O142+O143","v":0},null,null,{"$f":"R142","v":-9.3600000000000017E-2},null,null,{"$f":"U142+U143+AB142","v":9.3600000000000017E-2},null,null,null,{"$f":"Y142+Y143","v":0}]
[{"$f":"IF(U147=0,\"z\",\" \")","v":"z"},null,null,null,null,{"$f":"AI145","v":"Труба 20х20 чм, 2.0 мм"},null,{"$f":"SUMIFS($F$35:$F$65,$C$35:$C$65,\"=500\",$B$35:$B$65,AM95,$D$35:$D$65,AJ145,$E$35:$E$65,AI145)","v":0},{"$f":"AJ145","v":2},null,{"$f":"AK145","v":2.2519999999999998},{"$f":"SUMIFS($L$35:$L$65,$B$35:$B$65,AM145,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ145,$E$35:$E$65,AI145)","v":0},null,null,{"$f":"SUMIFS($O$35:$O$65,$B$35:$B$65,AM145,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ145,$E$35:$E$65,AI145)","v":0},null,null,{"$f":"AC145+AC146-AB145","v":0},null,null,{"$f":"SUMIFS($U$35:$U$65,$B$35:$B$65,AM145,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ145,$E$35:$E$65,AI145)","v":0},null,null,null,{"$f":"SUMIFS($Y$35:$Y$65,$B$35:$B$65,AM145,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ145,$E$35:$E$65,AI145)","v":0},null,{"$f":"AC145+AC146-AB145","v":0},{"$f":"AG145*AO145/1000/2*AK145","v":0},{"$f":"SUMIFS($Z$35:$Z$65,$B$35:$B$65,AM145,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ145,$E$35:$E$65,AI145)","v":0},null,null,null,{"$f":"SUMIFS($H$9:$H$31,$E$9:$E$31,AI145)","v":0},"Труба 20х20х2","Труба 20х20 чм, 2.0 мм",2,2.2519999999999998,1.1259999999999999,6000,{"$f":"CONCATENATE(\"<>\",AM145)","v":"<>6000"},5]
[{"$f":"IF(U147=0,\"z\",\" \")","v":"z"},null,null,null,null,null,"Остатки",null,null,null,null,{"$f":"SUMIFS($L$35:$L$65,$B$35:$B$65,AN145,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ145,$E$35:$E$65,AI145)","v":0},null,null,{"$f":"SUMIFS($O$35:$O$65,$B$35:$B$65,AN145,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ145,$E$35:$E$65,AI145)","v":0},null,null,null,null,null,{"$f":"SUMIFS($U$35:$U$65,$B$35:$B$65,AN145,C59:C89,\"=500\",$D$35:$D$65,AJ145,$E$35:$E$65,AI145)","v":0},null,null,null,{"$f":"SUMIFS($Y$35:$Y$65,$B$35:$B$65,AN145,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ145,$E$35:$E$65,AI145)","v":0},null,null,null,{"$f":"SUMIFS($Z$35:$Z$65,$B$35:$B$65,AN145,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ145,$E$35:$E$65,AI145)","v":0}]
[{"$f":"IF(U147=0,\"z\",\" \")","v":"z"},null,null,null,null,null,"общая",null,null,null,null,{"$f":"L145+L146","v":0},null,null,{"$f":"O145+O146","v":0},null,null,{"$f":"R145","v":0},null,null,{"$f":"U145+U146+AB145","v":0},null,null,null,{"$f":"Y145+Y146","v":0}]
[{"$f":"IF(U150=0,\"z\",\" \")","v":"z"},null,null,null,null,{"$f":"AI148","v":"Труба 25х25 чм, 1.0 мм"},null,{"$f":"SUMIFS($F$35:$F$65,$C$35:$C$65,\"=500\",$B$35:$B$65,AM98,$D$35:$D$65,AJ148,$E$35:$E$65,AI148)","v":0},{"$f":"AJ148","v":1},null,{"$f":"AK148","v":1.548},{"$f":"SUMIFS($L$35:$L$65,$B$35:$B$65,AM148,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ148,$E$35:$E$65,AI148)","v":0},null,null,{"$f":"SUMIFS($O$35:$O$65,$B$35:$B$65,AM148,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ148,$E$35:$E$65,AI148)","v":0},null,null,{"$f":"AC148+AC149-AB148","v":0},null,null,{"$f":"SUMIFS($U$35:$U$65,$B$35:$B$65,AM148,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ148,$E$35:$E$65,AI148)","v":0},null,null,null,{"$f":"SUMIFS($Y$35:$Y$65,$B$35:$B$65,AM148,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ148,$E$35:$E$65,AI148)","v":0},null,{"$f":"AC148+AC149-AB148","v":0},{"$f":"AG148*AO148/1000/2*AK148","v":0},{"$f":"SUMIFS($Z$35:$Z$65,$B$35:$B$65,AM148,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ148,$E$35:$E$65,AI148)","v":0},null,null,null,{"$f":"SUMIFS($H$9:$H$31,$E$9:$E$31,AI148)","v":0},"Труба 25х25х1","Труба 25х25 чм, 1.0 мм",1,1.548,0.77400000000000002,6000,{"$f":"CONCATENATE(\"<>\",AM148)","v":"<>6000"},5]
[{"$f":"IF(U150=0,\"z\",\" \")","v":"z"},null,null,null,null,null,"Остатки",null,null,null,null,{"$f":"SUMIFS($L$35:$L$65,$B$35:$B$65,AN148,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ148,$E$35:$E$65,AI148)","v":0},null,null,{"$f":"SUMIFS($O$35:$O$65,$B$35:$B$65,AN148,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ148,$E$35:$E$65,AI148)","v":0},null,null,null,null,null,{"$f":"SUMIFS($U$35:$U$65,$B$35:$B$65,AN148,C62:C92,\"=500\",$D$35:$D$65,AJ148,$E$35:$E$65,AI148)","v":0},null,null,null,{"$f":"SUMIFS($Y$35:$Y$65,$B$35:$B$65,AN148,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ148,$E$35:$E$65,AI148)","v":0},null,null,null,{"$f":"SUMIFS($Z$35:$Z$65,$B$35:$B$65,AN148,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ148,$E$35:$E$65,AI148)","v":0}]
[{"$f":"IF(U150=0,\"z\",\" \")","v":"z"},null,null,null,null,null,"общая",null,null,null,null,{"$f":"L148+L149","v":0},null,null,{"$f":"O148+O149","v":0},null,null,{"$f":"R148","v":0},null,null,{"$f":"U148+U149+AB148","v":0},null,null,null,{"$f":"Y148+Y149","v":0}]
[{"$f":"IF(U153=0,\"z\",\" \")","v":"z"},null,null,null,null,{"$f":"AI151","v":"Труба 40х40 чм, 2.0 мм"},null,{"$f":"SUMIFS($F$35:$F$65,$C$35:$C$65,\"=500\",$B$35:$B$65,AM77,$D$35:$D$65,AJ151,$E$35:$E$65,AI151)","v":0},{"$f":"AJ151","v":2},null,{"$f":"AK151","v":5.08},{"$f":"SUMIFS($L$35:$L$65,$B$35:$B$65,AM151,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ151,$E$35:$E$65,AI151)","v":0},null,null,{"$f":"SUMIFS($O$35:$O$65,$B$35:$B$65,AM151,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ151,$E$35:$E$65,AI151)","v":0},null,null,{"$f":"AC151+AC152-AB151","v":0},null,null,{"$f":"SUMIFS($U$35:$U$65,$B$35:$B$65,AM151,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ151,$E$35:$E$65,AI151)","v":0},null,null,null,{"$f":"SUMIFS($Y$35:$Y$65,$B$35:$B$65,AM151,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ151,$E$35:$E$65,AI151)","v":0},null,{"$f":"AC151+AC152-AB151","v":0},{"$f":"AG151*AO151/1000/2*AK151","v":0},{"$f":"SUMIFS($Z$35:$Z$65,$B$35:$B$65,AM151,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ151,$E$35:$E$65,AI151)","v":0},null,null,null,{"$f":"SUMIFS($H$9:$H$31,$E$9:$E$31,AI151)","v":0},"Труба 40х40х2","Труба 40х40 чм, 2.0 мм",2,5.08,2.54,6000,"<>6000",5]
[{"$f":"IF(U153=0,\"z\",\" \")","v":"z"},null,null,null,null,null,"Остатки",null,null,null,null,{"$f":"SUMIFS($L$35:$L$65,$B$35:$B$65,AN151,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ151,$E$35:$E$65,AI151)","v":0},null,null,{"$f":"SUMIFS($O$35:$O$65,$B$35:$B$65,AN151,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ151,$E$35:$E$65,AI151)","v":0},null,null,null,null,null,{"$f":"SUMIFS($U$35:$U$65,$B$35:$B$65,AN151,C41:C71,\"=500\",$D$35:$D$65,AJ151,$E$35:$E$65,AI151)","v":0},null,null,null,{"$f":"SUMIFS($Y$35:$Y$65,$B$35:$B$65,AN151,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ151,$E$35:$E$65,AI151)","v":0},null,null,null,{"$f":"SUMIFS($Z$35:$Z$65,$B$35:$B$65,AN151,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ151,$E$35:$E$65,AI151)","v":0}]
[{"$f":"IF(U153=0,\"z\",\" \")","v":"z"},null,null,null,null,null,"общая",null,null,null,null,{"$f":"L151+L152","v":0},null,null,{"$f":"O151+O152","v":0},null,null,{"$f":"R151","v":0},null,null,{"$f":"U151+U152+AB151","v":0},null,null,null,{"$f":"Y151+Y152","v":0}]
[{"$f":"IF(U156=0,\"z\",\" \")","v":"z"},null,null,null,null,{"$f":"AI154","v":0},null,{"$f":"SUMIFS($F$35:$F$65,$C$35:$C$65,\"=500\",$B$35:$B$65,AM80,$D$35:$D$65,AJ154,$E$35:$E$65,AI154)","v":0},{"$f":"AJ154","v":1.5},null,{"$f":"AK154","v":1.9179999999999999},{"$f":"SUMIFS($L$35:$L$65,$B$35:$B$65,AM154,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ154,$E$35:$E$65,AI154)","v":0},null,null,{"$f":"SUMIFS($O$35:$O$65,$B$35:$B$65,AM154,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ154,$E$35:$E$65,AI154)","v":0},null,null,{"$f":"AC154+AC155-AB154","v":0},null,null,{"$f":"SUMIFS($U$35:$U$65,$B$35:$B$65,AM154,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ154,$E$35:$E$65,AI154)","v":0},null,null,null,{"$f":"SUMIFS($Y$35:$Y$65,$B$35:$B$65,AM154,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ154,$E$35:$E$65,AI154)","v":0},null,{"$f":"AC154+AC155-AB154","v":0},{"$f":"AG154*AO154/1000/2*AK154","v":0},{"$f":"SUMIFS($Z$35:$Z$65,$B$35:$B$65,AM154,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ154,$E$35:$E$65,AI154)","v":0},null,null,null,{"$f":"SUMIFS($H$9:$H$31,$E$9:$E$31,AI154)","v":0},"Труба ø 30х15",null,1.5,1.9179999999999999,0.95899999999999996,6000,"<>6000",5]
[{"$f":"IF(U156=0,\"z\",\" \")","v":"z"},null,null,null,null,null,"Остатки",null,null,null,null,{"$f":"SUMIFS($L$35:$L$65,$B$35:$B$65,AN154,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ154,$E$35:$E$65,AI154)","v":0},null,null,{"$f":"SUMIFS($O$35:$O$65,$B$35:$B$65,AN154,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ154,$E$35:$E$65,AI154)","v":0},null,null,null,null,null,{"$f":"SUMIFS($U$35:$U$65,$B$35:$B$65,AN154,C44:C74,\"=500\",$D$35:$D$65,AJ154,$E$35:$E$65,AI154)","v":0},null,null,null,{"$f":"SUMIFS($Y$35:$Y$65,$B$35:$B$65,AN154,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ154,$E$35:$E$65,AI154)","v":0},null,null,null,{"$f":"SUMIFS($Z$35:$Z$65,$B$35:$B$65,AN154,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ154,$E$35:$E$65,AI154)","v":0}]
[{"$f":"IF(U156=0,\"z\",\" \")","v":"z"},null,null,null,null,null,"общая",null,null,null,null,{"$f":"L154+L155","v":0},null,null,{"$f":"O154+O155","v":0},null,null,{"$f":"R154","v":0},null,null,{"$f":"U154+U155+AB154","v":0},null,null,null,{"$f":"Y154+Y155","v":0}]
[{"$f":"IF(U159=0,\"z\",\" \")","v":"z"},null,null,null,null,{"$f":"AI157","v":"Труба 50 чм, 1.2 мм"},null,{"$f":"SUMIFS($F$35:$F$65,$C$35:$C$65,\"=500\",$B$35:$B$65,AM83,$D$35:$D$65,AJ157,$E$35:$E$65,AI157)","v":0},{"$f":"AJ157","v":1.2},null,{"$f":"AK157","v":2.88},{"$f":"SUMIFS($L$35:$L$65,$B$35:$B$65,AM157,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ157,$E$35:$E$65,AI157)","v":0},null,null,{"$f":"SUMIFS($O$35:$O$65,$B$35:$B$65,AM157,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ157,$E$35:$E$65,AI157)","v":0},null,null,{"$f":"AC157+AC158-AB157","v":0},null,null,{"$f":"SUMIFS($U$35:$U$65,$B$35:$B$65,AM157,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ157,$E$35:$E$65,AI157)","v":0},null,null,null,{"$f":"SUMIFS($Y$35:$Y$65,$B$35:$B$65,AM157,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ157,$E$35:$E$65,AI157)","v":0},null,{"$f":"AC157+AC158-AB157","v":0},{"$f":"AG157*AO157/1000/2*AK157","v":0},{"$f":"SUMIFS($Z$35:$Z$65,$B$35:$B$65,AM157,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ157,$E$35:$E$65,AI157)","v":0},null,null,null,{"$f":"SUMIFS($H$9:$H$31,$E$9:$E$31,AI157)","v":0},"Труба ø50х1.2","Труба 50 чм, 1.2 мм",1.2,2.88,1.44,6000,"<>6000",5]
[{"$f":"IF(U159=0,\"z\",\" \")","v":"z"},null,null,null,null,null,"Остатки",null,null,null,null,{"$f":"SUMIFS($L$35:$L$65,$B$35:$B$65,AN157,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ157,$E$35:$E$65,AI157)","v":0},null,null,{"$f":"SUMIFS($O$35:$O$65,$B$35:$B$65,AN157,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ157,$E$35:$E$65,AI157)","v":0},null,null,null,null,null,{"$f":"SUMIFS($U$35:$U$65,$B$35:$B$65,AN157,C47:C77,\"=500\",$D$35:$D$65,AJ157,$E$35:$E$65,AI157)","v":0},null,null,null,{"$f":"SUMIFS($Y$35:$Y$65,$B$35:$B$65,AN157,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ157,$E$35:$E$65,AI157)","v":0},null,null,null,{"$f":"SUMIFS($Z$35:$Z$65,$B$35:$B$65,AN157,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ157,$E$35:$E$65,AI157)","v":0}]
[{"$f":"IF(U159=0,\"z\",\" \")","v":"z"},null,null,null,null,null,"общая",null,null,null,null,{"$f":"L157+L158","v":0},null,null,{"$f":"O157+O158","v":0},null,null,{"$f":"R157","v":0},null,null,{"$f":"U157+U158+AB157","v":0},null,null,null,{"$f":"Y157+Y158","v":0}]
[{"$f":"IF(U162=0,\"z\",\" \")","v":"z"},null,null,null,null,{"$f":"AI160","v":"Труба 25х25 чм, 1.2 мм"},null,{"$f":"SUMIFS($F$35:$F$65,$C$35:$C$65,\"=500\",$B$35:$B$65,AM86,$D$35:$D$65,AJ160,$E$35:$E$65,AI160)","v":0},{"$f":"AJ160","v":1.2},null,{"$f":"AK160","v":1.8575999999999999},{"$f":"SUMIFS($L$35:$L$65,$B$35:$B$65,AM160,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ160,$E$35:$E$65,AI160)","v":0},null,null,{"$f":"SUMIFS($O$35:$O$65,$B$35:$B$65,AM160,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ160,$E$35:$E$65,AI160)","v":0},null,null,{"$f":"AC160+AC161-AB160","v":0},null,null,{"$f":"SUMIFS($U$35:$U$65,$B$35:$B$65,AM160,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ160,$E$35:$E$65,AI160)","v":0},null,null,null,{"$f":"SUMIFS($Y$35:$Y$65,$B$35:$B$65,AM160,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ160,$E$35:$E$65,AI160)","v":0},null,{"$f":"AC160+AC161-AB160","v":0},{"$f":"AG160*AO160/1000/2*AK160","v":0},{"$f":"SUMIFS($Z$35:$Z$65,$B$35:$B$65,AM160,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ160,$E$35:$E$65,AI160)","v":0},null,null,null,{"$f":"SUMIFS($H$9:$H$31,$E$9:$E$31,AI160)","v":0},"Труба 25х25х1,2","Труба 25х25 чм, 1.2 мм",1.2,1.8575999999999999,0.92879999999999996,6000,{"$f":"CONCATENATE(\"<>\",AM160)","v":"<>6000"},5]
[{"$f":"IF(U162=0,\"z\",\" \")","v":"z"},null,null,null,null,null,"Остатки",null,null,null,null,{"$f":"SUMIFS($L$35:$L$65,$B$35:$B$65,AN160,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ160,$E$35:$E$65,AI160)","v":0},null,null,{"$f":"SUMIFS($O$35:$O$65,$B$35:$B$65,AN160,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ160,$E$35:$E$65,AI160)","v":0},null,null,null,null,null,{"$f":"SUMIFS($U$35:$U$65,$B$35:$B$65,AN160,C50:C80,\"=500\",$D$35:$D$65,AJ160,$E$35:$E$65,AI160)","v":0},null,null,null,{"$f":"SUMIFS($Y$35:$Y$65,$B$35:$B$65,AN160,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ160,$E$35:$E$65,AI160)","v":0},null,null,null,{"$f":"SUMIFS($Z$35:$Z$65,$B$35:$B$65,AN160,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ160,$E$35:$E$65,AI160)","v":0}]
[{"$f":"IF(U162=0,\"z\",\" \")","v":"z"},null,null,null,null,null,"общая",null,null,null,null,{"$f":"L160+L161","v":0},null,null,{"$f":"O160+O161","v":0},null,null,{"$f":"R160","v":0},null,null,{"$f":"U160+U161+AB160","v":0},null,null,null,{"$f":"Y160+Y161","v":0}]
[{"$f":"IF(U165=0,\"z\",\" \")","v":"z"},null,null,null,null,{"$f":"AI163","v":"Труба 25х25 чм, 2.0 мм"},null,{"$f":"SUMIFS($F$35:$F$65,$C$35:$C$65,\"=500\",$B$35:$B$65,AM89,$D$35:$D$65,AJ163,$E$35:$E$65,AI163)","v":0},{"$f":"AJ163","v":2},null,{"$f":"AK163","v":3.0960000000000001},{"$f":"SUMIFS($L$35:$L$65,$B$35:$B$65,AM163,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ163,$E$35:$E$65,AI163)","v":0},null,null,{"$f":"SUMIFS($O$35:$O$65,$B$35:$B$65,AM163,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ163,$E$35:$E$65,AI163)","v":0},null,null,{"$f":"AC163+AC164-AB163","v":0},null,null,{"$f":"SUMIFS($U$35:$U$65,$B$35:$B$65,AM163,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ163,$E$35:$E$65,AI163)","v":0},null,null,null,{"$f":"SUMIFS($Y$35:$Y$65,$B$35:$B$65,AM163,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ163,$E$35:$E$65,AI163)","v":0},null,{"$f":"AC163+AC164-AB163","v":0},{"$f":"AG163*AO163/1000/2*AK163","v":0},{"$f":"SUMIFS($Z$35:$Z$65,$B$35:$B$65,AM163,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ163,$E$35:$E$65,AI163)","v":0},null,null,null,{"$f":"SUMIFS($H$9:$H$31,$E$9:$E$31,AI163)","v":0},"Труба 25х25х2","Труба 25х25 чм, 2.0 мм",2,3.0960000000000001,1.548,6000,{"$f":"CONCATENATE(\"<>\",AM163)","v":"<>6000"},5]
[{"$f":"IF(U165=0,\"z\",\" \")","v":"z"},null,null,null,null,null,"Остатки",null,null,null,null,{"$f":"SUMIFS($L$35:$L$65,$B$35:$B$65,AN163,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ163,$E$35:$E$65,AI163)","v":0},null,null,{"$f":"SUMIFS($O$35:$O$65,$B$35:$B$65,AN163,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ163,$E$35:$E$65,AI163)","v":0},null,null,null,null,null,{"$f":"SUMIFS($U$35:$U$65,$B$35:$B$65,AN163,C53:C83,\"=500\",$D$35:$D$65,AJ163,$E$35:$E$65,AI163)","v":0},null,null,null,{"$f":"SUMIFS($Y$35:$Y$65,$B$35:$B$65,AN163,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ163,$E$35:$E$65,AI163)","v":0},null,null,null,{"$f":"SUMIFS($Z$35:$Z$65,$B$35:$B$65,AN163,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ163,$E$35:$E$65,AI163)","v":0}]
[{"$f":"IF(U165=0,\"z\",\" \")","v":"z"},null,null,null,null,null,"общая",null,null,null,null,{"$f":"L163+L164","v":0},null,null,{"$f":"O163+O164","v":0},null,null,{"$f":"R163","v":0},null,null,{"$f":"U163+U164+AB163","v":0},null,null,null,{"$f":"Y163+Y164","v":0}]
[{"$f":"IF(U168=0,\"z\",\" \")","v":"z"},null,null,null,null,{"$f":"AI166","v":"Труба 25х28 чм, 1.5 мм"},null,{"$f":"SUMIFS($F$35:$F$65,$C$35:$C$65,\"=500\",$B$35:$B$65,AM152,$D$35:$D$65,AJ166,$E$35:$E$65,AI166)","v":0},{"$f":"AJ166","v":1.5},null,{"$f":"AK166","v":2.6},{"$f":"SUMIFS($L$35:$L$65,$B$35:$B$65,AM166,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ166,$E$35:$E$65,AI166)","v":0},null,null,{"$f":"SUMIFS($O$35:$O$65,$B$35:$B$65,AM166,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ166,$E$35:$E$65,AI166)","v":0},null,null,{"$f":"AC166+AC167-AB166","v":0},null,null,{"$f":"SUMIFS($U$35:$U$65,$B$35:$B$65,AM166,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ166,$E$35:$E$65,AI166)","v":0},null,null,null,{"$f":"SUMIFS($Y$35:$Y$65,$B$35:$B$65,AM166,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ166,$E$35:$E$65,AI166)","v":0},null,{"$f":"AC166+AC167-AB166","v":0},{"$f":"AG166*AO166/1000/2*AK166","v":0},{"$f":"SUMIFS($Z$35:$Z$65,$B$35:$B$65,AM166,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ166,$E$35:$E$65,AI166)","v":0},null,null,null,{"$f":"SUMIFS($H$9:$H$31,$E$9:$E$31,AI166)","v":0},"Труба 25х28х1,5","Труба 25х28 чм, 1.5 мм",1.5,2.6,1.3,6000,{"$f":"CONCATENATE(\"<>\",AM166)","v":"<>6000"},5]
[{"$f":"IF(U168=0,\"z\",\" \")","v":"z"},null,null,null,null,null,"Остатки",null,null,null,null,{"$f":"SUMIFS($L$35:$L$65,$B$35:$B$65,AN166,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ166,$E$35:$E$65,AI166)","v":0},null,null,{"$f":"SUMIFS($O$35:$O$65,$B$35:$B$65,AN166,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ166,$E$35:$E$65,AI166)","v":0},null,null,null,null,null,{"$f":"SUMIFS($U$35:$U$65,$B$35:$B$65,AN166,C56:C86,\"=500\",$D$35:$D$65,AJ166,$E$35:$E$65,AI166)","v":0},null,null,null,{"$f":"SUMIFS($Y$35:$Y$65,$B$35:$B$65,AN166,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ166,$E$35:$E$65,AI166)","v":0},null,null,null,{"$f":"SUMIFS($Z$35:$Z$65,$B$35:$B$65,AN166,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ166,$E$35:$E$65,AI166)","v":0}]
[{"$f":"IF(U168=0,\"z\",\" \")","v":"z"},null,null,null,null,null,"общая",null,null,null,null,{"$f":"L166+L167","v":0},null,null,{"$f":"O166+O167","v":0},null,null,{"$f":"R166","v":0},null,null,{"$f":"U166+U167+AB166","v":0},null,null,null,{"$f":"Y166+Y167","v":0}]
[{"$f":"IF(U171=0,\"z\",\" \")","v":"z"},null,null,null,null,{"$f":"AI169","v":0},null,{"$f":"SUMIFS($F$35:$F$65,$C$35:$C$65,\"=500\",$B$35:$B$65,AM155,$D$35:$D$65,AJ169,$E$35:$E$65,AI169)","v":0},{"$f":"AJ169","v":0},null,{"$f":"AK169","v":0},{"$f":"SUMIFS($L$35:$L$65,$B$35:$B$65,AM169,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ169,$E$35:$E$65,AI169)","v":0},null,null,{"$f":"SUMIFS($O$35:$O$65,$B$35:$B$65,AM169,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ169,$E$35:$E$65,AI169)","v":0},null,null,{"$f":"AC169+AC170-AB169","v":0},null,null,{"$f":"SUMIFS($U$35:$U$65,$B$35:$B$65,AM169,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ169,$E$35:$E$65,AI169)","v":0},null,null,null,{"$f":"SUMIFS($Y$35:$Y$65,$B$35:$B$65,AM169,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ169,$E$35:$E$65,AI169)","v":0},null,{"$f":"AC169+AC170-AB169","v":0},{"$f":"AG169*AO169/1000/2*AK169","v":0},{"$f":"SUMIFS($Z$35:$Z$65,$B$35:$B$65,AM169,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ169,$E$35:$E$65,AI169)","v":0}]
[{"$f":"IF(U171=0,\"z\",\" \")","v":"z"},null,null,null,null,null,"Остатки",null,null,null,null,{"$f":"SUMIFS($L$35:$L$65,$B$35:$B$65,AN169,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ169,$E$35:$E$65,AI169)","v":0},null,null,{"$f":"SUMIFS($O$35:$O$65,$B$35:$B$65,AN169,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ169,$E$35:$E$65,AI169)","v":0},null,null,null,null,null,{"$f":"SUMIFS($U$35:$U$65,$B$35:$B$65,AN169,C59:C89,\"=500\",$D$35:$D$65,AJ169,$E$35:$E$65,AI169)","v":0},null,null,null,{"$f":"SUMIFS($Y$35:$Y$65,$B$35:$B$65,AN169,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ169,$E$35:$E$65,AI169)","v":0},null,null,null,{"$f":"SUMIFS($Z$35:$Z$65,$B$35:$B$65,AN169,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ169,$E$35:$E$65,AI169)","v":0}]
[{"$f":"IF(U171=0,\"z\",\" \")","v":"z"},null,null,null,null,null,"общая",null,null,null,null,{"$f":"L169+L170","v":0},null,null,{"$f":"O169+O170","v":0},null,null,{"$f":"R169","v":0},null,null,{"$f":"U169+U170+AB169","v":0},null,null,null,{"$f":"Y169+Y170","v":0}]
[{"$f":"IF(U174=0,\"z\",\" \")","v":{"$error":"#VALUE!"}},null,null,null,null,{"$f":"AI172","v":0},null,{"$f":"SUMIFS($F$35:$F$65,$C$35:$C$65,\"=500\",$B$35:$B$65,AM158,$D$35:$D$65,AJ172,$E$35:$E$65,AI172)","v":0},{"$f":"AJ172","v":0},null,{"$f":"AK172","v":0},{"$f":"SUMIFS($L$35:$L$65,$B$35:$B$65,AM172,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ172,$E$35:$E$65,AI172)","v":0},null,null,{"$f":"SUMIFS($O$35:$O$65,$B$35:$B$65,AM172,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ172,$E$35:$E$65,AI172)","v":0},null,null,{"$f":"AC172+AC173-AB172","v":0},null,null,{"$f":"SUMIFS($U$35:$U$65,$B$35:$B$65,AM172,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ172,$E$35:$E$65,AI172)","v":0},null,null,null,{"$f":"SUMIFS($Y$35:$Y$65,$B$35:$B$65,AM172,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ172,$E$35:$E$65,AI172)","v":0},null,{"$f":"AC172+AC173-AB172","v":0},{"$f":"AG172*AO172/1000/2*AK172","v":0},{"$f":"SUMIFS($Z$35:$Z$65,$B$35:$B$65,AM172,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ172,$E$35:$E$65,AI172)","v":0}]
[{"$f":"IF(U174=0,\"z\",\" \")","v":{"$error":"#VALUE!"}},null,null,null,null,null,"Остатки",null,null,null,null,{"$f":"SUMIFS($L$35:$L$65,$B$35:$B$65,AN172,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ172,$E$35:$E$65,AI172)","v":0},null,null,{"$f":"SUMIFS($O$35:$O$65,$B$35:$B$65,AN172,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ172,$E$35:$E$65,AI172)","v":0},null,null,null,null,null,{"$f":"SUMIFS($U$35:$U$65,$B$35:$B$65,AN172,C62:C152,\"=500\",$D$35:$D$65,AJ172,$E$35:$E$65,AI172)","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"SUMIFS($Y$35:$Y$65,$B$35:$B$65,AN172,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ172,$E$35:$E$65,AI172)","v":0},null,null,null,{"$f":"SUMIFS($Z$35:$Z$65,$B$35:$B$65,AN172,$C$35:$C$65,\"=500\",$D$35:$D$65,AJ172,$E$35:$E$65,AI172)","v":0}]
[{"$f":"IF(U174=0,\"z\",\" \")","v":{"$error":"#VALUE!"}},null,null,null,null,null,"общая",null,null,null,null,{"$f":"L172+L173","v":0},null,null,{"$f":"O172+O173","v":0},null,null,{"$f":"R172","v":0},null,null,{"$f":"U172+U173+AB172","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"Y172+Y173","v":0}]
["Подпись",null,null,null,"Инженер-технолог"]
["Подпись",null,null,null,"Нач техотдела"]
["Подпись",null,null,null,"Генеральный директор"]