Allen Computing and Business Analysis

First established 1998. Registered with Companies House 2007.

We now concentrate on research and development of the role of spreaadsheets 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.

Services and Products

Audit and Consultancy

Housing Benefit Subsidy Support - England and Wales only. A range of investigative and audit related services associated with the preparation of a Housing Authority's annual housing benefit subsidy claim and an Excel based package for monitoring the impact of claim adjustments using an expanded model of the DWP Electronic Claim.
Investigative Analysis and Audit - ACBA specialises in the review of older non-windows based systems using Excel as its analytical tool. The Audit and Investigation Analysis Service page describes in some detail our specialisms.
Audit Related Resources - including sample templates for use with ACBA-EWP software, miscellaneous models, extracts from seminar presentations and other publications

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.

Excel Workbooks

Examples of how Excel workbooks can be designed and used to generate fully functional processes and methodologies without resorting to specialist code developement.

Project Resource Scheduling and Control
Arithmetic and Stylistic - template resources
Auditing Su Doku puzzles - a typical approach to audit and process control

Spreadsheet design

Impact of employing ACBA Electronic Working Papers package is described spreadsheet design concepts. The employment of 'Controlled Statements' is a crucial extension of the design concept. These two elements were explored at the Excel Development Conference 2012. The slide show provides an overview of the combined processes, together with a worked example of the 'Controlled Statement' process.
Systems development and programming
ACBA Spreadsheet Design Facility - a controlled methodology for describing spreadsheet systems requirements
Auditing Su Doku puzzles provides a typical example of the combination process control and spreadsheet design to solve specific problems.
conversion service (24 hour delivery)

Specialist Excel Functions

An eclectic group of Add-ins and examples of Code developed within ACBA (UK) LTD 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.

Contact

ACBA (UK) LTD, 38 London Road, Harleston, Norfolk, England IP20 9BW or by e-mail.

Mobile 0(+44)7748 195353

Personnel

Stephen Allen

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.

Group name: ACBA_Functions
Group home page: http://groups.yahoo.com/group/ACBA_Functions
Group email address: ACBA_Functions@yahoogroups.com