Important Community update: The process for changing your account details was updated on June 25th. Learn how this impacts your Community experience and the actions we suggest you take to secure your account here.
General Discussions
Discuss any topics that are not product-specific here.
I revisit my WF and update. I got the clear picture now. WF completes in 0.7sec.
Spoiler
<WF>
<Macro Part1>
<Macro Part2>
<Macro Part1>
<Macro Part2>
Solved. Part 1 worked beautifully but Part 2 failed spectacularly (those Joins seemed like such a good idea during Part 1), so I ended up rebuilding the workflow just for Part 2 with an Iterative Macro (which I probably should've done in the first place). Good fun
Pure brute force. The workflow ran all night and finished 20 min before the AoC Day ended.
5/5 so far.
Spoiler
Brutal
Tried to brute force part 2, then spend a crazy amount of time trying to optimise.
Finally in the evening attempted the approach of creating ranges with big jumps, and then finding the seed number and then doing +1 increments around this value, which resulted in a fast solve.
And yes I probably have should have put this in a macro!
Tried to brute force part 2, then spend a crazy amount of time trying to optimise.
Finally in the evening attempted the approach of creating ranges with big jumps, and then finding the seed number and then doing +1 increments around this value, which resulted in a fast solve.
And yes I probably have should have put this in a macro!
Spoiler 
macro for part 1
macro for part 2:
1. split to group based on the seed range
2. update the destination, source, and range
3. go for next soil etc.
i did not update the previous range, because it not required.
workflow
macro for part 1
macro for part 2:
1. split to group based on the seed range
2. update the destination, source, and range
3. go for next soil etc.
i did not update the previous range, because it not required.
My solution.
Spoiler
I completed part 2 just before sleeping. This is that workflow.
To be the honest, I was going to do debug more time, but I got the correct result. Some of this is not clear to me, but I'll leave it at that for now. But the workflow above is messy, so I remade it using Iterative macro.
Part 2 macro :
To be the honest, I was going to do debug more time, but I got the correct result. Some of this is not clear to me, but I'll leave it at that for now. But the workflow above is messy, so I remade it using Iterative macro.
Part 1 is normal brute force. But that was not working for Part 2. So I made it using range approach.
Part 2 macro :
