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 ms5.migadu.com with LMTPS id cKavDHMg42NDBQEAbAwnHQ (envelope-from ) for ; Wed, 08 Feb 2023 05:09:23 +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 +AvSC3Mg42MLHgEAG6o9tA (envelope-from ) for ; Wed, 08 Feb 2023 05:09:23 +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 547A921AC1 for ; Wed, 8 Feb 2023 05:09:22 +0100 (CET) Received: from localhost ([::1] helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1pPbkw-0004Vu-2g; Tue, 07 Feb 2023 23:08:26 -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 1pPbku-0004Vj-HW for emacs-orgmode@gnu.org; Tue, 07 Feb 2023 23:08:24 -0500 Received: from mailbackend.panix.com ([166.84.1.89]) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1pPbks-0005yE-QW for emacs-orgmode@gnu.org; Tue, 07 Feb 2023 23:08:24 -0500 Received: from panix1.panix.com (panix1.panix.com [166.84.1.1]) by mailbackend.panix.com (Postfix) with ESMTP id 4PBRLW5JRNz3jg3; Tue, 7 Feb 2023 23:08:19 -0500 (EST) DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=panix.com; s=panix; t=1675829299; bh=7yDV20aIXw1190zcWNkDSVAxmvjW3oo1BwTOXfkqGWI=; h=Date:From:To:Subject:In-Reply-To:References; b=QzKUyldsGgq5IHSyUZ7kDkIW3YA1AiBW6v9AR6bwZNRc+dHYySXGAhNuajn3h9pQq K+fnIbbRpCmxuZJvdFCajyTta1lwC/osHoCcH7nizuLC5Cfl8CMWv/4xPDxHb+JEnn dymPdpMNmlqTMVFR2aUrDMMp++77klM3s5PlkDQk= Received: by panix1.panix.com (Postfix, from userid 20712) id 4PBRLW4nL6zcbc; Tue, 7 Feb 2023 23:08:19 -0500 (EST) Received: from localhost (localhost [127.0.0.1]) by panix1.panix.com (Postfix) with ESMTP id 4PBRLW4XYSzcbV; Tue, 7 Feb 2023 23:08:19 -0500 (EST) Date: Tue, 7 Feb 2023 23:08:19 -0500 From: Jude DaShiell To: TRS-80 , emacs-orgmode@gnu.org Subject: Re: netspend table In-Reply-To: <87zg9ohluj.fsf@isnotmyreal.name> Message-ID: References: <87zg9ohluj.fsf@isnotmyreal.name> MIME-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Received-SPF: pass client-ip=166.84.1.89; envelope-from=jdashiel@panix.com; helo=mailbackend.panix.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_MSPIKE_H3=0.001, RCVD_IN_MSPIKE_WL=0.001, SPF_HELO_NONE=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: , 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=fail ("headers rsa verify failed") header.d=panix.com header.s=panix header.b=QzKUylds; 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=fail reason="SPF not aligned (relaxed)" header.from=panix.com (policy=none) ARC-Seal: i=1; s=key1; d=yhetil.org; t=1675829362; a=rsa-sha256; cv=none; b=rtkyLN8ZeRn6U0gZIduw47diuR77FhPiG5jGZZ0Q/BcFs3RvMujf14+OSKjUSOK1A8VJ/1 ArpQHTKyN57Xeu4r/NaEfrqLaRSuwxoS3izfgDb8cEyO4OuB3KgE2KN3rfTheZ68YYNX8P /WgS/+EQ5iL6tXvRfTFm/4in8HeraGJ2IXF1VV5XsuUxseEiY6G9DlP/14Jwuh7cN3cCAr FhuE8xltmYiikRNF7pBiutBjY/39GcRMZLaNiqGeAj8YLKDzAR+IJogBcHTIXv5YOtI+9a 5jsXlC9FX55ulxzrzURJwz5qepOSdLU2hsixyN5gtdG20SHPsRvBuIkgWVZOBg== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=yhetil.org; s=key1; t=1675829362; 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=cUNXXqWtEHe7C80GIj+8xdVilcNkGsnFpfi8hZFpRIM=; b=QMsDNVFWTQP0oU/K6ipogjR4LgtgmQMx86vtApEujPLDkw9gYc5vRyXLnraZxKwGiuQMHr RtMRsC+p+ARH85dnMKm1e8QTqmS2U6cebehNQ7lVS6OufhRm34YDESCaz6ZNOw2TUdT3zR IafqJAIwz+ZiKBVtUnALGbZTIwNHHoJizUJFHgVxcFcCWlNxg+CiYO29STr7hJ93dOmSYf +z7PDM0za6PqikaLiIuqdR61pvMhjLKsY3NJSAYQOnwwMV4kN6CGTRKWCwwD3zkioTQHVT kLT/y9MtuARztUfbAbwIS9FvExRi5tPvMsaVDxhj2VAeeD2Ibj+t7bOUL9HGUA== X-Migadu-Spam-Score: -0.29 X-Spam-Score: -0.29 X-Migadu-Queue-Id: 547A921AC1 X-Migadu-Scanner: scn1.migadu.com Authentication-Results: aspmx1.migadu.com; dkim=fail ("headers rsa verify failed") header.d=panix.com header.s=panix header.b=QzKUylds; 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=fail reason="SPF not aligned (relaxed)" header.from=panix.com (policy=none) X-TUID: AZ1pJTjPHu/g I added that check column to the table and like that feature. That shows you the previous balance so errors can be caught humans make not orgmode. My walmart order got cancelled by walmart so I deleted that row and put an entry in for amazon to buy the razor WalMart couldn't ship. The $1.00 transaction fees only happen on withdrawls not deposits with netspend. Fortunately this isn't the official record but something I track so I have an idea what's on the card at any time and don't overspend. I think if I had known about orgmode when studying adjusted trial balance sheets I would have used it since braille paper has a maximum of 42 characters in a line. Ways exist to get around that so long as every column will be 42 characters or less, but they're not being used by any of the braille producers Jude "There are four boxes to be used in defense of liberty: soap, ballot, jury, and ammo. Please use in that order." -Ed Howdershelt (Author, 1940) . On Tue, 7 Feb 2023, TRS-80 wrote: > 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. > >