- Excel Formula-Density Conversion to 15 deg C, table ASTM 53 B - 1980,

- Excel Formula-Density Conversion to 15 deg C,  table ASTM 53 B - 1980,   

Excel sheet giving the Density 15 deg C figures from given observed Density and observed temperature for petroleum product as derived from ASTM tables 53 B.

Density conversion to 15 deg C matches exactly with the ASTM conversion tables 1980.

Lists of Android/iOs Apps developed on Petroleum Calculation - see here.    (These apps convert Density/API gravity exactly as per ASTM tables 5a, 5b, 6a, 6b, 23a,23b, 24a,24b, 53a,53b, 54a,54b to standard temperature 15 C,  20 C and 60 F.)

  Example:  Observed density is 792 kg/Cu. M and observed temperature is 29 deg C. Corresponding 15 deg C for this set of data comes 802.2 kg/Cu. M


Excel Worksheet - green color cells  observed density and observed sample temperature are variables and Red color digits are the answer - density at 15 deg C. 

Apps developed on Petroleum Calculations - see here.

Density Conversion from observed temperature to 15 deg C using Excel Sheet has following fixtures/benefits:
a)   Accurate as per the ASTM Density Conversion table 53B (1980).
b)   Can be used in Mobile Phone or Laptop/Desktop.
c)    Avoids manual human error in reading ASTM Book table/Conversion formula disk.
d)   Far Simpler than using the charts & formula wheel to work out conversions.
e)   Very very convenient to use in the field say at Airport tarmac for refuelling aircraft, receiving/despatching tank trucks, marine tanker loading/unloading, pipeline samples density conversions, etc where ASTM Conversion charts are cumbersome to be carried/use and likely human error may occur, leading to costly consequences.


If interested, you can obtain the above excel worksheet thru email -  rjpatelioc2014@gmail.com

See also -  Patel's Density Conversion for Petroleum Products from observed temperature to 15 C without use of  ASTM Table

Author's Profile
List of all blog articles on Petroleum QC  by RJ Patel.
**************************************************************************

Comments

Popular posts from this blog

- Temperature around 15 deg C, - Density Conversion for Petroleum Products from observed temperature to 15 C without use of ASTM Table (1980 series)

Density conversion to any temperature say 20 C, 15 C or any desired temperature from any observed temp

Android/iOS apps for Petroleum Calculation