Need Help Building a Viscosity Calculator
Need Help Building a Viscosity Calculator
(OP)
I am in the process of making a viscosity calculator. The Calculator is going to use the following inputs:
bearing dimensions
rpm
operating temperature
VI
The calculator will return a suggested ISO viscosity grade.
I know of 2 calculators like this that exist. One was written by SKF and resides at http://ww w.skf.com/ portal/skf /home/prod ucts?mainc atalogue=1 &newli nk=first&a mp;lang=en ,under calculations > viscosity. The other was written by Exxon Mobil. Both companies refuse to release the formulas used in the calculators. I have been working on this for several days, and I can not find a way to link all the variables in a single equation.
This process is easily done using several independent charts and equations.
The following is my current practice:
1. Survey the bearing. Find rpm, dimensions, and operating temp.
2. Calculate dm. dm = .5(d+D)
3. Use dm and rpm in conjunction with the following chart to find minimum operating viscosity.

4.Use the newly obtained minimum required viscosity and the operating temperature with the following chart to obtain the ISO viscosity grade.

I have been trying to find a "missing link" as to how these two companies are getting these calculators to work. I know that the first chart is a graphical representation of ASTM D341. The second is a simple viscosity conversion from a viscosity at a certain operating temp to a viscosity at 40C (ISO grade).
Anyone have any ideas? I need some fresh eyes to look at this.
Thanks in advance.
bearing dimensions
rpm
operating temperature
VI
The calculator will return a suggested ISO viscosity grade.
I know of 2 calculators like this that exist. One was written by SKF and resides at http://ww
This process is easily done using several independent charts and equations.
The following is my current practice:
1. Survey the bearing. Find rpm, dimensions, and operating temp.
2. Calculate dm. dm = .5(d+D)
3. Use dm and rpm in conjunction with the following chart to find minimum operating viscosity.

4.Use the newly obtained minimum required viscosity and the operating temperature with the following chart to obtain the ISO viscosity grade.

I have been trying to find a "missing link" as to how these two companies are getting these calculators to work. I know that the first chart is a graphical representation of ASTM D341. The second is a simple viscosity conversion from a viscosity at a certain operating temp to a viscosity at 40C (ISO grade).
Anyone have any ideas? I need some fresh eyes to look at this.
Thanks in advance.





RE: Need Help Building a Viscosity Calculator
On the first graph, if you ignore the data below 5 on vertical axis, the lines have the same slope on log log scale.
log(v1) = a((rpm)) - b * log (dm)
Solve for the value of b and the function a((rpm)) (maybe a polynomial) that minimize the sum of square of residual errors.
=====================================
Eng-tips forums: The best place on the web for engineering discussions.
RE: Need Help Building a Viscosity Calculator
=====================================
Eng-tips forums: The best place on the web for engineering discussions.
RE: Need Help Building a Viscosity Calculator
If you want to adapt this spreadsheet, send an email request to the website for the password.
JMW
www.ViscoAnalyser.com
RE: Need Help Building a Viscosity Calculator
RE: Need Help Building a Viscosity Calculator
I thought that what you would be doing was trying to project the operating temperature and required viscosity at that temperature for a piece of equipment.
The ASTM D341 spreadsheet lets you do that two ways, feed in a temperature to find the viscosity at that temp for each oil and enter a viscosity and find the temperature for each oil at which that viscosity will be obtained..... with the spreadsheet populated with the available lubricants, this should then help discover the optimum lubricant with just a few extra IF statements.
JMW
www.ViscoAnalyser.com
RE: Need Help Building a Viscosity Calculator