Re: A strange fascination with Excel
nightsprite wrote:
Ermm, yeah, I did read that and had to scratch my head. Might have to ask for a script! Or a translation!
VBA scripts are only for convenience, and for checking and searching.
Inputting a puzzle is easy with the minimum of key strokes.
Calculating the solution is only done by excel formulae.
When a solution not is found using in advance logic, a script starts.
Than a stack of combinations to be tried is calculated by excel itself, using excel formulae. So the script is as simple as possible.
My aim and fun is to build a spreadsheet that does most of the work, and to minimize the role of scripts.