** File: TPSheet4.hlp
** Index: 24

** Sheet View's Column Menu Commands


Û  Column menu

    This menu contains commands that
relate to column creation and
information.  Most of the commands in
this menu will display a dialog box.


Û  Create Column

    This menu item contains three column
creation commands.  These commands
produce smooth function plots.


Û  2D Curve Data

    This command displays the Create 2D
Curve Data dialog box.  The dialog box
contains several inputlines that let you
type in the function, data positions, as
well as other specifications.

    For example, if you type in function
string as 'Y=SQR(X)+2' and X MinVal=0,
MaxVal=4, and  NumPoints=5, the result is
as follows:
       X	Y
       0	2
       1	3
       2	6
       3	11
       4	18


Û  3D Surface Data

    This command displays the Create 3D
Surface Data dialog box.

    For example, if you type in function
string as 'Z=X+2*Y' and X from 0 to 2
with xMeshNum=2 and Y from 1 to 5 with
yMeshNum=2, the result is as follows:
       X	Y	Z
       0	1	2
       1	1	3
       2	1	4
       0	3	6
       1	3	7
       2	3	8
       0	5	10
       1	5	11
       2	5	12


Û  3D Bar Data

    This command displays the Create 3D
Bar Data dialog box.

    For example, if you type in function
string as 'Z=X+2*Y' and X from 0 to 2
with xDataNum=3 and Y from 1 to 5 with
yDataNum=3, the result is as follows:
       X	Y	Z
       0	1	2
       1	1	3
       2	1	4
       0	3	6
       1	3	7
       2	3	8
       0	5	10
       1	5	11
       2	5	12


Û  Curve Data

    This command displays the Create 3D
Curve Data dialog box.

    For example, if you type in the
following dialog box input:
        X Function: T
        Y Function: T+2
        Z Function: T*T
        T: MinVal: 0	MaxVal: 1.0
        DesColPos: 2	NumPoints: 11

    The result is as follows:
        X		Y		Z
        0.0		2.0		0.0
        0.1		2.1		0.01
        0.2		2.2		0.04
        0.3		2.3		0.09
        0.4		2.4		0.16
        0.5		2.5		0.25
        0.6		2.6		0.36
        0.7		2.7		0.49
        0.8		2.8		0.64
        0.9		2.9		0.81
        1.0		3.0		1.0


Û  Calculate Value

    This command calculates any data
value for the current column if it is a
calculated column.  A calculated column
is a column created either by a
user-defined function, or via
interpolation, or via curve fitting.


Û  Rank

    This command performs ranking of the
current column (the column which contains
the currently active cell).  It replaces
values with their positions in a list
sorted in ascending order.  Equal values
are given the mean of the ranks they
would have been given had they differed
slightly.  Missing values are ignored.


Û  Normalize

    This command does the normalization of
the current column (the column which
contains the currently active cell).
Normalization of a column data is to assume
that the column data values are from a
normal distribution with a population mean
and variance equal to those of the samples.
Each value is replaced with its Z-score,
i.e. the value it would have in the same
position in the standard normal
distribution (mean 0 and variance 1).
Missing values are ignored.


Û  Frequency Count

    The Column | Frequency Count command
lets you count the number of points in a
data range for the selected column.


Û  Sieve

    This command does data sieving based
on a selected data column.  This is useful
in certain situations, for example, where
instruments are recording large amounts of
data automatically and there may be more
data points than necessary for plotting.
With data sieving, you can select only
part of a column to create a new column
and plot it.


Û  Difference

    This command creates a new column based
on a selected column using the difference
between two consecutive rows.  i.e.
     B[i]:=A[i+1]-A[i], for i:=1 to N-1.
N is the number of points in column A.


Û  Column Info

    This command displays the Column
Information dialog box which shows the
current column information such as column
name, min and max value, if column is
calculated or observed, etc.
