{"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)",1,null,"Total average daily flow rate (mgd)",1]
[null,null,"So (mg/L)",200,null,"So (mg/L)",200,null,2,null,null,null,"Aeration volume in service (mil gal)",1,null,"Aeration volume in service (mil gal)",1]
[null,null,"V (mil gal)",1,null,"V (mil gal)",1,null,4,null,null,null,"Influent BOD5 concentration (mg/L)",200,null,"Influent BOD5 concentration (mg/L)",200]
[null,null," Q (mgd)",1,null," Q (mgd)",1,null,6,null,null,null,"Influent BOD5 mass loading (lb/day)",1668,null,"Influent BOD5 mass loading (lb/day)",1668]
[null,null,"Inert VSS (mg/L)",40,null,"Inert VSS (mg/L)",40,null,8,null,null,null,"Sec ww Oxid N load (lb/day) ",291.89999999999998,null,"Sec ww Oxid N load (lb/day) ",291.89999999999998]
[null,null,"Oxidizable N (mg/L)",35,null,"Oxidizable N (mg/L)",35,null,10,null,null,null,"Sec ww TSS load (lb/day)",1668,null,"Sec ww TSS load (lb/day)",1668]
[null,null,"biomass (VSS/TSS)",0.85,null,"biomass (VSS/TSS)",0.85,null,12,null,null,null,"F/M ratio",8.9209641262054051E-2,null,"F/M ratio",8.9209641262054051E-2]
[null,null,"Influent TSS (mg/L)",200,null,"Influent TSS (mg/L)",200,null,14,null,null,null,"Solids Retention Time (day)",28,null,"Solids Retention Time (day)",28]
[null,null,"Inert Inorg TSS (mg/L)",20,null," Inert Inorg TSS (mg/L)",20,null,16,null,null,null,"MLSS (mg/L)",2999.8942911733889,null,"MLSS (mg/L)",2999.8942911733889]
[null,null,"Effluent TSS (mg/L)",8,null,"Effluent TSS (mg/L)",8,null,18,null,null,null,"MLVSS (mg/L)",2241.9101474973804,null,"MLVSS (mg/L)",2241.9101474973804]
[null,null,"RAS TSS (mg/L)",10000,null,"RAS TSS (mg/L)",10000,null,20,null,null,null,"TSS Sludge Production (lb/day)",826.81994244235932,null,"TSS Sludge Production (lb/day)",826.81994244235932]
[null,null,"MLSS (mg/L)",3000,null,"MLSS (mg/L)",3000,null,22,null,null,null,"TSS in activated sludge effluent (lb/day)",66.72,null,"TSS in activated sludge effluent (lb/day)",66.72]
[null,null,"fd",0.1,null,"fd",0.1,null,24,null,null,null,"Total Oxygen Requirements (lb/day)",3121.4484522694092,null,"Total Oxygen Requirements (lb/day)",3121.4484522694092]
[null,null,"Y",0.6,null,"Y",0.6,null,26,null,null,null,"Total Oxygen Req'd W/Denit. (lb/day)",2686.9240715561195,null,"Total Oxygen Req'd W/Denit. (lb/day)",2686.9240715561195]
[null,null,"Ks (mg/L)",60,null,"Ks (mg/L)",60,null,28,null,null,null,"Total oxygen supplied (lb/day)",3394.1587715234386,null,"Total oxygen supplied (lb/day)",3184.7306829979789]
[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)",150,null,"Mixing intensity in the reactor (hp/mil gal)",85]
[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.42854985566728598,null,"RAS flow rate (mgd)",0.42854985566728598]
[null,null,null,null,null,null,null,null,34,null,null,null,"RAS recycle percentage (%)",42.854985566728601,null,"RAS recycle percentage (%)",42.854985566728601]
[null,null,"Aerator Performance Data ",null,null,"Aerator Performance Data ",null,null,36,null,null,null,"WAS flow rate (mgd)",9.9139081827621014E-3,null,"WAS flow rate (mgd)",9.9139081827621014E-3]
[null,null,null,null,null,null,null,null,38,null,null,null,"RAS TSS concentration (mg/L)",10000,null,"RAS TSS concentration (mg/L)",10000]
[null,null,"Operating DO concentration (mg/L)",4.5,null,"Operating DO concentration (mg/L)",2,null,40,null,null,null,"Total sludge production (lb/day)",893.53994244235935,null,"Total sludge production  (lb/day)",893.53994244235935]
[null,null,"alpha",0.84,null,"alpha",0.84,null,42,null,null,null,"Reactor Detention Time (hr)",24,null,"Reactor Detention Time (hr)",24]
[null,null,"beta",0.92,null,"beta",0.92,null,44,null,null,null,"VOLR (lb BOD/(thou cu ft-day))",12.476625028049966,null,"VOLR (lb BOD/(thou cu ft-day))",12.476625028049966]
[null,null,"SOTR, lb O2 / hp-hr",2.7,null,"SOTR, lb O2 / hp-hr",2.7,null,46,null,null,null,"Effluent CBOD5 (mg/L)",3.9943872876837556,null,"Effluent CBOD5 (mg/L)",3.9943872876837556]
[null,null,"Temperature (°C)",20,null,"Temperature (°C)",20,null,48,null,null,null,"Effluent TSS (mg/L)",8,null,"Effluent TSS (mg/L)",8]
[null,null,"Aeration (hp) being operated",150,null,"Aeration (hp) being operated",100,null,50,null,null,null,"Effluent Ammonia-N (mg/L)",0.37528386697831906,null,"Effluent Ammonia-N (mg/L)",0.37528386697831906]
[null,null,"Elevation (ft)",200,null,"Elevation (ft)",200,null,52,null,null,null,"Effluent NO3-N (mg/L)",26.024597747174269,null,"Effluent NO3-N (mg/L)",26.024597747174269]
[null,null,"Aerators operating time (hr/day)",24,null,"Aerators operating time (hr/day)",24,null,54,null,null,null,"Effluent NO3-N W/denit (mg/L)",7.8073793241522802,null,"Effluent NO3-N W/denit (mg/L)",7.8073793241522802]
[null,null,"Type of aerators (1, 2, or 3)",1,null,"Type of aerators (1, 2, or 3)",1,null,56]
[null,null,"Speed of aerators (%)",100,null,"Speed of aerators (%)",85,null,58,null,null,null,"Actual Aerator Performance",null,null,"Actual Aerator Performance"]
[null,null,"Energy cost unit ($/kWh)",0.09,null,"Energy cost unit ($/kWh)",0.09,null,60]
[null,null,null,null,null,null,null,null,62,null,null,null,"Field OTR ( lb O2 / hp-hr)",0.94282188097873287,null,"Field OTR ( lb O2 / hp-hr)",1.561142491665676]
[null,null,null,null,null,null,null,null,64,null,null,null,"Aerator energy use (kWh/month)",70200,null,"Aerator energy use (kWh/month)",39780]
[null,null,null,null,null,null,null,null,66,null,null,null,"Energy cost ($/month)",6318,null,"Energy cost ($/month)",3580.2]
[null,null,null,null,null,null,null,null,68,null,null,null,null,null,null,"Cost savings vs. current conditions ($/month)",2737.8]
[null,null,null,null,null,null,null,null,70]

{"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.4249602621646793,17.837837837837839,99.361179361179353,0.99361179361179364,40,140.35479115479114,178.06446018210721,836.95895823095816,1170.5589582309581,1485.057597918774,66.72,1418.337597918774,1090.3669279606881,1173.2712404910076,20.661682555282557,null,null,82.90431253031943,1.7006446018210719E-2,100.43507498771497,12.042574938574937,22.691376473958957,1.8129263774969623E-2]
[2,0.72659331534149885,8.5714285714285712,191.42857142857142,3.8285714285714287,80,275.25714285714287,349.71428571428567,814.22228571428559,1147.8222857142857,1458.3085714285712,66.72,1391.5885714285712,1238.5757828571427,1424.3399730819428,18.238116000000005,2.4377257199017164,1383.6380468089742,185.76419022480005,1.6685714285714283E-2,96.892451999999977,11.617799999999997,13.231696516936411,3.623874940786357E-2]
[4,0.39357841749888811,4.7191011235955056,334.76725521669346,13.390690208667738,160,508.15794542536122,649.59758285336613,725.90931621187815,1059.5093162118781,1354.4109602492683,66.72,1287.6909602492683,1412.1728159229533,1797.5276708879305,14.145336654895669,6.7022414038751998,1685.6224908846755,385.35485496497722,1.5439939571334152E-2,84.931389996789733,10.183619903691815,9.0235235595583845,6.9472687256983023E-2]
[6,0.28225371288156142,3.5294117647058818,442.05882352941171,26.523529411764706,240,708.5823529411764,911.27335640138404,651.32947058823515,984.92947058823518,1266.6699653979238,66.72,1199.9499653979237,1532.9592105882352,2124.9056293642061,9.6269701470588238,11.800065701690997,1927.883708364096,591.94641877597064,1.4387889273356399E-2,74.902889117647035,8.9811617647058792,7.5162299314950012,0.10026413953633573]
[8,0.22535169641801633,2.9508196721311473,525.46448087431691,42.037158469945354,320,887.50163934426223,1147.6489874638378,591.6204590163934,925.22045901639331,1196.4240694310508,66.72,1129.7040694310508,1624.9841940983606,2424.0356750968131,4.8571270819672145,17.415201186450236,2133.2596337510331,799.05148099845246,1.3545612343297972E-2,66.853111868852451,8.0159606557377039,6.6551976631353069,0.12964341177147257]
[10,0.19022413365313043,2.6086956521739131,592.17391304347825,59.217391304347835,400,1051.391304347826,1366.3427109974425,543.2603478260869,876.86034782608692,1139.5298209718671,66.72,1072.8098209718671,1697.9355234782608,2620.5297201806611,2.2215645217391295,20.846183763700463,2272.4676606569587,922.59419670240015,1.2863427109974426E-2,60.301898608695637,7.2304434782608675,6.0628842441739135,0.15825769604474252]
[12,0.16606367078430453,2.382671480144404,646.74762061043634,77.609714473252367,480,1204.3573350836887,1572.1851000984573,503.42834788316367,837.02834788316352,1092.6686445684279,66.72,1025.9486445684279,1757.3245257893009,2742.5954915329007,1.136816834919594,22.529513416723585,2366.4274154581603,985.27096574359985,1.2301542500820477E-2,54.873689919264841,6.5795791270101729,5.6161676364682442,0.18654717963927092]
[14,0.14824331669713892,2.2222222222222228,692.22222222222206,96.911111111111097,560,1349.1333333333332,1768.392156862745,470.0979999999999,803.69799999999998,1053.4564705882351,66.72,986.73647058823508,1806.66084,2821.4029587513996,0.86906300000000081,23.279197686322686,2432.7176443261296,1014.7421187513999,1.1831372549019606E-2,50.300485999999985,6.0312333333333319,5.2619242686811027,0.21482949510733373]
[16,0.13444379128926887,2.1024258760107815,730.69873522703699,116.91179763632593,640,1487.610532863363,1957.1888621921917,441.81699025502792,775.41699025502794,1020.1846944176799,66.72,953.46469441767988,1848.3185261289655,2885.8601137803839,0.70650134107402096,23.843259704204009,2487.7568363423952,1037.5415876514185,1.1432430388701198E-2,46.390783976777932,5.5624441219158189,4.9727843496159014,0.243346365923203]
[18,0.12337002727295573,2.0095693779904304,763.67737525632253,137.46192754613807,720,1621.1393028024606,2140.163885649954,417.52787696514008,751.1278769651401,991.60926701781193,66.72,924.8892670178119,1883.9707017908404,2937.974741615807,0.65655657443609083,24.274480449598197,2532.6715093826097,1054.0040398249664,1.1089799364721965E-2,43.005371327409428,5.1565193438140797,4.7327335484505895,0.27229115906660739]
[20,0.11423938679245281,1.935483870967742,792.25806451612914,158.45161290322585,800,1750.7096774193551,2318.4819734345356,396.44593548387104,730.04593548387106,966.80698292220131,66.72,900.08698292220129,1914.833868387097,2983.5721814412391,0.60397832258064565,24.619843605294445,2572.5025311135914,1068.7383130541418,1.0792409867172677E-2,40.041039483870975,4.8010838709677426,4.5314439349677418,0.30182601478202453]
[22,0.10654937356460097,1.875,817.265625,179.79843750000003,880,1877.0640625000001,2493.0165441176473,377.97792187499999,711.57792187500002,945.07990808823536,66.72,878.35990808823533,1941.8151009374999,3023.8801194912066,0.54923781093750046,25.023706071606263,2606.0673067995399,1082.0650185537065,1.0531893382352941E-2,37.419814265624993,4.4867882812499991,4.3617249482598393,0.33209298498775286]
[24,9.9961509086178277E-2,1.8246869409660107,839.33073766179075,201.4393770388298,960,2000.7701147006205,2664.4354290595538,361.66761485846564,695.26761485846555,925.89131159819499,66.72,859.17131159819496,1965.6051532694937,3059.8357705914568,0.49269686591602696,25.340830867862081,2636.7280266566413,1094.2306173219629,1.0301814287748141E-2,35.081758641271165,4.2064458802483413,4.2182580980808906,0.36322159028012801]
[26,9.4238746867261469E-2,1.7821782178217822,858.94389438943892,223.32541254125417,1040,2122.2693069306929,2833.2580081537567,347.15869306930693,680.7586930693069,908.82199184624346,66.72,842.10199184624344,1986.7396063366334,3092.1671521400908,0.43463776237623802,25.726972780840246,2662.6121202496911,1105.4275458034574,1.0097146185206756E-2,32.98007584158416,3.9544455445544555,4.0969184548829016,0.39533417156320338]
[28,8.9209641262054051E-2,1.745788667687596,876.49230273232843,245.417844765052,1120,2241.9101474973804,2999.8942911733889,334.1689510760055,667.76895107600546,893.53994244235935,66.72,826.81994244235932,2005.6402732393005,3121.4484522694092,0.37528386697831906,26.024597747174269,2686.9240715561195,1115.8081790301089,9.9139081827621014E-3,31.07771245006851,3.7263444184734427,3.9943872876837556,0.42854985566728598]
[30,8.47467887020424E-2,1.7142857142857142,892.28571428571422,267.68571428571431,1200,2359.9714285714285,3164.6722689075632,322.47205714285712,656.07205714285715,879.77889075630253,66.72,813.0588907563025,2022.6439645714288,3148.1386665421887,0.31481420000000027,26.313664812285012,2708.787825544206,1125.4947019707597,9.7489075630252092E-3,29.344957199999996,3.5185799999999996,3.9079190102857142,0.46298764205732951]
[32,8.0753304630930986E-2,1.6867469879518071,906.57487091222026,290.10395869191052,1280,2476.6788296041309,3327.8574465930951,311.88441996557663,645.48441996557665,867.32284701832543,66.72,800.60284701832541,2038.0229188296039,3171.4653949977687,0.28504563304647185,26.476655282852999,2729.3931542696628,1133.4424761681648,9.5995545206034229E-3,27.757713376936319,3.3282629948364892,3.8351944740676469,0.49876893665796107]
[34,7.7154034823872009E-2,1.6624685138539042,919.5649187084955,312.65207236088855,1360,2592.2169910693842,3489.6670483169223,302.2555795740783,635.85557957407843,855.99479949891565,66.72,789.27479949891563,2051.9995958964964,3192.8633821101962,0.2547757933592858,26.629591137863212,2748.2376203504582,1140.8637862136998,9.4637266126968295E-3,26.296235422944811,3.1530258300893061,3.7742248289847842,0.53601975109656397]
[36,7.3889666329042508E-2,1.6409036860879904,931.42532182184766,335.31311585586519,1440,2706.7384376777127,3650.2805149149563,293.46107139533683,627.06107139533674,845.64831928863146,66.72,778.92831928863143,2064.7575735056607,3212.584795609896,0.22406362859949355,26.773784243634854,2765.5514877048827,1147.8272221042355,9.3396680969859876E-3,24.944191068603629,2.9909102000723777,3.7232861704451103,0.57487272051767924]
[38,7.0912674874010206E-2,1.6216216216216219,942.29729729729729,358.07297297297305,1520,2820.3702702702703,3809.8473767885534,285.39705405405408,618.99705405405405,836.16124006359303,66.72,769.441240063593,2076.4496967567566,3230.8397005838087,0.19295830540540559,26.910329004176905,2781.5265485063483,1154.3900038270524,9.2259141494435617E-3,23.687955486486487,2.8402824324324327,3.6808735660337835,0.6154690536227857]
[40,6.8184469984248292E-2,1.6042780748663101,952.29946524064178,380.91978609625676,1600,2933.2192513368987,3968.4932368669397,277.97621390374337,611.57621390374334,827.43083988675698,66.72,760.71083988675696,2087.2042575401069,3249.0021168463318,0.16166780748663115,27.063310252926723,2797.1346858124953,1161.7978593062246,9.1212330921673496E-3,22.238097112299471,2.6664385026737976,3.6042780748663104,0.65796050517988802]
[42,6.5673341683303119E-2,1.5885947046843176,961.53219489268372,403.84352185492725,1680,3045.375716747611,4126.3243726442488,271.12460661131132,604.7246066113114,819.37012542507227,66.72,752.65012542507225,2097.1297388563371,3261.2891279448295,0.16199642174526097,27.108987634876271,2808.6590362813436,1164.1593890884924,9.0245818396291633E-3,21.689968528904906,2.6007156509478304,3.5885947046843176,0.70251144844065283]
[44,6.3352956126507917E-2,1.574344023323615,970.08098477486226,426.83563330093943,1760,3156.9166180758016,4283.4313153832964,264.77919533527694,598.3791953352769,811.90493568856118,66.72,745.18493568856115,2106.3184988921284,3272.6649481943095,0.16230075801749286,27.151290376716499,2819.3285411871948,1166.3464493021809,8.9350711713256734E-3,21.182335626822155,2.5398483965014576,3.574344023323615,0.74930111955271661]
[46,6.1201234958366428E-2,1.5613382899628254,978.01911842804009,449.88879447689851,1840,3267.9079129049387,4439.8916622411043,258.88591290493889,592.48591290493891,804.97166224110458,66.72,738.25166224110455,2114.8496616675516,3283.2273368384322,0.16258340945300068,27.190578926252087,2829.2349414920577,1168.3776751708804,8.8519383961763141E-3,20.71087303239511,2.4833181093998933,3.5613382899628254,0.7985261064230782]
[48,5.9199507914974393E-2,1.5494211932324133,985.40977062670777,472.99668990081977,1920,3378.4064605275275,4595.7723065029732,253.39812251665788,586.99812251665787,798.51543825489159,66.72,731.79543825489156,2122.7914068990085,3293.0605478074367,0.16284661282893739,27.227164195507292,2838.4572999275942,1170.2691409084284,8.7745256385478605E-3,20.271849801332632,2.4306774342125457,3.5494211932324133,0.85040315973975744]
[50,5.7331863285556783E-2,1.5384615384615385,992.30769230769226,496.15384615384619,2000,3488.4615384615386,4751.1312217194572,248.27538461538464,581.87538461538463,792.48868778280553,66.72,725.7686877828055,2130.2028,3302.2375847353851,0.16309230769230784,27.26131578151578,2847.0641187524661,1172.0347847353848,8.7022624434389146E-3,19.86203076923077,2.3815384615384616,3.5384615384615383,0.90517241379310354]
[52,5.558464384244434E-2,1.5283483976992605,998.76056935351323,519.35549606382699,2080,3598.11606541734,4906.018900490988,243.48246126116572,577.08246126116569,786.84995442490072,66.72,720.12995442490069,2137.1352665539266,3310.8220185959631,0.16332218411217445,27.293268603877241,2855.115046562978,1173.6867520420365,8.6346517317134382E-3,19.478596900893258,2.3355631775651391,3.5283483976992605,0.96310111966529655]
[54,5.3946051217337032E-2,1.5189873417721518,1004.8101265822784,542.59746835443036,2160,3707.4075949367088,5060.479523454952,238.98850632911393,572.5885063291139,781.56294862248694,66.72,714.84294862248692,2143.6337893670884,3318.8694638676452,0.16353772151898749,27.323228303424251,2862.6622643184278,1175.235674500557,8.571258376768429E-3,19.119080506329116,2.292455696202532,3.518987341772152,1.0244880140661972]
[56,5.2405832159698532E-2,1.5102974828375288,1010.4930309964634,565.87609735801971,2240,3816.3691283544831,5214.5519157111567,234.76640232993552,568.36640232993545,776.5957674469829,66.72,709.87576744698288,2149.7378871811943,3326.42878582294,0.16374022051175385,27.351375663418775,2869.751618811049,1176.6908986417459,8.511699849484208E-3,18.781312186394842,2.2519558976492617,3.5102974828375286,1.0896684748981205]
[58,5.0955027348013007E-2,1.5022091310751104,1015.8416356233213,589.18814866152638,2320,3925.0297842848477,5368.2703344527617,230.79221380923499,564.39221380923505,771.92025154027647,66.72,705.20025154027644,2155.4824201611364,3333.5430944119353,0.16393082907389775,27.377870253556779,2876.4235557067791,1178.0606742507987,8.455638507677176E-3,18.4633771047388,2.2138341852204797,3.5022091310751104,1.159020651482366]
[60,4.9585768506306242E-2,1.4946619217081851,1020.8845958312151,612.53075749872914,2400,4033.4153533299441,5521.6651215646398,227.04473411286224,560.64473411286224,767.5114518974849,66.72,700.79145189748488,2160.8982569191658,3340.2505675019538,0.16411056431113383,27.402853451532597,2882.7138923348184,1179.3523105827878,8.4027752026077322E-3,18.163578729028981,2.1778871377732592,3.4946619217081851,1.23297280606532]
[62,4.8291113197961241E-2,1.4876033057851239,1025.6473829201102,635.9013774104684,2480,4141.5487603305783,5674.7632474477396,223.50510743801655,557.10510743801649,763.3471852211959,66.72,696.62718522119587,2166.012830082645,3346.5851367121986,0.16428033057851252,27.426450962698233,2888.6544614523345,1180.5723066295536,8.3528439474963526E-3,17.880408595041324,2.1439338842975211,3.4876033057851239,1.3120121676805652]
[64,4.706490928073475E-2,1.4809873248832555,1030.1527144222273,659.29773723022561,2560,4249.450451652453,5827.5887666499448,220.15651198096029,553.75651198096023,759.40766115407087,66.72,692.68766115407084,2170.8506015527469,3352.577061881293,0.1644409346771723,27.448774932411943,2894.2736504427894,1181.7264603285462,8.3056074478905385E-3,17.612520958476825,2.1118130645655664,3.4809873248832552,1.3966956852359294]
[66,4.590168291439977E-2,1.47477360931436,1034.4209164567303,682.717804861442,2640,4357.1387213181724,5980.1632015507912,216.98389296656904,550.58389296656901,755.67516819596358,66.72,688.95516819596355,2175.433454134949,3358.2534147139477,0.16459309865867788,27.469925725841218,2899.5968552458089,1182.8199605789985,8.2608533356830164E-3,17.358711437325525,2.0813802682644513,3.4747736093143597,1.4876631817137069]
[68,4.4796545421244054E-2,1.4689265536723164,1038.4702303346371,706.15975662755341,2720,4464.6299869621907,6132.5058670143417,213.97373663624512,547.57373663624514,752.13380780734713,66.72,685.4138078073471,2179.7810227900914,3363.6384879311499,0.16473747066492844,27.489993434710044,2904.6468643496955,1183.8574651410588,8.2183909809034426E-3,17.11789893089961,2.0525058670143417,3.4689265536723166,1.5856535669208947]
[70,4.3745115351067891E-2,1.4634146341463414,1042.3170731707316,729.6219512195122,2800,4571.9390243902435,6284.6341463414637,211.11387804878049,544.71387804878043,748.76926829268302,66.72,682.049268292683,2183.9109760975607,3368.7541429782436,0.1648746341463416,27.509059158626474,2909.4441851055881,1184.8431668806829,8.1780487804878049E-3,16.88911024390244,2.0250731707317073,3.4634146341463414,1.6915249786647413]

{"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.4249602621646793,17.837837837837839,99.361179361179353,0.99361179361179364,40,140.35479115479114,178.06446018210721,836.95895823095816,1170.5589582309581,1485.057597918774,66.72,1418.337597918774,1090.3669279606881,1173.2712404910076,20.661682555282557,null,null,82.90431253031943,1.7006446018210719E-2,100.43507498771497,12.042574938574937,22.691376473958957,1.8129263774969623E-2]
[2,0.72659331534149885,8.5714285714285712,191.42857142857142,3.8285714285714287,80,275.25714285714287,349.71428571428567,814.22228571428559,1147.8222857142857,1458.3085714285712,66.72,1391.5885714285712,1238.5757828571427,1424.3399730819428,18.238116000000005,2.4377257199017164,1383.6380468089742,185.76419022480005,1.6685714285714283E-2,96.892451999999977,11.617799999999997,13.231696516936411,3.623874940786357E-2]
[4,0.39357841749888811,4.7191011235955056,334.76725521669346,13.390690208667738,160,508.15794542536122,649.59758285336613,725.90931621187815,1059.5093162118781,1354.4109602492683,66.72,1287.6909602492683,1412.1728159229533,1797.5276708879305,14.145336654895669,6.7022414038751998,1685.6224908846755,385.35485496497722,1.5439939571334152E-2,84.931389996789733,10.183619903691815,9.0235235595583845,6.9472687256983023E-2]
[6,0.28225371288156142,3.5294117647058818,442.05882352941171,26.523529411764706,240,708.5823529411764,911.27335640138404,651.32947058823515,984.92947058823518,1266.6699653979238,66.72,1199.9499653979237,1532.9592105882352,2124.9056293642061,9.6269701470588238,11.800065701690997,1927.883708364096,591.94641877597064,1.4387889273356399E-2,74.902889117647035,8.9811617647058792,7.5162299314950012,0.10026413953633573]
[8,0.22535169641801633,2.9508196721311473,525.46448087431691,42.037158469945354,320,887.50163934426223,1147.6489874638378,591.6204590163934,925.22045901639331,1196.4240694310508,66.72,1129.7040694310508,1624.9841940983606,2424.0356750968131,4.8571270819672145,17.415201186450236,2133.2596337510331,799.05148099845246,1.3545612343297972E-2,66.853111868852451,8.0159606557377039,6.6551976631353069,0.12964341177147257]
[10,0.19022413365313043,2.6086956521739131,592.17391304347825,59.217391304347835,400,1051.391304347826,1366.3427109974425,543.2603478260869,876.86034782608692,1139.5298209718671,66.72,1072.8098209718671,1697.9355234782608,2620.5297201806611,2.2215645217391295,20.846183763700463,2272.4676606569587,922.59419670240015,1.2863427109974426E-2,60.301898608695637,7.2304434782608675,6.0628842441739135,0.15825769604474252]
[12,0.16606367078430453,2.382671480144404,646.74762061043634,77.609714473252367,480,1204.3573350836887,1572.1851000984573,503.42834788316367,837.02834788316352,1092.6686445684279,66.72,1025.9486445684279,1757.3245257893009,2742.5954915329007,1.136816834919594,22.529513416723585,2366.4274154581603,985.27096574359985,1.2301542500820477E-2,54.873689919264841,6.5795791270101729,5.6161676364682442,0.18654717963927092]
[14,0.14824331669713892,2.2222222222222228,692.22222222222206,96.911111111111097,560,1349.1333333333332,1768.392156862745,470.0979999999999,803.69799999999998,1053.4564705882351,66.72,986.73647058823508,1806.66084,2821.4029587513996,0.86906300000000081,23.279197686322686,2432.7176443261296,1014.7421187513999,1.1831372549019606E-2,50.300485999999985,6.0312333333333319,5.2619242686811027,0.21482949510733373]
[16,0.13444379128926887,2.1024258760107815,730.69873522703699,116.91179763632593,640,1487.610532863363,1957.1888621921917,441.81699025502792,775.41699025502794,1020.1846944176799,66.72,953.46469441767988,1848.3185261289655,2885.8601137803839,0.70650134107402096,23.843259704204009,2487.7568363423952,1037.5415876514185,1.1432430388701198E-2,46.390783976777932,5.5624441219158189,4.9727843496159014,0.243346365923203]
[18,0.12337002727295573,2.0095693779904304,763.67737525632253,137.46192754613807,720,1621.1393028024606,2140.163885649954,417.52787696514008,751.1278769651401,991.60926701781193,66.72,924.8892670178119,1883.9707017908404,2937.974741615807,0.65655657443609083,24.274480449598197,2532.6715093826097,1054.0040398249664,1.1089799364721965E-2,43.005371327409428,5.1565193438140797,4.7327335484505895,0.27229115906660739]
[20,0.11423938679245281,1.935483870967742,792.25806451612914,158.45161290322585,800,1750.7096774193551,2318.4819734345356,396.44593548387104,730.04593548387106,966.80698292220131,66.72,900.08698292220129,1914.833868387097,2983.5721814412391,0.60397832258064565,24.619843605294445,2572.5025311135914,1068.7383130541418,1.0792409867172677E-2,40.041039483870975,4.8010838709677426,4.5314439349677418,0.30182601478202453]
[22,0.10654937356460097,1.875,817.265625,179.79843750000003,880,1877.0640625000001,2493.0165441176473,377.97792187499999,711.57792187500002,945.07990808823536,66.72,878.35990808823533,1941.8151009374999,3023.8801194912066,0.54923781093750046,25.023706071606263,2606.0673067995399,1082.0650185537065,1.0531893382352941E-2,37.419814265624993,4.4867882812499991,4.3617249482598393,0.33209298498775286]
[24,9.9961509086178277E-2,1.8246869409660107,839.33073766179075,201.4393770388298,960,2000.7701147006205,2664.4354290595538,361.66761485846564,695.26761485846555,925.89131159819499,66.72,859.17131159819496,1965.6051532694937,3059.8357705914568,0.49269686591602696,25.340830867862081,2636.7280266566413,1094.2306173219629,1.0301814287748141E-2,35.081758641271165,4.2064458802483413,4.2182580980808906,0.36322159028012801]
[26,9.4238746867261469E-2,1.7821782178217822,858.94389438943892,223.32541254125417,1040,2122.2693069306929,2833.2580081537567,347.15869306930693,680.7586930693069,908.82199184624346,66.72,842.10199184624344,1986.7396063366334,3092.1671521400908,0.43463776237623802,25.726972780840246,2662.6121202496911,1105.4275458034574,1.0097146185206756E-2,32.98007584158416,3.9544455445544555,4.0969184548829016,0.39533417156320338]
[28,8.9209641262054051E-2,1.745788667687596,876.49230273232843,245.41784476505197,1120,2241.9101474973804,2999.8942911733889,334.1689510760055,667.76895107600546,893.53994244235935,66.72,826.81994244235932,2005.6402732393005,3121.4484522694092,0.37528386697831906,26.024597747174269,2686.9240715561195,1115.8081790301089,9.9139081827621014E-3,31.07771245006851,3.7263444184734427,3.9943872876837556,0.42854985566728598]
[30,8.47467887020424E-2,1.7142857142857142,892.28571428571422,267.68571428571431,1200,2359.9714285714285,3164.6722689075632,322.47205714285712,656.07205714285715,879.77889075630253,66.72,813.0588907563025,2022.6439645714288,3148.1386665421887,0.31481420000000027,26.313664812285012,2708.787825544206,1125.4947019707597,9.7489075630252092E-3,29.344957199999996,3.5185799999999996,3.9079190102857142,0.46298764205732951]
[32,8.0753304630930986E-2,1.6867469879518071,906.57487091222026,290.10395869191052,1280,2476.6788296041309,3327.8574465930951,311.88441996557663,645.48441996557665,867.32284701832543,66.72,800.60284701832541,2038.0229188296039,3171.4653949977687,0.28504563304647185,26.476655282852999,2729.3931542696628,1133.4424761681648,9.5995545206034229E-3,27.757713376936319,3.3282629948364892,3.8351944740676469,0.49876893665796107]
[34,7.7154034823872009E-2,1.6624685138539042,919.5649187084955,312.65207236088855,1360,2592.2169910693842,3489.6670483169223,302.2555795740783,635.85557957407843,855.99479949891565,66.72,789.27479949891563,2051.9995958964964,3192.8633821101962,0.2547757933592858,26.629591137863212,2748.2376203504582,1140.8637862136998,9.4637266126968295E-3,26.296235422944811,3.1530258300893061,3.7742248289847842,0.53601975109656397]
[36,7.3889666329042508E-2,1.6409036860879904,931.42532182184766,335.31311585586519,1440,2706.7384376777127,3650.2805149149563,293.46107139533683,627.06107139533674,845.64831928863146,66.72,778.92831928863143,2064.7575735056607,3212.584795609896,0.22406362859949355,26.773784243634854,2765.5514877048827,1147.8272221042355,9.3396680969859876E-3,24.944191068603629,2.9909102000723777,3.7232861704451103,0.57487272051767924]
[38,7.0912674874010206E-2,1.6216216216216219,942.29729729729729,358.07297297297305,1520,2820.3702702702703,3809.8473767885534,285.39705405405408,618.99705405405405,836.16124006359303,66.72,769.441240063593,2076.4496967567566,3230.8397005838087,0.19295830540540559,26.910329004176905,2781.5265485063483,1154.3900038270524,9.2259141494435617E-3,23.687955486486487,2.8402824324324327,3.6808735660337835,0.6154690536227857]
[40,6.8184469984248292E-2,1.6042780748663101,952.29946524064178,380.91978609625676,1600,2933.2192513368987,3968.4932368669397,277.97621390374337,611.57621390374334,827.43083988675698,66.72,760.71083988675696,2087.2042575401069,3249.0021168463318,0.16166780748663115,27.063310252926723,2797.1346858124953,1161.7978593062246,9.1212330921673496E-3,22.238097112299471,2.6664385026737976,3.6042780748663104,0.65796050517988802]
[42,6.5673341683303119E-2,1.5885947046843176,961.53219489268372,403.84352185492725,1680,3045.375716747611,4126.3243726442488,271.12460661131132,604.7246066113114,819.37012542507227,66.72,752.65012542507225,2097.1297388563371,3261.2891279448295,0.16199642174526097,27.108987634876271,2808.6590362813436,1164.1593890884924,9.0245818396291633E-3,21.689968528904906,2.6007156509478304,3.5885947046843176,0.70251144844065283]
[44,6.3352956126507917E-2,1.574344023323615,970.08098477486226,426.83563330093943,1760,3156.9166180758016,4283.4313153832964,264.77919533527694,598.3791953352769,811.90493568856118,66.72,745.18493568856115,2106.3184988921284,3272.6649481943095,0.16230075801749286,27.151290376716499,2819.3285411871948,1166.3464493021809,8.9350711713256734E-3,21.182335626822155,2.5398483965014576,3.574344023323615,0.74930111955271661]
[46,6.1201234958366428E-2,1.5613382899628254,978.01911842804009,449.88879447689851,1840,3267.9079129049387,4439.8916622411043,258.88591290493889,592.48591290493891,804.97166224110458,66.72,738.25166224110455,2114.8496616675516,3283.2273368384322,0.16258340945300068,27.190578926252087,2829.2349414920577,1168.3776751708804,8.8519383961763141E-3,20.71087303239511,2.4833181093998933,3.5613382899628254,0.7985261064230782]
[48,5.9199507914974393E-2,1.5494211932324133,985.40977062670777,472.99668990081977,1920,3378.4064605275275,4595.7723065029732,253.39812251665788,586.99812251665787,798.51543825489159,66.72,731.79543825489156,2122.7914068990085,3293.0605478074367,0.16284661282893739,27.227164195507292,2838.4572999275942,1170.2691409084284,8.7745256385478605E-3,20.271849801332632,2.4306774342125457,3.5494211932324133,0.85040315973975744]
[50,5.7331863285556783E-2,1.5384615384615385,992.30769230769226,496.15384615384619,2000,3488.4615384615386,4751.1312217194572,248.27538461538464,581.87538461538463,792.48868778280553,66.72,725.7686877828055,2130.2028,3302.2375847353851,0.16309230769230784,27.26131578151578,2847.0641187524661,1172.0347847353848,8.7022624434389146E-3,19.86203076923077,2.3815384615384616,3.5384615384615383,0.90517241379310354]
[52,5.558464384244434E-2,1.5283483976992605,998.76056935351323,519.35549606382699,2080,3598.11606541734,4906.018900490988,243.48246126116572,577.08246126116569,786.84995442490072,66.72,720.12995442490069,2137.1352665539266,3310.8220185959631,0.16332218411217445,27.293268603877241,2855.115046562978,1173.6867520420365,8.6346517317134382E-3,19.478596900893258,2.3355631775651391,3.5283483976992605,0.96310111966529655]
[54,5.3946051217337032E-2,1.5189873417721518,1004.8101265822784,542.59746835443036,2160,3707.4075949367088,5060.479523454952,238.98850632911393,572.5885063291139,781.56294862248694,66.72,714.84294862248692,2143.6337893670884,3318.8694638676452,0.16353772151898749,27.323228303424251,2862.6622643184278,1175.235674500557,8.571258376768429E-3,19.119080506329116,2.292455696202532,3.518987341772152,1.0244880140661972]
[56,5.2405832159698532E-2,1.5102974828375288,1010.4930309964634,565.87609735801971,2240,3816.3691283544831,5214.5519157111567,234.76640232993552,568.36640232993545,776.5957674469829,66.72,709.87576744698288,2149.7378871811943,3326.42878582294,0.16374022051175385,27.351375663418775,2869.751618811049,1176.6908986417459,8.511699849484208E-3,18.781312186394842,2.2519558976492617,3.5102974828375286,1.0896684748981205]
[58,5.0955027348013007E-2,1.5022091310751104,1015.8416356233213,589.18814866152638,2320,3925.0297842848477,5368.2703344527617,230.79221380923499,564.39221380923505,771.92025154027647,66.72,705.20025154027644,2155.4824201611364,3333.5430944119353,0.16393082907389775,27.377870253556779,2876.4235557067791,1178.0606742507987,8.455638507677176E-3,18.4633771047388,2.2138341852204797,3.5022091310751104,1.159020651482366]
[60,4.9585768506306242E-2,1.4946619217081851,1020.8845958312151,612.53075749872914,2400,4033.4153533299441,5521.6651215646398,227.04473411286224,560.64473411286224,767.5114518974849,66.72,700.79145189748488,2160.8982569191658,3340.2505675019538,0.16411056431113383,27.402853451532597,2882.7138923348184,1179.3523105827878,8.4027752026077322E-3,18.163578729028981,2.1778871377732592,3.4946619217081851,1.23297280606532]
[62,4.8291113197961241E-2,1.4876033057851239,1025.6473829201102,635.9013774104684,2480,4141.5487603305783,5674.7632474477396,223.50510743801655,557.10510743801649,763.3471852211959,66.72,696.62718522119587,2166.012830082645,3346.5851367121986,0.16428033057851252,27.426450962698233,2888.6544614523345,1180.5723066295536,8.3528439474963526E-3,17.880408595041324,2.1439338842975211,3.4876033057851239,1.3120121676805652]
[64,4.706490928073475E-2,1.4809873248832555,1030.1527144222273,659.29773723022561,2560,4249.450451652453,5827.5887666499448,220.15651198096029,553.75651198096023,759.40766115407087,66.72,692.68766115407084,2170.8506015527469,3352.577061881293,0.1644409346771723,27.448774932411943,2894.2736504427894,1181.7264603285462,8.3056074478905385E-3,17.612520958476825,2.1118130645655664,3.4809873248832552,1.3966956852359294]
[66,4.590168291439977E-2,1.47477360931436,1034.4209164567303,682.717804861442,2640,4357.1387213181724,5980.1632015507912,216.98389296656904,550.58389296656901,755.67516819596358,66.72,688.95516819596355,2175.433454134949,3358.2534147139477,0.16459309865867788,27.469925725841218,2899.5968552458089,1182.8199605789985,8.2608533356830164E-3,17.358711437325525,2.0813802682644513,3.4747736093143597,1.4876631817137069]
[68,4.4796545421244054E-2,1.4689265536723164,1038.4702303346371,706.15975662755341,2720,4464.6299869621907,6132.5058670143417,213.97373663624512,547.57373663624514,752.13380780734713,66.72,685.4138078073471,2179.7810227900914,3363.6384879311499,0.16473747066492844,27.489993434710044,2904.6468643496955,1183.8574651410588,8.2183909809034426E-3,17.11789893089961,2.0525058670143417,3.4689265536723166,1.5856535669208947]
[70,4.3745115351067891E-2,1.4634146341463414,1042.3170731707316,729.6219512195122,2800,4571.9390243902435,6284.6341463414637,211.11387804878049,544.71387804878043,748.76926829268302,66.72,682.049268292683,2183.9109760975607,3368.7541429782436,0.1648746341463416,27.509059158626474,2909.4441851055881,1184.8431668806829,8.1780487804878049E-3,16.88911024390244,2.0250731707317073,3.4634146341463414,1.6915249786647413]

{"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."]