{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Credits","Instructions","Utilities & Consumables","Economic and CO2 Emission Data","Sensitivity","Economic balance"],"not_rendered":{"charts":2,"images":29,"macros":1,"external_links":1,"defined_names":238,"comments":2,"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":"Credits","index":0,"n_rows":15,"n_cols":14,"rows_kept":15,"cut":false,"hidden":false,"merged":[[2,0,4,0],[5,0,7,0]]}
["Spreadsheet for the evaluation of the economic analysis of cement plants with CO2 capture.",null,null,null,null,null,null,null,null,null,null,null,null," Version 1.1 - 26/06/2018"]
["Authors:","Name","email"]
["POLIMI","Edoardo De Lena","edoardo.delena@polimi.it"]
[null,"Maurizio Spinelli","maurizio.spinelli@polimi.it"]
[null,"Matteo Romano","matteo.romano@polimi.it"]
["SINTEF","Mari Voldsund","mari.voldsund@sintef.no"]
[null,"Stefania Osk Gardarsdottir","stefania.gardarsdottir@sintef.no"]
[null,"Simon Roussanaly","simon.roussanaly@sintef.no"]
[]
[]
[]
[]
[]
[]
["Acknowledgement: This project has received funding from the European Union's Horizon 2020 research and innovation Programme under grant agreement no 641185 (CEMCAP)."]

{"sheet":"Instructions","index":1,"n_rows":16,"n_cols":1,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["Instructions:"]
["General note: Green cells in  \"Utilities & Consumables\" and \"Economic and CO2 emission Data\" must be used to insert the input data. Light green cells represent CEMCAP reference values and should not be changed"]
["    to keep a consistent methodology with the CEMCAP economic framework."]
["When the Cemcap economic framework default values are changed, the colour of the cells becomes orange."]
["It is possible to restore the Cemcap default values by clicking the button below."]
[]
[]
["Step-by-step instructions for economic calculation:"]
["1) Insert inputs in the \"Utilities & Consumables\" sheet. Additional items associated to the capture plant may be introduced in addition to the default ones (fuel, electricity, steam, etc…)."]
["    Electricity and steam prices introduced in this sheet must refer to the cost without carbon tax. When a calculation with carbon tax is performed, the cost associated to indirect emissions from power "]
["    and steam generation are is added to the cement cost."]
["2) Insert inputs in the \"Economic and CO2 emission data\""]
["3) Press the button \"Calculate the Cost of Clinker\" and read the cost breakdown and the cost of CO2 avoided. Details of the economic calculations may be checked in the \"Economic balance\" sheet."]
["4) A sensitivity analysis of the cost of cement vs. selected parameters may be performed in the \"Sensitivity\" sheet."]
[]
["NOTE: When a calculation with carbon tax > 0 is performed, cost of avoided CO2 is computed independently of the carbon tax value."]

{"sheet":"Utilities & Consumables","index":2,"n_rows":29,"n_cols":13,"rows_kept":29,"cut":false,"hidden":false,"merged":[[1,1,1,2],[20,9,21,9],[10,9,11,9]]}
["Input data on utilities and consumables"]
["Utilities and Consumables","Unit price",null,"Amount","Plant without CO2 capture","Plant with CO2 capture","Climate impact","Climate impact",null,null,null,"Plant without CO2 capture","Plant with CO2 capture"]
["Raw Meal","€/tRawMeal",3.012,"tRawMeal/tclk",1.66,1.66,"kgCO2/tRawMeal",0,null,"Total Cost","€/tclk",{"$f":"SUMPRODUCT(C3:C29,E3:E29)","v":22.718309999999995},{"$f":"SUMPRODUCT(C3:C29,F3:F29)","v":40.130920000000003}]
["Fuel","€/GJLHV",3,"GJLHV/tclk",3.1349999999999998,10,"Do not introduce specific CO2 emissions from fuel",null,null,"Total indirect CO2 emissions","kgCO2/tclk",{"$f":"SUMPRODUCT(E3:E29,H3:H29)","v":34.5578},{"$f":"SUMPRODUCT(F3:F29,H3:H29)","v":2.62}]
["Electricity","€/MWhe",58.1,"MWhe/tclk",0.13189999999999999,0.01,"kgCO2/MWhe",262]
["Steam","€/MWhth",25.3,"MWhth/tclk",0,0,"kgCO2/MWhth",224]
["Cooling water","€/m3",0.39,"m3/tclk",0,10,"kgCO2/m3",0]
["Ammonia","€/tNH3",0.13,"kgNH3/tclk",5,5,"kgCO2/kgNH3",0]
["Others items may be introduced below this line",null,null,null,null,null,null,null,null,"Data for electricity and steam generation"]
[null,null,null,{"$f":"IF(B10=\"\",\"\",CONCATENATE(MID(B10,FIND(\"/\",B10)+1,LEN(B10)-FIND(\"/\",B10)),\"/tclk\"))","v":""},null,null,{"$f":"IF(B10=\"\",\"\",CONCATENATE(\"kgCO2/\",MID(B10,FIND(\"€\",B10)+2,LEN(B10)-FIND(\"/\",B10))))","v":""},null,null,"Reference power generation efficiency and emissions"]
[null,null,null,{"$f":"IF(B11=\"\",\"\",CONCATENATE(MID(B11,FIND(\"/\",B11)+1,LEN(B11)-FIND(\"/\",B11)),\"/tclk\"))","v":""},null,null,{"$f":"IF(B11=\"\",\"\",CONCATENATE(\"kgCO2/\",MID(B11,FIND(\"€\",B11)+2,LEN(B11)-FIND(\"/\",B11))))","v":""},null,null,"Reference scenario","href,e","Emissions"]
[null,null,null,"",null,null,"",null,null,null,"-","kgCO2/MWhe"]
[null,null,null,"",null,null,"",null,null,null,0.45900000000000002,262]
[null,null,null,"",null,null,"",null,null,null,0.442,770]
[null,null,null,"",null,null,"",null,null,null,0.35,973]
[null,null,null,"",null,null,"",null,null,null,0.35,90]
[null,null,null,"",null,null,"",null,null,null,0.52500000000000002,385]
[null,null,null,"",null,null,""]
[null,null,null,"",null,null,"",null,null,"Price of electricity with Carbon Tax",{"$f":"C5+Carbon_Tax/1000*'Utilities & Consumables'!H5","v":60.195999999999998},"€/MWhe"]
[null,null,null,"",null,null,"",null,null,"Reference steam generation cost and emissions"]
[null,null,null,"",null,null,"",null,null,"Steam source","Cost","Emissions"]
[null,null,null,"",null,null,"",null,null,null,"€/MWhth","kgCO2/MWhth"]
[null,null,null,"",null,null,"",null,null,null,8.5,0]
[null,null,null,"",null,null,"",null,null,null,7.7,101]
[null,null,null,"",null,null,"",null,null,null,10.3,136]
[null,null,null,"",null,null,"",null,null,null,13,170]
[null,null,null,"",null,null,"",null,null,null,25.3,224]
[null,null,null,"",null,null,""]
[null,null,null,"",null,null,"",null,null,"Price of steam with Carbon Tax",{"$f":"C6+Carbon_Tax/1000*'Utilities & Consumables'!H6","v":27.092000000000002},"€/MWhth"]

{"sheet":"Economic and CO2 Emission Data","index":3,"n_rows":54,"n_cols":20,"rows_kept":54,"cut":false,"hidden":false,"merged":[[35,8,35,9],[35,5,53,5],[6,5,17,5],[3,12,3,13],[3,5,5,5],[19,5,34,5],[18,1,23,3],[3,14,3,15],[3,16,3,17],[3,18,3,19],[1,12,1,15],[1,16,1,19]]}
[]
[null,"Financial data",null,null,null,"Plant data",null,null,"Plant without CO2 capture","Plant with CO2 capture",null,"Cost breakdown","Plant without CO2 capture",null,null,null,"Plant with CO2 capture"]
[]
[null,"Capacity_factor ",{"$f":"1000000/3000/365","v":0.91324200913242004},null,null,"Clinker Production","Clinker production","tclk/day",2895.5232000000001,2895,null,null,"Clinker",null,"Cement",null,"Clinker",null,"Cement"]
[null,"Depreciation_time",0,"yrs",null,null,"Cement/clinker ratio","tcem/tclk",1.36,1.36,null,"Raw meal",{"$f":"INDEX('Utilities & Consumables'!$A$3:$F$29,MATCH('Economic and CO2 Emission Data'!$L5,'Utilities & Consumables'!$A$3:$A$29,0),3)*INDEX('Utilities & Consumables'!$A$3:$F$29,MATCH('Economic and CO2 Emission Data'!$L5,'Utilities & Consumables'!$A$3:$A$29,0),5)","v":4.9999199999999995},"€/tclk",{"$f":"M5/I$5","v":3.6764117647058816},"€/tcem",{"$f":"INDEX('Utilities & Consumables'!$A$3:$F$29,MATCH('Economic and CO2 Emission Data'!$L5,'Utilities & Consumables'!$A$3:$A$29,0),3)*INDEX('Utilities & Consumables'!$A$3:$F$29,MATCH('Economic and CO2 Emission Data'!$L5,'Utilities & Consumables'!$A$3:$A$29,0),6)","v":4.9999199999999995},"€/tclk",{"$f":"Q5/J$5","v":3.6764117647058816},"€/tcem"]
[null,"Tax_rate",0,null,null,null,"Cement production","tcem/day",{"$f":"I4*I5","v":3937.9115520000005},{"$f":"J4*J5","v":3937.2000000000003},null,"Fuel",{"$f":"INDEX('Utilities & Consumables'!$A$3:$F$29,MATCH('Economic and CO2 Emission Data'!$L6,'Utilities & Consumables'!$A$3:$A$29,0),3)*INDEX('Utilities & Consumables'!$A$3:$F$29,MATCH('Economic and CO2 Emission Data'!$L6,'Utilities & Consumables'!$A$3:$A$29,0),5)","v":9.4049999999999994},"€/tclk",{"$f":"M6/I$5","v":6.915441176470587},"€/tcem",{"$f":"INDEX('Utilities & Consumables'!$A$3:$F$29,MATCH('Economic and CO2 Emission Data'!$L6,'Utilities & Consumables'!$A$3:$A$29,0),3)*INDEX('Utilities & Consumables'!$A$3:$F$29,MATCH('Economic and CO2 Emission Data'!$L6,'Utilities & Consumables'!$A$3:$A$29,0),6)","v":30},"€/tclk",{"$f":"Q6/J$5","v":22.058823529411764},"€/tcem"]
[null,"Operational_life",25,"yrs",null,"Emissions of CO2","CO2 emissions (direct at stack)","kgCO2/s",28.338592800000001,1,null,"Electricity",{"$f":"INDEX('Utilities & Consumables'!$A$3:$F$29,MATCH('Economic and CO2 Emission Data'!$L7,'Utilities & Consumables'!$A$3:$A$29,0),3)*INDEX('Utilities & Consumables'!$A$3:$F$29,MATCH('Economic and CO2 Emission Data'!$L7,'Utilities & Consumables'!$A$3:$A$29,0),5)","v":7.6633899999999997},"€/tclk",5.6348455882352937,"€/tcem",{"$f":"INDEX('Utilities & Consumables'!$A$3:$F$29,MATCH('Economic and CO2 Emission Data'!$L7,'Utilities & Consumables'!$A$3:$A$29,0),3)*INDEX('Utilities & Consumables'!$A$3:$F$29,MATCH('Economic and CO2 Emission Data'!$L7,'Utilities & Consumables'!$A$3:$A$29,0),6)","v":0.58100000000000007},"€/tclk",0.42720588235294121,"€/tcem"]
[null,"Construction_time",3,"yrs",null,null,"CO2 emissions (direct at stack)","kgCO2/tclk",{"$f":"I7/(I4/3600/24)","v":845.6},{"$f":"J7/(J4/3600/24)","v":29.844559585492227},null,"Steam",{"$f":"INDEX('Utilities & Consumables'!$A$3:$F$29,MATCH('Economic and CO2 Emission Data'!$L8,'Utilities & Consumables'!$A$3:$A$29,0),3)*INDEX('Utilities & Consumables'!$A$3:$F$29,MATCH('Economic and CO2 Emission Data'!$L8,'Utilities & Consumables'!$A$3:$A$29,0),5)","v":0},"€/tclk",0,"€/tcem",{"$f":"INDEX('Utilities & Consumables'!$A$3:$F$29,MATCH('Economic and CO2 Emission Data'!$L8,'Utilities & Consumables'!$A$3:$A$29,0),3)*INDEX('Utilities & Consumables'!$A$3:$F$29,MATCH('Economic and CO2 Emission Data'!$L8,'Utilities & Consumables'!$A$3:$A$29,0),6)","v":0},"€/tclk",0,"€/tcem"]
[null,"Percentage_of_TPC_depreciated",1,null,null,null,"CO2 emissions (indirect from electricity)","kgCO2/s",{"$f":"I10*I4/24/3600","v":1.1581355514},{"$f":"J10*J4/24/3600","v":8.7788194444444453E-2},null,"Carbon tax (direct emissions)",{"$f":"I37","v":6.7648000000000001},"€/tclk",4.9741176470588231,"€/tcem",{"$f":"J37","v":0.23875647668393782},"€/tclk",0.17555623285583663,"€/tcem"]
[null,"Inflation_rate",0,null,null,null,"CO2 emissions (indirect from electricity)","kgCO2/tclk",{"$f":"'Utilities & Consumables'!E5*'Utilities & Consumables'!H5","v":34.5578},{"$f":"'Utilities & Consumables'!F5*'Utilities & Consumables'!H5","v":2.62},null,"Carbon tax (emissions from power gen.)",{"$f":"I38","v":0.2764623999999995},"€/tclk",0.20328117647058785,"€/tcem",{"$f":"J38","v":2.0959999999999965E-2},"€/tclk",1.5411764705882326E-2,"€/tcem"]
[null,"Construction_inflat.",0,null,null,null,"CO2 emissions (indirect from steam)","kgCO2/s",{"$f":"I12*I6/24/3600","v":0},{"$f":"J12*J6/24/3600","v":0},null,"Carbon tax (emissions from steam gen.)",{"$f":"I39","v":0},"€/tclk",0,"€/tcem",{"$f":"J39","v":0},"€/tclk",0,"€/tcem"]
[null,"Percentage_of_Debt_Capital",0.5,null,null,null,"CO2 emissions (indirect from steam)","kgCO2/tclk",{"$f":"'Utilities & Consumables'!E6*'Utilities & Consumables'!H6","v":0},{"$f":"'Utilities & Consumables'!F6*'Utilities & Consumables'!H6","v":0},null,"Cooling water",{"$f":"INDEX('Utilities & Consumables'!$A$3:$F$29,MATCH('Economic and CO2 Emission Data'!$L12,'Utilities & Consumables'!$A$3:$A$29,0),3)*INDEX('Utilities & Consumables'!$A$3:$F$29,MATCH('Economic and CO2 Emission Data'!$L12,'Utilities & Consumables'!$A$3:$A$29,0),5)","v":0},"€/tclk",{"$f":"M12/I$5","v":0},"€/tcem",{"$f":"INDEX('Utilities & Consumables'!$A$3:$F$29,MATCH('Economic and CO2 Emission Data'!$L12,'Utilities & Consumables'!$A$3:$A$29,0),3)*INDEX('Utilities & Consumables'!$A$3:$F$29,MATCH('Economic and CO2 Emission Data'!$L12,'Utilities & Consumables'!$A$3:$A$29,0),6)","v":3.9000000000000004},"€/tclk",{"$f":"Q12/J$5","v":2.8676470588235294},"€/tcem"]
[null,"Percentage_of_Equity_capital",{"$f":"1-Percentage_of_Debt_Capital","v":0.5},null,null,null,"CO2 emissions (indirect from others sources)","kgCO2/s",{"$f":"I14*I8/24/3600","v":0},{"$f":"J14*J8/24/3600","v":0},null,"Other variable costs",{"$f":"(I40+Other_variable_OeM_base)-SUM(M12,M5:M8)","v":1.7379999999999995},"€/tclk",1.2779411764705879,"€/tcem",{"$f":"(J40+Other_variable_OeM_capt)-SUM(Q12,Q5:Q8)","v":1.7379999999999995},"€/tclk",1.2779411764705879,"€/tcem"]
[null,"Interest_on_debt",0.08,null,null,null,"CO2 emissions (indirect from others sources)","kgCO2/tclk",{"$f":"SUMPRODUCT('Utilities & Consumables'!E3,'Utilities & Consumables'!H3)+SUMPRODUCT('Utilities & Consumables'!E7:E8,'Utilities & Consumables'!H7:H8)+SUMPRODUCT('Utilities & Consumables'!E10:E29,'Utilities & Consumables'!H10:H29)","v":0},{"$f":"SUMPRODUCT('Utilities & Consumables'!F3,'Utilities & Consumables'!H3)+SUMPRODUCT('Utilities & Consumables'!F7:F8,'Utilities & Consumables'!H7:H8)+SUMPRODUCT('Utilities & Consumables'!F10:F29,'Utilities & Consumables'!H10:H29)","v":0},null,"Variable Opex",{"$f":"SUM(M5:M13)","v":30.847572399999997},"€/tclk",22.682038529411759,"€/tcem",{"$f":"SUM(Q5:Q13)","v":41.478636476683945},"€/tclk",30.498997409326428,"€/tcem"]
[null,"Interest_on_equity",0.08,null,null,null,"CO2 emissions (total indirect)","kgCO2/s",{"$f":"I13+I11+I9","v":1.1581355514},{"$f":"J13+J11+J9","v":8.7788194444444453E-2},null,"Labour",{"$f":"I54*1000000/(I4*365*$C$4)","v":8.7147563724596875},"€/tclk",6.4079090973968285,"€/tcem",{"$f":"J54*1000000/(J4*365*$C$4)","v":11.093947930502544},"€/tclk",8.1573146547812811,"€/tcem"]
[null,"Discounted_cash_flow_rate",{"$f":"C14*C12+C15*C13","v":0.08},null,null,null,"CO2 emissions (total indirect)","kgCO2/tclk",{"$f":"I14+I12+I10","v":34.5578},{"$f":"J14+J12+J10","v":2.62},null,"Insur. and loc. tax",{"$f":"I44*1000000/(I4*365*$C$4)","v":4.2221022641777148},"€/tclk",3.1044869589542019,"€/tcem",{"$f":"J44*1000000/(J4*365*$C$4)","v":9.2964404347838006},"€/tclk",6.8356179667527943,"€/tcem"]
[null,"DCF_and_inflation",{"$f":"C16-C10","v":0.08},null,null,null,"CO2 emissions (total: direct + indirect)","kgCO2/s",{"$f":"I15+I7","v":29.496728351400002},{"$f":"J15+J7","v":1.0877881944444445},null,"Maintenance cost",{"$f":"I46*1000000/(I4*365*$C$4)","v":5.2776278302221442},"€/tclk",3.8806086986927526,"€/tcem",{"$f":"J46*1000000/(J4*365*$C$4)","v":11.620550543479752},"€/tclk",8.5445224584409925,"€/tcem"]
[null,null,null,null,null,null,"CO2 emissions (total: direct + indirect)","kgCO2/tclk",{"$f":"I16+I8","v":880.15780000000007},{"$f":"J16+J8","v":32.464559585492225},null,"Fixed Opex",{"$f":"SUM(M15:M17)","v":18.214486466859547},"€/tclk",13.393004755043783,"€/tcem",{"$f":"SUM(Q15:Q17)","v":32.010938908766093},"€/tclk",23.537455079975068,"€/tcem"]
[null,{"$f":"IF(AND('Economic balance'!L1<10^-5,'Economic balance'!Y1<10^-5),\"OK\",\"CONVERGENCE NOT ACHIEVED, PLEASE CLICK ON ''Calculate the Cost of Clinker (COC)''\")","v":"OK"},null,null,null,"Capex and Opex",null,null,null,null,null,"Cement kiln",{"$f":"M21*I26/I35","v":20.567112027317364},"€/tclk",15.122876490674532,"€/tcem",{"$f":"Q21*J26/J35","v":21.11017265792584},"€/tclk",15.522185777886646,"€/tcem"]
[null,null,null,null,null,"CAPEX","Total direct costs including process contingency (TDC)","M€",{"$f":"145.5/567.3*580.2+1.01","v":149.81856689582233},{"$f":"145.5/567.3*580.2+1.01","v":149.81856689582233},null,"CO2 capture system",{"$f":"M21*I34/I35","v":0},"€/tclk",0,"€/tcem",{"$f":"Q21*J34/J35","v":25.362884969183405},"€/tclk",18.64918012439956,"€/tcem"]
[null,null,null,null,null,null,"Indirect costs","(% of TDC)",0.14000000000000001,0.14000000000000001,null,"Capex",{"$f":"M22-M18-M14","v":20.567112027317364},"€/tclk",15.122876490674532,"€/tcem",{"$f":"Q22-Q18-Q14","v":46.473057627109242},"€/tclk",34.171365902286205,"€/tcem"]
[null,null,null,null,null,null,"Eng. Proc. Constr. (EPC)","M€",{"$f":"I20*(1+I21)","v":170.79316626123747},{"$f":"J20*(1+J21)","v":170.79316626123747},null,"Cost of Clinker/Cement (COC)",{"$f":"'Economic balance'!Breakeven_selling_price_base","v":69.629170894176909},"€/tclk",51.197919775130075,"€/tcem",{"$f":"Breakeven_selling_price_capt","v":119.96263301255928},"€/tclk",88.207818391587693,"€/tcem"]
[null,null,null,null,null,null,"Owner's costs","(% of TDC)",7.0000000000000007E-2,7.0000000000000007E-2]
[null,null,null,null,null,null,"Project Conting.","(% of TDC)",0.15,0.15,null,"Cost breakdown of CO2 avoided"]
[null,null,null,null,null,null,"Owner's costs & Conting.","M€",{"$f":"I20*(I23+I24)","v":32.96008471708091},{"$f":"J20*(J23+J24)","v":32.96008471708091},null,"Fuel",{"$f":"(Q6-M6)/($I$8+$I$10+$I$12-$J$8-$J$10-$J$12)*10^3","v":24.295345318466133},"€/tCO2"]
[null,null,null,null,null,null,"Total plant cost (TPC)","M€",{"$f":"I25+I22","v":203.75325097831839},{"$f":"J22+J25","v":203.75325097831839},null,"Electricity",{"$f":"(Q7-M7)/($I$8+$I$10+$I$12-$J$8-$J$10-$J$12)*10^3","v":-8.3548973406191482},"€/tCO2"]
[null,null,null,null,null,null,"CO2 capture plant:",null,null,null,null,"Steam",{"$f":"(Q8-M8)/($I$8+$I$10+$I$12-$J$8-$J$10-$J$12)*10^3","v":0},"€/tCO2"]
[null,null,null,null,null,null,"Total direct costs including process contingency (TDC)","M€",0,180,null,"Other variable costs",{"$f":"((Q13+Q5+Q12)-(M13+M5+M12))/($I$8+$I$10+$I$12-$J$8-$J$10-$J$12)*10^3","v":4.6007208906053867},"€/tCO2"]
[null,null,null,null,null,null,"Indirect costs ","(% of TDC)",0.14000000000000001,0.14000000000000001,null,"Variable Opex",{"$f":"SUM(M25:M28)","v":20.54116886845237},"€/tCO2"]
[null,null,null,null,null,null,"Eng. Proc. Constr. (EPC)","M€",{"$f":"I28*(1+I29)","v":0},{"$f":"J28*(1+J29)","v":205.20000000000002},null,"Fixed Opex",{"$f":"(Q18-M18)/($I$8+$I$10+$I$12-$J$8-$J$10-$J$12)*10^3","v":16.275288965570031},"€/tCO2"]
[null,null,null,null,null,null,"Owner's costs","(% of TDC)",7.0000000000000007E-2,7.0000000000000007E-2,null,"Capex",{"$f":"(Q21-M21)/($I$8+$I$10+$I$12-$J$8-$J$10-$J$12)*10^3","v":30.560519259448501},"€/tCO2"]
[null,null,null,null,null,null,"Project Conting.","(% of TDC)",0.15,0.15,null,"Cost of avoided CO2 (CAC)",{"$f":"SUM(M29:M31)","v":67.376977093470899},"€/tCO2"]
[null,null,null,null,null,null,"Owner's costs & Project Conting.","M€",{"$f":"I28*(I31+I32)","v":0},{"$f":"J28*(J32+J31)","v":39.6}]
[null,null,null,null,null,null,"Total plant cost (TPC)","M€",{"$f":"I33+I30","v":0},{"$f":"J33+J30","v":244.8}]
[null,null,null,null,null,null,"TPC cement kiln and capture system","M€",{"$f":"I34+I26","v":203.75325097831839},{"$f":"J34+J26","v":448.55325097831837}]
[null,null,null,null,null,"OPEX","Carbon Tax","€/tCO2",8]
[null,null,null,null,null,null,"Cost of direct CO2 emissions","€/tclk",{"$f":"I36*I8/1000","v":6.7648000000000001},{"$f":"I36*J8/1000","v":0.23875647668393782}]
[null,null,null,null,null,null,"Cost of CO2 emissions from electricity","€/tclk",{"$f":"('Utilities & Consumables'!K19-'Utilities & Consumables'!C5)*'Utilities & Consumables'!E5","v":0.2764623999999995},{"$f":"('Utilities & Consumables'!K19-'Utilities & Consumables'!C5)*'Utilities & Consumables'!F5","v":2.0959999999999965E-2}]
[null,null,null,null,null,null,"Cost of CO2 emissions from steam","€/tclk",{"$f":"('Utilities & Consumables'!K29-'Utilities & Consumables'!C6)*'Utilities & Consumables'!E6","v":0},{"$f":"('Utilities & Consumables'!K29-'Utilities & Consumables'!C6)*'Utilities & Consumables'!F6","v":0}]
[null,null,null,null,null,null,"Total consumables","€/tclk",{"$f":"'Utilities & Consumables'!L3","v":22.718309999999995},{"$f":"'Utilities & Consumables'!M3","v":40.130920000000003}]
[null,null,null,null,null,null,"Other variable O&M","€/tcem",0.8,0.8]
[null,null,null,null,null,null,"Other variable O&M","€/tclk",{"$f":"I41*I5","v":1.0880000000000001},{"$f":"J41*J5","v":1.0880000000000001}]
[null,null,null,null,null,null,"Insur. and loc. tax","(% of TPC)",0.02,0.02]
[null,null,null,null,null,null,"Insur. and loc. tax","M€/year",{"$f":"I43*I35","v":4.0750650195663676},{"$f":"J43*J35","v":8.9710650195663675}]
[null,null,null,null,null,null,"Maintenance cost","(% of TPC)",2.5000000000000001E-2,2.5000000000000001E-2]
[null,null,null,null,null,null,"Maintenance cost","M€/year",{"$f":"I45*I35","v":5.0938312744579601},{"$f":"J45*J35","v":11.213831274457959}]
[null,null,null,null,null,null,"Number of persons","persons",100,120]
[null,null,null,null,null,null,"Cost of labour","k€/year per person",60,60]
[null,null,null,null,null,null,"Operating labour","M€/year",{"$f":"I47*I48*10^3/10^6","v":6},{"$f":"J47*J48*10^3/10^6","v":7.2}]
[null,null,null,null,null,null,"Maintenance labour","(% of Maintenance cost)",0.4,0.4]
[null,null,null,null,null,null,"Maintenance labour","M€/year",{"$f":"I50*I46","v":2.0375325097831842},{"$f":"J50*J46","v":4.4855325097831837}]
[null,null,null,null,null,null,"Administrative and support labour","(% Oper. And maintenance labour cost)",0.3,0.3]
[null,null,null,null,null,null,"Administrative and support labour","M€/year",{"$f":"I52*(I51+I49)","v":2.4112597529349551},{"$f":"J52*(J51+J49)","v":3.5056597529349549}]
[null,null,null,null,null,null,"Labour cost","M€/year",{"$f":"I53+I49","v":8.4112597529349546},{"$f":"J53+J49","v":10.705659752934956}]

{"sheet":"Sensitivity","index":4,"n_rows":36,"n_cols":16,"rows_kept":36,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Reference values:"]
[null,"Fuel cost:",3,"€/GJLHV"]
[null,"Electricity price:",58.1,"€/MWhe"]
[null,"Carbon tax:",8,"€/tCO2"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[]
[]
[]
[]
[]
[null,"Variation of Fuel Cost"]
[null,"Delta %",-50,0,50]
[null,"Fuel Cost, €/GJLHV",1.5,3,4.5]
[null,"Cost of cement with CO2 capture, €/tcem",77.178406626881824,88.207818391587693,99.237230156293606]
[null,"Cost of cement in referance case, €/tcem",47.740199186894827,51.19791977513011,54.655640363365414]
[null,"Cost of CO2 avoided, €/tCO2",55.22930443423779,67.376977093470856,79.524649752703937]
[null,"Variation of Electricity Price"]
[null,"Delta %",-30,0,30]
[null,"Electricity price, €/MWhe",40.67,58.1,75.53]
[null,"Cost of cement with CO2 capture, €/tcem",88.079656626881842,88.207818391587708,88.335980156293587]
[null,"Cost of cement in referance case, €/tcem",49.507466098659556,51.197919775130075,52.888373451600657]
[null,"Cost of CO2 avoided, €/tCO2",69.883446295656569,67.376977093470913,64.870507891285172]
[null,"Variation of Carbon tax"]
[null,"Delta, €/tCO2",-8,7,22]
[null,"Carbon tax, €/tCO2",0,15,30]
[null,"Cost of cement with CO2 capture, €/tcem",88.01685039402598,88.374915389454216,88.732980384882424]
[null,"Cost of cement in referance case, €/tcem",46.020520951600666,55.728143745718313,65.435766539835967]
[null,"Variation of CAPEX"]
[null,"min/base/max, %",-15,0,30]
[null,"CAPEX cement kiln without capture, M€",173.19026333157063,203.75325097831839,264.87922627181393]
[null,"CAPEX cement kiln with capture, M€",381.27026333157062,448.55325097831837,583.11922627181389]
[null,"Cost of cement with CO2 capture, €/tcem",80.621097733888135,88.207818391587708,103.38125970698677]
[null,"Cost of cement in referance case, €/tcem",47.811872996305397,51.197919775130131,57.970013332779494]
[null,"Cost of CO2 avoided, €/tCO2",60.637609356533034,67.376977093470842,80.855712567346444]

{"sheet":"Economic balance","index":5,"n_rows":33,"n_cols":25,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
["Breakeven selling price","€/tclk",69.629170894176909,119.96263301255928,null,null,null,null,null,null,null,{"$f":"MIN(ABS(INDIRECT(\"L7\"):INDIRECT(CONCATENATE(\"L\",6+Operational_life+Construction_time-1))))","v":3.6859404417555197E-14},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MIN(ABS(INDIRECT(\"Y7\"):INDIRECT(CONCATENATE(\"Y\",6+Operational_life+Construction_time-1))))","v":2.1316282072803006E-14}]
[null,"€/tcement",{"$f":"Breakeven_selling_price_base/'Economic and CO2 Emission Data'!I5","v":51.197919775130075},{"$f":"Breakeven_selling_price_capt/'Economic and CO2 Emission Data'!J5","v":88.207818391587693}]
["Cost of CO2","€/tCO2",{"$f":"(Breakeven_selling_price_capt-Breakeven_selling_price_base)/('Economic and CO2 Emission Data'!I18-'Economic and CO2 Emission Data'!J18)*1000","v":59.37697709347092}]
[]
["Year","% Constr. Cement plant","% Constr. Capt. Plant","Availability [h]","Clinker production [t]","Expense [M€]","Revenues [M€]","Deprec. [M€]","Taxable [M€]","Taxes [M€]","Discount. CF [M€]","Prog. DCF [M€]",null,"Year","% Constr. Cement plant","% Constr. Capt. Plant","Availability [h]","Clinker production [t]","Expense [M€]","Revenues [M€]","Deprec. [M€]","Taxable [M€]","Taxes [M€]","Discount. CF [M€]","Prog. DCF [M€]"]
[-2,null,0.4,null,null,{"$f":"B6*TPC_cem_base+C6*TPC_capt_base","v":0},null,null,0,0,{"$f":"(G6-J6-F6)*((1+Discounted_cash_flow_rate-Construction_inflat.)^(-A6))","v":0},{"$f":"K6","v":0},null,-2,null,0.4,null,null,{"$f":"O6*TPC_cem+P6*TPC_capt","v":97.920000000000016},null,null,0,0,{"$f":"(T6-W6-S6)*((1+Discounted_cash_flow_rate-Construction_inflat.)^(-N6))","v":-114.21388800000003},{"$f":"X6","v":-114.21388800000003}]
[-1,0.5,0.3,null,null,{"$f":"B7*TPC_cem_base+C7*TPC_capt_base","v":101.8766254891592},null,null,0,0,{"$f":"(G7-J7-F7)*((1+Discounted_cash_flow_rate-Construction_inflat.)^(-A7))","v":-110.02675552829194},{"$f":"K7+L6","v":-110.02675552829194},null,-1,0.5,0.3,null,null,{"$f":"O7*TPC_cem+P7*TPC_capt","v":175.31662548915921},null,null,0,0,{"$f":"(T7-W7-S7)*((1+Discounted_cash_flow_rate-Construction_inflat.)^(-N7))","v":-189.34195552829195},{"$f":"X7+Y6","v":-303.55584352829197}]
[0,0.5,0.3,null,null,{"$f":"B8*TPC_cem_base+C8*TPC_capt_base","v":101.8766254891592},null,null,0,0,{"$f":"(G8-J8-F8)*((1+Discounted_cash_flow_rate-Construction_inflat.)^(-A8))","v":-101.8766254891592},-211.90338101745112,null,0,0.5,0.3,null,null,{"$f":"O8*TPC_cem+P8*TPC_capt","v":175.31662548915921},null,null,0,0,{"$f":"(T8-W8-S8)*((1+Discounted_cash_flow_rate-Construction_inflat.)^(-N8))","v":-175.31662548915921},-478.87246901745118]
[1,null,null,{"$f":"8760*Capacity_factor","v":8000},{"$f":"D9/24*Clinker_production_ref","v":965174.4},{"$f":"(Total_consumables_base+Other_variable_OeM_base+Carbon_Tax_base+Carbon_Tax_base_el+Carbon_Tax_base_steam)*E9/1000000+Insur_and_loc_tax_base+Maintenance_cost_base+Labour_cost_base","v":47.353443229585842},{"$f":"Breakeven_selling_price_base*E9/1000000","v":67.20429324028467},{"$f":"IF(A9+1>Depreciation_time,0,(TPC_cem_base+TPC_capt_base)/Depreciation_time)","v":0},{"$f":"G9-H9-F9","v":19.850850010698828},{"$f":"I9*Tax_rate","v":0},{"$f":"(G9-J9-F9)*((1+DCF_and_inflation)^(-A9))","v":18.380416676572988},-193.52296434087813,null,1,null,null,{"$f":"8760*Capacity_factor","v":8000},{"$f":"Q9/24*Clinker_production_ref","v":965174.4},{"$f":"(Total_consumables_capt+Other_variable_OeM_capt+Carbon_Tax_capt+Carbon_Tax_capt_el+Carbon_Tax_capt_steam)*R9/1000000+Insur_and_loc_tax_capt+Maintenance_cost_capt+Labour_cost_capt","v":70.92467412116082},{"$f":"Breakeven_selling_price_capt*R9/1000000","v":115.7848623403171},{"$f":"IF(N9+1>Depreciation_time,0,(TPC_cem+TPC_capt)/Depreciation_time)","v":0},{"$f":"T9-U9-S9","v":44.860188219156285},{"$f":"V9*Tax_rate","v":0},{"$f":"(T9-W9-S9)*((1+DCF_and_inflation)^(-N9))","v":41.537211314033591},-437.3352577034176]
[2,null,null,8000,965174.4,47.353443229585842,67.20429324028467,0,19.850850010698828,0,17.018904330160172,-176.50406001071795,null,2,null,null,8000,965174.4,70.92467412116082,115.7848623403171,0,44.860188219156285,0,38.460380846327404,-398.87487685709021]
[3,null,null,8000,965174.4,47.353443229585842,67.20429324028467,0,19.850850010698828,0,15.758244750148307,-160.74581526056966,null,3,null,null,8000,965174.4,70.92467412116082,115.7848623403171,0,44.860188219156285,0,35.611463746599448,-363.26341311049077]
[4,null,null,8000,965174.4,47.353443229585842,67.20429324028467,0,19.850850010698828,0,14.590967361248433,-146.15484789932123,null,4,null,null,8000,965174.4,70.92467412116082,115.7848623403171,0,44.860188219156285,0,32.973577543147634,-330.28983556734312]
[5,null,null,8000,965174.4,47.353443229585842,67.20429324028467,0,19.850850010698828,0,13.510154964118918,-132.6446929352023,null,5,null,null,8000,965174.4,70.92467412116082,115.7848623403171,0,44.860188219156285,0,30.531090317729287,-299.75874524961381]
[6,null,null,8000,965174.4,47.353443229585842,67.20429324028467,0,19.850850010698828,0,12.509402744554551,-120.13529019064775,null,6,null,null,8000,965174.4,70.92467412116082,115.7848623403171,0,44.860188219156285,0,28.269528071971557,-271.48921717764227]
[7,null,null,8000,965174.4,47.353443229585842,67.20429324028467,0,19.850850010698828,0,11.582780319031993,-108.55250987161575,null,7,null,null,8000,965174.4,70.92467412116082,115.7848623403171,0,44.860188219156285,0,26.175488955529222,-245.31372822211304]
[8,null,null,8000,965174.4,47.353443229585842,67.20429324028467,0,19.850850010698828,0,10.72479659169629,-97.827713279919465,null,8,null,null,8000,965174.4,70.92467412116082,115.7848623403171,0,44.860188219156285,0,24.23656384771224,-221.07716437440081]
[9,null,null,8000,965174.4,47.353443229585842,67.20429324028467,0,19.850850010698828,0,9.9303672145336019,-87.897346065385861,null,9,null,null,8000,965174.4,70.92467412116082,115.7848623403171,0,44.860188219156285,0,22.441262821955778,-198.63590155244503]
[10,null,null,8000,965174.4,47.353443229585842,67.20429324028467,0,19.850850010698828,0,9.1947844579014824,-78.702561607484384,null,10,null,null,8000,965174.4,70.92467412116082,115.7848623403171,0,44.860188219156285,0,20.778947057366459,-177.85695449507858]
[11,null,null,8000,965174.4,47.353443229585842,67.20429324028467,0,19.850850010698828,0,8.5136893128717421,-70.188872294612636,null,11,null,null,8000,965174.4,70.92467412116082,115.7848623403171,0,44.860188219156285,0,19.239765793857835,-158.61718870122075]
[12,null,null,8000,965174.4,47.353443229585842,67.20429324028467,0,19.850850010698828,0,7.8830456600664274,-62.305826634546207,null,12,null,null,8000,965174.4,70.92467412116082,115.7848623403171,0,44.860188219156285,0,17.814597957275769,-140.80259074394499]
[13,null,null,8000,965174.4,47.353443229585842,67.20429324028467,0,19.850850010698828,0,7.2991163519133586,-55.006710282632852,null,13,null,null,8000,965174.4,70.92467412116082,115.7848623403171,0,44.860188219156285,0,16.494998108588675,-124.30759263535631]
[14,null,null,8000,965174.4,47.353443229585842,67.20429324028467,0,19.850850010698828,0,6.7584410665864425,-48.24826921604641,null,14,null,null,8000,965174.4,70.92467412116082,115.7848623403171,0,44.860188219156285,0,15.273146396841364,-109.03444623851495]
[15,null,null,8000,965174.4,47.353443229585842,67.20429324028467,0,19.850850010698828,0,6.2578158023948527,-41.990453413651558,null,15,null,null,8000,965174.4,70.92467412116082,115.7848623403171,0,44.860188219156285,0,14.141802219297556,-94.892644019217386]
[16,null,null,8000,965174.4,47.353443229585842,67.20429324028467,0,19.850850010698828,0,5.7942738911063456,-36.196179522545215,null,16,null,null,8000,965174.4,70.92467412116082,115.7848623403171,0,44.860188219156285,0,13.094261314164406,-81.798382705052973]
[17,null,null,8000,965174.4,47.353443229585842,67.20429324028467,0,19.850850010698828,0,5.3650684176910612,-30.831111104854152,null,17,null,null,8000,965174.4,70.92467412116082,115.7848623403171,0,44.860188219156285,0,12.124316031633709,-69.674066673419262]
[18,null,null,8000,965174.4,47.353443229585842,67.20429324028467,0,19.850850010698828,0,4.9676559423065374,-25.863455162547616,null,18,null,null,8000,965174.4,70.92467412116082,115.7848623403171,0,44.860188219156285,0,11.226218547808987,-58.447848125610278]
[19,null,null,8000,965174.4,47.353443229585842,67.20429324028467,0,19.850850010698828,0,4.5996814280616087,-21.263773734486008,null,19,null,null,8000,965174.4,70.92467412116082,115.7848623403171,0,44.860188219156285,0,10.394646803526841,-48.053201322083439]
[20,null,null,8000,965174.4,47.353443229585842,67.20429324028467,0,19.850850010698828,0,4.2589642852422296,-17.00480944924378,null,20,null,null,8000,965174.4,70.92467412116082,115.7848623403171,0,44.860188219156285,0,9.6246729662285553,-38.42852835585488]
[21,null,null,8000,965174.4,47.353443229585842,67.20429324028467,0,19.850850010698828,0,3.9434854492983611,-13.061323999945419,null,21,null,null,8000,965174.4,70.92467412116082,115.7848623403171,0,44.860188219156285,0,8.9117342279894025,-29.516794127865477]
[22,null,null,8000,965174.4,47.353443229585842,67.20429324028467,0,19.850850010698828,0,3.6513754160170002,-9.4099485839284185,null,22,null,null,8000,965174.4,70.92467412116082,115.7848623403171,0,44.860188219156285,0,8.2516057666568532,-21.265188361208622]
[23,null,null,8000,965174.4,47.353443229585842,67.20429324028467,0,19.850850010698828,0,3.3809031629787043,-6.0290454209497142,null,23,null,null,8000,965174.4,70.92467412116082,115.7848623403171,0,44.860188219156285,0,7.6403757098674578,-13.624812651341164]
[24,null,null,8000,965174.4,47.353443229585842,67.20429324028467,0,19.850850010698828,0,3.1304658916469479,-2.8985795293027663,null,24,null,null,8000,965174.4,70.92467412116082,115.7848623403171,0,44.860188219156285,0,7.0744219535809787,-6.5503906977601858]
[25,null,null,8000,965174.4,47.353443229585842,67.20429324028467,0,19.850850010698828,0,2.8985795293027294,-3.6859404417555197E-14,null,25,null,null,8000,965174.4,70.92467412116082,115.7848623403171,0,44.860188219156285,0,6.5503906977601645,-2.1316282072803006E-14]