From mboxrd@z Thu Jan 1 00:00:00 1970 From: Adam Porter Subject: Re: Finding calc/elisp methods Date: Thu, 03 Aug 2017 04:58:51 -0500 Message-ID: <8760e5otus.fsf@alphapapa.net> References: <2017-08-02T14-05-32@devnull.Karl-Voit.at> <2017-08-02T16-48-17@devnull.Karl-Voit.at> Mime-Version: 1.0 Content-Type: text/plain Return-path: Received: from eggs.gnu.org ([2001:4830:134:3::10]:36842) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1ddCuS-0006GR-CW for emacs-orgmode@gnu.org; Thu, 03 Aug 2017 05:59:17 -0400 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1ddCuP-00021c-QL for emacs-orgmode@gnu.org; Thu, 03 Aug 2017 05:59:16 -0400 Received: from [195.159.176.226] (port=54736 helo=blaine.gmane.org) by eggs.gnu.org with esmtps (TLS1.0:RSA_AES_128_CBC_SHA1:16) (Exim 4.71) (envelope-from ) id 1ddCuP-00021F-JR for emacs-orgmode@gnu.org; Thu, 03 Aug 2017 05:59:13 -0400 Received: from list by blaine.gmane.org with local (Exim 4.84_2) (envelope-from ) id 1ddCu8-0007S0-9n for emacs-orgmode@gnu.org; Thu, 03 Aug 2017 11:58:56 +0200 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" To: emacs-orgmode@gnu.org Karl Voit writes: > Leslie helped here by mentioning vmin/vmax which is that obvious > that I do feel embarrassed now ;-) > > #+TBLFM: @2$1=vmin(remote(myvalues,@2$1..@>$1))::@2$2=vmax(remote(myvalues,@2$1..@>$1))::@2$3=vmean(remote(myvalues,@2$1..@>$1))::@2$4=remote(myvalues,@2$1)::@2$5=remote(myvalues,@>$1) > > However, let's make this thread a valuable one by adding a question: > how does somebody find such things? Is there a source of information > where I could find calc methods by "apropos" method together with > elisp methods? > > "M-h a minimum" returns only calc-find-minimum which is hardly of > any help in this case. "apropos-documentation" returns more results > but still lacks "vmin". > > What is your method of choice to find answers to those kind of > questions? At least my internet search engine of choice did not help > me in the first place. IIRC these kinds of things are in the Org manual and info pages. Helm's helm-info-org command is very helpful for finding things in the Org info manual. I learned something new today: I didn't realize that Org could use calc-mode commands in tables. Wow. Org never ceases to surprise and amaze me! So googling for "org table calc" I got the manual page: http://orgmode.org/manual/Formula-syntax-for-Calc.html It wouldn't hurt to add a section to that page explaining how to find more info about the calc functions... ;)