Introduction |
| Getting Started | A few pointers |
| Using The Help File | What"s in it, how to find something, etc |
| Top Dozen Functions | Our own view |
| Golden Rules | Recommendations |
Menu Options |
| Go To | Quickly go to a worksheet, workbook or named range |
| Function Selector | BF"s fast function menu |
| CalculateFull | Does a full recalculate |
| Calculate WorkSheet | Calculate just the current worksheet |
| Trace Facility | BF"s error tracking mechanism |
| Quick Paste Example | |
| Tutorials | Spreadsheets that walk through various aspects of the library |
| Function Finder | Fast Access to function definitions, examples and more |
| Examples | The types of spreadsheet example available |
| Help | BF"s Help File |
| Excel"s Function Wizard | Getting the most out of Excel"s function interface |
| Access Internet | What happens when BF accesses the internet |
| Usage of Functions (Audit) | Checking up on what functions you are using |
| Uninstall | |
Business Functions Date Arithmetic |
| Time Periods | How BF defines Time Periods |
| Inclusive and Exclusive Dates | How BF deals with the first and last days of a Time Period |
| Using Daycount | Detailed discussion of DayCount and Periods |
| Examples of DayCount | Examples of DayCount and Periods in Cash and Accruals Mode |
| Annual Date Sequences | Description and Use of the AnnualDateSequence data type |
| ProjMode and Inclusive Dates | Using ProjModes 3 and 4 for a subtle change in defining the finish date |
Techniques |
| Rate Projections Functions Walkthrough | Discussion of the logic of the Rate Projections functions |
| Accruals and Cash | Difference between Accruals and Cash, and Recommendations |
| Repeating Formulae | Why its best to use the same formula across a projections"s range |
| Range Names and References | Specifying function arguments and the case for named ranges |
| Optional Parameters | How to deal with BF"s optional function parameters |
| Using PmtsPerYear | Pro"s and Con"s of this short-cut approach to payment frequency |
| Modelling Seasonality | Forecasting revenues that vary seasonally |
| Calculating Interest | Ins and Outs of interest calculation in Business Functions |
| Using Business Functions in VBA (Visual Basic for Applications) | How to call Business Functions from VBA |
| Array Functions | Many Business Functions are also Array Functions - here is how to use them |
| Volatility | Why some functions in Excel and BF re-calculate with more frequency than others |
| Annual Equivalent Rates | How BF uses what are also known as Annual Effective Rates |
| Array Function | How to use this most powerful and efficient Excel feature in Business Functions |
| Auto Multi Functions | Getting one function to do the job of many |
| Variable Plurality | How some variables can either be a single value or a range |
| GoalSeek | BF"s extension to Excel"s GoalSeek facility |
Worked Examples |
| Introduction To the Worked Examples | |
| Daycount | |
| General Projections | |
| Business Plans | |
| Cashbasis And Periods | |
| Using Timebases | |
| Using Dates | |
How to ... |
| How To Generate a time scale for a structured financing | |
| How To Project Rents off a Rental Forecast | |
| How To Run a model on different time bases | |
| How To Isolate The Cause of a Errors in Cells using Trace | |
Utilities - Information |
| Audit | |
| Introduction to the Utilities | The Utilities that come with BF |
| Insert Macro Button | Insert a quick macro button at the cursor location |
| Link Analyser | Finds out information about external links |
| Range Describer | Gives you information about the range you are in |
| Create Local Range Name | Quick way to do a sheet-local rangename |
Utilities - Formatting |
| Apply BF"s Color Palette | Replaces the current color palette of your workbook with the Business Functions color palette. |
| Bullets | Paste a bullet character into the current cell using the Wingdings font. |
| Color Cells | Color the currently active cell(s) according to a consistent code |
| Intelliformats | Applies a BF custom number format to the active cell(s) |
Utilities - Validating |
| Validation DropDowms | Paste a validation list into the active cell(s) |
| Validation Standards | Applies one of a number of standard cell validation conditions to the active cell(s) |
Utilities - Operations |
| Array Function Tools | Ways of working with array functions |
| Sort Sheets | Re-arranges the order of your worksheets |
| Range Value | Transforms a range into just numbers |
| Named Range Manager | Re-define and delete range names |
| Enforce WorkBook Settings | Apply your user-configurable settings to the whole worksheet |
| Monte-Carlo | How to use BF"s no-frills Monte-Carlo Simulator |
Customising Business Functions |
| The ".ini" file | Edit (carefully) the settings in BF"s INI file |
Resources On The Web |
| Forum | A place for you to post questions or start a discussion |
| Online Help | An alternative source of help |
| Templates | Lots of downloadable Excel spreadsheets available on the net |
Appendix 1 |
| List of Holidays | List of all the holidays dealt with by BusDaySwitch |
| Acknowledgements and Trademarks | |
| Published Editions Changes in Behaviour | Changes to existing functions you may want to review |
| Range Handling And Constraints | |
| Dates in Excel and Business Functions | What a date is, limits, auto date converson |
| Old Composite DayCount Format | Superceded Daycount specification format |
| DayCount in Excels"s Functions | Similarities, differences and things to watch out for |
Appendix 2 Key Formulae |
| NPV of Annual To Periodic CashFlows - CorrectionM | Mathematics of the PV correction from annually in arrear to periodic payments |
| Interest - Simple, Annual, Continous and Discount Factors | Mathematics of converting interest rates from one basis to another |
Appendix 3 New and Retired Functions |
| New Functions | Functions added recently |
| Obsolete Functions | Functions retired but still work |
| Discontinued Functions | Functions no longer with us |
| Deprecated Functions | Functions earmarked for future retirement |
Any comments on this documentation? Send us your suggestions below.
