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
 Calculating the sum of a matrix?
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic

gvswaaij

5 Posts

Posted - 02/07/2011 :  05:36:17 AM  Show Profile  Edit Topic  Reply with Quote  View user's IP address  Delete Topic
Origin Ver. and Service Release (Select Help-->About Origin): 8.1 SR1
Operating System: Windows 7

Dear fellow users,

This question should be waaay to simple, but: how do I calculate the sum of a matrix? According to the help browser:

"Computing the volume beneath a surface
To compute the volume beneath the surface defined by the matrix:

Select Analysis: Mathematics: 2D Volume Integrate. "

Unfortunately, this function doesn't show... I tried removing the local OCTemp folder and restarting but to no avail. Who can tell me where I can find this function?

Many thanks!

greg

USA
1378 Posts

Posted - 02/07/2011 :  12:46:00 PM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
First : The menu only appears when you have a matrix as the active window.

Second : You can access the X-Function via the Script Window as follows...
// BEGIN SCRIPT
integ2 -d
// END SCRIPT
which opens the dialog. You can click OK if a matrix is active or use the data hunt button or Matrix Browser in the fly out to select the matrix.

Third : You mentioned you want the sum of a matrix. The above calculates the integrated area which is different than a raw sum of the values of a matrix. The integral takes into account the X and Y scale values as well as the z values and the sign of the z values.
If you really just want to sum the z values in the matrix, use this:
// BEGIN SCRIPT
range ram = [MBook1]MSheet1!1;
total(ram)=;
// END SCRIPT

Edited by - greg on 02/07/2011 12:46:42 PM
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