{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Бланк уставок УАЧР"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":130,"n_cols":26,"rows_kept":130,"cut":false,"hidden":false,"merged":[[92,12,92,13],[92,14,92,17],[93,10,93,11],[92,10,92,11],[92,8,92,9],[93,8,93,9],[93,12,93,13],[3,14,3,15],[3,16,3,17],[0,14,0,17],[1,14,1,17],[2,14,2,17],[83,1,83,8],[82,9,82,10],[83,9,83,10],[78,1,78,8],[78,9,78,10],[79,9,79,10],[80,9,80,10],[81,9,81,10],[79,1,79,8],[81,1,81,8],[77,1,77,10],[90,9,90,10],[85,9,85,10],[86,9,86,10],[87,9,87,10],[88,9,88,10],[89,9,89,10],[90,1,90,8],[85,1,85,8],[86,1,86,8],[87,1,87,8],[88,1,88,8],[89,1,89,8],[82,1,82,8],[80,1,80,8],[84,1,84,10],[17,1,17,17],[49,1,49,17],[56,1,56,17],[63,1,63,17],[66,1,66,17],[24,1,24,17],[33,1,33,17],[4,14,4,15],[15,10,15,17],[15,1,16,1],[15,8,16,8],[15,9,16,9],[8,11,8,13],[9,11,9,13],[10,11,10,13],[5,14,5,17]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"УТВЕРЖДАЮ:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Начальник СРЗА"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ПАО \"Сети\"",null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"________________",null,"(Иванов И.И.)",null,null,null,null,null,null,"Список",null,2]
[null,{"$f":"IF(Z5=2,380,100)","v":100},null,null,null,null,null,null,null,null,null,null,null,null,"(подпись)",null,null,null,null,null,null,null,null,"☐",null,1]
[null,null,null,null,null,null,null,null,null,null,null,null," ",null,"\"_____\" _______________ 20___ г.",null,null,null,null,null,null,null,null,"☑"]
[]
[null,null,null,null,null,null,null,null,null,"Бланк уставок \"ПАРМА УАЧР 12\""]
[null,null,null,null,null,null,null,null,null,"Зав.№:",null,1]
[null,null,null,null,null,null,null,null,null,"Подстанция:"]
[null,null,null,null,null,null,null,null,null,"Присоединение:"]
[null,null,null,null,null,null,null,null,null,"Uн:"]
[]
[]
[]
[null,"Название",null,null,null,null,null,null,"Диапазон","Шаг","УСТАВКИ",null,null,null,null,null,null,null,null,null,null,null,null,"из Пр.1","в  Пр.1"]
[null,null,null,null,null,null,"мин","макс",null,null,"Пр.1","Пр.2","Пр.3","Пр.4","Пр.5","Пр.6","Пр.7","Пр.8",null,null,null,null,null,"из Пр.2","в  Пр.2"]
[null,"АЧР-1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"из Пр.3","в  Пр.3"]
[null,"Ввод АЧР-1",null,null,{"$f":"IF(COUNTIF($K19:$R19,$X$5)+COUNTIF($K19:$R19,$X$6)<>8,1,0)","v":0},null,"-","-","☐ или ☑","-","☐","☐","☐","☐","☐","☐","☐","☐",null,null,null,null,null,"из Пр.4","в  Пр.4"]
[null,"Блокир. по dF/dt",null,null,{"$f":"IF(COUNTIF($K20:$R20,$X$5)+COUNTIF($K20:$R20,$X$6)<>8,1,0)","v":0},null,"-","-","☐ или ☑","-","☐","☐","☐","☐","☐","☐","☐","☐",null,null,null,null,null,"из Пр.5","в  Пр.5"]
[null,"F<, Гц",null,null,{"$f":"IF(OR(COUNTBLANK($K21:$R21),$G21>MINA($K21:$R21)),1,0)","v":0},{"$f":"IF($H21<MAXA($K21:$R21),1,0)","v":0},45,51,{"$f":"CONCATENATE(TEXT(G21,\"#0,00\"),\" ... \",TEXT(H21,\"#0,00\"))","v":"45,00 ... 51,00"},0.01,48.8,48.8,48.8,48.8,48.8,48.8,48.8,48.8,null,null,null,null,null,"из Пр.6","в  Пр.6"]
[null,"Блокир. по dF/dt>, Гц/с",null,null,{"$f":"IF(OR(COUNTBLANK($K22:$R22),ABS(MINA($K22:$R22))>ABS($G22),ABS(MAXA($K22:$R22))>ABS($G22)),1,0)","v":0},{"$f":"IF(OR(ABS(MINA($K22:$R22))<ABS($H22),ABS(MAXA($K22:$R22))<ABS($H22)),1,0)","v":0},-20,-0.1,{"$f":"CONCATENATE(TEXT(G22,\"#0,0\"),\" ... \",TEXT(H22,\"#0,0\"))","v":"-20,0 ... -0,1"},0.1,3,3,3,3,3,3,3,3,null,null,null,null,null,"из Пр.7","в  Пр.7"]
[null,"Тачр-1, с",null,null,{"$f":"IF(OR(COUNTBLANK($K23:$R23),$G23>MINA($K23:$R23)),1,0)","v":0},{"$f":"IF($H23<MAXA($K23:$R23),1,0)","v":0},0.08,0.5,{"$f":"CONCATENATE(TEXT(G23,\"#0,00\"),\" ... \",TEXT(H23,\"#0,00\"))","v":"0,08 ... 0,50"},0.01,0.1,0.1,0.1,0.1,0.1,0.1,0.1,0.1,null,null,null,null,null,"из Пр.8","в  Пр.8"]
[]
[null,"АЧР-2"]
[null,"Ввод АЧР-2",null,null,{"$f":"IF(COUNTIF($K26:$R26,$X$5)+COUNTIF($K26:$R26,$X$6)<>8,1,0)","v":0},null,"-","-","☐ или ☑","-","☐","☐","☐","☐","☐","☐","☐","☐"]
[null,"Уск. по U",null,null,{"$f":"IF(COUNTIF($K27:$R27,$X$5)+COUNTIF($K27:$R27,$X$6)<>8,1,0)","v":0},null,"-","-","☐ или ☑","-","☐","☐","☐","☐","☐","☐","☐","☐"]
[null,"Fпуска<, Гц",null,null,{"$f":"IF(OR(COUNTBLANK($K28:$R28),$G28>MINA($K28:$R28),$K$28>=$K$29,$L$28>=$L$29,$M$28>=$M$29,$N$28>=$N$29,$O$28>=$O$29,$P$28>=$P$29,$Q$28>=$Q$29,$R$28>=$R$29),1,0)","v":0},{"$f":"IF(OR($H28<MAXA($K28:$R28),$K$28>=$K$29,$L$28>=$L$29,$M$28>=$M$29,$N$28>=$N$29,$O$28>=$O$29,$P$28>=$P$29,$Q$28>=$Q$29,$R$28>=$R$29),1,0)","v":0},45,51,{"$f":"CONCATENATE(TEXT(G28,\"#0,00\"),\" ... \",TEXT(H28,\"#0,00\"))","v":"45,00 ... 51,00"},0.01,49,49,49,49,49,49,49,49]
[null,"Fвозвр.>, Гц",null,null,{"$f":"IF(OR(COUNTBLANK($K29:$R29),$G29>MINA($K29:$R29),$K$28>=$K$29,$L$28>=$L$29,$M$28>=$M$29,$N$28>=$N$29,$O$28>=$O$29,$P$28>=$P$29,$Q$28>=$Q$29,$R$28>=$R$29),1,0)","v":0},{"$f":"IF(OR($H29<MAXA($K29:$R29),$K$28>=$K$29,$L$28>=$L$29,$M$28>=$M$29,$N$28>=$N$29,$O$28>=$O$29,$P$28>=$P$29,$Q$28>=$Q$29,$R$28>=$R$29),1,0)","v":0},45,51,{"$f":"CONCATENATE(TEXT(G29,\"#0,00\"),\" ... \",TEXT(H29,\"#0,00\"))","v":"45,00 ... 51,00"},0.01,49.1,49.1,49.1,49.1,49.1,49.1,49.1,49.1]
[null,"Uачр-н<, В",null,null,{"$f":"IF(OR(COUNTBLANK($K30:$R30),$G30>MINA($K30:$R30)),1,0)","v":0},{"$f":"IF($H30<MAXA($K30:$R30),1,0)","v":0},{"$f":"0.5*$B$5","v":50},{"$f":"1.1*$B$5","v":110.00000000000001},{"$f":"CONCATENATE(G30,\" ... \",H30)","v":"50 ... 110"},1,80,80,80,80,80,80,80,80]
[null,"Тачр-2, с",null,null,{"$f":"IF(OR(COUNTBLANK($K31:$R31),$G31>MINA($K31:$R31)),1,0)","v":0},{"$f":"IF($H31<MAXA($K31:$R31),1,0)","v":0},0.08,99.99,{"$f":"CONCATENATE(TEXT(G31,\"#0,00\"),\" ... \",TEXT(H31,\"#0,00\"))","v":"0,08 ... 99,99"},0.01,10,10,10,10,10,10,10,10]
[null,"Туск. по U, с",null,null,{"$f":"IF(OR(COUNTBLANK($K32:$R32),$G32>MINA($K32:$R32)),1,0)","v":0},{"$f":"IF($H32<MAXA($K32:$R32),1,0)","v":0},0.08,99.99,{"$f":"CONCATENATE(TEXT(G32,\"#0,00\"),\" ... \",TEXT(H32,\"#0,00\"))","v":"0,08 ... 99,99"},0.01,1,1,1,1,1,1,1,1]
[]
[null,"АЧР-C"]
[null,"Ввод АЧР-С",null,null,{"$f":"IF(COUNTIF($K35:$R35,$X$5)+COUNTIF($K35:$R35,$X$6)<>8,1,0)","v":0},null,"-","-","☐ или ☑","-","☐","☐","☐","☐","☐","☐","☐","☐"]
[null,"dF/dt>, Гц/с",null,null,{"$f":"IF(OR(COUNTBLANK($K36:$R36),ABS(MINA($K36:$R36))>ABS($G36),ABS(MAXA($K36:$R36))>ABS($G36)),1,0)","v":0},{"$f":"IF(OR(ABS(MINA($K36:$R36))<ABS($H36),ABS(MAXA($K36:$R36))<ABS($H36)),1,0)","v":0},-20,-0.1,{"$f":"CONCATENATE(TEXT(G36,\"#0,0\"),\" ... \",TEXT(H36,\"#0,0\"))","v":"-20,0 ... -0,1"},0.1,1.5,1.5,1.5,1.5,1.5,1.5,1.5,1.5]
[null,"F<, Гц",null,null,{"$f":"IF(OR(COUNTBLANK($K37:$R37),$G37>MINA($K37:$R37)),1,0)","v":0},{"$f":"IF($H37<MAXA($K37:$R37),1,0)","v":0},45,51,{"$f":"CONCATENATE(TEXT(G37,\"#0,00\"),\" ... \",TEXT(H37,\"#0,00\"))","v":"45,00 ... 51,00"},0.01,48.8,48.8,48.8,48.8,48.8,48.8,48.8,48.8]
[null,"Тачр-c, с",null,null,{"$f":"IF(OR(COUNTBLANK($K38:$R38),$G38>MINA($K38:$R38)),1,0)","v":0},{"$f":"IF($H38<MAXA($K38:$R38),1,0)","v":0},0.08,1,{"$f":"CONCATENATE(TEXT(G38,\"#0,00\"),\" ... \",TEXT(H38,\"#0,00\"))","v":"0,08 ... 1,00"},0.01,0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"АОCН"]
[null,"Ввод АОСН",null,null,{"$f":"IF(COUNTIF($K51:$R51,$X$5)+COUNTIF($K51:$R51,$X$6)<>8,1,0)","v":0},null,"-","-","☐ или ☑","-","☐","☐","☐","☐","☐","☐","☐","☐"]
[null,"Контроль dU/dt",null,null,{"$f":"IF(COUNTIF($K52:$R52,$X$5)+COUNTIF($K52:$R52,$X$6)<>8,1,0)","v":0},null,"-","-","☐ или ☑","-","☐","☐","☐","☐","☐","☐","☐","☐"]
[null,"U<, В",null,null,{"$f":"IF(OR(COUNTBLANK($K53:$R53),$G53>MINA($K53:$R53)),1,0)","v":0},{"$f":"IF($H53<MAXA($K53:$R53),1,0)","v":0},{"$f":"0.5*$B$5","v":50},{"$f":"$B$5","v":100},{"$f":"CONCATENATE(G53,\" ... \",H53)","v":"50 ... 100"},1,80,80,80,80,80,80,80,80]
[null,"dU/dt>, В/с",null,null,{"$f":"IF(OR(COUNTBLANK($K54:$R54),ABS(MINA($K54:$R54))>ABS($G54),ABS(MAXA($K54:$R54))>ABS($G54)),1,0)","v":0},{"$f":"IF(OR(ABS(MINA($K54:$R54))<ABS($H54),ABS(MAXA($K54:$R54))<ABS($H54)),1,0)","v":0},-30,-2,{"$f":"CONCATENATE(G54,\" ... \",H54)","v":"-30 ... -2"},1,5,5,5,5,5,5,5,5]
[null,"Таосн, с",null,null,{"$f":"IF(OR(COUNTBLANK($K55:$R55),$G55>MINA($K55:$R55)),1,0)","v":0},{"$f":"IF($H55<MAXA($K55:$R55),1,0)","v":0},0.08,99.99,{"$f":"CONCATENATE(TEXT(G55,\"#0,00\"),\" ... \",TEXT(H55,\"#0,00\"))","v":"0,08 ... 99,99"},0.01,5,5,5,5,5,5,5,5]
[]
[null,"ЧАПВ"]
[null,"Ввод ЧАПВ",null,null,{"$f":"IF(COUNTIF($K58:$R58,$X$5)+COUNTIF($K58:$R58,$X$6)<>8,1,0)","v":0},null,"-","-","☐ или ☑","-","☐","☐","☐","☐","☐","☐","☐","☐"]
[null,"Контроль U",null,null,{"$f":"IF(COUNTIF($K59:$R59,$X$5)+COUNTIF($K59:$R59,$X$6)<>8,1,0)","v":0},null,"-","-","☐ или ☑","-","☐","☐","☐","☐","☐","☐","☐","☐"]
[null,"F>, Гц",null,null,{"$f":"IF(OR(COUNTBLANK($K60:$R60),$G60>MINA($K60:$R60)),1,0)","v":0},{"$f":"IF($H60<MAXA($K60:$R60),1,0)","v":0},49,51,{"$f":"CONCATENATE(TEXT(G60,\"#0,00\"),\" ... \",TEXT(H60,\"#0,00\"))","v":"49,00 ... 51,00"},0.01,49.5,49.5,49.5,49.5,49.5,49.5,49.5,49.5]
[null,"Uчапв>, В",null,null,{"$f":"IF(OR(COUNTBLANK($K61:$R61),$G61>MINA($K61:$R61)),1,0)","v":0},{"$f":"IF($H61<MAXA($K61:$R61),1,0)","v":0},{"$f":"0.7*$B$5","v":70},{"$f":"$B$5","v":100},{"$f":"CONCATENATE(G61,\" ... \",H61)","v":"70 ... 100"},1,90,90,90,90,90,90,90,90]
[null,"Тчапв, с",null,null,{"$f":"IF(OR(COUNTBLANK($K62:$R62),$G62>MINA($K62:$R62)),1,0)","v":0},{"$f":"IF($H62<MAXA($K62:$R62),1,0)","v":0},0.08,300,{"$f":"CONCATENATE(TEXT(G62,\"#0,00\"),\" ... \",TEXT(H62,\"#0,00\"))","v":"0,08 ... 300,00"},0.01,10,10,10,10,10,10,10,10]
[]
[null,"Д. Вход \"РАЗРЕШЕНИЕ\""]
[null,"Разреш.☐/Блокир.☑",null,null,{"$f":"IF(COUNTIF($K65:$R65,$X$5)+COUNTIF($K65:$R65,$X$6)<>8,1,0)","v":0},null,"-","-","☐ или ☑","-","☐","☐","☐","☐","☐","☐","☐","☐"]
[]
[null,"Д. Вход \"ЗАПРЕТ ЧАПВ\""]
[null,"Запрет☐/Разреш.☑",null,null,{"$f":"IF(COUNTIF($K68:$R68,$X$5)+COUNTIF($K68:$R68,$X$6)<>8,1,0)","v":0},null,"-","-","☐ или ☑","-","☐","☐","☐","☐","☐","☐","☐","☐"]
[null,null,null,null,{"$f":"SUM(E19:E68)","v":0},{"$f":"SUM(F19:F68)","v":0}]
[null,null,null,null,null,{"$f":"SUM(E69:F69)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[null,"Настройки RS-485"]
[null,"Название",null,null,null,null,null,null,null,"Значение"]
[null,"Протокол",null,null,null,null,null,null,null,"МЭК 60870-5-101",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(NOT(OR(J80=W88,J80=W89,J80=W90)),1,0)","v":0}]
[null,"Адрес",null,null,null,null,null,null,null,1,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(J81<1,J81>247),1,0)","v":0}]
[null,"Скорость",null,null,null,null,null,null,null,38400,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(NOT(OR(J82=X88,J82=X89,J82=X90,J82=X91)),1,0)","v":0}]
[null,"Чётность",null,null,null,null,null,null,null,"8E1",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(NOT(OR(J83=$Y$88,J83=$Y$89,J83=$Y$90)),1,0)","v":0}]
[null,"Чётность",null,null,null,null,null,null,null,"7O1",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(NOT(OR(J84=$Y$92,J84=$Y$93,J84=$Y$94)),1,0)","v":0}]
[null,"Настройки МЭК",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(U80:U84)","v":0}]
[null,"Длина адреса канального уровня",null,null,null,null,null,null,null,1,null,null,null,null,null,null,null,null,null,null,null,null,"протокол","скорость","формат"]
[null,"Длина причины передачи ASDU",null,null,null,null,null,null,null,1]
[null,"Длина общего адреса ASDU",null,null,null,null,null,null,null,1,null,null,null,null,null,null,null,null,null,null,null,null,"MODBUS RTU",9600,"8E1"]
[null,"Общий адрес ASDU",null,null,null,null,null,null,null,1,null,null,null,null,null,null,null,null,null,null,null,null,"MODBUS ASCII",19200,"8O1"]
[null,"Длина адреса объекта информации",null,null,null,null,null,null,null,1,null,null,null,null,null,null,null,null,null,null,null,null,"МЭК 60870-5-101",38400,"8N2"]
[null,"Базовый адрес объекта информации",null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,57600]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"7E1"]
[null,"Разработал:",null,null,null,null,null,null,"__________________________",null,"________________",null,"________________",null,"\"_____\" _______________ 20___ г.",null,null,null,null,null,null,null,null,null,"7O1"]
[null,null,null,null,null,null,null,null,"(должность)",null,"(подпись)",null,"(ФИО)",null,null,null,null,null,null,null,null,null,null,null,"7N2"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"ERROR"]