{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Классификатор"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":1,"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":141,"n_cols":20,"rows_kept":141,"cut":false,"hidden":false,"merged":[[0,0,0,4],[42,2,56,2],[2,11,2,17]]}
["ЗАДАЧА.\nНеобходимо, чтобы при выборе значения в столбце 1 (Узел)-12 значений, в столбце 2 (механизм), находился свой список из таблицы справа - 12 списков. \nПопытались сделать список по условию, но ограничивает только 6-ю условиями. Помогите, пожалуйста, как реализовать, может есть более простой вариант. \nЗаранее спасибо!"]
["1\nУзел","2\nМеханизм","3\nМеханизм","4\nВид неисправност","5\nВид неисправност (вспом ячейка)",null,1,2,3,4,5,6,7,8,9,10,11,12]
[null,null,null,{"$f":"IF(E3=1,$H$49,IF(E3=2,$H$50,IF(E3=3,$H$51,IF(E3=4,$H$52,0))))","v":0},{"$f":"SUM(IF($J$49:$J$151=C3,$L$49:$L$151,0))","v":0},null,"Мост","Кабина","АСУТП","Гидравл","Эл. Тельфер 6,3","Телега",null,null,null,null,null,null,"Провели ТО","Не провели ТО"]
["Провели ТО",null,null,{"$f":"IF(E4=1,$H$49,IF(E4=2,$H$50,IF(E4=3,$H$51,IF(E4=4,$H$52,0))))","v":0},{"$f":"SUM(IF($J$49:$J$151=C4,$L$49:$L$151,0))","v":0},null,"ВК вперед","Гидротолкатель","Привод","Вращение штанги (г\\активатор)","Канат","Передвижение","Главный подъем","Вспомогательный подъем ","Желоб","Бункер ПАМ","Ключ","Ключ (Noel)"]
[null,null,null,{"$f":"IF(E5=1,$H$49,IF(E5=2,$H$50,IF(E5=3,$H$51,IF(E5=4,$H$52,0))))","v":0},{"$f":"SUM(IF($J$49:$J$151=C5,$L$49:$L$151,0))","v":0},null,"ВК калитки","Гидротолкатель (подъём)","Модуль","Г\\мотор вращения ключа","Барабан","ВК влево","Барабан","Барабан","Барабан","Канат","Барабан","Мотор-редуктор (подъём)"]
[null,null,null,{"$f":"IF(E6=1,$H$49,IF(E6=2,$H$50,IF(E6=3,$H$51,IF(E6=4,$H$52,0))))","v":0},{"$f":"SUM(IF($J$49:$J$151=C6,$L$49:$L$151,0))","v":0},null,"ВК назад","Канат подъёма","видео камера","Г\\шланг","Гидротолкатель (подъём)","ВК вправо","ВК вира","ВК вира","Блоки","Барабан","Блоки","Редуктор (вращения)"]
["Кабина","Колесо ведомое","Колесо ведомое",{"$f":"IF(E7=1,$H$49,IF(E7=2,$H$50,IF(E7=3,$H$51,IF(E7=4,$H$52,0))))","v":"Механическая часть"},{"$f":"SUM(IF($J$49:$J$151=C7,$L$49:$L$151,0))","v":1},null,"Линейка ВК","Колесо ведомое","Лазер","М\\магистраль","Колесо ведомое","Гидротолкатель","ВК роспуска","Гидротолкатель (подъём)","Канат","Гидротолкатель","Головка ключа","Тормозной диск"]
["Телега","Желоб","Канат",{"$f":"IF(E8=1,$H$49,IF(E8=2,$H$50,IF(E8=3,$H$51,IF(E8=4,$H$52,0))))","v":"Механическая часть"},{"$f":"SUM(IF($J$49:$J$151=C8,$L$49:$L$151,0))","v":1},null,"Гидротолкатель","Колесо ведущее","Энкодер","Опрокидывание дозатора (г\\активатор)","Колесо ведущее","Гидротолкатель","Гидротолкатель (вращения)","Канат","Мотор-редуктор ","Крюковая подвеска","Канат","Цепь"]
["Гидравл","Г\\панель","Г\\панель",{"$f":"IF(E9=1,$H$49,IF(E9=2,$H$50,IF(E9=3,$H$51,IF(E9=4,$H$52,0))))","v":"Гидравлическая часть"},{"$f":"SUM(IF($J$49:$J$151=C9,$L$49:$L$151,0))","v":3},null,"Колесо ведомое (лев)","Мотор-редуктор (карусель)","Джойстик","Поворот жёлоба","Редуктор","Дроссель","Гидротолкатель (подъём)","Крюковая подвеска","Мотор-редуктор (отвод)","Редуктор","Кардан ","Электродвигатель (вращения)"]
["Телега","Главный подъем","ВК вира",{"$f":"IF(E10=1,$H$49,IF(E10=2,$H$50,IF(E10=3,$H$51,IF(E10=4,$H$52,0))))","v":"Электрическая часть"},{"$f":"SUM(IF($J$49:$J$151=C10,$L$49:$L$151,0))","v":2},null,"Колесо ведомое (прав)","Редуктор","НЕ ОПРЕДЕЛЕНО","Подъём/опускание ключа","Редуктор передвижения","Колесо ведомое","Головка АЗУ","Промежут.вал (горизонт.)","Тормозной диск","Секторный (СЗТМ)","Мотор-редуктор (подъём)","НЕ ОПРЕДЕЛЕНО"]
["Телега","Главный подъем","Направляющие",{"$f":"IF(E11=1,$H$49,IF(E11=2,$H$50,IF(E11=3,$H$51,IF(E11=4,$H$52,0))))","v":"Механическая часть"},{"$f":"SUM(IF($J$49:$J$151=C11,$L$49:$L$151,0))","v":1},null,"Колесо ведущее (лев)","Редуктор подъёма",null,"Редуктор","Электродвигатель","Колесо ведущее","Канат","Редуктор","НЕ ОПРЕДЕЛЕНО","Электродвигатель","Редуктор (вращения)"]
[null,null,null,{"$f":"IF(E12=1,$H$49,IF(E12=2,$H$50,IF(E12=3,$H$51,IF(E12=4,$H$52,0))))","v":0},{"$f":"SUM(IF($J$49:$J$151=C12,$L$49:$L$151,0))","v":0},null,"Колесо ведущее (прав)","Электродвигатель",null,"Штуцера","Электродвигатель передвижения","Линейка ВК","Палец АЗУ","Редуктор  вращения",null,"НЕ ОПРЕДЕЛЕНО","Тормозной диск"]
[null,null,null,{"$f":"IF(E13=1,$H$49,IF(E13=2,$H$50,IF(E13=3,$H$51,IF(E13=4,$H$52,0))))","v":0},{"$f":"SUM(IF($J$49:$J$151=C13,$L$49:$L$151,0))","v":0},null,"Линейка ВК","Электродвигатель подъёма",null,"Электродвигатель","Крюковая подвеска","Подтележечный путь","Промежут.вал (вертик.)","Тормозная упряжка",null,null,"Электродвигатель (вращения)"]
[null,null,null,{"$f":"IF(E14=1,$H$49,IF(E14=2,$H$50,IF(E14=3,$H$51,IF(E14=4,$H$52,0))))","v":0},{"$f":"SUM(IF($J$49:$J$151=C14,$L$49:$L$151,0))","v":0},null,"Полумуфта","Контроллер",null,"Г\\панель","НЕ ОПРЕДЕЛЕНО","Полумуфта","Промежут.вал (горизонт.)","Тормозной шкив",null,null,"НЕ ОПРЕДЕЛЕНО"]
[null,null,null,{"$f":"IF(E15=1,$H$49,IF(E15=2,$H$50,IF(E15=3,$H$51,IF(E15=4,$H$52,0))))","v":0},{"$f":"SUM(IF($J$49:$J$151=C15,$L$49:$L$151,0))","v":0},null,"Промежут.вал (горизонт.)","Печь",null,"НЕ ОПРЕДЕЛЕНО",null,"Промежут.вал (горизонт.)","Редуктор (верхний)","Ур/блок"]
[null,null,null,{"$f":"IF(E16=1,$H$49,IF(E16=2,$H$50,IF(E16=3,$H$51,IF(E16=4,$H$52,0))))","v":0},{"$f":"SUM(IF($J$49:$J$151=C16,$L$49:$L$151,0))","v":0},null,"Редуктор","ПКСИ",null,null,null,"Редуктор","Редуктор (нижний)","Электродвигатель"]
[null,null,null,{"$f":"IF(E17=1,$H$49,IF(E17=2,$H$50,IF(E17=3,$H$51,IF(E17=4,$H$52,0))))","v":0},{"$f":"SUM(IF($J$49:$J$151=C17,$L$49:$L$151,0))","v":0},null,"Тормозная упряжка","БКИ",null,null,null,"Тормозная упряжка","Редуктор (подъём)","Электродвигатель вращения"]
[null,null,null,{"$f":"IF(E18=1,$H$49,IF(E18=2,$H$50,IF(E18=3,$H$51,IF(E18=4,$H$52,0))))","v":0},{"$f":"SUM(IF($J$49:$J$151=C18,$L$49:$L$151,0))","v":0},null,"Тормозной шкив","ЗУКН",null,null,null,"Тормозной шкив","Редуктор планетарный","НЕ ОПРЕДЕЛЕНО"]
[null,null,null,{"$f":"IF(E19=1,$H$49,IF(E19=2,$H$50,IF(E19=3,$H$51,IF(E19=4,$H$52,0))))","v":0},{"$f":"SUM(IF($J$49:$J$151=C19,$L$49:$L$151,0))","v":0},null,"Электродвигатель","Освещение",null,null,null,"электродвигатель","Стакан"]
[null,null,null,{"$f":"IF(E20=1,$H$49,IF(E20=2,$H$50,IF(E20=3,$H$51,IF(E20=4,$H$52,0))))","v":0},{"$f":"SUM(IF($J$49:$J$151=C20,$L$49:$L$151,0))","v":0},null,"КПК",null,null,null,null,"НЕ ОПРЕДЕЛЕНО","Тормозная упряжка (вращения)"]
[null,null,null,{"$f":"IF(E21=1,$H$49,IF(E21=2,$H$50,IF(E21=3,$H$51,IF(E21=4,$H$52,0))))","v":0},{"$f":"SUM(IF($J$49:$J$151=C21,$L$49:$L$151,0))","v":0},null,"КПТ","НЕ ОПРЕДЕЛЕНО",null,null,null,null,"Тормозная упряжка (подъём)"]
[null,null,null,{"$f":"IF(E22=1,$H$49,IF(E22=2,$H$50,IF(E22=3,$H$51,IF(E22=4,$H$52,0))))","v":0},{"$f":"SUM(IF($J$49:$J$151=C22,$L$49:$L$151,0))","v":0},null,"Подкрановое освещение",null,null,null,null,null,"Тормозной шкив (вращения)"]
[null,null,null,{"$f":"IF(E23=1,$H$49,IF(E23=2,$H$50,IF(E23=3,$H$51,IF(E23=4,$H$52,0))))","v":0},{"$f":"SUM(IF($J$49:$J$151=C23,$L$49:$L$151,0))","v":0},null,"Токосъёмники",null,null,null,null,null,"Тормозной шкив (подъём)"]
[null,null,null,{"$f":"IF(E24=1,$H$49,IF(E24=2,$H$50,IF(E24=3,$H$51,IF(E24=4,$H$52,0))))","v":0},{"$f":"SUM(IF($J$49:$J$151=C24,$L$49:$L$151,0))","v":0},null,"НЕ ОПРЕДЕЛЕНО",null,null,null,null,null,"Торсион"]
[null,null,null,{"$f":"IF(E25=1,$H$49,IF(E25=2,$H$50,IF(E25=3,$H$51,IF(E25=4,$H$52,0))))","v":0},{"$f":"SUM(IF($J$49:$J$151=C25,$L$49:$L$151,0))","v":0},null,null,null,null,null,null,null,"Кормысло"]
[null,null,null,{"$f":"IF(E26=1,$H$49,IF(E26=2,$H$50,IF(E26=3,$H$51,IF(E26=4,$H$52,0))))","v":0},{"$f":"SUM(IF($J$49:$J$151=C26,$L$49:$L$151,0))","v":0},null,null,null,null,null,null,null,"Траверса"]
[null,null,null,{"$f":"IF(E27=1,$H$49,IF(E27=2,$H$50,IF(E27=3,$H$51,IF(E27=4,$H$52,0))))","v":0},{"$f":"SUM(IF($J$49:$J$151=C27,$L$49:$L$151,0))","v":0},null,null,null,null,null,null,null,"Хвостовик"]
[null,null,null,{"$f":"IF(E28=1,$H$49,IF(E28=2,$H$50,IF(E28=3,$H$51,IF(E28=4,$H$52,0))))","v":0},{"$f":"SUM(IF($J$49:$J$151=C28,$L$49:$L$151,0))","v":0},null,null,null,null,null,null,null,"Штанга"]
[null,null,null,{"$f":"IF(E29=1,$H$49,IF(E29=2,$H$50,IF(E29=3,$H$51,IF(E29=4,$H$52,0))))","v":0},{"$f":"SUM(IF($J$49:$J$151=C29,$L$49:$L$151,0))","v":0},null,null,null,null,null,null,null,"Электродвигатель (вращения)"]
[null,null,null,{"$f":"IF(E30=1,$H$49,IF(E30=2,$H$50,IF(E30=3,$H$51,IF(E30=4,$H$52,0))))","v":0},{"$f":"SUM(IF($J$49:$J$151=C30,$L$49:$L$151,0))","v":0},null,null,null,null,null,null,null,"электродвигатель (подъём)"]
[null,null,null,{"$f":"IF(E31=1,$H$49,IF(E31=2,$H$50,IF(E31=3,$H$51,IF(E31=4,$H$52,0))))","v":0},{"$f":"SUM(IF($J$49:$J$151=C31,$L$49:$L$151,0))","v":0},null,null,null,null,null,null,null,"Направляющие"]
[null,null,null,{"$f":"IF(E32=1,$H$49,IF(E32=2,$H$50,IF(E32=3,$H$51,IF(E32=4,$H$52,0))))","v":0},{"$f":"SUM(IF($J$49:$J$151=C32,$L$49:$L$151,0))","v":0},null,null,null,null,null,null,null,"НЕ ОПРЕДЕЛЕНО"]
[null,null,null,{"$f":"IF(E33=1,$H$49,IF(E33=2,$H$50,IF(E33=3,$H$51,IF(E33=4,$H$52,0))))","v":0},{"$f":"SUM(IF($J$49:$J$151=C33,$L$49:$L$151,0))","v":0}]
[null,null,null,{"$f":"IF(E34=1,$H$49,IF(E34=2,$H$50,IF(E34=3,$H$51,IF(E34=4,$H$52,0))))","v":0},{"$f":"SUM(IF($J$49:$J$151=C34,$L$49:$L$151,0))","v":0}]
[null,null,null,{"$f":"IF(E35=1,$H$49,IF(E35=2,$H$50,IF(E35=3,$H$51,IF(E35=4,$H$52,0))))","v":0},{"$f":"SUM(IF($J$49:$J$151=C35,$L$49:$L$151,0))","v":0}]
[null,null,null,{"$f":"IF(E36=1,$H$49,IF(E36=2,$H$50,IF(E36=3,$H$51,IF(E36=4,$H$52,0))))","v":0},{"$f":"SUM(IF($J$49:$J$151=C36,$L$49:$L$151,0))","v":0}]
[null,null,null,{"$f":"IF(E37=1,$H$49,IF(E37=2,$H$50,IF(E37=3,$H$51,IF(E37=4,$H$52,0))))","v":0},{"$f":"SUM(IF($J$49:$J$151=C37,$L$49:$L$151,0))","v":0}]
[null,null,null,{"$f":"IF(E38=1,$H$49,IF(E38=2,$H$50,IF(E38=3,$H$51,IF(E38=4,$H$52,0))))","v":0},{"$f":"SUM(IF($J$49:$J$151=C38,$L$49:$L$151,0))","v":0}]
[null,null,null,{"$f":"IF(E39=1,$H$49,IF(E39=2,$H$50,IF(E39=3,$H$51,IF(E39=4,$H$52,0))))","v":0},{"$f":"SUM(IF($J$49:$J$151=C39,$L$49:$L$151,0))","v":0}]
[null,null,null,{"$f":"IF(E40=1,$H$49,IF(E40=2,$H$50,IF(E40=3,$H$51,IF(E40=4,$H$52,0))))","v":0},{"$f":"SUM(IF($J$49:$J$151=C40,$L$49:$L$151,0))","v":0}]
[null,null,null,{"$f":"IF(E41=1,$H$49,IF(E41=2,$H$50,IF(E41=3,$H$51,IF(E41=4,$H$52,0))))","v":0},{"$f":"SUM(IF($J$49:$J$151=C41,$L$49:$L$151,0))","v":0}]
[null,null,null,{"$f":"IF(E42=1,$H$49,IF(E42=2,$H$50,IF(E42=3,$H$51,IF(E42=4,$H$52,0))))","v":0},{"$f":"SUM(IF($J$49:$J$151=C42,$L$49:$L$151,0))","v":0}]
[null,null,"КАК ИСКЛЮЧИТЬ ЭТОТ СТОЛБЕЦ"]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,1,"Механическая часть",null,"Барабан","Механическая часть",{"$f":"SUM(IF(K49=$H$49:$H$52,$G$49:$G$52,0))","v":1}]
[null,null,null,null,null,null,2,"Электрическая часть",null,"БКИ","Электрическая часть",{"$f":"SUM(IF(K50=$H$49:$H$52,$G$49:$G$52,0))","v":2}]
[null,null,null,null,null,null,3,"Гидравлическая часть",null,"Блоки","Механическая часть",{"$f":"SUM(IF(K51=$H$49:$H$52,$G$49:$G$52,0))","v":1}]
[null,null,null,null,null,null,4,"Средства автоматизации",null,"видео камера","Средства автоматизации",{"$f":"SUM(IF(K52=$H$49:$H$52,$G$49:$G$52,0))","v":4}]
[null,null,null,null,null,null,null,null,null,"ВК вира","Электрическая часть",{"$f":"SUM(IF(K53=$H$49:$H$52,$G$49:$G$52,0))","v":2}]
[null,null,null,null,null,null,null,null,null,"ВК влево","Электрическая часть",{"$f":"SUM(IF(K54=$H$49:$H$52,$G$49:$G$52,0))","v":2}]
[null,null,null,null,null,null,null,null,null,"ВК вперед","Электрическая часть",{"$f":"SUM(IF(K55=$H$49:$H$52,$G$49:$G$52,0))","v":2}]
[null,null,null,null,null,null,null,null,null,"ВК вправо","Электрическая часть",{"$f":"SUM(IF(K56=$H$49:$H$52,$G$49:$G$52,0))","v":2}]
[null,null,null,null,null,null,null,null,null,"ВК калитки","Электрическая часть",{"$f":"SUM(IF(K57=$H$49:$H$52,$G$49:$G$52,0))","v":2}]
[null,null,null,null,null,null,null,null,null,"ВК назад","Электрическая часть",{"$f":"SUM(IF(K58=$H$49:$H$52,$G$49:$G$52,0))","v":2}]
[null,null,null,null,null,null,null,null,null,"ВК роспуска","Электрическая часть",{"$f":"SUM(IF(K59=$H$49:$H$52,$G$49:$G$52,0))","v":2}]
[null,null,null,null,null,null,null,null,null,"Вращение штанги (г\\активатор)","Гидравлическая часть",{"$f":"SUM(IF(K60=$H$49:$H$52,$G$49:$G$52,0))","v":3}]
[null,null,null,null,null,null,null,null,null,"Г\\мотор вращения ключа","Гидравлическая часть",{"$f":"SUM(IF(K61=$H$49:$H$52,$G$49:$G$52,0))","v":3}]
[null,null,null,null,null,null,null,null,null,"Г\\шланг","Гидравлическая часть",{"$f":"SUM(IF(K62=$H$49:$H$52,$G$49:$G$52,0))","v":3}]
[null,null,null,null,null,null,null,null,null,"Гидротолкатель","Электрическая часть",{"$f":"SUM(IF(K63=$H$49:$H$52,$G$49:$G$52,0))","v":2}]
[null,null,null,null,null,null,null,null,null,"Гидротолкатель (вращения)","Электрическая часть",{"$f":"SUM(IF(K64=$H$49:$H$52,$G$49:$G$52,0))","v":2}]
[null,null,null,null,null,null,null,null,null,"Гидротолкатель (подъём)","Электрическая часть",{"$f":"SUM(IF(K65=$H$49:$H$52,$G$49:$G$52,0))","v":2}]
[null,null,null,null,null,null,null,null,null,"Гидротолкатель подъёма","Электрическая часть",{"$f":"SUM(IF(K66=$H$49:$H$52,$G$49:$G$52,0))","v":2}]
[null,null,null,null,null,null,null,null,null,"Головка АЗУ","Механическая часть",{"$f":"SUM(IF(K67=$H$49:$H$52,$G$49:$G$52,0))","v":1}]
[null,null,null,null,null,null,null,null,null,"Головка ключа","Механическая часть",{"$f":"SUM(IF(K68=$H$49:$H$52,$G$49:$G$52,0))","v":1}]
[null,null,null,null,null,null,null,null,null,"Джойстик","Средства автоматизации",{"$f":"SUM(IF(K69=$H$49:$H$52,$G$49:$G$52,0))","v":4}]
[null,null,null,null,null,null,null,null,null,"Дроссель","Электрическая часть",{"$f":"SUM(IF(K70=$H$49:$H$52,$G$49:$G$52,0))","v":2}]
[null,null,null,null,null,null,null,null,null,"ЗУКН","Электрическая часть",{"$f":"SUM(IF(K71=$H$49:$H$52,$G$49:$G$52,0))","v":2}]
[null,null,null,null,null,null,null,null,null,"Канат","Механическая часть",{"$f":"SUM(IF(K72=$H$49:$H$52,$G$49:$G$52,0))","v":1}]
[null,null,null,null,null,null,null,null,null,"Канат подъёма","Механическая часть",{"$f":"SUM(IF(K73=$H$49:$H$52,$G$49:$G$52,0))","v":1}]
[null,null,null,null,null,null,null,null,null,"Кардан ","Механическая часть",{"$f":"SUM(IF(K74=$H$49:$H$52,$G$49:$G$52,0))","v":1}]
[null,null,null,null,null,null,null,null,null,"Колесо ведомое","Механическая часть",{"$f":"SUM(IF(K75=$H$49:$H$52,$G$49:$G$52,0))","v":1}]
[null,null,null,null,null,null,null,null,null,"Колесо ведомое (лев)","Механическая часть",{"$f":"SUM(IF(K76=$H$49:$H$52,$G$49:$G$52,0))","v":1}]
[null,null,null,null,null,null,null,null,null,"Колесо ведомое (прав)","Механическая часть",{"$f":"SUM(IF(K77=$H$49:$H$52,$G$49:$G$52,0))","v":1}]
[null,null,null,null,null,null,null,null,null,"Колесо ведущее","Механическая часть",{"$f":"SUM(IF(K78=$H$49:$H$52,$G$49:$G$52,0))","v":1}]
[null,null,null,null,null,null,null,null,null,"Колесо ведущее (лев)","Механическая часть",{"$f":"SUM(IF(K79=$H$49:$H$52,$G$49:$G$52,0))","v":1}]
[null,null,null,null,null,null,null,null,null,"Колесо ведущее (прав)","Механическая часть",{"$f":"SUM(IF(K80=$H$49:$H$52,$G$49:$G$52,0))","v":1}]
[null,null,null,null,null,null,null,null,null,"Контроллер","Электрическая часть",{"$f":"SUM(IF(K81=$H$49:$H$52,$G$49:$G$52,0))","v":2}]
[null,null,null,null,null,null,null,null,null,"Кормысло","Механическая часть",{"$f":"SUM(IF(K82=$H$49:$H$52,$G$49:$G$52,0))","v":1}]
[null,null,null,null,null,null,null,null,null,"КПК","Электрическая часть",{"$f":"SUM(IF(K83=$H$49:$H$52,$G$49:$G$52,0))","v":2}]
[null,null,null,null,null,null,null,null,null,"КПТ","Электрическая часть",{"$f":"SUM(IF(K84=$H$49:$H$52,$G$49:$G$52,0))","v":2}]
[null,null,null,null,null,null,null,null,null,"Крюковая подвеска","Механическая часть",{"$f":"SUM(IF(K85=$H$49:$H$52,$G$49:$G$52,0))","v":1}]
[null,null,null,null,null,null,null,null,null,"Лазер","Средства автоматизации",{"$f":"SUM(IF(K86=$H$49:$H$52,$G$49:$G$52,0))","v":4}]
[null,null,null,null,null,null,null,null,null,"Линейка ВК","Электрическая часть",{"$f":"SUM(IF(K87=$H$49:$H$52,$G$49:$G$52,0))","v":2}]
[null,null,null,null,null,null,null,null,null,"М\\магистраль","Гидравлическая часть",{"$f":"SUM(IF(K88=$H$49:$H$52,$G$49:$G$52,0))","v":3}]
[null,null,null,null,null,null,null,null,null,"Модуль","Средства автоматизации",{"$f":"SUM(IF(K89=$H$49:$H$52,$G$49:$G$52,0))","v":4}]
[null,null,null,null,null,null,null,null,null,"Мотор-редуктор ","Механическая часть",{"$f":"SUM(IF(K90=$H$49:$H$52,$G$49:$G$52,0))","v":1}]
[null,null,null,null,null,null,null,null,null,"Мотор-редуктор (карусель)","Механическая часть",{"$f":"SUM(IF(K91=$H$49:$H$52,$G$49:$G$52,0))","v":1}]
[null,null,null,null,null,null,null,null,null,"Мотор-редуктор (отвод)","Механическая часть",{"$f":"SUM(IF(K92=$H$49:$H$52,$G$49:$G$52,0))","v":1}]
[null,null,null,null,null,null,null,null,null,"Мотор-редуктор (подъём)","Механическая часть",{"$f":"SUM(IF(K93=$H$49:$H$52,$G$49:$G$52,0))","v":1}]
[null,null,null,null,null,null,null,null,null,"Мотор-редуктор (подъём)","Механическая часть",{"$f":"SUM(IF(K94=$H$49:$H$52,$G$49:$G$52,0))","v":1}]
[null,null,null,null,null,null,null,null,null,"Опрокидывание дозатора (г\\активатор)","Гидравлическая часть",{"$f":"SUM(IF(K95=$H$49:$H$52,$G$49:$G$52,0))","v":3}]
[null,null,null,null,null,null,null,null,null,"Освещение","Электрическая часть",{"$f":"SUM(IF(K96=$H$49:$H$52,$G$49:$G$52,0))","v":2}]
[null,null,null,null,null,null,null,null,null,"Палец АЗУ","Механическая часть",{"$f":"SUM(IF(K97=$H$49:$H$52,$G$49:$G$52,0))","v":1}]
[null,null,null,null,null,null,null,null,null,"Печь","Электрическая часть",{"$f":"SUM(IF(K98=$H$49:$H$52,$G$49:$G$52,0))","v":2}]
[null,null,null,null,null,null,null,null,null,"ПКСИ","Электрическая часть",{"$f":"SUM(IF(K99=$H$49:$H$52,$G$49:$G$52,0))","v":2}]
[null,null,null,null,null,null,null,null,null,"Поворот жёлоба","Гидравлическая часть",{"$f":"SUM(IF(K100=$H$49:$H$52,$G$49:$G$52,0))","v":3}]
[null,null,null,null,null,null,null,null,null,"Подкрановое освещение","Электрическая часть",{"$f":"SUM(IF(K101=$H$49:$H$52,$G$49:$G$52,0))","v":2}]
[null,null,null,null,null,null,null,null,null,"Подтележечный путь","Механическая часть",{"$f":"SUM(IF(K102=$H$49:$H$52,$G$49:$G$52,0))","v":1}]
[null,null,null,null,null,null,null,null,null,"Подъём/опускание ключа","Электрическая часть",{"$f":"SUM(IF(K103=$H$49:$H$52,$G$49:$G$52,0))","v":2}]
[null,null,null,null,null,null,null,null,null,"Полумуфта","Механическая часть",{"$f":"SUM(IF(K104=$H$49:$H$52,$G$49:$G$52,0))","v":1}]
[null,null,null,null,null,null,null,null,null,"Привод","Средства автоматизации",{"$f":"SUM(IF(K105=$H$49:$H$52,$G$49:$G$52,0))","v":4}]
[null,null,null,null,null,null,null,null,null,"Промежут.вал (вертик.)","Механическая часть",{"$f":"SUM(IF(K106=$H$49:$H$52,$G$49:$G$52,0))","v":1}]
[null,null,null,null,null,null,null,null,null,"Промежут.вал (горизонт.)","Механическая часть",{"$f":"SUM(IF(K107=$H$49:$H$52,$G$49:$G$52,0))","v":1}]
[null,null,null,null,null,null,null,null,null,"Редуктор","Механическая часть",{"$f":"SUM(IF(K108=$H$49:$H$52,$G$49:$G$52,0))","v":1}]
[null,null,null,null,null,null,null,null,null,"Редуктор  вращения","Механическая часть",{"$f":"SUM(IF(K109=$H$49:$H$52,$G$49:$G$52,0))","v":1}]
[null,null,null,null,null,null,null,null,null,"Редуктор (верхний)","Механическая часть",{"$f":"SUM(IF(K110=$H$49:$H$52,$G$49:$G$52,0))","v":1}]
[null,null,null,null,null,null,null,null,null,"Редуктор (вращения)","Механическая часть",{"$f":"SUM(IF(K111=$H$49:$H$52,$G$49:$G$52,0))","v":1}]
[null,null,null,null,null,null,null,null,null,"Редуктор (вращения)","Механическая часть",{"$f":"SUM(IF(K112=$H$49:$H$52,$G$49:$G$52,0))","v":1}]
[null,null,null,null,null,null,null,null,null,"Редуктор (нижний)","Механическая часть",{"$f":"SUM(IF(K113=$H$49:$H$52,$G$49:$G$52,0))","v":1}]
[null,null,null,null,null,null,null,null,null,"Редуктор (подъём)","Механическая часть",{"$f":"SUM(IF(K114=$H$49:$H$52,$G$49:$G$52,0))","v":1}]
[null,null,null,null,null,null,null,null,null,"Редуктор передвижения","Механическая часть",{"$f":"SUM(IF(K115=$H$49:$H$52,$G$49:$G$52,0))","v":1}]
[null,null,null,null,null,null,null,null,null,"Редуктор планетарный","Механическая часть",{"$f":"SUM(IF(K116=$H$49:$H$52,$G$49:$G$52,0))","v":1}]
[null,null,null,null,null,null,null,null,null,"Редуктор подъёма","Механическая часть",{"$f":"SUM(IF(K117=$H$49:$H$52,$G$49:$G$52,0))","v":1}]
[null,null,null,null,null,null,null,null,null,"Секторный (СЗТМ)","Механическая часть",{"$f":"SUM(IF(K118=$H$49:$H$52,$G$49:$G$52,0))","v":1}]
[null,null,null,null,null,null,null,null,null,"Стакан","Механическая часть",{"$f":"SUM(IF(K119=$H$49:$H$52,$G$49:$G$52,0))","v":1}]
[null,null,null,null,null,null,null,null,null,"Тормозная упряжка","Механическая часть",{"$f":"SUM(IF(K120=$H$49:$H$52,$G$49:$G$52,0))","v":1}]
[null,null,null,null,null,null,null,null,null,"Тормозная упряжка (вращения)","Механическая часть",{"$f":"SUM(IF(K121=$H$49:$H$52,$G$49:$G$52,0))","v":1}]
[null,null,null,null,null,null,null,null,null,"Тормозная упряжка (подъём)","Механическая часть",{"$f":"SUM(IF(K122=$H$49:$H$52,$G$49:$G$52,0))","v":1}]
[null,null,null,null,null,null,null,null,null,"Тормозной диск","Механическая часть",{"$f":"SUM(IF(K123=$H$49:$H$52,$G$49:$G$52,0))","v":1}]
[null,null,null,null,null,null,null,null,null,"Тормозной шкив","Механическая часть",{"$f":"SUM(IF(K124=$H$49:$H$52,$G$49:$G$52,0))","v":1}]
[null,null,null,null,null,null,null,null,null,"Тормозной шкив (вращения)","Механическая часть",{"$f":"SUM(IF(K125=$H$49:$H$52,$G$49:$G$52,0))","v":1}]
[null,null,null,null,null,null,null,null,null,"Тормозной шкив (подъём)","Механическая часть",{"$f":"SUM(IF(K126=$H$49:$H$52,$G$49:$G$52,0))","v":1}]
[null,null,null,null,null,null,null,null,null,"Торсион","Механическая часть",{"$f":"SUM(IF(K127=$H$49:$H$52,$G$49:$G$52,0))","v":1}]
[null,null,null,null,null,null,null,null,null,"Траверса","Механическая часть",{"$f":"SUM(IF(K128=$H$49:$H$52,$G$49:$G$52,0))","v":1}]
[null,null,null,null,null,null,null,null,null,"Ур/блок","Механическая часть",{"$f":"SUM(IF(K129=$H$49:$H$52,$G$49:$G$52,0))","v":1}]
[null,null,null,null,null,null,null,null,null,"Хвостовик","Механическая часть",{"$f":"SUM(IF(K130=$H$49:$H$52,$G$49:$G$52,0))","v":1}]
[null,null,null,null,null,null,null,null,null,"Цепь","Механическая часть",{"$f":"SUM(IF(K131=$H$49:$H$52,$G$49:$G$52,0))","v":1}]
[null,null,null,null,null,null,null,null,null,"Штанга","Механическая часть",{"$f":"SUM(IF(K132=$H$49:$H$52,$G$49:$G$52,0))","v":1}]
[null,null,null,null,null,null,null,null,null,"Штуцера","Гидравлическая часть",{"$f":"SUM(IF(K133=$H$49:$H$52,$G$49:$G$52,0))","v":3}]
[null,null,null,null,null,null,null,null,null,"Электродвигатель","Электрическая часть",{"$f":"SUM(IF(K134=$H$49:$H$52,$G$49:$G$52,0))","v":2}]
[null,null,null,null,null,null,null,null,null,"Электродвигатель (вращения)","Электрическая часть",{"$f":"SUM(IF(K135=$H$49:$H$52,$G$49:$G$52,0))","v":2}]
[null,null,null,null,null,null,null,null,null,"электродвигатель (подъём)","Электрическая часть",{"$f":"SUM(IF(K136=$H$49:$H$52,$G$49:$G$52,0))","v":2}]
[null,null,null,null,null,null,null,null,null,"Электродвигатель передвижения","Электрическая часть",{"$f":"SUM(IF(K137=$H$49:$H$52,$G$49:$G$52,0))","v":2}]
[null,null,null,null,null,null,null,null,null,"Энкодер","Средства автоматизации",{"$f":"SUM(IF(K138=$H$49:$H$52,$G$49:$G$52,0))","v":4}]
[null,null,null,null,null,null,null,null,null,"Токосъёмники","Электрическая часть",{"$f":"SUM(IF(K139=$H$49:$H$52,$G$49:$G$52,0))","v":2}]
[null,null,null,null,null,null,null,null,null,"Г\\панель","Гидравлическая часть",{"$f":"SUM(IF(K140=$H$49:$H$52,$G$49:$G$52,0))","v":3}]
[null,null,null,null,null,null,null,null,null,"Направляющие","Механическая часть",{"$f":"SUM(IF(K141=$H$49:$H$52,$G$49:$G$52,0))","v":1}]