Icon

Goal Seek Modified

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. The logic of the workflow below is exactlyas above, but the column expressionused to modify 1st row's volume isreplaced with Row Splitter, Math Formulaand Concatenation.This changes the behavior, and the result(Knime 4.3.2) Vary volume from 0 to 10with step size 0.1 and hillclimbing algorithm;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 34Calculatesum and count of Percenatage * Volume columnNode 36Output optimalvolume valuevalue to be optimized = sum/countCalculatePercentage * VolumeDetermine differencebetween value to be optimizedand optimal valueVary volume from 0 to 10with step size 0.1 and hillclimbing algorithm;use 1.5 for target valueSplit out first rowBring back togetherReplace Volume in first row with variable volume Parameter OptimizationLoop Start Column Expressions Math Formula(Multi Column) GroupBy Math Formula ParameterOptimization Loop End Math Formula Table Rowto Variable Table Creator GroupBy Table Creator ParameterOptimization Loop End Math Formula Math Formula(Multi Column) Table Rowto Variable Math Formula Parameter OptimizationLoop Start Row Splitter Concatenate Math Formula 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. The logic of the workflow below is exactlyas above, but the column expressionused to modify 1st row's volume isreplaced with Row Splitter, Math Formulaand Concatenation.This changes the behavior, and the result(Knime 4.3.2) Vary volume from 0 to 10with step size 0.1 and hillclimbing algorithm;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 34Calculatesum and count of Percenatage * Volume columnNode 36Output optimalvolume valuevalue to be optimized = sum/countCalculatePercentage * VolumeDetermine differencebetween value to be optimizedand optimal valueVary volume from 0 to 10with step size 0.1 and hillclimbing algorithm;use 1.5 for target valueSplit out first rowBring back togetherReplace Volume in first row with variable volumeParameter OptimizationLoop Start Column Expressions Math Formula(Multi Column) GroupBy Math Formula ParameterOptimization Loop End Math Formula Table Rowto Variable Table Creator GroupBy Table Creator ParameterOptimization Loop End Math Formula Math Formula(Multi Column) Table Rowto Variable Math Formula Parameter OptimizationLoop Start Row Splitter Concatenate Math Formula

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: 2022-02-06
Last update: 2024-04-26
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!