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.

*