EBSILON®Professional Online Documentation
Data Transfer and Results Display / EBSILON for Excel Add-In / Excel 2003 Add-In (obsolete) / Execute selected profiles
In This Topic
    Execute selected profiles
    In This Topic

    Execute selected profiles


    Before starting the calculations we have to enter the values for the input variables. Then select Execute Selection.

    In principle EVERY function is using the saved model.  If you also want to see the results of the calculation triggered from Excel in the model file, the option flag Save model after run has to be active (default).

    NOTE: The menu commands Write Input in selection, Reset Nominal Values in Selection and Reset All Nominal Values in Selection are also saving the changes to the model.

    The internal steps in Execute Selection are the following:

    1. Open the model
    2. Execute every selected profile
      • Activate the profile
      • Write all input data to the profile
      • Simulate
      • Read all result data from the profile
    3. Save the model, if the option flag Save model after run is active.

     

    If options for multiple execution of the calculation are active, then step 2 will be repeated according to the respective global (menu command Execute plus dropdown) or local (value for @MultipleExecutionLimit) settings. This allows iterative calculations in Excel.

     

     

    After the calculations the fields @Errors, @Warnings, @Status, @ExecutionTime give detailed information concerning the status of the run.

     

    We see warnings in the column G. The text of these messages is inserted as comment and can be shown by moving the mouse to the respective cell.

    It is also possible to calculate multiple profiles at once. For this purpose we add additional columns in the range of FirstProfile and LastProfile. In our example we execute the model at different ambient temperatures and read back the gas turbine power output. The calculations shall be done in the profile OffDesign.

    First we insert additional columns

    After entering all input data and setting the profile for each column we need to select the range to be calculated and select Execute Selection.

     

     

     

    Now as the data are available in Excel it easy to generate curves or doing other work with the calculation results.