Allen Computing and Business Analysis
Services and Products, Analytical and Audit Software, Excel Workbooks, Spreadsheet Design, Specialist (open code) Functions, User Group. Links
We now concentrate on research and development of the role of spreadsheets outside the recognised commercial environment. The role of the website is to act as an information resource concerning the "development" findings arising from earlier commercial activity. Any potential contractual requests should be submitted direct to Stephen Allen.
Residual Services and Products
Analytical and Audit Software
- Electronic project and work paper management (ACBA Electronic Working Papers) - for the registration, indexing and cross-referencing of worksheets within an Excel workbook. Includes a complete suite for the management and control of Excel worksheet templates.
- Analytical and Investigative Tools (ACBA Tools) - a wide range of essential tools for Excel analysts, developers and auditors.
Examples of how Excel workbooks can be designed and used to generate fully functional processes and methodologies without resorting to specialist code development.
Specialist Excel Functions
An eclectic group of Add-ins and examples of Code developed within ACBA for its own use and published free for wider availability.
- Post a String - package for manipulating string arrays
- Convert to Single Column - more manipulating string arrays
- Reset to Default - a high speed function for reformatting a pre-selected range back to standard layout
- Merge and Word Wrap - selected cells are merged and word wrapped with specified cells to the right while ensuring that the row height is sufficient to keep the whole string visible
- Auto-delete Rows - built to help clean up databases imported from other sources. Selects and deletes rows based on the value of the first cell in the row.
- Automatic Review of VBA Code in Excel - a complete example of a procedure for reporting the instances of a user specified string within an Excel VB project code.
ACBA Functions - User Group
ACBA maintains a discussion forum for its software product users, who are welcome to join. The forum is moderated by ACBA and covers technical issues, general discussions on methodologies, answers to queries and future developments for ACBA software Membership is free.
This site is listed with
- willyancey.com Consultation on statistical sampling and litigation support - sadly Will died 11 February 2010 - see tribute from Bob Jensen - Dr Yancey's web site, however, continues for the time being
- Enable Technology Limited Specialists in Excel 2003 and a wide variety of other computer software related training.
- Blue Pecan Computer Training On-site Excel Training in Sussex, Surrey, Hants & London, UK
- Prime Office Space - Norwich - An online service that helps businesses find office space in Norwich and surrounding Norfolk