Examples of Spreading Patterns

Assume a form cell having three children cells is affected by a spread. Examples of how patterns are applied to the three child values:

Table 13-7 Examples of Applied Spreading Patterns

Pattern Cell 1 Cell 2 Cell 3 Explanation
4 4 5 4 4 5 The new value is spread to level zero members using the 4 4 5 pattern. For example, if you set Q1 to 13, its value is spread as:

Jan = 4

Feb = 4

Mar = 5

1 1 1 1 1 is the same as 1*. This FLOW spread type shows how FLOW works if no values exist to make the spread proportional. The parent's value is divided by 3, the number of children cells, and spread equally to each of its three children.
P P P P Each child cell receives the parent's value. This is more a copy pattern than a spread.
!* P ! ! P Equivalent to a BALANCE type of spread.
P !* P ! ! Equivalent to a FIRST type of spread.
1 2 1 1 2 1 Similar to a bell-curve type of spread.
0 1 0 0 1 0 The beginning and ending children cells receive no spread values, and the middle child member receives the parent's value.