5g: ScheduleValuesByItemsλ()
Description
ScheduleValuesByItemsλ() sums and places each item's values from a schedule table (or array) in a timeline's periods. Unlike ScheduleValues(), ScheduleValuesByItemsλ() keeps each item's value in its own row.
Syntax
ScheduleValuesByItemsλ(PeriodStarts, PeriodEnds, ItemFilter, ItemList, EffectiveList, ValueList, [Diagnostics])
PeriodStarts (Required)
A row of period start dates (timeline).
PeriodEnds (Required)
A row of period end dates (timeline).
ItemFilter (Required)
A column of 1 or more items to filter a value schedule by.
ItemList (Required)
Items in a value schedule. A 'value schedule' is a table/list where each row contains a unique item/effective date pair with a value.
EffectiveList (Required)
Effective dates in the value schedule.
ValueList (Required)
Values in a value schedule for each item/effective date pair.
Diagnostics (Optional)
If TRUE, input errors that can occur after formula entry will display as diagnostic messages. The default is FALSE. It is recommended that models have a named range called Diagnostics and this named range be set to TRUE during model development and then set to FALSE when the model is placed into production.
This function includes an argument named DoNotUse. This is needed for internal purposes and must be omitted when the function is first called. So, do not use DoNotUse.
Example
In this example we are scheduling when assets are purchased. On the left we have a table of assets, their value, and when the are recognized as payables. The order of entries in the table is unimportant. The rates and effective dates can be in a horizontal layout. No table is needed but we lose the dynamic advantages of structured references.
