From mboxrd@z Thu Jan 1 00:00:00 1970 From: Jude DaShiell Subject: Re: searching for csv utilities Date: Wed, 3 Jun 2015 21:21:50 -0400 (EDT) Message-ID: References: Mime-Version: 1.0 Content-Type: TEXT/PLAIN; format=flowed; charset=US-ASCII Return-path: Received: from eggs.gnu.org ([2001:4830:134:3::10]:51442) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1Z0Jr2-0002Ae-Gw for emacs-orgmode@gnu.org; Wed, 03 Jun 2015 21:21:57 -0400 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1Z0Jqx-00075y-If for emacs-orgmode@gnu.org; Wed, 03 Jun 2015 21:21:56 -0400 Received: from mailbackend.panix.com ([166.84.1.89]:57720) by eggs.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1Z0Jqx-00075q-GB for emacs-orgmode@gnu.org; Wed, 03 Jun 2015 21:21:51 -0400 In-Reply-To: List-Id: "General discussions about Org-mode." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org Sender: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org To: Jonathan Leech-Pepin Cc: Org Mode Mailing List First, I tried usinb multiple #+TBLFM: lines to do all of the math and that only did the first line of calculations which was the sums which appear last. After replacing the double colons between calculation lines in the single line form of the #+TBLFM: line seven of the 8 lines worked correctly. The vmode() function only returned zeros since the columns weren't sorted. I did find a calc-sort function in the calc info and tried vmode(sort(@I..@II))%.2f (nested functions) and that also returned zeros on the mode line. Must be some other way to use that function I'll have to search out. Thanks much for the help on this project, it probably will be stolen from and used in other projects here. >> -- >> >> >> > --