01:16
_whitelogger has joined #libreoffice-ru
04:37
lo-ru-tg has quit [Remote host closed the connection]
04:38
lo-ru-tg has joined #libreoffice-ru
05:14
ivan_bond has joined #libreoffice-ru
05:17
ivan_bond has quit [Client Quit]
05:18
ivan_bond has joined #libreoffice-ru
05:18
ivan_bond has quit [Read error: Connection reset by peer]
05:19
ivan_bond has joined #libreoffice-ru
05:21
ivan_bond has quit [Client Quit]
05:21
ivan_bond has joined #libreoffice-ru
05:23
ivan_bond has quit [Client Quit]
05:23
ivan_bond has joined #libreoffice-ru
05:24
ivan_bond has quit [Read error: Connection reset by peer]
05:25
ivan_bond has joined #libreoffice-ru
05:27
ivan_bond has quit [Read error: Connection reset by peer]
05:27
ivan_bond has joined #libreoffice-ru
05:30
ivan_bond has quit [Client Quit]
05:30
ivan_bond has joined #libreoffice-ru
05:34
JohnDoe_71Rus has joined #libreoffice-ru
05:42
ivan_bond has quit [Read error: Connection reset by peer]
05:42
ivan_bond has joined #libreoffice-ru
05:44
ivan_bond has quit [Read error: Connection reset by peer]
05:44
ivan_bond has joined #libreoffice-ru
05:45
ivan_bond has quit [Read error: Connection reset by peer]
05:45
ivan_bond has joined #libreoffice-ru
05:47
ivan_bond has quit [Client Quit]
05:47
ivan_bond has joined #libreoffice-ru
05:49
ivan_bond has quit [Client Quit]
05:49
ivan_bond has joined #libreoffice-ru
05:50
ivan_bond has quit [Client Quit]
05:51
ivan_bond has joined #libreoffice-ru
05:53
ivan_bond has quit [Read error: Connection reset by peer]
05:53
ivan_bond has joined #libreoffice-ru
05:55
ivan_bond has quit [Read error: Connection reset by peer]
05:55
ivan-bond has joined #libreoffice-ru
05:56
ivan-bond has quit [Read error: Connection reset by peer]
05:57
ivan-bond has joined #libreoffice-ru
05:58
ivan-bond has quit [Read error: Connection reset by peer]
05:58
ivan-bond has joined #libreoffice-ru
06:00
ivan-bond has quit [Read error: Connection reset by peer]
06:00
ivan-bond has joined #libreoffice-ru
06:01
ivan-bond has quit [Read error: Connection reset by peer]
06:02
ivan-bond has joined #libreoffice-ru
06:03
ivan-bond has quit [Read error: Connection reset by peer]
06:03
ivan-bond has joined #libreoffice-ru
06:04
ivan-bond has quit [Client Quit]
06:04
ivan-bond has joined #libreoffice-ru
06:05
ivan-bond has quit [Read error: No route to host]
06:05
ivan-bond has joined #libreoffice-ru
06:06
ivan-bond has quit [Client Quit]
06:07
ivan-bond has joined #libreoffice-ru
06:08
ivan-bond has quit [Client Quit]
06:08
ivan-bond has joined #libreoffice-ru
06:10
ivan-bond has quit [Client Quit]
06:10
ivan-bond has joined #libreoffice-ru
06:11
ivan-bond has quit [Read error: Connection reset by peer]
06:11
ivan-bond has joined #libreoffice-ru
06:13
ivan-bond has quit [Read error: Connection reset by peer]
06:13
ivan-bond has joined #libreoffice-ru
06:15
ivan-bond has quit [Read error: Connection reset by peer]
06:15
ivan-bond has joined #libreoffice-ru
06:18
ivan-bond has quit [Read error: Connection reset by peer]
06:18
ivan-bond has joined #libreoffice-ru
06:19
ivan-bond has quit [Client Quit]
06:19
ivan-bond has joined #libreoffice-ru
06:27
ivan-bond has quit [Quit: Konversation terminated!]
06:27
ivan-bond has joined #libreoffice-ru
06:28
ivan-bond has quit [Client Quit]
06:28
ivan-bond has joined #libreoffice-ru
06:30
ivan-bond has quit [Read error: Connection reset by peer]
06:30
ivan-bond has joined #libreoffice-ru
06:34
ivan-bond has quit [Client Quit]
06:34
ivan-bond has joined #libreoffice-ru
06:36
ivan-bond has quit [Read error: Connection reset by peer]
06:36
ivan-bond has joined #libreoffice-ru
06:37
ivan-bond has quit [Read error: Connection reset by peer]
06:38
ivan-bond has joined #libreoffice-ru
06:42
ivan-bond has quit [Client Quit]
06:42
ivan-bond has joined #libreoffice-ru
06:45
ivan-bond has quit [Client Quit]
06:45
ivan-bond has joined #libreoffice-ru
06:48
ivan-bond has quit [Client Quit]
06:48
ivan-bond has joined #libreoffice-ru
06:50
ivan-bond has quit [Read error: Connection reset by peer]
06:50
ivan-bond has joined #libreoffice-ru
06:51
ivan-bond has quit [Client Quit]
06:51
ivan-bond has joined #libreoffice-ru
06:57
ivan-bond has quit [Read error: Connection reset by peer]
06:57
ivan-bond has joined #libreoffice-ru
07:00
ivan-bond has quit [Read error: Connection reset by peer]
07:00
ivan-bond has joined #libreoffice-ru
07:05
ivan-bond has quit [Client Quit]
07:05
ivan-bond has joined #libreoffice-ru
07:06
ivan-bond has quit [Read error: Connection reset by peer]
07:06
ivan-bond has joined #libreoffice-ru
07:08
ivan-bond has quit [Read error: Connection reset by peer]
07:08
ivan-bond has joined #libreoffice-ru
07:10
ivan-bond has quit [Client Quit]
07:10
ivan-bond has joined #libreoffice-ru
07:11
ivan-bond has quit [Read error: Connection reset by peer]
07:11
ivan-bond has joined #libreoffice-ru
07:13
ivan_bond has joined #libreoffice-ru
07:13
ivan-bond has quit [Read error: Connection reset by peer]
07:16
ivan_bond has quit [Client Quit]
07:16
ivan_bond has joined #libreoffice-ru
07:17
ivan_bond has quit [Read error: Connection reset by peer]
07:18
ivan-bond has joined #libreoffice-ru
07:19
ivan-bond has quit [Read error: Connection reset by peer]
07:19
ivan_bond has joined #libreoffice-ru
07:22
ivan_bond has quit [Client Quit]
07:22
ivan_bond has joined #libreoffice-ru
07:24
ivan_bond has quit [Read error: Connection reset by peer]
07:24
ivan_bond has joined #libreoffice-ru
07:28
ivan_bond has quit [Read error: Connection reset by peer]
07:28
ivan_bond has joined #libreoffice-ru
07:29
ivan_bond has quit [Read error: Connection reset by peer]
07:30
ivan_bond has joined #libreoffice-ru
07:31
ivan_bond has quit [Read error: Connection reset by peer]
07:31
ivan_bond has joined #libreoffice-ru
07:33
ivan_bond has quit [Client Quit]
07:33
ivan-bond has joined #libreoffice-ru
07:34
ivan-bond has quit [Client Quit]
07:35
ivan-bond has joined #libreoffice-ru
07:36
ivan-bond has quit [Read error: Connection reset by peer]
07:36
ivan-bond has joined #libreoffice-ru
07:38
ivan-bond has quit [Client Quit]
07:38
ivan-bond has joined #libreoffice-ru
07:39
ivan-bond has quit [Read error: Connection reset by peer]
07:39
ivan-bond has joined #libreoffice-ru
07:41
ivan-bond has quit [Read error: Connection reset by peer]
07:41
ivan-bond has joined #libreoffice-ru
07:47
ivan-bond has quit [Quit: Konversation terminated!]
07:47
ivan-bond has joined #libreoffice-ru
07:49
ivan-bond has quit [Read error: Connection reset by peer]
07:49
ivan-bond has joined #libreoffice-ru
07:50
ivan-bond has quit [Read error: Connection reset by peer]
07:50
ivan-bond has joined #libreoffice-ru
07:53
ivan-bond has quit [Client Quit]
07:53
ivan-bond has joined #libreoffice-ru
07:59
ivan-bond has quit [Quit: Konversation terminated!]
07:59
ivan-bond has joined #libreoffice-ru
08:00
ivan-bond has quit [Read error: Connection reset by peer]
08:01
ivan-bond has joined #libreoffice-ru
08:04
ivan-bond has quit [Read error: Connection reset by peer]
08:04
ivan-bond has joined #libreoffice-ru
08:05
ivan-bond has quit [Read error: Connection reset by peer]
08:05
ivan-bond has joined #libreoffice-ru
08:09
ivan-bond has quit [Client Quit]
08:10
ivan-bond has joined #libreoffice-ru
08:11
ivan-bond has quit [Read error: Connection reset by peer]
08:11
ivan-bond has joined #libreoffice-ru
08:14
ivan-bond has quit [Read error: Connection reset by peer]
08:14
ivan-bond has joined #libreoffice-ru
08:20
ivan-bond has quit [Read error: Connection reset by peer]
08:20
ivan-bond has joined #libreoffice-ru
08:21
ivan-bond has quit [Read error: Connection reset by peer]
08:22
ivan-bond has joined #libreoffice-ru
08:23
ivan-bond has quit [Read error: Connection reset by peer]
08:23
ivan-bond has joined #libreoffice-ru
08:25
ivan-bond has quit [Read error: Connection reset by peer]
08:25
ivan-bond has joined #libreoffice-ru
08:29
ivan-bond has quit [Client Quit]
08:29
ivan-bond has joined #libreoffice-ru
08:33
ivan-bond has quit [Client Quit]
08:33
ivan-bond has joined #libreoffice-ru
08:35
ivan-bond has quit [Client Quit]
08:35
ivan-bond has joined #libreoffice-ru
08:37
ivan-bond has quit [Read error: Connection reset by peer]
08:37
ivan-bond has joined #libreoffice-ru
08:41
ivan-bond has quit [Client Quit]
08:41
ivan-bond has joined #libreoffice-ru
08:43
ivan-bond has quit [Read error: Connection reset by peer]
08:43
ivan-bond has joined #libreoffice-ru
08:46
ivan-bond has quit [Client Quit]
08:46
ivan-bond has joined #libreoffice-ru
08:49
ivan-bond has quit [Client Quit]
08:49
ivan-bond has joined #libreoffice-ru
08:51
ivan-bond has quit [Client Quit]
10:24
ivan_bond has joined #libreoffice-ru
10:25
ivan_bond has quit [Read error: Connection reset by peer]
10:25
ivan_bond has joined #libreoffice-ru
10:27
ivan_bond has quit [Client Quit]
10:27
ivan_bond has joined #libreoffice-ru
10:28
ivan_bond has quit [Read error: Connection reset by peer]
10:29
ivan_bond has joined #libreoffice-ru
10:30
ivan_bond has quit [Client Quit]
10:30
ivan_bond has joined #libreoffice-ru
10:32
ivan_bond has quit [Client Quit]
10:32
ivan_bond has joined #libreoffice-ru
10:35
ivan_bond has quit [Client Quit]
12:32
lo-ru-tg1 has joined #libreoffice-ru
12:32
lo-ru-tg has quit [Remote host closed the connection]
15:37
JohnDoe_71Rus has joined #libreoffice-ru
16:33
<
lo-ru-tg1 >
<Ievgeny_Fomin> Уважаемые форумчане есть ли альтернатива в libreoffice надстройки как excel Power query.?
16:34
<
lo-ru-tg1 >
<Kompilainenn> Нет
16:35
<
lo-ru-tg1 >
<Ievgeny_Fomin> Ясно, спасибо.
16:35
<
lo-ru-tg1 >
<Ievgeny_Fomin> Ясно, спасибо.
16:35
<
lo-ru-tg1 >
<Ievgeny_Fomin> Ясно, спасибо.
16:56
ivan_bond has joined #libreoffice-ru
16:57
ivan-bond has joined #libreoffice-ru
17:01
ivan_bond has quit [Ping timeout: 258 seconds]
18:28
ivan_bond has joined #libreoffice-ru
18:29
ivan-bond has quit [Ping timeout: 258 seconds]
18:34
ivan_bond has quit [Ping timeout: 264 seconds]
18:43
<
lo-ru-tg1 >
<economist> Есть: Ctrl+Shift+F4
18:44
<
lo-ru-tg1 >
<Kompilainenn> И что будет?
18:45
ivan_bond has joined #libreoffice-ru
18:51
<
lo-ru-tg1 >
<economist> Будет SQL, который не делает ничего, чего не умеет PowerQuery. Ð� вÑ�е оÑ�тальное - делает. Готов ответить предметно, но лишь тем, кто готов Ñ�кÑ�периментировать. ОÑ�тальным - бегом брать MSO 365 за 24 Ñ‚Ñ‹Ñ� руб в год. Ðто хорошаÑ� цена длÑ� офиÑ�а, безоткатнÐ
18:54
<
lo-ru-tg1 >
<Ievgeny_Fomin> SQL, это язык программирования, я правильно понимаю?
19:04
<
lo-ru-tg1 >
<economist> Это язык запросов к данным, с почти 50 летней историей. В PQ - почему то решили сделать свои языки - M и ещё что-то.
19:11
<
lo-ru-tg1 >
<Kompilainenn> PQ позволяет делать очень нужные вещи без знания скл или М
19:11
<
lo-ru-tg1 >
<Ievgeny_Fomin> PQ - очень удобный интерфейс для быстрой обработки данных, не нужно знать ни каких языков, интерфейс аналогичен excel. Нажал несколько пиктограм и получил результат.... Вот первые преимущества. Продолжать можно долго, но интуитивно п
19:12
<
lo-ru-tg1 >
<economist> В 70-е считалось что SQL станет языком экономистов. Не совсем вышло - злые одмины не дали себя потеснить.
19:13
<
lo-ru-tg1 >
<economist> Если вы в здравом уме не хотите знать SQL - то пробуйте аналоги PQ, например Orange
19:14
<
lo-ru-tg1 >
<Ievgeny_Fomin> SQL, язык со средой разработки, PQ - готовый продукт для широкого круга пользователей.
19:17
<
lo-ru-tg1 >
<Ievgeny_Fomin> Orange - ? Можно подробнейб
19:17
<
lo-ru-tg1 >
<Ievgeny_Fomin> ?
19:20
<
lo-ru-tg1 >
<economist> Давайте поспорим что нет - ни то (SQL), ни другое (PQ) - не является ничем готовым ни для кого и ни для чего. Везде нужны знания и лучше всего идти путём, который можно хотя бы проверить на живых людях и предприятиях.
19:23
<
lo-ru-tg1 >
<Ievgeny_Fomin> Спасибо, нет, спор тут не уместен.
19:24
<
lo-ru-tg1 >
<economist> А Orange - ну почти PQ.
19:27
<
lo-ru-tg1 >
<Ievgeny_Fomin> Спасибо, исчерпывающие.
19:30
<
lo-ru-tg1 >
<Ievgeny_Fomin> Лучшая и отличительная черта Orange — это замечательные визуальные эффекты.
19:30
<
lo-ru-tg1 >
<Ievgeny_Fomin> Это совсем не PQ.!
19:31
<
lo-ru-tg1 >
<Ievgeny_Fomin> PQ это обработка данных.
19:33
ivan_bond has quit [Ping timeout: 256 seconds]
19:34
<
lo-ru-tg1 >
<economist> Ну ладно, хайпану вчерне: Orange - надстройка над... Короче это ещё и Anaconda+Python+Pandas... То есть это самый популярный и самый быстрый стэк для анализа данных в мире. Его стоит знать для того чтобы быть на плаву
19:41
<
lo-ru-tg1 >
<Ievgeny_Fomin> Для анализа мне не надо. Мне нужно для обработки. Анализ я сам напишу или проанализирую в куче других доступных дата студий. Нужна только обработка не структурированных данных.
19:41
<
lo-ru-tg1 >
<Ievgeny_Fomin> Как я понимаю нет альтернативы PQ....
19:44
<
lo-ru-tg1 >
<Ievgeny_Fomin> Все анаконды и пандасы и т.д. я смотрел, пробовал это не то..., поиском я умею пользоваться ...
19:45
<
lo-ru-tg1 >
<economist> Обработкой, которую называют tiding data (чистка, конвертация, категоризация, итд) - делать нужно быстро, и часто лучший выбор - это библиотеки на языке С. Это пандас в том числе.
19:45
ivan_bond has joined #libreoffice-ru
19:49
<
lo-ru-tg1 >
<Ievgeny_Fomin> Правильно, я об этом и говорю, чтобы ни каких библиотек, языков... Нажал пиктограмму, одну вторую, выгрузил в электронную таблицу и работай.
19:52
<
lo-ru-tg1 >
<Ievgeny_Fomin> Так как, библиотеки, языки, это хорошо, а готовый продукт лучше.
19:54
<
lo-ru-tg1 >
<economist> Все таки готовый продукт или средство для анализа? 90% времени - это чистка.
19:54
<
lo-ru-tg1 >
<economist> Давайте конкретный пример обработки. Вот в 1С был план счетов со счетом 10.1 - а стал 10.01.1
19:54
<
lo-ru-tg1 >
<economist> Как быстрее всего привести к одному виду миллионы строк? PQ делает это 1 минуту, Pandas делает это 10 секунд. Если это ларёк, наносекунды не нуны. Если холдинг - нужны. Сделав это 500 раз - люли уходят с PowerQuery, просто потому что им надоело ждать
19:57
<
lo-ru-tg1 >
<Ievgeny_Fomin> Я с тобой согласен, но у нас разные задачи.
20:00
<
lo-ru-tg1 >
<Ievgeny_Fomin> Есть файлы каждый раз разные причём кардинально разные по всем параметрам, и ты не знаешь что внутри, как они структурированны.
20:03
ivan_bond has quit [Read error: Connection reset by peer]
20:04
ivan_bond has joined #libreoffice-ru
20:04
<
lo-ru-tg1 >
<Ievgeny_Fomin> В PQ есть на эти случаи уже готовые алгоритмы
20:05
<
lo-ru-tg1 >
<Ievgeny_Fomin> Действий
20:23
ivan_bond has quit [Quit: Konversation terminated!]
20:24
ivan_bond has joined #libreoffice-ru
20:32
<
lo-ru-tg1 >
<Kompilainenn> Я тебе сразу сказал
20:33
<
lo-ru-tg1 >
<Kompilainenn> У экономиста свой богатый внутренний мир
20:33
<
lo-ru-tg1 >
<Ievgeny_Fomin> 😂
20:36
<
lo-ru-tg1 >
<PS> Я Ñ� недовериÑ�м отношуÑ�ÑŒ к кнопкам - кто Ñ�кажет, что кнопка делает? Ð� правильно ли она делает? Ð� правильно ли она будет Ñ�то делать поÑ�ле очередного обновлениÑ�? (Ñ�кÑ�ели разные ловил на коÑ�Ñ�ках не однократно). Самый надежный Ñ�поÑ�об каждый раÐ
20:48
<
lo-ru-tg1 >
<I​evgeny_Fomin> Я так и поÑ�тупаю вÑ�егда, но речь едет макÑ�имально быÑ�тром Ñ�поÑ�обе обработки например Ñ�парÑ�еных данных, корÑ�вый парÑ�ером или набранных таблиц вручную, или ещё каких-нибудь кучи квитанций или выгрузки баз нужно получить более Ð
20:50
<
lo-ru-tg1 >
<Ievgeny_Fomin> И писать обработку отдельно на каждый файл это не рационально 3 часа пишешь 10 сек обрабатывает.
20:51
<
lo-ru-tg1 >
<Ievgeny_Fomin> Просто разные задачи.. стоят перед нами.
20:53
<
lo-ru-tg1 >
<Ievgeny_Fomin> Всем спасибо за дискуссию, было очень интересно и познавательно. Отдельное спасибо Economist - было приятно общаться.
21:06
<
lo-ru-tg1 >
Cody has joined the Telegram Group!
22:35
lo-ru-tg has joined #libreoffice-ru
22:38
lo-ru-tg1 has quit [Ping timeout: 258 seconds]
23:00
ivan_bond has quit [Ping timeout: 260 seconds]