{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["QA_QC Checklist","Timeline","USGS Approval"],"not_rendered":{"charts":1,"images":0,"macros":1,"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":"QA_QC Checklist","index":0,"n_rows":103,"n_cols":5,"rows_kept":103,"cut":false,"hidden":false,"merged":[[0,0,0,3],[67,0,67,4],[50,0,50,4],[18,0,18,4],[20,0,20,4],[36,0,36,4],[40,0,40,4],[34,0,34,4],[52,0,52,4],[54,0,54,4],[29,0,32,1],[29,2,30,2],[31,2,32,2],[45,0,48,1],[45,2,46,2],[47,2,48,2],[101,0,102,1],[62,0,65,1],[62,2,63,2],[64,2,65,2],[87,0,90,1],[87,2,88,2],[89,2,90,2],[69,0,69,4],[76,0,76,4],[81,0,81,4],[94,0,94,4],[92,0,92,4]]}
["Final NWS/USGS Inundation Mapping QA/QC Checklist (1-D)",null,null,null,"Version 3"]
[]
["Project:",null,null,"Lowest inundation elevation:"]
["Site Name/LID:",null,null,"Action Stage:"]
["USGS gage ID:",null,null,"Flood Stage:"]
["Reach Limits & Length:",null,null,"Moderate Flood Stage:"]
["# of profile elevations:",null,null,"Major Flood Stage:"]
[null,null,null,"Highest inundation elevation:"]
[]
[]
["Reviewer","Agency","Phase(s)","Contact phone #","Contact e-mail address"]
[null," ","1A"]
[null," "]
[null," "]
[null," "]
[null," "]
[null," "]
[]
["PHASE 1A - PROJECT SCOPING AND PLANNING"]
["Category","Explanation","Applicable","Project Chief Comments","Reviewer Comments"]
["Site Selection and Evaluation"]
["Project scope","Obtain stakeholder input on definition of the study extent. Evaluate study extent impact on AHPS web appearance.","YES"]
["Modeling approach","Establish suitability of 1-D modeling approach and static map library. Select FEMA approved hydraulic model.","YES"]
["Stream gage selection","Verify USGS gage location with local USGS Water Science Center. Is gage a NWS forecast point or suitable to be a new forecast point? Coordinate with USGS and NWS sponsoring office.","YES"]
["Stream gage rating suitability","Ensure rating is well defined by streamflow measurements. Coordinate with USGS and NWS sponsoring office. ","YES"]
["Base data availability / suitability","Verify resolution and spatial extent of available GIS data is sufficient for inundation mapping, etc.","YES"]
["Establish minimum/maximum stage and depth increments","Ensure highest modeled inundation elevations (WSELs) do not exceed rating. Verify lowest inundation elevation is approximately equal to bank-full conditions. Depth increment should be in keeping with the resolution of digital elevation data. For example, depth increments should not be less than 1/2 the contour interval.","YES"]
["Establish project timeline and reviewers",null,"YES"]
[]
["Mandatory review at this point.\n",null,"Target Date","Reviewed and Approved By","Date(s)"]
[]
[null,null,{"$f":"Timeline!C6","v":"00:00:00"}]
[]
[]
["PHASE 1B - BASE DATA COLLECTION AND PROCESSING"]
["Category","Explanation","Applicable","Project Chief Comments","Reviewer Comments"]
["Obtain GIS and other pertinent base data"]
["Obtain/review hydraulic model(s)","Research any existing hydraulic models. Initial preference is for an existing FEMA FIS.","YES"]
["Obtain/review GIS data","Check that GIS data includes stream centerline , topography, orthophotography, FEMA Flood Insurance Study data (if available and current), and transportation data (road centerlines). Transportation layers  should contain a \"RoadName\" field and extend at least 2000 ft beyond the study area extent.","YES"]
["GIS data projection","Verify agreement of datum and projection for all GIS data. ","YES"]
["Gage rating and datum checks"]
["Rating check","If FEMA FIS exists, compare 10-, 5-, 1-, and 0.2- annual percent chance flows and corresponding water surface elevations (WSEL) to rating curve to check for reasonability. Review site for possible backwater effects from downstream confluences and/or structures.","YES"]
["Rating changes","Verify historical changes to datum and/or location of gage at forecast point location. Coordinate with USGS and NWS sponsoring office.","YES"]
["Datum conversion","Establish conversion from gage datum to NAVD88 if necessary. ","YES"]
[]
["Mandatory review at this point.\n",null,"Target Date","Reviewed and Approved By","Date(s)"]
[]
[null,null,{"$f":"Timeline!C8","v":"00:00:00"}]
[]
[]
["PHASE 2A - HYDROLOGIC AND HYDRAULIC ANALYSES"]
["Category","Explanation","Applicable","Project Chief Comments","Reviewer Comments"]
["Hydrologic Analyses"]
["Discharge Selection","Verify that discharges selected from rating curve correspond to stated incremental WSEL profiles","YES"]
["Hydraulic Modeling"]
["Model conversion","Verify that pre-existing hydraulic model was adapted to workable FEMA approved model (if needed).","YES"]
["Hydraulic structure verification","Coordinate with  local/state transportation agency to verify hydraulic model represents current bridge/structure and to determine imminent plans for structure replacement and/or revision","YES"]
["Profile validation/calibration","Verify that WSELs were validated/calibrated against HWM and other historical gage data or other study data (if available). Check agreement with FEMA Flood Insurance Study (if available and current).","YES"]
["Target WS elevations","Verify for each Q, modeled WSEL at gage +/-0.1 foot  of rating.","YES"]
["Technical Summary (optional)","Complete Technical Summary Checksheet","YES"]
["Review-quality mapping development","Create review-quality (post RAS / RASMapper without refinement) floodplain boundaries for use by reviewer(s). Used to check appropriate use of ineffective flow area, possible overland flow, discharge loss, etc.  ","YES"]
[]
["Mandatory review at this point.\n",null,"Target Date","Reviewed and Approved By","Date(s)"]
[]
[null,null,{"$f":"Timeline!C10","v":"00:00:00"}]
[]
[]
["PHASE 2B - MAPPING"]
["Category","Explanation","Applicable","Project Chief Comments","Reviewer Comments"]
["Inundation Polygons"]
["WSEL boundary checks","Perform reasonability check with WSEL boundary shapefiles, orthophotography, and rasters /contours. Ensure transitions along the boundary are consistent with the raster/contour data. Check agreement with FEMA Flood Insurance Study (if available and current).","YES"]
["Inter-profile consistency","Ensure boundaries for higher WSELs are always coincident or outside boundaries for lower WSELs.","YES"]
["Minimum elevation mapping","Ensure lowest WSEL polygon covers stream and channel banks visible from orthophotography.","YES"]
["Islands","Delete \"islands\"  that don't have straight line distances greater than 250 feet, as appropriate.","YES"]
["Disconnected wetted areas","Remove wetted areas that result from depressions not connected with the flow.","YES"]
["Overtopping","Ensure structures indicated as overtopped in the hydraulic model are mapped accordingly.","YES"]
["Depth Grid Rasters"]
["Grid/Layer pairing","Ensure there is a corresponding depth grid raster for each WSEL boundary.","YES"]
["Edge trimming","Ensure depth grid rasters are trimmed to extents of WSEL polygons.","YES"]
["Overtopping","Ensure that grid cells for dry areas have their depths set to zero. This is particularly important for parts of roadways/bridges that are not overtopped.","YES"]
["Grid/Layer consistency","Ensure that wetted areas have positive depths and non-wetted area depths are set to zero. For islands that were removed from the polygon mapping, the overlying grid cell depths should be set to be consistent with those of the nearest adjacent wetted cells.","YES"]
["Mapping File Management"]
["Projection","Set the coordinate system for shapefiles and rasters to Geographic NAD83.","YES"]
["Map scale","Select the largest map scale that allows display of the full extent of inundation. Map scales of 1:12,000, 1:18,000, 1:24,000, and 1:30,000 are acceptable.","YES"]
["Naming Convention","Verify that file naming convention used for inundation polygons and depth rasters layers conforms to: elev_feet_tenth.shp. Example for a inundation layer at 78.3 feet NAVD88 the file would be named elev_78_3.shp.","YES"]
["Metadata","Review and verify that metadata is attached to all GIS data and meets FGDC standards.","YES"]
[]
["Mandatory review at this point.\n",null,"Target Date","Reviewed and Approved By","Date(s)"]
[]
[null,null,{"$f":"Timeline!C12","v":"00:00:00"}]
[]
[]
["PHASE 2C - DATA SUBMISSION"]
["Category","Explanation","Applicable","Project Chief Comments","Reviewer Comments"]
["Final Data Submission"]
["USGS Approval","Obtain Bureau approval for geospatial data and publications (if applicable). See \"USGS Approval\" tab for more detail.","YES"]
["GIS Layers","Include inundation polygons, depth grids, stream centerline data, cross sections, topography, and gage location data. Also Include pertinent supporting base data such as transportation, political boundaries, and other base data layers as applicable. Include FEMA Flood Insurance Study inundation polygons if found to be in agreement during phases 2A and 2B. For each shapefile, include files with the following file extensions: dbf, prj, shp, shp.xml, shx and, if available, sbn and sbx.","YES"]
["Orthophoto/Imagery","Include ortho imagery data used to develop hydraulic modeling and inundation mapping.","YES"]
["Hydraulic Model","Include hydraulic model data (as digital files).","YES"]
["Technical Summary Document","Include completed Technical Summary document.","YES"]
[]
["Confirm data are received by NWS.\nUSGS obligation is completed.",null,"Target Date","Receiving Agent","Date(s)"]
[null,null,{"$f":"Timeline!C15","v":"00:00:00"}]

{"sheet":"Timeline","index":1,"n_rows":15,"n_cols":5,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[null,"QA/QC Timeline"]
[]
[]
[null,"Element","Start date (mm/dd/yyyy)"," End date (mm/dd/yyyy)","Duration (days)"]
[null,"Phase 1A - Project Scoping and Planning",null,null,{"$f":"IF(ISBLANK(D5),\"\",D5-C5+1)","v":""}]
[null,"     Review of Phase 1A",null,null,""]
[null,"Phase 1B - Base Data Collection and Processing",null,null,""]
[null,"     Review of Phase 1B",null,null,""]
[null,"Phase 2A - Hydrologic and Hydraulic Analyses",null,null,""]
[null,"     Review of Phase 2A",null,null,""]
[null,"Phase 2B - Mapping",null,null,""]
[null,"     Review of Phase 2B",null,null,""]
[null,"Phase 2C - Data Submission",null,null,""]
[null,"     Review of Phase 2C",null,null,""]
[null,"Confirmed data are received by NWS.",null,{"$f":"IF(MAX(C15,D5:D14)=0,TODAY(),MAX(C15,D5:D14))","v":"2021-07-21"},{"$f":"IF(ISBLANK(D15),\"\",D15-C15+1)","v":44399}]

{"sheet":"USGS Approval","index":2,"n_rows":10,"n_cols":6,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,0,1,4],[3,0,3,4]]}
[]
["USGS APPROVAL and PUBLICATION PROCESS"]
["Category","Explanation","Applicable","Project Chief Comments","Reviewer Comments"]
["Final Data Submission"]
["Colleague Review of Scientific Investigation Maps (SIM) or the Report Manuscript","Choose and contact colleague reviewers from the pool and assure that your choices meet the USGS FSP guidelines for colleague reviewers (http://internal.usgs.gov/fsp/faqs.html#sp1). Additionally, the reports specialist in the originating office should create the IPDS record in the C workflow. ","YES",null,null," "]
["Editorial Review of SIM or the Report Manuscript","Contact Ed Swibas (ejswibas@usgs.gov) to arrange the editorial review with the EPN. Start the process of creating the maps with the EPN. Do not contact your local EPN.","YES"]
["Transmittal for Approval","Upon completion of the SIM or the report manuscript, the Center Director or designee of the Originating Science Center completes the supervisor checks and transmits the SIM for Bureau Approval","YES"]
["Bureau Approval","Send for Approval through the Originating Science Center's Reports Specialist.","YES",null,null," "]
["Complete Layout","Contact Ed Swibas (ejswibas@usgs.gov) to finalize the layout and online files. ","YES"]
["Product Distribution","Prepare and package (zip) the digital data for transmission to Pubs Warehouse and the USGS FIMI Mapper according to the technical guidelines.","YES"]