From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: from mp12.migadu.com ([2001:41d0:2:bcc0::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by ms0.migadu.com with LMTPS id yD3DNks73GHMygAAgWs5BA (envelope-from ) for ; Mon, 10 Jan 2022 14:57:31 +0100 Received: from aspmx1.migadu.com ([2001:41d0:2:bcc0::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by mp12.migadu.com with LMTPS id EGFlM0s73GGlUgEAauVa8A (envelope-from ) for ; Mon, 10 Jan 2022 14:57:31 +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 789C1329C4 for ; Mon, 10 Jan 2022 14:57:31 +0100 (CET) Received: from localhost ([::1]:34022 helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1n6vAw-0005Ab-JS for larch@yhetil.org; Mon, 10 Jan 2022 08:57:30 -0500 Received: from eggs.gnu.org ([209.51.188.92]:41190) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1n6v8y-00059O-UP for emacs-orgmode@gnu.org; Mon, 10 Jan 2022 08:55:29 -0500 Received: from mail-am6eur05on2101.outbound.protection.outlook.com ([40.107.22.101]:54848 helo=EUR05-AM6-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 1n6v8v-0000NA-84 for emacs-orgmode@gnu.org; Mon, 10 Jan 2022 08:55:28 -0500 ARC-Seal: i=1; a=rsa-sha256; s=arcselector9901; d=microsoft.com; cv=none; b=aSLi1j7Jol4ulrETZ/waV1hCG3C2taaVQ7NteWEJ0VcoqkbgqnkOXUY100ZIWLafh+Q5QidN+hoGPO6HUZwDmywHfILvXEH4a4/C9saXAcM/PxsM979CAYa/eBzSAtz4ogd4DKOzEyska9NsXBsNVwz1fbiBX2al/0W/dWpoxHI03UuTKKE3b3lRkFFQOrm2FnUSPHPZjQzpr0rRzaJJAW/3jioRQMwEqRmwiVrs1GmWuUyivh1Md9deaJ2/L8To9PHRjcDufnbBbBSYdfVkLbeITCIWga2NDtsdBs/SW23rjSE3Nbo7BuTyINOx5XxlOttxc0vuTbZENM122FhYgg== 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=HpO5mmN/FNMWS6EehNMKHn6VPKsiPMKuELMoCOhQ3TE=; b=htpwKVLoT8WoxqDg6CFArAu3mZdZqsJiahM8lyfuafxZS/IDixhMVKVKRjnM1eLtC9635dnsF8Vxav3JtdsgGpd4eL8CdAMXmv31BjyLCcu2vMNkwcefxcLoGsqrQRn5Ievf99Svkdw+3FPWt5VcJOn/deyLSTda0wIzbmy0N47GfKJEySrHRQjMTqTGqD3U1wJLevdRwTLrf4BeHHh9pHH6oOK5S2FEV8h6LS+zJgejNnjk9GB+q398q0itnlSLeBk8vmAS0MpAUQ204nMMl6uAUSh14i7PLOl0YbvGpeWYTXDW0e5OwKuq0bU3XIKshAY8qhSiO+5Lu33eYUGCWw== 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=HpO5mmN/FNMWS6EehNMKHn6VPKsiPMKuELMoCOhQ3TE=; b=hbajwCOvyeIXNP6NQ1zeWdblWN7ScLgkEUgZcXKR1krQFeg7WqkAuNxYRY+bkjPBQ86OR+1CnlrOAmS8yGVfFSqpwziLzTWWAjXvFgEEhCYQmiTvobXy+Kl0evs8yBH8GLlzDTCmDxFi8WCpM3BvptA3m0AoQAnOd5CkoV+yL3c= Received: from AS8PR01MB8428.eurprd01.prod.exchangelabs.com (2603:10a6:20b:443::13) by AS1PR01MB9418.eurprd01.prod.exchangelabs.com (2603:10a6:20b:4d2::21) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.4867.11; Mon, 10 Jan 2022 13:35:33 +0000 Received: from AS8PR01MB8428.eurprd01.prod.exchangelabs.com ([fe80::7de9:d269:6084:d523]) by AS8PR01MB8428.eurprd01.prod.exchangelabs.com ([fe80::7de9:d269:6084:d523%4]) with mapi id 15.20.4867.011; Mon, 10 Jan 2022 13:35:33 +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> X-Url: http://www.ucl.ac.uk/~ucecesf/ Mail-Followup-To: Org Mode List Date: Mon, 10 Jan 2022 13:35:32 +0000 In-Reply-To: <137562d1-e6fe-4a68-b18b-abedef513fbd@www.fastmail.com> (Samuel Banya's message of "Sun, 09 Jan 2022 11:56:05 -0500") Message-ID: <87ee5f90ij.fsf@ucl.ac.uk> User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/29.0.50 (gnu/linux) Content-Type: text/plain X-ClientProxiedBy: LO4P123CA0019.GBRP123.PROD.OUTLOOK.COM (2603:10a6:600:151::6) To AS8PR01MB8428.eurprd01.prod.exchangelabs.com (2603:10a6:20b:443::13) MIME-Version: 1.0 X-MS-PublicTrafficType: Email X-MS-Office365-Filtering-Correlation-Id: 908b4ba2-eda3-45e1-065d-08d9d43e1399 X-MS-TrafficTypeDiagnostic: AS1PR01MB9418:EE_ X-Microsoft-Antispam-PRVS: X-MS-Oob-TLC-OOBClassifiers: OLM:6108; X-MS-Exchange-SenderADCheck: 1 X-MS-Exchange-AntiSpam-Relay: 0 X-Microsoft-Antispam: BCL:0; X-Microsoft-Antispam-Message-Info: qNExco3TsXWllfEKRQxn/hLqKRVVk2DAm82X9lU9xrbVY//qMrxkpVl01wwkxt6Tfy3yQE7iqTS7HRf0iXdeAztST0YHwGSFw5JX2H2QIGP71lf24vFCeZMEJa0VkhyGwtuVxpDRzI3S93wCBJsguF8t60ltgsn1qb9OVF/wxuZtO9eQf1iA12QY13HHsQ62bScfcFzjJQ0PVinc1BHDkDE/RWh6m0/jiuAPgNs5eE8ybAlrY1yQbPnwUuzCZ9X1WiwPCi0fRBi0h5AZRYdYbA8GZvySiiUNdNMbiO6tCi1SFxlHwzXvPPJ5OhvSQ5ajWwk+qxa90PQGfJVmabmVNQ/hsvLxvOejBWb3ne6snd4T1EQr7pf+OHQaR6NGlQJZ4S1eOfjbKdoEvV6t9m+/9SLaxgEGedO8Wn0yl5jvWSDP7hYCnABPVDTn2xSOnxPL3VkSiRRT/3SL5PZJs0Wi9ft7zpN8shOYQzKf506/UC3LKemPVO5MQ8xKrxL16WLdAwSeyJ6+vU1zUuHsqggtGSMvdUsmqW424hrTmo55zEebW5EaiPMN7HDkF/R42L1zoaRU6AxREUoIZPYT3dkA6eOz5k/hGDq0KCtE3MFYKCT9NKsKEC0en/ObR8M/U2FHoZBkBtL00TQKKy6SnIlSB9wnozqnxYyBWc11pO8wqnqUTkeEdNfL3wvPoNa92kmIaLRTGYSKvnd3BOOO4TiMXELP479y6M51eJmXw0F+cuiZy+9Y8W80LrXEQe2+UDqHJJNgztyFjwLfnkvJGNZ4PQ== X-Forefront-Antispam-Report: CIP:255.255.255.255; CTRY:; LANG:en; SCL:1; SRV:; IPV:NLI; SFV:NSPM; H:AS8PR01MB8428.eurprd01.prod.exchangelabs.com; PTR:; CAT:NONE; SFS:(4636009)(366004)(6486002)(966005)(66946007)(26005)(508600001)(36916002)(36756003)(6512007)(2616005)(2906002)(86362001)(66556008)(186003)(6506007)(66476007)(6916009)(83380400001)(52116002)(38100700002)(316002)(5660300002)(786003)(8936002)(38350700002)(8676002)(4326008); DIR:OUT; SFP:1102; X-MS-Exchange-AntiSpam-MessageData-ChunkCount: 1 X-MS-Exchange-AntiSpam-MessageData-0: =?us-ascii?Q?PvUEqm7mYvdiI6eJVbK2qOXzXrcyDwl1IZJOcpjjWDLUjIiUqYUgs0TwswQp?= =?us-ascii?Q?F9GSXtNNT1Xn4u+r37NbrhnP1u0igQXNytRuArwsm5lAdQoZS7JktC8Ionqt?= =?us-ascii?Q?Gf5GRqXcaRT28iI7pAMOzoLOCE2qau3rLX4cxXwaYUJqBvVHJpX9zb8Z27Bu?= =?us-ascii?Q?r9uE1fKr374ZouEYgLonwBgYQN4tpQvVdLgX5pdsZVEoXXwTjHNfumN4d4wJ?= =?us-ascii?Q?+AnkbCR/6JsjH8TFqdfiWB8DIVT5TnpRilvoPXBcv/ULqB0HIOor5Z6AGUPF?= =?us-ascii?Q?mY7cRIX/pUI0kU1Qs2SVOXQdF0SBX8fDlG2n8QzctXSAWaHRUAe8rvltBroy?= =?us-ascii?Q?6cy9yjmRka/EvMFKfdFdbdqKL/Mv4kTFX/FACWaSgNTphHPK6wA0dYVi99MS?= =?us-ascii?Q?BFF2tVRaSzbFFDfVhJZdWMLhTRpX2zGUBzTE1PRmMhgem2kLrCZjHTM7dcA2?= =?us-ascii?Q?96nqSiIPIyDCD3TtOQgkWt4EwFdlu42Hpe1F4TX77t6oD5faV6C/RhNh9j1B?= =?us-ascii?Q?HxOzict22DYP28O/XkWjRAJyc4Wjbg8F5Kr/8swhQmGzrofoOsAhz/rR4hfO?= =?us-ascii?Q?Mrpo+clsl7fvuKA4RAc3rbPKtogBfe0v91IeBB/zjVAerU3uN75O3JHeqv2d?= =?us-ascii?Q?D3pYmJyT29iBOx/Gi2ANFSgXo2Oj9bNpZkjuIqdfiSc5TtajTVtIGE3r/YL8?= =?us-ascii?Q?VjGhlJR8coK1KqRx97WqfZXc0vk5nfoJTdngaDtWnhRuZ/pcx4MbTa6eCQGW?= =?us-ascii?Q?uFGrE8NAfQIL+o48ki2tui+0TCOYJnhene42cxdoDE7/T4zz4VrQ4wh1yv1q?= =?us-ascii?Q?gmWhypw+Dgv9HaaRpKugrdQtVnGB39FdBlfch1myGs7tLDHdjyJkU5OBDcyy?= =?us-ascii?Q?olrWuxTMHXuFPa4EzIytOTUGmNDpSnslaans8mHTunmgi7wsW8YMK/DOdeut?= =?us-ascii?Q?cK9Iz+GGKdYPb/t8yTR8xSYmRH6VJqVFc4oH3ctN1hWe3kWgRMX/0FRCjuo+?= =?us-ascii?Q?Lg7BthEp+cun8ZhRBruC40q6TD2zdSMm0pjYbJvkTT8Y1OCGd0gsQ1lhmGie?= =?us-ascii?Q?58tLJRszQwUXO3sd2Q2/Oke20ECVk4l6t4f2hw7czymkPgR6LZnPbEqGoLEp?= =?us-ascii?Q?pByfMtmwCuNHFlAkTlhPKGEKw/gYPnREhUymmGGgcRf+4NbkM6PfDfF/AoPc?= =?us-ascii?Q?k3+ZIDAIx8aOZIcKtw7SYQLc/77G9u2SSEuUAFy/rxArrRrKUXqrdRC+BBHK?= =?us-ascii?Q?s78AmPu48nuELVuE+0q8SHUY+iIYK8+Gqhbjuhnltg/U5zFLa/dWzEodn+Yg?= =?us-ascii?Q?QXJ71LAMuU9u+mql9D1cFZI8MmXDQIhDyrbBX/3YYLkG7kPriONrb+i92C8E?= =?us-ascii?Q?hBbo6p4DIs5xQ7FbCKsi5ROEl+zg/ST2c3BvznFeRrnI6E1Sm8xaayE4S9Sn?= =?us-ascii?Q?Ircvx5k4ZY8kEeOCrHwJHEx1AXD8aMJNjhni4QIPsDtzrm9XAemLtPw8xtJE?= =?us-ascii?Q?aaZhW8Cz/v5vxeZpLT7tBEX3XFmC/FksWo/vQ0NqRjWlcxqMWWFTBjuVsZxO?= =?us-ascii?Q?42DFZFSXh2qzBgHWY0phJ7tFFoTENmLQT1Q/ICgAhUSdDL6h1MULg0GZHx1V?= =?us-ascii?Q?4dxhBoLUBSn+Rd4NKAqZmCc=3D?= X-OriginatorOrg: ucl.ac.uk X-MS-Exchange-CrossTenant-Network-Message-Id: 908b4ba2-eda3-45e1-065d-08d9d43e1399 X-MS-Exchange-CrossTenant-AuthSource: AS8PR01MB8428.eurprd01.prod.exchangelabs.com X-MS-Exchange-CrossTenant-AuthAs: Internal X-MS-Exchange-CrossTenant-OriginalArrivalTime: 10 Jan 2022 13:35:33.4616 (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: I3vXq0sP31ZUGc0qRIlNqAA3q/SQLQMv1z59yZqhOyJB2zzvB8gsmRb07nD6WZWuqMRuHDy06ZLIAh5MWqIpnA== X-MS-Exchange-Transport-CrossTenantHeadersStamped: AS1PR01MB9418 Received-SPF: pass client-ip=40.107.22.101; envelope-from=e.fraga@ucl.ac.uk; helo=EUR05-AM6-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: Emacs Org mode mailing list 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=1641823051; 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=HpO5mmN/FNMWS6EehNMKHn6VPKsiPMKuELMoCOhQ3TE=; b=cJBSmdLIv2q4Tys5dvXS6teQfW/oNmedw6FezCOueBPE9REt95HSbgh1dPw3oAK+a6XqjP P0Vkv6xIK0cpnu1DRAL9HjPPZ5wJYryGScshWEf1B20zFM70iLAi3Pg8R9n6kstQy29LEF DBjz5Wo6wc6mZW/8ChD4YK0JLtyRplRAjE+QryfTKVxd3IDMloEix0HYuA/LMm+0QnR5Mm LkQoVbL8RP+XKqKvvIAMW1+sniAWLvj7f1t5Y5f+0yDWsFTXtckRLmuvhG3tpbHOqdBP0r WmtglKzYvaaaBUDH37Trnt1LUxgHXjuUPHyqhQ9L8SlaXIl84lVX45bKYyhn3w== ARC-Seal: i=2; s=key1; d=yhetil.org; t=1641823051; a=rsa-sha256; cv=pass; b=Hu7ksHlXa2NqTeIZiQ9azztpmJnEPeZKSM23YlXJFEKVc2DsLcMYHudLJKeiNRTrK2uVHl XbQ3cm5bm4WE9qqgLmFjt0ff7i+IxMmExo6Vj6JwYu0kHiMGOZntXdE/qHHI/H/5h2HgwC FIiWy1k/74lmIsQpGF71Ppl9JhfLO+iYKG0dPh+U1D9JvOKRUU/IcaULYbr0EkNHZp3CEK qyDEU1c0dZZ749vEl8fUpeiVrmqND7aP2OVvXf938YOnzQOrrD/b7jWPVNs1/Qt1tEbBOu Y3yPHjgAtvP5q4FCM87yr4QMl3us3urmWvysMG9SEpWak3kQbtH8O29rDoTMjw== ARC-Authentication-Results: i=2; aspmx1.migadu.com; dkim=pass header.d=ucl.ac.uk header.s=selector1 header.b=hbajwCOv; 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.31 Authentication-Results: aspmx1.migadu.com; dkim=pass header.d=ucl.ac.uk header.s=selector1 header.b=hbajwCOv; 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: 789C1329C4 X-Spam-Score: -6.31 X-Migadu-Scanner: scn1.migadu.com X-TUID: qTA0vwkJ8hfC I would suggest the following: |------------+-----------------------------------------------------+---+----------| | 01/03/2022 | Example Rent Expense | | -1061.67 | | 01/04/2022 | Example Food Expense | | -1061.67 | |------------+-----------------------------------------------------+---+----------| | | January expenses | 0 | -2123.34 | |------------+-----------------------------------------------------+---+----------| | 02/05/2022 | Example Utility Expense | | -2061.67 | | 02/06/2022 | Example Random Expense | | -2061.67 | |------------+-----------------------------------------------------+---+----------| | | February expenses | 0 | -4123.34 | |------------+-----------------------------------------------------+---+----------| #+TBLFM: @3$3=vsum(@-I..@-II)::@3$4=vsum(@-I..@-II)::@6$3=vsum(@-I..@-II)::@6$4=vsum(@-I..@-II) where each month is collated separately; all you have to do is append each month to the table, add some horizontal lines and copy the formulas modifying the row number. But I also would highly recommend ledger which is what I use for my accounting and which integrates very nicely with org using babel. Ledger supports converting CSV files from banks into a ledger file (section 7.2.1 of the ledger info manual). -- : Eric S Fraga, with org release_9.5.2-293-gb8656a in Emacs 29.0.50 : Latest paper written in org: https://arxiv.org/abs/2106.05096