Icon

Goal Seek

This aim of this workflow is to emulate the Goal Seek function of Microsoft Excel. The parameter to be varied (and the method of variation) is defined in ParameterOptimization Loop Start node, along with the goal value. These can and shouldbe customized.After a series of calculations, each using the variable paremeter, a Math Formulanode is used to determine how close the output is to the defined goal.The Parameter Optimization Loop End node tries to minimize this difference,and ouputs the best value for the parameter. Vary volume from 0 to 10with step size 0.001 and a Bayesian search strategy;use 1.5 for target valueReplace Volumein first row withvariable volumeCalculatePercentage * VolumeCalculatesum and count of Percenatage * Volume columnvalue to be optimized = sum/countOutput optimalvolume valueDetermine differencebetween value to be optimizedand optimal valueNode 34 Parameter OptimizationLoop Start Column Expressions Math Formula(Multi Column) GroupBy Math Formula ParameterOptimization Loop End Math Formula Table Rowto Variable Table Creator This aim of this workflow is to emulate the Goal Seek function of Microsoft Excel. The parameter to be varied (and the method of variation) is defined in ParameterOptimization Loop Start node, along with the goal value. These can and shouldbe customized.After a series of calculations, each using the variable paremeter, a Math Formulanode is used to determine how close the output is to the defined goal.The Parameter Optimization Loop End node tries to minimize this difference,and ouputs the best value for the parameter. Vary volume from 0 to 10with step size 0.001 and a Bayesian search strategy;use 1.5 for target valueReplace Volumein first row withvariable volumeCalculatePercentage * VolumeCalculatesum and count of Percenatage * Volume columnvalue to be optimized = sum/countOutput optimalvolume valueDetermine differencebetween value to be optimizedand optimal valueNode 34Parameter OptimizationLoop Start Column Expressions Math Formula(Multi Column) GroupBy Math Formula ParameterOptimization Loop End Math Formula Table Rowto Variable Table Creator

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: Loïc
Created at: 2020-09-21
On NodePit since: 2021-04-08
Last update: 2024-11-21
Created with KNIME version: v4.3.2

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!