Comments on: Development

By: Andrew Mason

Andrew Mason — Wed, 11 Dec 2024 22:29:54 +0000

Gary,
Thanks for your interest in SolverStudio. Your use case is, I think, covered at https://solverstudio.org/using-studio/ under “SolverStudio and VBA”. Please let us know how you get on.
Andrew

By: Gary Howorth

Gary Howorth — Sun, 08 Dec 2024 10:58:31 +0000

Hi Andrew. Looking at Solver studio to help me run a python optimization script I have already written. Was using xlwings
So looking to run a specific python script from a vba based run button
Xlwings has an object that allows me to write something like runpython(file name path)

Can I do something like this in solver studio
Ps I see from the py files in the cPython dir that you call a fixed py name to run the model. I guess I could change the python file name in the code. And use the ribbon solve button. But I would like to use a separate active x button to start the code as I’m doing other things before I run the optimization

Thanks Gary

By: Andrew Mason

Andrew Mason — Fri, 01 Sep 2023 03:51:24 +0000

In reply to Nik.

Excel’s dates are simply floating point numbers formatted to look like dates/times. You will need to explicitly convert these to Python dates by adding Excel’s “time zero” (being 0/1/1900; format the value “0” as a date to see this). Hope this helps. Andrew. PS: Dates on a Mac behave differently in Excel.

By: Nik

Nik — Thu, 24 Aug 2023 02:26:34 +0000

I am using python external in solverstudio . I defined a dictionary in edit data and it has a date component to it . Python in solverstudio does not read the date as expected and stores as a float type when converting it to a dataframe . I tried manipulating the date using pd.datetime and also making sure data is in right format in excel sheet but still I am not able to get the right date in dataframe

By: Andrew Mason

Andrew Mason — Mon, 16 Jan 2017 08:51:50 +0000

In reply to Mazlina.

Change the language to AMPL, and choose the Install AMPL Student Version menu item. Hope this helps, Andrew

By: Mazlina

Mazlina — Mon, 16 Jan 2017 03:42:55 +0000

Hi,
May I know how can I install the AMPL in my computer?

By: amas008

amas008 — Sun, 29 Jul 2012 21:17:19 +0000

In reply to Konstantin Sokolov.

I’m pleased it worked. Andrew

By: Konstantin Sokolov

Konstantin Sokolov — Sat, 28 Jul 2012 07:28:42 +0000

I install free trial version, after changing cplexamp to cplex it works. Thank you!

By: amas008

amas008 — Sun, 22 Jul 2012 21:21:53 +0000

In reply to Konstantin Sokolov.

Please to hear you are using SolverStudio. Depending on the version of AMPL you are running, you need to either choose “solver cplexamp” or “solver cplex”. I suggest you try the latter option. Cheers, Andrew. PS: Did you install the free trial version of AMPL, or do you have a full copy of AMPL?

By: Konstantin Sokolov

Konstantin Sokolov — Fri, 20 Jul 2012 20:23:27 +0000

Hello!

I interest in solving nonlinear optimisation tasks.
I have a problem with Transportation-AMPL in SolverStudio example.

## Building AMPL input file for 7 data items
## Writing constants
## Writing sets
## Writing indexed parameters
## Running AMPL…
## AMPL file: C:\Users\Konstantin\AppData\Local\Temp\SolverStudio\model.txt

Cannot invoke cplexamp: no such program.

## AMPL.EXE completed successfully.
## Results loaded for data items: flow
## Done