ASTM D2502 Calculation of Petroleum Oil Molecular Weight

ASTM D2502 has a chart that is used to estimate the molecular weight of a petroleum oil based on two viscosities of the oil.  The chart requires several estimation and interpolations, which can introduce mistakes.  A calculation from mid 1985 using the 2 viscosities is presented (LINK->Calculation of a Petroleum Oil Molecular Weight). The calculated molecular weights compared to the ones determined from the chart have a difference of 2.3 standard deviations.  The calculation is valid for the entire chart. The Microsoft document is available by contacting the author for a Dropbox link.

An Excel workbook (MWPetOilFrom2Vis_VisCalcs.xlsm) and the exported VBA module (MWPetOilFrom2Vis_VisCalcs.bas) are available.  The function MW40_100 calculates the molecular weight from cSt viscosities at 40C and 100C. It converts the viscosities and checks if they are within the bounds of the chart.

DoE Document Describing the Method

The document "Using Design of Experiment Methods for Screening and Optimization of Factors when Results are Qualitative" had been uploaded and published to the WEB through Google Docs 2 months ago.  It did not seemed to be indexed.  A new versions has been uploaded and can be viewed on Google Docs.  It can also be viewed on this LINK-> blog   . Both have the same content.  The links in the other post Wed. August 7, 2019 are the same as in this post. 8/28/20 links to Google Docs removed.