• Corpus ID: 17674998

Identification of Logical Errors through Monte-Carlo Simulation

@article{Emmett2010IdentificationOL,
  title={Identification of Logical Errors through Monte-Carlo Simulation},
  author={Hilary L. Emmett and Lawrence I. Goldman},
  journal={ArXiv},
  year={2010},
  volume={abs/1001.4299}
}
The primary focus of Monte Carlo simulation is to identify and quantify risk related to uncertainty and variability in spreadsheet model inputs. The stress of Monte Carlo simulation often reveals logical errors in the underlying spreadsheet model that might be overlooked during day-to-day use or traditional "what-if" testing. This secondary benefit of simulation requires a trained eye to recognize warning signs of poor model construction. 
3 Citations
Digital Traceability Through Production Value Chain
TLDR
By using digital traceability technologies in production value chain, redundant inventory and production costs, redundant labour costs caused by inefficient production activities, inaccuracies of records, incorrect order deliveries and penalty costs incurred by customers could be significantly reduced, which provides invaluable advantages in the real life competition of the productions systems.
Technology Project Portfolio Selection in Industry 4.0
TLDR
The proposed model incorporates two important goals: profit maximization by selecting technology projects and the development of simulation-based optimization with a three-step stage-gate model for technology project portfolio management under conditions such as resources, costs, and the probabilities of completion of stages and success.

References

SHOWING 1-2 OF 2 REFERENCES
A risk and control-oriented study of the practices of spreadsheet application developers
  • M. Hall
  • Computer Science
    Proceedings of HICSS-29: 29th Hawaii International Conference on System Sciences
  • 1996
TLDR
The significance to the management of end-user computing of tolerating a high level of risk is discussed and the need for an end- user spreadsheet control model is established.
“ Spreadsheet testing using interval analysis ” , Klagenfurt University
  • 2001