{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Flood & Heat Hazard Exposure"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":2,"comments":1,"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":"Flood & Heat Hazard Exposure","index":0,"n_rows":61,"n_cols":31,"rows_kept":61,"cut":false,"hidden":false,"merged":[[8,1,8,11],[9,1,9,3],[9,4,9,13],[10,1,10,3],[10,4,10,13],[11,1,11,3],[11,4,11,13],[2,1,2,13],[3,2,3,13],[4,2,4,13],[5,2,5,13],[6,2,6,13],[7,2,7,13],[16,1,16,15],[17,2,17,4],[17,5,17,9],[17,10,17,12],[17,13,17,14],[17,15,19,15],[18,1,19,1],[18,2,19,3],[18,4,19,4],[18,5,19,5],[22,2,22,3],[22,6,22,7],[22,10,22,11],[22,24,22,28],[23,2,23,3],[23,6,23,7],[23,10,23,11],[18,14,19,14],[20,2,20,3],[20,6,20,7],[20,10,20,11],[21,2,21,3],[21,6,21,7],[21,10,21,11],[18,6,19,7],[18,8,19,8],[18,9,19,9],[18,10,19,11],[18,12,19,12],[18,13,19,13],[26,2,26,3],[26,6,26,7],[26,10,26,11],[27,2,27,3],[27,6,27,7],[27,10,27,11],[24,2,24,3],[24,6,24,7],[24,10,24,11],[25,2,25,3],[25,6,25,7],[25,10,25,11],[30,1,30,2],[31,2,31,12],[32,2,32,12],[33,2,33,12],[34,2,34,12],[35,2,35,12],[28,2,28,3],[28,6,28,7],[28,10,28,11],[29,2,29,3],[29,6,29,7],[29,10,29,11],[40,2,40,3],[40,13,40,14],[41,2,41,3],[41,13,41,14],[42,2,42,3],[42,13,42,14],[37,1,37,14],[38,1,39,1],[38,2,38,4],[38,5,39,5],[38,6,38,10],[38,11,38,12],[38,13,39,14],[39,2,39,3],[46,2,46,3],[46,13,46,14],[47,2,47,3],[47,13,47,14],[48,2,48,3],[48,13,48,14],[43,2,43,3],[43,13,43,14],[44,2,44,3],[44,13,44,14],[45,2,45,3],[45,13,45,14],[58,2,58,12],[58,13,58,14],[59,2,59,12],[60,2,60,12],[49,2,49,3],[49,13,49,14],[50,1,50,2],[51,2,51,13],[53,2,53,13],[57,1,57,12],[57,13,57,14]]}
[]
[null,"FLOOD HAZARD AND HEAT EXPOSURE SCREENING"]
[null,"Instructions "]
[null,1,"This tab applies to all projects. Completion of this tab is mandatory and flood risks identified must be represented in project summary and recommended scopes in this IPNA. "]
[null,2,"All projects must complete Table 1. If YES response is indicated as a response in Table 1 for Coastal Flood Exposure or Stormwater Exposure, then proceed to complete Table 2. "]
[null,3,"Buildings that are exposed to flood risk must complete Table 2. The purpose of Table 2 is to identify if there are residential uses or critical equipment located in areas of the building that are prone to flooding. Please ensure that you scroll all the way to the right [columns X-AI] to access reference tables/calculators for First Floor Flood Elevation, Design Flood Elevation, and Estimated Flood Depth at Site."]
[null,4,"Table 3 helps determine minimum required flood mitigation strategy for all buildings that are exposed to flood hazard. Provide additional comments and recommendations as needed."]
[null,5,"See Flood Map resources list below for links to reference maps. "]
[null,"Flood Map Resources"]
[null,"FEMA Flood Insurance Rate Maps ",null,null,"FEMA Flood Maps"]
[null,"NYC Flood Hazard Mapper",null,null,"NYC Flood Hazard Mapper "]
[null,"NYC Stormwater Flood Maps",null,null,"New York City Stormwater Flood Maps"]
[]
[]
[]
[]
[null,"TABLE 1: FLOOD HAZARD AND HEAT EXPOSURE SCREENING  (complete screening for each building being assessed)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DATA VALIDATION"]
[null,null,"Property Information",null,null,"Coastal Flood Exposure \n(see note 1) ",null,null,null,null,"Stormwater Exposure",null,null,"Heat Exposure\n(see note 5)",null,"Comments\n(see note 4)",null,"YES","+1FT NAVD88",1,null,null,null,"Figure 1.0 - Flood Elevations Diagram"]
[null,"#","Address",null,"BBL","Current Special Flood Hazard Area","Current Shaded X Zone [0.2% Annual Chance Flood] (see note 1)",null,"Base Flood \nElevation [BFE] (see note1)","NYC ONLY\nFuture (2050s) Flood Hazard Area \n(see note 2)","NYC ONLY\nStormwater Flood Exposure\n(see note 3)",null,"Prior Flood History\n(see note 4)","NYC ONLY\nHeat Vulnerability Index\n(see note 5)","NYC ONLY\nIs project considered High Risk for Heat Vulnerability",null,null,"NO ","+2FT NAVD88",2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"UNKNOWN","+3FT NAVD88",3,null,null,null,null,"Determine Design Flood Elevation "]
[null,1,null,null,null,null,null,null,{"$f":"IF(TRIM(G21)=\"NO\",\"N/A\",\"\")","v":""},null,null,null,null,null,{"$f":"IF(N21=\"\",\"\",IF(N21>4,\"YES\",\"NO\"))","v":""},null,null,"YES (1ft+)","+4FT NAVD88",4,null,null,null,1,"Base Flood Elevation from FEMA PFIRM ",null,null,null,null,null,"FT (User Input)"]
[null,{"$f":"B21+1","v":2},null,null,null,null,null,null,"",null,null,null,null,null,{"$f":"IF(N22=\"\",\"\",IF(N22>4,\"YES\",\"NO\"))","v":""},null,null,"YES (4in to 1ft)","+6FT NAVD88",5,null,null,null,2,"Freeboard *",null,null,null,null,2,"FT"]
[null,3,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,"NO","+7FT NAVD88",null,null,null,null,3,"DFE relative to NAVD88",null,null,null,null,{"$f":"SUM(AD21:AD22)","v":2},"FT above NAVD88 (Insert in Table 2)"]
[null,4,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,"Current / Coastal","+8FT NAVD88"]
[null,5,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,"Current / Compound","+9FT NAVD88",null,null,null,null,4,"Sea Level Rise Adjustment (2050s)",null,null,null,null,1.25,"FT"]
[null,6,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,"Stormwater","+10FT NAVD88",null,null,null,null,5,"Sea Level Rise Adjusted DFE relative to NAVD88",null,null,null,null,{"$f":"SUM(AD23:AD25)","v":3.25},"FT above NAVD88 (Insert in Table 2)"]
[null,7,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,"Future / Coastal","+11FT NAVD88"]
[null,8,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,"Future / Compound","+12FT NAVD88",null,null,null,null,null,"* For projects in VE zone, refer to Appendix G for appropriate freeboard elevation"]
[null,9,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,"Prior Flood Experienced","+13FT NAVD88"]
[null,10,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,"+14FT NAVD88"]
[null,"NOTES:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Appendix G","+16FT NAVD88"]
[null,1,"Refer to FEMA Flood Insurance Rate Maps (2007 FIRM and 2015 PFIRM). Answer YES if building is within the illustrated current Special Flood Hazard Area (1% Annual Chance Flood) or Shaded X Zone (.2% Annual Chance Flood) and NO if it is not. For YES responses, indicate the BFE noted on the FIRM in next column.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HPD Design Guidelines for Preservation, Baseline","+17FT NAVD88"]
[null,2,"For NYC Properties Only: Refer to the NYC Flood Hazard Mapper and view map layer \"Future Flood Plain 2050s \". Answer YES if building is within the  1% Annual Chance Flood Area indicated and NO if it is not.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HPD Design Guidelines for Preservation, Reach","+18FT NAVD88"]
[null,3,"For NYC Properties Only: Refer to the NYC Stormwater Flood Maps and view layer \"Extreme Stormwater Flood with 2080s Sea Level Rise\". Answer YES if building is within or adjacent to a flooded area. indicated. ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"None Needed","+19FT NAVD89"]
[null,4,"Talk with building manager and on-site staff to determine if the building has experienced flooding of any kind in the past. Indicate YES if it has and NO if it has not and provide descriptions (including flood levels and degree of damage) in the comments column. ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Incremental Mitigation Measures, See Comments","+20FT NAVD90"]
[null,5,"For NYC Properties Only: refer to NYC's Environment and Health Data Portal here: https://a816-dohbesp.nyc.gov/IndicatorPublic/beta/data-explorer/weather-related-illness/?id=2191#display=summary"]
[]
[null,"TABLE 2: PROPERTY RISK ASSESSMENT (complete for all buildings with a YES response for Coastal Flood Exposure or Stormwater Exposure in Table 1)"]
[null,"#","Property Information",null,null,"Risk Exposure Type\n(see note 1)","Coastal Flood Risk \n(see note 2)",null,null,null,null,"NYC ONLY\nStormwater Flood Risk \n(See note 4)",null,"Comments\n(see note 5)"]
[null,null,"Address",null,"BBL",null,"First Floor Elevation\n(FFE)\n(see note 2)","Design Flood Elevation (DFE) \n(see note 3)","Is FFE Below DFE?","Are there Residential Uses \nBelow DFE?","Is there Critical Equipment \nBelow DFE?","Residential Use Below Anticipated Flood Level or Below Grade\n(see note 4)","Critical Equipment Below Anticipated Flood Level or Below Grade? \n(see note 4)"]
[null,1,{"$f":"IFERROR(INDEX($C$19:$C$30,SMALL(IF(($F$21:$F$30=\"Yes\")*1=1,ROW($F$21:$F$30)-ROW($F$19)+1),ROWS($F$19:F19))),\"\")","v":""},null,{"$f":"IFERROR(INDEX($E$19:$E$30,SMALL(IF(($F$21:$F$30=\"Yes\")*1=1,ROW($F$21:$F$30)-ROW($F$19)+1),ROWS($F$19:F19))),\"\")","v":""},null,null,null,{"$f":"IF(OR(G41=\"\",H41=\"\"),\"\",IF(MID(G41,2,1)<MID(H41,2,1)=TRUE,\"YES\",IF(MID(G41,2,1)>MID(H41,2,1)=TRUE,\"NO\",\"UNKNOWN\")))","v":""}]
[null,{"$f":"B41+1","v":2},{"$f":"IFERROR(INDEX($C$19:$C$30,SMALL(IF(($F$21:$F$30=\"Yes\")*1=1,ROW($F$21:$F$30)-ROW($F$19)+1),ROWS($F$19:F20))),\"\")","v":""},null,{"$f":"IFERROR(INDEX($E$19:$E$30,SMALL(IF(($F$21:$F$30=\"Yes\")*1=1,ROW($F$21:$F$30)-ROW($F$19)+1),ROWS($F$19:F20))),\"\")","v":""},null,null,null,{"$f":"IF(OR(G42=\"\",H42=\"\"),\"\",IF(MID(G42,2,1)<MID(H42,2,1)=TRUE,\"YES\",IF(MID(G42,2,1)>MID(H42,2,1)=TRUE,\"NO\",\"UNKNOWN\")))","v":""}]
[null,3,{"$f":"IFERROR(INDEX($C$19:$C$30,SMALL(IF(($F$21:$F$30=\"Yes\")*1=1,ROW($F$21:$F$30)-ROW($F$19)+1),ROWS($F$19:F21))),\"\")","v":""},null,{"$f":"IFERROR(INDEX($E$19:$E$30,SMALL(IF(($F$21:$F$30=\"Yes\")*1=1,ROW($F$21:$F$30)-ROW($F$19)+1),ROWS($F$19:F21))),\"\")","v":""},null,null,null,""]
[null,4,{"$f":"IFERROR(INDEX($C$19:$C$30,SMALL(IF(($F$21:$F$30=\"Yes\")*1=1,ROW($F$21:$F$30)-ROW($F$19)+1),ROWS($F$19:F22))),\"\")","v":""},null,{"$f":"IFERROR(INDEX($E$19:$E$30,SMALL(IF(($F$21:$F$30=\"Yes\")*1=1,ROW($F$21:$F$30)-ROW($F$19)+1),ROWS($F$19:F22))),\"\")","v":""},null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Estimated Flood Depth at Site**"]
[null,5,{"$f":"IFERROR(INDEX($C$19:$C$30,SMALL(IF(($F$21:$F$30=\"Yes\")*1=1,ROW($F$21:$F$30)-ROW($F$19)+1),ROWS($F$19:F23))),\"\")","v":""},null,{"$f":"IFERROR(INDEX($E$19:$E$30,SMALL(IF(($F$21:$F$30=\"Yes\")*1=1,ROW($F$21:$F$30)-ROW($F$19)+1),ROWS($F$19:F23))),\"\")","v":""},null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"DFE Relative to NAVD88",null,null,null,null,{"$f":"AD23","v":2},"FT  above NAVD88"]
[null,6,{"$f":"IFERROR(INDEX($C$19:$C$30,SMALL(IF(($F$21:$F$30=\"Yes\")*1=1,ROW($F$21:$F$30)-ROW($F$19)+1),ROWS($F$19:F24))),\"\")","v":""},null,{"$f":"IFERROR(INDEX($E$19:$E$30,SMALL(IF(($F$21:$F$30=\"Yes\")*1=1,ROW($F$21:$F$30)-ROW($F$19)+1),ROWS($F$19:F24))),\"\")","v":""},null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"Elevation of lowest adjacent grade on site",null,null,null,null,null,"FT  above NAVD88 (User Input)"]
[null,7,{"$f":"IFERROR(INDEX($C$19:$C$30,SMALL(IF(($F$21:$F$30=\"Yes\")*1=1,ROW($F$21:$F$30)-ROW($F$19)+1),ROWS($F$19:F25))),\"\")","v":""},null,{"$f":"IFERROR(INDEX($E$19:$E$30,SMALL(IF(($F$21:$F$30=\"Yes\")*1=1,ROW($F$21:$F$30)-ROW($F$19)+1),ROWS($F$19:F25))),\"\")","v":""},null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,"Predicted height of flood waters on site",null,null,null,null,{"$f":"SUM(AD45-AD46)","v":2},"FT flood water depth at site"]
[null,8,{"$f":"IFERROR(INDEX($C$19:$C$30,SMALL(IF(($F$21:$F$30=\"Yes\")*1=1,ROW($F$21:$F$30)-ROW($F$19)+1),ROWS($F$19:F26))),\"\")","v":""},null,{"$f":"IFERROR(INDEX($E$19:$E$30,SMALL(IF(($F$21:$F$30=\"Yes\")*1=1,ROW($F$21:$F$30)-ROW($F$19)+1),ROWS($F$19:F26))),\"\")","v":""},null,null,null,""]
[null,9,{"$f":"IFERROR(INDEX($C$19:$C$30,SMALL(IF(($F$21:$F$30=\"Yes\")*1=1,ROW($F$21:$F$30)-ROW($F$19)+1),ROWS($F$19:F27))),\"\")","v":""},null,{"$f":"IFERROR(INDEX($E$19:$E$30,SMALL(IF(($F$21:$F$30=\"Yes\")*1=1,ROW($F$21:$F$30)-ROW($F$19)+1),ROWS($F$19:F27))),\"\")","v":""},null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"** If site elevation information is not available, then refer to NYC Flood Hazard Mapper \"Base Flood Elevation\" layer. Use high end of range provided"]
[null,10,{"$f":"IFERROR(INDEX($C$19:$C$30,SMALL(IF(($F$21:$F$30=\"Yes\")*1=1,ROW($F$21:$F$30)-ROW($F$19)+1),ROWS($F$19:F28))),\"\")","v":""},null,{"$f":"IFERROR(INDEX($E$19:$E$30,SMALL(IF(($F$21:$F$30=\"Yes\")*1=1,ROW($F$21:$F$30)-ROW($F$19)+1),ROWS($F$19:F28))),\"\")","v":""},null,null,null,""]
[null,"NOTES:"]
[null,1,"Choose category based on results of screening in Table 1"]
[null,2,"Provide First Floor Elevation relative to NAVD88m if possible. Use inset Figure 1 to determine DFE at each building. "]
[null,3,"For NYC Properties Only: Projects must design to the 2050s Sea-Level-Rise-Adjusted DFE "]
[null,4,"For NYC Properties Only: If there are any below grade or first floor residential uses or critical equipment below estimate flood depth (from Table 1) indicate YES"]
[null,5,"In the comments section: please note any existing resiliency measures in the building. Also, please note if the building has been flood proofed."]
[]
[null,"REFERENCE TABLE 3: Flood Risk Mitigation Measures ",null,null,null,null,null,null,null,null,null,null,null,"Links"]
[null,1,"If overall scope of capital project triggers compliance with NYS or NYC Building Code Appendix G, then refer to Appendix G for minimum flood protection standards required.",null,null,null,null,null,null,null,null,null,null,"NYS Construction Code Appendix G"]
[null,2,"For NYC PROJECTS:  If TABLE 1 shows that project is exposed to current or future flood hazard then refer to HPD Design Guidelines for Preservation for baseline and reach incremental flood risk mitigation measures applicable to all preservation projects not subject to Appendix G Flood protection Standards.",null,null,null,null,null,null,null,null,null,null,"HPD Design Guidelines for Preservation"]
[null,3,"FOR NYS PROJECTS:  If TABLE 1 shows that project is exposed to current or future flood hazard then refer to HCR Design Guidelines for Existing Buildings for baseline and reach incremental flood risk mitigation measures applicable to all preservation projects not subject to Appendix G: Flood-Resistant Construction. ",null,null,null,null,null,null,null,null,null,null,"HCR Sustainability Guidelines for Existing Buildings"]