Product(s):	HAMMER
Version(s):	26.00.00.XXX and higher
Area:	Output and Reporting

Problem

How can I export transient profile results (minimum and maximum pressures or HGL) for multiple scenarios and profiles?

This may be needed for example to produce a combined profile showing multiple lines for the minimum and maximum head for multiple scenarios.

Solution

The Profile tab of the Transient Results Viewer currently only shows one scenario at a time. You can set up and compute multiple scenarios and open multiple profiles, but a combined profile with multiple lines would be difficult to visualize in a consistent way that meets the needs of all users and all standard presentation.

To address this, an "Export" button can be found in the Profiles tab of the Transient Results Viewer in HAMMER 2026 (26.XX.XX.XXX) and higher, which enables users to export multiple transient profiles to CSV file. The CSV file can then be manipulated in an external application such as Excel, to produce the desired visualization.

For HAMMER version 2024 and earlier, see the following article for other options: Combine, save and export profiles and graphs from the HAMMER transient results viewer

Transient Profile Results Export - Configuration

After clicking the Export button, you can configure which scenarios are included. Click the New button (white paper icon) to create a new row to add multiple scenarios.

Table Columns:

Scenario: Label of the scenario with transient results. Note: as of 26.00.00.XXX, "Generate Animation Data" must also be set to "True" in the transient calculation options.
Time from Start: the transient timestep (in seconds) to use for the current timestep column in the exported CSV file. Meaning, the "Hydraulic Grade" and "Air/Vapor Volume" columns in the export. For example if you want the "Hydraulic Grade" column to show the transient results from the end of the simulation, pick the timestep from the dropdown that corresponds to the simulation end time. Otherwise, leave it as zero and the "Hydraulic Grade" column will show the same value as the "Hydraulic Grade (Initial)".
Profile: the label of the profile to export. Only includes profiles with transient results saved. If a profile is not appearing in the list, it either has the "Transient Report Path" check box unchecked (right click on the profile in the Profiles manager), or it includes elements that are currently closed or inactive in the current scenario.

Menu Buttons:

New: add a new row to the table, to export an additional scenario and/or profile.
Delete: delete the currently selected row in the table.
Preview: show a preview table of the data that will be exported to CSV.
Export: choose a location to save the CSV file to.
Help: documentation link.

What gets Exported?

The exported CSV file includes the primary profile lines (min, max, initial, current and physical elevation) plus more.

Click the Preview button to see the columns that will be exported to the CSV file. Scenario Name, Profile name, time from start, Point (pipe endpoint), Distance (station along the profile), Elevation (physical elevation), Hydraulic Grade (minimum), Hydraulic Grade (maximum), Hydraulic Grade (initial), Hydraulic Grade (corresponding to the "time from start"), Air/Vapor Volume (also corresponding to the "time from start", Air/vapor volume (maximum) and Vaporization grade line (corresponding to the vapor pressure limit, below which the water vaporizes and a vapor pocket forms).

Preview Table

Assumptions and Limitations

All exported profiles will use the Graph Type selected in the Profiles tab of the Transient Results Viewer at the time the Export button was clicked. The default is "Hydraulic Grade and Air/Vapor Volume" which is typical, but you can also choose the pressure profile type for example.
"Generate Animation Data" must be set to "True" in the transient calculation options
The "Distance" increments (how many rows in the exported table, for a given scenario/profile) and the corresponding "Point" (pipe endpoint) are based on the transient calculation timestep, wave speed and pipe length. HAMMER computes results at increments along the pipe, not just at the endpoints. See: Transient profile data section intervals
A "max allowable" HGL or pressure column/line must be manually added in an external application, alongside the exported data. The pipe pressure rating (maximum pressure the pipe can safely withstand) is often a function of the pipe material and other factors.