XP Table allows you to create a spreadsheet for data entry, manipulation, and displaying results in tabular form. This functionality provides views of data and results that can be sorted, edited, and copied to or from other applications such as Microsoft Excel. You can also apply filters to display certain criteria based on your preference.

Setup

This button allows you to return to the main XP Table Options dialog, select network objects, and view the results for the selected objects.

View

The View button shows the results in the XP Table. The XP Table view allows you to sort specific parameters to enhance object selection, sorting, and filtering. Data can be manipulated in this view to display information in a more meaningful manner, allowing you to review the results faster. From here, you can return to the main network window and show the objects in the network, sort columns in ascending or descending order. You may also select the table display and printing options, set the header and footer, and other page preferences.

You can use the following icons in the XP Table view tool strip:

  • Network View . Clicking this icon returns you to the main network window.
  • Show Object in Network  . Clicking this icon shows the objects in the main network window.
  • Sort ascending  . Sorts XP Table in ascending order based on the selected column.
  • Sort descending  . Sorts XP Table in descending order based on the selected column.

Save

This button saves the XP Table Definitions file (*.tab) to your specified file location. All the global attributes, excluding the flags on this dialog, are saved.

Load

This button loads the XP Table Definitions from a specified file (*.tab). All the global attributes, excluding the flags on this dialog, are loaded.

Close

This button closes the XP Table Options dialog.

Add

This button allows you to add a new object, which you can then view in your XP Table. The list of added objects are shown in the XP Table Options dialog. You can highlight the object and specify the parameters of that added object by selecting the Edit button. This gives you the flexibility to customize the results according to you needs. This also allows you to review and compare XP Tables with different variables.

To add a new object, click the Add button and the Get Name dialog appears. Enter the new table name and then click OK.

Edit

The Edit button displays the Variable Selection dialog, which allows you to add, delete, or modify the available variables and display them in your XP Table.

The following options are available in the Variable Selection dialog:

Display Object. Selecting Node or Link displays the variables for nodes or links in the Available Variables window.

Variable Type. When you select Node in Display Object, the Variable Type becomes Node automatically. When you select Link in Display Object, the Variable Type has three options; LinkUS Node; or DS Node. By default, the Variable Type is set to Link. Select any of these options to load the available variables for them. 

Available Variables. This portion gives the list of all available variables that can be shown in your XP Table. Select Node or Link in Display Object and the list of variables automatically refreshes. Select a variable and then click Insert/Append and the variable will appear in Selected Variables. You can add as much variable as you need in your XP Table to help you review your result.

Insert/Append. These buttons allow you to insert a variable before the highlighted field in the list, or at the end of the list respectively. The variable then appears in the Selected Variables list.

Selected Variables. This portion provides the list of selected variables that will be shown in the XP Table. You may change the order of the variable by using the move up or move down icon. You may remove a variable by highlighting one, and then click Delete.

Delete. This button allows you to remove a variable from the Selected Variables list. 

Move up icon  . Select a variable in the Selected Variables list and click this icon   to move the variable up the list. 

Move down icon  Select a variable in the Selected Variables list and click this icon   to move the variable down the list. 

Rename

This button allows you to change the name of the result to one that is more meaningful to you.

Delete

The delete button removes an object in the XP Table Options dialog.

Options

This button displays the XP Tables - Display Options dialog where you can select and change settings for General Display, Row Headings, and Printing Options

Classic. This option selects all General Display view. Selecting the Classic button allows your result to:

  • Display Subcatchment column
  • Display Storm column
  • Combined Subcatch/Storm rows

Compact. This option selects all Row Headings view. Selecting the Compact button allows your result to display the:

  • Object name on every row
  • Subcatchment on every row
  • Storm on every row
You can select any or a combination of the Classic and Compact options by marking the appropriate checkboxes.

Header & Footer. This button allows you to change the settings of your header or footer. This dialog also lets you:

  • Select the Header and Footer tab and change the settings for Left Aligned, Centered, and Right Aligned as necessary.
  • Use the Font button to change the font type, style, size, effects, color, and other options. 
  • You can alter the Distance to Frame by entering value (in) in the Header and Footer field.
  • Select Save settings to profile to save the settings you just used for later use.

Page Setup. This button allows you to change the way XP Tables is set up. This dialog gives you a preview of your output, making it easier for you to visualize the result. This dialog also allows you to: 

  • Change the left, right, top, and bottom margins of your results display by entering a value in the corresponding fields.
  • You can choose to show Row Headers, Column Headers, Print Frame, Vertical Lines, Horizontal Lines, and Only Black and White by marking the appropriate checkbox to turn on any of these preferences.
  • Change the Page Order to First Rows, then Columns or First Columns, then Rows by marking the appropriate radio button.
  • The Center on Page section  allows you to center the data vertically or horizontally, depending on how you want to view the results.  
  • Select Save settings to profile to save the settings for later use.