Features

You can use the following modeling options:

Spread

The Spread modeling option allows you to take a value and allocate it among selected destination cells. The value can be allocated equally, or it can be weighted by a range of values. For example, you can take the value 100,000 and spread it across a number of columns that represent each month of the year. See Spread Modeling.

Trend

The Trend modeling option takes a value or percentage and grows it by a factor among selected cells. This option places the source value in the first cell of the destination range. Each subsequent cell in the destination increases by the amount or percentage specified. See Trend Modeling.

Weight

The Weighted modeling option lets you allocate a set of values by weighted factors in your spreadsheet. It allows you to take a set of values, grow them if desired, and then allocate the new amount based on the relative weights of the selected cells. The destination range is the same as the weight range. For example, you can weigh 12 months of revenue based on 12 months of cost of sales. See Weighted Modeling.