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 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 don't match any of the above series types, a simple "copy" operation is performed.

• Built-in list (day/month names) items can be substrings (words) within text strings in fields. For example, if the first field contains "departure on Monday", the rest of the inserted series will be in the same form: "departure on Tuesday", etc.
• Custom list items can also be substrings (words) within a field, but to be recognized, instead of the F8 command such series must be used explicitly by its name, by clicking the Fill button.

Click the Fill toolbar button and choose the desired list, or use the Manage dialog box and use the Insert button.

If you choose a specific custom list by name:

• Custom list items can also be substrings (words) within a field, but to be recognized, instead of the F8 command such series must be used explicitly by its name, by clicking the Fill button.
• The selected range of fields doesn't have to contain the initial series item. If it's empty, the series will simply start from the first list item.

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 added to the "recently used" list, which is stored in the settings file.

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.