4 ms·

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

by mlac 5y 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-Analysis-Introduction/dp/130594741X/ref=mp_s_a_1_3?dchild=1&keywords=ragsdale+spreadsheet+modeling+and+decision+analysis&qid=1625426197&sprefix=ragsdale&sr=8-3 https://www.amazon.com/Spreadsheet-Modeling-Decision-Analysi...

mkl 5y ago
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.
- mlac 5y ago
  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