emacs-orgmode@gnu.org archives
 help / color / mirror / code / Atom feed
From: John Hendy <jw.hendy@gmail.com>
To: Samuel Banya <sbanya@fastmail.com>
Cc: Charles Berry <emacs-orgmode@gnu.org>
Subject: Re: Question Regarding Creating Workflow For Automatic Formulas For Finance Based Org Spreadsheet
Date: Sun, 16 Jan 2022 18:41:18 -0600	[thread overview]
Message-ID: <CA+M2ft8qe7j22TF-pjugRuOAbbwR88nBuDiBKDfO67OTWouQ4A@mail.gmail.com> (raw)
In-Reply-To: <17ff6003-cbaf-409a-a625-10cbfcc75eab@www.fastmail.com>


[-- Attachment #1.1: Type: text/plain, Size: 3543 bytes --]

On Sun, Jan 16, 2022 at 9:20 AM Samuel Banya <sbanya@fastmail.com> wrote:

>
> 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.
>
>
> How would you able to keep the running totals in Column E?
>
> Can you provide me with an example of this?
>

Sure, attached.
- running csv, named "running_total.csv"
- toy examples of your jan and feb downloads

Routine each month:
- open month's bank download
- copy all but the header (easy to do with ctrl+shift+arrow to get to
bottom row)
- ctrl+arrow to get to last row in running_totals.csv
- update the month's formula with
sum(first_row_of_this_month:last_row_of_this_month)
- you could  even get fancy with an auto-date formula I'm sure

Just keep the total formulas far enough right (I said column E, but it's
arbitrary) to not get pasted over depending on your institution's number of
columns.

This is basically doing what you're doing in org, but in a csv (or use a
regular ods or xlsx if you need the last month's formulas to stay as
formulas, not static values on save/exit).

John



> On Sun, Jan 16, 2022, at 10:15 AM, Samuel Banya wrote:
>
> Hello,
>
> I appreciate the enthusiasm for Ledger, but I really just don't like the
> double posting idea period.
>
> I just need totals spreadsheet style, that's about it. I think the whole
> idea behind bean count is tedious.
>
> I just don't think like a mathematician in this respect, too brainy for me.
>
> I'll take a look at the Org Mode way to solve this problem via the
> previous posts, thanks.
>
> Sincerely,
>
> Sam
>
> On Fri, Jan 14, 2022, at 2:54 PM, Quiliro Ordóñez wrote:
>
> El 2022-01-09 22:42, Samuel Banya escribió:
> > Ah, Ledger is way too complicated for what it's worth. I've seen
> > videos on YouTube about it, and every person who's praised it is
> > pretty much too smart enough to be able to explain it in simple terms.
>
> It is very easy.  I made a video for EmacsConf 2019
> https://emacsconf.org/2019/talks/12/ .   I wish someone had showed me
> examples like these when I started with it.
>
> My fiancee is a preschool teacher (programming is not her area of
> expertize).  But she quickly learned how to use it.  She keeps about
> 3700 per year with 4500 lines.  It takes her about 10 minutes per day.
> With that investment, she can even tell how much we have spent on apples
> or on all fruits (as detailed or general as she wants).  On these two
> years, she has saved us about half our budget and has us living much
> better thanks to the knowledge of what we want to invest on.  (We now do
> not think of how to spend money, but how to invest it.  That changes the
> point view completely.)
>
> There are complicated reports as well as very simple ones that can be
> generated.  And you can always customize them to the last bit.  There is
> also a website http://plaintextaccounting.org .  There is plenty of
> information there.  You can also use org-babel to include formulas for
> Ledger reports.
>
> Just ask away!  :-)
>
>
>
>
>

[-- Attachment #1.2: Type: text/html, Size: 5339 bytes --]

[-- Attachment #2: running_total.csv --]
[-- Type: text/csv, Size: 217 bytes --]

"date","value",,,,
"jan",1,,,"jan",6
"jan",2,,,"feb",30
"jan",3,,,"mar",
"feb",4,,,"arp",
"feb",5,,,"may",
"feb",6,,,"jun",
"feb",7,,,"jul",
"feb",8,,,"aug",
,,,,"sep",
,,,,"oct",
,,,,"nov",
,,,,"dec",
,,,,"total",36

[-- Attachment #3: jan.csv --]
[-- Type: text/csv, Size: 39 bytes --]

"date","value"
"jan",1
"jan",2
"jan",3

[-- Attachment #4: feb.csv --]
[-- Type: text/csv, Size: 55 bytes --]

"date","value"
"feb",4
"feb",5
"feb",6
"feb",7
"feb",8

  parent reply	other threads:[~2022-01-17  0:43 UTC|newest]

Thread overview: 25+ messages / expand[flat|nested]  mbox.gz  Atom feed  top
2022-01-09 16:56 Question Regarding Creating Workflow For Automatic Formulas For Finance Based Org Spreadsheet Samuel Banya
2022-01-09 19:05 ` Ken Mankoff
2022-01-09 19:48 ` John Hendy
2022-01-09 22:37 ` Neil Jerram
2022-01-10  3:42   ` Samuel Banya
2022-01-10  7:04     ` Marcin Borkowski
2022-01-10  7:17       ` Detlef Steuer
2022-01-10 15:31       ` Greg Minshall
2022-01-10 17:01         ` Samuel Banya
2022-01-10 17:23           ` John Hendy
2022-01-10 19:04           ` Marcin Borkowski
2022-01-10 22:44             ` Samuel Wales
2022-01-11  0:30             ` Samuel Banya
2022-01-11  0:41               ` John Hendy
2022-01-11  0:43                 ` Samuel Banya
2022-01-10 10:31     ` Neil Jerram
2022-01-19 15:01       ` Neil Jerram
2022-01-14 19:54     ` Quiliro Ordóñez
2022-01-16 15:15       ` Samuel Banya
2022-01-16 15:19         ` Samuel Banya
2022-01-16 15:35           ` Samuel Banya
2022-01-16 18:10             ` Eric S Fraga
2022-01-17  0:41           ` John Hendy [this message]
2022-01-10 13:35 ` Eric S Fraga
2022-01-10 17:09   ` Bob Newell

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

  Avoid top-posting and favor interleaved quoting:
  https://en.wikipedia.org/wiki/Posting_style#Interleaved_style

  List information: https://www.orgmode.org/

* Reply using the --to, --cc, and --in-reply-to
  switches of git-send-email(1):

  git send-email \
    --in-reply-to=CA+M2ft8qe7j22TF-pjugRuOAbbwR88nBuDiBKDfO67OTWouQ4A@mail.gmail.com \
    --to=jw.hendy@gmail.com \
    --cc=emacs-orgmode@gnu.org \
    --cc=sbanya@fastmail.com \
    /path/to/YOUR_REPLY

  https://kernel.org/pub/software/scm/git/docs/git-send-email.html

* If your mail client supports setting the In-Reply-To header
  via mailto: links, try the mailto: link
Be sure your reply has a Subject: header at the top and a blank line before the message body.
Code repositories for project(s) associated with this public inbox

	https://git.savannah.gnu.org/cgit/emacs/org-mode.git

This is a public inbox, see mirroring instructions
for how to clone and mirror all data and code used for this inbox;
as well as URLs for read-only IMAP folder(s) and NNTP newsgroup(s).