Excel Dev conf presenter – Stephen Allen

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

Advertisements

2 Responses to “Excel Dev conf presenter – Stephen Allen”

  1. Excel Dev conf presenters « Smurf on Spreadsheets Says:

    […] 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. […]

  2. Excel Developers’ Conference Jan 25 London report | Patrick O'Beirne @ sysmod Says:

    […] 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. […]

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s


%d bloggers like this: