Cap'n Squirrgle Wrote:
Solving a problem in excel that sorta can't be solved that way, I think. Nobody had tried it yet, I took it as a challenge, put 6 hours on it last night during elections, till 2. Came in this morning, and I think I got it. It's not linear, so Solver has a hard time with it, but I can't break the solution it came up with yet... can't better it.
One of those "a farmer has 120 acres, can grow wheat or corn, can buy wheat or corn too, or can sell what he grows. Can also raise pigs and chickens, which eat a certain amt of your corn, or a certain amt of your wheat, or any proper ratio btwn the two. So you have to allot his labor, his family's labor, he can hire labor, then the square footage and acreage constraints, and max profit without breaking any of the rules."
My undergrad major was a 50/50 split of IT and this stuff. I enjoyed the optimization class more than I should have.
I haven't seen Guster in years. Always a fun show.