This work shows how Excel can be leveraged to tackle configuration problems. We demonstrate this by presenting the full development cycle of a PC-configurator prototype. We articulate our demonstration by exemplifying several important points. First, Excel can be used to import raw products and services data. Second, these data can be used by a constraint modelling to correctly instantiate a se...

Microsoft attempted to implement theWichmann–Hill RNG in Excel 2003 and failed; it did not just produce numbers between zero andunity, itwould also produce negative numbers. Microsoft issued a patch that allegedly fixed the problem so that the patched Excel 2003 and Excel 2007 now implement the Wichmann–Hill RNG, as least according to Microsoft. We show thatwhatever RNG it is thatMicrosoft has ...

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 describ...

This article shows ways in which Excel can be used to explore the Goldbach Conjecture. We first show an elementary approach in which the Goldbach Comet is constructed by means of a table of values. Second, we give two simple VBA programs that generate substantially more data for the Goldbach Comet. We then show how the Comet can be seen as the agglomeration of individ...