Embedded Files
Description
Description
Timelineλ() creates a horizontal timeline of either start dates or end dates for various period intervals.
Syntax
Syntax
Timelineλ( StartDate, [Periods], [Interval], [PeriodStarts?], [Diagnostics])
StartDate (Required)
First period's start date. May be entered as text.
Periods (Optional)
The number of periods in the timeline. Defaults to 12.
Interval (Optional)
Period interval: D, W, M, Q or Y (Day, Week, Month <default>, Quarter, or Year)
PeriodStarts? (Optional)
TRUE=Display period start dates <default>. FALSE=Period end dates
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.
Example
Example
This example creates the typical start and end period timelines for a financial model spanning 60 periods in months.
Timelineλ() defaults to one month periods.
Page updated
Google Sites
Report abuse