From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: from mp11.migadu.com ([2001:41d0:2:bcc0::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by ms0.migadu.com with LMTPS id f2F/J+w75GEdjgAAgWs5BA (envelope-from ) for ; Sun, 16 Jan 2022 16:38:20 +0100 Received: from aspmx1.migadu.com ([2001:41d0:2:bcc0::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by mp11.migadu.com with LMTPS id 0C/II+w75GGfowAA9RJhRA (envelope-from ) for ; Sun, 16 Jan 2022 16:38:20 +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 0DB0532EAB for ; Sun, 16 Jan 2022 16:38:20 +0100 (CET) Received: from localhost ([::1]:40410 helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1n97bm-0006xH-Uo for larch@yhetil.org; Sun, 16 Jan 2022 10:38:18 -0500 Received: from eggs.gnu.org ([209.51.188.92]:44126) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1n97ZZ-0005Ct-AC for emacs-orgmode@gnu.org; Sun, 16 Jan 2022 10:36:01 -0500 Received: from out3-smtp.messagingengine.com ([66.111.4.27]:45243) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1n97ZR-0004C8-D2 for emacs-orgmode@gnu.org; Sun, 16 Jan 2022 10:36:00 -0500 Received: from compute2.internal (compute2.nyi.internal [10.202.2.46]) by mailout.nyi.internal (Postfix) with ESMTP id 239565C009B for ; Sun, 16 Jan 2022 10:35:41 -0500 (EST) Received: from imap49 ([10.202.2.99]) by compute2.internal (MEProxy); Sun, 16 Jan 2022 10:35:41 -0500 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=fastmail.com; h= mime-version:message-id:in-reply-to:references:date:from:to :subject:content-type; s=fm1; bh=9gMbjdlbUze63OovuccHjiD1m2cyH2c GcVgpr3Vl0R8=; b=UKyjgMmZSiJbZ5AshdFkIWiweHtW+bNRoWMO/6y3LSQIHhH 3UVrzrtELtKLHlI6j+tCENC9xkKLgdq4ebprdMRSFtnEFNk8KOQNsyRLaArEZqZ9 /Z6gNuDFQpBB4XTU5TCuXD6uDwPdBrpBJ11hHeE5ljDhxerXQkkhXqAmjSnC7oiX rPa6AETQYLAy16iLLZ8KsputY/MxFtmmtMJpOG0n7SKzGXKmTZdseKq3Lb7q+BJn ahjoy/QvIBqW3zZ+8RVmjpx0963LlggdSYAFpCZSyul2AMzp6f0OTDBr2nmHXxrd GypLmB50lfGmtn/TPQ1k1LlzhPbPbo6OdZC/xgw== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=content-type:date:from:in-reply-to :message-id:mime-version:references:subject:to:x-me-proxy :x-me-proxy:x-me-sender:x-me-sender:x-sasl-enc; s=fm1; bh=9gMbjd lbUze63OovuccHjiD1m2cyH2cGcVgpr3Vl0R8=; b=W5FX+iPF5VaDVcUmcF6Vvg heOVj4p09bFc/uPEai4dP23RidKTYk1PP8mzEmk4W95bQW7XB0Z9zWSvinTv7plw alDJr7QNYss/oT/AYBOk0+mEg+PtNbW0ERXIdWqLT4AZosO9DiJ3CY3r3lMKPZ3i No04/FJ/7UyVwB7+LPyut2S96erOmiWFSi0tKtjZdsPv0h97YJKamDoTYPKO/4ZM M9hObXyUuxdDaPzNZiF1dVAJych88cZacPEjMYSD9qxa3gkK2vLSHnEv8UPHwvO6 yfN7tSGLqfsIm9jVD+G4sLOdmwEfewHRV5M5Ov1R20wf/zKwYhHI0JbmxjFF4hKQ == X-ME-Sender: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedvvddrtdelgdejkecutefuodetggdotefrodftvf curfhrohhfihhlvgemucfhrghsthforghilhdpqfgfvfdpuffrtefokffrpgfnqfghnecu uegrihhlohhuthemuceftddtnecunecujfgurhepofgfggfkjghffffhvffutgesrgdtre erreerjeenucfhrhhomhepfdfurghmuhgvlhcuuegrnhihrgdfuceoshgsrghnhigrsehf rghsthhmrghilhdrtghomheqnecuggftrfgrthhtvghrnhepleeiudffledutddtheeuvd efheegveejkeejgfdugfdufefhudeuhfffffevjedvnecuffhomhgrihhnpegvmhgrtghs tghonhhfrdhorhhgpdhplhgrihhnthgvgihtrggttghouhhnthhinhhgrdhorhhgnecuve hluhhsthgvrhfuihiivgeptdenucfrrghrrghmpehmrghilhhfrhhomhepshgsrghnhigr sehfrghsthhmrghilhdrtghomh X-ME-Proxy: Received: by mailuser.nyi.internal (Postfix, from userid 501) id EB514F60080; Sun, 16 Jan 2022 10:35:40 -0500 (EST) X-Mailer: MessagingEngine.com Webmail Interface User-Agent: Cyrus-JMAP/3.5.0-alpha0-4569-g891f756243-fm-20220111.001-g891f7562 Mime-Version: 1.0 Message-Id: In-Reply-To: <17ff6003-cbaf-409a-a625-10cbfcc75eab@www.fastmail.com> References: <137562d1-e6fe-4a68-b18b-abedef513fbd@www.fastmail.com> <5f6b2337d0d5ca303c054febba4ff8c3@riseup.net> <17ff6003-cbaf-409a-a625-10cbfcc75eab@www.fastmail.com> Date: Sun, 16 Jan 2022 10:35:20 -0500 From: "Samuel Banya" To: "Charles Berry" Subject: Re: Question Regarding Creating Workflow For Automatic Formulas For Finance Based Org Spreadsheet Content-Type: multipart/alternative; boundary=b5a6b0419e6e4dd1ae9049e98c06d558 Received-SPF: pass client-ip=66.111.4.27; envelope-from=sbanya@fastmail.com; helo=out3-smtp.messagingengine.com X-Spam_score_int: -27 X-Spam_score: -2.8 X-Spam_bar: -- X-Spam_report: (-2.8 / 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, RCVD_IN_DNSWL_LOW=-0.7, RCVD_IN_MSPIKE_H3=-0.01, RCVD_IN_MSPIKE_WL=-0.01, SPF_HELO_PASS=-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" 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=1642347500; 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=9gMbjdlbUze63OovuccHjiD1m2cyH2cGcVgpr3Vl0R8=; b=mwlURYgDwd53DGaH2vAOY14EECGuVN6gfnZ6oR6JIsxlygI55DCs2eKLAKrmBpm47KGGAr PPpVaChVUfNu6yaVcOet4V8SrX23EAbSfgAOJrNpRaY3jCvsBTjC8VxDU6CCZY3lmcGFzO kyRH+QZSRCkLap3KKF1klgVfEd8CPDs88Bh0DJq7GMNEjnqEmytqD7FMWfUle4Qo9y+LG1 FFNZPfAjVAWLT+mCmb6unx9CCmGwOLSrsZJizhJwqmaOInhBWdJ5mpUe8ullzFANJHX4of ljcPU6y+uAyLHFLR6Dotxy36C66PwC+188HdBDP1S+5FYb5MYjYofxu81LQEHQ== ARC-Seal: i=1; s=key1; d=yhetil.org; t=1642347500; a=rsa-sha256; cv=none; b=IMJamcdk5kus6bqH3t57GG6OMUFvH/vQ8acsCKL850aEgeKcG5qgu88s2Dz+nS6OUip/TA YH3xSbxerU8uTEZY5b8tVq0UUxMhHdLpt76CePocVKLTDpZVBciX7t6k3j0DbwiBhnEeOO lUIcfhO4rIwTXPacQf0kNYfMrZLK57BRESL4oqRlQ8ID2rlI9DXmkG6W1a3qoFqASkmoLP Zj2XJz/wzchtstgX+t9+84hZkNxKdj0u2Y3RiHI/jYAGna9w4dZE+RcBdqnEvG7xl+getC NFfZ3ahrvG3/ELPKx3EgMfDW+1AEIx0hbVfYmv9sbxhgs7/l1eIgqjTBSwPEgg== ARC-Authentication-Results: i=1; aspmx1.migadu.com; dkim=pass header.d=fastmail.com header.s=fm1 header.b=UKyjgMmZ; dkim=pass header.d=messagingengine.com header.s=fm1 header.b=W5FX+iPF; dmarc=pass (policy=none) header.from=fastmail.com; 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: -4.41 Authentication-Results: aspmx1.migadu.com; dkim=pass header.d=fastmail.com header.s=fm1 header.b=UKyjgMmZ; dkim=pass header.d=messagingengine.com header.s=fm1 header.b=W5FX+iPF; dmarc=pass (policy=none) header.from=fastmail.com; 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: 0DB0532EAB X-Spam-Score: -4.41 X-Migadu-Scanner: scn1.migadu.com X-TUID: 1weaRli0+faA --b5a6b0419e6e4dd1ae9049e98c06d558 Content-Type: text/plain;charset=utf-8 Content-Transfer-Encoding: quoted-printable Actually, to end this thread, I actually used Eric Fraga's idea to just = use separate sections for each month, since this solves this problem ind= efinitely, so thanks for the ideas in this thread as my workflow is defi= nitely improved for my finance spreadsheet. Cool stuff, will include his quote to wrap it up: > I would suggest the following: >=20 > |------------+-----------------------------------------------------+--= -+----------| > | 01/03/2022 | Example Rent Expense | = | -1061.67 | > | 01/04/2022 | Example Food Expense | = | -1061.67 | > |------------+-----------------------------------------------------+--= -+----------| > | | January expenses | 0= | -2123.34 | > |------------+-----------------------------------------------------+--= -+----------| > | 02/05/2022 | Example Utility Expense | = | -2061.67 | > | 02/06/2022 | Example Random Expense | = | -2061.67 | > |------------+-----------------------------------------------------+--= -+----------| > | | February expenses | 0= | -4123.34 | > |------------+-----------------------------------------------------+--= -+----------| > #+TBLFM: @3$3=3Dvsum(@-I..@-II)::@3$4=3Dvsum(@-I..@-II)::@6$3=3Dvsum(@= -I..@-II)::@6$4=3Dvsum(@-I..@-II) On Sun, Jan 16, 2022, at 10:19 AM, Samuel Banya wrote: >=20 >> 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. >=20 > How would you able to keep the running totals in Column E? >=20 > Can you provide me with an example of this? >=20 > On Sun, Jan 16, 2022, at 10:15 AM, Samuel Banya wrote: >> Hello, >>=20 >> I appreciate the enthusiasm for Ledger, but I really just don't like = the double posting idea period. >>=20 >> I just need totals spreadsheet style, that's about it. I think the wh= ole idea behind bean count is tedious. >>=20 >> I just don't think like a mathematician in this respect, too brainy f= or me. >>=20 >> I'll take a look at the Org Mode way to solve this problem via the pr= evious posts, thanks. >>=20 >> Sincerely, >>=20 >> Sam >>=20 >> 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 te= rms. >>>=20 >>> 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. =20 >>>=20 >>> 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 da= y.=20 >>> With that investment, she can even tell how much we have spent on ap= ples >>> 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 no= w do >>> not think of how to spend money, but how to invest it. That changes= the >>> point view completely.) >>> =20 >>> There are complicated reports as well as very simple ones that can be >>> generated. And you can always customize them to the last bit. Ther= e is >>> also a website http://plaintextaccounting.org . There is plenty of >>> information there. You can also use org-babel to include formulas f= or >>> Ledger reports. >>>=20 >>> Just ask away! :-) >>>=20 >>>=20 >>=20 >=20 --b5a6b0419e6e4dd1ae9049e98c06d558 Content-Type: text/html;charset=utf-8 Content-Transfer-Encoding: quoted-printable
Actually, = to end this thread, I actually used Eric Fraga's idea to just use separa= te sections for each month, since this solves this problem indefinitely,= so thanks for the ideas in this thread as my workflow is definitely imp= roved for my finance spreadsheet.

Cool stuf= f, will include his quote to wrap it up:

I would suggest the following:
|------------+----------------------------------------------= -------+---+----------|
| 01/03/2022 | Example Rent Expens= e            = ;            = ;        |   | -1061.67 |
| 01/04/2022 | Example Food Expense    =             =             =     |   | -1061.67 |
|-----------= -+-----------------------------------------------------+---+----------|<= br>
|         &nb= sp;  | January expenses       &n= bsp;           &n= bsp;           &n= bsp;    | 0 | -2123.34 |
|------------+----= -------------------------------------------------+---+----------|
| 02/05/2022 | Example Utility Expense    &n= bsp;           &n= bsp;            |=    | -2061.67 |
| 02/06/2022 | Example Random Ex= pense           &= nbsp;           &= nbsp;      |   | -2061.67 |
=
|------------+-----------------------------------------------------= +---+----------|
|      &nbs= p;     | February expenses    &n= bsp;           &n= bsp;           &n= bsp;      | 0 | -4123.34 |
|-----= -------+-----------------------------------------------------+---+------= ----|
#+TBLFM: @3$3=3Dvsum(@-I..@-II)::@3$4=3Dvsum(@-I..@-= II)::@6$3=3Dvsum(@-I..@-II)::@6$4=3Dvsum(@-I..@-II)

On Sun, Jan 16, 2022, at 10:19 AM, Samuel Banya wr= ote:

In that case, would a running csv whe= re you paste in each month's new
pull work? You could even= keep the totals to the side, so that as you
paste new dat= a 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 inqui= ries. Maybe org is just
more fun, maybe it's mandatory bec= ause there's some other aspect of
this we don't know.
<= /div>

How would you able to keep the run= ning totals in Column E?

Can you provide me= with an example of this?

On Sun, Jan 16, 2= 022, at 10:15 AM, Samuel Banya wrote:
Hello,

I appr= eciate the enthusiasm for Ledger, but I really just don't like the doubl= e posting idea period.

I just need totals s= preadsheet style, that's about it. I think the whole idea behind bean co= unt is tedious.

I just don't think like a m= athematician 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=C3=B3=C3=B1ez wrote:
El 2022-01-09 22= :42, Samuel Banya escribi=C3=B3:
> Ah, Ledger is way to= o complicated for what it's worth. I've seen
> videos o= n YouTube about it, and every person who's praised it is
&= gt; pretty much too smart enough to be able to explain it in simple term= s.

It is very easy.  I made a video fo= r EmacsConf 2019
https://emacsconf.org/2019/talks/12/ .   I wish so= meone had showed me
examples like these when I started wit= h 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
<= div>3700 per year with 4500 lines.  It takes her about 10 minutes p= er 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 h= as saved us about half our budget and has us living much
b= etter thanks to the knowledge of what we want to invest on.  (We no= w 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
als= o a website http://plain= textaccounting.org .  There is plenty of
informat= ion there.  You can also use org-babel to include formulas for
<= /div>
Ledger reports.

Just ask away!&nb= sp; :-)





--b5a6b0419e6e4dd1ae9049e98c06d558--