{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["ТРУБА"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"ТРУБА","index":0,"n_rows":83,"n_cols":37,"rows_kept":83,"cut":false,"hidden":false,"merged":[[2,7,2,9],[3,2,3,12],[31,11,32,11],[31,1,32,1],[31,2,32,2],[31,3,32,3],[31,4,32,4],[31,5,32,5],[31,12,31,13],[66,8,66,9],[66,13,66,15],[31,6,32,6],[31,7,32,7],[31,8,32,8],[31,9,32,9],[31,15,31,16],[31,14,32,14],[66,26,66,29],[66,23,66,25],[66,17,66,19],[31,23,32,23],[31,21,32,21],[31,18,31,19],[31,17,32,17],[31,20,32,20],[31,22,32,22]]}
["z",null,null,null,null,null,null,null,null,null,"z","z",null,null,null,null,null,null,null,null,null,null,null,null,null,"z","z","z","z","z","z","z","z","z"]
[]
[]
[]
[]
[]
[]
[{"$f":"IF(E8=0,\"z\",\"\")","v":"z"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I8=0,0,1)","v":0}]
[{"$f":"IF(E9=0,\"z\",\"\")","v":"z"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I9=0,R8,R8+1)","v":0}]
["z",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I10=0,R9,R9+1)","v":0}]
["z",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I11=0,R10,R10+1)","v":0}]
["z",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["z",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["z",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["z",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["z",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["z",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["z",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["z",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["z",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["z",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["z",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["z",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["z",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["z",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["z",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["z",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["z",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["z",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["z",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[]
[null,"Карта рас-кроя №","Длина, мм","Ширина, мм","Толщина, мм","Марка материала","Кол-во","Площадь остатков всего, кв.м","Площадь деталей всего, кв.м","Количество деталей",null,"Коэфициент ","Трубы/остатка со склада масса (кг)",null,"Получил","Деловой остаток на склад (кг)",null,"Получил кла-довщик","Масса деталей (кг)",null,"Количество деталей","Получил","Расход (кг)","ЛОМ (кг)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"теория","факт",null,"теория","факт",null,"теория","факт"]
[{"$f":"IF(G34=0,\"z\",\"\")","v":""},1,6000,500,0.8,"Труба 25х25 чм, 0.8 мм",2,10,2,1,null,{"$f":"IFERROR(VLOOKUP(F34,Таблица1[[Столбец4]:[Столбец10]],7,0),\"0\")","v":1.2},{"$f":"C34*D34*G34*L34/1000000","v":7.2},null,null,{"$f":"H34*L34","v":12},null,null,{"$f":"I34*L34","v":2.4},null,null,null,{"$f":"M34-P34","v":-4.8},{"$f":"W34-S34","v":-7.1999999999999993}]
[{"$f":"IF(G35=0,\"z\",\"\")","v":"z"},null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(F35,Таблица1[[Столбец4]:[Столбец10]],7,0),\"0\")","v":0},0,null,null,0,null,null,0,null,null,null,0,{"$f":"W35-S35","v":0}]
["z",null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(F36,Таблица1[[Столбец4]:[Столбец10]],7,0),\"0\")","v":0},0,null,null,0,null,null,0,null,null,null,0,0]
["z",null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(F37,Таблица1[[Столбец4]:[Столбец10]],7,0),\"0\")","v":0},0,null,null,0,null,null,0,null,null,null,0,0]
["z",null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(F38,Таблица1[[Столбец4]:[Столбец10]],7,0),\"0\")","v":0},0,null,null,0,null,null,0,null,null,null,0,0]
["z",null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(F39,Таблица1[[Столбец4]:[Столбец10]],7,0),\"0\")","v":0},0,null,null,0,null,null,0,null,null,null,0,0]
["z",null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(F40,Таблица1[[Столбец4]:[Столбец10]],7,0),\"0\")","v":0},0,null,null,0,null,null,0,null,null,null,0,0]
["z",null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(F41,Таблица1[[Столбец4]:[Столбец10]],7,0),\"0\")","v":0},0,null,null,0,null,null,0,null,null,null,0,0]
["z",null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(F42,Таблица1[[Столбец4]:[Столбец10]],7,0),\"0\")","v":0},0,null,null,0,null,null,0,null,null,null,0,0]
["z",null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(F43,Таблица1[[Столбец4]:[Столбец10]],7,0),\"0\")","v":0},0,null,null,0,null,null,0,null,null,null,0,0]
["z",null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(F44,Таблица1[[Столбец4]:[Столбец10]],7,0),\"0\")","v":0},0,null,null,0,null,null,0,null,null,null,0,0]
["z",null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(F45,Таблица1[[Столбец4]:[Столбец10]],7,0),\"0\")","v":0},0,null,null,0,null,null,0,null,null,null,0,0]
["z",null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(F46,Таблица1[[Столбец4]:[Столбец10]],7,0),\"0\")","v":0},0,null,null,0,null,null,0,null,null,null,0,0]
["z",null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(F47,Таблица1[[Столбец4]:[Столбец10]],7,0),\"0\")","v":0},0,null,null,0,null,null,0,null,null,null,0,0]
["z",null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(F48,Таблица1[[Столбец4]:[Столбец10]],7,0),\"0\")","v":0},0,null,null,0,null,null,0,null,null,null,0,0]
["z",null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(F49,Таблица1[[Столбец4]:[Столбец10]],7,0),\"0\")","v":0},0,null,null,0,null,null,0,null,null,null,0,0]
["z",null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(F50,Таблица1[[Столбец4]:[Столбец10]],7,0),\"0\")","v":0},0,null,null,0,null,null,0,null,null,null,0,0]
["z",null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(F51,Таблица1[[Столбец4]:[Столбец10]],7,0),\"0\")","v":0},0,null,null,0,null,null,0,null,null,null,0,0]
["z",null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(F52,Таблица1[[Столбец4]:[Столбец10]],7,0),\"0\")","v":0},0,null,null,0,null,null,0,null,null,null,0,0]
["z",null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(F53,Таблица1[[Столбец4]:[Столбец10]],7,0),\"0\")","v":0},0,null,null,0,null,null,0,null,null,null,0,0]
["z",null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(F54,Таблица1[[Столбец4]:[Столбец10]],7,0),\"0\")","v":0},0,null,null,0,null,null,0,null,null,null,0,0]
["z",null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(F55,Таблица1[[Столбец4]:[Столбец10]],7,0),\"0\")","v":0},0,null,null,0,null,null,0,null,null,null,0,0]
["z",null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(F56,Таблица1[[Столбец4]:[Столбец10]],7,0),\"0\")","v":0},0,null,null,0,null,null,0,null,null,null,0,0]
["z",null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(F57,Таблица1[[Столбец4]:[Столбец10]],7,0),\"0\")","v":0},0,null,null,0,null,null,0,null,null,null,0,0]
["z",null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(F58,Таблица1[[Столбец4]:[Столбец10]],7,0),\"0\")","v":0},0,null,null,0,null,null,0,null,null,null,0,0]
["z",null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(F59,Таблица1[[Столбец4]:[Столбец10]],7,0),\"0\")","v":0},0,null,null,0,null,null,0,null,null,null,0,0]
["z",null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(F60,Таблица1[[Столбец4]:[Столбец10]],7,0),\"0\")","v":0},0,null,null,0,null,null,0,null,null,null,0,0]
["z",null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(F61,Таблица1[[Столбец4]:[Столбец10]],7,0),\"0\")","v":0},0,null,null,0,null,null,0,null,null,null,0,0]
["z",null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(F62,Таблица1[[Столбец4]:[Столбец10]],7,0),\"0\")","v":0},0,null,null,0,null,null,0,null,null,null,0,0]
["z",null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(F63,Таблица1[[Столбец4]:[Столбец10]],7,0),\"0\")","v":0},0,null,null,0,null,null,0,null,null,null,0,0]
["z",null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(F64,Таблица1[[Столбец4]:[Столбец10]],7,0),\"0\")","v":0},0,null,null,0,null,null,0,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M34:M64)","v":7.2},null,null,{"$f":"SUM(P34:P64)","v":12},null,null,{"$f":"SUM(S34:S64)","v":2.4},null,null,null,{"$f":"SUM(W34:W64)","v":-4.8},{"$f":"SUM(X34:X64)","v":-7.1999999999999993}]
[]
[null,null,null,null,null,null,null,null,"получить"]
[null,"№ п/п",null,"Стандарт. длина\nмм",null,"Марка материала","Толщина\nмм","Кол-во труб","Масса \nцелых\nкг","Масса\nделовых\nкг","коэф 2м","Резы",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ширина реза\nмм","Марка материала","Марка материала\nАстра"]
["z",null,null,null,"копия","копия"]
["z","Столбец1","Столбец2","Столбец3","Столбец4","Столбец5","Столбец6","Столбец7","Столбец8","Столбец9","Столбец10","Столбец11","Столбец12","Столбец13","Столбец14","Столбец15","Столбец16","Столбец17","Столбец18","Столбец19","Столбец20","Столбец21","Столбец22","Столбец23","Столбец24","Столбец25","Столбец26","Столбец27","Столбец28","Столбец29","Столбец30","Столбец31","Столбец32","Столбец33","Столбец34","Столбец35","Столбец36"]
[{"$f":"IF(Таблица1[[#This Row],[Столбец19]]=0,\"z\",\"\")","v":"z"},null,null,6000,{"$f":"Таблица1[[#This Row],[Столбец32]]","v":"Труба 25х25 чм, 0.8 мм"},{"$f":"Таблица1[[#This Row],[Столбец31]]","v":"Труба 25х25х0,8"},0.8,{"$f":"SUMIFS($G$34:$G$64,$D$34:$D$64,\"=500\",$C$34:$C$64,\"=[@Столбец3]\",$E$34:$E$64,\"=[@Столбец6]\",$F$34:$F$64,\"=[@Столбец32]\")","v":0},{"$f":"SUMIFS($M$34:$M$64,$C$34:$C$64,\"=[@Столбец3]\",$D$34:$D$64,\"=500\",$E$34:$E$64,\"=[@Столбец6]\",$F$34:$F$64,\"=[@Столбец32]\")","v":0},{"$f":"SUMIFS($M$34:$M$64,$C$34:$C$64,\"<>[@Столбец3]\",$D$34:$D$64,\"=500\",$E$34:$E$64,\"=[@Столбец6]\",$F$34:$F$64,\"=[@Столбец32]\")","v":0},1.2,{"$f":"SUMIFS($I$8:$I$30,$F$8:$F$30,\"=[@Столбец5]\")","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,"Труба 25х25х0,8","Труба 25х25 чм, 0.8 мм","Труба","25х25х0,8"]
[{"$f":"IF(Таблица1[[#This Row],[Столбец19]]=0,\"z\",\"\")","v":"z"},null,null,6000,{"$f":"Таблица1[[#This Row],[Столбец32]]","v":"Труба 25х25 чм, 1.0 мм"},{"$f":"Таблица1[[#This Row],[Столбец31]]","v":"Труба 25х25х1"},1,{"$f":"SUMIFS($G$34:$G$64,$D$34:$D$64,\"=500\",$C$34:$C$64,\"=[@Столбец3]\",$E$34:$E$64,\"=[@Столбец6]\",$F$34:$F$64,\"=[@Столбец32]\")","v":0},{"$f":"SUMIFS($M$34:$M$64,$C$34:$C$64,\"=[@Столбец3]\",$D$34:$D$64,\"=500\",$E$34:$E$64,\"=[@Столбец6]\",$F$34:$F$64,\"=[@Столбец32]\")","v":0},0,1.48,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,"Труба 25х25х1","Труба 25х25 чм, 1.0 мм","Труба","25х25х1"]
[{"$f":"IF(Таблица1[[#This Row],[Столбец19]]=0,\"z\",\"\")","v":"z"},null,null,6000,{"$f":"Таблица1[[#This Row],[Столбец32]]","v":"Труба 25х25 чм, 1.2 мм"},{"$f":"Таблица1[[#This Row],[Столбец31]]","v":"Труба 25х25х1.2"},1.2,{"$f":"SUMIFS($G$34:$G$64,$D$34:$D$64,\"=500\",$C$34:$C$64,\"=[@Столбец3]\",$E$34:$E$64,\"=[@Столбец6]\",$F$34:$F$64,\"=[@Столбец32]\")","v":0},0,0,1.75,{"$f":"SUMIFS($I$8:$I$30,$F$8:$F$30,\"=[@Столбец5]\")","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,"Труба 25х25х1.2","Труба 25х25 чм, 1.2 мм","Труба","25х25х1.2"]
[{"$f":"IF(Таблица1[[#This Row],[Столбец19]]=0,\"z\",\"\")","v":"z"},null,null,null,{"$f":"Таблица1[[#This Row],[Столбец32]]","v":0},{"$f":"Таблица1[[#This Row],[Столбец31]]","v":0},null,{"$f":"SUMIFS($G$34:$G$64,$D$34:$D$64,\"=500\",$C$34:$C$64,\"=[@Столбец3]\",$E$34:$E$64,\"=[@Столбец6]\",$F$34:$F$64,\"=[@Столбец32]\")","v":0},0,0,null,{"$f":"SUMIFS($I$8:$I$30,$F$8:$F$30,\"=[@Столбец5]\")","v":0}]
[{"$f":"IF(Таблица1[[#This Row],[Столбец19]]=0,\"z\",\"\")","v":"z"},null,null,null,{"$f":"Таблица1[[#This Row],[Столбец32]]","v":0},{"$f":"Таблица1[[#This Row],[Столбец31]]","v":0},null,0,0,0,null,0]
[{"$f":"IF(Таблица1[[#This Row],[Столбец19]]=0,\"z\",\"\")","v":"z"},null,null,null,{"$f":"Таблица1[[#This Row],[Столбец32]]","v":0},{"$f":"Таблица1[[#This Row],[Столбец31]]","v":0},null,{"$f":"SUMIFS($G$34:$G$64,$D$34:$D$64,\"=500\",$C$34:$C$64,\"=[@Столбец3]\",$E$34:$E$64,\"=[@Столбец6]\",$F$34:$F$64,\"=[@Столбец32]\")","v":0},0,0,null,{"$f":"SUMIFS($I$8:$I$30,$F$8:$F$30,\"=[@Столбец5]\")","v":0}]
[{"$f":"IF(Таблица1[[#This Row],[Столбец19]]=0,\"z\",\"\")","v":"z"},null,null,null,{"$f":"Таблица1[[#This Row],[Столбец32]]","v":0},{"$f":"Таблица1[[#This Row],[Столбец31]]","v":0},null,{"$f":"SUMIFS($G$34:$G$64,$D$34:$D$64,\"=500\",$C$34:$C$64,\"=[@Столбец3]\",$E$34:$E$64,\"=[@Столбец6]\",$F$34:$F$64,\"=[@Столбец32]\")","v":0},0,0,null,{"$f":"SUMIFS($I$8:$I$30,$F$8:$F$30,\"=[@Столбец5]\")","v":0}]
[]
[null,"Подпись",null,null,null,"Инженер-технолог"]
[null,"Подпись",null,null,null,"Нач техотдела"]
[null,"Подпись",null,null,null,"Генеральный директор"]
[]
[null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36]