Weekly Challenges
Solve the challenge, share your solution and summit the ranks of our Community!Also available in | Français | Português | Español | 日本語
IDEAS WANTED
Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEA
Not the most efficient way, but dynamic for Number of tools and number of toggles.
Spoiler
Macro:
Example with 4 tools and 3 toggles:
Whew!
That was a good workout. I hate hard-coding values, so I made mine as dynamic as possible.
Spoiler
If you pivot the output data you may notice a pattern: each permutation can be viewed as a binary (in this case) representation ON/ON/ON = 111, for instance. With that observation, I set about counting the number of possible permutations = [Number Configurations]^[Number of Options] = 2^3 = 8 in this case.
I then needed to convert the numbers 0 through 7 into binary, which is what the macro does, padding each number with zeroes to the left to give it the necessary length.
I didn't perform extensive testing, but I'm pretty sure my converter macro will work up to Base 9. Not actually sure what happens if you try Base 11+, since those need new characters...
With the base conversion done, standard tools come into play: tokenize by rows, do some joins, and bada bing.
Very good challenge!
I then needed to convert the numbers 0 through 7 into binary, which is what the macro does, padding each number with zeroes to the left to give it the necessary length.
I didn't perform extensive testing, but I'm pretty sure my converter macro will work up to Base 9. Not actually sure what happens if you try Base 11+, since those need new characters...
With the base conversion done, standard tools come into play: tokenize by rows, do some joins, and bada bing.
Very good challenge!
On a spree to binge complete weekly challenges
Adrenaline rush
Spoiler
Solved the easy way. Might want to build a iterative macro to make it dynamic
Don't need many tools, but thinking through how to implement the logic is a bit of tricky, anyway, successfully finished the challenge with dynamic number of options using a little iterative macro
