This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
The approach here was to think about all the combinations for 1 slice first - In other words - take the numbers which are at the 12 O'clock position in each ring, and call them slice 0; then go round the circle in clockwise order then you'll find slice 1, 2,3,4,5 - For slice zero - you create every combination of the inner 5 rings - Once you know slice zero - you can derive the other slices fairly easily
The trick is to figure out the combinations by generating numbers; converting using base 6 math a set of 6 digits (each from 0 to 5). This makes it much easier than generating 1 rotation for every ring.
Once you have this, you can then do a quick lookup to find the value written on the ring, and do a simple sum.
Looking forward to reading the solutions from other folk.
It was quite difficult, but I enjoyed it. I unfortunately used 5 slightly different macros one after the other to get it to find every possible combination, but I couldn't be bothered at that point to consolidate them. Then, as I'd used a recordID + grouping in each macro, I could find the one combination where everything was in the right order. Doesn't make too much sense, but hopefully the workflow does!