{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Instructions","Project List","Discipline Code - Description","Discipline Code - Data Vali."],"not_rendered":{"charts":0,"images":4,"macros":0,"external_links":0,"defined_names":1,"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":2,"n_cols":2,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
[]
[null,"The Project List tab in this workbook contains a select list of current and past advertisements for projects managed by the NCDOT Hydraulics Unit.  The Advertisement Status column indicates whether Letters of Interest from private engineering firms are currently being accepted.  If the advertisement is open and your firm is interested in responding then please download the Letter of Interest form from the Hydraulics Unit Connect site, fill out the form, and email it to the Hydraulics Unit Staff Contact person listed for the particular project. For reference the Discipline Code- Description tab contains a list of prequalifcation codes relevant to the Hydraulics Unit.  NOTE:  In order to submit a Letter of Interest your firm must have a current on-call contract with the Hydraulics Unit and be prequalified under the prequalification code listed for the project of interest."]

{"sheet":"Project List","index":1,"n_rows":11,"n_cols":10,"rows_kept":11,"cut":false,"hidden":false,"merged":[[0,0,0,9]]}
[]
["Advertisement\nStatus","Project\nTitle","Project\nDescription","Outline of Anticipated\nMajor Tasks","Description of\nDeliverables","Approximate\nStart Date","Approximate\nEnd Date","Hydraulics Unit\nStaff Contact","Applicable Hydraulics Prequalification Code(s) ","Letter of Interest\nDue Date "]
[]
["Open - Accepting Letters of Interest","Stormwater BMP Retrofit Feasibility Assessment","The Hydraulics Unit in partnership with the Town of Cary are interested in assessing the feasibility of constructing a stormwater treatment device on Town owned property at 1119 Evans Rd, Cary, NC 27513.  If feasible, the ultimate project objective is to design and construct a stormwater control measure to treat runoff from Evans Rd which is part of the state maintained network designated as SR 1653.\n\nIn addition to the site described above the Hydraulics Unit is evaluating up to four additional sites in the piedmont area potentially in need of further investigation which may be added to the scope of work.","Anticipated major tasks will be refined during scope development and may include:\n\n1)  Confirm property, ROW, riparian buffer, and drainage area boundaries.\n\n2)  Locate utilities.\n\n3)  Preliminary geotechnical investigations.\n\n4)  Preliminary survey data of key site features.\n\n5)  Assessment of project construction and permanent access, potential staging areas, and other constraints that may impact constructability and long term maintenance.\n\n6)  Assessment of potential retrofit stormwater control measure types that may be suitable for the site.\n\n7)  Preparation of a draft and final report of findings and recommendations.","A written report summarizing the findings of the feasibility assessment and subsequent recommendations along with supporting data.","2022-12-01","2022-03-31","Ryan Mullins, PE\nAndy McDaniel, PE","555 - NPDES Stormwater Program - BMP Retrofit Site Selection and Design","2022-11-04"]
["Closed","Project Management Services for the Highway Stormwater Program","The Hydraulics Unit is seeking a Project Manager to assist in managing and implementing the BMP Retrofit Program.  The Project Manager will serve as the primary point of contact for the Unit, however it is reasonable to expect additional firm staff assisting the Project Manager with tasks.  The Project Manager will be assigned an NCDOT email address but is not required to be stationed at the Century Center.\n\nThe Highway Stormwater Program manages a variety of initiatives designed to comply with the Department's statewide NPDES stormwater permit.  More information on the Program can be found here:  https://connect.ncdot.gov/resources/hydro/Pages/Highway-Stormwater-Program.aspx","Anticipated major tasks will vary over time but the Project Manager can expect to provide support in the following areas:\n\n1)  Assist in the management and implementation of the Retrofit Opportunity Site Selection (ROSS) program.  The objective of the ROSS program is to populate a geodatabase of field verified retrofit opportunities across the state using a combination of desktop and field screening procedures developed by the Hydraulics Unit.  The Project Manager may be involved in performing such procedure and/or managing the performance of other PEFs implementing the ROSS program.\n\n2)  Assist the Retrofit Program Manager in various project development tasks such as selecting retrofit opportunities to move forward with, securing concurrance from the Divisions, preparing project schedules, coordinate NEPA compliance, prepare scopes of work for design, and review deliverables.  Some in-house retrofit BMP design coordination may be expected.\n\n3)  Coordinate with the Divisions in support of the Division LET process, attend pre-bid meetings, attend pre-construction meetings with the contractor, monitor construction progress and coordinate with the NCDOT inspector, perform a final walk-through of the project and document lessons learned.\n\n4)  Assist the Retrofit Program Manager in performing a Lean Six Sigma analysis of the program and identify ways to improve the program's efficiency.  \n\n5)  The Project Manager may be asked to assist with implemention of other Highway Stormwater Programs including to the Research Program, Outfall Inventory Program, BMP Toolbox Program, Post-Construction Stormwater Program, and various training and educational programs.","Variable by task.","2022-07-01","2023-06-30","Ryan Mullins, PE\nAndy McDaniel, PE","555 - NPDES Stormwater Program - BMP Retrofit Site Selection and Design","2022-05-20"]
["Closed","Embedded Staff Augmentation for the Highway Stormwater Program","The Highway Stormwater Program manages a variety of initiatives designed to comply with the Department's statewide NPDES stormwater permit.  More information on the Program can be found here:  https://connect.ncdot.gov/resources/hydro/Pages/Highway-Stormwater-Program.aspx\n\nThe Hydraulics Unit is seeking a professional engineer with approximately 3-5 years of experience in the disciplines of hydraulics and transportation to assist in primarily managing and implementing the BMP Retrofit Program.  The embedded engineer may also assist with delivery of other Highway Stormwater Programs.  The embedded engineer will be stationed at the Century Center for 32 hours per week and work under the direction of the Retrofit Program Manager and the Highway Stormwater Program manager.  This project will be piloted for a six month period after which it may conclude or be extended.\n\nThe selection process may include an interview with the proposed embedded engineer.","Anticipated major tasks will vary over time but the embedded engineer can expect to provide support in the following areas:\n\n1)  Assist in the management and implementation of the Retrofit Opportunity Site Selection (ROSS) program.  The objective of the ROSS program is to populate a geodatabase of field verified retrofit opportunities across the state using a combination of desktop and field screening procedures developed by the Hydraulics Unit.  The embedded engineer may be involved in performing such procedure and/or managing the performance of other PEFs implementing the ROSS program.\n\n2)  Assist the Retrofit Program Manager in various project development tasks such as selecting retrofit opportunities to move forward with, securing concurrance from the Divisions, preparing project schedules, coordinate NEPA compliance, prepare scopes of work for design, and review deliverables.  Some in-house retrofit BMP design coordination may be expected.\n\n3)  Coordinate with the Divisions in support of the Division LET process, attend pre-bid meetings, attend pre-construction meetings with the contractor, monitor construction progress and coordinate with the NCDOT inspector, perform a final walk-through of the project and document lessons learned.\n\n4)  Assist the Retrofit Program Manager in performing a Lean Six Sigma analysis of the program and identify ways to improve the program's efficiency.  \n\n5)  The embedded engineer may be asked to assist with implemention of other Highway Stormwater Programs including to the Research Program, Outfall Inventory Program, BMP Toolbox Program, Post-Construction Stormwater Program, and various training and educational programs.","Variable by task.","10/1/2021","4/1/2022","Ryan Mullins, PE\nAndy McDaniel, PE","555 - NPDES Stormwater Program - BMP Retrofit Site Selection and Design","8/13/2021"]
["Closed","Complete 540 - LID Policy Research and BMP Toolbox Manual Update","In August 2019 NCDOT entered into a settlement agreement with plaintiffs over the Triangle Expressway Southeast Extension project also known as Complete 540.  A copy of the settlement agreement is available at:  https://www.ncdot.gov/projects/complete-540/Pages/project-documents.aspx\nThis advertisement is intended to address only the committments made in settlement item #7.  \nThe project will be scoped in three parts with Part I focusing on researching peer states’ use of LID guidelines and regulations and preparing a summary report of findings.  \n\nPart II of the project will be informed by the Part I research findings and focus on enhancing NCDOT’s BMP Toolbox Manual to include additional practices which yield LID benefits.  \n\nPart III will involve the preparation of training materials describing the updated BMP Toolbox manual.","Part I:  Conduct research on peer states’ use of LID guidelines and regulations.  For this project ‘peer states’ will be defined as other state DOTs, other state regulatory agencies (including NCDEQ), and select federal agencies such as the USEPA, FHWA, and the US Army Corps of Engineers.  The research will identify the various ways LID is defined with particular distinction being made between ‘design philosophy’ versus ‘stormwater treatment standard’.  The research will summarize any LID-related regulatory requirements applicable to state DOTs, as well as identify best management practices considered as LID practices appropriate for the linear environment.  The research findings will be documented in a report.\n\nPart II:  The Department’s last update to the BMP Toolbox was in 2014, thus initial tasks will involve reviewing the existing BMP Toolbox chapters and recommending any appropriate updates to the current content.  Over the past few years, the Hydraulics Unit has been planning its next update to the Toolbox and has already identified additional practices which may achieve LID benefits including promoting infiltration or otherwise extending the runoff hydrograph.  Informed by the Part I research and the Unit's planned updates, additional tasks involve identifying BMPs not currently described in the 2014 addition of the Toolbox and prepare new Toolbox manual chapters descibing these BMPs.  It is anticipated that the new chapters will have a similar 'look and feel', as well as content type as the current Toolbox manual.  \n\nPart III:  Prepare training materials describing the updated BMP Toolbox manual.  The training may involve in-person or virtual training targetting Hydraulics Unit staff.  Additional materials may involve hardcopy and/or recorded video based training which could be posted to the Department's Learning Management System in the form of one or more courses. ","1.  Draft and final peer state LID research findings (Part I)\n2.  Draft and final revisions to the content of the 2014 edition of the BMP Toolbox.  Content reviews may include updates to general descriptions, technical specifications, photographs, illustrations, etc. (Part II)\n3.  Draft and final new Toolbox manual chapters (Part II)\n4.  Draft and final training materials (specifics TBD) along with an in-person or virtual training session for Hydraulics Unit staff (Part III)","2021-03-01","2022-03-01","Brian Lipscomp, PE\nAndy McDaniel, PE","434 - Tier II Complete Hydrologic and Hydraulic Design, 555 - NPDES Stormwater Program - BMP Retrofit Site Selection and Design","2021-01-15"]
["Closed","Complete 540 - Hydrologic and Pollutant Load Modeling","In August 2019 NCDOT entered into a settlement agreement with plaintiffs over the Triangle Expressway Southeast Extension project also known as Complete 540.  A copy of the settlement agreement is available at:  https://www.ncdot.gov/projects/complete-540/Pages/project-documents.aspx\nThis advertisement is intended to address only the modeling committments made in settlement item #6.  This advertisement does NOT involve the design and construction of additional stormwater control measures also described in settlement item #6.  The Hydraulics Unit is requesting letters of interest which includes a high level description of hydrologic modeling approaches the firm might consider for modeling pre and post construction peak flows and discharge volume based on design plans for R-2721 and R-2828 (two sections of Complete 540).  The letter of interest should also include the firm's thoughts on approprate geographic scales for this modeling.  Additionally, approaches for modeling the full pre and post runoff hydrograph for three select drainage areas in the Complete 540 project vicinity as described in settlement item #6.  The Hydraulics Unit also requests that the letter of interest contain the firm's high level thoughts on appropriate pollutant load modeling approaches and geographic scale as described in settlement item #6.","Task 1:  Develop a White Paper outlining the pros and cons of various hydrologic modeling approaches for simulating pre and post construction peak flow and total runoff volume for R-2721 and R-2828.  The White Paper will also evaluate modeling approaches for simulating the pre and post construction runoff hydrograph for three select drainage areas.  This white paper will serve as the basis for model selection as well as a future staff training resource.\nTask 2:  Using the selected models perform the modeling work and calculate NCDOT's financial stormwater control measure retrofit committment as described in settlement item #6.\nTask 3:  Prepare a Report of Findings on the pre and post construction modeling of R-2721 and R-2828.\nTask 4:  Prepare a Report of Findings on the hydrograph modeling and runoff volume and peak flow modeling for the three selected drainage areas as described in settlement item #6.\nTask 5:  Prepare recommendations for appropriate pollutant load modeling approaches for R-2721 and R-2828.  The modeling approaches should be able to address the parameters of concern listed in settlement item #6.  Perform the pre and post construction pollutant load modeling.\nTask 6:  Prepare a Report of Findings on the pollutant load modeling.\nTask 7:  Give a presentation to select NCDOT and Hydraulics Unit staff on the modeling work performed and associated findings.  If deemed appropriate by NCDOT, give a presentation of findings to the plaintiffs.\n","1.  Meeting minutes from all meetings with NCDOT held during the project's progress.\n2.  Draft and Final White Paper describing modeling methods for determining runoff volume discharge volume, peak flow, hydrograph simulation.\n3.  Draft and Final Report of Findings of pre and post construction runoff volume and peak flow modeling of R-2721 and R-2828.\n4.  Draft and Final Report of Findings on the pollutant load modeling.\n5.  Draft and Final Report of Findings of pre and post construction modeling of three selected drainage areas.\n6.  Presentation of findings to select NCDOT and Hydraulics Unit staff.\n7.  If deemed appropriate by NCDOT, presentation of findings to the plaintiffs.","12/14/2020","2021-12-14","Andy McDaniel, PE\nRyan Mullins, PE","434 - Tier II Complete Hydrologic and Hydraulic Design, 554 - NPDES Stormwater Program - Water Quality Modeling Support and TMDL Compliance","2020-11-06"]
["Closed","Review and Update of Procedures and Guidance Documents","NCDOT is undertaking an Integrated Project Delivery (IPD) initiative to improve its preconstruction project development workflows.  In support of this initiative the Hydraulics Unit intends to review and update, where appropriate, its various procedures and guidance documents associated with drainage studies, hydraulic design, the Highway Floodplain Program, and the Highway Stormwater Program.  The Hydraulics Unit is seeking one or more private engineering firms (PEF) to assist in the review, update, and transformation of business critical information into \"living documents\" compatible with the latest information technologies.  Major goals of the project include, but are not limited to, identifying any policies and procedures which are inconsistent with updated IPD workflows; develop context-sensitive indexing to facilitate the end user to efficiently locate and access necessary information for a given hydraulics related task; update guidance to reflect the state-of-the-practice; and address any needed corrections or inadequacies with the current guidance that have been logged since the 2016 guidelines were published. ","Specific tasks will be assigned by the Hydraulics Unit project manager.  Example tasks might include:\nTask 1:  Review available recommendations from the IPD Team, the Hydraulics Unit Data Management Plan (under development), and the Hydraulics Unit Strategic Plan (under development).  Review list of comments and issues in the 2016 Guidelines discussion log and make recommendations regarding any inadquacies or corrections which need to be addressed.  Consult with the State Hydraulics Engineer and select unit staff to identify the goals and objectives for the project.  Compile these goals and objectives into a written project plan which defines specific deliverables, PEF and Unit team members for a given deliverable, and associated schedules.\nTask 2:  Execute the project plan which is expected to be phased to coincide with known near term objectives and additional objectives which emerge from recommendations being prepared by the various initiatives under development and mentioned above.  These objectives will likely include an assessment of the Unit's various policies, procedures, guidelines, forms, and checklists to determine its continued relevance and purpose into the future.  Relevant items will be updated as appropriate, and if necessary, be transformed into a format to most effectively deliver the content to the end user.  Such formats may include web pages, geodatabases, MicroStation files, electronic forms of various formats, etc.\nTask 3: Provide training for Hydraulics staff and end users to update on changes made to guidance and how best to utilize with IPD workflows.  Format of training may be in brief online video modules, classroom setting, printed materials, or other means as deemed appropriate.\nTask 4:  Provide GIS support to NCDOT's Project Atlas Team related to the Unit's geospatial data.","Specific deliverables will be defined by the project plan.","7/1/2019","2020-12-01","Jerry Snead, PE","434 - Tier II Complete Hydrologic and Hydraulic Design","6/7/2019"]
["Closed","NPDES Retrofit Program Management Support","NCDOT is required by its NPDES stormwater permit to build an average of 14 BMP retrofits per year across the state.  Additionally, NCDOT is required to build six (6) BMP retrofits per year to comply with the Falls Lake Nutrient Management Strategy regulations for existing development.  The Hydraulics Unit is seeking a private engineering firm (PEF) to assist the NCDOT Retrofit Program Manager in the day to day operations of managing the program.  Although the Retrofit Program is a permenant ongoing program this project will be time limited for a period of approximately one year.  This project will not require an embedded employee however frequent in-person coordination meetings between the PEF and the Retrofit Program Manager is expected. ","Specific tasks will be assigned by the Retrofit Program Manager.  Example tasks might include:\nTask 1:  Assist in the development of program management infrastructure and process improvement initiatives designed to improve project tracking processes and dashboards.  Expertise in Microsoft Project and Office 365 apps (e.g. SharePoint, etc) prefered.\nTask 2:  Upon its completion, assist in managing implementation of the retrofit site selection tracking system (see the Closed project advertisement below for additional information on this system).  This task includes assisting in the managment of other PEFs performing desktop and field site selection work.\nTask 3:  Assist in establishing schedules for individual retrofit projects and coordination with various NCDOT staff statewide depending on project location.\nTask 4:  Assist with retrofit project development and design phases.  Responsibilities include, but are not limited to, coordination with the PEF design team, reviewing engineering drawings, coordinate attainment of the Categorical Exclusion and any needed permits, ROW certification, and cultural resources review (if needed).\nTask 5:  Assist with various pre-construction, construction, and post-construction activities including participating in any pre-construction meetings with the Division and Contractor, periodic construction observation visits and coordination with the NCDOT construction inspector, coordinating final walk-through and punch list items, and integration of any lessions learned into process improvement inititatives.\nTask 6:  Development of training materials for NCDOT staff, PEFs, and contractors as reqeusted by the Retrofit Program Manager.","1.  Biweekly status reports as requested by the Retrofit Program Manager\n2.  Program documentation to support Integrated Project Delivery and project tracking\n3.  Development and maintenance of Microsoft Project files for retrofit projects\n4.  Develoment of dashboards for improved project tracking\n5.  Various reports, plan review markups, meeting minutes, PowerPoint presentations, etc consistent with the execution of the anticipated major tasks for this project","2019-05-01","2020-05-01","Andy McDaniel, PE                                                    Joe Dunnehoo, PE","555 - NPDES Stormwater Program - BMP Retrofit Site Selection and Design","2019-03-22"]
["Closed","Retrofit Site Selection Tracking System Development","NCDOT is required by its NPDES stormwater permit to build an average of 14 BMP retrofits per year across the state.  Ultimately the Hydraulics Unit would like to build an inventory of field verified retrofit opportunities such that site selection is no longer on the critical path for retrofit project delivery.  The objective of this project is to develop the GIS-based IT framework and associated workflows which will be used to collect, store, review, and display infomation about potential retrofit sites across the state using ArcGIS, AGOL, Survey123 and/or Esri Collector.  To clarify this project is NOT anticipated to include any significant amount of field work to locate retrofit sites.","Task 1:  Develop a GeoDatabase schema designed to store various attributes about potential stormwater BMP retrofit opportunities.\nTask 2:  Using available GIS data, perform a statewide desktop analysis using ArcGIS to develop a Retrofit Investigation Areas (RIAs) data layer.                                                                                                 \nTask 3:  Create a Survey123 or Collector field assessment form for retrofit site selection data collection using mobile devices.\nTask 4:  Coordinate with NCDOT GIS Unit to transfer GIS deliverables over to NCDOT/NCDIT, and upload to AGOL.\nTask 5:  Develop a retrofit site selection workflow to be managed by NCDOT and implemented in the future by private engineering firms (via separate projects) using the tools developed under this project.","1.  GeoDatabase for storing and retrieving retrofit site information.\n2.  Statewide GeoDatabase layer of Retrofit Investigation Areas.\n3.  Survey123 and/or Collector Application linked to the retrofit site GeoDatabase.\n4.  A report(s) describing the tools, geoDatabases, and workflows necessary to implement an NPDES retrofit site selection program.","2019-01-14","2019-03-25","Andy McDaniel, PE                                                    Ryan M. Mullins, PE","481 - NPDES Stormwater Permit Programmatic Support","2018-12-07"]

{"sheet":"Discipline Code - Description","index":2,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Title","Discipline","Work_Code","Description"]
["Tier I Basic H&H","Tier I Basic Hydrologic and Hydraulic Design",433,"a) Roadway drainage design, including ditches, small pipe culverts, storm sewer systems, outfall analysis, drainage investigations, etc.b) Bridge and/or culvert design over streams using the Federal Highway Administration (FHWA) design guidelines, such as Hydraulic Design Series 5, 7, HY-8, HEC-Ras, etc.c) Drainage design using the North Carolina Department of Transportation “Stormwater Best Management Practices Toolbox” or similar.","433 - Tier I Basic Hydrologic and Hydraulic Design"]
["Tier II Complete H&H","Tier II Complete Hydrologic and Hydraulic Design",434,"a) Tier I, plus:b) Design of bridges, culverts and roadway fill at FEMA regulated streams that require coordination and approvals from FEMA or their designees.c) Experience evaluating scour and stream instability using FHWA guidance such as HEC 18, HEC 20 and HEC 23.","434 - Tier II Complete Hydrologic and Hydraulic Design"]
["Tier III Complex H&H","Tier III Complex Hydraulic Design",479,"a) Tier I and II, plus:b) Two-dimensional (2D) hydraulic modeling design experience for bridges over streams that are under the influence of turbulent, unsteady flow, etc.","479 - Tier III Complex Hydraulic Design"]
["Floodplain Support","Highway Floodplain Program Support",480,"Extensive knowledge of the National Flood Insurance Program. Extensive experience in hydraulic model design and community flood map revision or creation for FEMA or a designee of FEMA. Experience reviewing hydraulic models for bridges and/or culverts over FEMA regulated streams.","480 - Highway Floodplain Program Support"]
["Stormwater Support","NPDES Stormwater Permit Programmatic Support",481,"Extensive knowledge of the USEPA's NPDES stormwater program and experience assisting MS4s in implementation of NPDES permit stormwater programs. Experience negotiating NPDES permit language with regulatory agencies, administering and overseeing the implementation of NPDES compliance programs, preparation of NPDES annual reports, preparation of fiscal year program business/work plans, designing and performing internal program self-assessment audits, managing water quality research projects, development of NPDES internal education programs for MS4 staff and contractors, and development of information technology solutions to support delivery of NPDES programs.","481 - NPDES Stormwater Permit Programmatic Support"]
["Coastal Hydraulic Engineering","Coastal Hydraulic Engineering",482,"Extensive knowledge and experience of coastal hydrodynamics and simulation models using RMA2 (Resource Management Associates), ADCIRC (Advanced Circulation Model for Coastal Ocean Hydrodynamics), SWAN (Simulation Waves Near Shore) software or similar state-of-the-art hydrodynamic modelling techniques for coastal resources.","482 - Coastal Hydraulic Engineering"]
["HSP Industrial","NPDES Stormwater Program - Industrial Facility Compliance and Asset Inventory",553,"a) Experience preparing stormwater pollution prevention plans (SPPPs) and spill prevention, control, and countermeasure (SPCC) plans for industrial facilities. Experience developing and delivering stormwater pollution prevention training for industrial facility staff.b) Experience with geospatial field mapping of industrial facility assets, stormwater conveyance systems and outfalls draining roadways and industrial facilities.c) Experience identifying waters of the US for the purposes of outfall identification and Clean Water Act compliance.","553 - NPDES Stormwater Program - Industrial Facility Compliance and Asset Inventory"]
["HSP Water Quality","NPDES Stormwater Program - Water Quality Modeling Support and TMDL Compliance",554,"Experience developing and applying water quality models to support regulatory compliance. Relevant experience includes the application of watershed and surface water models such as, but not limited to, HSPF, WASP, SWMM, EFDC, WARMF, SWAT, and SELDM. Review of model applications developed by third parties. Preparation of modeling reports and TMDL compliance plans.","554 - NPDES Stormwater Program - Water Quality Modeling Support and TMDL Compliance"]
["HSP BMP Retrofit","NPDES Stormwater Program - BMP Retrofit Site Selection and Design",555,"a) Experience locating potential retrofit sites using a combination of desktop and field evaluation techniques.b) Experience preparing BMP construction drawings, pollutant load calculations and management of databases for the storage, retrieval, and reporting of site assessment information.c) Experience with BMP construction engineering and inspection.","555 - NPDES Stormwater Program - BMP Retrofit Site Selection and Design"]

{"sheet":"Discipline Code - Data Vali.","index":3,"n_rows":11,"n_cols":1,"rows_kept":11,"cut":false,"hidden":true,"merged":[]}
[]
["Discipline Code and Description"]
["433 - Teir I Basic Hydrologic and Hydraulic Design"]
["434 - Tier II Complete Hydrologic and Hydraulic Design"]
["479 - Tier III Complex Hydraulic Design"]
["480 - Highway Floodplain Program Support"]
["481 - NPDES Stormwater Permit Programmatic Support"]
["482 - Coastal Hydraulic Engineering"]
["553 - NPDES Stormwater Program - Industrial Facility Compliance and Asset Inventory"]
["554 - NPDES Stormwater Program - Water Quality Modeling Support and TMDL Compliance"]
["555 - NPDES Stormwater Program - BMP Retrofit Site Selection and Design"]