Header
COSTALD Equation (Excel)
Version 2.0 (October 1999)
Designed by Bruce Nicholls
RTG/HEM, Sunbury
Instructions for use:
NOTE: Check that this is the latest available version by visiting the BP Intranet site at:-
http://olympus.bpweb.bp.com/Environmental/Standards/MeasurementStandards/
p3v2c5.pdf
1. Data can only be inputted in the "white" spaces.
2. Proceed to COSTALD Equation.
3. Enter gas composition, component and either %weight or mole fraction.
4. Enter liquid temperature at bottom of sheet.
5. Note liquid density at temperature and molecular weight for "Tank Calculation".
6. Note liquid density at 15 Degrees Celcius for Bill of Lading and/or Certificate of
Quantity/Quality.
7. Proceed to Tank Calculation. Enter data as required.
Page 1
Before using this table use the COSTALD equation to calculate liquid density at temperature.
PORT:
Arrival Date: Time:
Departure Date: Time:
Tank Tank Tank Tank Tank Tank Tank Tank
Tank ID 1port 1stbd 2port 2stbd 3port 3stbd
100% Capacity (m3) 1079.130 1078.520 1253.350 1252.750 1250.460 1249.850 0.000 0.000
Before Transfer
Ship Trim (If Ship) (m) 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000
Ship List (If Ship) (Degrees P/S) 0 0 0 0 0 0 0 0
Product Type 0 0 0 0 0 0 0 0
Molar Mass 57.841 0 0 0 0 0 0 0
Liquid Temperature (C) 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
Vapour Temperature (C) 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
Tank Pressure (Gauge) (Bar) 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Liquid Level (mm) 0 0 0 0 0 0 0 0
Float Correction (mm) 0 0 0 0 0 0 0 0
Tape Correction (mm) 0 0 0 0 0 0 0 0
Trim Correction (mm) 0 0 0 0 0 0 0 0
List Correction (mm) 0 0 0 0 0 0 0 0
Corrected Level (mm) 0 0 0 0 0 0 0 0
Liquid Volume (m3) 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000
Shell Shrinkage Factor 1.00000 1.00000 1.00000 1.00000 1.00000 1.00000 1.00000 1.00000
Corrected Liquid Volume at temperature (m3) 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000
Liquid Density at temperature (g/ml) 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000
Liquid Mass (kg) 0 0 0 0 0 0 0 0 Total 0 Kgs
Vapour Volume (m3) 1079.130 1078.520 1253.350 1252.750 1250.460 1249.850 0.000 0.000
Shell Shrinkage Factor 1.00000 1.00000 1.00000 1.00000 1.00000 1.00000 1.00000 1.00000
Corrected Volume (m3) 1079.130 1078.520 1253.350 1252.750 1250.460 1249.850 0.000 0.000
Vapour Density 0.002545 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000
Vapour Mass (kg) 2747 0 0 0 0 0 0 0 Total 2747 Kgs
Total Mass (kg) 2747 0 0 0 0 0 0 0 Total 2747 Kgs
After Transfer
Ship Trim (If Ship) (m) 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000
Ship List (If Ship) (Degrees P/S) 0 0 0 0 0 0 0 0
Product Type 0 0 0 0 0 0 0 0
Molar Mass 0 0 0 0 0 0 0 0
Liquid Temperature (C) 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
Vapour Temperature (C) 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
Tank Pressure (Gauge) (Bar) 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Liquid Level (mm) 0 0 0 0 0 0 0 0
Float Correction (mm) 0 0 0 0 0 0 0 0
Tape Correction (mm) 0 0 0 0 0 0 0 0
Trim Correction (mm) 0 0 0 0 0 0 0 0
List Correction (mm) 0 0 0 0 0 0 0 0
Corrected Level (mm) 0 0 0 0 0 0 0 0
Liquid Volume (m3) 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000
Shell Shrinkage Factor 1.00000 1.00000 1.00000 1.00000 1.00000 1.00000 1.00000 1.00000
Corrected Volume (m3) 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000
Liquid Density at temperature (g/ml) 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000
Liquid Mass (kg) 0 0 0 0 0 0 0 0 Total 0 Kgs
Vapour Volume (m3) 1079.130 1078.520 1253.350 1252.750 1250.460 1249.850 0.000 0.000
Shell Shrinkage Factor 1.00000 1.00000 1.00000 1.00000 1.00000 1.00000 1.00000 1.00000
Corrected Volume (m3) 1079.130 1078.520 1253.350 1252.750 1250.460 1249.850 0.000 0.000
Vapour Density 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000
Vapour Mass (kg) 0 0 0 0 0 0 0 0 Total 0 Kgs
Total Mass (kg) 0 0 0 0 0 0 0 0 Total 0 Kgs
Total Transfer
Mass Transferred (kg) -2747 0 0 0 0 0 0 0 Total -2747 Kgs
Mass to Weight Conversion Factor 1.00000 1.00000 1.00000 1.00000 1.00000 1.00000 1.00000 1.00000
Weight Transferred (Kg) -2747 0 0 0 0 0 0 0 Total -2747 Kgs
COSTALD EQUATION
Refinery/Terminal:
Date (DD-MMM-YY):
Time (HH:MM):
Product:
Sample ID:
Data
Mole
Component, i % Weight Fraction, xi
Methane 0.000
Ethane 0.000
Ethene 0.000
Ethyne (Acetylene) 0.000
Propane 100.000 1.000
Propene 0.000
Propyne (Methylacetylene) 0.000
n Butane 0.000
iso Butane 0.000
1-Butene 0.000
cis 2-Butene 0.000
trans 2-Butene 0.000
iso Butene 0.000
n Pentane 0.000
iso Pentane 0.000
neo Pentane 0.000
cyclo-Pentane 0.000
1-Pentene 0.000
cis 2-Pentene 0.000
trans 2-Pentene 0.000
2-Methyl 1-Butene 0.000
3-Methyl 1-Butene 0.000
2-Methyl 2-Butene 0.000
n Hexane (C6+) 0.000
Propadiene 0.000
1,2-Butadiene 0.000
1,3-Butadiene 0.000
1,2-Pentadiene 0.000
Isoprene 0.000
Sum 100.000 1.000
Liquid Temperature (C) -41.5
Output Data
Molar Mass 44.097
Saturated Volume 0.086881 litres/mol
Density at 15 C 0.50756 g/ml
Saturated Volume 0.075950 litres/mol
Density at Temperature (C) 0.58061 g/ml