From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: from mp10.migadu.com ([2001:41d0:8:6d80::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by ms5.migadu.com with LMTPS id 6MR9DC7R0mMzQQEAbAwnHQ (envelope-from ) for ; Thu, 26 Jan 2023 20:14:54 +0100 Received: from aspmx1.migadu.com ([2001:41d0:8:6d80::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by mp10.migadu.com with LMTPS id gBCWCy7R0mMqnAAAG6o9tA (envelope-from ) for ; Thu, 26 Jan 2023 20:14:54 +0100 Received: from lists.gnu.org (lists.gnu.org [209.51.188.17]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (No client certificate requested) by aspmx1.migadu.com (Postfix) with ESMTPS id DED2B3A886 for ; Thu, 26 Jan 2023 20:14:53 +0100 (CET) Received: from localhost ([::1] helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1pL7hB-0003c1-Dc; Thu, 26 Jan 2023 14:14:01 -0500 Received: from eggs.gnu.org ([2001:470:142:3::10]) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1pL7h9-0003bo-TI for emacs-orgmode@gnu.org; Thu, 26 Jan 2023 14:13:59 -0500 Received: from smtp5-g21.free.fr ([212.27.42.5]) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1pL7h7-0005H3-L9 for emacs-orgmode@gnu.org; Thu, 26 Jan 2023 14:13:59 -0500 Received: from [IPV6:2a01:e35:39f3:4610:45e4:b232:d0af:334b] (unknown [IPv6:2a01:e35:39f3:4610:45e4:b232:d0af:334b]) (Authenticated sender: tbanelwebmin@free.fr) by smtp5-g21.free.fr (Postfix) with ESMTPSA id E6FFD5FF88 for ; Thu, 26 Jan 2023 20:13:52 +0100 (CET) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=free.fr; s=smtp-20201208; t=1674760433; bh=6J0Q7JbnqseGZaS4l5R/+AA9tXK49rCiREipnWN2jgA=; h=Date:Subject:To:References:From:In-Reply-To:From; b=lxVSRA4O9+uxphBHRy5lW5Z/cqX0RBgy0xupGvAmnoLwjaqj3WF6y4mGEwD7lC+Bl DDM0765nRE23qItgT55Bnvtw9ojSgwPEoDYJB+7QW2xkYvaiw6DQl7z5qPbNZSQ/26 wNpYXithEdYyYe3oAPFGW1RcdqJwCUW6CkZe4F2GSpn+Qcl+Qyc4ES8R4oeWtZuhIk Vc84A57c1hgU3WDCs9kvw9TOYNrAil6++pyFqK3LlqAF/D9ckTUOXC5ingVi2aOkXE gszxdCEfI/nUUlMS+PMF7M7wu9yJxYfPjJM1SaIIRwpAIXunNxjdaRECGAOsmNHAcj 4sYO9yR15UFBg== Message-ID: <840f139e-d62f-a6ac-8691-b63afb4cd1d6@free.fr> Date: Thu, 26 Jan 2023 20:13:52 +0100 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101 Thunderbird/102.4.2 Subject: Re: [ANN] orgtbl-fit To: emacs-orgmode@gnu.org References: <116c3126-32cc-44d0-9e95-e802161e1e84@app.fastmail.com> <87zgb90win.fsf@localhost> <87tu0qdc4k.fsf@localhost> <304d062e-c760-53ad-e442-ca646f2c892d@free.fr> <87a627ogg3.fsf@localhost> <073b5e6e-8c81-66c6-6a5e-19c5e10f0176@free.fr> <871qnhwpld.fsf@localhost> Content-Language: fr, en-US From: tbanelwebmin In-Reply-To: <871qnhwpld.fsf@localhost> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit Received-SPF: pass client-ip=212.27.42.5; envelope-from=tbanelwebmin@free.fr; helo=smtp5-g21.free.fr X-Spam_score_int: -31 X-Spam_score: -3.2 X-Spam_bar: --- X-Spam_report: (-3.2 / 5.0 requ) BAYES_00=-1.9, DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, DKIM_VALID_EF=-0.1, FREEMAIL_FROM=0.001, NICE_REPLY_A=-1.15, RCVD_IN_DNSWL_NONE=-0.0001, RCVD_IN_MSPIKE_H2=-0.001, SPF_HELO_NONE=0.001, SPF_PASS=-0.001 autolearn=ham autolearn_force=no X-Spam_action: no action X-BeenThere: emacs-orgmode@gnu.org X-Mailman-Version: 2.1.29 Precedence: list List-Id: "General discussions about Org-mode." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: emacs-orgmode-bounces+larch=yhetil.org@gnu.org Sender: emacs-orgmode-bounces+larch=yhetil.org@gnu.org X-Migadu-Country: US X-Migadu-Flow: FLOW_IN ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=yhetil.org; s=key1; t=1674760493; h=from:from:sender:sender:reply-to:subject:subject:date:date: message-id:message-id:to:to:cc:mime-version:mime-version: content-type:content-type: content-transfer-encoding:content-transfer-encoding: in-reply-to:in-reply-to:references:references:list-id:list-help: list-unsubscribe:list-subscribe:list-post:dkim-signature; bh=izObEU7l8bOkyHzbB6STFP7+FYh5H4QFWbeB7sBMKUw=; b=YOHJtseAtKPrQKR9NQV4otqgijiuIcY38uaFdVpb/ioJhnogs0Z8CEIeH9O3ECc9WJHhm2 RviQgnngkbx4CKrpYLRrdYO1A/D9lwzZWr3cdR7vy+2+fl6/nxiKfCEnQrHFJQnL+e57sO +//Uw8181Z6zPimzYEgIrvAD2LlMPVB3SouQeathkl6+x2s0dft3fzMC7KE7C6WUuGIFLI akRF8JxDOMNW4cOZhWRIZmAPKqjcugP8ik1MlxoasI3atR1EDmIaVwv4yy2cASr3rY9gSp QuAjMMfEW7D/aafvdgHRXs/jl3DCoZOhPo9AGknlOvAaKSz/XXxSNu5fmnGclw== ARC-Authentication-Results: i=1; aspmx1.migadu.com; dkim=pass header.d=free.fr header.s=smtp-20201208 header.b=lxVSRA4O; dmarc=pass (policy=none) header.from=free.fr; spf=pass (aspmx1.migadu.com: domain of "emacs-orgmode-bounces+larch=yhetil.org@gnu.org" designates 209.51.188.17 as permitted sender) smtp.mailfrom="emacs-orgmode-bounces+larch=yhetil.org@gnu.org" ARC-Seal: i=1; s=key1; d=yhetil.org; t=1674760493; a=rsa-sha256; cv=none; b=NsYhYYFYu4bxBIp6act705HG4ELAAw4mJGDhbDUVJVXHfwA3e+zpMyTXGdyF+g11Zowtqj Po8I3ViTBib3BoiyT0VhMKjGd0N0+xV/+UkOHGegICRYzooV7AXmrRcQlLdX8aCmCKHqYs I3eT0/j5r/1SouZ970dtBueQ53sSWfAu32f/9P2Mb8/hK9YdQ31ZN9JvYlLryjCeBwPeDs bDZuhik5cE4M07GfMSLoP5Otq9Zxhhpxpw1Z/ZXY00xtz/fNyoU8RY3RtRTnRsmEeK8M63 JhXZZiZwLyQ+/Tg46YJtvNHp+ipiUnq1te+b1zF0HNfLQ2v2xnwK2vWPFRT8/Q== X-Spam-Score: -4.77 X-Migadu-Spam-Score: -4.77 Authentication-Results: aspmx1.migadu.com; dkim=pass header.d=free.fr header.s=smtp-20201208 header.b=lxVSRA4O; dmarc=pass (policy=none) header.from=free.fr; spf=pass (aspmx1.migadu.com: domain of "emacs-orgmode-bounces+larch=yhetil.org@gnu.org" designates 209.51.188.17 as permitted sender) smtp.mailfrom="emacs-orgmode-bounces+larch=yhetil.org@gnu.org" X-Migadu-Queue-Id: DED2B3A886 X-Migadu-Scanner: scn1.migadu.com X-TUID: MWEas9JBBqgY On 1/26/23 11:35, Ihor Radchenko wrote: > tbanelwebmin writes: > >> Actually, orgtbl-fit is a bridge between Org Mode tables and Calc. >> >> By the way, Org Mode table spreadsheet capabilities are also a bridge >> with Calc. >> >> Examples & documentation can be read here: >> https://github.com/tbanel/orgtblfit/blob/main/README.org > Interesting. > Could it be somehow integrated with TBLFM formulas? > I imagine something like > > ? +?*year +?*passengers +?*(year-2016)*passengers > > , when set as a column value in table formula, to be auto-updated with > actual coefficients upon re-calculating the table. > Hey! That's an awesome idea. Expanding on the idea --------------------- We need to specify the target column ("consumption" in this example). Therefore, the formula could be something like that: $4 = fit (consumption = ? +?*year +?*passengers +?*(year-2016)*passengers) It would benefit from other spreadsheet features, like constants and remote references. On the development side, the TBLFM handling is already quite a big chunk of code. We must take care that such an additional feature do not add complexity and maintenance burden. Orgtbl-fit as-is ---------------- It is also possible to include orgtbl-fit as-is into Org Mode core. It would sit side-by-side with the core without changing anything in its code and its unit-tests. Data-analysis toolkit --------------------- From a higher perspective, we could give a consistent data-analysis toolkit to Org Mode (and call it org-data-analysis.el). It would start with fitting, clustering & aggregation. Then, new algorithms would be added upon user requests. Of course, there should be an interest among Org Mode users for such a toolkit.