Embedded Files
Description
Description
Allocateλ() divides and distributes amounts equally across periods. This is useful when we have an annual amount that we want to spread the impact across months. In the example below, we have the annual depreciation of three assets being spread equally across months.
NOTE! In the above example the row and column totals are supplied by SumAλ(). Allocateλ() does not create totals.
Syntax
Syntax
Allocateλ( Amounts, Timeline, [FromInterval], [EndDates?])
Arguments:
Arguments:
Amounts
(Required) One or more amounts to allocate in a row. The amount's position under the model's timeline indicates when the amount is incurred.
Timeline
(Required) The model's timeline.
FromInterval
(Optional Default=Y) Indicates for what period the amounts are for. Y=annual, Q=quarterly.
Page updated
Google Sites
Report abuse