{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["7_","список (для задания 2)"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"7_","index":0,"n_rows":501,"n_cols":5,"rows_kept":501,"cut":false,"hidden":false,"merged":[]}
["Номер договора. Список 1",null,"Номер договора. Список 2"]
[2168,null,2168]
[2176,null,2176]
[2379,null,2379,null,"При анализе данных часто возникает необходимость в сверке 2-х одинаковых с виду, "]
[4535,null,4535,null,"а в действительно незначительно отличающихся списков"]
[4841,null,4841]
[5383,null,5383]
[5619,null,5619]
[5628,null,5628,null,"Задание 7:"]
[5737,null,5737,null,"1. Впишите в ячейку K2 количество договоров из списка в столбце А, которые отсутствуют в столбце B"]
[5775,null,5775,null,"2. Ниже, в ячейках K3, K4, K5 и т.д. расположите список найденных договоров, которые есть в столбце А, но отсутствуют в столбце B"]
[5819,null,5819,null,"Все вспомогательные расчеты на листе сохранять!!!"]
[5853,null,5853]
[5877,null,5877]
[5892,null,5892]
[5918,null,5918]
[5995,null,5995]
[6324,null,6324]
[7584,null,7584]
[7677,null,7677]
[8232,null,8232]
[8253,null,8253]
[8283,null,8283]
[8378,null,8378]
[8462,null,8462]
[8544,null,8544]
[8750,null,8750]
[8779,null,8779]
[8903,null,8903]
[8913,null,8913]
[8931,null,8931]
[9127,null,9127]
[9155,null,9155]
[9188,null,9188]
[9200,null,9200]
[9210,null,9210]
[9229,null,9229]
[9254,null,9254]
[9365,null,9365]
[9501,null,9501]
[9513,null,9513]
[9615,null,9615]
[9639,null,9639]
[9684,null,9684]
[9805,null,9805]
[9855,null,9855]
[9962,null,9962]
[10214,null,10214]
[10323,null,10323]
[10476,null,10476]
[10983,null,10983]
[11079,null,11079]
[11807,null,11807]
[11884,null,11884]
[12103,null,12103]
[12223,null,12223]
[12299,null,12299]
[13617,null,13617]
[13685,null,13685]
[13735,null,13735]
[13892,null,13892]
[13929,null,13929]
[14070,null,14070]
[14079,null,14079]
[14378,null,14378]
[14400,null,14400]
[14411,null,14411]
[14425,null,14425]
[14609,null,14609]
[16716,null,16716]
[16773,null,16773]
[16999,null,16999]
[17098,null,17098]
[17112,null,17112]
[17198,null,17198]
[17310,null,17310]
[17317,null,17317]
[17318,null,17318]
[17324,null,17324]
[17615,null,17615]
[17645,null,17645]
[17657,null,17746]
[17746,null,17783]
[17783,null,17819]
[17819,null,17835]
[17835,null,17850]
[17850,null,17885]
[17885,null,17886]
[17886,null,17903]
[17903,null,17979]
[17979,null,18088]
[18088,null,18456]
[18456,null,18577]
[18577,null,18728]
[18728,null,19241]
[19241,null,19539]
[19539,null,20209]
[20209,null,21127]
[20243,null,21178]
[20791,null,21528]
[21127,null,21529]
[21178,null,21534]
[21528,null,21610]
[21529,null,21660]
[21534,null,21697]
[21610,null,21705]
[21660,null,21721]
[21697,null,21736]
[21705,null,21740]
[21721,null,21765]
[21736,null,21766]
[21740,null,21790]
[21765,null,21792]
[21766,null,21814]
[21790,null,21820]
[21792,null,21831]
[21814,null,21837]
[21820,null,21841]
[21831,null,21860]
[21837,null,21976]
[21841,null,21979]
[21860,null,21997]
[21976,null,22006]
[21979,null,22017]
[21997,null,22065]
[22006,null,22090]
[22017,null,22095]
[22065,null,22224]
[22090,null,22226]
[22095,null,22240]
[22224,null,22250]
[22226,null,22253]
[22240,null,22256]
[22250,null,22268]
[22253,null,22275]
[22256,null,22289]
[22268,null,22298]
[22275,null,22302]
[22289,null,22306]
[22298,null,22309]
[22302,null,22327]
[22306,null,22344]
[22309,null,22425]
[22327,null,22476]
[22344,null,22491]
[22425,null,22531]
[22476,null,22564]
[22491,null,22632]
[22531,null,22665]
[22564,null,22703]
[22632,null,22813]
[22665,null,23201]
[22703,null,23245]
[22813,null,23259]
[23098,null,23346]
[23201,null,23385]
[23245,null,23569]
[23259,null,23612]
[23346,null,23618]
[23367,null,23899]
[23385,null,24757]
[23569,null,24769]
[23612,null,24776]
[23618,null,24903]
[23899,null,24942]
[24757,null,25014]
[24769,null,25053]
[24776,null,25076]
[24903,null,25130]
[24942,null,25136]
[25014,null,25142]
[25053,null,25407]
[25076,null,25409]
[25130,null,25466]
[25136,null,25471]
[25142,null,25511]
[25407,null,25512]
[25409,null,25574]
[25466,null,25594]
[25471,null,25607]
[25511,null,25728]
[25512,null,25742]
[25574,null,25747]
[25594,null,25780]
[25607,null,25789]
[25728,null,25793]
[25742,null,25812]
[25747,null,25823]
[25780,null,25841]
[25789,null,25868]
[25793,null,25876]
[25812,null,25889]
[25823,null,39412]
[25841,null,39431]
[25868,null,39465]
[25876,null,39475]
[25889,null,39534]
[39412,null,39551]
[39431,null,39609]
[39465,null,39675]
[39475,null,39742]
[39534,null,39840]
[39551,null,39895]
[39609,null,39995]
[39675,null,40107]
[39742,null,40144]
[39840,null,40151]
[39895,null,40206]
[39995,null,40235]
[40107,null,40301]
[40144,null,40340]
[40151,null,40443]
[40206,null,40504]
[40235,null,44597]
[40301,null,44601]
[40340,null,44613]
[40443,null,44648]
[40504,null,44672]
[41824,null,44674]
[42521,null,44723]
[44597,null,44773]
[44601,null,44775]
[44613,null,44812]
[44648,null,44918]
[44672,null,44945]
[44674,null,46439]
[44723,null,46477]
[44773,null,46489]
[44775,null,46518]
[44812,null,46561]
[44918,null,46565]
[44945,null,46568]
[46046,null,46609]
[46439,null,46665]
[46477,null,47348]
[46489,null,47447]
[46518,null,47476]
[46561,null,47635]
[46565,null,47652]
[46568,null,47657]
[46580,null,47726]
[46609,null,47873]
[46665,null,48003]
[46828,null,48055]
[47348,null,48085]
[47362,null,48087]
[47447,null,48226]
[47476,null,48278]
[47635,null,48294]
[47652,null,48303]
[47657,null,48314]
[47726,null,48325]
[47873,null,48341]
[48003,null,48427]
[48055,null,48452]
[48085,null,48454]
[48087,null,48474]
[48226,null,48566]
[48278,null,48626]
[48294,null,48719]
[48303,null,48739]
[48314,null,48773]
[48325,null,48786]
[48333,null,48795]
[48341,null,48823]
[48427,null,48900]
[48452,null,48959]
[48454,null,48968]
[48474,null,48969]
[48566,null,48997]
[48626,null,49009]
[48719,null,49018]
[48739,null,49044]
[48773,null,49052]
[48786,null,49056]
[48795,null,49060]
[48823,null,49107]
[48900,null,49159]
[48959,null,49181]
[48968,null,49301]
[48969,null,49315]
[48997,null,49391]
[49009,null,49414]
[49018,null,49441]
[49044,null,49446]
[49052,null,49529]
[49056,null,49627]
[49060,null,49640]
[49107,null,49641]
[49159,null,49669]
[49181,null,49691]
[49301,null,49745]
[49315,null,49808]
[49391,null,49821]
[49414,null,49861]
[49441,null,49871]
[49446,null,49875]
[49529,null,49899]
[49627,null,49910]
[49640,null,50019]
[49641,null,50034]
[49669,null,50051]
[49691,null,50052]
[49745,null,50059]
[49808,null,50068]
[49821,null,50077]
[49861,null,50087]
[49871,null,50182]
[49875,null,50189]
[49899,null,50193]
[49910,null,50213]
[50019,null,50238]
[50034,null,50357]
[50051,null,50368]
[50052,null,50377]
[50068,null,50392]
[50077,null,50394]
[50087,null,50396]
[50182,null,50406]
[50189,null,50425]
[50193,null,50426]
[50213,null,50432]
[50238,null,50435]
[50357,null,50446]
[50368,null,50504]
[50377,null,50505]
[50392,null,50592]
[50394,null,50596]
[50396,null,50598]
[50406,null,50609]
[50425,null,50613]
[50426,null,50632]
[50432,null,50654]
[50435,null,50660]
[50446,null,50676]
[50504,null,50690]
[50505,null,50718]
[50596,null,50726]
[50598,null,50745]
[50609,null,50758]
[50613,null,50807]
[50632,null,50816]
[50654,null,50821]
[50660,null,50828]
[50676,null,50845]
[50690,null,50868]
[50718,null,50874]
[50726,null,50876]
[50745,null,50894]
[50758,null,50899]
[50807,null,50949]
[50816,null,52477]
[50821,null,52584]
[50828,null,52588]
[50845,null,52596]
[50868,null,52606]
[50874,null,52610]
[50876,null,52691]
[50894,null,52710]
[50899,null,52728]
[50949,null,52786]
[51908,null,52798]
[52477,null,52799]
[52584,null,52824]
[52588,null,52861]
[52596,null,52874]
[52606,null,52877]
[52610,null,52909]
[52691,null,52914]
[52710,null,52916]
[52728,null,52922]
[52786,null,52937]
[52798,null,52993]
[52799,null,53042]
[52824,null,53066]
[52861,null,53071]
[52874,null,53073]
[52877,null,53100]
[52909,null,53103]
[52914,null,53123]
[52916,null,53198]
[52922,null,53219]
[52937,null,53228]
[52993,null,53231]
[53042,null,53254]
[53066,null,53255]
[53071,null,53297]
[53073,null,53318]
[53100,null,53321]
[53103,null,53323]
[53123,null,53420]
[53198,null,53436]
[53219,null,53531]
[53228,null,53574]
[53231,null,53582]
[53254,null,53591]
[53255,null,53628]
[53297,null,53629]
[53318,null,53649]
[53321,null,53675]
[53323,null,53714]
[53420,null,53736]
[53436,null,53774]
[53531,null,53836]
[53574,null,53856]
[53582,null,53905]
[53591,null,53937]
[53628,null,53943]
[53629,null,53955]
[53649,null,54024]
[53675,null,54034]
[53714,null,54035]
[53736,null,54054]
[53774,null,54068]
[53836,null,54075]
[53856,null,54078]
[53905,null,54109]
[53937,null,54110]
[53943,null,54123]
[53955,null,54126]
[54024,null,54142]
[54034,null,54143]
[54035,null,54150]
[54054,null,54152]
[54068,null,54179]
[54075,null,54181]
[54078,null,54191]
[54109,null,54208]
[54110,null,54231]
[54123,null,54235]
[54126,null,54244]
[54142,null,54391]
[54143,null,54441]
[54150,null,54446]
[54152,null,54461]
[54179,null,54499]
[54181,null,54612]
[54191,null,54624]
[54208,null,54634]
[54231,null,54659]
[54235,null,54678]
[54244,null,54697]
[54391,null,54700]
[54441,null,54742]
[54446,null,54755]
[54461,null,54758]
[54499,null,54766]
[54612,null,54789]
[54624,null,54793]
[54634,null,54798]
[54659,null,54812]
[54678,null,54876]
[54697,null,54898]
[54700,null,54901]
[54742,null,54903]
[54755,null,54913]
[54758,null,54916]
[54766,null,54917]
[54789,null,54974]
[54793,null,54975]
[54798,null,54977]
[54812,null,54980]
[54876,null,55014]
[54898,null,55033]
[54901,null,55055]
[54903,null,55069]
[54913,null,55094]
[54916,null,55103]
[54917,null,55120]
[54974,null,55135]
[54975,null,55139]
[54977,null,55173]
[54980,null,55174]
[55014,null,55192]
[55033,null,55208]
[55055,null,55225]
[55069,null,55228]
[55094,null,55237]
[55103,null,55263]
[55120,null,55272]
[55135,null,55283]
[55139,null,55306]
[55173,null,55314]
[55174,null,55319]
[55192,null,55322]
[55208,null,55323]
[55225,null,55327]
[55228,null,55332]
[55237,null,55338]
[55263,null,55375]
[55272,null,55385]
[55283,null,55388]
[55306,null,55398]
[55314,null,55400]
[55319,null,55434]
[55322,null,55437]
[55323,null,55451]
[55327,null,55462]
[55332,null,55466]
[55338,null,55471]
[55375,null,55487]

{"sheet":"список (для задания 2)","index":1,"n_rows":8,"n_cols":1,"rows_kept":8,"cut":false,"hidden":true,"merged":[]}
["Список"]
["Вашингтон"]
["Калифорния"]
["Мичиган"]
["Нью-йорк"]
["Техас"]
["Филадельфия"]
["Юта"]