1
$\begingroup$

Is it possible to import data into SCIP from Excel (and then export results to Excel)? If yes, how can I do it?

$\endgroup$
1
$\begingroup$

As far as I know, SCIP has presented some useful solutions to deal with it.

  • First, by using an interactive shell, which I don't know has the capability to connect with the separate sheet software like excel.
  • The second, by using a low-level API like C/C++, python, etc. I think you could write your own model in your favorite language through the many capabilities of IDEs/code writers such as sheet read methods.
  • The third, by connecting SCIP with some of the algebraic modeling languages like GAMS or AMPL. I knew that GAMS has the last version of SCIP by default and you can easily read your separate sheet data in GAMS and solving the problem by SCIP solver.

I hope it would be helpful.

$\endgroup$
5
  • $\begingroup$ Yes very helpful, thanks a lot Mr. Omidi. Otherwise, for GAMS and AMPL, are there limits on the model size for also the open source solvers or only for the commercial ones. Also, which one would you advise me to use? I believe that AMPL is easier to learn. $\endgroup$
    – O. Sd
    Apr 29 at 21:11
  • $\begingroup$ @O. Sd, as far as I know, GAMS and AMPL are commercial softwares and whose free version is limited. At least for GAMS as I have experienced with that. The good news is, there is an optimization host that supports many of solvers, commercial and open source. Would you see neos? $\endgroup$
    – A.Omidi
    Apr 30 at 10:43
  • $\begingroup$ By using the commercial solvers in neos, will I be able to benefit these with their maximum performance without the need for commercial licenses? because I used Gurobi in opensolver with the academic but I was not satisfied with the results obtained in term of resolution time. I don't know if it will be the same in neos. Also, from what I noticed, resolving a problem in the neos server makes it publicly available, is that true? Finaly MrOmidi, is it possible to estimate in advance the resolution time of an optimization problem? Thank you again Mr Omidi for your precious help. $\endgroup$
    – O. Sd
    Apr 30 at 23:59
  • $\begingroup$ @O.Sd, as far as I know, the neos provides an academic license for many of the commercial solvers and you are being able to use them by accepting the neos using agreement (for non-commercial usage). If you have any issues, I recommend contacting the neos support team. About resolving a problem in the neos server makes it publicly available, is that true?, I really don't know. For the last question, If the problem at hand is MILP, I think it is very complicating to estimate the resolution time. $\endgroup$
    – A.Omidi
    May 1 at 11:29
  • $\begingroup$ alright, thank you again Mr Omidi $\endgroup$
    – O. Sd
    May 3 at 0:16

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.