Hacker News new | ask | show | jobs
by mlac 1813 days ago
So for medium to non-technical people reading this, I took a course in grad school that showed me how to do this in Excel with solver.

It was easily one of the top 3 courses I took and heavily based off of this text book:

https://www.amazon.com/Spreadsheet-Modeling-Decision-Analysi...

1 comments

There are many programming libraries that would be better than Excel, e.g. scipy implements quite a few algorithms very accessibly, but that's not what OP is looking for.
The book covered the theory well and introduced it in a way that was easy for less technical people to use. Excel was used and helped to visualize problems with two dimensions.

I would recommend that text for anyone interested in getting into optimization. Excel quickly hits limits but the concepts translate to other tools