Spreadsheet: 166880d1341839489-conditional-formula-for-the-cell-with-wrong-blank-value-speed-consump
Sheet: Ballast Report

Voyage |  |  |  |  |  |  |  |  |  |  |  |  | Gauging |  |  |  |  | Time |  |  |  |  |  | GMT (+/-) |  |  |  | Qty
From |  |  | Montoir |  |  |  |  |  |  |  |  |  | Depart dis.port |  |  |  |  | 2012-04-27 03:23:00 |  |  |  |  |  | 1 |  |  |  | 5571.37 |  |  |  | m3
To |  |  | [NAME] |  |  |  |  |  |  |  |  |  | Arr. load port |  |  |  |  | 2012-05-14 16:06:00 |  |  |  |  |  | 1 |  |  |  | 2234.32 |  |  |  | m3
Voyage Report
 |  |  |  |  |  | Total |  |  |  | Exempt |  |  |  | Normal |  |  |  |  |  |  |  |  |  |  | FO/GO |  |  | GAS |  |  | PORT ME REV |  |  |  |  |  |  |  |  |  | FO/GO |  |  | GAS |  |  | PORT ME REV
Distance |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | nm |  |  |  | MGE1 |  |  | 586761 |  |  | 413.842 |  |  | 2143754 |  |  |  |  |  |  | MGE1 |  |  | 586761 |  |  | 746.325 |  |  | 2143754
Total time |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | hrs |  |  |  | MGE2 |  |  | 358149 |  |  | 165.432 |  |  | STBD ME REV |  |  |  |  |  |  | MGE2 |  |  | 358149 |  |  | 450.171 |  |  | STBD ME REV
C/P speed |  |  |  |  |  | 19.5 |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  | MGE3 |  |  | 1623882 |  |  |  |  |  | 2157082 |  |  |  |  |  |  | MGE3 |  |  | 1623882 |  |  |  |  |  | 2157082
Average speed |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  | MGE4 |  |  | 390382 |  |  | 404.668 |  |  |  |  |  |  |  |  |  | MGE4 |  |  | 390382 |  |  | 720.345
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BLR |  |  | 473191 |  |  |  |  |  |  |  |  |  |  |  |  | BLR |  |  | 473191
Consumptions |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | GCU |  |  |  |  |  | 512 |  |  |  |  |  |  |  |  |  | GCU |  |  |  |  |  | 574
HFO |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | mt
GO |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | mt
GO ex Pilot |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | mt |  |  |  | Boil off |  |  |  |  |  |  |  |  | m3 |  |  | [NAME] factor |  |  |  |  |  |  |  | Cargo boiloff
LNG |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | m3 |  |  |  | Boil off Energy |  |  |  |  |  |  |  |  | mmBtu |  |  | Calculated |  |  |  |  |  |  |  | Guage - FAOP
GCU LNG |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | m3 |  |  |  | Tanks loaded |  |  |  |  | 4 |  |  |  |  |  |  | Estimated |  |  |  | 0.86 |  |  |  | EOSP - gauge
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Fixed FOE Factor |  |  |  |  |  | 0.554000020027161 |  |  |  |  |  |  |  |  |  |  |  |  |  | Passage boil off
FO cons (FOEF) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | mt |  | Gauging |  |  |  |  |  |  |  | Prop K |  |  |  |  | 7.5426
FO cons (FOEG) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | mt |  | After load |  |  |  |  |  |  |  | @ |  |  |  |  |  |  |  |  |  |  |  |  |  | Cargo density |  |  |  |  | 0.428196
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Before disc |  |  |  |  |  |  |  | @ |  |  |  |  |  |  |  |  |  |  |  |  |  | Cargo energy |  |  |  |  | 54.7932 |  |  | mj/kg
C/P time |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | hrs |  | 1 |  | 173593 |  |  |  | m3 |  | Boil off |  |  | 0.145 |  |  |  |  |  |  |  |  |  |  | Fuel energy |  |  |  |  | 40.06 |  |  | mj/kg
C/P consump |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | mt |  |  |  |  |  |  |  |  |  |  |  |  |  |  | hrs |  |  |  |  |  |  |  |  | GO energy |  |  |  |  | 42.85 |  |  | mj/kg
C/P calc @ av spd |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | mt |  |  |  |  |  |  |  |  |  |  |  |  |  |  | days |  |  |  |  |  |  |  |  | Fuel vis @15 |  |  |  |  | 0.9894