{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Перечень","Как-то так","Комплект Свод","Комплект","Состав узлов","Данные"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":4,"comments":0,"pivot_tables":1},"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":12,"n_cols":6,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[null,"ПЛАН"]
[null,"Перечень узлов","Наименование","Кол-во"]
[null,"301524.068",{"$f":"VLOOKUP(B3,Данные!A:B,2,0)","v":"Контактодержатель"},32]
[null,"301714.101",{"$f":"VLOOKUP(B4,Данные!A:B,2,0)","v":"Пластина"},2]
[null,"301568.042",{"$f":"VLOOKUP(B5,Данные!A:B,2,0)","v":"Кронштейн"},4]
[null,null,{"$f":"VLOOKUP(B6,Данные!A:B,2,0)","v":{"$error":"#N/A"}},null,null,"Макрос должен собрать на листе КОМПЛЕКТ состав каждого из узлов (с учетом его кол-ва), "]
[null,null,{"$f":"VLOOKUP(B7,Данные!A:B,2,0)","v":{"$error":"#N/A"}},null,null,"с разузлованием узлов входящих в состав других узлов. Повторяющиеся позиции ссумировать."]
[null,null,{"$f":"VLOOKUP(B8,Данные!A:B,2,0)","v":{"$error":"#N/A"}}]
[null,null,{"$f":"VLOOKUP(B9,Данные!A:B,2,0)","v":{"$error":"#N/A"}}]
[null,null,{"$f":"VLOOKUP(B10,Данные!A:B,2,0)","v":{"$error":"#N/A"}}]
[null,null,{"$f":"VLOOKUP(B11,Данные!A:B,2,0)","v":{"$error":"#N/A"}}]
[null,null,{"$f":"VLOOKUP(B12,Данные!A:B,2,0)","v":{"$error":"#N/A"}}]

{"sheet":"Как-то так","index":1,"n_rows":15,"n_cols":4,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[null,null,null,{"$f":"SUM(D3:D1048576)","v":376}]
["№п/п","Деталь","Наименование","Кол-во деталей"]
[1," подузел: 301714.102","Пластина",32]
[2," подузел: 301714.102-01","Пластина",32]
[3,"715111.115","Ось (Палец)",2]
[4,"741121.130","Бобышка",160]
[5,"741124.345","Пластина",32]
[6,"741126.060","Пластина",4]
[7,"741141.031","Пластина",8]
[8,"741334.084","Пластина",32]
[9,"741361.047","Пластина",32]
[10,"741361.047-01","Пластина",32]
[11,"745112.020","Пластина",2]
[12,"745222.184","Уголок",4]
[13,"745222.184-01","Уголок",4]

{"sheet":"Комплект Свод","index":2,"n_rows":33,"n_cols":7,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
[]
[]
["№","Деталь","Наименование детали","Узел","Кол-во","Наименование узла"," Кол-во деталей"]
[{"$f":"IFERROR(IF(B4<>\"\",A3+1,\"\"),1)","v":1}," подузел: 301714.102","Пластина","301524.068",32,"Контактодержатель",32]
[{"$f":"IFERROR(IF(B5<>\"\",A4+1,\"\"),1)","v":2}," подузел: 301714.102-01","Пластина","301524.068",32,"Контактодержатель",32]
[3,"715111.115","Ось (Палец)","301714.101",2,"Пластина",2]
[4,"741121.130","Бобышка","301524.068",32,"Контактодержатель",160]
[5,"741124.345","Пластина","301524.068",32,"Контактодержатель",32]
[6,"741126.060","Пластина","301568.042",4,"Кронштейн",4]
[7,"741141.031","Пластина","301568.042",4,"Кронштейн",8]
[8,"741334.084","Пластина","301524.068",32,"Контактодержатель",32]
[9,"741361.047","Пластина","301524.068",32,"Контактодержатель",32]
[10,"741361.047-01","Пластина","301524.068",32,"Контактодержатель",32]
[11,"745112.020","Пластина","301714.101",2,"Пластина",2]
[12,"745222.184","Уголок","301568.042",4,"Кронштейн",4]
[13,"745222.184-01","Уголок","301568.042",4,"Кронштейн",4]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]

{"sheet":"Комплект","index":3,"n_rows":16,"n_cols":8,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[null,"Комплекование на план"]
["№п/п","Узел","Наименование","Кол-во","Деталь","Наименование","Кол-во деталей","Кол-во деталей * к-во узлов"]
[1,"301524.068","Контактодержатель",32," подузел: 301714.102","Пластина",1,32]
[2,"301524.068","Контактодержатель",32,"741121.130","Бобышка",2,64]
[3,"301524.068","Контактодержатель",32,"741361.047","Пластина",1,32]
[4,"301524.068","Контактодержатель",32," подузел: 301714.102-01","Пластина",1,32]
[5,"301524.068","Контактодержатель",32,"741121.130","Бобышка",3,96]
[6,"301524.068","Контактодержатель",32,"741361.047-01","Пластина",1,32]
[7,"301524.068","Контактодержатель",32,"741124.345","Пластина",1,32]
[8,"301524.068","Контактодержатель",32,"741334.084","Пластина",1,32]
[9,"301714.101","Пластина",2,"715111.115","Ось (Палец)",1,2]
[10,"301714.101","Пластина",2,"745112.020","Пластина",1,2]
[11,"301568.042","Кронштейн",4,"741126.060","Пластина",1,4]
[12,"301568.042","Кронштейн",4,"741141.031","Пластина",2,8]
[13,"301568.042","Кронштейн",4,"745222.184","Уголок",1,4]
[14,"301568.042","Кронштейн",4,"745222.184-01","Уголок",1,4]

{"sheet":"Состав узлов","index":4,"n_rows":80,"n_cols":5,"rows_kept":80,"cut":false,"hidden":false,"merged":[]}
["Номер чертежа","Наименование","Номер чертежа","Наименование","Кол-во"]
[null,null,null,null,"в узле"]
["301524.068","Контактодержатель","301714.102","Пластина",1]
[null,null,"301714.102-01","Пластина",1]
[null,null,"741124.345","Пластина",1]
[null,null,"741334.084","Пластина",1]
[]
[]
["301524.068-01","Контактодержатель","301714.102","Пластина",1]
[null,null,"301714.102-01","Пластина",1]
[null,null,"741124.345-01","Пластина",1]
[null,null,"741334.084","Пластина",1]
[]
[]
["301524.069","Контактодержатель","741234.016-01","Пластина",1]
[null,null,"741334.084","Пластина",1]
[null,null,"741364.063","Пластина",1]
[]
[]
["301524.070","Контактодержатель","741234.016","Пластина",1]
[null,null,"741334.084","Пластина",1]
[null,null,"741364.064","Пластина",1]
[]
[]
["301568.042","Кронштейн","741126.060","Пластина",1]
[null,null,"741141.031","Пластина",2]
[null,null,"745222.184","Уголок",1]
[null,null,"745222.184-01","Уголок",1]
[]
[]
["301314.204","Основание","713151.009","Втулка",2]
[null,null,"741374.036","Рычаг",1]
[null,null,"745326.065","Скоба",1]
[]
[]
["301314.205","Основание","301314.204","Основание",1]
[null,null,"725324.432","Втулка",2]
[]
[]
["301714.101","Пластина","715111.115","Ось (Палец)",1]
[null,null,"745112.020","Пластина",1]
[]
[]
["301714.102","Пластина","741121.130","Бобышка",2]
[null,null,"741361.047","Пластина",1]
[]
[]
["301714.102-01","Пластина","741121.130","Бобышка",3]
[null,null,"741361.047-01","Пластина",1]
[]
[]
["301216.040","Цоколь","723116.062","Труба",1]
[null,null,"741121.125","Пластина",2]
[null,null,"741124.346","Пластина",1]
[null,null,"741124.347","Пластина",1]
[null,null,"741334.084","Пластина",1]
[null,null,"746124.001","Уголок",1]
[null,null,"746124.002","Уголок",1]
[]
[]
["301216.041","Цоколь","301216.040","Цоколь",1]
[null,null,"301314.205","Основание",1]
[null,null,"711141.030","Шайба",4]
[null,null,"711171.005","Кольцо",2]
[null,null,"713263.001","Втулка",1]
[null,null,"715112.240","Вал",1]
[null,null,"741374.037","Пластина",2]
[null,null,"753513.068","Пружина",1]
[null,null,"754152.086","Кольцо уплотнит-ое",1]
[null,null,"754165.009","Пластина",2]
[null,null,"758274.008","Шпилька",1]
[null,null,"758413.002","Гайка",1]
[null,null,"Болт М10х30 ","ГОСТ7798-70",2]
[null,null,"Винт М6х12 ","ГОСТ17473-80",4]
[null,null,"Гайка М10 ","ГОСТ5915-70",2]
[null,null,"Шайба 6.65Г ","ГОСТ6402-70",4]
[null,null,"Шайба 10.65Г ","ГОСТ6402-70",2]
[null,null,"Шайба А6х1 ","ГОСТ11371-78",4]
[null,null,"Шайба А10х1 ","ГОСТ11371-78",2]
[null,null,"Шплинт 3,2х20 ","ГОСТ397-79",1]

{"sheet":"Данные","index":5,"n_rows":47,"n_cols":6,"rows_kept":47,"cut":false,"hidden":false,"merged":[]}
["Номер детали","Наименование детали","Материал","Масса детали, кг","Норма расхода, кг","Отходы, кг"]
["301216.040","Цоколь","Узел",0,0,0]
["301314.204","Основание","Узел",0,0,0]
["301314.205","Основание","Узел",0,0,0]
["301524.068","Контактодержатель","Узел",0,0,0]
["301524.068-01","Контактодержатель","Узел",0,0,0]
["301524.069","Контактодержатель","Узел",0,0,0]
["301524.070","Контактодержатель","Узел",0,0,0]
["301568.042","Кронштейн","Узел",0,0,0]
["301714.101","Пластина","Узел",0,0,0]
["301714.102","Пластина","Узел",0,0,0]
["301714.102-01","Пластина","Узел",0,0,0]
["711141.030","Шайба","Лист БТ-ПН-0-0,5 ГОСТ19904-90",5.0000000000000001E-3,1.2E-2,7.0000000000000001E-3]
["711171.005","Кольцо","Труба 42х6 ГОСТ8734-75",2.1000000000000001E-2,6.4000000000000001E-2,4.2999999999999997E-2]
["713151.009","Втулка","Труба 42х6 ГОСТ8734-75",0,0,0]
["713263.001","Втулка","Круг 30-h11 ГОСТ7417-75",0,0,0]
["715111.115","Палец","Круг 4-h11 ГОСТ7417-75",1.4E-3,2E-3,6.0000000000000006E-4]
["715112.240","Вал","Круг 30-h11 ГОСТ7417-75",0,0,0]
["723116.062","Ось","Труба 42х6 ГОСТ8734-75",0.54,0.56000000000000005,2.0000000000000018E-2]
["725324.432","Втулка","Кооперация",0,0,0]
["741121.125","Пластина","Лист Б-ПН-0-6 ГОСТ19903-74",0.23,0.25,1.999999999999999E-2]
["741124.345","Пластина","Лист Б-ПН-0-8 ГОСТ19903-74",0.32500000000000001,0.36199999999999999,3.6999999999999977E-2]
["741124.345-01","Пластина","Лист Б-ПН-0-8 ГОСТ19903-74",0.32,0.36199999999999999,4.1999999999999982E-2]
["741124.346","Пластина","Лист г/к Б-ПН-0-8 ГОСТ19903-74",8.1000000000000003E-2,9.0999999999999998E-2,9.999999999999995E-3]
["741124.347","Пластина","Лист Б-ПН-0-8 ГОСТ19903-74",0.16,0.17,1.0000000000000009E-2]
["741126.060","Пластина","Лист Б-ПН-0-6 ГОСТ19903-74",0.44,0.53,9.0000000000000024E-2]
["741141.031","Пластина","Лист4 Ст3кп",0.45,0.56999999999999995,0.11999999999999994]
["741234.016","Пластина","Лист Б-ПН-0-8 ГОСТ19903-74",0.38,0.66,0.28000000000000003]
["741234.016-01","Пластина","Лист 8 Ст3кп",0.38,0.66,0.28000000000000003]
["741334.084","Пластина","Лист 6 Ст3кп",0.64400000000000002,0.9,0.25600000000000001]
["741361.047","Пластина","Лист Б-ПН-0-8 ГОСТ19903-74",1.1000000000000001,1.605,0.50499999999999989]
["741361.047-01","Пластина","Лист Б-ПН-0-8 ГОСТ19903-74",1.1000000000000001,1.605,0.50499999999999989]
["741364.063","Пластина","Лист 8 Ст3кп",0.81499999999999995,1.345,0.53]
["741364.064","Пластина","Лист 8 Ст3кп",0.92,1.8,0.88]
["741374.036","Рычаг","Лист Б-ПН-0-8 ГОСТ19903-74",0.75,1.121,0.371]
["741374.037","Пластина","Лист 2,5 К270В ",3.0000000000000001E-3,4.0000000000000001E-3,1E-3]
["745112.020","Пластина","Лист Б-ПН-0-4 ГОСТ19903-74",0.154,0.17299999999999999,1.8999999999999989E-2]
["745222.184","Уголок","Лист г/к Б-ПН-0-6,0 ГОСТ19903-74",0.68,0.87,0.18999999999999995]
["745222.184-01","Уголок","Ст3кп2 Лист 7",0.68,0.87,0.18999999999999995]
["745326.065","Скоба","Лист г/к Б-ПН-0-6,0 ГОСТ19903-74",1.5,2.633,1.133]
["746124.001","Уголок","Уголок 50х50х5 В ГОСТ8509-86",1.54,1.54,0]
["746124.002","Уголок","Уголок 50х50х5 В ГОСТ8509-86",1.54,1.54,0]
["753513.068",null,"Кооперация",0,0,0]
["754152.086","Кольцо","Войлок ТЭ-4",5.0000000000000001E-4,1.6000000000000001E-3,1.1000000000000001E-3]
["754165.009","Пластина","2Ф-I-ТМКЩ-С2 Рулон 2х1000х1000",0.01,1.2999999999999999E-2,2.9999999999999992E-3]
["758274.008","Шпилька","Пруток 10,8-h11 ГОСТ7417-75",7.2999999999999995E-2,7.4999999999999997E-2,2.0000000000000018E-3]
["758413.002","Гайка","Шестигранник 19-h11 ГОСТ8560-78",2.7E-2,6.6000000000000003E-2,3.9000000000000007E-2]