Problem

Can demand data be exported to an Excel file for use in another model?

Solution

If the demand data only needs to be saved to an Excel file, all you would need to do is open the Demand Control Center, highlight the cells, and using the keyboard shortcut to copy the cells. These can then be pasted into Excel.

However, if you need to have the data in a format where another user can export these into their model, a different method needs to be used. The first thing you will need to do is create a new spreadsheet with headers for the label, demand, and pattern in the first row of the first three columns. Save this spreadsheet, then open the model and the scenario with the demand data you want to export. Note that if you have a 64-bit computer and a 32-bit version of Microsoft Office, you will need to open the 32-bit version of WaterGEMS. You can find this at C:\Program Files (x86)\Bentley\WaterGEMS\WaterGEMS.exe.

Next, open ModelBuilder and select the New button. For the Data Source type, choose Excel and select the spreadsheet you just created. Click Next. In the next screen, make sure the units are accurate and click Next. Then click Next two more times. You should be on the field mapping section.

For the Table Type, choose "Junction, Demand Collection". For the key field, choose Label. In the lower right, you will see the column headers from your spreadsheet. Highlight "Demand" and choose Demand (Base) from the Property pulldown menu (make sure the units are correct as well). Highlight "Pattern" and select Pattern (Demand) (Label). Click Next.

For the option "Would you like to build model now?" select No. This is important because you do not want to add the blank data to your existing model. After selecting No, click Finish. This will take you back to the ModelBuilder Manager. You should see the title of your spreadsheet listed in the list of ModelBuilder connections. Highlight this and select the Sync Out button. This will update the spreadsheet with the demand data from your model. Save this file.

The data is now in a format where the user can use ModelBuilder to import the data into their model, using the steps in the following link: Importing Demands from a Spreadsheet.