Showing 1–3 of 3 results for author: Bekenn, B

Workbook Structure Analysis - "Coping with the Imperfect"

Authors: Bill Bekenn, Ray Hooper

Abstract: This Paper summarises the operation of software developed for the analysis of workbook structure. This comprises: the identification of layout in terms of filled areas formed into "Stripes", the identification of all the Formula Blocks/Cells and the identification of Data Blocks/Cells referenced by those formulas. This development forms part of our FormulaDataSleuth toolset. It is essential for th… ▽ More This Paper summarises the operation of software developed for the analysis of workbook structure. This comprises: the identification of layout in terms of filled areas formed into "Stripes", the identification of all the Formula Blocks/Cells and the identification of Data Blocks/Cells referenced by those formulas. This development forms part of our FormulaDataSleuth toolset. It is essential for the initial "Watching" of an existing workbook and enables the workbook to be subsequently managed and protected from damage. △ Less

Submitted 29 November, 2011; originally announced November 2011.

Comments: 12 Pages, 7 Figures; Proc. European Spreadsheet Risks Int. Grp. (EuSpRIG) 2011 ISBN 978-0-9566256-9-4

Some Spreadsheet Poka-Yoke

Authors: Bill Bekenn, Ray Hooper

Abstract: Whilst not all spreadsheet defects are structural in nature, poor layout choices can compromise spreadsheet quality. These defects may be avoided at the development stage by some simple mistake prevention and detection devices. Poka-Yoke (Japanese for Mistake Proofing), which owes its genesis to the Toyota Production System (the standard for manufacturing excellence throughout the world) offers… ▽ More Whilst not all spreadsheet defects are structural in nature, poor layout choices can compromise spreadsheet quality. These defects may be avoided at the development stage by some simple mistake prevention and detection devices. Poka-Yoke (Japanese for Mistake Proofing), which owes its genesis to the Toyota Production System (the standard for manufacturing excellence throughout the world) offers some principles that may be applied to reducing spreadsheet defects. In this paper we examine spreadsheet structure and how it can lead to defects and illustrate some basic spreadsheet Poka-Yokes to reduce them. These include guidelines on how to arrange areas of cells so that whole rows and columns can be inserted anywhere without causing errors, and rules for when to use relative and absolute references with respect to what type of area is being referred to. △ Less

Submitted 6 August, 2009; originally announced August 2009.

Comments: 12 Pages, 8 Colour Figures

Journal ref: Proc. European Spreadsheet Risks Int. Grp. (EuSpRIG) 2009 83-94 ISBN 978-1-905617-89-0

Reducing Spreadsheet Risk with FormulaDataSleuth

Authors: Bill Bekenn, Ray Hooper

Abstract: A new MS Excel application has been developed which seeks to reduce the risks associated with the development, operation and auditing of Excel spreadsheets. FormulaDataSleuth provides a means of checking spreadsheet formulas and data as they are developed or used, enabling the users to identify actual or potential errors quickly and thereby halt their propagation. In this paper, we will describe… ▽ More A new MS Excel application has been developed which seeks to reduce the risks associated with the development, operation and auditing of Excel spreadsheets. FormulaDataSleuth provides a means of checking spreadsheet formulas and data as they are developed or used, enabling the users to identify actual or potential errors quickly and thereby halt their propagation. In this paper, we will describe, with examples, how the application works and how it can be applied to reduce the risks associated with Excel spreadsheets. △ Less

Submitted 18 July, 2008; originally announced July 2008.

Comments: 10 pages, 12 colour figures

Journal ref: Proc. European Spreadsheet Risks Int. Grp. (EuSpRIG) 2008 33-44 ISBN 978-905617-69-2