SNGSP Capability Improvements
SNGSP can work with multiple variable cells, in multiples of sheets in multiples of open workbooks. Up to 64000 cells in multiple ranges may be incorporated into the problem - but that figure can be increased or lowered to suit business strategy. Those cells, if selected, but do not relate to the target cell by formulae or functions, will be automatically ignored. Upper and lower bounds may be set individually for each range. Solver cannot work with multiple worksheets/workbooks.
SNGSP can work with protected workbooks, Solver cannot.
SNGSP can/will alter its internal precision differently for each variable cell in an effort to find a solution (in case the user has incorporated the Round, etc. functions in his/her workbook).
SNGSP does not get bogged down if the starting values are such that the "set up" sub-routine does not detect a change in target cell value. For example: See the image in http://cargocal.com/Interface.html and look at the Measure ...