From mboxrd@z Thu Jan  1 00:00:00 1970
From: Pete Phillips <pete@smtl.co.uk>
Subject: problems with table mode
Date: Sun, 20 Apr 2008 20:32:27 +0100
Message-ID: <18277.1208719947@localhost>
Reply-To: pete@smtl.co.uk
Return-path: <emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org>
Received: from mailman by lists.gnu.org with tmda-scanned (Exim 4.43)
	id 1JnfHS-0000Ss-PS
	for emacs-orgmode@gnu.org; Sun, 20 Apr 2008 15:32:54 -0400
Received: from exim by lists.gnu.org with spam-scanned (Exim 4.43)
	id 1JnfHR-0000RV-2M
	for emacs-orgmode@gnu.org; Sun, 20 Apr 2008 15:32:54 -0400
Received: from [199.232.76.173] (helo=monty-python.gnu.org)
	by lists.gnu.org with esmtp (Exim 4.43) id 1JnfHQ-0000RN-AM
	for emacs-orgmode@gnu.org; Sun, 20 Apr 2008 15:32:52 -0400
Received: from mailhost.smtl.co.uk ([193.131.77.174])
	by monty-python.gnu.org with esmtp (Exim 4.60)
	(envelope-from <pete@smtl.co.uk>) id 1JnfHP-000636-Qn
	for emacs-orgmode@gnu.org; Sun, 20 Apr 2008 15:32:52 -0400
List-Id: "General discussions about Org-mode." <emacs-orgmode.gnu.org>
List-Unsubscribe: <http://lists.gnu.org/mailman/listinfo/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=unsubscribe>
List-Archive: <http://lists.gnu.org/pipermail/emacs-orgmode>
List-Post: <mailto:emacs-orgmode@gnu.org>
List-Help: <mailto:emacs-orgmode-request@gnu.org?subject=help>
List-Subscribe: <http://lists.gnu.org/mailman/listinfo/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=subscribe>
Sender: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org
Errors-To: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org
To: org-mode mailing list <emacs-orgmode@gnu.org>

I am having a problem with a table I use to calculate my annual leave


| Basic Entitlement |         33 |
| Carryover         |          5 |
|-------------------+------------|
| Date              | No of days |
|-------------------+------------|
| 25th April        |          1 |
| 26th - 28th May   |          3 |
|-------------------+------------|
| Used              |          4 |
| Remaining         |          4 |
#+TBLFM: @III+1$2=vsum(@II+1$2..@III-1$2)::@III+2$2=@1$2+@2$2-@III+1

The table gives me the correct calculation for 'Used' - i.e., the number
of days I have taken so far.

However, the formula for the 'Remaining' row gives me the error 

  org-table-get-stored-formulas: Double definition `$2=' in TBLFM line, please fix by hand 

I don't understand this - if @III+1$w works for the second column in the
Used row, why doesn't @III+2$2 work for the second column in the
Remaining row ?

Any help appreciated.

Regards
Pete