Spreadsheet: 93774d1293553474-excel-2007-separate-data-from-a-list-problem-to-be-solved
Sheet: Fleet inputs

1
(in $ millions unless otherwise stated)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Drydocking - IS |  |  | Drydocking - SS
No | Vessel Name | On/Off | Type | Ownership Status | Vessel Type | [NAME] | Lwt | Age | Year Built | Acquisition Date | Vessel life | Sell Date | Disposal date | Acquisition Cost | Book Value | Market Values | OPEX ($/day) | Start | Days | Cost | Start | Days | Cost |  |  |  |  |  | Weighted average Age
 | a | 1 | 0 | 1 | Capesize | 171199 | 23000 |  | 2000-06-30 00:00:00 | 2010-09-08 00:00:00 | 25 |  |  | 42.5 |  | 46.5 | 7000 |  |  | 0 |  |  | 2.7
 | b | 1 | 0 | 1 | Capesize | 184403 | 23000 |  | 1991-06-30 00:00:00 | 2008-04-15 00:00:00 | 25 |  |  | 83.75 |  | 26.5 | 7500 |  |  |  |  |  | 2.7
 | a | 1 | 0 | 1 | Capesize | 150940 | 9000 |  | 1991-06-30 00:00:00 | 2008-09-18 00:00:00 | 25 |  |  | 87.18 |  | 21.5 | 7000 |  |  |  |  |  | 0.9
 | b | 1 | 0 | 1 | Supramax | 53098 | 9000 |  | 2002-06-30 00:00:00 | 2008-01-04 00:00:00 | 25 |  |  | 43.4743543703704 |  | 27.25 | 5500 |  |  |  |  |  | 0.9
 | a | 1 | 0 | 1 | Supramax | 52434 | 9000 |  | 2000-06-30 00:00:00 | 2008-01-02 00:00:00 | 25 |  |  | 40.9170394074074 |  | 25 | 5500 |  |  |  |  |  | 0.9
 | b | 1 | 0 | 1 | Supramax | 52402 | 9000 |  | 2001-06-30 00:00:00 | 2007-12-03 00:00:00 | 25 |  |  | 40.9170394074074 |  | 26 | 6000 |  |  |  |  |  | 0.9
 | a | 1 | 0 | 1 | Supramax | 52994 | 9000 |  | 2003-06-30 00:00:00 | 2008-01-02 00:00:00 | 25 |  |  | 42.4514283851852 |  | 28.5 | 6000 |  |  |  |  |  | 0.9
 | b | 1 | 0 | 1 | Supramax | 52425 | 9000 |  | 2003-06-30 00:00:00 | 2007-12-06 00:00:00 | 25 |  |  | 43.985817362963 |  | 28 | 6000 |  |  |  |  |  | 0.9
 | a | 1 | 0 | 1 | Supramax | 52055 | 9000 |  | 2001-06-30 00:00:00 | 2007-12-14 00:00:00 | 25 |  |  | 72 |  | 26 | 6000 |  |  |  |  |  | 0.9
 | b | 1 | 0 | 1 | Supramax | 53489 | 9000 |  | 2005-06-30 00:00:00 | 2008-04-17 00:00:00 | 25 |  |  | 72 |  | 26 | 5500 |  |  |  |  |  | 0.9
 | a | 1 | 0 | 1 | Supramax | 52247 | 9000 |  | 2005-06-30 00:00:00 | 2008-07-01 00:00:00 | 25 |  |  | 68.8 |  | 29 | 5500 |  |  |  |  |  | 0.9
 | b | 1 | 1 | 1 | Capesize | 180000 | 23000 |  | 2011-10-15 00:00:00 |  | 25 |  |  | 53.58 |  | 58.5 | 7000 |  |  |  |  |  | 2.7
 | a | 1 | 1 | 1 | Capesize | 180000 | 23000 |  | 2011-12-15 00:00:00 |  | 25 |  |  | 53.3 |  | 58.5 | 7000 |  |  |  |  |  | 2.7
 | b | 1 | 1 | 1 | Capesize | 180000 | 23000 |  | 2011-12-16 00:00:00 |  | 25 |  |  | 53.3 |  | 58.5 | 7000 |  |  |  |  |  | 2.7
 | a | 1 | 1 | 1 | Capesize | 180000 | 23000 |  | 2011-12-17 00:00:00 |  | 25 |  |  | 53.3 |  | 58.5 | 7000 |  |  |  |  |  | 2.7
 | b | 1 | 1 | 1 | Capesize | 180000 | 23000 |  | 2011-12-18 00:00:00 |  | 25 |  |  | 53.3 |  | 58.5 | 7000 |  |  |  |  |  | 2.7
 | a | 1 | 1 | 1 | Capesize | 180000 | 23000 |  | 2011-12-19 00:00:00 |  | 25 |  |  | 53.3 |  | 58.5 | 7000 |  |  |  |  |  | 2.7
 | b | 1 | 1 | 1 | Capesize | 180000 | 23000 |  | 2011-12-20 00:00:00 |  | 25 |  |  | 53.3 |  | 58.5 | 7000 |  |  |  |  |  | 2.7
 | a | 1 | 1 | 1 | Capesize | 180000 | 23000 |  | 2011-12-21 00:00:00 |  | 25 |  |  | 53.3 |  | 58.5 | 7000 |  |  |  |  |  | 2.7
 | b | 1 | 1 | 1 | Capesize | 180000 | 23000 |  | 2011-12-22 00:00:00 |  | 25 |  |  | 53.3 |  | 58.5 | 7000 |  |  |  |  |  | 2.7
 | a | 1 | 1 | 1 | Capesize | 180000 | 23000 |  | 2011-12-23 00:00:00 |  | 25 |  |  | 53.3 |  | 58.5 | 7000 |  |  |  |  |  | 2.7
 | b | 1 | 1 | 1 | Capesize | 180000 | 23000 |  | 2011-12-24 00:00:00 |  | 25 |  |  | 53.3 |  | 58.5 | 7000 |  |  |  |  |  | 2.7
 | a | 1 | 1 | 1 | Capesize | 180000 | 23000 |  | 2011-12-25 00:00:00 |  | 25 |  |  | 53.3 |  | 58.5 | 7000 |  |  |  |  |  | 2.7
 | NB | 1 | 1 | 1 | Capesize | 180000 | 23000 |  | 2011-12-26 00:00:00 |  | 25 |  |  | 53.3 |  | 58.5 | 7000 |  |  |  |  |  | 2.7
 | NB | 1 | 1 | 1 | Capesize | 180000 | 23000 |  | 2011-12-27 00:00:00 |  | 25 |  |  | 53.3 |  | 58.5 | 7000 |  |  |  |  |  | 2.7
 | NB | 1 | 1 | 1 | Capesize | 180000 | 23000 |  | 2011-12-28 00:00:00 |  | 25 |  |  | 53.3 |  | 58.5 | 7000 |  |  |  |  |  | 2.7
 | NB | 1 | 1 | 1 | Capesize | 180000 | 23000 |  | 2011-12-29 00:00:00 |  | 25 |  |  | 53.3 |  | 58.5 | 7000 |  |  |  |  |  | 2.7
 | NB | 1 | 1 | 1 | Capesize | 180000 | 23000 |  | 2011-12-30 00:00:00 |  | 25 |  |  | 53.3 |  | 58.5 | 7000 |  |  |  |  |  | 2.7
 | NB | 1 | 1 | 1 | Capesize | 180000 | 23000 |  | 2011-12-31 00:00:00 |  | 25 |  |  | 53.3 |  | 58.5 | 7000 |  |  |  |  |  | 2.7
 | NB | 1 | 1 | 1 | Capesize | 180000 | 23000 |  | 2012-01-01 00:00:00 |  | 25 |  |  | 53.3 |  | 58.5 | 7000 |  |  |  |  |  | 2.7
 | NB | 1 | 1 | 1 | Capesize | 180000 | 23000 |  | 2012-01-02 00:00:00 |  | 25 |  |  | 53.3 |  | 58.5 | 7000 |  |  |  |  |  | 2.7
 | NB | 1 | 1 | 1 | Capesize | 180000 | 23000 |  | 2012-01-03 00:00:00 |  | 25 |  |  | 53.3 |  | 58.5 | 7000 |  |  |  |  |  | 2.7
 | NB | 1 | 1 | 1 | Capesize | 180000 | 23000 |  | 2012-01-04 00:00:00 |  | 25 |  |  | 53.3 |  | 58.5 | 7000 |  |  |  |  |  | 2.7
 | NB | 1 | 1 | 1 | Capesize | 180000 | 23000 |  | 2012-01-05 00:00:00 |  | 25 |  |  | 53.3 |  | 58.5 | 7000 |  |  |  |  |  | 2.7
 | NB | 1 | 0 | 1 | Capesize | 180000 | 23000 |  | 2012-01-06 00:00:00 |  | 25 |  |  | 53.3 |  | 58.5 | 7000 |  |  |  |  |  | 2.7
 | NB | 1 | 1 | 1 | Capesize | 180000 | 23000 |  | 2012-01-07 00:00:00 |  | 25 |  |  | 53.3 |  | 58.5 | 7000 |  |  |  |  |  | 2.7
 |  | 1 | 1 | 1 | Capesize | 180000 | 23000 |  | 2012-01-08 00:00:00 |  | 25 |  |  | 53.3 |  | 58.5 | 7000 |  |  |  |  |  | 2.7
 |  | 1 | 1 | 1 | Capesize | 180000 | 23000 |  | 2012-01-09 00:00:00 |  | 25 |  |  | 53.3 |  | 58.5 | 7000 |  |  |  |  |  | 2.7
 |  | 1 | 1 | 1 | Capesize | 180000 | 23000 |  | 2012-01-10 00:00:00 |  | 25 |  |  | 53.3 |  | 58.5 | 7000 |  |  |  |  |  | 2.7
 |  | 1 | 1 | 1 | Capesize | 180000 | 23000 |  | 2012-01-11 00:00:00 |  | 25 |  |  | 53.3 |  | 58.5 | 7000 |  |  |  |  |  | 2.7
 | Total/Average
 | Weighted Average |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #[NAME]!