#### Fill Data

Use Fill Data (a) to fill a column with an evenly spaced series of numbers such as 2, 4, 6, 8… Use *Destination Column* (b), *Start Row *(c), and *End Row* (d) to define the range of cells to be filled and which column the results will be loaded. *Start Fill* (e) value and *Increment* (f) value define the first value in the series and the spacing between the values.

Start Fill Value | Increment Value | Resulting Series |

200 | 200 | 200, 400, 600, 800… |

1.00 | 0.01 | 1.01, 1.02, 1.03, 1.04… |

50 | -1 | 50, 49, 48, 47… |

#### Transform Data

Use **Data Options** → **Transform** (a) to transform a column of data or create a new column from the transformation of one or more other columns.

Enter the right side of an equation in the *Transform Equation* field (b). Use *Start Row* (c) and *End Row* (d) to define the range of cells to be transformed by the equation and loaded in *Dest Col* (Destination Column) (e). For example:

**(A + B)/100**,** sin(X), **and** (A*B)/sqrt(C)** are all valid transform equations. The letters X, A, B, and C each have their own designated column of Data in the Data Table. The results of the transformation will be placed in the Destination Column.

Example: Equation = **a*(1+b)**. The letters a and b in the equation designate the data in columns A and B in the Data Table. The results will be entered in Column C (*Dest Col*) as shown below.

If a value in the Destination Column is not empty, the values occupying that column will be overwritten. The function evaluator treats any empty or non-numeric cell as if it contains the value 0. See Entering Equations for more information.

#### Entering Equations

You can enter equations using rules listed below.

- Arithmetic operators supported include:

+ – e.g. –A –2*+3

^ e.g. B^2 (B squared)

*/ e.g. 4*C/3

- Expressions can be grouped with parentheses:

( ) e.g. 2*(3+2) (((A+2)*sin(C))/pi)

- Variables and constants supported include:

n | the value contained in the series (X, A, …P) |

en | 2.71828183 (base of natural logs) |

pi | 3.14159265… |

- Functions supported by the equation evaluator include:

**Note:** All trigonometric functions work in radians.

radians *180/π = degrees degrees * π/180 = radians

abs(n) | absolute value of n |

arccos(n) | arccosine of n returned in radians (0 to π) |

arcsin(n) | arcsine of n returned in radians (-π/2 to π/2) |

arctan(n) | arctangent of n returned in radians (-π/2 to π/2) |

arctan2(m,n) | arctangent of m/n returned in radians (-π/2 to π/2) |

ceil(n) | n rounded up to nearest integer |

cos(n) | cosine of n in radians |

cosh(n) | hyperbolic cosine of n |

exp(n) | en raised to the power n |

erf(n) | Gaussian error function of n |

erfc(n) | complementary Gaussian error function of n |

floor(n) | n rounded down to the nearest integer |

ln(n) | the natural log (base en) of n (for n>0) |

log(n) | the log (base 10) of n (for n>0) |

mod(n,m) | n mod m (n=(i*m)+mod(n,m) where i = integer) |

pow(n,m) | n raised to the power m (for n>=0 or n=-integer) |

rand() | random number between 0 and 1 |

sin(n) | sine of n in radians |

sinh(n) | hyperbolic sine of n |

sqrt(n) | square root of n (for n>=0) |

tan(n) | tangent of n in radians |

tanh(n) | hyperbolic tangent of n |