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.

Update to Windows Performance Counter Event Errors

After installing all the performance counters that could be found for the services listed by lodctr /Q, a event viewer logged a couple of events associated with the performance counters.  This was used as an opportunity to run lodctr /R to check its affect on installed counters.  Some counter were lost. This is listed under Update 20190122 in LINK-> Performance Counter Event Errors

DoE, Great if Results aren't Qualitative and a Model Can Be Made

LINK-> (Using Design of Experiment Methods for Screening and Optimization of Quantitative Factors when Results are Qualitative) details the sequential use of traditional DOE (vertices generations and optimality selection) to generate a small set of trial experiments from the number of factors.  The best result from a set of experiments is used as the starting point for the next series of experiments.  It will eliminate unnecessary ones and optimize the others (screening and optimization) .  Its primary use is for situations when quantitative results are to difficult, impossible or time consuming to obtain or when a mathematical model of the system cannot be determined or it is not clear how to weight multiple responses.

Fixing Windows Performance Counter Event Errors

Windows performance counters can cause event errors like 1008, 1023, 2001 and 8317.  Information on fixing them is fragmented and the easily found reference information on using the Lodctr command to fix them is limited in depth. Link-> Performance Counter Event Errors discusses how Lodctr was used to resolve the events and items that may have caused others to have less success with the command.