Challenge #168: Dice Game - Born to Solve

[cplewis90]

This is such a great idea to get the thoughts of how someone solves a problem! I am so sad I missed this! Excellent work @patrick_digan and @estherb47! Definitely a fun challenge!

Révélation

[Claje]

This was an interesting one!

Révélation

I think I definitely overcomplicated the flow.  Looking at some other solutions, there are definitely good ways to solve this using a more condensed flow.  I like my answer because it should be completely dynamic and it uses the Sample tool to exclude the lowest die, and then uses a join to get the data back.  This is certainly a slower solution than many of the others posted.

[Eduardo_Pavan]

My solution certainly takes a lot longer but it is more hands on and fun!

Révélation

[ryangensel]

Révélation

I was actually present during this session at Inspire. Without it, I probably wouldn't have used the "tile" tool in my solution.

[garthn555]

Révélation

My go at this....now to check other solutions !

[Alekh]

Tried it with transpose, cross tab and then straight formula too.

Révélation

[bnelly1987]

My route seems a bit different from what I am seeing on here. I've always liked the Cross Tab and Transpose tools.

Révélation

[garthn555]

After I get spoilers working properly :(

[Alekh]

@garthn555 You can edit your response (clicking the ... icon on the top right of your response) and drag the image into the spoiler box.

[T_Willins]

You can actually just logic why the solution cannot be 36.  Since the last number (smallest) is added, the product of the first two can be no smaller than 30 and no larger than 35 (last die cannot be greater than 6 or less than 1).  Factoring the numbers between 30 & 35 leads to only one number that has 2 paired factors between 1 & 6:  30, with a factor pair of 5 & 6.  Given the constraint that the added number must be less than or equal to the lower number the maximum result with a product of 30 is 35 (6*5+5).