List of Contributions

Farahanim Misni

Contact Details

My Content

1 to 20 of 24 total

Why there is 'no value' in the output Attachments

Posted By Farahanim Misni Mon October 04, 2021 11:48 AM
Found In Library: Decision Optimization
#DecisionOptimization

RE: Why there is 'no value' in the output

Posted By Farahanim Misni Mon October 04, 2021 11:48 AM
Found In Egroup: Decision Optimization \ view thread
Hi,Here is the file.dat SheetConnection excelsheet("Exceldata.xlsx"); depot from SheetRead(excelsheet, "Sheet1!CN86:CN91"); customer from SheetRead(excelsheet, "Sheet1!CN1:CN85"); node from SheetRead(excelsheet, "Sheet1!CN1:CN91"); vehicle=("V1", "V2", "V3", "V4", "V5", "V6"); dist from SheetRead(excelsheet, ...

RE: Why there is 'no value' in the output

Posted By Farahanim Misni Mon October 04, 2021 10:24 AM
Found In Egroup: Decision Optimization \ view thread
Hi,I already tried to check the conflict and the relaxation on the model by referring to the link that you gave to me but it does not appear. I cannot detect which part of the model is in conflict. Is there any other way to find it?Thank you. Regards.

Why there is 'no value' in the output

Posted By Farahanim Misni Mon October 04, 2021 03:39 AM
Found In Egroup: Decision Optimization \ view thread
Hello and Good day, I have a question here.First I tried to run the model with the small data set, and I get the optimal solutions. However, when I used the same model but with the bigger data set, the output for the decision variables are appeared to be 'no values'. What it does means? Is it because ...

RE: How to import Excel data to CPLEX

Posted By Farahanim Misni Fri March 12, 2021 03:07 AM
Found In Egroup: Decision Optimization \ view thread
Is it because of my version? I used CPLEX version 12.10.0. Or can I upgrade my version of CPLEX without reinstalling it? Thank you. Regards. "Think Green. Keep it on the screen. If printing is necessary, please print it on both sides." The information contained in this e-mail message and ...

RE: How to import Excel data to CPLEX

Posted By Farahanim Misni Thu March 11, 2021 11:30 PM
Found In Egroup: Decision Optimization \ view thread
Hi,I think something is wrong with my excel file. Still until now, CPLEX has a problem accessing my Excel file. Can I import other types of files such as csv files from Matlab to my CPLEX?I think I cannot extract any data from my Excel. I need to do some other alternatives. Thank you. Regards. On ...

RE: How to import Excel data to CPLEX

Posted By Farahanim Misni Sat February 27, 2021 02:23 AM
Found In Egroup: Decision Optimization \ view thread
Hi,Actually I already changed the name according to Alex's suggestion but still got the same problem which is "problem accessing excel file". I tried to do a new opl project and create a new excel file, but still didnt work as well. Is it because of my excel file or my programme system in my laptop? ...

RE: How to import Excel data to CPLEX

Posted By Farahanim Misni Mon February 22, 2021 09:18 PM
Found In Egroup: Decision Optimization \ view thread
I already put the Excel file in the same location of the project file. However it is still not working. Here I attach the file.mod , file.data and also the Excel file to be checked if something wrong that i did in the coding. Thank you. Regards. file.mod: (string) depot=...; (string) customer=...; ...

How to import Excel data to CPLEX Attachments

Posted By Farahanim Misni Mon February 22, 2021 09:17 PM
Found In Library: Decision Optimization
#DecisionOptimization

How to import Excel data to CPLEX

Posted By Farahanim Misni Sat February 20, 2021 05:41 AM
Found In Egroup: Decision Optimization \ view thread
Hi, I have a question. I tried to import Excel data to CPLEX but it doesn't work. There is a problem accessing the Excel file. Can anyone help me how to solve this problem? Here I give the file.data of my file depot=("D1", "D2"); customer=("C1", "C2", "C3", "C4", "C5", "C6", "C7", "C8", ...

RE: Linearization in objective function

Posted By Farahanim Misni Sat November 21, 2020 06:28 PM
Found In Egroup: Decision Optimization \ view thread
Thank you so much. Finally it works. I got the optimal solution. Thanks again for your help. Regards. "Think Green. Keep it on the screen. If printing is necessary, please print it on both sides." The information contained in this e-mail message and any accompanying files is or may be confidential. ...

RE: Linearization in objective function

Posted By Farahanim Misni Thu November 19, 2020 06:05 PM
Found In Egroup: Decision Optimization \ view thread
Here is the dat file depot=("D1", "D2"); customer=("C1", "C2", "C3", "C4", "C5", "C6", "C7", "C8", "C9", "C10", "C11", "C12" ); node=("C1", "C2", "C3", "C4", "C5", "C6", "C7", "C8", "C9", "C10", "C11", "C12", "D1", "D2" ); vehicle=("V1", "V2"); dist=[[0.0 5.1 10.2 17.1 26.2 4.1 11.7 8.5 14.6 23.4 ...

RE: Linearization in objective function

Posted By Farahanim Misni Thu November 19, 2020 09:36 AM
Found In Egroup: Decision Optimization \ view thread
Here is my coding in CPLEX. My nonlinear objective is actually on the setup cost where the Q[i] is the decision variable. But this decision variable also appears in a holdinginventory cost. using CP; execute ( cp.param.timeLimit=6400; ) (string) depot=...; (string) customer=...; (string) vehicle=...; ...

RE: Linearization in objective function

Posted By Farahanim Misni Thu November 19, 2020 09:09 AM
Found In Egroup: Decision Optimization \ view thread
I did not get an optimal solution means my solution is not optimal. and because the computation time is also too long even for the small data size, I need to use cp.limit time to stop the iteration. Did I do the right thing? "Think Green. Keep it on the screen. If printing is necessary, please ...

RE: Linearization in objective function

Posted By Farahanim Misni Thu November 19, 2020 08:54 AM
Found In Egroup: Decision Optimization \ view thread
Sorry for asking this, if I am using CP for my nonlinear function in my CPLEX, I did not get an optimal solution in my problem. Is it possible to get that solutions? ------------------------------ Farahanim Misni ------------------------------

RE: Linearization in objective function

Posted By Farahanim Misni Thu November 19, 2020 08:52 AM
Found In Egroup: Decision Optimization \ view thread
If I am 'using CP' for my nonlinear function in the CPLEX, is the solution that I will get will not be as good as a linear function? I get the non-optimal solution in my problem. "Think Green. Keep it on the screen. If printing is necessary, please print it on both sides." The information ...

RE: Can CPLEX solve a problem with a logarithm in the objective function (e.g. optimize entropy)

Posted By Farahanim Misni Thu November 19, 2020 08:37 AM
Found In Egroup: Decision Optimization \ view thread
May I know, why the constraint become log(x)<=2.5? ------------------------------ Farahanim Misni ------------------------------

Linearization in objective function

Posted By Farahanim Misni Sun November 08, 2020 09:40 AM
Found In Egroup: Decision Optimization \ view thread
Hi, I want to ask about linearization in my objective function since my objective is nonlinear function. Is there any example how to linearize the fraction function (example 1/x) in cplex since the cplex can't solve the nonlinear function. Thank you. Regards. ------------------------------ Farahanim ...

RE: Download CPLEX academic version

Posted By Farahanim Misni Thu June 25, 2020 07:34 PM
Found In Egroup: Decision Optimization \ view thread
Hi, I'm not sure whether your problem is same with mine. But I could download it once I used different browser. You can try it. I used chrome. ------------------------------ Farahanim Misni ------------------------------

RE: Piecewise function for solving nonlinear objective function

Posted By Farahanim Misni Tue June 23, 2020 10:25 AM
Found In Egroup: Decision Optimization \ view thread
Hi Alex, I just saw the link that you gave to me. May I know for that example, how can we set up the values of first and last slope and how to set the value of piecewise , , in that example. For example one of my objective function is sum(i in depot, j in customer)(D[j]-R[j])*y[i][j]/Q[i]. You said ...