Новая статья: Столбец из примеров - искусственный интеллект в Power Query

Одно из самых просматриваемых видео у меня на YouTube-канале - это видео про Мгновенное заполнение (Flash Fill) в Microsoft Excel. Суть этого инструмента в том, что если вам надо как-то преобразовать ваши исходные данные, то достаточно просто начать набирать в соседнем с ними столбце тот результат, который вы хотите получить. После нескольких вручную набранных ячеек (обычно хватает 2-3) Excel "поймёт" логику нужных вам преобразований и автоматически продолжит набранное, завершив всю монотонную работу за вас.

Квинтэссенция эффективности. Волшебная кнопка "сделать всё хорошо", которую мы все так любим, правда?

На самом деле, аналог подобного инструмента есть и в Power Query - там он называется Столбец из примеров (Column from Examples). По сути, это маленький встроенный в Power Query искусственный интеллект, который умеет быстро обучаться на ваших данных и затем их преобразовывать.  Давайте детально рассмотрим его возможности на нескольких практических сценариях, чтобы понять, где он может нам с вами пригодиться в реальных задачах.



Читать статью полностью
21 апреля 2022 13:44
Индексация строк
Добрый день.
В PoverQuery столкнулся с проблемой создать индексированный столбец по условию.
Упрощенно надо по порядку пронумеровать единички (пример ниже)
[img]data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAMAAAADvCAYAAACkJtvkAAAgAElEQVR4nOydd5wdVfn/38+ZmVu2pxcSQgtSQpEmoUgRqUoRv/K10KRJb9JExAqoiDQFG/AVBRSkigI/OkpLAkhvQgiEkrLZzZbbZs7z++PMLRuCwt4bsrPJJ6+7mXvv3Jk55znPOc/znKfI4sWL1RjD7NmzWXPNNYmiiOEGVcUYQ39/P319fYwdOxZr7fJ+rGUCYwxvv/02o0aNIpVKoarL+5GWCVSVuXPnMmXKlLrGrMyePVt93+ell16iubl52HYYuMFRbt9wbaeIVI6HaxuhcbT0fd8nlUoxd+5cPv3pT1MsFhv1jEMKqVSKGTNmcP/993PmmWfS29u7vB9pmaCtrY1jjz2WY445hsmTJxOG4fJ+pIbDGEOxWOToo4/muuuuo7u7e9DX8ltbW8lkMlhrmTJlSgMfc+jh6aef5uWXX2bChAnL+1GWKWbMmMHYsWNZffXVl/ejLDOUSiXuu+8+xo4dy9ixYwd9HaOqw1YeXhKqiu/7y/sxBkAVVC1uFdf4VR+CIPhgmtZeXrV6xyVvqzb+3FZ+pwqKDji3+l7jNtj3fV6+Sc3d0Phf+XPF0af8P5U+WTqstXie91964r/D1H2FlagLisZjTN83uJYJBMLcQu647wGI9QWrFgRmv/QUz7w2u/JkFutGfXWIYlHQiAjHuNVhXX72ELDuFwqWWgXVnV++fvXYnS8iCLEeI4YadWaZYSUDLG+oYjxH7AgFlj3VO9+ZyW47bg+AKHjxOLzoh2fy3R9f6R5LPDwNiYypzOmCBTVYAx4hiCDWgLhhLmLBpsC6dqgBVECs+w+hPOhFQdyHKIJBIFxMxksDMKIlw6vvDV62/7BYyQDLGZEqF/zqNkDwI4OltMzvGfgpYLS7vyjlYdDSEtDamgViNpQUFjCEiBgQD0/K3/oIghU3fH0MiHGXMh5qLQbFiIctX899Eq96go1lHIMBDcFv440XnmTvffbmxvsfY61x7cu8L1YywHJG4Hlceu3j/OBXfwNPEK1frv1v8KKSm4IBD6mMgrbWUWiQAkJEhAgInFCCiOHkww5AvHYMhifuu45xa22HEeG2319cMb/6Irz6bi+e8Zj76uP4qbEYDN896st847QfOaYBEIsxhmO+ti+nnvtLEB8Rg7/aetx8081s0F4gaBm/zPuiAQygA19aVmzcd4rWqEW1MmBCoNU2Vd/TmFeMkSPbuPTqx/jxr29DjAFVIsKKYqw0dnPSpJpBFzqZu+Z16k+vYERzM+Cz6eodXPLHewC479pLWH/bvfjZb37Pift/lpN+8jvGtrfQX3TMuueBxxOpAgUnCqWbAMh6IVHJmWGD/j5Kxg03D0GM+63N99EfloehUoqbuv02OxHapoa2e2loqEnk/RKsxjIgYBU1H4eE21hYBDcXCoo4ORePiomiKtZ+5GOJe0NCZc0N1+fSq5/CGMMph+6BWAGJwHpOWW1gx0VhAcgyd/4cehfMI8KjuaWJc04+gkX9PQCcffpJHHfxzzjhq5/hhz86n2+efzsAF1x1BSNGTOVT475Dc6rIuWceyeGnXhDPpG70zn75FbKTW3hj9huAE6loaeWhW2/hTK+PSNJ8/bCvs/aqq2AwGK/auLYs/N+l3+Zzhx7NSxdc27hGfwDqYIDycK8+vMXRyqAIimIQIqcooSjex6TmNQ7OKuHhWAEgFlFqTRTC4I8BJML4I1l7089w0f/9nUjh9MP2cMqksYg2VlK16gFpJo4eDaNHVz4fP7aZ1+IZ+/OHH8WeR3wHUO597m3u2XXj+Kws7S0eN9x+J/nF73LL33rY/4zd4u88ssD+//M50n6E5vqQ9jYAgijEb80yYcw4ervn8Ykpk7j36bfINKcJayy2WeDkH13LO6/ez4/P+XVD2700NIABqu+9yvtYbgSIB49jhyj+LimqhyISMW9xhOd5GCyKa08jICJ4gY96ikQRfibDeptuz0W/fxAxKU475LNgLaGE+A1crEUt1TaUj31sSZF0EH8+il03m8qXv/wldtzvG5XfTl9zAod+/woO2ayJ9Wacx6NP3o2IMH3rRWyySpYc8PZrr9DhQ7joWYKROwBQKhTZdo8vcszxRwOw6gjLz358GZu2pFhoXNuynmHTjTfjmlvvJN/9Dh+HuNygXnW2ght+/yuef3UuoR/g2ZBSaBk9eS1OOOJArAoeIdpYqWsZQ+iPYOr0b9A8clUMedAAa2xZh3QS3iCPAXwM6fZWWk2I2ALqN7PBpjvw86vuw1DilEN2x9fGblTaqAQsrrwvT139uT76g57K52f94Ey23u0g7nryNQAeuvlXPPpaH48cvCeP3/EbuhY6M+U9f76ETVfbEC3NAWDuwiId41LMf+9toAuACMtfr/4N3w0X0rXwHS76xeU88vI8rj39y+TH9AGQiyxzepvZefO1eOfFe4C+hrZ7aahjNC4p2MJF557LrLk9TJk0DlsqUSiFrLfZNpxwxIGIxiJRLDooQGQREwGeM6EBWEtkBKNS3RxRsGLjzyIUHyMRTqlYtgKVb4Rsxximbf4Zdy/VBt9TsFhEfSK1KAbPz7DBJtty4VUPgyqnHLoHqFtHJTZD1vMETePW5/yLL4/fVVfjL379WLqDcZX3W+26OyB8dmPnUvHeYmHmi88DsNq0bbn8Emem3PF/juH8FzvpKha4+MILWKXNXbNt4gZcePFlAHzu0OMJPjEDjUJGT1yTf8+dzxoTR1M8/Fh09JoAXHrhBXzuywcB0D5hXS68+Bd1tPLDQbq6ujSdTvOnP/2JAw888CP+vDwzOZFn66mTOfySv3DgrlsMOKuoEFA7btyKARBpiCfv50OrYCrnV8WtKAJjLCKKqjPPfVjceuutXH755fztb3/70L8pacSkbc9g4y0+h5U0EMbM2tjluTKVqKLGbQzZUoEXZt3FyV/fmpMO3gNsASQAKVvWl24yXXvttbn55ptZb731Purd3X82DybDaYd/lTcza3PNxWejtjpHDQUUCgWam5vrdvZrQJOqc5HRCM97/yV9LCLw/aMOik1uHiLCOZf8AU98Zt7z54opLts2kUWRG/xnH7d//LlbOX5y4dV4Hk4pVA+VZS8jDoRWXAMajbI5QRFELVYjCJpYd5PP8tPf/Yvzr7gDTNrJUNbngwb/4ODapQo2UjAZNlp7Vf784Mtcc/HZAEREibNgfxg0aB/AYeSodvbfefPKYG5pb+e8S67EiKFv3ov86rZ/OIcnVbT3Dc48bn8A/v73h7j6r/ehquy37XiO+dbPoPgmv73p0er5PW9y2okHuBuJoqJ1CgKDa+YyHwOiiPUwFtASJpVhvc224IKrZvDz390NRoiwld2VxsDE4mSEek70/NfLc3j9xRkAqLX4DTbFDhU0VCPt6+vj4BO/w5d22oJCscQbs1/k+OO+TjByIid/dRfmzn6cU44/mhkznuKZR2Zi0h0AnHX+JZCfzxbTpjLjuVdZcPsTAMx9fQYnnXAsT854jCceeQLi8xEnRHkfs01VB/zfGFaQmqPYSybWdwxgsWpJp1qZOu1TfPuim/nkeuPZfvq02AWtgTDON8fED2WJMJFH6BXwCQgFPD7mSedjQJ0rgMFiKJMxX1A2224Xdt19D/bae2+OO+F0Tjl4J/5+6/+D/BzEH4Xfvgrf/8n5vN39b2yhaokgM5rf/PEatlhzAj+/+I/QPQcJRpBqG893f3IxnQtnQ8FZFFB14sLH4S5Y3swz5V0AD2JHrka8VN3sq4BohKjGZiJBrI8YS77Yz8vPPMK5p+zN9tOnVZ9rsO0ZIM5UPTLLyrWAY0ADhhSI4GnZ6KFLXGtp/eW8RtXGrvZWKan7XzV0XqY2qtxVBxxF1d33pJlBI4URLdkB31x73d3s+52vcuefb2Dqlp/j3O9/C4A///K7lBlni/XX5Mo7Z7LRRptz4vH7c/Gd/+DekQv4xJa7ct73zwTgT788C0jF6rB8bDsJBjCxSwIS+2tqAxnPxK7AKogaBCUSJfJKeNqMFvM8P+M+zvjGNhy3/06VMSiDFkkGbl7GayluCag5R8sfufsIuImg8rXbP5DaIVTuJ2fLqv4e51Ok4ix4qmCNxhum5XPcLoup3CbeSl1CP2806mSAqp8fQMaP+MpOm/CVmjNMy6r87PSD8OjklQNPZuon1kMkZOSIEUBEEfjK53dk2uSR7LDddtz3wAPc/dxsdlyvnZf2P4G11l0fLwoZOWoEUKQXaBXBEgLeMmeECKmsNIrvFO8GKd+OmeNd8viaqgaxHvhFotIinn/8H5x59DYc+9WdwYJKbDrW4D9e+wPvqcSenbXvy2NXa8zUGjNa+ZzyQXWID5iGFJyh1u2ch/nFnPTNY3n4sRfwfeWxR2eSVyVNAdW0u77Egp8KKiYe+QYrca9UGKoclOM1nBEasAKUZxD43c13sqC/RCAGjZTWlhamrjMV5yMyElXloQceZNLUqaw+cQKzZs4izBc54bzfcOA3z+WJp//F3TveX+lWVeXB+x9g8tpru/NnzcAWQkj7iFYnpGUJW57ttOSEPQWnNDbAF0iE6qAxbhCIxQOivPLSrIc4/Yit3OBX3Aokbtd2sNKfG8fVgS7ioWpjpqjRSGKRz9oIY+JVw4izTsVKmJiahxDXLwJQmkOQncIFv72GQw85it7+IhtuvBlpwFrnX2pim2oloF2t+0wFsW6l9YxznVErGNGlOZvVjcYpwQprrLMBayz5eWTjGdSiRth2u08DSqSw6WabAoqNlBGjR/GZHT/jLmU1tnV7fHr77dxl1LLppps7+dJGsbL2MXBApPR2dfL0jH9gJcSzFlseEDBwY+yjHsdLfktbB5NWWw8/045KijDs4bmn7ufUI7bh+AN2jjdFACtO5JAyFw2i/fFs3rN4ATNnPcsOO2yPiOHN11/mtTfeItvUChrRkyuwzjrrssp4F2/7z4ceoHXEODacto4T2Yzy1hv/5s233iNSRRGCdIYtN9+UH3zzDC69+j6O/tr2/OPBR9jm09vGTQ8xsdvD0zOfoKCw+eabxA9WYtbMZ1h32jSaMi4oZsaj/2TaZtPJ+DUTToNRJwOYpYggZcK4ThHP1HgIVadB5wAYCwEe8fmxhGriTR6tEtmUB42AkVgRre/hPxTSns+8mZfhVQZ94wghAkHKZ9O9f0SEEGiWUtTF8zMf5NuHbsOxB+wMgBqL4IGRjy59VfowdPQQj4vO+gYn/PBXbLXl5jz86Aw6I+Xhv9/G+VdcwwtPPQFtE1h7ygS+/dNfsYu3gJax67PBJzdjwexX6dJm+he9BQjnHn8Iv73zWTbbYh2aEO5+8J+oKs+98DLZ/hvxDt6FrbfamocevI8b7nqMfT+7BdBFixlBx5R1GNMS8tSzb9EX5WgyKTbbfDP++fwctlp3MgBbTN+GJ+f1sfGYJtdZlQ3ABlK+q6tLc7mcXnXVVTrcccstt+huu+32kX5jbaSqNn4tG2yy5491m2Pu0B1PuE8nbf1dveCKv8c3V9XIfuRbT506VZ977rn4XcldyoZaVFXtf0OByrk/PeMI/fwBJ1Xen7T/dnr8JddW3q8/ukV/+vu/Vt7vvtX6+vXTL1RV1WP23VG/ddF1le/K1/3CjpsoqXGVz3Pznq189/VdN9GzLri68t0Nl5+tG+1+oKqqjhX0sZffGXC9f3Xma1oWxS/VfD6vnud9yB75YCTJM205QWqklrKprlGuEPH6KZao1McL/3qYUw/dihMO2oVyxgYxRbDpQU96znKviEIgMPOhe0iN28x9GcE3z7mcb0LF1aGvUML0dMa/7ua5Bb0cvv8elet96/jj2e/sK+Dc4yFSCn0977tnMR/yjW+e5e5vITNmfVqB2d0h/3r+Da64Y39+cNL+1R/4a7vH+VjM2gMxhLw7hibKu9pU3Li9muN6X+Wb+Lz+9L847eDy4AenZRaJSNdFJa0RPAFMkKWYi+OOPdDcYq77y401fj6WoinPi+7D2lRpuTBPKv7elzj+fQmsv+Yk8rbgmibO3t8DtLT7dL67kLufmVPd4VdFSy/FdxvIAFLzd1lhJQMMAXR2Lua4Qz7F8Qfv4jaIxGVfEE3FBBr8amNi+7oVZ6nbZIfdYfG/eL3bMcHpRx3ADy+8pnK+HxkkKvsZtbL7J9fmsKPOrHx/6FGnsM9Bh7mnCgLCcgxj/Ix9wHGnnsBV551MD4B43HDFT4EWRgMHfOOLHPiFqqH88vPPYu9DTo/fWcaMqQboGGBkR6ramGWhB6/UAZYv+kuhXvK7W92byGpZxq0HA3WA9+OxB24pb7Nq2+jJTjeI8cWd19evnXZ+9YNooa65yoTK+Xt+5TBVVT10vz0U0Dsee75yKqCd8cV+e/H3K7/Bb9OX3u2pnLfXZ7etfDdiwpo6L+c+H1Xdaq681tpsR/cYGqlGjdcBVjLA8kboNFxrrWqo+nEwwNIQaVnZLmqkqjZSDW1+6Sdbq2XlWlU1iqIBerqNSu/7iaqqDcP/oM+HS/ksr6TGVu7hGCD+ppFKsCwH5WN5IJVK/feTPm4YAUqIBODFwUF1QkQIgo+2U2wq/g6BE7sMeKQ/6AbUWtCNGShJi1m6bUX+YyrDpX0XQbF/qfdoFC39QqGAiJDJZHjiiVnYyCbb7XXJ/aH4fSqV4tlnn6nkk8zn80OC8ctuBkoRlQKiqbq6P51Ok0qlmDVrJv39fZSKpffTs7pVE39X3ifwnZXdKtaAsUJkYn8cwZ2jKZDIReeJoLhIPSRENYjd1KEaLOX2c6rOiwWUNBaLpyBqUAGVyOVEEotYsJ5Hk1/gf/93L55+8UXC3m4i9RGJMOLRn8uRTjsmqIeW/uLFi+nv76etrY299/1fmpubl9mu28eBcsytisumYMW5TXtBwLvvvM0207cgn8/T2dn53y+2jCEI1oQY6+GC7RWhh4rj5Ue5lgiqypgxYwiCgFPP+A5tbW2EYfh+hqpuRMd/fNREeNYSiY/RECtpPC1ixYC63XzBxExTAvyKbxBqUKMYKzVxCoKLNQ6d/5BEGBvE250Gl0M0JlbsYCQI1lMkwnkgakBLS4b9vrgfRiNCyWC0gPECwrBEU1Mz1loWdXYOWj/2x40bRyaT5qF//JOXXn+FQnLHfgVWwLcQp60EgbTALbfcyR9+eymZTIaJEycu78dcZsjnc1x/211Mm7Y6pYTT04rjhfKcYGL+yfcrq47MYoxhQh209K21TuwBFvRYioXcx+hsvIygSsn4BDbE4Ga1bCZDz+LFiV7d/jucW7qq0tW9iM7uVSmVklvwxLmeK5HxwCoBJSLx8TyPYl9PhZTVCPOPjoSP9KXBEmHwKdHS0oSfTrugk5VIHCTeDUctLdmAdFNLw2k54GrLXyWsF4qqh4gyYVQzvzjnDO78x7Nk0zJoGTGpGA60BEGNYVRblpl3/ZlzL/kDrU2NteQtwU7J7jaNNeBVR2e5/rKf8v0fnkehUEQ8L+EtWxEhqMDojgyzZ93Pnvt+hQXzu/BS8j4DQT20XcJgm/B5Mu6wPbffgodf7GKtKasS2RBPleFXKm54Q4GW5iwXf+dYzj7nF+y4/bYoeUw5u+YS5w6WCQasAMsg4OZjR66vn68e920Wv/sybX7ksq0lnK8/Klz4UfJRKpbYaKudWKSWTaZOpFAKGx4F+D6NIsljRYC+kmG7nfakGzClEiUCXJKdFQfDYSIToFAK2XjrPQkj0EIf1qawjY1JGl5KsOsXS5TvJ8L5lxtKLsf+Coak09LBYkt9hBZKIq5UU4O5ewkdIPndJipERuJEHxGW1HBo1gqJcjklEfA1JJJgqaSsh7xLiEBJFoBqAyhcpoVQPHwbxYXcViJ5iFPSKJTEx7fRUnWAekbtgBVgOMiOSKXoJnM7e4j6FzMMWvWRMFyU4HL2IQHe6ynRX5rf8Cl6AAPUkWxjyEBxXowLFvQzu6uP7n5X+KEp07y8H+1jQ9JpuCR6uvP8+ppbyZuAxd39eB/gbj0Y+LUcVZOphKSKQwJYEVSFdzr78SO3m7iioerwmWzxz+Ic4Ob3hhhbRKWxBg3foFghznfpAjJ0iZSHyYJLqiUKqLgclDowJ9GwRbkip3oQ12NzOSGSuiZoNcOUS5+HqK3x/a8/bN43gCeuyndLa4CfDoadh5wCmRRkm5pJ5kD4kCjnDhOhubmV5nZDVMz+598kEOKBb6rltupigM7uHvz+fjpamjjqoENIpZshToxauXrCjwXFD1K8+NwzjGzLAkpnZxdJFfM+ECqMHDWCprTPj39wFuPGTSKMSjUrQ3xewo+NZyjlc2SzLmSzs3MRg6WlL56H7/toFLHqqpMJvPTHknT2Y0GNPpMOfDrnvUNU6AMkDo0cZgxQXrtVGT9uLJNWmUApamyV+eWCASGcimeEYiFfie0wnsdg/X39jtYmgmyW7lyBU7/3XfIFamJAa24+FI9r8L4wV62Z+BTSWfjrX27nz1f9CoD2uIDz8IIbBLmS5WuHHsN6G69LVOD95r2kHMfvB5SWFcCDUm+Rn/30fAA66qClHymkIkWJ6OtVCvl+hlQ5wP+IOA5VoGQM2ahIUVJ4WEIBIxaJDNazRFEzhf4c6DCYET8QbvRYLZHP5cn1RBRLZQ5IIhRPlYIJSGuRyPqIiTBe4FIyxrSsR8X3ZUl2kwR1l4qL+1WLp5ZIAhChdUSWFs9tcvRG0N29OK5SX5t2JKmWkQ+Hcg2x5Nb0cgbcSCypyNDa1kzRE4qL+t9XJ2OFdodWUUQNRixWfCZ2BPzg8K+QFSEQYaedvoK0tSGmXIml8svl+NTLFrW6Y6KhipU0k8b6nH/K4Rx42Bk0dTQtW2/QRHWcqMthIx6qkM36XHnJOVx8xbXc8sBMHnr8YV595FqOPeRs0k3iclDZ2uLewxNK8oO9XS0Dw7gRAT867RjOu/S3rDJ+9YaTLdH9pGhcOMVlW9bQMm78ZP583zNMn74p6246nT9cdQWPPnA9CnESquHPAMMF7W0ZDt1zG/7y0Gsc8/X96c13V2tk1KCB3qDJgsQF1TwtISoUink+9bn92XyzdejvzNNu4MrfXc6WO3zBMUBNcxO10q2g6O7Jc95vb2bmw3/D1360FBE1qjRDjPd5gyYJbovcAym5SCEgzOUIjc+UcRl+eOpx3Hj3TN7Uxyj0E6fmc0rwcJ//k0bLJeHM1xbPb2ZRCJF1+Y2WVhy9LivQ0m6cJIha1FisDfAIUKNMHR2wyw4bcdeDb/Ha4ggW5ZEgSKaWPwgkTpf7AAgQqlTqNCtU6wY3CMlWgstQg8HgScik0cJG66xKp7cpGi1kRBMEmQwuT6UmtIEfDcNBCQYqm2DGya9YYxqe4CDxIZEqgqqHISTb1MwvzzmVp196k3OPnc6JZ5xBFEHLiImceMaxsU18OG+EDTcIJg7tiULFhkWWlhiuLme4gW+TNj26AW0lRUAO9eHF519n6jrr8+sLfgIIUanIiDU25NQzjnWFqCtYQeShBENFMSoUI1hlzfVJN42ltJQETw3TAZI2/MF5elqxEPr09vRxzu+ux68pqqhAIYL+vih+F+8EDyhYPfyQRFouDSpCf18/h5x+LlYMud4cxm9cUEzCy6Q63hfU5a/XiPk9Fq9nYEZkiZOrqsbCZPWnKzGEIbj0BqLQlYtI2T5EypU6GwO/VqsYOB6G+hwiLnW2GFI2IjKCsQGBKTDg2dUtpaEEWAxSDhcfFlriB6PsA5TskEinA6h4pLTgUtwQNXD4gy++75YUESa0GnKtzYnKKFAWaiKqY3pJ1hUgDYzoaI9nEBieHODaJMYwqqONce0eeZqW8zPVh1pP7jJdPaCQHVWJCKuHkv47b72J5wWMHT2aIMjQ1taGaI25cAhEANV9jGL8gK5FXez1uZ3p6+thYWf3oIMohioEGDVqFE3ZZrbd4pNkmpqwUVTNpjYUaDHI4wExAb4hCpX29jZKxQLvvDd/8AExY8aOIZtqYdasmTz7/GOUNIeKqdys9sZJPs6mm7jj9v/H3XfcS3NzK+l007DTgVUtvh9QyOe55rorWHva6pTCEFSWe/836liBwPjk+kpst9UOBKk0EydMGDQtfeP7SGAoRAUmThlPf9gNNsXQ1wE+PFSUTDZN25g2NJbv/AZaEoYKNJaOQxsyctwIxkweSSk/zLR9AfEg31ciDB0x66GlL9YgagGlFEaERRBNejZ9x7ye74NabKRYT9GSrWHreipLDU3UijpRpERFISolfONPwPd9PM9QKpXQyCK+jy3WaqqDp6VfHiyC56Km1EOX5nOaBCiIRFjxMCmf/PyF9No0I0c1Uc6OU+WABLbvQ0PiScy4VidB1qs8pqVoAlJRHitZJnW08sKLr/DK3DfZausdwCthc3nUqxmj5eDvQcCoxIYyBSuKGjeTCMl8WQxNQSuTsz5Tp2zGvY+/TFPgu0iwAZ00fES8CmrbZ7QyLpLwQlx8NwLpMMQQMKEjw16f3oEN1p3OF3b6EuOzY7jzny+TaRK8MB1LLtTF4KYaM1qzSZRQqEAm8HjrxUcIZDIWSDcHLghm2OR6+bCIZaGErHSiQslzdIq8ELLNPPKXP3H7Q8/wZrETVcv3vn0EB+6wN5E/EZVStWV1DNsawSkZHfXf0Nbs840Dj+cvjz/EthutQVgAO8C2tiIhOe1WUfzIiR++9aGQY5Utt+Bfbz1Dupjn7d63OOG4Q4Eu8qTAD2O6Qj0uoktkh5ak9NfSobCgq8hdTz1Bqyd8r3sxUEx2mwaLBLbZiiKq5D2ftC2Qbp1Ak1hyYZ7J7SM58H/2Zos9D6SNRXQVa2Xawa90A32BNNnrgMQTXlfvQtLt7WglanhpSlKSW/ohoFUbehJQSeKrPoGNQA2RhmAMq7aP5shD/oer75jNPH2Ivv55FL0Ar+LWMnhr3kBvUNGBO26JhuIkvHKJhaV9P4yZwDh6JgYKiKJYRD2s+NWQ4KgAACAASURBVPgIE1tSbLzGVN6wY5inc4l638KqQUSJakWgQSrCNayToM76L3A7huUpUIcJQw8WyWByFcVYE9sqLGoiJrU3sf4q0/jEzl9j0exnGEHEiJaRID7SoBT+NSvAknbCZI4a14EGwaOvL0fR7eyRlIHQWCRHCQZABBWLqCHT5HPt7y/jxbcX0fLkw6y51upYVQpW+OeLM/HordkGGHz+u9gd2joxWZ0SApLc4tICoobeYp5jTzuRtdddi2KpiElllveTfbyo7PoliZbuQY16aNGjo3U8p512IiXfolGAFxXJiYfFqwTKl/8OngGId76sk5dRTbzJXCWivz9iv2OOICwWKYSW7PtEoYQ38j/CreZibaL0AAt4Vgi9IhRLfHLX3dhyr72o9fRUhXx/Jzmtprc39ViBFAPqLmFx9bSGS2H1fF8BqDGWDeijYcgAlXHgyouqeNXd0gShTJlSvkQpX1riW8X40jBa+iIhIoIYReLoIR0uHBBDUCT27xApL5v6Adah5KLaJufcKDL8aAnO4OPo6einWGSwznDGCOIJBsOYprHkKAAh1ZC6pW83JOdYMRjSNNPeXI0IG26DH6hESHnGY2TrSEZnx1LK5t7nFJH0Y580PV5/XA26Plr6b7zxFp5nGDd2AiLDX1HcZ+99WbSoi85FC2OZKDky8n+CACqG0aM6aGpqZeNpWyzvR1rmmDB+In29Od6b/zZqB0dLf8qUSWQzzcyc9QSqISElkhwq6OYCi0Xx8HFbKxafJm6+42auuPRKRozoYMSIjuX8pMsOfX09PPPyTKZN3ZiIEklmcoMlQjF4CBBh8QnotTlGZ8fR3JJljZY1B31931qIbISgzO97k1wxRMTVmE0iFDcTejYkMgJ4eNaSymZYtGhBnBplmOoAqogIimXBgnm8O/EtSqXC8n6suhCJh29LWCNYPHxVxAiF/qgc4YFVixlkWS9f1ZmWFIsYcfEA1k/snCGieJ5HpnUUvuYoFHLki8YphNSWyx5egx+qOoDGpmw1uACn5ftYdUAJPAiax5D2QsJCH30FxTN24KJWR007X4TYDclgK1EjmoggIqi4kLhjgUw6g+1+j/O+/0MW9aU58MjDmLb+KoSFOF9QQtpVH8r2vPhdQvYCBtASMIFPh5S49Gfn8uwr89nrf7/KZ3fagr6ehXHUYv3wKzeW2G1sYNzgkIbiMgdbPBBLKvAovPsyk9f4DOMnTaW9LeJ3v7yM39/7EPvusKbzOCxz9jD3jhB1QSYkJMtThZbisjyJ8ZjUEmFkbfBa2GTzT/CHz+7Ckd+/gJ+c9WWKfd0VJjd10DJeOyT2qNOaob+0wLWh9nJiTdnpLZXJcs73f8ZnvnoE77z5Ai8+9wLnnXkw3z7qZGACosVhs8n3n+GEvepm0fKm04d7OSq6Z/dTaa67+loy49bEhj3MfORBHr3/Si77zkn0MRa0iNcAl4UaZziNPShJygIQe3AIng2xQG9PHz/59W8oBQGzu19ndGsrU1YZj6SfJwRETCXd9nCe/QEqwREJaaioYo3B0whVpZjPs/O+X2PB/scye/HLNAdZJowbD7hdKszgq8PXYglv0ORBtOz37rb9F/TlSEU5si1NRIX3+PJR53Ld44/h6TtEpInKDJCcsVEnEtRQBdSixsPYiJ4S9HfOJx2kGZPNMmbD3TjiRxfQxrvMt2kiqZ+WS6jPCemoGCqCUUUwROLjU8QgpEc20//qS3Q0bcSZF17KrpuvQ75QxIVQxEmUktXUQSI5jSzTEiAiwMOZ5v2WDB22yIjm8ay3+36c/62j6e3pQ8WlfQHqamaVAcQpE0lKCSSqRKaExceoYknR3trKk3fdyhrTduQXt97It48/kMXd7xBKCs86X/MVApZEBQKJgpoSkfgYdUXPM6kshXdeo6ljbfY58XTuufkaurpfJyJA1BXPqBdVEUjBxrbjZDCBqwkQRGmimNI2K8x/ZQaf3fUIZkd5ppg0Sh9j2sfTU+gm9AzWRPGvE9DEemCW9H4d2nBZIWKxRpUwDeMzOYLVtuOGhx9n3+mbAz2Ma5/Ewr53yYnBxhaNSAZfMWCAEpwY7TeGKJQMWFMiCFO0ZZo4+PBTAVjNq/VraqJX+8iG4YDfDm8OgCSxeZWWIUEU0JRp5pffOxuAL2410K/p2WKREbxEWYDx6shymWAl2PmEB7EFSEVZ1J/j2xddwHHqEWgKNSWslhCvlbzOo+D5Fbmgjmx6CUMymEBFCGyEjSfivnyBnf/3q9z/+f3wSSOmhCUkCgPaw3fJE1De47Ay+Cyvvg6Y9Yd+R9VCVCkZg6c+QoQUYfTa67BK7D6lxiI2QCkQFUtObozKNcJIWnM/EhxVE9RAhdAAmsZTixeWaJ60BusYi6hgjXUuOhJioxBVXCpF6mul75RCG28/eEApfp5kiENG4yJ5xIpUqUhBia0EIBqhCBkv3jgziRsaHx61EWE1c2JSaOme3xKJIlZQdbSUeINWNEIFPC9AcIm0oE4GQDxEXDxNUyZAJBrQebX7Ykk4Xto+nqBkMj5BKqj21nDkgEqblGzKJ5vxKVYCgIYOjeo5FsB4QBhQcVirg5Z+Pt+Hqk8m3cStN/wd68X22KHS4kYcI6RSKZ547ElMnEUsl+unrp4boshms/h+mofue5Q5b71LVCq9f2ZI8rEIxjMU+gqkghRQHy39vr4eCgWfpqZmfvS979Hc0gJqh06DB30cfyA4FwjjM3fOm0xbdyNKhSKLF3ejSbITfgiIQCrlkUql+MMfr6Vj1AhsGOL8vBgidPmwx0KlJlLN5yIGjCEqhqTTKVBY3N01QGr5KPBHjx5HJhPwwIMPMevxf9JPnuTOjLW95QKlY+mRLBluuu1W/u831xKkU4wbN2E5PueyRS7fxx/+/Gumrb8+RZJV7ceF87hMoW7Mv1+o9fDI5YtMGDEFBMaNnzjo+/mqEdYGIEpnfyf9xRKiNiGbKIJRSyQBRi1ICVGDFR9DkYgAJMSzHrmmNIt7e9Go3JnD1wyk1tK9uJvO/m5KhUIiaFl2bAxsSMFk8MnFFjwDEtWwhY/xodBbdLVxqa/YVaVEEsqA5LiJiJhSxYrBaCmeKQKsETKZFG3pUYBSyvfRne9/v2Y8jBkAcKGRFSvJ0G+nxhViIgFDCVGPoidkUh7tmZH4eBQ1R293N2gcCdCAOsGmOggSYipbAi4vpK10SEeLz3P/7y42XG09pkyexm+vuYfmjrEJGALLCslpuShYMaARqj6tmYD3nniSnTbaghFtkzjsuO+hLaMQEyBaE7deR4zHEhViktNZZZQjnyLjkfIN/37qMT7z+UPY9YADOPKwvTn5kAO5/m+PkMmklvejLgcszSg8RKHiNi7Vw2DAM6S732aTrfdh/KbT+cEPT+amS3/JXrt/k0zzeBfXofXHdgysEKMkyoNQRRC1WHE1ANSWCCOfv9x3N7tuvxlNNFN8dw63Xn8nX999S4ilyBUCCaOli0svh+QKfmB4+J4nOeDYI7ns4l9i6eKAz2/N2DV2oo/LQUx13DeKAZIIQbHi49mIyCqrrL8xq/uGee+9yetPPs1lV93D9c+eQzHKu9TbKwoDQCKU3wrEreSIogphvsBGu+zJp/b6AosWvUpTe4YXXngFSY8kg9KrNZSsQ51LdIUYUcWKh2gYJ/b10VDJCDxwx038/Pw/kDdpMhIQGSi7fMS/Xo5P/jFAIDHiDzhulQhU4vQuSlgo0FUqMKq5meKiOWy3x5H8333/RMOFzg2inA6lDgZIfHSIiiJEbgZBafYF9Tx23+9rzHjmSf555wV8eo11Sct4PPUqDJAY/5gVFSqoRIxtb+WZh+9mzOgtueiPf+EL269Fqb934MZXHaM40SGRiCDWsb8Vnybf45+338INd80kyIyiv9TPphtMAZQcca6juImatLYOCglqo4CqK2ioCmosLe3N3PH7P7LNDgfw/557kuO+shN9+RyIh8VQ3gioZypLtBLsND3jOk6tyxTg+xy55z6YP1/DWqOyHLT3fnxyu33IUgBbbVyChsbgkLCQSAU8LCUT4FmL8Xz03df54oEn8vubbiO1uIs77r6Poho22HY6PvMrI9/SkIgwHBeSrMFRNvR5KH3FEjt/YR+uunQeB33pKwBsv9fnufbm/6OntMDtFmj5d0lr6UeEJEwJBqouLJZMto2fn/0LAA7Y5/MDznq10EkgVHSAOjfCyqjJC5QYxB0mFo2DpOd35djjG0dS1D5KWuC2m68i6n4HLc+IiWpfHagowclosOBydggRRpXFvT2cdt65qBaxmsdqDqt5ilogU+olUqqTWWMqxSejo5YOt9mvqggeucX95GWxK6SpAa6Zlal/BUOSmMDtBljxMCidfRGLeL3ybZnOnjHx3n+FAxhsG5OtBKO49AeAcfNHedkX9VBNoxIh4jxcbdKaVxeSM/CB2DU9zt+tKXyNYp3UQ1TiPKfEqXDiokiVmb+u7NCCMYKIpSM7klS2v/7WLBdUoz6quf/LnSY0SROtza01QyLxFuAPhAg0N3fQkW2jmC0u78f5CCgPaA8hTVlTq4UAHgE5KWIHq/nWwO/s7CQIAtraO9hn7y+RbkojtVPlcg+MqP9YAM8P+Pcr/2bi+EnYyNLZ2TkM9wKEMWNGk8mkOePkbzFy/EhssUb0GwK0qPtYwBihVIxobmoGYMG8+XEthA/qlw+Gn0oFpNMZbFHYcvOt8X2/stwMJwQpH88G9Pb2YDxDJpupVIsZHnAGAQCNhPXX3YjJkycThdHyfawGorzGGyPkCwXuu+s+ADJN2UHT0m9paSGdydCf6+Pww75BqVRMVHHlpeH9PpBCUzpLR8cIbr75JgBaWlqWw5N9PCiUCuy1195ssMEGFBJeImlp8MWnP9fHj370Q6A+WroSSVZBLLlcD6VyEHWCoSIuaKKcIlwFbESxmEMTWDj6o0PJ5/vo7++lVEySDlATxBN7hSpOpylrdygYzyOX62vIHZcwg8avxEpAiqpBBXyElrYmegoFJFce9G6rfcVA2RyWkPYqWGPxIg9EsUZR9WhtztASRBRsO1FQotDZFUc5N8aIMcxMIS6kOjAeq0/oYPstNue62/5BumlFDIZJGhTUQyXCioA1jGpR/nbtb2kbM5kx49rYYvOd6ZIUvte4YTusGEAB33h0pAtsPX1rXnhjLu2jRtCgemorsSwhuHTn4hIy+Mana8HbHHryd/jd9X/i3889xVjzNgd94yxaWlsbdtthxQAAYztSrLX2umy5xwFsteFUiv0RaoaPJWTYQnEpLtVgrBJqiEm18+qcOey2zc6MW2NtvnP60bz9+kuV5GaNQOIjwgZAYV5XP0++8CoTxq/Gp669CGNDrPjICqH8JhkuEkus0+EQJTTNmAi65j/FOd+6ksuvvJrbn3yV/t7egT9dkQNiaiECkRpKeUtvz3zUgjUGY2syCKzEEIUialATOocI9RAtghYo5EqMW30qm282jYvP+QFBU5tLh1P96aAxrBgA4u0grU4JUvmzEkMb4mK2bQpDBJLHSzXT0TKSllXW5cDDDufhe2/m9uuv4vm3OklDxbernqpXw44BgKor8MqBnxiogGct1oSEkiLjZXjl0dvZZtd9GDNxEs3pFGFnDwBWArxqaEdd21bDkwHiTZRioUBoV8r+SYHiIa7eD2EIW396O1584kE2/ORmnH3mmWRW25h1PrUn6686gqLVSsSbWSkCLQGBYrHE5lt/mgkj24iilUww1CEKkVHEBvgaEkrI24VW3n75SbZcewx33X0fR3/nx9z7199T6HybqEH7tcPLChRDRFjcm+O8X/6GYj5HsRSS8YZlU4cPBDwrceVHwVjA5sj5HVzyq9/j+x7FQp6+7vmI+IgWq6JPHZwwbEeFAL09TmYcXl6fwxhSjvmiYr2wUcjixd2VU1QVz2scPQ0QO41VbzBcIUnxixkkyrQTkWHb1qW1q54x6xtjMMagqowdO5ZisTgsOy+dTtPW1jYs21ZGbdtGjBjB2LFjnXfvMEE1HsDQ29tbaW89NPXffPNNfN9n7NixNDU1ubzyw24VcGGf1lr22WcfFi9ezKJFi5b3Qy0TjBo1iqamJqZPn44xBjssrGDleOE4/Dtu17hx48jlcsybN2/QV/YnTpxIOp3mySef5KWXXsJam2gGcHFRXixJhi6NNh7pbJbbb7+du+66i7a2NlpaWobdaqCqGGPI5/PccsstrL/++hQTFQ+wJFztBxXnH4QIoQhpz9DT28s222xDNptl1VVXHfQdKiJQFEU0NTVVRKDkMoFgCFEMKs4NWtWSSqXwfb/SrkY6VA0VlBnaWks6nSadTieeySUOkpE4G7Qvim88MpkMUeScHOsSgWpn/CiKEr0CuCXSUBKPTNrD04BisR80xNoUqprYtn0UqCpRFFVeSYXgcr4GgcX3UpTyRUQLRF6mYaKdvzTuSdqsoZRzIymeMUwZ28Hf7vw73b2GXfbYg3x+Qc2ZKxaSRcs4fDWuDK8I40a18OKzs3j65bfZfc8vEeW6iMLGxTknfh9AUXyrhAbUNDHCW0RH6xrkas65Z9abbDAxwjU3FhMYrtvgSYULZxUJUfURgXEjUhz0hd258f4Z8Tlf54Z7n+BTa49E89X83vWkAEv2GFCXAis0aUICRmWU755xCunVN2dRsYgW+9lzl+kcf8ShmPZVUFMCieXG5fzoK/F+aOWvYIzH66//mxsfeIZ/vzUfVctJB+/GicedRmtTR1xCtezxO/iVPdkMEGeTDGw/KQp05YscdeaPefyeW+h5Yw5zOnMcue/ezFv4NhgfL4ooJ9JekUolJQLxNC5qQJTIRnSMHM/CRQvwoz5KxZApq02lvb0DbBEjIQPXgMEh0SKQExeVohdgNYVogXSmGau9lHzDxOY+Njr8NI65+FpM73sIHqhrcrIyZ64IcPHAWIOIYgVKkUf3wvm8+9aTbLvJJsxZ2MlL83J05d5BtUjFHXRFjQgTFBWDqCXQEN+WsFaQoImxgcd6q63NGjt+lZMO2YdcrkDJeCDOLr5iVIhJEKSaCwh1KrDFw0YhHaOncOudd/LdM45h46lrIE2r4IlfTY5bBykTzQAKLo+pKIpFxcdLZ8n0vUPrpNXZeM+juOvm39L91mtEBCim4jtuVopAQwxuGhexROK2L1t9ZfSEcaSzY+gYPYqzz/4Oue53ePGVtzF+qia36+CHcaIZQBCn1FofsIjJ0F56k0nrbs6VNz3AjVf8jMDmaR49BrGWtC1iK8V0Vq4AQwrqasOohHgqNPtNzHz4Njpa2wg6RjFhwiSeePAeAMaOTMf7AKb640Ei0QzgUmngfMkVmlpaOO3k0wA46/iDGd/RzsRJq7Llp/egZewElNrg+JUrwFCDxGKPSkSh1MdnPvcltl13EquObGbyKlPYdOcvc8SpFzJxVBqNoqrr9IqqBFeyOKqrF1gq5Jm+065M3Gg7InFpEP1iAW/EeBbnC1gTQJxYb6UaPLSgInhqsQQgRSKxzJkPtz30GHfc9ndmvvAan91zHzZcdxK9XV1YaYwdL9EMoCjGekRehKihmO9lx70PJGXASOSqRwrYKMT2doJKxU0u6YvfcISKACVQn8BC5HUzb1GarT6zK9vuAmGhSG9nP0Yklv9t+YeDnssSzQACWKMY66ojqBhKuT7C2JAgQqVaTCaTwVKuLLsSQw1lh2eJzaGRgFgfxJLP9ztaxmWUMB4DRnw9znDu9+4CtcExyYDU5P2pPa72SVlONMZgEuUXUx/KtEySL5DUHDlaxmxRCXxx35Xb1gj4UPUjH86uwuAYvdw2VU3U4PgwKLepln7Jp+XAcN1yuGd5zNYLf+7cuXiex8iRI5kyZUrdFxzq2Hvvvenu7h72EWG77bbb8n6UZY7x48eTy+V47733Bn0Nf/LkyWQyGWbNmkV/f38CY0iX9Ot0y6YVwSgIEYpHJpPmxhtv5JprrqG9vZ329vbl9LzLHn19fTz66KNsuOGGCaPn+310Xb4g5yPkAp08PM/FBE+ZMoVsNstqq6026Dv61tpK0MS8efMS1WGKImqx4rtu0wjFBylirE/kqUu3rRGZbBNdXV0J0m8GD1Vl4cKFiaKnC+eIsOI5VVjdxIVYjCqRAVUfoxGe55HL5f7rNT8Mkm8FkjRGI1QsKh5WFN/L0JZJoyLkczmKYTIGwYoMQbGSwqg6RjAekYAxPs2ZFL5JUSj0kSsWaeSwTbaGpOAC30sIBsXQ7Ht4fQs5/YyTOOqE03j9nRKZlpUlkoY8FCDCUAQRFI+UCKP9iJ+f/yP2P+xwHpo5h7ZRHTRyFz/ZDBBbCBQlQkiZCNs1hzWmbcY/ZrzA7Jdmsv1Wn+DJf/eTChpQVnwlljkUJRIBIia0KpNWncplV95IqW8hX953Oy656m6am7INu1+iGUBFMaooTtzxfJj13EucdMYPeWbWDGY+8RSHfGE6v7rsarLpzEoX6CEMFWJaphwtPeXl12ezx34HMPedufz973fzh1+cwi8v/AWZTIYBG2F1LAiJ1wEQsGoIbIlSIeKT2+zOVtv5zOuaT3tU5K77nubUS79NsVSKXaGHvxKcREgcEGDVw7Mh2JCW0Wty6YUXsHDeHCa2j+Kmv9zLZ/fYjVKpgOgSDLAiBsQ4F1pnGRAsiiEqFChKyPWX/4i2VVZnPiPZa49dKYQhKisdIYYsVB0tieJkZoJGSn+hj9efvpd0ezt/uXcWJx53DLmSUnVqrA/JZgAEkRKGIqHxKHk+nm8ohHn2O+RMolLI+afty6qTVqV1xJgldn5XrgRDCzEttUQkQtELUE9AQlabthOFvgKPPnADW647nrymGZDtXlbUeADA1ZbyseqREcu8V5/hnff6scBrb8/l6IMPgN659OcsGFPTVysZYOhBUDFYfAKU4rzXeeHFOaQyLbzx3lw+9anpALw+ZwEmdnd3P1tRGUAUrIciLiAmEB5+5G6222JD3rPCxKY0X/7CobSNW4t0U4BGtY6DKxXiIYUKLV3YaiBKvriQPXbZgQdfeI3Vx4/l/FO/B8Baa4ynFJlKWGs9xo1EK8GKYDTCGkXVpzcvfP3Ik3jikafYbMpEAKRlFI8+/iz9i+ZTdo52WMkAQwkDaekRhh5rrLsVPzn1SL6ywxZ8JT7vj399hJTNkVdLNTniCsoAlUBqFDVFrPWZ361ces31nPjOu9BbYpU1p5Lv6cKWnJ+5rhz3QxS1tCwRqc+CRUUO+uZZ7HnECSyat4gpU9YiskXC/l5UbFUCqiPNX8IZADSWBUVLYApgU8xb2MWI9EhoyrN40QIMJXyvyQVUrBT9hywG0FIKiPHp7gpJmRTjxo+lL9cFNsIXz20clGm5otYIkziLAJpymd60OhVYm8eq4tmQyAhWDIKpCaReiaGEKi0DhBRoyTnDoVgbojYukCEax3tXlWArg1dm/dp6UplMBs9LpsuAEADlScFW0uxpXDIjm82QTq8YPkEiLgQ0m80mkp5ukkpXc4WKdSkTMS5vhOcPSG1ZjyXH7+vrIwxD0uk0V199dSI77L9BRAiCgBkzZmA81109PT3DLiIMoKWlhSAIuOOOO3juuecIw8ZsGC1flIsjVaP6crkcmUwagN7e3kFf2c/n80RRRCaT4bbbbqO5uXlY+swHQcDrr7/OmmuuSRRF5PP55f1IDYeq0tLSgjGGhx56iNGjRw8TBhgIYwylUqkyWdcTG+CPGjWKTCZDd3c3t9xyS2ICKD4qMpkMN910EzfccAOe5zFmzJjl/UjLDPl8nosuuogNNthgWNLT8zz6+vqYOnUqQF209FW1Um6mu7t7mHRY1d4v8WpWyGbp7+8flqvb0tDT05MseqpSznqCSGzUALc7XE2ApqJ4ZmVE2Aei6vBpaEoFpNsCuhcMXkZciY8PFoMfO7lZ9UGUIJ2mvbkJ3zP0FAvkuxtLy2S7QiyBcq0wo5BpSvHyzLvYcMvPM2LEKFZuAAxtqAi+RhgVrAZY8cikU7z78gy2/eSGtHWM4pQzforfMQbTQNvFsGIAiGNLgzTtuogdv3goXV15TGrFMH8mGnF9vMiIC4ihRBO9TN9pX9bf9Yv84rILuP53F3DcKT+mpbW1YbcdBiKQVuIhRMGKMGVMO5ttvBnHH380V159B7VeIysxNCEokXiIWiDEGJi3YCFXX3cDu+y+Ey1BwJqtIV86/c8EwakNu2/CV4A486cKFoPK/2/vXIPkqKoA/N3bPbOzr2R32c0aiA8MG6IkgMojvIMuVSFRjFEL0CS1IkEoSFmoUPIDhMKqKBBLUgarEKQiWAhEhRRIQQQMYgS0wJCUBZWkAktMNibZx2x2Zmem+x5/dPfMJpGAmV53u7e/H+mZnZ7J7b733Nvn3PPQNDc1svr2G7Gnf5arL1vAUF7QFH2leKTfYCIU4w0tgiUGLQrXpEhPOpbzzjmDwZ27ef7xtVx7w138cMUt5HND4f2fof3SGBEUx1YYauw0PVtf5zt3PMirz/yGocFdWLaiobYRrQSwR2gC8dsEiwcWSrkIJYwBSgXe7XmTu1fdT/fgEMXsECpV421ihtCF0X8EEoXRBlsULZkCn557MZdddQM/vfPH9GzbTDG/h7tW3cfSxV/HouSn4IZEAMYbClEGZVIYDGKVsPRkUuk0Hzl+Ng899SQNhR3UTz2Fczt7aNbhODZGXwCUizJereC8m6N92od5du29/MFNo0wOnCFW3LmSxd9YhlbOIRFhiRCMF0SB7SpcXcRRNdSpNO9ufoGHN7zJ7bf9gGL/HuoavXSWA9khWur90kBVEnEB8KoJKmqwTI7e4RQv/u01UlYaO2Ox4+Xfcer8Wxno2c7unTspSZ1XUglIBv94Q3yP3RJaDK7RdJzYwT2XLOHAcIlFcz/DiptuwK47ltknfIi+XTuqCoUMiLYOIBqDHwE0AQAACMxJREFUxhIXUZAyDvt6B+nZu5e9u/ezux/SKYfe3v14xVEd7PJOcKIEjye8JLgKJIUlJVwcCnXH8tqza3nq1z9n4VcvxWmbwetb/o6b3RtUUq2aaK8ACs9ioF0QG1eBJQ6gKZWG6Tj1PHbueJ19+/qorfU8ByvDPtqyHzuUwjJuOS2iMlAYLtBy4ulsf3s7WjdQKDhkD+ym6IQ3bKMtAOAXyhthEfCPAjilAvv27QeVDPZIEFSCCf4RoVQssXdvHpEsCg1KCLPmR/QF4DC8ABgVpFdS+JFiCVHDqwsmeKZRQXAIO6jbTtkpMpkMdakMTU1N0fEe/B/JZDLU19fHMgjmv9HY2BiT/gysdZUAYK016ZDcW+wtb7zBk92v8lb3NlbOW4lKWTFxGR5Zck2wUym6u7uZNWsWjuPQ29s7hm0bHUSEtrY2MpkMy5cvp7m5OYYBMQrL8gJi6uvrAa+wy9Fit7e2s+7xF9i6/x2euv0nHMhnY5BFORBgXX6dTqfZsGEDW7Zswbbt2K4GWmscx2HZsmV0dHTEYAU4nCAksqurC6CqvrRbW4+hobYOZ7jI3M65YbZz3KGUYtOmTQDl2SOOFAoF5s+fz/Tp08e6KaPK5ZdfDlTXl9oYU05J5BEXhdGrJC4iBE90w8PDMXm8OzIiQqFQGOtmhEIwGkWCQBk/wq9QCKUvY2wfVIA+SH1KiC5K2SASerHzGAsAnHDcVB74/XOhRhAljCbGX7chCAkOJvld//wzSuuQqgJUiKkA5PlUxzS27+qhpaV1rBuT8AExfr5nhQs4KARLAeQ56aTzgZrQzTOxFICpTY186+bVXHT2SQzFMP9PnNFiUOLXfPCH+xkzpvPoiy8BhdA11BgKgGF3v8PVS7/IwL/7kBheYVzxip0LgsYR7/2alTdjZnRy0XnnAOH78MbSFcIIaN9RzkR+T2Pi4AKW8rwdUsBw/1a6vrcakcqmZdgDNoYCEGSIVjiWwTZxMevGH0vwPHpdwILzTz+LqR+bwoUXzPUKaAOfOPl0/vjSRqZkRpjuq4htiqEAVJL7alf5OecTIoGf2CnIBHflt29k81vvIjpFY7rI8y/+lTlzzqQu7Rm4JRGAI1McHsYtJStAdPDKowI4YrjqupHpT4Qf3bWaB+79GQDF4TxlFbaKOa781ThtFgV7JfO+fCkfP65pbBuT8MHRGo1GKbB8k6hLUNt5mM658wg8myRIFlolNlSSSsUFJS5GaVbcfY/3hypqSCX8/xA8EyjK9QtieIYMAURlWP/C0/iqspfdQ1W/utuipJyWDkBEEXknSWUdPN6TwR8JvIgvAKtSAO+wNDaejqeMqmwTV4FW4tVhEn+LQZmoj/6EOHLYqAxpmGqthJItEHhZxK9CUpnW1tZYxgAcilIq1gVAAGpqakLpS7t3oJf83kGaJ7VPiMGxcOFC+vv76evri51rtFKKlpYWJk2axJQpU8a6OaNOe3s7uVyOPXv2HH1f9mezIuLIr9Y+JHFn/fr1smDBgrFuxqgzc+ZM2bFjx1g3Y9RJpVJV/4bGGAoFBw647y8t4xI57LX7Hh/n8/lyOag447puaCWExh456BBQLBZD6Uvf/0h8T+zoYfCtAf7NEL+8chkFGE8kJGaPPEciLtfqosC4lZSWgTyEdH3xMBCKl1eyKKrsH/L00+t49JHfequB9k1nE0DHiRcC4mDwzNprH3sEN+QujIcrhPaMuF6mmP1YqrXiN34ZbN6VZdbURpDo57uYWCi0KJSGh1ffxteuu5WiXDpihU9igv1boMt7It+9YhnTTr7AD4YXrlv6eZYsWuJ9qLyscZXvJYwnDAYEXAyeJicobbG/+xWuuekOIFMesEIJHcL8HXkB8JQYg8bLGLDyl4/yzqY/lUf4kkVfYl9fj/dGDi6SlDC+0OJ7JWAQYxHsdrV+dA7/2t8NjIzus0ZkMjl64vEIhKBFcJVCi42IoPxI+HMXfpPV6/7inaUMKF8fGLO2JrwnohElZf8fBXzlc6dxy6oHqU8dA3jrtwVosXCDzdsqfL0iLwAG0MqrK2XjRYBppQGXtozNxUu/z7IvnD3WzUz4AIhWOBhsEZSG59bdx7bcNNYuX1w+JxWcK07Fg7OK2SwGj0DiP9ZYgOdOm+t/G6VsltyyiifWrCBw89BScaBKdIDxh8JgoUC8efn6a69n08tPoJQqW/CUUry1J08qZZXPq8Z9LfIrAEYQrcCUQKfB2U198/G8snUPZ5wQuAP4N2rE15QI0Xd7jRvKy+bqd8tjz2ykbyCHtoXmTIkZJ5/P8xv/QUd7LU6xSBhZDKMvAHirgMFGA8sXLwWg87SZDA1kMbgcN30WO7dtRkmJYL0UFYYKlRAuwSzvvTvxk7MPO+PCs04BQMRQsQEePdEXAO0rTP5NW9R1DWdecgWWFDGkEeOQmtTsfahsDnGUSBj3+MXQcbn3F/eP0HfDmb4iLwDiR1ArcRFRXDhv0Xuea5RNsGwms39UED9WXrPsyitC/3UddZ8RLaBxEO1FEYm4gOsXUDUY/wiekoXy7Ajxd4mLC97mpSgFRkK3XtiBhh1ZPxkNYFcKqzHSzq/LRwBLe8k0Kn+JFyJS7kvLiktkk0IHzg8jshyHdX22MQbXdbEsi1wuR7FYDOWHx46DE6IH7zKZDAMDA2UXWteNpy5gWV6Jq97e3pj05+FYlsXQ0FDZI9QYc9TeoXZPTw+2bdPW1kZ9fT11dXXRXQ2OgFIK13Xp6uqiv7+fbDY71k0aFSZPnszs2bPp7OxEax0bt+hDERHmzJnDgQMHqorus6dNm0Ymk2Hjxo2xvVkjyefz1NbW0tQU33xBa9asoaGhYaybMeoMDg7S0NBQ1bVqY8xBkTVxFILgmnK5XHnmj+N1Bv2YzWZj+egTICIYY8qVPqvpSztwGw6I6+PPyOOhr+OC9kuoB8pwXDn02qq5Vh3nG5WQ8H7E0RqYkPCBSQQgYUKTCEDChCYRgIQJTSIACROaRAASJjT/AdvWKQ2XME5RAAAAAElFTkSuQmCC[/img]
21 апреля 2022 17:02
Евгений, картинку тут можно вставить только из веба (не локальную).
21 апреля 2022 18:13
Индексация строк
Добрый день.
В PoverQuery столкнулся с проблемой проиндексировать столбец "База" по количеству единичек.
В оригинале это база рецептур из +50К строк причем, некоторые артикулы повторяются. Все рецептуры состоят из нескольких позиций (строк) пронумерованных по порядку, на каждую рецептуру нумерация строк начинается с 1. Таким образом единственный вариант сделать базу уникальной это по порядку пронумеровать все единички (пример в таблице ниже).

Фунция "Столбец из примеров" не ловит системы, хотя она очевидна.

БазаНужный столбец
11
21
12
22
32
13
23
33
43
14
24
Спасибо!
Наверх