Astm Table 54b Excel Site

VCF=e(−α⋅ΔT⋅(1+0.8⋅α⋅ΔT))cap V cap C cap F equals e raised to the open paren negative alpha center dot cap delta cap T center dot open paren 1 plus 0.8 center dot alpha center dot cap delta cap T close paren close paren power : Constant (approx. 2.718282.71828 ΔTcap delta cap T : Observed Temperature (

Note: The official ASTM D1250 tables are copyrighted. While the formulas and methods can be implemented in Excel, distribution of the exact table data may require a license. Many commercial Excel add-ins are available that provide fully validated ASTM Table 54B calculations. Astm Table 54b Excel

α15=K0D152+K1D15alpha sub 15 equals the fraction with numerator cap K sub 0 and denominator cap D sub 15 squared end-fraction plus the fraction with numerator cap K sub 1 and denominator cap D sub 15 end-fraction API Constants for Generalized Products (Table 54B): (Density range: 640 to 770 Transition Zone: (Density range: 770.5 to 787.5 Distillate Products (Diesel, Jet Fuel): (Density range: 788 to 1075 Step 2: Calculate the Temperature Difference ( ΔT=T−15cap delta cap T equals cap T minus 15 Step 3: Compute the VCF (CTL) Factor VCF=e(−α⋅ΔT⋅(1+0