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
    Range Handling And Constraints
    Most functions involving range inputs do some pre-processing of these input ranges during the functions input screening process. The types of processes carried out are as follows. See each function for details pertaining to that function.
    NameWhat It Does
    2 Dimensional Matrix TrimTthe 2 dimensional array will be trimmed to match the size of the axis variables.
    Check AscendingThe dates in this range must (after any previous range-handling adjustments) be in order of ascending date.
    Check DescendingThe dates in this range must (after any previous range-handling adjustments) be in order of descending date.
    Check Same LengthThe length of these ranges (after any previous range handling adjustments and including any blanks or zeros) must be the same length or the function will report an error.
    Date SizeThe first (date) range will be shortened to the first non-zero element, eliminating trailing zeros. If the second range is then longer then it will be shortened to the size of the date range. If the second range is shorter it will be padded by zeros. If both the date and the corresponding value are zero at any location in the range, the range is compacted and shortened.
    Make Same SizeIf the two ranges are differing lengths, the longer range will be shortened to the size of the other, so that both ranges are the same length.
    Preceding Zero SizeTrims the zeros at the start of the list.
    Trailing Blank Size (one range, and will not shorten to a range length less than 1)If this range has trailing blanks (as opposed to zeros, a blank is a cell with nothing in it), the range will be shortened to the last non-blank element.
    Trailing Zero Size (2 or more ranges)If the ranges are of different lengths, the longer will be shortened to the size of the shorter range. Then, if both corresponding elements at the end of the ranges are zero, the ranges are shortened further. For instance ({20,30,0,0,0},{0,10,10,0,0}) would be shortened to ({20,30,0},{0,10,10})
    Trailing Zero Size (one range)If this range has trailing zeros, the range will be shortened to last non-zero element. So {0,20,0,30,0,0} would be shortened to {0,20,0,30}.
    Trailing Zero Size (one range, and will not shorten to a range length less than 1)If this range has trailing zeros, the range will be shortened to last non-zero element. So {0,20,0,30,0,0} would be shortened to {0,20,0,30}. However, it will not be shortened to less than 1 item if more than one item exists.

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