{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["лист 1"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":41,"n_cols":34,"rows_kept":41,"cut":false,"hidden":false,"merged":[]}
[null,null,"материал","кол-во","материал","кол-во","материал","кол-во","материал","кол-во","материал","кол-во","материал","кол-во","материал","кол-во","материал","кол-во","материал","кол-во","материал","кол-во","материал","кол-во","материал","кол-во","материал","кол-во","материал","кол-во","материал","кол-во","материал","кол-во"]
[null,{"$f":"SUMIF($C$2:$AF$101,$A2,$D$2:$AH$101)/2","v":0},"Двутавр 40Ш2",3.5630000000000002,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"SUMIF($C$2:$AF$101,$A3,$D$2:$AH$101)/2","v":0},"Двутавр 30Ш2",1.125,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,0,"Двутавр 25Ш1",1.8959999999999999,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,0,"Двутавр 40Ш2",5.9,"Лист t16",0.152,"Лист t10",5.2999999999999999E-2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,0,"Уголок 75х75х6",8.1000000000000003E-2,"Лист t8",1.2E-2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,0,"Уголок 90х90х8",0.28999999999999998,"Лист t8",1.7000000000000001E-2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,0,"Швеллер 16П",8.2000000000000003E-2,"Лист t10",0.39500000000000002,"Двутавр 25Ш1",0.91249999999999998,"Лист t8",3.7499999999999999E-2,"Двутавр 20Ш1",0.20499999999999999,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,0,"Уголок 50х50х5",3.2000000000000001E-2,"Лист ПВЛ 506",0.06,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,0,"Уголок 50х50х5",9.0999999999999998E-2,"Полоса 4х40",1.2E-2,"Полоса 4х150",7.0000000000000007E-2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,0,"Уголок 75х75х5",0.14499999999999999,"Пруток Ø18",1.7999999999999999E-2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,0,"Полоса 4х40",3.4000000000000002E-2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,0,"Двутавр 40Ш2",3.5630000000000002,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,0,"Двутавр 30Ш2",1.125,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[0,0,"Двутавр 25Ш1",1.8959999999999999,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,0,"Двутавр 40Ш2",5.9,"Лист t16",0.152,"Лист t10",5.2999999999999999E-2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,0,"Уголок 75х75х6",8.1000000000000003E-2,"Лист t8",1.2E-2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,0,"Уголок 90х90х8",0.28999999999999998,"Лист t8",1.7000000000000001E-2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,0,"Швеллер 16П",8.2000000000000003E-2,"Лист t10",0.39500000000000002,"Двутавр 25Ш1",0.91249999999999998,"Лист t8",3.7499999999999999E-2,"Двутавр 20Ш1",0.20499999999999999,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,0,"Уголок 50х50х5",3.2000000000000001E-2,"Лист ПВЛ 506",0.06,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Уголок 50х50х5",9.0999999999999998E-2,"Полоса 4х40",1.2E-2,"Полоса 4х150",7.0000000000000007E-2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Уголок 75х75х5",0.14499999999999999,"Пруток Ø18",1.7999999999999999E-2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Полоса 4х40",3.4000000000000002E-2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Швеллер 16П",8.2000000000000003E-2,"Лист t10",0.39500000000000002,"Двутавр 25Ш1",0.91249999999999998,"Лист t8",3.7499999999999999E-2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Швеллер 16П",8.2000000000000003E-2,"Лист t10",0.39500000000000002,"Двутавр 25Ш1",0.91249999999999998,"Лист t8",3.7499999999999999E-2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Лист t10",5.6000000000000001E-2,"Двутавр 25Ш1",0.65200000000000002,"Лист t8",1E-3,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Швеллер 16П",0.26740000000000003,"Лист t10",5.0000000000000001E-3,"Лист t8",2E-3,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Лист t10",0.05,"Двутавр 25Ш1",0.57299999999999995,"Лист t8",1E-3,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Лист t10",5.6000000000000001E-2,"Двутавр 25Ш1",0.65200000000000002,"Лист t8",1E-3,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Швеллер 16П",0.26740000000000003,"Лист t10",5.0000000000000001E-3,"Лист t8",2E-3,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Лист t10",0.05,"Двутавр 25Ш1",0.57299999999999995,"Лист t8",1E-3,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Труба 426х12",6,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"срезка сваи 426х12",6,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Лист t=16 (ОГЛОВОК)4",0.192,"Лист t=10 (ОГЛОВОК)4",6.6000000000000003E-2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Лист t=16 (ОГЛОВОК)4",0.192,"Лист t=10 (ОГЛОВОК)4",6.6000000000000003E-2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[]
["выбрать уникальные значения в столбцах с материалом и поместить их в столбец \"А\". столбы с материалом не ограниченны по количеству строк"]