Spreadsheet: 62585d1263498745-calculation-dependant-on-if-a-date-falls-within-a-range-data-and-projection
Sheet: Operational Days

 |  | 2006-12-31 00:00:00 | 2007-12-31 00:00:00 | 2008-12-31 00:00:00 | 2009-12-31 00:00:00 | 2010-12-31 00:00:00 | 2011-12-31 00:00:00 | 2012-12-31 00:00:00 | 2013-12-31 00:00:00
 | CSCL Zeebrugge | 0 | 286 | 360 | 360 | 360 | 360 | 360 | 360
 | CSCL Long Beach | 0 | 176 | 360 | 360 | 360 | 360 | 360 | 360
 | [NAME] | 360 | 360 | 360 | 360 | 360 | 360 | 360 | 360
 | CSCL Africa | 360 | 360 | 360 | 360 | 360 | 360 | 360 | 360
 | [NAME] | 55 | 360 | 360 | 360 | 360 | 360 | 360 | 360
 | [NAME] | 41 | 360 | 360 | 360 | 360 | 360 | 360 | 360
 | [NAME] | 55 | 360 | 360 | 360 | 360 | 360 | 360 | 360
 | [NAME] | 55 | 360 | 360 | 360 | 360 | 360 | 360 | 360
 | CSCL Hamburg | 360 | 360 | 360 | 360 | 360 | 360 | 360 | 207
 | [NAME] | 360 | 360 | 360 | 360 | 360 | 360 | 360 | 268
 | CSCL Ningbo | 360 | 360 | 360 | 360 | 360 | 360 | 360 | 360
 | CSCL Dalian | 360 | 360 | 360 | 360 | 360 | 360 | 360 | 360
 | CSCL Felixstowe | 360 | 360 | 360 | 360 | 360 | 360 | 360 | 360
 | CSCL Vancouver | 360 | 360 | 360 | 360 | 360 | 360 | 360 | 360
 | [NAME] | 360 | 360 | 360 | 360 | 360 | 360 | 360 | 360
 | CSCL New York | 360 | 360 | 360 | 360 | 360 | 360 | 360 | 360
 | [NAME] | 360 | 360 | 360 | 360 | 360 | 360 | 360 | 360
 | CSCL Brisbane | 360 | 360 | 360 | 360 | 360 | 360 | 360 | 360
 | New Delhi Express | 360 | 360 | 360 | 360 | 360 | 360 | 360 | 360
 | Dubai Express | 358 | 360 | 360 | 360 | 360 | 360 | 360 | 360
 | Jakarta Express | 310 | 360 | 360 | 360 | 360 | 360 | 360 | 360
 | Saigon Express | 265 | 360 | 360 | 360 | 360 | 360 | 360 | 360
 | Lahore Express | 170 | 360 | 360 | 360 | 360 | 360 | 360 | 360
 | Rio Grande Express | 71 | 360 | 360 | 360 | 360 | 360 | 360 | 360
 | Santos Express | 48 | 360 | 360 | 360 | 360 | 360 | 360 | 360
 | Rio de Janeiro Express | 0 | 273 | 360 | 360 | 360 | 360 | 360 | 360
 | Manila Express | 0 | 218 | 360 | 360 | 360 | 360 | 360 | 360
 | COSCO Fuzhou | 0 | 274 | 360 | 360 | 360 | 360 | 360 | 360
 | COSCO Yingkou | 0 | 176 | 360 | 360 | 360 | 360 | 360 | 360
 | CSCL Panama | 0 | 0 | 226 | 360 | 360 | 360 | 360 | 360
 | CSCL Montevideo | 0 | 0 | 115 | 360 | 360 | 360 | 360 | 360
 | [NAME] | 0 | 0 | 140 | 360 | 360 | 360 | 360 | 360
 | CSCL Lima | 0 | 0 | 76 | 360 | 360 | 360 | 360 | 360
 | [NAME] | 0 | 0 | 53 | 360 | 360 | 360 | 360 | 360
 | [NAME] | 0 | 0 | 30 | 360 | 360 | 360 | 360 | 360
 | Hull No. S452 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Hull No. 2177 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Hull No. S453 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Hull No. 2178 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Hull No. S454 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Hull No. 2179 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Hull No. 2180 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Hull No. 2181 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | COSCO Japan | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | COSCO Korea | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | COSCO Philippines | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | COSCO Malaysia | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | COSCO Indonesia | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | COSCO Thailand | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | COSCO Pakistan | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | COSCO Vietnam | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | MOL Eminence | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | MOL Emissary | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | MOL Empire | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Hull No. 1851 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Hull No. 1852 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Hull No. 1853 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Hull No. 1854 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Hull No. 1855 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | [NAME] Lumaco | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | CSCL Callao | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Calicanto Bridge | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0