Step 4: Export Data
SAInt GUI has a range of export options that allow the user to extract network and scenario-related data. For scenarios, the stored results of an executed scenario can also be exported to various file formats (e.g., PDF, CSV, Excel, etc.). This tutorial focuses on exporting network and scenario data and also some base results using SAInt GUI export results option.
1. Network data
A network in SAInt can be exported to an Excel file. The exported file is used to edit any network object property or add/remove network objects. Once the changes are made, the exported network file can be imported back into SAInt using the option from the network tab. You will first export the network from the first beginner tutorial to an Excel file. Start by opening the network GNET_Tutorial. Go to the network tab and click . When prompted to Select import file save location, navigate to your preferred location, type the filename, and press Save. Once the network file is exported, a message box notifies of the export status and location of the saved file, and the Excel file will be automatically opened.
Similarly, a network parameter file can be exported by clicking on from the network tab. The parameter file contains the list of all the network objects with their respective property values, which can be changed. Once the property values are changed, the same file can be imported back into SAInt using the option from the network tab. This action updates all the property values in the existing network.
|
The parameter import option for the network is only visible when no scenario is loaded into SAInt GUI. |
2. Scenario data
The scenario related data, which includes results, events, profiles, network state, and state transfer events (dispatch and commitment), can be exported from SAInt GUI into different file formats. All the export functions for the scenario can be accessed by clicking on Export from the scenario tab. This section only focuses on the export of scenario results.
|
Please refer to the data export section of the reference guide for more information on exporting the network and scenario data and export file formats. |
Once a scenario is executed, the stored results for a set of user-defined result variables can be exported to an Excel file. The result variables are defined in the Results Description File, which can either be a text, CSV, or an Excel file. The result variables are defined using the object parameter (ObjectType.ObjectName.PropertyExtension.[Unit]). Create a results description file to extract the active power generation of all the generators and the demand not served at the network level. Open a new Excel file and type the object identifiers in separate rows as shown in Table 1.
|
|
|
After entering all the above object identifiers, save the results description file at your preferred location. Next, return to SAInt, go to the scenario tab, and click on . If the option is not available, just load the dynamic scenario of the beginner tutorial. When prompted to Choose Result Description File, select the previously saved excel file and press Open. Once the results description file is selected, another dialog box appears to Choose Result Output File. Go to your preferred location to save the results file and type the name of the output results file name. After pressing Save, a message box states that "Export all results may take a while to finish. Are you sure you want to continue?". Press Yes and wait for the results to be exported. Once all the results are exported, a message box notifies of the export status and the location of the results output file.
Click here to view the exported results file.
| Time [sec] | DateTime [dd/MM/yyyy HH:mm] | GSUP.SUPPLY1.Q [ksm³/h] | GDEM.DEMAND1.P [bar-g] | GDEM.DEMAND1.Q [ksm³/h] |
|---|---|---|---|---|
0 |
2/1/2020 6:00 |
200 |
34.97678796 |
100 |
900 |
2/1/2020 6:15 |
200.1328628 |
34.97446409 |
100 |
1800 |
2/1/2020 6:30 |
200.3851167 |
34.96968695 |
100 |
2700 |
2/1/2020 6:45 |
200.710031 |
34.96323646 |
100 |
3600 |
2/1/2020 7:00 |
201.0730794 |
34.95583293 |
100 |
4500 |
2/1/2020 7:15 |
202.1290641 |
34.87058808 |
101.25 |
5400 |
2/1/2020 7:30 |
203.5882987 |
34.76427993 |
102.5 |
6300 |
2/1/2020 7:45 |
205.2170454 |
34.64997009 |
103.75 |
7200 |
2/1/2020 8:00 |
206.9109442 |
34.53174033 |
105 |
8100 |
2/1/2020 8:15 |
208.0352436 |
34.49055938 |
105 |
9000 |
2/1/2020 8:30 |
208.8315781 |
34.4685847 |
105 |
9900 |
2/1/2020 8:45 |
209.4961627 |
34.45253966 |
105 |
10800 |
2/1/2020 9:00 |
210.1138133 |
34.43841599 |
105 |
11700 |
2/1/2020 9:15 |
210.684492 |
34.42547816 |
105 |
12600 |
2/1/2020 9:30 |
211.2210513 |
34.41334842 |
105 |
13500 |
2/1/2020 9:45 |
211.7376847 |
34.40170083 |
105 |
14400 |
2/1/2020 10:00 |
212.2438323 |
34.39030673 |
105 |
15300 |
2/1/2020 10:15 |
211.344486 |
34.5410988 |
102.5 |
16200 |
2/1/2020 10:30 |
209.5393911 |
34.73309111 |
100 |
17100 |
2/1/2020 10:45 |
207.3101288 |
34.93598822 |
97.5 |
18000 |
2/1/2020 11:00 |
204.8998369 |
35.13950994 |
95 |
18900 |
2/1/2020 11:15 |
203.7142994 |
35.19341652 |
95 |
19800 |
2/1/2020 11:30 |
203.2529369 |
35.21059664 |
95 |
20700 |
2/1/2020 11:45 |
203.0874685 |
35.21636015 |
95 |
21600 |
2/1/2020 12:00 |
203.0299037 |
35.21832215 |
95 |
22500 |
2/1/2020 12:15 |
202.8294396 |
35.15977751 |
96.25 |
23400 |
2/1/2020 12:30 |
202.2101324 |
35.09812197 |
97.5 |
24300 |
2/1/2020 12:45 |
201.2194997 |
35.04131357 |
98.75 |
25200 |
2/1/2020 13:00 |
199.9889921 |
34.98843659 |
100 |
26100 |
2/1/2020 13:15 |
198.7102993 |
35.00143105 |
100 |
27000 |
2/1/2020 13:30 |
197.668335 |
35.02118738 |
100 |
27900 |
2/1/2020 13:45 |
196.8600663 |
35.03822732 |
100 |
28800 |
2/1/2020 14:00 |
196.2015599 |
35.05227308 |
100 |
29700 |
2/1/2020 14:15 |
195.5893096 |
35.06501224 |
100 |
30600 |
2/1/2020 14:30 |
194.9864167 |
35.07733822 |
100 |
31500 |
2/1/2020 14:45 |
194.3839556 |
35.08955132 |
100 |
32400 |
2/1/2020 15:00 |
193.7805685 |
35.1017263 |
100 |
33300 |
2/1/2020 15:15 |
193.9961487 |
35.03484757 |
101.25 |
34200 |
2/1/2020 15:30 |
194.7231836 |
34.94542499 |
102.5 |
35100 |
2/1/2020 15:45 |
195.6808212 |
34.84709847 |
103.75 |
36000 |
2/1/2020 16:00 |
196.7334602 |
34.74448723 |
105 |
36900 |
2/1/2020 16:15 |
197.2735069 |
34.71715588 |
105 |
37800 |
2/1/2020 16:30 |
197.5381117 |
34.70753202 |
105 |
38700 |
2/1/2020 16:45 |
197.7031748 |
34.70292845 |
105 |
39600 |
2/1/2020 17:00 |
197.8377446 |
34.69978968 |
105 |
40500 |
2/1/2020 17:15 |
198.4278743 |
34.68906123 |
105 |
41400 |
2/1/2020 17:30 |
199.4114779 |
34.67021959 |
105 |
42300 |
2/1/2020 17:45 |
200.6230334 |
34.64591781 |
105 |
43200 |
2/1/2020 18:00 |
201.9485332 |
34.61852255 |
105 |
44100 |
2/1/2020 18:15 |
201.8737608 |
34.75040109 |
102.5 |
45000 |
2/1/2020 18:30 |
200.9125493 |
34.92201188 |
100 |
45900 |
2/1/2020 18:45 |
199.5493208 |
35.10396864 |
97.5 |
46800 |
2/1/2020 19:00 |
198.0208443 |
35.28654557 |
95 |
47700 |
2/1/2020 19:15 |
197.5284186 |
35.32446418 |
95 |
48600 |
2/1/2020 19:30 |
197.5659074 |
35.33031661 |
95 |
49500 |
2/1/2020 19:45 |
197.7755975 |
35.32777153 |
95 |
50400 |
2/1/2020 20:00 |
198.0272871 |
35.32307919 |
95 |
51300 |
2/1/2020 20:15 |
199.6638502 |
35.23159435 |
96.25 |
52200 |
2/1/2020 20:30 |
202.3075449 |
35.10761368 |
97.5 |
53100 |
2/1/2020 20:45 |
205.4793352 |
34.96713931 |
98.75 |
54000 |
2/1/2020 21:00 |
208.9009247 |
34.817308 |
100 |
54900 |
2/1/2020 21:15 |
211.0718113 |
34.75260284 |
100 |
55800 |
2/1/2020 21:30 |
212.2407149 |
34.72006643 |
100 |
56700 |
2/1/2020 21:45 |
212.8336441 |
34.70360033 |
100 |
57600 |
2/1/2020 22:00 |
213.1264443 |
34.69539343 |
100 |
58500 |
2/1/2020 22:15 |
213.268884 |
34.69136406 |
100 |
59400 |
2/1/2020 22:30 |
213.337504 |
34.68940885 |
100 |
60300 |
2/1/2020 22:45 |
213.370334 |
34.68846836 |
100 |
61200 |
2/1/2020 23:00 |
213.3859615 |
34.6880189 |
100 |
62100 |
2/1/2020 23:15 |
213.0345313 |
34.62865271 |
101.25 |
63000 |
2/1/2020 23:30 |
212.0536524 |
34.5701735 |
102.5 |
63900 |
2/1/2020 23:45 |
210.5417464 |
34.52034769 |
103.75 |
64800 |
2/2/2020 |
208.6835439 |
34.47715738 |
105 |
65700 |
2/2/2020 0:15 |
206.691207 |
34.50521448 |
105 |
66600 |
2/2/2020 0:30 |
204.8859511 |
34.5420503 |
105 |
67500 |
2/2/2020 0:45 |
203.2984752 |
34.57655634 |
105 |
68400 |
2/2/2020 1:00 |
201.8602648 |
34.60788056 |
105 |
69300 |
2/2/2020 1:15 |
200.3854715 |
34.63911303 |
105 |
70200 |
2/2/2020 1:30 |
198.8443071 |
34.67125785 |
105 |
71100 |
2/2/2020 1:45 |
197.2571296 |
34.70411996 |
105 |
72000 |
2/2/2020 2:00 |
195.6447847 |
34.73729892 |
105 |
72900 |
2/2/2020 2:15 |
193.3133878 |
34.91723016 |
102.5 |
73800 |
2/2/2020 2:30 |
190.7199321 |
35.12273204 |
100 |
74700 |
2/2/2020 2:45 |
188.1006308 |
35.32884744 |
97.5 |
75600 |
2/2/2020 3:00 |
185.509119 |
35.53004532 |
95 |
76500 |
2/2/2020 3:15 |
184.384338 |
35.58035108 |
95 |
77400 |
2/2/2020 3:30 |
184.0988472 |
35.59334625 |
95 |
78300 |
2/2/2020 3:45 |
184.1538623 |
35.59465919 |
95 |
79200 |
2/2/2020 4:00 |
184.3338367 |
35.59203958 |
95 |
80100 |
2/2/2020 4:15 |
185.7234641 |
35.50742895 |
96.25 |
81000 |
2/2/2020 4:30 |
187.8917118 |
35.39624987 |
97.5 |
81900 |
2/2/2020 4:45 |
190.4246925 |
35.27320498 |
98.75 |
82800 |
2/2/2020 5:00 |
193.112993 |
35.1439193 |
100 |
83700 |
2/2/2020 5:15 |
195.0090012 |
35.09043691 |
100 |
84600 |
2/2/2020 5:30 |
196.3964522 |
35.05774757 |
100 |
85500 |
2/2/2020 5:45 |
197.549945 |
35.03252761 |
100 |
86400 |
2/2/2020 6:00 |
198.6048781 |
35.01017745 |
100 |