Data tables

The data tables show the whole model as a spreadsheet. There is one tab per asset type, one row per asset, and one column per property. Use the tables when the job is a list and not a network. For example, you can make sure that every pipe has a diameter, paste a column of elevations from a survey, or find the six junctions that have no demand.

Data tables in the toolbar opens the bottom panel on the Junctions tab. Ctrl+J shows and hides the panel from anywhere. The tabs are Junctions, Pipes, Pumps, Valves, Reservoirs, Tanks and Customer points. A HGL profile tab appears when a profile exists.

The columns

Label is the first column. It stays fixed on the left when you scroll sideways, so you always know which row you are on.

The columns after Label come in this order:

• Enabled
• The connections of a link (Start node and End node)
• The model attributes of that asset type, in the same order as the Asset tab
• Any custom attributes that the project defines
• The results columns.

The results columns appear only after a run produces results. They show the values for the timestep that the time browser shows.

Some columns are read-only because the app calculates the value and does not store it: Start node and End node, Direct demand, Number of demands, Connected customers, Customer demand, and everything on the results side. The Enabled column is editable for pipes, pumps and valves, and read-only for nodes. The Asset tab uses the same rule.

Caution

The Junctions tab shows Base demand and Pattern for the first demand category of the junction only. Number of demands tells you when there are more categories, and Direct demand is the average of all of them. You must edit a junction that has several categories in the Demands section of the Asset tab. If you edit Base demand here, only the first category changes.

Working in the grid

The grid works like a spreadsheet.

Key	What it does
Arrow keys	Move between cells
Enter	Start an edit, or accept the value and move down
Esc	Cancel the edit, or clear the selection
Tab / Shift+Tab	Move right and left
Delete / Backspace	Clear the cell
Any character	Start an edit with that character
Ctrl+C	Copy the selected cells as tab-separated text
Ctrl+V	Paste into the selection

To select a block of cells, click one cell and then shift-click another. To select a whole column, click the column header. To select everything, click the box at the top left of the grid. To change the width of a column, drag the edge of its header.

To sort, point at a column header and open the More actions menu that appears on it. The menu has Sort ascending and Sort descending. Sorting changes the order that you see, and not the model. The row menus still work on the rows in their sorted order.

Copying and pasting

Copy takes the selection as tab-separated text, which pastes directly into a spreadsheet. If you copy a whole column, the app also offers Copy with headers, which adds the column name. To get a whole table out in one step, use Export > Asset data in the toolbar. See Import and export.

Paste writes into the cells from the top left of the selection outward, in one undo step, and skips read-only columns. This is the fastest way to get a spreadsheet of diameters or elevations into the model. It is why the worked examples use the tables and not the panel when there are thirty numbers to enter.

Note

A paste of a column of numbers is correct only if the rows are in the order that you expect. Sort by Label first. Copy the labels out together with the values, so that you can compare the two lists before you paste.

Getting from a row to the map

When you right-click a cell or a row, the menu gives two commands:

• Select in map selects the assets in the rows that you selected, and zooms the map to them. This is the way back from a list to the network. For example, sort by pressure, select the bottom twenty rows, and see where they are.
• Delete removes those assets from the model, with everything that follows from it. See Selecting and finding assets for what the app deletes together with a node.

On the Customer points tab, Select in map is not available while the map hides customer points. To use it, show them again from the Map tab. See Customer points and Symbology.

What the tables cannot do

The tables edit the same model as the Asset tab, one property at a time. Anything that the panel treats as more than a single value stays in the panel: demand categories after the first, the controls of a pump, the volume curve of a tank, and a chemical source.

The tables cannot filter rows either. To work on a subset, select it on the map and read it in the panel, or sort by the column that separates it.

The grid becomes read-only with the rest of the app in two cases: while a simulation plays back, and while you are on Main and a scenario exists. See Scenario work.

Next

• The Asset tab — the same properties, one asset at a time, with the sections that the grid cannot show.
• Custom attributes — how to add your own columns.
• Import and export — how to move whole tables in and out.