You cannot just avg the numbers. You have to use Refutas equation or some approximation of it for blending different viscosities. I have cut and pasted a clip from another post that explains it well but you can also look up viscosity on Wikipedia and scroll about halfway down and look for the title Viscosity of blends of liquids and it goes over it as well. There are a few equations out there that will get you pretty close without do quite as much math. Im not sure why you cant figure out the spreadsheet though. Is it locked or something. i have had trouble in the past with it being password protected. If you cant use my spreadsheet, go to this site and put the numbers in there, i think you will be suprised.
http://www.rohmax.com/product/rohmax/en/about/calculation-tools/pages/default.aspx
Viscosity blending equations
Calculating the viscosity blending index of a liquid consisting of two or more liquids having different viscosities is a two step procedure. The first step involves calculation of the Viscosity Blending Index (VBI) of each component of the blend using the following equation (known as a Refutas equation):
(1) VBI = 14.534 × ln[ln(v + 0.8)] + 10.975
where v is the viscosity in centistokes and ln is the natural logarithm (Loge).
The second step involves using this equation:
(2) VBIBlend = [wA × VBIA] + [wB × VBIB] + ... + [wX × VBIX]
where w is the weight fraction (i.e., % ÷ 100) of each component of the blend. In using the above blending equation, it is necessary that all viscosities are determined at the same temperature, for example, 100 oC.
(Reference: Robert E. Maples (2000), Petroleum Refinery Process Economics, 2nd Edition, Pennwell Books, ISBN 0-87814-779-9)
Once the viscosity blending number of a blend is obtained with equation (2), the viscosity of the blend can be determined by using the invert of equation (1):
(3) v = ee(VBN - 10.975) ÷ 14.534 - 0.8
where VBN is the viscosity blending number of the blend and e is the transcendental number 2.71828, also known as Euler's number.