Excel在高速公路桥梁病害定期调查方面的应用

The application of Excel in the regular surveys of disease of highway bridges

桥梁的病害随着通车年数日趋严重,桥梁的定期观察与技术状况等级评定显得尤为重要。为了更好更高效更有针对性的做好定期调查,结合计算机中office软件中的excel表格功能,制作出直观可视化的定期调查表格。通过每次的定期调查汇总,可以不用到现场,便可以了解桥梁的基本信息、初步判定桥梁的病害等级、做好应对由桥梁病害所引发的交通突发事件、观察桥梁病害形成的原因与趋势等。从而对高速公路养护工作带来一定的便利。

Along with the highway opening time increases, the bridges disease of a highway becomes more serious, and it is more important to have investigations and evaluation for the bridges＇ working condition and disease class. In order to have accurate and efficient regular surveys, a tabulated program was created on base of Excel for intuitive visualized form of regular surveys in front of a computer. By summary of the regular surveys, we can know and judge the basic information about the initial level of disease of bridge and to assessment of the bridge conditions, get prepared to deal with diseases caused by the bridge traffic incident, can observe the formation of the bridge causes and trends in disease and so on. The usage of the Excel brings much convenience for highway maintenance work.