LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
Albie
 
Posts: n/a
Default Kakuro Puzzle Solver Question

I am trying to create a model to solve a Kakuro puzzle, see www.kakuro.net
for information on the puzzle, but it is very simlar in nature to a Sudoku
puzzle with some minor difference. It is a puzzle where rows and columns
must add to a specified value, it out repeating the digit. For example, if
two cells must sum to 6, the choices are 1:5, 2:4 (3:3 is not an option
because the two cells would be equal). I have been able to set up a system
of equations that modle all of the cells, the the sums that rows or columns
must equal.

where I run in to issue is making sure that in a set of number on value
repeats, I have been able to use Delta() and =--(a5=a3) to determine if the
cells are equal or not, but when I put them into the solver constraints, my
results go from almost perfect to all 1's.

Any thoughts?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Solver question Mick Excel Discussion (Misc queries) 0 April 21st 06 05:33 PM
Solver Question Greg Toews Excel Worksheet Functions 3 March 20th 06 01:43 PM
Solver question Bill_S Excel Worksheet Functions 1 February 2nd 06 06:38 PM
Solver parameter constraint question Morrigan Excel Discussion (Misc queries) 7 June 7th 05 10:01 PM
question on excel Solver Avalon Excel Worksheet Functions 1 May 1st 05 05:35 PM


All times are GMT +1. The time now is 12:32 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"