Variable Definition zip_code The postal code Average1 inundation height(m) Average inundation height projection of the typhoon ensemble 1 (25 typhoon cases) Average2inundation height(m) Average inundation height projection of the typhoon ensemble 2 (25 typhoon cases) Average3 inundation height(m) Average inundation height projection of the typhoon ensemble 3 (25 typhoon cases) Average4inundation height(m) Average inundation height projection of the typhoon ensemble 4 (25 typhoon cases) Worst1 inundation height(m) Worst inundation height projection of the typhoon ensemble 1 (25 typhoon cases) Worst2inundation height(m) Worst inundation height projection of the typhoon ensemble 2 (25 typhoon cases) Worst3 inundation height(m) Worst inundation height projection of the typhoon ensemble 3 (25 typhoon cases) Worst4inundation height(m) Worst inundation height projection of the typhoon ensemble 4 (25 typhoon cases) flood level over 0m Count of all ensemble with inundation over 0m flood level over 0.5m Count of all ensemble with inundation over 0.5m flood level over 2m Count of all ensemble with inundation over 2m return period 50year "=IF(Count of flood level over 2m>=4,3,IF(Count of flood level over 0.5m>=4,2,IF(Count of flood level over 0m>=4,1,0)))" "0 indicate no flooding, 1 indicate flood level 0-0.5m, 2 indicate flood level 0.5-2m, 3 indicate flood level over 2m" return period 67year "=IF(Count of flood level over 2m>=3,3,IF(Count of flood level over 0.5m>=3,2,IF(Count of flood level over 0m>=3,1,0)))" "0 indicate no flooding, 1 indicate flood level 0-0.5m, 2 indicate flood level 0.5-2m, 3 indicate flood level over 2m" return period 100year "=IF(Count of flood level over 2m>=2,3,IF(Count of flood level over 0.5m>=2,2,IF(Count of flood level over 0m>=2,1,0)))" "0 indicate no flooding, 1 indicate flood level 0-0.5m, 2 indicate flood level 0.5-2m, 3 indicate flood level over 2m" return period 200year "=IF(Count of flood level over 2m>=1,3,IF(Count of flood level over 0.5m>=1,2,IF(Count of flood level over 0m>=1,1,0)))" "0 indicate no flooding, 1 indicate flood level 0-0.5m, 2 indicate flood level 0.5-2m, 3 indicate flood level over 2m"