Page Content

Related Pages

Exhibition Workbooks in EWP

The Electronic Working Papers (EWP) software, although originally constructed for auditors, is mulri-functional. It is particularly suited to the analysis of and commentary on technical problems from an educational perspective. One of the first workbooks we published was our approach to solving Su Doku puzzles. This page contains descriptions of and links to a series of workbooks built in the EWP.

Deleting Duplicates

This sounds easy, but in this case the request came from an organisation who only wanted two to three fields from their original database extracted. The exclusion of duplicates was secondary. An additional requirement was that the original database should remain unchanged. The workbook Deleting Duplicates contains both an analysis of the problem and the code appropraite to a possible solution. NB - Contains VBA Code.

Analysing Lists

This particular workbook analyses lists (paragraphs of free text) for the names of British birds that they contain. It then looks for any numeric content associated with the birds found. The workbook Birds - Analysis of WebLogs demonstrates and evaluates the potential for employing ACBA Tools functionalityfor analysing lists.

Arithmetic Combinations

This project stems from a request submitted to one of the myriad of Excel on-line discussion groups. The workbook Arithmetic Combinations outlines two potential solutions to the questions "How many combinations of a named group of variables are there?" and "What is the value associated with each combination?". The project deconstructs the primary elements of the process for creating combinations and considers how these might be applied to a solution wiich uses formulae only (through Excel's user interface) and one which employs VBA Code. This workbook also considers that rather curious relationship between Arithmetic Combinations, binary numbering and the maximum number of rows in a worksheet (Excel 2003 or earlier).NB - Contains VBA Code

Management and Control of VBA Coded Projects

Over the years, the development of code published on our Oddments page has grown and become difficult to monitor and control. The workbook created and prepared at Oddments Development Record is a first attempt to draw together and evaluate the separate developments and activites that are publicised under this generic heading.

This particular file demonstrates the use of both ACBA-EWP style templates (to generate fairly complex worksheet presentations) and the Documentary Evidence Index. The evidence index, which links directly to separate code snippets and associated form layout pictures, shows the development of code without including coded modules within the project file itself. This approach for presenting VB code to the potential user overcomes the frequent barrier that commercial entities employ to stop their staff downloading inappropriate files from the internet.