Library Information family
| Miscellaneous category | Home |
Provides textual information on various functions and variables in the library
| Component | What the name means |
|---|---|
| BFVer | Business Functions Version Number |
| DescribeLoanAcctOutput | Describes a value of a LAOutput variable (and similar variables) |
| DescribeCombineSwitch | Describe CombineSwitch |
| DescribePmtsPerYear | Describe the PmtsPerYear setting |
| DescribeLevelSwitch | Describe in a text string the LevelSwitch setting |
| DescribeBD | Describe Business Day convention |
| DescribeDayCount | Describe DayCount Method |
| DescribePeriods | Describe Periods used in Daycount Calculation |
| DescribeLookup | Describe in a text string the LookupSwitch setting |
| DescribeRounding | Describe the rounding method used |
| DescribeLoanOutput | Describes the value of a LoanOutput variable (also LAOutput) |
| DescribeShape | Describes the value of Shape variable. |
| ArgValues array function | Get the possible values of an argument and return an array |
The Library Information family provides information, as a text string, on various functions and variables in the library.
- Three very useful ones relate to the very common variables DayCount, CashBasis and Periods, which govern how projections functions determine how long a period of time is and when during the year payments are to be made. The functions, DescribeDayCount and DescribePeriods, take as inputs DayCount and Periods respectively.
- Also in this family is DescribeBD, which describes in plain language what Business Day setting you have made in BusDaySwitch.
- DescribeLevelSwitch describes what setting has been made in a function of the Levels Over Time Projections Category.
- Use these functions with your input cells in a spreadsheet so that when printed out you can see what settings have been used. It's very easy to forget and its a common source of errors.