Goal Seek Demo

Demonstrate use of a recursive loop to perform a "goal seek". It is a proof of concept and there are some flaws such as "what happens if we never get an answer that is "within tolerance" of the required answer. In which case the loop would continue
until the end point is reached.

A more efficient mechanism would be to "play golf", so that rather than simply iterating between low and high bounds, the algorithm would see if the current answer was "too high" or "too low" compared with the previous iteration and then adjust the next guess accordingly. Maybe that's a workflow for another day! ;-)

This workflow was created to assist in forum question:

https://forum.knime.com/t/excel-goal-seek-function-in-knime/32003

External resources

• forum.knime.com/t/excel-goal-seek-function-in-knime/32003