{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Goth Ghent (policy)","Goth - Ghent (RoRo measures)"],"not_rendered":{"charts":15,"images":1,"macros":1,"external_links":1,"defined_names":27,"comments":1,"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":"Goth Ghent (policy)","index":0,"n_rows":44,"n_cols":81,"rows_kept":44,"cut":false,"hidden":false,"merged":[[24,0,25,5],[0,75,0,79],[37,6,38,7],[39,6,40,7],[41,6,42,7],[27,0,29,0],[27,1,29,1],[27,2,29,2],[27,3,29,3],[27,4,29,4],[27,5,29,5],[5,71,5,72],[2,74,4,74],[5,74,7,74],[8,74,10,74],[10,0,11,0],[7,31,8,31],[7,32,8,32],[1,26,1,36],[6,26,6,36],[7,33,7,36],[10,7,11,7],[7,26,8,26],[7,27,8,27],[0,80,0,84],[10,29,11,29],[10,30,11,30],[10,31,11,31],[15,3,16,3],[10,33,10,36],[10,32,11,32],[10,1,11,1],[10,2,11,2],[10,3,11,3],[10,4,11,4],[10,5,11,5],[10,6,11,6],[10,15,11,15],[10,14,11,14],[10,16,11,16],[10,17,11,17],[10,18,11,18],[10,19,11,19],[10,20,11,20],[0,38,0,41],[3,31,4,31],[3,32,4,32],[3,33,3,36],[3,29,4,29],[3,30,4,30],[7,17,8,17],[7,18,8,18],[7,19,8,19],[7,20,8,20],[7,29,8,29],[7,30,8,30],[7,14,8,14],[3,15,4,15],[20,11,21,11],[7,15,8,15],[7,28,8,28],[10,13,11,13],[10,26,11,26],[10,27,11,27],[10,28,11,28],[0,67,0,74],[3,2,4,2],[3,3,4,3],[3,4,4,4],[3,5,4,5],[3,6,4,6],[3,7,4,7],[3,13,4,13],[7,2,8,2],[1,0,1,13],[6,0,6,13],[6,14,6,24],[3,0,4,0],[3,1,4,1],[7,0,8,0],[7,1,8,1],[7,3,8,3],[7,7,8,7],[7,4,8,4],[7,5,8,5],[7,6,8,6],[0,0,0,24],[5,0,5,24],[1,14,1,24],[32,1,54,5],[43,6,54,7],[0,63,0,65],[0,56,1,56],[0,57,0,59],[0,60,0,62],[0,47,1,47],[0,48,0,50],[0,52,0,54],[21,4,21,5],[20,4,20,5],[22,12,23,12],[3,20,4,20],[3,26,4,26],[3,27,4,27],[3,28,4,28],[3,16,4,16],[7,16,8,16],[3,17,4,17],[3,18,4,18],[3,19,4,19],[9,0,9,24],[7,13,8,13],[3,14,4,14]]}
["Baseline (2014)",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,null,null,null,null,null,null,null,null,null,null,"BAF CALCULATION AS A FUNCTION OF MGO PRICE (2015)",null,null,null,null,null,"External cost per kg",null,null,"Pollutant","2014 Handbook",null,null,null,"COWI/DTU study",null,null,null,"External cost ","2014 Handbook (EU)",null,null,"COWI/DTU study (DK)",null,null,"Present study (EU)",null,null,null,"Road Truck Emissions (taken from DESMO Cargo model)",null,null,null,null,null,null,null,"Total Emissions per mode",null,null,null,null,"Total Emissions per mode"]
["Option 1 (DFDS link)",null,null,null,null,null,null,null,null,null,null,null,null,null,"Option 2 (Other Maritime)",null,null,null,null,null,null,null,null,null,null,null,"Option 3 Road only",null,null,null,null,null,null,null,null,null,null,null,"MGO PRICE","FC1","FC2","FC3",null,"CO2","SO2","NOx","Total",null,"Low","Medium","High",null,"Low","Medium","High",null,null,"Low","Medium","High","Low","Medium","High","Low","Medium","High",null,null," CO2 emissions per lanemeter per km"," SOx emissions per lanemeter per km"," NOx emissions per lanemeter per km"," Particulate emissions per lanemeter per km",null,null,null,null," CO2","SO2","NOx","PM2.5"]
["Generalized Cost","Freight Rate (€/lm)","of which BAF","Road Cost (€/lm)","Road Distance (km)","Cargo Value (€/lm)","Depreciation Rate (%)","Total Time (hr)","Emissions (kg/lm)"," CO2","SO2","NOx","PM2.5","Transported lm/trip","GC","Freight Rate (€/lm)","Road Cost (€/lm)","Road Distance (km)","Cargo Value (€/lm)","Depreciation Rate (%)","Total Time","Emissions (kg/lm)"," CO2","SO2","NOx","PM2.5","GC","Road Cost","Road Distance","Cargo Value","Depreciation Rate","Total Time","Emissions (kg/lm)"," CO2","SO2","NOx","PM2.5",null,"ROUTE",422.39,604.02,231.88,null,0.09,10.241,10.64,null,"CO2",5.8900000000000001E-2,0.1104,0.20610000000000001,null,7.0000000000000001E-3,1.06E-2,1.06E-2,null,"Climate change",3.5999999999999997E-2,8.5900000000000004E-2,0.24279999999999999,6.8999999999999999E-3,1.0500000000000001E-2,1.0500000000000001E-2,6.8999999999999999E-3,8.5900000000000004E-2,0.24279999999999999,null,"EURO 4,5,6",72.900116822429908,1.1369325767690255E-2,0.3979264018691589,2.2738651535380507E-3,null,null,"Baseline","Option 1 (DFDS link)",{"$f":"J4+J5","v":48.136227018915392},{"$f":"K4+K5","v":5.5795514454192747E-3},5.2454103962569096E-2,5.3354090260644173E-4]
[{"$f":"B4+C8+D4*E4+H4*(F4*G4/(365*24))","v":74.076654373533728},50.171678535399998,0,{"$f":"0.0333333333333333","v":3.3333333333333298E-2},100,100000,4.4999999999999998E-2,{"$f":"577/'Goth - Ghent (RoRo measures)'!J6+E4/70+2+2","v":37.379444636011442},"Maritime (SOx, NOx, PM2.5 port only)",{"$f":"((('Goth - Ghent (RoRo measures)'!C9+'Goth - Ghent (RoRo measures)'!D9)*'Goth - Ghent (RoRo measures)'!G6/'Goth - Ghent (RoRo measures)'!A4)+('Goth - Ghent (RoRo measures)'!E9*'Goth - Ghent (RoRo measures)'!F6/'Goth - Ghent (RoRo measures)'!A4))*3.021*1000/N4","v":40.846215336672401},{"$f":"1000*('Goth - Ghent (RoRo measures)'!E9*'Goth - Ghent (RoRo measures)'!F6/'Goth - Ghent (RoRo measures)'!A4)*0.02/N4","v":4.4426188686502487E-3},{"$f":"1000*('Goth - Ghent (RoRo measures)'!E9*'Goth - Ghent (RoRo measures)'!F6/'Goth - Ghent (RoRo measures)'!A4)*0.057/N4","v":1.2661463775653208E-2},{"$f":"1000*('Goth - Ghent (RoRo measures)'!E9*'Goth - Ghent (RoRo measures)'!F6/'Goth - Ghent (RoRo measures)'!A4)*3.17/(2300*N4)","v":3.0615438725263664E-4},{"$f":"(3831+4650+3831)/3*F14","v":3421.4053578307617},{"$f":"P4+R4*Q4+U4*(S4*T4/(365*24))","v":72.836757990867554},40,{"$f":"D4","v":3.3333333333333298E-2},700,{"$f":"F4","v":100000},{"$f":"G4","v":4.4999999999999998E-2},{"$f":"R4/70+8.5","v":18.5},"Maritime (SOx, NOx, PM2.5 port only)",{"$f":"J4*300/577","v":21.237200348356534},{"$f":"K4*300/577","v":2.309853831187304E-3},{"$f":"L4*300/577","v":6.5830834188838165E-3},{"$f":"M4*300/577","v":1.5917905749703812E-4},{"$f":"AC4*AB4+AF4*(AD4*AE4/(365*24))","v":65.075016307892966},{"$f":"0.0333333333333333","v":3.3333333333333298E-2},1600,100000,{"$f":"G4","v":4.4999999999999998E-2},{"$f":"AC4/70","v":22.857142857142858},"Road (assuming Truck Euro 4-6)","No Maritime Emissions",null,null,null,null,"GOTH GHENT",{"$f":"0.0207*AN3-7.3736","v":1.3698730000000001},{"$f":"0.0207*AO3-7.3736","v":5.1296140000000001},{"$f":"0.0207*AP3-7.3736","v":-2.5736840000000001},null,null,null,null,null,"PM2.5",null,34.787500000000001,null,null,4.6390000000000002,52.353900000000003,1568.3829000000001,null,"Air Pollution ",1.2999999999999999E-3,8.9899999999999994E-2,0.48499999999999999,2.3999999999999998E-3,6.7699999999999996E-2,0.47860000000000003,1.2999999999999999E-3,8.9899999999999994E-2,0.48499999999999999,null,null,{"$f":"IF($A$28>70,BQ3,(($A$28/70)^0.4)*BQ3)","v":72.900116822429908},{"$f":"IF($A$28>70,BR3,(($A$28/70)^0.4)*BR3)","v":1.1369325767690255E-2},{"$f":"IF($A$28>70,BS3,(($A$28/70)^0.4)*BS3)","v":0.3979264018691589},{"$f":"IF($A$28>70,BT3,(($A$28/70)^0.4)*BT3)","v":2.2738651535380507E-3},null,null,null,"Option (Other Maritime)",{"$f":"W4+W5","v":72.267282124057473},{"$f":"X4+X5","v":1.0268381868570483E-2},0.28513156472729501,1.7508846649736734E-3]
[null,null,null,null,null,null,null,null,"Road (assuming Truck Euro 4-6)",{"$f":"$E$4*BQ3/1000","v":7.2900116822429908},{"$f":"$E$4*BR3/1000","v":1.1369325767690256E-3},3.979264018691589E-2,2.2738651535380509E-4,null,null,null,null,null,null,null,null,"Road (assuming Truck Euro 4-6)",{"$f":"$R$4*BQ3/1000","v":51.030081775700936},{"$f":"$R$4*BR3/1000","v":7.9585280373831793E-3},0.2785484813084112,1.5917056074766353E-3,null,null,null,null,null,null,null,{"$f":"$AC$4*BQ3/1000","v":116.64018691588785},{"$f":"$AC$4*BR3/1000","v":1.8190921228304409E-2},0.63668224299065423,3.6381842456608814E-3,null,"ESB IMMI",{"$f":"0.0171*AN3-6.0313","v":1.1915690000000003},{"$f":"0.0171*AO3-6.0313","v":4.2974420000000002},{"$f":"0.0171*AP3-6.0313","v":-2.0661519999999998},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,null,null,null,null,null,null,"Option 3 (Road Only)",{"$f":"AH5","v":116.64018691588785},{"$f":"AI5","v":1.8190921228304409E-2},0.63668224299065423,3.6381842456608814E-3]
["No policy applied (2015)",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,null,null,null,null,null,null,null,null,null,null,"ROT FELIX",{"$f":"0.0063*AN3-2.221","v":0.44005699999999992},{"$f":"0.0063*AO3-2.221","v":1.5843259999999999},{"$f":"0.0063*AP3-2.221","v":-0.76015600000000005},null,null,null,null,null,"NOx",null,7.5837000000000003,null,null,4.3E-3,7.0667999999999997,54.278100000000002,null,"Noise",5.0000000000000001E-4,0.1026,0.60419999999999996,7.1999999999999998E-3,1.44E-2,2.8899999999999999E-2,5.0000000000000001E-4,0.1026,0.60419999999999996,null,"Sea region (€/kg)","PM2.5","NOx","SO2","Present study (EU)",null,null,"No policy","Option 1 (DFDS link)",{"$f":"J8+J9","v":46.906803329535073},{"$f":"K8+K9","v":5.4458337720684497E-3},5.2073008593519252E-2,5.2432601076900448E-4]
[{"$f":"A2","v":"Option 1 (DFDS link)"},null,null,null,null,null,null,null,null,null,null,null,null,null,"Option 2 (Other Maritime)",null,null,null,null,null,null,null,null,null,null,null,"Option 3 Road only",null,null,null,null,null,null,null,null,null,null,null,"COP OSLO",{"$f":"0.0171*AN3-6.0313","v":1.1915690000000003},{"$f":"0.0171*AO3-6.0313","v":4.2974420000000002},{"$f":"0.0171*AP3-6.0313","v":-2.0661519999999998},null,null,null,null,null,"SO2",null,8.2432999999999996,null,null,1.4198999999999999,28.121400000000001,167.25659999999999,null,"Accidents ",2.5000000000000001E-3,1.52E-2,3.7999999999999999E-2,4.0300000000000002E-2,0.18390000000000001,0.24210000000000001,2.5000000000000001E-3,1.52E-2,0.24210000000000001,null,"Baltic Sea",17.476199999999999,5.952,6.6486000000000001,"CO2",null,null,null,"Option (Other Maritime)",{"$f":"W8+W9","v":71.628067034258351},{"$f":"X8+X9","v":1.0198857948284092E-2},0.28493342155447882,1.7460935600321983E-3]
[{"$f":"B8+D8*E8+H8*(F8*G8/(365*24))","v":69.885128322533731},47.3500254844,1.3698730000000001,{"$f":"D4","v":3.3333333333333298E-2},{"$f":"E4","v":100},{"$f":"F4","v":100000},4.4999999999999998E-2,{"$f":"577/'Goth - Ghent (RoRo measures)'!J6+E4/70+2+2","v":37.379444636011442},"Maritime (SOx, NOx, PM2.5 port only)",{"$f":"((('Goth - Ghent (RoRo measures)'!C9+'Goth - Ghent (RoRo measures)'!D9)*'Goth - Ghent (RoRo measures)'!G6/'Goth - Ghent (RoRo measures)'!A4)+('Goth - Ghent (RoRo measures)'!E9*'Goth - Ghent (RoRo measures)'!F6/'Goth - Ghent (RoRo measures)'!A4))*3.021*1000/N8","v":39.616791647292082},{"$f":"1000*('Goth - Ghent (RoRo measures)'!E9*'Goth - Ghent (RoRo measures)'!F6/'Goth - Ghent (RoRo measures)'!A4)*0.02/N8","v":4.3089011952994237E-3},{"$f":"1000*('Goth - Ghent (RoRo measures)'!E9*'Goth - Ghent (RoRo measures)'!F6/'Goth - Ghent (RoRo measures)'!A4)*0.057/N8","v":1.2280368406603358E-2},{"$f":"1000*('Goth - Ghent (RoRo measures)'!E9*'Goth - Ghent (RoRo measures)'!F6/'Goth - Ghent (RoRo measures)'!A4)*3.17/(2300*N8)","v":2.9693949541519939E-4},{"$f":"(3831+4650+3831)/3*F18","v":3527.5814670760292},{"$f":"P8+R8*Q8+U8*(S8*T8/(365*24))","v":72.836757990867554},{"$f":"P4","v":40},{"$f":"Q4","v":3.3333333333333298E-2},{"$f":"R4","v":700},{"$f":"S4","v":100000},4.4999999999999998E-2,{"$f":"R8/70+8.5","v":18.5},"Maritime (SOx, NOx, PM2.5 port only)",{"$f":"J8*300/577","v":20.597985258557408},{"$f":"K8*300/577","v":2.2403299109009134E-3},{"$f":"L8*300/577","v":6.3849402460676042E-3},{"$f":"M8*300/577","v":1.5438795255556294E-4},{"$f":"AC8*AB8+AF8*(AD8*AE8/(365*24))","v":65.075016307892966},{"$f":"0.0333333333333333","v":3.3333333333333298E-2},{"$f":"AC4","v":1600},{"$f":"AD4","v":100000},{"$f":"AE4","v":4.4999999999999998E-2},{"$f":"AC8/70","v":22.857142857142858},"Road (assuming Truck Euro 4-6)","No Maritime Emissions",null,null,null,null,"KLAI KIEL",{"$f":"0.0252*AN3-8.8806","v":1.7636280000000006},{"$f":"0.0252*AO3-8.8806","v":6.3407040000000006},{"$f":"0.0252*AP3-8.8806","v":-3.0372239999999993},null,{"$f":"$AR$3*J8","v":3.5655112482562874},{"$f":"$AS$3*K8","v":4.4127457141061394E-2},{"$f":"$AT$3*L8","v":0.13066311984625975},{"$f":"AR8+AS8+AT8","v":3.7403018252436087},"CO2",{"$f":"AW3*$J$8","v":2.3334290280255039},{"$f":"AX3*$J$8","v":4.373693797861046},{"$f":"AY3*$J$8","v":8.1650207585068983},null,{"$f":"BA3*$J$8","v":0.2773175415310446},{"$f":"BB3*$J$8","v":0.41993799146129607},{"$f":"BC3*$J$8","v":0.41993799146129607},null,"Congestion",0,0.51380000000000003,7.7744,1.95E-2,8.5599999999999996E-2,0.25130000000000002,0,0.51380000000000003,7.7744,null,"Black Sea",28.557200000000002,5.3189000000000002,10.0678,"Medium",null,null,null,"Option 3 (Road Only)",{"$f":"AH9","v":116.64018691588785},{"$f":"AI9","v":1.8190921228304409E-2},0.63668224299065423,3.6381842456608814E-3]
[null,null,null,null,null,null,null,null,"Road (assuming Truck Euro 4-6)",{"$f":"$E$8*BQ3/1000","v":7.2900116822429908},{"$f":"$E$8*BR3/1000","v":1.1369325767690256E-3},3.979264018691589E-2,2.2738651535380509E-4,null,null,null,null,null,null,null,null,"Road (assuming Truck Euro 4-6)",{"$f":"$R$8*BQ3/1000","v":51.030081775700936},{"$f":"$R$8*BR3/1000","v":7.9585280373831793E-3},0.2785484813084112,1.5917056074766353E-3,null,null,null,null,null,null,null,{"$f":"$AC$8*BQ3/1000","v":116.64018691588785},{"$f":"$AC$8*BR3/1000","v":1.8190921228304409E-2},0.63668224299065423,3.6381842456608814E-3,null,"KLAI KARLS",{"$f":"0.0145*AN3-5.1125","v":1.0121549999999999},{"$f":"0.0145*AO3-5.1125","v":3.6457900000000008},{"$f":"0.0145*AP3-5.1125","v":-1.7502399999999998},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,"Mediterranean Sea",23.4283,2.3428,8.4847999999999999,0.1104,null,null,"Policy","Option 1 (DFDS link)",{"$f":"J11+J12","v":48.063649043259311},{"$f":"K11+K12","v":8.4979721187388741E-3},6.0771602881529954E-2,7.3465815335477063E-4]
["Mitigate Modal Shift Via Policy (2015)",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,null,null,null,null,null,null,null,null,null,null,"DOV CAL",{"$f":"0.0048*AN3-1.6984","v":0.32907200000000003},{"$f":"0.0048*AO3-1.6984","v":1.2008959999999997},{"$f":"0.0048*AP3-1.6984","v":-0.58537600000000012},null,null,null,null,null,"PM2.5",null,{"$f":"AX4*$M$8","v":1.0329782696756249E-2},null,null,{"$f":"BA4*$M$8","v":1.3775023192311101E-3},{"$f":"BB4*$M$8","v":1.5545940649017808E-2},{"$f":"BC4*$M$8","v":0.46571482694382715},null,"Infrastructure",1.9E-2,6.59E-2,0.57110000000000005,3.7499999999999999E-2,0.15,0.22500000000000001,1.9E-2,6.59E-2,0.57110000000000005,null,"North Sea",32.673000000000002,7.5350000000000001,9.6245999999999992,null,null,null,null,"Option (Other Maritime)",{"$f":"W11+W12","v":72.229546608118426},{"$f":"X11+X12","v":1.1785758301838907E-2},0.28945608756211,1.8554516930923888E-3]
[{"$f":"B11+(-C28)+D28+(E28+F28)*E11+D11*E11+H11*(F11*G11/(365*24))+E11*E28","v":69.885128322533731},47.3500254844,1.3698730000000001,{"$f":"D4*(100+B28)/100","v":3.3333333333333298E-2},{"$f":"E4","v":100},{"$f":"F4","v":100000},4.4999999999999998E-2,{"$f":"577/'Goth - Ghent (RoRo measures)'!J17+E4/(IF(A28>70,70,A28))+2+2","v":37.379444636011442},"Maritime (SOx, NOx, PM2.5 port only)",{"$f":"((('Goth - Ghent (RoRo measures)'!C21+'Goth - Ghent (RoRo measures)'!D21)*'Goth - Ghent (RoRo measures)'!G6/'Goth - Ghent (RoRo measures)'!A22)+('Goth - Ghent (RoRo measures)'!E21*'Goth - Ghent (RoRo measures)'!F17/'Goth - Ghent (RoRo measures)'!A22))*3.021*1000/N11","v":40.77363736101632},{"$f":"1000*('Goth - Ghent (RoRo measures)'!E21*'Goth - Ghent (RoRo measures)'!F17/'Goth - Ghent (RoRo measures)'!A22)*0.02/N11","v":7.361039541969849E-3},{"$f":"1000*('Goth - Ghent (RoRo measures)'!E21*'Goth - Ghent (RoRo measures)'!F17/'Goth - Ghent (RoRo measures)'!A22)*0.057/N11","v":2.0978962694614068E-2},{"$f":"1000*('Goth - Ghent (RoRo measures)'!E21*'Goth - Ghent (RoRo measures)'!F17/'Goth - Ghent (RoRo measures)'!A22)*3.17/(2300*N11)","v":5.0727163800096554E-4},{"$f":"(3831+4650+3831)/3*((C22)/(C18/F18))","v":3527.5814670760292},{"$f":"P11+(-C28)*(300/577)+D28+E28*R11+R11*Q11+U11*(S11*T11/(365*24))+R11*E28+D28","v":72.836757990867554},40,{"$f":"D11","v":3.3333333333333298E-2},{"$f":"R4","v":700},100000,{"$f":"T4","v":4.4999999999999998E-2},{"$f":"R11/(IF(A28>70,70,A28))+8.5","v":18.5},"Maritime (SOx, NOx, PM2.5 port only)",{"$f":"J11*300/577","v":21.199464832417497},{"$f":"K11*300/577","v":3.8272302644557278E-3},{"$f":"L11*300/577","v":1.0907606253698823E-2},{"$f":"M11*300/577","v":2.6374608561575334E-4},{"$f":"AC11*AB11+AF11*(AD11*AE11/(365*24))+AC11*E28","v":65.075016307892966},{"$f":"D11","v":3.3333333333333298E-2},1600,100000,{"$f":"AE4","v":4.4999999999999998E-2},{"$f":"AC11/(IF(A28>70,70,A28))","v":22.857142857142858},"Road (assuming Truck Euro 4-6)","No Maritime Emissions",null,null,null,null,null,null,null,null,null,{"$f":"$AR$3*J11","v":3.6696273624914686},{"$f":"$AS$3*K11","v":7.5384405949313227E-2},{"$f":"$AT$3*L11","v":0.2232161630706937},{"$f":"AR11+AS11+AT11","v":3.9682279315114757},"NOx",null,{"$f":"AX6*$L$8","v":9.3130629885157898E-2},null,null,{"$f":"BA6*$L$8","v":5.2805584148394444E-5},{"$f":"BB6*$L$8","v":8.6782907455784611E-2},0.66655506441045775,null,"Total",5.9299999999999999E-2,0.87319999999999998,9.7155000000000005,0.1138,0.5121,1.2363,3.0200000000000001E-2,0.87319999999999998,9.9196000000000009,null,"North-East Atlantic",7.0285000000000002,2.8494000000000002,3.6724999999999999,null,null,null,null,"Option 3 (Road Only)",{"$f":"AH12","v":116.64018691588785},{"$f":"AI12","v":1.8190921228304409E-2},0.63668224299065423,3.6381842456608814E-3]
[null,null,null,null,null,null,null,null,"Road (assuming Truck Euro 4-6)",{"$f":"$E$11*BQ3/1000","v":7.2900116822429908},{"$f":"$E$11*BR3/1000","v":1.1369325767690256E-3},3.979264018691589E-2,2.2738651535380509E-4,null,null,null,null,null,null,null,null,"Road (assuming Truck Euro 4-6)",{"$f":"$R$11*BQ3/1000","v":51.030081775700936},{"$f":"$R$11*BR3/1000","v":7.9585280373831793E-3},0.2785484813084112,1.5917056074766353E-3,null,null,null,null,null,null,null,{"$f":"$AC$11*BQ4/1000","v":116.64018691588785},{"$f":"$AC$11*BR4/1000","v":1.8190921228304409E-2},0.63668224299065423,3.6381842456608814E-3,null,null,null,null,null,null,null,null,null,null,"SO2",null,{"$f":"AX7*$K$8","v":3.5519565223211737E-2},null,null,{"$f":"BA7*$K$8","v":6.1182088072056513E-3},{"$f":"BB7*$K$8","v":0.12117233407349322},0.72069216366171751,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,47.3500254844]
[" λ2 (Mar - Mar)",2.7199999999999998E-2,"λ1 (Mar - Land)",2.52E-2,null,"Utilization Rate",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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"('[1]Goth - Ghent'!$E$4,'[1]Goth - Ghent'!$D$4:$E$4)","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,{"$f":"SUM(BM3:BM10)","v":0.87329999999999997}]
[null,"SHARE option 1",{"$f":"(1-C16)*EXP(-A4*$B$13)/(EXP(-A4*$B$13)+EXP(-O4*$B$13))","v":0.29795737336417993},null,null,0.83367576945194,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total emissions",null,{"$f":"SUM(AX8:AX12)","v":4.5126737756661717},null,null,{"$f":"SUM(BA8:BA12)","v":0.28486605824162975},{"$f":"SUM(BB8:BB12)","v":0.6434391736395918},2.2729000464772984]
[null,"SHARE option 2",{"$f":"(1-C16)*EXP(-O4*$B$13)/(EXP(-A4*$B$13)+EXP(-O4*$B$13))","v":0.30817740748566896}]
[null,"SHARE option 3",{"$f":"EXP(-AA4*$D$13)/(EXP(-AA4*$D$13)+EXP((-(-1/$B$13)*LN((EXP(-$B$13*A4)+EXP(-$B$13*O4))))*$D$13))","v":0.3938652191501511},"Change in\n Market Share"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AX3*$J$11","v":4.5014095646562016}]
[null,"SHARE option 1",{"$f":"(1-C20)*EXP(-A8*$B$13)/(EXP(-A8*$B$13)+EXP(-O8*$B$13))","v":0.32182109931737196},{"$f":"(C18-$C$14)","v":2.3863725953192028E-2},null,0.85954714110039698,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AX4*$M$11","v":1.764671210695859E-2}]
[null,"SHARE option 2",{"$f":"(1-C20)*EXP(-O8*$B$13)/(EXP(-A8*$B$13)+EXP(-O8*$B$13))","v":0.29699386201860722},{"$f":"(C19-$C$15)","v":-1.118354546706174E-2},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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AX6*$L$11","v":0.15909815938714472}]
[null,"SHARE option 3",{"$f":"EXP(-AA8*$D$13)/(EXP(-AA8*$D$13)+EXP((-(-1/$B$13)*LN((EXP(-$B$13*A8)+EXP(-$B$13*O8))))*$D$13))","v":0.3811850386640207},{"$f":"(C20-$C$16)","v":-1.2680180486130399E-2},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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AX7*$K$11","v":6.0679257256320056E-2}]
[null,null,null,"Change in Market Share (Policy)","New Utilization Rate After Policy"]
[null,"SHARE option 1 NEW",{"$f":"(1-C24)*EXP(-A11*$B$13)/(EXP(-A11*$B$13)+EXP(-O11*$B$13))","v":0.32182109931737196},{"$f":"(C22-$C$14)","v":2.3863725953192028E-2},{"$f":"IF(((C22)/(C18/F18))>1,\"Will require additional sailings/bigger vessels\",(C22)/(C18/F18))","v":0.85954714110039698},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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AX17:AX20)","v":4.7388336934066242}]
[null,"SHARE option 2 NEW",{"$f":"(1-C24)*EXP(-O11*$B$13)/(EXP(-A11*$B$13)+EXP(-O11*$B$13))","v":0.29699386201860722},{"$f":"(C23-$C$15)","v":-1.118354546706174E-2}]
[null,"SHARE option 3 NEW",{"$f":"EXP(-AA11*$D$13)/(EXP(-AA11*$D$13)+EXP(-((-1/$B$13)*LN((EXP(-$B$13*A11)+EXP(-$B$13*O11))))*$D$13))","v":0.3811850386640207},{"$f":"(C24-$C$16)","v":-1.2680180486130399E-2}]
["Policy Options"]
[]
["Road speed limit","Tax Levy Road (%)","Pay BAF for shipper","Ext Cost Maritime (€/lm-trip)","Ext Cost Road (€/lm-km)","All External Road(€/lm-km)"]
[70,0,0,0,0,0]
[]
[]
[null,null,null,{"$f":"5.35709419137995/2","v":2.6785470956899751},{"$f":"0.8732/18/2","v":2.4255555555555555E-2},{"$f":"0.8732/18","v":4.8511111111111109E-2}]
[null,null,null,{"$f":"5.84/2","v":2.92}]
[null,"Instructions on Using this Software\n\nThis file allows the examination of the effects of a policy intervention to the Gothenburg - Ghent service. The User can select whether a speed limit on road is imposed, a tax levy (%) is added on the landbased components, the BAF is reimbursed to the shippers, or the external costs of transport are internalized  for maritime modes, or for both maritime and landbased modes. The level of internalization applies to all external costs as a percentage of the values used in the DTU study.  Any policy changes are then fed into the modal split model, which automatically calculates the new market shares of each option, and the new emissions per lanemeter of cargo for each of the three available options. The User needs to provide input in the yellow cells. The user can also change the sailing speed of Option 1 (DFDS), by adding extra hours in the sheet entitled \" Goth - Ghent (RoRo measures). Graphs are automatically created to show this difference. \n\nTo start testing the different policy measures, click on the button above.\n\nFor more information, read the Public report on Task 3.2 ----> \nShould you require to change more parameters, please contact either of the following DTU team members: \n\nHarilaos Psaraftis hnpsar@dtu.dk  \n Thalis Zis tzis@dtu.dk  "]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,"Low","Medium","High","Freight Rate (2015)"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,"Handbook","COWI/DTU ",null,null,"COWI/DTU study"]
[]
[]
[null,null,null,null,null,null,"LEGEND"]
[]
[null,null,null,null,null,null,"This means INPUT"]
[]
[null,null,null,null,null,null,"This means Result"]
[]
[null,null,null,null,null,null,"Link To Reports"]

{"sheet":"Goth - Ghent (RoRo measures)","index":1,"n_rows":27,"n_cols":13,"rows_kept":27,"cut":false,"hidden":false,"merged":[[0,0,0,11],[2,2,2,4],[9,2,9,6]]}
["BASELINE"]
["Ships Deployed",3]
["Sailings per Week",null,2014,null,null,null,{"$f":"32*2*A4/$B$2+2","v":130},"For brevik +2","Brevik always Begonia (NOW)"]
[6]
["ROUTE","SHIP","Average Fuel ME per hour SAILING per ship","Average Fuel AE per hour SAILING per ship","Average Fuel port per hour berth","HOURS BERTH PER WEEK","HOURS SAILING PER WEEK",null,"Sailing Distance","Sailing Speed"]
["Baseline","Ship A",2,0.18,0.25,38,130,null,{"$f":"((($A$4-1)*577*2)+580+577+116)/$B$2","v":2347.6666666666665},{"$f":"I6/G6","v":18.058974358974357}]
["GOTHENBURG GHENT","Ship B",2.1,0.15,0.27]
[null,"Ship C",1.87,0.15,0.18]
[null,"Ship D",1.93,0.17,0.12]
[null,"SHIP","WEEKLY FUEL CONSUMPTION"]
[null,"Magnolia",{"$f":"C6*$G$6/$B$2","v":86.666666666666671},7.8,{"$f":"E6*$F$6/$B$2","v":3.1666666666666665}]
["Baseline","Freesia",91,6.5,{"$f":"E7*$F$6/$B$2","v":3.4200000000000004}]
["Total Fuel Consumption WEEK","Primula",81.033333333333346,6.5,{"$f":"E8*$F$6/$B$2","v":2.2799999999999998}]
[null,"Petunia",83.63333333333334,7.3666666666666671,{"$f":"E9*$F$6/$B$2","v":1.5199999999999998}]
[null,"Average",{"$f":"AVERAGE(C11:C14)","v":85.583333333333343},{"$f":"AVERAGE(D11:D14)","v":7.041666666666667},{"$f":"#REF!*$F$6/$B$2","v":{"$error":"#REF!"}}]
["Slow Steaming extra 1 Hour","SHIP","ME Sailing","AE Sailing","AE+Boilers BERTH","NEW Hours berth per week","New Sailing Hours",null,null,"New Sailing Speed"]
["extra 1 hour","Ship A",{"$f":"C6*($J$17/$J$6)^$A$24","v":2},0.18,0.25,{"$f":"$G$6+$F$6-G17","v":38},{"$f":"($G$6/$A$4+A18)*A22","v":130},null,{"$f":"((($A$22-1)*577*2)+580+577+116)/$A$20","v":2347.6666666666665},{"$f":"I17/G17","v":18.058974358974357},null,{"$f":"F17/7","v":5.4285714285714288},{"$f":"G17/7","v":18.571428571428573}]
[0,"Ship B",{"$f":"C7*($J$17/$J$6)^$A$24","v":2.1},0.15,0.27,"New Idle Berth Hours if freq change"]
["Ships Deployed","Ship C",{"$f":"C8*($J$17/$J$6)^$A$24","v":1.87},0.15,0.18,{"$f":"IF(A22=A4,0,F17-$F$6)","v":0}]
[3,"Ship D",{"$f":"C9*($J$17/$J$6)^$A$24","v":1.93},0.17,0.12]
["New Sailings per Week","AVERAGE",{"$f":"AVERAGE(C17:C20)","v":1.9749999999999999},{"$f":"AVERAGE(D17:D20)","v":0.16250000000000001},0.20499999999999999]
[6,"SHIP","ME Sailing","AE Sailing","AE+Boilers BERTH"]
["Proposed Exponent","Ship A",{"$f":"C17*$G$17/$A$20","v":86.666666666666671},{"$f":"D17*$G$17/$A$20","v":7.8},{"$f":"E17*$F$17/$A$20","v":3.1666666666666665}]
[3.5,"Ship B",{"$f":"C18*$G$17/$A$20","v":91},6.5,{"$f":"E18*$F$17/$A$20","v":3.4200000000000004}]
[null,"Ship C",81.033333333333346,6.5,2.2799999999999998]
[null,"Ship D",83.63333333333334,7.3666666666666671,1.5199999999999998]
[null,"Total",{"$f":"AVERAGE(C23:C26)*$A$20","v":256.75},{"$f":"AVERAGE(D23:D26)*$A$20","v":21.125},7.79]