blue background


  • Optimization from Excel
  • KULI-System

    With the help of the COM interface KULI offers extensive capabilities to control a KULI simulation from other programs like e.g. Microsoft Excel. The attached files show how the built in optimization of KULI can be controlled from Excel. The Excel and KULI files are set up in a way such that also the lower and upper bounds of the optimization parameter(s) as well as the optimization target(s) can be set from Excel. The VBA script is set up in a way such that the variation of the parameters and the progress of the optimization targets are visible in Excel as well. This is particularly useful for optimizations that take a lot of time. The included demo file in this example is based on the tutorial example ExCAR and varies two optimization parameters to achieve two optimization targets. The method and script can easily be adapted to other optimization problems.

    Usable from release: KULI 13
    Necessary modules: KULI base + KULI COM

    File, 39 KB
    Please login for Download.