Recent Topics
2017 Honda Civic 1.5T, factory fill, 2977miles
by researcher
05/26/17 10:05 PM
Gutter Guards?
by Gebo
05/26/17 08:59 PM
75w90 recommendations for GM AWD
by HOG
05/26/17 07:09 PM
Lifespan of Maxima Castor 927 once mixed.
by Surestick
05/26/17 07:04 PM
mPerks $10.00 of $50.00 auto dept
by fdcg27
05/26/17 06:22 PM
VW Diesel Band
by redbone3
05/26/17 04:52 PM
2006 PT Cruiser Under-cover Pics - Seal R&R
by DoubleWasp
05/26/17 03:40 PM
Dealer put in wrong oil?
by fafafooey
05/26/17 02:43 PM
07' CTS V6 ATF & Power Steering
by TX_1821
05/26/17 01:49 PM
Strange Telephone Behavior
by oilpsi2high
05/26/17 01:42 PM
How important is heat cycling when breaking in an
by 5AcresAndAFool
05/26/17 12:46 PM
Fumoto 10% off $100 or $10 off over $100
by knnaz392
05/26/17 12:39 PM
PCV screwed into crankcase rather than valve cover
by friendly_jacek
05/26/17 12:19 PM
Fram Tough Guard 3614 Cut Open- internal damage
by 5AcresAndAFool
05/26/17 12:16 PM
Traveller 5w30 SYNTHETIC
by Vlad_the_Russian
05/26/17 11:47 AM
Basic Description of Lubricant Films
by MotoTribologist
05/26/17 10:29 AM
Harvest King All-Fleet 15W-40 VOA
by SmrtJustin
05/26/17 10:18 AM
Ecopia with a front bulge
by nicholas
05/26/17 09:22 AM
How Do Univ. ATF's Meet Many Specs.?
by doitmyself
05/26/17 08:30 AM
Berkeley Professor arrested for Assault.
by pbm
05/26/17 07:28 AM
Newest Members
Harleyman08, DannyWatts, TX_1821, TwoDogs, AoS810
61670 Registered Users
Who's Online
52 registered (A310, ammolab, another Todd, 555, 2004tdigls, andyd, 1 invisible), 1772 Guests and 11 Spiders online.
Key: Admin, Global Mod, Mod
Forum Stats
61670 Members
66 Forums
265644 Topics
4390265 Posts

Max Online: 3590 @ 01/24/17 08:07 PM
Donate to BITOG
Topic Options
#2897415 - 02/06/13 01:22 PM Blending Viscosities Calculator
jstutz Offline


Registered: 10/06/08
Posts: 1547
Loc: NC
Guys, a few years ago i put this calculator together , in excel, to share with BITOG Members. Some of the information in it is outdated but the tool is still very handy. I have seen a lot of posts asking questions about viscosity, blending different oils, and cold weather performace of particular oils. Please keep in mind that the equations used have higher error ratios as you go further from the numbers that you input. Anyway take a look at it and if you have any questions or comments please PM me as i have been very busy and may loose site of the post. Ill try the best i can to answer any questions should there be any.

https://docs.google.com/file/d/0B6pXF6fW...dit?usp=sharing

Top
#2897418 - 02/06/13 01:24 PM Re: Blending Viscosities Calculator [Re: jstutz]
jstutz Offline


Registered: 10/06/08
Posts: 1547
Loc: NC
One side note. Google has there own viewer and the equations do not work with it. You have to actually download the .xls file then modify it as you wish.

Also i should list what the tool does.

It will:
Graph up to three different oils
calculate VI from known viscosities
Allow you to blend two different oils and see the resulting viscosity from the misture.

You will need basic information such as 40 and 100C viscosity in cSt.


Edited by jstutz (02/06/13 01:28 PM)

Top
#2897459 - 02/06/13 01:57 PM Re: Blending Viscosities Calculator [Re: jstutz]
Brule Offline


Registered: 11/12/12
Posts: 423
Loc: St. Louis, Mo
Nice to be able to use a calculator offline...Thanks!
_________________________
2014 Camry V6 SE (QSUD 5w20)
2003 Civic Si [sold]
2010 Frontier SE 4.0 [gone]
2006 BMW M Coupe [sold]

Top
#2897464 - 02/06/13 02:04 PM Re: Blending Viscosities Calculator [Re: jstutz]
LeakySeals Offline


Registered: 02/18/11
Posts: 5976
Loc: Hudson, NH
I just opened with "Google sheets". trying it out, thanks.
_________________________
06 Escalade 6.0L AWD 147k. Edge EP FTG
03 Maxima 3.5L Unknown miles supertech 10w30

Top
#2897474 - 02/06/13 02:08 PM Re: Blending Viscosities Calculator [Re: jstutz]
jstutz Offline


Registered: 10/06/08
Posts: 1547
Loc: NC
I have not got it to work in google sheets. The graphs dont come in when i use google sheets

Top
#2897533 - 02/06/13 03:01 PM Re: Blending Viscosities Calculator [Re: jstutz]
Donald Offline


Registered: 03/21/04
Posts: 18518
Loc: Upstate NY
But this just does it for virgin oil. What about oil with 100 hours or 1000 hours. There is plenty of good oil available at various weights, do not see the point in mixing.
_________________________
2015 Subaru Forester 2.5 engine/CVT
2015 Ford F250 w/Powerstroke
2016 Subaru Crosstrek CVT (wife's)


Top
#2897547 - 02/06/13 03:13 PM Re: Blending Viscosities Calculator [Re: Donald]
LeakySeals Offline


Registered: 02/18/11
Posts: 5976
Loc: Hudson, NH
For old engines like mine. A couple of quarts 5w30 for starts, some 10w40 for highway oil burning. It likes blends, I can tell by the idle and the vvt-i ticking or lack of. His sheet tells me which way to blend by qt for summer and winter.
_________________________
06 Escalade 6.0L AWD 147k. Edge EP FTG
03 Maxima 3.5L Unknown miles supertech 10w30

Top
#2897610 - 02/06/13 03:58 PM Re: Blending Viscosities Calculator [Re: jstutz]
HTSS_TR Offline


Registered: 04/17/06
Posts: 19528
Loc: Lake Forest, CA
Using the calculator to check 3 Mobil 1 grades: 0W20, 0W30 and 0W40.

As expected, M1 0W20 at 80C(13.4 cSt) is as thick as 0W30(13.6 cSt) at 90C and 0W40 at 100C(13.5 cSt).

With an oil temp gauge, if the OEM grade is at less than 100C after a long drive, then 1 or 2 thinner grades can be used without problem.
_________________________
'00 MB E430
'04 Honda S2000
'06 Volvo V70
'14 Honda Accord LX
"Throwing food away is like stealing it from the poor and hungry" Pope Francis

Top
#2897624 - 02/06/13 04:17 PM Re: Blending Viscosities Calculator [Re: jstutz]
oldhp Online   content


Registered: 06/28/12
Posts: 1305
Loc: Southern Illinois
_________________________
2016 Challenger R/T Hemi 6-speed,Toy.
2012 Equinox 2.4-Wife's Ride
2010 Ranger 2.3/auto, work/haul truck.

Top
#2897836 - 02/06/13 07:19 PM Re: Blending Viscosities Calculator [Re: Donald]
jstutz Offline


Registered: 10/06/08
Posts: 1547
Loc: NC
Originally Posted By: Donald
But this just does it for virgin oil. What about oil with 100 hours or 1000 hours. There is plenty of good oil available at various weights, do not see the point in mixing.


Sure there are plenty of weights available but maybe there are a few odd quarts laying around you want to use up and just would like to know about what your mixture is. As far as 1000 hrs on the oil, no calculator could predict that unless you did one for every specific oil. Different oils have too many properties to just lump into a single (simple) equation. I think i see your point though. I myself am not a big fan of mixing but every once in a while i have a few odd quarts lying around.

Top
#2897840 - 02/06/13 07:24 PM Re: Blending Viscosities Calculator [Re: oldhp]
jstutz Offline


Registered: 10/06/08
Posts: 1547
Loc: NC
Originally Posted By: oldhp


This calculator should give you similar answers as the widman charts but it is local and you can manipulate as you wish. I just wanted something that i could control on my own and build my own data base that is important to me. Nothing is stopping you from saving one as 10w30 comparisons and others as something else or expanding on this calculator to do anything you would like to tailor it towards.

There is a lot that goes into blending a motor oil and it should most likely be left up to the blender as to what works best together. This tool just gives us something to play with.

Check out how thick some of the dino gear oils get when very cold.

If there was something else you all would like to see in the calculator i would be more than happy to add it to it.


Edited by jstutz (02/06/13 07:26 PM)

Top
#2897865 - 02/06/13 07:59 PM Re: Blending Viscosities Calculator [Re: jstutz]
cp3 Offline


Registered: 07/26/06
Posts: 2645
Loc: Kitchener, Ontario, Canada
Thanx again, been using this and a couple modified variations for quite a while now.
_________________________
Dodge Charger|Pennzoil Platinum 5w20|Mopar MO-744
Pontiac G6 GT|Mobil 1 0w40|Mobil 1 M1-101

Top
#2897875 - 02/06/13 08:07 PM Re: Blending Viscosities Calculator [Re: oldhp]
ARB1977 Offline


Registered: 06/12/05
Posts: 4835
Loc: North Texas
Originally Posted By: oldhp

Pretty cool, thanks.
_________________________
2015 Tacoma 4.0L 44K (as of 3-15-17)
M1 0W30 & BioTech / Toyota filter

2008 CRV 2.4L 164K (as of 4-19-17)
Maxlife 5W20 / M1 filter

Top