# 2.8.32 vmathtool

## Contents

Analysis: Mathematics: Simple Column Math

## Brief Information

Perform simple arithmetic on a single column.

## Command Line Usage

 

 vmathtool ix1:=col(1) operator:=add operand:=data ix2:=col(2) ox:=<new>; vmathtool ix1:=col(3) operator:=sub operand:=constant constant:=100; 

## 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

Specifies the Operator.
Option list

• sub:Subtract
Subtraction
• Div:Divide
Division
• mul:Multiply
Multiplication
• pow:Power
Power
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.

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 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 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:

## Related X-Functions

Keywords:calculation