Efficient Reliability Evaluation Using Spreadsheet
Publication: Journal of Engineering Mechanics
Volume 123, Issue 7
Abstract
A practical method using spreadsheets is proposed for calculating the Hasofer-Lind second moment reliability index β. Two example problems involving correlated normals and correlated nonnormals, respectively, are solved and compared with established mathematical approach. The proposed method is based on the perspective of an ellipsoid that is tangent to the failure surface in the original space of the random variables; concepts of transformed space or reduced variates are not required. Correlation is accounted for by setting up the quadratic form in the spreadsheet. Nonnormals are dealt with using established relationships between nonnormal distribution and its equivalent normal distribution. Iterative searching is performed automatically by invoking a spreadsheet's optimization tool. An advantage of the spreadsheet method is that partial derivatives are not part of the input; the method may therefore be especially attractive for cases with complicated or nonexplicit performance functions.
Get full access to this article
View all available purchase options and get full access to this article.
References
1.
Ang, A. H.-S., and Tang, W. H. (1975). Probability concepts in engineering planning and design, Vol. I, basic principles. John Wiley and Sons, Inc., New York.
2.
Ang, A. H.-S., and Tang, W. H. (1984). Probability concepts in engineering planning and design, Vol. II, decision, risk, and reliability. John Wiley and Sons, Inc., New York.
3.
Dai, S. H., and Wang, M. O. (1992). Reliability analysis in engineering applications. Van Nostrand Reinhold, New York.
4.
Ditlevsen, O. (1981). Uncertainty modeling with applications to multidimensional civil engineering systems. McGraw-Hill Book Co., Inc., New York.
5.
Hasofer, A. M., and Lind, N.(1974). “An exact and invariant first-order reliability format.”J. Engrg. Mech., ASCE, 100(1), 111–121.
6.
Low, B. K. (1996). “Practical probabilistic approach using spreadsheet.”Proc., Uncertainty in Geologic Environment from Theory to Practice, ASCE Geotech. Spec. Publ. 58, Vol. 2, 1284–1302.
7.
Low, B. K. (1997). “Reliability analysis of rock wedges.”J. Geotech. Engrg., ASCE, 123(6).
8.
Madsen, H. O., Krenk, S., and Lind, N. C. (1986). Methods of structural safety. Prentice-Hall, Inc., Englewood Cliffs, N.J.
9.
Melchers, R. E. (1987). Structural reliability: analysis and prediction. Ellis Horwood Ltd., Chichester, West Sussex, England.
10.
Rackwitz, R. (1976). “Practical probabilistic approach to design.”Bull. 112, Comite European du Beton, Paris.
11.
Shinozuka, M.(1983). “Basic analysis of structural safety.”J. Struct. Engrg., ASCE, 109(3), 721–740.
12.
Tichy, M. (1993). Applied methods of structural reliability. Kluwer Academic Publishers Group, Boston, Mass.
13.
Veneziano, D. (1974). “Contributions to second moment reliability.”Res. Rep. No. R74-33. Dept. of Civ. Engrg., Mass. Inst. of Technol., Cambridge, Mass.
Information & Authors
Information
Published In
Copyright
Copyright © 1997 American Society of Civil Engineers.
History
Published online: Jul 1, 1997
Published in print: Jul 1997
Authors
Metrics & Citations
Metrics
Citations
Download citation
If you have the appropriate software installed, you can download article citation data to the citation manager of your choice. Simply select your manager software from the list below and click Download.