用迭代法实现《石油计量表》转换EXCEL上的应用

Realization of Converting the "Petroleum Measurement Meter" into EXCEL by Iterative Method

上世纪80年代,美国石油学会(API)、英国石油学会(IP)和美国材料与试验协会(ASTM)合作开发了石油计量表,明确指出石油产品各个类别在基准温度下其膨胀系数与基准温度下的密度之间存在的数学关系,并制订形成API Standard 2540、IP 200、ASTM-D1250系列标准。后来,这些标准得到国际标准ISO-91/1的支持。现行标准GB/T1885-1998《石油计量表》1998年6月获国家质量技术监督局批准,1999年3月实施。该标准引用国际标准ISO-91/1石油计量表第一部分(以15℃和60℉为标准温度的表),采用20℃作为标准温度,主要包括标准密度表和体积修正系数表两部分,按照原油、石油产品和润滑油分别建表。介绍了如何用计算机办公软件实现《石油计量表》的自动换算功能。

In the 1980s, the American Petroleum Institute （API）, the British Institute of Petroleum （IP） and the American Society for Testing and Materials （ASTM） developed the petroleum measurement meter, and mathematical relationship between expansion coefficient and density of petroleum products under reference temperature was pointed out, and standards of API Standard 2540, IP 200, ASTM-D1250 were formulated. Later, these standards were supported by the international standard ISO-91/1. Current standard GB/T1885-1998＂petroleum measurement meter＂was approved by the State Quality and Technical Supervision in June 1998, was implemented in March 1999. The standard referenced to the first part of the international standard ISO-91/1 petroleum measurement meter （using 15 ℃and 60 ℉ as standard temperature）, used 20 ℃ as standard temperature, included two parts of standard density meter and volume correction factor, the tables of the crude oil, petroleum products and lubricants were respectively built. In this article, how to use office software to realize automatic conversion of the＂petroleum measurement meter＂was discussed.