{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["RIDEM SW Application","General Project Information","Worksheet A","Minimum Standards Compliance","Tables","Worksheet B","Plan Contents","pick lists","Review Checklist","RIDOT STU History","Version Notes"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":1,"defined_names":2,"comments":2,"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":"RIDEM SW Application","index":0,"n_rows":100,"n_cols":18,"rows_kept":100,"cut":false,"hidden":false,"merged":[[1,12,4,14],[6,1,6,14],[8,1,8,14],[8,17,8,30],[10,1,10,9],[10,10,10,14],[16,2,16,4],[16,5,16,7],[16,8,16,14],[17,2,17,4],[17,5,17,7],[17,8,17,14],[12,11,12,14],[13,11,13,12],[13,13,13,14],[14,2,14,4],[14,5,14,11],[14,12,14,14],[15,2,15,4],[15,5,15,11],[15,12,15,14],[21,6,21,7],[21,8,21,9],[21,11,21,13],[22,2,22,4],[22,5,22,7],[22,8,22,11],[22,12,22,14],[18,2,18,7],[18,8,18,14],[19,2,19,7],[19,8,19,14],[20,2,20,3],[20,4,20,5],[20,6,20,7],[20,8,20,10],[20,11,20,14],[23,5,23,7],[23,12,23,14],[24,1,35,1],[24,2,24,8],[24,9,24,14],[25,2,25,8],[25,9,25,14],[26,2,26,4],[26,5,26,8],[14,1,23,1],[28,2,28,8],[28,9,28,11],[28,13,28,14],[29,2,29,8],[29,9,29,11],[29,13,29,14],[26,9,26,12],[26,13,26,14],[27,2,27,4],[27,5,27,8],[27,9,27,12],[27,13,27,14],[21,2,21,3],[21,4,21,5],[39,2,39,7],[39,8,39,12],[30,2,33,14],[34,2,34,7],[34,8,34,11],[34,12,34,14],[35,2,35,7],[35,8,35,11],[35,12,35,14],[48,1,50,1],[48,13,48,14],[49,2,49,4],[49,5,49,7],[49,8,49,12],[50,2,50,4],[50,5,50,7],[50,8,50,12],[39,13,39,14],[40,2,44,14],[45,2,45,7],[45,8,45,11],[45,12,45,14],[46,2,46,7],[46,8,46,11],[46,12,46,14],[36,1,46,1],[36,2,36,7],[36,8,36,14],[37,2,37,7],[37,8,37,14],[38,2,38,7],[38,8,38,12],[38,13,38,14],[76,11,76,12],[77,9,77,10],[78,1,87,1],[79,8,79,12],[79,13,81,14],[83,8,83,12],[65,13,67,14],[69,3,69,12],[71,2,72,12],[71,13,75,14],[73,3,73,12],[74,8,74,12],[51,1,77,1],[51,2,52,12],[51,13,51,14],[53,2,53,12],[53,13,55,14],[56,3,57,11],[59,13,61,14],[61,3,61,12],[63,2,63,12],[63,13,64,14],[88,1,97,1],[88,2,89,12],[88,13,88,14],[91,13,91,14],[92,4,92,9],[92,13,92,14],[93,13,93,14],[94,13,94,14],[95,4,96,12],[97,4,97,12]]}
[]
[null,null,"RHODE ISLAND DEPARTMENT OF ENVIRONMENTAL MANAGEMENT",null,null,null,null,null,null,null,null,null,"Received by RIDEM\n[DATE STAMP HERE]"]
[null,null,"Office of Water Resources"]
[null,null,"235 Promenade Street, Providence, RI 02908-5767"]
[null,null,"Telephone: 401-222-6820; Rhode Island Relay: 711; FAX: 401-222-6177"]
[]
[null,"Application for Stormwater Construction Permit and Water Quality Certification"]
[]
[null,"Use this form to request a Stormwater Construction Permit or Water Quality Certification (WQC).  [This form replaces the formerly used WQC Program Application; Applications for a Stormwater Discharge System Registration and to Modify a Groundwater or Stormwater Discharge System (GWD/UIC Program); and the RIPDES Notice of Intent (NOI) Stormwater General Permit for Construction Activity (CGP).]  If a Freshwater Wetlands (FWW) Application is required, this form must be submitted in addition to the FWW Application form."]
[]
[null,"Please complete this form online before printing.  Submit the completed form with all required documentation and fee to:\n(Check or money order must be made payable to the Rhode Island General Treasurer.)\nStormwater Construction Permit Fee will be waived for applications submitted concurrently with a Freshwater Wetlands Application. ",null,null,null,null,null,null,null,null,"Permit Application Center (PAC)\nRIDEM\n235 Promenade Street, Room 260\nProvidence, RI 02908-5767"]
[null,"Provide all applicable information by completing the shaded areas. "]
[null,"Double-click to select:",null,null,"¨","New Permit",null,"¨","Permit Modification",null,null,{"$f":"IF(H13=CHAR(254),\"Provide Permit Type & No.:\",\" \")","v":" "}]
[null,null,null,null,null,{"$f":"IF(E13=\"þ\",\"Fee = $400.\",\" \")","v":" "},null,null,{"$f":"IF(H13=\"þ\",\"Fee = $200.\",\" \")","v":" "}]
[null,"Site & Project","City/Town:",null,null,"Street Address:",null,null,null,null,null,null,"Water Body Class:"]
[null,null,"Click to Select",null,null,null,null,null,null,null,null,null,"Click to Select"]
[null,null,"Plat(s):",null,null,"Lot(s):",null,null,"Project Name:"]
[]
[null,null,"Location:",null,null,null,null,null,"Water Body Name(s):"]
[]
[null,null,"Latitude:",null,"Longitude:",null,"Utility Pole #:",null,"Total Site Area:",null,null,"Site Area to be Disturbed:"]
[null,null,null,null,null,null,null,null,null,null,"acres",null,null,null,"acres"]
[null,null,"RI Federal Aid Project #:",null,null,"RI Contract #:",null,null,"Was there a Pre-Application Meeting?",null,null,null,{"$f":"IF(I24=\"þ\",\"Provide Meeting Date:\",\" \")","v":" "}]
[null,null,null,null,null,null,null,null,"¨","Yes","¨","No"]
[null,"Owner / Applicant","Organization/Company Name:",null,null,null,null,null,null,"Contact Name of Owner's Representative for Questions:"]
[]
[null,null,"First Name:",null,null,"Last Name:",null,null,null,"Email:",null,null,null,"Phone:"]
[]
[null,null,"Address:",null,null,null,null,null,null,"City/Town:",null,null,"State:","Zip:"]
[]
[null,null,"I certify under penalty of law that I’ve requested and authorized the investigation, compilation, and submission of all the information, in whatever form, contained in this Application; I have personally examined and am familiar with the information submitted herein; and based on my inquiry of those individuals immediately responsible for obtaining the information, I believe the information is true, accurate and complete. I’m aware that it’s the owner's responsibility to implement or hire a qualified contractor responsible to implement any required Soil Erosion and Sediment Control Plan, so as to effectively control stormwater discharges leaving the site during the construction period. I authorize RIDEM personnel access to the property for purposes of observing conditions pertinent to this application and assessing compliance with any permit or determination resulting from this application."]
[]
[]
[]
[null,null,"Applicant's Signature:",null,null,null,null,null,"Title:",null,null,null,"Date:"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TODAY()","v":"2019-07-22"}]
[null,"Professional","Professional's Name:",null,null,null,null,null,"Professional's License Type(s) and Number(s):"]
[]
[null,null,"Company Name:",null,null,null,null,null,"Email:",null,null,null,null,"Phone:"]
[]
[null,null,"I certify under penalty of law that  the project described in this application and associated materials is in compliance with the RI Stormwater Design and Installation Standards Manual (as amended) and the Rhode Island Soil Erosion and Sediment Control Handbook (as amended) [if required] and I believe all information presented in this application and the accompanying materials are true, accurate and complete. All engineering designs, plans and specifications [if required] included in this application were done by me or by someone working directly for me.  The Natural Heritage Area Information [if required] and the site specific Soil Erosion and Sediment Control Plan [if required] were prepared under my direction or supervision in accordance with a system designed to assure that qualified personnel properly gather and evaluate the information submitted.  Based on my inquiry of the person or persons who manage the system, or those persons directly responsible for gathering or developing the information, the information submitted is, to the best of my knowledge and belief, true, accurate, and complete at the time this application is made. I am aware that there are significant penalties for submitting false information, including the possibility of fine and imprisonment for knowing violations."]
[]
[]
[]
[]
[null,null,"Professional's Signature:",null,null,null,null,null,"Title:",null,null,null,"Date:"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TODAY()","v":"2019-07-22"}]
[null,"PERMIT HISTORY AND APPLICABILITY - Double-click to check all boxes that apply to the proposed project."]
[null,"Permit History","Provide all other application or file numbers associated with this site.",null,null,null,null,null,null,null,null,null,null,"RIDEM USE ONLY"]
[null,null,"RI CRMC Assent:",null,null,"US Army Corps of Engineers:",null,null,"RIDEM Program Name & File Number:"]
[]
[null,"Stormwater Construction Activity","Select all that apply.  [Stormwater submissions must comply with all requirements of the RI Stormwater Design and Installation Standards Manual (RISDISM).  Click links below to refer to other applicable Rules.]  "]
[]
[null,null,"There are Freshwater Wetlands on the subject or adjacent property, AND the project proposes:",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(P54>0,\"FWW Application # Required:\",\" \")","v":" "},null,{"$f":"COUNTIF(C55:C57,CHAR(254))","v":0}]
[null,null,"¨","New or increased impervious cover for property other than a single family home; or"]
[null,null,"¨","Disturbance of more than 10,000 sq. ft. of existing impervious cover; or"]
[null,null,"¨","To fill in any amount of floodplain or alter storm flowage to a river, stream or wetland on any lot."]
[]
[null,null,null,null,null,null,null,null,"Refer to  Freshwater Wetland: ","Rules",null,"Guidance"]
[null,null,"The project requires an application to RI CRMC, AND proposes:",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(P60>0,\"STW/WQC Application # Required:\",\" \")","v":" "},null,{"$f":"COUNTIF(C55:C87,CHAR(254))","v":0}]
[null,null,"¨","A residential development of 6 units or more; or"]
[null,null,"¨","A project that results in the creation of 10,000 sq. ft. or more of impervious area."]
[null,null,null,null,null,null,null,null,"Refer to Water Quality: ","Rules",null,"Guidance"]
[null,null,"The project proposes an infiltration system listed in Section 5.3 of the RISDISM (i.e. infiltration trench, infiltration basin, UIC chamber or drywell) that receives stormwater from:"]
[null,null,"¨","A residential impervious area that is more than 10,000 sq.ft.; or"]
[null,null,"¨","A non-residential roof area greater than 10,000 sq.ft.; or",null,null,null,null,null,null,null,null,null,{"$f":"IF(P66>0,\"UIC/GWD Application # Required:\",\" \")","v":" "},null,{"$f":"COUNTIF(C69:C69,CHAR(254))","v":0}]
[null,null,"¨","A non-residential (commercial, industrial, institutional…) road or parking area of any size."]
[null,null,"Indicate if the treatment system discharges:"]
[null,null,"¨","Below the ground (UIC); or"]
[null,null,"¨","Above the ground and infiltrates (not UIC), but must be reviewed for compliance with the RISDISM to be protective of groundwater."]
[null,null,null,null,null,null,null,null,"Refer to Groundwater Discharge: ","Rules",null,"Guidance"]
[null,null,"The project proposes discharge of stormwater to waters of the State [including a Separate Storm Sewer System (MS4)], AND : ",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(P72>0,\"RIPDES Application # Required:\",\" \")","v":" "},null,{"$f":"COUNTIF(C74:C77,CHAR(254))","v":0}]
[]
[null,null,"¨","Disturbs less than 1 acre, but the activity is part of a larger common plan resulting in more than 1 acre of disturbance.  "]
[null,null,null,null,null,null,null,"Provide name of larger common plan: "]
[null,null,"¨","Disturbs more than 1 acre of property."]
[null,null,"Site is within or directly discharges to a Natural Heritage Area?",null,null,null,null,null,null,null,null,"Click to Select"]
[null,null,null,null,null,null,null,null,"Refer to RI Pollutant Discharge Elimination System: ","General Permit",null,"Guidance"]
[null,"Water Quality Certification (WQC)","Select all project type(s):",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(C80,CHAR(254))","v":0}]
[null,null,"¨","Discharge that requires a Federal Permit",null,null,null,null,"Freshwater Wetlands Individual Permit (IP)"]
[null,null,null,"¨","Federal Energy Regulatory Commission (FERC)"]
[null,null,null,"¨",{"$f":"IF(I80=\"Freshwater Wetlands Individual Permit (IP)\",\"US Army Corps of Engineers (ACOE)\",\"Marinas - New Construction or Expansion\")","v":"US Army Corps of Engineers (ACOE)"}]
[null,null,null,"¨",{"$f":"IF(I80=\"Freshwater Wetlands Individual Permit (IP)\",\" \",\"Individual Permit\")","v":" "}]
[null,null,null,"¨",{"$f":"IF(I80=\"Freshwater Wetlands Individual Permit (IP)\",\" \",\"Fill Waters of the State\")","v":" "},null,null,null,"Click to Select One:"]
[null,null,"¨","Harbor Management Plan"]
[null,null,"¨","Flow Alteration"]
[null,null,"¨","Stormwater Master Plan"]
[null,null,null,null,null,null,null,null,"Refer to Water Quality: ","Rules",null,"Guidance"]
[null,"Submission Requirements","Please submit separately bound documents, as required.  Additional copies are required when submitting concurrently with a Freshwater Wetlands Application. ",null,null,null,null,null,null,null,null,null,null,"Amt Paid:",null,null,null,"ELIMINATION SYSTEM"]
[]
[null,null,null,{"$f":"IF($P$54>0,\" \",\"1\")","v":"1"},"Site Plan(s)"]
[null,null,null,{"$f":"IF($P$54>0,\" \",\"1\")","v":"1"},"RISDISM Appendix A Checklist and LID Planning Assessment",null,null,null,null,null,null,null,null,"Check No:"]
[null,null,null,{"$f":"IF($P$54>0,\" \",\"1\")","v":"1"},"Stormwater Analysis and Drainage Report"]
[null,null,null,{"$f":"IF($P$54>0,\" \",\"1\")","v":"1"},"Soil Erosion and Sediment Control (SESC) Plan"]
[null,null,null,{"$f":"IF($P$54>0,\" \",\"1\")","v":"1"},"Post-Construction Operation and Maintenance (O&M) Plan ",null,null,null,null,null,null,null,null,"Date Received:"]
[null,null,null,null,{"$f":"IF($P$54>0,\"Stormwater Construction Permit Fee Waived when submitting concurrently with a Freshwater Wetland Application\",\"Appropriate Fee: New Permit = $400; Permit Modification = $200.\")","v":"Appropriate Fee: New Permit = $400; Permit Modification = $200."}]
[]
[null,null,null,{"$f":"IF($P$54>0,\"1\",\" \")","v":" "},{"$f":"IF($P$54>0,\"Completed Freshwater Wetland Application Form\",\" \")","v":" "}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Updated: July 22, 2019"]

{"sheet":"General Project Information","index":1,"n_rows":70,"n_cols":8,"rows_kept":70,"cut":false,"hidden":false,"merged":[[66,0,66,8],[61,0,61,8],[62,1,62,8],[63,1,63,8],[64,1,64,8],[65,1,65,8],[57,1,57,8],[58,2,58,4],[58,6,58,8],[59,1,59,8],[57,0,58,0],[54,3,54,4],[54,5,54,6],[54,7,54,8],[55,0,55,8],[56,1,56,8],[40,1,40,8],[41,1,41,5],[41,6,41,8],[50,0,51,2],[50,3,51,4],[50,5,51,6],[50,7,51,8],[44,0,44,8],[45,1,45,2],[45,4,45,5],[45,7,45,8],[46,1,46,2],[46,4,46,5],[47,0,47,8],[48,0,48,8],[39,7,39,8],[9,6,11,8],[0,0,0,8],[1,0,1,1],[1,6,8,8],[2,0,2,1],[2,2,2,5],[3,2,3,5],[6,2,6,5],[12,6,14,8],[16,0,19,1],[20,0,20,8],[21,0,31,2],[21,3,31,4],[34,2,34,8],[3,0,6,1],[7,0,15,1],[7,2,15,5],[68,0,69,0],[5,2,5,5],[19,3,19,5],[18,3,18,5],[17,3,17,5],[16,3,16,5],[39,1,39,6],[43,1,43,8],[21,5,31,6],[21,7,31,8],[32,0,32,8],[33,0,33,8],[34,0,34,1],[68,1,68,8],[69,1,69,3],[69,4,69,8],[42,1,42,6],[42,7,42,8],[67,1,67,6],[67,7,67,8],[49,3,49,4],[49,5,49,6],[49,7,49,8],[52,0,52,2],[53,0,53,2],[53,3,53,4],[53,5,53,6],[53,7,53,8],[60,1,60,8],[54,0,54,2]]}
["APPENDIX A: STORMWATER MANAGEMENT PLAN CHECKLIST & LID PLANNING REPORT\n(RIDOT Redevelopment Projects Only)"]
["PROJECT NAME:",null,"Enter Here",null,null,null,"RIDEM USE ONLY"]
["PROJECT ID:",null,"Enter Here"]
["PROJECT LOCATION\nInclude a vicinity map/locus map in the site construction plans. ",null,"STREET & HIGHWAY ROUTE NUMBER:"]
[null,null,"Enter Here"]
[null,null,"MUNICIPALITY: "]
[null,null,"Enter Here"]
["BRIEF PROJECT \nDESCRIPTION",null,"Enter Here"]
[]
[null,null,null,null,null,null,"DATE RECEIVED"]
[]
[]
[null,null,null,null,null,null,"PROJECT FIID"]
[]
[]
[]
["ENGINEER",null,"FIRM:","Enter Here"]
[null,null,"CONTACT: ","Enter Here"]
[null,null,"PHONE: ","Enter Here"]
[null,null,"EMAIL : ","Enter Here"]
["STORMWATER MANAGEMENT PLAN ELEMENTS"]
["APPENDIX A: STORMWATER MANAGEMENT CHECKLIST \nPART 1: PROJECT AND SITE INFORMATION \nMINIMUM STANDARDS:\n6.  REDEVELOPMENT\n8.  LUHHPL IDENTIFICATION \nPART 2.\nMINIMUM STANDARD:\n1. LID SITE PLANNING\nPART 3.\nSUMMARY OF REMAINING STANDARDS\nPART 4.\nSUBWATERSHED MAPPING\nSITE PLAN DETAILS\n",null,null,"STORMWATER ANALYSIS AND DRAINAGE REPORT\nADDRESSES\nMINIMUM STANDARDS:\n\n2.  GROUNDWATER RECHARGE\n3.  WATER QUALITY VOLUME\n9. ILLICIT DISCHARGE DETECTION AND ELIMINATION\n",null,"SOIL EROSION AND SEDIMENT CONTROL PLAN\nADDRESSES\nMINIMUM STANDARDS:\n\n7.  POLLUTION PREVENTION DURING CONSTRUCTION\n10.  CONSTRUCTION EROSION AND SEDIMENTATION CONTROL\n",null,"OPERATIONS AND MAINTENANCE PLAN\nADDRESSES\nMINIMUM STANDARDS:\n\n7.  POLLUTION  PREVENTION AFTER CONSTRUCTION\n11.  OPERATIONS AND MAINTENANCE \n"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["PART 1: PROJECT & SITE INFORMATION"]
["Enter project type:",null,"Enter Here"]
[]
[]
[]
["Answer the following questions:"]
[null,"Has a pre-application meeting with RIDEM/CRMC been conducted? If yes, when? ",null,null,null,null,null,"Enter Here"]
[null,"Are minutes from the RIDEM or CRMC meeting available? If yes, attach to this checklist. "]
[null,"Is RIDEM grant funding involved? If yes, what is the grant?",null,null,null,null,"Enter Here"]
[null,"Has the RIDOT Office of SW Management (OSM) been consulted? If yes, when? ",null,null,null,null,null,"Enter Here"]
[null,"Is correspondence with the RIDOT OSM available? If yes, attach documentation to this checklist. "]
["Where does the project discharge (select all that apply)?"]
[null,"Surface Water",null,null,"Groundwater  - GAA",null,null,"Groundwater - GB"]
[null,"Combined Sewer (CSO)",null,null,"Groundwater - GA"]
["PART 1: PROJECT & SITE INFORMATION - CONT'D"]
["If the project discharges to a surface water, complete the following table. "]
[null,null,null,"#1",null,"#2",null,"#3"]
["Waterbody Name",null,null,"Enter Here",null,"Enter Here",null,"Enter Here"]
[]
["Waterbody ID",null,null,"Enter Here",null,"Enter Here",null,"Enter Here"]
["Is there a known history of repetitive flooding? If so, peak flow control may be required. "]
["Is the surface water a public beach and/or shellfish grounds?"]
["Freshwater Wetlands Jurisdiction"]
[null,"Has FEMA mapping been reviewed for floodplain and floodway information?"]
[null,"Does any activity extend within a 100-year floodplain? If yes, provide the following information:"]
[null,"Cut (cy):","Enter Here",null,null,"Fill (cy):","Enter Here"]
[null,"Is the floodplain storage capacity impacted by the proposed activity? "]
[null,"Any there any restrictions or modifications proposed to floodway? "]
["CRMC Jurisdiction"]
[null,"Has the CRMC jurisdictional map been reviewed? "]
[null,"If the project is within CRMC jurisdiction, does it require a CRMC permit? "]
[null,"Is the property subject to a Special Area Management Plan (SAMP)?"]
[null,"Is sea level rise mitigation designed into this project? "]
["RIDEM Office of Waste Management "]
[null,"Is the site on the list of CERCLA and State Sites in RI? If yes, what is the Site ID?",null,null,null,null,null,"Enter Here"]
[null,"Has the RIDEM Office of Waste Management been contacted? If yes, attach documentation."]
[null,"If yes, indicate the contact person. ",null,null,"Enter Here"]

{"sheet":"Worksheet A","index":2,"n_rows":25,"n_cols":6,"rows_kept":25,"cut":false,"hidden":false,"merged":[[13,4,14,4],[11,5,12,5],[13,5,14,5],[4,3,4,4],[9,0,16,0],[2,0,2,1],[4,0,4,1],[24,0,24,5],[17,0,20,0],[21,0,22,0],[8,0,8,1],[8,3,8,5],[13,1,14,1],[11,1,12,1],[9,1,10,1],[9,3,10,3],[9,4,10,4],[9,5,10,5],[11,3,12,3],[13,3,14,3],[11,4,12,4]]}
["Worksheet A: Stormwater Treatment Goal"]
[]
["Date:                                                                   ",null,"Prepared By: "]
[]
["Project ID:                                                                 ",null,"Location:","Municipality:"]
[]
["Instructions: Enter data in unshaded boxes. "]
[]
[null,null,"Project Information","Stormwater Treatment Information  "]
["Input \nreceiving waterbody information.\n1) Steps correlate to those in Section 1.1.2 of the Linear Stormwater Manual. ","A","Step 3.1(b): Enter Waterbody ID (WBID) per the"]
[null,null,"RIDEM GIS Map Room."]
[null,"B","Step 3.1(b): Enter waterbody name per the"]
[null,null,"RIDEM GIS Map Room."]
[null,"C","Step 3.1(c): Is the WBID impaired per the"]
[null,null,"RIDEM 303(d) List of Impaired Waters?"]
[null,"D","Step 3.1(c): Enter stormwater impairments/ pollutants of concern. Enter N/A if none."]
[null,"E","Step 3.1(d) Is there an SCP for the WBID? "]
["Input pre- & post- construction impervious areas.\nNote: Correlates to Step 2.1 of Section 1.2.2 of the Linear Stormwater Manual.  ","F","Total Pre-ConstructionA Impervious Area Contributing to the Waterbody (ft2) "]
[null,"G","Total DisturbedB Existing Impervious Area Contributing to the Waterbody (ft2) "]
[null,null,"└ Total Portion of (G) that comprises Mill & Overlay and/or Reclamation Area (ft2)"]
[null,"H","Total Post-ConstructionA Impervious Area Contributing to the Waterbody (ft2) "]
["Calculate treatment goal.","I","Post-Construction Net IncreaseC in Pervious Surface Area (ft2) = (F) - (H)",{"$f":"D18-D21","v":0},{"$f":"E18-E21","v":0},{"$f":"F18-F21","v":0}]
[null,"J","Post-Construction Impervious Surface Requiring Treatment (ft2) = (G)*0.5 - (I)",{"$f":"D19*0.5-D22","v":0},{"$f":"E19*0.5-E22","v":0},{"$f":"F19*0.5-F22","v":0}]
[null,"K","Total Stormwater Treatment Goal (ft3) \n= (J)*(1/12 ft.)",{"$f":"D23/12","v":0},{"$f":"E23/12","v":0},{"$f":"F23/12","v":0}]
["A Independent of project phasing.\nB Includes all disturbed impervious area with the exception of impervious area disturbed during pavement marking, installing traffic induction loops, installing wheelchair ramps, crack sealing, bridge washing, and limited scale maintenance activities. Impervious surface converted to pervious surface is considered disturbed. \nC Negative value represents a loss of pervious surface.\n "]

{"sheet":"Minimum Standards Compliance","index":3,"n_rows":108,"n_cols":3,"rows_kept":108,"cut":false,"hidden":false,"merged":[[105,1,105,2],[106,1,106,2],[107,1,107,2],[99,1,99,2],[100,1,100,2],[101,1,101,2],[102,1,102,2],[103,1,103,2],[104,1,104,2],[98,1,98,2],[82,0,82,2],[83,0,83,2],[87,0,87,2],[89,0,89,2],[90,1,90,2],[92,1,92,2],[93,1,93,2],[94,1,94,2],[95,1,95,2],[96,1,96,2],[97,1,97,2],[91,1,91,2],[84,1,84,2],[85,1,85,2],[86,1,86,2],[81,0,81,2],[70,0,70,2],[71,0,71,2],[72,1,72,2],[73,1,73,2],[74,1,74,2],[75,1,75,2],[76,1,76,2],[77,1,77,2],[78,1,78,2],[79,0,79,2],[80,0,80,2],[69,0,69,2],[57,0,57,2],[58,1,58,2],[59,1,59,2],[60,1,60,2],[61,0,61,2],[62,0,62,2],[63,0,63,2],[64,0,64,2],[65,1,65,2],[67,1,67,2],[68,0,68,2],[66,1,66,2],[32,0,32,1],[33,0,35,0],[33,1,35,1],[33,2,35,2],[56,1,56,2],[45,0,45,2],[46,0,46,2],[47,0,47,2],[48,0,48,2],[49,1,49,2],[50,1,50,2],[51,0,51,2],[52,0,52,2],[53,1,53,2],[54,1,54,2],[55,1,55,2],[41,1,41,2],[19,0,19,1],[20,0,20,1],[20,2,21,2],[22,0,22,1],[23,2,28,2],[24,0,24,1],[26,0,27,0],[36,0,36,2],[37,0,37,1],[38,1,38,2],[39,1,39,2],[40,0,40,2],[29,0,29,2],[30,0,30,2],[31,0,31,2],[17,0,17,1],[17,2,18,2],[0,0,0,2],[1,0,1,2],[2,0,2,2],[3,0,3,1],[4,0,4,1],[4,2,8,2],[5,0,6,0],[9,0,9,1],[9,2,13,2],[10,0,10,1],[14,0,14,1],[16,0,16,1]]}
["PART 2: MINIMUM STANDARD 1 "]
["Relates to Study & Development of Stormwater Management (WBS 1.14)"]
["Low Impact Development (LID) Assessment"]
["Preservation of Undisturbed Area, Buffers & Floodplains",null,"If not implemented - explain here:"]
["Relates to Step 3.1 of Study & Development of Stormwater Management",null,"Enter here. "]
[null,"Are sensitive resource areas within the project LOD? Refer to the:"]
[null,"Environmental Resource Map of the RIDEM Map Room"]
[null,"If answering yes to the question above: have resource area boundaries been field verified? "]
[null,"If answering yes to the question above: Will all vegetated buffers and coastal and freshwater wetlands be protected during and after construction?"]
["Locate Development in Less Sensitive Areas and Work with the Natural Landscape, Hydrology & Soils",null,"If not implemented - explain here:\nEnter here. \n"]
["Relates to Steps 3 & 4 of Study & Development of Stormwater Management"]
[null,"Have areas with greatest infiltration capacity (e.g., Hydrologic Soil Groups A and B) been prioritized for locating STUs? "]
[null,"Have infiltration measures been identified in areas that have minimal potential for compaction during construction? "]
[null,"Have QPAs/Filter Strips been identified in areas that have minimal potential for being disturbed during construction? "]
["Minimize Clearing & Grading",null,"If not implemented - explain here:"]
[null,"Is site clearing restricted to minimum area needed for laydown areas, development activities, construction access and safety?","Enter here. "]
["Reduce Impervious Cover",null,"If not implemented - explain here:"]
["Relates to Step 1 of Study & Development of Stormwater Management ",null,"Enter here. "]
[null,"Were alternatives to reduce impervious cover evaluated during the Develop Alternatives tasks of WBS 1.08.04?"]
["Disconnect Impervious Area",null,"If not implemented - explain here:"]
["Relates to Step 1 of Study & Development of Stormwater Management",null,"Enter here. "]
[null,"Has runoff from an impervious surface been (1) captured and infiltrated by a pervious surface, which is separated from a drainage system; (2) discharged to a drainage system, but the drainage system does not discharge to a waterbody per Section IV.6(cc) of the Consent Decree; or (3) treated by a Qualified Pervious Area (QPA) per the RI Stormwater Rules.\n"]
["Provide Low-Maintenance Vegetation",null,"If not implemented - explain here:"]
[null,"Has vegetation been selected from the Vegetation Palettes of Section 2.1.4 of the RIDOT Linear Stormwater Manual? ","Enter here. "]
["Please select one:"]
[null,"RIDOT will maintain vegetation."]
[null,"A third party will maintain vegetation on behalf of RIDOT. "]
[null,"Name of third party: Enter here."]
[null,"If a third party will be maintaining the vegetation, has an agreement been executed by RIDOT and the third party? "]
["PART 2: MINIMUM STANDARD 1 - CONT'D"]
["Relates to Study & Development of Stormwater Management (WBS 1.14)"]
["Low Impact Development (LID) Assessment - CONT'D"]
["Restore Streams/Wetlands",null,"If not implemented - explain here:"]
[null,"Have opportunities been identified that convert existing closed conveyance infrastructure (e.g., culverted or piped streams) to open channel infrastructure (e.g., swale)?","Enter here. "]
[]
[]
["Complete RIDOT Worksheet A"]
["Relates to RIDOT Step 2 of Study & Development of Stormwater Management (WBS 1.14)"]
[null,"Has more than one Waterbody ID (WBID) been identified within the project LOD?"]
[null,"If answering yes to the question above: have separate treatment goals been identified for each WBID?"]
["Complete Table 5-3 of this Checklist "]
[null,"Is Table 5-3 updated with soils data? Relates to Step 3.3 of Section 1.2.2 of the Linear Stormwater Manual. "]
[]
[]
[]
["PART 3: SUMMARY OF REMAINING STANDARDS "]
["Relates to Final Design of Stormwater Management (WBS 2.04) "]
["Minimum Standard 2: Groundwater Discharge"]
["Groundwater recharge is inherently satisfied by the process outlined in Step 4 of Section 1.2.2 of the Linear Stormwater Manual; no additional steps are required with the exception of the following questions:"]
[null,"Are infiltrating STUs proposed in any CERCLA or contaminated sites? "]
[null,"If answering yes to the question above: has the area been approved for infiltration by the Office of Waste Management? Refer to the RIDEM Subsurface Contamination Guidance document. "]
["Minimum Standard 3: Water Quality"]
["The water quality standard is inherently satisfied by the process outlined in Step 4 of Section 1.2.2 of the RIDOT Linear Stormwater Manual; no additional steps are required with the exception of the following questions:"]
[null,"Is an STU from the approved technology list proposed for the project? If yes, please attach the design worksheets from the manufacturer."]
[null,"If answering yes to the question above: has RIDOT Office of Stormwater Management been consulted, and does the OSM approve of the proposed STU?"]
[null,"Have the design worksheets from the manufacturer been used to size and select the STU? If yes, attach worksheets. "]
[null,"Does the project request a waiver for certain setback requirements? If yes, please explain: Enter here."]
["Select the techniques used to size the STUs and flow control structures: "]
[null,"Split Pervious/Impervious method in HydroCAD"]
[null,"TR-55 or TR-20"]
[null,"Other: Enter here. "]
["Minimum Standard 4: Conveyance and Natural Channel Protection"]
["This standard is waived in accordance with Section 3.2.6 of the RISDISM.  "]
["Minimum Standard 5: Overbank Flood Protection & Other Potential High Flows"]
["This standard is waived in accordance with Section 3.2.6 of the RISDISM, unless RIDEM and/or RIDOT OSM has identified the discharge locations to have a known history of repetitive flooding."]
[null,"Has RIDEM and/or RIDOT OSM identified that the discharge location(s) have a known history of repetitive flooding? "]
[null,"If answering yes to the question above: coordinate with the regulatory agency and describe any requirements:"]
[null,"Enter here. "]
["PART 3: SUMMARY OF REMAINING STANDARDS - CONT'D"]
["Relates to Final Design of Stormwater Management (WBS 2.04) "]
["Minimum Standard 5: Overbank Flood Protection & Other Potential High Flows - CONT'D"]
["The following questions shall be answered despite Minimum Standard 5 being waived:"]
[null,"Has infrastructure been provided (i.e., flow diversion weirs) to safely convey flow to a new or upgraded STU for the 100-year event? "]
[null,"Has infrastructure been provided to safely and non-erosively convey overflow from the STU for the 100-year event? "]
[null,"Are off-site areas that contribute runoff to the project limits included in the pre- and post-development modeling analyses? It is necessary to include these contributions to appropriately size stormwater infrastructure. "]
[null,"If answering yes to the question above: are the off-site areas modeled as “present condition” for both the pre- and post-development modeling analyses?"]
[null,"Are the areas outside the LOD (i.e., off-site areas) that contribute runoff to the site shown on the subwatershed maps?"]
[null,"Does the hydrologic model confirm safe and non-erosive passage of off-site runoff through the site for the 100-year flow?"]
[null,"Has Table 5-1 of this checklist been updated with pre- and post-construction peak flow rates? "]
["Minimum Standard 7: Pollution Prevention"]
["Refer to Minimum Standards 10 and 11. "]
["Minimum Standard 8: Land Uses with Higher Potential Pollutant Loads (LUHPPLs)"]
["Roadways, bridges, sidewalks, parking lots are not LUHPPLs; this standard is automatically waived. "]
["Minimum Standard 9: Illicit Discharges"]
[null,"Has the site been investigated for illicit discharges? "]
[null,"Have any illicit discharges been found? If yes, please notify RIDOT OSM."]
[null,"Have corrective actions been taken to address illicit discharges? "]
["Minimum Standard 7 & 10: Soil Erosion and Sediment Control "]
[null,"Has the RIDOT SWPPP template been utilized? Refer to the following link:","RIDOT Stormwater Page"]
["If answering no to the question above: include the following elements on the Soil Erosion and Sediment Control Plan (SESC Plan) as part of the Construction Plan Set (select the data that has been included):"]
[null,"Provide Natural Buffers and Maintain Existing Vegetation;"]
[null,"Minimize Area of Disturbance;"]
[null,"Minimize the Disturbance of Steep Slopes;"]
[null,"Preserve Topsoil;"]
[null,"Stabilize Soils;"]
[null,"Protect Storm Drain Inlets;"]
[null,"Protect Storm Drain Outlets;"]
[null,"Establish Temporary Controls for the Protection of Post-Construction Stormwater Control Measures;"]
[null,"Establish Perimeter Controls and Sediment Barriers;"]
[null,"Divert or Manage Run-On from Up-Gradient Areas;"]
[null,"Properly Design Constructed Stormwater Conveyance Channels;"]
[null,"Retain Sediment On-Site;"]
[null,"Control Temporary Increases in Stormwater Velocity, Volume, and Peak Flows;"]
[null,"Apply Construction Activity Pollution Prevention Control Measures;"]
[null,"Install, Inspect, and Maintain Control Measures and Take Corrective Actions."]
[null,"Qualified SESC Plan Preparer’s Information and Certification;"]
[null,"Operator’s Information and Certification; if not known at the time of application the operator must certify the SESC Plan upon selection and prior to initiating site activities;"]
[null,"Description of Control Measures (e.g., temporary sediment trapping and conveyance practices); include design calculations and supporting documentation, as required."]

{"sheet":"Tables","index":4,"n_rows":45,"n_cols":10,"rows_kept":45,"cut":false,"hidden":false,"merged":[[44,0,44,9],[32,9,35,9],[33,2,35,2],[33,3,35,3],[32,7,35,7],[32,8,35,8],[32,2,32,3],[32,5,35,5],[32,6,35,6],[32,4,35,4],[36,0,36,1],[32,0,35,1],[37,0,37,1],[38,0,38,1],[39,0,39,1],[40,0,40,1],[0,0,0,9],[1,0,1,9],[3,2,3,3],[3,4,3,5],[3,6,3,7],[3,8,3,9],[2,5,2,7],[2,0,2,4],[3,0,4,1],[31,2,31,9],[26,0,26,9],[27,0,27,9],[28,0,28,9],[22,3,22,4],[16,3,16,4],[17,3,17,4],[18,3,18,4],[23,3,23,4],[24,3,24,4],[41,0,41,1],[42,0,42,1],[43,0,43,1],[31,0,31,1],[10,0,10,1],[11,0,11,1],[12,0,12,1],[14,0,14,9],[29,5,29,9],[30,0,30,4],[30,5,30,9],[29,0,29,4],[19,3,19,4],[20,3,20,4],[21,3,21,4],[15,0,15,9],[5,0,5,1],[6,0,6,1],[7,0,7,1],[8,0,8,1],[9,0,9,1]]}
["Table 5-1 Hydrologic Analysis Summary "]
["Relates to Minimum Standard 5: Overbank Flood Protection & Other Potential High Flows"]
["Runoff Method Applied for 1.2\" Water Quality Event:"]
["STU ID",null,"1.2\" Peak Flow",null,"1-yr. Peak Flow",null,"10-yr. Peak Flow",null,"100-yr. Peak Flow"]
[null,null,"Pre (cfs)","Post (cfs)","Pre (cfs)","Post (cfs)","Pre (cfs)","Post (cfs)","Pre (cfs)","Post (cfs)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Table 5-2 Summary of Best Management Practices (i.e., STUs)"]
["Relates to Step 4 of Section 1.2.2 of the RIDOT Linear Stormwater Manual"]
["STU ID","WBID","DP No.","BMP Type",null,"Impervious Area\n(ft2)","Pervious Area \n(ft2)","Provided Pretreat-ment Vol. \n(ft3) ","Provided \nWQV  \n(ft3)","Treatment Depth (in.)\n(e.g., 0.5\", 1\", etc.)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Table 5-3 Summary of Soils to Evaluate STUs"]
["Relates to Step 3.3 of Section 1.2.2 of the RIDOT Linear Stormwater Manual"]
["Enter the following information (as applicable):"]
["Name of DEM-licensed Class IV Soil Evaluator: ",null,null,null,null,"Enter here. "]
["Name of RI-registered Professional Engineer: ",null,null,null,null,"Enter here. "]
[null,null,"Is a geotechnical report attached to this checklist?"]
["STU ID",null,"Test Pit ID*",null,"Depth of Boring/Test Pit\n(ft.)","Top of Filter Elev. \n(ft.)","SHGT Elev. (ft.)","Separation Distance \n(ft.)","Hydrologic Soil Group A, B, C or D","Exfiltration Rate Applied\n(in./hr.)"]
[null,null,"Primary","Secondary"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["* Provide supporting soil field test data. "]

{"sheet":"Worksheet B","index":5,"n_rows":23,"n_cols":6,"rows_kept":23,"cut":false,"hidden":false,"merged":[[11,0,15,0],[21,0,21,5],[4,3,4,4],[2,0,2,1],[4,0,4,1],[9,0,10,0],[8,0,8,1],[8,3,8,5]]}
["Worksheet B: Treatment Provided by STUs"]
[]
["Date:                                                                   ",null,"Prepared By: "]
[]
["Project ID:                                                                 ",null,"Location:","Municipality:"]
[]
["Instructions: Enter data in unshaded boxes. "]
[]
["PART 1 ",null,"Project Information","Stormwater Treatment Information  "]
["Information from Worksheet A. ","A","Waterbody ID (WBID)",{"$f":"IF('Worksheet A'!D10=\"\",\"\",'Worksheet A'!D10)","v":""},{"$f":"IF('Worksheet A'!E10=\"\",\"\",'Worksheet A'!E10)","v":""},{"$f":"IF('Worksheet A'!F10=\"\",\"\",'Worksheet A'!F10)","v":""}]
[null,"B","Total Stormwater Treatment Goal (ft3)                                   ",{"$f":"'Worksheet A'!D24","v":0},{"$f":"'Worksheet A'!E24","v":0},{"$f":"'Worksheet A'!F24","v":0}]
["Input STU Treatment Volumes.\nNotes: \n1) Steps correlate to those in Section 1.2.2 of the Linear Stormwater Manual. \n2) Items F & G apply only to waterbodies that are impaired by stormwater.  ","C","Step 4.1: Total Volume to Filter Strips (ft3)"]
[null,"D","Step 4.2: Total Volume of Stormwater Treated by Upgrading Existing STUs (ft3) "]
[null,"E","Step 4.3: Total Volume of Stormwater Treated by Tier 1 STUs Inside the Project Limits (ft3) "]
[null,"F","Step 4.4: Total Volume of Stormwater Treated by Tier 2 STUs Inside the Project Limits (ft3) "]
[null,"G","Step 4.4: Total Volume of Stormwater Treated by Tier 1 STUs Outside the Project Limits (ft3) "]
["Calculate Total Treatment Provided.","H","Total Volume of Stormwater Treated (ft3) \n= Sum of Items in Step 2",{"$f":"SUM(D12:D16)","v":0},{"$f":"SUM(E12:E16)","v":0},0]
["Calculate Treatment Surplus/Deficit.","I","Total VolumeA of Remaining Stormwater Requiring Treatment (ft3) = (B) - (H)",{"$f":"D11-D17","v":0},{"$f":"E11-E17","v":0},0]
["ANegative value indicates a surplus of treatment. "]
[]
["PART 2 \n(treatment deficit only) "]
["Attach justification to this worksheet for treatment deficit. Utilize the STU Selection Tool as a basis for this justification. This tool is available on the "]
["RIDOT Stormwater Page."]

{"sheet":"Plan Contents","index":6,"n_rows":44,"n_cols":2,"rows_kept":44,"cut":false,"hidden":false,"merged":[[13,0,13,1],[22,0,22,1],[32,0,32,1],[41,0,41,1],[0,0,0,1],[1,0,1,1],[2,0,2,1],[3,0,3,1],[11,0,11,1],[12,0,12,1]]}
["PART 3: SUBWATERSHED MAPPING AND SITE PLAN DETAILS "]
["Relates to Final Design of Stormwater Management (WBS 2.04) "]
["Existing & Proposed Subwatershed Mapping"]
["Include the following elements on the existing and proposed subwatershed plans (select all that have been provided):"]
[null,"Plans: 24-inch by 36-inch with a usable scale "]
[null,"Drainage area boundaries: based on delineations; incorporate off-site areas that contribute to the project site (labels shall include area of drainage boundary and curve number)"]
[null,"Streams & drainage swales: location, elevation data, cross sections, profiles, method of stabilization"]
[null,"Drainage flow paths: mapped according to Appendix K of the RISDISM; include time of concentration values"]
[null,"Design points: locations, type (e.g., property boundary, drainage system, etc.)"]
[null,"STUs: type, location, dimensions, grading, elevation data; STU labels must correspond to other submittals"]
[null,"Borings & test pit information: boring/test pit locations, soil types, bedrock & SHGT elevations (not only depths)"]
["Site Construction Plans"]
["Include the following elements on the site construction plans (select all that have been provided)"]
["General (Existing & Proposed)"]
[null,"Vicinity Map/Locus Map"]
[null,"Plans: at a scale not greater than 1-inch = 40 feet (1\"=40') and include a north arrow "]
[null,"Topography: 1 or 2-foot contours; 10-foot contours accepted for areas outside the LOD "]
[null,"Structures (e.g., buildings, driveways, sidewalks): location, dimensions "]
[null,"Utilities (e.g., water, sewer, gas, electric): location, dimensions, materials, easements"]
[null,"Roadways: cross-sections with edge details such as curbs, sidewalks, edge of pavement, etc."]
[null,"Predominant vegetation: type, location, boundaries, protection measures during construction"]
[null,"Limit of disturbance/clearing: boundary"]
["Resource Protection Areas"]
[null,"Freshwater & coastal wetlands: type, location, field-verified boundaries"]
[null,"Lakes & ponds: type, location, field-verified boundaries"]
[null,"Coastal shoreline features: type, location, field-verified boundaries"]
[null,"Perennial & intermittent streams: type, location, field-verified boundaries"]
[null,"Areas subject to storm flowage (ASSFs): location, boundaries"]
[null,"Floodplain & floodway limits: location, boundary, FEMA zone designation, 100-year elevation (i.e., Base Flood Elevation, or BFE)"]
[null,"Channel modifications (e.g., bridge crossings or culverts): location, dimensions"]
[null,"Proposed stream or wetland crossings: locations, cross sections, profiles, and method of stabilization"]
[null,"Required resource area setbacks (e.g., buffers): type, location"]
["Drainage Infrastructure (Existing & Proposed)"]
[null,"Drainage structures (e.g., manholes, catch basins): location, size, rim & invert elevations"]
[null,"Conveyance structures (e.g., grass channels, swales, storm drains): location, dimensions, material, invert elevations, representative cross-sections and profiles, notes and details"]
[null,"STUs: type, location, dimensions, grading, notes and details; STU labels must correspond to other submittals"]
[null,"STU planting plans: type, size, species, planting methods, maintenance requirements"]
[null,"Required setbacks (e.g., infiltration, water supply wells, septic systems): type, location"]
[null,"Outlet control structures (e.g., embankments, spillways): location, dimensions, elevations, notes and details"]
[null,"Stabilization measures (e.g., riprap, turf reinforcement matting): type, location, notes and details"]
[null,"Final discharge point (e.g., wetlands, waterbodies): type, location"]
["Soils"]
[null,"Borings & test pit information: boring/test pit locations, soil types, SHGT elevations (not only depths)"]
[null,"RIDEM Office of Waste Management approved activities: as they relate to current/former site use areas for any known contamination and/or remedial clean-up efforts"]

{"sheet":"pick lists","index":7,"n_rows":41,"n_cols":45,"rows_kept":41,"cut":false,"hidden":true,"merged":[]}
["City/Town","Permit Type for Modification","Federal Permit Type","Permit Type","App Type ","Fee","WBClass","WBClass","WBClass Description","Water Quality Regulations Appendix A",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,"Scoping"]
["Click to Select","STW/WQC","Click to Select One:","Click HERE to Select","Renewal",100,"Click to Select",null,null,"http://www.dem.ri.gov/pubs/regs/regs/water/h20q09a.pdf",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,"Design/build scope"]
["Barrington","Wetlands","RI CRMC Jurisdiction","Freshwater Wetlands","Transfer",200,"AA","Freshwaters",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,"10% Initial Review"]
["Bristol","WQC","Freshwater Wetlands Individual Permit (IP)","Water Quality Certification",null,null,"AA@","Class AA@","These waters are designated as a source of public drinking water supply (PDWS) or as tributary waters within a public drinking water supply watershed (the terminal reservoir of the PDWS are identified in Appendix A), for primary and secondary contact recreational activities and for fish and wildlife habitat. These waters shall have excellent aesthetic value.",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,"30% Intermediate Review"]
["Burrillville","GWD/UIC",null,"GWD/UIC",null,null,"A","Class A","These waters are designated for primary and secondary contact recreational activities and for fish and wildlife habitat. They shall be suitable for compatible industrial processes and cooling, hydropower, aquacultural uses, navigation, and irrigation and other agricultural uses. These waters shall have excellent aesthetic value.",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,"90% Pre-Final Review"]
["Central Falls","RIPDES",null,"RIPDES",null,null,"B","Class B*","These waters are designated for fish and wildlife habitat and primary and secondary contact recreational activities. They shall be suitable for compatible industrial processes and cooling, hydropower, aquacultural uses, navigation, and irrigation and other agricultural uses. These waters shall have good aesthetic value.",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,"Final PS&E (100%)"]
["Charlestown",null,"Fill Waters of the State","Stormwater Engineering",null,null,"B*","Class B1*","These waters are designated for primary and secondary contact recreational activities and fish and wildlife habitat. They shall be suitable for compatible industrial processes and cooling, hydropower, aquacultural uses, navigation, and irrigation and other agricultural uses. These waters shall have good aesthetic value. Primary contact recreational activities may be impacted due to pathogens from approved wastewater discharges. However all Class B criteria must be met.",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,"Pre-Con Conference"]
["Coventry",null,"Click to Select One:",null,null,null,"B1","Class C","These waters are designated for secondary contact recreational activities and fish and wildlife habitat. They shall be suitable for compatible industrial processes and cooling, hydropower, aquacultural uses, navigation, and irrigation and other agricultural uses. These water shall have good aesthetic value.",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,"Active Construction"]
["Cranston",null,"Programmatic General Permit (PGP) Eligible",null,null,null,"B1*","@","Class AA waters used for public drinking water supply may be subject to restricted recreational use by State and local authorities.",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,"Final Inspection & Comments"]
["Cumberland",null,"Individual Permit (IP) Required",null,null,null,"C","* ","Certain Class B and B1 waterbody segments may have partial use designations assigned to them as noted in rule 8.B.(3) and described below.",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,"Coordination"]
["East Greenwich",null,"Restoration General Permit Eligible",null,null,null,"SA","Seawaters",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,"Site Review"]
["East Providence",null,null,null,null,null,"SA@","Class SA@ * ","These waters are designated for shellfish harvesting for direct human consumption, primary and secondary contact recreational activities, and fish and wildlife habitat. They shall be suitable for aquacultural uses, navigation, and industrial cooling. These waters shall have good aesthetic value. Class ",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,"PAPA Submission"]
["Exeter",null,null,null,null,null,"SA*","SB*","These waters are designated for primary and secondary contact recreational activities; shellfish harvesting for controlled relay and depuration; and fish and wildlife habitat. They shall be suitable for aquacultural uses, navigation, and industrial cooling. These waters shall have good aesthetic value.",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,"Review"]
["Foster",null,"NHA",null,null,null,"SA@*","Class SB1*","These waters are designated for primary and secondary contact recreational activities and fish and wildlife habitat. They shall be suitable for aquacultural uses, navigation, and industrial cooling. These waters shall have good aesthetic value. Primary contact recreational activities may be impacted due to pathogens from approved wastewater discharges. However all Class SB criteria must be met.",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,"Other"]
["Glocester",null,"Click to Select",null,null,null,"SB","Class SC","These waters are designated for secondary contact recreational activities, and fish and wildlife habitat. They shall be suitable for aquacultural uses, navigation, and industrial cooling. These waters shall have good aesthetic value."]
["Hopkinton",null,"Yes",null,null,null,"SB*","@","@ Some Class SA waters contain Closed Safety Zones which are waters in the vicinity of an approved sanitary discharge which may be impacted in the event of complete failure of treatment and are therefore, currently prohibited to shellfishing. Although shellfishing use is restricted, all SA criteria must be met."]
["Jamestown",null,"No",null,null,null,"SB1","*","* Certain Class SA, SB and SB1 waterbody segments may have partial use designations assigned to them as noted in rule 8.B.(3) and described below."]
["Johnston",null,null,null,null,null,"SB1*"]
["Lincoln",null,"BMP Type",null,null,null,"SC","Partial Uses"]
["Little Compton",null,"Bioretention Swale",null,null,null,null,null,"In accordance with rule 8.B.(3). of these regulations, the Department may assign a partial use subcategory to a waterbody segment where waters are affected by combined sewer overflows or mooring fields. A partial use designation may affect the application of criteria."]
["Middletown",null,"Bioretention Basin",null,null,null,null,"a. CSO - These waters will likely be impacted by combined sewer overflows in accordance with approved CSO Facilities Plans and in compliance with rule 19.E.1 of these regulations and the Rhode Island CSO Policy. Therefore, primary contact recreational activities; shellfishing uses; and fish and wildlife habitat will likely be restricted.","a. CSO - These waters will likely be impacted by combined sewer overflows in accordance with approved CSO Facilities Plans and in compliance with rule 19.E.1 of these regulations and the Rhode Island CSO Policy. Therefore, primary contact recreational activities; shellfishing uses; and fish and wildlife habitat will likely be restricted."]
["Narragansett",null,"Bioretention Curb Extension Planter",null,null,null,null,"b. Concentration of Vessels - these waters are in the vicinity of marinas and/or mooring fields and therefore seasonal shellfishing closures will likely be required as listed in the most recent (revised annually) RIDEM document entitled Shellfish Closure Areas. , however, all Class SA criteria must be attained.","b. Concentration of Vessels - these waters are in the vicinity of marinas and/or mooring fields and therefore seasonal shellfishing closures will likely be required as listed in the most recent (revised annually) RIDEM document entitled Shellfish Closure Areas. , however, all Class SA criteria must be attained."]
["New Shoreham",null,"Bioretention Curb Inlet Planter",null,null,null,null,"Coldwater/Warmwater Fisheries"]
["Newport",null,"Bioretention Parking Lane Adjacent Planter",null,null,null,null,null,"Freshwater rivers and streams, and lakes and ponds are designated coldwater, warmwater or unassessed based upon the potential for the presence of brook trout by evaluating current and historical presence/absence information, habitat, water quality and physical characteristics data. Where coldwater fish exist in waters not yet designated as coldwater, the coldwater fish and habitat will be protected as an existing use."]
["North Kingstown",null,"Gravel Wetland (WVTS)",null,null,null,null,null,"The following is a list of symbols used in the water quality classification listing:"]
["North Providence",null,"Hydrodynamic Separator",null,null,null,null,"#","Located next to the Waterbody ID number, the # indicates a segment where the Water Effect Ratios (WERs) and Site Specific Criteria (See Appendix B) apply."]
["North Smithfield",null,"Infiltration Basin",null,null,null,null,"@","Located next to the Waterbody ID number identifies the terminal reservoir of the public drinking water supply."]
["Pawtucket",null,"Infiltration Gutter",null,null,null,null,"*","Located next to the Waterbody ID number identifies a closed safety zone."]
["Portsmouth",null,"Infiltration Trench",null,null,null,null,"{a}","Located next to the classification, {a} indicates a partial use designation due to impacts from CSOs."]
["Providence",null,"Leaching Basin",null,null,null,null,"{b}","Located next to the classification, {b} indicates a partial use designation due to impacts from a concentration of vessels."]
["Richmond",null,"Oil/Grit Separator"]
["Scituate",null,"Other",null,null,null,null,"General Water Quality Classification Rules"]
["Smithfield",null,"Pavement Removal",null,null,null,null,"In accordance with rule 8.C. of these regulations:"]
["South Kingstown",null,"Porous Pavement",null,null,null,null,"1. All streams tributary to Class A waters shall be Class A."]
["Tiverton",null,"Porous Pavement with storage",null,null,null,null,"2. All waters tributary to Class AA waters shall be Class AA."]
["Warren",null,"QPA/Filter Strip",null,null,null,null,"3. All freshwaters hydrologically connected by surface waters and upstream of Class B, SB, C or SC waters shall be Class B unless otherwise identified in Appendix A of these regulations."]
["Warwick",null,"Sand Filter",null,null,null,null,"4. All other fresh waters, including, but not limited to, ponds, kettleholes and wetlands not listed in Appendix A shall be considered to be Class A."]
["West Greenwich",null,"Tree Filter",null,null,null,null,"5. All seawaters not listed in Appendix A shall be considered to be Class SA. All saltwater and brackish wetlands contiguous to seawaters not listed in Appendix A shall be considered to be Class SA."]
["West Warwick",null,"Tree Filter with Storage",null,null,null,null,"6. All saltwater and brackish wetlands contiguous to seawaters listed in Appendix A shall be considered the same class"]
["Westerly",null,"Underground Infiltration System"]
["Woonsocket"]

{"sheet":"Review Checklist","index":8,"n_rows":57,"n_cols":11,"rows_kept":57,"cut":false,"hidden":false,"merged":[[3,0,3,2],[3,3,3,4],[0,0,0,6],[1,0,1,2],[2,0,2,2],[7,1,7,2],[4,0,4,2],[4,3,4,4],[5,0,5,2],[5,3,5,4],[6,0,6,2]]}
["Office of Stormwater Management (OSM) Review Checklist - RIDOT USE ONLY",null,null,null,null,null,null,null,{"$f":"IF('General Project Information'!F53=\"\",'General Project Information'!D53,IF('General Project Information'!H53=\"\",_xlfn.CONCAT('General Project Information'!D53, \", \",'General Project Information'!F53),_xlfn.CONCAT('General Project Information'!D53, \", \", 'General Project Information'!F53, \", \", 'General Project Information'!H53)))","v":"Enter Here, Enter Here, Enter Here"}]
["Project Title:",null,null,"Enter Here",null,null,null,null,{"$f":"IF(SUM('Worksheet A'!D19:F19)>43560,\">1 acre (requires RIPDES permit)\",\"<1 acre\")","v":"<1 acre"}]
["FAP #",null,null,null,null,"Area of Disturbance: (circle)","<1 acre",null,{"$f":"IF('Worksheet A'!D17=\"Yes\",'Worksheet A'!D10,\"\")","v":""},{"$f":"IF('Worksheet A'!E17=\"Yes\",'Worksheet A'!E10,\"\")","v":""},{"$f":"IF('Worksheet A'!F17=\"Yes\",'Worksheet A'!F10,\"\")","v":""}]
["RIDOT PM:",null,null,null,null,null,null,null,{"$f":"_xlfn.CONCAT(I3, \" \", J3, \" \", K3)","v":"  "}]
["OSM Reviewer:",null,null,null,null,"Review Type:"]
["OSM Signoff:",null,null,null,null,"Status:"]
["WBIDs:",null,null,"Enter Here, Enter Here, Enter Here",null,"SCP:","  "]
[null,"State Road:",null,"Enter Here"]
[]
[null,"Y/N/NA","Item","Docs.","Description","Stormwater Review Comment","Comment Addressed"]
[null,null,null,"Plans","Infrastructure Maintenance and Repair","Per Consent Decree (CD)"]
[null,null,1,null,"Clean and Flush Drainage System (CFP)","per CD VI.D.46"]
[null,null,2,null,"Repair Vertical Structures","per CD VI.D.47"]
[null,null,3,null,"Repair Manholes and Catch Basins","per CD VI.D.47"]
[null,null,4,null,"Properly Identified Limits of Disturbance ","Per RIPDES CGP Applicability"]
[null,null,5,null,"Located Outfalls - Field Verified","per CD VI.D.47a"]
[null,null,null,"SESC Plan/SWPPP","Soil Erosion and Sediment / Pollution Control","Per MS4 GP and RIPDES CGP"]
[null,null,6,null,"CFS (not haybales) or other Perimeter Controls","Per RIPDES CGP J.1.f. and \"new\" Spec. Section 206 (not approved yet)"]
[null,null,7,null,"Outfall Protection Stormwater Discharge","Per RIPDES CGP J.1.e."]
[null,null,8,null,"Inlet Protection","Per RIPDES CGP J.1.d."]
[null,null,9,null,"Designate Washout Practices (locations or areas where not to washout)","Per RIPDES CGP J.2.j."]
[null,null,10,null,"Construction Accesses Provided","Per RIPDES CGP J.2.b."]
[null,null,11,null,"Laydown Areas Provided with Cover (as appropriate)","Per RIPDES CGP J.2.g."]
[null,null,12,null,"Dewatering Practices Addressed","Per RIPDES CGP J.2.f."]
[null,null,13,null,"Stabilization Plans/Steep Slopes - Erosion Control Mats","Per RIPDES CGP J.1.c."]
[null,null,14,null,"Stockpile Containment","Per RIPDES CGP J.2.h."]
[null,null,15,null,"Wildflower/Pollinator Seed Mix (as appropriate)","?"]
[null,null,16,null,"Timelines, Gaps in Schedule Coverage","? Not sure what you mean. "]
[null,null,null,"Appendix A Checklist","11 Minimum Stormwater Standards","(for more complex projects, a drainage report may be requested by OSM)"]
[null,null,17,null,"Appendix A Checklist Overall"]
[null,null,18,null,"Pavement Reduction"]
[null,null,19,null,"Disconnection of Stormwater"]
[null,null,20,null,"Test Pits Completed by 90% Design"]
[null,null,21,"Worksheet A","Stormwater Goal is Correct"]
[null,null,22,"Worksheet B","Stormwater Proposed is Sufficient"]
[null,null,23,"MEP Worksheet","Did Project Perform to MEP?"]
[null,null,24,"Item List","Items and Quantities"]
[null,null,25,null,"Erosion Control Maintenance"]
[null,null,26,null,"Qty for Excavation & Repair of Blocked Outfalls "]
[null,null,27,null,"Qty for CB & MH Reconstruction - VLF?"]
[null,null,28,null,"Qty for Construction Accesses"]
[null,null,29,null,"Qty for CFP"]
[null,null,30,null,"Qty for Inlet Protection"]
[null,null,31,null,"Qty - Other"]
[null,null,32,"Other","Other Issues"]
[null,null,33,null,"C&M Agreement Required"]
[null,null,34,null,"Contaminated Soils or Dewatering"]
[null,null,35,null,"STUs are Accessable and Maintainable"]
[null,null,36,null,"Any New Mitigation Techniques"]
[null,null,37,null,"Permitting is Required"]
[null,null,38,null,"Submittal of Drainage Reports to OSM is Required"]
[null,null,39,null,"Submittal of Construction Report/As-Builts for STU to OSM is Required","Per EPA Consent Decree"]
[null,null,40,null,"Submittal of O&M Plan for STU to OSM is Required","Per EPA Consent Decree"]
[null,null,41,null,"High Risk Issues"]
[null,null,42,null,"Other Issues"]
[]
[null,"Updated: July 22, 2019"]

{"sheet":"RIDOT STU History","index":9,"n_rows":13,"n_cols":51,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[null,"RIDOT STU History - RIDOT USE ONLY"]
["Infil Rate","STU Name","Legacy ID","TIP ID","Waterbody ID","STU Progress","Progress Date","Consultant","STU Type","STU Soil Type","STU Storage Volume (cuft)","Treatment Depth (inches)","Catchment Area (sqft)","RIDOT Catchment Area (sqft)","Impervious Area of STU catchment (sqft)","RIDOT Impervious Area of STU catchment (sqft)","TP Load (lb/year)","RIDOT TP Load (lb/year)","TP Removal (%)","TP Removal (lb/year)","RIDOT TP Removal (lb/year)","TN Load (lb/year)","RIDOT TN Load (lb/year)","TN Removal (%)","TN Removal (lb/year)","RIDOT TN Removal (lb/year)","TSS Load (lb/year)","RIDOT TSS Load (lb/year)","TSS Removal (%)","TSS Removal (lb/year)","RIDOT TSS Removal (lb/year)","Zinc Load (lb/year)","RIDOT ZN Load (lb/year)","Zinc Removal (%)","Zinc Removal (lb/year)","RIDOT ZN Removal (lb/year)","Effective IC Reduction (acres)","RIDOT Effective IC Reduction (acres)","IC Removal (%)","Runoff Reduction (acft)","Runoff Factor","Flow Factor","TP Factor","TSS Factor","Cost","Cost per Acre IC","Cost per Lb Phosphorus","SCP Priority","Latitude","Longitude","Notes"]
[{"$f":"IF(B3=\"\",\"\",VLOOKUP(B3,Tables!$A$37:$J$44,9))","v":""},{"$f":"IF(Tables!A18=\"\",\"\",Tables!A18)","v":""},null,null,{"$f":"IF(B3=\"\",\"\",VLOOKUP(B3,Tables!$A$18:$J$25,2))","v":""},null,null,{"$f":"IF(B3=\"\",\"\",'General Project Information'!$D$17)","v":""},{"$f":"IF(B3=\"\",\"\",VLOOKUP(B3,Tables!$A$18:$J$25,3))","v":""},{"$f":"IF(B3=\"\",\"\",Soiltype(A3))","v":""},{"$f":"IF(B3=\"\",\"\",VLOOKUP(B3,Tables!$A$18:$J$25,8))","v":""},{"$f":"IF(B3=\"\",\"\",VLOOKUP(B3,Tables!$A$18:$J$25,9))","v":""},{"$f":"IF(B3=\"\",\"\",SUM(VLOOKUP(B3,Tables!$A$18:$J$25,5),VLOOKUP(B3,Tables!$A$18:$J$25,6)))","v":""},null,{"$f":"IF(B3=\"\",\"\",VLOOKUP(B3,Tables!$A$18:$J$25,5))","v":""}]
[{"$f":"IF(B4=\"\",\"\",VLOOKUP(B4,Tables!$A$37:$J$44,9))","v":""},{"$f":"IF(Tables!A19=\"\",\"\",Tables!A19)","v":""},null,null,{"$f":"IF(B4=\"\",\"\",VLOOKUP(B4,Tables!$A$18:$J$25,2))","v":""},null,null,{"$f":"IF(B4=\"\",\"\",'General Project Information'!$D$17)","v":""},{"$f":"IF(B4=\"\",\"\",VLOOKUP(B4,Tables!$A$18:$J$25,3))","v":""},{"$f":"IF(B4=\"\",\"\",Soiltype(A4))","v":""},{"$f":"IF(B4=\"\",\"\",VLOOKUP(B4,Tables!$A$18:$J$25,8))","v":""},{"$f":"IF(B4=\"\",\"\",VLOOKUP(B4,Tables!$A$18:$J$25,9))","v":""},{"$f":"IF(B4=\"\",\"\",SUM(VLOOKUP(B4,Tables!$A$18:$J$25,5),VLOOKUP(B4,Tables!$A$18:$J$25,6)))","v":""},null,{"$f":"IF(B4=\"\",\"\",VLOOKUP(B4,Tables!$A$18:$J$25,5))","v":""}]
[{"$f":"IF(B5=\"\",\"\",VLOOKUP(B5,Tables!$A$37:$J$44,9))","v":""},{"$f":"IF(Tables!A20=\"\",\"\",Tables!A20)","v":""},null,null,{"$f":"IF(B5=\"\",\"\",VLOOKUP(B5,Tables!$A$18:$J$25,2))","v":""},null,null,{"$f":"IF(B5=\"\",\"\",'General Project Information'!$D$17)","v":""},{"$f":"IF(B5=\"\",\"\",VLOOKUP(B5,Tables!$A$18:$J$25,3))","v":""},"",{"$f":"IF(B5=\"\",\"\",VLOOKUP(B5,Tables!$A$18:$J$25,8))","v":""},{"$f":"IF(B5=\"\",\"\",VLOOKUP(B5,Tables!$A$18:$J$25,9))","v":""},{"$f":"IF(B5=\"\",\"\",SUM(VLOOKUP(B5,Tables!$A$18:$J$25,5),VLOOKUP(B5,Tables!$A$18:$J$25,6)))","v":""},null,{"$f":"IF(B5=\"\",\"\",VLOOKUP(B5,Tables!$A$18:$J$25,5))","v":""}]
[{"$f":"IF(B6=\"\",\"\",VLOOKUP(B6,Tables!$A$37:$J$44,9))","v":""},{"$f":"IF(Tables!A21=\"\",\"\",Tables!A21)","v":""},null,null,{"$f":"IF(B6=\"\",\"\",VLOOKUP(B6,Tables!$A$18:$J$25,2))","v":""},null,null,{"$f":"IF(B6=\"\",\"\",'General Project Information'!$D$17)","v":""},{"$f":"IF(B6=\"\",\"\",VLOOKUP(B6,Tables!$A$18:$J$25,3))","v":""},"",{"$f":"IF(B6=\"\",\"\",VLOOKUP(B6,Tables!$A$18:$J$25,8))","v":""},{"$f":"IF(B6=\"\",\"\",VLOOKUP(B6,Tables!$A$18:$J$25,9))","v":""},{"$f":"IF(B6=\"\",\"\",SUM(VLOOKUP(B6,Tables!$A$18:$J$25,5),VLOOKUP(B6,Tables!$A$18:$J$25,6)))","v":""},null,{"$f":"IF(B6=\"\",\"\",VLOOKUP(B6,Tables!$A$18:$J$25,5))","v":""}]
[{"$f":"IF(B7=\"\",\"\",VLOOKUP(B7,Tables!$A$37:$J$44,9))","v":""},{"$f":"IF(Tables!A22=\"\",\"\",Tables!A22)","v":""},null,null,{"$f":"IF(B7=\"\",\"\",VLOOKUP(B7,Tables!$A$18:$J$25,2))","v":""},null,null,{"$f":"IF(B7=\"\",\"\",'General Project Information'!$D$17)","v":""},{"$f":"IF(B7=\"\",\"\",VLOOKUP(B7,Tables!$A$18:$J$25,3))","v":""},"",{"$f":"IF(B7=\"\",\"\",VLOOKUP(B7,Tables!$A$18:$J$25,8))","v":""},{"$f":"IF(B7=\"\",\"\",VLOOKUP(B7,Tables!$A$18:$J$25,9))","v":""},{"$f":"IF(B7=\"\",\"\",SUM(VLOOKUP(B7,Tables!$A$18:$J$25,5),VLOOKUP(B7,Tables!$A$18:$J$25,6)))","v":""},null,{"$f":"IF(B7=\"\",\"\",VLOOKUP(B7,Tables!$A$18:$J$25,5))","v":""}]
[{"$f":"IF(B8=\"\",\"\",VLOOKUP(B8,Tables!$A$37:$J$44,9))","v":""},{"$f":"IF(Tables!A23=\"\",\"\",Tables!A23)","v":""},null,null,{"$f":"IF(B8=\"\",\"\",VLOOKUP(B8,Tables!$A$18:$J$25,2))","v":""},null,null,{"$f":"IF(B8=\"\",\"\",'General Project Information'!$D$17)","v":""},{"$f":"IF(B8=\"\",\"\",VLOOKUP(B8,Tables!$A$18:$J$25,3))","v":""},"",{"$f":"IF(B8=\"\",\"\",VLOOKUP(B8,Tables!$A$18:$J$25,8))","v":""},{"$f":"IF(B8=\"\",\"\",VLOOKUP(B8,Tables!$A$18:$J$25,9))","v":""},{"$f":"IF(B8=\"\",\"\",SUM(VLOOKUP(B8,Tables!$A$18:$J$25,5),VLOOKUP(B8,Tables!$A$18:$J$25,6)))","v":""},null,{"$f":"IF(B8=\"\",\"\",VLOOKUP(B8,Tables!$A$18:$J$25,5))","v":""}]
[{"$f":"IF(B9=\"\",\"\",VLOOKUP(B9,Tables!$A$37:$J$44,9))","v":""},{"$f":"IF(Tables!A24=\"\",\"\",Tables!A24)","v":""},null,null,{"$f":"IF(B9=\"\",\"\",VLOOKUP(B9,Tables!$A$18:$J$25,2))","v":""},null,null,{"$f":"IF(B9=\"\",\"\",'General Project Information'!$D$17)","v":""},{"$f":"IF(B9=\"\",\"\",VLOOKUP(B9,Tables!$A$18:$J$25,3))","v":""},"",{"$f":"IF(B9=\"\",\"\",VLOOKUP(B9,Tables!$A$18:$J$25,8))","v":""},{"$f":"IF(B9=\"\",\"\",VLOOKUP(B9,Tables!$A$18:$J$25,9))","v":""},{"$f":"IF(B9=\"\",\"\",SUM(VLOOKUP(B9,Tables!$A$18:$J$25,5),VLOOKUP(B9,Tables!$A$18:$J$25,6)))","v":""},null,{"$f":"IF(B9=\"\",\"\",VLOOKUP(B9,Tables!$A$18:$J$25,5))","v":""}]
[{"$f":"IF(B10=\"\",\"\",VLOOKUP(B10,Tables!$A$37:$J$44,9))","v":""},{"$f":"IF(Tables!A25=\"\",\"\",Tables!A25)","v":""},null,null,{"$f":"IF(B10=\"\",\"\",VLOOKUP(B10,Tables!$A$18:$J$25,2))","v":""},null,null,{"$f":"IF(B10=\"\",\"\",'General Project Information'!$D$17)","v":""},{"$f":"IF(B10=\"\",\"\",VLOOKUP(B10,Tables!$A$18:$J$25,3))","v":""},"",{"$f":"IF(B10=\"\",\"\",VLOOKUP(B10,Tables!$A$18:$J$25,8))","v":""},{"$f":"IF(B10=\"\",\"\",VLOOKUP(B10,Tables!$A$18:$J$25,9))","v":""},{"$f":"IF(B10=\"\",\"\",SUM(VLOOKUP(B10,Tables!$A$18:$J$25,5),VLOOKUP(B10,Tables!$A$18:$J$25,6)))","v":""},null,{"$f":"IF(B10=\"\",\"\",VLOOKUP(B10,Tables!$A$18:$J$25,5))","v":""}]
[{"$f":"IF(B11=\"\",\"\",VLOOKUP(B11,Tables!$A$37:$J$44,9))","v":""},{"$f":"IF(Tables!A26=\"\",\"\",Tables!A26)","v":""},null,null,{"$f":"IF(B11=\"\",\"\",VLOOKUP(B11,Tables!$A$18:$J$25,2))","v":""},null,null,{"$f":"IF(B11=\"\",\"\",'General Project Information'!$D$17)","v":""},{"$f":"IF(B11=\"\",\"\",VLOOKUP(B11,Tables!$A$18:$J$25,3))","v":""},"",{"$f":"IF(B11=\"\",\"\",VLOOKUP(B11,Tables!$A$18:$J$25,8))","v":""},{"$f":"IF(B11=\"\",\"\",VLOOKUP(B11,Tables!$A$18:$J$25,9))","v":""},{"$f":"IF(B11=\"\",\"\",SUM(VLOOKUP(B11,Tables!$A$18:$J$25,5),VLOOKUP(B11,Tables!$A$18:$J$25,6)))","v":""},null,{"$f":"IF(B11=\"\",\"\",VLOOKUP(B11,Tables!$A$18:$J$25,5))","v":""}]
[]
[null,"Updated: July 22, 2019"]

{"sheet":"Version Notes","index":10,"n_rows":3,"n_cols":3,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["Version Notes - RIDOT USE ONLY"]
["Date","Updated By","Update"]
["2019-07-22","VHB ","-added tab for the OSM review checklist (Review Checklist).  Adjusted formatting (i.e., merged cells) on other tabs to allow this tab to auto-populate upfront project information.  \n-added tab for RIDOT STU History (pulls information from the Tables tab in the format matching the STU GIS layer so that the data can be easily loaded from this spreadsheet into GIS).\n-updated pick list for BMP Type to match the STU GIS layer domain. \n-added WBID to Table 5-2 (Tables tab)."]