View Full Version : WHQ Treasure Generator

21-03-2013, 16:21
Hi all. I recently made a warhammer quest set for myself, and after a few games we have come across some problems.

The game is great, but relies on a lot of rolling for random events and treasures - I'm using the lists from Here (http://wquest.free.fr/rules/rul_109.htm) rather than cards since I don't have any. The tables also have a bunch of extra bits.

However, the down side is that there is a lot of 'roll, roll, flip pages, roll, flip pages' which slows things down.

So I made a treasure table generator in Excel. Currently it only does regular treasure, but it shouldn't be long before I have everything included.

You can get it here:

The file is macro enabled, but the only macro is to hit the 'GIVE ME TREASURE!' button to press Shift+Control+F9 at the same time to refresh the page. You can of course get by without that convenience.

Feedback appreciated.

And done! https://docs.google.com/file/d/0B4Ha0RiPWRfUMHoxb01tdTRSa00/edit?usp=sharing

21-03-2013, 21:34
Kewl beans just ditch the forbidden Rod in that table it breaks the wizard WIDE open. Trust me at level ten its hilarious for the first quest...

22-03-2013, 07:11
Very cool, I appreciate the effort that went into this!

23-03-2013, 03:34
Thanks guys, I hope it's useful.

I also made a blank version with instructions if anyone wants to make their own tables. It should be as simple as writing/pasting the text into the sheet.

I thought it could be used for custom settlement events, dungeon events and so on.

By picking your start and end values you can use one massive list and choose sections of it to roll on. So swapping from a custom level 1 monster chart with 50 entries to a custom level 2 chart would be as easy as using '1' and '50' or '51 and '100'.

If you wanted to have random numbers of monsters spawn, or gold etc. You can use the excel forumula "=RANDBETWEEN(x,y)" in your table list. This will then appear as a number on the front page when you press 'Roll' and be updated each time.


23-03-2013, 10:41
Hi, cheers for this. I've just had a quick play about with it and it looks great!

A question if I may. Is there a way of doing the random number generator per unit rather than seperate, because, for example, some monsters such as Minotaurs you get D3 of (1-3) whilst others are 2D6 (2-12)? I don't think the warriors would appreciate 12 Minotaurs turning up!

I have been after something like this for ages so thank you very much for providing it!


EDIT: Never mind, I've figured it out!

23-03-2013, 16:15
Assuming you only want the contents of the WHQ rulebook, for events and monsters, this is probably better: http://www.binkystick.com/eventdeck/

It includes rules and a fancy card to click :)

Glad I could help!