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 ms0.migadu.com with LMTPS id IK+qHMq75GF2KQAAgWs5BA (envelope-from ) for ; Mon, 17 Jan 2022 01:43:54 +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 yALpGcq75GEebQAA9RJhRA (envelope-from ) for ; Mon, 17 Jan 2022 01:43:54 +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 EED982312C for ; Mon, 17 Jan 2022 01:43:53 +0100 (CET) Received: from localhost ([::1]:48436 helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1n9G7l-000864-4o for larch@yhetil.org; Sun, 16 Jan 2022 19:43:53 -0500 Received: from eggs.gnu.org ([209.51.188.92]:46918) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1n9G5V-00085v-Ts for emacs-orgmode@gnu.org; Sun, 16 Jan 2022 19:41:33 -0500 Received: from [2607:f8b0:4864:20::92b] (port=41951 helo=mail-ua1-x92b.google.com) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.90_1) (envelope-from ) id 1n9G5T-0008OO-AD for emacs-orgmode@gnu.org; Sun, 16 Jan 2022 19:41:33 -0500 Received: by mail-ua1-x92b.google.com with SMTP id i10so5640727uab.8 for ; Sun, 16 Jan 2022 16:41:30 -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=XiVHm0oWqc7FLa77sSaR+htvkvqjyZEAz+Kqx8/8NvY=; b=L/Q9s2l+jAkojqpvAhw6cGjnQXZ67X+MLUrVlRlrEv/1s2gsJ5CZDHEIEtR+sqJrd+ /f7v5hVgAUMj30UglJwZT0X6RP7fNrxBS+61You0NU4e7U0M7U2IjrnpyVUVr/EOjkfA vjkCpEWeqggiFKR7ROZWUOJwRmKH761QDhcmK+hsnXE1WA1lzVgJPMgIxhj5H/bGZGUE QYuBt4feCbDE0QYVLLyN2Xtu2LZJKzqsNtsT7BhKI94H0o08hqs0GGz4bNvq3Jm+yUzJ qLt0z6EPrlKZnxs1S/kEC37STI3oShpSx2O431KPxOPJVwvMnyuWEB68nihkKmiUTDKP FHEg== 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=XiVHm0oWqc7FLa77sSaR+htvkvqjyZEAz+Kqx8/8NvY=; b=ueAr3dvpQq//SJCdXJa3isD+IHS7HZX1N/R1VvpGDO2cnboVe+5g7UHOlqo5pl0qBi I1hI8IEXYoQa2WlOIR+YNcFbLYDvPQxj9PuW++Ab2brOuNr5LJrkDYm55pCYnyL8q5B/ eUm5eDcVbTX7O2ofurhC2C/N4jUe4UnynyZC+ONOvkBKR8dC3t0IcauGO/UsLVD2kYaa Wlf6V9t8NOHWyXP/GQWBO3H7+KsoG7WYdUXmaycx3eAi0hoMyh47WlUjOhQAIRzlduPA 2Bybz0Apu/tAHoabXLH4FJqaWSQ0m7eqkABbn8Oy1sAPwf6knUDahJQcNIt3iJZmUQz0 VbGg== X-Gm-Message-State: AOAM533mxG+9Eta3qXmAko9SIaB84QjMlBhh7HhQFFgFz6aw+zGZE8aE UJ0u4d4EBS3hxASwsmbG7WHmrCyzvJxCQAVPV3c= X-Google-Smtp-Source: ABdhPJy4kADxkXKq+o554zUp4LsIoxUjwJF0IGqIZw3L/QBNFxHjwfszgoXJ/1BQBsNOG6JBzZ12rmjvb9QaooWidLU= X-Received: by 2002:a67:e3a7:: with SMTP id j7mr7054758vsm.81.1642380089405; Sun, 16 Jan 2022 16:41:29 -0800 (PST) MIME-Version: 1.0 References: <137562d1-e6fe-4a68-b18b-abedef513fbd@www.fastmail.com> <5f6b2337d0d5ca303c054febba4ff8c3@riseup.net> <17ff6003-cbaf-409a-a625-10cbfcc75eab@www.fastmail.com> In-Reply-To: <17ff6003-cbaf-409a-a625-10cbfcc75eab@www.fastmail.com> From: John Hendy Date: Sun, 16 Jan 2022 18:41:18 -0600 Message-ID: Subject: Re: Question Regarding Creating Workflow For Automatic Formulas For Finance Based Org Spreadsheet To: Samuel Banya Content-Type: multipart/mixed; boundary="000000000000d1330505d5bc69e8" X-Host-Lookup-Failed: Reverse DNS lookup failed for 2607:f8b0:4864:20::92b (failed) Received-SPF: pass client-ip=2607:f8b0:4864:20::92b; envelope-from=jw.hendy@gmail.com; helo=mail-ua1-x92b.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, HTML_MESSAGE=0.001, PDS_HP_HELO_NORDNS=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: Charles Berry 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=1642380234; 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=0OSyCxKXZZeCgAQ4vKKUFgzkLvFpH47rLd2Db7h58v8=; b=KxrsQOHgRKvVT2l5gu1jTV3RDrqYSko8QtBeNCz6sGwMEGUqk7naE0FEkJjP/cBWEtz2JF HHqLSAaVIBBc9iHjNR/lWK2NCEr6lIQ5vAxXg4BQknIAZsrZ4s4mbdsv2xu+Po+y+ptAsb VGCTbJ6WajCACcqwrsYGW7sLZbq0M6mJP0L9sfjkdLaxLez/uGPewhXu0a3suDYQNccQ3Y eUcUGZ7jd46SJYjPqzE7qqJFsw+YVIcxDx4FSP7voQkqmpXFBltq5qygZ86dKj7o3FPC0T ZycAWJmOIMCzhnwL0LtQrQ5p+t8Vcb/xV0o96/2RReNd4oGqxsSoMlPX+S2+pg== ARC-Seal: i=1; s=key1; d=yhetil.org; t=1642380234; a=rsa-sha256; cv=none; b=WNoksoZUFbPKNagMVmlmI8Zdhoi+KziRJq0+06/vHfPye9/0NIwJWV3dU/xbYJvxzXYKgH dB282mvT0qR6RLXZgs8V2Cm6orMxunkESwoBfIH9KK0pw2TngKjtoTJ5o0XzT5StQ4FUGS NRYot1kxHmdmpqgNn/mAbNGb6zCZXSTKFPfnbnYub41fgQgXP9xg/daloMrnA5DTZPId0d cn+PdieO+dIrNBi07cekV9CjDvBBQens0dhZ1BMORAZ1+iYwNtCQIIYKwKMq3+5fqUNB6S DwLS3CO8inx+cu5c+oumLzrtkLzLsU6dwVgvC6i+ADSI+1vnG79BCg0vjFcOmw== ARC-Authentication-Results: i=1; aspmx1.migadu.com; dkim=fail ("body hash did not verify") header.d=gmail.com header.s=20210112 header.b="L/Q9s2l+"; 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: -0.92 Authentication-Results: aspmx1.migadu.com; dkim=fail ("body hash did not verify") header.d=gmail.com header.s=20210112 header.b="L/Q9s2l+"; 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: EED982312C X-Spam-Score: -0.92 X-Migadu-Scanner: scn1.migadu.com X-TUID: p2A63WvSum8Z --000000000000d1330505d5bc69e8 Content-Type: multipart/alternative; boundary="000000000000d1330305d5bc69e6" --000000000000d1330305d5bc69e6 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Sun, Jan 16, 2022 at 9:20 AM Samuel Banya 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 m= e. > > 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=C3=B3=C3=B1ez wrote: > > El 2022-01-09 22:42, Samuel Banya escribi=C3=B3: > > 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! :-) > > > > > --000000000000d1330305d5bc69e6 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable


=
On Sun, Jan 16, 2022 at 9:20 AM Samue= l Banya <sbanya@fastmail.com&= gt; 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
<= /div>
right there happily? I alluded to this with respect to the reques= t to
automate csv -> org; without knowing which things mus= t be org and why,
it's hard to comment on these kinds of = inquiries. Maybe org is just
more fun, maybe it's mandato= ry 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 provi= de me with an example of this?

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

Routine each month:
- open month's bank d= ownload
- copy all but the header (easy to do with ctrl+shift+arr= ow to get to bottom row)
- ctrl+arrow to get to last row in runni= ng_totals.csv
- update the month's formula with sum(first_row= _of_this_month:last_row_of_this_month)
- you could=C2=A0 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 numb= er of columns.

This is basically doing what yo= u're doing in org, but in a csv (or use a regular ods or xlsx if you ne= ed 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 Ledg= er, but I really just don't like the double posting idea period.

I just need totals spreadsheet style, that's abo= ut it. I think the whole idea behind bean count is tedious.
<= br>
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
<= /div>

On Fri, Jan 14, 2022, at 2:54 PM, Quiliro Or= d=C3=B3=C3=B1ez wrote:
El 2022-01-09 22:42, Samuel Banya escribi=C3=B3:=
> Ah, Ledger is way too complicated for what it's wor= th. I've seen
> videos on YouTube about it, and every = person who's praised it is
> pretty much too smart eno= ugh to be able to explain it in simple terms.

= It is very easy.=C2=A0 I made a video for EmacsConf 2019
https://emac= sconf.org/2019/talks/12/ .=C2=A0=C2=A0 I wish someone had showed me
=
examples like these when I started with it.=C2=A0=C2=A0

My fiancee is a preschool teacher (programming is not = her area of
expertize).=C2=A0 But she quickly learned how to = use it.=C2=A0 She keeps about
3700 per year with 4500 lines.= =C2=A0 It takes her about 10 minutes per day.=C2=A0
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).=C2=A0 On these t= wo
years, she has saved us about half our budget and has us l= iving much
better thanks to the knowledge of what we want to = invest on.=C2=A0 (We now do
not think of how to spend money, = but how to invest it.=C2=A0 That changes the
point view compl= etely.)
=C2=A0=C2=A0
There are complicated repo= rts as well as very simple ones that can be
generated.=C2=A0 = And you can always customize them to the last bit.=C2=A0 There is
=
also a website=C2=A0http://plaintextaccounting.org .=C2=A0 There is plenty of
information there.=C2=A0 You can also use org-babel to include= formulas for
Ledger reports.

Ju= st ask away!=C2=A0 :-)


=


--000000000000d1330305d5bc69e6-- --000000000000d1330505d5bc69e8 Content-Type: text/csv; charset="US-ASCII"; name="running_total.csv" Content-Disposition: attachment; filename="running_total.csv" Content-Transfer-Encoding: base64 Content-ID: X-Attachment-Id: f_kyhymhcy2 ImRhdGUiLCJ2YWx1ZSIsLCwsCiJqYW4iLDEsLCwiamFuIiw2CiJqYW4iLDIsLCwiZmViIiwzMAoi amFuIiwzLCwsIm1hciIsCiJmZWIiLDQsLCwiYXJwIiwKImZlYiIsNSwsLCJtYXkiLAoiZmViIiw2 LCwsImp1biIsCiJmZWIiLDcsLCwianVsIiwKImZlYiIsOCwsLCJhdWciLAosLCwsInNlcCIsCiws LCwib2N0IiwKLCwsLCJub3YiLAosLCwsImRlYyIsCiwsLCwidG90YWwiLDM2Cg== --000000000000d1330505d5bc69e8 Content-Type: text/csv; charset="US-ASCII"; name="jan.csv" Content-Disposition: attachment; filename="jan.csv" Content-Transfer-Encoding: base64 Content-ID: X-Attachment-Id: f_kyhymhcx1 ImRhdGUiLCJ2YWx1ZSIKImphbiIsMQoiamFuIiwyCiJqYW4iLDMK --000000000000d1330505d5bc69e8 Content-Type: text/csv; charset="US-ASCII"; name="feb.csv" Content-Disposition: attachment; filename="feb.csv" Content-Transfer-Encoding: base64 Content-ID: X-Attachment-Id: f_kyhymhcr0 ImRhdGUiLCJ2YWx1ZSIKImZlYiIsNAoiZmViIiw1CiJmZWIiLDYKImZlYiIsNwoiZmViIiw4Cg== --000000000000d1330505d5bc69e8--