Boggle game for Excel?

[QUINABA]

Has anyone created this game for Excel?

It's a game where you locate words in a 5 row by 5 column grid of letters where letters forming the words must be adjacent to each other.

Seems like an interesting project.

 

[santeria]

I'm not too familiar with Boggle, but check this link for some Games in Excel... could be Boggle there somewhere, not sure...
Lotsa neat games anyway...

http://www.xl-logic.com/pages/games.html

 

[QUINABA]

Cool site... Not there though, closest game to Boggle is "word finder"(I think, in terms of programming).

You guys think this can be done?

I have the idea in my head but I can't quite put it in code...

I guess the first step is to determine how many possible strings of 25 letters you can get in the 5 rows by 5 columns of letters.

 

[santeria]

Sounds cool.

Keep us posted on what you end up with.

Ta

 

[QUINABA]

I will need a lot of help from you guys...

I'll try to outline the steps on my free time and I'll piece together any solutions I get from you...

This could be a fun project!

Any ideas or codes from anyone that could help is welcome.

 

[XL Pro]

In cells A1:E5, I put in the function:

=CHAR(RANDBETWEEN(CODE("A"),CODE("Z")))

This gives me the 5x5 square of randomized letters. The only problem is there is no algorithm to insure that there are enough vowels being displayed.

 

[chippjm]

I realize this is an older thread and there are Boggle games that are on the internet, but I still think designing/programming an Excel Boggle game is a fun challenge. Unfortunately I'm not a VBA programmer. However, the 16 (4x4) Boggle cubes are listed on http://www-cs-faculty.stanford.edu/~zelenski/boggle/106b_boggle.doc and using that as a 6x16 array I've recreated the cubes. Then use =RAND() next to each "cube". The next column RANKs the random numbers to get a variable order of the cubes. Each "cube" of the 4x4 gameboard is "=INDEX($I$6:$N$21,P6,RANDBETWEEN(1,6))" where "P6" is the ranks (from P6-P20). This generates the random face of each cube in random locations on the board. <F9> will generate a new game board (with Calculations turned to Manual). Now I need help with the other aspects: timer, clearing the words that are entered, checking words with a dictionary. Hopefully this thread gets active again.

 

[XL Pro]

The simplist solution I came up with is the formula I posted previously.

I did eventually write an Excel/VBA version using the Deluxe Boggle set of cubes (5 x 5, 25 cubes). If anyone is interested in it, I can certainly provide it via email (unless some else wants to host it).

 

[santeria]

Yes, I am interested.
I put the previous code of =CHAR(RANDBETWEEN(CODE("A"),CODE("Z")))
into the cells ( in Office 2003 ), and all I got was "#NAME?" in all cells.
Work for sudoko or Sudoku ?

Ta

The simplist solution I came up with is the formula I posted previously.

I did eventually write an Excel/VBA version using the Deluxe Boggle set of cubes (5 x 5, 25 cubes). If anyone is interested in it, I can certainly provide it via email (unless some else wants to host it).

 

[XL Pro]

My bad! RANDBETWEEN() is part of the Analysis Toolpak. Make sure you have that add-in installed/selected.

PM me with your email addy and I'll send you my boggle program.