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
    Usage of Functions (Audit)
    Checking up on what functions you are using
    The audit facility searches through your workbook, worksheet or range and gives you a list of what functions you are using.

    This is a most useful way of seeing the extent of your use of the library, what your favourite functions are, etc.

    It also tells you if any of those functions are deprecated or obsolete, meaning they are on the list to be phased out over time and you might be better off using a substitute function. If you keep your models a long time, Audit can give you advance warning that you should change a couple of functions that are destined to be ultimately discontinued. Such changes are normally very minor - a name change usually is all that is required - but at least the forewarning prevents later unexpected #NAME? errors.

    This function is particularly useful if you want to make sure you haven"t used any Business Functions in a model, should that be your wish.

    Note: the Audit facility is not perfect. If you are using the function FStepGrow it will report that you are using FStep and FStepGrow. That"s because the search that Audit performs can"t test for the whole word and tests for any part of the function name matching the Business Functions list of functions. This compromise has been made because it makes the search much quicker - as you can imagine, searching through thousands of formulas in a large model could take a long time, and we have implemented this the fastest way possible, even with this slight inaccuracy.

    Replacing Old Functions
    The Audit facility can also replace old Business Functions that have been or are on the list for retirement. Simply tick the box and as Audit goes through your workbook or worksheet it will replace old functions by their modern equivalents providing the change retains 100% compatibility. For example DpYX will be changed to DpY, MultiCon will be changed to Con. Such changes will only be made where 100% compatibility is assured. The Audit facility will tell you what functions have been replaced.

    Clearly, as with any facility that performs global edits on your worksheet, you should save your workbook, preferably under a different name, before selecting the "replace" option.

Business Functions Ltd, London, UK Website Design: Webpure