{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Input_Output_Data","Calculations_Current","Calculations_Alternate","Charts","©"],"not_rendered":{"charts":12,"images":2,"macros":1,"external_links":0,"defined_names":0,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Input_Output_Data","index":0,"n_rows":39,"n_cols":17,"rows_kept":39,"cut":false,"hidden":false,"merged":[[0,12,0,16],[0,2,0,8],[2,12,2,13],[2,15,2,16],[1,15,1,16],[1,2,1,3],[1,5,1,6],[1,12,1,13],[2,2,2,3],[21,2,22,3],[21,5,22,6],[32,15,33,16],[32,12,33,13],[2,5,2,6]]}
[null,null,"Input",null,null,null,null,null,null,null,null,null,"Output"]
[null,null,"Current Conditions",null,null,"Alternate Scenario",null,null,null,null,null,null,"Current Conditions",null,null,"Alternate Scenario"]
[null,null,"Activated Sludge Input Data",null,null,"Activated Sludge Input Data",null,null,"SRT (day)",null,null,null,"Approximate Operating Conditions",null,null,"Approximate Operating Conditions"]
[null,null,"Temperature (°C)",20,null,"Temperature (°C)",20,null,1,null,null,null,"Total average daily flow rate (mgd)",0.57999999999999996,null,"Total average daily flow rate (mgd)",0.57999999999999996]
[null,null,"So (mg/L)",90,null,"So (mg/L)",90,null,2,null,null,null,"Aeration volume in service (mil gal)",0.66,null,"Aeration volume in service (mil gal)",0.33]
[null,null,"V (mil gal)",0.66,null,"V (mil gal)",0.33,null,4,null,null,null,"Influent BOD5 concentration (mg/L)",90,null,"Influent BOD5 concentration (mg/L)",90]
[null,null," Q (mgd)",0.57999999999999996,null," Q (mgd)",0.57999999999999996,null,6,null,null,null,"Influent BOD5 mass loading (lb/day)",435.34799999999996,null,"Influent BOD5 mass loading (lb/day)",435.34799999999996]
[null,null,"Inert VSS (mg/L)",10,null,"Inert VSS (mg/L)",10,null,8,null,null,null,"Sec ww Oxid N load (lb/day) ",169.30199999999996,null,"Sec ww Oxid N load (lb/day) ",169.30199999999996]
[null,null,"Oxidizable N (mg/L)",35,null,"Oxidizable N (mg/L)",35,null,10,null,null,null,"Sec ww TSS load (lb/day)",483.71999999999991,null,"Sec ww TSS load (lb/day)",483.71999999999991]
[null,null,"biomass (VSS/TSS)",0.85,null,"biomass (VSS/TSS)",0.85,null,11,null,null,null,"F/M ratio",3.1018755679874496E-2,null,"F/M ratio",6.0395022729969584E-2]
[null,null,"Influent TSS (mg/L)",100,null,"Influent TSS (mg/L)",100,null,14,null,null,null,"Solids Retention Time (day)",160,null,"Solids Retention Time (day)",70]
[null,null,"Inert Inorg TSS (mg/L)",5,null," Inert Inorg TSS (mg/L)",5,null,16,null,null,null,"MLSS (mg/L)",3454.6395809048145,null,"MLSS (mg/L)",3479.3569844789354]
[null,null,"Effluent TSS (mg/L)",4,null,"Effluent TSS (mg/L)",4,null,18,null,null,null,"MLVSS (mg/L)",2549.7769771024255,null,"MLVSS (mg/L)",2619.1201034737619]
[null,null,"RAS TSS (mg/L)",6500,null,"RAS TSS (mg/L)",6500,null,20,null,null,null,"TSS Sludge Production (lb/day)",99.499438182077895,null,"TSS Sludge Production (lb/day)",117.44957560975611]
[null,null,"MLSS (mg/L)",3500,null,"MLSS (mg/L)",3500,null,22,null,null,null,"TSS in activated sludge effluent (lb/day)",19.348799999999997,null,"TSS in activated sludge effluent (lb/day)",19.348799999999997]
[null,null,"fd",0.1,null,"fd",0.1,null,24,null,null,null,"Total Oxygen Requirements (lb/day)",1303.1456566369998,null,"Total Oxygen Requirements (lb/day)",1275.4575329230211]
[null,null,"Y",0.6,null,"Y",0.6,null,26,null,null,null,"Total Oxygen Req'd W/Denit. (lb/day)",1013.4114752504698,null,"Total Oxygen Req'd W/Denit. (lb/day)",987.42169517314494]
[null,null,"Ks (mg/L)",60,null,"Ks (mg/L)",60,null,28,null,null,null,"Total oxygen supplied (lb/day)",1428.8989396166573,null,"Total oxygen supplied (lb/day)",1175.5045723234769]
[null,null,"kd at 20°C (1/day)",0.1,null,"kd at 20°C (1/day)",0.1,null,30,null,null,null,"Mixing intensity in the reactor (hp/mil gal)",90.909090909090907,null,"Mixing intensity in the reactor (hp/mil gal)",181.81818181818181]
[null,null,"k at 20°C (1/day)",8,null,"k at 20°C (1/day)",8,null,32,null,null,null,"RAS flow rate (mgd)",0.65794870924345761,null,"RAS flow rate (mgd)",0.66807863114856358]
[null,null,null,null,null,null,null,null,34,null,null,null,"RAS recycle percentage (%)",113.43943262818235,null,"RAS recycle percentage (%)",115.18597088768338]
[null,null,"Aerator Performance Data ",null,null,"Aerator Performance Data ",null,null,36,null,null,null,"WAS flow rate (mgd)",1.8354443494203634E-3,null,"WAS flow rate (mgd)",2.16656660412758E-3]
[null,null,null,null,null,null,null,null,38,null,null,null,"RAS TSS concentration (mg/L)",6500,null,"RAS TSS concentration (mg/L)",6500]
[null,null,"Operating DO concentration (mg/L)",4.5,null,"Operating DO concentration (mg/L)",4,null,40,null,null,null,"Total sludge production (lb/day)",118.84823818207789,null,"Total sludge production  (lb/day)",136.79837560975611]
[null,null,"alpha",0.84,null,"alpha",0.84,null,42,null,null,null,"Reactor Detention Time (hr)",27.310344827586206,null,"Reactor Detention Time (hr)",13.655172413793103]
[null,null,"beta",0.92,null,"beta",0.92,null,44,null,null,null,"VOLR (lb BOD/(thou cu ft-day))",4.9339380792743048,null,"VOLR (lb BOD/(thou cu ft-day))",9.8678761585486097]
[null,null,"SOTR, lb O2 / hp-hr",3.1,null,"SOTR, lb O2 / hp-hr",3.1,null,46,null,null,null,"Effluent CBOD5 (mg/L)",2.3581890812250332,null,"Effluent CBOD5 (mg/L)",2.4634146341463414]
[null,null,"Temperature (°C)",20,null,"Temperature (°C)",20,null,48,null,null,null,"Effluent TSS (mg/L)",4,null,"Effluent TSS (mg/L)",4]
[null,null,"Aeration (hp) being operated",60,null,"Aeration (hp) being operated",60,null,50,null,null,null,"Effluent Ammonia-N (mg/L)",0.17174632411686394,null,"Effluent Ammonia-N (mg/L)",0.1704846341463416]
[null,null,"Elevation (ft)",200,null,"Elevation (ft)",200,null,52,null,null,null,"Effluent NO3-N (mg/L)",29.91862406452908,null,"Effluent NO3-N (mg/L)",29.743249158626476]
[null,null,"Aerators operating time (hr/day)",22,null,"Aerators operating time (hr/day)",16,null,60,null,null,null,"Effluent NO3-N W/denit (mg/L)",8.9755872193587241,null,"Effluent NO3-N W/denit (mg/L)",8.9229747475879417]
[null,null,"Type of aerators (1, 2, or 3)",2,null,"Type of aerators (1, 2, or 3)",2,null,70]
[null,null,"Speed of aerators (%)",100,null,"Speed of aerators (%)",100,null,80,null,null,null,"Actual Aerator Performance",null,null,"Actual Aerator Performance"]
[null,null,"Energy cost unit ($/kWh)",7.4999999999999997E-2,null,"Energy cost unit ($/kWh)",7.4999999999999997E-2,null,100]
[null,null,null,null,null,null,null,null,120,null,null,null,"Field OTR ( lb O2 / hp-hr)",1.0824991966792858,null,"Field OTR ( lb O2 / hp-hr)",1.2244839295036216]
[null,null,null,null,null,null,null,null,140,null,null,null,"Aerator energy use (kWh/month)",25740,null,"Aerator energy use (kWh/month)",18720]
[null,null,null,null,null,null,null,null,160,null,null,null,"Energy cost ($/month)",1930.5,null,"Energy cost ($/month)",1404]
[null,null,null,null,null,null,null,null,180,null,null,null,null,null,null,"Cost savings vs. current conditions ($/month)",526.5]
[null,null,null,null,null,null,null,null,190]

{"sheet":"Calculations_Current","index":1,"n_rows":38,"n_cols":24,"rows_kept":38,"cut":false,"hidden":false,"merged":[]}
["SRT","F/M Ratio","Se","Heter Biomass","Cell debris","Inert VSS","MLVSS","MLSS","Biomass Prod VSS","Sludge Prod VSS","T. Solids Prod TSS","Effluent TSS","Intent Waste TSS","Oxygen Reqd","O2 Reqd w/ nit","Eff NH3-N","Eff NO3-N","O2 Reqd w/ den saving","Nit O2 Demand","WAS Flow","N Reduction by Assim.","N Reduction by Assim.","Eff CBOD5 ","RAS Flow Rate"]
["day",null,"mg/L","mg/L","mg/L","mg/L","mg/L","mg/L","lb/day","lb/day","lb/day","lb/day","lb/day","lb/day","lb/day","mg/L","mg/L","lb/day","lb/day"," mgd","lb/day","mg/L","mg/L","mgd"]
[1,1.8088710234960641,17.837837837837839,34.590127317400039,0.34590127317400043,8.7878787878787872,43.723907378452829,54.283028288375874,192.30187577395577,240.67387577395576,298.79550091053619,19.348799999999997,279.44670091053621,250.52555261719891,313.8413131519842,27.206482555282555,null,null,63.315760534785262,5.1548921031273976E-3,23.07622509287469,4.7705749385749385,20.2646071558984,4.8845080454870734E-3]
[2,0.87330191294704729,8.5714285714285712,71.558441558441558,1.4311688311688313,17.575757575757574,90.565367965367969,112.23376623376623,200.88200571428573,249.25400571428574,308.88977142857146,19.348799999999997,289.54097142857148,305.57698045714289,444.08220201857489,23.445318,3.7554537199017197,407.71410878928987,138.50522156143199,5.3410989010989019E-3,23.90495868,4.9419000000000004,10.901562544182491,1.0190664785364881E-2]
[4,0.46864343314120649,4.7191011235955056,128.47512038523274,5.1390048154093106,35.151515151515149,168.76564035215719,209.92036119861632,183.86639768860354,232.23839768860353,288.87140904541593,19.348799999999997,269.52260904541595,357.69086134959861,632.86037618439855,17.415052083467096,9.823760261018057,537.72635092893631,275.16951483479988,4.9718245535033375E-3,21.512368529566611,4.4472770465489573,6.8713123415769459,1.9356481393993676E-2]
[6,0.3380505750173996,3.5294117647058818,170.975935828877,10.258556149732621,52.727272727272727,233.96176470588236,292.30795847750863,166.26452294117647,214.63652294117648,268.16332110726643,19.348799999999997,248.81452110726644,391.31767154117642,800.99800324608429,11.487468897058823,15.923460701690995,646.79402510543252,409.68033170490787,4.5898269896193777E-3,19.120420138235293,3.9527867647058827,5.5228208481004417,2.7311054540549363E-2]
[8,0.27214863578680198,2.9508196721311473,203.99403874813709,16.319523099850969,70.303030303030297,290.61659215101838,364.64697115806081,151.58674622950818,199.95874622950822,250.89534850530376,19.348799999999997,231.54654850530375,416.35826297704909,956.66264334568746,5.6625910819672143,22.035657186450234,743.26769969920872,540.30438036863836,4.2712884800830799E-3,17.129302323934422,3.5411606557377047,4.8030086676332271,3.4471568673790795E-2]
[10,0.23172506436807339,2.6086956521739131,230.39525691699606,23.039525691699613,87.878787878787875,341.31357048748356,429.97674959311792,139.50064173913046,187.87264173913044,236.67640204603586,19.348799999999997,217.32760204603585,436.00291481739123,1048.7500240534391,2.5439085217391288,25.447289763700461,802.31657670340553,612.747109236048,4.0089946881762747E-3,15.484571233043479,3.2011434782608701,4.3357899481739128,4.1084935670928718E-2]
[11,0.2167099733809239,2.4852071005917158,241.70752324598476,26.587827557058326,96.666666666666657,364.96201746970974,460.64158918005074,134.25499354184277,182.62699354184275,230.5050512256974,19.348799999999997,211.15625122569742,444.34774349010979,1073.3318296715688,1.9168190363482687,26.191381929733467,819.69253842521448,628.98408618145902,3.8951531308927764E-3,14.768049289602704,3.0530160608622148,4.1553677280002752,4.4238494149605553E-2]
[14,0.18358604746039303,2.2222222222222228,269.9831649831649,37.797643097643089,123.03030303030303,430.81111111111102,546.64052287581694,121.01061999999999,169.38261999999995,214.92343529411761,19.348799999999997,195.57463529411763,465.06291959999982,1121.7647823583659,0.96969650000000085,27.451185186322686,855.92546264583916,656.70186275836602,3.6077224736048262E-3,12.948136339999998,2.6767833333333333,3.7420732454516625,5.3255897697131502E-2]
[16,0.16776269410955716,2.1024258760107815,285.20611464007686,45.632978342412301,140.60606060606059,471.44515358854977,600.13155324143099,113.81691896330084,162.18891896330086,206.46025760388329,19.348799999999997,187.11145760388331,476.14719340095365,1141.1260520472488,0.78070564876632864,27.80576308881939,871.85297354634804,664.97885864629518,3.4516040878783123E-3,11.950776491146588,2.4705979680696664,3.5376051128133414,5.8997298672187448E-2]
[18,0.1550435245218873,2.0095693779904304,298.25327782265583,53.685590008078059,158.18181818181819,510.12068601255208,651.31845413241433,107.62290578263843,155.99490578263843,199.1731832736923,19.348799999999997,179.82438327369232,485.61644029583033,1155.6236243003314,0.71958374586466234,28.023833563883912,884.23873509446241,670.00718400450114,3.3171810233110556E-3,11.085159295611758,2.2916479152426525,3.3711514632205102,6.4589719996588246E-2]
[20,0.14452963116452547,1.935483870967742,309.56011730205279,61.912023460410559,175.75757575757575,547.22971652003912,700.66241159220283,102.23656258064517,150.60856258064516,192.83630891840608,19.348799999999997,173.48750891840609,493.80259726451607,1168.4018104693905,0.65730632258064581,28.209787605294444,895.21612849152132,674.59921320487433,3.2002860896219532E-3,10.325892820645162,2.1346838709677423,3.2334639029677419,7.0074244261239843E-2]
[22,0.13564654654725375,1.875,319.453125,70.279687500000009,193.33333333333331,583.06614583333328,748.50919117647061,97.511149687500023,145.88314968749998,187.27699963235298,19.348799999999997,167.92819963235297,500.95154244374987,1179.7861019088668,0.59407738593750048,28.416073371606267,904.60273322237299,678.83455946511697,3.0977347285067879E-3,9.6536038190625018,1.9957007812500007,3.1183624741299196,7.5482226315363887E-2]
[24,0.12800892133591582,1.8246869409660107,328.18191384538846,78.763659322893247,210.90909090909091,617.8546640773726,795.12313420867372,93.332967206145426,141.70496720614543,182.36149083075929,19.348799999999997,163.01269083075931,507.24962306101224,1190.024473417659,0.5300544188572035,28.589752373744432,913.15918435274136,682.77485035664688,3.0070594139597734E-3,9.0532978189961071,1.8715988214248136,3.0214725195234506,8.0838101976642998E-2]
[26,0.1213478826196191,1.7821782178217822,335.94059405940595,87.344554455445561,228.48484848484847,651.76999699969997,840.70980039180392,89.612721980198032,137.984721980198,177.98473174140946,19.348799999999997,158.63593174140948,512.84080607524743,1199.3092563533046,0.46536076237623802,28.788349780840246,920.52073522242404,686.46845027805716,2.9263222973881105E-3,8.5132085881188129,1.7599455445544558,2.9395483363523418,8.6161279423522863E-2]
[28,0.1154695984967474,1.745788667687596,342.88239043941468,96.007069323036106,246.06060606060606,684.95006582305689,885.4314499879099,86.279397939872638,134.65139793987265,174.06317404690898,19.348799999999997,154.71437404690897,517.83816151037308,1207.7919650430426,0.40009430908358223,28.953507726121639,927.40404208230598,689.95380353266955,2.8539821812748382E-3,8.0239840084081546,1.6588075763681791,2.8700879776856758,9.146744516849506E-2]
[30,0.1102304340979476,1.7142857142857142,349.12987012987014,104.73896103896105,263.63636363636363,717.50519480519483,929.41787624140579,83.275853142857144,131.64785314285714,170.52959193277314,19.348799999999997,151.18079193277316,522.33177425142844,1215.5936050816872,0.33433370000000029,29.114910312285012,933.64264746819197,693.26183083025865,2.7887989657401431E-3,7.5781026359999997,1.5666300000000002,2.8111023622857143,9.6769485889258933E-2]
[32,0.10552141989977785,1.6867469879518071,354.78224586658314,113.53031867730661,281.21212121212119,749.52468575601097,972.77414010511086,80.555615008605841,128.92761500860584,167.32931177483039,19.348799999999997,147.9805117748304,526.39432789259888,1222.1099650529352,0.30166066161790045,29.206720254281571,939.26991313048552,695.71563716033631,2.7297640984104482E-3,7.1694497357659195,1.482148709122203,2.7609707310097269,0.102078151963143]
[34,0.10125819027347363,1.6624685138539042,359.92068613776871,122.37303328684138,298.78787878787875,781.08159821248887,1015.5861939754772,78.080516152965416,126.45251615296542,164.41743076819461,19.348799999999997,145.06863076819462,530.08512801996778,1228.119765189904,0.26876539335928579,29.294091537863213,944.43360325682625,698.03463716993622,2.6760492670760859E-3,6.7930049053079911,1.4043258300893062,2.7183466714193445,0.10740254352410966]
[36,9.7374262708239845E-2,1.6409036860879904,364.61223933487798,131.2604061605561,316.36363636363637,812.23628185907046,1057.9250374812593,75.818927496251874,124.19092749625189,161.75673823088454,19.348799999999997,142.40793823088455,533.45305398980497,1233.6893501986644,0.23567388946905879,29.377600069721812,949.1944854300333,700.23629620885947,2.6269680544343211E-3,6.4446088371814083,1.3323015044202038,2.68209492826655,0.11275047219399953]
[38,9.3816426890098142E-2,1.6216216216216219,368.91277641277628,140.18685503685501,333.93939393939394,843.03902538902526,1099.84983379101,73.74442135135132,122.11642135135133,159.31614276629568,19.348799999999997,139.9673427662957,536.53875951891871,1238.8739640149934,0.2024078554054056,29.457726954176906,953.60314453585886,702.33520449607477,2.5819469242998653E-3,6.1207869721621586,1.2653574324324319,2.6512475938277027,0.11812873419529608]
[40,9.0541505990910334E-2,1.6042780748663101,372.86922702965478,149.14769081186191,351.5151515151515,873.53206935666822,1141.4102776745117,71.834748064171123,120.20674806417112,157.06946831078955,19.348799999999997,137.72066831078956,539.37633689326185,1244.02946964748,0.16905980748663116,29.545198252926724,957.91157160338764,704.65313275421818,2.5405030125583762E-3,5.7467798451336902,1.188038502673797,2.6042780748663104,0.12354331929780923]
[42,8.7514033825232054E-2,1.5885947046843176,376.52129947445627,158.13894577927167,369.09090909090907,903.75115434463703,1182.6484168760435,70.071044142252845,118.44304414225287,154.99452252029747,19.348799999999997,135.64572252029745,541.99459185975252,1247.2556169173304,0.16920565251449177,29.565470711799346,960.94139887324468,705.26102505757797,2.502226941898127E-3,5.6056835313802278,1.1588694971016764,2.5885947046843176,0.12899957263783488]
[44,8.4704557527757407E-2,1.574344023323615,379.9028182701652,167.15724003887271,386.66666666666663,933.72672497570454,1223.6000685988681,68.437213294460648,116.80921329446063,153.07236858171839,19.348799999999997,133.72356858171838,544.41803175743439,1250.2421860256591,0.16934075801749285,29.584250376716497,963.74610430930852,705.82415426822467,2.4667693890743107E-3,5.4749770635568522,1.1318483965014581,2.574344023323615,0.13450232147184643]
[46,8.2088376345004252E-2,1.5613382899628254,383.04277506879737,176.19967653164679,404.24242424242425,963.48487584286841,1264.2959323641589,66.919438056293146,115.29143805629316,151.28675065446254,19.348799999999997,131.93795065446255,546.66763959575144,1253.0149224197648,0.16946626659585784,29.601696069109227,966.34989532032364,706.3472828240134,2.433830486155E-3,5.3535550445034517,1.1067466808284654,2.5613382899628254,0.14005597552848834]
[48,7.9644590183947941E-2,1.5494211932324133,385.96616206589482,185.26375779162956,421.81818181818181,993.04810167570622,1304.7624725596545,65.505791059661604,113.8777910596616,149.62363654077839,19.348799999999997,130.27483654077838,548.76148640142469,1255.5960081084731,0.16958316455307537,29.617944885162466,968.77362626546039,706.83452170704857,2.4031513842608077E-3,5.240463284772928,1.0833670893849601,2.5494211932324133,0.14566460726531025]
[50,7.7355371900826433E-2,1.5384615384615385,388.69463869463874,194.3473193473194,439.39393939393938,1022.4358974358975,1345.0226244343894,64.185923076923103,112.55792307692309,148.07085067873305,19.348799999999997,128.72205067873307,550.71521999999982,1258.0046579649229,0.16969230769230784,29.63311578151578,971.03536003291003,707.28943796492308,2.3745074834667602E-3,5.1348738461538481,1.0615384615384622,2.5384615384615383,0.15133201667763882]
[52,7.5205403691527187E-2,1.5283483976992605,391.24706925592233,203.44847601307964,456.96969696969694,1051.665242238699,1385.0963634180771,62.950810757282582,111.3228107572826,146.6177773615089,19.348799999999997,127.2689773615089,552.54245842063233,1260.2576000785414,0.1697944421766906,29.647312474844981,973.15082031209454,707.71514165790904,2.3477029581536416E-3,5.0360648605826066,1.0411115646619133,2.5283483976992605,0.15706178412372473]
[60,6.7757181044064557E-2,1.4946619217081851,399.99815131487725,239.99889078892639,527.27272727272725,1167.2697693765308,1543.8467875018009,58.713328642602953,107.08532864260293,141.63250428541522,19.348799999999997,122.28370428541523,558.80410535597343,1267.9797714993847,0.17014485002541957,29.69601916581831,980.40131251377443,709.17566614341126,2.2557407173107403E-3,4.6970662914082366,0.97102999491611619,2.4946619217081851,0.18067059236445468]
[70,6.0395022729969584E-2,1.4634146341463414,408.47560975609753,285.9329268292683,615.15151515151513,1309.560051736881,1739.6784922394677,54.604319268292677,102.9763192682927,136.79837560975611,19.348799999999997,117.44957560975611,564.86562273658524,1275.4575329230211,0.1704846341463416,29.743249158626476,987.42169517314494,710.59191018643594,2.16656660412758E-3,4.3683455414634142,0.90307317073170734,2.4634146341463414,0.21196331463199342]
[80,5.4539636984176229E-2,1.44,415.0690909090909,332.05527272727272,703.030303030303,1450.1546666666666,1933.515294117647,51.405891840000002,99.777891839999995,133.03551981176471,19.348799999999997,113.68671981176472,569.57728158719988,1281.2715873584907,0.17074912000000017,29.780012692285013,992.87972881345831,711.69430577129094,2.0971540271493214E-3,4.1124713472000005,0.85017600000000026,2.44,0.24558034085686195]
[100,4.5767373090192201E-2,1.4072494669509594,424.6594653650285,424.65946536502861,878.78787878787875,1728.1068095179357,2317.3805602171797,46.749911223105265,95.121911223105272,127.55789555659443,19.348799999999997,108.20909555659443,576.42640538088767,1289.7254786794424,0.17113413452219436,29.83352971087001,1000.8153573447667,713.29907329855473,1.9961094919128284E-3,3.7399928978484214,0.77317309556115565,2.4072494669509594,0.32134903599925757]
[120,3.9478283258345515E-2,1.3854351687388988,431.29886099690714,517.55863319628861,1054.5454545454545,2003.4029487386501,2698.1211161631181,43.524093258641891,91.896093258641883,123.76281559840223,19.348799999999997,104.41401559840223,581.16534707539267,1295.5762566001231,0.17140088536685355,29.870608078277634,1006.3070655968415,714.41090952473041,1.9261024829072537E-3,3.4819274606913515,0.71982292662932112,2.3854351687388986,0.41161496596527303]
[140,3.4733089162007388E-2,1.3698630136986301,436.16770444167702,610.63478621834793,1230.3030303030303,2277.1055209630554,3076.9868874075155,41.15728306849315,89.529283068493157,120.97833302175664,19.348799999999997,101.62953302175664,584.63920598794516,1299.8658792472938,0.17159660273972616,29.89781279310693,1010.3332357615745,715.22667325934856,1.8747377425153411E-3,3.292582645479452,0.68067945205479463,2.3698630136986303,0.52136884551538221]
[160,3.1018755679874496E-2,1.3581890812250332,439.8909119391613,703.82545910265821,1406.060606060606,2549.7769771024255,3454.6395809048145,39.346702454766195,87.718702454766202,118.84823818207789,19.348799999999997,99.499438182077895,587.29493417867923,1303.1456566369998,0.17174632411686394,29.91862406452908,1013.4114752504698,715.85072245832055,1.8354443494203634E-3,3.1477361963812958,0.65073517662724223,2.3581890812250332,0.65794870924345761]
[180,2.8029097887281643E-2,1.349112426035503,442.83027094363132,797.09448769853645,1581.8181818181818,2821.7429404603495,3831.4622828945289,37.916899119277488,86.288899119277502,117.16611661091471,19.348799999999997,97.817316610914716,589.39111330979733,1305.7346432241543,0.17186455808159465,29.935058585626649,1015.8413087125871,716.34352991435685,1.804414621119991E-3,3.0333519295421993,0.62708838368109643,2.3491124260355027,0.83275874642284275]
[190,2.6742239587282099E-2,1.3452914798206279,444.07949449653478,843.75103954341614,1669.6969696969695,2957.5275037369206,4019.6402004748088,37.309128376681613,85.681128376681613,116.45109220786073,19.348799999999997,97.102292207860728,590.28187178582948,1306.8348808264952,0.17191481614349791,29.942044456231201,1016.8738946242447,716.55300904066576,1.7912247225209505E-3,2.9847302701345293,0.61703677130044854,2.3452914798206281,0.93994077662510145]

{"sheet":"Calculations_Alternate","index":2,"n_rows":38,"n_cols":24,"rows_kept":38,"cut":false,"hidden":false,"merged":[]}
["SRT","F/M Ratio","Se","Heter Biomass","Cell debris","Inert VSS","MLVSS","MLSS","Biomass Prod VSS","Sludge Prod VSS","T. Solids Prod TSS","Effluent TSS","Intent Waste TSS","Oxygen Reqd","O2 Reqd w/ nit","Eff NH3-N","Eff NO3-N","O2 Reqd w/ den saving","Nit O2 Demand","WAS Flow","N Reduction by Assim.","N Reduction by Assim.","Eff CBOD5 ","RAS Flow Rate"]
["day",null,"mg/L","mg/L","mg/L","mg/L","mg/L","mg/L","lb/day","lb/day","lb/day","lb/day","lb/day","lb/day","lb/day","mg/L","mg/L","lb/day","lb/day"," mgd","lb/day","mg/L","mg/L","mgd"]
[1,1.8088710234960641,17.837837837837839,69.180254634800079,0.69180254634800087,17.575757575757574,87.447814756905657,108.56605657675175,192.30187577395577,240.67387577395576,298.79550091053619,19.348799999999997,279.44670091053621,250.52555261719891,313.8413131519842,27.206482555282555,null,null,63.315760534785262,5.1548921031273976E-3,23.07622509287469,4.7705749385749385,20.2646071558984,9.851985230843241E-3]
[2,0.87330191294704729,8.5714285714285712,143.11688311688312,2.8623376623376626,35.151515151515149,181.13073593073594,224.46753246753246,200.88200571428573,249.25400571428574,308.88977142857146,19.348799999999997,289.54097142857148,305.57698045714289,444.08220201857489,23.445318,3.7554537199017197,407.71410878928987,138.50522156143199,5.3410989010989019E-3,23.90495868,4.9419000000000004,10.901562544182491,2.0745836230588392E-2]
[4,0.46864343314120649,4.7191011235955056,256.95024077046548,10.278009630818621,70.303030303030297,337.53128070431438,419.84072239723264,183.86639768860354,232.23839768860353,288.87140904541593,19.348799999999997,269.52260904541595,357.69086134959861,632.86037618439855,17.415052083467096,9.823760261018057,537.72635092893631,275.16951483479988,4.9718245535033375E-3,21.512368529566611,4.4472770465489573,6.8713123415769459,4.0049546051761156E-2]
[6,0.3380505750173996,3.5294117647058818,341.951871657754,20.517112299465243,105.45454545454545,467.92352941176472,584.61591695501727,166.26452294117647,214.63652294117648,268.16332110726643,19.348799999999997,248.81452110726644,391.31767154117642,800.99800324608429,11.487468897058823,15.923460701690995,646.79402510543252,409.68033170490787,4.5898269896193777E-3,19.120420138235293,3.9527867647058827,5.5228208481004417,5.7321253712974078E-2]
[8,0.27214863578680198,2.9508196721311473,407.98807749627417,32.639046199701937,140.60606060606059,581.23318430203676,729.29394231612162,151.58674622950818,199.95874622950822,250.89534850530376,19.348799999999997,231.54654850530375,416.35826297704909,956.66264334568746,5.6625910819672143,22.035657186450234,743.26769969920872,540.30438036863836,4.2712884800830799E-3,17.129302323934422,3.5411606557377047,4.8030086676332271,7.3299607069766667E-2]
[10,0.23172506436807339,2.6086956521739131,460.79051383399212,46.079051383399225,175.75757575757575,682.62714097496712,859.95349918623583,139.50064173913046,187.87264173913044,236.67640204603586,19.348799999999997,217.32760204603585,436.00291481739123,1048.7500240534391,2.5439085217391288,25.447289763700461,802.31657670340553,612.747109236048,4.0089946881762747E-3,15.484571233043479,3.2011434782608701,4.3357899481739128,8.8434205188920367E-2]
[11,0.2167099733809239,2.4852071005917158,483.41504649196952,53.175655114116651,193.33333333333331,729.92403493941947,921.28317836010149,134.25499354184277,182.62699354184275,230.5050512256974,19.348799999999997,211.15625122569742,444.34774349010979,1073.3318296715688,1.9168190363482687,26.191381929733467,819.69253842521448,628.98408618145902,3.8951531308927764E-3,14.768049289602704,3.0530160608622148,4.1553677280002752,9.5782643308965257E-2]
[14,0.18358604746039303,2.2222222222222228,539.96632996632979,75.595286195286178,246.06060606060606,861.62222222222204,1093.2810457516339,121.01061999999999,169.38261999999995,214.92343529411761,19.348799999999997,195.57463529411763,465.06291959999982,1121.7647823583659,0.96969650000000085,27.451185186322686,855.92546264583916,656.70186275836602,3.6077224736048262E-3,12.948136339999998,2.6767833333333333,3.7420732454516625,0.11728055626743773]
[16,0.16776269410955716,2.1024258760107815,570.41222928015372,91.265956684824602,281.21212121212119,942.89030717709954,1200.263106482862,113.81691896330084,162.18891896330086,206.46025760388329,19.348799999999997,187.11145760388331,476.14719340095365,1141.1260520472488,0.78070564876632864,27.80576308881939,871.85297354634804,664.97885864629518,3.4516040878783123E-3,11.950776491146588,2.4705979680696664,3.5376051128133414,0.13135606837607791]
[18,0.1550435245218873,2.0095693779904304,596.50655564531166,107.37118001615612,316.36363636363637,1020.2413720251042,1302.6369082648287,107.62290578263843,155.99490578263843,199.1731832736923,19.348799999999997,179.82438327369232,485.61644029583033,1155.6236243003314,0.71958374586466234,28.023833563883912,884.23873509446241,670.00718400450114,3.3171810233110556E-3,11.085159295611758,2.2916479152426525,3.3711514632205102,0.14536783239082157]
[20,0.14452963116452547,1.935483870967742,619.12023460410558,123.82404692082112,351.5151515151515,1094.4594330400782,1401.3248231844057,102.23656258064517,150.60856258064516,192.83630891840608,19.348799999999997,173.48750891840609,493.80259726451607,1168.4018104693905,0.65730632258064581,28.209787605294444,895.21612849152132,674.59921320487433,3.2002860896219532E-3,10.325892820645162,2.1346838709677423,3.2334639029677419,0.15940776167556805]
[22,0.13564654654725375,1.875,638.90625,140.55937500000002,386.66666666666663,1166.1322916666666,1497.0183823529412,97.511149687500023,145.88314968749998,187.27699963235298,19.348799999999997,167.92819963235297,500.95154244374987,1179.7861019088668,0.59407738593750048,28.416073371606267,904.60273322237299,678.83455946511697,3.0977347285067879E-3,9.6536038190625018,1.9957007812500007,3.1183624741299196,0.17355064002275114]
[24,0.12800892133591582,1.8246869409660107,656.36382769077693,157.52731864578649,421.81818181818181,1235.7093281547452,1590.2462684173474,93.332967206145426,141.70496720614543,182.36149083075929,19.348799999999997,163.01269083075931,507.24962306101224,1190.024473417659,0.5300544188572035,28.589752373744432,913.15918435274136,682.77485035664688,3.0070594139597734E-3,9.0532978189961071,1.8715988214248136,3.0214725195234506,0.18785928706545238]
[26,0.1213478826196191,1.7821782178217822,671.88118811881191,174.68910891089112,456.96969696969694,1303.5399939993999,1681.4196007836078,89.612721980198032,137.984721980198,177.98473174140946,19.348799999999997,158.63593174140948,512.84080607524743,1199.3092563533046,0.46536076237623802,28.788349780840246,920.52073522242404,686.46845027805716,2.9263222973881105E-3,8.5132085881188129,1.7599455445544558,2.9395483363523418,0.20238810762877077]
[28,0.1154695984967474,1.745788667687596,685.76478087882936,192.01413864607221,492.12121212121212,1369.9001316461138,1770.8628999758198,86.279397939872638,134.65139793987265,174.06317404690898,19.348799999999997,154.71437404690897,517.83816151037308,1207.7919650430426,0.40009430908358223,28.953507726121639,927.40404208230598,689.95380353266955,2.8539821812748382E-3,8.0239840084081546,1.6588075763681791,2.8700879776856758,0.21718560072634052]
[30,0.1102304340979476,1.7142857142857142,698.25974025974028,209.4779220779221,527.27272727272725,1435.0103896103897,1858.8357524828116,83.275853142857144,131.64785314285714,170.52959193277314,19.348799999999997,151.18079193277316,522.33177425142844,1215.5936050816872,0.33433370000000029,29.114910312285012,933.64264746819197,693.26183083025865,2.7887989657401431E-3,7.5781026359999997,1.5666300000000002,2.8111023622857143,0.23229618236777083]
[32,0.10552141989977785,1.6867469879518071,709.56449173316628,227.06063735461322,562.42424242424238,1499.0493715120219,1945.5482802102217,80.555615008605841,128.92761500860584,167.32931177483039,19.348799999999997,147.9805117748304,526.39432789259888,1222.1099650529352,0.30166066161790045,29.206720254281571,939.26991313048552,695.71563716033631,2.7297640984104482E-3,7.1694497357659195,1.482148709122203,2.7609707310097269,0.24776154671236988]
[34,0.10125819027347363,1.6624685138539042,719.84137227553742,244.74606657368275,597.57575757575751,1562.1631964249777,2031.1723879509543,78.080516152965416,126.45251615296542,164.41743076819461,19.348799999999997,145.06863076819462,530.08512801996778,1228.119765189904,0.26876539335928579,29.294091537863213,944.43360325682625,698.03463716993622,2.6760492670760859E-3,6.7930049053079911,1.4043258300893062,2.7183466714193445,0.26362171184119149]
[36,9.7374262708239845E-2,1.6409036860879904,729.22447866975597,262.5208123211122,632.72727272727275,1624.4725637181409,2115.8500749625186,75.818927496251874,124.19092749625189,161.75673823088454,19.348799999999997,142.40793823088455,533.45305398980497,1233.6893501986644,0.23567388946905879,29.377600069721812,949.1944854300333,700.23629620885947,2.6269680544343211E-3,6.4446088371814083,1.3323015044202038,2.68209492826655,0.27991584787506302]
[38,9.3816426890098142E-2,1.6216216216216219,737.82555282555256,280.37371007371001,667.87878787878788,1686.0780507780505,2199.6996675820201,73.74442135135132,122.11642135135133,159.31614276629568,19.348799999999997,139.9673427662957,536.53875951891871,1238.8739640149934,0.2024078554054056,29.457726954176906,953.60314453585886,702.33520449607477,2.5819469242998653E-3,6.1207869721621586,1.2653574324324319,2.6512475938277027,0.29668295434616726]
[40,9.0541505990910334E-2,1.6042780748663101,745.73845405930956,298.29538162372381,703.030303030303,1747.0641387133364,2282.8205553490234,71.834748064171123,120.20674806417112,157.06946831078955,19.348799999999997,137.72066831078956,539.37633689326185,1244.02946964748,0.16905980748663116,29.545198252926724,957.91157160338764,704.65313275421818,2.5405030125583762E-3,5.7467798451336902,1.188038502673797,2.6042780748663104,0.31396243377355593]
[42,8.7514033825232054E-2,1.5885947046843176,753.04259894891254,316.27789155854333,738.18181818181813,1807.5023086892741,2365.296833752087,70.071044142252845,118.44304414225287,154.99452252029747,19.348799999999997,135.64572252029745,541.99459185975252,1247.2556169173304,0.16920565251449177,29.565470711799346,960.94139887324468,705.26102505757797,2.502226941898127E-3,5.6056835313802278,1.1588694971016764,2.5885947046843176,0.33179459526259836]
[44,8.4704557527757407E-2,1.574344023323615,759.8056365403304,334.31448007774543,773.33333333333326,1867.4534499514091,2447.2001371977362,68.437213294460648,116.80921329446063,153.07236858171839,19.348799999999997,133.72356858171838,544.41803175743439,1250.2421860256591,0.16934075801749285,29.584250376716497,963.74610430930852,705.82415426822467,2.4667693890743107E-3,5.4749770635568522,1.1318483965014581,2.574344023323615,0.35022111321166377]
[46,8.2088376345004252E-2,1.5613382899628254,766.08555013759474,352.39935306329357,808.4848484848485,1926.9697516857368,2528.5918647283179,66.919438056293146,115.29143805629316,151.28675065446254,19.348799999999997,131.93795065446255,546.66763959575144,1253.0149224197648,0.16946626659585784,29.601696069109227,966.34989532032364,706.3472828240134,2.433830486155E-3,5.3535550445034517,1.1067466808284654,2.5613382899628254,0.36928546036784909]
[48,7.9644590183947941E-2,1.5494211932324133,771.93232413178964,370.52751558325912,843.63636363636363,1986.0962033514124,2609.524945119309,65.505791059661604,113.8777910596616,149.62363654077839,19.348799999999997,130.27483654077838,548.76148640142469,1255.5960081084731,0.16958316455307537,29.617944885162466,968.77362626546039,706.83452170704857,2.4031513842608077E-3,5.240463284772928,1.0833670893849601,2.5494211932324133,0.38903333058785394]
[50,7.7355371900826433E-2,1.5384615384615385,777.38927738927748,388.6946386946388,878.78787878787875,2044.8717948717949,2690.0452488687788,64.185923076923103,112.55792307692309,148.07085067873305,19.348799999999997,128.72205067873307,550.71521999999982,1258.0046579649229,0.16969230769230784,29.63311578151578,971.03536003291003,707.28943796492308,2.3745074834667602E-3,5.1348738461538481,1.0615384615384622,2.5384615384615383,0.40951306413301669]
[52,7.5205403691527187E-2,1.5283483976992605,782.49413851184465,406.89695202615928,913.93939393939388,2103.3304844773979,2770.1927268361542,62.950810757282582,111.3228107572826,146.6177773615089,19.348799999999997,127.2689773615089,552.54245842063233,1260.2576000785414,0.1697944421766906,29.647312474844981,973.15082031209454,707.71514165790904,2.3477029581536416E-3,5.0360648605826066,1.0411115646619133,2.5283483976992605,0.43077608677674656]
[60,6.7757181044064557E-2,1.4946619217081851,799.9963026297545,479.99778157785278,1054.5454545454545,2334.5395387530616,3087.6935750036018,58.713328642602953,107.08532864260293,141.63250428541522,19.348799999999997,122.28370428541523,558.80410535597343,1267.9797714993847,0.17014485002541957,29.69601916581831,980.40131251377443,709.17566614341126,2.2557407173107403E-3,4.6970662914082366,0.97102999491611619,2.4946619217081851,0.52482457624068135]
[70,6.0395022729969584E-2,1.4634146341463414,816.95121951219505,571.86585365853659,1230.3030303030303,2619.1201034737619,3479.3569844789354,54.604319268292677,102.9763192682927,136.79837560975611,19.348799999999997,117.44957560975611,564.86562273658524,1275.4575329230211,0.1704846341463416,29.743249158626476,987.42169517314494,710.59191018643594,2.16656660412758E-3,4.3683455414634142,0.90307317073170734,2.4634146341463414,0.66807863114856358]
[80,5.4539636984176229E-2,1.44,830.13818181818181,664.11054545454544,1406.060606060606,2900.3093333333331,3867.0305882352941,51.405891840000002,99.777891839999995,133.03551981176471,19.348799999999997,113.68671981176472,569.57728158719988,1281.2715873584907,0.17074912000000017,29.780012692285013,992.87972881345831,711.69430577129094,2.0971540271493214E-3,4.1124713472000005,0.85017600000000026,2.44,0.85184344761271547]
[100,4.5767373090192201E-2,1.4072494669509594,849.31893073005699,849.31893073005722,1757.5757575757575,3456.2136190358715,4634.7611204343593,46.749911223105265,95.121911223105272,127.55789555659443,19.348799999999997,108.20909555659443,576.42640538088767,1289.7254786794424,0.17113413452219436,29.83352971087001,1000.8153573447667,713.29907329855473,1.9961094919128284E-3,3.7399928978484214,0.77317309556115565,2.4072494669509594,1.4411888360797636]
[120,3.9478283258345515E-2,1.3854351687388988,862.59772199381428,1035.1172663925772,2109.090909090909,4006.8058974773003,5396.2422323262363,43.524093258641891,91.896093258641883,123.76281559840223,19.348799999999997,104.41401559840223,581.16534707539267,1295.5762566001231,0.17140088536685355,29.870608078277634,1006.3070655968415,714.41090952473041,1.9261024829072537E-3,3.4819274606913515,0.71982292662932112,2.3854351687388986,2.8356045016521176]
[140,3.4733089162007388E-2,1.3698630136986301,872.33540888335403,1221.2695724366959,2460.6060606060605,4554.2110419261107,6153.973774815031,41.15728306849315,89.529283068493157,120.97833302175664,19.348799999999997,101.62953302175664,584.63920598794516,1299.8658792472938,0.17159660273972616,29.89781279310693,1010.3332357615745,715.22667325934856,1.8747377425153411E-3,3.292582645479452,0.68067945205479463,2.3698630136986303,10.315127957381666]
[160,3.1018755679874496E-2,1.3581890812250332,879.7818238783226,1407.6509182053164,2812.121212121212,5099.5539542048509,6909.2791618096289,39.346702454766195,87.718702454766202,118.84823818207789,19.348799999999997,99.499438182077895,587.29493417867923,1303.1456566369998,0.17174632411686394,29.91862406452908,1013.4114752504698,715.85072245832055,1.8354443494203634E-3,3.1477361963812958,0.65073517662724223,2.3581890812250332,0]
[180,2.8029097887281643E-2,1.349112426035503,885.66054188726264,1594.1889753970729,3163.6363636363635,5643.4858809206989,7662.9245657890579,37.916899119277488,86.288899119277502,117.16611661091471,19.348799999999997,97.817316610914716,589.39111330979733,1305.7346432241543,0.17186455808159465,29.935058585626649,1015.8413087125871,716.34352991435685,1.804414621119991E-3,3.0333519295421993,0.62708838368109643,2.3491124260355027,0]
[190,2.6742239587282099E-2,1.3452914798206279,888.15898899306956,1687.5020790868323,3339.393939393939,5915.0550074738412,8039.2804009496176,37.309128376681613,85.681128376681613,116.45109220786073,19.348799999999997,97.102292207860728,590.28187178582948,1306.8348808264952,0.17191481614349791,29.942044456231201,1016.8738946242447,716.55300904066576,1.7912247225209505E-3,2.9847302701345293,0.61703677130044854,2.3452914798206281,0]

{"sheet":"Charts","index":3,"n_rows":33,"n_cols":2,"rows_kept":33,"cut":false,"hidden":false,"merged":[[1,1,1,23],[32,1,32,23]]}
[]
[null,"Current Conditions"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Alternate Scenario"]

{"sheet":"©","index":4,"n_rows":7,"n_cols":2,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
["©","All Rights Reserved."]