Excel在储运工程设计中的应用  

APPLICATION OF EXCEL IN STORAGE AND TRANSPORTATION ENGINEERING DESIGN

作　　者：吴华丽[1] 陈坤明[1] 金丽[2] 

机构地区：[1]西南石油大学,四川成都610500 [2]大庆油田有限责任公司第八采油厂规划设计研究所,黑龙江大庆163113

出　　处：《石油工业计算机应用》2007年第2期46-48,共3页Computer Applications Of Petroleum

摘　　要：利用Excel对数据快速填充、分析处理和规划求解等功能,本文将其应用到油气储运工程设计中的四个子问题:油气消费预测、油库成品油配送的优化调度、长输管道的线路优选和管网的布局优化以及输油、输气管网的水力计算。实例应用表明:Excel可以较好解决储运工程中的规划设计问题,求解过程快捷、简洁。Excel has many functions such as fast data filling in, analysis processing and programming derivation, etc. In the paper, four aspects of its application in oil-gas storage and transportation engineering design are formulated: oil-gas consumption prediction, optimized dispatch of refined oil delivery in oil storage depot, optimized line for long pipeling transportation and layout of pipe network and hydraulic calculation of gas line network. Practical applications show that Excel can solve planning and design problems in storage and transportation engineering better. The process is simple and fast.

关 键 词：EXCEL 储运工程 消费预测 优化调度 布局优化 水力计算 

分 类 号：TE978[石油与天然气工程—石油机械设备]