(sometimes we provide two download links because it may happen that the main server / link is overloaded or slow or non responding - the files are identical. Just choose one, save to the Desktop, double click to install)
Disclaimer: to our best knowledge this download comes from a website that is
safe (the last time we checked it, it was), but for your peace of mind (and better safe than sorry) we advise you to run an
antivirus on the downloaded file. Do not rely on MSWindows, Internet explorer, or on the electronic signature: a unsigned download is usually as safe as a signed one, signed just means the author paid Microsoft or Verisign for a stamp, it does not mean verified. Please kindly
report us problems with detail (click here to report), if any.
Premium reverse solving engine to contiguous or non-contiguous ranges in any number of Excel sheets or workbooks. Far superior to Solver
(
Premium Addin reverse solving engine to contiguous or non-contiguous ranges)
SNGSP Capability ImprovementsSNGSP 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 Measured Ull column. This column represents the ullage of the respective tank. (Ullage is a measure of the empty space above the liquid cargo in a tank - Total tank height less the height (sounding) of the cargo). The ullage for empty tank is usually an odd figure like 22.068 or 21.567, etc. The users of the program will not write this cumbersome figure to indicate empty tank, they will adopt a rule such as to enter 23 in tanks that are empty. With 23 in the measured ullage column, the volume, etc. will be zero. SNGSP will not be bogged down by this, as it will progressively increase its internal precision in an effort to detect and measure a change. Solver cannot work if start values do not change with changes as per its setup computing sub-routines.SNGSP can use the value of a referenced cell for the set-cell value. As the value in the referenced cell changes with change of the variable cells, so will the problem target value change, until an equilibrium is reached. Etc.
Addin software and excel addin software and reverse excel software and solving reverse software
Click here to start the download