Поиск  Пользователи  Правила  Войти
Форумы "Планета Excel" » Вопросы по Microsoft Excel
Страницы: 1
RSS
Вывести в Power Query Название умной таблицы, Вывести в Power Query Название умной таблицы
 
#1
29.11.2020 13:43:35
Добрый день, умнейшие люди!
Подскажите, пожалуйста, как в Настраиваемый столбец вывести название файла или название умной таблицы?
 
 
 
#2
29.11.2020 13:51:26
Код
let
    Source = Folder.Files("C:\Users\Администратор\Desktop"),
    #"Added Custom" = Table.AddColumn(Source, "_", each Source[Name]{2})
in
    #"Added Custom"
Можно так
НА МЯСО В ПРОФИЛЕ
 
 
 
#3
29.11.2020 17:32:18
Добавила код в Расширенный редактор, но ничего не вышло. Пожалуйста, помогите найти ошибку:
 
 
 
#4
29.11.2020 18:04:03
Цитата
Елена Боровская написал:
помогите найти ошибку
Давайте попробуем. Побольше скриншотов сделайте. Каждый шаг отскриншотте.
А так у меня работает. Вот и скрин
НА МЯСО В ПРОФИЛЕ
 
 
 
#5
29.11.2020 18:06:43
Михаил Л, осторожнее! Ведь за чистую монету примет ! :)

Елена Боровская, Вы на форуме по Excel, а не по рисованию. Пример нужно показывать соответствующий.
 
 
 
#6
29.11.2020 18:12:23
Елена Боровская, попробуйте!
Хотя не поможет.
Короче! Будет пример в файле Excel - будет помощь
Изменено: Михаил Л - 29.11.2020 18:15:10
НА МЯСО В ПРОФИЛЕ
 
 
 
#7
29.11.2020 18:14:20
Михаил Л, не-а, еще как минимум запятая нужна - но у меня на телефоне фотошопа нету  :cry:
Соблюдение правил форума не освобождает от модераторского произвола
 
 
 
#8
29.11.2020 18:17:31
buchlotnik, да, там надо второй шаг закомментировать и переименовать первый шаг в Source. Дальше смотреть - помогло или нет
пс. Опять туплю
Изменено: Михаил Л - 29.11.2020 18:19:41
НА МЯСО В ПРОФИЛЕ
 
 
 
#9
29.11.2020 18:21:32
Михаил, не выходит :(
Я цель объясню:
в папке куча файлов *.xlsx. Мне все не нужны - нужны только три. Папка не моя, поэтому я не могу попросить перенести весь хлам, который там есть в другое место.
Я создала запрос-подключение к каждому из трех, добавила запросы и все данные залились отлично, но я теперь не знаю какие данные из какого файла, поэтому и решила найти способ извлечения названия файла в настраиваемый столбец.
Изменено: Елена Боровская - 29.11.2020 18:22:30
 
 
 
#10
29.11.2020 18:23:20
надо слушать дядю модератора ...
Цитата
vikttur написал:
осторожнее! Ведь за чистую монету примет !
Соблюдение правил форума не освобождает от модераторского произвола
 
 
 
#11
29.11.2020 18:26:12
Елена Боровская, вы еще мне и в личку головоломку закинули)
Как называются эти три файла?
Код
[img]data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAABI0AAACPCAYAAAB3TyssAAAgAElEQVR4Ae2dv44kOXav090H6EeRICCt6/UzyBcWkJWAgLbHXGANQbvW7ZqxBgtcSMY4WkOD6ZI1KwhyFuP1TOniDhYrGbuG5gWaF/xzyHMOT0RkZWdWZ2V9RiEiIxjk4TkfmeSvyMjd7373u8QfPoABGIABGIABGIABGIABGIABGIABGIABGNAM7PKH//qvP6affvof/vABDMAADMAADMAADMAADMAADMAADMAADMBAYaCIRlkwSukDf/gABmAABmAABmAABmAABmAABmAABmAABmCgMIBoBAh0BjAAAzAAAzAAAzAAAzAAAzAAAzAAAzAwMYBoBBQTFKw6Y9UdDMAADMAADMAADMAADMAADMAADMAAohGiEaIRDMAADMAADMAADMAADMAADMAADMAADEwMIBoBxQQFajJqMgzAAAzAAAzAAAzAAAzAAAzAAAzAwEVFo7t9Srtd+zskxAkEKhiAARiAARiAARiAARiAARiAARiAARh4JgxcVDQSVfL+kNLuVNHovopO98/EoVJnjiiyMAADMAADMAADMAADMAADMAADMAADz5kBRCPEKBReGIABGIABGIABGIABGIABGIABGIABGJgY+OSikdnCtk/pQYLUVhj17W2yzW2X0uEepfI5K5XYDr8wAAMwAAMwAAMwAAMwAAMwAAMwcP0MfFLRqAhGatta2camhaMsILE9bVL6aFjX37CIETGCARiAARiAARiAARiAARiAARh47gx8OtHoIaX9LmtCCqJ27e5BXUM0QjTSjHAODzAAAzAAAzAAAzAAAzAAAzAAAzDwJAx8OtFoZfsZopESzWgIT9IQnrv6i/20GRiAARiAARiAARiAARiAARiAgXMz8OlEo2ilUSSQsNII0STigmtwAQMwAAMwAAMwAAMwAAMwAAMwAAMXZeDTiUbpQ/LvNAoVsSYu8fJrFNOQDzqIi3YQ+Jx2BwMwAAMwAAMwAAMwAAMwAAMvl4HLiUZN7Jl+/cy96Nr8elr+hTR3P8P5cJeSzgcB6eUCS2dF7GEABmAABmAABmAABmAABmAABmDgaRi4nGjEChBWgMAADMAADMAADMAADMAADMAADMAADMDAs2UA0Qh4ny28KMtPoyzjZ/wMAzAAAzAAAzAAAzAAAzAAAy+TAUQjRCNEIxiAARiAARiAARiAARiAARiAARiAARiYGEA0AooJChTkl6kgE3fiDgMwAAMwAAMwAAMwAAMwAAMwoBm4mGj05z//CTECQQoGYAAGYAAGYAAGYAAGYAAGYAAGYAAGnikDFxON3r9/DxTPFAqtKnKOygwDMAADMAADMAADMAADMAADMAADL5MBRCOEHcQ9GIABGIABGIABGIABGIABGIABGIABGJgYQDQCigkKFOSXqSATd+IOAzAAAzAAAzAAAzAAAzAAAzCgGUA0QjRCNIIBGIABGIABGIABGIABGIABGIABGICBiQFEI6CYoNCqIueozOn+kHaHd3ByE33Fu3TYHdL9TdSFtkn/DAMwAAMwAAMwAAOXZ4Dx4+V9fC6OLxOrmxaNHu72abd/mx7UBKlcY9J0fgEgCwu7nfvbp7uHczWAI/IxNjy27NzAdulwP5dzf9il/d0P5/FZsXFl0r51X7F8cuf1mDJK2tmX2SdTvANhqaYL6lvylTzm/E+um/fPw9u011wGNp6tLF/21X2ujE8sf/95+urVq/TVF+9T0ufZ/ndv0pev3qTvprp8k75+9Tp9+/3cXmZ/vk/fvm75T/mM57978yp9+Ur9vfnmPG3OlJntfpW+vEjeoy6zD8577w9fvE5fHu3/U8quMfvy9efpD8Z/p+Tln2kxaLEu3J29DF/mqZ8v6YdTbXqez12O2a3+pcVQ9y2PbTuL/eCIhem/VtpNTRf1qSOvsP8offNyn2vKN3V9lb5+Z/M+2Yaj2qlt37lPH+XXe+OztSus91FlPiafDV7ad6D5LhJ/+rgWLnT9HmPHx6Ut7cnbc3ZffZyNJZ7en+q7t/YJ6jtf/OzHHCt55DJ8PifxJWVMPp15tmOidl/VS8ZR5xxnmPY92XiGOKUPSfcL+ly3y2here9/6vOH3/467T77rP39Zv4H6b/9Rt3/dbr7z/P47lPXOyr/ErF6YaJRnTTtEI3OPxl7jBBx6S+2IhQ8VohANJo7nXWfHLP6aFE0EgZOitWRnXwTjIxIcn8IhcG57keWkX5Id/szioriF308k49KLCLRrA2WykBLn2cbFidLeaC0PIGZ/JnzWRzoPOXEPBjgaV8/k/PLTcCF+6eIycbk7Spi8RR+EJ/f9vGizB7Rv2hx8tG2LPaDc8xK3ot9nZ2YTf3kBvN5IqfrET+/3a6WJoRxfnMdF9O1749lG2v/e9KkfsM31qYNH6zyouq7Ffdy/7ZFoy2erd+V73K8/Hgi2e/fMO/yjBJVI6bevelCZG3LKv2JMcn5fPXF58G4ZmbWtp9WJy10NRvOKRqJn0OfPaptuBipZ0u9Wt+lz6Xseqxj3mPG//a55XIvkq6IQ4FoJPX9z9+m/WeXE43uDyntDun8c22x/6jj+WP1okSjusoor24IVj4cFYAnhv452fTsRaPauFhpNBhfU6kXBYjHMnsmQWT+0jl/ZzmXkX1VyzHC1GN9sJX+HD5azUMPivS5DPrUgKzbmtM9QjRqg8V4suDK7GUMFmPfc/95+2VjYgcHn3jA+Zza11ofEnEWXVup75Z4oFi95KRuWcTXtj+ybsr2j+5PNv20Fiddh4893/LBkXZs1udj7Tz9+Ytyppj4mHKK8KBX4OR8lU/DvI1oVOO4LL7EcQzLVXWaOc/l1PFMftaKnlEZ6lqz9+s3Qzz87s3r9O0Xa/8ou86463jo88lfq+PJ0+s2lbMas41yEI3q+OHMsXpBolFeNbFPd3d5G5UTjcxWmd3Y0uavq20uepI4xKi63Wa657bI2Ql3sJrDCTA2/YdUy1N1cOnLO2iyrdGqgo9phGvPehtc2lKH7H+1Xa1eU/VIUjfZtjTXoT4j9+2zvcM5qZHoyb8VkHKZQ0yq8Rpbs5wN2Q853sWGZqeOv/dT+azqKfflemHOlZE2bGhCxrDR+r3yofKUsgwv1gfdty2uJQ4mve3AbZtQZTku0lqstA93j1zNs5avssHypOP8IRU/5diJf3Iseiyrf4aPhUmdJvvEpevPV3/l8nN/oe3o/Yervy6rpyl18Ty4eEu7WomXj2//XAZETRwyg7k8aHJiUhkM+gHX4KIMQvwAsthfB2DLK5FaHi1/2TZgBKh8L/+HTKcx/+1vg09Z/h7a4dJ4UUzKKH5oS+pNGaOu3X+Ktfpf1zfpO/28K6P7SNdD26qvu2dzmfJ8Oa7U1dzP6VQZZcAtzwb1k0G1SaeeL3U3dtr8h2+qv+0AfcOHyp+mfMfiUX7wNpY6DyHU5D/5odr+9TvLjGFS4iG+DOIl/4kXpq0vpAxZnVKZ82UMf8a+W4t1FCub/7oNNW/XDzSBuNfF+Hn419pt/Wi3NOV6tT5CfOl5E18H11OqeXd7VJ8j10o9TIzdM6UOb9J3pi6+3tX/c17qutjveB2+2PJDvW9j5OPubFdtxrLg7G/9+7dl62tts9IGxE/FTtN/uf6++cekV+VLHL9+p+M5M2HtnO9X4WFsaxr+mP0nbct/v5QyQl6UPyXupg7yz5So/Pxsi9EXddt32cok3ASMLdmXfS3+lzTar8LZdxKvzJavz1qsSp2cv5R9Ngajrsdvi64xHrERv47rUgezBbpxWLbEl/Mg/hKPpfjo6/o8P9d8YuxSZc42DXt7O9V55PPst3dvmtj0Tfq6ffbM9efF/nYUX2ub6rW57rN94tc1XiTOus23ayrmS/bN1+u41o5Dhx1z+iPvZaHn179ND3oLWf4s/gpWB5XtaDqNpP1EolFZYbRLaRf89XeJ3qe026f08JDSXtLlz832h7t2X+qSPqS7fUr7O+3HlA7ybD4urmo6b6xejGhUJrF50iSTcglG+TxPsjz05Xk34ctpJgGnTeilMUXP2Qn3I0WjPpFUE3FdpzbBHSKHhmzhvD2jJ6X1XJUh/lo6hnnY50u9mw9nv0W+tPbq52Pft/RHCgY+xjn/Grc2CS+T7Nrgqj/rdYltaEP3gzDlGmy53/xSziVds12e76zV54cAuGWDT9/EDy3YbdmQY7zhQ8uwjZPxqy4rYmepnMb54HiutynH5x351qXxPNU6K+FoikVkg4uvKWOOhS+zfNaCWGT3ko9KWWvlS1yOSSNp/TEPmNrApQ18y8BGDbJ6HNp9PbDt94qtKi/jpzGQK4PjaBBT8lYDKD1oy3m1sscgrQ70IlvKQNwPrttA3wy6fZlShvgjnIx6/6nPzWb9PoRii6qvDB5HmmDAmutb8lL+aP7sz0v9vJ9kcr04aR32Lg1OZSLTfTuV8U36Wsrvto7/wg4m6qC159PqMO4PW/y12G9jQLzpB2/zgj9zubEfZBA+6lXL9DaMz5VRFTNvgxdbhEk9GSwMqjy3fLaV3jM+2TTq2duGyTPg09xXMVz0cStDM2Pq5dvyUvqcTvm351HTa87CWKl2KBP//kyp0yu1xXbJhiVelB+W/CPxXvRDyyM/b2xVeZc6z/X17Uev9uj3WuxLnFt9c/0N/xMfPjb2/TLdfz0WNb0WHrba8tRuim0qzpNN2R9H+KC0N5VPt1H5czFWkqbWR0/2pezah7f65ngZ/md+Qj+sxLkyrIQi7wf/eal/Ubx5G5b7P6n/2jHXPfLv8JlhS/xf7G59nI+1pJFjvh/5SMdNn0sbM+/ZGv9sKW3BxCnXb9grbcX4KacvNgyxqHC/ZJvY7o6mTyo2R75b7l9CX5oyLHOmDibdWkzHvTKHO+UfkWtliVjURaDfpcNnn6X9bx/qqplnIBoJI6vb07Jo1AQfWUihRaFt0agKRlpEys8vCUfnjNULEY3yZK9Nzs0k9vjJVCT+yCoCLSJkYExaU15tcHbCXSeiY3Isk/whuIz0zd793q6WkjKiCedaAz3nPbFhNc9m/+GQ9hKPnj7wQ7+X/aZi2K8vPLM6yR6dnjRuOWY/l1jeH9L+7m37lalqc4lPWEdnQxCDEb8R27v8kvbJB+N+V6RzXXOeIiJt2RDW3XHe8li0Qcr0K/K63z+YlTEiNvp2UPwa2qtiENrb2pD7QjLtStki8TPHUq4T5MwzLm7tXhQrHQtzvzzjfKvLKHUb7bjY5+o75xfY5Z4x9ZSVTMKHLr+fB3n2eyoW4bUx8OtLrvMgUw/swufifPNAZZ5IqLQl3/pfTZ0ueq4MemTAawaGNT9zX9kYXp8GijkPN/EIBnJhXqosE6uoDOdHM3As+TgbJO8or1Dg8M/PA2Bjo+Qf5rXs1+wHHS+bp7dB4r10Xe4vHQeToxxbr3kA7cqaBvT1vp381fLnvPJ1l1/2m4lJlJ99puQr/Da/27Jq+i7WTGUs+UddL8wOYWv4q6aJ4maZ3rbBpq//7Q5ZMP7xNq4IYVOsRCSen4nqI7GS1RqRMG39nm2zsQpFlsiulXbTfV9iMtselqHaY39+U+xwtkd5RDbo+Oj7qp7bzI64lrRlZZWe/Np2Wuqky2p+t+3Q1ieKsWdwil/kg7aSJ2RV0hvbRt1sLHz70vbq+qp+q/jaMaD9LxyFoku1Y4vZzVgdYUOu51xO5Ifomqqv+LMch0/CvLVdxf+aH1eOYnPExPUPKoa1vNflhz8GYzVe/vPgotpr+g/dbysb8hjpq7bNrbTnSNAyvrD1qRy/KT/WMeyxaUKfSZxWeKn+ab5/s/QDJ7Ys41Nn96PG4+7ZxXyD1UH3v/ks7X7zu5sUjUQwyv7QItOmaCQrlbRfmxCl5yvi53PG6kWIRnf5l55kAmomscdPpmKnLzxvyogn2N2eaauRbHMZk02ZWHYbXP519VR7TuqpYdo6L/lJufo4bBD4Fo/epqUyywRYVvSoDmp1YiwrX7Rt49wIbrncrbwWbCv+Pbwrot/hPosBWXSQoxMDex5ONNjyg/Z1FKvoeXWtM9DLzz5UNqi0OlbCULm2ZUPOeyEfydPkZ2xRMT0in6VYlfzVdlARprp4tlZmvrfFwMJ949/AB3O9le+9TdrPpi5DzJrzC/qUBVslFhL/7qOJqyBPb+viZxlQ5WPbWpUHQnlg98gBUbFXDwgXy5RBnwwWqw1m0CbbPGTwpgaG4pd5IlHZDK8Hz+d8TNqFNFLe5rHUXerU2om7tjQgnPJ2z8n9+fnquz4AXnhOntfHOa9l/xk/id8kRu3Ybehxd7b1664P8ddLHfR2iXEuA+3ZdldWy0PST6sZVJlzXtk+l19Ob3wbTDScH4rPnI+soBGUoezSsVo9L9yKjzR/Nf/VdhXV09tQ6i0T4FxvXYaKpfHPuB77192P/BStljO2SB7bfpxtcM9EbT+6JpO3tb7x1OeU34u90vep65UDZ/t0X/pXiVnzk46PtjGft/psMys+H8fyTPdHm7TqX3PTZbVVHRGTtf84htlc9hE+yH4JeRm2bwt5QX1M2fq+ahulztIm9dG2nRLnzr6N1xazm7F6jA09fso3EVfmmq67fm74Ya6Di4lm0uTd8jPsqDLydbFZ0vS8nF39+ni++K63L5fe2+HL8uX69Kufa1nmHwUufeizlmaNl/4dUfzhhc5R957Oleuvm7HyRlr/7OLnFyYaRQJP9s2WaFTu661p6jzK85yxun3RqEzWxiTNToZXJnyuEcROj5+P045GaSeKwYTOTVZL+v1+rM5x90edal5DkBplLjZSV8+T03mbwnylrnLU9kXX/H0VxzD/ln5zkq3zHeclboe36W5fxbL8ua44auWGdXR2h2lGGSNWlZ0pVsHzhqfgfl2F1bZVhXV3nPY8FmzIvg3zGfWwDI/rEz+9rIU0C+XUWLz7iBfB1riEq58KOy5ujSdTr8B2c78843zb8il+KHVbF17n/AK7Fnw0+VrVy9Z7xUZtb3heB99f5/czlEFU/vwxL3ls+elJQ1iuHajlQdwsOiimZGCo8rIDv5E2vB4MHKeJR1BGHINRlrkfleHyXBsQbuYVTlj95Mn61eSpfJevL9ky+8+WUQeueoJj748yl64v+K/bl+tgJ1cjz/rsbLsrq8RCT9aWB9FzXrkMl1+2zcS33u+iVLd91K3k2ycm4/qoS1BGkM9IH+Vhr/nYbLarqJ6TDaqumeelOhn/KLtcG5jqk+/LRGwqW+VT7ilbetptP84xds8ENs7PVFuWrvd6BXmVe0vXez1UXYsvdRtT946JWVSWjo++n8+b/0vdluIb2Zmv6byCrT72fhQ/XbeVlWymfBc/c0/nt1GesV0/J+dRf6rL1vdVv7UaP8nbHku/q9rBzJku1225iup/pA1zOdauznVQxvxdYXkI8zZ2Vf8tf/dr/w67TLklhnkFkIwh7DPFhi7M6e8EaV82/VRf1T7MPVOPYZtJY3wm8fsmfdttnZ8LfWbyqc94Xkq5xabX6dt3+X1b69+hy3bW/D9+jD7XLSEalTnPlmiUopVGAQMSw3PG6kWIRmYC5SaCxZnRNiEXgJIu2AJSn1cTwzLBU+9FcfnkINqJYjBJdDaW9NN7T1SZJn3NbxIjAjsEqLMcjQ1BZyDbaGQVRElvRaBaT1UvZ3O5H8Rgsn9jkj35s5VTY6leZNxiOV6cXn2reZps2vKDuR/EytzPfvRl+s+Np+6XWQiaGDVlBDYUf6wLDaXeEksXJxMPU1bAxVKsjmhHpZySv4qZskXiaVai3R/6S83j2CkmA9ujek/5dBvmWBjfTH3BiLexeWIg8KMrUzOayyy+6IysPe/v1YFM/s+vDNz6IMtPHsrgbKTzde2flwZZvQ5twKtXErSB37ffe/va53JfBnn1mhk4qrzj662eqk61nirPoIxeJ5X/4jUZsPU6LJSpJgbH51XrPA8oZSD6vguwpf7atwu2z3kt+NXFxg9WhRfhZ9Rptm3ca3FdsM2X4Z+bbbdllfsq1v55/XnOK9tm8yvpXXxrvRU/vi4l/bJYFZbh83jsZ8+wi52udz0P6hmVmfN5801ZmbcolDn/jLLqpGxRbGpCw8zPAiPZFtOGjqiD80ttI6ovc/flPSeRTTEvytYpL7m35QdJV4/Zxqj8o7iJbNDx0ffzufhzk1lro9gyYhtMwHVZIlav9U8l/faEd6uP6Pzp+nm2nW39mZ4uqI/pG/T9fC52VyaHX7zf5s+eK/9ZfN2Z2IzVkTYc6e/ZNyIQ6T6u+kNsnOsg4vvoN0sa9w6iLDRKP1Pb6khfRUjx87ChM2yEy6W+wcdN18HFZomf4n9ll1qBK/XXPjO8rsQu9Fnncdg2pwt8v9bOgjyHvWvzgzanWHm9xchn2FuubYlGqb7j6PBv7bmS/rP68mxvb5CXKTd4P5K+L/MHP5bWadbOZTVQtPKniD67lMJ7uR5uq5m8XHu8w2h+p9GyLWuxanOUIzQQyf8FiEZOhAgmggJH394RTK7WJl1l0qi2n9gJn2sU00SxNjDzjLNxmpS6+2P1SitrEjtmGwSAsx2LTWPLWPWlTMAFTBuL6jdJU230vvTi13RfdUzzvWqP8a34X4tw0tm0OoxOIuj8um9bXT0rPjaStxz9/Z5f803/PHzp7a+rgMb9ecuW2C1prN+P5WWT+UXRSOIt5ctxxPqoWAW+GLFpTAt3Pg7G31K+2qZa7ns7h32lXfhYCTtTvZ2/jS2+DCtwFT+Y/IL+INsq9Wz9zPCDKzvfN/npPsHVT3y0cayDsmAQ5ifdZXC5NJHRfZAePMsgUf+HL5/bwVaJR8tfb12QgaP9b3Utq9gtNrZBmH62nMtkqPigDqpGGmdDKd9d2/Cd6V8DG/zgcR7oab/Nv44itoof5ufjQXGNqfK5+Glxe8io9/TsFCvnxyYm9LoGcSz16DbYOhsfKn+v2bHtB2dj+09zt3HTD4FfS3xVO+kTYOXnPmlsdVxlIihD1X/JL/p68YP5L7q1r6QN4iE8TRPRxfKbP017Uu3Q2FD9McrI6eZ4bN1fnnDnvHQ9j/FjTSPtKXOQ+eo8BHHatK/UWdqNzV/K0S+ErnHb8oNqGzlugb+XY7Zhg+ZX93W+nMAX4qeZN/Wi5sJOrZ/xnS6r8TXno+OphADFlclTldV9HfpK2HP5C+eBbTlOs32V6eoHzZuub8xlty/XRdm41r91G1T6MO4rsaq8BUyYPKM2vOAr8Zk/Fh+OPlDHqfjRl1dslnbTeHd5+LZvfRU9q21ei8loXyXP8p2k04/71X/LK3KjrY9ip7QXyaNe1zYOxqq/qg2GFdO/RGMD7Yf2vPG1xF6nm+snNppjGZsvjydlfD/GqUfmGwg95p1G+R+gv/112n32Wf2TX1rrL85+SHe/bvckTTn+Ot39Z7Wh5Gfu1fRdiBJ++/zDzZ/k/hHH8nLqaOuYE4WMb1u++tksFmXhaIhGuS7u19NyOdEvqG3Equsf0bwhqONNi0ZRILh2ZOMNYMF3L813VZB4dMcPO31VxzW1mfJFbgStT8dzGSw+UiS4Jl+eZIuelD3jNjIG05+On5P8r3we1qFMTOzA/WPL4flPw8jL6F/qpE9PwuHtNN5eBi+n+Qam8JtloP4jdHVe0P7JOf3DW30H2zyv0cftH75XMmY+zV9HxKqJY6vxVHFDNFLOOC0o1wg7NhHLMzFQOv/l/yjg5zP5+Un6oSsSAW9EQHkU/zdS51BweRJ+z9XW2n9YnWhZJo7TqqlzlUk+j2orH8vTjbS1LZ8VZs3qATjb8ll4/4XwEtb9Y9saz1/lPwkvFeu1HQi1TFldf/oKnUvZ/qh8m/B1rJjyqLyfqM1sx0p+qOv4OR6i0RMF7xqBwiYGWEcxkDvPI5cuHpUfbe4TDjKycPTMv8yfKz83MjF5/qJR7vej5f4nLNN/rixi9yfsgxl3ME547gzI1qax7cxvnfJbsIj5c495tn9j/NiElvmVGc+p7iJ6rb+b+Pp53ojVidvvEI0YPDF4ggEYgAEYgAEYgAEYgAEYgAEYgAEYgIGJgYuJRj/++ONU2PUrc89JDcVWeIIBGIABGIABGIABGIABGIABGIABGLgcAxcTjd6/Hz/xSwAvF0B8i29hAAZgAAZgAAZgAAZgAAZgAAZgAAYuwQCiEcvPWBEGAzAAAzAAAzAAAzAAAzAAAzAAAzAAAxMDiEZAMUFxCXWSPFG9YQAGYAAGYAAGYAAGYAAGYAAGYOB5MYBohGiEaAQDMAADMAADMAADMAADMAADMAADMAADEwOIRkAxQYHy+7yU34vGS35CM/iZ9vvDLu128sfPuF80DvRT9FPnYqD/1Gptu/u7H4xvH+72rV2vtOneL9Q8DvfX12eOemQb9+nu4fpspM8gJjAAAzAAAzAAA8+BgRcgGr1Lhz6x3aXd/m16kMG3G/iOCbAbYLpB9u7wzgyyk8vHD8KPA0Hs9AP1H9LdXibmctT2tfu6XqnlZa4tN0g7+Zcy6vHYyUDJw/tF/FyOUr+a72k+Wq7DcT5ef75MMpzP6sTDx2Q9n3PYch151JgtMbAW85ipa/PjN+nrV6/Sl2++SSnpcxXf7z9PX+U08lfS1vt/+OL1uC73y/FN+k6z/+6NSffVF/ZHAnw+X79T5et81s7Fztefpz+YdK1eS/a154xNzd5x7X369vWr9GXJW58fa2fmSPdZH1JtV/ZaZr5ycw5Oar/4qH5G+0KfZ3+Kf40fGxeTzxf8UvJ4nb79fuF++pAsC44jE9elPHR89HmUft1Ha+27fudFcYq+r6J0kT0Xula+v2fWrqOPvVCdj2KFsmEABmAABmAABmDgOAZuXDSqk94xcXACSxF7/IDWTXCaYDTy+JDygLlPpEseakAapT9mAJfzObwtAlHPuzw3D+zthEsG6bMNRiA7xoY0l3VsQ1qdYJiyTy/jWFtOTTeLRpWfXbDK5tQynjB83SkAACAASURBVNVzhWXfPkbHckzMZ5+O55cnniqNYefc16ugUsURfd7KaULBEHGssFQm+F4wKM+oyX4TYEYeWRh404WDKhKspz+GmZzPV198nr5+5UWJarMu/7s3WexoZYoYouohwsUkGhXBrAkRSjzbts/1qb7PVDG+BtGo+GqKvWKvxFTFTNm/6ouSp4+Pylfnc2oZScdHn0flbPTFOU5ORO/1KzGM+oY5T/t9FdkRXzumf+n2aN/5c0Qj+08u7x8+4x8YgAEYgAEYgIENBm5aNAonrHoAGQ589QSnDoCnlUXdqfMAOQ9iw3L7M8sD5CwWlWfNip2oDH2t2ns47JMIWzmPw93btH+02KHzje1cGqQfP8A/vYylss913cetfC6r1KLJ0eP8cy4bnzSfsH2Meh8Tc+9TY/9G/ibtRvs5LW2dVFdxRJ/XOhZxxYsjajK/LRoFQpSpxyzo5HqE5ZrnRgxqvbPtVYzIzw6xJ6eLylDXcn1ev0lft+dTER3epG/zKipVd22TPj/O77pPzee7Ibqv1svX8zGfT+lnlF9Cv7XyFQPH1b899ySikeVnPVYbPsrt8wyiUfZR6SuW8lpg4Jj+5Sj/6+/8hbKOyodnGVDDAAzAAAzAAAy8UAZuWDRaGhCr6+GkVU1wtgabS/f1dX1eIKuTJhF46mBVlTnZpOztkOo88vkh3edyitiU07fPZxaNyiBebfXTK6JkgG/SGPFLJnxRfeRerVffJhg+L2nPf7QCR4vJ3SFNK41KjNQ2PpkMlVir68pXWngcYtS8Vc/aUOsovh2suEm3Y8aml61ASvhy6fv2Su9vn67zF9kVxyOqTy9P+6eda6aS86duM7mO+7u3bevpPt3dZ5E0+1PV09n7uImhFhB03cb1TdFoS1xYuq+v6/Ncn2gFTLlWV77MNg17e/11Hjn/N9+UbVF9hU37rEWj/uxJPm1t6aGJB54zEdo7D3MMC0eHd21bW2tjPh/HS+5HNDMfVwfFgI+J9knzbd/OqFZw1di9Tt++01seF1YerZQhK8FqGQvPa5sWz9f64rqi9lyi0bSq0MdK+lARmDoLuj+1XJjvmjUhspSlVuIu+kPFmDRMCmAABmAABmAABmCgM3DzopGZhJbAq4FyOCkeE5w60F0ZbJbBqB3IlomJHqTqczUgNpOZbEcfNFfhZNit7G3gVtFBys3p83lOp8SjJdtW4Z/L6hMtvSWvT/LEBnkXiZqklfKduOH9b2yp9R5+qbZosaXbYp6TgX5LH0w2Rp6SNj5qgUMmqdNkpzCzwoTYFrIVCDjt/VNio7ZB6mtFIM9Hm9wpscSkb3EwYoq2rZxHcYpWvVm/mXKk3u4Y1UfqNflWPzvxY/moE8YcB4l7ZlH7pp53AVJxMdqWrU+3q9iRxZZoQj5EmFmgEVFHCTiyDUzXTc6zMKBFBX1dnjPiQdtu9OpV0tvNih2yKqiIFtruYa/Ur6w+kXJz/vnZ/JwSj0yeYtfJxxyLfbrLAmzv5xZ8r9lU5RWOcgxFKPJ8+M9+q23jfOZh9GHin82jiYmux/v07Rv9Tqnq+77yqwtKY2ubiYWqb1ooowpG4/maTsdb27N1vtLfZ1uKTxf6uoU4Je93qVNJL3n9kO4O6t2Crg8U/6/2LxvfR5JHOa7VQ+zj2AeFxnf4Bb/AAAzAAAzAAAykDwnRSE2262CpTXDyL62YgW4wAC+D0WDSoQep+rzlt98rcaUJSSIaZBvsYFkmxeo/rnripWzIE6v9fl+3fqjrxw8CNyYRutPQ9Zpsrr7K9dD1qnYslJF9o+uVyyr+Cvyr7Tjj+RA4PANiw4LtkQ2h7fHzo9y4zpaHKoYY4cOVNdK38vb515CkDqqM8pxM5BTf5XoUO5VmIeaeNVM37ydnt362PCcCQXtO5zXVsfwCVK2v8Y0v8+jP1ycaVZHqdXkx9xCNqpDkP3ehQl7wrV/gLAKTvHi5fK5b3L56rQQvlU7H5vHnldki2Pg27uOxwISOfS3ftqWZF3v/8TZb1s3zC4KOSdPqZbaHTYKeFRnN82EZPtbZxnptxHvFbu/rJYHHpKt+PL5vXvD7Ul/TyhrtedgfXTM+0na67yOTbu2ezoNzBsUwAAMwAAMwAAMwEDJw86LRkmhRJpbhBEUJBluDzaX75XqbpPc0Mtn3g2q5PgbLdoLk0490ZWA8leXLdelXG8JaWWri11dtDMEhGuBH15b+E13q3PNVApkWO46wfV5JsC1+yARD/H6Xf0peBAvDyBwreXY6muckBgvPu7TFb94XYo/8Mp6/r/wkfpf6PLj8qxi3sMVH+bg838uVOoyjlDPV3eexJBR4u9RzoQ9ynVteo2zNbD2volHEa63zcaLSvEKn1nOISVXE0StLnAgQTvyH/5ZWk5TreiVQXnXUBQdnV78+8jVCxdq7eYxo1H65qwlFYd1UfNZiPt/Lsah9xYjbsNekX2Cis9xt0HH3QnvO2943zJu2o8TUnveCbXJ/Ja51JZD6tb0s1on4FsSqb1nzv6gWllFj37e+KSHwIqJR/+4K/LEQp8nvzWclfqqPqp91P6/63PbMOitR+x7fR4aptXpITDmGA0TjR3yEj2AABmAABmDgxTJww6JR217jJ6x6ABkOfMcEJy0smx8DKTcxaQ3JTHBaeXl1URUi3DPFBjd4LpMaGQC79L6xlvyjiY+uRzDo9/mUz0tl1etdSMlptR/DVSfreU1iXvaDj1Vo47F1eXy6MZER36tVOav+CcoK2Yp9YngJ6mwnT3WyZIQPV1ZJv9+nvfzMubs/VnC1ideSMOSfc7ZZuwIfyDbGpbiu5F98smSX4U37tJ4b3zibR9uN7dX3rfjS0qvJfCisFGGgbR8q53Yrmc4/fkm1fZGxbD/66rW84NqKRqFIUcQE2cJk09vyrVBk7uV6inD1ET6seeq+qDI3tX8pY4GJuY3ouB8hGkn+5zgqBiafuS2NhqFINFrNS2IorEYrjeTeKUfrQ1OX7Kcci0e33SjPeq1/f5QYqz7WtOdRj+X+xeWXbXXfR6Yua/fOwQN5vNgBtOEMDuAABmAABmDghhm4adFIXqQ7JihusBlOUPQER95B4975ot6nUIUGNQAuA1SVvn0e24PsoDoeGOs0+nwMqPtgpeR/adHIT/SaH0WUiAb9wcSg2rxUH19GUNcLN8QaS7cyyTEyxXvJJvecxKs+r+LleQnys4xUPxlhxJVV0uuXALv7QzTKPq759QmdLt8/p+9FMXf3c51LfZcmnmt1X7tnytY81XPjm8AmicXmsUzotehTBRhZ1bEpGskvoTkh4Q9fvEnftpUlRVSQ9xdlW0uZ6h01zYYh4GgRaGlrkk6jz+c2VeogK2G0r3K5jxSNwvZT8syMrfSRutwF5maOdNxjcTevOhx9/1z3zfhru/R5iYkXdJoAN8VybaVRjV9fiXRKGfqZR587H/rncyyW2u5CnKKVRrU/Gn3e1AeWvOSfKiNOU7pun/+uqPXYacZ62g1BSafjnME+DMAADMAADMAADIQM3LZolIPeJp+ybclMIsKBr5vg5DxkUCvbGtwKCJks1TLU5EiVPyayeqBez8c9N2AuA3adftzvE56wDjldUI/NRrBSlvPB4d7mb32QV06NSUKx1T0v8bBiRZ0M9HvZ387Xvd6bdQl8tfFMOEkJ/DvVNZpYBc+J7SLqSD2j+EvafDxJNNI2eVv8595Gopi5a8qH1i7rb1/HWtc5L+9L44tu11iJJ+13lK2ZXW5P2p+POhfRpm0FGu8OaiKBF1b0SqPmK78aSEQnsaMKR7KlyYkRpXwlIpntZlkQ0vdGDMYKl3XRaKQbzxa7ThCNRl/r42z7ipy/xL3Gu8ZN2sM4jr60pNdM++1n0k5aH505yYwIL+LrsxwXRCN5v1DfPvb68/TdF6/H9rTg/VKWhSYiqW1n0S+keZ6+XGBgu6667bj4Z3ZzP2F8rtL4PqT3C0Espzxcmv3bdH+3D/p6l05/p5TyR7/gv49M3Us/Mlgy97rdqm5cCweL+A1GYAAGYAAGYODlMnD7ohEDQAaAMHAaA2Wy5QWA0VkO4WZc48vkJfuiTfInkeAl++Sa617jtSisnSQaXWF9EY1O6//53sRvMAADMAADMAADjQFEIxoDjQEGFhioK7/M6h/lK0SjK5wgq/g8uYDXVn8sihCf0jbKDtr4umi02r4XVxpdYZtANApif4Vxoo0SJxiAARiAARi4WgYQjW4cTtkGMrZ8jCX95RqrAq62cT75pD9qC30byLziqEwqZcum3joS5cO1G+ZsbCNaEhivgmUYrAwWEWV8D3iRb3xnzG2+x7H3CzWfa4z7qEe2ke1pPXa0gxvuixED4RwGYAAGYOAyDCAaMYBiAAUDMAADMAADMAADMAADMAADMAADMAADEwMXE41+/PHHqbCnVP7++KefEn8vxwdPyRZlXUbBxq/4FQZgAAZgAAZgAAZgAAZgAAaui4GLiUbv379HNEK4ejLhjo7lujoW4kE8YAAGYAAGYAAGYAAGYAAGYOD5M4BohLDzZMLOJVd+0Rk9/86IGBJDGIABGIABGIABGIABGIABGLguBhCNEI0Qjdi3+klXBfKlcF1fCsSDeMAADMAADMAADMAADMAADAgDiEaIRohGiEaIRscwkH8x6vAOXx3jK9K8bE42fqFNBiCf9Hj0L8C9S4f2K5GP+pU45YPF5+hTXnY7oZ8k/jAAAzAAA8+EgRcgGv0+/fIv/yr98j/yS6H/Of3NTs7bS6K/+tuUf3r+b776Kf1RnxsxKeeRf7bXPWvSyEuncxktv/B+zesv/v73p4s1xc6/Tf8U5i92zMd/+vn4meXj6jLnccktZpt5/8ev0l/sdqn4Tp//6acn6XDsTzhrX+6S/9nqpclQyWP/Nj0sdhBjgpK5PDbfpfLWrkt9tsuoP6m+li6sl5o05bo8TnB5Oj+s+ajfKxPM6Ge7rZ25nosTxMWYP///Ynz35lX68tWb9F36kPR5999W3b//PH316lX66ov3Kenzreeu6f59SrtdSvcfadP9wfYtj2s3V8JSaftRe/mQpH6mneT2tdovXrJetQ0be1QMi72hWPyv6e9+8dfpZ/L3j/8afw+VvuOwwMV233p0G1I288wleSFv+IIBGIABGHh5DCAaFQGmiUH6XAsyWaD4y1+lX/68CRb63nR+naJRFYy00PT79Muf/yr9brL/I4SiE8WsTbFIbGxCURH49PkTiUa6g1yeSKx3IqG4Eg72Lz2ZyPnv093dMZO1bVumejXByAhN94cTBJXtsnVcLnO+MKmM6hjGcp2Jy9j8tGUWoej15+kPIhq186Pr1oSir9996KJROX9O/vxo0aiy/unEkzMysyUa7fdpr4WYqxWNakwiQendP/51+rt/F59VAel//Uv0AyC5/4gFtNI+Wj8SlXF0+3lO7QRbY3ERv+AXGIABGICBK2bgBYhGanVRERq0cPJT+mO51kQjfS5CxZ9+Sr/7+7+qq1uyKPKXW0LLFYpGS2KYquPRws3aM5cWjcpKMVnFZf381IPrZy8a5YlK+c/+xoSmdF7bwo0VjdrkV08KT+4Et8u+dOxt3WSS+CGl1RUEKt3JdX8+efzhi9fpyyYU6fPjY/NN+vrVq1SFIn3+fHyQPlo0WhAnnyM/W6LR4W0VrR9afK9WNDo+Jj/8y5v0s//9f9IPU7y2+9jFPmbK6xm1B2xn8gMDMAADMAADN8PATYtGdjuWW/L/838+cntY3U42VrcEW9SKWGLzL+lFYGmrYsoWnfZuBLs9Tba/tTwCYWquixO/pKzgWJ5dq28glmWhzAtk3oZeh6D+UlfjB59O2ZTz/ou//1XZ2le2zn1Vt6LtdsfV8/jJ6XkG3WuiUZkAtDhnP+jVNjI5uL/bl22RxU/htow1saSJMlJG+Px6PYsdRdRZKKf991vi6OuRkrMh2yJ2rEwYdZyKD6UOi9u61uyz/70X35atf20Sete2+uzv3qW7fW1f8h/9XH6OjbZDx6raWsuXZ7T9VTSy8TX3yxdlnXQOP9ptKjNHbpJafJmf0fnYPHKZnjm7pcnFSuL04r7IUzrs6hayvI1sd0jTF/n9Qd3fpWBlnMtjl9JdFz7a9rQmHpUy9mllK6pvoy3GG/HRvGauNJumDZT4+vYzeNb56DwKw0UQVd9pzibLm22H5fmVPkCYz3n09jaJRo5ZvVLniLYd1WGqY+fftbl+Pcdn7Z6N38eIRmnFX6UuxiZbLvfxBwzAAAzAAAzAwKUZuGnRqKyeKYJIEx6yaBEIMqurbPTzfwreR1SEEC0k2RUwdSWTrI7JW798Hk0wcgKKtrOINdruUuZxYoqUt1P5T/U9QjSKRKQpnzW7Jj/ZeldBKvuxXS9ikfNlIIiJDcc0FD1JGpP4x75rp3ZKMvGZyn14mw53P4zJaJl8jUlVn2z1VTh1UtInT31y4Cd70hm2yVR/vr0jxE3qJrt6vjmfMXHM6aaJZpnA6Mmot2W2weTh6hzZUvynbZ7KtPWd/BNMsmYbqqAjPs+TRh034aHnHdkdlKPrI3nPolq2f45tTT9EH21PzddNUptftDjgn/F5avsk1lpEKs9r3xs2xO+3dqxiz/5u1Otu74SjeysSPdz5dxTNeRhfi1jUhaKN9JHfVby7CKvSTbFr6UUQKSyY2C603SzWSh9SuB9MVjF09FmmjtJf7DbSr7Sbwe+7dBBbsw1yXso4DDEuuT6u2Lvetqc6OD/ZOrk2p/xdxRxVV33PnK9tT/MxGAwOO2oaieO4HqXlGv6BARiAARiAARh4WgZuXzTKYkUTXIrwsSaeBKKEf8aLJ3WFjH6ptRU6/PMi4vRVOkaUau8TMiJOzk+LUvLC7k8gGnk7vL9WRKMiCnnfq/TjvhbV6rlZreTLbJ+fuuMYE5+tBmsnJPOkrok2MoHrE5GFiUaZ/LhJzMoELfSLz8M9X2w09jhb/PMykZRJXyS+9Hplf1mfiI2xT13Zko+zOedhfKsmwvq6rttcXmCXykfsjI4l37JqSk22w2dtGZs2lHpqAc/Vc8GX3cYgVi9yVUMWdLqY09rs1nayh5T2aiVREZF8HsJjPgb5lZVLwYqmHh/9vD5vcbdipGVH8tAMadbrfd9+6ucuGOUyTVvy6X3/Vu9bcSN4xuRp89D25vOSV24r0n9oP8i5bkvqXNfXt+0uBrc8dLniu3qM/FqvrdoktqUPKb/f6Ge/+If0Tl2zZbR2q1dMmbSBD81960OfN5/xDwzAAAzAAAzAwCUZuGHRqIo3ZkVJ3wrjRJgFIWISeHI6JXSE9817d35KQwyRF0xrUUTyU9sAvI1GQGp5GBsk3+XjbINLG5ThxbG8oqdc6/YFotWiXa7O4m9V7rBRpz2vaFQmDd1+5XMjkBzX4SxPQOrg33Mnkyw9yZGGHV2TFSJ+4iNbonz+u8XJyFyfuTw7aZrr5iY0atIW1mFlwljSL9yf7cq2u7JlIhXkYZ5XNurr5bzFe66n9UOxVeUjdV07ljzb5FeXO56x9dm0IajnyMtP+OdYn4MXU574/5kdZdVQ2TKmt6iZXzubt57l9LL9bFMAOqdoJP4t/DUhcoEFzZk+r3GzvC22JylvS4Rs9+f+x23TXLA122SYz/XL7TEftWhUnld9dOm3m1iu2qSubzkvbbvWObLRiGXH1LnY4UT6/lxtb1UwepM+/79B+ytpfQyidMekiZ7j2i30T9QBjmEABmAABq6dgRsWjaowolf6ZGGir/AR4WLtWEQNP3Ctn+vqFy1wiBBjVxoNMUTuu2dKGYEAI3YpYUW2YlnhSvJdPlax53FlRKJRL/9PTQzTW+ayvYuiUSSe2fTDT9o/5xWNztkYzcRHTSK0aFDLs0KEnuSIPXFeC5OIIyYxkm983J5QzfY4W9SkTcqw9ap1ngSv7ifrE8ljLjd/gbiyJY9gUmpsUDbq6+X8MaJRUI7YGx5VuVWw8RNOW/e5zva+XQUSfaG69OIfOX40L1GZz/BatNJIfNSO03a1T7nSqNum46vPRww0Q5r1yqdvP/7zyCdOH98XETxsA9n2lXaj7a3t+5Duc7vpolGtp+k/FtqVrq9v2+b57k9fn/w59mut29q9D6m8x+gXa4KR5K9WIIa21Lhs+jV8NqoT1xbZxIdj+zy+wBcwAAMwAANHMvAiRCMRih4rGi0JJ0PgaKtvungyVjf1LVVGSKkiSP4PqNgkq5WW3zmkRRQRWrJwtSICieDUj82ubmcWmH6ffvlz+SU4K3RV8WfXt/VpsUjOQ980ka3XvZcvdusVXrVM8cPwqa7vcxON6sBf/ze7TJDUy2r1JKcMasvkym4/qoPdpcndXEY8OK6TnWkF0tJkbmFSJqJNZnZMwuxEqtQprwTokz7ZiuHqdX/oL+0tflHpq8ASTayW/GBt6CtqJE9VH+1zP7HUsYonj0vlR5MyH5tq4/CbezeL31KnXi7eJ49L8VIdfGXMi1Nin7dJrvuj8LKUj0//aT779hSzH9m29X6h+X4RkdRKo9REJP1eJFP+BVYa1bY1YrLZbhT32Tbx12Bwm+daZtQWq1+9TcYHwuUKt8WmJtzmZ3N+h4MSjaY+0bGp6lhsaW2+nEu+Jc1yHazNri+ROpTjyr1//4f0s1/8dfq7f49409dyHhu2rPjL2qrz5RzfwAAMwAAMwAAMPA0DNy8aDaHoeAFChJHxrFvFsyAE5Yn133w1l1MEkbYtKoskc771GbOcXgs8ZsXT36Z/2lqdpMWafu7L0AKO23qWy851VDboOlQ7Y9Gqrmoaq7O0gOTviWCU/V3yL+88qnbWe7MvJTb++NQdhp/49PLbhEdiKb/a1UWAMpkZ/plEnel+SyuToTKRaUKA3monYkmf8MhEy01Wcv5T2tzZ2MmRTDZzPfKEM38eE0/5uflmW84vytfXZbUOgZ26fnKu8qiT1wUbStl1sr00sZxjaH0gMdXPy7V8NOUH9pW0jofZ9xKnWo/DfY1t5+XIyaSOV2FP+UkLf8LlbEckMDzNl5D26ea5MBUyvGVvsP1Mv2+oiT6yhe2QX4ytRaPctppwJGn09rWPfqeRZ6UwNQSj6hvf9l27UcJj3Ha3RaNczsS28/d034siK9wutTvNpM1/n+7u36a9vHz7iLZdfCWsSNtU4r3lLG73Nc3Svfri6ywa+b9ZRMp5+DhZVkt9nY+tjTY99/AHDMAADMAADMDAUzJw86KRFxf47ASwLio97+tP2Wgo66V10nXiaESzLs7dkC/aJLsLVldZxxoLu0LshmJwlT4/wb8rotH19Z9LwlCutxNxT4rPhmj0rHx1Agsn+Yxyrq+dEBNiAgMwAAMvmQFEoxsRTV66GPaSGzF1f4IvsSKorK8WeN5xkBUsfmXLE/j2EZNKWYFy3cLWdfnsk3D5rISQNdHIvbj7Eax2v6uVUf1az+e4lV/zczCGT2AABmAABmAABp6OAUQjRKN0C4ITncbTdRov1td58me2fd2Iz9sKI7096Gwx/v7z9NWrV+nLxb/X6dvvj/FjW2G0sc3nbHb3Sf0xtpFm8nsRjdrWUfM+tCvylXDftq8tC5HCnntH2xYjygeLed9qn7LlG+7z4lUYgAEYgAEYeFYMIBohGiEa0Wk9q05rmqASP+IHAzAAAzAAAzAAAzAAAzAAAxdhANEI0QjRiM7lIp0L4s4VraqAcRiHARiAARiAARiAARiAARg4gYGLiUZ//vOfCMgJAWGizUQbBmAABmAABmAABmAABmAABmAABmDgGhi4mGh0DZXDBhoZDMAADMAADMAADMAADMAADMAADMAADJzGAKIRq4FYEQYDMAADMAADMAADMAADMAADMAADMAADEwOIRkAxQYECe5oCi9/wGwzAAAzAAAzAAAzAAAzAAAzAwC0xgGiEaIRoBAMwAAMwAAMwAAMwAAMwAAMwAAMwAAMTA08gGqV02KW0O6Sp8FtS36gLajIMwAAMwAAMwAAMwAAMwAAMwAAMwMAtMYBohJKImAcDMAADMAADMAADMAADMAADMAADMAADEwNPIBqhMt6Sykhd4BkGYAAGYAAGYAAGYAAGYAAGYAAGXgYDFxWN7vYp7fLWtHB7Wt22dvfQtq+1dHcPL8PxNDDiDAMwAAMwAAMwAAMwAAMwAAMwAAMwcM0MXFQ0korfH6J3Gg2xSISikm6f0gNLwqYlYeJLjnQoMAADMAADMAADMAADMAADMAADMAADT8HAJxeNDvcq0Pd1VdI9ohGiEQzAAAzAAAzAAAzAAAzAAAzAAAzAAAx8UgYQjQDwkwL4FMooZShhFt7hHQZgAAZgAAZgAAZgAAZgAAZg4EgGEI2OdBTCA8IDDMAADMAADMAADMAADMAADMAADMDAS2IA0QjRCIUVBmAABmAABmAABmAABmAABmAABmAABiYGLicaPaS0l19O08f+ouv6ImzeaYRK+5JUWuoK7zAAAzAAAzAAAzAAAzAAAzAAA8+FgcuJRih0k0L3XKDATjowGIABGIABGIABGIABGIABGIABGIABRCPELcQtGIABGIABGIABGIABGIABGIABGIABGJgYQDQCigkK1GTUZBiAARiAARiAARiAARiAARiAARiAAUQjRCNEIxiAARiAARiAARiAARiAARiAARiAARiYGEA0AooJCtRk1GQYgAEYgAEYgAEYgAEYgAEYgAEYgIGLiUb//d//jRiBIAUDMAADMAADMAADMAADMAADMAADMAADz5SBi4lG79+/B4pnCgVqMmoyDMAADMAADMAADMAADMAADMAADMAAohHCDuIeDMAADMAADMAADMAADMAADMAADMAADEwMIBoBxQQFajJqMgzAAAzAAAzAAAzAAAzAAAzAAAzAAKIRohGiEQzAAAzAAAzAAAzAAAzAAAzAAAzAAAxMDLwA0ehdOux2aSd/+7fpQUC4P4zrA4igmQAACxxJREFUcr8c9+nuQSmKD2/TXt8/vLOOdPns736w96W81aPYeUj3Jt0P6W6v7J/sa/d1vVLLy1xT9TH5f0j3B5//+Hy4X35Oq84lD+8XU47Ur+Z9mo+Os0XbxTk+gwEYgAEYgAEYgAEYgAEYgAEYgIHTGLhx0agKFUOgcAJLEXu8SJOfUaJRE4xGHh9Suj+kLqaUPDbSG/FkIVA5n8PbIhD1vMtz1WZd/sPdPu26jSIqzTbsjhSNRuOZyxr3FuxuddsWjeT508s41hbSia85wgIMwAAMwAAMwAAMwAAMwAAMwMDpDNy0aFTEFS+cFBGoCSybolETZBZX0MQCSFjuhnCURZcsFpVnTXlRGfpaFbkOh30SYSnncbjLq6O8ILYFis53K629j2hk/UGnhD9gAAZgAAZgAAZgAAZgAAZgAAaeOwM3LBotCSDq+pZopAWmSPRZuq+v6/OSh1/9lBuRWt002aTs7TboPPL5Id3ncorYlNO3z2cWjYowpLbp6RVRIhqZNEb8ks4iqo/cq/XqWwnD5yUtx+fe+WA/DMMADMAADMAADMAADMAADMDAdTNw86KRFjYqjEq0mASaHCwv4KhtX120aUEtglCwmkcLRfo8jfcHyaqgYlO2o6+IqsLJsFvZ28ovq5G6INREo6TEoiy2LNnm62A+z2X1Bqy35KW2IqrbENSrlF9XT/U8SllLZdR6D7/UdDuEoxPej3XdnY7lAVvxBwzAAAzAAAzAAAzAAAzAAAxcKwOIRkr4qEG6oGhURKp92u93fStZLjOvzhliSRNguljSxBO1wmcITB+MOJTFpP1+X9+3dG7RyIhLUu4Q1GSlkQbd16veWxCNjHDWOoxQ1KMz0T7mHB5gAAZgAAZgAAZgAAZgAAZgAAYuxcDNi0ZajKlOrKJFWckTihJKNHKrhKYgLN3Xgk1PU1fSHO69aCLXB+RlJVFfeeTTj3TFnqmstvKpl+vSe/HHfF4rq9rZt465X3FbEo3mlUJxGXX11PjVtlFOsJLL2PyY+pF2YhhfspILBmAABmAABmAABmAABmAABmBggYEbFo3aFqouvjTBQIspW6JR++n6WXgS8WFFAJFyW3l5dVEVUNwzxYZILJFVPC69D6QWjcw9JX6Z62J7dFwqq143ApD2o2y766ujct7reU0+zX4Qnx1tb1QHriEMwQAMwAAMwAAMwAAMwAAMwAAMwMA5GLhp0ai+10dv/XLix6ZoJO/uce/mUe/3qStkROCRbVsqfRFXsigkK2asmBKt0LGCi00/Bf1JRKO6ymgIPc2Pu1HvqR7Ft+P+sHupPr4MGvjwGb7AFzAAAzAAAzAAAzAAAzAAAzAAA0/PwG2LRnnFShdt6mqeIXx8SOkI0ahAWdKp1UBmRc0QluqWKieUtPLjF1tXAWXcGwCMLWpLIktLG9Yh3zvnSiPx1fDB4d7mP28vE5FM2zme79vPjC+rcNTv5S1w5v7wD50FvoABGIABGIABGIABGIABGIABGICByzJw+6IRW53YmwkDMAADMAADMAADMAADMAADMAADMAADj2YA0QhoHg0NSu5llVz8i39hAAZgAAZgAAZgAAZgAAZgAAaugQFEoxsXjeZtY26LGC+fRjS78TZwDR0tNvCFDwMwAAMwAAMwAAMwAAMw8BwZQDRiwoxoAgMwAAMwAAMwAAMwAAMwAAMwAAMwAAMTA4hGQDFB8RzVT2xGtYcBGIABGIABGIABGIABGIABGICB8zJwMdHoxx//H2IEghQMwAAMwAAMwAAMwAAMwAAMwAAMwAAMPFMGLiYavX//HiieKRQos+dVZvEn/oQBGIABGIABGIABGIABGIABGHiODCAaIewg7sEADMAADMAADMAADMAADMAADMAADMDAxACiEVBMUDxH9RObUe1hAAZgAAZgAAZgAAZgAAZgAAZg4LwMIBohGiEawQAMwAAMwAAMwAAMwAAMwAAMwAAMwMDEwAsQjX5Id/t9unvIatu7dNjJeVPf7g9pt9ulw/2HlPS5gSXnsUs7/6xJI2peLqPlF96vee3vfpiCcbQiWuw8pPswf7FjPt4fch3kz/nhkXkdbes58314m/a7XSq+0+fnLIO8TucS3+E7GIABGIABGIABGIABGIABGLgpBhCNigDTBBR9rkHPAsX+bbo7NMFC35vOr1M0qoKRFpp+SHeHt+lhsn8Wm44WiE4Us47OvwlFReDT5+esA3ndVAd3NFvEnbjDAAzAAAzAAAzAAAzAAAzAwMTACxCN1OqiIjRo4eRDSuVaE430uYLl4W5fV7dkUWS/JbRcoWi0JIapOp5lcn1p0aisFJNVXFt+/gjx69x+Ib+p4zkLb/gVv8IADMAADMAADMAADMAADMDARRm4adHIbseSbVnteHh3pGPrdrKxuiXY1lXEEpt/SS/wtlUxY2uYX7Ek299aHoEwNdfFiV9SVnAsz67VNxDLslDmBTJvQ99iF9Rf6mr84NMpm3Le+7u3ZWtf2QZ4X7ei7XbH1xMhAqEMBmAABmAABmAABmAABmAABmAABs7HwE2LRgWUIog04SGLFoEgswqUfj4F7yMqQogWktwKmCYYDfHE59EEIyegaDuLWKPtLmUeK6bM+U/1PUI0ikSkKZ81uyY/WbuqIJX92K4Xscj5MhDEJhtIc6QYer5OhBjgSxiAARiAARiAARiAARiAARi4TQZuXzTKYkUTXIrwocSZY6D2z3jxpK6Q0S+1tkKHfz554cmIUg0yI+Lk/LQoJS/s/gSikbfDCzQrolERhbzvVfpxv4pGdRVTPR+C2202wmM4JA2xhwEYgAEYgAEYgAEYgAEYgAEYeGoGblg0quKNbJOyRyfCePGjf9YCRoNTCR2TAFSes6LREEMEbpdnyc9ubau2NhuNgBTZIPkuH2cbXNqgDC+OZTDLtf7ra4FoZXyjy3B1Fv+qcoeNOm09RzTSvuT8qTtJyoM5GIABGIABGIABGIABGICBl8rADYtGFWq90icLE/09PCJcrB2LqBEJOvIyZi1wSCN6pGhUyggEGLFLCSsd0kVxRmywxyr2PK6MSDTq5acPqYg8estctnfFriEKKdtU+nFf+xTRSPucc8WOtA+ObEeEARiAARiAARiAARiAARiAgYsx8CJEIxGKHisaLQknQ+Boq2+6eDJWN/XVMUoYkZVJeSWR2NSv+a1bHXotoogwk4WsFRGoPyuT7GZXtzNf/yHdHeSX4KzQVcWfXd/WF4kVoW+ayNbrru0oftArvGqZ4ofhU11fRKPI91wTrjnCAgzAAAzAAAzAAAzAAAzAAAxckoGbF42GUPR4AWI86yBcEIKyGHS4n8spgkjb1pVFkjnf+ozZQqcFHrPi6ZDut1YnabGmn/sytIDjtp7lsnMdlQ26DtXOWLSqq5rG6iwtIPl7IhhlwEv+RTirdtZ7sy8v2RjI23He2eE6bMAADMAADMAADMAADMAADMDAS2Tg5kWjlxhU6kxnBgMwAAMwAAMwAAMwAAMwAAMwAAMw8LEMIBqxmuJiex8/Fk6ep4ODARiAARiAARiAARiAARiAARiAgU/HAKIRohGiEQzAAAzAAAzAAAzAAAzAAAzAAAzAAAxMDCAaAcUEBSrup1Nx8T2+hwEYgAEYgAEYgAEYgAEYgAEYuBYGEI0QjRCNYAAGYAAGYAAGYAAGYAAGYAAGYAAGYGBi4GKi0U8//c9U2LUoZdiBagsDMAADMAADMAADMAADMAADMAADMAAD6wxcTDTC8euOxz/4BwZgAAZgAAZgAAZgAAZgAAZgAAZg4JoZ+P+x7YVh/eJiOQAAAABJRU5ErkJggg==[/img]
НА МЯСО В ПРОФИЛЕ
 
 
 
#12
29.11.2020 18:27:41
Михаил, ;( я не поняла, где писать: в Расширенном редакторе или в Настраиваемом столбце?
 
 
 
#13
29.11.2020 18:34:17
Показать ПРИМЕР в теме - никак еще не поняли?! Как в картинке можно "пощупать" код?
 
 
 
#14
29.11.2020 18:36:12
Я уже не могу
Для начала так, а дальше смотреть какой лист или таблица надо.
Код
let
    Source = Folder.Files("C:\Users\Администратор\Downloads\Telegram Desktop"),
    #"Filtered Rows" = Table.SelectRows(Source, each ([Name] = "файл1.xlsx" or [Name] = "файл2.xlsx" or [Name] = "файл3.xlsx")),
    #"Changed Type" = Table.TransformColumns(#"Filtered Rows",{{"Content", Excel.Workbook}})[[Name],[Content]]
in
    #"Changed Type"
НА МЯСО В ПРОФИЛЕ
 
 
 
#15
29.11.2020 18:38:14
Цитата
Елена Боровская написал:
Я создала запрос-подключение к каждому из трех
Хотя бы их покажите.
Текстом)
НА МЯСО В ПРОФИЛЕ
 
 
 
#16
29.11.2020 19:00:38
Вот сам файл с запросами. СводныйTS объединяет:
Код
=Table.Combine({ОПСОиАРМ, ПрУ, СГЭ})

В СводныйTS необходимо добавить столбец с информацией об источнике данных.
 
 
 
#17
29.11.2020 19:37:16
Попробуйте у себя запустить
НА МЯСО В ПРОФИЛЕ
 
 
 
#18
29.11.2020 19:58:07
Михаил, вы волшебник! Спасибо вам огромное!!!!!!!!!!![QUOTE]Михаил Л написал:
Надо учить язык М...
 
 
 
#19
29.11.2020 20:18:33
Елена Боровская, По времени быстро работает?
Лучше прописать явно вместо a[Item] - "ОПСОиАРМ" или соответствующее название в двойных кавычках
Цитата
Елена Боровская написал: Надо учить язык М
Учу уже не первый год
НА МЯСО В ПРОФИЛЕ
 
 
 
#20
29.11.2020 20:33:57
Да, всё быстро, спасибо!!!
Теперь буду применять в других отчётах!
 
 
 
Страницы: 1
Наверх