Installing and Using OpenSolver for Excel (Mac and Windows)

[@martimmoliveira]

THANKS!! Was struggling to open the .pkg but you helped a lot!

[@sandipankarmakar]

Hello Professor Tallis... OpenSolver has really opened up the horizon of solving the LPPs using excel of any size in terms of number of variables and number constraints as well... But one problem is that for big size problems writing down the constraints in concrete form (borrowed from pyomo parlance) is really challenging and error prone... Do you have any idea by which the abstract forms of the constraints can be written down?

[@TallysYunes]

Good question. I think this addresses the issue you're talking about: solverstudio.org/

[@sandipankarmakar]

@@TallysYunes Hello Professor, I checked the reference you gave... Thanks a lot... It will generate the AMPL code I believe... But is the reverse possible... I have to check... BTW thanks again...

[@lanchidaongoc]

Thanks a lot

[@TallysYunes]

Happy to help!