View unanswered posts | View active topics It is currently Tue Nov 21, 2017 7:27 pm



← Back to the Calcudoku puzzle page




Reply to topic  [ 4 posts ] 
 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
Post 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.


Profile
User avatar

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




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


Profile

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




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


Profile

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




Posts: 66
Joined: Fri May 13, 2011 9:37 am
Post 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.


Profile
Display posts from previous:  Sort by  
Reply to topic   [ 4 posts ] 

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

Search for:
Jump to:  
All forum contents © Patrick Min, and by the post authors.

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