From mboxrd@z Thu Jan 1 00:00:00 1970 From: Matt Price Subject: syntax for remote table/cell references Date: Mon, 30 Nov 2015 11:36:11 -0500 Message-ID: Mime-Version: 1.0 Content-Type: multipart/alternative; boundary=047d7bd76b0494a4e60525c4a319 Return-path: Received: from eggs.gnu.org ([2001:4830:134:3::10]:39791) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1a3RR1-0008TC-4D for emacs-orgmode@gnu.org; Mon, 30 Nov 2015 11:36:16 -0500 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1a3RR0-0004N6-2W for emacs-orgmode@gnu.org; Mon, 30 Nov 2015 11:36:15 -0500 Received: from mail-ig0-x22f.google.com ([2607:f8b0:4001:c05::22f]:34376) by eggs.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1a3RQz-0004N2-TH for emacs-orgmode@gnu.org; Mon, 30 Nov 2015 11:36:14 -0500 Received: by igvg19 with SMTP id g19so74096646igv.1 for ; Mon, 30 Nov 2015 08:36:13 -0800 (PST) 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: Org Mode --047d7bd76b0494a4e60525c4a319 Content-Type: text/plain; charset=UTF-8 Hello everyone, I'm trying to simulate a simple "COUNT" spreadsheet function with the following two tables: #+TBLNAME: grades | Student | Precis | POV PAPER | |-----------------------+---------+-----------| | | A- | A- | | | A | A-/B+ | | | A- | A | | | B | B+ | | | A- | B+ | | | A | A | | | A | A- | | | A- | B+ | | | A- | A- | | | A | A | | | A | A | | | B+? A-? | A- | | | A- | B+ | | | B | B+ | | | B+ | A- | | | A- | A- | | | A | B+ | | | B+ | B | | | B+ | B+ | | | B+ | B | | | A | A- | | Grade | Count in Precis | Percent | |-------+--------+---------| | A+ | #ERROR | | | A | #ERROR | | | A- | #ERROR | | | B+ | #ERROR | | | B | #ERROR | | | B- | #ERROR | | | C+ | #ERROR | | | C | #ERROR | | | C- | #ERROR | | | F | #ERROR | | #+TBLFM: $2='(length (org-lookup-all $1 '(remote(grades,$2))));E Sorry for the ugly formatting. I want to just count the number of As, A-'s, etc, so I can see how badly I've messed up my distribution, and how much regrading I need to do. I don't understand the syntax for referencing cell ranges in org-lookup-all, nor do I quite get how "remote" works (doesn't seem to be a normal function?). Am trying to follow worg tutorials but not having much luck. Thanks, Matt --047d7bd76b0494a4e60525c4a319 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: base64 PGRpdiBkaXI9Imx0ciI+PGRpdj48ZGl2PjxkaXY+PGRpdj48ZGl2PkhlbGxvIGV2ZXJ5b25lLDxi cj48YnI+PC9kaXY+SSYjMzk7bSB0cnlpbmcgdG8gc2ltdWxhdGUgYSBzaW1wbGUgJnF1b3Q7Q09V TlQmcXVvdDsgc3ByZWFkc2hlZXQgZnVuY3Rpb24gd2l0aCB0aGUgZm9sbG93aW5nIHR3byB0YWJs ZXM6PGJyPjxicj7CoCMrVEJMTkFNRTogZ3JhZGVzPGJyPnwgU3R1ZGVudMKgwqDCoMKgwqDCoMKg wqDCoMKgwqDCoMKgwqAgfCBQcmVjaXPCoCB8IFBPViBQQVBFUiB8PGJyPnwtLS0tLS0tLS0tLS0t LS0tLS0tLS0tLSstLS0tLS0tLS0rLS0tLS0tLS0tLS18PGJyPnwgfCBBLcKgwqDCoMKgwqAgfCBB LcKgwqDCoMKgwqDCoMKgIHw8YnI+fCB8IEHCoMKgwqDCoMKgwqAgfCBBLS9CK8KgwqDCoMKgIHw8 YnI+fCB8IEEtwqDCoMKgwqDCoCB8IEHCoMKgwqDCoMKgwqDCoMKgIHw8YnI+fCB8IELCoMKgwqDC oMKgwqAgfCBCK8KgwqDCoMKgwqDCoMKgIHw8YnI+fCB8IEEtwqDCoMKgwqDCoCB8IEIrwqDCoMKg wqDCoMKgwqAgfDxicj58IHwgQcKgwqDCoMKgwqDCoCB8IEHCoMKgwqDCoMKgwqDCoMKgIHw8YnI+ fCB8IEHCoMKgwqDCoMKgwqAgfCBBLcKgwqDCoMKgwqDCoMKgIHw8YnI+fCB8IEEtwqDCoMKgwqDC oCB8IEIrwqDCoMKgwqDCoMKgwqAgfDxicj58IHwgQS3CoMKgwqDCoMKgIHwgQS3CoMKgwqDCoMKg wqDCoCB8PGJyPnwgfCBBwqDCoMKgwqDCoMKgIHwgQcKgwqDCoMKgwqDCoMKgwqAgfDxicj58IHwg QcKgwqDCoMKgwqDCoCB8IEHCoMKgwqDCoMKgwqDCoMKgIHw8YnI+fCB8IEIrPyBBLT8gfCBBLcKg wqDCoMKgwqDCoMKgIHw8YnI+fCB8IEEtwqDCoMKgwqDCoCB8IEIrwqDCoMKgwqDCoMKgwqAgfDxi cj58IHwgQsKgwqDCoMKgwqDCoCB8IEIrwqDCoMKgwqDCoMKgwqAgfDxicj58IHwgQivCoMKgwqDC oMKgIHwgQS3CoMKgwqDCoMKgwqDCoCB8PGJyPnwgfCBBLcKgwqDCoMKgwqAgfCBBLcKgwqDCoMKg wqDCoMKgIHw8YnI+fCB8IEHCoMKgwqDCoMKgwqAgfCBCK8KgwqDCoMKgwqDCoMKgIHw8YnI+fCB8 IEIrwqDCoMKgwqDCoCB8IELCoMKgwqDCoMKgwqDCoMKgIHw8YnI+fCB8IEIrwqDCoMKgwqDCoCB8 IEIrwqDCoMKgwqDCoMKgwqAgfDxicj58IHwgQivCoMKgwqDCoMKgIHwgQsKgwqDCoMKgwqDCoMKg wqAgfDxicj58IHwgQcKgwqDCoMKgwqDCoCB8IEEtwqDCoMKgwqDCoMKgwqAgfDxicj48YnI+PGJy PnwgR3JhZGUgfCBDb3VudCBpbiBQcmVjaXMgfCBQZXJjZW50IHw8YnI+fC0tLS0tLS0rLS0tLS0t LS0rLS0tLS0tLS0tfDxicj58IEErwqDCoMKgIHwgI0VSUk9SIHzCoMKgwqDCoMKgwqDCoMKgIHw8 YnI+fCBBwqDCoMKgwqAgfCAjRVJST1IgfMKgwqDCoMKgwqDCoMKgwqAgfDxicj58IEEtwqDCoMKg IHwgI0VSUk9SIHzCoMKgwqDCoMKgwqDCoMKgIHw8YnI+fCBCK8KgwqDCoCB8ICNFUlJPUiB8wqDC oMKgwqDCoMKgwqDCoCB8PGJyPnwgQsKgwqDCoMKgIHwgI0VSUk9SIHzCoMKgwqDCoMKgwqDCoMKg IHw8YnI+fCBCLcKgwqDCoCB8ICNFUlJPUiB8wqDCoMKgwqDCoMKgwqDCoCB8PGJyPnwgQyvCoMKg wqAgfCAjRVJST1IgfMKgwqDCoMKgwqDCoMKgwqAgfDxicj58IEPCoMKgwqDCoCB8ICNFUlJPUiB8 wqDCoMKgwqDCoMKgwqDCoCB8PGJyPnwgQy3CoMKgwqAgfCAjRVJST1IgfMKgwqDCoMKgwqDCoMKg wqAgfDxicj58IEbCoMKgwqDCoCB8ICNFUlJPUiB8wqDCoMKgwqDCoMKgwqDCoCB8PGJyPsKgIytU QkxGTTogJDI9JiMzOTsobGVuZ3RoIChvcmctbG9va3VwLWFsbCAkMSAmIzM5OyhyZW1vdGUoZ3Jh ZGVzLCQyKSkpKTtFPGJyPjxicj48L2Rpdj5Tb3JyeSBmb3IgdGhlIHVnbHkgZm9ybWF0dGluZy7C oCA8YnI+PC9kaXY+SSB3YW50IHRvIGp1c3QgY291bnQgdGhlIG51bWJlciBvZiBBcywgQS0mIzM5 O3MsIGV0Yywgc28gSSBjYW4gc2VlIGhvdyBiYWRseSBJJiMzOTt2ZSBtZXNzZWQgdXAgbXkgZGlz dHJpYnV0aW9uLCBhbmQgaG93IG11Y2ggcmVncmFkaW5nIEkgbmVlZCB0byBkby7CoCBJIGRvbiYj Mzk7dCB1bmRlcnN0YW5kIHRoZSBzeW50YXggZm9yIHJlZmVyZW5jaW5nIGNlbGwgcmFuZ2VzIGlu IG9yZy1sb29rdXAtYWxsLCBub3IgZG8gSSBxdWl0ZSBnZXQgaG93ICZxdW90O3JlbW90ZSZxdW90 OyB3b3JrcyAoZG9lc24mIzM5O3Qgc2VlbSB0byBiZSBhIG5vcm1hbCBmdW5jdGlvbj8pLsKgIEFt IHRyeWluZyB0byBmb2xsb3cgd29yZyB0dXRvcmlhbHMgYnV0IG5vdCBoYXZpbmcgbXVjaCBsdWNr LsKgIDxicj48YnI+PC9kaXY+VGhhbmtzLDxicj48L2Rpdj5NYXR0PGJyPjxicj48L2Rpdj4NCg== --047d7bd76b0494a4e60525c4a319--