Skip to main content

Posts

Showing posts from June, 2022

ACBA Mapping – Spring 2022 Revision

Nearly all spreadsheet error values are as a result of a problem within a formula, but … The ACBA Mapping software was made available in its ribbon-based format in December 2021. There had been considerable testing of the technical aspects of the software and its interaction with the ribbon. However, relatively little testing had been undertaken on publicly available spreadsheet collections like the Enron Corpus. I began reviewing the Enron spreadsheets on a workbook by workbook basis in early spring 2022. The results of that review will be published later. However, it became clear the different authors had very different approaches to the construction of spreadsheets. In particular, I came across cell constants which were themselves error values. I should emphasise that these were not as a result of formula errors. The original ACBA Mapping software had not taken account of this possibility. Cell Constant - Error Values The spreadsheet file “NYMEX Straddles” displays the fol