Skip to main content

Posts

Showing posts from August, 2021

ACBA-Mapping - Development, Version Control and Publication Dates

The Mapping software arose out of a need to review some of my own rather complicated spreadsheets. The worksheets contained a variety of functional parts and I wanted a way of viewing how they worked together. The table below shows how these concepts have been developed over time. Date Primary Development Version Publication Date March 2020 The essential map and primary colour coding. It was always intended that the mapping function would be combined with lists of the main generic formulae used in the spreadsheet.  None   June 2020 The first version of the Mapping software was published and included within it some of the List functions from previous ACBA software developments. None 23 June 2020   March 2021 Introduced the shortcut tool bar. 0.000 Not published April 2021 The layout of the map, its legends, the generic fo

Generating the "ACBA-Mapping" Add-In

Background This Add-In is designed to map the underlying structure of an Excel worksheet. It. provides the means of reviewing the way that a worksheet operates both in terms of its layout and the relationship between blocks of formulae. The program for the Add-In can be downloaded from the link ' ACBA-Mapping '. Please read the following description of the process before attempting to activate it.  Generating 'ACBA-Mapping' The 'ACBA-Mapping' link will download the Add-In file to your personal Downloads folder. The File Explorer icon on your Task Bar, is the entry point. From your TaskBar Clicking this will open File Explorer. You want the Downloads folder - encircled in green. File Explorer normally opens to the 'Quick access' panel in the first instance. The Downloads folder is usually ordered youngest to oldest. So 'ACBA-Mapping' should be right at the top. The Downloads Folder ' ACBA-Mapping ' contains active code, which will have bee