{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Лист1"],"not_rendered":{"charts":0,"images":1,"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":"Лист1","index":0,"n_rows":27,"n_cols":42,"rows_kept":27,"cut":false,"hidden":false,"merged":[[26,4,28,33],[0,0,0,2],[0,4,0,6],[0,7,0,9],[0,10,0,12],[0,13,0,15],[0,31,0,33],[0,16,0,18],[0,19,0,21],[0,22,0,24],[0,25,0,27],[0,28,0,30]]}
["Исходная таблица",null,null,null,"000-099",null,null,"100-199",null,null,"200-299",null,null,"300-399",null,null,"400-499",null,null,"500-599",null,null,"600-699",null,null,"700-799",null,null,"800-899",null,null,"900-999"]
["ВО","222","АМ","Иваново","ЕЕ",3,"ВМ","АО",133,"НВ","ВО",222,"АМ","ОУ",385,"АО","СН",432,"МУ","РК",511,"КМ","МС",600,"ЕС","ТА",717,"РЕ","РМ",810,"РА","ХЕ",941,"ТО"]
["ХЕ","941","ТО","Ижевск ","РС",4,"УУ","РВ",130,"ТМ","АС",291,"ВР",null,null,null,"КМ",404,"СА","ХУ",506,"УН",null,null,null,"АА",788,"НХ",null,null,null,"РС",962,"АО"]
["РС","962","АО","Изборск ","ОН",20,"ОС","МТ",101,"СК",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"КН",963,"АМ"]
["КН","963","АМ","Иркутск ","РУ",30,"СН",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ТС",901,"ТК"]
["ЕЕ","003","ВМ","Йошкар-Ола",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,"УТ",980,"КТ"]
["РС","004","УУ","Казань ",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,"УС",934,"ЕК"]
["МС","600","ЕС","Калининград",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,"ХХ",958,"КМ"]
["ОН","020","ОС","Калуга "]
["ТС","901","ТК","Калязин"]
["СН","432","МУ","Касимов"]
["АО","133","НВ","Киров "]
["РВ","130","ТМ","Клин "]
["РУ","030","СН","Козельск "]
["АС","291","ВР","Коломна "]
["ТА","717","РЕ","Кострома"]
["ОУ","385","АО","Краснодар "]
["КМ","404","СА","Красноярск"]
["АА","788","НХ","Кронштадт "]
["РК","511","КМ","Курск "]
["УТ","980","КТ","Липецк "]
["РМ","810","РА","Луховицы"]
["МТ","101","СК","Малоярославец ",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,{"$f":"AM23&AN23&AO23","v":""}]
["УС","934","ЕК","Можайск "]
["ХУ","506","УН","Москва"]
["ХХ","958","КМ","Мурманск"]
[null,null,null,null,"Таблица вверху (разукрашеная) получается после фильтрации (с этим я справился с грехом пополам.)"]