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 ms0.migadu.com with LMTPS id MHqLAbc35GE4cwAAgWs5BA (envelope-from ) for ; Sun, 16 Jan 2022 16:20: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 WHPRNbY35GHYEAEAG6o9tA (envelope-from ) for ; Sun, 16 Jan 2022 16:20:22 +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 694F31A873 for ; Sun, 16 Jan 2022 16:20:22 +0100 (CET) Received: from localhost ([::1]:58112 helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1n97KP-0006yj-LB for larch@yhetil.org; Sun, 16 Jan 2022 10:20:21 -0500 Received: from eggs.gnu.org ([209.51.188.92]:41658) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1n97Jj-0006yZ-Oa for emacs-orgmode@gnu.org; Sun, 16 Jan 2022 10:19:39 -0500 Received: from out3-smtp.messagingengine.com ([66.111.4.27]:35303) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1n97Jh-0000gR-S2 for emacs-orgmode@gnu.org; Sun, 16 Jan 2022 10:19:39 -0500 Received: from compute2.internal (compute2.nyi.internal [10.202.2.46]) by mailout.nyi.internal (Postfix) with ESMTP id 273D85C00AC for ; Sun, 16 Jan 2022 10:19:37 -0500 (EST) Received: from imap49 ([10.202.2.99]) by compute2.internal (MEProxy); Sun, 16 Jan 2022 10:19:37 -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=dIizSeQO5iNDBTDWV8M/uglbNIQvCkf OWyqvyJ9OElw=; b=MSRhmo2iqVlndA4/5h2fKcUc3vSBbwDrYLCt/zUKCw+hEs3 pM3AtefZSlr+L62IoKXhv9LEQxLDXChrXlxoMa3kOuxEtRwTNQGrznCbXyRO6CxW F65Xd/4wPhAtC3Q4P7u9ukbbqFVRjLjuq0v+rVlP+Uv0gflb9r0On0oZ210ZSmgZ ZHYxM3cjhmkpo0+K41zmODapP5dSx0MN+qVv7sUacnGGCD5lrijzTOV5r088KgLU RGUELto6f1d+Vvs+wMAKMDR1EHyrsgnbhZfd3yAYs1K3+DfDwefLhTOvIx7obl0r VCUGc0j6Mc9Yxpb1taHHv+hI95MEU9iLzkkzeSg== 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=dIizSe QO5iNDBTDWV8M/uglbNIQvCkfOWyqvyJ9OElw=; b=QnEJW+qBhs8knzw/EUNnbr iQT3D3CBm69SYaFgGkpOqaOvWohhXkt23bqHfRcJ2R7yitQu3CBQ16oIyE3bIfU6 L4sgwPm6MzsU38NgjtupZTVhsKmKVRdJ9MnVX9twjWLx291X9hsddbBsSIH9r7N9 fj8BxEkSTHCqLxmfJVI/YTdXNAefDjGsBJ5P/S5vOpdEXwP2eoBlSyc5YZXWA5Pk 4wcIHldzs9WKMnJyIS1DX1o75T5CX/pLO2hQefA2EX9DNloBhzDxA04lfIwSRvXN 02wZ8S/4/C17n4IEaQD5IfpD3NGKqTUKboY2TWpsL51rTJNqRylF5s2c8YvLZkpQ == X-ME-Sender: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedvvddrtdelgdejhecutefuodetggdotefrodftvf curfhrohhfihhlvgemucfhrghsthforghilhdpqfgfvfdpuffrtefokffrpgfnqfghnecu uegrihhlohhuthemuceftddtnecunecujfgurhepofgfggfkjghffffhvffutgesrgdtre erreerjeenucfhrhhomhepfdfurghmuhgvlhcuuegrnhihrgdfuceoshgsrghnhigrsehf rghsthhmrghilhdrtghomheqnecuggftrfgrthhtvghrnhepleeiudffledutddtheeuvd efheegveejkeejgfdugfdufefhudeuhfffffevjedvnecuffhomhgrihhnpegvmhgrtghs tghonhhfrdhorhhgpdhplhgrihhnthgvgihtrggttghouhhnthhinhhgrdhorhhgnecuve hluhhsthgvrhfuihiivgeptdenucfrrghrrghmpehmrghilhhfrhhomhepshgsrghnhigr sehfrghsthhmrghilhdrtghomh X-ME-Proxy: Received: by mailuser.nyi.internal (Postfix, from userid 501) id E9B56F60080; Sun, 16 Jan 2022 10:19:36 -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: <17ff6003-cbaf-409a-a625-10cbfcc75eab@www.fastmail.com> In-Reply-To: References: <137562d1-e6fe-4a68-b18b-abedef513fbd@www.fastmail.com> <5f6b2337d0d5ca303c054febba4ff8c3@riseup.net> Date: Sun, 16 Jan 2022 10:19:16 -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=290e26be6c6d497d8b72310add84c1bd 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=1642346422; 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=dIizSeQO5iNDBTDWV8M/uglbNIQvCkfOWyqvyJ9OElw=; b=n//56MukeRlKeXAEhJj9pK0K9G4yiOaxJAVw1nQ5hsjE9zQAJ2alazjF91mq2WXq5HmiYO TghpDdVIjvHdMW53aVybJi95kf9+lyKaldnozb5yK5nvAew7+rt3wUEjBbdj90SChcXlfX NfrTsq0s+uuB8lD147Pu3RpmsJ6MRlvyuKrdhGzISjdz5/y1wHXbUShrcoX4W2/CkC2HkH Nd8zcvpDbLnKH8/hwZz5Fqer8e6EjAjAjNgj5xQpf8dJSnX/IyhyVK+v00PzhXzueTmgHp UbL4zeSM47ZWvmRSZ5k55AZ9K6QwLfLGp5tAIFObDBAXLMRbJihfEPOpW7Mvyw== ARC-Seal: i=1; s=key1; d=yhetil.org; t=1642346422; a=rsa-sha256; cv=none; b=JP9hHz7RLqyQX9SDNZuAWDuUFfO5cnJCmHnBz3EMkdXMkQ6MpF3f+dgboz8NsFZO3pWeu5 BSJ/hdrLxXben1/6lZRoZUyc44YfgQZefT7ItMshcLQJQKcVnpr3EeN8l5WZ4QhTQUWFA0 FoJO5hnlu80vysIaRhK4ZSVGZHwaGw2VC7VNSdsMr67Ldk2R1agEnTP6NNkg0qyGIC8bu5 41zR67AqN6HoT3IqzhTwcPbCnLyDIJ4HngOi7vit9KoGnSOIaK/fzfxBXfsfQgInm1tot/ PGCOneRa3ZkCx92uAqKg9ye/kv1Wj8Ffh/U19IhgoakPqZNDkOBNv3z9wBNvDw== ARC-Authentication-Results: i=1; aspmx1.migadu.com; dkim=pass header.d=fastmail.com header.s=fm1 header.b=MSRhmo2i; dkim=pass header.d=messagingengine.com header.s=fm1 header.b=QnEJW+qB; 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=MSRhmo2i; dkim=pass header.d=messagingengine.com header.s=fm1 header.b=QnEJW+qB; 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: 694F31A873 X-Spam-Score: -4.41 X-Migadu-Scanner: scn1.migadu.com X-TUID: LgFzO9Z8ZLlx --290e26be6c6d497d8b72310add84c1bd Content-Type: text/plain;charset=utf-8 Content-Transfer-Encoding: quoted-printable > 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? 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 t= he double posting idea period. >=20 > I just need totals spreadsheet style, that's about it. I think the who= le idea behind bean count is tedious. >=20 > I just don't think like a mathematician in this respect, too brainy fo= r me. >=20 > I'll take a look at the Org Mode way to solve this problem via the pre= vious 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 ter= ms. >>=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 day= .=20 >> With that investment, she can even tell how much we have spent on app= les >> 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.) >> =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. 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. >>=20 >> Just ask away! :-) >>=20 >>=20 >=20 --290e26be6c6d497d8b72310add84c1bd Content-Type: text/html;charset=utf-8 Content-Transfer-Encoding: quoted-printable

=
In that case, would a running csv where y= ou paste in each month's new
pull work? You could even kee= p 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
righ= t 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 wit= h an example of this?

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

I appreciate th= e enthusiasm for Ledger, but I really just don't like the double posting= idea period.

I just need totals spreadshee= t style, that's about it. I think the whole idea behind bean count is te= dious.

I just don't think like a mathematic= ian in this respect, too brainy for me.

I'l= l 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 complicate= d for what it's worth. I've seen
> videos on YouTube ab= out it, and every person who's praised it is
> pretty m= uch too smart enough to be able to explain it in simple terms.
=

It is very easy.  I made a video for EmacsConf = 2019
http= s://emacsconf.org/2019/talks/12/ .   I wish someone had sh= owed me
examples like these when I started with it. &= nbsp;

My fiancee is a preschool teacher (pr= ogramming is not her area of
expertize).  But she qui= ckly 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.)
 &= nbsp;
There are complicated reports as well as very simple= ones that can be
generated.  And you can always cust= omize them to the last bit.  There is
also a website&= nbsp;http://plaintextaccounti= ng.org .  There is plenty of
information there.&n= bsp; You can also use org-babel to include formulas for
Le= dger reports.

Just ask away!  :-)
<= /div>




--290e26be6c6d497d8b72310add84c1bd--