| Author |
 Topic  |
|
|
ngkhw2
USA
1 Posts |
 Posted - 07/03/2010 : 4:07:40 PM
|
Origin Ver. and Service Release (Select Help-->About Origin):
Operating System:
Hi Forum members,
I have 60data sheets open, I want to divide one column with fixed number. Instead of doing each data sheet, I would like to do for all 60 data sheets.Is their any code for it. Any help is appreciated.
Thanks
Naresh |
|
|
AmandaLu
439 Posts |
Posted - 07/05/2010 : 03:45:14 AM
|
Dear ngkhw2,
Suppose your data stores in worksheet1-60, Book1, and want to divide col(B) in each worksheet by 5, please run the following scripts:
loop(ii,1,3)
{
range DATA=[Book1]$(ii)!col(B);
DATA/=5;
}
If you use Origin 8.1, you can also use Batch Processing tool to do this.
First of all, create an Analysis Template using Set Column Value tool. Add a new column. Right click on this column and select Set Column Value. Specify the dividing formula and set Recalculate to Auto.
Save this worksheet as an .ogw file.
Secondly, select Batch Processing from File menu. This opens batchProcess dialog box. Specify settings like picture below.
|
 |
|
| |
Topic |
|
|
|
divide all columns with a number