- 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

Post a Comment

Popular posts from this blog

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

-
Image
Density conversion to any temperature say 20 C, 15 C or any desired temperature from any observed temp Some of the countries like Russian block follow standard temperature 20 deg C as compared to Commonwealth countries which have standard temperature 15 deg C.  The calculator developed for conversion of Density from observed temperature to 20C or 15C or any desired temperature is thus very handy.   It may be noted that the calculator is for finished petroleum products and uses ASTM tables 1952 version for this conversion. For Excel Worksheet you may contact by email to  rjpatelioc2014@gmail.com and specify your clear requirement as per the title of this post. Follow me on twitter @RJPatel13 to get notification when my new post is available in my blog. Author's Profile List of all blog articles on Petroleum QC  by RJ Patel.
Read more

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

-
- Temperature around 15 deg C,    - Density Conversion for Petroleum Products from observed temperature to 15 C without use of  ASTM Table List of all blog articles on Petroleum QC  by RJ Patel. Lists of Android/iOs Apps developed on Petroleum Calculation - see here.      (These apps convert 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.) One follower from Kiev, Ukraine  has requested the formula for the subject conversion. The post gives a simple way to convert Density of petroleum products from ambient temperature  ( say 15 +/-7  deg C  )  to density at 15 Deg C, in line with ASTM table 53B,  without using these table and in the field with simple calculation. See my earlier post dated 18 Dec 2016, for detail description of the procedure explained there. For areas in Norther Europe,  Canada,  Russia,  China and southern hemisphere New Zealand,  Southern Australia etc  where winter t
Read more

Android/iOS apps for Petroleum Calculation

-
List of Android/iOS apps on Petroleum Calculation  App for Jet A-1 Density Conversion to 15 deg C as per ASTM 53B  App for Aviation products Density Conversion to 20 deg C as per ASTM 53B     App for Petroleum Products Density Conversion to 15 Deg C as per ASTM 53B  App for Gasoline - Diesel for Density Conversion to 20 Deg C as per ASTM 53B     App for Crude Oil Density Conversion as per ASTM 53A and Volume correction as per ASTM 54A  Crude Oil  API Gravity Conversion  to 60 deg F and Volume Calculation App as per  Petroleum tables ASTM 5A and 6A Petroleum Products API Gravity Conversion  to 60 deg F and Volume Calculation App as per  Petroleum tables ASTM 5B and 6B.   LPG density Conversion from observed temperature to 15 C and also to 20 C.   An App for Calculation of Vapor pressure of Liquefied Petroleum (LP) Gases from Compositional Analysis based on ASTM D2598.    An App for calculation of Relative Density of LPG from Compositional Analysis based on
Read more