Challenge #73: Plinko Probabilities

[kelly_gilbert]

Whew, I've been sitting on this one for a while, as I struggled to figure out how to handle the edges of the board. In the end, my workflow isn't generalizable beyond a 5-slot x 9-level board, but I spent way too much time on it and had to reach a reasonable stopping point!

Révélation

I calculated the probabilities for each position using the "bottom" row of Paschal's triangle, based on the number of board levels entered by the user. I then attempted to reassign the probabilities for columns that were off of the board.

Example for slot #2, unadjusted triangle:



Example for slot #2, adjusted for edges:

Révélation

My workflow:









Output report:

[TimothyManning]

Révélation

Outside the macro:


Inside the macro:

I couldn't figure out where to start, so I ended up using @SeanAdams' and @Natasha's solutions as a starting point. I then made it my own, using three generate rows tools to find all possible combinations. I used the Rand() function to decide whether the ball went left or right, excluded any positions that were impossible (such as left of position 1), then ran it through an iterative macro 25000 times to get the following output!

[hanykowska]

I really enjoyed this one! Nice to have Pascal's triangle refresher 😄

Révélation

For some reason, I can't upload the file with my solution... 

[RolandSchubert]

Decided to use a very simple approach.

Révélation

Generate Rows tool to create possible combinations for row/col, each second row needs
correction for first and last col
Probabilities calculated based on final counts

Révélation

[ConradW]

Révélation

My first iterative macro in a while. A good fun problem to solve!

[TonyA]

I didn't read any of the spoilers and went for a pretty brute force approach. Looking at what other people have done I think my solution was similar to Patrick Digan but my results line up with many of the others. 

[RWvanLeeuwen]

I have one slight glitch in one of my workflows

Révélation

(breaking out of the loop didn't work somehow)

Anyways, I

Révélation

rebuild the board and run an iterative macro.

And overall it looks like

Révélation

any feedback on this error would be greatly appreciated

So in detail I built this

overall boardbeginning of the boardend of the board (where I get an error somehow, but this only results in running the maximum amount of iterations)

[hanykowska]

Just reattaching my workflow

[T_Willins]

My solution.  Would convert multi-row formula tools to a macro to make this more dynamic (such as user can choose number of peg rows, slots, etc).

Révélation