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
 All Forums
 Origin Forum
 Origin Forum
 Area Fonction [Solved]

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: BoldItalicizedUnderlineStrikethrough Align LeftCenteredAlign Right Horizontal Rule Insert HyperlinkUpload FileInsert Image Insert CodeInsert QuoteInsert List
   
Message:

* HTML is OFF
* Forum Code is ON
Smilies
Smile [:)] Big Smile [:D] Cool [8D] Blush [:I]
Tongue [:P] Evil [):] Wink [;)] Clown [:o)]
Black Eye [B)] Eight Ball [8] Frown [:(] Shy [8)]
Shocked [:0] Angry [:(!] Dead [xx(] Sleepy [|)]
Kisses [:X] Approve [^] Disapprove [V] Question [?]

 
Check here to subscribe to this topic.
   

T O P I C    R E V I E W
polal2is Posted - 04/14/2008 : 10:16:57 AM
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
5   L A T E S T    R E P L I E S    (Newest First)
polal2is Posted - 04/15/2008 : 04:25:26 AM
THANKS A LOT that's exactly what I wanted it works perfectly !!!!
easwar Posted - 04/14/2008 : 10:30:40 PM
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

easwar Posted - 04/14/2008 : 10:23:09 PM
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



polal2is Posted - 04/14/2008 : 11:35:55 AM
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 ?
polal2is Posted - 04/14/2008 : 11:03:23 AM
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 ?

The Origin Forum © 2020 Originlab Corporation Go To Top Of Page
Snitz Forums 2000