Goal Seek

Goal seeking is the computation of an input value, calculated backwards from a known output value to a formula. It is also known as what-if analysis.

For example, you can use it to determine the number of units that need to be sold to reach a certain amount of revenue, where the formula for revenue is equal to the selling price multiplied by the number of units sold.

The Goal Seek Function analyzes the output values of three guesses at a time: the centre stab and two equidistant values to either side. This is known as tine spacing, like the points of a fork.

The tine that results in output closest to the expected value becomes the new centre stab point and the tine spacing is doubled. This is repeated until the centre tine's output is the closest to the expected value, after which the tine spacing is repeatedly reduced until the output value matches the expected value.

With the default stab value of 0 and tine spacing of 1, the first inputs analyzed are -1, 0, and 1.

Details for an example and its configuration can be found in the How to Use section.

Goal Seek works only with one variable input value.

Pre-requisites

None at this time

Current Version

• Download the Goal Seek Function v1.41

Please contact XMPro if you're looking for an older version of this Agent.

Release Notes

Version	Date	Description
1.41	22 Jan 2025	Repackaged to translate the Agent's properties.
1.40	17 Oct 2022	Repackaged to include the Agents Category.
1.30	23 Nov 2021	Convert the initial stab value (StartingStabValue) to a drop-down to pass the value from the parent Agent or enter the value manually.
1.20	20 Aug 2021	Validate that the fields used in the formula exist in the payload. Pass the data for only those fields that are used in the formula for calculation.
1.10	28 Jul 2021	Specify the formula as input using a drop-down of string input columns.
1.00	01 Jul 2021	Initial Release.