{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["INPUT","Results Summary","DCFROR","Mass Balance","OPEX","CAPEX","Cost Breakdown","Facility_Dim","Quick Access Charts"],"not_rendered":{"charts":1,"images":2,"macros":1,"external_links":1,"defined_names":50,"comments":0,"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":"INPUT","index":0,"n_rows":77,"n_cols":9,"rows_kept":77,"cut":false,"hidden":false,"merged":[]}
["Use of this tool is subject to a disclaimer (https://www.nrel.gov/disclaimer.html)"]
["Overall process/design framework for this TEA tool is based on NREL's Algae Farm Design Report - for details refer to: https://www.nrel.gov/docs/fy16osti/64772.pdf "]
["Biomass cost results differ from Design Report due to different cost-year dollars (more recent work updates parameters further to 2016$ and 21% tax rates)"]
[null," "]
[null," ",null," "]
["INPUT DATA"]
[]
[null,null,null,null," "]
["Main Process Inputs",null,null,null,null,null,"= Input Required"]
["Facility size (based on cultivation area)",5000,"acres",null,null,null,"= Calculated Cells"]
["Module size (based on cultivation area)",100,"acres","Recommend leaving default at 100 acres, may be varied from 1-500",null,null,"= No Input Required"]
["Individual pond size","10-acre",null,null,null,null,"=Aditional Notes"]
["Pond liner coverage","Minimally Lined"]
["Pond depth",20,"cm"]
["Pond harvest concentration",0.5,"g/L","Values allowed from 0.0001 to 0.9999 g/L. Above 1 will cause unsolveable dewatering steps. "]
["Fresh or saline water cultivation","Freshwater"]
["Total pond volume",{"$f":"B14/100*4046.86*B10","v":4046860.0000000005},"m^3"]
["CO2 uptake efficiency in ponds",0.9]
["CO2 uptake efficiency in PBRs",0.99]
["Excess NH3 to ponds",0.2,null,"Values allowed from 0% to 99.99%"]
["Excess DAP to ponds",0.1,null,"Values allowed from 0% to 99.99%"]
["Production ponds initial concentration at inoculation",0.1,"g/L"]
["Outlet concentration of 1st-stage inoculum (tubular PBR)",1.5,"g/L",null,null,null,null,"MINIMUM BIOMASS SELLING PRICE "]
["Outlet concentration of 2nd-stage inoculum (closed ponds)",0.5,"g/L",null,null,null,null,{"$f":"\"$\"&ROUND(DCFROR!B31,0)&\"/U.S. Ton\"","v":"$494/U.S. Ton"},"$/ton AFDW"]
["Outlet concentration of 3rd-stage inoculum (lined open ponds)",0.5,"g/L",null,null,null,"NPV",{"$f":"DCFROR!B33","v":0},"If NPV does not equal zero, press Solve Product Cost button. "]
["Pond up-time between re-inoculation",20,"days",null,null,null,"Mass Balance",{"$f":"SUM(ABS('Mass Balance'!AR155),ABS('Mass Balance'!AR134),ABS('Mass Balance'!AR112),ABS('Mass Balance'!AR91))","v":2.1066676923510386E-2},"If Mass Balance does not equal zero, press Solve Product Cost button. This will re-run the mass balance and the NPV calculation. "]
["Primary dewatering outlet concentration",10,"g/L"]
["Primary dewatering harvest efficiency",0.9]
["Residence time for settling tank (primary dewatering)",4,"hr"]
["Secondary dewatering outlet concentration",130,"g/L"]
["Secondary dewatering harvest efficiency",0.995]
["Tertiary dewatering outlet concentration",200,"g/L"]
["Tertiary dewatering harvest efficiency",0.97]
["Biomass loss during short-term product storage",0.01]
["Blowdown disposal set manually (user defined) or calculated based on salt tolerance of algae? ","User defined",null,"Only applies if saline cultivation is selected (B16)"]
[]
[]
["Salt content in makeup water",250,"mg/L","Recommend  a saline case of 7,000 mg/L (typical saline groundwater), 250 may be shown as default for freshwater"]
["Salt tolerance of algae strain",4000,"mg/L","Recommend  a saline case up to 40,000 mg/L, 4000 may be shown as default for freshwater"]
["Specifed percent below the salininty tolerance ",0,null,"Recommend  a saline case of 10% below salinity tolerance. 0% may be shown as default for freshwater"]
[]
[]
["Season Specific Process Inputs"]
[null,"SUMMER","FALL","WINTER","SPRING","Yearly Average ","Unit","Season that CAPEX is Sized From (season with largest productivity)"]
[null,"(JUN, JUL, AUG)","(SEP, OCT, NOV)","(DEC, JAN, FEB)","(MAR, APRL, MAY)",null,null,{"$f":"INDEX(B44:E44,MATCH(MAX(B46:E46),B46:E46,0))","v":"SUMMER"}]
["Productivity ",35,24.9,11.7,28.5,{"$f":"AVERAGE(B46:E46)","v":25.024999999999999},"g/m2/day",{"$f":"MAX(B46:E46)","v":35},"g/m2/day"]
["Evaporation ",0.09,3.5000000000000003E-2,3.5000000000000003E-2,0.189,{"$f":"AVERAGE(B47:E47)","v":8.7249999999999994E-2},"cm/day"]
["Blowdown For Facility",304135,116817,111986,514894,{"$f":"AVERAGE(B48:E48)","v":261958},"kg/hr"]
["Is there enough blowdown to accommodate cell salt tolerance?  ",{"$f":"IF(SUM('Mass Balance'!C79:V79)>0,\"NO, PLEASE INCREASE BLOWDOWN AMOUNT\",\"Yes\")","v":"Yes"},{"$f":"IF(SUM('Mass Balance'!C100:V100)>0,\"NO, PLEASE INCREASE BLOWDOWN AMOUNT\",\"Yes\")","v":"Yes"},{"$f":"IF(SUM('Mass Balance'!C121:V121)>0,\"NO, PLEASE INCREASE BLOWDOWN AMOUNT\",\"Yes\")","v":"Yes"},{"$f":"IF(SUM('Mass Balance'!C142:V142)>0,\"NO, PLEASE INCREASE BLOWDOWN AMOUNT\",\"Yes\")","v":"Yes"}]
[]
[]
["Strain Specific Inputs"]
["Algal composition specified based on wt% or elemental formula (molar): ","Elemental Formula"]
[]
[null,"Wt% Composition (dry basis and ash free basis)","Elemental Formula (ash free dry weight)","Molecular Weight of Components","Adjusted to Close Mass Balance - wt% composition (dry and ash free basis)","Elemental Fomula"]
["Carbon",0.3,620,12.0107,{"$f":"B56/$B$62","v":0.39515279241306639},{"$f":"IF($B$53=\"Mass Percent\",B56/D56/($B$61/$D$61),C56)","v":620}]
["Hydrogen",8.2000000000000003E-2,1117,1.0079400000000001,{"$f":"B57/$B$62","v":0.10800842992623816},{"$f":"IF($B$53=\"Mass Percent\",B57/D57/($B$61/$D$61),C57)","v":1117}]
["Oxygen",0.35499999999999998,306,15.9994,0.46759747102212856,306]
["Nitrogen",1.7999999999999999E-2,18,14.0067,2.3709167544783982E-2,18]
["Sulfur",2E-3,0,32.064999999999998,2.6343519494204425E-3,0]
["Phosphourous",2.2000000000000001E-3,1,30.973759999999999,2.897787144362487E-3,1]
["Total",{"$f":"SUM(B56:B61)","v":0.75919999999999999},null,null,{"$f":"SUM(E56:E61)","v":1}]
[]
["Ash Content% (Dry Weight Basis) ",2.4E-2]
[]
["Algae Molecular Weight",{"$f":"F56*D56+F57*D57+F58*D58+F59*D59+F60*D60+F61*D61","v":13751.41374}]
[]
[]
["Financial Assumption Inputs"]
["Cost Year",2014]
["Operating Hours Per Year",7920]
["Internal Rate of Return (IRR)",0.1]
["Tax Rate",0.35]
["Equity Financing (Remainder = Debt Financing)",0.4]
["   Loan Interest",0.08]
["   Loan Term, years",10]
["CO2 Price ($/metric ton)",45]

{"sheet":"Results Summary","index":1,"n_rows":46,"n_cols":10,"rows_kept":46,"cut":false,"hidden":false,"merged":[[43,3,43,4],[44,3,44,4],[0,0,0,5],[1,0,1,5],[2,0,2,5],[3,0,3,5],[42,3,42,4]]}
["Algal Biomass Production Process Engineering Analysis"]
[]
[]
[{"$f":"\"All Values in \"&INPUT!B70&\"$\"","v":"All Values in 2014$"},null,null,null,null,null,null,null,null," "]
[null,null,"MBSP (Minimum Biomass Selling Price):",{"$f":"DCFROR!B31","v":494.0318824103901},"/US Dry Ton (AFDW)"]
[null,"Contributions:","CO2 and Nutrients",{"$f":"ROUND(SUM(F18:F20),0)","v":120},{"$f":"\"/US Dry Ton\"","v":"/US Dry Ton"}]
[null,null,"Cultivation ",{"$f":"'Cost Breakdown'!G4+'Cost Breakdown'!G5","v":273.99201130768995},{"$f":"\"/US Dry Ton\"","v":"/US Dry Ton"}]
[null,null,"Other Production ",{"$f":"'Cost Breakdown'!G6+'Cost Breakdown'!G7+'Cost Breakdown'!G8+'Cost Breakdown'!G9","v":99.910854445461723},{"$f":"\"/US Dry Ton\"","v":"/US Dry Ton"}]
[null,null,"Total Biomass Production (AFDW Basis)",{"$f":"OPEX!B3","v":0.18747791960589236},{"$f":"\"MM US Ton/yr\"","v":"MM US Ton/yr"}]
[null,null,"Total Biomass Yield (AFDW Basis)",{"$f":"D9*1000000/INPUT!B10","v":37.495583921178472},{"$f":"\"US Ton/acre/yr\"","v":"US Ton/acre/yr"}]
[null,null,null,{"$f":"D9*1000000*0.9072/(INPUT!B10*0.4047)","v":84.052368997512005},{"$f":"\"Metric tonne/ha/yr\"","v":"Metric tonne/ha/yr"}]
[]
[null,null,"Internal Rate of Return (After-Tax)",{"$f":"INPUT!B72","v":0.1}]
[null,null,"Equity Percent of Total Investment",{"$f":"INPUT!B74","v":0.4}]
[]
[]
["Capital Costs",null,null,"Cost Breakdowns ($/US Ton AFDW Biomass product)"]
[{"$f":"\"Production ponds\"","v":"Production ponds"},{"$f":"CAPEX100","v":155908879.7182858},null,"CO2",null,{"$f":"OPEX!M16","v":97.064575322533486}]
["Inoculum Ponds",{"$f":"CAPEX200","v":15567153.964508031},null,"Ammonia",null,{"$f":"OPEX!M22","v":16.544907281963535}]
["CO2 Delivery",{"$f":"CAPEX300","v":6571607.175287093},null,"Diammonium Phosphate",null,{"$f":"OPEX!M28","v":6.5346278563732962}]
["Makeup Water Delivery + On-Site Circulation",{"$f":"CAPEX400","v":7098111.7640091926},null,"Power",null,{"$f":"OPEX!M40","v":28.089678797000179}]
["Dewatering",{"$f":"CAPEX500","v":42964817.957421519},null,"Chilled Water Utility",null,{"$f":"OPEX!M46","v":3.8480606161057551}]
["Storage",{"$f":"CAPEX600","v":5444624.4039622219},null,"Fixed Costs",null,{"$f":"OPEX!M82","v":61.965126340045757}]
[null,null,null,"Capital Depreciation",null,{"$f":"ROUND(F36/(D9*1000000),0)","v":61}]
["Total Installed Equipment Cost",{"$f":"SUM(B18:B24)","v":233555194.98347384},null,"Average Income Tax",null,{"$f":"ROUND(D5*DCFROR!B78/DCFROR!B79,0)","v":40}]
[null,null,null,"Average Return on Investment",null,{"$f":"ROUND(D5-SUM(F18:F25),0)","v":179}]
["Added Direct + Indirect Costs",{"$f":"B30-B25","v":150444805.01652616}]
["        (% of TCI)",{"$f":"B27/B30","v":0.39178334639720352}]
[null,null,null,"Cost Breakdowns ($/yr)"]
["Total Capital Investment (TCI)",{"$f":"ROUND(DCFROR!O27,-6)","v":384000000},null,"CO2",null,{"$f":"ROUND(OPEX!L16*1000000,-5)","v":18200000}]
[null,null,null,"Ammonia",null,{"$f":"ROUND(OPEX!L22*1000000,-5)","v":3100000}]
["Installed Equipment Cost/Annual US dry ton biomass",{"$f":"ROUND(B25/(D9*1000000),0)","v":1246},null,"Diammonium Phosphate",null,{"$f":"ROUND(OPEX!L28*1000000,-5)","v":1200000}]
["Total Capital Investment/Annual US dry ton biomass",{"$f":"ROUND(B30/(D9*1000000),0)","v":2048},null,"Power",null,{"$f":"ROUND(OPEX!L40*1000000,-5)","v":5300000}]
[null,null,null,"Chilled Water Utility",null,{"$f":"ROUND(OPEX!L46*1000000,-5)","v":700000}]
["Loan Rate",{"$f":"INPUT!B75","v":0.08},null,"Fixed Costs",null,{"$f":"ROUND(OPEX!L82*1000000,-5)","v":11600000}]
["Term (years)",{"$f":"INPUT!B76","v":10},null,"Capital Depreciation",null,{"$f":"ROUND(DCFROR!B4/30,-5)","v":11500000}]
["Capital Charge Factor (Computed)",{"$f":"(F36+F37+F38)/B30","v":0.13697916666666668},null,"Average Income Tax",null,{"$f":"ROUND(F25*(D9*1000000),-5)","v":7500000}]
[null,null,null,"Average Return on Investment",null,{"$f":"ROUND(F26*(D9*1000000),-5)","v":33600000}]
[]
[]
[null,null,null,"Specific Operating Conditions"]
[null,null,null,"Algal Productivity (g/m^2/day)",null,{"$f":"INPUT!F46","v":25.024999999999999}]
[null,null,null,"Maximum seasonal variability (productivity)",null,{"$f":"ROUND((MAX(INPUT!B46:E46)/MIN(INPUT!B46:E46)),0)&\":1\"","v":"3:1"}]
[null,null,null,"CO2 Price ($/US ton)",null,{"$f":"OPEX!I16","v":43.583490678302262}]
[null,null,null,"Facility size (acres, cultivation pond only)",null,{"$f":"INPUT!B10","v":5000}]
[null,null,null,"Total footprint (acres; includes processing, storage, etc.)",null,{"$f":"DCFROR!D4","v":7615}]

{"sheet":"DCFROR","index":2,"n_rows":123,"n_cols":60,"rows_kept":123,"cut":false,"hidden":false,"merged":[[7,6,7,8],[8,6,8,8],[0,11,0,13],[2,6,2,8],[3,6,3,8],[4,6,4,8],[5,6,5,8],[6,6,6,8]]}
[null,null,null,1,null,null,"Total Capital Investment",null,null,null,null,"Installed cost"]
[null,null,null,null,null,null,"Process Area",null,null,"Purchased Cost",null,"Cultivation","Dewatering","OSBL","Installed Cost"]
["Assumptions","Value",null,"Land Requirement",null,null,{"$f":"\"Area 100:  Production\"","v":"Area 100:  Production"},null,null,{"$f":"CAPEX!L11","v":155908879.7182858},null,{"$f":"CAPEX!M11","v":155908879.7182858},null,null,{"$f":"SUM(L3:N3)","v":155908879.7182858}]
["Fixed Capital Investment",{"$f":"O24*D1","v":344018850.04773784},null,{"$f":"INPUT!B10/5000*7615","v":7615},"Acres"," ","Area 200: Inoculum Ponds",null,null,{"$f":"CAPEX!L19","v":15567153.964508031},null,{"$f":"CAPEX!M19","v":15567153.964508031},null,null,15567153.964508031]
["   General Plant",{"$f":"B4-B6","v":344018850.04773784},null,3000,"/acre",null,"Area 300: CO2 Delivery",null,null,{"$f":"CAPEX!L28","v":6174286.882421134},null,null,null,{"$f":"CAPEX!M28","v":6571607.175287093},6571607.175287093]
["   Steam/Power Plant",0,null,null,null,null,"Area 400: Makeup Water Delivery + On-Site Circulation",null,null,{"$f":"CAPEX!L47","v":5343186.1727561001},null,null,null,{"$f":"CAPEX!M47","v":7098111.7640091926},7098111.7640091926]
[null,null,null,null,null,null,"Area 500: Dewatering",null,null,{"$f":"CAPEX!L57","v":40910049.283013806},null,null,{"$f":"CAPEX!M57","v":42964817.957421519},null,42964817.957421519]
["Equity",{"$f":"INPUT!B74","v":0.4},null,null," ",null,"Area 600: Storage",null,null,{"$f":"CAPEX!L64","v":4089312.9665676164},null,null,null,{"$f":"CAPEX!M64","v":5444624.4039622219},5444624.4039622219]
["   Loan Interest",{"$f":"INPUT!B75","v":0.08}]
["   Loan Term, years",{"$f":"INPUT!B76","v":10}]
["   Annual Loan Payment",{"$f":"-PMT(B9,B10,FCI*(1-B8))","v":30761371.994862132}]
["Working Capital (% of FCI)",0.05,null,null,null,null,"Totals (Excl. Area 100)",null,null,{"$f":"SUM(J3:J11)","v":227992868.98755249},null,{"$f":"SUM(L3:L11)","v":171476033.68279383},{"$f":"SUM(M3:M11)","v":42964817.957421519},{"$f":"SUM(N3:N11)","v":19114343.343258508},{"$f":"SUM(L12:N12)","v":233555194.98347384}]
["Salvage Value",null,null,null,null,null,null,null,"Standard factors","Cultivation Factors","OSBL Factors",null,null,null,{"$f":"SUM(L13:N13)","v":0}]
["   General Plant",0,"Not permitted since 2002",null,null,null,"   Warehouse",null,0.04,1.2200000000000001E-2,0,{"$f":"J14*L12","v":2092007.6109300847},{"$f":"I14*M12","v":1718592.7182968608},{"$f":"K14*$N$12","v":0},3810600.3292269455]
["   Steam Plant",0,"Not permitted since 2002",null,null,null,"   Site Development",null,0.09,"Included in pond cost"," $1534/acre",null,{"$f":"I15*M12","v":3866833.6161679365},{"$f":"1534*D4","v":11681410},15548243.616167936]
["Depreciation Period (Years)","MACR (IRS publication 946, Table A1, Page 76.  http://www.irs.gov/pub/irs-pdf/p946.pdf )",null,null,null,null,"   Additional Piping",null,4.4999999999999998E-2,"Included in pond cost",0,null,{"$f":"I16*M12","v":1933416.8080839682},{"$f":"K16*$N$12","v":0},1933416.8080839682]
["   General Plant",7,"IRS Pub 946",null,null,null,"Total Direct Costs (TDC)",null,null,null,null,{"$f":"SUM(L12:L16)","v":173568041.29372391},{"$f":"SUM(M12:M16)","v":50483661.099970281},{"$f":"SUM(N12:N16)","v":30795753.343258508},254847455.73695269]
["   Steam/Electricity System",20,"IRS Pub 946",null,null,null,"   Prorateable Expenses",null,0.1,0.04,0.01,{"$f":"J18*$L$17","v":6942721.6517489562},{"$f":"I18*$M$17","v":5048366.1099970285},{"$f":"K18*$N$17","v":307957.53343258507},12299045.29517857]
["Construction Period (Years)",3,null,null,null,null,"   Field Expenses",null,0.1,4.4600000000000001E-2,0.01,{"$f":"J19*$L$17","v":7741134.6417000862},{"$f":"I19*$M$17","v":5048366.1099970285},{"$f":"K19*$N$17","v":307957.53343258507},13097458.2851297]
["   % Spent in Year -2",0.08,null,null,null,null,"   Home Office & Construction Fee",null,0.2,0.10340000000000001,0.01,{"$f":"J20*$L$17","v":17946935.469771054},{"$f":"I20*$M$17","v":10096732.219994057},{"$f":"K20*$N$17","v":307957.53343258507},28351625.223197695]
["   % Spent in Year -1",0.6,null,null,null,null,"   Project Contingency",null,0.1,0.1,0.1,{"$f":"J21*$L$17","v":17356804.129372392},{"$f":"I21*$M$17","v":5048366.1099970285},{"$f":"K21*$N$17","v":3079575.3343258509},25484745.573695272]
["   % Spent in Year 0",{"$f":"1-SUM(B20:B21)","v":0.32000000000000006},null,null,null,null,"   Other Costs (Start-Up, Permits, etc.)",null,0.1,2.64E-2,0.01,{"$f":"J22*$L$17","v":4582196.2901543109},{"$f":"I22*$M$17","v":5048366.1099970285},{"$f":"K22*$N$17","v":307957.53343258507},9938519.9335839227]
["Start-up Time (Years)",0.5,null,null,null,null,"Total Indirect Costs",null,null,null,null,{"$f":"SUM(L18:L22)","v":54569792.182746798},{"$f":"SUM(M18:M22)","v":30290196.659982167},{"$f":"SUM(N18:N22)","v":4311405.4680561908},89171394.310785159]
["  Algal Production/Dewatering (% of Normal)",0.5,null,null,null,null,"Fixed Capital Investment (FCI)",null,null,null,null,{"$f":"L17+L23","v":228137833.47647071},{"$f":"M17+M23","v":80773857.759952456},{"$f":"N17+N23","v":35107158.811314702},344018850.04773784]
["  Variable Costs (% of Normal)",0.75,null,null,null,null,"   Land",null,null,null,null,null,null,null,{"$f":"D4*D5","v":22845000}]
["  Fixed Cost (% of Normal)",1,null,null,null,null,"   Working Capital",null,{"$f":"B12","v":0.05},"of FCI",null,null,null,null,{"$f":"I26*O24","v":17200942.502386894}]
["Discount Rate (Internal Rate of Return [IRR])",{"$f":"INPUT!B72","v":0.1},"Short et. al",null,null,null,"Total Capital Investment (TCI)",null,null,null,null,null,null,null,{"$f":"FCI+O26+O25","v":384064792.5501247}]
["Income Tax Rate",{"$f":"INPUT!B73","v":0.35}]
["Biomass Production Rate (MM US Dry Ton/yr)",{"$f":"OPEX!B3","v":0.18747791960589236},"Mass balances",null,null,null,"Lang Factor (FCI/Purchased Equip Cost)",null,null,null,null,null,null,null,{"$f":"O24/J12","v":1.5089017984440554}]
["Cost Year for Analysis",{"$f":"INPUT!B70","v":2014}]
["Minimum Biomass Selling Price ($/US Dry Ton)",494.0318824103901,"Manipulated Value"]
["Minimum Biomass Selling Price ($/kg)",{"$f":"B31*2.205/2000","v":0.54467015035745514},null,null,null,null,{"$f":"DCFROR!$B$30&\" Dollars\"","v":"2014 Dollars"}]
["Net Present Value",{"$f":"E70","v":0},"Targeted Value"]
[]
[]
[]
[]
[]
["DCFROR Worksheet"]
["Year",null,-2,-1,0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30]
["Fixed Capital Investment",null,{"$f":"FCI*B20*B8","v":11008603.20152761},{"$f":"FCI*B21*B8","v":82564524.011457086},{"$f":"FCI*B22*B8","v":44034412.806110457}]
["Land",null,{"$f":"O25","v":22845000},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"-C42","v":-22845000}]
["Working Capital"," ",null,null,{"$f":"B12*B4","v":17200942.502386894},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"-E43","v":-17200942.502386894}]
["Loan Payment",null,null,null,null,{"$f":"B11","v":30761371.994862132},{"$f":"IF($B$10>1,$B$11,0)","v":30761371.994862132},{"$f":"IF($B$10>2,$B$11,0)","v":30761371.994862132},{"$f":"IF($B$10>3,$B$11,0)","v":30761371.994862132},{"$f":"IF($B$10>4,$B$11,0)","v":30761371.994862132},{"$f":"IF($B$10>5,$B$11,0)","v":30761371.994862132},{"$f":"IF($B$10>6,$B$11,0)","v":30761371.994862132},{"$f":"IF($B$10>7,$B$11,0)","v":30761371.994862132},{"$f":"IF($B$10>8,$B$11,0)","v":30761371.994862132},{"$f":"IF($B$10>9,$B$11,0)","v":30761371.994862132},{"$f":"IF($B$10>10,$B$11,0)","v":0},{"$f":"IF($B$10>11,$B$11,0)","v":0},{"$f":"IF($B$10>12,$B$11,0)","v":0},{"$f":"IF($B$10>13,$B$11,0)","v":0},{"$f":"IF($B$10>14,$B$11,0)","v":0},{"$f":"IF($B$10>15,$B$11,0)","v":0},{"$f":"IF($B$10>16,$B$11,0)","v":0},{"$f":"IF($B$10>17,$B$11,0)","v":0},{"$f":"IF($B$10>18,$B$11,0)","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"IF($B$10>19,$B$11,0)","v":0}]
["   Loan Interest Payment",null,{"$f":"$B$9*C46","v":1321032.3841833132},{"$f":"$B$9*D46","v":11228775.265558163},{"$f":"$B$9*E46","v":16512904.802291416},{"$f":"B4*(1-B8)*B9","v":16512904.802291416},{"$f":"$B$9*F46","v":15373027.426885758},14141959.861447647,12812406.890774488,11376489.682447476,9825699.0974543039,8150845.2656616783,6342003.127325641,4388453.6179227214,2278620.1477675689,3.7997961044311524E-9,4.1037797927856442E-9,4.4320821762084957E-9,4.7866487503051757E-9,5.1695806503295906E-9,5.5831471023559576E-9,6.0297988705444347E-9,6.5121827801879889E-9,7.0331574026030279E-9,7.5958099948112694E-9,8.2034747943961722E-9,8.8597527779478663E-9,9.5685330001836949E-9,1.033401564019839E-8,1.1160736891414263E-8,1.2053595842727404E-8,1.3017883510145596E-8,1.4059314190957245E-8,1.5184059326233821E-8,{"$f":"$B$9*X46","v":7.5958099948112694E-9}]
["   Loan Principal",null,{"$f":"FCI*(1-B8)*B20","v":16512904.802291416},{"$f":"FCI*(1-B8)*B21+C46","v":140359690.81947702},{"$f":"FCI*(1-B8)*B22+D46","v":206411310.02864268},{"$f":"FCI*(1-B8)-F44+F45","v":192162842.83607197},{"$f":"F46-G44+G45","v":176774498.26809558},{"$f":"G46-H44+H45","v":160155086.13468111},142206121.03059345,122821238.71817879,101885565.82077098,79275039.091570511,54855670.224034019,28482751.84709461,4.7497451305389404E-8,5.1297247409820555E-8,5.5401027202606198E-8,5.9833109378814696E-8,6.4619758129119877E-8,6.9789338779449471E-8,7.537248588180543E-8,8.1402284752349859E-8,8.7914467532537848E-8,9.4947624935140875E-8,1.0254343492995215E-7,1.1074690972434832E-7,1.1960666250229619E-7,1.2917519550247989E-7,1.3950921114267829E-7,1.5066994803409256E-7,1.6272354387681995E-7,1.7574142738696555E-7,1.8980074157792278E-7,2.0498480090415661E-7,{"$f":"X46-AI44+AI45","v":1.0254343492995215E-7}]
["   Algal Biomass Sales"," "," "," "," ",{"$f":"($B$29*$B$31*1000000)*(1-B23)+($B$29*$B$31*1000000)*B23*B24","v":69465052.149962097},{"$f":"$B$29*$B$31*1000000","v":92620069.533282787},92620069.533282787,92620069.533282787,92620069.533282787,92620069.533282787,92620069.533282787,92620069.533282787,92620069.533282787,92620069.533282787,92620069.533282787,92620069.533282787,92620069.533282787,92620069.533282787,92620069.533282787,92620069.533282787,92620069.533282787,92620069.533282787,92620069.533282787,92620069.533282787,92620069.533282787,92620069.533282787,92620069.533282787,92620069.533282787,92620069.533282787,92620069.533282787,92620069.533282787,92620069.533282787,92620069.533282787,92620069.533282787]
["   By-Product Credit"," "," "," "," ",{"$f":"(OPEX!L58*1000000)*(1-B23)+(OPEX!L58*1000000)*B23*B24","v":0},{"$f":"OPEX!$L$58*1000000","v":0},{"$f":"OPEX!$L$58*1000000","v":0},{"$f":"OPEX!$L$58*1000000","v":0},{"$f":"OPEX!$L$58*1000000","v":0},{"$f":"OPEX!$L$58*1000000","v":0},{"$f":"OPEX!$L$58*1000000","v":0},{"$f":"OPEX!$L$58*1000000","v":0},{"$f":"OPEX!$L$58*1000000","v":0},{"$f":"OPEX!$L$58*1000000","v":0},{"$f":"OPEX!$L$58*1000000","v":0},{"$f":"OPEX!$L$58*1000000","v":0},{"$f":"OPEX!$L$58*1000000","v":0},{"$f":"OPEX!$L$58*1000000","v":0},{"$f":"OPEX!$L$58*1000000","v":0},{"$f":"OPEX!$L$58*1000000","v":0},{"$f":"OPEX!$L$58*1000000","v":0},{"$f":"OPEX!$L$58*1000000","v":0},{"$f":"OPEX!$L$58*1000000","v":0},{"$f":"OPEX!$L$58*1000000","v":0},{"$f":"OPEX!$L$58*1000000","v":0},{"$f":"OPEX!$L$58*1000000","v":0},{"$f":"OPEX!$L$58*1000000","v":0},{"$f":"OPEX!$L$58*1000000","v":0},{"$f":"OPEX!$L$58*1000000","v":0},{"$f":"OPEX!$L$58*1000000","v":0},{"$f":"OPEX!$L$58*1000000","v":0},{"$f":"OPEX!$L$58*1000000","v":0},{"$f":"OPEX!$L$58*1000000","v":0},{"$f":"OPEX!$L$58*1000000","v":0}]
["Total Annual Sales",null,null,null,null,{"$f":"F47+F48","v":69465052.149962097},{"$f":"G47+G48","v":92620069.533282787},92620069.533282787,92620069.533282787,92620069.533282787,92620069.533282787,92620069.533282787,92620069.533282787,92620069.533282787,92620069.533282787,92620069.533282787,92620069.533282787,92620069.533282787,92620069.533282787,92620069.533282787,92620069.533282787,92620069.533282787,92620069.533282787,92620069.533282787,92620069.533282787,92620069.533282787,92620069.533282787,92620069.533282787,92620069.533282787,92620069.533282787,92620069.533282787,92620069.533282787,92620069.533282787,92620069.533282787,92620069.533282787]
["Annual Manufacturing Cost"]
["CO2 Cost",null,null,null,null,{"$f":"(OPEX!L16*1000000)*(1-B23)+(OPEX!L16*1000000)*(B23)*B24","v":13648098.486673512},{"$f":"OPEX!$L$16*1000000","v":18197464.648898017},{"$f":"OPEX!$L$16*1000000","v":18197464.648898017},{"$f":"OPEX!$L$16*1000000","v":18197464.648898017},{"$f":"OPEX!$L$16*1000000","v":18197464.648898017},{"$f":"OPEX!$L$16*1000000","v":18197464.648898017},{"$f":"OPEX!$L$16*1000000","v":18197464.648898017},{"$f":"OPEX!$L$16*1000000","v":18197464.648898017},{"$f":"OPEX!$L$16*1000000","v":18197464.648898017},{"$f":"OPEX!$L$16*1000000","v":18197464.648898017},{"$f":"OPEX!$L$16*1000000","v":18197464.648898017},{"$f":"OPEX!$L$16*1000000","v":18197464.648898017},{"$f":"OPEX!$L$16*1000000","v":18197464.648898017},{"$f":"OPEX!$L$16*1000000","v":18197464.648898017},{"$f":"OPEX!$L$16*1000000","v":18197464.648898017},{"$f":"OPEX!$L$16*1000000","v":18197464.648898017},{"$f":"OPEX!$L$16*1000000","v":18197464.648898017},{"$f":"OPEX!$L$16*1000000","v":18197464.648898017},{"$f":"OPEX!$L$16*1000000","v":18197464.648898017},{"$f":"OPEX!$L$16*1000000","v":18197464.648898017},{"$f":"OPEX!$L$16*1000000","v":18197464.648898017},{"$f":"OPEX!$L$16*1000000","v":18197464.648898017},{"$f":"OPEX!$L$16*1000000","v":18197464.648898017},{"$f":"OPEX!$L$16*1000000","v":18197464.648898017},{"$f":"OPEX!$L$16*1000000","v":18197464.648898017},{"$f":"OPEX!$L$16*1000000","v":18197464.648898017},{"$f":"OPEX!$L$16*1000000","v":18197464.648898017},{"$f":"OPEX!$L$16*1000000","v":18197464.648898017},{"$f":"OPEX!$L$16*1000000","v":18197464.648898017},{"$f":"OPEX!$L$16*1000000","v":18197464.648898017}," "," "," ",null," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "]
["   Other Variable Costs",null,null,null,null,{"$f":"(((OPEX!L59-OPEX!L16)*1000000)*(1-B23))+((OPEX!L59-OPEX!L16)*1000000)*B23*B25","v":9025208.6533793565},{"$f":"(OPEX!$L$59-OPEX!$L$16)*1000000","v":10314524.175290693},{"$f":"(OPEX!$L$59-OPEX!$L$16)*1000000","v":10314524.175290693},{"$f":"(OPEX!$L$59-OPEX!$L$16)*1000000","v":10314524.175290693},{"$f":"(OPEX!$L$59-OPEX!$L$16)*1000000","v":10314524.175290693},{"$f":"(OPEX!$L$59-OPEX!$L$16)*1000000","v":10314524.175290693},{"$f":"(OPEX!$L$59-OPEX!$L$16)*1000000","v":10314524.175290693},{"$f":"(OPEX!$L$59-OPEX!$L$16)*1000000","v":10314524.175290693},{"$f":"(OPEX!$L$59-OPEX!$L$16)*1000000","v":10314524.175290693},{"$f":"(OPEX!$L$59-OPEX!$L$16)*1000000","v":10314524.175290693},{"$f":"(OPEX!$L$59-OPEX!$L$16)*1000000","v":10314524.175290693},{"$f":"(OPEX!$L$59-OPEX!$L$16)*1000000","v":10314524.175290693},{"$f":"(OPEX!$L$59-OPEX!$L$16)*1000000","v":10314524.175290693},{"$f":"(OPEX!$L$59-OPEX!$L$16)*1000000","v":10314524.175290693},{"$f":"(OPEX!$L$59-OPEX!$L$16)*1000000","v":10314524.175290693},{"$f":"(OPEX!$L$59-OPEX!$L$16)*1000000","v":10314524.175290693},{"$f":"(OPEX!$L$59-OPEX!$L$16)*1000000","v":10314524.175290693},{"$f":"(OPEX!$L$59-OPEX!$L$16)*1000000","v":10314524.175290693},{"$f":"(OPEX!$L$59-OPEX!$L$16)*1000000","v":10314524.175290693},{"$f":"(OPEX!$L$59-OPEX!$L$16)*1000000","v":10314524.175290693},{"$f":"(OPEX!$L$59-OPEX!$L$16)*1000000","v":10314524.175290693},{"$f":"(OPEX!$L$59-OPEX!$L$16)*1000000","v":10314524.175290693},{"$f":"(OPEX!$L$59-OPEX!$L$16)*1000000","v":10314524.175290693},{"$f":"(OPEX!$L$59-OPEX!$L$16)*1000000","v":10314524.175290693},{"$f":"(OPEX!$L$59-OPEX!$L$16)*1000000","v":10314524.175290693},{"$f":"(OPEX!$L$59-OPEX!$L$16)*1000000","v":10314524.175290693},{"$f":"(OPEX!$L$59-OPEX!$L$16)*1000000","v":10314524.175290693},{"$f":"(OPEX!$L$59-OPEX!$L$16)*1000000","v":10314524.175290693},{"$f":"(OPEX!$L$59-OPEX!$L$16)*1000000","v":10314524.175290693},{"$f":"(OPEX!$L$59-OPEX!$L$16)*1000000","v":10314524.175290693}]
["   Fixed Operating Costs",null,null,null,null,{"$f":"(OPEX!L82*1000000)*(1-B23)+(OPEX!L82*1000000)*B23*B26","v":11617092.974348059},{"$f":"OPEX!$L$82*1000000","v":11617092.974348059},{"$f":"OPEX!$L$82*1000000","v":11617092.974348059},{"$f":"OPEX!$L$82*1000000","v":11617092.974348059},{"$f":"OPEX!$L$82*1000000","v":11617092.974348059},{"$f":"OPEX!$L$82*1000000","v":11617092.974348059},{"$f":"OPEX!$L$82*1000000","v":11617092.974348059},{"$f":"OPEX!$L$82*1000000","v":11617092.974348059},{"$f":"OPEX!$L$82*1000000","v":11617092.974348059},{"$f":"OPEX!$L$82*1000000","v":11617092.974348059},{"$f":"OPEX!$L$82*1000000","v":11617092.974348059},{"$f":"OPEX!$L$82*1000000","v":11617092.974348059},{"$f":"OPEX!$L$82*1000000","v":11617092.974348059},{"$f":"OPEX!$L$82*1000000","v":11617092.974348059},{"$f":"OPEX!$L$82*1000000","v":11617092.974348059},{"$f":"OPEX!$L$82*1000000","v":11617092.974348059},{"$f":"OPEX!$L$82*1000000","v":11617092.974348059},{"$f":"OPEX!$L$82*1000000","v":11617092.974348059},{"$f":"OPEX!$L$82*1000000","v":11617092.974348059},{"$f":"OPEX!$L$82*1000000","v":11617092.974348059},{"$f":"OPEX!$L$82*1000000","v":11617092.974348059},{"$f":"OPEX!$L$82*1000000","v":11617092.974348059},{"$f":"OPEX!$L$82*1000000","v":11617092.974348059},{"$f":"OPEX!$L$82*1000000","v":11617092.974348059},{"$f":"OPEX!$L$82*1000000","v":11617092.974348059},{"$f":"OPEX!$L$82*1000000","v":11617092.974348059},{"$f":"OPEX!$L$82*1000000","v":11617092.974348059},{"$f":"OPEX!$L$82*1000000","v":11617092.974348059},{"$f":"OPEX!$L$82*1000000","v":11617092.974348059},{"$f":"OPEX!$L$82*1000000","v":11617092.974348059}]
["Total Product Cost",null,null,null,null,{"$f":"SUM(F51:F53)","v":34290400.114400931},40129081.79853677,40129081.79853677,40129081.79853677,40129081.79853677,40129081.79853677,40129081.79853677,40129081.79853677,40129081.79853677,40129081.79853677,40129081.79853677,40129081.79853677,40129081.79853677,40129081.79853677,40129081.79853677,40129081.79853677,40129081.79853677,40129081.79853677,40129081.79853677,40129081.79853677,40129081.79853677,40129081.79853677,40129081.79853677,40129081.79853677,40129081.79853677,40129081.79853677,40129081.79853677,40129081.79853677,40129081.79853677,40129081.79853677]
["Annual Depreciation"]
["General Plant Writedown",null,null,null,null,0.1429,0.24490000000000001,0.1749,0.1249,8.9300000000000004E-2,8.9200000000000002E-2,8.9300000000000004E-2,4.4600000000000001E-2]
["     Depreciation Charge",null,null,null,null,{"$f":"$B$5*F56","v":49160293.671821736},{"$f":"$B$5*G56","v":84250216.376690999},60168896.873349346,42967954.370962456,30720883.309262991,30686481.424258217,30720883.309262991,15343240.712129109]
["     Remaining Value",null,null,null,null,{"$f":"$B$5-$B$14-F57","v":294858556.37591612},{"$f":"F58-G57","v":210608339.99922514},150439443.1258758,107471488.75491334,76750605.445650354,46064124.021392137,15343240.712129146,3.7252902984619141E-8]
["Steam Plant Writedown",null,null,null,null,3.7499999999999999E-2,7.2190000000000004E-2,6.6769999999999996E-2,6.1769999999999999E-2,5.713E-2,5.2850000000000001E-2,4.888E-2,4.5220000000000003E-2,4.462E-2,4.4609999999999997E-2,4.462E-2,4.4609999999999997E-2,4.462E-2,4.4609999999999997E-2,4.462E-2,4.4609999999999997E-2,4.462E-2,4.4609999999999997E-2,4.462E-2,4.4609999999999997E-2,2.231E-2]
["     Depreciation Charge",null,null,null,null,{"$f":"$B$6*F59","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["     Remaining Value",null,null,null,null,{"$f":"B6-B15-F60","v":0},{"$f":"F61-G60","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Net Revenue",null,null,null,null,{"$f":"F49-F54-F57-F60-F45","v":-30498546.438551985},-47132256.068830743,-21819869.000050977,-3289373.5269909278,10393614.743035549,11978807.213033495,13619259.159821346,30805743.895291269,48102534.116823293,50212367.58697845,52490987.734746009,52490987.734746009,52490987.734746009,52490987.734746009,52490987.734746009,52490987.734746009,52490987.734746009,52490987.734746009,52490987.734746009,52490987.734746009,52490987.734746009,52490987.734746009,52490987.734746009,52490987.734746009,52490987.734746009,52490987.734746002,52490987.734746002,52490987.734746002,52490987.734746002,52490987.734746009]
["Losses Forward",null,null,null,null,null,{"$f":"IF(F64<0,F64,0)","v":-30498546.438551985},-77630802.507382721,-99450671.507433698,-102740045.03442463,-92346430.291389078,-80367623.078355581,-66748363.918534234,-35942620.023242965,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(X64<0,X64,0)","v":0}]
["Taxable Income",null,null,null,null,{"$f":"F62+F63","v":-30498546.438551985},-77630802.507382721,-99450671.507433698,-102740045.03442463,-92346430.291389078,-80367623.078355581,-66748363.918534234,-35942620.023242965,12159914.093580328,50212367.58697845,52490987.734746009,52490987.734746009,52490987.734746009,52490987.734746009,52490987.734746009,52490987.734746009,52490987.734746009,52490987.734746009,52490987.734746009,52490987.734746009,52490987.734746009,52490987.734746009,52490987.734746009,52490987.734746009,52490987.734746009,52490987.734746002,52490987.734746002,52490987.734746002,52490987.734746002,52490987.734746009]
["Income Tax",null,null,null,null,{"$f":"IF(F64*($B$28)<0,0,F64*$B$28)","v":0},0,0,0,0,0,0,0,4255969.932753115,17574328.655442458,18371845.707161102,18371845.707161102,18371845.707161102,18371845.707161102,18371845.707161102,18371845.707161102,18371845.707161102,18371845.707161102,18371845.707161102,18371845.707161102,18371845.707161102,18371845.707161102,18371845.707161102,18371845.707161102,18371845.707161102,18371845.707161099,18371845.707161099,18371845.707161099,18371845.707161099,18371845.707161102]
["Annual Cash Income",null,null,null,null,{"$f":"F49-F54-F65-F44","v":4413280.0406990349},21729615.739883885,21729615.739883885,21729615.739883885,21729615.739883885,21729615.739883885,21729615.739883885,21729615.739883885,17473645.807130769,4155287.0844414309,34119142.02758491,34119142.02758491,34119142.02758491,34119142.02758491,34119142.02758491,34119142.02758491,34119142.02758491,34119142.02758491,34119142.02758491,34119142.02758491,34119142.02758491,34119142.02758491,34119142.02758491,34119142.02758491,34119142.02758491,34119142.027584918,34119142.027584918,34119142.027584918,34119142.027584918,34119142.02758491]
["Discount Factor",null,{"$f":"1/(1+$B$27)^C40","v":1.2100000000000002},1.1000000000000001,1,0.90909090909090906,0.82644628099173545,0.75131480090157754,0.68301345536507052,0.62092132305915493,0.56447393005377722,0.51315811823070645,0.46650738020973315,0.42409761837248466,0.38554328942953148,0.3504938994813922,0.31863081771035656,0.28966437973668779,0.26333125430607973,0.23939204936916339,0.21762913579014853,0.19784466890013502,0.17985878990921364,0.16350799082655781,0.14864362802414349,0.13513057093103953,0.12284597357367227,0.11167815779424752,0.10152559799477048,9.2295998177064048E-2,8.3905452888240042E-2,7.6277684443854576E-2,6.9343349494413245E-2,6.3039408631284766E-2,5.7308553301167964E-2]
["Annual Present Value",{"$f":"SUM(F68:AI68)","v":221187223.34382224},null,null,null,{"$f":"F67*F66","v":4012072.7642718498},17958360.115606513,16325781.923278647,14841619.930253316,13492381.75477574,12265801.595250672,11150728.722955154,10137026.111777414,7410531.5710885115,1602043.0510595965,11958551.13620769,10871410.123825174,9883100.1125683393,8984636.4659712147,8167851.3327011047,7425319.39336464,6750290.3576042177,6136627.5978220161,5578752.3616563771,5071593.0560512524,4610539.1418647747,4191399.219877067,3810362.9271609699,3463966.2974190637,3149060.2703809664,2862782.0639826972,2602529.1490751789,2365935.5900683445,2150850.5364257675,1955318.6694779699]
["Total Capital Investment + Interest",null,{"$f":"(C41+C42+C45)*C67","v":42561309.058710217},{"$f":"(D41+D45)*D67","v":103172629.20471679},{"$f":"(E41+E45+E43)*E67","v":77748260.110788763},null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(AI41+AI45+AI43+AI42)*AI67","v":-2294975.0303935464}]
["Net Present Worth",null,null,null,{"$f":"B68-SUM(B69:AI69)","v":0}]
[]
[null,null,null,null,null,null," "]
[null,null,null,null,null,"If taxable income < 0, tax = $0"]
[null,null,null,null,null,"Loan Interest subtracted from taxable income."]
[null,null,null,null,null,"Loan payment subtracted from annual cash income"]
[null,null,null,null,null,"Interest on construction loan added to investment"]
[null,null,null,null,null,null," "]
["NPV of Income Tax",{"$f":"SUM(F78:AI78)","v":68883390.470490739},null,null,null,{"$f":"F65*F67","v":0},0,0,0,0,0,0,0,1804946.7123454998,6775664.4793349598,6439219.8425733699,5853836.2205212461,5321669.2913829507,4837881.1739844996,4398073.7945313631,3998248.9041194208,3634771.7310176552,3304337.9372887774,3003943.5793534331,2730857.7994122123,2482597.9994656476,2256907.2722414974,2051733.8838559063,1865212.621687188,1695647.837897443,1541498.0344522207,1401361.8495020187,1273965.3177291078,1158150.2888446434,1052863.898949676]
["NPV of Algal Biomass Income",{"$f":"SUM(F79:AI79)","v":852071457.61374807},null,null,null,{"$f":"F47*F67","v":63150047.409056447},76545512.010977507,69586829.100888625,63260753.728080571,57509776.116436876,52281614.651306249,47528740.592096582,43207945.992815077,39279950.902559154,35709046.275053777,32462769.340957973,29511608.491779976,26828734.992527254,24389759.084115677,22172508.258286979,20156825.689351797,18324386.990319815,16658533.627563467,15144121.479603149,13767383.163275592,12515802.875705082,11378002.614277346,10343638.740252132,9403307.9456837568,8548461.768803414,7771328.8807303756,7064844.4370276136,6422585.8518432844,5838714.4107666221,5307922.1916060196]
[]
[null,null,null,null,null,null," "]
[null,{"$f":"B78/B79","v":8.0842269571381672E-2},null,null,null,null," "]
[null,null,null,null,null,null," "]
[null,null,null,null,null,null," "]
[null,null,null,null,null,null," "]
[null,null,null,null,null,null," "]
[null,null,null,null,null,null," "]
[null,null,null,null,null,null," "]
[null,null,null,null,null,null," "]
[null,null,null,null,null,null," "]
[null,null,null,null,null,null," "]
[null,null,null,null,null,null," "]
[null,null,null,null,null,null," "]
[null,null,null,null,null,null," "]
[null,null,null,null,null,null," "]
[null,null,null,null,null,null," "]
[null,null,null,null,null,null," "]
[null,null,null,null,null,null," "]
[null,null,null,null,null,null," "]
[null,null,null,null,null,null," "]
[null,null,null,null,null,null," "]
[null,null,null,null,null,null," "]
[null,null,null,null,null,null," "]
[null,null,null,null,null,null," "]
[null,null,null,null,null,null," "]
[null,null,null,null,null,null," "]
[null,null,null,null,null,null," "]
[null,null,null,null,null,null," "]
[null,null,null,null,null,null," "]
[null,null,null,null,null,null," "]
[null,null,null,null,null,null," "]
[null,null,null,null,null,null," "]
[null,null,null,null,null,null," "]
[null,null,null,null,null,null," "]
[null,null,null,null,null,null," "]
[null,null,null,null,null,null," "]
[null,null,null,null,null,null," "]
[null,null,null,null,null,null," "]
[null,null,null,null,null,null," "]
[null,null,null,null,null,null," "]
[null,null,null,null,null,null," "]
[null,null,null,null,null,null," "]
[null,null,null,null,null,null," "]

{"sheet":"Mass Balance","index":3,"n_rows":156,"n_cols":44,"rows_kept":156,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"FLOW DIAGRAM"]
[null,null,"(note, this is only an overall schematic of the process, beyond individual processing equipment, pumps, piping, etc)",null,null,null,null,null,null,null,null,null,null,null,null," "]
[]
[null,null,null,null,null,{"$f":"C61*2.205/2000*24","v":11.002491791972481},"ton/day NH3",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"a"]
[null,null,null,null,null,{"$f":"C62*2.205/2000*24","v":5.3482210411043205},"ton/day DAP"]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"H67*2.205/2000*24","v":19464.005491875003},"ton/day Water",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"U56/2000*2.205*24","v":2879.3364216935061},null,null,"ton/day"]
[null,null,null,null,null,null,null,null,null,{"$f":"H56*2.205/2000*24-J8","v":1076.5861192815428},"ton/day Other",null,null,null,null,{"$f":"R56/2000*2.205*24","v":6931.40854414368},"ton/day"]
[]
[null,null,null,null,null,{"$f":"D56*2.205/2000*24","v":29047.786966921725},"ton/day"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"F56/2000*2.205*24","v":1255836.6091915597},"ton/day"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"S56/2000*2.205*24","v":59517.016260111399},"ton/day"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"T56*2.205/2000*24","v":2885.1316087390314},"ton/day"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"P56/2000*2.205*24","v":1321276.3527139523},"ton/day"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"I56*2.205/2000*24","v":56631.941303994696},"ton/day"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"V56*2.205*24/2000","v":5.7951870455253536},null,"ton/day"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"G56*2.205/2000*24","v":1230.8046677352174},"ton/day"]
[null,null,null,null,{"$f":"E69*2.205/2000*24","v":15.950445761249998},"ton/day Algae (AFDW)"]
[null,null,null,null,{"$f":"E56*2.205/2000*24-E28","v":32.51111745357106},"ton/day Other"]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"M56*2.205/2000*24","v":34.44121806164695},"ton/day",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AJ56","v":287.00028288631233},"kW"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AD56+AE56+AF56+AG56","v":632.19159959100091},"kW"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"POWER BALANCE"]
[null,null,null,null,{"$f":"K61*2.205/2000*24","v":0.39507848528435496},"ton/day NH3"]
[null,null,null,null,{"$f":"K62*2.205/2000*24","v":0.17019305266198415},"ton/day DAP",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Z56+AA56+AB56+AH56","v":6818.4214759076503},"kW"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AC56","v":195.18712374603174},"kW",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AK56","v":9749.6122205547763},"kW"]
[]
[null,null,null,null,null,null,null,{"$f":"L56*2.205/2000*24","v":487.98937745924491},"ton/day",null,null,null,null,null,null,{"$f":"O56*2.205/2000*24","v":1265.2458857968645},"ton/day"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AI56","v":1816.8117384237817},"kW"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Yearly Average ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yearly Average Power Usage"]
[null,null,100,110,120,130,140,150,160,null,200,210,220,230,300,500,null,510,520,600,610,620,null,null,null,"W-101","W-102","W-103","W-201","W-501","W-502","W-503","W-504","W-104","W-301","W-401","W-Total"]
["Component","Units","Nutrients","Makup Water","Inoculum Algae","Clarified Water","CO2","Evaporation","Recycle Water","Total Inlet Into Area 100","Nutrients","Make-up Water","CO2","Evaporation","CO2 (From outside of Facility)","Algae to Settlers","Clarified Water to Blowdown","Blowdown","Algae","Algae Product","Algae Product","Storage Loss",null,null,null,"Paddlewheel Mixing","Pump to Settlers ","Clarified Water Pump","Inoculum Power","Pump from Settler to Membranes","Membrane Power Requirement","Pump from Membrane to Centrifuge","Centrifuge Power","Pump Return from Central Dewatering","CO2 Heating Power","Make-up Water Pump ","Total"]
["Total Flow","kg/hr",{"$f":"AVERAGE(C77,C98,C119,C140)","v":617.94077222512465},{"$f":"AVERAGE(D77,D98,D119,D140)","v":1097799.9609569812},1831.5027670000395,47461701.027647756,46515.671494150316,776288.42067862977,2140285.0077095502,50748751.111747093,21.363247843776989,18442.531272080305,1301.6333356631501,17948.848371886372,47817.304829813467,49934858.379212096,47723659.02251336,261957.99486559635,2249320.3424078384,109037.47576489158,108818.45886974702,219.01689514457121,null,null,"kW",{"$f":"AVERAGE(Z77,Z98,Z119,Z140)","v":4641.2456243297383},945.2254406770744,838.51660213320042,195.18712374603174,289.94410318147084,89.972813696313523,2.8932779672649032,249.38140474595161,393.43380876763717,1816.8117384237817,287.00028288631233,9749.6122205547763]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Chiller Utility GJ/hr",null,null,null,{"$f":"AVERAGE(AC78,AC99,AC120,AC141)","v":16.877483188658399}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Electricity usage by AREA (kW)",null,null,null,null,"kW"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Area 100:  Production Pond",null,null,null,null,{"$f":"Z56+AA56+AB56","v":6424.9876671400134}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Area 200: Inoculum Ponds",null,null,null,null,{"$f":"AC56","v":195.18712374603174}]
["Ammonia","kg/hr",{"$f":"AVERAGE(C82,C103,C124,C145)","v":415.81601632549058},{"$f":"AVERAGE(D82,D103,D124,D145)","v":0},2.9862319371455395,99.313634780349872,0,0,4.4747059574836143,522.59058900046966,14.931159685727703,0,0,0,0,104.5181178000939,99.861835652099714,0.54820087174982879,4.6562821479941832,0.18157619051056914,0.18157619051056914,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Area 300: CO2 Delivery",null,null,null,null,{"$f":"AI56","v":1816.8117384237817}]
["DAP","kg/hr",{"$f":"AVERAGE(C83,C104,C125,C146)","v":202.12475589963415},0,0.6432088158049285,21.391307428522335,0,0,0.9638133877636651,225.12308553172511,6.4320881580492877,0,0,0,0,22.512308553172506,21.50938520712867,0.11807777860633467,1.0029233460438352,3.9109958280169999E-2,3.9109958280169999E-2,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Area 400: Makeup Water Delivery ",null,null,null,null,{"$f":"AJ56","v":287.00028288631233}]
["O2","kg/hr",{"$f":"AVERAGE(C84,C105,C126,C147)","v":0},0,0,0,0,36035.738945881385,0,0,0,0,0,1029.5925413108966,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Area 400: On-Site Circulation",null,null,null,null,{"$f":"AH56","v":393.43380876763717}]
["N2","kg/hr",{"$f":"AVERAGE(C85,C106,C127,C148)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Area 500: Dewatering",null,null,null,null,{"$f":"AD56+AE56+AF56+AG56","v":632.19159959100091}]
["CO2","kg/hr",{"$f":"AVERAGE(C86,C107,C128,C149)","v":0},0,0,0,46515.671494150316,4651.5671494150301,0,46515.671494150316,0,0,1301.6333356631501,105.51606867071345,47817.304829813467,0,0,0,0,0,0,0]
["Salt (NaCl)","kg/hr",{"$f":"AVERAGE(C87,C108,C129,C150)","v":0},274.38139489052264,4.6094804479080995,36087.505476733502,0,0,1627.4586882343997,37993.9552827468,0,4.6094804479080995,0,0,0,37993.9552827468,36300.457004060932,212.95152732743867,1693.4982786858604,66.039590451460953,66.039590451460953,0]
["Water","kg/hr",{"$f":"AVERAGE(C88,C109,C130,C151)","v":0},1097525.5795620908,1205.6270416666673,{"$f":"AVERAGE(F88,F109,F130,F151)","v":47422948.720029958},0,735601.11458333349,2137847.6093774447,50659527.536011159,0,18437.921791632398,0,16813.739761904762,0,49909276.996845692,47684679.056051791,261730.33602183615,2224597.9407938989,86750.331416453788,86750.331416453788,0]
["Solids"]
["Algae (AFDW)","kg/hr",{"$f":"AVERAGE(C90,C111,C132,C153)","v":0},0,602.81352083333331,2483.0388660850135,0,0,783.1034165319943,3868.9559604393803,0,0,0,0,0,24967.429189606046,2496.7429189606041,13.704052875590548,22470.686270645441,21687.582854113447,21470.707025572316,216.8758285411345]
["Ash","kg/hr",{"$f":"AVERAGE(C91,C112,C133,C154)","v":0},0,14.823283299180346,61.058332772583853,0,0,21.397707993568019,97.279324065332219,0,0,0,0,0,613.95317679359323,61.395317679360687,0.33698490677682591,552.55785911423254,533.30121772410166,531.16015112066452,2.1410666034367161]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Summer",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Summer Power Usage"]
[null,null,100,110,120,130,140,150,160,null,200,210,220,230,300,500,"500.A",510,520,600,610,620]
["Component","Units","Nutrients","Makup Water","Inoculum Algae","Clarified Water","CO2","Evaporation","Recycle Water","Total Inlet Into Area 100","Nutrients","Make-up Water","CO2","Evaporation","CO2 (From outside of Facility)","Algae to Settlers","Clarified Water to Blowdown","Blowdown","Algae","Algae Product","Algae Product","Storage Loss",null,null,null,"Paddlewheel Mixing","Pump to Settlers ","Clarified Water Pump","Inoculum Power","Pump from Settler to Membranes","Membrane Power Requirement","Pump from Membrane to Centrifuge","Centrifuge Power","Pump Return from Central Dewatering","CO2 Heating Power","Make-up Water Pump ","Total"]
["Total Flow","kg/hr",{"$f":"SUM(C82:C91)","v":864.09439870805181},1203131.1385783532,2559.9993229104766,{"$f":"SUM(F82:F91)","v":66446562.348262332},65056.883208601837,{"$f":"SUM(H82:H91)","v":815691.57321020472},{"$f":"SUM(I82:I91)","v":2993596.4413315342},70711770.905243292,{"$f":"SUM(K82:K91)","v":29.87866831297481},{"$f":"SUM(L82:L91)","v":19620.172789889202},1820.4662037246853,18931.250203770483,66877.349412326526,{"$f":"'Mass Balance'!P90/INPUT!B15*1000","v":69846455.953438148},{"$f":"SUM(Q82:Q91)","v":66750697.344976194},{"$f":"SUM(R82:R91)","v":304134.99671385624},{"$f":"SUM(S82:S91)","v":3146107.6023267484},{"$f":"SUM(T82:T91)","v":152511.16099521416},{"$f":"SUM(U82:U91)","v":152207.80561387859},303.35538133557378,null,null,"kW",{"$f":"'Quick Access Charts'!B48*INPUT!B10/2.47105/24","v":4641.2456243297383},{"$f":"P77/998*998*9.81*((1.45-1)*14.69*2.31)/3.28084/(3.6*10^6)/0.67","v":1322.2004992626601},{"$f":"(Q77-R77)/998*998*9.81*((1.42-1)*14.69*2.31)/3.28084/(3.6*10^6)/0.67","v":1173.9841570737028},{"$f":"'Quick Access Charts'!B49*('Quick Access Charts'!B37+'Quick Access Charts'!B38)/24+'Quick Access Charts'!B39*229/24","v":195.18712374603174},{"$f":"(S77)/998*998*9.81*((4.93-1)*14.69*2.31)/3.28084/(3.6*10^6)/0.8593","v":405.54265662869312},{"$f":"S77*0.04/1000/60*60","v":125.84430409306995},{"$f":"(S90*(1-0.005)/(INPUT!$B$30/1000)-S90)/998*998*9.81*((1.59-1)*14.69*2.31)/3.28084/(3.6*10^6)/0.8593","v":4.0471758463071756},{"$f":"(S90*(1-0.005)/(INPUT!$B$30/1000))/1000*1.45","v":348.82260343900236},{"$f":"(S77-T77)/998*998*9.81*((5.37-1)*14.69*2.31)/3.28084/(3.6*10^6)/0.67","v":550.31977543099447},{"$f":"G77/65057*2541","v":2540.9954383549389},{"$f":"(D77+L77)/998*998*9.81*((12.4-2)*14.69*2.31)/3.28084/(3.6*10^6)/0.67-(D77+L77)/998*998*9.81*((12.4-6)*14.69*2.31)/3.28084/(3.6*10^6)","v":314.38506839272105},{"$f":"SUM(Z77:AJ77)","v":11622.574426597861}]
["Salinity","mg/L",{"$f":"IF(C88>0,C87*1000*1000/C88,0)","v":0},{"$f":"IF(D88>0,D87*1000*1000/D88,0)","v":250},{"$f":"IF(E88>0,E87*1000*1000/(E88+N88),0)","v":257.69042779381749},{"$f":"IF(F88>0,F87*1000*1000/F88,0)","v":718.67704591036068},0,0,718.67704591036068,{"$f":"IF(J88>0,J87*1000*1000/J88,0)","v":710.74323901939431},0,250.00000000000003,0,0,0,718.67704591036079,718.67704591036068,{"$f":"IF(R88=0,0,R87*1000*1000/R88)","v":718.67704591036068},718.67704591036068,718.67704591036068,718.67704591036068,0,null,null,"Chiller Utility GJ/hr",null,null,null,{"$f":"4.187*4*5*1.06*1000/25*10000/1000/1000*('Quick Access Charts'!B38+'Quick Access Charts'!B39)/24*0.239005736/0.239006","v":16.877483188658399}]
["Is salinity above cell tolerance? ","(1=Yes, 0=No)",{"$f":"IF('Mass Balance'!C78>INPUT!$B$39,1,0)","v":0},{"$f":"IF('Mass Balance'!D78>INPUT!$B$39,1,0)","v":0},{"$f":"IF('Mass Balance'!E78>INPUT!$B$39,1,0)","v":0},{"$f":"IF('Mass Balance'!F78>INPUT!$B$39,1,0)","v":0},{"$f":"IF('Mass Balance'!G78>INPUT!$B$39,1,0)","v":0},{"$f":"IF('Mass Balance'!H78>INPUT!$B$39,1,0)","v":0},{"$f":"IF('Mass Balance'!I78>INPUT!$B$39,1,0)","v":0},{"$f":"IF('Mass Balance'!J78>INPUT!$B$39,1,0)","v":0},{"$f":"IF('Mass Balance'!K78>INPUT!$B$39,1,0)","v":0},{"$f":"IF('Mass Balance'!L78>INPUT!$B$39,1,0)","v":0},{"$f":"IF('Mass Balance'!M78>INPUT!$B$39,1,0)","v":0},{"$f":"IF('Mass Balance'!N78>INPUT!$B$39,1,0)","v":0},{"$f":"IF('Mass Balance'!O78>INPUT!$B$39,1,0)","v":0},{"$f":"IF('Mass Balance'!P78>INPUT!$B$39,1,0)","v":0},{"$f":"IF('Mass Balance'!Q78>INPUT!$B$39,1,0)","v":0},{"$f":"IF('Mass Balance'!R78>INPUT!$B$39,1,0)","v":0},{"$f":"IF('Mass Balance'!S78>INPUT!$B$39,1,0)","v":0},{"$f":"IF('Mass Balance'!T78>INPUT!$B$39,1,0)","v":0},{"$f":"IF('Mass Balance'!U78>INPUT!$B$39,1,0)","v":0},{"$f":"IF('Mass Balance'!V78>INPUT!$B$39,1,0)","v":0}]
[]
[]
["Ammonia","kg/hr",{"$f":"J82-E82-G82-I82-F82+H82-D82","v":581.43050927537865},0,{"$f":"K82+L82+M82-N82-E90/'Quick Access Charts'!B33*'Quick Access Charts'!B7*-1*'Quick Access Charts'!B31","v":4.1765481638399145},{"$f":"P82-S82-R82","v":139.03054122230023},0,0,{"$f":"S82-U82","v":6.2583300104665929},{"$f":"'Quick Access Charts'!C15/(1-INPUT!B20)*'Quick Access Charts'!B31","v":730.89592867198542},{"$f":"(E90/'Quick Access Charts'!B33*'Quick Access Charts'!B7*-1*'Quick Access Charts'!B31)/(1-INPUT!B20)","v":20.882740819199583},0,0,0,0,{"$f":"J82-'Quick Access Charts'!C15*'Quick Access Charts'!B31","v":146.17918573439704},{"$f":"P82-S82","v":139.66690300992965},{"$f":"$R$88/$Q$88*Q82","v":0.63636178762941997},{"$f":"S88/P77*P82","v":6.5122827244673891},{"$f":"T88/S88*S82","v":0.253952714000796},{"$f":"T82","v":0.253952714000796},0]
["DAP","kg/hr",{"$f":"J83-E83-G83-I83-F83+H83-D83","v":282.66388943267316},0,{"$f":"K83+L83+M83-N83-E90/'Quick Access Charts'!B33*'Quick Access Charts'!B6*-1*'Quick Access Charts'!B30","v":0.89959274937752198},29.945989347965302,0,0,{"$f":"S83-U83","v":1.3479907521170151},{"$f":"'Quick Access Charts'!C16/(1-INPUT!B21)*'Quick Access Charts'!B30","v":314.85746228213299},{"$f":"('Mass Balance'!E90/'Quick Access Charts'!B33*'Quick Access Charts'!B6*-'Quick Access Charts'!B30)/(1-INPUT!B21)","v":8.9959274937752287},0,0,0,0,{"$f":"J83-'Quick Access Charts'!C16*'Quick Access Charts'!B30","v":31.485746228213316},{"$f":"P83-S83","v":30.083056233746412},{"$f":"$R$88/$Q$88*Q83","v":0.13706688578110884},{"$f":"S88/P77*P83","v":1.4026899944669033},{"$f":"S83*T88/S88","v":5.4699242349888155E-2},5.4699242349888155E-2,0]
["O2","kg/hr",0,0,{"$f":"K84+L84+M84-N84+E90/'Quick Access Charts'!B33*'Quick Access Charts'!B9*'Quick Access Charts'!B27","v":0},0,0,{"$f":"J84+'Quick Access Charts'!C19*'Quick Access Charts'!B27","v":50399.634889344597},0,{"$f":"SUM(C84:G84,I84)","v":0},0,0,0,{"$f":"E90/'Quick Access Charts'!B33*'Quick Access Charts'!B9*'Quick Access Charts'!B27","v":1439.9895682669885},0,0,0,0,{"$f":"S88/P77*P84","v":0},0,0,0]
["N2","kg/hr",0,0,{"$f":"K85+L85+M85-N85","v":0},0,0,{"$f":"J85","v":0},0,{"$f":"SUM(C85:G85,I85)","v":0},0,0,0,0,0,0,0,0,{"$f":"S88/P77*P85","v":0},0,0,0]
["CO2","kg/hr",0,0,{"$f":"K86+L86+M86-N86-E90/'Quick Access Charts'!B33*'Quick Access Charts'!B5*-1*'Quick Access Charts'!B29","v":0},0,{"$f":"'Quick Access Charts'!C17*'Quick Access Charts'!B29/(INPUT!B18)","v":65056.883208601837},{"$f":"J86-'Quick Access Charts'!C17*'Quick Access Charts'!B29","v":6505.6883208601794},0,{"$f":"SUM(C86:G86,I86)","v":65056.883208601837},0,0,{"$f":"E90/'Quick Access Charts'!B33*'Quick Access Charts'!B5*-1*'Quick Access Charts'!B29*'Quick Access Charts'!B37/'Quick Access Charts'!B36/(INPUT!B18)+E90/'Quick Access Charts'!B33*'Quick Access Charts'!B5*-1*'Quick Access Charts'!B29*('Quick Access Charts'!B38+'Quick Access Charts'!B39)/'Quick Access Charts'!B36/INPUT!B19","v":1820.4662037246853},{"$f":"M86-'Mass Balance'!E90/'Quick Access Charts'!B33*'Quick Access Charts'!B5*-1*'Quick Access Charts'!B29","v":147.57492121778091},{"$f":"M86+G86","v":66877.349412326526},0,0,0,{"$f":"S88/P77*P86","v":0},0,0,0]
["Salt (NaCl)","kg/hr",0,{"$f":"D88*INPUT!B38/1000/1000","v":300.70760774265267},{"$f":"K87+L87+M87-N87","v":4.9038172431615106},{"$f":"IFERROR(P87-S87-R87,0)","v":47716.644989220462},0,0,2149.0725186245572,50171.328932830831,0,{"$f":"L88*INPUT!B38/1000/1000","v":4.9038172431615106},0,0,0,{"$f":"IFERROR(J87,0)","v":50171.328932830831},{"$f":"IFERROR(P87*Q88/P88,0)","v":47935.050594478569},{"$f":"$R$88/$Q$88*Q87","v":218.40560525810744},{"$f":"S88/P88*P87","v":2236.2783383522615},{"$f":"T88/S88*S87","v":87.205819727704451},{"$f":"T87","v":87.205819727704451},0]
["Water","kg/hr",0,{"$f":"U88+H88+R88-E88+'Quick Access Charts'!C18*'Quick Access Charts'!B26","v":1202830.4309706106},{"$f":"K88+L88+M88-N88-E90/'Quick Access Charts'!B33*'Quick Access Charts'!B8*-1*'Quick Access Charts'!B26","v":1686.1916666666659},{"$f":"P88-S88-R88","v":66395114.830440924},0,{"$f":"INPUT!B47*4046.86*INPUT!$B$10/100*1000/24","v":758786.25},2990317.4601914403,{"$f":"D88+E88+F88+G88+I88","v":70589948.913269639},0,{"$f":"E90/INPUT!B25+N88+E90/'Quick Access Charts'!B33*'Quick Access Charts'!B8*-1*'Quick Access Charts'!B26","v":19615.268972646041},0,{"$f":"INPUT!B47/100*'Quick Access Charts'!B37*10000*1000/24","v":17343.685714285715},0,{"$f":"P77-P90-P91","v":69810673.95756036},{"$f":"P88-S88","v":66699014.344834693},303899.51439376955,{"$f":"S90/INPUT!B27*1000-S90","v":3111659.61272567},{"$f":"T90/INPUT!B32*1000-T90","v":121342.15253422952},{"$f":"T88","v":121342.15253422952},0]
["Solids",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Goal Seek for Mass Balance Recycles "]
["Algae (AFDW)","kg/hr",0,0,{"$f":"INPUT!B22*INPUT!B17/INPUT!B26/24","v":843.09583333333342},{"$f":"P90-S90-R90","v":3476.4107903844856},0,0,{"$f":"S90-T90","v":1095.3670454897947},5414.8738100524106,0,0,0,0,0,{"$f":"'Quick Access Charts'!C13+J90","v":34923.227976719078},{"$f":"P90-S90","v":3492.3227976719063},{"$f":"R88/Q88*Q90","v":15.912007287420634},{"$f":"P90*INPUT!B28","v":31430.905179047171},{"$f":"S90*(INPUT!B31)*(INPUT!B33)","v":30335.538133557377},{"$f":"T90-V90","v":30032.182752221805},{"$f":"T90*INPUT!B34","v":303.35538133557378},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C90,D90,E90,F90,G90,I90)","v":5414.8736692076136},{"$f":"SUM(C87:G87,I87)","v":50171.328932830831},{"$f":"IF(INPUT!B35=\"User defined\",R77,R78)","v":304134.99671385624}]
["Ash","kg/hr",0,0,{"$f":"E90/(1-INPUT!$B$64)-E90","v":20.73186475409841},{"$f":"P91-S91-R91","v":85.485511238965969},0,0,{"$f":"S91-T91","v":26.935255216962105},{"$f":"SUM(C91,D91,E91,F91,G91,I91)","v":133.15263121002647},0,0,0,0,0,{"$f":"P90/(1-INPUT!$B$64)-P90","v":858.76790106686531},{"$f":"P91-S91","v":85.876790106689441},{"$f":"$R$88/$Q$88*Q91","v":0.39127886772347287},{"$f":"S90/(1-INPUT!$B$64)-S90","v":772.89111096017587},{"$f":"T90/(1-INPUT!$B$64)-T90","v":745.95585574321376},{"$f":"T91","v":745.95585574321376},0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"J90-AO90","v":1.4084479698794894E-4},{"$f":"(AP90-J87)","v":0},{"$f":"IF(INPUT!B35=\"User defined\",AQ90-INPUT!B48,R78-(INPUT!B39-INPUT!B39*INPUT!B40))","v":-3.2861437648534775E-3},{"$f":"SUM(AO91:AQ91)+AQ92","v":-3.1452989678655285E-3}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(INPUT!B35=\"User defined\",0,IF(R77=0,AQ91*-1,0))","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Fall",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fall Power Usage"]
[null,null,100,110,120,130,140,150,160,null,200,210,220,230,300,500,"500.A",510,520,600,610,620]
["Component","Units","Nutrients","Makup Water","Inoculum Algae","Clarified Water","CO2","Evaporation","Recycle Water","Total Inlet Into Area 100","Nutrients","Make-up Water","CO2","Evaporation","CO2 (From outside of Facility)","Algae to Settlers","Clarified Water to Blowdown","Blowdown","Algae","Algae Product","Algae Product","Storage Loss",null,null,null,"Paddlewheel Mixing","Pump to Settlers ","Clarified Water Pump","Inoculum Power","Pump from Settler to Membranes","Membrane Power Requirement","Pump from Membrane to Centrifuge","Centrifuge Power","Pump Return from Central Dewatering","CO2 Heating Power","Make-up Water Pump ","Total"]
["Total Flow","kg/hr",{"$f":"SUM(C103:C112)","v":614.48822683963522},511670.90660228208,1819.8581544352219,{"$f":"SUM(F103:F112)","v":47379262.584748141},{"$f":"SUM(G103:G112)","v":46283.325482691027},{"$f":"SUM(H103:H112)","v":335567.61446478381},{"$f":"SUM(I103:I112)","v":2130076.5994751896},50069727.763695598,{"$f":"SUM(K103:K112)","v":21.256538314087798},{"$f":"SUM(L103:L112)","v":8362.9261080177748},{"$f":"SUM(M103:M112)","v":1295.1316706498476},7874.2054034715457,47578.457153340874,{"$f":"'Mass Balance'!P111/INPUT!B15*1000","v":49702755.55016613},{"$f":"SUM(Q103:Q112)","v":47496079.584748141},{"$f":"SUM(R103:R112)","v":116816.99999999999},{"$f":"SUM(S103:S112)","v":2238596.7879159465},{"$f":"SUM(T103:T112)","v":108520.18844075646},{"$f":"SUM(U103:U112)","v":108304.32067541988},{"$f":"SUM(V103:V112)","v":215.86776533659275},null,null,"kW",{"$f":"'Quick Access Charts'!B48*INPUT!B10/2.47105/24","v":4641.2456243297383},{"$f":"P98/998*998*9.81*(6.61*2.31)/3.28084/(3.6*10^6)/0.67","v":940.80704099855075},{"$f":"(Q98-R98)/998*998*9.81*(6.61*2.31)*0.42/0.45/3.28084/(3.6*10^6)/0.67","v":837.03798285233086},{"$f":"'Quick Access Charts'!B49*('Quick Access Charts'!B37+'Quick Access Charts'!B38)/24+'Quick Access Charts'!B39*229/24","v":195.18712374603174},{"$f":"(S98)/998*998*9.81*((4.93-1)*14.69*2.31)/3.28084/(3.6*10^6)/0.8593","v":288.56180501279783},{"$f":"S98*0.04/1000/60*60","v":89.54387151663785},{"$f":"(S111*(1-0.005)/(INPUT!$B$30/1000)-S111)/998*998*9.81*((6.61*2.31)*0.59/0.45)/3.28084/(3.6*10^6)/0.8593","v":2.8797535127905438},{"$f":"(S111*(1-0.005)/(INPUT!$B$30/1000))/1000*1.45","v":248.22225197308444},{"$f":"(S98-T98)/998*998*9.81*((6.61*2.31)*4.37/0.45)/3.28084/(3.6*10^6)/0.67","v":391.5473027536616},{"$f":"G98/65057*2541","v":1807.736754715371},{"$f":"(D98+L98)/998*998*9.81*((12.4-2)*14.69*2.31)/3.28084/(3.6*10^6)/0.67-(D98+L98)/998*998*9.81*((12.4-6)*14.69*2.31)/3.28084/(3.6*10^6)","v":133.70737822412343},{"$f":"SUM(Z98:AJ98)","v":9576.4768896351179}]
["Salinity","mg/L",{"$f":"IF(C109>0,C108*1000*1000/C109,0)","v":0},{"$f":"IF(D109>0,D108*1000*1000/D109,0)","v":250},{"$f":"IF(E109>0,E108*1000*1000/(E109+N109),0)","v":263.10564022630024},{"$f":"IF(F109>0,F108*1000*1000/F109,0)","v":640.0193050482153},{"$f":"IF(G109>0,G108*1000*1000/G109,0)","v":0},0,640.0193050482153,636.05450556136873,0,250,0,0,0,640.0193050482153,640.01930504821519,{"$f":"IF(R109=0,0,R108*1000*1000/R109)","v":640.01930504821519},640.0193050482153,640.01930504821519,640.01930504821519,0,null,null,"Chiller Utility GJ/hr",null,null,null,{"$f":"4.187*4*5*1.06*1000/25*10000/1000/1000*('Quick Access Charts'!B38+'Quick Access Charts'!B39)/24*0.239005736/0.239006","v":16.877483188658399}]
["Is salinity above cell tolerance? ","(1=Yes, 0=No)",{"$f":"IF('Mass Balance'!C99>INPUT!$B$39,1,0)","v":0},{"$f":"IF('Mass Balance'!D99>INPUT!$B$39,1,0)","v":0},{"$f":"IF('Mass Balance'!E99>INPUT!$B$39,1,0)","v":0},{"$f":"IF('Mass Balance'!F99>INPUT!$B$39,1,0)","v":0},{"$f":"IF('Mass Balance'!G99>INPUT!$B$39,1,0)","v":0},{"$f":"IF('Mass Balance'!H99>INPUT!$B$39,1,0)","v":0},{"$f":"IF('Mass Balance'!I99>INPUT!$B$39,1,0)","v":0},{"$f":"IF('Mass Balance'!J99>INPUT!$B$39,1,0)","v":0},{"$f":"IF('Mass Balance'!K99>INPUT!$B$39,1,0)","v":0},{"$f":"IF('Mass Balance'!L99>INPUT!$B$39,1,0)","v":0},{"$f":"IF('Mass Balance'!M99>INPUT!$B$39,1,0)","v":0},{"$f":"IF('Mass Balance'!N99>INPUT!$B$39,1,0)","v":0},{"$f":"IF('Mass Balance'!O99>INPUT!$B$39,1,0)","v":0},{"$f":"IF('Mass Balance'!P99>INPUT!$B$39,1,0)","v":0},{"$f":"IF('Mass Balance'!Q99>INPUT!$B$39,1,0)","v":0},{"$f":"IF('Mass Balance'!R99>INPUT!$B$39,1,0)","v":0},{"$f":"IF('Mass Balance'!S99>INPUT!$B$39,1,0)","v":0},{"$f":"IF('Mass Balance'!T99>INPUT!$B$39,1,0)","v":0},{"$f":"IF('Mass Balance'!U99>INPUT!$B$39,1,0)","v":0},{"$f":"IF('Mass Balance'!V99>INPUT!$B$39,1,0)","v":0}]
[]
[]
["Ammonia","kg/hr",{"$f":"J103-E103-G103-I103-F103+H103-D103","v":413.43793482259184},0,{"$f":"K103+L103+M103-N103-E111/'Quick Access Charts'!B33*'Quick Access Charts'!B7*-1*'Quick Access Charts'!B31","v":2.9713156937032554},{"$f":"P103-S103-R103","v":99.118641102899772},0,0,{"$f":"S103-U103","v":4.4523547788748035},{"$f":"'Quick Access Charts'!D15/(1-INPUT!B20)*'Quick Access Charts'!B31","v":519.98024639806965},{"$f":"(E111/'Quick Access Charts'!B33*'Quick Access Charts'!B7*-1*'Quick Access Charts'!B31)/(1-INPUT!B20)","v":14.856578468516277},0,0,0,0,{"$f":"J103-'Quick Access Charts'!D15*'Quick Access Charts'!B31","v":103.99604927961389},{"$f":"P103-S103","v":99.363025284207083},{"$f":"$R$109/$Q$109*Q103","v":0.24438418130730374},{"$f":"S109/P98*P103","v":4.6330239954067984},{"$f":"T109/S109*S103","v":0.18066921653199478},{"$f":"T103","v":0.18066921653199478},0]
["DAP","kg/hr",{"$f":"J104-E104-G104-I104-F104+H104-D104","v":201.05029201704343},0,{"$f":"K104+L104+M104-N104-E111/'Quick Access Charts'!B33*'Quick Access Charts'!B6*-1*'Quick Access Charts'!B30","v":0.63999598455715212},21.3493074583251,0,0,0.95899913507753254,{"$f":"'Quick Access Charts'!D16/(1-INPUT!B21)*'Quick Access Charts'!B30","v":223.9985945950032},{"$f":"('Mass Balance'!E111/'Quick Access Charts'!B33*'Quick Access Charts'!B6*-'Quick Access Charts'!B30)/(1-INPUT!B21)","v":6.3999598455715194},0,0,0,0,{"$f":"J104-'Quick Access Charts'!D16*'Quick Access Charts'!B30","v":22.399859459500306},{"$f":"P104-S104","v":21.401945720579565},{"$f":"$R$109/$Q$109*Q104","v":5.2638262254465613E-2},{"$f":"S109/P98*P104","v":0.99791373892073865},{"$f":"S104*T109/S109","v":3.8914603843206094E-2},3.8914603843206094E-2,0]
["O2","kg/hr",0,0,{"$f":"K105+L105+M105-N105+E111/'Quick Access Charts'!B33*'Quick Access Charts'!B9*'Quick Access Charts'!B27","v":0},0,0,{"$f":"J105+'Quick Access Charts'!D19*'Quick Access Charts'!B27","v":35855.740249848015},0,{"$f":"SUM(C105:G105,I105)","v":0},0,0,0,{"$f":"E111/'Quick Access Charts'!B33*'Quick Access Charts'!B9*'Quick Access Charts'!B27","v":1024.4497214242288},0,0,0,{"$f":"$R$109/$Q$109*Q105","v":0},{"$f":"S109/P98*P105","v":0},0,0,0]
["N2","kg/hr",0,0,{"$f":"K106+L106+M106-N106","v":0},0,0,{"$f":"J106","v":0},0,{"$f":"SUM(C106:G106,I106)","v":0},0,0,0,0,0,0,0,0,{"$f":"S109/P98*P106","v":0},0,0,0]
["CO2","kg/hr",0,0,{"$f":"K107+L107+M107-N107-E111/'Quick Access Charts'!B33*'Quick Access Charts'!B5*-1*'Quick Access Charts'!B29","v":0},0,{"$f":"'Quick Access Charts'!D17*'Quick Access Charts'!B29/(INPUT!B18)","v":46283.325482691027},{"$f":"J107-'Quick Access Charts'!D17*'Quick Access Charts'!B29","v":4628.3325482690998},0,{"$f":"SUM(C107:G107,I107)","v":46283.325482691027},0,0,{"$f":"E111/'Quick Access Charts'!B33*'Quick Access Charts'!B5*-1*'Quick Access Charts'!B29*'Quick Access Charts'!B37/'Quick Access Charts'!B36/(INPUT!B18)+E111/'Quick Access Charts'!B33*'Quick Access Charts'!B5*-1*'Quick Access Charts'!B29*('Quick Access Charts'!B38+'Quick Access Charts'!B39)/'Quick Access Charts'!B36/INPUT!B19","v":1295.1316706498476},{"$f":"M107-'Mass Balance'!E111/'Quick Access Charts'!B33*'Quick Access Charts'!B5*-1*'Quick Access Charts'!B29","v":104.98901538065002},{"$f":"M107+G107","v":47578.457153340874},0,0,0,{"$f":"S109/P98*P107","v":0},0,0,0]
["Salt (NaCl)","kg/hr",0,{"$f":"D109*INPUT!B38/1000/1000","v":127.88575521176757},{"$f":"K108+L108+M108-N108","v":2.0902089747607535},{"$f":"IFERROR(P108-S108-R108,0)","v":30302.545757531676},0,0,1361.9038977379348,31794.426589218016,0,{"$f":"L109*INPUT!B38/1000/1000","v":2.0902089747607535},0,0,0,{"$f":"IFERROR(J108,0)","v":31794.426589218016},{"$f":"IFERROR(P108*Q109/P109,0)","v":30377.258876618864},{"$f":"$R$109/$Q$109*Q108","v":74.713119087190918},{"$f":"S109/P109*P108","v":1417.1677125991498},{"$f":"T109/S109*S108","v":55.263814861214918},{"$f":"T108","v":55.263814861214918},0]
["Water","kg/hr",0,{"$f":"U109+H109+R109-E109+'Quick Access Charts'!D18*'Quick Access Charts'!B26","v":511543.02084707032},{"$f":"K109+L109+M109-N109-E111/'Quick Access Charts'!B33*'Quick Access Charts'!B8*-1*'Quick Access Charts'!B26","v":1199.604928571428},{"$f":"P109-S109-R109","v":47346299.585836492},0,{"$f":"INPUT!C47*4046.86*INPUT!$B$10/100*1000/24","v":295083.54166666669},2127910.6536252638,{"$f":"D109+E109+F109+G109+I109","v":49986952.8652374},0,{"$f":"E111/INPUT!B25+N109+E111/'Quick Access Charts'!B33*'Quick Access Charts'!B8*-1*'Quick Access Charts'!B26","v":8360.8358990430133},0,{"$f":"INPUT!C47/100*'Quick Access Charts'!B37*10000*1000/24","v":6744.7666666666673},0,{"$f":"P98-P111-P112","v":49677293.072937563},{"$f":"P109-S109","v":47463035.31317766},116735.72734116588,{"$f":"S111/INPUT!B27*1000-S111","v":2214257.7597599011},{"$f":"T111/INPUT!B32*1000-T111","v":86347.106134637099},{"$f":"T109","v":86347.106134637099},0]
["Solids",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Goal Seek for Mass Balance Recycles "]
["Algae (AFDW)","kg/hr",0,0,{"$f":"INPUT!C46*'Quick Access Charts'!B36*10000/1000/24","v":599.80246428571422},{"$f":"P111-S111-R111","v":2479.0255606202318},0,0,{"$f":"S111-T111","v":779.46346391548286},3858.2915250830642,0,0,0,0,0,{"$f":"'Quick Access Charts'!D13+J111","v":24851.377775083063},{"$f":"P111-S111","v":2485.1377775083056},{"$f":"R109/Q109*Q111","v":6.1122168880736503},{"$f":"P111*INPUT!B28","v":22366.239997574758},{"$f":"S111*(INPUT!B31)*(INPUT!B33)","v":21586.776533659275},{"$f":"T111-V111","v":21370.908768322683},{"$f":"T111*INPUT!B34","v":215.86776533659275},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C111,D111,E111,F111,G111,I111)","v":3858.2914888214291},{"$f":"SUM(C108:G108,I108)","v":31794.425619456139},{"$f":"IF(INPUT!B35=\"User defined\",R98,R99)","v":116816.99999999999}]
["Ash","kg/hr",0,0,{"$f":"E111/(1-INPUT!$B$64)-E111","v":14.74924092505853},{"$f":"P112-S112-R112","v":60.959644933285311},0,0,{"$f":"S112-T112","v":19.167134358576732},{"$f":"SUM(C112,D112,E112,F112,G112,I112)","v":94.87602021692058},0,0,0,0,0,{"$f":"P111/(1-INPUT!$B$64)-P111","v":611.09945348565088},{"$f":"P112-S112","v":61.109945348565816},{"$f":"$R$109/$Q$109*Q112","v":0.15030041528050186},{"$f":"S111/(1-INPUT!$B$64)-S111","v":549.98950813708507},{"$f":"T111/(1-INPUT!$B$64)-T111","v":530.82237377850834},{"$f":"T112","v":530.82237377850834},0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AO111-J111","v":-3.6261635159462458E-5},{"$f":"AP111-J108","v":-9.6976187705877237E-4},{"$f":"IF(INPUT!B35=\"User defined\",AQ111-INPUT!C48,R99-(INPUT!B39-INPUT!B39*INPUT!B40))","v":-1.4551915228366852E-11},{"$f":"SUM(AO112:AQ112)+AQ113","v":-1.0060235267701501E-3}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(INPUT!B35=\"User defined\",0,IF(R98=0,AQ112*-1,0))","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Winter",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Winter Power Usage"]
[null,null,100,110,120,130,140,150,160,null,200,210,220,230,300,500,"500.A",510,520,600,610,620]
["Component","Units","Nutrients","Makup Water","Inoculum Algae","Clarified Water","CO2","Evaporation","Recycle Water","Total Inlet Into Area 100","Nutrients","Make-up Water","CO2","Evaporation","CO2 (From outside of Facility)","Algae to Settlers","Clarified Water to Blowdown","Blowdown","Algae","Algae Product","Algae Product","Storage Loss",null,null,null,"Paddlewheel Mixing","Pump to Settlers ","Clarified Water Pump","Inoculum Power","Pump from Settler to Membranes","Membrane Power Requirement","Pump from Membrane to Centrifuge","Centrifuge Power","Pump Return from Central Dewatering","CO2 Heating Power","Make-up Water Pump ","Total"]
["Total Flow","kg/hr",{"$f":"SUM(C124:C133)","v":288.88065683799277},{"$f":"SUM(D124:D133)","v":453938.26224235003},856.00795730490336,22201474.398019426,21747.586672589754,314106.17828264943,1000703.5720243963,23679008.707630273,9.9880119789087232,7506.0005298718061,608.55584524510914,7275.466796008719,22356.142517834862,{"$f":"'Mass Balance'!P132/INPUT!B15*1000","v":23347430.020212088},{"$f":"SUM(Q124:Q133)","v":22313460.396585435},{"$f":"SUM(R124:R133)","v":111985.99856600662},{"$f":"SUM(S124:S133)","v":1051682.2020900499},50981.123556826904,50877.22809127564,103.895465551265,null,null,"kW",{"$f":"'Quick Access Charts'!B48*INPUT!B10/2.47105/24","v":4641.2456243297383},{"$f":"P119/998*998*9.81*(6.61*2.31)/3.28084/(3.6*10^6)/0.67","v":441.93579026149274},{"$f":"(Q119-R119)/998*998*9.81*(6.61*2.31)*0.42/0.45/3.28084/(3.6*10^6)/0.67","v":392.22808318777118},{"$f":"'Quick Access Charts'!B49*('Quick Access Charts'!B37+'Quick Access Charts'!B38)/24+'Quick Access Charts'!B39*229/24","v":195.18712374603174},{"$f":"(S119)/998*998*9.81*((4.93-1)*14.69*2.31)/3.28084/(3.6*10^6)/0.8593","v":135.56497363576739},{"$f":"S119*0.04/1000/60*60","v":42.067288083601994},{"$f":"(S132*(1-0.005)/(INPUT!$B$30/1000)-S132)/998*998*9.81*((6.61*2.31)*0.59/0.45)/3.28084/(3.6*10^6)/0.8593","v":1.352738754041021},{"$f":"(S132*(1-0.005)/(INPUT!$B$30/1000))/1000*1.45","v":116.60020844421111},{"$f":"(S119-T119)/998*998*9.81*((6.61*2.31)*4.37/0.45)/3.28084/(3.6*10^6)/0.67","v":183.94728539757719},{"$f":"G119/65057*2541","v":849.41847510722232},{"$f":"(D119+L119)/998*998*9.81*((12.4-2)*14.69*2.31)/3.28084/(3.6*10^6)/0.67-(D119+L119)/998*998*9.81*((12.4-6)*14.69*2.31)/3.28084/(3.6*10^6)","v":118.6432472100488},{"$f":"SUM(Z119:AJ119)","v":7118.190838157504}]
["Salinity","mg/L",{"$f":"IF(C130>0,C129*1000*1000/C130,0)","v":0},{"$f":"IF(D130>0,D129*1000*1000/D130,0)","v":250},{"$f":"IF(E130>0,E129*1000*1000/(E130+N130),0)","v":256.69390941691825},{"$f":"IF(F130>0,F129*1000*1000/F130,0)","v":756.49593449914926},0,0,756.49593449914926,746.83282502256282,0,250,0,0,0,756.49593449914914,756.49593449914914,{"$f":"IF(R130=0,0,R129*1000*1000/R130)","v":756.49593449914914},756.49593449914926,756.49593449914937,756.49593449914937,0,null,null,"Chiller Utility GJ/hr",null,null,null,{"$f":"4.187*4*5*1.06*1000/25*10000/1000/1000*('Quick Access Charts'!B38+'Quick Access Charts'!B39)/24*0.239005736/0.239006","v":16.877483188658399}]
["Is salinity above cell tolerance? ","(1=Yes, 0=No)",{"$f":"IF('Mass Balance'!C120>INPUT!$B$39,1,0)","v":0},{"$f":"IF('Mass Balance'!D120>INPUT!$B$39,1,0)","v":0},{"$f":"IF('Mass Balance'!E120>INPUT!$B$39,1,0)","v":0},{"$f":"IF('Mass Balance'!F120>INPUT!$B$39,1,0)","v":0},{"$f":"IF('Mass Balance'!G120>INPUT!$B$39,1,0)","v":0},{"$f":"IF('Mass Balance'!H120>INPUT!$B$39,1,0)","v":0},{"$f":"IF('Mass Balance'!I120>INPUT!$B$39,1,0)","v":0},{"$f":"IF('Mass Balance'!J120>INPUT!$B$39,1,0)","v":0},{"$f":"IF('Mass Balance'!K120>INPUT!$B$39,1,0)","v":0},{"$f":"IF('Mass Balance'!L120>INPUT!$B$39,1,0)","v":0},{"$f":"IF('Mass Balance'!M120>INPUT!$B$39,1,0)","v":0},{"$f":"IF('Mass Balance'!N120>INPUT!$B$39,1,0)","v":0},{"$f":"IF('Mass Balance'!O120>INPUT!$B$39,1,0)","v":0},{"$f":"IF('Mass Balance'!P120>INPUT!$B$39,1,0)","v":0},{"$f":"IF('Mass Balance'!Q120>INPUT!$B$39,1,0)","v":0},{"$f":"IF('Mass Balance'!R120>INPUT!$B$39,1,0)","v":0},{"$f":"IF('Mass Balance'!S120>INPUT!$B$39,1,0)","v":0},{"$f":"IF('Mass Balance'!T120>INPUT!$B$39,1,0)","v":0},{"$f":"IF('Mass Balance'!U120>INPUT!$B$39,1,0)","v":0},{"$f":"IF('Mass Balance'!V120>INPUT!$B$39,1,0)","v":0}]
[]
[]
["Ammonia","kg/hr",{"$f":"J124-E124-G124-I124-F124+H124-D124","v":194.38550577816903},0,{"$f":"K124+L124+M124-N124-E132/'Quick Access Charts'!B33*'Quick Access Charts'!B7*-1*'Quick Access Charts'!B31","v":1.3961603861979146},{"$f":"P124-S124-R124","v":46.4543311024836},0,0,{"$f":"S124-U124","v":2.0920703177845472},{"$f":"'Quick Access Charts'!E15/(1-INPUT!B20)*'Quick Access Charts'!B31","v":244.32806758463511},{"$f":"(E132/'Quick Access Charts'!B33*'Quick Access Charts'!B7*-1*'Quick Access Charts'!B31)/(1-INPUT!B20)","v":6.9808019309895757},0,0,0,0,{"$f":"J124-'Quick Access Charts'!E15*'Quick Access Charts'!B31","v":48.865613516927027},{"$f":"P124-S124","v":46.688650434747927},{"$f":"$R$130/$Q$130*Q124","v":0.23431933226432977},{"$f":"S130/P119*P124","v":2.1769630821790988},{"$f":"T130/S130*S124","v":8.4892764394551803E-2},{"$f":"T124","v":8.4892764394551803E-2},0]
["DAP","kg/hr",{"$f":"J125-E125-G125-I125-F125+H125-D125","v":94.495151059823769},0,{"$f":"K125+L125+M125-N125-E132/'Quick Access Charts'!B33*'Quick Access Charts'!B6*-1*'Quick Access Charts'!B30","v":0.30072100479191466},{"$f":"P125-S125-R125","v":10.005865561132493},0,0,0.45061405142197325,{"$f":"'Quick Access Charts'!E16/(1-INPUT!B21)*'Quick Access Charts'!B30","v":105.25235167717015},{"$f":"('Mass Balance'!E132/'Quick Access Charts'!B33*'Quick Access Charts'!B6*-'Quick Access Charts'!B30)/(1-INPUT!B21)","v":3.0072100479191475},0,0,0,0,{"$f":"J125-'Quick Access Charts'!E16*'Quick Access Charts'!B30","v":10.525235167717014},{"$f":"P125-S125","v":10.05633594099522},{"$f":"$R$130/$Q$130*Q125","v":5.0470379862726539E-2},{"$f":"S130/P119*P125","v":0.46889922672179296},{"$f":"S125*T130/S130","v":1.8285175299819736E-2},1.8285175299819736E-2,0]
["O2","kg/hr",0,0,{"$f":"K126+L126+M126-N126+E132/'Quick Access Charts'!B33*'Quick Access Charts'!B9*'Quick Access Charts'!B27","v":0},0,0,{"$f":"J126+'Quick Access Charts'!E19*'Quick Access Charts'!B27","v":16847.877948723763},0,{"$f":"SUM(C126:G126,I126)","v":0},0,0,0,{"$f":"E132/'Quick Access Charts'!B33*'Quick Access Charts'!B9*'Quick Access Charts'!B27","v":481.36794139210758},0,0,0,0,{"$f":"S130/P119*P126","v":0},0,0,0]
["N2","kg/hr",0,0,{"$f":"K127+L127+M127-N127","v":0},0,0,0,0,{"$f":"SUM(C127:G127,I127)","v":0},0,0,0,0,0,0,0,0,{"$f":"S130/P119*P127","v":0},0,0,0]
["CO2","kg/hr",0,0,{"$f":"K128+L128+M128-N128-E132/'Quick Access Charts'!B33*'Quick Access Charts'!B5*-1*'Quick Access Charts'!B29","v":0},0,{"$f":"'Quick Access Charts'!E17*'Quick Access Charts'!B29/(INPUT!B18)","v":21747.586672589754},{"$f":"J128-'Quick Access Charts'!E17*'Quick Access Charts'!B29","v":2174.758667258975},0,{"$f":"SUM(C128:G128,I128)","v":21747.586672589754},0,0,{"$f":"E132/'Quick Access Charts'!B33*'Quick Access Charts'!B5*-1*'Quick Access Charts'!B29*'Quick Access Charts'!B37/'Quick Access Charts'!B36/(INPUT!B18)+E132/'Quick Access Charts'!B33*'Quick Access Charts'!B5*-1*'Quick Access Charts'!B29*('Quick Access Charts'!B38+'Quick Access Charts'!B39)/'Quick Access Charts'!B36/INPUT!B19","v":608.55584524510914},{"$f":"M128-E132/'Quick Access Charts'!B33*'Quick Access Charts'!B5*-1*'Quick Access Charts'!B29","v":49.332187949943886},{"$f":"M128+G128","v":22356.142517834862},0,0,0,{"$f":"S130/P119*P128","v":0},0,0,0]
["Salt (NaCl)","kg/hr",0,{"$f":"D130*INPUT!B38/1000/1000","v":113.45620151020995},{"$f":"K129+L129+M129-N129","v":1.8760311246867798},{"$f":"IFERROR(P129-S129-R129,0)","v":16781.686845665012},0,0,756.16853641027228,17653.187614710179,0,{"$f":"L130*INPUT!B38/1000/1000","v":1.8760311246867798},0,0,0,{"$f":"IFERROR(J129,0)","v":17653.187614710179},{"$f":"IFERROR(P129*Q130/P130,0)","v":16866.335005753037},84.648160088028462,{"$f":"S130/P130*P129","v":786.85260895714032},{"$f":"T130/S130*S129","v":30.684072546868034},30.684072546868034,0]
["Water","kg/hr",0,{"$f":"U130+H130+R130-E130+'Quick Access Charts'!E18*'Quick Access Charts'!B26","v":453824.80604083982},{"$f":"K130+L130+M130-N130-E132/'Quick Access Charts'!B33*'Quick Access Charts'!B8*-1*'Quick Access Charts'!B26","v":563.66978571428535},{"$f":"P130-S130-R130","v":22183446.176449854},0,{"$f":"INPUT!D47*4046.86*INPUT!$B$10/100*1000/24","v":295083.54166666669},999567.21764923458,{"$f":"D130+E130+F130+G130+I130","v":23637401.869925644},0,{"$f":"E132/INPUT!B25+N130+E132/'Quick Access Charts'!B33*'Quick Access Charts'!B8*-1*'Quick Access Charts'!B26","v":7504.1244987471191},0,{"$f":"INPUT!D47/100*'Quick Access Charts'!B37*10000*1000/24","v":6744.7666666666673},0,{"$f":"P119-P132-P133","v":23335469.24663616},{"$f":"P130-S130","v":22295341.23923571},111895.06278585779,{"$f":"S132/INPUT!B27*1000-S132","v":1040128.0074004484},{"$f":"T132/INPUT!B32*1000-T132","v":40560.789751213844},40560.789751213844,0]
["Solids"]
["Algae (AFDW)","kg/hr",0,0,{"$f":"INPUT!D46*'Quick Access Charts'!B36*10000/1000/24","v":281.83489285714285},{"$f":"P132-S132-R132","v":1161.5127385903131},0,0,{"$f":"S132-T132","v":366.14607129197611},1809.4937601060456,0,0,0,0,0,{"$f":"'Quick Access Charts'!E13+J132","v":11673.715010106043},{"$f":"P132-S132","v":1167.3715010106043},{"$f":"$R$130/$Q$130*Q132","v":5.8587624202911917},{"$f":"P132*INPUT!B28","v":10506.343509095439},{"$f":"S132*(INPUT!B31)*(INPUT!B33)","v":10140.197437803463},{"$f":"T132-V132","v":10038.795463425427},{"$f":"T132*INPUT!B34","v":101.40197437803464},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Goal Seek for Mass Balance Recycles "]
["Ash","kg/hr",0,0,{"$f":"E132/(1-INPUT!B64)-E132","v":6.9303662177986212},{"$f":"P133-S133-R133","v":28.561788653860262},0,0,{"$f":"S133-U133","v":11.497083090247543},{"$f":"SUM(C133:I133)","v":46.989237961906426},0,0,0,0,0,{"$f":"P132/(1-INPUT!$B$64)-P132","v":287.0585658222808},{"$f":"P133-S133","v":28.70585658222808},{"$f":"$R$130/$Q$130*Q133","v":0.14406792836781673},{"$f":"S132/(1-INPUT!$B$64)-S132","v":258.35270924005272},{"$f":"T132/(1-INPUT!$B$64)-T132","v":249.3491173230359},{"$f":"U132/(1-INPUT!$B$64)-U132","v":246.85562614980518},{"$f":"V132/(1-INPUT!$B$64)-V132","v":2.4934911732303675},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C132:I132)","v":1809.4937027394321},{"$f":"SUM(C129:G129,I129)","v":17653.187614710179},{"$f":"IF(INPUT!B35=\"User defined\",R119,R120)","v":111985.99856600662}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AO133-J132","v":-5.7366613418707857E-5},{"$f":"AP133-J129","v":0},{"$f":"IF(INPUT!B35=\"User defined\",AQ133-INPUT!D48,INPUT!B39*(1-INPUT!B40)-AQ133)","v":-1.4339933841256425E-3},{"$f":"SUM(AO134:AQ134)+AQ135","v":-1.4913599975443503E-3}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(INPUT!B35=\"User defined\",0,IF(R119=0,AQ134*-1,0))","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,"Spring",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Spring Power Usage"]
[null,null,100,110,120,130,140,150,160,null,200,210,220,230,300,500,"500.A",510,520,600,610,620]
["Component","Units","Nutrients","Makup Water","Inoculum Algae","Clarified Water","CO2","Evaporation","Recycle Water","Total Inlet Into Area 100","Nutrients","Make-up Water","CO2","Evaporation","CO2 (From outside of Facility)","Algae to Settlers","Clarified Water to Blowdown","Blowdown","Algae","Algae Product","Algae Product","Storage Loss",null,null,null,"Paddlewheel Mixing","Pump to Settlers ","Clarified Water Pump","Inoculum Power","Pump from Settler to Membranes","Membrane Power Requirement","Pump from Membrane to Centrifuge","Centrifuge Power","Pump Return from Central Dewatering","CO2 Heating Power","Make-up Water Pump ","Total"]
["Total Flow","kg/hr",{"$f":"SUM(C145:C154)","v":704.29980651481901},{"$f":"SUM(D145:D154)","v":2222459.5364049394},2090.1456333495557,53819504.779561125,52974.890612718649,1639788.3167568813,2436763.41800708,58534497.070419215,24.329772769136632,38281.025660542444,1482.3796230329585,37714.471084294746,54457.27023575161,{"$f":"'Mass Balance'!P153/INPUT!B15*1000","v":56842791.993032008},{"$f":"SUM(Q145:Q154)","v":54334398.763743654},{"$f":"SUM(R145:R154)","v":514893.98418252246},{"$f":"SUM(S145:S154)","v":2560894.7772986088},{"$f":"SUM(T145:T154)","v":124137.43006676884},123884.48109841399,252.94896835485329,null,null,"kW",{"$f":"'Quick Access Charts'!B48*INPUT!B10/2.47105/24","v":4641.2456243297383},{"$f":"P140/998*998*9.81*(6.61*2.31)/3.28084/(3.6*10^6)/0.67","v":1075.9584321855934},{"$f":"(Q140-R140)/998*998*9.81*(6.61*2.31)*0.42/0.45/3.28084/(3.6*10^6)/0.67","v":950.81618541899695},{"$f":"'Quick Access Charts'!B49*('Quick Access Charts'!B37+'Quick Access Charts'!B38)/24+'Quick Access Charts'!B39*229/24","v":195.18712374603174},{"$f":"(S140)/998*998*9.81*((4.93-1)*14.69*2.31)/3.28084/(3.6*10^6)/0.8593","v":330.10697744862489},{"$f":"S140*0.04/1000/60*60","v":102.43579109194435},{"$f":"(S153*(1-0.005)/(INPUT!$B$30/1000)-S153)/998*998*9.81*((6.61*2.31)*0.59/0.45)/3.28084/(3.6*10^6)/0.8593","v":3.2934437559208729},{"$f":"(S153*(1-0.005)/(INPUT!$B$30/1000))/1000*1.45","v":283.88055512750856},{"$f":"(S140-T140)/998*998*9.81*((6.61*2.31)*4.37/0.45)/3.28084/(3.6*10^6)/0.67","v":447.92087148831553},{"$f":"G140/65057*2541","v":2069.0962855175935},{"$f":"(D140+L140)/998*998*9.81*((12.4-2)*14.69*2.31)/3.28084/(3.6*10^6)/0.67-(D140+L140)/998*998*9.81*((12.4-6)*14.69*2.31)/3.28084/(3.6*10^6)","v":581.26543771835611},{"$f":"SUM(Z140:AJ140)","v":10681.206727828623}]
["Salinity","mg/L",{"$f":"IF(C151>0,C150*1000*1000/C151,0)","v":0},{"$f":"IF(D151>0,D150*1000*1000/D151,0)","v":250.00000000000003},{"$f":"IF(E151>0,E150*1000*1000/(E153/INPUT!B25+N151),0)","v":253.15305438910681},{"$f":"IF(F151>0,F150*1000*1000/F151,0)","v":921.55420373549714},0,0,921.55420373549703,896.15656929441161,0,250,0,0,0,921.55420373549714,921.55420373549691,{"$f":"IF(R151=0,0,R150*1000*1000/R151)","v":921.55420373549703},921.55420373549691,921.55420373549703,921.55420373549703,0,null,null,"Chiller Utility GJ/hr",null,null,null,{"$f":"4.187*4*5*1.06*1000/25*10000/1000/1000*('Quick Access Charts'!B38+'Quick Access Charts'!B39)/24*0.239005736/0.239006","v":16.877483188658399}]
["Is salinity above cell tolerance? ","(1=Yes, 0=No)",{"$f":"IF('Mass Balance'!C141>INPUT!$B$39,1,0)","v":0},{"$f":"IF('Mass Balance'!D141>INPUT!$B$39,1,0)","v":0},{"$f":"IF('Mass Balance'!E141>INPUT!$B$39,1,0)","v":0},{"$f":"IF('Mass Balance'!F141>INPUT!$B$39,1,0)","v":0},{"$f":"IF('Mass Balance'!G141>INPUT!$B$39,1,0)","v":0},{"$f":"IF('Mass Balance'!H141>INPUT!$B$39,1,0)","v":0},{"$f":"IF('Mass Balance'!I141>INPUT!$B$39,1,0)","v":0},{"$f":"IF('Mass Balance'!J141>INPUT!$B$39,1,0)","v":0},{"$f":"IF('Mass Balance'!K141>INPUT!$B$39,1,0)","v":0},{"$f":"IF('Mass Balance'!L141>INPUT!$B$39,1,0)","v":0},{"$f":"IF('Mass Balance'!M141>INPUT!$B$39,1,0)","v":0},{"$f":"IF('Mass Balance'!N141>INPUT!$B$39,1,0)","v":0},{"$f":"IF('Mass Balance'!O141>INPUT!$B$39,1,0)","v":0},{"$f":"IF('Mass Balance'!P141>INPUT!$B$39,1,0)","v":0},{"$f":"IF('Mass Balance'!Q141>INPUT!$B$39,1,0)","v":0},{"$f":"IF('Mass Balance'!R141>INPUT!$B$39,1,0)","v":0},{"$f":"IF('Mass Balance'!S141>INPUT!$B$39,1,0)","v":0},{"$f":"IF('Mass Balance'!T141>INPUT!$B$39,1,0)","v":0},{"$f":"IF('Mass Balance'!U141>INPUT!$B$39,1,0)","v":0},{"$f":"IF('Mass Balance'!V141>INPUT!$B$39,1,0)","v":0}]
[]
[]
["Ammonia","kg/hr",{"$f":"J145-E145-G145-I145-F145+H145-D145","v":474.01011542582273},0,{"$f":"K145+L145+M145-N145-E153/'Quick Access Charts'!B33*'Quick Access Charts'!B7*-1*'Quick Access Charts'!B31","v":3.4009035048410734},{"$f":"P145-S145-R145","v":112.65102569371592},0,0,{"$f":"S145-U145","v":5.0960687228085124},{"$f":"'Quick Access Charts'!F15/(1-INPUT!B20)*'Quick Access Charts'!B31","v":595.15811334718819},{"$f":"(E153/'Quick Access Charts'!B33*'Quick Access Charts'!B7*-1*'Quick Access Charts'!B31)/(1-INPUT!B20)","v":17.004517524205376},0,0,0,0,{"$f":"J145-'Quick Access Charts'!F15*'Quick Access Charts'!B31","v":119.03162266943764},{"$f":"P145-S145","v":113.72876387951419},{"$f":"$R$151/$Q$151*Q145","v":1.077738185798262},{"$f":"S151/P140*P145","v":5.3028587899234463},{"$f":"T151/S151*S145","v":0.20679006711493395},{"$f":"T145","v":0.20679006711493395},0]
["DAP","kg/hr",{"$f":"J146-E146-G146-I146-F146+H146-D146","v":230.28969108899628},0,{"$f":"K146+L146+M146-N146-E153/'Quick Access Charts'!B33*'Quick Access Charts'!B6*-1*'Quick Access Charts'!B30","v":0.73252552449312525},{"$f":"P146-S146-R146","v":24.264067346666447},0,0,1.0976496124381394,{"$f":"'Quick Access Charts'!F16/(1-INPUT!B21)*'Quick Access Charts'!B30","v":256.383933572594},{"$f":"(E153/'Quick Access Charts'!B33*'Quick Access Charts'!B6*-'Quick Access Charts'!B30)/(1-INPUT!B21)","v":7.3252552449312569},0,0,0,0,{"$f":"J146-'Quick Access Charts'!F16*'Quick Access Charts'!B30","v":25.638393357259389},{"$f":"P146-S146","v":24.496202933193484},{"$f":"$R$151/$Q$151*Q146","v":0.23213558652703772},{"$f":"S151/P140*P146","v":1.1421904240659055},{"$f":"S146*T151/S151","v":4.4540811627766019E-2},4.4540811627766019E-2,0]
["O2","kg/hr",0,0,{"$f":"K147+L147+M147-N147+E153/'Quick Access Charts'!B33*'Quick Access Charts'!B9*'Quick Access Charts'!B27","v":0},0,0,{"$f":"J147+'Quick Access Charts'!F19*'Quick Access Charts'!B27","v":41039.702695609172},0,{"$f":"SUM(C147:G147,I147)","v":0},0,0,0,{"$f":"E153/'Quick Access Charts'!B33*'Quick Access Charts'!B9*'Quick Access Charts'!B27","v":1172.5629341602621},0,0,0,0,{"$f":"S151/P140*P147","v":0},0,0,0]
["N2","kg/hr",0,0,{"$f":"K148+L148+M148-N148","v":0},0,0,0,0,{"$f":"SUM(C148:G148,I148)","v":0},0,0,0,0,0,0,0,0,{"$f":"S151/P140*P148","v":0},0,0,0]
["CO2","kg/hr",0,0,{"$f":"K149+L149+M149-N149-E153/'Quick Access Charts'!B33*'Quick Access Charts'!B5*-1*'Quick Access Charts'!B29","v":0},0,{"$f":"'Quick Access Charts'!F17*'Quick Access Charts'!B29/(INPUT!B18)","v":52974.890612718649},{"$f":"J149-'Quick Access Charts'!F17*'Quick Access Charts'!B29","v":5297.4890612718664},0,{"$f":"SUM(C149:G149,I149)","v":52974.890612718649},0,0,{"$f":"E153/'Quick Access Charts'!B33*'Quick Access Charts'!B5*-1*'Quick Access Charts'!B29*'Quick Access Charts'!B37/'Quick Access Charts'!B36/(INPUT!B18)+E153/'Quick Access Charts'!B33*'Quick Access Charts'!B5*-1*'Quick Access Charts'!B29*('Quick Access Charts'!B38+'Quick Access Charts'!B39)/'Quick Access Charts'!B36/INPUT!B19","v":1482.3796230329585},{"$f":"M149-E153/'Quick Access Charts'!B33*'Quick Access Charts'!B5*-1*'Quick Access Charts'!B29","v":120.16815013447899},{"$f":"M149+G149","v":54457.27023575161},0,0,0,{"$f":"S151/P140*P149","v":0},0,0,0,null,null,null,null,null," "]
["Salt (NaCl)","kg/hr",0,{"$f":"D151*INPUT!B38/1000/1000","v":555.4760150974605},{"$f":"K150+L150+M150-N150","v":9.5678644490233538},{"$f":"IFERROR(P150-S150-R150,0)","v":49549.144314516852},0,0,2242.6898001648342,52356.877994228169,0,{"$f":"L151*INPUT!B38/1000/1000","v":9.5678644490233538},0,0,0,{"$f":"IFERROR(J150,0)","v":52356.877994228169},{"$f":"IFERROR(P150*Q151/P151,0)","v":50023.183539393278},474.03922487642785,{"$f":"S151/P151*P150","v":2333.6944548348906},{"$f":"T151/S151*S150","v":91.004654670056368},91.004654670056368,0,null,null,null,null,null," "]
["Water","kg/hr",0,{"$f":"U151+H151+R151-E151+'Quick Access Charts'!F18*'Quick Access Charts'!B26","v":2221904.0603898419},{"$f":"K151+L151+M151-N151-E153/'Quick Access Charts'!B33*'Quick Access Charts'!B8*-1*'Quick Access Charts'!B26","v":1373.04178571429},{"$f":"P151-S151-R151","v":53766934.287392564},0,{"$f":"INPUT!E47*4046.86*INPUT!$B$10/100*1000/24","v":1593451.1250000002},2433595.1060438408,{"$f":"D151+E151+F151+G151+I151","v":58423806.495611958},0,{"$f":"E153/INPUT!B25+N151+E153/'Quick Access Charts'!B33*'Quick Access Charts'!B8*-1*'Quick Access Charts'!B26","v":38271.457796093418},0,{"$f":"INPUT!E47/100*'Quick Access Charts'!B37*10000*1000/24","v":36421.740000000005},0,{"$f":"P140-P153-P154","v":56813671.710248694},{"$f":"P151-S151","v":54281325.326959118},514391.03956655139,{"$f":"S153/INPUT!B27*1000-S153","v":2532346.3832895756},{"$f":"T153/INPUT!B32*1000-T153","v":98751.277245734716},98751.277245734716,0]
["Solids"]
["Algae (AFDW)","kg/hr",0,0,{"$f":"INPUT!E46*'Quick Access Charts'!B36*10000/1000/24","v":686.52089285714283},{"$f":"P153-S153-R153","v":2815.2063747450234},0,0,{"$f":"S153-T153","v":891.43708543072353},4393.1647465160004,0,0,0,0,0,{"$f":"'Quick Access Charts'!F13+J153","v":28421.395996516003},{"$f":"P153-S153","v":2842.1395996516003},{"$f":"$R$151/$Q$151*Q153","v":26.933224906576719},{"$f":"P153*INPUT!B28","v":25579.256396864403},{"$f":"S153*(INPUT!B31)*(INPUT!B33)","v":24687.819311433679},{"$f":"T153-V153","v":24440.941118319341},{"$f":"T153*INPUT!B34","v":246.8781931143368},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Goal Seek for Mass Balance Recycles "]
["Ash","kg/hr",0,0,{"$f":"E153/(1-INPUT!B64)-E153","v":16.881661299765824},{"$f":"P154-S154-R154","v":69.226386264223905},0,0,{"$f":"S154-U154","v":27.991359308485698},{"$f":"SUM(C154:I154)","v":114.09940687247543},0,0,0,0,0,{"$f":"P153/(1-INPUT!$B$64)-P153","v":698.88678679957593},{"$f":"P154-S154","v":69.888678679959412},0.66229241573551223,{"$f":"S153/(1-INPUT!$B$64)-S153","v":628.99810811961652},{"$f":"T153/(1-INPUT!$B$64)-T153","v":607.07752405164865},{"$f":"U153/(1-INPUT!$B$64)-U153","v":601.00674881113082},{"$f":"V153/(1-INPUT!$B$64)-V153","v":6.0707752405164968},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C153:I153)","v":4393.1643530328893},{"$f":"SUM(C150:G150,I150)","v":52356.877994228176},{"$f":"IF(INPUT!B35=\"User defined\",R140,R141)","v":514893.98418252246}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AO154-J153","v":-3.9348311111098155E-4},{"$f":"AP154-J150","v":0},{"$f":"IF(INPUT!B35=\"User defined\",INPUT!E48-AQ154,INPUT!B39*(1-INPUT!B40)-AQ154)","v":1.5817477542441338E-2},{"$f":"SUM(AO155:AQ155)+AQ156","v":1.5423994431330357E-2}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(INPUT!B35=\"User defined\",0,IF(R140=0,AQ155*-1,0))","v":0}]

{"sheet":"OPEX","index":4,"n_rows":87,"n_cols":19,"rows_kept":87,"cut":false,"hidden":false,"merged":[[78,0,78,12],[10,0,10,12],[54,0,54,12],[63,0,63,12]]}
[null,"AVERAGE","SUMMER","FALL","WINTER","SPRING"]
["Dry Algae Biomass Production Rate (kg/hr)",{"$f":"AVERAGE(C2:F2)","v":21470.707025572316},{"$f":"'Mass Balance'!U90","v":30032.182752221805},{"$f":"'Mass Balance'!U111","v":21370.908768322683},{"$f":"'Mass Balance'!U132","v":10038.795463425427},{"$f":"'Mass Balance'!U153","v":24440.941118319341},null," "]
["BIOMASS Production Rate (MM US Dry Ton/yr)",{"$f":"B2*2.205/2000*B7/1000000","v":0.18747791960589236},{"$f":"C2*2.205/2000*$B$7/1000000","v":0.26223501335585037},{"$f":"D2*2.205/2000*$B$7/1000000","v":0.18660650118324001},8.7656754227538158E-2,0.21341340965694081]
[" "," "]
["Operating Cost Analysis"]
[]
["Operating Hours/Yr",{"$f":"INPUT!B71","v":7920}]
[]
["Variable Operating Costs"]
[null,"Costing Code","Raw Material","Stream No.","kg/hr","lb/hr","Quoted Price (cents / ton)","Year of Price Quote",{"$f":"INPUT!B70 &\" (Cost $ / ton)\"","v":"2014 (Cost $ / ton)"},{"$f":"costyear & \" Cost ($/lb)\"","v":"2014 Cost ($/lb)"},"$/hour",{"$f":"\"MM$/yr (\" & INPUT!B70 & \")\"","v":"MM$/yr (2014)"},{"$f":"\"$/Dry US Ton Algae (\"&INPUT!B70&\")\"","v":"$/Dry US Ton Algae (2014)"}]
["Raw Materials"]
["A100",null,"CO2 cost","Summer ",{"$f":"'Mass Balance'!O86","v":66877.349412326526},{"$f":"E12*2.205","v":147464.55545417999},{"$f":"INPUT!$B$77*907/1000*100","v":4081.5},2011,{"$f":"G12*VLOOKUP(INPUT!$B$70,'Quick Access Charts'!$O$37:$P$75,2,FALSE)/VLOOKUP(H12,'Quick Access Charts'!$O$37:$P$75,2,FALSE)/100","v":43.583490678302262},{"$f":"I12/2000","v":2.1791745339151132E-2},{"$f":"F12*J12","v":3213.5100390086204},{"$f":"K12*$B$7/1000000","v":25.450999508948275},{"$f":"L12/$C$3","v":97.05416215496561}]
[null,null,null,"Fall",{"$f":"'Mass Balance'!O107","v":47578.457153340874},{"$f":"E13*2.205","v":104910.49802311663},{"$f":"INPUT!$B$77*907/1000*100","v":4081.5},2011,{"$f":"G13*VLOOKUP(INPUT!$B$70,'Quick Access Charts'!$O$37:$P$75,2,FALSE)/VLOOKUP(H13,'Quick Access Charts'!$O$37:$P$75,2,FALSE)/100","v":43.583490678302262},{"$f":"I13/2000","v":2.1791745339151132E-2},{"$f":"F13*J13","v":2286.1828563232757},{"$f":"K13*$B$7/1000000","v":18.106568222080341},{"$f":"L13/$D$3","v":97.030747092248546}]
[null,null,null,"Winter",{"$f":"'Mass Balance'!O128","v":22356.142517834862},49295.294251825871,{"$f":"INPUT!$B$77*907/1000*100","v":4081.5},2011,{"$f":"G14*VLOOKUP(INPUT!$B$70,'Quick Access Charts'!$O$37:$P$75,2,FALSE)/VLOOKUP(H14,'Quick Access Charts'!$O$37:$P$75,2,FALSE)/100","v":43.583490678302262},2.1791745339151132E-2,1074.23049875431,8.5079055501341347,{"$f":"L14/$E$3","v":97.059326746795051}]
[null,null,null,"Spring ",{"$f":"'Mass Balance'!O149","v":54457.27023575161},120078.28086983231,{"$f":"INPUT!$B$77*907/1000*100","v":4081.5},2011,{"$f":"G15*VLOOKUP(INPUT!$B$70,'Quick Access Charts'!$O$37:$P$75,2,FALSE)/VLOOKUP(H15,'Quick Access Charts'!$O$37:$P$75,2,FALSE)/100","v":43.583490678302262},2.1791745339151132E-2,2616.7153174784489,20.724385314429316,{"$f":"L15/$F$3","v":97.109105504398656}]
[null,null,null,"AVERAGE",{"$f":"AVERAGE(E12:E15)","v":47817.304829813467},{"$f":"AVERAGE(F12:F15)","v":105437.1571497387},{"$f":"AVERAGE(G12:G15)","v":4081.5},2011,{"$f":"AVERAGE(I12:I15)","v":43.583490678302262},{"$f":"AVERAGE(J12:J15)","v":2.1791745339151132E-2},{"$f":"AVERAGE(K12:K15)","v":2297.6596778911639},{"$f":"AVERAGE(L12:L15)","v":18.197464648898016},{"$f":"L16/$B$3","v":97.064575322533486}]
[]
["A100",null,"Ammonia","Summer ",{"$f":"'Mass Balance'!C82+'Mass Balance'!K82","v":602.31325009457828},{"$f":"E18*2.205","v":1328.1007164585451},77230,2011,{"$f":"G18*VLOOKUP(INPUT!$B$70,'Quick Access Charts'!$O$37:$P$75,2,FALSE)/VLOOKUP(H18,'Quick Access Charts'!$O$37:$P$75,2,FALSE)/100","v":824.68528361761219},{"$f":"I18/2000","v":0.41234264180880609},{"$f":"J18*F18","v":547.63255801268463},{"$f":"K18*$B$7/1000000","v":4.3372498594604618},{"$f":"L18/$C$3","v":16.539552838334583}]
[null,null,null,"Fall",{"$f":"'Mass Balance'!C103+'Mass Balance'!K103","v":428.2945132911081},{"$f":"E19*2.205","v":944.38940180689337},77230,2011,{"$f":"G19*VLOOKUP(INPUT!$B$70,'Quick Access Charts'!$O$37:$P$75,2,FALSE)/VLOOKUP(H19,'Quick Access Charts'!$O$37:$P$75,2,FALSE)/100","v":824.68528361761219},{"$f":"I19/2000","v":0.41234264180880609},{"$f":"J19*F19","v":389.41202083729246},{"$f":"K19*$B$7/1000000","v":3.0841432050313564},{"$f":"L19/$D$3","v":16.527522811238249}]
[null,null,null,"Winter",{"$f":"'Mass Balance'!C124+'Mass Balance'!K124","v":201.3663077091586},444.01270849869474,77230,2011,{"$f":"G20*VLOOKUP(INPUT!$B$70,'Quick Access Charts'!$O$37:$P$75,2,FALSE)/VLOOKUP(H20,'Quick Access Charts'!$O$37:$P$75,2,FALSE)/100","v":824.68528361761219},0.41234264180880609,183.08537321903512,1.4500361558947581,{"$f":"L20/$E$3","v":16.542206800525317}]
[null,null,null,"Spring ",{"$f":"'Mass Balance'!C145+'Mass Balance'!K145","v":491.0146329500281},1082.6872656548121,77230,2011,{"$f":"G21*VLOOKUP(INPUT!$B$70,'Quick Access Charts'!$O$37:$P$75,2,FALSE)/VLOOKUP(H21,'Quick Access Charts'!$O$37:$P$75,2,FALSE)/100","v":824.68528361761219},0.41234264180880609,446.43812737285788,3.5357899687930345,{"$f":"L21/$F$3","v":16.567796627572605}]
[null,null,null,"AVERAGE",{"$f":"AVERAGE(E18:E21)","v":430.74717601121824},{"$f":"AVERAGE(F18:F21)","v":949.79752310473634},{"$f":"AVERAGE(G18:G21)","v":77230},{"$f":"AVERAGE(H18:H21)","v":2011},{"$f":"AVERAGE(I18:I21)","v":824.68528361761219},{"$f":"AVERAGE(J18:J21)","v":0.41234264180880609},{"$f":"AVERAGE(K18:K21)","v":391.64201986046754},{"$f":"AVERAGE(L18:L21)","v":3.1018047972949025},{"$f":"L22/$B$3","v":16.544907281963535}]
[]
["A100",null,"Diammonium Phosphate","Summer ",{"$f":"'Mass Balance'!C83+'Mass Balance'!K83","v":291.6598169264484},{"$f":"E24*2.205","v":643.10989632281871},63000,2011,{"$f":"G24*VLOOKUP(INPUT!$B$70,'Quick Access Charts'!$O$37:$P$75,2,FALSE)/VLOOKUP(H24,'Quick Access Charts'!$O$37:$P$75,2,FALSE)/100","v":672.7330424434748},{"$f":"I24/2000","v":0.33636652122173738},{"$f":"J24*F24","v":216.32063858937872},{"$f":"K24*$B$7/1000000","v":1.7132594576278795},{"$f":"L24/$C$3","v":6.533297883082466}]
[null,null,null,"Fall",{"$f":"'Mass Balance'!C104+'Mass Balance'!K104","v":207.45025186261495},{"$f":"E25*2.205","v":457.42780535706595},63000,2011,{"$f":"G25*VLOOKUP(INPUT!$B$70,'Quick Access Charts'!$O$37:$P$75,2,FALSE)/VLOOKUP(H25,'Quick Access Charts'!$O$37:$P$75,2,FALSE)/100","v":672.7330424434748},{"$f":"I25/2000","v":0.33636652122173738},{"$f":"J25*F25","v":153.86339959805028},{"$f":"K25*$B$7/1000000","v":1.2185981248165583},{"$f":"L25/$D$3","v":6.5303090572388172}]
[null,null,null,"Winter",{"$f":"'Mass Balance'!C125+'Mass Balance'!K125","v":97.502361107742914},214.99270624257312,63000,2011,{"$f":"G26*VLOOKUP(INPUT!$B$70,'Quick Access Charts'!$O$37:$P$75,2,FALSE)/VLOOKUP(H26,'Quick Access Charts'!$O$37:$P$75,2,FALSE)/100","v":672.7330424434748},0.33636652122173738,72.316348686861218,{"$f":"K26*$B$7/1000000","v":0.57274548159994076},{"$f":"L26/$E$3","v":6.5339572135333253}]
[null,null,null,"Spring ",{"$f":"'Mass Balance'!C146+'Mass Balance'!K146","v":237.61494633392755},523.94095666631029,63000,2011,{"$f":"G27*VLOOKUP(INPUT!$B$70,'Quick Access Charts'!$O$37:$P$75,2,FALSE)/VLOOKUP(H27,'Quick Access Charts'!$O$37:$P$75,2,FALSE)/100","v":672.7330424434748},0.33636652122173738,176.23619691943586,{"$f":"K27*$B$7/1000000","v":1.3957906796019319},{"$f":"L27/$F$3","v":6.5403138530312912}]
[null,null,null,"AVERAGE",{"$f":"AVERAGE(E24:E27)","v":208.55684405768346},{"$f":"AVERAGE(F24:F27)","v":459.86784114719205},{"$f":"AVERAGE(G24:G27)","v":63000},{"$f":"AVERAGE(H24:H27)","v":2011},{"$f":"AVERAGE(I24:I27)","v":672.7330424434748},{"$f":"AVERAGE(J24:J27)","v":0.33636652122173738},{"$f":"AVERAGE(K24:K27)","v":154.68414594843151},{"$f":"AVERAGE(L24:L27)","v":1.2250984359115775},{"$f":"L28/$B$3","v":6.5346278563732962}]
[]
["A100",null,"Salt Disposal Cost","Summer ",{"$f":"IF(INPUT!B16=\"Saltwater\",'Mass Balance'!R77/1*1000/100/100/100,0)","v":0},"m^3/hr",1.5,2009,{"$f":"G30*VLOOKUP(INPUT!$B$70,'Quick Access Charts'!$O$37:$P$75,2,FALSE)/VLOOKUP(H30,'Quick Access Charts'!$O$37:$P$75,2,FALSE)","v":1.7970627503337782},"$/m3",{"$f":"I30*E30","v":0},{"$f":"K30*$B$7/1000000","v":0},{"$f":"L30/$C$3","v":0}]
[null,null,null,"Fall",{"$f":"IF(INPUT!B16=\"Saltwater\",'Mass Balance'!R98/1*1000/100/100/100,0)","v":0},"m^3/hr",1.5,2009,{"$f":"G31*VLOOKUP(INPUT!$B$70,'Quick Access Charts'!$O$37:$P$75,2,FALSE)/VLOOKUP(H31,'Quick Access Charts'!$O$37:$P$75,2,FALSE)","v":1.7970627503337782},"$/m3",{"$f":"I31*E31","v":0},{"$f":"K31*$B$7/1000000","v":0},{"$f":"L31/$C$3","v":0}]
[null,null,null,"Winter",{"$f":"IF(INPUT!B16=\"Saltwater\",'Mass Balance'!R119/1*1000/100/100/100,0)","v":0},"m^3/hr",1.5,2009,{"$f":"G32*VLOOKUP(INPUT!$B$70,'Quick Access Charts'!$O$37:$P$75,2,FALSE)/VLOOKUP(H32,'Quick Access Charts'!$O$37:$P$75,2,FALSE)","v":1.7970627503337782},"$/m3",0,0,0]
[null,null,null,"Spring ",{"$f":"IF(INPUT!B16=\"Saltwater\",'Mass Balance'!R140/1*1000/100/100/100,0)","v":0},"m^3/hr",1.5,2009,{"$f":"G33*VLOOKUP(INPUT!$B$70,'Quick Access Charts'!$O$37:$P$75,2,FALSE)/VLOOKUP(H33,'Quick Access Charts'!$O$37:$P$75,2,FALSE)","v":1.7970627503337782},"$/m3",0,0,0]
[null,null,null,"AVERAGE",{"$f":"AVERAGE(E30:E33)","v":0},"m^3/hr",{"$f":"AVERAGE(G30:G33)","v":1.5},2009,1.7970627503337782,"$/m3",0,0,{"$f":"L34/$B$3","v":0}]
[]
["A600",null,"Power ","Summer ",{"$f":"'Mass Balance'!AK77","v":11622.574426597861},"kW","fixed",2014,6.8199999999999997E-2,"$/kWh",{"$f":"I36*E36","v":792.65957589397408},{"$f":"K36*$B$7/1000000","v":6.2778638410802747},{"$f":"L36/$C$3","v":23.939838394353824}]
[null,null,null,"Fall",{"$f":"'Mass Balance'!AK98","v":9576.4768896351179},"kW","fixed",2014,6.8199999999999997E-2,"$/kWh",{"$f":"I37*E37","v":653.11572387311503},{"$f":"K37*$B$7/1000000","v":5.1726765330750712},{"$f":"L37/$D$3","v":27.719701619589944}]
[null,null,null,"Winter",{"$f":"'Mass Balance'!AK119","v":7118.190838157504},"kW","fixed",2014,6.8199999999999997E-2,"$/kWh",{"$f":"I38*E38","v":485.46061516234175},{"$f":"K38*$B$7/1000000","v":3.8448480720857465},{"$f":"L38/$E$3","v":43.862542093508786}]
[null,null,null,"Spring ",{"$f":"'Mass Balance'!AK140","v":10681.206727828623},"kW","fixed",2014,6.8199999999999997E-2,"$/kWh",{"$f":"I39*E39","v":728.45829883791203},{"$f":"K39*$B$7/1000000","v":5.7693897267962626},{"$f":"L39/$F$3","v":27.033866972419769}]
[null,null,null,"AVERAGE",{"$f":"AVERAGE(E36:E39)","v":9749.6122205547763},"kW","fixed",2014,{"$f":"AVERAGE(I36:I39)","v":6.8199999999999997E-2},"$/kWh",{"$f":"I40*E40","v":664.92355344183568},{"$f":"AVERAGE(L36:L39)","v":5.2661945432593384},{"$f":"L40/$B$3","v":28.089678797000179}]
[]
["A600",null,"Chiller Utility","Summer ",{"$f":"'Mass Balance'!AC78","v":16.877483188658399},"GJ/h",{"$f":"3.3*100","v":330},2003,{"$f":"G42*VLOOKUP(INPUT!$B$70,'Quick Access Charts'!$O$37:$P$75,2,FALSE)/VLOOKUP(H42,'Quick Access Charts'!$O$37:$P$75,2,FALSE)","v":539.70838396111787},"¢/GJ",{"$f":"I42*E42/100","v":91.089191770817592},{"$f":"K42*$B$7/1000000","v":0.72142639882487536},{"$f":"L42/$C$3","v":2.7510681719908496}]
[null,null,null,"Fall",{"$f":"'Mass Balance'!AC99","v":16.877483188658399},"GJ/h",{"$f":"3.3*100","v":330},2003,{"$f":"G43*VLOOKUP(INPUT!$B$70,'Quick Access Charts'!$O$37:$P$75,2,FALSE)/VLOOKUP(H43,'Quick Access Charts'!$O$37:$P$75,2,FALSE)","v":539.70838396111787},"¢/GJ",{"$f":"I43*E43/100","v":91.089191770817592},{"$f":"K43*$B$7/1000000","v":0.72142639882487536},{"$f":"L43/$D$3","v":3.8660303593413601}]
[null,null,null,"Winter",{"$f":"'Mass Balance'!AC120","v":16.877483188658399},"GJ/h",330,2003,{"$f":"G44*VLOOKUP(INPUT!$B$70,'Quick Access Charts'!$O$37:$P$75,2,FALSE)/VLOOKUP(H44,'Quick Access Charts'!$O$37:$P$75,2,FALSE)","v":539.70838396111787},"¢/GJ",91.089191770817592,0.72142639882487536,{"$f":"L44/$E$3","v":8.2301290434757259}]
[null,null,null,"Spring ",{"$f":"'Mass Balance'!AC141","v":16.877483188658399},"GJ/h",330,2003,{"$f":"G45*VLOOKUP(INPUT!$B$70,'Quick Access Charts'!$O$37:$P$75,2,FALSE)/VLOOKUP(H45,'Quick Access Charts'!$O$37:$P$75,2,FALSE)","v":539.70838396111787},"¢/GJ",91.089191770817592,0.72142639882487536,{"$f":"L45/$F$3","v":3.3804173785731582}]
[null,null,null,"AVERAGE",{"$f":"AVERAGE(E42:E45)","v":16.877483188658399},"GJ/h",330,2003,{"$f":"AVERAGE(I42:I45)","v":539.70838396111787},"¢/GJ",91.089191770817592,{"$f":"AVERAGE(L42:L45)","v":0.72142639882487536},{"$f":"L46/$B$3","v":3.8480606161057551}]
[]
["A600",null,"Makeup Water","Summer ",{"$f":"'Mass Balance'!D77+'Mass Balance'!L77","v":1222751.3113682424},{"$f":"E48*2.205","v":2696166.6415669746},0,2004,{"$f":"G48*VLOOKUP(INPUT!$B$70,'Quick Access Charts'!$O$37:$P$75,2,FALSE)/VLOOKUP(H48,'Quick Access Charts'!$O$37:$P$75,2,FALSE)/100","v":0},{"$f":"I48/2000","v":0},{"$f":"F48*J48","v":0},{"$f":"K48*$B$7/1000000","v":0},{"$f":"L48/$C$3","v":0}]
[null,null,"(Sourced from groundwater)","Fall",{"$f":"'Mass Balance'!D98+'Mass Balance'!L98","v":520033.83271029987},{"$f":"E49*2.205","v":1146674.6011262112},0,2004,{"$f":"G49*VLOOKUP(INPUT!$B$70,'Quick Access Charts'!$O$37:$P$75,2,FALSE)/VLOOKUP(H49,'Quick Access Charts'!$O$37:$P$75,2,FALSE)/100","v":0},{"$f":"I49/2000","v":0},{"$f":"F49*J49","v":0},{"$f":"K49*$B$7/1000000","v":0},{"$f":"L49/$D$3","v":0}]
[null,null,null,"Winter",{"$f":"'Mass Balance'!D119+'Mass Balance'!L119","v":461444.26277222182},1017484.5994127492,0,2004,{"$f":"G50*VLOOKUP(INPUT!$B$70,'Quick Access Charts'!$O$37:$P$75,2,FALSE)/VLOOKUP(H50,'Quick Access Charts'!$O$37:$P$75,2,FALSE)/100","v":0},0,0,{"$f":"K50*$B$7/1000000","v":0},{"$f":"L50/$E$3","v":0}]
[null,null,null,"Spring ",{"$f":"'Mass Balance'!D140+'Mass Balance'!L140","v":2260740.5620654817},4984932.9393543871,0,2004,{"$f":"G51*VLOOKUP(INPUT!$B$70,'Quick Access Charts'!$O$37:$P$75,2,FALSE)/VLOOKUP(H51,'Quick Access Charts'!$O$37:$P$75,2,FALSE)/100","v":0},0,0,{"$f":"K51*$B$7/1000000","v":0},{"$f":"L51/$F$3","v":0}]
[null,null,null,"AVERAGE",{"$f":"AVERAGE(E48:E51)","v":1116242.4922290614},{"$f":"AVERAGE(F48:F51)","v":2461314.6953650806},{"$f":"AVERAGE(G48:G51)","v":0},{"$f":"AVERAGE(H48:H51)","v":2004},{"$f":"AVERAGE(I48:I51)","v":0},{"$f":"AVERAGE(J48:J51)","v":0},{"$f":"AVERAGE(K48:K51)","v":0},{"$f":"AVERAGE(L48:L51)","v":0},{"$f":"L52/$B$3","v":0}]
[]
[null,null,"Subtotal",null,null,null,null,null,null,null,{"$f":"SUM(K52,K46,K40,K28,K22,K16,K34)","v":3599.9985889127165},{"$f":"SUM(L52,L46,L40,L28,L22,L16,L34)","v":28.511988824188709},{"$f":"SUM(M52,M46,M40,M28,M22,M16,M34)","v":152.08184987397624}]
["By-Products and Credits"]
[]
[]
[null,null,"Subtotal",null,null,null,null,null,null,null,{"$f":"SUM(K56:K57)","v":0},{"$f":"SUM(L56:L57)","v":0},{"$f":"SUM(M56:M57)","v":0}]
[null,null,"Total Variable Operating Costs",null,null,null,null,null,null,null,{"$f":"K54-K58","v":3599.9985889127165},{"$f":"L54-L58","v":28.511988824188709},{"$f":"M54-M58","v":152.08184987397624}]
[]
[]
["Fixed Operating Costs"]
[null,null,"Position","Salary","Year of salary quote",{"$f":"INPUT!B70 & \" Salary\"","v":"2014 Salary"},"# Required","Total",{"$f":"INPUT!B70 & \" Cost\"","v":"2014 Cost"},null,null,{"$f":"L10","v":"MM$/yr (2014)"},{"$f":"M10","v":"$/Dry US Ton Algae (2014)"}]
["Labor & Supervision"]
[null,null,"Plant Manager",155400,2011,{"$f":"(D65)*VLOOKUP(INPUT!$B$70,'Quick Access Charts'!$O$78:$P$106,2,FALSE)/VLOOKUP(E65,'Quick Access Charts'!$O$78:$P$106,2,FALSE)","v":155617.24137931032},1,{"$f":"G65*F65","v":155617.24137931032},{"$f":"F65*G65","v":155617.24137931032},null,null,null,null,null,"Pond size","ponds/operator","ponds/module","ponds","operators"]
[null,null,"Plant Engineer (civil)",82050,2014,{"$f":"(D66)*VLOOKUP(INPUT!$B$70,'Quick Access Charts'!$O$78:$P$106,2,FALSE)/VLOOKUP(E66,'Quick Access Charts'!$O$78:$P$106,2,FALSE)","v":82050},2,{"$f":"G66*D66","v":164100},{"$f":"F66*G66","v":164100},null,null,null,null,null,2.2000000000000002,30,44,{"$f":"Q66*INPUT!$B$10/INPUT!$B$11","v":2200},{"$f":"Q66*INPUT!$B$10/INPUT!$B$11/P66","v":73.333333333333329}]
[null,null,"Plant Engineer (environmental)",83360,2014,{"$f":"(D67)*VLOOKUP(INPUT!$B$70,'Quick Access Charts'!$O$78:$P$106,2,FALSE)/VLOOKUP(E67,'Quick Access Charts'!$O$78:$P$106,2,FALSE)","v":83360},2,166720,166720,null,null,null,null,null,10,9,10,{"$f":"Q67*INPUT!$B$10/INPUT!$B$11","v":500},{"$f":"Q67*INPUT!$B$10/INPUT!$B$11/P67","v":55.555555555555557}]
[null,null,"Maintenance Supr",60257,2011,{"$f":"(D68)*VLOOKUP(INPUT!$B$70,'Quick Access Charts'!$O$78:$P$106,2,FALSE)/VLOOKUP(E68,'Quick Access Charts'!$O$78:$P$106,2,FALSE)","v":60341.23625349487},1,60257,60341.23625349487,null,null,null,null,null,48.6,3,2,{"$f":"Q68*INPUT!$B$10/INPUT!$B$11","v":100},{"$f":"Q68*INPUT!$B$10/INPUT!$B$11/P68","v":33.333333333333336}]
[null,null,"Maintenance Tech",42286,2011,{"$f":"(D69)*VLOOKUP(INPUT!$B$70,'Quick Access Charts'!$O$78:$P$106,2,FALSE)/VLOOKUP(E69,'Quick Access Charts'!$O$78:$P$106,2,FALSE)","v":42345.113699906797},{"$f":"ROUNDUP(IF(INPUT!$B$12=\"2-acre\",S75,IF(INPUT!$B$12=\"10-acre\",S76,IF(INPUT!$B$12=\"50-acre\",S78,0))),0)","v":12},{"$f":"G69*D69","v":507432},508141.36439888156,null,null,null,null,null,50,3,2,{"$f":"Q69*INPUT!$B$10/INPUT!$B$11","v":100},{"$f":"Q69*INPUT!$B$10/INPUT!$B$11/P69","v":33.333333333333336}]
[null,null,"Lab Manager",59200,2011,{"$f":"(D70)*VLOOKUP(INPUT!$B$70,'Quick Access Charts'!$O$78:$P$106,2,FALSE)/VLOOKUP(E70,'Quick Access Charts'!$O$78:$P$106,2,FALSE)","v":59282.758620689652},1,59200,59282.758620689652]
[null,null,"Lab Technician",42286,2011,{"$f":"(D71)*VLOOKUP(INPUT!$B$70,'Quick Access Charts'!$O$78:$P$106,2,FALSE)/VLOOKUP(E71,'Quick Access Charts'!$O$78:$P$106,2,FALSE)","v":42345.113699906797},{"$f":"ROUNDUP(0.1*IF(INPUT!$B$12=\"2-acre\",R66,IF(INPUT!$B$12=\"10-acre\",R67,IF(INPUT!$B$12=\"50-acre\",R69,0)))/O72,0)","v":1},{"$f":"G71*D71","v":42286},42345.113699906797,null,null,null,null,null,"ponds/lab tech"]
[null,null,"Shift Supervisor",50743,2011,{"$f":"(D72)*VLOOKUP(INPUT!$B$70,'Quick Access Charts'!$O$78:$P$106,2,FALSE)/VLOOKUP(E72,'Quick Access Charts'!$O$78:$P$106,2,FALSE)","v":50813.936160298217},4,202972,203255.74464119287,null,null,null,null,null,55]
[null,null,"Module operator - Production",26910,2014,{"$f":"(D73)*VLOOKUP(INPUT!$B$70,'Quick Access Charts'!$O$78:$P$106,2,FALSE)/VLOOKUP(E73,'Quick Access Charts'!$O$78:$P$106,2,FALSE)","v":26909.999999999996},{"$f":"ROUNDUP(IF(INPUT!$B$12=\"2-acre\",S66,IF(INPUT!$B$12=\"10-acre\",S67,IF(INPUT!$B$12=\"50-acre\",S69,0))),0)","v":56},{"$f":"G73*D73","v":1506960},1506959.9999999998]
[null,null,"Module operator - Innoculum",44100,2014,{"$f":"(D74)*VLOOKUP(INPUT!$B$70,'Quick Access Charts'!$O$78:$P$106,2,FALSE)/VLOOKUP(E74,'Quick Access Charts'!$O$78:$P$106,2,FALSE)","v":44100},{"$f":"ROUNDUP(41*0.172,0)","v":8},352800,352800,null,null,null,null,null,"Pond size","ponds/maint. tech","ponds/module","ponds","Maint. techs"]
[null,null,"Module operator - Dewatering",38590,2014,{"$f":"(D75)*VLOOKUP(INPUT!$B$70,'Quick Access Charts'!$O$78:$P$106,2,FALSE)/VLOOKUP(E75,'Quick Access Charts'!$O$78:$P$106,2,FALSE)","v":38590},9,347310,347310,null,null,null,null,null,2.2000000000000002,{"$f":"P66*5","v":150},44,{"$f":"Q75*INPUT!$B$10/INPUT!$B$11","v":2200},{"$f":"Q75*INPUT!$B$10/INPUT!$B$11/P75","v":14.666666666666666}]
[null,null,"Clerks & Secretaries",38057,2011,{"$f":"(D76)*VLOOKUP(INPUT!$B$70,'Quick Access Charts'!$O$78:$P$106,2,FALSE)/VLOOKUP(E76,'Quick Access Charts'!$O$78:$P$106,2,FALSE)","v":38110.201770736247},3,114171,114330.60531220873,null,null,null,null,null,10,{"$f":"P67*5","v":45},10,{"$f":"Q76*INPUT!$B$10/INPUT!$B$11","v":500},{"$f":"Q76*INPUT!$B$10/INPUT!$B$11/P76","v":11.111111111111111}]
[null,null,"Total Salaries",null,null,null,{"$f":"SUM(G65:G76)","v":100},{"$f":"SUM(H65:H76)","v":3679825.2413793104},{"$f":"SUM(I65:I76)","v":3681204.0643056845},null,null,{"$f":"I77/1000000","v":3.6812040643056845},{"$f":"(L77)/$B$3","v":19.635400649015875},null,48.6,{"$f":"P68*5","v":15},2,{"$f":"Q77*INPUT!$B$10/INPUT!$B$11","v":100},{"$f":"Q77*INPUT!$B$10/INPUT!$B$11/P77","v":6.666666666666667}]
[null,null,"Labor Burden (90%)",null,null,null,null,{"$f":"0.9*H77","v":3311842.7172413794},{"$f":"0.9*I77","v":3313083.657875116},null,null,{"$f":"I78/1000000","v":3.3130836578751159},{"$f":"(L78)/$B$3","v":17.671860584114285},null,50,{"$f":"P69*5","v":15},2,{"$f":"Q78*INPUT!$B$10/INPUT!$B$11","v":100},{"$f":"Q78*INPUT!$B$10/INPUT!$B$11/P78","v":6.666666666666667}]
["Other Fixed Opex"]
[null,null,"Maintenance",0.03,"of Area 500: Dewatering ",5.0000000000000001E-3,"of Area 100, 200, 300, 400",null,{"$f":"DCFROR!M7*OPEX!D80+SUM(DCFROR!O3:O6)*OPEX!F80","v":2214673.301833096},null,null,{"$f":"I80/1000000","v":2.2146733018330957},{"$f":"(L80)/$B$3","v":11.812982064707578}]
[null,null,"Property Insur. & Tax",7.0000000000000001E-3,"of FCI",null,null,null,{"$f":"FCI*OPEX!D81","v":2408131.9503341648},null,null,{"$f":"I81/1000000","v":2.4081319503341647},{"$f":"(L81)/$B$3","v":12.844883042208018}]
[null,null,"Total Fixed Operating Costs",null,null,null,null,null,null,null,null,{"$f":"SUM(L65:L81)","v":11.61709297434806},{"$f":"SUM(M65:M81)","v":61.965126340045757}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"L63","v":"MM$/yr (2014)"},{"$f":"M63","v":"$/Dry US Ton Algae (2014)"}]
["Total Operating Costs",null,null,null,null,null,null,null,null,null,null,{"$f":"L82+L59","v":40.129081798536767},{"$f":"M82+M59","v":214.04697621402198}]

{"sheet":"CAPEX","index":5,"n_rows":83,"n_cols":13,"rows_kept":83,"cut":false,"hidden":false,"merged":[[0,2,1,2],[0,3,1,12]]}
[null,null,null,"Scaled Installed Costs"]
[]
[null,"EQUIPMENT TITLE","$","Year of Quote","Scaling Val","Units","Scaling Exp","Inst Factor","New Val","Size Ratio","Scaled Purch Cost","Purch Cost in Proj year","Inst Cost in Proj year"]
[null,"A100: Production Ponds","Further details behind pond design/cost elements and individual sources for pond inputs can be found in NREL algae farm design report"]
[null,"AVERAGE of 10-acre Costs",158506910,2011,5000,"acre",1,1,{"$f":"IF(INPUT!$B$12=\"10-acre\",IF(INPUT!$B$13=\"Minimally Lined\",INPUT!$B$10,0),0)","v":5000},{"$f":"I5/E5","v":1},{"$f":"C5*J5^G5","v":158506910},{"$f":"K5*VLOOKUP(INPUT!$B$70,'Quick Access Charts'!$O$6:$P$34,2,FALSE)/VLOOKUP(D5,'Quick Access Charts'!$O$6:$P$34,2,FALSE)","v":155908879.7182858},{"$f":"L5*H5","v":155908879.7182858}]
[null,"AVERAGE of 10-acre Costs Full Liner Option",276539009,2011,5000,"acre",1,1,{"$f":"IF(INPUT!$B$12=\"10-acre\",IF(INPUT!$B$13=\"Minimally Lined\",0,INPUT!$B$10),0)","v":0},0,0,{"$f":"K6*VLOOKUP(INPUT!$B$70,'Quick Access Charts'!$O$6:$P$34,2,FALSE)/VLOOKUP(D6,'Quick Access Charts'!$O$6:$P$34,2,FALSE)","v":0},0]
[null,"AVERAGE of 2-acre Costs",246531755,2011,5000,"acre",1,1,{"$f":"IF(INPUT!$B$12=\"2-acre\",IF(INPUT!$B$13=\"Minimally Lined\",INPUT!$B$10,0),0)","v":0},0,0,{"$f":"K7*VLOOKUP(INPUT!$B$70,'Quick Access Charts'!$O$6:$P$34,2,FALSE)/VLOOKUP(D7,'Quick Access Charts'!$O$6:$P$34,2,FALSE)","v":0},0]
[null,"AVERAGE of 2-acre Costs Full Liner Option",365691872,2011,5000,"acre",1,1,{"$f":"IF(INPUT!$B$12=\"2-acre\",IF(INPUT!$B$13=\"Minimally Lined\",0,INPUT!$B$10),0)","v":0},0,0,{"$f":"K8*VLOOKUP(INPUT!$B$70,'Quick Access Charts'!$O$6:$P$34,2,FALSE)/VLOOKUP(D8,'Quick Access Charts'!$O$6:$P$34,2,FALSE)","v":0},0]
[null,"AVERAGE of 50-acre Costs",98673256,2011,5000,"acre",1,1,{"$f":"IF(INPUT!$B$12=\"50-acre\",IF(INPUT!$B$13=\"Minimally Lined\",INPUT!$B$10,0),0)","v":0},0,0,{"$f":"K9*VLOOKUP(INPUT!$B$70,'Quick Access Charts'!$O$6:$P$34,2,FALSE)/VLOOKUP(D9,'Quick Access Charts'!$O$6:$P$34,2,FALSE)","v":0},0]
[null,"AVERAGE of 50-acre Costs Full Liner Option",250468668,2011,5000,"acre",1,1,{"$f":"IF(INPUT!$B$12=\"50-acre\",IF(INPUT!$B$13=\"Minimally Lined\",0,INPUT!$B$10),0)","v":0},0,0,{"$f":"K10*VLOOKUP(INPUT!$B$70,'Quick Access Charts'!$O$6:$P$34,2,FALSE)/VLOOKUP(D10,'Quick Access Charts'!$O$6:$P$34,2,FALSE)","v":0},0]
[null,"Total",null,null,null,null,null,null,null,null,{"$f":"SUM(K5:K10)","v":158506910},{"$f":"SUM(L5:L10)","v":155908879.7182858},155908879.7182858]
[null,"A200: Inocululation System ","See NREL design report for further information"]
[null,"Tubular Photobioreactors ",18.22,2014,1,"m^2",1,1,{"$f":"'Quick Access Charts'!B39*10000*1.5","v":32374.880000000001},{"$f":"I13/E13","v":32374.880000000001},{"$f":"C13*J13^G13","v":589870.31359999999},{"$f":"K13*VLOOKUP(INPUT!$B$70,'Quick Access Charts'!$O$6:$P$34,2,FALSE)/VLOOKUP(D13,'Quick Access Charts'!$O$6:$P$34,2,FALSE)","v":589870.31359999999},{"$f":"L13*H13","v":589870.31359999999}]
[null,"Inoculum Covered Pond Costs (minus liners)",5427316,2014,100,"wetted acres",1,1,{"$f":"'Quick Access Charts'!B38*2.47105","v":22.857127778285719},0.22857127778285719,1240528.5530513453,{"$f":"K14*VLOOKUP(INPUT!$B$70,'Quick Access Charts'!$O$6:$P$34,2,FALSE)/VLOOKUP(D14,'Quick Access Charts'!$O$6:$P$34,2,FALSE)","v":1240528.5530513453},1240528.5530513453]
[null,"Inoculum Lined Pond Costs (minus liners)",5427316,2014,100,"wetted acres",1,1,{"$f":"'Quick Access Charts'!B37*2.47105","v":114.28563889142858},1.1428563889142858,6202642.7652567262,{"$f":"K15*VLOOKUP(INPUT!$B$70,'Quick Access Charts'!$O$6:$P$34,2,FALSE)/VLOOKUP(D15,'Quick Access Charts'!$O$6:$P$34,2,FALSE)","v":6202642.7652567262},6202642.7652567262]
[null,"Lining for Covered Pond",{"$f":"0.65*E16","v":3097827.2},2014,4765888,"ft^2 (per 100 acres as seen from Leidos 2.2 acre fully lined system)",1,1,{"$f":"'Quick Access Charts'!B38*2.47105*4765888/100","v":1089345.1099299856},0.22857127778285719,708074.32145449077,{"$f":"K16*VLOOKUP(INPUT!$B$70,'Quick Access Charts'!$O$6:$P$34,2,FALSE)/VLOOKUP(D16,'Quick Access Charts'!$O$6:$P$34,2,FALSE)","v":708074.32145449077},708074.32145449077]
[null,"Air Supported Greenhouse for Covered Pond",3,2014,1,"ft^2",1,1,{"$f":"'Quick Access Charts'!B38*2.47105*43560*1.1","v":1095222.1346243387},1095222.1346243387,3285666.4038730161,{"$f":"K17*VLOOKUP(INPUT!$B$70,'Quick Access Charts'!$O$6:$P$34,2,FALSE)/VLOOKUP(D17,'Quick Access Charts'!$O$6:$P$34,2,FALSE)","v":3285666.4038730161},3285666.4038730161]
[null,"Lining for Lined Ponds",{"$f":"0.65*E18","v":3097827.2},2014,4765888,"ft^2 (per 100 acres as seen from Leidos 2.2 acre fully lined system)",1,1,{"$f":"'Quick Access Charts'!B37*2.47105/100*CAPEX!E18","v":5446725.5496499278},1.1428563889142858,3540371.6072724531,{"$f":"K18*VLOOKUP(INPUT!$B$70,'Quick Access Charts'!$O$6:$P$34,2,FALSE)/VLOOKUP(D18,'Quick Access Charts'!$O$6:$P$34,2,FALSE)","v":3540371.6072724531},3540371.6072724531]
[null,"Total",null,null,null,null,null,null,null,null,{"$f":"SUM(K13:K18)","v":15567153.964508031},{"$f":"SUM(L13:L18)","v":15567153.964508031},{"$f":"SUM(M13:M18)","v":15567153.964508031}]
[null,"A300: CO2 On-Site Storage and Piping","See NREL design report for further information"]
[null,"Pipeline CO2 Storage Sphere",1400800,2014,68550,"kg/h",0.6,1.25,{"$f":"MAX('Mass Balance'!$O$77,'Mass Balance'!$O$98,'Mass Balance'!$O$119,'Mass Balance'!$O$140)","v":66877.349412326526},{"$f":"I21/E21","v":0.97559955379032137},{"$f":"C21*J21^G21","v":1380190.6750954948},{"$f":"K21*VLOOKUP(INPUT!$B$70,'Quick Access Charts'!$O$6:$P$34,2,FALSE)/VLOOKUP(D21,'Quick Access Charts'!$O$6:$P$34,2,FALSE)","v":1380190.6750954948},{"$f":"L21*H21","v":1725238.3438693685}]
[null,"Storage tank immersion vaporizers",70500,2014,68550,"kg/h",1,1.76,{"$f":"MAX('Mass Balance'!$O$77,'Mass Balance'!$O$98,'Mass Balance'!$O$119,'Mass Balance'!$O$140)","v":66877.349412326526},0.97559955379032137,{"$f":"C22*J22^G22","v":68779.768542217658},{"$f":"K22*VLOOKUP(INPUT!$B$70,'Quick Access Charts'!$O$6:$P$34,2,FALSE)/VLOOKUP(D22,'Quick Access Charts'!$O$6:$P$34,2,FALSE)","v":68779.768542217658},121052.39263430308]
[null,"Trunk line",1661900,2014,68550,"kg/h",1,1,{"$f":"MAX('Mass Balance'!$O$77,'Mass Balance'!$O$98,'Mass Balance'!$O$119,'Mass Balance'!$O$140)","v":66877.349412326526},0.97559955379032137,{"$f":"C23*J23^G23","v":1621348.898444135},{"$f":"K23*VLOOKUP(INPUT!$B$70,'Quick Access Charts'!$O$6:$P$34,2,FALSE)/VLOOKUP(D23,'Quick Access Charts'!$O$6:$P$34,2,FALSE)","v":1621348.898444135},1621348.898444135]
[null,"Branch line",912300,2014,68550,"kg/h",1,1,{"$f":"MAX('Mass Balance'!$O$77,'Mass Balance'!$O$98,'Mass Balance'!$O$119,'Mass Balance'!$O$140)","v":66877.349412326526},0.97559955379032137,{"$f":"C24*J24^G24","v":890039.47292291024},{"$f":"K24*VLOOKUP(INPUT!$B$70,'Quick Access Charts'!$O$6:$P$34,2,FALSE)/VLOOKUP(D24,'Quick Access Charts'!$O$6:$P$34,2,FALSE)","v":890039.47292291024},890039.47292291024]
[null,"Within-plot piping",44200,2014,68550,"kg/h",1,1,{"$f":"MAX('Mass Balance'!$O$77,'Mass Balance'!$O$98,'Mass Balance'!$O$119,'Mass Balance'!$O$140)","v":66877.349412326526},0.97559955379032137,{"$f":"C25*J25^G25*INPUT!B10/INPUT!B11","v":2156075.0138766104},{"$f":"K25*VLOOKUP(INPUT!$B$70,'Quick Access Charts'!$O$6:$P$34,2,FALSE)/VLOOKUP(D25,'Quick Access Charts'!$O$6:$P$34,2,FALSE)","v":2156075.0138766104},2156075.0138766104]
[null,"Supply to Inoculum area",59300,2014,68550,"kg/h",1,1,{"$f":"MAX('Mass Balance'!$O$77,'Mass Balance'!$O$98,'Mass Balance'!$O$119,'Mass Balance'!$O$140)","v":66877.349412326526},0.97559955379032137,{"$f":"C26*J26^G26","v":57853.053539766057},{"$f":"K26*VLOOKUP(INPUT!$B$70,'Quick Access Charts'!$O$6:$P$34,2,FALSE)/VLOOKUP(D26,'Quick Access Charts'!$O$6:$P$34,2,FALSE)","v":57853.053539766057},57853.053539766057]
[]
[null,"Total",null,null,null,null,null,null,null,null,{"$f":"SUM(K21:K27)","v":6174286.882421134},{"$f":"SUM(L21:L27)","v":6174286.882421134},{"$f":"SUM(M21:M27)","v":6571607.175287093}]
[null,"A400: Makeup Water Delivery + On-Site Circulation ",null,"See NREL design report for further information"]
[null,"Channel (aquaducts)",100,2014,1,"acre",1,1,{"$f":"INPUT!B10","v":5000},{"$f":"I30/E30","v":5000},{"$f":"C30*J30^G30","v":500000},{"$f":"K30*VLOOKUP(INPUT!$B$70,'Quick Access Charts'!$O$6:$P$34,2,FALSE)/VLOOKUP(D30,'Quick Access Charts'!$O$6:$P$34,2,FALSE)","v":500000},{"$f":"L30*H30","v":500000}]
[null,"34 in Diameter Pipe",872158,2012,5883,"ft",1,{"$f":"1320300/872158","v":1.5138312094826856},{"$f":"IF(INPUT!B12=\"2-acre\",Facility_Dim!D51,IF(INPUT!B12=\"10-acre\",Facility_Dim!E51,IF(INPUT!B12=\"50-acre\",Facility_Dim!F51,0)))","v":5883},1,{"$f":"C31*J31^G31*J32^G32","v":872158},{"$f":"K31*VLOOKUP(INPUT!$B$70,'Quick Access Charts'!$O$6:$P$34,2,FALSE)/VLOOKUP(D31,'Quick Access Charts'!$O$6:$P$34,2,FALSE)","v":859476.94799863151},{"$f":"L31*H31","v":1301103.0277112557}]
[null,null,null,null,34,"Inches",1.4,null,{"$f":"Facility_Dim!B51","v":34},{"$f":"I32/E32","v":1}]
[null,"26 in Diameter Pipe",852949,2012,9426,"ft",1,{"$f":"1261400/852949","v":1.4788691938204981},{"$f":"IF(INPUT!B12=\"2-acre\",Facility_Dim!D52,IF(INPUT!B12=\"10-acre\",Facility_Dim!E52,IF(INPUT!B12=\"50-acre\",Facility_Dim!F52,0)))","v":9426},1,{"$f":"C33*J33^G33*J34^G34","v":768890.52234391426},{"$f":"K33*VLOOKUP(INPUT!$B$70,'Quick Access Charts'!$O$6:$P$34,2,FALSE)/VLOOKUP(D33,'Quick Access Charts'!$O$6:$P$34,2,FALSE)","v":757710.96462936874},{"$f":"L33*H33","v":1120555.4034103865}]
[null,null,null,null,28,"Inches",1.4,null,{"$f":"Facility_Dim!B52","v":26},0.9285714285714286]
[null,"20 in Diameter Pipe",469386,2012,9990,"ft",1,{"$f":"809600/469386","v":1.7248064492762887},{"$f":"IF(INPUT!B12=\"2-acre\",Facility_Dim!D53,IF(INPUT!B12=\"10-acre\",Facility_Dim!E53,IF(INPUT!B12=\"50-acre\",Facility_Dim!F53,0)))","v":9926},0.99359359359359356,{"$f":"C35*J35^G35*J36^G36","v":466378.92252252251},{"$f":"K35*VLOOKUP(INPUT!$B$70,'Quick Access Charts'!$O$6:$P$34,2,FALSE)/VLOOKUP(D35,'Quick Access Charts'!$O$6:$P$34,2,FALSE)","v":459597.84000209585},{"$f":"L35*H35","v":792717.31850906683}]
[null,null,null,null,20,"Inches",1.4,null,{"$f":"Facility_Dim!B53","v":20},{"$f":"I36/E36","v":1}]
[null,"16 in Diameter Pipe",416554,2012,9360,"ft",1,{"$f":"660100/416554","v":1.5846684943608751},{"$f":"IF(INPUT!B12=\"2-acre\",Facility_Dim!D54,IF(INPUT!B12=\"10-acre\",Facility_Dim!E54,IF(INPUT!B12=\"50-acre\",Facility_Dim!F54,0)))","v":9360},1,{"$f":"C37*J37^G37*J38^G38","v":416554},{"$f":"K37*VLOOKUP(INPUT!$B$70,'Quick Access Charts'!$O$6:$P$34,2,FALSE)/VLOOKUP(D37,'Quick Access Charts'!$O$6:$P$34,2,FALSE)","v":410497.36469380773},{"$f":"L37*H37","v":650502.24084844335}]
[null,null,null,null,16,"Inches",1.4,null,{"$f":"Facility_Dim!B54","v":16},1]
[null,"14 in Diameter Pipe",321593,2012,9360,"ft",1,{"$f":"524500/321593","v":1.6309434595902275},{"$f":"IF(INPUT!B12=\"2-acre\",Facility_Dim!D55,IF(INPUT!B12=\"10-acre\",Facility_Dim!E55,IF(INPUT!B12=\"50-acre\",Facility_Dim!F55,0)))","v":9360},1,{"$f":"C39*J39^G39*J40^G40","v":321593},{"$f":"K39*VLOOKUP(INPUT!$B$70,'Quick Access Charts'!$O$6:$P$34,2,FALSE)/VLOOKUP(D39,'Quick Access Charts'!$O$6:$P$34,2,FALSE)","v":316917.08398905233},{"$f":"L39*H39","v":516873.8453643517}]
[null,null,null,null,14,"Inches",1.4,null,{"$f":"Facility_Dim!B55","v":14},1]
[null,"12 in Diameter Pipe",267709,2012,9360,"ft",1,{"$f":"447700/267709","v":1.672338247873624},{"$f":"IF(INPUT!B12=\"2-acre\",Facility_Dim!D56,IF(INPUT!B12=\"10-acre\",Facility_Dim!E56,IF(INPUT!B12=\"50-acre\",Facility_Dim!F56,0)))","v":9360},1,{"$f":"C41*J41^G41*J42^G42","v":267709},{"$f":"K41*VLOOKUP(INPUT!$B$70,'Quick Access Charts'!$O$6:$P$34,2,FALSE)/VLOOKUP(D41,'Quick Access Charts'!$O$6:$P$34,2,FALSE)","v":263816.54960656859},{"$f":"L41*H41","v":441190.50632911391}]
[null,null,null,null,12,"Inches",2,null,{"$f":"Facility_Dim!B56","v":12},1]
[null,"Make-up water Pipeline",2638100,2009,36,"Inches",1.4,1,{"$f":"ROUND(22*'Mass Balance'!D56/1100481,0)","v":22},{"$f":"I43/E43","v":0.61111111111111116},{"$f":"C43*J43^G43","v":1323913.1807927676},{"$f":"K43*VLOOKUP(INPUT!$B$70,'Quick Access Charts'!$O$6:$P$34,2,FALSE)/VLOOKUP(D43,'Quick Access Charts'!$O$6:$P$34,2,FALSE)","v":1461403.302270001},{"$f":"L43*H43","v":1461403.302270001}]
[null,"Make-up Water Pump",705500,2009,10626,"MM gal/yr",0.6,1,{"$f":"OPEX!E52*0.26417*OPEX!B7/1000000","v":2335.4320110434373},{"$f":"I44/E44","v":0.21978468012831143},{"$f":"C44*J44^G44","v":284246.72418294573},{"$f":"K44*VLOOKUP(INPUT!$B$70,'Quick Access Charts'!$O$6:$P$34,2,FALSE)/VLOOKUP(D44,'Quick Access Charts'!$O$6:$P$34,2,FALSE)","v":313766.11956657411},313766.11956657411]
[]
[]
[null,"Total",null,null,null,null,null,null,null,null,{"$f":"SUM(K30:K44)","v":5221443.3498421498},{"$f":"SUM(L30:L44)","v":5343186.1727561001},{"$f":"SUM(M30:M44)","v":7098111.7640091926}]
[null,"A500: Dewatering","See NREL design report for further information"]
[null,"22-inch Pipe",284880,2014,4300,"LF",1,1,{"$f":"Facility_Dim!J50*INPUT!B10/INPUT!B11","v":168200},{"$f":"I49/E49","v":39.116279069767444},{"$f":"C49*J49^G49","v":11143445.581395349},{"$f":"K49*VLOOKUP(INPUT!$B$70,'Quick Access Charts'!$O$6:$P$34,2,FALSE)/VLOOKUP(D49,'Quick Access Charts'!$O$6:$P$34,2,FALSE)","v":11143445.581395349},{"$f":"L49*H49","v":11143445.581395349}]
[null,"Pumps (costed from ACCE)",121905,2012,6653,"gpm",0.8,{"$f":"188600/163783","v":1.1515236624069654},{"$f":"'Mass Balance'!F77*1000/1000000*264/60*INPUT!B11/INPUT!B10","v":5847.2974866470859},{"$f":"I50/E50","v":0.87889636053616205},{"$f":"C50*J50^G50*INPUT!B10/INPUT!B11","v":5497201.4960094132},{"$f":"K50*VLOOKUP(INPUT!$B$70,'Quick Access Charts'!$O$6:$P$34,2,FALSE)/VLOOKUP(D50,'Quick Access Charts'!$O$6:$P$34,2,FALSE)","v":5417272.97613928},{"$f":"L50*H50","v":6238118.0177421849}]
[null,"Primary Dewatering: Settler",34300,2014,1000,"m3",1,1,{"$f":"SUM('Mass Balance'!P82:P88)/1000*I52","v":279444.09180570062},{"$f":"I51/E51","v":279.44409180570062},{"$f":"C51*J51^G51","v":9584932.3489355315},{"$f":"K51*VLOOKUP(INPUT!$B$70,'Quick Access Charts'!$O$6:$P$34,2,FALSE)/VLOOKUP(D51,'Quick Access Charts'!$O$6:$P$34,2,FALSE)","v":9584932.3489355315},{"$f":"L51*H51","v":9584932.3489355315}]
[null,null,null,null,null,"hr",null,null,{"$f":"INPUT!B29","v":4}]
[null,"Secondary Dewatering: Membranes",{"$f":"238000*20","v":4760000},2014,20000000,"gal/day",1,1,{"$f":"'Mass Balance'!S77*24/3.785","v":19948898.931530241},{"$f":"I53/E53*1.04","v":1.0373427444395726},{"$f":"C53*J53^G53","v":4937751.4635323659},{"$f":"K53*VLOOKUP(INPUT!$B$70,'Quick Access Charts'!$O$6:$P$34,2,FALSE)/VLOOKUP(D53,'Quick Access Charts'!$O$6:$P$34,2,FALSE)","v":4937751.4635323659},{"$f":"L53*H53","v":4937751.4635323659}]
[null,"Membrane other costs",{"$f":"405200*20","v":8104000},2014,20000000,"gal/day",0.6,1,{"$f":"'Mass Balance'!S77*24/3.785","v":19948898.931530241},{"$f":"I54/E54*1.04","v":1.0373427444395726},{"$f":"C54*J54^G54","v":8284242.3720052773},{"$f":"K54*VLOOKUP(INPUT!$B$70,'Quick Access Charts'!$O$6:$P$34,2,FALSE)/VLOOKUP(D54,'Quick Access Charts'!$O$6:$P$34,2,FALSE)","v":8284242.3720052773},{"$f":"L54*H54","v":8284242.3720052773}]
[null,"Tertiary Dewatering: Centrifuge",2242500,2013,463.3,"m3/hr",0.6,1.8,{"$f":"I53*INPUT!B27/INPUT!B30/24*3.785/1000","v":242.00827710205755},{"$f":"I55/E55","v":0.52235760220603833},{"$f":"C55*J55^G55","v":1518844.1175363786},{"$f":"K55*VLOOKUP(INPUT!$B$70,'Quick Access Charts'!$O$6:$P$34,2,FALSE)/VLOOKUP(D55,'Quick Access Charts'!$O$6:$P$34,2,FALSE)","v":1542404.541006007},{"$f":"L55*H55","v":2776328.1738108126}]
[]
[null,"Total",null,null,null,null,null,null,null,null,{"$f":"SUM(K49:K56)","v":40966417.37941432},{"$f":"SUM(L49:L56)","v":40910049.283013806},{"$f":"SUM(M49:M56)","v":42964817.957421519}]
[null,"A600: Storage","See NREL design report for further information"]
[null,"Product Storage Tank",418795,2009,750000,"gal",0.6,{"$f":"478800/418795","v":1.1432801251208826},{"$f":"'Mass Balance'!U56*24/3.785","v":689998.15399575385},{"$f":"I59/E59","v":0.91999753866100509},{"$f":"C59*J59^G59*2","v":796715.89722287888},{"$f":"K59*VLOOKUP(INPUT!$B$70,'Quick Access Charts'!$O$6:$P$34,2,FALSE)/VLOOKUP(D59,'Quick Access Charts'!$O$6:$P$34,2,FALSE)","v":879455.88884863106},{"$f":"L59*H59","v":1005464.4386411599}]
[null,"Firewater Pump",15000,2009,8343,"kg/h",0.8,3.1,{"$f":"8007*'Mass Balance'!U90/21769","v":11046.335950068446},{"$f":"I60/E60","v":1.324024445651258},{"$f":"C60*J60^G60","v":18776.21553498245},{"$f":"K60*VLOOKUP(INPUT!$B$70,'Quick Access Charts'!$O$6:$P$34,2,FALSE)/VLOOKUP(D60,'Quick Access Charts'!$O$6:$P$34,2,FALSE)","v":20726.150162298123},{"$f":"L60*H60","v":64251.065503124184}]
[null,"Firewater Storage Tank",803000,2009,8343,"kg/h",0.7,1.7,{"$f":"I60","v":11046.335950068446},{"$f":"I61/E61","v":1.324024445651258},{"$f":"C61*J61^G61","v":977333.41561245325},{"$f":"K61*VLOOKUP(INPUT!$B$70,'Quick Access Charts'!$O$6:$P$34,2,FALSE)/VLOOKUP(D61,'Quick Access Charts'!$O$6:$P$34,2,FALSE)","v":1078830.7735856187},1834012.3150955518]
[null,"Make-up Storage Tank",418795,2009,750000,"gal",0.6,{"$f":"478800/418795","v":1.1432801251208826},{"$f":"('Mass Balance'!L77+'Mass Balance'!D77)/0.993*6/3.78541/4","v":487940.89981889614},{"$f":"I62/E62","v":0.65058786642519484},{"$f":"C62*J62^G62*4","v":1294330.1119288795},{"$f":"K62*VLOOKUP(INPUT!$B$70,'Quick Access Charts'!$O$6:$P$34,2,FALSE)/VLOOKUP(D62,'Quick Access Charts'!$O$6:$P$34,2,FALSE)","v":1428747.9928764659},1633459.1840620157]
[null,"Tankage BOP",null,null,null,null,null,null,null,null,{"$f":"SUM(K59:K62)*0.2","v":617431.1280598389},{"$f":"SUM(L59:L62)*0.2","v":681552.16109460278},{"$f":"SUM(M59:M62)*0.2","v":907437.40066037036}]
[null,"Total",null,null,null,null,null,null,null,null,{"$f":"SUM(K59:K63)","v":3704586.7683590334},{"$f":"SUM(L59:L63)","v":4089312.9665676164},{"$f":"SUM(M59:M63)","v":5444624.4039622219}]
[]
[]
[]
[null,null,"Flue Gas Distribution"]
[null,"Plot blower",138500,2014,68550,"kg/h",0.6,1.25,{"$f":"'Mass Balance'!G77","v":65056.883208601837},{"$f":"I69/E69","v":0.9490427893304425},{"$f":"C69*J69^G69*INPUT!B10/INPUT!B11","v":6711062.0460423799},{"$f":"K69*VLOOKUP(INPUT!$B$70,'Quick Access Charts'!$O$6:$P$31,2,FALSE)/VLOOKUP(D69,'Quick Access Charts'!$O$6:$P$31,2,FALSE)","v":6711062.0460423799},{"$f":"L69*H69","v":8388827.5575529747}]
[null,"Double branch fan #1",266700,2014,68550,"kg/h",0.6,1.25,{"$f":"'Mass Balance'!G77","v":65056.883208601837},0.9490427893304425,{"$f":"C70*J70^G70*3","v":775382.05675646337},{"$f":"K70*VLOOKUP(INPUT!$B$70,'Quick Access Charts'!$O$6:$P$31,2,FALSE)/VLOOKUP(D70,'Quick Access Charts'!$O$6:$P$31,2,FALSE)","v":775382.05675646337},969227.57094557921]
[null,"Double branch fan #2",254900,2014,68550,"kg/h",0.6,1.25,{"$f":"'Mass Balance'!G77","v":65056.883208601837},0.9490427893304425,{"$f":"C71*J71^G71*3","v":741075.68904095422},{"$f":"K71*VLOOKUP(INPUT!$B$70,'Quick Access Charts'!$O$6:$P$31,2,FALSE)/VLOOKUP(D71,'Quick Access Charts'!$O$6:$P$31,2,FALSE)","v":741075.68904095422},926344.61130119278]
[null,"Double branch fan #3",170200,2014,68550,"kg/h",0.6,1.25,{"$f":"'Mass Balance'!G77","v":65056.883208601837},0.9490427893304425,{"$f":"C72*J72^G72*3","v":494825.74450674938},{"$f":"K72*VLOOKUP(INPUT!$B$70,'Quick Access Charts'!$O$6:$P$31,2,FALSE)/VLOOKUP(D72,'Quick Access Charts'!$O$6:$P$31,2,FALSE)","v":494825.74450674938},618532.18063343677]
[null,"single branch fan #1",124000,2014,68550,"kg/h",0.6,1.25,{"$f":"'Mass Balance'!G77","v":65056.883208601837},0.9490427893304425,{"$f":"C73*J73^G73","v":120169.19764754588},{"$f":"K73*VLOOKUP(INPUT!$B$70,'Quick Access Charts'!$O$6:$P$31,2,FALSE)/VLOOKUP(D73,'Quick Access Charts'!$O$6:$P$31,2,FALSE)","v":120169.19764754588},150211.49705943235]
[null,"single branch fan #2",108100,2014,68550,"kg/h",0.6,1.25,{"$f":"'Mass Balance'!G77","v":65056.883208601837},0.9490427893304425,{"$f":"C74*J74^G74","v":104760.40536854604},{"$f":"K74*VLOOKUP(INPUT!$B$70,'Quick Access Charts'!$O$6:$P$31,2,FALSE)/VLOOKUP(D74,'Quick Access Charts'!$O$6:$P$31,2,FALSE)","v":104760.40536854604},130950.50671068254]
[null,"single branch fan #3",49100,2014,68550,"kg/h",0.6,1.25,{"$f":"'Mass Balance'!G77","v":65056.883208601837},0.9490427893304425,{"$f":"C75*J75^G75","v":47583.125842697598},{"$f":"K75*VLOOKUP(INPUT!$B$70,'Quick Access Charts'!$O$6:$P$31,2,FALSE)/VLOOKUP(D75,'Quick Access Charts'!$O$6:$P$31,2,FALSE)","v":47583.125842697598},59478.907303371998]
[null,"Dbl branch supply fan",266700,2014,68550,"kg/h",0.6,1.25,{"$f":"'Mass Balance'!G77","v":65056.883208601837},0.9490427893304425,{"$f":"C76*J76^G76*9","v":2326146.1702693901},{"$f":"K76*VLOOKUP(INPUT!$B$70,'Quick Access Charts'!$O$6:$P$31,2,FALSE)/VLOOKUP(D76,'Quick Access Charts'!$O$6:$P$31,2,FALSE)","v":2326146.1702693901},2907682.7128367377]
[null,"Single branch supply fan",124000,2014,68550,"kg/h",0.6,1.25,{"$f":"'Mass Balance'!G77","v":65056.883208601837},0.9490427893304425,{"$f":"C77*J77^G77*9","v":1081522.7788279129},{"$f":"K77*VLOOKUP(INPUT!$B$70,'Quick Access Charts'!$O$6:$P$31,2,FALSE)/VLOOKUP(D77,'Quick Access Charts'!$O$6:$P$31,2,FALSE)","v":1081522.7788279129},1351903.4735348911]
[null,"Double branch",2466689,2014,68550,"kg/h",1,1,{"$f":"'Mass Balance'!G77","v":65056.883208601837},0.9490427893304425,{"$f":"C78*J78^G78*3","v":7022980.2269121595},{"$f":"K78*VLOOKUP(INPUT!$B$70,'Quick Access Charts'!$O$6:$P$31,2,FALSE)/VLOOKUP(D78,'Quick Access Charts'!$O$6:$P$31,2,FALSE)","v":7022980.2269121595},7022980.2269121595]
[null,"Single branch",1897272,2014,68550,"kg/h",1,1,{"$f":"'Mass Balance'!G77","v":65056.883208601837},0.9490427893304425,{"$f":"C79*J79^G79","v":1800592.3109985474},{"$f":"K79*VLOOKUP(INPUT!$B$70,'Quick Access Charts'!$O$6:$P$31,2,FALSE)/VLOOKUP(D79,'Quick Access Charts'!$O$6:$P$31,2,FALSE)","v":1800592.3109985474},1800592.3109985474]
[null,"Double supply",7748111,2014,68550,"kg/h",1,1,{"$f":"'Mass Balance'!G77","v":65056.883208601837},0.9490427893304425,{"$f":"C80*J80^G80","v":7353288.875481884},{"$f":"K80*VLOOKUP(INPUT!$B$70,'Quick Access Charts'!$O$6:$P$31,2,FALSE)/VLOOKUP(D80,'Quick Access Charts'!$O$6:$P$31,2,FALSE)","v":7353288.875481884},7353288.875481884]
[null,"Single supply",5472900,2014,68550,"kg/h",1,1,{"$f":"'Mass Balance'!G77","v":65056.883208601837},0.9490427893304425,{"$f":"C81*J81^G81","v":5194016.2817265792},{"$f":"K81*VLOOKUP(INPUT!$B$70,'Quick Access Charts'!$O$6:$P$31,2,FALSE)/VLOOKUP(D81,'Quick Access Charts'!$O$6:$P$31,2,FALSE)","v":5194016.2817265792},{"$f":"L81*H81","v":5194016.2817265792}]
[null,"Within-plot piping",295000,2014,68550,"kg/h",1,1,{"$f":"'Mass Balance'!G77","v":65056.883208601837},0.9490427893304425,{"$f":"C82*J82^G82*INPUT!B10/INPUT!B11","v":13998381.142624028},{"$f":"K82*VLOOKUP(INPUT!$B$70,'Quick Access Charts'!$O$6:$P$31,2,FALSE)/VLOOKUP(D82,'Quick Access Charts'!$O$6:$P$31,2,FALSE)","v":13998381.142624028},13998381.142624028]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(K69:K82)","v":47771786.052045837},{"$f":"SUM(L69:L82)","v":47771786.052045837},{"$f":"SUM(M69:M82)","v":50872417.855621494}]

{"sheet":"Cost Breakdown","index":6,"n_rows":10,"n_cols":9,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,10,1,14]]}
["Portion of MBSP for each cost in each area"]
["AREA",null,"Capital Recovery Charge","Raw Materials & Waste","Process Electricity","Fixed Costs","Area Totals","Labels"]
["NONE",{"$f":"\"Nutrient Cost CO2, NH3, DAP   \" & H3","v":"Nutrient Cost CO2, NH3, DAP   120.1$"},0,{"$f":"SUM(OPEX!M16,OPEX!M22,OPEX!M28)","v":120.14411046087031},0,0,{"$f":"SUM(C3:F3)","v":120.14411046087031},{"$f":"TEXT(G3,\"0.0\") & \"$\"","v":"120.1$"},"Feedstock"]
["A100",{"$f":"\"Production Ponds\" & \"  \" & H4","v":"Production Ponds  250.6$"},{"$f":"CAPEX100/CAPEX*SUM('Results Summary'!$F$24:$F$26)","v":186.91293218379909},{"$f":"OPEX!M46","v":3.8480606161057551},{"$f":"'Mass Balance'!AR59/SUM('Mass Balance'!$AR$59:$AR$64)*OPEX!$M$40","v":18.511078775436768},{"$f":"CAPEX100/CAPEX*OPEX!$M$82","v":41.364583776276838},{"$f":"SUM(C4:F4)","v":250.63665535161846},{"$f":"TEXT(G4,\"0.0\") & \"$\"","v":"250.6$"},"Area 100"]
["A200",{"$f":"\"Inoculum Ponds   \" & H5","v":"Inoculum Ponds   23.4$"},{"$f":"CAPEX200/CAPEX*SUM('Results Summary'!$F$24:$F$26)","v":18.66283946443869},0,{"$f":"'Mass Balance'!AR60/SUM('Mass Balance'!$AR$59:$AR$64)*OPEX!$M$40","v":0.56235504421163296},{"$f":"CAPEX200/CAPEX*OPEX!$M$82","v":4.1301614474211972},{"$f":"SUM(C5:F5)","v":23.35535595607152},{"$f":"TEXT(G5,\"0.0\") & \"$\"","v":"23.4$"},"Area 200"]
["A300",{"$f":"\"CO2 On-Site Storage/Piping   \" & H6","v":"CO2 On-Site Storage/Piping   14.9$"},{"$f":"CAPEX300/CAPEX*SUM('Results Summary'!$F$24:$F$26)","v":7.8784375111441491},0,{"$f":"'Mass Balance'!AR61/SUM('Mass Balance'!$AR$59:$AR$64)*OPEX!$M$40","v":5.234429535499987},{"$f":"CAPEX300/CAPEX*OPEX!$M$82","v":1.7435299133578674},14.856396960002005,"14.9$","Area 300"]
["A400",{"$f":"\"Makeup Water Delivery + On-site Circulation   \" & H7","v":"Makeup Water Delivery + On-site Circulation   11.2$"},{"$f":"CAPEX400/CAPEX*SUM('Results Summary'!$F$24:$F$26)","v":8.509642845080819},0,{"$f":"'Mass Balance'!AR62/SUM('Mass Balance'!$AR$59:$AR$64)*OPEX!$M$40","v":0.82687860589248829},{"$f":"CAPEX400/CAPEX*OPEX!$M$82","v":1.8832181928717835},11.219739643845092,"11.2$","Area 400"]
["A500",{"$f":"\"Dewatering   \" & H8","v":"Dewatering   64.0$"},{"$f":"CAPEX500/CAPEX*SUM('Results Summary'!$F$24:$F$26)","v":51.508805141025732},{"$f":"0","v":0},{"$f":"'Mass Balance'!AR63/SUM('Mass Balance'!$AR$59:$AR$64)*OPEX!$M$40","v":1.1335250127039893},{"$f":"CAPEX500/CAPEX*OPEX!$M$82","v":11.399105779244493},64.041435932974224,"64.0$","Area 500"]
["A600",{"$f":"\"Storage   \" & H9","v":"Storage   9.8$"},{"$f":"CAPEX600/CAPEX*SUM('Results Summary'!$F$24:$F$26)","v":6.5273428545115175},{"$f":"0","v":0},{"$f":"'Mass Balance'!AR64/SUM('Mass Balance'!$AR$59:$AR$64)*OPEX!$M$40","v":1.821411823255314},{"$f":"CAPEX600/CAPEX*OPEX!$M$82","v":1.4445272308735753},9.7932819086404059,"9.8$","Area 600"]
[null,"NET SUMMATION",{"$f":"SUM(C4:C9)","v":280},{"$f":"SUM(D3:D9)","v":123.99217107697606},{"$f":"SUM(E3:E9)","v":28.089678797000179},{"$f":"SUM(F3:F9)","v":61.965126340045749},{"$f":"SUM(G3:G9)","v":494.0469762140221},{"$f":"TEXT(G10,\"$0\") & \" /US Dry Ton MBSP\"","v":"$494 /US Dry Ton MBSP"},"RESULT"]

{"sheet":"Facility_Dim","index":7,"n_rows":56,"n_cols":37,"rows_kept":56,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2-acre Module Dimensions",null,null,null,null,null,null,"10-acre Module Dimensions",null,null,null,null,null,null,"50-acre Module Dimensions"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Module Size","Rows","Columns","A (ft)","B (ft)",null,null,"Module Size","Rows","Columns","A (ft)","B (ft)",null,null,"Module Size","Rows","Columns","A (ft)","B (ft)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,{"$f":"ROUNDUP(R5/2.2/T5,0)","v":1},1,{"$f":"S5*70+ROUND((S5/2),0)*30+2*10","v":120},{"$f":"1370*T5+30*(T5-1)","v":1370},null,null,10,{"$f":"ROUNDUP(Y5/10/AA5,0)","v":1},1,{"$f":"Z5*196+ROUND((Z5/2),0)*30","v":226},{"$f":"2264*AA5+60*(AA5-1)","v":2264},{"$f":"AC5/AB5","v":10.017699115044248},null,50,{"$f":"ROUNDUP(AF5/50/AH5,0)","v":1},1,{"$f":"AG5*2412","v":2412},{"$f":"1320*AH5+60*(AH5-1)","v":1320},{"$f":"AJ5/AI5","v":0.54726368159203975}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,{"$f":"ROUND(R6/2.2/T6,0)","v":2},1,190,1370,null,null,20,{"$f":"ROUNDUP(Y6/10/AA6,0)","v":2},1,422,2264,{"$f":"AC6/AB6","v":5.3649289099526065},null,100,1,2,{"$f":"AG6*2412","v":2412},{"$f":"1320*AH6+60*(AH6-1)","v":2700},1.1194029850746268]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,5,1,460,1370,null,null,30,3,1,648,2264,3.4938271604938271,null,150,1,3,2412,{"$f":"1320*AH7+60*(AH7-1)","v":4080},1.691542288557214]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20,5,2,460,2770,null,null,40,4,1,844,2264,2.6824644549763033,null,200,{"$f":"ROUNDUP(AF8/50/AH8,0)","v":2},3,4824,4080,0.845771144278607]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30,7,2,630,2770,null,null,50,5,1,1070,2264,2.1158878504672898,null,250,{"$f":"ROUNDUP(AF9/50/AH9,0)","v":2},3,4824,4080,0.845771144278607]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,40,9,2,800,2770,null,null,60,6,1,1266,2264,1.7883096366508688,null,300,2,4,4824,5460,1.1318407960199004]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,50,8,3,700,4170,null,null,70,4,2,844,4588,5.4360189573459712,null,350,2,4,4824,5460,1.1318407960199004]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,60,9,3,800,4170,null,null,80,4,2,844,4588,5.4360189573459712,null,400,2,4,4824,5460,1.1318407960199004]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,70,11,3,970,4170,null,null,90,5,2,{"$f":"Z13*196+ROUND((Z13/2),0)*30","v":1070},{"$f":"2264*AA13+60*(AA13-1)","v":4588},4.2878504672897195,null,450,2,5,4824,6840,1.4179104477611941]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,80,12,3,1040,4170,null,null,100,5,2,{"$f":"Z14*196+ROUND((Z14/2),0)*30","v":1070},{"$f":"2264*AA14+60*(AA14-1)","v":4588},4.2878504672897195,null,500,2,5,4824,6840,1.4179104477611941]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,90,10,4,870,{"$f":"1370*T15+30*(T15-1)","v":5570},null,null,110,6,2,{"$f":"Z15*196+ROUND((Z15/2),0)*30","v":1266},{"$f":"2264*AA15+60*(AA15-1)","v":4588},3.6240126382306479]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,100,11,4,{"$f":"S16*70+ROUND((S16/2),0)*30+2*10","v":970},{"$f":"1370*T16+30*(T16-1)","v":5570},null,null,120,6,2,{"$f":"Z16*196+ROUND((Z16/2),0)*30","v":1266},{"$f":"2264*AA16+60*(AA16-1)","v":4588},3.6240126382306479]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,110,13,4,{"$f":"S17*70+ROUND((S17/2),0)*30+2*10","v":1140},{"$f":"1370*T17+30*(T17-1)","v":5570},null,null,130,7,2,1492,4588,3.0750670241286864]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,120,14,4,1210,5570,null,null,140,7,2,1492,4588,3.0750670241286864]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,130,15,4,1310,5570,null,null,150,8,2,1688,4588,2.7180094786729856]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,140,13,5,{"$f":"S20*70+ROUND((S20/2),0)*30+2*10","v":1140},{"$f":"1370*T20+30*(T20-1)","v":6970},null,null,160,8,2,1688,4588,2.7180094786729856]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,150,14,5,1210,6970,null,null,170,9,2,1914,4588,2.3970741901776385]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,160,15,5,1310,6970,null,null,180,9,2,1914,4588,2.3970741901776385]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,170,15,5,1310,6970,null,null,190,7,3,1492,6912,4.632707774798928]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,180,16,5,1380,6970,null,null,200,7,3,1492,6912,4.632707774798928]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,190,17,5,1480,6970,null,null,210,7,3,1492,6912,4.632707774798928]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,200,18,5,1550,6970,null,null,220,8,3,1688,6912,4.0947867298578196]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,210,16,6,1380,8370,null,null,230,8,3,1688,6912,4.0947867298578196]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,220,17,6,1480,8370,null,null,240,8,3,1688,6912,4.0947867298578196]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,230,17,6,1480,8370,null,null,250,9,3,1914,6912,3.6112852664576804]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,240,18,6,1550,8370,null,null,260,9,3,1914,6912,3.6112852664576804]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,250,19,6,1650,8370,null,null,270,9,3,1914,6912,3.6112852664576804]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,260,20,6,1720,8370,null,null,280,10,3,2110,6912,3.275829383886256]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,270,20,6,1720,8370,null,null,290,10,3,2110,6912,3.275829383886256]
[null,null,"Cultivation area",{"$f":"INPUT!B10","v":5000},"acres",null,null,null,null,null,null,null,null,null,null,null,null,280,21,6,1820,8370,null,null,300,8,4,1688,9236,5.471563981042654]
[null,null,"Module Size",{"$f":"INPUT!B11","v":100},"acres",null,null,null,null,null,null,null,null,null,null,null,null,290,19,7,{"$f":"S35*70+ROUND((S35/2),0)*30+2*10","v":1650},{"$f":"1370*T35+30*(T35-1)","v":9770},null,null,310,8,4,1688,9236,5.471563981042654]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,300,19,7,1650,9770,null,null,320,8,4,1688,9236,5.471563981042654]
[null,null,"Pond Size","A (ft)","B (ft)","C (ft)","D (ft) ","D (ft) (minus last row)","Last Row ","Facility (acre)",null,null,null,null,null,null,null,310,20,7,{"$f":"S37*70+ROUND((S37/2),0)*30+2*10","v":1720},{"$f":"1370*T37+30*(T37-1)","v":9770},null,null,330,9,4,1914,9236,4.825496342737722]
[null,null,"2-acre",{"$f":"VLOOKUP(ROUND(D35,-1),R5:V56,5)","v":5570},{"$f":"VLOOKUP(ROUND(D35,-1),R5:V56,4)","v":970},{"$f":"D38*F45+(F45+1)*50+75*F45","v":39915},{"$f":"E38*($E$45)+100*($E$45)-60","v":8500},{"$f":"E38*($E$45-1)+(100)*($E$45-2)+50","v":7440},{"$f":"($D$45-($F$45*($E$45-1)))*(E38+20)*(D38)/43560+G45","v":970.23530762167127},{"$f":"F38*H38/43560+I38","v":7787.6733241505972},null,null,null,null,null,null,null,320,21,7,1820,9770,null,null,340,9,4,1914,9236,4.825496342737722]
[null,null,"10-acre",{"$f":"VLOOKUP(ROUND(D35,-1),Y5:AC54,5)","v":4588},{"$f":"VLOOKUP(ROUND(D35,-1),Y5:AC54,4)","v":1070},{"$f":"D39*F45+(F45+1)*50+75*F45","v":33041},{"$f":"E39*($E$45)+100*($E$45)+100","v":9460},{"$f":"E39*($E$45-1)+100*($E$45)","v":8290},{"$f":"($D$45-($F$45*($E$45-1)))*(E39+100)*(D39)/43560+G46","v":887.46487603305786},{"$f":"F39*H39/43560+I39","v":7175.5707070707067},null,null,null,null,null,null,null,330,21,7,1820,9770,null,null,350,9,4,1914,9236,4.825496342737722]
[null,null,"50-acre",{"$f":"VLOOKUP(ROUND(D35,-1),AF5:AJ14,5)","v":2700},{"$f":"VLOOKUP(ROUND(D35,-1),AF5:AJ14,4)","v":2412},{"$f":"D40*F45+(F45+1)*50+75*F45","v":19825},{"$f":"E40*($E$45)+100*($E$45)+100","v":20196},{"$f":"E40*($E$45-1)+100*($E$45)","v":17684},{"$f":"($D$45-($F$45*($E$45-1)))*(E40+100)*(D40)/43560+G47","v":1143.2598714416895},{"$f":"F40*H40/43560+I40","v":9191.5909090909081},null,null,null,null,null,null,null,340,22,7,1890,9770,null,null,360,9,4,1914,9236,4.825496342737722]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,350,23,7,1990,9770,null,null,370,10,4,2110,9236,4.3772511848341233]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,360,23,7,1990,9770,null,null,380,10,4,2110,9236,4.3772511848341233]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,370,21,8,1820,11170,null,null,390,10,4,2110,9236,4.3772511848341233]
[null,null,"Cultivation Area","Number of Modules","Rows ","Columns","Plus area for Dewatering and Conversion (2-acre, 10-acre, 50-acre)",null,null,null,null,null,null,null,null,null,null,380,22,8,1890,11170,null,null,400,10,4,2110,9236,4.3772511848341233]
[null,null,{"$f":"D34","v":5000},{"$f":"ROUNDUP(C45/D35,0)","v":50},{"$f":"ROUNDUP(D45/F45,0)","v":8},{"$f":"ROUND(D45^(1/2),0)","v":7},{"$f":"((E38+100)*F38-(E38+100)*D38)/43560","v":843.64439853076215},null,null,null,null,null,null,null,null,null,null,390,22,8,1890,11170,null,null,410,11,4,2336,9236,3.9537671232876712]
[null,null,null,null,null,null,{"$f":"((E39+100)*F39-(E39+100)*D39)/43560","v":764.23347107438019},null,null,null,null,null,null,null,null,null,null,400,23,8,1990,11170,null,null,420,11,4,2336,9236,3.9537671232876712]
[null,null,null,null,null,null,{"$f":"((E40+100)*F40-(E40+100)*D40)/43560","v":987.55739210284662},null,null,null,null,null,null,null,null,null,null,410,23,8,1990,11170,null,null,430,11,4,2336,9236,3.9537671232876712]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,420,24,8,2060,11170,null,null,440,11,4,2336,9236,3.9537671232876712]
[null,null,"Distribution Pipeline Requirement (ft)",null,null,null,null,null,"Pipelines within Module",null,null,null,null,null,null,null,null,430,24,8,2060,11170,null,null,450,12,4,2532,9236,3.6477093206951028]
[null,null,null,"2-acre","10-acre","50-acre",null,null,"Pipelines within Module",{"$f":"IF(INPUT!B12=\"2-acre\",Facility_Dim!J51,IF(INPUT!B12=\"10-acre\",Facility_Dim!J52,IF(INPUT!B12=\"50-acre\",Facility_Dim!J53,0)))","v":3364},"ft",null,null,null,null,null,null,440,25,8,2160,11170,null,null,460,12,4,2532,9236,3.6477093206951028]
[null,34,"34\" ID",{"$f":"D38+E38+100+50+55","v":6745},{"$f":"D39+E39+100+50+75","v":5883},{"$f":"D40+E40+100+50+75","v":5337},null,null,"2-acre",{"$f":"D38*(VLOOKUP(ROUND(D35,-1),R5:V56,3)-1)/VLOOKUP(ROUND(D35,-1),R5:V56,3)+E38*VLOOKUP(ROUND(D35,-1),R5:V56,3)/2","v":6117.5},"ft",null,null,null,null,null,null,450,26,8,2230,11170,null,null,470,10,5,2110,11560,5.4786729857819907]
[null,26,"26\" ID",{"$f":"D38*($F$45-3)/2+($F$45-3)/2*(75+50)","v":11390},{"$f":"D39*($F$45-3)/2+($F$45-3)/2*(75+50)","v":9426},{"$f":"D40*($F$45-3)/2+($F$45-3)/2*(75+50)","v":5650},null,null,"10-acre",{"$f":"D39*(VLOOKUP(ROUND(D35,-1),Y5:AC54,3)-1)/VLOOKUP(ROUND(D35,-1),Y5:AC54,3)+E39*VLOOKUP(ROUND(D35,-1),Y5:AC54,3)/2","v":3364},"ft",null,null,null,null,null,null,460,23,9,1990,12570,null,null,480,10,5,2110,11560,5.4786729857819907]
[null,20,"20\" ID",{"$f":"D38*($F$45-3)/2+($F$45-3)/2*(75+50+250)","v":11890},{"$f":"D39*($F$45-3)/2+($F$45-3)/2*(75+50+250)","v":9926},{"$f":"D40*($F$45-3)/2+($F$45-3)/2*(75+50+300)","v":6250},null,null,"50-acre",{"$f":"D40*(VLOOKUP(ROUND(D35,-1),AF5:AJ14,3)-1)/VLOOKUP(ROUND(D35,-1),AF5:AJ14,3)+E40*IF(VLOOKUP(ROUND(D35,-1),AF5:AJ14,3)/2<1,VLOOKUP(ROUND(D35,-1),AF5:AJ14,3)/2,0)","v":1350},"ft",null,null,null,null,null,null,470,24,9,2060,12570,null,null,490,10,5,2110,11560,5.4786729857819907]
[null,16,"16\"ID",{"$f":"ROUNDUP($F$45/2,0)*(($E$45-2)/3)*($E$38+100)","v":8560},{"$f":"ROUNDUP($F$45/2,0)*(($E$45-2)/3)*($E$39+100)","v":9360},{"$f":"ROUNDUP($F$45/2,0)*(($E$45-2)/3)*($E$40+100)","v":20096},null,null,null,null,null,null,null,null,null,null,null,480,24,9,2060,12570,null,null,500,10,5,2110,11560,5.4786729857819907]
[null,14,"14\"ID",{"$f":"ROUNDUP($F$45/2,0)*(($E$45-2)/3)*($E$38+100)","v":8560},{"$f":"ROUNDUP($F$45/2,0)*(($E$45-2)/3)*($E$39+100)","v":9360},{"$f":"ROUNDUP($F$45/2,0)*(($E$45-2)/3)*($E$40+100)","v":20096},null,null,null,null,null,null,null,null,null,null,null,490,25,9,2160,12570]
[null,12,"12\"ID",8560,9360,20096,null,null,null,null,null,null,null,null,null,null,null,500,25,9,2160,12570]

{"sheet":"Quick Access Charts","index":8,"n_rows":104,"n_cols":19,"rows_kept":104,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cost Indices"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LOOKUP strings"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Data Set","Lookup String"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Plant Cost Indices",null,null,"Index-Capital","INDICES!b15:e41"]
["CO2 Consumed",{"$f":"INPUT!F56*-1","v":-620},"mol CO2 per mol of algae produced",null,null,null,null,null,null,null,null,null,null,null,"Year","Index Used",null,"Index-Chemical","INDICES!b58:e93"]
["DAP Consumed",{"$f":"INPUT!F61*-1","v":-1},"mol of DAP per mol of algae produced",null,null,null,null,null,null,null,null,null,null,null,1990,357.6,null,"Index-Labor","INDICES!b114:e149"]
["NH3 Consumed",{"$f":"(INPUT!F59-INPUT!F61*2)*-1","v":-16},"mol of NH3 per mol of algae produced",null,null,null,null,null,null,null,null,null,null,null,1991,361.3]
["H2O Consumed",{"$f":"(INPUT!F57+B6*9+B7*3)/2*-1","v":-530},"mol of H2O per mol of algae produced",null,null,null,null,null,null,null,null,null,null,null,1992,358.2]
["O2 Produced",{"$f":"((-2*B5-B6*4-B8-INPUT!F58))/2","v":734},"mol of O2 produced per mol of algae produced",null,null,null,null,null,null,null,null,null,null,null,1993,359.2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,1994,368.1]
["Ponds - Component Rates",null,null,null,null,null,null,null,null,null,null,null,null,null,1995,381.1]
[null,"Units","Summer","Fall","Winter","Spring","Yearly Average",null,null,null,null,null,null,null,1996,381.7]
["Total Algae Produced in Ponds (AFDW)","kg/hr",{"$f":"INPUT!B46*4046.86*INPUT!$B$10/1000/24","v":29508.354166666668},{"$f":"INPUT!C46*4046.86*INPUT!$B$10/1000/24","v":20993.08625},{"$f":"INPUT!D46*4046.86*INPUT!$B$10/1000/24","v":9864.2212499999987},{"$f":"INPUT!E46*4046.86*INPUT!$B$10/1000/24","v":24028.231250000001},{"$f":"AVERAGE(C13:F13)","v":21098.473229166666},null,null,null,null,null,null,null,1997,386.5]
["Total Algae Produced in Ponds (AFDW)","kmol/hr",{"$f":"C13/INPUT!$B$66","v":2.1458414912521326},{"$f":"D13/INPUT!$B$66","v":1.5266129466336602},{"$f":"E13/INPUT!$B$66","v":0.71732415564714136},{"$f":"F13/INPUT!$B$66","v":1.7473280714481652},1.5342766662452747,null,null,null,null,null,null,null,1998,389.5]
["Required NH3 for Producton Ponds","kmol/hr",{"$f":"C14*$B$7*-1","v":34.333463860034122},{"$f":"D14*$B$7*-1","v":24.425807146138563},{"$f":"E14*$B$7*-1","v":11.477186490354262},{"$f":"F14*$B$7*-1","v":27.957249143170642},24.548426659924395,null,null,null,null,null,null,null,1999,390.6]
["Required DAP for Producton Ponds","kmol/hr",{"$f":"C14*$B$6*-1","v":2.1458414912521326},{"$f":"D14*$B$6*-1","v":1.5266129466336602},{"$f":"E14*$B$6*-1","v":0.71732415564714136},{"$f":"F14*$B$6*-1","v":1.7473280714481652},1.5342766662452747,null,null,null,null,null,null,null,2000,394.1]
["Required CO2 for Producton Ponds","kmol/hr",{"$f":"C14*$B$5*-1","v":1330.4217245763223},{"$f":"D14*$B$5*-1","v":946.50002691286932},{"$f":"E14*$B$5*-1","v":444.74097650122764},{"$f":"F14*$B$5*-1","v":1083.3434042978624},951.2515330720704,null,null,null,null,null,null,null,2001,394.3]
["Required H2O for Producton Ponds","kmol/hr",{"$f":"C14*$B$8*-1","v":1137.2959903636304},{"$f":"D14*$B$8*-1","v":809.10486171583989},{"$f":"E14*$B$8*-1","v":380.1818024929849},{"$f":"F14*$B$8*-1","v":926.08387786752758},813.1666331099957,null,null,null,null,null,null,null,2002,395.6]
["Total O2 Produced in Ponds ","kmol/hr",{"$f":"C14*$B$9","v":1575.0476545790655},{"$f":"D14*$B$9","v":1120.5339028291066},{"$f":"E14*$B$9","v":526.51593024500175},{"$f":"F14*$B$9","v":1282.5388044429533},1126.1590730240318,null,null,null,null,null,null,null,2003,402]
["Total algae Produced in Inoculum (AFDW)","kg/day",{"$f":"B36*INPUT!B46/24*10000/1000","v":843.09583333333342},{"$f":"INPUT!C46*'Quick Access Charts'!B36*10000/1000/24","v":599.80246428571422},{"$f":"INPUT!D46*'Quick Access Charts'!B36*10000/1000/24","v":281.83489285714285},{"$f":"INPUT!E46*'Quick Access Charts'!B36*10000/1000/24","v":686.52089285714283},602.81352083333331,null,null,null,null,null,null,null,2004,444.2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,2005,468.2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,2006,499.6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,2007,525.4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,2008,575.4]
["Components","Component MW (g/mol)",null,null,null,null,null,null,null,null,null,null,null,null,2009,521.9]
["H2O",18.015280000000001,null,null,null,null,null,null,null,null,null,null,null,null,2010,550.79999999999995]
["O2",31.998799999999999,null,null,null,null,null,null,null,null,null,null,null,null,2011,585.70000000000005]
["N2",28.013400000000001,null,null,null,null,null,null,null,null,null,null,null,null,2012,584.6]
["CO2",44.009500000000003,null,null,null,null,null,null,null,null,null,null,null,null,2013,567.29999999999995]
["DAP (NH2)2HPO4",132.05622,null,null,null,null,null,null,null,null,null,null,null,null,2014,576.1]
["NH3",17.030520000000003,null,null,null,null,null,null,null,null,null,null,null,null,2015,556.79999999999995]
["NaCl",58.44,null,null,null,null,null,null,null,null,null,null,null,null,2016,541.70000000000005]
["Algae ",{"$f":"INPUT!B66","v":13751.41374}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Inorganic Chemical Index"]
["Algae Inoculumn Area",{"$f":"'Mass Balance'!E90/INPUT!B46*24*1000/10000","v":57.812285714285714},"ha",null,null,null,null,null,null,null,null,null,null,null,"Year","Index Used"]
["Lined Pond Area",{"$f":"(C20-C20*INPUT!B22/INPUT!B25)/INPUT!B46*24*1000/10000","v":46.249828571428573},"ha",null,null,null,null,null,null,null,null,null,null,null,1980,89]
["Covered Pond Area",{"$f":"(C20*INPUT!B22/INPUT!B25-C20*INPUT!B22/INPUT!B25*INPUT!B22/INPUT!B24)/INPUT!B46*24*1000/10000","v":9.2499657142857163},"ha",null,null,null,null,null,null,null,null,null,null,null,1981,98.4]
["PBR Area",{"$f":"(C20*INPUT!B22/INPUT!B25*INPUT!B22/INPUT!B24-C20*INPUT!B22/INPUT!B25*INPUT!B22/INPUT!B24*INPUT!B22/INPUT!B23)/INPUT!B46*24*1000/10000","v":2.1583253333333334},"ha",null,null,null,null,null,null,null,null,null,null,null,1982,100]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,1983,100.3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,1984,102.9]
["Power for Paddlewheel Mixing Based on Pond Size",null,null,null,null,null,null,null,null,null,null,null,null,null,1985,103.7]
["2-acre",75.5,"kWh/ha/day",null,null,null,null,null,null,null,null,null,null,null,1986,102.6]
["10-acre",{"$f":"AVERAGE(70,48,58.2,44)","v":55.05},"kWh/ha/day",null,null,null,null,null,null,null,null,null,null,null,1987,106.4]
["50-acre",{"$f":"AVERAGE(41.5,44)","v":42.75},"kWh/ha/day",null,null,null,null,null,null,null,null,null,null,null,1988,116.3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,1989,123]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,1990,123.6]
["Paddlewheel Mixing",{"$f":"IF(INPUT!B12=\"2-acre\",'Quick Access Charts'!B43,IF(INPUT!B12=\"10-acre\",'Quick Access Charts'!B44,IF(INPUT!B12=\"50-acre\",'Quick Access Charts'!B45,0)))","v":55.05},"kWh/ha/day",null,null,null,null,null,null,null,null,null,null,null,1991,125.6]
["Paddlewheel Mixing for 2-acre ponds (inoculum)",{"$f":"B43","v":75.5},"kWh/ha/day",null,null,null,null,null,null,null,null,null,null,null,1992,125.9]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,1993,128.19999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,1994,132.1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,1995,139.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,1996,142.1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,1997,147.1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,1998,148.69999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,1999,149.69999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,2000,156.69999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,2001,158.4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,2002,157.30000000000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,2003,164.6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,2004,172.8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,2005,187.3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,2006,196.8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,2007,203.3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,2008,228.2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,2009,224.7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,2010,233.7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,2011,252.1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,2012,260.3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,2013,263.89999999999998]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,2014,269.2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,2015,264.8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,2016,267.10000000000002]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Labor Index"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Year","Index Used"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,1990,12.85]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,1991,13.3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,1992,13.7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,1993,13.97]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,1994,14.33]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,1995,14.86]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,1996,15.37]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,1997,15.78]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,1998,16.23]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,1999,16.399999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,2000,17.09]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,2001,17.57]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,2002,17.97]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,2003,18.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,2004,19.170000000000002]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,2005,19.670000000000002]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,2006,19.600000000000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,2007,19.55]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,2008,19.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,2009,20.3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,2010,21.07]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,2011,21.46]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,2012,21.45]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,2013,21.4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,2014,21.49]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,2015,21.76]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,2016,22.71]