Business Functions Library for Excel

      1. Getting Started
      2. Using The Help File
      3. Top Dozen Functions
      4. Golden Rules
      5. Excel 2007
      1. Go To
      2. Function Selector
      3. CalculateFull
      4. Calculate WorkSheet
      5. Trace Facility
      6. Quick Paste Example
      7. Tutorials
      8. Function Finder
      9. Examples
      10. Help
      11. Excel"s Function Wizard
      12. Access Internet
      13. Usage of Functions (Audit)
      14. Uninstall
      1. Time Periods
      2. Inclusive and Exclusive Dates
      3. Using Daycount
      4. Examples of DayCount
      5. Annual Date Sequences
      6. ProjMode and Inclusive Dates
      7. Date Rolling Convention
      1. Rate Projections Functions Walkthrough
      2. Accruals and Cash
      3. Repeating Formulae
      4. Range Names and References
      5. Optional Parameters
      6. Using PmtsPerYear
      7. Modelling Seasonality
      8. Calculating Interest
      9. Using Business Functions in VBA (Visual Basic for Applications)
      10. Array Functions
      11. Volatility
      12. Annual Equivalent Rates
      13. Array Function
      14. Auto Multi Functions
      15. Variable Plurality
      16. GoalSeek
      1. Introduction To the Worked Examples
      2. Daycount
      3. General Projections
      4. Business Plans
      5. Cashbasis And Periods
      6. Using Timebases
      7. Using Dates
      1. How To Generate a time scale for a structured financing
      2. How To Project Rents off a Rental Forecast
      3. How To Run a model on different time bases
      4. How To Isolate The Cause of a Errors in Cells using Trace
      1. Introduction to the Utilities
      2. Audit
      3. Synchronized Range Insert/Delete
      4. Database Edit
      5. Insert Macro Button
      6. Link Analyser
      7. Range Describer
      8. PrintScript (beta)
      9. Create Local Range Name
      1. Number Formats
      2. Apply BF"s Color Palette
      3. Bullets
      4. Color Cells
      5. Conditional Formats
      1. Validation DropDowms
      2. Validation Standards
      1. Select Excel Function
      2. Array Function Tools
      3. Sort Sheets
      4. Range Value
      5. Named Range Manager
      6. Enforce WorkBook Settings
      7. Monte-Carlo
      8. TimeChart
      1. The ".ini" file
      1. Forum
      2. Online Help
      3. Templates
      1. Conversion of Input Strings to Values
      2. List of Holidays
      3. Acknowledgements and Trademarks
      4. Published Editions Changes in Behaviour
      5. Range Handling And Constraints
      6. Dates in Excel and Business Functions
      7. Old Composite DayCount Format
      8. DayCount in Excels"s Functions
      1. NPV of Annual To Periodic CashFlows - CorrectionM
      2. Interest - Simple, Annual, Continous and Discount Factors
      1. New Functions
      2. Obsolete Functions
      3. Discontinued Functions
      4. Deprecated Functions
    Variable Plurality
    How some variables can either be a single value or a range
    Usually it is onbvious whether a variable accepts a single value or a range. All variables that accept a range obviously accept a single value too. However, there are some variables where a single value is meaningful, but a range can be useful as well. Business Functions has two ways in which variables can effecetively be operated in two modes: singular or plural. The two ways are by Auto Multi variables (described in detail elsewhere see Auto Multi Functions) and optional plural variables, which are suffixed with an "_s" (eg ØIdxRegularity_sØ).

    The "_s" really means "(s)", like "VariableValue(s)", meaining the variable can be specified singular or plural. In fact, as far as the function is concerned, the variable is a plural range, and it will work out how you mean to use it be looking at how many elements it contains. So plural variables are really ranges that you can simply specify a single value. They are used in situations where, for simple use of a function, you might want to set just one value for a variable that you want used in all instances where the function uses that variable, but that when, in other situations of more advanced usage, you want to specify a range so that different values of the variable are used, say at different times, depending on what the function says in its documentation.

    The difference between plural "_s" variables and variables in Auto Multi Functions variables is that variables in Auto Multi Functions are for when the whole function will be re-run with the multiple values specified in its Auto Multi variables. Plural variables use the different values with a single calculation of the function

Business Functions phone: +44 (0)20 8144 9374 (London UK)
Website Design: Webpure