Challenge #154: Permute the Data

[karlhansen]

I just posted a different solution -- works for a number of conditions (I tested up to ten).

Karl Hansen  2024-08-22 (page 13?)

[Erin]

I liked this one! 

Spoiler

[Bobbyt23]

Not dynamic but could be changed to a Macro to handle the different amounts of inputs.

[lwolfie]

Making some progress on a quiet Monday.

[Carolyn]

Solved! That was the most fun I've had with a challenge in awhile!

Spoiler

I initially solved it in a non-dynamic way.

Then I went back. Each Tool has 2 possible status - On or Off. With 3 Tools, there are 2^3 combinations = 8. With 4 Tools, it would be 2^4 = 16. I did a Generate Rows starting at 1 going until it hit 2 ^ [number of records]

From there, I subtracted 1 from each Row Count number (probably should've done it in the Generate Rows) and converted it to Binary, padding left with "0"s. Then I split that to Rows, added in some Tool Names from the Input, and voila! 

[RebekaMazuchova]

I spent a lot of time on a macro solution, which would make it more dynamic. But I had to give up :(