Calcudoku puzzle forum
https://www.calcudoku.org/forum/

A strange fascination with Excel
https://www.calcudoku.org/forum/viewtopic.php?f=3&t=501
Page 1 of 1

Author:  nightsprite  [ Thu Nov 28, 2013 12:00 pm ]
Post subject:  A strange fascination with Excel

Hi There,

I discovered these puzzles in my local paper, titled Hitoshi and Killer Sudoku puzzles, which didn't really explain themselves to well. In search of answers on how these puzzles work I went in search of answers which led me here!
I've been hooked since and will be subscribing soon

I have written up multiplication and addition tables on scraps of paper and I'm hooked.

Now, I have a weird fascination with the old excel and love writing up tables and formulas for everything from my budget to recipes! I'm always teaching myself to write up new things.

I am rather curious to know if there is a resource that would allow me to write up a spreadsheet that would make answering these puzzles easier. Please be aware that the answering of the puzzles is secondary to writing up a new excel spreadsheet. I'm a strange fish, I know. I'm not looking for a pre-written spreadsheet to download or something to just cut and paste. I want to be able to type stuff in and see how stuff connects.

Many thanks for your indulgence in my madness.

Author:  pnm  [ Thu Nov 28, 2013 1:16 pm ]
Post subject:  Re: A strange fascination with Excel

nicow wrote a solver in Excel (!):
viewtopic.php?p=524#p524

Author:  nightsprite  [ Fri Nov 29, 2013 9:37 am ]
Post subject:  Re: A strange fascination with Excel

Ermm, yeah, I did read that and had to scratch my head. Might have to ask for a script! Or a translation! :-)

Author:  nicow  [ Sat Nov 30, 2013 5:50 pm ]
Post subject:  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.

Page 1 of 1 All times are UTC + 1 hour [ DST ]
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group
http://www.phpbb.com/