路基工程Issue(2)：38-41,4.
运用Excel建立路面性能马尔可夫预测模型
Application of Excel for Establishment of Markov Model for Prediction of Pavement Performance
叶操 1苏卫国1
作者信息
- 1. 华南理工大学土木与交通学院,广州510640
- 折叠
摘要
Abstract
Based on the pavement performance data of certain test highway and combined with the solver of Microsoft Office Excel sheet, the exponential regression equation of pavement performance index curve is established; and the matrix of status transition probability is calculated through the fitting exponential regression equation. Then according to the known probability distribution of initial pavement status, the probability distribution of pavement performance at certain time could be obtained for the final purpose of prediction of pavement performance at this time. It is known through analysis that the Markov Model could be establish conveniently with Microsoft Office Excel sheet and operated simply; moreover, it is capable of prediction of pavement performance well and has good application prospect in practical engineering.关键词
马尔可夫模型/ExcelSolver/路面性能Key words
Markov Model/Excel solver/pavement performance分类
交通工程引用本文复制引用
叶操,苏卫国..运用Excel建立路面性能马尔可夫预测模型[J].路基工程,2012,(2):38-41,4.
