Importing Scenario Data
To prepare scenario data
The scenario data that you plan to import needs to follow
certain naming and formatting conventions. To
ensure that naming and formatting are correct, you may want to create a scenario
template MS Excel file
in ALX and fill it with your own data.
The coordinates of the objects in the
importing scenarios will be automatically filled, unless:
- The coordinates are already specified in the
file (values differ from zero).
- The file contains more than 200 locations. In this case
only local coordinates storage will be used (using an online provider
will be too time-consuming). The search through local storage is
available by either of the following:
- country and name
- country and zip code
importing MS Excel file into the existing scenario, you can add
the missing data to it, but be careful.
To import scenario data from MS Excel file
Note: If you are
importing a scenario
into the project that lacks certain units, a pop-up
will inform you about all the missing units (and their corresponding
conversions in case of user-defined units) that must be created.
- You can import a scenario by doing either of the
- Choose File
> Import Scenario
from the main menu.
- Click the Import Scenario
button in the projects tree.
- Press Ctrl + N.
The Import Scenario
dialog box will open:
- Select the MS Excel file with the scenario data by
the right of the field and navigating to the existing file.
Provide the name of the new scenario in the New
scenario name field.
- Click Advanced options
if you need to modify the import parameters:
- Sheets to import
- click the drop-down list to select the sheets to import. All other
sheets will not be imported.
If no sheet
is selected, all sheets will be imported.
- Create new scenario
- (selected by default) a new scenario will be created for the
importing file. If disabled, the Scenario
name option becomes active.
- Scenario name
- (active only if the Create new scenario
option is disabled) click the drop-down list of the currently opened
scenarios to specify the scenario to import the data to.
to importing data into the existing scenario complete the
- Explicitly specify the data to be imported in the
Sheets to import
option, otherwise, all sheets will be imported, resulting in
the data from the existing scenario that is about to be updated by the
imported scenario to avoid data duplication (e.g. when
demand, clear the existing demand data).
- Import experiments
- (selected by default) If disabled the experiments contained
in the MS Excel file will not
Click OK to
close the dialog box and import the scenario data. The newly created
scenario will be located in the tab that corresponds to the type of the
imported scenario (GFA, NO, SIM,
create a scenario tamplate
A scenario template is an empty MS Excel file with proper ALX naming and formatting.
You can now fill the exported file with your own data to later import
ALX as a new scenario.
a new scenario in ALX.
records to the data tables of the
new scenario that will serve as examples of data values.
the created scenario to a new MS Excel file. The file will contain the
worksheets corresponding to the ALX data tables as well as examples of