Phew, only 4 more to go! Fun part 2 today.
Macro for part 2
Looking for some suggestions, I've checked vs @patrick_digan , the logic is the same, but I cannot figure out what's wrong with my macro. It under-counted a lot of results.
Idea is to iterate through each round, count the combinations.
@LiuZhang check your text input in your workflow, I think you put the starting position for player2 into their score.
Great, thanks.
After 2 hrs constantly changing the formula tool, it's the text input was wrong. The irony of it.
Well, at least today's doable compare to the weekend.
Happily playing golf for part I...only to find out part II... then iterative it was.
A similar approach to those above for the grouping. Although a lot less neat
For part 1 I went with a generate rows that was fun to build that keeps track of points for players, current position, last_advance, number of rolls.
Because of the deterministic dice we know that the first roll is 1+2+3 --> advance 6; the next is 4+5+6 --> 15 == advance 5;
1+2+3 --> 6 == 6
4+5+6 --> 15 == 5
7+8+9 --> 24 == 4
..... 33 == 3
42 == 2
etc, so no need to keep track of the actual numbers, just know that the next turn the marker will advance one square less.
This was a fun one - and I just got tripped up on a < vs. <= issue - thank you @patrick_digan for posting your full solution so that I could use yours to cross-check and find my error.
:-) I've included @patrick_digan 's macro that I used to find my error in this. You can see that it's pretty straighforward.
Also relatively simple - all the work is done in the formula tool in the middle which updates the scores.
thanks @patrick_digan again for the workflow. it simple and work well.
P2:
i already have idea to do by group as flash fish. but i can't figure how....
thanks patrick once again. it countless time that i referred to your workflow.