:: Download
Main BF Addin For all Versions of Excel
Business Functions 1.54This is it - our main product, the free 500 function+ Business Functions library. It has both the Excel 2007 and the Excel 1997-2003 versions in the same package, complete with the help file, function finder, trace facility, all the examples and the tutorials. The Excel 2007 version also incorporates utilities including Cashflow Administrator, Number Formats, Select Function and Time Chart (BF Charts). 12,487 kb22 Feb 10
Alternative Downloads of Business Functions

As well as the complete install package above, we have a couple of minimalist install packages.

A potential advantage of using just the XLL is that you don't get all the BF user interface so its much more discrete and is in fact invisible to the user.

Beginning users are probably better off withe the complete install above, but you may have your reasons for wanting a more basic setup which will still run all the functions.

One application for minimum installs is that you might want to create a few bespoke VBA (array) functions that in turn call BF, without loading the full BF user interface.

Another might be that you don't want your users to start using the library, but just need them to be able to run models with BF in them. The XLL is very quick to load as there is no user interface.

You can also use the Excel VBA Auto_Open() function contained here to register the XLL on a individual model by model basis. In other words, you program it to load on demand.

(a) Library XLL Only
(with Automatic Installer)
This is just the library XLL without the BF user interface, and the installer automatically places it in program files/Business Functions and registers it with Excel. It's easy to install and has no menu interface at all, but all the functions are there and useable. It's the smallest download we do.1,949 kb22 Feb 10
(b) Library XLL File Only
(Manual install)
This is the basic uncompressed library file only that you can manually register as an add-in with Excel. You just have to copy the file somewhere on your system and reference in Excel as an add-in. The same file works with all versions of Excel. You should be comfortable copying files on windowss and dealing with Excel's Add-Ins menu to use this version. Most of the time we'd recommend option (a) above, but you might have some particular security considerations which prevents you using an automatic installer.. We suggest you save the XLL file either to c:\program files\Business Functions or alternatively to the directory you keep your Excel models in. 3,609 kb22 Feb 10
Addins For Excel 2003 and earlier
Cashflow AdministratorOur cashflow spreadsheet consolidation solution. Note this is the standalone CFA. CFA is included in Business Functions (both the 2003 and 2007 versions), so only download this if you just want to use CFA and not Business Functions. All CFA versions are compatible with each other. This version is open source.658 kb10 Sep 07
NumberFormatsThe simple and popular quick number formatter. Works with any version of Excel.544 kb10 Sep 07
SelectFunction The quickest, easiest, most organized way to access Excel's own function library, with unique context-sensitive help. Works with any version of Excel.306 kb11 Feb 06
BF Charts (beta)Our fast Chart Wizard for business charts that uses named ranges. Currently it's just the TimeChart (a quick, minimalist cashflow graph) that is implemented. Works with any version of Excel.523 kb17 Apr 07
Free Embeddable VBA Modules
You can freely use, distribute, copy and edit. They are Open Source. These add-ins are bits of VBA code you paste into your model and stay with the model, adding permanent functionality. Each consist of a short VBA code module(s) in zip files (containing instructions) that you can copy and paste into your workbook.
BFCheckUseful for Developers: Checks to see if Business Functions is installed and, if not, pops up a message advising the user to download Business Functions from the website. Also checks for specific version of BF being present0 kb19 Jul 06
Two-Way Cell LinkerA new and interesting concept: A method of linking two cells or ranges in both directions - change either one and the other changes. Example workbook contains code that goes into the ThisWorkBook module and a normal VBA module. TwoWay enables you to have the same input cell in more than one part of your model, for example on a DashBoard as well as an input sheet. 15 kb2 Dec 07
PDF Introductory 40 page booklet for Property
  • Getting a bit old now (Oct 2005) but still useful if you are wondering what its all about.
Introduction to Property Cash Flow Modelling Using Business Functions715 kb3 Nov 05
BF and Excel 12 (Excel 07)

BF is fully compatible Excel 2007, and the single installer on this page installs both busfun.xla for use with Excel 2003 and previous, and busfun.xlam, for Excel 2007.

The Excel 2007 version has its own new ribbon menu.

BF can cope with the larger spreadsheet dimensions in Excel 2007 inasmuch as it can happily receive references from anywhere on the spreadsheet. However, since we have only just got ourhands on the new Excel 2007 SDK, we cannot yet cope with ranges whose extent is greater than 256 columns.

In practise this should not impede you building spreadsheets that take advantage of the great sheet dimensions. And there is an absolute BF-imposed constraint of 10,000 cells per range passed to a BF function (not really an issue).

If you are still using Excel 2003 or earlier, none of this affects you.

94