{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Задания","Условия","Лист1","Сводная"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":1},"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":10,"n_cols":2,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
[]
[1,"В таблицу 1 проставьте названия городов из таблицы 2 в соответствии с кодами городов, а также стоимость по каждой строке."]
[2,"В таблице 2 посчитайте суммы по каждому городу из таблицы 1."]
[3,"Проставьте в таблице 1 статус каждой строки из таблицы 3 в зависимости от стоимости."]
[4,"В первом столбце таблицы 4 есть набор данных, во втором столбце такой же набор данных за исключением 10 значений. Найдите значения в первом столбце, которых нет во втором."]
[5,"На листе \"Сводная\" создайте сводную таблицу из таблицы 1, отражающую суммы по каждому городу и статусу."]
[6,"Создайте макрос, который в ячейку D10 поместит из таблицы 1 общую стоимость по позициям, по которым количество больше 50."]
[]
[null,"Время выполнения всех заданий - 30 минут максимум (в идеале 5-10 мин)."]

{"sheet":"Условия","index":1,"n_rows":1017,"n_cols":15,"rows_kept":1017,"cut":false,"hidden":false,"merged":[[9,0,9,2]]}
[null,null,null,null,null,null,null,null,null,"Таблица 2",null,null,null,"Таблица 3"]
[null,null,null,null,null,null,null,null,null,"Код города","Название города","Сумма",null,"Условие","Статус"]
[null,null,null,null,null,null,null,null,null,1,"Москва",{"$f":"SUMIF($C$18:$F$1017,K3,$F$18:$F$1017)","v":238495651},null,"больше 5 млн","А"]
[null,null,null,null,null,null,null,null,null,2,"Санкт-Петербург",{"$f":"SUMIF($C$18:$F$1017,K4,$F$18:$F$1017)","v":216862066},null,"от 1 до 5 млн","Б"]
[null,null,null,null,null,null,null,null,null,3,"Челябинск",280549198,null,"меньше 1 млн","В"]
[null,null,null,null,null,null,null,null,null,4,"Архангельск",279796944]
[null,null,null,null,null,null,null,null,null,5,"Краснодар",244148856]
[null,null,null,null,null,null,null,null,null,6,"Владивосток",253105795]
[null,null,null,null,null,null,null,null,null,7,"Мурманск",219392326]
["Результирующая ячейка для макроса",null,null,null,null,null,null,null,null,8,"Новосибирск",259970564]
[null,null,null,null,null,null,null,null,null,9,"Тюмень",219317957]
[null,null,null,null,null,null,null,null,null,10,"Сочи",189443740]
[null,null,null,null,null,null,null,null,null,{"$f":"SUMIF(J21:J1020,\">50\",L21:L1020)","v":0},"Итого:",{"$f":"SUM(L3:L12)","v":2401083097}]
[]
[]
["Таблица 1",null,null,null,null,null,null,null,null,"Таблица 4"]
["№","Код города","Название города","Кол-во","Цена","Стоимость","Статус",null,null,"Исходные данные","Конечные данные"]
[1,1,{"$f":"VLOOKUP(B18,$J$2:$L$12,2,0)","v":"Москва"},56,93470,{"$f":"D18*E18","v":5234320},{"$f":"IF(F18>5000000,\"А\",IF(F18<999999,\"В\",IF(AND(F18>999999,F18<5000000),\"Б\")))","v":"А"},null,null,93470,16744,{"$f":"IF(COUNTIF($K$18:$K$1017,J18)>0,\"Есть\",\"Нет\")","v":"Есть"}]
[2,4,"Архангельск",29,15436,{"$f":"D19*E19","v":447644},"В",null,null,15436,98543,{"$f":"IF(COUNTIF($K$18:$K$1017,J19)>0,\"Есть\",\"Нет\")","v":"Есть"}]
[3,4,"Архангельск",91,85030,7737730,"А",null,null,85030,19420,"Есть"]
[4,1,"Москва",6,17080,102480,"В",null,null,17080,18638,"Есть"]
[5,5,"Краснодар",26,64494,1676844,"Б",null,null,64494,57536,"Есть"]
[6,9,"Тюмень",65,88369,5743985,"А",null,null,88369,5799,"Нет"]
[7,6,"Владивосток",75,31965,2397375,"Б",null,null,31965,37998,"Есть"]
[8,9,"Тюмень",4,99825,399300,"В",null,null,99825,54695,"Есть"]
[9,8,"Новосибирск",6,70360,422160,"В",null,null,70360,63912,"Есть"]
[10,10,"Сочи",24,26226,629424,"В",null,null,26226,37905,"Есть"]
[11,7,"Мурманск",19,79777,1515763,"Б",null,null,79777,42872,"Есть"]
[12,7,"Мурманск",33,99983,3299439,"Б",null,null,99983,2396,"Есть"]
[13,8,"Новосибирск",66,59856,3950496,"Б",null,null,59856,61431,"Есть"]
[14,7,"Мурманск",36,13577,488772,"В",null,null,13577,25566,"Есть"]
[15,6,"Владивосток",43,76951,3308893,"Б",null,null,76951,96134,"Есть"]
[16,10,"Сочи",11,57536,632896,"В",null,null,57536,48370,"Есть"]
[17,10,"Сочи",5,67723,338615,"В",null,null,67723,67066,"Есть"]
[18,7,"Мурманск",26,76144,1979744,"Б",null,null,76144,43253,"Есть"]
[19,4,"Архангельск",72,51504,3708288,"Б",null,null,51504,63079,"Есть"]
[20,3,"Челябинск",46,67867,3121882,"Б",null,null,67867,36464,"Есть"]
[21,3,"Челябинск",54,61505,3321270,"Б",null,null,61505,22068,"Есть"]
[22,10,"Сочи",36,45225,1628100,"Б",null,null,45225,12696,"Есть"]
[23,4,"Архангельск",92,20725,1906700,"Б",null,null,20725,45475,"Есть"]
[24,3,"Челябинск",65,60550,3935750,"Б",null,null,60550,35148,"Есть"]
[25,5,"Краснодар",94,11164,1049416,"Б",null,null,11164,11141,"Есть"]
[26,4,"Архангельск",58,41872,2428576,"Б",null,null,41872,83318,"Есть"]
[27,8,"Новосибирск",30,23655,709650,"В",null,null,23655,99764,"Есть"]
[28,6,"Владивосток",60,97901,5874060,"А",null,null,97901,51527,"Есть"]
[29,1,"Москва",97,82442,7996874,"А",null,null,82442,97003,"Есть"]
[30,3,"Челябинск",100,94804,9480400,"А",null,null,94804,91631,"Есть"]
[31,7,"Мурманск",69,79322,5473218,"А",null,null,79322,12474,"Есть"]
[32,1,"Москва",72,5272,379584,"В",null,null,5272,81672,"Есть"]
[33,1,"Москва",4,62962,251848,"В",null,null,62962,63412,"Есть"]
[34,6,"Владивосток",77,80082,6166314,"А",null,null,80082,24302,"Есть"]
[35,6,"Владивосток",73,70724,5162852,"А",null,null,70724,62422,"Есть"]
[36,4,"Архангельск",86,16106,1385116,"Б",null,null,16106,68301,"Есть"]
[37,8,"Новосибирск",14,1093,15302,"В",null,null,1093,70601,"Есть"]
[38,4,"Архангельск",21,81535,1712235,"Б",null,null,81535,54781,"Есть"]
[39,10,"Сочи",49,49566,2428734,"Б",null,null,49566,54660,"Есть"]
[40,1,"Москва",60,55723,3343380,"Б",null,null,55723,7128,"Есть"]
[41,8,"Новосибирск",6,77563,465378,"В",null,null,77563,21593,"Есть"]
[42,1,"Москва",23,82926,1907298,"Б",null,null,82926,7039,"Есть"]
[43,9,"Тюмень",31,70746,2193126,"Б",null,null,70746,39542,"Есть"]
[44,8,"Новосибирск",79,39870,3149730,"Б",null,null,39870,23395,"Есть"]
[45,10,"Сочи",87,6807,592209,"В",null,null,6807,52042,"Есть"]
[46,4,"Архангельск",96,80879,7764384,"А",null,null,80879,46058,"Есть"]
[47,2,"Санкт-Петербург",83,51584,4281472,"Б",null,null,51584,25116,"Есть"]
[48,4,"Архангельск",26,99026,2574676,"Б",null,null,99026,37661,"Есть"]
[49,8,"Новосибирск",59,47089,2778251,"Б",null,null,47089,22509,"Есть"]
[50,7,"Мурманск",67,24543,1644381,"Б",null,null,24543,91372,"Есть"]
[51,9,"Тюмень",37,51809,1916933,"Б",null,null,51809,45443,"Есть"]
[52,10,"Сочи",89,35436,3153804,"Б",null,null,35436,38947,"Есть"]
[53,3,"Челябинск",15,55351,830265,"В",null,null,55351,32564,"Есть"]
[54,7,"Мурманск",85,77027,6547295,"А",null,null,77027,23802,"Есть"]
[55,8,"Новосибирск",48,83295,3998160,"Б",null,null,83295,77187,"Есть"]
[56,8,"Новосибирск",85,91918,7813030,"А",null,null,91918,71569,"Есть"]
[57,2,"Санкт-Петербург",61,51832,3161752,"Б",null,null,51832,25121,"Есть"]
[58,4,"Архангельск",65,10557,686205,"В",null,null,10557,47020,"Есть"]
[59,10,"Сочи",77,43544,3352888,"Б",null,null,43544,88597,"Есть"]
[60,3,"Челябинск",13,62405,811265,"В",null,null,62405,25559,"Есть"]
[61,1,"Москва",60,17417,1045020,"Б",null,null,17417,76028,"Есть"]
[62,1,"Москва",52,12408,645216,"В",null,null,12408,77797,"Есть"]
[63,7,"Мурманск",99,69919,6921981,"А",null,null,69919,5344,"Есть"]
[64,4,"Архангельск",27,11244,303588,"В",null,null,11244,96467,"Есть"]
[65,7,{"$f":"VLOOKUP(B82,$J$2:$L$12,2,0)","v":"Мурманск"},100,12755,1275500,{"$f":"IF(F82>5000000,\"А\",IF(F82<999999,\"В\",IF(AND(F82>999999,F82<5000000),\"Б\")))","v":"Б"},null,null,12755,48584,"Есть"]
[66,10,"Сочи",6,30573,{"$f":"D83*E83","v":183438},"В",null,null,30573,82466,{"$f":"IF(COUNTIF($K$18:$K$1017,J83)>0,\"Есть\",\"Нет\")","v":"Есть"}]
[67,3,"Челябинск",37,27631,1022347,"Б",null,null,27631,92497,"Есть"]
[68,7,"Мурманск",43,27241,1171363,"Б",null,null,27241,41371,"Есть"]
[69,6,"Владивосток",95,25116,2386020,"Б",null,null,25116,18076,"Есть"]
[70,6,"Владивосток",20,35183,703660,"В",null,null,35183,74104,"Есть"]
[71,4,"Архангельск",17,12470,211990,"В",null,null,12470,86816,"Есть"]
[72,7,"Мурманск",59,2459,145081,"В",null,null,2459,25288,"Есть"]
[73,7,"Мурманск",2,37998,75996,"В",null,null,37998,57917,"Есть"]
[74,8,"Новосибирск",59,7682,453238,"В",null,null,7682,78714,"Есть"]
[75,5,"Краснодар",54,86296,4659984,"Б",null,null,86296,70998,"Есть"]
[76,7,"Мурманск",14,29766,416724,"В",null,null,29766,4220,"Есть"]
[77,1,"Москва",63,26485,1668555,"Б",null,null,26485,1394,"Есть"]
[78,8,"Новосибирск",20,53748,1074960,"Б",null,null,53748,79322,"Есть"]
[79,8,"Новосибирск",58,37262,2161196,"Б",null,null,37262,97914,"Есть"]
[80,7,"Мурманск",59,33128,1954552,"Б",null,null,33128,6440,"Есть"]
[81,9,"Тюмень",82,76366,6262012,"А",null,null,76366,25500,"Есть"]
[82,8,"Новосибирск",28,45961,1286908,"Б",null,null,45961,37262,"Есть"]
[83,1,"Москва",67,55811,3739337,"Б",null,null,55811,10419,"Есть"]
[84,5,"Краснодар",60,16660,999600,"В",null,null,16660,44543,"Есть"]
[85,6,"Владивосток",16,32980,527680,"В",null,null,32980,70279,"Есть"]
[86,3,"Челябинск",42,83233,3495786,"Б",null,null,83233,39867,"Есть"]
[87,7,"Мурманск",6,49402,296412,"В",null,null,49402,11117,"Есть"]
[88,10,"Сочи",26,41422,1076972,"Б",null,null,41422,15970,"Есть"]
[89,1,"Москва",95,65839,6254705,"А",null,null,65839,91360,"Есть"]
[90,3,"Челябинск",100,83971,8397100,"А",null,null,83971,26745,"Есть"]
[91,7,"Мурманск",68,70998,4827864,"Б",null,null,70998,41173,"Есть"]
[92,4,"Архангельск",58,28965,1679970,"Б",null,null,28965,80853,"Есть"]
[93,3,"Челябинск",71,69979,4968509,"Б",null,null,69979,72722,"Есть"]
[94,2,"Санкт-Петербург",80,97003,7760240,"А",null,null,97003,59101,"Есть"]
[95,8,"Новосибирск",23,79297,1823831,"Б",null,null,79297,70726,"Есть"]
[96,4,"Архангельск",28,84626,2369528,"Б",null,null,84626,22513,"Есть"]
[97,4,"Архангельск",85,82070,6975950,"А",null,null,82070,11473,"Есть"]
[98,5,"Краснодар",93,43253,4022529,"Б",null,null,43253,51015,"Есть"]
[99,10,"Сочи",49,20720,1015280,"Б",null,null,20720,49627,"Есть"]
[100,8,"Новосибирск",80,53579,4286320,"Б",null,null,53579,86980,"Есть"]
[101,8,"Новосибирск",62,28281,1753422,"Б",null,null,28281,70148,"Есть"]
[102,9,"Тюмень",91,76157,6930287,"А",null,null,76157,37281,"Есть"]
[103,8,"Новосибирск",94,35148,3303912,"Б",null,null,35148,48404,"Есть"]
[104,3,"Челябинск",54,91631,4948074,"Б",null,null,91631,69979,"Есть"]
[105,9,"Тюмень",34,90883,3090022,"Б",null,null,90883,93470,"Есть"]
[106,9,"Тюмень",11,75839,834229,"В",null,null,75839,12420,"Есть"]
[107,2,"Санкт-Петербург",54,92395,4989330,"Б",null,null,92395,97901,"Есть"]
[108,4,"Архангельск",44,72763,3201572,"Б",null,null,72763,35122,"Есть"]
[109,9,"Тюмень",83,10609,880547,"В",null,null,10609,41337,"Есть"]
[110,2,"Санкт-Петербург",36,59029,2125044,"Б",null,null,59029,63770,"Нет"]
[111,7,"Мурманск",84,49455,4154220,"Б",null,null,49455,15961,"Есть"]
[112,6,"Владивосток",65,11437,743405,"В",null,null,11437,83756,"Есть"]
[113,8,"Новосибирск",14,96772,1354808,"Б",null,null,96772,87413,"Есть"]
[114,8,"Новосибирск",87,19740,1717380,"Б",null,null,19740,17486,"Есть"]
[115,8,"Новосибирск",29,29480,854920,"В",null,null,29480,65640,"Есть"]
[116,1,"Москва",63,14635,922005,"В",null,null,14635,72837,"Есть"]
[117,4,"Архангельск",45,84110,3784950,"Б",null,null,84110,1612,"Есть"]
[118,1,"Москва",34,91687,3117358,"Б",null,null,91687,77679,"Есть"]
[119,2,"Санкт-Петербург",82,33516,2748312,"Б",null,null,33516,12510,"Есть"]
[120,5,"Краснодар",39,60658,2365662,"Б",null,null,60658,31836,"Есть"]
[121,5,"Краснодар",35,93406,3269210,"Б",null,null,93406,5736,"Есть"]
[122,10,"Сочи",39,42456,1655784,"Б",null,null,42456,10922,"Есть"]
[123,2,"Санкт-Петербург",70,71985,5038950,"А",null,null,71985,28316,"Есть"]
[124,8,"Новосибирск",97,99673,9668281,"А",null,null,99673,46389,"Есть"]
[125,7,"Мурманск",23,32845,755435,"В",null,null,32845,83533,"Есть"]
[126,10,"Сочи",15,79432,1191480,"Б",null,null,79432,10628,"Есть"]
[127,2,"Санкт-Петербург",55,23922,1315710,"Б",null,null,23922,77729,"Есть"]
[128,7,"Мурманск",27,80011,2160297,"Б",null,null,80011,95757,"Есть"]
[129,6,{"$f":"VLOOKUP(B146,$J$2:$L$12,2,0)","v":"Владивосток"},99,14123,1398177,{"$f":"IF(F146>5000000,\"А\",IF(F146<999999,\"В\",IF(AND(F146>999999,F146<5000000),\"Б\")))","v":"Б"},null,null,14123,98214,"Есть"]
[130,8,"Новосибирск",18,96467,{"$f":"D147*E147","v":1736406},"Б",null,null,96467,43130,{"$f":"IF(COUNTIF($K$18:$K$1017,J147)>0,\"Есть\",\"Нет\")","v":"Есть"}]
[131,5,"Краснодар",76,15961,1213036,"Б",null,null,15961,75835,"Есть"]
[132,10,"Сочи",100,98214,9821400,"А",null,null,98214,45421,"Есть"]
[133,3,"Челябинск",3,1305,3915,"В",null,null,1305,31807,"Есть"]
[134,6,"Владивосток",62,34301,2126662,"Б",null,null,34301,42484,"Есть"]
[135,5,"Краснодар",97,34065,3304305,"Б",null,null,34065,45961,"Есть"]
[136,5,"Краснодар",99,78828,7803972,"А",null,null,78828,38588,"Есть"]
[137,8,"Новосибирск",43,78436,3372748,"Б",null,null,78436,76380,"Есть"]
[138,1,"Москва",57,67739,3861123,"Б",null,null,67739,26703,"Есть"]
[139,8,"Новосибирск",98,55013,5391274,"А",null,null,55013,57068,"Есть"]
[140,10,"Сочи",70,72955,5106850,"А",null,null,72955,3022,"Есть"]
[141,4,"Архангельск",38,48899,1858162,"Б",null,null,48899,90970,"Есть"]
[142,9,"Тюмень",70,25566,1789620,"Б",null,null,25566,64685,"Есть"]
[143,10,"Сочи",77,4631,356587,"В",null,null,4631,16938,"Есть"]
[144,4,"Архангельск",96,86547,8308512,"А",null,null,86547,55811,"Есть"]
[145,9,"Тюмень",95,49527,4705065,"Б",null,null,49527,28781,"Есть"]
[146,6,"Владивосток",22,23224,510928,"В",null,null,23224,43359,"Есть"]
[147,6,"Владивосток",87,37785,3287295,"Б",null,null,37785,79591,"Есть"]
[148,6,"Владивосток",1,32453,32453,"В",null,null,32453,23017,"Есть"]
[149,4,"Архангельск",96,1458,139968,"В",null,null,1458,23118,"Есть"]
[150,4,"Архангельск",91,31231,2842021,"Б",null,null,31231,67479,"Есть"]
[151,6,"Владивосток",91,51105,4650555,"Б",null,null,51105,27654,"Есть"]
[152,7,"Мурманск",78,4216,328848,"В",null,null,4216,63478,"Есть"]
[153,8,"Новосибирск",23,75751,1742273,"Б",null,null,75751,20742,"Есть"]
[154,2,"Санкт-Петербург",61,62357,3803777,"Б",null,null,62357,36324,"Есть"]
[155,4,"Архангельск",46,12474,573804,"В",null,null,12474,68145,"Есть"]
[156,6,"Владивосток",35,79623,2786805,"Б",null,null,79623,97883,"Есть"]
[157,3,"Челябинск",5,94737,473685,"В",null,null,94737,78281,"Есть"]
[158,7,"Мурманск",82,86538,7096116,"А",null,null,86538,92453,"Есть"]
[159,2,"Санкт-Петербург",12,18266,219192,"В",null,null,18266,83275,"Есть"]
[160,8,"Новосибирск",78,49994,3899532,"Б",null,null,49994,52782,"Есть"]
[161,7,"Мурманск",83,47134,3912122,"Б",null,null,47134,90396,"Есть"]
[162,7,"Мурманск",58,69557,4034306,"Б",null,null,69557,11956,"Есть"]
[163,5,"Краснодар",82,78323,6422486,"А",null,null,78323,16749,"Есть"]
[164,2,"Санкт-Петербург",6,65239,391434,"В",null,null,65239,6717,"Есть"]
[165,10,"Сочи",10,33908,339080,"В",null,null,33908,28122,"Есть"]
[166,8,"Новосибирск",61,36458,2223938,"Б",null,null,36458,3621,"Есть"]
[167,6,"Владивосток",40,24693,987720,"В",null,null,24693,42339,"Есть"]
[168,7,"Мурманск",46,16646,765716,"В",null,null,16646,28572,"Есть"]
[169,8,"Новосибирск",69,40877,2820513,"Б",null,null,40877,27033,"Есть"]
[170,3,"Челябинск",75,60727,4554525,"Б",null,null,60727,47372,"Есть"]
[171,8,"Новосибирск",49,39117,1916733,"Б",null,null,39117,42952,"Есть"]
[172,5,"Краснодар",95,33436,3176420,"Б",null,null,33436,43224,"Есть"]
[173,5,"Краснодар",20,33072,661440,"В",null,null,33072,34090,"Есть"]
[174,2,"Санкт-Петербург",53,80203,4250759,"Б",null,null,80203,66846,"Есть"]
[175,9,"Тюмень",52,17260,897520,"В",null,null,17260,66496,"Есть"]
[176,9,"Тюмень",5,14051,70255,"В",null,null,14051,1093,"Есть"]
[177,5,"Краснодар",67,73849,4947883,"Б",null,null,73849,41872,"Есть"]
[178,9,"Тюмень",11,34756,382316,"В",null,null,34756,14655,"Есть"]
[179,1,"Москва",7,46694,326858,"В",null,null,46694,29004,"Есть"]
[180,2,"Санкт-Петербург",77,73208,5637016,"А",null,null,73208,28908,"Есть"]
[181,5,"Краснодар",57,72746,4146522,"Б",null,null,72746,24808,"Есть"]
[182,4,"Архангельск",39,28712,1119768,"Б",null,null,28712,17249,"Есть"]
[183,9,"Тюмень",48,18638,894624,"В",null,null,18638,26226,"Есть"]
[184,3,"Челябинск",96,23693,2274528,"Б",null,null,23693,70360,"Есть"]
[185,3,"Челябинск",99,53092,5256108,"А",null,null,53092,17934,"Есть"]
[186,7,"Мурманск",45,23017,1035765,"Б",null,null,23017,11854,"Есть"]
[187,9,"Тюмень",64,56436,3611904,"Б",null,null,56436,62357,"Есть"]
[188,8,"Новосибирск",74,70908,5247192,"А",null,null,70908,32681,"Есть"]
[189,8,"Новосибирск",8,48370,386960,"В",null,null,48370,86296,"Есть"]
[190,6,"Владивосток",11,47165,518815,"В",null,null,47165,9531,"Есть"]
[191,8,"Новосибирск",9,77797,700173,"В",null,null,77797,10077,"Есть"]
[192,2,"Санкт-Петербург",33,47168,1556544,"Б",null,null,47168,83672,"Есть"]
[193,10,{"$f":"VLOOKUP(B210,$J$2:$L$12,2,0)","v":"Сочи"},77,23322,1795794,{"$f":"IF(F210>5000000,\"А\",IF(F210<999999,\"В\",IF(AND(F210>999999,F210<5000000),\"Б\")))","v":"Б"},null,null,23322,92356,"Есть"]
[194,10,"Сочи",91,39867,{"$f":"D211*E211","v":3627897},"Б",null,null,39867,31231,{"$f":"IF(COUNTIF($K$18:$K$1017,J211)>0,\"Есть\",\"Нет\")","v":"Есть"}]
[195,5,"Краснодар",33,74772,2467476,"Б",null,null,74772,93406,"Есть"]
[196,4,"Архангельск",3,56748,170244,"В",null,null,56748,24543,"Есть"]
[197,8,"Новосибирск",73,17809,1300057,"Б",null,null,17809,60222,"Есть"]
[198,10,"Сочи",16,11473,183568,"В",null,null,11473,47168,"Есть"]
[199,2,"Санкт-Петербург",40,22499,899960,"В",null,null,22499,19761,"Есть"]
[200,5,"Краснодар",48,56680,2720640,"Б",null,null,56680,76012,"Есть"]
[201,3,"Челябинск",54,18424,994896,"В",null,null,18424,79332,"Есть"]
[202,2,"Санкт-Петербург",43,33146,1425278,"Б",null,null,33146,62499,"Есть"]
[203,9,"Тюмень",75,10677,800775,"В",null,null,10677,10191,"Есть"]
[204,9,"Тюмень",24,56299,1351176,"Б",null,null,56299,77051,"Есть"]
[205,10,"Сочи",17,52847,898399,"В",null,null,52847,88112,"Есть"]
[206,3,"Челябинск",11,52782,580602,"В",null,null,52782,13281,"Есть"]
[207,5,"Краснодар",24,3808,91392,"В",null,null,3808,3644,"Есть"]
[208,4,"Архангельск",45,44543,2004435,"Б",null,null,44543,67723,"Есть"]
[209,2,"Санкт-Петербург",69,11956,824964,"В",null,null,11956,98822,"Есть"]
[210,4,"Архангельск",32,32681,1045792,"Б",null,null,32681,73537,"Есть"]
[211,10,"Сочи",55,22176,1219680,"Б",null,null,22176,71523,"Есть"]
[212,8,"Новосибирск",95,40994,3894430,"Б",null,null,40994,25994,"Есть"]
[213,8,"Новосибирск",20,90690,1813800,"Б",null,null,90690,50584,"Есть"]
[214,5,"Краснодар",8,12971,103768,"В",null,null,12971,73208,"Есть"]
[215,4,"Архангельск",70,50584,3540880,"Б",null,null,50584,65478,"Есть"]
[216,7,"Мурманск",46,72681,3343326,"Б",null,null,72681,98943,"Есть"]
[217,6,"Владивосток",3,65649,196947,"В",null,null,65649,22076,"Есть"]
[218,4,"Архангельск",68,1781,121108,"В",null,null,1781,39359,"Есть"]
[219,3,"Челябинск",89,70838,6304582,"А",null,null,70838,65212,"Нет"]
[220,4,"Архангельск",18,76623,1379214,"Б",null,null,76623,37283,"Есть"]
[221,3,"Челябинск",23,82466,1896718,"Б",null,null,82466,14123,"Есть"]
[222,10,"Сочи",30,88158,2644740,"Б",null,null,88158,90883,"Есть"]
[223,1,"Москва",62,19981,1238822,"Б",null,null,19981,34756,"Есть"]
[224,4,"Архангельск",47,25126,1180922,"Б",null,null,25126,94014,"Есть"]
[225,1,"Москва",23,81905,1883815,"Б",null,null,81905,13362,"Есть"]
[226,5,"Краснодар",95,84742,8050490,"А",null,null,84742,40877,"Есть"]
[227,2,"Санкт-Петербург",95,70279,6676505,"А",null,null,70279,88264,"Есть"]
[228,6,"Владивосток",91,75835,6900985,"А",null,null,75835,23249,"Есть"]
[229,6,"Владивосток",83,42726,3546258,"Б",null,null,42726,85626,"Есть"]
[230,3,"Челябинск",56,86189,4826584,"Б",null,null,86189,62961,"Есть"]
[231,6,"Владивосток",13,42952,558376,"В",null,null,42952,69933,"Есть"]
[232,4,"Архангельск",60,53521,3211260,"Б",null,null,53521,77676,"Есть"]
[233,7,"Мурманск",38,51296,1949248,"Б",null,null,51296,17809,"Есть"]
[234,5,"Краснодар",41,62341,2555981,"Б",null,null,62341,57935,"Есть"]
[235,8,"Новосибирск",40,34663,1386520,"Б",null,null,34663,61145,"Есть"]
[236,3,"Челябинск",58,45639,2647062,"Б",null,null,45639,19196,"Есть"]
[237,9,"Тюмень",22,98943,2176746,"Б",null,null,98943,48676,"Есть"]
[238,5,"Краснодар",73,70148,5120804,"А",null,null,70148,72457,"Есть"]
[239,10,"Сочи",11,78747,866217,"В",null,null,78747,83322,"Есть"]
[240,5,"Краснодар",70,32617,2283190,"Б",null,null,32617,17195,"Есть"]
[241,2,"Санкт-Петербург",43,3068,131924,"В",null,null,3068,19981,"Есть"]
[242,10,"Сочи",64,94342,6037888,"А",null,null,94342,26605,"Нет"]
[243,9,"Тюмень",97,29200,2832400,"Б",null,null,29200,72613,"Есть"]
[244,5,"Краснодар",56,37905,2122680,"Б",null,null,37905,46057,"Есть"]
[245,10,"Сочи",75,46009,3450675,"Б",null,null,46009,86547,"Есть"]
[246,9,"Тюмень",26,11854,308204,"В",null,null,11854,99083,"Есть"]
[247,2,"Санкт-Петербург",71,63412,4502252,"Б",null,null,63412,44211,"Есть"]
[248,4,"Архангельск",82,5774,473468,"В",null,null,5774,53203,"Есть"]
[249,1,"Москва",76,54641,4152716,"Б",null,null,54641,32617,"Есть"]
[250,9,"Тюмень",8,75992,607936,"В",null,null,75992,46025,"Есть"]
[251,3,"Челябинск",87,21648,1883376,"Б",null,null,21648,53078,"Есть"]
[252,5,"Краснодар",69,99861,6890409,"А",null,null,99861,95014,"Нет"]
[253,6,"Владивосток",40,88742,3549680,"Б",null,null,88742,17977,"Есть"]
[254,1,"Москва",67,39359,2637053,"Б",null,null,39359,68551,"Есть"]
[255,5,"Краснодар",86,58290,5012940,"А",null,null,58290,29391,"Есть"]
[256,1,"Москва",71,36464,2588944,"Б",null,null,36464,7659,"Есть"]
[257,2,{"$f":"VLOOKUP(B274,$J$2:$L$12,2,0)","v":"Санкт-Петербург"},60,65102,3906120,{"$f":"IF(F274>5000000,\"А\",IF(F274<999999,\"В\",IF(AND(F274>999999,F274<5000000),\"Б\")))","v":"Б"},null,null,65102,19089,"Есть"]
[258,10,"Сочи",49,83524,{"$f":"D275*E275","v":4092676},"Б",null,null,83524,44551,{"$f":"IF(COUNTIF($K$18:$K$1017,J275)>0,\"Есть\",\"Нет\")","v":"Есть"}]
[259,3,"Челябинск",33,30812,1016796,"Б",null,null,30812,62859,"Есть"]
[260,10,"Сочи",76,26593,2021068,"Б",null,null,26593,51741,"Есть"]
[261,4,"Архангельск",31,99379,3080749,"Б",null,null,99379,35527,"Есть"]
[262,1,"Москва",8,90449,723592,"В",null,null,90449,32693,"Есть"]
[263,8,"Новосибирск",72,2521,181512,"В",null,null,2521,2459,"Есть"]
[264,9,"Тюмень",33,59765,1972245,"Б",null,null,59765,31783,"Есть"]
[265,5,"Краснодар",61,80712,4923432,"Б",null,null,80712,72832,"Нет"]
[266,2,"Санкт-Петербург",44,27654,1216776,"Б",null,null,27654,18266,"Есть"]
[267,1,"Москва",11,77042,847462,"В",null,null,77042,58405,"Есть"]
[268,6,"Владивосток",2,4549,9098,"В",null,null,4549,3695,"Есть"]
[269,1,"Москва",24,63079,1513896,"Б",null,null,63079,82029,"Есть"]
[270,2,"Санкт-Петербург",67,61145,4096715,"Б",null,null,61145,17260,"Есть"]
[271,5,"Краснодар",26,59544,1548144,"Б",null,null,59544,26199,"Есть"]
[272,8,"Новосибирск",32,30866,987712,"В",null,null,30866,23693,"Есть"]
[273,10,"Сочи",29,87405,2534745,"Б",null,null,87405,44623,"Есть"]
[274,5,"Краснодар",85,99083,8422055,"А",null,null,99083,56436,"Есть"]
[275,6,"Владивосток",98,33735,3306030,"Б",null,null,33735,86368,"Есть"]
[276,3,"Челябинск",65,67035,4357275,"Б",null,null,67035,4549,"Есть"]
[277,10,"Сочи",12,28423,341076,"В",null,null,28423,20725,"Есть"]
[278,9,"Тюмень",19,53203,1010857,"Б",null,null,53203,62973,"Есть"]
[279,4,"Архангельск",68,72590,4936120,"Б",null,null,72590,7831,"Есть"]
[280,1,"Москва",56,73567,4119752,"Б",null,null,73567,27612,"Есть"]
[281,10,"Сочи",59,60286,3556874,"Б",null,null,60286,75406,"Есть"]
[282,2,"Санкт-Петербург",45,25994,1169730,"Б",null,null,25994,55351,"Есть"]
[283,6,"Владивосток",22,72837,1602414,"Б",null,null,72837,98929,"Есть"]
[284,1,"Москва",31,44716,1386196,"Б",null,null,44716,22184,"Есть"]
[285,6,"Владивосток",50,57917,2895850,"Б",null,null,57917,53092,"Есть"]
[286,3,"Челябинск",50,27612,1380600,"Б",null,null,27612,92407,"Есть"]
[287,9,"Тюмень",97,10191,988527,"В",null,null,10191,79485,"Есть"]
[288,6,"Владивосток",60,34773,2086380,"Б",null,null,34773,56680,"Есть"]
[289,8,"Новосибирск",30,13131,393930,"В",null,null,13131,60658,"Есть"]
[290,2,"Санкт-Петербург",31,14558,451298,"В",null,null,14558,40896,"Есть"]
[291,4,"Архангельск",13,21339,277407,"В",null,null,21339,2847,"Есть"]
[292,6,"Владивосток",60,11117,667020,"В",null,null,11117,5065,"Есть"]
[293,10,"Сочи",6,79485,476910,"В",null,null,79485,59783,"Есть"]
[294,6,"Владивосток",1,52097,52097,"В",null,null,52097,6807,"Есть"]
[295,1,"Москва",36,15675,564300,"В",null,null,15675,84334,"Есть"]
[296,6,"Владивосток",21,29004,609084,"В",null,null,29004,92360,"Есть"]
[297,9,"Тюмень",64,47890,3064960,"Б",null,null,47890,17080,"Есть"]
[298,9,"Тюмень",32,6429,205728,"В",null,null,6429,32845,"Есть"]
[299,5,"Краснодар",53,4781,253393,"В",null,null,4781,51296,"Есть"]
[300,10,"Сочи",57,35122,2001954,"Б",null,null,35122,19740,"Есть"]
[301,5,"Краснодар",15,34973,524595,"В",null,null,34973,53521,"Есть"]
[302,5,"Краснодар",21,53616,1125936,"Б",null,null,53616,99733,"Есть"]
[303,1,"Москва",86,60667,5217362,"А",null,null,60667,74649,"Есть"]
[304,7,"Мурманск",86,91885,7902110,"А",null,null,91885,84409,"Есть"]
[305,1,"Москва",68,8182,556376,"В",null,null,8182,88876,"Есть"]
[306,6,"Владивосток",72,25246,1817712,"Б",null,null,25246,36500,"Есть"]
[307,6,"Владивосток",24,1748,41952,"В",null,null,1748,82113,"Есть"]
[308,3,"Челябинск",24,32476,779424,"В",null,null,32476,1458,"Есть"]
[309,9,"Тюмень",24,28651,687624,"В",null,null,28651,8182,"Есть"]
[310,8,"Новосибирск",18,65862,1185516,"Б",null,null,65862,53983,"Есть"]
[311,2,"Санкт-Петербург",76,93587,7112612,"А",null,null,93587,51361,"Есть"]
[312,2,"Санкт-Петербург",21,31651,664671,"В",null,null,31651,88158,"Есть"]
[313,9,"Тюмень",93,23802,2213586,"Б",null,null,23802,92050,"Есть"]
[314,8,"Новосибирск",55,28130,1547150,"Б",null,null,28130,82442,"Есть"]
[315,7,"Мурманск",61,91372,5573692,"А",null,null,91372,1226,"Есть"]
[316,3,"Челябинск",6,13281,79686,"В",null,null,13281,60918,"Есть"]
[317,3,"Челябинск",44,79711,3507284,"Б",null,null,79711,59765,"Есть"]
[318,9,"Тюмень",7,80762,565334,"В",null,null,80762,83680,"Есть"]
[319,6,"Владивосток",10,89154,891540,"В",null,null,89154,83208,"Есть"]
[320,6,"Владивосток",66,72650,4794900,"Б",null,null,72650,96856,"Есть"]
[321,4,{"$f":"VLOOKUP(B338,$J$2:$L$12,2,0)","v":"Архангельск"},73,65212,4760476,{"$f":"IF(F338>5000000,\"А\",IF(F338<999999,\"В\",IF(AND(F338>999999,F338<5000000),\"Б\")))","v":"Б"},null,null,65212,3180,"Есть"]
[322,9,"Тюмень",18,54188,{"$f":"D339*E339","v":975384},"В",null,null,54188,77027,{"$f":"IF(COUNTIF($K$18:$K$1017,J339)>0,\"Есть\",\"Нет\")","v":"Есть"}]
[323,2,"Санкт-Петербург",1,7831,7831,"В",null,null,7831,58106,"Есть"]
[324,3,"Челябинск",46,32500,1495000,"Б",null,null,32500,38466,"Есть"]
[325,4,"Архангельск",1,72763,72763,"В",null,null,72763,37410,"Есть"]
[326,2,"Санкт-Петербург",62,97978,6074636,"А",null,null,97978,51832,"Есть"]
[327,5,"Краснодар",18,97883,1761894,"Б",null,null,97883,38222,"Есть"]
[328,10,"Сочи",77,13833,1065141,"Б",null,null,13833,66372,"Есть"]
[329,6,"Владивосток",88,92050,8100400,"А",null,null,92050,27046,"Есть"]
[330,5,"Краснодар",83,76012,6308996,"А",null,null,76012,89999,"Есть"]
[331,6,"Владивосток",31,80853,2506443,"Б",null,null,80853,82345,"Есть"]
[332,4,"Архангельск",28,41454,1160712,"Б",null,null,41454,40622,"Есть"]
[333,10,"Сочи",85,5344,454240,"В",null,null,5344,10609,"Есть"]
[334,8,"Новосибирск",63,75406,4750578,"Б",null,null,75406,27885,"Есть"]
[335,2,"Санкт-Петербург",7,97586,683102,"В",null,null,97586,12241,"Есть"]
[336,9,"Тюмень",83,70267,5832161,"А",null,null,70267,29451,"Есть"]
[337,7,"Мурманск",1,3621,3621,"В",null,null,3621,54732,"Есть"]
[338,1,"Москва",4,49178,196712,"В",null,null,49178,84626,"Есть"]
[339,6,"Владивосток",40,97210,3888400,"Б",null,null,97210,10557,"Есть"]
[340,5,"Краснодар",37,36324,1343988,"Б",null,null,36324,72763,"Есть"]
[341,5,"Краснодар",99,37410,3703590,"Б",null,null,37410,12139,"Есть"]
[342,8,"Новосибирск",49,77676,3806124,"Б",null,null,77676,11164,"Есть"]
[343,8,"Новосибирск",11,42872,471592,"В",null,null,42872,15238,"Есть"]
[344,3,"Челябинск",32,31623,1011936,"Б",null,null,31623,30124,"Есть"]
[345,1,"Москва",17,84409,1434953,"Б",null,null,84409,24605,"Есть"]
[346,7,"Мурманск",16,60745,971920,"В",null,null,60745,82426,"Есть"]
[347,4,"Архангельск",70,43222,3025540,"Б",null,null,43222,2898,"Есть"]
[348,10,"Сочи",99,8651,856449,"В",null,null,8651,49527,"Есть"]
[349,6,"Владивосток",12,45840,550080,"В",null,null,45840,81535,"Есть"]
[350,10,"Сочи",66,28652,1891032,"Б",null,null,28652,90449,"Есть"]
[351,8,"Новосибирск",42,13646,573132,"В",null,null,13646,82357,"Есть"]
[352,6,"Владивосток",42,4685,196770,"В",null,null,4685,99379,"Есть"]
[353,3,"Челябинск",30,63564,1906920,"Б",null,null,63564,17629,"Есть"]
[354,9,"Тюмень",89,81758,7276462,"А",null,null,81758,29371,"Есть"]
[355,4,"Архангельск",62,55255,3425810,"Б",null,null,55255,76951,"Есть"]
[356,2,"Санкт-Петербург",37,93836,3471932,"Б",null,null,93836,84751,"Есть"]
[357,4,"Архангельск",5,69933,349665,"В",null,null,69933,44930,"Есть"]
[358,10,"Сочи",20,57935,1158700,"Б",null,null,57935,9583,"Есть"]
[359,3,"Челябинск",34,66613,2264842,"Б",null,null,66613,29180,"Есть"]
[360,7,"Мурманск",54,66846,3609684,"Б",null,null,66846,76623,"Есть"]
[361,7,"Мурманск",73,55409,4044857,"Б",null,null,55409,6849,"Есть"]
[362,6,"Владивосток",75,16744,1255800,"Б",null,null,16744,61792,"Есть"]
[363,10,"Сочи",11,73224,805464,"В",null,null,73224,23303,"Есть"]
[364,9,"Тюмень",18,26636,479448,"В",null,null,26636,88918,"Есть"]
[365,4,"Архангельск",24,63912,1533888,"Б",null,null,63912,23322,"Есть"]
[366,3,"Челябинск",21,55357,1162497,"Б",null,null,55357,8651,"Есть"]
[367,7,"Мурманск",3,86770,260310,"В",null,null,86770,66739,"Есть"]
[368,8,"Новосибирск",77,18605,1432585,"Б",null,null,18605,45639,"Есть"]
[369,4,"Архангельск",67,14940,1000980,"Б",null,null,14940,24015,"Есть"]
[370,8,"Новосибирск",59,50220,2962980,"Б",null,null,50220,84248,"Есть"]
[371,4,"Архангельск",13,88089,1145157,"Б",null,null,88089,66446,"Есть"]
[372,9,"Тюмень",7,81672,571704,"В",null,null,81672,11812,"Есть"]
[373,7,"Мурманск",29,45421,1317209,"Б",null,null,45421,16402,"Есть"]
[374,3,"Челябинск",41,17486,716926,"В",null,null,17486,56059,"Есть"]
[375,3,"Челябинск",89,34913,3107257,"Б",null,null,34913,12501,"Есть"]
[376,9,"Тюмень",39,27075,1055925,"Б",null,null,27075,17643,"Есть"]
[377,1,"Москва",73,84326,6155798,"А",null,null,84326,82911,"Есть"]
[378,6,"Владивосток",8,3180,25440,"В",null,null,3180,33385,"Есть"]
[379,4,"Архангельск",13,92356,1200628,"Б",null,null,92356,70724,"Есть"]
[380,3,"Челябинск",11,33920,373120,"В",null,null,33920,35183,"Есть"]
[381,2,"Санкт-Петербург",45,46025,2071125,"Б",null,null,46025,72955,"Есть"]
[382,10,"Сочи",56,97126,5439056,"А",null,null,97126,21033,"Есть"]
[383,5,"Краснодар",7,96138,672966,"В",null,null,96138,38051,"Есть"]
[384,1,"Москва",42,81475,3421950,"Б",null,null,81475,27260,"Есть"]
[385,9,{"$f":"VLOOKUP(B402,$J$2:$L$12,2,0)","v":"Тюмень"},41,48404,1984564,{"$f":"IF(F402>5000000,\"А\",IF(F402<999999,\"В\",IF(AND(F402>999999,F402<5000000),\"Б\")))","v":"Б"},null,null,48404,51013,"Есть"]
[386,9,"Тюмень",23,75609,{"$f":"D403*E403","v":1739007},"Б",null,null,75609,14558,{"$f":"IF(COUNTIF($K$18:$K$1017,J403)>0,\"Есть\",\"Нет\")","v":"Есть"}]
[387,6,"Владивосток",62,30580,1895960,"Б",null,null,30580,63633,"Есть"]
[388,3,"Челябинск",36,99219,3571884,"Б",null,null,99219,42635,"Есть"]
[389,10,"Сочи",9,61713,555417,"В",null,null,61713,3068,"Есть"]
[390,5,"Краснодар",3,58811,176433,"В",null,null,58811,33133,"Есть"]
[391,5,"Краснодар",1,36333,36333,"В",null,null,36333,85180,"Есть"]
[392,1,"Москва",6,42635,255810,"В",null,null,42635,73224,"Есть"]
[393,9,"Тюмень",60,77187,4631220,"Б",null,null,77187,63282,"Есть"]
[394,2,"Санкт-Петербург",87,4971,432477,"В",null,null,4971,12408,"Есть"]
[395,6,"Владивосток",59,46863,2764917,"Б",null,null,46863,14323,"Есть"]
[396,6,"Владивосток",29,92764,2690156,"Б",null,null,92764,23897,"Есть"]
[397,8,"Новосибирск",23,3394,78062,"В",null,null,3394,99851,"Есть"]
[398,4,"Архангельск",24,21313,511512,"В",null,null,21313,23917,"Есть"]
[399,9,"Тюмень",92,43686,4019112,"Б",null,null,43686,76165,"Есть"]
[400,10,"Сочи",21,88495,1858395,"Б",null,null,88495,88495,"Есть"]
[401,5,"Краснодар",8,82357,658856,"В",null,null,82357,86189,"Есть"]
[402,5,"Краснодар",15,6717,100755,"В",null,null,6717,38822,"Есть"]
[403,4,"Архангельск",7,39352,275464,"В",null,null,39352,54637,"Есть"]
[404,5,"Краснодар",36,72613,2614068,"Б",null,null,72613,52097,"Есть"]
[405,3,"Челябинск",5,43401,217005,"В",null,null,43401,22022,"Есть"]
[406,5,"Краснодар",22,12139,267058,"В",null,null,12139,4216,"Есть"]
[407,9,"Тюмень",24,85180,2044320,"Б",null,null,85180,10902,"Есть"]
[408,5,"Краснодар",98,70601,6918898,"А",null,null,70601,33072,"Есть"]
[409,2,"Санкт-Петербург",2,63770,127540,"В",null,null,63770,50229,"Есть"]
[410,3,"Челябинск",8,31783,254264,"В",null,null,31783,15525,"Есть"]
[411,2,"Санкт-Петербург",58,6742,391036,"В",null,null,6742,65862,"Есть"]
[412,3,"Челябинск",47,92181,4332507,"Б",null,null,92181,38670,"Есть"]
[413,3,"Челябинск",33,70985,2342505,"Б",null,null,70985,60667,"Есть"]
[414,2,"Санкт-Петербург",4,17026,68104,"В",null,null,17026,57779,"Есть"]
[415,10,"Сочи",22,55097,1212134,"Б",null,null,55097,34383,"Есть"]
[416,6,"Владивосток",19,58612,1113628,"Б",null,null,58612,28965,"Есть"]
[417,6,"Владивосток",47,59952,2817744,"Б",null,null,59952,34300,"Есть"]
[418,9,"Тюмень",96,14088,1352448,"Б",null,null,14088,56175,"Есть"]
[419,4,"Архангельск",67,97775,6550925,"А",null,null,97775,97771,"Есть"]
[420,7,"Мурманск",47,51741,2431827,"Б",null,null,51741,84572,"Есть"]
[421,10,"Сочи",3,38822,116466,"В",null,null,38822,87690,"Есть"]
[422,8,"Новосибирск",39,29451,1148589,"Б",null,null,29451,34939,"Есть"]
[423,5,"Краснодар",34,22513,765442,"В",null,null,22513,11244,"Есть"]
[424,8,"Новосибирск",85,92796,7887660,"А",null,null,92796,70746,"Есть"]
[425,3,"Челябинск",90,98603,8874270,"А",null,null,98603,15754,"Есть"]
[426,10,"Сочи",95,19035,1808325,"Б",null,null,19035,33436,"Есть"]
[427,8,"Новосибирск",41,66739,2736299,"Б",null,null,66739,32476,"Есть"]
[428,4,"Архангельск",65,44930,2920450,"Б",null,null,44930,80465,"Есть"]
[429,10,"Сочи",73,12510,913230,"В",null,null,12510,49091,"Есть"]
[430,3,"Челябинск",100,1119,111900,"В",null,null,1119,43438,"Есть"]
[431,9,"Тюмень",87,82805,7204035,"А",null,null,82805,82070,"Есть"]
[432,10,"Сочи",68,35527,2415836,"Б",null,null,35527,5272,"Есть"]
[433,4,"Архангельск",64,48091,3077824,"Б",null,null,48091,92290,"Есть"]
[434,9,"Тюмень",51,95014,4845714,"Б",null,null,95014,49455,"Есть"]
[435,5,"Краснодар",88,15970,1405360,"Б",null,null,15970,87285,"Есть"]
[436,4,"Архангельск",29,12241,354989,"В",null,null,12241,95452,"Есть"]
[437,4,"Архангельск",16,22068,353088,"В",null,null,22068,92631,"Есть"]
[438,8,"Новосибирск",20,89477,1789540,"Б",null,null,89477,79297,"Есть"]
[439,7,"Мурманск",33,11141,367653,"В",null,null,11141,21648,"Есть"]
[440,7,"Мурманск",61,16794,1024434,"Б",null,null,16794,99219,"Есть"]
[441,8,"Новосибирск",43,62961,2707323,"Б",null,null,62961,56383,"Есть"]
[442,5,"Краснодар",94,25895,2434130,"Б",null,null,25895,95945,"Есть"]
[443,5,"Краснодар",68,49350,3355800,"Б",null,null,49350,52998,"Есть"]
[444,9,"Тюмень",9,87526,787734,"В",null,null,87526,88909,"Есть"]
[445,6,"Владивосток",68,12437,845716,"В",null,null,12437,63271,"Есть"]
[446,8,"Новосибирск",39,14199,553761,"В",null,null,14199,62962,"Есть"]
[447,3,"Челябинск",2,4991,9982,"В",null,null,4991,13508,"Есть"]
[448,7,"Мурманск",26,87690,2279940,"Б",null,null,87690,76144,"Есть"]
[449,8,{"$f":"VLOOKUP(B466,$J$2:$L$12,2,0)","v":"Новосибирск"},89,39426,3508914,{"$f":"IF(F466>5000000,\"А\",IF(F466<999999,\"В\",IF(AND(F466>999999,F466<5000000),\"Б\")))","v":"Б"},null,null,39426,46934,"Есть"]
[450,5,"Краснодар",88,73537,{"$f":"D467*E467","v":6471256},"А",null,null,73537,59856,{"$f":"IF(COUNTIF($K$18:$K$1017,J467)>0,\"Есть\",\"Нет\")","v":"Есть"}]
[451,6,"Владивосток",41,24808,1017128,"Б",null,null,24808,58290,"Есть"]
[452,4,"Архангельск",72,53498,3851856,"Б",null,null,53498,83871,"Есть"]
[453,4,"Архангельск",79,90979,7187341,"А",null,null,90979,49350,"Есть"]
[454,2,"Санкт-Петербург",56,96698,5415088,"А",null,null,96698,40600,"Есть"]
[455,2,"Санкт-Петербург",48,40622,1949856,"Б",null,null,40622,78747,"Есть"]
[456,4,"Архангельск",45,71921,3236445,"Б",null,null,71921,19247,"Есть"]
[457,6,"Владивосток",3,60874,182622,"В",null,null,60874,93571,"Есть"]
[458,7,"Мурманск",78,37281,2907918,"Б",null,null,37281,1412,"Есть"]
[459,4,"Архангельск",22,98822,2174084,"Б",null,null,98822,72763,"Есть"]
[460,3,"Челябинск",29,84230,2442670,"Б",null,null,84230,51105,"Есть"]
[461,9,"Тюмень",65,81979,5328635,"А",null,null,81979,98603,"Есть"]
[462,3,"Челябинск",76,22619,1719044,"Б",null,null,22619,13851,"Есть"]
[463,9,"Тюмень",5,21593,107965,"В",null,null,21593,66703,"Есть"]
[464,4,"Архангельск",72,11298,813456,"В",null,null,11298,68892,"Есть"]
[465,6,"Владивосток",76,51361,3903436,"Б",null,null,51361,11060,"Есть"]
[466,9,"Тюмень",44,95452,4199888,"Б",null,null,95452,47165,"Есть"]
[467,2,"Санкт-Петербург",22,82911,1824042,"Б",null,null,82911,63564,"Есть"]
[468,6,"Владивосток",88,2650,233200,"В",null,null,2650,1119,"Есть"]
[469,9,"Тюмень",54,71144,3841776,"Б",null,null,71144,29200,"Есть"]
[470,3,"Челябинск",63,79344,4998672,"Б",null,null,79344,15436,"Есть"]
[471,9,"Тюмень",32,26265,840480,"В",null,null,26265,31435,"Есть"]
[472,10,"Сочи",81,17249,1397169,"Б",null,null,17249,27075,"Есть"]
[473,5,"Краснодар",38,23118,878484,"В",null,null,23118,23051,"Есть"]
[474,2,"Санкт-Петербург",45,62860,2828700,"Б",null,null,62860,98691,"Есть"]
[475,10,"Сочи",10,87149,871490,"В",null,null,87149,94051,"Есть"]
[476,2,"Санкт-Петербург",1,23051,23051,"В",null,null,23051,18691,"Есть"]
[477,1,"Москва",39,59101,2304939,"Б",null,null,59101,48780,"Есть"]
[478,2,"Санкт-Петербург",89,17486,1556254,"Б",null,null,17486,33735,"Есть"]
[479,7,"Мурманск",62,60292,3738104,"Б",null,null,60292,86538,"Есть"]
[480,9,"Тюмень",15,23303,349545,"В",null,null,23303,42979,"Есть"]
[481,10,"Сочи",7,27046,189322,"В",null,null,27046,1405,"Есть"]
[482,5,"Краснодар",76,34300,2606800,"Б",null,null,34300,65478,"Есть"]
[483,7,"Мурманск",52,74649,3881748,"Б",null,null,74649,70267,"Есть"]
[484,4,"Архангельск",15,8583,128745,"В",null,null,8583,60745,"Есть"]
[485,1,"Москва",27,10902,294354,"В",null,null,10902,24693,"Есть"]
[486,1,"Москва",83,90396,7502868,"А",null,null,90396,99673,"Есть"]
[487,9,"Тюмень",60,7128,427680,"В",null,null,7128,5725,"Есть"]
[488,3,"Челябинск",38,32603,1238914,"Б",null,null,32603,30866,"Есть"]
[489,10,"Сочи",40,4220,168800,"В",null,null,4220,4781,"Есть"]
[490,1,"Москва",16,38051,608816,"В",null,null,38051,47089,"Есть"]
[491,10,"Сочи",67,10077,675159,"В",null,null,10077,95732,"Есть"]
[492,5,"Краснодар",24,15754,378096,"В",null,null,15754,17012,"Есть"]
[493,4,"Архангельск",89,4518,402102,"В",null,null,4518,39870,"Есть"]
[494,6,"Владивосток",81,14655,1187055,"Б",null,null,14655,26989,"Есть"]
[495,10,"Сочи",62,73522,4558364,"Б",null,null,73522,29973,"Есть"]
[496,6,"Владивосток",86,68402,5882572,"А",null,null,68402,2693,"Есть"]
[497,4,"Архангельск",85,33385,2837725,"Б",null,null,33385,21599,"Есть"]
[498,1,"Москва",72,85376,6147072,"А",null,null,85376,61999,"Есть"]
[499,2,"Санкт-Петербург",75,8143,610725,"В",null,null,8143,65239,"Есть"]
[500,2,"Санкт-Петербург",16,46934,750944,"В",null,null,46934,77027,"Есть"]
[501,5,"Краснодар",9,82345,741105,"В",null,null,82345,97126,"Есть"]
[502,4,"Архангельск",80,9583,766640,"В",null,null,9583,51940,"Есть"]
[503,6,"Владивосток",35,47020,1645700,"Б",null,null,47020,49402,"Есть"]
[504,9,"Тюмень",11,25559,281149,"В",null,null,25559,91918,"Есть"]
[505,5,"Краснодар",27,83459,2253393,"Б",null,null,83459,77136,"Есть"]
[506,9,"Тюмень",38,22022,836836,"В",null,null,22022,46953,"Есть"]
[507,4,"Архангельск",50,86106,4305300,"Б",null,null,86106,10937,"Есть"]
[508,2,"Санкт-Петербург",25,99851,2496275,"Б",null,null,99851,53498,"Есть"]
[509,6,"Владивосток",38,3695,140410,"В",null,null,3695,54188,"Есть"]
[510,6,"Владивосток",81,54732,4433292,"Б",null,null,54732,40734,"Есть"]
[511,3,"Челябинск",19,38466,730854,"В",null,null,38466,48091,"Есть"]
[512,7,"Мурманск",41,17044,698804,"В",null,null,17044,70537,"Есть"]
[513,6,{"$f":"VLOOKUP(B530,$J$2:$L$12,2,0)","v":"Владивосток"},41,63030,2584230,{"$f":"IF(F530>5000000,\"А\",IF(F530<999999,\"В\",IF(AND(F530>999999,F530<5000000),\"Б\")))","v":"Б"},null,null,63030,72650,"Есть"]
[514,7,"Мурманск",39,72722,{"$f":"D531*E531","v":2836158},"Б",null,null,72722,28652,{"$f":"IF(COUNTIF($K$18:$K$1017,J531)>0,\"Есть\",\"Нет\")","v":"Есть"}]
[515,5,"Краснодар",64,15266,977024,"В",null,null,15266,1781,"Есть"]
[516,8,"Новосибирск",79,19089,1508031,"Б",null,null,19089,76157,"Есть"]
[517,9,"Тюмень",37,86310,3193470,"Б",null,null,86310,15266,"Есть"]
[518,7,"Мурманск",46,38388,1765848,"Б",null,null,38388,13833,"Есть"]
[519,7,"Мурманск",84,36500,3066000,"Б",null,null,36500,85030,"Есть"]
[520,1,"Москва",19,27439,521341,"В",null,null,27439,74772,"Есть"]
[521,9,"Тюмень",42,67861,2850162,"Б",null,null,67861,29461,"Есть"]
[522,1,"Москва",84,98691,8290044,"А",null,null,98691,94953,"Есть"]
[523,3,"Челябинск",42,63478,2666076,"Б",null,null,63478,10020,"Есть"]
[524,9,"Тюмень",53,40600,2151800,"Б",null,null,40600,83233,"Есть"]
[525,5,"Краснодар",35,67848,2374680,"Б",null,null,67848,3138,"Есть"]
[526,6,"Владивосток",43,5072,218096,"В",null,null,5072,18354,"Есть"]
[527,4,"Архангельск",73,56059,4092307,"Б",null,null,56059,58811,"Есть"]
[528,2,"Санкт-Петербург",62,61431,3808722,"Б",null,null,61431,63030,"Есть"]
[529,3,"Челябинск",31,34383,1065873,"Б",null,null,34383,3205,"Есть"]
[530,5,"Краснодар",14,43130,603820,"В",null,null,43130,46009,"Есть"]
[531,1,"Москва",13,54637,710281,"В",null,null,54637,75609,"Есть"]
[532,1,"Москва",16,49187,786992,"В",null,null,49187,11178,"Есть"]
[533,3,"Челябинск",72,46389,3340008,"Б",null,null,46389,72508,"Есть"]
[534,3,"Челябинск",98,7039,689822,"В",null,null,7039,35436,"Есть"]
[535,10,"Сочи",59,88876,5243684,"А",null,null,88876,22807,"Есть"]
[536,10,"Сочи",5,94318,471590,"В",null,null,94318,77856,"Есть"]
[537,3,"Челябинск",51,86204,4396404,"Б",null,null,86204,28712,"Есть"]
[538,6,"Владивосток",52,79725,4145700,"Б",null,null,79725,28800,"Есть"]
[539,3,"Челябинск",53,12190,646070,"В",null,null,12190,5072,"Есть"]
[540,10,"Сочи",84,24015,2017260,"Б",null,null,24015,61505,"Есть"]
[541,2,"Санкт-Петербург",54,34939,1886706,"Б",null,null,34939,46596,"Есть"]
[542,3,"Челябинск",45,54781,2465145,"Б",null,null,54781,87526,"Есть"]
[543,3,"Челябинск",88,53983,4750504,"Б",null,null,53983,15951,"Есть"]
[544,7,"Мурманск",55,22509,1237995,"Б",null,null,22509,33128,"Есть"]
[545,9,"Тюмень",33,88597,2923701,"Б",null,null,88597,51504,"Есть"]
[546,9,"Тюмень",55,68145,3747975,"Б",null,null,68145,74164,"Есть"]
[547,6,"Владивосток",43,10628,457004,"В",null,null,10628,31187,"Есть"]
[548,5,"Краснодар",67,88112,5903504,"А",null,null,88112,60727,"Есть"]
[549,8,"Новосибирск",100,10922,1092200,"Б",null,null,10922,12437,"Есть"]
[550,3,"Челябинск",76,67519,5131444,"А",null,null,67519,14940,"Есть"]
[551,8,"Новосибирск",36,45207,1627452,"Б",null,null,45207,23316,"Есть"]
[552,3,"Челябинск",39,10020,390780,"В",null,null,10020,24080,"Есть"]
[553,9,"Тюмень",48,94014,4512672,"Б",null,null,94014,69134,"Есть"]
[554,4,"Архангельск",62,98543,6109666,"А",null,null,98543,69919,"Есть"]
[555,9,"Тюмень",14,26989,377846,"В",null,null,26989,89360,"Есть"]
[556,5,"Краснодар",19,62859,1194321,"Б",null,null,62859,25246,"Есть"]
[557,10,"Сочи",94,64685,6080390,"А",null,null,64685,38388,"Есть"]
[558,6,"Владивосток",90,21713,1954170,"Б",null,null,21713,87149,"Есть"]
[559,2,"Санкт-Петербург",54,83672,4518288,"Б",null,null,83672,7682,"Есть"]
[560,7,"Мурманск",53,42979,2277887,"Б",null,null,42979,3394,"Есть"]
[561,6,"Владивосток",54,94574,5106996,"А",null,null,94574,21339,"Есть"]
[562,8,"Новосибирск",47,46058,2164726,"Б",null,null,46058,45109,"Есть"]
[563,7,"Мурманск",100,89360,8936000,"А",null,null,89360,92796,"Есть"]
[564,5,"Краснодар",92,12501,1150092,"Б",null,null,12501,97887,"Есть"]
[565,1,"Москва",34,52998,1801932,"Б",null,null,52998,27241,"Есть"]
[566,4,"Архангельск",46,99557,4579622,"Б",null,null,99557,64560,"Есть"]
[567,3,"Челябинск",19,68301,1297719,"Б",null,null,68301,12190,"Есть"]
[568,7,"Мурманск",15,78120,1171800,"Б",null,null,78120,14051,"Есть"]
[569,3,"Челябинск",50,71569,3578450,"Б",null,null,71569,59501,"Есть"]
[570,10,"Сочи",64,16312,1043968,"Б",null,null,16312,54860,"Есть"]
[571,3,"Челябинск",84,29371,2467164,"Б",null,null,29371,31623,"Есть"]
[572,6,"Владивосток",83,95642,7938286,"А",null,null,95642,45480,"Есть"]
[573,6,"Владивосток",79,44551,3519529,"Б",null,null,44551,89498,"Есть"]
[574,6,"Владивосток",8,45475,363800,"В",null,null,45475,59544,"Есть"]
[575,8,"Новосибирск",85,23310,1981350,"Б",null,null,23310,49666,"Есть"]
[576,4,"Архангельск",12,92290,1107480,"Б",null,null,92290,32500,"Есть"]
[577,3,{"$f":"VLOOKUP(B594,$J$2:$L$12,2,0)","v":"Челябинск"},23,44965,1034195,{"$f":"IF(F594>5000000,\"А\",IF(F594<999999,\"В\",IF(AND(F594>999999,F594<5000000),\"Б\")))","v":"Б"},null,null,44965,36333,"Есть"]
[578,9,"Тюмень",1,97914,{"$f":"D595*E595","v":97914},"В",null,null,97914,37785,{"$f":"IF(COUNTIF($K$18:$K$1017,J595)>0,\"Есть\",\"Нет\")","v":"Есть"}]
[579,6,"Владивосток",54,26703,1441962,"Б",null,null,26703,27439,"Есть"]
[580,7,"Мурманск",81,20742,1680102,"Б",null,null,20742,79623,"Есть"]
[581,8,"Новосибирск",8,72457,579656,"В",null,null,72457,34301,"Есть"]
[582,2,"Санкт-Петербург",99,7632,755568,"В",null,null,7632,68402,"Есть"]
[583,3,"Челябинск",33,48717,1607661,"Б",null,null,48717,29480,"Есть"]
[584,5,"Краснодар",52,32941,1712932,"Б",null,null,32941,32941,"Есть"]
[585,2,"Санкт-Петербург",100,23897,2389700,"Б",null,null,23897,53579,"Есть"]
[586,8,"Новосибирск",29,15951,462579,"В",null,null,15951,13089,"Есть"]
[587,5,"Краснодар",47,64582,3035354,"Б",null,null,64582,56899,"Есть"]
[588,5,"Краснодар",25,85626,2140650,"Б",null,null,85626,51307,"Есть"]
[589,9,"Тюмень",58,84751,4915558,"Б",null,null,84751,23224,"Есть"]
[590,7,"Мурманск",51,92423,4713573,"Б",null,null,92423,17044,"Есть"]
[591,7,"Мурманск",20,72832,1456640,"Б",null,null,72832,23167,"Есть"]
[592,7,"Мурманск",14,65640,918960,"В",null,null,65640,6742,"Есть"]
[593,8,"Новосибирск",96,56175,5392800,"А",null,null,56175,43686,"Есть"]
[594,7,"Мурманск",51,72503,3697653,"Б",null,null,72503,21228,"Есть"]
[595,5,"Краснодар",2,78281,156562,"В",null,null,78281,34065,"Есть"]
[596,2,"Санкт-Петербург",47,38972,1831684,"Б",null,null,38972,65102,"Есть"]
[597,8,"Новосибирск",84,92889,7802676,"А",null,null,92889,84110,"Есть"]
[598,8,"Новосибирск",51,17977,916827,"В",null,null,17977,19591,"Есть"]
[599,6,"Владивосток",30,99764,2992920,"Б",null,null,99764,60286,"Есть"]
[600,7,"Мурманск",95,29558,2808010,"Б",null,null,29558,97079,"Есть"]
[601,8,"Новосибирск",66,79776,5265216,"А",null,null,79776,42456,"Есть"]
[602,8,"Новосибирск",53,8128,430784,"В",null,null,8128,14176,"Есть"]
[603,1,"Москва",10,4617,46170,"В",null,null,4617,35227,"Есть"]
[604,10,"Сочи",23,20822,478906,"В",null,null,20822,7436,"Есть"]
[605,8,"Новосибирск",4,23249,92996,"В",null,null,23249,30580,"Есть"]
[606,7,"Мурманск",98,54660,5356680,"А",null,null,54660,12971,"Есть"]
[607,9,"Тюмень",24,60918,1462032,"Б",null,null,60918,65649,"Есть"]
[608,4,"Архангельск",65,80980,5263700,"А",null,null,80980,41875,"Есть"]
[609,3,"Челябинск",52,71354,3710408,"Б",null,null,71354,37905,"Есть"]
[610,4,"Архангельск",56,41371,2316776,"Б",null,null,41371,8143,"Есть"]
[611,2,"Санкт-Петербург",64,29461,1885504,"Б",null,null,29461,34460,"Есть"]
[612,3,"Челябинск",26,18076,469976,"В",null,null,18076,1748,"Есть"]
[613,6,"Владивосток",49,63633,3118017,"Б",null,null,63633,83008,"Есть"]
[614,6,"Владивосток",44,84572,3721168,"Б",null,null,84572,86193,"Есть"]
[615,4,"Архангельск",89,62499,5562411,"А",null,null,62499,11298,"Есть"]
[616,1,"Москва",12,49795,597540,"В",null,null,49795,28587,"Есть"]
[617,4,"Архангельск",39,95732,3733548,"Б",null,null,95732,16660,"Есть"]
[618,1,"Москва",61,27260,1662860,"Б",null,null,27260,45719,"Есть"]
[619,7,"Мурманск",7,43224,302568,"В",null,null,43224,45840,"Есть"]
[620,8,"Новосибирск",75,12994,974550,"В",null,null,12994,98023,"Есть"]
[621,10,"Сочи",16,19761,316176,"В",null,null,19761,62748,"Есть"]
[622,4,"Архангельск",52,47044,2446288,"Б",null,null,47044,66092,"Есть"]
[623,8,"Новосибирск",87,39005,3393435,"Б",null,null,39005,33324,"Есть"]
[624,7,"Мурманск",96,83008,7968768,"А",null,null,83008,71921,"Есть"]
[625,3,"Челябинск",97,58405,5665285,"А",null,null,58405,52847,"Есть"]
[626,10,"Сочи",2,1809,3618,"В",null,null,1809,91885,"Есть"]
[627,3,"Челябинск",86,86368,7427648,"А",null,null,86368,42840,"Есть"]
[628,5,"Краснодар",83,32693,2713519,"Б",null,null,32693,33516,"Есть"]
[629,5,"Краснодар",14,57779,808906,"В",null,null,57779,2885,"Есть"]
[630,10,"Сочи",43,87146,3747278,"Б",null,null,87146,29766,"Есть"]
[631,10,"Сочи",9,99733,897597,"В",null,null,99733,21313,"Есть"]
[632,4,"Архангельск",98,1226,120148,"В",null,null,1226,34773,"Есть"]
[633,4,"Архангельск",38,52042,1977596,"Б",null,null,52042,14088,"Есть"]
[634,9,"Тюмень",98,33516,3284568,"Б",null,null,33516,73849,"Есть"]
[635,4,"Архангельск",96,2898,278208,"В",null,null,2898,52184,"Есть"]
[636,2,"Санкт-Петербург",8,99652,797216,"В",null,null,99652,56748,"Есть"]
[637,8,"Новосибирск",18,60752,1093536,"Б",null,null,60752,44965,"Есть"]
[638,10,"Сочи",43,11178,480654,"В",null,null,11178,62405,"Есть"]
[639,9,"Тюмень",23,83275,1915325,"Б",null,null,83275,46694,"Есть"]
[640,10,"Сочи",66,41173,2717418,"Б",null,null,41173,46863,"Есть"]
[641,3,{"$f":"VLOOKUP(B658,$J$2:$L$12,2,0)","v":"Челябинск"},60,9981,598860,{"$f":"IF(F658>5000000,\"А\",IF(F658<999999,\"В\",IF(AND(F658>999999,F658<5000000),\"Б\")))","v":"В"},null,null,9981,82805,"Есть"]
[642,3,"Челябинск",98,74862,{"$f":"D659*E659","v":7336476},"А",null,null,74862,43222,{"$f":"IF(COUNTIF($K$18:$K$1017,J659)>0,\"Есть\",\"Нет\")","v":"Есть"}]
[643,10,"Сочи",38,83871,3187098,"Б",null,null,83871,9981,"Есть"]
[644,4,"Архангельск",5,83208,416040,"В",null,null,83208,30573,"Есть"]
[645,2,"Санкт-Петербург",16,74169,1186704,"Б",null,null,74169,83524,"Есть"]
[646,8,"Новосибирск",39,29180,1138020,"Б",null,null,29180,4617,"Есть"]
[647,2,"Санкт-Петербург",20,3022,60440,"В",null,null,3022,4685,"Есть"]
[648,8,"Новосибирск",71,14176,1006496,"Б",null,null,14176,80082,"Есть"]
[649,7,"Мурманск",4,52734,210936,"В",null,null,52734,74169,"Есть"]
[650,10,"Сочи",37,11812,437044,"В",null,null,11812,48899,"Есть"]
[651,3,"Челябинск",60,27885,1673100,"Б",null,null,27885,89154,"Есть"]
[652,5,"Краснодар",72,46057,3316104,"Б",null,null,46057,2650,"Есть"]
[653,2,"Санкт-Петербург",59,58437,3447783,"Б",null,null,58437,58612,"Есть"]
[654,8,"Новосибирск",24,12420,298080,"В",null,null,12420,59952,"Есть"]
[655,9,"Тюмень",71,96662,6863002,"А",null,null,96662,70389,"Есть"]
[656,2,"Санкт-Петербург",54,48676,2628504,"Б",null,null,48676,70908,"Есть"]
[657,4,"Архангельск",98,42484,4163432,"Б",null,null,42484,80980,"Есть"]
[658,6,"Владивосток",79,10320,815280,"В",null,null,10320,29167,"Есть"]
[659,7,"Мурманск",16,79591,1273456,"Б",null,null,79591,79110,"Есть"]
[660,2,"Санкт-Петербург",4,95757,383028,"В",null,null,95757,28423,"Есть"]
[661,8,"Новосибирск",15,37390,560850,"В",null,null,37390,65367,"Есть"]
[662,1,"Москва",48,37905,1819440,"Б",null,null,37905,61713,"Есть"]
[663,8,"Новосибирск",72,83677,6024744,"А",null,null,83677,15675,"Есть"]
[664,5,"Краснодар",76,45719,3474644,"Б",null,null,45719,19035,"Есть"]
[665,4,"Архангельск",7,28586,200102,"В",null,null,28586,79711,"Есть"]
[666,1,"Москва",75,70819,5311425,"А",null,null,70819,54186,"Есть"]
[667,8,"Новосибирск",8,89182,713456,"В",null,null,89182,37483,"Нет"]
[668,3,"Челябинск",42,38222,1605324,"Б",null,null,38222,66613,"Есть"]
[669,3,"Челябинск",13,48780,634140,"В",null,null,48780,8128,"Есть"]
[670,6,"Владивосток",72,41875,3015000,"Б",null,null,41875,87405,"Есть"]
[671,9,"Тюмень",96,6849,657504,"В",null,null,6849,24196,"Есть"]
[672,10,"Сочи",68,25464,1731552,"Б",null,null,25464,17417,"Есть"]
[673,7,"Мурманск",89,99067,8816963,"А",null,null,99067,5162,"Нет"]
[674,3,"Челябинск",6,77729,466374,"В",null,null,77729,56299,"Есть"]
[675,8,"Новосибирск",41,56899,2332859,"Б",null,null,56899,31965,"Есть"]
[676,1,"Москва",20,21228,424560,"В",null,null,21228,9378,"Есть"]
[677,6,"Владивосток",98,94784,9288832,"А",null,null,94784,16646,"Есть"]
[678,2,"Санкт-Петербург",12,67303,807636,"В",null,null,67303,4518,"Есть"]
[679,10,"Сочи",42,83756,3517752,"Б",null,null,83756,34124,"Есть"]
[680,10,"Сочи",82,77679,6369678,"А",null,null,77679,26485,"Есть"]
[681,6,"Владивосток",38,34124,1296712,"Б",null,null,34124,98383,"Есть"]
[682,3,"Челябинск",35,46953,1643355,"Б",null,null,46953,78120,"Есть"]
[683,7,"Мурманск",72,83533,6014376,"А",null,null,83533,4991,"Есть"]
[684,6,"Владивосток",18,88909,1600362,"Б",null,null,88909,92764,"Есть"]
[685,5,"Краснодар",78,92497,7214766,"А",null,null,92497,3808,"Есть"]
[686,3,"Челябинск",92,16396,1508432,"Б",null,null,16396,97978,"Есть"]
[687,1,"Москва",87,63271,5504577,"А",null,null,63271,71144,"Есть"]
[688,7,"Мурманск",40,15238,609520,"В",null,null,15238,96772,"Есть"]
[689,6,"Владивосток",38,48630,1847940,"Б",null,null,48630,56378,"Есть"]
[690,1,"Москва",61,76380,4659180,"Б",null,null,76380,76366,"Есть"]
[691,3,"Челябинск",58,23917,1387186,"Б",null,null,23917,85376,"Есть"]
[692,5,"Краснодар",14,33258,465612,"В",null,null,33258,92747,"Есть"]
[693,9,"Тюмень",77,22438,1727726,"Б",null,null,22438,55723,"Есть"]
[694,6,"Владивосток",96,96101,9225696,"А",null,null,96101,25464,"Есть"]
[695,1,"Москва",32,67066,2146112,"Б",null,null,67066,49551,"Есть"]
[696,3,"Челябинск",84,17629,1480836,"Б",null,null,17629,39005,"Есть"]
[697,1,"Москва",14,49627,694778,"В",null,null,49627,39085,"Есть"]
[698,1,"Москва",64,98383,6296512,"А",null,null,98383,16396,"Есть"]
[699,10,"Сочи",10,31435,314350,"В",null,null,31435,40994,"Есть"]
[700,3,"Челябинск",27,37629,1015983,"Б",null,null,37629,79776,"Есть"]
[701,4,"Архангельск",79,77051,6087029,"А",null,null,77051,55409,"Есть"]
[702,10,"Сочи",13,75592,982696,"В",null,null,75592,49795,"Есть"]
[703,10,"Сочи",58,45109,2616322,"Б",null,null,45109,22619,"Есть"]
[704,8,"Новосибирск",26,86447,2247622,"Б",null,null,86447,28281,"Есть"]
[705,9,{"$f":"VLOOKUP(B722,$J$2:$L$12,2,0)","v":"Тюмень"},77,81828,6300756,{"$f":"IF(F722>5000000,\"А\",IF(F722<999999,\"В\",IF(AND(F722>999999,F722<5000000),\"Б\")))","v":"А"},null,null,81828,75992,"Есть"]
[706,1,"Москва",56,28316,{"$f":"D723*E723","v":1585696},"Б",null,null,28316,38972,{"$f":"IF(COUNTIF($K$18:$K$1017,J723)>0,\"Есть\",\"Нет\")","v":"Есть"}]
[707,1,"Москва",39,13516,527124,"В",null,null,13516,77309,"Есть"]
[708,2,"Санкт-Петербург",74,33233,2459242,"Б",null,null,33233,18605,"Есть"]
[709,5,"Краснодар",87,17195,1495965,"Б",null,null,17195,34900,"Есть"]
[710,10,"Сочи",91,28781,2619071,"Б",null,null,28781,80011,"Есть"]
[711,8,"Новосибирск",70,23167,1621690,"Б",null,null,23167,94737,"Есть"]
[712,3,"Челябинск",99,94896,9394704,"А",null,null,94896,84742,"Есть"]
[713,6,"Владивосток",79,80121,6329559,"А",null,null,80121,28651,"Есть"]
[714,9,"Тюмень",34,12024,408816,"В",null,null,12024,37629,"Есть"]
[715,8,"Новосибирск",7,77136,539952,"В",null,null,77136,51584,"Есть"]
[716,1,"Москва",17,45643,775931,"В",null,null,45643,38369,"Есть"]
[717,8,"Новосибирск",64,13658,874112,"В",null,null,13658,61146,"Есть"]
[718,2,"Санкт-Петербург",87,86816,7552992,"А",null,null,86816,34913,"Есть"]
[719,4,"Архангельск",50,53300,2665000,"Б",null,null,53300,76832,"Есть"]
[720,9,"Тюмень",7,35289,247023,"В",null,null,35289,94224,"Есть"]
[721,4,"Архангельск",60,18062,1083720,"Б",null,null,18062,93587,"Есть"]
[722,5,"Краснодар",25,79332,1983300,"Б",null,null,79332,81905,"Есть"]
[723,8,"Новосибирск",79,83318,6582122,"А",null,null,83318,83459,"Есть"]
[724,3,"Челябинск",14,46290,648060,"В",null,null,46290,46290,"Есть"]
[725,5,"Краснодар",90,3644,327960,"В",null,null,3644,23112,"Есть"]
[726,5,"Краснодар",13,91576,1190488,"Б",null,null,91576,96698,"Есть"]
[727,10,"Сочи",8,65367,522936,"В",null,null,65367,39352,"Есть"]
[728,4,"Архангельск",73,68551,5004223,"А",null,null,68551,22499,"Есть"]
[729,1,"Москва",100,56383,5638300,"А",null,null,56383,69199,"Есть"]
[730,6,"Владивосток",42,94549,3971058,"Б",null,null,94549,88742,"Есть"]
[731,6,"Владивосток",70,92631,6484170,"А",null,null,92631,2204,"Есть"]
[732,3,"Челябинск",66,1964,129624,"В",null,null,1964,47044,"Есть"]
[733,9,"Тюмень",7,37283,260981,"В",null,null,37283,92181,"Есть"]
[734,4,"Архангельск",93,41174,3829182,"Б",null,null,41174,83971,"Есть"]
[735,4,"Архангельск",27,15525,419175,"В",null,null,15525,87146,"Есть"]
[736,10,"Сочи",91,78714,7162974,"А",null,null,78714,75751,"Есть"]
[737,2,"Санкт-Петербург",67,97486,6531562,"А",null,null,97486,89074,"Есть"]
[738,7,"Мурманск",28,3968,111104,"В",null,null,3968,93460,"Есть"]
[739,7,"Мурманск",98,18691,1831718,"Б",null,null,18691,73522,"Есть"]
[740,10,"Сочи",71,23316,1655436,"Б",null,null,23316,9261,"Есть"]
[741,10,"Сочи",72,30124,2168928,"Б",null,null,30124,90979,"Есть"]
[742,4,"Архангельск",4,40462,161848,"В",null,null,40462,22176,"Есть"]
[743,8,"Новосибирск",21,34725,729225,"В",null,null,34725,3791,"Есть"]
[744,2,"Санкт-Петербург",75,19420,1456500,"Б",null,null,19420,49566,"Есть"]
[745,10,"Сочи",69,32942,2272998,"Б",null,null,32942,14199,"Есть"]
[746,4,"Архангельск",11,83372,917092,"В",null,null,83372,86770,"Есть"]
[747,2,"Санкт-Петербург",32,73664,2357248,"Б",null,null,73664,48717,"Есть"]
[748,10,"Сочи",73,18354,1339842,"Б",null,null,18354,36458,"Есть"]
[749,10,"Сочи",7,10640,74480,"В",null,null,10640,65839,"Есть"]
[750,6,"Владивосток",35,53522,1873270,"Б",null,null,53522,95556,"Есть"]
[751,2,"Санкт-Петербург",78,82219,6413082,"А",null,null,82219,81475,"Есть"]
[752,2,"Санкт-Петербург",9,62422,561798,"В",null,null,62422,71985,"Есть"]
[753,10,"Сочи",3,89999,269997,"В",null,null,89999,55097,"Есть"]
[754,4,"Архангельск",50,96520,4826000,"Б",null,null,96520,29558,"Есть"]
[755,8,"Новосибирск",43,25759,1107637,"Б",null,null,25759,73664,"Есть"]
[756,7,"Мурманск",9,38947,350523,"В",null,null,38947,70163,"Есть"]
[757,6,"Владивосток",45,70726,3182670,"Б",null,null,70726,12024,"Есть"]
[758,3,"Челябинск",30,52172,1565160,"Б",null,null,52172,91687,"Есть"]
[759,6,"Владивосток",13,94051,1222663,"Б",null,null,94051,99026,"Есть"]
[760,5,"Краснодар",98,53078,5201644,"А",null,null,53078,4631,"Есть"]
[761,7,"Мурманск",5,89074,445370,"В",null,null,89074,62341,"Есть"]
[762,6,"Владивосток",88,37661,3314168,"Б",null,null,37661,89477,"Есть"]
[763,4,"Архангельск",52,40734,2118168,"Б",null,null,40734,47134,"Есть"]
[764,3,"Челябинск",63,33324,2099412,"Б",null,null,33324,10677,"Есть"]
[765,7,"Мурманск",87,19196,1670052,"Б",null,null,19196,33146,"Есть"]
[766,10,"Сочи",41,65465,2684065,"Б",null,null,65465,67303,"Есть"]
[767,3,"Челябинск",17,32564,553588,"В",null,null,32564,94784,"Есть"]
[768,10,"Сочи",18,54860,987480,"В",null,null,54860,72915,"Есть"]
[769,2,{"$f":"VLOOKUP(B786,$J$2:$L$12,2,0)","v":"Санкт-Петербург"},99,87257,8638443,{"$f":"IF(F786>5000000,\"А\",IF(F786<999999,\"В\",IF(AND(F786>999999,F786<5000000),\"Б\")))","v":"А"},null,null,87257,99983,"Есть"]
[770,7,"Мурманск",100,82029,{"$f":"D787*E787","v":8202900},"А",null,null,82029,32980,{"$f":"IF(COUNTIF($K$18:$K$1017,J787)>0,\"Есть\",\"Нет\")","v":"Есть"}]
[771,1,"Москва",84,38392,3224928,"Б",null,null,38392,86106,"Есть"]
[772,3,"Челябинск",14,93571,1309994,"Б",null,null,93571,48630,"Есть"]
[773,9,"Тюмень",45,25288,1137960,"Б",null,null,25288,69584,"Есть"]
[774,8,"Новосибирск",80,31187,2494960,"Б",null,null,31187,45643,"Есть"]
[775,2,"Санкт-Петербург",9,34900,314100,"В",null,null,34900,16312,"Есть"]
[776,3,"Челябинск",63,2847,179361,"В",null,null,2847,62479,"Есть"]
[777,2,"Санкт-Петербург",49,31807,1558543,"Б",null,null,31807,47890,"Есть"]
[778,8,"Новосибирск",45,41337,1860165,"Б",null,null,41337,97586,"Есть"]
[779,4,"Архангельск",13,39085,508105,"В",null,null,39085,41174,"Есть"]
[780,5,"Краснодар",87,10135,881745,"В",null,null,10135,67848,"Есть"]
[781,9,"Тюмень",97,74164,7193908,"А",null,null,74164,1964,"Есть"]
[782,10,"Сочи",65,43359,2818335,"Б",null,null,43359,27631,"Есть"]
[783,5,"Краснодар",84,66496,5585664,"А",null,null,66496,99825,"Есть"]
[784,1,"Москва",99,50229,4972671,"Б",null,null,50229,93836,"Есть"]
[785,9,"Тюмень",9,7659,68931,"В",null,null,7659,80203,"Есть"]
[786,7,"Мурманск",13,7287,94731,"В",null,null,7287,57659,"Есть"]
[787,1,"Москва",16,15211,243376,"В",null,null,15211,73567,"Есть"]
[788,8,"Новосибирск",1,14323,14323,"В",null,null,14323,96101,"Есть"]
[789,10,"Сочи",33,16402,541266,"В",null,null,16402,36024,"Есть"]
[790,1,"Москва",72,5736,412992,"В",null,null,5736,24319,"Есть"]
[791,3,"Челябинск",63,69584,4383792,"Б",null,null,69584,84230,"Есть"]
[792,9,"Тюмень",12,23804,285648,"В",null,null,23804,40462,"Есть"]
[793,4,"Архангельск",69,88918,6135342,"А",null,null,88918,23922,"Есть"]
[794,7,"Мурманск",79,5065,400135,"В",null,null,5065,80879,"Есть"]
[795,8,"Новосибирск",22,39715,873730,"В",null,null,39715,92889,"Есть"]
[796,2,"Санкт-Петербург",20,35800,716000,"В",null,null,35800,62266,"Есть"]
[797,7,"Мурманск",10,13508,135080,"В",null,null,13508,67861,"Есть"]
[798,2,"Санкт-Петербург",85,77309,6571265,"А",null,null,77309,45225,"Есть"]
[799,8,"Новосибирск",44,12696,558624,"В",null,null,12696,72700,"Есть"]
[800,4,"Архангельск",58,67479,3913782,"Б",null,null,67479,18424,"Есть"]
[801,1,"Москва",13,91360,1187680,"Б",null,null,91360,15211,"Есть"]
[802,9,"Тюмень",49,42840,2099160,"Б",null,null,42840,82219,"Есть"]
[803,1,"Москва",61,38588,2353868,"Б",null,null,38588,32603,"Есть"]
[804,3,"Челябинск",6,49091,294546,"В",null,null,49091,3664,"Есть"]
[805,1,"Москва",96,92407,8871072,"А",null,null,92407,13516,"Есть"]
[806,5,"Краснодар",47,28800,1353600,"Б",null,null,28800,62860,"Есть"]
[807,1,"Москва",51,39159,1997109,"Б",null,null,39159,17486,"Есть"]
[808,10,"Сочи",15,97771,1466565,"Б",null,null,97771,81979,"Есть"]
[809,6,"Владивосток",59,17934,1058106,"Б",null,null,17934,54641,"Есть"]
[810,6,"Владивосток",13,62266,809458,"В",null,null,62266,23804,"Есть"]
[811,3,"Челябинск",14,38369,537166,"В",null,null,38369,86204,"Есть"]
[812,4,"Архангельск",63,24080,1517040,"Б",null,null,24080,34973,"Есть"]
[813,5,"Краснодар",25,95945,2398625,"Б",null,null,95945,13658,"Есть"]
[814,6,"Владивосток",5,84170,420850,"В",null,null,84170,60752,"Есть"]
[815,5,"Краснодар",85,21599,1835915,"Б",null,null,21599,8385,"Есть"]
[816,2,"Санкт-Петербург",29,51307,1487903,"Б",null,null,51307,26265,"Есть"]
[817,5,"Краснодар",17,9261,157437,"В",null,null,9261,37260,"Есть"]
[818,1,"Москва",93,86980,8089140,"А",null,null,86980,13577,"Есть"]
[819,2,"Санкт-Петербург",64,17643,1129152,"Б",null,null,17643,53616,"Есть"]
[820,4,"Архангельск",93,74511,6929523,"А",null,null,74511,86447,"Есть"]
[821,8,"Новосибирск",45,29391,1322595,"Б",null,null,29391,97210,"Есть"]
[822,4,"Архангельск",69,79110,5458590,"А",null,null,79110,13131,"Есть"]
[823,10,"Сочи",75,7436,557700,"В",null,null,7436,75029,"Есть"]
[824,3,"Челябинск",67,33322,2232574,"Б",null,null,33322,74511,"Есть"]
[825,4,"Архангельск",35,96134,3364690,"Б",null,null,96134,84170,"Есть"]
[826,8,"Новосибирск",94,74104,6965776,"А",null,null,74104,52172,"Есть"]
[827,7,"Мурманск",46,55543,2554978,"Б",null,null,55543,55255,"Есть"]
[828,2,"Санкт-Петербург",41,12486,511926,"В",null,null,12486,16106,"Есть"]
[829,9,"Тюмень",67,10937,732779,"В",null,null,10937,55357,"Есть"]
[830,2,"Санкт-Петербург",54,5548,299592,"В",null,null,5548,53300,"Есть"]
[831,10,"Сочи",23,70389,1618947,"Б",null,null,70389,67519,"Есть"]
[832,8,"Новосибирск",66,70163,4630758,"Б",null,null,70163,44409,"Есть"]
[833,5,{"$f":"VLOOKUP(B850,$J$2:$L$12,2,0)","v":"Краснодар"},50,51015,2550750,{"$f":"IF(F850>5000000,\"А\",IF(F850<999999,\"В\",IF(AND(F850>999999,F850<5000000),\"Б\")))","v":"Б"},null,null,51015,83372,"Есть"]
[834,2,"Санкт-Петербург",54,62748,{"$f":"D851*E851","v":3388392},"Б",null,null,62748,34663,{"$f":"IF(COUNTIF($K$18:$K$1017,J851)>0,\"Есть\",\"Нет\")","v":"Есть"}]
[835,3,"Челябинск",96,84248,8087808,"А",null,null,84248,21713,"Есть"]
[836,9,"Тюмень",50,90970,4548500,"Б",null,null,90970,33322,"Есть"]
[837,6,"Владивосток",16,24196,387136,"В",null,null,24196,34725,"Есть"]
[838,6,"Владивосток",32,61146,1956672,"Б",null,null,61146,94896,"Есть"]
[839,7,"Мурманск",62,62973,3904326,"Б",null,null,62973,34032,"Есть"]
[840,9,"Тюмень",86,59783,5141338,"А",null,null,59783,60874,"Есть"]
[841,7,"Мурманск",39,31543,1230177,"Б",null,null,31543,73856,"Есть"]
[842,9,"Тюмень",94,25500,2397000,"Б",null,null,25500,77563,"Есть"]
[843,4,"Архангельск",2,37483,74966,"В",null,null,37483,20216,"Есть"]
[844,9,"Тюмень",5,63282,316410,"В",null,null,63282,42726,"Есть"]
[845,8,"Новосибирск",83,66703,5536349,"А",null,null,66703,64494,"Есть"]
[846,6,"Владивосток",84,5799,487116,"В",null,null,5799,7632,"Есть"]
[847,3,"Челябинск",97,61999,6013903,"А",null,null,61999,25759,"Есть"]
[848,10,"Сочи",53,19247,1020091,"Б",null,null,19247,69557,"Есть"]
[849,2,"Санкт-Петербург",68,36024,2449632,"Б",null,null,36024,64582,"Есть"]
[850,4,"Архангельск",67,16938,1134846,"Б",null,null,16938,75592,"Есть"]
[851,8,"Новосибирск",53,98023,5195219,"А",null,null,98023,25895,"Есть"]
[852,8,"Новосибирск",89,24605,2189845,"Б",null,null,24605,65465,"Есть"]
[853,7,"Мурманск",71,1412,100252,"В",null,null,1412,39426,"Есть"]
[854,3,"Челябинск",49,3138,153762,"В",null,null,3138,94574,"Есть"]
[855,10,"Сочи",63,22076,1390788,"Б",null,null,22076,99557,"Есть"]
[856,2,"Санкт-Петербург",16,35227,563632,"В",null,null,35227,31834,"Есть"]
[857,3,"Челябинск",41,51940,2129540,"Б",null,null,51940,77042,"Есть"]
[858,6,"Владивосток",11,25121,276331,"В",null,null,25121,60550,"Есть"]
[859,7,"Мурманск",90,54186,4876740,"Б",null,null,54186,99149,"Есть"]
[860,2,"Санкт-Петербург",30,65478,1964340,"Б",null,null,65478,17026,"Есть"]
[861,2,"Санкт-Петербург",48,2204,105792,"В",null,null,2204,50181,"Есть"]
[862,4,"Архангельск",74,76028,5626072,"А",null,null,76028,95642,"Есть"]
[863,2,"Санкт-Петербург",71,23112,1640952,"Б",null,null,23112,26636,"Есть"]
[864,7,"Мурманск",95,16507,1568165,"Б",null,null,16507,35388,"Есть"]
[865,7,"Мурманск",51,6440,328440,"В",null,null,6440,4971,"Есть"]
[866,2,"Санкт-Петербург",93,21093,1961649,"Б",null,null,21093,23655,"Есть"]
[867,3,"Челябинск",55,42339,2328645,"Б",null,null,42339,12994,"Есть"]
[868,3,"Челябинск",49,24302,1190798,"Б",null,null,24302,79432,"Есть"]
[869,3,"Челябинск",95,9378,890910,"В",null,null,9378,13971,"Есть"]
[870,6,"Владивосток",63,57068,3595284,"Б",null,null,57068,39159,"Есть"]
[871,1,"Москва",57,22807,1299999,"Б",null,null,22807,88089,"Есть"]
[872,6,"Владивосток",28,40479,1133412,"Б",null,null,40479,55543,"Есть"]
[873,8,"Новосибирск",31,13851,429381,"В",null,null,13851,94549,"Есть"]
[874,2,"Санкт-Петербург",66,8385,553410,"В",null,null,8385,94318,"Есть"]
[875,3,"Челябинск",42,2396,100632,"В",null,null,2396,30812,"Есть"]
[876,10,"Сочи",15,31836,477540,"В",null,null,31836,35800,"Есть"]
[877,5,"Краснодар",60,76157,4569420,"Б",null,null,76157,86310,"Есть"]
[878,4,"Архангельск",29,34090,988610,"В",null,null,34090,12486,"Есть"]
[879,1,"Москва",35,5162,180670,"В",null,null,5162,39715,"Есть"]
[880,1,"Москва",24,6644,159456,"В",null,null,6644,96662,"Есть"]
[881,4,"Архангельск",4,29167,116668,"В",null,null,29167,33233,"Есть"]
[882,4,"Архангельск",15,72508,1087620,"Б",null,null,72508,91576,"Есть"]
[883,6,"Владивосток",48,24319,1167312,"Б",null,null,24319,82926,"Есть"]
[884,9,"Тюмень",92,65699,6044308,"А",null,null,65699,5774,"Есть"]
[885,8,"Новосибирск",1,22184,22184,"В",null,null,22184,81828,"Есть"]
[886,1,"Москва",40,3664,146560,"В",null,null,3664,79725,"Есть"]
[887,4,"Архангельск",44,29973,1318812,"Б",null,null,29973,41422,"Есть"]
[888,10,"Сочи",14,82113,1149582,"Б",null,null,82113,72503,"Есть"]
[889,5,"Краснодар",29,95556,2771124,"Б",null,null,95556,31651,"Есть"]
[890,10,"Сочи",8,34460,275680,"В",null,null,34460,12755,"Есть"]
[891,3,"Челябинск",18,1612,29016,"В",null,null,1612,40479,"Есть"]
[892,4,"Архангельск",88,98868,8700384,"А",null,null,98868,90690,"Есть"]
[893,3,"Челябинск",43,77027,3312161,"Б",null,null,77027,74862,"Есть"]
[894,9,"Тюмень",75,19591,1469325,"Б",null,null,19591,11437,"Есть"]
[895,5,"Краснодар",2,84334,168668,"В",null,null,84334,28130,"Есть"]
[896,6,"Владивосток",97,58106,5636282,"А",null,null,58106,72746,"Есть"]
[897,1,{"$f":"VLOOKUP(B914,$J$2:$L$12,2,0)","v":"Москва"},56,96856,5423936,{"$f":"IF(F914>5000000,\"А\",IF(F914<999999,\"В\",IF(AND(F914>999999,F914<5000000),\"Б\")))","v":"А"},null,null,96856,33344,"Есть"]
[898,9,"Тюмень",44,94224,{"$f":"D915*E915","v":4145856},"Б",null,null,94224,49178,{"$f":"IF(COUNTIF($K$18:$K$1017,J915)>0,\"Есть\",\"Нет\")","v":"Есть"}]
[899,9,"Тюмень",2,76832,153664,"В",null,null,76832,65699,"Есть"]
[900,4,"Архангельск",7,50181,351267,"В",null,null,50181,58437,"Есть"]
[901,10,"Сочи",25,38670,966750,"В",null,null,38670,79344,"Есть"]
[902,7,"Мурманск",70,44409,3108630,"Б",null,null,44409,25126,"Есть"]
[903,5,"Краснодар",52,33133,1722916,"Б",null,null,33133,33920,"Есть"]
[904,5,"Краснодар",94,92453,8690582,"А",null,null,92453,26593,"Есть"]
[905,3,"Челябинск",75,5078,380850,"В",null,null,5078,10640,"Есть"]
[906,5,"Краснодар",7,88264,617848,"В",null,null,88264,17513,"Есть"]
[907,8,"Новосибирск",100,97079,9707900,"А",null,null,97079,2521,"Есть"]
[908,7,"Мурманск",97,31834,3087898,"Б",null,null,31834,8583,"Есть"]
[909,6,"Владивосток",47,16026,753222,"В",null,null,16026,41454,"Есть"]
[910,2,"Санкт-Петербург",68,97887,6656316,"А",null,null,97887,3968,"Есть"]
[911,1,"Москва",14,64560,903840,"В",null,null,64560,96520,"Есть"]
[912,9,"Тюмень",95,66092,6278740,"А",null,null,66092,10320,"Есть"]
[913,6,"Владивосток",64,28908,1850112,"Б",null,null,28908,38392,"Есть"]
[914,9,"Тюмень",14,34032,476448,"В",null,null,34032,21093,"Есть"]
[915,3,"Челябинск",14,59501,833014,"В",null,null,59501,67739,"Есть"]
[916,8,"Новосибирск",5,2885,14425,"В",null,null,2885,33516,"Есть"]
[917,8,"Новосибирск",27,82426,2225502,"Б",null,null,82426,13646,"Есть"]
[918,2,"Санкт-Петербург",70,9531,667170,"В",null,null,9531,52734,"Есть"]
[919,4,"Архангельск",33,46596,1537668,"Б",null,null,46596,72590,"Есть"]
[920,4,"Архангельск",12,28572,342864,"В",null,null,28572,84326,"Есть"]
[921,3,"Челябинск",39,69199,2698761,"Б",null,null,69199,43544,"Есть"]
[922,6,"Владивосток",63,80465,5069295,"А",null,null,80465,33908,"Есть"]
[923,3,"Челябинск",97,61792,5993824,"А",null,null,61792,79777,"Есть"]
[924,7,"Мурманск",19,16749,318231,"В",null,null,16749,70985,"Есть"]
[925,4,"Архангельск",45,28122,1265490,"Б",null,null,28122,80762,"Есть"]
[926,10,"Сочи",85,62082,5276970,"А",null,null,62082,16507,"Есть"]
[927,10,"Сочи",33,71523,2360259,"Б",null,null,71523,75839,"Есть"]
[928,10,"Сочи",25,49551,1238775,"Б",null,null,49551,97486,"Есть"]
[929,1,"Москва",6,65478,392868,"В",null,null,65478,94804,"Есть"]
[930,9,"Тюмень",85,62479,5310715,"А",null,null,62479,67867,"Есть"]
[931,6,"Владивосток",4,54695,218780,"В",null,null,54695,78436,"Есть"]
[932,2,"Санкт-Петербург",25,72700,1817500,"Б",null,null,72700,96138,"Есть"]
[933,6,"Владивосток",95,3791,360145,"В",null,null,3791,42479,"Есть"]
[934,1,"Москва",80,51013,4081040,"Б",null,null,51013,28586,"Есть"]
[935,1,"Москва",64,10419,666816,"В",null,null,10419,32453,"Есть"]
[936,3,"Челябинск",37,70296,2600952,"Б",null,null,70296,78828,"Нет"]
[937,7,"Мурманск",12,45443,545316,"В",null,null,45443,75467,"Есть"]
[938,4,"Архангельск",96,45480,4366080,"Б",null,null,45480,71354,"Есть"]
[939,5,"Краснодар",42,89498,3758916,"Б",null,null,89498,20720,"Есть"]
[940,1,"Москва",54,66372,3584088,"Б",null,null,66372,39117,"Есть"]
[941,10,"Сочи",35,75029,2626015,"Б",null,null,75029,18062,"Есть"]
[942,3,"Челябинск",30,27033,810990,"В",null,null,27033,67035,"Есть"]
[943,4,"Архангельск",50,57659,2882950,"Б",null,null,57659,37390,"Есть"]
[944,1,"Москва",20,52184,1043680,"Б",null,null,52184,43401,"Есть"]
[945,1,"Москва",89,75467,6716563,"А",null,null,75467,45884,"Есть"]
[946,6,"Владивосток",42,77856,3269952,"Б",null,null,77856,51809,"Есть"]
[947,4,"Архангельск",18,70537,1269666,"Б",null,null,70537,23310,"Есть"]
[948,4,"Архангельск",31,37260,1155060,"Б",null,null,37260,33258,"Есть"]
[949,8,"Новосибирск",39,73856,2880384,"Б",null,null,73856,76157,"Есть"]
[950,8,"Новосибирск",67,48584,3255128,"Б",null,null,48584,7287,"Есть"]
[951,1,"Москва",46,87413,4020998,"Б",null,null,87413,49187,"Есть"]
[952,9,"Тюмень",64,26199,1676736,"Б",null,null,26199,16026,"Есть"]
[953,2,"Санкт-Петербург",12,13089,157068,"В",null,null,13089,44716,"Есть"]
[954,3,"Челябинск",54,42479,2293866,"Б",null,null,42479,20822,"Есть"]
[955,4,"Архангельск",92,2693,247756,"В",null,null,2693,53522,"Есть"]
[956,1,"Москва",27,20216,545832,"В",null,null,20216,97775,"Есть"]
[957,2,"Санкт-Петербург",42,44211,1856862,"Б",null,null,44211,98868,"Есть"]
[958,2,"Санкт-Петербург",31,33344,1033664,"Б",null,null,33344,12470,"Есть"]
[959,8,"Новосибирск",79,99149,7832771,"А",null,null,99149,32942,"Есть"]
[960,5,"Краснодар",34,43438,1476892,"Б",null,null,43438,5548,"Есть"]
[961,2,{"$f":"VLOOKUP(B978,$J$2:$L$12,2,0)","v":"Санкт-Петербург"},42,51527,2164134,{"$f":"IF(F978>5000000,\"А\",IF(F978<999999,\"В\",IF(AND(F978>999999,F978<5000000),\"Б\")))","v":"Б"},null,null,51527,80121,"Есть"]
[962,10,"Сочи",94,3205,{"$f":"D979*E979","v":301270},"В",null,null,3205,92423,{"$f":"IF(COUNTIF($K$18:$K$1017,J979)>0,\"Есть\",\"Нет\")","v":"Есть"}]
[963,1,"Москва",26,40896,1063296,"Б",null,null,40896,83677,"Есть"]
[964,9,"Тюмень",9,94953,854577,"В",null,null,94953,16794,"Есть"]
[965,1,"Москва",96,93460,8972160,"А",null,null,93460,6644,"Есть"]
[966,2,"Санкт-Петербург",21,5725,120225,"В",null,null,5725,31543,"Есть"]
[967,10,"Сочи",6,69134,414804,"В",null,null,69134,99652,"Есть"]
[968,3,"Челябинск",12,26605,319260,"В",null,null,26605,49994,"Есть"]
[969,4,"Архангельск",81,76165,6169365,"А",null,null,76165,6429,"Есть"]
[970,8,"Новосибирск",9,56378,507402,"В",null,null,56378,53748,"Есть"]
[971,1,"Москва",32,44623,1427936,"Б",null,null,44623,87257,"Есть"]
[972,1,"Москва",89,39542,3519238,"Б",null,null,39542,1809,"Есть"]
[973,7,"Мурманск",15,45884,688260,"В",null,null,45884,10135,"Есть"]
[974,10,"Сочи",42,47372,1989624,"Б",null,null,47372,45207,"Есть"]
[975,1,"Москва",60,98929,5935740,"А",null,null,98929,35289,"Есть"]
[976,10,"Сочи",50,17513,875650,"В",null,null,17513,1305,"Есть"]
[977,3,"Челябинск",20,11060,221200,"В",null,null,11060,83295,"Есть"]
[978,3,"Челябинск",77,83322,6415794,"А",null,null,83322,14635,"Есть"]
[979,7,"Мурманск",24,23395,561480,"В",null,null,23395,92395,"Есть"]
[980,8,"Новосибирск",73,72915,5322795,"А",null,null,72915,78323,"Есть"]
[981,6,{"$f":"VLOOKUP(B998,$J$2:$L$12,2,0)","v":"Владивосток"},27,86193,2327211,{"$f":"IF(F998>5000000,\"А\",IF(F998<999999,\"В\",IF(AND(F998>999999,F998<5000000),\"Б\")))","v":"Б"},null,null,86193,81758,"Есть"]
[982,2,"Санкт-Петербург",59,49666,2930294,{"$f":"IF(F999>5000000,\"А\",IF(F999<999999,\"В\",IF(AND(F999>999999,F999<5000000),\"Б\")))","v":"Б"},null,null,49666,62082,"Есть"]
[983,7,"Мурманск",98,68892,6751416,{"$f":"IF(F1000>5000000,\"А\",IF(F1000<999999,\"В\",IF(AND(F1000>999999,F1000<5000000),\"Б\")))","v":"А"},null,null,68892,50220,"Есть"]
[984,9,"Тюмень",24,28587,686088,{"$f":"IF(F1001>5000000,\"А\",IF(F1001<999999,\"В\",IF(AND(F1001>999999,F1001<5000000),\"Б\")))","v":"В"},null,null,28587,95221,"Есть"]
[985,5,"Краснодар",88,66446,5847248,"А",null,null,66446,60292,"Есть"]
[986,8,"Новосибирск",60,96846,5810760,"А",null,null,96846,72681,"Нет"]
[987,1,"Москва",69,87285,6022665,"А",null,null,87285,70819,"Есть"]
[988,8,"Новосибирск",14,13362,187068,"В",null,null,13362,5078,"Есть"]
[989,7,"Мурманск",26,17012,442312,{"$f":"IF(F1006>5000000,\"А\",IF(F1006<999999,\"В\",IF(AND(F1006>999999,F1006<5000000),\"Б\")))","v":"В"},null,null,17012,55013,"Есть"]
[990,5,"Краснодар",42,60222,2529324,"Б",null,null,60222,22438,"Есть"]
[991,3,"Челябинск",56,83680,4686080,"Б",null,null,83680,null,"Есть"]
[992,6,"Владивосток",75,92360,6927000,{"$f":"IF(F1009>5000000,\"А\",IF(F1009<999999,\"В\",IF(AND(F1009>999999,F1009<5000000),\"Б\")))","v":"А"},null,null,92360,null,"Есть"]
[993,7,"Мурманск",4,95221,380884,"В",null,null,95221,null,"Есть"]
[994,1,"Москва",50,92747,4637350,"Б",null,null,92747,null,"Есть"]
[995,1,"Москва",34,1405,47770,"В",null,null,1405,null,"Есть"]
[996,4,"Архангельск",60,21033,1261980,"Б",null,null,21033,null,"Есть"]
[997,4,"Архангельск",19,1394,26486,"В",null,null,1394,null,"Есть"]
[998,2,"Санкт-Петербург",21,35388,743148,"В",null,null,35388,null,"Есть"]
[999,3,"Челябинск",96,26745,2567520,"Б",null,null,26745,null,"Есть"]
[1000,3,"Челябинск",70,13971,977970,"В",null,null,13971,null,"Есть"]

{"sheet":"Лист1","index":2,"n_rows":1002,"n_cols":3,"rows_kept":1002,"cut":false,"hidden":false,"merged":[]}
["Таблица 4"]
["Исходные данные","Конечные данные"]
[93470,16744,{"$f":"IF(COUNTIF($B$3:$B$1002,A3)>0,\"Есть\",\"Нет\")","v":"Есть"}]
[15436,98543,{"$f":"IF(COUNTIF($B$3:$B$1002,A4)>0,\"Есть\",\"Нет\")","v":"Есть"}]
[85030,19420,"Есть"]
[17080,18638,"Есть"]
[64494,57536,"Есть"]
[88369,5799,{"$f":"IF(COUNTIF($B$3:$B$1002,A8)>0,\"Есть\",\"Нет\")","v":"Нет"}]
[31965,37998,"Есть"]
[99825,54695,"Есть"]
[70360,63912,"Есть"]
[26226,37905,"Есть"]
[79777,42872,"Есть"]
[99983,2396,"Есть"]
[59856,61431,"Есть"]
[13577,25566,"Есть"]
[76951,96134,"Есть"]
[57536,48370,"Есть"]
[67723,67066,"Есть"]
[76144,43253,"Есть"]
[51504,63079,"Есть"]
[67867,36464,"Есть"]
[61505,22068,"Есть"]
[45225,12696,"Есть"]
[20725,45475,"Есть"]
[60550,35148,"Есть"]
[11164,11141,"Есть"]
[41872,83318,"Есть"]
[23655,99764,"Есть"]
[97901,51527,"Есть"]
[82442,97003,"Есть"]
[94804,91631,"Есть"]
[79322,12474,"Есть"]
[5272,81672,"Есть"]
[62962,63412,"Есть"]
[80082,24302,"Есть"]
[70724,62422,"Есть"]
[16106,68301,"Есть"]
[1093,70601,"Есть"]
[81535,54781,"Есть"]
[49566,54660,"Есть"]
[55723,7128,"Есть"]
[77563,21593,"Есть"]
[82926,7039,"Есть"]
[70746,39542,"Есть"]
[39870,23395,"Есть"]
[6807,52042,"Есть"]
[80879,46058,"Есть"]
[51584,25116,"Есть"]
[99026,37661,"Есть"]
[47089,22509,"Есть"]
[24543,91372,"Есть"]
[51809,45443,"Есть"]
[35436,38947,"Есть"]
[55351,32564,"Есть"]
[77027,23802,"Есть"]
[83295,77187,"Есть"]
[91918,71569,"Есть"]
[51832,25121,"Есть"]
[10557,47020,"Есть"]
[43544,88597,"Есть"]
[62405,25559,"Есть"]
[17417,76028,"Есть"]
[12408,77797,"Есть"]
[69919,5344,"Есть"]
[11244,96467,"Есть"]
[12755,48584,"Есть"]
[30573,82466,{"$f":"IF(COUNTIF($B$3:$B$1002,A68)>0,\"Есть\",\"Нет\")","v":"Есть"}]
[27631,92497,"Есть"]
[27241,41371,"Есть"]
[25116,18076,"Есть"]
[35183,74104,"Есть"]
[12470,86816,"Есть"]
[2459,25288,"Есть"]
[37998,57917,"Есть"]
[7682,78714,"Есть"]
[86296,70998,"Есть"]
[29766,4220,"Есть"]
[26485,1394,"Есть"]
[53748,79322,"Есть"]
[37262,97914,"Есть"]
[33128,6440,"Есть"]
[76366,25500,"Есть"]
[45961,37262,"Есть"]
[55811,10419,"Есть"]
[16660,44543,"Есть"]
[32980,70279,"Есть"]
[83233,39867,"Есть"]
[49402,11117,"Есть"]
[41422,15970,"Есть"]
[65839,91360,"Есть"]
[83971,26745,"Есть"]
[70998,41173,"Есть"]
[28965,80853,"Есть"]
[69979,72722,"Есть"]
[97003,59101,"Есть"]
[79297,70726,"Есть"]
[84626,22513,"Есть"]
[82070,11473,"Есть"]
[43253,51015,"Есть"]
[20720,49627,"Есть"]
[53579,86980,"Есть"]
[28281,70148,"Есть"]
[76157,37281,"Есть"]
[35148,48404,"Есть"]
[91631,69979,"Есть"]
[90883,93470,"Есть"]
[75839,12420,"Есть"]
[92395,97901,"Есть"]
[72763,35122,"Есть"]
[10609,41337,"Есть"]
[59029,63770,"Нет"]
[49455,15961,"Есть"]
[11437,83756,"Есть"]
[96772,87413,"Есть"]
[19740,17486,"Есть"]
[29480,65640,"Есть"]
[14635,72837,"Есть"]
[84110,1612,"Есть"]
[91687,77679,"Есть"]
[33516,12510,"Есть"]
[60658,31836,"Есть"]
[93406,5736,"Есть"]
[42456,10922,"Есть"]
[71985,28316,"Есть"]
[99673,46389,"Есть"]
[32845,83533,"Есть"]
[79432,10628,"Есть"]
[23922,77729,"Есть"]
[80011,95757,"Есть"]
[14123,98214,"Есть"]
[96467,43130,{"$f":"IF(COUNTIF($B$3:$B$1002,A132)>0,\"Есть\",\"Нет\")","v":"Есть"}]
[15961,75835,"Есть"]
[98214,45421,"Есть"]
[1305,31807,"Есть"]
[34301,42484,"Есть"]
[34065,45961,"Есть"]
[78828,38588,"Есть"]
[78436,76380,"Есть"]
[67739,26703,"Есть"]
[55013,57068,"Есть"]
[72955,3022,"Есть"]
[48899,90970,"Есть"]
[25566,64685,"Есть"]
[4631,16938,"Есть"]
[86547,55811,"Есть"]
[49527,28781,"Есть"]
[23224,43359,"Есть"]
[37785,79591,"Есть"]
[32453,23017,"Есть"]
[1458,23118,"Есть"]
[31231,67479,"Есть"]
[51105,27654,"Есть"]
[4216,63478,"Есть"]
[75751,20742,"Есть"]
[62357,36324,"Есть"]
[12474,68145,"Есть"]
[79623,97883,"Есть"]
[94737,78281,"Есть"]
[86538,92453,"Есть"]
[18266,83275,"Есть"]
[49994,52782,"Есть"]
[47134,90396,"Есть"]
[69557,11956,"Есть"]
[78323,16749,"Есть"]
[65239,6717,"Есть"]
[33908,28122,"Есть"]
[36458,3621,"Есть"]
[24693,42339,"Есть"]
[16646,28572,"Есть"]
[40877,27033,"Есть"]
[60727,47372,"Есть"]
[39117,42952,"Есть"]
[33436,43224,"Есть"]
[33072,34090,"Есть"]
[80203,66846,"Есть"]
[17260,66496,"Есть"]
[14051,1093,"Есть"]
[73849,41872,"Есть"]
[34756,14655,"Есть"]
[46694,29004,"Есть"]
[73208,28908,"Есть"]
[72746,24808,"Есть"]
[28712,17249,"Есть"]
[18638,26226,"Есть"]
[23693,70360,"Есть"]
[53092,17934,"Есть"]
[23017,11854,"Есть"]
[56436,62357,"Есть"]
[70908,32681,"Есть"]
[48370,86296,"Есть"]
[47165,9531,"Есть"]
[77797,10077,"Есть"]
[47168,83672,"Есть"]
[23322,92356,"Есть"]
[39867,31231,{"$f":"IF(COUNTIF($B$3:$B$1002,A196)>0,\"Есть\",\"Нет\")","v":"Есть"}]
[74772,93406,"Есть"]
[56748,24543,"Есть"]
[17809,60222,"Есть"]
[11473,47168,"Есть"]
[22499,19761,"Есть"]
[56680,76012,"Есть"]
[18424,79332,"Есть"]
[33146,62499,"Есть"]
[10677,10191,"Есть"]
[56299,77051,"Есть"]
[52847,88112,"Есть"]
[52782,13281,"Есть"]
[3808,3644,"Есть"]
[44543,67723,"Есть"]
[11956,98822,"Есть"]
[32681,73537,"Есть"]
[22176,71523,"Есть"]
[40994,25994,"Есть"]
[90690,50584,"Есть"]
[12971,73208,"Есть"]
[50584,65478,"Есть"]
[72681,98943,"Есть"]
[65649,22076,"Есть"]
[1781,39359,"Есть"]
[70838,65212,"Нет"]
[76623,37283,"Есть"]
[82466,14123,"Есть"]
[88158,90883,"Есть"]
[19981,34756,"Есть"]
[25126,94014,"Есть"]
[81905,13362,"Есть"]
[84742,40877,"Есть"]
[70279,88264,"Есть"]
[75835,23249,"Есть"]
[42726,85626,"Есть"]
[86189,62961,"Есть"]
[42952,69933,"Есть"]
[53521,77676,"Есть"]
[51296,17809,"Есть"]
[62341,57935,"Есть"]
[34663,61145,"Есть"]
[45639,19196,"Есть"]
[98943,48676,"Есть"]
[70148,72457,"Есть"]
[78747,83322,"Есть"]
[32617,17195,"Есть"]
[3068,19981,"Есть"]
[94342,26605,"Нет"]
[29200,72613,"Есть"]
[37905,46057,"Есть"]
[46009,86547,"Есть"]
[11854,99083,"Есть"]
[63412,44211,"Есть"]
[5774,53203,"Есть"]
[54641,32617,"Есть"]
[75992,46025,"Есть"]
[21648,53078,"Есть"]
[99861,95014,"Нет"]
[88742,17977,"Есть"]
[39359,68551,"Есть"]
[58290,29391,"Есть"]
[36464,7659,"Есть"]
[65102,19089,"Есть"]
[83524,44551,{"$f":"IF(COUNTIF($B$3:$B$1002,A260)>0,\"Есть\",\"Нет\")","v":"Есть"}]
[30812,62859,"Есть"]
[26593,51741,"Есть"]
[99379,35527,"Есть"]
[90449,32693,"Есть"]
[2521,2459,"Есть"]
[59765,31783,"Есть"]
[80712,72832,"Нет"]
[27654,18266,"Есть"]
[77042,58405,"Есть"]
[4549,3695,"Есть"]
[63079,82029,"Есть"]
[61145,17260,"Есть"]
[59544,26199,"Есть"]
[30866,23693,"Есть"]
[87405,44623,"Есть"]
[99083,56436,"Есть"]
[33735,86368,"Есть"]
[67035,4549,"Есть"]
[28423,20725,"Есть"]
[53203,62973,"Есть"]
[72590,7831,"Есть"]
[73567,27612,"Есть"]
[60286,75406,"Есть"]
[25994,55351,"Есть"]
[72837,98929,"Есть"]
[44716,22184,"Есть"]
[57917,53092,"Есть"]
[27612,92407,"Есть"]
[10191,79485,"Есть"]
[34773,56680,"Есть"]
[13131,60658,"Есть"]
[14558,40896,"Есть"]
[21339,2847,"Есть"]
[11117,5065,"Есть"]
[79485,59783,"Есть"]
[52097,6807,"Есть"]
[15675,84334,"Есть"]
[29004,92360,"Есть"]
[47890,17080,"Есть"]
[6429,32845,"Есть"]
[4781,51296,"Есть"]
[35122,19740,"Есть"]
[34973,53521,"Есть"]
[53616,99733,"Есть"]
[60667,74649,"Есть"]
[91885,84409,"Есть"]
[8182,88876,"Есть"]
[25246,36500,"Есть"]
[1748,82113,"Есть"]
[32476,1458,"Есть"]
[28651,8182,"Есть"]
[65862,53983,"Есть"]
[93587,51361,"Есть"]
[31651,88158,"Есть"]
[23802,92050,"Есть"]
[28130,82442,"Есть"]
[91372,1226,"Есть"]
[13281,60918,"Есть"]
[79711,59765,"Есть"]
[80762,83680,"Есть"]
[89154,83208,"Есть"]
[72650,96856,"Есть"]
[65212,3180,"Есть"]
[54188,77027,{"$f":"IF(COUNTIF($B$3:$B$1002,A324)>0,\"Есть\",\"Нет\")","v":"Есть"}]
[7831,58106,"Есть"]
[32500,38466,"Есть"]
[72763,37410,"Есть"]
[97978,51832,"Есть"]
[97883,38222,"Есть"]
[13833,66372,"Есть"]
[92050,27046,"Есть"]
[76012,89999,"Есть"]
[80853,82345,"Есть"]
[41454,40622,"Есть"]
[5344,10609,"Есть"]
[75406,27885,"Есть"]
[97586,12241,"Есть"]
[70267,29451,"Есть"]
[3621,54732,"Есть"]
[49178,84626,"Есть"]
[97210,10557,"Есть"]
[36324,72763,"Есть"]
[37410,12139,"Есть"]
[77676,11164,"Есть"]
[42872,15238,"Есть"]
[31623,30124,"Есть"]
[84409,24605,"Есть"]
[60745,82426,"Есть"]
[43222,2898,"Есть"]
[8651,49527,"Есть"]
[45840,81535,"Есть"]
[28652,90449,"Есть"]
[13646,82357,"Есть"]
[4685,99379,"Есть"]
[63564,17629,"Есть"]
[81758,29371,"Есть"]
[55255,76951,"Есть"]
[93836,84751,"Есть"]
[69933,44930,"Есть"]
[57935,9583,"Есть"]
[66613,29180,"Есть"]
[66846,76623,"Есть"]
[55409,6849,"Есть"]
[16744,61792,"Есть"]
[73224,23303,"Есть"]
[26636,88918,"Есть"]
[63912,23322,"Есть"]
[55357,8651,"Есть"]
[86770,66739,"Есть"]
[18605,45639,"Есть"]
[14940,24015,"Есть"]
[50220,84248,"Есть"]
[88089,66446,"Есть"]
[81672,11812,"Есть"]
[45421,16402,"Есть"]
[17486,56059,"Есть"]
[34913,12501,"Есть"]
[27075,17643,"Есть"]
[84326,82911,"Есть"]
[3180,33385,"Есть"]
[92356,70724,"Есть"]
[33920,35183,"Есть"]
[46025,72955,"Есть"]
[97126,21033,"Есть"]
[96138,38051,"Есть"]
[81475,27260,"Есть"]
[48404,51013,"Есть"]
[75609,14558,{"$f":"IF(COUNTIF($B$3:$B$1002,A388)>0,\"Есть\",\"Нет\")","v":"Есть"}]
[30580,63633,"Есть"]
[99219,42635,"Есть"]
[61713,3068,"Есть"]
[58811,33133,"Есть"]
[36333,85180,"Есть"]
[42635,73224,"Есть"]
[77187,63282,"Есть"]
[4971,12408,"Есть"]
[46863,14323,"Есть"]
[92764,23897,"Есть"]
[3394,99851,"Есть"]
[21313,23917,"Есть"]
[43686,76165,"Есть"]
[88495,88495,"Есть"]
[82357,86189,"Есть"]
[6717,38822,"Есть"]
[39352,54637,"Есть"]
[72613,52097,"Есть"]
[43401,22022,"Есть"]
[12139,4216,"Есть"]
[85180,10902,"Есть"]
[70601,33072,"Есть"]
[63770,50229,"Есть"]
[31783,15525,"Есть"]
[6742,65862,"Есть"]
[92181,38670,"Есть"]
[70985,60667,"Есть"]
[17026,57779,"Есть"]
[55097,34383,"Есть"]
[58612,28965,"Есть"]
[59952,34300,"Есть"]
[14088,56175,"Есть"]
[97775,97771,"Есть"]
[51741,84572,"Есть"]
[38822,87690,"Есть"]
[29451,34939,"Есть"]
[22513,11244,"Есть"]
[92796,70746,"Есть"]
[98603,15754,"Есть"]
[19035,33436,"Есть"]
[66739,32476,"Есть"]
[44930,80465,"Есть"]
[12510,49091,"Есть"]
[1119,43438,"Есть"]
[82805,82070,"Есть"]
[35527,5272,"Есть"]
[48091,92290,"Есть"]
[95014,49455,"Есть"]
[15970,87285,"Есть"]
[12241,95452,"Есть"]
[22068,92631,"Есть"]
[89477,79297,"Есть"]
[11141,21648,"Есть"]
[16794,99219,"Есть"]
[62961,56383,"Есть"]
[25895,95945,"Есть"]
[49350,52998,"Есть"]
[87526,88909,"Есть"]
[12437,63271,"Есть"]
[14199,62962,"Есть"]
[4991,13508,"Есть"]
[87690,76144,"Есть"]
[39426,46934,"Есть"]
[73537,59856,{"$f":"IF(COUNTIF($B$3:$B$1002,A452)>0,\"Есть\",\"Нет\")","v":"Есть"}]
[24808,58290,"Есть"]
[53498,83871,"Есть"]
[90979,49350,"Есть"]
[96698,40600,"Есть"]
[40622,78747,"Есть"]
[71921,19247,"Есть"]
[60874,93571,"Есть"]
[37281,1412,"Есть"]
[98822,72763,"Есть"]
[84230,51105,"Есть"]
[81979,98603,"Есть"]
[22619,13851,"Есть"]
[21593,66703,"Есть"]
[11298,68892,"Есть"]
[51361,11060,"Есть"]
[95452,47165,"Есть"]
[82911,63564,"Есть"]
[2650,1119,"Есть"]
[71144,29200,"Есть"]
[79344,15436,"Есть"]
[26265,31435,"Есть"]
[17249,27075,"Есть"]
[23118,23051,"Есть"]
[62860,98691,"Есть"]
[87149,94051,"Есть"]
[23051,18691,"Есть"]
[59101,48780,"Есть"]
[17486,33735,"Есть"]
[60292,86538,"Есть"]
[23303,42979,"Есть"]
[27046,1405,"Есть"]
[34300,65478,"Есть"]
[74649,70267,"Есть"]
[8583,60745,"Есть"]
[10902,24693,"Есть"]
[90396,99673,"Есть"]
[7128,5725,"Есть"]
[32603,30866,"Есть"]
[4220,4781,"Есть"]
[38051,47089,"Есть"]
[10077,95732,"Есть"]
[15754,17012,"Есть"]
[4518,39870,"Есть"]
[14655,26989,"Есть"]
[73522,29973,"Есть"]
[68402,2693,"Есть"]
[33385,21599,"Есть"]
[85376,61999,"Есть"]
[8143,65239,"Есть"]
[46934,77027,"Есть"]
[82345,97126,"Есть"]
[9583,51940,"Есть"]
[47020,49402,"Есть"]
[25559,91918,"Есть"]
[83459,77136,"Есть"]
[22022,46953,"Есть"]
[86106,10937,"Есть"]
[99851,53498,"Есть"]
[3695,54188,"Есть"]
[54732,40734,"Есть"]
[38466,48091,"Есть"]
[17044,70537,"Есть"]
[63030,72650,"Есть"]
[72722,28652,{"$f":"IF(COUNTIF($B$3:$B$1002,A516)>0,\"Есть\",\"Нет\")","v":"Есть"}]
[15266,1781,"Есть"]
[19089,76157,"Есть"]
[86310,15266,"Есть"]
[38388,13833,"Есть"]
[36500,85030,"Есть"]
[27439,74772,"Есть"]
[67861,29461,"Есть"]
[98691,94953,"Есть"]
[63478,10020,"Есть"]
[40600,83233,"Есть"]
[67848,3138,"Есть"]
[5072,18354,"Есть"]
[56059,58811,"Есть"]
[61431,63030,"Есть"]
[34383,3205,"Есть"]
[43130,46009,"Есть"]
[54637,75609,"Есть"]
[49187,11178,"Есть"]
[46389,72508,"Есть"]
[7039,35436,"Есть"]
[88876,22807,"Есть"]
[94318,77856,"Есть"]
[86204,28712,"Есть"]
[79725,28800,"Есть"]
[12190,5072,"Есть"]
[24015,61505,"Есть"]
[34939,46596,"Есть"]
[54781,87526,"Есть"]
[53983,15951,"Есть"]
[22509,33128,"Есть"]
[88597,51504,"Есть"]
[68145,74164,"Есть"]
[10628,31187,"Есть"]
[88112,60727,"Есть"]
[10922,12437,"Есть"]
[67519,14940,"Есть"]
[45207,23316,"Есть"]
[10020,24080,"Есть"]
[94014,69134,"Есть"]
[98543,69919,"Есть"]
[26989,89360,"Есть"]
[62859,25246,"Есть"]
[64685,38388,"Есть"]
[21713,87149,"Есть"]
[83672,7682,"Есть"]
[42979,3394,"Есть"]
[94574,21339,"Есть"]
[46058,45109,"Есть"]
[89360,92796,"Есть"]
[12501,97887,"Есть"]
[52998,27241,"Есть"]
[99557,64560,"Есть"]
[68301,12190,"Есть"]
[78120,14051,"Есть"]
[71569,59501,"Есть"]
[16312,54860,"Есть"]
[29371,31623,"Есть"]
[95642,45480,"Есть"]
[44551,89498,"Есть"]
[45475,59544,"Есть"]
[23310,49666,"Есть"]
[92290,32500,"Есть"]
[44965,36333,"Есть"]
[97914,37785,{"$f":"IF(COUNTIF($B$3:$B$1002,A580)>0,\"Есть\",\"Нет\")","v":"Есть"}]
[26703,27439,"Есть"]
[20742,79623,"Есть"]
[72457,34301,"Есть"]
[7632,68402,"Есть"]
[48717,29480,"Есть"]
[32941,32941,"Есть"]
[23897,53579,"Есть"]
[15951,13089,"Есть"]
[64582,56899,"Есть"]
[85626,51307,"Есть"]
[84751,23224,"Есть"]
[92423,17044,"Есть"]
[72832,23167,"Есть"]
[65640,6742,"Есть"]
[56175,43686,"Есть"]
[72503,21228,"Есть"]
[78281,34065,"Есть"]
[38972,65102,"Есть"]
[92889,84110,"Есть"]
[17977,19591,"Есть"]
[99764,60286,"Есть"]
[29558,97079,"Есть"]
[79776,42456,"Есть"]
[8128,14176,"Есть"]
[4617,35227,"Есть"]
[20822,7436,"Есть"]
[23249,30580,"Есть"]
[54660,12971,"Есть"]
[60918,65649,"Есть"]
[80980,41875,"Есть"]
[71354,37905,"Есть"]
[41371,8143,"Есть"]
[29461,34460,"Есть"]
[18076,1748,"Есть"]
[63633,83008,"Есть"]
[84572,86193,"Есть"]
[62499,11298,"Есть"]
[49795,28587,"Есть"]
[95732,16660,"Есть"]
[27260,45719,"Есть"]
[43224,45840,"Есть"]
[12994,98023,"Есть"]
[19761,62748,"Есть"]
[47044,66092,"Есть"]
[39005,33324,"Есть"]
[83008,71921,"Есть"]
[58405,52847,"Есть"]
[1809,91885,"Есть"]
[86368,42840,"Есть"]
[32693,33516,"Есть"]
[57779,2885,"Есть"]
[87146,29766,"Есть"]
[99733,21313,"Есть"]
[1226,34773,"Есть"]
[52042,14088,"Есть"]
[33516,73849,"Есть"]
[2898,52184,"Есть"]
[99652,56748,"Есть"]
[60752,44965,"Есть"]
[11178,62405,"Есть"]
[83275,46694,"Есть"]
[41173,46863,"Есть"]
[9981,82805,"Есть"]
[74862,43222,{"$f":"IF(COUNTIF($B$3:$B$1002,A644)>0,\"Есть\",\"Нет\")","v":"Есть"}]
[83871,9981,"Есть"]
[83208,30573,"Есть"]
[74169,83524,"Есть"]
[29180,4617,"Есть"]
[3022,4685,"Есть"]
[14176,80082,"Есть"]
[52734,74169,"Есть"]
[11812,48899,"Есть"]
[27885,89154,"Есть"]
[46057,2650,"Есть"]
[58437,58612,"Есть"]
[12420,59952,"Есть"]
[96662,70389,"Есть"]
[48676,70908,"Есть"]
[42484,80980,"Есть"]
[10320,29167,"Есть"]
[79591,79110,"Есть"]
[95757,28423,"Есть"]
[37390,65367,"Есть"]
[37905,61713,"Есть"]
[83677,15675,"Есть"]
[45719,19035,"Есть"]
[28586,79711,"Есть"]
[70819,54186,"Есть"]
[89182,37483,"Нет"]
[38222,66613,"Есть"]
[48780,8128,"Есть"]
[41875,87405,"Есть"]
[6849,24196,"Есть"]
[25464,17417,"Есть"]
[99067,5162,"Нет"]
[77729,56299,"Есть"]
[56899,31965,"Есть"]
[21228,9378,"Есть"]
[94784,16646,"Есть"]
[67303,4518,"Есть"]
[83756,34124,"Есть"]
[77679,26485,"Есть"]
[34124,98383,"Есть"]
[46953,78120,"Есть"]
[83533,4991,"Есть"]
[88909,92764,"Есть"]
[92497,3808,"Есть"]
[16396,97978,"Есть"]
[63271,71144,"Есть"]
[15238,96772,"Есть"]
[48630,56378,"Есть"]
[76380,76366,"Есть"]
[23917,85376,"Есть"]
[33258,92747,"Есть"]
[22438,55723,"Есть"]
[96101,25464,"Есть"]
[67066,49551,"Есть"]
[17629,39005,"Есть"]
[49627,39085,"Есть"]
[98383,16396,"Есть"]
[31435,40994,"Есть"]
[37629,79776,"Есть"]
[77051,55409,"Есть"]
[75592,49795,"Есть"]
[45109,22619,"Есть"]
[86447,28281,"Есть"]
[81828,75992,"Есть"]
[28316,38972,{"$f":"IF(COUNTIF($B$3:$B$1002,A708)>0,\"Есть\",\"Нет\")","v":"Есть"}]
[13516,77309,"Есть"]
[33233,18605,"Есть"]
[17195,34900,"Есть"]
[28781,80011,"Есть"]
[23167,94737,"Есть"]
[94896,84742,"Есть"]
[80121,28651,"Есть"]
[12024,37629,"Есть"]
[77136,51584,"Есть"]
[45643,38369,"Есть"]
[13658,61146,"Есть"]
[86816,34913,"Есть"]
[53300,76832,"Есть"]
[35289,94224,"Есть"]
[18062,93587,"Есть"]
[79332,81905,"Есть"]
[83318,83459,"Есть"]
[46290,46290,"Есть"]
[3644,23112,"Есть"]
[91576,96698,"Есть"]
[65367,39352,"Есть"]
[68551,22499,"Есть"]
[56383,69199,"Есть"]
[94549,88742,"Есть"]
[92631,2204,"Есть"]
[1964,47044,"Есть"]
[37283,92181,"Есть"]
[41174,83971,"Есть"]
[15525,87146,"Есть"]
[78714,75751,"Есть"]
[97486,89074,"Есть"]
[3968,93460,"Есть"]
[18691,73522,"Есть"]
[23316,9261,"Есть"]
[30124,90979,"Есть"]
[40462,22176,"Есть"]
[34725,3791,"Есть"]
[19420,49566,"Есть"]
[32942,14199,"Есть"]
[83372,86770,"Есть"]
[73664,48717,"Есть"]
[18354,36458,"Есть"]
[10640,65839,"Есть"]
[53522,95556,"Есть"]
[82219,81475,"Есть"]
[62422,71985,"Есть"]
[89999,55097,"Есть"]
[96520,29558,"Есть"]
[25759,73664,"Есть"]
[38947,70163,"Есть"]
[70726,12024,"Есть"]
[52172,91687,"Есть"]
[94051,99026,"Есть"]
[53078,4631,"Есть"]
[89074,62341,"Есть"]
[37661,89477,"Есть"]
[40734,47134,"Есть"]
[33324,10677,"Есть"]
[19196,33146,"Есть"]
[65465,67303,"Есть"]
[32564,94784,"Есть"]
[54860,72915,"Есть"]
[87257,99983,"Есть"]
[82029,32980,{"$f":"IF(COUNTIF($B$3:$B$1002,A772)>0,\"Есть\",\"Нет\")","v":"Есть"}]
[38392,86106,"Есть"]
[93571,48630,"Есть"]
[25288,69584,"Есть"]
[31187,45643,"Есть"]
[34900,16312,"Есть"]
[2847,62479,"Есть"]
[31807,47890,"Есть"]
[41337,97586,"Есть"]
[39085,41174,"Есть"]
[10135,67848,"Есть"]
[74164,1964,"Есть"]
[43359,27631,"Есть"]
[66496,99825,"Есть"]
[50229,93836,"Есть"]
[7659,80203,"Есть"]
[7287,57659,"Есть"]
[15211,73567,"Есть"]
[14323,96101,"Есть"]
[16402,36024,"Есть"]
[5736,24319,"Есть"]
[69584,84230,"Есть"]
[23804,40462,"Есть"]
[88918,23922,"Есть"]
[5065,80879,"Есть"]
[39715,92889,"Есть"]
[35800,62266,"Есть"]
[13508,67861,"Есть"]
[77309,45225,"Есть"]
[12696,72700,"Есть"]
[67479,18424,"Есть"]
[91360,15211,"Есть"]
[42840,82219,"Есть"]
[38588,32603,"Есть"]
[49091,3664,"Есть"]
[92407,13516,"Есть"]
[28800,62860,"Есть"]
[39159,17486,"Есть"]
[97771,81979,"Есть"]
[17934,54641,"Есть"]
[62266,23804,"Есть"]
[38369,86204,"Есть"]
[24080,34973,"Есть"]
[95945,13658,"Есть"]
[84170,60752,"Есть"]
[21599,8385,"Есть"]
[51307,26265,"Есть"]
[9261,37260,"Есть"]
[86980,13577,"Есть"]
[17643,53616,"Есть"]
[74511,86447,"Есть"]
[29391,97210,"Есть"]
[79110,13131,"Есть"]
[7436,75029,"Есть"]
[33322,74511,"Есть"]
[96134,84170,"Есть"]
[74104,52172,"Есть"]
[55543,55255,"Есть"]
[12486,16106,"Есть"]
[10937,55357,"Есть"]
[5548,53300,"Есть"]
[70389,67519,"Есть"]
[70163,44409,"Есть"]
[51015,83372,"Есть"]
[62748,34663,{"$f":"IF(COUNTIF($B$3:$B$1002,A836)>0,\"Есть\",\"Нет\")","v":"Есть"}]
[84248,21713,"Есть"]
[90970,33322,"Есть"]
[24196,34725,"Есть"]
[61146,94896,"Есть"]
[62973,34032,"Есть"]
[59783,60874,"Есть"]
[31543,73856,"Есть"]
[25500,77563,"Есть"]
[37483,20216,"Есть"]
[63282,42726,"Есть"]
[66703,64494,"Есть"]
[5799,7632,"Есть"]
[61999,25759,"Есть"]
[19247,69557,"Есть"]
[36024,64582,"Есть"]
[16938,75592,"Есть"]
[98023,25895,"Есть"]
[24605,65465,"Есть"]
[1412,39426,"Есть"]
[3138,94574,"Есть"]
[22076,99557,"Есть"]
[35227,31834,"Есть"]
[51940,77042,"Есть"]
[25121,60550,"Есть"]
[54186,99149,"Есть"]
[65478,17026,"Есть"]
[2204,50181,"Есть"]
[76028,95642,"Есть"]
[23112,26636,"Есть"]
[16507,35388,"Есть"]
[6440,4971,"Есть"]
[21093,23655,"Есть"]
[42339,12994,"Есть"]
[24302,79432,"Есть"]
[9378,13971,"Есть"]
[57068,39159,"Есть"]
[22807,88089,"Есть"]
[40479,55543,"Есть"]
[13851,94549,"Есть"]
[8385,94318,"Есть"]
[2396,30812,"Есть"]
[31836,35800,"Есть"]
[76157,86310,"Есть"]
[34090,12486,"Есть"]
[5162,39715,"Есть"]
[6644,96662,"Есть"]
[29167,33233,"Есть"]
[72508,91576,"Есть"]
[24319,82926,"Есть"]
[65699,5774,"Есть"]
[22184,81828,"Есть"]
[3664,79725,"Есть"]
[29973,41422,"Есть"]
[82113,72503,"Есть"]
[95556,31651,"Есть"]
[34460,12755,"Есть"]
[1612,40479,"Есть"]
[98868,90690,"Есть"]
[77027,74862,"Есть"]
[19591,11437,"Есть"]
[84334,28130,"Есть"]
[58106,72746,"Есть"]
[96856,33344,"Есть"]
[94224,49178,{"$f":"IF(COUNTIF($B$3:$B$1002,A900)>0,\"Есть\",\"Нет\")","v":"Есть"}]
[76832,65699,"Есть"]
[50181,58437,"Есть"]
[38670,79344,"Есть"]
[44409,25126,"Есть"]
[33133,33920,"Есть"]
[92453,26593,"Есть"]
[5078,10640,"Есть"]
[88264,17513,"Есть"]
[97079,2521,"Есть"]
[31834,8583,"Есть"]
[16026,41454,"Есть"]
[97887,3968,"Есть"]
[64560,96520,"Есть"]
[66092,10320,"Есть"]
[28908,38392,"Есть"]
[34032,21093,"Есть"]
[59501,67739,"Есть"]
[2885,33516,"Есть"]
[82426,13646,"Есть"]
[9531,52734,"Есть"]
[46596,72590,"Есть"]
[28572,84326,"Есть"]
[69199,43544,"Есть"]
[80465,33908,"Есть"]
[61792,79777,"Есть"]
[16749,70985,"Есть"]
[28122,80762,"Есть"]
[62082,16507,"Есть"]
[71523,75839,"Есть"]
[49551,97486,"Есть"]
[65478,94804,"Есть"]
[62479,67867,"Есть"]
[54695,78436,"Есть"]
[72700,96138,"Есть"]
[3791,42479,"Есть"]
[51013,28586,"Есть"]
[10419,32453,"Есть"]
[70296,78828,"Нет"]
[45443,75467,"Есть"]
[45480,71354,"Есть"]
[89498,20720,"Есть"]
[66372,39117,"Есть"]
[75029,18062,"Есть"]
[27033,67035,"Есть"]
[57659,37390,"Есть"]
[52184,43401,"Есть"]
[75467,45884,"Есть"]
[77856,51809,"Есть"]
[70537,23310,"Есть"]
[37260,33258,"Есть"]
[73856,76157,"Есть"]
[48584,7287,"Есть"]
[87413,49187,"Есть"]
[26199,16026,"Есть"]
[13089,44716,"Есть"]
[42479,20822,"Есть"]
[2693,53522,"Есть"]
[20216,97775,"Есть"]
[44211,98868,"Есть"]
[33344,12470,"Есть"]
[99149,32942,"Есть"]
[43438,5548,"Есть"]
[51527,80121,"Есть"]
[3205,92423,{"$f":"IF(COUNTIF($B$3:$B$1002,A964)>0,\"Есть\",\"Нет\")","v":"Есть"}]
[40896,83677,"Есть"]
[94953,16794,"Есть"]
[93460,6644,"Есть"]
[5725,31543,"Есть"]
[69134,99652,"Есть"]
[26605,49994,"Есть"]
[76165,6429,"Есть"]
[56378,53748,"Есть"]
[44623,87257,"Есть"]
[39542,1809,"Есть"]
[45884,10135,"Есть"]
[47372,45207,"Есть"]
[98929,35289,"Есть"]
[17513,1305,"Есть"]
[11060,83295,"Есть"]
[83322,14635,"Есть"]
[23395,92395,"Есть"]
[72915,78323,"Есть"]
[86193,81758,"Есть"]
[49666,62082,"Есть"]
[68892,50220,"Есть"]
[28587,95221,"Есть"]
[66446,60292,"Есть"]
[96846,72681,"Нет"]
[87285,70819,"Есть"]
[13362,5078,"Есть"]
[17012,55013,"Есть"]
[60222,22438,"Есть"]
[83680,null,"Есть"]
[92360,null,"Есть"]
[95221,null,"Есть"]
[92747,null,"Есть"]
[1405,null,"Есть"]
[21033,null,"Есть"]
[1394,null,"Есть"]
[35388,null,"Есть"]
[26745,null,"Есть"]
[13971,null,"Есть"]

{"sheet":"Сводная","index":3,"n_rows":33,"n_cols":3,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
["Сумма по полю Стоимость"]
["Название города","Статус","Итог"]
["Архангельск","А",111571147]
[null,"Б",155622612]
[null,"В",12603185]
["Владивосток","А",100093299]
[null,"Б",138220265]
[null,"В",14792231]
["Краснодар","А",105865714]
[null,"Б",125807844]
[null,"В",12475298]
["Москва","А",125581133]
[null,"Б",97454208]
[null,"В",15460310]
["Мурманск","А",91561515]
[null,"Б",115311417]
[null,"В",12519394]
["Новосибирск","А",113446565]
[null,"Б",129496313]
[null,"В",17027686]
["Санкт-Петербург","А",86078707]
[null,"Б",115987357]
[null,"В",14796002]
["Сочи","А",56538890]
[null,"Б",110812210]
[null,"В",22092640]
["Тюмень","А",87710344]
[null,"Б",111802140]
[null,"В",19805473]
["Челябинск","А",99779346]
[null,"Б",162846092]
[null,"В",17923760]
["Общий итог",null,2401083097]