I am currently writing an Excel function to calculate various petroleum properties (MW, VGC’s (4), VI, d-n-M, viscosities (cSt, SUS, SFS) at various standard temperatures (12) and at user specified temperatures, density and specific gravity at standard and user specific temperatures, equivalent methylenes based on the molecular weight (MW with and without sulfur)). The function currently has 33 parameters and has 51 outputs. Since this would be cumbersome, the function also will show a form if the first parameter is “Form”. This will generate a parameter filled out string that can be used as a template for the actual function. At the moment, the calculations and function logic are being validated.
No comments:
Post a Comment