Note: In order to use the spreadsheet examples, you need to download Business Functions | ||||||||
TFcstStep (TheDate, Start, ToDates, FcstVals, StartFcst, FcstBase, [FcstSwitchOpt]) | ||||||||
Read a value off an evenly spaced forecast, but at specific stepped intervals described by ToDates | ||||||||
Auto Array Function | ||||||||
Features | ||||||||
T... | Rates pertain to the time up until each corresponding to date | |||||||
...Fcst... | Changes are read of a supplied forecast. | |||||||
Step... | Has a stepped rate profile | |||||||
ExampleTFcstStep.xls |