Cashflow Administrator (CFA)The way to organise your consolidation process that just worksNo more unreliable hot links between files!Distributed as a separate add-in for Excel 2003 and earlier, CFA is now part of Business Functions for Excel 2007 (data files are remain compatible). CFA organises the systematic download and upload of data files, enabling you to set up a logical system of linking models together. This utility is designed for business planning and budgeting teams.It does not require, or depend on, the Business Functions library itself, although BF users will find the approach fits well with the way BF encourages you to work. - CFA works using a special range-naming convention for you to identify cells and ranges that you want downloaded.
- The download facility ensures that each download is given a unique version number and downloaded to your download directory.
- The upload facility imports data from any number of files into the workbook. Each item of data is systematically named, ready for use.
- CashFlow Administrator's upload facility understands time. Time-specific cashflows, budget lines etc are linked to a timebase set in the download file.On upload the data is consolidated into the consolidating file's timebase.
- CFA's Logfile Viewer keeps track of who downloaded what, and who uploaded it.
- There is a working example and help provided, plus our usual rapid support.
- The underlying method is simple and quite low-tech involving 3 key techniques:
- The Download is based on a user-configurable convention of naming ranges. There are no hidden secrets.
- The Storage of data is in plain editable text files in your download directory. You can even create CFA date files from other programs such as MS Access.
- the Upload is based on writing a simple script on a page within your workbook. There is complete transparency of purpose.
- It is similar to the methodology used inside leading UK property company.
| 