How to create a custom breach growth formula

This how-to will describe the steps necessary o iteratively update the breach width using an excel panel. This project assumes you have followed the steps to setup an iterated Flooding Overlay. To setup a project with an iterated Flooding Overlay, see this how-to.

How to create a custom breach growth formula:

1. Open a project setup with an iterative Flooding Overlay
2. Add a new Breach Area
3. Import a Template Excel Panel for updating the Breach Width
4. Import a Template Excel Panel for storing Breach output variables
5. Import a Template Text Panel for plotting Breach output variables
6. Adjust the Breach Width Excel.

Breach Area

This how-to contain the steps that can be followed to an Area that is identified as a Breach Area for the Flooding Overlay.

How to "Add a Breach Area":

1. Select Current Situation in the ribbon bar.
2. Hover over Areas, and select Add Empty Area.
3. Add a new Area.
4. Rename it to Breach.
5. Add new attribute BREACH_HEIGHT using the Add new attribute section in the attributes tab.
6. Draw a selection for the breach.

Breach Width Excel Panel

This how-to contain the steps that can be followed to an Area that is identified as a Breach Area for the Flooding Overlay.

How to Import a Template Excel Panel for updating the Breach Width:

1. Select Current Situation in the ribbon bar.
2. Hover over Panels, and select Find more on Share.
3. Navigate to Panels, Water and select the file named "Breach_width_iteration_before.xlsx"
4. With the Panel selected, select the Template Tab.
5. Adjust the option below Apply Template on to Areas.
6. Click on the Select button and select the attribute named BREACH_HEIGHT.
7. Click on the Apply Template button to create a Panel instance for the Breach Area.

Breach output values

The following how-to contain the steps that can be followed to add a Template Excel Panel that stores the output values of a breach for each calculated iterations. This is necessary because each iteration, the default output values of the breach are overwritten. By adding this example excel file, you can see how to obtain the output values and append and store these under new attributes in the Breach Area.

How to Import a Template Excel for storing Breach output values:

1. Select Current Situation in the ribbon bar.
2. Hover over Panels, and select Find more on Share.
3. Navigate to Panels, Water and select the file named "Breach_output_iteration_after.xlsx"
4. With the Panel selected, select the Template Tab.
5. Adjust the option below Apply Template on to Areas.
6. Click on the Select button and select the attribute named BREACH_HEIGHT.
7. Click on the Apply Template button to create a Panel instance for the Breach Area.

Breach output plot

The following how-to contain the steps that can be followed to add a Template Text Panel that create a simple plot of the stored output values for a Breach. The Breach Width, Breach Flow and Breach Cumulative Flow are added to the plot.

How to Import a Text Excel for plotting Breach output values:

1. Select Current Situation in the ribbon bar.
2. Hover over Panels, and select "Find more on Share".
3. Navigate to Panels, Water and select the file named "Breach_output_iteration_plots.txt"
4. With the Panel selected, select the Template Tab.
5. Adjust the option below Apply Template on to Areas.
6. Click on the Select button and select the attribute named BREACH_HEIGHT.
7. Click on the Apply Template button to create a Panel instance for the Breach Area.