Clueless Explosions
As Ruud is not posting any new Clueless Explosions at the moment, I guess we will have to find a way to survive without… at least for the time being. I hope he’s fine and just does not find time to pursue the issue.
This is a follow-up to the forum there.
I’ve created an Clueless Explosion Template in Excel that supported me in solving the Clueless Sudokus and I’d like to share this a bit…
1st step: populate the template:
I used to copy the lines under the explosion and then just hit Ctrl-i in my worksheet “temp” which filled the sudokus in the sheet “new”. Ctrl-i called a macro that itself called again several other macros: initiateClueless
the called macros are:
Solving The Explosion
This gave me the current clueless on the “new” sheet which I copied to a new spreadsheet, renamed it to the current number and duplicated it so that the new sheet read “xx (1)”. I used this one for highlighting the 1, by typing “1″ into BK/BL-23/24.
So all 1′s in the sheet get highlighted.
now I can start solving the single Sudokus. The combinated one on the right gets filled (but not highlighted) automatically.
I then used the macro (I store them in my personal workbook so they are available for every new file I create) “yellow” to block all cells where 1 cannot be in. When I finished 1, I copied the sheet (Ctrl-Click-Drag to right) to create a “xx (2)” sheet in the file.
Then, the Macro “clear” clears all formatting from the sheet and leaves me in the field BK/BL-23/24 to put in No. 2 now…
This goes on until I have 10 Sheets in my file, starting with xx and ending with xx (9).
Now, the next macro comes in: copytonext (Ctrl-d) copies all cell values in the range of the creating sudokus to the next sheet in the file. (As 9 does not have a nex one, I get an error, which does not matter, the cells get copied anyway… go right to the first sheet (xx) and paste everything into cell B1).
then do Ctrl-d again and the cell values get copied into the already formatted sheet for No. 1 etc…
Hm, I’m not sure if this is really understandable… I’ve been using it for so long, it’s just like eating. You just know what you do.
Here’s a semi finished 81 Clueless Explosion, maybe that helps in understanding what I mean.
I think this might be not the most efficient way to do it as it takes me at least 4 hours to solve one of these puzzles and I see that there have been a lot of people submitting before me… but at least it is fun and it helped me to keep track.