Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAHere is my solution. It works with different toggle options but not with different tool options (yet). Maybe it works when I add an interative macro.
a messy solution this week. with a bad base X macro that will create more problem then when it solve but wanted to get somethign in before the weekend.
Fun excercise @MarqueeCrew !
This one was deceptively challenging! At first, I questioned the Advanced tag, but realized there was more to it than I anticipated. It's interesting to see the different ways everyone has solved this.
My solution! I chose to create an app that would allow a user to enter their own choices for tools and their states. I then used an iterative macro to create the combinations for any number of tools/states.
Cheers!
NJ
I can't take much credit for this one; 6 months ago I was working on a client project with a very similar challenge, assessing fuelling options on a route (you either stop or you don't), with the objective to reduce total fuel cost by stopping at the cheapest locations.
@PhilipMannering stepped in and built the permutations solution for me which I've adopted here so it can be shared (Y)
I was able to solve it but it's not a dynamic or elegant solution. Thanks for a tough challenge!