{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Invoer_waarden","Resultaten_CCNR1_CCNR0","Resultaten_CCNR2_","Uitleg_resultaten","CBA figures","Results","Key Data","Emission factors","Ship segment (Data)","Shi Segment (Peter)"],"not_rendered":{"charts":22,"images":9,"macros":1,"external_links":1,"defined_names":115,"comments":6,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Invoer_waarden","index":0,"n_rows":67,"n_cols":10,"rows_kept":67,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Selecteer scheepstype",null,null,"Selecteer dieselverbruik"]
[]
[null,null,null,"Motor vessels dry cargo 110 m ship",null,null,"normal fuel use"]
[]
[]
[null,null,null,"Selectie",null,null,"Jaarlijkse dieselverbruik (1.000 liters)",null,null,"Jaarlijkse vaaruren (uren)"]
[null,null,null,{"$f":"D41& \" - \"& G41","v":"Motor vessels dry cargo 110 m ship - normal fuel use"},null,null,{"$f":"INDEX('Ship segment (Data)'!$P$59:$R$76,MATCH(Invoer_waarden!$D$41,'Ship segment (Data)'!$I$59:$I$76,0),MATCH(Invoer_waarden!$G$41,'Ship segment (Data)'!$P$58:$R$58,0))","v":307},null,null,{"$f":"INDEX('Ship segment (Data)'!$J$59:$L$76,MATCH(Invoer_waarden!$D$41,'Ship segment (Data)'!$I$59:$I$76,0),MATCH(Invoer_waarden!$G$41,'Ship segment (Data)'!$J$58:$L$58,0))","v":1943}]
[]
[]
[]
[null,null,null,"Invoer waarden",null,null,"Selectie",null,null,"Standaard"]
[]
[null,null,null,"Gemiddelde Diesel prijs (Euro per ton) tussen 2020 en 2035",null,null,{"$f":"J51","v":697},null,null,697]
[]
[]
[]
[null,null,null,"Gemiddelde LNG prijs (Euro per ton) tussen 2020 en 2035",null,null,{"$f":"J55","v":523},null,null,523]
[]
[]
[]
[null,null,null,"Gemiddelde GTL prijs (Euro per ton) tussen 2020 en 2035",null,null,{"$f":"J59","v":767.13662691652473},null,null,767.13662691652473]
[]
[]
[]
[null,null,null,"Wil je de kosten doorrekenen voor Diesel of HVO (bio-diesel)",null,null,"Diesel",null,null,"Diesel"]
[]
[]
[]
[null,null,null,"Gemiddelde HVO prijs (Euro per ton) tussen 2020 en 2035",null,null,{"$f":"J67","v":857.79822827938676},null,null,{"$f":"'Key Data'!B201","v":857.79822827938676}]

{"sheet":"Resultaten_CCNR1_CCNR0","index":1,"n_rows":154,"n_cols":12,"rows_kept":154,"cut":false,"hidden":false,"merged":[]}
[null,"Resultaten voor een CCNR1/CCNR0 motor"]
[null,"Kosten (mil Euro) voor schippers over 15 jaar"]
[null,{"$f":"Invoer_waarden!$D$45&\" - \" &Invoer_waarden!$G$63","v":"Motor vessels dry cargo 110 m ship - normal fuel use - Diesel"}]
[null,{"$f":"IF(Invoer_waarden!$G$63='Ship segment (Data)'!$S$18,'Ship segment (Data)'!$T$19,'Ship segment (Data)'!$T$18)","v":"_"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Volgende grafiek"]
[]
["Data"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Resultaten voor een CCNR1/CCNR0 motor"]
[null,"Totale kosten (mil Euro) inclusief emissies over 15 jaar"]
[null,{"$f":"Invoer_waarden!$D$45&\" - \" &Invoer_waarden!$G$63","v":"Motor vessels dry cargo 110 m ship - normal fuel use - Diesel"}]
[null,{"$f":"IF(Invoer_waarden!$G$63='Ship segment (Data)'!$S$18,'Ship segment (Data)'!$T$19,'Ship segment (Data)'!$T$18)","v":"_"}]
[]
[]
[]
[]
[]
[]
[]
[]
["Vorige grafiek"]
[]
["Volgende grafiek"]
[]
["Data"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Resultaten voor een CCNR1/CCNR0 motor"]
[null,"Grafiek die milieuvoordelen uitzet tegenover de totale kosten voor de schipper. De grootte van de bel geeft weer hoe groot de investeringen zijn. "]
[null,{"$f":"Invoer_waarden!$D$45&\" - \" &Invoer_waarden!$G$63","v":"Motor vessels dry cargo 110 m ship - normal fuel use - Diesel"}]
[null,{"$f":"IF(Invoer_waarden!$G$63='Ship segment (Data)'!$S$18,'Ship segment (Data)'!$T$19,'Ship segment (Data)'!$T$18)","v":"_"}]
[]
[]
[]
[]
[]
["Vorige grafiek"]
[]
["Data"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"* GTL does not require any invesment. However a small sum is included in order to include GTL in the figure."]
[]
[]
[]
[]
[null,"Detailed results for CCNR1/unregulated engine"]
[null,"Kosten over 15 jaar (mil €)"]
[null,{"$f":"IF(Invoer_waarden!$G$63='Ship segment (Data)'!$S$18,'Ship segment (Data)'!$T$19,'Ship segment (Data)'!$T$18)","v":"_"}]
[null,"Cost factors","Unregulated engine revision","SCR unregulated engine","SCR+DPF unregulated engine","FWE unregulated engine","GTL unregulated engine","Stage V","LNG mono fuel","LNG Dual fuel refit","Diesel electric","Battery electric"]
[null,"Investments in start year",{"$f":"Results!D4","v":0},{"$f":"Results!I4","v":87031.607142857145},{"$f":"Results!K4","v":161784.60714285713},{"$f":"Results!O4","v":148636.83314285713},{"$f":"Results!Q4","v":0},{"$f":"Results!E4","v":609082.01428571425},{"$f":"Results!F4","v":1923862},{"$f":"Results!G4","v":996097},{"$f":"Results!L4","v":1099547.54},{"$f":"Results!M4","v":2732989.2390595516}]
[null,"Investments",{"$f":"Results!D19","v":100782.00000000003},{"$f":"Results!I19","v":187813.60714285716},{"$f":"Results!K19","v":262566.60714285716},{"$f":"Results!O19","v":249418.83314285715},{"$f":"Results!Q19","v":100782.00000000003},{"$f":"Results!E19","v":609082.01428571425},{"$f":"Results!F19","v":1923862},{"$f":"Results!G19","v":1096879},{"$f":"Results!L19","v":1099547.54},{"$f":"Results!M19","v":2732989.2390595516}]
[null,"Revision costs in start year",{"$f":"Results!D20","v":171826.60714285713},{"$f":"Results!I20","v":171826.60714285713},{"$f":"Results!K20","v":171826.60714285713},{"$f":"Results!O20","v":171826.60714285713},{"$f":"Results!Q20","v":171826.60714285713},{"$f":"Results!E20","v":0},{"$f":"Results!F20","v":0},{"$f":"Results!G20","v":0},{"$f":"Results!L20","v":0},{"$f":"Results!M20","v":0}]
[null,"Investments in assessment period",{"$f":"Results!D21","v":0},{"$f":"Results!I21","v":0},{"$f":"Results!K21","v":0},{"$f":"Results!O21","v":0},{"$f":"Results!Q21","v":0},{"$f":"Results!E21","v":0},{"$f":"Results!F21","v":0},{"$f":"Results!G21","v":0},{"$f":"Results!L21","v":0},{"$f":"Results!M21","v":0}]
["Naar de grafieken","Revision costs in assessment period (incl. SCR/DPF)",{"$f":"Results!D22","v":0},{"$f":"Results!I22","v":0},{"$f":"Results!K22","v":0},{"$f":"Results!O22","v":0},{"$f":"Results!Q22","v":0},{"$f":"Results!E22","v":0},{"$f":"Results!F22","v":0},{"$f":"Results!G22","v":0},{"$f":"Results!L22","v":0},{"$f":"Results!M22","v":0}]
[null,"Fuel (+ Urea)",{"$f":"Results!D23","v":2068401.3740154058},{"$f":"Results!I23","v":2143184.3218277274},{"$f":"Results!K23","v":2143184.3218277274},{"$f":"Results!O23","v":1983875.3563272762},{"$f":"Results!Q23","v":2298427.0166514008},{"$f":"Results!E23","v":2027197.7046621577},{"$f":"Results!F23","v":1488015.1335323923},{"$f":"Results!G23","v":1513113.3819056167},{"$f":"Results!L23","v":2027197.7046621577},{"$f":"Results!M23","v":842400.34259097313}]
[null,"Other operational costs",{"$f":"Results!D24","v":500405.70789508836},{"$f":"Results!I24","v":509443.60140004486},{"$f":"Results!K24","v":539139.86763008975},{"$f":"Results!O24","v":554752.16828249721},{"$f":"Results!Q24","v":500405.70789508836},{"$f":"Results!E24","v":528899.83280506299},{"$f":"Results!F24","v":272898.9621793917},{"$f":"Results!G24","v":272898.9621793917},{"$f":"Results!L24","v":453454.5367110314},{"$f":"Results!M24","v":197453.66608536025}]
[null,"Total TCO",{"$f":"SUM(C123:C128)","v":2841415.6890533515},{"$f":"SUM(D123:D128)","v":3012268.1375134867},3116717.4037435316,2959872.9648954878,3071441.3316893466,3165179.5517529352,3684776.095711784,2882891.3440850084,3580199.7813731893,3772843.247735885]
[null,"Environmental Costs: CO2",{"$f":"Results!D25","v":1945436.8337573109},{"$f":"Results!I25","v":1945436.8337573109},{"$f":"Results!K25","v":1945436.8337573109},{"$f":"Results!O25","v":1865935.8093008823},{"$f":"Results!Q25","v":1964142.9571588235},{"$f":"Results!E25","v":1870612.3401512606},{"$f":"Results!F25","v":2017379.3399945353},{"$f":"Results!G25","v":2022973.7622243436},{"$f":"Results!L25","v":1870612.3401512606},{"$f":"Results!M25","v":230942.36110663708}]
[null,"Environmental Costs: NOx",{"$f":"Results!D26","v":2742903.4576084837},{"$f":"Results!I26","v":557696.08065574325},{"$f":"Results!K26","v":557696.08065574325},{"$f":"Results!O26","v":2331467.9389672112},{"$f":"Results!Q26","v":2468613.1118476349},{"$f":"Results!E26","v":494440.80454372457},{"$f":"Results!F26","v":494440.80454372457},{"$f":"Results!G26","v":1078212.4226011033},{"$f":"Results!L26","v":494440.80454372457},{"$f":"Results!M26","v":0}]
[null,"Environmental Costs: PM",{"$f":"Results!D27","v":763801.53565561573},{"$f":"Results!I27","v":763801.53565561573},{"$f":"Results!K27","v":32249.398172125988},{"$f":"Results!O27","v":381900.76782780787},{"$f":"Results!Q27","v":534661.07495893107},{"$f":"Results!E27","v":25460.051188520523},{"$f":"Results!F27","v":25460.051188520523},{"$f":"Results!G27","v":225745.78720488193},{"$f":"Results!L27","v":25460.051188520523},{"$f":"Results!M27","v":0}]
[null,"Total enviromental costs",{"$f":"SUM(C130:C132)","v":5452141.8270214107},{"$f":"SUM(D130:D132)","v":3266934.4500686699},2535382.3125851802,4579304.5160959018,4967417.1439653886,{"$f":"SUM(H130:H132)","v":2390513.195883506},2537280.1957267807,3326931.9720303291,2390513.195883506,230942.36110663708]
[null,"Total SC",{"$f":"Results!D28","v":8293557.5160747617},{"$f":"Results!I28","v":6279202.587582157},{"$f":"Results!K28","v":5652099.7163287122},{"$f":"Results!O28","v":7539177.4809913887},{"$f":"Results!Q28","v":8038858.4756547352},{"$f":"H129+H133","v":5555692.7476364411},{"$f":"I129+I133","v":6222056.2914385647},{"$f":"J129+J133","v":6209823.3161153374},{"$f":"K129+K133","v":5970712.9772566948},{"$f":"L129+L133","v":4003785.6088425219}]
[]
[]
[null,"Meerkosten t.o.v. doorvaren over 15 jaar (mil €)",{"$f":"C121","v":"Unregulated engine revision"},"SCR","SCR DPF","FWE","GTL*",{"$f":"H121","v":"Stage V"},{"$f":"I121","v":"LNG mono fuel"},{"$f":"J121","v":"LNG Dual fuel refit"},{"$f":"K121","v":"Diesel electric"},{"$f":"L121","v":"Battery electric"}]
["Naar de grafiek","TCO extra costs",{"$f":"SUM(C123:C128)-SUM($C$123:$C$128)","v":0},170852.44846013514,275301.71469018003,118457.27584213624,230025.64263599506,323763.86269958364,843360.40665843245,41475.655031656846,738784.09231983777,931427.55868253345]
[null,"Enviromental benefits",{"$f":"SUM($C$130:$C$132)-SUM(C130:C132)","v":0},2185207.3769527408,2916759.5144362305,872837.31092550885,484724.68305602204,3061628.6311379047,2914861.63129463,2125209.8549910816,3061628.6311379047,5221199.4659147738]
[null,"Initial investment costs",{"$f":"C122-$C$122","v":0},{"$f":"D122-$C$122","v":87031.607142857145},{"$f":"E122-$C$122","v":161784.60714285713},{"$f":"F122-$C$122","v":148636.83314285713},1000,{"$f":"H122-$C$122","v":609082.01428571425},{"$f":"I122-$C$122","v":1923862},{"$f":"J122-$C$122","v":996097},{"$f":"K122-$C$122","v":1099547.54},{"$f":"L122-$C$122","v":2732989.2390595516}]
[null,"Total social costs",{"$f":"$C$134-C134","v":0},2014354.9284926048,2641457.7997460496,754380.03508337308,254699.04042002652,2737864.7684383206,2071501.2246361971,2083734.1999594243,2322844.5388180669,4289771.9072322398]
[null,null,null,null,null,null,"* GTL does not require any invesment. However a small sum is included in order to include GTL in the figure."]
[]
[null,"Extra costs over 15 years (€) - same data in columns"]
[null,null,"Initial investment costs","TCO extra costs","Enviromental benefits (euro)","Benefits / Costs"]
[null,{"$f":"D137","v":"SCR"},{"$f":"INDEX($C$140:$L$140,MATCH($B146,$C$137:$L$137,0))","v":87031.607142857145},{"$f":"INDEX($C$138:$L$138,MATCH($B146,$C$137:$L$137,0))","v":170852.44846013514},{"$f":"INDEX($C$139:$L$139,MATCH($B146,$C$137:$L$137,0))","v":2185207.3769527408},{"$f":"E146/D146","v":12.790026696413504}]
[null,{"$f":"E137","v":"SCR DPF"},161784.60714285713,{"$f":"INDEX($C$138:$L$138,MATCH($B147,$C$137:$L$137,0))","v":275301.71469018003},{"$f":"INDEX($C$139:$L$139,MATCH($B147,$C$137:$L$137,0))","v":2916759.5144362305},{"$f":"E147/D147","v":10.594774237852834}]
[null,{"$f":"F137","v":"FWE"},148636.83314285713,118457.27584213624,872837.31092550885,7.3683723074022724]
[null,{"$f":"G137","v":"GTL*"},"none",230025.64263599506,484724.68305602204,2.1072636837410186]
[null,{"$f":"H137","v":"Stage V"},609082.01428571425,323763.86269958364,3061628.6311379047,9.4563630592051311]
[null,{"$f":"I137","v":"LNG mono fuel"},1923862,843360.40665843245,2914861.63129463,3.4562467105183559]
[null,{"$f":"J137","v":"LNG Dual fuel refit"},996097,41475.655031656846,2125209.8549910816,51.239934688650173]
[null,{"$f":"K137","v":"Diesel electric"},1099547.54,738784.09231983777,3061628.6311379047,4.1441453097943137]
[null,{"$f":"L137","v":"Battery electric"},2732989.2390595516,931427.55868253345,5221199.4659147738,5.605588343660294]

{"sheet":"Resultaten_CCNR2_","index":2,"n_rows":161,"n_cols":13,"rows_kept":161,"cut":false,"hidden":false,"merged":[[38,11,38,18],[73,2,73,14],[2,11,2,18]]}
[null,null,"Resultaten voor een CCNR2 motor"]
[null,null,{"$f":"Resultaten_CCNR1_CCNR0!B2","v":"Kosten (mil Euro) voor schippers over 15 jaar"}]
[null,null,{"$f":"Invoer_waarden!$D$45&\" - \" &Invoer_waarden!$G$63","v":"Motor vessels dry cargo 110 m ship - normal fuel use - Diesel"}]
[null,null,{"$f":"IF(Invoer_waarden!$G$63='Ship segment (Data)'!$S$18,'Ship segment (Data)'!$T$19,'Ship segment (Data)'!$T$18)","v":"_"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Volgende grafiek"]
[]
["Data"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Resultaten voor een CCNR2 motor"]
[null,null,"Totale kosten (mil Euro) inclusief emissies over 15 jaar"]
[null,null,{"$f":"Invoer_waarden!$D$45&\" - \" &Invoer_waarden!$G$63","v":"Motor vessels dry cargo 110 m ship - normal fuel use - Diesel"}]
[null,null,{"$f":"IF(Invoer_waarden!$G$63='Ship segment (Data)'!$S$18,'Ship segment (Data)'!$T$19,'Ship segment (Data)'!$T$18)","v":"_"}]
[]
[]
[]
[]
[]
[]
[]
[]
["Vorige grafiek"]
[]
["Volgende grafiek"]
[]
["Data"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"* GTL does not require any invesment. However a small sum is included in order to include GTL in the figure."]
[]
[null,null,"Resultaten voor een CCNR2 motor"]
[null,null,"Grafiek die milieuvoordelen uitzet tegenover de totale kosten voor de schipper. De grootte van de bel geeft weer hoe groot de investeringen zijn. "]
[null,null,{"$f":"Invoer_waarden!$D$45&\" - \" &Invoer_waarden!$G$63","v":"Motor vessels dry cargo 110 m ship - normal fuel use - Diesel"}]
[null,null,{"$f":"IF(Invoer_waarden!$G$63='Ship segment (Data)'!$S$18,'Ship segment (Data)'!$T$19,'Ship segment (Data)'!$T$18)","v":"_"}]
[]
[]
[]
[]
[]
["Vorige grafiek"]
[]
["Data"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"* GTL does not require any invesment. However a small sum is included in order to include GTL in the figure."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Resultaten voor een CCNR2 motor"]
[null,null,"Kosten over 15 jaar (mil €)"]
[null,null,{"$f":"Invoer_waarden!D45","v":"Motor vessels dry cargo 110 m ship - normal fuel use"}]
[null,null,{"$f":"IF(Invoer_waarden!$G$63='Ship segment (Data)'!$S$18,'Ship segment (Data)'!$T$19,'Ship segment (Data)'!$T$18)","v":"_"}]
[null,null,"Cost factors","CCNR2 revision","SCR CCNR2","SCR+ DPF CCNR2","FWE CCNR2","GTL CCNR2","Stage V","LNG mono fuel","LNG Dual fuel refit","Diesel electric","Battery electric"]
[null,null,"Investments in start year",{"$f":"Results!C4","v":0},{"$f":"Results!H4","v":87031.607142857145},{"$f":"Results!J4","v":161784.60714285713},{"$f":"Results!N4","v":148636.83314285713},{"$f":"Results!P4","v":0},{"$f":"Results!E4","v":609082.01428571425},{"$f":"Results!F4","v":1923862},{"$f":"Results!G4","v":996097},{"$f":"Results!L4","v":1099547.54},{"$f":"Results!M4","v":2732989.2390595516}]
[null,null,"Investments",{"$f":"Results!C19","v":100782.00000000003},{"$f":"Results!H19","v":187813.60714285716},{"$f":"Results!J19","v":262566.60714285716},{"$f":"Results!N19","v":249418.83314285715},{"$f":"Results!P19","v":100782.00000000003},{"$f":"Results!E19","v":609082.01428571425},{"$f":"Results!F19","v":1923862},{"$f":"Results!G19","v":1096879},{"$f":"Results!L19","v":1099547.54},{"$f":"Results!M19","v":2732989.2390595516}]
[null,null,"Revision costs in start year",{"$f":"Results!C20","v":171826.60714285713},{"$f":"Results!H20","v":171826.60714285713},{"$f":"Results!J20","v":171826.60714285713},{"$f":"Results!N20","v":171826.60714285713},{"$f":"Results!P20","v":171826.60714285713},{"$f":"Results!E20","v":0},{"$f":"Results!F20","v":0},{"$f":"Results!G20","v":0},{"$f":"Results!L20","v":0},{"$f":"Results!M20","v":0}]
[null,null,"Investments in assessment period",{"$f":"Results!C21","v":0},{"$f":"Results!H21","v":0},{"$f":"Results!J21","v":0},{"$f":"Results!N21","v":0},{"$f":"Results!P21","v":0},{"$f":"Results!E21","v":0},{"$f":"Results!F21","v":0},{"$f":"Results!G21","v":0},{"$f":"Results!L21","v":0},{"$f":"Results!M21","v":0}]
[null,null,"Revision costs in assessment period (incl. SCR/DPF)",{"$f":"Results!C22","v":0},{"$f":"Results!H22","v":0},{"$f":"Results!J22","v":0},{"$f":"Results!N22","v":0},{"$f":"Results!P22","v":0},{"$f":"Results!E22","v":0},{"$f":"Results!F22","v":0},{"$f":"Results!G22","v":0},{"$f":"Results!L22","v":0},{"$f":"Results!M22","v":0}]
["Naar de grafieken",null,"Fuel (+ Urea)",{"$f":"Results!C23","v":2088289.8487655541},{"$f":"Results!H23","v":2128557.5898952656},{"$f":"Results!J23","v":2128557.5898952656},{"$f":"Results!N23","v":1983875.3563272762},{"$f":"Results!P23","v":2298427.0166514008},{"$f":"Results!E23","v":2027197.7046621577},{"$f":"Results!F23","v":1488015.1335323923},{"$f":"Results!G23","v":1513113.3819056167},{"$f":"Results!L23","v":2027197.7046621577},{"$f":"Results!M23","v":842400.34259097313}]
[null,null,"Other operational costs",{"$f":"Results!C24","v":502965.71660134505},{"$f":"Results!H24","v":509443.60140004486},{"$f":"Results!J24","v":541699.8763363465},{"$f":"Results!N24","v":554752.16828249721},{"$f":"Results!P24","v":502965.71660134505},{"$f":"Results!E24","v":528899.83280506299},{"$f":"Results!F24","v":272898.9621793917},{"$f":"Results!G24","v":272898.9621793917},{"$f":"Results!L24","v":453454.5367110314},{"$f":"Results!M24","v":197453.66608536025}]
[null,null,"Total TCO",{"$f":"SUM(D129:D135)","v":2863864.1725097564},{"$f":"SUM(E129:E135)","v":3084673.0127238818},3266435.2876601834,3108509.7980383448,3074001.3403956033,3774261.5660386491,5608638.0957117835,3878988.3440850084,4679747.3213731889,6505832.4867954366]
[null,null,"Environmental Costs: CO2",{"$f":"Results!C25","v":1964142.9571588235},{"$f":"Results!H25","v":1964142.9571588235},{"$f":"Results!J25","v":1964142.9571588235},{"$f":"Results!N25","v":1865935.8093008823},{"$f":"Results!P25","v":1964142.9571588235},{"$f":"Results!E25","v":1870612.3401512606},{"$f":"Results!F25","v":2017379.3399945353},{"$f":"Results!G25","v":2022973.7622243436},{"$f":"Results!L25","v":1870612.3401512606},{"$f":"Results!M25","v":230942.36110663708}]
[null,null,"Environmental Costs: NOx",{"$f":"Results!C26","v":1858986.9355191439},{"$f":"Results!H26","v":557696.08065574325},{"$f":"Results!J26","v":557696.08065574325},{"$f":"Results!N26","v":1580138.895191272},{"$f":"Results!P26","v":1673088.2419672296},{"$f":"Results!E26","v":494440.80454372457},{"$f":"Results!F26","v":494440.80454372457},{"$f":"Results!G26","v":1078212.4226011033},{"$f":"Results!L26","v":494440.80454372457},{"$f":"Results!M26","v":0}]
[null,null,"Environmental Costs: PM",{"$f":"Results!C27","v":322493.98172126},{"$f":"Results!H27","v":322493.98172126},{"$f":"Results!J27","v":32249.398172125988},{"$f":"Results!N27","v":161246.99086063},{"$f":"Results!P27","v":225745.78720488198},{"$f":"Results!E27","v":25460.051188520523},{"$f":"Results!F27","v":25460.051188520523},{"$f":"Results!G27","v":225745.78720488193},{"$f":"Results!L27","v":25460.051188520523},{"$f":"Results!M27","v":0}]
[null,null,"Total enviromental costs",{"$f":"SUM(D137:D139)","v":4145623.8743992276},{"$f":"SUM(E137:E139)","v":2844333.019535827},2554088.435986693,3607321.6953527844,3862976.9863309353,2390513.195883506,2537280.1957267807,3326931.9720303291,2390513.195883506,230942.36110663708]
[null,null,"Total SC",{"$f":"Results!C28","v":7009488.046908984},{"$f":"Results!H28","v":5841974.425116851},{"$f":"Results!J28","v":5658739.1165040191},{"$f":"Results!N28","v":6567194.6602482712},{"$f":"Results!P28","v":6936978.3267265391},{"$f":"Results!E28","v":5555692.7476364402},{"$f":"Results!F28","v":6698556.2914385637},{"$f":"Results!G28","v":6686323.3161153384},{"$f":"Results!L28","v":5970712.9772566939},{"$f":"Results!M28","v":4003785.6088425219}]
[]
[]
[null,null,"Meerkosten t.o.v. doorvaren over 15 jaar (mil €)",{"$f":"D128","v":"CCNR2 revision"},"SCR","SCR DPF","FWE","GTL*",{"$f":"I128","v":"Stage V"},{"$f":"J128","v":"LNG mono fuel"},{"$f":"K128","v":"LNG Dual fuel refit"},{"$f":"L128","v":"Diesel electric"},{"$f":"M128","v":"Battery electric"}]
[null,null,"TCO extra costs",{"$f":"SUM(D130:D135)-SUM($D$130:$D$135)","v":0},133777.23307126807,240786.5080075697,96008.792385731358,210137.16788584692,301315.37924317876,820911.92320202757,19027.171575251967,716335.60886343289,908979.07522612857]
["Naar de grafiek",null,"Enviromental benefits",{"$f":"SUM($D$137:$D$138)-SUM(D137:D138)","v":0},{"$f":"SUM($D$137:$D$139)-SUM(E137:E139)","v":1301290.8548634006},1591535.4384125345,538302.1790464432,282646.88806829229,1755110.6785157216,1608343.6786724469,818691.9023688985,1755110.6785157216,3914681.5132925906]
[null,null,"Initial investment costs",{"$f":"D129-$D$129","v":0},{"$f":"E129-$D$129","v":87031.607142857145},{"$f":"F129-$D$129","v":161784.60714285713},{"$f":"G129-$D$129","v":148636.83314285713},1000,{"$f":"I129-$D$129","v":609082.01428571425},{"$f":"J129-$D$129","v":1923862},{"$f":"K129-$D$129","v":996097},{"$f":"L129-$D$129","v":1099547.54},{"$f":"M129-$D$129","v":2732989.2390595516}]
[null,null,"Total social costs",{"$f":"$D$141-D141","v":0},1167513.621792133,1350748.9304049648,442293.38666071277,72509.7201824449,1453795.2992725438,310931.75547042023,323164.73079364561,1038775.0696522901,3005702.4380664621]
[null,null,null,null,null,null,null,"* GTL does not require any invesment. However a small sum is included in order to include GTL in the figure."]
[]
[]
[null,null,null,"Initial investment costs","TCO extra costs","Enviromental benefits (euro)","Benefits / Costs"]
[null,null,{"$f":"E144","v":"SCR"},{"$f":"INDEX($D$147:$M$147,MATCH($C153,$D$144:$M$144,0))","v":87031.607142857145},{"$f":"INDEX($D$145:$M$145,MATCH($C153,$D$144:$M$144,0))","v":133777.23307126807},{"$f":"INDEX($D$146:$M$146,MATCH($C153,$D$144:$M$144,0))","v":1301290.8548634006},{"$f":"F153/E153","v":9.7272968276310134}]
[null,null,{"$f":"F144","v":"SCR DPF"},{"$f":"INDEX($D$147:$M$147,MATCH($C154,$D$144:$M$144,0))","v":161784.60714285713},240786.5080075697,1591535.4384125345,{"$f":"F154/E154","v":6.6097367812755552}]
[null,null,{"$f":"G144","v":"FWE"},{"$f":"INDEX($D$147:$M$147,MATCH($C155,$D$144:$M$144,0))","v":148636.83314285713},96008.792385731358,538302.1790464432,5.6068008530273383]
[null,null,{"$f":"H144","v":"GTL*"},"none",210137.16788584692,282646.88806829229,1.3450589960450734]
[null,null,{"$f":"I144","v":"Stage V"},{"$f":"INDEX($D$147:$M$147,MATCH($C157,$D$144:$M$144,0))","v":609082.01428571425},301315.37924317876,1755110.6785157216,5.8248293961100694]
[null,null,{"$f":"J144","v":"LNG mono fuel"},{"$f":"INDEX($D$147:$M$147,MATCH($C158,$D$144:$M$144,0))","v":1923862},820911.92320202757,1608343.6786724469,1.9592158832326172]
[null,null,{"$f":"K144","v":"LNG Dual fuel refit"},{"$f":"INDEX($D$147:$M$147,MATCH($C159,$D$144:$M$144,0))","v":996097},19027.171575251967,818691.9023688985,43.027514579925523]
[null,null,{"$f":"L144","v":"Diesel electric"},{"$f":"INDEX($D$147:$M$147,MATCH($C160,$D$144:$M$144,0))","v":1099547.54},716335.60886343289,1755110.6785157216,2.4501234572164452]
[null,null,{"$f":"M144","v":"Battery electric"},{"$f":"INDEX($D$147:$M$147,MATCH($C161,$D$144:$M$144,0))","v":2732989.2390595516},908979.07522612857,3914681.5132925906,4.3066794604911314]

{"sheet":"Uitleg_resultaten","index":3,"n_rows":2,"n_cols":2,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Uitleg resultaten"]

{"sheet":"CBA figures","index":4,"n_rows":117,"n_cols":28,"rows_kept":117,"cut":false,"hidden":true,"merged":[[46,2,46,4],[28,2,28,4],[29,2,29,4],[30,2,30,4],[31,2,31,4],[45,2,45,4],[1,2,1,4],[2,2,2,4],[3,2,3,4],[4,2,4,4],[5,2,5,4],[6,2,6,4],[7,2,7,4],[8,2,8,4],[9,2,9,4],[10,2,10,4],[11,2,11,4],[12,2,12,4],[13,2,13,4],[14,2,14,4],[15,2,15,4],[16,2,16,4],[17,2,17,4],[19,2,19,4],[20,2,20,4],[36,4,40,4],[22,2,22,4],[23,2,23,4],[24,2,24,4],[25,2,25,4],[26,2,26,4]]}
[null,null,"Diesel (baseline)- Stage 5","Diesel baseline CCNR (2) at revision","Diesel baseline CCNR (0) at revision",null,"LNG mono fuel","LNG dual fuel",null,null,"SCR on Diesel baseline CCNR 2 at revision","SCR on Diesel baseline CCNR 0 at revision",null,null,"SCR/ DPF on Diesel baseline CCNR (2) at revision","SCR/ DPF on Diesel baseline CCNR 0 at revision",null,"Compatible prominent segments for Right Size","Diesel elctric (2x 40%)","Battery electric",null,null,"FWE (CCR2)","FWE (CCR0)",null,null,"GTL (CCNR2)","GTL (CCNR0)"]
["Legend","CE Delft Segment",{"$f":"INDEX('Shi Segment (Peter)'!$A$3:$A$20,MATCH($C$3,'Shi Segment (Peter)'!$B$3:$B$20,0))","v":"H"}]
["Purple - Independent value","Vessel Class",{"$f":"'Ship segment (Data)'!Z5","v":"Motor vessels dry cargo 110 m ship"}]
["Yellow - Own calculation","Propulsion power range (Kw)",{"$f":"INDEX('Shi Segment (Peter)'!$C$3:$C$20,MATCH($C$2,'Shi Segment (Peter)'!$A$3:$A$20,0))","v":0}]
["Red - Data/value not good (Source)","Prominent Category",{"$f":"INDEX('Shi Segment (Peter)'!$D$3:$D$20,MATCH($C$2,'Shi Segment (Peter)'!$A$3:$A$20,0))","v":"MVS 110m"}]
["Dark blue - Not used/ reference value","Sailing hours",{"$f":"'Ship segment (Data)'!AA5","v":"normal fuel use"}]
["Pink - Recheck the calculations","Average Propulsion power (kW) ",{"$f":"INDEX('Shi Segment (Peter)'!$I$3:$I$20,MATCH($C$2,'Shi Segment (Peter)'!$A$3:$A$20,0))","v":1527}]
[]
[null,"Diesel fuel consumption (m3/ year)",{"$f":"SUMPRODUCT(('Ship segment (Data)'!$H$59:$H$76='CBA figures'!$C$2)*('Ship segment (Data)'!$P$58:$R$58='CBA figures'!$C$6)*'Ship segment (Data)'!$P$59:$R$76)","v":307}]
[null,"Diesel fuel consumption (tonnes/ year)",{"$f":"C9*'Key Data'!$B$42","v":256.64150699119625}]
[null,"Energy consumption Diesel (GJ/ year)",{"$f":"C9*'Key Data'!$B$43","v":11008.7744}]
[null,"Energy consumption LNG mono fuel engine (GJ/year)",{"$f":"('Key Data'!$B$69/'Key Data'!$B$67)*C11","v":12537.770844444443}]
[null,"Energy consumption LNG dual fuel engine (GJ/year)",{"$f":"('Key Data'!$B$68/'Key Data'!$B$67)*C11","v":12537.770844444443}]
[null,"LNG fuel consumption mono fuel engine (Tonnes/year)",{"$f":"C12/'Key Data'!$B$70","v":255.8728743764172}]
[null,"LNG fuel consumption dual fuel engine (Tonnes/year)",{"$f":"C13*C17/'Key Data'!$B$70","v":243.07923065759633}]
[null,"Diesel consumption LNG Dual fuel (tonne)",{"$f":"(1-C17)*C10","v":12.832075349559824}]
[null,"Share of LNG in dual fuel",0.95]
[null,"Energy engine output (kWh/year)",{"$f":"C10*1000/'Key Data'!$B$44","v":1239814.0434357307}]
[null,"Energy engine output per day (300 days)",null,{"$f":"C18/300","v":4132.7134781191025}]
[null,"Estimated hours per year",{"$f":"C24","v":1943}]
[null,"Estimated hours per day",{"$f":"C20/365","v":5.3232876712328769}]
[null,"Lifetime battery",null,10]
[null,"Number of engines",{"$f":"INDEX('Ship segment (Data)'!$J$3:$J$34,MATCH($C$2,'Ship segment (Data)'!$A$3:$A$34,0))","v":1}]
[null,"Sailing hours (STC Nestra)",{"$f":"SUMPRODUCT(('Ship segment (Data)'!$H$59:$H$76='CBA figures'!$C$2)*('Ship segment (Data)'!$J$58:$L$58='CBA figures'!$C$6)*'Ship segment (Data)'!$J$59:$L$76)","v":1943}]
[null,"Max pay load",{"$f":"INDEX('Ship segment (Data)'!$H$3:$H$34,MATCH($C$2,'Ship segment (Data)'!$A$3:$A$34,0))","v":3043}]
[null,"Total Number of Engines (Prominent & IVR based)",{"$f":"INDEX('Shi Segment (Peter)'!$F$3:$F$218,MATCH($C$2,'Shi Segment (Peter)'!$A$3:$A$20,0))","v":575}]
[null,"Total Number of vessels (Prominent & IVR based)",{"$f":"INDEX('Shi Segment (Peter)'!$E$3:$E$20,MATCH($C$2,'Shi Segment (Peter)'!$A$3:$A$20,0))","v":575}]
[]
[null,"Engine lifetime min (hgh speed)",{"$f":"INDEX('Shi Segment (Peter)'!$N$29:$N$55,MATCH($C$2,'Shi Segment (Peter)'!$A$29:$A$55,0))","v":34}]
[null,"Engine Lifetime max",{"$f":"INDEX('Shi Segment (Peter)'!$L$29:$L$55,MATCH($C$2,'Shi Segment (Peter)'!$A$29:$A$55,0))","v":51}]
[null,"Assesement period",{"$f":"'Ship segment (Data)'!W5","v":15}]
[null,"Engine hours ",{"$f":"C31*C24","v":29145}]
[null,"Engines needed in assesment period (starting with new engine)",null,{"$f":"ROUNDUP(C31/C29,0)","v":1}]
[null,"Battery needed in assesment period (starting with new battery)",null,{"$f":"ROUNDUP(C31/D22,0)","v":2}]
[null,"Revision needed in assessment period (starting with new engine)",null,{"$f":"ROUNDUP((C31+C29/2)/C29,0)-1","v":0}]
[null,"Battery replacement in assessment period (starting with new battery)",null,{"$f":"ROUNDUP((C31+D22/2)/D22,0)-1","v":1}]
[null,"Engines needed in assesment period (starting with revision)",null,{"$f":"D35","v":0},"Engine/ revision in year 0 is included, at end of assesment period not."]
[null,"Revision needed in assessment period (starting with revision)",null,{"$f":"D33","v":1}]
[null,"Engines reaching end of life (starting with new engine)"]
[null,"Engines reaching end of life (starting with revision)"]
[null,"Interest over engine lifetime period",null,{"$f":"'Key Data'!B76^('CBA figures'!C29)-1","v":2.7943163405884071}]
[null,"Age of engine at end of asesment period (new enigine in 2020)",null,{"$f":"C31","v":15}]
[null,"Age of engine at end of asesment period (revision in 2020)",null,{"$f":"C31+C29/2-(D37)*C29","v":32}]
[null,"Age of battery at the end of assesment period (new engine)",null,{"$f":"C31+D22-(D36)*D22","v":15}]
[null,"Cost for iddling per day",null,{"$f":"SUMPRODUCT(('Ship segment (Data)'!$H$59:$H$76='CBA figures'!$C$2)*('Ship segment (Data)'!$S$58:$U$58='CBA figures'!$C$6)*'Ship segment (Data)'!$S$59:$U$76)","v":771.32142857142856}]
[null,"Port dues (€ per annum)",{"$f":"SUMPRODUCT(('Ship segment (Data)'!$H$59:$H$76='CBA figures'!$C$2)*('Ship segment (Data)'!$V$58:$X$58='CBA figures'!$C$6)*'Ship segment (Data)'!$V$59:$X$76)","v":14000}]
["Case LNG Monofuel","Definition/Assumption","Remarks"]
[null,"Diesel (New engine)"]
[null,"LNG Mono fuel (New/Retrofit)","Additional cost as comapred to diesel",null,null,null,null,null,null,null,null,null,null,"Life time engine hours (SCR & DPF)",30000]
[null,"LNG price",null,null,null,null,null,null,null,"Life time engine hours with (SCR)",30000,null,null,"Port due per annum (CCNR 2 or older) Baseline",{"$f":"C46","v":14000},null,null,"Life time electromotor (in years)",30]
[null,"Diesel price",null,null,null,null,null,null,null,"Port due per annum (CCNR 2 or older) ",{"$f":"C46","v":14000},null,null,"Number of replacements SCR up to 2050",{"$f":"ROUNDUP((C31*C20)/O49,0)-1","v":0}]
[null,"Equipment and installation","Tank will be bought instead of leased",null,null,null,null,null,null,"Number of replacements SCR in engine lifetime",{"$f":"ROUNDUP((C31*C20)/K50,0)-1","v":0},null,null,"Life time SCR (in years)",{"$f":"O49/C20","v":15.440041173443129}]
[null,"Environment (Cost and Benefit)",null,null,null,null,null,null,null,"Life time SCR (in years)",{"$f":"K50/C20","v":15.440041173443129},null,null,"Interest factor over lifetime",{"$f":"'Key Data'!B76^O52","v":1.832295268337756}]
[null,"Incentives (If available)",null,null,null,null,null,null,null,"Interest factor over lifetime",{"$f":"'Key Data'!B76^'CBA figures'!K53","v":1.832295268337756}]
[null,"Societal effects"]
[]
[null,"Compatible prominent segments for LNG fuel",null,{"$f":"INDEX('Shi Segment (Peter)'!$B$3:$B$20,MATCH($C$2,'Shi Segment (Peter)'!$A$3:$A$20,0))","v":"Motor vessels dry cargo 110 m ship"},null,null,null,null,null,null,null,null,null,null,null,null,null,"Relative power",0.8,0.8]
[null,"Cost type"]
[null,null,"Diesel (baseline)- Stage 5","Diesel baseline CCNR (2) at revision","Diesel baseline CCNR (0) at revision",null,"LNG mono fuel","LNG dual fuel - Refit",null,null,"SCR on Diesel baseline CCNR 2 at revision","SCR on Diesel baseline CCNR 0 at revision",null,null,"SCR/ DPF on Diesel baseline CCNR (2) at revision","SCR/ DPF on Diesel baseline CCNR 0 at revision",null,"Compatible prominent segments for Right Size",{"$f":"D57","v":"Motor vessels dry cargo 110 m ship"},{"$f":"S59","v":"Motor vessels dry cargo 110 m ship"}]
[null,null,"Values","Values","Values",null,"Values","Values",null,null,"Values",null,null,null,"Values","Values",null,"RS Hybrid,  Diesel 60 & Electricity 20%","Diesel elctric (2x 40%)",{"$f":"T1","v":"Battery electric"},"Investement costs ","Fuel water emulsion","FWE (CCR2)","FWE (CCR0)","Investement costs ","GTL","GTL (CCNR2)","GTL (CCNR0)"]
["Investment costs","Engine (New) (Euros)",{"$f":"'Key Data'!$B$11*C7","v":541168.79999999993},{"$f":"C7*'Key Data'!$B$12","v":335940},{"$f":"C7*'Key Data'!$B$12","v":335940},null,{"$f":"INDEX('Shi Segment (Peter)'!L3:$L$20,MATCH($C$2,'Shi Segment (Peter)'!$A$3:$A$20,0))+D61","v":1143765},{"$f":"INDEX('Shi Segment (Peter)'!$M$3:$M$20,MATCH($C$2,'Shi Segment (Peter)'!A3:A20,0))","v":216000},"Investment costs","Engine (New)",0,null,"Investment costs","Engine (New)",0,null,"Investement costs ",null,null,null,"(one time)","Engine (New)",0,0,"(One time)","Total investment cost (New build & Retrofit) (if any)"]
[null,null,null,null,null,null,null,null,"(One time)","Equipment cost 30000hrs (Euro per vessel) ",{"$f":"IF(C7<2000,'Key Data'!$B$79*$C$7,'Key Data'!$B$80*$C$7)","v":38175},null,null,"Equipment cost 30000hrs (Euro per vessel) (SCR Only)",{"$f":"K62","v":38175},null,"(one time)","Generator set ",{"$f":"S57*C7*'Key Data'!B11","v":432935.04000000004},null,null,"Equipment cost (Incl installation cost)",{"$f":"$C$7*'Key Data'!$B$163+'Key Data'!$B$164","v":116890},{"$f":"$C$7*'Key Data'!$B$163+'Key Data'!$B$164","v":116890},null,"Revision of engine"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Equipment cost 30000hrs (Euro per vessel) (DPF Only)",{"$f":"'Key Data'!$B$81*C7","v":59553},null,null,"Electromotor + Controller",{"$f":"S57*C7*'Key Data'!$B$123","v":610800.00000000012},{"$f":"S63","v":610800.00000000012},null,null,null,null,null,"Revision time"]
["(One time)","Tank (Euros)",0,0,0,null,{"$f":"'Key Data'!B52","v":165000},{"$f":"'Key Data'!B52","v":165000},null,"Design and installation per unit (incl tank + compr)",{"$f":"C23*'Key Data'!$B$83","v":45000},null,null,"Total equipment costs ",{"$f":"SUM(O62:O63)","v":97728},null,null,"Additional equipment cost (€) - Retrofit (Deinstallation/rebuild engine room)",{"$f":"K64","v":45000},{"$f":"S64","v":45000},null,"Reverse osomosis systems",{"$f":"$C$7*'Key Data'!$B$169","v":8990.9760000000006},{"$f":"$C$7*'Key Data'!$B$169","v":8990.9760000000006},null,"Scrap value of existing engine (value for \"rebuying\", instead of restvalue for case)"]
[null,"Tank connection space (Euros)",0,0,0,null,{"$f":"'Key Data'!B51","v":377500},{"$f":"'Key Data'!B51","v":377500},null,null,null,null,null,"NPV Additional costs after 30000 hours (30 yrs) (SCR + DPF)",{"$f":"-1.1*PV((O53-1),O51,O64)","v":0},null,null,"Battery benodigde pakket is 2 maal zo groot als dagelijkse benodigde energie. Dit kunnen ook 4 batterijpakketten zijn",null,{"$f":"D19*'Key Data'!B152*2","v":2066356.7390595514},null,"Measurement after installation costs",{"$f":"'Key Data'!$B$172","v":3500},{"$f":"'Key Data'!$B$172","v":3500},null,"NPV Scrap value new engine after 30 years"]
[null,"a. Installation costs (Tank above deck - Retrofit/NB) (Euros)",{"$f":"O66+O67","v":60200},0,0,null,{"$f":"INDEX('Shi Segment (Peter)'!M3:M210,MATCH($C$2,'Shi Segment (Peter)'!$A$3:$A$20,0))","v":216000},{"$f":"INDEX('Shi Segment (Peter)'!M3:M210,MATCH($C$2,'Shi Segment (Peter)'!$A$3:$A$20,0))","v":216000},null,null,null,null,null,"Design and installation per unit (DPF)",{"$f":"C23*'Key Data'!$B$84","v":15200},null,null,"Levensduur batterij pakket",null,{"$f":"3000/300*2","v":20},null,"Additional cost (Based on Kw)"]
[null,"b. Installation costs (Tank under deck - Retrofit) (Euros)",0,0,0,null,{"$f":"INDEX('Shi Segment (Peter)'!$O$3:$O$20,MATCH($C$2,'Shi Segment (Peter)'!$A$3:$A$20,0))","v":692500},{"$f":"INDEX('Shi Segment (Peter)'!$O$3:$O$20,MATCH($C$2,'Shi Segment (Peter)'!$A$3:$A$20,0))","v":692500},null,null,null,null,null,"Design and installation per unit (incl tank + compr) (SCR)",{"$f":"C23*'Key Data'!$B$83","v":45000},null,null,"Days idle",{"$f":"'Key Data'!B151","v":14},{"$f":"S67","v":14},null,"Installation costs",{"$f":"'Key Data'!$B$166","v":10000},{"$f":"'Key Data'!$B$166","v":10000}]
[null,"Days idling",10,{"$f":"C68/2","v":5},{"$f":"C68/2","v":5},null,{"$f":"'Key Data'!$B$53","v":28},{"$f":"'Key Data'!$B$53","v":28},null,"Days idle",{"$f":"'Key Data'!B107","v":5},null,null,"Days idle",{"$f":"'Key Data'!B107","v":5},null,null,"Oppurtunity cost",{"$f":"S67*D45","v":10798.5},{"$f":"S68","v":10798.5},null,"Idle time (days) ",{"$f":"'Key Data'!$B$165","v":12},{"$f":"'Key Data'!$B$165","v":12}]
[null,"Oppurtunity cost (Idling cost) (Euros)",{"$f":"C68*D45","v":7713.2142857142853},{"$f":"D68*D45","v":3856.6071428571427},{"$f":"E68*D45","v":3856.6071428571427},null,{"$f":"G68*D45","v":21597},{"$f":"H68*D45","v":21597},null,"Oppurtunity cost (Idling cost) (Euros)",{"$f":"K68*D45","v":3856.6071428571427},null,null,"Oppurtunity cost (Idling cost) (Euros)",{"$f":"O68*D45","v":3856.6071428571427},null,null," Scrap value end of life",{"$f":"S62*'Key Data'!$B$74","v":43293.504000000008},null,null,"Oppurtunity cost",{"$f":"W68*$D$45","v":9255.8571428571431},{"$f":"X68*$D$45","v":9255.8571428571431}]
[null,"Scrap value end of life",{"$f":"('Key Data'!$B$74*C61)","v":54116.88},{"$f":"('Key Data'!$B$74*D61)","v":33594},{"$f":"('Key Data'!$B$74*E61)","v":33594},null,{"$f":"('Key Data'!$B$74*G61)","v":114376.5},{"$f":"('Key Data'!$B$74*H61)","v":21600},null,null,null,null,null,null,null,null,null,"Revision of engine ",{"$f":"S62*'Key Data'!$B$71","v":216467.52000000002},{"$f":"T65*'Key Data'!$B$71","v":1033178.3695297757},null,"Scrap value end of life",{"$f":"D69","v":3856.6071428571427},{"$f":"E69","v":3856.6071428571427}]
[null,"Revision costs of engine",{"$f":"'Key Data'!$B$71*'CBA figures'!C61","v":270584.39999999997},{"$f":"'Key Data'!$B$71*'CBA figures'!D61","v":167970},{"$f":"'Key Data'!$B$71*'CBA figures'!E61","v":167970},null,{"$f":"C71","v":270584.39999999997},{"$f":"C71","v":270584.39999999997},null,null,null,null,null,null,null,null,null,"Residual value of electro engine",{"$f":"IF($D$42<=$C$29/2,S63-$D$42/$C$29*'Key Data'!$B$75*S63,S63*(1+'Key Data'!$B$71)-$D$42/$C$29*'Key Data'!$B$75*S63)","v":233541.17647058831},{"$f":"S71","v":233541.17647058831},null,"Revision costs of engine",{"$f":"D71","v":167970},{"$f":"E71","v":167970}]
[null,"Residual Value of engine after assement period ",{"$f":"IF(Results!$K$3='Shi Segment (Peter)'!$AF$4,IF($D$42<=$C$29/2,$C$61-$D$42/$C$29*'Key Data'!$B$75*$C$61,$C$61*(1+'Key Data'!$B$71)-$D$42/$C$29*'Key Data'!$B$75*$C$61),0)","v":0},{"$f":"IF(Results!$K$3='Shi Segment (Peter)'!$AF$4,IF(D37=0,IF(D43<=C29/2,D61-D43/C29*'Key Data'!$B$75*D61,D61*(1+'Key Data'!$B$71)-D43/C29*'Key Data'!$B$75*D61),IF(D43<=C29/2,C61-D43/C29*'Key Data'!$B$75*C61,C61*(1+'Key Data'!$B$71)-D43/C29*'Key Data'!$B$75*C61)),0)","v":0},{"$f":"IF(Results!$K$3='Shi Segment (Peter)'!$AF$4,IF(D37=0,IF(D43<=C29/2,E61-D43/C29*'Key Data'!$B$75*E61,E61*(1+'Key Data'!$B$71)-D43/C29*'Key Data'!$B$75*E61),IF(D43<=C29/2,C61-D43/C29*'Key Data'!$B$75*C61,C61*(1+'Key Data'!$B$71)-D43/C29*'Key Data'!$B$75*C61)),0)","v":0},null,{"$f":"IF(Results!$K$3='Shi Segment (Peter)'!$AF$4,IF(D42<=C29/2,(G61+G64)-D42/C29*'Key Data'!$B$75*(G61+G64),(G61+G64)*(1+'Key Data'!$B$71)-D42/C29*'Key Data'!$B$75*(G61+G64)),0)","v":0},{"$f":"IF(Results!$K$3='Shi Segment (Peter)'!$AF$4,IF(D43<=C29/2,(H61+H64)-D43/C29*'Key Data'!$B$75*(H61+H64),(H61+H64)*(1+'Key Data'!$B$71)-D43/C29*'Key Data'!$B$75*(H61+H64))+D72,0)","v":0},null,null,null,null,null,null,null,null,null,"Residual Value of engine after assement period ",{"$f":"IF(Results!$K$3='Shi Segment (Peter)'!$AF$4,IF($D$42<=$C$29/2,S62-$D$42/$C$29*'Key Data'!$B$75*S62,S62*(1+'Key Data'!$B$71)-$D$42/$C$29*'Key Data'!$B$75*S62)+S71,0)","v":0},{"$f":"IF(Results!$K$3='Shi Segment (Peter)'!$AF$4,T65*(1-(C31/T66))+T71,0)","v":0},null,"Residual Value of engine after assement period ",{"$f":"IF(Results!$K$3='Shi Segment (Peter)'!$AF$4,IF($D$42<=$C$29,$C$61-$D$42/$C$29*'Key Data'!$B$75*$C$61,$C$61*(1+'Key Data'!$B$71)-$D$42/$C$29*'Key Data'!$B$75*$C$61),0)","v":0},{"$f":"IF(Results!$K$3='Shi Segment (Peter)'!$AF$4,IF($D$42<=$C$29,$C$61-$D$42/$C$29*'Key Data'!$B$75*$C$61,$C$61*(1+'Key Data'!$B$71)-$D$42/$C$29*'Key Data'!$B$75*$C$61),0)","v":0}]
[null,"Total engine and installation costs in 2020 (tank above deck) or revision costs",{"$f":"C61+C64+C65+C66+C69","v":609082.01428571425},0,0,null,{"$f":"G61+G64+G65+G66+G69","v":1923862},{"$f":"H61+H64+H65+H66+H69","v":996097},null,"Total installation costs in 2020 costs",{"$f":"K61+K62+K64+K69","v":87031.607142857145},null,null,"Total installation costs in 2020 costs",{"$f":"O61+O62+O63+O66+O67+O69","v":161784.60714285713},null,null,"Total engine and installation costs in 2020 (tank above deck) or revision costs",{"$f":"SUM(S61:S68)","v":1099547.54},{"$f":"SUM(T61:T68)","v":2732989.2390595516},null,"Total engine and installation costs in 2020 ",{"$f":"SUM(W62:W67)+W69","v":148636.83314285713},{"$f":"SUM(X62:X67)+X69","v":148636.83314285713}]
[null,"NPV Additional costs after 30000 hours (30 yrs)",{"$f":"O74","v":0},null,null,null,null,null,null,"NPV Additional costs after 30.000 hours (during engine lifetime)",{"$f":"-1.1*PV((K54-1),K52,K62)","v":0},null,null,"NPV Additional costs after 30000 hours (30 yrs)",{"$f":"-1.1*PV((O53-1),O51,O64)","v":0},null,null,{"$f":"J74","v":"NPV Additional costs after 30.000 hours (during engine lifetime)"},{"$f":"K74","v":0},0]
[null,"Engine replacement in assement period",{"$f":"-PV(D41,D33-1,C61+C71)","v":0},{"$f":"-PV(D41,D37,(C61+C69)*'Key Data'!$B$76^('CBA figures'!C29/2))","v":0},{"$f":"-PV(D41,D37,(C61+C69)*'Key Data'!$B$76^('CBA figures'!C29/2))","v":0},null,{"$f":"-PV(D41,D33-1,G61+C69)","v":0},{"$f":"-PV(D41,D37,(C61+C69)*'Key Data'!$B$76^(C29/2))-PV(D41,D33-1,H61+C69)","v":0},null,"Engine replacement in assement period",{"$f":"D75","v":0},null,null,"Engine replacement in assement period",{"$f":"D75","v":0},null,null,"Engine replacement in assement period",{"$f":"-PV($D41,$D33-1,S62+$C69)","v":0},{"$f":"-PV($D41,$D34-1,T65+$T68)","v":547438.60358713125},null,"Engine replacement in assement period",{"$f":"D75","v":0},0]
[null,"Rest value (Value for \"rebuying\", instead of restvalue for other cases)",null,{"$f":"D61-0.5*'Key Data'!B75*D61","v":100782.00000000003},{"$f":"E61-0.5*'Key Data'!B75*E61","v":100782.00000000003},null,null,{"$f":"D76","v":100782.00000000003},null,"Rest value (Value for \"rebuying\", instead of restvalue for other cases)",100782.00000000003,null,null,"Rest value (Value for \"rebuying\", instead of restvalue for other cases)",{"$f":"D76","v":100782.00000000003},null,null,"Rest value (Value for \"rebuying\", instead of restvalue for other cases)",null,{"$f":"S76","v":0},null,"Rest value (Value for \"rebuying\", instead of restvalue for other cases)",100782.00000000003,100782.00000000003]
[null,"Scrap value During life time",{"$f":"PV('Key Data'!$B$66,(D33-1),C70)","v":0},{"$f":"IF(D37<2,0,-D70/'Key Data'!$B$76^(C29/2)+PV(D41,(D37-2),C70/'Key Data'!$B$76^('CBA figures'!C29/2)))","v":0},{"$f":"IF(D37<2,0,-E70/'Key Data'!$B$76^(C29/2)+PV(D41,(D37-2),C70/'Key Data'!$B$76^('CBA figures'!C29/2)))","v":0},null,{"$f":"PV('Key Data'!$B$66,(D33-1),'CBA figures'!G70)","v":0},{"$f":"PV('Key Data'!$B$66,(D37),H70*'Key Data'!$B$76^(C29/2))","v":0},null,"Scrap value During life time",0,null,null,"Scrap value During life time",0,null,null,"Scrap value During life time",{"$f":"PV('Key Data'!$B$66,($D33-1),S69)","v":0},{"$f":"PV('Key Data'!$B$66,($D33-1),T69)","v":0},null,"Scrap value During life time",0,0]
[null,"Residual Value at end of assesment period",{"$f":"-C72/'Key Data'!$B$76^C31","v":0},{"$f":"-D72/'Key Data'!$B$76^C31","v":0},{"$f":"-E72/'Key Data'!$B$76^C31","v":0},null,{"$f":"-G72/'Key Data'!$B$76^C31","v":0},{"$f":"-H72/'Key Data'!$B$76^C31","v":0},null,"Residual Value at end of assesment period",{"$f":"D78","v":0},"Aaname: Geen restwaarde van SCR",null,"Residual Value at end of assesment period",0,null,null,"NPV Residual Value at end of assesment period",{"$f":"-S72/'Key Data'!$B$76^C31","v":0},{"$f":"-T72/'Key Data'!$B$76^C31","v":0},null,"Residual Value at end of assesment period",0,0]
[null,"Revision costs in 2020",0,{"$f":"D71+D69","v":171826.60714285713},{"$f":"E71+E69","v":171826.60714285713},null,0,0,null,"Revision costs in 2020",171826.60714285713,null,null,"Revision costs in 2020",171826.60714285713,null,null,"Revision costs in 2020",0,{"$f":"S79","v":0},null,"Revision costs in 2020",{"$f":"D79","v":171826.60714285713},{"$f":"E79","v":171826.60714285713}]
[null,"Revision costs during lifetime",{"$f":"-PV(D41,D35,(C71+D69)*'Key Data'!$B$76^(C29/2))","v":0},{"$f":"-PV(D41,D38-1,(C71+D69))","v":0},{"$f":"-PV(D41,D38-1,(C71+E69))","v":0},null,{"$f":"-PV(D41,D35,(G71+D69)*'Key Data'!$B$76^(C29/2))","v":0},{"$f":"-PV(D41,D38-1,(H71+D69))","v":0},null,"Revision costs during lifetime",0,null,null,"Revision costs during lifetime",0,null,null,"Revision costs during lifetime",{"$f":"-PV($D41,$D35,(S70+$D69)*'Key Data'!$B$76^($C29/2))","v":0},{"$f":"-PV($D41,$D35,(T70+$D69)*'Key Data'!$B$76^($C29/2))","v":0},null,"Revision costs during lifetime",0,0]
["Operational cost ","Fuel consumption (LNG/Phase V/CCNR2 or older) (tonne)",{"$f":"C10","v":256.64150699119625},{"$f":"C10*(1+'Key Data'!B117)","v":269.47358234075608},{"$f":"C10*(1+'Key Data'!B118)","v":266.90716727084413},null,{"$f":"C14","v":255.8728743764172},{"$f":"C15+C16","v":255.91130600715616},"Operational cost ","Fuel consumption (Tonnes/year) includes fuel penalty ",{"$f":"('Key Data'!$B$117*C10)+C10","v":269.47358234075608},{"$f":"('Key Data'!$B$118*C10)+C10","v":266.90716727084413},"Operational cost ","Fuel consumption (Tonnes/year) includes fuel penalty ",{"$f":"K81","v":269.47358234075608},{"$f":"L81","v":266.90716727084413},"Operational cost","Fuel consumption (RS/Phase V/CCNR2 or older)",{"$f":"C81","v":256.64150699119625},{"$f":"C18/0.9","v":1377571.159373034},"Operational cost","Fuel consumption (tonnes/yr)",{"$f":"D81-(D81*'Key Data'!$B$176)","v":255.99990322371826},{"$f":"E81-(E81*'Key Data'!$B$176)","v":253.56180890730192},"Operational cost","Fuel consumption (tonnes/year)",{"$f":"D81","v":269.47358234075608},{"$f":"E81","v":266.90716727084413}]
[null,"Fuel cost (€ /yr) (Based on 2018 prices)",{"$f":"C81*'Key Data'!$B$204","v":178879.13037286379},{"$f":"D81*'Key Data'!$B$204","v":187823.086891507},{"$f":"E81*'Key Data'!$B$204","v":186034.29558777835},null,{"$f":"G81*'Key Data'!$B$9","v":133833.71847856388},{"$f":"C15*'Key Data'!$B$9+C16*'Key Data'!B7","v":136091.08255463568},"per year","Fuel cost (€ /yr) (Based on 2018 prices) (Euros)",{"$f":"K81*'Key Data'!$B$204","v":187823.086891507},{"$f":"L81*'Key Data'!$B$204","v":186034.29558777835},"per year","Fuel cost (€ /yr)  (Based on 2018 prices) (Euros)",{"$f":"O81*'Key Data'!$B$204","v":187823.086891507},{"$f":"P81*'Key Data'!$B$204","v":186034.29558777835},"(per year)","Fuel cost (€ /yr) (Based on 2018 prices)",{"$f":"S81*'Key Data'!$B$204","v":178879.13037286379},{"$f":"T81*'Key Data'!B154","v":75766.413765516874},"(per year)","Fuel cost (€ /yr) (Based on 2018 prices)",{"$f":"W81*'Key Data'!$B$204","v":178431.93254693164},{"$f":"X81*'Key Data'!$B$204","v":176732.58080838944},"(per year)","Fuel cost (€ /yr) (Based on 2018 prices)",{"$f":"AA81*'Key Data'!$B$193","v":206723.05499999999},{"$f":"AB81*'Key Data'!$B$193","v":204754.26400000002}]
[null,"Urea consumption liter/ year)",{"$f":"'Key Data'!B90*'CBA figures'!C81*1000","v":12318.79233557742},null,null,null,null,0,null,null,null,null,null,null,null,null,null,"Urea consumption liter/ year)",{"$f":"C83","v":12318.79233557742},0]
[null,"Urea costs euro/ year)",{"$f":"C83*'Key Data'!$B$94","v":3449.2618539616778},null,null,null,null,0,null,"Urea cost per year ",{"$f":"'Key Data'!$B$90*K81*1000*'Key Data'!$B$94","v":3621.7249466597623},{"$f":"'Key Data'!$B$91*L81*1000*'Key Data'!$B$94","v":6726.0606152252722},null,"Urea cost per year ",{"$f":"'Key Data'!$B$90*O81*1000*'Key Data'!$B$94","v":3621.7249466597623},{"$f":"'Key Data'!$B$91*P81*1000*'Key Data'!$B$94","v":6726.0606152252722},null,"Urea costs euro/ year)",{"$f":"C84","v":3449.2618539616778},0]
[null,"Insurance cost per year (Euros)",{"$f":"D85","v":0},{"$f":"Results!U43","v":0},{"$f":"D85","v":0},null,{"$f":"D85","v":0},{"$f":"D85","v":0},null,"Insurance cost per year",{"$f":"D85","v":0},{"$f":"K85","v":0},null,"Insurance cost per year",{"$f":"K85","v":0},{"$f":"L85","v":0},null,"Insurance cost per year (Euros)",{"$f":"D85","v":0},0,null,"Insurance cost per year (Euros)",{"$f":"G85","v":0},{"$f":"H85","v":0},null,"Insurance cost per year (Euros)",{"$f":"G85","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Repair and maintenance in euro per annum (SCR)",{"$f":"C18*'Key Data'!$B$88/1000","v":2479.6280868714616},{"$f":"C18*'Key Data'!$B$88/1000","v":2479.6280868714616}]
[null,null,null,null,null,null,null,null,null,"Additional Repair and maintenance cost (per annum)",{"$f":"(C18*'Key Data'!$B$88/1000)","v":2479.6280868714616},{"$f":"K87","v":2479.6280868714616},null,"Repair and maintenance in euro per annum (DPF)",{"$f":"(C18*'Key Data'!$B$89)/1000","v":2901.1648616396096},{"$f":"(C18*'Key Data'!$B$89)/1000","v":2901.1648616396096},null,null,null,null,null,"FWE Maintenance cost (Engine hours based)",{"$f":"'Key Data'!$B$173*$C$20","v":485.75},{"$f":"'Key Data'!$B$173*$C$20","v":485.75}]
[null,"Repair and Maintenance (Euros)",{"$f":"O88","v":12441.83294851107},{"$f":"C9*'Key Data'!$B$124+'Key Data'!$B$125*C7","v":7061.04},{"$f":"C9*'Key Data'!$B$124+'Key Data'!$B$125*C7","v":7061.04},null,{"$f":"C88","v":12441.83294851107},{"$f":"C88","v":12441.83294851107},null,"Total repair and maintenance costs per annum (Additional on top of baseline vessel)",{"$f":"K87+D88","v":9540.6680868714611},{"$f":"L87+E88","v":9540.6680868714611},null,"Total Repair and maintenance cost (Euros per annum) (SCR + DPF)",{"$f":"O86+O87+D88","v":12441.83294851107},{"$f":"P86+P87+D88","v":12441.83294851107},null,"Total maintenance cost",{"$f":"S57*$C7*'Key Data'!$B$125+$C9*'Key Data'!$B$124","v":5656.2000000000007},{"$f":"T57*$C7*'Key Data'!$B$125+$C9*'Key Data'!$B$124","v":5656.2000000000007},null,"Repair and Maintenance costs ",{"$f":"G88","v":12441.83294851107},{"$f":"H88","v":12441.83294851107},null,"Maintenance cost (Engine hours based)",{"$f":"G88","v":12441.83294851107},{"$f":"H88","v":12441.83294851107}]
[null,"Oil duty under the CCR convention (Euro per annum)",{"$f":"('Key Data'!$B$57)*(C81/'Key Data'!$B$42)*10","v":23025},{"$f":"('Key Data'!$B$57)*(D81/'Key Data'!$B$42)*10","v":24176.25},{"$f":"('Key Data'!$B$57)*(E81/'Key Data'!$B$42)*10","v":23946.000000000004},null,null,null,null,"Oil duty under the CCR convention (Euro per annum)",{"$f":"('Key Data'!$B$57)*(K81/'Key Data'!$B$42)*10","v":24176.25},{"$f":"('Key Data'!$B$57)*(L81/'Key Data'!$B$42)*10","v":23946.000000000004},null,"Oil duty under the CCR convention (Euro per annum)",{"$f":"('Key Data'!$B$57)*(O81/'Key Data'!$B$42)*10","v":24176.25},{"$f":"('Key Data'!$B$57)*(P81/'Key Data'!$B$42)*10","v":23946.000000000004},null,"Oil duty under the CCR convention (Euro per annum)",{"$f":"('Key Data'!$B$57)*(S81/'Key Data'!$B$42)*10","v":23025},0,null,"Oil duty under the CCNR convention (Euro per annum)",{"$f":"('Key Data'!$B$57)*(W81/'Key Data'!$B$42)*10","v":22967.437499999996},{"$f":"('Key Data'!$B$57)*(X81/'Key Data'!$B$42)*10","v":22748.700000000004},null,"Oil duty under the CCR convention (Euro per annum)",{"$f":"('Key Data'!$B$57)*(AA81/'Key Data'!$B$42)*10","v":24176.25},{"$f":"('Key Data'!$B$57)*(AB81/'Key Data'!$B$42)*10","v":23946.000000000004}]
[null,"Port dues per annum (Euros)",{"$f":"(D90-C98)","v":12103},{"$f":"C46","v":14000},{"$f":"C46","v":14000},null,{"$f":"(D90-G98)","v":12103},{"$f":"(D90-H98)","v":12103},null,"Port dues (Euros per annum) ",{"$f":"(K51-K98)","v":12103},12103,null,"Port dues (Euros per annum) (CCNR1 & CCNR2)",{"$f":"(O50-O98)","v":12103},{"$f":"O90","v":12103},null,"Port dues ",{"$f":"C90","v":12103},{"$f":"S90","v":12103},null,"Port dues (Euros per annum) (CCNR1 & CCNR2)",{"$f":"D90","v":14000},{"$f":"E90","v":14000},null,"Port dues (Euros per annum) (CCNR1 & CCNR2)",{"$f":"D90","v":14000},{"$f":"E90","v":14000}]
["External Costs","CO2 (tonne /year)",{"$f":"'Key Data'!$B$205*C81","v":1004.2382168565509},{"$f":"'Key Data'!$B$205*D81","v":1054.4501276993785},{"$f":"'Key Data'!$B$205*E81","v":1044.4077455308129},null,{"$f":"'Key Data'!$B$25*C14","v":944.17090644897951},{"$f":"'Key Data'!$B$25*C15+C16*'Key Data'!$B$24","v":947.17427196935807},"External Costs","CO2 (tonne /year)",{"$f":"'Key Data'!$B$205*K81","v":1054.4501276993785},{"$f":"'Key Data'!$B$205*L81","v":1044.4077455308129},"External Costs","CO2 (tonne /year)",{"$f":"'Key Data'!$B$205*O81","v":1054.4501276993785},{"$f":"'Key Data'!$B$205*P81","v":1044.4077455308129},"External costs","CO2 (tonne /year) ",{"$f":"'Key Data'!$B$205*S81","v":1004.2382168565509},{"$f":"C18*'Key Data'!$B$157","v":123.98140434357308},"External costs","CO2 (tonne /year) CCNR2",{"$f":"'Key Data'!$B$205*W81","v":1001.7276213144095},{"$f":"'Key Data'!$B$205*X81","v":992.18735825427234},"Operational benefits","CO2 (tonne /year) ",{"$f":"'Key Data'!$B$24*AA81","v":1054.4501276993785},{"$f":"'Key Data'!$B$24*AB81","v":1044.4077455308129}]
[null,"Nox (kg/ year)",{"$f":"C18*'Key Data'!B31/1000","v":2219.2671377499578},{"$f":"C18*'Key Data'!$B$30/1000","v":8343.9485123224695},{"$f":"C18*'Key Data'!$B$28/1000","v":12311.353451316805},null,{"$f":"C18*'Key Data'!$B$31/1000","v":2219.2671377499578},{"$f":"C18*'Key Data'!$B$34/1000","v":4839.4901371470314},null,"Nox (kg/ year)",{"$f":"D92*(1-'Key Data'!$B$110)","v":2503.1845536967412},{"$f":"E92*(1-'Key Data'!$B$110)","v":3693.4060353950422},null,"Nox (kg/ year)",{"$f":"K92","v":2503.1845536967412},{"$f":"L92","v":3693.4060353950422},"(per year)","Nox (kg/ year)",{"$f":"C92","v":2219.2671377499578},0,"(per year)","Nox (kg/ year) ",{"$f":"D92*(1-'Key Data'!$B$178)","v":7092.3562354740989},{"$f":"E92*(1-'Key Data'!$B$178)","v":10464.650433619285},"(per year)","Nox (kg/ year)",{"$f":"($C$18*'Key Data'!$B$30/1000)*(1-'Key Data'!$B$197)","v":7509.5536610902227},{"$f":"($C$18*'Key Data'!$B$28/1000)*(1-'Key Data'!$B$197)","v":11080.218106185124}]
[null,"PM (kg/year) (PM 2.5)",{"$f":"'Key Data'!B38*C18/1000","v":18.59721065153596},{"$f":"C18*'Key Data'!$B$37/1000","v":235.56466825278883},{"$f":"C18*'Key Data'!$B$35/1000","v":557.91631954607885},null,{"$f":"C18*'Key Data'!$B$38/1000","v":18.59721065153596},{"$f":"C18*'Key Data'!$B$41/1000","v":164.89526777695215},null,"PM (kg/year) ",{"$f":"C18*'Key Data'!$B$113/1000","v":235.56466825278883},{"$f":"C18*'Key Data'!$B$114/1000","v":557.91631954607885},null,"PM (kg/year)",{"$f":"D93*(1-'Key Data'!$B$112)","v":23.556466825278878},{"$f":"E93*(1-'Key Data'!$B$112)","v":55.791631954607873},null,"PM 2.5 (kg/year)",{"$f":"C93","v":18.59721065153596},0,null,"PM (kg/year) ",{"$f":"D93*(1-'Key Data'!$B$183)","v":117.78233412639442},{"$f":"E93*(1-'Key Data'!$B$183)","v":278.95815977303943},null,"PM (kg/year) ",{"$f":"($C$18*'Key Data'!$B$37/1000)*(1-('Key Data'!$B$198))","v":164.89526777695218},{"$f":"($C$18*'Key Data'!$B$35/1000)*(1-('Key Data'!$B$198))","v":390.54142368225519}]
[null,"Methane slip (tonne CO2 eq/year)",0,0,0,null,{"$f":"C18*'Key Data'!$B$27/1000*'Key Data'!$B$15/1000","v":138.85917286480185},{"$f":"C18*'Key Data'!$B$27/1000*'Key Data'!$B$15/1000","v":138.85917286480185}]
[null,"Climate costs (Euro/year)",{"$f":"(C94+C91)*'Key Data'!$B$58","v":168244.93224072561},{"$f":"(D94+D91)*'Key Data'!$B$58","v":176657.17885276189},{"$f":"(E94+E91)*'Key Data'!$B$58","v":174974.72953035461},null,{"$f":"(G94+G91)*'Key Data'!$B$58","v":181445.31770477619},{"$f":"(H94+H91)*'Key Data'!$B$58","v":181948.48619606497},null,"Climate costs (Euro/year) ",{"$f":"(K94+K91)*'Key Data'!$B$58","v":176657.17885276189},{"$f":"(L94+L91)*'Key Data'!$B$58","v":174974.72953035461},null,"Climate costs (Euro/year) CCNR 1 or Older",{"$f":"(O94+O91)*'Key Data'!$B$58","v":176657.17885276189},{"$f":"(P94+P91)*'Key Data'!$B$58","v":174974.72953035461},null,"Climate costs (Euro/year)",{"$f":"(S94+S91)*'Key Data'!$B$58","v":168244.93224072561},{"$f":"(T94+T91)*'Key Data'!$B$58","v":20771.210080201585},null,"Climate costs (Euro/year) CCNR2+0",{"$f":"(W94+W91)*'Key Data'!$B$58","v":167824.31991012377},{"$f":"(X94+X91)*'Key Data'!$B$58","v":166225.99305383689},null,"Climate costs (Euro/year)",{"$f":"(AA94+AA91)*'Key Data'!$B$58","v":176657.17885276189},{"$f":"(AB94+AB91)*'Key Data'!$B$58","v":174974.72953035461}]
[null,"Nox (Euro/ year) ",{"$f":"('Key Data'!$B$63*C92)","v":44470.55002897184},{"$f":"('Key Data'!$B$63*D92)","v":167199.33055585509},{"$f":"('Key Data'!$B$63*E92)","v":246699.75518865386},null,{"$f":"('Key Data'!$B$63*G92)","v":44470.55002897184},{"$f":"('Key Data'!$B$63*H92)","v":96975.61172239593},null,"Nox (Euro/ year)",{"$f":"('Key Data'!$B$63*K92)","v":50159.799166756529},{"$f":"('Key Data'!$B$63*L92)","v":74009.926556596169},null,"Nox (Euro/ year)",{"$f":"O92*'Key Data'!$B$63","v":50159.799166756529},{"$f":"('Key Data'!$B$63*P92)","v":74009.926556596169},null,"Nox (Euro/ year)",{"$f":"('Key Data'!$B$63*S92)","v":44470.55002897184},0,null,"Nox (Euro/ year) ",{"$f":"W92*'Key Data'!$B$63","v":142119.43097247681},{"$f":"X92*'Key Data'!$B$63","v":209694.79191035579},null,"Nox (Euro/ year)",{"$f":"AA92*'Key Data'!$B$63","v":150479.39750026958},{"$f":"AB92*'Key Data'!$B$63","v":222029.77966978846}]
[null,"PM (Euro/year) (Based on PM2.5 cost)",{"$f":"('Key Data'!$B$64*C93)","v":2289.9050193968383},{"$f":"('Key Data'!$B$64*D93)","v":29005.463579026618},{"$f":"('Key Data'!$B$64*E93)","v":68697.150581905153},null,{"$f":"('Key Data'!$B$64*G93)","v":2289.9050193968383},{"$f":"('Key Data'!$B$64*H93)","v":20303.824505318629},null,"PM (Euro/year) CCNR 2",{"$f":"('Key Data'!$B$64*K93)","v":29005.463579026618},{"$f":"('Key Data'!$B$64*L93)","v":68697.150581905153},null,"PM (Euro/year) ",{"$f":"('Key Data'!$B$64*O93)","v":2900.5463579026609},{"$f":"('Key Data'!$B$64*P93)","v":6869.7150581905134},null,"PM (Euro/year) (Based on PM 2.5 Cost)",{"$f":"('Key Data'!$B$64*S93)","v":2289.9050193968383},0,null,"PM (Euro/year)",{"$f":"('Key Data'!$B$64*W93)","v":14502.731789513309},{"$f":"('Key Data'!$B$64*X93)","v":34348.575290952576},null,"PM (Euro/year) CCR2",{"$f":"('Key Data'!$B$64*AA93)","v":20303.824505318633},{"$f":"('Key Data'!$B$64*AB93)","v":48088.005407333607}]
["per year","Port dues (Savings per annum) in euros",{"$f":"C46*'Key Data'!$B$65/100","v":1897},0,0,null,{"$f":"C46*'Key Data'!$B$65/100","v":1897},{"$f":"C46*'Key Data'!$B$65/100","v":1897},null,"Port dues (Savings per annum) (CCNR1 & CCNR2)",{"$f":"G98","v":1897},{"$f":"H98","v":1897},null,"Port dues (Savings per annum) ( SCR CCNR1 & CCNR2) + DPF (High and medium speed engines)",{"$f":"K98","v":1897},{"$f":"L98","v":1897},"per year","Port dues (Savings per annum) Assumed",{"$f":"O98","v":1897},{"$f":"P98","v":1897},"per year","Port dues (Savings per annum) ",{"$f":"T98","v":1897},{"$f":"W98","v":1897},"per year","Port dues (Savings per annum) ",{"$f":"W98","v":1897},{"$f":"X98","v":1897}]
["NPV \n(Tank above deck/ new)","Total Investment (Tank above deck) 2020",{"$f":"C73","v":609082.01428571425},{"$f":"D73","v":0},{"$f":"E73","v":0},null,{"$f":"G73","v":1923862},{"$f":"H73","v":996097},null,"Total Investment (Tank above deck) 2020",{"$f":"K73","v":87031.607142857145},{"$f":"K73","v":87031.607142857145},"NPV ","Total Investment (Tank above deck) 2020",{"$f":"O73","v":161784.60714285713},{"$f":"O73","v":161784.60714285713},"NPV ","Total Investment (Tank above deck) 2020",{"$f":"S73","v":1099547.54},{"$f":"T73","v":2732989.2390595516},"NPV ","Total Investment (Tank above deck) 2020",{"$f":"W73","v":148636.83314285713},{"$f":"W99","v":148636.83314285713},"NPV ","Total Investment (Tank above deck) 2020",{"$f":"D99","v":0},0]
[null,"Revision costs in 2020",{"$f":"C79","v":0},{"$f":"D79","v":171826.60714285713},{"$f":"E79","v":171826.60714285713},null,{"$f":"G79","v":0},{"$f":"H79","v":0},"NPV ","Revision costs in 2020",{"$f":"K79","v":171826.60714285713},{"$f":"K79","v":171826.60714285713},null,"Revision costs in 2020",{"$f":"O79","v":171826.60714285713},{"$f":"O79","v":171826.60714285713},null,"Revision costs in 2020",0,0,null,"Revision costs in 2020",{"$f":"W79","v":171826.60714285713},{"$f":"W100","v":171826.60714285713},null,"Revision costs in 2020",171826.60714285713,171826.60714285713]
[null,"Investments later in assessment period",{"$f":"+C75+C76+C77+C78","v":0},{"$f":"+D75+D76+D77+D78","v":100782.00000000003},{"$f":"+E75+E76+E77+E78","v":100782.00000000003},null,{"$f":"+G75+G76+G77+G78","v":0},{"$f":"H75+H76+H77+H78","v":100782.00000000003},null,"Investments later in assessment period ",{"$f":"K75+K76+K77+K78","v":100782.00000000003},{"$f":"K101","v":100782.00000000003},null,"Investments later in assessment period ",{"$f":"O75+O76+O77+O78","v":100782.00000000003},{"$f":"O101","v":100782.00000000003},null,"Investments later in assessment period",{"$f":"S75+S76+S77+S78","v":0},{"$f":"T75+T76+T77+T78","v":547438.60358713125},null,"Investments later in assessment period",{"$f":"SUM(W75:W78)","v":100782.00000000003},100782.00000000003,null,"Investments later in assessment period",100782.00000000003,100782.00000000003]
[null,"Revision costs during assesment period",{"$f":"C80+C74","v":0},{"$f":"D80+D74","v":0},{"$f":"E80+E74","v":0},null,{"$f":"G80+G74","v":0},0,null,"Revision costs during assesment period (incl SCR )",{"$f":"K80+K74","v":0},{"$f":"K80+K74","v":0},null,"Revision costs during assesment period (incl SCR+DPF )",{"$f":"O74+O80","v":0},{"$f":"O74+O80","v":0},null,"Revision costs during assesment period",{"$f":"S80+S74","v":0},{"$f":"T80+T74","v":0},null,"Revision costs during assesment period",{"$f":"W80+W74","v":0},0,null,"Revision costs during assesment period",0,0]
[null,"Fuel (+ Urea)",{"$f":"-PV('Key Data'!$B$66,C$31,C82+C84)","v":2027197.7046621577},{"$f":"-PV('Key Data'!$B$66,C31,D82)-PV('Key Data'!$B$66,(C31-'CBA figures'!C29/2),D84/'Key Data'!B76^('CBA figures'!C29/2))","v":2088289.8487655541},{"$f":"-PV('Key Data'!$B$66,C$31,E82)-PV('Key Data'!$B$66,(C31-'CBA figures'!C29/2),E84/'Key Data'!B76^('CBA figures'!C29/2))","v":2068401.3740154058},null,{"$f":"-PV('Key Data'!$B$66,C$31,G82+G84)","v":1488015.1335323923},{"$f":"-PV('Key Data'!$B$66,C$31,(H82))","v":1513113.3819056167},null,"Fuel (+ Urea)",{"$f":"-PV('Key Data'!$B$66,C$31,(K82+K84))","v":2128557.5898952656},{"$f":"-PV('Key Data'!$B$66,C$31,(L82+L84))","v":2143184.3218277274},null,"Fuel (+ Urea)",{"$f":"-PV('Key Data'!$B$66,C$31,(O82+O84))","v":2128557.5898952656},{"$f":"-PV('Key Data'!$B$66,C$31,(P82+P84))","v":2143184.3218277274},null,"Fuel (+ Urea)",{"$f":"-PV('Key Data'!$B$66,C$31,S82+S84)","v":2027197.7046621577},{"$f":"-PV('Key Data'!$B$66,C$31,T82+T84)","v":842400.34259097313},null,"Fuel (+ Urea)",{"$f":"-PV('Key Data'!$B$66,C31,W82)-PV('Key Data'!$B$66,(C31-'CBA figures'!C29/2),D84/'Key Data'!B76^('CBA figures'!C29/2))","v":1983875.3563272762},{"$f":"W103","v":1983875.3563272762},null,"Fuel (+ Urea)",{"$f":"-PV('Key Data'!$B$66,$C31,AA82)-PV('Key Data'!$B$66,(C31-C29/2),D84/'Key Data'!$B$76^(C29/2))","v":2298427.0166514008},{"$f":"-PV('Key Data'!$B$66,$C31,AA82)-PV('Key Data'!$B$66,($C31-C29/2),E84/'Key Data'!B76^(C29/2))","v":2298427.0166514008}]
[null,"Other operational costs",{"$f":"-PV('Key Data'!$B$66,C$31,(C85+C88+C89+C90))","v":528899.83280506299},{"$f":"-PV('Key Data'!$B$66,C$31,(D85+D88+D89+D90))","v":502965.71660134505},{"$f":"-PV('Key Data'!$B$66,C$31,(E85+E88+E89+E90))","v":500405.70789508836},null,{"$f":"-PV('Key Data'!$B$66,C$31,(G85+G88+G89+G90))","v":272898.9621793917},{"$f":"-PV('Key Data'!$B$66,C$31,(SUM(H85:H90)))","v":272898.9621793917},null,"Other operational costs",{"$f":"-PV('Key Data'!$B$66,C$31,(K89+K88+K85+K90))","v":509443.60140004486},{"$f":"-PV('Key Data'!$B$66,C$31,(K89+K88+K85+K90))","v":509443.60140004486},null,"Other operational costs",{"$f":"-PV('Key Data'!$B$66,C$31,(O89+O88+O85+O90))","v":541699.8763363465},{"$f":"-PV('Key Data'!$B$66,C$31,(P89+P88+P85+P90))","v":539139.86763008975},null,"Other operational costs",{"$f":"-PV('Key Data'!$B$66,C$31,S88+S89+S90+S85)","v":453454.5367110314},{"$f":"-PV('Key Data'!$B$66,C$31,T88+T89+T90+T85)","v":197453.66608536025},null,"Other operational costs",{"$f":"-PV('Key Data'!$B$66,C$31,SUM(W85:W90))","v":554752.16828249721},{"$f":"W104","v":554752.16828249721},null,"Other operational costs",{"$f":"D104","v":502965.71660134505},{"$f":"E104","v":500405.70789508836}]
[null,"Extra Cost Tank under deck",null,{"$f":"D67-D66","v":0},{"$f":"E67-E66","v":0},null,{"$f":"G67-G66","v":476500},{"$f":"H67-H66","v":476500},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Extra Cost Tank under deck",0,{"$f":"AA105","v":0}]
[null,"Total costs",{"$f":"SUM(C99:C105)","v":3165179.5517529352},{"$f":"SUM(D100:D105)","v":2863864.1725097564},{"$f":"SUM(E100:E105)","v":2841415.6890533515},null,{"$f":"SUM(G99:G105)","v":4161276.095711784},{"$f":"SUM(H99:H105)","v":3359391.3440850084},null,"Total costs",{"$f":"SUM(K99:K104)","v":2997641.4055810245},{"$f":"SUM(L99:L104)","v":3012268.1375134867},null,"Total costs",{"$f":"SUM(O99:O104)","v":3104650.6805173261},{"$f":"SUM(P99:P104)","v":3116717.4037435316},null,"Total costs",{"$f":"SUM(S99:S104)","v":3580199.7813731893},{"$f":"SUM(T99:T104)","v":4320281.851323016},null,"Total costs",{"$f":"SUM(W99:W104)","v":2959872.9648954878},{"$f":"W106","v":2959872.9648954878},null,"Total costs",{"$f":"SUM(AA99:AA105)","v":3074001.3403956033},{"$f":"SUM(AB99:AB105)","v":3071441.3316893466}]
[null,"Enviromental Costs: CO2",{"$f":"-PV('Key Data'!$B$62,C$31,(C95))","v":1870612.3401512606},{"$f":"-PV('Key Data'!$B$62,C$31,(D95))","v":1964142.9571588235},{"$f":"-PV('Key Data'!$B$62,C$31,(E95))","v":1945436.8337573109},null,{"$f":"-PV('Key Data'!$B$62,C$31,(G95))","v":2017379.3399945353},{"$f":"-PV('Key Data'!$B$62,C$31,(H95))","v":2022973.7622243436},null,"Enviromental Costs: CO2",{"$f":"-PV('Key Data'!$B$62,C$31,(K95))","v":1964142.9571588235},{"$f":"-PV('Key Data'!$B$62,C$31,(L95))","v":1945436.8337573109},null,"Enviromental Costs: CO2",{"$f":"-PV('Key Data'!$B$62,C$31,(O95))","v":1964142.9571588235},{"$f":"-PV('Key Data'!$B$62,C$31,(P95))","v":1945436.8337573109},null,"Enviromental Costs: CO2",{"$f":"-PV('Key Data'!$B$62,$C$31,(S95))","v":1870612.3401512606},{"$f":"-PV('Key Data'!$B$62,$C$31,(T95))","v":230942.36110663708},null,"Enviromental Costs: CO2",{"$f":"-PV('Key Data'!$B$62,C$31,(W95))","v":1865935.8093008823},{"$f":"-PV('Key Data'!$B$62,C$31,(W95))","v":1865935.8093008823},null,"Enviromental Costs: CO2",{"$f":"-PV('Key Data'!$B$62,C$31,(AA95))","v":1964142.9571588235},{"$f":"-PV('Key Data'!$B$62,C$31,(AA95))","v":1964142.9571588235}]
[null,"Enviromental Costs: Nox",{"$f":"-PV('Key Data'!$B$66,C$31,(C96))","v":494440.80454372457},{"$f":"-PV('Key Data'!$B$66,C$31,(D96))","v":1858986.9355191439},{"$f":"-PV('Key Data'!$B$66,C$31,(E96))","v":2742903.4576084837},null,{"$f":"-PV('Key Data'!$B$66,C$31,(G96))","v":494440.80454372457},{"$f":"-PV('Key Data'!$B$66,C$31,(H96))","v":1078212.4226011033},null,"Enviromental Costs: Nox",{"$f":"-PV('Key Data'!$B$66,C$31,(K96))","v":557696.08065574325},{"$f":"-PV('Key Data'!$B$66,C$31,(K96))","v":557696.08065574325},null,"Enviromental Costs: Nox",{"$f":"-PV('Key Data'!$B$66,C$31,(O96))","v":557696.08065574325},{"$f":"-PV('Key Data'!$B$66,C$31,(O96))","v":557696.08065574325},null,"Enviromental Costs: Nox",{"$f":"-PV('Key Data'!$B$66,$C$31,(S96))","v":494440.80454372457},{"$f":"-PV('Key Data'!$B$66,$C$31,(T96))","v":0},null,"Enviromental Costs: Nox",{"$f":"-PV('Key Data'!$B$66,C$31,(W96))","v":1580138.895191272},{"$f":"-PV('Key Data'!$B$66,C$31,(X96))","v":2331467.9389672112},null,"Enviromental Costs: Nox",{"$f":"-PV('Key Data'!$B$66,C$31,(AA96))","v":1673088.2419672296},{"$f":"-PV('Key Data'!$B$66,C$31,(AB96))","v":2468613.1118476349}]
[null,"Enviromental Costs: PM",{"$f":"-PV('Key Data'!$B$66,C$31,(C97))","v":25460.051188520523},{"$f":"-PV('Key Data'!$B$66,C$31,(D97))","v":322493.98172126},{"$f":"-PV('Key Data'!$B$66,C$31,(E97))","v":763801.53565561573},null,{"$f":"-PV('Key Data'!$B$66,C$31,(G97))","v":25460.051188520523},{"$f":"-PV('Key Data'!$B$66,C$31,(H97))","v":225745.78720488193},null,"Enviromental Costs: PM",{"$f":"-PV('Key Data'!$B$66,C$31,(K97))","v":322493.98172126},{"$f":"-PV('Key Data'!$B$66,C$31,(L97))","v":763801.53565561573},null,"Enviromental Costs: PM",{"$f":"-PV('Key Data'!$B$66,C$31,(O97))","v":32249.398172125988},{"$f":"-PV('Key Data'!$B$66,C$31,(O97))","v":32249.398172125988},null,"Enviromental Costs: PM",{"$f":"-PV('Key Data'!$B$66,C$31,(S97))","v":25460.051188520523},{"$f":"-PV('Key Data'!$B$66,C$31,(T97))","v":0},null,"Enviromental Costs: PM",{"$f":"-PV('Key Data'!$B$66,C$31,(W97))","v":161246.99086063},{"$f":"-PV('Key Data'!$B$66,C$31,(X97))","v":381900.76782780787},null,"Enviromental Costs: PM",{"$f":"-PV('Key Data'!$B$66,C$31,(AA97))","v":225745.78720488198},{"$f":"-PV('Key Data'!$B$66,C$31,(AB97))","v":534661.07495893107}]
[null,"Total Cost (Incl. environmental costs)",{"$f":"SUM(C106:C109)","v":5555692.7476364402},{"$f":"SUM(D106:D109)","v":7009488.046908984},{"$f":"SUM(E106:E109)","v":8293557.5160747617},null,{"$f":"SUM(G106:G109)","v":6698556.2914385637},{"$f":"SUM(H106:H109)","v":6686323.3161153384},"Total","Total",{"$f":"SUM(K106:K109)","v":5841974.425116851},{"$f":"SUM(L106:L109)","v":6279202.587582157},null,"Total Cost (Incl. environmental costs)",{"$f":"SUM(O106:O109)","v":5658739.1165040191},{"$f":"SUM(P106:P109)","v":5652099.7163287122},null,"Total Cost (Incl. environmental costs)",{"$f":"SUM(S106:S109)","v":5970712.9772566939},{"$f":"SUM(T106:T109)","v":4551224.2124296529},null,"Total Cost (Incl. environmental costs)",{"$f":"SUM(W106:W109)","v":6567194.6602482712},{"$f":"SUM(X106:X109)","v":7539177.4809913887},null,"Total Cost (Incl. environmental costs)",{"$f":"SUM(AA106:AA109)","v":6936978.3267265391},{"$f":"SUM(AB106:AB109)","v":8038858.4756547352}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cost advantage in 2030 when battery electric is needed",{"$f":"-('CBA figures'!S63+'CBA figures'!S64+'CBA figures'!S68/2)/'Key Data'!B76^'CBA figures'!C31","v":-367140.47274564032},{"$f":"-('CBA figures'!T63+'CBA figures'!T64+'CBA figures'!T68/2)/'Key Data'!B76^'CBA figures'!C31","v":-367140.47274564032}]
[null,"Residual value when only scrap value",{"$f":"-C70/'Key Data'!$B$76^'CBA figures'!$D$42","v":-30049.182461593966},{"$f":"-D70/'Key Data'!$B$76^'CBA figures'!$D$42","v":-18653.555704149752},{"$f":"-E70/'Key Data'!$B$76^'CBA figures'!$D$42","v":-18653.555704149752},null,{"$f":"-G70/'Key Data'!$B$76^'CBA figures'!$D$42","v":-63509.210394584872},{"$f":"-H70/'Key Data'!$B$76^'CBA figures'!$D$42","v":-11993.713258606736},null,null,{"$f":"-K70/'Key Data'!$B$76^'CBA figures'!$D$42","v":0},{"$f":"-L70/'Key Data'!$B$76^'CBA figures'!$D$42","v":0},null,null,{"$f":"-O70/'Key Data'!$B$76^'CBA figures'!$D$42","v":0},{"$f":"-P70/'Key Data'!$B$76^'CBA figures'!$D$42","v":0},null,null,{"$f":"-S69/'Key Data'!$B$76^'CBA figures'!$D$42","v":-24039.345969275179},null,null,null,{"$f":"-W70/'Key Data'!$B$76^'CBA figures'!$D$42","v":-2141.437047339035},{"$f":"-X70/'Key Data'!$B$76^'CBA figures'!$D$42","v":-2141.437047339035},null,null,{"$f":"D112","v":-18653.555704149752},{"$f":"E112","v":-18653.555704149752}]
[null,"Investments later in assessment period when only scrap value",{"$f":"C101-C78+C112","v":-30049.182461593966},{"$f":"D101-D78+D112","v":82128.444295850277},{"$f":"E101-E78+E112","v":82128.444295850277},null,{"$f":"G101-G78+G112","v":-63509.210394584872},{"$f":"H101-H78+H112","v":88788.286741393298},null,null,{"$f":"D113","v":82128.444295850277},{"$f":"E113","v":82128.444295850277},null,null,{"$f":"D113","v":82128.444295850277},{"$f":"E113","v":82128.444295850277},null,null,{"$f":"S101-S78+S112","v":-24039.345969275179},null,null,null,{"$f":"W101-W78+W112","v":98640.562952660999},{"$f":"W113","v":98640.562952660999},null,null,{"$f":"D113","v":82128.444295850277},{"$f":"E113","v":82128.444295850277}]
[]
[null,"€ per ton environmental costs",{"$f":"SUM(C107:C109)/C106","v":0.75525358255255859},{"$f":"SUM(D107:D109)/D106","v":1.4475630213866593},{"$f":"SUM(E107:E109)/E106","v":1.9188117557124671},null,{"$f":"SUM(G107:G109)/G106","v":0.60973608512577682},{"$f":"SUM(H107:H109)/H106","v":0.9903377223044193},null,null,{"$f":"SUM(K107:K109)/K106","v":0.94885699611709151},{"$f":"SUM(L107:L109)/L106","v":1.0845430422954978},null,null,{"$f":"SUM(O107:O109)/O106","v":0.82266531691130762},{"$f":"SUM(P107:P109)/P106","v":0.81347840825732165},null,null,{"$f":"SUM(S107:S109)/S106","v":0.66770385505320107},{"$f":"SUM(T107:T109)/T106","v":5.3455392276296684E-2},null,null,{"$f":"SUM(W107:W109)/W106","v":1.2187420670198115},{"$f":"SUM(X107:X109)/X106","v":1.5471287350528558},null,null,{"$f":"SUM(AA107:AA109)/AA106","v":1.256660800881042},{"$f":"SUM(AB107:AB109)/AB106","v":1.617291885967173}]
[null,"€ per ton Co2",{"$f":"C$106/($D$91-C91)","v":63036.428979182303},0,0,null,{"$f":"G$106/($D$91-G91)","v":37733.999646798628},{"$f":"H$106/($D$91-H91)","v":31315.446716542989},null,null,0,0,null,null,0,0,null,null,{"$f":"S$106/($D$91-S91)","v":71301.803123562961},{"$f":"T$106/($D$91-T91)","v":4643.1242049078173},null,null,{"$f":"W$106/($D$91-W91)","v":56140.596641652344},0,null,null,0,0]
[null,"€ per kg NOx",{"$f":"C$106/($D$92-C92)","v":516.79089215867282},0,0,null,{"$f":"G$106/($D$92-G92)","v":679.42735976240579},{"$f":"H$106/($D$92-H92)","v":958.6050066629291},null,null,{"$f":"K$106/($D$92-K92)","v":513.22762344368709},0,null,null,{"$f":"O$106/($D$92-O92)","v":531.54873275307273},0,null,null,{"$f":"S$106/($D$92-S92)","v":584.55282200261047},{"$f":"T$106/($D$92-T92)","v":517.77427017230013},null,null,{"$f":"W$106/($D$92-W92)","v":2364.8859294248218},0,null,null,{"$f":"AA$106/($D$92-AA92)","v":3684.10871166795},0]

{"sheet":"Results","index":5,"n_rows":200,"n_cols":42,"rows_kept":200,"cut":false,"hidden":true,"merged":[]}
[]
[]
[null,"Cost factors","CCNR2 revision","CCNRO revision","Stage V","LNG mono fuel","LNG Dual fuel refit","SCR CCNR2","SCR CCNR0","SCR+ DPF CCNR2","SCR+DPF CCNR0","Diesel electric","Battery electric","FWE CCNR2","FWE CCNR0","GTL CCNR2","GTL CCNR0",null,null,"CCR 2",{"$f":"C3","v":"CCNR2 revision"},{"$f":"E3","v":"Stage V"},{"$f":"F3","v":"LNG mono fuel"},{"$f":"G3","v":"LNG Dual fuel refit"},{"$f":"H3","v":"SCR CCNR2"},{"$f":"J3","v":"SCR+ DPF CCNR2"},{"$f":"L3","v":"Diesel electric"},{"$f":"M3","v":"Battery electric"},{"$f":"N3","v":"FWE CCNR2"},{"$f":"P3","v":"GTL CCNR2"},null,"CCR 0",{"$f":"D3","v":"CCNRO revision"},{"$f":"E3","v":"Stage V"},{"$f":"F3","v":"LNG mono fuel"},{"$f":"G3","v":"LNG Dual fuel refit"},{"$f":"I3","v":"SCR CCNR0"},{"$f":"K3","v":"SCR+DPF CCNR0"},{"$f":"L3","v":"Diesel electric"},{"$f":"M3","v":"Battery electric"},{"$f":"O3","v":"FWE CCNR0"},{"$f":"Q3","v":"GTL CCNR0"}]
[{"$f":"'Ship segment (Data)'!$Z$5&\"&\"&'Ship segment (Data)'!$AA$5","v":"Motor vessels dry cargo 110 m ship&normal fuel use"},"Investments in start year",{"$f":"'CBA figures'!D99","v":0},{"$f":"'CBA figures'!E99","v":0},{"$f":"'CBA figures'!C99","v":609082.01428571425},{"$f":"'CBA figures'!G99","v":1923862},{"$f":"'CBA figures'!H99","v":996097},{"$f":"'CBA figures'!K99","v":87031.607142857145},{"$f":"'CBA figures'!L99","v":87031.607142857145},{"$f":"'CBA figures'!O99","v":161784.60714285713},{"$f":"'CBA figures'!P99","v":161784.60714285713},{"$f":"'CBA figures'!S99","v":1099547.54},{"$f":"IF('Ship segment (Data)'!$AC$5=\"nee\",'CBA figures'!T99*10^3,'CBA figures'!T99)","v":2732989.2390595516},{"$f":"'CBA figures'!W99","v":148636.83314285713},{"$f":"'CBA figures'!X99","v":148636.83314285713},{"$f":"'CBA figures'!AA99","v":0},{"$f":"'CBA figures'!AB99","v":0},null,null,{"$f":"B4","v":"Investments in start year"},0,609082.01428571425,1923862,996097,87031.607142857145,161784.60714285713,1099547.54,2732989.2390595516,148636.83314285713,0,null,{"$f":"B4","v":"Investments in start year"},0,609082.01428571425,1923862,996097,87031.607142857145,161784.60714285713,1099547.54,2732989.2390595516,148636.83314285713,0]
[{"$f":"'Ship segment (Data)'!$Z$5&\"&\"&'Ship segment (Data)'!$AA$5","v":"Motor vessels dry cargo 110 m ship&normal fuel use"},"Revision costs in start year",{"$f":"'CBA figures'!D100","v":171826.60714285713},{"$f":"'CBA figures'!E100","v":171826.60714285713},{"$f":"'CBA figures'!C100","v":0},{"$f":"'CBA figures'!G100","v":0},{"$f":"'CBA figures'!H100","v":0},{"$f":"'CBA figures'!K100","v":171826.60714285713},{"$f":"'CBA figures'!L100","v":171826.60714285713},{"$f":"'CBA figures'!O100","v":171826.60714285713},{"$f":"'CBA figures'!P100","v":171826.60714285713},{"$f":"'CBA figures'!S100","v":0},{"$f":"'CBA figures'!T100","v":0},{"$f":"'CBA figures'!W100","v":171826.60714285713},{"$f":"'CBA figures'!X100","v":171826.60714285713},{"$f":"'CBA figures'!AA100","v":171826.60714285713},{"$f":"'CBA figures'!AB100","v":171826.60714285713},null,null,"Revision costs in start year",171826.60714285713,0,0,0,171826.60714285713,171826.60714285713,0,0,171826.60714285713,171826.60714285713,null,"Revision costs in start year",171826.60714285713,0,0,0,171826.60714285713,171826.60714285713,0,0,171826.60714285713,171826.60714285713]
[{"$f":"'Ship segment (Data)'!$Z$5&\"&\"&'Ship segment (Data)'!$AA$5","v":"Motor vessels dry cargo 110 m ship&normal fuel use"},"Investments in assessment period",{"$f":"IF($S$44=\"YES\",'CBA figures'!D101,'CBA figures'!D113)","v":100782.00000000003},{"$f":"IF($S$44=\"YES\",'CBA figures'!E101,'CBA figures'!E113)","v":100782.00000000003},{"$f":"IF($S$44=\"YES\",'CBA figures'!C101,'CBA figures'!C113)","v":0},{"$f":"IF($S$44=\"YES\",'CBA figures'!G101,'CBA figures'!G113)","v":0},{"$f":"IF($S$44=\"YES\",'CBA figures'!H101,'CBA figures'!H113)","v":100782.00000000003},{"$f":"IF($S$44=\"YES\",'CBA figures'!K101,'CBA figures'!K113)","v":100782.00000000003},{"$f":"IF($S$44=\"YES\",'CBA figures'!L101,'CBA figures'!L113)","v":100782.00000000003},{"$f":"IF($S$44=\"YES\",'CBA figures'!O101,'CBA figures'!O113)","v":100782.00000000003},{"$f":"IF($S$44=\"YES\",'CBA figures'!P101,'CBA figures'!P113)","v":100782.00000000003},{"$f":"IF($S$44=\"YES\",'CBA figures'!S101,'CBA figures'!S113)","v":0},null,{"$f":"IF($S$44=\"YES\",'CBA figures'!W101,'CBA figures'!W113)","v":100782.00000000003},{"$f":"IF($S$44=\"YES\",'CBA figures'!X101,'CBA figures'!X113)","v":100782.00000000003},{"$f":"IF($S$44=\"YES\",'CBA figures'!AA101,'CBA figures'!AA113)","v":100782.00000000003},{"$f":"IF($S$44=\"YES\",'CBA figures'!AB101,'CBA figures'!AB113)","v":100782.00000000003},null,null,{"$f":"B6","v":"Investments in assessment period"},100782.00000000003,{"$f":"E6","v":0},0,100782.00000000003,100782.00000000003,{"$f":"J6","v":100782.00000000003},{"$f":"L6","v":0},0,100782.00000000003,100782.00000000003,null,"Investments in assessment period",100782.00000000003,0,0,100782.00000000003,100782.00000000003,100782.00000000003,0,0,100782.00000000003,100782.00000000003]
[{"$f":"'Ship segment (Data)'!$Z$5&\"&\"&'Ship segment (Data)'!$AA$5","v":"Motor vessels dry cargo 110 m ship&normal fuel use"},"Revision costs in assesment period (incl SCR/ DPF)",{"$f":"'CBA figures'!D102","v":0},{"$f":"'CBA figures'!E102","v":0},{"$f":"'CBA figures'!C102","v":0},{"$f":"'CBA figures'!G102","v":0},{"$f":"'CBA figures'!H102","v":0},{"$f":"'CBA figures'!K102","v":0},{"$f":"'CBA figures'!L102","v":0},{"$f":"'CBA figures'!O102","v":0},{"$f":"'CBA figures'!P102","v":0},{"$f":"'CBA figures'!S102","v":0},{"$f":"'CBA figures'!T102","v":0},{"$f":"'CBA figures'!W102","v":0},{"$f":"'CBA figures'!X102","v":0},{"$f":"'CBA figures'!AA102","v":0},{"$f":"'CBA figures'!AB102","v":0},null,null,"Revision costs in assesment period (incl SCR/ DPF)",0,0,0,0,0,0,0,0,0,0,null,"Revision costs in assesment period (incl SCR/ DPF)",0,0,0,0,0,0,0,0,0,0]
[{"$f":"'Ship segment (Data)'!$Z$5&\"&\"&'Ship segment (Data)'!$AA$5","v":"Motor vessels dry cargo 110 m ship&normal fuel use"},"Fuel (+ Urea)",{"$f":"'CBA figures'!D103","v":2088289.8487655541},{"$f":"'CBA figures'!E103","v":2068401.3740154058},{"$f":"'CBA figures'!C103","v":2027197.7046621577},{"$f":"'CBA figures'!G103","v":1488015.1335323923},{"$f":"'CBA figures'!H103","v":1513113.3819056167},{"$f":"'CBA figures'!K103","v":2128557.5898952656},{"$f":"'CBA figures'!L103","v":2143184.3218277274},{"$f":"'CBA figures'!O103","v":2128557.5898952656},{"$f":"'CBA figures'!P103","v":2143184.3218277274},{"$f":"'CBA figures'!S103","v":2027197.7046621577},{"$f":"'CBA figures'!T103","v":842400.34259097313},{"$f":"'CBA figures'!W103","v":1983875.3563272762},{"$f":"'CBA figures'!X103","v":1983875.3563272762},{"$f":"'CBA figures'!AA103","v":2298427.0166514008},{"$f":"'CBA figures'!AB103","v":2298427.0166514008},null,null,"Fuel (+ Urea)",2088289.8487655541,2027197.7046621577,1488015.1335323923,1513113.3819056167,2128557.5898952656,2128557.5898952656,2027197.7046621577,842400.34259097313,1983875.3563272762,2298427.0166514008,null,"Fuel (+ Urea)",2068401.3740154058,2027197.7046621577,1488015.1335323923,1513113.3819056167,2143184.3218277274,2143184.3218277274,2027197.7046621577,842400.34259097313,1983875.3563272762,2298427.0166514008]
[{"$f":"'Ship segment (Data)'!$Z$5&\"&\"&'Ship segment (Data)'!$AA$5","v":"Motor vessels dry cargo 110 m ship&normal fuel use"},"Other operational costs",{"$f":"'CBA figures'!D104","v":502965.71660134505},{"$f":"'CBA figures'!E104","v":500405.70789508836},{"$f":"'CBA figures'!C104","v":528899.83280506299},{"$f":"'CBA figures'!G104","v":272898.9621793917},{"$f":"'CBA figures'!H104","v":272898.9621793917},{"$f":"'CBA figures'!K104","v":509443.60140004486},{"$f":"'CBA figures'!L104","v":509443.60140004486},{"$f":"'CBA figures'!O104","v":541699.8763363465},{"$f":"'CBA figures'!P104","v":539139.86763008975},{"$f":"'CBA figures'!S104","v":453454.5367110314},{"$f":"'CBA figures'!T104","v":197453.66608536025},{"$f":"'CBA figures'!W104","v":554752.16828249721},{"$f":"'CBA figures'!X104","v":554752.16828249721},{"$f":"'CBA figures'!AA104","v":502965.71660134505},{"$f":"'CBA figures'!AB104","v":500405.70789508836},null,null,"Other operational costs",502965.71660134505,528899.83280506299,272898.9621793917,272898.9621793917,509443.60140004486,541699.8763363465,453454.5367110314,197453.66608536025,554752.16828249721,502965.71660134505,null,"Other operational costs",500405.70789508836,528899.83280506299,272898.9621793917,272898.9621793917,509443.60140004486,539139.86763008975,453454.5367110314,197453.66608536025,554752.16828249721,500405.70789508836]
[{"$f":"'Ship segment (Data)'!$Z$5&\"&\"&'Ship segment (Data)'!$AA$5","v":"Motor vessels dry cargo 110 m ship&normal fuel use"},"Extra Cost Tank under deck",{"$f":"'CBA figures'!D105","v":0},{"$f":"'CBA figures'!E105","v":0},{"$f":"'CBA figures'!C105","v":0},{"$f":"'CBA figures'!G105","v":476500},{"$f":"'CBA figures'!H105","v":476500},null,null,null,null,null,{"$f":"'CBA figures'!T105","v":0},{"$f":"'CBA figures'!W105","v":0},{"$f":"'CBA figures'!X105","v":0},{"$f":"'CBA figures'!AA105","v":0},{"$f":"'CBA figures'!AB105","v":0},null,null,"Extra Cost Tank under deck",0,0,476500,476500,0,0,0,0,0,0,null,"Extra Cost Tank under deck",0,0,476500,476500,0,0,0,0,0,0]
[{"$f":"'Ship segment (Data)'!$Z$5&\"&\"&'Ship segment (Data)'!$AA$5","v":"Motor vessels dry cargo 110 m ship&normal fuel use"},"Environmental Costs: CO2",{"$f":"'CBA figures'!D107","v":1964142.9571588235},{"$f":"'CBA figures'!E107","v":1945436.8337573109},{"$f":"'CBA figures'!C107","v":1870612.3401512606},{"$f":"'CBA figures'!G107","v":2017379.3399945353},{"$f":"'CBA figures'!H107","v":2022973.7622243436},{"$f":"'CBA figures'!K107","v":1964142.9571588235},{"$f":"'CBA figures'!L107","v":1945436.8337573109},{"$f":"'CBA figures'!O107","v":1964142.9571588235},{"$f":"'CBA figures'!P107","v":1945436.8337573109},{"$f":"'CBA figures'!S107","v":1870612.3401512606},{"$f":"'CBA figures'!T107","v":230942.36110663708},{"$f":"'CBA figures'!W107","v":1865935.8093008823},{"$f":"'CBA figures'!X107","v":1865935.8093008823},{"$f":"'CBA figures'!AA107","v":1964142.9571588235},{"$f":"'CBA figures'!AB107","v":1964142.9571588235},null,null,"Environmental Costs: CO2",1964142.9571588235,1870612.3401512606,2017379.3399945353,2022973.7622243436,1964142.9571588235,1964142.9571588235,1870612.3401512606,230942.36110663708,1865935.8093008823,1964142.9571588235,null,"Environmental Costs: CO2",1945436.8337573109,1870612.3401512606,2017379.3399945353,2022973.7622243436,1945436.8337573109,1945436.8337573109,1870612.3401512606,230942.36110663708,1865935.8093008823,1964142.9571588235]
[{"$f":"'Ship segment (Data)'!$Z$5&\"&\"&'Ship segment (Data)'!$AA$5","v":"Motor vessels dry cargo 110 m ship&normal fuel use"},"Environmental Costs: NOx",{"$f":"'CBA figures'!D108","v":1858986.9355191439},{"$f":"'CBA figures'!E108","v":2742903.4576084837},{"$f":"'CBA figures'!C108","v":494440.80454372457},{"$f":"'CBA figures'!G108","v":494440.80454372457},{"$f":"'CBA figures'!H108","v":1078212.4226011033},{"$f":"'CBA figures'!K108","v":557696.08065574325},{"$f":"'CBA figures'!L108","v":557696.08065574325},{"$f":"'CBA figures'!O108","v":557696.08065574325},{"$f":"'CBA figures'!P108","v":557696.08065574325},{"$f":"'CBA figures'!S108","v":494440.80454372457},{"$f":"'CBA figures'!T108","v":0},{"$f":"'CBA figures'!W108","v":1580138.895191272},{"$f":"'CBA figures'!X108","v":2331467.9389672112},{"$f":"'CBA figures'!AA108","v":1673088.2419672296},{"$f":"'CBA figures'!AB108","v":2468613.1118476349},null,null,"Environmental Costs: NOx",1858986.9355191439,494440.80454372457,494440.80454372457,1078212.4226011033,557696.08065574325,557696.08065574325,494440.80454372457,0,1580138.895191272,1673088.2419672296,null,"Environmental Costs: NOx",2742903.4576084837,494440.80454372457,494440.80454372457,1078212.4226011033,557696.08065574325,557696.08065574325,494440.80454372457,0,2331467.9389672112,2468613.1118476349]
[{"$f":"'Ship segment (Data)'!$Z$5&\"&\"&'Ship segment (Data)'!$AA$5","v":"Motor vessels dry cargo 110 m ship&normal fuel use"},"Environmental Costs: PM",{"$f":"'CBA figures'!D109","v":322493.98172126},{"$f":"'CBA figures'!E109","v":763801.53565561573},{"$f":"'CBA figures'!C109","v":25460.051188520523},{"$f":"'CBA figures'!G109","v":25460.051188520523},{"$f":"'CBA figures'!H109","v":225745.78720488193},{"$f":"'CBA figures'!K109","v":322493.98172126},{"$f":"'CBA figures'!L109","v":763801.53565561573},{"$f":"'CBA figures'!O109","v":32249.398172125988},{"$f":"'CBA figures'!P109","v":32249.398172125988},{"$f":"'CBA figures'!S109","v":25460.051188520523},{"$f":"'CBA figures'!T109","v":0},{"$f":"'CBA figures'!W109","v":161246.99086063},{"$f":"'CBA figures'!X109","v":381900.76782780787},{"$f":"'CBA figures'!AA109","v":225745.78720488198},{"$f":"'CBA figures'!AB109","v":534661.07495893107},null,null,"Environmental Costs: PM",322493.98172126,25460.051188520523,25460.051188520523,225745.78720488193,322493.98172126,32249.398172125988,25460.051188520523,0,161246.99086063,225745.78720488198,null,"Environmental Costs: PM",763801.53565561573,25460.051188520523,25460.051188520523,225745.78720488193,763801.53565561573,32249.398172125988,25460.051188520523,0,381900.76782780787,534661.07495893107]
[{"$f":"'Ship segment (Data)'!$Z$5&\"&\"&'Ship segment (Data)'!$AA$5","v":"Motor vessels dry cargo 110 m ship&normal fuel use"},"Total investment start year",{"$f":"SUM(C4:C5)","v":171826.60714285713},{"$f":"SUM(D4:D5)","v":171826.60714285713},609082.01428571425,1923862,996097,258858.21428571426,258858.21428571426,333611.21428571426,333611.21428571426,1099547.54,2732989.2390595516,320463.44028571423,320463.44028571423,171826.60714285713,171826.60714285713,null,null,{"$f":"B16","v":"Total SC"},{"$f":"C16","v":7009488.046908984},{"$f":"E16","v":5555692.7476364402},{"$f":"F16","v":6698556.2914385637},{"$f":"G16","v":6686323.3161153384},{"$f":"H16","v":5841974.425116851},{"$f":"J16","v":5658739.1165040191},{"$f":"L16","v":5970712.9772566939},{"$f":"M16","v":4003785.6088425219},{"$f":"N16","v":6567194.6602482712},{"$f":"P16","v":6936978.3267265391},null,{"$f":"B16","v":"Total SC"},{"$f":"D16","v":8293557.5160747617},{"$f":"E16","v":5555692.7476364402},{"$f":"F16","v":6698556.2914385637},{"$f":"G16","v":6686323.3161153384},{"$f":"I16","v":6279202.587582157},{"$f":"K16","v":5652099.7163287122},{"$f":"L16","v":5970712.9772566939},{"$f":"M16","v":4003785.6088425219},{"$f":"O16","v":7539177.4809913887},{"$f":"Q16","v":8038858.4756547352}]
[{"$f":"'Ship segment (Data)'!$Z$5&\"&\"&'Ship segment (Data)'!$AA$5","v":"Motor vessels dry cargo 110 m ship&normal fuel use"},"TCO costs",{"$f":"SUM(C4:C10)","v":2863864.1725097564},{"$f":"SUM(D4:D10)","v":2841415.6890533515},3165179.5517529352,4161276.095711784,3359391.3440850084,2997641.4055810245,3012268.1375134867,3104650.6805173261,3116717.4037435316,3580199.7813731893,3772843.247735885,2959872.9648954878,2959872.9648954878,3074001.3403956033,3071441.3316893466]
[{"$f":"'Ship segment (Data)'!$Z$5&\"&\"&'Ship segment (Data)'!$AA$5","v":"Motor vessels dry cargo 110 m ship&normal fuel use"},"Total SC",{"$f":"SUM(C4:C13)","v":7009488.046908984},{"$f":"SUM(D4:D13)","v":8293557.5160747617},5555692.7476364402,6698556.2914385637,6686323.3161153384,5841974.425116851,6279202.587582157,5658739.1165040191,5652099.7163287122,5970712.9772566939,4003785.6088425219,6567194.6602482712,7539177.4809913887,6936978.3267265391,8038858.4756547352]
[]
[null,"Cost factors",{"$f":"C3","v":"CCNR2 revision"},"CCNRO revision","Stage V","LNG mono fuel","LNG Dual fuel refit","SCR CCNR2","SCR CCNR0","SCR+ DPF CCNR2","SCR+DPF CCNR0","Diesel electric","Battery electric","FWE CCNR2","FWE CCNR0","GTL CCNR2","GTL CCNR0",null,null,{"$f":"B4","v":"Investments in start year"},{"$f":"U4+U6","v":100782.00000000003},609082.01428571425,1923862,1096879,187813.60714285716,262566.60714285716,1099547.54,2732989.2390595516,249418.83314285715,100782.00000000003,0,{"$f":"B4","v":"Investments in start year"},{"$f":"AG4+AG6","v":100782.00000000003},609082.01428571425,1923862,1096879,187813.60714285716,262566.60714285716,1099547.54,{"$f":"AN4+AN6","v":2732989.2390595516},249418.83314285715,100782.00000000003]
[null,"Investments",{"$f":"C4+C6+C10","v":100782.00000000003},{"$f":"D4+D6","v":100782.00000000003},609082.01428571425,1923862,1096879,187813.60714285716,187813.60714285716,262566.60714285716,262566.60714285716,1099547.54,2732989.2390595516,249418.83314285715,249418.83314285715,100782.00000000003,100782.00000000003,null,null,"Revision costs in start year",{"$f":"U5","v":171826.60714285713},0,0,0,171826.60714285713,171826.60714285713,0,0,171826.60714285713,171826.60714285713,0,"Revision costs in start year",{"$f":"AG5","v":171826.60714285713},0,0,0,171826.60714285713,171826.60714285713,0,{"$f":"AN5","v":0},171826.60714285713,171826.60714285713]
[null,"Revision costs in start year",{"$f":"C5","v":171826.60714285713},171826.60714285713,0,0,0,171826.60714285713,171826.60714285713,171826.60714285713,171826.60714285713,0,0,171826.60714285713,171826.60714285713,171826.60714285713,171826.60714285713,null,null,{"$f":"B6","v":"Investments in assessment period"},null,null,null,null,null,null,null,null,null,null,null,"Investments in assessment period"]
[null,"Investments in assessment period",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,{"$f":"B7","v":"Revision costs in assesment period (incl SCR/ DPF)"},{"$f":"U7","v":0},0,0,0,0,0,0,0,0,0,0,"Revision costs in assesment period (incl SCR/ DPF)",{"$f":"AG7","v":0},0,0,0,0,0,0,{"$f":"AN7","v":0},0,0]
[null,"Revision costs in assesment period (incl SCR/DPF)",{"$f":"C7","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,{"$f":"B8","v":"Fuel (+ Urea)"},{"$f":"U8","v":2088289.8487655541},2027197.7046621577,1488015.1335323923,1513113.3819056167,2128557.5898952656,2128557.5898952656,2027197.7046621577,842400.34259097313,1983875.3563272762,2298427.0166514008,0,"Fuel (+ Urea)",{"$f":"AG8","v":2068401.3740154058},2027197.7046621577,1488015.1335323923,1513113.3819056167,2143184.3218277274,2143184.3218277274,2027197.7046621577,{"$f":"AN8","v":842400.34259097313},1983875.3563272762,2298427.0166514008]
[null,"Fuel (+ Urea)",{"$f":"C8","v":2088289.8487655541},2068401.3740154058,2027197.7046621577,1488015.1335323923,1513113.3819056167,2128557.5898952656,2143184.3218277274,2128557.5898952656,2143184.3218277274,2027197.7046621577,842400.34259097313,1983875.3563272762,1983875.3563272762,2298427.0166514008,2298427.0166514008,null,null,{"$f":"B9","v":"Other operational costs"},{"$f":"U9","v":502965.71660134505},528899.83280506299,272898.9621793917,272898.9621793917,509443.60140004486,541699.8763363465,453454.5367110314,197453.66608536025,554752.16828249721,502965.71660134505,0,"Other operational costs",{"$f":"AG9","v":500405.70789508836},528899.83280506299,272898.9621793917,272898.9621793917,509443.60140004486,539139.86763008975,453454.5367110314,{"$f":"AN9","v":197453.66608536025},554752.16828249721,500405.70789508836]
[null,"Other operational costs",{"$f":"C9","v":502965.71660134505},500405.70789508836,528899.83280506299,272898.9621793917,272898.9621793917,509443.60140004486,509443.60140004486,541699.8763363465,539139.86763008975,453454.5367110314,197453.66608536025,554752.16828249721,554752.16828249721,502965.71660134505,500405.70789508836,null,null,{"$f":"B11","v":"Environmental Costs: CO2"},{"$f":"U11","v":1964142.9571588235},1870612.3401512606,2017379.3399945353,2022973.7622243436,1964142.9571588235,1964142.9571588235,1870612.3401512606,230942.36110663708,1865935.8093008823,1964142.9571588235,{"$f":"AE12","v":0},{"$f":"B11","v":"Environmental Costs: CO2"},{"$f":"AG11","v":1945436.8337573109},1870612.3401512606,2017379.3399945353,2022973.7622243436,1945436.8337573109,1945436.8337573109,1870612.3401512606,{"$f":"AN11","v":230942.36110663708},1865935.8093008823,1964142.9571588235]
[null,"Environmental Costs: CO2",{"$f":"C11","v":1964142.9571588235},1945436.8337573109,1870612.3401512606,2017379.3399945353,2022973.7622243436,1964142.9571588235,1945436.8337573109,1964142.9571588235,1945436.8337573109,1870612.3401512606,230942.36110663708,1865935.8093008823,1865935.8093008823,1964142.9571588235,1964142.9571588235,null,null,{"$f":"B12","v":"Environmental Costs: NOx"},{"$f":"U12","v":1858986.9355191439},494440.80454372457,494440.80454372457,1078212.4226011033,557696.08065574325,557696.08065574325,494440.80454372457,0,1580138.895191272,1673088.2419672296,{"$f":"AE13","v":0},{"$f":"B12","v":"Environmental Costs: NOx"},{"$f":"AG12","v":2742903.4576084837},494440.80454372457,494440.80454372457,1078212.4226011033,557696.08065574325,557696.08065574325,494440.80454372457,{"$f":"AN12","v":0},2331467.9389672112,2468613.1118476349]
[null,"Environmental Costs: NOx",{"$f":"C12","v":1858986.9355191439},2742903.4576084837,494440.80454372457,494440.80454372457,1078212.4226011033,557696.08065574325,557696.08065574325,557696.08065574325,557696.08065574325,494440.80454372457,0,1580138.895191272,2331467.9389672112,{"$f":"P12","v":1673088.2419672296},2468613.1118476349,null,null,{"$f":"B13","v":"Environmental Costs: PM"},{"$f":"U13","v":322493.98172126},25460.051188520523,25460.051188520523,225745.78720488193,322493.98172126,32249.398172125988,25460.051188520523,0,161246.99086063,225745.78720488198,{"$f":"AE14","v":0},{"$f":"B13","v":"Environmental Costs: PM"},{"$f":"AG13","v":763801.53565561573},25460.051188520523,25460.051188520523,225745.78720488193,763801.53565561573,32249.398172125988,25460.051188520523,{"$f":"AN13","v":0},381900.76782780787,534661.07495893107]
[null,"Environmental Costs: PM",{"$f":"C13","v":322493.98172126},763801.53565561573,25460.051188520523,25460.051188520523,225745.78720488193,322493.98172126,763801.53565561573,32249.398172125988,32249.398172125988,25460.051188520523,0,161246.99086063,381900.76782780787,225745.78720488198,534661.07495893107,null,null,{"$f":"B16","v":"Total SC"},{"$f":"SUM(U18:U26)","v":7009488.046908984},{"$f":"SUM(V18:V26)","v":5555692.7476364402},6222056.2914385637,6209823.3161153384,5841974.425116851,5658739.1165040191,5970712.9772566939,{"$f":"SUM(AB18:AB26)","v":4003785.6088425219},6567194.6602482712,6936978.3267265391]
[null,"Total SC",{"$f":"C16","v":7009488.046908984},8293557.5160747617,5555692.7476364402,6698556.2914385637,6686323.3161153384,5841974.425116851,6279202.587582157,5658739.1165040191,5652099.7163287122,5970712.9772566939,4003785.6088425219,6567194.6602482712,7539177.4809913887,6936978.3267265391,8038858.4756547352]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"insurance costs (all 161000"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Assement period"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Ship segment (Data)'!W5","v":15}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Residual value in 2050?"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"yes"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LNG price"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,442,"442 (Hary input"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"U3","v":"CCNR2 revision"},"Stage V","LNG mono fuel","LNG Dual fuel refit","SCR CCNR2","SCR+ DPF CCNR2","Diesel electric",null,{"$f":"AC3","v":"FWE CCNR2"},{"$f":"AD3","v":"GTL CCNR2"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"investment costs",{"$f":"U4+U5","v":171826.60714285713},{"$f":"V4+V5-$U$59","v":437255.40714285709},1752035.392857143,824270.39285714284,87031.60714285713,161784.60714285713,927720.93285714288,null,{"$f":"AC4+AC5-$U$59","v":148636.8331428571},{"$f":"AD4+AD5-$U$59","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TCO (over 30 years)",{"$f":"SUM(U4:U10)","v":2863864.1725097564},{"$f":"SUM(V4:V10)-$U$60","v":301315.37924317876},1297411.9232020276,495527.17157525197,133777.23307126807,240786.5080075697,716335.60886343289,null,{"$f":"SUM(AC4:AC10)-$U$60","v":96008.792385731358},{"$f":"SUM(AD4:AD10)-$U$60","v":210137.16788584692}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"enviromental benefits",{"$f":"SUM(U11:U13)","v":4145623.8743992276},{"$f":"$U$61-SUM(V11:V13)","v":1755110.6785157216},1608343.6786724469,818691.9023688985,1301290.8548634006,1591535.4384125345,1755110.6785157216,null,{"$f":"$U$61-SUM(AC11:AC13)","v":538302.1790464432},{"$f":"$U$61-SUM(AD11:AD13)","v":282646.88806829229}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Effectivity",null,{"$f":"V60/V61","v":0.1716788479106047},{"$f":"W60/W61","v":0.80667579971025383},0.60526697545369135,0.10280348361113394,0.15129195504923248,0.4081426987095938,null,0.17835482768396521,0.74346181315491511]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"[TCO in euro]/ [Environmental benefits in euro]"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2020-2050"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"V58","v":"Stage V"},{"$f":"V63","v":0.1716788479106047},null,null,"Diesel (baseline)- Stage V",0.1714250242358614]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"W58","v":"LNG mono fuel"},{"$f":"W63","v":0.80667579971025383},null,null,"LNG mono fuel",-3.4097116124934115E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"X58","v":"LNG Dual fuel refit"},{"$f":"X63","v":0.60526697545369135},null,null,"LNG Dual fuel refit",-0.8724861600881344]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Y58","v":"SCR CCNR2"},{"$f":"Y63","v":0.10280348361113394},null,null,"SCR (CCR2)",9.5013030216288388E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Z58","v":"SCR+ DPF CCNR2"},{"$f":"Z63","v":0.15129195504923248},null,null,"SCR+ DPF (CCR2)",0.18004962501030508]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AA58","v":"Diesel electric"},{"$f":"AA63","v":0.4081426987095938},null,null,"Diesel electric (0% fuel change)",0.24570473883878721]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Diesel electric incl advantage in 2030 (0% fuel change)",0.1632318154392296]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AC58","v":"FWE CCNR2"},{"$f":"AC63","v":0.17835482768396521},null,null,"FWE CCR2",0.11897020262404417]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AD58","v":"GTL CCNR2"},{"$f":"AD63","v":0.74346181315491511},null,null,"GTL CCR2",2.081206466305066]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Revision","Stage V","LNG mono fuel","LNG Dual fuel refit","SCR","SCR+ DPF","Diesel electric","Battery electric","FWE","GTL",null,null,"Lijn"]
[null,"TCO extra costs",{"$f":"C15-$C15","v":0},{"$f":"E15-$C15","v":301315.37924317876},{"$f":"F15-$C15","v":1297411.9232020276},{"$f":"G15-$C15","v":495527.17157525197},{"$f":"H15-$C15","v":133777.23307126807},{"$f":"J15-$C15","v":240786.5080075697},{"$f":"L15-$C15","v":716335.60886343289},{"$f":"M15-$C15","v":908979.07522612857},{"$f":"N15-$C15","v":96008.792385731358},{"$f":"P15-$C15","v":210137.16788584692},null,null,{"$f":"MAX($C$129:$L$129)","v":1297411.9232020276}]
[null,"Enviromental benefits (euro)",{"$f":"SUM($C$11:$C$13)-SUM(C11:C13)","v":0},{"$f":"SUM($C$11:$C$13)-SUM(E11:E13)","v":1755110.6785157216},{"$f":"SUM($C$11:$C$13)-SUM(F11:F13)","v":1608343.6786724469},{"$f":"SUM($C$11:$C$13)-SUM(G11:G13)","v":818691.9023688985},{"$f":"SUM($C$11:$C$13)-SUM(H11:H13)","v":1301290.8548634006},{"$f":"SUM($C$11:$C$13)-SUM(J11:J13)","v":1591535.4384125345},{"$f":"SUM($C$11:$C$13)-SUM(L11:L13)","v":1755110.6785157216},{"$f":"SUM($C$11:$C$13)-SUM(M11:M13)","v":3914681.5132925906},{"$f":"SUM($C$11:$C$13)-SUM(N11:N13)","v":538302.1790464432},{"$f":"SUM($C$11:$C$13)-SUM(P11:P13)","v":282646.88806829229},null,null,{"$f":"O129","v":1297411.9232020276}]
[null,"Initial investment costs",{"$f":"C14-$C14","v":0},{"$f":"E14-$C14","v":437255.40714285709},{"$f":"F14-$C14","v":1752035.392857143},{"$f":"G14-$C14","v":824270.39285714284},{"$f":"H14-$C14","v":87031.60714285713},{"$f":"J14-$C14","v":161784.60714285713},{"$f":"L14-$C14","v":927720.93285714288},{"$f":"M14-$C14","v":2561162.6319166943},{"$f":"N14-$C14","v":148636.8331428571},1000,null,null,1]
[null,"Total social benefits",{"$f":"$C16-C16","v":0},{"$f":"$C16-E16","v":1453795.2992725438},{"$f":"$C16-F16","v":310931.75547042023},323164.73079364561,{"$f":"$C16-H16","v":1167513.621792133},{"$f":"$C16-J16","v":1350748.9304049648},{"$f":"$C16-L16","v":1038775.0696522901},{"$f":"$C16-M16","v":3005702.4380664621},{"$f":"$C16-N16","v":442293.38666071277},{"$f":"$C16-P16","v":72509.7201824449}]
[]
[]
[null,null,null,{"$f":"D130/D129","v":5.8248293961100694},1.239655386165279,1.652163492400073,9.7272968276310134,6.6097367812755552,2.4501234572164452,4.3066794604911314,5.6068008530273383,1.3450589960450734]
[]
[]
[]
[]
[]
[]
[null,null,{"$f":"D18","v":"CCNRO revision"},{"$f":"E18","v":"Stage V"},{"$f":"F18","v":"LNG mono fuel"},{"$f":"G18","v":"LNG Dual fuel refit"},{"$f":"I18","v":"SCR CCNR0"},{"$f":"K18","v":"SCR+DPF CCNR0"},{"$f":"L18","v":"Diesel electric"},{"$f":"M18","v":"Battery electric"},{"$f":"O18","v":"FWE CCNR0"},{"$f":"Q18","v":"GTL CCNR0"}]
[null,"TCO extra costs",{"$f":"D15-$D15","v":0},{"$f":"E15-$D15","v":323763.86269958364},{"$f":"F15-$D15","v":1319860.4066584324},{"$f":"G15-$D15","v":517975.65503165685},{"$f":"I15-$D15","v":170852.44846013514},{"$f":"K15-$D15","v":275301.71469018003},{"$f":"L15-$D15","v":738784.09231983777},{"$f":"M15-$D15","v":931427.55868253345},{"$f":"O15-$D15","v":118457.27584213624},{"$f":"Q15-$D15","v":230025.64263599506}]
[null,"Enviromental benefits (euro)",{"$f":"SUM($D$25:$D$27)-SUM(D25:D27)","v":0},{"$f":"SUM($D$25:$D$27)-SUM(E25:E27)","v":3061628.6311379047},{"$f":"SUM($D$25:$D$27)-SUM(F25:F27)","v":2914861.63129463},2125209.8549910816,{"$f":"SUM($D$25:$D$27)-SUM(I25:I27)","v":2185207.3769527408},{"$f":"SUM($D$25:$D$27)-SUM(K25:K27)","v":2916759.5144362305},{"$f":"SUM($D$25:$D$27)-SUM(L25:L27)","v":3061628.6311379047},5221199.4659147738,{"$f":"SUM($D$25:$D$27)-SUM(O25:O27)","v":872837.31092550885},{"$f":"SUM($D$25:$D$27)-SUM(Q25:Q27)","v":484724.68305602204}]
[null,"Initial investment costs",{"$f":"D14-$D14","v":0},{"$f":"E14-$D14","v":437255.40714285709},{"$f":"F14-$D14","v":1752035.392857143},{"$f":"G14-$D14","v":824270.39285714284},{"$f":"I14-$D14","v":87031.60714285713},{"$f":"K14-$D14","v":161784.60714285713},{"$f":"L14-$D14","v":927720.93285714288},{"$f":"M14-$D14","v":2561162.6319166943},{"$f":"O14-$D14","v":148636.8331428571},1]
[null,"Total social benefits",{"$f":"$D16-D16","v":0},{"$f":"$D16-E16","v":2737864.7684383215},{"$f":"$D16-F16","v":1595001.224636198},{"$f":"$D16-G16","v":1607234.1999594234},{"$f":"$D16-I16","v":2014354.9284926048},{"$f":"$D16-K16","v":2641457.7997460496},{"$f":"$D16-L16","v":2322844.5388180679},{"$f":"$D16-M16","v":4289771.9072322398},{"$f":"$D16-O16","v":754380.03508337308},{"$f":"$D16-Q16","v":254699.04042002652}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,{"$f":"B131","v":"Initial investment costs"},{"$f":"B129","v":"TCO extra costs"},{"$f":"B130","v":"Enviromental benefits (euro)"},"Benefits / Costs"]
[null,{"$f":"D128","v":"Stage V"},{"$f":"D131","v":437255.40714285709},{"$f":"D129","v":301315.37924317876},{"$f":"D130","v":1755110.6785157216},{"$f":"E192/D192","v":5.8248293961100694}]
[null,{"$f":"E128","v":"LNG mono fuel"},{"$f":"E131","v":1752035.392857143},{"$f":"E129","v":1297411.9232020276},{"$f":"E130","v":1608343.6786724469},{"$f":"E193/D193","v":1.239655386165279}]
[null,{"$f":"F128","v":"LNG Dual fuel refit"},{"$f":"F131","v":824270.39285714284},{"$f":"F129","v":495527.17157525197},{"$f":"F130","v":818691.9023688985},1.652163492400073]
[null,{"$f":"G128","v":"SCR"},{"$f":"G131","v":87031.60714285713},{"$f":"G129","v":133777.23307126807},{"$f":"G130","v":1301290.8548634006},9.7272968276310134]
[null,{"$f":"H128","v":"SCR+ DPF"},{"$f":"H131","v":161784.60714285713},{"$f":"H129","v":240786.5080075697},{"$f":"H130","v":1591535.4384125345},6.6097367812755552]
[null,{"$f":"I128","v":"Diesel electric"},{"$f":"I131","v":927720.93285714288},{"$f":"I129","v":716335.60886343289},{"$f":"I130","v":1755110.6785157216},2.4501234572164452]
[null,{"$f":"J128","v":"Battery electric"},{"$f":"J131","v":2561162.6319166943},{"$f":"J129","v":908979.07522612857},{"$f":"J130","v":3914681.5132925906},{"$f":"E198/D198","v":4.3066794604911314}]
[null,{"$f":"K128","v":"FWE"},{"$f":"K131","v":148636.8331428571},{"$f":"K129","v":96008.792385731358},{"$f":"K130","v":538302.1790464432},{"$f":"E199/D199","v":5.6068008530273383}]
[null,{"$f":"L128","v":"GTL"},null,{"$f":"L129","v":210137.16788584692},{"$f":"L130","v":282646.88806829229},{"$f":"E200/D200","v":1.3450589960450734}]

{"sheet":"Key Data","index":6,"n_rows":205,"n_cols":37,"rows_kept":205,"cut":false,"hidden":true,"merged":[[1,0,1,3]]}
[]
["Key data"]
[]
["General data/Details - LNG (Mono & Dual fuel)","#","Units","Source","Type of costs"]
["Fuel price",{"$f":"N9","v":583},"Euro per 1000 liter","CBRB five year average price https://www.zandmij.nl/logistiek/cbrb"]
["Fuel price (Diesel/100KG)",{"$f":"B5/B42","v":697.39693356047701},"Per 1000 KG","http://www.interrijn.com/","operational"]
["Fuel Price (Diesel/Ton)",{"$f":"B6","v":697.39693356047701},"Per Ton","http://www.interrijn.com/",{"$f":"E6","v":"operational"}]
["Fuel price (Diesel/Lt)",{"$f":"70.11/100","v":0.70109999999999995},"€ /lt","http://www.interrijn.com/ (70.11 euro for 100 Lt on 16/11/2018)",{"$f":"E7","v":"operational"},null,null,2015,2016,2017,2018,2019,2020,"Average"]
["Fuel price (LNG)",{"$f":"0.75*B7","v":523.04770017035776},"€ /ton","501$/ton converted into euro (DNV GL Sep 18) (https://www.dnvgl.com/maritime/lng/current-price-development-oil-and-gas.html)",{"$f":"E8","v":"operational"},null,"€ per 1000 litre",569,490,564,657,668,550,{"$f":"AVERAGE(H9:M9)","v":583}]
["Fuel price (Diesel/BBTU)",7.298,"$/bbtu ","Coversion of 1 BTU = 10.41 Liter atmosphere has been used. ",{"$f":"E9","v":"operational"}]
["Diesel (New engine Phase V)",{"$f":"B12+B80+B82","v":354.4},"(euro/kW)","https://theicct.org/publications/emission_reduction_tech_cost_non_road_diesel","investment","VERWIJZEN SCR DPF aan de hand van kW","DST gaat uit van 375 "]
["Diesel (New engine CCNR2) ",220,"(euro/kW)","Robert Hekkenberg 2014 - and Prominent D2.8 Page nr 30","investment",null,{"$f":"220*500","v":110000},{"$f":"G12+10000","v":120000},{"$f":"H12/500","v":240}]
["Price difference (Scenario 4: Current policies = 0.35)",0.35,"Euro/l","Pg:9 Act 1.1 Ex ante cost benefit analysis","operational"]
["Price difference (Scenario 1: Clow oil price (0,05))",0.05,"Euro/l",null,"operational"]
["Methane CO2 eq.",28,"CO2 eq/","IPCC","environmental"]
["LNG Engine (Mono fuel) (500 - 2000kw) - Min",895825,"€ ","The costs are additional costs compared to diesel taken from Pg:40 (Salih Karaarslan)","investment"]
["LNG Engine Mono fuel (2000kw) - Max",1920425,"€ ","Pg: 40 Act 1.1 (Prominent concluded it is not possible to calculate this cost)","investment"]
["Price difference (Scenario 1: Low oil price)",0.05,"Lt/euro","Pg:9 Act 1.1 Ex ante cost benefit analysis","operational"]
["Price difference (Scenario 2: 450 )",0.17,"Lt/euro","Pg:9 Act 1.1 Ex ante cost benefit analysis","operational"]
["Dual fuel engine (low estimate) - Additional costs as compared to diesel",null,"€ ","Pg: 40 Act 1.1 Ex ante cost benefit analysis","investment"]
["Dual fuel engine (Middle estimate) - Additional costs as compared to diesel",666335,"€ ","Based on average of the low estimate and the high estimate","investment"]
["Dual fuel engine (High estimate) - Additional costs as compared to diesel",967670,"€ ","Pg: 40 Act 1.1 Ex ante cost benefit analysis","investment"]
["Ton to liter ","1 ton = 1000 lt","litres","14314 Tonnes (metric ton) into Liters, For substance with density: 885 kg/m3","general"]
["CO2 emissions Diesel WTW",3.9129999999999998,"kg/ kg","STREAM 2020","environmental"]
["CO2 emission/LT (LNG) WTW",3.69," kg/kg","STREAM 2020 (Max 10% reduction - Salih Karaarslan 2017)","environmental"]
["Fuel use benefit of Euro VI",0.05,"per kwh","discussions with Vink diesel "]
["Methane emissions (LNG Only)",4,"g/kWh ","For other dual or mono fuel engines (TNO, 2017)/4g/kwh = 0.53MJ (This is the value taken)","environmental"]
["NOX emissions (Diesel) CCR 0",{"$f":"'Emission factors'!D4","v":9.93},"g/kwh ","Measurements CLINSH","environmental"]
["NOX emissions (Diesel) CCR 1",{"$f":"B28","v":9.93},"g/kwh ","Measurements CLINSH","environmental"]
["NOX emissions (Diesel) CCR 2",{"$f":"'Emission factors'!D7","v":6.73},"g/kwh ","Measurements CLINSH","environmental"]
["NOX emissions (LNG)/ Phase  V @ 1.8g/kwh",1.79,"g/kwh","EMS protocol BIVAS","environmental"]
["Nox emission Phase V <300 kW",2.9,"g/ kWh","EMS protocol BIVAS","environmental"]
["Nox emissions Euro VI <400 kW",0.4,"g/ kWh","https://dieselnet.com/standards/eu/hd.php"]
["Nox emission LNG Dual fuel",{"$f":"58%*B30","v":3.9034},"g/kwh","Prominent D1.2; page 69","environmental",null,"Tremod","TNO"]
["PM emission (Diesel) CCR0",{"$f":"H35","v":0.45},"g/kwh","TNO","environmental",null,0.4,0.45]
["PM emission (Diesel) CCR1",{"$f":"H36","v":0.28499999999999998},"g/kwh","TNO","environmental",null,0.12,0.28499999999999998]
["PM emission (Diesel) CCR2",0.19,"g/kwh","TNO","environmental",null,0.12,0.19]
["PM emission (LNG) and stage V >300 kW",1.4999999999999999E-2,"g/kwh","EMS protocol BIVAS","environmental"]
["Stage V <300 kW PM",0.1,"g/kwh","EMS protocol BIVAS","environmental"]
["PM emissions Euro VI <400 kW",0.01,"g/kwh","https://dieselnet.com/standards/eu/hd.php"]
["PM emission LNG Dual fuel",{"$f":"70%*B37","v":0.13299999999999998},"g/kwh","Prominent D1.2; page 69 : 50-90& reduction","environmental"]
["Diesel density ",0.8359658208182289,"(kg/ litre)","STREam 2020","environmental"]
["Energy density Diesel",35.859200000000001,"MJ/ liter","STREAM 2020","environmental"]
["Specfic diesel consumption ",0.20699999999999999,"(kg/ kwh)","STREAM 2020","environmental"]
["Installation cost (Tank above deck) Min",507500,"€ ","Pg:40 Act 1.1 Ex ante cost beneift analysis","investment"]
["Installation cost (Tank above deck) Avg",{"$f":"AVERAGE(B45,B47)","v":598750},"€ ","Pg:40 Act 1.1 Ex ante cost beneift analysis","investment",null,{"$f":"B49+B51+B52+B55","v":1391822}]
["Installatioon cost (Tank above deck) Max",690000,"€ ","Pg:40 Act 1.1 Ex ante cost beneift analysis","investment",null,{"$f":"G46/1000","v":1391.8219999999999}]
["Installation cost (Tank under deck) Min",667500,"€ ","Pg:40 Act 1.1 Ex ante cost beneift analysis","investment"]
["Installation cost (Tank under deck) Avg",{"$f":"AVERAGE(B48,B50)","v":777500},"€ ","Pg:40 Act 1.1 Ex ante cost beneift analysis","investment"]
["Installation cost (Tank under deck) Max",887500,"€ ","Pg:40 Act 1.1 Ex ante cost beneift analysis","investment"]
["Tank connection space (for all categories of ships)",377500,"€ ","Pg:40 Act 1.1 Ex ante cost beneift analysis","investment"]
["Tank (for all categories of ships)",165000,"€ ","Pg:40 Act 1.1 Ex ante cost beneift analysis","investment"]
["Oppurtunity cost",{"$f":"4*7","v":28},"days","Pg:40 Act 1.1 Ex ante cost beneift analysis","investment"]
["Additional installation cost (Low estimate)",20231,"€ ","Pg:40 Act 1.1 Ex ante cost beneift analysis","investment"]
["Additional installation cost (middle estimate)",{"$f":"(B54+B56)/2","v":71822},"€ ","Pg:40 Act 1.1 Ex ante cost beneift analysis","investment"]
["Additional installation cost (High estimate)",123413,"€ ","Pg:40 Act 1.1 Ex ante cost beneift analysis","investment"]
["Oil duty under CCR convention (per 100 liters)",7.5,"€ /liter","Pg:20 Charges for barges (CE delft, 2004) & https://www.cdni-iwt.org/en/part-a/","operational"]
["Climate cost (€ /tonne) - (Diesel (Maritime emissions cost factor)",{"$f":"AD64","v":167.53488307521593},"€ ",{"$f":"D60","v":"CE Delft Handbook of External costs "},"environmental"]
["Climate cost (€ /tonne) (LNG - Maritime emissions cost factor)",{"$f":"B58","v":167.53488307521593},"€ ",{"$f":"D60","v":"CE Delft Handbook of External costs "},"environmental",null,null,"source: handbook of external cots"]
["Cllimate costs 2050 (€/ tonne CO2)",269,null,"CE Delft Handbook of External costs ","environmental",null,"Emission factors","€/ton NOX","€/ton NOX","€/ton NMVOC","€/ton SO2","€/ton PM (exhaust)",null,null,"Inflation","source Eurostat",null,null,null,"€/ton NOX","€/ton NOX","€/ton NMVOC","€/ton SO2","€/ton PM (exhaust)"]
["Annual increase climate costs factor",1,null,{"$f":"D60","v":"CE Delft Handbook of External costs "},"environmental",null,null,"cities","rural","All areas","All areas","Metropolitan","Urban","Rural",2016,2018,null,null,null,"cities","rural","All areas","All areas","Metropolitan","Urban","Rural","tkm 2018 (Eurostat)",null,null,"CO2 short term (<2030)",null,null,"Metropolitan","Urban","Rural","€/ton NOX","€/ton PM (exhaust)"]
["rentfacto/climatecost factor -1",{"$f":"(B76/B61)-1","v":4.0000000000000036E-2},null,null,"environmental",null,"Belgium",26100,15100,3600,17100,479000,155000,114000,98.68,102.48,null,null,"Belgium",{"$f":"H62/$O62*$P62","v":27105.066882853665},15681.475476286987,3738.6299148763683,17758.492095662747,497445.48034049448,160968.7880016214,118389.94730441833,11328,null,"bron EU handboek",100,null,"Share (source PVeR 2014)",0.05,0.05,0.9,{"$f":"((AG62+AH62)*T65)+U65*AI62","v":20038.39432960697},{"$f":"X65*AG62+Y65*AH62+Z65*AI62","v":123131.63851847389}]
["Environmental costs Nox euro/kg ",{"$f":"AJ62/10^3","v":20.03839432960697},"€ ","CE Delft Handbook of External costs ","environmental",null,"Germany",36800,21600,1800,16500,448000,144000,93000,100.4,104,null,null,"Germany",38119.521912350596,22374.501992031874,1864.5418326693225,17091.633466135459,464063.74501992029,149163.34661354579,96334.661354581665,46901,null,"Toename CO2 prijs",3.5000000000000003E-2]
["Environmental costs PM 2.5 euro/kg rural",{"$f":"AK62/10^3","v":123.13163851847389},"€ ","CE Delft Handbook of External costs ","environmental",null,"Netherlands",26500,15300,2800,20200,458000,148000,101000,100.11,103.2,null,null,"Netherlands",27317.95025471981,15772.250524423134,2886.4249325741685,20823.494156427929,472136.64968534611,152568.17500749175,104117.47078213964,47242,null,"Gemiddelde ",{"$f":"AD62*(1+AD63)^15","v":167.53488307521593}]
["Estimated annual savings on port dues",13.55,"%","Pg:40 Act 1.1 Ex ante cost beneift analysis","operational",null,null,null,null,null,null,null,null,null,null,null,null,null,"Weighted",{"$f":"SUMPRODUCT(T62:T64,$AA$62:$AA$64)/SUM($AA$62:$AA$64)","v":32098.344576173495},{"$f":"SUMPRODUCT(U62:U64,$AA$62:$AA$64)/SUM($AA$62:$AA$64)","v":18698.399857766242},{"$f":"SUMPRODUCT(V62:V64,$AA$62:$AA$64)/SUM($AA$62:$AA$64)","v":2523.5426120394445},18834.81156519664,471265.04641950416,151956.36974816018,102189.51967787853]
["Interest rate (Depricition cost -Own calculation)",0.04,"%","Suggested by Mattijs / ook uit prominent"]
["Energy efficiency (LNG Mono fuel) ",{"$f":"36/100","v":0.36},"%","Life cycle assessment of marine fuels (Chalmers university, 2011)"]
["Energy efficiency (LNG dual fuel)",{"$f":"41/100","v":0.41},"%","Life cycle assessment of marine fuels (Chalmers university, 2011)"]
["Energy efficiency (Conventional CCNR2 diesel engine)",{"$f":"41/100","v":0.41},"%","Life cycle assessment of marine fuels (Chalmers university, 2011)"]
["LNG energy density (MJ/ kg)",49,"MJ/KG","STREAM 2020"]
["Relative revision costs (% of new engine costs)",0.5,"%","Bijlagen visie On-Board-Monitoring in de binnenvaart"]
["Relative scrap value of engine at half life time (without revision)",0.25,"%","Source: Assumed by mattijs"]
["Assessment period",30,"years","Source: Assumed by Mattijs"]
["NPV Scrap value new engine after 30 years (% of new engine price)",0.1,"%","Source: Assumed by matijs"]
["Lineair value decrease factor over life time",{"$f":"(1+B71)-B74","v":1.4},"%","Source: assumption see cel G68 for explanation",null,null,"Depreciation of engine value"]
["Annual interest factor NPV calculation",{"$f":"1+B66","v":1.04},null,"Source:Assumed by Mattijs",null,null,"Scrap valuue",{"$f":"B74","v":0.1}]
[null,null,null,null,null,null,"Costs  revision = increase in vale engine = % of new value",{"$f":"B71","v":0.5}]
["General data/Details - SCR +DPF","#","Units","Source",null,null,"Life time: assume 30 year"]
["SCR (Investment costs - Variable) @ < 30000 hours in five years",25,"Euro/ kW","Prominent (D2.2), Page 23. Section 2.4.1","investment",null,"Year","Rest value engine","Revision costs","Rest value+ revision costs",null,null,"NPV rest value","NPV revision costs","NPV total"]
["SCR (Investment costs - Variable) @ > 30000 hours ",52.5,"Euro/ kW","Prominent (D2.2), Page 23. Section 2.4. 1","investment",null,0,1,0,{"$f":"H80+I80","v":1},null,null,{"$f":"H80","v":1},{"$f":"I80/1.04^G80","v":0},{"$f":"M80+N80","v":1},null,{"$f":"$J$80-G80/$G$85*140%","v":1},{"$f":"Q80/1.04^G80","v":1}]
["DPF (Investment costs - Variable) @ 30000 hours",39,"Euro/ kW","Prominent (D2.2), Page 24. Section 2.4. 2","investment",null,15,{"$f":"H80-15/30*B75","v":0.30000000000000004},0,0.30000000000000004,null,null,{"$f":"H81/1.04^G81","v":0.16657935081398245},0,{"$f":"M81+N81","v":0.16657935081398245},null,0.30000000000000004,0.16657935081398245]
["DPF (Investment costs - Variable) @ 30000 - 60000 hours",81.900000000000006,"Euro/ kW","Prominent (D2.2), Page 24. Section 2.4. 2","investment",null,15,{"$f":"H81+H77","v":0.8},-0.5,0.30000000000000004,null,null,{"$f":"H82/1.04^G82","v":0.44421160217061989},-0.27763225135663738,{"$f":"M82+$N$82","v":0.16657935081398251},null,0.30000000000000004,0.16657935081398245]
["SCR design and installation costs (Per unit/per engine)",45000,"per engine","Prominent (D2.2), Page 24. Section 2.4. 1","investment",null,20,{"$f":"H82-5/15*70%","v":0.56666666666666676},0,0.56666666666666676,null,null,{"$f":"H83/1.04^G83","v":0.25861926951406555},0,{"$f":"M83+$N$82","v":-1.901298184257183E-2},null,6.6666666666666763E-2,3.0425796413419515E-2]
["DPF design and installation costs",15200,"per engine",null,"investment",null,25,{"$f":"H82-10/15*70%","v":0.33333333333333343},0,0.33333333333333343,null,null,{"$f":"H84/1.04^G84","v":0.12503893408465463},0,{"$f":"M84+$N$82","v":-0.15259331727198275},null,-0.16666666666666674,-6.2519467042327317E-2]
["SCR + DPF (Investment cost - Fixed) @ 30000 hours (For high speed engines)",15200,"Euro","Prominent (D2.2), Page 24. Section 2.4. 1","investment",null,30,{"$f":"H82-15/30*B75","v":0.10000000000000009},0,0.10000000000000009,null,null,{"$f":"H85/1.04^G85","v":3.083186679734206E-2},0,{"$f":"M85+$N$82","v":-0.24680038455929532},null,-0.39999999999999991,-0.1233274671893681]
["SCR + DPF (Investment cost - % increase from high speed engines)",0.5,"%","Prominent (D2.2), Page 24. Section 2.4. 1","investment"]
["SCR + DPF (Investment cost - Fixed) @ 30000 hours (For medium speed engines) (Costs determined based on 50% higher than high speed engines)",22800,"Euro","Prominent (D2.2), Page 24. Section 2.4. 1","investment"]
["SCR - Maintenance costs (Includes repair) for every 1000 engine hours",2,"Euro/1000kwh","Prominent (D2.2), Page 23. Section 2.4. 1","operational",null,1]
["DPF - Maintenance costs (Includes repair) for every 1000 engine hours + filter cleaning @ 3000 hours",2.34,"Euro/1000kwh","Prominent (D2.2), Page 23. Section 2.4. 1","operational",null,null,"number of engines",1,1,1.5,2,2.5,3]
["Urea consumption of CCNR2 engines (To reduce Nox to 1.8g/kwh)",4.8000000000000001E-2,"Liter/ kg diesel","Prominent (D2.2), Page 23. Section 2.4. 1","operational",null,null,"kW",500,{"$f":"I90+500","v":1000},{"$f":"J90+500","v":1500},2000,2500,3000]
["Urea consumption of CCNR1 and CCCNR0 engines (To reduce Nox to 1.8g/kwh)",{"$f":"9/100","v":0.09},"Liter/ kg diesel","Prominent (D2.2), Page 24. Section 2.4. 1","operational",null,null,"filter",{"$f":"$B$81*I90","v":19500},{"$f":"$B$81*J90","v":39000},58500,78000,97500,117000]
["Price of Urea (Adblue) Min",0.25,"Euro/litre","Prominent (D2.2), Page 24. Section 2.4. 1","operational",null,null,"per engine",{"$f":"$B$84*I89","v":15200},{"$f":"$B$84*J89","v":15200},22800,30400,38000,45600]
["Price of Urea (Adblue) Max",0.31,"Euro/litre","Prominent (D2.2), Page 24. Section 2.4. 1","operational",null,null,"SCR",{"$f":"$B$79*I90","v":12500},{"$f":"$B$79*J90","v":25000},37500,50000,62500,75000]
["Price of Urea (Adblue) Avg",0.28000000000000003,"Euro/litre","Prominent (D2.2), Page 24. Section 2.4. 1","operational",null,null,"SCR fixed",{"$f":"$B$83*I89","v":45000},{"$f":"$B$83*J89","v":45000},67500,90000,112500,135000]
["Lifetime of the system (SCR + Catalyst)",30000,"Hours","Prominent (D2.2), Page 23. Section 2.4.1","operational",null,null,"Total",{"$f":"SUM(I91:I94)","v":92200},{"$f":"SUM(J91:J94)","v":124200},186300,248400,310500,372600]
["Rotterdam - Basic tarriff (Annual and complied to CCNR2 Standards)",3.1960000000000002,"Euros/tonne","Prominent (D2.2), Page 25, Sectio 2.4.3","operational",null,null,null,{"$f":"I95/I90","v":184.4},{"$f":"J95/J90","v":124.2},{"$f":"K95/K90","v":124.2},{"$f":"L95/L90","v":124.2},124.2,124.2]
["Rotterdam - Basic tarriff (Annual and complied to CCNR1 Standards)",3.5150000000000001,"Euros/tonne","Prominent (D2.2), Page 25, Sectio 2.4.3","operational"]
["Rotterdam - Tariff (Green Award certficiation)",2.7160000000000002,"Euros/tonne","Prominent (D2.2), Page 25, Sectio 2.4.3","operational"]
["Rotterdam - Tariff (Emission 60% lower than CCNR2 standards) - *SCR + DPF installation reach these standards*",2.2370000000000001,"Euros/tonne","Prominent (D2.2), Page 25, Sectio 2.4.3","operational"]
["Antwerp - Basic Tarriff (Annual)",3.15,"Euros/tonne","Prominent (D2.2), Page 26, Sectio 2.4.3","operational"]
["Antwerp - Tarriff (if compiled to CCNR-2 standards)",2.9295,"Euros/tonne","Prominent (D2.2), Page 26, Sectio 2.4.3","operational"]
["Antwerp - Tarriff (if diesel electric, with CCNR2 engine) LNG or hydrogen powered",2.6755,"Euros/tonne","Prominent (D2.2), Page 26, Sectio 2.4.3","operational"]
["Amsterdam - Basic tarriff",3.2446000000000002,"Euros/tonne","Prominent (D2.2), Page 26, Sectio 2.4.3","operational"]
["Amsterdam - Green Award Bronze certificate",3.08,"Euros/Tonne","Prominent (D2.2), Page 26, Sectio 2.4.3","operational"]
["Amsterdam - Green Award Silver certificate",2.9201000000000001,"Euros/tonne","Prominent (D2.2), Page 26, Sectio 2.4.3","operational"]
["Amsterdam - Green Award Gold certificate ",2.75,"Euros/tonne","Prominent (D2.2), Page 26, Sectio 2.4.3","operational"]
["Oppurtunity costs",5,"Days","IWT Greening tool","investment"]
["Time needed for installation",5,"Days","Prominent D2.2 Annex A2","investment"]
["Additional power or Fuel penalty",2,"%","Data is based on Sea going vessel = 0,05kw and fuel penalty is 1-2% in SFOC","operational"]
["Nox emission (SCR Only)",0.7,"%","Prominent D1.2","environmental"]
["Nox emission (SCR + DPF)",0.7,"%","Prominent D1.2","environmental"]
["PM emission (SCR + DPF)",{"$f":"'Emission factors'!I5","v":0.9},"%",null,"environmental"]
["PM emission (SCR Only) CCNR 2 (Same as diesel value)",{"$f":"B37","v":0.19},"g/kwh","The information in prominent is contradicting from no increase/decrease of PM to 0-20%. CCNR2 Values are used.","environmental"]
["PM emission (SCR Only) CCNR 0 (Same as diesel value)",{"$f":"B35","v":0.45},null,"Assuming PM emission can be reduced optimizing on fuel consumption","environmental"]
["CO2 emission/LT (Diesel)",2.64,"kg/lt","Salih Karaarslan 2017 (Same value for SCR/SCR+DPF since they do not reduce CO2)."]
["Fuel benefit Phase 5",0.05,"%","3-10 Range Panteia 2020"]
["Fuel penalty CCR2 (Additional on top of phase V diesel vessel)",0.05,"%","Its 1 -2% based on manufacturer data but we have taken the conservative approach","operational"]
["Fuel penalty CCNR 1/ CCNR0 (Additional on top of baseline diesel vessel)",0.04,"%","2% since old engines are less efficienct hence load would vary so applying the conservative approach. ","operational"]
[]
["General data/Details - Right Sizing/Diesel - Electric/ Hybrid","#","Units","Source"]
["Diesel engine CCNR2 incl gear box",220,"Euro/Kw","Table 7, Pg: 30, Document D2.8/2.9 Prominent","investment",null,null,"kW",500,{"$f":"I121+500","v":1000},{"$f":"J121+500","v":1500},{"$f":"K121+500","v":2000},{"$f":"L121+500","v":2500},{"$f":"M121+500","v":3000}]
["Generator set",350,"Euro/Kw","Table 7, Pg: 30, Document D2.8/2.9 Prominent","investment",null,null,"Generator set",{"$f":"I121*$B$122","v":175000},{"$f":"J121*$B$122","v":350000},525000,700000,875000,1050000]
["Electromotor + Controller",500,"Euro/Kw","Table 7, Pg: 30, Document D2.8/2.9 Prominent","investment",null,null,"Electromotr",{"$f":"I121*$B$123","v":250000},{"$f":"J121*$B$123","v":500000},750000,1000000,1250000,1500000]
["Fuel based maintenance cost",0.12,"Euro/m3","Section 6.3, Pg: 30, Document D2.8/2.9 Prominent","operational",null,null,"Total",{"$f":"SUM(I122:I123)","v":425000},{"$f":"SUM(J122:J123)","v":850000},1275000,1700000,2125000,2550000]
["Power based maintenance cost",4.5999999999999996,"Euro/Kw","Section 6.3, Pg: 30, Document D2.8/2.9 Prominent","operational",null,null,"Eur/kw",{"$f":"I124/I121","v":850},850,850,850,850,850]
["Engine revision time frame","30,000 hour or 6 years","Hours/Years","Section 6.3, Pg: 30, Document D2.8/2.9 Prominent","operational"]
["Fuel price (Diesel/Lt)",0.70109999999999995,"$/ton ","http://www.interrijn.com/ (70.11 euro for 100 Lt on 16/11/2018)","operational",null,null,{"$f":"B124+B125+B128","v":67.72}]
["Engine revision",63,"Euro/Kw","Section 6.3, Pg: 30, Document D2.8/2.9 Prominent","operational"]
["Right size option 1 - Reduce it by 20%",80,"%","Table 9, Pg: 31, Document D2.8/2.9 Prominent","investment"]
["Right size option 2 - Reduce it by 40%",60,"%","Table 9, Pg: 31, Document D2.8/2.9 Prominent","investment"]
["Right size option 1 - Fuel reduction (Pessimistic value)",-0.01,"%","Table 9, Pg: 31, Document D2.8/2.9 Prominent","operational"]
["Right size option 1 - Fuel reduction (Optimistic value)",-3,"%","Table 9, Pg: 31, Document D2.8/2.9 Prominent","operational"]
["Conventional engine (KW - Baseline value)",1250,"kw","Table 9, Pg: 31, Document D2.8/2.9 Prominent","investment"]
["Right size option 2 - Fuel reduction (Pessimistic value)",-2,"%","Table 9, Pg: 31, Document D2.8/2.9 Prominent","operational"]
["Right size option 2 - Fuel reduction (Optimistic value)",-4,"%","Table 10, Pg: 32, Document D2.8/2.9 Prominent","operational"]
["Right size option 1 - Investment savings",55000,"Euro/yr","Table 10, Pg: 32, Document D2.8/2.9 Prominent","investment"]
["Right size option 2 - Investment savings",110000,"Euro/yr","Table 10, Pg: 32, Document D2.8/2.9 Prominent","investment"]
["Extra Investment cost- Hybrid (Compared to Diesel direct drive line) - Lower value",102,"Keur","Pg:33, Document D2.8/2.9 Prominent","investment"]
["Extra Investment cost- Hybrid (Compared to Diesel direct drive line) - Higher value",260,"Keur","Pg:33, Document D2.8/2.9 Prominent","investment"]
["Extra Investment cost- Diesel electric driveline (Compared to Diesel direct driveline)",575,"Keur","Pg:33, Document D2.8/2.9 Prominent","investment"]
["External costs ",0.6,"%","Pg:23, Document Panteia 2013 contribution to impact assessment. "]
["Weighted average external costs for emissions to air (NOX/PM)",10.47,"Euro/1000tkm","Pg:27, Document Panteia 2013 contribution to impact assessment (Up until 2035)"]
["Climate change costs (CO2)",3.06,"Euro/1000tkm","Pg:27, Document Panteia 2013 contribution to impact assessment (Up until 2035)"]
["Hybrid configuration 1",{"$f":"40/100","v":0.4},"%","Pg:16, Document D2.8/2.9 Prominent"]
["Hybrid configuration 2",{"$f":"50/100","v":0.5},"%","Pg:16, Document D2.8/2.9 Prominent"]
["Hybrid Configuration 3",{"$f":"30/100","v":0.3},"%","Pg:16, Document D2.8/2.9 Prominent"]
["Fuel penalty",7.0000000000000007E-2,"%","0-14% Page 20 Document D2.8/2.9 Prominent","operational"]
["Diesel electric fuel savings",0.02,"%","At a certain speed point, it is said to have 2% fuel savings (Page 20 Document D2.8/2.9 Prominent)","operational"]
["Engine revision time frame",6,"yrs","Pg:30, Document D2.8/2.9 Prominent","operational"]
["Engine revision (euro/kw)",63,"Euro/Kw","Pg:30, Document D2.8/2.9 Prominent","operational"]
["Idling days",14,"days","estimated based on greening tool","Jaar",2020,2030,2040]
["Battery costs ",{"$f":"G152","v":250},"Euro/KWh","BloombergNEF (2019)zegt 60 Euro per kW, TESLA truck gaat richting 150 € per kW (T&E paper), Innterreg gaat uit van 500 Eur /kwh","Kosten",500,250,150]
["Battery replacement"]
["Electricity costs",5.5E-2,"Euro/kwh","Intter Fact sheet 5 (0.10 per kwH) of PANTEIA marginale prijs voor elektriciteit is vastgesteld op € 0,055 per kWh;DST min 0.03, avg 0.05 en max 0.10. https://ec.europa.eu/clima/sites/clima/files/eu-climate-action/docs/impact_part2_en.pdf small increase for final consumers",null,null,null,"beon KEV 2019"]
["Battery lifetime",10,"years","EICB presentation",null,null,null,2020,2030,2040]
["Lifetime electro motor","simliar to diesel engines","years","assumption",null,null,null,0.3,0.1,0.05]
["CO2 emissions ",{"$f":"I156/1000","v":1E-4},"ton CO2/kWh"]
[]
["General data/Details - Fuel water emulsion","#","Units","Source"]
["Investment Cost (For smaller engines <1000 kw)",135,"Euro/kW","Pg: 198, Panteia (Contribution to impact assessment of measures for reducing emissions of inland navigation)","investment"]
["Investment Cost (For larger engines >1000 kw)",100,"Euro/kW","Pg: 198, Panteia (Contribution to impact assessment of measures for reducing emissions of inland navigation)","investment",null,"€ per MWh",2020,2030,2040,null,2020,2030,2040,null,2020,2030,2040]
["Hardware costs per KW",61,"Euro / kW ","IWT Greening tool  https://www.inlandwaterways.nl/greeningtool#","investment",null,"Be",{"$f":"H167","v":105},{"$f":"I167","v":111},97,null,{"$f":"AVERAGE(H162:H165)","v":98.666666666666671},{"$f":"AVERAGE(I162:I165)","v":102.66666666666667},{"$f":"AVERAGE(J162:J165)","v":92.333333333333329},null,{"$f":"SUM(L162:N162)/3","v":97.8888888888889},{"$f":"SUM(M162:N162)/2","v":97.5},{"$f":"N162","v":92.333333333333329}]
["Hardware costs per KW",70,"Euro / kW ","Assumption based on greening tool and Panteia","investment"]
["Hardware costs fixed",10000,"per  ship","IWT Greening tool  https://www.inlandwaterways.nl/greeningtool#","investment",null,"De",{"$f":"H170","v":107},{"$f":"I170","v":101},87]
["Yard time",12,"days","IWT Greening tool  https://www.inlandwaterways.nl/greeningtool# + 2 for revision","investment",null,"Nl",{"$f":"H173","v":84},{"$f":"I173","v":96},93]
["Installation costs",10000,"Euros","IWT Greening tool  https://www.inlandwaterways.nl/greeningtool#","investment",null,"BE"]
["Equipment costs (Based on Overview fleetender data) - Shipname: Hoekstra Brons",{"$f":"98500/883","v":111.5515288788222},"Euro/kW","Data from overview fleetender  (Ship of 883 kw)","investment",null,"Average Cost of Gross Electricity Generation (€'13/MWh)",105,111,97]
["Equipment costs (Based on Overview fleetender data) - Shipname: Invontes Scheepvaart",{"$f":"75000/1250","v":60},"Euro/kW","Data from overview fleetender (Ship of 1250 kw)","investment",null,"Average Price of Electricity in Final demand sectors (€'13/MWh)",146,157,158]
["Reverse osomosis unit ",{"$f":"7360/1250","v":5.8879999999999999},"Euro/kW","Data from overview fleetender (Ship of 1250 kw)","investment"]
["Additional cost (Ship of 883 kw)",{"$f":"15000/883","v":16.987542468856173},"Euro/kW","Data from overview fleetender ","investment",null,"DE",107,101,87]
["Additional cost (Ship of 1250 kw)",{"$f":"3500/1250","v":2.8},"Euro/kW","Data from overview fleetender ","investment",null,null,170,173,183]
["Measurement after installation costs",3500,"Euros","Data from overview fleetender ","investment"]
["Measurement after installation costs",{"$f":"250/1000","v":0.25},"euro/hour","IWT greening tool (Based on 250 euro per 1000 engine hours)","operational",null,"NL",84,96,93]
["Life span",8,"years","IWT Greening tool","operational",null,null,137,153,164,null,"number of engines",1,1,1.5,2,2.5,3]
[null,{"$f":"2/100","v":0.02},"%","Pg: 198, Panteia (Contribution to impact assessment of measures for reducing emissions of inland navigation)","operational",null,null,null,null,null,null,"kW",500,{"$f":"M175+500","v":1000},{"$f":"N175+500","v":1500},{"$f":"O175+500","v":2000},2500,3000]
["Reduction in fuel consumption",0.05,"%","Greening tool","operational",null,null,null,null,null,null,"Investment costs paneia",{"$f":"M175*$B$160","v":67500},{"$f":"N175*$B$160","v":135000},{"$f":"O175*$B$161","v":150000},{"$f":"P175*$B$161","v":200000},250000,300000]
["NOX reduction ",{"$f":"25/100","v":0.25},"%","Pg: 198, Panteia (Contribution to impact assessment of measures for reducing emissions of inland navigation)",null,null,null,null,null,null,null,"Greening tool",{"$f":"M175*$B$163+$B$164+$B$166","v":55000},90000,125000,160000,195000,230000]
["NOX reduction ",0.15,"%","Monitoring results",null,null,null,"Op basis van Shell","Meerprijs GTL per ton"]
["NOX reduction ",0.23,"%","Greening tool",null,null,null,null,null,null,null,null,{"$f":"M176/M$175","v":135},135,100,100,100,100]
["NOX emissions (Diesel)",7,"g/kwh ","6.0 - 8.0 (Prominent D1.2 - Page no. 22, Section 4.1",null,null,null,null,null,null,null,null,{"$f":"M177/M$175","v":110},{"$f":"N177/N$175","v":90},{"$f":"O177/O$175","v":83.333333333333329},80,78,76.666666666666671]
["Nox emissions (FWE) - 20% reduction",5.6,"g/kwh ","Pg: 198, Panteia (Contribution to impact assessment of measures for reducing emissions of inland navigation - Values taken from Test beds of german  vessel TUV Nord"]
["PM Reduction ",{"$f":"80/100","v":0.8},"%","Pg: 198, Panteia (Contribution to impact assessment of measures for reducing emissions of inland navigation)"]
["PM Reduction ",0.5,"%","Monitoring results"]
["PM Reduction ",0.7,"%","Greening tool"]
["PM emission (Diesel)",0.8,"g/kwh","Based on CCNR2 values (0,2 - 0,8g/kwh) (https://www.dieselnet.com/standards/eu/nonroad.php)"]
["PM emission (Diesel engine with FWE)",0.16,"g/kwh","Pg: 198, Panteia (Contribution to impact assessment of measures for reducing emissions of inland navigation - Values taken from Test beds of german  vessel TUV Nord"]
["CO2 Reduction ",3,"%","Pg: 198, Panteia (Contribution to impact assessment of measures for reducing emissions of inland navigation - Values taken from Test beds of german  vessel TUV Nord"]
[]
["General data/Details - GTL","#","Units","Source"]
["Price of GTL (On top of the diesel cost)",0.14705882352941177,"Euro/lt","Jamie file (Additional cost on top of per liter of bunker diesel)","operational"]
["Price of GTL ",{"$f":"B8+B190","v":0.84815882352941174},"Euro/lt","Jamie file (Additional cost on top of per liter of bunker diesel)","operational"]
["Price of GTL 2020 (2nd source)",{"$f":"B191/B42","v":1.0145855277901776},"Euro/kg","https://www.oliecentrale.nl/producten/lijstprijs-brandstoffen","operational"]
["Price of GTL 2020 (2nd source)",{"$f":"B200","v":767.13662691652473},"Euro/ton","https://www.oliecentrale.nl/producten/lijstprijs-brandstoffen","operational",null,"%",10,{"$f":"N9*H193/100/B42","v":69.739693356047695}]
["Price difference GTL- Diesel per kg",{"$f":"N9*B195-N9","v":94.88634037611439},"€ per ton","https://www.oliecentrale.nl/producten/lijstprijs-brandstoffen","operational"]
["Price difference GTL- Diesel per kg",{"$f":"B196*(42.9/44)*(836/780)","v":1.1627553008166627},"% GTL compared to diesel per KG",null,"operational"]
["Price difference GTL- Diesel per liter",{"$f":"14851/13347","v":1.1126844983891511},"% GTL compared to diesel per liter","https://www.oliecentrale.nl/producten/lijstprijs-brandstoffen"]
["NOX reduction ",0.1,"%","https://eibip.eu/publication/gas-to-liquid-gtl-fuel/ & monitoring results"]
["PM Reduction ",0.3,"%","https://eibip.eu/publication/gas-to-liquid-gtl-fuel/ & monitoring results"]
["Additional costs GTL",{"$f":"I193","v":69.739693356047695},"€ per ton","https://www.oliecentrale.nl/producten/lijstprijs-brandstoffen",null,null,"en kilogram Shell GTL Fuel bevat weliswaar meer energie "]
["Fuel price GTL",{"$f":"Invoer_waarden!G59","v":767.13662691652473},"€ per ton",{"$f":"'Key Data'!D248","v":0},null,null,"dan een kilogram conventionele diesel (44,0 tegen 42,9 "]
["HVO price",{"$f":"B6*1.23","v":857.79822827938676},"€ per ton","TNO 2021 R11152",null,null,"MJ), maar het aantal grammen per liter ligt beduidend lager. "]
["HVO WTW CO2 emissies",{"$f":"413.6/1000","v":0.41360000000000002},"kg/ kg","STREAM 2020"]
[null,null,null,null,null,null,"Tank je een liter GTL, dan krijg je 774 tot 782 gram brand-"]
["Geselecteerde brandstofprijs",{"$f":"IF(Invoer_waarden!$G$63='Ship segment (Data)'!$S$18,Invoer_waarden!$G$67,Invoer_waarden!$G$51)","v":697},{"$f":"C201","v":"€ per ton"},{"$f":"D201","v":"TNO 2021 R11152"},null,null,"stof. "]
["Geselecteerde CO2 productie",{"$f":"IF(Invoer_waarden!$G$63='Ship segment (Data)'!$S$18,$B$202,$B$24)","v":3.9129999999999998},{"$f":"B24","v":3.9129999999999998}]

{"sheet":"Emission factors","index":7,"n_rows":27,"n_cols":24,"rows_kept":27,"cut":false,"hidden":true,"merged":[[9,1,11,1],[17,1,19,1],[20,1,22,1],[15,1,16,1],[3,1,8,1],[12,1,14,1]]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Nox"]
[null,null,"g/kwh","Nox","PM",null,"Compared to Diesel","Nox","PM",null,null,null,null,"Engine type","Revision","Stage V","LNG mono fuel","LNG Dual fuel refit","SCR","SCR + DPF","Diesel electric","Battery electric","FWE","GTL"]
[null,"Diesel","CCNRO/1",9.93,{"$f":"(E5+E6)/2","v":0.26500000000000001},null,null,null,null,null,null,null,null,"unregulated",{"$f":"D5","v":11.8},{"$f":"D8","v":1.79},{"$f":"D17","v":1.79},{"$f":"D16","v":2.77},{"$f":"D10","v":3.5400000000000009},{"$f":"S4","v":3.5400000000000009},{"$f":"P4","v":1.79},{"$f":"U4","v":1.79},{"$f":"D18","v":10.030000000000001},{"$f":"D21","v":10.620000000000001}]
[null,null,"CCNRO",11.8,0.4,null,{"$f":"B10","v":"SCR/DPF"},0.7,0.9,null,null,null,null,"CCR1",{"$f":"D6","v":9.1999999999999993},{"$f":"P4","v":1.79},{"$f":"Q4","v":1.79},2.77,{"$f":"D11","v":2.7600000000000002},{"$f":"S5","v":2.7600000000000002},{"$f":"P5","v":1.79},{"$f":"U5","v":1.79},{"$f":"D19","v":7.8199999999999994},{"$f":"D22","v":8.2799999999999994}]
[null,null,"CCNR1",9.1999999999999993,0.13,null,{"$f":"B18","v":"FWE"},0.15,0.5,null,null,null,null,"CCR2",{"$f":"D7","v":6.73},{"$f":"P5","v":1.79},{"$f":"Q5","v":1.79},{"$f":"R5","v":2.77},2.0190000000000006,2.0190000000000006,1.79,1.79,5.7205000000000004,6.0570000000000004]
[null,null,"CCNR2",6.73,0.13,null,{"$f":"B21","v":"GTL"},0.1,0.7]
[null,null,"Stage V",{"$f":"'Key Data'!B31","v":1.79},1.4999999999999999E-2,null,null,null,null,null,null,null,null,"PM"]
[null,null,"Euro VI",0.4,0.01,null,null,null,null,null,null,null,null,"Engine type","Revision","Stage V","LNG mono fuel","LNG Dual fuel refit","SCR","SCR + DPF","Diesel electric","Battery electric","FWE","GTL"]
[null,"SCR/DPF",{"$f":"C5","v":"CCNRO"},{"$f":"(1-$H$5)*D5","v":3.5400000000000009},{"$f":"(1-$I$5)*E5","v":3.9999999999999994E-2},null,null,null,null,null,null,null,null,"unregulated",{"$f":"E5","v":0.4},{"$f":"E8","v":1.4999999999999999E-2},{"$f":"E17","v":1.4999999999999999E-2},{"$f":"E16","v":1.4999999999999999E-2},{"$f":"E5","v":0.4},{"$f":"E10","v":3.9999999999999994E-2},{"$f":"P10","v":1.4999999999999999E-2},{"$f":"U10","v":1.4999999999999999E-2},{"$f":"E18","v":0.2},{"$f":"E21","v":0.12000000000000002}]
[null,null,{"$f":"C6","v":"CCNR1"},{"$f":"(1-$H$5)*D6","v":2.7600000000000002},{"$f":"(1-$I$5)*E6","v":1.2999999999999998E-2},null,null,null,null,null,null,null,null,"CCR1",{"$f":"E6","v":0.13},{"$f":"P10","v":1.4999999999999999E-2},{"$f":"Q10","v":1.4999999999999999E-2},{"$f":"R10","v":1.4999999999999999E-2},{"$f":"E6","v":0.13},{"$f":"E11","v":1.2999999999999998E-2},{"$f":"P11","v":1.4999999999999999E-2},{"$f":"U11","v":1.4999999999999999E-2},{"$f":"E19","v":6.5000000000000002E-2},{"$f":"E22","v":3.9000000000000007E-2}]
[null,null,"CCNR2",{"$f":"(1-$H$5)*D7","v":2.0190000000000006},{"$f":"(1-$I$5)*E7","v":1.2999999999999998E-2},null,null,null,null,null,null,null,null,"CCR2",{"$f":"E7","v":0.13},{"$f":"P11","v":1.4999999999999999E-2},1.4999999999999999E-2,1.4999999999999999E-2,{"$f":"E7","v":0.13},{"$f":"E12","v":1.2999999999999998E-2},1.4999999999999999E-2,1.4999999999999999E-2,{"$f":"E20","v":6.5000000000000002E-2},{"$f":"E23","v":3.9000000000000007E-2}]
[null,"SCR",{"$f":"C10","v":"CCNRO"}]
[null,null,{"$f":"C11","v":"CCNR1"},null,null,null,null,null,"min","average","max"]
[null,null,"CCNR2",null,null,null,null,"Diesel",{"$f":"E7","v":0.13},{"$f":"AVERAGE(I15,K15)","v":0.26500000000000001},{"$f":"E5","v":0.4}]
[null,"LNG","Existing",2.77,1.4999999999999999E-2,null,null,"GTL",{"$f":"E23","v":3.9000000000000007E-2},{"$f":"AVERAGE(I16,K16)","v":7.9500000000000015E-2},{"$f":"E21","v":0.12000000000000002}]
[null,null,"Stage V",{"$f":"D8","v":1.79},{"$f":"E8","v":1.4999999999999999E-2},null,null,"FWE",{"$f":"E20","v":6.5000000000000002E-2},{"$f":"AVERAGE(I17,K17)","v":0.13250000000000001},{"$f":"E18","v":0.2}]
[null,"FWE",{"$f":"C5","v":"CCNRO"},{"$f":"(1-H$6)*D5","v":10.030000000000001},0.2,null,null,"LNG",{"$f":"E16","v":1.4999999999999999E-2},1.4999999999999999E-2,{"$f":"E16","v":1.4999999999999999E-2}]
[null,null,{"$f":"C6","v":"CCNR1"},7.8199999999999994,6.5000000000000002E-2,null,null,"SCR-DPF",{"$f":"E12","v":1.2999999999999998E-2},2.6499999999999996E-2,{"$f":"E10","v":3.9999999999999994E-2}]
[null,null,{"$f":"C7","v":"CCNR2"},5.7205000000000004,6.5000000000000002E-2,null,null,"Euro VI",{"$f":"E9","v":0.01},0.01,{"$f":"E9","v":0.01}]
[null,"GTL",{"$f":"C18","v":"CCNRO"},{"$f":"(1-H$7)*D5","v":10.620000000000001},0.12000000000000002]
[null,null,{"$f":"C19","v":"CCNR1"},8.2799999999999994,3.9000000000000007E-2,null,null,null,{"$f":"J15-I15","v":0.13500000000000001},null,{"$f":"K15-J15","v":0.13500000000000001}]
[null,null,"CCNR2",6.0570000000000004,3.9000000000000007E-2,null,null,null,{"$f":"J16-I16","v":4.0500000000000008E-2},null,{"$f":"K16-J16","v":4.0500000000000008E-2}]
[null,null,null,null,null,null,null,null,6.7500000000000004E-2,null,6.7500000000000004E-2]
[null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,1.3499999999999998E-2,null,1.3499999999999998E-2]
[null,null,null,null,null,null,null,null,0,null,0]

{"sheet":"Ship segment (Data)","index":8,"n_rows":138,"n_cols":37,"rows_kept":138,"cut":false,"hidden":true,"merged":[[36,1,36,3],[35,13,35,15],[56,18,56,20],[56,21,56,23]]}
[null,"source: PROMINENT D2.2"]
["CE Delft Segment","Fleet family ","Vessel type ",null,"Length (m) ","Width (m) ","Draught (m) ","Max pay-load (t) ","Operational hours/year ","# en-gines ","Installed kW ","Fuel cons. (M3) ",null,"Average engine load",null,"Segment",null,null,"M3 / Kwh"]
[{"$f":"'Ship segment (Data)'!B85","v":"A1"},{"$f":"'Ship segment (Data)'!C85","v":"Passenger vessel <250 kW"},null,null,null,null,null,null,{"$f":"'Ship segment (Data)'!I85/0.5","v":1880},{"$f":"'Ship segment (Data)'!G85/'Ship segment (Data)'!F85","v":1.1621737623351607},{"$f":"'Ship segment (Data)'!J85","v":125.97336642465551},{"$f":"K3*I3*$S$3","v":10.650549831187348},null,{"$f":"(L3*'Key Data'!$B$43*1000/3.6)/K3/I3","v":0.44795412461794071},null,null,null,null,{"$f":"SUM(L8:L34)/SUMPRODUCT($K$8:$K$34,$I$8:$I$34)","v":4.4971300213741149E-5}]
[{"$f":"'Ship segment (Data)'!B86","v":"A2"},{"$f":"'Ship segment (Data)'!C86","v":"Passenger vessel 250 - 500 kW"},null,null,null,null,null,null,{"$f":"'Ship segment (Data)'!I86/0.5","v":1390},{"$f":"'Ship segment (Data)'!G86/'Ship segment (Data)'!F86","v":1.5065407863157894},{"$f":"'Ship segment (Data)'!J86","v":429.4484210526316},{"$f":"K4*I4*$S$3","v":26.844866878570265},null,{"$f":"(L4*'Key Data'!$B$43*1000/3.6)/K4/I4","v":0.44795412461794071},null,null,null,null,null,null,null,null,"Period","Scenario",null,"Vessel type","Fuel use",null,"ZE meenemen?","Afschrijving? "]
[{"$f":"'Ship segment (Data)'!B87","v":"A3"},{"$f":"'Ship segment (Data)'!C87","v":"Passenger vessel 500 - 1000 kW"},null,null,null,null,null,null,{"$f":"'Ship segment (Data)'!I87/0.5","v":1470},{"$f":"'Ship segment (Data)'!G87/'Ship segment (Data)'!F87","v":1.81586982473223},{"$f":"'Ship segment (Data)'!J87","v":693.02142161635834},{"$f":"K5*I5*$S$3","v":45.814129376912504},null,{"$f":"(L5*'Key Data'!$B$43*1000/3.6)/K5/I5","v":0.44795412461794071},null,null,null,null,null,null,null,null,15,{"$f":"Invoer_waarden!D41&Invoer_waarden!G41","v":"Motor vessels dry cargo 110 m shipnormal fuel use"},null,{"$f":"INDEX('Ship segment (Data)'!AC$85:AC$138,MATCH('Ship segment (Data)'!$X$5,scenario_names,0))","v":"Motor vessels dry cargo 110 m ship"},{"$f":"INDEX('Ship segment (Data)'!AD$85:AD$138,MATCH('Ship segment (Data)'!$X$5,scenario_names,0))","v":"normal fuel use"},null,"ja","met restwaarde"]
[{"$f":"'Ship segment (Data)'!B101","v":"N"},{"$f":"'Ship segment (Data)'!C101","v":"Ferry"},null,null,null,null,null,null,{"$f":"'Ship segment (Data)'!I101","v":750},{"$f":"'Ship segment (Data)'!G101/'Ship segment (Data)'!F101","v":2.1875},{"$f":"'Ship segment (Data)'!J101","v":644},{"$f":"K6*I6*$S$3","v":21.721138003236973},null,{"$f":"(L6*'Key Data'!$B$43*1000/3.6)/K6/I6","v":0.44795412461794065}]
[{"$f":"'Ship segment (Data)'!B102","v":"O"},{"$f":"'Ship segment (Data)'!C102","v":"tugboat and workboat"},null,null,null,null,null,null,{"$f":"'Ship segment (Data)'!I102","v":916},{"$f":"'Ship segment (Data)'!G102/'Ship segment (Data)'!F102","v":1.2489999999999999},{"$f":"'Ship segment (Data)'!J102","v":500},20.596855497893447,null,{"$f":"(L7*'Key Data'!$B$43*1000/3.6)/K7/I7","v":0.44795412461794071}]
["A4","Passenger vessels (hotel/cruise) ","PAX 135m ",null,135,11.5,2,"NA",4318,{"$f":"'Ship segment (Data)'!G88/'Ship segment (Data)'!F88","v":2.3901162222222223},{"$f":"'Ship segment (Data)'!J88","v":1492},433,null,{"$f":"(L8*'Key Data'!$B$43*1000/3.6)/K8/I8","v":0.66947525740011093},null,1,null,"a","Propulsion power 200-600"]
["B","Push boats <500 kW ","PB <500 kW B04 ",null,85,8.1999999999999993,2.7,1250,3360,{"$f":"'Ship segment (Data)'!G89/'Ship segment (Data)'!F89","v":1.1999999999999997},400,82,null,{"$f":"(L9*'Key Data'!$B$43*1000/3.6)/K9/I9","v":0.60773280423280418},null,1,null,"b","Propulsion power 600-1100"]
["C-1","Push boats 500-2000 kW ","PushB2L 500-2000kW ",null,190,11.4,3,"5000 / 352 TEU ",8064,2,1249,141,null,{"$f":"(L10*'Key Data'!$B$43*1000/3.6)/K10/I10","v":0.13944541876887753},null,2,null,"c","Propulsion power 1200-2200"]
["C-2","Push boats 500-2000 kW ","PushBII-1, 500-2000kW ",null,130,11.4,6,2800,4313,2,1249,178,null,{"$f":"(L11*'Key Data'!$B$43*1000/3.6)/K11/I11","v":0.32913661738056754},null,2,null,"d","Propulsion power 2600-4100"]
["C","Push boats 500-2000 kW ","Average of both C categories (B2L and BII-1)",null,{"$f":"AVERAGE(E10:E11)","v":160},{"$f":"AVERAGE(F10:F11)","v":11.4},{"$f":"AVERAGE(G10:G11)","v":4.5},2800,6188.5,2,1249,{"$f":"AVERAGE(L10:L11)","v":159.5},null,{"$f":"(L12*'Key Data'!$B$43*1000/3.6)/K12/I12","v":0.20554690859777133},null,2,null,"e","Coupled convoys (1750-2750 kW)"]
["D-1","Push boats >=2000 kW ","Push B4 > 2000 kW ",null,190,22.8,4,11200,8064,3,4080,1094,null,{"$f":"(L13*'Key Data'!$B$43*1000/3.6)/K13/I13","v":0.33121098748141237},null,4]
["D-2","Push boats >=2000 kW ","Push B6 > 2000 kW ",null,270,22.8,4,16800,8064,3,4080,2323,null,{"$f":"(L14*'Key Data'!$B$43*1000/3.6)/K14/I14","v":0.7032935319189404},null,4]
["D","Push boats >=2000 kW ","Average of both D categories (B4 and B6)",null,{"$f":"AVERAGE(E13:E14)","v":230},{"$f":"AVERAGE(F13:F14)","v":22.8},4,14000,8064,3,4080,{"$f":"AVERAGE(L13:L14)","v":1708.5},null,{"$f":"(L15*'Key Data'!$B$43*1000/3.6)/K15/I15","v":0.51725225970017641},null,4]
["H","Motor vessel dry cargo >=110m length ","MVS 110m ",null,110,11.4,3.5,3043,4318,1,1527,307,null,{"$f":"(L16*'Key Data'!$B$43*1000/3.6)/K16/I16","v":0.46378296861357216},null,3]
["I","Motor vessel dry cargo >=110m length ","MVS 135m ",null,135,11.4,3.3,"3300 / 268 TEU ",7898,2,1492,472,null,{"$f":"(L17*'Key Data'!$B$43*1000/3.6)/K17/I17","v":0.39898277056902076},null,3,null,null,"list","List2"]
["K","Motor vessel liquid cargo >=110m length ","MTS 110m ",null,110,11.4,3.5,2908,4318,1.1000000000000001,1550,355,null,{"$f":"(L18*'Key Data'!$B$43*1000/3.6)/K18/I18","v":0.52833832203612119},null,3,null,null,"HVO","_"]
["L-1","Motor vessel liquid cargo >=110m length ","MTS 135m (M11) ",null,135,11.4,4,"4290 (5320 m3) ",7898,2,2347,352,null,{"$f":"(L19*'Key Data'!$B$43*1000/3.6)/K19/I19","v":0.1891518268710512},null,3,null,null,"Diesel","Let op: HVO is een biodiesel met lagere CO2 uitstoot. Voor GTL en LNG zijn geen bio-varianten doorgerekend maar de reguliere fossiele varianten. "]
["L-2","Motor vessel liquid cargo >=110m length ","MTS 135M (M12) ",null,135,17,3.8,6228,7898,2,2370,352,null,{"$f":"(L20*'Key Data'!$B$43*1000/3.6)/K20/I20","v":0.18731617623053046},null,3]
["L","Motor vessel liquid cargo >=110m length ","Average of both L categories (M11 and M12)",null,{"$f":"AVERAGE(E19:E20)","v":135},{"$f":"AVERAGE(F19:F20)","v":14.2},{"$f":"AVERAGE(G19:G20)","v":3.9},6228,7898,2,{"$f":"AVERAGE(K19:K20)","v":2358.5},{"$f":"AVERAGE(L19:L20)","v":352},null,{"$f":"(L21*'Key Data'!$B$43*1000/3.6)/K21/I21","v":0.18822952625243045}]
["F-1","Motor vessel dry cargo 80-109m length ","MVS 80m ",null,80,8.1999999999999993,2.7,1250,3499,1,700,111,null,{"$f":"(L22*'Key Data'!$B$43*1000/3.6)/K22/I22","v":0.45141822833734813},null,"b"]
["F-2","Motor vessel dry cargo 80-109m length ","MVS 86m ",null,86,9.5,2.9,1522,3971,1.1000000000000001,756,155,null,{"$f":"(L23*'Key Data'!$B$43*1000/3.6)/K23/I23","v":0.51429003722016953},null,"b"]
["F","Motor vessel dry cargo 80-109m length ","Average of both F categories (80m and 86m)",null,{"$f":"AVERAGE(E22:E23)","v":83},{"$f":"AVERAGE(F22:F23)","v":8.85},2.8,1386,3735,1.05,728,{"$f":"AVERAGE(L22:L23)","v":133},null,{"$f":"(L24*'Key Data'!$B$43*1000/3.6)/K24/I24","v":0.48722296593782538}]
["G","Motor vessel dry cargo 80-109m length ","MVS 105m ",null,105,9.5,3,2050,4013,1.1000000000000001,1286,311,null,{"$f":"(L25*'Key Data'!$B$43*1000/3.6)/K25/I25","v":0.60027237381396226}]
["J","Motor vessel liquid cargo 80-109m length ","MTS 86m ",null,86,9.5,3.2,"1680 (1918m3) ",3971,1,1210,272,null,{"$f":"(L26*'Key Data'!$B$43*1000/3.6)/K26/I26","v":0.5638735746929241}]
["E-1","Motor vessels <80 m. length ","MVS 67m ",null,67,8.1999999999999993,2.7,985,3778,1.2,445,81,null,{"$f":"(L27*'Key Data'!$B$43*1000/3.6)/K27/I27","v":0.47991149231803282}]
["E-2","Motor vessels <80 m. length ","MVS 55m ",null,55,7.2,2.6,653,3874,1,319,48,null,{"$f":"(L28*'Key Data'!$B$43*1000/3.6)/K28/I28","v":0.38689136212857572}]
["E-3","Motor vessels <80 m. length ","MVS 50m ",null,50,6.6,2.6,650,3830,1,300,34,null,{"$f":"(L29*'Key Data'!$B$43*1000/3.6)/K29/I29","v":0.29475215162943624}]
["E-4","Motor vessels <80 m. length ","MVS 38,5m ",null,39,5.0999999999999996,2.5,400,3265,1,220,23,null,{"$f":"(L30*'Key Data'!$B$43*1000/3.6)/K30/I30","v":0.31894813371076774}]
["E","Motor vessels <80 m. length ","Average of four E categories (67, 55, 50, 38.5)",null,{"$f":"AVERAGE(E27:E30)","v":52.75},{"$f":"AVERAGE(F27:F30)","v":6.7750000000000004},2.6,672,3686.75,1.05,{"$f":"AVERAGE(K27:K30)","v":321},{"$f":"AVERAGE(L27:L30)","v":46.5},null,{"$f":"(L31*'Key Data'!$B$43*1000/3.6)/K31/I31","v":0.3913833329073178}]
["M","Coupled convoys ","C3L/B ",null,"110 + 80 ",11.4,3.4,5500,8064,2,2351,551,null,{"$f":"(L32*'Key Data'!$B$43*1000/3.6)/K32/I32","v":0.2894986523052594}]
[null,"Danube barges ","Push Barge, 4 units, Danube ",null,178,22.8,2.7,6400,8064,2,2000,1533,null,{"$f":"(L33*'Key Data'!$B$43*1000/3.6)/K33/I33","v":0.94680324074074074}]
[null,null,"Push Barge, 8/9 units, Danube ",null,267,33,2.9,17400,8064,2,2000,1252,null,{"$f":"(L34*'Key Data'!$B$43*1000/3.6)/K34/I34","v":0.77325352733686081}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"AIS data analyse"]
[null,"Not applicable anymore",null,null,null,null,null,null,null,{"$f":"I2","v":"Operational hours/year "},"Sailing hours (STC NESTRA)","AIS data Armin gemiddeld ",null,"Schip wat veel vaart (75%)","Mediaan schip","Onderkant van histogram (25%)",null,"PROMINENT"]
[null,"Prominent categories","Segment (CBA) (Not applicable anymore","Defintion (Propulsion power)",null,null,null,"A1","Passenger vessel <250 kW",{"$f":"INDEX($I$3:$I$32,MATCH(H38,$A$3:$A$32,0))","v":1880},{"$f":"'Ship segment (Data)'!I85","v":940},1601.1194332703828,null,2213.4699606222362,1073.1598682686633,418.27931185894067]
[null,"Passenger vessels (hotel/cruise) ","a","Propulsion power 200-600",null,null,null,"A2","Passenger vessel 250 - 500 kW",{"$f":"INDEX($I$3:$I$32,MATCH(H39,$A$3:$A$32,0))","v":1390},{"$f":"'Ship segment (Data)'!I86","v":695},1112.3619635828131,null,1370.5693822675255,694.19615339915947,310.6063801849765]
[null,"Push boats <500 kW ","a",null,null,null,null,"A3","Passenger vessel 500 - 1000 kW",1470,{"$f":"'Ship segment (Data)'!I87","v":735},1406.9096415374913,null,1731.2932675030058,1028.5146246206166,425.27966230569115]
[null,"Motor vessels <80 m. length ","a",null,null,null,null,"A4","Passenger vessel >1000 kW",4318,{"$f":"'Ship segment (Data)'!I88","v":1750},1772.1855580495958,null,2543.3775828389594,1436.5380508693474,770.08788286659671]
[null,"Push boats 500-2000 kW ","b","Propulsion power 600-1100",null,null,null,"B","Push boats <500 kW ",3360,{"$f":"'Ship segment (Data)'!I89","v":1420},2092.5719784462945,null,2831.3286511547303,1746.5391991796405,1100.9528910803365]
[null,"Motor vessel dry cargo 80-109m length ","b",null,null,null,null,"C","Push boats 500-2000 kW ",6188.5,{"$f":"'Ship segment (Data)'!I90","v":3000},2632.6750624173051,null,3509.2385387869294,2423.986016281558,1594.9399675920802]
[null,"Motor vessel liquid cargo 80-109m length ","b",null,null,null,null,"D","Push boats ≥2000 kW ",8064,{"$f":"'Ship segment (Data)'!I91","v":7258},6552.9977080414183,null,7354.0648008969274,7287.2414006769741,6683.1976474371195]
[null,"Motor vessel dry cargo >=110m length ","c","Propulsion power 1200-2200",null,null,null,"E","Motor vessels <80 m. length",3686.75,{"$f":"'Ship segment (Data)'!I92","v":1500},1922.9822813109663,null,2486.5939734473259,1776.4256233947808,1144.6091556374031]
[null,"Motor vessel dry cargo 80-109m length ","c",null,null,null,null,"F","Motor vessels dry cargo typical 80 and 86 m ship",3735,{"$f":"'Ship segment (Data)'!I93","v":1600},2254.5418208837077,null,2788.5844823950929,2183.9592655444512,1593.7714137217729]
[null,"Push boats >=2000 kW ","d","Propulsion power 2600-4100",null,null,null,"G","Motor vessels dry cargo typical 105 m ship",4013,{"$f":"'Ship segment (Data)'!I94","v":1886},2725.2561850071297,null,3359.7357383204885,2640.2289699503658,1932.9600451533991]
[null,"Coupled convoys ","e","Coupled convoys (1750-2750 kW)",null,null,null,"H","Motor vessels dry cargo 110 m ship",4318,{"$f":"'Ship segment (Data)'!I95","v":1943},2844.2739728193942,null,3473.1263320445264,2711.2283868243894,2076.8416447634158]
[null,null,null,null,null,null,null,"I","Motor vessels dry cargo >130 (135 m ship)",7898,{"$f":"'Ship segment (Data)'!I96","v":2831},2946.8447106055009,null,3563.6721968789507,2834.7264177280153,2377.0931386540319]
[null,null,null,null,null,null,null,"J","Motor vessels liquid cargo 80-109m length (typical 86 m ship)",3971,{"$f":"'Ship segment (Data)'!I97","v":1707},2793.6782446577163,null,3410.8410972436041,2875.1826543032398,2038.9190600453242]
[null,null,null,null,null,null,null,"K","Motor vessels liquid cargo 110 m ship",4318,{"$f":"'Ship segment (Data)'!I98","v":1943},2861.9497844289817,null,3824.6915698824055,2858.1950877305489,1781.6182264327851]
[null,null,null,null,null,null,null,"L","Motor vessels liquid cargo >130 (135 m ship)",7898,{"$f":"'Ship segment (Data)'!I99","v":2831},2118.9002786738492,null,2747.5999049320062,1754.5984380598293,1197.7068958850637]
[null,null,null,null,null,null,null,"M","Coupled convoys",8064,{"$f":"'Ship segment (Data)'!I100","v":2513},3294.9929297594335,null,4477.8837743554677,3146.4215986260306,2235.8815241528132]
[null,null,null,null,null,null,null,"N","Ferry",1200,{"$f":"'Ship segment (Data)'!I101","v":750},1388.9046102335437,null,1977.2794392123499,958.35658271647162,373.22366074338873]
[null,null,null,null,null,null,null,"O","tugboat and workboat",1600,{"$f":"'Ship segment (Data)'!I102","v":916},1634.0028123496725,null,2197.9011507642199,1077.1613648037035,455.12441838188283]
[]
[null,null,null,null,null,null,null,null,null,"Vaauren",null,null,"Operationele uren",null,null,"Brandstofverbruik",null,null,"idling costs per day",null,null,"Port dues per annum"]
[null,null,null,null,null,null,null,null,null,"high fuel use","normal fuel use","low fuel use","high fuel use","normal fuel use","low fuel use","high fuel use","normal fuel use","low fuel use","high fuel use","normal fuel use","low fuel use","high fuel use","normal fuel use","low fuel use"]
[null,null,null,null,null,null,null,"A1","Passenger vessel <250 kW",{"$f":"$K38/$O38*N38","v":1938.8180871333259},{"$f":"K38","v":940},{"$f":"$K38/$O38*P38","v":366.3783605528676},{"$f":"$N59-$K59+J59","v":2878.8180871333261},{"$f":"J38","v":1880},{"$f":"$N59-$K59+L59","v":1306.3783605528677},{"$f":"$Q59/$K59*J59","v":21.96753047938385},{"$f":"INDEX($L$3:$L$32,MATCH(H59,$A$3:$A$32,0))","v":10.650549831187348},{"$f":"$Q59/$K59*L59","v":4.1512031767415332},{"$f":"M59/$N59*T59","v":526.66906972218476},{"$f":"'Ship segment (Data)'!K85","v":343.93901285498328},{"$f":"O59/$N59*T59","v":238.99706582109826},{"$f":"M59/$N59*$W59","v":6464.5200958368796},{"$f":"'Ship segment (Data)'!L85","v":4221.6275611479723},{"$f":"O59/$N59*$W59","v":2933.5334532964307}]
[null,null,null,null,null,null,null,"A2","Passenger vessel 250 - 500 kW",1372.1564373581612,695,310.96604781160983,{"$f":"$N60-$K60+J60","v":2067.1564373581614},{"$f":"J39","v":1390},{"$f":"$N60-$K60+L60","v":1005.9660478116098},{"$f":"$Q60/$K60*J60","v":53.000513521515217},{"$f":"INDEX($L$3:$L$32,MATCH(H60,$A$3:$A$32,0))","v":26.844866878570265},12.011283679507599,{"$f":"M60/$N60*T60","v":1743.7019749305894},{"$f":"'Ship segment (Data)'!K86","v":1172.5023328428308},{"$f":"O60/$N60*T60","v":848.55937972647132},{"$f":"M60/$N60*$W60","v":21402.807011308403},{"$f":"'Ship segment (Data)'!L86","v":14391.703118385776},10415.514177899682]
[null,null,null,null,null,null,null,"A3","Passenger vessel 500 - 1000 kW",1237.2216409505024,735,303.9145426930445,{"$f":"$N61-$K61+J61","v":1972.2216409505024},1470,1038.9145426930445,77.118683437309258,45.814129376912504,18.943646501312028,2538.5618518922947,{"$f":"'Ship segment (Data)'!K87","v":1892.1229971308935},1337.2476859069627,31159.194738242601,{"$f":"'Ship segment (Data)'!L87","v":23224.578472398065},16413.845117612356]
[null,null,null,null,null,null,null,"A4","Passenger vessel >1000 kW",3098.3591191856203,1750,938.12606926839624,{"$f":"$N62-$K62+J62","v":5666.3591191856203},4318,3506.1260692683963,766.62257063278491,433,232.11919313898034,{"$f":"M62/$N62*T62","v":5345.5572584463098},{"$f":"'Ship segment (Data)'!K88","v":4073.5357142857142},3307.6261607116721,65613.236674219777,{"$f":"'Ship segment (Data)'!L88","v":50000},40598.958652945767]
[null,null,null,null,null,null,null,"B","Push boats <500 kW ",2301.9733462198633,1420,895.11481108949283,4241.9733462198637,3360,2835.1148110894928,132.93085520424563,82,51.68972852770311,292.13630348964222,{"$f":"'Ship segment (Data)'!K89","v":231.39654580807502},195.24874233792315,4223.0359652099532,{"$f":"'Ship segment (Data)'!L89","v":3345},2822.4580485399861]
[null,null,null,null,null,null,null,"C","Push boats 500-2000 kW ",4343.1420584308935,3000,1973.9469908808499,7531.6420584308935,6188.5,5162.4469908808496,230.91038610657583,{"$f":"INDEX($L$3:$L$32,MATCH(H64,$A$3:$A$32,0))","v":159.5},104.94818168183185,879.3537003203835,{"$f":"'Ship segment (Data)'!K90","v":722.53571428571433},602.73932681881411,63525.75269029932,{"$f":"'Ship segment (Data)'!L90","v":52197},43542.739853439074]
[null,null,null,null,null,null,null,"D","Push boats ≥2000 kW ",7324.5552589970966,7258,6656.380083771126,8130.5552589970966,8064,7462.380083771126,{"$f":"L14","v":2323},2100,1925.9297569467299,4443.9848009611005,{"$f":"'Ship segment (Data)'!K91","v":4407.6071428571431},4078.7747718185146,90575.434168743202,{"$f":"'Ship segment (Data)'!L91","v":89834},83131.8765433402]
[null,null,null,null,null,null,null,"E","Motor vessels <80 m. length",2099.6606393478501,1500,966.49908155178036,4286.4106393478505,3686.75,3153.2490815517804,{"$f":"L27","v":81},46.5,{"$f":"L30","v":23},269.84203940129368,{"$f":"'Ship segment (Data)'!K92","v":232.09165487562291},198.50621755540536,5813.2645817425246,{"$f":"'Ship segment (Data)'!L92","v":5000},4276.4617638187838]
[null,null,null,null,null,null,null,"F","Motor vessels dry cargo typical 80 and 86 m ship",2042.9571385434508,1600,1167.6198829281388,4177.957138543451,3735,3302.6198829281388,169.82081214142437,133,{"$f":"$Q67/$K67*L67","v":97.05840276840155},588.78840138517216,{"$f":"'Ship segment (Data)'!K93","v":526.3636285029703},465.42944716040432,8948.7703101332281,{"$f":"'Ship segment (Data)'!L93","v":8000},7073.8846220683035]
[null,null,null,null,null,null,null,"G","Motor vessels dry cargo typical 105 m ship",2399.9666978093805,1886,1380.7751852779058,4526.966697809381,4013,3507.7751852779056,395.75272694523716,311,227.68880308665362,1048.8988307512866,{"$f":"'Ship segment (Data)'!K94","v":929.81267342695025},812.75201166308625,12408.829722378068,{"$f":"'Ship segment (Data)'!L94","v":11000},9615.1325786336802]
[null,null,null,null,null,null,null,"H","Motor vessels dry cargo 110 m ship",2489.013650032874,1943,1488.367167954372,4864.0136500328736,4318,3863.3671679543722,393.27184279984164,307,235.16660862686163,868.85547872493851,{"$f":"'Ship segment (Data)'!K95","v":771.32142857142856},690.11067232110247,15770.30826782312,{"$f":"'Ship segment (Data)'!L95","v":14000},12525.970438017881]
[null,null,null,null,null,null,null,"I","Motor vessels dry cargo >130 (135 m ship)",3558.9875362470689,2831,2373.9683072919552,8625.9875362470684,7898,7440.9683072919552,593.37411413232655,472,395.80114483991622,1281.8218102962376,{"$f":"'Ship segment (Data)'!K96","v":1173.6428571428571},1105.7279442997694,29488.68871596238,{"$f":"'Ship segment (Data)'!L96","v":27000},25437.597404011496]
[null,null,null,null,null,null,null,"J","Motor vessels liquid cargo 80-109m length (typical 86 m ship)",2025.0211736220238,1707,1210.50912375541,4289.0211736220235,3971,3474.5091237554097,322.67472713836582,272,192.88721831369156,944.92679919984641,{"$f":"'Ship segment (Data)'!K97","v":874.86262429751935},765.47926722597128,9546.8794141639555,{"$f":"'Ship segment (Data)'!L97","v":8839},7733.8670724940985]
[null,null,null,null,null,null,null,"K","Motor vessels liquid cargo 110 m ship",2600.0239634384579,1943,1211.1434341270008,4975.0239634384579,4318,3586.1434341270005,475.04297839457155,355,221.28456979674999,1691.6990768285739,{"$f":"'Ship segment (Data)'!K98","v":1468.2857142857142},1219.4263950227391,16130.23054380232,{"$f":"'Ship segment (Data)'!L98","v":14000},11627.144066182958]
[null,null,null,null,null,null,null,"L","Motor vessels liquid cargo >130 (135 m ship)",4433.182637198538,2831,1932.469645875176,{"$f":"$N73-$K73+J73","v":9500.1826371985371},7898,6999.469645875176,551.21168784665679,352,240.2788114970194,3354.0012806887758,{"$f":"'Ship segment (Data)'!K99","v":2788.3571428571427},2471.1346142425677,57737.24570594199,{"$f":"'Ship segment (Data)'!L99","v":48000},42539.192580654395]
[null,null,null,null,null,null,null,"M","Coupled convoys",3576.4189801739158,2513,1785.7652237861596,9127.4189801739158,8064,7336.7652237861594,784.16508478942603,551,391.5466129352065,1737.8687879847682,{"$f":"'Ship segment (Data)'!K100","v":1535.3928571428571},1396.9267012816697,36219.916587991727,{"$f":"'Ship segment (Data)'!L100","v":32000},29114.147713437142]
[null,null,null,null,null,null,null,"N","Ferry",1547.3985426236634,750,292.08099636996474,1997.3985426236634,1200,742.08099636996474,44.815009720448479,21.721138003236973,8.4591088403666141,775.03951034052989,{"$f":"'Ship segment (Data)'!K101","v":465.6293636757045},287.94558511298288,0,{"$f":"'Ship segment (Data)'!L101","v":0},0]
[null,null,null,null,null,null,null,"O","tugboat and workboat",1869.0583601342917,916,387.03018958888981,2553.0583601342914,{"$f":"J55","v":1600},1071.0301895888897,42.026992315300973,20.596855497893447,8.7026254238915595,576.85313453817344,{"$f":"'Ship segment (Data)'!K102","v":361.5134811146774},241.99490763574528,5337.4876341557529,{"$f":"'Ship segment (Data)'!L102","v":3345},2239.1224901092723]
[]
[]
[]
[]
[]
[]
[]
[null,"CE Delft Segment","Vessel class ","Propulsion power range (kW)","Corresponding PROMINENT Category (D3.5 table 4.2)","Number of vessels (Prominent & IVR based)","Number of engines (Prominent & IVR based)","Average total propulsion power (IVR based)","Sailing hours (STC Nestra)","kW according to Prominent ","Idling costs (€ per day)","Port dues (€ per annum)","Additional engine costs mono fuel LNG engine (compared to diesel) (€)","Additional engine costs dual fuel LNG engine (compared to diesel) (€)","Installation costs (tank above deck) (€)","Installation costs (tank below deck) (€)",null,null,"Idling cost per kW","Port dues","Additional engine costs mono fuel LNG engine (compared to diesel) (€)","Additional engine costs dual fuel LNG engine (compared to diesel) (€)","Installation costs (tank above deck) (€)","Installation costs (tank below deck) (€)",null,null,null,null,"Vessel type iteraties","Fuel use","Year","ZE meenemen","Afschrijving",null,null,"NPV","Fuel use"]
[null,"A1","Passenger vessel <250 kW",null,{"$f":"E89","v":"PB< 500 kW B04"},521,605.49253017661874,125.97336642465551,940,{"$f":"H85","v":125.97336642465551},{"$f":"S$88*$J85","v":343.93901285498328},4221.6275611479723,79915.40973253113,24316.574752212324,47493.310062914694,68390.366490597153,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AC85&AD85","v":"Passenger vessel <250 kWnormal fuel use"},"Passenger vessel <250 kW","normal fuel use",15,"ja","zonder restwaarde",null,"Passenger vessel <250 kW",15,1]
[null,"A2","Passenger vessel 250 - 500 kW",null,{"$f":"E89","v":"PB< 500 kW B04"},227,341.98475849368418,429.4484210526316,695,{"$f":"H86","v":429.4484210526316},1172.5023328428308,14391.703118385776,272434.94003104279,82896.209961902074,161906.66008183997,233145.59051784957,null,null,null,null,null,null,null,null,null,null,null,"Passenger vessel 250 - 500 kWnormal fuel use","Passenger vessel 250 - 500 kW","normal fuel use",15,"nee","met restwaarde",null,"Passenger vessel 250 - 500 kW",null,0.43]
[null,"A3","Passenger vessel 500 - 1000 kW",null,null,60,108.95218948393381,693.02142161635834,735,{"$f":"H87","v":693.02142161635834},1892.1229971308935,23224.578472398065,439641.27048249543,133773.57200101286,261276.50781447825,376238.17125284864,null,null,null,null,null,null,null,null,null,null,null,"Passenger vessel 500 - 1000 kWnormal fuel use","Passenger vessel 500 - 1000 kW","normal fuel use",15,null,null,null,"Passenger vessel 500 - 1000 kW",null,1.75]
[null,"A4","Passenger vessel >1000 kW",{"$f":"RIGHT(C88,8)","v":">1000 kW"},"PAX 135m",155,370.46801444444446,1518.851851851852,1750,1492,{"$f":"114059/4/7","v":4073.5357142857142},50000,946500,288000,562500,810000,null,"Passenger vessel",{"$f":"K88/$J88","v":2.7302518192263499},33.512064343163537,634.38337801608577,193.02949061662198,377.01072386058979,542.89544235924927,null,null,null,"Passenger vessel >1000 kWnormal fuel use","Passenger vessel >1000 kW","normal fuel use",15,null,null,null,"Passenger vessel >1000 kW"]
[null,"B","Push boats <500 kW ",{"$f":"RIGHT(C89,8)","v":"<500 kW "},"PB< 500 kW B04",155,185.99999999999997,247,1420,400,{"$f":"S90*$J89","v":231.39654580807502},3345,{"$f":"U90*$J89","v":286893.51481184951},{"$f":"V90*$J89","v":92233.787029623709},{"$f":"W90*$J89","v":174539.6317053643},{"$f":"X90*$J89","v":231385.10808646915},null,null,null,null,null,null,null,null,null,null,null,"Push boats <500 kW normal fuel use","Push boats <500 kW ","normal fuel use",15,null,null,null,"Push boats <500 kW "]
[null,"C","Push boats 500-2000 kW ",{"$f":"RIGHT(C90,8)","v":"2000 kW "},"Push B2L & Push BII-1",92,147.20000000000002,846.90068493150682,3000,1249,{"$f":"20231/4/7","v":722.53571428571433},52197,895825,288000,545000,722500,null,"Push boats",{"$f":"K90/$J90","v":0.57849136452018757},null,{"$f":"M90/$J90","v":717.23378702962373},230.58446757405926,436.34907926341072,578.46277021617288,null,null,null,"Push boats 500-2000 kW normal fuel use","Push boats 500-2000 kW ","normal fuel use",15,null,null,null,"Push boats 500-2000 kW "]
[null,"D","Push boats ≥2000 kW ",{"$f":"RIGHT(C91,8)","v":"2000 kW "},"Push B4 & Push B6",14,37.520000000000003,3458,7258,4080,{"$f":"123413/4/7","v":4407.6071428571431},89834,1920425,648000,690000,887500,null,null,{"$f":"K91/$J91","v":1.0802958683473389},null,470.69240196078431,158.8235294117647,169.11764705882354,217.52450980392157,null,null,null,"Push boats ≥2000 kW normal fuel use","Push boats ≥2000 kW ","normal fuel use",15,null,null,null,"Push boats ≥2000 kW "]
[null,"E","Motor vessels <80 m. length",null,"MVS 67, MVS 55, MVS 50 , MVS 38.5",1839,2022.9,302,1500,{"$f":"(445+319+300+220)/4","v":321},{"$f":"$J92*S$102","v":232.09165487562291},5000,{"$f":"$J92*U$102","v":175787.1519238023},52771.577873537259,103382.57409725094,134995.85360356505,null,null,null,null,null,null,null,null,null,null,null,"Motor vessels <80 m. lengthnormal fuel use","Motor vessels <80 m. length","normal fuel use",15,null,null,null,"Motor vessels <80 m. length"]
[null,"F","Motor vessels dry cargo typical 80 and 86 m ship",null,"MVS 80m & MVS 86m",853,929.84675725232921,669.18833853294188,1600,{"$f":"(700+756)/2","v":728},{"$f":"$J93*S$102","v":526.3636285029703},8000,398669.92710444878,119681.33548889446,234462.66025793983,306158.82063363038,null,null,null,null,null,null,null,null,null,null,null,"Motor vessels dry cargo typical 80 and 86 m shipnormal fuel use","Motor vessels dry cargo typical 80 and 86 m ship","normal fuel use",15,null,null,null,"Motor vessels dry cargo typical 80 and 86 m ship"]
[null,"G","Motor vessels dry cargo typical 105 m ship",null,"MVS 105m",288,322.78644182768232,962.86745992715419,1886,1286,{"$f":"$J94*S$102","v":929.81267342695025},11000,704243.85474769387,211415.10637186578,414174.42457652558,540824.51007534156,null,null,null,null,null,null,null,null,null,null,null,"Motor vessels dry cargo typical 105 m shipnormal fuel use","Motor vessels dry cargo typical 105 m ship","normal fuel use",15,null,null,null,"Motor vessels dry cargo typical 105 m ship"]
[null,"H","Motor vessels dry cargo 110 m ship",null,"MVS 110m",575,575,1415.5044401899988,1943,1527,{"$f":"21597/4/7","v":771.32142857142856},14000,807825,216000,532500,692500,null,null,{"$f":"K95/$J95","v":0.50512208812798198},9.1683038637851997,529.02750491159134,141.45383104125736,348.72298624754421,453.50360183366075,null,null,null,"Motor vessels dry cargo 110 m shipnormal fuel use","Motor vessels dry cargo 110 m ship","normal fuel use",15,null,null,null,"Motor vessels dry cargo 110 m ship"]
[null,"I","Motor vessels dry cargo >130 (135 m ship)",null,"MVS 135m",211,215.79895787096714,2455.9847956284639,2831,1492,{"$f":"32862/4/7","v":1173.6428571428571},27000,861500,288000,532500,692500,null,null,0.78662389888931439,18.096514745308312,577.41286863270773,193.02949061662198,356.9034852546917,464.142091152815,null,null,null,"Motor vessels dry cargo >130 (135 m ship)normal fuel use","Motor vessels dry cargo >130 (135 m ship)","normal fuel use",15,null,null,null,"Motor vessels dry cargo >130 (135 m ship)"]
[null,"J","Motor vessels liquid cargo 80-109m length (typical 86 m ship)",null,"MTS86 m",251,276.10000000000002,954,1707,1210,{"$f":"$J97*S$102","v":874.86262429751935},8839,{"$f":"$J97*U$102","v":662624.46675327339},{"$f":"$J97*V$102","v":198920.90101862952},{"$f":"$J97*W$102","v":389697.55345069669},{"$f":"$J97*X$102","v":508862.87495424825},null,null,null,null,null,null,null,null,null,null,null,"Motor vessels liquid cargo 80-109m length (typical 86 m ship)normal fuel use","Motor vessels liquid cargo 80-109m length (typical 86 m ship)","normal fuel use",15,null,null,null,"Motor vessels liquid cargo 80-109m length (typical 86 m ship)"]
[null,"K","Motor vessels liquid cargo 110 m ship",null,"MTS 110m",391,519.48699615312785,1597.6670895333043,1943,1550,{"$f":"41112/4/7","v":1468.2857142857142},14000,871000,216000,507500,667500,null,null,{"$f":"K98/$J98","v":0.94728110599078341},9.0322580645161299,561.93548387096769,139.35483870967741,327.41935483870969,430.64516129032256,null,null,null,"Motor vessels liquid cargo 110 m shipnormal fuel use","Motor vessels liquid cargo 110 m ship","normal fuel use",15,null,null,null,"Motor vessels liquid cargo 110 m ship"]
[null,"L","Motor vessels liquid cargo >130 (135 m ship)",null,"MTS 135 M11& MTS 135 M12",91,182.13638792534056,2772.0478784532033,2831,{"$f":"(2347+2370)/2","v":2358.5},{"$f":"((71459/4/7)+(84689/4/7))/2","v":2788.3571428571427},48000,1085000,432000,{"$f":"(570000+575000)/2","v":572500},{"$f":"(742500+747500)/2","v":745000},null,null,null,null,null,null,null,null,null,null,null,"Motor vessels liquid cargo >130 (135 m ship)normal fuel use","Motor vessels liquid cargo >130 (135 m ship)","normal fuel use",15,null,null,null,"Motor vessels liquid cargo >130 (135 m ship)"]
[null,"M","Coupled convoys",null,"C3L/B",143,278.84999999999997,2237,2513,2351,{"$f":"42991/4/7","v":1535.3928571428571},32000,1227500,432000,600000,785000,null,null,{"$f":"K100/$J100","v":0.65308075590933945},13.611229264142917,522.1182475542322,183.75159506592939,255.21054870267972,333.90046788600597,null,null,null,"Coupled convoysnormal fuel use","Coupled convoys","normal fuel use",15,null,null,null,"Coupled convoys"]
[null,"N","Ferry",null,{"$f":"E93","v":"MVS 80m & MVS 86m"},618,1351.875,644,750,{"$f":"H101","v":644},{"$f":"S$102*$J101","v":465.6293636757045},0,{"$f":"U$102*$J101","v":352669.55090008932},105871.95062479125,207409.2763820237,270832.80286821147,null,null,null,null,null,null,null,null,null,null,null,"Ferrynormal fuel use","Ferry","normal fuel use",15,null,null,null,"Ferry"]
[null,"O","tugboat and workboat",null,{"$f":"E86","v":"PB< 500 kW B04"},480,599.52,500,916,{"$f":"H102","v":500},{"$f":"S$102*$J102","v":361.5134811146774},{"$f":"L89","v":3345},273811.7631211874,82198.71942918576,161032.04688045318,210273.91527035052,null,"Gemiddelde",{"$f":"AVERAGE(S95:S100)","v":0.72302696222935481},12.47707648443814,547.62352624237474,164.39743885837152,322.06409376090636,420.54783054070106,null,null,null,"tugboat and workboatnormal fuel use","tugboat and workboat","normal fuel use",15,null,null,null,"tugboat and workboat"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Passenger vessel <250 kWlow fuel use","Passenger vessel <250 kW","low fuel use",15]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Passenger vessel 250 - 500 kWlow fuel use","Passenger vessel 250 - 500 kW","low fuel use",15]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Passenger vessel 500 - 1000 kWlow fuel use","Passenger vessel 500 - 1000 kW","low fuel use",15]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Passenger vessel >1000 kWlow fuel use","Passenger vessel >1000 kW","low fuel use",15]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Push boats <500 kW low fuel use","Push boats <500 kW ","low fuel use",15]
[null,null,"Lifetime of engine (based on Nestra)",null,null,null,null,"Uit Engines database STC-NESTRA 2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Push boats 500-2000 kW low fuel use","Push boats 500-2000 kW ","low fuel use",15]
[null,null,null,null,null,null,null,null,null,"Time to revision",null,null,"life time in years",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Push boats ≥2000 kW low fuel use","Push boats ≥2000 kW ","low fuel use",15]
[null,"CE Delft Segment","Categories",null,"Dimensions","Loading capacity","Operational hrs (hrs/yr)","Effective (%)","Effecitve (hrs)","RPM < 750","RPM 750 - 125-","RPM >1250","RPM <750","RPM 750 - 1250","RPM >1250",null,null,null,null,null,null,null,null,null,null,null,null,"Motor vessels <80 m. lengthlow fuel use","Motor vessels <80 m. length","low fuel use",15]
[null,"E-1","38‐49 m",null,"38.8 x 5.05",380,3265,0.52,1697.8,null,null,null,67.10526315789474,55.921052631578945,44.736842105263158,null,null,null,null,null,null,null,null,null,null,null,null,"Motor vessels dry cargo typical 80 and 86 m shiplow fuel use","Motor vessels dry cargo typical 80 and 86 m ship","low fuel use",15]
[null,"E-2","50‐54",null,"50 x 6.6",520,3830,0.39,1493.7,null,null,null,75,62.5,50,null,null,null,null,null,null,null,null,null,null,null,null,"Motor vessels dry cargo typical 105 m shiplow fuel use","Motor vessels dry cargo typical 105 m ship","low fuel use",15]
[null,"E-3","55‐66",null,"55 x 7.2",700,3874,0.4,1549.6,null,null,null,75,62.5,50,null,null,null,null,null,null,null,null,null,null,null,null,"Motor vessels dry cargo 110 m shiplow fuel use","Motor vessels dry cargo 110 m ship","low fuel use",15]
[null,"E-4","67‐79",null,"67 x 8.2",910,3778,0.44,1662.32,null,null,null,70.833333333333329,59.027777777777779,47.222222222222221,null,null,null,null,null,null,null,null,null,null,null,null,"Motor vessels dry cargo >130 (135 m ship)low fuel use","Motor vessels dry cargo >130 (135 m ship)","low fuel use",15]
[null,"E","Average of the above 4 E categories",null,null,null,null,null,null,null,null,null,71.984649122807014,59.987207602339183,47.989766081871345,null,null,null,null,null,null,null,null,null,null,null,null,"Motor vessels liquid cargo 80-109m length (typical 86 m ship)low fuel use","Motor vessels liquid cargo 80-109m length (typical 86 m ship)","low fuel use",15]
[null,"F-1","80‐84",null,"80 x 8.2",1130,3499,0.44,1539.56,null,null,null,75,62.5,50,null,null,null,null,null,null,null,null,null,null,null,null,"Motor vessels liquid cargo 110 m shiplow fuel use","Motor vessels liquid cargo 110 m ship","low fuel use",15]
[null,"F-2","85‐86",null,"86 x 9.5",1600,3971,0.43,1707.53,null,null,null,67.10526315789474,55.921052631578945,44.736842105263158,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AC117&AD117","v":"Motor vessels liquid cargo >130 (135 m ship)low fuel use"},"Motor vessels liquid cargo >130 (135 m ship)","low fuel use",15]
[null,"F","Average of the above 2 F categories",null,null,null,null,null,null,null,null,null,71.05263157894737,59.210526315789473,47.368421052631575,null,null,null,null,null,null,null,null,null,null,null,null,"Coupled convoyslow fuel use","Coupled convoys","low fuel use",15]
[null,"J","85‐86",null,"86 x 9.5",1600,3971,0.43,1707.53,null,null,null,67.10526315789474,55.921052631578945,44.736842105263158,null,null,null,null,null,null,null,null,null,null,null,null,"Ferrylow fuel use","Ferry","low fuel use",15]
[null,"G","87‐109",null,"105 x 9.5",1910,4013,0.47,1886.11,null,null,null,53.125,44.270833333333336,35.416666666666664,null,null,null,null,null,null,null,null,null,null,null,null,"tugboat and workboatlow fuel use","tugboat and workboat","low fuel use",15]
[null,"H","110‐134",null,"110 x 11.4",3000,4318,0.45,1943.1,null,null,null,51,42.5,34,null,null,null,null,null,null,null,null,null,null,null,null,"Passenger vessel <250 kWhigh fuel use","Passenger vessel <250 kW","high fuel use",15]
[null,"K","110‐134",null,"110 x 11.4",3000,4318,0.45,1943.1,null,null,null,51,42.5,34,null,null,null,null,null,null,null,null,null,null,null,null,"Passenger vessel 250 - 500 kWhigh fuel use","Passenger vessel 250 - 500 kW","high fuel use",15]
[null,"I","135 or longer",null,"135 x 11,4",3920,6905,0.41,2831.05,null,null,null,41.12903225806452,34.274193548387096,27.419354838709676,null,null,null,null,null,null,null,null,null,null,null,null,"Passenger vessel 500 - 1000 kWhigh fuel use","Passenger vessel 500 - 1000 kW","high fuel use",15]
[null,"L","135 or longer",null,"135 x 11,4",3920,6905,0.41,2831.05,null,null,null,41.12903225806452,34.274193548387096,27.419354838709676,null,null,null,null,null,null,null,null,null,null,null,null,"Passenger vessel >1000 kWhigh fuel use","Passenger vessel >1000 kW","high fuel use",15]
[null,"M","Coupled convoys",null,"190 x 11.4",5300,6130,0.41,2513.3000000000002,null,null,null,38.636363636363633,32.196969696969695,25.757575757575758,null,null,null,null,null,null,null,null,null,null,null,null,"Push boats <500 kW high fuel use","Push boats <500 kW ","high fuel use",15]
[null,"C-1","Push boats 500 - 999 kW",null,"100 x 11.4",2450,6130,0.43,2635.9,null,null,null,43.96551724137931,36.637931034482762,29.310344827586206,null,null,null,null,null,null,null,null,null,null,null,null,"Push boats 500-2000 kW high fuel use","Push boats 500-2000 kW ","high fuel use",15]
[null,"C-2","Push boats 1000 - 1999 kW",null,"100 x 22.8",4900,7964,0.67,5335.88,null,null,null,21.610169491525422,18.008474576271187,14.40677966101695,null,null,null,null,null,null,null,null,null,null,null,null,"Push boats ≥2000 kW high fuel use","Push boats ≥2000 kW ","high fuel use",15]
[null,"C","Average of the above 2 C categories",null,null,null,null,null,null,null,null,null,32.787843366452364,27.323202805376972,21.858562244301577,null,null,null,null,null,null,null,null,null,null,null,null,"Motor vessels <80 m. lengthhigh fuel use","Motor vessels <80 m. length","high fuel use",15]
[null,"D","Push boats > 2000 kw",null,"195 x 22.8",9800,8064,0.9,7257.6,null,null,null,15.74074074074074,13.117283950617283,10.493827160493828,null,null,null,null,null,null,null,null,null,null,null,null,"Motor vessels dry cargo typical 80 and 86 m shiphigh fuel use","Motor vessels dry cargo typical 80 and 86 m ship","high fuel use",15]
[null,"B","Push boats <500 kW",null,null,null,null,null,null,null,null,null,85,70.833333333333329,56.666666666666664,null,null,null,null,null,null,null,null,null,null,null,null,"Motor vessels dry cargo typical 105 m shiphigh fuel use","Motor vessels dry cargo typical 105 m ship","high fuel use",15]
[null,"a1","PV<250",null,null,null,1000,0.8,1420,null,null,null,159.375,132.8125,106.25,null,null,null,null,null,null,null,null,null,null,null,null,"Motor vessels dry cargo 110 m shiphigh fuel use","Motor vessels dry cargo 110 m ship","high fuel use",15]
[null,"a2","PV 250-500",null,null,null,2000,0.8,940,null,null,null,79.6875,66.40625,53.125,null,null,null,null,null,null,null,null,null,null,null,null,"Motor vessels dry cargo >130 (135 m ship)high fuel use","Motor vessels dry cargo >130 (135 m ship)","high fuel use",15]
[null,"a3","PV 500 - 1000",null,null,null,3000,0.8,695,null,null,null,53.125,44.270833333333336,35.416666666666664,null,null,null,null,null,null,null,null,null,null,null,null,"Motor vessels liquid cargo 80-109m length (typical 86 m ship)high fuel use","Motor vessels liquid cargo 80-109m length (typical 86 m ship)","high fuel use",15]
[null,"a4","PV > 1000",null,null,null,4318,0.5,735,null,null,null,57.954545454545453,48.295454545454547,38.636363636363633,null,null,null,null,null,null,null,null,null,null,null,null,"Motor vessels liquid cargo 110 m shiphigh fuel use","Motor vessels liquid cargo 110 m ship","high fuel use",15]
[null,"O","Tugboat and workboat",null,null,null,null,null,1750,null,null,null,106.25,88.541666666666671,70.833333333333329,null,null,null,null,null,null,null,null,null,null,null,null,"Motor vessels liquid cargo >130 (135 m ship)high fuel use","Motor vessels liquid cargo >130 (135 m ship)","high fuel use",15]
[null,"N","Ferry",null,null,null,4000,0.6,916,null,null,null,53.125,44.270833333333336,35.416666666666664,null,null,null,null,null,null,null,null,null,null,null,null,"Coupled convoyshigh fuel use","Coupled convoys","high fuel use",15]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ferryhigh fuel use","Ferry","high fuel use",15]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"tugboat and workboathigh fuel use","tugboat and workboat","high fuel use",15]

{"sheet":"Shi Segment (Peter)","index":9,"n_rows":56,"n_cols":36,"rows_kept":56,"cut":false,"hidden":true,"merged":[]}
[]
["CE Delft Segment","Vessel class ","Propulsion power range (kW)","Corresponding PROMINENT Category (D3.5 table 4.2)","Number of vessels (Prominent & IVR based)","Number of engines (Prominent & IVR based)","Average total propulsion power (IVR based)","Sailing hours (STC Nestra)","kW according to Prominent ","Idling costs (€ per day)","Port dues (€ per annum)","Additional engine costs mono fuel LNG engine (compared to diesel) (€)","Additional engine costs dual fuel LNG engine (compared to diesel) (€)","Installation costs (tank above deck) (€)","Installation costs (tank below deck) (€)",null,null,"Idling cost per kW","Port dues","Additional engine costs mono fuel LNG engine (compared to diesel) (€)","Additional engine costs dual fuel LNG engine (compared to diesel) (€)","Installation costs (tank above deck) (€)","Installation costs (tank below deck) (€)",null,null,null,null,"Vessel type iteraties","Fuel use","Year","ZE meenemen","Afschrijving",null,null,"NPV","Fuel use"]
["A1","Passenger vessel <250 kW",null,{"$f":"D7","v":"PB< 500 kW B04"},521,605.49253017661874,125.97336642465551,940,{"$f":"G3","v":125.97336642465551},{"$f":"R$6*$I3","v":343.93901285498328},4221.6275611479723,79915.40973253113,24316.574752212324,47493.310062914694,68390.366490597153,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AB3&AC3","v":"Passenger vessel <250 kWnormal fuel use"},"Passenger vessel <250 kW","normal fuel use",15,"ja","zonder restwaarde",null,"Passenger vessel <250 kW",15,1]
["A2","Passenger vessel 250 - 500 kW",null,{"$f":"D7","v":"PB< 500 kW B04"},227,341.98475849368418,429.4484210526316,695,{"$f":"G4","v":429.4484210526316},1172.5023328428308,14391.703118385776,272434.94003104279,82896.209961902074,161906.66008183997,233145.59051784957,null,null,null,null,null,null,null,null,null,null,null,"Passenger vessel 250 - 500 kWnormal fuel use","Passenger vessel 250 - 500 kW","normal fuel use",15,"nee","met restwaarde",null,"Passenger vessel 250 - 500 kW",null,0.43]
["A3","Passenger vessel 500 - 1000 kW",null,null,60,108.95218948393381,693.02142161635834,735,{"$f":"G5","v":693.02142161635834},1892.1229971308935,23224.578472398065,439641.27048249543,133773.57200101286,261276.50781447825,376238.17125284864,null,null,null,null,null,null,null,null,null,null,null,"Passenger vessel 500 - 1000 kWnormal fuel use","Passenger vessel 500 - 1000 kW","normal fuel use",15,null,null,null,"Passenger vessel 500 - 1000 kW",null,1.75]
["A4","Passenger vessel >1000 kW",{"$f":"RIGHT(B6,8)","v":">1000 kW"},"PAX 135m",155,370.46801444444446,1518.851851851852,1750,1492,{"$f":"114059/4/7","v":4073.5357142857142},50000,946500,288000,562500,810000,null,"Passenger vessel",{"$f":"J6/$I6","v":2.7302518192263499},33.512064343163537,634.38337801608577,193.02949061662198,377.01072386058979,542.89544235924927,null,null,null,"Passenger vessel >1000 kWnormal fuel use","Passenger vessel >1000 kW","normal fuel use",15,null,null,null,"Passenger vessel >1000 kW"]
["B","Push boats <500 kW ",{"$f":"RIGHT(B7,8)","v":"<500 kW "},"PB< 500 kW B04",155,185.99999999999997,247,1420,400,{"$f":"R8*$I7","v":231.39654580807502},3345,{"$f":"T8*$I7","v":286893.51481184951},{"$f":"U8*$I7","v":92233.787029623709},{"$f":"V8*$I7","v":174539.6317053643},{"$f":"W8*$I7","v":231385.10808646915},null,null,null,null,null,null,null,null,null,null,null,"Push boats <500 kW normal fuel use","Push boats <500 kW ","normal fuel use",15,null,null,null,"Push boats <500 kW "]
["C","Push boats 500-2000 kW ",{"$f":"RIGHT(B8,8)","v":"2000 kW "},"Push B2L & Push BII-1",92,147.20000000000002,846.90068493150682,3000,1249,{"$f":"20231/4/7","v":722.53571428571433},52197,895825,288000,545000,722500,null,"Push boats",{"$f":"J8/$I8","v":0.57849136452018757},null,{"$f":"L8/$I8","v":717.23378702962373},230.58446757405926,436.34907926341072,578.46277021617288,null,null,null,"Push boats 500-2000 kW normal fuel use","Push boats 500-2000 kW ","normal fuel use",15,null,null,null,"Push boats 500-2000 kW "]
["D","Push boats ≥2000 kW ",{"$f":"RIGHT(B9,8)","v":"2000 kW "},"Push B4 & Push B6",14,37.520000000000003,3458,7258,4080,{"$f":"123413/4/7","v":4407.6071428571431},89834,1920425,648000,690000,887500,null,null,{"$f":"J9/$I9","v":1.0802958683473389},null,470.69240196078431,158.8235294117647,169.11764705882354,217.52450980392157,null,null,null,"Push boats ≥2000 kW normal fuel use","Push boats ≥2000 kW ","normal fuel use",15,null,null,null,"Push boats ≥2000 kW "]
["E","Motor vessels <80 m. length",null,"MVS 67, MVS 55, MVS 50 , MVS 38.5",1839,2022.9,302,1500,{"$f":"(445+319+300+220)/4","v":321},{"$f":"$I10*R$20","v":232.09165487562291},5000,{"$f":"$I10*T$20","v":175787.1519238023},52771.577873537259,103382.57409725094,134995.85360356505,null,null,null,null,null,null,null,null,null,null,null,"Motor vessels <80 m. lengthnormal fuel use","Motor vessels <80 m. length","normal fuel use",15,null,null,null,"Motor vessels <80 m. length"]
["F","Motor vessels dry cargo typical 80 and 86 m ship",null,"MVS 80m & MVS 86m",853,929.84675725232921,669.18833853294188,1600,{"$f":"(700+756)/2","v":728},{"$f":"$I11*R$20","v":526.3636285029703},8000,398669.92710444878,119681.33548889446,234462.66025793983,306158.82063363038,null,null,null,null,null,null,null,null,null,null,null,"Motor vessels dry cargo typical 80 and 86 m shipnormal fuel use","Motor vessels dry cargo typical 80 and 86 m ship","normal fuel use",15,null,null,null,"Motor vessels dry cargo typical 80 and 86 m ship"]
["G","Motor vessels dry cargo typical 105 m ship",null,"MVS 105m",288,322.78644182768232,962.86745992715419,1886,1286,{"$f":"$I12*R$20","v":929.81267342695025},11000,704243.85474769387,211415.10637186578,414174.42457652558,540824.51007534156,null,null,null,null,null,null,null,null,null,null,null,"Motor vessels dry cargo typical 105 m shipnormal fuel use","Motor vessels dry cargo typical 105 m ship","normal fuel use",15,null,null,null,"Motor vessels dry cargo typical 105 m ship"]
["H","Motor vessels dry cargo 110 m ship",null,"MVS 110m",575,575,1415.5044401899988,1943,1527,{"$f":"21597/4/7","v":771.32142857142856},14000,807825,216000,532500,692500,null,null,{"$f":"J13/$I13","v":0.50512208812798198},9.1683038637851997,529.02750491159134,141.45383104125736,348.72298624754421,453.50360183366075,null,null,null,"Motor vessels dry cargo 110 m shipnormal fuel use","Motor vessels dry cargo 110 m ship","normal fuel use",15,null,null,null,"Motor vessels dry cargo 110 m ship"]
["I","Motor vessels dry cargo >130 (135 m ship)",null,"MVS 135m",211,215.79895787096714,2455.9847956284639,2831,1492,{"$f":"32862/4/7","v":1173.6428571428571},27000,861500,288000,532500,692500,null,null,0.78662389888931439,18.096514745308312,577.41286863270773,193.02949061662198,356.9034852546917,464.142091152815,null,null,null,"Motor vessels dry cargo >130 (135 m ship)normal fuel use","Motor vessels dry cargo >130 (135 m ship)","normal fuel use",15,null,null,null,"Motor vessels dry cargo >130 (135 m ship)"]
["J","Motor vessels liquid cargo 80-109m length (typical 86 m ship)",null,"MTS86 m",251,276.10000000000002,954,1707,1210,{"$f":"$I15*R$20","v":874.86262429751935},8839,{"$f":"$I15*T$20","v":662624.46675327339},{"$f":"$I15*U$20","v":198920.90101862952},{"$f":"$I15*V$20","v":389697.55345069669},{"$f":"$I15*W$20","v":508862.87495424825},null,null,null,null,null,null,null,null,null,null,null,"Motor vessels liquid cargo 80-109m length (typical 86 m ship)normal fuel use","Motor vessels liquid cargo 80-109m length (typical 86 m ship)","normal fuel use",15,null,null,null,"Motor vessels liquid cargo 80-109m length (typical 86 m ship)"]
["K","Motor vessels liquid cargo 110 m ship",null,"MTS 110m",391,519.48699615312785,1597.6670895333043,1943,1550,{"$f":"41112/4/7","v":1468.2857142857142},14000,871000,216000,507500,667500,null,null,{"$f":"J16/$I16","v":0.94728110599078341},9.0322580645161299,561.93548387096769,139.35483870967741,327.41935483870969,430.64516129032256,null,null,null,"Motor vessels liquid cargo 110 m shipnormal fuel use","Motor vessels liquid cargo 110 m ship","normal fuel use",15,null,null,null,"Motor vessels liquid cargo 110 m ship"]
["L","Motor vessels liquid cargo >130 (135 m ship)",null,"MTS 135 M11& MTS 135 M12",91,182.13638792534056,2772.0478784532033,2831,{"$f":"(2347+2370)/2","v":2358.5},{"$f":"((71459/4/7)+(84689/4/7))/2","v":2788.3571428571427},48000,1085000,432000,{"$f":"(570000+575000)/2","v":572500},{"$f":"(742500+747500)/2","v":745000},null,null,null,null,null,null,null,null,null,null,null,"Motor vessels liquid cargo >130 (135 m ship)normal fuel use","Motor vessels liquid cargo >130 (135 m ship)","normal fuel use",15,null,null,null,"Motor vessels liquid cargo >130 (135 m ship)"]
["M","Coupled convoys",null,"C3L/B",143,278.84999999999997,2237,2513,2351,{"$f":"42991/4/7","v":1535.3928571428571},32000,1227500,432000,600000,785000,null,null,{"$f":"J18/$I18","v":0.65308075590933945},13.611229264142917,522.1182475542322,183.75159506592939,255.21054870267972,333.90046788600597,null,null,null,"Coupled convoysnormal fuel use","Coupled convoys","normal fuel use",15,null,null,null,"Coupled convoys"]
["N","Ferry",null,{"$f":"D11","v":"MVS 80m & MVS 86m"},618,1351.875,644,750,{"$f":"G19","v":644},{"$f":"R$20*$I19","v":465.6293636757045},0,{"$f":"T$20*$I19","v":352669.55090008932},105871.95062479125,207409.2763820237,270832.80286821147,null,null,null,null,null,null,null,null,null,null,null,"Ferrynormal fuel use","Ferry","normal fuel use",15,null,null,null,"Ferry"]
["O","tugboat and workboat",null,{"$f":"D4","v":"PB< 500 kW B04"},480,599.52,500,916,{"$f":"G20","v":500},{"$f":"R$20*$I20","v":361.5134811146774},{"$f":"K7","v":3345},273811.7631211874,82198.71942918576,161032.04688045318,210273.91527035052,null,"Gemiddelde",{"$f":"AVERAGE(R13:R18)","v":0.72302696222935481},12.47707648443814,547.62352624237474,164.39743885837152,322.06409376090636,420.54783054070106,null,null,null,"tugboat and workboatnormal fuel use","tugboat and workboat","normal fuel use",15,null,null,null,"tugboat and workboat"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Passenger vessel <250 kWlow fuel use","Passenger vessel <250 kW","low fuel use",15]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Passenger vessel 250 - 500 kWlow fuel use","Passenger vessel 250 - 500 kW","low fuel use",15]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Passenger vessel 500 - 1000 kWlow fuel use","Passenger vessel 500 - 1000 kW","low fuel use",15]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Passenger vessel >1000 kWlow fuel use","Passenger vessel >1000 kW","low fuel use",15]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Push boats <500 kW low fuel use","Push boats <500 kW ","low fuel use",15]
[null,"Lifetime of engine (based on Nestra)",null,null,null,null,"Uit Engines database STC-NESTRA 2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Push boats 500-2000 kW low fuel use","Push boats 500-2000 kW ","low fuel use",15]
[null,null,null,null,null,null,null,null,"Time to revision",null,null,"life time in years",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Push boats ≥2000 kW low fuel use","Push boats ≥2000 kW ","low fuel use",15]
["CE Delft Segment","Categories",null,"Dimensions","Loading capacity","Operational hrs (hrs/yr)","Effective (%)","Effecitve (hrs)","RPM < 750","RPM 750 - 125-","RPM >1250","RPM <750","RPM 750 - 1250","RPM >1250",null,null,null,null,null,null,null,null,null,null,null,null,"Motor vessels <80 m. lengthlow fuel use","Motor vessels <80 m. length","low fuel use",15]
["E-1","38‐49 m",null,"38.8 x 5.05",380,3265,0.52,1697.8,null,null,null,67.10526315789474,55.921052631578945,44.736842105263158,null,null,null,null,null,null,null,null,null,null,null,null,"Motor vessels dry cargo typical 80 and 86 m shiplow fuel use","Motor vessels dry cargo typical 80 and 86 m ship","low fuel use",15]
["E-2","50‐54",null,"50 x 6.6",520,3830,0.39,1493.7,null,null,null,75,62.5,50,null,null,null,null,null,null,null,null,null,null,null,null,"Motor vessels dry cargo typical 105 m shiplow fuel use","Motor vessels dry cargo typical 105 m ship","low fuel use",15]
["E-3","55‐66",null,"55 x 7.2",700,3874,0.4,1549.6,null,null,null,75,62.5,50,null,null,null,null,null,null,null,null,null,null,null,null,"Motor vessels dry cargo 110 m shiplow fuel use","Motor vessels dry cargo 110 m ship","low fuel use",15]
["E-4","67‐79",null,"67 x 8.2",910,3778,0.44,1662.32,null,null,null,70.833333333333329,59.027777777777779,47.222222222222221,null,null,null,null,null,null,null,null,null,null,null,null,"Motor vessels dry cargo >130 (135 m ship)low fuel use","Motor vessels dry cargo >130 (135 m ship)","low fuel use",15]
["E","Average of the above 4 E categories",null,null,null,null,null,null,null,null,null,71.984649122807014,59.987207602339183,47.989766081871345,null,null,null,null,null,null,null,null,null,null,null,null,"Motor vessels liquid cargo 80-109m length (typical 86 m ship)low fuel use","Motor vessels liquid cargo 80-109m length (typical 86 m ship)","low fuel use",15]
["F-1","80‐84",null,"80 x 8.2",1130,3499,0.44,1539.56,null,null,null,75,62.5,50,null,null,null,null,null,null,null,null,null,null,null,null,"Motor vessels liquid cargo 110 m shiplow fuel use","Motor vessels liquid cargo 110 m ship","low fuel use",15]
["F-2","85‐86",null,"86 x 9.5",1600,3971,0.43,1707.53,null,null,null,67.10526315789474,55.921052631578945,44.736842105263158,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AB35&AC35","v":"Motor vessels liquid cargo >130 (135 m ship)low fuel use"},"Motor vessels liquid cargo >130 (135 m ship)","low fuel use",15]
["F","Average of the above 2 F categories",null,null,null,null,null,null,null,null,null,71.05263157894737,59.210526315789473,47.368421052631575,null,null,null,null,null,null,null,null,null,null,null,null,"Coupled convoyslow fuel use","Coupled convoys","low fuel use",15]
["J","85‐86",null,"86 x 9.5",1600,3971,0.43,1707.53,null,null,null,67.10526315789474,55.921052631578945,44.736842105263158,null,null,null,null,null,null,null,null,null,null,null,null,"Ferrylow fuel use","Ferry","low fuel use",15]
["G","87‐109",null,"105 x 9.5",1910,4013,0.47,1886.11,null,null,null,53.125,44.270833333333336,35.416666666666664,null,null,null,null,null,null,null,null,null,null,null,null,"tugboat and workboatlow fuel use","tugboat and workboat","low fuel use",15]
["H","110‐134",null,"110 x 11.4",3000,4318,0.45,1943.1,null,null,null,51,42.5,34,null,null,null,null,null,null,null,null,null,null,null,null,"Passenger vessel <250 kWhigh fuel use","Passenger vessel <250 kW","high fuel use",15]
["K","110‐134",null,"110 x 11.4",3000,4318,0.45,1943.1,null,null,null,51,42.5,34,null,null,null,null,null,null,null,null,null,null,null,null,"Passenger vessel 250 - 500 kWhigh fuel use","Passenger vessel 250 - 500 kW","high fuel use",15]
["I","135 or longer",null,"135 x 11,4",3920,6905,0.41,2831.05,null,null,null,41.12903225806452,34.274193548387096,27.419354838709676,null,null,null,null,null,null,null,null,null,null,null,null,"Passenger vessel 500 - 1000 kWhigh fuel use","Passenger vessel 500 - 1000 kW","high fuel use",15]
["L","135 or longer",null,"135 x 11,4",3920,6905,0.41,2831.05,null,null,null,41.12903225806452,34.274193548387096,27.419354838709676,null,null,null,null,null,null,null,null,null,null,null,null,"Passenger vessel >1000 kWhigh fuel use","Passenger vessel >1000 kW","high fuel use",15]
["M","Coupled convoys",null,"190 x 11.4",5300,6130,0.41,2513.3000000000002,null,null,null,38.636363636363633,32.196969696969695,25.757575757575758,null,null,null,null,null,null,null,null,null,null,null,null,"Push boats <500 kW high fuel use","Push boats <500 kW ","high fuel use",15]
["C-1","Push boats 500 - 999 kW",null,"100 x 11.4",2450,6130,0.43,2635.9,null,null,null,43.96551724137931,36.637931034482762,29.310344827586206,null,null,null,null,null,null,null,null,null,null,null,null,"Push boats 500-2000 kW high fuel use","Push boats 500-2000 kW ","high fuel use",15]
["C-2","Push boats 1000 - 1999 kW",null,"100 x 22.8",4900,7964,0.67,5335.88,null,null,null,21.610169491525422,18.008474576271187,14.40677966101695,null,null,null,null,null,null,null,null,null,null,null,null,"Push boats ≥2000 kW high fuel use","Push boats ≥2000 kW ","high fuel use",15]
["C","Average of the above 2 C categories",null,null,null,null,null,null,null,null,null,32.787843366452364,27.323202805376972,21.858562244301577,null,null,null,null,null,null,null,null,null,null,null,null,"Motor vessels <80 m. lengthhigh fuel use","Motor vessels <80 m. length","high fuel use",15]
["D","Push boats > 2000 kw",null,"195 x 22.8",9800,8064,0.9,7257.6,null,null,null,15.74074074074074,13.117283950617283,10.493827160493828,null,null,null,null,null,null,null,null,null,null,null,null,"Motor vessels dry cargo typical 80 and 86 m shiphigh fuel use","Motor vessels dry cargo typical 80 and 86 m ship","high fuel use",15]
["B","Push boats <500 kW",null,null,null,null,null,null,null,null,null,85,70.833333333333329,56.666666666666664,null,null,null,null,null,null,null,null,null,null,null,null,"Motor vessels dry cargo typical 105 m shiphigh fuel use","Motor vessels dry cargo typical 105 m ship","high fuel use",15]
["a1","PV<250",null,null,null,1000,0.8,1420,null,null,null,159.375,132.8125,106.25,null,null,null,null,null,null,null,null,null,null,null,null,"Motor vessels dry cargo 110 m shiphigh fuel use","Motor vessels dry cargo 110 m ship","high fuel use",15]
["a2","PV 250-500",null,null,null,2000,0.8,940,null,null,null,79.6875,66.40625,53.125,null,null,null,null,null,null,null,null,null,null,null,null,"Motor vessels dry cargo >130 (135 m ship)high fuel use","Motor vessels dry cargo >130 (135 m ship)","high fuel use",15]
["a3","PV 500 - 1000",null,null,null,3000,0.8,695,null,null,null,53.125,44.270833333333336,35.416666666666664,null,null,null,null,null,null,null,null,null,null,null,null,"Motor vessels liquid cargo 80-109m length (typical 86 m ship)high fuel use","Motor vessels liquid cargo 80-109m length (typical 86 m ship)","high fuel use",15]
["a4","PV > 1000",null,null,null,4318,0.5,735,null,null,null,57.954545454545453,48.295454545454547,38.636363636363633,null,null,null,null,null,null,null,null,null,null,null,null,"Motor vessels liquid cargo 110 m shiphigh fuel use","Motor vessels liquid cargo 110 m ship","high fuel use",15]
["O","Tugboat and workboat",null,null,null,null,null,1750,null,null,null,106.25,88.541666666666671,70.833333333333329,null,null,null,null,null,null,null,null,null,null,null,null,"Motor vessels liquid cargo >130 (135 m ship)high fuel use","Motor vessels liquid cargo >130 (135 m ship)","high fuel use",15]
["N","Ferry",null,null,null,4000,0.6,916,null,null,null,53.125,44.270833333333336,35.416666666666664,null,null,null,null,null,null,null,null,null,null,null,null,"Coupled convoyshigh fuel use","Coupled convoys","high fuel use",15]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ferryhigh fuel use","Ferry","high fuel use",15]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"tugboat and workboathigh fuel use","tugboat and workboat","high fuel use",15]