We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!Submit Feedback
Excellent, @MarqueeCrew ! Where I'm struggling though is how can you make it handle more than two toggles (on/off, e.g.) IntToBin is wonderful for 2 choices, but how can we make this work for 3, 4, 5 different answers for each option?
Good point. When I created this, I knew that I could handle the permutation calculation quickly enough. I didn't think through how to create the states so fast. I suppose that I'd have to do something like the append fields trick or multi-row to handle the appropriate state answers.
Here's my second pass at it with a custom iterative macro that does IntToBaseN().
@MarqueeCrew, I really like the simplicity of your solution in the sense that it's a clean way to do the math without brute-forcing it with nested append tools like I did. I'm curious to know why you wrote your formula the way you did in Formula Tool (50). Couldn't you just leave off the "-1"? It looks like you account for it in your Generate Rows (40) by having your initialization expression at "0". I'm wondering if there's a reason you did it this way. Also, the Concat Options is clever. I think if I had thought of that from the beginning of my solution, things would have turned out differently - I seem to remember banging my head against the wall yesterday as I have all the results themselves concatenated as "Off,On,Off" (etc.), but was stumped at to how to break out the actual tool labels. Definitely one of those "so obvious, why didn't I think of that". Good experience to implement in future workflows, thanks!