利用Excel实现《JJG 266-2018卧式金属罐容量》容量比较法罐容表计算  

Excel Application in Calculation of Tank Capacity Table by Capacity Comparison Method in “Horizontal Metal Tank Capacity(JJG 266-2018)”

作　　者：孙大圣 Sun Dasheng

机构地区：[1]中石油海南销售有限公司,海南海口570100

出　　处：《石油库与加油站》2023年第5期32-35,M0004,共5页Oil Depot And Gas Station

摘　　要：针对国家市场监督管理总局2018年12月发布,2019年6月25日开始实施的《JJG 266-2018卧式金属罐容量检定规程》新增的容量比较法测量油罐容积表存在局限性的问题,通过研究并结合工作实际,利用Excel函数功能实现三次样条插值,较好地解决了油罐测量时液位非严格等距升高带来的误差。In response to the limitations of the capacity comparison method for measuring the volume table of oil tanks,which was newly added to the“Horizontal Metal Tank Capacity Verification Regulations(JJG 266-2018)”issued by the State Administration for Market Regulation in December 2018 and implemented on June 25,2019,through research and practical work,cubic spline interpolation was achieved using the Excel function,which can effectively solve the error caused by non-strict equidistant liquid level rise during oil tank measurement.

关 键 词：加油站 油罐 容积 计算 容量比较法 EXCEL 应用 

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