I looked at jmw's spreadsheet. I don't see any calculation for the values A and B in there (it looks like they were solved in some other program for specific oils and dumped into this spreadsheet). Also he mentioned he used celsius temperature and the equation does require Kelvin ( checked and that makes a big difference). But I like his approach to forget about the straight line. I think the special graph giving the characteristics as a straight line was more important in the old days when numerical calcs were tough, but it is just an unnecessary complication these days when we have spreadsheets.
I went back to the ASTM standard / Walther equation and did it in a way which doesn’t seek to plot a straight line
from ASTM D341 :
log (log(v + 0.7)) = A - B log T <eq1>
where v is kinematic viscosity in cSt, T is temperature in K, log is base 10 log, and A and B are unknown constants which can be solved from two data points (v1,T1), (v2,T2)
Plug the data from the first ppoint v1,T1 into eq1:
log (log(v1 + 0.7)) = A - B log T1 <eq2>
solve eq2 for A
A = log(log(v1+0.7)) + B*log(T1) <eq3>
plug the data from the second point v2,T2 int eq1
log (log(v2 + 0.7)) = A - B log T2 <eq4>
substitute into eq4 the value A from eq3
log (log(v2 + 0.7)) = [log(log(v1+0.7)) + B*log(T1)] - B log T2 <eq5>
solve eq5 for B
B = {log (log(v2 + 0.7)) - log(log(v1+0.7)) } / (logT1-logT2) <eq6>
solve equation 4 for A
A = log (log(v2 + 0.7)) + B log T2 <eq7>
solve eq 1 for v
v = 10^(10^(A-B*LOG(T)))-0.7 <eq8>
equation 8 using values of A from eq7 and B from eq6 give us v as a function of T.
I have implemented this in a spreadsheet. Enter in the green the pairs (v1,T1), (v2,T2) in units cSt and deg C. Then enter the target temperautre T3 and it computes v3 as well as a curve based on the two points.
http://home.houston.rr.com/electricpete/eng-tips/ViscosityVsTemperatureCalculator.xls Regarding the role of p-v. The rolling bearing manfuacturer’s give instructions for selecting oil based on minimum viscosity as a function of temperature (for example SKF, MRC). As you point out, variation of viscosity with pressure is a huge factor. What I have heard is that the variation with pressure does not change widely among non-synthetic oils, so this approach is valid for non-synth oils. For synth oils, perhaps we should use a limti curve which explicitly accounts for both pressure and temperature variation of viscosity.
=====================================
Eng-tips forums: The best place on the web for engineering discussions.