Manipulate Data > Generate Patterned Data > Simple Number Sequence
This utility generates a simple number sequence in a column. The sequence
consists of repetitions of terms that are differed by a constant step size.
To use this utility, you will specify the column for storing the sequence,
the first and last value of the
sequence, the step size, the number of times a value is repeated, and
the number of times the whole sequence of values is repeated.
- The utility can be accessed from
Data > Generate Patterned Data > Simple Number Sequence
- Store number pattern in: The
column names in which the numbers will be stored, separated
by spaces (e.g. c1 c3 c7). For a continuous range of columns, specify using
the first column, a dash, and the last column (e.g. C1-C30)
- From first number: The first number in the sequence
- To last number: The last number in the sequence
- In steps of: The difference between two terms (step size)
- Number of times to list each number: The number of times
each term appears in the sequence (continuously)
- Number of times to list each sequence: The number of times the
sequence, from the first to the last value, is repeated
Example
Given the inputs (From first number: 1, To last number: 10,
In steps of: 2, Number of times to list each number: 2, Number of times
to list each sequence: 2) produces the following sequence:
1 1 3 3 5 5 7 7 9 9 1 1 3 3 5 5 7 7 9 9.