{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Итог","Сборка","Покупные","Механический","Материал","Крепёж","Данные"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"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":"Итог","index":0,"n_rows":46,"n_cols":7,"rows_kept":46,"cut":false,"hidden":false,"merged":[]}
[]
["№ п/п","Деталь","Наименование","Кол-во деталей"]
[1,"301714.036","Пластина",1]
[2,"304552.058-01","Рычаг",1]
[3,"685121.022-01","Нож контактный",1]
[4,"685172.103","Нож контактный",1]
[5,"715112.028","Ось",1,null,null,"Примерный алгоритм работы"]
[6,"715112.029-01","Вал",1,null,1,"Берём номер из столбца \"Деталь\""]
[7,"715412.012","Ось",1,null,2,"Ищем его на листе \"Данные\""]
[8,"725421.001","Пружинодержатель",1,null,"2.2","Если на листе \"Данные\" в столбце \"Материал\" значение (Сборка), то единица попадает на лист \"Сборка\""]
[9,"731213.001","Кожух",1,null,"2.3","Если на листе \"Данные\" в столбце \"Материал\" значение (Покупные, Кооперация), то единица попадает на лист \"Покупные\""]
[10,"741124.023","Пластина",1,null,"2.4","Если на листе \"Данные\" в столбце \"Материал\" значение (Крепёж), то единица попадает на лист \"Крепёж\""]
[11,"741124.104-01","Планка",1,null,"2.5","Если на листе \"Данные\" в столбце \"Материал\" значение отличное от вержних 3, то единица попадает на лист \"Механический\""]
[12,"743125.002","Рычаг",1,null,7,"Затем заполняется лист Материал"]
[13,"745112.008-01","Пластина",1,null,8,"Берем детали из полученного листа \"Механический\" ищем Материал на листе данные и Норму расхода и ссумируем по потребности данных деталей"]
[14,"745115.002","Пластина",2]
[15,"745212.063","Контакт",1]
[16,"745232.001-01","Угольник",1]
[17,"745242.031-02","Контакт",1]
[18,"745246.002","Контакт",1]
[19,"745247.001","Ламель",2]
[20,"745261.019","Угольник",2]
[21,"753513.001","Пружина",1]
[22,"757491.002","Связь гибкая",1]
[23,"758491.003","Шайба",2]
[24,"758491.040","Шайба",4]
[25,"758491.154-03","Шайба 8х1.02.119 ГОСТ11371-78",13]
[26,"758491.155-06","Шайба 10х1.02.119 ГОСТ11371-78",4]
[27,"758491.156-03","Шайба 12х1.02.119 ГОСТ11371-78",2]
[28,"Болт М10х20","ГОСТ 7798-70",2]
[29,"Болт М10х25","ГОСТ 7798-70",1]
[30,"Болт М10х35","ГОСТ 7798-70",1]
[31,"Болт М12х40","ГОСТ 7798-70",2]
[32,"Болт М8х20","ГОСТ 7798-70",3]
[33,"Болт М8х25","ГОСТ 7796-70",3]
[34,"Болт М8х70","ГОСТ 7798-70",1]
[35,"Гайка М10","ГОСТ 5915-70",2]
[36,"Гайка М12","ГОСТ 5915-70",2]
[37,"Гайка М8","ГОСТ 5915-70",6]
[38,"Заклепка 5х16.38.М3","ГОСТ 10299-80",2]
[39,"С4-80-II УХЛ1","Изолятор ГОСТ 25073-81",1]
[40,"Шайба 10.65Г","ГОСТ 6402-70",4]
[41,"Шайба 12.65Г","ГОСТ 6402-70",2]
[42,"Шайба 8.65Г","ГОСТ 6402-70",6]
[43,"Шплинт 3,2х20","ГОСТ 397-79",1]
[44,"715112.029","Ось",2]

{"sheet":"Сборка","index":1,"n_rows":3,"n_cols":4,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
[{"$f":"MID(CELL(\"filename\",A1),1+SEARCH(\"]\",CELL(\"filename\",A1)),99)","v":"Сборка"}]
["№ п/п","Деталь","Наименование","Кол-во деталей"]
[1,"685121.022-01","Нож контактный",1]

{"sheet":"Покупные","index":2,"n_rows":6,"n_cols":4,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
[{"$f":"MID(CELL(\"filename\",A1),1+SEARCH(\"]\",CELL(\"filename\",A1)),99)","v":"Покупные"}]
["№ п/п","Деталь","Наименование","Кол-во деталей"]
[1,"731213.001","Кожух",1]
[2,"753513.001","Пружина",1]
[3,"757491.002","Связь гибкая",1]
[4,"С4-80-II УХЛ1","Изолятор ГОСТ 25073-81",1]

{"sheet":"Механический","index":3,"n_rows":23,"n_cols":6,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
[{"$f":"MID(CELL(\"filename\",A1),1+SEARCH(\"]\",CELL(\"filename\",A1)),99)","v":"Механический"}]
["№ п/п","Наименование","Деталь","Кол-во деталей","Потребность ,кг","Потребность Итого ,кг"]
[1,"715112.028","Ось",1,"0,014",1.4E-2]
[2,"715112.029-01","Вал",1,"0,444",0.44400000000000001]
[3,"715412.012","Ось",1,"0,023",2.3E-2]
[4,"725421.001","Пружинодержатель",1,"0,005",5.0000000000000001E-3]
[5,"741124.023","Пластина",1,"0,0167",1.67E-2]
[6,"741124.104-01","Планка",1,"0,073",7.2999999999999995E-2]
[7,"743125.002","Рычаг",1,"0,442",0.442]
[8,"745112.008-01","Пластина",1,"0,274",0.27400000000000002]
[9,"745115.002","Пластина",2,"0,274",0.54800000000000004]
[10,"745212.063","Контакт",1,"0,146",0.14599999999999999]
[11,"745232.001-01","Угольник",1,"0,09",0.09]
[12,"745242.031-02","Контакт",1,"0,146",0.14599999999999999]
[13,"745246.002","Контакт",1,"0,097",9.7000000000000003E-2]
[14,"745247.001","Ламель",2,"0,067",0.13400000000000001]
[15,"745261.019","Угольник",2,"0,274",0.54800000000000004]
[16,"758491.003","Шайба",2,"0,046",9.1999999999999998E-2]
[17,"758491.040","Шайба",4,"0,008",3.2000000000000001E-2]
[18,"758491.154-03","Шайба 8х1.02.119 ГОСТ11371-78",13,"0,003",3.9E-2]
[19,"758491.155-06","Шайба 10х1.02.119 ГОСТ11371-78",4,"0,003",1.2E-2]
[20,"758491.156-03","Шайба 12х1.02.119 ГОСТ11371-78",2,"0,003",6.0000000000000001E-3]
[21,"715112.029","Ось",2,"0,014",2.8000000000000001E-2]

{"sheet":"Материал","index":4,"n_rows":17,"n_cols":3,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[{"$f":"MID(CELL(\"filename\",A1),1+SEARCH(\"]\",CELL(\"filename\",A1)),99)","v":"Материал"}]
["№ п/п","Материал","Потребность ,кг"]
[1,"Круг 8-h11х6000/20-В-Н ГОСТ 1051-73",2.8000000000000001E-2]
[2,"Круг 25-h11 ГОСТ 7417-75/20-В-Н ГОСТ 1051-73",0.44400000000000001]
[3,"Круг 10-4 ГОСТ 7417-75",2.3E-2]
[4,"Лист Б-ПН-0-1,0 ГОСТ 19903-74",5.0000000000000001E-3]
[5,"Лист 1х600х1500/ДПРНМ М1 ГОСТ 495-92",1.67E-2]
[6,"Лист 4 Ст3кп",7.2999999999999995E-2]
[7,"Лист 6х1500х3000/Ст3пс 2 ГОСТ 14637-89",0.442]
[8,"Лист 2,5х1250х2500/К270В 4-II-Г ГОСТ 16523-97",0.82199999999999995]
[9,"Лента 3х40 ДПРНТ М1",0.29199999999999998]
[10,"Лист 5 Ст3кп",0.09]
[11,"ПМТ 4,0х20 ГОСТ 434-78",9.7000000000000003E-2]
[12,"Лента 2х40 ДПРНТ М1",6.7000000000000004E-2]
[13,"Лист 4х1500х3000/Ст3пс 2 ГОСТ 14637-89",4.5999999999999999E-2]
[14,"Лист Б-ПН-0-2,5 ГОСТ 19903-74",8.0000000000000002E-3]
[15,"Лист 1х1250х2500/К270В 4-II-Г ГОСТ 16523-97",8.9999999999999993E-3]

{"sheet":"Крепёж","index":5,"n_rows":17,"n_cols":4,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[{"$f":"MID(CELL(\"filename\",A1),1+SEARCH(\"]\",CELL(\"filename\",A1)),99)","v":"Крепёж"}]
["№ п/п","Деталь","Наименование","Кол-во деталей"]
[1,"Болт М10х20","ГОСТ 7798-70",2]
[2,"Болт М10х25","ГОСТ 7798-70",1]
[3,"Болт М10х35","ГОСТ 7798-70",1]
[4,"Болт М12х40","ГОСТ 7798-70",2]
[5,"Болт М8х20","ГОСТ 7798-70",3]
[6,"Болт М8х25","ГОСТ 7796-70",3]
[7,"Болт М8х70","ГОСТ 7798-70",1]
[8,"Гайка М10","ГОСТ 5915-70",2]
[9,"Гайка М12","ГОСТ 5915-70",2]
[10,"Гайка М8","ГОСТ 5915-70",6]
[11,"Заклепка 5х16.38.М3","ГОСТ 10299-80",2]
[12,"Шайба 10.65Г","ГОСТ 6402-70",4]
[13,"Шайба 12.65Г","ГОСТ 6402-70",2]
[14,"Шайба 8.65Г","ГОСТ 6402-70",6]
[15,"Шплинт 3,2х20","ГОСТ 397-79",1]

{"sheet":"Данные","index":6,"n_rows":45,"n_cols":9,"rows_kept":45,"cut":false,"hidden":false,"merged":[]}
["Номер детали","Наименование детали","Материал","Масса детали, кг","Норма расхода, кг","Отходы, кг","Масса детали, кг","Норма расхода, кг","Отходы, кг"]
["301714.036","Пластина","Узел",0,{"$f":"D2","v":0},{"$f":"E2-D2","v":0}]
["304552.058-01","Рычаг","Узел",0,{"$f":"D3","v":0},{"$f":"E3-D3","v":0}]
["685121.022-01","Нож контактный","Сборка",0,{"$f":"D4","v":0},{"$f":"E4-D4","v":0}]
["685172.103","Нож контактный","Узел",0,{"$f":"D5","v":0},{"$f":"E5-D5","v":0}]
["715112.028","Ось","Круг 8-h11х6000/20-В-Н ГОСТ 1051-73",9.7999999999999997E-3,1.4E-2,4.2000000000000006E-3]
["715112.029","Ось","Круг 8-h11х6000/20-В-Н ГОСТ 1051-73",9.7999999999999997E-3,1.4E-2,{"$f":"E7-D7","v":4.2000000000000006E-3}]
["715112.029-01","Вал","Круг 25-h11 ГОСТ 7417-75/20-В-Н ГОСТ 1051-73",0.4,0.44400000000000001,4.3999999999999984E-2]
["715412.012","Ось","Круг 10-4 ГОСТ 7417-75",1.4999999999999999E-2,2.3E-2,{"$f":"E9-D9","v":8.0000000000000002E-3}]
["725421.001","Пружинодержатель","Лист Б-ПН-0-1,0 ГОСТ 19903-74",2E-3,5.0000000000000001E-3,{"$f":"E10-D10","v":3.0000000000000001E-3}]
["731213.001","Кожух","Кооперация",0,{"$f":"D11","v":0},0]
["741124.023","Пластина","Лист 1х600х1500/ДПРНМ М1 ГОСТ 495-92",1.4E-2,1.67E-2,{"$f":"E12-D12","v":2.6999999999999993E-3}]
["741124.104-01","Планка","Лист 4 Ст3кп",0.05,7.2999999999999995E-2,2.2999999999999993E-2]
["743125.002","Рычаг","Лист 6х1500х3000/Ст3пс 2 ГОСТ 14637-89",0.24,0.442,{"$f":"E14-D14","v":0.20200000000000001}]
["745112.008-01","Пластина","Лист 2,5х1250х2500/К270В 4-II-Г ГОСТ 16523-97",0.17,0.27400000000000002,0.10400000000000001]
["745115.002","Пластина","Лист 2,5х1250х2500/К270В 4-II-Г ГОСТ 16523-97",7.0000000000000007E-2,8.5000000000000006E-2,1.4999999999999999E-2]
["745212.063","Контакт","Лента 3х40 ДПРНТ М1",0.14000000000000001,0.14599999999999999,5.9999999999999776E-3]
["745232.001-01","Угольник","Лист 5 Ст3кп",7.0000000000000007E-2,0.09,{"$f":"E18-D18","v":1.999999999999999E-2}]
["745242.031-02","Контакт","Лента 3х40 ДПРНТ М1",0.11799999999999999,0.13350000000000001,1.5500000000000014E-2]
["745246.002","Контакт","ПМТ 4,0х20 ГОСТ 434-78",0.08,9.7000000000000003E-2,1.7000000000000001E-2,0.34,0.44700000000000001,{"$f":"H20-G20","v":0.10699999999999998}]
["745247.001","Ламель","Лента 2х40 ДПРНТ М1",5.6000000000000001E-2,6.7000000000000004E-2,1.1000000000000003E-2]
["745261.019","Угольник","Лист 2,5х1250х2500/К270В 4-II-Г ГОСТ 16523-97",2.5999999999999999E-2,0.03,{"$f":"E22-D22","v":4.0000000000000001E-3}]
["753513.001","Пружина","Кооперация",0,{"$f":"D23","v":0},{"$f":"E23-D23","v":0}]
["757491.002","Связь гибкая","Кооперация",0,{"$f":"D24","v":0},{"$f":"E24-D24","v":0}]
["758491.003","Шайба","Лист 4х1500х3000/Ст3пс 2 ГОСТ 14637-89",3.1E-2,4.5999999999999999E-2,{"$f":"E25-D25","v":1.4999999999999999E-2}]
["758491.040","Шайба","Лист Б-ПН-0-2,5 ГОСТ 19903-74",3.0000000000000001E-3,8.0000000000000002E-3,5.0000000000000001E-3]
["758491.154-03","Шайба 8х1.02.119 ГОСТ11371-78","Лист 1х1250х2500/К270В 4-II-Г ГОСТ 16523-97",1.1000000000000001E-3,3.0000000000000001E-3,{"$f":"E27-D27","v":1.9E-3}]
["758491.155-06","Шайба 10х1.02.119 ГОСТ11371-78","Лист 1х1250х2500/К270В 4-II-Г ГОСТ 16523-97",1.7799999999999999E-3,4.0000000000000001E-3,2.2200000000000002E-3]
["758491.156-03","Шайба 12х1.02.119 ГОСТ11371-78","Лист 1х1250х2500/К270В 4-II-Г ГОСТ 16523-97",2.5000000000000001E-3,5.0000000000000001E-3,2.5000000000000001E-3]
["Болт М10х20","ГОСТ 7798-70","Крепеж",0,{"$f":"D30","v":0},0]
["Болт М10х25","ГОСТ 7798-70","Крепеж",0,0,0]
["Болт М10х35","ГОСТ 7798-70","Крепеж",0,0,0]
["Болт М12х40","ГОСТ 7798-70","Крепеж",0,0,{"$f":"E33-D33","v":0}]
["Болт М8х20","ГОСТ 7798-70","Крепеж",0,0,0]
["Болт М8х25","ГОСТ 7796-70","Крепеж",0,0,0]
["Болт М8х70","ГОСТ 7798-70","Крепеж",0,0,0]
["Гайка М10","ГОСТ 5915-70","Крепеж",0,{"$f":"D37","v":0},{"$f":"E37-D37","v":0}]
["Гайка М12","ГОСТ 5915-70","Крепеж",0,0,{"$f":"E38-D38","v":0}]
["Гайка М8","ГОСТ 5915-70","Крепеж",0,0,0]
["Заклепка 5х16.38.М3","ГОСТ 10299-80","Крепеж",0,0,0]
["С4-80-II УХЛ1","Изолятор ГОСТ 25073-81","Кооперация",0,{"$f":"D41","v":0},{"$f":"E41-D41","v":0}]
["Шайба 10.65Г","ГОСТ 6402-70","Крепеж",0,{"$f":"D42","v":0},{"$f":"E42-D42","v":0}]
["Шайба 12.65Г","ГОСТ 6402-70","Крепеж",0,0,0]
["Шайба 8.65Г","ГОСТ 6402-70","Крепеж",0,0,0]
["Шплинт 3,2х20","ГОСТ 397-79","Крепеж",0,0,0]