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. 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).
Users
may send their queries to
for any clarification.
This project has a limit of 30 calculations and / or prevents printing with the unregistered copy. With 30 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.