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 KGQgJsNr3GEgbgAAgWs5BA (envelope-from ) for ; Mon, 10 Jan 2022 18:24:19 +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 gFXUHsNr3GE8eQEAG6o9tA (envelope-from ) for ; Mon, 10 Jan 2022 18:24:19 +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 45CC0281A0 for ; Mon, 10 Jan 2022 18:24:19 +0100 (CET) Received: from localhost ([::1]:59220 helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1n6yP4-0000tG-Du for larch@yhetil.org; Mon, 10 Jan 2022 12:24:18 -0500 Received: from eggs.gnu.org ([209.51.188.92]:42294) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1n6yOb-0000t6-1t for emacs-orgmode@gnu.org; Mon, 10 Jan 2022 12:23:49 -0500 Received: from [2607:f8b0:4864:20::92d] (port=41814 helo=mail-ua1-x92d.google.com) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.90_1) (envelope-from ) id 1n6yOZ-0001qD-Ij for emacs-orgmode@gnu.org; Mon, 10 Jan 2022 12:23:48 -0500 Received: by mail-ua1-x92d.google.com with SMTP id p37so24722437uae.8 for ; Mon, 10 Jan 2022 09:23:47 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; h=mime-version:references:in-reply-to:from:date:message-id:subject:to :cc; bh=FBKkqiNMX8xWnZkiiqCDJnj7cwtzJYz2PkEAKjCU8cA=; b=KvElk+m5QzSpW79zrZqh6ajrxL35fdJpCnS7zmVAgjQq1FxIGpaGHHjKL7n2T+72SR axDQsY7Jaz+wgjiAsmwmO76z8fcNztTTSIN6Q2VWbyPrp7THYEH+WQksuy6SibLbYAc0 tfXckmzLfiE7eAgnvTHaynbNJLS8xwmrBoE+eRKyHo+or3PWIMLsAL+YC4xmA0PbUkQq COFrtrUxeEZzOCyUEgkSWgqb1jFJj5Jym0pR19tsch6xCYjWgD6tPIY7vim2KDw+tBOL tX6OIk697S7hfJWxXTWTn5D0yS7NU3vvon18UNASZ+U5a1O4CRNIzDxL0E4h8A/AUEFB j1iQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=x-gm-message-state:mime-version:references:in-reply-to:from:date :message-id:subject:to:cc; bh=FBKkqiNMX8xWnZkiiqCDJnj7cwtzJYz2PkEAKjCU8cA=; b=34TRTgn0ccAvyAPJ+SlBtj0n5xnalJh5GZrenErrFowGGCOQZCTBIhPQHO+Kn32Mvq QG/DOHZqdgWarDHJPY/gT1AErkGE5nyo2Hj9X+JjrSV//qIjxPXsQOhNx2zvHOw54Bpj KyY7fk0dttkYgNUhN421gLlID9kKQE0cmoQ5clgJ4P6fyhyQZsbqPc+P5RummKaZ/uLT 7iJpnVi1KFtZmMj1yeEA3WeMPGhM5knAMyXDHzm2CyKGbjd1zmoaf9RcgdpjqLqnBRB8 4IfiGuE2oonuR1lUvnuusTC3N13b+s6MyfnKlgUCGuTQkZLReKB8z8MyHyVvWAe5RPKm wmFA== X-Gm-Message-State: AOAM530lfxrzwRbFisCY11UqkrZOaLWL+Nxz3JaZ5qht2WhkMlR6zOmC gtTDfhjeRTRmypxEeH7xbm4konCkAP9rwXpglxY= X-Google-Smtp-Source: ABdhPJwNaL0ZjYuzwLNmSzVYtbc2R1mZbutwjru9sKvb3ScELTPAV+krA7AFZ4vdUZrebH59Ago9Dzn0hWDQSfoEgAM= X-Received: by 2002:a05:6102:22ef:: with SMTP id b15mr291081vsh.72.1641835426696; Mon, 10 Jan 2022 09:23:46 -0800 (PST) MIME-Version: 1.0 References: <137562d1-e6fe-4a68-b18b-abedef513fbd@www.fastmail.com> <87zgo4xea3.fsf@mbork.pl> <2352934.1641828705@apollo2.minshall.org> In-Reply-To: From: John Hendy Date: Mon, 10 Jan 2022 11:23:35 -0600 Message-ID: Subject: Re: Question Regarding Creating Workflow For Automatic Formulas For Finance Based Org Spreadsheet To: Samuel Banya Content-Type: text/plain; charset="UTF-8" X-Host-Lookup-Failed: Reverse DNS lookup failed for 2607:f8b0:4864:20::92d (failed) Received-SPF: pass client-ip=2607:f8b0:4864:20::92d; envelope-from=jw.hendy@gmail.com; helo=mail-ua1-x92d.google.com X-Spam_score_int: -12 X-Spam_score: -1.3 X-Spam_bar: - X-Spam_report: (-1.3 / 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, RCVD_IN_DNSWL_NONE=-0.0001, RDNS_NONE=0.793, SPF_HELO_NONE=0.001, SPF_PASS=-0.001 autolearn=no 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: Greg Minshall , Charles Berry , Neil Jerram 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=1; a=rsa-sha256; c=relaxed/relaxed; d=yhetil.org; s=key1; t=1641835459; 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=FBKkqiNMX8xWnZkiiqCDJnj7cwtzJYz2PkEAKjCU8cA=; b=obog94NIaJKDSrdRq8bRtPQyI/gQCr4MPqflUACr+angjSM6gDQAJ8LxFgYA+ytRjGT8Fz dfLSm6laky2MUxz0AAnAh+xwGwwkFLW98j7UaAnLZOAT2kUpOcG4Cr1QSUh4ZEuVKdXNH/ /PbKXt33nigqYh9MW1Qp2pUdD3PUeQdJrrfLKnze2aFCz6czRMqf9CQa3T2jh5vsgMnnTu ofpR9oHENE21m5Gv8hgKC+/+ORsmHoIFbGMku6L83FUqnkynclyWUQbuQYQldJ2KpByeu7 G/ahZlhv69smDDqiePjYLnGLRBelsknYrRS3PAlAkQTWgdBtOmak6W1QsxY1tQ== ARC-Seal: i=1; s=key1; d=yhetil.org; t=1641835459; a=rsa-sha256; cv=none; b=dyA6GVjIuQZ+Qy97pjsMiF8eQA/axCFqOokNGM0SqOIxeM9BXf3P+Ah0ZgsjylX3H/hvkf EVpuN3YAkLaGn2AFtkhVC43DQYYAMzST5pOzjYwx3C1QLMyjLlgP97tJ1jOrwi+xFo8E+r cEJwjy/yrbjFa+36R4wPgnoRNJ31iXh10tmKZi5fWafdkFNxfCblkisJE0iXmw9HbNirgP lgP+cKb0AugtIhBlxoaj9yNl4V2HO3S/B8JgDLVcOlU2x0ZTfumxbbjPMWtXosBghwxjEj +/raJEWZzIfWEgQWNfMS25k/AGZH6Va2dhWytDbErypcedu4f06yGdafY7Uvew== ARC-Authentication-Results: i=1; aspmx1.migadu.com; dkim=fail ("headers rsa verify failed") header.d=gmail.com header.s=20210112 header.b=KvElk+m5; dmarc=fail reason="SPF not aligned (relaxed)" header.from=gmail.com (policy=none); 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: -2.01 Authentication-Results: aspmx1.migadu.com; dkim=fail ("headers rsa verify failed") header.d=gmail.com header.s=20210112 header.b=KvElk+m5; dmarc=fail reason="SPF not aligned (relaxed)" header.from=gmail.com (policy=none); 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: 45CC0281A0 X-Spam-Score: -2.01 X-Migadu-Scanner: scn0.migadu.com X-TUID: bcBGdHVsqlze On Mon, Jan 10, 2022 at 11:09 AM Samuel Banya wrote: > > The 'double reporting' idea might have been why I just flat out shook my head when I saw the one presentation on 'ledger' in Emacs on YouTube a while ago as its a bit too complicated and unnecessary for a layman. Fair, it's a bit to wrap one's head around. That said, I think it's also standard and one doesn't end up having to actually create two entries for every transaction, for what it's worth. > I just don't need that kind of over-thinking when it comes to my finances since I just need a spreadsheet that listed expenses, and to count totals. That's about it. In that case, would a running csv where you paste in each month's new pull work? You could even keep the totals to the side, so that as you paste new data in e.g. cols A-D, your totals (in E and beyond) can sit right there happily? I alluded to this with respect to the request to automate csv -> org; without knowing which things must be org and why, it's hard to comment on these kinds of inquiries. Maybe org is just more fun, maybe it's mandatory because there's some other aspect of this we don't know. > I will take a look at the other suggestions with specific Org Mode formulas, looked awesome, thanks. Happy to help and good luck! John > On Mon, Jan 10, 2022, at 10:31 AM, Greg Minshall wrote: > > > I'm wondering if your opinion about Ledger isn't influenced by the fact > > that it uses basic accounting principles, like the idea of double-entry > > accounting. For me, it's /very/ simple and intuitive, but I graduated > > in economics many years ago and had a (basic, but still) course on > > accounting. If that is your problem, I'd suggest spending some time on > > understanding that - even if you don't end up using Ledger but some > > other software, you might find learning about accounting useful. (Also, > > it's fascinating. No, really! It's an extremely clever abstract > > system with a real-life use-case.) > > i agree that learning the principles of double-entry is worthwhile, > actually interesting, and of a very interesting history! > >