 |
Allen Computing and Business Analysis |
Page Content
- Services and Products
- Audit and Consultancy
- Analytical and Audit Software
- Free Download - Trial and Evaluation
- Excel Workbooks
- Spreadsheet Design
- Specialist (open code) Functions
- Contact Us
- Personnel
- Feedback
- Links
- User Group
Related Pages
Specialising in software development for Excel spreadsheets and Internal Audit/Consultancy
Allen Computing and Business Analysis was established in 1998.
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.
Free Download - Trial and Evaluation
Both the commercially available packages (ACBA Electronic Working Papers and ACBA Tools) are available for immediate download free of charge. The packages remain fully functional for at least one calendar month and may be converted into a registered version on purchase.
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
- Systems development and programming
- ACBA Spreadsheet Design Facility - a controlled methodology for describing spreadsheet systems requirements
- impact of employing ACBA Electronic Working Papers package on spreadsheet design concepts
- 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)7788 425508
Personnel
Stephen Allen, MIIA
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
Links
This site is listed with
- OzGrid.com. OzGrid has a really fine collection of Excel files and add-ins.
- 4Tops.com Mainly for MS Access end users but also carries a wide range of links
- willyancey.com Consultation on statistical sampling and litigation support
- Excel training UK Activia are experts in providing quality flexible training courses for Microsoft Excel standard or bespoke courses delivered at your offices or at their premises in Slough Berkshire
-
- AuditNet run by Jim Kaplan is the primary on-line resource for Internal Auditors
Feedback
Comments and suggestions about this website are always welcome. Please click the entry form to send a comment.
ACBA takes feedback seriously and reviews your entries regularly. Each suggestion will receive a response even if it is only brief. Click on the link to review ACBA's responses to view your own suggestion(s).
The ACBA Guestbook is based on suggestions from visitors to the website.
