It turns out that I had made a copy and paste error with the CLBM values, which is probably why Excel Solver wouldn’t converge - the numbers made no sense. When I corrected these and used the starting point that @ronlawrence3 gave me, I ended up with:
| Excel | ||
|---|---|---|
| Maslow_tlX | -49.00 | |
| Maslow_tlY | 2424.06 | |
| Maslow_trX | 2450.42 | |
| Maslow_trY | 2408.20 | |
| Maslow_blX | 0 | |
| Maslow_blY | 0 | |
| Maslow_brX | 2449.24 | |
| Maslow_brY | 0 | |
| Max Error: | 0.97 | Relative to centroids |
| Avg. Error: | 0.50 | Relative to centroids |
| SSE: | 10.76 | |
| ‘Fitness’: | 1.310002688 |
…which is pretty good.
I notice that in @ronlawrence3 's message the CLBM values have a lot more terms than the ones in @bar 's message, although they started out with the same values. I used the shorter set in @bar 's message - was that what you all intended? Let me know.