Comments on: Help & Feedback

By: Andrew Mason

Andrew Mason — Mon, 28 Jul 2025 23:26:45 +0000

In reply to Nav.

You can, but as you note, the current version of SolverStudio does not come with HiGHS. You will need to install PuLP and Highs on your machine, and then choose this local Python installation within SolverStudio. Hope this helps, Andrew

By: Nav

Nav — Fri, 25 Jul 2025 12:57:30 +0000

Hi,
Is there any way I can use HiGHS solver with solverstudio? It’s much faster than CBC for my use case.

By: Andrew Mason

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

In reply to Gary Howorth.

Thanks for your interest in SolverStudio. Your use case is, I tink, 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 — Mon, 09 Dec 2024 09:37:38 +0000

Im looking at solverStudio for a small internal project. I already have a python script that i will need to run in cypython as it has a number of import statements that are not in iron python. I want to run the script (mainly pyomo with other calculations and preprocessing elements) off an active x button in the sheet rather than the solve button in the ribbon. Could i do that ??. Im used to working with xlwings which has a runpython function associated with its object model

By: Jack

Jack — Tue, 27 Aug 2024 21:44:45 +0000

Hi, I’m using SolverStudio to develop optimization models in GMPL/GLPK. Recently, I was wondering how can I define solver options such as ‘mipgap’ or ‘tmlim’? I know how to do it by running glpsol.exe in command terminal, but it would be much more convenient if I could do it directly from Excel file. In the example files I found that in AMPL you can use ‘option’ command to pass solver parameters, but it doesn’t seem to work in GMPL. Thanks for help!

By: Christian

Christian — Thu, 15 Aug 2024 15:46:29 +0000

In reply to Andrew Mason.

Thanks for the info, Andrew. I understand. Sadly, this is often a requirement.

By: Andrew Mason

Andrew Mason — Thu, 21 Mar 2024 07:43:46 +0000

In reply to Andrew S..

If you are coding in Python, you should use PuLP, and not OpenSolver…. it will be much easier. Andrew

By: Andrew S.

Andrew S. — Sun, 10 Mar 2024 21:17:19 +0000

Hi, I’m new to SolverStudio but I’ve used OpenSolver in the past. When I used OpenSolver, I used it with a spreadsheet where I had written the names of around 20 people and was using the model to match them to around 15-20 tasks based on a grid of numbers representing how much each person wanted to do each task on a scale from 1-5. I optimized a variable representing the total amount of “satisfaction”, which was higher for each person if they were assigned tasks that they had a high preference number for. So it was not an incredibly complicated model but not the simplest one either.

My question is related to building such a model using external code. I would like to build a GUI (preferably in Python using PyQt5) where a user can enter the above information, and then behind the scenes, an Excel file will be generated along with the SolverStudio model, the model will be solved, and then the GUI will display the results. I have been able to fairly easily generate the Excel file using Python’s openpyxl module, which allows you to generate and edit Excel files from a Python script. I’m wondering if anyone here knows a way to generate and solve a linear programming model in Excel from a script (preferably Python) using SolverStudio or OpenSolver. Any advice or resources related to this would be greatly appreciated. Thansk in advance for your help!

By: Andrew Mason

Andrew Mason — Mon, 20 Feb 2023 07:29:40 +0000

In reply to German.

Thanks; this has been fixed.

By: Andrew Mason

Andrew Mason — Mon, 20 Feb 2023 07:28:55 +0000

In reply to Renaud.

Thanks for those good error reports and the suggestions for improvements. I will add them to my (always long) ToDo list. Thanks for the detailed feedback. Andrew