Inserting series |
Inserting automatic series (F8)
This will fill a given range of fields with values that can be numbers, dates/times,
built-in lists (day/month names) or custom lists.
The type of the series is determined automatically by the contents of the first field in that range.
The "step" (for numbers, dates/times) is determined automatically by the value of the next field value
in that range and if the next field is empty or contains incorrect data types, a unit step is used (1, one day, one hour).
If the contents of the first field doesn't match any of the above series types, a simple "copy" operation is performed.
Choosing a specific custom list to insert series.
Click the "Fill" toolbar button and choose the desirable list or use the "Manage" dialog box and use the "Insert" button.
If you choose a specific custom list by name:
Inserting formula based series
This enables you to define any type of data series including those referring to resources in other tables.
For this series type you need to define a formula that will be calculated for each record within the selected range.
Used formulas are add to the "recently used" list which is stored in the settings file.
Inserting random series
You can use several popular distribution types. Additionally, for the uniform distribution you can choose to create a series of items randomly selected from a given custom list.