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 ms0.migadu.com with LMTPS id KDlHOddg5GHTWAEAgWs5BA (envelope-from ) for ; Sun, 16 Jan 2022 19:15:51 +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 YBjxMddg5GGaAwEAG6o9tA (envelope-from ) for ; Sun, 16 Jan 2022 19:15:51 +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 418751D8AE for ; Sun, 16 Jan 2022 19:15:51 +0100 (CET) Received: from localhost ([::1]:41960 helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1n9A4E-0004nd-A1 for larch@yhetil.org; Sun, 16 Jan 2022 13:15:50 -0500 Received: from eggs.gnu.org ([209.51.188.92]:38886) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1n99zh-0002q3-Oa for emacs-orgmode@gnu.org; Sun, 16 Jan 2022 13:11:09 -0500 Received: from mail-eopbgr140092.outbound.protection.outlook.com ([40.107.14.92]:62210 helo=EUR01-VE1-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 1n99zc-0005io-Pe for emacs-orgmode@gnu.org; Sun, 16 Jan 2022 13:11:08 -0500 ARC-Seal: i=1; a=rsa-sha256; s=arcselector9901; d=microsoft.com; cv=none; b=frOmejIR62PJG0/Nh/VQLDmEszL3osCl6dhrzONqiO4ZCSSZxQNNfn3QbCIAbSr6CftfKTKk5QROUjN09UgLrFnitsiOsFE7nZpS7Mh+9Az3mMeZextXzEEGCf3i6WrwAPlZwGlGI3cPBXkGAldGSg572J60DLq6NZ+Q6kTG2uiPekBs0D0VTHhPgxIWJvTnm+zAkKQZTZhKdC3gia7Y13sGU1dgmyChUDfO37AiGYqTBaNYxwa2da4c9X/fYLS+bfLm19KbPrhWbG8O73NSYqYGa5U3eArG9kUteGR4pFMziIlYaemLbBuxJXhw0wwrqxudZ0LwOw1iBKr/EdngAw== 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-AntiSpam-MessageData-ChunkCount:X-MS-Exchange-AntiSpam-MessageData-0:X-MS-Exchange-AntiSpam-MessageData-1; bh=wIngclsK2dqVIcSfbUqjpNxulvdk7Hov2CT/COGMtWc=; b=Y8zuHfGe0sN/n8kNgA1bPo5oKzmffgxmZth1pXbFhTKfONHkAAc5iZH4QzcFN7MOqFJhnvYiX+9eft9Otuo4BFuBJDnk7iRJrdCJCw1OU1eBPy+Hw+fwCEd9Ajh6Me4s3lfH1KrCp/l1Sj9kuIt9H8rL0uztn2IYqsjTB5wTndbeihKcq+glpAbE8aTL68iiG7lUK5wjVVNax8DCw8613RVfX+ZG36i1Nz/qDBh4V4DcMdOx0Rn+QNrUARpOJX8vZTdgaLt3nip1kJcNl/09Ar540zrnUeTPmdDuZIYyF6ph7+dunoofXsZ70dJiKlxDK/Cvs+Z1HcQKPiW9ItVWDg== 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=wIngclsK2dqVIcSfbUqjpNxulvdk7Hov2CT/COGMtWc=; b=ONxkpL3aLW6qgnvbyM7bblieSL08iBriIx6R0GRbnTlaAf2UOBA3x4DnrXxbR3k3Q/wZJi8L8uwkRuYP7XCKh3yMGPt4xzjuLreSZuoOADxU7kvU2GVOin8kmI9GMbm9mL/v6TYnf3hUStO+t+q8Xu3jGFHkVa9CE2sn9CjefRU= Received: from GV1PR01MB8433.eurprd01.prod.exchangelabs.com (2603:10a6:150:1c::19) by VI1PR01MB5375.eurprd01.prod.exchangelabs.com (2603:10a6:803:d1::25) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.4888.11; Sun, 16 Jan 2022 18:11:01 +0000 Received: from GV1PR01MB8433.eurprd01.prod.exchangelabs.com ([fe80::9961:f84a:7d0:dcfa]) by GV1PR01MB8433.eurprd01.prod.exchangelabs.com ([fe80::9961:f84a:7d0:dcfa%6]) with mapi id 15.20.4888.013; Sun, 16 Jan 2022 18:11:00 +0000 From: Eric S Fraga To: "Samuel Banya" Subject: Re: Question Regarding Creating Workflow For Automatic Formulas For Finance Based Org Spreadsheet Organization: On the Interweb somewhere References: <137562d1-e6fe-4a68-b18b-abedef513fbd@www.fastmail.com> <5f6b2337d0d5ca303c054febba4ff8c3@riseup.net> <17ff6003-cbaf-409a-a625-10cbfcc75eab@www.fastmail.com> X-Url: http://www.ucl.ac.uk/~ucecesf/ Mail-Followup-To: Org Mode List Date: Sun, 16 Jan 2022 18:10:31 +0000 In-Reply-To: (Samuel Banya's message of "Sun, 16 Jan 2022 10:35:20 -0500") Message-ID: <87ilujblgo.fsf@ucl.ac.uk> User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/29.0.50 (gnu/linux) Content-Type: text/plain X-ClientProxiedBy: LO4P123CA0200.GBRP123.PROD.OUTLOOK.COM (2603:10a6:600:1a5::7) To GV1PR01MB8433.eurprd01.prod.exchangelabs.com (2603:10a6:150:1c::19) MIME-Version: 1.0 X-MS-PublicTrafficType: Email X-MS-Office365-Filtering-Correlation-Id: b89ce584-6cd1-4000-d993-08d9d91b8d3a X-MS-TrafficTypeDiagnostic: VI1PR01MB5375:EE_ X-Microsoft-Antispam-PRVS: X-MS-Oob-TLC-OOBClassifiers: OLM:9508; X-MS-Exchange-SenderADCheck: 1 X-MS-Exchange-AntiSpam-Relay: 0 X-Microsoft-Antispam: BCL:0; X-Microsoft-Antispam-Message-Info: zXyESrkCTYsTiVVhfYJywMuwHUI5LuUyF5+2EapFZ8b+1217DCLTo1UWg8gYD67rcnL9g9kQvlnWBC0E6OhIyOxrpay4pgzApvakp9/fu03LH1YecgI7rh9ZGNIETjDj32zOx1LxqZ3vVdAvkPbSWSY5lL8tg/Umu6ZG+8H6fAkUhvvFq+5vOTPG0g902SL3z51lIDbWE5kNEUkxpJoOg2HbGIfGe0aPuN+RQJTWMYFkhU0uknES9TFuJQ4Phsh8yVDAWbubW2f1WrzRn6dEHf1JdbXTvGnY0sq9ABXn0mRWm7gq84L+STUlYMkBbBrafqdXRe9mJ6Qg9iNQMprdVG0OF+ZJfpXqNBOJMo8r1yPJvO5lsp4fMMyNT1QYJe5Yj+9EF1IXWWrhV2K985GhS6n+EJ3BrROpmA19Zsm8KbfKuOi5fwZPO4VcxC6kVtYBeN6WX47iXEBz02VXbC/V1ELrHdticPANeryhvEONOwJnNLEdgvccjoamoNvtcbjULIDTMYHUYd+3FaWNJPT8+d60eP/R4MTkvuhF7Ztnr/8d9cYvQdFh/6gbELzafL5U6K1R/F61Ajpwmw1hxHhHWuwftPhX8Ux8wVEOdmyYMhikGZsrh9ijRza5qsSOAxgSu9mMyFL88F5677AfbT3zhrRu9fetPcVEkjCErdvbEIjl0NxY9ZNR9Y/dFYzzo3DJd0eVbhCLRD6E5VaKvhhvSA== X-Forefront-Antispam-Report: CIP:255.255.255.255; CTRY:; LANG:en; SCL:1; SRV:; IPV:NLI; SFV:NSPM; H:GV1PR01MB8433.eurprd01.prod.exchangelabs.com; PTR:; CAT:NONE; SFS:(4636009)(366004)(8936002)(4326008)(66946007)(786003)(36756003)(2906002)(5660300002)(6512007)(316002)(66476007)(8676002)(26005)(508600001)(66556008)(38350700002)(38100700002)(6506007)(6666004)(2616005)(52116002)(186003)(6486002)(36916002)(6916009)(86362001); DIR:OUT; SFP:1102; X-MS-Exchange-AntiSpam-MessageData-ChunkCount: 1 X-MS-Exchange-AntiSpam-MessageData-0: =?us-ascii?Q?GRdzTFN1yUjA2BQOJ1O6SXnwZzJoUxpB+hoZELffCKw1XjqiHsuBG3459vnU?= =?us-ascii?Q?z1TENvRIpYMV2UtjPSaUu1eIlrFAe80m9mrQwcyUhHUWyngjxXC2a8qhkTHw?= =?us-ascii?Q?UNJKU0DhIiLny+E9sqTZw/hA/B1q+ucR+N11tozntAHITbUaTOrHs8IOZrFa?= =?us-ascii?Q?oT52sle5gbyIUvpJ0fRtoF5vU1u7t8QYuQolGeq7yZageOD76ZJ6QMBAxmr3?= =?us-ascii?Q?4W8XcRvGvvVM9xHiZNX4IZDjrrs1PhuDR3e2sK6aTazhjAupJFBTx8GgOPn2?= =?us-ascii?Q?nRg8SoVXD47ep2dX811uDKNdzbBgAkXZKRrZq8eS+xuUeYtiwtMhPj6rxQ+X?= =?us-ascii?Q?fxQilvxNGrRfUwHxtqVaiqSmz6YyUz15O/Hbc3eF4pEA75a0ZPiSqiMIGdX0?= =?us-ascii?Q?1+bnj9O5XJnBaufQyec0yaghLIPqMr89la9bkELncTyi8k68g3IRGqD+ztDx?= =?us-ascii?Q?TwYDx7mhBGhQlTsMRb1+fm4OqRIfLFWhYaJoshpu9jcPl3ahlLkw5RIF/ZxB?= =?us-ascii?Q?l8YXWUo7UOJAXcCzXAHyQLmfWl7ZO960ZfMscJ6pjl5zbOkDnV27ZYPvOK51?= =?us-ascii?Q?ECXUWNa34VtEW0dTv1D6fscgC1S1ejl2zExTEhponTZBwgVNFWxu+uNd8jha?= =?us-ascii?Q?zvlZwjungY2O53Z6QKXYhMIw5BMrtKVDHoPh/baq74FdB5cUSknRo9O20qwW?= =?us-ascii?Q?1NnHz9ibZSsNb3wCcwaoZE6WfD9v6t7frqzirWUKX1cbIMPlzAIMZOUjnEAy?= =?us-ascii?Q?kXhUyuTc7YvajgIluA/IkKBQ4HqFZHS4L3MTMeghITk8xNFlMmJ8q1WBml+0?= =?us-ascii?Q?MkCVs4DSyelhAzIhGAA8P/mF38C6E3LYL7Jn7uzEtCOsVXGE+6MbNqMLIUBc?= =?us-ascii?Q?/Aho/q3WH5rE67LjyJkICWXj8rZgIpUdoAnRHdouffyfMFQTkc/G7V1mZSNH?= =?us-ascii?Q?yiLkr7X90alFcJn6OxVDWejuq74MNe2ay9bJJum5MN5tABsiTaYQLQ5J16fs?= =?us-ascii?Q?9zleTk6L0rNDAVnG3/OaxVBkYh5C84fxmYPXLXbNUBxgBBDODrBMT/eBNcvT?= =?us-ascii?Q?i4dv17uggGaehc3ik4jx6nxq8KO0r21hzWvZogS8At8VUAQ4v2o+/+wZloJq?= =?us-ascii?Q?3+WRc0jdgF5RydPf4DvZeVyeeCSGl6UYGGcd4NfqBxHkzMP0QenBuq35d2AH?= =?us-ascii?Q?lueZDG75Wxyux1sYccm692QeYMx0I6xpfmgbz7jrTeOuck3+YdZtGl2q5ikd?= =?us-ascii?Q?GO8wOo8FP8gL3ud2gNF76ZHWuKjsukzQkpjZFR02osbqBIRBr8U7Ld0OZTaq?= =?us-ascii?Q?CShqA+zNt+Ub5xM+saZNcmGo9zIUO7KOFoBtdrxHTPvgcN1MN4ox3JMsAJRE?= =?us-ascii?Q?RadRbACekvHPNDLdGYtQsKPAue2TQ2wbsN5TgnLiCJl40ctpy95gbNObhiLW?= =?us-ascii?Q?udmJwJDa5HT19kJL6U3pGbzKUdFg7IDpxeqp2qTtFieuVLC5zFtk4AqC/QtZ?= =?us-ascii?Q?swJUVw3D+1SM1Wh4+/M5i/QgbnD3jjF5hRDlZk81HwE4vdhUIZQseA2c2p7e?= =?us-ascii?Q?IrCVR5v9MlV3W+d/gtmBxLN9prOQVVL+QTzbiQU3F2dqbWZX4J37JZQScGiE?= =?us-ascii?Q?pTJMsyu47MCTTn5ovpzLbEQ=3D?= X-OriginatorOrg: ucl.ac.uk X-MS-Exchange-CrossTenant-Network-Message-Id: b89ce584-6cd1-4000-d993-08d9d91b8d3a X-MS-Exchange-CrossTenant-AuthSource: GV1PR01MB8433.eurprd01.prod.exchangelabs.com X-MS-Exchange-CrossTenant-AuthAs: Internal X-MS-Exchange-CrossTenant-OriginalArrivalTime: 16 Jan 2022 18:11:00.9403 (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: VOta5hetDuWsM5i6rjb0uvO/6pJojfy9p0VcK9d9Pp4hKHN8KWhCgn5YSiif9jlOUWrS+JL0O5HqAaGkx2uSOA== X-MS-Exchange-Transport-CrossTenantHeadersStamped: VI1PR01MB5375 Received-SPF: pass client-ip=40.107.14.92; envelope-from=e.fraga@ucl.ac.uk; helo=EUR01-VE1-obe.outbound.protection.outlook.com X-Spam_score_int: -20 X-Spam_score: -2.1 X-Spam_bar: -- X-Spam_report: (-2.1 / 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, RCVD_IN_DNSWL_NONE=-0.0001, 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.29 Precedence: list List-Id: "General discussions about Org-mode." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Cc: Charles Berry Errors-To: emacs-orgmode-bounces+larch=yhetil.org@gnu.org Sender: "Emacs-orgmode" X-Migadu-Flow: FLOW_IN X-Migadu-Country: US ARC-Message-Signature: i=2; a=rsa-sha256; c=relaxed/relaxed; d=yhetil.org; s=key1; t=1642356951; h=from:from:sender:sender:reply-to:subject:subject:date:date: message-id:message-id:to:to:cc: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=wIngclsK2dqVIcSfbUqjpNxulvdk7Hov2CT/COGMtWc=; b=XyHJ4r9A57QguMP4ecr8ZiFDolGt1OInScF0wYvFOzn3liMRKig9VCBe49Ex1UsfAFn2cA LbbOLzJM4uapxJbob3S/GWDj0xcSomec1+hZgnuH/aLAoefNoueYDRNpCblV7eiWF92Nie W5PNCH2C/5x8P4Z9Noxz3R+ezHxbFkw50x2hX4Sx+e3PN8rhv8dFCPAMRQV1HnEUdvR08m HXZvuoHjHLraylImNNCw7sICTVH61Mdwe6/5SG67xpDI/Xnj7RKVE0PunKijZWYwhSsWZm iIT0NOM0APFS3AxHuZrXFj/Hu+WQbhIVd+8CL9j/TMs+Q4PnUMMcSMFe3hy7NQ== ARC-Seal: i=2; s=key1; d=yhetil.org; t=1642356951; a=rsa-sha256; cv=pass; b=FwCS4dXAdGC/WYQp57UrB1Zl19E1ED67qgtVdADeSquJmybfbq0HghQXrKYKvpGL/fqBrL 6sWtFDWxREOzdYA8EdFJpmSzb6uFkZw0E3gT2f6xLALNzT3JkUdluBJQ6YIxG5u6FqTxx4 zX0Oxh2kNb77SYvLZB3Q8NzGbVh1Vh8q0p4zJynFM9Q37S075jr0u98kPnpsge+Rf3L1+V cYampzewqpJEKj8M5kz4mlebkK/Qa7gNUcXDsR3O1OaoJ/kxEo+6iq9WlQa0ffdx/hm/ur WW/Ve3yqMUoTSLSeX+PSTpI6W1lgOEUyMDFw2yF8dzR3WVsHjn9nX3tGReTHew== ARC-Authentication-Results: i=2; aspmx1.migadu.com; dkim=pass header.d=ucl.ac.uk header.s=selector1 header.b=ONxkpL3a; 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+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-Spam-Score: -6.32 Authentication-Results: aspmx1.migadu.com; dkim=pass header.d=ucl.ac.uk header.s=selector1 header.b=ONxkpL3a; 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+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: 418751D8AE X-Spam-Score: -6.32 X-Migadu-Scanner: scn1.migadu.com X-TUID: l1hAjp6Wdxh4 On Sunday, 16 Jan 2022 at 10:35, Samuel Banya wrote: > How would you able to keep the running totals in Column E? Using your initial example, adding a header line to give a starting point, the following works: | Date | Item | | Debit | | |------------+-------------------------+---+----------+----------| | 01/03/2022 | Example Rent Expense | | -1061.67 | -1061.67 | | 01/04/2022 | Example Food Expense | | -1061.67 | -2123.34 | |------------+-------------------------+---+----------+----------| | 02/05/2022 | Example Utility Expense | | -2061.67 | -4185.01 | | 02/06/2022 | Example Random Expense | | -2061.67 | -6246.68 | |------------+-------------------------+---+----------+----------| #+TBLFM: $5=@-1+$-1;NE I've not included monthly sums as this would complicate things (although should still be possible...) but retain a dividing line for clarity. The top entry of the last column could have a starting balance, if you wanted. At the moment, it's treated as a 0.00 value. -- : Eric S Fraga, with org release_9.5.2-306-g9623da in Emacs 29.0.50