The Origin Forum - Add data calculations to column?

The Origin Forum

Username:	Password:
Save Password
Forgot your Password? \| Admin Options

All Forums

Origin Forum

Add data calculations to column?

New Topic

Reply to Topic

Printer Friendly

Author

Topic

dendrite

USA
1 Posts

Posted - 04/22/2001 : 11:43:58 AM

Any idea how to set column values by adding columns and other calculations?

Lorraine

USA
66 Posts

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

Topic

New Topic

Reply to Topic

Printer Friendly

Jump To:

The Origin Forum

Snitz Forums 2000