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 |