From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: from mp2 ([2001:41d0:2:4a6f::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by ms11 with LMTPS id ILCsLbAXa19XHQAA0tVLHw (envelope-from ) for ; Wed, 23 Sep 2020 09:38:56 +0000 Received: from aspmx1.migadu.com ([2001:41d0:2:4a6f::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by mp2 with LMTPS id oFd1KbAXa1+aNQAAB5/wlQ (envelope-from ) for ; Wed, 23 Sep 2020 09:38:56 +0000 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 461BF9404C7 for ; Wed, 23 Sep 2020 09:38:56 +0000 (UTC) Received: from localhost ([::1]:39778 helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1kL1El-0007Dg-89 for larch@yhetil.org; Wed, 23 Sep 2020 05:38:55 -0400 Received: from eggs.gnu.org ([2001:470:142:3::10]:60624) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1kL1Dx-0007CY-BD for emacs-orgmode@gnu.org; Wed, 23 Sep 2020 05:38:06 -0400 Received: from se18.route25.eu ([2a00:f10:400:4:1c00:18ff:fe00:1617]:35760) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1kL1Ds-0006Al-P8 for emacs-orgmode@gnu.org; Wed, 23 Sep 2020 05:38:04 -0400 Date: Wed, 23 Sep 2020 11:37:43 +0200 From: Russell Adams To: emacs-orgmode@gnu.org Subject: Re: org-tables with monetary amounts Message-ID: <20200923093743.GL15026@maokai> Mail-Followup-To: emacs-orgmode@gnu.org References: <3444a52f-36a7-6e9d-46b9-272dddc7a3ef@grinta.net> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <3444a52f-36a7-6e9d-46b9-272dddc7a3ef@grinta.net> X-Originating-IP: 185.87.185.80 X-SpamExperts-Domain: out.pcextreme.nl X-SpamExperts-Username: 185.87.185.80 X-SpamExperts-Outgoing-Class: ham X-SpamExperts-Outgoing-Evidence: Combined (0.15) X-Recommended-Action: accept X-Filter-ID: Mvzo4OR0dZXEDF/gcnlw0Z1apovzGPsYhEeBL1aoZmqpSDasLI4SayDByyq9LIhVUZbR67CQ7/vm /hHDJU4RXkTNWdUk1Ol2OGx3IfrIJKywOmJyM1qr8uRnWBrbSAGDLZy6c0DmV/7RK6letuHor9Q5 3pMmTXeVbblO3cSIiVBtBtEQtQerrRSXW3vX86k3JODXbtOodkPED+RkHjVGH9gpfPe2lDQBFQc5 pWKjU8U1TnR+f0U9cu064nZcMieLAqdkk6hppCDsqsBwLjHur1XxB26GtR7aQdGQ3RxVouttwXp1 RdEU8VHZI5KGZSviaHwJ2eESrUp0Iw/gSJ3HqMuR600P9eQ3vodupN36MrkzGQZS068e3EYTgNAB jZkD8TzPF4eG61o+cxFZrUIXowfXJosMX5ZQSlYSVlCDu2na8Lc2iK0mXNgodhRh0E6+UMVFei1G 2PrSIU9EwioS70yFBF2moUWeHNDS4qZDIDBdjx85xQq9VD42UbTRudBo31/E3ahF5MMcDI7KdpjQ KULbtCr8aoTjHIUEuG3LCVsCW2UOyugPPaOGK1ZclZhyJ1oAKHx1qHjvOGXm6QB+mk6ZTzCPKsFf twxbkg5OTEJBSZDxFdMdjhWKQRs1y634NtkDir044XKUvwzb23wQ7pgpf21taAxkVvyytXnHYuQQ rlTIRNmSBv5C/KoHO2jcB5hQ6nsDvccjqgmDvD9Wh0yFsY2Z2oGTB2IF2g6y44/ujwN5vAr2fQEN gxhN/KmvEyoAEK4rsNWk4mvtBc9RUW7Qh3gWh36mDf/2VxyYC7eGuP0YIX8qMA5MLNz4roJ54bmv bmzbv5BeKU93WlJYGqJLSMbJJChSd3VEt6mT7Hpm4zuNRcgRKiGg7nXFaZTxVtvfGUGUq3gP3sz9 6chjQ/thtU3VbZiduO40Yo9l2XF6coSh1XA3fOLJ37wDhYziT8A73IOjFaUxVIYlf6k/MfIjQKAZ fI/jcX6o1g9K5ZwJhmYqJ0PIxX89f7dLTMqse5FhVBQaO03dzx9rAMZnZXrgXdZHl2vqCbCSy9Ix 3eltOv8yJ5cKtwxhveW3ZWTI X-Report-Abuse-To: spam@semaster01.route25.eu Received-SPF: pass client-ip=2a00:f10:400:4:1c00:18ff:fe00:1617; envelope-from=rladams@adamsinfoserv.com; helo=se18.route25.eu X-detected-operating-system: by eggs.gnu.org: First seen = 2020/09/23 05:37:52 X-ACL-Warn: Detected OS = ??? X-Spam_score_int: -18 X-Spam_score: -1.9 X-Spam_bar: - X-Spam_report: (-1.9 / 5.0 requ) BAYES_00=-1.9, SPF_HELO_NONE=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.23 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-Scanner: scn0 Authentication-Results: aspmx1.migadu.com; dkim=none; dmarc=none; spf=pass (aspmx1.migadu.com: domain of emacs-orgmode-bounces@gnu.org designates 209.51.188.17 as permitted sender) smtp.mailfrom=emacs-orgmode-bounces@gnu.org X-Spam-Score: -0.51 X-TUID: cYifpYmuISR1 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 precision. On Tue, Sep 22, 2020 at 04:57:42PM +0200, Daniele Nicolodi wrote: > Hello, > > I often use org-tables to work with monetary amounts. It would be very > nice to have a couple of functionalities common in this domain: > > - fixed precision arithmetic, namely derive the precision of the results > from the precision of the arguments (I think that calc can do this), > > - support for parsing numbers followed by currencies, > > - correct alignment for monetary values. > > I had a quick look around, but I haven't found anything that implements > those things. Has anyone some secret code that they would like to share? > > Thank you! > > Cheers, > Dan > ------------------------------------------------------------------ Russell Adams RLAdams@AdamsInfoServ.com PGP Key ID: 0x1160DCB3 http://www.adamsinfoserv.com/ Fingerprint: 1723 D8CA 4280 1EC9 557F 66E8 1154 E018 1160 DCB3