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

{"sheet":"Scenario Tool","index":0,"n_rows":38,"n_cols":28,"rows_kept":38,"cut":false,"hidden":false,"merged":[[11,2,11,5],[11,9,11,10],[5,11,5,12],[5,3,5,5],[9,11,10,12],[2,2,3,2],[2,8,3,9],[2,10,3,12],[2,3,3,6],[6,11,7,12],[8,11,8,12],[6,3,6,5],[9,3,9,5],[7,3,7,5],[8,3,8,5],[18,11,19,11],[34,12,35,12],[12,12,13,12],[15,11,16,11],[14,12,19,12],[12,11,13,11],[25,12,28,12],[37,12,38,12],[37,10,38,11],[34,11,35,11],[37,2,38,3],[37,4,38,5],[37,6,38,6],[37,7,38,7],[37,8,38,9]]}
[]
[]
[null,null,"Project Name ",null,null,null,null,null,"Scenario Name "]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"A"]
[null,null,"Scenario","Description",null,null,"Runoff Vol","Vol Reduction","Goal","% Complete",null,"Design Rainfall Depth",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"B"]
[null,null,"Baseline",null,null,null,null,{"$f":"G38","v":0},"-","-",null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"C"]
[null,null,"Scenario #1",null,null,null,null,{"$f":"H7","v":0},{"$f":"IF(L10>0,((G8-G7)*43560*7.5/L10),0)","v":0},{"$f":"IF(G8=\"\",\"\",H7/(G8-G7))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"D"]
[null,null,"Scenario #2",null,null,null,null,{"$f":"H8","v":0},{"$f":"IF(L10>0,((G9-G7)*43560*7.5/L10),0)","v":0},{"$f":"IF(G9=\"\",\"\",H8/(G9-G7))","v":""},null,"Watershed Area"]
[null,null,"Scenario #3",null,null,null,null,{"$f":"H9","v":0},{"$f":"IF(L10>0,((G10-G7)*43560*7.5/L10),0)","v":0},null,null,0]
[]
[null,null,"Structural BMP Details",null,null,null,null,null,null,"Non Structural BMP Details"]
[null,null,"BMP Type","Soil Type","#","Avg Storage Volume","Total Volume Reduction","Est Cost",null,null,null,"Volume Reduction","Estimated Cost"]
[null,null,null,null,null,null,{"$f":"IF(C14=\"\",\"\",ROUND(F14*E14*VLOOKUP(C14,Volume,AB15),0))","v":""},{"$f":"IF(C14=\"\",\"\",E14*F14*VLOOKUP(C14,Costs,2))","v":""},null,"Downspout Disconnection"]
[null,null,null,null,null,null,"","",null,"Over A & B Soils:",null,null,{"$f":"(K16+K19)*VLOOKUP(\"Downspout Disconnection\",Costs,2)","v":0},null,null,"DCIA",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D14=\"A\",2,IF(D14=\"B\",3,IF(D14=\"C\",4,IF(D14=\"D\",5,0))))","v":0}]
[null,null,null,null,null,null,"","",null,"# of Downspouts",0,{"$f":"ROUND(S17*VLOOKUP(\"Downspout Disconnection\",Volume,2),0)","v":0},null,null,null,"CN","S","Q*","Vol (cf)",null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,"","",null,"Avg Roof Area per DS",0,null,null,null,null,98,{"$f":"(1000/P17)-10","v":0.20408163265306101},{"$f":"((L7-0.2*Q17)^2)/(L7+0.8*Q17)","v":1.0204081632653052E-2},{"$f":"(R17/12)*(K16*K17)","v":0},null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,"","",null,"Over C & D Soils:",null,null,null,null,null,98,{"$f":"(1000/P18)-10","v":0.20408163265306101},{"$f":"R17","v":1.0204081632653052E-2},{"$f":"(R18/12)*(K19*K20)","v":0},null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,"","",null,"# of Downspouts",0,{"$f":"ROUND(S18*VLOOKUP(\"downspout disconnection\",Volume,4),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,"","",null,"Avg Roof Area per DS",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,"","",null,"Green Roof Conversions",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,"","",null,"Roof Area",0,{"$f":"ROUND(P25,0)","v":0},{"$f":"K23*VLOOKUP(\"Green Roof\",Costs,2)","v":0},null,null,"Green Roof",null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,"","",null,null,null,null,null,null,null,"Vol Reduction ","CN","S","Q*","Vol (cf)",null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,"","",null,"Impervious Area Removal",null,null,null,null,null,{"$f":"T26-T25","v":0},85,{"$f":"(1000/Q25)-10","v":1.764705882352942},{"$f":"((L7-0.2*R25)^2)/(L7+0.8*R25)","v":8.8235294117647106E-2},{"$f":"(S25/12)*K23","v":0},null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,"","",null,"Over A Soils",0,{"$f":"ROUND(X29-T29,0)","v":0},{"$f":"SUM(K26:K29)*VLOOKUP(\"Impervious area removal\",Costs, 2)","v":0},null,null,null,98,{"$f":"(1000/Q26)-10","v":0.20408163265306101},{"$f":"((L7-0.2*R26)^2)/(L7+0.8*R26)","v":1.0204081632653052E-2},{"$f":"(S26/12)*K23","v":0},null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,"","",null,"Over B Soils",0,{"$f":"ROUND(X30-T30,0)","v":0},null,null,null,"Imp Area",null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,"","",null,"Over C Soils",0,{"$f":"ROUND(X31-T31,0)","v":0},null,null,null,"Vol Reduction ","CN","S","Q*","Vol (cf)","CN","S","Q*","Vol (cf)",null,null,null,0]
[null,null,null,null,null,null,"","",null,"Over D Soils",0,{"$f":"ROUND(X32-T32,0)","v":0},null,null,null,{"$f":"X29-T29","v":0},39,{"$f":"(1000/Q29)-10","v":15.641025641025642},{"$f":"((L$7-0.2*R29)^2)/(L$7+0.8*R29)","v":0.78205128205128227},{"$f":"(S29/12)*K26","v":0},98,{"$f":"(1000/U29)-10","v":0.20408163265306101},{"$f":"((L$7-0.2*V29)^2)/(L$7+0.8*V29)","v":1.0204081632653052E-2},{"$f":"(W29/12)*K26","v":0},null,null,null,0]
[null,null,null,null,null,null,"","",null,null,null,null,null,null,null,{"$f":"X30-T30","v":0},61,{"$f":"(1000/Q30)-10","v":6.3934426229508183},{"$f":"((L$7-0.2*R30)^2)/(L$7+0.8*R30)","v":0.31967213114754095},{"$f":"(S30/12)*K27","v":0},98,{"$f":"(1000/U30)-10","v":0.20408163265306101},{"$f":"((L$7-0.2*V30)^2)/(L$7+0.8*V30)","v":1.0204081632653052E-2},{"$f":"(W30/12)*K27","v":0},null,null,null,0]
[null,null,null,null,null,null,"","",null,"Stream Restoration",null,null,null,null,null,{"$f":"X31-T31","v":0},74,{"$f":"(1000/Q31)-10","v":3.513513513513514},{"$f":"((L$7-0.2*R31)^2)/(L$7+0.8*R31)","v":0.17567567567567571},{"$f":"(S31/12)*K28","v":0},98,{"$f":"(1000/U31)-10","v":0.20408163265306101},{"$f":"((L$7-0.2*V31)^2)/(L$7+0.8*V31)","v":1.0204081632653052E-2},{"$f":"(W31/12)*K28","v":0},null,null,null,0]
[null,null,null,null,null,null,"","",null,"New Floodplain Area",0,{"$f":"ROUND(K32*0.2/12,0)","v":0},{"$f":"K32*VLOOKUP(\"Stream Restoration\",Costs,2)","v":0},null,null,{"$f":"X32-T32","v":0},80,{"$f":"(1000/Q32)-10","v":2.5},{"$f":"((L$7-0.2*R32)^2)/(L$7+0.8*R32)","v":0.125},{"$f":"(S32/12)*K29","v":0},98,{"$f":"(1000/U32)-10","v":0.20408163265306101},{"$f":"((L$7-0.2*V32)^2)/(L$7+0.8*V32)","v":1.0204081632653052E-2},{"$f":"(W32/12)*K29","v":0},null,null,null,0]
[null,null,null,null,null,null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,"","",null,"Tree Planting"]
[null,null,null,null,null,null,"","",null,"# of Trees",0,{"$f":"ROUND(K35*((K36/2)^2*3.14)*(0.1/12),0)","v":0},{"$f":"K35*VLOOKUP(\"tree planting\",Costs,2)","v":0}]
[null,null,null,null,null,null,"","",null,"Avg Canopy Diameter",0]
[]
[null,null,"Total Volume Removed",null,{"$f":"SUM(G14:G36)+L16+L19+L23+SUM(L26:L29)+L32+L35","v":0},null,{"$f":"E38/43560","v":0},{"$f":"IF(E38>0,E38/L10,0)","v":0},{"$f":"H38*7.5/43560","v":0},null,"Estimated Cost =",null,{"$f":"M26+M23+M15+SUM(H14:H36)+M32+M35","v":0}]

{"sheet":"References","index":1,"n_rows":56,"n_cols":7,"rows_kept":56,"cut":false,"hidden":false,"merged":[[2,2,3,2],[2,3,3,6],[26,2,27,6],[28,2,28,6]]}
[]
[]
[null,null,"Project Name ",{"$f":"'Scenario Tool'!D3","v":0}]
[]
[]
[null,null,"BMP Volume Reduction Credits"]
[null,null,"Soil Type","A","B","C","D"]
[null,null,"Bioretention",1.49,1.1200000000000001,0.97,0.89999999999999991]
[null,null,"Bioretention w/ IWS",1.9,1.7,1.33,1.0900000000000001]
[null,null,"Blue Roof",0.05,0.05,0.05,0.05]
[null,null,"Closed Sand Filter",0.1,0.1,0.1,0.1]
[null,null,"Constructed Wetland",0.25,0.2,0.15,0.1]
[null,null,"Downspout Disconnection",0.5,{"$f":"D13","v":0.5},0.35,{"$f":"F13","v":0.35}]
[null,null,"Dry Detention",0.2,0.1,0.05,0]
[null,null,"Grass Swale",0.4,0.3,0.1,0.05]
[null,null,"Infiltration Device",1.5,1.4,1.3,1.2]
[null,null,"Open Sand Filter",0.30000000000000004,0.2,0.2,0.15000000000000002]
[null,null,"Permeable Pavement (Detention)*",0.2,0.2,0.2,0.2]
[null,null,"Permeable Pavement (Infiltration)*",1.5,1.4,1.3,1.2]
[null,null,"Rainwater Harvesting",1,1,1,1]
[null,null,"Wet Detention",0.15,0.1,0.05,0.05]
[null,null,"ZZ User Defined"]
[null,null,"ZZ User Defined"]
[null,null,"ZZ User Defined"]
[null,null,"ZZ User Defined"]
[]
[null,null,"Volume Reduction expressed as a percentage of available surface storage volume below overflow structure"]
[]
[null,null,"*Note: Storage Volume in gravel layer below pavement"]
[]
[]
[null,null,"BMP Construction Cost Data"]
[null,null,"Soil Type","$","Unit"]
[null,null,"Bioretention",0,"cf"]
[null,null,"Bioretention w/ IWS",0,"cf"]
[null,null,"Blue Roof",0,"cf"]
[null,null,"Closed Sand Filter",0,"cf"]
[null,null,"Constructed Wetland",0,"cf"]
[null,null,"Downspout Disconnection",0,"ea"]
[null,null,"Dry Detention",0,"cf"]
[null,null,"Engineered Filter Strip",0,"ea"]
[null,null,"Grass Swale",0,"cf"]
[null,null,"Green Roof",0,"sf"]
[null,null,"Impervious Area Removal",0,"sf"]
[null,null,"Infiltration Device",0,"cf"]
[null,null,"Open Sand Filter",0,"cf"]
[null,null,"Permeable Pavement (Detention)",0,"cf"]
[null,null,"Permeable Pavement (Infiltration)",0,"cf"]
[null,null,"Rainwater Harvesting",0,"cf"]
[null,null,"Stream Restoration",0,"sf"]
[null,null,"Tree Planting",0,"ea"]
[null,null,"Wet Detention",0,"cf"]
[null,null,"ZZ User Defined",0]
[null,null,"ZZ User Defined",0]
[null,null,"ZZ User Defined",0]
[null,null,"ZZ User Defined",0]