| T O P I C R E V I E W |
| GuGel |
Posted - 11/01/2005 : 1:36:37 PM
Origin Version (Select Help-->About Origin): 7.5
Operating System: XP
Hello to everybody!
Have some troubles (of course) with one script:
I have a worksheet with hundred of columns in each of which I need to average first 30 numbers, then normalize this column to the average value. So I wanted to create a button on a worksheet to make it automaticly; this is a script:
m=wks.ncols;
for (i=1;i<m+1;i+1) {
worksheet -s $i 1 $i 30;
ii=wks.sel;
stat.ds.mean(ii)=mea;
col($(i))/=mea;}
The script runs without any error message, but it simply deletes all the data in the worksheet and just makes the selection of first 30 raws.
What I did wrong?
Thank you in advance for help. |
| 1 L A T E S T R E P L I E S (Newest First) |
| Mike Buess |
Posted - 11/02/2005 : 09:00:35 AM
You are using the stat.ds method incorrectly but the sum() function is much easier to use anyway...
loop (ii,1,wks.ncols) {
set %(%H,ii) -e 30;
sum(%(%H,ii));
set %(%H,ii) -e wks.maxrows;
%(%H,ii)/=sum.mean;
};
Mike Buess
Origin WebRing Member |
|
|
