{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Instructions","Cover","Site Inputs","Lookup Tables","Drainage Tables","DA #","Design Summary"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":10,"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":"Instructions","index":0,"n_rows":90,"n_cols":3,"rows_kept":90,"cut":false,"hidden":false,"merged":[[61,1,61,2],[3,1,3,2],[19,1,19,2],[25,1,25,2],[26,1,26,2],[34,1,34,2],[88,1,88,2],[89,1,89,2],[62,1,62,2],[63,1,63,2],[66,1,66,2],[80,1,80,2],[86,1,86,2],[87,1,87,2]]}
[]
[null,null,"KC Compliance Calculator Instructions"]
[]
[null,"Instructions Worksheet"]
[]
[null,"1.","Light blue cells are to be filled in by the designer."]
[null,"2.","Gray cells are automatically calculated based on the designer inputs. These cells are locked and should not be changed."]
[null,"3.","Green cells are to be filled in by the Approving Jurisdiction"]
[null,"4."]
[]
[]
[]
[]
[null,"5."]
[]
[]
[]
[]
[]
[null,"Cover Worksheet"]
[null,"1.","General Requirements: Complete these in tandem with the Site Summary section of the Site Inputs sheet."]
[null,"2.","Designer Verification: After finishing the Design Worksheets (DA#), return to the Cover Sheet to complete the Designer Verification of Compliance with Design Criteria sections."]
[null,"3.","Required Maps: Ensure the Required Maps section is marked as provided with the submittal when completing the Designer Verification."]
[null,"4.","Saving the Workbook: Once the KC Compliance Calculator is completed, click the \"Save as PDF\" button at the top. Select a location to save the workbook for submittal. A default name, based on the Project Name and the date, will be provided."]
[]
[null,"Site Inputs Worksheet","Site Inputs"]
[null,"Site Summary"]
[null,"1.","Project and Development Type: Select the Project and Development Type using the dropdown list options."]
[null,"2.","System Type: Select the System Type in which the project is located using the dropdown list options (Combined Sewer System or Separate Storm Sewer System). If the project is tributary to a combined sewer system at any point downstream, it should be considered combined. Confirm system type with Approving Jurisdiction, as appropriate."]
[null,"3.","Proposed Land Use: Select the Proposed Land Use of the project using the dropdown list options. Note that this input primarily used if designer is relying on assumed impervious coverage values, as described in step 4."]
[null,"4.","Input Value Basis: Choose the basis for the post-project input values using the dropdown list options."]
[null,"◦","If \"Estimated Values\" is selected, an assumed percent impervious coverage will be generated based on the selected land use. This will be used by the designer to complete the drainage areas worksheet. Assumed values are only appropriate for early concept analysis, or, larger residential-type developments where final building/pavement layouts are yet to be defined. "]
[null,"5.","Total Disturbed Area: Enter the total disturbed area in square feet. A message will appear saying the total of the subdivided drainage areas in the Drainage Area Summary Table does not match the total disturbed area. After completing the Drainage Area Summary Table, ensure that the totals match and the message is not displayed."]
[null,"◦","Treatment Summary Table: This table is auto-calculated based on the remaining inputs of the sheet and is used to determine values in subsequent tables and worksheets. As the detailed drainage area tables are completed, a message will appear if the volume of the uncontrolled area is too high."]
[null,"Drainage Areas"]
[null,"1.","Number of Drainage Areas: Enter the number of drainage areas that intersect the disturbed area of the site in cell E24. These include both controlled and uncontrolled drainage areas."]
[null,"◦","The Drainage Area Summary Table will automatically adjust based on the value entered in cell E24. The Unique Drainage Area ID will initially fill with numbers 1, 2, 3, etc."]
[null,"◦","Two tables are automatically added to the bottom of the worksheet for each drainage area in the Drainage Area Summary Table; an Individual Drainage Area Summary Table, which auto-calculates values needed for the Design worksheets (DA#), and a Cover Type Area Table, for the designer to complete."]
[null,"◦","Note: The Drainage Area ID, control designation (Yes/No), and disturbed drainage area in each detailed table are linked to the corresponding row in the Drainage Area Summary Table. Any revisions must be made in the Drainage Area Summary Table. "]
[null,"◦","Note: If the total number of drainage areas is increased in cell E24, the workbook will automatically generate additional tables."]
[null,"◦","Note: If the total number of drainage areas is decreased in cell E24, a warning will appear asking if you are sure you want to delete the associated tables and design worksheets. Click \"Yes\" to complete the deletion of the drainage area; click \"No\" to keep the drainage area. "]
[null,"2.","Complete the Drainage Area Summary Table:"]
[null,"a.","Unique Drainage Area Identifier (ID): Adjust the Drainage Area IDs if desired."]
[null,"◦","Note: The number of drainage areas must be changed in cell E24 per Step 1; the number must not be adjusted by expanding this table manually or through deleting data and leaving blank rows. "]
[null,"b.","Feasibility of Control: Indicate if each drainage area can be feasibly controlled."]
[null,"◦","Note: The uncontrolled drainage area represents the portion of the project's disturbed area from which it is impractical to capture and convey stormwater runoff to a retention or detention practice. The percentage of controlled drainage area must meet or exceed the project type percentage. Reference to Appendix A Definitions. "]
[null,"◦","Note: Design Worksheets are only generated in Step 5 for drainage areas which are marked \"Yes\", they can be feasibly controlled. If a drainage area is later marked as \"No\", it cannot be feasibly controlled, a warning will appear asking if you are you want to delete the associated design worksheet. Click \"Yes\" to complete the deletion of the design worksheet; click \"No\" to keep the design worksheet."]
[null,"c.","Disturbed Drainage Area: Enter the amount of the drainage area within the disturbed area in square feet."]
[null,"3.","Select Post-Project Cover Types: Choose the cover types present in the post-project condition. Reference Table 5602-4 for Rv assumptions."]
[null,"a.","Filter Cover Types: Use the \"Filter Cover Types\" button to filter the tables based on selected choices, if desired. Cover types can be unfiltered to the tables by click the \"Unfilter Cover Types\" button."]
[null,"4.","Enter Cover Type Areas: For each Cover Type Area Table (generated for each drainage area per Step 1), enter the area values for applicable post-project cover types within the disturbed area footprint."]
[null,"a.","Impervious Cover: If unknown, calculate using the assumed percent impervious coverage in cell E9."]
[null,"◦","Auto-Calculations: Required retention volume, pervious area weighted Rv, impervious area weighted Rv, and post-project condition weighted CN in the detailed summary table will auto-calculate as cover type areas are entered."]
[null,"◦","Note: The total cover area must equal the disturbed drainage area in the Drainage Area Summary Table. A message will display until totals match. "]
[null,"◦","Note: If there are drainage areas that are not controlled, the RRV for the controlled drainage areas in the Individual Drainage Area Summary Table(s) will be adjusted to account for the additional volume needing to be controlled."]
[null,"5.","Generate Design Worksheets: Once detailed drainage area tables are completed, click the \"Generate Design Worksheets\" button. This will create a new worksheet titled \"DA X\" for each controlled drainage area, where \"DA\" stands for \"Drainage Area\" and \"X\" corresponds to the Unique Drainage Area ID."]
[null,"a.","If the total number of drainage areas is increased or a previously uncontrolled area is now controlled, click the button again to generate additional design worksheets."]
[null,"b.","If the total number of drainage areas is decreased or a previously controlled area is now uncontrolled, a warning will appear asking if you are sure you want to delete the associated tables and/or design worksheets. Click \"Yes\" to complete the deletion of the drainage area; click \"No\" to keep the drainage area."]
[null,"◦","Linking: Each design worksheet links to the corresponding detailed summary table. Revisions must be made in the Drainage Area Summary Table or the appropriate Cover Type Area Table of the Site Inputs Worksheet."]
[]
[]
[null,"Design Worksheet(s) (DA# Worksheets)"]
[null,"Linking Values: The values at the top of each design worksheet link to the Site Inputs worksheet. Any revisions to disturbed area or cover types must be made in the corresponding Drainage Area Summary Table or the appropriate Cover Type Area Table in the Site Inputs Worksheet."]
[null,"Required Retention Volume Reductions"]
[null,"1.","Natural Area Preservation/Restoration and Downspout Disconnections: Enter the area values of the natural or pervious area receiving the sheetflow/disconnection and the corresponding drainage area (pervious and/or impervious), if any. A credit will be auto-calculated and deducted from the total retention volume required for the drainage area."]
[null,"2.","Tree Preservation/Planting: Enter the number of trees either being preserved or planted, if any. A credit will be auto-calculated and deducted from the total retention volume required for the drainage area."]
[null,"Retention Practices"]
[null,"1.","Material Types and Storage Layers: Select the material types and/or storage layers to be used for all retention practices in the drainage area. Corresponding columns will appear in the design table below as selections are made."]
[null,"2.","Retention Facility ID: Create an ID for each unique retention facility."]
[null,"3.","Practice: Select a type of retention practice to design."]
[null,"4.","In-Series Retention Facilities: Enter the downstream retention facility ID for routing when retention facilities are applied in-series."]
[null,"5.","Tributary Drainage Area: Enter the pervious and impervious tributary drainage area to each facility."]
[null,"◦","Impervious tributary area should include the following cover types: pervious area, gravel - public road with compacted subgrade material, and water surfaces. All other cover types should be input in the pervious tributary drainage area columns. The pervious area weighted Rv for the drainage area factors in the appropriate weighted runoff coefficient to be applied"]
[null,"◦","A \"Target RRV Prior to Reductions\" for each GSI facility is auto-calculated based on the pervious weighted Rv, impervious weighted Rv, the PT%, the tributary drainage area to the GSI, and any bypass volume from upstream facilities. This value is approximate in nature and intended to assist the designer in right-sizing each facility. The approximate target retention volume does  NOT include the RRVreductions and therefore does NOT represent the exact RRV. It is intended to set a target for the designer while giving flexibility in where the RRVreductions are applied within each drainage area, so long as the total RRV for the drainage area is met. "]
[null,"6.","Design Parameters: Enter the design parameters for each storage and/or material layer of the facility to achieve the required retention volume. Porosity values (n) and volumes are auto-calculated."]
[null,"◦","The Retention Volume Provided (VR) is auto-calculated based on the lesser of the GSI Total Static Storage Volume (GSIstorage) * GSI runoff reduction factor (RRFGSI) based on the GSI Practice type and presence of an underdrain, or, the Maximum Retention Credit Allowed. Note that the VR cannot exceed the maximum retention credit allowed based on maximum WQv tributary to each GSI. Oversizing a facility without the tributary drainage area to support it will not be credited."]
[null,"◦","The bypass volume is calculated as the difference between the approximate target retention volume and the VR. The bypass volume is automatically routed to the designated downstream retention facility identified. Note that bypass is permitted provided that the bypass at the downstream most facility(ies) do not exceed the RRVreductions for the drainage area. "]
[null,"◦","A message will appear if the facility is oversized by more than 10%, warning that credit cannot be taken for volume over the maximum retention credit allowed and to consider reducing the facility size. Designer is recommended to right-size the facility."]
[null,"◦","Underneath the design table, the required retention volume after reductions (RRVDA#) and the retention volume achieved with retention practices (VR)are shown. A message will indicate whether the required retention volume was achieved or if additional volume is needed."]
[null,"7.","Hide/Show Blank Rows: After completing the design table, click the \"Hide Blank Rows in Retention Practice Table\" button. If necessary, blank rows can be added back by clicking the \"Show Blank Rows in Retention Practice Table\" button."]
[null,"Detention Calculations"]
[null,"1.","Rainfall Depth: Input the rainfall depth for each design storm based on the project's location."]
[null,"2.","Retention Design Completion: After completing the retention design, cells in row 86 will auto-calculate a retention adjusted curve number (CNR), and row 87 will indicate if detention is required for each storm event. Use this information to meet detention release rate requirements. With sufficient retention practices, the CNR may reduce or eliminate the need for detention peak flow control for some of the required design storms."]
[null,"3.","Peak Outflow Rates: Input the modeled peak outflow rates for each design storm. A message will appear if the release rate requirements have been met or if the outlet control needs resizing to meet the required release rate."]
[null,"4.","Overtopping Elevation & Max Ponding Depths: Input the elevation at which water will overtop and exit the detention practice and therefore not be controlled by the primary, secondary, or overflow spillway. Input the modeled maximum water surface elevation for each design storm. A message will appear if the maximum ponding elevation exceeds the  overtopping elevation of the practice."]
[]
[null,"Design Summary Worksheet"]
[null,"Purpose: The Design Summary worksheet is a tool for both designers and reviewers to confirm that the design for individual drainage areas meets the total site requirements."]
[null,"Drainage Area Summary: For each drainage area, the worksheet summarizes the following:\n     RRV Prior to Reductions\n     RRV Reductions\n     RRV After Reductions\n     Retention Volume Achieved"]
[null,"Total Site Summary: The Total Site Summary table auto-sums each of these values and checks that the required Percent WQv Control is achieved. A message will appear if the required Percent WQv Control is not achieved, in which case, the design needs revised for one or more drainage areas."]

{"sheet":"Cover","index":1,"n_rows":167,"n_cols":12,"rows_kept":167,"cut":false,"hidden":false,"merged":[[111,2,111,12],[112,2,112,12],[121,2,121,12],[123,2,123,12],[124,2,124,12],[125,2,125,12],[107,2,107,12],[108,2,108,12],[109,2,109,12],[119,2,119,12],[120,2,120,12],[69,1,69,6],[75,1,75,12],[74,1,74,12],[77,1,77,6],[77,7,77,9],[79,11,79,12],[100,7,100,12],[101,7,101,9],[101,11,101,12],[100,1,103,6],[102,7,103,9],[102,10,103,10],[102,11,103,12],[82,1,82,12],[83,1,83,6],[83,7,83,9],[83,10,83,12],[85,11,85,12],[86,11,86,12],[87,11,87,12],[88,1,88,12],[89,1,89,6],[89,7,89,12],[90,7,90,12],[9,7,9,10],[55,1,55,12],[56,1,56,12],[57,1,57,6],[57,7,57,12],[58,7,58,12],[59,7,59,12],[60,7,60,12],[62,7,62,12],[34,3,37,11],[13,1,13,12],[24,2,28,11],[30,1,30,12],[11,2,11,6],[11,7,11,10],[17,2,18,7],[17,9,18,9],[17,10,18,10],[10,7,10,10],[40,1,40,12],[44,6,45,7],[46,6,47,7],[48,6,49,7],[50,6,51,7],[1,1,1,12],[2,1,2,12],[4,7,4,10],[6,7,6,10],[5,7,5,10],[3,2,3,6],[4,2,4,6],[5,2,5,6],[6,2,6,6],[3,7,3,10],[8,2,8,6],[9,2,9,6],[10,2,10,6],[8,7,8,10],[131,1,131,12],[138,1,138,12],[146,8,146,10],[145,1,145,7],[146,1,146,7],[145,8,145,10],[61,7,61,12],[64,7,64,12],[66,7,66,12],[76,1,76,12],[70,7,70,12],[71,7,71,9],[71,11,71,12],[65,7,65,12],[63,7,63,12],[70,1,73,6],[72,7,73,9],[72,10,73,10],[72,11,73,12],[52,6,53,7],[145,11,145,12],[146,11,146,12],[79,7,79,9],[80,7,80,9],[81,7,81,9],[78,7,78,9],[77,10,78,12],[80,11,81,12],[130,1,130,12],[85,7,85,9],[86,7,86,9],[87,7,87,9],[118,2,118,12],[99,1,99,6],[84,7,84,9],[91,1,91,12],[92,1,92,6],[92,7,92,12],[126,2,126,12],[127,2,127,12],[128,2,128,12],[104,1,104,12],[106,2,106,12],[110,2,110,12],[43,1,43,7],[45,9,47,11],[53,9,53,10],[50,11,52,11],[50,9,52,10],[165,1,165,7],[165,8,165,10],[165,11,165,12],[129,1,129,12],[84,11,84,12],[105,1,105,12],[93,7,93,12],[94,7,94,12],[95,7,95,12],[96,7,96,12],[97,7,97,12],[98,7,98,12],[122,2,122,12],[113,2,113,12],[114,2,114,12],[115,2,115,12],[116,2,116,12],[117,2,117,12],[147,1,147,12],[166,1,166,7],[166,8,166,10],[166,11,166,12],[154,1,154,7],[154,8,154,10],[154,11,154,12],[155,1,155,7],[155,8,155,10],[155,11,155,12],[156,1,156,12],[158,1,163,12]]}
[]
[null,"General Requirements"]
[null,"Project Information"]
[null,null,"Project Name:"]
[null,null,"Date:"]
[null,null,"Address:"]
[null,null,"Nearest Intersection:"]
[]
[null,null,"Project Type:",null,null,null,null,{"$f":"IF('Site Inputs'!$D$4=\"\",\"\",'Site Inputs'!$D$4)","v":""}]
[null,null,"System Type:",null,null,null,null,{"$f":"IF('Site Inputs'!$D$5=\"\",\"\",'Site Inputs'!$D$5)","v":""}]
[null,null,"Proposed Land Use:",null,null,null,null,{"$f":"IF('Site Inputs'!$D$6=\"\",\"\",'Site Inputs'!$D$6)","v":""}]
[null,null,"Input Value Basis:",null,null,null,null,{"$f":"IF('Site Inputs'!$D$7=\"\",\"\",'Site Inputs'!$D$7)","v":""}]
[]
[null,"Site Parameters"]
[null,null,"Total Disturbed Area of Site",null,null,null,null,null,null,{"$f":"IF('Site Inputs'!$D$9=0,\"\",'Site Inputs'!$D$9/43560)","v":""},"acres"]
[null,null,"Total Proposed Impervious Area",null,null,null,null,null,null,null,"square feet"]
[]
[null,null,"Single-family/duplex dwelling part of a larger common plan of development?",null,null,null,null,null,null,null,"(Select Yes/No)"]
[]
[null,null,null,"Lot Size ",null,null,null,null,null,null,"acres"]
[null,null,null,"Percent Impervious Coverage",null,null,null,null,null,null,"%"]
[]
[null,null,"Effective FEMA floodplain?",null,null,null,null,null,null,null,"(Select Yes/No)"]
[null,null,"Describe Known Stormwater Issues (if any):"]
[]
[]
[]
[]
[]
[]
[null,"Stormwater Management Requirements/Variance"]
[null,null,"Project required to meet stormwater management criteria?",null,null,null,null,null,null,null,{"$f":"IF(J18=\"No\", IF(OR(J20 < 1, J21 < 35), \"No\", \"Yes\"), IF(AND(J15 < 0.5, J16 < 5000), \"No\", \"Yes\"))","v":"Yes"}]
[null,null,"Request for Variance?",null,null,null,null,null,null,null,null,"(Select Yes/No)"]
[null,null,null,"If yes, explain why a variance is being requested."]
[]
[]
[]
[]
[]
[]
[null,"Approving Jurisdiction Review"]
[null,"This section is to be filled out by the approving jurisdiction following completion of review."]
[]
[null,"Requirements Met?"]
[null,false,"Approved",null,null,null,"Preservation/Restoration",null,null,"I hereby certify that I have reviewed the information submitted:"]
[null,false,"Revise & Resubmit"]
[null,false,"Approved",null,null,null,"Retention/Detention"]
[null,false,"Revise & Resubmit"]
[null,false,"Approved",null,null,null,"Collection",null,null,"Approving Authority Signature"]
[null,false,"Revise & Resubmit"]
[null,false,"Approved",null,null,null,"Conveyance"]
[null,false,"Revise & Resubmit"]
[null,false,"Approved",null,null,null,"Maintenance Responsibilities"]
[null,false,"Revise & Resubmit",null,null,null,null,null,null,"Name (Printed)",null,"Date"]
[]
[null,"Landscape Professional Verification of Compliance with Design Criteria"]
[null,"Preservation/Restoration"]
[null,"Requirements Met?",null,null,null,null,null,"Design Criteria"]
[null,false,"Yes",false,"No",false,"N/A","Stream setbacks meet requirements of Section 5604 and placed within a separate dedicated tract of land restricted from future development?"]
[null,false,"Yes",false,"No",null,null,"Project incorporates preservation or restoration of Natural Areas?"]
[null,false,"Yes",false,"No",false,"N/A","     Natural Area meets requirements of Section 5604?"]
[null,false,"Yes",false,"No",false,"N/A","     Natural Area placed within a separate dedicated tract of land restricted from \n     future development?"]
[null,false,"Yes",false,"No",false,"N/A","Project incorporates the following Sustainable Stormwater Management Practices and RRV reductions meeting requirements of Section 5602 and 5604 (select all that apply):"]
[null,false,"Yes",false,"No",false,"N/A","     Sheetflow to Natural Areas"]
[null,false,"Yes",false,"No",false,"N/A","     Sheetflow to Natural Areas"]
[null,false,"Yes",false,"No",false,"N/A","     Downspout Disconnection (not applicable for residential developments)"]
[null,false,"Yes",false,"No",false,"N/A","     Preservation of Existing Trees or Planting New Trees?"]
[]
[null,null,null,null,null,null,null,null,null,"Total RRV Reductions:",{"$f":"'Design Summary'!$D$7","v":0},"(ft3)"]
[null,"Licensee's Seal:"]
[null,null,null,null,null,null,null,"I hereby certify, as a Landscape Professional, that the information in the Preservation/Restoration section of this form was assembled under my direct personal charge and is in compliance with the Stormwater Management Criteria."]
[]
[null,null,null,null,null,null,null,"Professional Name",null,null,"License Number","State"]
[]
[]
[null,"Professional Engineer Verification of Compliance with Design Criteria"]
[null,"Retention"]
[null,"Requirements Met?",null,null,null,null,null,"Design Criteria",null,null,"Retention Volume (ft3)"]
[null,false,"Yes",false,"No",false,"N/A","Required Retention Volume met per Section 5602?"]
[null,false,"Yes",false,"No",false,"N/A","Easement(s) provided per Section 5609.3?",null,null,"Required","Designed"]
[null,null,null,null,null,null,null,"RRV (prior to RRV Reductions)",null,null,{"$f":"'Design Summary'!$D$6","v":0},{"$f":"'Design Summary'!$D$9","v":0}]
[null,null,null,null,null,null,null,"RRV (with RRV Reductions)",null,null,{"$f":"'Design Summary'!$D$8","v":0}]
[null,"Detention"]
[null,"Requirements Met?",null,null,null,null,null,"Design Criteria",null,null,"Release Rates (cfs)"]
[null,false,"Yes",false,"No",false,"N/A","Easement(s) provided per Section 5609.3?",null,null,"Maximum Allowable","Designed"]
[null,false,"Yes",false,"No",false,"N/A","2-year peak outflow control achieved?",null,null,{"$f":"IF($J$15=\"\",\"\",0.2*$J$15)","v":""},{"$f":"0","v":0}]
[null,false,"Yes",false,"No",false,"N/A","10-year peak outflow control achieved?",null,null,{"$f":"IF($J$15=\"\",\"\",0.6*$J$15)","v":""},{"$f":"0","v":0}]
[null,false,"Yes",false,"No",false,"N/A","100-year peak outflow control achieved? ",null,null,{"$f":"IF($J$15=\"\",\"\",3*$J$15)","v":""},{"$f":"0","v":0}]
[null,"Collection"]
[null,"Requirements Met?",null,null,null,null,null,"Design Criteria"]
[null,false,"Yes",false,"No",false,"N/A","Inlet placement and gutter spread per requirements of Section 5607?"]
[null,"Conveyance"]
[null,"Requirements Met?",null,null,null,null,null,"Design Criteria"]
[null,false,"Yes",false,"No",false,"N/A","Easement(s) provided per Section 5609.3? "]
[null,false,"Yes",false,"No",false,"N/A","Enclosed pipe systems per requirements of 5608.3?"]
[null,false,"Yes",false,"No",false,"N/A","Minor drainage systems per requirements of 5608.4, C, 3?"]
[null,false,"Yes",false,"No",false,"N/A","Designated overflow routes for 100-year design storm per requirements of Section 5608.2?"]
[null,false,"Yes",false,"No",false,"N/A","Open channel design per requirements of 5608.4 and energy management per 5608.5?"]
[null,false,"Yes",false,"No",false,"N/A","Road crossings per requirements of 5608.4, D?"]
[null,"Licensee's Seal:"]
[null,null,null,null,null,null,null,"I hereby certify, as a Professional Engineer, that the information in the Retention, Detention, Collection, and Conveyance sections of this form were assembled under my direct personal charge and is in compliance with the Stormwater Management Criteria."]
[]
[null,null,null,null,null,null,null,"Professional Name",null,null,"License Number","State"]
[]
[]
[null,"Required Maps"]
[null,false,"Watershed Location Map. Describes the project's location within the greater watershed depicting:"]
[null,"1.","Watershed boundary and area (acres)"]
[null,"2.","Delineated drainage area tributary to the project site (acres)"]
[null,"3.","Natural overland drainage paths to, through and downstream of the project site to the downstream destination of runoff (whether open channel or enclosed system)"]
[null,"4.","Water bodies & regulatory floodplain (lakes, rivers, streams, creeks, wetlands, etc.)"]
[null,"5.","Existing stormwater retention/detention facility location(s) in upstream or downstream watershed affecting stormwater management at project site (if applicable)"]
[null,false,"Existing Site Conditions Map. Demonstrates existing conditions of the site depicting:"]
[null,"1.","Existing contours"]
[null,"2.","Aerial imagery"]
[null,"3.","Water bodies & regulatory floodplain (lakes, rivers, streams, creeks, wetlands, etc.)"]
[null,"4.","Natural overland drainage paths and discharge points from the site"]
[null,"5.","Existing utilities, including existing stormwater infrastructure"]
[null,"6.","Parcel boundaries"]
[null,"7.","Existing impervious surfaces and types (i.e. building, parking lot, gravel, etc.)"]
[null,"8.","Key statistics including total disturbed area, total impervious area, and lot size (if applicable)"]
[null,false,"Proposed Site Conditions Map. Demonstrates proposed conditions of the site depicting:"]
[null,"1.","Proposed contours including finished floor elevation (FFE) and lowest opening elevation (LOE) information"]
[null,"2.","Existing and proposed utilities, including existing stormwater infrastructure overland drainage paths"]
[null,"3.","Designated overflow routes and discharge points from the site"]
[null,"4.","Proposed drainage areas labeled with IDs and acreages correlating to the stormwater management calculator inputs, including uncontrolled drainage area"]
[null,"5.","Parcel boundaries depicting required utility easements, stream setbacks identifying key features and statistics (top of bank or bank-full extents, centerline, Zone 1, and Zone 2, and dimensional offset), and Natural Areas with key statistics (total footprint, minimum length and width)."]
[null,"6.","Impervious surfaces and types (i.e. building, parking lot, gravel, etc.)"]
[null,"7.","Stormwater improvements including Natural Areas of preservation or restoration, preserved trees, new trees, retention practices, detention practices, collection and conveyance practices with labels correlating to the stormwater management calculator inputs"]
[]
[null,"Maintenance Requirement & Responsibilities"]
[null,"Storm Drainage System Components"]
[null,"Select all applicable components of the storm drainage system design"]
[null,null,null,null,null,null,null,"Preserved Natural Areas",false]
[null,null,null,null,null,null,null,"Restored Natural Areas",false]
[null,null,null,null,null,null,null,"Retention & Detention Practices",false]
[null,null,null,null,null,null,null,"Collection Practices",false]
[null,null,null,null,null,null,null,"Conveyance Practices",false]
[null,"During Construction"]
[]
[null,null,null,null,null,null,null,"Anticipated Construction Start"]
[null,null,null,null,null,null,null,null,null,"Month","Year"]
[null,null,null,null,null,null,null,"Anticipated Construction Completion"]
[null,null,null,null,null,null,null,null,null,"Month","Year"]
[null,"Responsible Party"]
[]
[null,"Name",null,null,null,null,null,null,"Address",null,null,"Phone"]
[null,"Warranty and/or Vegetation Establishment Period"]
[]
[null,null,null,null,null,null,null,"Anticipated Construction Start"]
[null,null,null,null,null,null,null,null,null,"Month","Year"]
[null,null,null,null,null,null,null,"Anticipated Construction Completion"]
[null,null,null,null,null,null,null,null,null,"Month","Year"]
[null,"Responsible Party"]
[]
[null,"Name",null,null,null,null,null,null,"Address",null,null,"Phone"]
[null,"Long-Term Owner (Post-Warranty Period)"]
[null,"Describe source of funding and the mechanism for maintenance of stormwater drainage system:"]
[]
[]
[]
[]
[]
[]
[null,"Responsible Party"]
[]
[null,"Name",null,null,null,null,null,null,"Address",null,null,"Phone"]

{"sheet":"Site Inputs","index":2,"n_rows":244,"n_cols":15,"rows_kept":244,"cut":false,"hidden":false,"merged":[[65,1,65,3],[52,4,52,12],[3,3,3,6],[12,1,12,3],[11,1,11,3],[14,1,14,3],[35,1,35,3],[18,1,18,3],[16,1,16,3],[17,1,17,3],[33,1,33,3],[34,1,34,3],[30,1,30,4],[31,1,31,3],[32,1,32,3],[15,1,15,3],[4,3,4,6],[6,3,6,6],[5,3,5,6],[25,1,25,3],[40,1,40,3],[36,1,36,3],[37,1,37,3],[38,1,38,3],[39,1,39,3],[13,1,13,3],[49,1,49,3],[41,1,41,3],[48,1,48,3],[44,1,44,3],[45,1,45,3],[46,1,46,3],[47,1,47,3],[50,1,50,3],[58,1,58,3],[59,1,59,3],[61,1,61,3],[64,1,64,3],[63,1,63,3],[53,1,53,3],[55,1,55,3],[56,1,56,3],[60,1,60,3],[62,1,62,3],[57,1,57,3],[54,1,54,3],[52,1,52,3]]}
[]
[null,"Site Inputs Worksheet"]
[]
[null,"Project and Development Type:"]
[null,"System Type:"]
[null,"Proposed Land Use:"]
[null,"Input Value Basis:"]
[null,"Assumed Percent Impervious Coverage:",null,{"$f":"IF($D$7=\"Actual measured values based on improvement plans\", \"NA\", IF($D$7=\"Estimated values based on development type\", IF($D$6<>\"\", IFERROR(VLOOKUP($D$6,'Lookup Tables'!$A$54:$B$64,2,FALSE),\"\"), \"\"), \"\"))","v":""},{"$f":"IF($D$7=\"\",\"Select an Input Value Basis above.\", IF(D7=\"Estimated values based on development type\", IF(D6=\"\",\"Select a Proposed Land Use above.\",\"\"), \"\"))","v":"Select an Input Value Basis above."}]
[null,"Total Disturbed Area ft2:",null,null,{"$f":"IF($D$9=\"\",\"\",(IF($D$9-SUM(Drainage_Area_IDs[Disturbed Drainage Area (ft2)])<>0,\"⮽ Subdivided disturbed drainage areas from the Drainage Area Summary Table does not match the input total disturbed area.\",\"\")))","v":""}]
[]
[null,"Treatment Summary Table"]
[null,"Water Quality Storm Event (PWQ), inches",null,null,1.37]
[null,"Percent of Water Quality Storm to be Retained (PT%)",null,null,{"$f":"IFERROR(IF(D5=\"Separate Storm Sewer System\",VLOOKUP($D$4,'Lookup Tables'!$A$3:$C$7,2,FALSE),IF(D5=\"Combined Sewer System\",VLOOKUP($D$4,'Lookup Tables'!$A$3:$C$7,3,FALSE),0)),0)","v":0},{"$f":"IF(AND(D4=\"\", D5=\"\"),\"\",IF(D5=\"\",\"Select a System Type above\",IF(D4=\"\",\"Select a Project and Development Type above\",\"\")))","v":""}]
[null,"Total Controlled Disturbed Area (Acontrolled), ft2",null,null,{"$f":"IF(SUMIF(Drainage_Area_IDs[Can this drainage area be feasibly controlled?],\"Yes\",Drainage_Area_IDs[Disturbed Drainage Area (ft2)])>0,SUMIF(Drainage_Area_IDs[Can this drainage area be feasibly controlled?],\"Yes\",Drainage_Area_IDs[Disturbed Drainage Area (ft2)]),0)","v":0}]
[null,"Controlled Area Rv (Rvcontrolled)",null,null,{"$f":"0","v":0},"Equation 5602-16"]
[null,"Total Uncontrolled Disturbed Area, ft2",null,null,{"$f":"IF(SUMIF(Drainage_Area_IDs[Can this drainage area be feasibly controlled?],\"No\",Drainage_Area_IDs[Disturbed Drainage Area (ft2)])>0,SUMIF(Drainage_Area_IDs[Can this drainage area be feasibly controlled?],\"No\",Drainage_Area_IDs[Disturbed Drainage Area (ft2)]),0)","v":0}]
[null,"Total Required Retention Volume (RRV), ft3",null,null,{"$f":"IFERROR(($E$12/12)*$E$13*(M66*O66), 0)","v":0},"Equation 5602-9"]
[null,"Uncontrolled Retention Volume, ft3",null,null,{"$f":"SUM(0)","v":0},{"$f":"IFERROR((IF($E$18/$E$17>(1-$E$13),\"⮽ Uncontrolled area is too large. Stormwater management required for portions of uncontrolled area.\",\"☑ Uncontrolled area is within the limit to achieve the total site retention requirements.\")),\"\")","v":""}]
[null,"Adjusted PT% within Controlled Drainage Areas (PT%controlled)",null,null,{"$f":"IFERROR(IF($E$16=0,\"NA\",(12*($E$17)/($E$12*($E$15*$E$14)))),\"\")","v":"NA"},"Equation 5602-15"]
[]
[]
[null,"Drainage Areas"]
[]
[null,"How many total drainage areas are included on the site?",null,null,1]
[]
[null,"Drainage Area Summary Table"]
[null,"Unique Drainage Area Identifier (ID)","Can this drainage area be feasibly controlled?","Disturbed Drainage Area (ft2)"]
[null,1]
[]
[]
[null,"Select post-project cover types within the disturbed area:"]
[null,"Natural Area",null,null,false]
[null,"Pervious Area",null,null,false]
[null,"Impervious Area",null,null,false]
[null,"Solar Farm - Native",null,null,false]
[null,"Solar Farm - Gravel",null,null,false]
[null,"Gravel - Overflow Parking Lots, Trails/Maintenance Paths, Substations",null,null,false]
[null,"Gravel - Primary Parking Lots, Access Driveways, Railroad Ballasts",null,null,false]
[null,"Gravel - Public Road with Compacted Subgrade Material",null,null,false]
[null,"Artificial Turf - No Underdrain System",null,null,false]
[null,"Artificial Turf - Underdrain System",null,null,false]
[null,"Water Surfaces",null,null,false]
[true]
[]
[true,"Individual Drainage Area Summary Table ID:",null,null,{"$f":"IF(ISBLANK('Site Inputs'!$B$28), \"-\", 'Site Inputs'!$B$28)","v":1}]
[true,"Is this drainage area controlled?",null,null,{"$f":"IF(ISBLANK('Site Inputs'!$C$28), \"-\", 'Site Inputs'!$C$28)","v":"-"}]
[true,"Disturbed drainage area (ft2)",null,null,{"$f":"IF(ISBLANK('Site Inputs'!$D$28), \"0\", 'Site Inputs'!$D$28)","v":"0"}]
[true,{"$f":"IF(E46=\"No\", \"Uncontrolled Retention Volume, (ft³)\", IF(AND(E46=\"Yes\", 'Site Inputs'!$E$19=\"NA\"), \"RRV Prior to Reductions, (ft³)\", IF(AND(E46=\"Yes\", 'Site Inputs'!$E$19>0), \"Adjusted RRV Prior to Reductions, (ft³)\", \"RRV Prior to Reductions, (ft³)\")))","v":"RRV Prior to Reductions, (ft³)"},null,null,{"$f":"IFERROR(IF(E46=\"Yes\",IF('Site Inputs'!$E$19=\"NA\",'Site Inputs'!$E$12/12*'Site Inputs'!$E$13*M66*O66,'Site Inputs'!$E$12/12*'Site Inputs'!$E$19*M66*O66),'Site Inputs'!$E$12/12*'Site Inputs'!$E$13*M66*O66),0)","v":0},"Equation 5602-9"]
[true,"Pervious Area Weighted Rv",null,null,{"$f":"IF(E46=\"No\",\"NA\",IFERROR((M55*O55+M56*O56+M58*O58+M59*O59+M60*O60+M61*O61+M63*O63+M64*O64)/(M55+M56+M58+M59+M60+M61+M63+M64),\"-\"))","v":"-"}]
[true,"Impervious Area Weighted Rv",null,null,{"$f":"IF(E46=\"No\",\"NA\",IFERROR((O57*M57++M62*O62+O65*M65)/(M57+M62+M65),\"-\"))","v":"-"}]
[true,"Post-Project Condition Weighted CN",null,null,{"$f":"IFERROR((SUMPRODUCT(E55:E65,F55:F65)+SUMPRODUCT(G55:G65,H55:H65)+SUMPRODUCT(I55:I65,J55:J65)+SUMPRODUCT(K55:K65,L55:L65))/M66,\"-\")","v":"-"}]
[true]
[true,{"$f":"\"Post-Project Cover Type Area Table for Drainage Area \"&E45","v":"Post-Project Cover Type Area Table for Drainage Area 1"},null,null,"Area (ft2)"]
[true,"Cover Type",null,null,"Soil Type A","CN","Soil Type B","CN","Soil Type C","CN","Soil Type D","CN","Total","% Cover","Rv"]
[{"$f":"'Site Inputs'!$E$32","v":false},"Natural Area",null,null,null,{"$f":"VLOOKUP(B55,'Lookup Tables'!$A$12:$F$22,3,FALSE)","v":30},null,{"$f":"VLOOKUP(B55,'Lookup Tables'!$A$12:$F$22,4,FALSE)","v":55},null,{"$f":"VLOOKUP(B55,'Lookup Tables'!$A$12:$F$22,5,FALSE)","v":70},null,{"$f":"VLOOKUP(B55,'Lookup Tables'!$A$12:$F$22,6,FALSE)","v":77},{"$f":"E55+G55+I55+K55","v":0},{"$f":"IF(M66>0,M55/M66,0)","v":0},{"$f":"VLOOKUP(B55,'Lookup Tables'!$A$12:$F$22,2,FALSE)","v":0}]
[{"$f":"'Site Inputs'!$E$33","v":false},"Pervious Area",null,null,null,{"$f":"VLOOKUP(B56,'Lookup Tables'!$A$12:$F$22,3,FALSE)","v":39},null,{"$f":"VLOOKUP(B56,'Lookup Tables'!$A$12:$F$22,4,FALSE)","v":61},null,{"$f":"VLOOKUP(B56,'Lookup Tables'!$A$12:$F$22,5,FALSE)","v":74},null,{"$f":"VLOOKUP(B56,'Lookup Tables'!$A$12:$F$22,6,FALSE)","v":80},{"$f":"E56+G56+I56+K56","v":0},{"$f":"IF(M66>0,M56/M66,0)","v":0},{"$f":"VLOOKUP(B56,'Lookup Tables'!$A$12:$F$22,2,FALSE)","v":0.25}]
[{"$f":"'Site Inputs'!$E$34","v":false},"Impervious Area",null,null,null,{"$f":"VLOOKUP(B57,'Lookup Tables'!$A$12:$F$22,3,FALSE)","v":98},null,{"$f":"VLOOKUP(B57,'Lookup Tables'!$A$12:$F$22,4,FALSE)","v":98},null,{"$f":"VLOOKUP(B57,'Lookup Tables'!$A$12:$F$22,5,FALSE)","v":98},null,{"$f":"VLOOKUP(B57,'Lookup Tables'!$A$12:$F$22,6,FALSE)","v":98},0,{"$f":"IF(M66>0,M57/M66,0)","v":0},{"$f":"VLOOKUP(B57,'Lookup Tables'!$A$12:$F$22,2,FALSE)","v":0.95}]
[{"$f":"'Site Inputs'!$E$35","v":false},"Solar Farm - Native",null,null,null,{"$f":"VLOOKUP(B58,'Lookup Tables'!$A$12:$F$22,3,FALSE)","v":62},null,{"$f":"VLOOKUP(B58,'Lookup Tables'!$A$12:$F$22,4,FALSE)","v":76},null,{"$f":"VLOOKUP(B58,'Lookup Tables'!$A$12:$F$22,5,FALSE)","v":84},null,{"$f":"VLOOKUP(B58,'Lookup Tables'!$A$12:$F$22,6,FALSE)","v":88},0,{"$f":"IF(M66>0,M58/M66,0)","v":0},{"$f":"VLOOKUP(B58,'Lookup Tables'!$A$12:$F$22,2,FALSE)","v":0.4}]
[{"$f":"'Site Inputs'!$E$36","v":false},"Solar Farm - Gravel",null,null,null,{"$f":"VLOOKUP(B59,'Lookup Tables'!$A$12:$F$22,3,FALSE)","v":75},null,{"$f":"VLOOKUP(B59,'Lookup Tables'!$A$12:$F$22,4,FALSE)","v":84},null,{"$f":"VLOOKUP(B59,'Lookup Tables'!$A$12:$F$22,5,FALSE)","v":89},null,{"$f":"VLOOKUP(B59,'Lookup Tables'!$A$12:$F$22,6,FALSE)","v":92},0,{"$f":"IF(M66>0,M59/M66,0)","v":0},{"$f":"VLOOKUP(B59,'Lookup Tables'!$A$12:$F$22,2,FALSE)","v":0.6}]
[{"$f":"'Site Inputs'!$E$37","v":false},"Gravel - Overflow Parking Lots, Trails/Maintenance Paths, Substations",null,null,null,{"$f":"VLOOKUP(B60,'Lookup Tables'!$A$12:$F$22,3,FALSE)","v":75},null,{"$f":"VLOOKUP(B60,'Lookup Tables'!$A$12:$F$22,4,FALSE)","v":84},null,{"$f":"VLOOKUP(B60,'Lookup Tables'!$A$12:$F$22,5,FALSE)","v":89},null,{"$f":"VLOOKUP(B60,'Lookup Tables'!$A$12:$F$22,6,FALSE)","v":92},0,{"$f":"IF(M66>0,M60/M66,0)","v":0},{"$f":"VLOOKUP(B60,'Lookup Tables'!$A$12:$F$22,2,FALSE)","v":0.6}]
[{"$f":"'Site Inputs'!$E$38","v":false},"Gravel - Primary Parking Lots, Access Driveways, Railroad Ballasts",null,null,null,{"$f":"VLOOKUP(B61,'Lookup Tables'!$A$12:$F$22,3,FALSE)","v":88},null,{"$f":"VLOOKUP(B61,'Lookup Tables'!$A$12:$F$22,4,FALSE)","v":92},null,{"$f":"VLOOKUP(B61,'Lookup Tables'!$A$12:$F$22,5,FALSE)","v":94},null,{"$f":"VLOOKUP(B61,'Lookup Tables'!$A$12:$F$22,6,FALSE)","v":96},0,{"$f":"IF(M66>0,M61/M66,0)","v":0},{"$f":"VLOOKUP(B61,'Lookup Tables'!$A$12:$F$22,2,FALSE)","v":0.8}]
[{"$f":"'Site Inputs'!$E$39","v":false},"Gravel - Public Road with Compacted Subgrade Material",null,null,null,{"$f":"VLOOKUP(B62,'Lookup Tables'!$A$12:$F$22,3,FALSE)","v":98},null,{"$f":"VLOOKUP(B62,'Lookup Tables'!$A$12:$F$22,4,FALSE)","v":99},null,{"$f":"VLOOKUP(B62,'Lookup Tables'!$A$12:$F$22,5,FALSE)","v":98},null,{"$f":"VLOOKUP(B62,'Lookup Tables'!$A$12:$F$22,6,FALSE)","v":98},0,{"$f":"IF(M66>0,M62/M66,0)","v":0},{"$f":"VLOOKUP(B62,'Lookup Tables'!$A$12:$F$22,2,FALSE)","v":0.95}]
[{"$f":"'Site Inputs'!$E$40","v":false},"Artificial Turf - No Underdrain System",null,null,null,{"$f":"VLOOKUP(B63,'Lookup Tables'!$A$12:$F$22,3,FALSE)","v":66},null,{"$f":"VLOOKUP(B63,'Lookup Tables'!$A$12:$F$22,4,FALSE)","v":78},null,{"$f":"VLOOKUP(B63,'Lookup Tables'!$A$12:$F$22,5,FALSE)","v":85},null,{"$f":"VLOOKUP(B63,'Lookup Tables'!$A$12:$F$22,6,FALSE)","v":89},0,{"$f":"IF(M66>0,M63/M66,0)","v":0},{"$f":"VLOOKUP(B63,'Lookup Tables'!$A$12:$F$22,2,FALSE)","v":0.45}]
[{"$f":"$E$41","v":false},"Artificial Turf - Underdrain System",null,null,null,{"$f":"VLOOKUP(B64,'Lookup Tables'!$A$12:$F$22,3,FALSE)","v":88},null,{"$f":"VLOOKUP(B64,'Lookup Tables'!$A$12:$F$22,4,FALSE)","v":92},null,{"$f":"VLOOKUP(B64,'Lookup Tables'!$A$12:$F$22,5,FALSE)","v":94},null,{"$f":"VLOOKUP(B64,'Lookup Tables'!$A$12:$F$22,6,FALSE)","v":96},0,{"$f":"IF(M66>0,M64/M66,0)","v":0},{"$f":"VLOOKUP(B64,'Lookup Tables'!$A$12:$F$22,2,FALSE)","v":0.8}]
[{"$f":"$E$42","v":false},"Water Surfaces",null,null,null,{"$f":"VLOOKUP(B65,'Lookup Tables'!$A$12:$F$22,3,FALSE)","v":100},null,{"$f":"VLOOKUP(B65,'Lookup Tables'!$A$12:$F$22,4,FALSE)","v":100},null,{"$f":"VLOOKUP(B65,'Lookup Tables'!$A$12:$F$22,5,FALSE)","v":100},null,{"$f":"VLOOKUP(B65,'Lookup Tables'!$A$12:$F$22,6,FALSE)","v":99},0,{"$f":"IF(M66>0,M65/M66,0)","v":0},{"$f":"VLOOKUP(B65,'Lookup Tables'!$A$12:$F$22,2,FALSE)","v":1}]
[true,"Total",null,null,{"$f":"SUM(E55:E65)","v":0},null,{"$f":"SUM(G55:G65)","v":0},null,{"$f":"SUM(I55:I65)","v":0},null,{"$f":"SUM(K55:K65)","v":0},null,{"$f":"SUM(E66:K66)","v":0},{"$f":"IF(M66>0,M66/M66,0)","v":0},{"$f":"IFERROR(SUMPRODUCT(O55:O65,M55:M65)/M66,\"\")","v":""}]
[true,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(E47=\"-\",\"Input disturbed drainage area in the drainage area summary table.\",(IF(E47-M66<>0, \"Disturbed drainage area from summary table does not match.\",\"\"))),\"\")","v":""}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[true]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[true]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[true]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[true]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[true]

{"sheet":"Lookup Tables","index":3,"n_rows":80,"n_cols":12,"rows_kept":80,"cut":false,"hidden":true,"merged":[[9,2,9,5],[9,0,9,1]]}
[]
["Project Type","MS4 PT Modifier","CSS PT Modifier"]
["Site Development - New Development",0.85,1]
["Site Development - Redevelopment",0.4,0.85,null,null,null,null,null,"Ia=0.2S","Ia=0.4S","Ia=0.05S","Ia=0.4S"]
["Public Roadway Improvements - New Development",0.4,1,null,null,null,null,"CN","WQ 90% Rv","WQ 90% Rv UnDev","WQ Rv Dev.","10-yr Rv"]
["Public Roadway Improvements - Redevelopment",0.2,0.65,null,null,null,null,26,0,0,0,0]
["Utility Improvements",0,0,null,null,null,null,27,0,0,0,0]
[null,null,null,null,null,null,null,28,0,0,0,0]
[null,null,"CN = 39.168+0.585*I","CN = 60.665+0.3737*I","CN = 74.084+0.2385*I","CN = 80.45+0.1751*I",null,29,0,0,0,0]
["Post -Project Runoff Coefficients",null,"CN, Hydrologic Soil Group",null,null,null,null,30,0,0,0,0]
["Land Cover","Rv","A","B","C","D","% Impervious",31,0,0,0,0]
["Natural Area",0,30,55,70,77,{"$f":"IF((B12-0.05)/0.009<1,0,B12-0.05)/0.009","v":0},32,0,0,0,0]
["Pervious Area",0.25,39,61,74,80,{"$f":"IF((B13-0.05)/0.009<1,0,B13-0.05)/0.009","v":22.222222222222225},33,0,0,0,0]
["Impervious Area",0.95,98,98,98,98,100,34,0,0,0,0]
["Solar Farm - Native",0.4,{"$f":"ROUNDUP(IF(39.168+0.585*$G15>100,100,39.168+0.585*$G15),0)","v":62},{"$f":"ROUNDUP(IF(60.665+0.3737*$G15>100,100,60.665+0.3737*$G15),0)","v":76},{"$f":"ROUNDUP(IF(74.084+0.2385*$G15>100,100,74.084+0.2385*$G15),0)","v":84},{"$f":"ROUNDUP(IF(80.45+0.1751*$G15>100,100,80.45+0.1751*$G15),0)","v":88},38.888888888888893,35,0,0,0,0]
["Solar Farm - Gravel",0.6,75,{"$f":"ROUNDUP(IF(60.665+0.3737*$G16>100,100,60.665+0.3737*$G16),0)","v":84},{"$f":"ROUNDUP(IF(74.084+0.2385*$G16>100,100,74.084+0.2385*$G16),0)","v":89},{"$f":"ROUNDUP(IF(80.45+0.1751*$G16>100,100,80.45+0.1751*$G16),0)","v":92},61.111111111111107,36,0,0,0,0]
["Gravel - Overflow Parking Lots, Trails/Maintenance Paths, Substations",0.6,75,84,89,92,61.111111111111107,37,0,0,0,0]
["Gravel - Primary Parking Lots, Access Driveways, Railroad Ballasts",0.8,88,92,94,96,83.333333333333343,38,0,0,0,0]
["Gravel - Public Road with Compacted Subgrade Material",0.95,98,99,98,98,100,39,0,0,0,0]
["Artificial Turf - No Underdrain System",0.45,66,78,85,89,44.44444444444445,40,0,0,0,0]
["Artificial Turf - Underdrain System",0.8,88,92,94,96,83.333333333333343,41,0,0,0,0]
["Water Surfaces",1,100,100,100,99,105.55555555555556,42,0,0,0,0]
[null,null,null,null,null,null,null,43,0,0,0,1.8087855297157753E-2]
["GSI Types","Runoff Reduction","Assumption",null,null,null,null,44,0,0,0,5.7239057239057319E-2]
["Bioretention, Controlled Release",0.8," 60% (runoff reduction research)",null,null,null,null,45,0,0,0,9.4650205761316858E-2]
["Bioretention, Infiltration",1," 100% (all infiltration practices should get 100%)",null,null,null,null,46,0,0,0,0.13043478260869562]
["Permeable Pavement, Controlled Release",0.65," 30% (runoff reduction research)",null,null,null,null,47,0,0,0,0.16469661150512221]
["Permeable Pavement, Infiltration Only",1," 100% (all infiltration practices should get 100%)",null,null,null,null,48,0,0,0,0.19753086419753096]
["Infiltration Trench, Infiltration Only",1," 100% (all infiltration practices should get 100%)",null,null,null,null,49,0,0,0,0.22902494331065762]
["Infiltration Trench, Controlled Release",0.65,null,null,null,null,null,50,0,0,5.0826288116358566E-2,0.2592592592592593]
["Wetland",0.5,null,null,null,null,null,51,0,0,5.5029147374763596E-2,0.28830791575889608]
["Wet Detention Basin",0.1," 10% (of the permanent pool; summer evaporation over 3 days is less than 1 inch)",null,null,null,null,52,0,0,5.9413825414654987E-2,0.31623931623931634]
["Dry Detention Basin, Infiltration Only",1," 0% (runoff reduction research; I could live with 5-10% though)",null,null,null,null,53,0,0,6.398586367818293E-2,0.34311670160726759]
["Dry Detention Basin, Controlled Release",0.6," 100% (assuming infiltration below the outlet)",null,null,null,null,54,0,0,6.8751382124882521E-2,0.36899862825788748]
["Subsurface Storage, Infiltration Only",1," 100% (if it’s infiltration, 0% if it’s just detention)",null,null,null,null,55,0,0,7.3717105135102823E-2,0.39393939393939387]
["Subsurface Storage, Controlled Release",0.5,null,null,null,null,null,56,0,0,7.8890392239652399E-2,0.41798941798941797]
["Green Roof",1," 100% (if we use the maximum water retention instead of porosity for the volume calculation)",null,null,null,null,57,0,0,8.4279273956426703E-2,0.44119558154645866]
["Blue Roof",0.2," 20%?? (I’m assuming a blue roof will typically have less than 6” of storage and a relatively high evaporation rate)",null,null,null,null,58,0,0,8.989249309274501E-2,0.46360153256704967]
["Cistern",0.5," variable based on average 3-day drawdown.  (I have a modeling spreadsheet I can share that is a bit more complex than that)",null,null,null,null,59,0,0,9.5739551956038019E-2,0.48524795982423091]
["Sheetflow to Pervious Area",0.5,null,null,null,null,null,60,0,0,0.10183076600748979,0.50617283950617276]
["Downspout Disconnection",0.25,null,null,null,null,null,61,0,0,0.10817732459556313,0.52641165755919861]
["Sheetflow to Natural Area",1,null,null,null,null,null,62,5.8341836067289932E-3,0,0.11479135952164247,0.54599761051373952]
["Existing Trees (Preserved)",20,"ft3/tree",null,null,null,null,63,4.7361577775203119E-2,0,0.12168602232135108,0.56496178718400947]
["New Trees",10,"ft3/tree",null,null,null,null,64,8.7591240875912482E-2,0,0.12887557129597041,0.58333333333333337]
[null,null,null,null,null,null,null,65,0.12658306818890752,0,0.13637546950303922,0.60113960113960108]
["Input Value Basis",null,null,null,null,null,null,66,0.1643933249772665,0,0.14420249511867342,0.6184062850729517]
["Actual measured values based on improvement plans",null,null,null,null,null,null,67,0.20107491738388342,0,0.15237486582252791,0.63515754560530679]
["Estimated values based on development type",null,null,null,null,null,null,68,0.23667763942560008,0,0.16091237913704262,0.65141612200435739]
[null,null,null,null,null,null,null,69,0.27124839850958543,0,0.16983657098475136,0.66720343531937742]
[null,null,null,null,null,null,null,70,0.30483142161974269,0,0.17917089512216686,0.68253968253968256]
[null,null,null,null,null,null,null,71,0.33746844407890964,0,0.18894092657990871,0.6974439227960354]
["Assumed Impervious Cover",null,null,null,null,null,null,72,0.36919888258087769,0,0.19917459280350547,0.7119341563786008]
["Zoning Type","Assumed Impervious Area",null,null,null,null,null,73,0.40005999400059999,0,0.20990243686915708,0.7260273972602741]
["Single Family Residential",0.4,null,null,null,null,null,74,0.43008702132789717,0,0.22115791797065246,0.73973973973973972]
["Multifamily Residential",0.65,null,null,null,null,null,75,0.45931332792646651,2.9120068540458419E-4,0.23297775537165849,0.75308641975308632]
["Industrial",0.85,null,null,null,null,null,76,0.48777052119349484,2.55220835790796E-3,0.24540232323490779,0.76608187134502936]
["Commercial",0.9,null,null,null,null,null,77,0.5154885665834571,7.0848633363978317E-3,0.25847610523153586,0.77873977873977873]
["Other","N/A",null,null,null,null,null,78,0.54249589286085631,1.3935571342377745E-2,0.27224821967064328,0.79107312440645772]
[null,null,null,null,null,null,null,79,0.568819489359081,2.3158831955372741E-2,0.28677302816231487,0.80309423347398023]
[null,null,null,null,null,null,null,80,0.59448499594484994,3.4817772578142898E-2,0.30211084365528734,0.81481481481481488]
[null,null,null,null,null,null,null,81,0.61951678631862472,4.898476966534273E-2,0.31832875722799586,0.82624599908550533]
[null,null,null,null,null,null,null,82,0.64393804521986819,6.5742168192362116E-2,0.33550160746251767,0.83739837398373984]
[null,null,null,null,null,null,null,83,0.66777084005120224,8.5183112408941691E-2,0.35371312186476533,0.84828201695671568]
[null,null,null,null,null,null,null,84,0.69103618738655226,0.10741250337819384,0.37305726697133512,0.85890652557319225]
["GSI Material Types","Porosity",null,null,null,null,null,85,0.71375411478459982,0.13254810173535078,0.39363985298822535,0.86928104575163401]
["Bioretention Soil",0.3,null,null,null,null,null,86,0.73594371828966987,0.16072179762363153,0.4155804506964908,0.87941429801894933]
["Structural Soil",0.4,null,null,null,null,null,87,0.75762321596703686,0.19208107401737107,0.43901469383430813,0.88931460195828016]
["Sand",0.3,null,null,null,null,null,88,0.77880999778810001,0.22679069480218211,0.46409706046634591,0.89898989898989912]
["Storage Aggregate Media",0.4,null,null,null,null,null,89,0.79952067215250999,0.26503465527335263,0.49100425371289685,0.9084477736163129]
["Choker Course",0.3,null,null,null,null,null,90,0.81977110930882235,0.30701844042424892,0.51993933807616843,0.91769547325102874]
["Open Storage (Ponding Area)",1,null,null,null,null,null,91,0.83957648191224843,0.35297164589514918,0.55113683595215224,0.92673992673992667]
["Green Roof Drainage Layer",null,null,null,null,null,null,92,0.85895130293733901,0.40315102821655496,0.58486905477804596,0.93558776167471824]
["Green Roof Growing Media",null,null,null,null,null,null,93,0.87790946114468615,0.45784406562958441,0.62145400597879741,0.94424532058940669]
["Storage Chamber",null,null,null,null,null,null,94,0.89646425428379151,0.51737312911117994,0.66126540331767925,0.95271867612293148]
[null,null,null,null,null,null,null,95,0.91462842019891566,0.58210038634304695,0.70474540677533382,0.96101364522417143]
["Yes",null,null,null,null,null,null,96,0.9324141659908084,0.65243359066013884,0.7524210336556405,0.96913580246913589]
["No",null,null,null,null,null,null,97,0.94983319537462041,0.72883294439597135,0.80492553006110057,0.97709049255441005]
[null,null,null,null,null,null,null,98,0.96689673436284485,0.81181927406792753,0.86302654466115336,0.9848828420256992]
["Combined Sewer System"]
["Separate Storm Sewer System"]

{"sheet":"Drainage Tables","index":4,"n_rows":26,"n_cols":19,"rows_kept":26,"cut":false,"hidden":true,"merged":[[1,17,5,17],[1,1,1,3],[2,1,2,3],[3,1,3,3],[4,1,4,3],[5,1,5,3],[22,1,22,3],[10,1,10,3],[16,1,16,3],[17,1,17,3],[18,1,18,3],[21,1,21,3],[6,1,6,3],[7,1,7,3],[9,4,9,12],[19,1,19,3],[20,1,20,3],[11,1,11,3],[12,1,12,3],[13,1,13,3],[14,1,14,3],[15,1,15,3],[9,1,9,3]]}
[]
[true,"Individual Drainage Area Summary Table ID:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Disturbed Drainage Area (sf)"]
[true,"Is this drainage area controlled?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RRV Prior to Reductions (cf)"]
[true,"Disturbed drainage area (ft2)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RRVreductions  (cf)"]
[true,{"$f":"IF(E3=\"No\", \"Uncontrolled Retention Volume, (ft³)\", IF(AND(E3=\"Yes\", 'Site Inputs'!$E$19=\"NA\"), \"RRV Prior to Reductions, (ft³)\", IF(AND(E3=\"Yes\", 'Site Inputs'!$E$19>0), \"Adjusted RRV Prior to Reductions, (ft³)\", \"RRV Prior to Reductions, (ft³)\")))","v":"RRV Prior to Reductions, (ft³)"},null,null,{"$f":"IFERROR(IF(E3=\"Yes\",IF('Site Inputs'!$E$19=\"NA\",'Site Inputs'!$E$12/12*'Site Inputs'!$E$13*M23*O23,'Site Inputs'!$E$12/12*'Site Inputs'!$E$19*M23*O23),'Site Inputs'!$E$12/12*'Site Inputs'!$E$13*M23*O23),0)","v":0},"Equation 5602-9",null,null,null,null,null,null,null,null,null,null,null,null,"RRV After Reductions (cf)"]
[true,"Pervious Area Weighted Rv",null,null,{"$f":"IF(E3=\"No\",\"NA\",IFERROR((M12*O12+M13*O13+M15*O15+M16*O16+M17*O17+M18*O18+M20*O20+M21*O21)/(M12+M13+M15+M16+M17+M18+M20+M21),\"-\"))","v":"-"},null,null,null,null,null,null,null,null,null,null,null,null,null,"Retention Volume Achieved (cf)"]
[true,"Impervious Area Weighted Rv",null,null,{"$f":"IF(E3=\"No\",\"NA\",IFERROR((O14*M14++M19*O19+O22*M22)/(M14+M19+M22),\"-\"))","v":"-"}]
[true,"Post-Project Condition Weighted CN",null,null,{"$f":"IFERROR((SUMPRODUCT(E12:E22,F12:F22)+SUMPRODUCT(G12:G22,H12:H22)+SUMPRODUCT(I12:I22,J12:J22)+SUMPRODUCT(K12:K22,L12:L22))/M23,\"-\")","v":"-"}]
[true]
[true,{"$f":"\"Post-Project Cover Type Area Table for Drainage Area \"&E2","v":"Post-Project Cover Type Area Table for Drainage Area "},null,null,"Area (ft2)"]
[true,"Cover Type",null,null,"Soil Type A","CN","Soil Type B","CN","Soil Type C","CN","Soil Type D","CN","Total","% Cover","Rv"]
[{"$f":"'Site Inputs'!$E$32","v":false},"Natural Area",null,null,null,{"$f":"VLOOKUP(B12,'Lookup Tables'!$A$12:$F$22,3,FALSE)","v":30},null,{"$f":"VLOOKUP(B12,'Lookup Tables'!$A$12:$F$22,4,FALSE)","v":55},null,{"$f":"VLOOKUP(B12,'Lookup Tables'!$A$12:$F$22,5,FALSE)","v":70},null,{"$f":"VLOOKUP(B12,'Lookup Tables'!$A$12:$F$22,6,FALSE)","v":77},{"$f":"E12+G12+I12+K12","v":0},{"$f":"IF(M23>0,M12/M23,0)","v":0},{"$f":"VLOOKUP(B12,'Lookup Tables'!$A$12:$F$22,2,FALSE)","v":0}]
[{"$f":"'Site Inputs'!$E$33","v":false},"Pervious Area",null,null,null,{"$f":"VLOOKUP(B13,'Lookup Tables'!$A$12:$F$22,3,FALSE)","v":39},null,{"$f":"VLOOKUP(B13,'Lookup Tables'!$A$12:$F$22,4,FALSE)","v":61},null,{"$f":"VLOOKUP(B13,'Lookup Tables'!$A$12:$F$22,5,FALSE)","v":74},null,{"$f":"VLOOKUP(B13,'Lookup Tables'!$A$12:$F$22,6,FALSE)","v":80},{"$f":"E13+G13+I13+K13","v":0},{"$f":"IF(M23>0,M13/M23,0)","v":0},{"$f":"VLOOKUP(B13,'Lookup Tables'!$A$12:$F$22,2,FALSE)","v":0.25}]
[{"$f":"'Site Inputs'!$E$34","v":false},"Impervious Area",null,null,null,{"$f":"VLOOKUP(B14,'Lookup Tables'!$A$12:$F$22,3,FALSE)","v":98},null,{"$f":"VLOOKUP(B14,'Lookup Tables'!$A$12:$F$22,4,FALSE)","v":98},null,{"$f":"VLOOKUP(B14,'Lookup Tables'!$A$12:$F$22,5,FALSE)","v":98},null,{"$f":"VLOOKUP(B14,'Lookup Tables'!$A$12:$F$22,6,FALSE)","v":98},0,{"$f":"IF(M23>0,M14/M23,0)","v":0},{"$f":"VLOOKUP(B14,'Lookup Tables'!$A$12:$F$22,2,FALSE)","v":0.95}]
[{"$f":"'Site Inputs'!$E$35","v":false},"Solar Farm - Native",null,null,null,{"$f":"VLOOKUP(B15,'Lookup Tables'!$A$12:$F$22,3,FALSE)","v":62},null,{"$f":"VLOOKUP(B15,'Lookup Tables'!$A$12:$F$22,4,FALSE)","v":76},null,{"$f":"VLOOKUP(B15,'Lookup Tables'!$A$12:$F$22,5,FALSE)","v":84},null,{"$f":"VLOOKUP(B15,'Lookup Tables'!$A$12:$F$22,6,FALSE)","v":88},0,{"$f":"IF(M23>0,M15/M23,0)","v":0},{"$f":"VLOOKUP(B15,'Lookup Tables'!$A$12:$F$22,2,FALSE)","v":0.4}]
[{"$f":"'Site Inputs'!$E$36","v":false},"Solar Farm - Gravel",null,null,null,{"$f":"VLOOKUP(B16,'Lookup Tables'!$A$12:$F$22,3,FALSE)","v":75},null,{"$f":"VLOOKUP(B16,'Lookup Tables'!$A$12:$F$22,4,FALSE)","v":84},null,{"$f":"VLOOKUP(B16,'Lookup Tables'!$A$12:$F$22,5,FALSE)","v":89},null,{"$f":"VLOOKUP(B16,'Lookup Tables'!$A$12:$F$22,6,FALSE)","v":92},0,{"$f":"IF(M23>0,M16/M23,0)","v":0},{"$f":"VLOOKUP(B16,'Lookup Tables'!$A$12:$F$22,2,FALSE)","v":0.6}]
[{"$f":"'Site Inputs'!$E$37","v":false},"Gravel - Overflow Parking Lots, Trails/Maintenance Paths, Substations",null,null,null,{"$f":"VLOOKUP(B17,'Lookup Tables'!$A$12:$F$22,3,FALSE)","v":75},null,{"$f":"VLOOKUP(B17,'Lookup Tables'!$A$12:$F$22,4,FALSE)","v":84},null,{"$f":"VLOOKUP(B17,'Lookup Tables'!$A$12:$F$22,5,FALSE)","v":89},null,{"$f":"VLOOKUP(B17,'Lookup Tables'!$A$12:$F$22,6,FALSE)","v":92},0,{"$f":"IF(M23>0,M17/M23,0)","v":0},{"$f":"VLOOKUP(B17,'Lookup Tables'!$A$12:$F$22,2,FALSE)","v":0.6}]
[{"$f":"'Site Inputs'!$E$38","v":false},"Gravel - Primary Parking Lots, Access Driveways, Railroad Ballasts",null,null,null,{"$f":"VLOOKUP(B18,'Lookup Tables'!$A$12:$F$22,3,FALSE)","v":88},null,{"$f":"VLOOKUP(B18,'Lookup Tables'!$A$12:$F$22,4,FALSE)","v":92},null,{"$f":"VLOOKUP(B18,'Lookup Tables'!$A$12:$F$22,5,FALSE)","v":94},null,{"$f":"VLOOKUP(B18,'Lookup Tables'!$A$12:$F$22,6,FALSE)","v":96},0,{"$f":"IF(M23>0,M18/M23,0)","v":0},{"$f":"VLOOKUP(B18,'Lookup Tables'!$A$12:$F$22,2,FALSE)","v":0.8}]
[{"$f":"'Site Inputs'!$E$39","v":false},"Gravel - Public Road with Compacted Subgrade Material",null,null,null,{"$f":"VLOOKUP(B19,'Lookup Tables'!$A$12:$F$22,3,FALSE)","v":98},null,{"$f":"VLOOKUP(B19,'Lookup Tables'!$A$12:$F$22,4,FALSE)","v":99},null,{"$f":"VLOOKUP(B19,'Lookup Tables'!$A$12:$F$22,5,FALSE)","v":98},null,{"$f":"VLOOKUP(B19,'Lookup Tables'!$A$12:$F$22,6,FALSE)","v":98},0,{"$f":"IF(M23>0,M19/M23,0)","v":0},{"$f":"VLOOKUP(B19,'Lookup Tables'!$A$12:$F$22,2,FALSE)","v":0.95}]
[{"$f":"'Site Inputs'!$E$40","v":false},"Artificial Turf - No Underdrain System",null,null,null,{"$f":"VLOOKUP(B20,'Lookup Tables'!$A$12:$F$22,3,FALSE)","v":66},null,{"$f":"VLOOKUP(B20,'Lookup Tables'!$A$12:$F$22,4,FALSE)","v":78},null,{"$f":"VLOOKUP(B20,'Lookup Tables'!$A$12:$F$22,5,FALSE)","v":85},null,{"$f":"VLOOKUP(B20,'Lookup Tables'!$A$12:$F$22,6,FALSE)","v":89},0,{"$f":"IF(M23>0,M20/M23,0)","v":0},{"$f":"VLOOKUP(B20,'Lookup Tables'!$A$12:$F$22,2,FALSE)","v":0.45}]
[{"$f":"'Site Inputs'!$E$41","v":false},"Artificial Turf - Underdrain System",null,null,null,{"$f":"VLOOKUP(B21,'Lookup Tables'!$A$12:$F$22,3,FALSE)","v":88},null,{"$f":"VLOOKUP(B21,'Lookup Tables'!$A$12:$F$22,4,FALSE)","v":92},null,{"$f":"VLOOKUP(B21,'Lookup Tables'!$A$12:$F$22,5,FALSE)","v":94},null,{"$f":"VLOOKUP(B21,'Lookup Tables'!$A$12:$F$22,6,FALSE)","v":96},0,{"$f":"IF(M23>0,M21/M23,0)","v":0},{"$f":"VLOOKUP(B21,'Lookup Tables'!$A$12:$F$22,2,FALSE)","v":0.8}]
[{"$f":"'Site Inputs'!$E$42","v":false},"Water Surfaces",null,null,null,{"$f":"VLOOKUP(B22,'Lookup Tables'!$A$12:$F$22,3,FALSE)","v":100},null,{"$f":"VLOOKUP(B22,'Lookup Tables'!$A$12:$F$22,4,FALSE)","v":100},null,{"$f":"VLOOKUP(B22,'Lookup Tables'!$A$12:$F$22,5,FALSE)","v":100},null,{"$f":"VLOOKUP(B22,'Lookup Tables'!$A$12:$F$22,6,FALSE)","v":99},0,{"$f":"IF(M23>0,M22/M23,0)","v":0},{"$f":"VLOOKUP(B22,'Lookup Tables'!$A$12:$F$22,2,FALSE)","v":1}]
[true,"Total",null,null,{"$f":"SUM(E12:E22)","v":0},null,{"$f":"SUM(G12:G22)","v":0},null,{"$f":"SUM(I12:I22)","v":0},null,{"$f":"SUM(K12:K22)","v":0},null,{"$f":"SUM(E23:K23)","v":0},{"$f":"IF(M23>0,M23/M23,0)","v":0},{"$f":"IFERROR(SUMPRODUCT(O12:O22,M12:M22)/M23,\"\")","v":""}]
[true,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(E4=\"-\",\"Input disturbed drainage area in the drainage area summary table.\",(IF(E4-M23<>0, \"Disturbed drainage area from summary table does not match.\",\"\"))),\"\")","v":""}]
[true]
[true]

{"sheet":"DA #","index":5,"n_rows":854,"n_cols":46,"rows_kept":854,"cut":false,"hidden":true,"merged":[[42,44,43,44],[42,43,43,43],[19,1,19,2],[3,1,3,2],[4,1,4,2],[5,1,5,2],[6,1,6,2],[7,1,7,2],[8,1,8,2],[9,1,9,2],[14,1,14,2],[15,1,15,2],[16,1,16,2],[17,1,17,2],[36,1,36,2],[20,1,20,2],[21,1,21,2],[38,1,38,2],[39,1,39,2],[42,1,43,1],[42,2,43,2],[23,1,23,2],[24,1,24,2],[25,1,25,2],[30,1,30,3],[31,1,31,2],[32,1,32,2],[33,1,33,2],[34,1,34,2],[35,1,35,2],[37,1,37,2],[42,3,43,3],[42,42,43,42],[67,1,67,2],[68,1,68,2],[83,1,83,2],[42,36,42,39],[42,41,43,41],[42,20,42,23],[42,24,42,27],[42,28,42,31],[42,32,42,35],[42,6,43,6],[42,7,43,7],[42,8,43,8],[42,9,42,11],[42,12,42,15],[42,16,42,19],[66,1,66,2],[84,1,84,2],[92,1,92,2],[93,1,93,2],[85,1,85,2],[86,1,86,2],[87,1,87,2],[90,1,90,2],[91,1,91,2]]}
[]
[null,{"$f":"\"Design Worksheet for Drainage Area \"&D4&\"\"","v":"Design Worksheet for Drainage Area "}]
[]
[null,"Drainage Area ID"]
[null,"Is this drainage area controlled?",null,null,{"$f":"IF(D5=\"No\",\"Check input in the Drainage Area Summary Table in the Summary sheet. If this drainage area is truly meant to be uncontrolled, delete this tab.\",\"\")","v":""}]
[null,"Disturbed drainage area (ft2)",null,null,{"$f":"IF(D6=\"-\",\"Input the disturbed drainage area in the Drainage Area Summary Table in the Summary sheet.\",\"\")","v":""}]
[null,{"$f":"IF('Site Inputs'!$E$19=\"NA\",\"RRV Prior to Reductions, (ft³)\", \"Adjusted RRV Prior to Reductions, (ft³)\")","v":"RRV Prior to Reductions, (ft³)"},null,null,{"$f":"IF(D7=\"-\",\"Complete cover type area calcuations for this drainage area in the Summary sheet.\",\"\")","v":""}]
[null,"Pervious Area Weighted Rv"]
[null,"Impervious Area Weighted Rv"]
[null,"Post-Project Condition Weighted CN"]
[]
[]
[null,"Required Retention Volume Reductions (RRVReductions)"]
[]
[null,"Preservation/Restoration, & Disconnection RRVreductions",null,"Natural or Pervious Area Footprint (ft2)","Pervious Tributary Area (ft2) \n(PTributary Area)","Impervious Tributary Area (ft2)\n(ITributary Area)","Runoff Reduction Credit","Retention Volume Credited (ft3)\nRRVreduction"]
[null,"Sheetflow to Natural Area",null,null,null,null,{"$f":"VLOOKUP(B16,'Lookup Tables'!$A$25:$B$249,2,FALSE)","v":1},{"$f":"IFERROR((IF(D16>0.5*(F16+E16),'Site Inputs'!$E$13/12*(0.95*F16)*G16,0)),0)","v":0},"Equations 5602-1 and 5602-2"]
[null,"Sheetflow to Pervious Area",null,null,null,null,{"$f":"VLOOKUP(B17,'Lookup Tables'!$A$25:$B$249,2,FALSE)","v":0.5},{"$f":"IFERROR(IF(D17>F17,'Site Inputs'!$E$13/12*(0.95*F17)*G17,0),0)","v":0},"Equations 5602-3 and 5602-4"]
[null,"Downspout Disconnection",null,null,null,null,{"$f":"VLOOKUP(B18,'Lookup Tables'!$A$25:$B$249,2,FALSE)","v":0.25},{"$f":"IFERROR(IF(D18>F18,'Site Inputs'!$E$12/12*(0.95*F18)*G18,0),0)","v":0},"Equations 5602-5 and 5602-6"]
[]
[null,"Tree RRVreductions",null,"Number of Trees (Each)","Runoff Reduction Credit (ft3/tree)","Retention Volume Credited (ft3)\nRRVreduction"]
[null,"Existing Trees (Preserved)",null,null,{"$f":"VLOOKUP(B21,Table1[[GSI Types]:[Runoff Reduction]],2,FALSE)","v":20},{"$f":"IF(E21*D21=0,0,E21*D21)","v":0},"Equation 5602-7"]
[null,"New Trees",null,null,{"$f":"VLOOKUP(B22,Table1[[GSI Types]:[Runoff Reduction]],2,FALSE)","v":10},{"$f":"IF(E22*D22=0,0,E22*D22)","v":0},"Equation 5602-8"]
[]
[null,"Total Reductions applied to RRV (RRVreduction), ft3",null,{"$f":"SUM(H16:H18)+SUM(F21:F22)","v":0},"Equation 5602-17"]
[null,"RRV After Reductions (RRVDA#), ft3",null,{"$f":"IFERROR($D$7-D24,0)","v":0},"Equation 5602-18"]
[null,"% Reduction in RRV",null,{"$f":"IFERROR(($D$7-D25)/$D$7,0)","v":0}]
[]
[]
[null,"Retention Practices"]
[]
[null,"Select material types and storage layers used for this design:"]
[null,"Open Storage (Ponding Area)",null,false]
[null,"Bioretention Soil",null,false]
[null,"Structural Soil",null,false]
[null,"Sand",null,false]
[null,"Storage Aggregate Media",null,false]
[null,"Choker Course",null,false]
[null,"Green Roof Drainage Layer",null,false]
[null,"Green Roof Growing Media",null,false]
[null,"Storage Chamber(s)",null,false,null,{"$f":"IF('Site Inputs'!E19=\"NA\",\"PT%\",\"Adjusted PT%\")","v":"PT%"},{"$f":"IF('Site Inputs'!E19=\"NA\",'Site Inputs'!E13,'Site Inputs'!E19)","v":0}]
[]
[null,null,null,null,null,null,null,"Equation 5605-1",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,null,null,null,null,null,null,"Equation 5605-2 ","Table 5605-1"]
[null,"Retention Facility ID","Practice","Downstream Retention Facility ID","Pervious Drainage Area","Impervious Drainage Area","Target RRV Prior to Reductions) \n(ft3)","Retention Volume Provided (ft3) (VR)","Bypass RRV (ft3)","Open Storage (Ponding)",null,null,"Bioretention Soil",null,null,null,"Structural Soil",null,null,null,"Sand",null,null,null,"Storage Aggregate Media",null,null,null,"Choker Course",null,null,null,"Green Roof Drainage Layer",null,null,null,"Green Roof Growing Media",null,null,null,"Storage Chamber","Total Static Storage  Volume (ft3) (GSIstorage)","Runoff Reduction Factor (%) (GSIRRF)","Retention Volume Provided (ft3) (VR)","Maximum Retention Credit Allowed (ft3)"]
[null,null,null,null,"(ft2)","(ft2)",null,null,null,"Area (ft2)\nAp","Height (ft)\nhp","Volume (ft3)\nVP ","Area (ft2)\nAm","n","Height (ft)\nhm","Volume (ft3)\nVm ","Area (ft2)\nAm","n","Height (ft)\nhm","Volume (ft3)\nVm ","Area (ft2)\nAm","n","Height (ft)\nhm","Volume (ft3)\nVm ","Area (ft2)\nAm","n","Height (ft)\nhm","Volume (ft3)\nVm ","Area (ft2)\nAm","n","Height (ft)\nhm","Volume (ft3)\nVm ","Area (ft2)\nAm","n","Height (ft)\nhm","Volume (ft3)\nVm ","Area (ft2)\nAm","n","Height (ft)\nhm","Volume (ft3)\nVm ","Volume (ft3)\nVs"]
[null,null,null,null,null,null,{"$f":"IFERROR(($G$40*'Site Inputs'!$E$12/12*(E45*$D$8+F45*$D$9)+IFERROR(SUMIF($D$45:$D$64,B45,$I$45:$I$64),0)),0)","v":0},{"$f":"IFERROR(MIN(AQ45*AP45,AS45),0)","v":0},{"$f":"IF(G45-H45>0,G45-H45,\"\")","v":""},null,null,{"$f":"+IF(J45=\"\",\"0\",J45*1*K45)","v":"0"},null,{"$f":"IFERROR(VLOOKUP(M$43,'Lookup Tables'!$A$66:$B$73,2,FALSE),\"\")","v":0.3},null,{"$f":"+IF(M45=\"\",\"0\",M45*N45*O45)","v":"0"},null,{"$f":"IFERROR(VLOOKUP(Q$43,'Lookup Tables'!$A$66:$B$73,2,FALSE),\"\")","v":0.4},null,{"$f":"+IF(Q45=\"\",\"0\",Q45*R45*S45)","v":"0"},null,{"$f":"IFERROR(VLOOKUP(U$43,'Lookup Tables'!$A$66:$B$73,2,FALSE),\"\")","v":0.3},null,{"$f":"+IF(U45=\"\",\"0\",U45*V45*W45)","v":"0"},null,{"$f":"IFERROR(VLOOKUP(Y$43,'Lookup Tables'!$A$66:$B$73,2,FALSE),\"\")","v":0.4},null,{"$f":"+IF(Y45=\"\",\"0\",Y45*Z45*AA45)","v":"0"},null,{"$f":"IFERROR(VLOOKUP(AC$43,'Lookup Tables'!$A$66:$B$73,2,FALSE),\"\")","v":0.3},null,{"$f":"+IF(AC45=\"\",\"0\",AC45*AD45*AE45)","v":"0"},null,null,null,{"$f":"+IF(AG45=\"\",\"0\",AG45*AH45*AI45)","v":"0"},null,null,null,{"$f":"+IF(AK45=\"\",\"0\",AK45*AL45*AM45)","v":"0"},null,{"$f":"+IFERROR((L45+X45+T45+P45+AB45+AF45+AJ45+AO45+AN45),\"\")","v":0},{"$f":"IFERROR(VLOOKUP(C45,'Lookup Tables'!$A$25:$B$197,2,FALSE),\"\")","v":""},{"$f":"IFERROR(AP45*AQ45,\"\")","v":""},{"$f":"IFERROR(('Site Inputs'!$E$12/12*(E45*$D$8+F45*$D$9)+IFERROR(SUMIF($D$45:$D$64,B45,$I$45:$I$64),0)),0)","v":0},{"$f":"IF(AR45=\"\",\"\",IF(AR45>AS45*1.1,\"Facility size is larger than needed to meet the Required Retention Volume. Consider adjusting the design parameters to more closely right-size this facility. Credit will only be given for up to the maximum retention credit allowed based on the WQv.\",\"\"))","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(($G$40*'Site Inputs'!$E$12/12*(E46*$D$8+F46*$D$9)+IFERROR(SUMIF($D$45:$D$64,B46,$I$45:$I$64),0)),0)","v":0},{"$f":"IFERROR(MIN(AQ46*AP46,AS46),0)","v":0},{"$f":"IF(G46-H46>0,G46-H46,\"\")","v":""},null,null,{"$f":"+IF(J46=\"\",\"0\",J46*1*K46)","v":"0"},null,{"$f":"IFERROR(VLOOKUP(M$43,'Lookup Tables'!$A$66:$B$73,2,FALSE),\"\")","v":0.3},null,{"$f":"+IF(M46=\"\",\"0\",M46*N46*O46)","v":"0"},null,{"$f":"IFERROR(VLOOKUP(Q$43,'Lookup Tables'!$A$66:$B$73,2,FALSE),\"\")","v":0.4},null,{"$f":"+IF(Q46=\"\",\"0\",Q46*R46*S46)","v":"0"},null,{"$f":"IFERROR(VLOOKUP(U$43,'Lookup Tables'!$A$66:$B$73,2,FALSE),\"\")","v":0.3},null,{"$f":"+IF(U46=\"\",\"0\",U46*V46*W46)","v":"0"},null,{"$f":"IFERROR(VLOOKUP(Y$43,'Lookup Tables'!$A$66:$B$73,2,FALSE),\"\")","v":0.4},null,{"$f":"+IF(Y46=\"\",\"0\",Y46*Z46*AA46)","v":"0"},null,{"$f":"IFERROR(VLOOKUP(AC$43,'Lookup Tables'!$A$66:$B$73,2,FALSE),\"\")","v":0.3},null,{"$f":"+IF(AC46=\"\",\"0\",AC46*AD46*AE46)","v":"0"},null,null,null,{"$f":"+IF(AG46=\"\",\"0\",AG46*AH46*AI46)","v":"0"},null,null,null,{"$f":"+IF(AK46=\"\",\"0\",AK46*AL46*AM46)","v":"0"},null,{"$f":"+IFERROR((L46+X46+T46+P46+AB46+AF46+AJ46+AO46+AN46),\"\")","v":0},{"$f":"IFERROR(VLOOKUP(C46,'Lookup Tables'!$A$25:$B$197,2,FALSE),\"\")","v":""},{"$f":"IFERROR(AP46*AQ46,\"\")","v":""},{"$f":"IFERROR(('Site Inputs'!$E$12/12*(E46*$D$8+F46*$D$9)+IFERROR(SUMIF($D$45:$D$64,B46,$I$45:$I$64),0)),0)","v":0},{"$f":"IF(AR46=\"\",\"\",IF(AR46>AS46*1.1,\"Facility size is larger than needed to meet the Required Retention Volume. Consider adjusting the design parameters to more closely right-size this facility. Credit will only be given for up to the maximum retention credit allowed based on the WQv.\",\"\"))","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(($G$40*'Site Inputs'!$E$12/12*(E47*$D$8+F47*$D$9)+IFERROR(SUMIF($D$45:$D$64,B47,$I$45:$I$64),0)),0)","v":0},0,"",null,null,{"$f":"+IF(J47=\"\",\"0\",J47*1*K47)","v":"0"},null,{"$f":"IFERROR(VLOOKUP(M$43,'Lookup Tables'!$A$66:$B$73,2,FALSE),\"\")","v":0.3},null,{"$f":"+IF(M47=\"\",\"0\",M47*N47*O47)","v":"0"},null,{"$f":"IFERROR(VLOOKUP(Q$43,'Lookup Tables'!$A$66:$B$73,2,FALSE),\"\")","v":0.4},null,{"$f":"+IF(Q47=\"\",\"0\",Q47*R47*S47)","v":"0"},null,{"$f":"IFERROR(VLOOKUP(U$43,'Lookup Tables'!$A$66:$B$73,2,FALSE),\"\")","v":0.3},null,{"$f":"+IF(U47=\"\",\"0\",U47*V47*W47)","v":"0"},null,{"$f":"IFERROR(VLOOKUP(Y$43,'Lookup Tables'!$A$66:$B$73,2,FALSE),\"\")","v":0.4},null,{"$f":"+IF(Y47=\"\",\"0\",Y47*Z47*AA47)","v":"0"},null,{"$f":"IFERROR(VLOOKUP(AC$43,'Lookup Tables'!$A$66:$B$73,2,FALSE),\"\")","v":0.3},null,{"$f":"+IF(AC47=\"\",\"0\",AC47*AD47*AE47)","v":"0"},null,null,null,{"$f":"+IF(AG47=\"\",\"0\",AG47*AH47*AI47)","v":"0"},null,null,null,{"$f":"+IF(AK47=\"\",\"0\",AK47*AL47*AM47)","v":"0"},null,{"$f":"+IFERROR((L47+X47+T47+P47+AB47+AF47+AJ47+AO47+AN47),\"\")","v":0},{"$f":"IFERROR(VLOOKUP(C47,'Lookup Tables'!$A$25:$B$197,2,FALSE),\"\")","v":""},"",{"$f":"IFERROR(('Site Inputs'!$E$12/12*(E47*$D$8+F47*$D$9)+IFERROR(SUMIF($D$45:$D$64,B47,$I$45:$I$64),0)),0)","v":0},""]
[null,null,null,null,null,null,{"$f":"IFERROR(($G$40*'Site Inputs'!$E$12/12*(E48*$D$8+F48*$D$9)+IFERROR(SUMIF($D$45:$D$64,B48,$I$45:$I$64),0)),0)","v":0},0,"",null,null,{"$f":"+IF(J48=\"\",\"0\",J48*1*K48)","v":"0"},null,{"$f":"IFERROR(VLOOKUP(M$43,'Lookup Tables'!$A$66:$B$73,2,FALSE),\"\")","v":0.3},null,{"$f":"+IF(M48=\"\",\"0\",M48*N48*O48)","v":"0"},null,{"$f":"IFERROR(VLOOKUP(Q$43,'Lookup Tables'!$A$66:$B$73,2,FALSE),\"\")","v":0.4},null,{"$f":"+IF(Q48=\"\",\"0\",Q48*R48*S48)","v":"0"},null,{"$f":"IFERROR(VLOOKUP(U$43,'Lookup Tables'!$A$66:$B$73,2,FALSE),\"\")","v":0.3},null,{"$f":"+IF(U48=\"\",\"0\",U48*V48*W48)","v":"0"},null,{"$f":"IFERROR(VLOOKUP(Y$43,'Lookup Tables'!$A$66:$B$73,2,FALSE),\"\")","v":0.4},null,{"$f":"+IF(Y48=\"\",\"0\",Y48*Z48*AA48)","v":"0"},null,{"$f":"IFERROR(VLOOKUP(AC$43,'Lookup Tables'!$A$66:$B$73,2,FALSE),\"\")","v":0.3},null,{"$f":"+IF(AC48=\"\",\"0\",AC48*AD48*AE48)","v":"0"},null,null,null,{"$f":"+IF(AG48=\"\",\"0\",AG48*AH48*AI48)","v":"0"},null,null,null,{"$f":"+IF(AK48=\"\",\"0\",AK48*AL48*AM48)","v":"0"},null,{"$f":"+IFERROR((L48+X48+T48+P48+AB48+AF48+AJ48+AO48+AN48),\"\")","v":0},{"$f":"IFERROR(VLOOKUP(C48,'Lookup Tables'!$A$25:$B$197,2,FALSE),\"\")","v":""},"",{"$f":"IFERROR(('Site Inputs'!$E$12/12*(E48*$D$8+F48*$D$9)+IFERROR(SUMIF($D$45:$D$64,B48,$I$45:$I$64),0)),0)","v":0},""]
[null,null,null,null,null,null,{"$f":"IFERROR(($G$40*'Site Inputs'!$E$12/12*(E49*$D$8+F49*$D$9)+IFERROR(SUMIF($D$45:$D$64,B49,$I$45:$I$64),0)),0)","v":0},0,"",null,null,{"$f":"+IF(J49=\"\",\"0\",J49*1*K49)","v":"0"},null,{"$f":"IFERROR(VLOOKUP(M$43,'Lookup Tables'!$A$66:$B$73,2,FALSE),\"\")","v":0.3},null,{"$f":"+IF(M49=\"\",\"0\",M49*N49*O49)","v":"0"},null,{"$f":"IFERROR(VLOOKUP(Q$43,'Lookup Tables'!$A$66:$B$73,2,FALSE),\"\")","v":0.4},null,{"$f":"+IF(Q49=\"\",\"0\",Q49*R49*S49)","v":"0"},null,{"$f":"IFERROR(VLOOKUP(U$43,'Lookup Tables'!$A$66:$B$73,2,FALSE),\"\")","v":0.3},null,{"$f":"+IF(U49=\"\",\"0\",U49*V49*W49)","v":"0"},null,{"$f":"IFERROR(VLOOKUP(Y$43,'Lookup Tables'!$A$66:$B$73,2,FALSE),\"\")","v":0.4},null,{"$f":"+IF(Y49=\"\",\"0\",Y49*Z49*AA49)","v":"0"},null,{"$f":"IFERROR(VLOOKUP(AC$43,'Lookup Tables'!$A$66:$B$73,2,FALSE),\"\")","v":0.3},null,{"$f":"+IF(AC49=\"\",\"0\",AC49*AD49*AE49)","v":"0"},null,null,null,{"$f":"+IF(AG49=\"\",\"0\",AG49*AH49*AI49)","v":"0"},null,null,null,{"$f":"+IF(AK49=\"\",\"0\",AK49*AL49*AM49)","v":"0"},null,{"$f":"+IFERROR((L49+X49+T49+P49+AB49+AF49+AJ49+AO49+AN49),\"\")","v":0},{"$f":"IFERROR(VLOOKUP(C49,'Lookup Tables'!$A$25:$B$197,2,FALSE),\"\")","v":""},"",{"$f":"IFERROR(('Site Inputs'!$E$12/12*(E49*$D$8+F49*$D$9)+IFERROR(SUMIF($D$45:$D$64,B49,$I$45:$I$64),0)),0)","v":0},""]
[null,null,null,null,null,null,{"$f":"IFERROR(($G$40*'Site Inputs'!$E$12/12*(E50*$D$8+F50*$D$9)+IFERROR(SUMIF($D$45:$D$64,B50,$I$45:$I$64),0)),0)","v":0},0,"",null,null,{"$f":"+IF(J50=\"\",\"0\",J50*1*K50)","v":"0"},null,{"$f":"IFERROR(VLOOKUP(M$43,'Lookup Tables'!$A$66:$B$73,2,FALSE),\"\")","v":0.3},null,{"$f":"+IF(M50=\"\",\"0\",M50*N50*O50)","v":"0"},null,{"$f":"IFERROR(VLOOKUP(Q$43,'Lookup Tables'!$A$66:$B$73,2,FALSE),\"\")","v":0.4},null,{"$f":"+IF(Q50=\"\",\"0\",Q50*R50*S50)","v":"0"},null,{"$f":"IFERROR(VLOOKUP(U$43,'Lookup Tables'!$A$66:$B$73,2,FALSE),\"\")","v":0.3},null,{"$f":"+IF(U50=\"\",\"0\",U50*V50*W50)","v":"0"},null,{"$f":"IFERROR(VLOOKUP(Y$43,'Lookup Tables'!$A$66:$B$73,2,FALSE),\"\")","v":0.4},null,{"$f":"+IF(Y50=\"\",\"0\",Y50*Z50*AA50)","v":"0"},null,{"$f":"IFERROR(VLOOKUP(AC$43,'Lookup Tables'!$A$66:$B$73,2,FALSE),\"\")","v":0.3},null,{"$f":"+IF(AC50=\"\",\"0\",AC50*AD50*AE50)","v":"0"},null,null,null,{"$f":"+IF(AG50=\"\",\"0\",AG50*AH50*AI50)","v":"0"},null,null,null,{"$f":"+IF(AK50=\"\",\"0\",AK50*AL50*AM50)","v":"0"},null,{"$f":"+IFERROR((L50+X50+T50+P50+AB50+AF50+AJ50+AO50+AN50),\"\")","v":0},{"$f":"IFERROR(VLOOKUP(C50,'Lookup Tables'!$A$25:$B$197,2,FALSE),\"\")","v":""},"",{"$f":"IFERROR(('Site Inputs'!$E$12/12*(E50*$D$8+F50*$D$9)+IFERROR(SUMIF($D$45:$D$64,B50,$I$45:$I$64),0)),0)","v":0},""]
[null,null,null,null,null,null,{"$f":"IFERROR(($G$40*'Site Inputs'!$E$12/12*(E51*$D$8+F51*$D$9)+IFERROR(SUMIF($D$45:$D$64,B51,$I$45:$I$64),0)),0)","v":0},0,"",null,null,"0",null,{"$f":"IFERROR(VLOOKUP(M$43,'Lookup Tables'!$A$66:$B$73,2,FALSE),\"\")","v":0.3},null,"0",null,{"$f":"IFERROR(VLOOKUP(Q$43,'Lookup Tables'!$A$66:$B$73,2,FALSE),\"\")","v":0.4},null,"0",null,{"$f":"IFERROR(VLOOKUP(U$43,'Lookup Tables'!$A$66:$B$73,2,FALSE),\"\")","v":0.3},null,"0",null,{"$f":"IFERROR(VLOOKUP(Y$43,'Lookup Tables'!$A$66:$B$73,2,FALSE),\"\")","v":0.4},null,"0",null,{"$f":"IFERROR(VLOOKUP(AC$43,'Lookup Tables'!$A$66:$B$73,2,FALSE),\"\")","v":0.3},null,"0",null,null,null,"0",null,null,null,"0",null,0,{"$f":"IFERROR(VLOOKUP(C51,'Lookup Tables'!$A$25:$B$197,2,FALSE),\"\")","v":""},"",{"$f":"IFERROR(('Site Inputs'!$E$12/12*(E51*$D$8+F51*$D$9)+IFERROR(SUMIF($D$45:$D$64,B51,$I$45:$I$64),0)),0)","v":0},""]
[null,null,null,null,null,null,{"$f":"IFERROR(($G$40*'Site Inputs'!$E$12/12*(E52*$D$8+F52*$D$9)+IFERROR(SUMIF($D$45:$D$64,B52,$I$45:$I$64),0)),0)","v":0},0,"",null,null,"0",null,{"$f":"IFERROR(VLOOKUP(M$43,'Lookup Tables'!$A$66:$B$73,2,FALSE),\"\")","v":0.3},null,"0",null,{"$f":"IFERROR(VLOOKUP(Q$43,'Lookup Tables'!$A$66:$B$73,2,FALSE),\"\")","v":0.4},null,"0",null,{"$f":"IFERROR(VLOOKUP(U$43,'Lookup Tables'!$A$66:$B$73,2,FALSE),\"\")","v":0.3},null,"0",null,{"$f":"IFERROR(VLOOKUP(Y$43,'Lookup Tables'!$A$66:$B$73,2,FALSE),\"\")","v":0.4},null,"0",null,{"$f":"IFERROR(VLOOKUP(AC$43,'Lookup Tables'!$A$66:$B$73,2,FALSE),\"\")","v":0.3},null,"0",null,null,null,"0",null,null,null,"0",null,0,{"$f":"IFERROR(VLOOKUP(C52,'Lookup Tables'!$A$25:$B$197,2,FALSE),\"\")","v":""},"",{"$f":"IFERROR(('Site Inputs'!$E$12/12*(E52*$D$8+F52*$D$9)+IFERROR(SUMIF($D$45:$D$64,B52,$I$45:$I$64),0)),0)","v":0},""]
[null,null,null,null,null,null,{"$f":"IFERROR(($G$40*'Site Inputs'!$E$12/12*(E53*$D$8+F53*$D$9)+IFERROR(SUMIF($D$45:$D$64,B53,$I$45:$I$64),0)),0)","v":0},0,"",null,null,"0",null,{"$f":"IFERROR(VLOOKUP(M$43,'Lookup Tables'!$A$66:$B$73,2,FALSE),\"\")","v":0.3},null,"0",null,{"$f":"IFERROR(VLOOKUP(Q$43,'Lookup Tables'!$A$66:$B$73,2,FALSE),\"\")","v":0.4},null,"0",null,{"$f":"IFERROR(VLOOKUP(U$43,'Lookup Tables'!$A$66:$B$73,2,FALSE),\"\")","v":0.3},null,"0",null,{"$f":"IFERROR(VLOOKUP(Y$43,'Lookup Tables'!$A$66:$B$73,2,FALSE),\"\")","v":0.4},null,"0",null,{"$f":"IFERROR(VLOOKUP(AC$43,'Lookup Tables'!$A$66:$B$73,2,FALSE),\"\")","v":0.3},null,"0",null,null,null,"0",null,null,null,"0",null,0,{"$f":"IFERROR(VLOOKUP(C53,'Lookup Tables'!$A$25:$B$197,2,FALSE),\"\")","v":""},"",{"$f":"IFERROR(('Site Inputs'!$E$12/12*(E53*$D$8+F53*$D$9)+IFERROR(SUMIF($D$45:$D$64,B53,$I$45:$I$64),0)),0)","v":0},""]
[null,null,null,null,null,null,{"$f":"IFERROR(($G$40*'Site Inputs'!$E$12/12*(E54*$D$8+F54*$D$9)+IFERROR(SUMIF($D$45:$D$64,B54,$I$45:$I$64),0)),0)","v":0},0,"",null,null,"0",null,{"$f":"IFERROR(VLOOKUP(M$43,'Lookup Tables'!$A$66:$B$73,2,FALSE),\"\")","v":0.3},null,"0",null,{"$f":"IFERROR(VLOOKUP(Q$43,'Lookup Tables'!$A$66:$B$73,2,FALSE),\"\")","v":0.4},null,"0",null,{"$f":"IFERROR(VLOOKUP(U$43,'Lookup Tables'!$A$66:$B$73,2,FALSE),\"\")","v":0.3},null,"0",null,{"$f":"IFERROR(VLOOKUP(Y$43,'Lookup Tables'!$A$66:$B$73,2,FALSE),\"\")","v":0.4},null,"0",null,{"$f":"IFERROR(VLOOKUP(AC$43,'Lookup Tables'!$A$66:$B$73,2,FALSE),\"\")","v":0.3},null,"0",null,null,null,"0",null,null,null,"0",null,0,{"$f":"IFERROR(VLOOKUP(C54,'Lookup Tables'!$A$25:$B$197,2,FALSE),\"\")","v":""},"",{"$f":"IFERROR(('Site Inputs'!$E$12/12*(E54*$D$8+F54*$D$9)+IFERROR(SUMIF($D$45:$D$64,B54,$I$45:$I$64),0)),0)","v":0},""]
[null,null,null,null,null,null,{"$f":"IFERROR(($G$40*'Site Inputs'!$E$12/12*(E55*$D$8+F55*$D$9)+IFERROR(SUMIF($D$45:$D$64,B55,$I$45:$I$64),0)),0)","v":0},0,"",null,null,"0",null,{"$f":"IFERROR(VLOOKUP(M$43,'Lookup Tables'!$A$66:$B$73,2,FALSE),\"\")","v":0.3},null,"0",null,{"$f":"IFERROR(VLOOKUP(Q$43,'Lookup Tables'!$A$66:$B$73,2,FALSE),\"\")","v":0.4},null,"0",null,{"$f":"IFERROR(VLOOKUP(U$43,'Lookup Tables'!$A$66:$B$73,2,FALSE),\"\")","v":0.3},null,"0",null,{"$f":"IFERROR(VLOOKUP(Y$43,'Lookup Tables'!$A$66:$B$73,2,FALSE),\"\")","v":0.4},null,"0",null,{"$f":"IFERROR(VLOOKUP(AC$43,'Lookup Tables'!$A$66:$B$73,2,FALSE),\"\")","v":0.3},null,"0",null,null,null,"0",null,null,null,"0",null,0,{"$f":"IFERROR(VLOOKUP(C55,'Lookup Tables'!$A$25:$B$197,2,FALSE),\"\")","v":""},"",{"$f":"IFERROR(('Site Inputs'!$E$12/12*(E55*$D$8+F55*$D$9)+IFERROR(SUMIF($D$45:$D$64,B55,$I$45:$I$64),0)),0)","v":0},""]
[null,null,null,null,null,null,{"$f":"IFERROR(($G$40*'Site Inputs'!$E$12/12*(E56*$D$8+F56*$D$9)+IFERROR(SUMIF($D$45:$D$64,B56,$I$45:$I$64),0)),0)","v":0},0,"",null,null,{"$f":"+IF(J56=\"\",\"0\",J56*1*K56)","v":"0"},null,{"$f":"IFERROR(VLOOKUP(M$43,'Lookup Tables'!$A$66:$B$73,2,FALSE),\"\")","v":0.3},null,"0",null,{"$f":"IFERROR(VLOOKUP(Q$43,'Lookup Tables'!$A$66:$B$73,2,FALSE),\"\")","v":0.4},null,{"$f":"+IF(Q56=\"\",\"0\",Q56*R56*S56)","v":"0"},null,{"$f":"IFERROR(VLOOKUP(U$43,'Lookup Tables'!$A$66:$B$73,2,FALSE),\"\")","v":0.3},null,{"$f":"+IF(U56=\"\",\"0\",U56*V56*W56)","v":"0"},null,{"$f":"IFERROR(VLOOKUP(Y$43,'Lookup Tables'!$A$66:$B$73,2,FALSE),\"\")","v":0.4},null,{"$f":"+IF(Y56=\"\",\"0\",Y56*Z56*AA56)","v":"0"},null,{"$f":"IFERROR(VLOOKUP(AC$43,'Lookup Tables'!$A$66:$B$73,2,FALSE),\"\")","v":0.3},null,{"$f":"+IF(AC56=\"\",\"0\",AC56*AD56*AE56)","v":"0"},null,null,null,{"$f":"+IF(AG56=\"\",\"0\",AG56*AH56*AI56)","v":"0"},null,null,null,{"$f":"+IF(AK56=\"\",\"0\",AK56*AL56*AM56)","v":"0"},null,{"$f":"+IFERROR((L56+X56+T56+P56+AB56+AF56+AJ56+AO56+AN56),\"\")","v":0},{"$f":"IFERROR(VLOOKUP(C56,'Lookup Tables'!$A$25:$B$197,2,FALSE),\"\")","v":""},"",{"$f":"IFERROR(('Site Inputs'!$E$12/12*(E56*$D$8+F56*$D$9)+IFERROR(SUMIF($D$45:$D$64,B56,$I$45:$I$64),0)),0)","v":0},""]
[null,null,null,null,null,null,{"$f":"IFERROR(($G$40*'Site Inputs'!$E$12/12*(E57*$D$8+F57*$D$9)+IFERROR(SUMIF($D$45:$D$64,B57,$I$45:$I$64),0)),0)","v":0},0,"",null,null,{"$f":"+IF(J57=\"\",\"0\",J57*1*K57)","v":"0"},null,{"$f":"IFERROR(VLOOKUP(M$43,'Lookup Tables'!$A$66:$B$73,2,FALSE),\"\")","v":0.3},null,"0",null,{"$f":"IFERROR(VLOOKUP(Q$43,'Lookup Tables'!$A$66:$B$73,2,FALSE),\"\")","v":0.4},null,{"$f":"+IF(Q57=\"\",\"0\",Q57*R57*S57)","v":"0"},null,{"$f":"IFERROR(VLOOKUP(U$43,'Lookup Tables'!$A$66:$B$73,2,FALSE),\"\")","v":0.3},null,{"$f":"+IF(U57=\"\",\"0\",U57*V57*W57)","v":"0"},null,{"$f":"IFERROR(VLOOKUP(Y$43,'Lookup Tables'!$A$66:$B$73,2,FALSE),\"\")","v":0.4},null,{"$f":"+IF(Y57=\"\",\"0\",Y57*Z57*AA57)","v":"0"},null,{"$f":"IFERROR(VLOOKUP(AC$43,'Lookup Tables'!$A$66:$B$73,2,FALSE),\"\")","v":0.3},null,{"$f":"+IF(AC57=\"\",\"0\",AC57*AD57*AE57)","v":"0"},null,null,null,{"$f":"+IF(AG57=\"\",\"0\",AG57*AH57*AI57)","v":"0"},null,null,null,{"$f":"+IF(AK57=\"\",\"0\",AK57*AL57*AM57)","v":"0"},null,{"$f":"+IFERROR((L57+X57+T57+P57+AB57+AF57+AJ57+AO57+AN57),\"\")","v":0},{"$f":"IFERROR(VLOOKUP(C57,'Lookup Tables'!$A$25:$B$197,2,FALSE),\"\")","v":""},"",{"$f":"IFERROR(('Site Inputs'!$E$12/12*(E57*$D$8+F57*$D$9)+IFERROR(SUMIF($D$45:$D$64,B57,$I$45:$I$64),0)),0)","v":0},""]
[null,null,null,null,null,null,{"$f":"IFERROR(($G$40*'Site Inputs'!$E$12/12*(E58*$D$8+F58*$D$9)+IFERROR(SUMIF($D$45:$D$64,B58,$I$45:$I$64),0)),0)","v":0},0,"",null,null,{"$f":"+IF(J58=\"\",\"0\",J58*1*K58)","v":"0"},null,{"$f":"IFERROR(VLOOKUP(M$43,'Lookup Tables'!$A$66:$B$73,2,FALSE),\"\")","v":0.3},null,"0",null,{"$f":"IFERROR(VLOOKUP(Q$43,'Lookup Tables'!$A$66:$B$73,2,FALSE),\"\")","v":0.4},null,{"$f":"+IF(Q58=\"\",\"0\",Q58*R58*S58)","v":"0"},null,{"$f":"IFERROR(VLOOKUP(U$43,'Lookup Tables'!$A$66:$B$73,2,FALSE),\"\")","v":0.3},null,{"$f":"+IF(U58=\"\",\"0\",U58*V58*W58)","v":"0"},null,{"$f":"IFERROR(VLOOKUP(Y$43,'Lookup Tables'!$A$66:$B$73,2,FALSE),\"\")","v":0.4},null,{"$f":"+IF(Y58=\"\",\"0\",Y58*Z58*AA58)","v":"0"},null,{"$f":"IFERROR(VLOOKUP(AC$43,'Lookup Tables'!$A$66:$B$73,2,FALSE),\"\")","v":0.3},null,{"$f":"+IF(AC58=\"\",\"0\",AC58*AD58*AE58)","v":"0"},null,null,null,{"$f":"+IF(AG58=\"\",\"0\",AG58*AH58*AI58)","v":"0"},null,null,null,{"$f":"+IF(AK58=\"\",\"0\",AK58*AL58*AM58)","v":"0"},null,{"$f":"+IFERROR((L58+X58+T58+P58+AB58+AF58+AJ58+AO58+AN58),\"\")","v":0},{"$f":"IFERROR(VLOOKUP(C58,'Lookup Tables'!$A$25:$B$197,2,FALSE),\"\")","v":""},"",{"$f":"IFERROR(('Site Inputs'!$E$12/12*(E58*$D$8+F58*$D$9)+IFERROR(SUMIF($D$45:$D$64,B58,$I$45:$I$64),0)),0)","v":0},""]
[null,null,null,null,null,null,{"$f":"IFERROR(($G$40*'Site Inputs'!$E$12/12*(E59*$D$8+F59*$D$9)+IFERROR(SUMIF($D$45:$D$64,B59,$I$45:$I$64),0)),0)","v":0},0,"",null,null,{"$f":"+IF(J59=\"\",\"0\",J59*1*K59)","v":"0"},null,{"$f":"IFERROR(VLOOKUP(M$43,'Lookup Tables'!$A$66:$B$73,2,FALSE),\"\")","v":0.3},null,{"$f":"+IF(M59=\"\",\"0\",M59*N59*O59)","v":"0"},null,{"$f":"IFERROR(VLOOKUP(Q$43,'Lookup Tables'!$A$66:$B$73,2,FALSE),\"\")","v":0.4},null,{"$f":"+IF(Q59=\"\",\"0\",Q59*R59*S59)","v":"0"},null,{"$f":"IFERROR(VLOOKUP(U$43,'Lookup Tables'!$A$66:$B$73,2,FALSE),\"\")","v":0.3},null,{"$f":"+IF(U59=\"\",\"0\",U59*V59*W59)","v":"0"},null,{"$f":"IFERROR(VLOOKUP(Y$43,'Lookup Tables'!$A$66:$B$73,2,FALSE),\"\")","v":0.4},null,{"$f":"+IF(Y59=\"\",\"0\",Y59*Z59*AA59)","v":"0"},null,{"$f":"IFERROR(VLOOKUP(AC$43,'Lookup Tables'!$A$66:$B$73,2,FALSE),\"\")","v":0.3},null,{"$f":"+IF(AC59=\"\",\"0\",AC59*AD59*AE59)","v":"0"},null,null,null,{"$f":"+IF(AG59=\"\",\"0\",AG59*AH59*AI59)","v":"0"},null,null,null,{"$f":"+IF(AK59=\"\",\"0\",AK59*AL59*AM59)","v":"0"},null,{"$f":"+IFERROR((L59+X59+T59+P59+AB59+AF59+AJ59+AO59+AN59),\"\")","v":0},{"$f":"IFERROR(VLOOKUP(C59,'Lookup Tables'!$A$25:$B$197,2,FALSE),\"\")","v":""},"",{"$f":"IFERROR(('Site Inputs'!$E$12/12*(E59*$D$8+F59*$D$9)+IFERROR(SUMIF($D$45:$D$64,B59,$I$45:$I$64),0)),0)","v":0},""]
[null,null,null,null,null,null,{"$f":"IFERROR(($G$40*'Site Inputs'!$E$12/12*(E60*$D$8+F60*$D$9)+IFERROR(SUMIF($D$45:$D$64,B60,$I$45:$I$64),0)),0)","v":0},0,"",null,null,"0",null,{"$f":"IFERROR(VLOOKUP(M$43,'Lookup Tables'!$A$66:$B$73,2,FALSE),\"\")","v":0.3},null,"0",null,{"$f":"IFERROR(VLOOKUP(Q$43,'Lookup Tables'!$A$66:$B$73,2,FALSE),\"\")","v":0.4},null,"0",null,{"$f":"IFERROR(VLOOKUP(U$43,'Lookup Tables'!$A$66:$B$73,2,FALSE),\"\")","v":0.3},null,"0",null,{"$f":"IFERROR(VLOOKUP(Y$43,'Lookup Tables'!$A$66:$B$73,2,FALSE),\"\")","v":0.4},null,"0",null,{"$f":"IFERROR(VLOOKUP(AC$43,'Lookup Tables'!$A$66:$B$73,2,FALSE),\"\")","v":0.3},null,"0",null,null,null,"0",null,null,null,"0",null,0,{"$f":"IFERROR(VLOOKUP(C60,'Lookup Tables'!$A$25:$B$197,2,FALSE),\"\")","v":""},"",{"$f":"IFERROR(('Site Inputs'!$E$12/12*(E60*$D$8+F60*$D$9)+IFERROR(SUMIF($D$45:$D$64,B60,$I$45:$I$64),0)),0)","v":0},""]
[null,null,null,null,null,null,{"$f":"IFERROR(($G$40*'Site Inputs'!$E$12/12*(E61*$D$8+F61*$D$9)+IFERROR(SUMIF($D$45:$D$64,B61,$I$45:$I$64),0)),0)","v":0},0,"",null,null,"0",null,{"$f":"IFERROR(VLOOKUP(M$43,'Lookup Tables'!$A$66:$B$73,2,FALSE),\"\")","v":0.3},null,"0",null,{"$f":"IFERROR(VLOOKUP(Q$43,'Lookup Tables'!$A$66:$B$73,2,FALSE),\"\")","v":0.4},null,"0",null,{"$f":"IFERROR(VLOOKUP(U$43,'Lookup Tables'!$A$66:$B$73,2,FALSE),\"\")","v":0.3},null,"0",null,{"$f":"IFERROR(VLOOKUP(Y$43,'Lookup Tables'!$A$66:$B$73,2,FALSE),\"\")","v":0.4},null,"0",null,{"$f":"IFERROR(VLOOKUP(AC$43,'Lookup Tables'!$A$66:$B$73,2,FALSE),\"\")","v":0.3},null,"0",null,null,null,"0",null,null,null,"0",null,0,{"$f":"IFERROR(VLOOKUP(C61,'Lookup Tables'!$A$25:$B$197,2,FALSE),\"\")","v":""},"",{"$f":"IFERROR(('Site Inputs'!$E$12/12*(E61*$D$8+F61*$D$9)+IFERROR(SUMIF($D$45:$D$64,B61,$I$45:$I$64),0)),0)","v":0},""]
[null,null,null,null,null,null,{"$f":"IFERROR(($G$40*'Site Inputs'!$E$12/12*(E62*$D$8+F62*$D$9)+IFERROR(SUMIF($D$45:$D$64,B62,$I$45:$I$64),0)),0)","v":0},0,"",null,null,"0",null,{"$f":"IFERROR(VLOOKUP(M$43,'Lookup Tables'!$A$66:$B$73,2,FALSE),\"\")","v":0.3},null,"0",null,{"$f":"IFERROR(VLOOKUP(Q$43,'Lookup Tables'!$A$66:$B$73,2,FALSE),\"\")","v":0.4},null,"0",null,{"$f":"IFERROR(VLOOKUP(U$43,'Lookup Tables'!$A$66:$B$73,2,FALSE),\"\")","v":0.3},null,"0",null,{"$f":"IFERROR(VLOOKUP(Y$43,'Lookup Tables'!$A$66:$B$73,2,FALSE),\"\")","v":0.4},null,"0",null,{"$f":"IFERROR(VLOOKUP(AC$43,'Lookup Tables'!$A$66:$B$73,2,FALSE),\"\")","v":0.3},null,"0",null,null,null,"0",null,null,null,"0",null,0,{"$f":"IFERROR(VLOOKUP(C62,'Lookup Tables'!$A$25:$B$197,2,FALSE),\"\")","v":""},"",{"$f":"IFERROR(('Site Inputs'!$E$12/12*(E62*$D$8+F62*$D$9)+IFERROR(SUMIF($D$45:$D$64,B62,$I$45:$I$64),0)),0)","v":0},""]
[null,null,null,null,null,null,{"$f":"IFERROR(($G$40*'Site Inputs'!$E$12/12*(E63*$D$8+F63*$D$9)+IFERROR(SUMIF($D$45:$D$64,B63,$I$45:$I$64),0)),0)","v":0},0,"",null,null,"0",null,{"$f":"IFERROR(VLOOKUP(M$43,'Lookup Tables'!$A$66:$B$73,2,FALSE),\"\")","v":0.3},null,"0",null,{"$f":"IFERROR(VLOOKUP(Q$43,'Lookup Tables'!$A$66:$B$73,2,FALSE),\"\")","v":0.4},null,"0",null,{"$f":"IFERROR(VLOOKUP(U$43,'Lookup Tables'!$A$66:$B$73,2,FALSE),\"\")","v":0.3},null,"0",null,{"$f":"IFERROR(VLOOKUP(Y$43,'Lookup Tables'!$A$66:$B$73,2,FALSE),\"\")","v":0.4},null,"0",null,{"$f":"IFERROR(VLOOKUP(AC$43,'Lookup Tables'!$A$66:$B$73,2,FALSE),\"\")","v":0.3},null,"0",null,null,null,"0",null,null,null,"0",null,0,{"$f":"IFERROR(VLOOKUP(C63,'Lookup Tables'!$A$25:$B$197,2,FALSE),\"\")","v":""},"",{"$f":"IFERROR(('Site Inputs'!$E$12/12*(E63*$D$8+F63*$D$9)+IFERROR(SUMIF($D$45:$D$64,B63,$I$45:$I$64),0)),0)","v":0},""]
[null,null,null,null,null,null,{"$f":"IFERROR(($G$40*'Site Inputs'!$E$12/12*(E64*$D$8+F64*$D$9)+IFERROR(SUMIF($D$45:$D$64,B64,$I$45:$I$64),0)),0)","v":0},0,"",null,null,"0",null,{"$f":"IFERROR(VLOOKUP(M$43,'Lookup Tables'!$A$66:$B$73,2,FALSE),\"\")","v":0.3},null,"0",null,{"$f":"IFERROR(VLOOKUP(Q$43,'Lookup Tables'!$A$66:$B$73,2,FALSE),\"\")","v":0.4},null,"0",null,{"$f":"IFERROR(VLOOKUP(U$43,'Lookup Tables'!$A$66:$B$73,2,FALSE),\"\")","v":0.3},null,"0",null,{"$f":"IFERROR(VLOOKUP(Y$43,'Lookup Tables'!$A$66:$B$73,2,FALSE),\"\")","v":0.4},null,"0",null,{"$f":"IFERROR(VLOOKUP(AC$43,'Lookup Tables'!$A$66:$B$73,2,FALSE),\"\")","v":0.3},null,"0",null,null,null,"0",null,null,null,"0",null,0,{"$f":"IFERROR(VLOOKUP(C64,'Lookup Tables'!$A$25:$B$197,2,FALSE),\"\")","v":""},"",{"$f":"IFERROR(('Site Inputs'!$E$12/12*(E64*$D$8+F64*$D$9)+IFERROR(SUMIF($D$45:$D$64,B64,$I$45:$I$64),0)),0)","v":0},""]
[]
[]
[null,{"$f":"B7","v":"RRV Prior to Reductions, (ft³)"},null,{"$f":"D7","v":0}]
[null,"RRV After Reductions, RRVDA# (ft3)",null,{"$f":"D25","v":0}]
[null,"Total Retention Achieved, VR  (ft3)",null,{"$f":"SUM(H45:H64)","v":0},{"$f":"IF(D68=0,\"\",IF(D68>D69,\"⮽ Need to capture an additional \"&ROUND(D68-D69,0)&\" cubic feet.\",\"☑ You met the Required Retention Volume.\"))","v":""}]
[]
[]
[null,"Detention Calculations"]
[]
[null,null,null,"2-year storm","10-year storm","25-year storm","50-year storm","100-year storm"]
[null,"Required Rainfall Event (in) - 6 hour Events",null,2.66,4.04,4.96,5.7,6.47]
[]
[null,null,null,null,null,null,"Post-Project Conditions"]
[null,null,null,null,null,null,"Weighted CN",{"$f":"$D$10","v":0}]
[null,null,null,null,null,null,"S",{"$f":"IFERROR(IF(H78>0,1000/H78-10,1000),\"\")","v":1000},"Equation 5602-10"]
[null,null,null,null,null,null,"Ia",{"$f":"IFERROR(H79*F101,\"\")","v":50}]
[]
[]
[null,null,null,{"$f":"$D$74","v":"2-year storm"},{"$f":"$E$74","v":"10-year storm"},{"$f":"$F$74","v":"25-year storm"},{"$f":"$G$74","v":"50-year storm"},{"$f":"$H$74","v":"100-year storm"}]
[null,"Pre-Project Runoff Volume (in)",null,{"$f":"IFERROR(IF(D$75>$F$100*$AQ102,(D$75-$AQ$103)^2/(D$75-$AQ$103+$AQ$102),0),0)","v":0.13902954946729695},{"$f":"IFERROR(IF(E$75>$F$100*$AQ102,(E$75-$AQ$103)^2/(E$75-$AQ$103+$AQ$102),0),0)","v":0.74686070167429419},{"$f":"IFERROR(IF(F$75>$F$100*$AQ102,(F$75-$AQ$103)^2/(F$75-$AQ$103+$AQ$102),0),0)","v":1.3067374294073619},{"$f":"IFERROR(IF(G$75>$F$100*$AQ102,(G$75-$AQ$103)^2/(G$75-$AQ$103+$AQ$102),0),0)","v":1.8143458997240549},{"$f":"IFERROR(IF(H$75>$F$100*$AQ102,(H$75-$AQ$103)^2/(H$75-$AQ$103+$AQ$102),0),0)","v":2.3823706650698808}]
[null,"Post-Project Runoff Volume (in) with no Retention",null,{"$f":"IFERROR(IF(D$75>$F$101*$H79,(D$75-$H$80)^2/(D$75-$H$80+$H$79),0),0)","v":0},{"$f":"IFERROR(IF(E$75>$F$101*$H79,(E$75-$H$80)^2/(E$75-$H$80+$H$79),0),0)","v":0},{"$f":"IFERROR(IF(F$75>$F$101*$H79,(F$75-$H$80)^2/(F$75-$H$80+$H$79),0),0)","v":0},{"$f":"IFERROR(IF(G$75>$F$101*$H79,(G$75-$H$80)^2/(G$75-$H$80+$H$79),0),0)","v":0},{"$f":"IFERROR(IF(H$75>$F$101*$H79,(H$75-$H$80)^2/(H$75-$H$80+$H$79),0),0)","v":0},"Equation 5602-11"]
[null,"Post-Project Runoff Volume (in) with Retention",null,{"$f":"IFERROR(IF(D85>(SUM($AP$45:$AP$64))*12/($D$6),D85-(SUM($AP$45:$AP$64))*12/($D$6),0),0)","v":0},{"$f":"IFERROR(IF(E85>(SUM($AP$45:$AP$64))*12/($D$6),E85-(SUM($AP$45:$AP$64))*12/($D$6),0),0)","v":0},{"$f":"IFERROR(IF(F85>(SUM($AP$45:$AP$64))*12/($D$6),F85-(SUM($AP$45:$AP$64))*12/($D$6),0),0)","v":0},{"$f":"IFERROR(IF(G85>(SUM($AP$45:$AP$64))*12/($D$6),G85-(SUM($AP$45:$AP$64))*12/($D$6),0),0)","v":0},{"$f":"IFERROR(IF(H85>(SUM($AP$45:$AP$64))*12/($D$6),H85-(SUM($AP$45:$AP$64))*12/($D$6),0),0)","v":0},"Equation 5602-13"]
[null,"Retention Adjusted CN (CNR)",null,{"$f":"IF(D86>0,VLOOKUP((D86),B$104:$H$854,6),0)","v":0},{"$f":"IF(E86>0,VLOOKUP((E86),C$104:$H$854,5),0)","v":0},{"$f":"IF(F86>0,VLOOKUP((F86),D$104:$H$854,4),0)","v":0},{"$f":"IF(G86>0,VLOOKUP((G86),E$104:$H$854,3),0)","v":0},{"$f":"IF(H86>0,VLOOKUP((H86),F$104:$H$854,2),0)","v":0},"Equation 5602-14"]
[null,"Additional Detention Required?",null,{"$f":"IF(D87>AQ101,\"Yes\",\"No\")","v":"No"},{"$f":"IF(E87>AQ101,\"Yes\",\"No\")","v":"No"},"N/A","N/A",{"$f":"IF(H87>AQ101,\"Yes\",\"No\")","v":"No"}]
[]
[null,null,null,null,null,"Overtopping Elevation",null,{"$f":"IF(G90=0,\"\",IF(G90>G94,\"\",\"Maximum ponding depth of design storm overtopping detention practice.\"))","v":""}]
[null,"Design Storm",null,"Required Release Rate (cfs/acre)","Allowable Site Release \n(cfs)","Peak Outflow (cfs)","Max Ponding Depth (ft)","Achieved Release Rate (cfs/acre)"]
[null,"2-Year, NOAA Atlas14 Median, First Quartile",null,0.2,{"$f":"D92*($D$6/43560)","v":0},null,null,{"$f":"+IFERROR(F92/($D$6/43560),0)","v":0},{"$f":"IF(H92=0,\"\",IF(H92>D92,\"Re-size outlet control to meet required release rate.\",\"Required release rate met.\"))","v":""}]
[null,"10-Year, NOAA Atlas14 Median, First Quartile",null,0.6,{"$f":"D93*($D$6/43560)","v":0},null,null,{"$f":"+IFERROR(F93/($D$6/43560),0)","v":0},{"$f":"IF(H93=0,\"\",IF(H93>D93,\"Re-size outlet control to meet required release rate.\",\"Required release rate met.\"))","v":""}]
[null,"100-Year, NOAA Atlas14 Median, First Quartile",null,3,{"$f":"D94*($D$6/43560)","v":0},null,null,{"$f":"+IFERROR(F94/($D$6/43560),0)","v":0},{"$f":"IF(H94=0,\"\",IF(H94>D94,\"Re-size outlet control to meet required release rate.\",\"Required release rate met.\"))","v":""}]
[]
[]
[]
[]
[]
[null,null,null,"Predevelopment",null,0.4,"X",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,null,null,null,null,null,null,null,"Pre-Development Conditions"]
[null,null,null,"Post-Development",null,0.05,"X",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,null,null,null,null,null,null,null,"Weighted CN",69]
[null,"LOCK/HIDE THESE CALC CELLS",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,null,null,null,null,null,null,null,null,null,null,null,null,"S",{"$f":"IFERROR(IF(AQ101>0,1000/AQ101-10,1000),\"\")","v":4.4927536231884062}]
[null,"v (in)","v (in)","v (in)","v (in)","v (in)","CN","S",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,null,null,null,null,null,null,"Ia",{"$f":"IFERROR(AQ102*F100,\"\")","v":1.7971014492753625}]
[null,{"$f":"IF(D$75>0.2*($H104),(D$75-0.2*($H104))^2/(D$75+0.8*($H104)),0)","v":0},{"$f":"IF(E$75>0.2*($H104),(E$75-0.2*($H104))^2/(E$75+0.8*($H104)),0)","v":0},{"$f":"IF(F$75>0.2*($H104),(F$75-0.2*($H104))^2/(F$75+0.8*($H104)),0)","v":0},{"$f":"IF(G$75>0.2*($H104),(G$75-0.2*($H104))^2/(G$75+0.8*($H104)),0)","v":0},{"$f":"IF(H$75>0.2*($H104),(H$75-0.2*($H104))^2/(H$75+0.8*($H104)),0)","v":7.2497538562520435E-3},25,{"$f":"IF(G104>0,1000/G104-10,1000)","v":30}]
[null,0,0,0,0,8.3010936334677269E-3,{"$f":"G104+0.1","v":25.1},29.840637450199203]
[null,0,0,0,0,9.4192971532868E-3,{"$f":"G105+0.1","v":25.200000000000003},29.682539682539677]
[null,0,0,0,0,1.0603616730251312E-2,25.300000000000004,29.525691699604735]
[null,0,0,0,0,1.1853316489650005E-2,25.400000000000006,29.370078740157474]
[null,0,0,0,0,1.316767213597143E-2,25.500000000000007,29.215686274509792]
[null,0,0,0,0,1.4545970726783423E-2,25.600000000000009,29.062499999999986]
[null,0,0,0,0,1.5987510451892471E-2,25.70000000000001,28.910505836575858]
[null,0,0,0,0,1.7491600417638475E-2,25.800000000000011,28.759689922480604]
[null,0,0,0,0,1.9057560436186602E-2,25.900000000000013,28.610038610038593]
[null,0,0,0,2.0784403383724737E-6,2.0684720819681975E-2,26.000000000000014,28.461538461538439]
[null,0,0,0,4.8717932387972638E-5,2.2372422179135938E-2,26.100000000000016,28.314176245210703]
[null,0,0,0,1.5621333429098768E-4,2.4120015227918713E-2,26.200000000000017,28.167938931297684]
[null,0,0,0,3.2392736882143206E-4,2.5926860589734597E-2,26.300000000000018,28.022813688212899]
[null,0,0,0,5.5123248500594006E-4,2.7792328610961748E-2,{"$f":"G117+0.1","v":26.40000000000002},27.878787878787847]
[null,0,0,0,8.3751067471888902E-4,2.9715799177240588E-2,{"$f":"G118+0.1","v":26.500000000000021},27.73584905660374]
[null,0,0,0,1.1821532934147203E-3,3.1696661534199734E-2,{"$f":"G119+0.1","v":26.600000000000023},27.593984962405983]
[null,0,0,0,1.5845608848889291E-3,3.3734314112210374E-2,{"$f":"G120+0.1","v":26.700000000000024},27.453183520599218]
[null,0,0,0,2.0441430099624853E-3,3.5828164355064002E-2,{"$f":"G121+0.1","v":26.800000000000026},27.313432835820862]
[null,0,0,0,2.5603180789877515E-3,3.797762855247204E-2,26.900000000000027,27.17472118959104]
[null,0,0,0,3.1325131880764502E-3,4.0182131676286703E-2,27.000000000000028,27.037037037036995]
[null,0,0,0,3.7601639589540225E-3,4.2441107220349106E-2,27.10000000000003,26.900369003689995]
[null,0,0,0,4.442714382346784E-3,4.4753997043869842E-2,27.200000000000031,26.764705882352899]
[null,0,0,0,5.1796166648110835E-3,4.7120251218251093E-2,27.300000000000033,26.630036630036585]
[null,0,0,0,5.9703310789171096E-3,4.9539327877264193E-2,27.400000000000034,26.496350364963462]
[null,0,0,0,6.8143258167014196E-3,5.2010693070495342E-2,27.500000000000036,26.363636363636317]
[null,0,0,0,7.7110768463053711E-3,5.4533820619977073E-2,27.600000000000037,26.231884057970966]
[null,0,0,0,8.6600677717193625E-3,5.7108191979926157E-2,27.700000000000038,26.101083032490926]
[null,0,0,0,9.6607896955542387E-3,5.9733296099508254E-2,27.80000000000004,25.971223021582681]
[null,0,0,0,1.0712741084763784E-2,6.2408629288553327E-2,27.900000000000041,25.842293906809985]
[null,0,0,0,1.1815427639245434E-2,6.5133695086150176E-2,28.000000000000043,25.714285714285658]
[null,0,0,0,1.296836216324589E-2,6.7908004132044522E-2,28.100000000000044,25.587188612099588]
[null,0,0,0,1.4171064439504234E-2,7.0731074040776262E-2,28.200000000000045,25.460992907801362]
[null,0,0,0,1.5423061106062357E-2,7.3602429278482331E-2,28.300000000000047,25.335689045936334]
[null,0,0,0,1.6723885535678877E-2,7.6521601042304127E-2,28.400000000000048,25.211267605633743]
[null,0,0,0,1.8073077717782091E-2,7.9488127142333886E-2,28.50000000000005,25.087719298245553]
[null,0,0,0,1.9470184142898757E-2,8.2501551886036112E-2,28.600000000000051,24.965034965034903]
[null,0,0,0,2.0914757689500151E-2,8.5561425965087187E-2,28.700000000000053,24.84320557491283]
[null,0,0,9.7816105721397701E-6,2.2406357513205216E-2,8.8667306344571595E-2,28.800000000000054,24.722222222222157]
[null,0,0,6.3589642964048882E-5,2.394454893828412E-2,9.1818756154478404E-2,28.900000000000055,24.602076124567411]
[null,0,0,1.6400430937605969E-4,2.5528903351407138E-2,9.5015344583443614E-2,29.000000000000057,24.482758620689587]
[null,0,0,3.1060513508137196E-4,2.7158998097584004E-2,9.8256646774682224E-2,29.100000000000058,24.364261168384807]
[null,0,0,5.0297750752247461E-4,2.8834416378241995E-2,0.10154224372405954,29.20000000000006,24.246575342465682]
[null,0,0,7.4071257649201475E-4,3.055474715139157E-2,0.10487172218025016,29.300000000000061,24.129692832764434]
[null,0,0,1.0234071563512727E-3,3.2319585033828979E-2,0.10824467454693323,29.400000000000063,24.013605442176797]
[null,0,0,1.3506636302380256E-3,3.4128530205328717E-2,0.1116606987869781,29.500000000000064,23.898305084745687]
[null,0,0,1.7220898562166507E-3,3.5981188314777847E-2,0.1151193983285716,29.600000000000065,23.783783783783711]
[null,0,0,2.1372990753249226E-3,3.7877170388207738E-2,0.1186203819732433,29.700000000000067,23.670033670033597]
[null,0,0,2.5959098214724096E-3,3.9816092738675854E-2,0.1221632638057394,29.800000000000068,23.557046979865696]
[null,0,0,3.097545833147856E-3,4.1797576877958001E-2,0.12574766310570862,29.90000000000007,23.44481605351163]
[null,0,0,3.6418359668927763E-3,4.382124943000594E-2,0.12937320426115256,30.000000000000071,23.333333333333258]
[null,0,0,4.2284141125004861E-3,4.5886742046130718E-2,0.1330395166836022,30.100000000000072,23.222591362126167]
[null,0,0,4.8569191099002507E-3,4.7993691321870514E-2,0.13674623472497813,30.200000000000074,23.112582781456872]
[null,0,0,5.5269946676882375E-3,5.0141738715506166E-2,0.14049299759609973,30.300000000000075,23.003300330032921]
[null,0,0,6.2382892832666056E-3,5.2330530468183985E-2,0.14427944928680042,30.400000000000077,22.894736842105182]
[null,0,0,6.9904561645543128E-3,5.4559717525610459E-2,0.14810523848761531,30.500000000000078,22.786885245901559]
[null,0,0,7.7831531532337548E-3,5.6828955461283234E-2,0.1519700185130054,30.60000000000008,22.679738562091416]
[null,0,0,8.6160426494974809E-3,5.9137904401220957E-2,0.1558734472260796,30.700000000000081,22.573289902280045]
[null,0,0,9.4887915382622558E-3,6.1486228950162071E-2,0.1598151869647873,30.800000000000082,22.467532467532379]
[null,0,0,1.040107111681547E-2,6.3873598119194061E-2,0.16379490446953943,30.900000000000084,22.362459546925479]
[null,0,0,1.1352557023863437E-2,6.6299685254786314E-2,0.16781227081223513,31.000000000000085,22.258064516128947]
[null,0,0,1.234292916994836E-2,6.8764167969190312E-2,0.17186696132665411,31.100000000000087,22.154340836012771]
[null,0,0,1.3371871669204243E-2,7.1266728072179097E-2,0.17595865554018908,31.200000000000088,22.051282051281959]
[null,0,0,1.44390727724217E-2,7.3807051504095944E-2,0.18008703710688709,31.30000000000009,21.948881789137289]
[null,{"$f":"IF(D$75>0.2*($H168),(D$75-0.2*($H168))^2/(D$75+0.8*($H168)),0)","v":0},{"$f":"IF(E$75>0.2*($H168),(E$75-0.2*($H168))^2/(E$75+0.8*($H168)),0)","v":0},{"$f":"IF(F$75>0.2*($H168),(F$75-0.2*($H168))^2/(F$75+0.8*($H168)),0)","v":1.5544224801392175E-2},{"$f":"IF(G$75>0.2*($H168),(G$75-0.2*($H168))^2/(G$75+0.8*($H168)),0)","v":7.6384828270182004E-2},{"$f":"IF(H$75>0.2*($H168),(H$75-0.2*($H168))^2/(H$75+0.8*($H168)),0)","v":0.18425179374177036},31.400000000000091,{"$f":"IF(G168>0,1000/G168-10,1000)","v":21.847133757961693}]
[null,0,0,1.6687024084503257E-2,7.8999752376155016E-2,0.18845261715640713,31.500000000000092,21.746031746031655]
[null,0,0,1.7867170893557608E-2,8.1651521765011836E-2,0.19268920299570752,{"$f":"G169+0.1","v":31.600000000000094},21.64556962025307]
[null,0,0,1.9084369381787987E-2,8.4339838255026611E-2,0.19696125077591378,31.700000000000095,21.545741324921043]
[null,0,0,2.0338327523042748E-2,8.7064407478919803E-2,0.20126846382376262,31.800000000000097,21.446540880503051]
[null,0,0,2.1628757052115664E-2,8.9824938824171419E-2,0.20561054921679101,31.900000000000098,21.347962382445044]
[null,0,0,2.2955373406194357E-2,9.2621145374452055E-2,0.20998721772475917,32.000000000000099,21.249999999999904]
[null,0,0,2.4317895667405425E-2,9.5452743852152244E-2,0.21439818375217393,32.100000000000101,21.152647975077784]
[null,0,0,2.5716046506428451E-2,9.8319454561978437E-2,0.21884316528187592,32.200000000000102,21.055900621117914]
[null,0,0,2.7149552127160168E-2,0.10122100133560126,0.22332188381968163,32.300000000000104,20.959752321981323]
[null,0,0,2.8618142212402175E-2,0.10415711147732555,0.22783406434004511,32.400000000000105,20.864197530864097]
[null,0,0,3.0121549870553189E-2,0.10712751571076606,0.23237943523272717,32.500000000000107,20.769230769230667]
[null,0,0,3.1659511583282E-2,0.11013194812650304,0.23695772825044265,32.600000000000108,20.674846625766769]
[null,0,0,3.3231767154161748E-2,0.11317014613069953,0.24156867845747096,32.700000000000109,20.581039755351579]
[null,0,0,3.4838059658244123E-2,0.1162418503946584,0.24621202417920529,32.800000000000111,20.487804878048678]
[null,0,0,3.6478135392553783E-2,0.11934680480529958,0.25088750695262274,32.900000000000112,20.395136778115397]
[null,0,0,3.8151743827483188E-2,0.12248475641653735,0.25559487147765347,33.000000000000114,20.303030303030198]
[null,0,0,3.9858637559069737E-2,0.12565545540154066,0.26033386556943439,33.100000000000115,20.21148036253766]
[null,0,1.2560593473657359E-5,4.1598572262134877E-2,0.12885865500585436,0.26510424011142208,33.200000000000117,20.120481927710738]
[null,0,5.759520753570926E-5,4.3371306644269109E-2,0.13209411150136705,0.2699057490093536,33.300000000000118,20.030030030029923]
[null,0,1.3512888201587262E-4,4.517660240064366E-2,0.13536158414110527,0.27473814914603317,33.400000000000119,19.940119760478936]
[null,0,2.4492874137435166E-4,4.7014224169631948E-2,0.13866083511483729,0.27960120033692792,33.500000000000121,19.850746268656607]
[null,0,3.8676482012073673E-4,4.8883939489224253E-2,0.14199162950547023,0.28449466528655781,33.600000000000122,19.761904761904653]
[null,0,5.6041002004611994E-4,5.0785518754219348E-2,0.14535373524622433,0.28941830954566256,33.700000000000124,19.673590504450928]
[null,0,7.6564006821577748E-4,5.2718735174175586E-2,0.14874692307856585,0.29437190146912606,33.800000000000125,19.585798816567937]
[null,0,1.0022334757068966E-3,5.468336473210797E-2,0.15217096651088691,0.29935521217464967,33.900000000000126,19.498525073746201]
[null,0,1.2699714970758086E-3,5.6679186143913526E-2,0.15562564177791266,0.30436801550215098,34.000000000000128,19.411764705882241]
[null,0,1.5686380905399469E-3,5.8705980818511985E-2,0.15911072780082433,0.30941008797387948,34.100000000000129,19.325513196480827]
[null,0,1.8980198788597971E-3,6.0763532818686003E-2,0.16262600614808151,0.31448120875523111,34.200000000000131,19.239766081871235]
[null,0,2.257906110906577E-3,6.2851628822606892E-2,0.16617126099692994,0.31958115961624856,34.300000000000132,19.154518950437204]
[null,0,2.6480886239016728E-3,6.4970058086031748E-2,0.1697462790955804,0.32470972489379207,34.400000000000134,19.069767441860353]
[null,0,3.0683618063143993E-3,6.711861240515947E-2,0.17335084972604725,0.32986669145437064,34.500000000000135,18.985507246376699]
[null,0,3.5185225614043983E-3,6.9297086080130271E-2,0.17698476466762908,0.33505184865761473,34.600000000000136,18.901734104046128]
[null,0,3.9983702713960179E-3,7.1505275879157504E-2,0.18064781816102282,0.34026498832038266,34.700000000000138,18.818443804034466]
[null,0,4.5077067622718396E-3,7.3742981003278515E-2,0.18433980687305615,0.34550590468148518,34.800000000000139,18.735632183907931]
[null,0,5.0463362691730183E-3,7.6010003051712197E-2,0.1880605298620272,0.35077439436701763,34.900000000000141,18.653295128939714]
[null,0,5.6140654023940119E-3,7.8306145987810119E-2,0.19180978854363681,0.35607025635628425,35.000000000000142,18.571428571428456]
[null,0,6.2107031139602481E-3,8.0631216105591139E-2,0.19558738665750486,0.36139329194830649,35.100000000000144,18.490028490028372]
[null,0,6.8360606647769537E-3,8.2985021996846597E-2,0.19939313023425728,0.36674330472890232,35.200000000000145,18.409090909090793]
[null,0,7.4899515923377942E-3,8.5367374518805383E-2,0.20322682756317229,0.37212010053832495,35.300000000000146,18.328611898016881]
[null,0,8.1721916789823813E-3,8.7778086762347537E-2,0.20708828916037589,0.37752348743945024,35.400000000000148,18.24858757062135]
[null,0,8.8825989206915146E-3,9.0216974020755111E-2,0.21097732773757344,0.38295327568649989,35.500000000000149,18.169014084506923]
[null,0,9.6209934964102527E-3,9.2683853758991477E-2,0.2148937581713109,0.38840927769429556,35.600000000000151,18.089887640449319]
[null,0,1.0387197737887649E-2,9.5178545583496255E-2,0.21883739747275074,0.39389130800802663,35.700000000000152,18.011204481792596]
[null,0,1.1181036100023649E-2,9.7700871212487619E-2,0.22280806475795559,0.39939918327352547,35.800000000000153,17.932960893854627]
[null,0,1.2002335131713036E-2,0.1002506544467615,0.22680558121866826,0.40493272220804,35.900000000000155,17.8551532033425]
[null,0,1.2850923447176903E-2,0.10282772114097813,0.23082977009358002,0.4104917455714942,36.000000000000156,17.777777777777658]
[null,0,1.3726631697771916E-2,0.10543189917542591,0.23488045664007506,0.41607607613822378,36.100000000000158,17.700831024930626]
[null,0,1.4629292544268278E-2,0.10806301842825382,0.23895746810644358,0.4216855386691819,36.200000000000159,17.624309392265072]
[null,0,1.5558740629587986E-2,0.11072091074816474,0.24306063370455699,0.42731995988460653,36.300000000000161,17.548209366391063]
[null,0,1.6514812551993014E-2,0.11340540992755709,0.24718978458298949,0.43297916843713308,36.400000000000162,17.47252747252735]
[null,0,1.7497346838716576E-2,0.11611635167611044,0.25134475380058513,0.43866299488535437,36.500000000000163,17.397260273972481]
[null,0,1.8506183920027786E-2,0.11885357359480424,0.25552537630045674,0.44437127166781126,36.600000000000165,17.322404371584575]
[null,0,1.9541166103721759E-2,0.12161691515036099,0.25973148888441033,0.45010383307740837,36.700000000000166,17.247956403269633]
[null,0,2.060213755002753E-2,0.1244062176501082,0.26396293018778738,0.45586051523624915,36.800000000000168,17.173913043478137]
[null,0,2.1688944246924944E-2,0.12722132421724794,0.26821954065471487,0.46164115607087725,36.900000000000169,17.100271002709903]
[null,0,2.2801433985863862E-2,0.13006207976652953,0.27250116251375894,0.46744559528792196,37.000000000000171,17.027027027026904]
[null,0,2.3939456337877297E-2,0.13292833098031528,0.27680763975397082,0.47327367435013651,37.100000000000172,16.954177897573999]
[null,0,2.5102862630081168E-2,0.13581992628503295,0.28113881810131924,0.47912523645282185,37.200000000000173,16.8817204301074]
[null,0,2.6291505922554012E-2,0.1387367158280077,0.28549454499550364,0.48500012650063162,37.300000000000175,16.809651474530707]
[null,0,2.7505240985588989E-2,0.14167855145466687,0.28987466956713864,0.49089819108474914,37.400000000000176,16.737967914438375]
[null,0,2.8743924277310994E-2,0.14464528668610829,0.29427904261530269,0.49681927846042673,37.500000000000178,16.66666666666654]
[null,0,3.0007413921653105E-2,0.14763677669702926,0.29870751658544703,0.50276323852488758,37.600000000000179,16.595744680850938]
[null,0,3.1295569686684642E-2,0.15065287829400598,0.30315994554765574,0.50872992279557638,37.70000000000018,16.525198938991917]
[null,{"$f":"IF(D$75>0.2*($H232),(D$75-0.2*($H232))^2/(D$75+0.8*($H232)),0)","v":0},{"$f":"IF(E$75>0.2*($H232),(E$75-0.2*($H232))^2/(E$75+0.8*($H232)),0)","v":3.2608252963284928E-2},{"$f":"IF(F$75>0.2*($H232),(F$75-0.2*($H232))^2/(F$75+0.8*($H232)),0)","v":0.15369344989411865},{"$f":"IF(G$75>0.2*($H232),(G$75-0.2*($H232))^2/(G$75+0.8*($H232)),0)","v":0.30763618517525032},{"$f":"IF(H$75>0.2*($H232),(H$75-0.2*($H232))^2/(H$75+0.8*($H232)),0)","v":0.51471918438875686},37.800000000000182,{"$f":"IF(G232>0,1000/G232-10,1000)","v":16.455026455026328}]
[null,0,3.3945326744155985E-2,0.15675835150391523,0.31213609272373377,0.52073087799844653,37.900000000000183,16.385224274406205]
[null,0,3.5306655603168625E-2,0.15984744469870907,0.316659527010068,0.52676485987568644,{"$f":"G233+0.1","v":38.000000000000185},16.315789473684081]
[null,0,3.6692105675034559E-2,0.16296059260220086,0.32120634839227563,0.53282098780813392,38.100000000000186,16.24671916010486]
[null,0,3.8101544635300515E-2,0.16609765986642455,0.32577641874936608,0.53889912109998162,38.200000000000188,16.178010471204061]
[null,0,3.9534841680655984E-2,0.16925851265200439,0.33036960146157163,0.54499912055218391,38.300000000000189,16.109660574412406]
[null,0,4.0991867509551097E-2,0.17244301860872349,0.33498576139089625,0.55112084844299802,38.40000000000019,16.041666666666536]
[null,0,4.2472494303117607E-2,0.17565104685639438,0.33962476486196524,0.55726416850882476,38.500000000000192,15.974025974025846]
[null,0,4.3976595706388906E-2,0.17888246796602927,0.34428647964317627,0.56342894592535198,38.600000000000193,15.906735751295209]
[null,0,4.5504046809811231E-2,0.18213715394130034,0.34897077492813733,0.56961504728898338,38.700000000000195,15.839793281653616]
[null,0,4.7054724131043703E-2,0.18541497820028907,0.35367752131739677,0.57582234059856019,38.800000000000196,15.773195876288529]
[null,0,4.8628505597040059E-2,0.18871581555751724,0.35840659080045351,0.58205069523736341,38.900000000000198,15.706940874035858]
[null,0,5.022527052640758E-2,0.19203954220625455,0.36315785673804346,0.58829998195539102,39.000000000000199,15.641025641025511]
[null,0,5.1844899612038649E-2,0.19538603570109891,0.36793119384469974,0.59457007285191021,39.1000000000002,15.575447570332351]
[null,0,5.3487274904009265E-2,0.19875517494082343,0.37272647817157806,0.600860841358274,39.200000000000202,15.510204081632523]
[null,0,5.5152279792740545E-2,0.20214684015148579,0.37754358708954583,0.60717216222100212,39.300000000000203,15.445292620865008]
[null,0,5.683979899241795E-2,0.20556091286979564,0.38238239927252843,0.61350391148511829,39.400000000000205,15.380710659898345]
[null,0,5.8549718524664444E-2,0.20899727592673559,0.38724279468110889,0.61985596647774144,39.500000000000206,15.3164556962024]
[null,0,6.0281925702462123E-2,0.21245581343143027,0.39212465454637657,0.62622820579192617,39.600000000000207,15.252525252525121]
[null,0,6.2036309114318615E-2,0.21593641075525996,0.39702786135401869,0.63262050927074542,39.700000000000209,15.188916876574176]
[null,0,6.381275860867372E-2,0.21943895451621445,0.40195229882865385,0.63903275799161507,39.80000000000021,15.125628140703384]
[null,0,6.5611165278541994E-2,0.22296333256348197,0.40689785191839911,0.64546483425085277,39.900000000000212,15.062656641603876]
[null,0,6.7431421446387946E-2,0.22650943396227172,0.41186440677967168,0.65191662154847074,40.000000000000213,14.999999999999865]
[null,0,6.9273420649228049E-2,0.23007714897886175,0.41685185076221465,0.65838800457319291,40.100000000000215,14.937655860348993]
[null,0,7.1137057623957764E-2,0.23366636906587243,0.42186007239434975,0.66487886918769934,40.200000000000216,14.87562189054713]
[null,0,7.3022228292897839E-2,0.23727698684775814,0.42688896136844712,0.67138910241408634,40.300000000000217,14.813895781637584]
[null,0,7.4928829749557474E-2,0.24090889610651675,0.43193840852661364,0.67791859241954699,40.400000000000219,14.752475247524618]
[null,0,7.6856760244609398E-2,0.2445619917676099,0.43700830584659023,0.68446722850225938,40.50000000000022,14.691358024691223]
[null,0,7.8805919172074371E-2,0.24823616988609237,0.44209854642786123,0.69103490107748655,40.600000000000222,14.630541871921046]
[null,0,8.0776207055710716E-2,0.2519313276329469,0.44720902447796645,0.69762150166388115,40.700000000000223,14.570024570024437]
[null,0,8.2767525535605832E-2,0.25564736328162069,0.45233963529901594,0.70422692286999,40.800000000000225,14.509803921568494]
[null,0,8.4779777354965502E-2,0.2593841761947589,0.45749027527440123,0.71085105838095741,40.900000000000226,14.449877750611112]
[null,0,8.6812866347098547E-2,0.26314166681113282,0.4626608418557025,0.71749380294542286,41.000000000000227,14.39024390243889]
[null,0,8.8866697422593358E-2,0.26691973663276214,0.4678512335497873,0.72415505236261146,41.100000000000229,14.330900243308868]
[null,0,9.0941176556682352E-2,0.27071828821222149,0.47306134990609644,0.73083470346961077,41.20000000000023,14.271844660194038]
[null,0,9.3036210776791611E-2,0.2745372251401344,0.47829109150411481,0.73753265412883184,41.300000000000232,14.213075060532553]
[null,0,9.5151708150273143E-2,0.27837645203284894,0.4835403599410249,0.74424880321565534,41.400000000000233,14.154589371980542]
[null,0,9.7287577772315684E-2,0.28223587452029125,0.48880905781953826,0.75098305060625326,41.500000000000234,14.096385542168537]
[null,0,9.9443729754031054E-2,0.28611539923399454,0.4940970887359018,0.75773529716558541,41.600000000000236,14.038461538461402]
[null,0,0.10162007521071487,0.29001493379530241,0.4994043572680788,0.76450544473557336,41.700000000000237,13.980815347721688]
[null,0,0.10381652625027671,0.29393438680374206,0.50473076896409974,0.77129339612344094,41.800000000000239,13.923444976076418]
[null,0,0.10603299596183641,0.29787366782556124,0.51007623033057581,0.77809905509021804,41.90000000000024,13.866348448687216]
[null,0,0.10826939840448783,0.30183268738243524,0.51544064882138418,0.78492232633941961,42.000000000000242,13.809523809523672]
[null,0,0.11052564859622091,0.30581135694032907,0.52082393282650696,0.79176311550587186,42.100000000000243,13.752969121140005]
[null,0,0.11280166250300622,0.30980958889852439,0.52622599166103556,0.79862132914471096,42.200000000000244,13.696682464454838]
[null,0,0.11509735702803313,0.31382729657879826,0.53164673555432618,0.80549687472052656,42.300000000000246,13.640661938534141]
[null,0,0.11741265000110418,0.31786439421475804,0.53708607563931188,0.81238966059666717,42.400000000000247,13.58490566037722]
[null,0,0.11974746016817947,0.3219207969413268,0.54254392394196482,0.81929959602469182,42.500000000000249,13.529411764705745]
[null,0,0.12210170718107044,0.32599642078437702,0.54802019337090746,0.8262265911339719,42.60000000000025,13.47417840375573]
[null,0,0.12447531158728009,0.3300911826505103,0.55351479770716827,0.83317055692143882,42.700000000000252,13.419203747072462]
[null,0,0.12686819481998798,0.33420500031698341,0.55902765159408496,0.84013140524147778,42.800000000000253,13.364485981308274]
[null,0,0.12928027918817525,0.33833779242177137,0.5645586705273441,0.84710904879595683,42.900000000000254,13.310023310023173]
[null,5.88754783636333E-6,0.13171148786689135,0.34248947845377425,0.57010777084516462,0.85410340112440297,43.000000000000256,13.255813953488232]
[null,2.9141100710054443E-5,0.13416174488765595,0.34665997874315735,0.57567486971861448,0.86111437659430867,43.100000000000257,13.201856148491739]
[null,6.9989611892948918E-5,0.13663097512899713,0.35084921445182854,0.58125988514206439,0.86814189039157585,43.200000000000259,13.14814814814801]
[null,1.2836092176627295E-4,0.1391191043071226,0.35505710756404796,0.58686273592377403,0.87518585851109398,43.30000000000026,13.094688221708868]
[null,2.0418372233641611E-4,0.14162605896671959,0.35928358087716544,0.59248334167660544,0.88224619774744317,43.400000000000261,13.04147465437774]
[null,2.9738754832154488E-4,0.14415176647188593,0.36352855799248973,0.59812162280886916,0.88932282568573118,43.500000000000263,12.988505747126297]
[null,4.0790276836579165E-4,0.14669615499718602,0.36779196330628222,0.60377750051529311,0.89641566069255363,43.600000000000264,12.935779816513623]
[null,5.3566057637903801E-4,0.1492591535188319,0.37207372200087524,0.60945089676811803,0.90352462190707905,43.700000000000266,12.88329519450787]
[null,6.8059298300027628E-4,0.15184069180598633,0.37637376003591166,0.61514173430831254,0.91064962923225512,43.800000000000267,12.831050228310364]
[null,8.4263280718270659E-4,0.15444070041218746,0.38069200413970716,0.62084993663691124,0.91779060332613738,43.900000000000269,12.779043280182094]
[null,1.0217136678985119E-3,0.1570591106668906,0.38502838180072774,0.62657542800646793,0.92494746559333263,44.00000000000027,12.727272727272588]
[null,1.2177699759616323E-3,0.15969585466712879,0.3893828212591865,0.63231813341262966,0.93212013817656403,44.100000000000271,12.675736961451108]
[null,{"$f":"IF(D$75>0.2*($H296),(D$75-0.2*($H296))^2/(D$75+0.8*($H296)),0)","v":1.4307369259665438E-3},{"$f":"IF(E$75>0.2*($H296),(E$75-0.2*($H296))^2/(E$75+0.8*($H296)),0)","v":0.16235086526928647},{"$f":"IF(F$75>0.2*($H296),(F$75-0.2*($H296))^2/(F$75+0.8*($H296)),0)","v":0.39375525149875434},{"$f":"IF(G$75>0.2*($H296),(G$75-0.2*($H296))^2/(G$75+0.8*($H296)),0)","v":0.63807797858582049},{"$f":"IF(H$75>0.2*($H296),(H$75-0.2*($H296))^2/(H$75+0.8*($H296)),0)","v":0.93930854394834495},44.200000000000273,{"$f":"IF(G296>0,1000/G296-10,1000)","v":12.624434389140131}]
[null,1.6605504883412782E-3,0.16502407608098713,0.39814560223838119,0.64385488998304119,0.94651260650276925,44.300000000000274,12.573363431151101]
[null,1.9071474015130399E-3,0.16771542145309259,0.40255380392423273,0.64964879477977877,0.95373225014741159,{"$f":"G297+0.1","v":44.400000000000276},12.522522522522383]
[null,2.1704651641845222E-3,0.17042483647181181,0.40697978772173277,0.65545962086202736,0.96096739989533853,44.500000000000277,12.47191011235941]
[null,2.4504420277192164E-3,0.17315225695091621,0.41142348550771413,0.66128729681841147,0.96821798145722227,44.600000000000279,12.42152466367699]
[null,2.7470169886342865E-3,0.17589761942406401,0.41588482986267722,0.66713175193242236,0.97548392123356731,44.70000000000028,12.371364653243706]
[null,3.0601297811989328E-3,0.17866086113722579,0.42036375406314958,0.67299291617475088,0.98276514630703393,44.800000000000281,12.321428571428431]
[null,3.3897208701371933E-3,0.18144192004121651,0.4248601920741521,0.67887072019573058,0.99006158443487136,44.900000000000283,12.271714922048858]
[null,3.7357314434329986E-3,0.18424073478432582,0.42937407854176318,0.68476509531787577,0.99737316404144649,45.000000000000284,12.222222222222083]
[null,4.0981034052363328E-3,0.18705724470504972,0.43390534878578269,0.69067597352852117,1.0046998142108747,45.100000000000286,12.172949002217155]
[null,4.4767793688689451E-3,0.18989138982492076,0.43845393879249661,0.69660328747256073,1.0120414646797464,45.200000000000287,12.123893805309596]
[null,4.8717026499277985E-3,0.19274311084143361,0.44301978520753416,0.70254697044528025,1.0193980458299527,45.300000000000288,12.07505518763783]
[null,5.2828172594852549E-3,0.19561234912106767,0.44760282532882323,0.70850695638528849,1.026769488681605,45.40000000000029,12.026431718061534]
[null,5.7100678973840534E-3,0.1984990466924017,0.45220299709963752,0.71448317986753629,1.0341557248860465,45.500000000000291,11.978021978021836]
[null,6.1533999456260032E-3,0.20140314623932176,0.45682023910173525,0.7204755760964332,1.0415566867189552,45.600000000000293,11.929824561403368]
[null,6.6127594618530594E-3,0.20432459109432102,0.46145449054859239,0.72648408089905225,1.0489723070735437,45.700000000000294,11.881838074398107]
[null,7.0880931729188417E-3,0.20726332523188681,0.46610569127871865,0.73250863071842298,1.0564025194538398,45.800000000000296,11.834061135371037]
[null,7.5793484685500101E-3,0.21021929326197808,0.47077378174906737,0.73854916260691417,1.0638472579680571,45.900000000000297,11.786492374727526]
[null,8.0864733950956127E-3,0.21319244042358837,0.47545870302852888,0.74460561421970162,1.0713064573220585,46.000000000000298,11.739130434782467]
[null,8.6094166493633911E-3,0.21618271257839564,0.48016039679151007,0.7506779238083231,1.078780052812897,46.1000000000003,11.691973969631096]
[null,9.1481275725416415E-3,0.21919005620449519,0.48487880531159805,0.75676603021431432,1.0862679803224427,46.200000000000301,11.645021645021504]
[null,9.7025561442052669E-3,0.22221441839021577,0.48961387145530538,0.76286987286292995,1.093770176311095,46.300000000000303,11.598272138228801]
[null,1.0272652976405131E-2,0.22525574682801802,0.49436553867589783,0.76898939175694414,1.1012865778115712,46.400000000000304,11.551724137930893]
[null,1.0858369307839273E-2,0.22831398980847362,0.49913375100730334,0.77512452747053429,1.1088171224227827,46.500000000000306,11.505376344085882]
[null,1.1459656998104658E-2,0.23138909621432302,0.50391845305809779,0.78127522114323966,1.1163617483037824,46.600000000000307,11.459227467811019]
[null,1.2076468522028521E-2,0.2344810155146117,0.50871959000556966,0.78744141447400129,1.123920394167794,46.700000000000308,11.413276231263243]
[null,1.270875696407809E-2,0.23758969775890323,0.5135371075898616,0.79362304971527509,1.1314929992763163,46.80000000000031,11.367521367521228]
[null,1.3356476012847614E-2,0.24071509357156939,0.51837095210818773,0.79982006966722563,1.1390795034333054,46.900000000000311,11.32196162046894]
[null,1.4019579955621302E-2,0.24385715414615258,0.5232210704091248,0.80603241767198686,1.1466798469794275,47.000000000000313,11.276595744680709]
[null,1.4698023673011562E-2,0.24701583123980475,0.52808740988697644,0.81226003760800369,1.1542939707863891,47.100000000000314,11.231422505307712]
[null,1.5391762633670942E-2,0.25019107716779665,0.53296991847621067,0.81850287388444032,1.1619218162513345,47.200000000000315,11.186440677965962]
[null,1.610075288907736E-2,0.25338284479810058,0.53786854464596867,0.82476087143566401,1.1695633252913205,47.300000000000317,11.141649048625652]
[null,1.6824951068390503E-2,0.25659108754604099,0.54278323739464107,0.83103397571579252,1.1772184403378552,47.400000000000318,11.097046413501968]
[null,1.7564314373379779E-2,0.25981575936901619,0.54771394624451653,0.8373221326933169,1.1848871043315059,47.50000000000032,11.052631578947228]
[null,1.8318800573421903E-2,0.26305681476129,0.55266062123649751,0.84362528884579102,1.1925692607165832,47.600000000000321,11.008403361344396]
[null,1.9088368000567086E-2,0.26631420874884681,0.55762321292488193,0.84994339115458428,1.2002648534358824,47.700000000000323,10.964360587001956]
[null,1.9872975544673432E-2,0.26958789688431667,0.56260167237221226,0.85627638709970511,1.207973826925494,47.800000000000324,10.920502092050068]
[null,2.0672582648608131E-2,0.27287783524196441,0.56759595114418893,0.86262422465468669,1.2156961261096837,47.900000000000325,10.876826722338063]
[null,2.1487149303514589E-2,0.27618398041274261,0.572606001304648,0.86898685228153683,1.2234316963958263,48.000000000000327,10.83333333333319]
[null,2.2316636044144834E-2,0.27950628949940975,0.57763177541060284,0.87536421892575256,1.2311804836694165,48.100000000000328,10.790020790020648]
[null,2.3161003944256086E-2,0.28284472011171025,0.58267322650734821,0.88175627401139633,1.2389424342891295,48.20000000000033,10.746887966804838]
[null,2.4020214612070385E-2,0.28619923036161582,0.58773030812362403,0.88816296743623258,1.24671749508195,48.300000000000331,10.703933747411867]
[null,2.4894230185796739E-2,0.28956977885862795,0.59280297426684014,0.89458424956692528,1.2545056133383576,48.400000000000333,10.661157024793248]
[null,2.5783013329215197E-2,0.29295632470514182,0.59789117941836456,0.90102007123429695,1.2623067368075775,48.500000000000334,10.618556701030787]
[null,2.6686527227321052E-2,0.29635882749186693,0.60299487852886446,0.90747038372864297,1.2701208136928821,48.600000000000335,10.576131687242658]
[null,2.7604735582029281E-2,0.2997772472933079,0.60811402701370876,0.91393513879510635,1.2779477926469582,48.700000000000337,10.533880903490619]
[null,2.853760260793815E-2,0.30321154466330236,0.61324858074842914,0.92041428862910912,1.2857876227673246,48.800000000000338,10.491803278688383]
[null,2.9485093028150645E-2,0.30666168063061472,0.61839849606423214,0.92690778587183853,1.2936402535918095,48.90000000000034,10.449897750511106]
[null,3.0447172070153957E-2,0.31012761669458722,0.62356372974357388,0.93341558360579102,1.3015056350940848,49.000000000000341,10.40816326530598]
[null,3.1423805461755237E-2,0.31360931482084486,0.6287442390157828,0.93993763535036923,1.3093837176792509,49.100000000000342,10.366598778003933]
[null,3.2414959427073571E-2,0.3171067374370557,0.63393998155274112,0.94647389505753354,1.3172744521794784,49.200000000000344,10.325203252032377]
[null,3.3420600682586725E-2,0.32061984742874289,0.63915091546461611,0.95302431710750479,1.3251777898497015,49.300000000000345,10.283975659229068]
[null,3.4440696433233095E-2,0.32414860813515234,0.64437699929564796,0.95958885630452384,1.3330936823633637,49.400000000000347,10.242914979756943]
[null,3.5475214368566557E-2,0.32769298334516966,0.64961819201998405,0.9661674678726575,1.3410220818082164,49.500000000000348,10.202020202020059]
[null,3.6524122658964805E-2,0.33125293729329031,0.65487445303756797,0.97276010745165875,1.3489629406821677,49.60000000000035,10.161290322580502]
[null,3.758738995189017E-2,0.33482843465563977,0.66014574217007926,0.97936673109287664,1.3569162118891798,49.700000000000351,10.120724346076315]
[null,3.8664985368201288E-2,0.33841944054604262,0.66543201965691834,0.98598729525521334,1.3648818487352172,49.800000000000352,10.080321285140421]
[null,3.9756878498516939E-2,0.34202592051214376,0.67073324615124663,0.99262175680113496,1.3728598049242471,49.900000000000354,10.0400801603205]
[null,4.0863039399628737E-2,0.34564784053157444,0.67604938271606829,0.99927007299272441,1.3808500345542785,50.000000000000355,9.9999999999998579]
[null,4.1983438590964615E-2,0.34928516700816831,0.68138039082036406,1.0059322014877849,1.3888524921134593,50.100000000000357,9.9600798403192208]
[null,4.3118047051100984E-2,0.35293786676822658,0.68672623233527208,1.0126081003359928,1.3968671324762163,50.200000000000358,9.9203187250994596]
[null,4.4266836214322432E-2,0.35660590705682349,0.69208686953030918,1.0192977279750886,1.4048939108994332,50.30000000000036,9.8807157057652653]
[null,4.5429777967230578E-2,0.36028925553416569,0.69746226506964637,1.0260010432271229,1.4129327830186895,50.400000000000361,9.8412698412696997]
[null,4.660684464539884E-2,0.36398788027199119,0.70285238200842204,1.0327180052947413,1.4209837048445326,50.500000000000362,9.8019801980196597]
[null,{"$f":"IF(D$75>0.2*($H360),(D$75-0.2*($H360))^2/(D$75+0.8*($H360)),0)","v":4.7798009030074175E-2},{"$f":"IF(E$75>0.2*($H360),(E$75-0.2*($H360))^2/(E$75+0.8*($H360)),0)","v":0.36770174975001485},{"$f":"IF(F$75>0.2*($H360),(F$75-0.2*($H360))^2/(F$75+0.8*($H360)),0)","v":0.70825718378910318},{"$f":"IF(G$75>0.2*($H360),(G$75-0.2*($H360))^2/(G$75+0.8*($H360)),0)","v":1.0394485737575139},{"$f":"IF(H$75>0.2*($H360),(H$75-0.2*($H360))^2/(H$75+0.8*($H360)),0)","v":1.4290466327587954},50.600000000000364,{"$f":"IF(G360>0,1000/G360-10,1000)","v":9.762845849802229}]
[null,4.9003244344924785E-2,0.37143083285241896,0.71367663423788896,1.0461927085683107,1.4371215235109638,50.700000000000365,9.7238658777118907]
[null,5.0222524252833189E-2,0.37517509886438571,0.7191106975611592,1.0529503700497198,1.4452083342145814,{"$f":"G361+0.1","v":50.800000000000367},9.6850393700785986]
[null,5.1455822852733375E-2,0.3789345174686724,0.72455933834196096,1.0597215188905027,1.4533070223436937,50.900000000000368,9.6463654223967161]
[null,5.2703114676493405E-2,0.38270905874223193,0.73002252153654323,1.0665061161421021,1.4614175457293481,51.000000000000369,9.6078431372547612]
[null,5.3964374685840283E-2,0.38649869315287033,0.73550021247092812,1.0733041232151783,1.4695398625561147,51.100000000000371,9.5694716242660043]
[null,5.5239578269329057E-2,0.39030339155595078,0.74099237683752539,1.0801155018761983,1.477673931358668,51.200000000000372,9.5312499999998579]
[null,5.6528701239353385E-2,0.39412312519113246,0.74649898069178466,1.0869402142440532,1.4858197110183924,51.300000000000374,9.4931773879140877]
[null,5.7831719829199303E-2,0.39795786567915531,0.75201999044889134,1.0937782227867279,1.4939771607600385,51.400000000000375,9.455252918287794]
[null,5.9148610690139304E-2,0.4018075850186596,0.75755537288049701,1.1006294903179976,1.5021462401484122,51.500000000000377,9.4174757281551962]
[null,6.0479350888568512E-2,0.40567225558304887,0.76310509511149438,1.1074939799941736,1.5103269090851075,51.600000000000378,9.3798449612401669]
[null,6.1823917903180238E-2,0.40955185011738587,0.7686691246168218,1.1143716553108769,1.5185191278052674,51.700000000000379,9.3423597678915407]
[null,6.3182289622182683E-2,0.41344634173533318,0.77424742921831569,1.1212624800998594,1.5267228568743976,51.800000000000381,9.3050193050191616]
[null,6.4554444340553713E-2,0.41735570391612437,0.77983997708158936,1.1281664185258526,1.5349380571852009,51.900000000000382,9.2678227360306877]
[null,6.59403607573366E-2,0.42127991050157942,0.78544673671295984,1.135083435083462,1.5431646899544615,52.000000000000384,9.2307692307690878]
[null,6.7340017972971816E-2,0.42521893569314873,0.79106767695639779,1.1420134945940876,1.5514027167199533,52.100000000000385,9.1938579654509134]
[null,6.8753395486669408E-2,0.42917275404900074,0.79670276699052622,1.1489565622028894,1.5596520993373972,52.200000000000387,9.1570881226052236]
[null,7.0180473193817497E-2,0.43314134048114067,0.80235197632564548,1.1559126033757834,1.5679127999774409,52.300000000000388,9.1204588910132429]
[null,7.1621231383427991E-2,0.43712467025256418,0.80801527480079427,1.1628815838964686,1.5761847811226806,52.400000000000389,9.083969465648714]
[null,7.3075650735619932E-2,0.44112271897444899,0.81369263258084978,1.1698634698634975,1.5844680055647136,52.500000000000391,9.0476190476189053]
[null,7.4543712319137867E-2,0.44513546260337583,0.8193840201536533,1.1768582276873687,1.5927624364012243,52.600000000000392,9.0114068441063218]
[null,7.6025397588907528E-2,0.4491628774385889,0.82508940832717836,1.1838658240876654,1.6010680370331092,52.700000000000394,8.9753320683110545]
[null,7.7520688383625899E-2,0.45320494011928508,0.830808768226725,1.1908862260902151,1.6093847711616271,52.800000000000395,8.9393939393937991]
[null,7.9029566923386682E-2,0.45726162762193751,0.83654207129214919,1.1979194010242884,1.6177126027855839,52.900000000000396,8.9035916824195169]
[null,8.0552015807339963E-2,0.46133291725765102,0.84228928927512214,1.2049653165198266,1.6260514961985495,53.000000000000398,8.8679245283017458]
[null,8.2088018011387487E-2,0.46541878666955294,0.8480503942364267,1.212023940504706,1.6344014159861118,53.100000000000399,8.832391713747505]
[null,8.3637556885909792E-2,0.46951921383020973,0.85382535854327779,1.2190952412020235,1.6427623270231499,53.200000000000401,8.7969924812028673]
[null,8.5200616153528572E-2,0.47363417703908056,0.85961415486667792,1.2261791871274257,1.6511341944711528,53.300000000000402,8.7617260787991071]
[null,8.6777179906900537E-2,0.47776365491999612,0.86541675617880232,1.2332757470864533,1.6595169837755488,53.400000000000404,8.7265917602994847]
[null,8.8367232606545637E-2,0.48190762641867407,0.87123313575041439,1.2403848901719308,1.667910660663088,53.500000000000405,8.6915887850465872]
[null,8.9970759078706011E-2,0.48606607080025949,0.8770632671483084,1.2475065857613745,1.6763151911392358,53.600000000000406,8.6567164179103067]
[null,9.1587744513238104E-2,0.49023896764689734,0.88290712423278606,1.2546408035144341,1.6847305414856037,53.700000000000408,8.6219739292363577]
[null,9.3218174461535561E-2,0.49442629685533324,0.88876468115515583,1.2617875133703624,1.6931566782574079,53.800000000000409,8.587360594795399]
[null,9.4862034834483952E-2,0.49862803863454386,0.8946359123552664,1.2689466855455129,1.701593568280954,53.900000000000411,8.5528756957326983]
[null,9.6519311900446103E-2,0.5028441735033965,0.90052079255906525,1.2761182905308681,1.7100411786511549,54.000000000000412,8.5185185185183769]
[null,9.8189992283277933E-2,0.5070746822883343,0.90641929677618449,1.2833022990895893,1.7184994767290673,54.100000000000414,8.4842883548981938]
[null,9.9874062960374502E-2,0.51131954612109143,0.91233140029755488,1.2904986822545987,1.7269684301394634,54.200000000000415,8.4501845018448769]
[null,0.10157151126074679,0.5155787464364372,0.91825707869304984,1.2977074113261922,1.735448006768431,54.300000000000416,8.4162062615099877]
[null,0.10328232486312666,0.51985226496994286,0.92419630780915074,1.3049284578696645,1.7439381747609886,54.400000000000418,8.3823529411763289]
[null,0.10500649179410196,0.52414008375577892,0.93014906376664164,1.3121617937129786,1.7524389025187388,54.500000000000419,8.3486238532108672]
[null,0.10674400042628041,0.52844218512453767,0.93611532295832978,1.3194073909444457,1.7609501586975416,54.600000000000421,8.3150183150181753]
[null,0.10849483947648247,0.53275855170108277,0.94209506204679194,1.3266652219104429,1.7694719122052165,54.700000000000422,8.2815356489943746]
[null,0.1102589980039614,0.53708916640242188,0.94808825796214458,1.3339352592131444,1.7780041321992637,54.800000000000423,8.2481751824816101]
[null,0.11203646540865284,0.54143401243560896,0.95409488789984187,1.3412174757082895,1.786546788084618,54.900000000000425,8.2149362477229921]
[null,0.11382723142945124,0.5457930732956684,0.96011492931849474,1.3485118445029669,1.7950998495114248,55.000000000000426,8.1818181818180413]
[null,0.11563128614251365,0.55016633276354499,0.96614835993771808,1.355818338953424,1.8036632863728321,55.100000000000428,8.1488203266786243]
[null,0.11744861995959138,0.55455377490407998,0.97219515773599918,1.3631369326629053,1.8122370688028224,55.200000000000429,8.1159420289853657]
[null,0.11927922362638771,0.55895538406400846,0.97825530094859081,1.3704675994795084,1.8208211671740531,55.300000000000431,8.0831826401445248]
[null,0.12112308822094307,0.56337114486998385,0.98432876806542935,1.3778103134940687,1.82941555209573,55.400000000000432,8.050541516245346]
[null,0.12298020515204573,0.56780104222662409,0.99041553782907321,1.3851650490380636,1.8380201944114996,55.500000000000433,8.0180180180178766]
[null,0.12485056615766923,0.57224506131458119,0.99651558923266692,1.3925317806815389,1.8466350651973629,55.600000000000435,7.9856115107912267]
[null,0.12673416330343545,0.57670318758863626,1.0026289015179268,1.3999104832310629,1.8552601357596179,55.700000000000436,7.9533213644522824]
[null,0.12863098898110234,0.58117540677581181,1.0087554541731454,1.4073011317276927,1.8638953776328138,55.800000000000438,7.9211469534048788]
[null,0.13054103590707947,0.58566170487351654,1.0148952269312286,1.4147037014449795,1.872540762577743,55.900000000000439,7.8890876565293766]
[null,0.13246429712096491,0.59016206814769956,1.0210481997677392,1.422118167886973,1.8811962625794338,56.000000000000441,7.8571428571427155]
[null,0.13440076598411024,0.59467648313103816,1.027214352898975,1.429544506786268,1.8898618498451865,56.100000000000442,7.8253119429588622]
[null,0.13635043617820905,0.59920493662114105,1.0333936667800629,1.4369826941020594,1.8985374968026125,56.200000000000443,7.7935943060496804]
[null,0.13831330170390824,0.60374741567877344,1.0395861221030729,1.4444327060182225,1.907223176097705,56.300000000000445,7.7619893428062525]
[null,0.1402893568794461,0.60830390762610675,1.0457916997951548,1.4518945189414141,1.9159188605929263,56.400000000000446,7.7304964539005674]
[null,0.14227859633931231,0.61287440004498528,1.0520103810166959,1.4593681094991919,1.9246245233653168,56.500000000000448,7.6991150442476481]
[null,0.1442810150329327,0.6174588807752176,1.0582421471594965,1.4668534545381604,1.9333401377046264,56.600000000000449,7.667844522968057]
[null,0.14629660822337573,0.62205733791288242,1.064486979844967,1.4743505311221214,1.9420656771114528,56.70000000000045,7.6366843033508296]
[null,0.14832537148608504,0.62666975980866402,1.0707448609223462,1.481859316530266,1.9508011152954217,56.800000000000452,7.6056338028167616]
[null,0.15036730070763227,0.63129613506619742,1.0770157724669356,1.4893797882553659,1.9595464261733662,56.900000000000453,7.5746924428821103]
[null,{"$f":"IF(D$75>0.2*($H424),(D$75-0.2*($H424))^2/(D$75+0.8*($H424)),0)","v":0.15242239208449412},{"$f":"IF(E$75>0.2*($H424),(E$75-0.2*($H424))^2/(E$75+0.8*($H424)),0)","v":0.63593645254044107},{"$f":"IF(F$75>0.2*($H424),(F$75-0.2*($H424))^2/(F$75+0.8*($H424)),0)","v":1.0832996967783544},{"$f":"IF(G$75>0.2*($H424),(G$75-0.2*($H424))^2/(G$75+0.8*($H424)),0)","v":1.4969119240019964},{"$f":"IF(H$75>0.2*($H424),(H$75-0.2*($H424))^2/(H$75+0.8*($H424)),0)","v":1.968301583867536},57.000000000000455,{"$f":"IF(G424>0,1000/G424-10,1000)","v":7.5438596491226662}]
[null,0.15449064212185112,0.64059070133606466,1.0895966163788151,1.5044557016847724,1.9770665627038198,57.100000000000456,7.513134851138215]
[null,0.15657204763241095,0.6452588708058612,1.0959065140114188,1.5120110994266096,1.9858413372099979,{"$f":"G425+0.1","v":57.200000000000458},7.4825174825173413]
[null,0.15866660573524935,0.64994095054916812,1.1022293726384604,1.5195780955569873,1.9946258821139884,57.300000000000459,7.4520069808026541]
[null,0.16077431385467958,0.654636930410323,1.1085651754397674,1.5271566686102596,2.0034201723421483,57.40000000000046,7.4216027874563046]
[null,0.16289516971913651,0.65934680047712035,1.1149139058110396,1.5347467973239493,2.012224183017552,57.500000000000462,7.3913043478259475]
[null,0.16502917136008841,0.66407055107930135,1.1212755473622211,1.5423484606370861,2.0210378894583196,57.600000000000463,7.3611111111109722]
[null,0.16717631711096659,0.66880817278705462,1.1276500839158841,1.5499616376885537,2.0298612671759506,57.700000000000465,7.3310225303291503]
[null,0.16933660560611707,0.67355965640953452,1.1340374995056255,1.5575863078154486,2.0386942918736679,57.800000000000466,7.3010380622835989]
[null,0.17151003577977406,0.67832499299340099,1.1404377783744899,1.5652224505514645,2.0475369394447926,57.900000000000468,7.2711571675300846]
[null,0.17369660686505298,0.68310417382137378,1.1468509049734028,1.572870045625288,2.0563891859711254,58.000000000000469,7.2413793103446871]
[null,0.17589631839296591,0.68789719041080777,1.1532768639596247,1.5805290729590171,2.0652510077213493,58.10000000000047,7.2117039586917713]
[null,0.17810917019145631,0.69270403451228113,1.1597156401952207,1.5881995126665887,2.0741223811494511,58.200000000000472,7.1821305841923007]
[null,0.18033516238445393,0.6975246981082035,1.1661672187455427,1.5958813450522285,2.0830032828931513,58.300000000000473,7.1526586620924846]
[null,0.18257429539095071,0.70235917341143872,1.1726315848777344,1.6035745506089096,2.0918936897723546,58.400000000000475,7.1232876712327382]
[null,0.18482656992409713,0.70720745286394904,1.1791087240592499,1.6112791100168424,2.1007935787876244,58.500000000000476,7.0940170940169551]
[null,0.1870919869903164,0.71206952913544852,1.1855986219563841,1.6189950041419596,2.1097029271186551,58.600000000000477,7.0648464163821139]
[null,0.18937054788844096,0.71694539512207911,1.1921012644328257,1.6267222140344322,2.1186217121227768,58.700000000000479,7.0357751277681757]
[null,0.19166225420886659,0.72183504394509923,1.1986166375482208,1.6344607209271955,2.1275499113334648,58.80000000000048,7.0068027210882953]
[null,0.19396710783272653,0.72673846894958871,1.2051447275567511,1.6422105062344883,2.1364875024588699,58.900000000000482,6.9779286926993507]
[null,0.19628511093108567,0.73165566370317225,1.211685520905734,1.6499715515504141,2.1454344633803641,59.000000000000483,6.9491525423727438]
[null,0.19861626596415302,0.736586621994755,1.2182390042342304,1.6577438386475085,2.1543907721510935,59.100000000000485,6.9204737732655133]
[null,0.20096057568051315,0.74153133783327452,1.2248051643716702,1.6655273494753271,2.163356406994557,59.200000000000486,6.8918918918917527]
[null,0.20331804311637616,0.74648980544646804,1.2313839883364919,1.6733220661590436,2.1723313463031881,59.300000000000487,6.8634064080942956]
[null,0.20568867159484808,0.75146201927965639,1.2379754633347972,1.6811279709980689,2.1813155686369612,59.400000000000489,6.8350168350166953]
[null,0.2080724647252179,0.75644797399454067,1.2445795767590211,1.6889450464646765,2.1903090527220042,59.50000000000049,6.8067226890754924]
[null,0.2104694264022641,0.76144766446801559,1.2511963161866133,1.6967732752026503,2.1993117774492341,59.600000000000492,6.7785234899327484]
[null,0.21287956080557907,0.7664610857909937,1.257825669378736,1.7046126400259343,2.2083237218729916,59.700000000000493,6.7504187604688717]
[null,0.21530287239891116,0.77148823326724791,1.264467624278971,1.7124631239173076,2.2173448652097019,59.800000000000495,6.7224080267557156]
[null,0.21773936592952764,0.77652910241227036,1.2711221690120509,1.720324710027072,2.2263751868365542,59.900000000000496,6.6944908180299123]
[null,0.22018904642759071,0.78158368895213493,1.2777892918825891,1.7281973816717404,2.2354146662901693,60.000000000000497,6.6666666666665293]
[null,0.22265191920555644,0.78665198882238829,1.2844689813738366,1.7360811223327584,2.2444632832653135,60.100000000000499,6.6389351081529391]
[null,0.22512798985758717,0.79173399816694101,1.2911612261464425,1.7439759156552157,2.2535210176135938,60.2000000000005,6.6112956810629839]
[null,0.2276172642589851,0.79682971333698271,1.2978660150372328,1.7518817454465934,2.262587849342192,60.300000000000502,6.5837479270313715]
[null,0.23011974856564066,0.80193913088990587,1.3045833370580024,1.7597985956755087,2.2716637586125983,60.400000000000503,6.5562913907283402]
[null,0.23263544921349977,0.80706224758824219,1.3113131813943142,1.7677264504704766,2.2807487257393544,60.500000000000504,6.528925619834574]
[null,0.23516437291804748,0.81219906039861622,1.3180555374043175,1.7756652941186863,2.2898427311888221,60.600000000000506,6.5016501650163647]
[null,0.2377065266738092,0.81734956649070556,1.3248103946175729,1.7836151110647838,2.2989457555779471,60.700000000000507,6.4744645799010172]
[null,0.24026191775386979,0.82251376323622383,1.3315777427338975,1.7915758859096764,2.3080577796730553,60.800000000000509,6.4473684210524951]
[null,0.2428305537094077,0.82769164820790575,1.338357571622212,1.7995476034093396,2.3171787843886396,60.90000000000051,6.4203612479473158]
[null,0.24541244236924686,0.83288321917851083,1.3451498713194059,1.8075302484736391,2.3263087507861737,61.000000000000512,6.3934426229506833]
[null,0.248007591839428,0.83808847411984266,1.3519546320292193,1.8155238061651711,2.335447660072937,61.100000000000513,6.3666121112928238]
[null,0.25061601050279037,0.84330741120177033,1.3587718441211225,1.8235282616981019,2.344595493600838,61.200000000000514,6.3398692810456154]
[null,0.25323770701857773,0.84854002879127521,1.3656014981292244,1.8315436004370316,2.3537522328652685,61.300000000000516,6.3132137030993718]
[null,0.25587269032205334,0.85378632545149535,1.3724435847511749,1.8395698078958533,2.3629178595039448,61.400000000000517,6.2866449511399267]
[null,0.25852096962413784,0.85904629994079706,1.3792980948470941,1.8476068697366459,2.3720923552957895,61.500000000000519,6.2601626016258791]
[null,0.26118255441105909,0.86431995121184713,1.3861650194385036,1.8556547717685574,2.3812757021597992,61.60000000000052,6.2337662337660973]
[null,0.26385745444402031,0.86960727841070218,1.3930443497072729,1.86371349994671,2.390467882153938,61.700000000000522,6.2074554294974327]
[null,0.26654567975888305,0.87490828087590677,1.3999360769945715,1.8717830403711107,2.39966887747403,61.800000000000523,6.1812297734626469]
[null,0.26924724066586769,0.88022295813760709,1.4068401927998402,1.879863379285579,2.4088786704526788,61.900000000000524,6.1550888529885555]
[null,0.27196214774926908,0.88555130991667141,1.4137566887797659,1.8879545030766782,2.4180972435581789,62.000000000000526,6.129032258064381]
[null,0.27469041186718829,0.8908933361238256,1.4206855567472716,1.8960563982726637,2.4273245793934533,62.100000000000527,6.1030595813203128]
[null,0.27743204415127881,0.8962490368587962,1.4276267886705121,1.9041690515424328,2.436560660694989,62.200000000000529,6.0771704180062933]
[null,0.28018705600651184,0.90161841240946883,1.4345803766718854,1.9122924496944953,2.4458054703317926,62.30000000000053,6.0513643659709722]
[null,0.2829554591109546,0.90700146325105724,1.4415463130270545,1.9204265796759517,2.4550589913043552,62.400000000000531,6.0256410256408905]
[null,0.28573726541556455,0.91239819004527789,1.4485245901639716,1.9285714285714726,2.4643212067436164,62.500000000000533,5.9999999999998632]
[null,0.28853248714399882,0.91780859363953793,1.4555152006619203,1.9367269836022925,2.4735920999099461,62.600000000000534,5.9744408945685539]
[null,0.29134113679244217,0.92323267506614182,1.4625181372505673,1.9448932321252286,2.4828716541921456,62.700000000000536,5.9489633173842336]
[null,0.29416322712944576,0.92867043554149331,1.4695333928090171,1.9530701616316806,2.4921598531064371,62.800000000000537,5.9235668789807558]
[null,0.29699877119578538,0.93412187646532263,1.4765609603648857,1.9612577597466656,2.501456680295481,62.900000000000539,5.8982511923687024]
[null,0.29984778230433173,0.93958699941991441,1.483600833093377,1.9694560142278497,2.5107621195273948,63.00000000000054,5.8730158730157367]
[null,0.30271027403993894,0.94506580616934832,1.4906530043163713,1.9776649129645876,2.5200761546947796,63.100000000000541,5.8478605388271223]
[null,0.30558626025934577,0.95055829865875419,1.4977174675015243,1.9858844439769832,2.5293987698137621,63.200000000000543,5.8227848101264463]
[null,0.30847575509109387,0.95606447901357039,1.5047942162613726,1.9941145954149473,2.5387299490230433,63.300000000000544,5.7977883096365144]
[null,{"$f":"IF(D$75>0.2*($H488),(D$75-0.2*($H488))^2/(D$75+0.8*($H488)),0)","v":0.31137877293545912},{"$f":"IF(E$75>0.2*($H488),(E$75-0.2*($H488))^2/(E$75+0.8*($H488)),0)","v":0.96158434953881522},{"$f":"IF(F$75>0.2*($H488),(F$75-0.2*($H488))^2/(F$75+0.8*($H488)),0)","v":1.5118832443524495},{"$f":"IF(G$75>0.2*($H488),(G$75-0.2*($H488))^2/(G$75+0.8*($H488)),0)","v":2.0023553555572655},{"$f":"IF(H$75>0.2*($H488),(H$75-0.2*($H488))^2/(H$75+0.8*($H488)),0)","v":2.548069676582946},63.400000000000546,{"$f":"IF(G488>0,1000/G488-10,1000)","v":5.7728706624604325}]
[null,0.31429532846440106,0.96711791271837277,1.5189845456744155,2.0106067128106875,2.5574179368744963,63.500000000000547,5.7480314960628558]
[null,0.31722543662152314,0.97266517121427876,1.526098114269185,2.0188686557090079,2.5667747143984831,{"$f":"G489+0.1","v":63.600000000000549},5.7232704402514365]
[null,0.32016911262205211,0.97822612786602392,1.5332239443200746,2.0271411729121662,2.5761399937745488,63.70000000000055,5.6985871271584205]
[null,0.32312637195282984,0.9838007856898664,1.5403620301509562,2.0354242532053592,2.5855137597402842,63.800000000000551,5.6739811912224347]
[null,0.32609723037231997,0.98938914787814736,1.5475123662254135,2.0437178854981437,2.594895997150318,63.900000000000553,5.6494522691704443]
[null,0.32908170391063102,0.99499121779862554,1.5546749471459165,2.0520220588235749,2.6042866909754387,64.000000000000554,5.624999999999865]
[null,0.33207980886955274,1.0006069989938129,1.5618497676529963,2.0603367623373279,2.6136858263017038,64.100000000000549,5.6006240249608652]
[null,0.33509156182260763,1.0062364951803227,1.5690368226244333,2.0686619853168398,2.6230933883295666,64.200000000000543,5.5763239875388084]
[null,0.3381169796151175,1.0118797102482289,1.5762361070744513,2.0769977171604634,2.6325093623730131,64.300000000000537,5.5520995334368841]
[null,0.34115607936428444,1.0175366482604311,1.5834476161529223,2.0853439473866189,2.6419337338587008,64.400000000000531,5.5279503105588788]
[null,0.34420887845928683,1.0232073134520299,1.5906713451445771,2.0937006656329609,2.6513664883251105,64.500000000000526,5.5038759689921211]
[null,0.34727539456138801,1.0288917102297099,1.5979072894682234,2.1020678616555473,2.660807611421701,64.60000000000052,5.4798761609905871]
[null,0.3503556456040634,1.0345898431711382,1.6051554446759775,2.110445525328029,2.6702570889080812,64.700000000000514,5.4559505409581455]
[null,0.35344964979313775,1.040301717024358,1.6124158064524954,2.1188336466408257,2.6797149066531754,64.800000000000509,5.4320987654319772]
[null,0.35655742560694009,1.0460273367072053,1.6196883706142184,2.1272322157003325,2.68918105063441,64.900000000000503,5.408320493066137]
[null,0.35967899179647267,1.0517667073067283,1.6269731331086272,2.135641222728121,2.698655506936904,65.000000000000497,5.384615384615266]
[null,0.36281436738559136,1.0575198340786098,1.6342700900134941,2.1440606580601442,2.7081382617526568,65.100000000000492,5.3609831029184711]
[null,0.36596357167120619,1.0632867224466098,1.6415792375361569,2.1524905121459672,2.7176293013797621,65.200000000000486,5.3374233128833204]
[null,0.36912662422348941,1.0690673780020028,1.6489005720127854,2.1609307755479779,2.7271286122216067,65.30000000000048,5.313935681470026]
[null,0.37230354488610568,1.07486180650304,1.6562340899076733,2.1693814389406385,2.7366361807861059,65.400000000000475,5.2905198776757292]
[null,0.37549435377644785,1.0806700138743996,1.6635797878125147,2.1778424931097082,2.7461519936849093,65.500000000000469,5.2671755725189744]
[null,0.37869907128589608,1.0864920062066663,1.670937662445712,2.1863139289515052,2.7556760376326501,65.600000000000463,5.2439024390242821]
[null,0.38191771808008412,1.092327789755801,1.6783077106516722,2.1947957374721536,2.7652082994461744,65.700000000000458,5.220700152206895]
[null,0.38515031509918363,1.0981773709426288,1.685689929400118,2.2032879097868441,2.7747487660437895,65.800000000000452,5.197568389057647]
[null,0.38839688355820301,1.1040407563523345,1.6930843157854105,2.2117904371191144,2.7842974244445253,65.900000000000446,5.1745068285279707]
[null,0.39165744494729748,1.1099179527339593,1.70049086702587,2.2203033108001078,2.7938542617673812,66.000000000000441,5.151515151515051]
[null,0.39493202103209746,1.1158089669999138,1.7079095804631075,2.22882652226787,2.8034192652306036,66.100000000000435,5.1285930408471021]
[null,0.3982206338540481,1.1217138062254932,1.715340453561365,2.2373600630666304,2.8129924221509572,66.200000000000429,5.1057401812687839]
[null,0.40152330573076417,1.127632477648399,1.7227834839068605,2.2459039248460977,2.8225737199429992,66.300000000000423,5.0829562594267514]
[null,0.40484005925640082,1.133564988668277,1.7302386692071401,2.2544580993607708,2.8321631461183783,66.400000000000418,5.0602409638553265]
[null,0.40817091730203492,1.1395113468462512,1.7377060072904362,2.2630225784692346,2.841760688285115,66.500000000000412,5.0375939849623137]
[null,0.41151590301606528,1.1454715599044754,1.7451854961050361,2.2715973541334882,2.8513663341469115,66.600000000000406,5.0150150150149226]
[null,0.41487503982462226,1.1514456357256828,1.7526771337186478,2.2801824184182546,2.8609800715024503,66.700000000000401,4.9925037481258467]
[null,0.41824835143199629,1.1574335823527535,1.7601809183177843,2.2887777634903199,2.8706018882447126,66.800000000000395,4.9700598802394325]
[null,0.42163586182107748,1.1634354079882785,1.7676968482071469,2.2973833816178559,2.8802317723602897,66.900000000000389,4.9476831091179996]
[null,0.42503759525381046,1.1694511209941398,1.7752249218090144,2.3059992651697718,2.8898697119287156,67.000000000000384,4.9253731343282734]
[null,0.42845357627166469,1.1754807298910932,1.7827651376626428,2.3146254066150536,2.8995156951217926,67.100000000000378,4.9031296572279341]
[null,0.43188382969611588,1.1815242433583588,1.7903174944236679,2.3232617985221187,2.909169710202931,67.200000000000372,4.8809523809522979]
[null,0.43532838062914631,1.1875816702332171,1.7978819908635155,2.3319084335581715,2.9188317455264858,67.300000000000367,4.8588410104011075]
[null,0.43878725445375516,1.1936530195106183,1.8054586258688183,2.3405653044885746,2.9285017895371137,67.400000000000361,4.8367952522254392]
[null,0.44226047683448549,1.1997383003427897,1.8130473984408348,2.3492324041762114,2.9381798307691214,67.500000000000355,4.8148148148147367]
[null,0.44574807371796532,1.205837522038858,1.8206483076948821,2.3579097255808672,2.9478658578458283,67.60000000000035,4.7928994082839473]
[null,0.44925007133346312,1.2119506940644724,1.8282613528597655,2.3665972617586073,2.9575598594789301,67.700000000000344,4.7710487444607814]
[null,0.45276649619345566,1.2180778260414391,1.8358865332772196,2.3752950058611697,2.9672618244678737,67.800000000000338,4.7492625368730828]
[null,0.45629737509421342,1.2242189277473583,1.843523848401355,2.3840029511353515,2.9769717416992312,67.900000000000333,4.7275405007363052]
[null,0.45984273511639834,1.2303740091152731,1.8511732977981081,2.3927210909224139,2.9866896001460845,68.000000000000327,4.7058823529411065]
[null,0.46340260362567687,1.2365430802333197,1.8588348811446991,2.4014494186574793,2.9964153888674101,68.100000000000321,4.6842878120410472]
[null,0.46697700827334671,1.2427261513443886,1.866508598229093,2.4101879278689498,3.0061490970074773,68.200000000000315,4.6627565982404011]
[null,0.47056597699697755,1.2489232328457878,1.8741944489494697,2.4189366121779137,3.015890713795244,68.30000000000031,4.641288433382071]
[null,0.47416953802106943,1.2551343352889182,1.881892433313697,2.4276954652975729,3.0256402285437614,68.400000000000304,4.6198830409356066]
[null,0.47778771985772062,1.26135946937895,1.8896025514388088,2.4364644810326603,3.0353976306495816,68.500000000000298,4.5985401459853374]
[null,0.48142055130731465,1.2675986459745092,1.8973248035504922,2.4452436532788813,3.0451629095921775,68.600000000000293,4.5772594752185967]
[null,0.48506806145921977,1.2738518760873692,1.9050591899825731,2.4540329760223387,3.0549360549333553,68.700000000000287,4.556040756914058]
[null,0.4887302796925016,1.2801191708821473,1.912805711176516,2.4628324433389821,3.0647170563166846,68.800000000000281,4.5348837209301731]
[null,0.49240723567665451,1.2864005416760116,1.9205643676809228,2.4716420493940516,3.0745059034669273,68.900000000000276,4.5137880986937002]
[null,0.49609895937234205,1.2926959999383878,1.9283351601510375,2.4804617884415276,3.0843025861894708,69.00000000000027,4.4927536231883494]
[null,0.49980548103215905,1.2990055572906796,1.9361180893482586,2.4892916548235875,3.0941070943697691,69.100000000000264,4.4717800289435043]
[null,0.50352683120139996,1.3053292255059881,1.9439131561396548,2.49813164297007,3.1039194179727865,69.200000000000259,4.4508670520230673]
[null,0.50726304071885087,1.3116670165088429,1.9517203614974825,2.5069817473979352,3.1137395470424467,69.300000000000253,4.4300144300143778]
[null,0.51101414071758922,1.3180189423749369,1.9595397064987208,2.5158419627107427,3.1235674717010915,69.400000000000247,4.4092219020172401]
[null,0.51478016262580184,1.3243850153308661,1.9673711923245938,2.5247122835981219,3.1334031821489337,69.500000000000242,4.3884892086330431]
[null,0.51856113816761773,1.3307652477538765,1.9752148202601079,2.5335927048352516,3.1432466686635223,69.600000000000236,4.3678160919539746]
[null,0.52235709936395458,1.3371596521716194,1.9830705916935976,2.5424832212823518,3.1530979215992145,69.70000000000023,4.3472022955523197]
[null,{"$f":"IF(D$75>0.2*($H552),(D$75-0.2*($H552))^2/(D$75+0.8*($H552)),0)","v":0.52616807853338021},{"$f":"IF(E$75>0.2*($H552),(E$75-0.2*($H552))^2/(E$75+0.8*($H552)),0)","v":1.3435682412619063},{"$f":"IF(F$75>0.2*($H552),(F$75-0.2*($H552))^2/(F$75+0.8*($H552)),0)","v":1.9909385081162674},{"$f":"IF(G$75>0.2*($H552),(G$75-0.2*($H552))^2/(G$75+0.8*($H552)),0)","v":2.5513838278841674},{"$f":"IF(H$75>0.2*($H552),(H$75-0.2*($H552))^2/(H$75+0.8*($H552)),0)","v":3.1629569313866472},69.800000000000225,{"$f":"IF(G552>0,1000/G552-10,1000)","v":4.3266475644698676}]
[null,0.52999410829299087,1.3499910278524776,1.9988185711217412,2.5602945196694611,3.1728236885322074,69.900000000000219,4.3061516452073949]
[null,0.53383522155930319,1.3564280249207701,2.0067107824056221,2.5692152917505218,3.1826981836175285,{"$f":"G553+0.1","v":70.000000000000213},4.2857142857142421]
[null,0.53769145154915987,1.3628792455936942,2.0146151437650466,2.5781461393226568,3.1925804072989639,70.100000000000207,4.2653352353779894]
[null,0.54156283178065423,1.3693447031474166,2.0225316570982543,2.5870870576637035,3.2024703503070824,70.200000000000202,4.2450142450142039]
[null,0.54544939607406628,1.3758244110071465,2.030460324404153,2.5960380421335469,3.2123680034461652,70.300000000000196,4.2247510668562906]
[null,0.5493511785528159,1.3823183827469314,2.0384011477818964,2.6049990881736282,3.2222733575937044,70.40000000000019,4.204545454545416]
[null,0.55326821364443068,1.3888266320894531,2.0463541294304588,2.6139701913064721,3.2321864036999068,70.500000000000185,4.184397163120531]
[null,0.55720053608152986,1.395349172905834,2.0543192716482195,2.6229513471352059,3.2421071327871993,70.600000000000179,4.1643059490084635]
[null,0.56114818090282337,1.401886019215449,2.0622965768325492,2.6319425513430943,3.2520355359497457,70.700000000000173,4.1442715700141104]
[null,0.56511118345412514,1.4084371851857371,2.0702860474794051,2.6409437996930731,3.2619716043529627,70.800000000000168,4.1242937853107016]
[null,0.56908957938938409,1.4150026851320265,2.0782876861829211,2.6499550880272817,3.2719153292330376,70.900000000000162,4.1043723554301508]
[null,0.57308340467172814,1.4215825335173584,2.0863014956350114,2.6589764122666089,3.2818667018964547,71.000000000000156,4.0845070422534899]
[null,0.57709269557452747,1.4281767449523219,2.0943274786249755,2.6680077684102397,3.2918257137195224,71.100000000000151,4.0646976090013762]
[null,0.5811174886824696,1.4347853341948891,2.1023656380391049,2.6770491525352029,3.3017923561479092,71.200000000000145,4.0449438202246899]
[null,0.58515782089265234,1.4414083161502591,2.1104159768602986,2.6861005607959259,3.3117666206961793,71.300000000000139,4.0252454417952048]
[null,0.58921372941569305,1.4480457058707084,2.118478498167681,2.6951619894237981,3.3217484989473358,71.400000000000134,4.0056022408963319]
[null,0.59328525177685154,1.4546975185554381,2.1265532051362168,2.7042334347267198,3.3317379825523532,71.500000000000128,3.9860139860139618]
[null,0.59737242581717243,1.4613637695504413,2.1346401010363443,2.7133148930886826,3.3417350632297436,71.600000000000122,3.9664804469273509]
[null,0.60147528969464015,1.4680444743483603,2.1427391892336001,2.7224063609693308,3.351739732765096,71.700000000000117,3.9470013947001164]
[null,0.60559388188535024,1.4747396485883588,2.1508504731882554,2.7315078349035353,3.3617519830106373,71.800000000000111,3.9275766016712872]
[null,0.60972824118470204,1.4814493080559967,2.1589739564549499,2.7406193115009754,3.3717718058847912,71.900000000000105,3.9082058414464331]
[null,0.61387840670859939,1.4881734686831087,2.167109642682338,2.7497407874457145,3.3817991933717417,72.000000000000099,3.8888888888888697]
[null,0.6180444178946759,1.49491214654769,2.1752575356127295,2.7588722594957882,3.3918341375209984,72.100000000000094,3.8696255201109384]
[null,0.62222631450352872,1.5016653578737844,2.1834176390817399,2.7680137244827905,3.4018766304469699,72.200000000000088,3.8504155124653572]
[null,0.62642413661997687,1.5084331190313824,2.191589957017948,2.7771651793114684,3.4119266643285373,72.300000000000082,3.8312586445366374]
[null,0.63063792465432911,1.5152154465363195,2.1997744934425483,2.7863266209593176,3.4219842314086324,72.400000000000077,3.8121546961325823]
[null,0.6348677193436737,1.5220123570501791,2.2079712524690094,2.7954980464761761,3.4320493239938163,72.500000000000071,3.7931034482758488]
[null,0.63911356175318157,1.5288238673802079,2.2161802383027447,2.8046794529838359,3.4421219344538687,72.600000000000065,3.7741046831955796]
[null,0.64337549327742782,1.5356499944792246,2.2244014552407756,2.8138708376756387,3.4522020552213704,72.70000000000006,3.7551581843191091]
[null,0.64765355564173033,1.542490755445546,2.2326349076714078,2.8230721978161002,3.4622896787913042,72.800000000000054,3.7362637362637265]
[null,0.65194779090350519,1.5493461675229079,2.2408806000739023,2.8322835307405065,3.4723847977206397,72.900000000000048,3.7174211248285225]
[null,0.65625824145363687,1.5562162481003943,2.2491385370181534,2.8415048338545397,3.4824874046279364,73.000000000000043,3.6986301369862939]
[null,0.66058495001787176,1.5631010147123774,2.2574087231643789,2.8507361046339001,3.4925974921929486,73.100000000000037,3.6798905608755064]
[null,0.66492795965822193,1.570000485038451,2.2656911632627987,2.8599773406239235,3.5027150531562241,73.200000000000031,3.6612021857923445]
[null,0.66928731377439032,1.5769146769033791,2.2739858621533302,2.8692285394392125,3.5128400803187221,73.300000000000026,3.6425648021828056]
[null,0.67366305610521271,1.5838436082770428,2.2822928247652756,2.8784896987632629,3.5229725665414127,73.40000000000002,3.6239782016348734]
[null,0.67805523073011753,1.5907872972743946,2.2906120561170229,2.8877608163480959,3.5331125047448979,73.500000000000014,3.6054421768707456]
[null,0.68246388207060227,1.5977457621554192,2.2989435613157441,2.8970418900138974,3.5432598879090316,73.600000000000009,3.586956521739129]
[null,0.68688905489172902,1.6047190213250946,2.3072873455571017,2.906332917648661,3.5534147090725412,73.7,3.568521031207597]
[null,0.69133079430363664,1.6117070933333606,2.3156434141249513,2.9156338972078188,3.5635769613326422,73.8,3.5501355013550135]
[null,0.69578914576307338,1.6187099968750935,2.3240117723910565,2.9249448267139022,3.5737466378446805,73.899999999999991,3.5317997293640069]
[null,0.70026415507494422,1.6257277507900822,2.3323924258147946,2.9342657042561759,3.5839237318217467,73.999999999999986,3.5135135135135158]
[null,0.70475586839387827,1.6327603740630108,2.3407853799428864,2.9435965279903029,3.5941082365343258,74.09999999999998,3.495276653171393]
[null,0.70926433222581553,1.6398078858234451,2.3491906404091019,2.9529372961379878,3.6043001453099182,74.199999999999974,3.4770889487870669]
[null,0.71378959342961124,1.6468703053458258,2.3576082129339944,2.9622880069866446,3.6144994515326898,74.299999999999969,3.4589502018842584]
[null,0.71833169921865681,1.6539476520494629,2.3660381033246241,2.9716486588890549,3.6247061486431145,74.399999999999963,3.4408602150537693]
[null,0.72289069716252241,1.6610399454985365,2.3744803174742826,2.9810192502630244,3.634920230137606,74.499999999999957,3.422818791946316]
[null,0.72746663518861787,1.6681472054021032,2.3829348613622341,2.9903997795910602,3.6451416895681836,74.599999999999952,3.4048257372654245]
[null,0.7320595615838712,1.675269451614106,2.3914017410534463,2.9997902454200345,3.6553705205421116,74.699999999999946,3.386880856760385]
[null,0.73666952499642735,1.6824067041333881,2.3998809626983322,3.0091906463608602,3.6656067167215585,74.79999999999994,3.3689839572192621]
[null,0.74129657443736496,1.689558983103711,2.4083725325324905,3.0186009810881647,3.6758502718232524,74.899999999999935,3.3511348464619601]
[null,0.74594075928243309,1.6967263088137785,2.4168764568764503,3.0280212483399658,3.6861011796181362,74.999999999999929,3.3333333333333464]
[null,0.75060212927380987,1.7039087016972678,2.4253927421354224,3.0374514469173595,3.6963594339310357,75.099999999999923,3.3155792276964178]
[null,0.75528073452187505,1.7111061823328544,2.433921394799047,3.0468915756841932,3.7066250286403197,75.199999999999918,3.2978723404255472]
[null,0.75997662550700884,1.7183187714442587,2.442462421441153,3.0563416335667659,3.716897957677574,75.299999999999912,3.2802124833997492]
[null,0.7646898530814038,1.725546489900277,2.451015828719509,3.0658016195535045,3.7271782150272608,75.399999999999906,3.2625994694960383]
[null,0.76942046847090506,1.7327893587148366,2.4595816233755894,3.0752715326946678,3.7374657947264058,75.499999999999901,3.2450331125827994]
[null,0.7741685232768617,1.74004739904704,2.4681598122343344,3.0847513721020303,3.7477606908642613,75.599999999999895,3.2275132275132457]
[null,0.77893406947800303,1.7473206322012189,2.4767504022039151,3.0942411369485825,3.7580628975819872,75.699999999999889,3.21003963011891]
[null,0.78371715943233933,1.7546090796269997,2.4853534002755082,3.1037408264682407,3.7683724090723421,75.799999999999883,3.1926121372031862]
[null,0.78851784587907181,1.7619127629193576,2.4939688135230589,3.1132504399555341,3.7786892195793489,75.899999999999878,3.1752305665349354]
[null,0.79333618194053612,1.7692317038186909,2.5025966491030611,3.1227699767653179,3.7890133233979917,75.999999999999872,3.1578947368421275]
[null,0.79817222112415942,1.776565924210892,2.5112369142543365,3.1322994363124832,3.7993447148739055,76.099999999999866,3.1406044678055416]
[null,{"$f":"IF(D$75>0.2*($H616),(D$75-0.2*($H616))^2/(D$75+0.8*($H616)),0)","v":0.80302601732443601},{"$f":"IF(E$75>0.2*($H616),(E$75-0.2*($H616))^2/(E$75+0.8*($H616)),0)","v":1.7839154461274203},{"$f":"IF(F$75>0.2*($H616),(F$75-0.2*($H616))^2/(F$75+0.8*($H616)),0)","v":2.5198896162978106},{"$f":"IF(G$75>0.2*($H616),(G$75-0.2*($H616))^2/(G$75+0.8*($H616)),0)","v":3.1418388180716645},{"$f":"IF(H$75>0.2*($H616),(H$75-0.2*($H616))^2/(H$75+0.8*($H616)),0)","v":3.8096833884030619},76.199999999999861,{"$f":"IF(G616>0,1000/G616-10,1000)","v":3.1233595800525169}]
[null,0.80789762482493299,1.7912802917453849,2.5285547626362939,3.1513881215769488,3.820029338431461,76.299999999999855,3.1061598951507463]
[null,0.81278709830031048,1.798660483387633,2.5372323607542775,3.1609473464215978,3.8303825594548346,{"$f":"G617+0.1","v":76.399999999999849},3.0890052356021194]
[null,0.81769449281836337,1.806056043522831,2.5459224182177076,3.1705164922577587,3.8407430460183352,76.499999999999844,3.0718954248366277]
[null,0.82261986384208852,1.8134669947655653,2.5546249426737897,3.1800955587961921,3.8511107927162462,76.599999999999838,3.0548302872062933]
[null,0.82756326723177065,1.8208933598764363,2.5633399418507725,3.1896845458059873,3.8614857941916765,76.699999999999832,3.0378096479791683]
[null,0.83252475924709168,1.8283351617621626,2.5720674235577503,3.1992834531142891,3.8718680451362664,76.799999999999827,3.0208333333333623]
[null,0.83750439654926057,1.8357924234756833,2.5808073956844551,3.208892280606026,3.8822575402898996,76.899999999999821,3.0039011703511349]
[null,0.84250223620316833,1.8432651682162731,2.5895598662010713,3.2185110282236447,3.8926542744404138,76.999999999999815,2.9870129870130189]
[null,0.84751833567956281,1.8507534193296555,2.5983248431580233,3.2281396959668309,3.903058242423306,77.09999999999981,2.9701686121919906]
[null,0.85255275285724619,1.8582572003081186,2.6071023346857962,3.2377782838922542,3.9134694391214522,77.199999999999804,2.953367875647702]
[null,0.85760554602529826,1.8657765347906432,2.6158923489947359,3.2474267921132993,3.923887859464823,77.299999999999798,2.9366106080207324]
[null,0.86267677388531983,1.8733114465630267,2.6246948943748669,3.2570852207998051,3.9343134984302019,77.399999999999793,2.9198966408269076]
[null,0.86776649555369778,1.8808619595580143,2.6335099791957024,3.2667535701778085,3.9447463510409064,77.499999999999787,2.9032258064516476]
[null,0.87287477056390006,1.8884280978554366,2.6423376119060635,3.276431840529284,3.9551864123665115,77.599999999999781,2.8865979381443658]
[null,0.87800165886878723,1.89600988568235,2.651177801033898,3.2861200321918931,3.9656336775225749,77.699999999999775,2.8700128700129071]
[null,0.88314722084295127,1.9036073474131781,2.6600305551861059,3.2958181455587323,3.9760881416703677,77.79999999999977,2.8534704370180322]
[null,0.88831151728507718,1.9112205075698603,2.6688958830483545,3.3055261810780765,3.9865498000165966,77.899999999999764,2.8369704749679467]
[null,0.89349460942032988,1.9188493908220063,2.6777737933849148,3.3152441392531395,3.9970186478131455,77.999999999999758,2.8205128205128602]
[null,0.89869655890276334,1.9264940219870503,2.6866642950384838,3.3249720206418227,4.0074946803567997,78.099999999999753,2.8040973111396053]
[null,0.90391742781775786,1.9341544260304124,2.6955673969300209,3.3347098258564749,4.0179778929889896,78.199999999999747,2.7877237851662819]
[null,0.90915727868447826,1.9418306280656634,2.7044831080585783,3.3444575555636473,4.0284682810955266,78.299999999999741,2.771392081736952]
[null,0.91441617445835699,1.949522653354693,2.7134114375011391,3.3542152104838578,4.0389658401063357,78.399999999999736,2.7551020408163698]
[null,0.91969417853360769,1.9572305273078843,2.7223523944124546,3.3639827913913516,4.0494705654952163,78.49999999999973,2.7388535031847567]
[null,0.92499135474575633,1.9649542754842872,2.7313059880248831,3.3737602991138629,4.0599824527795594,78.599999999999724,2.722646310432614]
[null,0.93030776737420529,1.9726939235918044,2.7402722276482421,3.3835477345323901,4.0705014975201204,78.699999999999719,2.7064803049555728]
[null,0.93564348114481743,1.9804494974873734,2.7492511226696417,3.3933450985809568,4.08102769532075,78.799999999999713,2.6903553299492842]
[null,0.94099856123252812,1.9882210231771555,2.7582426825533393,3.403152392246382,4.0915610418281503,78.899999999999707,2.674271229404356]
[null,0.94637307326398856,1.9960085268167322,2.7672469168405889,3.412969616568061,4.1021015327316253,78.999999999999702,2.6582278481013137]
[null,0.95176708332022386,2.0038120347113,2.7762638351494942,3.4227967726377342,4.1126491637628391,79.099999999999696,2.6422250316056104]
[null,0.95718065793932894,2.0116315733158703,2.7852934471748569,3.4326338615992595,4.1232039306955599,79.19999999999969,2.626262626262676]
[null,0.96261386411918903,2.0194671692354818,2.7943357626880418,3.4424808846484001,4.1337658293454336,79.299999999999685,2.6103404791929883]
[null,0.96806676932021829,2.0273188492254017,2.8033907915368288,3.4523378430325997,4.1443348555697304,79.399999999999679,2.5944584382872051]
[null,0.97353944146814264,2.035186640191347,2.812458543645282,3.462204738050767,4.1549110052671159,79.499999999999673,2.5786163522013101]
[null,0.97903194895679146,2.0430705691896964,2.8215390290136009,3.4720815710530544,4.1654942743774024,79.599999999999667,2.562814070351811]
[null,0.98454436065093021,2.0509706634277141,2.8306322577179972,3.481968343440653,4.176084658881325,79.699999999999662,2.5470514429109699]
[null,0.99007674588911854,2.058886950263779,2.8397382399105551,3.4918650566655733,4.1866821548003044,79.799999999999656,2.5313283208020589]
[null,0.99562917448659283,2.0668194572076102,2.848856985819106,3.5017717122304393,4.1972867581962152,79.89999999999965,2.5156445556946725]
[null,1.0012017167381777,2.0747682119205018,2.8579885057470951,3.5116883116882778,4.2078984651711551,79.999999999999645,2.5000000000000551]
[null,1.0067944434212339,2.0827332422155629,2.8671328100734557,3.5216148566423082,4.218517271867217,80.099999999999639,2.4843945068664741]
[null,1.012407425798626,2.0907145760579597,2.8762899092524949,3.5315513487457517,4.2291431744662669,80.199999999999633,2.468827930174621]
[null,1.0180407356217234,2.0987122415651598,2.8854598138137555,3.5414977897016091,4.2397761691897156,80.299999999999628,2.4533001245330581]
[null,1.0236944451334291,2.1067262670071809,2.8946425343619064,3.5514541812624723,4.2504162522982929,80.399999999999622,2.4378109452736911]
[null,1.0293686270712457,2.1147566808068521,2.9038380815766254,3.5614205252303242,4.2610634200918396,80.499999999999616,2.4223602484472639]
[null,1.0350633546703598,2.1228035115400634,2.9130464662124753,3.571396823456332,4.2717176689090692,80.599999999999611,2.4069478908189179]
[null,1.0407787016667647,2.1308667879360335,2.9222676990987968,3.5813830778406612,4.2823789951273632,80.699999999999605,2.3915737298637527]
[null,1.0465147423004133,2.1389465388775744,2.9315017911395946,3.5913792903322768,4.2930473951625521,80.799999999999599,2.376237623762437]
[null,1.0522715513183984,2.1470427934013614,2.9407487533134264,3.6013854629287483,4.3037228654687016,80.899999999999594,2.360939431396849]
[null,1.0580492039781708,2.1551555806982123,2.9500085966732987,3.6114015976760658,4.3144054025378979,80.999999999999588,2.3456790123457409]
[null,1.0638477760507761,2.1632849301133557,2.9592813323465541,3.621427696668444,4.3250950029000395,81.099999999999582,2.3304562268804574]
[null,1.0696673438241413,2.1714308711467232,2.9685669715347722,3.6314637620481345,4.3357916631226194,81.199999999999577,2.3152709359606547]
[null,1.0755079841063784,2.1795934334532308,2.977865525513665,3.6415097960052436,4.346495379810527,81.299999999999571,2.3001230012300766]
[null,1.0813697742291288,2.1877726468430727,2.9871770056329798,3.6515658007775467,4.3572061496058376,81.399999999999565,2.2850122850123498]
[null,1.0872527920509347,2.1959685412820114,2.9965014233163974,3.6616317786503028,4.3679239691876086,81.499999999999559,2.2699386503068144]
[null,1.0931571159606512,2.2041811468916821,3.0058387900614374,3.6717077319560771,4.3786488352716724,81.599999999999554,2.2549019607843803]
[null,1.0990828248808824,2.2124104939498901,3.015189117439363,3.6817936630745582,4.3893807446104383,81.699999999999548,2.2399020807834216]
[null,1.1050299982714598,2.2206566128909211,3.024552417095089,3.691889574432381,4.400119693992691,81.799999999999542,2.2249388753056927]
[null,1.1109987161329491,2.2289195343058519,3.0339287007470901,3.7019954685029512,4.4108656802433917,81.899999999999537,2.2100122100122785]
[null,1.1169890590101912,2.2371992889428594,3.0433179801873123,3.7121113478062671,4.4216187002234797,81.999999999999531,2.1951219512195816]
[null,1.1230011079958842,2.2454959077075478,3.0527202672810838,3.7222372149087493,4.4323787508296792,82.099999999999525,2.1802679658953199]
[null,1.1290349447341921,2.2538094216632683,3.0621355739670379,3.7323730724230701,4.4431458289943038,82.19999999999952,2.1654501216545725]
[null,1.1350906514243957,2.2621398620314443,3.071563912257016,3.7425189230079754,4.453919931685058,82.299999999999514,2.1506682867558435]
[null,1.1411683108245723,2.2704872601919037,3.0810052942359989,3.7526747693681259,4.4647010559048574,82.399999999999508,2.1359223300971593]
[null,1.1472680062553178,2.2788516476832137,3.090459732062016,3.762840614253919,4.4754891986916236,82.499999999999503,2.1212121212121939]
[null,{"$f":"IF(D$75>0.2*($H680),(D$75-0.2*($H680))^2/(D$75+0.8*($H680)),0)","v":1.1533898216035028},{"$f":"IF(E$75>0.2*($H680),(E$75-0.2*($H680))^2/(E$75+0.8*($H680)),0)","v":2.2872330562030219},{"$f":"IF(F$75>0.2*($H680),(F$75-0.2*($H680))^2/(F$75+0.8*($H680)),0)","v":3.0999272379660772},{"$f":"IF(G$75>0.2*($H680),(G$75-0.2*($H680))^2/(G$75+0.8*($H680)),0)","v":3.7730164604613341},{"$f":"IF(H$75>0.2*($H680),(H$75-0.2*($H680))^2/(H$75+0.8*($H680)),0)","v":4.4862843571181132},82.599999999999497,{"$f":"IF(G680>0,1000/G680-10,1000)","v":2.1065375302664169}]
[null,1.159533841326063,2.2956315176083959,3.1094078242520875,3.7832023108317556,4.4970865282917112,82.699999999999491,2.0918984280532786]
[null,1.16570015045383,2.3040470639161748,3.1189015032967831,3.7933981682518234,4.5078957093542646,{"$f":"G681+0.1","v":82.799999999999486},2.0772946859904131]
[null,1.1718888345954002,2.3124797273033173,3.1284082875496453,3.8036040356532581,4.5187118974818787,82.89999999999948,2.0627261761158771]
[null,1.1780999799410332,2.3209295401072567,3.1379281895328397,3.8138199160127075,4.5295350898847477,82.999999999999474,2.0481927710844143]
[null,1.1843336732666041,2.3293965348262677,3.1474612218411457,3.8240458123515917,4.540365283806973,83.099999999999469,2.0336943441637345]
[null,1.1905900019375757,2.3378807441198175,3.1570073971418804,3.8342817277359318,4.5512024765263659,83.199999999999463,2.0192307692308464]
[null,1.1968690539130249,2.3463822008089448,3.1665667281748449,3.8445276652762095,4.5620466653542895,83.299999999999457,2.0048019207683847]
[null,1.203170917749699,2.3549009378766255,3.1761392277522549,3.8547836281272034,4.5728978476354731,83.399999999999451,1.9904076738609895]
[null,1.2094956826061172,2.3634369884681514,3.1857249087586705,3.8650496194878357,4.5837560207478276,83.499999999999446,1.976047904191697]
[null,1.2158434382467094,2.3719903858915106,3.1953237841509505,3.8753256426010259,4.5946211821022853,83.59999999999944,1.9617224880383581]
[null,1.2222142750459939,2.380561163617767,3.204935866958182,3.8856117007535342,4.6054933291426128,83.699999999999434,1.9474313022700933]
[null,1.2286082839928005,2.3891493552814556,3.2145611702816272,3.895907797275814,4.6163724593452446,83.799999999999429,1.9331742243437571]
[null,1.2350255566945323,2.3977549946809686,3.224199707294666,3.9062139355418659,4.6272585702191114,83.899999999999423,1.9189511323004389]
[null,1.2414661853814679,2.4063781157789559,3.2338514912427399,3.9165301189690838,4.638151659305465,83.999999999999417,1.9047619047619868]
[null,1.2479302629111084,2.4150187527027245,3.2435165354433066,3.9268563510181211,4.6490517241777196,84.099999999999412,1.8906064209275506]
[null,1.2544178827725656,2.4236769397446434,3.2531948532857835,3.9371926351927393,4.6599587624412733,84.199999999999406,1.8764845605701552]
[null,1.2609291390909936,2.4323527113625532,3.2628864582314989,3.9475389750396634,4.6708727717333494,84.2999999999994,1.8623962040332991]
[null,1.2674641266320619,2.4410461021801786,3.272591363813647,3.9578953741484479,4.6817937497228295,84.399999999999395,1.8483412322275736]
[null,1.2740229408064769,2.4497571469875457,3.2823095836372369,3.9682618361513251,4.692721694110082,84.499999999999389,1.8343195266273042]
[null,1.2806056776745411,2.458485880741403,3.2920411313790554,3.9786383647230803,4.703656602626813,84.599999999999383,1.8203309692672249]
[null,1.2872124339507651,2.4672323385656494,3.3017860207876146,3.9890249635808992,4.7145984730358892,84.699999999999378,1.8063754427391654]
[null,1.2938433070085167,2.4759965557517614,3.3115442656831213,3.999421636484243,4.7255473031311928,84.799999999999372,1.7924528301887666]
[null,1.300498394884722,2.4847785677592293,3.3213158799574312,4.0098283872347089,4.7365030907374521,84.899999999999366,1.7785630153122192]
[null,1.3071777962846085,2.4935784102159944,3.3311008775740105,4.0202452196758935,4.7474658337100841,84.999999999999361,1.7647058823530291]
[null,1.313881610586497,2.5023961189188904,3.3408992725679005,4.030672137693263,4.758435529935042,85.099999999999355,1.7508813160987966]
[null,1.3206099378466409,2.511231729834094,3.3507110790456838,4.0411091452140191,4.769412177328654,85.199999999999349,1.7370892018780246]
[null,1.3273628788041127,2.5200852790975738,3.3605363111854518,4.0515562462069745,4.7803957738374772,85.299999999999343,1.7233294255569476]
[null,1.3341405348857338,2.5289568030155403,3.3703749832367653,4.0620134446824112,4.7913863174381284,85.399999999999338,1.7096018735363909]
[null,1.3409430082110652,2.5378463380649174,3.3802271095206371,4.0724807446919682,4.8023838061371542,85.499999999999332,1.6959064327486288]
[null,1.3477704015974308,2.5467539208937948,3.3900927044294904,4.0829581503285022,4.813388237970857,85.599999999999326,1.6822429906542968]
[null,1.3546228185650051,2.5556795883219001,3.3999717824271363,4.0934456657259624,4.8243996110051564,85.699999999999321,1.6686114352392991]
[null,1.361500363341944,2.5646233773410758,3.4098643580487518,4.1039432950592758,4.8354179233354397,85.799999999999315,1.655011655011748]
[null,1.3684031408695643,2.5735853251157472,3.419770445900852,4.1144510425442125,4.8464431730864126,85.899999999999309,1.6414435389989297]
[null,1.3753312568075804,2.5825654689834119,3.4296900606612644,4.1249689124372697,4.8574753584119508,85.999999999999304,1.6279069767442795]
[null,1.3822848175393865,2.5915638464551169,3.4396232170791117,4.1354969090355453,4.8685144774949531,86.099999999999298,1.614401858304392]
[null,1.3892639301773981,2.600580495215957,3.4495699299747931,4.1460350366766265,4.8795605285472021,86.199999999999292,1.6009280742460348]
[null,1.3962687025684406,2.6096154531255609,3.4595302142399591,4.1565832997384558,4.8906135098092118,86.299999999999287,1.5874855156432019]
[null,1.4032992432991929,2.6186687582185955,3.4695040848375043,4.1671417026392312,4.9016734195500939,86.399999999999281,1.5740740740741703]
[null,1.410355661701685,2.6277404487052638,3.4794915568015439,4.1777102498372747,4.9127402560674094,86.499999999999275,1.5606936416185935]
[null,1.4174380678588523,2.6368305629718152,3.4894926452373989,4.1882889458309194,4.9238140176870262,86.59999999999927,1.5473441108546009]
[null,1.4245465726101425,2.6459391395810576,3.4995073653215942,4.1988777951584044,4.9348947027629899,86.699999999999264,1.5340253748559221]
[null,1.4316812875571781,2.6550662172728692,3.5095357323018339,4.2094768023977451,4.945982309677369,86.799999999999258,1.520737327189039]
[null,1.4388423250694788,2.6642118349647239,3.5195777614970014,4.2200859721666344,4.9570768368401348,86.899999999999253,1.5074798619103404]
[null,1.446029798290235,2.6733760317522117,3.5296334682971477,4.2307053091223228,4.9681782826890091,86.999999999999247,1.4942528735633172]
[null,1.4532438211421437,2.6825588469095694,3.5397028681634803,4.2413348179615085,4.9792866456893341,87.099999999999241,1.4810562571757604]
[null,1.4604845083333031,2.6917603198902169,3.5497859766283684,4.2519745034202359,4.9904019243339448,87.199999999999235,1.4678899082569821]
[null,1.4677519753631609,2.7009804903272916,3.5598828092953276,4.2626243702737758,5.0015241171430214,87.29999999999923,1.4547537227950613]
[null,1.4750463385285266,2.7102193980341927,3.569993381839025,4.2732844233365235,5.0126532226639675,87.399999999999224,1.4416475972541054]
[null,1.4823677149296415,2.7194770830051254,3.5801177100052719,4.2839546674618916,5.0237892394712693,87.499999999999218,1.4285714285715301]
[null,1.489716222476313,2.7287535854156588,3.5902558096110275,4.2946351075422031,5.0349321661663717,87.599999999999213,1.4155251141553542]
[null,1.4970919798941065,2.7380489456232779,3.6004076965444054,4.3053257485085927,5.0460820013775471,87.699999999999207,1.4025085518815175]
[null,1.5044951067306012,2.7473632041679439,3.6105733867646643,4.3160265953308929,5.0572387437597612,87.799999999999201,1.3895216400912194]
[null,1.5119257233617058,2.7566964017726585,3.6207528963022222,4.3267376530175392,5.0684023919945469,87.899999999999196,1.3765642775882725]
[null,1.5193839509980447,2.7660485793440386,3.6309462412586582,4.3374589266154668,5.079572944789879,87.99999999999919,1.3636363636364681]
[null,1.5268699116914015,2.7754197779728864,3.641153437806723,4.3481904212100089,5.0907504008800473,88.099999999999184,1.3507377979569721]
[null,1.5343837283412289,2.7848100389347676,3.6513745021903397,4.3589321419247948,5.1019347590255277,88.199999999999179,1.3378684807257297]
[null,1.5419255247012298,2.7942194036906014,3.6616094507246228,4.3696840939216601,5.1131260180128608,88.299999999999173,1.3250283125708879]
[null,1.5494954253859947,2.8036479138872412,3.6718582997958831,4.3804462824005359,5.1243241766545262,88.399999999999167,1.312217194570243]
[null,1.557093555877715,2.8130956113580718,3.6821210658616415,4.3912187125993611,5.1355292337888185,88.499999999999162,1.2994350282486948]
[null,1.5647200425329599,2.8225625381236061,3.6923977654506475,4.4020013897939867,5.1467411882797327,88.599999999999156,1.2866817155757282]
[null,1.5723750125895242,2.832048736392085,3.7026884151628821,4.4127943192980696,5.1579600390168245,88.69999999999915,1.2739571589629044]
[null,1.5800585941733449,2.8415542485600915,3.7129930316695923,4.4235975064629987,5.1691857849151184,88.799999999999145,1.2612612612613692]
[null,1.5877709163054829,2.8510791172131515,3.7233116317132886,4.4344109566777767,5.1804184249149561,88.899999999999139,1.2485939257593888]
[null,{"$f":"IF(D$75>0.2*($H744),(D$75-0.2*($H744))^2/(D$75+0.8*($H744)),0)","v":1.5955121089091866},{"$f":"IF(E$75>0.2*($H744),(E$75-0.2*($H744))^2/(E$75+0.8*($H744)),0)","v":2.8606233851263605},{"$f":"IF(F$75>0.2*($H744),(F$75-0.2*($H744))^2/(F$75+0.8*($H744)),0)","v":3.7336442321077814},{"$f":"IF(G$75>0.2*($H744),(G$75-0.2*($H744))^2/(G$75+0.8*($H744)),0)","v":4.4452346753689493},{"$f":"IF(H$75>0.2*($H744),(H$75-0.2*($H744))^2/(H$75+0.8*($H744)),0)","v":5.1916579579819029},88.999999999999133,{"$f":"IF(G744>0,1000/G744-10,1000)","v":1.2359550561798844}]
[null,1.603282302817016,2.8701870952649986,3.7439908497381911,4.4560686680005031,5.2029043831066177,89.099999999999127,1.2233445566780006]
[null,1.6110816297780488,2.8797702907851614,3.7543515015609774,4.4669129400737795,5.2141576993047396,{"$f":"G745+0.1","v":89.199999999999122},1.2107623318386747]
[null,1.6189102224651479,2.8893730150343826,3.7647262046039511,4.4777674971273749,5.2254179056167649,89.299999999999116,1.1982082866742427]
[null,1.6267682144823197,2.8989953115522775,3.7751149759663094,4.4886323447370691,5.2366850011079462,89.39999999999911,1.185682326622036]
[null,1.634655740372134,2.9086372240711826,3.7855178328186594,4.4995074885157251,5.2479589848681636,89.499999999999105,1.1731843575420111]
[null,1.6425729356232222,2.9182987965167939,3.7959347924030382,4.5103929341132023,5.2592398560118134,89.599999999999099,1.1607142857143984]
[null,1.6505199366778596,2.9279800730088268,3.8063658720329512,4.5212886872162761,5.2705276136777037,89.699999999999093,1.148272017837348]
[null,1.6584968809396154,2.9376810978616641,3.8168110890933908,4.5321947535485476,5.2818222570289306,89.799999999999088,1.1358574610246119]
[null,1.6665039067810898,2.9474019155850169,3.8272704610408761,4.543111138870362,5.2931237852527735,89.899999999999082,1.1234705228032276]
[null,1.6745411535517247,2.9571425708845909,3.8377440054034841,4.5540378489787274,5.3044321975605859,89.999999999999076,1.1111111111112244]
[null,1.6826087615856982,2.9669031086627582,3.8482317397808727,4.5649748897072202,5.3157474931876756,90.099999999999071,1.0987791342953415]
[null,1.6907068722098997,2.9766835740192255,3.8587336818443312,4.5759222669259216,5.3270696713932084,90.199999999999065,1.0864745011087624]
[null,1.6988356277519865,2.9864840122517231,3.8692498493368035,4.5868799865413203,5.3383987314600931,90.299999999999059,1.0741971207088632]
[null,1.7069951715485221,2.9963044688566787,3.879780260072931,4.5978480544962386,5.3497346726948702,90.399999999999054,1.0619469026549826]
[null,1.7151856479532044,3.0061449895299166,3.8903249319390922,4.6088264767697593,5.3610774944276152,90.499999999999048,1.049723756906193]
[null,1.7234072023451734,3.0160056201673471,3.9008838828934338,4.6198152593771278,5.3724271960118157,90.599999999999042,1.0375275938191013]
[null,1.7316599811374078,3.0258864068656695,3.9114571309659252,4.6308144083697025,5.3837837768242895,90.699999999999037,1.0253583241456514]
[null,1.7399441317852058,3.0357873959230743,3.92204469425839,4.6418239298348514,5.3951472362650597,90.799999999999031,1.0132158590309537]
[null,1.7482598027947593,3.0457086338399528,3.9326465909445476,4.652843829895887,5.4065175737572551,90.899999999999025,1.0011001100111194]
[null,1.7566071437318147,3.0556501673196168,3.9432628392700706,4.6638741147119944,5.4178947887470148,90.999999999999019,0.98901098901110807]
[null,1.7649863052304224,3.065612043269017,3.9538934575526232,4.6749147904781534,5.4292788807033805,91.099999999999014,0.976948408342599]
[null,1.7733974390017759,3.0755943087994622,3.9645384641818961,4.6859658634250563,5.440669849118188,91.199999999999008,0.96491228070187418]
[null,1.781840697843156,3.0855970112273621,3.9751978776196819,4.6970273398190505,5.4520676935059811,91.299999999999002,0.95290251916769897]
[null,1.7903162356469469,3.0956201980749505,3.9858717163998989,4.7080992259620524,5.4634724134038954,91.399999999998997,0.94091903719924552]
[null,1.7988242074097704,3.1056639170710385,3.9965599991286584,4.7191815281914842,5.4748840083715713,91.499999999998991,0.92896174863400027]
[null,1.8073647692416961,3.1157282161517501,4.0072627444843061,4.7302742528801964,5.4863024779910443,91.599999999998985,0.91703056768571045]
[null,1.8159380783755616,3.1258131434612819,4.0179799712174828,4.7413774064364054,5.4977278218666568,91.69999999999898,0.90512540894232352]
[null,1.8245442931763849,3.1359187473526546,4.0287116981511746,4.7524909953036127,5.5091600396249465,91.799999999998974,0.89324618736395678]
[null,1.8331835731508797,3.1460450763884831,4.039457944180775,4.7636150259605561,5.5205991309145706,91.899999999998968,0.88139281828086169]
[null,1.8418560789570622,3.1561921793417325,4.0502187282741273,4.7747495049211146,5.5320450954061853,91.999999999998963,0.86956521739142723]
[null,1.8505619724139757,3.1663601051965045,4.0609940694715991,4.7858944387342657,5.5434979327923664,92.099999999998957,0.85776330076016727]
[null,1.8593014165115016,3.1765489031488068,4.0717839868861327,4.7970498339840049,5.5549576427875103,92.199999999998951,0.84598698481574175]
[null,1.8680745754202812,3.1867586226073379,4.0825884997033066,4.8082156972892838,5.5664242251277347,92.299999999998946,0.83423618634898666]
[null,1.8768816145017497,3.1969893131942841,4.0934076271814002,4.8193920353039488,5.5778976795707944,92.39999999999894,0.82251082251094587]
[null,1.8857227003182606,3.2072410247461036,4.1042413886514506,4.8305788547166673,5.5893780058959743,92.499999999998934,0.81081081081093487]
[null,1.8945980006433372,3.2175138073143361,4.115089803517324,4.8417761622508744,5.6008652039040125,92.599999999998929,0.79913606911459567]
[null,1.9035076844720185,3.2278077111664056,4.1259528912557766,4.8529839646647064,5.612359273416998,92.699999999998923,0.78748651564198013]
[null,1.9124519220313201,3.23812278678643,4.1368306714165231,4.8642022687509385,5.6238602142782836,92.799999999998917,0.77586206896564214]
[null,1.9214308847908119,3.2484590848760426,4.147723163622298,4.8754310813369139,5.6353680263523893,92.899999999998911,0.76426264800873689]
[null,1.9304447454733016,3.2588166563552097,4.1586303875689339,4.8866704092845046,5.6468827095249221,92.999999999998906,0.75268817204313798]
[null,1.9394936780656411,3.2691955523630685,4.1695523630254305,4.8979202594900313,5.658404263702483,93.0999999999989,0.74113856068755979]
[null,1.9485778578296356,3.2795958242587475,4.1804891098340153,4.9091806388842123,5.6699326888125707,93.199999999998894,0.7296137339057065]
[null,1.9576974613130882,3.2900175236222204,4.1914406479102286,4.9204515544321055,5.6814679848035041,93.299999999998889,0.71811361200441404]
[null,1.9668526663609451,3.3004607022551404,4.2024069972429849,4.9317330131330426,5.6930101516443248,93.399999999998883,0.70663811563182044]
[null,1.9760436521265841,3.3109254121817049,4.2133881778946654,4.9430250220205867,5.7045591893247236,93.499999999998877,0.69518716577552908]
[null,1.9852705990831914,3.3214117056494947,4.2243842100011699,4.9543275881624584,5.7161150978549387,93.599999999998872,0.68376068376081278]
[null,1.9945336890352998,3.3319196351303555,4.235395113772018,4.9656407186604934,5.7276778772656831,93.699999999998866,0.67235859124879482]
[null,2.0038331051304215,3.3424492533212549,4.2464209094904062,4.9769644206505772,5.7392475276080441,93.79999999999886,0.66098081023467081]
[null,2.0131690318708251,3.3530006131451615,4.2574616175133055,4.9882987013025968,5.7508240489534188,93.899999999998855,0.64962726304592344]
[null,2.0225416551254365,3.3635737677519293,4.2685172582715305,4.9996435678203861,5.7624074413934139,93.999999999998849,0.63829787234055502]
[null,2.0319511621418593,3.3741687705191734,4.2795878522698203,5.0109990274416631,5.7739977050397613,94.099999999998843,0.62699256110533774]
[null,2.041397741558546,3.384785675053176,4.2906734200869314,5.0223650874379953,5.7855948400242552,94.199999999998838,0.61571125265405868]
[null,2.0508815834170839,3.3954245351897758,4.3017739823757122,5.0337417551147272,5.7971988464986435,94.299999999998832,0.60445387062579492]
[null,2.0604028791746272,3.40608540499528,4.3128895598631924,5.0451290378109457,5.808809724634564,94.399999999998826,0.59322033898318338]
[null,2.0699618217164573,3.4167683387673673,4.3240201733506716,5.0565269428994171,5.8204274746234574,94.49999999999882,0.58201058201071376]
[null,2.0795586053686872,3.4274733910360098,4.3351658437137957,5.0679354777865413,5.8320520966764828,94.599999999998815,0.57082452431302855]
[null,2.0891934259111049,3.4382006165643961,4.3463265919026615,5.0793546499123048,5.8436835910244449,94.699999999998809,0.5596620908132266]
[null,2.0988664805901531,3.4489500703498597,4.3575024389418955,5.090784466750228,5.8553219579177087,94.799999999998803,0.54852320675118804]
[null,2.1085779681320598,3.4597218076248142,4.368693405930749,5.1022249358073166,5.8669671976261233,94.899999999998798,0.5374077976819045]
[null,2.1183280887561078,3.470515883857697,4.3798995140431884,5.1136760646240189,5.8786193104389444,94.999999999998792,0.52631578947381819]
[null,2.1281170441880546,3.4813323547539143,4.3911207845279909,5.1251378607741689,5.8902782966647509,95.099999999998786,0.51524710830717879]
[null,2.1379450376736973,3.4921712762567951,4.4023572387088334,5.1366103318649481,5.9019441566313695,95.199999999998781,0.5042016806724039]
[null,2.1478122739925984,3.503032704548561,4.4136088979843979,5.1480934855368385,5.9136168906858071,95.299999999998775,0.49317943336844472]
[null,{"$f":"IF(D$75>0.2*($H808),(D$75-0.2*($H808))^2/(D$75+0.8*($H808)),0)","v":2.1577189594719455},{"$f":"IF(E$75>0.2*($H808),(E$75-0.2*($H808))^2/(E$75+0.8*($H808)),0)","v":3.5139166960512749},{"$f":"IF(F$75>0.2*($H808),(F$75-0.2*($H808))^2/(F$75+0.8*($H808)),0)","v":4.4248757838284556},{"$f":"IF(G$75>0.2*($H808),(G$75-0.2*($H808))^2/(G$75+0.8*($H808)),0)","v":5.1595873294635703},{"$f":"IF(H$75>0.2*($H808),(H$75-0.2*($H808))^2/(H$75+0.8*($H808)),0)","v":5.9252964991941566},95.399999999998769,{"$f":"IF(G808>0,1000/G808-10,1000)","v":0.48218029350118385}]
[null,2.1676653020005903,3.5248233074278361,4.436157917789977,5.1710918713520879,5.9369829825415357,95.499999999998764,0.47120418848181167]
[null,2.1776515110432211,3.5357525955829456,4.4474553214932246,5.1826071189424976,5.9486763411320069,{"$f":"G809+0.1","v":95.599999999998758},0.46025104602524003]
[null,2.1876777976547062,3.5467046176640937,4.4587680166378494,5.1941330800080223,5.9603765753884987,95.699999999998752,0.449320794148516]
[null,2.1977443744945968,3.5576794310625588,4.4700960249990001,5.205669762354967,5.9720836857527368,95.799999999998747,0.43841336116923912]
[null,2.2078514558417952,3.5686770934144061,4.4814393684274236,5.2172171738226707,5.983797672685168,95.899999999998741,0.42752867570399467]
[null,2.2179992576093732,3.5796976626014851,4.4927980688495621,5.2287753222834628,5.9955185366648847,95.999999999998735,0.41666666666680463]
[null,2.2281879973595831,3.5907411967524574,4.5041721482676653,5.2403442156426268,6.0072462781895553,96.09999999999873,0.40582726326756813]
[null,2.2384178943190105,3.6018077542438012,4.515561628759893,5.251923861838355,6.0189808977753492,96.199999999998724,0.3950103950105337]
[null,2.2486891693939195,3.6128973937008442,4.5269665324804267,5.263514268841714,6.0307223959568708,96.299999999998718,0.38421599169276455]
[null,2.259002045185754,3.6240101739987942,4.5383868816595614,5.2751154446565902,6.0424707732870706,96.399999999998712,0.37344398340262863]
[null,2.2693567460068405,3.635146154263786,4.5498226986038421,5.2867273973196767,6.0542260303372037,96.499999999998707,0.36269430051827278]
[null,2.279753497896233,3.6463053938739147,4.5612740056961485,5.2983501349004074,6.0659881676967267,96.599999999998701,0.35196687370614299]
[null,2.2901925286357714,3.6574879524602997,4.5727408253958197,5.309983665500936,6.077757185973252,96.699999999998695,0.34126163391947806]
[null,2.3006740677663098,3.668693889908146,4.5842231802387685,5.3216279972560967,6.0895330857924694,96.79999999999869,0.33057851239683345]
[null,2.3111983466041184,3.6799232663577959,4.595721092837584,5.3332831383333588,6.1013158677980712,96.899999999998684,0.31991744066061401]
[null,2.3217655982574956,3.69117614220582,4.6072345858816544,5.3449490969327949,6.1131055326516925,96.999999999998678,0.30927835051560493]
[null,2.3323760576435602,3.7024525781060946,4.6187636821372884,5.3566258812870542,6.1249020810328432,97.099999999998673,0.29866117404751513]
[null,2.3430299615052252,3.7137526349708816,4.6303084044478187,5.3683134996613111,6.1367055136388329,97.199999999998667,0.2880658436215402]
[null,2.3537275484283864,3.725076373971933,4.6418687757337329,5.3800119603532428,6.1485158311847057,97.299999999998661,0.27749229188092173]
[null,2.3644690588592949,3.7364238565415842,4.6534448189927788,5.3917212716929841,6.1603330344031777,97.399999999998656,0.26694045174552095]
[null,2.3752547351221396,3.7477951443738755,4.6650365573001027,5.4034414420431087,6.1721571240445687,97.49999999999865,0.25641025641039761]
[null,2.3860848214368233,3.7591902994256561,4.6766440138083567,5.4151724797985796,6.183988100876733,97.599999999998644,0.2459016393444049]
[null,2.3969595639369579,3.7706093839177206,4.6882672117478332,5.426914393386733,6.1958259656850005,97.699999999998639,0.23541453428878079]
[null,2.4078792106880469,3.782052460335926,4.699906174426574,5.4386671912672293,6.2076707192721017,97.799999999998633,0.22494887525576601]
[null,2.418844011705906,3.7935195914323425,4.711560925230506,5.4504308819320331,6.2195223624581129,97.899999999998627,0.21450459652721143]
[null,2.4298542189752794,3.8050108402263958,4.7232314876235693,5.4622054739053763,6.2313808960803865,97.999999999998622,0.20408163265320489]
[null,2.4409100864686795,3.8165262700060181,4.7349178851478371,5.4739909757437344,6.2432463209934879,98.099999999998616,0.1936799184507052]
[null,2.4520118701654452,3.8280659443288103,4.746620141423648,5.4857873960357875,6.2551186380691366,98.19999999999861,0.18329938900218146]
[null,2.4631598280710265,3.8396299270232137,4.7583382801497356,5.4975947434023977,6.2669978481961346,98.299999999998604,0.17293997965426477]
[null,2.4743542202364908,3.8512182821896772,4.7700723251033574,5.509413026496575,6.2788839522803093,98.399999999998599,0.16260162601640538]
[null,2.4855953087782652,3.8628310742018557,4.781822300140429,5.5212422540034538,6.2907769512444531,98.499999999998593,0.15228426395953498]
[null,2.4968833578980978,3.8744683677077831,4.7935882291956524,5.5330824346402565,6.3026768460282554,98.599999999998587,0.14198782961475054]
[null,2.5082186339032804,3.8861302276310896,4.8053701362826615,5.5449335771562787,6.3145836375882531,98.699999999998582,0.13171225937198017]
[null,2.5196014052270765,3.8978167191721966,4.8171680454941432,5.5567956903328533,6.3264973268977549,98.799999999998576,0.12145748987868821]
[null,2.531031942449415,3.9095279078095291,4.8289819810019781,5.5686687829833188,6.3384179149467847,98.89999999999857,0.11122345803856959]
[null,2.5425105183178269,3.9212638593007534,4.8408119670573884,5.5805528639530086,6.3503454027420361,98.999999999998565,0.10101010101024777]
[null,2.5540374077686208,3.9330246396839881,4.8526580279910592,5.5924479421192084,6.3622797913067899,99.099999999998559,9.0817356205999289E-2]
[null,2.5656128879483173,3.9448103152790575,4.8645201882132909,5.6043540263911478,6.3742210816808704,99.199999999998553,8.0645161290469503E-2]
[null,2.577237238235341,3.9566209526887297,4.8763984722141371,5.6162711257099618,6.3861692749205821,99.299999999998548,7.0493454179402448E-2]
[null,2.5889107402619711,3.9684566187999772,4.8882929045635475,5.6281992490486719,6.398124372098656,99.399999999998542,6.0362173038376099E-2]
[null,2.6006336779365395,3.9803173807852241,4.9002035099114991,5.640138405412161,6.4100863743041723,99.499999999998536,5.0251256281555357E-2]
[null,2.6124063374659312,3.9922033061036446,4.9121303129881664,5.6520886038371598,6.4220552826425346,99.599999999998531,4.0160642570429061E-2]
[null,2.6242290073783106,4.0041144625024092,4.9240733386040372,5.6640498533922035,6.4340310982353826,99.699999999998525,3.0090270812586084E-2]
[null,2.6361019785461588,4.0160509180179975,4.9360326116500826,5.6760221631776311,6.4460138222205527,99.799999999998519,2.0040080160470097E-2]
[null,2.6480255442095681,4.0280127409774789,4.9480081570978918,5.6880055423255502,6.4580034557520172,99.899999999998514,1.001001001015922E-2]
[null,2.6599999999998212,4.0399999999998206,4.9599999999998206,5.6999999999998217,6.4699999999998195,99.999999999998508,1.4921397450962104E-13]

{"sheet":"Design Summary","index":6,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":false,"merged":[[9,4,9,7],[3,1,9,1]]}
[]
[null,"Design Summary Worksheet"]
[]
[null,"Total Site Summary","Total Disturbed Area (ft2):",{"$f":"'Site Inputs'!$D$9","v":0},{"$f":"IF($D$4=0,\"\",(IF($D$4-SUM(Drainage_Area_IDs[Disturbed Drainage Area (ft2)])<>0,\"⮽ Subdivided disturbed drainage areas from the Drainage Area Summary Table in the Site Input tab does not match the input total disturbed area.\",\"\")))","v":""}]
[null,null,"Total Site Rv:",{"$f":"IFERROR(('Site Inputs'!M66*'Site Inputs'!O66)/'Site Inputs'!$D$9, 0)","v":0}]
[null,null,"Total RRV Prior to Reductions (ft3)",{"$f":"0","v":0}]
[null,null,"Total RRV Reductions  (ft3)",{"$f":"0","v":0}]
[null,null,"Total RRV After Reductions (ft3)",{"$f":"0","v":0}]
[null,null,"Total Retention Volume Achieved (ft3)",{"$f":"0","v":0},{"$f":"IF(D8=0,\"\",IF(ROUND(D9,0)>=ROUND(D8,0),\"☑ Total Required Retention Volume achieved!\",\"⮽ Additional retention required.\"))","v":""}]
[null,null,"Percent WQv Control Achieved",{"$f":"IF(D9=0,0,((D9+D7)*12)/('Site Inputs'!$E$12*(D4*D5)))","v":0},{"$f":"IF(D10>='Site Inputs'!$E$13,\"☑ Required percent site control achieved!\",\"⮽ Additional site control required.\")","v":"☑ Required percent site control achieved!"}]