{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Задание_09","Задание_10","Задание_10 (2)"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Задание_09","index":0,"n_rows":100,"n_cols":10,"rows_kept":100,"cut":false,"hidden":false,"merged":[]}
[58454112,34376821,18765441,63631225,76124776,81546661,74342344,18238436,44151465,41737787]
[27321675,41247671,33785816,24175121,84727452,13164755,32527542,21437287,51327322,11428451]
[78516336,25872568,62534885,88215165,57716214,26381152,57467264,32368171,86727237,34654254]
[44282455,55447858,52382534,23153827,88355567,62238882,11486667,46887223,77745166,66762785]
[61317832,28848465,57371478,68263428,24636814,51574583,61757723,23378332,41877455,41686644]
[82433855,44665168,28851173,15843736,53541576,43887151,34615686,71734143,67386736,41114226]
[28176284,34854252,53163174,35444388,42811455,42412217,16742767,85868182,71887326,21558381]
[64255467,56154536,27784526,27486115,44773581,51815551,15565713,58723515,83362485,76253182]
[12115823,36733173,55433573,31717762,38728464,34568741,65617628,43237535,86111748,16137166]
[84271287,53483213,54514288,41664474,82615635,66438362,37787141,55712281,17313357,36123161]
[78266841,81822526,86163826,48532481,27337655,74224277,87212486,28233121,37118535,75661441]
[82253585,52162212,73164528,55174276,48152621,83788488,78247121,67328162,27155152,12276437]
[87475411,24664368,38881348,82245766,62272471,21828637,27471246,34416465,31828741,55641111]
[34362428,42722627,76443467,87158477,57718134,34416825,88773621,13867555,25675368,26165417]
[31763778,41673266,41234847,87365743,46688128,64446414,42458455,28551472,67768151,67828887]
[34885854,87287211,24731838,65544656,28458242,37217622,61813725,18484288,82684272,11544431]
[76827687,22154351,46473712,83885553,58331368,87623571,66713623,37682335,71222864,56223268]
[77465234,41558428,23868226,66525854,68453177,63381227,37258731,43883544,51423816,41658455]
[87485847,34847127,42283454,82254583,43672154,56777314,14283861,54758482,67768325,16772271]
[31857778,12124658,48672871,84575862,34625372,22143545,36478314,28656813,51786281,18732385]
[17231883,76683358,26581356,72634543,58857446,72282483,37465353,78584452,85526347,26166551]
[53222557,86315133,33878761,42144216,74344712,21817283,18547816,33316582,51114585,33574445]
[12643738,87213786,38622678,15118235,65116774,72746872,24831255,52621265,36625337,36861322]
[47753565,43266262,16237778,68677127,12638443,84711515,75256821,48686837,43354283,56661346]
[17123447,34386673,16148338,15284724,71671715,22332712,71167471,26823858,11625276,13288418]
[18217126,37777654,53173323,34844563,31282622,23748445,53746343,18816782,52268421,43457656]
[37225551,61271416,51337838,57427785,43363524,76114652,38553647,58551228,38228523,18182517]
[84318448,46447753,42377841,38752437,88778864,71313785,65144742,34234268,15574615,82847688]
[35174542,15436556,44422744,72162731,88288173,55534822,32328382,78275444,56235813,54218328]
[62234614,13667616,22881312,78823237,55586842,11623172,15344176,11382473,84486727,18752542]
[75731556,88657254,43631428,87818678,33277661,88486742,66586521,15361555,76778384,68845464]
[36283724,53334731,85431588,32313328,24715857,41146642,44648231,13755142,78376743,51864751]
[16734516,66741475,66544386,68856676,34181284,41626156,41626223,13153721,18645615,88515216]
[81718866,57573216,76211721,46771534,17246887,41238436,15861512,74163856,14676883,77523286]
[22868223,22143675,45537465,62443221,53432467,66424555,74523121,56568623,44414767,36141125]
[13826717,88545527,13364732,15844176,44475611,82612351,37653565,24262862,17341728,72637854]
[72151548,35127474,23716122,85558888,33116544,85361534,43172477,46363633,66164827,73188517]
[23523118,12133571,55521385,43225871,14661765,41175726,82214153,47846432,51345271,77132147]
[64447464,66247784,85511483,88368525,58434122,46756217,12451553,23155784,52573358,67166676]
[42217734,33772432,24538283,86452755,88321566,12126255,86684178,14172865,33183152,23568216]
[86473285,61757868,41218216,27577563,33814567,66182558,77882364,37524258,17613755,55367616]
[75383327,23786132,15632841,25647471,23647118,67773346,21754847,61525242,58285776,57386288]
[81858735,11768286,38386485,36454288,73183836,47233135,74587443,68227216,45825264,12742765]
[72745117,72651475,66783876,33365751,24827733,18663463,47341187,21875445,78315864,13445112]
[81681448,87651155,85168214,64441134,73114352,82612445,73165134,25417544,48457643,45141641]
[27621846,26684177,65162173,34855468,62887616,41227531,28441378,68684682,61723115,53626167]
[11828423,53316717,16466711,22428267,78816238,37232523,51744684,25766274,64238537,75655474]
[77337745,84762276,16766221,64364576,58286733,28265377,47333716,73588628,16716463,76775715]
[28313546,57433377,77167222,73126586,18333241,31618421,15214854,25531281,38731667,87715132]
[66212282,54132642,73521716,14568243,88128281,26712584,37641674,12765187,21827373,24811876]
[68337742,58478242,54646842,13763756,76766235,45472615,68727735,28528132,54825864,46537858]
[51376452,27814657,53257417,46157262,41537654,13326245,35338442,47624812,42184263,75481574]
[13817163,86685732,65222443,11136566,52343437,88782887,84614361,15513326,85528363,42474876]
[81548477,71721331,85776666,85465836,42511776,34343644,82374157,26656565,57211624,76758143]
[15574826,68866436,18638114,17313558,23111347,25652887,56111858,16165866,45762361,24856616]
[66487263,78686316,63665676,88345117,26657651,16525441,37877426,54648527,43667188,55858772]
[76415163,42227832,84642424,76877178,66571453,56768173,66376487,85224246,85242665,45354582]
[16557822,14431357,21357751,25865245,67372771,21331284,51842835,31856538,21288535,71768561]
[67377453,11487775,32832425,74621513,45586684,78473517,53327512,47115313,75516261,64632831]
[54573373,47628367,85688538,57635343,35447326,56778118,14848148,47582673,37537757,44787514]
[22225843,62446785,74415252,47462548,83846316,21242282,71821532,43182175,67578258,26434412]
[62631836,84787742,36756582,42867884,76832328,33673362,42251521,82265384,45652331,61651175]
[84346377,38641714,37433388,68534122,14856677,82552757,24342767,41156365,21621778,25252757]
[42228136,21581146,47258112,82626461,24325768,84686547,72753443,48644712,54172354,78118455]
[33234817,75234855,82243257,32284263,67117427,57627558,73843827,74826337,41368851,33123532]
[16674728,77314114,52188285,71161518,43851785,81888578,22688131,57282176,71338145,67113584]
[31362824,75145527,75452851,12432481,24786546,83567864,77618883,51718351,78122424,26356712]
[84847622,66128747,87532581,28228516,22871223,54668278,87315833,23722112,61138132,28171473]
[68754372,38826418,54354651,17766375,27416218,86875472,73245841,56386142,61872415,83222477]
[65287614,12666563,34555877,82774475,87264535,61568854,81178881,47445282,64688185,47544331]
[16741557,75461432,14887625,41223856,55886573,18243233,73881354,26862513,18288388,83523278]
[33535662,32884717,53558338,76621875,64132114,85524232,11217825,78626785,74288387,72441862]
[68782363,61514662,22635754,72286372,13738567,74555273,56225744,11731718,85234786,63447263]
[88782817,14676323,88144153,23816757,66175744,71512771,44216315,17723754,34452766,11854778]
[68482445,87445573,48441788,11226724,34776114,88162888,56723214,76243317,48762638,15743115]
[13612172,34534321,71887615,33832885,22268416,46832716,47748525,85845271,62142257,25187255]
[78746313,37576766,28868174,13654286,61766147,41244168,34672726,62348637,34737342,81271315]
[24364744,34852717,86275147,12147722,17571758,77325515,72473518,77716388,37235313,32653386]
[56815152,31668454,48538686,32423417,87245245,71656546,56168858,77123812,36441131,71443785]
[44857387,33621522,21377863,85461867,11211775,34518423,46237258,88178511,43314225,66524542]
[37528481,51742311,86682436,38278535,26256836,31534365,32345212,78318153,54361475,15447728]
[87324638,18181324,64646866,65186813,51161873,82581322,58616778,13143883,13718111,31647858]
[26181441,62842182,33141434,71321835,86682412,11115123,11264615,51238587,27882427,54324654]
[13188515,55278117,17217316,22125822,67635417,35866384,55664131,18866352,54566526,74435343]
[64526257,73628318,81583545,86268415,32567546,84432387,37673385,11442287,72452213,44532218]
[58362667,75682187,68157135,62262336,42353322,68154556,16486561,23382111,77683314,53418111]
[76345118,26651882,66476345,86527718,56834727,26427832,67118667,48452683,33756327,87864116]
[38527231,47482713,63477144,41387468,53253427,51714546,13265474,82175568,55557456,75433676]
[43538613,45888276,48263426,34413258,41421825,58257258,38525422,52455248,67678151,55448612]
[45284386,13566334,21818757,38462387,37846312,57386325,71432177,74383736,11684311,48564845]
[84371162,36644378,71555727,76844245,35642778,67782478,64184471,84481323,27723733,16183278]
[37233486,52386343,62586587,28874627,83472231,55731674,55231617,74235657,72856362,37234867]
[74375351,85367158,12438574,61511264,64624556,52681377,15452787,73848523,46874322,66588421]
[84522518,17283356,64227342,24376133,38643246,76126132,28331435,15435666,37323323,45834882]
[88784744,56574458,18855184,27877358,52565622,62546781,57135131,42663882,32481271,57318366]
[77642621,21242713,33353174,74515872,36122142,68633824,42351135,26826123,52363346,48428432]
[35365324,62367442,83683146,72272565,77756666,52557867,83288627,32511553,58724232,35561763]
[43833833,48418463,58363831,56545145,22248253,82834113,41713122,55516666,77357567,81876252]
[26584532,25867565,13315362,38438567,63272631,86663278,57524762,38878724,71567876,63412514]
[17443185,64176437,84275628,55768486,21761217,37122461,88443752,35856682,44314625,78626363]

{"sheet":"Задание_10","index":1,"n_rows":1415,"n_cols":108,"rows_kept":1415,"cut":false,"hidden":true,"merged":[]}
["Регион","Площадь","Номер",null,null,null,null,"Задание: Не используя сортировку, написать макрос нумерующий регионы по площади."]
["Алтайский край",168,null,null,null,null,null,"Примечание:"]
["Архангельская обл",589.9,null,null,null,null,null,"Запуск макроса осуществлять при нажатии клавиш Ctrl+Q"]
["Астраханская область",49,null,null,null,null,null,"Пример:"]
["Белгородская область",27.1,null,null,null,null,null,"Регион","Площадь","Номер"]
["Брянская область",34.9,null,null,null,null,null,"Алтайский край",168,2]
["Волгоградская область",112.9,null,null,null,null,null,"Архангельская обл",589.9,1]
["Воронежская область",52.2,null,null,null,null,null,"Астраханская область",49,3]
["Ивановская область",21.4,null,null,null,null,null,"Белгородская область",27.1,5]
["Иркутская область",774.8,null,null,null,null,null,"Брянская область",34.9,4]
["Кемеровская область",95.7]
["Кировская область",120.4]
["Краснодарский край",75.5]
["Красноярский край",2366.8000000000002]
["Курганская область",71.5]
["Курская область",30]
["Ленинградская область",83.9]
["Липецкая область",24]
["Московская область",45.8]
["Мурманская область",144.9]
["Нижегородская область",76.599999999999994]
["Новосибирская область",177.8]
["Омская область",141.1]
["Оренбургская область",123.7]
["Пензенская область",43.4]
["Пермский край",160.19999999999999]
["Приморский край",164.7]
["Республика Башкортостан",142.9]
["Республика Бурятия",351.3]
["Республика Татарстан",67.8]
["Ростовская область",101]
["Рязанская область",39.6]
["Самарская область",53.6]
["Саратовская область",101.2]
["Сахалинская область",87.1]
["Свердловская область",194.3]
["Смоленская обл",49.8]
["Ставропольский край",66.2]
["Тверская область",84.2]
["Томская область",314.39999999999998]
["Тульская обл",25.7]
["Тюменская область",1464.2]
["Удмуртская Республика",42.1]
["Ульяновская область",37.200000000000003]
["Хабаровский край",787.6]
["Ханты-Мансийский авт.округ-Югра",534.79999999999995]
["Челябинская область",88.5]
["Чувашская республика",18.3]
["ЯНАО",769.3]
["Ярославская область",36.200000000000003]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Application.Calculation = xlCalculationManual\nSet rng = Selection\nN = Selection.Rows.Count\nReDim ms(N)\nFor i = 1 To N\n    ms(i - 1) = Cells(Selection.Row + i - 1, Selection.Column)\nNext i\nFor i = 1 To N\na = Application.Max(rng)\nWith rng\n    Set b = .Find(a)\n    If Not b Is Nothing Then\n        Cells(b.Row, b.Column + 1) = i\n        Cells(b.Row, b.Column).ClearContents\n    End If\nEnd With\nNext i\nFor i = 1 To N\n    Cells(Selection.Row + i - 1, Selection.Column) = ms(i - 1)\nNext i\nApplication.Calculation = xlCalculationAutomatic"]

{"sheet":"Задание_10 (2)","index":2,"n_rows":1415,"n_cols":108,"rows_kept":1415,"cut":false,"hidden":true,"merged":[]}
["Регион","Площадь","Номер",null,null,null,null,"Задание: Не используя сортировку, написать макрос нумерующий регионы по площади."]
["Красноярский край",2366.8000000000002,1]
["Тюменская область",1464.2,2]
["Хабаровский край",787.6,3]
["Иркутская область",774.8,4,null,null,null,null,"Брянская область",34.9,4]
["ЯНАО",769.3,5]
["Архангельская обл",589.9,6,null,null,null,null,"Запуск макроса осуществлять при нажатии клавиш Ctrl+Q"]
["Ханты-Мансийский авт.округ-Югра",534.79999999999995,7]
["Республика Бурятия",351.3,8]
["Томская область",314.39999999999998,9]
["Свердловская область",194.3,10]
["Новосибирская область",177.8,11]
["Алтайский край",168,12,null,null,null,null,"Примечание:"]
["Приморский край",164.7,13]
["Пермский край",160.19999999999999,14]
["Мурманская область",144.9,15]
["Республика Башкортостан",142.9,16]
["Омская область",141.1,17]
["Оренбургская область",123.7,18]
["Кировская область",120.4,19]
["Волгоградская область",112.9,20,null,null,null,null,"Архангельская обл",589.9,1]
["Саратовская область",101.2,21]
["Ростовская область",101,22]
["Кемеровская область",95.7,23]
["Челябинская область",88.5,24]
["Сахалинская область",87.1,25]
["Тверская область",84.2,26]
["Ленинградская область",83.9,27]
["Нижегородская область",76.599999999999994,28]
["Краснодарский край",75.5,29]
["Курганская область",71.5,30]
["Республика Татарстан",67.8,31]
["Ставропольский край",66.2,32]
["Самарская область",53.6,33]
["Воронежская область",52.2,34,null,null,null,null,"Астраханская область",49,3]
["Смоленская обл",49.8,35]
["Астраханская область",49,36,null,null,null,null,"Пример:"]
["Московская область",45.8,37]
["Пензенская область",43.4,38]
["Удмуртская Республика",42.1,39]
["Рязанская область",39.6,40]
["Ульяновская область",37.200000000000003,41]
["Ярославская область",36.200000000000003,42]
["Брянская область",34.9,43,null,null,null,null,"Алтайский край",168,2]
["Курская область",30,44]
["Белгородская область",27.1,45,null,null,null,null,"Регион","Площадь","Номер"]
["Тульская обл",25.7,46]
["Липецкая область",24,47]
["Ивановская область",21.4,48,null,null,null,null,"Белгородская область",27.1,5]
["Чувашская республика",18.3,49]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Application.Calculation = xlCalculationManual\nSet rng = Selection\nN = Selection.Rows.Count\nReDim ms(N)\nFor i = 1 To N\n    ms(i - 1) = Cells(Selection.Row + i - 1, Selection.Column)\nNext i\nFor i = 1 To N\na = Application.Max(rng)\nWith rng\n    Set b = .Find(a)\n    If Not b Is Nothing Then\n        Cells(b.Row, b.Column + 1) = i\n        Cells(b.Row, b.Column).ClearContents\n    End If\nEnd With\nNext i\nFor i = 1 To N\n    Cells(Selection.Row + i - 1, Selection.Column) = ms(i - 1)\nNext i\nApplication.Calculation = xlCalculationAutomatic"]