| Author |
 Topic  |
|
|
lucast005
Spain
5 Posts |
 Posted - 02/12/2014 : 09:40:17 AM
|
Origin Pro 9.1 SR1
Operating System:Windows 7 Enterprise Service Pack 1.
We have some doubts about the best procedure to make two different calculations.
a) We need to make a calculation with the head of the columns named Parameters. The procedure is divide the full column by the Parameter Value. Question: How to do for all range of columns and not one by one.
b)We have two sheets with several columns each one. Question: We need to divide column by column the sheet 1 with the sheet 2: i mean: sheet 1 column i divided by sheet 2 column j and the result in a new sheet 3 (column z).
Thank you very much for your help
Lucas
University of Santiago de Compostela
|
|
|
lkb0221
China
497 Posts |
Posted - 02/12/2014 : 2:04:08 PM
|
Hi,
For the first calculation, you can see the following example, using right click and "Set multiple Column Values..."
Zheng
OriginLab |
 |
|
|
lkb0221
China
497 Posts |
Posted - 02/12/2014 : 2:10:26 PM
|
For the second calculation, still use the "Set Multiple column values...", see the example below:
 |
|
|
|
lucast005
Spain
5 Posts |
Posted - 02/13/2014 : 06:25:36 AM
|
Hi lkb0221,
Thank you very much for your fast and fantastic answer.
Lucas |
|
|
|
lucast005
Spain
5 Posts |
Posted - 02/14/2014 : 07:07:23 AM
|
Good day.
Thank you for the fast answer. I have a new question:
I was working with you procedure and its perfect.
I want to do but with several columns but i have to write for each column the script to calculate: is it possible to do automatically for all columns.
Thanks.
Lucas |
|
|
|
lkb0221
China
497 Posts |
Posted - 02/14/2014 : 10:10:50 AM
|
Hi, lucast005
The tool "Set Multiple Column Values" is desired to value multiple columns at one time, according to its name. In both cases I posted, you just need to highlight all the columns you need to calculate, open this dialog and right your code.
"i" means row number and "j" means column index number.
currently the tool only support set continuous columns. If your target columns are not continuous or in different sheets or books, you might need to use script to do automation process. Or, you can highlight the columns that with calculation, right click and select "Copy: Copy(Forluma)" and then paste to other columns.
Zheng
OriginLab |
Edited by - lkb0221 on 02/14/2014 11:45:37 AM |
|
|
| |
Topic |
|
Calculations for Columns