Hi Huron
Back in my office after the weekend.
I've made a copy of the relevant part of the sheet with data for M=5. The sub CalcSS() in the solve module for the case 5 (ie M=5) works OK with the specific code for M=5.
I have commented out the more generic code I was trying to create, with your help, for M = anything from 2 to 15. teh geenric code does not currently work. What would be helpful is getting the generic code that uses pred to work. I would then replace all the specific code for cases 2 to 15 with this (i've coded cases 2-6 so far). You may need to add in solver.xla to project references to enable solver to run.
Look forward to seeing what you can come up with.
Bookmarks