Random Adventure Generator (Excel) - [WFRP origination..use for any fantasy inspiration)

[Emirikol]

I did up a random adventure generator in excel. It is simply based on WFRP3, but can pretty much be used for any fantasy game any time you are stuck. Enjoy:
https://dl.dropboxusercontent.com/u/167876/WFRP%20STUFF/Random%20WFRP3%20Adventure%20Generator/Random%20WFRP3%20Adventure%20Output%201.1.xlsx

jh

 

[2die10games]

this is really cool

 

[Emirikol]

Thanks. These things are surpiringly easy to set up. It's just a couple random statements, table look-ups and and very few IF-then's.

jh

 

[Emirikol]

For any of you wanting to make your own in excel, feel free to adapt mine.

You can look up how to do any of those 3 functions by googling it.

First thing to learn:
Roll random number in box A-1 example d6: =randbetween(1,6)

Next:
make chart of 1-6 in boxes A2-7 and in B2-7 the monster. Example:
1 Goblin
2 Orc
3 Kobold
4 Bugbear
5 Lizardman
6 Gnoll


Last, how to get a result of your random number from that chart:
=vlookup(a1,A2-7:B2-7,2,FALSE)

a1 is your roll
a2-b7 is your chart
"2" is the column that you reference
"False" means that it will show "FALSE" if there is an error


Hit "F9" to roll again.

IF you use GOOGLE DOCS (Spreadsheet) the RE-ROLL is "CONTROL-R"

Try it out!


jh

 

[Emirikol]

Upgraded to ver 1.2..now includes other stuff

https://dl.dropboxusercontent.com/u...erator/Random WFRP3 Adventure Output 1.2.xlsx