{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["абоненты","Список кодов","коды, операторы, регионы"],"not_rendered":{"charts":0,"images":1,"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":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[]
["абонент"]
["Сидоров И.Н.",9194144551,"МТС, Республика Марий Эл,     +7 (919) 414-45-51","+7(919) 414-45-51   МТС, Республика Марий Эл"]
["Петров И.И.",null,"Билайн                                     +7 (961) 265-45-51","+7(919) 980-00-00   МТС, Волгоградская обл."]
["Петров А.И.",null,"г. Москва                                    8 (495) 265-45-61","+7(919) 180-00-00   МТС, Воронежская обл."]
["Сидоров И.Ф.",null,"г. Булик                                      8 (800) 265-45-51","+7(919) 230-00-00   МТС, Воронежская обл."]
["Петров И.И.",null,"МегаФон,                                 +7 (910) 362-25-47","+7(919) 030-00-00   МТС, Калужская обл."]
["Петров А.И.",null,"Т2 Мобайл (Теле2)","+7(919) 500-00-00   МТС, Кировская обл."]
["Сидоров Н.А.",9191799599,"МТС, Республика Марий Эл,     +7 (919) 179-95-99","+7(919) 179-95-99   МТС, Курская обл."]
[]
[null,null,"надписи оператора и региона в условном форматировании ячейки"]

{"sheet":"Список кодов","index":1,"n_rows":12,"n_cols":11,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["Список задействованных мобильных кодов:"]
[]
["90x:",900,901,902,903,904,905,906,null,908,909]
["91x:",910,911,912,913,914,915,916,917,918,919]
["92x:",920,921,922,923,924,925,926,927,928,929]
["93x:",930,931,932,933,934,null,936,937,938,939]
["94x:",null,941]
["95x:",950,951,952,953,954,955,956,null,958]
["96x:",960,961,962,963,964,965,966,967,968,969]
["97x:",970,971,null,null,null,null,null,977,978]
["98x:",980,981,982,983,984,985,986,987,988,989]
["99x:",null,991,992,993,994,995,996,997,null,999]

{"sheet":"коды, операторы, регионы","index":2,"n_rows":75,"n_cols":12,"rows_kept":75,"cut":false,"hidden":false,"merged":[[65,1,66,1],[67,1,68,1],[73,1,74,1],[5,1,6,1],[16,1,19,1],[20,1,21,1],[8,1,10,1],[11,1,12,1],[69,1,70,1],[71,1,72,1],[35,1,36,1],[37,1,38,1],[22,1,30,1],[32,1,34,1],[57,1,59,1],[60,1,62,1],[40,1,42,1],[44,1,45,1]]}
["Актуализация:","2018-01-06"]
[]
["МТС","Белгородская обл.",9192200000,9192299999,"+7 919 22x-xx-xx","Код:",919,null,{"$f":"LEFTB(C3,3)","v":"919"},{"$f":"VALUE(SUBSTITUTE(C3,$I3,\"\",1))","v":2200000},{"$f":"VALUE(SUBSTITUTE(D3,$I3,\"\",1))","v":2299999},{"$f":"COLUMN()","v":12}]
["МТС",null,9192800000,9192899999,"28x-xx-xx","Сотовый оператор:","МТС (МТС)",null,{"$f":"LEFTB(C4,3)","v":"919"},{"$f":"VALUE(SUBSTITUTE(C4,$I4,\"\",1))","v":2800000},{"$f":"VALUE(SUBSTITUTE(D4,$I4,\"\",1))","v":2899999}]
["МТС",null,9194300000,9194399999,"43x-xx-xx","Регионов РФ:",33,null,"919",4300000,4399999]
["МТС","Брянская обл.",9191900000,9191999999,"+7 919 19x-xx-xx",null,null,null,"919",1900000,1999999]
["МТС",null,9192900000,9192999999,"29x-xx-xx",null,null,null,"919",2900000,2999999]
["МТС","Владимирская обл.",9190000000,9190299999,"+7 919 0xx-xx-xx",null,null,null,"919",0,299999]
["МТС","Волгоградская обл.",9195400000,9195499999,"+7 919 54x-xx-xx",null,null,null,"919",5400000,5499999]
["МТС",null,9197900000,9197999999,"79x-xx-xx",null,null,null,"919",7900000,7999999]
["МТС",null,9199800000,9199899999,"98x-xx-xx",null,null,null,"919",9800000,9899999]
["МТС","Воронежская обл.",9191800000,9191899999,"+7 919 18x-xx-xx",null,null,null,"919",1800000,1899999]
["МТС",null,9192300000,9192499999,"2xx-xx-xx",null,null,null,"919",2300000,2499999]
["МТС","Калужская обл.",9190300000,9190399999,"+7 919 03x-xx-xx",null,null,null,"919",300000,399999]
["МТС","Кировская обл.",9195000000,9195299999,"+7 919 5xx-xx-xx",null,null,null,"919",5000000,5299999]
["МТС","Курганская обл.",9195600000,9195999999,"+7 919 5xx-xx-xx",null,null,null,"919",5600000,5999999]
["МТС","Курская обл.",9191300000,9191369999,"+7 919 13x-xx-xx",null,null,null,"919",1300000,1369999]
["МТС",null,9191700000,9191799999,"17x-xx-xx",null,null,null,"919",1700000,1799999]
["МТС",null,9192100000,9192199999,"21x-xx-xx",null,null,null,"919",2100000,2199999]
["МТС",null,9192700000,9192799999,"27x-xx-xx",null,null,null,"919",2700000,2799999]
["МТС","Липецкая обл.",9191600000,9191699999,"+7 919 16x-xx-xx",null,null,null,"919",1600000,1699999]
["МТС",null,9192500000,9192599999,"25x-xx-xx",null,null,null,"919",2500000,2599999]
["МТС","Московская обл.",9191000000,9191099999,"+7 919 10x-xx-xx",null,null,null,"919",1000000,1099999]
["МТС",null,9191390000,9191399999,"139-xx-xx",null,null,null,"919",1390000,1399999]
["МТС",null,9194100000,9194119999,"41x-xx-xx",null,null,null,"919",4100000,4119999]
["МТС",null,9197200000,9197299999,"72x-xx-xx",null,null,null,"919",7200000,7299999]
["МТС",null,9197600000,9197799999,"7xx-xx-xx",null,null,null,"919",7600000,7799999]
["МТС",null,9197840000,9197849999,"784-xx-xx",null,null,null,"919",7840000,7849999]
["МТС",null,9197860000,9197869999,"786-xx-xx",null,null,null,"919",7860000,7869999]
["МТС",null,9199600000,9199709999,"9xx-xx-xx",null,null,null,"919",9600000,9709999]
["МТС",null,9199900000,9199999999,"99x-xx-xx",null,null,null,"919",9900000,9999999]
["МТС","Оренбургская обл.",9198400000,9198699999,"+7 919 8xx-xx-xx",null,null,null,"919",8400000,8699999]
["МТС","Орловская обл.",9190900000,9190999999,"+7 919 09x-xx-xx",null,null,null,"919",900000,999999]
["МТС",null,9192000000,9192099999,"20x-xx-xx",null,null,null,"919",2000000,2099999]
["МТС",null,9192600000,9192699999,"26x-xx-xx",null,null,null,"919",2600000,2699999]
["МТС","Пермский край",9194400000,9194999999,"+7 919 4xx-xx-xx",null,null,null,"919",4400000,4999999]
["МТС",null,9197000000,9197199999,"7xx-xx-xx",null,null,null,"919",7000000,7199999]
["МТС","Республика Башкортостан",9191400000,9191599999,"+7 919 1xx-xx-xx",null,null,null,"919",1400000,1599999]
["МТС",null,9196000000,9196199999,"6xx-xx-xx",null,null,null,"919",6000000,6199999]
["МТС","Республика Марий Эл",9194120000,9194199999,"+7 919 41x-xx-xx",null,null,null,"919",4120000,4199999]
["МТС","Республика Мордовия",9197800000,9197839999,"+7 919 78x-xx-xx",null,null,null,"919",7800000,7839999]
["МТС",null,9197850000,9197859999,"785-xx-xx",null,null,null,"919",7850000,7859999]
["МТС",null,9197870000,9197899999,"78x-xx-xx",null,null,null,"919",7870000,7899999]
["МТС","Республика Северная Осетия - Алания",9194200000,9194299999,"+7 919 42x-xx-xx",null,null,null,"919",4200000,4299999]
["МТС","Республика Татарстан",9196200000,9196499999,"+7 919 6xx-xx-xx",null,null,null,"919",6200000,6499999]
["МТС",null,9196800000,9196999999,"6xx-xx-xx",null,null,null,"919",6800000,6999999]
["МТС","Ростовская обл.",9198700000,9198999999,"+7 919 8xx-xx-xx",null,null,null,"919",8700000,8999999]
["МТС","Самарская обл.",9198000000,9198199999,"+7 919 8xx-xx-xx",null,null,null,"919",8000000,8199999]
["МТС","Саратовская обл.",9198200000,9198399999,"+7 919 8xx-xx-xx",null,null,null,"919",8200000,8399999]
["МТС","Свердловская обл.",9193600000,9193999999,"+7 919 3xx-xx-xx",null,null,null,"919",3600000,3999999]
["МТС","Смоленская обл.",9190400000,9190499999,"+7 919 04x-xx-xx",null,null,null,"919",400000,499999]
["МТС","Ставропольский край",9197300000,9197599999,"+7 919 7xx-xx-xx",null,null,null,"919",7300000,7599999]
["МТС","Тверская обл.",9190500000,9190699999,"+7 919 0xx-xx-xx",null,null,null,"919",500000,699999]
["МТС","Тульская обл.",9190700000,9190899999,"+7 919 0xx-xx-xx",null,null,null,"919",700000,899999]
["МТС","Тюменская обл.",9199200000,9199599999,"+7 919 9xx-xx-xx",null,null,null,"919",9200000,9599999]
["МТС","Удмуртская Республика",9199000000,9199199999,"+7 919 9xx-xx-xx",null,null,null,"919",9000000,9199999]
["МТС","Ханты-Мансийский АО (Югра)",9195300000,9195399999,"+7 919 53x-xx-xx",null,null,null,"919",5300000,5399999]
["МТС","Челябинская обл.",9191100000,9191299999,"+7 919 1xx-xx-xx",null,null,null,"919",1100000,1299999]
["МТС",null,9193000000,9193599999,"3xx-xx-xx",null,null,null,"919",3000000,3599999]
["МТС",null,9194000000,9194099999,"40x-xx-xx",null,null,null,"919",4000000,4099999]
["МТС","Чувашская Республика",9191380000,9191389999,"+7 919 138-xx-xx",null,null,null,"919",1380000,1389999]
["МТС",null,9196500000,9196799999,"6xx-xx-xx",null,null,null,"919",6500000,6799999]
["МТС",null,9199710000,9199799999,"97x-xx-xx",null,null,null,"919",9710000,9799999]
["МТС","Ямало-Ненецкий АО",9195500000,9195599999,"+7 919 55x-xx-xx",null,null,null,"919",5500000,5599999]
[null,null,null,null,null,null,null,null,""]
["МТС","Белгородская обл.","2000000 ... 2099999",null,"+7 920 20x-xx-xx","Код:",920,null,920,{"$f":"VALUE(LEFTB(C66,7))","v":2000000},{"$f":"VALUE(RIGHTB(C66,LEN(C66)-12))","v":2099999}]
["МТС",null,"5500000 ... 5999999",null,"5xx-xx-xx","Сотовый оператор:","МТС (МТС)",null,920,{"$f":"VALUE(LEFTB(C67,7))","v":5500000},{"$f":"VALUE(RIGHTB(C67,LEN(C67)-12))","v":5999999}]
["МТС","Брянская обл.","6000000 ... 6099999",null,"+7 920 60x-xx-xx","Регионов РФ:",17,null,920,6000000,6099999]
["МТС",null,"8300000 ... 8699999",null,"8xx-xx-xx",null,null,null,920,8300000,8699999]
["МТС","Владимирская обл.","6200000 ... 6299999",null,"+7 920 62x-xx-xx",null,null,null,920,6200000,6299999]
["МТС",null,"9000000 ... 9499999",null,"9xx-xx-xx",null,null,null,920,9000000,9499999]
["МТС","Воронежская обл.","2100000 ... 2299999",null,"+7 920 2xx-xx-xx",null,null,null,920,2100000,2299999]
["МТС",null,"4000000 ... 4699999",null,"4xx-xx-xx",null,null,null,920,4000000,4699999]
["МТС","Ивановская обл.","3400000 ... 3799999",null,"+7 920 3xx-xx-xx",null,null,null,920,3400000,3799999]
["МТС",null,"6700000 ... 6799999",null,"67x-xx-xx",null,null,null,920,6700000,6799999]