Re: [O] org-table-duplicate-column
Hi! * Michael Brand wrote: > > On Tue, Oct 1, 2013 at 5:50 PM, Karl Voit wrote: >> I assume, there is a misunderstanding. > > Yes there was. With your clean example I understand now. Sorry that I was not able to describe the issue in the first place. >> [your example] >> >> Does this make any sense for you? > > Yes, it absolutely does. Only that someone would have to implement the > missing function org-table-duplicate-column... If you don't already > know it you can use the table formula editor "C-c '" for this in the > meantime to at least copy/paste the formulas for the new column. Thanks. This is how I do it for now. -- 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
Re: [O] org-table-duplicate-column
Hi Karl On Tue, Oct 1, 2013 at 5:50 PM, Karl Voit wrote: > I assume, there is a misunderstanding. Yes there was. With your clean example I understand now. > [your example] > > Does this make any sense for you? Yes, it absolutely does. Only that someone would have to implement the missing function org-table-duplicate-column... If you don't already know it you can use the table formula editor "C-c '" for this in the meantime to at least copy/paste the formulas for the new column. Michael
Re: [O] org-table-duplicate-column
Hi Michael! * Michael Brand wrote: > > On Mon, Sep 30, 2013 at 1:43 PM, Karl Voit wrote: >> 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 | > > Alternation and moving can be handled with conditional formulas > > #+TBLFM: @>$<..@>$> = if(subvec("@1", 2, 6) == "Eval", 42, $0) > > in Calc or even simpler (regex) with Lisp. Don't worry, For this I had > to cheat and look in testing/lisp/test-org-table.el with the ERTs that > should also be an advanced documentation. In this case > test-org-table/compare for the comparison and > test-org-table/copy-field for the substring. :-) I could not follow this example without looking into a manual either. >> I still tend to think that org-table-duplicate-column >> would be handy in many cases. > > I can not understand how with a variable if you mean that > literally. Also with macros for TBLFM as I imagine, that could be > difficult because already now there are conflicts and traps with the > TBLFM syntax. I assume, there is a misunderstanding. What I mean: I have got the following table with two columns containing two different data columns and one result column which contains two formulas: | data1 | data2 | results1 | |---+---+--| | 1 | 643 |2 | | 4 |22 |8 | | 6 |91 | 12 | |---+---+--| | | | 22 | #+TBLFM: $3=$1*2::@5$3=vsum(@I$3..@II$3) While being in the outer right column and doing "M-x org-table-duplicate-column", Org-mode simply duplicates the column and its related TBLFM entries accordingly: | data1 | data2 | results1 | results1 | |---+---+--+--| | 1 | 643 |2 |2 | | 4 |22 |8 |8 | | 6 |91 | 12 | 12 | |---+---+--+--| | | | 22 | 22 | #+TBLFM: $3=$1*2::@5$3=vsum(@I$3..@II$3) :: $4=$1*2::@5$4=vsum(@I$4..@II$4) This should be a pretty simple operation in cases where there are no complicated references. Then I adopt the resulting TBLFM with only minor effort (*instead of writing everything from scratch*) and get my similar but not same forth column: | data1 | data2 | results1 | results2 | |---+---+--+--| | 1 | 643 |2 | 321.50 | | 4 |22 |8 |11.00 | | 6 |91 | 12 |45.50 | |---+---+--+--| | | | 22 | 378.00 | #+TBLFM: $3=$1*2::@5$3=vsum(@I$3..@II$3) :: $4=$2/2;%.2f::@5$4=vsum(@I$4..@II$4);%.2f Probably I have a different approach because I am clearly no calc pro user (I need only basics) and I want to keep formulas (and references) easy to read (maintainability). Does this make any sense for you? -- 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
Re: [O] org-table-duplicate-column
Hi Karl On Mon, Sep 30, 2013 at 1:43 PM, Karl Voit wrote: > 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 | Alternation and moving can be handled with conditional formulas #+TBLFM: @>$<..@>$> = if(subvec("@1", 2, 6) == "Eval", 42, $0) in Calc or even simpler (regex) with Lisp. Don't worry, For this I had to cheat and look in testing/lisp/test-org-table.el with the ERTs that should also be an advanced documentation. In this case test-org-table/compare for the comparison and test-org-table/copy-field for the substring. > I still tend to think that org-table-duplicate-column > would be handy in many cases. I can not understand how with a variable if you mean that literally. Also with macros for TBLFM as I imagine, that could be difficult because already now there are conflicts and traps with the TBLFM syntax. Michael
Re: [O] org-table-duplicate-column
* Michael Brand wrote: > Hi Karl Hi Michael! > On Sun, Sep 29, 2013 at 9:56 PM, Karl Voit 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
Re: [O] org-table-duplicate-column
Hi Karl On Sun, Sep 29, 2013 at 9:56 PM, Karl Voit 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) The $<< vs. $2 etc. leaves TBLFM alone when moving around e. g. column $2. Michael
Re: [O] org-table-duplicate-column
* Michael Brand wrote: > Hi Karl Hi! > If you are not looking for range formulas > >| | a | b | >|--+---+---| >| 2014 | x | x | >| 2015 | x | x | > #+TBLFM: @<<$<<..@>$> = x > > an example would help me to understand. Sure: | *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) The third column is similar to the second. This is a very simple example with only one formula per column. Usually I end up with more formulas which I want to be duplicated as well. -- 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
Re: [O] org-table-duplicate-column
Hi Karl On Sun, Sep 29, 2013 at 10:35 AM, Karl Voit wrote: > I often end up creating a table where I do the header and the outer > leftmost column. Then I start by creating the second column with > formulas. In many cases, the following columns are like the previous > one but with, e.g., $3 instead of $2 in all formulas. If you are not looking for range formulas | | a | b | |--+---+---| | 2014 | x | x | | 2015 | x | x | #+TBLFM: @<<$<<..@>$> = x an example would help me to understand. Michael
[O] org-table-duplicate-column
Hi! I often end up creating a table where I do the header and the outer leftmost column. Then I start by creating the second column with formulas. In many cases, the following columns are like the previous one but with, e.g., $3 instead of $2 in all formulas. Either there is another solution to my work-flow or org-table-duplicate-column would be a cool new feature :-) -- 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