{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Orientation","Dashboard","Tornado","Process model","Equipment sizing","Equipment costs","CapEx","OpEx & Rev","Cash flow","Constants"],"not_rendered":{"charts":8,"images":7,"macros":1,"external_links":0,"defined_names":64,"comments":3,"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":"Orientation","index":0,"n_rows":43,"n_cols":4,"rows_kept":43,"cut":false,"hidden":false,"merged":[[19,3,20,3]]}
["Demonstration TEM - Riboflavin fermentation"]
[]
[]
[null,"Introduction"]
[null,"Purpose",null,"This model illustrates one approach to techno-economic modeling that we often use at Burk Engineering LLC. The purpose of this model is to demonstrate this approach and its value, not to accurately represent a realistic process."]
[]
[]
[null,"About the process",null,"Riboflavin (Vitamin B2) is used as an additive to human and animal food products. The worldwide production was about 8,000 metric tons per year as of 2015 and is obtained mostly through fermentation using A. gossypii strains. This model is based on a case study from the textbook 'Development of Sustainable Bioprocesses', by Heinzle, Biwer, and Cooney, using the alternative organism Eremothecium ashbyii. "]
[]
[null,null,null,"E. ashbyii is closely related to A. gosypii, but it is not very genetically stable, so it is necessary to use a batch configuration starting with fresh stock for each batch."]
[]
[]
[null,"The model"]
[null,"Operation",null,"The model is modular in structure, as described in more detail below. The Dashboard page aggregates important user input values and results for easy access and operation. The Tornado page uses a VBA macro to quickly build tornado diagrams for sensitivity analysis."]
[]
[]
[null,null,null,"Grey shaded cells contain workbook-level input values."]
[]
[]
[null,null,null,"Yellow shaded cells contain worksheet-level input values, which are linked to workbook-level input cells on the Dashboard page."]
[]
[]
[]
[null,"Structure",null,"The diagram below shows the general structure of the model. The blocks are worksheet pages and the lines represent flow of information."]
[]
[null,null,null,"The Process model uses technical parameters from the lab, literature, and elsewhere to develop a material balance for the process, which is defined in the process diagram. The Equipment sizing page uses data from the material balance to calculate utility requirements, labor requirements, and the specific values necessary for estimating major equipment costs. The OpEx & Rev page estimates operating costs and revenue using values from the material balance and prices specified by the user. "]
[]
[null,null,null,"To estimate capital costs, the model first estimates major equipment costs and then extrapolates total plant cost. The Equipment costs page uses capacity scaling factors to estimate major equipment costs from reference cases. The CapEx page applies multiplying factors to major equipment costs to estimate total capital cost."]
[]
[null,null,null,"The Cash flow page performs a discounted cash flow analysis for the plant over a fifteen-year period and calculates profitability metrics like NPV and IRR."]
[]
[]
[null,"VBA components",null,"Tornado analysis - Tornado charts are time consuming to generate manually, since they require plugging in and recording numerous values. This workbook contains a macro that does this automatically. It can be used and reconfigured on the 'Tornado' page, but the code is locked and cannot be exported. Third party tornado analysis software is available from several sources."]
[]
[null,null,null,"Lookup functions- This workbook also contains two custom VBA functions for looking up values in the stream table and equipment list. These functions allow for simpler and more intuitive formulas, which reduces errors and facilitates spreadsheet development and debugging. The code for these functions is also locked, but is published and discussed in more detail in the blog post linked below."]
[null,null,null,"Pro Tip: Searchable Excel Stream Tables with VBA"]
[]
[]
[null,"Contact"]
[null,"Chris Burk, PE",null,"Process techno-economics consultant"]
[null,null,null,"Burk Engineering LLC"]
[null,null,"email","cburk@BurkEngineeringLLC.com"]
[null,null,"website","www.BurkEngineeringLLC.com"]

{"sheet":"Dashboard","index":1,"n_rows":29,"n_cols":12,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
["Techno-economic model  dashboard- Riboflavin fermentation"]
[null,"This page aggregates important user input values and results for easy access."]
[]
[]
[null,"Process parameters",null,null,null,null,null,null,"Profitability metrics"]
[null,"Plant capacity",null,null,1000,"t/yr",null,null,"NPV",null,{"$f":"NPV","v":52.396376991164971},"MM USD"]
[null,"Batches per year",null,null,12,"/yr",null,null,"IRR",null,{"$f":"IRR","v":0.1738735901276085}]
[null,"Inoculum ratio",null,null,0.1,"mass",null,null,"Disc. payback",null,{"$f":"DiscountedPayback","v":9.3192454421677429},"yr"]
[null,"Max fermenter size",null,null,500,"m3",null,null,"Gross margin",null,{"$f":"K22/K18","v":0.57525925103542119}]
[null,"Fermentation time",null,null,500,"h",null,null,"CapEx / Capacity",null,{"$f":"10^6*K17/E6","v":143231.60519936107},"USD/(t/yr)"]
[null,"Sunflower oil conversion",null,null,0.99]
[null,"Fermentation aeration rate",null,null,0.2,"vvm"]
[null,"Crystallization yield",null,null,0.9,"of riboflavin"]
[]
[]
[null,"Product & raw material values",null,null,null,null,null,null,"Financial results"]
[null,"Riboflavin product",null,null,60,"/kg",null,null,"Total capital",null,{"$f":"TotalCapitalInvestment/10^6","v":143.2316051993611},"MM USD"]
[null,"Methionine",null,null,35,"/kg",null,null,"Revenue",null,{"$f":"Revenue/10^6","v":60},"MM USD/ yr"]
[null,"Glucose",null,null,1,"/kg",null,null,null,null,{"$f":"K18/PlantCapacity_kg_per_year*10^6","v":60},"/ kg product"]
[null,"Malt Extract",null,null,4,"/kg",null,null,"Operating costs",null,{"$f":"OpEx/10^6","v":25.484444937874727},"MM USD/ yr"]
[null,"Peptone",null,null,9,"/kg",null,null,null,null,{"$f":"K20/PlantCapacity_kg_per_year*10^6","v":25.484444937874727},"/ kg product"]
[null,"Sunflower oil",null,null,0.55000000000000004,"/kg",null,null,"Gross profit",null,{"$f":"K18-K20","v":34.515555062125273},"MM USD/ yr"]
[null,"Yeast extract",null,null,4,"/kg",null,null,null,null,{"$f":"K22/PlantCapacity_kg_per_year*10^6","v":34.515555062125273},"/ kg product"]
[]
[]
[null,"Other OpEx parameters",null,null,null,null,null,null,"Process metrics"]
[null,"Operator rate",null,null,85,"/hr",null,null,"Mass index",null,{"$f":"'Process model'!O21","v":38.434950807238067},"kg in / kg prod."]
[null,"Electrical power",null,null,0.11,"/kWh",null,null,"Ferm. O2 utilization",null,{"$f":"'Process model'!O22","v":1.8049876656083645E-3}]
[null,"Maintenance factor",null,null,0.1,"xDFC/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"]
[" ","This page uses a VBA macro to automate building tornado diagrams based on the model. Tornado diagrams are useful for prioritizing R&D and for identify risks and opportunities."]
[]
[null,null,null,null,null,null,null,"Settings","Worst","Expected","Best","Units","Reference"]
[null,null,null,null,null,null,null,"Plant capacity",900,1000,1200,"t/yr",{"$f":"Dashboard!$E$6","v":1000}]
[null,null,null,null,null,null,null,"Batches per year",11,12,13,"1/yr",{"$f":"Dashboard!$E$7","v":12}]
[null,null,null,null,null,null,null,"Max fermenter size",400,500,800,"m3",{"$f":"Dashboard!$E$9","v":500}]
[null,null,null,null,null,null,null,"Fermentation time",550,500,450,"h",{"$f":"Dashboard!$E$10","v":500}]
[null,null,null,null,null,null,null,"Fermentation air rate",0.3,0.2,0.1,"vvm",{"$f":"Dashboard!$E$12","v":0.2}]
[null,null,null,null,null,null,null,"Crystallization yield",0.87,0.9,0.93,"of riboflavin",{"$f":"Dashboard!$E$13","v":0.9}]
[null,null,null,null,null,null,null,"Product price",58,60,63,"/kg",{"$f":"Dashboard!$E$17","v":60}]
[null,null,null,null,null,null,null,"Methionine price",38.5,35,33,"/kg",{"$f":"Dashboard!$E$18","v":35}]
[null,null,null,null,null,null,null,"Power price",0.13,0.11,0.1,"/kWh",{"$f":"Dashboard!$E$28","v":0.11}]
[null,null,null,null,null,null,null,"Maintenance factor",0.12,0.1,0.08,"x DFC/yr",{"$f":"Dashboard!$E$29","v":0.1}]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Metric:","IRR"]
[]
[]
[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":"Dashboard!K6","v":52.396376991164971},1]
[null,null,null,null,null,null,null,"IRR",{"$f":"Dashboard!K7","v":0.1738735901276085},1]
[null,null,null,null,null,null,null,"Disc. Payback, yr",{"$f":"Dashboard!K8","v":9.3192454421677429},0]
[null,null,null,null,null,null,null,"Gross margin",{"$f":"Dashboard!K9","v":0.57525925103542119},1]
[null,null,null,null,null,null,null,"CapEx/Capacity, USD/(t/yr)",{"$f":"Dashboard!K10","v":143231.60519936107},0]
[]
[]
[null,null,null,null,null,null,null,"Use: Index",{"$f":"MATCH(J18,$H$52:$H$57,0)","v":2}]
[null,null,null,null,null,null,null,"Value",{"$f":"INDEX($I$52:$I$57,I59)","v":0.1738735901276085}]
[null,null,null,null,null,null,null,"Format",{"$f":"CELL(\"format\",INDEX($I$52:$I$57,I59))","v":"P0"}]
[]
[null,null,null,null,null,null,null,"Metric","Higher = better","Reference"]
[null,null,null,null,null,null,null,{"$f":"J18","v":"IRR"},{"$f":"INDEX(J52:J57,MATCH(T_Metric,H52:H57,0))","v":1},{"$f":"Tornado!I60","v":0.1738735901276085}]
[null,null,null,null,null,null,null,"Input","Low ","High"]
[null,null,null,null,null,null,null,"Methionine price",0.17330492203708148,0.17419827249830799]
[null,null,null,null,null,null,null,"Maintenance factor",0.16955074412680982,0.1781575425722759]
[null,null,null,null,null,null,null,"Fermentation time",0.16923783241295753,0.17850890140577635]
[null,null,null,null,null,null,null,"Power price",0.16918876300681518,0.1762006815624364]
[null,null,null,null,null,null,null,"Plant capacity",0.16854081593776926,0.1767241209951298]
[null,null,null,null,null,null,null,"Max fermenter size",0.16712682187661554,0.18550480674299097]
[null,null,null,null,null,null,null,"Product price",0.16262551222585864,0.1902659379248397]
[null,null,null,null,null,null,null,"Crystallization yield",0.16101446312105594,0.18448157562235457]
[null,null,null,null,null,null,null,"Fermentation air rate",0.15827788352388361,0.19142790371116103]
[null,null,null,null,null,null,null,"Batches per year",0.15390068955137148,0.19120504055317045]

{"sheet":"Process model","index":3,"n_rows":116,"n_cols":26,"rows_kept":116,"cut":false,"hidden":false,"merged":[]}
["Process model"]
[null,"This page populates a material balance for the process based on user input and the process flow diagram."]
[]
[]
[null,"General user input",null,null,null,null,"Raw materials",null,"t/batch","t/yr",null,"Product",null,"Mass comp.","t/batch","t/yr"]
[null,"Plant capacity",null,{"$f":"Dashboard!E6","v":1000},"t/yr",null,"Water",null,{"$f":"StreamTable(100,G6)/1000","v":2977.7915277703974},{"$f":"I6*Batches_per_year","v":35733.498333244766},null,"Riboflavin (cr)",null,{"$f":"O6/SUM($O$6:$O$11)","v":0.86099661151943674},{"$f":"StreamTable(700,L6)/1000","v":83.333333333333329},{"$f":"O6*Batches_per_year","v":1000}]
[null,"Batches per year",null,{"$f":"Dashboard!E7","v":12},"1/yr",null,"Sunflower oil",null,89.333745833111934,1072.0049499973431,null,"Biomass",null,9.4845946515443091E-2,9.1798606063486208,110.15832727618346]
[null,"Inoculum ratio",null,{"$f":"Dashboard!E8","v":0.1},"mass",null,"Glucose",null,29.777915277703976,357.33498333244768,null,"Water",null,4.3558744043295163E-2,4.2159229065204276,50.591074878245131]
[null,null,null,null,null,null,"Peptone",null,29.777915277703976,357.33498333244768,null,"Glucose",null,5.5434992761548799E-4,5.3653901401269112E-2,0.64384681681522937]
[null,null,null,null,null,null,"Yeast extract",null,29.777915277703976,357.33498333244768,null,"Magnesium sulfate",null,2.2173997104619557E-5,2.146156056050768E-3,2.5753872672609215E-2]
[null,"Fermentation parameters",null,null,null,null,"Malt extract",null,29.777915277703976,357.33498333244768,null,"Potassium phosphate",null,2.2173997104619557E-5,2.146156056050768E-3,2.5753872672609215E-2]
[null,"SFO conversion",null,{"$f":"Dashboard!E11","v":0.99},null,null,"Methionine",null,2.3822332222163181,28.586798666595818,null,"Total",null,{"$f":"SUM(N6:N11)","v":0.99999999999999967},{"$f":"SUM(O6:O11)","v":96.787063059715777},{"$f":"SUM(P6:P11)","v":1161.4447567165889}]
[null,"Aeration rate ",null,{"$f":"Dashboard!E12","v":0.2},"vvm",null,"Magnesium sulfate",null,1.191116611108159,14.293399333297909]
[null,null,null,null,null,null,"Potassium phosphate",null,1.191116611108159,14.293399333297909]
[null,null,null,null,null,null,"Sulfuric acid",null,11.91116611108159,142.93399333297907]
[null,null,null,null,null,null,"Air",null,{"$f":"(StreamTable(205,\"Oxygen\")+StreamTable(205,\"Nitrogen\")+StreamTable(605,\"Oxygen\")+StreamTable(605,\"Nitrogen\"))/1000","v":28188.819669991084},338265.83603989298]
[]
[]
[]
[null,"Crystallizer parameters",null,null,null,null,"Liquid waste",null,"t/batch","t/yr",null,"Metrics"]
[null,"SFO evaporated",null,0.2,null,null,"Decanter oil fract.",null,{"$f":"StreamTable(550, \"Mass per batch\")/1000","v":42.777345080524547},{"$f":"I21*Batches_per_year","v":513.32814096629454},null,"Mass index, inlet",null,null,{"$f":"SUM(J6:J15)/P6","v":38.434950807238067}]
[null,"Water evaporated",null,0.3,null,null,"Decanter aq. fract.",null,{"$f":"StreamTable(555, \"Mass per batch\")/1000","v":1704.1188657888879},{"$f":"I22*Batches_per_year","v":20449.426389466655},null,"Oxygen utilization in fermenter",null,null,{"$f":"-O107/StreamTable(205,\"Oxygen\")","v":1.8049876656083645E-3}]
[null,"Crystallization yield",null,{"$f":"Dashboard!E13","v":0.9},"of riboflavin"]
[]
[]
[null,"Spray dryer parameters",null,null,null,null,"Exhaust",null,"t/batch","t/yr",null,"Assumptions & notes"]
[null,"Water evaporation",null,0.99,null,null,"Fermenter",null,{"$f":"StreamTable(250, \"Mass per batch\")/1000","v":26140.217743757214},{"$f":"I27*Batches_per_year","v":313682.61292508658},null,"Crystallization heat is negligible."]
[null,"Air ratio",null,5,"x evap. H2O",null,"Crystallizer",null,{"$f":"StreamTable(450, \"Mass per batch\")/1000","v":903.57301310143907},{"$f":"I28*Batches_per_year","v":10842.87615721727},null,"Agitation energy goes to heat."]
[null,null,null,null,null,null,"Spray dryer",null,{"$f":"StreamTable(650, \"Mass per batch\")/1000","v":2504.2582064731369},{"$f":"I29*Batches_per_year","v":30051.098477677642},null,"No loss of product in spray dryer, crystallizer, tank transfer."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Material balance"]
[]
[]
[null,"Stream",null,null,5,10,100,105,200,205,250,300,350,400,450,500,550,555,600,605,650,700]
[]
[null,"Process step",null,"-","Feed preparation",null,"Inoculation",null,"Fermentation",null,null,"Inoculation removal",null,"Crystallization",null,"Decanting",null,null,"Spray drying",null,null,"Product"]
[null,"In / Out",null,"-","in","in",null,"in",null,"in","out",null,"out",null,"out",null,"out","out"," ","in","out","out"]
[null,"Phase",null,"-","L","L","L","L","L","G","G","L","L","L","G","L, S","L","L","L, S","G","G","S"]
[]
[null,"Temperature",null,"degC",2,2,null,2,1,40,20]
[null,"Pressure",null,"bar",35,35,null,30,30,6,1]
[null,"Density",null,"kg/m3",1330,1005,1000,1000,1000,{"$f":"D105","v":1.2238784507410516},{"$f":"J51","v":1.2238784507410516},1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000]
[]
[null,"Volume",null,"m3",{"$f":"E56/E51","v":31.984871404622961},3144.6494410962105,3202.9125672698397,351.62585053067659,3554.5384178005161,21327230.506803095,21358508.05112996,3516.2585053067664,351.62585053067698,3164.6326547760896,903.57301310143907,2261.0596416746507,42.777345080524547,1704.1188657888879,514.16343080523848,2086.8818387276137,2504.2582064731369,96.787063059715749]
[]
[]
[null,"Mass per batch",null,"kg",{"$f":"E60/I104","v":42539.878968148536},{"$f":"SUM(F57:F75)","v":3160372.6883016913},{"$f":"SUM(G57:G75)","v":3202912.5672698398},{"$f":"SUM(H57:H75)","v":351625.8505306766},{"$f":"SUM(I57:I75)","v":3554538.4178005159},{"$f":"D110","v":26101937.831263468},{"$f":"SUM(K57:K75)","v":26140217.743757214},{"$f":"SUM(L57:L75)","v":3516258.5053067664},{"$f":"L56-N56","v":351625.85053067701},{"$f":"SUM(N57:N75)","v":3164632.6547760894},903573.01310143911,2261059.6416746508,42777.345080524545,1704118.865788888,514163.43080523843,{"$f":"D116","v":2086881.8387276139},{"$f":"SUM(U57:U75)","v":2504258.2064731368},{"$f":"SUM(V57:V75)","v":96787.063059715743}]
[null,"Water",null,"H2O",{"$f":"E56-E60","v":12761.963690444562},{"$f":"G57-E57","v":2965029.5640799529},{"$f":"G59/I92*1000","v":2977791.5277703973},{"$f":"M57","v":334597.05607305001},{"$f":"G57+H57","v":3312388.5838434473},null,null,{"$f":"N57/(1-Inoculum_ratio)","v":3345970.5607305011},{"$f":"L57-N57","v":334597.05607305001},{"$f":"G57+O110","v":3011373.5046574511},{"$f":"N57*D22","v":903412.05139723525},{"$f":"N57-O57","v":2107961.4532602159},null,{"$f":"P57-Q57-S57","v":1686369.1626081727},{"$f":"X112","v":421592.29065204319},null,{"$f":"D114","v":417376.36774552276},{"$f":"S57-U57","v":4215.9229065204272}]
[]
[null,"Sunflower oil",null,"-",null,{"$f":"G59","v":89333.745833111927},{"$f":"I59-H59","v":89333.745833111927},{"$f":"M59","v":89.423169002114449},{"$f":"D97","v":89423.169002114038},null,null,{"$f":"I59+O92","v":894.23169002114446},{"$f":"L59*Inoculum_ratio","v":89.423169002114449},{"$f":"G59+O92","v":804.80852101903292},{"$f":"N59*D21","v":160.96170420380659},{"$f":"N59-O59","v":643.84681681522636},{"$f":"W94","v":128.76936336304527},{"$f":"P59-Q59-S59","v":515.07745345218109}]
[null,"Glucose",null,"C6H12O6",{"$f":"G60","v":29777.915277703974},null,{"$f":"$G$59*J93","v":29777.915277703974},29.807723000705039,{"$f":"G60+H60","v":29807.723000704678},null,null,{"$f":"N60/(1-Inoculum_ratio)","v":298.07723000705056},{"$f":"L60-N60","v":29.807723000705039},268.26950700634552,null,{"$f":"N60","v":268.26950700634552},null,{"$f":"P60-Q60-S60","v":214.61560560507641},{"$f":"X95","v":53.65390140126911},null,null,{"$f":"S60","v":53.65390140126911}]
[null,"Peptone",null,"-",null,{"$f":"G61","v":29777.915277703974},29777.915277703974,29.807723000705039,29807.723000704678,null,null,298.07723000705056,29.807723000705039,268.26950700634552,null,268.26950700634552,{"$f":"W96","v":134.13475350317276},{"$f":"P61-Q61-S61","v":134.13475350317276}]
[null,"Yeast extract",null,"-",null,29777.915277703974,29777.915277703974,29.807723000705039,29807.723000704678,null,null,298.07723000705056,29.807723000705039,268.26950700634552,null,268.26950700634552,{"$f":"W97","v":134.13475350317276},{"$f":"P62-Q62-S62","v":134.13475350317276}]
[null,"Malt extract",null,"-",null,29777.915277703974,29777.915277703974,29.807723000705039,29807.723000704678,null,null,298.07723000705056,29.807723000705039,268.26950700634552,null,268.26950700634552,{"$f":"W98","v":134.13475350317276},134.13475350317276]
[null,"Methionine",null,"C5H11NO2S",null,2382.2332222163182,2382.2332222163182,2.3846178400564071,2384.6178400563745,null,null,23.846178400564085,2.3846178400564071,21.461560560507678,null,21.461560560507678,{"$f":"W99","v":8.5846242242030719},12.876936336304606]
[null,"Magnesium sulfate",null,"MgSO4-7H2O",null,1191.1166111081591,1191.1166111081591,1.1923089200282035,1192.3089200281872,null,null,11.923089200282043,1.1923089200282035,10.730780280253839,null,10.730780280253839,null,8.5846242242030719,{"$f":"X100","v":2.146156056050768},null,null,{"$f":"S65","v":2.146156056050768}]
[null,"Potassium phosphate",null,"K2HPO4",null,1191.1166111081591,1191.1166111081591,1.1923089200282035,1192.3089200281872,null,null,11.923089200282043,1.1923089200282035,10.730780280253839,null,10.730780280253839,null,8.5846242242030719,{"$f":"X101","v":2.146156056050768},null,null,{"$f":"S66","v":2.146156056050768}]
[null,"Sulfuric acid",null,"H2SO4 (1N*)",null,11911.166111081589,11911.166111081589,1323.4629012312871,13234.629012312877,null,null,13234.629012312877,1323.4629012312871,11911.166111081589,null,11911.166111081589,null,11911.166111081589,null,null,null,{"$f":"S67","v":0}]
[]
[null,"Biomass",null,"-",null,null,null,{"$f":"M69","v":5099.9225590825663},{"$f":"G69+H69","v":5099.9225590825663},null,null,{"$f":"N69/(1-Inoculum_ratio)","v":50999.225590825663},{"$f":"L69-N69","v":5099.9225590825663},{"$f":"G69+O102","v":45899.303031743097},null,{"$f":"N69","v":45899.303031743097},{"$f":"W104","v":36719.442425394482},null,{"$f":"X104","v":9179.8606063486204},null,null,{"$f":"S69","v":9179.8606063486204}]
[null,"Riboflavin, aq.",null,"C17H20N4O6",null,null,null,{"$f":"M70","v":10391.985700627672},{"$f":"L70-O103","v":10391.985700627672},null,null,{"$f":"N70/(1-Inoculum_ratio)","v":103919.85700627674},{"$f":"L70-N70","v":10391.985700627672},{"$f":"P71/D23","v":93527.871305649067},null,{"$f":"N70-P71","v":9352.7871305649023},{"$f":"W105","v":4676.3935652824512},{"$f":"P70-Q70-S70","v":4676.3935652824512}]
[null,"Riboflavin (cr)",null,"C17H20N4O6",null,null,null,null,null,null,null,null,null,null,null,{"$f":"S71/U106","v":84175.084175084165},{"$f":"W106","v":841.75084175084169},null,{"$f":"V71","v":83333.333333333328},null,null,{"$f":"D95","v":83333.333333333328}]
[]
[null,"Nitrogen",null,"N2",null,null,null,null,null,{"$f":"J56-J74","v":20046288.254410341},{"$f":"J73","v":20046288.254410341},null,null,null,null,null,null,null,null,{"$f":"T56-T74","v":1602725.2521428075},{"$f":"T73","v":1602725.2521428075}]
[null,"Oxygen",null,"O2",null,null,null,null,null,{"$f":"J56*$I$105","v":6055649.5768531244},{"$f":"J74+O107","v":6044719.2040596576},null,null,null,null,null,null,null,null,{"$f":"T56*$I$105","v":484156.58658480644},{"$f":"T74","v":484156.58658480644}]
[null,"Carbon dioxide",null,"CO2",null,null,null,null,null,null,{"$f":"J75+O108","v":49210.28528721536}]
[]
[null,"Balance check",null,"Overall:",{"$f":"SUM(E56,F56,H56,J56,T56)-SUM(K56,M56,O56,Q56,R56,U56,V56)<tolerance","v":true},null,{"$f":"G56-F56-E56<tolerance","v":true},null,{"$f":"I56-H56-G56<tolerance","v":true},null,null,{"$f":"I56+L56-K56-J56<tolerance","v":true},null,{"$f":"N56-M56-L56<tolerance","v":true},null,{"$f":"P56-O56-N56<tolerance","v":true},null,null,{"$f":"P56-S56-R56-Q56<tolerance","v":true},null,null,{"$f":"S56+V56-U56-T56<tolerance","v":true}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Calculations & secondary user input"]
[]
[]
[null,"General calculations",null,null,null,null,"Medium composition",null,"g/L water","g/g SFO",null,"Reaction rate",null,"Mass coef.","Conv., kg",null,"Centrifuge material balance"]
[null,"Batch rate",null,{"$f":"D7/s_per_yr","v":3.8051750380517519E-7},"1/s",null,"Sunflower oil",null,30,{"$f":"I92/$I$92","v":1},null,"Sun Flower Oil",null,-15,{"$f":"$O$103/$N$103*N92","v":-88528.937312092894},null,"Component",null,"Feed rate","Mass distribution by phase",null,null,"Mass per batch, kg",null,null,"Balance"]
[null,"Plant capacity (RBF)",null,{"$f":"D6*kg_per_t/s_per_yr","v":3.1709791983764599E-2},"kg/s",null,"Glucose",null,10,0.33333333333333331,null,"Glucose",null,-5,-29509.645770697629,null,"-",null,"kg","oil","solid","aq.","oil","solid","aq.","check"]
[null,null,null,{"$f":"Capacity*s_per_yr","v":1000000},"kg/yr",null,"Peptone",null,10,0.33333333333333331,null,"Peptone",null,-5,-29509.645770697629,null,"Sun Flower Oil",null,{"$f":"P59","v":643.84681681522636},0.2,null,0.8,{"$f":"$S94*T94","v":128.76936336304527},{"$f":"$S94*U94","v":0},{"$f":"$S94*V94","v":515.07745345218109},{"$f":"S94-W94-X94-Y94<0.0001","v":true}]
[null,null,null,{"$f":"Capacity/Batch_rate","v":83333.333333333328},"kg/batch",null,"Yeast extract",null,10,0.33333333333333331,null,"Yeast Extract",null,-5,-29509.645770697629,null,"Glucose",null,268.26950700634552,null,0.2,0.8,0,53.65390140126911,214.61560560507644,true]
[null,"Sunflower oil conversion",null,{"$f":"D12","v":0.99},null,null,"Malt extract",null,10,0.33333333333333331,null,"Malt Extract",null,-5,-29509.645770697629,null,"Peptone",null,268.26950700634552,0.5,null,0.5,134.13475350317276,0,134.13475350317276,true]
[null,"Sunflower oil feed rate",null,{"$f":"-O92/D96","v":89423.169002114038},"kg/s",null,"Methionine",null,0.8,2.6666666666666668E-2,null,"D/L-Methionine",null,-0.4,-2360.7716616558105,null,"Yeast Extract",null,268.26950700634552,0.5,null,0.5,134.13475350317276,0,134.13475350317276,true]
[null,null,null,null,null,null,"Magnesium sulfate",null,0.4,1.3333333333333334E-2,null,"Magne Sulfate",null,-0.2,-1180.3858308279052,null,"Malt Extract",null,268.26950700634552,0.5,null,0.5,134.13475350317276,0,134.13475350317276,true]
[null,null,null,null,null,null,"Potassium phosphate",null,0.4,1.3333333333333334E-2,null,"K2HPO4",null,-0.2,-1180.3858308279052,null,"D/L-Methionine",null,21.461560560507678,0.4,null,0.6,8.5846242242030719,0,12.876936336304606,true]
[null,"Fermenter calculations",null,null,null,null,"Sulfuric acid",null,4,0.13333333333333333,null,"Sulfuric acid",null,0,0,null,"Magne Sulfate",null,10.730780280253839,null,0.2,0.8,0,2.146156056050768,8.5846242242030719,true]
[null,"Working volume",null,{"$f":"I53","v":3554.5384178005161},"m3",null,null,null,null,null,null,null,null,null,null,null,"K2HPO4",null,10.730780280253839,null,0.2,0.8,0,2.146156056050768,8.5846242242030719,true]
[null,"Fermentation time",null,{"$f":"Fermentation_Time","v":500},"h",null,null,null,null,null,null,"Biomass",null,7.7770000000000001,{"$f":"$O$103/$N$103*N102","v":45899.303031743097},null,"Sulfuric Acid",null,11911.166111081589,null,null,1,0,0,11911.166111081589,true]
[null,null,null,{"$f":"D102*s_per_h","v":1800000},"s",null,"Other compositions",null,null,null,null,"Riboflavin, aq.",null,15.847,{"$f":"Gross_product_rate","v":93527.871305649067}]
[null,"MW air",null,{"$f":"MW_O2*I105+MW_N2*(1-I105)","v":28.938288},"kg/kmol",null,"Glucose in syrup",null,0.7,"mass",null,"Riboflavin, s.",null,0,{"$f":"$O$103/$N$103*N104","v":0},null,"Biomass",null,{"$f":"P69","v":45899.303031743097},0.8,0.2,null,{"$f":"$S104*T104","v":36719.442425394482},9179.8606063486204,0,{"$f":"S104-W104-X104-Y104<0.0001","v":true}]
[null,"Air density",null,{"$f":"MW_air/scm_per_kmol","v":1.2238784507410516},"kg/scm",null,"Oxygen in air",null,0.23200000000000001,"mass",null,null,null,null,null,null,"Riboflavin",null,{"$f":"P70","v":9352.7871305649023},0.5,null,0.5,4676.3935652824512,0,4676.3935652824512,{"$f":"S105-W105-X105-Y105<0.0001","v":true}]
[null,"Air rate",null,{"$f":"D13","v":0.2},"vvm",null,null,null,null,null,null,"Nitrogen",null,0,{"$f":"$O$103/$N$103*N106","v":0},null,"Riboflavin (cr)",null,{"$f":"P71","v":84175.084175084165},0.01,0.99,null,841.75084175084169,83333.333333333328,0,{"$f":"S106-W106-X106-Y106<0.0001","v":true}]
[null,null,null,{"$f":"D106*D101","v":710.90768356010324},"scm/min",null,null,null,null,null,null,"Oxygen",null,-1.8520000000000001,{"$f":"$O$103/$N$103*N107","v":-10930.372793466402}]
[null,null,null,{"$f":"D107/s_per_min/scm_per_kmol","v":0.50110347139140188},"kmol/s",null,null,null,null,null,null,"Carb. Dioxide",null,8.3379999999999992,{"$f":"$O$103/$N$103*N108","v":49210.28528721536},null,"Nitrogen",null,{"$f":"P73","v":0},null,null,null,null,null,null,{"$f":"S108-W108-X108-Y108<0.0001","v":true}]
[null,null,null,{"$f":"D108*D104","v":14.501076572924148},"kg/s",null,null,null,null,null,null,null,null,null,null,null,"Oxygen",null,{"$f":"P74","v":0},null,null,null,null,null,null,{"$f":"S109-W109-X109-Y109<0.0001","v":true}]
[null,null,null,{"$f":"D103*D109","v":26101937.831263468},"kg/batch",null,null,null,null,null,null,"Water",null,5.69,{"$f":"$O$103/$N$103*N110","v":33581.976887053905},null,"Carb. Dioxide",null,{"$f":"P75","v":0},null,null,null,null,null,null,{"$f":"S110-W110-X110-Y110<0.0001","v":true}]
[]
[null,"Spray dryer calculations",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Water",null,{"$f":"P57","v":2107961.4532602159},null,0.2,0.8,{"$f":"$S112*T112","v":0},{"$f":"$S112*U112","v":421592.29065204319},{"$f":"$S112*V112","v":1686369.1626081727},{"$f":"S112-W112-X112-Y112<0.0001","v":true}]
[null,"Water evaporation",null,{"$f":"D27","v":0.99},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"S113-W113-X113-Y113<0.0001","v":true}]
[null,null,null,{"$f":"D113*S57","v":417376.36774552276},"kg"]
[null,"Air mass per batch",null,{"$f":"D28","v":5},"x water evaporated"]
[null,null,null,{"$f":"D115*D114","v":2086881.8387276139},"kg"]

{"sheet":"Equipment sizing","index":4,"n_rows":295,"n_cols":24,"rows_kept":295,"cut":false,"hidden":false,"merged":[]}
["Equipment sizing"]
[null,"This page uses information from the process model to estimate equipment capacities, utility requirements, and labor requirements."]
[]
[]
[null,"Equipment list",null,null,"Fermenters","Vessels",null,null,null,null,null,"Separation equipment",null,null,"Fluid transport equipment",null,null,null,null,"Misc. equipment"]
[null,"Tag",null,"-",{"$f":"E74","v":"R-200"},{"$f":"L74","v":"T-005"},"T-010","T-350","T-300","T-400","T-500",{"$f":"E128","v":"CR-300"},{"$f":"L128","v":"DC-400"},{"$f":"R128","v":"SD-500"},{"$f":"E201","v":"K-200"},{"$f":"L201","v":"P-005"},{"$f":"M201","v":"P-010"},{"$f":"N201","v":"P-300"},{"$f":"O201","v":"P-350"},{"$f":"E255","v":"H-005"},{"$f":"F255","v":"H-101"},{"$f":"L255","v":"F-200"},{"$f":"M255","v":"F-205"},"Total"]
[null,"Capacity metric",null,"-","Volume","Volume","Volume","Volume","Volume","Volume","Volume","Volume","Throughput","Volume","Power","Power","Power","Power","Power","Throughput","Throughput","Throughput","Throughput","-"]
[null,"Capacity units",null,"-","m3","m3","m3","m3","m3","m3","m3","m3","m3/h","m3","kW","kW","kW","kW","kW","m3/h","m3/h","m3/h","m3/h","-"]
[null,"Capacity per unit",null,"-",{"$f":"E80","v":493.68589136118277},{"$f":"L80","v":39.981089255778699},982.70295034256571,439.53231316334569,3955.7908184701118,2826.3245520933133,642.7042885065481,{"$f":"E136","v":29.302154210889718},{"$f":"L136","v":18.84216368062209},{"$f":"R136","v":34.781363978793564},{"$f":"E212","v":1980.2050377755136},{"$f":"L212","v":0.42308030958495979},12.47876762339766,13.953406767090339,3.8759463241917618,{"$f":"E266","v":10.661623801540987},{"$f":"F266","v":26.205412009135088},{"$f":"L266","v":7109.0768356010321},{"$f":"M266","v":14239.005367419973},"-"]
[null,"Number of units",null,"-",{"$f":"E81","v":12},1,4,1,1,1,1,{"$f":"E137","v":2},{"$f":"L137","v":1},{"$f":"R137","v":1},{"$f":"E213","v":2},1,1,1,12,{"$f":"E267","v":1},{"$f":"F267","v":12},{"$f":"L267","v":1},{"$f":"M267","v":3},"-"]
[]
[null,"Electrical power",null,"kW-h",{"$f":"E82","v":1421815.3671202066},{"$f":"L82/1000","v":0.22389409983236072},null,null,null,null,null,{"$f":"E138","v":632.92653095521791},{"$f":"L138","v":7976.515958130025},{"$f":"R138","v":10283.26861610477},{"$f":"E214","v":1980205.0377755135},{"$f":"L214","v":1.2692409287548794},{"$f":"M214","v":124.7876762339766},{"$f":"N214","v":13.953406767090339},{"$f":"O214","v":139.53406767090343},null,null,null,null,{"$f":"SUM(E12:W12)","v":3421192.8842866104}]
[null,"Steam",null,"MT",{"$f":"E83/1000","v":14.4},{"$f":"L83/1000","v":0.68474278865396976},null,null,null,null,null,{"$f":"E139/1000","v":1344.5118296669075},null,{"$f":"R139/1000","v":501.98613358975797},null,null,null,null,null,{"$f":"E269/1000","v":1.2822734946113343},{"$f":"F269/1000","v":179.23827960796737},null,null,{"$f":"SUM(E13:W13)","v":2042.1032591478981}]
[null,"Cooling water",null,"MT",null,null,null,null,null,null,null,null,null,null,{"$f":"E216/1000","v":232494.0215148624},null,null,null,null,{"$f":"E270/1000","v":193.26131617347863},{"$f":"F270/1000","v":12006.39193546193},null,null,{"$f":"SUM(E14:W14)","v":244693.6747664978}]
[null,"Chilled water",null,"MT",{"$f":"E85/1000","v":248460.53466817102},null,null,null,null,null,null,{"$f":"E141/1000","v":33915.89462511977},null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E15:W15)","v":282376.42929329077}]
[null,"Process water",null,"m3",null,null,null,null,null,null,null,{"$f":"E191","v":64.970924306423953},null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E16:W16)","v":64.970924306423953}]
[]
[null,"Operating labor",null,"h",{"$f":"E65","v":101},{"$f":"F65","v":0},0,0,0,0,0,301,60,60,25,0.15000000000000002,5.5,0.55000000000000004,1.6500000000000001,0,0,5,5,{"$f":"SUM(E18:W18)","v":564.84999999999991}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Timing, labor, usage",null,null,"Fermenters","Vessels",null,null,null,null,null,"Separation equipment",null,null,"Fluid transport equipment",null,null,null,null,"Misc. equipment"]
[null,"Tag",null,"-",{"$f":"E6","v":"R-200"},"T-005","T-010","T-350","T-300","T-400","T-500","CR-300","DC-400","SD-500","K-200","P-005","P-010","P-300","P-350","H-005","H-101","F-200","F-205"]
[null,"Process time",null,"h",{"$f":"Dashboard!E10","v":500},7,7,9,null,null,null,120,120,120,500,3,10,1,3,3,10,500,500]
[null,"Process labor",null,"labor-h/h",0.2,null,null,null,null,null,null,2.5,0.5,0.5,0.05,0.05,{"$f":"0.5+0.05","v":0.55000000000000004},0.55000000000000004,{"$f":"0.5+0.05","v":0.55000000000000004},null,null,0.01,0.01]
[null,null,null,"labor-h",{"$f":"E58*E57","v":100},{"$f":"F58*F57","v":0},0,0,0,0,0,300,60,60,25,0.15000000000000002,5.5,0.55000000000000004,1.6500000000000001,0,0,5,5]
[]
[null,"CIP time",null,"h",2,null,null,null,null,null,null,2]
[null,"CIP labor",null,"labor-h/h",0.5,null,null,null,null,null,null,0.5]
[null,null,null,"labor-h",{"$f":"E62*E61","v":1},{"$f":"F62*F61","v":0},{"$f":"G62*G61","v":0},{"$f":"H62*H61","v":0},{"$f":"I62*I61","v":0},{"$f":"J62*J61","v":0},{"$f":"K62*K61","v":0},{"$f":"L62*L61","v":1},{"$f":"M62*M61","v":0},{"$f":"N62*N61","v":0},{"$f":"O62*O61","v":0},{"$f":"P62*P61","v":0},{"$f":"Q62*Q61","v":0},{"$f":"R62*R61","v":0},{"$f":"S62*S61","v":0},{"$f":"T62*T61","v":0},{"$f":"U62*U61","v":0},{"$f":"V62*V61","v":0},{"$f":"W62*W61","v":0}]
[]
[null,"Total labor per batch",null,"h",{"$f":"E63+E59","v":101},{"$f":"F63+F59","v":0},0,0,0,0,0,301,60,60,25,0.15000000000000002,5.5,0.55000000000000004,1.6500000000000001,0,0,5,5]
[]
[]
[]
[]
[]
["Fermenter & vessel sizing"]
[]
[]
[null,"Fermenters",null,null,"R-200",null,null,null,"Vessels & tanks",null,null,"T-005","T-010","T-350","T-300","T-400","T-500"]
[null,"Stream",null,"-",200,null,null,null,"Stream",null,"-",5,10,105,400,500,600]
[null,"Max working volume",null,"-",0.6,null,null,null,"Max working volume",null,"-",0.8,0.8,0.8,0.8,0.8,0.8]
[null,"Max vessel volume",null,"m3",{"$f":"Dashboard!E9","v":500},null,null,null,"Max vessel volume",null,"m3",80,1000,500,10000,10000,10000]
[]
[null,"Results summary",null,null,null,null,null,null,"Results summary"]
[null,"Unit capacity",null,"m3",{"$f":"E91","v":493.68589136118277},null,null,null,"Unit capacity",null,"m3",{"$f":"L91","v":39.981089255778699},982.70295034256571,439.53231316334569,3955.7908184701118,2826.3245520933133,642.7042885065481]
[null,"Units in parallel",null,"-",{"$f":"E90","v":12},null,null,null,"Units in parallel",null,"-",{"$f":"L90","v":1},4,1,1,1,1]
[null,"Electrical power",null,"kW-h",{"$f":"E99","v":1421815.3671202066},null,null,null,"Electrical power",null,"kW-h",{"$f":"L99","v":223.89409983236072},{"$f":"M99","v":"-"},"-","-","-","-"]
[null,"Steam",null,"kg",{"$f":"E114","v":14400},null,null,null,"Steam",null,"kg",{"$f":"L108","v":684.7427886539698},{"$f":"M108","v":"-"},"-","-","-","-"]
[null,"Cooling water",null,"kg","-",null,null,null,"Cooling water",null,"kg","-","-","-","-","-","-"]
[null,"Chilled water",null,"kg",{"$f":"E108","v":248460534.66817102},null,null,null,"Chilled water",null,"kg","-","-","-","-","-","-"]
[]
[null,"Capacity calculation",null,null,null,null,null,null,"Volume calculation"]
[null,"Batch volume",null,"m3",{"$f":"StreamTable(E75,\"Volume\")","v":3554.5384178005161},null,null,null,"Batch volume",null,"m3",{"$f":"StreamTable(L75,\"Volume\")","v":31.984871404622961},3144.6494410962105,351.62585053067659,3164.6326547760896,2261.0596416746507,514.16343080523848]
[null,"Total vessel volume",null,"m3",{"$f":"E88/E76","v":5924.2306963341935},null,null,null,"Vessel volume",null,"m3",{"$f":"L88/L76","v":39.981089255778699},3930.8118013702629,439.53231316334569,3955.7908184701118,2826.3245520933133,642.7042885065481]
[null,"Units in parallel",null,"-",{"$f":"ROUNDUP(E89/E77,0)","v":12},null,null,null,"Units in parallel",null,"-",{"$f":"ROUNDUP(L89/L77,0)","v":1},4,1,1,1,1]
[null,"Vessel volume",null,"m3",{"$f":"E89/E90","v":493.68589136118277},null,null,null,"Vessel volume",null,"m3",{"$f":"L89/L90","v":39.981089255778699},982.70295034256571,439.53231316334569,3955.7908184701118,2826.3245520933133,642.7042885065481]
[]
[null,"Agitation power calculation",null,null,null,null,null,null,"Agitation power calculation"]
[null,"Process time",null,"h",{"$f":"E57","v":500},null,null,null,"Process time",null,"h",{"$f":"F57","v":7},7,9,0,0,0]
[null,null,null,"s",{"$f":"E94*s_per_h","v":1800000},null,null,null,null,null,"s",{"$f":"L94*s_per_h","v":25200},25200,32400,0,0,0]
[null,"Specific power",null,"kW/m3",0.8,null,null,null,"Specific power",null,"kW/m3",1,"-","-","-","-","-"]
[null,"Power",null,"kW ",{"$f":"E96*E88","v":2843.6307342404129},null,null,null,"Power",null,"kW ",{"$f":"L96*L88","v":31.984871404622961},"-","-","-","-","-"]
[null,null,null,"kJ",{"$f":"E97*E95","v":5118535321.6327429},null,null,null,null,null,"kJ",{"$f":"L97*L95","v":806018.75939649867},"-","-","-","-","-"]
[null,null,null,"kW-h",{"$f":"E97*E94","v":1421815.3671202066},null,null,null,null,null,"kW-h",{"$f":"L97*L94","v":223.89409983236072},"-","-","-","-","-"]
[]
[null,"Chilled water calculations",null,null,null,null,null,null,"Steam calculations"]
[null,"Total mass",null,"kg",{"$f":"StreamTable(E75,\"Mass per batch\")","v":3554538.4178005159},null,null,null,"Total mass",null,"kg",{"$f":"StreamTable(L75,\"Mass per batch\")","v":42539.878968148536},"-","-","-","-","-"]
[null,"Process temp. initial",null,"degC",35,null,null,null,"Process temp. initial",null,"degC",25,"-","-","-","-","-"]
[null,"Process temp. final",null,"degC",30,null,null,null,"Process temp. final",null,"degC",50,"-","-","-","-","-"]
[null,"Duty for temp. change",null,"kJ",{"$f":"(E104-E103)*Cp_H2O*E102","v":-74289852.932030782},null,null,null,"Duty for temp. change",null,"kJ",{"$f":"(L104-L103)*Cp_GlucoseSyrup*L102","v":2243978.6155698351},"-","-","-","-","-"]
[null,"Total duty",null,"kJ",{"$f":"E105-E98","v":-5192825174.5647736},null,null,null,"Total duty",null,"kJ",{"$f":"L105-L98","v":1437959.8561733365},"-","-","-","-","-"]
[]
[null,"Chilled water ",null,"kg",{"$f":"E106/Cp_H2O/(T_ChilledWater_Supply-T_ChilledWater_Return)","v":248460534.66817102},null,null,null,"Steam",null,"kg",{"$f":"L106/Hvap_H2O","v":684.7427886539698},"-","-","-","-","-"]
[null,null,null,"kg/h",{"$f":"E108/E94","v":496921.06933634204},null,null,null,null,null,"kg/h",{"$f":"L108/L94","v":97.820398379138538},"-","-","-","-","-"]
[]
[null,"Steam in place calculations"]
[null,"Time",null,"h",{"$f":"E61","v":2}]
[null,"Rate",null,"kg/h",7200]
[null,"Steam per batch",null,"kg",{"$f":"E113*E112","v":14400}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Separation equipment sizing"]
[]
[]
[null,"Crystallizers",null,null,"CR-300",null,null,null,"Decanting centrifuges",null,null,"DC-400",null,null,"Spray dryers",null,null,"SD-500"]
[null,"Stream",null,null,400,null,null,null,"Stream",null,"-",500,null,null,"Process time",null,"h",{"$f":"N57","v":120}]
[null,"Process time",null,"h",{"$f":"L57","v":120},null,null,null,"Process time",null,"h",{"$f":"M57","v":120},null,null,"Temperature out",null,"degC",70]
[null,"Residence time",null,"h",2,null,null,null,"Specific power",null,"kJ/m3",12700,null,null,"Max volume",null,"m3",10000]
[null,"Max working volume",null,"-",0.9,null,null,null,"Max throughput",null,"m3/h",9000]
[null,"Max volume",null,"m3",40]
[]
[null,"Results summary",null,null,null,null,null,null,"Results summary",null,null,null,null,null,"Results summary"]
[null,"Unit capacity",null,"m3",{"$f":"E149","v":29.302154210889718},null,null,null,"Unit capacity",null,"m3",{"$f":"L147","v":18.84216368062209},null,null,"Unit capacity",null,"m3",{"$f":"R148","v":34.781363978793564}]
[null,"Units in parallel",null,"-",{"$f":"E148","v":2},null,null,null,"Units in parallel",null,"-",{"$f":"L146","v":1},null,null,"Units in parallel",null,"-",{"$f":"R147","v":1}]
[null,"Electrical power",null,"kW-h",{"$f":"E156","v":632.92653095521791},null,null,null,"Electrical power",null,"kW-h",{"$f":"L151","v":7976.515958130025},null,null,"Electrical power",null,"kW-h",{"$f":"R152","v":10283.26861610477}]
[null,"Steam",null,"kg",{"$f":"E170","v":1344511.8296669074},null,null,null,"Steam",null,"kg","-",null,null,"Steam",null,"kg",{"$f":"R174","v":501986.13358975796}]
[null,"Cooling water",null,"kg","-",null,null,null,"Cooling water",null,"kg","-",null,null,"Cooling water",null,"kg","-"]
[null,"Chilled water",null,"kg",{"$f":"E179","v":33915894.625119768},null,null,null,"Chilled water",null,"kg","-",null,null,"Chilled water",null,"kg","-"]
[]
[null,"Volume calculation",null,null,null,null,null,null,"Throughput calculation",null,null,null,null,null,"Volume calculation"]
[null,"Batch volume",null,"m3",{"$f":"StreamTable(E129,\"Volume\")","v":3164.6326547760896},null,null,null,"Volume, total",null,"m3",{"$f":"StreamTable(L129,\"Volume\")","v":2261.0596416746507},null,null,"Specific evap. rate",null,"(kg/h)/m3",100]
[null,"Throughput rate",null,"m3/h",{"$f":"E144/E130","v":26.371938789800748},null,null,null,"Rate, total",null,"m3/h",{"$f":"L144/L130","v":18.84216368062209},null,null,"Evaporation rate",null,"kg/h",{"$f":"R169/R129","v":3478.1363978793565}]
[null,"Working volume",null,"m3",{"$f":"E145*E131","v":52.743877579601495},null,null,null,"Units in parallel",null,"-",{"$f":"ROUNDUP(L145/L132,0)","v":1},null,null,"Vessel volume",null,"m3",{"$f":"R145/R144","v":34.781363978793564}]
[null,"Total vessel volume",null,"m3",{"$f":"E146/E132","v":58.604308421779436},null,null,null,"Unit throughput",null,"m3/h",{"$f":"L145/L146","v":18.84216368062209},null,null,"Units in parallel",null,"-",{"$f":"ROUNDUP(R146/R131,0)","v":1}]
[null,"Units in parallel",null,"-",{"$f":"ROUNDUP(E147/E133,0)","v":2},null,null,null,null,null,null,null,null,null,"Vessel volume",null,"m3",{"$f":"R146/R147","v":34.781363978793564}]
[null,"Vessel volume",null,"m3",{"$f":"E147/E148","v":29.302154210889718},null,null,null,"Power calculation"]
[null,null,null,null,null,null,null,null,"Power, unit",null,"kJ",{"$f":"L131*L144","v":28715457.449268065},null,null,"Power calculation"]
[null,"Agitation power calculation",null,null,null,null,null,null,null,null,"kW-h",{"$f":"L150/kJ_per_kWh","v":7976.515958130025},null,null,"Specific power",null,"kW/(kg/h)",0.02]
[null,"Specific power",null,"kW/m3",0.1,null,null,null,null,null,"kW",{"$f":"L151/L130","v":66.470966317750211},null,null,"Power",null,"kW-h",{"$f":"R151*R156","v":10283.26861610477}]
[null,"Process time",null,"s",{"$f":"E130*s_per_h","v":432000}]
[null,"Power",null,"kW",{"$f":"E152*E146","v":5.2743877579601497},null,null,null,null,null,null,null,null,null,"Heat to raise liquid stream temperature"]
[null,null,null,"kJ",{"$f":"E154*E153","v":2278535.5114387847},null,null,null,null,null,null,null,null,null,"Stream",null,"-",600]
[null,null,null,"kW-h",{"$f":"E154*E130","v":632.92653095521791},null,null,null,null,null,null,null,null,null,"Batch mass",null,"kg",{"$f":"StreamTable(R155,\"Mass per batch\")","v":514163.43080523843}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Temperature in",null,"degC",25]
[null,"Evaporation calculations",null,null,null,null,null,null,null,null,null,null,null,null,"Specific heat",null,"kJ/(kg-K)",3.58]
[null,"Batch mass",null,"kg",{"$f":"StreamTable(E129,\"Mass per batch\")","v":3164632.6547760894},null,null,null,null,null,null,null,null,null,"Duty",null,"kJ",{"$f":"R156*R158*(R130-R157)","v":82831728.70272392}]
[null,"Temperature in",null,"degC",30]
[null,"Temperature evap.",null,"degC",100,null,null,null,null,null,null,null,null,null,"Heat to raise gas stream temperature"]
[null,"Duty for temp. change",null,"kJ",{"$f":"(E161-E160)*Cp_H2O*E159","v":925971514.78748369},null,null,null,null,null,null,null,null,null,"Stream",null,"-",605]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Batch mass",null,"kg",{"$f":"StreamTable(R162,\"Mass per batch\")","v":2086881.8387276139}]
[null,"Exhaust gas stream",null,"-",450,null,null,null,null,null,null,null,null,null,"Temperature in",null,"degC",25]
[null,"Exhaust gas mass",null,"kg",{"$f":"StreamTable(E164,\"Mass per batch\")","v":903573.01310143911},null,null,null,null,null,null,null,null,null,"Duty",null,"kJ",{"$f":"R163*Cp_air*(R130-R164)","v":94848779.570170045}]
[null,"Duty for evaporation",null,"kJ",{"$f":"E165*Hvap_H2O","v":1897503327.5130222}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Heat for evaporation"]
[null,"Total duty",null,"kJ",{"$f":"E162+E166","v":2823474842.3005056},null,null,null,null,null,null,null,null,null,"Stream",null,"-",650]
[null,null,null,"kJ/hr",{"$f":"E168/E130","v":23528957.01917088},null,null,null,null,null,null,null,null,null,"Batch water mass",null,"kg",{"$f":"StreamTable(R168,\"Water\")","v":417376.36774552276}]
[null,"Steam rate",null,"kg",{"$f":"E168/Hvap_H2O","v":1344511.8296669074},null,null,null,null,null,null,null,null,null,"Duty",null,"kJ",{"$f":"R169*Hvap_H2O","v":876490372.26559782}]
[null,null,null,"kg/h",{"$f":"E170/E130","v":11204.265247224228}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total heating duty"]
[null,"Evaporation calculations",null,null,null,null,null,null,null,null,null,null,null,null,"Duty",null,"kJ",{"$f":"R170+R165+R159","v":1054170880.5384917}]
[null,"Crystallized stream",null,"-",500,null,null,null,null,null,null,null,null,null,"Steam rate",null,"kg",{"$f":"R173/Hvap_H2O","v":501986.13358975796}]
[null,"Total mass",null,"kg",{"$f":"StreamTable(E174,\"Mass per batch\")","v":2261059.6416746508},null,null,null,null,null,null,null,null,null,null,null,"kg/h",{"$f":"R174/R129","v":4183.2177799146493}]
[null,"Temperature in",null,"degC",100]
[null,"Temperature out",null,"degC",25]
[null,"Cooling duty",null,"kJ",{"$f":"(E177-E176)*Cp_H2O*E175","v":-708842197.66500306}]
[null,"Chilled water rate",null,"kg",{"$f":"E178/(Cp_H2O*(T_ChilledWater_Supply-T_ChilledWater_Return))","v":33915894.625119768}]
[null,null,null,"kg/h",{"$f":"E179/E130","v":282632.45520933141}]
[]
[null,"Clean in place calculations"]
[null,"Vol flow per circ.",null,"(m3/h)/m",2.1]
[null,"Time",null,"h",{"$f":"L61","v":2}]
[null,"Vessel volume",null,"m3",{"$f":"E136","v":29.302154210889718}]
[null,"Height / diameter",null,"-",2.5]
[null,"Diameter",null,"m",{"$f":"(4*E185/E186/PI())^(1/3)","v":2.4620104191944625}]
[null,"Circumference",null,"m",{"$f":"PI()*E187","v":7.7346338460028505}]
[null,"Flow rate per vessel",null,"m3/h",{"$f":"E183*E188","v":16.242731076605988}]
[null,"Total flow rate",null,"m3/h",{"$f":"E189*E137","v":32.485462153211976}]
[null,"Total volume H2O",null,"m3",{"$f":"E190*E184","v":64.970924306423953}]
[]
[]
[]
[]
[]
[]
["Fluid transport equipment sizing"]
[]
[]
[null,"Compressors",null,null,"K-200",null,null,null,"Pumps",null,null,"P-005","P-010","P-300","P-350"]
[null,"Stream",null,"-",205,null,null,null,"Stream",null,"-",5,10,105,300]
[null,"Process time",null,"h",{"$f":"O57","v":500},null,null,null,"Operating time",null,"h",{"$f":"P57","v":3},{"$f":"Q57","v":10},{"$f":"R57","v":1},{"$f":"S57","v":3}]
[null,"P1",null,"bar",1,null,null,null,"Pressure change",null,"bar",1,1,1,1]
[null,"P2",null,"bar",6,null,null,null,"Efficiency",null,"-",0.7,0.7,0.7,0.7]
[null,"T1",null,"degC",25,null,null,null,"Max power per unit",null,"kW",300,300,300,4]
[null,"T2 (after cooling)",null,"degC",40]
[null,"Efficiency",null,"-",0.7]
[null,"Max power per unit",null,"kW",3000]
[]
[null,"Results summary",null,null,null,null,null,null,"Results summary"]
[null,"Unit capacity",null,"kW",{"$f":"E234","v":1980.2050377755136},null,null,null,"Unit capacity",null,"kW",{"$f":"L230","v":0.42308030958495979},{"$f":"M230","v":12.47876762339766},{"$f":"N230","v":13.953406767090339},{"$f":"O230","v":3.8759463241917618}]
[null,"Units in parallel",null,"-",{"$f":"E233","v":2},null,null,null,"Units in parallel",null,"-",{"$f":"L229","v":1},{"$f":"M229","v":1},{"$f":"N229","v":1},{"$f":"O229","v":12}]
[null,"Electrical power",null,"kW-h",{"$f":"E232","v":1980205.0377755135},null,null,null,"Electrical power",null,"kW-h",{"$f":"L228","v":1.2692409287548794},{"$f":"M228","v":124.7876762339766},{"$f":"N228","v":13.953406767090339},{"$f":"O228","v":139.53406767090343}]
[null,"Steam",null,"kg","-",null,null,null,"Steam",null,"kg","-","-","-","-"]
[null,"Cooling water",null,"kg",{"$f":"E243","v":232494021.51486239},null,null,null,"Cooling water",null,"kg","-","-","-","-"]
[null,"Chilled water",null,"kg","-",null,null,null,"Chilled water",null,"kg","-","-","-","-"]
[]
[null,"Throughput calculation",null,null,null,null,null,null,"Throughput calculation"]
[null,"Process time",null,"s",{"$f":"E203*s_per_h","v":1800000},null,null,null,"Volume total",null,"m3",{"$f":"StreamTable(L202,\"Volume\")","v":31.984871404622961},{"$f":"StreamTable(M202,\"Volume\")","v":3144.6494410962105},{"$f":"StreamTable(N202,\"Volume\")","v":351.62585053067659},{"$f":"StreamTable(O202,\"Volume\")","v":3516.2585053067664}]
[null,"Batch air volume",null,"m3",{"$f":"StreamTable(E202,\"Volume\")","v":21327230.506803095},null,null,null,"Operating time",null,"s",{"$f":"L203*s_per_h","v":10800},{"$f":"M203*s_per_h","v":36000},{"$f":"N203*s_per_h","v":3600},{"$f":"O203*s_per_h","v":10800}]
[null,"Air rate",null,"m3/s",{"$f":"E221/E220","v":11.848461392668387},null,null,null,"Volume rate total",null,"m3/s",{"$f":"L220/L221","v":2.9615621670947188E-3},{"$f":"M220/M221","v":8.7351373363783624E-2},{"$f":"N220/N221","v":9.7673847369632388E-2},{"$f":"O220/O221","v":0.325579491232108}]
[null,null,null,"m3/h",{"$f":"E222*s_per_h","v":42654.461013606197}]
[null,null,null,null,null,null,null,null,"Power calculation"]
[null,"Power calculation",null,null,null,null,null,null,"Pressure change",null,"kPa",{"$f":"L204*kPa_per_bar","v":99.999999999999986},{"$f":"M204*kPa_per_bar","v":99.999999999999986},{"$f":"N204*kPa_per_bar","v":99.999999999999986},{"$f":"O204*kPa_per_bar","v":99.999999999999986}]
[null,"γ  (Cp/Cv ratio)",null,"-",1.4,null,null,null,"Fluid power",null,"kW",{"$f":"L225*L222","v":0.29615621670947184},{"$f":"M225*M222","v":8.7351373363783615},{"$f":"N225*N222","v":9.7673847369632369},{"$f":"O225*O222","v":32.557949123210797}]
[null,"γ/(γ-1)",null,null,{"$f":"E226/(E226-1)","v":3.5000000000000004},null,null,null,"Power",null,"kW",{"$f":"L226/L205","v":0.42308030958495979},{"$f":"M226/M205","v":12.47876762339766},{"$f":"N226/N205","v":13.953406767090339},{"$f":"O226/O205","v":46.511355890301139}]
[null,"Compression ratio",null,"-",{"$f":"E205/E204","v":6},null,null,null,null,null,"kW-h",{"$f":"L227*L203","v":1.2692409287548794},{"$f":"M227*M203","v":124.7876762339766},{"$f":"N227*N203","v":13.953406767090339},{"$f":"O227*O203","v":139.53406767090343}]
[null,"Suction pressure",null,"kPa",{"$f":"E204*kPa_per_bar","v":99.999999999999986},null,null,null,"Units in parallel",null,"-",{"$f":"ROUNDUP(L227/L206,0)","v":1},{"$f":"ROUNDUP(M227/M206,0)","v":1},{"$f":"ROUNDUP(N227/N206,0)","v":1},{"$f":"ROUNDUP(O227/O206,0)","v":12}]
[null,"Fluid power",null,"kW",{"$f":"E229*E222*E227*(E228^(1/E227)-1)","v":2772.2870528857188},null,null,null,"Unit power",null,"kW",{"$f":"L227/L229","v":0.42308030958495979},{"$f":"M227/M229","v":12.47876762339766},{"$f":"N227/N229","v":13.953406767090339},{"$f":"O227/O229","v":3.8759463241917618}]
[null,"Power",null,"kW",{"$f":"E230/E208","v":3960.4100755510271}]
[null,null,null,"kW-h",{"$f":"E231*E203","v":1980205.0377755135}]
[null,"Units in parallel",null,"-",{"$f":"ROUNDUP(E231/E209,0)","v":2}]
[null,"Unit power",null,"kW",{"$f":"E231/E233","v":1980.2050377755136}]
[]
[null,"Cooling calculations"]
[null,"Air mass, total",null,"kg",{"$f":"StreamTable(E202,\"Mass per batch\")","v":26101937.831263468}]
[null,"T1",null,"K",{"$f":"E206+273.15","v":298.14999999999998}]
[null,"T2 (before cooling)",null,"K",{"$f":"E238*E228^(1/E227)","v":497.46638799214793}]
[null,"T2 (after cooling)",null,"K",{"$f":"E207+273.15","v":313.14999999999998}]
[null,"Cooling duty",null,"kJ",{"$f":"(E240-E239)*Cp_air*E237","v":-4859125049.6606236}]
[null,null,null,null,{"$f":"E241/500","v":-9718250.099321248}]
[null,"Cooling water ",null,"kg",{"$f":"E241/(T_CW_supply-T_CW_return)/Cp_H2O","v":232494021.51486239}]
[null,null,null,"kg/h",{"$f":"E243/E203","v":464988.04302972479}]
[]
[]
[]
[]
[]
[]
[]
["Miscellaneous equipment sizing"]
[]
[]
[null,"Inline sterilizers",null,null,"H-005","H-101",null,null,"Filters",null,null,"F-200","F-205"]
[null,"Stream",null,"-",5,10,null,null,"Stream",null,"-",205,250]
[null,"Process time",null,"h",{"$f":"T57","v":3},{"$f":"U57","v":10},null,null,"Operating time",null,"h",{"$f":"V57","v":500},{"$f":"W57","v":500}]
[null,"T in",null,"degC",50,25,null,null,"Pressure",null,"bar",6,1]
[null,"T sterilization",null,"degC",140,140,null,null,"Max throughput /unit",null,"m3/h",14400,14400]
[null,"T out",null,"degC",35,35]
[null,"Exchanger approach",null,"degC",30,30]
[null,"Specific heat fluid",null,"kJ/(kg-K)",2.11,3.97]
[null,"Max throughput /unit",null,"m3/h",28,28]
[]
[null,"Results summary",null,null,null,null,null,null,"Results summary"]
[null,"Unit capacity",null,"m3/h",{"$f":"E278","v":10.661623801540987},{"$f":"F278","v":26.205412009135088},null,null,"Unit capacity",null,"m3/h",{"$f":"L278","v":7109.0768356010321},{"$f":"M278","v":14239.005367419973}]
[null,"Units in parallel",null,"-",{"$f":"E277","v":1},{"$f":"F277","v":12},null,null,"Units in parallel",null,"-",{"$f":"L277","v":1},{"$f":"M277","v":3}]
[null,"Electrical power",null,"kW-h","-","-",null,null,"Electrical power",null,"kW-h","-","-"]
[null,"Steam",null,"kg",{"$f":"E289","v":1282.2734946113344},{"$f":"F289","v":179238.27960796736},null,null,"Steam",null,"kg","-","-"]
[null,"Cooling water",null,"kg",{"$f":"E295","v":193261.31617347864},{"$f":"F295","v":12006391.935461931},null,null,"Cooling water",null,"kg","-","-"]
[null,"Chilled water",null,"kg","-","-",null,null,"Chilled water",null,"kg","-","-"]
[]
[null,"Throughput calculations",null,null,null,null,null,null,"Throughput calculations"]
[null,"Batch mass",null,"kg",{"$f":"StreamTable(E256,\"Mass per batch\")","v":42539.878968148536},{"$f":"StreamTable(F256,\"Mass per batch\")","v":3160372.6883016913},null,null,"Std. volume, batch",null,"m3",{"$f":"StreamTable(L256,\"Volume\")","v":21327230.506803095},{"$f":"StreamTable(M256,\"Volume\")","v":21358508.05112996}]
[null,"Batch volume",null,"m3",{"$f":"StreamTable(E256,\"Volume\")","v":31.984871404622961},{"$f":"StreamTable(F256,\"Volume\")","v":3144.6494410962105},null,null,"Act. volume, batch",null,"m3",{"$f":"L274/L258","v":3554538.4178005159},{"$f":"M274/M258","v":21358508.05112996}]
[null,"Capacity",null,"m3/h",{"$f":"E275/E257","v":10.661623801540987},{"$f":"F275/F257","v":314.46494410962106},null,null,null,null,"m3/h",{"$f":"L275/L257","v":7109.0768356010321},{"$f":"M275/M257","v":42717.01610225992}]
[null,"Units in parallel",null,"-",{"$f":"ROUNDUP(E276/E263,0)","v":1},{"$f":"ROUNDUP(F276/F263,0)","v":12},null,null,"Units in parallel",null,"-",{"$f":"ROUNDUP(L276/L259,0)","v":1},{"$f":"ROUNDUP(M276/M259,0)","v":3}]
[null,"Unit throughput",null,"m3/h",{"$f":"E276/E277","v":10.661623801540987},{"$f":"F276/F277","v":26.205412009135088},null,null,"Unit throughput",null,"m3/h",{"$f":"L276/L277","v":7109.0768356010321},{"$f":"M276/M277","v":14239.005367419973}]
[]
[null,"Inlet/outlet exchanger calculations"]
[null,"T1",null,"degC",{"$f":"E258","v":50},{"$f":"F258","v":25}]
[null,"T2",null,"degC",{"$f":"E287-E261","v":110},{"$f":"F287-F261","v":110}]
[null,"Duty",null,"kJ",{"$f":"$E$274*$E$262*(E282-E281)","v":5385548.6773676043},{"$f":"$F$274*$F$262*(F282-F281)","v":1066467763.6674058}]
[]
[null,"Heating calculations"]
[null,"T2",null,"degC",{"$f":"E282","v":110},{"$f":"F282","v":110}]
[null,"T3",null,"degC",{"$f":"E259","v":140},{"$f":"F259","v":140}]
[null,"Duty",null,"kJ",{"$f":"$E$274*$E$262*(E287-E282)","v":2692774.3386838022},{"$f":"$F$274*$F$262*(F287-F282)","v":376400387.17673147}]
[null,"Steam",null,"kg",{"$f":"E288/Hvap_H2O","v":1282.2734946113344},{"$f":"F288/Hvap_H2O","v":179238.27960796736}]
[]
[null,"Cooling calculations"]
[null,"T4",null,"degC",{"$f":"E281+E261","v":80},{"$f":"F281+F261","v":55}]
[null,"T5",null,"degC",{"$f":"E260","v":35},{"$f":"F260","v":35}]
[null,"Duty",null,"kJ",{"$f":"$E$274*$E$262*(E293-E292)","v":-4039161.5080257035},{"$f":"$F$274*$F$262*(F293-F292)","v":-250933591.45115432}]
[null,"Cooling water",null,"kg",{"$f":"E294/(Cp_H2O*(T_CW_supply-T_CW_return))","v":193261.31617347864},{"$f":"F294/(Cp_H2O*(T_CW_supply-T_CW_return))","v":12006391.935461931}]

{"sheet":"Equipment costs","index":5,"n_rows":57,"n_cols":22,"rows_kept":57,"cut":false,"hidden":false,"merged":[[4,4,4,5],[5,4,5,5]]}
["Equipment purchased cost estimation"]
[null,"This page estimates the purchased costs (PC) and installation costs for major equipment based on capacity and year."]
[]
[]
[null,"Total equipment purchased cost",null,null,{"$f":"SUM(K5:K6)","v":38717776.737758085},null,null,"Listed equipment purchased cost",null,null,{"$f":"SUM(D33:V33)","v":34845999.063982278},null,null,"Listed equipment installation",null,null,{"$f":"SUM(D37:V37)","v":11103026.440484812}]
[null,"Total equipment installation cost",null,null,{"$f":"SUM(Q5:Q6)","v":13038915.277372718},null,null,"Unlisted equipment purchased cost",null,null,{"$f":"K5*K7/(1-K7)","v":3871777.6737758089},null,null,"Unlisted equipment installation",null,null,{"$f":"K6*Q7","v":1935888.8368879044}]
[null,null,null,null,null,null,null,"Allowance for unlisted equipment",null,null,0.1,"x purchased cost",null,"Unlisted eq. installation cost",null,null,0.5,"x purchased cost of unlisted equipment"]
[]
[]
[]
[null,null,null,"Fermenters","Vessels",null,null,null,null,null,"Separation equipment",null,null,"Fluid transport equipment",null,null,null,null,"Misc. equipment"]
[null,"Tag",null,"R-200","T-005","T-010","T-350","T-300","T-400","T-500","CR-300","DC-400","SD-500","K-200","P-005","P-010","P-300","P-350","H-005","H-101","F-200","F-205"]
[null,"Capacity metric",null,{"$f":"EquipmentList(D$12,$B13)","v":"Volume"},"Volume","Volume","Volume","Volume","Volume","Volume","Volume","Throughput","Volume",{"$f":"EquipmentList(N$12,$B13)","v":"Power"},"Power","Power","Power","Power","Throughput","Throughput","Throughput","Throughput"]
[null,"Capacity units",null,"m3","m3","m3","m3","m3","m3","m3","m3","m3/h","m3","kW","kW","kW","kW","kW","m3/h","m3/h","m3/h","m3/h"]
[null,"Number of units",null,{"$f":"EquipmentList(D$12,$B15)","v":12},1,4,1,1,1,1,2,1,1,2,1,1,1,12,1,12,1,3]
[null,"Capacity per unit",null,{"$f":"EquipmentList(D$12,$B16)","v":493.68589136118277},39.981089255778699,982.70295034256571,439.53231316334569,3955.7908184701118,2826.3245520933133,642.7042885065481,29.302154210889718,18.84216368062209,34.781363978793564,1980.2050377755136,0.42308030958495979,12.47876762339766,13.953406767090339,3.8759463241917618,10.661623801540987,26.205412009135088,7109.0768356010321,14239.005367419973]
[null,"MOC",null,"SS316","SS316","SS316","SS316","SS316","SS316","SS316","SS316","SS316","SS316","CS","SS316","SS316","SS316","SS316","SS316","SS316","CS","CS"]
[]
[]
[null,"Scaling exponent",null,0.66,0.66,0.66,0.66,0.66,0.66,0.66,0.66,0.6,0.66,0.88,0.6,0.6,0.6,0.6,0.3,0.3,0.3,0.3]
[null,"Capacity (ref.)",null,500,40,1000,1000,1000,1000,1000,40,15,30,2000,10,10,10,10,10,10,3600,3600]
[null,"PC (ref.)",null,912635,122100,1022000,1022000,1022000,1022000,1022000,122100,127400,101000,892000,700,700,700,700,339000,339000,4500,4500]
[null,"PC/unit (ref. year)",null,{"$f":"D22*(D16/D21)^D20","v":905012.10863123555},{"$f":"E22*(E16/E21)^E20","v":122061.89840650359},1010298.2188912246,594052.50222524384,2532939.9029613915,2028885.0237388979,763375.6210742658,99428.244687009952,146080.79908734761,111355.09884030238,884226.24240117101,104.94257783233239,799.46795103556985,854.88203951161063,396.39182798194111,345578.49144913646,452602.54935980705,5519.0677583461929,6797.7573741177139]
[]
[]
[null,"Year (ref.)",null,2005,2005,2005,2005,2005,2005,2005,2005,2005,2005,2002,2005,2005,2005,2005,2005,2005,2005,2005]
[null,"Year (est.)",null,2016,2016,2016,2016,2016,2016,2016,2016,2016,2016,2016,2016,2016,2016,2016,2016,2016,2016,2016]
[null,"CEPCI (ref.)",null,468.2,468.2,468.2,468.2,468.2,468.2,468.2,468.2,468.2,468.2,395.6,468.2,468.2,468.2,468.2,468.2,468.2,468.2,468.2]
[null,"CEPCI (est.)",null,556.79999999999995,556.79999999999995,556.79999999999995,556.79999999999995,556.79999999999995,556.79999999999995,556.79999999999995,556.79999999999995,556.79999999999995,556.79999999999995,556.79999999999995,556.79999999999995,556.79999999999995,556.79999999999995,556.79999999999995,556.79999999999995,556.79999999999995,556.79999999999995,556.79999999999995]
[null,"PC/unit (est. year)",null,{"$f":"D23*D29/D28","v":1076272.4094102348},{"$f":"E23*E29/E28","v":145160.3268533558},1201482.3756485132,706468.24698636425,3012261.7214201251,2412821.8308795779,907833.28879570949,118243.58530911391,173724.45307952829,132427.4221150798,1244532.7901136803,124.80142532473873,950.7555641533645,1016.6559581376864,471.4031820169688,410974.16496984015,538250.9600246487,6563.47058489355,8084.1335025816807]
[]
[]
[null,"Total PC",null,{"$f":"D30*D15","v":12915268.912922818},145160.3268533558,4805929.5025940528,706468.24698636425,3012261.7214201251,2412821.8308795779,907833.28879570949,236487.17061822783,173724.45307952829,132427.4221150798,2489065.5802273606,124.80142532473873,950.7555641533645,1016.6559581376864,5656.8381842036251,410974.16496984015,6459011.5202957839,6563.47058489355,24252.400507745042]
[]
[]
[null,"Installation factor",null,0.2,0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5]
[null,"Installation cost",null,{"$f":"D36*D33","v":2583053.7825845638},43548.09805600674,1441778.8507782158,211940.47409590927,903678.51642603753,723846.54926387337,272349.98663871281,70946.151185468349,86862.226539764146,66213.711057539898,1244532.7901136803,62.400712662369365,475.37778207668225,508.32797906884321,2828.4190921018126,205487.08248492007,3229505.7601478919,3281.735292446775,12126.200253872521]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Cart data"]
[null,null,null,null,null,null,null,null,"Fermenters",{"$f":"D37","v":2583053.7825845638}]
[null,null,null,null,null,null,null,null,"Vessels",{"$f":"SUM(E37:J37)","v":3597142.4752587555}]
[null,null,null,null,null,null,null,null,"Separation ",{"$f":"SUM(K37:M37)","v":224022.08878277242}]
[null,null,null,null,null,null,null,null,"Compressor",{"$f":"N37","v":1244532.7901136803}]
[null,null,null,null,null,null,null,null,"Inline sterilizers",{"$f":"SUM(S37:T37)","v":3434992.842632812}]
[null,null,null,null,null,null,null,null,"Other",{"$f":"SUM(O37:R37,U37:V37)","v":19282.461112229004}]

{"sheet":"CapEx","index":6,"n_rows":50,"n_cols":12,"rows_kept":50,"cut":false,"hidden":false,"merged":[]}
["Fixed capital estimation"]
[null,"This page estimates direct fixed capital investment by applying multiplication factors to purchased equipment cost."]
[]
[]
[null,"Direct fixed capital",null,null,null,null,null,"Total capital investment"]
[null,"Plant direct costs",null,null,null,{"$f":"F38","v":80020669.033694208},null,"Direct fixed capital",null,null,null,{"$f":"DirectFixedCapital","v":128833277.14424767}]
[null,"Plant indirect costs",null,null,null,{"$f":"F44","v":32008267.613477685},null,"Working capital",null,0.1," x (RM+OL+UT+W)",{"$f":"J7*(Cost_RawMaterials+Cost_Labor+Cost_Utilities+Cost_Waste)","v":1515000.3406886535}]
[null,"Other costs",null,null,null,{"$f":"F50","v":16804340.497075785},null,"Startup costs",null,0.1," x DFC",{"$f":"J8*DirectFixedCapital","v":12883327.714424767}]
[null,"Total",null,null,null,{"$f":"SUM(F6:F8)","v":128833277.14424767},null,"Total",null,null,null,{"$f":"SUM(L6:L8)","v":143231605.19936109}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Capital cost component setpoints and calculations"]
[]
[]
[null,"Plant direct costs"]
[null,"Equipment purchase",null,null,null,{"$f":"Eq_PurchasedCost","v":38717776.737758085}]
[null,"Installation",null,null,null,{"$f":"Eq_InstallationCost","v":13038915.277372718}]
[null,"Piping",null,0.15," x PC",{"$f":"D31*Eq_PurchasedCost","v":5807666.5106637124}]
[null,"Instrumentation",null,0.2," x PC",7743555.3475516178]
[null,"Insulation",null,0.03," x PC",1161533.3021327425]
[null,"Electrical facilities",null,0.1," x PC",3871777.6737758089]
[null,"Buildings",null,0.1," x PC",3871777.6737758089]
[null,"Yard improvements",null,0.05," x PC",1935888.8368879044]
[null,"Auxiliary facilities",null,0.1," x PC",3871777.6737758089]
[null,"Total plant direct costs (DC)",null,null,null,{"$f":"SUM(F29:F37)","v":80020669.033694208}]
[]
[]
[null,"Plant indirect costs"]
[null,"Engineering",null,0.15," x DC",{"$f":"D42*$F$38","v":12003100.355054131}]
[null,"Construction",null,0.25," x DC",{"$f":"D43*$F$38","v":20005167.258423552}]
[null,"Total plant indirect costs (IC)",null,null,null,{"$f":"SUM(F42:F43)","v":32008267.613477685}]
[]
[]
[null,"Other costs"]
[null,"Contractor's fee",null,0.05," x (PC + IC)",{"$f":"D48*($F$38+$F$44)","v":5601446.832358595}]
[null,"Contingency",null,0.1," x (PC + IC)",{"$f":"D49*($F$38+$F$44)","v":11202893.66471719}]
[null,"Total",null,null,null,{"$f":"SUM(F48:F49)","v":16804340.497075785}]

{"sheet":"OpEx & Rev","index":7,"n_rows":79,"n_cols":16,"rows_kept":79,"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,"Operating costs",null,null,"USD/year"]
[null,"Raw materials",null,null,{"$f":"Cost_RawMaterials","v":8136519.1297820173}]
[null,"Utilities",null,null,{"$f":"Cost_Utilities","v":5672477.9933996815}]
[null,"Labor",null,null,{"$f":"Cost_Labor","v":756146.99999999988}]
[null,"Waste treatment",null,null,{"$f":"Cost_Waste","v":584859.28370483534}]
[null,"Facilities",null,null,{"$f":"Cost_Facilities","v":10313441.530988192}]
[null,"Laboratory",null,null,{"$f":"Cost_Lab","v":21000}]
[null,"Total",null,null,{"$f":"SUM(E6:E11)","v":25484444.937874727}]
[]
[]
[null,"Revenue",null,null,"USD/year"]
[null,"Product sales",null,null,{"$f":"H31","v":60000000}]
[]
[null,"Total",null,null,{"$f":"SUM(E16:E17)","v":60000000}]
[]
[]
[]
[]
[]
[]
["Operating cost component settings & calculations"]
[]
[]
[null,"Products",null,"USD/kg",null,"kg/batch","kg/yr","USD/yr",null,"Raw materials",null,"USD/kg",null,"kg/batch","kg/yr","USD/yr"]
[null,"Riboflavin (cr)",null,{"$f":"Dashboard!E17","v":60},null,{"$f":"StreamTable(700,B29)","v":83333.333333333328},{"$f":"F29*Batches_per_year","v":1000000},{"$f":"D29*G29","v":60000000},null,"Air",null,0,null,{"$f":"StreamTable(205,\"Mass per batch\")+StreamTable(605,\"Mass per batch\")","v":28188819.669991083},{"$f":"N29*Batches_per_year","v":338265836.03989303},{"$f":"L29*O29","v":0}]
[null,null,null,null,null,null,null,null,null,"Methionine",null,{"$f":"Dashboard!E18","v":35},null,{"$f":"StreamTable(10,J30)","v":2382.2332222163182},28586.798666595816,1000537.9533308536]
[null,"Total",null,null,null,null,null,{"$f":"SUM(H14:H30)","v":60000000},null,"Glucose",null,{"$f":"Dashboard!E19","v":1},null,{"$f":"StreamTable(5,J31)","v":29777.915277703974},357334.98333244771,357334.98333244771]
[null,null,null,null,null,null,null,null,null,"Potassium phosphate",null,1.5,null,{"$f":"StreamTable(10,J32)","v":1191.1166111081591},14293.399333297908,21440.098999946862]
[null,null,null,null,null,null,null,null,null,"Magnesium sulfate",null,1.5,null,{"$f":"StreamTable(10,J33)","v":1191.1166111081591},14293.399333297908,21440.098999946862]
[null,null,null,null,null,null,null,null,null,"Malt Extract",null,{"$f":"Dashboard!E20","v":4},null,{"$f":"StreamTable(10,J34)","v":29777.915277703974},357334.98333244771,1429339.9333297908]
[null,null,null,null,null,null,null,null,null,"Peptone",null,{"$f":"Dashboard!E21","v":9},null,{"$f":"StreamTable(10,J35)","v":29777.915277703974},357334.98333244771,3216014.8499920294]
[null,null,null,null,null,null,null,null,null,"Sunflower Oil",null,{"$f":"Dashboard!E22","v":0.55000000000000004},null,{"$f":"StreamTable(10,J36)","v":89333.745833111927},1072004.9499973431,589602.72249853879]
[null,null,null,null,null,null,null,null,null,"Water",null,2E-3,null,{"$f":"StreamTable(5,J37)+StreamTable(10,J37)+EquipmentList(\"Total\", \"Process water\")","v":2977856.4986947034},35734277.984336443,71468.555968672881]
[null,null,null,null,null,null,null,null,null,"Yeast extract",null,{"$f":"Dashboard!E23","v":4},null,{"$f":"StreamTable(10,J38)","v":29777.915277703974},357334.98333244771,1429339.9333297908]
[null,null,null,null,null,null,null,null,null,"Total",null,null,null,null,null,{"$f":"SUM(P29:P38)","v":8136519.1297820173}]
[]
[]
[]
[]
[null,"Utilities",null,"USD/unit","Unit","Units/batch","Units/yr","USD/yr",null,"Labor",null,"USD/h",null,"h/batch","h/yr","USD/yr"]
[null,"Electrical power",null,{"$f":"Dashboard!E28","v":0.11},"kW-h",{"$f":"EquipmentList(\"Total\",B45)","v":3421192.8842866104},{"$f":"F45*Batches_per_year","v":41054314.611439325},{"$f":"G45*D45","v":4515974.6072583254},null,"Operator",null,{"$f":"Dashboard!E27","v":85},null,{"$f":"EquipmentList(\"Total\",\"Operating labor\")","v":564.84999999999991},{"$f":"N45*Batches_per_year","v":6778.1999999999989},{"$f":"L45*O45","v":576146.99999999988}]
[null,"Steam",null,20,"MT",{"$f":"EquipmentList(\"Total\",B46)","v":2042.1032591478981},{"$f":"F46*Batches_per_year","v":24505.239109774779},{"$f":"G46*D46","v":490104.78219549556},null,"QC analyst",null,100,null,150,{"$f":"N46*Batches_per_year","v":1800},{"$f":"L46*O46","v":180000}]
[null,"Chilled water",null,0.17499999999999999,"MT",{"$f":"EquipmentList(\"Total\",B47)","v":282376.42929329077},{"$f":"F47*Batches_per_year","v":3388517.1515194895},{"$f":"G47*D47","v":592990.50151591061},null,"Total",null,null,null,{"$f":"SUM(N45:N46)","v":714.84999999999991},{"$f":"SUM(O45:O46)","v":8578.1999999999989},{"$f":"SUM(P45:P46)","v":756146.99999999988}]
[null,"Cooling water",null,2.5000000000000001E-2,"MT",{"$f":"EquipmentList(\"Total\",B48)","v":244693.6747664978},{"$f":"F48*Batches_per_year","v":2936324.0971979736},{"$f":"G48*D48","v":73408.102429949344}]
[null,"Total",null,null,null,null,null,{"$f":"SUM(H45:H48)","v":5672477.9933996815}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Waste",null,"USD/kg",null,"kg/batch","kg/yr","USD/yr",null,"Facility costs",null,null,null,null,null,"USD/yr"]
[null,"Crystallizer aq fraction",null,4.0000000000000001E-3,null,{"$f":"StreamTable(555,\"Mass per batch\")","v":1704118.865788888},{"$f":"F61*Batches_per_year","v":20449426.389466655},{"$f":"D61*G61","v":81797.705557866619},null,"Maintenance",null,{"$f":"Dashboard!E29","v":0.1},"x PC",null,null,{"$f":"L61*Eq_PurchasedCost","v":3871777.6737758089}]
[null,"Crystallizer oil fraction",null,0.98,null,{"$f":"StreamTable(550,\"Mass per batch\")","v":42777.345080524545},{"$f":"F62*Batches_per_year","v":513328.14096629457},{"$f":"D62*G62","v":503061.57814696868},null,"Insurance",null,0.01,"x DFC",null,null,{"$f":"L62*DirectFixedCapital","v":1288332.7714424767}]
[null,"Fermenter exhaust",null,null,null,{"$f":"StreamTable(250,\"Mass per batch\")","v":26140217.743757214},{"$f":"F63*Batches_per_year","v":313682612.92508656},{"$f":"D63*G63","v":0},null,"Local taxes",null,0.02,"x DFC",null,null,{"$f":"L63*DirectFixedCapital","v":2576665.5428849533}]
[null,"Crystallizer exhaust",null,null,null,{"$f":"StreamTable(450,\"Mass per batch\")","v":903573.01310143911},{"$f":"F64*Batches_per_year","v":10842876.15721727},{"$f":"D64*G64","v":0},null,"Factory expense",null,0.02,"x DFC",null,null,{"$f":"L64*DirectFixedCapital","v":2576665.5428849533}]
[null,"Spray dryer exhaust",null,null,null,{"$f":"StreamTable(650,\"Mass per batch\")","v":2504258.2064731368},{"$f":"F65*Batches_per_year","v":30051098.477677643},{"$f":"D65*G65","v":0},null,"Total",null,null,null,null,null,{"$f":"SUM(P61:P64)","v":10313441.530988192}]
[null,"Total",null,null,null,null,null,{"$f":"SUM(H61:H65)","v":584859.28370483534}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Laboratory/QC/QA",null,"USD/batch",null,null,null,"USD/yr"]
[null,"Fixed cost",null,1000,null,null,null,{"$f":"D77*Batches_per_year","v":12000}]
[null,"Product titer",null,750,null,null,null,{"$f":"D78*Batches_per_year","v":9000}]
[null,"Total",null,null,null,null,null,{"$f":"SUM(H77:H78)","v":21000}]

{"sheet":"Cash flow","index":8,"n_rows":46,"n_cols":19,"rows_kept":46,"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.28999999999999998,null,"IRR",null,{"$f":"IRR(E38:S38)","v":0.1738735901276085}]
[null,"Discount rate",null,0.1,null,"NPV",null,{"$f":"(NPV(DiscountRate,F38:S38)+E38)","v":52.396376991164971},"MM USD"]
[null,null,null,null,null,"Discounted payback",null,{"$f":"D46","v":9.3192454421677429},"yr"]
[]
[]
[]
[]
[]
[]
[null,null,null,"Year",1,2,3,4,5,6,7,8,9,10,11,12,13,14,15]
[]
[null,"Capital outlay",null,"MM USD",{"$f":"SUM(E19,E21)","v":-38.649983143274298},{"$f":"SUM(F19,F21)","v":-51.533310857699064},-40.164983483962949,0,0,0,0,0,0,0,0,0,0,0,7.956664197901036]
[null,"Fixed capital",null,"-",0.3,0.4,0.3,null,null,null,null,null,null,null,null,null,null,null,-0.05]
[null,null,null,"MM USD",{"$f":"-E18*DirectFixedCapital/10^6","v":-38.649983143274298},{"$f":"-F18*DirectFixedCapital/10^6","v":-51.533310857699064},{"$f":"-G18*DirectFixedCapital/10^6","v":-38.649983143274298},null,null,null,null,null,null,null,null,null,null,null,{"$f":"-S18*DirectFixedCapital/10^6","v":6.441663857212383}]
[null,"Working capital",null,"-",null,null,1,null,null,null,null,null,null,null,null,null,null,null,-1]
[null,null,null,"MM USD",null,null,{"$f":"-G20*Working_Capital/10^6","v":-1.5150003406886534},null,null,null,null,null,null,null,null,null,null,null,{"$f":"-S20*Working_Capital/10^6","v":1.5150003406886534}]
[null,"Startup costs",null,"-",null,null,1]
[null,null,null,"MM USD",null,null,{"$f":"-G22*Startup_Costs/10^6","v":-12.883327714424766}]
[]
[]
[null,"Gross profit",null,"MM USD",null,null,{"$f":"G28-G29","v":17.257777531062636},34.515555062125273,34.515555062125273,34.515555062125273,34.515555062125273,34.515555062125273,34.515555062125273,34.515555062125273,34.515555062125273,34.515555062125273,34.515555062125273,34.515555062125273,34.515555062125273]
[null,"Operating rate",null,"-",null,null,0.5,1,1,1,1,1,1,1,1,1,1,1,1]
[null,"Revenue",null,"MM USD",null,null,{"$f":"G27*Revenue/10^6","v":30},60,60,60,60,60,60,60,60,60,60,60,60]
[null,"Operating costs",null,"MM USD",null,null,{"$f":"G27*OpEx/10^6","v":12.742222468937364},25.484444937874727,25.484444937874727,25.484444937874727,25.484444937874727,25.484444937874727,25.484444937874727,25.484444937874727,25.484444937874727,25.484444937874727,25.484444937874727,25.484444937874727,25.484444937874727]
[]
[]
[null,"Net profit",null,"MM USD",{"$f":"E26-E35*IncomeTax","v":0},0,15.989187084237654,28.242209131292128,28.242209131292128,28.242209131292128,28.242209131292128,28.242209131292128,28.242209131292128,28.242209131292128,28.242209131292128,28.242209131292128,24.506044094108944,24.506044094108944,24.506044094108944]
[null,"Depreciation",null,"Schedule",null,null,0.1,0.1,0.1,0.1,0.1,0.1,0.1,0.1,0.1,0.1]
[null,null,null,"MM USD",null,null,{"$f":"G33*DirectFixedCapital/10^6","v":12.883327714424766},12.883327714424766,12.883327714424766,12.883327714424766,12.883327714424766,12.883327714424766,12.883327714424766,12.883327714424766,12.883327714424766,12.883327714424766]
[null,"Taxable income",null,"MM USD",null,null,{"$f":"IF(G26-G34>0,G26-G34,0)","v":4.3744498166378705},21.632227347700507,21.632227347700507,21.632227347700507,21.632227347700507,21.632227347700507,21.632227347700507,21.632227347700507,21.632227347700507,21.632227347700507,34.515555062125273,34.515555062125273,34.515555062125273]
[]
[]
[null,"Cash flow",null,"MM USD",{"$f":"E32+E17","v":-38.649983143274298},-51.533310857699064,-24.175796399725293,28.242209131292128,28.242209131292128,28.242209131292128,28.242209131292128,28.242209131292128,28.242209131292128,28.242209131292128,28.242209131292128,28.242209131292128,24.506044094108944,24.506044094108944,32.462708292009978]
[null,"Cumulative",null,"MM USD",{"$f":"E38","v":-38.649983143274298},{"$f":"F38+E39","v":-90.183294000973362},{"$f":"G38+F39","v":-114.35909040069865},-86.11688126940652,-57.874672138114391,-29.632463006822263,-1.390253875530135,26.851955255761993,55.094164387054121,83.33637351834625,111.57858264963838,139.82079178093051,164.32683587503945,188.83287996914839,221.29558826115837]
[null,"Discounted cash flow",null,"MM USD",{"$f":"E38/(1+DiscountRate)^(E15-1)","v":-38.649983143274298},-46.848464416090053,-19.979997024566355,21.218789730497459,19.289808845906784,17.536189859915257,15.94199078174114,14.492718892491943,13.175198993174495,11.97745363015863,10.888594209235118,9.8987220083955592,7.8083808685519864,7.0985280623199873,8.5484456927073627]
[null,"Cum. disc. cash flow",null,"MM USD",{"$f":"E40","v":-38.649983143274298},{"$f":"F40+E41","v":-85.498447559364351},{"$f":"G40+F41","v":-105.47844458393071},-84.259654853433247,-64.969846007526456,-47.433656147611202,-31.491665365870062,-16.998946473378119,-3.8237474802036235,8.1537061499550063,19.042300359190122,28.941022367585681,36.749403236137667,43.847931298457652,52.396376991165013]
[]
[]
[null,"Payback calculation"]
[null,"Non-discounted",null,{"$f":"SUM(E45:S45)","v":7.0492261022877898},{"$f":"IF(AND(E39>=0,D39<0),-D39/(E39-D39),0)","v":0},{"$f":"IF(AND(F39>=0,E39<0),-E39/(F39-E39)+E15,0)","v":0},0,0,0,0,0,{"$f":"IF(AND(L39>=0,K39<0),-K39/(L39-K39)+K15,0)","v":7.0492261022877898},{"$f":"IF(AND(M39>=0,L39<0),-L39/(M39-L39)+L15,0)","v":0},0,0,0,0,0,0]
[null,"Discounted",null,{"$f":"SUM(E46:S46)","v":9.3192454421677429},{"$f":"IF(AND(E41>=0,D41<0),-D41/(E41-D41),0)","v":0},{"$f":"IF(AND(F41>=0,E41<0),-E41/(F41-E41)+E15,0)","v":0},0,0,0,0,0,{"$f":"IF(AND(L41>=0,K41<0),-K41/(L41-K41)+K15,0)","v":0},{"$f":"IF(AND(M41>=0,L41<0),-L41/(M41-L41)+L15,0)","v":0},9.3192454421677429,0,0,0,0,0]

{"sheet":"Constants","index":9,"n_rows":21,"n_cols":12,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["Constants"]
[null,"This page contains various constants and conversion factors that are used as Named Ranges throughout the workbook."]
[]
[]
[null,"Physical constants",null,null,null,null,null,"Plant parameters"]
[null,"Specific heat of glucose syrup",null,null,2.11,"kJ/(kg-K)",null,"Cooling water supply",null,null,25,"degC"]
[null,"Specific heat of water",null,null,4.18,"kJ/(kg-K)",null,"Cooling water return",null,null,30,"degC"]
[null,"Heat capacity of water",null,null,2100,"kJ/kg",null,"Steam temperature",null,null,152,"degC"]
[null,"Specific heat of air",null,null,1.01,"kJ/(kg-K)",null,"Chilled water supply",null,null,25,"degC"]
[null,null,null,null,null,null,null,"Chilled water return",null,null,30,"degC"]
[]
[]
[]
[null,"Molecular weights",null,null,null,null,null,"Unit conversions"]
[null,"Oxygen",null,"O2",31.997999999999998,"kg/kmol",null,"Time",null,null,31535999.999999989,"s/yr"]
[null,"Nitrogen",null,"N2",28.013999999999999,"kg/kmol",null,null,null,null,3600,"s/h"]
[null,null,null,null,null,null,null,null,null,null,60,"s/min"]
[null,null,null,null,null,null,null,"Mass",null,null,1000,"kg/t"]
[null,null,null,null,null,null,null,"Energy",null,null,3599.9999999999968,"kJ/kWh"]
[null,null,null,null,null,null,null,"Pressure",null,null,99.999999999999986,"kPa/bar"]
[null,null,null,null,null,null,null,"Amount",null,null,23.644740196608598,"scm/kmol"]