To export all of the scenario results data sets to an Excel workbook, use the File and then Export Results to Excel menu option. Choose the desired file and choose Save. Data for all data sets and all scenarios are exported, with each data set written to a different worksheet. A sample is shown in Figure 1.10.

Within a worksheet, the first column contains the series date and times and each subsequent column contains the data for a different scenario. Values are written for the entire run range, including the initialization date. The string “NaN” (Not A Number) is written if a data set does not have a value for a given timestep or if that value is invalid.

When exporting, if the file exists, you are asked to confirm that you would like to replace it. In fact, if you do continue with the operation, only the worksheets corresponding to those being exported are overwritten, other worksheets are left as they are, and new worksheets are appended.