{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Статистика","Вагоны депо","Парность","Перегоны","Отчёт"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":18,"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":50,"n_cols":25,"rows_kept":50,"cut":false,"hidden":false,"merged":[]}
["Депо","Год","Квартал","Месяц","Число","Маршрут","№ вагона","Тип вагона","Тип АРС","Время (часы)","Время (минуты)","Перегон (станция)","Путь","Расстояние от станции отправления, м","Скорость","Расстояние от ст. отпр. с учётом задержки, м","Рельсовая цепь","График рабочего дня или выходного (раб/вых)","Парность поездов по графику на данный момент времени","Предыдущий сигнал АЛС","Принятый сигнал АЛС","Последующий сигнал АЛС","Длительность сбоя восприятия АЛС (\"ОЧ\" или \"40\") в сек.","Тормоз АРС из-за сбоя (да/нет)","Положение КВ (КМ)"]
["ТЧ-11 Выхино",2018,1,1,8,34,37327,"81-760","Витязь-М",16,13,"Сходненская - Планерная",2,662.4,64,653,"490а","раб",35,80,"ОЧ",80,1,"Да",0]
["ТЧ-11 Выхино",2018,1,1,11,35,65196,"81-765","СКИФ-М",19,34,"Беговая - Улица 1905 года",1,432.1,null,424,"349б","раб",36,75,"ОЧ",75,135,"Да","Т+"]
["ТЧ-11 Выхино",2018,1,1,15,13,65208,"81-765","СКИФ-М",22,29,"Лермонтовский проспект - Жулебино",1,466.8,52,null,6119,"раб",18,60,"ОЧ",60,1,"Да","Т"]
["ТЧ-11 Выхино",2018,1,1,16,6,65034,"81-765","СКИФ-М",19,11,"Беговая - Улица 1905 года",1,430.7,44,null,"349а","раб",36,75,"ОЧ",75,12,"Да","Т"]
["ТЧ-11 Выхино",2018,1,1,18,28,65035,"81-765","СКИФ-М",8,8,"Пушкинская - Баррикадная",2,1594.9,0,1595,304,"раб",37,75,"ОЧ",75,15,"Да","Т"]
["ТЧ-11 Выхино",2018,1,1,18,9,65041,"81-765","СКИФ-М",18,21,"Выхино - Рязанский проспект",2,20.7,0,21,"36с","раб",37,40,"ОЧ",0,1,"Да",0]
["ТЧ-11 Выхино",2018,1,1,18,20,37309,"81-760","Витязь-М",10,19,"Рязанский проспект - Выхино",1,0.3,0,0,61,"раб",27,60,"ОЧ",60,60,"Да","Х"]
["ТЧ-11 Выхино",2018,1,1,24,28,65201,"81-765","СКИФ-М",18,23,"Жулебино - Лермонтовский проспект",2,1441.1,74,null,6162,"раб",37,80,"ОЧ",80,1,"Да","Х"]
["ТЧ-11 Выхино",2018,1,2,8,1,65202,"81-765","СКИФ-М",20,3,"Баррикадная - Пушкинская",1,1527.1,2,1527,299,"раб",31,75,"ОЧ",60,1,"Да",0]
["ТЧ-11 Выхино",2018,1,2,8,31,65207,"81-765","СКИФ-М",19,39,"Жулебино - Лермонтовский проспект",2,1451.1,60,1441,6162,"раб",36,60,"ОЧ",60,1,"Да",0]
["ТЧ-11 Выхино",2018,1,2,9,16,37281,"81-760.А","Витязь-М",9,14,"Тушинская - Спартак",1,321.10000000000002,72,null,"459б","раб",37,80,"ОЧ",80,1,"Да",0]
["ТЧ-11 Выхино",2018,1,2,9,16,37281,"81-760.А","Витязь-М",18,29,"Выхино - Лермонтовский проспект",1,1888,50,1881,6059,"раб",37,75,"ОЧ",75,1,"Да",0]
["ТЧ-11 Выхино",2018,1,2,9,33,65009,"81-765","СКИФ-М",21,5,"Таганская - Китай-город",2,332,2,332,"152б","раб",28,75,"ОЧ",80,1,"Да","Т"]
["ТЧ-11 Выхино",2018,1,2,13,14,65049,"81-765","СКИФ-М",20,44,"Лермонтовский проспект - Выхино",2,769,70,759,6026,"Раб",31,80,"ОЧ",75,1,"Да",0]
["ТЧ-11 Выхино",2018,1,2,25,35,65041,"81-765","СКИФ-М",19,20,"Выхино - Рязанский проспект",2,167,60,159,"38а","Вых",23,80,"ОЧ",80,1,"Да","Х"]
["ТЧ-11 Выхино",2018,1,3,2,35,65015,"81-765","СКИФ-М",18,20,"Выхино - Рязанский проспект",2,164,50,157,"38а","Раб",37,80,"ОЧ",80,1,"Да",0]
["ТЧ-11 Выхино",2018,1,3,4,10,65009,"81-765","СКИФ-М",20,38,"Выхино - Рязанский проспект",2,170,46,164,"38а","Вых",23,80,"ОЧ",80,1,"Да",0]
["ТЧ-11 Выхино",2018,1,3,4,37,65011,"81-765","СКИФ-М",9,25,"Выхино - Рязанский проспект",2,156,34,151,"38а","Вых",24,80,"ОЧ",80,1,"Да",0]
["ТЧ-11 Выхино",2018,1,3,4,22,65017,"81-765","СКИФ-М",17,4,"Выхино - Рязанский проспект",2,156,40,151,"38а","Вых",24,80,"ОЧ",80,1,"Да",0]
["ТЧ-11 Выхино",2018,1,3,4,34,65030,"81-765","СКИФ-М",9,2,"Беговая - Улица 1905 года",1,154,50,147,349,"Вых",24,80,"ОЧ",80,1,"Да",0]
["ТЧ-11 Выхино",2018,1,3,4,22,65017,"81-765","СКИФ-М",6,45,"Выхино - Рязанский проспект",2,155,40,147,"38а","Вых",19,80,"ОЧ",80,1,"Да",0]
["ТЧ-11 Выхино",2018,1,3,4,30,65046,"81-765","СКИФ-М",4,3,"Выхино - Рязанский проспект",2,203,50,196,"38б","Вых",1,80,"ОЧ",80,1,"Да",0]
["ТЧ-11 Выхино",2018,1,3,5,15,65003,"81-765","СКИФ-М",12,27,"Выхино - Рязанский проспект",2,183,46,176,"38а","Раб",24,80,"ОЧ",80,1,"Да",0]
["ТЧ-11 Выхино",2018,1,3,5,30,65046,"81-765","СКИФ-М",16,10,"Выхино - Рязанский проспект",2,186,58,178,"38б","Раб",27,80,"ОЧ",80,1,"Да",0]
["ТЧ-11 Выхино",2018,1,3,5,11,65199,"81-765","СКИФ-М",6,12,"Выхино - Рязанский проспект",2,162,46,155,"38а","Раб",38,80,"ОЧ",80,1,"Да",0]
["ТЧ-11 Выхино",2018,1,3,5,18,65028,"81-765","СКИФ-М",10,3,"Выхино - Рязанский проспект",2,156,46,149,"38а","Раб",27,80,"ОЧ",80,1,"Да",0]
["ТЧ-11 Выхино",2018,1,3,5,26,65203,"81-765","СКИФ-М",18,55,"Выхино - Рязанский проспект",2,163,50,156,"38а","Раб",37,80,"ОЧ",80,1,"Да",0]
["ТЧ-11 Выхино",2018,1,3,6,22,65035,"81-765","СКИФ-М",21,6,"Полежаевская - Октябрьское поле",2,146,28,142,"374а","Раб",28,75,"ОЧ",80,1,"Да","Т"]
["ТЧ-11 Выхино",2018,1,3,6,36,65017,"81-765","СКИФ-М",20,48,"Полежаевская - Октябрьское поле",2,115,36,110,"374а","Раб",31,75,"ОЧ",80,3,"Да",0]
["ТЧ-11 Выхино",2018,1,3,6,28,65049,"81-765","СКИФ-М",13,15,"Полежаевская - Октябрьское поле",2,96,48,90,"374а","Раб",23,75,"ОЧ",75,1,"Да",0]
["ТЧ-11 Выхино",2018,1,3,6,16,65003,"81-765","СКИФ-М",19,6,"Выхино - Рязанский проспект",2,175,55,165,"38а","Раб",36,80,"ОЧ",80,1,"Да",0]
["ТЧ-11 Выхино",2018,1,3,6,35,65030,"81-765","СКИФ-М",21,6,"Полежаевская - Октябрьское поле",2,97,47,91,"374а","Раб",28,75,"ОЧ",80,1,"Да",0]
["ТЧ-11 Выхино",2018,1,3,6,31,65046,"81-765","СКИФ-М",7,56,"Выхино - Рязанский проспект",2,180,54,172,"38а","Раб",38,80,"ОЧ",80,1,"Да",0]
["ТЧ-11 Выхино",2018,1,3,6,31,65046,"81-765","СКИФ-М",21,5,"Полежаевская - Октябрьское поле",2,91,19,89,"374а","Раб",28,80,"ОЧ",80,1,"Да",0]
["ТЧ-11 Выхино",2018,1,3,6,16,65003,"81-765","СКИФ-М",12,46,"Выхино - Рязанский проспект",2,174,49,167,"38а","Раб",23,80,"ОЧ",80,1,"Да",0]
["ТЧ-11 Выхино",2018,1,3,10,25,65007,"81-765","СКИФ-М",23,49,"Выхино - Рязанский проспект",2,176,58,168,"38а","Раб",17,80,"ОЧ",80,1,"Да",0]
["ТЧ-11 Выхино",2018,1,3,12,22,65205,"81-765","СКИФ-М",18,50,"Выхино - Рязанский проспект",2,168,50,161,"38а","Раб",37,80,"ОЧ",80,1,"Да",0]
["ТЧ-11 Выхино",2018,1,3,12,27,65007,"81-765","СКИФ-М",6,46,"Выхино - Рязанский проспект",2,161,56,153,"38а","Раб",27,80,"ОЧ",80,1,"Да",0]
["ТЧ-11 Выхино",2018,1,3,13,4,65019,"81-765","СКИФ-М",6,30,"Выхино - Рязанский проспект",2,167,53,161,"38а","Раб",27,80,"ОЧ",80,1,"Да",0]
["ТЧ-11 Выхино",2018,1,3,13,33,37321,"81-760","Витязь-М",10,1,"Выхино - Рязанский проспект",2,720,35,715,"42а","Раб",27,40,"ОЧ",75,1,"Да",0]
["ТЧ-11 Выхино",2018,2,4,16,22,65213,"81-765","СКИФ-М",14,1,"Сходненская - Планерная",2,610,52,null,"488а","раб",23,75,"ОЧ",75,1,"да",0]
["ТЧ-11 Выхино",2018,2,4,16,15,65008,"81-765","СКИФ-М",9,33,"Китай-город - Таганская",1,1703,0,1703,161,"раб",37,60,"ОЧ",null,30,"да","Т"]
["ТЧ-11 Выхино",2018,2,4,18,17,65007,"81-765","СКИФ-М",11,22,"Текстильщики - Волгоградский проспект",2,579,1,579,"102б","раб",23,80,"ОЧ",null,30,"да","Т"]
["ТЧ-11 Выхино",2018,2,4,26,9,65009,"81-765","СКИФ-М",16,13,"Сходненская - Планерная",2,657,50,null,"488а","раб",35,80,"ОЧ",80,2,"да",0]
["ТЧ-11 Выхино",2018,2,5,15,38,65059,"81-765","СКИФ-М",16,21,"Тушинская - Сходненская",2,2261,10,null,474,"раб",35,60,"ОЧ",null,40,"да","Т"]
["ТЧ-11 Выхино",2018,2,5,22,36,65035,"81-765","СКИФ-М",21,39,"Щукинская - Спартак",2,805,22,805,426,"раб",28,60,"ОЧ",60,2,"да","Т"]
["ТЧ-11 Выхино",2018,2,5,22,1,65007,"81-765","СКИФ-М",21,5,"Щукинская - Спартак",2,800,50,800,426,"раб",28,60,"ОЧ",60,2,"да","Т"]
["ТЧ-11 Выхино",2018,2,5,30,20,65012,"81-765","СКИФ-М",6,52,"Китай-город - Таганская",1,2051,35,null,155,"раб",27,60,"ОЧ",60,1,"да","Т"]
["ТЧ-11 Выхино",2018,2,5,30,3,65194,"81-765","СКИФ-М",14,20,"Китай-город - Таганская",1,2026,40,null,"157а","раб",23,60,"ОЧ",60,1,"да","Т"]

{"sheet":"Вагоны депо","index":1,"n_rows":16,"n_cols":26,"rows_kept":16,"cut":false,"hidden":true,"merged":[[0,1,0,2]]}
["Депо:","ТЧ-11 Выхино",null,null,null,null,"ТЧ-1 Северное","ТЧ-2 Сокол","ТЧ-3 Измайлово","ТЧ-4 Красная Пресня","ТЧ-5 Калужское","ТЧ-6 Планерное","ТЧ-7 Замоскворецкое","ТЧ-8 Варшавское","ТЧ-9 Фили","ТЧ-10 Свиблово","ТЧ-11 Выхино","ТЧ-12 Новогиреево","ТЧ-13 Черкизово","ТЧ-14 Владыкино","ТЧ-15 Печатники","ТЧ-16 Митино","ТЧ-17 Братеево","ТЧ-18 Солнцево","ТЧ-19 Лихоборы","ТЧ-20 Руднево"]
["№ вагона","Тип вагона","Тип АРС"]
[65001,"81-765","Скиф-М"]
[65002,"81-765","Скиф-М"]
[65005,"81-765","Скиф-М"]
[65006,"81-765","Скиф-М"]
[65007,"81-765","Скиф-М"]
[65008,"81-765","Скиф-М"]
[65009,"81-765","Скиф-М"]
[65010,"81-765","Скиф-М"]
[65011,"81-765","Скиф-М"]
[65012,"81-765","Скиф-М"]
[65013,"81-765","Скиф-М"]
[65014,"81-765","Скиф-М"]
[65015,"81-765","Скиф-М"]
[65016,"81-765","Скиф-М"]

{"sheet":"Парность","index":2,"n_rows":26,"n_cols":7,"rows_kept":26,"cut":false,"hidden":true,"merged":[[0,0,0,2],[0,4,0,6]]}
["Будние дни",null,null,null,"Выходные и праздничные дни"]
["с","до","парность",null,"с","до","парность"]
["04:00:00","04:59:00",null,null,"04:00:00","04:59:00"]
["05:00:00","05:59:00",1,null,"05:00:00","05:59:00",23]
["06:00:00","06:59:00",2,null,"06:00:00","06:59:00",24]
["07:00:00","07:59:00",3,null,"07:00:00","07:59:00",25]
["08:00:00","08:59:00",4,null,"08:00:00","08:59:00",26]
["09:00:00","09:59:00",5,null,"09:00:00","09:59:00",27]
["10:00:00","10:59:00",6,null,"10:00:00","10:59:00",28]
["11:00:00","11:59:00",7,null,"11:00:00","11:59:00",29]
["12:00:00","12:59:00",8,null,"12:00:00","12:59:00",30]
["13:00:00","13:59:00",9,null,"13:00:00","13:59:00",31]
["14:00:00","14:59:00",10,null,"14:00:00","14:59:00",32]
["15:00:00","15:59:00",11,null,"15:00:00","15:59:00",33]
["16:00:00","16:59:00",12,null,"16:00:00","16:59:00",34]
["17:00:00","17:59:00",13,null,"17:00:00","17:59:00",35]
["18:00:00","18:59:00",14,null,"18:00:00","18:59:00",36]
["19:00:00","19:59:00",15,null,"19:00:00","19:59:00",37]
["20:00:00","20:59:00",16,null,"20:00:00","20:59:00",38]
["21:00:00","21:59:00",17,null,"21:00:00","21:59:00",39]
["22:00:00","22:59:00",18,null,"22:00:00","22:59:00",40]
["23:00:00","23:59:00",19,null,"23:00:00","23:59:00",41]
[1,1.04097222222222,20,null,1,1.04097222222222,42]
[1.0416666666666701,1.08263888888889,21,null,1.0416666666666667,1.08263888888889,43]
[1.0833333333333299,1.1243055555555601,22,null,1.0833333333333299,1.1243055555555601,44]
[1.12499999999999,1.16597222222223,23,null,1.12499999999999,1.16597222222223,45]

{"sheet":"Перегоны","index":3,"n_rows":20,"n_cols":5,"rows_kept":20,"cut":false,"hidden":true,"merged":[]}
["Перегон (станция)","Путь","РЦ","Расстояние от указателя остановки на станции","Кодировка АРС"]
["Оборотный тупик - Планерная",1,509,62.5,"1/5 ТКЛ"]
["Оборотный тупик - Планерная",1,507,110,"1/5 ТКЛ"]
["Оборотный тупик - Планерная",1,505,160,"1/5 ТКЛ"]
["Оборотный тупик - Планерная",1,503,234.3,"1/5 ТКЛ"]
["Планерная - Сходненская",1,503,13.2,"1/5 ТКЛ"]
["Планерная - Сходненская",1,"503а",75.7,"1/5 ТКЛ"]
["Планерная - Сходненская",1,501,150.69999999999999,"1/5 ТКЛ"]
["Планерная - Сходненская",1,"501а",425.7,"1/5 ТКЛ"]
["Планерная - Сходненская",1,499,613.20000000000005,"1/5 ТКЛ"]
["Планерная - Сходненская",1,"499а",725.7,"1/5 ТКЛ"]
["Планерная - Сходненская",1,497,825.7,"1/5 ТКЛ"]
["Планерная - Сходненская",1,"497а",925.7,"1/5 ТКЛ"]
["Планерная - Сходненская",1,495,963.2,"1/5 ТКЛ"]
["Планерная - Сходненская",1,493,1000.7,"1/5 ТКЛ"]
["Планерная - Сходненская",1,491,1038.2,"1/5 ТКЛ"]
["Планерная - Сходненская",1,489,1088.2,"1/5 ТКЛ"]
["Планерная - Сходненская",1,"489с",1157.2,"1/5 ТКЛ"]
["Сходненская - Тушинская",1,"489с",18.5,"1/5 ТКЛ"]
["Сходненская - Тушинская",1,"487с",81,"1/5 ТКЛ"]

{"sheet":"Отчёт","index":4,"n_rows":22,"n_cols":8,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
[null,"Отчет за","2","квартал",null,"линия:"]
["№ п/п","РЦ",{"$f":"CONCATENATE(\"количество ОЧ за \",C1,\" \",D1)","v":"количество ОЧ за 2 квартал"},{"$f":"CONCATENATE(\"количество ОЧ за \",IF(C1-1=0,4,C1-1),\" \",D1)","v":"количество ОЧ за 1 квартал"},{"$f":"CONCATENATE(\"количество 40 за \",C1,\" \",D1)","v":"количество 40 за 2 квартал"},{"$f":"CONCATENATE(\"количество 40 за \",IF(E1-1=0,4,C1-1),\" \",D1)","v":"количество 40 за 1 квартал"},"Всего:","дата последнего случая"]
[1,"488а",2,0,0,0,2]
[2,426,2,0,0,0,2]
[3,161,1,0,0,0,1]
[4,"102б",1,0,0,0,1]
[5,474,1,0,0,0,1]
[6,155,1,0,0,0,1]
[7,"157а",1,0,0,0,1]
[8,"490а",0,1,0,0,0]
[9,"349б",0,1,0,0,0]
[10,6119,0,1,0,0,0]
[11,"349а",0,1,0,0,0]
[12,304,0,1,0,0,0]
[13,"36с",0,1,0,0,0]
[14,61,0,1,0,0,0]
[15,6162,0,2,0,0,0]
[16,299,0,1,0,0,0]
[17,"459б",0,1,0,0,0]
[18,6059,0,1,0,0,0]
[19,"152б",0,1,0,0,0]
[20,6026,0,1,0,0,0]