Create an arbitrary set of numbers

Calc > Make Patterned Data > Arbitrary Set of Numbers

Complete the following steps to fill a column with a pattern of numbers that are not equally spaced, such as the numbers 10 20 50.

  1. In Store patterned data in, enter a column number (for example, C1) or a column name. If the name contains spaces, enclose the name in single quotation marks.
  2. In Arbitrary set of numbers, enter the sequence of numbers in the pattern, separated by spaces. You can enter stored constants (K) instead of numbers.
    Tip

    You can use a colon to denote consecutive numbers and a slash to denote increments. For example, if you enter 50:52/0.5, the output is 50 50.5 51 51.5 52.

  3. Enter the repeat information for the pattern.
    1. In Number of times to list each value, enter the number of consecutive times to list each value in the sequence.
    2. In Number of times to list the sequence, enter the number of times to repeat the entire sequence.

For example, these settings create the following column of data.

  • Arbitrary set of numbers: 1 7 8
  • Number of times to list each value: 2
  • Number of times to list the sequence: 3
C1
Numbers
1
1
7
7
8
8
1
1
7
7
8
8
1
1
7
7
8
8
By using this site you agree to the use of cookies for analytics and personalized content.  Read our policy