Name: Stephen Allen
Business: ACBA (UK) LTD – consultancy and Excel software development.
Topic: Project management within Excel (2003). Managing the process of reviewing a large (multi sheet) workbook logically and drawing findings / conclusions. The process is engineered such that a reviewer can inspect the data sources and associate logic instantly.
This presentation concentrates, specifically, on the programming and management of closely related but separate findings/conclusions, such that a report (in MS Word) can be generated directly from the review process.
Is the process sufficiently robust?
Is there a realistic case for developing the same software in ribbon style Excel?
Why; The software has been on the market for 10 years (nearly). I’m still not certain of the answers to the above questions even though it has been employed extensively within the company. The programming itself is fairly sophisticated and deserves an airing even if the functionality proves unpopular.
The Excel 2003 Add-In is available free (and open-sourced) from http://tech.groups.yahoo.com/group/ACBA_Functions/
You will have to apply for membership. Sorry, but I must keep the riff-raff out.
Hobbies: Grandfather-dom, walking/cycling, amateur classical chamber music
December 23, 2011 at 1:02 pm |
[...] First up on the conf blog is Stephen Allen. Stephen will be taking us through some tools and techniques for reviewing real world spreadsheets. And dealing with the review findings. [...]
January 25, 2012 at 11:35 pm |
[...] Stephen Allen of ACBA spoke on his auditor’s Electronic Working Papers (EWP) application, which he developed from the need to demonstrate a chain of evidence from the system being audited through the risk to the audit finding, conclusions, and recommendations. [...]