It's me again. The spreadsheet works flawlessly on my Windows box. Thanks for the great work! And shame on Microsoft on ditching VBA on Mac...
Printable View
It's me again. The spreadsheet works flawlessly on my Windows box. Thanks for the great work! And shame on Microsoft on ditching VBA on Mac...
After some messing around, it seems that even though Solver is forced to optimize OPA, it is not forced to consider the total number of acres it is given. I ended up with it telling me to build 485 acres for a 1k acre strat.
Would there be a way to tweak the Solver Dialog so that it is forced to consider the total acres, i.e disregard the possibility of unbuilt acres?
I think I know why it's so CPU-intensice, ssteel. The troop numbers it gives have decimals. If you constrain to integers you'll simultaneously get faster and more realistic results.
Sadly, I have no idea how to program for Solver.