Hi All,
I am trying to minimize a function with two integer variables and two continuous variables in excel. i want to use ALGLIB's "minlmcreatev" function( VBA code preferred) to solve this. can you please help me in this problem.
i was trying to solve the problem but i haven't found the function minlmcreatev
Here is the problem details:
Sheet: Residue
Minimize Cell: H8
by changing cell : B2:B3 , Integer from 1 to 25
by changing cell : B4:B5 , continuous from 0.5 to 0.9999
constraints: B2<B3
I have attached the excel sheet for your reference, please help me to solve this problem.
| Attachments: |
Fenske Example_R7.xlsx [245.74 KiB]
Downloaded 1984 times |