- Kin. Viscosity Gasoil Excel Calculator

-

- Kin. Viscosity Gasoil Excel Calculator

Kin. Viscosity of petroleum products is not an additive property.

Earlier on 25/03/2017,  calculation of Kin. Viscosity of blend product was posted showing examples.

Now,  calculator in excel form is given below:

Step 1 -  Fill quantity of stock 1 and stock 2 columns
Step 2-   Fill individual Kin. Viscosity, in cSt .  Remember,  temperature should be identical.

See the blended calculated Kin. Viscosity in yellow colour column.

Kin. Viscosity Blending Calculator
Property
Unit
Blend
Stock 1
Stock 2





Quantity
KL
10000
2000
8000





Kin. Visc
Cst
4.025
2.800
4.400
  
Above is illustration only. For excel file, may approach by email.

Follow me on twitter @RJPatel13 to get notification when my new post is available in my blog.

List of all blog articles on Petroleum QC  by RJ Patel.

Comments

Post a Comment

Popular posts from this blog

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

-
Image
- 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 us
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

- 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