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

Without the cold-chain network, it would be impossible in today's world to transport large quantities of perishable goods, primarily food and medicine, over long distances, but is still very important that necessary materials reach their destination on time with adequate cooling. This absolutely true for vaccines created stop Covid-19 pandemic, which had distributed quickly at certain storage t...

O papel da logística é atender as exigências dos clientes entregando o produto certo, no lugar na hora certa. Frente a essa questão, torna-se inevitável importância que concerne ao transporte, uma das atuações logística. Nesse sentido, esse trabalho trata do clássico problema de transporte em almeja minimização custos favorece competitividade vários elos cadeia suprimentos. Diante disso, será a...

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