Can I easily export my results to an Excel spreadsheet?
Can I export results to an Excel spreadsheet for all the time steps in my analysis?
The first and most basic method of exporting model results to Excel is to use the Export button in the top-left corner of any Flextable. From here, choose CSV as the file type and the table will be exported to a CSV file that can be opened in Excel. Make sure to add or remove columns as needed before export. You can set up a new Project-Level flextable first if you don't want to modify the predefined flextables.
Note that with this method, calculated / results fields will export the values for the current timestep only. To export all timesteps, see the next method below.
Previously, data could be exported to Excel via the Flextables, but needed to be done one Flextable at a time and did not include time series (results over time). Now, starting with V8i SELECTseries 6 (08.11.06.58+) of WaterCAD, WaterGEMS and HAMMER, and V8i SELECTseries 5 (08.11.05.58+) of SewerGEMS, SewerCAD, StormCAD and CivilStorm, we have added the ability to export data for all the element types at once, including time series.
Starting with the release of CONNECT Edition (version 10.00.00.XX or later), FlexTables can be exported to an Excel file in multiple products (SewerGEMS, SewerCAD, StormCAD, and CivilStorm) and for all integrated platforms (MicroStation, AutoCAD, ArcMap, and stand alone).
Another possible method would be to use ModelBuilder to populate a spreadsheet.
Please note that the export to Excel from file menu is actually easier to use than Modelbuilder method. We highly recommend using that instead of ModelBuilder to speed the process. You could also use a similar process for exporting your information to an Access database or another database format that ModelBuilder exports to.