I think we all agree that this was a seriously hard challenge. Thanks @MattD! I've enjoyed looking thru the other solutions and being Inspired by what I've seen.
I'm a little short on billable work right now so I took another crack at Plinko Probabilities. In my previous post, I solved this challenge by using a pathways method and an iterative macro to calculate the number of paths to the bottom. In this solution, I’m using the formula n! / r!(n-r)! to calculate Pascal’s triangle for the bottom row - no macro needed. A number in Pascal’s triangle can be found by nCr (n Choose r) where n is the number of the row and r is the element in that row. This workflow allows you to solve for a variety of ranges in number of slots and levels to the bottom. Same goes for my previous workflow. Again, the tricky issues come up with the edges and how to fold them back to get the correct numbers at the bottom row. Excel to the rescue in terms of modeling the solution and then figuring out how to translate it to Alteryx. It's amazing what you can accomplish using both programs. The workflow does not have instructions or descriptions and currently only solves for one drop at a time. I tested it for many, but not all scenarios, and it provided the correct %'s each time. I believe both these solutions are like my girls - beautiful, challenging, inspiring, frustrating (at times) and I’m equally proud of both. Please feel free to PM me If you have any questions on either solution.
Note: I added an output to a csv file to the app and is now working fine.
I actually learned a lot about Pascal's Triangle from this weekly challenge.
Calculation of the probabilities is based on the 9th line of the Triangle. Please see below result.
I am an Alteryx beginner, but hopefully the result is correct.
If the chip starts in slot #4 (4th slot from the left hand side at the top):
My solution is a little different than those posted (seems that many folk have been inspired by Inspire to use Pascal's triangle).
Here's the dope:
I guess i approached this slightly differently than others. Used a few nested macros.
This is by far is the most difficult challenge I've done. I struggled a lot with math and I got stuck trying to to find a more visual solution, and it is hard to top @PhilipMannering's beautifully constructed Plinko board.