From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: from mp2 ([2001:41d0:2:bcc0::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by ms0.migadu.com with LMTPS id WEzXAbgT42CTjQAAgWs5BA (envelope-from ) for ; Mon, 05 Jul 2021 16:14:16 +0200 Received: from aspmx1.migadu.com ([2001:41d0:2:bcc0::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by mp2 with LMTPS id 0CowObcT42CuRgAAB5/wlQ (envelope-from ) for ; Mon, 05 Jul 2021 14:14:15 +0000 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 2FA6AFA80 for ; Mon, 5 Jul 2021 16:14:15 +0200 (CEST) Received: from localhost ([::1]:48178 helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1m0PMU-0003ar-5c for larch@yhetil.org; Mon, 05 Jul 2021 10:14:14 -0400 Received: from eggs.gnu.org ([2001:470:142:3::10]:38218) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1m0PM4-0003a1-R6 for emacs-orgmode@gnu.org; Mon, 05 Jul 2021 10:13:48 -0400 Received: from mail-vi1eur05on2097.outbound.protection.outlook.com ([40.107.21.97]:23073 helo=EUR05-VI1-obe.outbound.protection.outlook.com) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1m0PLz-0004M9-Jt for emacs-orgmode@gnu.org; Mon, 05 Jul 2021 10:13:47 -0400 ARC-Seal: i=1; a=rsa-sha256; s=arcselector9901; d=microsoft.com; cv=none; b=fdL3xsliUuanbBYnsWgeY3wkqBjuQCwsmSbGdMlXX8Yj7UpAKh9aww0Ag2ApJtOSCO0zj0tT2qMXhMlBGhd9YcHjwnTPzee7ifSt2jQjqgGoJItmjY3CMm2lfXryr2nW1SDnvdhQbrZjY5dwzpID8F1mbQWMjohNQIDHXHPcSQBJ3EjVRpeW5F02lWnI3rqlXauf2ZszqphBsKtyEsLv6KL1cw58AZ9vkNXADsxrmsxj54nuZbEwejrEIpFiuCayq/tEmQGFYJT6HJAVwI/YvRckCVZ4+A2sEz22bL+cxrtV/xYUeFSwORkKm2AcgBaWbuXTD79tDZrjN+3tBTzecQ== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=microsoft.com; s=arcselector9901; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck; bh=frIvUI/BUSW3ZVJjfo3b9pceCtRuANOFKtUyBZOfYMU=; b=INYWYd2eyhV8ZDXan2gWSP5m0v2G2h7D0kpcziguCf471yGPGmW9249eCHqIx4boy7elBfXg9nDKTrtt9j8l9yKwapubZMmlbobSX6jqYEIrPUuO4B+Xg/gs920ZY7/+yMB7AB3D0GKTeJtkq9G8qD6hfG7oxw7riN8HsJnDYYwI0FC2Jl9WkN2GTbKokphlSa6cROnXfUnM6aFU+hiVs/qciaVsSVBsRh+6Ay4zwYGs4LRvLQ5fH0fumBP9avMrliwG6r/J0PmZObO91Ijpha9kcDeNCPaygf8Av8wfEuYRW93BbLClSuAz98WZ67CxoODmWBXNMiRijVsldqaMTA== ARC-Authentication-Results: i=1; mx.microsoft.com 1; spf=pass smtp.mailfrom=ucl.ac.uk; dmarc=pass action=none header.from=ucl.ac.uk; dkim=pass header.d=ucl.ac.uk; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=ucl.ac.uk; s=selector1; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck; bh=frIvUI/BUSW3ZVJjfo3b9pceCtRuANOFKtUyBZOfYMU=; b=V7pnqBuEsDNWXDaVmCVx2M6mWvOZ/uXoO/mskCOoJ2tiJf95ur+sFws2glEddTUi46oRZ+yXo6rOob5VGh8AAqu2nqPfbCYXKUW84L577QRYwV5+xaxCbbBlpsj2HQ4gT+WlqwwIp9s0pOGLsHjA/Z5Jw/xOYktcWRrROds8S/M= Received: from PAXPR01MB8415.eurprd01.prod.exchangelabs.com (2603:10a6:102:21e::16) by PR3PR01MB7969.eurprd01.prod.exchangelabs.com (2603:10a6:102:170::6) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.4242.23; Mon, 5 Jul 2021 14:13:39 +0000 Received: from PAXPR01MB8415.eurprd01.prod.exchangelabs.com ([fe80::49c5:c7a4:70:85f]) by PAXPR01MB8415.eurprd01.prod.exchangelabs.com ([fe80::49c5:c7a4:70:85f%4]) with mapi id 15.20.4287.033; Mon, 5 Jul 2021 14:13:39 +0000 From: Eric S Fraga To: emacs-orgmode@gnu.org Subject: Re: how to document/comment a complex org table formula Organization: On the Interweb somewhere References: <87h7h9c2nw.fsf@mat.ucm.es> X-Url: http://www.ucl.ac.uk/~ucecesf/ Mail-Followup-To: Org Mode List Date: Mon, 05 Jul 2021 15:13:38 +0100 In-Reply-To: <87h7h9c2nw.fsf@mat.ucm.es> (Uwe Brauer's message of "Sun, 04 Jul 2021 21:14:11 +0200") Message-ID: <87zgv0alwt.fsf@ucl.ac.uk> User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/28.0.50 (gnu/linux) Content-Type: text/plain X-Originating-IP: [2.29.174.230] X-ClientProxiedBy: LO4P123CA0390.GBRP123.PROD.OUTLOOK.COM (2603:10a6:600:18f::17) To PAXPR01MB8415.eurprd01.prod.exchangelabs.com (2603:10a6:102:21e::16) MIME-Version: 1.0 X-MS-Exchange-MessageSentRepresentingType: 1 Received: from t3610 (2.29.174.230) by LO4P123CA0390.GBRP123.PROD.OUTLOOK.COM (2603:10a6:600:18f::17) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.4287.22 via Frontend Transport; Mon, 5 Jul 2021 14:13:39 +0000 X-MS-PublicTrafficType: Email X-MS-Office365-Filtering-Correlation-Id: fd29dfc5-68bd-463d-a235-08d93fbf1670 X-MS-TrafficTypeDiagnostic: PR3PR01MB7969: X-Microsoft-Antispam-PRVS: X-MS-Oob-TLC-OOBClassifiers: OLM:4502; X-MS-Exchange-SenderADCheck: 1 X-Microsoft-Antispam: BCL:0; X-Microsoft-Antispam-Message-Info: j0ZwqZyWoUC9+ALzx2SxUMNAcWK6a/MYnaiV+wMYS9+NPTdESra9KSxxxp/HkBIg8YuUX/ibqEv2IxSSyTQbU5oJiQ8RzQQEUTdrugKaSgDBJ3GGH1lIGgr/mLpe6JalfYnqbqC3Ar1x/WBAAHROlHp29Kir9ZA+q79+VKzE7ugquGx/ZZjTKmQNOJ6J0KiUKQeLIXo8Kpk8nRlFlTa12KdiBoXpH2xFd3XbXoS4xIlcs0DqfXF6GbkwpzoshaSAO9nOFB7cVAyrzwaAEHX3NbA36Mv5yji72cNcfWwyeQ/S+WLKhbKLlOVdmCAQZNyTKxm9IY6kAF6fTgOcK+Me75qhMMrV4EyxB6ZCpePpMLiAyGPv0VoLxEwO61BV05y4ecwQfPbefmxeO5Q3zhI608DEgsALICaZ98HLcFkwyujM246AaRyf4mLd7EEB+j2OpOr7fk6rgHOLTB757W1v8hGcWCMwLTOdEHL9Li7L7Yl+JhhF/pOW5N4Ucdz3MliUMCROUi2GXpvjQ8W5IZX/CvSHcObJXF9rJyzK2+0u9Eh1QCOvYecfGBLnOVvJ6izeuhfyD4t0+38dSzZ52i1+oAAfYK400Mm5GSn8OssfSH4WqqcuAC1zahqAvEeO9QRLea0MonNGbKn9vhbdI25f7g4uhd4EZzqVuGvasa7ssG4gEg56P/0JChkFv6SP06+51OvbYar5bbaqmLnIYmZwcBphtV6KbNx6kM7lNZNGkYPyn1irOvtedana6OTc86uxOlvJTqzevey59TjkcCiSpPfEuhGSiK0aweU30Hg1goY= X-Forefront-Antispam-Report: CIP:255.255.255.255; CTRY:; LANG:en; SCL:1; SRV:; IPV:NLI; SFV:NSPM; H:PAXPR01MB8415.eurprd01.prod.exchangelabs.com; PTR:; CAT:NONE; SFS:(4636009)(396003)(366004)(376002)(136003)(39860400002)(346002)(966005)(6916009)(66556008)(6486002)(66476007)(6496006)(38100700002)(36916002)(478600001)(786003)(956004)(16526019)(86362001)(186003)(2616005)(38350700002)(8936002)(316002)(36756003)(26005)(2906002)(8676002)(66946007)(5660300002)(4744005)(52116002)(83380400001); DIR:OUT; SFP:1102; X-MS-Exchange-AntiSpam-MessageData-ChunkCount: 1 X-MS-Exchange-AntiSpam-MessageData-0: =?us-ascii?Q?qLxiwnkUi2NcvKyldyrPcktQttKjXNVBbbu/0TL+KRcmnfLr65IhD7ln+RKJ?= =?us-ascii?Q?7m32ELbiAHrSkPolnGCCxdfOm/f6rG9VBNZscJF4Xw592rrP98V82glYz/dl?= =?us-ascii?Q?aSQClVYtTRMyhc87DtH5ByAJ4+N97vNZWyWxQGisFcOtbp8syow1r+5swhf6?= =?us-ascii?Q?gKjjpdgq3oZ0qCpZy/wGWV8m0l7VBdksgmg+nD5Q/iADc0Zw4cjayDIU5TNA?= =?us-ascii?Q?0k5Vt0nf8i3smiyEFq2j4+UIHzM0KwvqDMLq6n0gSUZh/2fXtgDtEC0RfmEr?= =?us-ascii?Q?BN974lEOqQx64FDwCmhA+KGezPd5LBhzV97ulJnnVvQN41F9m32Mu07riHPG?= =?us-ascii?Q?DYX93dDv/WAfqGlG45cpF5brymvsdYYhj27WtqSGvpeu0qtAYmTuqSWLAwkk?= =?us-ascii?Q?hqIHxhi6NkH30vpP0lBkRup8hOqYUnrxtD6nUjZVfukKypwkdjDZ5++FZWcF?= =?us-ascii?Q?utYzQpVJKqLQ7P4vnqO1p3ZqReNtyHZYCUxmj5eLJuWh3Udwfs5u+eL9BGvo?= =?us-ascii?Q?3a8z79Y6t6dybVigE8ICTaO/VQPx6KbP1tOgqpCIiqeC7ExvkZyO7b7WFkLR?= =?us-ascii?Q?0my9Ek6mQh8BnJ0MYyLDjNgdZjCAVEFvXeoURhg94Osy+VOhyvhh8ZB6Bf7E?= =?us-ascii?Q?fGmE8zP73NHQDvTmuL9mqB0mL46SIFNvYmcCTJk1daPucWfTrbXk6OZym3CS?= =?us-ascii?Q?RxM4+9CNXlUSkxFaXCPTbnHie8ZGiKerc6Il3cxrh9G2EqAFjT6H0GdoXNlU?= =?us-ascii?Q?rI8MJqFDRfrvLLPmtMsAI2eM2UNcfPc4ziNxZVVBtNd7MD5Tb2tIfngBAnED?= =?us-ascii?Q?JkZEsAZRy2jXJgDWly2yTlqHq7a7x7DeCk4I95ox55k7FlEcz2L6r5dy41o+?= =?us-ascii?Q?R87NtB9jlxIh6ndVhkuxcxpi+QQxmDSGjEBpmKDFRnCpQhq6cURa6/w3SpLt?= =?us-ascii?Q?YKVRnzI/LdsV5hBx99olZKpaxccWcMMLzGD+clv/sEWDNl0IrMH1w2VVdI3J?= =?us-ascii?Q?xXXjFXuc1mDA/Gy/fIWBwoA5/W1GNp+vh2kGfyZWvS9AEyaX6a49FoX6DEpu?= =?us-ascii?Q?nz79MxOHKlFYMZHFCEW6WG/h6qp8AV+EyJlP/s4wrh026uXF40zzHGWzSqGE?= =?us-ascii?Q?1MZjL/jZWDVwI0Yen7Xnvw3qsLL6m2SlNIgnctZhahuoE66nOrzuVATS2NIk?= =?us-ascii?Q?3UfYE5Lpg/PLH32+UWpgxdA4C7Lx10p3AL7z0kZB0J0Dvk0GeNXyUK778ezG?= =?us-ascii?Q?GbcF01tGoPruCzLnXzoTM6WOCIKQ8ci9hVmOCTRpQIvy00XJfOQHIOw4Kgqs?= =?us-ascii?Q?PHVGm9HrpvefPqPBrKNOk6Ai?= X-OriginatorOrg: ucl.ac.uk X-MS-Exchange-CrossTenant-Network-Message-Id: fd29dfc5-68bd-463d-a235-08d93fbf1670 X-MS-Exchange-CrossTenant-AuthSource: PAXPR01MB8415.eurprd01.prod.exchangelabs.com X-MS-Exchange-CrossTenant-AuthAs: Internal X-MS-Exchange-CrossTenant-OriginalArrivalTime: 05 Jul 2021 14:13:39.8654 (UTC) X-MS-Exchange-CrossTenant-FromEntityHeader: Hosted X-MS-Exchange-CrossTenant-Id: 1faf88fe-a998-4c5b-93c9-210a11d9a5c2 X-MS-Exchange-CrossTenant-MailboxType: HOSTED X-MS-Exchange-CrossTenant-UserPrincipalName: oRCGFks7oOIFp71n/vap6Cwey7FMY0bsoZUQLL2I9+xzbMGoUl50n8/JLssp5o02ZnBNw5WatlMoDcc+HYcKig== X-MS-Exchange-Transport-CrossTenantHeadersStamped: PR3PR01MB7969 Received-SPF: pass client-ip=40.107.21.97; envelope-from=e.fraga@ucl.ac.uk; helo=EUR05-VI1-obe.outbound.protection.outlook.com X-Spam_score_int: -27 X-Spam_score: -2.8 X-Spam_bar: -- X-Spam_report: (-2.8 / 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, MSGID_FROM_MTA_HEADER=0.001, RCVD_IN_DNSWL_LOW=-0.7, RCVD_IN_MSPIKE_H2=-0.001, SPF_HELO_PASS=-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.23 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" X-Migadu-Flow: FLOW_IN ARC-Message-Signature: i=2; a=rsa-sha256; c=relaxed/relaxed; d=yhetil.org; s=key1; t=1625494455; 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:in-reply-to:in-reply-to: references:references:list-id:list-help:list-unsubscribe: list-subscribe:list-post:dkim-signature; bh=frIvUI/BUSW3ZVJjfo3b9pceCtRuANOFKtUyBZOfYMU=; b=dDD8jqmgYHIZeW9vfZLMxwrgDwM4rdNz6Ay5qiVeIw8ubYx/qzxJ9Sn6+VbJARVH3P8bpz lLA3wPUepD6f8jehTuNg0r8PY3+SVt0EcbqlCewxaQw6vtsB86mEv+ba/vSazhexfueiR0 kVgcjQtjKXrw5SQEtA/CE/Ds6qq9TuNphxf6F8k97RU8AfNAE706G62cGQ5IpBmKHYqz8K Kapq6Gh90/stYu0Fddgslek8hbwkELu4l4zQSytQ4QC2c5wTcpZ/zHTnjiLElx0tAyK2hx OvKqMzBG58Fdt4Q+PbIPY0YmvSqJnNJMZFPWFdLvLiFaNHv+09WAzbOZ9c7HEQ== ARC-Seal: i=2; s=key1; d=yhetil.org; t=1625494455; a=rsa-sha256; cv=pass; b=ba1EEPV2o6z6BJ+tI3EzGkRTAZwB4WHHDYAgFfajU4kxHSR6gGO4gAWD7FGwp/Xsxo2lqX eld9/FT5kcUmLj3z+PhonAJKBc1kz+Ol03XtsNFwyScIXHQmtvbXaV84f9fjyCwy+Wb7bQ SkmgWqIJR7tM+kssU3MsGaujrbhbixOI8hUAhp0RzoG+ckkWwiw3LiDL/iCznorxtUY9T7 3NSNg3K55YAbcSK59YD+QDB6IvgN43YlIs2pBxE15fSw26LLDgRUsig3e3vLESdiLGg7Ck MytMKCoWRwUPOOUmv1J1UydqHBL9S3gxC08fE9hkDUiMBB+pGiFsH+KDZ478ZQ== ARC-Authentication-Results: i=2; aspmx1.migadu.com; dkim=pass header.d=ucl.ac.uk header.s=selector1 header.b=V7pnqBuE; arc=pass ("microsoft.com:s=arcselector9901:i=1"); spf=pass (aspmx1.migadu.com: domain of emacs-orgmode-bounces@gnu.org designates 209.51.188.17 as permitted sender) smtp.mailfrom=emacs-orgmode-bounces@gnu.org X-Migadu-Spam-Score: -4.11 Authentication-Results: aspmx1.migadu.com; dkim=pass header.d=ucl.ac.uk header.s=selector1 header.b=V7pnqBuE; arc=pass ("microsoft.com:s=arcselector9901:i=1"); dmarc=pass (policy=none) header.from=ucl.ac.uk; spf=pass (aspmx1.migadu.com: domain of emacs-orgmode-bounces@gnu.org designates 209.51.188.17 as permitted sender) smtp.mailfrom=emacs-orgmode-bounces@gnu.org X-Migadu-Queue-Id: 2FA6AFA80 X-Spam-Score: -4.11 X-Migadu-Scanner: scn0.migadu.com X-TUID: JVTcn7Dm5k6e Sorry; I cannot help you directly. My rule of thumb is that if formulas are getting too complex to understand/recall clearly, it's time to use a proper programming language instead. The nice thing about org is you can have tables as inputs to and outputs of src blocks... My papers often have awk source blocks that process tables to generate statistics for some (numerical) experiments. Spreadsheets, org tables being an example of such, are brilliant tools for simple calculations but are pretty much "write only programming languages". -- : Eric S Fraga via Emacs 28.0.50, Org release_9.4.6-577-gf76d4d : Latest paper written in org: https://arxiv.org/abs/2106.05096