View unanswered posts | View active topics It is currently Sat Mar 24, 2018 12:12 am ← Back to the Calcudoku puzzle page

 Page 1 of 1 [ 4 posts ]
 Print view Previous topic | Next topic
A strange fascination with Excel
Author Message

Posted on: Thu Nov 28, 2013 12:00 pm

Posts: 2
Joined: Wed Nov 20, 2013 4:54 am
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.

Posted on: Thu Nov 28, 2013 1:16 pm

Posts: 2258
Joined: Thu May 12, 2011 11:58 pm
Re: A strange fascination with Excel
nicow wrote a solver in Excel (!):
viewtopic.php?p=524#p524

Posted on: Fri Nov 29, 2013 9:37 am

Posts: 2
Joined: Wed Nov 20, 2013 4:54 am
Re: A strange fascination with Excel

Posted on: Sat Nov 30, 2013 5:50 pm

Posts: 66
Joined: Fri May 13, 2011 9:37 am
Re: A strange fascination with Excel
nightsprite wrote:

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.

Display posts from previous:  Sort by
 Page 1 of 1 [ 4 posts ]

 You cannot post new topics in this forumYou cannot reply to topics in this forumYou cannot edit your posts in this forumYou cannot delete your posts in this forum

Search for:
 Jump to:  Select a forum ------------------ English    Announcements    Calcudoku General    Other number stuff    Solving strategies and tips    Specific puzzles / your own puzzles    Timed Puzzles    Bugs and errors    Killer Sudoku    Sudoku Nederlands    Aankondigingen    Calcudoku Algemeen    Oplostips en strategieën Italiano    Calcudoku Generale    Strategie e consigli per risolvere Español    Avisos    Calcudoku - General    Estrategias de solución y aspectos relevantes
All forum contents © Patrick Min, and by the post authors.

Forum software phpBB © 2000, 2002, 2005, 2007 phpBB Group.
Designed by STSoftware.