Re: Question Regarding Creating Workflow For Automatic Formulas For Finance Based Org Spreadsheet

2022-01-19 Thread Neil Jerram
On Mon, 10 Jan 2022 at 10:31, Neil Jerram wrote: > > On Mon, 10 Jan 2022 at 03:42, Samuel Banya wrote: > > > > 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

Re: Question Regarding Creating Workflow For Automatic Formulas For Finance Based Org Spreadsheet

2022-01-16 Thread John Hendy
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

Re: Question Regarding Creating Workflow For Automatic Formulas For Finance Based Org Spreadsheet

2022-01-16 Thread Eric S Fraga
On Sunday, 16 Jan 2022 at 10:35, Samuel Banya wrote: > How would you able to keep the running totals in Column E? Using your initial example, adding a header line to give a starting point, the following works: | Date | Item| |Debit | |

Re: Question Regarding Creating Workflow For Automatic Formulas For Finance Based Org Spreadsheet

2022-01-16 Thread Samuel Banya
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 indefinitely, so thanks for the ideas in this thread as my workflow is definitely improved for my finance spreadsheet. Cool stuff, will include his quote

Re: Question Regarding Creating Workflow For Automatic Formulas For Finance Based Org Spreadsheet

2022-01-16 Thread Samuel Banya
> 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 >

Re: Question Regarding Creating Workflow For Automatic Formulas For Finance Based Org Spreadsheet

2022-01-16 Thread Samuel Banya
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.

Re: Question Regarding Creating Workflow For Automatic Formulas For Finance Based Org Spreadsheet

2022-01-14 Thread Quiliro Ordóñez
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

Re: Question Regarding Creating Workflow For Automatic Formulas For Finance Based Org Spreadsheet

2022-01-10 Thread Samuel Banya
Very true, my config would scare the average Emacs user as its too complex :) On Mon, Jan 10, 2022, at 7:41 PM, John Hendy wrote: > On Mon, Jan 10, 2022 at 6:32 PM Samuel Banya wrote: > > > > The double reporting thing still doesn't apply to me. > > > > Even if you pay with credit cards,

Re: Question Regarding Creating Workflow For Automatic Formulas For Finance Based Org Spreadsheet

2022-01-10 Thread John Hendy
On Mon, Jan 10, 2022 at 6:32 PM Samuel Banya wrote: > > The double reporting thing still doesn't apply to me. > > Even if you pay with credit cards, ultimately it comes out of your regular > bank account to pay off. > > To me, its easier to just focus on the single bank account, and obtain the

Re: Question Regarding Creating Workflow For Automatic Formulas For Finance Based Org Spreadsheet

2022-01-10 Thread Samuel Banya
The double reporting thing still doesn't apply to me. Even if you pay with credit cards, ultimately it comes out of your regular bank account to pay off. To me, its easier to just focus on the single bank account, and obtain the latest .csv from the current week (Last Saturday to current

Re: Question Regarding Creating Workflow For Automatic Formulas For Finance Based Org Spreadsheet

2022-01-10 Thread Samuel Wales
fwiw, my experience: double entry is what i found ledger useful for. iiuc it is that transactions go from one place to another, which felt intuitive to me. anything else, such as taking monthly averages, didn't end up as i expected. weird concept of average to me, and v3 bugs with floating point

Re: Question Regarding Creating Workflow For Automatic Formulas For Finance Based Org Spreadsheet

2022-01-10 Thread Marcin Borkowski
On 2022-01-10, at 18:01, Samuel Banya wrote: > The 'double reporting' idea might have been why I just flat out shook my head > when I saw the one presentation on 'ledger' in Emacs on YouTube a while ago > as its a bit too complicated and unnecessary for a layman. > > I just don't need that

Re: Question Regarding Creating Workflow For Automatic Formulas For Finance Based Org Spreadsheet

2022-01-10 Thread John Hendy
On Mon, Jan 10, 2022 at 11:09 AM Samuel Banya wrote: > > The 'double reporting' idea might have been why I just flat out shook my head > when I saw the one presentation on 'ledger' in Emacs on YouTube a while ago > as its a bit too complicated and unnecessary for a layman. Fair, it's a bit to

Re: Question Regarding Creating Workflow For Automatic Formulas For Finance Based Org Spreadsheet

2022-01-10 Thread Bob Newell
Aloha everyone, I used ledger in emacs (with babel) for many years managing the finances of two small non-profits. It did require learning a few things but so does org-mode. That's not to say that one size fits all, but ledger for me took a lot of the work out of things, and once you learn how

Re: Question Regarding Creating Workflow For Automatic Formulas For Finance Based Org Spreadsheet

2022-01-10 Thread Samuel Banya
The 'double reporting' idea might have been why I just flat out shook my head when I saw the one presentation on 'ledger' in Emacs on YouTube a while ago as its a bit too complicated and unnecessary for a layman. I just don't need that kind of over-thinking when it comes to my finances since I

Re: Question Regarding Creating Workflow For Automatic Formulas For Finance Based Org Spreadsheet

2022-01-10 Thread Greg Minshall
> I'm wondering if your opinion about Ledger isn't influenced by the fact > that it uses basic accounting principles, like the idea of double-entry > accounting. For me, it's /very/ simple and intuitive, but I graduated > in economics many years ago and had a (basic, but still) course on >

Re: Question Regarding Creating Workflow For Automatic Formulas For Finance Based Org Spreadsheet

2022-01-10 Thread Eric S Fraga
I would suggest the following: |+-+---+--| | 01/03/2022 | Example Rent Expense| | -1061.67 | | 01/04/2022 | Example Food Expense| | -1061.67 |

Re: Question Regarding Creating Workflow For Automatic Formulas For Finance Based Org Spreadsheet

2022-01-10 Thread Neil Jerram
On Mon, 10 Jan 2022 at 03:42, Samuel Banya wrote: > > 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. I have similar observations. I

Re: Question Regarding Creating Workflow For Automatic Formulas For Finance Based Org Spreadsheet

2022-01-09 Thread Detlef Steuer
Am Mon, 10 Jan 2022 08:04:20 +0100 schrieb Marcin Borkowski : > On 2022-01-10, at 04:42, Samuel Banya wrote: > > > 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

Re: Question Regarding Creating Workflow For Automatic Formulas For Finance Based Org Spreadsheet

2022-01-09 Thread Marcin Borkowski
On 2022-01-10, at 04:42, Samuel Banya wrote: > 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. Interesting - I've been using Ledger

Re: Question Regarding Creating Workflow For Automatic Formulas For Finance Based Org Spreadsheet

2022-01-09 Thread Samuel Banya
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. I don't like how manual and frequent it is, and for my use case, I just download .csvs from

Re: Question Regarding Creating Workflow For Automatic Formulas For Finance Based Org Spreadsheet

2022-01-09 Thread Neil Jerram
On Sun, 9 Jan 2022, 17:18 Samuel Banya, wrote: > Hey there, > > So I've been managing my finances via an org doc that basically has tables > that list all the expenses from my bank account, which has been awesome on > some respects. > I also save and process my bank account transactions with

Re: Question Regarding Creating Workflow For Automatic Formulas For Finance Based Org Spreadsheet

2022-01-09 Thread John Hendy
On Sun, Jan 9, 2022 at 11:17 AM Samuel Banya wrote: > > Hey there, > [...] > After Reading The Online Manual, I Figured This Out: > > I tried using the 'org-table-edit-formulas' function via the "C-c ' (single > quote)" (Obtained this formula via the docs, >

Re: Question Regarding Creating Workflow For Automatic Formulas For Finance Based Org Spreadsheet

2022-01-09 Thread Ken Mankoff
Hi Sam, Have you looked into Org Ledger? -k. Please excuse brevity. Sent from tiny pocket computer with non-haptic feedback keyboard. On Sun, Jan 9, 2022, 09:18 Samuel Banya wrote: > Hey there, > > So I've been managing my finances via an org doc that basically has tables > that list all

Question Regarding Creating Workflow For Automatic Formulas For Finance Based Org Spreadsheet

2022-01-09 Thread Samuel Banya
Hey there, So I've been managing my finances via an org doc that basically has tables that list all the expenses from my bank account, which has been awesome on some respects. The only annoying thing I want to somehow figure out this year is how to make the process of updating the formula for