{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Documentation","Dashboard","Tornado","Process model","Equipment sizing","Equipment costs","CapEx","OpEx & Rev","Cash flow","Constants"],"not_rendered":{"charts":7,"images":4,"macros":1,"external_links":0,"defined_names":49,"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":"Documentation","index":0,"n_rows":46,"n_cols":3,"rows_kept":46,"cut":false,"hidden":false,"merged":[[0,1,0,2],[1,1,1,2],[2,1,2,2],[3,1,3,2]]}
[null,"Note from Cyclotron Road"]
[null,"This model accompanies the screencast series 'Techonomics - Introduction to Cost Modeling in Excel'. The purpose of the series is to (1) educate innovators about cost modeling and (2) provide templates to help innovators start developing their own models. The best practices and techniques demonstrated are realistic, however, the exact numbers and example chemical/manufacturing processes may not be."]
[null,"This model was developed by Chris Burk of Burk Engineering LLC. Chris is a chemical engineer and an independent consultant. He works with companies that are developing or investing in new process-related technologies - helping them connect science, engineering, and business through techno-economic modeling.\n"]
[null,"Chris Burk PE  |  cburk@BurkEngineeringLLC.com  |  www.BurkEngineeringLLC.com"]
["Documentation"]
[null,"This page provides information about the model  - including important cost estimation techniques, important assumptions, and model structure."]
[]
[null,"1. Model info"]
[null,"Name","SuperSpin 2.0 - Techno-economic model"]
[null,"Purpose","To evaluate Plastic Co.'s improved SuperSpin polymer synthesis process for further R&D and scale-up investment."]
[null,"Version","1.3"]
[null,"Date","2018-05-19"]
[null,"Primary developer","J. Doe  /  Plastic Co.  /  jdoe@PlasticCo.com"]
[null,"Checked/approved by","R. Doe  /  Plastic Co."]
[null,"User input modification","All user input cells are shaded grey. Users should feel free to modify these values, however, entering certain values or combinations of values may result in unrealistic results. The user should contact the developer if they have concerns about the validity of input values or results. "]
[]
[]
[]
[]
[null,"2. Technology modeling approach"]
[null,"Key innovation(s)","Polymerization catalyst, Reactor"]
[null,"State of development","TRL 5 - Complete process has been demonstrated at the laboratory scale."]
[null,"Process description","Monomer gas, hydrogen gas, and solid catalyst are the only raw materials for the process. Monomer and hydrogen gas are fed to a reactor which is at elevated temperature and pressure (approx. 80C and 5bar). The reactor contains a fluidized bed of catalyst particles. The monomer and hydrogen react to form solid polymer, which is continuously removed from the bottom of the reactor. Unreacted monomer and hydrogen are continuously recycled using a compressor. A water-cooled heat exchanger on the recycle line removes excess heat from compression. Downstream of the reactor, the polymer product is separated from any remaining monomer and hydrogen."]
[null,"Important assumptions","Energy for heating monomer, hydrogen, and catalyst feed streams is provided by heat produced by the polymerization reaction.\nRecycle stream leaves heat exchanger at  reactor temperature.\nIt is unnecessary to separate remaining solid catalyst from product.\nAll hydrogen feed reacts. (Polymer length is controlled by the amount of hydrogen fed to reactor.)\nMonomer supply, hydrogen supply, catalyst supply, and product storage are available on site."]
[]
[]
[]
[]
[null,"3. CapEx estimation approach"]
[null,"Scope of estimate","Estimate includes installation of the process plant at an exiting facility, which already has auxiliary buildings, utilities, raw material supply, and product storage available."]
[null,"Method","Factored major equipment cost estimate based on material balance"]
[null,"Expected accuracy","- 30% to +40%"]
[null,"References","Quote for Reactor Vessel from fabricator (#123456)\nCost breakdown data from construction of SuperSpin 1.0 Plant in 2014\nPlant Design and Economics for Chemical Engineers (Fifth Edition), by Peters, Timmerhaus, and West"]
[]
[]
[]
[]
[null,"4. OpEx estimation approach"]
[null,"Method","Factored estimate based on material balance and CapEx"]
[null,"Expected accuracy","- 30% to +40%"]
[null,"References","Vendor quotes for monomer, hydrogen, and catalyst raw materials\nOperating data for existing SuperSpin 1.0 Plant\nPlant Design and Economics for Chemical Engineers (Fifth Edition), by Peters, Timmerhaus, and West"]
[]
[]
[]
[]
[null,"5. Overall model structure"]

{"sheet":"Dashboard","index":1,"n_rows":24,"n_cols":11,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
["Techno-economic model - Polymer synthesis"]
[null,"This is a model for a new super-polymer synthesis method."]
[]
[null,"Process parameters",null,null,null,null,null,"Financial results"]
[null,"Production rate",null,null,500,"t/yr",null,"CapEx",null,{"$f":"Total_Capital/10^6","v":2.455934575287237},"MM"]
[null,"Utilization",null,null,0.95,null,null,"OpEx less depreciation",null,{"$f":"OpEx_without_depr/Production_Rate/10^3","v":3.5822738296183374},"/kg product"]
[null,"Overall conversion (reactor yield)",null,null,0.95,"of monomer",null,"Revenue",null,{"$f":"Revenue/Production_Rate/10^3","v":7},"/kg product"]
[null,"Separation yield",null,null,0.98,null,null,{"$f":"IF(EqCapacityRangeCheck,\"( Equipment size is within cost correlation range. )\",\"Warning: Equipment size is outside cost correlation range.\")","v":"( Equipment size is within cost correlation range. )"}]
[]
[]
[null,"Reaction parameters",null,null,null,null,null,"Profitability metrics"]
[null,"Single pass conversion",null,null,0.04,"of monomer",null,"All-in cost",null,{"$f":"OpEx_with_depr/Production_Rate/10^3","v":4.0093928861900316},"/kg product"]
[null,"Catalyst dosing",null,null,1E-3,"kg/kg monomer",null,"Payback period",null,{"$f":"SimplePayback","v":2.7562833343919424},"years"]
[null,"Reactor pressure",null,null,5,"bar"]
[null,"Reactor pressure drop",null,null,1,"bar"]
[]
[]
[null,"Costs"]
[null,"Polymer product",null,null,7000,"/t"]
[null,"Catalyst",null,null,1150,"/t"]
[null,"Monomer",null,null,1050,"/t"]
[null,"Hydrogen",null,null,2100,"/t"]
[null,"Electrical power",null,null,0.11,"/kWh"]
[null,"Cost per operator",null,null,72000,"/yr"]

{"sheet":"Tornado","index":2,"n_rows":75,"n_cols":13,"rows_kept":75,"cut":false,"hidden":false,"merged":[[17,9,17,10]]}
["Tornado diagram sensitivity analysis"]
[" "]
[]
[null,null,null,null,null,null,null,"Settings","Worst","Expected","Best","Units","Reference"]
[null,null,null,null,null,null,null,{"$f":"Dashboard!B6","v":"Utilization"},0.9,0.95,0.98,"-",{"$f":"Dashboard!E6","v":0.95}]
[null,null,null,null,null,null,null,"Overall conversion",0.9,0.95,0.97,"of monomer",{"$f":"Dashboard!E7","v":0.95}]
[null,null,null,null,null,null,null,{"$f":"Dashboard!B8","v":"Separation yield"},0.95,0.98,0.99,"-",{"$f":"Dashboard!E8","v":0.98}]
[null,null,null,null,null,null,null,{"$f":"Dashboard!B12","v":"Single pass conversion"},0.03,0.04,7.0000000000000007E-2,{"$f":"Dashboard!F12","v":"of monomer"},{"$f":"Dashboard!E12","v":0.04}]
[null,null,null,null,null,null,null,{"$f":"Dashboard!B13","v":"Catalyst dosing"},1.5E-3,1E-3,8.0000000000000004E-4,"kg/kg monomer",{"$f":"Dashboard!E13","v":1E-3}]
[null,null,null,null,null,null,null,{"$f":"Dashboard!B14","v":"Reactor pressure"},4,5,5.5,"bar",{"$f":"Dashboard!E14","v":5}]
[null,null,null,null,null,null,null,"Polymer price",13500,14100,14600,"/t",{"$f":"Dashboard!E19","v":7000}]
[null,null,null,null,null,null,null,"Monomer price",1155,1050,945,"/t",{"$f":"Dashboard!E21","v":1050}]
[null,null,null,null,null,null,null,"Catalyst price",2310,2100,1890,"/t",{"$f":"Dashboard!E22","v":2100}]
[null,null,null,null,null,null,null,"Operator cost",76000,74000,72000,"/yr",{"$f":"Dashboard!E24","v":72000}]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Metric:","All-in cost , $/kg"]
[]
[]
[null,null,null,null,null,null,null,"User instructions:"]
[null,null,null,null,null,null,null,"1.  In 'Settings' table, enter best-case, expected-case, and worst-case values for each parameter."]
[null,null,null,null,null,null,null,"2.  Select output metric from drop down menu below table."]
[null,null,null,null,null,null,null,"3.  Click 'Refresh Tornado' button."]
[null,null,null,null,null,null,null,"4.  Customize chart format if desired."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Software Copyright 2017 Burk Engineering LLC"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"Tornado data & settings"]
[]
[null,null,null,null,null,null,null,"Results","Reference","Higher = better"]
[null,null,null,null,null,null,null,"NPV, MMUSD",{"$f":"NPV","v":3.5575667203713488},1]
[null,null,null,null,null,null,null,"IRR",{"$f":"IRR","v":0.36224523495016192},1]
[null,null,null,null,null,null,null,"Total capital, MMUSD",{"$f":"Dashboard!J5","v":2.455934575287237},0]
[null,null,null,null,null,null,null,"Simple payback, years",{"$f":"Dashboard!J13","v":2.7562833343919424},1]
[null,null,null,null,null,null,null,"All-in cost , $/kg",{"$f":"Dashboard!J12","v":4.0093928861900316},0]
[]
[]
[null,null,null,null,null,null,null,"Use: Index",{"$f":"MATCH(J18,$H$52:$H$57,0)","v":5}]
[null,null,null,null,null,null,null,"Value",{"$f":"INDEX($I$52:$I$57,I59)","v":4.0093928861900316}]
[null,null,null,null,null,null,null,"Format",{"$f":"CELL(\"format\",INDEX($I$52:$I$57,I59))","v":"C2-"}]
[]
[null,null,null,null,null,null,null,"Metric","Higher = better","Reference"]
[null,null,null,null,null,null,null,{"$f":"J18","v":"All-in cost , $/kg"},{"$f":"INDEX(J52:J57,MATCH(T_Metric,H52:H57,0))","v":0},{"$f":"Tornado!I60","v":4.0093928861900316}]
[null,null,null,null,null,null,null,"Input","Low ","High"]
[null,null,null,null,null,null,null,"Polymer price",4.0671754948856833,4.0671754948856833]
[null,null,null,null,null,null,null,"Catalyst price",4.0671773582248134,4.0671736315465532]
[null,null,null,null,null,null,null,"Catalyst dosing",4.0678468106752002,4.0669069685698762]
[null,null,null,null,null,null,null,"Utilization",4.0946973083574933,4.0518263695657017]
[null,null,null,null,null,null,null,"Separation yield",4.1216259235849879,4.0497292827408877]
[null,null,null,null,null,null,null,"Operator cost",4.124958103581335,4.0093928861900316]
[null,null,null,null,null,null,null,"Overall conversion",4.1670785601405438,4.0270058179771926]
[null,null,null,null,null,null,null,"Reactor pressure",4.1816693993739618,4.0239176482700314]
[null,null,null,null,null,null,null,"Monomer price",4.1897635955800281,3.9445873941913385]
[null,null,null,null,null,null,null,"Single pass conversion",4.2185470081462624,3.848762561551089]

{"sheet":"Process model","index":3,"n_rows":92,"n_cols":13,"rows_kept":92,"cut":false,"hidden":false,"merged":[]}
["Process model"]
[null,"This page uses user input and material balance calculations to develop a stream table for the polymer synthesis process."]
[]
[]
[null,"General process parameters",null,null,null,null,"Important rates"]
[null,"Production rate",null,{"$f":"Dashboard!E5","v":500},"t/yr",null,"Product",null,{"$f":"I89/kg_per_t*s_per_yr","v":500},"t/yr"]
[null,"Overall conversion",null,{"$f":"Dashboard!E7","v":0.95},"of monomer",null,"Catalyst",null,{"$f":"I90/kg_per_t*s_per_yr","v":0.53705263161331884},"t/yr"]
[null,"Separation yield",null,{"$f":"Dashboard!E8","v":0.98},null,null,"Monomer",null,{"$f":"I91/kg_per_t*s_per_yr","v":537.05263161331879},"t/yr"]
[null,null,null,null,null,null,"Hydrogen",null,{"$f":"I92/kg_per_t*s_per_yr","v":4.0816000002612228E-3},"t/yr"]
[null,"Reaction parameters",null,null,null,null,"Recycle rate",null,{"$f":"H64/kg_per_t*s_per_yr","v":12217.947369203004},"t/yr"]
[null,"Temperature",null,80,"degC"]
[null,"Pressure",null,{"$f":"Dashboard!E14","v":5},"bar"]
[null,"Polymer length",null,5000,"monomer units ",null,"Process results"]
[null,"Catalyst dosing",null,{"$f":"Dashboard!E13","v":1E-3},"kg/kg monomer",null,"Overall yield",null,{"$f":"Conv_Overall*Product_Loss","v":0.93099999999999994}]
[null,"Single pass conversion",null,{"$f":"Dashboard!E12","v":0.04},"of monomer"]
[]
[null,"Pressure drop"]
[null,"Reactor",null,{"$f":"Dashboard!E15","v":1},"bar"]
[null,"Heat exchanger",null,0.8,"bar"]
[]
[]
[]
[]
[]
["Process flow diagram"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Stream table / material balance"]
[]
[]
[null,"Stream",null,null,1,2,3,4,5,6,7,8,9]
[null,"Description",null,"-","Catalyst feed","Monomer feed","Hydrogen feed","Recycle A","Recycle B","Recycle return","Raw  product","Vent to flare","Product"]
[null,"In / Out",null,"-","in","in","in",null,null,null,null,"out","out"]
[null,"Phase",null,"-","solid","gas","gas","gas","gas","gas"," solid & gas","gas","solid"]
[]
[null,"Temperature",null,"K",{"$f":"T_ambient","v":298},{"$f":"T_ambient","v":298},{"$f":"T_ambient","v":298},{"$f":"T_Reactor","v":353.15},{"$f":"'Equipment sizing'!D72","v":392.70312213234456},{"$f":"H52","v":353.15},{"$f":"T_Reactor","v":353.15},{"$f":"K52","v":353.15},{"$f":"L52","v":353.15}]
[null,"Pressure",null,"bar",{"$f":"J53","v":5},{"$f":"J53","v":5},{"$f":"J53","v":5},{"$f":"P_Reactor-$D$18","v":4},{"$f":"J53+D19","v":5.8},{"$f":"P_Reactor","v":5},{"$f":"D84","v":1.5},{"$f":"P_ambient","v":1},{"$f":"P_ambient","v":1}]
[]
[null,"Gas volume flow rate",null,"m3/s",{"$f":"SUM(E60:E61)*Constant_R*E52/E53","v":0},1.6877926390451875E-3,3.2068060141858557E-7,{"$f":"SUM(H60:H61)*Constant_R*H52/H53","v":5.6879196008359396E-2},4.3620495065319169E-2,4.5503356806687517E-2,3.3335792532371831E-4,5.0003688798557747E-4,0]
[]
[null,null,null," "]
[null,"Mole flow rate",null,"kmol/s",{"$f":"SUM(E59:E62)","v":1.7029827232791699E-7},3.4059654465583397E-4,6.4713343484608452E-8,7.7485713909202234E-3,7.7485713909202234E-3,7.7485713909202234E-3,1.7264838848604236E-5,1.7201419771989321E-5,6.3419076614916278E-8]
[null,"Catalyst",null,null,{"$f":"E65/MW_catalyst","v":1.7029827232791699E-7},null,null,null,null,null,{"$f":"E59","v":1.7029827232791699E-7},{"$f":"K59","v":1.7029827232791699E-7}]
[null,"Monomer ",null,null,null,{"$f":"-I82/Conv_Overall","v":3.4059654465583397E-4},null,{"$f":"I60","v":7.7485713909202234E-3},{"$f":"J60","v":7.7485713909202234E-3},{"$f":"-I82/Conv_SinglePass-F60","v":7.7485713909202234E-3},{"$f":"F60+I82","v":1.702982723279171E-5},{"$f":"K60","v":1.702982723279171E-5}]
[null,"Hydrogen",null,null,null,null,{"$f":"-I83","v":6.4713343484608452E-8}]
[null,"Polymer",null,null,null,null,null,null,null,null,{"$f":"M62/Product_Loss","v":6.4713343484608452E-8},{"$f":"K62-M62","v":1.2942668696921741E-9},{"$f":"D82","v":6.3419076614916278E-8}]
[]
[null,"Mass flow rate",null,"kg/s",{"$f":"SUM(E65:E68)","v":1.7029827232791699E-5},1.70298272327917E-2,1.294266869692169E-7,0.38742856954601118,0.38742856954601118,0.38742856954601118,1.7046986486711459E-2,1.1920904948291601E-3,1.5854895991882299E-2]
[null,"Catalyst",null,null,{"$f":"F66*Catalyst_dosing_rate","v":1.7029827232791699E-5},null,null,null,null,null,{"$f":"K59*MW_catalyst","v":1.7029827232791699E-5},{"$f":"L59*MW_catalyst","v":1.7029827232791699E-5}]
[null,"Monomer ",null,null,null,{"$f":"F60*MW_monomer","v":1.70298272327917E-2},null,{"$f":"H60*MW_monomer","v":0.38742856954601118},{"$f":"I60*MW_monomer","v":0.38742856954601118},{"$f":"J60*MW_monomer","v":0.38742856954601118},{"$f":"K60*MW_monomer","v":8.5149136163958548E-4},{"$f":"L60*MW_monomer","v":8.5149136163958548E-4}]
[null,"Hydrogen",null,null,null,null,{"$f":"G61*MW_H2","v":1.294266869692169E-7}]
[null,"Polymer",null,null,null,null,null,null,null,null,{"$f":"K62*MW_polymer","v":1.6178465297839083E-2},{"$f":"L62*MW_polymer","v":3.2356930595678292E-4},{"$f":"M62*MW_polymer","v":1.5854895991882299E-2}]
[]
[null,"Mass balances checks",null,null,"Reactor:",{"$f":"SUM(H64,K64)-SUM(E64,F64,G64,J64)","v":0},null,"Separator:",{"$f":"SUM(L64,M64)-K64","v":0},null,"Overall:",{"$f":"SUM(L64,M64)-SUM(E64,F64,G64)","v":0}]
[]
[]
[]
[]
[]
[]
["Calculations"]
[]
[]
[null,"General ",null,null,null,null,"Reaction rates"]
[null,"Production rate",null,{"$f":"D6*kg_per_t/s_per_yr","v":1.5854895991882299E-2},"kg/s",null,"Polymer",null,{"$f":"D82/Product_Loss","v":6.4713343484608452E-8},"kmol/s"]
[null,null,null,{"$f":"D81/MW_polymer","v":6.3419076614916278E-8},"kmol/s",null,"Monomer",null,{"$f":"-I81*Length_Polymer","v":-3.2356671742304226E-4},"kmol/s"]
[null,"Reactor temperature",null,{"$f":"D11+273.15","v":353.15},"K",null,"Hydrogen",null,{"$f":"-I81","v":-6.4713343484608452E-8},"kmol/s"]
[null,"Separation pressure",null,1.5,"bar"]
[]
[]
[]
[null,"Molecular weights",null,null,null,null,"Important flow rates"]
[null,"Catalyst",null,100,"g/mol",null,"Product",null,{"$f":"M64","v":1.5854895991882299E-2},"kg/s"]
[null,"Monomer",null,50,"g/mol",null,"Catalyst",null,{"$f":"E64","v":1.7029827232791699E-5},"kg/s"]
[null,"Hydrogen",null,2,"g/mol",null,"Monomer",null,{"$f":"F64","v":1.70298272327917E-2},"kg/s"]
[null,"Polymer",null,{"$f":"MW_monomer*Length_Polymer+MW_H2","v":250002},"g/mol",null,"Hydrogen",null,{"$f":"G64","v":1.294266869692169E-7},"kg/s"]

{"sheet":"Equipment sizing","index":4,"n_rows":78,"n_cols":10,"rows_kept":78,"cut":false,"hidden":false,"merged":[]}
["Equipment sizing"]
[null,"This page uses values from the stream table to calculate the parameters necessary for estimating equipment and utility costs."]
[]
[null,"Summary",null,null,"Reactor","Compressor","Heat exchanger","Separation vessel"]
[null,"Capacity parameter",null,"-","Volume","Power","Area","Volume"]
[null,"Capacity units",null,"-","m3","kW","m2","m3"]
[null,"Capacity",null,"-",{"$f":"D36","v":23.844111221726717},{"$f":"D60","v":13.411624918638752},{"$f":"I60","v":7.7571163926521631},{"$f":"I36","v":1.2632510854372485}]
[]
[null,"Electrical power",null,"kW-h/yr",null,{"$f":"D76","v":117485.83428727547}]
[null,"Cooling water",null,"t/yr",null,null,{"$f":"I70","v":12980.991239839361}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Reactor sizing",null,null,null,null,"Separation vessel sizing"]
[null,"Residence time",null,8,"min",null,"Residence time",null,60,"min"]
[null,"Gas flow rate",null,{"$f":"SUM('Process model'!E55,'Process model'!F55,'Process model'!G55,'Process model'!J55)/Utilization","v":4.9675231711930661E-2},"m3/s",null,"Gas flow rate",null,{"$f":"'Process model'!K55/Utilization","v":3.5090307928812458E-4},"m3/s"]
[]
[null,"Results summary",null,null,null,null,"Calculations"]
[null,"Vessel volume",null,{"$f":"D41","v":23.844111221726717},"m3",null,"Vessel volume",null,{"$f":"I41","v":1.2632510854372485},"m3"]
[null,"Pressure",null,{"$f":"P_Reactor","v":5},"bar",null,"Pressure",null,{"$f":"'Process model'!K53","v":1.5},"bar"]
[]
[null,"Calculations",null,null,null,null,"Calculations"]
[null,"Residence time",null,{"$f":"D32*s_per_min","v":480},"s",null,"Residence time",null,{"$f":"I32*s_per_min","v":3600},"s"]
[null,"Reactor volume",null,{"$f":"D33*D40","v":23.844111221726717},"m3",null,"Reactor volume",null,{"$f":"I33*I40","v":1.2632510854372485},"m3"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Compressor sizing",null,null,null,null,"Heat exchanger sizing"]
[null,"Efficiency",null,0.7,"-",null,"Cooling water supply temp.",null,303,"K"]
[null,"Heat capacity ratio, γ",null,1.4,"-",null,"Cooling water return temp.",null,318,"K"]
[null,"Inlet volume rate",null,{"$f":"'Process model'!H55/Utilization","v":5.9872837903536209E-2},"m3/s",null,"Flow rate",null,{"$f":"'Process model'!I58/Utilization","v":8.1563909378107625E-3},"kmol/s"]
[null,"Inlet temperature",null,{"$f":"'Process model'!H52","v":353.15},"K",null,"Temperature in",null,{"$f":"'Process model'!I52","v":392.70312213234456},"K"]
[null,"Inlet pressure",null,{"$f":"'Process model'!H53","v":4},"bar",null,"Temperature out",null,{"$f":"'Process model'!J52","v":353.15},"K"]
[null,"Outlet pressure",null,{"$f":"'Process model'!I53","v":5.8},"bar"]
[]
[null,"Results summary",null,null,null,null,"Results summary"]
[null,"Electrical power",null,{"$f":"D75","v":13.411624918638752},"kW",null,"Capacity",null,{"$f":"I78","v":7.7571163926521631},"m2"]
[null,null,null,null,null,null,"Cooling water flow",null,{"$f":"I69","v":0.41162453195837662},"kg/s"]
[]
[null,"Power calculation",null,null,null,null,"Cooling water flow rate calculation"]
[null,"Inlet volume rate",null,{"$f":"D54","v":5.9872837903536209E-2},"m3/s",null,"Process heat capacity",null,80,"kJ/(kmol-K)"]
[null,"Inlet pressure",null,{"$f":"D56*kPa_per_bar","v":400},"kPa",null,"Process temperature change",null,{"$f":"I55-I56","v":39.553122132344583},"K"]
[null,"Outlet pressure",null,{"$f":"D57*kPa_per_bar","v":580},"kPa",null,"Cooling duty",null,{"$f":"I54*I64*I65","v":25.808858153790212},"kW"]
[null,null,null,null,null,null,"Cooling water heat capacity",null,4.18,"kJ/(kg-K)"]
[null,"Compression ratio",null,{"$f":"D66/D65","v":1.45},"-",null,"Cooling water temp. change",null,{"$f":"I53-I52","v":15},"K"]
[null,"γ/(γ-1)",null,{"$f":"D53/(D53-1)","v":3.5000000000000004},null,null,"Cooling water flow rate",null,{"$f":"I66/Cp_H2O/I68","v":0.41162453195837662},"kg/s"]
[null,null,null,null,null,null,null,null,{"$f":"I69/kg_per_t*s_per_yr","v":12980.991239839361},"t/yr"]
[null,"Inlet temperature",null,{"$f":"D55","v":353.15},"K"]
[null,"Outlet temperature",null,{"$f":"D71*D68^(1/D69)","v":392.70312213234456},"K",null,"Heat transfer area calculation"]
[null,null,null,null,null,null,"Temp. change, side 1",null,{"$f":"I55-I53","v":74.703122132344561},"K"]
[null,"Fluid power",null,{"$f":"D54*D65*D69*(D68^(1/D69)-1)","v":9.3881374430471265},"kW",null,"Temp. change, side 2",null,{"$f":"I56-I52","v":50.149999999999977},"K"]
[null,"Electrical power",null,{"$f":"D74/D52","v":13.411624918638752},"kW",null,"Log mean temp. difference",null,{"$f":"(I73-I74)/LN(I73/I74)","v":61.613335867372889},"K"]
[null,null,null,{"$f":"D75*h_per_yr","v":117485.83428727547},"kW-h/yr",null,"Heat transfer coefficient",null,0.06,"kW/(m2-K)"]
[null,null,null,null,null,null,"Fouling factor",null,0.9]
[null,null,null,null,null,null,"Heat transfer area",null,{"$f":"I66/I75/I76/I77","v":7.7571163926521631},"m2"]

{"sheet":"Equipment costs","index":5,"n_rows":28,"n_cols":8,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
["Equipment purchased cost estimation"]
[null,"This page uses equipment sizing data to estimate equipment purchased cost based on known references. "]
[]
[null,null,null,null,"Total equipment purchased cost",null,null,{"$f":"SUM(E26:H26)","v":398610.43804286746}]
[null,null,null,null,"All capacities within acceptable range",null,null,{"$f":"AND(E17:H17)","v":true}]
[]
[null,null,null,null,"Reactor","Compressor","Heat exchanger","Separation vessel"]
[null,"Capacity parameter",null,null,{"$f":"'Equipment sizing'!E5","v":"Volume"},{"$f":"'Equipment sizing'!F5","v":"Power"},{"$f":"'Equipment sizing'!G5","v":"Area"},{"$f":"'Equipment sizing'!H5","v":"Volume"}]
[null,"Capacity units",null,null,{"$f":"'Equipment sizing'!E6","v":"m3"},{"$f":"'Equipment sizing'!F6","v":"kW"},{"$f":"'Equipment sizing'!G6","v":"m2"},{"$f":"'Equipment sizing'!H6","v":"m3"}]
[null,"Capacity",null,null,{"$f":"'Equipment sizing'!E7","v":23.844111221726717},{"$f":"'Equipment sizing'!F7","v":13.411624918638752},{"$f":"'Equipment sizing'!G7","v":7.7571163926521631},{"$f":"'Equipment sizing'!H7","v":1.2632510854372485}]
[null,"MOC",null,null,"Ni","SS316","SS316","SS316"]
[]
[null,"Scaling exponent",null,null,0.72,0.65,0.65,0.65]
[null,"Reference capacity",null,null,10,10,5,1]
[null,"Min allowable capacity for correlation",null,null,2,2,1,0.5]
[null,"Max allowable capacity for correlation",null,null,50,60,50,50]
[null,"Capacity within allowable range",null,null,{"$f":"AND(E10>E15,E10<E16)","v":true},{"$f":"AND(F10>F15,F10<F16)","v":true},{"$f":"AND(G10>G15,G10<G16)","v":true},{"$f":"AND(H10>H15,H10<H16)","v":true}]
[null,"Reference purchased cost",null,null,125000,46000,15200,22000]
[null,"Reference source",null,null,"quote","previous plant","previous plant","previous plant"]
[null,"Scaled purchased cost in reference year",null,null,{"$f":"E18*(E10/E14)^E13","v":233681.55452835947},{"$f":"F18*(F10/F14)^F13","v":55669.938441238599},{"$f":"G18*(G10/G14)^G13","v":20221.728969655327},{"$f":"H18*(H10/H14)^H13","v":25608.902866189372}]
[]
[null,"Reference year",null,null,2010,2010,2010,2010]
[null,"Estimate year",null,null,2015,2015,2015,2015]
[null,"CE plant cost index in reference year",null,null,468.2,468.2,468.2,468.2]
[null,"CE plant cost index in estimate year",null,null,556.79999999999995,556.79999999999995,556.79999999999995,556.79999999999995]
[null,"Scaled purchased cost in estimate year",null,null,{"$f":"E20*(E25/E24)","v":277902.36984491791},{"$f":"F20*(F25/F24)","v":66204.659812220532},{"$f":"G20*(G25/G24)","v":24048.395323161225},{"$f":"H20*(H25/H24)","v":30455.013062567796}]
[]
[null,"Note: References costs have been adjusted for demonstration purposes and are not necessarily realistic."]

{"sheet":"CapEx","index":6,"n_rows":48,"n_cols":8,"rows_kept":48,"cut":false,"hidden":false,"merged":[]}
["Fixed and total capital cost estimation"]
[null,"This page estimates fixed and total capital investment by applying multiplication factors to equipment purchased cost."]
[]
[]
[null,"Fixed capital",null,"Cost",null,"Total capital",null,"Cost"]
[null,"Direct costs",null,{"$f":"F32","v":1179886.8966068877},null,"Fixed capital",null,{"$f":"Fixed_Capital","v":2135595.2828584667}]
[null,"Indirect costs",null,{"$f":"F41","v":955708.38625157904},null,"Working capital",null,{"$f":"F47","v":320339.29242876999}]
[null,"Total",null,{"$f":"SUM(D6:D7)","v":2135595.2828584667},null,"Total",null,{"$f":"SUM(H6:H7)","v":2455934.5752872368}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Capital cost component settings and calculations"]
[]
[]
[null,"Direct costs",null,"Cost relative to Equipment Purchase",null,"Cost"]
[null,"Equipment purchase",null,"-","-",{"$f":"Equipment_Purchase_Cost","v":398610.43804286746}]
[null,"Installation",null,0.39,"25-55% typical",{"$f":"$F$24*D25","v":155458.07083671831}]
[null,"Instrumentation & controls",null,0.26,"8-50% typical",103638.71389114554]
[null,"Piping, installed",null,0.31,"10-80% typical",123569.23579328891]
[null,"Electrical systems, installed",null,0.1,"10-40% typical",39861.043804286746]
[null,"Buildings (including services)",null,0.28999999999999998,"10-70% typical",115597.02703243155]
[null,"Service facilities & yard improvements",null,0.55000000000000004,"40-100% typical",219235.74092357713]
[null,"Land",null,0.06,"4-8% typical",23916.626282572048]
[null,"Total direct costs",null,null,null,{"$f":"SUM(F24:F31)","v":1179886.8966068877}]
[]
[]
[]
[null,"Indirect costs",null,"Cost relative to Total Direct Costs",null,"Cost"]
[null,"Engineering and supervision",null,0.33,"5-20% typical",{"$f":"D37*$F$32","v":389362.67588027293}]
[null,"Legal expenses",null,0.03,"1-5% typical",{"$f":"D38*$F$32","v":35396.606898206628}]
[null,"Construction expense & contractor's fee",null,0.2,"10-30% typical",{"$f":"D39*$F$32","v":235977.37932137755}]
[null,"Contingency",null,0.25,"5-25% typical",{"$f":"D40*$F$32","v":294971.72415172192}]
[null,"Total indirect costs",null,null,null,{"$f":"SUM(F37:F40)","v":955708.38625157904}]
[]
[]
[]
[null,"Total capital",null,"Cost relative to Fixed Capital",null,"Cost"]
[null,"Fixed capital",null,"-","-",{"$f":"F41+F32","v":2135595.2828584667}]
[null,"Working capital",null,0.15,"10-20% typical",{"$f":"F46*D47","v":320339.29242876999}]
[null,"Total capital",null,null,null,{"$f":"F46+F47","v":2455934.5752872368}]

{"sheet":"OpEx & Rev","index":7,"n_rows":65,"n_cols":14,"rows_kept":65,"cut":false,"hidden":false,"merged":[]}
["Operating cost and revenue estimation"]
[null,"This page estimates plant operating costs and revenue based on the stream table, equipment list, and user input."]
[]
[]
[null,"1.  Variable costs",null,"Estimated as…",null,null,"$/yr",null,"Results",null,null,"$/yr","$/kg product"]
[null,"a.  Raw materials",null,"-",null,null,{"$f":"F56","v":564531.44508034061},null,"Revenue",null,null,{"$f":"F47","v":3500000},{"$f":"L6/Production_Rate/10^3","v":7}]
[null,"b.  Waste treatment",null,"-",null,null,{"$f":"N65","v":0},null,"OpEx w/ depreciation",null,null,{"$f":"SUM(G6:G13,G19,G20,G24)/(1-SUM(D14,D25,D26))","v":2004696.4430950156},{"$f":"L7/Production_Rate/10^3","v":4.0093928861900316}]
[null,"c.  Utilities",null,"-",null,null,{"$f":"N47","v":13247.966552596286},null,"OpEx w/out depreciation",null,null,{"$f":"OpEx_with_depr-G18","v":1791136.9148091688},{"$f":"L8/Production_Rate/10^3","v":3.5822738296183374}]
[null,"d.  Operating labor",null,"-",null,null,{"$f":"N56","v":432000}]
[null,"e.  Supervisory & clerical labor",null,0.18,"of operating labor",null,{"$f":"D10*G9","v":77760}]
[null,"f.  Maintenance & repairs",null,0.06,"of fixed capital",null,{"$f":"D11*Fixed_Capital","v":128135.71697150799}]
[null,"g.  Operating supplies",null,0.01,"of fixed capital",null,{"$f":"D12*Fixed_Capital","v":21355.952828584668}]
[null,"h.  Laboratory Charges",null,0.15,"of operating labor",null,{"$f":"D13*G9","v":64800},null,null,"Data for graphing"]
[null,"i.  Patents & royalties",null,0.03,"of total operating cost",null,{"$f":"L7*D14","v":60140.893292850466},null,null,"Raw materials",null,{"$f":"G6","v":564531.44508034061}]
[null,"Total variables costs",null,null,null,null,{"$f":"SUM(G6:G14)","v":1361971.9747258802},null,null,"Waste treatment",null,{"$f":"G7","v":0}]
[null,null,null,null,null,null,null,null,null,"Utilities",null,{"$f":"G8","v":13247.966552596286}]
[null,"2.  Fixed costs",null,"Estimated as…",null,null,"$/yr",null,null,"Operating labor",null,{"$f":"G9","v":432000}]
[null,"a.  Depreciation",null,0.1,"of fixed capital",null,{"$f":"D18*Fixed_Capital","v":213559.5282858467},null,null,"Other variable costs",null,{"$f":"G15-SUM(L14:L17)","v":352192.56309294328}]
[null,"b.  Local taxes & insurance",null,0.03,"of fixed capital",null,{"$f":"D19*Fixed_Capital","v":64067.858485753997},null,null,"Depreciation",null,{"$f":"G18","v":213559.5282858467}]
[null,"c.  Plant overhead",null,0.6,"of (Line 1d + 1e + 1f)",null,{"$f":"D20*SUM(G9:G11)","v":382737.43018290476},null,null,"Other fixed costs",null,{"$f":"G21","v":660364.8169545054}]
[null,"Total Fixed costs",null,null,null,null,{"$f":"SUM(G18:G20)","v":660364.8169545054},null,null,"General costs",null,{"$f":"G27","v":195919.17970047699}]
[]
[null,"3.  General costs",null,"Estimated as…",null,null,"$/yr"]
[null,"a.  Administrative",null,0.15,"of (Line 1d + 1e + 1f)",null,{"$f":"D24*SUM(G9:G11)","v":95684.35754572619}]
[null,"b.  Distribution & marketing ",null,0,"of total operating cost",null,{"$f":"L7*D25","v":0}]
[null,"c.  Research & development",null,0.05,"of total operating cost",null,{"$f":"L7*D26","v":100234.82215475079}]
[null,"Total general costs",null,null,null,null,{"$f":"SUM(G24:G26)","v":195919.17970047699}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Operating cost component settings & calculations"]
[]
[]
[null,"Products",null,"$/t","t/yr","$/yr",null,"Utilities",null,null,null,null,null,"$/yr"]
[null,"Polymer",null,{"$f":"Dashboard!E19","v":7000},{"$f":"'Process model'!I6","v":500},{"$f":"E44*D44","v":3500000},null,"Electrical power",null,{"$f":"Dashboard!E23","v":0.11},"/kW-h",{"$f":"'Equipment sizing'!F9","v":117485.83428727547},"kW-h/yr",{"$f":"L44*J44","v":12923.441771600303}]
[null,null,null,null,null,null,null,"Cooling water",null,2.5000000000000001E-2,"/MT",{"$f":"'Equipment sizing'!G10","v":12980.991239839361},"t/yr",{"$f":"L45*J45","v":324.52478099598403}]
[]
[null,"Total",null,null,null,{"$f":"SUM(F44:F46)","v":3500000},null,"Total",null,null,null,null,null,{"$f":"SUM(N44:N46)","v":13247.966552596286}]
[]
[]
[]
[]
[null,"Raw materials",null,"$/t","t/yr","$/yr",null,"Labor",null,null,null,null,null,"$/yr"]
[null,"Catalyst",null,{"$f":"Dashboard!E20","v":1150},{"$f":"'Process model'!I7","v":0.53705263161331884},{"$f":"E53*D53","v":617.61052635531667},null,"Operations",null,6,"FTE",{"$f":"Dashboard!E24","v":72000},"/(FTE/yr)",{"$f":"L53*J53","v":432000}]
[null,"Monomer",null,{"$f":"Dashboard!E21","v":1050},{"$f":"'Process model'!I8","v":537.05263161331879},{"$f":"E54*D54","v":563905.26319398475}]
[null,"Hydrogen",null,{"$f":"Dashboard!E22","v":2100},{"$f":"'Process model'!I9","v":4.0816000002612228E-3},{"$f":"E55*D55","v":8.5713600005485677}]
[null,"Total",null,null,null,{"$f":"SUM(F53:F55)","v":564531.44508034061},null,"Total",null,null,null,null,null,{"$f":"SUM(N53:N55)","v":432000}]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"Waste",null,null,null,null,null,"$/yr"]
[null,null,null,null,null,null,null,"[none listed]"]
[]
[]
[null,null,null,null,null,null,null,"Total",null,null,null,null,null,{"$f":"SUM(N62:N64)","v":0}]

{"sheet":"Cash flow","index":8,"n_rows":44,"n_cols":14,"rows_kept":44,"cut":false,"hidden":false,"merged":[]}
["Cash flow analysis"]
[null,"This page performs a discounted cash flow analysis."]
[]
[]
[null,"User input",null,null,null,"Profitability metrics"]
[null,"Income tax rate",null,0.4,null,"IRR",null,{"$f":"IRR(E36:N36)","v":0.36224523495016192}]
[null,"Discount rate",null,0.1,null,"NPV",null,{"$f":"(NPV(Discount_Rate,F36:N36)+E36)","v":3.5575667203713488},"MM USD"]
[null,"Salvage value",null,0.05,"of FCI","Simple payback",null,{"$f":"F42","v":2.7562833343919424},"years"]
[null,null,null,null,null,"Discounted payback",null,{"$f":"J42","v":2.3230434077067308},"years"]
[]
[]
[]
[]
[]
[null,null,null,"Year",1,2,3,4,5,6,7,8,9,10]
[]
[null,"Capital outlay",null,"MM USD",{"$f":"SUM(E19,E21)","v":-2.4559345752872366},{"$f":"SUM(F19,F21)","v":0},0,0,0,0,0,0,0,0.4271190565716933]
[null,"Fixed capital",null,"-",1,null,null,null,null,null,null,null,null,{"$f":"-SalvagePercent","v":-0.05}]
[null,null,null,"MM USD",{"$f":"-E18*Fixed_Capital/10^6","v":-2.1355952828584668},0,0,0,0,0,0,0,0,0.10677976414292335]
[null,"Working capital",null,"-",1,null,null,null,null,null,null,null,null,-1]
[null,null,null,"MM USD",{"$f":"-E20*Working_Capital/10^6","v":-0.32033929242876996},0,0,0,0,0,0,0,0,0.32033929242876996]
[]
[]
[null,"Gross profit",null,"MM USD",{"$f":"E26+E27","v":0},{"$f":"F26+F27","v":0.85443154259541565},1.7088630851908313,1.7088630851908313,1.7088630851908313,1.7088630851908313,1.7088630851908313,1.7088630851908313,1.7088630851908313,1.7088630851908313]
[null,"Operating rate",null,"-",null,0.5,1,1,1,1,1,1,1,1]
[null,"Revenue",null,"MM USD",{"$f":"E25*Revenue/10^6","v":0},1.75,{"$f":"G25*Revenue/10^6","v":3.5},3.5,3.5,3.5,3.5,3.5,{"$f":"M25*Revenue/10^6","v":3.5},3.5]
[null,"Operating costs",null,"MM USD",{"$f":"-E25*OpEx_without_depr/10^6","v":0},-0.89556845740458435,-1.7911369148091687,-1.7911369148091687,-1.7911369148091687,-1.7911369148091687,-1.7911369148091687,-1.7911369148091687,-1.7911369148091687,-1.7911369148091687]
[]
[]
[null,"Net profit",null,"MM USD",{"$f":"E24-E33*Income_Tax_Rate","v":0},0.51265892555724935,1.1064704718631204,1.1064704718631204,1.1064704718631204,1.1064704718631204,1.1064704718631204,1.1064704718631204,1.1064704718631204,1.1064704718631204]
[null,"Depreciation",null,"Schedule",null,null,0.1,0.1,0.1,0.1,0.1,0.1,0.1,0.1]
[null,null,null,"MM USD",{"$f":"E31*Fixed_Capital*(1-SalvagePercent)/10^6","v":0},0,0.20288155187155435,0.20288155187155435,0.20288155187155435,0.20288155187155435,0.20288155187155435,0.20288155187155435,0.20288155187155435,0.20288155187155435]
[null,"Taxable income",null,"MM USD",{"$f":"IF(E24-E32>0,E24-E32,0)","v":0},{"$f":"IF(F24-F32>0,F24-F32,0)","v":0.85443154259541565},{"$f":"IF(G24-G32>0,G24-G32,0)","v":1.505981533319277},{"$f":"IF(H24-H32>0,H24-H32,0)","v":1.505981533319277},1.505981533319277,1.505981533319277,1.505981533319277,1.505981533319277,1.505981533319277,1.505981533319277]
[]
[]
[null,"Cash flow",null,"MM USD",{"$f":"E30+E17","v":-2.4559345752872366},{"$f":"F30+F17","v":0.51265892555724935},1.1064704718631204,1.1064704718631204,1.1064704718631204,1.1064704718631204,1.1064704718631204,1.1064704718631204,1.1064704718631204,1.5335895284348138]
[null,"Cumulative",null,"MM USD",{"$f":"E36","v":-2.4559345752872366},{"$f":"F36+E37","v":-1.9432756497299872},{"$f":"G36+F37","v":-0.83680517786686681},0.26966529399625361,1.376135765859374,2.4826062377224947,3.5890767095856151,4.6955471814487355,5.8020176533118555,7.3356071817466688]
[null,"Discounted cash flow",null,"MM USD",{"$f":"E36/(1+Discount_Rate)^(E15-1)","v":-2.4559345752872366},{"$f":"F36/(1+Discount_Rate)^(F15-1)","v":0.46605356868840847},0.91443840649844643,0.83130764227131482,0.75573422024664993,0.68703110931513622,0.62457373574103281,0.56779430521912067,0.51617664110829153,0.65039166657018632]
[null,"Cum. disc. cash flow",null,"MM USD",{"$f":"E38","v":-2.4559345752872366},{"$f":"F38+E39","v":-1.9898810065988282},{"$f":"G38+F39","v":-1.0754426001003816},-0.2441349578290668,0.51159926241758313,1.1986303717327194,1.8232041074737522,2.3909984126928729,2.9071750538011645,3.5575667203713506]
[]
[]
[null,"Payback calculation",null,null,"Simple payback",{"$f":"SUM(F43:N43)","v":2.7562833343919424},"years",null,"Discounted payback",{"$f":"SUM(F44:N44)","v":2.3230434077067308},"years"]
[null,"Simple payback",null,null,"-",{"$f":"IF(AND(E37<0,F37>0),INTERCEPT($F$15:$G$15,E37:F37),0)","v":0},{"$f":"IF(AND(F37<0,G37>0),INTERCEPT($F$15:$G$15,F37:G37),0)","v":0},{"$f":"IF(AND(G37<0,H37>0),INTERCEPT($F$15:$G$15,G37:H37),0)","v":2.7562833343919424},0,0,0,0,0,0]
[null,"Discounted payback",null,null,"-",{"$f":"IF(AND(E39<0,F39>0),INTERCEPT($F$15:$G$15,E39:F39),0)","v":0},{"$f":"IF(AND(F39<0,G39>0),INTERCEPT($F$15:$G$15,F39:G39),0)","v":0},{"$f":"IF(AND(G39<0,H39>0),INTERCEPT($F$15:$G$15,G39:H39),0)","v":0},2.3230434077067308,0,0,0,0,0]

{"sheet":"Constants","index":9,"n_rows":10,"n_cols":14,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Constants & misc."]
[null,"This page contains constants that are used throughout the model."]
[]
[]
[null,"Conversion factors",null,null,null,"Ambient conditions",null,null,null,null,"Constants"]
[null,"Mass",1000,"kg/t",null,"Temperature",null,298,"K",null,"Ideal gas constant",null,8.3144320999999993E-2,"m3-bar/(kmol-K)"]
[null,"Time",31535999.999999989,"s/yr",null,"Pressure",null,1,"bar"]
[null,null,60,"s/min"]
[null,null,8760,"h/yr"]
[null,"Pressure",100,"kPa/bar"]