So I made an Encounter Builder and Monster Index

[gunrock82]

This will be a very useful tool

 

[smartmonkey]

Thanks for the kind words y'all. The builder is more or less feature complete for what I have in mind - I would like to work on some aesthetics, if folk have any suggestions. Otherwise, the next big revision will be when we get additional guidelines for treasure or other tweaks to the encounter system.

 

[Emirikol]

Good work.

A randomizer function would be really handy for creating groups of monsters. Example: 1 orc, and 3 goblins..appropriate for 'x' encounter.

If you want to use any of my excel coding from my projects, here are three of them:

https://dl.dropboxusercontent.com/u...tor/WFRP3 Random Character Generator 2.8.xlsx

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

https://dl.dropboxusercontent.com/u/167876/D&D Stuff/D&D 5e Random Character Generator 1.0.xlsx

 

[Mistwell]

The real question is can it be turned into an OGRE app?

 

[smartmonkey]

Good work.

A randomizer function would be really handy for creating groups of monsters. Example: 1 orc, and 3 goblins..appropriate for 'x' encounter.

If you want to use any of my excel coding from my projects, here are three of them:

https://dl.dropboxusercontent.com/u...tor/WFRP3 Random Character Generator 2.8.xlsx

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

https://dl.dropboxusercontent.com/u/167876/D&D Stuff/D&D 5e Random Character Generator 1.0.xlsx

I might take you up on that! I'm trying to avoid too much calculation, just because I don't want to have to turn autocalc off - do your scripts dodge the RAND() function?

 

[Emirikol]

I've been using simple RANK, VLOOKUP, and RANDBETWEEN (1,whatever) for the majority. I've only done cursory work on encounter design (using WFRP3's monster difficulty rating), and didn't have a lot of luck yet. It's essentially identical to D&D's except that there are no fractions. Here is the link to that: https://dl.dropboxusercontent.com/u...ncounter total threat level monsters 1.0.xlsx


For everything else
I have as many pages as I like to conveniently sort things.

I create a dump page (like a sloppy character sheet showing the work) and then a true display page that looks pretty.

If you wanted both a random and a calculation (manual) page, that would be easy as well.

I've not messed around with drop-down boxes, but that would be ideal.

btw, I rarely use the RAND() function b/c it doesn't give me an integer..so I only use it for true randomization (such as I did with the character ability scores to generate random SORTing). I use the RANDBETWEEN, because I can set the second number to whatever I want remotely as well.

jh

 

[SidSad]

I might take you up on that! I'm trying to avoid too much calculation, just because I don't want to have to turn autocalc off - do your scripts dodge the RAND() function?

I don't like turning the autocalc off either. I wonder if there's a way to stop only an area of the sheet from autocalculating. I integrated a little dice roller in my version of a DM Tools spreadsheet. Choose the type of dice and how many, useful for that combat with the whole town fighting the dragon...

I'm thinking about doing an index with all the monsters from the DMBasics for the Encounter Builder.

 

[smartmonkey]

Thanks for the input! I'm going to start playing around with RANK eventually. I'd like to be able to include a random encounter and a treasure generator eventually.

I've added a field that generates XP per PC for any given encounter. It was pretty obvious but it didn't occur to me to throw it in there until someone on RPG.net suggested it. I'm considering adding a house rule to award building XP instead of the only monsters XP. After all, a fight with more critters is harder, right? Why shouldn't it be worth proportionally more XP?

In other news I'm going to be out of town at a wedding this next week. I'll check around for comments, but I won't be able to update the sheet until I return on the 27th.

Cheers,

MG

EDIT

I'm thinking about doing an index with all the monsters from the DMBasics for the Encounter Builder.

You did see the Monster Index tab right? I'm planning on keeping it as current as I can once the MM/other supplements come out. I'm only including type/CR to avoid having to worry about getting in trouble for reproducing material from the books - and besides, this is about supplementing the books and making games run quicker.

Anyhow!

 

[Boarstorm]

Thanks! This'll be quite useful. I've already used it to sort out beasts by CR for the party druid.

 

[eluj]

Awesome spreadsheet, thanks for sharing.

It might be nice to have room for multiple encounters within the same sheet.

Thanks