ScheduleRatesλ() places values from a schedule table (or array) in a timeline's periods. The rate continues for each period after until another rate begins. This can be used for interest rates, pricing, discounts, etc.
NOTE! If two rates are scheduled within the same timeline period, only the last rate will be selected.
ScheduleRatesλ(Rates, EffectiveDates, Timeline, [EndDates?], [ItemIDs], [IncludeIDs])
Rates
(Required) Rates to be scheduled and persist until replaced.
EffectiveDates
(Required) Dates determining when a rate is effective.
Timeline
(Required) The model's timeline.
EndDates?
(Optional) TRUE=Timeline displays period end dates. Default = TRUE
ItemIDs
(Optional) A list that identifies what item in a group each rate applies to.
IncludeIDs
(Optional) A list of one or more ItemIDs to include. One ID per result row.
In this example FP&A has been asked to perform analysis involving US Federal prime interest rates. They have downloaded the rates and, in preparation for their analysis, they are using ScheduleRatesλ to place them in a model timeline.
In this example our corporate executives asked manufacturing engineering to make production line capacity improvements. Manufacturing Engineering returned with a list of lines they could improve, by how much, and when. With that list, FP&A is to determine the financial impact of the faster production lines. FP&A starts their model by using ScheduleRatesλ to place the new production rates in a timeline.
For our model to be accurate, our timeline's period interval must be as frequent or more frequent than the rate at which rates can change.