Masboy, I downloaded the spreadsheet you suggested in search of the "k" factors for the various product types. These "k" factors are used to calculate the VCF.

VCF= exp(-α*∆T*(1.0+0.8*α*∆T)) where ∆T=T(actual) - T(base) and α=k0/ρ^2 + k1/ρ + k2

The spreadsheet formulas for Crudes (6a/54a) and Refined Products (6b) all follow the above pattern; however, the formula for 54b calculates ∆T as:

[T(actual) + 40]*1.8 - 99

Does anyone know if this is correct? If not, anyone using the spreadsheet for 54b VCF calculations needs to fix the "Calc 6-54" worksheet.