The Origin Forum

File Exchange

Try Origin for Free

The Origin Forum

All Forums

Origin Forum

Add data calculations to column?

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

Smilies

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
dendrite	Posted - 04/22/2001 : 11:43:58 AM Any idea how to set column values by adding columns and other calculations?
1 L A T E S T R E P L I E S (Newest First)
Lorraine	Posted - 04/23/2001 : 5:07:01 PM I'm not sure whether you're asking how to use the Set Column Values feature in Origin or if you are trying to manage large scripts in the Set Column Values field of several columns in a worksheet. For a basic understanding of how Set Column Values feature works in Origin please consult your Origin User's manual or use the Help files in Origin (press F1 while a Set Column Values dialog box is open). If you have a lot of scripts, you might be interested in the following information. Ideally the Set Column Values field for each column in a worksheet is intended for individual calculations within that column or simple calculations among other columns in a worksheet (or other worksheets). However if you are starting to create a more extensive script, a more suitable option would be to create a toolbar or a button instead from which to run your script. Scripts can be more global so to speak and you wouldn't have to access the Set Column Values interface in order to run your calculations. you can use the worksheet command to create a new column in a worksheet then run various calculations among columns in a worksheet(s) i.e., wo -a n ; col(3)=col(2)/col(1); or wo -c test; //create a new Y column "test" wo -s 3; //select 3rd column; %H_test=(%C<=.5)?%C:.5; //extract values equal to or less than .5 from active dataset and place in new column The following link is to a knowledge base item which describes how toolbars can be set up in Origin. http://www.originlab.com/www/support/resultstech.asp?ItemID=663&VersionID=All&TitleID=Executing+Your+LabTalk+Script+from+a+Button+on+a+NewToolbar&CatID=LabTalk+Tip&TypeID=Script The following link is to a knowledge base item which describes how to use our custom tool (a button on the interface that's already set up to run custom scripts): http://www.originlab.com/www/support/resultstech.asp?ItemID=655&VersionID=All&TitleID=Executing+Your+LabTalk+Script+from+the+Custom+Routine+Button&CatID=LabTalk+Tip&TypeID=Script Lorraine OriginLab Technical Support Edited by - Lorraine on 04/23/2001 17:24:29

The Origin Forum

Snitz Forums 2000