ChanServ changed the topic of #libreoffice-ru to: Канал поддержки русскоязычных пользователей LibreOffice | Wiki TDF http://tdf.io/wikiru | On-line документация http://tdf.io/helpru | Логи канала: http://goo.gl/gzwdwU
_whitelogger has joined #libreoffice-ru
lo-ru-tg has quit [Remote host closed the connection]
lo-ru-tg has joined #libreoffice-ru
ivan_bond has joined #libreoffice-ru
ivan_bond has quit [Client Quit]
ivan_bond has joined #libreoffice-ru
ivan_bond has quit [Read error: Connection reset by peer]
ivan_bond has joined #libreoffice-ru
ivan_bond has quit [Client Quit]
ivan_bond has joined #libreoffice-ru
ivan_bond has quit [Client Quit]
ivan_bond has joined #libreoffice-ru
ivan_bond has quit [Read error: Connection reset by peer]
ivan_bond has joined #libreoffice-ru
ivan_bond has quit [Read error: Connection reset by peer]
ivan_bond has joined #libreoffice-ru
ivan_bond has quit [Client Quit]
ivan_bond has joined #libreoffice-ru
JohnDoe_71Rus has joined #libreoffice-ru
ivan_bond has quit [Read error: Connection reset by peer]
ivan_bond has joined #libreoffice-ru
ivan_bond has quit [Read error: Connection reset by peer]
ivan_bond has joined #libreoffice-ru
ivan_bond has quit [Read error: Connection reset by peer]
ivan_bond has joined #libreoffice-ru
ivan_bond has quit [Client Quit]
ivan_bond has joined #libreoffice-ru
ivan_bond has quit [Client Quit]
ivan_bond has joined #libreoffice-ru
ivan_bond has quit [Client Quit]
ivan_bond has joined #libreoffice-ru
ivan_bond has quit [Read error: Connection reset by peer]
ivan_bond has joined #libreoffice-ru
ivan_bond has quit [Read error: Connection reset by peer]
ivan-bond has joined #libreoffice-ru
ivan-bond has quit [Read error: Connection reset by peer]
ivan-bond has joined #libreoffice-ru
ivan-bond has quit [Read error: Connection reset by peer]
ivan-bond has joined #libreoffice-ru
ivan-bond has quit [Read error: Connection reset by peer]
ivan-bond has joined #libreoffice-ru
ivan-bond has quit [Read error: Connection reset by peer]
ivan-bond has joined #libreoffice-ru
ivan-bond has quit [Read error: Connection reset by peer]
ivan-bond has joined #libreoffice-ru
ivan-bond has quit [Client Quit]
ivan-bond has joined #libreoffice-ru
ivan-bond has quit [Read error: No route to host]
ivan-bond has joined #libreoffice-ru
ivan-bond has quit [Client Quit]
ivan-bond has joined #libreoffice-ru
ivan-bond has quit [Client Quit]
ivan-bond has joined #libreoffice-ru
ivan-bond has quit [Client Quit]
ivan-bond has joined #libreoffice-ru
ivan-bond has quit [Read error: Connection reset by peer]
ivan-bond has joined #libreoffice-ru
ivan-bond has quit [Read error: Connection reset by peer]
ivan-bond has joined #libreoffice-ru
ivan-bond has quit [Read error: Connection reset by peer]
ivan-bond has joined #libreoffice-ru
ivan-bond has quit [Read error: Connection reset by peer]
ivan-bond has joined #libreoffice-ru
ivan-bond has quit [Client Quit]
ivan-bond has joined #libreoffice-ru
ivan-bond has quit [Quit: Konversation terminated!]
ivan-bond has joined #libreoffice-ru
ivan-bond has quit [Client Quit]
ivan-bond has joined #libreoffice-ru
ivan-bond has quit [Read error: Connection reset by peer]
ivan-bond has joined #libreoffice-ru
ivan-bond has quit [Client Quit]
ivan-bond has joined #libreoffice-ru
ivan-bond has quit [Read error: Connection reset by peer]
ivan-bond has joined #libreoffice-ru
ivan-bond has quit [Read error: Connection reset by peer]
ivan-bond has joined #libreoffice-ru
ivan-bond has quit [Client Quit]
ivan-bond has joined #libreoffice-ru
ivan-bond has quit [Client Quit]
ivan-bond has joined #libreoffice-ru
ivan-bond has quit [Client Quit]
ivan-bond has joined #libreoffice-ru
ivan-bond has quit [Read error: Connection reset by peer]
ivan-bond has joined #libreoffice-ru
ivan-bond has quit [Client Quit]
ivan-bond has joined #libreoffice-ru
ivan-bond has quit [Read error: Connection reset by peer]
ivan-bond has joined #libreoffice-ru
ivan-bond has quit [Read error: Connection reset by peer]
ivan-bond has joined #libreoffice-ru
ivan-bond has quit [Client Quit]
ivan-bond has joined #libreoffice-ru
ivan-bond has quit [Read error: Connection reset by peer]
ivan-bond has joined #libreoffice-ru
ivan-bond has quit [Read error: Connection reset by peer]
ivan-bond has joined #libreoffice-ru
ivan-bond has quit [Client Quit]
ivan-bond has joined #libreoffice-ru
ivan-bond has quit [Read error: Connection reset by peer]
ivan-bond has joined #libreoffice-ru
ivan_bond has joined #libreoffice-ru
ivan-bond has quit [Read error: Connection reset by peer]
ivan_bond has quit [Client Quit]
ivan_bond has joined #libreoffice-ru
ivan_bond has quit [Read error: Connection reset by peer]
ivan-bond has joined #libreoffice-ru
ivan-bond has quit [Read error: Connection reset by peer]
ivan_bond has joined #libreoffice-ru
ivan_bond has quit [Client Quit]
ivan_bond has joined #libreoffice-ru
ivan_bond has quit [Read error: Connection reset by peer]
ivan_bond has joined #libreoffice-ru
ivan_bond has quit [Read error: Connection reset by peer]
ivan_bond has joined #libreoffice-ru
ivan_bond has quit [Read error: Connection reset by peer]
ivan_bond has joined #libreoffice-ru
ivan_bond has quit [Read error: Connection reset by peer]
ivan_bond has joined #libreoffice-ru
ivan_bond has quit [Client Quit]
ivan-bond has joined #libreoffice-ru
ivan-bond has quit [Client Quit]
ivan-bond has joined #libreoffice-ru
ivan-bond has quit [Read error: Connection reset by peer]
ivan-bond has joined #libreoffice-ru
ivan-bond has quit [Client Quit]
ivan-bond has joined #libreoffice-ru
ivan-bond has quit [Read error: Connection reset by peer]
ivan-bond has joined #libreoffice-ru
ivan-bond has quit [Read error: Connection reset by peer]
ivan-bond has joined #libreoffice-ru
ivan-bond has quit [Quit: Konversation terminated!]
ivan-bond has joined #libreoffice-ru
ivan-bond has quit [Read error: Connection reset by peer]
ivan-bond has joined #libreoffice-ru
ivan-bond has quit [Read error: Connection reset by peer]
ivan-bond has joined #libreoffice-ru
ivan-bond has quit [Client Quit]
ivan-bond has joined #libreoffice-ru
ivan-bond has quit [Quit: Konversation terminated!]
ivan-bond has joined #libreoffice-ru
ivan-bond has quit [Read error: Connection reset by peer]
ivan-bond has joined #libreoffice-ru
ivan-bond has quit [Read error: Connection reset by peer]
ivan-bond has joined #libreoffice-ru
ivan-bond has quit [Read error: Connection reset by peer]
ivan-bond has joined #libreoffice-ru
ivan-bond has quit [Client Quit]
ivan-bond has joined #libreoffice-ru
ivan-bond has quit [Read error: Connection reset by peer]
ivan-bond has joined #libreoffice-ru
ivan-bond has quit [Read error: Connection reset by peer]
ivan-bond has joined #libreoffice-ru
ivan-bond has quit [Read error: Connection reset by peer]
ivan-bond has joined #libreoffice-ru
ivan-bond has quit [Read error: Connection reset by peer]
ivan-bond has joined #libreoffice-ru
ivan-bond has quit [Read error: Connection reset by peer]
ivan-bond has joined #libreoffice-ru
ivan-bond has quit [Read error: Connection reset by peer]
ivan-bond has joined #libreoffice-ru
ivan-bond has quit [Client Quit]
ivan-bond has joined #libreoffice-ru
ivan-bond has quit [Client Quit]
ivan-bond has joined #libreoffice-ru
ivan-bond has quit [Client Quit]
ivan-bond has joined #libreoffice-ru
ivan-bond has quit [Read error: Connection reset by peer]
ivan-bond has joined #libreoffice-ru
ivan-bond has quit [Client Quit]
ivan-bond has joined #libreoffice-ru
ivan-bond has quit [Read error: Connection reset by peer]
ivan-bond has joined #libreoffice-ru
ivan-bond has quit [Client Quit]
ivan-bond has joined #libreoffice-ru
ivan-bond has quit [Client Quit]
ivan-bond has joined #libreoffice-ru
ivan-bond has quit [Client Quit]
ivan_bond has joined #libreoffice-ru
ivan_bond has quit [Read error: Connection reset by peer]
ivan_bond has joined #libreoffice-ru
ivan_bond has quit [Client Quit]
ivan_bond has joined #libreoffice-ru
ivan_bond has quit [Read error: Connection reset by peer]
ivan_bond has joined #libreoffice-ru
ivan_bond has quit [Client Quit]
ivan_bond has joined #libreoffice-ru
ivan_bond has quit [Client Quit]
ivan_bond has joined #libreoffice-ru
ivan_bond has quit [Client Quit]
lo-ru-tg1 has joined #libreoffice-ru
lo-ru-tg has quit [Remote host closed the connection]
JohnDoe_71Rus has quit [Quit: KVIrc 5.0.1 Aria http://www.kvirc.net/]
JohnDoe_71Rus has joined #libreoffice-ru
<lo-ru-tg1> <I​evgeny_Fomin> Уважаемые форумчане есть ли альтернатива в libreoffice надстройки как excel Power query.?
<lo-ru-tg1> <K​ompilainenn> Нет
<lo-ru-tg1> <I​evgeny_Fomin> Ясно, спасибо.
<lo-ru-tg1> <I​evgeny_Fomin> Ясно, спасибо.
<lo-ru-tg1> <I​evgeny_Fomin> Ясно, спасибо.
ivan_bond has joined #libreoffice-ru
ivan-bond has joined #libreoffice-ru
ivan_bond has quit [Ping timeout: 258 seconds]
ivan_bond has joined #libreoffice-ru
ivan-bond has quit [Ping timeout: 258 seconds]
ivan_bond has quit [Ping timeout: 264 seconds]
<lo-ru-tg1> <economist> Есть: Ctrl+Shift+F4
<lo-ru-tg1> <K​ompilainenn> И что будет?
ivan_bond has joined #libreoffice-ru
<lo-ru-tg1> <economist> Будет SQL, который не делает ничего, чего не умеет PowerQuery. Ð� вÑ�е оÑ�тальное - делает. Готов ответить предметно, но лишь тем, кто готов Ñ�кÑ�периментировать. ОÑ�тальным - бегом брать MSO 365 за 24 Ñ‚Ñ‹Ñ� руб в год. Это хорошаÑ� цена длÑ� офиÑ�а, безоткатнÐ
<lo-ru-tg1> <I​evgeny_Fomin> SQL, это язык программирования, я правильно понимаю?
<lo-ru-tg1> <economist> Это язык запросов к данным, с почти 50 летней историей. В PQ - почему то решили сделать свои языки - M и ещё что-то.
<lo-ru-tg1> <K​ompilainenn> PQ позволяет делать очень нужные вещи без знания скл или М
<lo-ru-tg1> <I​evgeny_Fomin> PQ - очень удобный интерфейс для быстрой обработки данных, не нужно знать ни каких языков, интерфейс аналогичен excel. Нажал несколько пиктограм и получил результат.... Вот первые преимущества. Продолжать можно долго, но интуитивно п
<lo-ru-tg1> <economist> В 70-е считалось что SQL станет языком экономистов. Не совсем вышло - злые одмины не дали себя потеснить.
<lo-ru-tg1> <economist> Если вы в здравом уме не хотите знать SQL - то пробуйте аналоги PQ, например Orange
<lo-ru-tg1> <I​evgeny_Fomin> SQL, язык со средой разработки, PQ - готовый продукт для широкого круга пользователей.
<lo-ru-tg1> <I​evgeny_Fomin> Orange - ? Можно подробнейб
<lo-ru-tg1> <I​evgeny_Fomin> ?
<lo-ru-tg1> <economist> Давайте поспорим что нет - ни то (SQL), ни другое (PQ) - не является ничем готовым ни для кого и ни для чего. Везде нужны знания и лучше всего идти путём, который можно хотя бы проверить на живых людях и предприятиях.
JohnDoe_71Rus has quit [Quit: KVIrc 5.0.0 Aria http://www.kvirc.net/]
<lo-ru-tg1> <I​evgeny_Fomin> Спасибо, нет, спор тут не уместен.
<lo-ru-tg1> <economist> А Orange - ну почти PQ.
<lo-ru-tg1> <I​evgeny_Fomin> Спасибо, исчерпывающие.
<lo-ru-tg1> <I​evgeny_Fomin> Лучшая и отличительная черта Orange — это замечательные визуальные эффекты.
<lo-ru-tg1> <I​evgeny_Fomin> Это совсем не PQ.!
<lo-ru-tg1> <I​evgeny_Fomin> PQ это обработка данных.
ivan_bond has quit [Ping timeout: 256 seconds]
<lo-ru-tg1> <economist> Ну ладно, хайпану вчерне: Orange - надстройка над... Короче это ещё и Anaconda+Python+Pandas... То есть это самый популярный и самый быстрый стэк для анализа данных в мире. Его стоит знать для того чтобы быть на плаву
<lo-ru-tg1> <I​evgeny_Fomin> Для анализа мне не надо. Мне нужно для обработки. Анализ я сам напишу или проанализирую в куче других доступных дата студий. Нужна только обработка не структурированных данных.
<lo-ru-tg1> <I​evgeny_Fomin> Как я понимаю нет альтернативы PQ....
<lo-ru-tg1> <I​evgeny_Fomin> Все анаконды и пандасы и т.д. я смотрел, пробовал это не то..., поиском я умею пользоваться ...
<lo-ru-tg1> <economist> Обработкой, которую называют tiding data (чистка, конвертация, категоризация, итд) - делать нужно быстро, и часто лучший выбор - это библиотеки на языке С. Это пандас в том числе.
ivan_bond has joined #libreoffice-ru
<lo-ru-tg1> <I​evgeny_Fomin> Правильно, я об этом и говорю, чтобы ни каких библиотек, языков... Нажал пиктограмму, одну вторую, выгрузил в электронную таблицу и работай.
<lo-ru-tg1> <I​evgeny_Fomin> Так как, библиотеки, языки, это хорошо, а готовый продукт лучше.
<lo-ru-tg1> <economist> Все таки готовый продукт или средство для анализа? 90% времени - это чистка.
<lo-ru-tg1> <economist> Давайте конкретный пример обработки. Вот в 1С был план счетов со счетом 10.1 - а стал 10.01.1
<lo-ru-tg1> <economist> Как быстрее всего привести к одному виду миллионы строк? PQ делает это 1 минуту, Pandas делает это 10 секунд. Если это ларёк, наносекунды не нуны. Если холдинг - нужны. Сделав это 500 раз - люли уходят с PowerQuery, просто потому что им надоело ждать
<lo-ru-tg1> <I​evgeny_Fomin> Я с тобой согласен, но у нас разные задачи.
<lo-ru-tg1> <I​evgeny_Fomin> Есть файлы каждый раз разные причём кардинально разные по всем параметрам, и ты не знаешь что внутри, как они структурированны.
ivan_bond has quit [Read error: Connection reset by peer]
ivan_bond has joined #libreoffice-ru
<lo-ru-tg1> <I​evgeny_Fomin> В PQ есть на эти случаи уже готовые алгоритмы
<lo-ru-tg1> <I​evgeny_Fomin> Действий
ivan_bond has quit [Quit: Konversation terminated!]
ivan_bond has joined #libreoffice-ru
<lo-ru-tg1> <K​ompilainenn> Я тебе сразу сказал
<lo-ru-tg1> <K​ompilainenn> У экономиста свой богатый внутренний мир
<lo-ru-tg1> <I​evgeny_Fomin> 😂
<lo-ru-tg1> <PS> Я Ñ� недовериÑ�м отношуÑ�ÑŒ к кнопкам - кто Ñ�кажет, что кнопка делает? Ð� правильно ли она делает? Ð� правильно ли она будет Ñ�то делать поÑ�ле очередного обновлениÑ�? (Ñ�кÑ�ели разные ловил на коÑ�Ñ�ках не однократно). Самый надежный Ñ�поÑ�об каждый раÐ
<lo-ru-tg1> <I​evgeny_Fomin> Я так и поÑ�тупаю вÑ�егда, но речь едет макÑ�имально быÑ�тром Ñ�поÑ�обе обработки например Ñ�парÑ�еных данных, корÑ�вый парÑ�ером или набранных таблиц вручную, или ещё каких-нибудь кучи квитанций или выгрузки баз нужно получить более Ð
<lo-ru-tg1> <I​evgeny_Fomin> И писать обработку отдельно на каждый файл это не рационально 3 часа пишешь 10 сек обрабатывает.
<lo-ru-tg1> <I​evgeny_Fomin> Просто разные задачи.. стоят перед нами.
<lo-ru-tg1> <I​evgeny_Fomin> Всем спасибо за дискуссию, было очень интересно и познавательно. Отдельное спасибо Economist - было приятно общаться.
<lo-ru-tg1> Cody has joined the Telegram Group!
lo-ru-tg has joined #libreoffice-ru
lo-ru-tg1 has quit [Ping timeout: 258 seconds]
ivan_bond has quit [Ping timeout: 260 seconds]