2.8.32 vmathtool


Menu Information

Analysis: Mathematics: Simple Column Math

Brief Information

Perform simple arithmetic on a single column.

Command Line Usage

  1. vmathtool ix1:=col(1) operator:=add operand:=data ix2:=col(2) ox:=<new>;
  2. vmathtool ix1:=col(3) operator:=sub operand:=constant constant:=100;
  3. vmathtool ix1:=col(1) operator:=custom ix2:=col(2) formula:=x1*100+x2^2 ox:=<new>;

X-Function Execution Options

Please refer to the page for additional option switches when accessing the x-function from script

Variables

Display
Name
Variable
Name
I/O
and
Type
Default
Value
Description
Input1 ix1

Input

vector

<active>

Specifies input data range. The input data range can be a single column or a part of a column.

Operator operator

Input

int

add

Specifies the Operator.
Option list

  • add:Add
    Addition
  • sub:Subtract
    Subtraction
  • Div:Divide
    Division
  • mul:Multiply
    Multiplication
  • pow:Power
    Power
  • custom:Custom
    Customize with formula
Operand operand

Input

int

constant

Specifies the operand type.
Option list

  • constant:Constant
    Use constant as operand
  • data:Reference Data
    Use reference data range as operand
Reference Data ix2

Input

vector

<optional>

Specifies a data range (a single column or a part of a column) as operand. This option is available when Reference Data is selected from Operand drop-down list.

Constant constant

Input

double

10

Specifies a constant as operand. This option is available when Constant is selected from Operand drop-down list.

Formula formula

Input

string

<unassigned>

Specifies the formula to calculate, in which x1 means Input1 and x2 means Reference data. This option is available when Custom is selected from Operator drop-down list.

Output ox

Output

vector

<input>

Specifies the output data range

X Minimum xmin

Output

double

<unassigned>

Minimum X value of output data range

X Maximum xmax

Output

double

<unassigned>

Maximum X value of output data range

X Mean xmean

Output

double

<unassigned>

Mean X value of output data range

Description

This tool performs simple arithmetic on a (part of) single column, or between two columns. You can add a constant on a set of data, or subtract a set of data by another one.

Examples

The following steps show you how to subtract a column by another.

  1. Click Import Single ASCII button Button Import Single ASCII.png on the standard toolbar to open the ASCII dialog. Select Enzyme.dat from <Origin Program Directory>\Samples\Curve Fitting folder and check Show Options Dialog checkbox. Click Open button.
  2. In the impASC dialog open, expand Header Lines sub branch under the Import Options branch. Set Number of Subheader Lines to 3, Long Names to 1, Units to 2, both Comments From and Comments To to 3. Click OK button to import Enzyme.dat.
  3. With "Enzyme" worksheet active, click Analysis: Mathematics: Simple Column Math to open vmathtool dialog.
  4. Click the triangle to the right of Input1 and select V(Y):V from the context menu. Select Subtract from Operator drop-down list and Reference Data from Operand drop-down list. Click the interactive button Mathtool help English files image002.jpg next to Reference Data, and select column C in the source worksheet as Operand. Select <new> for Output. And then click OK button.

A new column is added to the original worksheet. It shows the difference between "No Inhibitor" condition and "Competitive Inhibition" condition. The result worksheet should be as follow:

Vmathtool example.png

Related X-Functions

mathtool


Keywords:calculation