Hi, new OneSolver user here. I can download the zip file and run it but my current version of excel (office 365) won’t touch it since it contains macros. I use Windows 11. I have tried the obvious such as going to excel’s Trust Center and relaxing Mother Microsoft’s protections but excel still thinks the xlam file contains dangerous macros. Any help would be appreciated. Also, I am an independent researcher, I no longer have corporate overlords to blame:).
Did you mark the .zip file as safe before you extracted the files as detailed in the download instructions? It must be possible to open .xlsm files in every iteration of Excel; that is a core Excel capability. Andrew
In OpenSolver for Google Sheets, how can I set the constraint to be a sum total of the input variable cells, instead of for each cell? ie. I have cells A1:C1 = D1 in my constraints. D1 is 5. I want the sum of A1:C1 to be the constraint, not have each cell a max of 5 as it is currently doing.
I am using OpenSolver for my thesis. I have 45,000 variables. I have reduced the number of constraints to try and save solving time. The program quit after 7 days, are there recommendations to stop this from happening. Would changing the solver engine help with the solver time?
I would not use Excel for a problem with 45k variables. But, if you have no other choice, then delete everything off the sheet except the bare minimum needed to solve the problem. (And delete any other sheets.) You should also look at SolvetStudio or PuLP or GurobiPy. Cheers, Andrew
Hi, new OneSolver user here. I can download the zip file and run it but my current version of excel (office 365) won’t touch it since it contains macros. I use Windows 11. I have tried the obvious such as going to excel’s Trust Center and relaxing Mother Microsoft’s protections but excel still thinks the xlam file contains dangerous macros. Any help would be appreciated. Also, I am an independent researcher, I no longer have corporate overlords to blame:).
Thanks
Did you mark the .zip file as safe before you extracted the files as detailed in the download instructions? It must be possible to open .xlsm files in every iteration of Excel; that is a core Excel capability. Andrew
In OpenSolver for Google Sheets, how can I set the constraint to be a sum total of the input variable cells, instead of for each cell? ie. I have cells A1:C1 = D1 in my constraints. D1 is 5. I want the sum of A1:C1 to be the constraint, not have each cell a max of 5 as it is currently doing.
You need to create a cell containing SUM(A1:C1) and apply the limit of 5 to this using a constraint. Andrew
I am using OpenSolver for my thesis. I have 45,000 variables. I have reduced the number of constraints to try and save solving time. The program quit after 7 days, are there recommendations to stop this from happening. Would changing the solver engine help with the solver time?
I would not use Excel for a problem with 45k variables. But, if you have no other choice, then delete everything off the sheet except the bare minimum needed to solve the problem. (And delete any other sheets.) You should also look at SolvetStudio or PuLP or GurobiPy. Cheers, Andrew