From mboxrd@z Thu Jan  1 00:00:00 1970
From: Brett Presnell <presnell@member.fsf.org>
Subject: Table calculation
Date: Sat, 20 Feb 2016 14:41:58 -0500
Message-ID: <87mvqvdv95.fsf@ufl.edu>
Mime-Version: 1.0
Content-Type: text/plain
Return-path: <emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org>
Received: from eggs.gnu.org ([2001:4830:134:3::10]:57347)
	by lists.gnu.org with esmtp (Exim 4.71)
	(envelope-from <presnell@member.fsf.org>) id 1aXDPn-0002Hl-Bu
	for emacs-orgmode@gnu.org; Sat, 20 Feb 2016 14:42:04 -0500
Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71)
	(envelope-from <presnell@member.fsf.org>) id 1aXDPk-0006k6-5f
	for emacs-orgmode@gnu.org; Sat, 20 Feb 2016 14:42:03 -0500
Received: from smtp-prod02.osg.ufl.edu ([128.227.74.218]:52116
	helo=smtp.ufl.edu) by eggs.gnu.org with esmtp (Exim 4.71)
	(envelope-from <presnell@member.fsf.org>) id 1aXDPj-0006k1-Um
	for emacs-orgmode@gnu.org; Sat, 20 Feb 2016 14:42:00 -0500
Received: from xps8500 (ip24-170-207-206.ga.at.cox.net [24.170.207.206])
	(authenticated bits=0)
	by smtp.ufl.edu (8.14.4/8.14.4/3.0.0) with ESMTP id u1KJfudm041493
	(version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA256 bits=256 verify=NOT)
	for <emacs-orgmode@gnu.org>; Sat, 20 Feb 2016 14:41:57 -0500
List-Id: "General discussions about Org-mode." <emacs-orgmode.gnu.org>
List-Unsubscribe: <https://lists.gnu.org/mailman/options/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=unsubscribe>
List-Archive: <http://lists.gnu.org/archive/html/emacs-orgmode>
List-Post: <mailto:emacs-orgmode@gnu.org>
List-Help: <mailto:emacs-orgmode-request@gnu.org?subject=help>
List-Subscribe: <https://lists.gnu.org/mailman/listinfo/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=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: emacs-orgmode@gnu.org


In the following table, the last row gives the number of empty cells
following the last nonempty cell in each column (except the first column
of course).  I would like to create a TBLFM formula that does this
calculation for me automatically.  Some time ago I tried using
org-lookup-last and org-lookup-all for this, but I never got it to work.
Any ideas/solutions?

|   Date | AA | BB | CC | DD | EE | FF | GG | HH | II | JJ | KK | LL | MM |
|--------+----+----+----+----+----+----+----+----+----+----+----+----+----|
|      / | <> | <> | <> | <> | <> | <> | <> | <> | <> | <> | <> | <> | <> |
| 201005 |    |    |    |    |  1 |    |    |  1 |    |    |    |  1 |    |
| 201008 |    |    |    |  1 |    |    |    |    |    |    |    |    |    |
| 201012 |    |    |    |    |    |    |    |    |    |    |    |    |    |
| 201105 |    |    |    |    |    |  1 |    |    |    |    |    |    |    |
| 201108 |    |    |    |    |    |    |  1 |    |    |    |    |    |    |
| 201112 |    |    |    |    |    |    |    |    |    |  1 |    |    |    |
| 201205 |    |    |    |    |    |    |    |    |    |    |    |    |    |
| 201208 |    |    |    |    |    |    |    |    |    |    |    |    |    |
| 201212 |    |    |    |    |    |    |    |    |  1 |    |    |    |    |
| 201305 |    |    |  1 |    |    |    |    |  2 |    |    |  1 |    |    |
| 201308 |  1 |    |    |    |    |    |    |    |    |    |    |    |    |
| 201312 |    |    |    |    |    |    |    |    |    |    |    |    |  1 |
| 201405 |    |    |    |    |    |    |    |  1 |    |    |    |  1 |    |
| 201408 |    |  1 |    |    |    |    |    |    |    |    |    |    |    |
| 201412 |    |    |    |    |  1 |    |    |    |    |    |    |    |    |
| 201505 |    |    |    |  1 |    |    |    |    |    |    |    |    |    |
| 201508 |    |    |    |    |    |    |    |    |  1 |    |    |    |    |
| 201512 |    |    |    |    |    |    |  1 |    |    |    |    |    |    |
| 201605 |    |    |    |    |    |    |    |    |    |    |    |    |    |
|--------+----+----+----+----+----+----+----+----+----+----+----+----+----|
|        |  8 |  5 |  9 |  3 |  4 | 15 |  1 |  6 |  2 | 13 |  9 |  6 |  7 |