VLOOKUP函数在仪表工程设计中的应用

针对仪表工程设计中,工艺数据需要在仪表相关文件中反复使用的情况,提出一种应用Excel函数解决反复人工录入工作的方法。论文介绍了Excel VLOOKUP函数与工艺条件、仪表规格数据表、仪表报警联锁值表的有机结合,方便快捷的完成了对工艺数据自动录入,提高了设计效率。希望本方法可以为减轻设计人员工作量,为新时期工程项目的设计提供新思路。

Aiming at solving the problem of process data to be used repeatedlyin instrument related documents,a method of using Excel VLOOKUP function is put forwarded. The way of using Excel VLOOKUP function in the process conditions,instrument specification and instrument alarm and interlock datasheet is introduced.We can input the process data automatically,We hope that this method can greatly improve the instrument engineering design efficiency,reduce the workload of engineers and provide new ideas of engineering design in recent projects.