"Black Dougal gasps 'Poison!' and falls to the floor. He looks dead."

Sunday, March 10, 2013

Wilderness Hex Stocking

I am currently stocking a wilderness hex map. It is 20 hexes by 20 hexes numbered 0 to 19 in each direction.

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:


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

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

    1 | 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:

    That should do it.

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

  3. Thanks 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?

  4. if you put:
    into a cell, will it give you a number?

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

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

    So 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.