In addition to the functions available in the standard version http://cargocal.com/SNsOil.html the following functions are made available in the advanced version. This will keep the file size small and give fast calculations. (See Calling .DLL Function vs. Visual Basic Worksheet Function) Further, you can access and call the functions in multiple projects at the same time.  However, a registered Dll has to be purchased for each machine it is being used on.  Select the level from Standard, Advanced, Premium or Universal  according to your need.

Extract the zipped file to "C:\Cargocal".  Then  from the Start-Run button, register the add-in by typing    RegSvr32 "c:\cargocal\SNsAdvOil.dll".  Then from Excel, Tools-Addins, click on the 'Automation, button.  Select SNsAdvOil.OilCalc from the list or use the Browse button to the Cargocal folder and select the add-in SNsAdvOil.dll

The functions are -

Tab6c(API As Double, DegC as Double) As Double   
Tab23a(Density As Double, DegC as Double) As Double   
Tab23b(Density As Double, DegC as Double) As Double   
Tab23c(Density As Double, DegC as Double) As Double   
Tab24c(Density As Double, DegC as Double) As Double   
Tab53a(Density As Double, DegC as Double) As Double   
Tab53b(Density As Double, DegC as Double) As Double   
Tab54c(Density As Double, DegC as Double) As Double

SG60F(API As Double, Optional AD As String = "A") As Double    ' If Density, Pass AD = "D"
DensTkTemp(Den15 As Double, DegC As Double) As Double

Chems(Density As Double, DegC As Double, CoEfF As Double, BaseTemp As Double) As Double    ' For Chemicals
Volu15(Voltk As Double, DegC As Double, CoEfF As Double, BaseTemp As Double) As Double

VCF(table As String, API As Double, DegC as Double) As Double       ' Tables are 6A/B/C, 24A/B/C, 54A/B/D, API is either API or Density      Example: =VCF(a1,b1,c1) returns 0.98822  where  A1="6C", B1=0.0003355, C1=35

RoundM(num As Double, Precision As Single) As Double
RoundD(num As Double, Places As Integer) As Double        ' Round Down
RoundU(num As Double, Places As Integer) As Double        ' Round Up
Trun(num As Double, Places As Integer) As Double              ' TruncateRoundM(num As Double, Precision As Single) As Double
SigDigs(num As Double, Places As Integer) As Double         ' Return significant digits (max 15)

For OBQ/ROB -
GetWedA2(Inn As Single, TkL As Single, TkH As Single, UDis As Single, LBP As Single, VTrim As Single)  As Double   ' Gives A/2 Innage
GetWedVol(VolA2 As Single, InnA2, TkL As Single, LBP As Single, VTrim As Single) As Double      ' Gives Wedged Volume  

For sake of uniformity, temperature to be passed is in degrees Centigrade to all the functions and is automatically changed to Fahrenheit internally, if required.  (Unless either is allowed by the argument 'CF' as string).

STANDARD FUNCTIONS

PREMIUM FUNCTIONS

Users may send their queries to for any clarification.

This project has a limit of 100 calculations and / or prevents printing with the unregistered copy.  With 100 calculations, the user can test the usefulness of this add-in substantially for a tank or two.  To get the registered version, click on the button below to purchase via secure transactions and send us by e-mail the file "licSNOilPCID.pvf" generated by the project.  You will find this file in 'C:\Cargocal\DllA.  We will send you the release code file by return e-mail.