The Origin Forum

The Origin Forum

All Forums

Origin Forum

Note: You must be registered in order to post a reply.
To register, click here. Registration is FREE!

Screensize:

UserName:

Password:

Anti-Spam Code:

Format Mode:

Format:

Message:

* HTML is OFF
* Forum Code is ON

Check here to include your profile signature.
Check here to subscribe to this topic.

T O P I C R E V I E W
zango24	Posted - 05/12/2011 : 5:32:57 PM Origin 8. and Service Release (Select Help-->About Origin): Operating System: Xp and Win 7 Dear All, I have many columns in my book. There are close to 200 rows in each column. Normally, in the origin, we can normalize each column one by one with user defined value or auto normalize with the min or max value of the column. In my case, I am interested to normalize multi columns together each with specific row value e.g. Row 10 value of each columns. If there is a possibility to write a small script it would be a great help. Thanks in Advance. Regards, Zan
1 L A T E S T R E P L I E S (Newest First)
easwar	Posted - 05/15/2011 : 11:18:28 AM Hi Zan, So you want to normalize each column so that the value in the 10th row is a user defined value? Try this script: double dvalue = 1.0; // change this value as you need for(int icol=1; icol<=wks.ncols; icol++) { range rcol = wcol(icol); rcol *= dvalue/rcol[10]; } Also look at the LabTalk scripting guide to learn more about scripting: http://wiki.originlab.com/~originla/ltwiki/index.php?title=Category:LabTalk_Programming Easwar OriginLab

The Origin Forum