{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["ОПН-П-110 550-680 А"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":3,"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":"ОПН-П-110 550-680 А","index":0,"n_rows":33,"n_cols":17,"rows_kept":33,"cut":false,"hidden":false,"merged":[[20,11,20,12],[20,5,20,8],[20,1,20,4],[32,11,32,12],[2,0,2,12],[7,11,7,12],[6,11,6,12],[7,5,7,8],[6,5,6,8],[7,1,7,4],[6,1,6,4],[30,11,30,12],[30,5,30,8],[30,1,30,4],[11,11,11,12],[10,11,10,12],[8,11,8,12],[5,11,5,12],[16,11,16,12],[15,11,15,12],[14,11,14,12],[13,11,13,12],[12,11,12,12],[9,5,9,8],[8,5,8,8],[5,5,5,8],[29,11,29,12],[28,11,28,12],[27,11,27,12],[26,11,26,12],[25,11,25,12],[24,11,24,12],[23,11,23,12],[22,11,22,12],[21,11,21,12],[19,11,19,12],[18,11,18,12],[17,11,17,12],[9,11,9,12],[14,5,14,8],[13,5,13,8],[12,5,12,8],[11,5,11,8],[10,5,10,8],[8,1,8,4],[5,1,5,4],[29,5,29,8],[28,5,28,8],[27,5,27,8],[26,5,26,8],[25,5,25,8],[24,5,24,8],[23,5,23,8],[22,5,22,8],[21,5,21,8],[19,5,19,8],[18,5,18,8],[17,5,17,8],[16,5,16,8],[15,5,15,8],[13,1,13,4],[12,1,12,4],[11,1,11,4],[10,1,10,4],[9,1,9,4],[18,1,18,4],[17,1,17,4],[16,1,16,4],[15,1,15,4],[14,1,14,4],[24,1,24,4],[23,1,23,4],[22,1,22,4],[21,1,21,4],[19,1,19,4],[29,1,29,4],[28,1,28,4],[27,1,27,4],[26,1,26,4],[25,1,25,4],[3,5,4,8],[3,1,4,4],[0,0,1,0],[3,0,4,0],[4,11,4,12],[3,11,3,12]]}
["ОПН-П","Класс напряжения сети, кВ","Наибольшее длительно допустимое рабочее напряжение, кВдейств.","Номинальный разрядный ток, кА","Ток пропускной способности ограничителя, А","Степень загрязнения по ГОСТ Р 52725","Климатическое исполнение по ГОСТ 15150","Наличие изолирующего пакета (да/нет)","Наличие монтажного основания (да/нет)","Количество фаз, шт.","Коэффициент перерасчета","Остающееся напряжение варистора, кВ","Курс доллара, руб.",null,"Ток пропускной способности ограничителя, А","Степень загрязнения по ГОСТ Р 52725","Ответ (Да/Нет)"]
[null,110,56,10,500,"IV","УХЛ1","Нет","Нет",1,3.3,"8,0",35.200000000000003,null,500,"I","Да"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,550,"II","Нет"]
["№ п/п","Наименование",null,null,null,"Пояснение",null,null,null,"Кол-во в комплекте","Цена за шт.","Стоимость комлпекта",null,null,680,"III"]
[null,null,null,null,null,null,null,null,null,"шт.","руб.","руб.",null,null,850,"IV"]
[1,"Покрышка 40 рёбер",null,null,null,"СЕБД.757523.503",null,null,null,{"$f":"IF(AND(61<=C2,C2<=100),1,0)*J2","v":0},5350,{"$f":"J6*K6","v":0},null,null,1000]
[2,"Покрышка 32 ребра",null,null,null,"СЕБД.757523.503",null,null,null,{"$f":"IF(AND(52<=C2,C2<=60),1,0)*J2","v":1},4230,{"$f":"J7*K7","v":4230},null,null,1200]
[3,"Покрышка 12 рёбер",null,null,null,"СЕБД.757523.503",null,null,null,{"$f":"IF(F2=\"IV\",\"1\",\"0\")*J2","v":1},2100,{"$f":"J8*K8","v":2100},null,null,1500]
[4,"Варисторы",null,null,null,"Китай ⌀46х21 мм",null,null,null,{"$f":"ROUNDUP(C2*K2/L2,0)*J2","v":24},{"$f":"3.2*M2","v":112.64000000000001},{"$f":"J9*K9","v":2703.3600000000006}]
[5,"Бобышка ",null,null,null,"СЕБД.711461.505",null,null,null,{"$f":"1*J2+1*J8","v":2},33,{"$f":"J10*K10","v":66}]
[6,"Бобышка ",null,null,null,"СЕБД.758491.503",null,null,null,{"$f":"1*J2+1*J8","v":2},33,66]
[7,"Шайба",null,null,null,"СЕБД.754151.505",null,null,null,{"$f":"3*J2+3*J8","v":6},5,30]
[8,"Добавка",null,null,null,"Труба ⌀45х2,5 мм",null,null,null,{"$f":"((0.92-0.18*J7/J2)-(0.021*J9/J2)+(0.3*J8/J2))*J2","v":0.53600000000000003},285.79000000000002,{"$f":"J13*K13","v":153.18344000000002}]
[9,"Тератен",null,null,null,"ТУТ D 50/20",null,null,null,{"$f":"(1-0.15*J7/J2+0.35*J8/J2)*J2","v":1.2},120,144]
[10,"Пружина",null,null,null,"СЕБД.753571.503",null,null,null,{"$f":"1*J2+1*J8","v":2},35,70]
[11,"Шайба",null,null,null,"СЕБД.711461.506",null,null,null,{"$f":"2*J2+2*J8","v":4},21,84]
[12,"Провод с наконечниками",null,null,null,"СЕБД.301634.503",null,null,null,{"$f":"1*J2+1*J8","v":2},50,100]
[13,"Фланец верхний",null,null,null,"СЕБД.753112.503",null,null,null,{"$f":"1*J2","v":1},200,200]
[14,"Фланец нижний (маленький)",null,null,null,"СЕБД.711361.503",null,null,null,{"$f":"IF(H2=\"Да\",\"0\",\"1\")*J2","v":1},276,276]
[15,"Фланец нижний (большой)",null,null,null,"СЕБД.753112.503",null,null,null,{"$f":"IF(H2=\"Да\",\"1\",\"0\")*J2","v":0},417,0]
[16,"Фланец средний (муфта)",null,null,null,"СЕБД.711361.009",null,null,null,{"$f":"IF(F2=\"IV\",\"1\",\"0\")*J2","v":1},350,{"$f":"J21*K21","v":350}]
[17,"СКТН",null,null,null,"кг",null,null,null,{"$f":"(0.5-0.1*J7/J2+0.2*J8/J2)*J2","v":0.60000000000000009},285,171.00000000000003]
[18,"Втулка (фарфоровая)",null,null,null,"СЕБД.757513.501",null,null,null,{"$f":"IF(H2=\"Да\",\"8\",\"0\")*J2","v":0},15,0]
[19,"Трубка изоляционная",null,null,null,"СЕБД.723146.501",null,null,null,{"$f":"IF(H2=\"Да\",\"4\",\"0\")*J2","v":0},20,0]
[20,"Шайба стальная",null,null,null,"СЕБД.758491.504",null,null,null,{"$f":"IF(H2=\"Да\",\"8\",\"0\")*J2","v":0},10,0]
[21,"Шайба паронитовая",null,null,null,"СЕБД.758491.505",null,null,null,{"$f":"IF(H2=\"Да\",\"16\",\"0\")*J2","v":0},5,0]
[22,"Основание",null,null,null,"СЕБД.741422.501",null,null,null,{"$f":"IF(I2=\"Да\",\"1\",\"0\")*J2","v":0},1200,0]
[23,"Экран",null,null,null,"СЕБД.686475.501",null,null,null,{"$f":"IF(C2>=88,\"1\",\"0\")*J2","v":0},2000,0]
[24,"Шильд",null,null,null,"Теса",null,null,null,{"$f":"1*J2","v":1},50,50]
[25,"Упаковка",null,null,null,null,null,null,null,{"$f":"1*J2","v":1},260,260]
[26,"Крепеж",null,null,null,null,null,null,null,{"$f":"1*J2","v":1},200,200]
[]
[null,null,null,null,null,null,null,null,null,null,"Итого:",{"$f":"SUM(L6:M31)","v":11253.543440000001}]