Showing 1–15 of 15 results for author: Croll, G J

BiEntropy, TriEntropy and Primality

Authors: Grenville J. Croll

Abstract: The order and disorder of binary representations of the natural numbers < 2^8 is measured using the BiEntropy function. Significant differences are detected between the primes and the non primes. The BiEntropic prime density is shown to be quadratic with a very small Gaussian distributed error. The work is repeated in binary using a monte carlo simulation for a sample of the natural numbers < 2^32… ▽ More The order and disorder of binary representations of the natural numbers < 2^8 is measured using the BiEntropy function. Significant differences are detected between the primes and the non primes. The BiEntropic prime density is shown to be quadratic with a very small Gaussian distributed error. The work is repeated in binary using a monte carlo simulation for a sample of the natural numbers < 2^32 and in trinary for all natural numbers < 3^9 with similar but cubic results. We find a significant relationship between BiEntropy and TriEntropy such that we can discriminate between the primes and numbers divisible by six. We discuss the theoretical underpinnings of these results and show how they generalise to give a tight bound on the variance of Pi(x) - Li(x) for all x. This bound is much tighter than the bound given by Von Koch in 1901 as an equivalence for proof of the Riemann Hypothesis. Since the primes are Gaussian due to a simple induction on the binary derivative, this implies that the twin primes conjecture is true. We also provide absolutely convergent asymptotes for the numbers of Fermat and Mersenne primes in the appendices. △ Less

Submitted 2 April, 2020; v1 submitted 25 November, 2019; originally announced December 2019.

Comments: 18 Pages, 12 Colour Figures, 10 Tables. Minor updates & typos. Supplementary materials now available at https://doi.org/10.6084/m9.figshare.11743749. Empirical results first presented at ANPA 40, University of Liverpool, 11th August 2019. Theoretical Basis first presented at PANPA 2019 meeting, Anstruther, Fife, Scotland, 21st August 2019

Journal ref: Entropy 2020, 22(3), 311;

The Reification of an Incorrect and Inappropriate Spreadsheet Model

Authors: Grenville J. Croll

Abstract: Once information is loaded into a spreadsheet, it acquires properties that it may not deserve. These properties include believability, correctness, appropriateness, concreteness, integrity, tangibility, objectivity and authority. The information becomes reified. We describe a case study through which we were able to observe at close hand the reification of a demonstrably incorrect and inappropriat… ▽ More Once information is loaded into a spreadsheet, it acquires properties that it may not deserve. These properties include believability, correctness, appropriateness, concreteness, integrity, tangibility, objectivity and authority. The information becomes reified. We describe a case study through which we were able to observe at close hand the reification of a demonstrably incorrect and inappropriate spreadsheet model within a small non profit organisation. △ Less

Submitted 30 January, 2018; originally announced January 2018.

Comments: 14 Pages, 4 Colour Figures, 2 Tables

Journal ref: Proceedings of the EuSpRIG 2017 Conference "Spreadsheet Risk Management", Imperial College, London, pp63-76 ISBN: 978-1-905404-54-4

BiEntropy - The Approximate Entropy of a Finite Binary String

Authors: Grenville J. Croll

Abstract: We design, implement and test a simple algorithm which computes the approximate entropy of a finite binary string of arbitrary length. The algorithm uses a weighted average of the Shannon Entropies of the string and all but the last binary derivative of the string. We successfully test the algorithm in the fields of Prime Number Theory (where we prove explicitly that the sequence of prime numbers… ▽ More We design, implement and test a simple algorithm which computes the approximate entropy of a finite binary string of arbitrary length. The algorithm uses a weighted average of the Shannon Entropies of the string and all but the last binary derivative of the string. We successfully test the algorithm in the fields of Prime Number Theory (where we prove explicitly that the sequence of prime numbers is not periodic), Human Vision, Cryptography, Random Number Generation and Quantitative Finance. △ Less

Submitted 15 September, 2013; v1 submitted 4 May, 2013; originally announced May 2013.

Comments: 16 Pages, 7 Tables, 6 Colour Figures. Presented at ANPA 34, Rowland's Castle, Hampshire, England, August 2013

Spreadsheets and Long Term Corporate Survival

Authors: Grenville J. Croll

Abstract: We have conducted an empirical investigation into the long term survival rates of some small but representative samples of the 30,000 largest UK limited companies. These companies were either a control or known to have used, or been interested in the use of, spreadsheets, spreadsheet based monte carlo simulation software, other spreadsheet and decision analysis software and/or related management t… ▽ More We have conducted an empirical investigation into the long term survival rates of some small but representative samples of the 30,000 largest UK limited companies. These companies were either a control or known to have used, or been interested in the use of, spreadsheets, spreadsheet based monte carlo simulation software, other spreadsheet and decision analysis software and/or related management training. We show that there is a material and statistically significant increase in the long term survival rate of all of these groups of companies compared to the control. △ Less

Submitted 8 July, 2012; originally announced July 2012.

Comments: 20 Pages, 21 Tables

Journal ref: Proc. European Spreadsheet Risks Int. Grp. (EuSpRIG) 2012 77-96

An Insight into Spreadsheet User Behaviour through an Analysis of EuSpRIG Website Statistics

Authors: Grenville J. Croll

Abstract: The European Spreadsheet Risks Interest Group (EuSpRIG) has maintained a website almost since its inception in 2000. We present here longitudinal and cross-sectional statistics from the website log in order to shed some light upon end-user activity in the EuSpRIG domain. The European Spreadsheet Risks Interest Group (EuSpRIG) has maintained a website almost since its inception in 2000. We present here longitudinal and cross-sectional statistics from the website log in order to shed some light upon end-user activity in the EuSpRIG domain. △ Less

Submitted 20 November, 2011; originally announced November 2011.

Comments: 10 Pages, 5 Tables, 2 Colour Figures, ISBN 978-0-9566256-9-4

Journal ref: Proc. European Spreadsheet Risks Int. Grp. (EuSpRIG) 2011 129-139

A Chronology of Torah Cryptography

Authors: Grenville J. Croll

Abstract: Regarding some papers and notes submitted to, or presented at, the second congress of the International Torah Codes Society in Jerusalem, Israel, June 2000. Regarding some papers and notes submitted to, or presented at, the second congress of the International Torah Codes Society in Jerusalem, Israel, June 2000. △ Less

Submitted 23 January, 2011; originally announced January 2011.

Comments: 10 Pages, 1 Table, 7 Figures

Journal ref: Proc. ANPA 31, 2011, Cambridge, UK

Evaluating Financial Model Performance: An Empirical Analysis of Some North Sea Investments

Authors: Grenville J. Croll, David F. Baker, Ola Lawal

Abstract: Fifty North Sea oil & gas investment transactions were analysed using traditional spreadsheet based financial modelling methods. The purpose of the analysis was to determine if there was a statistically significant relationship between the price paid for an oil & gas asset and the actual or expected financial return over the asset's economically useful life. Several interesting and statistically s… ▽ More Fifty North Sea oil & gas investment transactions were analysed using traditional spreadsheet based financial modelling methods. The purpose of the analysis was to determine if there was a statistically significant relationship between the price paid for an oil & gas asset and the actual or expected financial return over the asset's economically useful life. Several interesting and statistically significant relationships were found which reveal useful information about financial modelling performance, the premia paid to acquire North Sea assets, the contribution oil and gas price uncertainty has on estimates of future financial returns and the median financial return of these North Sea Investments. △ Less

Submitted 22 August, 2010; originally announced August 2010.

Comments: 11 Pages, 1 Table, 5 Figures

Journal ref: Proc. European Spreadsheet Risks Int. Grp. (EuSpRIG) 2010 87-98 ISBN 978-1-905404-50-6

Computers and the Conservation of Energy

Authors: Grenville J. Croll

Abstract: The purpose of this report is to show that computer and allied technologies can be used to increase energy efficiency. The report is divided into transport, industrial, commercial and domestic sections, which correspond to the major energy consuming sectors of the economy. Each section considers the various ways in which energy can be saved by the use of the computer. The report concludes that it… ▽ More The purpose of this report is to show that computer and allied technologies can be used to increase energy efficiency. The report is divided into transport, industrial, commercial and domestic sections, which correspond to the major energy consuming sectors of the economy. Each section considers the various ways in which energy can be saved by the use of the computer. The report concludes that it is economic to incorporate computer based energy management systems in a wide variety of applications and that it is important that this capability is realised on a large scale. A comprehensive reference list and a bibliography are included. △ Less

Submitted 22 April, 2010; originally announced April 2010.

Comments: 28 Pages, Five Figures, Three Tables; Dept. Computer Science, Brunel University, April 1980

Spreadsheets and the Financial Collapse

Authors: Grenville J. Croll

Abstract: We briefly review the well-known risks, weaknesses and limitations of spreadsheets and then introduce some more. We review and slightly extend our previous work on the importance and criticality of spreadsheets in the City of London, introducing the notions of ubiquity, centrality, legality and contagion. We identify the sector of the financial market that we believed in 2005 to be highly depend… ▽ More We briefly review the well-known risks, weaknesses and limitations of spreadsheets and then introduce some more. We review and slightly extend our previous work on the importance and criticality of spreadsheets in the City of London, introducing the notions of ubiquity, centrality, legality and contagion. We identify the sector of the financial market that we believed in 2005 to be highly dependant on the use of spreadsheets and relate this to its recent catastrophic financial performance. We outline the role of spreadsheets in the collapse of the Jamaican banking system in the late 1990's and then review the UK financial regulator's knowledge of the risks of spreadsheets in the contemporary financial system. We summarise the available evidence and suggest that there is a link between the use of spreadsheets and the recent collapse of the global financial system. We provide governments and regulating authorities with some simple recommendations to reduce the risks of continued overdependence on unreliable spreadsheets. We conclude with three fundamental lessons from a century of human error research. △ Less

Submitted 30 August, 2009; originally announced August 2009.

Comments: 17 Pages

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

In Pursuit of Spreadsheet Excellence

Authors: Grenville J. Croll

Abstract: The first fully-documented study into the quantitative impact of errors in operational spreadsheets identified an interesting anomaly. One of the five participating organisations involved in the study contributed a set of five spreadsheets of such quality that they set the organisation apart in a statistical sense. This virtuoso performance gave rise to a simple sampling test - The Clean Sheet T… ▽ More The first fully-documented study into the quantitative impact of errors in operational spreadsheets identified an interesting anomaly. One of the five participating organisations involved in the study contributed a set of five spreadsheets of such quality that they set the organisation apart in a statistical sense. This virtuoso performance gave rise to a simple sampling test - The Clean Sheet Test - which can be used to objectively evaluate if an organisation is in control of the spreadsheets it is using in important processes such as financial reporting. △ Less

Submitted 21 June, 2008; originally announced June 2008.

Comments: 7 pages, 2 tables. To Appear Proc. European Spreadsheet Risks Interest Group, 2008

Algorithmic Permutation of part of the Torah

Authors: Grenville J. Croll

Abstract: A small part of the Torah is arranged into a two dimensional array. The characters are then permuted using a simple recursive deterministic algorithm. The various permutations are then passed through three stochastic filters and one deterministic filter to identify the permutations which most closely approximate readable Biblical Hebrew. Of the 15 Billion sequences available at the second level of… ▽ More A small part of the Torah is arranged into a two dimensional array. The characters are then permuted using a simple recursive deterministic algorithm. The various permutations are then passed through three stochastic filters and one deterministic filter to identify the permutations which most closely approximate readable Biblical Hebrew. Of the 15 Billion sequences available at the second level of recursion, 800 pass the a priori thresholds set for each filter. The resulting "Biblical Hebrew" text is available for inspection and the generation of further material continues. △ Less

Submitted 19 October, 2010; v1 submitted 16 December, 2007; originally announced December 2007.

Comments: 10 Pages. Presented at the Second Conference of the International Torah Codes Society, Jerusalem, Israel, 6th June 2000. Minor updates and added Appendix B in version 2, October 2010

ACM Class: E.3

Journal ref: Proc. ANPA 27, Wesley College, Cambridge, UK, September 2005

Some A Priori Torah Decryption Principles

Authors: Grenville J. Croll

Abstract: The author proposes, a priori, a simple set of principles that can be developed into a range of algorithms by which means the Torah might be decoded. It is assumed that the Torah is some form of transposition cipher with the unusual property that the plain text of the Torah may also be the cipher text of one or more other documents written in Biblical Hebrew. The decryption principles are based… ▽ More The author proposes, a priori, a simple set of principles that can be developed into a range of algorithms by which means the Torah might be decoded. It is assumed that the Torah is some form of transposition cipher with the unusual property that the plain text of the Torah may also be the cipher text of one or more other documents written in Biblical Hebrew. The decryption principles are based upon the use of Equidistant Letter Sequences (ELS) and the notions of Message Length, Dimensionality, Euclidean Dimension, Topology, Read Direction, Skip Distance and offset. The principles can be applied recursively and define numerous large subsets of the 304,807! theoretically possible permutations of the characters of the Torah. △ Less

Submitted 16 December, 2007; originally announced December 2007.

Comments: 11 Pages. Presented at the 2nd conference of the Int. Torah Codes Society, Jerusalem, Israel, 5th June 2000

ACM Class: E.3

Journal ref: Proc. ANPA Cambridge, UK, 2007

A Typical Model Audit Approach: Spreadsheet Audit Methodologies in the City of London

Authors: Grenville J. Croll

Abstract: Spreadsheet audit and review procedures are an essential part of almost all City of London financial transactions. Structured processes are used to discover errors in large financial spreadsheets underpinning major transactions of all types. Serious errors are routinely found and are fed back to model development teams generally under conditions of extreme time urgency. Corrected models form the… ▽ More Spreadsheet audit and review procedures are an essential part of almost all City of London financial transactions. Structured processes are used to discover errors in large financial spreadsheets underpinning major transactions of all types. Serious errors are routinely found and are fed back to model development teams generally under conditions of extreme time urgency. Corrected models form the essence of the completed transaction and firms undertaking model audit and review expose themselves to significant financial liability in the event of any remaining significant error. It is noteworthy that in the United Kingdom, the management of spreadsheet error is almost unheard of outside of the City of London despite the commercial ubiquity of the spreadsheet. △ Less

Submitted 16 December, 2007; originally announced December 2007.

Comments: 5 Pages

ACM Class: J.1; H.4.1; K.6.4; D.2.9

Journal ref: IFIP, Integrity and Internal Control in Information Systems, Vol 124, pp. 213-219, Kluwer, 2003

Spreadsheets in Clinical Medicine

Authors: Grenville J. Croll, Raymond J. Butler

Abstract: There is overwhelming evidence that the continued and widespread use of untested spreadsheets in business gives rise to regular, significant and unexpected financial losses. Whilst this is worrying, it is perhaps a relatively minor concern compared with the risks arising from the use of poorly constructed and/or untested spreadsheets in medicine, a practice that is already occurring. This articl… ▽ More There is overwhelming evidence that the continued and widespread use of untested spreadsheets in business gives rise to regular, significant and unexpected financial losses. Whilst this is worrying, it is perhaps a relatively minor concern compared with the risks arising from the use of poorly constructed and/or untested spreadsheets in medicine, a practice that is already occurring. This article is intended as a warning that the use of poorly constructed and/or untested spreadsheets in clinical medicine cannot be tolerated. It supports this warning by reporting on potentially serious weaknesses found while testing a limited number of publicly available clinical spreadsheets. △ Less

Submitted 3 October, 2007; originally announced October 2007.

Comments: 10 Pages including references

ACM Class: J.3; K.8.1

Journal ref: Proc. European Spreadsheet Risks Int. Grp. 2006 7-16

The Importance and Criticality of Spreadsheets in the City of London

Authors: Grenville J. Croll

Abstract: Spreadsheets have been with us in their present form for over a quarter of a century. We have become so used to them that we forget that we are using them at all. It may serve us well to stand back for a moment to review where, when and how we use spreadsheets in the financial markets and elsewhere in order to inform research that may guide their future development. In this article I bring toget… ▽ More Spreadsheets have been with us in their present form for over a quarter of a century. We have become so used to them that we forget that we are using them at all. It may serve us well to stand back for a moment to review where, when and how we use spreadsheets in the financial markets and elsewhere in order to inform research that may guide their future development. In this article I bring together the experiences of a number of senior practitioners who have spent much of their careers working with large spreadsheets that have been and continue to be used to support major financial transactions and manage large institutions in the City of London. The author suggests that the City of London is presently exposed to significant reputational risk through the continued uncontrolled use of critical spreadsheets in the financial markets and elsewhere. △ Less

Submitted 20 February, 2008; v1 submitted 25 September, 2007; originally announced September 2007.

Comments: 11 pages, with references

ACM Class: J.1; H.4.1; K.6.4; D.2.9

Journal ref: Proc. European Spreadsheet Risks Int. Grp. (EuSpRIG) 2005 82-92 ISBN:1-902724-16-X