When a HAMMER model has many scenarios, it would be nice to have a feature that exports all of the profile result data to Excel (for example to create summary profile charts that show the max and min hydraulic grade line for multiple scenarios, or to do further analysis on pipe strength, etc.)
Currently you can only:
Copy data from one scenario at a time only from within the Transient Results Viewer.
Copy data from more than one scenario at a time from within the standard Profile viewer, but you miss intermediate results along the pipe
Use a Custom Report, but the export to Excel is a bit clunky (you need to pick a very large paper size or the columns wrap in a weird way, all numbers are exported as text, the scenarios are not labelled)
I have attached a custom report output, along with some modifications that would help us to process further in Excel. But an interface like the Export to Excel interface would be better. This interface should allow you to select:
a. The scenarios you want to export
b. The profile(s) you want to export
Excel file attached