Embedded Files
Description
Description
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.
Syntax
Syntax
ScheduleRatesλ(Rates, EffectiveDates, Timeline, [EndDates?], [ItemIDs], [IncludeIDs])
Arguments
Arguments
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.
Example
Example
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.
Page updated
Google Sites
Report abuse