Don't get me wrong, this spreadsheet is the next step in my process. First however, I must find a way to calculate the min operating viscosity at operating temperature. Once this is obtained, I will be able to use ASTM D341 to convert this number to an ISO Viscosity grade (@40C).
I don't think your spreadsheet is of any help here. I am trying to find out what viscosity of fluid to use based on size, rpm, and temp. To use your spreadsheet I have to know this, thus defeating the purpose of the original post.
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...