[Orgmode] Re: org-table and formulas

[Sébastien Vauban]

Hi Alan,

Alan Boudreault wrote:
>
> Here's what I'm trying to do (without success) in my spreadsheet:
>
> I have a first table :
>
> #+TBLNAME: table1
> | ... |... |.... |...|...
>
> and a second table:
>
> #+TBLNAME: table2
> | line_reference | ... |... |.... |...|...
>
> The line_reference is the line number to get some information in the table1.
> So in a cell of the table2, I tried a formula like: remote(table1,@$1$3) ($1
> = the line_reference) which of course, didn't work.
>
> then I tried to use elisp: remote(table1,'(concat "@" $1 "$3")') .... but no
> success anyway.
>
> after all, I decided to merge my 2 tables because it looks like I can use
> elisp inside a org function (remote). The last tried formula was: '(concat
> "@" $1 "$3")' ,($1 = the line_reference). The problem of this formula is
> only that I got the string "@2$3" inside the cell and it's not evaluated as
> a formula.
>
> Could anyone give me some hint to get done what I'm trying to do?

What I do, which works:

- give a name to the cell in table1
- reference it (in table2) by its name


  #+TBLNAME: Eau
  |   | Date             | Relevé m3 | Consommation | Prix TVAC |
  |---+------------------+-----------+--------------+-----------|
  |   | [2009-11-15 Sun] | 2072.6263 |       0.0000 |      0.00 |
  |   | [2009-11-22 Sun] | 2074.1774 |       1.5511 |      1.55 |
  |   | [2009-11-29 Sun] | 2076.0834 |       1.9060 |      1.91 |
  |   | [2009-12-06 Sun] | 2077.6757 |       1.5923 |      1.59 |
  |   | [2009-12-13 Sun] | 2079.2140 |       1.5383 |      1.54 |
  |   | [2009-12-20 Sun] | 2081.4222 |       2.2082 |      2.21 |
  |   | [2009-12-27 Sun] | 2083.2146 |       1.7924 |      1.79 |
  |   | [2010-01-03 Sun] | 2085.4916 |       2.2770 |      2.28 |
  |   | [2010-01-10 Sun] | 2087.4283 |       1.9367 |      1.94 |
  | ^ |                  |           |              |       Eau |
  #+TBLFM: address@hidden@-1$-1;%.4f::$5=$4*1;%.2f::@2$4=0;%.4f


  | Énergie     | Prix TVAC |
  |-------------+-----------|
  | Eau         |      1.94 |
  | Gaz         |    156.81 |
  | Électricité |     11.64 |
  |-------------+-----------|
  | Total       |    170.39 |
  #+TBLFM: 
@2$2=remote(Eau,$Eau)::@3$2=remote(Gaz,$Gaz)::@4$2=remote(Elec,$Elec)::@5$2=vsum(@address@hidden);%.2f

Best regards,
  Seb

-- 
Sébastien Vauban