From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: from mp11.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 sId8MmMY42PwEQAAbAwnHQ (envelope-from ) for ; Wed, 08 Feb 2023 04:34:59 +0100 Received: from aspmx1.migadu.com ([2001:41d0:8:6d80::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by mp11.migadu.com with LMTPS id 0GR6MmMY42NqGAAA9RJhRA (envelope-from ) for ; Wed, 08 Feb 2023 04:34:59 +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 A5190211CB for ; Wed, 8 Feb 2023 04:34:58 +0100 (CET) Received: from localhost ([::1] helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1pPbDn-0006qK-Ie; Tue, 07 Feb 2023 22:34:11 -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 1pPbDl-0006qB-Pd for emacs-orgmode@gnu.org; Tue, 07 Feb 2023 22:34:09 -0500 Received: from ciao.gmane.io ([116.202.254.214]) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1pPbDk-0000RI-6K for emacs-orgmode@gnu.org; Tue, 07 Feb 2023 22:34:09 -0500 Received: from list by ciao.gmane.io with local (Exim 4.92) (envelope-from ) id 1pPbDi-0002lo-1o for emacs-orgmode@gnu.org; Wed, 08 Feb 2023 04:34:06 +0100 X-Injected-Via-Gmane: http://gmane.org/ Mail-Followup-To: emacs-orgmode@gnu.org To: emacs-orgmode@gnu.org From: TRS-80 Subject: Re: netspend table Date: Tue, 07 Feb 2023 22:33:56 -0500 Message-ID: <87zg9ohluj.fsf@isnotmyreal.name> References: Mime-Version: 1.0 Content-Type: text/plain User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/27.1 (gnu/linux) Cancel-Lock: sha1:ElFm/SHzXMmywHfyIxSK/NFNQjw= Mail-Copies-To: never Received-SPF: pass client-ip=116.202.254.214; envelope-from=geo-emacs-orgmode@m.gmane-mx.org; helo=ciao.gmane.io X-Spam_score_int: -16 X-Spam_score: -1.7 X-Spam_bar: - X-Spam_report: (-1.7 / 5.0 requ) BAYES_00=-1.9, HEADER_FROM_DIFFERENT_DOMAINS=0.249, 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: , Errors-To: emacs-orgmode-bounces+larch=yhetil.org@gnu.org Sender: emacs-orgmode-bounces+larch=yhetil.org@gnu.org X-Migadu-Flow: FLOW_IN X-Migadu-Country: US ARC-Authentication-Results: i=1; aspmx1.migadu.com; dkim=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"; dmarc=none ARC-Seal: i=1; s=key1; d=yhetil.org; t=1675827298; a=rsa-sha256; cv=none; b=Zg6MddauOvqi5/fxwZ5OM37Cq2R2mkKsy8U/LTS+w6GWZgSQz2DU77xnSd/l4/2iFT24XB kNRJxFxddHadRuIXbjDsBmVaZsRRjbVmE5iBgcXwr3zVMSIKlNHPJQ23LGssXi2sqiA3EC th80gH1JgqQHdXCBBWuNtpVyVkbadcfl5zvXj9ZInuGJqf51EUXGta9I4lozaaf4WqNpqS nT01ITxRjQGeZfUXJ/2ZK7o5xFxR4gwfjxZLtUukyAOvVTEjfZtS0fjnI5ysr5oJyvtvNH O8qu9WJ2tw6XLwX99iUFlnVembSZeQ+lJZ6H0gHNBLHwqeMG3ZwhbZRxV3+vaQ== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=yhetil.org; s=key1; t=1675827298; 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:references:references:list-id:list-help: list-unsubscribe:list-subscribe:list-post; bh=IX020jInBYOoLAudgvmesTlo4vjfcACTSrN8PWMIx7c=; b=qpNSlhMF2wDOILFzzavKDAQ/i1sgvgPZdQ4thsc1G+P8qaCy6XfbKJ53PQ4MHzP+q4g27+ Dm4EwIMW83A2h7uRsY+LnUiwC3keVUBfIBwRtCk9C8Gkx2BULkM2OqyjHOrG9XuM2QnBBM j76A1WVO003gEYrKwq9AEDeS8rMunpV6KYYFwgmcZ6KJK6+wTFJJWJEK3HHBNA+4XQ616s HbHQm8al0qgubzt1/U/UlQUB8oEZZVj1UN8PU7d20BWAqWsQLDmRuZZDAhLNPpRvQ3yv9m SjLsEPh2Hy2YVQJ34Ne+AbeNvBTlI5z5Knq7TyIsUbyN4WKmuP5ppIaak8PUFg== X-Migadu-Spam-Score: -0.89 X-Spam-Score: -0.89 X-Migadu-Queue-Id: A5190211CB X-Migadu-Scanner: scn1.migadu.com Authentication-Results: aspmx1.migadu.com; dkim=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"; dmarc=none X-TUID: I9QcGNNGEMln Jude DaShiell writes: > I think if I ever get good with #TBLFMT lines I'd like to write up > tables that cover many more useful and simpler calculation tables now > missing from documented orgmode. I replied separately about the accounting use-case (and I still think that's best handled by accounting software). However I also agree that tables (spreadsheets especially) are very, very useful for many things. It's so handy having a little table (and some calculations) right there in your notes. It took me quite a while to get the hang of it though, but eventually I was able to produce some quite impressive (to myself, anyway) results. I guess what I am trying to say is, stick with it, the payoff is worth it. Since you provided this as an example though, we will work with it anyway. If you have some other ideas, post them to the list (in new topics). I think it would be very helpful for a lot of people to see some examples of this. And I'm happy to share what I've learned. > This is a running balance table and I don't know what kind of a > #TBLFMT line would be useful for that either. You probably want to use a formula referencing relative (instead of absolute) locations, something like: #+begin_src org Original table: |--------------+------------------+--------+-------+---------| | date | transaction | amount | fee | balance | |--------------+------------------+--------+-------+---------| | [2023-01-11] | original balance | +0.00 | +0.00 | +423.17 | | [2023-01-12] | dunkin | -18.68 | -1.00 | 403.49 | | [2023-01-13] | WalMart | -28.68 | -1.00 | 384.88 | | [2023-01-16] | Deposit | + | | 634.88 | | [2023-01-17] | Capris | - | - | 615.34 | | [2023-01-17] | Mcdonalds | -4.74 | -1.00 | 609.60 | | [2023-01-18] | verizon | - | - | 543.35 | | [2023-01-26] | dunkin | - | - | 542.37 | | [2023-02-01] | damgoodcafe | -13.28 | -1.00 | 528.09 | |--------------+------------------+--------+-------+---------| Empty amounts (signs only) removed: |--------------+------------------+--------+-------+---------| | date | transaction | amount | fee | balance | |--------------+------------------+--------+-------+---------| | [2023-01-11] | original balance | +0.00 | +0.00 | +423.17 | | [2023-01-12] | dunkin | -18.68 | -1.00 | 403.49 | | [2023-01-13] | WalMart | -28.68 | -1.00 | 373.81 | | [2023-01-16] | Deposit | | | 373.81 | | [2023-01-17] | Capris | | | 373.81 | | [2023-01-17] | Mcdonalds | -4.74 | -1.00 | 368.07 | | [2023-01-18] | verizon | | | 368.07 | | [2023-01-26] | dunkin | | | 368.07 | | [2023-02-01] | damgoodcafe | -13.28 | -1.00 | 353.79 | |--------------+------------------+--------+-------+---------| ,#+TBLFM: @3$5..@>$5 = @-1 + ($-2 + $-1) #+end_src I am not sure what those signs (+/-) with empty amounts were about, but the way I would do it would be to make your entries in the 'amount' and 'fee' columns, and then let the running balance column be calculated. That's what I did in second table, above. Let me know if you have any questions. -- Cheers, TRS-80