{"text_format":"1","workbook":"xlsx","n_sheets":27,"sheets":["Cost_Input","Cost_Schematics","Centrifuge","Belt filter press","Plate and frame press","Thickener","SFBW EQ","SFBW Clarifier","O&M input","Total Costs","Cost sheet","Assumptions","MainMenu","Reuse_button","Reuse_text","Reuse_print","Reuse_info","Reuse_criteria","Reuse_score","Reuse_summary","Resid_print","Resid_info","Resid_button","Resid_text","Resid_criteria","Resid_score","Resid_summary"],"not_rendered":{"charts":9,"images":47,"macros":1,"external_links":0,"defined_names":7,"comments":14,"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":"Cost_Input","index":0,"n_rows":16,"n_cols":14,"rows_kept":16,"cut":false,"hidden":false,"merged":[[0,1,0,12],[1,1,1,4],[15,1,24,5],[3,1,3,5],[14,7,14,12],[3,7,3,12],[14,1,14,5]]}
[null,"Residual treatment costs"]
[null,"Treatment Costs"]
[]
[null,"Main WTP operating parameters",null,null,null,null,null,"Treatment options"]
[]
[null,null,null,null,null,null,null,null,null,null,true]
[null,"Total treatment flow",null,1,"mgd",null,null,null,null,"Dewatering:"]
[null,null,null,null,null,null,null,null,null,null,true]
[null,"Daily solids production",null,1000,"lb/day",null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,false,null,null,null,null,null,null,true,null,null,18221]
[null,null,null,null,null,null,null,null,null,null,true]
[]
[]
[null,"Instructions",null,null,null,null,null,"Schematic"]
[null,"Enter the treatment plant capacity and the daily solids production for your design condition in the blue cells above.  The daily solids production commonly used for the design of residuals treatment processes is the 90th percentile of the historical daily solids production.  If the treatment plant uses lime or soda softening, check the indicated box.  In the Treatment options block, check the boxes for the treatment processes included in your plant's residuals management plan.  The corresponding process schematic is seen in the Schematic block.  "]

{"sheet":"Cost_Schematics","index":1,"n_rows":10,"n_cols":11,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,true]
[null,null,null,null,null,null,null,null,null,null,false]

{"sheet":"Centrifuge","index":2,"n_rows":30,"n_cols":14,"rows_kept":30,"cut":false,"hidden":false,"merged":[[22,6,22,10],[0,1,0,13],[1,1,1,4],[17,1,17,11],[3,1,3,11],[12,2,12,4],[7,6,9,6],[7,7,9,7],[7,8,9,8],[7,9,9,9],[7,10,9,10],[23,10,25,10],[26,2,26,4],[23,6,25,6],[23,7,25,7],[23,8,25,8],[23,9,25,9]]}
[null,"Residual treatment costs"]
[null,"Treatment Costs - Dewatering"]
[]
[null,"Day tank"]
[]
[null,null,"Tank diameter",10,"ft",null,"Number of shifts per week",null,5]
[]
[null,null,"Tank height",15,"ft",null,"Required day tank storage volume","Number of tanks","Provided day tank volume with all units in service","Provided day tank volume with one unit out of service","Total capital cost"]
[]
[null,null,"Thickened density",63,"lb/ft3"]
[null,null,null,null,null,null,"(ft3/day)",null,"(ft3)","(ft3)"]
[null,null,null,false,null,null,{"$f":"Cost_Input!D9*(7/I6)*(100/D15)*(1/D10)","v":1111.1111111111111},{"$f":"ROUNDUP((G12/(((D8*3.14*D6^2)/4)+((PI()*(D6^2))/96))),0)+D12","v":1},{"$f":"H12*((D8*PI()*D6^2)/4+((PI()*(D6^2))/96))","v":1181.3697374436617},{"$f":"(H12-1)*((D8*PI()*D6^2)/4+((PI()*(D6^2))/96))","v":0},{"$f":"'Cost sheet'!K189","v":1832753.1529776766}]
[null,null,"Assumptions"]
[null,null,"Cone slope",0.25,"ft/ft"]
[null,null,"Thickened solids conc.",{"$f":"IF(Cost_Input!$D$11=TRUE, 20, 2)","v":2},"%"]
[]
[]
[null,"Centrifuge"]
[]
[null,null,"Desired # of dewatering units",null,2]
[]
[null,null,"Dewatering equipment runtime",null,8,"hr/shift"]
[null,null,null,null,null,null,"Centrifuge"]
[null,null,null,true,null,null,"Inflow solids rate","Inflow hydraulic rate","Hydraulic rate to active unit(s)",null,"Total capital cost"]
[null,null,null,false]
[null,null,null,true]
[null,null,"Assumptions",null,null,null,"(lb/hr)","(gpm)","(gpm)"]
[null,null,"Centrate solids conc.",0.05,"%",null,{"$f":"Cost_Input!D9*(7/$I$6)/$E$22","v":175},{"$f":"G28*(100/D15)/D10*7.48/60","v":17.314814814814817},{"$f":"N30","v":17.314814814814817},null,{"$f":"'Cost sheet'!K302","v":6580960.4868250191}]
[null,null,"Polymer dose",{"$f":"IF(Cost_Input!$D$11=TRUE, 0, 10)","v":10},"lb/dry ton",null,null,null,{"$f":"IF(D24=TRUE,I28*(E20+1),I28*E20)","v":51.94444444444445},null,null,null,null,{"$f":"IF(IF($D$24=TRUE,$G$28/($E$20-1),$G$28/$E$20)>Assumptions!E64,\"Overloaded\",IF($D$24=TRUE,$G$28/($E$20-1),$G$28/$E$20))","v":175}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(IF($D$24=TRUE,$H$28/($E$20-1),$H$28/$E$20)>Assumptions!$E$55,\"Overloaded\",IF($D$24=TRUE,$H$28/($E$20-1),$H$28/$E$20))","v":17.314814814814817}]

{"sheet":"Belt filter press","index":3,"n_rows":29,"n_cols":11,"rows_kept":29,"cut":false,"hidden":false,"merged":[[12,2,12,4],[17,1,17,11],[0,1,0,13],[1,1,1,4],[3,1,3,11],[7,6,9,6],[7,7,9,7],[7,8,9,8],[7,9,9,9],[7,10,9,10],[26,2,26,4],[22,6,22,10],[23,6,25,6],[23,7,25,7],[23,8,25,8],[23,9,25,9],[23,10,25,10]]}
[null,"Residual treatment costs"]
[null,"Treatment Costs - Dewatering"]
[]
[null,"Day tank"]
[]
[null,null,"Tank diameter",20,"ft",null,"Number of shifts per week",null,5]
[]
[null,null,"Tank height",20,"ft",null,"Required day tank storage volume","Number of tanks","Provided day tank volume with all units in service","Provided day tank volume with one unit out of service","Total capital cost"]
[]
[null,null,"Thickened density",60,"lb/ft3"]
[null,null,null,null,null,null,"(ft3/day)",null,"(ft3)","(ft3)"]
[null,null,null,false,null,null,{"$f":"Cost_Input!D9*(7/I6)*(100/D15)*(1/D10)","v":1166.6666666666667},{"$f":"ROUNDUP((G12/(((D8*3.14*D6^2)/4)+((PI()*(D6^2))/96))),0)+D12","v":1},{"$f":"H12*((D8*PI()*D6^2)/4+((PI()*(D6^2))/96))","v":6296.2752765695432},{"$f":"(H12-1)*((D8*PI()*D6^2)/4+((PI()*(D6^2))/96))","v":0},{"$f":"'Cost sheet'!K189","v":1832753.1529776766}]
[null,null,"Assumptions"]
[null,null,"Cone slope",0.25,"ft/ft"]
[null,null,"Thickened solids conc.",{"$f":"IF(Cost_Input!$D$11=TRUE, 20, 2)","v":2},"%"]
[]
[]
[null,"Belt Filter Press"]
[]
[null,null,"Desired # of dewatering units",null,3]
[]
[null,null,"Dewatering equipment runtime",null,8,"hr/shift"]
[null,null,null,null,null,null,"Belt Filter Press"]
[null,null,null,true,null,null,"Inflow solids rate","Inflow hydraulic rate","Hydraulic rate to active unit(s)",null,"Total capital cost"]
[null,null,null,false]
[null,null,null,true]
[null,null,"Assumptions",null,null,null,"(lb/hr)","(gpm)","(gpm)"]
[null,null,"Filtrate solids conc.",0.05,"%",null,{"$f":"Cost_Input!D9*(7/$I$6)/$E$22","v":175},{"$f":"G28*(100/D15)/D10*7.48/60","v":18.180555555555557},{"$f":"IF(IF($D$24=TRUE,$H$28/($E$20-1),$H$28/$E$20)>Assumptions!$V$63,\"Overloaded\",IF($D$24=TRUE,$H$28/($E$20-1),$H$28/$E$20))","v":9.0902777777777786},null,{"$f":"'Cost sheet'!K360","v":8626421.6092041079}]
[null,null,"Polymer dose",{"$f":"IF(Cost_Input!$D$11=TRUE, 0, 10)","v":10},"lb/dry ton"]

{"sheet":"Plate and frame press","index":4,"n_rows":29,"n_cols":11,"rows_kept":29,"cut":false,"hidden":false,"merged":[[23,9,25,9],[23,10,25,10],[26,2,26,4],[12,2,12,4],[17,1,17,11],[22,6,22,10],[23,6,25,6],[23,7,25,7],[23,8,25,8],[0,1,0,13],[1,1,1,4],[3,1,3,11],[7,6,9,6],[7,7,9,7],[7,8,9,8],[7,9,9,9],[7,10,9,10]]}
[null,"Residual treatment costs"]
[null,"Treatment Costs - Dewatering"]
[]
[null,"Day tank"]
[]
[null,null,"Tank diameter",20,"ft",null,"Number of shifts per week",null,5]
[]
[null,null,"Tank height",20,"ft",null,"Required day tank storage volume","Number of tanks","Provided day tank volume with all units in service","Provided day tank volume with one unit out of service","Total capital cost"]
[]
[null,null,"Thickened density",65,"lb/ft3"]
[null,null,null,null,null,null,"(ft3/day)",null,"(ft3)","(ft3)"]
[null,null,null,false,null,null,{"$f":"Cost_Input!D9*(7/I6)*(100/D15)*(1/D10)","v":1076.9230769230769},{"$f":"ROUNDUP((G12/(((D8*3.14*D6^2)/4)+((PI()*(D6^2))/96))),0)+D12","v":1},{"$f":"H12*((D8*PI()*D6^2)/4+((PI()*(D6^2))/96))","v":6296.2752765695432},{"$f":"(H12-1)*((D8*PI()*D6^2)/4+((PI()*(D6^2))/96))","v":0},{"$f":"'Cost sheet'!K189","v":1832753.1529776766}]
[null,null,"Assumptions"]
[null,null,"Cone slope",0.25,"ft/ft"]
[null,null,"Thickened solids conc.",{"$f":"IF(Cost_Input!$D$11=TRUE, 20, 2)","v":2},"%"]
[]
[]
[null,"Plate and Frame Press"]
[]
[null,null,"Desired # of dewatering units",null,2]
[]
[null,null,"Dewatering equipment runtime",null,8,"hr/shift"]
[null,null,null,null,null,null,"Plate and Frame Press"]
[null,null,null,true,null,null,"Inflow solids rate","Inflow hydraulic rate","Solids loading rate to active unit(s)",null,"Total capital cost"]
[null,null,null,false]
[null,null,null,true]
[null,null,"Assumptions",null,null,null,"(lb/hr)","(gpm)","(lb/hr)"]
[null,null,"Pressate solids conc.",0.05,"%",null,{"$f":"Cost_Input!D9*(7/$I$6)/$E$22","v":175},{"$f":"G28*(100/D15)/D10*7.48/60","v":16.782051282051285},{"$f":"IF(IF($D$24=TRUE,$G$28/($E$20-1),$G$28/$E$20)>Assumptions!$AD$64,\"Overloaded\",IF($D$24=TRUE,$G$28/($E$20-1),$G$28/$E$20))","v":175},null,{"$f":"'Cost sheet'!K418","v":7652491.5092041083}]
[null,null,"Polymer dose",{"$f":"IF(Cost_Input!$D$11=TRUE, 0, 10)","v":10},"lb/dry ton"]

{"sheet":"Thickener","index":5,"n_rows":21,"n_cols":15,"rows_kept":21,"cut":false,"hidden":false,"merged":[[11,14,13,14],[11,7,13,7],[0,1,0,13],[1,1,1,4],[3,1,3,15],[11,2,11,4],[11,6,13,6],[11,8,13,8],[11,9,13,9],[11,13,13,13],[11,11,13,11],[11,10,13,10],[11,12,13,12]]}
[null,"Residual treatment costs"]
[null,"Treatment Costs - Thickener"]
[]
[null,"Thickener"]
[]
[null,null,"Thickener diameter",40,"ft",null,"Number of main sed. basins",null,null,2,"basins"]
[null,null,null,null,null,null,"Sed. Basin blowdown frequency",null,null,2,"per hour"]
[null,null,null,null,null,null,"Blowdown duration",null,null,5,"min"]
[]
[null,null,null,false]
[null,null,null,false]
[null,null,"Assumptions",null,null,null,"","Inst.:Avg. Peaking Factor","Inst. loading rate from sed. Basins","Total inst. solid loading rate","Number of thickening units","Required thickening area","Provided area with all units active","Provided area with one unit out of service","Total capital cost"]
[null,null,"Thickener height",15,"ft"]
[null,null,"Hydraulic loading rate",0.1,"gpm/ft2"]
[null,null,"Solids loading rate",4,"lb/day-ft2",null,null,null,"(lb/day)","(lb/day)",null,"(ft2)","(ft2)","(ft2)"]
[null,null,"Influent solids concentration",0.3,"% dry/wet",null,null,{"$f":"IF(1/(J6*J7*J8/60)>1,1/(J6*J7*J8/60),1)","v":3},{"$f":"Cost_Input!D9*H16","v":3000},{"$f":"G16+I16","v":3000},{"$f":"ROUNDUP(L17/((PI()*D6^2)/4),0)+D10","v":1},{"$f":"IF(L17>L18, L17, L18)","v":832.44301994301998},{"$f":"K16*((PI()*D6^2)/4)","v":1256.6370614359173},{"$f":"(K16-1)*((PI()*D6^2)/4)","v":0},{"$f":"'Cost sheet'!K128","v":2705785.5288965753}]
[null,null,"Polymer Dose",{"$f":"IF(Cost_Input!$D$11=TRUE, 0, 2)","v":2},"lb/dry-ton",null,null,null,null,null,null,{"$f":"J16/D15","v":750}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"(J16*(100/D16)/62.4*7.48/24/60)/D14","v":832.44301994301998}]
[]
[]
[null,"· All blue fields must be entered (required)."]

{"sheet":"SFBW EQ","index":6,"n_rows":20,"n_cols":12,"rows_kept":20,"cut":false,"hidden":false,"merged":[[0,1,0,13],[1,1,1,4],[3,1,3,12],[11,2,11,4],[11,6,13,6],[11,7,13,7],[11,8,13,8],[11,9,13,9],[11,10,13,10],[11,11,13,11]]}
[null,"Residual treatment costs"]
[null,"Treatment Costs - SFBW EQ"]
[]
[null,"SFBW Equalization Basin"]
[]
[null,null,"EQ basin diameter",40,"ft",null,null,"Daily backwashes",null,2]
[]
[null,null,"EQ basin height",15,"ft",null,null,"Back wash volume",null,100000,"gal/wash"]
[]
[null,null,null,false]
[]
[null,null,"Assumptions",null,null,null,"SFBW inflow","Required SFBW equalization volume","# of EQ basins","Total provided equalization volume","Provided equalization volume with one unit out of service","Total capital cost"]
[null,null,"Backwash frequency",30,"min"]
[null,null,"BW fraction of trt. volume",6,"%"]
[null,null,null,null,null,null,"(gpd)","(gpd)",null,"(gal)","(ft3)"]
[null,null,null,null,null,null,{"$f":"J8*J6","v":200000},{"$f":"IF(D14=0,0,IF((G16-(J6*D13)*(Cost_Input!D7*1000000/24/60)*(D14/100))>0,(G16-(J6*D13)*(Cost_Input!D7*1000000/24/60)*(D14/100)),0))","v":197500},{"$f":"ROUNDUP((H16/7.48)/(D8*(PI()/4*D6^2)),0)+D10","v":2},{"$f":"I16*(D8*PI()/4*(D6^2))*7.48","v":281989.35658621986},{"$f":"IF(I16=0,0,IF(I16>0,(I16-1)*(D8*PI()/4*(D6^2))*7.48,\"N/A\"))","v":140994.67829310993},{"$f":"IF(I16=0,0,'Cost sheet'!K478)","v":1749341.529580886}]
[]
[]
[]
[null,"· All blue fields must be entered (required)."]

{"sheet":"SFBW Clarifier","index":7,"n_rows":19,"n_cols":12,"rows_kept":19,"cut":false,"hidden":false,"merged":[[0,1,0,13],[1,1,1,4],[3,1,3,12],[9,2,9,4],[8,11,10,11],[8,6,10,6],[8,7,10,7],[8,9,10,9],[8,8,10,8],[8,10,10,10]]}
[null,"Residual treatment costs"]
[null,"Treatment Costs - SFBW Clarifier"]
[]
[null,"SFBW Clarification"]
[]
[null,null,"Clarifier diameter",8,"ft"]
[]
[null,null,null,false]
[null,null,null,null,null,null,"Clarifier inflow","Required settling area ","Number of clarifiers","Area of all clarifiers","Area of all minus 1 unit","Total capital cost"]
[null,null,"Assumptions"]
[null,null,"Clarifier height",15,"ft"]
[null,null,"Clarifier overflow rate",1,"gpm/sf",null,"(gpm)","(ft2)",null,"(ft2)","(ft2)"]
[null,null,"Polymer dose",0.2,"mg/L",null,{"$f":"Cost_Input!D7*('SFBW EQ'!D14/100)*1000000/1440","v":41.666666666666664},{"$f":"G13/D12","v":41.666666666666664},{"$f":"ROUNDUP(H13/((PI()*D6^2)/4),0)+D8","v":1},{"$f":"((PI()*D6^2)/4)*I13","v":50.26548245743669},{"$f":"((PI()*D6^2)/4)*(I13-1)","v":0},{"$f":"'Cost sheet'!K540","v":606738.2422331241}]
[]
[]
[]
[]
[]
[null,"· All blue fields must be entered (required)."]

{"sheet":"O&M input","index":8,"n_rows":27,"n_cols":12,"rows_kept":27,"cut":false,"hidden":false,"merged":[[0,1,0,13],[1,1,1,4],[3,1,3,12],[13,11,15,11],[13,6,15,6],[13,7,15,7],[13,8,15,8],[13,9,15,9],[13,10,15,10],[13,2,13,4]]}
[null,"Residual treatment costs"]
[null,"Treatment Costs - O&M"]
[]
[null,"O&M Input"]
[]
[null,null,"Labor Requirements for Residuals Management:",null,null,null,"Power:"]
[null,null,"Operator",1,"FTE",null,"Average power costs",null,0.1225,"$/kWh"]
[]
[null,null,"Supervisor",1,"FTE",null,"Disposal:"]
[null,null,null,null,null,null,"Average transport distance",null,50,"mile"]
[null,null,"Maintenance worker",0,"FTE"]
[null,null,null,null,null,null,"Maintenance budget",null,3,"% of capital costs"]
[]
[null,null,"Assumptions",null,null,null,"Labor cost","Disposal cost","Power cost","Polymer cost","Maintenance","Total cost"]
[null,null,"Labor salaries:"]
[null,null,"Operator",40000,"$/yr"]
[null,null,"Supervisor",55000,"$/yr",null,"($/year)","($/year)","($/year)","($/year)","($/year)","($/year)"]
[null,null,"Maintenance worker",50000,"$/yr",null,{"$f":"((D7*D16)+(D9*D17)+(D11*D18))*D19","v":161500},{"$f":"(I10*D20+D21)*(Cost_Input!D9/2000)/('O&M input'!D22/100)*365","v":42695.875},{"$f":"'Cost sheet'!F561","v":39929.416254000003},{"$f":"(3*Cost_Input!D9/2000+8*Cost_Input!D9/2000)*D23*365","v":4095.3},{"$f":"(I12/100*'Total Costs'!D10)","v":351787.12232797185},{"$f":"SUM(G18:K18)","v":600007.71358197182}]
[null,null,"Multiplier for Burdened Wages",1.7]
[null,null,"Trucking cost",0.25,"$/(mile-ton)"]
[null,null,"Average tipping fee",34.29,"$/truck"]
[null,null,"Dewatered cake concentration",{"$f":"IF(Cost_Input!D11,50,20)","v":20},"percent solids"]
[null,null,"Polymer cost",2.04,"$/lb"]
[]
[]
[]
[null,"· All blue fields must be entered (required)."]

{"sheet":"Total Costs","index":9,"n_rows":23,"n_cols":8,"rows_kept":23,"cut":false,"hidden":false,"merged":[[19,1,19,5],[3,1,3,5],[16,7,16,12],[0,1,0,12],[1,1,1,4]]}
[null,"Residual treatment costs"]
[null,"Treatment Costs"]
[]
[null,"Total Costs"]
[null,null,null,"Capital Costs"]
[null,null,"Dewatering",{"$f":"Centrifuge!$K$12+Centrifuge!$K$28","v":8413713.6398026962}]
[null,null,"Thickening",{"$f":"Thickener!$O$16","v":2705785.5288965753}]
[null,null,"SFBW Equalization",0]
[null,null,"SFBW Clarification",{"$f":"'SFBW Clarifier'!$L$13","v":606738.2422331241}]
[null,null,"Total Capital Costs",{"$f":"SUM(D6:D9)","v":11726237.410932396}]
[]
[null,null,"Period for Annualized Costs",20,"yrs"]
[null,null,"Interest Rate",5,"%"]
[]
[null,null,"Annualized Capital Costs",{"$f":"(D13/100)*(1+D13/100)^D12/((1+D13/100)^D12-1)*D10","v":940943.62786548911}]
[null,null,"O&M Costs",{"$f":"'O&M input'!L18","v":600007.71358197182}]
[null,null,"Total Annual Costs",{"$f":"SUM(D15:D16)","v":1540951.3414474609},null,null,null,"Schematic"]
[]
[]
[null,"Associated Carbon Emissions"]
[null,null,"Power Consumption",{"$f":"('Cost sheet'!F561/'Cost sheet'!D545)*0.000718","v":234.03527241120003},"metric tons CO2/year"]
[null,null,"Transportation",{"$f":"('Cost sheet'!D564*'Cost sheet'!D565)*365*Assumptions!C156","v":13.814853475605043},"metric tons CO2/year"]
[null,null,"Total Annual Carbon Emissions",{"$f":"SUM(D21:D22)","v":247.85012588680507},"metric tons CO2/year"]

{"sheet":"Cost sheet","index":10,"n_rows":600,"n_cols":12,"rows_kept":600,"cut":false,"hidden":false,"merged":[[169,1,171,1],[169,2,171,2],[169,3,171,3],[169,4,171,4]]}
[null,"Cost Breakdown"]
[]
[null,"Color Legend "]
[null,null,"Input cell - values are hand-entered"]
[null,null,"Value calculated on this worksheet"]
[null,null,"Value copied from another cell on this worksheet"]
[null,null,"Value copied or calculated from \"Assumptions\" tab - reference number in Column A refers to row number of data location on \"Assumptions\" worksheet"]
[null,null,null,{"$f":"'SFBW EQ'!$L$16","v":1749341.529580886}]
[null,"Construction Costs"]
[null,null,null,"TOTAL"]
[null,"COMPONENT NO.","DESCRIPTION","COST"]
[]
[null," "]
[null,1,"Thickener",{"$f":"K126","v":2081373.4837665963}]
[null,2,"Day Tank",{"$f":"K187","v":1409810.1176751358}]
[null,3,"Dewatering",{"$f":"K300","v":5062277.2975577069}]
[null,4,"SFBW EQ",{"$f":"K476","v":1345647.3304468354}]
[null,5,"SFBW Clarifier",{"$f":"K538","v":466721.72479471081}]
[null,"Total",null,{"$f":"SUM(D14:D18)","v":10365829.954240985}]
[]
[null,"Project Costs"]
[null,null,null,"TOTAL"]
[null,"COMPONENT NO.","DESCRIPTION","COST"]
[]
[null," "]
[null,1,"Thickener",{"$f":"K127","v":624412.04512997903}]
[null,2,"Day Tank",{"$f":"K188","v":422943.03530254081}]
[null,3,"Dewatering",{"$f":"K301","v":1518683.1892673124}]
[null,4,"SFBW EQ",{"$f":"K477","v":403694.19913405069}]
[null,5,"SFBW Clarifier",{"$f":"K539","v":140016.51743841326}]
[null,"Total",null,{"$f":"SUM(D26:D30)","v":3109748.9862722964}]
[]
[null,"Total Capital Costs"]
[null,null,null,"TOTAL"]
[null,"COMPONENT NO.","DESCRIPTION","COST"]
[]
[null," "]
[null,1,"Thickener",{"$f":"K128","v":2705785.5288965753}]
[null,2,"Day Tank",{"$f":"K189","v":1832753.1529776766}]
[null,3,"Dewatering",{"$f":"K302","v":6580960.4868250191}]
[null,4,"SFBW EQ",{"$f":"K478","v":1749341.529580886}]
[null,5,"SFBW Clarifier",{"$f":"K540","v":606738.2422331241}]
[null,"Total",null,{"$f":"SUM(D38:D42)","v":13475578.940513281}]
[]
[null,"Annual O&M Costs"]
[null,null,null,"TOTAL"]
[null,"COMPONENT NO.","DESCRIPTION","COST"]
[]
[null," "]
[null,1,"Power",{"$f":"F561","v":39929.416254000003}]
[null,2,"Cake Disposal",{"$f":"D569","v":42695.875}]
[null,3,"Chemical Use",{"$f":"D578","v":6021.1601358054631}]
[null,4,"Labor",{"$f":"D589","v":161500}]
[null,5,"Maintenance/Replacement",{"$f":"D600","v":71587.2664450171}]
[null,"Total",null,{"$f":"SUM(D50:D54)","v":321733.7178348226}]
[]
[null,"Specific Assumptions"]
[null,"Thickener","Thickener diameter ",{"$f":"Thickener!D6","v":40},"ft"]
[null,null,"# of thickeners",{"$f":"Thickener!K16","v":1}]
[null,null,"Thickener side wall depth",{"$f":"Thickener!D13","v":15},"ft"]
[]
[null,null,"Clarifier Blowdown Pumping Capacity",{"$f":"Cost_Input!D9*0.012+24.292","v":36.292000000000002},"gpm"]
[null,null,"Thickened Solids Pumping Capacity",{"$f":"Cost_Input!D9*0.008","v":8},"gpm"]
[null,null,"Thickener Overflow Pumping Capacity",{"$f":"Cost_Input!D9*0.0219+22.575","v":44.474999999999994},"gpm"]
[null,null,"# of Clarifier Blowdown Pumps",2]
[null,null,"# of Thickened Solids Pumps",2]
[null,null,"# of Thickener Overflow Pumps",2]
[null,null,"Clarifier Blowdown Capacity per Pump",{"$f":"D62/(D65-1)","v":36.292000000000002},"gpm"]
[null,null,"Thickened Solids Capacity per Pump",{"$f":"D63/(D66-1)","v":8},"gpm"]
[null,null,"Thickener Overflow Capacity per Pump",{"$f":"D64/(D67-1)","v":44.474999999999994},"gpm"]
[]
[null,"Common Assumptions"]
[null,"Thickener",{"$f":"Assumptions!C103","v":"Site Work"},{"$f":"Assumptions!D103","v":0.08}]
[null,null,{"$f":"Assumptions!C104","v":"Yard Piping"},{"$f":"Assumptions!D104","v":0.21}]
[null,null,{"$f":"Assumptions!C105","v":"Final Grading"},{"$f":"Assumptions!D105","v":0.01}]
[]
[null,null,{"$f":"Assumptions!C5","v":"basin side wall and bottom thickness"},{"$f":"Assumptions!D5","v":1},{"$f":"Assumptions!E5","v":"ft"}]
[null,null,{"$f":"Assumptions!C6","v":"cone slope"},{"$f":"Assumptions!D6","v":0.25},{"$f":"Assumptions!E6","v":"ft/ft"}]
[null,null,{"$f":"Assumptions!C7","v":"% of side wall depth under ground"},{"$f":"Assumptions!D7","v":0.5}]
[null,null,{"$f":"Assumptions!C8","v":"Excavation extended past perimeter"},{"$f":"Assumptions!D8","v":5},{"$f":"Assumptions!E8","v":"ft"}]
[null,null,{"$f":"Assumptions!C9","v":"Excavation extended past bottom depth"},{"$f":"Assumptions!D9","v":5},{"$f":"Assumptions!E9","v":"ft"}]
[null,null,{"$f":"Assumptions!$C$16","v":"Concrete"},{"$f":"Assumptions!$E$16","v":650},{"$f":"Assumptions!$D$16","v":"CY"}]
[null,null,{"$f":"Assumptions!$C$17","v":"Excavation"},{"$f":"Assumptions!$E$17","v":30},{"$f":"Assumptions!$D$17","v":"CY"}]
[null,null,{"$f":"Assumptions!C19","v":"Mechanical Sludge Collector"},{"$f":"Assumptions!E19","v":966.39},{"$f":"Assumptions!F19","v":"per LF plus"},{"$f":"Assumptions!G19","v":17595}]
[null,null,"Clarifier Blowdown Pumping Cost",{"$f":"VLOOKUP(D68,Assumptions!$D$26:$I$39,3,TRUE)","v":5826},"EA"]
[null,null,"Thickened Solids Pumping Cost",{"$f":"VLOOKUP(D69,Assumptions!$D$42:$I$43,3,TRUE)","v":9900},"EA"]
[null,null,"Thickener Overflow Pumping Cost",{"$f":"VLOOKUP(D70,Assumptions!$D$26:$I$39,3,TRUE)","v":5826},"EA"]
[null,null,"Clarifier Blowdown Pumping Space",{"$f":"VLOOKUP(D68,Assumptions!$D$26:$I$39,4,TRUE)","v":85},"ft2"]
[null,null,"Thickened Solids Pumping Space",{"$f":"VLOOKUP(D69,Assumptions!$D$42:$I$43,4,TRUE)","v":300},"ft2"]
[null,null,"Thickener Overflow Pumping Space",{"$f":"VLOOKUP(D70,Assumptions!$D$26:$I$39,4,TRUE)","v":85},"ft2"]
[null,null,"Additional Pump Station Space",{"$f":"SUM(VLOOKUP(D68,Assumptions!$D$26:$I$39,5,TRUE),VLOOKUP(D69,Assumptions!$D$26:$I$39,5,TRUE),VLOOKUP(D70,Assumptions!$D$26:$I$39,5,TRUE))","v":750},"ft2"]
[null,null,{"$f":"Assumptions!C21","v":"Pump Station/Building "},{"$f":"Assumptions!E21","v":250},{"$f":"Assumptions!D21","v":"SF"}]
[null,null,"Polymer System Size",{"$f":"Thickener!D17*Thickener!J16/2000/24","v":0.125},"lb/hr"]
[null,null,"Polymer System Cost",{"$f":"((D93/3.583)^0.6)*168349","v":22480.629281475874},"LS"]
[]
[null,null,{"$f":"Assumptions!C95","v":"Piping"},{"$f":"Assumptions!D95","v":0.1}]
[null,null,{"$f":"Assumptions!C93","v":"Electrical"},{"$f":"Assumptions!D93","v":0.15}]
[null,null,{"$f":"Assumptions!$C$94","v":"Instrumentation and Controls"},{"$f":"Assumptions!$D$94","v":0.15}]
[null,null,{"$f":"Assumptions!C92","v":"Labor/Installation"},{"$f":"Assumptions!D92","v":0.3},{"$f":"Assumptions!E92","v":"equipment/item cost"}]
[]
[null,null,{"$f":"Assumptions!$C$109","v":"Construction Contingency Costs "},{"$f":"Assumptions!$G$109","v":0.25}]
[null,null,{"$f":"Assumptions!$C$110","v":"Non-Construction Costs "},{"$f":"Assumptions!$G$110","v":0.30000000000000004}]
[null,null,{"$f":"Assumptions!$C$111","v":"Indirect Construction Costs"},{"$f":"Assumptions!$G$111","v":0.3}]
[]
[]
[null,"Thickener Quantity and Cost Calcualtions"]
[null,null,null,null,null,"MATERIAL","TOTAL ","LABOR","TOTAL","TOTAL","TOTAL"]
[null,"ITEM NO.","DESCRIPTION","UNIT ","QUANTITY","COST","MATERIAL","COST","LABOR","UNIT","COST"]
[null,null,null,null,null,"UNIT","COST","UNIT","COST","COST"]
[null," "]
[null,1,"General","LS",null,null,null,null,null,null,{"$f":"(D73+D74+D75)*SUM(K112:K120)","v":227368.97410285988}]
[null,{"$f":"B111+1","v":2},"Excavation","CY",{"$f":"$D$59*(PI()*($D$58/2+$D$80)^2*$D$60*$D$79+1/3*PI()*($D$58/2+$D$80)^2*($D$78*($D$58/2)+$D$81))/27","v":787.82223180299582},{"$f":"D83","v":30},{"$f":"E112*F112","v":23634.666954089873},{"$f":"F112*$D$99","v":9},{"$f":"E112*H112","v":7090.4000862269622},{"$f":"H112+F112","v":39},{"$f":"E112*J112","v":30725.067040316837}]
[null,{"$f":"B112+1","v":3},"Concerete","CY",{"$f":"$D$59*((PI()/4*($D$58+2*$D$77)^2-PI()/4*($D$58)^2)*$D$60+PI()*($D$58/2)*SQRT(($D$58/2)^2+($D$58/2*$D$78)^2)*$D$77)/27","v":119.53301171478668},{"$f":"D82","v":650},{"$f":"E113*F113","v":77696.45761461134},{"$f":"F113*$D$99","v":195},{"$f":"E113*H113","v":23308.937284383403},{"$f":"H113+F113","v":845},101005.39489899475]
[null,{"$f":"B113+1","v":4},"Mechanical Sludge Collector","EA",{"$f":"D59","v":1},null,null,null,null,{"$f":"D84*D58+F84","v":56250.6},56250.6]
[null,{"$f":"B114+1","v":5},"Pumps (Clarifier Blowdown to Thickeners)","EA",{"$f":"D65","v":2},{"$f":"D85","v":5826},{"$f":"E115*F115","v":11652},{"$f":"F115*$D$99","v":1747.8},{"$f":"E115*H115","v":3495.6},{"$f":"H115+F115","v":7573.8},15147.6]
[null,{"$f":"B115+1","v":6},"Pumps (Thickened Solids to Day Tanks)","EA",{"$f":"D66","v":2},{"$f":"D86","v":9900},{"$f":"E116*F116","v":19800},{"$f":"F116*$D$99","v":2970},{"$f":"E116*H116","v":5940},{"$f":"H116+F116","v":12870},25740]
[null,{"$f":"B116+1","v":7},"Pumps (Thickener Overflow to Recycle)","EA",{"$f":"D67","v":2},{"$f":"D87","v":5826},{"$f":"E117*F117","v":11652},{"$f":"F117*$D$99","v":1747.8},{"$f":"E117*H117","v":3495.6},{"$f":"H117+F117","v":7573.8},15147.6]
[null,8,"Polymer Feed System","LS",1,null,null,null,null,{"$f":"IF(ISERROR(D94),0,D94)","v":22480.629281475874},22480.629281475874]
[null,9,"Pump Station/Building","SF",{"$f":"E115*D88+E116*D89+E117*D90+D91","v":1690},null,null,null,null,{"$f":"D92","v":250},422500]
[null,10,"Piping","LS",null,null,null,null,null,null,{"$f":"SUM(K112:K119)*D96","v":68899.689122078751}]
[null,11,"Electrical","LS",null,null,null,null,null,null,{"$f":"SUM(K111:K120)*D97","v":147789.83316685888}]
[null,12,"Instrumentation & Controls","LS",null,null,null,null,null,null,{"$f":"D98*SUM(K111:K120)","v":147789.83316685888}]
[null,{"$f":"B122+1","v":13},"Construction Contingency","LS",null,null,null,null,null,null,{"$f":"D101*SUM(K111:K122)","v":320211.30519486096}]
[null,null,"Direct Construction Costs",null,null,null,null,null,null,null,{"$f":"SUM(K111:K123)","v":1601056.5259743049}]
[null,null,"Indirect Construction Costs",null,null,null,null,null,null,null,{"$f":"K124*D103","v":480316.95779229142}]
[null,null,"Construction Costs",null,null,null,null,null,null,null,{"$f":"K125+K124","v":2081373.4837665963}]
[null,null,"Non-Construction Costs",null,null,null,null,null,null,null,{"$f":"K126*D102","v":624412.04512997903}]
[null,null,"Total Capital Costs",null,null,null,null,null,null,null,{"$f":"K126+K127","v":2705785.5288965753}]
[]
[null,"DAY TANK"]
[null,"Specific Assumptions"]
[null,null,"Day Tank Diameter",{"$f":"'Belt filter press'!D6","v":20},"ft"]
[null,null,"# of Day Tanks",{"$f":"'Belt filter press'!H12","v":1}]
[null,null,"Day Tank Side Wall Depth",{"$f":"'Belt filter press'!D8","v":20},"ft"]
[]
[null,null,"Thickened Solids Pumping Capacity",{"$f":"0.0005*'Belt filter press'!G12+69.826","v":70.409333333333322},"gpm"]
[null,null,"# of Thickened Solids Pumps",{"$f":"D309","v":2}]
[null,null,"Thickened Solids Capacity per Pump",{"$f":"D136/(D137)","v":35.204666666666661}]
[]
[null,"Common Assumptions"]
[null,null,{"$f":"Assumptions!$C$103","v":"Site Work"},{"$f":"Assumptions!$D$103","v":0.08}]
[null,null,{"$f":"Assumptions!$C$104","v":"Yard Piping"},{"$f":"Assumptions!$D$104","v":0.21}]
[null,null,{"$f":"Assumptions!$C$105","v":"Final Grading"},{"$f":"Assumptions!$D$105","v":0.01}]
[]
[null,null,{"$f":"Assumptions!C5","v":"basin side wall and bottom thickness"},{"$f":"Assumptions!D5","v":1},{"$f":"Assumptions!E5","v":"ft"}]
[null,null,{"$f":"Assumptions!C6","v":"cone slope"},{"$f":"Assumptions!D6","v":0.25},{"$f":"Assumptions!E6","v":"ft/ft"}]
[null,null,{"$f":"Assumptions!C7","v":"% of side wall depth under ground"},{"$f":"Assumptions!D7","v":0.5}]
[null,null,{"$f":"Assumptions!C8","v":"Excavation extended past perimeter"},{"$f":"Assumptions!D8","v":5},{"$f":"Assumptions!E8","v":"ft"}]
[null,null,{"$f":"Assumptions!C9","v":"Excavation extended past bottom depth"},{"$f":"Assumptions!D9","v":5},{"$f":"Assumptions!E9","v":"ft"}]
[]
[null,null,{"$f":"Assumptions!$C$16","v":"Concrete"},{"$f":"Assumptions!$E$16","v":650},{"$f":"Assumptions!$D$16","v":"CY"}]
[null,null,{"$f":"Assumptions!$C$17","v":"Excavation"},{"$f":"Assumptions!$E$17","v":30},{"$f":"Assumptions!$D$17","v":"CY"}]
[null,null,"Thickened Solids Pumping Cost",{"$f":"VLOOKUP(D138,Assumptions!$D$42:$I$43,3,TRUE)","v":9900},"EA"]
[null,null,"Thickened Solids Pumping Space",{"$f":"VLOOKUP(D138,Assumptions!$D$42:$I$43,4,TRUE)","v":300},"SF"]
[null,null,"Additional Pump Station Space",{"$f":"VLOOKUP(D138,Assumptions!$D$42:$I$43,5,TRUE)","v":500},"SF"]
[null,null,{"$f":"Assumptions!C21","v":"Pump Station/Building "},{"$f":"Assumptions!E21","v":250},{"$f":"Assumptions!D21","v":"SF"}]
[null,null,"Mixer Cost",{"$f":"Assumptions!E18","v":1103.3},"per LF"]
[null,null,"Aluminum Cover Cost",{"$f":"Assumptions!E20","v":2714.3},{"$f":"Assumptions!F20","v":"per LF minus"},{"$f":"Assumptions!G20","v":20143}]
[]
[null,null,{"$f":"Assumptions!$C$95","v":"Piping"},{"$f":"Assumptions!$D$95","v":0.1}]
[null,null,{"$f":"Assumptions!$C$93","v":"Electrical"},{"$f":"Assumptions!$D$93","v":0.15}]
[null,null,{"$f":"Assumptions!$C$94","v":"Instrumentation and Controls"},{"$f":"Assumptions!$D$94","v":0.15}]
[null,null,{"$f":"Assumptions!$C$92","v":"Labor/Installation"},{"$f":"Assumptions!$D$92","v":0.3},{"$f":"Assumptions!$E$92","v":"equipment/item cost"}]
[]
[null,null,{"$f":"Assumptions!$C$109","v":"Construction Contingency Costs "},{"$f":"Assumptions!$G$109","v":0.25}]
[null,null,{"$f":"Assumptions!$C$110","v":"Non-Construction Costs "},{"$f":"Assumptions!$G$110","v":0.30000000000000004}]
[null,null,{"$f":"Assumptions!$C$111","v":"Indirect Construction Costs"},{"$f":"Assumptions!$G$111","v":0.3}]
[]
[null,"Day Tank Quantity and Cost Calcualtions"]
[null,"ITEM NO.","DESCRIPTION","UNIT ","QUANTITY","MATERIAL","TOTAL ","LABOR","TOTAL","TOTAL","TOTAL"]
[null,null,null,null,null,"COST","MATERIAL","COST","LABOR","UNIT","COST"]
[null,null,null,null,null,"UNIT","COST","UNIT","COST","COST"]
[null," "]
[null,1,"General","LS",null,null,null,null,null,null,{"$f":"(D141+D142+D143)*SUM(K175:K181)","v":154007.47757944136}]
[null,{"$f":"B174+1","v":2},"Excavation","CY",{"$f":"$D$133*(PI()*($D$132/2+$D$148)^2*$D$134*$D$147+1/3*PI()*($D$132/2+$D$148)^2*($D$146*($D$132/2)+$D$149))/27","v":327.24923474893671},{"$f":"D152","v":30},{"$f":"E175*F175","v":9817.477042468101},{"$f":"F175*$D$163","v":9},{"$f":"H175*E175","v":2945.2431127404307},{"$f":"F175+H175","v":39},{"$f":"J175*E175","v":12762.720155208532}]
[null,3,"Concerete","CY",{"$f":"$D$133*((PI()/4*($D$132+2*$D$145)^2-PI()/4*($D$132)^2)*$D$134+PI()*($D$132/2)*SQRT(($D$132/2)^2+($D$132/2*$D$146)^2)*$D$145)/27","v":60.862847151596036},{"$f":"D151","v":650},{"$f":"E176*F176","v":39560.850648537424},{"$f":"F176*$D$163","v":195},{"$f":"H176*E176","v":11868.255194561227},{"$f":"F176+H176","v":845},51429.105843098652]
[null,4,"Aluminum Covers","EA",{"$f":"D133","v":1},{"$f":"D158*D132-F158","v":34143},{"$f":"E177*F177","v":34143},{"$f":"F177*$D$163","v":10242.9},{"$f":"H177*E177","v":10242.9},{"$f":"F177+H177","v":44385.9},44385.9]
[null,5,"Pumps to Centrifuge","EA",{"$f":"D137","v":2},{"$f":"D153","v":9900},{"$f":"E178*F178","v":19800},{"$f":"F178*$D$163","v":2970},{"$f":"H178*E178","v":5940},{"$f":"F178+H178","v":12870},25740]
[null,6,"Pump Station/Building","SF",{"$f":"D154*E178+D155","v":1100},null,null,null,null,{"$f":"D156","v":250},275000]
[null,7,"Mixers","EA",2,{"$f":"D157*D132:D132","v":22066},{"$f":"E180*F180","v":44132},{"$f":"F180*$D$163","v":6619.8},{"$f":"H180*E180","v":13239.6},{"$f":"F180+H180","v":28685.8},57371.6]
[null,8,"Piping","LS",null,null,null,null,null,null,{"$f":"D160*SUM(K175:K180)","v":46668.932599830718}]
[null,9,"Electrical","LS",null,null,null,null,null,null,{"$f":"D161*SUM(K174:K181)","v":100104.86042663686}]
[null,10,"Instrumentaion & Controls","LS",null,null,null,null,null,null,{"$f":"D162*SUM(K174:K181)","v":100104.86042663686}]
[null,11,"Construction Contingency","LS",null,null,null,null,null,null,{"$f":"D165*SUM(K174:K183)","v":216893.86425771323}]
[null,null,"Direct Construction Costs",null,null,null,null,null,null,null,{"$f":"SUM(K174:K184)","v":1084469.3212885661}]
[null,null,"Indirect Construction Costs",null,null,null,null,null,null,null,{"$f":"D167*K185","v":325340.7963865698}]
[null,null,"Construction Costs",null,null,null,null,null,null,null,{"$f":"K186+K185","v":1409810.1176751358}]
[null,null,"Non-Construction Costs",null,null,null,null,null,null,null,{"$f":"D166*K187","v":422943.03530254081}]
[null,null,"Total Capital Costs",null,null,null,null,null,null,null,{"$f":"K187+K188","v":1832753.1529776766}]
[]
[]
[]
[null,"Centrifuge"]
[null,"Lime Softening"]
[null,"Specific Assumptions","Total centrifuge capacity",{"$f":"Centrifuge!G28","v":175},"lb/hr"]
[null,null,"# of Centrifuges",{"$f":"Centrifuge!E20","v":2}]
[null,null,"Loading per Centrifuge",{"$f":"Centrifuge!I28","v":17.314814814814817},"gpm"]
[]
[null,null,"Centrate Pumping Capacity",{"$f":"Cost_Input!$D$9*0.007","v":7},"gpm"]
[null,null,"# of Centrate Pumps",2,"gpm"]
[null,null,"Centrate Pump Capacity per Pump",{"$f":"D199/(D200)","v":3.5},"gpm"]
[]
[null,"Common Assumptions"]
[null,null,{"$f":"Assumptions!$C$103","v":"Site Work"},{"$f":"Assumptions!$D$103","v":0.08}]
[null,null,{"$f":"Assumptions!$C$104","v":"Yard Piping"},{"$f":"Assumptions!$D$104","v":0.21}]
[null,null,{"$f":"Assumptions!$C$105","v":"Final Grading"},{"$f":"Assumptions!$D$105","v":0.01}]
[]
[null,null,"Centrifuge Cost",{"$f":"VLOOKUP(D197,Assumptions!$D$59:$I$64,3,TRUE)","v":220000},"EA"]
[null,null,"Centrifuge Space",{"$f":"VLOOKUP(D197,Assumptions!$D$59:$I$64,4,TRUE)","v":500},"SF/centrifuge"]
[null,null,"Control/Electrical Room",1000,"SF"]
[null,null,"Classifier Area",{"$f":"Assumptions!F15","v":0},"SF/centrifuge"]
[null,null,"Truck Loading Area",{"$f":"Assumptions!M24*Assumptions!F16","v":0},"SF"]
[null,null,"Centrate Pumping Cost",{"$f":"VLOOKUP(D201,Assumptions!$D$26:$I$39,3,TRUE)","v":5826},"EA"]
[null,null,"Centrate Pumping Space",{"$f":"VLOOKUP(D201,Assumptions!$D$26:$I$39,4,TRUE)","v":85},"SF/pump"]
[null,null,"Additional Pump Station Space",{"$f":"VLOOKUP(D201,Assumptions!$D$26:$I$39,5,TRUE)","v":250},"SF"]
[null,null,{"$f":"Assumptions!C23","v":"Dewatering Building"},{"$f":"Assumptions!E23","v":350},{"$f":"Assumptions!D23","v":"SF"}]
[]
[null,null,{"$f":"Assumptions!C40","v":0},{"$f":"Assumptions!$D$95","v":0.1}]
[null,null,{"$f":"Assumptions!C38","v":"Goulds 3180 14x16-22XL"},{"$f":"Assumptions!$D$93","v":0.15}]
[null,null,{"$f":"Assumptions!$C$94","v":"Instrumentation and Controls"},{"$f":"Assumptions!$D$94","v":0.15}]
[null,null,{"$f":"Assumptions!C37","v":"Goulds 3180 12x14-19XL"},{"$f":"Assumptions!$D$92","v":0.3},{"$f":"Assumptions!E37","v":5005}]
[]
[null,null,{"$f":"Assumptions!$C$109","v":"Construction Contingency Costs "},{"$f":"Assumptions!$G$109","v":0.25}]
[null,null,{"$f":"Assumptions!$C$110","v":"Non-Construction Costs "},{"$f":"Assumptions!$G$110","v":0.30000000000000004}]
[null,null,{"$f":"Assumptions!$C$111","v":"Indirect Construction Costs"},{"$f":"Assumptions!$G$111","v":0.3}]
[]
[null,"Centrifuge Quantity and Cost Calcualtions"]
[null,null,null,null,null,"MATERIAL","TOTAL ","LABOR","TOTAL","TOTAL","TOTAL"]
[null,"ITEM NO.","DESCRIPTION","UNIT ","QUANTITY","COST","MATERIAL","COST","LABOR","UNIT","COST"]
[null,null,null,null,null,"UNIT","COST","UNIT","COST","COST"]
[null," "]
[null,1,"General","LS",null,null,null,null,null,null,{"$f":"(D204+D205+D206)*SUM(K233:K236)","v":473268.70799999998}]
[null,{"$f":"B232+1","v":2},"Centrifuges","EA",{"$f":"D196","v":2},{"$f":"D208","v":220000},{"$f":"F233*E233","v":440000},{"$f":"F233*$D$278","v":66000},{"$f":"H233*E233","v":132000},{"$f":"H233+F233","v":286000},{"$f":"J233*E233","v":572000}]
[null,3,"Building","SF",{"$f":"D209*D196+D210+D211*D196+D212+D214*D200+D215","v":2420},null,null,null,null,{"$f":"D216","v":350},{"$f":"J234*E234","v":847000}]
[null,4,"Pumps (centrate recycle)","EA",{"$f":"D200","v":2},{"$f":"D213","v":5826},{"$f":"F235*E235","v":11652},{"$f":"F235*$D$278","v":1747.8},{"$f":"H235*E235","v":3495.6},{"$f":"H235+F235","v":7573.8},{"$f":"J235*E235","v":15147.6}]
[null,5,"Piping","LS",null,null,null,null,null,null,{"$f":"D218*SUM(K233:K235)","v":143414.76}]
[null,6,"Electrical","LS",null,null,null,null,null,null,{"$f":"D219*SUM(K232:K236)","v":307624.66020000004}]
[null,7,"Instrumentation & Control","LS",null,null,null,null,null,null,{"$f":"D220*SUM(K232:K236)","v":307624.66020000004}]
[null,8,"Construction Contingency","LS",null,null,null,null,null,null,{"$f":"D223*SUM(K232:K238)","v":666520.09710000013}]
[null,null,"Direct Construction Costs",null,null,null,null,null,null,null,{"$f":"SUM(K232:K239)","v":3332600.4855000004}]
[null,null,"Indirect Construction Costs",null,null,null,null,null,null,null,{"$f":"K240*D225","v":999780.14565000008}]
[null,null,"Construction Costs",null,null,null,null,null,null,null,{"$f":"K241+K240","v":4332380.6311500007}]
[null,null,"Non-Construction Costs",null,null,null,null,null,null,null,{"$f":"K242*D224","v":1299714.1893450003}]
[null,null,"Total Capital Costs",null,null,null,null,null,null,null,{"$f":"K243+K242","v":5632094.820495001}]
[]
[]
[]
[null,"Centrifuge"]
[null,"Coagulant Solids"]
[null,"Specific Assumptions","Total centrifuge capacity",{"$f":"Centrifuge!H28","v":17.314814814814817},"lb/hr"]
[null,null,"# of Centrifuges",{"$f":"Centrifuge!E20","v":2}]
[null,null,"Loading per Centrifuge",{"$f":"Centrifuge!I28","v":17.314814814814817},"gpm"]
[]
[null,null,"Centrate Pumping Capacity",{"$f":"Cost_Input!$D$9*0.007","v":7},"gpm"]
[null,null,"# of Centrate Pumps",2,"gpm"]
[null,null,"Centrate Pump Capacity per Pump",{"$f":"D254/(D255)","v":3.5},"gpm"]
[]
[null,"Common Assumptions"]
[null,null,{"$f":"Assumptions!$C$103","v":"Site Work"},{"$f":"Assumptions!$D$103","v":0.08}]
[null,null,{"$f":"Assumptions!$C$104","v":"Yard Piping"},{"$f":"Assumptions!$D$104","v":0.21}]
[null,null,{"$f":"Assumptions!$C$105","v":"Final Grading"},{"$f":"Assumptions!$D$105","v":0.01}]
[]
[null,null,"Centrifuge Cost",{"$f":"VLOOKUP(D252,Assumptions!$D$46:$I$55,3,TRUE)","v":80000},"EA"]
[null,null,"Centrifuge Space",{"$f":"VLOOKUP(D252,Assumptions!$D$46:$I$55,4,TRUE)","v":400},"SF/centrifuge"]
[null,null,"Control/Electrical Room",1000,"SF"]
[null,null,"Classifier Area",{"$f":"Assumptions!F70","v":300},"SF/centrifuge"]
[null,null,"Truck Loading Area",{"$f":"Assumptions!M79*Assumptions!F71","v":1200},"SF"]
[null,null,"Centrate Pumping Cost",{"$f":"VLOOKUP(D256,Assumptions!$D$26:$I$39,3,TRUE)","v":5826},"EA"]
[null,null,"Centrate Pumping Space",{"$f":"VLOOKUP(D256,Assumptions!$D$26:$I$39,4,TRUE)","v":85},"SF/pump"]
[null,null,"Additional Pump Station Space",{"$f":"VLOOKUP(D256,Assumptions!$D$26:$I$39,5,TRUE)","v":250},"SF"]
[null,null,{"$f":"Assumptions!C23","v":"Dewatering Building"},{"$f":"Assumptions!E23","v":350},{"$f":"Assumptions!D23","v":"SF"}]
[null,null,"Polymer System Size",{"$f":"Centrifuge!$D$29*Centrifuge!$G$28/2000","v":0.875},"lb/hr"]
[null,null,"Polymer System Cost",{"$f":"((D272/62.5)^0.6)*590821","v":45617.632774512967},"LS"]
[]
[null,null,{"$f":"Assumptions!C95","v":"Piping"},{"$f":"Assumptions!$D$95","v":0.1}]
[null,null,{"$f":"Assumptions!C93","v":"Electrical"},{"$f":"Assumptions!$D$93","v":0.15}]
[null,null,{"$f":"Assumptions!$C$94","v":"Instrumentation and Controls"},{"$f":"Assumptions!$D$94","v":0.15}]
[null,null,{"$f":"Assumptions!C92","v":"Labor/Installation"},{"$f":"Assumptions!$D$92","v":0.3},{"$f":"Assumptions!E92","v":"equipment/item cost"}]
[]
[null,null,{"$f":"Assumptions!$C$109","v":"Construction Contingency Costs "},{"$f":"Assumptions!$G$109","v":0.25}]
[null,null,{"$f":"Assumptions!$C$110","v":"Non-Construction Costs "},{"$f":"Assumptions!$G$110","v":0.30000000000000004}]
[null,null,{"$f":"Assumptions!$C$111","v":"Indirect Construction Costs"},{"$f":"Assumptions!$G$111","v":0.3}]
[]
[null,"Centrifuge Quantity and Cost Calcualtions"]
[null,null,null,null,null,"MATERIAL","TOTAL ","LABOR","TOTAL","TOTAL","TOTAL"]
[null,"ITEM NO.","DESCRIPTION","UNIT ","QUANTITY","COST","MATERIAL","COST","LABOR","UNIT","COST"]
[null,null,null,null,null,"UNIT","COST","UNIT","COST","COST"]
[null," "]
[null,1,"General","LS",null,null,null,null,null,null,{"$f":"(D259+D260+D261)*SUM(K290:K294)","v":553002.52681558928}]
[null,{"$f":"B289+1","v":2},"Centrifuges","EA",{"$f":"D251","v":2},{"$f":"D263","v":80000},{"$f":"F290*E290","v":160000},{"$f":"F290*$D$278","v":24000},{"$f":"H290*E290","v":48000},{"$f":"H290+F290","v":104000},{"$f":"J290*E290","v":208000}]
[null,3,"Building","SF",{"$f":"D264*D251+D265+D266*D251+D267+D269*D255+D270","v":4020},null,null,null,null,{"$f":"D271","v":350},{"$f":"J291*E291","v":1407000}]
[null,4,"Polymer feed system","LS",1,null,null,null,null,{"$f":"IF(ISERROR(D273),0,D273)","v":45617.632774512967},{"$f":"J292*E292","v":45617.632774512967}]
[null,5,"Pumps (centrate recycle)","EA",{"$f":"D255","v":2},{"$f":"D268","v":5826},{"$f":"F293*E293","v":11652},{"$f":"F293*$D$278","v":1747.8},{"$f":"H293*E293","v":3495.6},{"$f":"H293+F293","v":7573.8},{"$f":"J293*E293","v":15147.6}]
[null,6,"Piping","LS",null,null,null,null,null,null,{"$f":"D275*SUM(K290:K293)","v":167576.52327745131}]
[null,7,"Electrical","LS",null,null,null,null,null,null,{"$f":"D276*SUM(K289:K294)","v":359451.64243013301}]
[null,8,"Instrumentation & Control","LS",null,null,null,null,null,null,{"$f":"D277*SUM(K289:K294)","v":359451.64243013301}]
[null,9,"Construction Contingency","LS",null,null,null,null,null,null,{"$f":"D280*SUM(K289:K296)","v":778811.891931955}]
[null,null,"Direct Construction Costs",null,null,null,null,null,null,null,{"$f":"SUM(K289:K297)","v":3894059.4596597748}]
[null,null,"Indirect Construction Costs",null,null,null,null,null,null,null,{"$f":"K298*D282","v":1168217.8378979324}]
[null,null,"Construction Costs",null,null,null,null,null,null,null,{"$f":"K299+K298","v":5062277.2975577069}]
[null,null,"Non-Construction Costs",null,null,null,null,null,null,null,{"$f":"K300*D281","v":1518683.1892673124}]
[null,null,"Total Capital Costs",null,null,null,null,null,null,null,{"$f":"K301+K300","v":6580960.4868250191}]
[]
[]
[]
[null,"Belt Filter Press"]
[null,"Specific Assumptions"]
[null,null,"Total belt filter capacity",{"$f":"'Belt filter press'!G28","v":175},"lb/hr"]
[null,null,"# of belt filters",{"$f":"Centrifuge!E20","v":2}]
[null,null,"Loading per belt filter",{"$f":"'Belt filter press'!I28","v":9.0902777777777786},"gpm"]
[]
[null,null,"Centrate Pumping Capacity",{"$f":"Cost_Input!$D$9*0.007","v":7},"gpm"]
[null,null,"# of Centrate Pumps",2,"gpm"]
[null,null,"Centrate Pump Capacity per Pump",{"$f":"D312/D313","v":3.5},"gpm"]
[]
[null,"Common Assumptions"]
[null,null,"Site Work",{"$f":"Assumptions!$D$103","v":0.08}]
[null,null,"Yard Piping",{"$f":"Assumptions!$D$104","v":0.21}]
[null,null,"Final Grading",{"$f":"Assumptions!$D$105","v":0.01}]
[]
[null,null,"belt filter Cost",{"$f":"VLOOKUP(D310,Assumptions!$U$59:$Y$63,3,TRUE)","v":290000},"EA"]
[null,null,"belt filter Space",{"$f":"VLOOKUP(D310,Assumptions!$U$59:$Y$63,4,TRUE)","v":370},"SF/centrifuge"]
[null,null,"Control/Electrical Room",1000,"SF"]
[null,null,"Classifier Area",300,"SF/centrifuge"]
[null,null,"Truck Loading Area",1200,"SF"]
[null,null,"Centrate Pumping Cost",{"$f":"VLOOKUP(D314,Assumptions!$D$26:$I$39,3,TRUE)","v":5826},"EA"]
[null,null,"Centrate Pumping Space",{"$f":"VLOOKUP(D314,Assumptions!$D$26:$I$39,4,TRUE)","v":85},"SF/pump"]
[null,null,"Additional Pump Station Space",{"$f":"VLOOKUP(D314,Assumptions!$D$26:$I$39,5,TRUE)","v":250},"SF"]
[null,null,"Dewatering Building",{"$f":"Assumptions!E23","v":350},"SF"]
[null,null,"Polymer System Size",{"$f":"'Belt filter press'!$D$29*'Belt filter press'!$G$28/2000","v":0.875},"lb/hr"]
[null,null,"Polymer System Cost",{"$f":"((D330/62.5)^0.6)*590821","v":45617.632774512967},"LS"]
[]
[null,null,"Piping",{"$f":"Assumptions!$D$95","v":0.1}]
[null,null,"Electrical",{"$f":"Assumptions!$D$93","v":0.15}]
[null,null,"Instrumentation and Controls",{"$f":"Assumptions!$D$94","v":0.15}]
[null,null,"Labor/Installation",{"$f":"Assumptions!$D$92","v":0.3}]
[]
[null,null,"Construction Contingency Costs ",{"$f":"Assumptions!$G$109","v":0.25}]
[null,null,"Non-Construction Costs ",{"$f":"Assumptions!$G$110","v":0.30000000000000004}]
[null,null,"Indirect Construction Costs",{"$f":"Assumptions!$G$111","v":0.3}]
[]
[null,"Belt filter Quantity and Cost Calcualtions"]
[null,null,null,null,null,"MATERIAL","TOTAL ","LABOR","TOTAL","TOTAL","TOTAL"]
[null,"ITEM NO.","DESCRIPTION","UNIT ","QUANTITY","COST","MATERIAL","COST","LABOR","UNIT","COST"]
[null,null,null,null,null,"UNIT","COST","UNIT","COST","COST"]
[null," "]
[null,1,"General","LS",null,null,null,null,null,null,{"$f":"(D317+D318+D319)*SUM(K348:K352)","v":724883.99783235381}]
[null,{"$f":"B347+1","v":2},"belt filter","EA",{"$f":"D309","v":2},{"$f":"D321","v":290000},{"$f":"F348*E348","v":580000},{"$f":"F348*$D$278","v":87000},{"$f":"H348*E348","v":174000},{"$f":"H348+F348","v":377000},{"$f":"J348*E348","v":754000}]
[null,3,"Building","SF",{"$f":"D322*D309+D323+D324*D309+D325+D327*D313+D328","v":3960},null,null,null,null,{"$f":"D329","v":350},{"$f":"J349*E349","v":1386000}]
[null,4,"Pumps (centrate recycle)","EA",{"$f":"D313","v":2},{"$f":"D326","v":5826},{"$f":"F350*E350","v":11652},{"$f":"F350*$D$278","v":1747.8},{"$f":"H350*E350","v":3495.6},{"$f":"H350+F350","v":7573.8},{"$f":"J350*E350","v":15147.6}]
[null,5,"Polymer System","LS",1,null,null,null,null,{"$f":"IF(ISERROR(D331),0,D331)","v":45617.632774512967},{"$f":"J351*E351","v":45617.632774512967}]
[null,6,"Piping","LS",null,null,null,null,null,null,{"$f":"D333*SUM(K348:K350)","v":215514.76}]
[null,7,"Electrical","LS",null,null,null,null,null,null,{"$f":"D334*SUM(K347:K352)","v":471174.59859102999}]
[null,8,"Instrumentation & Control","LS",null,null,null,null,null,null,{"$f":"D335*SUM(K347:K352)","v":471174.59859102999}]
[null,9,"Construction Contingency","LS",null,null,null,null,null,null,{"$f":"D338*SUM(K347:K354)","v":1020878.2969472317}]
[null,null,"Direct Construction Costs",null,null,null,null,null,null,null,{"$f":"SUM(K347:K355)","v":5104391.4847361585}]
[null,null,"Indirect Construction Costs",null,null,null,null,null,null,null,{"$f":"K356*D340","v":1531317.4454208475}]
[null,null,"Construction Costs",null,null,null,null,null,null,null,{"$f":"K357+K356","v":6635708.9301570058}]
[null,null,"Non-Construction Costs",null,null,null,null,null,null,null,{"$f":"K358*D339","v":1990712.6790471021}]
[null,null,"Total Capital Costs",null,null,null,null,null,null,null,{"$f":"K359+K358","v":8626421.6092041079}]
[]
[]
[]
[null,"Plate and frame press"]
[null,"Specific Assumptions"]
[null,null,"Total Plate and frame press capacity",{"$f":"'Plate and frame press'!G28","v":175},"lb/hr"]
[null,null,"# of Plate and frame presses",{"$f":"Centrifuge!E20","v":2}]
[null,null,"Loading per Plate and frame press",{"$f":"'Plate and frame press'!I28","v":175},"lb/hr"]
[]
[null,null,"Centrate Pumping Capacity",{"$f":"Cost_Input!$D$9*0.007","v":7},"gpm"]
[null,null,"# of Centrate Pumps",2,"gpm"]
[null,null,"Centrate Pump Capacity per Pump",{"$f":"D370/D371","v":3.5},"gpm"]
[]
[null,"Common Assumptions"]
[null,null,"Site Work",{"$f":"Assumptions!$D$103","v":0.08}]
[null,null,"Yard Piping",{"$f":"Assumptions!$D$104","v":0.21}]
[null,null,"Final Grading",{"$f":"Assumptions!$D$105","v":0.01}]
[]
[null,null,"Plate and frame press Cost",{"$f":"VLOOKUP(D368,Assumptions!$AC$59:$AG$64,3,TRUE)","v":200000},"EA"]
[null,null,"Plate and frame press Space",{"$f":"VLOOKUP(D368,Assumptions!$AC$59:$AG$64,4,TRUE)","v":350},"SF/centrifuge"]
[null,null,"Control/Electrical Room",1000,"SF"]
[null,null,"Classifier Area",300,"SF/centrifuge"]
[null,null,"Truck Loading Area",1200,"SF"]
[null,null,"Centrate Pumping Cost",{"$f":"VLOOKUP(D372,Assumptions!$D$26:$I$39,3,TRUE)","v":5826},"EA"]
[null,null,"Centrate Pumping Space",{"$f":"VLOOKUP(D372,Assumptions!$D$26:$I$39,4,TRUE)","v":85},"SF/pump"]
[null,null,"Additional Pump Station Space",{"$f":"VLOOKUP(D372,Assumptions!$D$26:$I$39,5,TRUE)","v":250},"SF"]
[null,null,"Dewatering Building",{"$f":"Assumptions!E23","v":350},"SF"]
[null,null,"Polymer System Size",{"$f":"'Plate and frame press'!$D$29*'Plate and frame press'!$G$28/2000","v":0.875},"lb/hr"]
[null,null,"Polymer System Cost",{"$f":"((D388/62.5)^0.6)*590821","v":45617.632774512967},"LS"]
[]
[null,null,"Piping",{"$f":"Assumptions!$D$95","v":0.1}]
[null,null,"Electrical",{"$f":"Assumptions!$D$93","v":0.15}]
[null,null,"Instrumentation and Controls",{"$f":"Assumptions!$D$94","v":0.15}]
[null,null,"Labor/Installation",{"$f":"Assumptions!$D$92","v":0.3}]
[]
[null,null,"Construction Contingency Costs ",{"$f":"Assumptions!$G$109","v":0.25}]
[null,null,"Non-Construction Costs ",{"$f":"Assumptions!$G$110","v":0.30000000000000004}]
[null,null,"Indirect Construction Costs",{"$f":"Assumptions!$G$111","v":0.3}]
[]
[null,"Plate and Frame"]
[null,null,null,null,null,"MATERIAL","TOTAL ","LABOR","TOTAL","TOTAL","TOTAL"]
[null,"ITEM NO.","DESCRIPTION","UNIT ","QUANTITY","COST","MATERIAL","COST","LABOR","UNIT","COST"]
[null,null,null,null,null,"UNIT","COST","UNIT","COST","COST"]
[null," "]
[null,1,"General","LS",null,null,null,null,null,null,{"$f":"(D375+D376+D377)*SUM(K406:K410)","v":643043.99783235393}]
[null,{"$f":"B405+1","v":2},"Plate and frame press","EA",{"$f":"D367","v":2},{"$f":"D379","v":200000},{"$f":"F406*E406","v":400000},{"$f":"F406*$D$278","v":60000},{"$f":"H406*E406","v":120000},{"$f":"H406+F406","v":260000},{"$f":"J406*E406","v":520000}]
[null,3,"Building","SF",{"$f":"D380*D367+D381+D382*D367+D383+D385*D371+D386","v":3920},null,null,null,null,{"$f":"D387","v":350},{"$f":"J407*E407","v":1372000}]
[null,4,"Pumps (centrate recycle)","EA",{"$f":"D371","v":2},{"$f":"D384","v":5826},{"$f":"F408*E408","v":11652},{"$f":"F408*$D$278","v":1747.8},{"$f":"H408*E408","v":3495.6},{"$f":"H408+F408","v":7573.8},{"$f":"J408*E408","v":15147.6}]
[null,5,"Polymer Feed System","LS",1,null,null,null,null,{"$f":"IF(ISERROR(D389),0,D389)","v":45617.632774512967},{"$f":"J409*E409","v":45617.632774512967}]
[null,6,"Piping","LS",null,null,null,null,null,null,{"$f":"D391*SUM(K406:K408)","v":190714.76}]
[null,7,"Electrical","LS",null,null,null,null,null,null,{"$f":"D392*SUM(K405:K410)","v":417978.59859102999}]
[null,8,"Instrumentation & Control","LS",null,null,null,null,null,null,{"$f":"D393*SUM(K405:K410)","v":417978.59859102999}]
[null,9,"Construction Contingency","LS",null,null,null,null,null,null,{"$f":"D396*SUM(K405:K412)","v":905620.29694723175}]
[null,null,"Direct Construction Costs",null,null,null,null,null,null,null,{"$f":"SUM(K405:K413)","v":4528101.4847361585}]
[null,null,"Indirect Construction Costs",null,null,null,null,null,null,null,{"$f":"K414*D398","v":1358430.4454208475}]
[null,null,"Construction Costs",null,null,null,null,null,null,null,{"$f":"K415+K414","v":5886531.9301570058}]
[null,null,"Non-Construction Costs",null,null,null,null,null,null,null,{"$f":"K416*D397","v":1765959.579047102}]
[null,null,"Total Capital Costs",null,null,null,null,null,null,null,{"$f":"K417+K416","v":7652491.5092041083}]
[]
[]
[]
[null,"SFBW EQ"]
[null,"Specific Assumptions"]
[null,null,"EQ diameter ",{"$f":"'SFBW EQ'!D6","v":40},"ft"]
[null,null,"# of EQ's",{"$f":"'SFBW EQ'!I16","v":2}]
[null,null,"side wall depth",{"$f":"'SFBW EQ'!D8","v":15},"ft"]
[]
[null,null,"EQ Pumping Capacity",{"$f":"Cost_Input!D7*1000000*('SFBW EQ'!D14/100)/1440","v":41.666666666666664},"gpm"]
[null,null,"# of EQ Pumps",2]
[null,null,"EQ Pump Capacity per Pump",{"$f":"D428/(D429)","v":20.833333333333332},"gpm"]
[]
[null,"Common Assumptions"]
[null,null,{"$f":"Assumptions!$C$103","v":"Site Work"},{"$f":"Assumptions!$D$103","v":0.08}]
[null,null,{"$f":"Assumptions!$C$104","v":"Yard Piping"},{"$f":"Assumptions!$D$104","v":0.21}]
[null,null,{"$f":"Assumptions!$C$105","v":"Final Grading"},{"$f":"Assumptions!$D$105","v":0.01}]
[]
[null,null,{"$f":"Assumptions!C5","v":"basin side wall and bottom thickness"},{"$f":"Assumptions!D5","v":1},{"$f":"Assumptions!E5","v":"ft"}]
[null,null,{"$f":"Assumptions!C6","v":"cone slope"},{"$f":"Assumptions!D6","v":0.25},{"$f":"Assumptions!E6","v":"ft/ft"}]
[null,null,{"$f":"Assumptions!C7","v":"% of side wall depth under ground"},{"$f":"Assumptions!D7","v":0.5},{"$f":"Assumptions!E7","v":0}]
[null,null,{"$f":"Assumptions!C8","v":"Excavation extended past perimeter"},{"$f":"Assumptions!D8","v":5},{"$f":"Assumptions!E8","v":"ft"}]
[null,null,{"$f":"Assumptions!C9","v":"Excavation extended past bottom depth"},{"$f":"Assumptions!D9","v":5},{"$f":"Assumptions!E9","v":"ft"}]
[null,null,{"$f":"Assumptions!C16","v":"Concrete"},{"$f":"Assumptions!E16","v":650},{"$f":"Assumptions!D16","v":"CY"}]
[null,null,{"$f":"Assumptions!C17","v":"Excavation"},{"$f":"Assumptions!E17","v":30},{"$f":"Assumptions!D17","v":"CY"}]
[null,null,"EQ Pump Cost",{"$f":"VLOOKUP(D430,Assumptions!$D$26:$I$39,3,TRUE)","v":5826},"EA"]
[null,null,"EQ Pumping Space",{"$f":"VLOOKUP(D430,Assumptions!$D$26:$I$39,4,TRUE)","v":85},"SF"]
[null,null,"Additional Pump Station Space",{"$f":"VLOOKUP(D430,Assumptions!$D$26:$I$39,5,TRUE)","v":250},"SF"]
[null,null,{"$f":"Assumptions!$C$21","v":"Pump Station/Building "},{"$f":"Assumptions!$E$21","v":250},{"$f":"Assumptions!$D$21","v":"SF"}]
[null,null,"Mixer Cost",{"$f":"Assumptions!$E$18","v":1103.3},{"$f":"Assumptions!$F$18","v":"per LF plus"},{"$f":"Assumptions!$G$18","v":20347}]
[]
[null,null,{"$f":"Assumptions!$C$95","v":"Piping"},{"$f":"Assumptions!$D$95","v":0.1}]
[null,null,{"$f":"Assumptions!$C$93","v":"Electrical"},{"$f":"Assumptions!$D$93","v":0.15}]
[null,null,{"$f":"Assumptions!$C$94","v":"Instrumentation and Controls"},{"$f":"Assumptions!$D$94","v":0.15}]
[null,null,{"$f":"Assumptions!$C$92","v":"Labor/Installation"},{"$f":"Assumptions!$D$92","v":0.3},{"$f":"Assumptions!$E$92","v":"equipment/item cost"}]
[]
[null,null,{"$f":"Assumptions!$C$109","v":"Construction Contingency Costs "},{"$f":"Assumptions!$G$109","v":0.25}]
[null,null,{"$f":"Assumptions!$C$110","v":"Non-Construction Costs "},{"$f":"Assumptions!$G$110","v":0.30000000000000004}]
[null,null,{"$f":"Assumptions!$C$111","v":"Indirect Construction Costs"},{"$f":"Assumptions!$G$111","v":0.3}]
[]
[null,"SFBW EQ Quantity and Cost Calcualtions"]
[null,null,null,null,null,"MATERIAL","TOTAL ","LABOR","TOTAL","TOTAL","TOTAL"]
[null,"ITEM NO.","DESCRIPTION","UNIT ","QUANTITY","COST","MATERIAL","COST","LABOR","UNIT","COST"]
[null,null,null,null,null,"UNIT","COST","UNIT","COST","COST"]
[null," "]
[null,1,"General","LS",null,null,null,null,null,null,{"$f":"(D433+D434+D435)*SUM(K465:K470)","v":146998.34287994565}]
[null,{"$f":"B464+1","v":2},"Excavation","CY",{"$f":"$D$425*(PI()*($D$424/2+$D$440)^2*$D$426*$D$439+1/3*PI()*($D$424/2+$D$440)^2*($D$438*($D$424/2)+$D$441))/27","v":1575.6444636059916},{"$f":"D443","v":30},{"$f":"E465*F465","v":47269.333908179746},{"$f":"F465*$D$453","v":9},{"$f":"H465*E465","v":14180.800172453924},{"$f":"F465+H465","v":39},{"$f":"E465*J465","v":61450.134080633674}]
[null,3,"Concrete","CY",{"$f":"$D$425*((PI()/4*($D$424+2*$D$437)^2-PI()/4*($D$424)^2)*$D$426+PI()*($D$424/2)*SQRT(($D$424/2)^2+($D$424/2*$D$438)^2)*$D$437)/27","v":239.06602342957336},{"$f":"D442","v":650},{"$f":"E466*F466","v":155392.91522922268},{"$f":"F466*$D$453","v":195},{"$f":"H466*E466","v":46617.874568766805},{"$f":"F466+H466","v":845},{"$f":"E466*J466","v":202010.78979798951}]
[null,4,"Pumps (to SFBW Clarifiers)","EA",{"$f":"D429","v":2},{"$f":"D444","v":5826},{"$f":"E467*F467","v":11652},{"$f":"F467*$D$453","v":1747.8},{"$f":"H467*E467","v":3495.6},{"$f":"F467+H467","v":7573.8},{"$f":"E467*J467","v":15147.6}]
[null,5,"Mixers","EA",{"$f":"D425","v":2},{"$f":"D448*D424-F448","v":23785},{"$f":"E468*F468","v":47570},{"$f":"F468*$D$453","v":7135.5},{"$f":"H468*E468","v":14271},{"$f":"F468+H468","v":30920.5},{"$f":"E468*J468","v":61841}]
[null,6,"Pump Station/Building","SF",{"$f":"D445*D425+D446","v":420},null,null,null,null,{"$f":"D447","v":250},{"$f":"E469*J469","v":105000}]
[null,7,"Piping","LS",null,null,null,null,null,null,{"$f":"D450*SUM(K465:K469)","v":44544.952387862315}]
[null,8,"Electrical","LS",null,null,null,null,null,null,{"$f":"D451*SUM(K464:K470)","v":95548.922871964649}]
[null,9,"Instrumentation & Controls","LS",null,null,null,null,null,null,{"$f":"D452*SUM(K464:K470)","v":95548.922871964649}]
[null,10,"Construction Contingency","LS",null,null,null,null,null,null,{"$f":"D455*SUM(K464:K472)","v":207022.66622259008}]
[null,null,"Direct Construction Costs",null,null,null,null,null,null,null,{"$f":"SUM(K464:K473)","v":1035113.3311129503}]
[null,null,"Indirect Construction Costs",null,null,null,null,null,null,null,{"$f":"K474*D457","v":310533.99933388509}]
[null,null,"Construction Costs",null,null,null,null,null,null,null,{"$f":"K475+K474","v":1345647.3304468354}]
[null,null,"Non-Construction Costs",null,null,null,null,null,null,null,{"$f":"K476*D456","v":403694.19913405069}]
[null,null,"Total Capital Costs",null,null,null,null,null,null,null,{"$f":"K477+K476","v":1749341.529580886}]
[]
[null,"SFBW CLARIFIER"]
[null,"Specific Assumptions"]
[null,null,"Clarifier  diameter ",{"$f":"'SFBW Clarifier'!D6","v":8},"ft"]
[null,null,"# of clarifiers",{"$f":"'SFBW Clarifier'!I13","v":1}]
[null,null,"side wall depth",{"$f":"'SFBW Clarifier'!D11","v":15},"ft"]
[]
[null,null,"Clarifier Underflow Pumping Capacity",{"$f":"0.9373*Cost_Input!D7+0.7972","v":1.7345000000000002},"gpm"]
[null,null,"# of Clarifier Underflow Pumps",2]
[null,null,"Clarifier Underflow Capacity per Pump",{"$f":"D486/(D487)","v":0.86725000000000008}]
[]
[null,"Common Assumptions"]
[null,null,{"$f":"Assumptions!$C$103","v":"Site Work"},{"$f":"Assumptions!$D$103","v":0.08}]
[null,null,{"$f":"Assumptions!$C$104","v":"Yard Piping"},{"$f":"Assumptions!$D$104","v":0.21}]
[null,null,{"$f":"Assumptions!$C$105","v":"Final Grading"},{"$f":"Assumptions!$D$105","v":0.01}]
[]
[null,null,{"$f":"Assumptions!C5","v":"basin side wall and bottom thickness"},{"$f":"Assumptions!D5","v":1},{"$f":"Assumptions!E5","v":"ft"}]
[null,null,{"$f":"Assumptions!C6","v":"cone slope"},{"$f":"Assumptions!D6","v":0.25},{"$f":"Assumptions!E6","v":"ft/ft"}]
[null,null,{"$f":"Assumptions!C7","v":"% of side wall depth under ground"},{"$f":"Assumptions!D7","v":0.5}]
[null,null,{"$f":"Assumptions!C8","v":"Excavation extended past perimeter"},{"$f":"Assumptions!D8","v":5},{"$f":"Assumptions!E8","v":"ft"}]
[null,null,{"$f":"Assumptions!C9","v":"Excavation extended past bottom depth"},{"$f":"Assumptions!D9","v":5},{"$f":"Assumptions!E9","v":"ft"}]
[null,null,{"$f":"Assumptions!C16","v":"Concrete"},{"$f":"Assumptions!E16","v":650},{"$f":"Assumptions!D16","v":"CY"}]
[null,null,{"$f":"Assumptions!C17","v":"Excavation"},{"$f":"Assumptions!E17","v":30},{"$f":"Assumptions!D17","v":"CY"}]
[null,null,{"$f":"Assumptions!C22","v":"Tubes"},{"$f":"Assumptions!E22","v":126},{"$f":"Assumptions!D22","v":"SF"}]
[null,null,{"$f":"Assumptions!C19","v":"Mechanical Sludge Collector"},{"$f":"Assumptions!E19","v":966.39},{"$f":"Assumptions!F19","v":"per LF plus"}]
[null,null,"Clarifier Underflow Pump Cost",{"$f":"VLOOKUP(D486,Assumptions!$D$26:$I$39,3,TRUE)","v":5826},"EA"]
[null,null,"Clarifier Underflow Pumping Space",{"$f":"VLOOKUP(D486,Assumptions!$D$26:$I$39,4,TRUE)","v":85},"SF"]
[null,null,"Additional Pump Station Space",{"$f":"VLOOKUP(D486,Assumptions!$D$26:$I$39,5,TRUE)","v":250},"SF"]
[null,null,{"$f":"Assumptions!$C$21","v":"Pump Station/Building "},{"$f":"Assumptions!$E$21","v":250},{"$f":"Assumptions!$D$21","v":"SF"}]
[null,null,"SFBW Polymer Feed System",{"$f":"HLOOKUP(D572,Assumptions!$F$88:$N$89,2,FALSE)","v":{"$error":"#N/A"}},"EA"]
[]
[null,null,{"$f":"Assumptions!$C$95","v":"Piping"},{"$f":"Assumptions!$D$95","v":0.1}]
[null,null,{"$f":"Assumptions!$C$93","v":"Electrical"},{"$f":"Assumptions!$D$93","v":0.15}]
[null,null,{"$f":"Assumptions!$C$94","v":"Instrumentation and Controls"},{"$f":"Assumptions!$D$94","v":0.15}]
[null,null,{"$f":"Assumptions!$C$92","v":"Labor/Installation"},{"$f":"Assumptions!$D$92","v":0.3},{"$f":"Assumptions!$E$92","v":"equipment/item cost"}]
[]
[null,null,{"$f":"Assumptions!$C$109","v":"Construction Contingency Costs "},{"$f":"Assumptions!$G$109","v":0.25}]
[null,null,{"$f":"Assumptions!$C$110","v":"Non-Construction Costs "},{"$f":"Assumptions!$G$110","v":0.30000000000000004}]
[null,null,{"$f":"Assumptions!$C$111","v":"Indirect Construction Costs"},{"$f":"Assumptions!$G$111","v":0.3}]
[]
[null,"SFBW Clarifier Quantity and Cost Calcualtions"]
[null,null,null,null,null,"MATERIAL","TOTAL ","LABOR","TOTAL","TOTAL","TOTAL"]
[null,"ITEM NO.","DESCRIPTION","UNIT ","QUANTITY","COST","MATERIAL","COST","LABOR","UNIT","COST"]
[null,null,null,null,null,"UNIT","COST","UNIT","COST","COST"]
[null," "]
[null,1,"General","LS",null,null,null,null,null,null,{"$f":"(D491+D492+D493)*SUM(K525:K532)","v":50984.621734515516}]
[null,{"$f":"B524+1","v":2},"Excavation","CY",{"$f":"$D$483*(PI()*($D$482/2+$D$498)^2*$D$484*$D$497+1/3*PI()*($D$482/2+$D$498)^2*($D$496*($D$482/2)+$D$499))/27","v":89.535390627309098},{"$f":"D501","v":30},{"$f":"E525*F525","v":2686.0617188192728},{"$f":"F525*$D$513","v":9},{"$f":"H525*E525","v":805.81851564578187},{"$f":"F525+H525","v":39},{"$f":"J525*E525","v":3491.8802344650549}]
[null,3,"Concrete","CY",{"$f":"$D$483*((PI()/4*($D$482+2*$D$495)^2-PI()/4*($D$482)^2)*$D$484+PI()*($D$482/2)*SQRT(($D$482/2)^2+($D$482/2*$D$496)^2)*$D$495)/27","v":17.626943763269736},{"$f":"D500","v":650},{"$f":"E526*F526","v":11457.513446125329},{"$f":"F526*$D$513","v":195},{"$f":"H526*E526","v":3437.2540338375984},{"$f":"F526+H526","v":845},14894.767479962928]
[null,4,"Tubes","SF",{"$f":"(PI()/4*D482^2)*D483","v":50.26548245743669},{"$f":"D502","v":126},{"$f":"E527*F527","v":6333.4507896370233},{"$f":"F527*$D$513","v":37.799999999999997},{"$f":"H527*E527","v":1900.0352368911067},{"$f":"F527+H527","v":163.80000000000001},8233.4860265281295]
[null,5,"Mechancial Sludge Collector","EA",{"$f":"D483","v":1},null,null,null,null,{"$f":"D503*D482+F503","v":7731.12},7731.12]
[null,6,"Pumps (for Clarifier Underflow)","EA",{"$f":"D487","v":2},{"$f":"D504","v":5826},{"$f":"E529*F529","v":11652},{"$f":"F529*$D$513","v":1747.8},{"$f":"H529*E529","v":3495.6},{"$f":"F529+H529","v":7573.8},15147.6]
[null,7,"Polymer System","EA",1,null,null,null,null,{"$f":"IF(ISERROR(D508),0,D508)","v":0},0]
[null,8,"Buildings for Pumps","SF",{"$f":"D505*E529+D506","v":420},null,null,null,null,{"$f":"D507","v":250},105000,{"$f":"(K531+K529)/K536","v":0.33465740226406121}]
[null,9,"Piping","LS",null,null,null,null,null,null,{"$f":"D510*SUM(K525:K531)","v":15449.885374095611}]
[null,10,"Electrical","LS",null,null,null,null,null,null,{"$f":"D511*SUM(K524:K532)","v":33140.004127435088}]
[null,11,"Instrumentation & Controls","LS",null,null,null,null,null,null,{"$f":"D512*SUM(K524:K532)","v":33140.004127435088}]
[null,12,"Construction Contingency","LS",null,null,null,null,null,null,{"$f":"D515*SUM(K524:K534)","v":71803.342276109353}]
[null,null,"Direct Construction Costs",null,null,null,null,null,null,null,{"$f":"SUM(K524:K535)","v":359016.7113805468}]
[null,null,"Indirect Construction Costs",null,null,null,null,null,null,null,{"$f":"K536*D517","v":107705.01341416403}]
[null,null,"Construction Costs",null,null,null,null,null,null,null,{"$f":"K537+K536","v":466721.72479471081}]
[null,null,"Non-Construction Costs",null,null,null,null,null,null,null,{"$f":"K538*D516","v":140016.51743841326}]
[null,null,"Total Capital Costs",null,null,null,null,null,null,null,{"$f":"K539+K538","v":606738.2422331241}]
[]
[null,"O&M Costing"]
[]
[null,"Power"]
[null,null,"Cost of Power",{"$f":"Assumptions!D142","v":0.1225},{"$f":"Assumptions!E142","v":"$/kWh"}]
[null,null,null,"Installed hp","Runtime","Annual",null,"Power Costs","Eqiupment","Est. Runtime (hrs/week)"]
[null,null,null,"(hp)","(hrs)","Cost",null,null,{"$f":"C115","v":"Pumps (Clarifier Blowdown to Thickeners)"},"168*"]
[null,null,"Clarifier Blowdown Pumps (Main Process)",{"$f":"VLOOKUP(D62,Assumptions!$D$26:$I$39,6,TRUE)*(E115-1)","v":1.5},168,{"$f":"D548*0.7457*E548*52*$D$545","v":1197.027468},null,null,{"$f":"C116","v":"Pumps (Thickened Solids to Day Tanks)"},"168 for softening, 8 x # of shifts from Memo 4C, Exhibit 12"]
[null,null,"Thickened Solids Pumps (Thickener to Day Tanks)",{"$f":"VLOOKUP(D63,Assumptions!$D$42:$I$43,6,TRUE)*(E116-1)","v":10},168,7980.1831200000006,null,null,{"$f":"C117","v":"Pumps (Thickener Overflow to Recycle)"},168]
[null,null,"Thickener Overflow Pumps",{"$f":"VLOOKUP(D64,Assumptions!$D$26:$I$39,6,TRUE)*(E117-1)","v":1.5},168,1197.027468,null,null,{"$f":"C178","v":"Pumps to Centrifuge"},"See Memo 4C, Exhibit 12"]
[null,null,"Thickened Solids Pumps (Day Tank to Dewatering)",{"$f":"VLOOKUP(D136,Assumptions!$D$42:$I$43,6,TRUE)*(E178-1)","v":10},168,7980.1831200000006,null,null,{"$f":"C293","v":"Pumps (centrate recycle)"},"See Memo 4C, Exhibit 12"]
[null,null,"Centrate Recycle Pumps",{"$f":"VLOOKUP(D254,Assumptions!$D$26:$I$39,6,TRUE)*(E293-1)","v":1.5},40,285.00653999999997,null,null,{"$f":"C467","v":"Pumps (to SFBW Clarifiers)"},168]
[null,null,"SFBW EQ Pumps",{"$f":"VLOOKUP(D428,Assumptions!$D$26:$I$39,6,TRUE)*(E467-1)","v":1.5},168,1197.027468,null,null,"Day Tank Mixers","See Memo 4C, Exhibit 12"]
[null,null,"Clarifier Underflow Pumps (SFBW)",{"$f":"VLOOKUP(D486,Assumptions!$D$26:$I$39,6,TRUE)*(E529-1)","v":1.5},28,199.50457799999998,null,null,"SFBW Mixers",168]
[null,null,"Mixers (Day Tanks)",{"$f":"ROUNDUP(Assumptions!$D$143*(D134*PI()/4*(D132^2)*7.4805/1000000),0)*D133","v":2},168,1596.0366239999998,null,null,"Thickener Mechancial Sludge Collectors",168]
[null,null,"Mixers (EQ Basin)",{"$f":"ROUNDUP(Assumptions!$D$143*(D426*PI()/4*(D424^2)*7.4805/1000000),0)*D425","v":12},168,9576.219744,null,null,"SFBW Clarifier Mechanical Sludge Collectors",168]
[null,null,"Mechancial Sludge Collector (Thickeners)",{"$f":"D59*Assumptions!$D$144","v":1},168,798.01831199999992,null,null,"Centrifuges","See Memo 4C, Exhibit 12"]
[null,null,"Mechanical Sludge Collector (SFBW Clarifiers)",{"$f":"D483*Assumptions!$D$144","v":1},168,798.01831199999992]
[null,null,"Centrifuges",{"$f":"VLOOKUP(D252,Assumptions!$D$59:$I$64,6,TRUE)*(D251-1)","v":37.5},40,7125.1634999999997]
[]
[null,null,"Total Cost of Power",null,null,{"$f":"SUM(F548:F559)","v":39929.416254000003},"$/year"]
[]
[null,"Cake Disposal"]
[null,null,"Mass of Cake Generated",{"$f":"(Cost_Input!D9/2000)*(100/'O&M input'!D22)","v":2.5},"tons/day (avg)"]
[null,null,{"$f":"Assumptions!C137","v":"Average trip length"},{"$f":"Assumptions!D137","v":50},{"$f":"Assumptions!E137","v":"mile"}]
[null,null,{"$f":"Assumptions!C138","v":"Trucking cost (truck + operator)"},{"$f":"Assumptions!D138","v":0.25},{"$f":"Assumptions!E138","v":"$/(mile-ton)"}]
[null,null,{"$f":"Assumptions!C139","v":"Average tipping fee"},{"$f":"Assumptions!D139","v":34.29},{"$f":"Assumptions!E139","v":"$/ton"}]
[]
[null,null,"Cost of Cake Disposal",{"$f":"(D564*D565*D566+D564*D567)*365","v":42695.875},"$/year"]
[]
[null,"Chemical Usage"]
[null,null,"Polymer Usage (SFBW Clarifier)",{"$f":"'SFBW Clarifier'!$D$13*'SFBW Clarifier'!$G$13*3.785/453590*60*24","v":0.10013448268259884},"lb/day"]
[null,null,"Polymer Usage (Thickener)",{"$f":"Thickener!D17*Thickener!J16/2000","v":3},"lb/day"]
[null,null,"Polymer Usage (Dewatering)",{"$f":"Centrifuge!D29*Centrifuge!G28/2000*Centrifuge!E22*Centrifuge!I6","v":35},"lb/week"]
[]
[null,null,"Cost of Polymer",{"$f":"Assumptions!D147","v":2.04},{"$f":"Assumptions!E147","v":"$/lb"}]
[]
[null,null,"Total Chemical Cost",{"$f":"((D572+D573)*365+D574*52)*D576","v":6021.1601358054631},"$/year"]
[]
[null,"Labor"]
[null,null,"# of Centrifuge Operators",{"$f":"'O&M input'!D7","v":1}]
[null,null,"# of Supervisors",{"$f":"'O&M input'!D9","v":1}]
[null,null,"# of Maintenance FTEs",{"$f":"'O&M input'!D11","v":0}]
[]
[null,null,"Burdened Centrifuge Operator Wage",{"$f":"'O&M input'!D16*'O&M input'!D19","v":68000},"$/year"]
[null,null,"Burdened Supervisor Wage",{"$f":"'O&M input'!D17*'O&M input'!D19","v":93500},"$/year"]
[null,null,"Burdened Maintenance Wage",{"$f":"'O&M input'!D18*'O&M input'!D19","v":85000},"$/year"]
[]
[null,null,"Total Cost of Labor",{"$f":"D581*D585+D582*D586+D583*D587","v":161500},"$/year"]
[]
[null,"Maintenance/Replacement Costs"]
[null,null,"Maintenance Cost Multiplier",{"$f":"'O&M input'!I12","v":3},{"$f":"Assumptions!E151","v":"% of capital costs"}]
[]
[null,null,{"$f":"C14","v":"Thickener"},{"$f":"IF(ISERROR($D$592/100*SUM(K114,K115,K116,K117,K120,K121,K122)),0,$D$592/100*SUM(K114,K115,K116,K117,K120,K121,K122))","v":14302.954663673894},"$/year"]
[null,null,{"$f":"C15","v":"Day Tank"},{"$f":"IF(ISERROR($D$592/100*SUM(K177,K178,K180,K181,K182,K183)),0,D$592/100*SUM(K177,K178,K180,K181,K182,K183))","v":11231.284603593134},"$/year"]
[null,null,{"$f":"C16","v":"Dewatering"},{"$f":"IF(ISERROR($D$592/100*SUM(K290,K293,K294,K295,K296)),0,$D$592/100*SUM(K290,K293,K294,K295,K296))","v":33288.822244131516},"$/year"]
[null,null,{"$f":"C17","v":"SFBW EQ"},{"$f":"IF(ISERROR($D$592/100*SUM(K467,K468,K470,K471,K472)),0,$D$592/100*SUM(K467,K468,K470,K471,K472))","v":9378.9419439537487},"$/year"]
[null,null,{"$f":"C18","v":"SFBW Clarifier"},{"$f":"IF(ISERROR($D$592/100*SUM(K527,K528,K529,K530,K532,K533,K534)),0,$D$592/100*SUM(K527,K528,K529,K530,K532,K533,K534))","v":3385.2629896648173},"$/year"]
[]
[null,null,"Total Cost of Maintenance/Replacement",{"$f":"SUM(D594:D598)","v":71587.2664450171},"$/year"]

{"sheet":"Assumptions","index":11,"n_rows":156,"n_cols":33,"rows_kept":156,"cut":false,"hidden":false,"merged":[[91,13,91,16]]}
["Ref No."]
[2,"Design Assumptions"]
[{"$f":"A2+1","v":3}]
[4,"Tanks"]
[5,null,"basin side wall and bottom thickness",1,"ft"]
[6,null,"cone slope",{"$f":"3/12","v":0.25},"ft/ft"]
[7,null,"% of side wall depth under ground",0.5]
[8,null,"Excavation extended past perimeter",5,"ft"]
[9,null,"Excavation extended past bottom depth",5,"ft"]
[10]
[11]
[12]
[13]
[14,"Unit Costs"]
[15,null,"Item","Unit","Unit Cost"]
[16,null,"Concrete","CY",650]
[17,null,"Excavation","CY",30]
[18,null,"Mixers","LF",1103.3,"per LF plus",20347]
[19,null,"Mechanical Sludge Collector","LF",966.39,"per LF plus",17595]
[20,null,"Aluminum Cover",null,2714.3,"per LF minus",20143]
[21,null,"Pump Station/Building ","SF",250]
[22,null,"Tubes","SF",126]
[23,null,"Dewatering Building","SF",350]
[24]
[25,"Centrifigual Pumps",null,"Lower Limit (gpm)","Upper Limit (gpm)","Pump Cost ($)","Space Required per Pump (ft2)","Additional Space Required per Station (ft2)","hp",null,"Ref No."]
[26,null,"Goulds 3196 1x1.5-8 STX",1,70,5826,85,250,1.5,null,{"$f":"A26","v":26}]
[27,null,"Goulds 3196 3x4-8G",70,125,8361,100,350,3,null,27]
[28,null,"Goulds 3196 3x4-8G",125,275,8361,100,350,5,null,28]
[29,null,"Goulds 3196 3x4-8",275,450,9259,100,350,7.5,null,29]
[30,null,"Goulds 3196 3x4-8",450,550,9259,100,350,10,null,30]
[31,null,"Goulds 3196 6x8-13",550,900,19722,125,500,15,null,31]
[32,null,"Goulds 3196 6x8-13",900,1200,19722,125,500,20,null,32]
[33,null,"Goulds 3196 6x8-13",1200,1500,19722,125,500,25,null,33]
[34,null,"Goulds 3196 8x10-13",1500,2000,24765,125,750,30,null,34]
[{"$f":"A34+1","v":35},null,"Goulds 3196 8x10-13",2000,2300,24765,125,750,40,null,35]
[36,null,"Goulds 3196 8x10-16HX17",3295,3305,29680,125,750,50,null,36]
[37,null,"Goulds 3180 12x14-19XL",4995,5005,48453,150,1000,75,null,37]
[38,null,"Goulds 3180 14x16-22XL",7995,8005,64092,175,1250,125,null,38]
[39,null,"Goulds 3180 18x18-22XL",12495,12505,73812,200,1500,200,null,39]
[40]
[41,"Progressive Cavity Pumps",null,"Lower Limit (gpm)","Upper Limit (gpm)","Pump Cost ($)","Space Required per Pump (ft2)","Additional Space Required per Station (ft2)","hp",null,"Ref No."]
[42,null,"Netzsch 6x6",1,200,9900,300,500,10,null,{"$f":"A42","v":42}]
[43,null,"Netzsch 6x8",200,600,27800,350,750,40,null,{"$f":"A43","v":43}]
[44]
[45,"Centrifuges - Coagulant",null,"Lower Limit (gpm)","Upper Limit (gpm)","Centrifuge Cost ($)","Space Required per Centrifuge (ft2)","Additional Space Required per Station (ft2)","hp",null,"Ref No."]
[46,null,30,0,30,80000,400,{"$f":"2000","v":2000},25,null,{"$f":"A46","v":46}]
[47,null,406,30,50,220000,500,{"$f":"2000","v":2000},30,null,47]
[48,null,506,60,100,260000,600,{"$f":"2000","v":2000},50,null,48]
[49,null,556,110,150,365000,750,{"$f":"2000","v":2000},90,null,49]
[50,null,606,160,210,450000,1000,{"$f":"2000","v":2000},110,null,50]
[51,null,656,220,270,550000,1400,{"$f":"2000","v":2000},125,null,51]
[52,null,656,271,350,550000,1400,{"$f":"2000","v":2000},150]
[53,null,706,351,450,750000,1600,{"$f":"2000","v":2000},230]
[54,null,1006,451,650,1800000,2000,{"$f":"2000","v":2000},400]
[55,null,1006,750,900,1800000,2000,{"$f":"2000","v":2000},600]
[56]
[57]
[58,"Centrifuges - Lime Softening",null,"Lower Limit (lb/hr)","Upper Limit (lb/hr)","Centrifuge Cost ($)","Space Required per Centrifuge (ft2)","Additional Space Required per Station (ft2)","hp",null,"Ref No.",null,null,null,null,null,null,null,"Belt Filter",null,"Lower Limit (gpm)","Upper Limit (gpm)","Centrifuge Cost ($)","Space Required per Belt Filter (ft2)","Additional Space Required per Station (ft2)",null,"Plate and frame filter press",null,"Lower Limit (lb/hr)","Upper Limit (lb/hr)","Centrifuge Cost ($)","Space Required per Filter Press (ft2)","Additional Space Required per Station (ft2)"]
[59,null,"ALDEC 406G2",0,750,220000,500,4500,{"$f":"30+7.5","v":37.5},null,{"$f":"A59","v":59},null,null,null,null,null,null,null,null,"1.0 Meter",0,75,290000,370,4500,null,null,2250,0,1125,200000,350,4500]
[60,null,"ALDEC 506G2",750,1500,260000,600,4500,{"$f":"30+7.5","v":37.5},null,60,null,null,null,null,null,null,null,null,"1.5 Meter",75,110,305000,410,4500,null,null,4500,1125,2250,300000,470,4500]
[61,null,"ALDEC 556G2",1500,2600,365000,750,4500,{"$f":"30+7.5","v":37.5},null,61,null,null,null,null,null,null,null,null,"2.0 Meter",110,150,315000,460,4500,null,null,6750,2250,3375,450000,560,4500]
[62,null,"ALDEC 602G2",2600,3700,450000,1000,4500,{"$f":"50+10","v":60},null,62,null,null,null,null,null,null,null,null,"2.5 Meter",150,200,500000,600,4500,null,null,9000,3375,4500,600000,660,4500]
[63,null,"ALDEC 706G2",3700,6000,750000,1600,4500,{"$f":"50+10","v":60},null,63,null,null,null,null,null,null,null,null,"3.0 Meter",200,250,600000,670,4500,null,null,11250,4500,5625,750000,630,4500]
[64,null,"ALDEC 1006",6000,12000,1500000,2000,4500,{"$f":"100+15","v":115},null,64,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13500,5625,6750,900000,710,4500]
[65]
[66,"Dewatering Building Sizing Assumptions"]
[67]
[68,1,"There is one classifier per centrifuge"]
[69,null,null,"L (ft)","W (ft)","Area (sf)"]
[70,2,"Classifer Area",30,10,{"$f":"D70*E70","v":300}]
[71,3,"Truck Loading Station",40,15,{"$f":"D71*E71","v":600}]
[72]
[73]
[74,null,"Other Areas that have population dependent sizes"]
[75,null,null,"LOW","LOW","LOW","HIGH","HIGH","HIGH"]
[76,5,"Control Rm and Electrical Rm","L (ft)","W (ft)","Area","L (ft)","W (ft)","Area",null,"Truck Loading","# (LOW)","# (HIGH)"]
[77,null,"13k",20,40,{"$f":"D77*E77","v":800},20,40,{"$f":"G77*H77","v":800},null,"13k",2,2]
[78,null,"30k",20,40,800,20,40,800,null,"30k",2,2]
[79,null,"70k",20,40,800,20,40,800,null,"70k",2,2]
[{"$f":"A79+1","v":80},null,"110k",20,50,1000,20,50,1000,null,"110k",2,2]
[81,null,"175k",20,50,1000,20,50,1000,null,"175k",2,2]
[82,null,"265k",20,50,1000,20,50,1000,null,"265k",2,2]
[83,null,"400k",20,60,1200,20,60,1200,null,"400k",3,3]
[84,null,"650k",20,60,1200,20,60,1200,null,"650k",3,3]
[85,null,"1000k",20,60,1200,20,60,1200,null,"1000k",4,4]
[86]
[87,"BW Polymer Costs"]
[88,null,null,"(lb/day)","all",0.39,0.9,2.1,3.3,5.25,7.96,12.01,19.52,30.02]
[89,null,null,null,null,6318.6464951856251,10435.921420497889,17350.694836796356,22755.88124081308,30066.361628210048,38595.185738715714,49546.120747254507,66110.917231652144,100174.60847463549]
[90]
[91,"Cost Multipliers"]
[92,null,"Labor/Installation",0.3,"equipment/item cost",null,null,null,null,null,null,null,null,"Cost Hierarchy"]
[93,null,"Electrical",0.15]
[94,null,"Instrumentation and Controls",0.15,null,null,null,null,null,null,null,null,null,null,"Non-percentage based unit costs"]
[95,null,"Piping",0.1,null,null,null,null,null,null,null,null,null,null,"Excavation"]
[96,null,null,null,null,null,null,null,null,null,null,null,null,null,"Concrete"]
[97,"Cost Scaling Factors",null,null,null,null,null,null,null,null,null,null,null,null,"Equipment"]
[98,null,"Size Scaling Exponent",0.6,null,null,null,null,null,null,null,null,null,null,"Building",null,"Subtotal"]
[99,null,"ENR",7939]
[100,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"C95","v":"Piping"},{"$f":"D95","v":0.1},null,"Piping Cost"]
[101,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Subtotal"]
[102,"General Costs"]
[103,null,"Site Work",0.08,null,null,null,null,null,null,null,null,null,{"$f":"B102","v":"General Costs"},{"$f":"SUM(D103:D105)","v":0.3},null,"General Cost"]
[104,null,"Yard Piping",0.21,null,null,null,null,null,null,null,null,null,null,null,null,"Subtotal"]
[105,null,"Final Grading",0.01]
[106,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"C93","v":"Electrical"},{"$f":"D93","v":0.15},null,"Electrical Cost"]
[107,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"C94","v":"Instrumentation and Controls"},{"$f":"D94","v":0.15},null,"I&C Cost"]
[108,"Project Costs Factors",null,null,null,null,"%",null,null,null,null,null,null,null,null,null,"Subtotal"]
[109,null,"Construction Contingency Costs ",null,null,null,0.25]
[110,null,"Non-Construction Costs ",null,null,null,{"$f":"SUM(G114:G118)","v":0.30000000000000004},null,null,null,null,null,null,{"$f":"C109","v":"Construction Contingency Costs "},{"$f":"G109","v":0.25},null,"Const. Contingency"]
[111,null,"Indirect Construction Costs",null,null,null,{"$f":"G121+G122","v":0.3},null,null,null,null,null,null,null,null,null,"Direct Const. Cost"]
[{"$f":"A111+1","v":112}]
[113,null," Non-construction costs include",null,null,null,null,null,null,null,null,null,null,{"$f":"C111","v":"Indirect Construction Costs"},{"$f":"G111","v":0.3},null,"Indirect Const. Cost"]
[114,null,"Engineering - Preliminary and Final Design Costs",null,null,null,0.1,null,null,null,null,null,null,null,null,null,"Total Construction Cost"]
[115,null,"Provider's Administration and Oversight during Design and Construction (Includes Legal Review)",null,null,null,0.04]
[116,null,"Construction Administration and Inspection Costs - Third Party",null,null,null,0.1,null,null,null,null,null,null,{"$f":"C110","v":"Non-Construction Costs "},{"$f":"G110","v":0.30000000000000004},null,"Non-Construction Costs"]
[117,null,"Permitting/Community Outreach",null,null,null,0.05,null,null,null,null,null,null,null,null,null,"Total Capital Costs"]
[118,null,"Start-Up/Acceptance Testing/Commissioning",null,null,null,0.01]
[119]
[120,null,"Indirect Construction costs include"]
[121,null,"Overhead and Profit",null,null,null,0.25]
[122,null,"Mobilization/Demobilization",null,null,null,0.05]
[123]
[124,null,"Inflation for Present Worth Calculations",null,null,null,0.06]
[125,null,"Period for Present Worth Calculations",null,null,null,20,"years"]
[126]
[127,"O&M Cost Assumptions"]
[128,"O&M Costs consist of labor, disposal, chemical, power and mainteance"]
[129]
[130,"Labor Costs"]
[131,null,"Centrifuge Operator",{"$f":"'O&M input'!D16","v":40000},"$/year"]
[132,null,"Supervisor",{"$f":"'O&M input'!D17","v":55000},"$/year"]
[133,null,"Maintenance Worker",{"$f":"'O&M input'!D18","v":50000},"$/year"]
[134,null,"Multiplier for Burdened Wages",1.7]
[135]
[136,"Disposal Costs"]
[137,null,"Average trip length",{"$f":"'O&M input'!I10","v":50},"mile"]
[138,null,"Trucking cost (truck + operator)",{"$f":"'O&M input'!D20","v":0.25},"$/(mile-ton)"]
[139,null,"Average tipping fee",{"$f":"'O&M input'!D21","v":34.29},"$/ton"]
[140]
[141,"Power Costs"]
[142,null,"Average power cost",{"$f":"'O&M input'!I7","v":0.1225},"$/kWh"]
[143,null,"Power for mixers",38,"hp/MG"]
[{"$f":"A143+1","v":144},null,"Power for Mechanical Sludge Collectors",1,"hp/unit"]
[145]
[146,"Chemical Costs"]
[147,null,"Polymer cost",{"$f":"'O&M input'!D23","v":2.04},"$/lb"]
[148,null,"Sodium Metabisulfite cost",0.37,"$/lb"]
[149]
[150,"Maintenance Costs"]
[151,null,"Maintenance budget",{"$f":"'O&M input'!I12","v":3},"% of capital costs"]
[]
[null,"Carbon Footprint"]
[null,null,1293300000000,"ton-miles","in 2005, per BTS Special Report"]
[null,null,391600000,"metric tons CO2","in 2005, per EPA Inventor of US Greenhouse Gas Emissions and Sinks: 1990-2007"]
[null,null,{"$f":"C155/C154","v":3.0279130905435709E-4},"metric tons CO2/ton mile"]

{"sheet":"MainMenu","index":12,"n_rows":16,"n_cols":7,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,4],[15,1,15,12]]}
[null,"Residual minimization, reuse, and treatment costs"]
[null,"Main Menu"]
[null,"First,  enable the macros when you open this tool"]
[]
[]
[null,null,null,null,null,null,"What would you like to do today?"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Jointly sponsored by Water Research Foundation and U.S. Environmental Protection Agency"]

{"sheet":"Reuse_button","index":13,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Reuse_text","index":14,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Reuse_print","index":15,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Reuse_info","index":16,"n_rows":8,"n_cols":9,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[null,"Beneficial Reuse"]
[null,"Click a button to select a minimization category to investigate:"]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Click a gold button to find information about each method"]

{"sheet":"Reuse_criteria","index":17,"n_rows":24,"n_cols":13,"rows_kept":24,"cut":false,"hidden":false,"merged":[[1,1,1,4],[9,1,9,3],[10,1,10,3],[4,1,4,3],[5,1,5,3],[6,1,6,3],[7,1,7,3],[8,1,8,3],[11,1,11,3],[14,1,14,3],[15,1,15,3],[12,1,12,3],[13,1,13,3]]}
[null,"Beneficial Reuse"]
[null,"Weighting Factors"]
[]
[null,"Criteria",null,null,"Weighting Factor",null,null,null,"Select minimization processes to consider:"]
[null,"Reliability",null,null,0,null,null,null,null,null,null,null,false]
[null,"Flexibility",null,null,0,null,null,null,null,null,null,null,false]
[null,"Permitting and regulatory impacts",null,null,0,null,null,null,null,null,null,null,false]
[null,"Liability",null,null,0,null,null,null,null,null,null,null,false]
[null,"User experience and time in business",null,null,0,null,null,null,null,null,null,null,false]
[null,"Operational complexity",null,null,0,null,null,null,null,null,null,null,false]
[null,"Expandability",null,null,0,null,null,null,null,null,null,null,false]
[null,"On-site land requirements",null,null,0,null,null,null,null,null,null,null,false]
[null,"Compatibility with existing processes",null,null,0,null,null,null,null,null,null,null,false]
[null,"Environmental impacts",null,null,0,null,null,null,null,null,null,null,false]
[null,"Vehicle traffic",null,null,0,null,null,null,null,null,null,null,false]
[null,"Disposal volume",null,null,0,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,true,null,null,null,false]
[]
[]
[null,"Please fill out weighting factors for each criteria on a scale from 0 to 3."]
[null,"0 = Does not apply"]
[null,"1 = Low Importance"]
[null,"2 = Medium Importance"]
[null,"3 = High Importance"]

{"sheet":"Reuse_score","index":18,"n_rows":17,"n_cols":34,"rows_kept":17,"cut":false,"hidden":true,"merged":[[13,1,13,3],[14,1,14,3],[15,1,15,3],[7,1,7,3],[8,1,8,3],[9,1,9,3],[10,1,10,3],[11,1,11,3],[6,1,6,3],[12,1,12,3],[3,1,3,4],[1,1,1,4],[4,1,4,3],[5,1,5,3]]}
[null,"Evaluation of residual minimization techniques"]
[null,"Process score"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Score","Score","Score","Score","Score","Score","Score","Score","Score","Score","Score","Score","Score"]
[null,"Criteria",null,null,null,"Weighting factor","Brick Making","Cement Manufacturing","Turf Farming","Land Application","Land Reclamation","Forest Land","Citrus Grove","Composting","Soil Making","Landfill Cover","Road Subgrade","Nutrient Control","Hydrogen Sulfide Binding",null,null,"Brick Making","Cement Manufact.","Turf Farming","Land Applicat.","Land Reclam.","Forest Land","Citrus Grove","Composting","Soil Making","Landfill Cover","Road Subgrade","Nutrient Control","Hydr. Sulf. Bind."]
[null,"Reliability",null,null,null,{"$f":"Reuse_criteria!E5","v":0},4,3,3,4,2,1,1,2,4,5,3,2,1,null,null,{"$f":"$F5*G5","v":0},{"$f":"$F5*H5","v":0},{"$f":"$F5*I5","v":0},{"$f":"$F5*J5","v":0},{"$f":"$F5*K5","v":0},{"$f":"$F5*L5","v":0},{"$f":"$F5*M5","v":0},{"$f":"$F5*N5","v":0},{"$f":"$F5*O5","v":0},{"$f":"$F5*P5","v":0},{"$f":"$F5*Q5","v":0},{"$f":"$F5*R5","v":0},{"$f":"$F5*S5","v":0}]
[null,"Flexibility",null,null,null,{"$f":"Reuse_criteria!E6","v":0},4,4,2,4,4,1,1,3,2,5,4,3,1,null,null,0,{"$f":"$F6*H6","v":0},{"$f":"$F6*I6","v":0},{"$f":"$F6*J6","v":0},0,0,0,0,0,0,0,0,0]
[null,"Permiting and regulatory impacts",null,null,null,{"$f":"Reuse_criteria!E7","v":0},4,4,4,3,2,1,1,2,4,3,4,3,1,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Liability",null,null,null,{"$f":"Reuse_criteria!E8","v":0},4,4,3,3,2,1,1,2,2,4,4,3,1,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"User experience and time in buisness",null,null,null,{"$f":"Reuse_criteria!E9","v":0},5,5,4,4,3,1,1,3,4,4,4,2,1,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Operational complexity",null,null,null,{"$f":"Reuse_criteria!E10","v":0},3,3,3,4,2,1,1,2,4,5,5,4,1,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Expandability",null,null,null,{"$f":"Reuse_criteria!E11","v":0},3,3,3,4,4,1,1,4,4,3,3,5,1,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"On-site-requirements",null,null,null,{"$f":"Reuse_criteria!E12","v":0},4,4,5,2,3,1,1,4,4,4,3,3,1,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Compatability with existing processes",null,null,null,{"$f":"Reuse_criteria!E13","v":0},4,4,4,5,3,1,1,4,4,5,4,3,1,null,null,0,0,0,{"$f":"$F13*J13","v":0},0,0,0,0,0,0,0,0,0]
[null,"Environmental impacts",null,null,null,{"$f":"Reuse_criteria!E14","v":0},3,3,3,4,5,1,1,4,3,4,3,5,1,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Vehicle traffic",null,null,null,{"$f":"Reuse_criteria!E15","v":0},2,2,2,2,3,1,1,3,2,2,4,2,1,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Disposal volume",null,null,null,{"$f":"Reuse_criteria!E16","v":0},5,5,3,4,5,1,1,4,5,5,5,5,1,null,null,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,null,null,null,null,null,{"$f":"SUM(V5:V16)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]

{"sheet":"Reuse_summary","index":19,"n_rows":17,"n_cols":19,"rows_kept":17,"cut":false,"hidden":false,"merged":[[13,1,13,3],[14,1,14,3],[15,1,15,3],[7,1,7,3],[8,1,8,3],[9,1,9,3],[10,1,10,3],[11,1,11,3],[6,1,6,3],[12,1,12,3],[1,1,1,4],[3,1,3,4],[4,1,4,3],[5,1,5,3]]}
[null,"Beneficial Reuse"]
[null,"Summary"]
[]
[null,"Criteria",null,null,null,"Weighting factor","Brick Making","Cement Manufact.","Turf Farming","Land Applicat.","Land Reclam.","Forest Land","Citrus Grove","Composting","Soil Making","Landfill Cover","Road Subgrade","Nutrient Control","Hydr. Sulf. Bind."]
[null,"Reliability",null,null,null,{"$f":"Reuse_criteria!E5","v":0},{"$f":"Reuse_score!V5","v":0},{"$f":"Reuse_score!W5","v":0},{"$f":"Reuse_score!X5","v":0},{"$f":"Reuse_score!Y5","v":0},{"$f":"Reuse_score!Z5","v":0},{"$f":"Reuse_score!AA5","v":0},{"$f":"Reuse_score!AB5","v":0},{"$f":"Reuse_score!AC5","v":0},{"$f":"Reuse_score!AD5","v":0},{"$f":"Reuse_score!AE5","v":0},{"$f":"Reuse_score!AF5","v":0},{"$f":"Reuse_score!AG5","v":0},{"$f":"Reuse_score!AH5","v":0}]
[null,"Flexibility",null,null,null,{"$f":"Reuse_criteria!E6","v":0},{"$f":"Reuse_score!V6","v":0},{"$f":"Reuse_score!W6","v":0},{"$f":"Reuse_score!X6","v":0},{"$f":"Reuse_score!Y6","v":0},{"$f":"Reuse_score!Z6","v":0},{"$f":"Reuse_score!AA6","v":0},{"$f":"Reuse_score!AB6","v":0},{"$f":"Reuse_score!AC6","v":0},{"$f":"Reuse_score!AD6","v":0},{"$f":"Reuse_score!AE6","v":0},{"$f":"Reuse_score!AF6","v":0},{"$f":"Reuse_score!AG6","v":0},{"$f":"Reuse_score!AH6","v":0}]
[null,"Permitting and regulatory impacts",null,null,null,{"$f":"Reuse_criteria!E7","v":0},{"$f":"Reuse_score!V7","v":0},{"$f":"Reuse_score!W7","v":0},{"$f":"Reuse_score!X7","v":0},{"$f":"Reuse_score!Y7","v":0},{"$f":"Reuse_score!Z7","v":0},{"$f":"Reuse_score!AA7","v":0},{"$f":"Reuse_score!AB7","v":0},{"$f":"Reuse_score!AC7","v":0},{"$f":"Reuse_score!AD7","v":0},{"$f":"Reuse_score!AE7","v":0},{"$f":"Reuse_score!AF7","v":0},{"$f":"Reuse_score!AG7","v":0},{"$f":"Reuse_score!AH7","v":0}]
[null,"Liability",null,null,null,{"$f":"Reuse_criteria!E8","v":0},{"$f":"Reuse_score!V8","v":0},{"$f":"Reuse_score!W8","v":0},{"$f":"Reuse_score!X8","v":0},{"$f":"Reuse_score!Y8","v":0},{"$f":"Reuse_score!Z8","v":0},{"$f":"Reuse_score!AA8","v":0},{"$f":"Reuse_score!AB8","v":0},{"$f":"Reuse_score!AC8","v":0},{"$f":"Reuse_score!AD8","v":0},{"$f":"Reuse_score!AE8","v":0},{"$f":"Reuse_score!AF8","v":0},{"$f":"Reuse_score!AG8","v":0},{"$f":"Reuse_score!AH8","v":0}]
[null,"User experience and time in business",null,null,null,{"$f":"Reuse_criteria!E9","v":0},{"$f":"Reuse_score!V9","v":0},{"$f":"Reuse_score!W9","v":0},{"$f":"Reuse_score!X9","v":0},{"$f":"Reuse_score!Y9","v":0},{"$f":"Reuse_score!Z9","v":0},{"$f":"Reuse_score!AA9","v":0},{"$f":"Reuse_score!AB9","v":0},{"$f":"Reuse_score!AC9","v":0},{"$f":"Reuse_score!AD9","v":0},{"$f":"Reuse_score!AE9","v":0},{"$f":"Reuse_score!AF9","v":0},{"$f":"Reuse_score!AG9","v":0},{"$f":"Reuse_score!AH9","v":0}]
[null,"Operational complexity",null,null,null,{"$f":"Reuse_criteria!E10","v":0},{"$f":"Reuse_score!V10","v":0},{"$f":"Reuse_score!W10","v":0},{"$f":"Reuse_score!X10","v":0},{"$f":"Reuse_score!Y10","v":0},{"$f":"Reuse_score!Z10","v":0},{"$f":"Reuse_score!AA10","v":0},{"$f":"Reuse_score!AB10","v":0},{"$f":"Reuse_score!AC10","v":0},{"$f":"Reuse_score!AD10","v":0},{"$f":"Reuse_score!AE10","v":0},{"$f":"Reuse_score!AF10","v":0},{"$f":"Reuse_score!AG10","v":0},{"$f":"Reuse_score!AH10","v":0}]
[null,"Expandability",null,null,null,{"$f":"Reuse_criteria!E11","v":0},{"$f":"Reuse_score!V11","v":0},{"$f":"Reuse_score!W11","v":0},{"$f":"Reuse_score!X11","v":0},{"$f":"Reuse_score!Y11","v":0},{"$f":"Reuse_score!Z11","v":0},{"$f":"Reuse_score!AA11","v":0},{"$f":"Reuse_score!AB11","v":0},{"$f":"Reuse_score!AC11","v":0},{"$f":"Reuse_score!AD11","v":0},{"$f":"Reuse_score!AE11","v":0},{"$f":"Reuse_score!AF11","v":0},{"$f":"Reuse_score!AG11","v":0},{"$f":"Reuse_score!AH11","v":0}]
[null,"On-site land requirements",null,null,null,{"$f":"Reuse_criteria!E12","v":0},{"$f":"Reuse_score!V12","v":0},{"$f":"Reuse_score!W12","v":0},{"$f":"Reuse_score!X12","v":0},{"$f":"Reuse_score!Y12","v":0},{"$f":"Reuse_score!Z12","v":0},{"$f":"Reuse_score!AA12","v":0},{"$f":"Reuse_score!AB12","v":0},{"$f":"Reuse_score!AC12","v":0},{"$f":"Reuse_score!AD12","v":0},{"$f":"Reuse_score!AE12","v":0},{"$f":"Reuse_score!AF12","v":0},{"$f":"Reuse_score!AG12","v":0},{"$f":"Reuse_score!AH12","v":0}]
[null,"Compatibility with existing processes",null,null,null,{"$f":"Reuse_criteria!E13","v":0},{"$f":"Reuse_score!V13","v":0},{"$f":"Reuse_score!W13","v":0},{"$f":"Reuse_score!X13","v":0},{"$f":"Reuse_score!Y13","v":0},{"$f":"Reuse_score!Z13","v":0},{"$f":"Reuse_score!AA13","v":0},{"$f":"Reuse_score!AB13","v":0},{"$f":"Reuse_score!AC13","v":0},{"$f":"Reuse_score!AD13","v":0},{"$f":"Reuse_score!AE13","v":0},{"$f":"Reuse_score!AF13","v":0},{"$f":"Reuse_score!AG13","v":0},{"$f":"Reuse_score!AH13","v":0}]
[null,"Environmental impacts",null,null,null,{"$f":"Reuse_criteria!E14","v":0},{"$f":"Reuse_score!V14","v":0},{"$f":"Reuse_score!W14","v":0},{"$f":"Reuse_score!X14","v":0},{"$f":"Reuse_score!Y14","v":0},{"$f":"Reuse_score!Z14","v":0},{"$f":"Reuse_score!AA14","v":0},{"$f":"Reuse_score!AB14","v":0},{"$f":"Reuse_score!AC14","v":0},{"$f":"Reuse_score!AD14","v":0},{"$f":"Reuse_score!AE14","v":0},{"$f":"Reuse_score!AF14","v":0},{"$f":"Reuse_score!AG14","v":0},{"$f":"Reuse_score!AH14","v":0}]
[null,"Vehicle traffic",null,null,null,{"$f":"Reuse_criteria!E15","v":0},{"$f":"Reuse_score!V15","v":0},{"$f":"Reuse_score!W15","v":0},{"$f":"Reuse_score!X15","v":0},{"$f":"Reuse_score!Y15","v":0},{"$f":"Reuse_score!Z15","v":0},{"$f":"Reuse_score!AA15","v":0},{"$f":"Reuse_score!AB15","v":0},{"$f":"Reuse_score!AC15","v":0},{"$f":"Reuse_score!AD15","v":0},{"$f":"Reuse_score!AE15","v":0},{"$f":"Reuse_score!AF15","v":0},{"$f":"Reuse_score!AG15","v":0},{"$f":"Reuse_score!AH15","v":0}]
[null,"Disposal volume",null,null,null,{"$f":"Reuse_criteria!E16","v":0},{"$f":"Reuse_score!V16","v":0},{"$f":"Reuse_score!W16","v":0},{"$f":"Reuse_score!X16","v":0},{"$f":"Reuse_score!Y16","v":0},{"$f":"Reuse_score!Z16","v":0},{"$f":"Reuse_score!AA16","v":0},{"$f":"Reuse_score!AB16","v":0},{"$f":"Reuse_score!AC16","v":0},{"$f":"Reuse_score!AD16","v":0},{"$f":"Reuse_score!AE16","v":0},{"$f":"Reuse_score!AF16","v":0},{"$f":"Reuse_score!AG16","v":0},{"$f":"Reuse_score!AH16","v":0}]
[null,null,null,null,null,null,{"$f":"SUM(G5:G16)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]

{"sheet":"Resid_print","index":20,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Resid_info","index":21,"n_rows":9,"n_cols":9,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[null,"Residual minimization"]
[null,"Click a red button to select a minimization category:"]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Click the gold buttons to find information about each method"]

{"sheet":"Resid_button","index":22,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Resid_text","index":23,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Resid_criteria","index":24,"n_rows":24,"n_cols":14,"rows_kept":24,"cut":false,"hidden":false,"merged":[[8,1,8,4],[9,1,9,4],[10,1,10,4],[16,1,16,4],[17,1,17,4],[11,1,11,4],[12,1,12,4],[13,1,13,4],[14,1,14,4],[15,1,15,4],[6,1,6,4],[7,1,7,4],[3,1,3,4],[1,1,1,4],[4,1,4,4],[5,1,5,4]]}
[null,"Residual minimization"]
[null,"Weighting Factors"]
[]
[null,"Criteria",null,null,null,"Weighting Factor",null,null,"Select minimization processes to consider:"]
[null,"Probablility of success",null,null,null,0,null,null,null,null,null,null,false]
[null,"Operational complexity",null,null,null,0,null,null,null,null,null,null,false]
[null,"Ease of implementation",null,null,null,0,null,null,null,null,null,null,false,false]
[null,"Operator time required",null,null,null,0,null,null,null,null,null,null,false,false]
[null,"On-site land requirements",null,null,null,0,null,null,null,null,null,null,false]
[null,"Reliability",null,null,null,0,null,null,null,null,null,null,false]
[null,"Residual volume reduction",null,null,null,0,null,null,null,null,null,null,false]
[null,"Residual mass reduction",null,null,null,0,null,null,null,null,null,null,false]
[null,"Capital costs",null,null,null,0,null,null,null,null,null,null,false]
[null,"O&M cost",null,null,null,0,null,null,null,null,null,null,false]
[null,"Ancillary benefit",null,null,null,0,null,null,null,null,null,null,false]
[null,"Regulatory acceptance",null,null,null,0,null,null,null,null,null,null,false]
[null,"Public acceptance",null,null,null,0,null,null,null,null,null,null,false]
[null,"Impact on finished water quality",null,null,null,0]
[]
[null,"Please fill out weighting factors for each criteria on a scale from 0 to 3."]
[null,"0 = Does not apply"]
[null,"1 = Low Importance"]
[null,"2 = Medium Importance"]
[null,"3 = High Importance"]

{"sheet":"Resid_score","index":25,"n_rows":19,"n_cols":38,"rows_kept":19,"cut":false,"hidden":true,"merged":[[0,1,0,22],[3,1,3,4],[1,1,1,4]]}
[null,"Evaluation of residual minimization techniques"]
[null,"Process score"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Score","Score",null,null,"Score","Score","Score","Score","Score","Score","Score","Score","Score","Score","Score"]
[null,"Criteria",null,null,null,"Weighting factor","Watershed protection","Intake optimization","Onsite pre-sedimentation","Riverbank Filtration","Improved Chemical Control","Changening Softening Goals","Improved Process Performance","Seasonal Direct Filtration","Monitor SFBW Quality","Air/Water Backwash","Optimizing Media","TOC Adsorption","Membrane","Improved Sludge collection","Lime/ Coagulant Recovery",null,null,"Watershed protection","Intake optimization","Onsite pre-sedimentation","Riverbank Filtration","Improved Chemical Control","Changening Softening Goals","Improved Process Performance","Seasonal Direct Filtration","Monitor SFBW Quality","Air/Water Backwash","Optimizing Media","TOC Adsorption","Membrane","Improved Sludge collection","Lime/ Coagulant Recovery"]
[null,"Probability of success",null,null,null,{"$f":"Resid_criteria!F5","v":0},1,2,4,5,3,5,3,5,4,4,4,3,3,5,5,null,null,{"$f":"$F5*G5","v":0},{"$f":"$F5*H5","v":0},{"$f":"$F5*I5","v":0},{"$f":"$F5*J5","v":0},{"$f":"$F5*K5","v":0},{"$f":"$F5*L5","v":0},{"$f":"$F5*M5","v":0},{"$f":"$F5*N5","v":0},{"$f":"$F5*O5","v":0},{"$f":"$F5*P5","v":0},{"$f":"$F5*Q5","v":0},{"$f":"$F5*R5","v":0},{"$f":"$F5*S5","v":0},{"$f":"$F5*T5","v":0},{"$f":"$F5*U5","v":0}]
[null,"Operational complexity",null,null,null,{"$f":"Resid_criteria!F6","v":0},1,5,4,4,5,5,2,2,4,5,5,1,1,5,1,null,null,0,{"$f":"$F6*H6","v":0},{"$f":"$F6*I6","v":0},{"$f":"$F6*J6","v":0},{"$f":"$F6*K6","v":0},0,0,0,0,0,0,0,0,0,0]
[null,"ease of implementation",null,null,null,{"$f":"Resid_criteria!F7","v":0},1,2,2,1,3,4,5,2,5,2,3,1,1,2,1,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Operator time consumption",null,null,null,{"$f":"Resid_criteria!F8","v":0},2,5,3,4,4,5,3,3,5,5,5,2,2,5,1,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"On-site land requirements",null,null,null,{"$f":"Resid_criteria!F9","v":0},5,5,1,1,5,5,5,5,5,5,5,3,4,5,1,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Reliability",null,null,null,{"$f":"Resid_criteria!F10","v":0},2,3,3,4,5,5,5,4,4,3,5,3,1,2,2,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Residual volume reduction",null,null,null,{"$f":"Resid_criteria!F11","v":0},3,3,3,5,2,3,2,3,3,3,3,2,1,3,5,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Residual mass reduction",null,null,null,{"$f":"Resid_criteria!F12","v":0},3,3,3,4,2,3,2,3,1,1,1,3,3,1,5,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Capital costs",null,null,null,{"$f":"Resid_criteria!F13","v":0},3,2,1,1,4,5,5,5,4,3,4,1,1,2,1,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"O&M Cost",null,null,null,{"$f":"Resid_criteria!F14","v":0},2,5,4,2,5,5,4,5,5,4,5,2,1,4,5,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Ancillary benefit",null,null,null,{"$f":"Resid_criteria!F15","v":0},5,3,2,5,2,1,4,2,2,2,2,4,4,3,2,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Regulatory acceptance",null,null,null,{"$f":"Resid_criteria!F16","v":0},5,3,5,4,5,3,5,2,5,5,5,4,4,5,2,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Public acceptance",null,null,null,{"$f":"Resid_criteria!F17","v":0},3,5,4,5,5,2,5,5,5,5,5,5,5,5,4,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Impact on finished water quality",null,null,null,{"$f":"Resid_criteria!F18","v":0},4,4,4,5,3,1,4,2,3,3,3,5,5,3,3,null,null,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,null,null,null,null,null,null,null,{"$f":"SUM(X5:X18)","v":0},{"$f":"SUM(Y5:Y18)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]

{"sheet":"Resid_summary","index":26,"n_rows":19,"n_cols":21,"rows_kept":19,"cut":false,"hidden":false,"merged":[[8,1,8,4],[9,1,9,4],[10,1,10,4],[16,1,16,4],[17,1,17,4],[11,1,11,4],[12,1,12,4],[13,1,13,4],[14,1,14,4],[15,1,15,4],[6,1,6,4],[7,1,7,4],[1,1,1,4],[3,1,3,4],[4,1,4,4],[5,1,5,4]]}
[null,"Residual minimization"]
[null,"Summary"]
[]
[null,"Criteria",null,null,null,"Weighting factor","Watershed protection","Intake optimiz.","Onsite Pre-Sediment.","Riverbank Filtration","Improved Chemical Control","Changening Softening Goals","Improved Process Perform.","Seasonal Direct Filtration","Monitor SFBW Quality","Air/Water Backwash","Optimizing Media","TOC Adsorption","Membrane","Improved Sludge collection","Lime/ Coagulant Recovery"]
[null,"Probablility of success",null,null,null,{"$f":"Resid_criteria!F5","v":0},{"$f":"Resid_score!$F5*Resid_score!G5","v":0},{"$f":"Resid_score!$F5*Resid_score!H5","v":0},{"$f":"Resid_score!$F5*Resid_score!I5","v":0},{"$f":"Resid_score!$F5*Resid_score!J5","v":0},{"$f":"Resid_score!$F5*Resid_score!K5","v":0},{"$f":"Resid_score!$F5*Resid_score!L5","v":0},{"$f":"Resid_score!$F5*Resid_score!M5","v":0},{"$f":"Resid_score!$F5*Resid_score!N5","v":0},{"$f":"Resid_score!$F5*Resid_score!O5","v":0},{"$f":"Resid_score!$F5*Resid_score!P5","v":0},{"$f":"Resid_score!$F5*Resid_score!Q5","v":0},{"$f":"Resid_score!$F5*Resid_score!R5","v":0},{"$f":"Resid_score!$F5*Resid_score!S5","v":0},{"$f":"Resid_score!$F5*Resid_score!T5","v":0},{"$f":"Resid_score!$F5*Resid_score!U5","v":0}]
[null,"Operational complexity",null,null,null,{"$f":"Resid_criteria!F6","v":0},{"$f":"Resid_score!$F6*Resid_score!G6","v":0},{"$f":"Resid_score!$F6*Resid_score!H6","v":0},{"$f":"Resid_score!$F6*Resid_score!I6","v":0},{"$f":"Resid_score!$F6*Resid_score!J6","v":0},{"$f":"Resid_score!$F6*Resid_score!K6","v":0},{"$f":"Resid_score!$F6*Resid_score!L6","v":0},{"$f":"Resid_score!$F6*Resid_score!M6","v":0},{"$f":"Resid_score!$F6*Resid_score!N6","v":0},{"$f":"Resid_score!$F6*Resid_score!O6","v":0},{"$f":"Resid_score!$F6*Resid_score!P6","v":0},{"$f":"Resid_score!$F6*Resid_score!Q6","v":0},{"$f":"Resid_score!$F6*Resid_score!R6","v":0},{"$f":"Resid_score!$F6*Resid_score!S6","v":0},{"$f":"Resid_score!$F6*Resid_score!T6","v":0},{"$f":"Resid_score!$F6*Resid_score!U6","v":0}]
[null,"Ease of implementation",null,null,null,{"$f":"Resid_criteria!F7","v":0},{"$f":"Resid_score!$F7*Resid_score!G7","v":0},{"$f":"Resid_score!$F7*Resid_score!H7","v":0},{"$f":"Resid_score!$F7*Resid_score!I7","v":0},{"$f":"Resid_score!$F7*Resid_score!J7","v":0},{"$f":"Resid_score!$F7*Resid_score!K7","v":0},{"$f":"Resid_score!$F7*Resid_score!L7","v":0},{"$f":"Resid_score!$F7*Resid_score!M7","v":0},{"$f":"Resid_score!$F7*Resid_score!N7","v":0},{"$f":"Resid_score!$F7*Resid_score!O7","v":0},{"$f":"Resid_score!$F7*Resid_score!P7","v":0},{"$f":"Resid_score!$F7*Resid_score!Q7","v":0},{"$f":"Resid_score!$F7*Resid_score!R7","v":0},{"$f":"Resid_score!$F7*Resid_score!S7","v":0},{"$f":"Resid_score!$F7*Resid_score!T7","v":0},{"$f":"Resid_score!$F7*Resid_score!U7","v":0}]
[null,"Operator time required",null,null,null,{"$f":"Resid_criteria!F8","v":0},{"$f":"Resid_score!$F8*Resid_score!G8","v":0},{"$f":"Resid_score!$F8*Resid_score!H8","v":0},{"$f":"Resid_score!$F8*Resid_score!I8","v":0},{"$f":"Resid_score!$F8*Resid_score!J8","v":0},{"$f":"Resid_score!$F8*Resid_score!K8","v":0},{"$f":"Resid_score!$F8*Resid_score!L8","v":0},{"$f":"Resid_score!$F8*Resid_score!M8","v":0},{"$f":"Resid_score!$F8*Resid_score!N8","v":0},{"$f":"Resid_score!$F8*Resid_score!O8","v":0},{"$f":"Resid_score!$F8*Resid_score!P8","v":0},{"$f":"Resid_score!$F8*Resid_score!Q8","v":0},{"$f":"Resid_score!$F8*Resid_score!R8","v":0},{"$f":"Resid_score!$F8*Resid_score!S8","v":0},{"$f":"Resid_score!$F8*Resid_score!T8","v":0},{"$f":"Resid_score!$F8*Resid_score!U8","v":0}]
[null,"On-site land requirements",null,null,null,{"$f":"Resid_criteria!F9","v":0},{"$f":"Resid_score!$F9*Resid_score!G9","v":0},{"$f":"Resid_score!$F9*Resid_score!H9","v":0},{"$f":"Resid_score!$F9*Resid_score!I9","v":0},{"$f":"Resid_score!$F9*Resid_score!J9","v":0},{"$f":"Resid_score!$F9*Resid_score!K9","v":0},{"$f":"Resid_score!$F9*Resid_score!L9","v":0},{"$f":"Resid_score!$F9*Resid_score!M9","v":0},{"$f":"Resid_score!$F9*Resid_score!N9","v":0},{"$f":"Resid_score!$F9*Resid_score!O9","v":0},{"$f":"Resid_score!$F9*Resid_score!P9","v":0},{"$f":"Resid_score!$F9*Resid_score!Q9","v":0},{"$f":"Resid_score!$F9*Resid_score!R9","v":0},{"$f":"Resid_score!$F9*Resid_score!S9","v":0},{"$f":"Resid_score!$F9*Resid_score!T9","v":0},{"$f":"Resid_score!$F9*Resid_score!U9","v":0}]
[null,"Reliability",null,null,null,{"$f":"Resid_criteria!F10","v":0},{"$f":"Resid_score!$F10*Resid_score!G10","v":0},{"$f":"Resid_score!$F10*Resid_score!H10","v":0},{"$f":"Resid_score!$F10*Resid_score!I10","v":0},{"$f":"Resid_score!$F10*Resid_score!J10","v":0},{"$f":"Resid_score!$F10*Resid_score!K10","v":0},{"$f":"Resid_score!$F10*Resid_score!L10","v":0},{"$f":"Resid_score!$F10*Resid_score!M10","v":0},{"$f":"Resid_score!$F10*Resid_score!N10","v":0},{"$f":"Resid_score!$F10*Resid_score!O10","v":0},{"$f":"Resid_score!$F10*Resid_score!P10","v":0},{"$f":"Resid_score!$F10*Resid_score!Q10","v":0},{"$f":"Resid_score!$F10*Resid_score!R10","v":0},{"$f":"Resid_score!$F10*Resid_score!S10","v":0},{"$f":"Resid_score!$F10*Resid_score!T10","v":0},{"$f":"Resid_score!$F10*Resid_score!U10","v":0}]
[null,"Residual volume reduction",null,null,null,{"$f":"Resid_criteria!F11","v":0},{"$f":"Resid_score!$F11*Resid_score!G11","v":0},{"$f":"Resid_score!$F11*Resid_score!H11","v":0},{"$f":"Resid_score!$F11*Resid_score!I11","v":0},{"$f":"Resid_score!$F11*Resid_score!J11","v":0},{"$f":"Resid_score!$F11*Resid_score!K11","v":0},{"$f":"Resid_score!$F11*Resid_score!L11","v":0},{"$f":"Resid_score!$F11*Resid_score!M11","v":0},{"$f":"Resid_score!$F11*Resid_score!N11","v":0},{"$f":"Resid_score!$F11*Resid_score!O11","v":0},{"$f":"Resid_score!$F11*Resid_score!P11","v":0},{"$f":"Resid_score!$F11*Resid_score!Q11","v":0},{"$f":"Resid_score!$F11*Resid_score!R11","v":0},{"$f":"Resid_score!$F11*Resid_score!S11","v":0},{"$f":"Resid_score!$F11*Resid_score!T11","v":0},{"$f":"Resid_score!$F11*Resid_score!U11","v":0}]
[null,"Residual mass reduction",null,null,null,{"$f":"Resid_criteria!F12","v":0},{"$f":"Resid_score!$F12*Resid_score!G12","v":0},{"$f":"Resid_score!$F12*Resid_score!H12","v":0},{"$f":"Resid_score!$F12*Resid_score!I12","v":0},{"$f":"Resid_score!$F12*Resid_score!J12","v":0},{"$f":"Resid_score!$F12*Resid_score!K12","v":0},{"$f":"Resid_score!$F12*Resid_score!L12","v":0},{"$f":"Resid_score!$F12*Resid_score!M12","v":0},{"$f":"Resid_score!$F12*Resid_score!N12","v":0},{"$f":"Resid_score!$F12*Resid_score!O12","v":0},{"$f":"Resid_score!$F12*Resid_score!P12","v":0},{"$f":"Resid_score!$F12*Resid_score!Q12","v":0},{"$f":"Resid_score!$F12*Resid_score!R12","v":0},{"$f":"Resid_score!$F12*Resid_score!S12","v":0},{"$f":"Resid_score!$F12*Resid_score!T12","v":0},{"$f":"Resid_score!$F12*Resid_score!U12","v":0}]
[null,"Capital costs",null,null,null,{"$f":"Resid_criteria!F13","v":0},{"$f":"Resid_score!$F13*Resid_score!G13","v":0},{"$f":"Resid_score!$F13*Resid_score!H13","v":0},{"$f":"Resid_score!$F13*Resid_score!I13","v":0},{"$f":"Resid_score!$F13*Resid_score!J13","v":0},{"$f":"Resid_score!$F13*Resid_score!K13","v":0},{"$f":"Resid_score!$F13*Resid_score!L13","v":0},{"$f":"Resid_score!$F13*Resid_score!M13","v":0},{"$f":"Resid_score!$F13*Resid_score!N13","v":0},{"$f":"Resid_score!$F13*Resid_score!O13","v":0},{"$f":"Resid_score!$F13*Resid_score!P13","v":0},{"$f":"Resid_score!$F13*Resid_score!Q13","v":0},{"$f":"Resid_score!$F13*Resid_score!R13","v":0},{"$f":"Resid_score!$F13*Resid_score!S13","v":0},{"$f":"Resid_score!$F13*Resid_score!T13","v":0},{"$f":"Resid_score!$F13*Resid_score!U13","v":0}]
[null,"O&M cost",null,null,null,{"$f":"Resid_criteria!F14","v":0},{"$f":"Resid_score!$F14*Resid_score!G14","v":0},{"$f":"Resid_score!$F14*Resid_score!H14","v":0},{"$f":"Resid_score!$F14*Resid_score!I14","v":0},{"$f":"Resid_score!$F14*Resid_score!J14","v":0},{"$f":"Resid_score!$F14*Resid_score!K14","v":0},{"$f":"Resid_score!$F14*Resid_score!L14","v":0},{"$f":"Resid_score!$F14*Resid_score!M14","v":0},{"$f":"Resid_score!$F14*Resid_score!N14","v":0},{"$f":"Resid_score!$F14*Resid_score!O14","v":0},{"$f":"Resid_score!$F14*Resid_score!P14","v":0},{"$f":"Resid_score!$F14*Resid_score!Q14","v":0},{"$f":"Resid_score!$F14*Resid_score!R14","v":0},{"$f":"Resid_score!$F14*Resid_score!S14","v":0},{"$f":"Resid_score!$F14*Resid_score!T14","v":0},{"$f":"Resid_score!$F14*Resid_score!U14","v":0}]
[null,"Ancillary benefit",null,null,null,{"$f":"Resid_criteria!F15","v":0},{"$f":"Resid_score!$F15*Resid_score!G15","v":0},{"$f":"Resid_score!$F15*Resid_score!H15","v":0},{"$f":"Resid_score!$F15*Resid_score!I15","v":0},{"$f":"Resid_score!$F15*Resid_score!J15","v":0},{"$f":"Resid_score!$F15*Resid_score!K15","v":0},{"$f":"Resid_score!$F15*Resid_score!L15","v":0},{"$f":"Resid_score!$F15*Resid_score!M15","v":0},{"$f":"Resid_score!$F15*Resid_score!N15","v":0},{"$f":"Resid_score!$F15*Resid_score!O15","v":0},{"$f":"Resid_score!$F15*Resid_score!P15","v":0},{"$f":"Resid_score!$F15*Resid_score!Q15","v":0},{"$f":"Resid_score!$F15*Resid_score!R15","v":0},{"$f":"Resid_score!$F15*Resid_score!S15","v":0},{"$f":"Resid_score!$F15*Resid_score!T15","v":0},{"$f":"Resid_score!$F15*Resid_score!U15","v":0}]
[null,"Regulatory acceptance",null,null,null,{"$f":"Resid_criteria!F16","v":0},{"$f":"Resid_score!$F16*Resid_score!G16","v":0},{"$f":"Resid_score!$F16*Resid_score!H16","v":0},{"$f":"Resid_score!$F16*Resid_score!I16","v":0},{"$f":"Resid_score!$F16*Resid_score!J16","v":0},{"$f":"Resid_score!$F16*Resid_score!K16","v":0},{"$f":"Resid_score!$F16*Resid_score!L16","v":0},{"$f":"Resid_score!$F16*Resid_score!M16","v":0},{"$f":"Resid_score!$F16*Resid_score!N16","v":0},{"$f":"Resid_score!$F16*Resid_score!O16","v":0},{"$f":"Resid_score!$F16*Resid_score!P16","v":0},{"$f":"Resid_score!$F16*Resid_score!Q16","v":0},{"$f":"Resid_score!$F16*Resid_score!R16","v":0},{"$f":"Resid_score!$F16*Resid_score!S16","v":0},{"$f":"Resid_score!$F16*Resid_score!T16","v":0},{"$f":"Resid_score!$F16*Resid_score!U16","v":0}]
[null,"Public acceptance",null,null,null,{"$f":"Resid_criteria!F17","v":0},{"$f":"Resid_score!$F17*Resid_score!G17","v":0},{"$f":"Resid_score!$F17*Resid_score!H17","v":0},{"$f":"Resid_score!$F17*Resid_score!I17","v":0},{"$f":"Resid_score!$F17*Resid_score!J17","v":0},{"$f":"Resid_score!$F17*Resid_score!K17","v":0},{"$f":"Resid_score!$F17*Resid_score!L17","v":0},{"$f":"Resid_score!$F17*Resid_score!M17","v":0},{"$f":"Resid_score!$F17*Resid_score!N17","v":0},{"$f":"Resid_score!$F17*Resid_score!O17","v":0},{"$f":"Resid_score!$F17*Resid_score!P17","v":0},{"$f":"Resid_score!$F17*Resid_score!Q17","v":0},{"$f":"Resid_score!$F17*Resid_score!R17","v":0},{"$f":"Resid_score!$F17*Resid_score!S17","v":0},{"$f":"Resid_score!$F17*Resid_score!T17","v":0},{"$f":"Resid_score!$F17*Resid_score!U17","v":0}]
[null,"Impact on finished water quality",null,null,null,{"$f":"Resid_criteria!F18","v":0},{"$f":"Resid_score!$F18*Resid_score!G18","v":0},{"$f":"Resid_score!$F18*Resid_score!H18","v":0},{"$f":"Resid_score!$F18*Resid_score!I18","v":0},{"$f":"Resid_score!$F18*Resid_score!J18","v":0},{"$f":"Resid_score!$F18*Resid_score!K18","v":0},{"$f":"Resid_score!$F18*Resid_score!L18","v":0},{"$f":"Resid_score!$F18*Resid_score!M18","v":0},{"$f":"Resid_score!$F18*Resid_score!N18","v":0},{"$f":"Resid_score!$F18*Resid_score!O18","v":0},{"$f":"Resid_score!$F18*Resid_score!P18","v":0},{"$f":"Resid_score!$F18*Resid_score!Q18","v":0},{"$f":"Resid_score!$F18*Resid_score!R18","v":0},{"$f":"Resid_score!$F18*Resid_score!S18","v":0},{"$f":"Resid_score!$F18*Resid_score!T18","v":0},{"$f":"Resid_score!$F18*Resid_score!U18","v":0}]
[null,null,null,null,null,"Sum of weighted score:",{"$f":"SUM(G5:G18)","v":0},{"$f":"SUM(H5:H18)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(U5:U18)","v":0}]