{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["FILLABLE FORM","Sheet1","DATA ENTRY SHEET","DATA","PEAK Q VS DA","VOL VS DA","PEAK Q VS DA VS VOL DIFF-2","DA VS VOL DIFF","%IP VS VOL DIFF TRENDLINES"],"not_rendered":{"charts":12,"images":1,"macros":1,"external_links":0,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[{"sheet":"PEAK Q VS DA","index":4,"reason":"not_a_worksheet"},{"sheet":"VOL VS DA","index":5,"reason":"not_a_worksheet"},{"sheet":"PEAK Q VS DA VS VOL DIFF-2","index":6,"reason":"not_a_worksheet"},{"sheet":"DA VS VOL DIFF","index":7,"reason":"not_a_worksheet"},{"sheet":"%IP VS VOL DIFF TRENDLINES","index":8,"reason":"not_a_worksheet"}],"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":"FILLABLE FORM","index":0,"n_rows":31,"n_cols":8,"rows_kept":31,"cut":false,"hidden":false,"merged":[[29,7,30,15],[22,0,22,2],[23,0,23,2],[24,0,24,2],[0,1,0,4],[1,1,1,4],[6,7,7,15],[18,7,20,15],[5,7,5,15],[1,7,4,15],[21,0,21,2],[24,7,25,15],[21,7,21,15],[10,7,10,15],[8,7,9,15],[16,7,17,15]]}
[null,"North Hudson Sewerage Authority",null,null,null,null,null,"Introduction: "]
[null,"Stormwater Storage Requrirements",null,null,null,null,null,"This calculator is the NHSA's stormwater detention requirements for the basic design of a stormwater storage system with connection to a downstream outlet control structure. The output includes the stormwater storage and the OCS maximum primary orifice size.    The owner's engineer is responsible for meeting any state permitting requirements in addition to these requirements.  "]
[]
[]
["A) Total Site Area",10000,"(Square Feet)"]
[null,null,null,null,null,null,null,"This tool is designed for sites less than 1 acre in area.  If the site area is greater than 1 acre,  contact  NHSA to determine the stormwater control requirements.  If the site is greater than 1 acre, this tool in not applicable."]
["B) Impervious Site Area",10000,"(Square Feet)",null,null,null,null,"The owner's Engineer shall determine the height of a control structure emergency overflow weir and is responsible certifying the Engineering Plan."]
[{"$f":"IF(B7>B5,\"Impervious Areas Exceed Total Site Area, Calculations May Be Invalid\",\"\")","v":""}]
["Green Infrastructure (GSI) Credits:",null,null,null,null,null,null,"If the site has greater than 10,000 square feet in area, an automatic valve is required.  Contact NHSA for additional information. "]
[]
["GSI Type","GSI Area (Square Feet)","% Credit","Impervious Area Deductions (Square Feet)"]
["Porous Pavement",null,{"$f":"VLOOKUP(A12,DATA!A70:B75,2,0)","v":0.25},{"$f":"IF(B12=\"\",\"\",B12*C12)","v":""},null,null,null,"Fillable Form Instructions"]
["Green Roof",null,{"$f":"VLOOKUP(A13,DATA!A71:B76,2,0)","v":0.5},{"$f":"IF(B13=\"\",\"\",B13*C13)","v":""}]
["Blue Roof",null,{"$f":"VLOOKUP(A14,DATA!A72:B77,2,0)","v":0.6},""]
["Permeable Pavers",null,{"$f":"VLOOKUP(A15,DATA!A73:B78,2,0)","v":0.25},""]
["Bioswales / Rain Gardens",null,0.25,"",null,null,null,"A)  Include Total Site Area of the subject land parcel."]
["Total",{"$f":"SUM(B12:B16)","v":0},null,{"$f":"SUM(D12:D16)","v":0},null,null,null,"B)  Enter the total proposed impervious coverage on the site, including existing  paved areas that are not impacted by the proposed construction.  Grandfathering of existing imperivious area is not permitted."]
[{"$f":"IF(B17>B5,\"Sum of GSI Areas Exceed Total Site Area, Calculations May Be Invalid\",\"\")","v":""}]
["C) Revised Site Impervious Area",null,{"$f":"IF(B7=\"\",\"\",B7-(SUM(D12:D16)))","v":10000},"(Square Feet)",null,null,null,"C) Green Infrastructure controls  provide credit and reduce the storage system requirements.  Provide the square foot area of any green infrastructure controls.  Idenfify locations of all GI on the Engineering Site Plan and submit specifications. "]
["D) Percent Site Impervious Area",null,{"$f":"(C19/B5)*100","v":100},"(%)"]
[]
["Approximate Detention Storag Size Required",null,null,{"$f":"'DATA ENTRY SHEET'!G21*7.48","v":14802.92},"(gallons)",null,null,"D and E) No Action needed."]
["Allowable Depth of Storage",null,null,{"$f":"'DATA ENTRY SHEET'!G22","v":3},"(Feet)"]
["Approximate Detention Footprint",null,null,{"$f":"'DATA ENTRY SHEET'!G23","v":659.66666666666663},"(Square Feet)",null,null,"Calculator Output"]
["Primary Orifice Size",null,null,{"$f":"IF('DATA ENTRY SHEET'!G24<2.5,2.5,'DATA ENTRY SHEET'!G24)","v":2.5},"(Inches)",null,null,"The gray shaded area outputs the site stormwater storage requirement, maximum storage depth,  and maximum orifice size of the OCS.  "]
[{"$f":"IF(B5>10000,\"Automated Valve Requirements for sites greater than or equal to 10,000 square feet\",IF(B5=10000,\"Automated Valve Requirements for sites greater than or equal to 10,000 square feet\",\"\"))","v":"Automated Valve Requirements for sites greater than or equal to 10,000 square feet"}]
["dia",{"$f":"ROUND(D23*12,0)","v":36}]
["area1",{"$f":"PI()*(D23^2)/4","v":7.0685834705770345}]
["len1",{"$f":"ROUND(D22/7.48/B28,0)","v":280}]
[{"$f":"IF(OR(A8<>\"\",A18<>\"\"),\"Check Input\",\"If the Applicant Chooses Pipe Storage, This Site Will Require \" & ROUND(B29, 0) & \" Ft \" & \"of \" & ROUND(B27,0) & \" in Pipe\")","v":"If the Applicant Chooses Pipe Storage, This Site Will Require 280 Ft of 36 in Pipe"},null,null,null,null,null,null,"If the site has greater than or equal to 10,000 square feet in area, an automatic valve is required.  Contact NHSA for additional information. "]
["NHSA Stormwater Storage  Tool - Version 2.0"]

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

{"sheet":"DATA ENTRY SHEET","index":2,"n_rows":24,"n_cols":7,"rows_kept":24,"cut":false,"hidden":true,"merged":[[23,0,23,5],[21,0,21,5],[22,0,22,5],[0,0,0,7],[1,0,1,7],[9,0,9,5],[10,0,10,5],[19,0,19,5],[20,0,20,5],[11,0,11,6],[18,0,18,5]]}
["NORTH HUDSON SEWERAGE AUTHORITY"]
["DETENTION VOLUME REQUIREMENT CALCULATOR"]
[]
["INSTRUCTIONS:"]
["1. ENABLE MACROS IN THE EXCEL SESSION."]
["2. USE THIS CALCULATOR FOR LOT SIZES FROM 0.05 ACRES UP TO 0.95 ACRES, AND BETWEEN 75-100% IMPERVIOUS. "]
["3. ENTER LOT SIZE UNDER FIELD A."]
["4. ENTER % IMPERVIOUS COVERAGE FOR PROPOSED CONDITIONS UNDER FIELD B (BETWEEN 75-100%)"]
["5. IF ANY GREEN INFRASTRUCTURE IS PROPOSED, INDICATE ON THIS SHEET TO GET STORAGE VOLUME CREDIT"]
["FIELD A: ENTER LOT SIZE IS ACRES",null,null,null,null,null,{"$f":"TRUNC((ROUND(('FILLABLE FORM'!B5/43560)/0.05,0)*0.05),2)","v":0.25}]
["FIELD B: ENTER % IMPERVIOUS UNDER PROPOSED CONDITIONS",null,null,null,null,null,{"$f":"'FILLABLE FORM'!C20","v":100}]
["GREEN INFRASTRUCTURE CREDIT CALCULATIONS"]
[]
[]
[]
[]
[]
[]
["REVISED % IMPERVIOUS AFTER CREDIT",null,null,null,null,null,{"$f":"'FILLABLE FORM'!C20","v":100}]
["CALCULATED DETENTION STORAGE SIZE REQUIRED, CU.FT",null,null,null,null,null,{"$f":"IF(AND(ISNUMBER(G10),ISNUMBER(G11)),ROUNDUP(((71.264*G19)+787.84)*G10,0),\"\")","v":1979}]
["APPROXIMATE DETENTION STORAGE SIZE REQUIRED, CU.FT",null,null,null,null,null,{"$f":"G22*G23","v":1979}]
["ALLOWABLE DEPTH OF STORAGE (FT)",null,null,null,null,null,{"$f":"IF(AND(ISNUMBER(G10),ISNUMBER(G11)),VLOOKUP(G10,DATA!J27:S46,7,0),\"\")","v":3}]
["APPROXIMATE DETENTION FOOTPRINT, SQ.FT",null,null,null,null,null,{"$f":"IF(AND(ISNUMBER(G10),ISNUMBER(G11)),VLOOKUP(G10,DATA!J27:S46,9,0),\"\")","v":659.66666666666663}]
["ORIFICE SIZE (in)",null,null,null,null,null,{"$f":"IF(AND(ISNUMBER(G10),ISNUMBER(G11)),VLOOKUP(G10,DATA!J27:S46,3,0),\"\")","v":2}]

{"sheet":"DATA","index":3,"n_rows":75,"n_cols":67,"rows_kept":75,"cut":false,"hidden":true,"merged":[[68,0,68,1],[68,3,68,4],[50,0,50,1],[26,3,26,4],[26,0,26,1],[3,2,3,6],[3,52,3,66],[3,37,3,51],[3,22,3,36],[3,7,3,21]]}
["P (in)",3.3,"HUDSON COUNTY 2-YEAR 24-HOUR RAINFALL"]
["Ia/S",0.2]
["Tc (mins)",10]
[null,null,"EXISTING",null,null,null,null,"PROPOSED-75% IMPERVIOUS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PROPOSED-85% IMPERVIOUS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PROPOSED-95% IMPERVIOUS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PROPOSED-100% IMPERVIOUS"]
["SCENARIO #","LOT SIZE (AC)","EXISTING CN","EXISTING FLOW (CFS)","S (in)","Ia (in)","EXISTING VOL (AC.FT)","IP AREA (AC)","IP AREA CN","NON-IP AREA (AC)","NON-IP AREA CN","IP AREA FLOW (CFS)","NON IP AREA FLOW (CFS)","TOTAL FLOW (CFS)","IP AREA \nS (in)","IP AREA\nIa (in)","IP AREA VOL (AC.FT)","NON-IP AREA\nS (in)","NON-IP AREA\nIa (in)","NON-IP AREA VOL (AC.FT)","TOTAL VOLUME (AC.FT)","VOLUME DIFF (CU.FT)","IP AREA (AC)","IP AREA CN","NON-IP AREA (AC)","NON-IP AREA CN","IP AREA FLOW (CFS)","NON IP AREA FLOW (CFS)","TOTAL FLOW (CFS)","IP AREA S (in)","IP AREA Ia (in)","IP AREA VOL (AC.FT)","NON IP AREA S (in)","NON IP AREA Ia (in)","NON-IP AREA VOL (AC.FT)","TOTAL VOLUME (AC.FT)","VOLUME DIFF (CU.FT)","IP AREA (AC)","IP AREA CN","NON-IP AREA (AC)","NON-IP AREA CN","IP AREA FLOW (CFS)","NON IP AREA FLOW (CFS)","TOTAL FLOW (CFS)","IP AREA S (in)","IP AREA Ia (in)","IP AREA VOL (AC.FT)","NON IP AREA S (in)","NON IP AREA Ia (in)","NON-IP AREA VOL (AC.FT)","TOTAL VOLUME (AC.FT)","VOLUME DIFF (CU.FT)","IP AREA (AC)","IP AREA CN","NON-IP AREA (AC)","NON-IP AREA CN","IP AREA FLOW (CFS)","NON IP AREA FLOW (CFS)","TOTAL FLOW (CFS)","IP AREA S (in)","IP AREA Ia (in)","IP AREA VOL (AC.FT)","NON IP AREA S (in)","NON IP AREA Ia (in)","NON-IP AREA VOL (AC.FT)","TOTAL VOLUME (AC.FT)","VOLUME DIFF (CU.FT)"]
[1,0.05,70,0.04,{"$f":"(1000/C6)-10","v":4.2857142857142865},{"$f":"$B$2*E6","v":0.85714285714285732},{"$f":"((IF(F6>$B$1,\"\",((($B$1-F6)^2)/($B$1+(0.8*E6)))))/12)*$B6","v":3.6954049135577783E-3},{"$f":"0.75*$B6","v":3.7500000000000006E-2},98,{"$f":"$B6-H6","v":1.2499999999999997E-2},74,0.1,0.01,{"$f":"M6+L6","v":0.11},{"$f":"(1000/I6)-10","v":0.20408163265306101},{"$f":"$B$2*O6","v":4.0816326530612207E-2},{"$f":"((IF(P6>$B$1,\"\",((($B$1-P6)^2)/($B$1+(0.8*O6)))))/12)*H6","v":9.5847752035404625E-3},{"$f":"(1000/K6)-10","v":3.513513513513514},{"$f":"$B$2*R6","v":0.70270270270270285},{"$f":"((IF(S6>$B$1,\"\",((($B$1-S6)^2)/($B$1+(0.8*R6)))))/12)*J6","v":1.1499349028373793E-3},{"$f":"Q6+T6","v":1.0734710106377842E-2},{"$f":"(U6-$G6)*43560","v":306.63213419924199},{"$f":"0.85*$B6","v":4.2500000000000003E-2},98,{"$f":"$B6-W6","v":7.4999999999999997E-3},74,0.11,0.01,{"$f":"AA6+AB6","v":0.12},{"$f":"(1000/X6)-10","v":0.20408163265306101},{"$f":"$B$2*AD6","v":4.0816326530612207E-2},{"$f":"((IF(AE6>$B$1,\"\",((($B$1-AE6)^2)/($B$1+(0.8*AD6)))))/12)*W6","v":1.0862745230679189E-2},{"$f":"(1000/Z6)-10","v":3.513513513513514},{"$f":"$B$2*AG6","v":0.70270270270270285},{"$f":"((IF(AH6>$B$1,\"\",((($B$1-AH6)^2)/($B$1+(0.8*AG6)))))/12)*Y6","v":6.8996094170242772E-4},{"$f":"AF6+AI6","v":1.1552706172381617E-2},{"$f":"(AJ6-$G6)*43560","v":342.26404283436636},{"$f":"0.95*$B6","v":4.7500000000000001E-2},98,{"$f":"$B6-AL6","v":2.5000000000000022E-3},74,0.13,3.0000000000000001E-3,{"$f":"AP6+AQ6","v":0.13300000000000001},{"$f":"(1000/AM6)-10","v":0.20408163265306101},{"$f":"$B$2*AS6","v":4.0816326530612207E-2},{"$f":"((IF(AT6>$B$1,\"\",((($B$1-AT6)^2)/($B$1+(0.8*AS6)))))/12)*AL6","v":1.2140715257817918E-2},{"$f":"(1000/AO6)-10","v":3.513513513513514},{"$f":"$B$2*AV6","v":0.70270270270270285},{"$f":"((IF(AW6>$B$1,\"\",((($B$1-AW6)^2)/($B$1+(0.8*AV6)))))/12)*AN6","v":2.2998698056747612E-4},{"$f":"AU6+AX6","v":1.2370702238385394E-2},{"$f":"(AY6-$G6)*43560","v":377.89595146949091},{"$f":"1*$B6","v":0.05},98,{"$f":"$B6-BA6","v":0},74,0.14000000000000001,0,{"$f":"BE6+BF6","v":0.14000000000000001},{"$f":"(1000/BB6)-10","v":0.20408163265306101},{"$f":"$B$2*BH6","v":4.0816326530612207E-2},{"$f":"((IF(BI6>$B$1,\"\",((($B$1-BI6)^2)/($B$1+(0.8*BH6)))))/12)*BA6","v":1.2779700271387282E-2},{"$f":"(1000/BD6)-10","v":3.513513513513514},{"$f":"$B$2*BK6","v":0.70270270270270285},{"$f":"((IF(BL6>$B$1,\"\",((($B$1-BL6)^2)/($B$1+(0.8*BK6)))))/12)*BC6","v":0},{"$f":"BJ6+BM6","v":1.2779700271387282E-2},{"$f":"(BN6-$G6)*43560","v":395.71190578705324}]
[2,0.1,70,0.08,{"$f":"(1000/C7)-10","v":4.2857142857142865},{"$f":"$B$2*E7","v":0.85714285714285732},7.3908098271155565E-3,{"$f":"0.75*$B7","v":7.5000000000000011E-2},98,{"$f":"$B7-H7","v":2.4999999999999994E-2},74,0.19,0.03,{"$f":"M7+L7","v":0.22},{"$f":"(1000/I7)-10","v":0.20408163265306101},{"$f":"$B$2*O7","v":4.0816326530612207E-2},{"$f":"((IF(P7>$B$1,\"\",((($B$1-P7)^2)/($B$1+(0.8*O7)))))/12)*H7","v":1.9169550407080925E-2},{"$f":"(1000/K7)-10","v":3.513513513513514},{"$f":"$B$2*R7","v":0.70270270270270285},{"$f":"((IF(S7>$B$1,\"\",((($B$1-S7)^2)/($B$1+(0.8*R7)))))/12)*J7","v":2.2998698056747586E-3},{"$f":"Q7+T7","v":2.1469420212755684E-2},{"$f":"(U7-$G7)*43560","v":613.26426839848398},{"$f":"0.85*$B7","v":8.5000000000000006E-2},98,{"$f":"$B7-W7","v":1.4999999999999999E-2},74,0.21,0.01,{"$f":"AA7+AB7","v":0.22},{"$f":"(1000/X7)-10","v":0.20408163265306101},{"$f":"$B$2*AD7","v":4.0816326530612207E-2},{"$f":"((IF(AE7>$B$1,\"\",((($B$1-AE7)^2)/($B$1+(0.8*AD7)))))/12)*W7","v":2.1725490461358379E-2},{"$f":"(1000/Z7)-10","v":3.513513513513514},{"$f":"$B$2*AG7","v":0.70270270270270285},{"$f":"((IF(AH7>$B$1,\"\",((($B$1-AH7)^2)/($B$1+(0.8*AG7)))))/12)*Y7","v":1.3799218834048554E-3},{"$f":"AF7+AI7","v":2.3105412344763234E-2},{"$f":"(AJ7-$G7)*43560","v":684.52808566873273},{"$f":"0.95*$B7","v":9.5000000000000001E-2},98,{"$f":"$B7-AL7","v":5.0000000000000044E-3},74,0.24,5.0000000000000001E-3,{"$f":"AP7+AQ7","v":0.245},{"$f":"(1000/AM7)-10","v":0.20408163265306101},{"$f":"$B$2*AS7","v":4.0816326530612207E-2},{"$f":"((IF(AT7>$B$1,\"\",((($B$1-AT7)^2)/($B$1+(0.8*AS7)))))/12)*AL7","v":2.4281430515635836E-2},{"$f":"(1000/AO7)-10","v":3.513513513513514},{"$f":"$B$2*AV7","v":0.70270270270270285},{"$f":"((IF(AW7>$B$1,\"\",((($B$1-AW7)^2)/($B$1+(0.8*AV7)))))/12)*AN7","v":4.5997396113495225E-4},{"$f":"AU7+AX7","v":2.4741404476770788E-2},{"$f":"(AY7-$G7)*43560","v":755.79190293898182},{"$f":"1*$B7","v":0.1},98,{"$f":"$B7-BA7","v":0},74,0.26,0,{"$f":"BE7+BF7","v":0.26},{"$f":"(1000/BB7)-10","v":0.20408163265306101},{"$f":"$B$2*BH7","v":4.0816326530612207E-2},{"$f":"((IF(BI7>$B$1,\"\",((($B$1-BI7)^2)/($B$1+(0.8*BH7)))))/12)*BA7","v":2.5559400542774564E-2},{"$f":"(1000/BD7)-10","v":3.513513513513514},{"$f":"$B$2*BK7","v":0.70270270270270285},{"$f":"((IF(BL7>$B$1,\"\",((($B$1-BL7)^2)/($B$1+(0.8*BK7)))))/12)*BC7","v":0},{"$f":"BJ7+BM7","v":2.5559400542774564E-2},{"$f":"(BN7-$G7)*43560","v":791.42381157410648}]
[3,0.15,70,0.12,4.2857142857142865,0.85714285714285732,1.1086214740673334E-2,0.11249999999999999,98,3.7500000000000006E-2,74,0.28999999999999998,0.04,0.32999999999999996,0.20408163265306101,4.0816326530612207E-2,2.8754325610621381E-2,3.513513513513514,0.70270270270270285,3.449804708512139E-3,3.2204130319133523E-2,919.89640259772591,0.1275,98,2.2499999999999992E-2,74,0.32,0.03,0.35,0.20408163265306101,4.0816326530612207E-2,3.2588235692037566E-2,3.513513513513514,0.70270270270270285,2.0698828251072823E-3,3.4658118517144849E-2,1026.7921285030993,0.14249999999999999,98,7.5000000000000067E-3,74,0.35,0.01,0.36,0.20408163265306101,4.0816326530612207E-2,3.6422145773453748E-2,3.513513513513514,0.70270270270270285,6.8996094170242837E-4,3.7112106715156176E-2,1133.6878544084727,0.15,98,0,74,0.37,0,0.37,0.20408163265306101,4.0816326530612207E-2,3.8339100814161843E-2,3.513513513513514,0.70270270270270285,0,3.8339100814161843E-2,1187.1357173611595]
[4,0.2,70,0.16,4.2857142857142865,0.85714285714285732,1.4781619654231113E-2,0.15000000000000002,98,4.9999999999999989E-2,74,0.37,0.05,0.42,0.20408163265306101,4.0816326530612207E-2,3.833910081416185E-2,3.513513513513514,0.70270270270270285,4.5997396113495173E-3,4.2938840425511368E-2,1226.528536796968,0.17,98,0.03,74,0.43,0.03,0.45999999999999996,0.20408163265306101,4.0816326530612207E-2,4.3450980922716757E-2,3.513513513513514,0.70270270270270285,2.7598437668097109E-3,4.6210824689526468E-2,1369.0561713374655,0.19,98,1.0000000000000009E-2,74,0.48,0.01,0.49,0.20408163265306101,4.0816326530612207E-2,4.8562861031271672E-2,3.513513513513514,0.70270270270270285,9.199479222699045E-4,4.9482808953541575E-2,1511.5838058779636,0.2,98,0,74,0.49,0,0.49,0.20408163265306101,4.0816326530612207E-2,5.1118801085549129E-2,3.513513513513514,0.70270270270270285,0,5.1118801085549129E-2,1582.847623148213]
[5,0.25,70,0.2,4.2857142857142865,0.85714285714285732,1.847702456778889E-2,0.1875,98,6.25E-2,74,0.46,7.0000000000000007E-2,0.53,0.20408163265306101,4.0816326530612207E-2,4.7923876017702302E-2,3.513513513513514,0.70270270270270285,5.7496745141868977E-3,5.36735505318892E-2,1533.1606709962093,0.21249999999999999,98,3.7500000000000006E-2,74,0.53,0.04,0.57000000000000006,0.20408163265306101,4.0816326530612207E-2,5.4313726153395941E-2,3.513513513513514,0.70270270270270285,3.449804708512139E-3,5.776353086190808E-2,1711.3202141718318,0.23749999999999999,98,1.2500000000000011E-2,74,0.59,0.01,0.6,0.20408163265306101,4.0816326530612207E-2,6.0703576289089581E-2,3.513513513513514,0.70270270270270285,1.1499349028373806E-3,6.185351119192696E-2,1889.4797573474541,0.25,98,0,74,0.62,0,0.62,0.20408163265306101,4.0816326530612207E-2,6.3898501356936407E-2,3.513513513513514,0.70270270270270285,0,6.3898501356936407E-2,1978.5595289352657]
[6,0.3,70,0.24,4.2857142857142865,0.85714285714285732,2.2172429481346668E-2,0.22499999999999998,98,7.5000000000000011E-2,74,0.56000000000000005,0.08,0.64,0.20408163265306101,4.0816326530612207E-2,5.7508651221242761E-2,3.513513513513514,0.70270270270270285,6.8996094170242781E-3,6.4408260638267045E-2,1839.7928051954518,0.255,98,4.4999999999999984E-2,74,0.64,0.05,0.69000000000000006,0.20408163265306101,4.0816326530612207E-2,6.5176471384075133E-2,3.513513513513514,0.70270270270270285,4.1397656502145646E-3,6.9316237034289699E-2,2053.5842570061986,0.28499999999999998,98,1.5000000000000013E-2,74,0.72,0.01,0.73,0.20408163265306101,4.0816326530612207E-2,7.2844291546907497E-2,3.513513513513514,0.70270270270270285,1.3799218834048567E-3,7.4224213430312352E-2,2267.3757088169455,0.3,98,0,74,0.75,0,0.75,0.20408163265306101,4.0816326530612207E-2,7.6678201628323686E-2,3.513513513513514,0.70270270270270285,0,7.6678201628323686E-2,{"$f":"(BN11-$G11)*43560","v":2374.2714347223191}]
[7,0.35,70,0.28000000000000003,4.2857142857142865,0.85714285714285732,2.5867834394904445E-2,0.26249999999999996,98,8.7500000000000022E-2,74,0.66,0.09,0.75,0.20408163265306101,4.0816326530612207E-2,6.709342642478322E-2,3.513513513513514,0.70270270270270285,8.0495443198616585E-3,7.5142970744644877E-2,2146.424939394693,0.29749999999999999,98,5.2499999999999991E-2,74,0.75,0.05,0.8,0.20408163265306101,4.0816326530612207E-2,7.6039216614754324E-2,3.513513513513514,0.70270270270270285,4.8297265919169932E-3,8.0868943206671318E-2,2395.8482998405648,0.33249999999999996,98,1.7500000000000016E-2,74,0.83,0.02,0.85,0.20408163265306101,4.0816326530612207E-2,8.4985006804725413E-2,3.513513513513514,0.70270270270270285,1.6099088639723329E-3,8.6594915668697744E-2,2645.2716602864361,0.35,98,0,74,0.88,0,0.88,0.20408163265306101,4.0816326530612207E-2,8.9457901899710965E-2,3.513513513513514,0.70270270270270285,0,8.9457901899710965E-2,2769.9833405093718]
[8,0.4,70,0.32,4.2857142857142865,0.85714285714285732,2.9563239308462226E-2,0.30000000000000004,98,9.9999999999999978E-2,74,0.75,0.1,0.85,0.20408163265306101,4.0816326530612207E-2,7.66782016283237E-2,3.513513513513514,0.70270270270270285,9.1994792226990346E-3,8.5877680851022736E-2,2453.0570735939359,0.34,98,0.06,74,0.85,0.06,0.90999999999999992,0.20408163265306101,4.0816326530612207E-2,8.6901961845433515E-2,3.513513513513514,0.70270270270270285,5.5196875336194218E-3,9.2421649379052936E-2,2738.1123426749309,0.38,98,2.0000000000000018E-2,74,0.94,0.02,0.96,0.20408163265306101,4.0816326530612207E-2,9.7125722062543343E-2,3.513513513513514,0.70270270270270285,1.839895844539809E-3,9.896561790708315E-2,3023.1676117559273,0.4,98,0,74,1.01,0,1.01,0.20408163265306101,4.0816326530612207E-2,0.10223760217109826,3.513513513513514,0.70270270270270285,0,0.10223760217109826,3165.6952462964259]
[9,0.45,70,0.35,4.2857142857142865,0.85714285714285732,3.3258644222020003E-2,0.33750000000000002,98,0.11249999999999999,74,0.85,0.12,0.97,0.20408163265306101,4.0816326530612207E-2,8.6262976831864152E-2,3.513513513513514,0.70270270270270285,1.0349414125536414E-2,9.6612390957400568E-2,2759.6892077931775,0.38250000000000001,98,6.7500000000000004E-2,74,0.95,7.0000000000000007E-2,1.02,0.20408163265306101,4.0816326530612207E-2,9.7764707076112706E-2,3.513513513513514,0.70270270270270285,6.2096484753218495E-3,0.10397435555143456,3080.376385509298,0.42749999999999999,98,2.250000000000002E-2,74,1.07,0.03,1.1000000000000001,0.20408163265306101,4.0816326530612207E-2,0.10926643732036126,3.513513513513514,0.70270270270270285,2.0698828251072849E-3,0.11133632014546854,3401.0635632254184,0.45,98,0,74,1.1200000000000001,0,1.1200000000000001,0.20408163265306101,4.0816326530612207E-2,0.11501730244248554,3.513513513513514,0.70270270270270285,0,0.11501730244248554,3561.4071520834786]
[10,0.5,70,0.39,4.2857142857142865,0.85714285714285732,3.6954049135577781E-2,0.375,98,0.125,74,0.94,0.13,1.0699999999999998,0.20408163265306101,4.0816326530612207E-2,9.5847752035404604E-2,3.513513513513514,0.70270270270270285,1.1499349028373795E-2,0.1073471010637784,3066.3213419924186,0.42499999999999999,98,7.5000000000000011E-2,74,1.05,0.08,1.1300000000000001,0.20408163265306101,4.0816326530612207E-2,0.10862745230679188,3.513513513513514,0.70270270270270285,6.8996094170242781E-3,0.11552706172381616,3422.6404283436636,0.47499999999999998,98,2.5000000000000022E-2,74,1.18,0.03,1.21,0.20408163265306101,4.0816326530612207E-2,0.12140715257817916,3.513513513513514,0.70270270270270285,2.2998698056747612E-3,0.12370702238385392,3778.9595146949082,0.5,98,0,74,1.25,0,1.25,0.20408163265306101,4.0816326530612207E-2,0.12779700271387281,3.513513513513514,0.70270270270270285,0,0.12779700271387281,3957.1190578705314]
[11,0.55000000000000004,70,0.43,4.2857142857142865,0.85714285714285732,4.0649454049135565E-2,0.41250000000000003,98,0.13750000000000001,74,1.04,0.14000000000000001,1.1800000000000002,0.20408163265306101,4.0816326530612207E-2,0.10543252723894508,3.513513513513514,0.70270270270270285,1.2649283931211177E-2,0.11808181117015626,3372.9534761916616,0.46750000000000003,98,8.2500000000000018E-2,74,1.17,0.08,1.25,0.20408163265306101,4.0816326530612207E-2,0.11949019753747109,3.513513513513514,0.70270270270270285,7.5895703587267067E-3,0.12707976789619779,3764.9044711780311,0.52249999999999996,98,2.750000000000008E-2,74,1.3,0.03,1.33,0.20408163265306101,4.0816326530612207E-2,0.13354786783599709,3.513513513513514,0.70270270270270285,2.5298567862422424E-3,0.13607772462223933,4156.8554661644002,0.55000000000000004,98,0,74,1.37,0,1.37,0.20408163265306101,4.0816326530612207E-2,0.14057670298526012,3.513513513513514,0.70270270270270285,0,0.14057670298526012,4352.8309636575859]
[12,0.6,70,0.47,4.2857142857142865,0.85714285714285732,4.4344858962693336E-2,0.44999999999999996,98,0.15000000000000002,74,1.1200000000000001,0.15,1.27,0.20408163265306101,4.0816326530612207E-2,0.11501730244248552,3.513513513513514,0.70270270270270285,1.3799218834048556E-2,0.12881652127653409,3679.5856103909036,0.51,98,8.9999999999999969E-2,74,1.28,0.09,1.37,0.20408163265306101,4.0816326530612207E-2,0.13035294276815027,3.513513513513514,0.70270270270270285,8.2795313004291292E-3,0.1386324740685794,4107.1685140123973,0.56999999999999995,98,3.0000000000000027E-2,74,1.42,0.03,1.45,0.20408163265306101,4.0816326530612207E-2,0.14568858309381499,3.513513513513514,0.70270270270270285,2.7598437668097135E-3,0.1484484268606247,4534.7514176338909,0.6,98,0,74,1.5,0,1.5,0.20408163265306101,4.0816326530612207E-2,0.15335640325664737,3.513513513513514,0.70270270270270285,0,0.15335640325664737,4748.5428694446382]
[13,0.65,70,0.51,4.2857142857142865,0.85714285714285732,4.804026387625112E-2,0.48750000000000004,98,0.16249999999999998,74,1.22,0.16,1.38,0.20408163265306101,4.0816326530612207E-2,0.124602077646026,3.513513513513514,0.70270270270270285,1.4949153736885932E-2,0.13955123138291192,3986.2177445901443,0.55249999999999999,98,9.7500000000000031E-2,74,1.37,0.1,1.4700000000000002,0.20408163265306101,4.0816326530612207E-2,0.14121568799882947,3.513513513513514,0.70270270270270285,8.9694922421315638E-3,0.15018518024096103,4449.432556846763,0.61749999999999994,98,3.2500000000000084E-2,74,1.55,0.03,1.58,0.20408163265306101,4.0816326530612207E-2,0.15782929835163292,3.513513513513514,0.70270270270270285,2.9898307473771946E-3,0.16081912909901011,4912.6473691033816,0.65,98,0,74,1.63,0,1.63,0.20408163265306101,4.0816326530612207E-2,0.16613610352803468,3.513513513513514,0.70270270270270285,0,0.16613610352803468,5144.2547752316914]
[14,0.7,70,0.55000000000000004,4.2857142857142865,0.85714285714285732,5.173566878980889E-2,0.52499999999999991,98,0.17500000000000004,74,1.3,0.18,1.48,0.20408163265306101,4.0816326530612207E-2,0.13418685284956644,3.513513513513514,0.70270270270270285,1.6099088639723317E-2,0.15028594148928975,4292.8498787893859,0.59499999999999997,98,0.10499999999999998,74,1.48,0.1,1.58,0.20408163265306101,4.0816326530612207E-2,0.15207843322950865,3.513513513513514,0.70270270270270285,9.6594531838339864E-3,0.16173788641334264,4791.6965996811296,0.66499999999999992,98,3.5000000000000031E-2,74,1.66,0.03,1.69,0.20408163265306101,4.0816326530612207E-2,0.16997001360945083,3.513513513513514,0.70270270270270285,3.2198177279446657E-3,0.17318983133739549,{"$f":"(AY19-$G19)*43560","v":5290.5433205728723},0.7,98,0,74,1.74,0,1.74,0.20408163265306101,4.0816326530612207E-2,0.17891580379942193,3.513513513513514,0.70270270270270285,0,0.17891580379942193,{"$f":"(BN19-$G19)*43560","v":5539.9666810187437}]
[15,0.75,70,0.59,4.2857142857142865,0.85714285714285732,5.5431073703366668E-2,0.5625,98,0.1875,74,1.41,0.19,1.5999999999999999,0.20408163265306101,4.0816326530612207E-2,0.14377162805310692,3.513513513513514,0.70270270270270285,1.7249023542560693E-2,0.16102065159566761,4599.4820129886293,0.63749999999999996,98,0.11250000000000004,74,1.6,0.12,1.7200000000000002,0.20408163265306101,4.0816326530612207E-2,0.16294117846018782,3.513513513513514,0.70270270270270285,1.0349414125536419E-2,0.17329059258572424,5133.9606425154961,0.71249999999999991,98,3.7500000000000089E-2,74,1.77,0.04,1.81,0.20408163265306101,4.0816326530612207E-2,0.18211072886726873,3.513513513513514,0.70270270270270285,3.4498047085121468E-3,0.18556053357578087,5668.439272042363,0.75,98,0,74,1.87,0,1.87,0.20408163265306101,4.0816326530612207E-2,0.19169550407080921,3.513513513513514,0.70270270270270285,0,0.19169550407080921,5935.6785868057968]
[16,0.8,70,0.63,4.2857142857142865,0.85714285714285732,5.9126478616924452E-2,0.60000000000000009,98,0.19999999999999996,74,1.5,0.2,1.7,0.20408163265306101,4.0816326530612207E-2,0.1533564032566474,3.513513513513514,0.70270270270270285,1.8398958445398069E-2,0.17175536170204547,4906.1141471878718,0.68,98,0.12,74,1.69,0.12,1.81,0.20408163265306101,4.0816326530612207E-2,0.17380392369086703,3.513513513513514,0.70270270270270285,1.1039375067238844E-2,0.18484329875810587,5476.2246853498618,0.76,98,4.0000000000000036E-2,74,1.91,0.04,1.95,0.20408163265306101,4.0816326530612207E-2,0.19425144412508669,3.513513513513514,0.70270270270270285,3.679791689079618E-3,0.1979312358141663,6046.3352235118546,0.8,98,0,74,2,0,2,0.20408163265306101,4.0816326530612207E-2,0.20447520434219651,3.513513513513514,0.70270270270270285,0,0.20447520434219651,6331.3904925928518]
[17,0.85,70,0.67,4.2857142857142865,0.85714285714285732,6.2821883530482223E-2,0.63749999999999996,98,0.21250000000000002,74,1.6,0.21,1.81,0.20408163265306101,4.0816326530612207E-2,0.16294117846018782,3.513513513513514,0.70270270270270285,1.9548893348235456E-2,0.18249007180842328,5212.7462813871125,0.72249999999999992,98,0.12750000000000006,74,1.81,0.13,1.94,0.20408163265306101,4.0816326530612207E-2,0.18466666892154621,3.513513513513514,0.70270270270270285,1.1729336008941276E-2,0.19639600493048748,5818.4887281842284,0.8075,98,4.2499999999999982E-2,74,2.02,0.05,2.0699999999999998,0.20408163265306101,4.0816326530612207E-2,0.20639215938290459,3.513513513513514,0.70270270270270285,3.9097786696470887E-3,0.21030193805255168,6424.2311749813462,0.85,98,0,74,2.11,0,2.11,0.20408163265306101,4.0816326530612207E-2,0.21725490461358377,3.513513513513514,0.70270270270270285,0,0.21725490461358377,6727.1023983799023]
[18,0.9,70,0.71,4.2857142857142865,0.85714285714285732,6.6517288444040007E-2,0.67500000000000004,98,0.22499999999999998,74,1.68,0.23,1.91,0.20408163265306101,4.0816326530612207E-2,0.1725259536637283,3.513513513513514,0.70270270270270285,2.0698828251072828E-2,0.19322478191480114,5519.378415586355,0.76500000000000001,98,0.13500000000000001,74,1.92,0.14000000000000001,2.06,0.20408163265306101,4.0816326530612207E-2,0.19552941415222541,3.513513513513514,0.70270270270270285,1.2419296950643699E-2,0.20794871110286911,6160.7527710185959,0.85499999999999998,98,4.500000000000004E-2,74,2.13,0.05,2.1799999999999997,0.20408163265306101,4.0816326530612207E-2,0.21853287464072252,3.513513513513514,0.70270270270270285,4.1397656502145698E-3,0.22267264029093708,6802.1271264508368,0.9,98,0,74,2.2400000000000002,0,2.2400000000000002,0.20408163265306101,4.0816326530612207E-2,0.23003460488497107,3.513513513513514,0.70270270270270285,0,0.23003460488497107,7122.8143041669573]
[19,0.95,70,0.74,4.2857142857142865,0.85714285714285732,7.0212693357597777E-2,0.71249999999999991,98,0.23750000000000004,74,1.77,0.24,2.0099999999999998,0.20408163265306101,4.0816326530612207E-2,0.18211072886726873,3.513513513513514,0.70270270270270285,2.1848763153910215E-2,0.20395949202117894,5826.0105497855957,0.8075,98,0.14249999999999996,74,2.02,0.14000000000000001,2.16,0.20408163265306101,4.0816326530612207E-2,0.20639215938290459,3.513513513513514,0.70270270270270285,1.3109257892346123E-2,0.21950141727525072,6503.0168138529616,0.90249999999999997,98,4.7499999999999987E-2,74,2.2400000000000002,0.05,2.29,0.20408163265306101,4.0816326530612207E-2,0.23067358989854042,3.513513513513514,0.70270270270270285,4.3697526307820414E-3,0.23504334252932246,7180.0230779203275,0.95,98,0,74,2.36,0,2.36,0.20408163265306101,4.0816326530612207E-2,0.24281430515635832,3.513513513513514,0.70270270270270285,0,0.24281430515635832,7518.5262099540096]
[]
[]
["%IP VS VOL DIFF TRENDLINES",null,null,"FINAL REQD VOLUME EQUATION",null,null,null,"SCENARIO #","LOT SIZE (SQ.FT)","LOT SIZE (AC)","DEPTH OF TANK (FT)","ORIFICE SIZE (in)","HEAD (FT)","FLOW (CFS)","CALCULATED FOOTPRINT (SQ.FT)","ACCEPTABLE DEPTH (FT)","FOOTPRINT BASED ON ACCEPTABLE DEPTH (SQ.FT)","REVISED FOOTPRINT (SQ.FT)","%OF AREA FOR TANK",null,null,null,null,null,null,null,null,null,null,"CALCULATED FOOTPRINT (SQ.FT)","REVISED FOOTPRINT (SQ.FT)","%OF AREA FOR TANK",null,null,null,null,null,null,null,null,null,null,null,null,"CALCULATED FOOTPRINT (SQ.FT)","REVISED FOOTPRINT (SQ.FT)","%OF AREA FOR TANK",null,null,null,null,null,null,null,null,null,null,null,null,"CALCULATED FOOTPRINT (SQ.FT)","REVISED FOOTPRINT (SQ.FT)","%OF AREA FOR TANK"]
["%IP","VOL",null,"LOT",0.95,null,null,1,{"$f":"J28*43560","v":2178},{"$f":"B6","v":0.05},2.3261532941047678,1,{"$f":"K28-(L28/12)","v":2.2428199607714343},{"$f":"0.6*((PI()*(L28/12)^2)/4)*(SQRT(2*32.2*M28))","v":3.9329532096206217E-2},{"$f":"'DATA ENTRY SHEET'!$G$20/$K28","v":850.76078391541625},{"$f":"IF(K28<1,1,IF(K28<3,ROUNDUP(K28/0.5,0)*0.5,3))","v":2.5},{"$f":"'DATA ENTRY SHEET'!$G$20/$P28","v":791.6},{"$f":"MAX(O28,Q28)","v":850.76078391541625},{"$f":"R28/$I28","v":0.39061560326694961},null,null,null,null,null,null,null,null,null,null,{"$f":"AK6/$K28","v":147.13735492057864},{"$f":"AK6/$P28","v":136.90561713374655},{"$f":"AE28/$I28","v":6.2858410070590703E-2},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AZ6/$K28","v":162.45530869663779},{"$f":"AZ6/$P28","v":151.15838058779636},{"$f":"AT28/$I28","v":6.9402378598620917E-2},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"BO6/$K28","v":170.11428558466739},{"$f":"BO6/$P28","v":158.28476231482131},{"$f":"BI28/$I28","v":7.2674362862636052E-2}]
[75,6132.6,null,"%IP",82.5,null,null,2,{"$f":"J29*43560","v":4356},{"$f":"B7","v":0.1},9.1517994266788421,1,{"$f":"K29-(L29/12)","v":9.0684660933455081},{"$f":"0.6*((PI()*(L29/12)^2)/4)*(SQRT(2*32.2*M29))","v":7.908397499143667E-2},{"$f":"'DATA ENTRY SHEET'!$G$20/$K29","v":216.24162721824123},{"$f":"IF(K29<1,1,IF(K29<3,ROUNDUP(K29/0.5,0)*0.5,3))","v":3},{"$f":"'DATA ENTRY SHEET'!$G$20/$P29","v":659.66666666666663},{"$f":"MAX(O29,Q29)","v":659.66666666666663},0.15143862871135597,null,null,null,null,null,null,null,null,null,null,{"$f":"AK7/$K29","v":74.797103143807178},{"$f":"AK7/$P29","v":228.17602855624423},{"$f":"AE29/$I29","v":5.2382008392158917E-2},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AZ7/$K29","v":82.583967119705136},{"$f":"AZ7/$P29","v":251.93063431299393},{"$f":"AT29/$I29","v":5.7835315498850765E-2},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"BO7/$K29","v":86.477399107654136},{"$f":"BO7/$P29","v":263.80793719136881},{"$f":"BI29/$I29","v":6.0561969052196699E-2}]
[85,6845.3,null,"VOL",{"$f":"((71.264*E29)+787.84)*E28","v":6333.7639999999992},null,null,3,6534,0.15,4.2469088825729253,1.5,4.1219088825729253,0.11996464827583683,{"$f":"'DATA ENTRY SHEET'!$G$20/$K30","v":465.98598056124359},3,{"$f":"'DATA ENTRY SHEET'!$G$20/$P30","v":659.66666666666663},659.66666666666663,0.10095908580757065,null,null,null,null,null,null,null,null,null,null,241.7739953679046,342.26404283436642,5.2382008392158924E-2,null,null,null,null,null,null,null,null,null,null,null,null,266.94423773971931,377.89595146949091,5.7835315498850765E-2,null,null,null,null,null,null,null,null,null,null,null,null,279.5293589256267,395.71190578705318,6.0561969052196692E-2]
[95,7557.9,null,null,null,null,null,4,8712,0.2,7.4501083221690445,1.5,7.3251083221690445,0.15992306959000743,{"$f":"'DATA ENTRY SHEET'!$G$20/$K31","v":265.63372160793341},3,{"$f":"'DATA ENTRY SHEET'!$G$20/$P31","v":659.66666666666663},659.66666666666663,7.5719314355677983E-2,null,null,null,null,null,null,null,null,null,null,183.76325714132366,456.35205711248847,5.2382008392158917E-2,null,null,null,null,null,null,null,null,null,null,null,null,202.89420509229282,503.86126862598786,5.7835315498850765E-2,null,null,null,null,null,null,null,null,null,null,null,null,212.45967906777742,527.61587438273762,6.0561969052196699E-2]
[100,7914.2,null,null,null,null,null,5,10890,0.25,3.7834306718959869,2,3.6167640052293204,0.19977523517654946,{"$f":"'DATA ENTRY SHEET'!$G$20/$K32","v":523.07024275622996},3,{"$f":"'DATA ENTRY SHEET'!$G$20/$P32","v":659.66666666666663},659.66666666666663,6.0575451484542388E-2,null,null,null,null,null,null,null,null,null,null,452.31969674608564,570.44007139061057,5.238200839215891E-2,null,null,null,null,null,null,null,null,null,null,null,null,499.40911336973988,629.8265857824847,5.7835315498850751E-2,null,null,null,null,null,null,null,null,null,null,null,null,522.95382168156709,659.51984297842193,6.0561969052196692E-2]
[null,null,null,null,null,null,null,6,13068,0.3,5.3730823117565185,2,5.2064156450898516,0.23969058910965133,{"$f":"'DATA ENTRY SHEET'!$G$20/$K33","v":368.31745452137761},3,{"$f":"'DATA ENTRY SHEET'!$G$20/$P33","v":659.66666666666663},659.66666666666663,5.0479542903785327E-2,null,null,null,null,null,null,null,null,null,null,382.19854784522363,684.52808566873284,5.2382008392158924E-2,null,null,null,null,null,null,null,null,null,null,null,null,421.98789768320449,755.79190293898182,5.7835315498850765E-2,null,null,null,null,null,null,null,null,null,null,null,null,441.8825726021949,791.42381157410637,6.0561969052196692E-2]
[null,null,null,null,null,null,null,7,15245.999999999998,0.35,3.1177665587918972,2.5,2.9094332254585638,0.27996631933314026,{"$f":"'DATA ENTRY SHEET'!$G$20/$K34","v":634.74925485339816},3,{"$f":"'DATA ENTRY SHEET'!$G$20/$P34","v":659.66666666666663},659.66666666666663,4.3268179631815999E-2,null,null,null,null,null,null,null,null,null,null,768.45018851216741,798.61609994685489,5.2382008392158924E-2,null,null,null,null,null,null,null,null,null,null,null,null,848.45084146115539,881.75722009547871,5.7835315498850771E-2,null,null,null,null,null,null,null,null,null,null,null,null,888.45116793564944,923.32778016979057,6.0561969052196685E-2]
[null,null,null,null,null,null,null,8,17424,0.4,4.007922990993718,2.5,3.7995896576603845,0.31994103036757876,{"$f":"'DATA ENTRY SHEET'!$G$20/$K35","v":493.77196229744175},3,{"$f":"'DATA ENTRY SHEET'!$G$20/$P35","v":659.66666666666663},659.66666666666663,3.7859657177838991E-2,null,null,null,null,null,null,null,null,null,null,683.17488854646081,912.70411422497693,5.2382008392158917E-2,null,null,null,null,null,null,null,null,null,null,null,null,754.29782921212461,1007.7225372519757,5.7835315498850765E-2,null,null,null,null,null,null,null,null,null,null,null,null,789.85929954495668,1055.2317487654752,6.0561969052196699E-2]
[null,null,null,null,null,null,null,9,19602,0.45,4.7535502950638415,2.5,4.5452169617305085,0.34992816553686801,{"$f":"'DATA ENTRY SHEET'!$G$20/$K36","v":416.32040835983656},3,{"$f":"'DATA ENTRY SHEET'!$G$20/$P36","v":659.66666666666663},659.66666666666663,3.3653028602523553E-2,null,null,null,null,null,null,null,null,null,null,648.01594477879144,1026.7921285030993,5.2382008392158931E-2,null,null,null,null,null,null,null,null,null,null,null,null,715.47861116713841,1133.6878544084727,5.7835315498850765E-2,null,null,null,null,null,null,null,null,null,null,null,null,749.20994436131195,1187.1357173611595,6.0561969052196692E-2]
[null,null,null,null,null,null,null,10,21780,0.5,2.9714047060665649,3,2.7214047060665649,0.38990665557173471,{"$f":"'DATA ENTRY SHEET'!$G$20/$K37","v":666.0149645585393},3,{"$f":"'DATA ENTRY SHEET'!$G$20/$P37","v":659.66666666666663},666.0149645585393,3.0579199474680407E-2,null,null,null,null,null,null,null,null,null,null,1151.8593954421065,1140.8801427812211,5.238200839215891E-2,null,null,null,null,null,null,null,null,null,null,null,null,1271.7754356986782,1259.6531715649694,5.7835315498850751E-2,null,null,null,null,null,null,null,null,null,null,null,null,1331.7334558269642,1319.0396859568439,6.0561969052196692E-2]
[null,null,null,null,null,null,null,11,23958.000000000004,0.55000000000000004,3.5542595101732122,3,3.3042595101732122,0.42963648725150061,{"$f":"'DATA ENTRY SHEET'!$G$20/$K38","v":556.79670950744844},3,{"$f":"'DATA ENTRY SHEET'!$G$20/$P38","v":659.66666666666663},659.66666666666663,2.7534296129337447E-2,null,null,null,null,null,null,null,null,null,null,1059.2654983131924,1254.9681570593436,5.2382008392158924E-2,null,null,null,null,null,null,null,null,null,null,null,null,1169.5419128137387,1385.6184887214667,5.7835315498850765E-2,null,null,null,null,null,null,null,null,null,null,null,null,1224.680120064012,1450.9436545525286,6.0561969052196699E-2]
[null,null,null,null,null,null,null,12,26136,0.6,4.1957823339364841,3,3.9457823339364841,0.46949464681791386,{"$f":"'DATA ENTRY SHEET'!$G$20/$K39","v":471.6641242309874},3,{"$f":"'DATA ENTRY SHEET'!$G$20/$P39","v":659.66666666666663},659.66666666666663,2.5239771451892663E-2,null,null,null,null,null,null,null,null,null,null,978.88026287556499,1369.0561713374657,5.2382008392158924E-2,null,null,null,null,null,null,null,null,null,null,null,null,1080.7880525535713,1511.5838058779636,5.7835315498850765E-2,null,null,null,null,null,null,null,null,null,null,null,null,1131.7419473925745,1582.8476231482127,6.0561969052196692E-2]
[null,null,null,null,null,null,null,13,28314,0.65,2.8045922881351966,3.5,2.51292562146853,0.50997334733457855,{"$f":"'DATA ENTRY SHEET'!$G$20/$K40","v":705.62841107855229},3,{"$f":"'DATA ENTRY SHEET'!$G$20/$P40","v":659.66666666666663},705.62841107855229,2.492153744008449E-2,null,null,null,null,null,null,null,null,null,null,1586.4810638145334,1483.1441856155877,5.2382008392158924E-2,null,null,null,null,null,null,null,null,null,null,null,null,1751.6440410559117,1637.5491230344605,5.7835315498850765E-2,null,null,null,null,null,null,null,null,null,null,null,null,1834.2255296766011,1714.7515917438971,6.0561969052196692E-2]
[null,null,null,null,null,null,null,14,30491.999999999996,0.7,3.2138991333967306,3.5,2.9222324667300641,0.54993966251963433,{"$f":"'DATA ENTRY SHEET'!$G$20/$K41","v":615.76294645825396},3,{"$f":"'DATA ENTRY SHEET'!$G$20/$P41","v":659.66666666666663},659.66666666666663,2.1634089815908E-2,null,null,null,null,null,null,null,null,null,null,1490.929366727463,1597.2321998937098,5.2382008392158924E-2,null,null,null,null,null,null,null,null,null,null,null,null,1646.1447920368807,1763.5144401909574,5.7835315498850771E-2,null,null,null,null,null,null,null,null,null,null,null,null,1723.7525046915896,1846.6555603395811,6.0561969052196685E-2]
[null,null,null,null,null,null,null,15,32670,0.75,3.653851394246177,3.5,3.3621847275795105,0.58988648702951429,{"$f":"'DATA ENTRY SHEET'!$G$20/$K42","v":541.62027583179417},3,{"$f":"'DATA ENTRY SHEET'!$G$20/$P42","v":659.66666666666663},659.66666666666663,2.0191817161514129E-2,null,null,null,null,null,null,null,null,null,null,1405.0819501307822,1711.320214171832,5.2382008392158924E-2,null,null,null,null,null,null,null,null,null,null,null,null,1551.3601021017478,1889.4797573474543,5.7835315498850758E-2,null,null,null,null,null,null,null,null,null,null,null,null,1624.4991780872308,1978.5595289352657,6.0561969052196685E-2]
[null,null,null,null,null,null,null,16,34848,0.8,2.5793721504230906,4,2.2460388170897572,0.62972391213758849,{"$f":"'DATA ENTRY SHEET'!$G$20/$K43","v":767.24097361266286},3,{"$f":"'DATA ENTRY SHEET'!$G$20/$P43","v":659.66666666666663},767.24097361266286,2.201678643287026E-2,null,null,null,null,null,null,null,null,null,null,2123.0843654924338,1825.4082284499539,5.2382008392158917E-2,null,null,null,null,null,null,null,null,null,null,null,null,2344.1112297502641,2015.4450745039514,5.7835315498850765E-2,null,null,null,null,null,null,null,null,null,null,null,null,2454.6246618791797,2110.4634975309505,6.0561969052196699E-2]
[null,null,null,null,null,null,null,17,37026,0.85,2.8709333109936503,4,2.5375999776603169,0.66934979836513342,{"$f":"'DATA ENTRY SHEET'!$G$20/$K44","v":689.32287365290767},3,{"$f":"'DATA ENTRY SHEET'!$G$20/$P44","v":659.66666666666663},689.32287365290767,1.8617265533757567E-2,null,null,null,null,null,null,null,null,null,null,2026.6889188625591,1939.4962427280761,5.2382008392158917E-2,null,null,null,null,null,null,null,null,null,null,null,null,2237.6803913838994,2141.4103916604486,5.7835315498850771E-2,null,null,null,null,null,null,null,null,null,null,null,null,2343.1761276445686,2242.3674661266341,6.0561969052196678E-2]
[null,null,null,null,null,null,null,18,39204,0.9,3.1884024439191063,4,2.8550691105857728,0.70998613665178245,{"$f":"'DATA ENTRY SHEET'!$G$20/$K45","v":620.68701640043332},3,{"$f":"'DATA ENTRY SHEET'!$G$20/$P45","v":659.66666666666663},659.66666666666663,1.6826514301261777E-2,null,null,null,null,null,null,null,null,null,null,1932.2381284609571,2053.5842570061986,5.2382008392158931E-2,null,null,null,null,null,null,null,null,null,null,null,null,2133.39666058273,2267.3757088169455,5.7835315498850765E-2,null,null,null,null,null,null,null,null,null,null,null,null,2233.9759266436167,2374.2714347223191,6.0561969052196692E-2]
[null,null,null,null,null,null,null,19,41382,0.95,3.4347122992344463,4,3.1013789659011128,0.73997828362278284,{"$f":"'DATA ENTRY SHEET'!$G$20/$K46","v":576.17635120155296},3,{"$f":"'DATA ENTRY SHEET'!$G$20/$P46","v":659.66666666666663},659.66666666666663,1.5940908285405894E-2,null,null,null,null,null,null,null,null,null,null,1893.3221321920912,2167.6722712843207,5.2382008392158924E-2,null,null,null,null,null,null,null,null,null,null,null,null,2090.4292564826064,2393.3410259734424,5.7835315498850765E-2,null,null,null,null,null,null,null,null,null,null,null,null,2188.9828186278642,2506.1754033180032,6.0561969052196685E-2]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["%CREDIT FOR GREEN INFRASTRUCTURE"]
["TYPE","%CREDIT"]
["Porous Pavement",0.25]
["Green Roof",0.5]
["Blue Roof",0.6]
["Permeable Pavers",0.25]
["Bioretention",0.5]