EXCEL函数在管道特性表中的应用

The Application of Excel Function in Line Description Table

文章描述对EXCEL表格中自带的函数分析和利用,针对管道特性表中的如管道规格、设计温度、设计压力、探伤比例等属性,编写简短实用的函数程序,利用小型数据库,使上述管道属性自动生成,避免工程师逐一判断确定上述属性出现的错误及减少人工时,明显提高工作效率和准确性。

The paper describes the analysis and utilization of Excel function and writes a short program of practical function with using a small database. The program makes the attributes of line description table such as piping specifications, design temperature; design pressure automatically generated and avoids errors by engineer. The programs significantly improve the efficiency and accuracy.