* Michael Brand <michael.ch.br...@gmail.com> wrote:
> Hi Karl
Hi Michael!
> On Sun, Sep 29, 2013 at 9:56 PM, Karl Voit <devn...@karl-voit.at> wrote:
>> | *Option* | *Evaluation 123* | *Evaluation 234* |
>> |----------+------------------+------------------|
>> | Option 1 | 27 | 26 |
>> | Option 2 | 22 | 24 |
>> | Option 3 | 16 | 16 |
>> | Option 4 | 16 | 13.5 |
>> | Option 5 | 8 | 9 |
>> | Option 6 | 2 | 4 |
>> |----------+------------------+------------------|
>> | | 91 | 92.5 |
>> #+TBLFM: @8$2=vsum(@I$2..@II$2)::@8$3=vsum(@I$3..@II$3)
>
> I would use
>
> #+TBLFM: @>$<<..@>$> = vsum(@I$0..@II$0)
> or the shorter
> #+TBLFM: @>$<<..@>$> = vsum(@I..@II)
Never used this kind of reference yet.
What about alternating data (no summary value at bottom row) and
evaluation columns?
| Data 1 | Eval 1 | Data 2 | Eval 2 |
What about moving columns:
Switching two columns from:
| Eval 1 | Eval 2 | foo | bar |
to:
| Eval 1 | foo | Eval 2 | bar |
("foo" and "bar" do not have those formula fields like Eval columns)
Besides the fact that I personally prefer single column
formulas for legibility and maintainability. I had to spend a minute
to understand "@>$<<..@>$> = vsum(@I..@II)" and I am afraid that I
have to re-spend this minute in three weeks when I have to add data
to the table.
So, yes you clearly helped with the example I posted. However, I
have got the feeling that this method is not able to solve my issue
in all cases. I still tend to think that org-table-duplicate-column
would be handy in many cases.
--
mail|git|SVN|photos|postings|SMS|phonecalls|RSS|CSV|XML to Org-mode:
> get Memacs from https://github.com/novoid/Memacs <
https://github.com/novoid/extract_pdf_annotations_to_orgmode + more on github
