Re: netspend table

[Jude DaShiell <jdashiel@panix.com>]

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 <jdashiel at panix dot com>
"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 <jdashiel@panix.com> 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.
>
>