{"text_format":"2","workbook":"xlsx","n_sheets":7,"sheets":["Properties and Data","Cp calculations","Stabilization","Storage and transportation","Slurry hydrotreatment","CO2","Costs summary"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":"Properties and Data","index":0,"n_rows":69,"n_cols":8,"rows_kept":69,"cut":false,"hidden":false,"merged":[]}
[]
["Density and Specific Heat"]
["Property","Raw PO","Methanol ","Stabilized PO","H2","DOW","MoS2","Unit"]
["Density",1200,792,{"$f":"B4*0.85+C4*0.15","v":1138.8},8.9899999999999994E-2,null,4692,"kg/m3"]
["Cp",{"$f":"'Cp calculations'!E12","v":2302.0736319919997},2481.273408,{"$f":"B5*0.85+C5*0.15","v":2328.9535983931996},14400,{"$f":"'Properties and Data'!B61","v":2245.2857142857142},null,"J/kg/°C"]
[]
["Prices"]
["Item","Cost","Unit"]
["PO",6000,"SEK/t"]
["Methanol fossil",{"$f":"625*B37","v":7143.75},"SEK/t"]
["Methanol green",{"$f":"1193*B37","v":13635.99},"SEK/t"]
["Catalyst",{"$f":"2*B36*1000","v":21120},"SEK/t"]
["Electricity",386,"SEK/MWh"]
["H2 from SMR",{"$f":"3.76*B37*1000","v":42976.799999999996},"SEK/t"]
["H2 from electrolysis",{"$f":"6*B36*1000","v":63360},"SEK/t"]
["H2 from slurry",{"$f":"(3.76-2.81)*'Properties and Data'!B37*1000","v":10858.499999999996},"SEK/t"]
["Natural gas",{"$f":"B68*1000","v":5751.576},"SEK/t"]
["Biogas",{"$f":"16*1000","v":16000},"SEK/t"]
["Cooling water",0.2,"SEK/t"]
["Dowtherm",{"$f":"B48","v":281463.31426446437},"SEK/t"]
["Monthly salary shift worker",30000,"SEK/worker"]
[]
["Cost related data"]
["Operational days",340]
["CEPCI 2024",798]
["CEPCI 2004",457.4]
["Conversion (2024/2004)",{"$f":"B25/B26","v":1.7446436379536512},"https://www.chemengonline.com/pci-home "]
["Fees & contingency",1.1499999999999999,"https://www.exchangerates.org.uk/USD-SEK-spot-exchange-rates-history-2024.html"]
["Fauxilairy facilities",1.25]
["§",0.15]
["Plant life N (years)",15]
["Annuitiy factor fA",0.1710170526]
["Discount factor fd",{"$f":"1/B32","v":5.8473701002142056}]
[]
["Conversions"]
["$ to SEK",10.56]
["€ to SEK",11.43]
["gallon to m3",3.7854117800000002E-3]
[]
["Dowtherm price calculations"]
["Property","Value","Unit"]
["Price",5860,"$/barrel"]
["Volume",55,"gallon/barrel"]
[null,{"$f":"B43*B38","v":0.2081976479},"m3/barrel"]
["Density",1056,"kg/m3"]
["Weigth",{"$f":"B44*B45","v":219.85671618239999},"kg/barrel"]
["Price",{"$f":"B42/B46*1000","v":26653.722941710639},"$/t"]
[null,{"$f":"B47*B36","v":281463.31426446437},"SEK/t"]
[]
["Dowtherm Cp calculations"]
["Temperature","Specific heat (J/kg/°C)"]
[15,1558]
[65,1701]
[105,1814]
[155,1954]
[205,2093]
[255,2231]
[305,2373]
[355,2527]
[405,2725]
["Avg 105-350 °C",{"$f":"AVERAGE(B54:B60)","v":2245.2857142857142}]
[]
["Natural gas calculation"]
["Property","Value","Unit"]
["Price",37,"€/MWh"]
["Conversion",{"$f":"13.6/1000","v":1.3599999999999999E-2},"MWh/kg"]
["Euro per kg",{"$f":"B65*B66","v":0.50319999999999998},"€/kg"]
["SEK per kg",{"$f":"B67*B37","v":5.751576},"SEK/kg"]
["Energy content",13.6,"kWh/kg"]

{"sheet":"Cp calculations","index":1,"n_rows":12,"n_cols":5,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["Cp of PO"]
["Group","Compound","Wt% (dry basis)","Wt% (wet basis)","Cp (25°C) [J/kg/°C]"]
["Carboxylic acids","Acetic acid ",28,22.4,2051.666667]
["Phenol","Guaiacol",21,16,1849.6737290000001]
["Esters","Ethyl Acetate",14,11.2,1289.897843]
["Ketones","Acetone",12,9.6,2159.951791]
["Alcohols","Ethanol",8,6.4,2439.8503099999998]
["Sugars","Levoglucosan",9,7.2,1154.5577900000001]
["Aldehydes","Benzaldehyde",5,4,1620.777615]
["Furans","Furfural",4,3.2,1694.3401960000001]
["water ","H2O",0,20,4182]
[null,null,null,"Total Cp",{"$f":"(D3*E3+D4*E4+D5*E5+D6*E6+D7*E7+D8*E8+D9*E9+D10*E10+D11*E11)/100","v":2302.0736319919997}]

{"sheet":"Stabilization","index":2,"n_rows":13,"n_cols":6,"rows_kept":13,"cut":false,"hidden":false,"merged":[[8,0,8,5],[1,0,1,4]]}
[]
["OPERATIONAL COSTS"]
[]
["Feedstock","Annual requirement [t/y]","Cost per tonne [SEK/tonne]","Annual cost [SEK/y]","Cost per tonne GREEN [SEK/t]","Annual cost Green [SEK/y]"]
["Raw pyrolysis oil",{"$f":"B12*24*'Properties and Data'!B24","v":408000},{"$f":"'Properties and Data'!B9","v":6000},{"$f":"B5*C5","v":2448000000},{"$f":"Table49[[#This Row],[Cost per tonne '[SEK/tonne']]]","v":6000},{"$f":"Table49[[#This Row],[Annual requirement '[t/y']]]*Table49[[#This Row],[Cost per tonne GREEN '[SEK/t']]]","v":2448000000}]
["Methanol",{"$f":"C12*24*'Properties and Data'!B24","v":72000.000000000029},{"$f":"'Properties and Data'!B10","v":7143.75},{"$f":"B6*C6","v":514350000.00000018},{"$f":"'Properties and Data'!B11","v":13635.99},{"$f":"Table49[[#This Row],[Annual requirement '[t/y']]]*Table49[[#This Row],[Cost per tonne GREEN '[SEK/t']]]","v":981791280.00000036}]
[null,"Total costs raw material, reactants & catalyst",null,{"$f":"SUM(D2:D6)","v":2962350000},null,{"$f":"SUM(Table49[Annual cost Green '[SEK/y']])","v":3429791280.0000005}]
[]
["CALCULATIONS"]
["Specifications and calculations"]
["Property","PO","Methanol","Stabilized oil","Unit"]
["Mass flow",50,{"$f":"B12/(1-C13/100)-B12","v":8.8235294117647101},{"$f":"B12+C12","v":58.82352941176471},"t/h"]
["Percentage in stabilized oil",85,15,null,"wt%"]

{"sheet":"Storage and transportation","index":3,"n_rows":87,"n_cols":9,"rows_kept":87,"cut":false,"hidden":false,"merged":[[20,0,20,4],[1,0,1,4],[8,0,8,4],[10,2,10,3]]}
[]
["CAPITAL COSTS"]
["Equipment"]
["Item","Type [-]","Material [-]","Temperature [°C]","Pressure [bar]","Volume [m3]","Fbm [-]","Cp [$2004]","Cbm [$2004]"]
["Storage tank ","Process vessel, vertical","Stainless steel",25,1,{"$f":"B34","v":17355.730490299389},3.5,60000,{"$f":"G5*H5","v":210000}]
["Storage tank ","Process vessel, vertical","Stainless steel",25,1,{"$f":"F5","v":17355.730490299389},{"$f":"G5","v":3.5},60000,{"$f":"G6*H6","v":210000}]
[{"$nulls":6},"Total costs",{"$f":"SUM(Table63[Cp '[$2004']])","v":120000},{"$f":"SUM(Table63[Cbm '[$2004']])","v":420000}]
[]
["OPERATIONAL COSTS"]
[]
["Utilities"]
["Utility","Annual requirement [MWh/y]","Cost [SEK/MWh]","Annual cost [SEK/y]"]
["Electricity for heating",{"$f":"B47+B87","v":3047.268476379621},{"$f":"'Properties and Data'!B13","v":386},{"$f":"B13*C13","v":1176245.6318825337}]
[]
["Transportation"]
["Transportation","Annual requirement [t/y]","Cost [SEK/t]","Annual cost [SEK/y]"]
["Ship",{"$f":"B57","v":480000.00000000006},{"$f":"B58","v":633.6},{"$f":"B17*C17","v":304128000.00000006}]
[]
[]
[]
["CALCULATIONS"]
[]
["Storage at pyrolysis-site"]
["Storing while waiting for transportation to refinery"]
[]
["Storage tank"]
[]
["Specifications and calculations"]
["Property","Value","Unit"]
["Oil produced daily",{"$f":"Stabilization!D12*24","v":1411.7647058823532},"t/d"]
["Days capacity",14,"d"]
["Required storage capacity",{"$f":"B30*1000*B31/'Properties and Data'!D4","v":17355.730490299389},"m3"]
["Number of storage tanks",1,"units"]
["Volume of tanks",{"$f":"B32","v":17355.730490299389},"m3"]
["H/D",1.5,"-"]
["Height",{"$f":"B37*B35","v":36.771542215347374},"m"]
["Diameter",{"$f":"((4*B34)/(PI()*B35))^(1/3)","v":24.514361476898248},"m"]
["Surface Area",{"$f":"PI()*B37*B36+PI()*(B37/2)^2","v":3303.916727794714},"m2"]
["Heat transfer coefficient",2.1,"W/m2/°C"]
["Temperature",25,"°C"]
[]
["Heating"]
["Property","Value","Unit"]
["Days needing heating",183,"d"]
["Liquid temperature",25,"°C"]
["Outside temperature ",0,"°C"]
["Energy demand yearly",{"$f":"B39*B38*(B45-B46)*2*24*B44/(10^6)","v":1523.6342381898105},"MWh/y"]
[]
[]
["Transportation to refinery"]
["Transportation by boat to refinery"]
[]
["Shipping"]
[]
["Specifications and calculations"]
["Property","Value","Unit"]
["Annual production",{"$f":"Stabilization!D12*24*'Properties and Data'!B24","v":480000.00000000006},"t/y"]
["Price per tonne",{"$f":"(45+15)*'Properties and Data'!B36","v":633.6},"SEK/t"]
["Annual transportation cost",{"$f":"B57*B58","v":304128000.00000006},"SEK/y"]
[]
[]
["Storage at pyrolysis-site"]
["Storing while waiting for transportation to refinery"]
[]
["Storage tank"]
[]
["Specifications and calculations"]
["Property","Value","Unit"]
["Oil processed daily",{"$f":"Stabilization!D12*24","v":1411.7647058823532},"t/d"]
["Oil processed weekly",{"$f":"B69*7","v":9882.3529411764721},"t/w"]
["Days of inventory",14,"d"]
["Required storage capacity",{"$f":"B69*1000*B71/'Properties and Data'!D4","v":17355.730490299389},"m3"]
["Number of storage tanks",1,"units"]
["Volume of tanks",{"$f":"B72","v":17355.730490299389},"m3"]
["H/D",1.5,"-"]
["Height",{"$f":"B77*B75","v":36.771542215347374},"m"]
["Diameter",{"$f":"((4*B74)/(PI()*B75))^(1/3)","v":24.514361476898248},"m"]
["Surface Area",{"$f":"PI()*B77*B76+PI()*(B77/2)^2","v":3303.916727794714},"m2"]
["Heat transfer coefficient",2.1,"W/m2/°C"]
["Temperature",25,"°C"]
[]
["Heating"]
["Property","Value","Unit"]
["Days needing heating",183,"d"]
["Liquid temperature",25,"°C"]
["Outside temperature ",0,"°C"]
["Energy demand yearly",{"$f":"B79*B78*(B85-B86)*2*24*B84/(10^6)","v":1523.6342381898105},"MWh/y"]

{"sheet":"Slurry hydrotreatment","index":4,"n_rows":294,"n_cols":17,"rows_kept":294,"cut":false,"hidden":false,"merged":[[42,0,42,4],[1,0,1,4],[17,0,17,4],[19,2,19,3],[19,4,19,5]]}
[]
["CAPITAL COSTS"]
["Equipment"]
[]
["Item","Type","Material","Temperature [°C]","Pressure [bar]","Residence time [h]","Volumetric feed rate [m3/h]","Volume [m3]","H/D [-]","Height [m]","Diameter [m]","Heat exchanger area [m2]","Fp [-] ","Fm [-]","Fbm [-]","Cp [$2004]","Cbm [$2004]"]
["HEX1","Shell and tube","SS",{"$f":"$B$61","v":121.88648329681264},1,{"$nulls":6},{"$f":"$B$69","v":522.54613301345341},1,1.7,4,35000,{"$f":"P6*O6","v":140000}]
["Gas heater","Indirect fired non-reactive","SS",{"$f":"$B$90","v":400},1,{"$nulls":7},1,null,2.7,{"$f":"1.3*10^6","v":1300000},{"$f":"P7*O7*M7","v":3510000}]
["Slurry reactor","Process vessel, vertical","SS",400,100,1,null,{"$f":"$B$107","v":74.588317940453337},3,{"$f":"K8*I8","v":9.4901806714414434},{"$f":"((4*H8)/(PI()*I8))^(1/3)","v":3.1633935571471481},null,5,4,40,{"$f":"5.5*10^4","v":55000},{"$f":"O8*P8","v":2200000}]
["HEX 2","Shell and tube","SS",{"$f":"$C$173","v":202.27248306772927},100,{"$nulls":6},{"$f":"$B$181","v":1262.521577663063},1.1000000000000001,1.7,4.5,{"$f":"6*10^4","v":60000},{"$f":"P9*O9","v":270000}]
["HEX 3","Shell and tube","SS",{"$f":"$C$200","v":100},100,{"$nulls":6},{"$f":"$B$208","v":519.46794190214996},1.1000000000000001,1.7,4.5,35000,{"$f":"P10*O10","v":157500}]
["Flash","Process vessel, horizontal","SS",100,1,null,null,{"$f":"$B$238","v":3.2304201504025922},3,{"$f":"K11*I11","v":3.3327587672225589},{"$f":"((4*H11)/(PI()*I11))^(1/3)","v":1.1109195890741863},null,1,4,8.5,{"$f":"5*10^3","v":5000},{"$f":"O11*P11","v":42500}]
["Sedimentation disk centrifuge","Sedimentation disk centrifuge",null,100,1,null,{"$f":"$B$273","v":8.8427352668960166E-3},{"$nulls":7},3.4,180000,{"$f":"P12*O12","v":612000}]
["Decanter","Process vessel, horizontal","SS",100,1,0.1,null,{"$f":"$B$288","v":9.6726430298146688},3,{"$f":"K13*I13","v":4.8035899716005765},{"$f":"((4*H13)/(PI()*I13))^(1/3)","v":1.6011966572001921},null,1,4,8.5,10000,{"$f":"O13*P13","v":85000}]
[{"$nulls":14},"Total cost",{"$f":"SUM(P6:P12)","v":1670000},{"$f":"SUM(Q6:Q12)","v":6932000}]
[]
[]
[]
["OPERATIONAL COSTS"]
[]
["Utilities",null,"Fossil",null,"Green"]
["Property","Annual requirement [t/y]","Cost [SEK/t]","Yearly cost [SEK/y]","Cost green [SEK/t]","Yearly cost green [SEK/y]"]
["Methane (for heating)",{"$f":"B98+C98","v":18101.212284296671},{"$f":"'Properties and Data'!B17","v":5751.576},{"$f":"B22*C22","v":104110498.14526591},{"$f":"'Properties and Data'!B18","v":16000},{"$f":"B22*E22","v":289619396.54874676}]
["Cooling water",{"$f":"B213","v":866137.69984434801},{"$f":"'Properties and Data'!B19","v":0.2},{"$f":"B23*C23","v":173227.53996886962},{"$f":"C23","v":0.2},{"$f":"E23*B23","v":173227.53996886962}]
[null,"Total costs utilities",null,{"$f":"SUM(Table43[Yearly cost '[SEK/y']])","v":104283725.68523477},null,{"$f":"SUM(Table43[Yearly cost green '[SEK/y']])","v":289792624.08871561}]
[]
["Raw material, reactants, catalyst"]
["Feedstock","Annual requirement [t/y]","Cost per tonne [SEK/tonne]","Annual cost [SEK/y]","Cost per tonne [SEK/tonne]2","Annual cost [SEK/y]2"]
["Hydrogen from slurry CH4",{"$f":"B139","v":15600},{"$f":"'Properties and Data'!B16","v":10858.499999999996},{"$f":"Table445[[#This Row],[Annual requirement '[t/y']]]*Table445[[#This Row],[Cost per tonne '[SEK/tonne']]]","v":169392599.99999994},{"$f":"Table445[[#This Row],[Cost per tonne '[SEK/tonne']]]","v":10858.499999999996},{"$f":"Table445[[#This Row],[Annual cost '[SEK/y']]]","v":169392599.99999994}]
["Hydrogen from other source",{"$f":"B141","v":2639.9999999999995},{"$f":"'Properties and Data'!B14","v":42976.799999999996},{"$f":"Table445[[#This Row],[Annual requirement '[t/y']]]*Table445[[#This Row],[Cost per tonne '[SEK/tonne']]]","v":113458751.99999997},{"$f":"'Properties and Data'!B15","v":63360},{"$f":"Table445[[#This Row],[Annual requirement '[t/y']]]*Table445[[#This Row],[Cost per tonne '[SEK/tonne']2]]","v":167270399.99999997}]
["Catalyst",{"$f":"B150","v":15840.000000000002},{"$f":"'Properties and Data'!B12","v":21120},{"$f":"Table445[[#This Row],[Annual requirement '[t/y']]]*Table445[[#This Row],[Cost per tonne '[SEK/tonne']]]","v":334540800.00000006},{"$f":"Table445[[#This Row],[Cost per tonne '[SEK/tonne']]]","v":21120},{"$f":"Table445[[#This Row],[Annual cost '[SEK/y']]]","v":334540800.00000006}]
[null,"Total costs raw material, reactants & catalyst",null,{"$f":"SUM(Table445[Annual cost '[SEK/y']])","v":617392152},null,{"$f":"SUM(F28:F30)","v":671203800}]
[]
["Electricity"]
["Unit","Annual requirement [MWh/y]","Cost per MWh [SEK/MWh]","Annual cost [SEK/y]"]
["Sedimentation disc centrifuge",{"$f":"B275","v":216.4701593336145},{"$f":"'Properties and Data'!B13","v":386},{"$f":"B35*C35","v":83557.481502775205}]
[null,"Total costs electricity",null,{"$f":"SUM(Table45[Annual cost '[SEK/y']])","v":83557.481502775205}]
[]
["Irregular costs"]
["Item","Cost [SEK]","Frequency (every x years)","Number of times during lifetime","Avg cost/year [SEK/y]"]
["Thermal oil",{"$f":"B76","v":13172483.107576931},5,{"$f":"$B$96/C40+1","v":3.7199999999999998},{"$f":"B40*D40/$B$96","v":3603061.5558960428}]
[null,null,null,"Total irregular costs",{"$f":"SUM(Table251[Avg cost/year '[SEK/y']])","v":3603061.5558960428}]
[]
["CALCULATIONS"]
["Heating"]
["Heating to process temperature"]
[]
["Heat exchanger 1"]
[]
["Mass balance"]
["Component","In [t/h]","Out [t/h]"]
["Stabilized PO",{"$f":"Stabilization!D12","v":58.82352941176471},{"$f":"B51","v":58.82352941176471}]
["Catalyst",{"$f":"B147","v":19.411764705882355},{"$f":"B52","v":19.411764705882355}]
["Total",{"$f":"SUM(B51:B52)","v":78.235294117647072},{"$f":"SUM(C51:C52)","v":78.235294117647072}]
[]
[]
["Energy balance"]
["Property","Cold side (PO)","Warm side (DOW)","Unit"]
["Cp",{"$f":"'Properties and Data'!$D$5","v":2328.9535983931996},{"$f":"'Properties and Data'!$F$5","v":2245.2857142857142},"J/kg/°C"]
["Efficiency",0.7,0.7,"-"]
["T in",25,{"$f":"B173","v":340},"°C"]
["T out",{"$f":"B60+B67/(B58*B62)","v":121.88648329681264},100,"°C"]
["Mass flow ",{"$f":"C53/3600*1000","v":21.732026143790851},13,"kg/s"]
["delta T1",{"$f":"C60-B61","v":218.11351670318737},null,"°C"]
["delta T2",{"$f":"C61-B60","v":75},null,"°C"]
["delta Tlm",{"$f":"(B63-B64)/LN(B63/B64)","v":134.06072662279317},null,"°C"]
["U",100,null,"W/m2/°C"]
["Q needed to heat (ideal)",{"$f":"C68*0.7","v":4903704},null,"W"]
["Q needed to provide",null,{"$f":"C58*C62*(C60-C61)","v":7005291.4285714291},"W"]
["A",{"$f":"C68/(B66*B65)","v":522.54613301345341},null,"m2"]
[]
["Thermal oil"]
["Property","Value","Unit"]
["Mass flow hourly",{"$f":"C62*3600/1000","v":46.8},"t/h"]
["Amount needed",{"$f":"B73","v":46.8},"t"]
["Cost/tonne",{"$f":"'Properties and Data'!B48","v":281463.31426446437},"SEK/t"]
["Total cost",{"$f":"B74*B75","v":13172483.107576931},"SEK"]
[]
["Gas heater"]
[]
["Mass balance"]
["Component","In"," "]
["Stabilized PO",{"$f":"C51","v":58.82352941176471},{"$f":"B82","v":58.82352941176471}]
["Catalyst",{"$f":"C52","v":19.411764705882355},{"$f":"B83","v":19.411764705882355}]
["H2",{"$f":"B132","v":6.7058823529411766},6.7058823529411766]
["Total",{"$f":"SUM(B82:B84)","v":84.941176470588246},{"$f":"SUM(C82:C84)","v":84.941176470588246}]
[]
["Energy balance"]
["Property","PO + Catalyst","H2","Unit"]
["Tin",{"$f":"B61","v":121.88648329681264},25,"°C"]
["T out",400,400,"°C"]
["Cp",{"$f":"'Properties and Data'!D5","v":2328.9535983931996},{"$f":"'Properties and Data'!E5","v":14400},"J/kg/°C"]
["Mass flow",{"$f":"B62","v":21.732026143790851},{"$f":"B132*1000/3600","v":1.8627450980392157},"kg/s"]
["Efficiency",0.8,0.8,"-"]
["Q needed to heat (ideal)",{"$f":"B92*B58*(B90-B89)","v":14076126.182983797},{"$f":"C92*C91*(C90-C89)","v":10058823.529411765},"W"]
["Q needed to provide",{"$f":"B94/B93","v":17595157.728729744},{"$f":"C94/C93","v":12573529.411764706},"W"]
["Combustion enthalpy CH4",{"$f":"'Properties and Data'!B69","v":13.6},{"$f":"B96","v":13.6},"kWh/kg"]
["Hourly CH4 requirement",{"$f":"B95/1000/B96","v":1293.7615977007165},{"$f":"C95/1000/C96","v":924.52422145328728},"kg/h"]
["Annual CH4 requirement",{"$f":"B97*24*'Properties and Data'!$B$24/1000","v":10557.094637237848},{"$f":"C97*24*'Properties and Data'!$B$24/1000","v":7544.1176470588243},"t/y"]
[]
["Slurry reactor"]
["Mild HDO and stabilization"]
[]
["Specifications and calculations"]
["Parameter","Value","Unit"]
["Residence time",1,"h"]
["Mass flow",{"$f":"C85","v":84.941176470588246},"t/h"]
["Volume",{"$f":"B105*B106*1000/'Properties and Data'!D4","v":74.588317940453337},"m3"]
[]
[]
["Product distribution"]
["Component","Weight percent of feed  [wt%]"]
["HDO oil",38.4]
["Water phase",47.4]
["Gas (CO+CO2)",8]
["Gas (C1-C5)",8.6999999999999993]
[]
["Mass balance"]
["Component","In [t/h]","Out [t/h]"]
["Stabilized PO",{"$f":"C51","v":58.82352941176471}]
["HDO oil",null,{"$f":"$B$119*B112/100","v":22.588235294117649}]
["Water phase",null,{"$f":"$B$119*B113/100","v":27.882352941176475}]
["Gas (CO+CO2)",null,{"$f":"$B$119*B114/100","v":4.7058823529411766}]
["Gas (C1-C5)",null,{"$f":"$B$119*B115/100","v":5.117647058823529}]
["Catalyst",{"$f":"C52","v":19.411764705882355},{"$f":"B124","v":19.411764705882355}]
["H2",{"$f":"C84","v":6.7058823529411766},{"$f":"B125-B131","v":4.4705882352941178}]
["Total",{"$f":"SUM(B119:B125)","v":84.941176470588246},{"$f":"SUM(C119:C125)","v":84.176470588235304}]
[]
["Hydrogen"]
["Property","Value","Unit"]
["Consumption",3.7999999999999999E-2,"g/g feed"]
[null,{"$f":"B130*C51","v":2.2352941176470589},"t/h"]
["Supply",{"$f":"B131*3","v":6.7058823529411766},"t/h"]
[null,{"$f":"B132*1000/'Properties and Data'!E4","v":74592.68468232677},"Nm3/h"]
["Natural gas needed to produce H2",{"$f":"B131*2","v":4.4705882352941178},"t/h"]
["Bio-gas yield slurry reactor",6.5,"wt% of feed"]
["Bio-gas from slurry",{"$f":"C51*B135/100","v":3.8235294117647061},"t/h"]
["Natural gas needed from other source",{"$f":"B134-B136","v":0.64705882352941169},"t/h"]
["H2 from slurry bio-gas",{"$f":"B136/2","v":1.911764705882353},"t/h"]
["Annual H2 from slurry bio-gas",{"$f":"B138*24*'Properties and Data'!B24","v":15600},"t/y"]
["H2 from other source",{"$f":"B137/2","v":0.32352941176470584},"t/h"]
["Annual H2 from other source",{"$f":"B140*24*'Properties and Data'!B24","v":2639.9999999999995},"t/y"]
[]
[]
["Catalyst"]
["Property","Value","Unit"]
["Catalyst / kg feed",33,"wt% of feed"]
["Catalyst feed rate",{"$f":"B146*B51/100","v":19.411764705882355},"t/h"]
["Make-up rate",0.1,"-"]
["Catalyst feed rate (fresh)",{"$f":"B147*B148","v":1.9411764705882355},"t/h"]
["Annual requirement",{"$f":"B149*24*'Properties and Data'!B24","v":15840.000000000002},"t/y"]
[]
[]
["Cooling"]
["Cooling of slurry mixture"]
[]
["Heat exchanger 2"]
[]
["Mass balance"]
["Component","In [t/h]","Out [t/h]"]
["HDO oil",{"$f":"C120","v":22.588235294117649},{"$f":"B160","v":22.588235294117649}]
["Water phase",27.882352941176475,{"$f":"B161","v":27.882352941176475}]
["Gas (CO+CO2)",4.7058823529411766,4.7058823529411766]
["Gas (C1-C5)",5.117647058823529,5.117647058823529]
["Catalyst",19.411764705882355,19.411764705882355]
["H2",4.4705882352941178,4.4705882352941178]
["Total",{"$f":"SUM(B160:B165)","v":84.176470588235304},{"$f":"SUM(C160:C165)","v":84.176470588235304}]
[]
["Energy balance"]
["Property","Cold side (DOW)","Warm side (PO)","Unit"]
["Cp",{"$f":"C58","v":2245.2857142857142},{"$f":"B58","v":2328.9535983931996},"J/kg/°C"]
["Efficiency",0.7,0.7,"-"]
["T in",100,400,"°C"]
["T out",340,{"$f":"C172-C180/(C170*C174)","v":202.27248306772927},"°C"]
["Mass flow ",{"$f":"C62","v":13},{"$f":"B62","v":21.732026143790851},"kg/s"]
["delta T1",{"$f":"C173-B172","v":102.27248306772927},null,"°C"]
["delta T2",{"$f":"C172-B173","v":60},null,"°C"]
["delta Tlm",{"$f":"(B175-B176)/LN(B175/B176)","v":79.266440754205078},null,"°C"]
["U",100,null,"W/m2/°C"]
["Q used",{"$f":"C68","v":7005291.4285714291},null,"MW"]
["Q provided",null,{"$f":"B179/0.7","v":10007559.183673471},"MW"]
["A",{"$f":"C180/(B178*B177)","v":1262.521577663063},null,"m2"]
[]
["Heat exchanger 3"]
[]
["Mass balance"]
["Component","In [t/h]","Out [t/h]"]
["HDO oil",{"$f":"C160","v":22.588235294117649},{"$f":"B187","v":22.588235294117649}]
["Water",{"$f":"C161","v":27.882352941176475},{"$f":"B188","v":27.882352941176475}]
["Gas (CO+CO2)",{"$f":"C162","v":4.7058823529411766},4.7058823529411766]
["Gas (C1-C5)",{"$f":"C163","v":5.117647058823529},5.117647058823529]
["Catalyst",{"$f":"C164","v":19.411764705882355},19.411764705882355]
["H2",{"$f":"C165","v":4.4705882352941178},4.4705882352941178]
["Total",{"$f":"SUM(B187:B192)","v":84.176470588235304},{"$f":"SUM(C187:C192)","v":84.176470588235304}]
[]
["Heat balance"]
["Property","Cold side (water)","Warm side (PO)","Unit"]
["Cp",4180,{"$f":"C170","v":2328.9535983931996},"J/kg/°C"]
["Efficiency",0.7,0.7,"-"]
["T in",20,{"$f":"C173","v":202.27248306772927},"°C"]
["T out",80,100,"°C"]
["Mass flow ",{"$f":"B206/(B197*(B200-B199))","v":29.484534989254765},{"$f":"C174","v":21.732026143790851},"kg/s"]
["delta T1",{"$f":"C200-B199","v":80},null,"°C"]
["delta T2",{"$f":"C199-B200","v":122.27248306772927},null,"°C"]
["delta Tlm",{"$f":"(B202-B203)/LN(B202/B203)","v":99.646283151937112},null,"°C"]
["U",100,null,"W/m2/°C"]
["Q used",{"$f":"C207/B198","v":7394721.3753050948},null,"MW"]
["Q provided",null,{"$f":"C197*C201*(C199-C200)","v":5176304.9627135657},"MW"]
["A",{"$f":"C207/(B205*B204)","v":519.46794190214996},null,"m2"]
[]
["Cooling water"]
["Property","Value","Unit"]
["Hourly requirement",{"$f":"B201*3600/1000","v":106.14432596131715},"t/h"]
["Annual requirement",{"$f":"B212*24*'Properties and Data'!B24","v":866137.69984434801},"t/y"]
[]
[]
["Liquid-gas separation"]
["Separating gases from liquid"]
[]
["Pressure regulator"]
[]
["Specifications and calculations"]
["Property","Value","Unit"]
["Mass flow",{"$f":"C193","v":84.176470588235304},"t/h"]
["Starting pressure",100,"bar"]
["Ending pressure",1,"bar"]
[]
["Flash vessel"]
[]
["Specifications and calculations"]
["Property","Value","Unit"]
["Liquid loss to gas",3,"wt%"]
["Liquid flow",{"$f":"(B242+B243)*1000/3600","v":14.019607843137257},"kg/s"]
["Liquid density",{"$f":"'Properties and Data'!D4","v":1138.8},"kg/m3"]
["Catalyst flow",{"$f":"B246*1000/3600","v":5.3921568627450993},"kg/s"]
["Catalyst density",{"$f":"'Properties and Data'!G4","v":4692},"kg/m3"]
["Volumetric flow",{"$f":"B232/B233+B234/B235","v":1.3460083960010801E-2},"m3/s"]
["Residense time",120,"s"]
["Flash volume (multiplied with 2)",{"$f":"B236*B237*2","v":3.2304201504025922},"m3"]
[]
["Mass balance"]
["Component","In [t/h]","Slurry [t/h]","Gas [t/h]"]
["HDO oil",{"$f":"C187","v":22.588235294117649},{"$f":"B242*(100-$B$231)/100","v":21.910588235294117},{"$f":"B242*$B$231/100","v":0.67764705882352938}]
["Water phase",27.882352941176475,{"$f":"B243*(100-$B$231)/100","v":27.045882352941181},{"$f":"B243*$B$231/100","v":0.83647058823529419}]
["Gas (CO+CO2)",4.7058823529411766,null,{"$f":"B244","v":4.7058823529411766}]
["Gas (C1-C5)",5.117647058823529,null,{"$f":"B245","v":5.117647058823529}]
["Catalyst",19.411764705882355,{"$f":"B246","v":19.411764705882355}]
["H2",4.4705882352941178,null,{"$f":"B247","v":4.4705882352941178}]
["Total",{"$f":"SUM(B242:B247)","v":84.176470588235304},{"$f":"SUM(C242:C247)","v":68.368235294117653},{"$f":"SUM(D242:D247)","v":15.808235294117647}]
[]
[]
["Liquid/solid-separation"]
["Separating catalyst from PO"]
[]
["Sedimentation Disc Centrifuge"]
[]
["Specifications and calculations"]
["Property","Value","Unit"]
["Liquid lost",10,"wt%"]
[]
["Mass balance"]
["Component","In [t/h]","Liquid [t/h]","Catalyst [t/h]"]
["HDO oil",{"$f":"C242","v":21.910588235294117},{"$f":"B262*(100-$B$258)/100","v":19.719529411764707},{"$f":"B262*$B$258/100","v":2.1910588235294117}]
["Water",{"$f":"C243","v":27.045882352941181},{"$f":"B263*(100-$B$258)/100","v":24.341294117647063},{"$f":"B263*$B$258/100","v":2.7045882352941182}]
["Catalyst",{"$f":"C246","v":19.411764705882355},null,{"$f":"B264","v":19.411764705882355}]
["Total",{"$f":"SUM(B262:B264)","v":68.368235294117653},{"$f":"SUM(C262:C264)","v":44.06082352941177},{"$f":"SUM(D262:D264)","v":24.307411764705883}]
[]
["Specifications and calculations"]
["Property","Value","Unit"]
["Density liquid",{"$f":"B233","v":1138.8},"kg/m3"]
["Density catalyst",{"$f":"'Properties and Data'!G4","v":4692},"kg/m3"]
["Density total",{"$f":"(B269*(B263+B262)/B265+B270*B264/B265)","v":2147.6586030664394},"kg/m3"]
["Volumetric flow/h",{"$f":"B265/B271*1000","v":31.83384696082566},"m3/h"]
["Volumetric flow/s",{"$f":"B272/3600","v":8.8427352668960166E-3},"m3/s"]
["Energy demand ",{"$f":"3000*B273*0.001","v":2.652820580068805E-2},"MW"]
["Annual energy demand",{"$f":"B274*24*'Properties and Data'!B24","v":216.4701593336145},"MWh/y"]
[]
["Liquid/liquid-separation"]
["Separating oil phase from aqueous phase"]
[]
["Decanter"]
[]
["Specifications and calculations"]
["Property","Value","Unit"]
["Water remaining in oil phase",5.8,"wt%"]
["Total liquid flow",{"$f":"B294/3600*1000","v":12.239117647058826},"kg/S"]
["Volumetric flow",{"$f":"B285/'Properties and Data'!D4","v":1.0747381144238521E-2},"m3/s"]
["Residence time",900,"s"]
["Decanter volume",{"$f":"B286*B287","v":9.6726430298146688},"m3/s"]
[]
["Mass balance"]
["Component","In","Oil phase","Water phase"]
["HDO oil",{"$f":"C262","v":19.719529411764707},{"$f":"B292","v":19.719529411764707}]
["Water",{"$f":"C263","v":24.341294117647063},{"$f":"(B294-B293)/(1-B284/100)-C292","v":1.2141536155863619},{"$f":"B293-C293","v":23.127140502060701}]
["Total",{"$f":"SUM(B292:B293)","v":44.06082352941177},{"$f":"SUM(C292:C293)","v":20.933683027351069},{"$f":"SUM(D292:D293)","v":23.127140502060701}]

{"sheet":"CO2","index":5,"n_rows":36,"n_cols":4,"rows_kept":36,"cut":false,"hidden":false,"merged":[]}
["Transportation"]
["Parameter","Fossil","Grön","Unit"]
["PO to ship",{"$f":"Stabilization!D12","v":58.82352941176471},{"$f":"B3","v":58.82352941176471},"ton/h"]
["Distance",1300,{"$f":"B4","v":1300},"km"]
["Ship emissions",7,7,"g CO2/tonne-km"]
["CO2 emissions/h",{"$f":"B3*B4*B5/1000","v":535.2941176470589},535.2941176470589,"kg CO2 eq/h"]
[]
["Methanol Production"]
["Parameter","Fossil","Green","Unit"]
["WtW emissions factor",110,13.3,"gCO2eq/MJ"]
["Energy density",19.899999999999999,19.899999999999999,"MJ/kg"]
["Methanol used",{"$f":"Stabilization!$C$12*1000","v":8823.5294117647099},{"$f":"Stabilization!$C$12*1000","v":8823.5294117647099},"kg/h"]
["Methanol MJ/h",{"$f":"B12*B11","v":175588.23529411771},{"$f":"C12*C11","v":175588.23529411771},"MJ/h"]
["CO2 emissions/h",{"$f":"B10*B13/1000","v":19314.705882352948},{"$f":"C10*C13/1000","v":2335.3235294117658},"kg CO2 eq/h"]
[]
["Natural Gas"]
["Parameter","Fossil","Green","Unit"]
["CH4 flow",{"$f":"'Slurry hydrotreatment'!B97+'Slurry hydrotreatment'!C97","v":2218.2858191540035},{"$f":"B18","v":2218.2858191540035},"kg/h"]
["g CO2/ MJ",null,{"$f":"20/1000","v":0.02},"kg CO2/MJ"]
["kg CO2 /kg CH4",28,{"$f":"C19*48.96","v":0.97920000000000007},"kg/kg"]
["CO2 emissions/h",{"$f":"B18*B20","v":62112.002936312099},{"$f":"C18*C20","v":2172.1454741156003},"kg CO2 eq/h"]
[]
["Hydrogen Production"]
["Parameter","Fossil","Green","Unit"]
["CH4 from extern source/h",{"$f":"'Slurry hydrotreatment'!B137","v":0.64705882352941169},{"$f":"B25","v":0.64705882352941169},"t/h"]
["CH4 kg/h",{"$f":"B25*1000","v":647.05882352941171},{"$f":"B26","v":647.05882352941171},"kg/h"]
["CH4 to CO2",28,0,"kg/kg"]
["CO2 emissions/h",{"$f":"B26*B27","v":18117.647058823528},0,"kg CO2 eq/h"]
[]
[]
["Total"]
["Parameter","Fossil","Green","Unit"]
["Total CO2 emissions hourly",{"$f":"B6+B14+B21+B28","v":100079.64999513564},{"$f":"B6+C14+C21+C28","v":5042.7631211744247},"kg CO2/h"]
["Total produced PO",{"$f":"'Slurry hydrotreatment'!$C$294*1000","v":20933.683027351068},{"$f":"'Slurry hydrotreatment'!$C$294*1000","v":20933.683027351068},"kg/h"]
["CO2 per kg PO",{"$f":"B33/B34","v":4.780795135971811},{"$f":"C33/C34","v":0.24089230330782035},"kg CO2 eq/kg PO"]
["tonne CO2 per year",{"$f":"B33*24*340/1000","v":816649.94396030693},{"$f":"C33*24*340","v":41148947.068783306},"t CO2/y"]

{"sheet":"Costs summary","index":6,"n_rows":103,"n_cols":6,"rows_kept":103,"cut":false,"hidden":false,"merged":[[0,0,0,4],[88,0,88,4]]}
["Operational costs"]
[]
["Personnel and administration"]
[]
["Number of operators"]
["Unit","n (workers per shift)",null,"Fossil scenario"]
["Storage tank x2",0,null,"Green scenario"]
["Heat exchanger x3",{"$f":"0.05*3","v":0.15000000000000002},null,"Same for both scenarios"]
["Gas Heater",0.25]
["Reactor",0.25]
["Flash vessel",0]
["Centrifuge",0.1]
["Settling tank",0]
["Total operators/shift",{"$f":"SUM(B7:B13)","v":0.75}]
["Total shifts",5]
["Total operators",5]
[]
["Costs personell and administration"]
["Item","Salary [SEK/y]"]
["Shift workers",{"$f":"'Properties and Data'!B21*B16*12","v":1800000}]
["Supervisors",{"$f":"B20*0.15","v":270000}]
["Laboratory work",{"$f":"0.15*B20","v":270000}]
["Overhead staff",{"$f":"0.7*B20+0.7*B21","v":1449000}]
["Administration",{"$f":"0.25*B23","v":362250}]
["Total costs personell",{"$f":"SUM(B20:B24)","v":4151250}]
["License fees",{"$f":"0.03*B25","v":124537.5}]
[]
["Consumables and utilities"]
[]
["Raw material, reactants, catalyst"]
["Feedstock","Annual requirement [t/y]","Cost per tonne [SEK/tonne]","Annual cost [SEK/y]","Cost per tonne GREEN [SEK/t]","Annual cost Green [SEK/y]"]
["Raw pyrolysis oil",{"$f":"Stabilization!B12*24*'Properties and Data'!B24","v":408000},{"$f":"'Properties and Data'!B9","v":6000},{"$f":"B32*C32","v":2448000000},{"$f":"Table4[[#This Row],[Cost per tonne '[SEK/tonne']]]","v":6000},{"$f":"Table4[[#This Row],[Annual requirement '[t/y']]]*Table4[[#This Row],[Cost per tonne GREEN '[SEK/t']]]","v":2448000000}]
["Methanol",{"$f":"Stabilization!C12*24*'Properties and Data'!B24","v":72000.000000000029},{"$f":"'Properties and Data'!B10","v":7143.75},{"$f":"B33*C33","v":514350000.00000018},{"$f":"'Properties and Data'!B11","v":13635.99},{"$f":"Table4[[#This Row],[Annual requirement '[t/y']]]*Table4[[#This Row],[Cost per tonne GREEN '[SEK/t']]]","v":981791280.00000036}]
["Hydrogen from slurry CH4",{"$f":"'Slurry hydrotreatment'!B28","v":15600},{"$f":"'Slurry hydrotreatment'!C28","v":10858.499999999996},{"$f":"B34*C34","v":169392599.99999994},{"$f":"Table4[[#This Row],[Cost per tonne '[SEK/tonne']]]","v":10858.499999999996},{"$f":"Table4[[#This Row],[Annual requirement '[t/y']]]*Table4[[#This Row],[Cost per tonne GREEN '[SEK/t']]]","v":169392599.99999994}]
["Hydrogen from other source",{"$f":"'Slurry hydrotreatment'!B29","v":2639.9999999999995},{"$f":"'Properties and Data'!B14","v":42976.799999999996},113458751.99999997,{"$f":"'Properties and Data'!B15","v":63360},{"$f":"Table4[[#This Row],[Annual requirement '[t/y']]]*Table4[[#This Row],[Cost per tonne GREEN '[SEK/t']]]","v":167270399.99999997}]
["Catalyst",{"$f":"'Slurry hydrotreatment'!B150","v":15840.000000000002},{"$f":"'Properties and Data'!B12","v":21120},{"$f":"B36*C36","v":334540800.00000006},{"$f":"Table4[[#This Row],[Cost per tonne '[SEK/tonne']]]","v":21120},{"$f":"Table4[[#This Row],[Annual requirement '[t/y']]]*Table4[[#This Row],[Cost per tonne GREEN '[SEK/t']]]","v":334540800.00000006}]
[null,"Total costs raw material, reactants & catalyst",null,{"$f":"SUM(D32:D36)","v":3579742152},null,{"$f":"SUM(Table4[Annual cost Green '[SEK/y']])","v":4100995080.0000005}]
[]
["Utilities"]
["Utility","Annual requirement [t/y]","Cost per tonne [SEK/tonne]","Annual cost [SEK/y]","Cost per tonne GREEN [SEK/t]","Annual cost Green [SEK/y]"]
["Natural gas",{"$f":"'Slurry hydrotreatment'!B98+'Slurry hydrotreatment'!C98","v":18101.212284296671},{"$f":"'Properties and Data'!B17","v":5751.576},{"$f":"B41*C41","v":104110498.14526591},{"$f":"'Properties and Data'!B18","v":16000},{"$f":"Table448[[#This Row],[Annual requirement '[t/y']]]*Table448[[#This Row],[Cost per tonne GREEN '[SEK/t']]]","v":289619396.54874676}]
["Cooling water ",{"$f":"'Slurry hydrotreatment'!B213","v":866137.69984434801},{"$f":"'Properties and Data'!B19","v":0.2},{"$f":"B42*C42","v":173227.53996886962},{"$f":"Table448[[#This Row],[Cost per tonne '[SEK/tonne']]]","v":0.2},{"$f":"Table448[[#This Row],[Annual requirement '[t/y']]]*Table448[[#This Row],[Cost per tonne GREEN '[SEK/t']]]","v":173227.53996886962}]
[null,"Total costs utilities",null,{"$f":"SUM(D41:D42)","v":104283725.68523477},null,{"$f":"SUM(Table448[Annual cost Green '[SEK/y']])","v":289792624.08871561}]
[]
[]
["Electricity"]
["Unit","Annual requirement [MWh/y]","Cost per MWh [SEK/MWh]","Annual cost [SEK/y]"]
["Heating Storage tank PO site",{"$f":"'Storage and transportation'!B47","v":1523.6342381898105},{"$f":"'Properties and Data'!B13","v":386},{"$f":"B48*C48","v":588122.81594126683}]
["Heating Storage tank Refinery",{"$f":"'Storage and transportation'!B87","v":1523.6342381898105},{"$f":"C48","v":386},{"$f":"B49*C49","v":588122.81594126683}]
["Sedimenation centrifuge",{"$f":"'Slurry hydrotreatment'!B275","v":216.4701593336145},{"$f":"C49","v":386},83557.481502775205]
[null,null,"Total costs electricity",{"$f":"SUM(D48:D50)","v":1259803.1133853088}]
[]
["Transportation"]
["Transportation","Annual requirement","Cost per tonne [SEK/t]","Annual cost [SEK/y]"]
["Ship",{"$f":"'Storage and transportation'!B57","v":480000.00000000006},{"$f":"'Storage and transportation'!B58","v":633.6},{"$f":"Table1[[#This Row],[Annual requirement]]*Table1[[#This Row],[Cost per tonne '[SEK/t']]]","v":304128000.00000006}]
[null,null,"Total costs transportation",{"$f":"SUM(D55)","v":304128000.00000006}]
["Irregular costs"]
["Item","Cost [SEK]","Frequency (every x years)","Number of times during lifetime","Avg cost/year [SEK/y]"]
["Thermal oil",{"$f":"'Slurry hydrotreatment'!B76","v":13172483.107576931},5,{"$f":"'Properties and Data'!$B$31/C59+1","v":4},{"$f":"B59*D59/'Properties and Data'!$B$31","v":3512662.1620205147}]
[null,null,null,"Total irregular costs",{"$f":"SUM(Table2[Avg cost/year '[SEK/y']])","v":3512662.1620205147}]
[]
["Equipment spare items and maintenance"]
[]
["Spare items and maintenance"]
["Item","Cost [$2024]","Cost [SEK2024]"]
["Annual maintenance",{"$f":"0.05*D103","v":932571.99661128118},{"$f":"B66*'Properties and Data'!$B$36","v":9847960.2842151299}]
["Spare items",{"$f":"0.15*B66","v":139885.79949169216},{"$f":"B67*'Properties and Data'!$B$36","v":1477194.0426322692}]
["Annual cost spare items",{"$f":"B67*'Properties and Data'!B32","v":23922.857129663771},{"$f":"B68*'Properties and Data'!$B$36","v":252625.37128924942}]
[null,"Total annual equipment costs",{"$f":"C66+C68","v":10100585.655504379}]
[]
["Total operating costs"]
["Item","Annual cost fossil [SEK/y]","Annual cost green [SEK/y]"]
["Personell and administration",{"$f":"B25+B26","v":4275787.5},{"$f":"Table36[[#This Row],[Annual cost fossil '[SEK/y']]]","v":4275787.5}]
["Raw material, reactants, catalyst",{"$f":"D37","v":3579742152},{"$f":"F37","v":4100995080.0000005}]
[{"$f":"A39","v":"Utilities"},{"$f":"D43","v":104283725.68523477},{"$f":"F43","v":289792624.08871561}]
[{"$f":"A46","v":"Electricity"},{"$f":"D51","v":1259803.1133853088},{"$f":"Table36[[#This Row],[Annual cost fossil '[SEK/y']]]","v":1259803.1133853088}]
[{"$f":"A53","v":"Transportation"},{"$f":"D56","v":304128000.00000006},{"$f":"Table36[[#This Row],[Annual cost fossil '[SEK/y']]]","v":304128000.00000006}]
["Spare items, maintenance, irregular costs",{"$f":"C69+E60","v":13613247.817524895},{"$f":"Table36[[#This Row],[Annual cost fossil '[SEK/y']]]","v":13613247.817524895}]
["Total annual operating costs",{"$f":"SUM(B73:B78)","v":4007302716.1161447},{"$f":"SUM(C73:C78)","v":4714064542.5196266}]
[]
[]
["Oil price"]
["Property","Fossil production","Green production","Unit"]
["Oil produced per year",{"$f":"'Slurry hydrotreatment'!C294*24*'Properties and Data'!B24","v":170818.85350318474},{"$f":"B84","v":170818.85350318474},"t/year"]
["Price per ton oil",{"$f":"B79/B84","v":23459.370168653149},{"$f":"C79/C84","v":27596.863260949925},"SEK/t"]
["Price per kg oil",{"$f":"B85/1000","v":23.459370168653148},{"$f":"C85/1000","v":27.596863260949924},"SEK/kg"]
[]
[]
["Capital costs"]
[]
[]
["Equipment"]
["Unit","Cbm [$2004]","Grass Root Plant Cost [$2004]","Grass Root Plant Cost [$2024]","Grass Root Plant Cost [SEK2024]"]
["Storage tanks",{"$f":"'Storage and transportation'!I7","v":420000},{"$f":"Table38[[#This Row],[Cbm '[$2004']]]*'Properties and Data'!B28*'Properties and Data'!B29","v":603749.99999999988},{"$f":"Table38[[#This Row],[Grass Root Plant Cost '[$2004']]]*'Properties and Data'!B27","v":1053328.5964145167},{"$f":"D94*'Properties and Data'!$B$36","v":11123149.978137298}]
["HEX1",{"$f":"'Slurry hydrotreatment'!Q6","v":140000},{"$f":"Table38[[#This Row],[Cbm '[$2004']]]*'Properties and Data'!B28*'Properties and Data'!B29","v":201250},{"$f":"C95*'Properties and Data'!$B$27","v":351109.5321381723},{"$f":"D95*'Properties and Data'!$B$36","v":3707716.6593790995}]
["Gas heater",{"$f":"'Slurry hydrotreatment'!Q7","v":3510000},{"$f":"B96*'Properties and Data'!$B$28*'Properties and Data'!$B$29","v":5045624.9999999991},{"$f":"C96*'Properties and Data'!$B$27","v":8802817.5557498895},{"$f":"D96*'Properties and Data'!$B$36","v":92957753.388718843}]
["Slurry reactor",{"$f":"'Slurry hydrotreatment'!Q8","v":2200000},{"$f":"B97*'Properties and Data'!$B$28*'Properties and Data'!$B$29","v":3162500},{"$f":"C97*'Properties and Data'!$B$27","v":5517435.505028422},{"$f":"D97*'Properties and Data'!$B$36","v":58264118.933100142}]
["HEX 2",{"$f":"'Slurry hydrotreatment'!Q9","v":270000},{"$f":"B98*'Properties and Data'!$B$28*'Properties and Data'!$B$29","v":388125},{"$f":"C98*'Properties and Data'!$B$27","v":677139.81198076089},{"$f":"D98*'Properties and Data'!$B$36","v":7150596.4145168355}]
["HEX 3",{"$f":"'Slurry hydrotreatment'!Q10","v":157500},{"$f":"B99*'Properties and Data'!$B$28*'Properties and Data'!$B$29","v":226406.25},{"$f":"C99*'Properties and Data'!$B$27","v":394998.22365544381},{"$f":"D99*'Properties and Data'!$B$36","v":4171181.2418014868}]
["Flash",{"$f":"'Slurry hydrotreatment'!Q11","v":42500},{"$f":"B100*'Properties and Data'!$B$28*'Properties and Data'!$B$29","v":61093.749999999993},{"$f":"C100*'Properties and Data'!$B$27","v":106586.82225623087},{"$f":"D100*'Properties and Data'!$B$36","v":1125556.843025798}]
["Sedimentation disk centrifuge",{"$f":"'Slurry hydrotreatment'!Q12","v":612000},{"$f":"B101*'Properties and Data'!$B$28*'Properties and Data'!$B$29","v":879750},{"$f":"C101*'Properties and Data'!$B$27","v":1534850.2404897246},{"$f":"D101*'Properties and Data'!$B$36","v":16208018.539571492}]
["Decanter",{"$f":"'Slurry hydrotreatment'!Q13","v":85000},{"$f":"B102*'Properties and Data'!$B$28*'Properties and Data'!$B$29","v":122187.49999999999},{"$f":"C102*'Properties and Data'!$B$27","v":213173.64451246173},{"$f":"D102*'Properties and Data'!$B$36","v":2251113.686051596}]
["Total",{"$f":"SUM(B94:B102)","v":7437000},{"$f":"SUM(C94:C102)","v":10690687.5},{"$f":"SUM(D94:D102)","v":18651439.932225622},{"$f":"SUM(E94:E102)","v":196959205.68430263}]