{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Cover Page","General Information","Prelim. Major X Table","SITE DATA TEMPLATE","GIS Table","Deliverables Checklist","List References"],"not_rendered":{"charts":0,"images":32,"macros":1,"external_links":0,"defined_names":27,"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":"Cover Page","index":0,"n_rows":44,"n_cols":8,"rows_kept":44,"cut":false,"hidden":false,"merged":[[2,21,17,28],[20,4,20,6],[18,2,18,3],[2,3,4,10],[6,2,6,3],[12,2,13,3],[8,4,10,10],[8,2,9,3],[12,4,13,10],[43,4,43,8],[43,2,43,3],[20,2,20,3],[6,7,6,8],[6,9,6,10],[24,2,24,3],[15,2,16,3],[15,4,16,10],[34,2,34,3],[34,4,39,8],[41,2,41,3],[41,4,41,8],[22,2,22,3],[22,4,22,6],[24,4,32,6],[18,4,18,6]]}
[]
[]
[null,null,null,"NCDOT - HYDRAULIC PLANNING REPORT"]
[]
[]
[]
[null,null,"TIP/PROJECT NO.",null,null,null,null,"WBS ELEMENT NO."]
[]
[null,null,"PROJECT DESCRIPTION:"]
[]
[]
[]
[null,null,"PROPOSED RDWY TYPICAL:"]
[]
[]
[null,null,"EXISTING RDWY TYPICAL:"]
[]
[]
[null,null,"COUNTY:"]
[]
[null,null,"DIVISION:"]
[]
[null,null,"DESIGNER: ",null,null,null,null,"DATE:"]
[]
[null,null,"SEAL:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"PREPARED BY:",null,"COMPANY LOGO/INFO"]
[]
[]
[]
[]
[]
[]
[null,null,"PROJECT MANAGER:"]
[]
[null,null,"QA REVIEWED BY:"]

{"sheet":"General Information","index":1,"n_rows":67,"n_cols":44,"rows_kept":67,"cut":false,"hidden":false,"merged":[[11,2,26,13],[29,1,29,5],[31,2,32,13],[5,1,5,2],[5,5,6,9],[5,11,5,12],[9,1,9,6],[56,2,67,13],[33,2,36,13],[37,2,39,13],[41,1,41,5],[43,2,52,13],[54,1,54,5],[1,13,1,14],[2,1,2,2],[2,11,2,12],[4,1,4,2],[4,11,4,12],[3,1,3,2],[3,5,4,9],[3,11,3,12],[1,1,1,2],[1,11,1,12]]}
[]
[null,null,null,{"$f":"IF('Cover Page'!D4=\"\",\"\",'Cover Page'!D4)","v":""}]
[null,"PROJECT NUMBER:",null,{"$f":"IF('Cover Page'!E7=\"\",\"\",'Cover Page'!E7)","v":""},null,null,null,null,null,null,null,"DATE:"]
[null,"WBS ELEMENT #:",null,{"$f":"IF('Cover Page'!J7=\"\",\"\",'Cover Page'!J7)","v":""},null,"NCDOT - HPR",null,null,null,null,null,"DESIGN FIRM:",null,{"$f":"IF('Prelim. Major X Table'!N1=\"\",\"\",'Prelim. Major X Table'!N1)","v":""}]
[null,"COUNTY:",null,{"$f":"IF('Cover Page'!E19=\"\",\"\",'Cover Page'!E19)","v":""},null,null,null,null,null,null,null,"DESIGNED BY:",null,{"$f":"IF('Cover Page'!E23=\"\",\"\",'Cover Page'!E23)","v":""}]
[null,"DIVISION:",null,{"$f":"IF('Cover Page'!E21=\"\",\"\",'Cover Page'!E21)","v":""},null,"GENERAL INFORMATION",null,null,null,null,null,"REVIEWED BY:"]
[]
[]
[]
[null,"MISCELLANEOUS PROJECT INFORMATION"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"GREEN SHEET COMMITMENTS"]
[]
[null,null,"FEMA INVOLVEMENT?"]
[]
[null,null,"Hydraulics Unit commitment: The Hydraulics Unit will coordinate with the NC Floodplain Mapping Program (FMP) to determine status of project with regard to applicability of NCDOT’s Memorandum of Agreement, or approval of a Conditional Letter of Map Revision (CLOMR)* and subsequent final Letter of Map Revision (LOMR)."]
[]
[]
[]
[null,null,"Highway Division commitment: This project involves construction activities on or adjacent to FEMA-regulated stream(s). Therefore, the Division shall submit sealed As-built construction plans to the Hydraulics Unit upon completion of structure construction, certifying that the drainage structure(s) and roadway embankment that are located within the 100-year floodplain were built as shown in the construction plans, both horizontally and vertically. "]
[]
[]
[]
[null,"RISK IDENTIFICATION"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"yes"]
[]
[]
[null,"AVOIDANCE AND MINIMIZATION"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"yes"]

{"sheet":"Prelim. Major X Table","index":2,"n_rows":378,"n_cols":33,"rows_kept":378,"cut":false,"hidden":false,"merged":[[1,28,1,35],[9,18,10,18],[7,0,8,0],[7,1,8,1],[7,2,8,2],[7,3,8,3],[7,4,8,4],[1,4,3,10],[7,12,8,13],[9,12,9,13],[7,5,8,5],[7,6,8,6],[7,7,8,7],[7,8,8,8],[7,9,8,9]]}
["PROJECT NUMBER:",{"$f":"IF('Cover Page'!E7=\"\",\"\",'Cover Page'!E7)","v":""},null,null,null,null,null,null,null,null,null,null,"DATE:",{"$f":"IF('Cover Page'!I23=\"\",\"\",'Cover Page'!I23)","v":""}]
["WBS ELEMENT #: ",{"$f":"IF('Cover Page'!J7=\"\",\"\",'Cover Page'!J7)","v":""},null,null,"PRELIMINARY HYDRAULIC RECOMMENDATIONS FOR MAJOR CROSSINGS",null,null,null,null,null,null,null,"DESIGN FIRM:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COLUMNS BELOW HIDDEN FOR MACROS DO NOT EDIT"]
["COUNTY:",{"$f":"IF('Cover Page'!E19=\"\",\"\",'Cover Page'!E19)","v":""},null,null,null,null,null,null,null,null,null,null,"DESIGNED BY:"]
["DIVISION:",{"$f":"IF('Cover Page'!E21=\"\",\"\",'Cover Page'!E21)","v":""},null,null,null,null,null,null,null,null,null,null,"REVIEWED BY:"]
[]
[]
[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,"Lat Lookup For Selected Site",null,null,null,"Long Lookup For Selected Site"]
["SITE NUMBER","ALTERNATIVE ID (2)","ROUTE","STATION","LAT","LONG","STREAM/ WETLAND ID","STREAM NAME","FEMA STUDY TYPE","DRAINAGE AREA (Mi^2)","EXISTING STRUCTURE","MINIMUM RECOMMENDED STRUCTURE ","Notes",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(site_number_selection,A10:N200,5)","v":{"$error":"#N/A"}},null,null,null,{"$f":"VLOOKUP(site_number_selection,A10:N200,6)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,"Number, Size, Structure Type","Number, Size, Structure Type"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(A10<>\"\",ROW(A10),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,"Stream For Selected Site",null,null,null,"DA For Selected Site"]
[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,{"$f":"VLOOKUP(site_number_selection,A10:N200,8)","v":{"$error":"#N/A"}},null,null,null,{"$f":"VLOOKUP(site_number_selection,A10:N200,10)","v":{"$error":"#N/A"}}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(A201<>\"\",ROW(A201),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
["NOTES:"]
["(1) Major Crossings - conveyance greater than 30 square feet or more."]
["(2) Complete Table for all Roadway projects (Not necessary for Structure replacement projects)"]
["(3) Provided in planning document"]
["(4) Mark N/A for Site No. if no major drainage structures."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null," ",null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(A260<>\"\",ROW(A260),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(A324<>\"\",ROW(A324),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]

{"sheet":"SITE DATA TEMPLATE","index":3,"n_rows":626,"n_cols":19,"rows_kept":626,"cut":false,"hidden":true,"merged":[[2,16,2,21],[7,1,7,3],[9,8,9,9],[9,11,9,13],[11,1,11,2],[11,11,11,13],[13,3,14,13],[2,1,2,2],[2,11,2,12],[3,1,3,2],[3,11,3,12],[4,1,4,2],[4,11,4,12],[5,1,5,2],[5,11,5,12],[11,3,11,4],[2,6,3,8],[4,6,5,8],[26,3,26,13],[28,1,28,3],[13,18,13,19],[13,20,13,21],[13,25,13,26],[15,23,15,24],[16,1,16,2],[16,7,16,8],[16,9,16,10],[18,1,19,2],[18,3,20,13],[22,11,22,13],[24,3,24,13],[40,1,40,2],[40,11,40,13],[42,3,43,13],[49,8,49,9],[49,11,49,13],[51,1,51,2],[51,11,51,13],[47,1,47,3],[30,1,31,2],[30,3,31,13],[33,1,34,2],[33,3,34,13],[36,1,36,3],[38,8,38,9],[38,11,38,13],[64,1,65,2],[64,3,66,13],[70,3,70,4],[70,9,70,10],[73,2,73,13],[53,3,54,13],[60,3,60,4],[60,5,60,6],[60,7,60,9],[60,10,60,12],[62,3,62,4],[58,1,58,3],[62,7,62,9],[77,1,77,2],[81,1,81,2],[83,3,83,4],[85,3,85,4],[89,2,89,3],[89,8,89,13],[93,4,93,5],[108,1,108,3],[118,3,118,5],[76,6,77,8],[78,6,79,8],[120,1,124,2],[120,3,123,13],[130,1,130,2],[91,3,91,13],[93,2,93,3],[93,8,93,9],[93,10,93,12],[98,2,99,13],[95,1,95,6],[120,16,123,17],[120,18,123,18],[131,1,131,2],[131,5,132,9],[131,11,131,12],[1,13,1,14],[75,13,75,14],[76,1,76,2],[76,11,76,12],[130,11,130,12],[130,13,130,14],[75,11,75,12],[77,11,77,12],[78,1,78,2],[78,11,78,12],[1,1,1,2],[1,11,1,12],[101,1,101,4],[116,1,116,6],[79,1,79,2],[79,11,79,12],[75,1,75,2],[105,3,106,13],[110,2,114,13],[134,1,158,14],[159,1,159,2],[159,11,159,12],[159,13,159,14],[160,1,160,2],[160,5,161,9],[160,11,160,12],[130,18,132,18],[242,5,243,9],[242,11,242,12],[245,1,270,14],[271,1,296,14],[297,1,322,14],[323,1,323,2],[323,11,323,12],[323,13,323,14],[163,1,188,14],[189,1,214,14],[215,1,240,14],[241,1,241,2],[241,11,241,12],[241,13,241,14],[242,1,242,2],[405,13,405,14],[406,1,406,2],[406,5,407,9],[406,11,406,12],[324,1,324,2],[324,5,325,9],[324,11,324,12],[327,1,352,14],[353,1,378,14],[379,1,404,14],[405,1,405,2],[405,11,405,12],[573,1,598,14],[599,1,624,14],[625,1,650,14],[569,1,569,2],[569,11,569,12],[569,13,569,14],[570,1,570,2],[570,5,571,9],[570,11,570,12],[488,1,488,2],[488,5,489,9],[488,11,488,12],[491,1,516,14],[517,1,542,14],[543,1,568,14],[409,1,434,14],[435,1,460,14],[461,1,486,14],[487,1,487,2],[487,11,487,12],[487,13,487,14]]}
[]
[null,null,null,{"$f":"IF('Cover Page'!E5=\"\",\"\",'Cover Page'!E5)","v":""},null,null,null,null,null,null,null,null,null,"Page 1"]
[null,"PROJECT NUMBER:",null,{"$f":"IF('Cover Page'!E7=\"\",\"\",'Cover Page'!E7)","v":""},null,null,"NCDOT - HPR",null,null,null,null,"DATE:"]
[null,"WBS ELEMENT #:",null,{"$f":"IF('Cover Page'!J7=\"\",\"\",'Cover Page'!J7)","v":""},null,null,null,null,null,null,null,"DESIGN FIRM:",null,{"$f":"IF('Prelim. Major X Table'!N2=\"\",\"\",'Prelim. Major X Table'!N2)","v":""}]
[null,"COUNTY:",null,null,null,null,"SITE #",null,null,null,null,"DESIGNED BY:",null,{"$f":"IF('Cover Page'!E23=\"\",\"\",'Cover Page'!E23)","v":""}]
[null,"DIVISION:",null,null,null,null,null,null,null,null,null,"REVIEWED BY:"]
[]
[null,"EXISTING STRUCTURE"]
[]
[null,null,"Str. #:",null,"Latitude:",null,"Longitude:",null,{"$f":"HYPERLINK(\"http://maps.google.com/?q=\"&F10&\",\"&H10, \"Google Maps\")","v":"Google Maps"},null,"Stream:"]
[]
[null,"Structure Type:",null,null,null,"Yr Built:",null,"Skew:",null,null,"River Basin:"]
[]
[null,null,"Exist. Str. Info:"]
[]
[]
[null,"Bed to Crown (ft):",null,null,null,"Clear Roadway (ft):",null,"Water Depth (ft):",null,null,null,null,"OAL (ft):"]
[]
[null,"Existing Structure Notes:"]
[]
[]
[]
[null,null,"ADT:",null,"Year ADT:",null,null,"Scour Code(Item113):",null,null,"Prior Survey:"]
[]
[null,null," Flooding Info 1:"]
[]
[null,null,"Flooding Info 2:"]
[]
[null,"CHANNEL INFORMATION"]
[]
[null,"U/S Channel Condition:"]
[]
[]
[null,"D/S Channel Condition:"]
[]
[]
[null,"UPSTREAM FEATURE"]
[]
[null,null,"Str. #:",null,"Latitude:",null,"Longitude:",null,{"$f":"HYPERLINK(\"http://maps.google.com/?q=\"&F39&\",\"&H39, \"Google Maps\")","v":"Google Maps"},null,"Stream:"]
[]
[null,"U/S Feature:",null,null,"Yr Built:",null,"Skew:",null,null,null,"Route:"]
[]
[null,null,"U/S Feature Info:"]
[]
[]
[null,null,"Bed to Crown (ft):",null,null,"Clear Roadway (ft):",null,null,"Water Depth (ft):"]
[]
[null,"DOWNSTREAM FEATURE"]
[]
[null,null,"Str. #:",null,"Latitude:",null,"Longitude:",null,{"$f":"HYPERLINK(\"http://maps.google.com/?q=\"&F50&\",\"&H50, \"Google Maps\")","v":"Google Maps"},null,"Stream:"]
[]
[null,"D/S Feature:",null,null,"Yr Built:",null,"Skew:",null,null,null,"Route:"]
[]
[null,null,"D/S Feature Info:"]
[]
[]
[null,null,"Bed to Crown (ft):",null,null,"Clear Roadway (ft):",null,null,"Water Depth (ft):"]
[]
[null,"HYDROLOGY"]
[]
[null,null,"Drainage Area:",null,null,"Drainage Area Source:",null,null,null,null,"Future % Impervious:"]
[]
[null,null,"Discharge Method:",null,null,null,"USGS Hydrologic Region:",null,null,null,null,null,"Stream Gage # (if applicable):"]
[]
[null,"Future Land Use/Development:"]
[]
[]
[]
[null,null,"Proposed LOS:",null,null,"Existing LOS:",null,null,null,null,null,null,null,"Level of Service (LOS) where roadway is open and not overtopping."]
[]
[null,null,"Q Design (cfs):",null,null,"Design Yr.:",null,null,"Q100 (cfs):",null,null,null,"QBFE (cfs):"]
[]
[null,null,"Has a different LOS from standard LOS been considered and why?"]
[]
[]
[null,null,null,{"$f":"IF('Cover Page'!E82=\"\",\"\",'Cover Page'!E82)","v":""},null,null,null,null,null,null,null,null,null,"Page 2"]
[null,"PROJECT NUMBER:",null,{"$f":"IF('Cover Page'!E83=\"\",\"\",'Cover Page'!E83)","v":""},null,null,"NCDOT - HPR",null,null,null,null,"DATE:"]
[null,"WBS ELEMENT #:",null,{"$f":"IF('Cover Page'!J83=\"\",\"\",'Cover Page'!J83)","v":""},null,null,null,null,null,null,null,"DESIGN FIRM:",null,{"$f":"IF('Prelim. Major X Table'!N240=\"\",\"\",'Prelim. Major X Table'!N240)","v":""}]
[null,"COUNTY:",null,null,null,null,{"$f":"SITE_TITLE","v":"SITE #"},null,null,null,null,"DESIGNED BY:",null,{"$f":"IF('Cover Page'!E99=\"\",\"\",'Cover Page'!E99)","v":""}]
[null,"DIVISION:",null,null,null,null,null,null,null,null,null,"REVIEWED BY:"]
[]
[null,"FEMA "]
[]
[null,null,"Type of FIS:",null,null,null,"Date of FIS:",null,null,null,null,"Regulatory Floodway Width:",null,"(Noted in FIS)"]
[]
[null,null,"River Station:",null,null,null,"RDWY OT @ Q100?:",null,null,"Panel #:",null,null,"Panel Date:"]
[]
[null,null,null,"Damage Potential?:",null,null,null,null,null,null,null,"Could proposed structure significantly increase damages?:"]
[]
[null,null,"*Buildings in Floodplain?:",null,null,null,null,"Explanation of Increased Damages:"]
[]
[null,null,"List  Buildings in Flood Plain w/  Location & Floor Elev.:  "]
[]
[null,null,"CLOMR/SFC Estimate:"]
[]
[null,"HIGHWAY & BRIDGE/CULVERT RELATED EVALUATIONS"]
[]
[null,null,"Are there any outside features that might affect stage, discharge or frequency?:"]
[]
[]
[]
[null,"ONSITE DETOUR INFORMATION"]
[]
[null,null,"Structure Type:"]
[]
[null,null,"Detour Str. Info:"]
[]
[]
[null,"DESIGN CONCERNS"]
[]
[]
[]
[]
[]
[]
[]
[null,"PRELIMINARY STRUCTURE ESTIMATE [OFFICE ESTIMATE]"]
[]
[null,null,"Structure Type:",null,null,null,null,null,"Disclaimer - Please note if extending/widening/retaining"]
[]
[null,"Proposed Structure and any grade requirements",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NUMBER OF PHOTO PAGES BELOW (SELECT ZERO FOR NO PHOTO PAGES)",null,0]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,{"$f":"_xlfn.TEXTJOIN(\"\",TRUE,$G$5,\" - PHOTOS\")","v":"SITE # - PHOTOS"}]
[]
[]
[null,"Photo Description Here"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Page 3"]
[null,null,null,null,null,{"$f":"_xlfn.TEXTJOIN(\"\",TRUE,$G$5,\" - PHOTOS\")","v":"SITE # - PHOTOS"}]
[]
[]
[null,"Photo Description Here"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Photo Description Here"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Photo Description Here"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Page 4"]
[null,null,null,null,null,{"$f":"_xlfn.TEXTJOIN(\"\",TRUE,$G$5,\" - PHOTOS\")","v":"SITE # - PHOTOS"}]
[]
[]
[null,"Photo Description Here"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Photo Description Here"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Photo Description Here"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Page 5"]
[null,null,null,null,null,{"$f":"_xlfn.TEXTJOIN(\"\",TRUE,$G$5,\" - PHOTOS\")","v":"SITE # - PHOTOS"}]
[]
[]
[null,"Photo Description Here"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Photo Description Here"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Photo Description Here"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Page 6"]
[null,null,null,null,null,{"$f":"_xlfn.TEXTJOIN(\"\",TRUE,$G$5,\" - PHOTOS\")","v":"SITE # - PHOTOS"}]
[]
[]
[null,"Photo Description Here"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Photo Description Here"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Photo Description Here"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Page 7"]
[null,null,null,null,null,{"$f":"_xlfn.TEXTJOIN(\"\",TRUE,$G$5,\" - PHOTOS\")","v":"SITE # - PHOTOS"}]
[]
[]
[null,"Photo Description Here"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Photo Description Here"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Photo Description Here"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Page 8"]
[null,null,null,null,null,{"$f":"_xlfn.TEXTJOIN(\"\",TRUE,$G$5,\" - PHOTOS\")","v":"SITE # - PHOTOS"}]
[]
[]
[null,"Photo Description Here"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Photo Description Here"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Photo Description Here"]

{"sheet":"GIS Table","index":4,"n_rows":1,"n_cols":10,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
["Site Number","Longitude","Latitude","Route","Stream","Stream-Wetland ID","FEMA Study","Drainage Area","Existing Structure","River Basin"]

{"sheet":"Deliverables Checklist","index":5,"n_rows":40,"n_cols":4,"rows_kept":40,"cut":false,"hidden":false,"merged":[[3,1,3,3],[35,1,36,2],[37,1,37,2],[10,1,10,3],[0,0,0,3],[2,0,11,0],[2,1,2,3],[16,0,37,0],[16,1,18,2],[19,1,20,2],[21,1,21,2],[22,1,22,2],[24,1,26,2],[27,1,29,2],[30,1,30,2],[31,1,33,2],[13,0,14,0],[4,1,4,3],[5,1,5,3],[6,1,6,3],[9,1,9,3],[11,1,11,3],[7,1,7,3],[34,1,34,2],[13,1,13,3],[14,1,14,3],[23,1,23,2],[8,1,8,3]]}
["HPR - DELIVERABLES CHECKLIST"]
[]
["Hydraulic Planning Report (submitted as a single PDF, listed here in order of appearance)","Cover Page"]
[null,"General Information"]
[null,"Roadway Alignment & Site Map *"]
[null,"Preliminary Major Crossing Table"]
[null,"Site Data *"]
[null,"Preliminary Plan & Profile Sketch"]
[null,"FEMA Site Maps with Sites Labeled"]
[null,"Photos as Needed"]
[null,"Preliminary Hydroplaning Assessment (as needed)"]
[null,"Miscellaneous Data as agreed upon by the QA reviewer"]
[]
["Preliminary Stormwater Management Plan (submitted as a single PDF)","General Project Information"]
[null,"Waterbody Information"]
[]
["HPR Supplemental Data (submitted in a single document set)","1. Bridge Inspection Reports",null,"Existing Structure (PDF)"]
[null,null,null,"Up Stream Structure (PDF)"]
[null,null,null,"Down Stream Structure (PDF)"]
[null,"2. Site Calculations",null,"Hydrology (Rational, USGS-SIR 2014-5030) (PDF/Excel)"]
[null,null,null,"Stream Stats (PDF)"]
[null,"Tools for sizing major structures -",null,"HDS-5 (PDF)"]
[null,"(Use as needed)",null,"HY-8 Model (HY-8 and Computations PDF)"]
[null,null,null,"Preliminary HEC-RAS Model (Add proposed str. to model)"]
[null,"3. Field Work",null,"Site Photos (JPG/PDF)"]
[null,null,null,"Historical Flooding Information (PDF)"]
[null,null,null,"Plan & Profile Sketch W/ Str. Measurements (PDF)"]
[null,"4. FRIS DATA",null,"FIS Report (PDF) w/ site locations labelled"]
[null,null,null,"FEMA Site Maps with Sites Labeled (PDF)"]
[null,null,null,"FEMA Models (HEC-RAS Model & Cross Sections PDF)"]
[null,"5. Planning Info",null,"NRTR - If Available (PDF)"]
[null,"6. Microstation Files ",null,"RDWY Alignment & Site Map"]
[null,null,null,"Drainage Areas Delineated and labeled on USGS Quad Map "]
[null,null,null,"Preliminary Plan & Profile Sketch for Major Structures"]
[null,"7. HPR",null,"Hydraulics Planning Report (Excel File Version)"]
[null,"8. Mapping/Data (PDF)",null,"Future Urbanization Determination"]
[null,null,null,"RDWY Alignment & Site Map"]
[null,"9. Miscellaneous Data",null,"As agreed upon by the QA reviewer"]
[]
["* On-site Field Scoping Meeting? If yes, please provide the files noted with an asterisk above prior to the meeting."]

{"sheet":"List References","index":6,"n_rows":101,"n_cols":9,"rows_kept":101,"cut":false,"hidden":true,"merged":[]}
[]
["Alamance",1,"Class B","Anadromonous Fish","YES","Broad","Bridge","Low"]
["Alexander",2,"Class C","Area of Environmental Concern","NO","Cape Fear","RCBC","Moderate","T"]
["Alleghany",3,"SA","CAMA County",null,"Catawba","WSP","High","O"]
["Anson",4,"SB","Federal Wild & Scenic Rivers",null,"Chowan","RCP"]
["Ashe",5,"SC","HSB Required",null,"French Broad","CMP"]
["Avery",6,"SWL","NC Natural & Scenic Rivers",null,"Hiwassee","C. M. Pipe-Arch"]
["Beaufort",7,"WL","Impaired Waters [303d]",null,"Little Tennessee","Structureal Plate C. M. Pipe-Arch"]
["Bertie",8,"WS I","Primary Nursery Area",null,"Lumber","Aluminum Box Culvert"]
["Bladen",9,"WS II","TVA",null,"Neuse","Detention Pond"]
["Brunswick",10,"WS III","Designated Shellfish Harvesting Area",null,"New","Dam "]
["Buncombe",11,"WS IV","Designated Public Mountain Trout Waters",null,"Pasquotank","Pond"]
["Burke",12,"WS V",null,null,"Roanoke","Lake"]
["Cabarrus",13,null,null,null,"Savannah","Confluence"]
["Caldwell",14,null,null,null,"Tar-Pamlico","N/A"]
["Camden",null,null,null,null,"Watauga","Other"]
["Carteret",null,null,null,null,"White Oak"]
["Caswell",null,null,null,null,"Yadkin-PeeDee"]
["Catawba"]
["Chatham"]
["Cherokee"]
["Chowan"]
["Clay"]
["Cleveland"]
["Columbus"]
["Craven"]
["Cumberland"]
["Currituck"]
["Dare"]
["Davidson"]
["Davie"]
["Duplin"]
["Durham"]
["Edgecombe"]
["Forsyth"]
["Franklin"]
["Gaston"]
["Gates"]
["Graham"]
["Granville"]
["Greene"]
["Guilford"]
["Halifax"]
["Harnett"]
["Haywood"]
["Henderson"]
["Hertford"]
["Hoke"]
["Hyde"]
["Iredell"]
["Jackson"]
["Johnston"]
["Jones"]
["Lee"]
["Lenoir"]
["Lincoln"]
["Macon"]
["Madison"]
["Martin"]
["McDowell"]
["Mecklenburg"]
["Mitchell"]
["Montgomery"]
["Moore"]
["Nash"]
["New Hanover"]
["Northampton"]
["Onslow"]
["Orange"]
["Pamlico"]
["Pasquotank"]
["Pender"]
["Perquimans"]
["Person"]
["Pitt"]
["Polk"]
["Randolph"]
["Richmond"]
["Robeson"]
["Rockingham"]
["Rowan"]
["Rutherford"]
["Sampson"]
["Scotland"]
["Stanly"]
["Stokes"]
["Surry"]
["Swain"]
["Transylvania"]
["Tyrrell"]
["Union"]
["Vance"]
["Wake"]
["Warren"]
["Washington"]
["Watauga"]
["Wayne"]
["Wilkes"]
["Wilson"]
["Yadkin"]
["Yancey"]