{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Equipment Summary","Utilities Summary","COM Summary","Cash Flow Analysis","Monte Carlo Simulation","User Options","Equipment Cost Data","Cooling Water","Cost of Refrigerated Water","Cost of Steam"],"not_rendered":{"charts":8,"images":0,"macros":1,"external_links":0,"defined_names":1162,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Equipment Summary","index":0,"n_rows":80,"n_cols":14,"rows_kept":80,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,"Unit Number",100,null," "]
[null,null,null,null,null,null,null,"This is Table 7.12 for Example 7.14"]
[null,null,null,"CEPCI",542,null,null,"Hit \"Remove All Equipment\" to start a new file"]
[]
["User Added Equipment"]
["Blenders","Type","Volume         (cubic meters)","# Spares",null,null,null,"Purchased Equipment Cost","Bare Module Cost","Base Equipment Cost","Base Bare Module Cost"]
[]
[]
["Centrifuges","Type","Diameter   (meters)","# Spares",null,null,null,"Purchased Equipment Cost","Bare Module Cost","Base Equipment Cost","Base Bare Module Cost"]
[]
[]
["Compressors","Compressor Type","Power (kilowatts)","# Spares","MOC",null,null,"Purchased Equipment Cost","Bare Module Cost","Base Equipment Cost","Base Bare Module Cost"]
[]
["Conveyors","Type","Area       (square meters)",null,null,null,null,"Purchased Equipment Cost","Bare Module Cost","Base Equipment Cost","Base Bare Module Cost"]
[]
[]
["Crystallizers","Type","Volume         (cubic meters)",null,null,null,null,"Purchased Equipment Cost","Bare Module Cost","Base Equipment Cost","Base Bare Module Cost"]
[]
[]
["Drives","Drive Type","Power (kilowatts)","# Spares",null,null,null,"Purchased Equipment Cost","Bare Module Cost","Base Equipment Cost","Base Bare Module Cost"]
[]
["Dryers","Type","Area       (square meters)",null,null,null,null,"Purchased Equipment Cost","Bare Module Cost","Base Equipment Cost","Base Bare Module Cost"]
[]
[]
["Dust Collectors","Type","Gas Flowrate (cubic meters/s)",null,null,null,null,"Purchased Equipment Cost","Bare Module Cost","Base Equipment Cost","Base Bare Module Cost"]
[]
[]
["Evaporators","Type","Area       (square meters)","Pressure     (barg)","MOC","Volume         (cubic meters)",null,"Purchased Equipment Cost","Bare Module Cost","Base Equipment Cost","Base Bare Module Cost"]
[]
[]
["Exchangers","Exchanger Type","Shell Pressure (barg)","Tube Pressure (barg)",null,"MOC","Area       (square meters)","Purchased Equipment Cost","Bare Module Cost","Base Equipment Cost","Base Bare Module Cost"]
[{"$f":"\"E-\" & unitNumber + 1","v":"E-101"},"Floating Head",{"$f":"ROUND(5*preferencePressure, 2)","v":5},{"$f":"ROUND(5*preferencePressure, 2)","v":5},null,"Carbon Steel / Carbon Steel",{"$f":"ROUND(170*preferenceArea, 0)","v":170},{"$f":"ROUND(83.0664206642066*CEPCI, -2)","v":45000},{"$f":"ROUND(273.287822878229*CEPCI, -3)","v":148000},{"$f":"ROUND(83.0664206642066*CEPCI, -2)","v":45000},{"$f":"ROUND(273.287822878229*CEPCI, -3)","v":148000}]
[{"$f":"\"E-\" & unitNumber + 2","v":"E-102"},"Floating Head",{"$f":"ROUND(6*preferencePressure, 2)","v":6},{"$f":"ROUND(18*preferencePressure, 1)","v":18},null,"Stainless Steel / Carbon Steel",{"$f":"ROUND(205*preferenceArea, 0)","v":205},{"$f":"ROUND(178.59778597786*CEPCI, -2)","v":96800},{"$f":"ROUND(447.870848708487*CEPCI, -3)","v":243000},{"$f":"ROUND(92.8837638376384*CEPCI, -2)","v":50300},{"$f":"ROUND(305.586715867159*CEPCI, -3)","v":166000}]
[{"$f":"\"E-\" & unitNumber + 3","v":"E-103"},"Double Pipe",null,{"$f":"ROUND(5*preferencePressure, 2)","v":5},null,"Carbon Steel / Carbon Steel",{"$f":"ROUND(10*preferenceArea, 1)","v":10},{"$f":"ROUND(9.39483394833948*CEPCI, -1)","v":5090},{"$f":"ROUND(30.909594095941*CEPCI, -2)","v":16800},{"$f":"ROUND(9.39483394833948*CEPCI, -1)","v":5090},{"$f":"ROUND(30.909594095941*CEPCI, -2)","v":16800}]
[]
["Fans / Blowers","Type","Gas Flowrate (cubic meters/s)","# Spares","MOC","Pressure Rise Across Fan (barg)",null,"Purchased Equipment Cost","Bare Module Cost","Base Equipment Cost","Base Bare Module Cost"]
[]
[]
["Filters","Type","Area       (square meters)",null,null,null,null,"Purchased Equipment Cost","Bare Module Cost","Base Equipment Cost","Base Bare Module Cost"]
[]
[]
["Heater","Type","Heat Duty (MJ/h)","Steam Superheat  (°C)","MOC","Pressure         (barg)",null,"Purchased Equipment Cost","Bare Module Cost","Base Equipment Cost","Base Bare Module Cost"]
[]
[]
["Mixers","Type","Power (kilowatts)","# Spares",null,null,null,"Purchased Equipment Cost","Bare Module Cost","Base Equipment Cost","Base Bare Module Cost"]
[]
[]
["Pump","Type","Power (kilowatts)","# Spares",null,"Discharge Pressure (barg)",null,"Purchased Equipment Cost","Bare Module Cost","Base Equipment Cost","Base Bare Module Cost"]
[{"$f":"\"P-\" & unitNumber + 1","v":"P-101"},"Centrifugal",{"$f":"ROUND(5*preferencePower, 2)","v":5},1,"Carbon Steel",{"$f":"ROUND(5*preferencePressure, 2)","v":5},null,{"$f":"ROUND(24.7933579335793*CEPCI, -2)","v":13400},{"$f":"ROUND(63.7047970479705*CEPCI, -2)","v":34500},{"$f":"ROUND(15.9963099630996*CEPCI, -1)","v":8670},{"$f":"ROUND(51.8284132841328*CEPCI, -2)","v":28100}]
[]
["Reactors","Type","Volume         (cubic meters)",null,null,null,null,"Purchased Equipment Cost","Bare Module Cost","Base Equipment Cost","Base Bare Module Cost"]
[]
[]
["Screens","Type","Area       (square meters)","# Spares",null,null,null,"Purchased Equipment Cost","Bare Module Cost","Base Equipment Cost","Base Bare Module Cost"]
[]
[]
["Storage Tanks","Tank Type","Volume         (cubic meters)",null,null,null,null,"Purchased Equipment Cost","Bare Module Cost","Base Equipment Cost","Base Bare Module Cost"]
[]
[]
["Towers","Tower Description","Height     (meters)","Diameter     (meters)","Tower MOC","Demister MOC","Pressure     (barg)","Purchased Equipment Cost","Bare Module Cost","Base Equipment Cost","Base Bare Module Cost",null,"Weld Efficiency","Maximum Stress"]
[{"$f":"\"T-\" & unitNumber + 1","v":"T-101"},"32 Stainless Steel Sieve Trays",{"$f":"ROUND(23*preferenceLength, 1)","v":23},{"$f":"ROUND(2.1*preferenceLength, 2)","v":2.1},"Carbon Steel",null,{"$f":"ROUND(5*preferencePressure, 2)","v":5},{"$f":"ROUND(535.509225092251*CEPCI, -3)","v":290000},{"$f":"ROUND(1013.40590405904*CEPCI, -3)","v":549000},{"$f":"ROUND(318.664206642066*CEPCI, -3)","v":173000},{"$f":"ROUND(741.819188191882*CEPCI, -3)","v":402000},null,0.89999997615814209,944]
[]
["Turbines","Turbine Type","Power (kilowatts)","# Spares","MOC",null,null,"Purchased Equipment Cost","Bare Module Cost","Base Equipment Cost","Base Bare Module Cost"]
[]
[]
["Vessels","Orientation","Length/Height  (meters)","Diameter     (meters)","MOC","Demister MOC","Pressure     (barg)","Purchased Equipment Cost","Bare Module Cost","Base Equipment Cost","Base Bare Module Cost",null,null,"Maximum Stress"]
[{"$f":"\"V-\" & unitNumber + 1","v":"V-101"},"Horizontal",{"$f":"ROUND(6*preferenceLength, 2)","v":6},{"$f":"ROUND(1.8*preferenceLength, 2)","v":1.8},"Carbon Steel",null,{"$f":"ROUND(5*preferencePressure, 2)","v":5},{"$f":"ROUND(45.6789667896679*CEPCI, -2)","v":24800},{"$f":"ROUND(120.083025830258*CEPCI, -2)","v":65100},{"$f":"ROUND(33.9944649446494*CEPCI, -2)","v":18400},{"$f":"ROUND(102.322878228782*CEPCI, -2)","v":55500},null,0.89999997615814209,944]
[]
[]
["User Added Equipment","Description","BMF0","Actual BMF",null,null,null,"Purchased Equipment Cost","Bare Module Cost","Base Equipment Cost","Base Bare Module Cost"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,"Totals",{"$f":"SUM(H5:H71)","v":475090},{"$f":"SUM(I5:I71)","v":1056400},{"$f":"SUM(J5:J71)","v":300460},{"$f":"SUM(K5:K71)","v":816400}]
[]
[null,null,null,null,null,null,"Total Module Cost ",{"$f":"ROUND(TBMC_Actual*1.18,-4)","v":1250000}]
[null,null,null,null,null,null,"Total Grass Roots Cost ",{"$f":"Total_Module_Cost+ROUND(0.5*TBMC_Base,-4)","v":1660000}]
[null,null,null,null,null,null,"Total Equipment Cost",{"$f":"TCP_Actual","v":475090},null,"`"]
[]
[null,null,null,null,null,null,"Lang Factor",4.74]
[null,null,null,null,null,null,"Lang Factor Cost",{"$f":"ROUND(Lang_Factor*TCP_Actual,-5)","v":2300000}]

{"sheet":"Utilities Summary","index":1,"n_rows":44,"n_cols":11,"rows_kept":44,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[null,{"$f":"\" \"","v":" "}]
[null,"Name","Total Module Cost",null,"Grass Roots Cost",null,"Utility Used","Efficiency","Actual Usage",null,"Annual Utility Cost"]
[null,{"$f":"\" \"","v":" "}]
[null,{"$f":"\"E-\" & unitNumber + 1","v":"E-101"},{"$f":"ROUND(totalModuleFactor*148122, 3)","v":174783.96},null,{"$f":"ROUND((totalModuleFactor*148122+ grassRootsFactor*148122), -3)","v":249000},null,"Unspecified"]
[null,{"$f":"\"E-\" & unitNumber + 2","v":"E-102"},{"$f":"ROUND(totalModuleFactor*242746, -3)","v":286000},null,{"$f":"ROUND((totalModuleFactor*242746+ grassRootsFactor*165628), -3)","v":369000},null,"Unspecified"]
[null,{"$f":"\"E-\" & unitNumber + 3","v":"E-103"},{"$f":"ROUND(totalModuleFactor*16753, -3)","v":20000},null,{"$f":"ROUND((totalModuleFactor*16753+ grassRootsFactor*16753), -2)","v":28100},null,"Unspecified"]
[null,{"$f":"\"P-\" & unitNumber + 1","v":"P-101"},{"$f":"ROUND(34528*totalModuleFactor, -2)","v":40700},null,{"$f":"ROUND((totalModuleFactor*34528+ grassRootsFactor*28091), -2)","v":54800},null,"Electricity",{"$f":"pumpEfficiency","v":0.86},{"$f":"ROUND(5*preferencePower/H11,2) & \"  \" &'User Options'!$F$5","v":"5.81  kilowatts"},null,{"$f":"ROUND(0.018*costElectricity*hoursPerYear/H11,-1)","v":3260}]
[null,"T-101",{"$f":"ROUND(totalModuleFactor*549266, -3)","v":648000},null,{"$f":"ROUND((totalModuleFactor*549266+grassRootsFactor*402067), -4)","v":850000},null,"NA"]
[null,"V-101",{"$f":"ROUND(totalModuleFactor*65085, -3)","v":77000},null,{"$f":"ROUND((totalModuleFactor*65085+ grassRootsFactor*55459), -3)","v":105000},null,"NA"]
[]
[]
[null,"Totals",{"$f":"ROUND(SUM($C$6:$C$14),-4)","v":1250000},null,{"$f":"ROUND(SUM($E$6:$E$14),-4)","v":1660000},null,null,null,null,null,{"$f":"ROUND(SUM($K$6:$K$14),-1)","v":3260}]
[]
[]
[]
[]
[]
[null,null,"COUNTIF(costSummary:totals,\"B-*\")"]
[null,null,{"$f":"COUNTIF(costSummary:totals,\"Ct*\")","v":0}]
[null,{"$f":"COUNTIF(costSummary:totals,\"C-*\")","v":0}]
[null,null,{"$f":"COUNTIF(costSummary:totals,\"Cv*\")","v":0}]
[null,null,{"$f":"COUNTIF(costSummary:totals,\"Cr*\")","v":0}]
[null,{"$f":"COUNTIF(costSummary:totals,\"D-*\")","v":0}]
[null,null,{"$f":"COUNTIF(costSummary:totals,\"Dy*\")","v":0}]
[null,null,{"$f":"COUNTIF(costSummary:totals,\"Dc*\")","v":0}]
[null,null,"COUNTIF(costSummary:totals,\"K-*\")"]
[null,{"$f":"COUNTIF(costSummary:totals,\"F-*\")","v":0}]
[null,null,{"$f":"COUNTIF(costSummary:totals,\"Fr*\")","v":0}]
[null,{"$f":"COUNTIF(costSummary:totals,\"H-*\")","v":0}]
[null,{"$f":"COUNTIF(costSummary:totals,\"E-*\")","v":3}]
[null,null,"COUNTIF(costSummary:totals,\"M-*\")"]
[null,"COUNTIF(costSummary:totals,\"P-*\")"]
[null,{"$f":"COUNTIF(costSummary:totals,\"R-*\")","v":0}]
[null,null,{"$f":"COUNTIF(costSummary:totals,\"S-*\")","v":0}]
[null,{"$f":"COUNTIF(costSummary:totals,\"Tk*\")","v":0}]
[null,{"$f":"COUNTIF(costSummary:totals,\"T-*\")","v":1}]
[null,{"$f":"COUNTIF(costSummary:totals,\"J-*\")","v":0}]
[null,"COUNTIF(costSummary:totals,\"V-*\")"]
[null,{"$f":"COUNTIF(costSummary:totals,\"Z-*\")","v":0}]
[null,{"$f":"SUM(B22:B43)","v":4},{"$f":"SUM(C22:C43)","v":0}]

{"sheet":"COM Summary","index":2,"n_rows":55,"n_cols":7,"rows_kept":55,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[null,"Material Name","Classification","Price ($/kg)","Flowrate (kg/h)","Annual Cost"]
[null,"Propylene","Raw Material",{"$f":"0.32/preferenceCost","v":0.32},{"$f":"1234*preferenceFlowrate","v":1234},{"$f":"D6 * preferenceCost * E6 / preferenceFlowrate * hoursPerYear","v":3286191.36}]
[null,"Product A","Product",{"$f":"-100/preferenceCost","v":-100},{"$f":"600*preferenceFlowrate","v":600},{"$f":"D7 * preferenceCost * E7 / preferenceFlowrate * hoursPerYear","v":-499320000}]
[]
[]
[null,null,null,null,null,{"$f":"SUMIF(C5:endClassification, \"Product\",F5:endMaterial)","v":-499320000}]
[null,null,null,null,null,{"$f":"SUMIF(C5:endClassification, \"Raw Material\",F5:endMaterial)","v":3286191.36}]
[null,null,null,null,null,{"$f":"SUMIF(C5:endClassification, \"Hazardous Waste\",F5:endMaterial)","v":0}]
[null,null,null,null,null,{"$f":"SUMIF(C5:endClassification, \"Non-Hazardous Waste\",F5:endMaterial)","v":0}]
[null,"Economic Options",null,null,null,{"$f":"F13+F12","v":0}]
[null,"Cost of Land",10000000]
[null,"Taxation Rate",0.45]
[null,"Annual Interest Rate",0.10000000149011612]
[null,"Salvage Value",{"$f":"FCIL/10","v":15000000},"tenPercent"]
[null,"Working Capital",30000000,"custom"]
[null,"FCIL",150000000,"custom"]
[null,"Total Module Factor",1.18]
[null,"Grass Roots Factor",0.5]
[]
[null,"Economic Information Calculated From Given Information"]
[null,"Revenue From Sales",{"$f":"-sumProduct","v":499320000},"material"]
[null,"CRM (Raw Materials Costs)",{"$f":"sumRawMaterial","v":3286191.36},"material"]
[null,"CUT (Cost of Utilities)",500,"custom"]
[null,"CWT (Waste Treatment Costs)",0,"custom"]
[null,"COL (Cost of Operating Labor)",0,"custom"]
[]
[null,"Factors Used in Calculation of Cost of Manufacturing (COMd)"]
[null,{"$f":"\"Comd = \" & C33 & \"*FCIL + \" &C34&\"*COL + \" & C35 & \"*(CUT + CWT + CRM)\"","v":"Comd = 0.18*FCIL + 2.76*COL + 1.23*(CUT + CWT + CRM)"}]
[null,"Multiplying factor for FCIL",0.18]
[null,"Multiplying factor for COL",2.76]
[null,"Facotrs for CUT, CWT, and CRM",1.23]
[]
[null,"COMd",{"$f":"C33*FCIL+C34*costOperatingLabor+C35*(costUtilities+costWasteTreatment+costRawMaterials)","v":31042630.3728}]
[]
[null,"Factors Used in Calculation of  Working Capital"]
[null,"Working Capital = A*CRM + B*FCIL + C*COL"]
[null,"A",0.1]
[null,"B",0.1]
[null,"C",0.1]
[]
[null,"Project Life (Years after Startup)",10]
[]
[null,"Construction period",2]
[]
[null,"Distribution of Fixed Capital Investment (must sum to one)"]
[null,"End of year One",{"$f":"0.6","v":0.6},null,null,""]
[null,"End of year Two",{"$f":"0.4","v":0.4}]
[null,"End of year Three"]
[null,"End of year Four"]
[null,"End of year Five"]
[null,null,null,null,null,null,""]

{"sheet":"Cash Flow Analysis","index":3,"n_rows":63,"n_cols":12,"rows_kept":63,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Discounted Profitibility Criterion",null,null,null,null,"Non-Discounted Profitibility Criteria"]
[]
[null,null,null,"Net Present Value (millions)",{"$f":"$K$63","v":1200.2017453959866},null,null,"Cumulative Cash Position (millions)",{"$f":"SUM($I$48:$I$63)","v":2501.2755329496003}]
[]
[null,null,null,"Discounted Cash Flow Rate of Return",0.12104384423463777,null,null,"Rate of Return on Investment",{"$f":"($L$63- costLand/10^6 - workingCapital/10^6 -$L$52)/projectLife/(FCIL/10^6) - 1/projectLife","v":1.6675170219664002}]
[]
[null,null,null,"Discounted Payback Period (years)",5.939099118895343,null,null,"Payback Period (years)",3.851672433679354]
[]
[]
[]
[]
[null,"Year","Investment","dk","FCIL-Sdk","R","COMd","(R-COMd-dk)*(1-t)+dk","Cash Flow       (Non-discounted)","Cash Flow (discounted)","Cumulative Cash Flow (discounted)","Cumulative Cash Flow (Non-discounted)"]
[null,0,{"$f":"0","v":0},null,{"$f":"FCIL/10^6","v":150},null,null,null,{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"0","v":0}]
[null,0,{"$f":"costLand/10^6","v":10},null,{"$f":"FCIL/10^6","v":150},null,null,null,{"$f":"-$C$49","v":-10},{"$f":"-$C$49","v":-10},{"$f":"-$C$49","v":-10},{"$f":"-$C$49","v":-10}]
[null,1,{"$f":"FCIL/10^6*'COM Summary'!$C$50","v":90},null,{"$f":"FCIL/10^6","v":150},null,null,null,{"$f":"-$C$50","v":-90},{"$f":"$I$50/((1 + iRate) ^1)","v":-81.818181707346739},{"$f":"$J$50+$K$49","v":-91.818181707346739},{"$f":"$I$50+$L$49","v":-100}]
[null,2,{"$f":"(FCIL/10^6*'COM Summary'!$C$51)","v":60},null,{"$f":"FCIL/10^6","v":150},null,null,null,{"$f":"-$C$51","v":-60},{"$f":"$I$51/((1 + iRate) ^2)","v":-49.586776725158579},{"$f":"$J$51+$K$50","v":-141.40495843250531},{"$f":"$I$51+$L$50","v":-160}]
[null,2,{"$f":"workingCapital/10^6","v":30},null,{"$f":"FCIL/10^6","v":150},null,null,null,{"$f":"-$C$52","v":-30},{"$f":"$I$52/((1 + iRate) ^2)","v":-24.793388362579289},{"$f":"$J$52+$K$51","v":-166.1983467950846},{"$f":"$I$52+$L$51","v":-190}]
[null,3,null,{"$f":"FCIL*0.2/10^6","v":30},{"$f":"FCIL/10^6-SUM($D$53:$D$53)","v":120},{"$f":"revenue/10^6","v":499.32},{"$f":"COMd/10^6","v":31.042630372800001},{"$f":"(revenue/10^6 - COMd/10^6 - FCIL/10^6*0.2)*(1 - taxRate) + FCIL/10^6*0.2","v":271.05255329496003},{"$f":"$H$53","v":271.05255329496003},{"$f":"$I$53/((iRate + 1)^3)","v":203.64579428506025},{"$f":"$J$53+$K$52","v":37.447447489975644},{"$f":"$I$53+$L$52","v":81.052553294960035}]
[null,4,null,{"$f":"FCIL*0.32/10^6","v":48},{"$f":"FCIL/10^6-SUM($D$53:$D$54)","v":72},499.32,31.042630372800001,{"$f":"(revenue/10^6 - COMd/10^6 - FCIL/10^6*0.32)*(1 - taxRate) + FCIL/10^6*0.32","v":279.15255329496006},{"$f":"$H$54","v":279.15255329496006},{"$f":"$I$54/((iRate + 1)^4)","v":190.66494896683486},{"$f":"$J$54+$K$53","v":228.1123964568105},{"$f":"$I$54+$L$53","v":360.20510658992009}]
[null,5,null,{"$f":"FCIL*0.192/10^6","v":28.8},{"$f":"FCIL/10^6-SUM($D$53:$D$55)","v":43.2},499.32,31.042630372800001,{"$f":"(revenue/10^6 - COMd/10^6 - FCIL/10^6*0.192)*(1 - taxRate) + FCIL/10^6*0.192","v":270.51255329496001},{"$f":"$H$55","v":270.51255329496001},{"$f":"$I$55/((iRate + 1)^5)","v":167.96701135833339},{"$f":"$J$55+$K$54","v":396.0794078151439},{"$f":"$I$55+$L$54","v":630.71765988488005}]
[null,6,null,{"$f":"FCIL*0.115/10^6","v":17.25},{"$f":"FCIL/10^6-SUM($D$53:$D$56)","v":25.950000000000003},499.32,31.042630372800001,{"$f":"(revenue/10^6 - COMd/10^6 - FCIL/10^6*0.115)*(1 - taxRate) + FCIL/10^6*0.115","v":265.31505329496002},{"$f":"$H$56","v":265.31505329496002},{"$f":"$I$56/((iRate + 1)^6)","v":149.76342961857043},{"$f":"$J$56+$K$55","v":545.84283743371429},{"$f":"$I$56+$L$55","v":896.03271317984013}]
[null,7,null,{"$f":"FCIL*0.115/10^6","v":17.25},{"$f":"FCIL/10^6-SUM($D$53:$D$57)","v":8.6999999999999886},499.32,31.042630372800001,{"$f":"(revenue/10^6 - COMd/10^6 - FCIL/10^6*0.115)*(1 - taxRate) + FCIL/10^6*0.115","v":265.31505329496002},{"$f":"$H$57","v":265.31505329496002},{"$f":"$I$57/((iRate + 1)^7)","v":136.14857219608476},{"$f":"$J$57+$K$56","v":681.99140962979902},{"$f":"$I$57+$L$56","v":1161.3477664748002}]
[null,8,null,{"$f":"FCIL*0.058/10^6","v":8.6999999999999993},"-",499.32,31.042630372800001,{"$f":"(revenue/10^6 - COMd/10^6 - FCIL/10^6*0.058)*(1 - taxRate) + FCIL/10^6*0.058","v":261.46755329496006},{"$f":"$H$58","v":261.46755329496006},{"$f":"$I$58/((iRate + 1)^8)","v":121.97654197559551},{"$f":"$J$58+$K$57","v":803.96795160539455},{"$f":"$I$58+$L$57","v":1422.8153197697602}]
[null,9,null,null,"-",499.32,31.042630372800001,{"$f":"(revenue/10^6 - COMd/10^6 - FCIL/10^6*0)*(1 - taxRate) + FCIL/10^6*0","v":257.55255329496003},{"$f":"$H$59","v":257.55255329496003},{"$f":"$I$59/((iRate + 1)^9)","v":109.22742312645971},{"$f":"$J$59+$K$58","v":913.19537473185426},{"$f":"$I$59+$L$58","v":1680.3678730647202}]
[null,10,null,null,"-",499.32,31.042630372800001,{"$f":"(revenue/10^6 - COMd/10^6 - FCIL/10^6*0)*(1 - taxRate) + FCIL/10^6*0","v":257.55255329496003},{"$f":"$H$60","v":257.55255329496003},{"$f":"$I$60/((iRate + 1)^10)","v":99.297657253176979},{"$f":"$J$60+$K$59","v":1012.4930319850313},{"$f":"$I$60+$L$59","v":1937.9204263596803}]
[null,11,null,null,"-",499.32,31.042630372800001,{"$f":"(revenue/10^6 - COMd/10^6 - FCIL/10^6*0)*(1 - taxRate) + FCIL/10^6*0","v":257.55255329496003},{"$f":"$H$61","v":257.55255329496003},{"$f":"$I$61/((iRate + 1)^11)","v":90.270597380602993},{"$f":"$J$61+$K$60","v":1102.7636293656342},{"$f":"$I$61+$L$60","v":2195.4729796546403}]
[null,12,null,null,"-",499.32,31.042630372800001,{"$f":"(revenue/10^6+salvageValue/10^6 - COMd/10^6 - FCIL/10^6*0)*(1 - taxRate) + FCIL/10^6*0","v":265.80255329495998},{"$f":"$H$62","v":265.80255329495998},{"$f":"$I$62/((iRate + 1)^12)","v":84.692883529122199},{"$f":"$J$62+$K$61","v":1187.4565128947563},{"$f":"$I$62+$L$61","v":2461.2755329496003}]
[null,12,null,null,null,null,null,null,{"$f":"workingCapital/10^6 + costLand/10^6","v":40},{"$f":"$I$63/((iRate + 1)^12)","v":12.745232501230168},{"$f":"$J$63+$K$62","v":1200.2017453959866},{"$f":"$I$63+$L$62","v":2501.2755329496003}]

{"sheet":"Monte Carlo Simulation","index":4,"n_rows":154,"n_cols":7,"rows_kept":154,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,"Probable Variation of Key Parameters over Plant Life"]
[]
[null,null,null,"Lower Limit","Upper Limit",null,"Base Value"]
[null,null,"FCIL",-0.2,0.3,null,{"$f":"FCIL","v":150000000}]
[null,null,"Price of Product",-0.2,0.05,null,{"$f":"revenue","v":499320000}]
[null,null,"Working Capital",0,0,null,{"$f":"workingCapital","v":30000000}]
[null,null,"Income Tax Rate*",0,0,null,{"$f":"taxRate","v":0.45}]
[null,null,"Interest Rate*",0,0,null,{"$f":"iRate","v":0.10000000149011612}]
[null,null,"Raw Material Price",-0.1,0.1,null,{"$f":"costRawMaterials","v":3286191.36}]
[null,null,"Salvage Value",0,0,null,{"$f":"salvageValue","v":15000000}]
[]
[]
[null,null,"* Please note that variations for percentages are a percent of a percent."]
[null,null,"For example, a 10% variance on a 12% interst rate would imply a 1.2% uncertainty"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Net Present Value Data"]
[]
[null,"Low NPV",18428.54296875]
[null,"High NPV",24130.955078125]
[]
[null,"Bins","Upper Value","# points/bin","Cumulative",null,"Cumulative Fraction"]
[null,0,{"$f":"C29","v":18428.54296875},0,0,null,{"$f":"E33/$E$43","v":0}]
[null,1,18998.78515625,13,{"$f":"D34","v":13},null,{"$f":"E34/$E$43","v":1.2999999999999999E-2}]
[null,{"$f":"B34+1","v":2},19569.025390625,34,{"$f":"D35+E34","v":47},null,4.7E-2]
[null,{"$f":"B35+1","v":3},20139.265625,74,121,null,0.121]
[null,4,20709.5078125,96,217,null,0.217]
[null,5,21279.75,110,327,null,0.32700000000000001]
[null,6,21849.990234375,121,448,null,0.44800000000000001]
[null,7,22420.23046875,165,613,null,0.61299999999999999]
[null,8,22990.47265625,188,801,null,0.80100000000000005]
[null,9,23560.71484375,142,943,null,0.94299999999999995]
[null,10,24130.955078125,57,1000,null,1]
[]
[]
[]
[]
[]
[null,"Discounted Cash Flow Rate of Return Data"]
[]
[]
[null,"Low DCFROR","NA"]
[null,"High DCFROR","NA"]
[]
[null,"Bins","Upper","#/bin","Cumulative",null,"Cumulative Fraction"]
[null,0,{"$f":"C52","v":"NA"},0,0,null,{"$f":"E56/$E$66","v":{"$error":"#DIV/0!"}}]
[null,1,6.3487626612186432E-2,null,{"$f":"D57","v":0},null,{"$f":"E57/$E$66","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"B57+1","v":2},7.4715808033943176E-2,null,{"$f":"D58+E57","v":0},null,{"$error":"#DIV/0!"}]
[null,{"$f":"B58+1","v":3},8.5943982005119324E-2,null,0,null,{"$error":"#DIV/0!"}]
[null,4,9.7172163426876068E-2,null,0,null,{"$error":"#DIV/0!"}]
[null,5,0.10840034484863281,null,0,null,{"$error":"#DIV/0!"}]
[null,6,0.11962852627038956,null,0,null,{"$error":"#DIV/0!"}]
[null,7,0.1308567076921463,null,0,null,{"$error":"#DIV/0!"}]
[null,8,0.14208488166332245,null,0,null,{"$error":"#DIV/0!"}]
[null,9,0.15331307053565979,null,0,null,{"$error":"#DIV/0!"}]
[null,10,0.16454124450683594,null,0,null,{"$error":"#DIV/0!"}]
[]
[]
[]
[]
[null,"Discounted Payback Period Data"]
[]
[]
[null,"Low DPBP",3.4872103482484818E-2]
[null,"High DPBP",6.4982295036315918E-2]
[]
[null,"Bins","Upper","#/bin","Cumulative",null,"Cumulative Fraction"]
[null,0,{"$f":"C74","v":3.4872103482484818E-2},0,0,null,{"$f":"E78/$E$88","v":0}]
[null,1,3.7883121520280838E-2,22,{"$f":"D79","v":22},null,{"$f":"E79/$E$88","v":2.1999999999999999E-2}]
[null,{"$f":"B79+1","v":2},4.0894143283367157E-2,73,{"$f":"D80+E79","v":95},null,{"$f":"E80/$E$88","v":9.5000000000000001E-2}]
[null,{"$f":"B80+1","v":3},4.3905161321163177E-2,173,268,null,0.26800000000000002]
[null,4,4.6916179358959198E-2,227,495,null,0.495]
[null,5,4.9927197396755219E-2,187,682,null,0.68200000000000005]
[null,6,5.2938219159841537E-2,125,807,null,0.80700000000000005]
[null,7,5.5949237197637558E-2,104,911,null,0.91100000000000003]
[null,8,5.8960255235433578E-2,53,964,null,0.96399999999999997]
[null,9,6.1971276998519897E-2,29,993,null,0.99299999999999999]
[null,10,6.4982295036315918E-2,7,1000,null,1]
[]
[]
[]
[]
[null,"Cumulative Cash Position Data"]
[]
[]
[null,"Low CCP",36413.40625]
[null,"High CCP",47636.6796875]
[]
[null,"Bins","Upper Value","# points/bin","Cumulativive",null,"Cumulative Fraction"]
[null,0,{"$f":"C96","v":36413.40625},0,0,null,{"$f":"E100/$E$110","v":0}]
[null,1,37535.734375,13,{"$f":"D101","v":13},null,{"$f":"E101/$E$110","v":1.2999999999999999E-2}]
[null,{"$f":"B101+1","v":2},38658.0625,33,{"$f":"D102+E101","v":46},null,4.5999999999999999E-2]
[null,{"$f":"B102+1","v":3},39780.38671875,75,121,null,0.121]
[null,4,40902.71484375,95,216,null,0.216]
[null,5,42025.04296875,108,324,null,0.32400000000000001]
[null,6,43147.37109375,122,446,null,0.44600000000000001]
[null,7,44269.69921875,167,613,null,0.61299999999999999]
[null,8,45392.0234375,184,797,null,0.79700000000000004]
[null,9,46514.3515625,146,943,null,0.94299999999999995]
[null,10,47636.6796875,57,1000,null,1]
[]
[]
[]
[]
[null,"Rate of Return on Investment Data"]
[]
[]
[null,"Low ROROI",20.282051086425781]
[null,"High ROROI",37.969886779785156]
[]
[null,"Bins","Upper Value","# points/bin","Cumulative",null,"Cumulative Fraction"]
[null,0,{"$f":"C118","v":20.282051086425781},0,0,null,{"$f":"E122/$E$132","v":0}]
[null,1,22.050834655761719,25,{"$f":"D123","v":25},null,{"$f":"E123/$E$132","v":2.5000000000000001E-2}]
[null,{"$f":"B123+1","v":2},23.819618225097656,81,{"$f":"D124+E123","v":106},null,0.106]
[null,{"$f":"B124+1","v":3},25.588401794433594,139,245,null,0.245]
[null,4,27.357185363769531,162,407,null,0.40699999999999997]
[null,5,29.125968933105469,205,612,null,0.61199999999999999]
[null,6,30.894752502441406,193,805,null,0.80500000000000005]
[null,7,32.663536071777344,114,919,null,0.91900000000000004]
[null,8,34.432319641113281,48,967,null,0.96699999999999997]
[null,9,36.201103210449219,21,988,null,0.98799999999999999]
[null,10,37.969886779785156,12,1000,null,1]
[]
[]
[]
[]
[null,"Payback Period Data"]
[]
[]
[null,"Low DPBP",3.1286045908927917E-2]
[null,"High DPBP",4.0889430791139603E-2]
[]
[null,"Bins","Upper","#/bin","Cumulative",null,"Cumulative Fraction"]
[null,0,{"$f":"C140","v":3.1286045908927917E-2},0,0,null,{"$f":"E144/$E$154","v":0}]
[null,1,3.2246384769678116E-2,85,{"$f":"D145","v":85},null,{"$f":"E145/$E$154","v":8.5000000000000006E-2}]
[null,{"$f":"B145+1","v":2},3.3206723630428314E-2,206,{"$f":"D146+E145","v":291},null,0.29099999999999998]
[null,{"$f":"B146+1","v":3},3.4167062491178513E-2,202,493,null,0.49299999999999999]
[null,4,3.5127401351928711E-2,144,637,null,0.63700000000000001]
[null,5,3.6087736487388611E-2,118,755,null,0.755]
[null,6,3.7048075348138809E-2,91,846,null,0.84599999999999997]
[null,7,3.8008414208889008E-2,79,925,null,0.92500000000000004]
[null,8,3.8968753069639206E-2,43,968,null,0.96799999999999997]
[null,9,3.9929091930389404E-2,24,992,null,0.99199999999999999]
[null,10,4.0889430791139603E-2,8,1000,null,1]

{"sheet":"User Options","index":5,"n_rows":55,"n_cols":8,"rows_kept":55,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Hours per Operting Year",8322]
[]
[null,null,"Cost ($/GJ)",null,null,"Power Preference"]
[null,"Common Utilities",null,null,null,"kilowatts",1,"  kW / kW"]
[null,"Electricity (110V - 440V)",18.72]
[null,"Cooling Water (30°C to 45°C)",0.378,null,null,"Pressure Preference"]
[null,"Refrigerated Water (15°C to 25°C)",4.7699999999999996,null,null,"barg",1,"  barg / barg"]
[]
[null,"Steam from Boilers",null,null,null,"Heat Duty Preference"]
[null,"Low Pressure (5 barg, 160°C)",2.0299999999999998,null,null,"MJ/h",3.6,"  (MJ/h) / kW"]
[null,"Medium Pressure (10 barg, 184°C)",2.78]
[null,"High Pressure (41 barg, 254°C)",5.66,null,null,"Length Preference"]
[null,null,null,null,null,"meters",1,"  m / m"]
[null,"Fuels"]
[null,"Fuel Oil (no. 2)",10.26,null,null,"Area Preference"]
[null,"Natural Gas",3.16,null,null,"square meters",1,"  m^2 / m^2"]
[null,"Coal (FOB mine mouth)",2.04]
[null,null,null,null,null,"Volume Preference"]
[null,"Thermal Systems",null,null,null,"cubic meters",1,"  m^3/m^3"]
[null,"Moderately High (up to 330°C)",3.95]
[null,"High (up to 400°C)",3.95,null,null,"Gas Flow Preference"]
[null,"Very High (up to 600°C)",3.95,null,null,"cubic meters/s",1,"  m^3 / m^3"]
[]
[null,"Refrigeration",null,null,null,"Cost Preference"]
[null,"Moderately Low (5°C)",4.7699999999999996,null,null,"$/kg",1,"  kg / kg"]
[null,"Low (-20°C)",8.49]
[null,"Very low (-50°C)",14.12,null,null,"Flowrate Preference"]
[null,null,null,null,null,"kg/h",1,"  kg / kg"]
[null,null,"Cost ($/tonne)"]
[null,"Waste Disposal (solid and liquid)",null,null,null,"Energy Price Preference"]
[null,"Non-Hazardous",36,null,null,"$/Gigajoule",1,"  GJ / GJ"]
[null,"Hazardous",200]
[]
[null,"Cost of Steam used in Steam Drives"]
[null,null,"Cost ($/GJ)"]
[null,"Steam used for steam-powered drives",5.66]
[]
[null,"Equipment Effeciencies"]
[]
[null,"Pump Efficiency",0.86]
[null,"Drive Efficiency",0.9]
[null,"Fan Efficiency",0.7]
[null,"Furnace Efficiency",0.9]
[null,"Turbine Efficiency",0.65]
[]
[null,"Process Equipment"]
[]
[null,null,"Operators per shift per equipment"]
[]
[null,"Cost of Labor (per operator/year)",66910]
[]
[null,"Miscellaneous Numebrs"]
[]
[null,"Solids Handling Coefficient",1]

{"sheet":"Equipment Cost Data","index":6,"n_rows":285,"n_cols":19,"rows_kept":285,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Blender Data"]
[null,"Blender Type","K1","K2","K3","Vmin(m3)","Vmax(m3)","FBM"]
[null,"Kneader",5.0141,0.5867,0.32240000000000002,0.14000000000000001,3,1.1200000000000001]
[null,"Ribbon",4.1365999999999996,0.50719999999999998,7.0000000000000001E-3,0.7,11,1.1200000000000001]
[null,"Rotary",4.1365999999999996,0.50719999999999998,7.0000000000000001E-3,0.7,11,1.1200000000000001]
[]
[]
[null,"Centrifuge Data"]
[null,"Centrifuge Type","K1","K2","K3","Dmin(m)","Dmax(m)","FBM"]
[null,"Auto Batch Seperator",4.7680999999999996,0.97399999999999998,2.4E-2,0.5,1.7,1.57]
[null,"Centrifugal Seperator",4.3612000000000002,0.87639999999999996,-4.8999999999999998E-3,0.5,1,1.57]
[null,"Oscillating Screen",4.8600000000000003,0.33400000000000002,0.10630000000000001,0.5,1.1000000000000001,1.57]
[null,"Solid Bowl w/o Motor",4.9696999999999996,1.1689000000000001,3.8E-3,0.3,2,1.27]
[]
[]
[null,"Compressor Data (without electric motors)"]
[null,"Compressor Type","K1","K2","K3","FBMCS","FBMSS","FBMNi","Wmin(kW)","Wmax(kW)"]
[null,"Centrifugal",2.2890999999999999,1.3604000000000001,-0.1027,2.74,5.75,11.45,450,3000]
[null,"Axial",2.2890999999999999,1.3604000000000001,-0.1027,3.83,8.0399999999999991,15.92,450,3000]
[null,"Rotary",5.0354999999999999,-1.8002,0.82530000000000003,2.41,5.04,9.85,18,950]
[null,"Reciprocating",2.2890999999999999,1.3604000000000001,-0.1027,3.37,7,13.88,450,3000]
[]
[]
[null,"Conveyor Data"]
[null,"Conveyor Type","K1","K2","K3","Amin(m2)","Amax(m2)","FBM"]
[null,"Apron",3.9255,0.50390000000000001,0.15060000000000001,1,15,2]
[null,"Belt",4.0636999999999999,0.25840000000000002,0.155,0.5,325,1.25]
[null,"Pneumatic",4.6616,0.32050000000000001,6.3799999999999996E-2,0.75,65,1.25]
[null,"Screw",3.6061999999999999,0.26590000000000003,0.19819999999999999,0.5,30,1.1000000000000001]
[]
[]
[null,"Crystallizer Data"]
[null,"Crystallizer Type","K1","K2","K3","Vmin(m3)","Vmax(m3)","FBM"]
[null,"Batch",4.5096999999999996,0.1731,0.13439999999999999,1.5,30,1.6]
[]
[]
[null,"Drive Data"]
[null,"Electric Drives","K1","K2","K3","FBM","Wmin(kW)","Wmax(kW)"]
[null,"Explosion Proof",2.4603999999999999,1.4191,-0.17979999999999999,1.5,75,2600]
[null,"Totally Enclosed",1.956,1.7141999999999999,-0.22819999999999999,1.5,75,2600]
[null,"Open/Drip Proof",2.9508000000000001,1.0688,-0.13150000000000001,1.5,75,2600]
[]
[null,"Non-Electric Drives","K1","K2","K3","FBM","Wmin(kW)","Wmax(kW)"]
[null,"Gas Turbine",-21.770199999999999,13.217499999999999,-1.5279,3.5,7500,23000]
[null,"Steam Turbine",2.6259000000000001,1.4398,-0.17760000000000001,3.5,70,7500]
[null,"Internal Combustion",2.7635000000000001,0.85740000000000005,-9.7999999999999997E-3,2,10,10000]
[]
[]
[null,"Dryer Data"]
[null,"Dryer Type","K1","K2","K3","Amin(m2)","Amax(m2)","FBM"]
[null,"Drum",4.5472000000000001,{"$f":"0.2731","v":0.27310000000000001},0.13400000000000001,0.5,50,1.6]
[null,"Rotary, Gas Fired",3.5644999999999998,1.1117999999999999,-7.7700000000000005E-2,5,100,1.25]
[null,"Tray",3.6951000000000001,0.54420000000000002,-0.12479999999999999,1.8,20,1.25]
[]
[]
[null,"Dust Collectors Data"]
[null,"Collector Type","K1","K2","K3","Vmin(m3/s)","Vmax(m3/s)","FBM"]
[null,"Baghouse",4.5007000000000001,0.41820000000000002,8.1299999999999997E-2,0.08,350,2.86]
[null,"Cyclone Scrubbers",3.6297999999999999,{"$f":"1-0.4991","v":0.50090000000000001},4.1099999999999998E-2,0.06,200,2.86]
[null,"     ( Centrifugal, Gravity"]
[null,"     Spray, Impingement, "]
[null,"     and Wet Dynamic)"]
[null,"Electrostatic Precipitator",3.6297999999999999,0.50090000000000001,4.1099999999999998E-2,0.06,200,2.86]
[null,"Venturi",3.6297999999999999,0.50090000000000001,4.1099999999999998E-2,0.06,200,2.86]
[]
[]
[null,"Fan Data (include electric motors)"]
[null,"Fan Type","K1","K2","K3","FBMCS","FBMfiberglass","FBMSS","FBMNi","Threshold","C1","C2","C3","Vmin(m3/s)","Vmax(m3/s)","Pmax(barg)"]
[null,"Centrifugal Radial Fan",3.5390999999999999,-0.3533,0.44769999999999999,2.74,4.97,5.75,11.45,0.01,0,0.20899000000000001,-3.2800000000000003E-2,1,100,0.16]
[null,"Centrifugal Backward curved fan",3.3471000000000002,-7.3400000000000007E-2,0.309,2.74,4.97,5.75,11.45,0.01,0,0.20899000000000001,-3.2800000000000003E-2,1,100,0.16]
[null,"Axial Tube Fan",3.0413999999999999,-0.33750000000000002,0.47220000000000001,2.74,4.97,5.75,11.45,0.04,0,0.20899000000000001,-3.2800000000000003E-2,1,100,0.16]
[null,"Axial Vane Fan",3.1760999999999999,-0.13730000000000001,0.34139999999999998,2.74,4.97,5.75,11.45,0.04,0,0.20899000000000001,-3.2800000000000003E-2,1,100,0.16]
[]
[]
[null,"Filter Data"]
[null,"Filter Type","K1","K2","K3","Amin(m2)","Amax(m2)","FBM"]
[null,"Bent",5.1055000000000001,0.49990000000000001,1E-4,0.9,115,1.65]
[null,"Cartridge",3.2107000000000001,0.75970000000000004,2.7000000000000001E-3,15,200,1.65]
[null,"Disc and Drum",4.8122999999999996,0.2858,4.2000000000000003E-2,0.9,300,1.65]
[null,"Gravity",4.2755999999999998,0.35199999999999998,7.1400000000000005E-2,0.5,80,1.65]
[null,"Leaf",3.8187000000000002,0.62350000000000005,1.7600000000000001E-2,0.6,235,1.65]
[null,"Pan",4.8122999999999996,0.2858,4.2000000000000003E-2,0.9,300,1.65]
[null,"Plate and Frame",4.2755999999999998,0.35199999999999998,7.1400000000000005E-2,0.5,80,1.8]
[null,"Table",5.1055000000000001,0.49990000000000001,1E-4,0.9,115,1.65]
[null,"Tube",5.1055000000000001,0.49990000000000001,1E-4,0.9,115,1.54]
[]
[]
[null,"Fired Heater Data"]
[null,null,null,null,null,null,null,null,null,null,null,"Bare Module Factor"]
[null,"Reactive Heaters","K1","K2","K3","Qmin(kW)","Qmax(kW)","Pmax(barg)","C1","C2","C3","CS","Alloy Steel","SS"]
[null,"Reformer Furnace",3.0680000000000001,0.65969999999999995,1.9400000000000001E-2,3000,100000,200,0.14050000000000001,-0.26979999999999998,0.1293,2.13,2.5099999999999998,2.81]
[null,"Pyrolysis Furnace",2.3858999999999999,0.97209999999999996,-2.06E-2,3000,100000,200,0.1017,-0.19570000000000001,9.4030000000000002E-2,2.13,2.5099999999999998,2.81]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Bare Module Factor"]
[null,"Non-reactive Heaters","K1","K2","K3","Qmin(kW)","Qmax(kW)","Pmax(barg)","C1","C2","C3","CS","Alloy Steel","SS"]
[null,"Process Heater",7.3487999999999998,-1.1666000000000001,0.20280000000000001,1000,100000,200,0.13469999999999999,-0.23680000000000001,0.1021,2.13,2.5099999999999998,2.81]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Steam Supreheat Factor"]
[null,"Thermal Fluid Heaters","K1","K2","K3","Qmin(kW)","Qmax(kW)","Pmax(barg)","C1","C2","C3","Fbm","FT1","FT2","FT3"]
[null,"Hot Water",2.0829,0.90739999999999998,-2.4299999999999999E-2,650,10750,200,-1.6330000000000001E-2,5.6875000000000002E-2,-8.7600000000000004E-3,2.17]
[null,"Molten Salt, Mineral Oil,",1.1979,1.4782,-9.5799999999999996E-2,650,10750,200,-1.6330000000000001E-2,5.6875000000000002E-2,-8.7600000000000004E-3,2.17]
[null,"Diphenyl Based Oils",2.2627999999999999,0.85809999999999997,2.9999999999999997E-4,650,10750,200,-1.6330000000000001E-2,5.6875000000000002E-2,-8.7600000000000004E-3,2.17]
[null,"Packaged Steam Boilers",6.9617000000000004,-1.48,0.31609999999999999,1200,9400,40,2.5940720000000002,-4.2347599999999996,1.722404,2.17,1,1.8400000000000001E-3,3.3500000000000001E-6]
[]
[]
[null,"Evaporator Data"]
[]
[null,"Evaporator Types","K1","K2","K3","Amin(m2)","Amax(m2)","Pmax(barg)","C1","C2","C3"]
[null,"Forced Circulation",5.0237999999999996,0.34749999999999998,7.0300000000000001E-2,5,1000,150,0.1578,-0.29920000000000002,0.14130000000000001]
[null,"Falling Film",3.9119000000000002,0.86270000000000002,-8.8000000000000005E-3,50,500,150,0.1578,-0.29920000000000002,0.14130000000000001]
[null,"Agitated (Scraped Wall)",5,0.14899999999999999,-1.34E-2,0.5,5,150,0.1578,-0.29920000000000002,0.14130000000000001]
[null,"Short Tube",5.2366000000000001,-0.65720000000000001,0.35,10,100,150,0.1578,-0.29920000000000002,0.14130000000000001]
[null,"Long Tube",4.6420000000000003,0.36980000000000002,2.5000000000000001E-3,100,10000,150,0.1578,-0.29920000000000002,0.14130000000000001]
[]
[]
[null,"Heat Exchanger Data"]
[null,"Exchager Type","K1","K2","K3","C1","C2","C3","B1","B2","Amin(m2)","Amax(m2)","Pmax(barg)"]
[null,"Double Pipe",3.3443999999999998,0.27450000000000002,-4.7199999999999999E-2,13.146699999999999,-12.657400000000001,3.0705,1.74,1.55,1,10,300]
[null,"40 barg  < P < 100 barg",null,null,null,0.60719999999999996,-0.91200000000000003,0.3327]
[null,"P < 40 barg",null,null,null,0,0,0]
[null,"Multiple Pipe",2.7652000000000001,0.72819999999999996,7.8299999999999995E-2,13.146699999999999,-12.657400000000001,3.0705,1.74,1.55,10,100,300]
[null,"40 barg  < P < 100 barg",null,null,null,0.60719999999999996,-0.91200000000000003,0.3327]
[null,"P < 40 barg",null,null,null,0,0,0]
[null,"Fixed tube, sheet, or U tube",4.3247,-0.30299999999999999,0.16339999999999999,3.8809999999999997E-2,-0.11272,8.183E-2,1.63,1.66,10,1000,140]
[null,"tubes only > 5 barg",null,null,null,-1.64E-3,-6.2700000000000004E-3,1.23E-2]
[null,"Floating Head",4.8305999999999996,-0.85089999999999999,0.31869999999999998,3.8809999999999997E-2,-0.11272,8.183E-2,1.63,1.66,10,1000,140]
[null,"tubes only > 5barg",null,null,null,-1.64E-3,-6.2700000000000004E-3,1.23E-2]
[null,"Bayonet",4.2767999999999997,-4.9500000000000002E-2,0.1431,3.8809999999999997E-2,-0.11272,8.183E-2,1.63,1.66,10,1000,140]
[null,"tubes only > 5 barg",null,null,null,-1.64E-3,-6.2700000000000004E-3,1.23E-2]
[null,"Kettle Reboiler",4.4645999999999999,-0.52769999999999995,0.39550000000000002,3.8809999999999997E-2,-0.11272,8.183E-2,1.63,1.66,10,100,140]
[null,"tubes only > 5 barg",null,null,null,-1.64E-3,-6.2700000000000004E-3,1.23E-2]
[null,"Scraped Wall",3.7803,0.8569,3.49E-2,13.146699999999999,-12.657400000000001,3.0705,1.74,1.55,2,20,300]
[null,"40 barg  < P < 100 barg",null,null,null,0.60719999999999996,-0.91200000000000003,0.3327]
[null,"P < 40 barg",null,null,null,0,0,0]
[null,"Teflon Tube",3.8062,0.89239999999999997,-0.1671,0,0,0,1.63,1.66,1,10,15]
[null,"Air Cooler",4.0335999999999999,0.2341,4.9700000000000001E-2,-0.125,0.15361,-2.861E-2,0.96,1.21,10,10000,100]
[null,"Spiral Tube - shell and tube",3.9912000000000001,6.6799999999999998E-2,0.24299999999999999,-0.40450000000000003,0.18590000000000001,0,1.74,1.55,1,100,400]
[null,"tube only",null,null,null,-0.21149999999999999,9.7170000000000006E-2,0]
[null,"Spiral Plate",4.6561000000000003,-0.29470000000000002,0.22070000000000001,0,0,0,0.96,1.21,1,100,19]
[null,"Flat Plate",4.6656000000000004,-0.15570000000000001,0.1547,0,0,0,0.96,1.21,10,1000,19]
[]
[null,"Materail Factors, FM"]
[null,null,"Shell - CS","CS","Cu","CS","SS","CS","Ni","CS","Ti"]
[null,"Exchanger Type","Tube - CS","Cu","Cu","SS","SS","Ni","Ni","Ti","Ti"]
[null,"Double Pipe",1,1.35,1.69,1.81,2.73,2.68,3.73,4.63,11.38]
[null,"Multiple Pipe",1,1.35,1.69,1.81,2.73,2.68,3.73,4.63,11.38]
[null,"Fixed tube, sheet, or U tube",1,1.35,1.69,1.81,2.73,2.68,3.73,4.63,11.38]
[null,"Floating Head",1,1.35,1.69,1.81,2.73,2.68,3.73,4.63,11.38]
[null,"Bayonet",1,1.35,1.69,1.81,2.73,2.68,3.73,4.63,11.38]
[null,"Kettle Reboiler",1,1.35,1.69,1.81,2.73,2.68,3.73,4.63,11.38]
[null,"Scraped Wall",1,1.35,1.69,1.81,2.73,2.68,3.73,4.63,11.38]
[null,"Spiral Tube",1,1.35,1.69,1.81,2.73,2.68,3.73,4.63,11.38]
[]
[null,null,"Shell Materail"]
[null,"Exchanger Type","CS","Cu","SS","Ni","Ti"]
[null,"Teflon Tube Exchanger",1,1.2,1.3,1.4,3.3]
[]
[null,null,"Material In Contact with Process Fluid"]
[null,"Exchanger Type","CS","Cu","SS","Ni","Ti"]
[null,"Spiral Plate",1,1.35,2.4500000000000002,2.68,4.63]
[null,"Flat Plate",1,1.35,2.4500000000000002,2.68,4.63]
[]
[null,null,"Tube Material"]
[null,"Exchanger Type","CS","Al","SS"]
[null,"Air Cooler",1,1.42,2.93]
[]
[]
[null,"Mixer Data"]
[null,"Mixer Type","K1","K2","K3","Pmin(kW)","Pmax(kW)","FBM"]
[null,"Impeller",3.8511000000000002,{"$f":"1-0.2991","v":0.70090000000000008},-2.9999999999999997E-4,5,150,1.38]
[null,"Propeller",4.3207000000000004,{"$f":"1-0.9641","v":3.5900000000000043E-2},0.1346,5,500,1.38]
[null,"Turbine",3.4091999999999998,{"$f":"1-0.5104","v":0.48960000000000004},3.0000000000000001E-3,5,150,1.38]
[]
[]
[null,"Pump Data (including electric drives)"]
[null,"Pump Type","K1","K2","K3","C1","C2","C3","B1","B2","FmCI","FmCS","FmCu","FmSS","FmNi","FmTi","Pmax(barg)","Wmin(kW)","Wmax(kW)"]
[null,"Centrifugal pump",3.3892000000000002,5.3600000000000002E-2,0.15379999999999999,-0.39350000000000002,0.3957,-2.2599999999999999E-3,1.89,1.35,1,1.55,"NA",2.2799999999999998,4.3600000000000003,"NA",100,1,300]
[null,"Positive Displacement",3.4771000000000001,0.13500000000000001,0.14380000000000001,-0.24538199999999999,0.25901600000000002,-1.363E-2,1.89,1.35,1,1.41,1.28,2.67,4.74,10.66,100,1,100]
[null,"Reciprocating pump",3.8696000000000002,0.31609999999999999,0.122,-0.24538199999999999,0.25901600000000002,-1.363E-2,1.89,1.35,1,1.46,1.28,2.35,3.95,6.44,100,0.1,200]
[]
[]
[null,"Reactor Data"]
[null,"Reactor Type","K1","K2","K3","Vmin(m3)","Vmax(m3)","FBM"]
[null,"Autoclave",4.5587,0.29859999999999998,2E-3,1,15,4]
[null,"Fermenter",4.1052,0.53200000000000003,-5.0000000000000001E-4,0.1,35,4]
[null,"Inoculum Tank",3.7957000000000001,0.45929999999999999,1.6E-2,7.0000000000000007E-2,1,4]
[null,"Jacketed Agitated",4.1052,0.53200000000000003,-5.0000000000000001E-4,0.1,35,4]
[null,"Jacketed Non-Agitated",3.3496000000000001,0.72350000000000003,2.5000000000000001E-3,5,45,4]
[null,"Mixer/Settler",4.7115999999999998,0.44790000000000002,4.0000000000000002E-4,0.04,6,4]
[]
[]
[null,"Screen Data"]
[null,"Screen Type","K1","K2","K3","Amin(m2)","Amax(m2)","FBM"]
[null,"DSM",3.8050000000000002,{"$f":"1-0.4144","v":0.58560000000000001},0.21199999999999999,0.3,6,1.34]
[null,"Rotary",4.0484999999999998,{"$f":"1-0.8882","v":0.11180000000000001},0.32600000000000001,0.3,15,1.34]
[null,"Stationary",3.8218999999999999,1.0367999999999999,-0.60499999999999998,2,11,1.34]
[null,"Vibrating",4.0484999999999998,{"$f":"1-0.8882","v":0.11180000000000001},0.32600000000000001,0.3,15,1.34]
[]
[]
[null,"Tank Data"]
[null,"Tank Type","K1","K2","K3","B1","B2","Vmin(m3/s)","Vmax(m3/s)"]
[null,"Fixed Roof",4.8509000000000002,-0.39729999999999999,0.14449999999999999,1.1000000000000001,0,90,30000]
[null,"Floating Roof",5.9566999999999997,-0.75849999999999995,0.1749,1.1000000000000001,0,1000,40000]
[]
[]
[null,"Turbine Data"]
[null,"Turbine Type","K1","K2","K3","FBMCI","FBMCS","FBMCu","FBMSS","FBMNi","FBMTi","Wmin(kW)","Wmax(kW)"]
[null,"Axial",2.7050999999999998,1.4398,-0.17760000000000001,"NA",3.5,"NA",6.13,11.66,"NA",100,4000]
[null,"Radial",2.2475999999999998,1.4964999999999999,-0.1618,"NA",3.5,"NA",6.13,11.66,"NA",100,1500]
[]
[null,"Vaporizer Data"]
[]
[null,"Vaporizer Types","K1","K2","K3","Vmin(m3)","Vmax(m3)","Pmax(barg)","C1","C2","C3"]
[null,"Jacketed Vessel",3.8751000000000002,0.33279999999999998,0.19009999999999999,1,100,320,0.1578,-0.29920000000000002,0.14130000000000001]
[null,"Internal Coil",4.0380000000000003,9.1420000000000001E-2,0.27660000000000001,1,100,320,0.1578,-0.29920000000000002,0.14130000000000001]
[null,"Jacketed Vessel w/ Coil",4.0380000000000003,9.1420000000000001E-2,0.27660000000000001,1,100,320,0.1578,-0.29920000000000002,0.14130000000000001]
[]
[null,null,null,"Bare Module Factors, FBM"]
[null,"Vaporizer Types","CS","Cu","GL SS Coils","Glass Lined Ni Coils","SS","SS Clad","Ni Alloy","Ni Alloy Clad","Ti","Ti Clad"]
[null,"Jacketed Vessel",2.74,3.43,4.66,4.93,4.8,3.77,9.1199999999999992,5.93,13.7,9.5299999999999994]
[null,"Internal Coil",3.03,3.79,5.15,5.45,5.15,4.09,10.09,6.56,15.15,10.61]
[null,"Jacketed Vessel w/ Coil",3.03,3.79,5.15,5.45,5.15,4.09,10.09,6.56,15.15,10.61]
[]
[null,"Evaporator Data"]
[null,null,null,"Bare Module Factors, FBM"]
[null,"Evaporator Types","CS","Cu Alloy","SS","Ni Alloy","Ti"]
[null,"Forced Circulation",2.9,3.63,5.08,9.66,14.5]
[null,"Falling Film",2.25,2.81,3.94,7.49,11.25]
[null,"Agitated (Scraped Wall)",2.25,2.81,3.94,7.49,11.25]
[null,"Short Tube",2.9,3.63,5.08,9.66,14.5]
[null,"Long Tube",2.9,3.63,5.08,9.66,14.5]
[]
[]
[null,"Vessel Data (including data for distillation towers and packed columns)"]
[null,"Vertical Vessels",null,null,null,null,"Horizontal Vessels"]
[null,"K1","K2","K3","Vmin","Vmax","K1","K2","K3","Vmin","Vmax","Pmax(barg)"]
[null,3.4973999999999998,0.44850000000000001,0.1074,0.3,520,3.5565000000000002,0.37759999999999999,9.0499999999999997E-2,0.1,628,400]
[]
[]
[null,"Vessel Type","B1","B2"]
[null,"Horizontal",1.49,1.52]
[null,"Vertical",2.25,1.82]
[]
[null,"Materials of Construction"]
[null,"FM CS",1]
[null,"FM SS clad",1.74]
[null,"FM SS",3.11]
[null,"FM Ni clad",3.62]
[null,"FM Ni",7.07]
[null,"FM Ti clad",4.68]
[null,"FM Ti",9.4]
[]
[null,"Tower Trays"]
[null,"Tray Type","K1","K2","K3","Amin(m2)","Amax(m2)"]
[null,"Sieve",2.9948999999999999,0.44650000000000001,0.39610000000000001,7.0000000000000007E-2,12.3]
[null,"Valve",3.3321999999999998,0.48380000000000001,0.34339999999999998,0.7,10.5]
[null,"Demister",3.2353000000000001,0.48380000000000001,0.34339999999999998,0.7,10.5]
[null,"FBM"]
[null,"MOC",null,"Sieve","Valve","Demister"]
[null,"CS",null,1,1,1]
[null,"SS",null,1.83,1.83,1]
[null,"Fluorocarbon",null,null,null,1.83]
[null,"Ni-alloy",null,5.58,5.58,5.58]
[]
[null,"Fq = 10^{0.4771+0.08516 Log N -0.3473 [Log N]^2}"]
[]
[null,"N","Fq"]
[null,1,{"$f":"10^(0.4771+0.08516*LOG10(B270)-0.3473*(LOG10(B270))^2)","v":2.9998531811907938}]
[null,2,{"$f":"10^(0.4771+0.08516*LOG10(B271)-0.3473*(LOG10(B271))^2)","v":2.9598091980761878}]
[null,3,2.745811025949318]
[null,4,2.5262913385408714]
[null,5,2.3278110295375591]
[null,8,1.8653449373966906]
[null,10,1.6404386762556979]
[null,15,1.2498958296278693]
[null,20,1.0000651203747728]
[]
[]
[null,"Tower Packing"]
[null,"Materials of Construction","K1","K2","K3","Vmin(m3)","Vmax(m3)","FBM"]
[null,"Ceramic",2.4493,0.97440000000000004,5.4999999999999997E-3,0.03,628,4.1399999999999997]
[null,"304 SS",2.4493,0.97440000000000004,5.4999999999999997E-3,0.03,628,7.09]
[null,"Plastic Saddle",2.4493,0.97440000000000004,5.4999999999999997E-3,0.03,628,1]

{"sheet":"Cooling Water","index":7,"n_rows":36,"n_cols":5,"rows_kept":36,"cut":false,"hidden":false,"merged":[]}
[null,"COST   OF   COOLING WATER"]
[null,"User may change values to suit location and changing circumstances"]
[]
[null,"Cost of electrical power",{"$f":"costElectricity/1000000000*3600000","v":6.7391999999999994E-2},"$/kWh"]
[null,"Cost of Chemicals",3.4700000000000003E-5,"$/kg MU water"]
[null,"Cost of water",{"$f":"0.177/1000","v":1.7699999999999999E-4},"$/kg MU water"]
[]
[null,"Deisgn DT",10,"°C"]
[null,"Basis ",1,"GJ"]
[null,"rwater",996,"kg/m3"]
[null,"m",{"$f":"1000000000/4180/C8","v":23923.444976076553},"kg/h"]
[null,"l",2417,"kJ/kg"]
[null,"Wevap",{"$f":"C9*1000000000/C12/1000","v":413.73603640877116},"kg/h"]
[null,"fevap",{"$f":"C13/C11","v":1.7294166321886635E-2}]
[null,"Windage loss, fwind",3.0000000000000001E-3,"Range =","0.001 to 0.003"]
[null,"s, salt conc factor",5,"Range =","3 to 7"]
[null,"fBD",{"$f":"C14/(C16-1)-C15","v":1.3235415804716587E-3}]
[null,"fMU ",{"$f":"C14+C15+C17","v":2.1617707902358292E-2}]
[null,"WMU",{"$f":"C18*C11","v":517.17004551096386},"kg/h"]
[null,"DPloop",266.7,"kPa"]
[null,"pump efficiency",0.75]
[null,"Power for circ cw pump",{"$f":"1/C21*(C11/C10/3600)*C20","v":2.3725951119736783},"kW"]
[]
[null,"SA of tower",0.5,"ft2/gpm"]
[null,"Fan hp",{"$f":"0.041","v":4.1000000000000002E-2},"hp/ft2-tower"]
[null,"Power for Fan",{"$f":"C11*2.2048/60/8.337*0.5*0.041*0.746","v":1.6125922010583289},"kW"]
[]
[null,"Cooling Water Cost",{"$f":" C4*(C22+C26)+C19*C5+C19*C6","v":0.37805464203452405},"$/GJ"]
[null,null,{"$f":"C28/C11*C10*1000","v":15.739473300894934},"$/1000m3"]
[]
[null,"indicates user option"]
[]
[null,"% electricity",{"$f":"(C26+C22)*C4/C28","v":0.71039927443961171}]
[null,"% MU chemical cost",{"$f":"C19*C5/C28","v":4.7468801024777872E-2}]
[null,"% MU water cost",{"$f":"C19*C6/C28","v":0.24213192453561044}]
[null,null,{"$f":"SUM(C33:C35)","v":1}]

{"sheet":"Cost of Refrigerated Water","index":8,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["COST  OF  REFRIGERATED WATER"]
["User may change values to suit location and changing circumstances"]
[]
["Cost of electrical power",{"$f":"costElectricity*3600000/1000000000","v":6.7391999999999994E-2},"$/kWh"]
["Cost of CW",{"$f":"costCW","v":0.378},"$/GJ"]
[]
["Basis ",1,"GJ/h"]
["Refrigerant","R-152a"]
["Compressor Efficiency",0.75]
["Compressor Duty",63.8,"kW"]
["Condenser Duty",1.23,"GJ/h"]
["Evaporator duty",1,"GJ/h"]
[]
["Cost per GJ",{"$f":"B10*B4+B11*B5","v":4.7645495999999996},"$/GJ"]

{"sheet":"Cost of Steam","index":9,"n_rows":47,"n_cols":19,"rows_kept":47,"cut":false,"hidden":false,"merged":[]}
["User may change values to suit location and changing circumstances"]
["hbfw",482.6,"kJ/kg","saturated liquid at 115°C"]
[]
[]
[]
[]
["HP steam generated at 45.3 bar and 400°C",null,"(650 psig and 400°C)"]
[]
["HP-Steam",null,null,null,null,null,null,"MP-Steam - with Power Generation (10 barg)",null,null,null,null,null,null,"LP-Steam - with Power Generation (6.2 barg)"]
["Natural gas cost",{"$f":"costNaturalGas","v":3.16},"$/GJ",0.1119,"$/std m3",null,null,"Natural gas cost",{"$f":"B10","v":3.16},"$/GJ",null,null,null,null,"Natural gas cost",{"$f":"B10","v":3.16},"$/GJ"]
["Process water cost",0.17699999999999999,"$/1000 kg",null,null,null,null,"Process water cost",{"$f":"B11","v":0.17699999999999999},"$/1000 kg",null,null,null,null,"Process water cost",{"$f":"B11","v":0.17699999999999999},"$/1000 kg"]
["Chemicals to treat bfw",0.156,"$/1000 kg",null,null,null,null,"Chemicals to treat bfw",{"$f":"B12","v":0.156},"$/1000 kg",null,null,null,null,"Chemicals to treat bfw",{"$f":"B12","v":0.156},"$/1000 kg"]
["Electricity",{"$f":"costElectricity*0.0036","v":6.7391999999999994E-2},"$/kWh",null,null,null,null,"Electricity",{"$f":"B13","v":6.7391999999999994E-2},"$/kWh",null,null,null,null,"Electricity",{"$f":"B13","v":6.7391999999999994E-2},"$/kWh"]
[]
["Basis ",1000,"kg of HP steam generated in boiler",null,null,null,null,"Basis ",1000,"kg of HP steam generated in boiler",null,null,null,null,"Basis ",1000,"kg of HP steam generated in boiler"]
["Pgen",45.3,"bar",null,null,null,null,"Pgen",{"$f":"B16","v":45.3},"bar",null,null,null,null,"Pgen",{"$f":"B16","v":45.3},"bar"]
["Tgen",400,"°C",null,null,null,null,"Tgen",400,"°C",null,null,null,null,"Tgen",{"$f":"B17","v":400},"°C"]
["hsteam",3205,"kJ/kg",null,null,null,null,"hgen",{"$f":"B18","v":3205},"kJ/kg",null,null,null,null,"hgen",{"$f":"B18","v":3205},"kJ/kg"]
["hsteam, sat",{"$f":"2799.9","v":2799.9},"kJ/kg",null,null,null,null,"sgen",6.7031999999999998,"kJ/kg/K",null,null,null,null,"sgen",6.7031999999999998,"kJ/kg/K"]
["hcond,sat",1101.5999999999999,"kJ/kg",null,null,null,null,"Conditions after rev adiabatic expansion",null,null,null,null,null,null,"Conditions after adiabatic expansion of 75% efficiency"]
["hbfw at 115C",{"$f":"B2","v":482.6},"kJ/kg",null,null,null,null,"hout",2851.9,"kJ/kg",null,null,null,null,"hout",{"$f":"2854.8","v":2854.8},"kJ/kg"]
["DH=mDh",{"$f":"(B18-B21)*1000/1000000","v":2.7223999999999999},"GJ",null,null,null,null,"-Wtheor",{"$f":"I18-I21","v":353.09999999999991},"kJ/kg",{"$f":"I22/3.6","v":98.0833333333333},"kWh",null,null,"-Wtheor",{"$f":"P18-P21","v":350.19999999999982},"kJ/kg",{"$f":"P22/3.6","v":97.277777777777729},"kWh"]
["bfw to desuperheat",{"$f":"(B18-B21)/(B19-B21)*1000-1000","v":174.81551805981098},"kg",null,null,null,null,"efficiency of turbine",0.75]
["total hp steam",{"$f":"1000+B23","v":1174.815518059811},"steam available at header after desuperheating",null,null,null,null,"actual work (-Wact)",{"$f":"K22*I23","v":73.562499999999972},"kWh",null,null,null,null,"actual work (-Wact)",{"$f":"R22","v":97.277777777777729},"kWh"]
["boiler efficiency",0.9,null,null,null,null,null,"credit for electricty",{"$f":"I24*I13","v":4.9575239999999976},null,null,null,null,null,"credit for electricty",{"$f":"P24*P13","v":6.5557439999999962}]
["cost of NG to produce steam",{"$f":"B22/B25*B10*(1000)/B24","v":8.1362977777777754},"per 1000 kg steam at header",null,null,null,null,"hout (after expansion)",{"$f":"I18-0.75*I22","v":2940.1750000000002},"kJ/kg",null,null,null,null,"hout (after expansion)",{"$f":"P21","v":2854.8},"kJ/kg"]
["Natural gas usage",{"$f":"B22/B25/B24*1000","v":2.5747777777777774},"GJ per 1000 kg steam at header",null,null,null,null,"hsat vap,10 barg",2780.7,"kJ/kg",null,null,null,null,"hsat vap,6.2 bar",2757.6,"kJ/kg"]
["natural gas usage",{"$f":"B27*B10/D10","v":72.710435905073965},"scm",null,null,null,null,"hsat liq,10 barg",781.2,null,null,null,null,null,"hsat liq,6.2 bar",676.1]
[null,{"$f":"B28/22.4","v":3.2460016029050878},"kmol",null,null,null,null,"hbfw",{"$f":"B21","v":482.6},"kJ/kg",null,null,null,null,"hbfw",{"$f":"I29","v":482.6},"kJ/kg"]
["% excess air",0.03,null,null,null,null,null,"steam produced after desuperheating",{"$f":"(I26-I29)*1000/(I27-I29)","v":1069.3942822331494},"kg",null,null,null,null,"steam produced after desuperheating",{"$f":"(P26-P29)*1000/(P27-P29)","v":1042.7252747252749},"kg"]
["O2",{"$f":"2*B29*(1+B30)","v":6.686763301984481},"kmol",null,null,null,null,"cost of nat gas to produce  1000 kg of saturated MP steam ",{"$f":"B22*1000*I10/B25/I30","v":8.9383766564827329},null,null,null,null,null,"cost of nat gas to produce  1000 kg of saturated MP steam ",{"$f":"B22*1000*B10/B25/P30","v":9.1669868570197384}]
["Air",{"$f":"B31/0.21","v":31.841730009449911},"kmol",null,null,null,null,"Cost of electricity for blower",{"$f":"B36*I31/B26","v":1.1500184923417134},null,null,null,null,null,"Cost of electricity for blower",{"$f":"P31/B26*B36","v":1.179431658541733}]
["blower efficiency",0.6,null,55.92,"MJ/h","from process simulator (Chemcad)",null,"Total cost of sat'd MP steam",{"$f":"I31-I25+I32+I12+B41+B43","v":5.5623402688244488},null,null,null,null,null,"Total cost of sat'd MP steam",{"$f":"P31-P25+P32+P12+B41+B43","v":4.2221436355614763}]
["Power for blower",{"$f":"D33*1000/3600","v":15.533333333333333},"kWh",null,null,null,null,"Energy released by condensation",{"$f":"1000*(I27-I28)/1000000","v":1.9994999999999998},"GJ",null,null,null,null,"Energy released by condensation",{"$f":"1000*(P27-P28)/1000000","v":2.0815000000000001},"GJ"]
[null,null,null,null,null,null,null,"Cost of MP steam in heat exchanger",{"$f":"I33/I34","v":2.7818656008124276},"$/GJ",null,null,null,null,"Cost of MP steam in heat exchanger",{"$f":"P33/P34","v":2.028413949344932},"$/GJ"]
["cost of electricty for blower",{"$f":"B34*B13","v":1.0468223999999999}]
["make-up water",0.1,"of all steam","(100 kg/1000kg steam)",null,null,null,"MP-Steam - without Power Generation (10 barg)",null,null,null,null,null,null,"LP-Steam - without Power Generation (6.2 barg)"]
["energy in bfw",{"$f":"1000*4.18*(115-25)*1000/1000000000","v":0.37619999999999998},"GJ/kg",null,null,null,null,"steam produced after desuperheating",{"$f":"1000*(I18-I29)/(I27-I29)","v":1184.6307819503068},"kg",null,null,null,null,"steam produced after desuperheating",{"$f":"1000*(P18-P29)/(P27-P29)","v":1196.6593406593406},"kg"]
["value of energy in MU water",{"$f":"B38*B10","v":1.1887920000000001},null,null,null,null,null,"cost of natural gas",{"$f":"B22*1000*I10/B25/I38","v":8.0688844444444463},"per 1000 kg of saturated MP steam",null,null,null,null,"cost of natural gas",{"$f":"B22*1000*P10/B25/P38","v":7.9877777777777794},"per 1000 kg of saturated MP steam"]
["bfw cost",{"$f":"B39+B11+B12","v":1.521792},"$/1000 kg of bfw (value given in Table 8.2)",null,null,null,null,"cost of electricity for blower",{"$f":"I39/B26*B36","v":1.0381489481033968},null,null,null,null,null,"cost of electricity for blower",{"$f":"P39/B26*B36","v":1.027713701290295}]
["make up water cost",{"$f":"B40*B37","v":0.15217920000000001},"(cost for process water, to heat up water, and treatment chemicals)/1000 kg steam",null,null,null,null,"Total cost of sat'd MP steam",{"$f":"I39+I40+I12+B41+B43","v":9.5385025125478435},"per 1000 kg of saturated MP steam",null,null,null,null,"Total cost of sat'd MP steam",{"$f":"P39+P40+P12+B41+B43","v":9.4469605990680758},"per 1000 kg of saturated MP steam"]
["work to pump bfw to 45.3 bar",{"$f":"6.586","v":6.5860000000000003},"MJ/1000 kg",{"$f":"B42/3.6","v":1.8294444444444444},"kWh",null,null,"Cost of MP steam in heat exchanger",{"$f":"I41/I34","v":4.7704438672407328},"$/GJ",null,null,null,null,"Cost of MP steam in heat exchanger",{"$f":"P41/P34","v":4.5385349983512251},"$/GJ"]
["cost to pump bfw to 45.3 bar",{"$f":"D42*B13","v":0.12328991999999998}]
["Total cost for steam",{"$f":"B26+B34*B13+B12+B41+B43","v":9.6145892977777763},"$/1000 kg of steam"]
[]
["Energy obtained through condensation of 1000 kg of HP steam at Tsat",{"$f":"1000*(B19-B20)/1000000","v":1.6983000000000001},"GJ"]
["Cost of steam",{"$f":"B44/B46","v":5.6613020654641559},"$/GJ"]