- 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

- 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

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

Crude Oil Density Conversion to 15 deg C and Volume Calculation App as per Petroleum tables ASTM 53A and 54A

-
Image
Crude Oil Density conversion to 15 C from observed temperature as per ASTM 53A  and volume Correction as per Petroleum tables ASTM 54A using an App developed. The App developed converts a) Density at 15 Deg C from observed density and temperature and b) calculates the bulk volume from natural to volume at 15 deg C, US barrels at 60 deg F and weight in MT. Large volume of crude moves from production to user refineries globally. Oil Industry uses ASTM tables published by API/IP/ASTM  to account Oil quantity on board of the tankers for calculating quantity.  Following publication is in IS system where mass is in Kg, volume is in Kg/Cu.M and temperature is in Centigrade and followed most of Europe, Asia, Africa & Commonwealth countries with standard temperature as 15 deg C. It may be noted that the above tables ASTM 53 A and 54 A are for Crude oil and not for refined petroleum products for which there are different ASTM tables for Corrections. See different Apps suiting
Read more