I have mentioned in the past that I stock wilderness hexes in the same manner as I stock dungeon rooms. Each hex is treated as a "room" and I roll on the table in section E "Stock the Dungeon" on page B52.

Instead of rolling 400 d6's I set up a simple random number generator in each cell of a 20 by 20 cell spreadsheet in excel with a vlookup function that referred to a table that matched the one on page B52.

Below are the very high level contents of my 400 hexes:

Great tool! Can you share the Spread sheet or the Vlook formula?

ReplyDeleteCells A1 to B6 put a version of the table on page B52 so it looks sort of like this:

ReplyDelete1 | Monster

2 | Monster

3 | Trap/Obstacle

4 | Special

5 | Empty

6 | Empty

Then in all of the cells that represent you hexes put the formula:

=vlookup(randbetween(1,6),$A$1:$B$6,2,false)

That should do it.

Beautiful, thanks very much for sharing! I think I see an entire hexploration spread sheet construction in the near future!

DeleteThanks for the idea, it certainly will make hex stocking easier if I get the formula to work. I keep getting an NA error in the target cell and when I run help its the randbetween that is causing the error? how do I change the number it looks up into text monster/special etc in the new cell?

ReplyDeleteif you put:

ReplyDelete=randbetween(1,6)

into a cell, will it give you a number?

Aye the randbetween bit works fine on its own, but when combined with vlookup, it doesn't do owt but error?

ReplyDeleteSorry, I don't know what would be causing that.

ReplyDeleteSo long as the "$A$1:$B$6" references the table, the randbetween should generate a number from 1 to 6 and the vlookup should look up the random number in the first column of the table and return the corresponding result from the second column.