SeasonFactors | ||||||||
Data Type: Range Of Floats (Optional) | ||||||||
A range (either one or range of cells) consisting all of type Float, but which is optional. | ||||||||
SeasonFactors is usually partnered with SeasonSeq (an annual date sequence) to describe how seasonality works. Seasonality (for more info see Modelling Seasonality) is about where the rate of disbursement varies throughout the year, even though the overall rate for the year is specified, since it is either known or assumed. It is a way of putting a bit of seasonal "noise" into a forecast. SeasonFactors is a range of factors, the same absolute number of factors as specified date sequence numbers in SeasonSeq, so that each Season factor applies from one date. For example: SeasonFactors={1,2}, SeasonSeq={1.01,7.01} means that the second half of the calendar year runs at double the annualised rate of the first half. If the overall annual rate were $100,000 per year, the annualised rate applied to the first 6 calendar months of the year would be $66,666 p.a. and the rate for the second half of the year would be $133,333 p.a. It is important to note that SeasonFactors are just that - factors. They are not rates, they just describe the ratio between the various seasonal rates that when combined will amount to a specified annual rate. | ||||||||
Example: {2,3,1,2} |