{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Перечень","Комплект","Состав узлов","Состав узлов (2)","Данные"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"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":3,"n_cols":2,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["Перечень узлов","Кол-во"]
["301224.025",5]
["301313.072",2]

{"sheet":"Комплект","index":1,"n_rows":15,"n_cols":6,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[null,"Комплекование общее"]
["№п/п","Номер","Наименование","Кол-во","Материал","Кол-во материала"]
[null,"301313.072",{"$f":"VLOOKUP(B3,Данные!A:E,2,0)","v":"Швеллер"},5,{"$f":"VLOOKUP(B3,Данные!A:E,3,0)","v":"Узел"},{"$f":"(VLOOKUP(B3,Данные!A:E,4,0))*D3","v":0}]
["2","301314.413",{"$f":"VLOOKUP(B4,Данные!A:E,2,0)","v":"Основание"},7,{"$f":"VLOOKUP(B4,Данные!A:E,3,0)","v":"Узел"},{"$f":"(VLOOKUP(B4,Данные!A:E,4,0))*D4","v":0}]
["3","741124.156",{"$f":"VLOOKUP(B5,Данные!A:E,2,0)","v":"Пластина"},14,{"$f":"VLOOKUP(B5,Данные!A:E,3,0)","v":"Лист Б-ПН-0-5 ГОСТ19903-74"},{"$f":"(VLOOKUP(B5,Данные!A:E,4,0))*D5","v":4.34}]
["4","746214.012",{"$f":"VLOOKUP(B6,Данные!A:E,2,0)","v":"Швеллер"},7,{"$f":"VLOOKUP(B6,Данные!A:E,3,0)","v":"Швеллер 16П-в ГОСТ8240-97"},{"$f":"(VLOOKUP(B6,Данные!A:E,4,0))*D6","v":56.42}]
["5","715345.013",{"$f":"VLOOKUP(B7,Данные!A:E,2,0)","v":"Втулка"},42,{"$f":"VLOOKUP(B7,Данные!A:E,3,0)","v":"Пруток ДКРНП 40,0 ЛС59-1 ГОСТ2060-73"},{"$f":"(VLOOKUP(B7,Данные!A:E,4,0))*D7","v":1.68}]
["6","741334.029",{"$f":"VLOOKUP(B8,Данные!A:E,2,0)","v":"Пластина"},20,{"$f":"VLOOKUP(B8,Данные!A:E,3,0)","v":"Лист Б-ПН-8 ГОСТ19903-74"},{"$f":"(VLOOKUP(B8,Данные!A:E,4,0))*D8","v":1.96}]
["7","715111.006",{"$f":"VLOOKUP(B9,Данные!A:E,2,0)","v":"Вал"},15,{"$f":"VLOOKUP(B9,Данные!A:E,3,0)","v":"Круг 30 ГОСТ7417-75"},{"$f":"(VLOOKUP(B9,Данные!A:E,4,0))*D9","v":21.45}]
["8","743111.034",{"$f":"VLOOKUP(B10,Данные!A:E,2,0)","v":"Рычаг"},10,{"$f":"VLOOKUP(B10,Данные!A:E,3,0)","v":"Лист Б-ПН-0-4 ГОСТ19903-74"},{"$f":"(VLOOKUP(B10,Данные!A:E,4,0))*D10","v":0.8}]
["9","741314.036",{"$f":"VLOOKUP(B11,Данные!A:E,2,0)","v":"Кольцо"},15,{"$f":"VLOOKUP(B11,Данные!A:E,3,0)","v":"Лист БТ-ПН-0-2,5 ГОСТ19904-90"},{"$f":"(VLOOKUP(B11,Данные!A:E,4,0))*D11","v":0.18}]
["10","741124.157",{"$f":"VLOOKUP(B12,Данные!A:E,2,0)","v":"Пластина"},10,{"$f":"VLOOKUP(B12,Данные!A:E,3,0)","v":"Лист 6 ГОСТ5681-57"},{"$f":"(VLOOKUP(B12,Данные!A:E,4,0))*D12","v":3.76}]
["11","741361.025",{"$f":"VLOOKUP(B13,Данные!A:E,2,0)","v":"Пластина"},20,{"$f":"VLOOKUP(B13,Данные!A:E,3,0)","v":"Лист 6 ГОСТ5681-57"},{"$f":"(VLOOKUP(B13,Данные!A:E,4,0))*D13","v":2.8000000000000003}]
["12","711143.003",{"$f":"VLOOKUP(B14,Данные!A:E,2,0)","v":"Диск"},15,{"$f":"VLOOKUP(B14,Данные!A:E,3,0)","v":"Лист 12 ГОСТ5681-51"},{"$f":"(VLOOKUP(B14,Данные!A:E,4,0))*D14","v":2.6999999999999997}]
["13","715312.051",{"$f":"VLOOKUP(B15,Данные!A:E,2,0)","v":"Ось"},20,{"$f":"VLOOKUP(B15,Данные!A:E,3,0)","v":"Круг 22-h11 ГОСТ7417-75"},{"$f":"(VLOOKUP(B15,Данные!A:E,4,0))*D15","v":2.2200000000000002}]

{"sheet":"Состав узлов","index":2,"n_rows":22,"n_cols":48,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
["304597.007",null,"301224.024-02",null,"684564.022",null,"304597.007-01",null,"301314.411",null,"301314.412",null,"301314.412-01",null,"301314.413-01",null,"301314.412-02",null,"301224.025",null,"301224.025-01",null,"301314.413",null,"301314.413-02",null,"301224.023",null,"301224.025-02",null,"301313.072",null,"301313.072-01",null,"301313.072-02",null,"301313.072-03",null,"301313.072-04",null,"301313.072-05",null,"301313.073",null,"301224.024-01",null,"301224.024"]
["746312.046",1,"301313.072-05",1,"301224.025",1,"746312.046",1,"741124.156",2,"741124.156",2,"741124.156",2,"741124.156",2,"741124.156",2,"301313.072",1,"301313.072-01",1,"741124.156",2,"741124.156",2,"301313.073",1,"301313.072-02",1,"301314.413",1,"301314.413-01",1,"301314.413-02",1,"301314.412",1,"301314.412-01",1,"301314.412-02",1,"301314.411",1,"301313.072-04",1,"301313.072-03",1]
["715211.026",1,"741334.029",4,"301314.411",4,"715211.026-01",1,"746212.140",1,"746214.013",1,"746214.017",1,"746214.015",1,"746214.018",1,"741334.029",4,"741334.029",4,"746214.012",1,"746214.016",1,"741334.029",4,"741334.029",4,"715345.013",6,"715345.013",4,"715345.013",4,"715345.013",6,"715345.013",4,"715345.013",4,"715345.013",2,"741334.029",4,"741334.029",4]
[null,null,"715111.006",3,"301314.413",3,null,null,null,null,null,null,null,null,null,null,null,null,"715111.006",3,"715111.006",2,null,null,null,null,"715111.006",1,"715111.006",2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"715111.006",3,"715111.006",3]
[null,null,"743111.034",2,"301314.412",2,null,null,null,null,null,null,null,null,null,null,null,null,"743111.034",2,"743111.034",2,null,null,null,null,"741314.036",2,"743111.034",2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"743111.034",2,"743111.034",2]
[null,null,"741314.036",8,"741314.036",3,null,null,null,null,null,null,null,null,null,null,null,null,"741314.036",3,"741314.036",2,null,null,null,null,"743111.034",2,"741314.036",2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"741314.036",8,"741314.036",8]
[null,null,"741124.157",1,"301313.073",2,null,null,null,null,null,null,null,null,null,null,null,null,"741124.157",2,"741124.157",1,null,null,null,null,null,null,"741124.157",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"741124.157",1,"741124.157",2]
[null,null,"741361.025",4,"741334.029",4,null,null,null,null,null,null,null,null,null,null,null,null,"741361.025",4,"741361.025",2,null,null,null,null,null,null,"741361.025",2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"741361.025",4,"741361.025",4]
[null,null,null,null,"715111.006",3,null,null,null,null,null,null,null,null,null,null,null,null,"711143.003",3,"711143.003",2,null,null,null,null,null,null,"711143.003",2]
[null,null,null,null,"304597.007",4,null,null,null,null,null,null,null,null,null,null,null,null,"715312.051",4,"715312.051",2,null,null,null,null,null,null,"715312.051",2]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"Узел"]
[null,null,null,null,null,null,"деталь/узел","шт"]
[null,null,null,null,null,null,"деталь","шт"]

{"sheet":"Состав узлов (2)","index":3,"n_rows":25,"n_cols":19,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
["Узел","деталь/узел","шт","деталь","шт","деталь","шт","деталь","шт","деталь","шт","деталь","шт","деталь","шт","деталь","шт","деталь","шт"]
["304597.007","746312.046",1,"715211.026",1]
["301224.024-02","741314.036",8,"741124.157",1,"741361.025",4,"715111.006",3,"743111.034",2,"741334.029",4,"301313.072-05",1]
["301314.413","741124.156",2,"746214.012",1]
["301224.025-01","301313.072-01",1,"715111.006",2,"741334.029",4,"741361.025",2,"711143.003",2,"715312.051",2,"741314.036",2,"741124.157",1,"743111.034",2]
["684564.022","301224.025",1,"301314.413",3,"301314.411",4,"301314.412",2,"741334.029",4,"715111.006",3,"304597.007",4,"301313.073",2,"741314.036",3]
["304597.007-01","746312.046",1,"715211.026-01",1]
["301314.411","741124.156",2,"746212.140",1]
["301224.025","301313.072",1,"743111.034",2,"741314.036",3,"715111.006",3,"741334.029",4,"741124.157",2,"741361.025",4,"711143.003",3,"715312.051",4]
["301314.412","746214.013",1,"741124.156",2]
["301314.412-01","741124.156",2,"746214.017",1]
["301314.413-01","741124.156",2,"746214.015",1]
["301314.412-02","741124.156",2,"746214.018",1]
["301314.413-02","741124.156",2,"746214.016",1]
["301224.023","301313.073",1,"741334.029",4,"715111.006",1,"741314.036",2,"743111.034",2]
["301224.025-02","301313.072-02",1,"741334.029",4,"715111.006",2,"743111.034",2,"741314.036",2,"741124.157",1,"741361.025",2,"711143.003",2,"715312.051",2]
["301224.024-01","301313.072-04",1,"741334.029",4,"715111.006",3,"743111.034",2,"741314.036",8,"741124.157",1,"741361.025",4]
["301224.024","301313.072-03",1,"741334.029",4,"715111.006",3,"743111.034",2,"741314.036",8,"741124.157",2,"741361.025",4]
["301313.072","301314.413",1,"715345.013",6]
["301313.072-01","301314.413-01",1,"715345.013",4]
["301313.072-02","301314.413-02",1,"715345.013",4]
["301313.072-03","301314.412",1,"715345.013",6]
["301313.072-04","301314.412-01",1,"715345.013",4]
["301313.072-05","301314.412-02",1,"715345.013",4]
["301313.073","301314.411",1,"715345.013",2]

{"sheet":"Данные","index":4,"n_rows":45,"n_cols":5,"rows_kept":45,"cut":false,"hidden":false,"merged":[]}
["Номер","Наименование","Материал","Норма расхода ","Отход"]
["301224.023","Цоколь","Узел",0,0]
["301224.024","Цоколь","Узел",0,0]
["301224.024-01","Цоколь","Узел",0,0]
["301224.024-02","Цоколь","Узел",0,0]
["301224.025","Цоколь","Узел",0,0]
["301224.025-01","Цоколь","Узел",0,0]
["301224.025-02","Цоколь","Узел",0,0]
["301313.072","Швеллер","Узел",0,0]
["301313.072-01","Швеллер","Узел",0,0]
["301313.072-02","Швеллер","Узел",0,0]
["301313.072-03","Швеллер","Узел",0,0]
["301313.072-04","Швеллер","Узел",0,0]
["301313.072-05","Швеллер","Узел",0,0]
["301313.073","Швеллер","Узел",0,0]
["301314.411","Основание","Узел",0,0]
["301314.412","Основание","Узел",0,0]
["301314.412-01","Основание","Узел",0,0]
["301314.412-02","Основание","Узел",0,0]
["301314.413","Основание","Узел",0,0]
["301314.413-01","Основание","Узел",0,0]
["301314.413-02","Основание","Узел",0,0]
["304597.007","Вилка","Узел",0,0]
["304597.007-01","Вилка","Узел",0,0]
["684564.022","РЕЛЕ","Узел",0,0]
["711143.003","Диск","Лист 12 ГОСТ5681-51",0.18,0.41299999999999998]
["715111.006","Вал","Круг 30 ГОСТ7417-75",1.43,8.2999999999999963E-2]
["715211.026","Шпилька","Круг 14,68(4) ГОСТ7417-75",8.3000000000000004E-2,2.9999999999999888E-3]
["715211.026-01","Шпилька","Круг 14,68(4) ГОСТ7417-75",4.5999999999999999E-2,3.0000000000000027E-3]
["715312.051","Ось","Круг 22-h11 ГОСТ7417-75",0.111,4.4999999999999998E-2]
["715345.013","Втулка","Пруток ДКРНП 40,0 ЛС59-1 ГОСТ2060-73",0.04,0.19699999999999998]
["741124.156","Пластина","Лист Б-ПН-0-5 ГОСТ19903-74",0.31,6.0999999999999999E-2]
["741124.157","Пластина","Лист 6 ГОСТ5681-57",0.376,9.5999999999999974E-2]
["741314.036","Кольцо","Лист БТ-ПН-0-2,5 ГОСТ19904-90",1.2E-2,2.4999999999999998E-2]
["741334.029","Пластина","Лист Б-ПН-8 ГОСТ19903-74",9.8000000000000004E-2,3.6000000000000004E-2]
["741361.025","Пластина","Лист 6 ГОСТ5681-57",0.14000000000000001,6.7799999999999999E-2]
["743111.034","Рычаг","Лист Б-ПН-0-4 ГОСТ19903-74",0.08,9.8400000000000001E-2]
["746212.140","Швеллер","Швеллер 16П-в ГОСТ8240-97",5.78,1.4399999999999995]
["746214.012","Швеллер","Швеллер 16П-в ГОСТ8240-97",8.06,2.3200000000000003]
["746214.013","Швеллер","Швеллер 16П-в ГОСТ8240-97",8.1199999999999992,2.2600000000000016]
["746214.015","Швеллер","Швеллер 16П-в ГОСТ8240-97",6.91,1.83]
["746214.016","Швеллер","Швеллер 16П-в ГОСТ8240-97",6.92,1.8200000000000003]
["746214.017","Швеллер","Швеллер 16П-в ГОСТ8240-98",6.95,1.79]
["746214.018","Швеллер","Швеллер 16П-в ГОСТ8240-97",6.95,1.79]
["746312.046","Скоба","Лист 6 ГОСТ5681-57",0.52,4.0000000000000001E-3]