Spreadsheet: 741728d1627302017-dynamic-workbook-path-wqe
Sheet: SUMMARY

CHECK DATE | 2021-07-23 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | virgo
GOODWOOD SHIP MANAGEMENT -NOON REPORT CHECK-FLEET-5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ASSUMPTIONS & FORMULAE USED
Vessel Name | NOON REPORT DATE | Voy.No | CP.Speed (Min) knots | [NAME] | Draft Aft | Ballast | Laden | Vessel at SSS | Stm.Hrs | Anchorage Hrs | Drifting Hrs | Port Stay Hrs | Man, Idling Etc | Total Op Hrs | Av.Gr.Speed | [NAME].Slip | Observed Distance | Consumption in nm/mt | Wind Force BF | ME. R Hrs | Av.RPM | Cyl.Exh T Max Deg .C | Cyl.Exh T Min Deg.C | ME. Sc.Temp Deg.C | ME.Air Cooler Pr Dr(mmH2O) | FO.Cons mt?day | Avg.ME Power in kW | Avg.ME Power(KwH) | ME-SFOC (Gms/kWh) | ME. Th.LOAD % | ME Cyl Oil Cons Lits/Day | SCOC (Gms/kWh) | SCOC-DP  (Gms/kWh) | AE.Total Rh | AE.FO.CONS mt/day | Aux.Eng Total Power in kWh | Aux.Eng SFOC Gms/kWh | Aux Eng Usage Sets/Day | [NAME] | F.W PROD | [NAME] | [NAME] | Sludge on Board |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Fm ME Cons in lits/Hr | Density@FM IN MT/Cu.m | Output at MCR | MCR RPM | Output at 90 % MCR | RPM at 90 %  MCR | SFOC at Shop Trial(90% Load) | ME.ACTUAL OUTPUT | Density of Cyl Oil gms/lit | AE. SFOC Gms/kWh AT SHOP TRIAL(75%) | AE. SFOC Gms/kWh AT SHOP TRIAL(25%) | na% =(Actual Rpm/ShopTrial MCR-Rpm x 100 | NA%= Actual kWh /MCR kWh x 100 | Sludge Tank Capacity | 80 % Sludge Tank Capacity | ME AVG CYL OIL [NAME] (2017) | ME. SYS OIL [NAME] (2017) | ME SUMP CHARGE | AE. SYS OIL [NAME] (2017) | AE SUMP CHARGE  FOR 2 ENGINES
AQUARIUS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | =1000*AA4/U4 | 0.95 | 15180 | 105 | 12872 | 101.4 | 174.72 |  | 950 | 191 | 247 |  |  | 47.2 |  | 184 | 43 | 15000 | 14 | 2000
ATHERINA |  |  |  |  |  |  | ='S:\ASP\Fleet 4\July\Common\[ATHE.xlsx]Log Report'!$P$23 | ='S:\ASP\Fleet 4\July\Common\[ATHE.xlsx]Log Report'!$D$12 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | SOPHIE |  | 0.95 | 15180 | 105 | 12872 | 101.4 | 169.66 |  | 950 | 191 | 247 |  |  | 47.2 |  | 207 | 175 | 15000 | 35 | 2000
EAGLE BAY |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.95 | 31640 | 80 | 29249 | 77.9 | 172.11 |  | 950 | 194 | 228 |  |  | 362.6 |  | 242 | 141 | 35000 | 20 | 2000
VIRGO |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.95 | 31940 | 80 | 29249 | 77.9 | 172.11 |  | 950 | 196 | 236 |  |  | 364 |  | 371 | 163 | 35000 | 23 | 2000
TAURUS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.95 | 31640 | 80 | 28476 | 78 | 172.6 |  | 950 | 193 | 230 |  |  | 362.6 |  | 290 | 52 | 35000 | 7 | 2000
WAWASAN RUBY |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.95 | 29346.9 | 76 | 22027 | 69.1 | 198.7 |  | 950 | 195 | 228 |  |  | 195.3 |  | 228 | 226 | 35000 | 29 | 2000
LEO |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.95 | 29260 | 76 | 26334 | 75.3 | 177.14 |  | 950 | 195 | 254.4 |  |  | 72.7 |  | 327 | 60 | 35000 | 37 | 2000
ZENO |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.95 | 29400 | 76 | 22050 | 69.1 | 171.86 |  | 950 | 198.12 | 231.09 |  |  | 129.9 |  | 322 | 75 | 35000 | 4 | 2000
MARIDAKI |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.95 | 29400 | 76 | 22050 | 69.1 | 171.86 |  | 950 | 198.12 | 231 |  |  | 129.9 |  | 364 | 85 | 35000 | 15 | 2000
EVAGORAS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.95 | 25485 | 79 | 22936 | 76.3 | 169.2 |  | 950 | 197.5 | 236.7 |  |  | 69.4 |  | 270 | 139 | 35000 | 40 | 2000
BLACK SWAN |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.95 | 25485 | 79 | 23265 | 76.3 | 170.58 |  | 950 | 197.5 | 236.7 |  |  | 69.4 |  | 228 | 68 | 35000 | 28 | 2000
GILOS
PROMETHUS ENERGY
PROMETHUS LIGHT |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.95 | 25469 | 79 | 22930 | 76.5 | 167.9 |  | 950 | 194.8 | 240.68 |  |  | 67.7 |  | 254 | 52 | 35000 | 36 | 2000
REMARKS FROM VESSEL |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SCANDINAVIA, PEONY  75 %  MCR
AQUARIUS | NEXT PORT |  |  |  |  | DATE |  |  |  |  |  | TIME |  |  |  |  |  | CYL.OIL ROB/ENDURANCE |  |  |  |  |  | Days | ME.SYS.OIL [NAME]/Endurance |  |  |  |  |  | Days | [NAME] |  |  |  |  |  | Days
ATHERINA | NEXT PORT |  |  |  |  | DATE |  |  |  |  |  | TIME |  |  |  |  |  | CYL.OIL ROB/ENDURANCE |  |  |  |  |  | Days | ME.SYS.OIL [NAME]/Endurance |  |  |  |  |  | Days | [NAME] |  |  |  |  |  | Days |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NOTE: | AE SFOC'S NOT FILLED IN VESSEL CONFIG |  |  |  |  |  |  | ESTIMAED
EAGLE BAY | NEXT PORT |  |  |  |  | DATE |  |  |  |  |  | TIME |  |  |  |  |  | CYL.OIL ROB/ENDURANCE |  |  |  |  |  | Days | ME.SYS.OIL [NAME]/Endurance |  |  |  |  |  | Days | [NAME] |  |  |  |  |  | Days
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] for calculation of  Output is as below, |  |  |  | (METHOD-A)-Used in this sheet
VIRGO | NEXT PORT |  |  |  |  | DATE |  |  |  |  |  | TIME |  |  |  |  |  | CYL.OIL ROB/ENDURANCE |  |  |  |  |  | Days | ME.SYS.OIL [NAME]/Endurance |  |  |  |  |  | Days | [NAME] |  |  |  |  |  | Days
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Output (kW)= |  | Fm x 9600 x 1000
TAURUS | NEXT PORT |  |  |  |  | DATE |  |  |  |  |  | TIME |  |  |  |  |  | CYL.OIL ROB/ENDURANCE |  |  |  |  |  | Days | ME.SYS.OIL [NAME]/Endurance |  |  |  |  |  | Days | [NAME] |  |  |  |  |  | Days
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SFOC x 10,200
WAWASAN RUBY | NEXT PORT |  |  |  |  | DATE |  |  |  |  |  | TIME |  |  |  |  |  | CYL.OIL ROB/ENDURANCE |  |  |  |  |  | Days | ME.SYS.OIL [NAME]/Endurance |  |  |  |  |  | Days | [NAME] |  |  |  |  |  | Days
LEO | NEXT PORT |  |  |  |  | DATE |  |  |  |  |  | TIME |  |  |  |  |  | CYL.OIL ROB/ENDURANCE |  |  |  |  |  | Days | ME.SYS.OIL [NAME]/Endurance |  |  |  |  |  | Days | [NAME] |  |  |  |  |  | Days |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Fm: Reading of Flow meter for main engine (Litre/Hr)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ῥ@Fm   : FO density at temperature in Flow meter.
ZENO | NEXT PORT |  |  |  |  | DATE |  |  |  |  |  | TIME |  |  |  |  |  | CYL.OIL ROB/ENDURANCE |  |  |  |  |  | Days | ME.SYS.OIL [NAME]/Endurance |  |  |  |  |  | Days | [NAME] |  |  |  |  |  | Days |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SFOC: Specific Fuel Oil Consumption in Shop Trial -Gms/kWh at 90 % MCR
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Thermal load (%) = (Actual output /Actual RPM / MCR/RPM at MCR) x 100.
MARIDAKI | NEXT PORT |  |  |  |  | DATE |  |  |  |  |  | TIME |  |  |  |  |  | CYL.OIL ROB/ENDURANCE |  |  |  |  |  | Days | ME.SYS.OIL [NAME]/Endurance |  |  |  |  |  | Days | [NAME] |  |  |  |  |  | Days
EVEGORAS | NEXT PORT |  |  |  |  | DATE |  |  |  |  |  | TIME |  |  |  |  |  | CYL.OIL ROB/ENDURANCE |  |  |  |  |  | Days | ME.SYS.OIL [NAME]/Endurance |  |  |  |  |  | Days | [NAME] |  |  |  |  |  | Days
BLACK SWAN | NEXT PORT |  |  |  |  | DATE |  |  |  |  |  | TIME |  |  |  |  |  | CYL.OIL ROB/ENDURANCE |  |  |  |  |  | Days | ME.SYS.OIL [NAME]/Endurance |  |  |  |  |  | Days | [NAME] |  |  |  |  |  | Days
GILOS | NEXT PORT |  |  |  |  | DATE |  |  |  |  |  | TIME |  |  |  |  |  | CYL.OIL ROB/ENDURANCE |  |  |  |  |  | Days | ME.SYS.OIL [NAME]/Endurance |  |  |  |  |  | Days | [NAME] |  |  |  |  |  | Days
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] for calculation of  Output is as below, |  |  |  | (METHOD-B)-Not used  in this sheet
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Cal (FO) = [NAME] value of FO in use in Mj/Kg
PROMETHUS ENERGY | NEXT PORT |  |  |  |  | DATE |  |  |  |  |  | TIME |  |  |  |  |  | CYL.OIL ROB/ENDURANCE |  |  |  |  |  | Days | ME.SYS.OIL [NAME]/Endurance |  |  |  |  |  | Days | [NAME] |  |  |  |  |  | Days |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Cal (FO) = [NAME] value of FO in use in Mj/Kg
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Fm        : Reading of FO Flowmeter for main engine (Litres/Hr)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ῥ@Fm   : FO density at temperature in Flow meter.
PROMETHUS LIGHT | NEXT PORT |  |  |  |  | DATE |  |  |  |  |  | TIME |  |  |  |  |  | CYL.OIL ROB/ENDURANCE |  |  |  |  |  | Days | ME.SYS.OIL [NAME]/Endurance |  |  |  |  |  | Days | [NAME] |  |  |  |  |  | Days |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SFOC: Specific Fuel Oil Consumption in Shop Trial -Gms/kWh at 90 % MCR
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Thermal load (%) = (Actual output /Actual RPM / MCR/RPM at MCR) x 100.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | “Dual Proportional Method” of Calculating SCOC-DP.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In this method Cylinder Oil Feed Quantity is  proportional to BHP and RPM simultaneously. The [NAME] is given below.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Cylinder Oil Feed rate=CYL OIL {Fm}/(Hr of Full steaming) X SG @ Fm x 1000   X   100
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | (In g/kWh)                         Catalog MCR (kWh)    x      0.7 x na (%) + 0.3 x NA (%)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Where
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Fm:                                         Reading value of Cylinder oil flowmeter Lits/Hr of full steaming.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SG@ Fm:                              Cylinder oil Specific Gravity at temperature  at Flow meter.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Catalog MCR:                       [NAME] (kW) on the Catalog as per Engine Maker.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | na(%):                                    Actual average rpm /Catalog MCR (RPM) x 100
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Na(%):                                   Actual (Ps)/ Catalog MCR (Ps ) x 100