This was a fun one. Took me a little bit to figure out how to create coordinates for the hex grid, but after that was sorted both parts were similar to previous days.
Spoiler
workflow
iterative macro
I think my approach is similar to those above. I spent quite some time debugging why a join was not returning the correct items for numbers that was set as decimals 19.6 I couldn't figure out why so just rescaled my coordinates a little bit.
Spoiler
The decimals were throwing me off, so I changed the step from 1, sqrt(3) to (1, 173), funny shaped hex I imagine, but works
The decimals were throwing me off, so I changed the step from 1, sqrt(3) to (1, 173), funny shaped hex I imagine, but works
