Monte Carlo simulation using Excel(R) spreadsheet for predicting reliability of a complex system

Gedam, Subhash G.; Beaudet, S.T.

doi:10.1109/rams.2000.816305

Cited by 15 publications

(9 citation statements)

References 1 publication

Supporting

Mentioning

Contrasting

Unclassified

Order By: Relevance

“…In the literature, the applications of spreadsheets for the MC calculations are known. Excel (Microsoft, Redmond, WA, USA) has been used, among others, for predicting the reliability parameters by Gedam and Beaudet [ 30 ], and for the evaluation of uncertainties in grating the pitch measurement by Decker et al [ 31 ]. However, they have applied macros that require some programming skills.…”

Section: Resultsmentioning

confidence: 99%

Measurement Uncertainty Calculations for pH Value Obtained by an Ion-Selective Electrode

Wiora

2018

Sensors

View full text Add to dashboard Cite

An assessment of measurement uncertainty is a task, which has to be the final step of every chemical assay. Apart from a commonly applied typical assessment method, Monte Carlo (MC) simulations may be used. The simulations are frequently performed by a computer program, which has to be written, and therefore some programming skills are required. It is also possible to use a commonly known spreadsheet and perform such simulations without writing any code. Commercial programs dedicated for the purpose are also available. In order to show the advantages and disadvantages of the ways of uncertainty evaluation, i.e., the typical method, the MC method implemented in a program and in a spreadsheet, and commercial programs, a case of pH measurement after two-point calibration is considered in this article. The ways differ in the required mathematical transformations, degrees of software usage, the time spent for the uncertainty calculations, and cost of software. Since analysts may have different mathematical and coding skills and practice, it is impossible to point out the best way of uncertainty assessment—all of them are just as good and give comparable assessments.

show abstract

Section: Resultsmentioning

confidence: 99%

Measurement Uncertainty Calculations for pH Value Obtained by an Ion-Selective Electrode

Wiora

2018

Sensors

View full text Add to dashboard Cite

show abstract

“…where λ is the reciprocal of the component MTTF and F is, for any sample to be generated, a random number in (0, 1) get by Monte Carlo method (Gedam et al 2000, Bozzo et al 2003. The Monte Carlo based approach has been adopted by the authors due to its flexibility, as it allows to carry out the failure analysis for components whose TTF (or TTR) is characterised by any distribution (exponential, Weibull, lognormal, …).…”

Section: The Innovative Simulation Toolmentioning

confidence: 99%

Estimate Of Components Reliability And Maintenance Strategies Impact On Trains Delay

Dazzi

Savio²,

Firpo³

2007

ECMS 2007 Proceedings Edited By: I. Zelinka, Z. Oplatkova, A. Orsoni

View full text Add to dashboard Cite

In this paper the authors present a procedure for estimating the impact of design choices, dealing with subsystems architecture, basic components reliability performances or maintenance policies, on the service quality provided by a railway or metro system. The procedure is based on the use of an innovative modular simulator, developed by the authors. Through a Monte Carlo approach and a suitable post-processing of the results of the simulated samples, the tool provides the user with a set of indicators for estimating the service quality and the effectiveness of different traffic and fleet management policies, as well as maintenance strategies, in both rated and degraded operating conditions.

show abstract

“…Muchos autores han apostado por utilizar hojas de cálculo para realizar simulación Montecarlo (Seila 2001;Evans 2000;Gedam y Beaudet 2000). La potencia de las hojas de cálculo reside en su universalidad, en su facilidad de uso, en su capacidad para recalcular valores y, sobre todo, en las posibilidades que ofrece con respecto al análisis de escenarios (what-if análisis).…”

Section: La Simulación Como Una Alternativa Más Viable a Los Modelos unclassified

Modelos ecónomico-matemáticos y simulaciones: dos pilares fundamentales de apoyo a la gestión y la adopción de decisiones en el sector público

Ene¹

2003

GAPP

View full text Add to dashboard Cite

show abstract

Monte Carlo simulation using Excel(R) spreadsheet for predicting reliability of a complex system

Cited by 15 publications

References 1 publication

Measurement Uncertainty Calculations for pH Value Obtained by an Ion-Selective Electrode

Measurement Uncertainty Calculations for pH Value Obtained by an Ion-Selective Electrode

Estimate Of Components Reliability And Maintenance Strategies Impact On Trains Delay

Modelos ecónomico-matemáticos y simulaciones: dos pilares fundamentales de apoyo a la gestión y la adopción de decisiones en el sector público

Contact Info

Product

Resources

About