Re: org-tables with monetary amounts

2020-10-15 Thread Daniele Nicolodi
On 12/10/2020 10:22, Christian Moe wrote: > > Hi, Daniele, > > Good that it's working for you. I'll try to explain the unclear parts. > > Daniele Nicolodi writes: > >> On 24/09/2020 11:17, Christian Moe wrote: >> >>> Now, with the Calc command to simplify units, you can add dollars to >>>

Re: org-tables with monetary amounts

2020-10-14 Thread Christian Moe
Hi, Derek, Very useful, thanks! Yours, Christian Derek Feichtinger writes: > Hi, > > On Mon, Oct 12 2020, Eric S Fraga wrote: > >> On Monday, 12 Oct 2020 at 10:22, Christian Moe wrote: >>> I think I was thinking about adding mode flags for unit computations, >>> like in the imagined example

Re: org-tables with monetary amounts

2020-10-13 Thread Derek Feichtinger
Hi, On Mon, Oct 12 2020, Eric S Fraga wrote: > On Monday, 12 Oct 2020 at 10:22, Christian Moe wrote: >> I think I was thinking about adding mode flags for unit computations, >> like in the imagined example above (`$3=$2+$1;u'), similar to what has >> been done for duration computations. > >

Re: org-tables with monetary amounts

2020-10-12 Thread Eric S Fraga
On Monday, 12 Oct 2020 at 10:22, Christian Moe wrote: > I think I was thinking about adding mode flags for unit computations, > like in the imagined example above (`$3=$2+$1;u'), similar to what has > been done for duration computations. This would be very useful, actually. I use embedded calc

Re: org-tables with monetary amounts

2020-10-12 Thread Christian Moe
Hi, Daniele, Good that it's working for you. I'll try to explain the unclear parts. Daniele Nicolodi writes: > On 24/09/2020 11:17, Christian Moe wrote: > >> Now, with the Calc command to simplify units, you can add dollars to >> euros and get the result in whichever currency comes first in

Re: org-tables with monetary amounts

2020-10-09 Thread Daniele Nicolodi
Hello Christian, thank you for your input. calc support for units indeed covers the basics of working with currencies. I gave it a spin on some notes I have been working on recently. While some things work very nicely, other are a bit ugly. It is a good start and I'll explore this approach more.

Re: org-tables with monetary amounts

2020-09-26 Thread Neil Jerram
On Fri, 25 Sep 2020 at 12:36, Daniele Nicolodi wrote: > On 25/09/2020 11:25, Neil Jerram wrote: > > Aside: Perhaps I'm misunderstanding them, but none of the open source > > tools, including (h)ledger, seem to be of much help here. > > - They focus on data entry and reconciliation, which I don't

Re: org-tables with monetary amounts

2020-09-25 Thread Alan Schmitt
Hello, On 2020-09-25 13:20, Daniele Nicolodi writes: > I use beancoount (another text-based accounting software, very similar > to ledger) for accounting purposes and I am very happy with it. I use > org-mode for planning and management tasks or simply to compare quotes, > things better handled

Re: org-tables with monetary amounts

2020-09-25 Thread Daniele Nicolodi
On 25/09/2020 11:25, Neil Jerram wrote: > Aside: Perhaps I'm misunderstanding them, but none of the open source > tools, including (h)ledger, seem to be of much help here. > - They focus on data entry and reconciliation, which I don't need as I'm > happy to download and use OFX files from my bank.

Re: org-tables with monetary amounts

2020-09-25 Thread Daniele Nicolodi
On 23/09/2020 18:55, Eric S Fraga wrote: > Not answering your question directly but, depending on why and how you > are using org tables for monetary calculations, you may wish to look at > ledger [1]. There is support in org for ledger via babel (ob-ledger.el, > distributed with org). Hello

Re: org-tables with monetary amounts

2020-09-25 Thread Neil Jerram
On Tue, 22 Sep 2020 at 17:05, Daniele Nicolodi wrote: > Hello, > Hi Daniele... > > I often use org-tables to work with monetary amounts. Me too. I use Org mode plus Scheme code to try to analyze my bank statements and compare them against a budget. Org is a convenient form for specifying

Re: org-tables with monetary amounts

2020-09-24 Thread Eric S Fraga
Christian, thank you for this mini-tutorial. Very helpful! Calc is so powerful but also has such a steep learning curve that I don't use it as much as I should. -- : Eric S Fraga via Emacs 28.0.50, Org release_9.4-29-gbc9664

Re: org-tables with monetary amounts

2020-09-24 Thread Christian Moe
Hi, Parsing numbers followed by currencies is sort of supported already through Calc's operations on units. (Calc is the built-in emacs calculator that powers the spreadsheet function of Org tables). I haven't used this or explored it much, but my impression is that it could be made more useful

Re: org-tables with monetary amounts

2020-09-23 Thread Nick Dokos
For fixed precision, you can either use an explicit format as Russell Adams points out, or you can modify (globally or per file) the variable org-calc-default-modes. That's a complicated variable and you only need to change one part of it for this: (plist-put org-calc-default-modes

Re: org-tables with monetary amounts

2020-09-23 Thread Eric S Fraga
Not answering your question directly but, depending on why and how you are using org tables for monetary calculations, you may wish to look at ledger [1]. There is support in org for ledger via babel (ob-ledger.el, distributed with org). HTH, eric Footnotes: [1] https://www.ledger-cli.org/ --

Re: org-tables with monetary amounts

2020-09-23 Thread Russell Adams
I often use this for summing columns. | Column | Column | |+| | a |1.2 | | b | 3 | | c | 4.56 | |+| || 8.76 | #+TBLFM: @>$2=vsum(@-I..@-II);%0.2f This does last row (@>$2), and the sum between dividers, and outputs to fixed

Re: org-tables with monetary amounts

2020-09-22 Thread Nicholas Savage
I don't have anything to answer your questions, but I wanted to chime in that this is a feature I'd also like to exist, or find out more about if it already does exist. I'd be definitely willing to help out too code-wise to the extent I can. Thanks, Nick On Tue, Sep 22, 2020, at 10:57,