Old Excel Add-Ins from ACBA

In the first decade of this millennium I developed two significant add-ins for Excel, that guided my approach to the structure of Excel workbooks (ACBA-EWP.xlam) and the review of those workbooks for errors etc (ACBA-Tools.xlam). The software can be downloaded from the links.

Diets would be boring if they never changed.

The Electronic Working Papers software assumes that workbooks do NOT stay static in terms of their structure. Rather they change and develop over time. It provides a methodology within which the changes and development can be managed. The reference to working papers is designed to show the rationale for that development. More detail about about operational mechanics of the software are available at ACBA Electronic Working Papers.

It is almost inevitable that Excel workbooks developed over time will become corrupted and error prone. The ACBA Tools software provides a series of simple tools that allows the user to review individual worksheets for their formulae, numeric values, error values etc. Also for worksheets developed over time, it allows the user to compare worksheets in terms of the changes between them. This functionality is considered in more detail at ACBA Audit Tools.

Comments

The Blood Sugar Diet: A Control Approach

Here is a quote from ‘ Get the Gloss ’ , High blood sugar levels - millions of us have it, but many of us don’t know it and it’s led to not just a type 2 diabetes epidemic, but also a rise in prediabetes , the condition that precedes it. Could calorie restriction help? It worked for medical journalist, Dr Michael Mosley and in his book, The 8-Week Blood Sugar Diet , he shares the science behind it . This website offers a specific diet which, it seems, you should repeat for each day of the 8 weeks. That is one approach but I would get bored very quickly. I guess my likelihood of success under these circumstances would be small. My wife and I wanted controlled variety, but for that we needed to know the calorie content of a wide variety of foods and to measure them out for each meal. I also needed “proof” that I had adhered to the regime throughout the 8 weeks. Hopefully, it would demonstrate how I was moving away from the type 2 diabetes risk zone. Th...

What is a Cell Map?

It is a simplified, colour coded version of an Excel Worksheet. The map shows the structure of the worksheet, its input cells, constants, primary formula and 'named' ranges. The map is designed for spreadsheet developers who work in isolation (i.e. not part of a team), but who, nevertheless, build complex spreadsheet systems. It highlights oddities and inconsistencies within a spreadsheet structure. Excel has its own built-in auditing and mapping tools. Excel's name manager and formula auditing tools These are useful for auditing one formula or one name, but they become overburdened with detail when trying to audit/review a whole worksheet. The ACBA Mapping [A revised version of the software is now available. Stephen Allen 05 September 2023] utility generates a map of the original spreadsheet and three map keys to aid the interpretation of the detail. For example, I went on strict weight reducing diet last year where I measured the weight/volume of everythin...

A Revised Cell Map!

In the Blog ' What is a Cell Map? ', I included an image of a Cell Map. On reflection the presentation was muddled. A simpler and clearer design seemed worthwhile. The result below is more clearly rectangular, with the headings for the map, the formula table and the names/validation table matched along the same row. The validation table is new and highlights where user inputs are limited by validation and the nature of the validation criteria. The revised software is available at ACBA-Mapping . In addition, although software is intended to be intuitive and self explanatory, it rarely is. I have created a user group at MSExcelCellMapping@groups.io . You are welcome to join and ask questions about the software. https://drive.google.com/file/d/1w3tHk1l-G9LjmCsOqMBkJpE9kaSj0iX_/view?usp=sharing Spreadsheet errors and inconsistensies is a subject that is of concern by professional developers as well as amateurs. The European Spreadsheet Risk Interest Group (EuSpRIG...

Logic, computing and people

Search This Blog