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
    Does a full recalculate
    There are two types of CalculateFull in Business Functions:
    • "Calculate Full" recalculates all the workbooks in memory, whether the individual cells need recalculating or not. It is a true "kitchen-sink" recalculate.
    • Calculate Full Rebuild" rebuilds Excels dependency tree first, and then does a Full Calculate. If you are in some doubt as to whether Excel has got the order of priority of cell calculations mixed up in some way.

    CalculateFullRebuild can take much longer to calculate than calculateFull - you may want to bear that in mind.

    CalculateFullRebuild does a full recalculate of your Excel workbook, including rebuilding the dependency tree. It is actually equivalent to the VBA command CalculateFullRebuild. This is very useful because, we have found at least, that Excel sometimes gets into its head not to recalculate certain cells in your workbook that ought to be. CalculateFull or CalculateFullRebuild is the brute force approach to this problem: assume everything needs recalculating and do it.

    CalculateFull (or CalculateFullrebuild) also solves any embedded GoalSeeks you have in the file. Business Functions" GoalSeek function is an extension to Excels GoalSeek, and in fact it uses Excel"s GoalSeek. But instead of having to specify your GoalSeek every time in Excel"s GoalSeek dialog box or via VBA, you can "embed" a GoalSeek in your model using the GoalSeek function. You just pass the appropriate information to the GoalSeek function. Then CalculateFull(Rebuild) will do the GoalSeek as part of its recalculation.

    The benefits of Business Functions embedded GoalSeek are:
    • You don"t have to re-specify the parameters of your GoalSeek every time, or set them up in VBA. The function is your record of the GoalSeek you require.
    • If you move the cells referred to by the GoalSeek, the references within the GoalSeek function will kepp track of where they have moved to.
    • If you give the model to someone else, you don"t have to give them detailed instructions about running the GoalSeek. Just say "use BF CalculateFull".
    • You can have several GoalSeeks in a model, and have them solved in the order you determine, all within a single CalculateFull.
    • It uses Excels GoalSeek, so the results will be consistent with if you done the Goalseek "by hand".
    • The GoalSeek becomes an intrinsic part of the logic of the model (which it is).

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