Inputs
Plinko Probability Calculator Workflow
4
5
Paths
Int32
4
Empty
IF ABS([Branch]) > [Iteration] + 1
THEN 0
ELSEIF ABS([Branch]) = 1 AND [Iteration] = 1
THEN 1
ELSEIF [Branch] < ( [StartLane] * -2 ) + 1
THEN 0
ELSEIF [Branch] > ( [Lanes] * 2) - ( ( [StartLane] * 2 ) - 1 )
THEN 0
ELSE [Row-28:Paths] + [Row-26:Paths]
ENDIF
Count possible Paths for each Start Lane within the boundaries.
IF ABS([Branch]) > [Iteration] + 1
THEN 0
ELSEIF ABS([Branch...
[Iteration] = [Levels] * 2
AND [Paths] != 0
Custom
=
Iterations
True
fixed
2018-08-21 15:59:03
0
2018-08-21 15:59:03
2018-08-21 15:59:03
Limit records to the final Iteration where Paths <> 0.
[Iteration] = [Levels] * 2
AND [Paths] != 0
Iteration
Int32
4
1
[Iteration] <= [Iterations]
[Iteration] + 1
For every Lane, generate a row for each Iteration.
Branch
Int32
4
( [Iterations] + [Lanes] ) * -1
[Branch] <= [Iterations] + [Lanes]
[Branch] + 1
For each Lane / Iteration, generate a row for each Branch in an unbounded Plinko.
Levels
StartLane
Int32
4
1
[StartLane] <= [Lanes]
[StartLane] + 1
Generate a row for each Lane
Calculate Total (possible) Paths for each Start Lane.
Levels
EndLane
Int32
4
Empty
[Row-1:EndLane] + 1
Specify End Lane.
[Row-1:EndLane] + 1
Re-order, remove unneeded.
Join Total Paths (denominator) to each End Lane record.
Calculate the probabilities
Sort StartLane (Asc), Probability (Desc)
StartLane - Ascending
Probability - Descending
For each Start Lane, list the End Lane with the highest probability
C:\_MyDocs\MyAlteryx\Temp\Engine_12568_e9163e01a51f4ab2a077c3c06a0c74a9_\Engine_16440_7bf41fb7fe0d4a109ed86b9780264a0d_.yxdb
Single
Profile
Most Likely End Lane for Each Start Lane
Basic
100%
Best Probabilities
Basic Table
Basic
100%
All Probabilities
Basic Table
Warning
All
ByName
Summary
Detail
pdf
Table
Whitespace
1
squeeze
warning
Crosstab End Lane probabilities.
Add
Prefix
Prefix column names.
Probability Detail
Horizontal
Question
Numeric Up Down (39)
Question
Numeric Up Down (40)
challenge_73_solution_KO App
NoCondition
(Always Run)
Dynamic
{{INPUT}}
1/Data/r[1]/c[2]
Update Cell
Expression
row 1
column 2
Dynamic
{{INPUT}}
1/Data/r[1]/c[1]
Update Cell
Expression
row 1
column 1
UpdateValueFormula
ToString( ( ( ( ToNumber([#1]) * 2) + ToNumber([#2]) ) + 1 ) * 2)
14/NumRows/@value
Expression
UpdateValueFormula
"IF ABS([Branch]) > [Iteration] + 1
THEN 0
ELSEIF ABS([Branch]) = 1 AND [Iteration] = 1
THEN 1
ELSEIF [Branch] < ( [StartLane] * -2 ) + 1
THEN 0
ELSEIF [Branch] > ( [Lanes] * 2) - ( ( [StartLane] * 2 ) - 1 )
THEN 0
ELSE [Row-" + ToString( ( ( ( ToNumber([#1]) * 2) + ToNumber([#2]) ) + 1 ) * 2) +
":Paths] + [Row-" + ToString( ( ( (ToNumber([#1]) * 2) + ToNumber([#2]) ) ) * 2) +
":Paths]
ENDIF"
14/Expression
Expression
Tab
Questions
Tab (36)
NumericUpDown
Plinko Levels
Numeric Up Down (39)
NumericUpDown
Plinko Lanes
Numeric Up Down (40)
Wizard