The Origin Forum
File Exchange
Try Origin for Free
The Origin Forum
Home | Profile | Register | Active Topics | Members | Search | FAQ | Send File to Tech support
Username:
 Password:
Save Password
Forgot your Password? | Admin Options

 All Forums
 Origin Forum
 Origin Forum
 Area Fonction [Solved]		  New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic

polal2is

France
Posts
Posted - 04/14/2008 :  10:16:57 AM  Show Profile  Edit Topic  Reply with Quote  View user's IP address  Delete Topic
Origin Version (8 SR1):
Operating System: Vista SP1

Hi,
My question about how to get the end value of a column don't seem to find answer.
So I've found another solution but I need to use the area value in the "set column value" so how do you make a calulation with the area of a column. For example I have two columns A(X) and B(Y) and I want to fill a new column C(Y) with the area of B(A) divided by something let's say F. So I click on add new column then "set column value" and what fonction do I have to use there ?

area(Col(B), Col(A))/F -- Doesn't work of course
int(Col(B), Col(A))/F no...
integ1(Col(B), Col(A))/F doesn't work .... I really need your help..

Edited by - polal2is on 04/21/2008 10:54:49 AM

polal2is

France
Posts
Posted - 04/14/2008 :  11:03:23 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
OK so it must be "integ.area" but it seem to apply to the last integrated datas so how to use it for a particular column.

integ.area(Col(B)) ?? or What ?
Go to Top of Page

polal2is

France
Posts
Posted - 04/14/2008 :  11:35:55 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
To be clearer here's a screenshot :

http://www.casimages.com/img.php?i=0804140530282949581.jpg

Column 5 and 6 are integrated values of column 3 and 4 and I need the total area value of each column (5 and 6) to fill column 7 and 8 so how do I get the value and use it for calculation in "set column value" (for column 7 and 8) without using copy and paste ?
Go to Top of Page

easwar

USA
1965 Posts
Posted - 04/14/2008 :  10:23:09 PM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Hi,

In the Set Values dialog for the column, there is a Before Formula Scripts panel at the bottom and you can enter script there to perform computation (or for that matter any script command) and then use results from that computation in the formula itself.

The image pasted here shows how to put the area/sum of col2 in first row of col3. Note that the Rows From: edit boxes have been set to 1 and 1 - otherwise all rows in the col will be filled with the same value.

Easwar
OriginLab
Go to Top of Page

easwar

USA
1965 Posts
Posted - 04/14/2008 :  10:30:40 PM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Hi,

I just realized you wanted area integration, not just statistical sum.

So the formula in the bottom panel should be:

integ1 iy:=(1,2) oy:=<none>;


which does integration with x from col 1 and y from col 2 and no output col is added. Then in the top edit box you can enter

integ1.area



Easwar
OriginLab
Go to Top of Page

polal2is

France
Posts
Posted - 04/15/2008 :  04:25:26 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
THANKS A LOT that's exactly what I wanted it works perfectly !!!!
Go to Top of Page
  Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
The Origin Forum © 2020 Originlab Corporation Go To Top Of Page
Snitz Forums 2000