{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["ЖД"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":0,"defined_names":9,"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":70,"n_cols":35,"rows_kept":70,"cut":false,"hidden":false,"merged":[[21,19,21,34],[1,0,2,0],[1,1,2,1],[1,2,2,2],[1,3,1,18],[1,19,1,34],[21,1,22,1],[21,2,22,2],[53,3,53,18],[53,2,54,2],[47,13,47,18],[48,13,48,18],[21,0,22,0],[46,13,46,18],[21,3,21,18],[43,0,43,2],[44,0,44,2],[39,13,39,18],[40,13,40,18],[41,0,41,2],[61,0,61,2],[63,0,63,2],[64,0,64,2],[42,0,42,2],[45,0,45,2],[53,0,54,0],[53,1,54,1],[68,13,68,18],[69,13,69,18],[66,13,66,18],[67,13,67,18],[65,13,65,18]]}
["Рейтинговая оценка железных дорог за I квартал 2018 г. (№ 2769р от 28 декабря 2017 г.)",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,"ОКТ","КЛГ","МСК","ГОР","СЕВ","СКВ","ЮВС","ПРВ","КБШ","СВР","ЮУР","ЗСБ","КРС","ВСБ","ЗАБ","ДВС","ОКТ","КЛГ","МСК","ГОР","СЕВ","СКВ","ЮВС","ПРВ","КБШ","СВР","ЮУР","ЗСБ","КРС","ВСБ","ЗАБ","ДВС"]
["Выручка, начисленная по грузовым перевозкам","млн. руб.","План",31444.241000000002,992.62,20849.516,12406.931,14939.897000000001,19107.519,13603.083000000001,11350.178,25255.339,39985.167999999998,20061.48,66249.297999999995,19245.601999999999,17003.635999999999,3284.797,29166.475999999999,31302.484,963.49800000000005,20760.060000000001,12378.968000000001,14607.620999999999,18934.823,13466.267,10978.745000000001,25064.123,39421.286999999997,19801.906999999999,64997.245000000003,18679.695,16436.706999999999,3108.8580000000002,28947.873]
["Себестоимость перевозок","коп./10 прив.тонно-км","План",590.65700000000004,1624.617,670.13300000000004,282.92700000000002,395.834,730.26800000000003,441.67599999999999,477.90899999999999,352.226,375.61599999999999,283.178,240.251,327.77600000000001,326.17899999999997,256.858,487.84399999999999,601.75099999999998,1852.08,677.07100000000003,287.76299999999998,399.02699999999999,746.928,448.72199999999998,487.86900000000003,361.75200000000001,380.10899999999998,291.05099999999999,242.95400000000001,339.97800000000001,335.60199999999998,259.68599999999998,484.46499999999997]
["Финансовый результат по прочим видам деятельности","млн. руб.","План",205.76400000000001,34.281999999999996,1286.5129999999999,280.96300000000002,446.68900000000002,309.04399999999998,166.45699999999999,127.345,364.23200000000003,852.41899999999998,336.04399999999998,-188.148,196.303,357.15600000000001,249.226,535.548,59.536000000000001,-22.524000000000001,1234.9100000000001,246.846,416.43,207.994,111.759,110.393,346.42099999999999,745.06,269.67599999999999,-311.34699999999998,153.102,274.37200000000001,183.66300000000001,485.315]
["Дебиторская задолженность","млн. руб.","План",7222.884,989.49199999999996,5579.0249999999996,1541.048,6955.3119999999999,4926.8990000000003,5188.7669999999998,1345.9690000000001,2552.38,4325.7740000000003,2966.2089999999998,3192.4969999999998,661.96600000000001,1464.617,4494.826,3599.355,7367.4650000000001,983.33799999999997,6115.8980000000001,1536.962,7050.5569999999998,5005.857,5134.18,1328.1210000000001,2573.0039999999999,4325.2830000000004,3032.9229999999998,3268.0430000000001,698.30100000000004,1530.473,4438.076,3601.5279999999998]
["Кредиторская задолженность","млн. руб.","План",7435.18,268.38900000000001,9871.9279999999999,3518.7620000000002,3995.3150000000001,4186.0320000000002,2482.2399999999998,3421.6990000000001,3219.3679999999999,5354.3029999999999,3390.97,5867.5720000000001,2660.3870000000002,4194.0050000000001,3964.1660000000002,8144.2150000000001,7534.9179999999997,245.339,9455.5040000000008,3481.7840000000001,3952.0050000000001,4222.7309999999998,2376.0419999999999,3495.55,3215.4259999999999,5487.3630000000003,3501.0390000000002,5979.7709999999997,2578.87,4219.5680000000002,4084.53,7975.2150000000001]
["Погрузка грузов","тыс. тонн","План",23984.9,657.6,16552.54,7948.39,15352.14,16802.939999999999,22332.75,9648.7999999999993,17593.009999999998,33877,19647.349999999999,77203.14,22465.43,15322.18,4214.96,12040.07,23397.599999999999,614.20000000000005,17175,7824,14779,16588,22298.5,9345,17808,33790,19506,77871,22035,15061,4177.7,11955]
["Отправление пассажиров","тыс. чел.","План",32639.855,610.09100000000001,167312.69,8248.11,2653.683,6733.4650000000001,2888.0349999999999,1831.239,3967.8359999999998,6248.1970000000001,1919.779,8500.0789999999997,1453.394,2723.875,596.32600000000002,2071.4340000000002,31113.4,583.1,166294.5,8277.4,2598.3000000000002,6384.1,2863.4,1766.4,3841.5,6197.8,1886.7,8358.5,1375.3,2642.6,587.70000000000005,1917.4]
["Выполнение расписания движения пассажирских поездов по прибытию на станции посадки (высадки) пассажиров с учетом опозданий при поступлении на дорогу и влияния дороги на опоздания по сети","%","План",0.98499999999999999,1,0.98099999999999998,0.99099999999999999,0.99099999999999999,0.99099999999999999,0.98699999999999999,0.98699999999999999,0.99099999999999999,0.99199999999999999,0.99399999999999999,0.995,0.98499999999999999,0.99099999999999999,0.97199999999999998,0.99199999999999999,0.98499999999999999,0.98499999999999999,0.98499999999999999,0.98499999999999999,0.98499999999999999,0.98499999999999999,0.98499999999999999,0.98499999999999999,0.98499999999999999,0.98499999999999999,0.98499999999999999,0.98499999999999999,0.98499999999999999,0.98499999999999999,0.98499999999999999,0.98499999999999999]
["Выполнение расписания движения пригородных поездов по прибытию в пункты назначения с учетом отклонений при поступлении на дорогу и влияния дороги на отклонения по сети","%","План",0.99099999999999999,0.996,0.97199999999999998,0.99399999999999999,0.99199999999999999,0.996,0.99099999999999999,0.99099999999999999,0.99,0.99199999999999999,0.995,0.997,0.99,0.98,0.96199999999999997,0.98799999999999999,0.98599999999999999,0.98599999999999999,0.98599999999999999,0.98599999999999999,0.98599999999999999,0.98599999999999999,0.98599999999999999,0.98599999999999999,0.98599999999999999,0.98599999999999999,0.98599999999999999,0.98599999999999999,0.98599999999999999,0.98599999999999999,0.98599999999999999,0.98599999999999999]
["Доля грузовых отправок в груженых вагонах, проследовавших по инфраструктуре дороги в установленный срок","%","Факт пр. г.",0.89200000000000002,0.80600000000000005,0.86899999999999999,0.94299999999999995,0.90400000000000003,0.90300000000000002,0.76800000000000002,0.86299999999999999,0.92300000000000004,0.88600000000000001,0.97,0.96,0.90500000000000003,0.91100000000000003,0.93500000000000005,0.86699999999999999,0.91100000000000003,0.63900000000000001,0.88300000000000001,0.94299999999999995,0.92200000000000004,0.83599999999999997,0.85499999999999998,0.88900000000000001,0.85899999999999999,0.88,0.96199999999999997,0.95099999999999996,0.92500000000000004,0.94,0.93200000000000005,0.872]
["Средняя участковая скорость движения грузового поезда","км/ч","План",37.5,56,42.1,43.7,39.5,36.4,46.1,42.1,45.7,37.9,53.3,53.3,48.1,47.7,43.3,38.799999999999997,38.5,54.9,44.8,44.2,39.5,35.4,46.3,41.7,44.7,38,53,53,48.7,48.3,43.5,39.299999999999997]
["Среднесуточная производительность локомотива рабочего парка грузового движения","тыс.тонн-км брутто","План",1802.17,1844.02,1885.68,2713.32,2047.87,1503.24,1830.74,2087.8000000000002,1706.32,1931.72,2690.97,2924.87,2315.38,2387.0100000000002,2808.32,2037.37,1800,1843,1960,2739,2014,1467,1915,2045,1607,1936,2652,2895,2332,2480,2795,2016]
["Балловая оценка состояния пути","балл","План",25,15,28,26,20,33,23,30,28,33,25,20,39,25,58,39,27,16,30,29,23,34,26,30,30,36,30,23,35,27,60,38]
["Уровень безопасности движения","ед./млн.поездо-км.","Факт пр. г.",0.6900650932945448,0,1.1626558036938799,0.81573423405899603,0.88976837281982901,0.58457363804365303,2.0001744284526883,0.95681264291350965,0.61599681748674662,1.0205945216789984,0.91022655713099465,0.64691720576447509,1.1443806566073031,0.62964540691111059,0.70298462514552162,1.104828270849135,1.0839919547184671,2.0455843247625896,1.3847936295181689,1.2222851873571106,1.5832968471480895,0.83337690959336141,2.1499418969083566,1.6983220687332798,1.381696887923956,1.4628210794703889,1.8345893633969477,0.94579794190919808,1.5071157470385472,0.34640350727537428,0.98872568460911281,1.2988821808948876]
["Интенсивность отказов 1 и 2 категории","ед./млн.поездо-км.","Факт пр. г.",30.390466708691754,10.637073854444726,24.344588869182054,26.647318312593871,27.752299247475616,22.160655187654847,30.209531022837158,34.604723918705268,23.455263435072272,24.834466694188965,26.684010122208633,16.765937582729315,25.494257961084919,21.741285520989525,16.168646378346999,51.088783145127252,34.980713349563501,22.501427572388486,23.640405532488742,23.393180391362478,30.434483839624388,25.112424209079958,27.430293167451445,38.297162649935458,35.46355345671487,29.10080232563433,30.493850229435751,17.35817399268646,30.994162971705776,23.863352723414671,17.271801803015439,57.265423210630487]
["Укомплектованность штата","%","План",0.99199999999999999,1.018,0.98599999999999999,1,1.0049999999999999,1.002,1.0009999999999999,1.0089999999999999,1.0049999999999999,1,1.002,1.0189999999999999,1.012,0.99399999999999999,0.999,0.99399999999999999,0.97,0.97,0.97,0.97,0.97,0.97,0.97,0.97,0.97,0.97,0.97,0.97,0.97,0.97,0.97,0.97]
[]
[]
["Показатель","Вес",null,"Коэффициент выполнения целевой метрики",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Балл"]
[null,null,null,"ОКТ","КЛГ","МСК","ГОР","СЕВ","СКВ","ЮВС","ПРВ","КБШ","СВР","ЮУР","ЗСБ","КРС","ВСБ","ЗАБ","ДВС","ОКТ","КЛГ","МСК","ГОР","СЕВ","СКВ","ЮВС","ПРВ","КБШ","СВР","ЮУР","ЗСБ","КРС","ВСБ","ЗАБ","ДВС"]
["Выручка, начисленная по грузовым перевозкам",0.1,null,1.0049999999999999,1.03,1.004,1.002,1.0229999999999999,1.0089999999999999,1.01,1.034,1.008,1.014,1.0129999999999999,1.0189999999999999,1.03,1.034,1.0569999999999999,1.008,3,12.5,2,1,11,6,7,14.5,4.5,9,8,10,12.5,14.5,16,4.5]
["Себестоимость перевозок",0.1,null,0.98199999999999998,0.877,0.99,0.98299999999999998,0.99199999999999999,0.97799999999999998,0.98399999999999999,0.98,0.97399999999999998,0.98799999999999999,0.97299999999999998,0.98899999999999999,0.96399999999999997,0.97199999999999998,0.98899999999999999,1.0069999999999999,9,2,15,10,16,7,11,8,6,12,5,13.5,3,4,13.5,-1]
["Финансовый результат по прочим видам деятельности",0.05,null,2.456,2.5219999999999998,4.2000000000000003E-2,0.13800000000000001,7.2999999999999995E-2,0.48599999999999999,0.48899999999999999,0.154,5.0999999999999997E-2,0.14399999999999999,0.246,0.39600000000000002,0.28199999999999997,0.30199999999999999,0.35699999999999998,0.104,15,16,1,5,3,13,14,7,2,6,8,12,9,10,11,4]
["Дебиторская задолженность",2.5000000000000001E-2,null,0.98,1.006,0.91200000000000003,1.0029999999999999,0.98599999999999999,0.98399999999999999,1.0109999999999999,1.0129999999999999,0.99199999999999999,1,0.97799999999999998,0.97699999999999998,0.94799999999999995,0.95699999999999996,1.0129999999999999,0.999,11,-2,16,-1,9,10,-3,-4.5,8,6,12,13,15,14,-4.5,7]
["Кредиторская задолженность",2.5000000000000001E-2,null,0.98699999999999999,1.0940000000000001,1.044,1.0109999999999999,1.0109999999999999,0.99099999999999999,1.0449999999999999,0.97899999999999998,1.0009999999999999,0.97599999999999998,0.96899999999999997,0.98099999999999998,1.032,0.99399999999999999,0.97099999999999997,1.0209999999999999,11,-1,3,12.5,12.5,14,2,8,16,7,5,10,4,15,6,9]
["Погрузка грузов",0.1,null,1.0249999999999999,1.071,0.96399999999999997,1.016,1.0389999999999999,1.0129999999999999,1.002,1.0329999999999999,0.98799999999999999,1.0029999999999999,1.0069999999999999,0.99099999999999999,1.02,1.0169999999999999,1.0089999999999999,1.0069999999999999,13,16,-3,10,15,9,4,14,-2,5,6.5,-1,12,11,8,6.5]
["Отправление пассажиров",0.05,null,1.0489999999999999,1.046,1.006,0.996,1.0209999999999999,1.0549999999999999,1.0089999999999999,1.0369999999999999,1.0329999999999999,1.008,1.018,1.0169999999999999,1.0569999999999999,1.0309999999999999,1.0149999999999999,1.08,13,12,2,-1,8,14,4,11,10,3,7,6,15,9,5,16]
["Выполнение расписания движения пассажирских поездов по прибытию на станции посадки (высадки) пассажиров с учетом опозданий при поступлении на дорогу и влияния дороги на опоздания по сети",0.05,null,1,1.0149999999999999,0.996,1.006,1.006,1.006,1.002,1.002,1.006,1.0069999999999999,1.0089999999999999,1.01,1,1.006,0.98699999999999999,1.0069999999999999,3.5,16,-1,9,9,9,5.5,5.5,9,12.5,14,15,3.5,9,-2,12.5]
["Выполнение расписания движения пригородных поездов по прибытию в пункты назначения с учетом отклонений при поступлении на дорогу и влияния дороги на отклонения по сети",0.05,null,1.0049999999999999,1.01,0.98599999999999999,1.008,1.006,1.01,1.0049999999999999,1.0049999999999999,1.004,1.006,1.0089999999999999,1.0109999999999999,1.004,0.99399999999999999,0.97599999999999998,1.002,8,14.5,-2,12,10.5,14.5,8,8,5.5,10.5,13,16,5.5,-1,-3,4]
["Доля грузовых отправок в груженых вагонах, проследовавших по инфраструктуре дороги в установленный срок",0.05,null,0.97899999999999998,1.2609999999999999,0.98399999999999999,1,0.98,1.08,0.89800000000000002,0.97099999999999997,1.075,1.0069999999999999,1.008,1.0089999999999999,0.97799999999999998,0.96899999999999997,1.0029999999999999,0.99399999999999999,-4,16,-2,9,-3,15,-8,-6,14,11,12,13,-5,-7,10,-1]
["Средняя участковая скорость движения грузового поезда",0.05,null,0.97399999999999998,1.02,0.94,0.98899999999999999,1,1.028,0.996,1.01,1.022,0.997,1.006,1.006,0.98799999999999999,0.98799999999999999,0.995,0.98699999999999999,-8,14,-9,-4,10,16,-2,13,15,-1,11.5,11.5,-5.5,-5.5,-3,-7]
["Среднесуточная производительность локомотива рабочего парка грузового движения",0.05,null,1.0009999999999999,1.0009999999999999,0.96199999999999997,0.99099999999999999,1.0169999999999999,1.0249999999999999,0.95599999999999996,1.0209999999999999,1.0620000000000001,0.998,1.0149999999999999,1.01,0.99299999999999999,0.96299999999999997,1.0049999999999999,1.0109999999999999,7.5,7.5,-5,-3,13,15,-6,14,16,-1,12,10,-2,-4,9,11]
["Балловая оценка состояния пути",0.1,null,0.92600000000000005,0.93799999999999994,0.93300000000000005,0.89700000000000002,0.87,0.97099999999999997,0.88500000000000001,1,0.93300000000000005,0.91700000000000004,0.83299999999999996,0.87,1.1140000000000001,0.92600000000000005,0.96699999999999997,1.026,9.5,6,7.5,12,14.5,4,13,3,7.5,11,16,14.5,-2,9.5,5,-1]
["Уровень безопасности движения",0.1,null,0.63659613919714708,0,0.83958777604892609,0.66738453717402857,0.56197192233567739,0.70145168568312066,0.93033882977440663,0.56338703978990468,0.44582630450322697,0.69768923623147572,0.4961472988405472,0.68399092142091256,0.75931835949295112,1.8176646416301221,0.71100067095297792,0.85059929768837406,11,16,4,10,13,7,2,12,15,8,14,9,5,-1,6,3]
["Интенсивность отказов 1 и 2 категории",0.05,null,0.86877778634754388,0.4727288444355186,1.0297872782142234,1.1391062637397062,0.91187021254302714,0.88245782259612227,1.1013200201113247,0.90358453536148808,0.66139067151577613,0.85339457023536314,0.87506201812621631,0.96588141067103761,0.82255029711105088,0.91107422217570544,0.93612968483254344,0.89214014811722142,12,16,-1,-3,6,10,-2,8,15,13,11,4,14,7,5,9]
["Укомплектованность штата",0.05,null,0.99199999999999999,1.018,0.98599999999999999,1,1.0049999999999999,1.002,1.0009999999999999,1.0089999999999999,1.0049999999999999,1,1.002,1.0189999999999999,1.012,0.99399999999999999,0.999,0.99399999999999999,11,2,10,15.5,5.5,7.5,9,4,5.5,15.5,7.5,1,3,12.5,14,12.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Балловая оценка",null,null,null,null,null,{"$f":"ROUND(SUMPRODUCT(T24:T39,$B$24:$B$39),3)","v":8},{"$f":"ROUND(SUMPRODUCT(U24:U39,$B$24:$B$39),3)","v":10.875},2.6749999999999998,6.5629999999999997,10.587999999999999,9.6,4.8,8.4629999999999992,8.3000000000000007,8.3000000000000007,10.175000000000001,9.6,5.4,6.0250000000000004,7.1879999999999997,4.6500000000000004]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Место",null,null,null,null,null,{"$f":"IFERROR((RANK(T40,$T40:$AI40,0)+(COUNTIF($T40:$AI40,T40)-1)/2),0)","v":9},{"$f":"IFERROR((RANK(U40,$T40:$AI40,0)+(COUNTIF($T40:$AI40,U40)-1)/2),0)","v":1},16,11,2,4.5,14,6,7.5,7.5,3,4.5,13,12,10,15]
["Крушения",null,null,1,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,2,0,0,0,0,0,2,0,0,0,0,0,0,0,0,0]
["Аварии",null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Сходы (в поездной работе)",null,null,0,0,0,1,0,0,0,0,0,2,0,0,2,0,2,1,0,0,0,1,0,0,0,0,0,2,0,0,2,0,2,1]
["Столкновения (в поездной работе)",null,null,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0]
["Случаи производственного травматизма со смертельным исходом",null,null,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,2,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Итоговый штрафной балл",null,null,null,null,null,{"$f":"SUM(T42:T46)","v":2},0,0,1,0,0,2,0,0,3,0,0,4,0,2,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Итоговая балловая оценка",null,null,null,null,null,{"$f":"ROUND(T40-T47,3)","v":6},{"$f":"ROUND(U40-U47,3)","v":10.875},2.6749999999999998,5.5629999999999997,10.587999999999999,9.6,2.8,8.4629999999999992,8.3000000000000007,5.3,10.175000000000001,9.6,1.4,6.0250000000000004,5.1879999999999997,3.65]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Место",null,null,null,null,null,{"$f":"IFERROR((RANK(T48,$T48:$AI48,0)+(COUNTIF($T48:$AI48,T48)-1)/2),0)","v":9},{"$f":"IFERROR((RANK(U48,$T48:$AI48,0)+(COUNTIF($T48:$AI48,U48)-1)/2),0)","v":1},{"$f":"IFERROR((RANK(V48,$T48:$AI48,0)+(COUNTIF($T48:$AI48,V48)-1)/2),0)","v":15},{"$f":"IFERROR((RANK(W48,$T48:$AI48,0)+(COUNTIF($T48:$AI48,W48)-1)/2),0)","v":10},{"$f":"IFERROR((RANK(X48,$T48:$AI48,0)+(COUNTIF($T48:$AI48,X48)-1)/2),0)","v":2},{"$f":"IFERROR((RANK(Y48,$T48:$AI48,0)+(COUNTIF($T48:$AI48,Y48)-1)/2),0)","v":4.5},{"$f":"IFERROR((RANK(Z48,$T48:$AI48,0)+(COUNTIF($T48:$AI48,Z48)-1)/2),0)","v":14},{"$f":"IFERROR((RANK(AA48,$T48:$AI48,0)+(COUNTIF($T48:$AI48,AA48)-1)/2),0)","v":6},{"$f":"IFERROR((RANK(AB48,$T48:$AI48,0)+(COUNTIF($T48:$AI48,AB48)-1)/2),0)","v":7},{"$f":"IFERROR((RANK(AC48,$T48:$AI48,0)+(COUNTIF($T48:$AI48,AC48)-1)/2),0)","v":11},{"$f":"IFERROR((RANK(AD48,$T48:$AI48,0)+(COUNTIF($T48:$AI48,AD48)-1)/2),0)","v":3},{"$f":"IFERROR((RANK(AE48,$T48:$AI48,0)+(COUNTIF($T48:$AI48,AE48)-1)/2),0)","v":4.5},{"$f":"IFERROR((RANK(AF48,$T48:$AI48,0)+(COUNTIF($T48:$AI48,AF48)-1)/2),0)","v":16},{"$f":"IFERROR((RANK(AG48,$T48:$AI48,0)+(COUNTIF($T48:$AI48,AG48)-1)/2),0)","v":8},{"$f":"IFERROR((RANK(AH48,$T48:$AI48,0)+(COUNTIF($T48:$AI48,AH48)-1)/2),0)","v":12},{"$f":"IFERROR((RANK(AI48,$T48:$AI48,0)+(COUNTIF($T48:$AI48,AI48)-1)/2),0)","v":13}]
[]
[]
[]
["Рейтинговая оценка железных дорог по перспективам оценки за I квартал 2018 г. (№ 2769р от 28 декабря 2017 г.)"]
["Перспектива оценки","Вес",null,"Балл"]
[null,null,null,"ОКТ","КЛГ","МСК","ГОР","СЕВ","СКВ","ЮВС","ПРВ","КБШ","СВР","ЮУР","ЗСБ","КРС","ВСБ","ЗАБ","ДВС"]
["Экономика и финансы",{"$f":"SUM(B24:B28)","v":0.30000000000000004},null,{"$f":"ROUND(SUMPRODUCT($B$24:$B$28,T$24:T$28),3)","v":2.5},{"$f":"ROUND(SUMPRODUCT($B$24:$B$28,U$24:U$28),3)","v":2.1749999999999998},2.2250000000000001,1.6379999999999999,3.3879999999999999,2.5499999999999998,2.4750000000000001,2.6880000000000002,1.75,2.7250000000000001,2.125,3.5249999999999999,2.4750000000000001,3.0750000000000002,3.5379999999999998,0.95]
["Клиенты и рынки",{"$f":"SUM(B29:B33)","v":0.3},null,{"$f":"ROUND(SUMPRODUCT($B$29:$B$33,T$29:T$33),3)","v":2.3250000000000002},{"$f":"ROUND(SUMPRODUCT($B$29:$B$33,U$29:U$33),3)","v":4.5250000000000004},-0.45,2.4500000000000002,2.7250000000000001,3.5249999999999999,0.875,2.3250000000000002,1.7250000000000001,2.35,2.95,2.4,2.15,1.6,1.3,2.2250000000000001]
["Технологические процессы",{"$f":"SUM(B34:B36)","v":0.2},null,{"$f":"ROUND(SUMPRODUCT($B$34:$B$36,T$34:T$36),3)","v":0.92500000000000004},{"$f":"ROUND(SUMPRODUCT($B$34:$B$36,U$34:U$36),3)","v":1.675},0.05,0.85,2.6,1.95,0.9,1.65,2.2999999999999998,1,2.7749999999999999,2.5249999999999999,-0.57499999999999996,0.47499999999999998,0.8,0.1]
["Безопасность и надежность",{"$f":"SUM(B37:B38)","v":0.15000000000000002},null,{"$f":"ROUND(SUMPRODUCT($B$37:$B$38,T$37:T$38),3)","v":1.7},{"$f":"ROUND(SUMPRODUCT($B$37:$B$38,U$37:U$38),3)","v":2.4},0.35,0.85,1.6,1.2,0.1,1.6,2.25,1.45,1.95,1.1000000000000001,1.2,0.25,0.85,0.75]
["Персонал и развитие",{"$f":"SUM(B39)","v":0.05},null,{"$f":"ROUND(SUMPRODUCT($B$39,T$39),3)","v":0.55000000000000004},{"$f":"ROUND(SUMPRODUCT($B$39,U$39),3)","v":0.1},0.5,0.77500000000000002,0.27500000000000002,0.375,0.45,0.2,0.27500000000000002,0.77500000000000002,0.375,0.05,0.15,0.625,0.7,0.625]
[]
["Критические (барьерные) показатели",null,null,{"$f":"-SUM(ЖД!T42:T46)","v":-2},{"$f":"-SUM(ЖД!U42:U46)","v":0},{"$f":"-SUM(ЖД!V42:V46)","v":0},{"$f":"-SUM(ЖД!W42:W46)","v":-1},{"$f":"-SUM(ЖД!X42:X46)","v":0},{"$f":"-SUM(ЖД!Y42:Y46)","v":0},{"$f":"-SUM(ЖД!Z42:Z46)","v":-2},{"$f":"-SUM(ЖД!AA42:AA46)","v":0},{"$f":"-SUM(ЖД!AB42:AB46)","v":0},{"$f":"-SUM(ЖД!AC42:AC46)","v":-3},{"$f":"-SUM(ЖД!AD42:AD46)","v":0},{"$f":"-SUM(ЖД!AE42:AE46)","v":0},{"$f":"-SUM(ЖД!AF42:AF46)","v":-4},{"$f":"-SUM(ЖД!AG42:AG46)","v":0},{"$f":"-SUM(ЖД!AH42:AH46)","v":-2},{"$f":"-SUM(ЖД!AI42:AI46)","v":-1}]
[]
["Итоговая балловая оценка ",null,null,{"$f":"T48","v":6},{"$f":"U48","v":10.875},2.6749999999999998,5.5629999999999997,10.587999999999999,9.6,2.8,8.4629999999999992,8.3000000000000007,5.3,10.175000000000001,9.6,1.4,6.0250000000000004,5.1879999999999997,3.65]
["Место",null,null,{"$f":"T49","v":9},{"$f":"U49","v":1},15,10,2,4.5,14,6,7,11,3,4.5,16,8,12,13]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Место (УС)",null,null,null,null,null,{"$f":"T70","v":""},{"$f":"U70","v":""},"","","",2,"","","","",1,"","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"п.1",null,null,null,null,null,{"$f":"IF(T47>0,0,1)","v":0},{"$f":"IF(U47>0,0,1)","v":1},1,0,1,1,0,1,1,0,1,1,0,1,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"п.2",null,null,null,null,null,{"$f":"IF(T67>0,COUNTIF(T24:T39,\"<0\"),\"\")","v":""},{"$f":"IF(U67>0,COUNTIF(U24:U39,\"<0\"),\"\")","v":2},7,"",1,0,"",2,1,"",0,1,"",5,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"п.3",null,null,null,null,null,{"$f":"IF(AND(LEN(T68),T68=MIN($T$68:$AI$68)),T48,\"\")","v":""},{"$f":"IF(AND(LEN(U68),U68=MIN($T$68:$AI$68)),U48,\"\")","v":""},"","","",9.6,"","","","",10.175000000000001,"","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"п.4",null,null,null,null,null,{"$f":"IFERROR((RANK(T69,$T69:$AI69,0)+(COUNTIF($T69:$AI69,T69)-1)/2),\"\")","v":""},{"$f":"IFERROR((RANK(U69,$T69:$AI69,0)+(COUNTIF($T69:$AI69,U69)-1)/2),\"\")","v":""},"","","",2,"","","","",1,"","","","",""]