Font size

Importing Data from Excel

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 anyLogistix 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 City (the Name column is considered if City is not specified)
    • Country and zip Code

On 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

  1. You can import a scenario by doing either of the following:
    • Choose File > Import > Import Scenario from Excel File... from the main menu.
    • Click the Import Scenario from Excel button in the projects tree.

    The Import dialog box will open:

  2. Select the MS Excel file with the scenario data by clicking the Browse button to the right of the field and navigating to the existing file.
  3. Specify the desired name of the importing scenario in the New scenario name field if you want to change its default name.
  4. Click Advanced options if you need to modify the import parameters:

    • Tables to import — click the drop-down list to select the tables to import. All other tables will not be imported.

      If no table is selected, all tables 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.

      Prior to importing data into the existing scenario complete the action below:

      1. Explicitly specify the data to be imported in the Tables to import option, otherwise, all tables will be imported, resulting in data duplication.
      2. Remove the data from the existing scenario that is about to be updated by the imported scenario to avoid data duplication (e.g. when importing demand, clear the existing demand data).
    • Import experiments — (selected by default) if disabled, the parameters of the experiments and the defined sets of statistics that visualize data on the dashboard will not be imported.
    • Import initial states — (selected by default) if disabled, the initial states contained in the MS Excel file will not be imported. Learn more about importing/exporting initial state data.
    • Import external tables — (selected by default) if disabled, the external tables contained in the MS Excel file will not be imported. Learn how to import external tables.
    • Scenario contains formulas — (disabled by default) if enabled, anyLogistix will consider expressions defined in the template cells.

      Formulas may slow down the importing process.

  5. 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, TO):

Please note the following possible issues:

  • If you are importing a scenario into the project that lacks certain units, a pop-up message will inform you about all the missing units (and their corresponding conversions in case of user-defined units) that must be created.
  • If you are importing an Excel file that has wrong structure or is not an anyLogistix scenario at all, an error message will pop-up notifying that the template is missing data.
  • If the importing file has duplicating objects, they will be skipped. The warning message will list such objects
How can we improve this article?