About Excel Addin

Before you can use MOS addin, you should make "mos.xll" available in excel.

1.  Data Format

xll_fmt.JPG (16775 bytes)

 Type definitions
Variable
  • Integer:   " Int" / a negtive number
  • Real Number: "Real" / a positive number / zero / empty
Objectives
  • Minimization: "Min" / a positive number / zero /empty
  • Maximization: "Max" / a negtive number
Constraints
  • <=0:   "<" or  empty or posiitve number
  • >=0:   ">"  or a negtive number
  • ==0:  "= =" or  zero

2. MoS Interface

xll_dlg.jpg (27405 bytes)

 Functions of buttons
run.jpg (876 bytes)/"Run" Run the selected optimization algorithm
run_problem.jpg (914 bytes)/"Test" Test the problem
"Random" Randomly generating variable inputs according to lower and upper boundaries
run_stop.jpg (938 bytes) Stop the running optimization algorithm
alg_set.jpg (951 bytes) Select algorithms (Double-clicking the algorithm list)
"Hide" Using a Thread for running.

 

3. Examples

4 Related Page: